Untitled query #86010

SQL

#USE viwiki_p;
SELECT
 CONCAT("# [[:File:", img_name, "]]") AS file, CONCAT("[[User:", actor_name, "]]") as uploader
 FROM image
JOIN page
 ON page_namespace = 6
AND page_title = img_name
JOIN actor_image ON img_actor = actor_id
JOIN categorylinks
 ON cl_from = page_id
AND cl_type = "file"
#AND cl_to = "No_license" # ENTER THE CATEGORY HERE
AND page_is_redirect=0 
AND NOT EXISTS(
SELECT * FROM categorylinks 
WHERE page_id=cl_from 
AND (cl_to="Hình_tự_do" 
OR cl_to= "Tất_cả_phương_tiện_truyền_thông_tự_do_ở_Hoa_Kỳ"
OR cl_to= "Hình_không_rõ_tình_trạng_bản_quyền" #Files tagged with no license
OR cl_to= "Hình_có_vấn_đề" #Files tagged with a problem tag
OR cl_to= "Hình_không_tự_do"))
GROUP BY img_name ASC
SQL

Checking query status...
