• Welcome to SpeedSolving.com — the world’s largest puzzle community!

    You’re currently browsing as a guest, which means you have limited access to discussions, resources, member profiles, and community features.

    Join 50,000+ cubers and puzzle enthusiasts from around the world to ask questions, share solves, improve faster, and be part of the community.

    Registration is free, fast, and easy — create your account today.

    Already a member? Log in here to hide this message and start participating.
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):
PositionpersonIdpersonNamepersonCountryIdCompsscore
1.2007VALK01Mats ValkNetherlands816739
2.2011ZALE02Marcin ZalewskiPoland1315359
3.2008BARA01Bence BarátHungary1115143
4.2009ZEMD01Feliks ZemdegsAustralia514836
5.2007HESS01Rowe HesslerUSA1413107
6.2010CORM02Louis CormierCanada812268
7.2009PLES01Michał PleskowiczPoland611838
8.2010BREC01John BrechonUSA1211743
9.2010CANT02Antoine CantinCanada711588
10.2012COST01Kevin Costello IIIUSA1311513
11.2006HALC01Michał HalczukPoland911121
12.2008LINE02Edward LinUSA1010964
13.2009YAUR01Robert YauUnited Kingdom810959
14.2009BOZS01Hunor BózsingHungary1110284
15.2010KIPA01Jakub KipaPoland69774
16.2009DIEC01Cornelius DieckmannGermany59713
17.2010APAG01Richard Jay S. ApagarPhilippines99582
18.2012WOLN01Jakub WolniewiczPoland119428
19.2008WEST02Simon WestlundSweden49267
20.2012CHOS01SeungBeom Cho (조승범)Korea39235
21.2007COHE01Dan CohenUSA79187
22.2009ZHAN53Weixing Zhang (张炜星)China59156
23.2009JUNY01Howard Wong Jun Yen (黄俊仁)Malaysia49148
24.2010BENT01Jan BentlageGermany179095
25.2011SZAT01Wojciech SzatanowskiPoland128963
26.2007VALL01Breandan VallanceUnited Kingdom88839
27.2012KALE01Przemysław KaletaPoland98657
28.2012MCNE01Jayden McNeillAustralia68331
29.2010WEYE02Sebastian WeyerGermany47889
30.2010BRAD01Drew BradsUSA47603
31.2008AURO01Sébastien AurouxGermany217363
32.2009OLSO01Christopher OlsonUSA77324
33.2008CLAR01Thompson ClarkeCanada67105
34.2005AKKE01Erik AkkersdijkNetherlands106952
35.2008JONG03Jong-Ho Jeong (정종호)Korea26869
36.2005ZOLN01Tomasz ŻołnowskiPoland156860
37.2008SAJI01Yu Sajima (佐島優)Japan96701
38.2010MALL01Justin MallariUSA56616
39.2011ETTE01Lucas EtterUSA66581
40.2011KUDA01Nurym KudaibergenKazakhstan46403
41.2011NARA02Bhargav NarasimhanIndia96280
42.2009LIUE01Evan LiuUSA86213
43.2009HAMO01James HamoryUSA106113
44.2010WANG07Yinghao Wang (王鹰豪)China96086
45.2009SHEP01Daniel SheppardUnited Kingdom105971
46.2009HAYS01Kevin HaysUSA25908
47.2009KORB01Björn KorbankaGermany125880
48.2007JAKU01Marcin JakubowskiPoland135830
49.2011FYDR01Mateusz FydrychPoland105788
50.2010RICC02Andrew RicciUSA85492
51.2007SUNT01Timothy SunUSA95472
52.2011KNOT01Wojciech KnottPoland75446
53.2009MORI05Paolo MorielloItaly95340
54.2010BURN01Collin BurnsUSA65295
55.2010TANE01Gaurav TanejaIndia95258
56.2011REED01Austin ReedUSA35253
57.2008JAFF01Justin JaffrayCanada65135
58.2007LIME01Eric LimebackCanada65008
59.2010SCHM01Leon SchmidtchenGermany74947
60.2009BARB01Gabriel Dechichi BarbarBrazil64875
61.2008SEAR01Anthony BrooksUSA84854
62.2011ZVYA01Dmitry ZvyagintsevRussia74809
63.2008ANDE02Oscar Roth AndersenDenmark94740
64.2010WEYE01Philipp WeyerGermany44733
65.2012SZEW01Patryk SzewczykPoland84697
66.2009SMIT03Andy SmithUSA24603
67.2010VYNN01Ivan Vynnyk (Іван Винник)Ukraine74591
68.2008KARL02Moritz KarlGermany64561
69.2013WOJT02Jakub WojtaszewskiPoland74498
70.2011CHAN13Swaminathan ChandrasekaranIndia104460
71.2011BILC01Ihor Bilchenko (Ігор Більченко)Ukraine84458
72.2011SHAH01Dharmesh ShahuIndia54429
73.2009RYAB01Sergey RyabkoRussia104371
74.2011STAN02Nick StantonUSA54364
75.2005KOZK01Piotr KózkaPoland54310
76.2007WOOR01Riley WooUSA94301
77.2011SOBR01Alrimar Dias Rocha SobrinhoBrazil64235
78.2009BRZE01Kalina BrzezińskaPoland134139
79.2008MAND01Nikhil MandeIndia74137
80.2011LIMA01Allyson Dias de LimaBrazil94110
81.2009SMAR01Jan SmarschevskiGermany64044
82.2010GARC02Carlos Méndez García-BarrosoSpain64022
83.2011SOAR01Israel Machado SoaresBrazil63990
84.2012RUPE01Akash RupelaIndia63925
85.2008LIKA01Kailong Li (李开隆)China43880
86.2011FATE01Seyyed Mohammad Hossein Fatemi (سید محمد حسین فاطمی)Iran43846
87.2011KIRU01Kesava KirupaIndia43842
88.2012KRIS04Velidi Venkata Jagan Mohana Murali KrishnaIndia83722
89.2011SELZ01Dan SelzerUSA173654
90.2010LANE02Mitchell LaneUSA73634
91.2010LEED02Daniil LeeRussia53555
92.2011KOWA01Marcin KowalczykPoland133533
93.2011VERS03Georgy VershininRussia63508
94.2011MATA01Jorge Castillo MatasSpain63489
95.2008MORE02Hippolyte MoreauFrance123446
96.2010DAVI06Julian DavidCanada63439
97.2010YUPH01Phil YuUSA63403
98.2011STAC01Marcin StachuraPoland93379
99.2011KUMA01Akula Pavan KumarIndia83225
100.2008ZERU01Krzysztof ŻeruchaPoland43223

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):
PositionpersonIdpersonNamepersonCountryIdCompsscore
1.2005AKKE01Erik AkkersdijkNetherlands10064398
2.2007VALK01Mats ValkNetherlands5851916
3.2007HESS01Rowe HesslerUSA7751255
4.2008BARA01Bence BarátHungary5544615
5.2009DIEC01Cornelius DieckmannGermany3036652
6.2005BATI01Milán BaticzHungary4636452
7.2007COHE01Dan CohenUSA5936252
8.2007VALL01Breandan VallanceUnited Kingdom4735748
9.2009PLES01Michał PleskowiczPoland3028993
10.2009ZEMD01Feliks ZemdegsAustralia2125981
11.2008WEST02Simon WestlundSweden2625899
12.2008JAFF01Justin JaffrayCanada4924839
13.2010BREC01John BrechonUSA3923825
14.2008LINE02Edward LinUSA4623687
15.2006HALC01Michał HalczukPoland3823276
16.2005ZOLN01Tomasz ŻołnowskiPoland6923142
17.2007NAKA03Yu Nakajima (中島悠)Japan5621912
18.2011ZALE02Marcin ZalewskiPoland2721903
19.2007SUNT01Timothy SunUSA3921850
20.2008AURO01Sébastien AurouxGermany10221371
21.2006TABU02Yumu Tabuchi (田渕雄夢)Japan3221236
22.2010CORM02Louis CormierCanada2020909
23.2009YAUR01Robert YauUnited Kingdom2220740
24.2005KOZK01Piotr KózkaPoland3919959
25.2009KORB01Björn KorbankaGermany4119811
26.2008CLAR01Thompson ClarkeCanada2919580
27.2009HAYS01Kevin HaysUSA1817676
28.2010WEYE02Sebastian WeyerGermany2217350
29.2008SAJI01Yu Sajima (佐島優)Japan4217238
30.2009MORI05Paolo MorielloItaly4116966
31.2008SMIT04Maarten SmitNetherlands2816578
32.2008HANK01Kanneti Sae Han (คันธ์เนตี แซ่ห่าน)Thailand4016540
33.2008SEAR01Anthony SearleBelize3716420
34.2007OMUR01Syuhei Omura (大村周平)Japan4516399
35.2008VARG01Dániel VargaHungary4616206
36.2007CHAN07Harris ChanCanada2815908
37.2007LIME01Eric LimebackCanada3115769
38.2008KARL02Moritz KarlGermany2915702
39.2009OLSO01Christopher OlsonUSA2815542
40.2009ZHAN53Weixing Zhang (张炜星)China2515318
41.2009JUNY01Howard Wong Jun Yen (黄俊仁)Malaysia2115183
42.2010KIPA01Jakub KipaPoland1415156
43.2012COST01Kevin Costello IIIUSA2614655
44.2009RYAB01Sergey RyabkoRussia2714367
45.2010APAG01Richard Jay S. ApagarPhilippines2314228
46.2010CANT02Antoine CantinCanada1514058
47.2010WEYE01Philipp WeyerGermany2314019
48.2010SCHM01Leon SchmidtchenGermany2313930
49.2005REYN01Tim ReynoldsUSA9013750
50.2009SMAR01Jan SmarschevskiGermany2513672
51.2007ESPI01Phillip EspinozaUSA3813631
52.2008LIKA01Kailong Li (李开隆)China2513605
53.2004CHAM01Edouard ChambonFrance4313436
54.2008JONG03Jong-Ho Jeong (정종호)Korea1413183
55.2006TSAO01Andy TsaoUSA2613007
56.2009CHAR03Nipat Charoenpholphant (นิพัฒน์ เจริญพลพันธุ์)Thailand2212945
57.2005FLEI01Jeremy FleischmanUSA7312835
58.2010RICC02Andrew RicciUSA3212609
59.2009BARB01Gabriel Dechichi BarbarBrazil1912450
60.2009CONT01Giovanni ContardiItaly2012320
61.2010MALL01Justin MallariUSA2412192
62.2012KALE01Przemysław KaletaPoland1612139
63.2009PICH01Piti Pichedpan (ปิติ พิเชษฐพันธ์)Thailand2512027
64.2004KRIG01Gunnar KrigSweden5111932
65.2010VYNN01Ivan Vynnyk (Іван Винник)Ukraine1811827
66.2007GAMB01Jai GambhirCanada2411730
67.2010WANG07Yinghao Wang (王鹰豪)China2911665
68.2007ADSU01Justin AdsuaraUSA3511568
69.2010GARC02Carlos Méndez García-BarrosoSpain1711550
70.2009BOZS01Hunor BózsingHungary2411472
71.2004LOLE01Leyan LoUSA4911218
72.2006BUUS01Henrik Buus AagaardDenmark5411112
73.2007HUBE01Stefan HuberAustria2511083
74.2007POLK01Adam PolkowskiPoland3910943
75.2009SMIT03Andy SmithUSA1510830
76.2006DZOA03Dan DzoanUSA5110713
77.2006GUNJ01Mitsuki Gunji (郡司光貴)Japan3210390
78.2010BENT01Jan BentlageGermany5510329
79.2009SPRI01Alexander SpringhornGermany3010180
80.2009KORB02Lasse KorbankaGermany2710175
81.2008LINH01Hao-Zheng Lin (林浩正)Taiwan2110066
82.2008MIZU01Weston MizumotoUSA3110050
83.2009SHEP01Daniel SheppardUnited Kingdom3110012
84.2007GOUL01Joey GoulyUnited Kingdom619843
85.2007BODO01Bertalan BodorHungary279840
86.2007GUIM01Pedro Santos GuimarãesBrazil219833
87.2012CHOS01SeungBeom ChoKorea59773
88.2009POOK01Baramee Pookcharoen (บารมี พุกเจริญ)Thailand199713
89.2006TEMM01Rama TemminkNetherlands499683
90.2012MCNE01Jayden McNeillAustralia129621
91.2008ANDE02Oscar Roth AndersenDenmark449519
92.2010YUPH01Phil YuUSA349473
93.2007AGUA01Alejandro Aguado BarahonaSpain299439
94.2006OKAY01Yohei Oka (岡要平)Japan559275
95.2009WANG15Emily WangCanada188951
96.2010EVDO01Nikolay EvdokimovRussia158855
97.2006GARR01Lucas GarronGermany508829
98.2007FUBO01Fubo Wang (王富博)China268788
99.2009LIUE01Evan LiuUSA308753
100.2009HAMO01James HamoryUSA248693

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

