Replicas browser and optimizer
New page reviews by month
This query is marked as a draft
This query has been published
This includes any means of marking a page as patrolled (aka reviewed), either with Page Curation, Twinkle, manually, etc.
SELECT log_user_text AS `reviewer`, COUNT(DISTINCT(log_page)) AS `reviews` FROM enwiki_p.logging_userindex WHERE log_timestamp BETWEEN 20170519000000 AND 20170619000000 AND log_namespace = 0 AND ( ( log_type = 'patrol' AND log_action = 'patrol' ) OR ( log_type = 'pagetriage-curation' AND log_action = 'reviewed' ) ) GROUP BY reviewer ORDER BY reviews 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