Untitled query #24905

SQL

USE dewiki_p;
SELECT COUNT(u1.user_id)
FROM user u1
WHERE WHERE (
  SELECT COUNT(r1.rev_id)
  FROM revision_userindex r1, page p1
  WHERE r1.rev_user = u1.user_id
  AND r1.rev_page = p1.page_id
  AND p1.page_namespace = 0
  AND r1.rev_timestamp >= DATE(NOW()) - INTERVAL 12 MONTH
) > 50
AND (
  SELECT COUNT(r2.rev_id)
  FROM revision_userindex r2, page p2
  WHERE r2.rev_user = u2.user_id
  AND r2.rev_page = p2.page_id
  AND p2.page_namespace = 0
) > 200
AND (
  SELECT COUNT(r3.rev_id)
  FROM revision_userindex r3
  WHERE r3.rev_user = u1.user_id
  AND r3.rev_timestamp < DATE(NOW()) - INTERVAL 2 MONTH
) > 0
SQL

Checking query status...