Wow, I picked my team 2 days ago and my top 15 is incredibly to similar to that top 15... I got 12/15 right, and the 3 I got wrong are up and coming...

Edit: realized the rankings were done differently... Oh well hopefully the results will be similar to Noah's competition.
 
Last edited:
PositionpersonIdpersonNamepersonCountryIdCompsscore
1.2007VALK01Mats ValkNetherlands816739
2.2011ZALE02Marcin ZalewskiPoland1315359
3.2008BARA01Bence BarátHungary1115143
4.2009ZEMD01Feliks ZemdegsAustralia514836
5.2007HESS01Rowe HesslerUSA1413107
6.2010CORM02Louis CormierCanada812268
7.2009PLES01Michał PleskowiczPoland611838
8.2010BREC01John BrechonUSA1211743
9.2010CANT02Antoine CantinCanada711588
10.2012COST01Kevin Costello IIIUSA1311513
11.2006HALC01Michał HalczukPoland911121
12.2008LINE02Edward LinUSA1010964
13.2009YAUR01Robert YauUnited Kingdom810959
14.2009BOZS01Hunor BózsingHungary1110284
15.2010KIPA01Jakub KipaPoland69774
16.2009DIEC01Cornelius DieckmannGermany59713
17.2010APAG01Richard Jay S. ApagarPhilippines99582
18.2012WOLN01Jakub WolniewiczPoland119428
19.2008WEST02Simon WestlundSweden49267
20.2012CHOS01SeungBeom Cho (조승범)Korea39235
21.2007COHE01Dan CohenUSA79187
22.2009ZHAN53Weixing Zhang (张炜星)China59156
23.2009JUNY01Howard Wong Jun Yen (黄俊仁)Malaysia49148
24.2010BENT01Jan BentlageGermany179095
25.2011SZAT01Wojciech SzatanowskiPoland128963
26.2007VALL01Breandan VallanceUnited Kingdom88839
27.2012KALE01Przemysław KaletaPoland98657
28.2012MCNE01Jayden McNeillAustralia68331
29.2010WEYE02Sebastian WeyerGermany47889
30.2010BRAD01Drew BradsUSA47603
31.2008AURO01Sébastien AurouxGermany217363
32.2009OLSO01Christopher OlsonUSA77324
33.2008CLAR01Thompson ClarkeCanada67105
34.2005AKKE01Erik AkkersdijkNetherlands106952
35.2008JONG03Jong-Ho Jeong (정종호)Korea26869
36.2005ZOLN01Tomasz ŻołnowskiPoland156860
37.2008SAJI01Yu Sajima (佐島優)Japan96701
38.2010MALL01Justin MallariUSA56616
39.2011ETTE01Lucas EtterUSA66581
40.2011KUDA01Nurym KudaibergenKazakhstan46403
41.2011NARA02Bhargav NarasimhanIndia96280
42.2009LIUE01Evan LiuUSA86213
43.2009HAMO01James HamoryUSA106113
44.2010WANG07Yinghao Wang (王鹰豪)China96086
45.2009SHEP01Daniel SheppardUnited Kingdom105971
46.2009HAYS01Kevin HaysUSA25908
47.2009KORB01Björn KorbankaGermany125880
48.2007JAKU01Marcin JakubowskiPoland135830
49.2011FYDR01Mateusz FydrychPoland105788
50.2010RICC02Andrew RicciUSA85492
51.2007SUNT01Timothy SunUSA95472
52.2011KNOT01Wojciech KnottPoland75446
53.2009MORI05Paolo MorielloItaly95340
54.2010BURN01Collin BurnsUSA65295
55.2010TANE01Gaurav TanejaIndia95258
56.2011REED01Austin ReedUSA35253
57.2008JAFF01Justin JaffrayCanada65135
58.2007LIME01Eric LimebackCanada65008
59.2010SCHM01Leon SchmidtchenGermany74947
60.2009BARB01Gabriel Dechichi BarbarBrazil64875
61.2008SEAR01Anthony BrooksUSA84854
62.2011ZVYA01Dmitry ZvyagintsevRussia74809
63.2008ANDE02Oscar Roth AndersenDenmark94740
64.2010WEYE01Philipp WeyerGermany44733
65.2012SZEW01Patryk SzewczykPoland84697
66.2009SMIT03Andy SmithUSA24603
67.2010VYNN01Ivan Vynnyk (Іван Винник)Ukraine74591
68.2008KARL02Moritz KarlGermany64561
69.2013WOJT02Jakub WojtaszewskiPoland74498
70.2011CHAN13Swaminathan ChandrasekaranIndia104460
71.2011BILC01Ihor Bilchenko (Ігор Більченко)Ukraine84458
72.2011SHAH01Dharmesh ShahuIndia54429
73.2009RYAB01Sergey RyabkoRussia104371
74.2011STAN02Nick StantonUSA54364
75.2005KOZK01Piotr KózkaPoland54310
76.2007WOOR01Riley WooUSA94301
77.2011SOBR01Alrimar Dias Rocha SobrinhoBrazil64235
78.2009BRZE01Kalina BrzezińskaPoland134139
79.2008MAND01Nikhil MandeIndia74137
80.2011LIMA01Allyson Dias de LimaBrazil94110
81.2009SMAR01Jan SmarschevskiGermany64044
82.2010GARC02Carlos Méndez García-BarrosoSpain64022
83.2011SOAR01Israel Machado SoaresBrazil63990
84.2012RUPE01Akash RupelaIndia63925
85.2008LIKA01Kailong Li (李开隆)China43880
86.2011FATE01Seyyed Mohammad Hossein Fatemi (سید محمد حسین فاطمی)Iran43846
87.2011KIRU01Kesava KirupaIndia43842
88.2012KRIS04Velidi Venkata Jagan Mohana Murali KrishnaIndia83722
89.2011SELZ01Dan SelzerUSA173654
90.2010LANE02Mitchell LaneUSA73634
91.2010LEED02Daniil LeeRussia53555
92.2011KOWA01Marcin KowalczykPoland133533
93.2011VERS03Georgy VershininRussia63508
94.2011MATA01Jorge Castillo MatasSpain63489
95.2008MORE02Hippolyte MoreauFrance123446
96.2010DAVI06Julian DavidCanada63439
97.2010YUPH01Phil YuUSA63403
98.2011STAC01Marcin StachuraPoland93379
99.2011KUMA01Akula Pavan KumarIndia83225
100.2008ZERU01Krzysztof ŻeruchaPoland43223
I forgot Marcin Zalewski and KC3, and idk who Louis Cormier or John Brecon are. And I chose Yu Nakajima, who isn't even in this year's top 100. I'm beginning to think I didn't choose a good team...
 
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):
PositionpersonIdpersonNamepersonCountryIdCompsscore
1.2007VALK01Mats ValkNetherlands816739
2.2011ZALE02Marcin ZalewskiPoland1315359
3.2008BARA01Bence BarátHungary1115143
4.2009ZEMD01Feliks ZemdegsAustralia514836
5.2007HESS01Rowe HesslerUSA1413107
6.2010CORM02Louis CormierCanada812268
7.2009PLES01Michał PleskowiczPoland611838
8.2010BREC01John BrechonUSA1211743
9.2010CANT02Antoine CantinCanada711588
10.2012COST01Kevin Costello IIIUSA1311513
11.2006HALC01Michał HalczukPoland911121
12.2008LINE02Edward LinUSA1010964
13.2009YAUR01Robert YauUnited Kingdom810959
14.2009BOZS01Hunor BózsingHungary1110284
15.2010KIPA01Jakub KipaPoland69774
16.2009DIEC01Cornelius DieckmannGermany59713
17.2010APAG01Richard Jay S. ApagarPhilippines99582
18.2012WOLN01Jakub WolniewiczPoland119428
19.2008WEST02Simon WestlundSweden49267
20.2012CHOS01SeungBeom Cho (조승범)Korea39235
21.2007COHE01Dan CohenUSA79187
22.2009ZHAN53Weixing Zhang (张炜星)China59156
23.2009JUNY01Howard Wong Jun Yen (黄俊仁)Malaysia49148
24.2010BENT01Jan BentlageGermany179095
25.2011SZAT01Wojciech SzatanowskiPoland128963
26.2007VALL01Breandan VallanceUnited Kingdom88839
27.2012KALE01Przemysław KaletaPoland98657
28.2012MCNE01Jayden McNeillAustralia68331
29.2010WEYE02Sebastian WeyerGermany47889
30.2010BRAD01Drew BradsUSA47603
31.2008AURO01Sébastien AurouxGermany217363
32.2009OLSO01Christopher OlsonUSA77324
33.2008CLAR01Thompson ClarkeCanada67105
34.2005AKKE01Erik AkkersdijkNetherlands106952
35.2008JONG03Jong-Ho Jeong (정종호)Korea26869
36.2005ZOLN01Tomasz ŻołnowskiPoland156860
37.2008SAJI01Yu Sajima (佐島優)Japan96701
38.2010MALL01Justin MallariUSA56616
39.2011ETTE01Lucas EtterUSA66581
40.2011KUDA01Nurym KudaibergenKazakhstan46403
41.2011NARA02Bhargav NarasimhanIndia96280
42.2009LIUE01Evan LiuUSA86213
43.2009HAMO01James HamoryUSA106113
44.2010WANG07Yinghao Wang (王鹰豪)China96086
45.2009SHEP01Daniel SheppardUnited Kingdom105971
46.2009HAYS01Kevin HaysUSA25908
47.2009KORB01Björn KorbankaGermany125880
48.2007JAKU01Marcin JakubowskiPoland135830
49.2011FYDR01Mateusz FydrychPoland105788
50.2010RICC02Andrew RicciUSA85492
51.2007SUNT01Timothy SunUSA95472
52.2011KNOT01Wojciech KnottPoland75446
53.2009MORI05Paolo MorielloItaly95340
54.2010BURN01Collin BurnsUSA65295
55.2010TANE01Gaurav TanejaIndia95258
56.2011REED01Austin ReedUSA35253
57.2008JAFF01Justin JaffrayCanada65135
58.2007LIME01Eric LimebackCanada65008
59.2010SCHM01Leon SchmidtchenGermany74947
60.2009BARB01Gabriel Dechichi BarbarBrazil64875
61.2008SEAR01Anthony BrooksUSA84854
62.2011ZVYA01Dmitry ZvyagintsevRussia74809
63.2008ANDE02Oscar Roth AndersenDenmark94740
64.2010WEYE01Philipp WeyerGermany44733
65.2012SZEW01Patryk SzewczykPoland84697
66.2009SMIT03Andy SmithUSA24603
67.2010VYNN01Ivan Vynnyk (Іван Винник)Ukraine74591
68.2008KARL02Moritz KarlGermany64561
69.2013WOJT02Jakub WojtaszewskiPoland74498
70.2011CHAN13Swaminathan ChandrasekaranIndia104460
71.2011BILC01Ihor Bilchenko (Ігор Більченко)Ukraine84458
72.2011SHAH01Dharmesh ShahuIndia54429
73.2009RYAB01Sergey RyabkoRussia104371
74.2011STAN02Nick StantonUSA54364
75.2005KOZK01Piotr KózkaPoland54310
76.2007WOOR01Riley WooUSA94301
77.2011SOBR01Alrimar Dias Rocha SobrinhoBrazil64235
78.2009BRZE01Kalina BrzezińskaPoland134139
79.2008MAND01Nikhil MandeIndia74137
80.2011LIMA01Allyson Dias de LimaBrazil94110
81.2009SMAR01Jan SmarschevskiGermany64044
82.2010GARC02Carlos Méndez García-BarrosoSpain64022
83.2011SOAR01Israel Machado SoaresBrazil63990
84.2012RUPE01Akash RupelaIndia63925
85.2008LIKA01Kailong Li (李开隆)China43880
86.2011FATE01Seyyed Mohammad Hossein Fatemi (سید محمد حسین فاطمی)Iran43846
87.2011KIRU01Kesava KirupaIndia43842
88.2012KRIS04Velidi Venkata Jagan Mohana Murali KrishnaIndia83722
89.2011SELZ01Dan SelzerUSA173654
90.2010LANE02Mitchell LaneUSA73634
91.2010LEED02Daniil LeeRussia53555
92.2011KOWA01Marcin KowalczykPoland133533
93.2011VERS03Georgy VershininRussia63508
94.2011MATA01Jorge Castillo MatasSpain63489
95.2008MORE02Hippolyte MoreauFrance123446
96.2010DAVI06Julian DavidCanada63439
97.2010YUPH01Phil YuUSA63403
98.2011STAC01Marcin StachuraPoland93379
99.2011KUMA01Akula Pavan KumarIndia83225
100.2008ZERU01Krzysztof ŻeruchaPoland43223

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):
PositionpersonIdpersonNamepersonCountryIdCompsscore
1.2005AKKE01Erik AkkersdijkNetherlands10064398
2.2007VALK01Mats ValkNetherlands5851916
3.2007HESS01Rowe HesslerUSA7751255
4.2008BARA01Bence BarátHungary5544615
5.2009DIEC01Cornelius DieckmannGermany3036652
6.2005BATI01Milán BaticzHungary4636452
7.2007COHE01Dan CohenUSA5936252
8.2007VALL01Breandan VallanceUnited Kingdom4735748
9.2009PLES01Michał PleskowiczPoland3028993
10.2009ZEMD01Feliks ZemdegsAustralia2125981
11.2008WEST02Simon WestlundSweden2625899
12.2008JAFF01Justin JaffrayCanada4924839
13.2010BREC01John BrechonUSA3923825
14.2008LINE02Edward LinUSA4623687
15.2006HALC01Michał HalczukPoland3823276
16.2005ZOLN01Tomasz ŻołnowskiPoland6923142
17.2007NAKA03Yu Nakajima (中島悠)Japan5621912
18.2011ZALE02Marcin ZalewskiPoland2721903
19.2007SUNT01Timothy SunUSA3921850
20.2008AURO01Sébastien AurouxGermany10221371
21.2006TABU02Yumu Tabuchi (田渕雄夢)Japan3221236
22.2010CORM02Louis CormierCanada2020909
23.2009YAUR01Robert YauUnited Kingdom2220740
24.2005KOZK01Piotr KózkaPoland3919959
25.2009KORB01Björn KorbankaGermany4119811
26.2008CLAR01Thompson ClarkeCanada2919580
27.2009HAYS01Kevin HaysUSA1817676
28.2010WEYE02Sebastian WeyerGermany2217350
29.2008SAJI01Yu Sajima (佐島優)Japan4217238
30.2009MORI05Paolo MorielloItaly4116966
31.2008SMIT04Maarten SmitNetherlands2816578
32.2008HANK01Kanneti Sae Han (คันธ์เนตี แซ่ห่าน)Thailand4016540
33.2008SEAR01Anthony SearleBelize3716420
34.2007OMUR01Syuhei Omura (大村周平)Japan4516399
35.2008VARG01Dániel VargaHungary4616206
36.2007CHAN07Harris ChanCanada2815908
37.2007LIME01Eric LimebackCanada3115769
38.2008KARL02Moritz KarlGermany2915702
39.2009OLSO01Christopher OlsonUSA2815542
40.2009ZHAN53Weixing Zhang (张炜星)China2515318
41.2009JUNY01Howard Wong Jun Yen (黄俊仁)Malaysia2115183
42.2010KIPA01Jakub KipaPoland1415156
43.2012COST01Kevin Costello IIIUSA2614655
44.2009RYAB01Sergey RyabkoRussia2714367
45.2010APAG01Richard Jay S. ApagarPhilippines2314228
46.2010CANT02Antoine CantinCanada1514058
47.2010WEYE01Philipp WeyerGermany2314019
48.2010SCHM01Leon SchmidtchenGermany2313930
49.2005REYN01Tim ReynoldsUSA9013750
50.2009SMAR01Jan SmarschevskiGermany2513672
51.2007ESPI01Phillip EspinozaUSA3813631
52.2008LIKA01Kailong Li (李开隆)China2513605
53.2004CHAM01Edouard ChambonFrance4313436
54.2008JONG03Jong-Ho Jeong (정종호)Korea1413183
55.2006TSAO01Andy TsaoUSA2613007
56.2009CHAR03Nipat Charoenpholphant (นิพัฒน์ เจริญพลพันธุ์)Thailand2212945
57.2005FLEI01Jeremy FleischmanUSA7312835
58.2010RICC02Andrew RicciUSA3212609
59.2009BARB01Gabriel Dechichi BarbarBrazil1912450
60.2009CONT01Giovanni ContardiItaly2012320
61.2010MALL01Justin MallariUSA2412192
62.2012KALE01Przemysław KaletaPoland1612139
63.2009PICH01Piti Pichedpan (ปิติ พิเชษฐพันธ์)Thailand2512027
64.2004KRIG01Gunnar KrigSweden5111932
65.2010VYNN01Ivan Vynnyk (Іван Винник)Ukraine1811827
66.2007GAMB01Jai GambhirCanada2411730
67.2010WANG07Yinghao Wang (王鹰豪)China2911665
68.2007ADSU01Justin AdsuaraUSA3511568
69.2010GARC02Carlos Méndez García-BarrosoSpain1711550
70.2009BOZS01Hunor BózsingHungary2411472
71.2004LOLE01Leyan LoUSA4911218
72.2006BUUS01Henrik Buus AagaardDenmark5411112
73.2007HUBE01Stefan HuberAustria2511083
74.2007POLK01Adam PolkowskiPoland3910943
75.2009SMIT03Andy SmithUSA1510830
76.2006DZOA03Dan DzoanUSA5110713
77.2006GUNJ01Mitsuki Gunji (郡司光貴)Japan3210390
78.2010BENT01Jan BentlageGermany5510329
79.2009SPRI01Alexander SpringhornGermany3010180
80.2009KORB02Lasse KorbankaGermany2710175
81.2008LINH01Hao-Zheng Lin (林浩正)Taiwan2110066
82.2008MIZU01Weston MizumotoUSA3110050
83.2009SHEP01Daniel SheppardUnited Kingdom3110012
84.2007GOUL01Joey GoulyUnited Kingdom619843
85.2007BODO01Bertalan BodorHungary279840
86.2007GUIM01Pedro Santos GuimarãesBrazil219833
87.2012CHOS01SeungBeom ChoKorea59773
88.2009POOK01Baramee Pookcharoen (บารมี พุกเจริญ)Thailand199713
89.2006TEMM01Rama TemminkNetherlands499683
90.2012MCNE01Jayden McNeillAustralia129621
91.2008ANDE02Oscar Roth AndersenDenmark449519
92.2010YUPH01Phil YuUSA349473
93.2007AGUA01Alejandro Aguado BarahonaSpain299439
94.2006OKAY01Yohei Oka (岡要平)Japan559275
95.2009WANG15Emily WangCanada188951
96.2010EVDO01Nikolay EvdokimovRussia158855
97.2006GARR01Lucas GarronGermany508829
98.2007FUBO01Fubo Wang (王富博)China268788
99.2009LIUE01Evan LiuUSA308753
100.2009HAMO01James HamoryUSA248693

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

