| name |
minAvg |
| Max Park |
5.9700 |
| Feliks Zemdegs |
6.0280 |
| Patrick Ponce |
6.3360 |
| Seung Hyuk Nahm (남승혁) |
6.5020 |
| Philipp Weyer |
6.6080 |
| Kian Mansour |
6.6280 |
| Bill Wang |
6.6620 |
| Tanzer Balimtas |
6.6720 |
| Sebastian Weyer |
6.7820 |
| Mats Valk |
6.7840 |
| Kevin Gerhardt |
6.9060 |
| Dylan Miller |
6.9500 |
| Drew Brads |
6.9580 |
| Antoine Cantin |
7.0460 |
| Ciarán Beahan |
7.0560 |
| Kai-Wen Wang (王楷文) |
7.0700 |
| Jayden McNeill |
7.0820 |
| Lucas Etter |
7.0820 |
| Cornelius Dieckmann |
7.1020 |
| Jay Benedict Alfaras |
7.1420 |
| Hyeon Kyo Kyoung |
7.1640 |
| Alexandre Carlier |
7.1720 |
| Yi-Fan Wu (吳亦凡) |
7.1820 |
| Michał Pleskowicz |
7.1860 |
| Brian Johnson |
7.2580 |
| Danny SungIn Park |
7.2740 |
| Keaton Ellis |
7.3200 |
| Daniel Rose-Levine |
7.3220 |
| Tommy Kiprillis |
7.3340 |
| Zibo Xu (徐子博) |
7.3380 |
| Blake Thompson |
7.3560 |
| Kevin Costello III |
7.3600 |
| SeungBeom Cho (조승범) |
7.3840 |
| Antonie Paterakis |
7.3860 |
| Andy Denney |
7.4080 |
| Leon Schmidtchen |
7.4200 |
| Phillip Lewicki |
7.4240 |
| Collin Burns |
7.4280 |
| Mulun Yin (阴目仑) |
7.4280 |
| Carlos Méndez García-Barroso |
7.4400 |
| Dmitry Dobrjakov |
7.4420 |
| Michał Rzewuski |
7.4680 |
| Alexander Lau |
7.4980 |
| Christopher Yen |
7.5020 |
| Lukas Shelley |
7.5060 |
| Rami Sbahi |
7.5080 |
| Martin Vædele Egdal |
7.5480 |
| Dario Roa Sánchez |
7.5860 |
| Ivan Vynnyk (Іван Винник) |
7.5900 |
| Leo Borromeo |
7.5960 |
| Daniel Wannamaker |
7.5980 |
| Morten Arborg |
7.6160 |
| Jiayu Wang (王佳宇) |
7.6320 |
| Jules Desjardin |
7.6340 |
| Jonathan Hamstad |
7.6360 |
| Ujjawal Pabreja |
7.6500 |
| Vincent Wong |
7.6600 |
| Kennan LeJeune |
7.6600 |
| Reinier Schippers |
7.6680 |
| Aryan Chhabra |
7.6980 |
| Arifumi Fushimi (伏見有史) |
7.7060 |
| Yusheng Du (杜宇生) |
7.7240 |
| Mykyta Tytar (Микита Титарь) |
7.7360 |
| Juliette Sébastien |
7.7840 |
| Amod Mathur |
7.7940 |
| Luke Tycksen |
7.7980 |
| Kaijun Lin (林恺俊) |
7.8060 |
| Ping-Yueh Huang (黃品越) |
7.8060 |
| Richard Jay S. Apagar |
7.8260 |
| Natthaphat Mahtani (ณัฐภัทร จี มาทานี) |
7.8800 |
| Anthony Brooks |
7.8820 |
| Daniel Karnaukh |
7.8840 |
| Staš Zupanc |
7.8900 |
| Igor Ośmiałowski |
7.8940 |
| Kevin Hays |
7.9020 |
| Bautista Bonazzola |
7.9040 |
| Rowe Hessler |
7.9400 |
| Weixing Zhang (张炜星) |
7.9400 |
| Matty Hiroto Inaba |
7.9400 |
| Andrew Ricci |
7.9420 |
| Sean Belke |
7.9480 |
| Alex Johnson |
7.9480 |
| Jeff Park |
7.9500 |
| Daniel Gutierrez |
7.9520 |
| Dana Yi |
7.9520 |
| Kailong Li (李开隆) |
7.9540 |
| Joshua Broderick Phillips |
7.9540 |
| Nipat Charoenpholphant (นิพัฒน์ เจริญพลพันธุ์) |
7.9560 |
| Firstian Fushada |
7.9660 |
| Yu Da-Hyun (유다현) |
7.9680 |
| AJ Kamal |
7.9700 |
| Nicolás Sánchez |
7.9760 |
| Haowei Fan (樊浩玮) |
7.9780 |
| Paul Mahvi |
7.9820 |
| Isaac Wong Chang Man |
7.9840 |
| Henri Gerber |
7.9900 |
| Martin Fronescu |
7.9980 |
| Juan Pablo Huanqui |
8.0140 |
| Eric Limeback |
8.0220 |
| Mika Smulders |
8.0240 |
| personName |
value1/100 |
value2/100 |
value3/100 |
value4/100 |
value5/100 |
avg |
| Max Park |
6.3600 |
6.2200 |
7.1200 |
5.2600 |
4.8900 |
5.9700 |
| Max Park |
6.3700 |
5.7700 |
5.5400 |
6.1700 |
6.0200 |
5.9740 |
| Feliks Zemdegs |
5.5500 |
5.6400 |
6.5800 |
6.6700 |
5.7000 |
6.0280 |
| Max Park |
6.3900 |
5.0800 |
6.5300 |
6.3000 |
5.9500 |
6.0500 |
| Feliks Zemdegs |
4.9200 |
6.9700 |
4.2200 |
7.2700 |
6.8900 |
6.0540 |
| Max Park |
6.3100 |
6.6000 |
5.9300 |
5.7700 |
5.8300 |
6.0880 |
| Max Park |
7.2200 |
5.5000 |
5.5500 |
6.4400 |
6.0100 |
6.1440 |
| Max Park |
6.5500 |
5.9200 |
7.1600 |
6.1100 |
5.2600 |
6.2000 |
| Max Park |
5.3600 |
6.8900 |
5.8600 |
6.0300 |
6.8800 |
6.2040 |
| Max Park |
5.1500 |
6.8700 |
6.0800 |
6.4300 |
6.5300 |
6.2120 |
| Max Park |
6.3900 |
6.8200 |
5.2600 |
6.9200 |
5.9200 |
6.2620 |
| Max Park |
6.9500 |
5.7200 |
5.8800 |
6.9100 |
5.9300 |
6.2780 |
| Feliks Zemdegs |
6.1000 |
6.1200 |
6.4900 |
6.4000 |
6.3700 |
6.2960 |
| Max Park |
5.5600 |
6.2700 |
6.5900 |
6.9400 |
6.2100 |
6.3140 |
| Max Park |
5.3400 |
5.3800 |
6.1100 |
6.6100 |
8.1800 |
6.3240 |
| Max Park |
7.2900 |
6.3200 |
5.5400 |
5.5500 |
6.9300 |
6.3260 |
| Max Park |
6.3900 |
6.6600 |
7.4100 |
6.2100 |
4.9900 |
6.3320 |
| Max Park |
7.5000 |
6.0600 |
6.3100 |
5.6400 |
6.1600 |
6.3340 |
| Patrick Ponce |
6.5100 |
7.2500 |
5.3900 |
7.4500 |
5.0800 |
6.3360 |
| Feliks Zemdegs |
5.9900 |
5.2800 |
5.2500 |
6.1300 |
9.1900 |
6.3680 |
| Max Park |
6.4100 |
7.2600 |
6.6300 |
6.1200 |
5.6000 |
6.4040 |
| Feliks Zemdegs |
7.3000 |
5.7900 |
8.6100 |
4.5900 |
5.7600 |
6.4100 |
| Feliks Zemdegs |
5.6500 |
7.7200 |
6.6800 |
5.9100 |
6.0900 |
6.4100 |
| Feliks Zemdegs |
6.2900 |
6.2200 |
8.1600 |
5.7800 |
5.6500 |
6.4200 |
| Max Park |
7.1300 |
7.3500 |
5.5600 |
6.3100 |
5.7800 |
6.4260 |
| Max Park |
6.5300 |
6.8300 |
7.6800 |
5.4500 |
5.7000 |
6.4380 |
| Max Park |
7.0500 |
5.9200 |
6.5700 |
5.6800 |
6.9700 |
6.4380 |
| Max Park |
6.9800 |
6.5600 |
7.5400 |
5.5500 |
5.6900 |
6.4640 |
| Max Park |
6.0600 |
6.4600 |
6.6800 |
6.4600 |
6.7400 |
6.4800 |
| Feliks Zemdegs |
7.1600 |
6.5800 |
6.7900 |
5.8800 |
5.9900 |
6.4800 |
| Seung Hyuk Nahm (남승혁) |
6.4700 |
8.3200 |
6.1200 |
4.9000 |
6.7000 |
6.5020 |
| Seung Hyuk Nahm (남승혁) |
6.0200 |
7.6900 |
7.0300 |
6.3700 |
5.4000 |
6.5020 |
| Feliks Zemdegs |
6.9100 |
5.3900 |
7.5700 |
5.9800 |
6.7900 |
6.5280 |
| Max Park |
7.0700 |
6.5800 |
6.5400 |
5.8800 |
6.5700 |
6.5280 |
| Max Park |
6.6100 |
6.2500 |
5.9700 |
6.4700 |
7.4100 |
6.5420 |
| Max Park |
6.7000 |
6.5800 |
6.1800 |
6.4300 |
6.8800 |
6.5540 |
| Max Park |
7.0500 |
6.4700 |
5.7500 |
6.3200 |
7.1900 |
6.5560 |
| Feliks Zemdegs |
5.7200 |
6.1600 |
7.9500 |
6.2400 |
6.7500 |
6.5640 |
| Max Park |
6.4500 |
6.7000 |
6.6600 |
6.3100 |
6.7200 |
6.5680 |
| Max Park |
6.7700 |
7.4300 |
6.3800 |
6.5700 |
5.7300 |
6.5760 |
| Max Park |
6.5800 |
6.1200 |
8.1800 |
6.0000 |
6.0100 |
6.5780 |
| Max Park |
6.7400 |
5.9700 |
7.7000 |
6.6600 |
5.8300 |
6.5800 |
| Feliks Zemdegs |
6.7700 |
6.3200 |
7.5300 |
6.2700 |
6.0100 |
6.5800 |
| Max Park |
6.3600 |
5.9600 |
6.9700 |
7.1100 |
6.5500 |
6.5900 |
| Feliks Zemdegs |
7.4500 |
5.7700 |
7.2900 |
5.4200 |
7.0300 |
6.5920 |
| Feliks Zemdegs |
7.4000 |
6.5900 |
5.3200 |
6.8400 |
6.8500 |
6.6000 |
| Max Park |
6.7000 |
7.3300 |
6.4200 |
5.8900 |
6.6600 |
6.6000 |
| Feliks Zemdegs |
6.7600 |
5.5800 |
6.8300 |
7.4700 |
6.3800 |
6.6040 |
| Philipp Weyer |
6.2100 |
6.6700 |
6.1900 |
6.8100 |
7.1600 |
6.6080 |
| Feliks Zemdegs |
6.8500 |
7.0900 |
7.0600 |
5.9200 |
6.1500 |
6.6140 |
| Feliks Zemdegs |
6.7100 |
5.5100 |
6.9600 |
8.0000 |
5.9000 |
6.6160 |
| Max Park |
7.0400 |
6.6700 |
5.9500 |
7.4900 |
5.9500 |
6.6200 |
| Kian Mansour |
6.4000 |
6.1600 |
7.4200 |
6.7300 |
6.4300 |
6.6280 |
| Feliks Zemdegs |
6.8900 |
6.6800 |
6.1700 |
6.0500 |
7.3800 |
6.6340 |
| Feliks Zemdegs |
6.9100 |
6.4100 |
6.2500 |
7.3000 |
6.3100 |
6.6360 |
| Patrick Ponce |
7.5900 |
6.5900 |
6.0200 |
6.9500 |
6.0500 |
6.6400 |
| Feliks Zemdegs |
7.5200 |
6.7700 |
7.1500 |
6.0200 |
5.7500 |
6.6420 |
| Feliks Zemdegs |
7.5100 |
6.7400 |
5.2000 |
7.3500 |
6.4200 |
6.6440 |
| Max Park |
5.8300 |
6.6000 |
7.1600 |
6.4500 |
7.2000 |
6.6480 |
| Max Park |
6.8900 |
5.4200 |
6.2100 |
7.9400 |
6.7900 |
6.6500 |
| Feliks Zemdegs |
7.6600 |
5.5300 |
5.6200 |
5.9400 |
8.5300 |
6.6560 |
| Bill Wang |
7.2000 |
6.8500 |
6.7400 |
5.4600 |
7.0600 |
6.6620 |
| Feliks Zemdegs |
6.6700 |
8.3300 |
5.7500 |
5.5000 |
7.0600 |
6.6620 |
| Tanzer Balimtas |
7.6500 |
5.6000 |
6.5900 |
7.2500 |
6.2700 |
6.6720 |
| Feliks Zemdegs |
5.5800 |
7.8200 |
6.7800 |
7.0300 |
6.1500 |
6.6720 |
| Feliks Zemdegs |
6.5000 |
7.5200 |
5.7600 |
6.6600 |
6.9500 |
6.6780 |
| Feliks Zemdegs |
5.8100 |
7.5300 |
7.2800 |
6.8000 |
6.0200 |
6.6880 |
| Feliks Zemdegs |
6.1000 |
7.3800 |
5.3400 |
7.4800 |
7.1400 |
6.6880 |
| Feliks Zemdegs |
7.1900 |
6.8300 |
6.1700 |
6.0300 |
7.2400 |
6.6920 |
| Feliks Zemdegs |
6.8300 |
7.8700 |
6.2000 |
5.7000 |
6.8800 |
6.6960 |
| Feliks Zemdegs |
7.3500 |
6.6800 |
7.4100 |
5.8700 |
6.2300 |
6.7080 |
| Feliks Zemdegs |
6.6600 |
7.3000 |
7.9300 |
6.9600 |
4.7300 |
6.7160 |
| Max Park |
6.7700 |
5.7200 |
6.8000 |
7.2600 |
7.0600 |
6.7220 |
| Feliks Zemdegs |
6.7700 |
6.1100 |
7.8800 |
6.0500 |
6.8400 |
6.7300 |
| Feliks Zemdegs |
7.1200 |
5.8400 |
8.5100 |
5.8100 |
6.4000 |
6.7360 |
| Feliks Zemdegs |
6.6400 |
6.6200 |
6.5000 |
6.2500 |
7.7000 |
6.7420 |
| Max Park |
7.7300 |
6.7900 |
7.3600 |
6.2200 |
5.6200 |
6.7440 |
| Feliks Zemdegs |
7.7800 |
4.7500 |
6.0500 |
8.8300 |
6.3100 |
6.7440 |
| Feliks Zemdegs |
7.7700 |
7.1000 |
6.6200 |
6.6100 |
5.6500 |
6.7500 |
| Max Park |
6.6900 |
7.4000 |
6.9900 |
6.4100 |
6.2700 |
6.7520 |
| Max Park |
7.2600 |
6.2200 |
6.2400 |
6.1800 |
7.8800 |
6.7560 |
| Bill Wang |
6.4200 |
6.8800 |
6.2400 |
6.8500 |
7.4000 |
6.7580 |
| Feliks Zemdegs |
6.2300 |
6.5700 |
6.3800 |
7.3900 |
7.2300 |
6.7600 |
| Feliks Zemdegs |
6.7500 |
6.0900 |
7.1300 |
7.6000 |
6.2300 |
6.7600 |
| Feliks Zemdegs |
6.8800 |
7.8900 |
6.2900 |
6.3100 |
6.4500 |
6.7640 |
| Patrick Ponce |
7.0300 |
7.3800 |
4.9600 |
7.5900 |
6.8800 |
6.7680 |
| Bill Wang |
6.7400 |
7.1700 |
4.7600 |
7.3700 |
7.8300 |
6.7740 |
| Sebastian Weyer |
7.9300 |
5.9800 |
7.4200 |
5.5300 |
7.0500 |
6.7820 |
| Mats Valk |
6.0200 |
6.5700 |
7.8100 |
6.7100 |
6.8100 |
6.7840 |
| Feliks Zemdegs |
6.1200 |
7.1900 |
7.7300 |
6.3500 |
6.5300 |
6.7840 |
| Seung Hyuk Nahm (남승혁) |
5.6600 |
7.0100 |
7.6100 |
6.6300 |
7.0500 |
6.7920 |
| Max Park |
5.4300 |
7.1000 |
6.7900 |
6.8600 |
7.7900 |
6.7940 |
| Max Park |
7.0000 |
7.3700 |
6.9000 |
6.3100 |
6.3900 |
6.7940 |
| Feliks Zemdegs |
7.3500 |
6.3600 |
5.7200 |
7.6900 |
6.8600 |
6.7960 |
| Feliks Zemdegs |
7.3000 |
7.0600 |
5.6500 |
7.0600 |
6.9100 |
6.7960 |
| Feliks Zemdegs |
6.6100 |
7.7500 |
7.0400 |
6.4600 |
6.1200 |
6.7960 |
| Max Park |
6.3700 |
8.7100 |
5.4900 |
6.0300 |
7.4200 |
6.8040 |
| Max Park |
7.4300 |
8.0100 |
5.9400 |
6.2000 |
6.4500 |
6.8060 |
| Max Park |
6.8200 |
6.8500 |
6.9000 |
6.9100 |
6.5600 |
6.8080 |
| Max Park |
7.7500 |
5.4300 |
6.4100 |
6.1400 |
8.3200 |
6.8100 |
SELECT
personName as name,
MIN(avg) as minAvg
FROM (SELECT
personName,
personId,
value1 / 100 AS val1,
value2 / 100 AS val2,
value3 / 100 AS val3,
value4 / 100 AS val4,
value5 / 100 AS val5,
(value1 + value2 + value3 + value4 + value5) / 500 AS avg
FROM Results
WHERE value1 > 0 AND value2 > 0 AND value3 > 0 AND value4 > 0 AND value5 > 0 AND eventId = '333'
GROUP BY personName, personId, value1, value2, value3, value4, value5
ORDER BY avg ASC) AS db
GROUP BY name
ORDER BY minAvg ASC
LIMIT 100;