SQL
x
-- select reviewer, min(m11, m12) as m
-- from (
SELECT actor_name AS `Reviewer`,
SUM(CASE WHEN month = 11 THEN 1 ELSE 0 END) AS m11,
SUM(CASE WHEN month = 12 THEN 1 ELSE 0 END) AS m12,
least(VALUES (m11), VALUES(m12)) AS minimum
FROM (
SELECT distinct log_actor, log_page, page_is_redirect, MONTH(log_timestamp) as month
FROM logging_userindex
JOIN page ON page_title = log_title AND page_namespace = log_namespace
WHERE YEAR(log_timestamp)=2023 and MONTH(log_timestamp)>10
AND
((log_type = "patrol" AND log_action = "patrol") OR
(log_type = "pagetriage-curation" AND log_action in ("reviewed", "reviewed-article")))
AND log_namespace = 0
) logtemp
JOIN actor ON actor_id = log_actor
JOIN user ON actor_user = user_id
left JOIN ipblocks ON ipb_user = user_id
where ipb_sitewide IS NULL
and logtemp.page_is_redirect = 0
GROUP BY reviewer
-- )
-- order by m 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.