Odd WCA stats/ Stats request Thread

[tx789]

Sameer Mahmood got 2x2 wr average at his first comp.

 

[mycube]

After I learned some SQL, I thought it would be cool to have some WCA stats, so here are my first. Special credits to Gregor, who helped me a lot
The statistics are all top100.

List of most solves done until now + DNFs

Spoiler

Rank	Name	Solves	DNFs
1	Sébastien Auroux	11633	523
2	François Courtès	9827	916
3	Bence Barát	9179	292
4	Jan Bentlage	8672	380
5	Erik Akkersdijk	8160	593
6	Wojciech Szatanowski	7052	283
7	Arnaud van Galen	6893	417
8	Tim Reynolds	6363	345
9	Dániel Varga	6184	200
10	Olivér Perge	6040	488
11	Clément Gallet	5825	189
12	Marcin Jakubowski	5418	383
13	Ron van Bruchem	5397	179
14	Mats Valk	5256	287
15	Lars Vandenbergh	5188	156
16	Joey Gouly	5100	358
17	Michał Halczuk	5086	84
18	Laura Ohrndorf	5081	345
19	Daniel Sheppard	4978	205
20	Hunor Bózsing	4900	147
21	Rafael Werneck Cinoto	4845	200
22	Robert Yau	4764	196
23	Henrik Buus Aagaard	4701	249
24	Tomasz Żołnowski	4501	182
25	Rowe Hessler	4474	307
26	Fabio Bini Graciose	4451	87
27	Cornelius Dieckmann	4391	251
28	Michał Pleskowicz	4376	196
29	Wojciech Knott	4342	146
30	Lorenzo Vigani Poli	4302	257
31	Evan Liu	4184	211
32	Corey Sakowski	4045	189
33	Bob Burton	3985	199
34	Yinghao Wang (王鹰豪)	3935	209
35	Ivan Zabrodin	3905	242
36	Andreas Pohl	3901	393
37	Ihor Bilchenko (Ігор Більченко)	3805	211
38	Gunnar Krig	3772	217
39	Przemysław Kaleta	3768	69
40	Dan Cohen	3758	349
41	Feliks Zemdegs	3746	148
42	Michael Röhrer	3707	160
43	Milán Baticz	3652	230
44	Jakub Kipa	3615	181
45	James Hildreth	3612	238
46	Nathan Dwyer	3590	269
47	John Brechon	3586	178
48	Leon Schmidtchen	3569	49
49	Alexander Olleta del Molino	3562	296
50	Javier Tirado Ortiz	3506	332
51	James Molloy	3467	230
52	Michael Young	3413	170
53	Jayden McNeill	3387	84
54	Ming Zheng (郑鸣)	3378	62
55	Callum Hales-Jepp	3373	208
56	Björn Korbanka	3367	105
57	Ton Dennenbroek	3360	221
58	Dan Selzer	3357	246
59	Antoine Cantin	3331	181
60	Nobuaki Suga (菅信昭)	3305	208
61	Hippolyte Moreau	3299	261
62	Yi-Fan Wu (吳亦凡)	3249	50
63	Philippe Virouleau	3240	55
64	Nathaniel Berg	3212	128
65	Christopher Olson	3193	201
66	Oscar Roth Andersen	3171	184
67	Zoé de Moffarts	3149	113
68	Breandan Vallance	3137	207
69	Wilhelm Kilders	3131	153
70	Thompson Clarke	3093	105
71	Kian Barry	3090	254
72	Kit Clement	3082	279
73	Jakub Wolniewicz	3081	83
74	Filippo Brancaleoni	3057	249
75	Jong-Ho Jeong (정종호)	3036	164
76	Paolo Moriello	3029	106
77	Piotr Kózka	3027	96
78	Matic Omulec	3010	111
79	Piotr Michał Padlewski	3008	91
80	Blake Thompson	3005	65
81	Anthony Brooks	2984	198
82	Reto Bubendorf	2983	137
83	Edward Lin	2965	84
84	Ryan Jew	2962	122
85	Geert Bicler	2936	77
86	Walker Welch	2910	184
87	Jeremy Fleischman	2909	45
88	István Kocza	2900	342
89	Artem Melikian (Артем Мелікян)	2897	118
90	Bhargav Narasimhan	2888	166
91	Shivam Bansal	2878	176
92	Linus Fresz	2858	247
93	Simon Westlund	2844	138
94	Oscar Alberto Ceballos Contreras	2825	167
95	Akash Rupela	2823	115
96	Yuhei Takagi (高木佑平)	2820	228
97	Ilya Tsiareshka	2805	135
98	Marcin Stachura	2790	70
99	Lucas Garron	2758	231
100	Brúnó Bereczki	2757	126

SELECT  personName, Count(value1 > 0 OR NULL) + Count(value2 > 0 OR NULL) + Count(value3 > 0 OR NULL) + Count(value4 > 0 OR NULL) + Count(value5 > 0 OR NULL) AS solves, Count(value1 = -1 OR NULL) + Count(value2 = -1 OR NULL) + Count(value3 = -1 OR NULL) + Count(value4 = -1 OR NULL) + Count(value5 = -1 OR NULL) AS dnfs
FROM Results
GROUP BY personName
ORDER BY solves DESC
Limit 100

