SET @codes = 'af', 'en', 'es', 'fr';

SELECT CONCAT('# [[TimedText:', REPLACE (page_title, '_',' '), ']] → ') AS title

FROM page

WHERE page_namespace = 102

AND (page_title LIKE '%.srt' OR page_title LIKE '%.vtt')

AND REGEXP_REPLACE((REGEXP_REPLACE(page_title, '\\.(?:srt|vtt)$', '')), '^.+\\.', '')

 NOT IN (@codes)

GROUP BY REGEXP_REPLACE((REGEXP_REPLACE(page_title, '\\.(?:srt|vtt)$', '')), '^.+\\.', '')

LIMIT 700;

​