Fork of
Untitled query #66432
by MusikAnimal
This query is marked as a draft
This query has been published
by MPGuy2824.
SQL
AخA
SELECT ROW_NUMBER(), actor_name AS `Reviewer`,
COUNT(IF(logtemp.page_is_redirect = 0, 1, NULL)) as `Article Reviews`
FROM (
SELECT distinct log_actor, log_page, page_is_redirect
FROM logging_userindex
JOIN page ON page_title = log_title AND page_namespace = log_namespace
WHERE log_timestamp BETWEEN 20220101000000 AND 20230101000000
AND
((log_type = 'patrol' AND log_action = 'patrol') OR
(log_type = 'pagetriage-curation' AND log_action = 'reviewed'))
AND log_namespace = 0
) logtemp
JOIN actor ON actor_id = log_actor
GROUP BY Reviewer
having `Article Reviews`>=100
ORDER BY `Article Reviews` DESC
limit 20;
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.