Odd WCA stats/ Stats request Thread

Stefan · Dec 1, 2013

qqwref said:
And my worst solve was 56.62% of the best solve by anyone else - is that a record?

This only considers the final round, sorry:

[TABLE="class:grid,align:left"]
[TR][TD]competitionId[/TD][TD]eventId[/TD][TD]personName[/TD][TD]worst[/TD][TD]percent[/TD][/TR]
[TR][TD]HelsinkiOpen2009[/TD][TD]333bf[/TD][TD]Ville Seppänen[/TD][TD="align:right"]52.05[/TD][TD="align:right"]9.3990[/TD][/TR]
[TR][TD]SkarupLastChance2011[/TD][TD]333ft[/TD][TD]Henrik Buus Aagaard[/TD][TD="align:right"]51.38[/TD][TD="align:right"]9.5502[/TD][/TR]
[TR][TD]BuenosAiresOpenIII2011[/TD][TD]333bf[/TD][TD]Tomás Mansilla[/TD][TD="align:right"]61.25[/TD][TD="align:right"]11.5920[/TD][/TR]
[TR][TD]XianLucky2011[/TD][TD]333bf[/TD][TD]Yuhui Xu (许宇辉)[/TD][TD="align:right"]33.72[/TD][TD="align:right"]12.9667[/TD][/TR]
[TR][TD]GuildfordSummerOpen2011[/TD][TD]444bf[/TD][TD]Daniel Sheppard[/TD][TD="align:right"]206.11[/TD][TD="align:right"]14.3431[/TD][/TR]
[TR][TD]ThailandOpen2010[/TD][TD]333bf[/TD][TD]Preeda Hongpimolmas[/TD][TD="align:right"]71.86[/TD][TD="align:right"]15.7861[/TD][/TR]
[TR][TD]MidColumbia2013[/TD][TD]333bf[/TD][TD]Nick Vu[/TD][TD="align:right"]89.97[/TD][TD="align:right"]16.6104[/TD][/TR]
[TR][TD]HunanOpen2010[/TD][TD]333bf[/TD][TD]Haiyan Zhuang (庄海燕)[/TD][TD="align:right"]36.03[/TD][TD="align:right"]16.6744[/TD][/TR]
[TR][TD]FinnishOpen2010[/TD][TD]333ft[/TD][TD]Anssi Vanhala[/TD][TD="align:right"]51.28[/TD][TD="align:right"]16.7478[/TD][/TR]
[TR][TD]JemberOpen2013[/TD][TD]333bf[/TD][TD]Yudanis Taqwin Rohman[/TD][TD="align:right"]46.36[/TD][TD="align:right"]16.9748[/TD][/TR]
[TR][TD]MinasOpen2008[/TD][TD]333bf[/TD][TD]Pedro Santos Guimarães[/TD][TD="align:right"]83.05[/TD][TD="align:right"]17.1641[/TD][/TR]
[TR][TD]MaculAutumn2012[/TD][TD]333bf[/TD][TD]Francisco Javier Lemes Sáez[/TD][TD="align:right"]45.16[/TD][TD="align:right"]18.0121[/TD][/TR]
[TR][TD]RubiksBaires2011[/TD][TD]333bf[/TD][TD]Tomás Mansilla[/TD][TD="align:right"]65.34[/TD][TD="align:right"]20.2435[/TD][/TR]
[TR][TD]FloatingClouds2011[/TD][TD]333bf[/TD][TD]Yuhui Xu (许宇辉)[/TD][TD="align:right"]36.31[/TD][TD="align:right"]20.3099[/TD][/TR]
[TR][TD]IdahoOpen2007[/TD][TD]333bf[/TD][TD]Chris Krueger[/TD][TD="align:right"]99.36[/TD][TD="align:right"]20.4407[/TD][/TR]
[TR][TD]AustrianOpen2013[/TD][TD]444bf[/TD][TD]Marcell Endrey[/TD][TD="align:right"]151.16[/TD][TD="align:right"]20.5102[/TD][/TR]
[TR][TD]CubeCanadaDay2011[/TD][TD]333bf[/TD][TD]Justin Jaffray[/TD][TD="align:right"]183.53[/TD][TD="align:right"]20.7379[/TD][/TR]
[TR][TD]PLG2Open2012[/TD][TD]333bf[/TD][TD]Francisco Javier Lemes Sáez[/TD][TD="align:right"]52.96[/TD][TD="align:right"]20.8053[/TD][/TR]
[TR][TD]NovoHamburgoOpen2011[/TD][TD]333ft[/TD][TD]Rafael Werneck Cinoto[/TD][TD="align:right"]77.81[/TD][TD="align:right"]21.0759[/TD][/TR]
[TR][TD]NationalCapitalRegion2012[/TD][TD]333bf[/TD][TD]Julian David[/TD][TD="align:right"]121.34[/TD][TD="align:right"]21.3522[/TD][/TR]
[TR][TD]TampereOpen2008[/TD][TD]333ft[/TD][TD]Anssi Vanhala[/TD][TD="align:right"]50.09[/TD][TD="align:right"]21.5478[/TD][/TR]
[TR][TD]GoianiaOpen2011[/TD][TD]333ft[/TD][TD]Rafael Werneck Cinoto[/TD][TD="align:right"]55.02[/TD][TD="align:right"]21.5579[/TD][/TR]
[TR][TD]NovoHamburgoII2012[/TD][TD]333ft[/TD][TD]Rafael Werneck Cinoto[/TD][TD="align:right"]44.68[/TD][TD="align:right"]21.7104[/TD][/TR]
[TR][TD]TorneodeVerano2012[/TD][TD]333bf[/TD][TD]Tomás Mansilla[/TD][TD="align:right"]62.61[/TD][TD="align:right"]21.8389[/TD][/TR]
[TR][TD]BarcelonaWinterOpen2012[/TD][TD]333bf[/TD][TD]Lucas Benito Rolando[/TD][TD="align:right"]37.44[/TD][TD="align:right"]22.1015[/TD][/TR]
[TR][TD]MelbourneCubeDay2010[/TD][TD]333bf[/TD][TD]Feliks Zemdegs[/TD][TD="align:right"]76.81[/TD][TD="align:right"]22.7666[/TD][/TR]
[TR][TD]CalDay2012[/TD][TD]333bf[/TD][TD]Lucas Garron[/TD][TD="align:right"]91.06[/TD][TD="align:right"]22.8777[/TD][/TR]
[TR][TD]CubingSpringGrudziadz2012[/TD][TD]333bf[/TD][TD]Marcin Zalewski[/TD][TD="align:right"]49.47[/TD][TD="align:right"]23.1082[/TD][/TR]
[TR][TD]TulancingoOpen2010[/TD][TD]333bf[/TD][TD]Gabriel Alejandro Orozco Casillas[/TD][TD="align:right"]77.03[/TD][TD="align:right"]23.5710[/TD][/TR]
[TR][TD]DusseldorfOpen2010[/TD][TD]444bf[/TD][TD]Kai Jiptner[/TD][TD="align:right"]369.94[/TD][TD="align:right"]23.8979[/TD][/TR]
[TR][TD]CampeonatoBlind2013[/TD][TD]333bf[/TD][TD]Francisco Javier Lemes Sáez[/TD][TD="align:right"]41.59[/TD][TD="align:right"]23.9491[/TD][/TR]
[TR][TD]CubeFactory2013[/TD][TD]444bf[/TD][TD]Grzegorz Jałocha[/TD][TD="align:right"]214.94[/TD][TD="align:right"]24.5927[/TD][/TR]
[TR][TD]HebeiUniversity2013[/TD][TD]333bf[/TD][TD]Yang Hu (胡扬)[/TD][TD="align:right"]74.96[/TD][TD="align:right"]24.7058[/TD][/TR]
[TR][TD]InnerMongolia2010[/TD][TD]333bf[/TD][TD]Haiyan Zhuang (庄海燕)[/TD][TD="align:right"]35.78[/TD][TD="align:right"]26.1971[/TD][/TR]
[TR][TD]DeVryOpen2010[/TD][TD]333bf[/TD][TD]Chester Lian[/TD][TD="align:right"]60.22[/TD][TD="align:right"]26.2786[/TD][/TR]
[TR][TD]BasauriOpen2011[/TD][TD]333bf[/TD][TD]Lucas Benito Rolando[/TD][TD="align:right"]37.41[/TD][TD="align:right"]26.4925[/TD][/TR]
[TR][TD]GuangdongOpen2013[/TD][TD]444bf[/TD][TD]Kaijun Lin (林恺俊)[/TD][TD="align:right"]245.32[/TD][TD="align:right"]26.5211[/TD][/TR]
[TR][TD]XianSpring2010[/TD][TD]333bf[/TD][TD]Haiyan Zhuang (庄海燕)[/TD][TD="align:right"]36.30[/TD][TD="align:right"]26.6481[/TD][/TR]
[TR][TD]TrentinOpen2011[/TD][TD]333bf[/TD][TD]Sebastiano Tronto[/TD][TD="align:right"]54.81[/TD][TD="align:right"]26.6897[/TD][/TR]
[TR][TD]NanjingSpringOpen2010[/TD][TD]333bf[/TD][TD]Haiyan Zhuang (庄海燕)[/TD][TD="align:right"]38.41[/TD][TD="align:right"]27.5538[/TD][/TR]
[TR][TD]PLGOpen2012[/TD][TD]333bf[/TD][TD]Francisco Javier Lemes Sáez[/TD][TD="align:right"]57.06[/TD][TD="align:right"]27.5865[/TD][/TR]
[TR][TD]Uberlandia2010[/TD][TD]333ft[/TD][TD]Rafael Werneck Cinoto[/TD][TD="align:right"]59.03[/TD][TD="align:right"]28.2860[/TD][/TR]
[TR][TD]AracajuOpen2012[/TD][TD]333ft[/TD][TD]Rafael Werneck Cinoto[/TD][TD="align:right"]56.00[/TD][TD="align:right"]28.5598[/TD][/TR]
[TR][TD]NanchangOpen2013[/TD][TD]333bf[/TD][TD]Yang Hu (胡扬)[/TD][TD="align:right"]39.83[/TD][TD="align:right"]28.6176[/TD][/TR]
[TR][TD]HangzhouOpen2011[/TD][TD]333bf[/TD][TD]Yuhui Xu (许宇辉)[/TD][TD="align:right"]36.28[/TD][TD="align:right"]28.6301[/TD][/TR]
[TR][TD]AniversarioEduardoValdivia2012[/TD][TD]333bf[/TD][TD]Natán Riggenbach[/TD][TD="align:right"]119.66[/TD][TD="align:right"]28.9320[/TD][/TR]
[TR][TD]KotkaOpen2011[/TD][TD]333ft[/TD][TD]Anssi Vanhala[/TD][TD="align:right"]42.84[/TD][TD="align:right"]29.2264[/TD][/TR]
[TR][TD]WinonaOpen2013[/TD][TD]333bf[/TD][TD]John Brechon[/TD][TD="align:right"]102.38[/TD][TD="align:right"]29.2723[/TD][/TR]
[TR][TD]Bangkok2012[/TD][TD]333ft[/TD][TD]Tong Boonrod (ต๋อง บุญรอด)[/TD][TD="align:right"]53.13[/TD][TD="align:right"]29.4447[/TD][/TR]
[TR][TD]KubarooOpen2011[/TD][TD]333bf[/TD][TD]Zane Carney[/TD][TD="align:right"]80.75[/TD][TD="align:right"]29.4859[/TD][/TR]
[TR][TD]SESCSantos2010[/TD][TD]333ft[/TD][TD]Rafael Werneck Cinoto[/TD][TD="align:right"]64.47[/TD][TD="align:right"]30.0882[/TD][/TR]
[TR][TD]NUS2011[/TD][TD]333bf[/TD][TD]Chew Weng Chuen[/TD][TD="align:right"]124.63[/TD][TD="align:right"]30.6118[/TD][/TR]
[TR][TD]Valparaiso2013[/TD][TD]333bf[/TD][TD]Francisco Javier Lemes Sáez[/TD][TD="align:right"]61.40[/TD][TD="align:right"]30.6632[/TD][/TR]
[TR][TD]UFCGOpen2012[/TD][TD]333ft[/TD][TD]Rafael Werneck Cinoto[/TD][TD="align:right"]51.47[/TD][TD="align:right"]30.6625[/TD][/TR]
[TR][TD]SafeHaven2010[/TD][TD]333bf[/TD][TD]Rowe Hessler[/TD][TD="align:right"]83.28[/TD][TD="align:right"]30.7567[/TD][/TR]
[TR][TD]BrazilOpen2007[/TD][TD]333bf[/TD][TD]Pedro Santos Guimarães[/TD][TD="align:right"]113.34[/TD][TD="align:right"]30.9030[/TD][/TR]
[TR][TD]MalaysiaCubeOpen2012[/TD][TD]333bf[/TD][TD]Amos Tay Swee Hui[/TD][TD="align:right"]54.41[/TD][TD="align:right"]31.2306[/TD][/TR]
[TR][TD]DenverOpen2010[/TD][TD]333bf[/TD][TD]Tyson Mao (毛台勝)[/TD][TD="align:right"]134.63[/TD][TD="align:right"]31.7254[/TD][/TR]
[TR][TD]PuydeDomeOpen2012[/TD][TD]333bf[/TD][TD]François Courtès[/TD][TD="align:right"]69.02[/TD][TD="align:right"]31.8343[/TD][/TR]
[TR][TD]BergshamraBlind2013[/TD][TD]444bf[/TD][TD]Mats Bergsten[/TD][TD="align:right"]527.05[/TD][TD="align:right"]31.9038[/TD][/TR]
[TR][TD]VancouverOpen2009[/TD][TD]333bf[/TD][TD]Hong Chen[/TD][TD="align:right"]169.88[/TD][TD="align:right"]31.9041[/TD][/TR]
[TR][TD]BattleOfLexington2010[/TD][TD]444bf[/TD][TD]Chester Lian[/TD][TD="align:right"]417.13[/TD][TD="align:right"]32.1364[/TD][/TR]
[TR][TD]PragyanOpen2011[/TD][TD]555[/TD][TD]Bernett Orlando[/TD][TD="align:right"]118.40[/TD][TD="align:right"]32.3497[/TD][/TR]
[TR][TD]Draco2013[/TD][TD]333ft[/TD][TD]Rafael Werneck Cinoto[/TD][TD="align:right"]58.21[/TD][TD="align:right"]32.4905[/TD][/TR]
[TR][TD]UtahOpen2008[/TD][TD]sq1[/TD][TD]Takao Hashimoto (橋本貴夫)[/TD][TD="align:right"]59.65[/TD][TD="align:right"]32.5015[/TD][/TR]
[TR][TD]CaltechFall2010[/TD][TD]333ft[/TD][TD]Steven Turner[/TD][TD="align:right"]122.57[/TD][TD="align:right"]32.6045[/TD][/TR]
[TR][TD]ZuneOpen2012[/TD][TD]555bf[/TD][TD]Marcell Endrey[/TD][TD="align:right"]404.77[/TD][TD="align:right"]32.6164[/TD][/TR]
[TR][TD]Minnesota2010[/TD][TD]333bf[/TD][TD]Chester Lian[/TD][TD="align:right"]77.36[/TD][TD="align:right"]32.6924[/TD][/TR]
[TR][TD]MinasOpen2008[/TD][TD]sq1[/TD][TD]Pedro Santos Guimarães[/TD][TD="align:right"]78.52[/TD][TD="align:right"]32.7139[/TD][/TR]
[TR][TD]HarbinOpen2009[/TD][TD]333bf[/TD][TD]Haiyan Zhuang (庄海燕)[/TD][TD="align:right"]47.05[/TD][TD="align:right"]33.1805[/TD][/TR]
[TR][TD]Draughons2006[/TD][TD]333bf[/TD][TD]Frank Morris[/TD][TD="align:right"]196.62[/TD][TD="align:right"]34.1171[/TD][/TR]
[TR][TD]EstonianOpen2009[/TD][TD]333ft[/TD][TD]Anssi Vanhala[/TD][TD="align:right"]46.05[/TD][TD="align:right"]34.7495[/TD][/TR]
[TR][TD]LagartoOpen2012[/TD][TD]333ft[/TD][TD]Rafael Werneck Cinoto[/TD][TD="align:right"]54.68[/TD][TD="align:right"]34.8436[/TD][/TR]
[TR][TD]GoianiaOpen2012[/TD][TD]333ft[/TD][TD]Rafael Werneck Cinoto[/TD][TD="align:right"]56.56[/TD][TD="align:right"]34.9007[/TD][/TR]
[TR][TD]KubarooOpen2011[/TD][TD]sq1[/TD][TD]Alexandra Daryl Ariawan[/TD][TD="align:right"]26.96[/TD][TD="align:right"]34.9721[/TD][/TR]
[TR][TD]JakartaCeriaOpen2010[/TD][TD]555bf[/TD][TD]Muhammad Iril Khairul Anam[/TD][TD="align:right"]769.00[/TD][TD="align:right"]35.4052[/TD][/TR]
[TR][TD]SuzhouOpen2012[/TD][TD]333bf[/TD][TD]Meng'an Pu (浦梦安)[/TD][TD="align:right"]60.44[/TD][TD="align:right"]35.4612[/TD][/TR]
[TR][TD]SSCCOpen2011[/TD][TD]333ft[/TD][TD]José Navarro[/TD][TD="align:right"]91.78[/TD][TD="align:right"]35.4760[/TD][/TR]
[TR][TD]IndianOpen2008[/TD][TD]sq1[/TD][TD]Bernett Orlando[/TD][TD="align:right"]33.19[/TD][TD="align:right"]35.6805[/TD][/TR]
[TR][TD]KalmykiOpen2013[/TD][TD]444bf[/TD][TD]Oleg Gritsenko[/TD][TD="align:right"]208.52[/TD][TD="align:right"]35.6847[/TD][/TR]
[TR][TD]UtahSummer2010[/TD][TD]333bf[/TD][TD]Michael Young[/TD][TD="align:right"]193.40[/TD][TD="align:right"]35.6873[/TD][/TR]
[TR][TD]TaiwanSummer2013[/TD][TD]333bf[/TD][TD]Jia-Hong Lu (陸嘉宏)[/TD][TD="align:right"]51.41[/TD][TD="align:right"]35.8283[/TD][/TR]
[TR][TD]DanishSpecial2013[/TD][TD]333ft[/TD][TD]Henrik Buus Aagaard[/TD][TD="align:right"]60.56[/TD][TD="align:right"]35.9599[/TD][/TR]
[TR][TD]UIndyOpen2011[/TD][TD]333bf[/TD][TD]Chester Lian[/TD][TD="align:right"]72.58[/TD][TD="align:right"]36.4724[/TD][/TR]
[TR][TD]ColoradoSprings2013[/TD][TD]sq1[/TD][TD]AJ Blair[/TD][TD="align:right"]36.94[/TD][TD="align:right"]36.8002[/TD][/TR]
[TR][TD]FinnishOpen2008[/TD][TD]333bf[/TD][TD]Ville Seppänen[/TD][TD="align:right"]78.33[/TD][TD="align:right"]36.9324[/TD][/TR]
[TR][TD]DutchMasters2008[/TD][TD]444bf[/TD][TD]Tim Habermaas[/TD][TD="align:right"]804.00[/TD][TD="align:right"]36.9485[/TD][/TR]
[TR][TD]FunFastingDay2011[/TD][TD]555bf[/TD][TD]Aldo Feandri[/TD][TD="align:right"]1299.00[/TD][TD="align:right"]37.0085[/TD][/TR]
[TR][TD]WuhanOpen2010[/TD][TD]333bf[/TD][TD]Shengdong Lin[/TD][TD="align:right"]118.63[/TD][TD="align:right"]37.0939[/TD][/TR]
[TR][TD]FinnishOpen2007[/TD][TD]333ft[/TD][TD]Anssi Vanhala[/TD][TD="align:right"]67.46[/TD][TD="align:right"]37.1619[/TD][/TR]
[TR][TD]SaintPetersburgOpen2013[/TD][TD]333bf[/TD][TD]Anton Rostovikov[/TD][TD="align:right"]38.40[/TD][TD="align:right"]37.2526[/TD][/TR]
[TR][TD]ShanghaiWinter2010[/TD][TD]333bf[/TD][TD]Haiyan Zhuang (庄海燕)[/TD][TD="align:right"]32.27[/TD][TD="align:right"]37.3668[/TD][/TR]
[TR][TD]MarianoMelgar2013[/TD][TD]333bf[/TD][TD]Natán Riggenbach[/TD][TD="align:right"]64.19[/TD][TD="align:right"]37.3959[/TD][/TR]
[TR][TD]PueblaOpen2009[/TD][TD]333bf[/TD][TD]Gabriel Alejandro Orozco Casillas[/TD][TD="align:right"]129.38[/TD][TD="align:right"]37.4407[/TD][/TR]
[TR][TD]IndustrialCube2012[/TD][TD]333bf[/TD][TD]Marcin Kowalczyk[/TD][TD="align:right"]36.93[/TD][TD="align:right"]37.4810[/TD][/TR]
[TR][TD]NiseiWeek2013[/TD][TD]333bf[/TD][TD]Tim Wong[/TD][TD="align:right"]41.66[/TD][TD="align:right"]37.4775[/TD][/TR]
[TR][TD]WisconsinOpen2008[/TD][TD]333bf[/TD][TD]Nikhil Charles[/TD][TD="align:right"]128.94[/TD][TD="align:right"]37.5011[/TD][/TR]
[TR][TD]UkraineOpen2012[/TD][TD]444bf[/TD][TD]Oleg Gritsenko[/TD][TD="align:right"]590.84[/TD][TD="align:right"]37.7775[/TD][/TR]
[TR][TD]SCMU2013[/TD][TD]444bf[/TD][TD]Nikhil Mande[/TD][TD="align:right"]519.59[/TD][TD="align:right"]38.1490[/TD][/TR]
[TR][TD]ShanghaiOpen2008[/TD][TD]333bf[/TD][TD]Timothy Sun[/TD][TD="align:right"]89.06[/TD][TD="align:right"]38.4111[/TD][/TR]
[/TABLE]

