Obsolete:Tool:Query service/5
This page contains historical information. It may be outdated or unreliable.
Image hash collisions
| 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 |
<noinclude>
Query
<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 <> ; </source>
Change <tt>commonswiki_p</tt> and <tt>nlwiki_p</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
This page was moved from toolserver:en:Query service/5. It's edit history can be viewed at Nova Resource:Tools/Tools/Query service/5/edithistory