Page curation actions per month by type

This query is marked as a draft This query has been published by Jtmorgan.

Last run 25 May 2017

Number of NPP actions per month, by type, in main namespace in the 12 months before and six months after the `patrol` userright was created (https://phabricator.wikimedia.org/T149019)

SQL

SELECT EXTRACT(YEAR FROM DATE_FORMAT(log_timestamp,'%Y%m%d%H%i%s')) AS `year`, 
EXTRACT(MONTH FROM DATE_FORMAT(log_timestamp,'%Y%m%d%H%i%s')) AS `month`, count(log_id) as review_actions, log_action
from logging WHERE log_namespace = 0 and log_type='pagetriage-curation' AND log_timestamp between 20151201000000 and 20170501000000
GROUP BY `year`, `month`, log_action 
ORDER BY `year` ASC, `month` ASC, log_action ASC;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...