pages cathgorized under a mother and daughter categories

SQL

USE fawiki_p;
SELECT page_title, frst.cl_to#, scnd.cl_to
FROM categorylinks AS frst JOIN page ON frst.cl_from = page_id
JOIN categorylinks AS scnd ON scnd.cl_from = page_id
AND frst.cl_to <> scnd.cl_to

WHERE page_namespace = 0
AND page_is_redirect = 0

AND NOT EXISTS (
  SELECT NULL
  FROM page JOIN page_props ON page_id = pp_page
  WHERE page_title = frst.cl_to
  AND pp_propname = 'hiddencat'
)


AND 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
  )
  

#AND page_title = 'گاهنامه'

LIMIT 10;

SQL

Checking query status...