NPP - total reviews split by articles and redirects over various time periods

SQL

SELECT actor_name AS `Reviewer`,
      COUNT(DISTINCT(logtemp.log_page)) AS `Total`,
	  sum(case when logtemp.page_is_redirect = 0 then 1 else 0 end) as `Articles`
      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 20211101000000 AND 20221101000000
        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 20211101000000 AND 20221101000000
        AND log_type = 'pagetriage-curation'
        AND log_action = 'reviewed'
        AND log_namespace = 0
      ) logtemp
      JOIN actor ON actor_id = log_actor
      GROUP BY Reviewer
      ORDER BY Total DESC
      LIMIT 10;
SQL

Checking query status...
