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
JOIN pagetriage_page ON rev_page = ptrp_page_id 
JOIN page ON page_id = rev_page 
JOIN actor ON rev_actor = actor_id
WHERE
TRUE
AND rev_parent_id = 0
AND ptrp_reviewed = 1
#AND ptrp_reviewed_updated = 1
AND page_namespace = 0
AND page_is_redirect = 0
-- AND actor_user NOT IN (SELECT ug_user FROM user_groups WHERE ug_group = 'reviewer')
GROUP BY rev_actor
HAVING COUNT(rev_id) >= 5
ORDER BY COUNT(rev_id) DESC;
SQL

Checking query status...
