Odd WCA stats/ Stats request Thread

cubizh · Dec 7, 2013

rowehessler said:
Not sure if this has been done before, but a list for highest 3x3 win percentage? I know feliks has almost 100%, but others? It'd also be cool to see over a certain number of comps, like for those who have more than 10, 20, 30, etc. I stand at 77 comps with 38 wins ( 75 of which competed in 3x3, so 50.66% i think).

[TABLE="class:grid,align:left"]
[TR][TD] Name [/TD][TD] personId [/TD][TD] 1st [/TD][TD] 2nd [/TD][TD] 3rd [/TD][TD] 4th or over [/TD][TD] DNS/DNF [/TD][TD] 3x3 FINALS [/TD][TD] 3x3 EVENTS [/TD][TD] %WINS [/TD][/TR]
[TR][TD] Feliks Zemdegs [/TD][TD] 2009ZEMD01 [/TD][TD] 19 [/TD][TD] 0 [/TD][TD] 1 [/TD][TD] 0 [/TD][TD] 0 [/TD][TD] 20 [/TD][TD] 21 [/TD][TD] 90.48% [/TD][/TR]
[TR][TD] Anssi Vanhala [/TD][TD] 2005VANH01 [/TD][TD] 19 [/TD][TD] 3 [/TD][TD] 1 [/TD][TD] 3 [/TD][TD] 0 [/TD][TD] 26 [/TD][TD] 26 [/TD][TD] 73.08% [/TD][/TR]
[TR][TD] Kanneti Sae Han (คันธ์เนตี แซ่ห่าน) [/TD][TD] 2008HANK01 [/TD][TD] 26 [/TD][TD] 2 [/TD][TD] 4 [/TD][TD] 7 [/TD][TD] 0 [/TD][TD] 39 [/TD][TD] 40 [/TD][TD] 65.00% [/TD][/TR]
[TR][TD] Sergey Ryabko [/TD][TD] 2009RYAB01 [/TD][TD] 17 [/TD][TD] 6 [/TD][TD] 0 [/TD][TD] 4 [/TD][TD] 0 [/TD][TD] 27 [/TD][TD] 27 [/TD][TD] 62.96% [/TD][/TR]
[TR][TD] Harris Chan [/TD][TD] 2007CHAN07 [/TD][TD] 17 [/TD][TD] 4 [/TD][TD] 2 [/TD][TD] 4 [/TD][TD] 0 [/TD][TD] 27 [/TD][TD] 28 [/TD][TD] 60.71% [/TD][/TR]
[TR][TD] Mulun Yin (阴目仑) [/TD][TD] 2009YINM01 [/TD][TD] 12 [/TD][TD] 5 [/TD][TD] 0 [/TD][TD] 2 [/TD][TD] 0 [/TD][TD] 19 [/TD][TD] 21 [/TD][TD] 57.14% [/TD][/TR]
[TR][TD] Yu Nakajima (中島悠) [/TD][TD] 2007NAKA03 [/TD][TD] 27 [/TD][TD] 6 [/TD][TD] 3 [/TD][TD] 13 [/TD][TD] 0 [/TD][TD] 49 [/TD][TD] 50 [/TD][TD] 54.00% [/TD][/TR]
[TR][TD] Rowe Hessler [/TD][TD] 2007HESS01 [/TD][TD] 38 [/TD][TD] 16 [/TD][TD] 6 [/TD][TD] 13 [/TD][TD] 0 [/TD][TD] 73 [/TD][TD] 75 [/TD][TD] 50.67% [/TD][/TR]
[TR][TD] Michał Pleskowicz [/TD][TD] 2009PLES01 [/TD][TD] 15 [/TD][TD] 3 [/TD][TD] 2 [/TD][TD] 4 [/TD][TD] 0 [/TD][TD] 24 [/TD][TD] 30 [/TD][TD] 50.00% [/TD][/TR]
[TR][TD] Cornelius Dieckmann [/TD][TD] 2009DIEC01 [/TD][TD] 15 [/TD][TD] 1 [/TD][TD] 3 [/TD][TD] 8 [/TD][TD] 0 [/TD][TD] 27 [/TD][TD] 30 [/TD][TD] 50.00% [/TD][/TR]
[TR][TD] Piti Pichedpan (ปิติ พิเชษฐพันธ์) [/TD][TD] 2009PICH01 [/TD][TD] 12 [/TD][TD] 5 [/TD][TD] 2 [/TD][TD] 4 [/TD][TD] 0 [/TD][TD] 23 [/TD][TD] 24 [/TD][TD] 50.00% [/TD][/TR]
[TR][TD] Anthony Brooks [/TD][TD] 2008SEAR01 [/TD][TD] 18 [/TD][TD] 4 [/TD][TD] 2 [/TD][TD] 10 [/TD][TD] 0 [/TD][TD] 34 [/TD][TD] 37 [/TD][TD] 48.65% [/TD][/TR]
[TR][TD] Mats Valk [/TD][TD] 2007VALK01 [/TD][TD] 28 [/TD][TD] 12 [/TD][TD] 4 [/TD][TD] 10 [/TD][TD] 0 [/TD][TD] 54 [/TD][TD] 58 [/TD][TD] 48.28% [/TD][/TR]
[TR][TD] Richard Jay S. Apagar [/TD][TD] 2010APAG01 [/TD][TD] 11 [/TD][TD] 2 [/TD][TD] 3 [/TD][TD] 4 [/TD][TD] 0 [/TD][TD] 20 [/TD][TD] 23 [/TD][TD] 47.83% [/TD][/TR]
[TR][TD] Tomasz Żołnowski [/TD][TD] 2005ZOLN01 [/TD][TD] 32 [/TD][TD] 21 [/TD][TD] 5 [/TD][TD] 8 [/TD][TD] 0 [/TD][TD] 66 [/TD][TD] 68 [/TD][TD] 47.06% [/TD][/TR]
[TR][TD] Stefan Huber [/TD][TD] 2007HUBE01 [/TD][TD] 11 [/TD][TD] 4 [/TD][TD] 2 [/TD][TD] 4 [/TD][TD] 0 [/TD][TD] 21 [/TD][TD] 25 [/TD][TD] 44.00% [/TD][/TR]
[TR][TD] Erik Akkersdijk [/TD][TD] 2005AKKE01 [/TD][TD] 43 [/TD][TD] 23 [/TD][TD] 9 [/TD][TD] 15 [/TD][TD] 0 [/TD][TD] 90 [/TD][TD] 98 [/TD][TD] 43.88% [/TD][/TR]
[TR][TD] Ravi Fernando [/TD][TD] 2005FERN01 [/TD][TD] 9 [/TD][TD] 5 [/TD][TD] 3 [/TD][TD] 3 [/TD][TD] 0 [/TD][TD] 20 [/TD][TD] 22 [/TD][TD] 40.91% [/TD][/TR]
[TR][TD] Vincent Hartanto Utomo [/TD][TD] 2010UTOM01 [/TD][TD] 9 [/TD][TD] 6 [/TD][TD] 2 [/TD][TD] 3 [/TD][TD] 0 [/TD][TD] 20 [/TD][TD] 22 [/TD][TD] 40.91% [/TD][/TR]
[TR][TD] Edouard Chambon [/TD][TD] 2004CHAM01 [/TD][TD] 17 [/TD][TD] 14 [/TD][TD] 3 [/TD][TD] 6 [/TD][TD] 0 [/TD][TD] 40 [/TD][TD] 42 [/TD][TD] 40.48% [/TD][/TR]
[TR][TD] Shotaro Makisumi (牧角章太郎) [/TD][TD] 2003MAKI01 [/TD][TD] 14 [/TD][TD] 4 [/TD][TD] 2 [/TD][TD] 9 [/TD][TD] 0 [/TD][TD] 29 [/TD][TD] 35 [/TD][TD] 40.00% [/TD][/TR]
[TR][TD] Andy Tsao [/TD][TD] 2006TSAO01 [/TD][TD] 10 [/TD][TD] 5 [/TD][TD] 3 [/TD][TD] 7 [/TD][TD] 0 [/TD][TD] 25 [/TD][TD] 25 [/TD][TD] 40.00% [/TD][/TR]
[TR][TD] Phillip Espinoza [/TD][TD] 2007ESPI01 [/TD][TD] 15 [/TD][TD] 9 [/TD][TD] 0 [/TD][TD] 11 [/TD][TD] 0 [/TD][TD] 35 [/TD][TD] 38 [/TD][TD] 39.47% [/TD][/TR]
[TR][TD] Francisco Javier Lemes Sáez [/TD][TD] 2009SAEZ01 [/TD][TD] 10 [/TD][TD] 6 [/TD][TD] 3 [/TD][TD] 7 [/TD][TD] 0 [/TD][TD] 26 [/TD][TD] 27 [/TD][TD] 37.04% [/TD][/TR]
[TR][TD] Paolo Moriello [/TD][TD] 2009MORI05 [/TD][TD] 15 [/TD][TD] 15 [/TD][TD] 3 [/TD][TD] 6 [/TD][TD] 0 [/TD][TD] 39 [/TD][TD] 41 [/TD][TD] 36.59% [/TD][/TR]
[TR][TD] Breandan Vallance [/TD][TD] 2007VALL01 [/TD][TD] 17 [/TD][TD] 7 [/TD][TD] 8 [/TD][TD] 13 [/TD][TD] 0 [/TD][TD] 45 [/TD][TD] 47 [/TD][TD] 36.17% [/TD][/TR]
[TR][TD] Shenjia Zhang (张砷镓) [/TD][TD] 2007ZHAN03 [/TD][TD] 9 [/TD][TD] 8 [/TD][TD] 1 [/TD][TD] 7 [/TD][TD] 0 [/TD][TD] 25 [/TD][TD] 25 [/TD][TD] 36.00% [/TD][/TR]
[TR][TD] Antoine Piau [/TD][TD] 2008PIAU01 [/TD][TD] 10 [/TD][TD] 7 [/TD][TD] 3 [/TD][TD] 6 [/TD][TD] 0 [/TD][TD] 26 [/TD][TD] 29 [/TD][TD] 34.48% [/TD][/TR]
[TR][TD] Pedro Santos Guimarães [/TD][TD] 2007GUIM01 [/TD][TD] 7 [/TD][TD] 8 [/TD][TD] 3 [/TD][TD] 1 [/TD][TD] 0 [/TD][TD] 19 [/TD][TD] 21 [/TD][TD] 33.33% [/TD][/TR]
[/TABLE]

