SELECT DB_TEAM.TEAM_ID, DB_TEAM.TEAM_NAME, DB_TEAM.OLD_AREA, DB_TEAM.CITY_ID, DB_TEAM.COORDINATOR, DB_TEAM.PASSWORD, DB_TEAM.TOTAL_LOGIN, DB_TEAM.LAST_LOGIN, DB_TEAM.ATHLETIC, DB_TEAM.CORPORATE, DB_TEAM.CORPORATE_LEVEL, DB_TEAM.CIVIC, DB_TEAM.MEDIA, DB_TEAM.LETR, DB_TEAM.FOUNDATION, DB_TEAM.SCHOOL, DB_TEAM.MEDICAL, DB_TEAM.VENDOR, DB_TEAM.LODGE, DB_TEAM.REGISTER_ONLINE, DB_TEAM.DESCRIPTION, DB_TEAM.WEB_SITE, DB_TEAM.TEAM_IMAGE, DB_TEAM.TEAM_IMAGE_BW, DB_TEAM.TEAM_ADDRESS, DB_TEAM.TEAM_ZIP, DB_TEAM.TEAM_PHONE, DB_TEAM.TEAM_FAX, DB_TEAM.TEAM_EMAIL, DB_EVENT.EVENT_ID, DB_EVENT.EVENT_NAME, DB_EVENT.EVENT_DESCRIPTION, DB_EVENT.EVENT_LOCATION, DB_EVENT.CITY_ID AS Expr1, DB_EVENT.START_DATE, DB_EVENT.END_DATE, DB_EVENT.EVENT_FULL, DB_EVENT.TEAM_ID AS Expr2, DB_EVENT.AREA1, DB_EVENT.AREA2, DB_EVENT.AREA3, DB_EVENT.AREA4, DB_EVENT.AREA5, DB_EVENT.AREA6, DB_EVENT.AREA7, DB_EVENT.FUNDRAISE_GOAL, DB_EVENT.EVENT_DETAILS, DB_EVENT.EVENT_TYPE, DB_EVENT.REGISTRATION_END, DB_EVENT.RESPONSIBLE_ID, DB_EVENT.PUBLISH, DB_EVENT.SEASON, DB_EVENT.EXTRA_COST, DB_EVENT.PICTURE_URL, DB_EVENT.PICTURE_THUMB_URL, DB_EVENT.VIDEO_URL, DB_EVENT.RSS_URL, DB_ATHLETE_EVENT.ID, DB_ATHLETE_EVENT.ATHLETE_EVENT_ID, DB_ATHLETE_EVENT.EVENT_ID AS Expr3, DB_ATHLETE_EVENT.TEAM_ID AS Expr4, DB_ATHLETE_EVENT.UNIFIED, DB_ATHLETE_EVENT.QUALIFY, DB_ATHLETE_EVENT.QUALIFY_2, DB_ATHLETE_EVENT.HEAT, DB_ATHLETE_EVENT.RESULT, DB_ATHLETE_EVENT.PLACE, DB_ATHLETE_EVENT.BIB, DB_ATHLETE_EVENT.SCRATCH, DB_ATHLETE_EVENT.DISQUALIFY, DB_ATHLETE_EVENT.NOTES, DB_ATHLETE_EVENT.JSONDATA, DB_ATHLETE_EVENT.TIME_ADDED, DB_ATHLETE_EVENT.TIME_EDITED, DB_PERSON.ID AS ID, DB_PERSON.LAST_NAME, DB_PERSON.FIRST_NAME, DB_PERSON.MIDDLE, DB_PERSON.SSN, DB_PERSON.SEX, DB_PERSON.BIRTHDATE, DB_PERSON.ADDRESS, DB_PERSON.CITY, DB_PERSON.STATE, DB_PERSON.ZIP, DB_PERSON.EMAIL, DB_PERSON.HOME_PHONE, DB_PERSON.WORK_PHONE, DB_PERSON.CELL_PHONE, DB_PERSON.FAX, DB_PERSON.DECEASED, DB_PERSON.ATHLETE, DB_PERSON.FOUNDATION AS Expr6, DB_PERSON.VOLUNTEER, DB_PERSON.CORPORATE AS Expr7, DB_PERSON.MEDIA AS Expr8, DB_PERSON.TORCH, DB_PERSON.STAFF, DB_PERSON.AREADIRECTOR, DB_PERSON.BOARD, DB_PERSON.PERSON_IMAGE, DB_PERSON.TIME_ADDED AS Expr9, DB_PERSON.TIME_EDITED AS Expr10, DB_PERSON.SITE_USERNAME, DB_PERSON.SITE_PASSWORD, DB_PERSON.ACCESS_ADMIN, DB_PERSON.ACCESS_MAIN, DB_PERSON.ACCESS_FULL, DB_PERSON.ACCESS_GAME, DB_PERSON.ACCESS_RAFFLE, DB_PERSON.ACCESS_DONOR, DB_PERSON.ACCESS_GRANTS, DB_PERSON.WORLD, DB_PERSON.NEWSLETTER, DB_PERSON.PROFILE_TOTAL_LOGIN, DB_PERSON.PROFILE_LAST_LOGIN, DB_PERSON.SHIRT_SIZE, DB_ATHLETE.ID AS Expr11, DB_ATHLETE.ATHLETE_TEAM_ID, DB_ATHLETE.UNIFIED AS Expr12, DB_ATHLETE.APP_DATE, DB_ATHLETE.WHEELCHAIR, DB_ATHLETE.WHEELCHAIR_NOTE, DB_ATHLETE.SEIZURES, DB_ATHLETE.SEIZURES_NOTE, DB_ATHLETE.DOWN_SYNDROME, DB_ATHLETE.DOWN_SYNDROME_NOTE, DB_ATHLETE.TETANUS, DB_ATHLETE.TETANUSDATE, DB_ATHLETE.ASTHMA, DB_ATHLETE.ASTHMA_NOTE, DB_ATHLETE.DIABETES, DB_ATHLETE.DIABETES_NOTE, DB_ATHLETE.DIET, DB_ATHLETE.DIET_NOTE, DB_ATHLETE.VIOLENT, DB_ATHLETE.VIOLENT_NOTE, DB_ATHLETE.SEXUAL_DEVIANT, DB_ATHLETE.SEXUAL_DEVIANT_NOTE, DB_ATHLETE.POLIO, DB_ATHLETE.POLIO_NOTE, DB_ATHLETE.VISION, DB_ATHLETE.VISION_NOTE, DB_ATHLETE.GLASSES, DB_ATHLETE.HEARING, DB_ATHLETE.HEARING_NOTE, DB_ATHLETE.HEART, DB_ATHLETE.HEART_NOTE, DB_ATHLETE.EMOTIONAL, DB_ATHLETE.EMOTIONAL_NOTE, DB_ATHLETE.NOTES AS Expr13, DB_ATHLETE.ALLERGIES, DB_ATHLETE.BONE, DB_ATHLETE.BONE_NOTE, DB_ATHLETE.HEIGHT, DB_ATHLETE.WEIGHT, DB_ATHLETE.ATHLETE_RESTRICTED, DB_ATHLETE.ATHLETE_EXCLUDED, DB_ATHLETE.ONE_ON_ONE, DB_ATHLETE_EVENT.NOTES AS EVENT_NOTES, DB_LINK_CITY.CITY_ID AS Expr14, DB_LINK_CITY.CITY AS Expr15, DB_LINK_CITY.COUNTY, DB_LINK_CITY.AREA, DB_LINK_CITY.REGION, DB_LINK_CITY.STATE AS Expr16, DB_ATHLETE_EVENT.NOTES AS THENOTES, DB_PERSON.CITY AS PERSON_CITY, DB_LK_SPORT.SPORT, DB_LK_SPORT_EVENT.SPORT_EVENT FROM DB_ATHLETE_EVENT INNER JOIN 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 ON DB_ATHLETE_EVENT.SPORT_ID = DB_LK_SPORT.SPORT_ID INNER JOIN DB_LK_SPORT_EVENT ON DB_ATHLETE_EVENT.SPORT_EVENT_ID = DB_LK_SPORT_EVENT.SPORT_EVENT_ID WHERE (DB_ATHLETE_EVENT.EVENT_ID = #EVENT_ID#) and DB_LK_SPORT.SPORT like '%#sport#%' ORDER BY DB_TEAM.TEAM_NAME, DB_ATHLETE_EVENT.SPORT, DB_LK_SPORT_EVENT.SPORT_EVENT_ORDER,DB_ATHLETE_EVENT.SPORT_EVENT, DB_ATHLETE_EVENT.HEAT, DB_ATHLETE_EVENT.NOTES, DB_PERSON.LAST_NAME, DB_PERSON.FIRST_NAME SELECT DB_ATHLETE_EVENT.ID FROM DB_ATHLETE_EVENT INNER JOIN DB_ATHLETE ON DB_ATHLETE_EVENT.ID = DB_ATHLETE.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 WHERE DB_ATHLETE_EVENT.EVENT_ID = #EVENT_ID# GROUP BY DB_ATHLETE_EVENT.ID SELECT DB_ATHLETE_EVENT.ATHLETE_EVENT_ID, DB_ATHLETE.ATHLETE_TEAM_ID, DB_LK_SPORT.SPORT, DB_LK_SPORT_EVENT.SPORT_EVENT FROM DB_ATHLETE_EVENT INNER JOIN DB_ATHLETE ON DB_ATHLETE_EVENT.ID = DB_ATHLETE.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 ON DB_ATHLETE_EVENT.SPORT_ID = DB_LK_SPORT.SPORT_ID INNER JOIN DB_LK_SPORT_EVENT ON DB_ATHLETE_EVENT.SPORT_EVENT_ID = DB_LK_SPORT_EVENT.SPORT_EVENT_ID WHERE (DB_ATHLETE_EVENT.EVENT_ID = #EVENT_ID#) GROUP BY DB_ATHLETE_EVENT.ATHLETE_EVENT_ID, DB_ATHLETE.ATHLETE_TEAM_ID, DB_ATHLETE_EVENT.HEAT, DB_LK_SPORT.SPORT, DB_LK_SPORT_EVENT.SPORT_EVENT SELECT DB_ATHLETE.ATHLETE_TEAM_ID, DB_TEAM.TEAM_NAME, DB_PERSON.LAST_NAME, DB_PERSON.FIRST_NAME, DB_PERSON.ADDRESS, DB_PERSON.CITY, DB_PERSON.STATE, DB_PERSON.ZIP, DB_PERSON.EMAIL, DB_PERSON.HOME_PHONE, DB_PERSON.WORK_PHONE, DB_PERSON.CELL_PHONE, DB_PERSON.FAX, DB_LINK_CITY.AREA FROM DB_ATHLETE_EVENT INNER JOIN DB_ATHLETE ON DB_ATHLETE_EVENT.ID = DB_ATHLETE.ID INNER JOIN DB_TEAM ON DB_ATHLETE.ATHLETE_TEAM_ID = DB_TEAM.TEAM_ID INNER JOIN DB_PERSON ON DB_TEAM.COORDINATOR = DB_PERSON.ID INNER JOIN DB_LINK_CITY ON DB_TEAM.CITY_ID = DB_LINK_CITY.CITY_ID WHERE DB_ATHLETE_EVENT.EVENT_ID = #EVENT_ID# GROUP BY DB_ATHLETE.ATHLETE_TEAM_ID, DB_TEAM.TEAM_NAME, DB_PERSON.LAST_NAME, DB_PERSON.FIRST_NAME, DB_PERSON.ADDRESS, DB_PERSON.CITY, DB_PERSON.STATE, DB_PERSON.ZIP, DB_PERSON.EMAIL, DB_PERSON.HOME_PHONE, DB_PERSON.WORK_PHONE, DB_PERSON.CELL_PHONE, DB_PERSON.FAX, DB_LINK_CITY.AREA ORDER BY TEAM_NAME SPECIAL OLYMPICS YOUR SEARCH CRITERIA RETURNED 0 RESULTS
TRY AGAIN
  1. #TEAM_NAME# - #REGION#
#TEAM_NAME# - #SPORT#
#EVENT_FULL#
NAME SPORT EVENT NOTES QUALIFY QUALIFY 2 HEAT RESULT PLACE
#SPORT_EVENT#
#LAST_NAME#,#FIRST_NAME# WC 1:1MF #DateDiff("YYYY",Birthdate, Now())# UNIFIED BIB:#bib# #EVENT_NOTES# #NUMBERFORMAT(QUALIFY, 0009.9999)# #NUMBERFORMAT(QUALIFY_2, 0009.9999)# #HEAT# SCRATCH----DQ----#NUMBERFORMAT(RESULT, 0009.9999)# SCRATCH----DQ----#PLACE#

Back to Top
 
TOTAL COMPETITION:
#ATHLETE_COUNT.RECORDCOUNT# ATHLETES FROM #TEAM_COUNT.RECORDCOUNT# TEAMS PARICIPATING IN #EVENT_COUNT.RECORDCOUNT# EVENTS