use arwiki_p;

select page_namespace, page_title, actor_name

from revision

inner join actor

on actor_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

order by rev_timestamp desc 

limit 50;