• Welcome to the Speedsolving.com, home of the web's largest puzzle community!
    You are currently viewing our forum as a guest which gives you limited access to join discussions and access our other features.

    Registration is fast, simple and absolutely free so please, join our community of 30,000+ people from around the world today!

    If you are already a member, simply login to hide this message and begin participating in the community!

Odd WCA stats/ Stats request Thread

Joined
May 7, 2006
Messages
7,287
Likes
31
WCA
2003POCH01
YouTube
StefanPochmann
#42

Tim Reynolds

Premium Member
Joined
Jun 28, 2006
Messages
995
Likes
34
Location
Boston, MA
WCA
2005REYN01
YouTube
timbreynolds
#55
http://www.worldcubeassociation.org/results/p.php?i=2006MUHL01

Between one 3x3 round and the next, improved his 3x3 single by 20.31 seconds or 54.2%. Is this the best improvement for someone under a minute?
http://www.worldcubeassociation.org/results/p.php?i=2009SMIT03 is a bigger improvement.

http://www.worldcubeassociation.org/results/p.php?i=2007HESS01 has gotten 8.91 NAR twice, single and average. Anyone else get a regional record single and average with the same time? (same event)
 

Lucas Garron

Super-Duper Moderator
Staff member
Joined
Jul 6, 2007
Messages
3,549
Likes
70
Location
Where the rolling foothills rise
WCA
2006GARR01
YouTube
LucasGarron
#56
http://www.worldcubeassociation.org/results/p.php?i=2009SMIT03 is a bigger improvement.

http://www.worldcubeassociation.org/results/p.php?i=2007HESS01 has gotten 8.91 NAR twice, single and average. Anyone else get a regional record single and average with the same time? (same event)
http://www.worldcubeassociation.org/results/p.php?i=2006GARR01
13.55 NR single, 13.54 NR average here. :-/
In fact, I set 15.27 NR average and 13.54 NR average twice each. What's the most that anyone has set and tied a regional record?

My 2x2x2 PBs have been 5.xy, 4.xy, 3.xy, 2.xy, 1.xy. Apparently I can only beat it one more time without daylight savings. :p

I also like to tell people that being slow is no excuse not to compete; I started off with 1:02.27 single and 1:29 average, but I've made it low into the top 100. Anyone else who started off even slower officially? (The ultimate anti-faz. :p)
 
Last edited:

Tim Reynolds

Premium Member
Joined
Jun 28, 2006
Messages
995
Likes
34
Location
Boston, MA
WCA
2005REYN01
YouTube
timbreynolds
#57
http://www.worldcubeassociation.org/results/p.php?i=2006GARR01
13.55 NR single, 13.54 NR average here. :-/
In fact, I set 15.27 NR average and 13.54 NR average twice each. What's the most that anyone has set and tied a regional record?

My 2x2x2 PBs have been 5.xy, 4.xy, 3.xy, 2.xy, 1.xy. Apparently I can only beat it one more time without daylight savings. :p

I also like to tell people that being slow is no excuse not to compete; I started off with 1:02.27 single and 1:29 average, but I've made it low into the top 100. Anyone else who started off even slower officially? (The ultimate anti-faz. :p)
I'll work on your two questions now. In the mean time, here's the answer to my question:

SELECT s.personId, s.personName, s.countryId, s.eventId, a.average, s.regionalSingleRecord, s.competitionId, a.regionalAverageRecord, a.competitionId
FROM (

SELECT *
FROM Results
WHERE regionalSingleRecord LIKE "%R"
) AS s, (

SELECT *
FROM Results
WHERE regionalAverageRecord LIKE "%R"
) AS a
WHERE s.personId = a.personId
AND s.eventId = a.eventId
AND s.best = a.average
LIMIT 0 , 30

