Untitled query #58490

SQL

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')
                  )
SQL

Checking query status...
