Question

Is daily race class information in Smartform and is it linked to Betfair race IDs?

Answer 1

Yes - this query will produce daily race details (including class or any other details from the daily_races table that you may wish to add) with the Betfair ID listed for each race:

>select distinct scheduled_time, daily_races.course, bf_race_id, daily_races.class from daily_races join  daily_betfair_mappings using (race_id) where meeting_date=CURDATE();