count of users who are eligible to vote in RfA in zhwiki

SQL

USE zhwiki_p;
SELECT COUNT(DISTINCT user_id) FROM user
#JOIN revision ON rev_user == user_id
WHERE
# 注册满七天，且 ..
(user_registration IS NULL OR user_registration <= DATE_SUB(NOW(), INTERVAL 7 DAY)) AND (
# 解任投票联署提出或上任投票开始1个月前，编辑100次或以上 ....
  (SELECT COUNT(*) FROM revision WHERE rev_user = user_id AND
   rev_timestamp <= DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 1 MONTH), '%Y%m%d%H%i%s')) >= 100 AND
# .... 并在联署提出或上任投票开始前3个月内至少有一次编辑（不包括任何用户页及用户对话页）
  (SELECT COUNT(*) FROM revision JOIN page ON rev_page = page_id
   WHERE rev_user = user_id AND page_namespace <> 2 AND page_namespace <> 3 AND
   rev_timestamp <= DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 3 MONTH), '%Y%m%d%H%i%s')) >= 1
# .. 或 ..
OR
# 编辑3000次或以上 ....
  (SELECT COUNT(*) FROM revision WHERE rev_user = user_id) >= 3000 OR
# .... 或编辑1500次条目或以上
  (SELECT COUNT(*) FROM revision JOIN page ON rev_page = page_id
   WHERE rev_user = user_id AND page_namespace = 0) >= 1500
)
SQL

Checking query status...