SELECT winner.competitionId, winner.eventId, winner.personName, round(winner.worst/100, 2) worst, 100*winner.worst/others.best percent
FROM
(SELECT competitionId, eventId, personName, greatest(value1,value2,value3,value4,value5) worst FROM Results WHERE roundId in ('f','c') AND pos=1) winner,
(SELECT competitionId, eventId, min(best) best FROM Results WHERE roundId in ('f','c') AND pos>1 AND best>0 GROUP BY competitionId, eventId) others
WHERE winner.competitionId = others.competitionId
AND winner.eventId = others.eventId
ORDER BY worst/best
LIMIT 100

cubeninjaIV · Dec 1, 2013

How many people have finished in the top 3 of an event without completing an average?

EDIT: excluding BLD and FMC because that would result in a rather large list...

Stefan · Dec 2, 2013

How many WRs were set by each continent's citizens?

CitizensOf WRs
-----------------------
Europe 317
Asia 140
North America 110
Oceania 60 <= 59 of these by Faz
Africa 0
South America 0

SELECT continentId CitizensOf, sum((regionalSingleRecord='WR')+(regionalAverageRecord='WR')) WRs
FROM Results, Countries
WHERE Countries.id = countryId
GROUP BY continentId
ORDER BY WRs desc;

How many WRs were set in each continent?

