Untitled query #81902

SQL

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
        WHERE YEAR(log_timestamp)=2018 and month(log_timestamp)=1
        AND 
        ((log_type = 'patrol'  AND log_action = 'patrol') OR
         (log_type = 'pagetriage-curation' AND log_action in ('reviewed', 'reviewed-redirect')))
        AND log_namespace = 0
      ) logtemp
      JOIN actor ON actor_id = log_actor
      where NOT EXISTS (
            	SELECT 1 FROM logging_logindex
                WHERE actor_name = log_title
                AND log_namespace = 2
                AND log_type = 'block' AND log_action = 'block'
        )
      GROUP BY reviewer
      HAVING `Redirect Reviews` >= 100
      ORDER BY `Redirect Reviews` DESC
      limit 100;
SQL

Checking query status...
