Toolserver:Query service/40

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

Category:Query service

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)

• commons:Image:Haalogaland_kart.jpg = no:Image:Haalogaland_kart.jpg (hash: 2hg4pc7z7sg6z5uswfyd7vd9k99mxo7)
• commons:Image:BGorange1.jpg = no:Image:BGorange1.jpg (hash: 34le16u3ttasi55w1sb51osp8yke2io)
• commons:Image:Ung-filosof.jpg = no:Image:Ung-filosof.jpg (hash: 3khqjtozrcrp7amfs6f9oa303wgutt8)
• commons:Image:Dorset_Sturminster_Newton_Bridge_notice.jpg = no:Image:Dorset_stur_br_notice.jpg (hash: 74po6vbn9c5e4k5kw1ur9bt49i845i5)
• commons:Image:Edinpain.JPG = no:Image:EdinburghCastleMaleri.JPG (hash: 8jdbxzy6xapuctykayxhojavniq5718)
• commons:Image:Hornindalsvatnet.jpg = no:Image:Hornindalsvatnet.jpg (hash: 8pkoda2y036v3mun59wt6eaz17zejnh)
• commons:Image:Watteau_Fetes_venitiennes.jpg = no:Image:Watteau_Les_Fetes_venitiennes.jpg (hash: 8rvbuot47l50kllg56a04vhirrmctsj)
• commons:Image:Oerje03052006.jpg = no:Image:Oerje030506.jpg (hash: 9gxzlbq21kp7qdzp7tgva8xdfkpz9a4)
• commons:Image:Toke_ya_Okt_2004.JPG = no:Image:Toke_Øya_Okt_2004.JPG (hash: 9qmg44migfizcha20h8c48nkzrjoi1b)
• commons:Image:Sturgeon2.jpg = no:Image:Stør.jpg (hash: b34kya3z6xhubnf63dljt22ipqp09yv)
• commons:Image:St-Peterburg-Canal.jpg = no:Image:St-Peterburg-Canal.jpg (hash: b7ihfb9bgxljdedp55qz712kyoycte5)
• commons:Image:Autoroute_M25.jpg = no:Image:Motorwaym25_midas.jpg (hash: bko58qx26opunajd38asguu8kc2fz0b)
• commons:Image:Aron-Oscarsborg-Fortress.jpg = no:Image:Aron-Oscarsborg-fortress.jpg (hash: bma8vqllra62cbpyhmuyoevzxbzdk6f)
• commons:Image:Indulgence.png = no:Image:Avlatsbrev.PNG (hash: bugrbybak4m5mebomzy2fj8buwr5huc)
• commons:Image:Eugenio_Preobrazhenski.jpg = no:Image:Preobrazhensky.jpg (hash: cjf1g0ba907bf4696vzt3nzd0u2fddg)
• commons:Image:Korean_dmz_map.png = no:Image:Korea_dmz_kart.png (hash: cvp6xe2171j1kkuqwj7tts2ehb4yjxf)
• commons:Image:Sine_waves_different_frequencies.png = no:Image:Frekvenser_art_1.png (hash: d47z2wlr9557l16vnznwqfliu6yv24a)
• commons:Image:Logo_user_steller.jpg = no:Image:Logo_user_steller.jpg (hash: fi7f2v00ito2m54fmz6im45acb07qbu)
• commons:Image:Qsicon_exzellent.png = no:Image:Utmerket.png (hash: g834xq4pciwaj3cx3xmehq8nw9zms5t)
• commons:Image:Torquay.devon.750pix.jpg = no:Image:Torquay.jpg (hash: gangp9oeknnpvks2l4av19vxdflrcbz)
• commons:Image:DNA-structure-and-bases.png = no:Image:DNA-struktur-og-baser.png (hash: gbcsu3xrpnadokja3vp4cx6lexib0zn)
• commons:Image:Birth_and_Origin_of_the_Pope_by_Lucas_Cranach.jpg = no:Image:Luthart1.jpg (hash: giflxfx5nctesmgc1u280hmcgh5eh2b)
• commons:Image:Gjesvær.jpg = no:Image:Nordkapp_Gjesvær.JPG (hash: gqbhotjvj0x4da2hnp8314tcm120yyo)
• commons:Image:Weisser_Wolf_Berlin_ca_1998.jpg = no:Image:Weisser.Wolf_Berlin_ca.1998.jpg (hash: gyy0yqyttbm50du7e7v2q5gv9r6k897)
• commons:Image:LocatieVeerseMeer.png = no:Image:LocatieVeerseMeer.png (hash: gzbic7r1e42mn12a3il3v05bg87zswt)
• commons:Image:BGorange2.jpg = no:Image:BGorange2.jpg (hash: h15a9a37r87nzy9dnparuinppvhp6u4)
• commons:Image:Kasparov-Topalov.jpg = no:Image:Kasparov-topalov.jpg (hash: h8peebzhdk6d7fsu4waitp8ejengeoa)
• commons:Image:Tollbugata_Oslo.jpg = no:Image:Tollbugata.jpg (hash: hmcx7apnd7st93js0qhyxeelh4a88gt)
• commons:Image:Lindesnes_fyr_natt.jpg = no:Image:Lindesnes_fyr_natt_2.jpg (hash: iquoa3ddnultli1y8ch37lwbzb1tm6l)
• commons:Image:Obi-knot.png = no:Image:Obi-knute.png (hash: ivas045rx13n9r868f1ylry7zch09hn)
• commons:Image:Uk-winchester-cathedral.jpg = no:Image:Winchesterkatedralen1.jpg (hash: j2odbx4b984pvjw6olp36g6ss50yotl)
• commons:Image:Adelaide_of_Italy.jpg = no:Image:Adelheidburgund.jpg (hash: jjlr8d5888gmk4tphssg9r6pkqqkkgv)
• commons:Image:Regular_pentagon.png = no:Image:Likebent-pentagon.png (hash: jovgrqpajhlyruwi30pqhug935mxjrm)
• commons:Image:Norwegian_Buhund_600.jpg = no:Image:Norsk_buhund_gu-tb_600.jpg (hash: js515tr1wazp771vw7z40rmbec6jzi4)
• commons:Image:TXMap-doton-Waco.PNG = no:Image:TXMap-doton-Waco.png (hash: jvd85ggzf01989xnk0ipz0ujk5x5w4e)
• commons:Image:Hirnhaut.png = no:Image:Hjernehinner.png (hash: jz7e3r5s5c34mimt0kpnkmw32rlbttv)
• commons:Image:Singsaker_Studenterhjem.jpg = no:Image:IMG_4152.JPG (hash: keyfbi1psm40spid2hyyhshfe8wciz3)
• commons:Image:Maltoscannabis.png = no:Image:Maltoscannabis.png (hash: knd62toz81y0w8czm7zejf6qvzvzuxu)
• commons:Image:Riverton.gif = no:Image:Riverton.gif (hash: kogr5bz3esmyps1xna531xnp0f6vduc)
• commons:Image:Cdoppler.jpg = no:Image:Christian_Andreas_Doppler.jpg (hash: l4y18cp0uxp64pd9jzopsqkhesmsp89)
• commons:Image:Scyphomedusae_Chrysaora_melanaster.jpg = no:Image:Stormanet.jpg (hash: la9su0m8rzv4g1ztyf01giacmu7t4o3)
• commons:Image:Steigen_Almennighetsvatnet.JPG = no:Image:100_2618.JPG (hash: lda6cijtrgxgvindtboiq59ja4rrtyk)
• commons:Image:Westerscheldetunnel-1.jpg = no:Image:Westerscheldetunnel.jpg (hash: ljs9d4sf08nu80aq7ysl4may7kvo0vm)
• commons:Image:Nijmegen.jpg = no:Image:NijmegenGroteMarkt.jpg (hash: m1hck2jaccgbx8lmekaslwc77vsexoz)
• commons:Image:Aksel2.jpg = no:Image:Image-Aksel2.jpg (hash: mjtdc1mwbm3hjfckuw406gp8qq2ywpg)
• commons:Image:Mylogo.jpg = no:Image:Nohat-logo-nowords-bgwhite-200px.jpg (hash: n02ib2z4tpxwzaji7lle3ryva9p20sf)
• commons:Image:Map_of_Alabama_highlighting_St_Clair_County.svg = no:Image:Map_of_Alabama_highlighting_St._Clair_County.svg (hash: nce4vbff8ri5tlw75ez82ihllwwwef6)
• commons:Image:First_Chinese_Japanese_war_map_of_battles.jpg = no:Image:Jianwuzhanzheng_english.jpg (hash: o62q5m0ne90l82qwsnfhth04ifucue0)
• commons:Image:GemeentenZuid-HollandNrs.png = no:Image:KommunerZuid-HollandNrs.png (hash: o8q5e6rjgds4b5hp4f7y5abtc4uwpee)
• commons:Image:Pohjois-Savon_vaakuna.png = no:Image:Norra_Savolax_Våpen.png (hash: os8sqqlpmbjwh00ld7ue1d2l249ixyz)
• commons:Image:Gessner_Conrad_1516-1565.jpg = no:Image:Gessner.jpg (hash: oym9afpo8goeydb9vymanct8a9zcy0p)
• commons:Image:Steigen_breivikamotbrattfjorden.jpg = no:Image:Steigen_breivikamotbrattfjorden.jpg.JPG (hash: p6jhhnbjpd30ycgyru6b8gksh1e2k0b)
• commons:Image:DSC00030.jpg = no:Image:Viktor-André.jpg (hash: pcnykyrb1h5sbebi9i3x48mrz4vjt38)
• commons:Image:Maison_carree_side.jpg = no:Image:Maison_carree_korintisk.jpg (hash: q4cslgfl0fwjayyis99mnhvoschum51)
• commons:Image:Insulin_synthesis.png = no:Image:Insulin_syntese.png (hash: qa13gqd84u8b5fcx2v602nbwjcgvvpx)
• commons:Image:Steingjerde_Sotre_(sauegjerde).JPG = no:Image:Steingjerde_Sotra_(sauegjerde).jpg (hash: qvdkl37alhchehpzm260aialr47a4di)
• commons:Image:Rådhuset_Bergen.jpg = no:Image:Rådhuset.i_bergen.jpg (hash: r4pdkcu48uxpln78dylmh1dorlrvlnm)
• commons:Image:Pancreas.jpg = no:Image:Pancreas.jpeg (hash: rf5nfzqy5f4cv1iuigajde07o7q5j4e)
• commons:Image:Capture_of_Landskrona-Claus_Møinichen.jpg = no:Image:Landskronas_erobring_maleri_av_Claus_Moinichen_1686.jpg (hash: s0zcag7ckddbkk32vofsk9xjkquceo4)
• commons:Image:Order_of_Merit_Dorothy_Hodgkin.jpg = no:Image:HodgkinOM20040420CopyrightKaihsuTai.jpg (hash: s8zvqu8dioia8a61xxf77j5fh5jgy5g)
• commons:Image:Isola_di_Utopia_Moro.jpg = no:Image:Thomas_Mores_Utopia.jpg (hash: t2ponp2a1f3t3gtnqm8jod97pu6u7bm)
• commons:Image:Stave_church_construction.jpg = no:Image:Stavkirkekonstruksjon.jpg (hash: tdw86ctd8fyxdrm1nt1lj3635xmq017)
• commons:Image:Ezzard_Charles.jpg = no:Image:EzzardCharles.jpg (hash: tjy0yyz371q8t43ufp0ghv910barn7s)