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

Fork of Files on ro.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, 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%' 
OR cl_to= "Tüm_adil_kullanım_dosyaları" # non-free files
OR cl_to= "Tüm_vikipedi%27deki_özgür_dosyalar" #Free files
    ))
###
#OR cl_to LIKE 'GFDL-B%'
#OR cl_to LIKE 'Public-Domain%'
###
GROUP BY img_name ASC

SQL

Checking query status...