Files on fy.wiki NOT in spec categories (no license)

Fork of Files on vi.wiki NOT in spec categories (no license) by MGA73

This query is marked as a draft This query has been published by MGA73.

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="Cc-by-sa-3.0_of_letter_en_GFDL_Ofbyld" 
OR cl_to= "GFDL_Ofbyld"
OR cl_to= "Frij_Ofbyld" #Files tagged with no license
OR cl_to= "Unfrij_ôfbyld" #Files tagged with a problem tag
OR cl_to= "Frijkaam_Ofbyld"))
GROUP BY img_name ASC

SQL

Checking query status...