Liste der Rotlinks auf Seiten

SQL

USE dewiki_p;
SELECT CONCAT('[[', REPLACE(FromPage.page_title, '_', ' '), ']]') AS "Von Seite", CONCAT('[[', REPLACE(pl_title, '_', ' '), ']]') AS "Rotlink nach"
  FROM page AS FromPage, pagelinks LEFT JOIN page AS ToPage ON pl_title = ToPage.page_title AND pl_namespace = ToPage.page_namespace
 WHERE ToPage.page_id IS NULL
   AND pl_from = FromPage.page_id
   AND pl_from_namespace = FromPage.page_namespace
   AND FromPage.page_namespace = 0
   AND FromPage.page_title IN ("Aale", "Amerikanischer_Aal") /* Leerzeichen durch _ ersetzen! */
SQL

Checking query status...
