Rotlinks im ANR

SQL

USE dewiki_p;
SELECT STRAIGHT_JOIN FORMAT(COUNT(*), 0, 'de_DE') AS "Anzahl Rotlinks gesamt",
       FORMAT(COUNT(DISTINCT pl_title, pl_namespace), 0, 'de_DE') AS "Anzahl unterschiedlicher Rotlinks"
  FROM pagelinks LEFT JOIN page AS toPage
                        ON toPage.page_namespace = pl_namespace
                       AND toPage.page_title = pl_title,
       page AS fromPage LEFT JOIN templatelinks
                               ON fromPage.page_id = tl_from
                              AND tl_namespace = 10
                              AND tl_title = "Begriffsklärung"
 WHERE pl_from_namespace = 0
   AND pl_namespace = 0
   AND toPage.page_id IS NULL
   AND fromPage.page_id = pl_from
   AND tl_from IS NULL
   AND NOT EXISTS (SELECT 1 FROM categorylinks
                           WHERE cl_from = fromPage.page_id
                            AND cl_to = 'Familienname'
                  )
SQL

Checking query status...