Florian · Dec 7, 2013

Could somebody use every single time entry, convert it into seconds and look if it follows Benford's law?
Would be highly appreciated

cubizh · Dec 7, 2013

Florian said:
Could somebody use every single time entry, convert it into seconds and look if it follows Benford's law?
Would be highly appreciated

For consistency, I only used direct time events (removed FMC and MultiBLD).

Mikel · Dec 10, 2013

x-colo-x said:
Is it possible to have the sum of 3/4/5/m bld ranks? And if it is possible the sql query's code,too.

I am looking for this same thing. I wanted to learn how to use SQL and couldn't quite think of how to do sum of ranks.

Evan Liu · Dec 10, 2013

Mikel said:
I am looking for this same thing. I wanted to learn how to use SQL and couldn't quite think of how to do sum of ranks.

Please try using the program documented in this thread.

CyanSandwich · Dec 13, 2013

I've been told this exists, but I can't find it. How many people/what percentage of people got a success on their first official 3bld solve?

TheDubDubJr · Dec 13, 2013

CyanSandwich said:
I've been told this exists, but I can't find it. How many people/what percentage of people got a success on their first official 3bld solve?

http://www.speedsolving.com/forum/s...request-Thread&p=823556&viewfull=1#post823556

CyanSandwich · Dec 13, 2013

