Login
Login

User:Topbanana/Eclipsed Files

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;