SQL
AخA
SELECT DISTINCT log.log_user_text AS `reviewer`, COUNT(DISTINCT(log.log_page)) AS `reviews`
FROM logging_userindex AS log
LEFT JOIN user_groups AS ugroups ON (log.log_user = ugroups.ug_user)
WHERE log.log_timestamp BETWEEN 20161100000000 AND NOW()
AND ( (log.log_action = 'patrol') OR (log.log_action = 'reviewed') )
AND ugroups.ug_group NOT RLIKE "sysop"
AND log.log_namespace = 0
GROUP BY reviewer
ORDER BY reviews ASC;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.