• 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.

Odd WCA stats/ Stats request Thread

[TABLE="class:grid,align:left"]
[TR][TD]Cuber[/TD][TD]Score[/TD][TD]WRs[/TD][TD]CRs[/TD][TD]NRs[/TD][TD]Country[/TD][/TR]
[TR][TD]Feliks Zemdegs[/TD][TD="align:right"]1240[/TD][TD="align:right"]61[/TD][TD="align:right"]125[/TD][TD="align:right"]5[/TD][TD]Australia[/TD][/TR]
[TR][TD]Emile Compion[/TD][TD="align:right"]651[/TD][TD="align:right"]0[/TD][TD="align:right"]129[/TD][TD="align:right"]6[/TD][TD]South Africa[/TD][/TR]
[TR][TD]Erik Akkersdijk[/TD][TD="align:right"]574[/TD][TD="align:right"]33[/TD][TD="align:right"]22[/TD][TD="align:right"]134[/TD][TD]Netherlands[/TD][/TR]
[TR][TD]Dan Cohen[/TD][TD="align:right"]514[/TD][TD="align:right"]16[/TD][TD="align:right"]70[/TD][TD="align:right"]4[/TD][TD]USA[/TD][/TR]
[TR][TD]Pedro Santos Guimarães[/TD][TD="align:right"]418[/TD][TD="align:right"]0[/TD][TD="align:right"]79[/TD][TD="align:right"]23[/TD][TD]Brazil[/TD][/TR]
[TR][TD]Michał Halczuk[/TD][TD="align:right"]370[/TD][TD="align:right"]19[/TD][TD="align:right"]30[/TD][TD="align:right"]30[/TD][TD]Poland[/TD][/TR]
[TR][TD]Shotaro Makisumi (牧角章太郎)[/TD][TD="align:right"]292[/TD][TD="align:right"]21[/TD][TD="align:right"]16[/TD][TD="align:right"]2[/TD][TD]Japan[/TD][/TR]
[TR][TD]Stefan Pochmann[/TD][TD="align:right"]285[/TD][TD="align:right"]21[/TD][TD="align:right"]3[/TD][TD="align:right"]60[/TD][TD]Germany[/TD][/TR]
[TR][TD]Gabriel Dechichi Barbar[/TD][TD="align:right"]276[/TD][TD="align:right"]0[/TD][TD="align:right"]54[/TD][TD="align:right"]6[/TD][TD]Brazil[/TD][/TR]
[TR][TD]Lars Vandenbergh[/TD][TD="align:right"]272[/TD][TD="align:right"]13[/TD][TD="align:right"]10[/TD][TD="align:right"]92[/TD][TD]Belgium[/TD][/TR]
[TR][TD]Henrik Buus Aagaard[/TD][TD="align:right"]250[/TD][TD="align:right"]1[/TD][TD="align:right"]4[/TD][TD="align:right"]220[/TD][TD]Denmark[/TD][/TR]
[TR][TD]Dene Beardsley[/TD][TD="align:right"]236[/TD][TD="align:right"]0[/TD][TD="align:right"]34[/TD][TD="align:right"]66[/TD][TD]New Zealand[/TD][/TR]
[TR][TD]Gunnar Krig[/TD][TD="align:right"]234[/TD][TD="align:right"]10[/TD][TD="align:right"]6[/TD][TD="align:right"]104[/TD][TD]Sweden[/TD][/TR]
[TR][TD]Chris Hardwick[/TD][TD="align:right"]230[/TD][TD="align:right"]16[/TD][TD="align:right"]14[/TD][TD="align:right"]0[/TD][TD]USA[/TD][/TR]
[TR][TD]Bence Barát[/TD][TD="align:right"]221[/TD][TD="align:right"]7[/TD][TD="align:right"]9[/TD][TD="align:right"]106[/TD][TD]Hungary[/TD][/TR]
[TR][TD]Yu Nakajima (中島悠)[/TD][TD="align:right"]216[/TD][TD="align:right"]8[/TD][TD="align:right"]22[/TD][TD="align:right"]26[/TD][TD]Japan[/TD][/TR]
[TR][TD]Mátyás Kuti[/TD][TD="align:right"]215[/TD][TD="align:right"]17[/TD][TD="align:right"]2[/TD][TD="align:right"]35[/TD][TD]Hungary[/TD][/TR]
[TR][TD]Gabriel Eduardo Núñez Serna[/TD][TD="align:right"]208[/TD][TD="align:right"]0[/TD][TD="align:right"]33[/TD][TD="align:right"]43[/TD][TD]Argentina[/TD][/TR]
[TR][TD]Anssi Vanhala[/TD][TD="align:right"]207[/TD][TD="align:right"]12[/TD][TD="align:right"]4[/TD][TD="align:right"]67[/TD][TD]Finland[/TD][/TR]
[TR][TD]Milán Baticz[/TD][TD="align:right"]188[/TD][TD="align:right"]4[/TD][TD="align:right"]3[/TD][TD="align:right"]133[/TD][TD]Hungary[/TD][/TR]
[TR][TD]Rowe Hessler[/TD][TD="align:right"]177[/TD][TD="align:right"]3[/TD][TD="align:right"]29[/TD][TD="align:right"]2[/TD][TD]USA[/TD][/TR]
[TR][TD]Kevin Hays[/TD][TD="align:right"]174[/TD][TD="align:right"]10[/TD][TD="align:right"]14[/TD][TD="align:right"]4[/TD][TD]USA[/TD][/TR]
[TR][TD]Yumu Tabuchi (田渕雄夢)[/TD][TD="align:right"]166[/TD][TD="align:right"]6[/TD][TD="align:right"]19[/TD][TD="align:right"]11[/TD][TD]Japan[/TD][/TR]
[TR][TD]Jasmine Lee[/TD][TD="align:right"]165[/TD][TD="align:right"]0[/TD][TD="align:right"]33[/TD][TD="align:right"]0[/TD][TD]Australia[/TD][/TR]
[TR][TD]Marcell Endrey[/TD][TD="align:right"]163[/TD][TD="align:right"]13[/TD][TD="align:right"]4[/TD][TD="align:right"]13[/TD][TD]Hungary[/TD][/TR]
[TR][TD]Simon Westlund[/TD][TD="align:right"]160[/TD][TD="align:right"]4[/TD][TD="align:right"]0[/TD][TD="align:right"]120[/TD][TD]Sweden[/TD][/TR]
[TR][TD]Lin Chen (陈霖)[/TD][TD="align:right"]157[/TD][TD="align:right"]12[/TD][TD="align:right"]6[/TD][TD="align:right"]7[/TD][TD]China[/TD][/TR]
[TR][TD]Conor Cronin[/TD][TD="align:right"]151[/TD][TD="align:right"]0[/TD][TD="align:right"]29[/TD][TD="align:right"]6[/TD][TD]South Africa[/TD][/TR]
[TR][TD]Ryan Patricio[/TD][TD="align:right"]150[/TD][TD="align:right"]10[/TD][TD="align:right"]10[/TD][TD="align:right"]0[/TD][TD]USA[/TD][/TR]
[TR][TD]Joshua Li[/TD][TD="align:right"]150[/TD][TD="align:right"]0[/TD][TD="align:right"]30[/TD][TD="align:right"]0[/TD][TD]Australia[/TD][/TR]
[TR][TD]Yuxuan Wang (王宇轩)[/TD][TD="align:right"]148[/TD][TD="align:right"]12[/TD][TD="align:right"]4[/TD][TD="align:right"]8[/TD][TD]China[/TD][/TR]
[TR][TD]Oscar Roth Andersen[/TD][TD="align:right"]141[/TD][TD="align:right"]7[/TD][TD="align:right"]4[/TD][TD="align:right"]51[/TD][TD]Denmark[/TD][/TR]
[TR][TD]Pablo Nicolás Oshiro Mondoñedo[/TD][TD="align:right"]140[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]140[/TD][TD]Peru[/TD][/TR]
[TR][TD]Ville Seppänen[/TD][TD="align:right"]135[/TD][TD="align:right"]7[/TD][TD="align:right"]4[/TD][TD="align:right"]45[/TD][TD]Finland[/TD][/TR]
[TR][TD]Frank Morris[/TD][TD="align:right"]135[/TD][TD="align:right"]6[/TD][TD="align:right"]15[/TD][TD="align:right"]0[/TD][TD]USA[/TD][/TR]
[TR][TD]Mats Valk[/TD][TD="align:right"]135[/TD][TD="align:right"]4[/TD][TD="align:right"]9[/TD][TD="align:right"]50[/TD][TD]Netherlands[/TD][/TR]
[TR][TD]Yohei Oka (岡要平)[/TD][TD="align:right"]133[/TD][TD="align:right"]9[/TD][TD="align:right"]8[/TD][TD="align:right"]3[/TD][TD]Japan[/TD][/TR]
[TR][TD]Giovanni Contardi[/TD][TD="align:right"]132[/TD][TD="align:right"]3[/TD][TD="align:right"]9[/TD][TD="align:right"]57[/TD][TD]Italy[/TD][/TR]
[TR][TD]Leyan Lo[/TD][TD="align:right"]130[/TD][TD="align:right"]8[/TD][TD="align:right"]10[/TD][TD="align:right"]0[/TD][TD]USA[/TD][/TR]
[TR][TD]Rafael Werneck Cinoto[/TD][TD="align:right"]126[/TD][TD="align:right"]0[/TD][TD="align:right"]25[/TD][TD="align:right"]1[/TD][TD]Brazil[/TD][/TR]
[TR][TD]Takayuki Ookusa (大艸尊之)[/TD][TD="align:right"]123[/TD][TD="align:right"]6[/TD][TD="align:right"]12[/TD][TD="align:right"]3[/TD][TD]Japan[/TD][/TR]
[TR][TD]Bernett Orlando[/TD][TD="align:right"]122[/TD][TD="align:right"]0[/TD][TD="align:right"]10[/TD][TD="align:right"]72[/TD][TD]India[/TD][/TR]
[TR][TD]Sebastian Weyer[/TD][TD="align:right"]121[/TD][TD="align:right"]8[/TD][TD="align:right"]4[/TD][TD="align:right"]21[/TD][TD]Germany[/TD][/TR]
[TR][TD]Nurym Kudaibergen[/TD][TD="align:right"]121[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]121[/TD][TD]Kazakhstan[/TD][/TR]
[TR][TD]Louis Cormier[/TD][TD="align:right"]119[/TD][TD="align:right"]2[/TD][TD="align:right"]16[/TD][TD="align:right"]19[/TD][TD]Canada[/TD][/TR]
[TR][TD]Ivan Vynnyk (Іван Винник)[/TD][TD="align:right"]114[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]114[/TD][TD]Ukraine[/TD][/TR]
[TR][TD]Edouard Chambon[/TD][TD="align:right"]113[/TD][TD="align:right"]6[/TD][TD="align:right"]6[/TD][TD="align:right"]23[/TD][TD]France[/TD][/TR]
[TR][TD]Hilmar Magnusson[/TD][TD="align:right"]113[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]113[/TD][TD]Iceland[/TD][/TR]
[TR][TD]Ron van Bruchem[/TD][TD="align:right"]112[/TD][TD="align:right"]3[/TD][TD="align:right"]5[/TD][TD="align:right"]57[/TD][TD]Netherlands[/TD][/TR]
[TR][TD]Bob Burton[/TD][TD="align:right"]111[/TD][TD="align:right"]5[/TD][TD="align:right"]12[/TD][TD="align:right"]1[/TD][TD]USA[/TD][/TR]
[TR][TD]Bingliang Li (李炳良)[/TD][TD="align:right"]109[/TD][TD="align:right"]8[/TD][TD="align:right"]5[/TD][TD="align:right"]4[/TD][TD]China[/TD][/TR]
[TR][TD]Matias Macaya[/TD][TD="align:right"]109[/TD][TD="align:right"]0[/TD][TD="align:right"]16[/TD][TD="align:right"]29[/TD][TD]Chile[/TD][/TR]
[TR][TD]Antonie Paterakis[/TD][TD="align:right"]107[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]107[/TD][TD]Greece[/TD][/TR]
[TR][TD]Kamaru-Deen Lawal[/TD][TD="align:right"]106[/TD][TD="align:right"]0[/TD][TD="align:right"]19[/TD][TD="align:right"]11[/TD][TD]USA[/TD][/TR]
[TR][TD]Breandan Vallance[/TD][TD="align:right"]106[/TD][TD="align:right"]0[/TD][TD="align:right"]4[/TD][TD="align:right"]86[/TD][TD]United Kingdom[/TD][/TR]
[TR][TD]Ciarán Beahan[/TD][TD="align:right"]104[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]104[/TD][TD]Ireland[/TD][/TR]
[TR][TD]Matic Omulec[/TD][TD="align:right"]104[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]104[/TD][TD]Slovenia[/TD][/TR]
[TR][TD]Michał Pleskowicz[/TD][TD="align:right"]96[/TD][TD="align:right"]4[/TD][TD="align:right"]9[/TD][TD="align:right"]11[/TD][TD]Poland[/TD][/TR]
[TR][TD]Kanneti Sae Han (คันธ์เนตี แซ่ห่าน)[/TD][TD="align:right"]96[/TD][TD="align:right"]1[/TD][TD="align:right"]2[/TD][TD="align:right"]76[/TD][TD]Thailand[/TD][/TR]
[TR][TD]Daniel Sheppard[/TD][TD="align:right"]94[/TD][TD="align:right"]3[/TD][TD="align:right"]2[/TD][TD="align:right"]54[/TD][TD]United Kingdom[/TD][/TR]
[TR][TD]Leandro Baltazar[/TD][TD="align:right"]94[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]94[/TD][TD]Portugal[/TD][/TR]
[TR][TD]Marcin Kowalczyk[/TD][TD="align:right"]92[/TD][TD="align:right"]9[/TD][TD="align:right"]0[/TD][TD="align:right"]2[/TD][TD]Poland[/TD][/TR]
[TR][TD]Chester Lian[/TD][TD="align:right"]90[/TD][TD="align:right"]2[/TD][TD="align:right"]4[/TD][TD="align:right"]50[/TD][TD]Malaysia[/TD][/TR]
[TR][TD]Anthony Searle[/TD][TD="align:right"]89[/TD][TD="align:right"]0[/TD][TD="align:right"]3[/TD][TD="align:right"]74[/TD][TD]Belize[/TD][/TR]
[TR][TD]Michael Röhrer[/TD][TD="align:right"]88[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]88[/TD][TD]Austria[/TD][/TR]
[TR][TD]Jaap Scherphuis[/TD][TD="align:right"]87[/TD][TD="align:right"]8[/TD][TD="align:right"]1[/TD][TD="align:right"]2[/TD][TD]Netherlands[/TD][/TR]
[TR][TD]Piotr Michał Padlewski[/TD][TD="align:right"]86[/TD][TD="align:right"]4[/TD][TD="align:right"]8[/TD][TD="align:right"]6[/TD][TD]Poland[/TD][/TR]
[TR][TD]Morten Arborg[/TD][TD="align:right"]86[/TD][TD="align:right"]0[/TD][TD="align:right"]1[/TD][TD="align:right"]81[/TD][TD]Norway[/TD][/TR]
[TR][TD]Boriss Benzerruki[/TD][TD="align:right"]84[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]84[/TD][TD]Latvia[/TD][/TR]
[TR][TD]Piti Pichedpan (ปิติ พิเชษฐพันธ์)[/TD][TD="align:right"]82[/TD][TD="align:right"]2[/TD][TD="align:right"]4[/TD][TD="align:right"]42[/TD][TD]Thailand[/TD][/TR]
[TR][TD]Warren Liao[/TD][TD="align:right"]82[/TD][TD="align:right"]0[/TD][TD="align:right"]9[/TD][TD="align:right"]37[/TD][TD]Taiwan[/TD][/TR]
[TR][TD]Clément Gallet[/TD][TD="align:right"]81[/TD][TD="align:right"]3[/TD][TD="align:right"]1[/TD][TD="align:right"]46[/TD][TD]France[/TD][/TR]
[TR][TD]Erwan Kohler[/TD][TD="align:right"]81[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]81[/TD][TD]Switzerland[/TD][/TR]
[TR][TD]Martin Zahradník[/TD][TD="align:right"]81[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]81[/TD][TD]Czech Republic[/TD][/TR]
[TR][TD]Francisco Javier Lemes Sáez[/TD][TD="align:right"]80[/TD][TD="align:right"]0[/TD][TD="align:right"]12[/TD][TD="align:right"]20[/TD][TD]Chile[/TD][/TR]
[TR][TD]Harris Chan[/TD][TD="align:right"]79[/TD][TD="align:right"]0[/TD][TD="align:right"]10[/TD][TD="align:right"]29[/TD][TD]Canada[/TD][/TR]
[TR][TD]Lucas Garron[/TD][TD="align:right"]78[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]78[/TD][TD]Germany[/TD][/TR]
[TR][TD]Haiyan Zhuang (庄海燕)[/TD][TD="align:right"]77[/TD][TD="align:right"]7[/TD][TD="align:right"]1[/TD][TD="align:right"]2[/TD][TD]China[/TD][/TR]
[TR][TD]Frédérick Badie[/TD][TD="align:right"]77[/TD][TD="align:right"]4[/TD][TD="align:right"]5[/TD][TD="align:right"]12[/TD][TD]France[/TD][/TR]
[TR][TD]Gilles van den Peereboom[/TD][TD="align:right"]77[/TD][TD="align:right"]1[/TD][TD="align:right"]6[/TD][TD="align:right"]37[/TD][TD]Belgium[/TD][/TR]
[TR][TD]Craig Bouchard[/TD][TD="align:right"]76[/TD][TD="align:right"]4[/TD][TD="align:right"]2[/TD][TD="align:right"]26[/TD][TD]Canada[/TD][/TR]
[TR][TD]Asia Konvittayayotin (เอเชีย กรวิทยโยธิน)[/TD][TD="align:right"]75[/TD][TD="align:right"]0[/TD][TD="align:right"]6[/TD][TD="align:right"]45[/TD][TD]Thailand[/TD][/TR]
[TR][TD]Stefan Huber[/TD][TD="align:right"]75[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]75[/TD][TD]Austria[/TD][/TR]
[TR][TD]Hsuan Chang (張璿)[/TD][TD="align:right"]74[/TD][TD="align:right"]4[/TD][TD="align:right"]6[/TD][TD="align:right"]4[/TD][TD]Taiwan[/TD][/TR]
[TR][TD]José Leonardo Chaparro Prieto[/TD][TD="align:right"]74[/TD][TD="align:right"]0[/TD][TD="align:right"]5[/TD][TD="align:right"]49[/TD][TD]Colombia[/TD][/TR]
[TR][TD]Teo Kai Xiang[/TD][TD="align:right"]74[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]74[/TD][TD]Singapore[/TD][/TR]
[TR][TD]Conor Baumann[/TD][TD="align:right"]74[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]74[/TD][TD]Ireland[/TD][/TR]
[TR][TD]Anatoly Kim[/TD][TD="align:right"]74[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]74[/TD][TD]Belarus[/TD][/TR]
[TR][TD]Uku Kruusamägi[/TD][TD="align:right"]73[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]73[/TD][TD]Estonia[/TD][/TR]
[TR][TD]Rafał Guzewicz[/TD][TD="align:right"]72[/TD][TD="align:right"]3[/TD][TD="align:right"]7[/TD][TD="align:right"]7[/TD][TD]Poland[/TD][/TR]
[TR][TD]Robert Yau[/TD][TD="align:right"]72[/TD][TD="align:right"]0[/TD][TD="align:right"]1[/TD][TD="align:right"]67[/TD][TD]United Kingdom[/TD][/TR]
[TR][TD]Dan Harris[/TD][TD="align:right"]72[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]72[/TD][TD]United Kingdom[/TD][/TR]
[TR][TD]Tomasz Żołnowski[/TD][TD="align:right"]71[/TD][TD="align:right"]2[/TD][TD="align:right"]4[/TD][TD="align:right"]31[/TD][TD]Poland[/TD][/TR]
[TR][TD]Masayuki Akimoto (秋元正行)[/TD][TD="align:right"]70[/TD][TD="align:right"]2[/TD][TD="align:right"]10[/TD][TD="align:right"]0[/TD][TD]Japan[/TD][/TR]
[TR][TD]Oscar Alberto Ceballos Contreras[/TD][TD="align:right"]70[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]70[/TD][TD]Venezuela[/TD][/TR]
[TR][TD]Aramayis Adloyan (Արամայիս Ադլոյան)[/TD][TD="align:right"]70[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]70[/TD][TD]Armenia[/TD][/TR]
[TR][TD]Bálint Bodor[/TD][TD="align:right"]69[/TD][TD="align:right"]6[/TD][TD="align:right"]0[/TD][TD="align:right"]9[/TD][TD]Hungary[/TD][/TR]
[TR][TD]Sébastien Auroux[/TD][TD="align:right"]68[/TD][TD="align:right"]5[/TD][TD="align:right"]1[/TD][TD="align:right"]13[/TD][TD]Germany[/TD][/TR]
[TR][TD]Takao Hashimoto (橋本貴夫)[/TD][TD="align:right"]68[/TD][TD="align:right"]0[/TD][TD="align:right"]7[/TD][TD="align:right"]33[/TD][TD]Japan[/TD][/TR]
[TR][TD]Jure Gregorc[/TD][TD="align:right"]68[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]68[/TD][TD]Slovenia[/TD][/TR]
[/TABLE]
SELECT personName Cuber, 10*WRs+5*CRs+NRs Score, WRs, CRs, NRs, countryId Country
FROM
(SELECT
personName,
countryId,
sum((regionalSingleRecord='WR')+(regionalAverageRecord='WR')) WRs,
sum((regionalSingleRecord like '%R' and regionalSingleRecord not in ('WR','NR'))
+(regionalAverageRecord like '%R' and regionalAverageRecord not in ('WR', 'NR'))) CRs,
sum((regionalSingleRecord='NR')+(regionalAverageRecord='NR')) NRs
FROM Results
GROUP BY personId) tmp
HAVING Score >= 68
ORDER BY Score desc, WRs desc, CRs desc, NRs desc;
[TABLE="class:grid,align:left"]
[TR][TD]Cuber[/TD][TD]Score[/TD][TD]WRs[/TD][TD]CRs[/TD][TD]NRs[/TD][TD]Country[/TD][/TR]
[TR][TD]Feliks Zemdegs[/TD][TD="align:right"]126[/TD][TD="align:right"]5[/TD][TD="align:right"]15[/TD][TD="align:right"]1[/TD][TD]Australia[/TD][/TR]
[TR][TD]Conor Cronin[/TD][TD="align:right"]79[/TD][TD="align:right"]0[/TD][TD="align:right"]15[/TD][TD="align:right"]4[/TD][TD]South Africa[/TD][/TR]
[TR][TD]Kevin Hays[/TD][TD="align:right"]41[/TD][TD="align:right"]2[/TD][TD="align:right"]4[/TD][TD="align:right"]1[/TD][TD]USA[/TD][/TR]
[TR][TD]Emile Compion[/TD][TD="align:right"]40[/TD][TD="align:right"]0[/TD][TD="align:right"]8[/TD][TD="align:right"]0[/TD][TD]South Africa[/TD][/TR]
[TR][TD]Pedro Henrique Da Silva Roque[/TD][TD="align:right"]35[/TD][TD="align:right"]0[/TD][TD="align:right"]7[/TD][TD="align:right"]0[/TD][TD]Brazil[/TD][/TR]
[TR][TD]Kamaru-Deen Lawal[/TD][TD="align:right"]33[/TD][TD="align:right"]0[/TD][TD="align:right"]6[/TD][TD="align:right"]3[/TD][TD]Nigeria[/TD][/TR]
[TR][TD]Louis Cormier[/TD][TD="align:right"]30[/TD][TD="align:right"]2[/TD][TD="align:right"]1[/TD][TD="align:right"]5[/TD][TD]Canada[/TD][/TR]
[TR][TD]Gabriel Dechichi Barbar[/TD][TD="align:right"]28[/TD][TD="align:right"]0[/TD][TD="align:right"]5[/TD][TD="align:right"]3[/TD][TD]Brazil[/TD][/TR]
[TR][TD]Oscar Roth Andersen[/TD][TD="align:right"]26[/TD][TD="align:right"]2[/TD][TD="align:right"]0[/TD][TD="align:right"]6[/TD][TD]Denmark[/TD][/TR]
[TR][TD]Mats Valk[/TD][TD="align:right"]25[/TD][TD="align:right"]1[/TD][TD="align:right"]0[/TD][TD="align:right"]15[/TD][TD]Netherlands[/TD][/TR]
[TR][TD]Sebastian Weyer[/TD][TD="align:right"]25[/TD][TD="align:right"]2[/TD][TD="align:right"]0[/TD][TD="align:right"]5[/TD][TD]Germany[/TD][/TR]
[TR][TD]Ciarán Beahan[/TD][TD="align:right"]24[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]24[/TD][TD]Ireland[/TD][/TR]
[TR][TD]Hilmar Magnusson[/TD][TD="align:right"]23[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]23[/TD][TD]Iceland[/TD][/TR]
[TR][TD]Oliver Frost[/TD][TD="align:right"]23[/TD][TD="align:right"]2[/TD][TD="align:right"]0[/TD][TD="align:right"]3[/TD][TD]United Kingdom[/TD][/TR]
[TR][TD]Lin Chen (陈霖)[/TD][TD="align:right"]22[/TD][TD="align:right"]1[/TD][TD="align:right"]2[/TD][TD="align:right"]2[/TD][TD]China[/TD][/TR]
[TR][TD]Antonie Paterakis[/TD][TD="align:right"]21[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]21[/TD][TD]Greece[/TD][/TR]
[TR][TD]Antoine Cantin[/TD][TD="align:right"]20[/TD][TD="align:right"]1[/TD][TD="align:right"]1[/TD][TD="align:right"]5[/TD][TD]Canada[/TD][/TR]
[TR][TD]Zane Carney[/TD][TD="align:right"]20[/TD][TD="align:right"]0[/TD][TD="align:right"]4[/TD][TD="align:right"]0[/TD][TD]Australia[/TD][/TR]
[TR][TD]Jayden McNeill[/TD][TD="align:right"]20[/TD][TD="align:right"]0[/TD][TD="align:right"]4[/TD][TD="align:right"]0[/TD][TD]Australia[/TD][/TR]
[TR][TD]Vincent Sheu[/TD][TD="align:right"]20[/TD][TD="align:right"]1[/TD][TD="align:right"]2[/TD][TD="align:right"]0[/TD][TD]USA[/TD][/TR]
[TR][TD]Gabriel Pereira Campanha[/TD][TD="align:right"]20[/TD][TD="align:right"]2[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD]Brazil[/TD][/TR]
[TR][TD]Yu Nakajima (中島悠)[/TD][TD="align:right"]20[/TD][TD="align:right"]0[/TD][TD="align:right"]2[/TD][TD="align:right"]10[/TD][TD]Japan[/TD][/TR]
[TR][TD]Bingliang Li (李炳良)[/TD][TD="align:right"]20[/TD][TD="align:right"]2[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD]China[/TD][/TR]
[TR][TD]Ainesh Sevellaraja[/TD][TD="align:right"]19[/TD][TD="align:right"]0[/TD][TD="align:right"]2[/TD][TD="align:right"]9[/TD][TD]Malaysia[/TD][/TR]
[TR][TD]Matic Omulec[/TD][TD="align:right"]19[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]19[/TD][TD]Slovenia[/TD][/TR]
[TR][TD]Leandro Baltazar[/TD][TD="align:right"]19[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]19[/TD][TD]Portugal[/TD][/TR]
[TR][TD]Nurym Kudaibergen[/TD][TD="align:right"]19[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]19[/TD][TD]Kazakhstan[/TD][/TR]
[TR][TD]Bence Barát[/TD][TD="align:right"]18[/TD][TD="align:right"]0[/TD][TD="align:right"]2[/TD][TD="align:right"]8[/TD][TD]Hungary[/TD][/TR]
[TR][TD]Simon Westlund[/TD][TD="align:right"]18[/TD][TD="align:right"]0[/TD][TD="align:right"]1[/TD][TD="align:right"]13[/TD][TD]Sweden[/TD][/TR]
[TR][TD]Vincent Hartanto Utomo[/TD][TD="align:right"]17[/TD][TD="align:right"]0[/TD][TD="align:right"]2[/TD][TD="align:right"]7[/TD][TD]Indonesia[/TD][/TR]
[TR][TD]Rami Sbahi[/TD][TD="align:right"]17[/TD][TD="align:right"]1[/TD][TD="align:right"]1[/TD][TD="align:right"]2[/TD][TD]USA[/TD][/TR]
[TR][TD]Teo Kai Xiang[/TD][TD="align:right"]16[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]16[/TD][TD]Singapore[/TD][/TR]
[TR][TD]Kaijun Lin (林恺俊)[/TD][TD="align:right"]16[/TD][TD="align:right"]1[/TD][TD="align:right"]1[/TD][TD="align:right"]1[/TD][TD]China[/TD][/TR]
[TR][TD]Daniel Cano Salgado[/TD][TD="align:right"]16[/TD][TD="align:right"]0[/TD][TD="align:right"]2[/TD][TD="align:right"]6[/TD][TD]Colombia[/TD][/TR]
[TR][TD]Przemysław Kaleta[/TD][TD="align:right"]16[/TD][TD="align:right"]1[/TD][TD="align:right"]1[/TD][TD="align:right"]1[/TD][TD]Poland[/TD][/TR]
[TR][TD]Lucas Etter[/TD][TD="align:right"]15[/TD][TD="align:right"]1[/TD][TD="align:right"]1[/TD][TD="align:right"]0[/TD][TD]USA[/TD][/TR]
[TR][TD]Bill Wang[/TD][TD="align:right"]15[/TD][TD="align:right"]0[/TD][TD="align:right"]2[/TD][TD="align:right"]5[/TD][TD]Canada[/TD][/TR]
[TR][TD]Evan Liu[/TD][TD="align:right"]15[/TD][TD="align:right"]1[/TD][TD="align:right"]1[/TD][TD="align:right"]0[/TD][TD]USA[/TD][/TR]
[TR][TD]Jonatan Kłosko[/TD][TD="align:right"]15[/TD][TD="align:right"]1[/TD][TD="align:right"]1[/TD][TD="align:right"]0[/TD][TD]Poland[/TD][/TR]
[TR][TD]Jakob Kogler[/TD][TD="align:right"]15[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]15[/TD][TD]Austria[/TD][/TR]
[TR][TD]Drew Brads[/TD][TD="align:right"]15[/TD][TD="align:right"]0[/TD][TD="align:right"]3[/TD][TD="align:right"]0[/TD][TD]USA[/TD][/TR]
[TR][TD]Marcin Kowalczyk[/TD][TD="align:right"]15[/TD][TD="align:right"]1[/TD][TD="align:right"]1[/TD][TD="align:right"]0[/TD][TD]Poland[/TD][/TR]
[TR][TD]Tomoaki Okayama (岡山友昭)[/TD][TD="align:right"]15[/TD][TD="align:right"]1[/TD][TD="align:right"]1[/TD][TD="align:right"]0[/TD][TD]Japan[/TD][/TR]
[TR][TD]Dene Beardsley[/TD][TD="align:right"]15[/TD][TD="align:right"]0[/TD][TD="align:right"]1[/TD][TD="align:right"]10[/TD][TD]New Zealand[/TD][/TR]
[TR][TD]Renato Stopic[/TD][TD="align:right"]15[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]15[/TD][TD]Bosnia and Herzegovina[/TD][/TR]
[TR][TD]Derrick André Dabian Celedón[/TD][TD="align:right"]15[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]15[/TD][TD]Aruba[/TD][/TR]
[TR][TD]Sébastien Auroux[/TD][TD="align:right"]15[/TD][TD="align:right"]1[/TD][TD="align:right"]1[/TD][TD="align:right"]0[/TD][TD]Germany[/TD][/TR]
[TR][TD]Chio Wai Cheng (趙偉程)[/TD][TD="align:right"]15[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]15[/TD][TD]Macau[/TD][/TR]
[TR][TD]Joel Spang[/TD][TD="align:right"]14[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]14[/TD][TD]Luxembourg[/TD][/TR]
[TR][TD]Michał Halczuk[/TD][TD="align:right"]14[/TD][TD="align:right"]0[/TD][TD="align:right"]2[/TD][TD="align:right"]4[/TD][TD]Poland[/TD][/TR]
[TR][TD]Oscar Alberto Ceballos Contreras[/TD][TD="align:right"]14[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]14[/TD][TD]Venezuela[/TD][/TR]
[TR][TD]Aramayis Adloyan (Արամայիս Ադլոյան)[/TD][TD="align:right"]13[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]13[/TD][TD]Armenia[/TD][/TR]
[TR][TD]Christian Saenz Valdivia[/TD][TD="align:right"]13[/TD][TD="align:right"]0[/TD][TD="align:right"]1[/TD][TD="align:right"]8[/TD][TD]Peru[/TD][/TR]
[TR][TD]Francisco Javier Lemes Sáez[/TD][TD="align:right"]13[/TD][TD="align:right"]0[/TD][TD="align:right"]2[/TD][TD="align:right"]3[/TD][TD]Chile[/TD][/TR]
[TR][TD]Zeid Doofesh (زيد دوفش)[/TD][TD="align:right"]13[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]13[/TD][TD]Jordan[/TD][/TR]
[TR][TD]Ivan Vynnyk (Іван Винник)[/TD][TD="align:right"]12[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]12[/TD][TD]Ukraine[/TD][/TR]
[TR][TD]Morten Arborg[/TD][TD="align:right"]12[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]12[/TD][TD]Norway[/TD][/TR]
[TR][TD]Vladislavs Baranovs[/TD][TD="align:right"]12[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]12[/TD][TD]Latvia[/TD][/TR]
[TR][TD]Can Gücüyener[/TD][TD="align:right"]12[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]12[/TD][TD]Turkey[/TD][/TR]
[TR][TD]Yuhei Takagi (高木佑平)[/TD][TD="align:right"]12[/TD][TD="align:right"]0[/TD][TD="align:right"]2[/TD][TD="align:right"]2[/TD][TD]Japan[/TD][/TR]
[TR][TD]Jacobus Philip Haupt[/TD][TD="align:right"]12[/TD][TD="align:right"]0[/TD][TD="align:right"]2[/TD][TD="align:right"]2[/TD][TD]South Africa[/TD][/TR]
[TR][TD]Uku Kruusamägi[/TD][TD="align:right"]11[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]11[/TD][TD]Estonia[/TD][/TR]
[TR][TD]Pavel Yushkevich[/TD][TD="align:right"]11[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]11[/TD][TD]Belarus[/TD][/TR]
[TR][TD]Dominik Vidaković[/TD][TD="align:right"]11[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]11[/TD][TD]Croatia[/TD][/TR]
[TR][TD]Facundo Finola[/TD][TD="align:right"]11[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]11[/TD][TD]Argentina[/TD][/TR]
[TR][TD]Noah Arthurs[/TD][TD="align:right"]11[/TD][TD="align:right"]0[/TD][TD="align:right"]2[/TD][TD="align:right"]1[/TD][TD]USA[/TD][/TR]
[TR][TD]Sam Zhixiao Wang (王志骁)[/TD][TD="align:right"]11[/TD][TD="align:right"]1[/TD][TD="align:right"]0[/TD][TD="align:right"]1[/TD][TD]China[/TD][/TR]
[TR][TD]Flavian Glonț[/TD][TD="align:right"]10[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]10[/TD][TD]Romania[/TD][/TR]
[TR][TD]Dino Sabotic[/TD][TD="align:right"]10[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]10[/TD][TD]Montenegro[/TD][/TR]
[TR][TD]Jakub Kipa[/TD][TD="align:right"]10[/TD][TD="align:right"]0[/TD][TD="align:right"]2[/TD][TD="align:right"]0[/TD][TD]Poland[/TD][/TR]
[TR][TD]Felipe Rueda Hernández[/TD][TD="align:right"]10[/TD][TD="align:right"]0[/TD][TD="align:right"]2[/TD][TD="align:right"]0[/TD][TD]Colombia[/TD][/TR]
[TR][TD]Breandan Vallance[/TD][TD="align:right"]10[/TD][TD="align:right"]0[/TD][TD="align:right"]2[/TD][TD="align:right"]0[/TD][TD]United Kingdom[/TD][/TR]
[TR][TD]Yu Da-Hyun[/TD][TD="align:right"]10[/TD][TD="align:right"]0[/TD][TD="align:right"]2[/TD][TD="align:right"]0[/TD][TD]Korea[/TD][/TR]
[TR][TD]Howard Wong Jun Yen (黄俊仁)[/TD][TD="align:right"]10[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]10[/TD][TD]Malaysia[/TD][/TR]
[TR][TD]Tomas Jankauskas[/TD][TD="align:right"]10[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]10[/TD][TD]Lithuania[/TD][/TR]
[TR][TD]Luis Salvador Batarsé Soto[/TD][TD="align:right"]10[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]10[/TD][TD]El Salvador[/TD][/TR]
[TR][TD]Martin Zahradník[/TD][TD="align:right"]10[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]10[/TD][TD]Czech Republic[/TD][/TR]
[TR][TD]Zolboo Erelkhegbaatar[/TD][TD="align:right"]10[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]10[/TD][TD]Mongolia[/TD][/TR]
[TR][TD]Richard Jay S. Apagar[/TD][TD="align:right"]10[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]10[/TD][TD]Philippines[/TD][/TR]
[TR][TD]Gabriel Bucsan[/TD][TD="align:right"]10[/TD][TD="align:right"]0[/TD][TD="align:right"]2[/TD][TD="align:right"]0[/TD][TD]Brazil[/TD][/TR]
[TR][TD]Ben Adcock[/TD][TD="align:right"]10[/TD][TD="align:right"]0[/TD][TD="align:right"]2[/TD][TD="align:right"]0[/TD][TD]Australia[/TD][/TR]
[TR][TD]Brandon Harnish[/TD][TD="align:right"]10[/TD][TD="align:right"]1[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD]USA[/TD][/TR]
[TR][TD]Anatoly Kim[/TD][TD="align:right"]10[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]10[/TD][TD]Belarus[/TD][/TR]
[TR][TD]Marcin Zalewski[/TD][TD="align:right"]10[/TD][TD="align:right"]1[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD]Poland[/TD][/TR]
[TR][TD]Gustavo Maysonnave Franck[/TD][TD="align:right"]10[/TD][TD="align:right"]0[/TD][TD="align:right"]2[/TD][TD="align:right"]0[/TD][TD]Brazil[/TD][/TR]
[TR][TD]Christian Kaserer[/TD][TD="align:right"]10[/TD][TD="align:right"]1[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD]Italy[/TD][/TR]
[TR][TD]Yumu Tabuchi (田渕雄夢)[/TD][TD="align:right"]10[/TD][TD="align:right"]0[/TD][TD="align:right"]2[/TD][TD="align:right"]0[/TD][TD]Japan[/TD][/TR]
[TR][TD]Amr Ramadan[/TD][TD="align:right"]10[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]10[/TD][TD]Egypt[/TD][/TR]
[TR][TD]Alireza Gholami (علیرضا غلامی)[/TD][TD="align:right"]10[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]10[/TD][TD]Afghanistan[/TD][/TR]
[TR][TD]Erwan Kohler[/TD][TD="align:right"]9[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]9[/TD][TD]Switzerland[/TD][/TR]
[TR][TD]Asia Konvittayayotin (เอเชีย กรวิทยโยธิน)[/TD][TD="align:right"]9[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]9[/TD][TD]Thailand[/TD][/TR]
[TR][TD]Eyal Alfasi[/TD][TD="align:right"]9[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]9[/TD][TD]Israel[/TD][/TR]
[TR][TD]Dario Roa Sánchez[/TD][TD="align:right"]9[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]9[/TD][TD]Spain[/TD][/TR]
[TR][TD]SeungBeom Cho (조승범)[/TD][TD="align:right"]9[/TD][TD="align:right"]0[/TD][TD="align:right"]1[/TD][TD="align:right"]4[/TD][TD]Korea[/TD][/TR]
[TR][TD]Mantas Sidabras[/TD][TD="align:right"]9[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]9[/TD][TD]Lithuania[/TD][/TR]
[TR][TD]Maria Koukou[/TD][TD="align:right"]9[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]9[/TD][TD]Cyprus[/TD][/TR]
[TR][TD]Niko Paavilainen[/TD][TD="align:right"]9[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]9[/TD][TD]Finland[/TD][/TR]
[TR][TD]Gabriel Alejandro Orozco Casillas[/TD][TD="align:right"]9[/TD][TD="align:right"]0[/TD][TD="align:right"]1[/TD][TD="align:right"]4[/TD][TD]Mexico[/TD][/TR]
[TR][TD]Alexander Lau[/TD][TD="align:right"]8[/TD][TD="align:right"]0[/TD][TD="align:right"]1[/TD][TD="align:right"]3[/TD][TD]United Kingdom[/TD][/TR]
[TR][TD]Erik Akkersdijk[/TD][TD="align:right"]8[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]8[/TD][TD]Netherlands[/TD][/TR]
[TR][TD]Jorge Leonardo Sánchez Salazar[/TD][TD="align:right"]8[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]8[/TD][TD]Mexico[/TD][/TR]
[TR][TD]Nguyễn Ngọc Thịnh[/TD][TD="align:right"]8[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]8[/TD][TD]Vietnam[/TD][/TR]
[TR][TD]Muhammad Usman Amjad[/TD][TD="align:right"]8[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]8[/TD][TD]Pakistan[/TD][/TR]
[TR][TD]Akash Rupela[/TD][TD="align:right"]8[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]8[/TD][TD]India[/TD][/TR]
[TR][TD]Nikolas Márkus[/TD][TD="align:right"]8[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]8[/TD][TD]Slovakia[/TD][/TR]
[TR][TD]Henrik Buus Aagaard[/TD][TD="align:right"]8[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]8[/TD][TD]Denmark[/TD][/TR]
[TR][TD]Michael Röhrer[/TD][TD="align:right"]8[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]8[/TD][TD]Austria[/TD][/TR]
[TR][TD]Beqa Kakhiani (ბექა კახიანი)[/TD][TD="align:right"]8[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]8[/TD][TD]Georgia[/TD][/TR]
[TR][TD]Andreas Pung[/TD][TD="align:right"]8[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]8[/TD][TD]Estonia[/TD][/TR]
[/TABLE]
SELECT name Cuber, NRs+5*CRs+10*WRs Score, WRs, CRs, NRs, countryId Country
FROM
(SELECT personId, sum(worldRank=1) WRs, sum(continentRank=1 and worldRank>1) CRs, sum(countryRank=1 and continentRank>1) NRs
FROM (SELECT * FROM RanksSingle UNION ALL SELECT * FROM RanksAverage) tmp
GROUP BY personId) tmp2
JOIN Persons on Persons.id = personId and subId = 1
HAVING score >= 8
ORDER BY 2 desc;
I had never even heard of Conor...
 
