Jump to content

User:Topbanana/Eclipsed Files

From Wikipedia, the free encyclopedia

This report lists the first 500 files that exist on both the English-language Wikipedia and on commons that have identical filenames but differing SHA-1 keys. Entries in Category:Wikipedia files on Wikimedia Commons for which a local copy has been requested to be kept are suffixed with "** marked as local copy required **". It was generated on the tool labs by TB (talk) 20:36, 10 June 2016 (UTC)


MariaDB [enwiki_p]>


Regenerating this report:

SELECT concat( '*[[:commons:file:', c.img_name, ']] (', c.img_width, 'x', c.img_height, ', ', c.img_size, ' bytes) eclipsed by [[:file:', e.img_name, ']] (', e.img_width, 'x', e.img_height, ', ', e.img_size, ' bytes)', IF( ec.cl_to IS NULL, '', ' ** marked as local copy required **') ) 
FROM enwiki_p.image e 
INNER JOIN commonswiki_p.image c ON c.img_name = e.img_name 
INNER JOIN enwiki_p.page ep ON ep.page_title = e.img_name AND ep.page_namespace = 6 
LEFT OUTER JOIN enwiki_p.categorylinks ec ON ep.page_id = ec.cl_from AND ec.cl_to = 'Wikipedia_files_on_Wikimedia_Commons_for_which_a_local_copy_has_been_requested_to_be_kept'
WHERE c.img_sha1 != e.img_sha1
LIMIT 500;