Files on oc.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 ocwiki_p;
SELECT
 CONCAT("# [[:File:", img_name, "]]") AS file, CONCAT("[[:User:", actor_name, "]]") as uploader
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
AND page_is_redirect=0 
AND NOT EXISTS(
SELECT * FROM categorylinks 
  WHERE page_id=cl_from )
##AND (cl_to="All_free_media" 
#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= "All_non-free_media"))
GROUP BY img_name ASC

SQL

Checking query status...