Untitled query #74001

SQL

WITH RECURSIVE all_citation_templates (page_title, page_id, page_namespace) AS (
  (
    SELECT page_title, page_id, page_namespace
    FROM page
    WHERE page_title = "Citation_templates"
      AND page_namespace = 14
  )
  UNION
  (
    SELECT child.page_title, child.page_id, child.page_namespace
    FROM page AS child
    JOIN categorylinks as childLinks ON child.page_id = childLinks.cl_from
    JOIN all_citation_templates AS parent ON childLinks.cl_to = parent.page_title
    LEFT JOIN page_props ON childLinks.cl_from = pp_page AND pp_propname = "hiddencat"
    WHERE (child.page_namespace = 10
      OR child.page_namespace = 14)
      AND parent.page_namespace = 14
      AND pp_propname IS NULL
  )
),

SELECT page_title, lt_title
FROM page
JOIN templatelinks ON tl_from = page_id
JOIN linktarget ON tl_target_id = lt_id
WHERE page_title = "A_Aravinddaraj"
AND page_namespace = 0
AND page_is_redirect = 0
AND lt_title IN (SELECT page_title FROM all_citation_templates)
SQL

Checking query status...
