Odd WCA stats/ Stats request Thread

[Stefan]

985 Erik Akkersdijk
960 Lars Vandenbergh
918 Ron van Bruchem
915 Clément Gallet
746 Tim Reynolds
742 Ton Dennenbroek
697 Jeremy Fleischman
671 Tomasz Żołnowski
658 Bob Burton
645 Arnaud van Galen
645 Rowe Hessler

Guess.

 

[thackernerd]

985 Erik Akkersdijk
960 Lars Vandenbergh
918 Ron van Bruchem
915 Clément Gallet
746 Tim Reynolds
742 Ton Dennenbroek
697 Jeremy Fleischman
671 Tomasz Żołnowski
658 Bob Burton
645 Arnaud van Galen
645 Rowe Hessler

Guess.

Most competitions?

 

[oranjules]

number of finals ? Number of medals is lower...

 

[Mike Hughey]

Counting solves?

 

[Stefan]

Mike is close.

Edit: While thackernerd was very wrong, he gave me the idea of this:

991 Erik Akkersdijk
955 François Courtès
925 Arnaud van Galen
915 Clément Gallet
774 Sébastien Auroux
718 Lars Vandenbergh
661 Ron van Bruchem
644 Bob Burton
554 Bence Barát
530 Tim Reynolds

That's counting different events in one competition as different competitions, so in that sense that's "most competitions". And Erik might reach 1000 next time.

 

[Cubenovice]

I was thinking valid 3x3x3 solves but a quick check on Bence revealed 103 3x3x3 appearances
103*5= maximum 515 solves...

EDIT bence is not in the original post, I was looking at the 2nd post

So valid 3x3 solves

Whut? Bob only has one DNF????
Lars 2...
These 2003 cubers don't mess about...

 

[That70sShowDude]

Most competitions?

Not sure if serious

 

[Bob]

I was thinking valid 3x3x3 solves but a quick check on Bence revealed 103 3x3x3 appearances
103*5= maximum 515 solves...

EDIT bence is not in the original post, I was looking at the 2nd post

So valid 3x3 solves

Whut? Bob only has one DNF????
Lars 2...
These 2003 cubers don't mess about...

Hrmm...and I got that DNF two competitions ago. :/

 

[Stefan]

So valid 3x3 solves

Indeed. And here as well, Erik can reach 1000 at his next competition.

Whut? Bob only has one DNF????
Lars 2...
These 2003 cubers don't mess about...

Tyson is king:

+--------------------------+--------+------+-------------+
| Name                     | Solves | DNFs | average     |
+--------------------------+--------+------+-------------+
| Tyson Mao (???)          |    427 |    0 | 19.65402810 |
| Patrick Jameson          |    370 |    0 | 16.07621622 |
| Philippe Virouleau       |    330 |    0 | 16.45869697 |
| Kσre Krig                |    296 |    0 | 21.35594595 |
| Yu Nakajima (?? ?)       |    296 |    0 | 11.97875000 |
| Istvßn Kocza             |    287 |    0 | 26.83850174 |
| Ryan Patricio            |    283 |    0 | 16.96222615 |
| Yumu Tabuchi (????)      |    273 |    0 | 12.88018315 |
| Anthony Hsu              |    271 |    0 | 16.15678967 |
| Berit Brⁿster            |    270 |    0 | 27.49992593 |
| Dene Beardsley           |    265 |    0 | 16.77169811 |
| Erik Johnson             |    261 |    0 | 16.17681992 |
| Gilles van den Peereboom |    259 |    0 | 18.31610039 |
| Yuji Suse (????)         |    215 |    0 | 17.44841860 |
| Jean Pons                |    209 |    0 | 14.53679426 |
| Kalina Brzezi?ska        |    205 |    0 | 14.82634146 |
| AurΘlien Souchet         |    198 |    0 | 20.63378788 |
| Chris Hardwick           |    196 |    0 | 17.17714286 |
| Zbigniew Zborowski       |    194 |    0 | 19.66329897 |
| Tatsuya Ookubo (??? ??)  |    188 |    0 | 16.56106383 |
+--------------------------+--------+------+-------------+

