File pages on Commons without files

SQL

USE commonswiki_p;
SELECT CONCAT('# [[:File:', REPLACE (page_title,'_',' '), ']]',
             IF (EXISTS (SELECT 1 FROM templatelinks JOIN linktarget ON lt_id = tl_target_id WHERE tl_from = page_id AND lt_namespace = 10 AND lt_title IN ('Delete', 'SD', 'Speedydelete')),
             ' (DR pending)', '')) AS p FROM page
LEFT JOIN (SELECT cl_from FROM categorylinks WHERE cl_to IN ('Commons_prohibited_file_names', 'Disambiguation/File')) ON cl_from = page_id
WHERE page_namespace = 6 AND page_is_redirect = 0
#AND c.cl_from IS NULL
#AND page_id NOT IN (SELECT cl_from FROM categorylinks WHERE cl_to IN ('Commons_prohibited_file_names', 'Disambiguation/File'))
AND page_id != 59501232 #File:DesiredFileName.ext
AND page_id != 132455928 #File:The Century Dictionary and Cyclopedia, vol. 3 (cu31924091890602).pdf
AND page_title NOT LIKE '%/%'
AND page_title NOT IN (SELECT img_name FROM image)
GROUP BY p
LIMIT 5;
SQL

Checking query status...
