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

Obsolete:Tool:Query service/40

From Wikitech-static
Jump to navigation Jump to search

Image hash collisions (

Description List of images with same SHA1 hashes between two wikis.
Assignee MZMcBride
JIRA bug DBQ-40
Source Query service/40#Query
Results Query service/40#Results
Approximate run time Less than 30 seconds.


  '* [[:commons:Image:'
, db1.img_name
, ']] = [[:no:Image:'
, db2.img_name
, ']] (hash: '
, db1.img_sha1
, ')'
) AS collision
FROM commonswiki_p.image db1
JOIN nowiki_p.image db2
  ON db1.img_sha1 = db2.img_sha1
WHERE db1.img_sha1 <> '';

Change commonswiki_p and nowiki_p to run against different wikis.


Last run: 21:23, 18 September 2008 (UTC)

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