Untitled query #49870

SQL

USE enwiki_p;
SELECT wp.page_id, CONCAT("File:",wp.page_title) as page_title, wi.img_sha1
FROM image wi
INNER JOIN page wp ON wp.page_title = wi.img_name AND wp.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', 
   /* 'Do_not_move_to_commons', */
  ## 'Puf', 
  ## 'Ffd', 
  ## 'Deletable_file', 
   'Db-nowcommons', 
   'Pp-template', 
   'Keep_local_high-risk', 
   'Keep_local',
   'Pp-upload',
   'C-uploaded',
   'Protected_sister_project_logo',
   'Rename_media',
   'ffd'
  ) 
WHERE wt.tl_from IS NULL
AND wi.img_name LIKE "th%"
SQL

Checking query status...
