prospecting - Quarry

SQL

use enwiki_p;
SELECT
  user_name, user_editcount AS "Edit count", user_registration,
  Max(rev_timestamp) AS "Last edit"
FROM
  user
  JOIN user_properties ON user_id = up_user
  JOIN revision_userindex ON user_id = rev_user
  JOIN user_groups ug1
	ON user_id = ug1.ug_user AND ug1.ug_group = 'autoreviewer'
  LEFT JOIN user_groups ug2
	ON user_id = ug2.ug_user AND ug2.ug_group = 'reviewer'
  LEFT JOIN user_groups ug3
	ON user_id = ug3.ug_user AND ug3.ug_group = 'rollbacker'
  LEFT JOIN ipblocks
	ON user_id = ipb_user
WHERE user_editcount >= 20000
	AND user_registration >= 20130101000000
	AND user_registration <= 20170101000000
    AND rev_timestamp >= 20190221000000
    AND ipb_id IS NULL
GROUP BY
  user_name
ORDER BY
  user_editcount DESC;
SQL

Checking query status...
