SQL
AخA
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 20180108000000 AND 20180115000000
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 20180108000000 AND 20180115000000
AND log_type = 'pagetriage-curation'
AND log_action = 'reviewed'
AND log_namespace = 0
) logtemp
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.