Files hiding Commons files - enwiki

SQL

USE enwiki_p;
SELECT wp.page_id FROM image wi
INNER JOIN commonswiki_p.image ci ON ci.img_name = wi.img_name AND 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', 'Now_Commons', 'Puf', 'Ffd', 'Deletable_file', # 'Deletable_file' = 'DI' templates
   'Pp-template', 'Keep_local_high-risk', 'Pp-upload', 'Protected_sister_project_logo') # Too many protected files which I don't know what to do with
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...
