Toolserver:Query service/5

Image hash collisions
&lt;noinclude>

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

concat( '* [[Toolserver:
 * commons:Image:'

, db1.img_name , '|:commons:Image:' , db1.img_name , ']] = [[Toolserver:
 * nl:Image:'

, db2.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)


 * [[Toolserver:
 * commons:Image:AFBEELDING_027.jpg|:commons:Image:AFBEELDING_027.jpg]] = [[Toolserver:
 * nl:Image:ZEE.jpg|:nl:Image:ZEE.jpg]] (hash: 1o8vbi0akxd15ouni2o40yytgv7cko1)


 * [[Toolserver:
 * commons:Image:PosizioneComune.png|:commons:Image:PosizioneComune.png]] = [[Toolserver:
 * nl:Image:Stip.png|:nl:Image:Stip.png]] (hash: 2566utsgue754bx60mll7cxm1osbq7z)


 * [[:commons:Image:RedDo