TimedText pages to be checked

SQL

(SELECT CONCAT('# [[TimedText:', REPLACE (page_title,'_',' '), ']] → missing or bad extension') AS title
 FROM page
 WHERE page_namespace = 102
 AND page_title NOT LIKE '%.srt'
 AND page_title NOT LIKE '%.vtt'
)/*
UNION
(SELECT CONCAT('# [[TimedText:', REPLACE (page_title,'_',' '), ']] → ',
               IF (page_len = 0, 'empty', CONCAT('length ', page_len))) AS title
 FROM page
 WHERE page_namespace = 102
 AND page_len < 33
)
UNION
(SELECT CONCAT('# [[TimedText:', REPLACE (p1.page_title, '_',' '), ']] → orphaned') AS title
 FROM page p1
 WHERE p1.page_namespace = 102
 AND (p1.page_title LIKE '%.srt' OR p1.page_title LIKE '%.vtt')
 AND NOT EXISTS (SELECT 1 FROM page p2 WHERE p2.page_namespace = 6 AND p2.page_title = REGEXP_REPLACE(p1.page_title, '\.[^\.]+\.(?:srt|vtt)$', ''))
)*/
UNION
(SELECT CONCAT('# [[TimedText:', REPLACE (p1.page_title,'_',' '), ']] → file page is redirect') AS title
 FROM page p1 JOIN page p2 ON p2.page_title = REGEXP_REPLACE(p1.page_title, '\.[^\.]+\.(?:srt|vtt)$', '')
 WHERE p1.page_namespace = 102
 AND p1.page_is_redirect = 0
 AND p2.page_is_redirect = 1
 AND p2.page_namespace = 6
)
/*UNION
(SELECT CONCAT('# [[:{{ns:', page_namespace, '}}:', REPLACE (page_title,'_',' '), ']] → wrong ns?') AS title
 FROM page
 WHERE (page_title LIKE '%.srt' OR page_title LIKE '%.vtt')
 AND page_title NOT LIKE 'Deletion\_requests/%'
 AND page_namespace NOT IN (2, 3, 102, 103)
)*/
ORDER BY title
LIMIT 500;
SQL

Checking query status...
