zhwiki RFX Eligible Voters

SQL

/*
解任投票联署提出或上任投票开始120天前，编辑至少500次；并在联署提出或上任投票开始前90天内至少有1次编辑（不包括任何用户页及用户对话页）
OR
编辑至少3000次
OR
编辑条目至少1500次
*/
/*
SELECT user_name, user_editcount, user_id
FROM user
WHERE user_editcount >= 3000;
*/
SELECT user_name, COUNT(*) article_editcount, user_editcount, user_id
FROM user
JOIN actor ON user_id = actor_user
JOIN revision_pageindex ON rev_actor = actor_id
JOIN page ON rev_page = page_id
WHERE page_namespace = 0
GROUP BY user_id
HAVING COUNT(*) >= 1500;
SQL

Checking query status...
