AC Gaming Weekdays

SQL

# users with 5 or more unreviewed articles
SELECT rev_actor, actor_name, COUNT(rev_id) articles
FROM revision_userindex AS revision
INNER JOIN pagetriage_page ON rev_page = ptrp_page_id 
INNER JOIN page ON page_id = rev_page 
INNER JOIN actor ON rev_actor = actor_id
INNER JOIN user ON actor_user = user_id
WHERE
TRUE
AND rev_parent_id = 0
AND ptrp_reviewed IN (1, 3)
AND page_namespace = 0
AND page_is_redirect = 0
AND actor_user NOT IN (SELECT ug_user FROM user_groups WHERE ug_group = 'reviewer')
AND user_registration < "20180101000000" 
GROUP BY rev_actor
HAVING COUNT(rev_id) >= 5
-- ORDER BY COUNT(rev_id) DESC;
ORDER BY user_registration ASC;
SQL

Checking query status...