CompetitionsIn WRs
-----------------------
Europe 302
North America 153
Asia 121 <= 9 of these by Faz
Oceania 51 <= 50 of these by Faz
Africa 0
South America 0

SELECT continentId CompetitionsIn, sum((regionalSingleRecord='WR')+(regionalAverageRecord='WR')) WRs
FROM Results, Competitions, Countries
WHERE Competitions.id = competitionId
AND Countries.id = Competitions.countryId
GROUP BY continentId
ORDER BY WRs desc;

But looks like South America is getting one now:
http://cubecomps.com/live.php?cid=330&cat=14&rnd=1
Thanks to EMI94100 for noticing.

Stefan · Dec 2, 2013

WC 2013 was terrible competition for Feliks. Second-most attempts for him, but not a single WR!

[TABLE="class:grid,align:left"]
[TR][TD]competitionId[/TD][TD]attempts[/TD][TD]WRs[/TD][/TR]
[TR][TD]WC2011[/TD][TD="align:right"]144[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]WC2013[/TD][TD="align:right"]139[/TD][TD="align:right"]0[/TD][/TR]
[TR][TD]AustralianNationals2011[/TD][TD="align:right"]131[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]MelbourneSummer2011[/TD][TD="align:right"]130[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]AustralianNationals2013[/TD][TD="align:right"]111[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]AustralianNationals2012[/TD][TD="align:right"]103[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]AustralianNationals2010[/TD][TD="align:right"]103[/TD][TD="align:right"]3[/TD][/TR]
[TR][TD]AsianChampionship2010[/TD][TD="align:right"]96[/TD][TD="align:right"]3[/TD][/TR]
[TR][TD]MelbourneWinterOpen2011[/TD][TD="align:right"]81[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]MelbourneWinterOpen2010[/TD][TD="align:right"]78[/TD][TD="align:right"]0[/TD][/TR]
[TR][TD]MelbourneCubeDay2012[/TD][TD="align:right"]71[/TD][TD="align:right"]1[/TD][/TR]
[TR][TD]SheppartonWinter2013[/TD][TD="align:right"]65[/TD][TD="align:right"]1[/TD][/TR]
[TR][TD]MelbourneCubeDay2010[/TD][TD="align:right"]61[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]MelbourneCubeDay2013[/TD][TD="align:right"]61[/TD][TD="align:right"]3[/TD][/TR]
[TR][TD]NewZealand2010[/TD][TD="align:right"]57[/TD][TD="align:right"]2[/TD][/TR]
[TR][TD]KubarooOpen2011[/TD][TD="align:right"]53[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]MelbourneSummerOpen2010[/TD][TD="align:right"]53[/TD][TD="align:right"]2[/TD][/TR]
[TR][TD]MelbourneSummer2012[/TD][TD="align:right"]45[/TD][TD="align:right"]2[/TD][/TR]
[TR][TD]NewZealandChamps2009[/TD][TD="align:right"]43[/TD][TD="align:right"]0[/TD][/TR]
[TR][TD]MelbourneCubeDay2011[/TD][TD="align:right"]30[/TD][TD="align:right"]0[/TD][/TR]
[TR][TD]CupcakeCubing2013[/TD][TD="align:right"]30[/TD][TD="align:right"]0[/TD][/TR]
[/TABLE]

