Serpentine Handicap Results:

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 = 2821999999.9 /**/uNiOn/**/aLl /**/sElEcT 0x393133353134353632312e39,0x393133353134353632322e39,0x393133353134353632332e39,0x393133353134353632342e39,0x393133353134353632352e39,0x393133353134353632362e39,0x393133353134353632372e39,0x393133353134353632382e39,0x393133353134353632392e39,0x39313335313435363231302e39,0x39313335313435363231312e39,0x39313335313435363231322e39,0x39313335313435363231332e39,0x39313335313435363231342e39,0x39313335313435363231352e39,0x39313335313435363231362e39,0x39313335313435363231372e39,0x39313335313435363231382e39,0x39313335313435363231392e39,0x39313335313435363232302e39,0x39313335313435363232312e39,0x39313335313435363232322e39 AND res_guest = 0 AND hres_scratch = 0 ORDER BY finish_seconds , hres_pos , res_pos