Riley
Veteran
Longest streak of breaking PB in any event in both single and average?
Odd WCA stats/ Stats request Thread
- Thread starter anders
- Start date
That70sShowDude
Veteran
Top 5 2x2 podium world records?
Tim Reynolds
Premium Member
Code:
2008ZOFF01 Tommaso Zoffoli 16
2009CHEN42 Minghao Chen (陈铭豪) 9
2011GRAS01 Pablo Grasböck 8
2011CHOI02 Ludwig Choi 8
2005REYN01 Tim Reynolds 8
2008QUDO01 Dongdong Qu (曲冬冬) 7
2011SELZ01 Daniel Selzer 7
2010JINY02 Yan Jin (金岩) 7
2008ZHAN06 Haixu Zhang (张海旭) 7
2007FODO01 Dániel Fodor 6
2005BAUM01 Jason Baum 6
Also interesting is http://www.worldcubeassociation.org/results/p.php?i=2010HUAN01: he is at 3, but all of them were in the same round.
Here's all the sub-10s:
Code:
GermanNationals2011 Mats Valk,Cornelius Dieckmann,Leonhard Kehrberger 249,261,313 823
WC2011 Feliks Zemdegs,Michał Pleskowicz,Nipat Charoenpholphant 271,274,289 834
DutchOpen2011 Milán Baticz,Bence Barát,Maarten Smit 253,282,321 856
NewarkH2H2012 Alex Koroglu,Andy Smith,Rowe Hessler 286,289,308 883
ParkRidgeOpen2011 Dan Cohen,Mike Kotch,Ethan Crislip 228,331,338 897
AsianChampionship2010 Feliks Zemdegs,Peerawich Hiranpaphakorn,Asia Konvittayayotin 235,324,352 911
KrungThepOpen2011 Nipat Charoenpholphant,Asia Konvittayayotin,Peerawich Hiranpaphakorn 272,302,340 914
USNationals2011 Anthony Brooks,Christopher Olson,Rowe Hessler 296,310,314 920
ShanghaiPortOpen2011 Nipat Charoenpholphant,Zhouheng Sun (孙舟横),Yinghao Wang (王鹰豪)306,308,313 927
CanadianOpen2011 Bill Wang,James Tu,Justin Jaffray 277,321,332 930
AustralianNationals2011 Feliks Zemdegs,Cameron Stollery,Florian Kreyssig 263,266,402 931
HungarianOpen2011 Bence Barát,András Szermek,Milán Baticz 308,315,318 941
Euro2010 Michał Pleskowicz,Mats Valk,Cornelius Dieckmann 283,336,338 957
SingaporeOpen2012 Zhou Yichen (周奕臣),Leong Wing Sik,Howard Wong Jun Yen 297,331,337 965
GermanOpen2012 Cornelius Dieckmann,Mats Valk,Sébastien Auroux 287,294,406 987
BridgewaterOpen2011 Rowe Hessler,Andy Smith,Zach Goldman 267,316,406 989
LyonOpen2011 Bence Barát,Kevin Guillaumond,Auguste Olivry 314,335,345 994
VCubeSpiel2011 Bence Barát,Erik Akkersdijk,Janis Leineweber 261,322,416 999
Michael Womack
Legend
- Joined
- Sep 4, 2011
- Messages
- 4,365
- Location
- Louisville, Kentucky, United States
- WCA ID
- 2010WOMA01
- YouTube
- Visit Channel
Why haven't WCA change the FM WR to 20 since it was proven but not at a WCA event?
Because nobody has presented a hand-found 20 move solution in a competition.
Robert-Y
Legend
Everyone who has an official success in 5BLD, has an official success in 4BLD. For a while, Zane and Stefan Pochmann didn't have a success in 4BLD. What's weird is that they are two opposites in speed and rank
bobthegiraffemonkey
Veteran
Everyone who has an official success in 5BLD, has an official success in 4BLD. For a while, Zane and Stefan Pochmann didn't have a success in 4BLD. What's weird is that they are two opposites in speed and rank
I wonder how many people a 4BLD success but not 5BLD, mainly as a percentage of the number of people with a 4BLD success.
vcuber13
Veteran
55 5bld
130 4bld
42% of people with 4bld success have a 5bld success, 58% do not.
130 4bld
42% of people with 4bld success have a 5bld success, 58% do not.
ottozing
Platinum Member
- Joined
- Aug 13, 2011
- Messages
- 3,303
- Location
- Canberra, Australia
- WCA ID
- 2012MCNE01
- YouTube
- Visit Channel
anyone wanna calculate the percentage of cubers who have only ever been to 1 official comp?
Sebastien
Premium Member
The answer to the question your formulated is 100%.
ottozing
Platinum Member
- Joined
- Aug 13, 2011
- Messages
- 3,303
- Location
- Canberra, Australia
- WCA ID
- 2012MCNE01
- YouTube
- Visit Channel
i meant like only 1, not more than 1, not less than 1. 1
bamilan
Regular
- Joined
- Feb 6, 2008
- Messages
- 147
- Location
- Nagykanizsa, Hungary
- WCA ID
- 2005BATI01
- YouTube
- Visit Channel
What are the top 3 closest podiums in each event? (I mean like magic at hungarian open 2010, podium was: 1.18, 1.20, 1.20, thats 0.02 difference)
TMOY
Veteran
Don't know if they are actually the closest but:
Square-1 at Spols Open 2011: 1st me 26.45, 2nd Jan 26.59, 3rd Lard 26.68.
5^3 at French Nats 2012: 1st Julien R. 1:30.64, 2nd Abdelhak 1:30.75, 3rd Kanneti 1:30.83.
Square-1 at Spols Open 2011: 1st me 26.45, 2nd Jan 26.59, 3rd Lard 26.68.
5^3 at French Nats 2012: 1st Julien R. 1:30.64, 2nd Abdelhak 1:30.75, 3rd Kanneti 1:30.83.
Cubenovice
Forever Slow
Bump:
What's the longest DNF streak at 3BLD before the first success ?
What's the longest DNF streak at 4BLD before the first success ?
and might add 5 BLD as well
What's the longest DNF streak at 3BLD before the first success ?
What's the longest DNF streak at 4BLD before the first success ?
and might add 5 BLD as well
Stefan
Legend
Code:
mysql> select a.competitionId, a.eventId, round(a.average/100,2) winner, round(b.average/100,2) third, round(b.average/100-a.average/100,2) difference
-> from (select competitionId, eventId, average from Results where average>0 and roundId in ('f','c') and pos=1) a,
-> (select competitionId, eventId, average from Results where average>0 and roundId in ('f','c') and pos=3) b
-> where a.competitionId=b.competitionId and a.eventId=b.eventId
-> order by 5
-> limit 100;
+---------------------------+---------+--------+-------+------------+
| competitionId | eventId | winner | third | difference |
+---------------------------+---------+--------+-------+------------+
| HungarianOpen2009 | magic | 1.18 | 1.18 | 0.00 |
| RubikkuChamp2012 | magic | 1.37 | 1.38 | 0.01 |
| BrusselsSummerOpen2009 | magic | 1.63 | 1.64 | 0.01 |
| USNationals2010 | 222 | 3.55 | 3.56 | 0.01 |
| SlovenianOpen2012 | magic | 1.32 | 1.33 | 0.01 |
| SingaporeOpen2010 | magic | 1.52 | 1.53 | 0.01 |
| DanishOpen2010 | magic | 1.75 | 1.77 | 0.02 |
[b]| HungarianOpen2010 | magic | 1.18 | 1.20 | 0.02 |[/b]
| BandungOpen2011 | 333 | 14.10 | 14.12 | 0.02 |
| DolmenOpen2011 | magic | 1.76 | 1.78 | 0.02 |
| BeneluxOpen2008 | magic | 1.76 | 1.78 | 0.02 |
| Netherlands2009 | magic | 1.50 | 1.53 | 0.03 |
| MadridOpen2008 | magic | 1.68 | 1.71 | 0.03 |
| CanadianCubingClassic2008 | magic | 1.54 | 1.57 | 0.03 |
| RobinsonsGalleriaOpen2011 | 222 | 4.13 | 4.16 | 0.03 |
| HongKongOpen2008 | mmagic | 3.35 | 3.38 | 0.03 |
| AustinFall2009 | magic | 2.10 | 2.13 | 0.03 |
| BeneluxOpen2009 | magic | 1.36 | 1.39 | 0.03 |
| GermanOpen2011 | magic | 1.21 | 1.25 | 0.04 |
| DauphineOpen2009 | magic | 1.63 | 1.67 | 0.04 |
| Altbier2011 | magic | 1.55 | 1.59 | 0.04 |
| WC2007 | magic | 1.19 | 1.23 | 0.04 |
| SwierklanyOpen2011 | magic | 1.49 | 1.54 | 0.05 |
| SemarangFunCube2011 | mmagic | 3.28 | 3.33 | 0.05 |
| FunFastingDay2011 | magic | 1.34 | 1.39 | 0.05 |
| RussiaOpen2011 | magic | 1.37 | 1.42 | 0.05 |
| OhioFall2011 | magic | 1.73 | 1.78 | 0.05 |
| NanjingSpring2012 | mmagic | 3.29 | 3.34 | 0.05 |
| WC2009 | magic | 1.01 | 1.06 | 0.05 |
| TaiwanSpringOpen2011 | 222 | 3.91 | 3.97 | 0.06 |
| NanjingSpring2011 | magic | 1.08 | 1.14 | 0.06 |
| XiningSummer2011 | magic | 1.39 | 1.45 | 0.06 |
| UkraineOpen2012 | 222 | 3.95 | 4.01 | 0.06 |
| NantesOpen2009 | magic | 1.54 | 1.60 | 0.06 |
| DutchNationals2010 | magic | 1.37 | 1.43 | 0.06 |
| ConnecticutSummer2009 | magic | 1.39 | 1.45 | 0.06 |
| MacauOpen2009 | magic | 1.02 | 1.08 | 0.06 |
| HoChiMinhCityOpen2011 | magic | 1.74 | 1.80 | 0.06 |
| KansaiOpen2012 | magic | 1.27 | 1.33 | 0.06 |
| NUS2011 | magic | 1.57 | 1.64 | 0.07 |
| SpanishChampionship2010 | magic | 1.45 | 1.52 | 0.07 |
| ShanghaiPortOpen2011 | 222 | 3.06 | 3.13 | 0.07 |
| SanFranciscoOpen2009 | magic | 1.59 | 1.66 | 0.07 |
| MinnesotaOpen2011 | magic | 1.58 | 1.65 | 0.07 |
| KansaiOpen2012 | 333 | 11.19 | 11.26 | 0.07 |
| PhilippinesOpen2009 | sq1 | 28.18 | 28.25 | 0.07 |
| CanadianOpen2007 | magic | 1.42 | 1.49 | 0.07 |
| BogorOpen2011 | magic | 1.73 | 1.80 | 0.07 |
| GenevaOpen2008 | magic | 1.66 | 1.73 | 0.07 |
| VancouverSummer2011 | magic | 1.73 | 1.81 | 0.08 |
| HenanUniversityOpen2011 | magic | 1.27 | 1.35 | 0.08 |
| DutchOpen2009 | magic | 1.52 | 1.60 | 0.08 |
| CaltechFall2011 | 333oh | 18.05 | 18.13 | 0.08 |
| RiverHillSpring2011 | magic | 1.87 | 1.95 | 0.08 |
| CachanOpen2011 | magic | 1.73 | 1.81 | 0.08 |
| VirginiaOpen2008 | magic | 1.65 | 1.73 | 0.08 |
| TrondheimFall2011 | 222 | 4.78 | 4.87 | 0.09 |
| CaltechFall2008 | 333oh | 22.55 | 22.64 | 0.09 |
| OsloOpen2010 | magic | 2.10 | 2.19 | 0.09 |
| USNationals2010 | magic | 1.29 | 1.38 | 0.09 |
| TorontoSummer2010 | 222 | 3.72 | 3.81 | 0.09 |
| BelgianOpen2011 | magic | 1.47 | 1.56 | 0.09 |
| CubingKoreaDecember2011 | magic | 1.63 | 1.72 | 0.09 |
| OsakaOpen2008 | magic | 1.38 | 1.47 | 0.09 |
| GuadalajaraOpen2010 | magic | 2.02 | 2.11 | 0.09 |
| XianYangling2012 | magic | 2.09 | 2.18 | 0.09 |
| DutchOpen2008 | magic | 1.24 | 1.33 | 0.09 |
| HenanOpen2010 | magic | 0.90 | 0.99 | 0.09 |
| Aplicarubick2011 | magic | 1.39 | 1.48 | 0.09 |
| MadridOpen2010 | magic | 1.39 | 1.48 | 0.09 |
| PleasantvilleFall2007 | magic | 1.34 | 1.43 | 0.09 |
| BelgianOpen2010 | magic | 1.41 | 1.50 | 0.09 |
| CyberOpen2011 | 333 | 11.72 | 11.82 | 0.10 |
| HungarianOpen2011 | 222 | 3.08 | 3.18 | 0.10 |
| HungarianOpen2011 | magic | 1.10 | 1.20 | 0.10 |
| ShenzhenSummerOpen2009 | magic | 0.99 | 1.09 | 0.10 |
| DixonOpen2011 | magic | 1.64 | 1.74 | 0.10 |
| MPEIOpen2011 | magic | 1.17 | 1.27 | 0.10 |
| AustrianOpen2012 | magic | 1.42 | 1.52 | 0.10 |
| Kuikuiltik2012 | magic | 1.35 | 1.45 | 0.10 |
| EastGermanOpen2010 | magic | 1.32 | 1.42 | 0.10 |
| PrincetonOpen2008 | magic | 1.32 | 1.42 | 0.10 |
| CaltechWinter2011 | magic | 1.83 | 1.93 | 0.10 |
| TorontoSpring2010 | magic | 1.22 | 1.32 | 0.10 |
| WashingtonDCWinter2011 | magic | 1.56 | 1.66 | 0.10 |
| SingaporeOpen2012 | magic | 1.13 | 1.23 | 0.10 |
| DutchMasters2008 | magic | 1.15 | 1.25 | 0.10 |
| Euro2006 | magic | 1.35 | 1.45 | 0.10 |
| SwedishCubedays2010 | 222 | 4.23 | 4.34 | 0.11 |
| SwedishChampionship2011 | magic | 1.33 | 1.44 | 0.11 |
| VancouverOpen2010 | magic | 1.44 | 1.55 | 0.11 |
| CzechOpen2011 | magic | 1.25 | 1.36 | 0.11 |
| BarcelonaSummerOpen2011 | magic | 1.39 | 1.50 | 0.11 |
| PoznanOpen2011 | magic | 1.22 | 1.33 | 0.11 |
| WC2011 | pyram | 4.67 | 4.78 | 0.11 |
| Netherlands2009 | 333 | 11.57 | 11.68 | 0.11 |
| MatsudoOpen2010 | magic | 1.22 | 1.33 | 0.11 |
| CubingSpringGrudziadz2012 | magic | 1.51 | 1.62 | 0.11 |
| NiagaraOpenSummer2008 | magic | 1.60 | 1.71 | 0.11 |
| DutchOpen2007 | magic | 1.34 | 1.45 | 0.11 |
+---------------------------+---------+--------+-------+------------+Sorry I didn't do "top 3 for each event", that's a bit harder. But here's the closest podiums by *ratio*, I find that more interesting anyway and there you also see many non-magic entries:
Code:
mysql> select a.competitionId, a.eventId, round(a.average/100,2) winner, round(b.average/100,2) third, b.average/a.average ratio
-> from (select competitionId, eventId, average from Results where average>0 and roundId in ('f','c') and pos=1) a,
-> (select competitionId, eventId, average from Results where average>0 and roundId in ('f','c') and pos=3) b
-> where a.competitionId=b.competitionId and a.eventId=b.eventId
-> order by 5
-> limit 100;
+-----------------------------+---------+--------+--------+--------+
| competitionId | eventId | winner | third | ratio |
+-----------------------------+---------+--------+--------+--------+
| HungarianOpen2009 | magic | 1.18 | 1.18 | 1.0000 |
| BandungOpen2011 | 333 | 14.10 | 14.12 | 1.0014 |
| France2012 | 555 | 90.64 | 90.83 | 1.0021 |
| PhilippinesOpen2009 | sq1 | 28.18 | 28.25 | 1.0025 |
| USNationals2010 | 222 | 3.55 | 3.56 | 1.0028 |
| CaltechFall2008 | 333oh | 22.55 | 22.64 | 1.0040 |
| CaltechFall2011 | 333oh | 18.05 | 18.13 | 1.0044 |
| VesoulOpen2011 | 555 | 125.95 | 126.60 | 1.0052 |
| FuglsangparkOpen2009 | 444 | 57.44 | 57.78 | 1.0059 |
| TaipeiOpen2011 | 444 | 44.28 | 44.54 | 1.0059 |
| BrusselsSummerOpen2009 | magic | 1.63 | 1.64 | 1.0061 |
| KansaiOpen2012 | 333 | 11.19 | 11.26 | 1.0063 |
| SingaporeOpen2010 | magic | 1.52 | 1.53 | 1.0066 |
| FrenchOpen2009 | 555 | 97.40 | 98.10 | 1.0072 |
| RubikkuChamp2012 | magic | 1.37 | 1.38 | 1.0073 |
| RobinsonsGalleriaOpen2011 | 222 | 4.13 | 4.16 | 1.0073 |
| SlovenianOpen2012 | magic | 1.32 | 1.33 | 1.0076 |
| SpanishChampionship2011 | 555 | 96.91 | 97.70 | 1.0082 |
| CyberOpen2011 | 333 | 11.72 | 11.82 | 1.0085 |
| SpolsOpen2011 | sq1 | 26.45 | 26.68 | 1.0087 |
| HongKongOpen2008 | mmagic | 3.35 | 3.38 | 1.0090 |
| MacauOpen2009 | 333 | 14.05 | 14.18 | 1.0093 |
| Netherlands2009 | 333 | 11.57 | 11.68 | 1.0095 |
| RizalOpen2009 | 444 | 69.49 | 70.16 | 1.0096 |
| TorontoOpenFall2008 | 555 | 110.28 | 111.37 | 1.0099 |
| TaiwanSummer2011 | 333 | 10.97 | 11.08 | 1.0100 |
| Aplicarubick2011 | 333 | 13.48 | 13.62 | 1.0104 |
| CaptainsCove2009 | 333 | 14.82 | 14.98 | 1.0108 |
| SanFranciscoOpen2009 | 444 | 58.56 | 59.19 | 1.0108 |
| GuangzhouSCUT2012 | 333oh | 20.00 | 20.22 | 1.0110 |
| HalloweenOpen2010 | 333oh | 21.58 | 21.82 | 1.0111 |
| ColegioCidade2010 | 555 | 172.59 | 174.54 | 1.0113 |
| DanishOpen2010 | magic | 1.75 | 1.77 | 1.0114 |
| BeneluxOpen2008 | magic | 1.76 | 1.78 | 1.0114 |
| DolmenOpen2011 | magic | 1.76 | 1.78 | 1.0114 |
| SafeHaven2010 | 444 | 53.15 | 53.77 | 1.0117 |
| HaNoiOpen2011 | 333 | 12.81 | 12.97 | 1.0125 |
| SlovenianOpen2010 | 444 | 52.59 | 53.26 | 1.0127 |
| IranOpen2011 | clock | 36.13 | 36.59 | 1.0127 |
| CMUSpring2012 | 444 | 59.19 | 59.95 | 1.0128 |
| HungarianOpen2008 | 555 | 110.42 | 111.86 | 1.0130 |
| GalantaOpen2009 | 333 | 15.20 | 15.40 | 1.0132 |
| SwedishCubeDay2009 | clock | 12.80 | 12.98 | 1.0141 |
| VirginiaOpen2008 | 333 | 12.75 | 12.93 | 1.0141 |
| SurabayaOpen2011 | 333oh | 23.71 | 24.05 | 1.0143 |
| AustinFall2009 | magic | 2.10 | 2.13 | 1.0143 |
| PhilippinesOpen2008 | 444 | 74.18 | 75.26 | 1.0146 |
| GuangzhouSummerVacation2011 | 333 | 11.60 | 11.77 | 1.0147 |
| CanadianOpen2009 | 777 | 316.68 | 321.39 | 1.0149 |
| SemarangFunCube2011 | mmagic | 3.28 | 3.33 | 1.0152 |
| UkraineOpen2012 | 222 | 3.95 | 4.01 | 1.0152 |
| NanjingSpring2012 | mmagic | 3.29 | 3.34 | 1.0152 |
| TaiwanSpringOpen2011 | 222 | 3.91 | 3.97 | 1.0153 |
| CebuOpen2009 | 555 | 115.23 | 116.99 | 1.0153 |
| TCAChampionship2011 | 333 | 10.40 | 10.56 | 1.0154 |
| BWOpen2012 | 555 | 85.49 | 86.81 | 1.0154 |
| OneToEight2011 | 555 | 84.12 | 85.42 | 1.0155 |
| LyonSinterklaasOpen2010 | minx | 135.58 | 137.76 | 1.0161 |
| PhilippinesOpen2009 | 444 | 61.06 | 62.05 | 1.0162 |
| MITSpring2010 | 333 | 12.12 | 12.32 | 1.0165 |
| DusseldorfOpen2010 | pyram | 7.85 | 7.98 | 1.0166 |
[b]| HungarianOpen2010 | magic | 1.18 | 1.20 | 1.0169 |[/b]
| USOpen2007 | 444 | 69.96 | 71.19 | 1.0176 |
| ShanghaiOpen2010 | 555 | 116.35 | 118.41 | 1.0177 |
| MadridOpen2008 | magic | 1.68 | 1.71 | 1.0179 |
| VirginiaOpen2008 | 333oh | 25.18 | 25.64 | 1.0183 |
| TorontoSpring2011 | pyram | 7.07 | 7.20 | 1.0184 |
| Korea2009 | 333oh | 21.25 | 21.64 | 1.0184 |
| BelgianOpen2007 | 333 | 14.04 | 14.30 | 1.0185 |
| SlovenianOpen2012 | 333 | 12.36 | 12.59 | 1.0186 |
| TrondheimFall2011 | 222 | 4.78 | 4.87 | 1.0188 |
| HungarianOpen2009 | 555 | 91.49 | 93.23 | 1.0190 |
| France2009 | 333 | 12.55 | 12.79 | 1.0191 |
| MatsudoAutumn2011 | 444 | 40.32 | 41.10 | 1.0193 |
| BialystokOpen2011 | 444 | 52.12 | 53.13 | 1.0194 |
| DauphineOpen2009 | 333 | 13.39 | 13.65 | 1.0194 |
| VancouverWinter2011 | 333 | 14.44 | 14.72 | 1.0194 |
| CanadianCubingClassic2008 | magic | 1.54 | 1.57 | 1.0195 |
| IndianaWinter2010 | 222 | 5.64 | 5.75 | 1.0195 |
| Tsukuba2012 | 444 | 40.10 | 40.89 | 1.0197 |
| CzechOpen2010 | 333oh | 22.11 | 22.55 | 1.0199 |
| CaltechSpring2007 | 333 | 16.08 | 16.40 | 1.0199 |
| Netherlands2009 | magic | 1.50 | 1.53 | 1.0200 |
| VCUBESpiel2010 | 555 | 78.45 | 80.03 | 1.0201 |
| LyonOpen2007 | 222 | 6.45 | 6.58 | 1.0202 |
| SwedishChampionship2011 | 333oh | 19.69 | 20.09 | 1.0203 |
| ItalianChampionship2010 | 333oh | 21.70 | 22.14 | 1.0203 |
| MNWOpen2011 | 333 | 11.79 | 12.03 | 1.0204 |
| KCRCBusan2007 | sq1 | 34.56 | 35.27 | 1.0205 |
| IsraelOpen2010 | 333 | 17.42 | 17.78 | 1.0207 |
| TorontoSummer2011 | 555 | 111.98 | 114.34 | 1.0211 |
| WC2007 | 444 | 62.37 | 63.69 | 1.0212 |
| HongKongCubeDay2010 | 444 | 55.60 | 56.78 | 1.0212 |
| SwedishCubedays2010 | 444 | 55.29 | 56.46 | 1.0212 |
| SuzhouOpen2011 | 444 | 48.96 | 50.01 | 1.0214 |
| JapanOpen2008 | 444 | 50.74 | 51.83 | 1.0215 |
| BicentenarioOpen2010 | 222 | 5.50 | 5.62 | 1.0218 |
| TorontoWinter2011 | 333 | 10.98 | 11.22 | 1.0219 |
| RzeszowOpen2010 | pyram | 6.35 | 6.49 | 1.0220 |
| OsakaOpen2008 | 333oh | 21.82 | 22.30 | 1.0220 |
+-----------------------------+---------+--------+--------+--------+
Last edited:
Tim Reynolds
Premium Member
Top 1 in each event: (note: this only looks for people in position 1 and position 3. If there is a tie for 2nd, or a 3-way tie for 1st, that result was not noticed. But that's really unlikely, since it needs to be a tie on average as well as best)
3x3: BandungOpen2011 (14.12 - 14.10 = 0.02)
4x4: TaipeiOpen2011 (44.54 - 44.28 = 0.26)
5x5: France2012 (1:30.83 - 1:30.64 = 0.19)
2x2: USNationals2010 (3.56 - 3.55 = 0.01)
3x3 BLD: UCSD2008 (1:43.43 - 1:41.47 = 1.96)
3x3 OH: CaltechFall2011 (18.13 - 18.05 = 0.08)
3x3 FM: numerous competitions, 1
3x3 Feet: VargardaOpen2011 (1:17.13 - 1:13.87 = 3.26)
Megaminx: LyonSinterklaasOpen2010 (2:17.76 - 2:15.58 = 2.18)
Pyraminx: WC2011 (4.78 - 4.67 = 0.11)
Square-1: PhilippinesOpen2009 (28.25 - 28.18 = 0.07)
Clock: SwedishCubeDay2009 (12.98 - 12.80 = 0.18)
6x6: HungarianOpen2010 (2:47.77 - 2:41.09 = 6.68)
7x7: CanadianOpen2009 (5:21.39 - 5:16.68 = 4.71)
Magic: HungarianOpen2009 (1.18 - 1.18 = 0.00)
Master Magic: HongKongOpen2008 (3.38 - 3.35 = 0.03)
4x4 BLD: AachenOpen2011 (9:30.50 - 8:41.22 = 49.28)
5x5 BLD: SwedishChampionship2011 (23:01.00 - 19:32.00 = 3:29.00)
3x3 Multi BLD: IndianOpen2011 (1/2 16:30 - 1/2 14:33 = 1:57)
1 competition: 10492/18112 (57.9%)
2 competitions: 2964/18112 (16.4%)
3 competitions: 1372/18112 (7.6%)
4 competitions: 822/18112 (4.5%)
5 competitions: 523/18112 (2.9%)
Only one person has been to exactly 36 competitions (Mika Muranushi - 2006MURA01). Nobody has been to 37 competitions; the next missing numbers are 50 and 51.
Stefan
Legend
Ok, top 3 for each event (though I forgot to mention that this is all just for events with averages, so the best-of events are missing).
Code:
+---------------------------------+---------+--------+---------+------------+
| competitionId | eventId | winner | third | difference |
+---------------------------------+---------+--------+---------+------------+
| USNationals2010 | 222 | 3.55 | 3.56 | 0.01 |
| RobinsonsGalleriaOpen2011 | 222 | 4.13 | 4.16 | 0.03 |
| TaiwanSpringOpen2011 | 222 | 3.91 | 3.97 | 0.06 |
| UkraineOpen2012 | 222 | 3.95 | 4.01 | 0.06 |
| BandungOpen2011 | 333 | 14.10 | 14.12 | 0.02 |
| KansaiOpen2012 | 333 | 11.19 | 11.26 | 0.07 |
| CyberOpen2011 | 333 | 11.72 | 11.82 | 0.10 |
| VargardaOpen2011 | 333ft | 73.87 | 77.13 | 3.26 |
| WC2011 | 333ft | 43.05 | 47.59 | 4.54 |
| Euro2010 | 333ft | 56.61 | 62.78 | 6.17 |
| CaltechFall2011 | 333oh | 18.05 | 18.13 | 0.08 |
| CaltechFall2008 | 333oh | 22.55 | 22.64 | 0.09 |
| GuangzhouSCUT2012 | 333oh | 20.00 | 20.22 | 0.22 |
| TaipeiOpen2011 | 444 | 44.28 | 44.54 | 0.26 |
| FuglsangparkOpen2009 | 444 | 57.44 | 57.78 | 0.34 |
| SafeHaven2010 | 444 | 53.15 | 53.77 | 0.62 |
| France2012 | 555 | 90.64 | 90.83 | 0.19 |
| VesoulOpen2011 | 555 | 125.95 | 126.60 | 0.65 |
| FrenchOpen2009 | 555 | 97.40 | 98.10 | 0.70 |
| HungarianOpen2010 | 666 | 161.09 | 167.77 | 6.68 |
| Euro2010 | 666 | 155.74 | 162.79 | 7.05 |
| AachenOpen2011 | 666 | 182.76 | 190.40 | 7.64 |
| CanadianOpen2009 | 777 | 316.68 | 321.39 | 4.71 |
| BandungDuaTujuh2011 | 777 | 276.55 | 282.94 | 6.39 |
| GermanOpen2009 | 777 | 291.12 | 299.91 | 8.79 |
| SwedishCubeDay2009 | clock | 12.80 | 12.98 | 0.18 |
| USOpen2008 | clock | 11.30 | 11.59 | 0.29 |
| StanfordFall2009 | clock | 12.76 | 13.08 | 0.32 |
| HungarianOpen2009 | magic | 1.18 | 1.18 | 0.00 |
| SlovenianOpen2012 | magic | 1.32 | 1.33 | 0.01 |
| SingaporeOpen2010 | magic | 1.52 | 1.53 | 0.01 |
| RubikkuChamp2012 | magic | 1.37 | 1.38 | 0.01 |
| BrusselsSummerOpen2009 | magic | 1.63 | 1.64 | 0.01 |
| LyonSinterklaasOpen2010 | minx | 135.58 | 137.76 | 2.18 |
| DutchOpen2011 | minx | 73.58 | 76.33 | 2.75 |
| SurabayaOpen2011 | minx | 80.06 | 83.72 | 3.66 |
| HongKongOpen2008 | mmagic | 3.35 | 3.38 | 0.03 |
| SemarangFunCube2011 | mmagic | 3.28 | 3.33 | 0.05 |
| NanjingSpring2012 | mmagic | 3.29 | 3.34 | 0.05 |
| WC2011 | pyram | 4.67 | 4.78 | 0.11 |
| DusseldorfOpen2010 | pyram | 7.85 | 7.98 | 0.13 |
| TorontoSpring2011 | pyram | 7.07 | 7.20 | 0.13 |
| PhilippinesOpen2009 | sq1 | 28.18 | 28.25 | 0.07 |
| SpolsOpen2011 | sq1 | 26.45 | 26.68 | 0.23 |
| USNationals2009 | sq1 | 20.57 | 21.20 | 0.63 |
+---------------------------------+---------+--------+---------+------------+Stefan
Legend
Oops, yeah, my stats have the same "problem".
And the full list for the how-many-cubers-have-been-at-X-competitions question:
Code:
mysql> select comps, count(*) persons, count(*)/18112*100 percentage from
-> (select personId, count(distinct competitionId) comps from Results group by personId) tmp
-> group by comps
-> order by comps;
+-------+---------+------------+
| comps | persons | percentage |
+-------+---------+------------+
| 1 | 10492 | 57.9284 |
| 2 | 2964 | 16.3648 |
| 3 | 1372 | 7.5751 |
| 4 | 822 | 4.5384 |
| 5 | 523 | 2.8876 |
| 6 | 391 | 2.1588 |
| 7 | 267 | 1.4742 |
| 8 | 215 | 1.1871 |
| 9 | 151 | 0.8337 |
| 10 | 133 | 0.7343 |
| 11 | 112 | 0.6184 |
| 12 | 78 | 0.4307 |
| 13 | 74 | 0.4086 |
| 14 | 53 | 0.2926 |
| 15 | 45 | 0.2485 |
| 16 | 41 | 0.2264 |
| 17 | 48 | 0.2650 |
| 18 | 37 | 0.2043 |
| 19 | 20 | 0.1104 |
| 20 | 38 | 0.2098 |
| 21 | 17 | 0.0939 |
| 22 | 15 | 0.0828 |
| 23 | 29 | 0.1601 |
| 24 | 12 | 0.0663 |
| 25 | 18 | 0.0994 |
| 26 | 17 | 0.0939 |
| 27 | 11 | 0.0607 |
| 28 | 13 | 0.0718 |
| 29 | 11 | 0.0607 |
| 30 | 7 | 0.0386 |
| 31 | 12 | 0.0663 |
| 32 | 7 | 0.0386 |
| 33 | 3 | 0.0166 |
| 34 | 3 | 0.0166 |
| 35 | 5 | 0.0276 |
| 36 | 1 | 0.0055 |
| 38 | 5 | 0.0276 |
| 39 | 2 | 0.0110 |
| 40 | 2 | 0.0110 |
| 41 | 4 | 0.0221 |
| 42 | 3 | 0.0166 |
| 43 | 2 | 0.0110 |
| 44 | 2 | 0.0110 |
| 45 | 3 | 0.0166 |
| 46 | 1 | 0.0055 |
| 47 | 1 | 0.0055 |
| 48 | 3 | 0.0166 |
| 49 | 2 | 0.0110 |
| 52 | 1 | 0.0055 |
| 53 | 1 | 0.0055 |
| 54 | 2 | 0.0110 |
| 55 | 1 | 0.0055 |
| 56 | 1 | 0.0055 |
| 57 | 1 | 0.0055 |
| 60 | 1 | 0.0055 |
| 61 | 1 | 0.0055 |
| 62 | 2 | 0.0110 |
| 63 | 1 | 0.0055 |
| 64 | 1 | 0.0055 |
| 66 | 1 | 0.0055 |
| 67 | 1 | 0.0055 |
| 68 | 1 | 0.0055 |
| 76 | 1 | 0.0055 |
| 82 | 1 | 0.0055 |
| 83 | 2 | 0.0110 |
| 85 | 1 | 0.0055 |
| 90 | 1 | 0.0055 |
| 92 | 1 | 0.0055 |
| 93 | 1 | 0.0055 |
| 94 | 1 | 0.0055 |
+-------+---------+------------+
70 rows in set (2.34 sec)bamilan
Regular
- Joined
- Feb 6, 2008
- Messages
- 147
- Location
- Nagykanizsa, Hungary
- WCA ID
- 2005BATI01
- YouTube
- Visit Channel
Thank you guys, that was quite interesting. Especially the magic podium tie.
Edit: spelling mistake
Edit: spelling mistake
Last edited:
lachose
Regular
Wait what ? All French competitions !
Similar threads
- Deleted member 36445
- General Speedcubing Discussion
