SELECT RANK() OVER (ORDER BY `Articles reviews` DESC) AS `No`, actor_name AS `Reviewer`,

      COUNT(IF(logtemp.page_is_redirect = 0, 1, NULL)) as `Articles reviews`,

      IF(ipb_sitewide = 1, 'yes', 'no') as 'Blocked'

      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-article' )))

        AND log_namespace = 0

        AND log_timestamp <20250101000000

) logtemp

JOIN actor ON actor_id = log_actor

LEFT JOIN ipblocks ON ipb_user = actor_user AND ipb_sitewide = 1

GROUP BY Reviewer

ORDER BY `Articles reviews` DESC

LIMIT 100;