Replicas browser and optimizer
Page curation reviewers per month
This query is marked as a draft
This query has been published
Last run 22 May 2017 Total number of NPP reviewers per month in the twelve months before and six months after the `patrol` userright was created (https://phabricator.wikimedia.org/T149019)
SELECT CONCAT(LEFT(log_timestamp, 6), "01") AS month, COUNT(log_id) AS actions, SUM(log_action = "delete") AS deletions, SUM(log_action = "reviewed") AS reviews, SUM(log_action = "unreviewed") AS unreviews, SUM(log_action = "tag") AS taggings FROM logging WHERE log_type='pagetriage-curation' AND log_timestamp between "20151201" and "20170501" GROUP BY month;
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