SQL
AخA
# users with 5 or more unreviewed articles
SELECT rev_actor, actor_name, COUNT(rev_id) articles
FROM 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 rev_parent_id = 0
AND ptrp_reviewed = 1
#AND ptrp_reviewed_updated = 1
AND page_namespace = 0
AND page_is_redirect = 0
GROUP BY rev_actor
HAVING COUNT(rev_id) >= 5
ORDER BY COUNT(rev_id) DESC;
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.