use cswiki_p;

 select page_title, actor_name from revision join page on page_id=rev_page join actor on rev_actor=actor_id where rev_parent_id=0 and page_namespace=0 and rev_page in (select cl_from from categorylinks)