Thanks

CyanSandwich · Dec 15, 2013

Could someone please make a list of people who have had more DNFs from sighted solves than BLD solves?

Edit: Discount people who haven't attempted BLD of course. I think FMC should be removed as well.

Sebastien · Dec 15, 2013

My girldfriend Laura came up with an idea for an interesting stat today. The outcome is quite as expected.

Average age (approximated) of Top 100 per event:

Single:

Code:

444 	18.3000
333oh 	18.5100
333 	18.6961
777 	18.9700
555 	19.0000
666 	19.1600
minx 	19.2200
222 	19.2941
pyram 	19.4300
333ft 	20.1010
sq1 	21.0714
clock 	21.5657
333bf 	22.4200
444bf 	22.9192
333mbf 	23.3300
333fm 	23.7184
555bf 	24.3299

Average:

Code:

444 	18.1700
333 	18.1765
222 	18.3301
333oh 	18.5050
pyram 	18.9100
777 	18.9200
555 	18.9400
666 	19.2500
minx 	19.4242
333ft 	20.0202
sq1 	21.1735
clock 	22.5960

Code:

SELECT eventId, 2013-SUM(Persons.year)/SUM(IF(Persons.year<>0,1,0)) AS averageAge 
FROM RanksSingle INNER JOIN Persons on RanksSingle.personId=Persons.id
WHERE RanksSingle.worldRank < 100
GROUP BY eventId
ORDER BY averageAge

