Fork of
Untitled query #9244
by Sfan00 IMG
This query is marked as a draft
This query has been published
by ShakespeareFan00.
SQL
x
/* disabled as broken by changes to Replica design - see : https://lists.wikimedia.org/pipermail/cloud/2020-November/001290.html
Ideally the functionality this query provided should be provided in the API.
USE enwiki_p;
SELECT wp.page_id, CONCAT("File:",wp.page_title) as page_title 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',
'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'
)
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
*/
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.