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 distinct(log_type) from logging_userindex

where log_type = 'block'

​