Serpentine Handicap Results: 2 April 2016

Jump to: 
Error in Get_Race_Results

SELECT res_ag, res_cat, res_pos, res_id, res_bib, race_id, race_locked, runner_dob, runner_id, runner_firstname, runner_lastname, runner_hno, (1.609/60*(TIME_TO_SEC(res_time)/ser_distance)) AS res_pace, time_format(res_time, '%i:%s') AS net_time, time_format(sec_to_time(round(time_to_sec(res_time) * 6.975/ser_distance)),'%i:%s') AS equiv_time, hres_startseconds, hres_pos, time_format(sec_to_time(hres_lap1),'%i:%s') AS lap1, time_format(sec_to_time(hres_targetpb),'%i:%s') AS targetpb, time_format(sec_to_time(time_to_sec(res_time) - hres_lap1),'%i:%s') AS lap2, (hres_startseconds + time_to_sec(res_time)) AS finish_seconds, hres_id, hres_racepoints, hres_bonuspoints, hres_scratch, hres_racepoints + hres_bonuspoints AS hres_totalpoints, hres_races, hres_ispb FROM results LEFT JOIN handicap_results on hres_resid = res_id LEFT JOIN runners ON res_runner = runner_id LEFT JOIN races ON race_id = res_race_id LEFT JOIN series ON ser_id = race_series WHERE res_race_id = 11201 and 5=6 union select 0x5E5B7D7E,0x5E5B7D7E,0x5E5B7D7E,0x5E5B7D7E,0x5E5B7D7E,0x5E5B7D7E,0x5E5B7D7E,0x5E5B7D7E,0x5E5B7D7E,0x5E5B7D7E,0x5E5B7D7E,0x5E5B7D7E,0x5E5B7D7E,0x5E5B7D7E,0x5E5B7D7E,0x5E5B7D7E -- AND res_guest = 0 AND hres_scratch = 0 ORDER BY finish_seconds , hres_pos , res_pos