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

        AND year(log_timestamp ) = 2024

) logtemp

JOIN actor ON actor_id = log_actor

GROUP BY Reviewer

having `Redirect reviews`>=50

ORDER BY `Redirect reviews` DESC