Odd WCA stats/ Stats request Thread

Discussion in 'General Speedcubing Discussion' started by anders, Dec 15, 2010.

Welcome to the Speedsolving.com. You are currently viewing our boards as a guest which gives you limited access to join discussions and access our other features. By joining our free community of over 30,000 people, you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact us and we'll help you get started. We look forward to seeing you on the forums!

Already a member? Login to stop seeing this message.
  1. 4.

    4. Guest

    No, I think he lives in Norway. There haven't been any competitions here in Iceland.... ever.
     
  2. Stefan

    Stefan Member

    7,268
    16
    May 7, 2006
    WCA:
    2003POCH01
    YouTube:
    StefanPochmann
  3. Pendragon

    Pendragon Member

    13
    0
    Dec 10, 2010
    Ottobiano, Italy
    WCA:
    2010PAUL02
    YouTube:
    ZanteF12R
    does exist a ranking of female results?
     
  4. JackJ

    JackJ Member

    862
    4
    Nov 25, 2009
    Whitewater, WI
    WCA:
    2009JOHN05
    YouTube:
    JackTheCuber
  5. @uguste

    @uguste Member

    92
    0
    Feb 6, 2010
    Marseille, France
    WCA:
    2010OLIV01
  6. Hippolyte!!!

    Hippolyte!!! Member

    116
    0
    Apr 24, 2010
    WCA:
    2008MORE02
    I am 2nd worst master magic AVERAGE!!!
    (someone shows me how to solve the master magic just before the event, so I solve just one before my official average.^^
    And my best is 35 seconds better than my average:p)
     
  7. Stefan

    Stefan Member

    7,268
    16
    May 7, 2006
    WCA:
    2003POCH01
    YouTube:
    StefanPochmann
    Wow! Someone exists who is the third worst in something! Unbelievable! That's so odd! It really belongs in this thread!
     
  8. Hippolyte!!!

    Hippolyte!!! Member

    116
    0
    Apr 24, 2010
    WCA:
    2008MORE02
    Killjoy!:cool:
    We're just happy to be in the top world in something!
    (and maybe 45 average for master magic is a little odd^^:p)
     
    Last edited: Dec 29, 2010
  9. Evan Liu

    Evan Liu Member

    922
    106
    Jul 15, 2009
    WCA:
    2009LIUE01
    YouTube:
    channel/UC9ZlPB5lZmX4byumwK1FrHA
    http://5x5x5.net/jscc/events.php

    As Ron says on the WCA Forum,
    "Unofficial, not always 100% up-to-date, but good quality."
     
  10. If someone did this, I'd love them forever. <3

    EDIT: Just looked at the link. I'm #2 for the US female 2x2 AVG. :). I just need sub 5 (EASY) at comp next time!
     
    Last edited: Dec 29, 2010
  11. qqwref

    qqwref Member

    7,828
    27
    Dec 18, 2007
    a <script> tag near you
    WCA:
    2006GOTT01
    YouTube:
    qqwref2
  12. Carrot

    Carrot Member

    1,910
    8
    Feb 9, 2009
    WCA:
    2008ANDE02
    YouTube:
    Minxer2011
  13. Slash

    Slash Member

    293
    0
    Mar 27, 2009
    Budapest, Hungary
    WCA:
    2008TROM01
    YouTube:
    deokeone
  14. bobthegiraffemonkey

    bobthegiraffemonkey Member

    1,345
    111
    Apr 23, 2010
    Scotland, UK
    WCA:
    2009SHEE01
    YouTube:
    bobthegiraffemonkey
    Breandan has an interesting one, compare 3x3 and 2x2 times (he told me he doesn't like 2x2 much).
     
  15. Tim Reynolds

    Tim Reynolds Premium Member

    995
    34
    Jun 28, 2006
    Boston, MA
    WCA:
    2005REYN01
    YouTube:
    timbreynolds
    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)
     
  16. Lucas Garron

    Lucas Garron Super-Duper Moderator Staff Member

    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: Dec 29, 2010
  17. Tim Reynolds

    Tim Reynolds Premium Member

    995
    34
    Jun 28, 2006
    Boston, MA
    WCA:
    2005REYN01
    YouTube:
    timbreynolds
    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
    
     
  18. Evan Liu

    Evan Liu Member

    922
    106
    Jul 15, 2009
    WCA:
    2009LIUE01
    YouTube:
    channel/UC9ZlPB5lZmX4byumwK1FrHA
    From the Euro 2010 thread:
    (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.
     
  19. Tim Reynolds

    Tim Reynolds Premium Member

    995
    34
    Jun 28, 2006
    Boston, MA
    WCA:
    2005REYN01
    YouTube:
    timbreynolds
    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: Dec 29, 2010
  20. keemy

    keemy Member

    151
    0
    Dec 29, 2007
    WCA:
    2006CORR01
    Yay slow people!
     

Share This Page