Untitled query #51420

SQL

USE alswiki_p;
SELECT CONCAT('[[', Artikel.page_title, ']]') AS "Artikelchen",
       pl_title AS "eventüll karpotter Link",
       CONCAT(SUBSTRING_INDEX(pl_title, ')', 1), ')|', SUBSTRING_INDEX(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 '\\)[^_/]'
   AND Blaulink.page_namespace = pl_namespace
   AND Blaulink.page_title = CONCAT(SUBSTRING_INDEX(pl_title, ')', 1), ')')
   AND NOT EXISTS (SELECT 1
                    FROM page
                   WHERE page_title = pl_title
                     AND page_namespace = pl_namespace
                  )
SQL

Checking query status...
