Namespace-0-Vorlageneinbindungen in BKS

SQL

USE dewiki_p;
SELECT CONCAT("[[", REPLACE(page_title, "_", " "), "]]") AS "BKL-Seite",
       GROUP_CONCAT(Kandidaten.tl_title SEPARATOR ", ") AS "Namespace-0-Vorlagen"
  FROM page, templatelinks AS Kandidaten, templatelinks AS BKL
 WHERE page_namespace = 0
   AND Kandidaten.tl_from_namespace = 0
   AND Kandidaten.tl_from = page_id
   AND Kandidaten.tl_namespace = 0
   AND LOWER(REPLACE(Kandidaten.tl_title, "_(Begriffsklärung)", "")) NOT LIKE CONCAT("%", LOWER(REPLACE(page_title, "_(Begriffsklärung)", "")))
   AND BKL.tl_from_namespace = 0
   AND BKL.tl_from = page_id
   AND BKL.tl_namespace = 10
   AND BKL.tl_title = "Begriffsklärung"
 GROUP BY Kandidaten.tl_from
SQL

Checking query status...
