Unique new page reviewers by month

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 patrollers
FROM logging_logindex
WHERE log_timestamp BETWEEN 20151201000000 and 20170501000000
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...