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.