BKL und Vorlage Linked Coordinates

SQL

SELECT P.page_title, count(X.page_id) AS Anzahl
  FROM page AS P, templatelinks AS A, pagelinks, templatelinks AS T, page AS X
 WHERE A.tl_from = P.page_id
   AND A.tl_from_namespace = 0
   AND A.tl_title = 'Begriffsklärung'
   AND NOT EXISTS (SELECT 1
                     FROM templatelinks AS B
                    WHERE B.tl_from = page_id
                      AND B.tl_from_namespace = 0
                      AND B.tl_title = 'Linked_Coordinates'
                      AND B.tl_namespace = 10
                  )
   AND A.tl_namespace = 10
   AND pl_from = P.page_id
   AND X.page_title = pl_title
   AND X.page_namespace = 0
   AND X.page_id = tl_from
   AND tl_title = 'Coordinate'
   AND tl_namespace = 10
 GROUP BY X.page_id
 ORDER BY Anzahl DESC
SQL

Checking query status...
