Deleted - Quarry

SQL

SELECT user_id, user_name, user_editcount, user_registration
FROM `user`
WHERE user_editcount >= 75000
  AND user_editcount <= 80000
  AND user_registration < 20181105000000
  AND EXISTS (SELECT 1 FROM user_groups WHERE user_id=ug_user AND ug_group = 'extendedconfirmed')
  AND NOT EXISTS (SELECT 1 FROM user_groups WHERE user_id=ug_user AND ug_group = 'sysop') -- administrator
  AND NOT EXISTS (SELECT 1 FROM user_groups WHERE user_id=ug_user AND ug_group = 'patroller') -- new page patroller
  AND NOT EXISTS (SELECT 1 FROM logging_logindex
                  WHERE user_name = log_title
                    AND log_type = 'block' AND log_action = 'block'
                    AND log_timestamp >= 20181105000000)
  AND (SELECT COUNT(*) FROM revision_userindex
       WHERE revision_user = user_id
         AND revision_timestamp >= 20181105000000
       LIMIT 500) >= 500
  AND (SELECT COUNT(*) FROM revision_userindex
       WHERE revision_user = user_id
         AND rev_timestamp >= 20191005000000
       LIMIT 500) >= 50
  AND (SELECT COUNT(*) FROM revision_userindex
       JOIN page ON page_id = rev_page
       WHERE revision_user = user_id
         AND revision_parent_id = 0
         AND page_namespace = 0
         AND page_len >= 2000 -- length in bytes
       LIMIT 2) >= 2;
SQL

Checking query status...
