Use enwiki_p;

​

SELECT

  from_page.page_namespace AS from_namespace,

  from_page.page_title AS from_title,

  to_page.page_namespace AS to_namespace,

  to_page.page_title AS to_title

FROM

  categorylinks,

  page AS from_page,

  page AS to_page

  LEFT JOIN page_props ON pp_page = to_page.page_id

  AND pp_propname = 'hiddencat'

WHERE

  from_page.page_id = cl_from

  AND from_page.page_namespace IN (0, 14)

  AND to_page.page_title = cl_to

  AND to_page.page_namespace = 14

  AND pp_value is NULL

LIMIT

  10

​

​