troll from CA - Quarry

SQL

SELECT CONCAT('# [[TimedText:', REPLACE (p1.page_title,'_',' '), "]] → possibly useless redirect, check links before deleting") AS title
 FROM page p1 JOIN pagelinks
 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)$', '')
 JOIN linktarget ON lt_id = pl_target_id AND lt_namespace = 102 AND lt_title = p1.page_title
 WHERE p1.page_namespace = 102 AND p1.page_is_redirect = 1 AND pl_from != 134378376
ORDER BY title
LIMIT 10;
SQL

Checking query status...