SELECT eventId, 2013-SUM(Persons.year)/SUM(IF(Persons.year<>0,1,0)) AS averageAge 
FROM RanksAverage INNER JOIN Persons on RanksAverage.personId=Persons.id
WHERE RanksAverage.worldRank < 100
GROUP BY eventId
ORDER BY averageAge

Tim Major · Dec 16, 2013

I am actually surprised, I would've assumed the averages for some of those events to be MUCH lower. What about current WR holders for each age on 3x3? Would be a cool stat, even if you can't really make assumptions bases off of it due to low sample size at 30+

cubizh · Dec 16, 2013

Tim Major said:
I am actually surprised, I would've assumed the averages for some of those events to be MUCH lower. What about current WR holders for each age on 3x3? Would be a cool stat, even if you can't really make assumptions bases off of it due to low sample size at 30+

I dont think Sebastien will do it, really, as it identifies people's age directly.
What I would like to see was average age by country to see which countries have a younger/mature competitor base.

Tim Major · Dec 16, 2013

cubizh said:
I dont think Sebastien will do it, really, as it identifies people's age directly.
What I would like to see was average age by country to see which countries have a younger/mature competitor base.

I mean something like;

17: 6.54
18: 7.x
..
..
..
50: 20.xy

etc. I just want to see how it goes, no need for naming.

kcl · Dec 16, 2013

Tim Major said:
I mean something like;

17: 6.54
18: 7.x
..
..
..
50: 20.xy

etc. I just want to see how it goes, no need for naming.

If I'm understanding you right you want to see the average average of each age? If so, someone do it please, I'm curious now

Tim Major · Dec 16, 2013

kclejeune said:
If I'm understanding you right you want to see the average average of each age? If so, someone do it please, I'm curious now

Well I actually wanted to know the FASTEST for each age. Average for each age would not mean much.

kcl · Dec 16, 2013

Tim Major said:
Well I actually wanted to know the FASTEST for each age. Average for each age would not mean much.

Although then we could find out the fastest age.. I realized what you actually meant and I thought I edited the post.. Apparently not :fp

Sebastien · Dec 16, 2013

cubizh said:
I dont think Sebastien will do it, really, as it identifies people's age directly.
What I would like to see was average age by country to see which countries have a younger/mature competitor base.

This, sorry.

canemu · Dec 17, 2013

Which tools do I need to work with the .sql file?

Sebastien · Dec 19, 2013

Inspired by Noah's Fantasy Cubing 2014 I just had the idea of making a more simple and possibly more fair ranking, which also doesn't provide so much advantage by competing very often:

For each round you compete in you get +1 for everyone you beat or tie and -1 for everyone you get beaten by.

As the resulting ranking hasn't to do much with Noah's ranking I don't think that I'll spoil anything by posting it here.

Top 100 (2013):

