zhwikinews users with 500+ edits

SQL

USE zhwiki_p;

SELECT t1.user_id, t1.user_name, t1.user_registration FROM (
  SELECT user_id, user_name, user_registration, COUNT(user_id) FROM user
  JOIN revision ON rev_user = user_id
  WHERE rev_timestamp <= DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 1 MONTH), '%Y%m%d%H%i%s')
  HAVING COUNT(user_id) >= 100
) AS t1
JOIN (
  SELECT user_id, user_name, user_registration, COUNT(user_id) FROM user
  JOIN revision ON rev_user = user_id
  JOIN page ON rev_page = page_id
  WHERE page_namespace <> 2 AND page_namespace <> 3 AND
    rev_timestamp <= DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 3 MONTH), '%Y%m%d%H%i%s')
  HAVING COUNT(user_id) >= 1
) AS t2 ON t1.user_id = t2.user_id
UNION
SELECT user_id, user_name, user_registration, COUNT(user_id) FROM user
JOIN revision ON rev_user = user_id
HAVING COUNT(user_id) >= 3000
UNION
SELECT user_id, user_name, user_registration, COUNT(user_id) FROM user
JOIN revision ON rev_user = user_id
JOIN page ON rev_page = page_id
WHERE page_namespace = 0
HAVING COUNT(user_id) >= 1500;
SQL

Checking query status...
