SQL
AخA
SELECT page_title
FROM page
WHERE page_namespace = 102
AND regexp_replace(page_title,'.[^.]+.srt','') NOT IN (
SELECT page_title FROM page WHERE page_namespace = 6
);
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.