Fork of Station redirects by Certes
This query is marked as a draft This query has been published by Certes.

SQL

x
 
/* 1 */
SELECT DISTINCT pl_title
FROM pagelinks PL
JOIN page ON page_namespace = 0 AND page_title = REPLACE(PL.pl_title, "station", "Station")
WHERE pl_from_namespace = 0 AND pl_namespace = 0 AND pl_title LIKE "Ö%station%"
AND NOT EXISTS (SELECT 1 FROM page WHERE page_namespace = 0 AND page_title = PL.pl_title)
/* 2 */
/* SELECT page_title FROM page WHERE page_namespace = 0 AND page_title LIKE "%station%" */
/* 3 */
/* SELECT page_title FROM page WHERE page_namespace = 0 AND page_title LIKE "%Station%" */
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...