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

SQL

SELECT logtemp.log_user_text AS `reviewer`,
COUNT(logtemp.log_page) AS `reviews`
FROM (
SELECT log_user_text, COUNT(*)
FROM logging
JOIN user_groups ON ug_user = log_user
WHERE log_timestamp BETWEEN 20180100000000 AND NOW()
AND log_type = 'pagetriage-curation'
AND log_action = 'reviewed'
AND ug_group = 'patroller'
AND log_namespace = 0
UNION
SELECT log_user_text,
FROM logging
JOIN user_groups ON ug_user = log_user
WHERE log_timestamp BETWEEN 20180100000000 AND NOW()
AND log_type = 'patrol'
AND log_action = 'patrol'
AND ug_group = 'patroller'
AND log_namespace = 0
) logtemp
GROUP BY log_user_text
ORDER BY COUNT(*) DESC

SQL

Checking query status...