Untitled query #45455

SQL

USE dewiki_p 
SELECT
 CONCAT("* [[:File:", img_name, "]]") AS file 
FROM image JOIN page ON img_name=page_title 
WHERE page_namespace=6 
AND page_is_redirect=0 
AND NOT EXISTS(
SELECT * FROM categorylinks 
WHERE page_id=cl_from 
AND (cl_to='By-Bild' 
OR cl_to LIKE 'CC-by%'
OR cl_to LIKE 'Datei:Public%'
OR cl_to LIKE 'Datei:Musik%'
OR cl_to LIKE 'Public-Domain%'
OR cl_to LIKE 'GFDL-B%'
OR cl_to='Frei-Bild'
OR cl_to='LogoSH-Bild'
OR cl_to='Datei:Wikimedia-Copyright'
OR cl_to='Datei:Musikzitat'
OR cl_to LIKE 'Wikipedia:Datei%'))
ORDER BY img_user_text ASC
SQL

Checking query status...
