You are browsing a read-only backup copy of Wikitech. The live site can be found at

Obsolete:Tool:Query service/5

From Wikitech-static
Jump to navigation Jump to search

Image hash collisions

Description List of images with same SHA1 hashes between two wikis.
Assignee Siebrand
JIRA bug DBQ-5
Source Query service/image hash collisions#Query
Results Query service/image hash collisions#Results
Approximate run time below one minute on commons vs. nlwiki



<source lang="sql"> select


 '* [[:commons:Image:'

, db1.img_name , ']] = [[:nl:Image:' , db2.img_name , ']] (hash: ' , db1.img_sha1 , ')' ) as collision

from commonswiki_p.image db1

join nlwiki_p.image db2

 on db1.img_sha1 = db2.img_sha1

where db1.img_sha1 <> ; </source>

Change <tt>commonswiki_p</tt> and <tt>nlwiki_p</tt> to run against different wikis.


Last run: 21:09, 15 December 2007 (UTC)

This page was moved from toolserver:en:Query service/5. It's edit history can be viewed at Nova Resource:Tools/Tools/Query service/5/edithistory