SELECT competitionId,
sum((value1<>0)+(value2<>0)+(value3<>0)+(value4<>0)+(value5<>0)) attempts,
sum((regionalSingleRecord='WR')+(regionalAverageRecord='WR')) WRs
FROM Results
WHERE personId = '2009ZEMD01'
GROUP BY competitionId
ORDER BY attempts desc, WRs desc

antoineccantin · Dec 2, 2013

Stefan said:
WC 2013 was terrible competition for Feliks. Second-most attempts for him, but not a single WR!

[TABLE="class:grid,align:left"]
[TR][TD]competitionId[/TD][TD]attempts[/TD][TD]WRs[/TD][/TR]
[TR][TD]WC2011[/TD][TD="align:right"]144[/TD][TD="align:right"]6[/TD][/TR]
[TR][TD]WC2013[/TD][TD="align:right"]139[/TD][TD="align:right"]0[/TD][/TR]
[TR][TD]AustralianNationals2011[/TD][TD="align:right"]131[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]MelbourneSummer2011[/TD][TD="align:right"]130[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]AustralianNationals2013[/TD][TD="align:right"]111[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]AustralianNationals2012[/TD][TD="align:right"]103[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]AustralianNationals2010[/TD][TD="align:right"]103[/TD][TD="align:right"]3[/TD][/TR]
[TR][TD]AsianChampionship2010[/TD][TD="align:right"]96[/TD][TD="align:right"]3[/TD][/TR]
[TR][TD]MelbourneWinterOpen2011[/TD][TD="align:right"]81[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD]MelbourneWinterOpen2010[/TD][TD="align:right"]78[/TD][TD="align:right"]0[/TD][/TR]
[TR][TD]MelbourneCubeDay2012[/TD][TD="align:right"]71[/TD][TD="align:right"]1[/TD][/TR]
[TR][TD]SheppartonWinter2013[/TD][TD="align:right"]65[/TD][TD="align:right"]1[/TD][/TR]
[TR][TD]MelbourneCubeDay2010[/TD][TD="align:right"]61[/TD][TD="align:right"]7[/TD][/TR]
[TR][TD]MelbourneCubeDay2013[/TD][TD="align:right"]61[/TD][TD="align:right"]3[/TD][/TR]
[TR][TD]NewZealand2010[/TD][TD="align:right"]57[/TD][TD="align:right"]2[/TD][/TR]
[TR][TD]KubarooOpen2011[/TD][TD="align:right"]53[/TD][TD="align:right"]5[/TD][/TR]
[TR][TD]MelbourneSummerOpen2010[/TD][TD="align:right"]53[/TD][TD="align:right"]2[/TD][/TR]
[TR][TD]MelbourneSummer2012[/TD][TD="align:right"]45[/TD][TD="align:right"]2[/TD][/TR]
[TR][TD]NewZealandChamps2009[/TD][TD="align:right"]43[/TD][TD="align:right"]0[/TD][/TR]
[TR][TD]MelbourneCubeDay2011[/TD][TD="align:right"]30[/TD][TD="align:right"]0[/TD][/TR]
[TR][TD]CupcakeCubing2013[/TD][TD="align:right"]30[/TD][TD="align:right"]0[/TD][/TR]
[/TABLE]

