Rotlinks in deWP

SQL

SELECT COUNT(*) AS "Rotlinks", COUNT(DISTINCT pl_title) AS "Unterschiedliche Rotlinks"
  FROM pagelinks
 WHERE pl_from_namespace = 0
   AND pl_namespace = 0
   AND NOT EXISTS (SELECT 1
                     FROM page
                    WHERE page_namespace = 0
                      AND page_title = pl_title
                  )

SELECT COUNT(*) AS "Rotlinks in Begriffsklärungsseiten", COUNT(DISTINCT pl_title) AS "Unterschiedliche Rotlinks in Begriffsklärungsseiten"
  FROM pagelinks, templatelinks
 WHERE pl_from_namespace = 0
   AND pl_namespace = 0
   AND pl_from = tl_from
   AND tl_namespace = 10
   AND tl_title = 'Begriffsklärung'
   AND NOT EXISTS (SELECT 1
                     FROM page
                    WHERE page_namespace = 0
                      AND page_title = pl_title
                  );

WITH RECURSIVE Cat AS (SELECT page_title, page_id
                        FROM page
                       WHERE page_title = 'Liste'
                         AND page_namespace = 14
                       UNION
                      SELECT SubCat.page_title, SubCat.page_id
                        FROM page AS SubCat, categorylinks, Cat
                       WHERE SubCat.page_namespace = 14
                         AND cl_from = SubCat.page_id
                         AND cl_to = Cat.page_title
                         AND cl_type = "subcat"
                     )
SELECT COUNT(*) AS "Rotlinks in Kategorie:Liste", COUNT(DISTINCT pl_title) AS "Unterschiedliche Rotlinks in Kategorie:Liste"
  FROM pagelinks, categorylinks, Cat
 WHERE Cat.page_title = cl_to
   AND cl_from = pl_from
   AND pl_from_namespace = 0
   AND pl_namespace = 0
   AND NOT EXISTS (SELECT 1
                     FROM page
                    WHERE page_namespace = 0
                      AND page_title = pl_title
                  );
SQL

Checking query status...