Position	personId	personName	personCountryId	Comps	score
1.	2007VALK01	Mats Valk	Netherlands	8	16739
2.	2011ZALE02	Marcin Zalewski	Poland	13	15359
3.	2008BARA01	Bence Barát	Hungary	11	15143
4.	2009ZEMD01	Feliks Zemdegs	Australia	5	14836
5.	2007HESS01	Rowe Hessler	USA	14	13107
6.	2010CORM02	Louis Cormier	Canada	8	12268
7.	2009PLES01	Michał Pleskowicz	Poland	6	11838
8.	2010BREC01	John Brechon	USA	12	11743
9.	2010CANT02	Antoine Cantin	Canada	7	11588
10.	2012COST01	Kevin Costello III	USA	13	11513
11.	2006HALC01	Michał Halczuk	Poland	9	11121
12.	2008LINE02	Edward Lin	USA	10	10964
13.	2009YAUR01	Robert Yau	United Kingdom	8	10959
14.	2009BOZS01	Hunor Bózsing	Hungary	11	10284
15.	2010KIPA01	Jakub Kipa	Poland	6	9774
16.	2009DIEC01	Cornelius Dieckmann	Germany	5	9713
17.	2010APAG01	Richard Jay S. Apagar	Philippines	9	9582
18.	2012WOLN01	Jakub Wolniewicz	Poland	11	9428
19.	2008WEST02	Simon Westlund	Sweden	4	9267
20.	2012CHOS01	SeungBeom Cho (조승범)	Korea	3	9235
21.	2007COHE01	Dan Cohen	USA	7	9187
22.	2009ZHAN53	Weixing Zhang (张炜星)	China	5	9156
23.	2009JUNY01	Howard Wong Jun Yen (黄俊仁)	Malaysia	4	9148
24.	2010BENT01	Jan Bentlage	Germany	17	9095
25.	2011SZAT01	Wojciech Szatanowski	Poland	12	8963
26.	2007VALL01	Breandan Vallance	United Kingdom	8	8839
27.	2012KALE01	Przemysław Kaleta	Poland	9	8657
28.	2012MCNE01	Jayden McNeill	Australia	6	8331
29.	2010WEYE02	Sebastian Weyer	Germany	4	7889
30.	2010BRAD01	Drew Brads	USA	4	7603
31.	2008AURO01	Sébastien Auroux	Germany	21	7363
32.	2009OLSO01	Christopher Olson	USA	7	7324
33.	2008CLAR01	Thompson Clarke	Canada	6	7105
34.	2005AKKE01	Erik Akkersdijk	Netherlands	10	6952
35.	2008JONG03	Jong-Ho Jeong (정종호)	Korea	2	6869
36.	2005ZOLN01	Tomasz Żołnowski	Poland	15	6860
37.	2008SAJI01	Yu Sajima (佐島優)	Japan	9	6701
38.	2010MALL01	Justin Mallari	USA	5	6616
39.	2011ETTE01	Lucas Etter	USA	6	6581
40.	2011KUDA01	Nurym Kudaibergen	Kazakhstan	4	6403
41.	2011NARA02	Bhargav Narasimhan	India	9	6280
42.	2009LIUE01	Evan Liu	USA	8	6213
43.	2009HAMO01	James Hamory	USA	10	6113
44.	2010WANG07	Yinghao Wang (王鹰豪)	China	9	6086
45.	2009SHEP01	Daniel Sheppard	United Kingdom	10	5971
46.	2009HAYS01	Kevin Hays	USA	2	5908
47.	2009KORB01	Björn Korbanka	Germany	12	5880
48.	2007JAKU01	Marcin Jakubowski	Poland	13	5830
49.	2011FYDR01	Mateusz Fydrych	Poland	10	5788
50.	2010RICC02	Andrew Ricci	USA	8	5492
51.	2007SUNT01	Timothy Sun	USA	9	5472
52.	2011KNOT01	Wojciech Knott	Poland	7	5446
53.	2009MORI05	Paolo Moriello	Italy	9	5340
54.	2010BURN01	Collin Burns	USA	6	5295
55.	2010TANE01	Gaurav Taneja	India	9	5258
56.	2011REED01	Austin Reed	USA	3	5253
57.	2008JAFF01	Justin Jaffray	Canada	6	5135
58.	2007LIME01	Eric Limeback	Canada	6	5008
59.	2010SCHM01	Leon Schmidtchen	Germany	7	4947
60.	2009BARB01	Gabriel Dechichi Barbar	Brazil	6	4875
61.	2008SEAR01	Anthony Brooks	USA	8	4854
62.	2011ZVYA01	Dmitry Zvyagintsev	Russia	7	4809
63.	2008ANDE02	Oscar Roth Andersen	Denmark	9	4740
64.	2010WEYE01	Philipp Weyer	Germany	4	4733
65.	2012SZEW01	Patryk Szewczyk	Poland	8	4697
66.	2009SMIT03	Andy Smith	USA	2	4603
67.	2010VYNN01	Ivan Vynnyk (Іван Винник)	Ukraine	7	4591
68.	2008KARL02	Moritz Karl	Germany	6	4561
69.	2013WOJT02	Jakub Wojtaszewski	Poland	7	4498
70.	2011CHAN13	Swaminathan Chandrasekaran	India	10	4460
71.	2011BILC01	Ihor Bilchenko (Ігор Більченко)	Ukraine	8	4458
72.	2011SHAH01	Dharmesh Shahu	India	5	4429
73.	2009RYAB01	Sergey Ryabko	Russia	10	4371
74.	2011STAN02	Nick Stanton	USA	5	4364
75.	2005KOZK01	Piotr Kózka	Poland	5	4310
76.	2007WOOR01	Riley Woo	USA	9	4301
77.	2011SOBR01	Alrimar Dias Rocha Sobrinho	Brazil	6	4235
78.	2009BRZE01	Kalina Brzezińska	Poland	13	4139
79.	2008MAND01	Nikhil Mande	India	7	4137
80.	2011LIMA01	Allyson Dias de Lima	Brazil	9	4110
81.	2009SMAR01	Jan Smarschevski	Germany	6	4044
82.	2010GARC02	Carlos Méndez García-Barroso	Spain	6	4022
83.	2011SOAR01	Israel Machado Soares	Brazil	6	3990
84.	2012RUPE01	Akash Rupela	India	6	3925
85.	2008LIKA01	Kailong Li (李开隆)	China	4	3880
86.	2011FATE01	Seyyed Mohammad Hossein Fatemi (سید محمد حسین فاطمی)	Iran	4	3846
87.	2011KIRU01	Kesava Kirupa	India	4	3842
88.	2012KRIS04	Velidi Venkata Jagan Mohana Murali Krishna	India	8	3722
89.	2011SELZ01	Dan Selzer	USA	17	3654
90.	2010LANE02	Mitchell Lane	USA	7	3634
91.	2010LEED02	Daniil Lee	Russia	5	3555
92.	2011KOWA01	Marcin Kowalczyk	Poland	13	3533
93.	2011VERS03	Georgy Vershinin	Russia	6	3508
94.	2011MATA01	Jorge Castillo Matas	Spain	6	3489
95.	2008MORE02	Hippolyte Moreau	France	12	3446
96.	2010DAVI06	Julian David	Canada	6	3439
97.	2010YUPH01	Phil Yu	USA	6	3403
98.	2011STAC01	Marcin Stachura	Poland	9	3379
99.	2011KUMA01	Akula Pavan Kumar	India	8	3225
100.	2008ZERU01	Krzysztof Żerucha	Poland	4	3223

