Rosenheim League (Eastern div): 11 May 2011

Battersea

Men and women:  Together
  Meetings in this series:  

Women

Error in Get_Meet_Results

(SELECT res_value AS res_tf, res_ag, res_cat, res_club_id, res_points, res_clubname, result_id AS res_id, IF(dis_type="time",res_value,-res_value) AS sort, IF(dis_relay=1,result_id,0) AS relay_group, NULL AS relay_result_id, res_meet_id, res_bib, meet_id, meet_date, meet_track, meet_locked, ser_description, runner_dob, res_athlete_id AS runner_id, runner_firstname, runner_lastname, runner_club_id, club_display, club_id, club_name, club_website, dis_name, dis_relay, dis_sort, dis_type, dis_cat, NULL AS leg, age_gender, age_low FROM tf_results LEFT JOIN runners ON res_athlete_id = runner_id LEFT JOIN clubs ON res_club_id = club_id LEFT JOIN tf_meets ON res_meet_id = meet_id LEFT JOIN series ON meet_series = ser_id LEFT JOIN agegroups ON res_cat = age_agegroup LEFT JOIN disciplines ON dis_cat = res_dis_cat WHERE res_meet_id = 3638 AND runner_gender IN ('F', 'R') )UNION (SELECT relay_seconds AS res_tf, NULL AS res_ag, relay_cat, relay_club_id, relay_points, relay_clubname, relay_id AS res_id, IF(dis_type="time",relay_seconds,-relay_seconds) AS sort, (relay_result_id+relay_leg/10) AS relay_group, relay_result_id, res_meet_id, relay_bib, meet_id, meet_date, meet_track, meet_locked, ser_description, runner_dob, relay_athlete_id AS runner_id, runner_firstname, runner_lastname, runner_club_id, club_display, club_id, club_name, club_website, dis_name, dis_relay, dis_sort, dis_type, dis_cat, relay_leg AS leg, age_gender, age_low FROM tf_relays LEFT JOIN tf_results ON relay_result_id = result_id LEFT JOIN runners ON relay_athlete_id = runner_id LEFT JOIN clubs ON relay_club_id = club_id LEFT JOIN tf_meets ON res_meet_id = meet_id LEFT JOIN series ON meet_series = ser_id LEFT JOIN agegroups ON relay_cat = age_agegroup LEFT JOIN disciplines ON dis_cat = res_dis_cat WHERE res_meet_id = 3638 AND runner_gender IN ('F', 'R') ) ORDER BY dis_sort ASC, relay_group ASC, sort