Orphaned File pages

SQL

USE commonswiki_p;
SELECT concat("File:",page_title )
#SELECT count(*) 
FROM page 
LEFT JOIN image ON page_title=img_name 
INNER JOIN categorylinks ON  page_id = cl_from
WHERE page_namespace=6 
AND page_is_redirect=0 
AND page_title NOT LIKE '%/%' -- skip rare image subpages 
AND img_name IS NULL
AND cl_to IN ("Media_missing_infobox_template", 
                "Artworks_missing_infobox_template", 
                "Items_with_OTRS_permission_missing_infobox_template",
                "Pages_using_Information_template_with_parsing_errors") 
AND NOT EXISTS ( 
  SELECT * 
  FROM templatelinks 
  WHERE page_id = tl_from 
  AND tl_title in ('Delete') 
  AND tl_namespace = 10 
)
SQL

Checking query status...
