language-like pages w/o page_lang set

Pages on meta without page_lang metadata set, whose titles end in "/languagecode".
languagecode is approximated as anything that appears as page_lang for at least one page on meta.
languagecode "en" is omitted, as are pages in namespace Translations: (which has another 1270876 results all by itself).

For [[w:en:WP:RAQ#List of pages where page language is not the same as the last part of title]] circa 15 June 2022.

SQL

SELECT CONCAT('[[', CASE page_namespace
                      WHEN 0 THEN ''                      WHEN 1 THEN 'Talk:'
                      WHEN 2 THEN 'User:'                 WHEN 3 THEN 'User talk:'
                      WHEN 4 THEN 'Wikipedia:'            WHEN 5 THEN 'Wikipedia talk:'
                      WHEN 8 THEN 'MediaWiki:'            WHEN 9 THEN 'MediaWiki talk:'
                      WHEN 10 THEN 'Template:'            WHEN 11 THEN 'Template talk:'
                      WHEN 12 THEN 'Help:'                WHEN 13 THEN 'Help talk:'
                      WHEN 14 THEN ':Category:'           WHEN 15 THEN 'Category talk:'
                      WHEN 200 THEN 'Grants:'             WHEN 201 THEN 'Grants talk:'
                      WHEN 202 THEN 'Research:'           WHEN 203 THEN 'Research talk:'
                      WHEN 206 THEN 'Iberocoop:'          WHEN 207 THEN 'Iberocoop talk:'
                      WHEN 828 THEN 'Module:'             WHEN 828 THEN 'Module talk:'
                      WHEN 866 THEN 'CNBanner:'           WHEN 867 THEN 'CNBanner talk:'
                      WHEN 1198 THEN 'Translations:'      WHEN 1199 THEN 'Translations talk:'
                      ELSE CONCAT('{{ns:', page_namespace, '}}:')
                    END, page_title,']]'),
       SUBSTRING_INDEX(page_title, '/', -1) AS lang_in_title,
       page_lang
FROM page
WHERE page_title LIKE '%/%'
  AND page_lang IS NULL
  AND SUBSTRING_INDEX(page_title, '/', -1) IN
    (SELECT DISTINCT page_lang
     FROM page
     WHERE page_lang != 'en')
  AND page_namespace != 1198;

SQL

Checking query status...