Code:
personId 	personName 		countryId 	eventId time 	single				average
2004KRIG01 	Gunnar Krig 		Sweden 		333 	1685 	NR 	SwedishOpen2005 	NR 	GermanOpen2007
2006ZAHR01 	Martin Zahradník 	Czech Republic 	333 	1676 	NR 	CzechOpen2007 		NR 	CzechOpen2008
2006BUUS01 	Henrik Buus Aagaard 	Denmark 	mmagic 	328 	NR 	SwedishOpen2007 	NR 	NorrkopingOpen2009
2007COHE01 	Dan Cohen 		USA 		minx 	8734 	NAR 	USOpen2008 		NAR 	USNationals2009
2008CHEN10 	Chio Wai Cheng 		Macau 		222 	555 	NR 	HongKongOpen2009 	NR 	GuangdongOpen2009
2008ZHAN06 	Haixu Zhang 		China 		444 	4491 	NR 	BeijingSummerOpen2009 	NR 	GuangdongOpen2009
2005CIAL02 	Lukasz Cialon 		Poland 		222 	328 	NR 	PolishOpen2007 		NR 	GrudziadzOpen2010
2009WANG13 	Yuxuan Wang 		China 		magic 	80 	NR 	ChangchunOpen2010 	WR 	NanjingSpringOpen2010
2009WANG13 	Yuxuan Wang 		China 		magic 	80 	NR 	NanjingSpringOpen2010 	WR 	NanjingSpringOpen2010
2008LIMR01 	Ranz Norwin Lim 	Philippines 	clock 	897 	NR 	BulacanOpen2010 	NR 	PhilippinesOpen2010
2009WANG13 	Yuxuan Wang 		China 		magic 	80 	NR 	ChangchunOpen2010 	WR 	BeijingNoCubes2010
2009WANG13 	Yuxuan Wang 		China 		magic 	80 	NR 	NanjingSpringOpen2010 	WR 	BeijingNoCubes2010
2010ARBO01 	Morten Arborg 		Norway 		222 	336 	NR 	KarlstadOpen2010 	NR 	SwedishCubedays2010
2007HESS01 	Rowe Hessler 		USA 		333 	891 	NAR 	NewarkOpen2008 		NAR 	LibertyScience2010
 
Joined
Jul 15, 2009
Messages
922
Likes
105
WCA
2009LIUE01
YouTube
channel/UC9ZlPB5lZmX4byumwK1FrHA
#58
Anyone else get a regional record single and average with the same time? (same event)
From the Euro 2010 thread:
The first ever UK sub-10 average is the same as the first ever UK sub-10 single :p
(Both were 9.90 - Robert got the single at UK Masters 2009, then Breandan got the average at Euro 2010)
Your post reminded me of this. :p
Not the same thing, but similar.
 

Tim Reynolds

Premium Member
Joined
Jun 28, 2006
Messages
995
Likes
34
Location
Boston, MA
WCA
2005REYN01
YouTube
timbreynolds
#59
Here's Lucas's two questions:

