Fork of
Untitled query #50373
by Wurgl
This query is marked as a draft
This query has been published
by Wurgl.
SQL
AخA
SELECT CONCAT('[[', REPLACE(s.page_title, '_', ' '), ']]') AS "ß-Seite",
CONCAT('[[', REPLACE(REPLACE(s.page_title, 'ß', 'ss'), '_', ' '), ']]') AS "fehlende ss-Seite"
FROM page AS s
WHERE s.page_namespace = 0
AND s.page_title RLIKE "^[^(]*ß"
AND s_page_is_redirect = 0
AND NOT EXISTS (SELECT 1
FROM categorylinks
WHERE cl_from = page_id
AND cl_to IN ('Mann', 'Frau')
)
AND NOT EXISTS (SELECT 1
FROM templatelinks
WHERE tl_from = page_id
AND tl_title = 'Infobox_Fußballsaison'
AND tl_namespace = 10
)
AND NOT EXISTS (SELECT 1
FROM page AS ss
WHERE ss.page_namespace = 0
AND ss.page_title = REPLACE(s.page_title, 'ß', 'ss')
)
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.