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('# [[:{{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 100;
SQL

Checking query status...