select personName Name, solves Solves, dnfs DNFs, solveTimeSum/solves/100 average
from( select personName,
       sum((value1>0)+(value2>0)+(value3>0)+(value4>0)+(value5>0)) solves,
       sum(if(value1>0,value1,0)+if(value2>0,value2,0)+if(value3>0,value3,0)+if(value4>0,value4,0)+if(value5>0,value5,0)) solveTimeSum,
       sum((value1=-1)+(value2=-1)+(value3=-1)+(value4=-1)+(value5=-1)) dnfs
      from results
      where eventId='333'
      group by personId) helper
where dnfs=0
order by solves/dnfs desc, solves desc
limit 20;

And those with just one DNF:

+------------------------------------------------+--------+------+-------------+
| Name                                           | Solves | DNFs | average     |
+------------------------------------------------+--------+------+-------------+
| Jeremy Fleischman                              |    697 |    1 | 15.74035868 |
| Bob Burton                                     |    658 |    1 | 22.50925532 |
| Leyan Lo                                       |    627 |    1 | 16.20491228 |
| Bence Barßt                                    |    512 |    1 | 13.65773438 |
| Darren Kwong                                   |    377 |    1 | 15.71822281 |
| Piotr Frankowski                               |    358 |    1 | 15.47357542 |
| Justin Adsuara                                 |    322 |    1 | 14.86875776 |
| Marcin Jakubowski                              |    318 |    1 | 18.24842767 |
| Dßniel Varga                                   |    317 |    1 | 15.23302839 |
| Piotr Alexandrowicz                            |    316 |    1 | 15.35768987 |
| Jack Moseley                                   |    294 |    1 | 16.48962585 |
| Mario Laurent                                  |    269 |    1 | 20.88349442 |
| Nipat Charoenpholphant (??????? ?????????????) |    266 |    1 | 11.48729323 |
| Micha? Halczuk                                 |    252 |    1 | 14.12039683 |
| Cornelius Dieckmann                            |    249 |    1 | 11.84116466 |
| Simon Westlund                                 |    244 |    1 | 13.44430328 |
| Takumi Yoshida (?? ?)                          |    233 |    1 | 12.56600858 |
| Mateusz Burnicki                               |    231 |    1 | 17.24190476 |
| Daniel Chan                                    |    229 |    1 | 17.35925764 |
| John Brechon                                   |    224 |    1 | 16.43236607 |
+------------------------------------------------+--------+------+-------------+

Not sure if serious

Precisely what I was thinking. Considered searching that image macro as well.

Hrmm...and I got that DNF two competitions ago. :/

Get used to it, you're getting old.

 

[Bob]

Tyson is king:

+--------------------------+--------+------+-------------+
| Name                     | Solves | DNFs | average     |
+--------------------------+--------+------+-------------+
| Tyson Mao (???)          |    427 |    0 | 19.65402810 |
+--------------------------+--------+------+-------------+

Get used to it, you're getting old.

Hrmm...then I WAS king by a couple hundred up until Princeton...do I have the longest streak of solves without a DNF then?

 

[macky]

China: http://stats.cubing.net/most_common_wca_id_middles.php?regionId=China
1 WANG 203
2 ZHAN 187
3 CHEN 119
...
52 CHAN 6

USA: http://stats.cubing.net/most_common_wca_id_middles.php?regionId=USA
1 CHEN 35
2 CHAN 24
3 WANG 23
...
21 ZHAN 7

I guess a bunch of Chens/Chengs got romanized Chan/Chang when they came to the US, but how do you explain the Zhans/Zhangs? Jian/Jiang in the US list don't account for the drop. Maybe border officers suck and they also became Chans/Changs.

 

[thackernerd]

Not sure if serious

I was kind of serious. I didn't really spend much time thinking about it, I just kind of typed it.

 

[MaeLSTRoM]

Who has the lowest single as a fraction of average? (single/average) or the Highest?

 

[Tim Major]

