USE dewiki_p;

SELECT CONCAT('[[', REPLACE(page_title, '_', ' '), ']]') AS "Artikel", COUNT(*) AS 'Anzahl Rotlinks'

  FROM page, pagelinks

 WHERE page_id = pl_from

   AND page_namespace = 0

   AND NOT EXISTS ( SELECT 1

                      FROM page AS Linkziel

                     WHERE Linkziel.page_title = pl_title

                       AND Linkziel.page_namespace = pl_namespace

                  )

 GROUP BY page_id

HAVING COUNT(*) > 100

 ORDER BY COUNT(*) DESC