Replicas browser and optimizer
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 COUNT(DISTINCT(log_page)) AS `reviews` FROM enwiki_p.logging_userindex WHERE log_timestamp BETWEEN 20180109160000 AND 20180112000000 AND log_namespace = 0 AND ( ( log_type = 'patrol' AND log_action = 'patrol' ) OR ( log_type = 'pagetriage-curation' AND log_action = 'reviewed' ) )
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