Who has the lowest single as a fraction of average? (single/average) or the Highest?

To make sure I understand you, like Charlie used to have? (10 single, 22 average).

 

[oranjules]

MaeLSTRoM, for 3x3x3, I have the query, It works, but I don't know how to make the results pretty...

pbAvg 	pbSgl 	ratio  	personName 	personId 	personCountryId
4455 	4425 	1.0068 	Benjamin English 	2010ENGL01 	USA
3186 	3158 	1.0089 	Ankita Purnaye 	2010PURN01 	India
2672 	2646 	1.0098 	Matthew Rush 	2011RUSH01 	USA
4103 	4055 	1.0118 	YiLin Li (李宜霖) 	2011LIYI01 	China
3421 	3381 	1.0118 	Alberto Muñoz Prieto 	2008MUNO01 	Spain
3079 	3038 	1.0135 	Nguyễn Tấn Hưng 	2011HANG01 	Vietnam
1936 	1909 	1.0141 	Caspian Gustavsson 	2009GUST02 	Sweden
9289 	9159 	1.0142 	Bruna Aparecida de Oliveira 	2011OLIV01 	Brazil
2480 	2444 	1.0147 	Yuri Ijuin (伊集院有里) 	2011IJUI01 	Japan
1627 	1603 	1.0150 	Tuan Phong Tran 	2010TRAN08 	Vietnam
3632 	3577 	1.0154 	Atsushi Syouji (東海林 淳) 	2011SYOU01 	Japan
3581 	3519 	1.0176 	Nathan Grammel 	2009GRAM01 	USA
4229 	4155 	1.0178 	Dawid Luniewski 	2010LUNI01 	Poland
5859 	5753 	1.0184 	Jiashi Shen 	2008SHEN01 	China
4795 	4708 	1.0185 	Ming-Kai Kang 	2006KANG03 	Taiwan
2285 	2243 	1.0187 	Natthasit Kiatthaweeanand 	2009KIAT01 	Thailand
3004 	2947 	1.0193 	Zephaniah Ko 	2011KOZE02 	Canada
6613 	6483 	1.0201 	Zhichu Chen (陈之初) 	2011CHEN48 	China
3796 	3719 	1.0207 	Sebastian Harasim 	2010HARA01 	USA
3507 	3436 	1.0207 	David Hamilton 	2011HAMI02 	Ireland
2545 	2493 	1.0209 	Toshinobu Hirayama (平山寿信) 	2005HIRA02 	Japan
4766 	4668 	1.0210 	Gregorio Requena Torres 	2009TORR02 	Spain
2609 	2555 	1.0211 	Dexin Lu (卢德馨) 	2011LUDE01 	China
4746 	4646 	1.0215 	Jesua Jovan 	2010JOVA01 	Indonesia
2928 	2866 	1.0216 	Asger Christiansen 	2011CHRI02 	Denmark
3871 	3788 	1.0219 	Ádám Brett 	2009BRET01 	Hungary
2715 	2653 	1.0234 	James Shi 	2006SHIJ01 	USA
3212 	3138 	1.0236 	Jared Cruz 	2010CRUZ01 	USA
3983 	3890 	1.0239 	Zhixing Wang (王之星) 	2009WANG78 	China
2770 	2705 	1.0240 	Andres Francisco Garzon Sepulveda 	2011GARZ02 	Colombia

...

