pages cathgorized under a mother and daughter categories

SQL

USE fawiki_p;
SELECT REPLACE(page_title,'_',' '), cl_to
FROM page JOIN categorylinks AS frst ON cl_from = page_id JOIN page_props ON pp_page = page_id JOIN pagelinks ON pl_from = page_id ON pl_from_namespace = page_namespace
    
WHERE page_namespace = 0
AND page_is_redirect = 0
AND pp_propname <> 'hiddencat'
AND pl_namespace = 14

AND page_id IN (
  SELECT scnd.cl_from
  FROM categorylinks AS scnd
  WHERE scnd.cl_to IN (
    SELECT pl_title 
    FROM pagelinks JOIN page ON pl_from = page_id
    WHERE page_title = frst.cl_to
    AND pl_from_namespace = 14
    AND pl_namespace = 14
  )
)
LIMIT 5;

SQL

Checking query status...