Untitled query #80620

SQL

SELECT us.user_registration, us.user_editcount, us.user_id, us.user_name from user us 
where
us.user_id NOT IN (SELECT ug_user FROM user_groups WHERE ug_group = 'sysop') #0. Cannot be already a sysop
and us.user_editcount > 10000          #1a. At least 10,000 total edits
and us.user_registration <20210101000000 #3. Account registered at least three years ago
and us.user_name in (
  		select log_title from logging 
		where log_type in ('block','gblblock')
		and log_action in ('block','reblock')
        and log_timestamp > 20190101000000
	)
#JOIN comment_logging ON comment_id = log_comment_id
limit 100;
SQL

Checking query status...
