Schweizer Artikel mit BKL

SQL

WITH RECURSIVE Cat AS (SELECT page_title, page_id
                        FROM page
                       WHERE page_title = 'Schweizer_Gemeinde'
                         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 CONCAT('[[', REPLACE(Art.page_title, '_', ' '), ']]') AS "Artikel",
       CONCAT('[[', GROUP_CONCAT(DISTINCT Bkl.page_title SEPARATOR ']], [['), ']]') as BKL
  FROM Cat, categorylinks AS CatLinks, page AS Art, pagelinks, page AS Bkl, templatelinks
 WHERE Cat.page_title = CatLinks.cl_to
   AND CatLinks.cl_from = Art.page_id
   AND Art.page_namespace = 0
   AND Art.page_id = pl_from
   AND pl_namespace = 0
   AND pl_title = Bkl.page_title
   AND Bkl.page_namespace = 0
   AND tl_from = Bkl.page_id
   AND tl_title = 'Begriffsklärung'
   AND tl_namespace = 10
 GROUP BY Artikel
SQL

Checking query status...
