SELECT CONCAT('# [[TimedText:', REPLACE (p1.page_title,'_',' '), "]] → probably useless redirect") AS title

 FROM page p1

 JOIN page p2 ON p2.page_namespace = 6 AND p2.page_is_redirect = 1 AND p2.page_title = REGEXP_REPLACE(p1.page_title, '\\.[^\.]+\\.(?:srt|vtt)$', '')

 WHERE p1.page_namespace = 102 AND p1.page_is_redirect = 1

 AND NOT EXISTS (SELECT 1 FROM pagelinks WHERE pl_namespace =102 AND pl_title = p1.page_title AND pl_from NOT IN (48260162, 134378376))

ORDER BY title

LIMIT 200;