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

Fork of Files on an.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="Сите_слободни_податотеки" #Free files
#OR cl_to= "Hình_không_rõ_tình_trạng_bản_quyền" #Files tagged with no license
OR cl_to= "Сите_неслободни_податотеки")) #Non-free files
GROUP BY img_name ASC

SQL

Checking query status...