Sajwo
Member
What is the WCA id with the biggest number at the end?
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.
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.
Not exactly. "Hu Chen" got a 2015CHEH ID by the end of 2015, while "Yu Chen" got a 2015CHEY ID.
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!
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!
select count(distinct personId) from Results where CompetitionId="FMCEurope2015";
How about this:
Code:select count(distinct personId) from Results where CompetitionId="FMCEurope2015";
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?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
Which competitor requires the fewest characters entered into the search function to be the only result?
https://www.worldcubeassociation.org/results/p.php?i=2013DOVB01Which competitor requires the fewest characters entered into the search function to be the only result?