Query service/5

Image hash collisions
&lt;noinclude>

Query
&lt;source lang="sql"> select

concat( '* 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 &lt;> ''; &lt;/source>

Change &lt;tt>commonswiki_p&lt;/tt> and &lt;tt>nlwiki_p&lt;/tt> to run against different wikis.

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


 * commons:Image:AFBEELDING_027.jpg = nl:Image:ZEE.jpg (hash: 1o8vbi0akxd15ouni2o40yytgv7cko1)
 * commons:Image:PosizioneComune.png = nl:Image:Stip.png (hash: 2566utsgue754bx60mll7cxm1osbq7z)
 * [[:commons:Image:RedDo