SELECT COUNT(DISTINCT DB_ATHLETE.ID) AS TOTAL_ATHLETES, DB_ATHLETE_EVENT.EVENT_ID, DB_LK_SPORT_EVENT.SPORT_VENUE FROM DB_ATHLETE_EVENT INNER JOIN dbo.DB_PERSON db_person ON DB_ATHLETE_EVENT.ID = DB_PERSON.ID INNER JOIN DB_ATHLETE ON DB_PERSON.ID = DB_ATHLETE.ID INNER JOIN DB_EVENT ON DB_ATHLETE_EVENT.EVENT_ID = DB_EVENT.EVENT_ID INNER JOIN DB_TEAM ON DB_ATHLETE.ATHLETE_TEAM_ID = DB_TEAM.TEAM_ID INNER JOIN DB_LINK_CITY ON DB_TEAM.CITY_ID = DB_LINK_CITY.CITY_ID INNER JOIN DB_LK_SPORT_EVENT ON DB_ATHLETE_EVENT.SPORT_EVENT = DB_LK_SPORT_EVENT.SPORT_EVENT GROUP BY DB_ATHLETE_EVENT.EVENT_ID, DB_LK_SPORT_EVENT.SPORT_VENUE HAVING DB_ATHLETE_EVENT.EVENT_ID = #EVENT_ID# AND (LEFT(SPORT_VENUE, NULLIF(CHARINDEX('-', SPORT_VENUE) - 1, -1))= '#TRIM(SPORT_VENUE)#') SELECT DB_PERSON.ID, DB_PERSON.LAST_NAME, DB_PERSON.FIRST_NAME, DB_PERSON.SEX, DB_PERSON.BIRTHDATE, dbo.DB_TEAM.TEAM_NAME, dbo.DB_ATHLETE_EVENT.UNIFIED, dbo.DB_ATHLETE_EVENT.HEAT, dbo.DB_ATHLETE_EVENT.BIB, dbo.DB_ATHLETE_EVENT.NOTES, dbo.DB_EVENT.EVENT_NAME, dbo.DB_EVENT.EVENT_FULL, dbo.DB_LK_SPORT_EVENT.SPORT_EVENT,DB_LK_SPORT_EVENT.SPORT_VENUE, dbo.DB_LK_SPORT.SPORT FROM dbo.DB_TEAM INNER JOIN dbo.DB_ATHLETE_EVENT INNER JOIN dbo.DB_PERSON db_person ON dbo.DB_ATHLETE_EVENT.ID = DB_PERSON.ID INNER JOIN dbo.DB_EVENT ON dbo.DB_ATHLETE_EVENT.EVENT_ID = dbo.DB_EVENT.EVENT_ID ON dbo.DB_TEAM.TEAM_ID = dbo.DB_ATHLETE_EVENT.TEAM_ID INNER JOIN dbo.DB_LK_SPORT_EVENT INNER JOIN dbo.DB_LK_SPORT ON dbo.DB_LK_SPORT_EVENT.SPORT_ID = dbo.DB_LK_SPORT.SPORT_ID ON dbo.DB_ATHLETE_EVENT.SPORT_EVENT_ID = dbo.DB_LK_SPORT_EVENT.SPORT_EVENT_ID WHERE DB_ATHLETE_EVENT.EVENT_ID = #EVENT_ID# AND DB_LK_SPORT_EVENT.SPORT_VENUE like '#TRIM(SPORT_VENUE)#%'AND DB_LK_SPORT.SPORT = '#TRIM(SPORT)#' AND HEAT LIKE '#TRIM(KEYWORD)#%' ORDER BY TEAM_NAME, DB_ATHLETE_EVENT.SPORT,dbo.DB_LK_SPORT_EVENT.SPORT_EVENT, notes, LAST_NAME, FIRST_NAME

UNIFIED PARTNER #First_Name# #Last_Name# #Team_Name# - UNIFIED ATHLETE #Sport# #bib# #Sport_Event# HEAT:#Heat# #NOTES# _____