damn. Had no idea I would be third all time and fifth this year. Should've picked myself :P
 
Hi Guys,
I was curious about which country dominate in each event single. I considered sum of ranks, but anyway i applied a scoring from ski jumping, so i consider top30 from every event single and sum points for every country :)
ScoreCountryEvent
273,00 :confused:Italy222
72,00Australia222
71,00USA222
45,00Brazil222
45,00China222
40,00Poland222
36,00Netherlands222
29,00Spain222
25,00Canada222
18,00France222
18,00Germany222
14,00Thailand222
13,00Japan222
5,00Iran222
ScoreCountryEvent
102,00Australia333
100,00Netherlands333
94,00USA333
90,00Japan333
74,00Poland333
67,00United Kingdom333
66,00Thailand333
27,00Taiwan333
20,00Canada333
18,00Indonesia333
16,00Philippines333
16,00Germany333
12,00Russia333
12,00Italy333
8,00France333
6,00Hungary333
6,00Belize333
ScoreCountryEvent
131,00USA444
100,00Australia444
80,00Germany444
80,00Netherlands444
60,00Japan444
53,00China444
40,00Brazil444
36,00Korea444
32,00Italy444
23,00Thailand444
22,00Indonesia444
18,00Kazakhstan444
14,00Russia444
12,00Poland444
7,00Sweden444
5,00United Kingdom444
4,00Hungary444
ScoreCountryEvent
125,00USA555
100,00Australia555
88,00Japan555
66,00Canada555
60,00Korea555
48,00United Kingdom555
42,00China555
36,00Poland555
36,00Netherlands555
32,00Thailand555
24,00Germany555
19,00Taiwan555
18,00Norway555
15,00Hungary555
8,00Italy555
ScoreCountryEvent
178,00USA666
134,00China666
85,00Poland666
60,00Australia666
47,00Russia666
43,00Hungary666
36,00Japan666
32,00Korea666
29,00Finland666
18,00Netherlands666
16,00Taiwan666
15,00Thailand666
12,00United Kingdom666
8,00Austria666
4,00Germany666
ScoreCountryEvent
179,00China777
121,00USA777
100,00Hungary777
61,00Poland777
60,00Australia777
36,00Russia777
33,00Japan777
32,00Korea777
29,00Finland777
14,00Germany777
13,00Thailand777
11,00Austria777
9,00Netherlands777
8,00Brazil777
6,00Canada777
3,00Malaysia777
2,00Italy777
ScoreCountryEvent
108,00Poland333oh
100,00Australia333oh
80,00Italy333oh
69,00Thailand333oh
68,00USA333oh
60,00Brazil333oh
49,00Japan333oh
44,00Russia333oh
36,00United Kingdom333oh
29,00China333oh
26,00Hungary333oh
16,00Netherlands333oh
11,00Denmark333oh
8,00Canada333oh
8,00Philippines333oh
5,00Norway333oh
3,00Germany333oh
ScoreCountryEvent
188,00Chinasq1
100,00Italysq1
77,00USAsq1
66,00Polandsq1
65,00Japansq1
60,00United Kingdomsq1
50,00Taiwansq1
24,00Malaysiasq1
22,00Netherlandssq1
20,00New Zealandsq1
11,00Hungarysq1
10,00Swedensq1
9,00Francesq1
8,00Czech Republicsq1
6,00Russiasq1
2,00Koreasq1
ScoreCountryEvent
124,00Swedenminx
80,00Hungaryminx
73,00Canadaminx
65,00Koreaminx
58,00Australiaminx
56,00USAminx
50,00Denmarkminx
35,00Colombiaminx
29,00Germanyminx
29,00Malaysiaminx
29,00Germanyminx
26,00Sloveniaminx
22,00Polandminx
20,00United Kingdomminx
14,00Italyminx
11,00Philippinesminx
8,00Austriaminx
7,00Chinaminx
6,00Japanminx
4,00Taiwanminx
ScoreCountryEvent
127,00Polandpyram
100,00Denmarkpyram
95,00Hungarypyram
85,00Brazilpyram
81,00USApyram
75,00Indonesiapyram
62,00Japanpyram
45,00Francepyram
18,00Chinapyram
16,00Latviapyram
8,00Australiapyram
6,00Vietnampyram
4,00Russiapyram
2,00Swedenpyram
2,00Finlandpyram
ScoreCountryEvent
193,00Indonesia333ft
140,00Japan333ft
123,00Brazil333ft
50,00Denmark333ft
47,00Korea333ft
41,00Poland333ft
36,00Finland333ft
32,00Canada333ft
26,00Thailand333ft
16,00USA333ft
7,00Netherlands333ft
5,00Taiwan333ft
2,00Hungary333ft
ScoreCountryEvent
129,00USAclock
124,00Chinaclock
85,00Indonesiaclock
67,00Spainclock
60,00Finlandclock
53,00Japanclock
40,00Netherlandsclock
40,00Franceclock
32,00Thailandclock
31,00United Kingdomclock
27,00Germanyclock
17,00Hungaryclock
15,00Taiwanclock
9,00Polandclock
ScoreCountryEvent
168,00Japan333fm
135,00Germany333fm
92,00Hungary333fm
70,00Belgium333fm
68,00USA333fm
68,00Netherlands333fm
46,00Spain333fm
36,00France333fm
22,00Korea333fm
22,00Finland333fm
22,00China333fm
10,00United Kingdom333fm
10,00Russia333fm
10,00Poland333fm
10,00Iran333fm
ScoreCountryEvent
220,00Poland333bf
99,00USA333bf
97,00China333bf
61,00Hungary333bf
60,00Mexico333bf
37,00Australia333bf
36,00Chile333bf
30,00Indonesia333bf
29,00Russia333bf
12,00Brazil333bf
10,00Italy333bf
9,00Germany333bf
7,00Spain333bf
5,00United Kingdom333bf
3,00Canada333bf
2,00Finland333bf
ScoreCountryEvent
148,00United Kingdom444bf
100,00Hungary444bf
97,00Russia444bf
87,00Poland444bf
50,00Australia444bf
47,00China444bf
39,00USA444bf
32,00Italy444bf
31,00Canada444bf
23,00Germany444bf
20,00Mexico444bf
16,00Malaysia444bf
13,00Finland444bf
9,00Austria444bf
5,00Brazil444bf
ScoreCountryEvent
149,00United Kingdom555bf
107,00Hungary555bf
86,00Russia555bf
68,00China555bf
64,00Poland555bf
44,00Indonesia555bf
40,00Australia555bf
35,00Italy555bf
34,00USA555bf
32,00Germany555bf
32,00Finland555bf
32,00Germany555bf
22,00Austria555bf
4,00Canada555bf
2,00Malaysia555bf
ScoreCountryEvent
154,00Poland333mbf
94,00USA333mbf
90,00Hungary333mbf
55,00China333mbf
55,00Russia333mbf
55,00China333mbf
50,00Australia333mbf
46,00Germany333mbf
36,00Malaysia333mbf
36,00United Kingdom333mbf
25,00Sweden333mbf
24,00Indonesia333mbf
20,00Austria333mbf
16,00Canada333mbf
13,00Italy333mbf
3,00India333mbf
 
