SELECT actor_name AS `reviewer`,

    sum(case when logtemp.page_is_redirect = 0 then 1 else 0 end) as `Article Reviews`,

    actor_user

FROM (

    SELECT log_actor, log_page, page_is_redirect

    FROM logging_userindex

    JOIN page ON page_title = log_title AND page_namespace = log_namespace

    WHERE log_timestamp BETWEEN 20210101000000 AND 20220101000000

    AND log_type = 'patrol'

    AND log_action = 'patrol'

    AND log_namespace = 0

    UNION

    SELECT log_actor, log_page, page_is_redirect

    FROM logging_userindex

    JOIN page ON page_title = log_title AND page_namespace = log_namespace

    WHERE log_timestamp BETWEEN 20210101000000 AND 20220101000000

    AND log_type = 'pagetriage-curation'

    AND log_action = 'reviewed'

    AND log_namespace = 0

) logtemp

JOIN actor ON actor_id = log_actor

JOIN user ON actor_user = user_id

LEFT JOIN ipblocks ON ipb_user = user_id AND ipb_sitewide = 1

WHERE ipb_id IS NULL

GROUP BY reviewer

HAVING `Article Reviews` >= 100

ORDER BY `Article Reviews` DESC

LIMIT 101