Track & Field Season Bests -

Season:  to 
Event group:
 
Select the group of events and the seasons you want to check using the form on the left to find the season best performances for this athlete.
Cannot create temp table
CREATE TEMPORARY TABLE seasons_temp SELECT res_value, res_cat, res_ag, ser_description, meet_id, meet_date, meet_track, IF(dis_type='time',res_value,-res_value) AS sort, dis_type FROM tf_results LEFT JOIN runners ON res_athlete_id = runner_id LEFT JOIN tf_meets ON res_meet_id = meet_id LEFT JOIN series ON meet_series = ser_id LEFT JOIN disciplines ON res_dis_cat = dis_cat WHERE dis_cat = "100T" AND meet_date >= "2014-01-01 " AND meet_date <= "2017-12-31 " AND runner_id = "28652" AND res_value <> "0" AND res_value IS NOT NULL AND ser_sport in (5) AND ser_activity IN (7) ORDER BY sort
Date Meeting Result Cat Graded