This query is marked as a draft This query has been published by Wurgl.

SQL

AخA
 
USE dewiki_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
                  )
 
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...