F8 Candidates.

SQL

USE enwiki_p;
SELECT wp.page_id, CONCAT("File:",wp.page_title) as page_title, CONCAT("File:", cp.page_title) FROM image wi
INNER JOIN commonswiki_p.image ci ON ci.img_sha1 = wi.img_sha1
INNER JOIN page wp ON wp.page_title = wi.img_name AND wp.page_namespace = 6
INNER JOIN commonswiki_p.page cp ON cp.page_title = ci.img_name AND cp.page_namespace = 6
LEFT JOIN templatelinks wt ON wt.tl_from = wp.page_id AND wt.tl_namespace = 10 AND wt.tl_title IN
  ('ShadowsCommons',
   'Shadows_commons',
   'Now_Commons',
   'NowCommons',
   'Puf', 
   'Ffd', 
   'Deletable_file', 
   'Db-nowcommons', 
   'Pp-template', 
   'Keep_local_high-risk', 
   'Keep_local',
   'Pp-upload',
   'C-uploaded',
   'Protected_sister_project_logo',
   'Rename_media',
   'FeaturedPicture',
   'Wrong-license',
   'DYKfile',
   'Split_media',
   'Nominated_for_deletion_on_Commons',
   'Deleted_on_Commons',
   'Already_moved_to_Commons',
   'Non-free_Philippines_government',
   'Userspace_file',
   'Esoteric_file',
   'PD-USonly',
   'PD-ineligible-USonly',
   'Do_not_move_to_commons',
   'Do_not_move_to_Commons', 
   'PD-1923-abroad',
   'PD-US-1923-abroad',
   'Not-PD-US-URAA',
   'Non-free_use_rationale',
   'Non-free_use_rationale_2'
   /*
   */
  ) 
LEFT JOIN commonswiki_p.templatelinks ct ON ct.tl_from = cp.page_id AND ct.tl_namespace = 10 AND ct.tl_title = 'Deletion_template_tag'
WHERE wt.tl_from IS NULL
AND ct.tl_from IS NULL
SQL

Checking query status...
