Race Information
|
Race Details
The specified race does not exist or there was a database error while processing this request.
SELECT Race.CourseId, date_format(RaceDate, '%m/%d/%Y'), StartTime, USATFPoints, Teams, TotalPrizeMoney, NumParticipants, NumFinishers, NumMen, NumWomen, date_format(WinningTimeMen, '%H:%i:%s'), date_format(WinningTimeWomen, '%H:%i:%s'), RaceResultsURL, Race.Comments as RaceComments, Courses.CourseName, Courses.Organization, Courses.Location, Courses.DistanceId, Distance.DistanceStr, Courses.Difficulty, YearEstablished, Courses.MonthRun, date_format(Courses.MensRecord, '%H:%i:%s'), date_format(Courses.WomensRecord, '%H:%i:%s'), Courses.WebURL, Courses.Comments as CourseComments, ScoringCompany, MainURL,
0 as NumVotes, 0 as Rating
FROM Race inner join Courses on Race.RaceId=2052 AND Courses.CourseId=Race.CourseId
left join ScoringSystems on ScoringSystems.ScoringSystemId=Race.ScoringId
inner join Distance on Distance.DistanceId=Courses.DistanceId
| Course Name: | |
| Distance: | |
| Difficulty: | Moderate |
| Established: | 1999 |
| Records: | Men: ; Women: |
|
| Race Date: | |
| Teams: | No |
| Total Prize Money: | 0 |
| Number of Participants: | 0 (0 men, 0 women) |
| Winning Times: | Men: ; Women |
|
