Untitled query #61118

SQL

SELECT concat("[[TimedText:",page_title,"]]")
FROM page 
WHERE page_namespace=710
AND NOT REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(page_title,".bg.srt",""),".ms.srt",""),".pt.srt",""),".tr.srt",""),".id.srt",""),".de.srt",""),".it.srt",""),".en.srt",""),".sv.srt",""),".vi.srt",""),".fr.srt",""),".ja.srt",""),".bs.srt",""),".en-gb.srt",""),".ru.srt",""),".nl.srt",""),".pt-br.srt",""),".bn.srt",""),".zh.srt",""),".es.srt",""),".en.srt",""),".ko.srt","") IN 
(SELECT page_title
FROM page
WHERE page_namespace=6);
SQL

Checking query status...
