3000 300 30 50

SQL

SELECT
  actor_name,
  COUNT(*) as edits_in_30,
  u.user_editcount AS total_edits,
  DATEDIFF(NOW(), u.user_registration) AS num_of_days,
  u.user_registration AS reg_date
FROM
  revision_userindex
  JOIN page ON rev_page = page_id
  JOIN actor_revision ON rev_actor = actor_id
  JOIN user u ON u.user_id = actor_user
WHERE
  rev_timestamp < NOW()
  AND rev_timestamp >= DATE_SUB(NOW(), INTERVAL '30' DAY)
  AND page_namespace != 2 AND page_namespace != 3
  AND actor_user IS NOT NULL
  AND u.user_editcount > 300 AND u.user_editcount < 3000
  AND u.user_registration < DATE_SUB(NOW(), INTERVAL '90' DAY)
GROUP BY
  actor_name
HAVING
  COUNT(*) > 50
ORDER BY
  edits_in_30 DESC
SQL

Checking query status...
