Hewiki non autopatrolled users

SQL

use hewiki_p;
select user_id, user_name, user_registration, user_editcount from user
where user_editcount > 500
and not exists
(select * from user_groups
 where user_id = ug_user
 and ug_group in ('autopatrolled', 'patroller', 'sysop', 'bureaucrat', 'bot'))
order by user_editcount desc;
select user_id, user_name, user_registration, user_editcount from user
where user_editcount > 500
and not exists
(select * from user_groups
 where user_id = ug_user
 and ug_group in ('autopatrolled', 'patroller', 'sysop', 'bureaucrat', 'bot'))
and exists
(select * from revision_userindex
 where user_id = rev_user
 and rev_timestamp like '2017%')
order by user_editcount desc;
select * from revision_userindex limit 1
SQL

Checking query status...
