use commonswiki_p;

SELECT

  page_title,

  cat_pages,

  cat_subcats

FROM page

JOIN categorylinks ON cl_to = page_title

RIGHT JOIN category

ON cat_title = page_title

WHERE page_id = cl_from

AND page_namespace = 14

limit 10000;