LATEST RACEDAY FORECASTS

WordPress database error: [Table 'raceweat_wp2010.wp_motorracingleague_entry' doesn't exist]
CREATE TEMPORARY TABLE player SELECT player_name, SUM(points) AS total, MAX(points) AS best_result, MIN(e.when) AS earliest_entry FROM wp_motorracingleague_entry e, wp_motorracingleague_race r WHERE r.championship_id = 5 AND e.race_id = r.id AND race_start < now() GROUP BY e.player_name

WordPress database error: [Table 'raceweat_wp2010.wp_motorracingleague_race' doesn't exist]
CREATE TEMPORARY TABLE race SELECT id, circuit, race_start FROM wp_motorracingleague_race WHERE championship_id = 5 AND race_start < now() ORDER BY race_start

WordPress database error: [Table 'raceweat_wp2010.race' doesn't exist]
SELECT race.id, circuit, GROUP_CONCAT(CONCAT(r.position, ' ', pt.name) ORDER BY r.position SEPARATOR '') AS finishing_positions FROM race LEFT JOIN wp_motorracingleague_result r ON race.id = r.race_id LEFT JOIN wp_motorracingleague_participant pt ON r.participant_id = pt.id GROUP BY id ORDER BY race_start

WordPress database error: [Table 'raceweat_wp2010.player' doesn't exist]
SELECT p.player_name as player_name, COALESCE(e.points, 0) points, r.id as id, p.total as total, COALESCE(e.points_breakdown, "") AS points_breakdown FROM player p JOIN race r LEFT JOIN wp_motorracingleague_entry e ON e.race_id = r.id AND e.player_name = p.player_name ORDER BY total DESC, best_result DESC, earliest_entry ASC, p.player_name, r.race_start ASC


PlayerRankTotal

RaceWeather.net’s NASCAR Fantasy League