Click on Event Distance to show Athletes in that event. (ie. 1600)
Division Event Athletes
Girls800322
Girls3200151
Girls1600734
Boys Varsity800153
   
Division Event Athletes
Boys Varsity3200126
Boys Varsity1600507
Boys Frosh-Soph800152
Boys Frosh-Soph320081
   
Division Event Athletes
Boys Frosh-Soph1600506
Query failed SELECT r.Runner_ID, location AS TeamName, r.FirstName, r.LastName, r.division, event, minutes AS seedtime, seconds, rf.time as FinishTime, rf.heatplace as `Heat Place`,rf.race_id FROM `runners` r LEFT JOIN `users` u ON u.id = r.Team_ID LEFT JOIN `resultsFixed` rf ON rf.FirstName = r.FirstName AND rf.LastName = r.LastName JOIN `Race` race ON race.Race_ID = rf.race_id AND (r.event = race.Distance OR race.Distance = "Mile") WHERE 1 AND 1 ORDER BY `TeamName, TeamName DESC` , seedtime, seconds