use zhwiki_p;

select *

    from user_former_groups

    join 

    user on user_former_groups.ufg_user = user.user_id

        where ufg_group = "ipblock-exempt"

​

    order by ufg_user desc limit 50 ;