SQL
AخA
use enwiki_p;
SELECT log_user_text,
COUNT(DISTINCT log_page) AS `reviews`
FROM logging
WHERE log_timestamp BETWEEN 20170519000000 AND 20170619000000
AND log_namespace = 0 AND
(
(
log_type = 'patrol'
AND log_action = 'patrol'
) OR (
log_type = 'pagetriage-curation'
AND log_action = 'reviewed'
)
)
GROUP BY log_user_text
ORDER BY 2 DESC;
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.