SELECT races.venue, races.meet_date, races.race, status, sum(abs((place >= '1' and place <= '8') or place = 'F' or place = 'N') * 1) as starters FROM races left join form using (venue, meet_date, race) WHERE (races.venue = 'CAN' or races.venue = 'MDH' or races.venue = 'NOR') and (races.race like 'R%' or races.race like 'T%') and races.meet_date > '2000-01-01' and starters = 0 and status != 'A' group by venue, meet_date, race order by meet_date asc limit 3000

Track

Meet Date

Race#

Status

Starters

Done!