SELECT event_standing.*, user_profile.* FROM event_standing LEFT JOIN user_profile ON user_profile.userID = event_standing.userID WHERE event_standing.eventSeason = '2021' AND event_standing.eventID = 'valdosta' AND event_standing.riderClass = 'beginner_jr' ORDER BY event_standing.eventPoints DESC
SELECT event_standing.*, user_profile.* FROM event_standing LEFT JOIN user_profile ON user_profile.userID = event_standing.userID WHERE event_standing.eventSeason = '2021' AND event_standing.eventID = 'valdosta' AND event_standing.riderClass = 'beginner_f' ORDER BY event_standing.eventPoints DESC
SELECT event_standing.*, user_profile.* FROM event_standing LEFT JOIN user_profile ON user_profile.userID = event_standing.userID WHERE event_standing.eventSeason = '2021' AND event_standing.eventID = 'valdosta' AND event_standing.riderClass = 'beginner_m' ORDER BY event_standing.eventPoints DESC
SELECT event_standing.*, user_profile.* FROM event_standing LEFT JOIN user_profile ON user_profile.userID = event_standing.userID WHERE event_standing.eventSeason = '2021' AND event_standing.eventID = 'valdosta' AND event_standing.riderClass = 'int_f' ORDER BY event_standing.eventPoints DESC
SELECT event_standing.*, user_profile.* FROM event_standing LEFT JOIN user_profile ON user_profile.userID = event_standing.userID WHERE event_standing.eventSeason = '2021' AND event_standing.eventID = 'valdosta' AND event_standing.riderClass = 'int_m' ORDER BY event_standing.eventPoints DESC
SELECT event_standing.*, user_profile.* FROM event_standing LEFT JOIN user_profile ON user_profile.userID = event_standing.userID WHERE event_standing.eventSeason = '2021' AND event_standing.eventID = 'valdosta' AND event_standing.riderClass = 'adv_f' ORDER BY event_standing.eventPoints DESC
SELECT event_standing.*, user_profile.* FROM event_standing LEFT JOIN user_profile ON user_profile.userID = event_standing.userID WHERE event_standing.eventSeason = '2021' AND event_standing.eventID = 'valdosta' AND event_standing.riderClass = 'adv_m' ORDER BY event_standing.eventPoints DESC
SELECT event_standing.*, user_profile.* FROM event_standing LEFT JOIN user_profile ON user_profile.userID = event_standing.userID WHERE event_standing.eventSeason = '2021' AND event_standing.eventID = 'valdosta' AND event_standing.riderClass = 'open' ORDER BY event_standing.eventPoints DESC

2021 Valdosta Wake Compound Results

Beginner - Junior

PlaceNamePoints
1 Rhett Richards25
2 Franklin Glas22
3 Trace Cox20

Beginner - Women

PlaceNamePoints
No riders in this class

Beginner - Men

PlaceNamePoints
1 Landon Davis25
2 Rhett Hanes22
3 Max Kofke20
4 Bowen Glas18
5 Joseph Short16

Intermediate - Women

PlaceNamePoints
1 Maggie Kofke50

Intermediate - Men

PlaceNamePoints
1 Jack Glas50
2 Nolan Richards44
3 Eliseo Magallon40
4 Jay McKibben36
5 Tate Cox32

Advanced - Women

PlaceNamePoints
No riders in this class

Advanced - Men

PlaceNamePoints
1 John Goza75
2 Henry Arvanites66
3 Jayden Asper60
4 Trevor Spencer54
5 Brandon Lee48
6 Buck Burriss44
7 scott perkins40

Open

PlaceNamePoints
1 Jadon Scures100
2 Hayden Turner91
3 Jamie Huser85
4 Rivers Hedrick81
5 Daniel Johnson77