Files without licences

SQL

SELECT
 CONCAT("# [[:File:", img_name, "]]") AS file, actor_name
###FROM templatelinks
###JOIN page ON tl_from = page_id
###JOIN image ON img_name = page_title AND page_namespace = 6
###JOIN actor_image ON img_actor = actor_id 
FROM image 
JOIN page 
ON page_namespace=6 
AND page_title = img_name
AND page_is_redirect=0 
AND NOT EXISTS(
SELECT * FROM categorylinks 
WHERE page_id=cl_from 
AND (cl_to="সকল_মুক্ত_মিডিয়া"
OR cl_to= "যুক্তরাষ্ট্রে_উন্মুক্ত_সকল_মিডিয়া"
OR cl_to= "Images_in_the_public_domain_in_the_United_States"
OR cl_to= "সকল_অ-মুক্ত_মিডিয়া"
    ))
    JOIN actor_image ON img_actor = actor_id 
Group BY img_name ASC
SQL

Checking query status...
