Odd WCA stats/ Stats request Thread

[Sajwo]

What is the WCA id with the biggest number at the end?

 

[guysensei1]

What is the WCA id with the biggest number at the end?

99.
try searching for WANG

it would have gone above 99 but they changed the ID system to account for that.

 

[Sajwo]

99.
try searching for WANG

it would have gone above 99 but they changed the ID system to account for that.

thanks

 

[Isaac Lai]

What is the WCA id with the biggest number at the end?

Chen too. 2015 had more than 100 Chens, so the 100th (and so on) was changed to Cheh in their ids.

 

[Sebastien]

Chen too. 2015 had more than 100 Chens, so the 100th (and so on) was changed to Cheh in their ids.

Not exactly. "Hu Chen" got a 2015CHEH ID by the end of 2015, while "Yu Chen" got a 2015CHEY ID.

 

[Isaac Lai]

Not exactly. "Hu Chen" got a 2015CHEH ID by the end of 2015, while "Yu Chen" got a 2015CHEY ID.

My bad. The last letter was changed to the first letter of their name.

 

[Ninja Storm]

Not sure if this is the place to ask, but does anybody in here know how to get the number of competitors from a competition using MySQL? I'm trying to get into answering people's requests on reddit (and here too if anybody starts asking,) but I don't know how to pull total competitors. Thanks!

 

[Calode]

Not sure if this is the place to ask, but does anybody in here know how to get the number of competitors from a competition using MySQL? I'm trying to get into answering people's requests on reddit (and here too if anybody starts asking,) but I don't know how to pull total competitors. Thanks!

Couldn't you grab all the results where comp = compid and count the length of the results?

 

[bubbagrub]

Not sure if this is the place to ask, but does anybody in here know how to get the number of competitors from a competition using MySQL? I'm trying to get into answering people's requests on reddit (and here too if anybody starts asking,) but I don't know how to pull total competitors. Thanks!

How about this:

select count(distinct personId) from Results where CompetitionId="FMCEurope2015";

 

[Ninja Storm]

How about this:

select count(distinct personId) from Results where CompetitionId="FMCEurope2015";

Thanks so much!

 

[hamfaceman]

It'd be interesting to see what the fastest counting solve is for each event. I know that Faz has had a counting 5 two times.

 

[APdRF]

What's the most points someone has in mbld without a single bld solve? Sandra Novales Peláez got 13 points yesterday and still no single solve. Also, she only failed a cube in her mbld because she undid parity on the last cube

 

[Lid]

What's the most points someone has in mbld without a single bld solve? Sandra Novales Peláez got 13 points yesterday and still no single solve. Also, she only failed a cube in her mbld because she undid parity on the last cube

Latest export gives: Sainuddin, m, Indonesia 5/5 32:57

 

[APdRF]

Wow, it seems she has a wr Hahahaha

 

[CyanSandwich]

What's the most points someone has in mbld without a single bld solve? Sandra Novales Peláez got 13 points yesterday and still no single solve. Also, she only failed a cube in her mbld because she undid parity on the last cube

Damn that's insane. Does she rush all her 3BLD attempts?

 

[moralsh]

She rushes everything, including her attempts. I'm telling her to slow down a bit.

She memorized the 15 cubes in 18 minutes.

 

[supercavitation]

Which competitor requires the fewest characters entered into the search function to be the only result?

 

[Cale S]

Which competitor requires the fewest characters entered into the search function to be the only result?

4 characters is an upper bound, zymk

Edit: 3 characters, ykt

 

[AlexMaass]

Which competitor requires the fewest characters entered into the search function to be the only result?

https://www.worldcubeassociation.org/results/p.php?i=2013DOVB01
vb
x then another letter (and the other way around) had sooo many 2 results

 

[DGCubes]

This has probably been asked before, but what is the most events anyone has competed in who has not competed in 3x3?