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

Fork of Files on lb.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 tewiki_p;
SELECT
 CONCAT("# [[:File:", img_name, "]]") AS file, actor_name
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 
#FROM image 
#JOIN page 
#ON page_namespace=6 
AND page_title = img_name
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= "అన్నిరకాల_ఉచితం_కాని_దస్త్రాలు"
    ))
ORDER BY img_name ASC

SQL

Checking query status...