/* Disabled as query is not compatibale with the changes to Replicas design - see : https://lists.wikimedia.org/pipermail/cloud/2020-November/001290.html

​

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

  ('Salted_redirect',

    'ShadowsCommons',

   'Shadows_commons',

   'Now_Commons',

   'NowCommons',

   'Puf', 

   'Ffd', 

   'Proposed_deletion/dated_files',

   '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

   */

​