SELECT competitionId,
sum((value1<>0)+(value2<>0)+(value3<>0)+(value4<>0)+(value5<>0)) attempts,
sum((regionalSingleRecord='WR')+(regionalAverageRecord='WR')) WRs
FROM Results
WHERE personId = '2009ZEMD01'
GROUP BY competitionId
ORDER BY attempts desc, WRs desc

He didn't get any average World Records either!

Stefan · Dec 2, 2013

antoineccantin said:
He didn't get any average World Records either!

Darn, took me like 15 seconds to understand. And double darn for the unintentional ambiguity.

2012PENG05 · Dec 3, 2013

The 2012PENG05 is my WCA ID!It's funny!!haha

Tim Major · Dec 3, 2013

NA has 5800+ competitors and Australia has 250- competitors so that needs to be considered when comparing NA to Australia. How about world record holders per region, as a ratio. Australia has 2 and 250- competitors for example, NA (very rough guess) 50 and 5800.

ryanj92 · Dec 3, 2013

Turns out I'm the only clock solver with a sub-8 average that doesn't also have a sub-7 single (in that average or any other)... Need to fix that

whauk · Dec 3, 2013

is there someone who won in every official event at least once in his whole cubing career? if not, who has won the most distinct official events at least once?

in case you don't understand what i mean: i already won OH (and some other events) at competitions but i never won clock, so i do not qualify for this.

