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 = 'spivey' 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 = 'spivey' 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 = 'spivey' 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 = 'spivey' 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 = 'spivey' 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 = 'spivey' 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 = 'spivey' 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 = 'spivey' AND event_standing.riderClass = 'open' ORDER BY event_standing.eventPoints DESC

2021 Lake Spivey Results

Beginner - Junior

PlaceNamePoints
1 Stella Dickerson25
2 Trace Cox22
3 Franklin Glas20
4 Garrison Aler18
5 Khloe Black16
6 Olivia Whatley15

Beginner - Women

PlaceNamePoints
1 Emma Teal25
2 sofia maruszak22
3 Rosie Amezaga20

Beginner - Men

PlaceNamePoints
1 Kaden Mathis 25
2 Rhett Hanes22
3 Jake Vincent20
4 Jeremy Mathis18
5 Will Sharon16
6 Cliff Hilton15
7 Shane Rose14
8 Connor Cornwell13
9 Thomas McNeely12
10 Bowen Glas11
11 Cole Black10
12 Joseph Short9

Intermediate - Women

PlaceNamePoints
1 Rivers Hedrick50
2 Marley Prato44
3 Lindsey Tulkoff40
4 Alex McWhorter36

Intermediate - Men

PlaceNamePoints
1 Drew Prato50
2 Jack Glas44
3 Sam Neitz40
4 Michael Deen 36
5 Tony Blankenship32
6 Justin Driskell30
7 Derek Jones28
8 Kevin Dickerson26
9 Tate Cox24
10 Hunter Black22
11 Andrew Still20
12 Matthew Niekamp18

Advanced - Women

PlaceNamePoints
No riders in this class

Advanced - Men

PlaceNamePoints
1 Brody Gillmore75
2 Ryan Wakenigg66
3 John Goza60
4 Jay McKibben54
5 Matt Filer48
6 Will Herzog44
7 Jackson Ginther40
8 James Portzer36
9 Jordan Penn32
10 David Blanchard 28
11 Stephen Pysh26

Open

PlaceNamePoints
1 Jamie Huser100
2 Logan Popwell91
3 Colby Bernier85
4 Daniel Johnson81
5 Brandon Lee77
6 Jayden Asper73
7 Vincent Knapp69
8 Jackie Sly65
9 scott perkins61
10 shawn fulks57
11 Henry Arvanites52
12 Buck Burriss48