ben1996123
Banned
This isn't really a statistic, but here are some profiles with weird things in 'em:
2007CHAN03 - WTF is that last 3x3 average?
Maybe he broke his arm and did OH or something.
This isn't really a statistic, but here are some profiles with weird things in 'em:
2007CHAN03 - WTF is that last 3x3 average?
I fixed these. I could not find 2010DOLP01 anymore and 2009BINK01 had 3 10.00s, I remember that happening.2007CHAN03 - WTF is that last 3x3 average? This guy is the only person out there with a CR worse than a WR in an event. I'm almost thinking someone else's results got put on his profile.
2011KOEB01 - a 5:38:00.00 5x5x5 time! Surely that's an error.
2011LIJI04 - a 1:07:51.00 3x3x3 time, same as above.
2012FAZD01 - 36:26.00 3x3x3 time, same as above.
2010DOLP01 - I dunno what it is, but I think this guy's name might be fake
2009BINK01 - three 10.00s in one Pyraminx round :O
I'd be happy to email it to you, but it's in a language called q, not in SQL. So it probably won't be very useful for you.Btw, Michael, thanks for notifying us. Please email me your query, then I can add it to my annual check process for the WCA database.
Regarding 2010DOLP01, Baiqiang found out that 3 persons were registered members under a nickname, so he took action.
Most historical WRs (all people with 5+):Would it be possibel to make a list with the people who broke more WRs and CRs (separate lists) in any event?
Like, Feliks has about 40 WRs, counting 3x3, OH, 4x4, etc.
personId x personName
2009ZEMD01 45 Feliks Zemdegs
2005AKKE01 33 Erik Akkersdijk
2003MAKI01 21 Shotaro Makisumi
2003POCH01 21 Stefan Pochmann
2006HALC01 19 Michał Halczuk
2006KUTI01 17 Mátyás Kuti
2003HARD01 16 Chris Hardwick
2007COHE01 16 Dan Cohen
2003VAND01 13 Lars Vandenbergh
2005VANH01 12 Anssi Vanhala
2009WANG13 11 Yuxuan Wang
2004KRIG01 10 Gunnar Krig
2004PATR01 10 Ryan Patricio
2006OKAY01 9 Yohei Oka
2003SCHE01 8 Jaap Scherphuis
2007NAKA03 8 Yu Nakajima
2008SEPP01 7 Ville Seppänen
2009HAYS01 7 Kevin Hays
2003MORR01 6 Frank Morris
2004CHAM01 6 Edouard Chambon
2006OOKU01 6 Takayuki Ookusa
2006TABU02 6 Yumu Tabuchi
2007ENDR01 6 Marcell Endrey
2008ZHUA01 6 Haiyan Zhuang
2003BURT01 5 Bob Burton
2005LUCZ01 5 Grzegorz Łuczyna
2006PRUS01 5 Grzegorz Prusak
2007HORV01 5 Máté Horváth
2008ANDE02 5 Oscar Roth Andersen
2008BARA01 5 Bence Barát
2008BODO01 5 Bálint Bodor
2008LIBI01 5 Bingliang Li
2010CHEN20 5 Lin Chen
query:
processName:{rtrim ((x?"(")-count x)_x:string x}
`x xdesc select sum[regionalSingleRecord=`WR]+sum regionalAverageRecord=`WR, processName last personName by personId from results
personId x personName
2009ZEMD01 130 Feliks Zemdegs
2007COMP01 126 Emile Compion
2007COHE01 83 Dan Cohen
2007GUIM01 79 Pedro Santos Guimarães
2005AKKE01 54 Erik Akkersdijk
2006HALC01 37 Michał Halczuk
2003MAKI01 36 Shotaro Makisumi
2009BARB01 36 Gabriel Dechichi Barbar
2009BEAR01 34 Dene Beardsley
2003LEEJ01 33 Jasmine Lee
2008NUNE01 33 Gabriel Eduardo Núñez Serna
2003HARD01 30 Chris Hardwick
2007HESS01 30 Rowe Hessler
2007LIJO01 30 Joshua Li
2007NAKA03 27 Yu Nakajima
2003POCH01 24 Stefan Pochmann
2006TABU02 24 Yumu Tabuchi
2003VAND01 23 Lars Vandenbergh
2003MORR01 21 Frank Morris
2004PATR01 20 Ryan Patricio
2007CINO01 20 Rafael Werneck Cinoto
2006KUTI01 19 Mátyás Kuti
2006OOKU01 18 Takayuki Ookusa
2003BURT01 17 Bob Burton
2006OKAY01 17 Yohei Oka
2004KRIG01 16 Gunnar Krig
2005VANH01 16 Anssi Vanhala
2009MACA01 16 Matias Macaya
query:
`x xdesc select sum[not regionalSingleRecord in ``NR]+sum not regionalAverageRecord in ``NR, processName last personName by personId from results
personId x personName
2006BUUS01 213 Henrik Buus Aagaard
2005AKKE01 179 Erik Akkersdijk
2005BATI01 135 Milán Baticz
2009ZEMD01 135 Feliks Zemdegs
2007COMP01 132 Emile Compion
2010MOND01 124 Pablo Nicolás Oshiro Mondoñedo
2004KRIG01 117 Gunnar Krig
2003VAND01 113 Lars Vandenbergh
2008WEST02 110 Simon Westlund
2009MAGN02 105 Hilmar Magnusson
2007GUIM01 100 Pedro Santos Guimarães
2009BEAR01 95 Dene Beardsley
2008BARA01 93 Bence Barát
2007COHE01 87 Dan Cohen
2003POCH01 84 Stefan Pochmann
2009BALT02 83 Leandro Baltazar
2006ORLA01 81 Bernett Orlando
2008HANK01 78 Kanneti Sae Han
2006GARR01 77 Lucas Garron
2008SEAR01 77 Anthony Brooks
2008NUNE01 76 Gabriel Eduardo Núñez Serna
2009BAUM01 74 Conor Baumann
2005VANH01 73 Anssi Vanhala
2006ZAHR01 73 Martin Zahradník
2003HARR01 72 Dan Harris
2007VALL01 72 Breandan Vallance
2007HUBE01 70 Stefan Huber
query:
`x xdesc select sum[regionalSingleRecord<>`]+sum regionalAverageRecord<>`, procesSName last personName by personId from results
WRs:
personId x comps personName ratio
2009ZEMD01 45 14 Feliks Zemdegs 3.214286
2006KUTI01 17 11 Mátyás Kuti 1.545455
2003WESL01 3 2 David Wesley 1.5
2005FUNG01 4 3 Michael Fung 1.333333
1982THAI01 1 1 Minh Thai 1
2003BELL01 1 1 Andy Bellenir 1
2003BOND01 1 1 Jess Bonde 1
2004GODF01 1 1 Mike Godfrey 1
2005ARNO01 1 1 Will Arnold 1
2005HAYA01 4 4 Yuki Hayashi 1
2009HEDI01 3 3 Claes Hedin 1
CRs:
personId x comps personName ratio
2007LIJO01 30 2 Joshua Li 15
2009ZEMD01 130 14 Feliks Zemdegs 9.285714
2007COMP01 126 25 Emile Compion 5.04
2008NUNE01 33 7 Gabriel Eduardo Núñez Serna 4.714286
2007GUIM01 79 17 Pedro Santos Guimarães 4.647059
2009BARB01 37 11 Gabriel Dechichi Barbar 3.363636
2003WESL01 6 2 David Wesley 3
2011HAUP01 7 3 Jacobus Philip Haupt 2.333333
2004NOWI01 4 2 Jarosław Nowicki 2
2007AMAN01 4 2 Etienne Amany 2
2009KOBA04 10 5 Rodrigo Kenji Asato Kobayashi 2
NRs:
personId x comps personName ratio
2012DOOF02 16 1 Zeid Doofesh 16
2007LIJO01 30 2 Joshua Li 15
2011KUDA01 58 4 Nurym Kudaibergen 14.5
2009KIMA01 64 5 Anatoly Kim 12.8
2010MOND01 124 10 Pablo Nicolás Oshiro Mondoñedo 12.4
2011VAIT01 35 3 Lukas Vaitkevicius 11.66667
2008NUNE01 76 7 Gabriel Eduardo Núñez Serna 10.85714
2012ZIVK01 21 2 Milutin Živković 10.5
2006ZAHR01 73 7 Martin Zahradník 10.42857
2010VYNN01 72 7 Ivan Vynnyk 10.28571
2011GUCU01 29 3 Can Gücüyener 9.666667
2009ZEMD01 135 14 Feliks Zemdegs 9.642857
2009MAGN02 105 11 Hilmar Magnusson 9.545455
2010BOWE01 19 2 Blake Bowers 9.5
2010DRVE01 19 2 Alex Drvenkar 9.5
queries:
processName:{rtrim ((x?"(")-count x)_x:string x}
`ratio xdesc update ratio:x%comps from
select sumregionalSingleRecord=`WR]+sum regionalAverageRecord=`WR,
comps:count distinct competitionId, processName last personName by personId from results
`ratio xdesc update ratio:x%comps from
select not sumregionalSingleRecord in ``NR]+sum not regionalAverageRecord in ``NR,
comps:count distinct competitionId, processName last personName by personId from results
`ratio xdesc update ratio:x%comps from
select sumregionalSingleRecord<>`]+sum regionalAverageRecord<>`,
comps:count distinct competitionId, processName last personName by personId from results
today's episode of Stuff You Have (Probably Not) Been Wondering
- Competition furthest from the equator: Iceland Open 2012 in Reykjavik, Iceland and then 7 in Trondheim, Norway. Competition closest to the equator: East Borneo Open 2011, Borneo 2012, and then Pekanbaru Cube Day 2011.
On today's episode of Stuff You Have (Probably Not) Been Wondering:
- There are 135 people who have completed every non-BLD event. The earliest one to enter the WCA database was 2003LARS01 (Anders Larsson), and the latest was was 2011MOLL01 (James Molloy) who first competed on 7/30/2011.
personId personName streak
2009ZEMD01 Feliks Zemdegs 21
2009CONT01 Giovanni Contardi 11
2007VALL01 Breandan Vallance 10
2009DIEC01 Cornelius Dieckmann 10
2009PLES01 Michał Pleskowicz 10
2007VALK01 Mats Valk 9
2008HANK01 Kanneti Sae Han 9
2007NAKA03 Yu Nakajima 8
2009PICH01 Piti Pichedpan 8
2010RICC02 Andrew Ricci 8
2006TABU02 Yumu Tabuchi 7
2007HESS01 Rowe Hessler 6
2008SAJI01 Yu Sajima 6
2009CHAR03 Nipat Charoenpholphant 6
2009FANH01 Haowei Fan 6
2009MORI05 Paolo Moriello 6
2010WEYE02 Sebastian Weyer 6
2007CHAN07 Harris Chan 5
2009SMAR01 Jan Smarschevski 5
2009YAUR01 Robert Yau 5
personId personName streak
2009ZEMD01 Feliks Zemdegs 8
2009PLES01 Michał Pleskowicz 7
2006TABU02 Yumu Tabuchi 6
2007VALK01 Mats Valk 4
2007VALL01 Breandan Vallance 4
2008HANK01 Kanneti Sae Han 4
2009CHAR03 Nipat Charoenpholphant 4
2009DIEC01 Cornelius Dieckmann 4
2005AKKE01 Erik Akkersdijk 3
2007HESS01 Rowe Hessler 3
2007NAKA03 Yu Nakajima 3
2009PICH01 Piti Pichedpan 3
personId personName streak
2009ZEMD01 Feliks Zemdegs 3
2006TABU02 Yumu Tabuchi 2
2007VALK01 Mats Valk 2
2009CHAR03 Nipat Charoenpholphant 2
2009DIEC01 Cornelius Dieckmann 2
sub15:
personId personName streak
2009KONV01 Asia Konvittayayotin 155
2005FERN01 Ravi Fernando 151
2006GUNJ01 Mitsuki Gunji 147
2006TABU02 Yumu Tabuchi 144
2008SAJI01 Yu Sajima 132
2009CHAR03 Nipat Charoenpholphant 132
2009DIEC01 Cornelius Dieckmann 115
2008BARA01 Bence Barát 102
2007NAKA03 Yu Nakajima 101
2007VALK01 Mats Valk 98
2009ZEMD01 Feliks Zemdegs 98
sub20:
personId personName streak
2008BARA01 Bence Barát 279
2005REYN01 Tim Reynolds 259
2007NAKA03 Yu Nakajima 228
2009DIEC01 Cornelius Dieckmann 226
2007POLK01 Adam Polkowski 224
2009SPRI01 Alexander Springhorn 223
2006OKAY01 Yohei Oka 218
2009MORI05 Paolo Moriello 213
2007TAMA02 John Tamanas 193
2010UTOM01 Vincent Hartanto Utomo 192