Hi!
https://www.worldcubeassociation.org/results/statistics.php#most_solves
Could someone make a longer list for the very last one?
Thanks!

Top 50, including duplicate people.
Code:
2008AURO01	Sébastien Auroux	2012	2033	2122
2008AURO01	Sébastien Auroux	2011	1842	1923
2008COUR01	François Courtès	2013	1651	1780
2008AURO01	Sébastien Auroux	2013	1578	1651
2010MOFF02	Zoé de Moffarts		2012	1518	1575
2008AURO01	Sébastien Auroux	2010	1513	1602
2006GALE01	Arnaud van Galen	2012	1481	1568
2005AKKE01	Erik Akkersdijk		2010	1477	1609
2010BENT01	Jan Bentlage		2012	1452	1517
2008COUR01	François Courtès	2011	1407	1576
2010BENT01	Jan Bentlage		2013	1363	1422
2008BARA01	Bence Barát		2010	1349	1392
2008COUR01	François Courtès	2012	1308	1439
2006GALE01	Arnaud van Galen	2009	1244	1308
2004GALL02	Clément Gallet		2011	1213	1249
2005REYN01	Tim Reynolds		2012	1205	1281
2005AKKE01	Erik Akkersdijk		2011	1182	1271
2009OHRN01	Laura Ohrndorf		2013	1148	1245
2007NAKA03	Yu Nakajima (中島悠)	2012	1124	1151
2009ROHR01	Michael Röhrer		2012	1112	1187
2005AKKE01	Erik Akkersdijk		2009	1094	1186
2005AKKE01	Erik Akkersdijk		2012	1085	1162
2008COUR01	François Courtès	2010	1047	1169
2004GALL02	Clément Gallet		2009	1034	1075
2004GALL02	Clément Gallet		2012	1032	1048
2008BARA01	Bence Barát		2013	1012	1043
2010BICL01	Geert Bicler		2012	999	1043
2008VARG01	Dániel Varga		2012	974	1000
2008COUR01	François Courtès	2009	967	1047
2011ZALE02	Marcin Zalewski		2013	946	1066
2003VAND01	Lars Vandenbergh	2009	922	945
2012POHL01	Andreas Pohl		2013	907	1009
2007GOUL01	Joey Gouly		2010	903	984
2008BARA01	Bence Barát		2011	894	931
2009SHEP01	Daniel Sheppard		2013	892	910
2007COHE01	Dan Cohen		2011	889	960
2011SAKO01	Corey Sakowski		2013	887	917
2007SUGA01	Nobuaki Suga (菅信昭)	2012	887	929
2010BENT01	Jan Bentlage		2011	883	925
2004GALL02	Clément Gallet		2010	882	908
2008MORE02	Hippolyte Moreau	2013	867	933
2006GALE01	Arnaud van Galen	2013	857	889
2009BOZS01	Hunor Bózsing		2013	850	885
2007HESS01	Rowe Hessler		2012	850	903
2007JAKU01	Marcin Jakubowski	2013	848	909
2005AKKE01	Erik Akkersdijk		2008	847	918
2009KASU01	Sanio Kasumovic		2012	830	892
2005REYN01	Tim Reynolds		2011	829	876
2003VAND01	Lars Vandenbergh	2008	826	844
2011SZAT01	Wojciech Szatanowski	2013	826	885
 
I'd like to see this one too

Also, optimal guildford challenge teams (2 man, 3 man, 4 man and 5 man) including 3bld means. (counting by the persons official averages)

BLD is not a part of Guildford Challenge. Even though there are now rankings for 3BLD means it is not becoming a part of the Guildford Challenge.

Sincerely,
Someone from Guildford
 
(except the first comp of the country where obvio first prizes at all events would be NRs)?

Why "obvio" ? The fastest people of the country may very wel have already competed elsewhere. For example, at the first Swiss competition (Geneva Open 2008), only 4 Swiss NRs out of 17 possible were broken.
 
This week-end there are 3 competitions with 100+ competitors: Techfest Mania 2014 (103), Shaastra Cube Open 2014 (383) and Warsaw Open 2014 (132).
Has this ever happened (2 or more competitions with 100+ cubers on the same week-end)?
 
Back
Top