BKL und Vorlage Linked Coordinates

SQL

SELECT P.page_title AS "Begriffsklärung",
       COUNT(DISTINCT Artikel.page_id) AS "Anzahl Artikel",
       GROUP_CONCAT(DISTINCT Artikel.page_title SEPARATOR ' · ' LIMIT 5) AS "5 verlinkte Artikel mit Koordinaten"
  FROM page AS P, templatelinks AS BKL, templatelinks AS COORD, pagelinks, page AS Artikel
 WHERE P.page_namespace = 0
   AND P.page_id = BKL.tl_from
   AND BKL.tl_from_namespace = P.page_namespace
   AND BKL.tl_title = 'Begriffsklärung'
   AND BKL.tl_namespace = 10
   AND NOT EXISTS (SELECT 1
                     FROM templatelinks AS LC
                    WHERE P.page_id = LC.tl_from
                      AND LC.tl_from_namespace = P.page_namespace
                      AND LC.tl_title = 'Linked_Coordinates'
                      AND LC.tl_namespace = 10
                  )
   AND P.page_id = pl_from
   AND pl_title = Artikel.page_title
   AND pl_namespace = 0
   AND pl_namespace = Artikel.page_namespace
   AND Artikel.page_id = COORD.tl_from
   AND COORD.tl_title = 'Coordinate'
   AND COORD.tl_namespace = 10
 GROUP BY P.page_id
 ORDER BY COUNT(DISTINCT Artikel.page_id) DESC
SQL

Checking query status...
