use arwiki_p;

select user_name, count(rev_id)

from revision

inner join user

on user_id = rev_actor

inner join page

on page_id = rev_page

where rev_page in (select cl_from from categorylinks where cl_from = rev_page and cl_to = "مقالات_مشروع_ويكي_طب")

and page_is_redirect = 0

group by user_name

order by count(rev_id) desc 

limit 50;