SQL
AخA
USE plwiki_p;
SELECT user_name, ug_group, COUNT(user_name) AS counting
FROM user
LEFT OUTER JOIN actor ON actor_user = user_id
LEFT OUTER JOIN user_groups ON ug_user = actor_user
WHERE actor_user IS NOT NULL
AND (ug_group LIKE 'autoreview' AND ug_group LIKE 'editor')
GROUP BY user_name
LIMIT 300;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.