Top non-admin new page reviewers

SQL

SELECT logtemp.log_user_text AS `reviewer`, logtemp.log_user,
COUNT(DISTINCT(logtemp.log_page)) AS `reviews`
FROM (
  SELECT log_user_text, log_page, log_user
  FROM logging_userindex
  WHERE log_timestamp BETWEEN 20161100000000 AND NOW()
  AND log_type = 'patrol'
  AND log_action = 'patrol'
  AND log_namespace = 0
  UNION
  SELECT log_user_text, log_page, log_user
  FROM logging_userindex
  WHERE log_timestamp BETWEEN 20161100000000 AND NOW()
  AND log_type = 'pagetriage-curation'
  AND log_action = 'reviewed'
  AND log_namespace = 0
) logtemp
WHERE NOT EXISTS
(
  SELECT 1
  FROM user_groups
  WHERE ug_user = log_user
  AND ug_group = 'sysop'
)
GROUP BY reviewer
ORDER BY reviews DESC;
SQL

Checking query status...
