use frwiki_p;

select rev_user, user_name, rev_user_text, count(*) from revision, user where rev_user = user_id and rev_user_text != user_name and rev_user_text!='' group by rev_user, rev_user_text order by count(*) desc;