From the highest :
pbAvg 	pbSgl 	ratio 	personName 	personId 	personCountryId
6122 	2120 	2.8877 	Jake Kuli 	2008KULI01 	USA
18054 	6946 	2.5992 	Joelle Sostheim 	2009SOST01 	USA
21110 	8653 	2.4396 	Arthy Ramu 	2010RAMU02 	India
21311 	8943 	2.3830 	Sabine Holderer 	2007HOLD03 	Brazil
21563 	9325 	2.3124 	Florent Pichot 	2011PICH01 	France
5849 	2644 	2.2122 	Binyamin Peleg 	2011PELE01 	Israel
3407 	1541 	2.2109 	Julian Christian Anderson 	2011ANDE02 	Indonesia
6102 	2777 	2.1973 	Warm Yin 	2008YINW02 	China
28155 	12896 	2.1832 	Welson Wei 	2009WEIW01 	Canada
5496 	2519 	2.1818 	Liujun Wang (王刘俊) 	2011WANG41 	China
10662 	4891 	2.1799 	Micah Postma 	2011POST02 	USA
20507 	9447 	2.1707 	Rafik Akbar 	2010AKBA01 	Indonesia
20391 	9422 	2.1642 	Tan Lee Choo 	2011CHOO01 	Malaysia
14431 	6693 	2.1561 	Yuhan Peng (彭宇晗) 	2010PENG04 	China
14763 	6940 	2.1272 	Manuel San Martin 	2010MART10 	Chile
8064 	3843 	2.0984 	Cosmin Aurelian Paiu 	2010PAIU01 	Romania
7610 	3659 	2.0798 	Leonardo Demutti 	2011DEMU01 	Italy
4045 	1950 	2.0744 	Aidan Aronhime 	2011ARON01 	USA
6369 	3072 	2.0732 	Zhongqi Chen (陈钟麒) 	2008QICH01 	China
6266 	3030 	2.0680 	Genki Nakao (中尾元気) 	2011NAKA04 	Japan
15445 	7494 	2.0610 	Dian Hayati 	2011HAYA03 	Indonesia
13174 	6408 	2.0559 	Chad Wang 	2009WANG14 	USA
11146 	5440 	2.0489 	Suryakumar 	2010SURY01 	India
9720 	4752 	2.0455 	Patricio Benitez Lima 	2009LIMA02 	Mexico
5528 	2708 	2.0414 	Victor Calme 	2011CALM01 	France
12458 	6107 	2.0400 	Eva Nieto 	2008NIET01 	Spain
8001 	3966 	2.0174 	Diogo Lino de Souza 	2009SOUZ01 	Brazil
33137 	16491 	2.0094 	Ned Diamond 	2009DIAM01 	USA
8584 	4305 	1.9940 	Nicolás Bórquez 	2011BORQ01 	Chile
27277 	13727 	1.9871 	Sandra Regina da Conceicao Eliziario 	2010ELIZ02 	Brazil

SQL query :

Spoiler

SELECT min( average ) AS pbAvg, min( best ) AS pbSgl, min( average ) / min( best ) AS ratio, personName, personId, personCountryId
FROM results
WHERE eventId =333
AND average >0
GROUP BY personName
ORDER BY ratio ASC [or DESC]

 

[Stefan]

That query is flawed. You only consider singles in valid averages, but people can set their single record outside of valid averages. And you should group by id, not by name. And while the eventId check works like that, better put it in quotes because they're strings.

You can make it nicer by using the mysql command line tool with the -t parameter. Here's my current setup:

In file mysql.bat:

mysql -t --default-character-set=utf8 -hlocalhost -uUSER -pPASSWORD DATABASE < mysql.in > mysql.out

In file mysql.in:

SELECT pbAvg, pbSgl, pbAvg/pbSgl ratio, personName, personId, personCountryId
FROM (SELECT min(if(average>0,average,1111111111)) AS pbAvg, min(if(best>0,best,1111111111)) AS pbSgl, personName, personId, personCountryId
FROM results
WHERE eventId = '333'
GROUP BY personId) helper
WHERE pbAvg<1111111111 AND pbSgl<1111111111
ORDER BY ratio ASC
LIMIT 30

The output in mysql.out:

