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

2021 Acworth Beach Results

Beginner - Junior

PlaceNamePoints
1 Trace Cox25
2 Stella Dickerson22
3 Franklin Glas20
4 Rider Mayo18
5 Garrison Aler16
6 Karsyn Kerley15

Beginner - Women

PlaceNamePoints
1 Ruby Barna25
2 Emma Teal22

Beginner - Men

PlaceNamePoints
1 Cole Black25
2 Rhett Hanes22
3 Bowen Glas20
4 Braxton Walker18
5 Joseph Short16

Intermediate - Women

PlaceNamePoints
1 Lindsey Tulkoff50

Intermediate - Men

PlaceNamePoints
1 Jack Glas50
2 Camden Marsden44
3 Landon Mclendon 40
4 Josh Luton36
5 Tate Cox32
6 Michael Deen 30
7 Derek Jones28
8 Sam Neitz26
9 Hunter Black24
10 Andrew Still22
11 Tony Blankenship20

Advanced - Women

PlaceNamePoints
No riders in this class

Advanced - Men

PlaceNamePoints
1 Drew Prato75
2 John Goza66
3 Jake Mitchum60
4 Matthew Niekamp54
5 Jay McKibben48

Open

PlaceNamePoints
1 Jamie Huser100
2 Daniel Johnson91
3 Tanner Higham85
4 Logan Popwell81
5 Brandon Lee77
6 Brian Mennella73
7 shawn fulks69
8 Jayden Asper65
9 Buck Burriss61
10 scott perkins57
11 Henry Arvanites52
12 Jackie Sly48