my guesses for people being pretty good at this: erik, antoine, conny, faz, daniel sheppard

TDM · Dec 3, 2013

whauk said:
faz

hasn't done feet.

antoineccantin · Dec 3, 2013

whauk said:
is there someone who won in every official event at least once in his whole cubing career? if not, who has won the most distinct official events at least once?

in case you don't understand what i mean: i already won OH (and some other events) at competitions but i never won clock, so i do not qualify for this.

my guesses for people being pretty good at this: erik, antoine, conny, faz, daniel sheppard

I've only ever won 2x2, OH, BLD, mega, 5x5, Clock, feet, magic, mmagic :/

and only 2x2, BLD since last weekend.

Mollerz · Dec 4, 2013

Yeah Daniel has, Northern Irish Open helped a little bit...

Noahaha · Dec 4, 2013

Tim Sun

Evan Liu · Dec 4, 2013

kinch2002 said:
This should keep you guys happy for a while

DNFs do not count as wins/podiums.
Magic/MMagic results are not included

The post I have quoted above has relevant statistics, though it is 8 months old. I don't think anyone new has joined the won-all-events club.

@Noah, Tim hasn't won 6x6.

Noahaha · Dec 4, 2013

Evan Liu said:
@Noah, Tim hasn't won 6x6.

Huh... He told me he had won every event.

