All non-free files potentially public domain

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 templatelinks ON tl_from=p.page_id
join page ilp ON ilp.page_id=il_from
WHERE c1.cl_to = "All_non-free_media" AND  tl_title  IN(
"Non-free_use_rationale", 
"Non-free_use_rationale_logo", 
"Non-free_use_rationale_software_screenshot", 
"Non-free_use_rationale_2", 
"Non-free_use_rationale_poster", 
"Book_rationale", 
"Non-free_use_rationale_book_cover", 
"Manga_rationale", 
"Logo_fur", 
"Non-free_use_rationale_video_cover", 
"Non-free_use_rationale_title-card", 
"Non-free_media_rationale", 
"Navbox", "Non-free_film_screenshot") AND tl_title !="PD-India" AND
  
  tl_namespace= 10 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" )  
ORDER BY p.page_title ASC
SQL

Checking query status...