+-------+-------+--------+-----------------------------------+------------+-----------+
| pbAvg | pbSgl | ratio  | personName                        | personId   | countryId |
+-------+-------+--------+-----------------------------------+------------+-----------+
|  4455 |  4425 | 1.0068 | Benjamin English                  | 2010ENGL01 | USA       |
|  3186 |  3158 | 1.0089 | Ankita Purnaye                    | 2010PURN01 | India     |
|  2672 |  2646 | 1.0098 | Matthew Rush                      | 2011RUSH01 | USA       |
|  3421 |  3381 | 1.0118 | Alberto Muñoz Prieto              | 2008MUNO01 | Spain     |
|  4103 |  4055 | 1.0118 | YiLin Li (李宜霖)                 | 2011LIYI01 | China     |
|  3079 |  3038 | 1.0135 | Nguyễn Tấn Hưng                   | 2011HANG01 | Vietnam   |
|  1936 |  1909 | 1.0141 | Caspian Gustavsson                | 2009GUST02 | Sweden    |
|  9289 |  9159 | 1.0142 | Bruna Aparecida de Oliveira       | 2011OLIV01 | Brazil    |
|  2480 |  2444 | 1.0147 | Yuri Ijuin (伊集院有里)           | 2011IJUI01 | Japan     |
|  3632 |  3577 | 1.0154 | Atsushi Syouji (東海林 淳)        | 2011SYOU01 | Japan     |
|  3581 |  3519 | 1.0176 | Nathan Grammel                    | 2009GRAM01 | USA       |
|  4229 |  4155 | 1.0178 | Dawid Luniewski                   | 2010LUNI01 | Poland    |
|  5859 |  5753 | 1.0184 | Jiashi Shen                       | 2008SHEN01 | China     |
|  4795 |  4708 | 1.0185 | Ming-Kai Kang                     | 2006KANG03 | Taiwan    |
|  3004 |  2947 | 1.0193 | Zephaniah Ko                      | 2011KOZE02 | Canada    |
|  6613 |  6483 | 1.0201 | Zhichu Chen (陈之初)              | 2011CHEN48 | China     |
|  3796 |  3719 | 1.0207 | Sebastian Harasim                 | 2010HARA01 | USA       |
|  3507 |  3436 | 1.0207 | David Hamilton                    | 2011HAMI02 | Ireland   |
|  2545 |  2493 | 1.0209 | Toshinobu Hirayama (平山寿信)     | 2005HIRA02 | Japan     |
|  4766 |  4668 | 1.0210 | Gregorio Requena Torres           | 2009TORR02 | Spain     |
|  2609 |  2555 | 1.0211 | Dexin Lu (卢德馨)                 | 2011LUDE01 | China     |
|  4746 |  4646 | 1.0215 | Jesua Jovan                       | 2010JOVA01 | Indonesia |
|  2928 |  2866 | 1.0216 | Asger Christiansen                | 2011CHRI02 | Denmark   |
|  3871 |  3788 | 1.0219 | Ádám Brett                        | 2009BRET01 | Hungary   |
|  2715 |  2653 | 1.0234 | James Shi                         | 2006SHIJ01 | USA       |
|  3212 |  3138 | 1.0236 | Jared Cruz                        | 2010CRUZ01 | USA       |
|  3983 |  3890 | 1.0239 | Zhixing Wang (王之星)             | 2009WANG78 | China     |
|  2770 |  2705 | 1.0240 | Andres Francisco Garzon Sepulveda | 2011GARZ02 | Colombia  |
|  2509 |  2450 | 1.0241 | Lee Ka Hou                        | 2009HOUL01 | Malaysia  |
|  1522 |  1486 | 1.0242 | Joel Wong Jun Wen                 | 2009WENJ01 | Singapore |
+-------+-------+--------+-----------------------------------+------------+-----------+

Don't know why it's still not perfectly aligned here, it is in my mysql.out file.

 

[Sessinator]

My first 3x3 solve in competition (which as fullstep) remained my fastest solve until the the time was broken 25 solves later. Has anyone else had a really long PB streak for their first solve in a competition?

 

[Riley]

What's the longest break someone has taken from one competition to another, besides people who went to the World Championships in 1982?

 

[Jakube]

Anthony Brooks has an official 5/5 Multi BLD but doesn´t appear in the WCA ranking.

 

[aronpm]

Anthony Brooks has an official 5/5 Multi BLD but doesn´t appear in the WCA ranking.

He does, but as Anthony Searle:

67 Anthony Searle 5/5 47:22 Belize Denver Open 2009