Linked stations existing only in upper case

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

1. Link targets containing station
2. Pages containing station
3. Pages containing Station
Offline processing:
4. 3 with Station replaced by station
5. Final result: (1 intersection 4) excluding 2
Joining these in SQL takes too long

SQL

/* 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%" */

SQL

Checking query status...