prospecting - Quarry

SQL

use enwiki_p;
SELECT
  user_name, user_editcount, 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
  (
    page_title LIKE "Bots/Requests_for_approval%"
    OR page_title = "Bot Approvals Group"
  )
  AND (
    user_name = "Anomie"
    OR user_name = "BU Rob13"
  )
  AND (
	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
  max(rev_timestamp) DESC;
LIMIT 10;
SQL

Checking query status...
