New Page Reviewers eligible for barnstars - 2021(articles) - hide blocked

SQL

SELECT sq.reviewer, sq.`Article Reviews`
FROM (
    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
	GROUP BY reviewer
	HAVING `Article Reviews` >= 100
	ORDER BY `Article Reviews` DESC
	LIMIT 101
) AS sq
SQL

Checking query status...
