Error performing query while attempting to SELECTMainRaceCalendar:

Here's the query: SELECT DateTime, DATE_FORMAT(DateTime,'%W, %M %e, %Y') AS date,DATE_FORMAT(DateTime,'%l:%i %p') AS time,DATE_FORMAT(DateTime,'%Y%m%d') AS compareDate, DATE_FORMAT(DateTime,'%W') AS weekday, ID, Name, Town, Region, State,Location, Address, Description, Website, Fee, Registration, Added_By, Results, MAX(CARA_Circuit) AS CARA_Circuit, MAX(Team_Race) AS Team_Race, MAX(Prize_Money) AS Prize_Money, MAX(Pacer_Race) AS Pacer_Race, MAX(Social_Event) AS Social_Event, MAX(Featured) AS Featured, MAX(Youth_Circuit) AS Youth_Circuit, Sources, NOW() AS curtime FROM races, Distance WHERE ID=RaceID AND Distance>=0 AND (NOW()>DateTime) AND Name LIKE '%Cheers to New Year's 5K%' GROUP BY ID ORDER BY DateTime DESC, Town LIMIT 0, 20