#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