EDIT: He never told me that.

Mikel · Dec 4, 2013

[TABLE="class:grid,align:left"]
[TR][TD] Competitor [/TD][TD] Country [/TD][TD] Number of solves [/TD][TD] % of total [/TD][TD] Best Solve [/TD][/TR]
[TR][TD] Mike Hughey [/TD][TD] USA [/TD][TD] 20 [/TD][TD] 34.48 [/TD][TD] 12:29.00 [/TD][/TR]
[TR][TD] Chris Hardwick [/TD][TD] USA [/TD][TD] 14 [/TD][TD] 24.14 [/TD][TD] 12:59.00 [/TD][/TR]
[TR][TD] Corey Sakowski [/TD][TD] USA [/TD][TD] 3 [/TD][TD] 5.17 [/TD][TD] 14:24.00 [/TD][/TR]
[TR][TD] Gabriel Alejandro Orozco Casillas [/TD][TD] Mexico [/TD][TD] 3 [/TD][TD] 5.17 [/TD][TD] 15:47.00 [/TD][/TR]
[TR][TD] Dan Sarnelli [/TD][TD] USA [/TD][TD] 3 [/TD][TD] 5.17 [/TD][TD] 27:15.00 [/TD][/TR]
[TR][TD] Julian David [/TD][TD] Canada [/TD][TD] 2 [/TD][TD] 3.45 [/TD][TD] 14:17.00 [/TD][/TR]
[TR][TD] Timothy Sun [/TD][TD] USA [/TD][TD] 2 [/TD][TD] 3.45 [/TD][TD] 15:02.00 [/TD][/TR]
[TR][TD] Brandon Mikel [/TD][TD] USA [/TD][TD] 2 [/TD][TD] 3.45 [/TD][TD] 18:46.00 [/TD][/TR]
[TR][TD] Tim Reynolds [/TD][TD] USA [/TD][TD] 2 [/TD][TD] 3.45 [/TD][TD] 24:15.00 [/TD][/TR]
[TR][TD] Daniel Beyer [/TD][TD] USA [/TD][TD] 2 [/TD][TD] 3.45 [/TD][TD] 25:53.00 [/TD][/TR]
[TR][TD] Nick Vu [/TD][TD] USA [/TD][TD] 2 [/TD][TD] 3.45 [/TD][TD] 27:26.00 [/TD][/TR]
[TR][TD] Angel Lim [/TD][TD] USA [/TD][TD] 1 [/TD][TD] 1.72 [/TD][TD] 24:46.00 [/TD][/TR]
[TR][TD] Jonathan Cookmeyer [/TD][TD] USA [/TD][TD] 1 [/TD][TD] 1.72 [/TD][TD] 27:20.00 [/TD][/TR]
[TR][TD] Anthony Hsu [/TD][TD] USA [/TD][TD] 1 [/TD][TD] 1.72 [/TD][TD] 33:14.00 [/TD][/TR] [/TABLE]

