Page curation unreview actions per month - Quarry

Fork of Page curation actions per month by type by Jtmorgan

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

Last run 22 May 2017

Number of NPP unreview actions per month, by type, in the twelve 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 unreviews
from logging WHERE log_type='pagetriage-curation' AND log_action = 'unreviewed' and log_timestamp between 20151201000000 and 20170430000000
GROUP BY `year`, `month`
ORDER BY `year` ASC, `month` ASC;

AخA
 
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 unreviewsfrom logging WHERE log_type='pagetriage-curation' AND log_action = 'unreviewed' and log_timestamp between 20151201000000 and 20170430000000GROUP BY `year`, `month`ORDER BY `year` ASC, `month` 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.

Checking query status...