Untitled query #60255

SQL

select * from (select distinct user_id from user join user_groups on user.user_id = user_groups.ug_user
    where (user_groups.ug_group = 'extendedconfirmed' or user_groups.ug_group = 'sysop') limit 10 ) A
    left join (select distinct user_id from user join user_groups on user.user_id = user_groups.ug_user
    where user_groups.ug_group = 'bot' limit 10 ) B
    on A.user_id = B.user_id limit 10

AخA
 
select * from (select distinct user_id from user join user_groups on user.user_id = user_groups.ug_user    where (user_groups.ug_group = 'extendedconfirmed' or user_groups.ug_group = 'sysop') limit 10 ) A    left join (select distinct user_id from user join user_groups on user.user_id = user_groups.ug_user    where user_groups.ug_group = 'bot' limit 10 ) B    on A.user_id = B.user_id limit 10

SQL

Checking query status...