Namespace-0-Vorlageneinbindungen in BKS

SQL

USE dewiki_p;
SELECT CONCAT("[[", REPLACE(page_title, "_", " "), "]]") AS "BKL-Seite",
       GROUP_CONCAT(Kandidaten.tl_title SEPARATOR ", ") AS "eingebundene Namespace-0-Vorlagen"
  FROM page as BKS, templatelinks AS BKL, templatelinks AS Kandidaten
 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(RELACE(REPLACE(REPLACE(page_title, "_(Begriffsklärung)", ""), "_(Familienname)", "")), "_", "%")
   AND BKL.tl_from_namespace = 0
   AND BKL.tl_from = page_id
   AND BKL.tl_namespace = 10
   AND BKL.tl_title = "Begriffsklärung"
   AND EXISTS ( SELECT 1
                  FROM pagelinks, page as p, templatelinks as pd
                 WHERE pl_from = BKS.page_id
                   AND p.page_title = pl_title
                   AND p.page_namespace = pl_namespace
                   AND pd.tl_from_namespace = 0
                   AND pd.tl_from = p.page_id
                   AND pd.tl_namespace = 10
                   AND pd.tl_title = "Personendaten"
              )
 GROUP BY Kandidaten.tl_from
SQL

Checking query status...
