Reviews of RfD-ed redirects during October 2023

Fork of Reviews of RfD-ed redirects during October 2023 by Illusion Flame

This query is marked as a draft This query has been published by Illusion Flame.

SQL

SELECT  actor_name AS `Reviewer`, 
        COUNT(IF(logtemp.page_is_redirect = 0, 1, NULL)) as `Articles`,
        COUNT(IF(logtemp.page_is_redirect = 1, 1, NULL)) as `Redirects`
      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
        join categorylinks as articleC on articleC.cl_from=page_id
        WHERE YEAR(log_timestamp)=2023 and MONTH(log_timestamp)=10
        and articleC.cl_to = "Redirects_for_discussion_from_October_2023"
        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
ORDER BY `Articles` DESC;

SQL

Checking query status...