(will split this post because it's to big)

 

[mycube]

part 2:

For the next two I chose to use only competitors with > 500 solves
Highest percentage dnf/solves

Spoiler

Rank	Name	Solves	DNFs	Percentage
1	Sarah Strong	1546	444	28.7193
2	Taku Yanai (矢内拓)	711	204	28.6920
3	Noah Arthurs	1274	326	25.5887
4	Grzegorz Jałocha	647	155	23.9567
5	Fabrizio Cirnigliaro	823	185	22.4787
6	Francisco Javier Lemes Sáez	818	180	22.0049
7	Oliver Frost	963	209	21.7030
8	Arvid Skarrie	526	108	20.5323
9	Matteo Colombo	1295	263	20.3089
10	Walter Pereira Rodrigues de Souza	536	108	20.1493
11	Deni Mintsaev	850	166	19.5294
12	Bruce Norskog	675	131	19.4074
13	Axel Häck	860	166	19.3023
14	Artem Savosik	869	164	18.8723
15	Ryan Reese	511	96	18.7867
16	Jael Riggenbach	665	124	18.6466
17	Michał Tomański	519	94	18.1118
18	Sreeram Venkatarao	568	101	17.7817
19	Shelley Chang	1338	237	17.7130
20	Guillaume Erbibou	747	127	17.0013
21	Raúl Morales Hidalgo	619	103	16.6397
22	Victor Cullot	620	101	16.2903
23	Andrey Ivanov	722	115	15.9280
24	Marcin Kowalczyk	1087	170	15.6394
25	Takayuki Matsumoto (松本孝之)	551	86	15.6080
26	Carlos Angosto Hernández	673	105	15.6018
27	Gilberto Caracciolo Morelli	1226	190	15.4976
28	Gregor Billing	934	143	15.3105
29	Krzysztof Bober	719	109	15.1599
30	Daniel Chudecki	556	84	15.1079
31	Laís Azevedo Martins da Silva	1099	165	15.0136
32	Lauren Klemz	614	92	14.9837
33	Tyson Mao (毛台勝)	574	86	14.9826
34	Markus Pirzer	1789	268	14.9804
35	Qirun Zhong (钟奇润)	564	83	14.7163
36	Adam Zamora	1570	231	14.7134
37	Shusei Tabuchi (田渕柊星)	568	83	14.6127
38	Janne Lehtimäki	521	76	14.5873
39	Mike Kotch	1920	280	14.5833
40	Han Wu (吳翰)	694	101	14.5533
41	Didiet Aditya Bayu Kusuma	692	99	14.3064
42	Kou Oobatake (大畠功)	811	116	14.3033
43	Natán Riggenbach	940	134	14.2553
44	Xin Shi (石欣)	1031	146	14.1610
45	Vivek Prasad Mada	767	108	14.0808
46	Xu Zhao (赵旭)	696	98	14.0805
47	Tomasz Korzeniewski	523	73	13.9579
48	Francisco Garrido Valenzuela	558	77	13.7993
49	Frank Severinsen	1405	189	13.4520
50	Péter Trombitás	1099	147	13.3758
51	Oleksandr Ivanchak (Олександр Іванчак)	1062	142	13.3710
52	Tomoyuki Hiraide (平出智之)	518	69	13.3205
53	Luchen Zhang (张录辰)	673	89	13.2244
54	Maxim Chechnev	1490	196	13.1544
55	José Felipe Duarte Coronado	639	84	13.1455
56	Adrian Lehmann	1755	228	12.9915
57	Zane Carney	764	99	12.9581
58	M Aashrit Krishna Sankaran	758	98	12.9288
59	Daniel Lundwall	932	119	12.7682
60	Sanae Omyo (大名佐苗)	886	113	12.7540
61	Olli Vikstedt	684	87	12.7193
62	Hari Anirudh	756	96	12.6984
63	Billy Jeffs	1176	148	12.5850
64	Maximilian Neitzel	1021	128	12.5367
65	Shaden Smith	877	109	12.4287
66	Dmitry Karyakin	507	63	12.4260
67	Michał Bogdan	1124	139	12.3665
68	Marcin Zalewski	2623	323	12.3141
69	Baiqiang Dong (董百强)	2019	248	12.2833
70	Ryan DeLine	2121	260	12.2584
71	Antoine Perdereau	947	116	12.2492
72	Chris Hardwick	695	85	12.2302
73	Francisco Pérez Padilla	681	83	12.1880
74	Tomoaki Okayama (岡山友昭)	944	115	12.1822
75	Rodrigo Pueblas Núñez	953	115	12.0672
76	Simone Ciancotti	1004	121	12.0518
77	Andrea Santambrogio	905	109	12.0442
78	François Sechet	535	64	11.9626
79	Kåre Krig	1246	149	11.9583
80	Gustavo Maysonnave Franck	720	86	11.9444
81	Kamil Pomietło	696	83	11.9253
82	Mátyás Kuti	573	68	11.8674
83	Israel Fraga da Silva	574	68	11.8467
84	István Kocza	2900	342	11.7931
85	Gianluca Placenti	649	76	11.7103
86	Bobby D'Angelo	1399	163	11.6512
87	Cendy Cahyo Rahmat	1074	125	11.6387
88	Ernesto Cabrera	652	75	11.5031
89	Gábor Szabó	548	63	11.4964
90	Jason Baum	730	82	11.2329
91	Aldo Feandri	864	97	11.2269
92	Victor Sanchez Redondo	962	108	11.2266
93	Karol Cudzich	521	58	11.1324
94	Anton Goryachikh	797	88	11.0414
95	Letian Mattia Chang	509	56	11.0020
96	Chris Krueger	619	68	10.9855
97	Monika Zimmermann	781	85	10.8835
98	Takuma Shirahase (白波瀬拓磨)	1366	148	10.8346
99	Adam Greenwood	918	99	10.7843
100	Matthew Dickman	849	91	10.7185

SELECT personName, solves, dnfs, dnfs/solves *100 AS percentage
FROM
(
SELECT personName, (Count(value1 > 0 OR NULL) + Count(value2 > 0 OR NULL) + Count(value3 > 0 OR NULL) + Count(value4 > 0 OR NULL) + Count(value5 > 0 OR NULL)) AS solves, Count(value1 = -1 OR NULL) + Count(value2 = -1 OR NULL) + Count(value3 = -1 OR NULL) + Count(value4 = -1 OR NULL) + Count(value5 = -1 OR NULL) AS dnfs
FROM Results
GROUP BY personName
) AS x
WHERE solves > 500
ORDER BY percentage DESC
Limit 100

Lowest percentage DNFs/solves

Spoiler

Rank	Name	Solves	DNFs	Percentage
1	Oswaldo Antonio Pajuelo Puppo	809	1	0.1236
2	James Creswell	525	1	0.1905
3	Yu-Ying Li (李昱穎)	520	1	0.1923
4	Matteo Provasi	2465	7	0.2840
5	Andreas Pung	654	2	0.3058
6	Robert Antal	628	2	0.3185
7	Yan Jin (金岩)	844	3	0.3555
8	Teera Tareesuchevakul (ธีรา ธารีสุชีวกุล)	531	2	0.3766
9	Raphaël Pihet	1027	4	0.3895
10	Wen-Pin Chen (陳文聘)	504	2	0.3968
11	Sonia Reinert	503	2	0.3976
12	Patricia Li	979	4	0.4086
13	Feilong Tang (唐飞龙)	600	3	0.5000
14	Alex Asbery	593	3	0.5059
15	Lucas Henrique Meng	573	3	0.5236
16	Dave Campbell	2156	12	0.5566
17	Max Park	831	5	0.6017
18	Staš Zupanc	951	6	0.6309
19	Armin Soleimani (آرمین سلیمانی)	631	4	0.6339
20	Alexander Lin	931	6	0.6445
21	Yueh-Lin Tsai (蔡岳霖)	1655	11	0.6647
22	Xingyu Chen (陈星宇)	746	5	0.6702
23	David Ludwig	580	4	0.6897
24	Ling Qin (秦岭)	563	4	0.7105
25	Micha Zahnd	1121	8	0.7136
26	Michał Marszałek	554	4	0.7220
27	Niño Francis Reyes	825	6	0.7273
28	Jorge Ströh	805	6	0.7453
29	Simon Stannek	897	7	0.7804
30	Robin Verstraten	1134	9	0.7937
31	Takumi Yoshida (吉田匠)	881	7	0.7946
32	Elmo Tiitola	576	5	0.8681
33	Nanbin Zhang (张楠彬)	575	5	0.8696
34	Zheng Lin (林铮)	871	8	0.9185
35	Mharr Justhinne Ampong	755	7	0.9272
36	Ryo Ito (伊藤崚)	749	7	0.9346
37	Quinten Andelhofs	961	9	0.9365
38	Chung-Han Hsu (許鍾瀚)	1274	12	0.9419
39	Bartosz Ochał	849	8	0.9423
40	Yi-Heng Lee (李宜衡)	1057	10	0.9461
41	Pratik Poojary	624	6	0.9615
42	Clark Cheng	520	5	0.9615
43	Kamil Olesz	623	6	0.9631
44	Jose Abanto Ortiz	617	6	0.9724
45	Filip Chodziutko	502	5	0.9960
46	Szymon Malinowski	1000	10	1.0000
47	Jithin Prakash	600	6	1.0000
48	Ramble Tandar	592	6	1.0135
49	Ramón Dersch	1083	11	1.0157
50	Jai Gambhir	1524	16	1.0499
51	Kacper Stacha	1324	14	1.0574
52	Jiaxi Ye (叶佳希)	849	9	1.0601
53	Howard Wong Jun Yen (黄俊仁)	1121	12	1.0705
54	Shuang Chen (陈霜)	652	7	1.0736
55	Durben Joun Virtucio	557	6	1.0772
56	Daan Baartmans	729	8	1.0974
57	Zhiqing Shi (石志庆)	911	10	1.0977
58	Bartłomiej Lewandowski	727	8	1.1004
59	Ciarán Beahan	1724	19	1.1021
60	Everett Kelly	1349	15	1.1119
61	Ryan Driscoll	531	6	1.1299
62	Sergey Shmakov	611	7	1.1457
63	Luis Gerardo Martínez Hernández	600	7	1.1667
64	Jaume Casado Ruiz	507	6	1.1834
65	Kai Su (苏锴)	756	9	1.1905
66	Pavel Galaktionov	1806	22	1.2182
67	Cezary Rokita	971	12	1.2358
68	Dylan Hughlett	566	7	1.2367
69	Rui-Jun Liu (劉睿鈞)	2087	26	1.2458
70	Karina Grandjean Beck	2085	26	1.2470
71	Yi Wei (危毅)	639	8	1.2520
72	Ivan Lew Yi Wen	559	7	1.2522
73	Georgy Vershinin	1434	18	1.2552
74	Łukasz Burliga	1351	17	1.2583
75	Ben Marlin	633	8	1.2638
76	Vegard Seim Karstang	934	12	1.2848
77	Arlo Sims	854	11	1.2881
78	Dinh-Anh Tran	698	9	1.2894
79	Samantha Raskind	1391	18	1.2940
80	Aaron LoPrete	535	7	1.3084
81	Sittinon Sukhaya (สิทธินนท์ สุขายะ)	610	8	1.3115
82	Simon Crawford	1513	20	1.3219
83	Phillip Lewicki	1508	20	1.3263
84	Phil Yu	1349	18	1.3343
85	Dmitry Dergunov	2247	30	1.3351
86	Myles Casanas	736	10	1.3587
87	Shenchuan Mao (毛神川)	806	11	1.3648
88	Leon Schmidtchen	3569	49	1.3729
89	Florian Harrer	581	8	1.3769
90	Giana Guelfi	508	7	1.3780
91	Daiki Matsumoto (松本大輝)	725	10	1.3793
92	Maggie Jordan	719	10	1.3908
93	Tiffany Chien	502	7	1.3944
94	Shu-Yii Luo (駱書翊)	1549	22	1.4203
95	Clara Lafourcade	836	12	1.4354
96	Tim McMahon	968	14	1.4463
97	Tsung-Che Lee (李宗哲)	686	10	1.4577
98	Ulrik Bredland	958	14	1.4614
99	Marie Hughey	747	11	1.4726
100	Christian Baier	543	8	1.4733

SELECT personName, solves, dnfs, dnfs/solves *100 AS percentage
FROM
(
SELECT personName, (Count(value1 > 0 OR NULL) + Count(value2 > 0 OR NULL) + Count(value3 > 0 OR NULL) + Count(value4 > 0 OR NULL) + Count(value5 > 0 OR NULL)) AS solves, Count(value1 = -1 OR NULL) + Count(value2 = -1 OR NULL) + Count(value3 = -1 OR NULL) + Count(value4 = -1 OR NULL) + Count(value5 = -1 OR NULL) AS dnfs
FROM Results
GROUP BY personName
) AS x
WHERE solves > 500
ORDER BY percentage ASC
Limit 100

 

[mycube]

Sorry for tripple post, I rethought me dnfs/solves stats and think it's better to show dnfs/attempts, so here it is:

Highest DNF-rate:

Spoiler

Rank	Name	Attempts	DNFs	percentage
1	Sebastián Pino Castillo	656	476	72.5610
2	Roman Strakhov	546	124	22.7106
3	Sarah Strong	1990	444	22.3116
4	Taku Yanai (矢内拓)	915	204	22.2951
5	Noah Arthurs	1600	326	20.3750
6	Grzegorz Jałocha	802	155	19.3267
7	Fabrizio Cirnigliaro	1008	185	18.3532
8	Francisco Javier Lemes Sáez	998	180	18.0361
9	Oliver Frost	1172	209	17.8328
10	Alvaro Rodríguez	567	98	17.2840
11	Arvid Skarrie	634	108	17.0347
12	Matteo Colombo	1558	263	16.8806
13	Walter Pereira Rodrigues de Souza	644	108	16.7702
14	Colin Boyd	511	84	16.4384
15	Deni Mintsaev	1016	166	16.3386
16	Bruce Norskog	806	131	16.2531
17	Axel Häck	1026	166	16.1793
18	Artem Savosik	1033	164	15.8761
19	Ryan Reese	607	96	15.8155
20	Jael Riggenbach	789	124	15.7161
21	Michał Tomański	613	94	15.3344
22	Sreeram Venkatarao	669	101	15.0972
23	Shelley Chang	1575	237	15.0476
24	Julien Rochette	587	87	14.8211
25	Guillaume Erbibou	874	127	14.5309
26	Raúl Morales Hidalgo	722	103	14.2659
27	Victor Cullot	721	101	14.0083
28	Marcell Endrey	559	77	13.7746
29	Andrey Ivanov	837	115	13.7395
30	Marcin Kowalczyk	1257	170	13.5243
31	Takayuki Matsumoto (松本孝之)	637	86	13.5008
32	Carlos Angosto Hernández	778	105	13.4961
33	Daniel Kottenstette	565	76	13.4513
34	Gilberto Caracciolo Morelli	1416	190	13.4181
35	Gregor Billing	1077	143	13.2776
36	Lucas Benito Rolando	529	70	13.2325
37	Krzysztof Bober	828	109	13.1643
38	Iulian Steavu	502	66	13.1474
39	Daniel Chudecki	640	84	13.1250
40	Laís Azevedo Martins da Silva	1264	165	13.0538
41	Lauren Klemz	706	92	13.0312
42	Tyson Mao (毛台勝)	660	86	13.0303
43	Markus Pirzer	2057	268	13.0287
44	Qirun Zhong (钟奇润)	647	83	12.8284
45	Adam Zamora	1801	231	12.8262
46	Samuel Djian	531	68	12.8060
47	Shusei Tabuchi (田渕柊星)	651	83	12.7496
48	Janne Lehtimäki	597	76	12.7303
49	Mike Kotch	2200	280	12.7273
50	Han Wu (吳翰)	795	101	12.7044
51	Roberto Antonio Ocmin Baráybar	512	65	12.6953
52	Mimmi Leckius	513	65	12.6706
53	Subash Karnan	501	63	12.5749
54	Didiet Aditya Bayu Kusuma	791	99	12.5158
55	Kou Oobatake (大畠功)	927	116	12.5135
56	Natán Riggenbach	1074	134	12.4767
57	Xin Shi (石欣)	1177	146	12.4044
58	Vivek Prasad Mada	875	108	12.3429
59	Xu Zhao (赵旭)	794	98	12.3426
60	Tomasz Korzeniewski	596	73	12.2483
61	Francisco Garrido Valenzuela	635	77	12.1260
62	Liam Wickett	502	60	11.9522
63	Frank Severinsen	1594	189	11.8570
64	Péter Trombitás	1246	147	11.7978
65	Oleksandr Ivanchak (Олександр Іванчак)	1204	142	11.7940
66	Tomoyuki Hiraide (平出智之)	587	69	11.7547
67	Luchen Zhang (张录辰)	762	89	11.6798
68	Yudanis Taqwin Rohman	524	61	11.6412
69	Clément Valot	524	61	11.6412
70	Maxim Chechnev	1686	196	11.6251
71	Antoine Simon-Chautemps	542	63	11.6236
72	José Felipe Duarte Coronado	723	84	11.6183
73	Adrian Lehmann	1983	228	11.4977
74	Zane Carney	863	99	11.4716
75	M Aashrit Krishna Sankaran	856	98	11.4486
76	Daniel Lundwall	1051	119	11.3225
77	Sanae Omyo (大名佐苗)	999	113	11.3113
78	Olli Vikstedt	771	87	11.2840
79	Hari Anirudh	852	96	11.2676
80	Billy Jeffs	1324	148	11.1782
81	Maximilian Neitzel	1149	128	11.1401
82	Shaden Smith	986	109	11.0548
83	Dmitry Karyakin	570	63	11.0526
84	Michał Bogdan	1263	139	11.0055
85	Marcin Zalewski	2946	323	10.9640
86	Baiqiang Dong (董百强)	2267	248	10.9396
87	Ryan DeLine	2381	260	10.9198
88	Duval Valdes Ayala	504	55	10.9127
89	Antoine Perdereau	1063	116	10.9125
90	Chris Hardwick	780	85	10.8974
91	Francisco Pérez Padilla	764	83	10.8639
92	Tomoaki Okayama (岡山友昭)	1059	115	10.8593
93	Rodrigo Pueblas Núñez	1068	115	10.7678
94	Simone Ciancotti	1125	121	10.7556
95	Andrea Santambrogio	1014	109	10.7495
96	François Sechet	599	64	10.6845
97	Kåre Krig	1395	149	10.6810
98	Gustavo Maysonnave Franck	806	86	10.6700
99	Kamil Pomietło	779	83	10.6547
100	Mátyás Kuti	641	68	10.6084

SELECT personName, attempts, dnfs, dnfs/attempts *100 AS percentage
FROM
(
SELECT personName, (Count(value1 > 0 OR value1 = -1 OR NULL) + Count(value2 > 0 OR value2 = -1 OR NULL) + Count(value3 > 0 OR value3 = -1 OR NULL) + Count(value4 > 0 OR value4 = -1 OR NULL) + Count(value5 > 0 OR value5 = -1 OR NULL)) AS attempts, Count(value1 = -1 OR NULL) + Count(value2 = -1 OR NULL) + Count(value3 = -1 OR NULL) + Count(value4 = -1 OR NULL) + Count(value5 = -1 OR NULL) AS dnfs
FROM Results
GROUP BY personName
) AS x
WHERE attempts > 500
ORDER BY percentage DESC
Limit 100

lowest DNF-rate

Spoiler

Rank	Name	Attempts	DNFs	percentage
1	Oswaldo Antonio Pajuelo Puppo	810	1	0.1235
2	James Creswell	526	1	0.1901
3	Yu-Ying Li (李昱穎)	521	1	0.1919
4	Matteo Provasi	2472	7	0.2832
5	Andreas Pung	656	2	0.3049
6	Robert Antal	630	2	0.3175
7	Yan Jin (金岩)	847	3	0.3542
8	Teera Tareesuchevakul (ธีรา ธารีสุชีวกุล)	533	2	0.3752
9	Raphaël Pihet	1031	4	0.3880
10	Wen-Pin Chen (陳文聘)	506	2	0.3953
11	Sonia Reinert	505	2	0.3960
12	Patricia Li	983	4	0.4069
13	Feilong Tang (唐飞龙)	603	3	0.4975
14	Alex Asbery	596	3	0.5034
15	Lucas Henrique Meng	576	3	0.5208
16	Dave Campbell	2168	12	0.5535
17	Max Park	836	5	0.5981
18	Staš Zupanc	957	6	0.6270
19	Armin Soleimani (آرمین سلیمانی)	635	4	0.6299
20	Alexander Lin	937	6	0.6403
21	Yueh-Lin Tsai (蔡岳霖)	1666	11	0.6603
22	Xingyu Chen (陈星宇)	751	5	0.6658
23	David Ludwig	584	4	0.6849
24	Ling Qin (秦岭)	567	4	0.7055
25	Micha Zahnd	1129	8	0.7086
26	Michał Marszałek	558	4	0.7168
27	Niño Francis Reyes	831	6	0.7220
28	Jorge Ströh	811	6	0.7398
29	Simon Stannek	904	7	0.7743
30	Robin Verstraten	1143	9	0.7874
31	Takumi Yoshida (吉田匠)	888	7	0.7883
32	Guilherme Henrique Paes Landim	501	4	0.7984
33	Elmo Tiitola	581	5	0.8606
34	Nanbin Zhang (张楠彬)	580	5	0.8621
35	Zheng Lin (林铮)	879	8	0.9101
36	Mharr Justhinne Ampong	762	7	0.9186
37	Ryo Ito (伊藤崚)	756	7	0.9259
38	Quinten Andelhofs	970	9	0.9278
39	Chung-Han Hsu (許鍾瀚)	1286	12	0.9331
40	Bartosz Ochał	857	8	0.9335
41	Yi-Heng Lee (李宜衡)	1067	10	0.9372
42	Pratik Poojary	630	6	0.9524
43	Clark Cheng	525	5	0.9524
44	Kamil Olesz	629	6	0.9539
45	Jose Abanto Ortiz	623	6	0.9631
46	Filip Chodziutko	507	5	0.9862
47	Szymon Malinowski	1010	10	0.9901
48	Jithin Prakash	606	6	0.9901
49	Ramble Tandar	598	6	1.0033
50	Ramón Dersch	1094	11	1.0055
51	Jai Gambhir	1540	16	1.0390
52	Kacper Stacha	1338	14	1.0463
53	Jiaxi Ye (叶佳希)	858	9	1.0490
54	Howard Wong Jun Yen (黄俊仁)	1133	12	1.0591
55	Shuang Chen (陈霜)	659	7	1.0622
56	Durben Joun Virtucio	563	6	1.0657
57	Daan Baartmans	737	8	1.0855
58	Zhiqing Shi (石志庆)	921	10	1.0858
59	Bartłomiej Lewandowski	735	8	1.0884
60	Ciarán Beahan	1743	19	1.0901
61	Everett Kelly	1364	15	1.0997
62	Ryan Driscoll	537	6	1.1173
63	Sergey Shmakov	618	7	1.1327
64	Luis Gerardo Martínez Hernández	607	7	1.1532
65	Jaume Casado Ruiz	513	6	1.1696
66	Kai Su (苏锴)	765	9	1.1765
67	Pavel Galaktionov	1828	22	1.2035
68	Cezary Rokita	983	12	1.2208
69	Dylan Hughlett	573	7	1.2216
70	Rui-Jun Liu (劉睿鈞)	2113	26	1.2305
71	Karina Grandjean Beck	2111	26	1.2316
72	Yi Wei (危毅)	647	8	1.2365
73	Ivan Lew Yi Wen	566	7	1.2367
74	Georgy Vershinin	1452	18	1.2397
75	Łukasz Burliga	1368	17	1.2427
76	Ben Marlin	641	8	1.2480
77	Vegard Seim Karstang	946	12	1.2685
78	Arlo Sims	865	11	1.2717
79	Dinh-Anh Tran	707	9	1.2730
80	Samantha Raskind	1409	18	1.2775
81	Aaron LoPrete	542	7	1.2915
82	Sittinon Sukhaya (สิทธินนท์ สุขายะ)	618	8	1.2945
83	Simon Crawford	1533	20	1.3046
84	Phillip Lewicki	1528	20	1.3089
85	Phil Yu	1367	18	1.3168
86	Dmitry Dergunov	2277	30	1.3175
87	Myles Casanas	746	10	1.3405
88	Shenchuan Mao (毛神川)	817	11	1.3464
89	Leon Schmidtchen	3618	49	1.3543
90	Florian Harrer	589	8	1.3582
91	Giana Guelfi	515	7	1.3592
92	Daiki Matsumoto (松本大輝)	735	10	1.3605
93	Maggie Jordan	729	10	1.3717
94	Tiffany Chien	509	7	1.3752
95	Shu-Yii Luo (駱書翊)	1571	22	1.4004
96	Clara Lafourcade	848	12	1.4151
97	Tim McMahon	982	14	1.4257
98	Tsung-Che Lee (李宗哲)	696	10	1.4368
99	Ulrik Bredland	972	14	1.4403
100	Marie Hughey	758	11	1.4512

SELECT personName, attempts, dnfs, dnfs/attempts *100 AS percentage
FROM
(
SELECT personName, (Count(value1 > 0 OR value1 = -1 OR NULL) + Count(value2 > 0 OR value2 = -1 OR NULL) + Count(value3 > 0 OR value3 = -1 OR NULL) + Count(value4 > 0 OR value4 = -1 OR NULL) + Count(value5 > 0 OR value5 = -1 OR NULL)) AS attempts, Count(value1 = -1 OR NULL) + Count(value2 = -1 OR NULL) + Count(value3 = -1 OR NULL) + Count(value4 = -1 OR NULL) + Count(value5 = -1 OR NULL) AS dnfs
FROM Results
GROUP BY personName
) AS x
WHERE attempts > 500
ORDER BY percentage ASC
Limit 100

 

[Robert-Y]

Thanks Linus, really cool stats

I'm gonna look out for my 5000th solve this year

 

[mycube]

Glad you like it, Rob

Another one:

Can someone make a statistic on which attempt most of the 2x2 sub1 singles happened? Right now for me it looks like many of them where on the 4th solve. A distribution would be interesting

solve 1	Solve 2	Solve 3	Solve 4	Solve 5
9	21	11	24	2

SELECT COUNT((value1 < 100 AND value1 > 0) OR NULL) AS a1, COUNT((value2 < 100 AND value2 > 0) OR NULL) AS a2, COUNT((value3 < 100 AND value3 > 0) OR NULL) AS a3, COUNT((value4 < 100 AND value4 > 0) OR NULL) AS a4, COUNT((value5 < 100 AND value5 > 0) OR NULL) AS a5
FROM Results
WHERE eventId = '222'
LIMIT 100

 

[1973486]

Is that from results or persons?

 

[mycube]

Is that from results or persons?

This is from results. I took every sub1 in 2x2 ever done by any competitor (so 67 in total)

 

[Keroma12]

If someone could post an updated nemesis list, that would be much appreciated.

 

[WACWCA]

Glad you like it, Rob

Another one:

solve 1	Solve 2	Solve 3	Solve 4	Solve 5
9	21	11	24	2

SELECT COUNT((value1 < 100 AND value1 > 0) OR NULL) AS a1, COUNT((value2 < 100 AND value2 > 0) OR NULL) AS a2, COUNT((value3 < 100 AND value3 > 0) OR NULL) AS a3, COUNT((value4 < 100 AND value4 > 0) OR NULL) AS a4, COUNT((value5 < 100 AND value5 > 0) OR NULL) AS a5
FROM Results
WHERE eventId = '222'
LIMIT 100

I guess that makes sense because most of the sub 1 solves are the same comp as other ones

 

[CJK]

Fastest first time comp averages and singles across events?

I'm very interested in this, too.

 

[the super cuber]

Ranking of 2/2 MBLDs officially? thanks

 

[Robert-Y]

List of top 100 results for 2/2 MBLD

Spoiler

Rank	Name	Time
1	Chuang Zhou (周闯)	00:01:16
2	Marcin Kowalczyk	00:01:20
3	Shivam Bansal	00:01:23
4	Marcin Kowalczyk	00:01:45
5	Oliver Frost	00:01:56
6	Alexander Yu	00:02:38
7	Marcin Kowalczyk	00:02:58
8	Jakob Kogler	00:03:00
9	Preeda Hongpimolmas (ปรีดา หงส์พิมลมาศ)	00:03:12
10	Marcin Zalewski	00:03:24
11	Jeff Park	00:03:38
12	Zane Carney	00:03:46
13	Joey Gouly	00:03:58
14	Alexander Yu	00:04:05
15	Joey Gouly	00:04:13
16	Israel Fraga da Silva	00:04:13
17	Adrian Lehmann	00:04:23
18	Sébastien Auroux	00:04:28
19	Cornelius Dieckmann	00:04:49
20	Kamil Galicki	00:04:51
21	Cornelius Dieckmann	00:05:06
22	Jan Bentlage	00:05:09
23	Julian David	00:05:22
24	Rowe Hessler	00:05:22
25	Cornelius Dieckmann	00:05:27
26	Eddy Deturche	00:05:37
27	Wojciech Szatanowski	00:05:42
28	Wojciech Szatanowski	00:05:42
29	Wojciech Szatanowski	00:05:42
30	Cornelius Dieckmann	00:05:47
31	Sébastien Auroux	00:05:53
32	Cornelius Dieckmann	00:05:55
33	Milán Baticz	00:05:59
34	Kui-Yo Chen (陳奎佑)	00:06:03
35	Feliks Zemdegs	00:06:07
36	Blai Solernou Lòpez	00:06:13
37	Danyang Chen (陈丹阳)	00:06:16
38	Milán Baticz	00:06:16
39	Sébastien Auroux	00:06:17
40	Shelley Chang	00:06:18
41	Sébastien Auroux	00:06:26
42	Javier Vega Aramburu	00:06:27
43	Kim Jokinen	00:06:29
44	Arthur Garcin	00:06:29
45	Sébastien Auroux	00:06:41
46	Wojciech Szatanowski	00:06:43
47	Mike Hughey	00:06:47
48	Henrik Buus Aagaard	00:06:47
49	Cornelius Dieckmann	00:06:48
50	Baiqiang Dong (董百强)	00:06:51
51	Alban Reynaud	00:06:52
52	Sébastien Auroux	00:07:00
53	Jan Bentlage	00:07:07
54	Juan Juli Andika Chandra	00:07:19
55	Christian Goñi	00:07:19
56	Baiqiang Dong (董百强)	00:07:20
57	Javier Vega Aramburu	00:07:23
58	Erik Akkersdijk	00:07:34
59	Freddy Fernández Córdova	00:07:34
60	Bobby D'Angelo	00:07:35
61	Bertalan Bodor	00:07:37
62	Jonathan Grayum	00:07:39
63	Zak Walters	00:07:48
64	Javier Gamazo Tejero	00:07:52
65	Lee Seung Ha	00:07:54
66	Javier Tirado Ortiz	00:07:57
67	Kai Jiptner	00:07:57
68	Mateusz Fydrych	00:07:57
69	Park Byung-Hwa	00:07:59
70	Kamil Pomietło	00:07:59
71	Tomoaki Okayama (岡山友昭)	00:08:06
72	Nikhil Mande	00:08:08
73	Lucas Santiago Bernhardt Caruncho	00:08:11
74	Marcell Endrey	00:08:17
75	Erik Akkersdijk	00:08:18
76	James Donahue	00:08:20
77	Cendy Cahyo Rahmat	00:08:21
78	Luchen Zhang (张录辰)	00:08:26
79	Yinghao Wang (王鹰豪)	00:08:30
80	Howie Craig	00:08:30
81	Kim Kyung-Ho	00:08:31
82	Anthony Brooks	00:08:32
83	Willian Fidêncio	00:08:34
84	Rizky Aditya Ramadhan	00:08:35
85	Daniel Grabski	00:08:36
86	Clément Gallet	00:08:37
87	Michał Robaczyk	00:08:38
88	Qijun Miao (缪其隽)	00:08:38
89	Dániel Varga	00:08:41
90	Shikai Jiang (江侍锴)	00:08:42
91	Luis Fernando Diaz Rondón	00:08:42
92	SeungWoon Lee (이승운)	00:08:42
93	Natthaphat Mahtani (ณัฐภัทร จี มาทานี)	00:08:45
94	Erik Akkersdijk	00:08:46
95	Lee Seung Ha	00:08:48
96	Soundhariya Hariharan	00:08:49
97	François Courtès	00:08:50
98	Stephen Adhisaputra	00:08:50
99	Ting He (禾廷)	00:08:52
100	Wenshun Zhou (周文舜)	00:08:53

 

[Robert-Y]

Yuxin Wang set the 0 points WR(or whatever it's called) at Asian Championships 2016: 10/20 1:00:00

 

[TheSilverBeluga]

At Hayward Rubik's Rumble (https://www.worldcubeassociation.org/competitions/HaywardRubiksRumble2016), the third place time for 3x3 was 0.03 seconds slower than the first place time.

 

[guysensei1]

Does there exist an official MBLD time that's greater than 1 hour (because of +2s or some other reason)?

Old MBLD not counted of course.

 

[Cale S]

Does there exist an official MBLD time that's greater than 1 hour (because of +2s or some other reason)?

Old MBLD not counted of course.

Brandon Satterstrom did this at a comp I went to: https://www.worldcubeassociation.org/competitions/ClockNOtherStuff2016

and it was 0 points as well, probably worst official MBLD result lol

 

[Wilhelm]

Brandon Satterstrom did this at a comp I went to: https://www.worldcubeassociation.org/competitions/ClockNOtherStuff2016

and it was 0 points as well, probably worst official MBLD result lol

Btw do you guys know if the +2's add up if you get them on multiple cubes?
Also I find it quite funny how you HAVE to solve at least 3 Cubes and get +2's in order to get the worst MBLD result.

 

[the super cuber]

Btw do you guys know if the +2's add up if you get them on multiple cubes?
Also I find it quite funny how you HAVE to solve at least 3 Cubes and get +2's in order to get the worst MBLD result.

yes +2s add up

 

[Robert-Y]

Brandon Satterstrom did this at a comp I went to: https://www.worldcubeassociation.org/competitions/ClockNOtherStuff2016

and it was 0 points as well, probably worst official MBLD result lol

I just checked the database export. I believe that this is the only instance of a (current) MBLD result that exceeds 1 hour.