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)

select user_id from A left join B where B.user_id is null