All non-free files potentially public domain

All non-free files  used in Telugu film articles with film release before 1962 (as of 2022) to qualify as public domain. Need  manually review for further action to weed out false positives.

SQL

SELECT
    DISTINCT (CONCAT("File:",p.page_title)) as filename
    
from  page p
join image ON  p.page_namespace=6  AND p.page_title=img_name
JOIN categorylinks c1 ON p.page_id = c1.cl_from
JOIN imagelinks i ON p.page_title = i.il_to AND i.il_from_namespace =  0
join page ilp ON ilp.page_id=il_from
WHERE c1.cl_to = "All_non-free_media"   AND   ilp.page_id IN (
SELECT
     page_id
FROM page p
JOIN categorylinks cl
ON p.page_namespace = 0 -- main page
AND cl.cl_from = p.page_id       AND cl.cl_to LIKE "%తెలుగు_సినిమాలు"  AND LEFT(cl.cl_to,4) < "1962" )

EXCEPT (
 SELECT
  DISTINCT (CONCAT("File:",p2.page_title)) as filename
 FROM page p2
 LEFT JOIN categorylinks c2 ON p2.page_id = c2.cl_from
  Where c2.cl_to LIKE "Wikipedia_non-free_files_for_NFUR_%" OR  cl_to ="All_free_media" )

LIMIT 1000;

SQL

Checking query status...