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,'_',' '), ']] → 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)
)
) UNION
*/
(SELECT CONCAT('# [[TimedText:', REPLACE (p1.page_title,'_',' '), ']] → testing...', SUBSTRING_INDEX(p1.page_title, '.', 2)) 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_title = SUBSTRING_INDEX(p1.page_title, '.', 2))
)
ORDER BY title
LIMIT 50;
SQL

Checking query status...
