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.