zhwiki RFX Eligible Voters #1: Recent Edits

SQL

/* 495 rows before 90-day test; 50.24 seconds */
SELECT tmp.actor_name, tmp.edit_count
FROM (
  SELECT actor_id, actor_name, COUNT(*) edit_count
  FROM actor
  JOIN revision_userindex ON rev_actor = actor_id
  JOIN page ON rev_page = page_id
  WHERE rev_timestamp >= 20230601000000
  GROUP BY actor_id
  HAVING edit_count >= 500
) tmp
JOIN revision_userindex ON rev_actor = tmp.actor_id
JOIN page ON rev_page = page_id
WHERE rev_timestamp >= 20230701000000
AND page_namespace != 2
AND page_namespace != 3
GROUP BY tmp.actor_id
;

SQL

Checking query status...