draft mother and daughter categories

SQL

USE fawiki_p;
SELECT frst.cl_from, frst.cl_to#, scnd.cl_to
FROM categorylinks AS frst JOIN categorylinks AS scnd ON scnd.cl_from = frst.cl_from
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
    OR page_title = scnd.cl_to
  )
  AND pp_propname = 'hiddencat'
)

AND scnd.cl_to IN (
  SELECT thrd.cl_to
    FROM categorylinks AS thrd JOIN page ON third.cl_from = page_id
    WHERE page_title = frst.cl_to
  )

#AND page_title = 'خیام'

LIMIT 100;
SQL

Checking query status...
