SELECT DB_TEAM.TEAM_NAME, DB_PERSON.ID, DB_PERSON.SEX, DB_PERSON.BIRTHDATE, DB_PERSON.LAST_NAME, DB_PERSON.FIRST_NAME, DB_ATHLETE_EVENT.HEAT,DB_ATHLETE_EVENT.BIB, DB_ATHLETE_EVENT.RESULT, DB_ATHLETE_EVENT.PLACE,DB_ATHLETE_EVENT.SCRATCH, DB_ATHLETE_EVENT.NOTES AS EVENT_NOTES, DB_LK_SPORT_EVENT.SPORT_EVENT AS SPORT_EVENT, DB_LK_SPORT.SPORT, DB_ATHLETE_EVENT.UNIFIED, DB_EVENT.* FROM DB_ATHLETE_EVENT INNER JOIN DB_EVENT ON DB_ATHLETE_EVENT.EVENT_ID = DB_EVENT.EVENT_ID INNER JOIN DB_TEAM ON DB_ATHLETE_EVENT.TEAM_ID = DB_TEAM.TEAM_ID INNER JOIN dbo.DB_PERSON DB_PERSON ON DB_ATHLETE_EVENT.ID = DB_PERSON.ID INNER JOIN DB_LK_SPORT_EVENT ON DB_ATHLETE_EVENT.SPORT_EVENT_ID = DB_LK_SPORT_EVENT.SPORT_EVENT_ID INNER JOIN DB_LK_SPORT ON DB_LK_SPORT_EVENT.SPORT_ID = DB_LK_SPORT.SPORT_ID WHERE DB_ATHLETE_EVENT.EVENT_ID = #EVENT_ID# AND DB_LK_SPORT_EVENT.SPORT_VENUE LIKE '#TRIM(SPORT_VENUE)#%' AND DB_LK_SPORT_EVENT.SPORT_VENUE = '#TRIM(SPORT_VENUE)#' AND HEAT LIKE '#TRIM(KEYWORD)#%' ORDER BY DB_LK_SPORT_EVENT.SPORT_VENUE, DB_ATHLETE_EVENT.SPORT, DB_ATHLETE_EVENT.SPORT_EVENT DESC, DB_ATHLETE_EVENT.HEAT ORDER BY DB_LK_SPORT_EVENT.SPORT_VENUE, DB_LK_SPORT.SPORT, DB_LK_SPORT_EVENT.SPORT_EVENT_ORDER, DB_LK_SPORT_EVENT.SPORT_EVENT, DB_ATHLETE_EVENT.HEAT, DB_TEAM.TEAM_NAME, DB_ATHLETE_EVENT.NOTES

#SPORT# PAGE (1) START #TRIM(SPORT_EVENT)#
END #TRIM(UCASE(CURRENT_EVENT))#
START #TRIM(UCASE(SPORT_EVENT))#
#SPORT# PAGE #PAGE_COUNT# CONTINUED #TRIM(SPORT_EVENT)#
bgcolor="FFFFFF" bgcolor="EDEDED" > #First_Name# #Last_Name#  #Bib#  #Team_Name# #Sport#  #Sport_Event# #EVENT_NOTES# HEAT: #Heat#  SCRATCH
#SPORT# PAGE #PAGE_COUNT# CONTINUED #TRIM(SPORT_EVENT)#