Unnamed

SELECT co1.fight_id, co1.fighter1_odds, co1.fighter2_odds, co1.bookie_id, co1.date
FROM fightodds AS co1
WHERE co1.date =
	(SELECT MAX(date) AS maxdate
		FROM bets.fightodds AS co2
		WHERE co2.bookie_id = co1.bookie_id 
		AND co2.fight_id = ' . $a_iFightID . ')
ORDER BY co1.bookie_id, co1.fight_id ASC