Untitled query #92767

SQL

WITH RECURSIVE subcategories AS (
  SELECT cl.cl_to AS category
  FROM categorylinks cl
  WHERE cl.cl_type = 'subcat' AND cl.cl_from IN (
    SELECT page_id FROM page WHERE page_title = 'Computer_science' AND page_namespace = 14
  )

  UNION

  SELECT cl.cl_to
  FROM categorylinks cl
  JOIN subcategories sc ON cl.cl_from = (
    SELECT page_id FROM page WHERE page_title = sc.category AND page_namespace = 14
  )
  WHERE cl.cl_type = 'subcat'
),
articles AS (
  SELECT p.page_title
  FROM page p
  JOIN categorylinks cl ON cl.cl_from = p.page_id
  WHERE cl.cl_to IN (SELECT category FROM subcategories)
    AND p.page_namespace = 0
    AND p.page_is_redirect = 0
)
SELECT *
FROM articles;
SQL

Checking query status...
