Toolserver:Query service/5

This page was moved from the Toolserver wiki.
Toolserver has been replaced by Toolforge. As such, the instructions here may no longer work, but may still be of historical interest.
Please help by updating examples, links, template links, etc. If a page is still relevant, move it to a normal title and leave a redirect.

Image hash collisions[edit]

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
Interval

Category:Query service

Query[edit]

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 <> '';

Change commonswiki_p and nlwiki_p to run against different wikis.

Results[edit]

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:RedDot.png = nl:Image:Stip.png (hash: 2566utsgue754bx60mll7cxm1osbq7z)
commons:Image:Reddot2.png = nl:Image:Stip.png (hash: 2566utsgue754bx60mll7cxm1osbq7z)
commons:Image:Town_in_Ireland.png = nl:Image:Stip.png (hash: 2566utsgue754bx60mll7cxm1osbq7z)
commons:Image:Asd.ogg = nl:Image:Uitspraak_Republiek_Turkije_in_het_Turks.ogg (hash: 4ac2saqd6lo0on0tysgbjjtrzy3ul8e)
commons:Image:Illu_artery.jpg = nl:Image:Ader.jpg (hash: 55diko280nxum6logujbbt7jx9ix6re)
commons:Image:Drukbank.JPG = nl:Image:Drukbank.jpg (hash: 7uslh0lw7mkqyvntlnktgk9t6rah2jy)
commons:Image:Walenweeshuis_Maison_Descartes_Amsterdam_2007.JPG = nl:Image:Walenweeshuis.jpg (hash: 9n4fyevd1relz9n402e8zvxfcxcdckp)
commons:Image:Brusilov_Aleksei_in_1917.jpg = nl:Image:Brusilov_in_1917.jpg (hash: cim5wggi5ng5y00cde2ydr97s1jre0u)
commons:Image:Nl-Noord-Zuidlijn-article.ogg = nl:Image:Zuidlijn.ogg (hash: d38ro6n1hq1ivz8odzqt5gpz48ekv11)
commons:Image:Vierhuis_(Rohel)_04m.JPG = nl:Image:Vierhuis_(Rohel)_04.JPG (hash: dpt7a5zvswnjtoqs42egn9us7kyb86w)
commons:Image:Flag_of_Saint_Pierre_and_Miquelon_(WFB_2004).gif = nl:Image:Saint-Pierre_and_Miquelon_(Official).gif (hash: iopk0g6let5wmj66xivzs0ud4ls3bey)
commons:Image:Nij_Beets_Sudergemaal.JPG = nl:Image:Sudergemaal_10.JPG (hash: jrkr2ih9qoegsdscnsax5wy3xq7abmw)
commons:Image:Leeuwarden_3.jpg = nl:Image:Grote-_of_Jacobijnerkerk_Leeuwarden.jpg (hash: ka4s7te4k9yerb2tji7xirjmk5dxp7c)
commons:Image:Utrecht_Tolsteeg.JPG = nl:Image:Utrecht_Tolsteeg.jpg (hash: kta8dgu1665x5y7wh9f8n39sp85ybf9)
commons:Image:Fernando_Yamasaki2.JPG = nl:Image:Fernando_yamasaki2.jpg (hash: n14zdbpaiuma0yftx2m9zx0l1ajxllk)
commons:Image:HPIM0761.JPG = nl:Image:Tarkan,_door_Inge_Versteegt,_1996.JPG (hash: n29tbnge9g1xjn3aoqz6l8bzlmcc5gm)
commons:Image:Tarkan.JPG = nl:Image:Tarkan,_door_Inge_Versteegt,_1996.JPG (hash: n29tbnge9g1xjn3aoqz6l8bzlmcc5gm)
commons:Image:St.Jan.jpg = nl:Image:St._Jan_Waalwijk.jpg (hash: njglujjuh4quc50076m1n00jhth6mbc)
commons:Image:St._Jan.jpg = nl:Image:St._Jan_Waalwijk.jpg (hash: njglujjuh4quc50076m1n00jhth6mbc)
commons:Image:CacciniLeNuoveMusiche.jpg = nl:Image:Caccini_-_le_nuove_musiche.jpg (hash: o451j0kftrg9nronrdz9iiodcybi083)
commons:Image:Satyr_en_bacchante.jpg = nl:Image:Satyr-en-Bacchante.jpg (hash: q85g8k1irpyx0ovjduywbvxsj5w69ro)
commons:Image:SWIETEN.jpg = nl:Image:Swieten.jpg (hash: smn9akku25jgp9f8cyx62mztokf03lr)
commons:Image:Vliedberg_sHeer-Abtskinderen.JPG = nl:Image:Vliedberg_s'Heer-Abtskinderen.JPG (hash: sos13vb328tdaloude17uqglfmlism0)
commons:Image:Hongkou_Stadion.JPG = nl:Image:Hongkou_Stadion.jpg (hash: sui67xzkkdjocq5zfiez4n0c2jh7baz)
commons:Image:Team-2007.jpg = nl:Image:Hongkou_Stadion.jpg (hash: sui67xzkkdjocq5zfiez4n0c2jh7baz)