Admin elections eligible voters

SQL

WITH usersWith150MainspaceEdits1MonthBeforeElection AS (
    SELECT actor_user FROM revision_userindex
    JOIN page ON rev_page = page_id
    JOIN actor_revision ON rev_actor = actor_id
    WHERE page_namespace = 0
    AND rev_timestamp < '20240925000000'
    AND actor_user IS NOT NULL
    GROUP BY rev_actor
    HAVING COUNT(*) >= 150
), usersWith10LiveEdits1YearBeforeElection AS (
    SELECT actor_user FROM revision_userindex
    JOIN actor_revision ON rev_actor = actor_id
    WHERE rev_timestamp < '20240925000000'
    AND rev_timestamp > '20230925000000'
    GROUP BY rev_actor
    HAVING COUNT(*) >= 10
), bots AS (
    SELECT ug_user FROM user_groups
    WHERE ug_group = 'bot'
)

SELECT user_name FROM user
LEFT JOIN ipblocks ON user_id = ipb_user
WHERE user_registration < '20240825000000'
AND user_id IN (SELECT actor_user FROM usersWith150MainspaceEdits1MonthBeforeElection)
AND user_id IN (SELECT actor_user FROM usersWith10LiveEdits1YearBeforeElection)
AND (ipb_sitewide IS NULL OR ipb_sitewide = 0)
AND user_name NOT LIKE 'Vanished user%'
AND user_id NOT IN (SELECT ug_user FROM bots)
SQL

Checking query status...
