Untitled query #51419

SQL

USE alswiki_p;
SELECT CONCAT('[[', REPLACE(Artikel.page_title, '_', ' '), ']]') AS "Artikelchen",
       REPLACE(pl_title, '_', ' ') AS "eventüll karpotter Link",
       SUBSTRING(REPLACE(pl_title, '_', ' '), 1, LENGTH(pl_title) - 1) AS "Vorschlag"
  from pagelinks, page AS Artikel, page AS Blaulink
 WHERE Artikel.page_id = pl_from
   AND pl_namespace = 0
   AND pl_from_namespace = 0
   AND pl_title regexp '[^A-Za-z0-9!+]$'
   AND Blaulink.page_namespace = pl_namespace
   AND Blaulink.page_title = SUBSTRING(pl_title, 1, LENGTH(pl_title) - 1)
   AND NOT EXISTS (SELECT 1
                    FROM page
                   WHERE page_title = pl_title
                     AND page_namespace = pl_namespace
                  )
SQL

Checking query status...
