Replicas browser and optimizer
This query is marked as a draft
This query has been published
# 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 = 0 #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
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in