zhwiki RFX Eligible Voters with a fix

SQL

/*  2024年7月5日 (五) 通过的人事任免投票资格。
注册满120天，解任投票联署提出或上任投票开始120天前，编辑至少500次；并在联署提出或上任投票开始前90天内至少有1次编辑（不包括任何用户页及用户对话页）
OR
注册满120天, 编辑至少3000次
OR
注册满120天, 编辑条目至少1500次
*/

-- USE zhwiki_p;

SET @VOTE_TIME = 20240616000000;
SET @PRIOR_90_VOTE_TIME = 20240318000000;
SET @PRIOR_120_VOTE_TIME = 20240216000000;

WITH all_revision AS (
    SELECT rev_id, rev_actor, rev_page, rev_timestamp
    FROM revision_userindex
    UNION
    SELECT ar_id AS rev_id, ar_actor AS rev_actor, ar_page_id AS rev_page, ar_timestamp AS rev_timestamp
    FROM archive_userindex
),

user_registration AS (
    SELECT actor_id, actor_user, actor_name, user_registration
    FROM actor
    JOIN user ON actor_user = user_id
    WHERE user_registration <= @PRIOR_120_VOTE_TIME
)

/*
SELECT part1.actor_name AS user_name
FROM (
    SELECT actor_user, actor_name, COUNT(*) AS edits
    FROM user_registration
    JOIN all_revision ON actor_id = all_revision.rev_actor
    WHERE actor_user IS NOT NULL
      AND all_revision.rev_timestamp < @PRIOR_120_VOTE_TIME
      AND EXISTS (
          SELECT 1
          FROM all_revision AS recent_edits
          JOIN page ON recent_edits.rev_page = page_id
          WHERE recent_edits.rev_actor = actor_id
            AND recent_edits.rev_timestamp BETWEEN @PRIOR_90_VOTE_TIME AND @VOTE_TIME
            AND page_namespace NOT IN (2, 3)
      )
    GROUP BY actor_id
    HAVING edits >= 500
) AS part1

UNION
*/
SELECT part2.actor_name AS user_name
FROM (
    SELECT actor_id, actor_user, actor_name, COUNT(*) AS edits
    FROM user_registration
    JOIN all_revision ON actor_id = all_revision.rev_actor
    WHERE actor_user IS NOT NULL
      AND all_revision.rev_timestamp < @VOTE_TIME
    GROUP BY actor_id
    HAVING edits >= 3000
) AS part2

UNION

SELECT part3.actor_name AS user_name
FROM (
    SELECT actor_id, actor_user, actor_name, COUNT(*) AS ns0_edits
    FROM user_registration
    JOIN all_revision ON actor_id = all_revision.rev_actor
    JOIN page ON page_id = all_revision.rev_page
    WHERE actor_user IS NOT NULL
      AND all_revision.rev_timestamp < @VOTE_TIME
      AND page_namespace = 0
    GROUP BY actor_id
    HAVING ns0_edits >= 1500
) AS part3

ORDER BY user_name;
SQL

Checking query status...
