Begriffsklärungsseiten ohne Blaulink

SQL

SELECT CONCAT('[[', REPLACE(page_title, '_', ' '), ']]') AS Titel,
       (SELECT COUNT(*)
          FROM pagelinks
         WHERE pl_from = page_id
           AND pl_namespace = 0
           AND NOT EXISTS (SELECT 1
                             FROM page AS RL
                            WHERE RL.page_namespace = 0
                              AND RL.page_title = pl_title
                          )
       ) AS "Anzahl Rotlinks"
  FROM page, templatelinks
 WHERE page_namespace = 0
   AND tl_from = page_id
   AND tl_from_namespace = page_namespace
   AND tl_title = 'Begriffsklärung'
   AND tl_namespace = 10
   AND NOT EXISTS (SELECT 1
                     FROM page AS linkedPage, pagelinks
                    WHERE pl_from = page.page_id
                      AND pl_from_namespace = page.page_namespace
                      AND pl_title != 'Begriffsklärung'
                      AND pl_title = linkedPage.page_title
                      AND pl_namespace = linkedPage.page_namespace
                  )
SQL

Checking query status...
