New Page Reviewer activity since January 1st 2018 (excluding admins)

SQL

SELECT user_name AS `reviewer`
FROM `user`
WHERE EXISTS (SELECT 1 FROM user_groups WHERE user_id=ug_user AND ug_group = 'sysop') -- administrator
OR EXISTS (SELECT 1 FROM user_groups WHERE user_id=ug_user AND ug_group = 'patroller') -- new page patroller
UNION
SELECT DISTINCT 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 20161100000000 AND NOW()
  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 20161100000000 AND NOW()
  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...