Top New NPP reviewers (September 2023)

SQL

SELECT  actor_name AS `Reviewer`, 
        COUNT(IF(logtemp.page_is_redirect = 0, 1, NULL)) as `Article Reviews`,
        COUNT(IF(logtemp.page_is_redirect = 1, 1, NULL)) as `Redirect Reviews`,
        SUM(IF(logtemp.page_is_redirect = 1, 0.25, 1)) as `Weighted 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 YEAR(log_timestamp)=2023 and MONTH(log_timestamp)=9
        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
where actor_name in ("Alalch E.", "AlexandraAVX", "BeanieFan11", "Ca", "ClydeFranklin", "CycloneYoris", "Dudhhr", "FatalFit", "Festucalex",
                     "Fork99", "Freedom4U", "IceBergYYC", "Isochrone", "Layah50", "Lightburst", "Lightoil", "LittlePuppers", "Maliner",
                     "Mdewman6", "Oaktree b", "Owais Al Qarni", "Paul Vaurie", "Shelovesneo", "Skynxnex", "TartarTorte", "True Pagan Warrior")
GROUP BY Reviewer
ORDER BY `Weighted reviews` DESC
limit 20;
SQL

Checking query status...
