Stefan
Member
That's a good one. Someone please check this independently, though. I did single and average separately, seemed easiest.
Using data from WCA_export468_20140908 and Stefan's WCA statistics tools.
| Cuber | Faster | Time | Slower | Time |
| Haiyan Zhuang (庄海燕) | 3x3 blindfolded | 30.94 | Rubik's Cube | 33.69 |
| Oliver Frost | 3x3 blindfolded | 38.12 | Skewb | 1:01.78 |
| Mats Kollbrink | 3x3 with feet | 48.84 | 3x3 one-handed | 57.96 |
| Denys Lazarenko (Денис Лазаренко) | 4x4 blindfolded | 5:11.84 | 5x5 Cube | 5:25.50 |
| Zheng Li (李政) | 5x5 Cube | 2:08.74 | Skewb | 4:07.94 |
| Vojtěch Dvořák | 5x5 blindfolded | 15:42.00 | 4x4 blindfolded | 19:32.00 |
| Xinye Wang (王鑫晔) | 6x6 Cube | 6:21.91 | 3x3 one-handed | 9:59.36 |
| Julio Martín Gómez Telésforo | 6x6 Cube | 8:33.91 | 4x4 Cube | 9:09.13 |
| Xinye Wang (王鑫晔) | 7x7 Cube | 8:38.22 | 3x3 one-handed | 9:59.36 |
| Vivek Prasad Mada | Megaminx | 4:08.44 | Rubik's Clock | 4:40.79 |
ALTER TABLE RanksSingle ADD INDEX person (personId ASC);
SELECT a.personId Cuber, a.eventId 'Faster', a.best 'Time', b.eventId 'Slower', b.best 'Time'
FROM RanksSingle a join RanksSingle b on a.personId = b.personId
WHERE a.best < b.best
GROUP BY a.eventId, b.eventId
HAVING count(*) = 1;
ALTER TABLE RanksSingle DROP INDEX person;
SELECT a.personId Cuber, a.eventId 'Faster', a.best 'Time', b.eventId 'Slower', b.best 'Time'
FROM RanksSingle a join RanksSingle b on a.personId = b.personId
WHERE a.best < b.best
GROUP BY a.eventId, b.eventId
HAVING count(*) = 1;
ALTER TABLE RanksSingle DROP INDEX person;
Using data from WCA_export468_20140908 and Stefan's WCA statistics tools.
| Cuber | Faster | Time | Slower | Time |
| Yudanis Taqwin Rohman | 3x3 blindfolded | 49.36 | Skewb | 52.66 |
| Mats Kollbrink | 3x3 with feet | 1:05.78 | 3x3 one-handed | 1:14.57 |
| Antonio Aguilera Manzano | 5x5 Cube | 2:12.55 | 3x3 one-handed | 2:15.01 |
| Yiliang Lu (路义亮) | 5x5 Cube | 2:46.00 | Rubik's Clock | 2:54.81 |
| Nguyễn Ngọc Thịnh | 5x5 Cube | 1:21.32 | Skewb | 1:53.70 |
| Nguyễn Ngọc Thịnh | Megaminx | 1:21.70 | Skewb | 1:53.70 |
ALTER TABLE RanksAverage ADD INDEX person (personId ASC);
SELECT a.personId Cuber, a.eventId 'Faster', a.best 'Time', b.eventId 'Slower', b.best 'Time'
FROM RanksAverage a join RanksAverage b on a.personId = b.personId
WHERE a.best < b.best
GROUP BY a.eventId, b.eventId
HAVING count(*) = 1;
ALTER TABLE RanksAverage DROP INDEX person;
SELECT a.personId Cuber, a.eventId 'Faster', a.best 'Time', b.eventId 'Slower', b.best 'Time'
FROM RanksAverage a join RanksAverage b on a.personId = b.personId
WHERE a.best < b.best
GROUP BY a.eventId, b.eventId
HAVING count(*) = 1;
ALTER TABLE RanksAverage DROP INDEX person;
Edit: Should I rename these statistics "Dude, what is wrong with you??"?
Last edited:
