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)

    select user_id from A;