21,893
社区成员




SELECT au.user_id, count(u.workno) AS tjs
FROM ecs_users AS u, ecs_admin_user AS au
WHERE au.workno = u.workno
AND au.action_list LIKE '%user_sales%'
GROUP BY au.user_id
SELECT au.user_id, count(u.workno) AS tjs
FROM ecs_admin_user AS au LEFT JOIN ecs_users AS u
ON au.workno = u.workno GROUP BY au.user_id
SELECT au.user_id, count(u.workno) AS tjs
FROM ecs_admin_user AS au LEFT JOIN ecs_users AS u
ON au.workno = u.workno AND au.action_list LIKE '%user_sales%'
GROUP BY au.user_id