SELECT actor_name AS `Reviewer`, month,

      COUNT(IF(logtemp.page_is_redirect = 0, 1, NULL)) as `Article Reviews`

      FROM (

        SELECT distinct log_actor, log_page, page_is_redirect, MONTH(log_timestamp) as month

        FROM logging_userindex

        JOIN page ON page_title = log_title AND page_namespace = log_namespace

        WHERE YEAR(log_timestamp)=2022

        AND 

        ((log_type = 'patrol'  AND log_action = 'patrol') OR

         (log_type = 'pagetriage-curation' AND log_action in ('reviewed', 'reviewed-article')))

        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

      where ipb_sitewide IS NULL

      GROUP BY reviewer, month

      HAVING `Article Reviews` >= 100

      ORDER BY `Article Reviews` DESC

      limit 100;