use zhwiki_p;

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 = 'extendedconfirm'

    group by user_id

    order by user_editcount desc;