Untitled query #82834

SQL

WITH RECURSIVE Cat AS (
  SELECT page_title, page_id
    FROM page
    WHERE page_title = "Mittelhessen"
      AND page_namespace = 14
  UNION
  SELECT Subcat.page_title, Subcat.page_id
    FROM page AS Subcat, categorylinks, Cat
    WHERE Subcat.page_namespace = 14
      AND cl_from = Subcat.page_id
      AND cl_to = Cat.page_title
      AND cl_type = "subcat"
)
SELECT DISTINCT Art.page_title AS Artikel, GROUP_CONCAT(DISTINCT Red.page_title) AS WL, Prop.pp_value AS Sort
  FROM Cat
  INNER JOIN categorylinks AS Catlinks ON Cat.page_title = Catlinks.cl_to
  INNER JOIN page          AS Art      ON Catlinks.cl_from = Art.page_id
   LEFT JOIN redirect      AS Rd       ON (Rd.rd_title = Art.page_title AND Rd.rd_namespace = 0)
   LEFT JOIN page          AS Red      ON (Rd.rd_from = Red.page_id     AND Red.page_namespace = 0)
   LEFT JOIN page_props    AS Prop     ON (Prop.pp_page = Art.page_id   AND Prop.pp_propname = 'defaultsort')
  WHERE Art.page_namespace = 0
  GROUP BY Artikel
  ORDER BY Sort, Artikel
SQL

Checking query status...