[TABLE="class:grid,align:left"]
[TR][TD]WRs[/TD][TD]Name[/TD][TD]Events[/TD][/TR]
[TR][TD="align:right"]5[/TD][TD]Máté Horváth[/TD][TD]Master Magic[/TD][/TR]
[TR][TD="align:right"]4[/TD][TD]Yuki Hayashi (林祐樹)[/TD][TD]4x4 Cube[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Claes Hedin[/TD][TD]6x6 Cube, 7x7 Cube[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Tyson Mao (毛台勝)[/TD][TD]3x3 blindfolded[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Walker Welch[/TD][TD]3x3 fewest moves, Skewb[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Tomasz Kiedrowicz[/TD][TD]Pyraminx[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Dan Knights[/TD][TD]Rubik's Cube[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Micael Hellberg[/TD][TD]2x2 Cube[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Christian Kaserer[/TD][TD]2x2 Cube[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Sameer Mahmood[/TD][TD]2x2 Cube[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Chris Krueger[/TD][TD]3x3 blindfolded[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Hong Zhang (张宏)[/TD][TD]3x3 fewest moves[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Jibo Zhao (赵吉波)[/TD][TD]3x3 fewest moves[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Tong Jiang (蒋彤)[/TD][TD]3x3 multi blind[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Piotr Tomczyk[/TD][TD]3x3 one-handed[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Will Arnold[/TD][TD]3x3 with feet[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Sunil Pedapudi[/TD][TD]Master Magic[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Andy Bellenir[/TD][TD]Pyraminx[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Minh Thai[/TD][TD]Rubik's Cube[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Toby Mao (毛台立)[/TD][TD]Rubik's Cube[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Henrik Bui[/TD][TD]Rubik's Magic[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]John Brechon[/TD][TD]Skewb[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Abhishek Sathyanarayanan[/TD][TD]Skewb[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Santosh Tantravahi[/TD][TD]Skewb[/TD][/TR]
[/TABLE]
SELECT sum((regionalSingleRecord='WR')+(regionalAverageRecord='WR')) WRs, personName Name, group_concat(distinct Events.cellName separator ', ') Events
FROM Results JOIN Events ON Events.id = eventId
WHERE regionalSingleRecord like '%R' or regionalAverageRecord like '%R'
GROUP BY personId
HAVING WRs and WRs = sum((regionalSingleRecord like '%R')+(regionalAverageRecord like '%R'))
ORDER BY WRs desc, Events;
 
Stefan said:
[TABLE="class:grid,align:left"]
[TR][TD]WRs[/TD][TD]Name[/TD][TD]Events[/TD][/TR]
[TR][TD="align:right"]5[/TD][TD]Máté Horváth[/TD][TD]Master Magic[/TD][/TR]
[TR][TD="align:right"]4[/TD][TD]Yuki Hayashi (林祐樹)[/TD][TD]4x4 Cube[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Claes Hedin[/TD][TD]6x6 Cube, 7x7 Cube[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Tyson Mao (毛台勝)[/TD][TD]3x3 blindfolded[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Walker Welch[/TD][TD]3x3 fewest moves, Skewb[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Tomasz Kiedrowicz[/TD][TD]Pyraminx[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Dan Knights[/TD][TD]Rubik's Cube[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Micael Hellberg[/TD][TD]2x2 Cube[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Christian Kaserer[/TD][TD]2x2 Cube[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Sameer Mahmood[/TD][TD]2x2 Cube[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Chris Krueger[/TD][TD]3x3 blindfolded[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Hong Zhang (张宏)[/TD][TD]3x3 fewest moves[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Jibo Zhao (赵吉波)[/TD][TD]3x3 fewest moves[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Tong Jiang (蒋彤)[/TD][TD]3x3 multi blind[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Piotr Tomczyk[/TD][TD]3x3 one-handed[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Will Arnold[/TD][TD]3x3 with feet[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Sunil Pedapudi[/TD][TD]Master Magic[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Andy Bellenir[/TD][TD]Pyraminx[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Minh Thai[/TD][TD]Rubik's Cube[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Toby Mao (毛台立)[/TD][TD]Rubik's Cube[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Henrik Bui[/TD][TD]Rubik's Magic[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]John Brechon[/TD][TD]Skewb[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Abhishek Sathyanarayanan[/TD][TD]Skewb[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Santosh Tantravahi[/TD][TD]Skewb[/TD][/TR]
[/TABLE]
SELECT sum((regionalSingleRecord='WR')+(regionalAverageRecord='WR')) WRs, personName Name, group_concat(distinct Events.cellName separator ', ') Events
FROM Results JOIN Events ON Events.id = eventId
WHERE regionalSingleRecord like '%R' or regionalAverageRecord like '%R'
GROUP BY personId
HAVING WRs and WRs = sum((regionalSingleRecord like '%R')+(regionalAverageRecord like '%R'))
ORDER BY WRs desc, Events;
Click to expand...
Walker's fewest moves records were NARs, so he shouldn't be in this list.
 
[TABLE="class:grid,align:left"]
[TR][TD]Event[/TD][TD]DNF percentage[/TD][TD]DNFs/Attempts[/TD][/TR]
[TR][TD]5x5 blindfolded[/TD][TD="align:right"]81.95[/TD][TD]1970/2404[/TD][/TR]
[TR][TD]4x4 blindfolded[/TD][TD="align:right"]77.54[/TD][TD]4081/5263[/TD][/TR]
[TR][TD]3x3 blindfolded[/TD][TD="align:right"]67.50[/TD][TD]40014/59281[/TD][/TR]
[TR][TD]3x3 multi blind[/TD][TD="align:right"]46.00[/TD][TD]3049/6628[/TD][/TR]
[TR][TD]3x3 fewest moves[/TD][TD="align:right"]39.45[/TD][TD]5000/12675[/TD][/TR]
[TR][TD]3x3 multi blind old[/TD][TD="align:right"]31.30[/TD][TD]185/591[/TD][/TR]
[TR][TD]Rubik's Clock[/TD][TD="align:right"]14.21[/TD][TD]5406/38035[/TD][/TR]
[TR][TD]3x3 with feet[/TD][TD="align:right"]11.11[/TD][TD]895/8054[/TD][/TR]
[TR][TD]Rubik's Magic[/TD][TD="align:right"]9.51[/TD][TD]8230/86498[/TD][/TR]
[TR][TD]6x6 Cube[/TD][TD="align:right"]5.43[/TD][TD]1013/18655[/TD][/TR]
[TR][TD]Square-1[/TD][TD="align:right"]5.16[/TD][TD]2158/41784[/TD][/TR]
[TR][TD]7x7 Cube[/TD][TD="align:right"]4.72[/TD][TD]771/16352[/TD][/TR]
[TR][TD]Megaminx[/TD][TD="align:right"]4.03[/TD][TD]1935/48003[/TD][/TR]
[TR][TD]Skewb[/TD][TD="align:right"]3.94[/TD][TD]839/21270[/TD][/TR]
[TR][TD]4x4 Cube[/TD][TD="align:right"]3.86[/TD][TD]8805/228325[/TD][/TR]
[TR][TD]Master Magic[/TD][TD="align:right"]3.57[/TD][TD]1481/41445[/TD][/TR]
[TR][TD]3x3 one-handed[/TD][TD="align:right"]3.49[/TD][TD]8506/243942[/TD][/TR]
[TR][TD]5x5 Cube[/TD][TD="align:right"]3.13[/TD][TD]3909/125043[/TD][/TR]
[TR][TD]Pyraminx[/TD][TD="align:right"]2.86[/TD][TD]4735/165422[/TD][/TR]
[TR][TD]2x2 Cube[/TD][TD="align:right"]2.72[/TD][TD]10139/373282[/TD][/TR]
[TR][TD]Rubik's Cube[/TD][TD="align:right"]2.62[/TD][TD]19244/734583[/TD][/TR]
[/TABLE]
SELECT Event, round(100*DNFs/(solves+DNFs), 2) 'DNF percentage', concat(DNFs, '/', solves+DNFs) 'DNFs/Attempts'
FROM
(SELECT
cellName Event,
sum((value1=-1)+(value2=-1)+(value3=-1)+(value4=-1)+(value5=-1)) DNFs,
sum((value1>0)+(value2>0)+(value3>0)+(value4>0)+(value5>0)) solves
FROM Results JOIN Events ON Events.id = eventId
GROUP BY eventId) tmp
ORDER BY 2 desc;
 
Evan Liu said:
Walker's fewest moves records were NARs, so he shouldn't be in this list.
Click to expand...

Thanks. Apparently we recently started using nulls instead of empty strings for the markers, that screwed me up. Gah... some of my other stats might be off as well, but I don't want to check right now, sorry...

Hopefully correct now:

[TABLE="class:grid,align:left"]
[TR][TD]WRs[/TD][TD]Name[/TD][TD]Events[/TD][TD]sum((regionalSingleRecord like '%R')+(regionalAverageRecord like '%R'))[/TD][/TR]
[TR][TD="align:right"]5[/TD][TD]Máté Horváth[/TD][TD]Master Magic[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD="align:right"]4[/TD][TD]Yuki Hayashi (林祐樹)[/TD][TD]4x4 Cube[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD="align:right"]3[/TD][TD]Claes Hedin[/TD][TD]6x6 Cube, 7x7 Cube[/TD][TD="align:right"]3[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Tyson Mao (毛台勝)[/TD][TD]3x3 blindfolded[/TD][TD="align:right"]2[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Tomasz Kiedrowicz[/TD][TD]Pyraminx[/TD][TD="align:right"]2[/TD][/TR]
[TR][TD="align:right"]2[/TD][TD]Dan Knights[/TD][TD]Rubik's Cube[/TD][TD="align:right"]2[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Micael Hellberg[/TD][TD]2x2 Cube[/TD][TD="align:right"]1[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Christian Kaserer[/TD][TD]2x2 Cube[/TD][TD="align:right"]1[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Sameer Mahmood[/TD][TD]2x2 Cube[/TD][TD="align:right"]1[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Chris Krueger[/TD][TD]3x3 blindfolded[/TD][TD="align:right"]1[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Hong Zhang (张宏)[/TD][TD]3x3 fewest moves[/TD][TD="align:right"]1[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Jibo Zhao (赵吉波)[/TD][TD]3x3 fewest moves[/TD][TD="align:right"]1[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Tong Jiang (蒋彤)[/TD][TD]3x3 multi blind[/TD][TD="align:right"]1[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Piotr Tomczyk[/TD][TD]3x3 one-handed[/TD][TD="align:right"]1[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Will Arnold[/TD][TD]3x3 with feet[/TD][TD="align:right"]1[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Sunil Pedapudi[/TD][TD]Master Magic[/TD][TD="align:right"]1[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Andy Bellenir[/TD][TD]Pyraminx[/TD][TD="align:right"]1[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Minh Thai[/TD][TD]Rubik's Cube[/TD][TD="align:right"]1[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Toby Mao (毛台立)[/TD][TD]Rubik's Cube[/TD][TD="align:right"]1[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Henrik Bui[/TD][TD]Rubik's Magic[/TD][TD="align:right"]1[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]John Brechon[/TD][TD]Skewb[/TD][TD="align:right"]1[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Abhishek Sathyanarayanan[/TD][TD]Skewb[/TD][TD="align:right"]1[/TD][/TR]
[TR][TD="align:right"]1[/TD][TD]Santosh Tantravahi[/TD][TD]Skewb[/TD][TD="align:right"]1[/TD][/TR]
[/TABLE]
SELECT sum((ifnull(regionalSingleRecord,'')='WR')+(ifnull(regionalAverageRecord,'')='WR')) WRs, personName Name, group_concat(distinct Events.cellName separator ', ') Events, sum((regionalSingleRecord like '%R')+(regionalAverageRecord like '%R'))
FROM Results JOIN Events ON Events.id = eventId
WHERE regionalSingleRecord like '%R' or regionalAverageRecord like '%R'
GROUP BY personId
HAVING WRs and WRs = sum((ifnull(regionalSingleRecord,'') like '%R')+(ifnull(regionalAverageRecord,'') like '%R'))
ORDER BY WRs desc, Events;
 
We're getting slower.

Using data from WCA_export451_20140827 and Stefan's WCA statistics tool.

[TABLE="class:grid,align:left"]
[TR][TD]year[/TD][TD]average[/TD][TD]solves[/TD][/TR]
[TR][TD="align:right"]1982[/TD][TD="align:right"]33.83[/TD][TD="align:right"]56[/TD][/TR]
[TR][TD="align:right"]2003[/TD][TD="align:right"]42.86[/TD][TD="align:right"]398[/TD][/TR]
[TR][TD="align:right"]2004[/TD][TD="align:right"]41.21[/TD][TD="align:right"]1775[/TD][/TR]
[TR][TD="align:right"]2005[/TD][TD="align:right"]36.90[/TD][TD="align:right"]4656[/TD][/TR]
[TR][TD="align:right"]2006[/TD][TD="align:right"]34.80[/TD][TD="align:right"]8344[/TD][/TR]
[TR][TD="align:right"]2007[/TD][TD="align:right"]34.40[/TD][TD="align:right"]16514[/TD][/TR]
[TR][TD="align:right"]2008[/TD][TD="align:right"]31.26[/TD][TD="align:right"]35483[/TD][/TR]
[TR][TD="align:right"]2009[/TD][TD="align:right"]30.86[/TD][TD="align:right"]63546[/TD][/TR]
[TR][TD="align:right"]2010[/TD][TD="align:right"]27.73[/TD][TD="align:right"]86440[/TD][/TR]
[TR][TD="align:right"]2011[/TD][TD="align:right"]25.37[/TD][TD="align:right"]106737[/TD][/TR]
[TR][TD="align:right"]2012[/TD][TD="align:right"]24.33[/TD][TD="align:right"]114970[/TD][/TR]
[TR][TD="align:right"]2013[/TD][TD="align:right"]25.28[/TD][TD="align:right"]151504[/TD][/TR]
[TR][TD="align:right"]2014[/TD][TD="align:right"]25.58[/TD][TD="align:right"]133253[/TD][/TR]
[/TABLE]

SELECT year, round(sum(seconds)/sum(solves), 2) average, sum(solves) solves
FROM
(SELECT
competitionId,
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))/100 seconds,
sum((value1>0)+(value2>0)+(value3>0)+(value4>0)+(value5>0)) solves
FROM Results
WHERE eventId = '333'
GROUP BY competitionId) tmp
JOIN Competitions ON Competitions.id = competitionId
GROUP BY year
ORDER BY year;
 
Last edited:
Stefan said:
We're getting slower.

[TABLE="class:grid,align:left"]
[TR][TD]year[/TD][TD]average[/TD][TD]solves[/TD][/TR]
[TR][TD="align:right"]1982[/TD][TD="align:right"]33.83[/TD][TD="align:right"]56[/TD][/TR]
[TR][TD="align:right"]2003[/TD][TD="align:right"]42.86[/TD][TD="align:right"]398[/TD][/TR]
[TR][TD="align:right"]2004[/TD][TD="align:right"]41.21[/TD][TD="align:right"]1775[/TD][/TR]
[TR][TD="align:right"]2005[/TD][TD="align:right"]36.90[/TD][TD="align:right"]4656[/TD][/TR]
[TR][TD="align:right"]2006[/TD][TD="align:right"]34.80[/TD][TD="align:right"]8344[/TD][/TR]
[TR][TD="align:right"]2007[/TD][TD="align:right"]34.40[/TD][TD="align:right"]16514[/TD][/TR]
[TR][TD="align:right"]2008[/TD][TD="align:right"]31.26[/TD][TD="align:right"]35483[/TD][/TR]
[TR][TD="align:right"]2009[/TD][TD="align:right"]30.86[/TD][TD="align:right"]63546[/TD][/TR]
[TR][TD="align:right"]2010[/TD][TD="align:right"]27.73[/TD][TD="align:right"]86440[/TD][/TR]
[TR][TD="align:right"]2011[/TD][TD="align:right"]25.37[/TD][TD="align:right"]106737[/TD][/TR]
[TR][TD="align:right"]2012[/TD][TD="align:right"]24.33[/TD][TD="align:right"]114970[/TD][/TR]
[TR][TD="align:right"]2013[/TD][TD="align:right"]25.28[/TD][TD="align:right"]151504[/TD][/TR]
[TR][TD="align:right"]2014[/TD][TD="align:right"]25.49[/TD][TD="align:right"]124916[/TD][/TR]
[/TABLE]
SELECT year, round(sum(seconds)/sum(solves), 2) average, sum(solves) solves
FROM
(SELECT
competitionId,
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))/100 seconds,
sum((value1>0)+(value2>0)+(value3>0)+(value4>0)+(value5>0)) solves
FROM Results
WHERE eventId = '333'
GROUP BY competitionId) tmp
JOIN Competitions ON Competitions.id = competitionId
GROUP BY year
ORDER BY year;
Click to expand...
It may mean that more people are eager to compete even if they aren't fast.
 
Last edited:
You must log in or register to reply here.

Similar threads

Minetoucubing
Odd or fake QJ megaminx?
Replies
0
Views
188
Minetoucubing
Minetoucubing
MrCubert
SS Oddballs Redemption 2026
Replies
2
Views
432
MrCubert
MrCubert
J
Special Characters in my name appear odd in the weekly competitions
Replies
0
Views
484
J:org
J
D
reduction parity on odd cubes vs even cubes
Replies
5
Views
3,044
Christopher Mowla
Christopher Mowla
Discomantis
Need help solving odd swaps on big cubes
Replies
15
Views
2,501
Discomantis
Discomantis
Back
Top