Everyone who has done both a sup-50 average and sub-15 average:
Code:
personId 	personName 			competitionId 		best 	average
2008WARL01 	Jackson Warley 			DenverOpen2008 		8713 	9013
2006GARR01 	Lucas Garron 			CaltechWinter2006 	6227 	8971
2006CORR01 	Devin Corr-Robinett 		CaltechSpring2006 	7188 	8592
2007KRIJ01 	Jacco Krijnen 			Netherlands2007 	6243 	7861
2007VALK01 	Mats Valk 			Netherlands2007 	5343 	7349
2009SMIT03 	Andy Smith 			FortLeeWinter2009 	5441 	6823
2009SALA01 	Jorge Leonardo Sánchez Salazar 	PueblaOpen2009 		5808 	6673
2009FLUG01 	Andres Flügel 			AachenOpen2009 		4636 	6538
2007LING01 	Alexander Lin 			CaltechWinter2007 	5234 	6098
2008BAOY01 	Ting Sheng Bao Yang	 	Spain2008 		4530 	5790
2008SOTO01 	Ignacio Soto Bustos 		MadridOpen2008 		3943 	5735
2007TAMA02 	John Tamanas 			RutgersSpring2007 	3975 	5699
2007NELS02 	Gavin Nelson 			PleasantvilleFall2007 	4516 	5666
2007WULE01 	Lebillie Wu 			BerkeleySpring2007 	4809 	5536
2008DANG01 	Bobby d'Angelo 			ArmonkSpring2008 	3864 	5086
2007CHRI03 	Tobias Christlieb 		Germany2007 		3700 	5028
2007FARE01 	Andreas Farenbruch 		Germany2007 		4356 	5007
Everyone who has repeated a regional single record (national, continental, or world--i don't care which)

Code:
personId 	personName 		eventId	best 	COUNT(1)
2009WANG13 	Yuxuan Wang 	 	magic 	72 	3
2007COOP01 	Charlie Cooper 		magic 	150 	3
2005OOMS01 	Alexander Ooms 		magic 	132 	3
2007KEZH01 	Zhulu Ke 		magic 	102 	2
2007KEZH01 	Zhulu Ke 		magic 	94 	2
2009BRAT01 	Abel Brata 		magic 	133 	2
2006BUUS01 	Henrik Buus Aagaard 	magic 	96 	2
2008AURO01 	Sébastien Auroux 	333fm 	27 	2
2006BUUS01 	Henrik Buus Aagaard 	magic 	106 	2
2006KUTI01 	Mátyás Kuti 		magic 	86 	2
2005AKKE01 	Erik Akkersdijk 	333fm 	26 	2
2010PERE01 	Isaias Andrés Sepúlveda Pérez 	mmagic 	265 	2
2006BUUS01 	Henrik Buus Aagaard 	magic 	93 	2
2008CHOI01 	Wonjun Choi 		magic 	196 	2
2008WONE01 	David Woner 		333fm 	27 	2
2009FUSH01 	Arifumi Fushimi 	magic 	90 	2
2010BORD01 	Szabolcs-László Bordás 	222 	538 	2
2009ZEMD01 	Feliks Zemdegs 		333fm 	32 	2
2009MACA01 	Matias Macaya 		magic 	105 	2
2005STIL01 	Peter Still 		magic 	291 	2
2009BALT02 	Leandro Baltazar 	magic 	111 	2
2008NUNE01 	Gabriel Eduardo Núñez Serna 	333fm 	46 	2
2009BAUM01 	Conor Baumann 		magic 	146 	2
2009MAGN02 	Hilmar Magnusson 	magic 	138 	2
2009MACA01 	Matias Macaya 		magic 	108 	2
2005VANH01 	Anssi Vanhala 		333 	1214 	2
2009KASU01 	Sanio Kasumovic 	mmagic 	258 	2
2003BURT01 	Bob Burton 		magic 	128 	2
2009KASU01 	Sanio Kasumovic 	magic 	119 	2
2007HIRA03 	Yoshiaki Hirayama 	magic 	90 	2
2005BOUC01 	Craig Bouchard 		magic 	118 	2
2010MOND01 	Pablo Nicolás Oshiro Mondoñedo 	magic 	153 	2
2009WANG13 	Yuxuan Wang 		magic 	80 	2
2003POCH01 	Stefan Pochmann 	333fm 	39 	2
2008BRAN01 	Filippo Brancaleoni 	magic 	105 	2
2007NAKA03 	Yu Nakajima 		333 	872 	2
2004GALL02 	Clément Gallet 		mmagic 	390 	2
and average:

Code:
personId 	personName 		eventId average COUNT( 1 )
2003VAND01 	Lars Vandenbergh 	222 	591 	2
2006GARR01 	Lucas Garron 		333 	1523 	2
2009WANG13 	Yuxuan Wang 		magic 	80 	2
2005LIAO01 	Warren Liao 		333 	2048 	2
2006BUUS01 	Henrik Buus Aagaard 	magic 	109 	2
2005BATI01 	Milán Baticz 		333 	1129 	2
2006BUUS01 	Henrik Buus Aagaard 	mmagic 	368 	2
2006GARR01 	Lucas Garron 		333 	1354 	2
2007SUNT01 	Timothy Sun 		magic 	112 	2
2005AKKE01 	Erik Akkersdijk 	333 	1049 	2
So there have been magic single records gotten 3 times, but no averages gotten more than twice.

Related to this, Lars Vandenbergh has gotten 16.31 and 16.62 3x3 averages four times each, Tomasz has gotten 11.37 four times, and Clement's gotten 1.92 magic average four times.
 
Last edited:
Top