Diskussionsseiten ohne Hauptseite

SQL

SELECT CONCAT(CASE D.page_namespace WHEN 1 THEN ''
                                    WHEN 3 THEN 'Benutzer '
                                    WHEN 5 THEN 'Wikipedia '
                                    WHEN 7 THEN 'Datei '
                                    WHEN 9 THEN 'MediaWiki '
                                    WHEN 11 THEN 'Vorlage '
                                    WHEN 13 THEN 'Hilfe '
                                    WHEN 15 THEN 'Kategorie '
                                    WHEN 101 THEN 'Portal '
                                    WHEN 829 THEN 'Modul '
                                    WHEN 2301 THEN 'Gadget '
                                    WHEN 2303 THEN 'Gadget-Definition '
              ELSE D.page_namespace
              END, 'Diskussion:', D.page_title) AS page_title,
       D.page_is_redirect
  FROM page as D LEFT JOIN page as P
                   ON P.page_title = D.page_title
                  AND P.page_namespace = D.page_namespace - 1
 WHERE P.page_title IS NULL
   AND D.page_namespace IN (1, /*3,*/ 5, 7, 9, 11, 13, 15, 101, 829, 2301, 2303)
   AND D.page_title NOT LIKE '%/Archiv%' # Archiv raus
SQL

Checking query status...
