Obsolete:Tool:Query service/40

Image hash collisions (no.wiki)

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.
Interval


Query

SELECT
 
CONCAT(
  '* [[: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.

Results

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