SQL
SELECT *,MIN(dates.date) as 'startdate' FROM shows, dates WHERE dates.show_id = shows.show_id AND category = training GROUP BY shows.show_id ORDER BY startdate ASC

Unknown column 'training' in 'where clause'