NPP - Top reviewers all time (redirects)

Fork of Top NPP reviewers (articles only) for 2022 by Hey man im josh

This query is marked as a draft This query has been published by Hey man im josh.

SQL

SELECT RANK() OVER (ORDER BY `Redirect Reviews` DESC) AS `No`, actor_name AS `Reviewer`,
      COUNT(IF(logtemp.page_is_redirect = 1, 1, NULL)) as `Redirect 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
        AND 
        ((log_type = 'patrol'  AND log_action = 'patrol') OR
         (log_type = 'pagetriage-curation' AND log_action in ( 'reviewed', 'reviewed-redirect' )))
        AND log_namespace = 0

) logtemp
JOIN actor ON actor_id = log_actor
GROUP BY Reviewer
ORDER BY `Redirect Reviews` DESC
LIMIT 50;

SQL

Checking query status...