Replicas browser and optimizer
Top new page reviewers (2017-05-19 to 2017-06-19)
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(log_id) AS `reviews` FROM logging WHERE log_timestamp BETWEEN 20180109160000 AND 20180110160000 AND log_namespace = 0 AND ( ( log_type = 'patrol' AND log_params NOT LIKE '%::auto";i:1%' ) 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