RAQ - Quarry

SQL

USE enwiki_p;
SELECT *
FROM actor_revision a1
JOIN `user` u1 ON a1.actor_user = u1.user_id
WHERE
	u1.user_editcount >= 200
    AND "bot" NOT IN (
      SELECT ug_group
      FROM user_groups
      WHERE u1.user_id = ug_user
    )
    AND 1 <= (
      SELECT COUNT(*)
      FROM revision_userindex
      WHERE rev_timestamp > 20200423000000
      AND rev_actor = a1.actor_id
    )
    AND 50 <= (
      SELECT COUNT(*)
      FROM revision_userindex
      WHERE rev_timestamp > 20190622000000
      AND rev_actor = a1.actor_id
    )
    AND 200 <= (
      SELECT COUNT(*)
      FROM revision_userindex
      JOIN page ON rev_page = page_id
      WHERE page_namespace = 0
      AND rev_actor = a1.actor_id
    )
SQL

Checking query status...
