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

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

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

SQL

#USE bnwiki_p;
SELECT
 CONCAT("# [[:File:", img_name, "]]")  AS file, actor_name #, GROUP_CONCAT(c.cl_from SEPARATOR ' ¤¤¤ ')
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 LIKE 'Imagini_Creative_Commons%' 
cl_to= "All_free_media"
OR cl_to= "All_free_in_US_media" 
#OR cl_to LIKE "Imagini_din%" 
OR cl_to= "All_non-free_media"
    ))
###
#OR cl_to LIKE 'GFDL-B%'
#OR cl_to LIKE 'Public-Domain%'
###
GROUP BY img_name ASC

SQL

Checking query status...