Code:

SELECT personId, personName, Results.personCountryId, COUNT(distinct Results.competitionId) AS Comps, SUM(peopleRound-(2*pos)+1) AS score
FROM Results
INNER JOIN (SELECT competitionId, eventId, COUNT(distinct personId) AS peopleRound FROM Results GROUP BY competitionId, eventId, roundId) tmp1 ON Results.competitionId=tmp1.competitionId AND Results.eventId=tmp1.eventId 
WHERE Results.competitionId IN (SELECT id FROM Competitions WHERE year="2013")
GROUP BY personId
ORDER BY score DESC
LIMIT 100

Top 100 (all-time):

Position	personId	personName	personCountryId	Comps	score
1.	2005AKKE01	Erik Akkersdijk	Netherlands	100	64398
2.	2007VALK01	Mats Valk	Netherlands	58	51916
3.	2007HESS01	Rowe Hessler	USA	77	51255
4.	2008BARA01	Bence Barát	Hungary	55	44615
5.	2009DIEC01	Cornelius Dieckmann	Germany	30	36652
6.	2005BATI01	Milán Baticz	Hungary	46	36452
7.	2007COHE01	Dan Cohen	USA	59	36252
8.	2007VALL01	Breandan Vallance	United Kingdom	47	35748
9.	2009PLES01	Michał Pleskowicz	Poland	30	28993
10.	2009ZEMD01	Feliks Zemdegs	Australia	21	25981
11.	2008WEST02	Simon Westlund	Sweden	26	25899
12.	2008JAFF01	Justin Jaffray	Canada	49	24839
13.	2010BREC01	John Brechon	USA	39	23825
14.	2008LINE02	Edward Lin	USA	46	23687
15.	2006HALC01	Michał Halczuk	Poland	38	23276
16.	2005ZOLN01	Tomasz Żołnowski	Poland	69	23142
17.	2007NAKA03	Yu Nakajima (中島悠)	Japan	56	21912
18.	2011ZALE02	Marcin Zalewski	Poland	27	21903
19.	2007SUNT01	Timothy Sun	USA	39	21850
20.	2008AURO01	Sébastien Auroux	Germany	102	21371
21.	2006TABU02	Yumu Tabuchi (田渕雄夢)	Japan	32	21236
22.	2010CORM02	Louis Cormier	Canada	20	20909
23.	2009YAUR01	Robert Yau	United Kingdom	22	20740
24.	2005KOZK01	Piotr Kózka	Poland	39	19959
25.	2009KORB01	Björn Korbanka	Germany	41	19811
26.	2008CLAR01	Thompson Clarke	Canada	29	19580
27.	2009HAYS01	Kevin Hays	USA	18	17676
28.	2010WEYE02	Sebastian Weyer	Germany	22	17350
29.	2008SAJI01	Yu Sajima (佐島優)	Japan	42	17238
30.	2009MORI05	Paolo Moriello	Italy	41	16966
31.	2008SMIT04	Maarten Smit	Netherlands	28	16578
32.	2008HANK01	Kanneti Sae Han (คันธ์เนตี แซ่ห่าน)	Thailand	40	16540
33.	2008SEAR01	Anthony Searle	Belize	37	16420
34.	2007OMUR01	Syuhei Omura (大村周平)	Japan	45	16399
35.	2008VARG01	Dániel Varga	Hungary	46	16206
36.	2007CHAN07	Harris Chan	Canada	28	15908
37.	2007LIME01	Eric Limeback	Canada	31	15769
38.	2008KARL02	Moritz Karl	Germany	29	15702
39.	2009OLSO01	Christopher Olson	USA	28	15542
40.	2009ZHAN53	Weixing Zhang (张炜星)	China	25	15318
41.	2009JUNY01	Howard Wong Jun Yen (黄俊仁)	Malaysia	21	15183
42.	2010KIPA01	Jakub Kipa	Poland	14	15156
43.	2012COST01	Kevin Costello III	USA	26	14655
44.	2009RYAB01	Sergey Ryabko	Russia	27	14367
45.	2010APAG01	Richard Jay S. Apagar	Philippines	23	14228
46.	2010CANT02	Antoine Cantin	Canada	15	14058
47.	2010WEYE01	Philipp Weyer	Germany	23	14019
48.	2010SCHM01	Leon Schmidtchen	Germany	23	13930
49.	2005REYN01	Tim Reynolds	USA	90	13750
50.	2009SMAR01	Jan Smarschevski	Germany	25	13672
51.	2007ESPI01	Phillip Espinoza	USA	38	13631
52.	2008LIKA01	Kailong Li (李开隆)	China	25	13605
53.	2004CHAM01	Edouard Chambon	France	43	13436
54.	2008JONG03	Jong-Ho Jeong (정종호)	Korea	14	13183
55.	2006TSAO01	Andy Tsao	USA	26	13007
56.	2009CHAR03	Nipat Charoenpholphant (นิพัฒน์ เจริญพลพันธุ์)	Thailand	22	12945
57.	2005FLEI01	Jeremy Fleischman	USA	73	12835
58.	2010RICC02	Andrew Ricci	USA	32	12609
59.	2009BARB01	Gabriel Dechichi Barbar	Brazil	19	12450
60.	2009CONT01	Giovanni Contardi	Italy	20	12320
61.	2010MALL01	Justin Mallari	USA	24	12192
62.	2012KALE01	Przemysław Kaleta	Poland	16	12139
63.	2009PICH01	Piti Pichedpan (ปิติ พิเชษฐพันธ์)	Thailand	25	12027
64.	2004KRIG01	Gunnar Krig	Sweden	51	11932
65.	2010VYNN01	Ivan Vynnyk (Іван Винник)	Ukraine	18	11827
66.	2007GAMB01	Jai Gambhir	Canada	24	11730
67.	2010WANG07	Yinghao Wang (王鹰豪)	China	29	11665
68.	2007ADSU01	Justin Adsuara	USA	35	11568
69.	2010GARC02	Carlos Méndez García-Barroso	Spain	17	11550
70.	2009BOZS01	Hunor Bózsing	Hungary	24	11472
71.	2004LOLE01	Leyan Lo	USA	49	11218
72.	2006BUUS01	Henrik Buus Aagaard	Denmark	54	11112
73.	2007HUBE01	Stefan Huber	Austria	25	11083
74.	2007POLK01	Adam Polkowski	Poland	39	10943
75.	2009SMIT03	Andy Smith	USA	15	10830
76.	2006DZOA03	Dan Dzoan	USA	51	10713
77.	2006GUNJ01	Mitsuki Gunji (郡司光貴)	Japan	32	10390
78.	2010BENT01	Jan Bentlage	Germany	55	10329
79.	2009SPRI01	Alexander Springhorn	Germany	30	10180
80.	2009KORB02	Lasse Korbanka	Germany	27	10175
81.	2008LINH01	Hao-Zheng Lin (林浩正)	Taiwan	21	10066
82.	2008MIZU01	Weston Mizumoto	USA	31	10050
83.	2009SHEP01	Daniel Sheppard	United Kingdom	31	10012
84.	2007GOUL01	Joey Gouly	United Kingdom	61	9843
85.	2007BODO01	Bertalan Bodor	Hungary	27	9840
86.	2007GUIM01	Pedro Santos Guimarães	Brazil	21	9833
87.	2012CHOS01	SeungBeom Cho	Korea	5	9773
88.	2009POOK01	Baramee Pookcharoen (บารมี พุกเจริญ)	Thailand	19	9713
89.	2006TEMM01	Rama Temmink	Netherlands	49	9683
90.	2012MCNE01	Jayden McNeill	Australia	12	9621
91.	2008ANDE02	Oscar Roth Andersen	Denmark	44	9519
92.	2010YUPH01	Phil Yu	USA	34	9473
93.	2007AGUA01	Alejandro Aguado Barahona	Spain	29	9439
94.	2006OKAY01	Yohei Oka (岡要平)	Japan	55	9275
95.	2009WANG15	Emily Wang	Canada	18	8951
96.	2010EVDO01	Nikolay Evdokimov	Russia	15	8855
97.	2006GARR01	Lucas Garron	Germany	50	8829
98.	2007FUBO01	Fubo Wang (王富博)	China	26	8788
99.	2009LIUE01	Evan Liu	USA	30	8753
100.	2009HAMO01	James Hamory	USA	24	8693

Code:

SELECT personId, personName, Results.personCountryId, COUNT(distinct Results.competitionId) AS Comps, SUM(peopleRound-(2*pos)+1) AS score
FROM Results
INNER JOIN (SELECT competitionId, eventId, COUNT(distinct personId) AS peopleRound FROM Results GROUP BY competitionId, eventId, roundId) tmp1 ON Results.competitionId=tmp1.competitionId AND Results.eventId=tmp1.eventId 
GROUP BY personId
ORDER BY score DESC
LIMIT 100

antoineccantin · Dec 19, 2013

4. 2009ZEMD01 Feliks Zemdegs Australia 5 14836

Would this be because auscomps usually don't have that many competitors?

Odd WCA stats/ Stats request Thread

Veteran

Veteran

Veteran

Premium Member

Veteran

Veteran

Cupcake

Veteran

Veteran

Premium Member

Platinum Member

Veteran

Platinum Member

Legend

Platinum Member

Legend

Premium Member

Member

Premium Member

Legend

Similar threads