troll from CA - Quarry

SQL

(SELECT CONCAT('# [[TimedText:', REPLACE (p1.page_title,'_',' '), ']] → useless redirect') AS title
 FROM page p1
 WHERE p1.page_namespace = 102
 AND p1.page_is_redirect = 1
 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,'_',' '), "]] → possibly useless redirect, check links before deleting") AS title
 FROM page p1
 WHERE p1.page_namespace = 102
 AND p1.page_is_redirect = 1
 AND EXISTS (SELECT 1 FROM page p3 WHERE p3.page_namespace = 6 AND p3.page_is_redirect = 1 AND p3.page_title = REGEXP_REPLACE(p1.page_title, '\\.[^\.]+\\.(?:srt|vtt)$', ''))
)

ORDER BY title
LIMIT 50;
SQL

Checking query status...
