with A as 

(select user_id, user_name, user_registration, user_editcount

    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')

    group by user_id

    order by user_editcount desc);

with B as 

(select user_id, user_name, user_registration, user_editcount

    from user join user_groups on user.user_id = user_groups.ug_user

    where (user_groups.ug_group = 'bot')

    group by user_id

    order by user_editcount desc);