File pages on Commons without files

Fork of Bad links from wikis to Commons: redirects by Achim55

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

SQL

USE commonswiki_p;
SELECT CONCAT('# [[:File:', REPLACE (page_title,'_',' '), ']]',
              IF (EXISTS (SELECT 1 FROM templatelinks JOIN linktarget ON lt_id = tl_target_id AND lt_namespace = 10 WHERE tl_from_namespace = 6 AND lt_title = 'Delete' AND tl_from = page_id), ' DR pending', '')
             ) AS p FROM page
WHERE page_namespace = 6 AND page_is_redirect = 0
AND page_id NOT IN (SELECT cl_from FROM categorylinks WHERE cl_to IN ('Commons_prohibited_file_names', 'Disambiguation/File'))
AND page_title NOT LIKE '%/%'
AND page_title != 'DesiredFileName.ext'
AND NOT EXISTS (SELECT 1 FROM image WHERE img_name = page_title)
GROUP BY p
LIMIT 10;

SQL

Checking query status...