Odd WCA stats/ Stats request Thread

[ilikecubing]

Whoa...why does your WCAID not follow convention?

Its because I had a name change

[Pro94]

We had 4 WRs this weekend in 3 different competitions, all in Europe (5 if we consider 3x3 Best Podium).
Has this already happened?

[blakedacuber]

Most national records brOken by a single person at 1 competition in the last 3 years?

[Coolster01]

I was wondering if i am the world's youngest 4x4 BLDer which i will do at nationals. I am reaaally close for 4x4 and am sure to get it next weekend, considering it's pretty easy for me. For 5x5 BLD, i just need an inner edges parity algorithm. Im the 8th youngest for normal BLD (yes, done at Hillsdale Winter 2012). Please answer. Thanks!
Edit: Sorry I'm new to speedsolving so I obviously multi posted way too much :P

[pdilla]

Age?

[ben1996123]

It depends how old you are.

[RNewms27]

He is somewhere between 10 and 11.

[drewsopchak]

Your constitution must be admirable to be big cube blding at your age.

[Coolster01]

Age?

Oh whoops, i am 10 years 8 months and 8 days old as of April 17

Oh by the way check out my video on my youtube channel of mu BLD solve. I cant get the link because I'm on an iPad

Your constitution must be admirable to be big cube blding at your age.

This is probably the only thing I'll ever accomplish in life that isnt fun but i had to push myself LOL. Eventually big cubes BLD will be fun

[ardi4nto]

Request for list of top 10 ppl with biggest difference between their 4x4 single and average

Hi Ayush,

Here it is,

+----------+----------+------------+----------------------------+------------+-----------------+
| pbAvg    | pbSgl    | difference | personName                 | personId   | personCountryId |
+----------+----------+------------+----------------------------+------------+-----------------+
| 422.4800 | 195.6100 |   226.8700 | Kenn-Eerik Kannike         | 2009KANN01 | Estonia         |
| 412.4900 | 206.6500 |   205.8400 | Aman Agrawal               | 2012AGRA01 | India           |
| 322.2900 | 133.3800 |   188.9100 | Marine Asalia              | 2009ASAL01 | India           |
| 468.9800 | 292.3400 |   176.6400 | Saarthi Bhatia             | 2009BHAT02 | India           |
| 375.8900 | 203.7200 |   172.1700 | Indrek J├Áe                | 2009JOEI01 | Estonia         |
| 335.5800 | 175.5700 |   160.0100 | Dariusz Peta               | 2005PETA01 | Poland          |
| 332.6100 | 173.7200 |   158.8900 | Eduardo González Parra    | 2011PARR03 | Mexico          |
| 337.4900 | 180.3800 |   157.1100 | Krzysztof Boryczko         | 2005BORY01 | Poland          |
| 317.9600 | 161.3000 |   156.6600 | Rebecca Hughey             | 2007HUGH04 | USA             |
| 369.9200 | 219.0800 |   150.8400 | Patrick Garcin             | 2008GARC05 | France          |
+----------+----------+------------+----------------------------+------------+-----------------+

Based on Stefan's code few pages before.

SELECT pbAvg, pbSgl, pbAvg-pbSgl difference, personName, personId, personCountryId
FROM (SELECT min(if(average>0,average/100.00,1111111111)) AS pbAvg, min(if(best>0,best/100.00,1111111111)) AS pbSgl, personName, personId, personCountryId
FROM results
WHERE eventId = '444'
GROUP BY personId) helper
WHERE pbAvg<1111111111 AND pbSgl<1111111111
ORDER BY difference DESC
LIMIT 10

For the smallest difference:

+---------+---------+------------+-------------------------------------------------+------------+-----------------+
| pbAvg   | pbSgl   | difference | personName                                      | personId   | personCountryId |
+---------+---------+------------+-------------------------------------------------+------------+-----------------+
| 80.6600 | 80.1900 |     0.4700 | Muhammad Bintang Assyidik                       | 2010ASSY01 | Indonesia       |
| 57.4400 | 56.7200 |     0.7200 | Erwan Kohler                                    | 2010KOHL02 | Switzerland     |
| 66.0700 | 64.7700 |     1.3000 | Yukiko Makino (þëºÚçÄþö▒Õ©îÕ¡É)                 | 2007MAKI01 | Japan           |
| 74.8800 | 73.5600 |     1.3200 | Mateusz Burnicki                                | 2006BURN01 | Poland          |
| 75.6500 | 74.2800 |     1.3700 | Zijing Jin (ÚçæÕ¡ÉÚØû)                          | 2011JINZ01 | China           |
| 70.9700 | 69.5600 |     1.4100 | Sakai Taisyu (ÕØéõ║òÕñºÕæ¿)                     | 2012TAIS01 | Japan           |
| 82.0000 | 80.5600 |     1.4400 | Bo-Zhou Xiao                                    | 2009XIAO01 | Taiwan          |
| 59.6600 | 58.1600 |     1.5000 | Dakota Allen Harris                             | 2008HARR03 | USA             |
| 58.7200 | 57.1500 |     1.5700 | Julian David                                    | 2010DAVI06 | Canada          |
| 51.6800 | 50.0200 |     1.6600 | Marcin Zalewski                                 | 2011ZALE02 | Poland          |
+---------+---------+------------+-------------------------------------------------+------------+-----------------+