Untitled query #19320

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(DISTINCT log_user) AS `unique_reviewers`,
       COUNT(log_page) AS `pages_reviewed`
FROM logging
WHERE log_timestamp BETWEEN 20150101000000 AND 20170601000000
AND log_namespace = 0
AND (
  (
    log_type = 'patrol'
    AND log_params NOT LIKE '%::auto";i:1%'
  ) OR (
    log_type = 'pagetriage-curation'
    AND log_action = 'reviewed'
  )
)
GROUP BY `year`, `month`
ORDER BY `year` ASC, `month` ASC;
SQL

Checking query status...
