|
|
|
|
|
|
|
|
|
|
274Table 'SDL_WEB.user_point_2022' doesn't exist
Err : SELECT U.sUserId , U.sUserName, SUM(P.iTotal) AS iTotalPoint FROM users U
INNER JOIN centers C ON C.id=U.center_id
INNER JOIN user_point_2022 P ON U.id=P.user_id
WHERE
P.group_id='2' AND
P.iMonth='01' AND
U.eUserType='S'
GROUP BY U.id
ORDER BY iTotalPoint DESC LIMIT 5
| |