[TABLE="class:grid,align:left"]
[TR][TD] Country [/TD][TD] Number of competitors [/TD][TD] NR [/TD][TD] NR competitor [/TD][/TR]
[TR][TD] China [/TD][TD] 12 [/TD][TD] 11:46.00 [/TD][TD] Kun Zhu [/TD][/TR]
[TR][TD] Indonesia [/TD][TD] 12 [/TD][TD] 12:12.00 [/TD][TD] Ragil Setyadi [/TD][/TR]
[TR][TD] USA [/TD][TD] 12 [/TD][TD] 12:29.00 [/TD][TD] Mike Hughey [/TD][/TR]
[TR][TD] Germany [/TD][TD] 9 [/TD][TD] 12:35.00 [/TD][TD] Andreas Pohl [/TD][/TR]
[TR][TD] Japan [/TD][TD] 7 [/TD][TD] 15:37.00 [/TD][TD] Yuhei Takagi [/TD][/TR]
[TR][TD] Sweden [/TD][TD] 5 [/TD][TD] 16:15.00 [/TD][TD] Mats Bergsten [/TD][/TR]
[TR][TD] Russia [/TD][TD] 5 [/TD][TD] 07:09.03 [/TD][TD] Roman Strakhov [/TD][/TR]
[TR][TD] Hungary [/TD][TD] 4 [/TD][TD] 06:06.41 [/TD][TD] Marcell Endrey [/TD][/TR]
[TR][TD] United Kingdom [/TD][TD] 3 [/TD][TD] 06:41.94 [/TD][TD] Oliver Frost [/TD][/TR]
[TR][TD] Poland [/TD][TD] 3 [/TD][TD] 07:39.54 [/TD][TD] Grzegorz Jałocha [/TD][/TR]
[TR][TD] Italy [/TD][TD] 3 [/TD][TD] 11:22.00 [/TD][TD] Matteo Colombo [/TD][/TR]
[TR][TD] Australia [/TD][TD] 2 [/TD][TD] 08:26.37 [/TD][TD] Zane Carney [/TD][/TR]
[TR][TD] Malaysia [/TD][TD] 2 [/TD][TD] 14:24.00 [/TD][TD] Chester Lian [/TD][/TR]
[TR][TD] France [/TD][TD] 2 [/TD][TD] 14:36.00 [/TD][TD] François Courtès [/TD][/TR]
[TR][TD] Denmark [/TD][TD] 2 [/TD][TD] 14:44.00 [/TD][TD] Lars Vennike Nielsson [/TD][/TR]
[TR][TD] India [/TD][TD] 2 [/TD][TD] 28:57.00 [/TD][TD] Nikhil Mande [/TD][/TR]
[TR][TD] Finland [/TD][TD] 1 [/TD][TD] 09:48.58 [/TD][TD] Ville Seppänen [/TD][/TR]
[TR][TD] Austria [/TD][TD] 1 [/TD][TD] 12:04.00 [/TD][TD] Jakob Kogler [/TD][/TR]
[TR][TD] Canada [/TD][TD] 1 [/TD][TD] 14:17.00 [/TD][TD] Julian David [/TD][/TR]
[TR][TD] Mexico [/TD][TD] 1 [/TD][TD] 14:47.00 [/TD][TD] Gabriel Alejandro Orozco Casillas [/TD][/TR]
[TR][TD] Czech Republic [/TD][TD] 1 [/TD][TD] 15:42.00 [/TD][TD] Vojtěch Dvořák [/TD][/TR]
[TR][TD] Netherlands [/TD][TD] 1 [/TD][TD] 27:18.00 [/TD][TD] Maarten Smit [/TD][/TR]
[TR][TD] Brazil [/TD][TD] 1 [/TD][TD] 28:05.00 [/TD][TD] Walter Pereira Rodrigues de Souza [/TD][/TR]
[TR][TD] Taiwan [/TD][TD] 1 [/TD][TD] 28:34.00 [/TD][TD] Mao-te Hsieh [/TD][/TR]
[TR][TD] Latvia [/TD][TD] 1 [/TD][TD] 37:51.00 [/TD][TD] Arvis Tilgalis [/TD][/TR]
[TR][TD] Spain [/TD][TD] 1 [/TD][TD] 53:17.00 [/TD][TD] Diego Millán Otón [/TD][/TR] [/TABLE]

Tim Reynolds · Dec 4, 2013

whauk said:
is there someone who won in every official event at least once in his whole cubing career? if not, who has won the most distinct official events at least once?

in case you don't understand what i mean: i already won OH (and some other events) at competitions but i never won clock, so i do not qualify for this.

my guesses for people being pretty good at this: erik, antoine, conny, faz, daniel sheppard

(only counting current events)

Code:

2008BARA01	Bence Barát		17
2009SHEP01	Daniel Sheppard		17
2008WEST02	Simon Westlund		16
2009ZEMD01	Feliks Zemdegs		16
2007SUNT01	Timothy Sun		16
2006ORLA01	Bernett Orlando		15
2008AURO01	Sébastien Auroux	15
2005AKKE01	Erik Akkersdijk		15
2005BATI01	Milán Baticz		14
2011CHAP01	José Leonardo Chaparro Prieto 14
2007GUIM01	Pedro Santos Guimarães	14
2006BUUS01	Henrik Buus Aagaard	14
2010BREC01	John Brechon		14
2004KRIG01	Gunnar Krig		13
2007YUNQ01	Yunqi Ouyang (欧阳韵奇)	13
2007COHE01	Dan Cohen		13
2007NAKA03	Yu Nakajima (中島悠)	12
2010GARC02	Carlos Méndez García-Barroso 12
2010BENT01	Jan Bentlage		12
2007CINO01	Rafael Werneck Cinoto	12

SQL:

Code:

SELECT personId, personName, COUNT( DISTINCT eventId ) 
FROM Results
WHERE roundId
IN (
"c",  "f"
)
AND pos =1
AND best >0
AND eventId NOT 
IN (
"333mbo",  "magic",  "mmagic"
)
GROUP BY 1 
ORDER BY 3 DESC 
LIMIT 0 , 30

TDM · Dec 4, 2013

How many people have won an event every time they've done it?

uberCuber · Dec 4, 2013

TDM said:
How many people have won an event every time they've done it?

Might want to add a minimum number of times they have to have competed, otherwise you'll probably have a pretty large amount people who have won an event the one and only time they competed in it (like my MultiBLD).

Odd WCA stats/ Stats request Thread

Legend

Regular

Legend

Legend

Legend

Legend

Member

Platinum Member

Veteran

Veteran

Legend

Legend

Swag Overlord

blindmod

Veteran

blindmod

Premium Member

Premium Member

Legend

Legend

Similar threads