7 day reviewers total Jan 1st-Jan7th TEST

7 day reviewers total Jan 1st-Jan7th 

(if you are wondering about the weird times, it is because it is updated from my local time zone of UTC plus 13 hours, so I have to subtract 13 hours from the date/times)

SQL

SELECT logtemp.log_user_text AS `reviewer`,
COUNT(DISTINCT(logtemp.log_page)) AS `reviews`
FROM (
  SELECT log_user_text, log_page
  FROM logging_userindex
  WHERE log_timestamp BETWEEN 20161231110000 AND 20170107110000
  AND log_type = 'patrol'
  AND log_action = 'patrol'
  AND log_namespace = 0
  UNION
  SELECT log_user_text, log_page
  FROM logging_userindex
  WHERE log_timestamp BETWEEN 20161231110000 AND 20170107110000
  AND log_type = 'pagetriage-curation'
  AND log_action = 'reviewed'
  AND log_namespace = 0
) logtemp
GROUP BY reviewer
ORDER BY reviews ASC;

SQL

Checking query status...