Artikel nicht auf Artikel (Begriffsklärung) verlinkt

SQL

USE dewiki_p;
SELECT Artikel.page_title AS "Artikel", BKL.page_title AS "BKS", (SELECT Redir.page_title
                                                                    FROM pagelinks, redirect, page AS Redir
                                                                   WHERE rd_from = Redir.page_id
                                                                     AND pl_from = BKL.page_id
                                                                     AND pl_title = Redir.page_title
                                                                     AND pl_namespace = Redir.page_namespace
                                                                     AND rd_title = Artikel.page_title)
  FROM page AS Artikel, page AS BKL
 WHERE Artikel.page_namespace = 0
   AND Artikel.page_is_redirect = 0
   AND BKL.page_namespace = 0
   AND BKL.page_title like '%_(Begriffsklärung)'
   AND Artikel.page_title = REPLACE(BKL.page_title, '_(Begriffsklärung)', '')
   AND NOT EXISTS (SELECT 1
                     FROM pagelinks
                    WHERE BKL.page_id = pl_from
                      AND Artikel.page_title = pl_title
                      AND pl_namespace = 0
                      AND pl_from_namespace = 0
                  )
SQL

Checking query status...
