use hewiki_p;

select * from user join user_groups

on user_id = ug_user

where user_editcount > 0

and not exists

(select * from user_groups

 where user_id = ug_user

 and ug_group in ('autopatrolled', 'patroller', 'sysop', 'bot'))

and not ug_group = 'ipblock-exempt'

limit 5;

select * from user join user_groups

on user_id = ug_user

where ug_group = 'autoconfirmed';

show tables;

select distinct(up_property) from user_properties limit 1

​