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 |
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)