Page curation actions per month by type

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;

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 review_actions, log_actionfrom logging WHERE log_namespace = 0 and log_type='pagetriage-curation' AND log_timestamp between 20151201000000 and 20170501000000GROUP BY `year`, `month`, log_action ORDER BY `year` ASC, `month` ASC, log_action ASC;  

SQL

Checking query status...