SELECT 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

        AND log_timestamp <20240701000000

) logtemp

JOIN actor ON actor_id = log_actor

GROUP BY Reviewer

ORDER BY `Redirect Reviews` DESC

LIMIT 50;