"Good article" review pages - users and counts (last 30 days)

Useful to see who has been doing a lot of good article reviews in the last month. Includes the reviewees (which is not ideal). Only checks last 30 days (not ideal) because queries on the recentchanges table are a lot quicker than queries on the billion row revision table.

SQL

SELECT ROW_NUMBER() OVER(ORDER BY COUNT(*) DESC) AS rank,
	actor_name,
	(
      	SELECT COUNT(*)
        FROM page
        JOIN recentchanges_userindex ON page_id = rc_cur_id
        JOIN actor_recentchanges ON actor_id = rc_actor
        WHERE page_namespace = 1
            AND page_title LIKE '%/GA%'
      		AND actor_id = actor_id
        GROUP BY actor_name
    ) AS count1
FROM page
JOIN recentchanges_userindex ON page_id = rc_cur_id
JOIN actor_recentchanges ON actor_id = rc_actor
WHERE page_namespace = 1
	AND page_title LIKE '%/GA%'
GROUP BY actor_name
ORDER BY count1 DESC

SQL

Checking query status...