SELECT IF(sch.ID='127',NULL,sch.name)AS schoolNameForHeader ,CONCAT_WS('-',a.ID,e.gender,e.level) as ID2,e.type,e.school,e.home_school AS home_school_id,e.away_schools AS away_schools_id ,e.worksheet,e.ID AS event_id,IF(e.gender=2,' Boys',IF(e.gender=3,' Girls',''))AS gender ,e.level,lev.name AS levelName,a.name AS activity,t.name AS event_type,d.id AS date_id ,e.history_comment,e.publish,e.schoolFS,e.school AS eSchool,e.showEndTime,e.activity AS activityID,e.gender AS genderID ,DATE_FORMAT(e.date_posted,'%Y%m%d%h%i%s')AS datePosted ,DATE_FORMAT(e.date_posted,'%Y-%m-%d')AS date_posted ,IF(d.locationDate>'',l1.name,IF(e.location=0 OR e.location=-1,h.name,l.name))AS location ,IF(d.locationDate>'',l1.name,IF(e.location=0 OR e.location=-1,h.name,l.name))AS locationName ,IF(d.locationDate>'',d.locationDate,e.location)AS location1,d.buildingFS ,IF(d.locationDate>0,d.fsLocationDate,e.fs_location_id)AS fs_location_id,d.schoolonly_locations_pub_view ,e.schoolonly_location,ls.name AS schoolOnlyLocation ,IF(cmt.publicComment>'',CONCAT(cmt.publicComment,'. ',IF(d.commentsDate>'',d.commentsDate,IF(e.recurring > 0, '', e.text))),IF(d.commentsDate>'',d.commentsDate,IF(e.recurring > 0, '', e.text)))AS note ,l.maps,h.name AS home_away,h.ID AS hID ,e.away_schools,e.history_ring ,opp.name AS oppName,ifnull(away.name,' ') AS awayName ,IF(ISNULL(s.season),'',s.season )AS seasonName ,e.cancelled,e.postponed,e.changed ,IF(cmt.publicComment>'',CONCAT(cmt.publicComment,'. ',IF(d.commentsDate>'',d.commentsDate,e.text)),IF(d.commentsDate>'',d.commentsDate,e.text))AS comments ,d.date ,DATE_FORMAT(d.date, '%W, %b %e, %Y')AS date_str,s.season ,DATE_FORMAT(d.date, '%a')AS week_day,DATE_FORMAT(d.date, '%m-%d-%y')AS short_date ,MONTH(d.date)AS dateMonth,DAYOFMONTH(d.date)AS dateDay,YEAR(d.date)AS dateYear ,CONCAT(d.date,' ',SEC_TO_TIME(TIME_TO_SEC(d.time_from)+(0*3600)))AS dateTXT ,DATE_FORMAT(d.date, '%m/%d/%Y')AS dateICSV ,d.time_from,d.time_duration ,(0+HOUR(d.time_from))AS dateHours,MINUTE(d.time_from)AS dateMin ,(0+HOUR(SEC_TO_TIME(TIME_TO_SEC(d.time_from)+TIME_TO_SEC(IF(d.time_duration='00:00:00',d.time_duration,d.time_duration)))))endHours ,MINUTE(SEC_TO_TIME(TIME_TO_SEC(d.time_from)+TIME_TO_SEC(IF(d.time_duration='00:00:00',d.time_duration,d.time_duration))))AS endMin ,TIME_FORMAT(SEC_TO_TIME(TIME_TO_SEC(d.time_from)+(0*3600)),'%r')AS startICSV ,TIME_FORMAT(SEC_TO_TIME(TIME_TO_SEC(d.time_from)+(0*3600)+TIME_TO_SEC(IF(d.time_duration='00:00:00','1:30', d.time_duration))),'%r')AS endICSV ,IF((s.season='Fall 2018' AND NOW()>'2019-03-01')OR(s.season RLIKE 'Winter 2018' AND NOW()>'2019-05-01'),1,0)AS skip ,IF(IF(w.ID=e.worksheet,w.dispFlag='T',1)AND(e.publish=1 OR w.dispflag='T'),1,0)AS publishedAlt,rel1.settingID as setNoTime ,if(away.master_school > 0 or h.master_school >0,1,0) as masterschool ,IF(ISNULL(bc.name),'',bc.name )AS busCompanyName ,a.ID as activity_id ,'86' AS Genie ,'`southernlakesconference`' AS dbName ,e.level AS eLevel,lev.name AS levName,d.date AS dDate,t.name AS tName,d.time_from AS dTime_from,e.gender AS eGender ,a.name AS aName,h.name AS hName,s.ID AS sID,e.type AS eType,e.event_type AS eEvent_type,e.home_school AS eHome_school ,e.away_schools AS eAway_school,e.location AS eLocation,d.ID AS dID ,e.recurring,d.cancelled as cancelled_recurring,d.postponed as postponed_recurring,d.changed as changed_recurring ,b.bus_leaves, b.bus_dismissal, b.bus_return, b.bus_notes, b.school AS bus_school, lsi.source_school_name ,dv.`name` AS division_name FROM southernlakesconference.LC_calendar_events e LEFT JOIN southernlakesconference.LC_schools AS sch ON sch.ID=IF(home_school IN(127,1117,1146,1317),home_school,IF(FIND_IN_SET('127',e.away_schools),127,IF(FIND_IN_SET('1117',e.away_schools),1117,IF(FIND_IN_SET('1146',e.away_schools),1146,IF(FIND_IN_SET('1317',e.away_schools),1317,0))))) LEFT JOIN southernlakesconference.LC_calendar_dates d ON e.ID=d.event_id LEFT JOIN southernlakesconference.LC_listings l ON e.location=l.ID LEFT JOIN southernlakesconference.LC_listings l1 ON d.locationDate=l1.ID LEFT JOIN southernlakesconference.LC_listings a ON e.activity=a.ID LEFT JOIN southernlakesconference.LC_listings_source_info lsi ON lsi.lc_listings_id=a.ID LEFT JOIN southernlakesconference.LC_listings t ON e.event_type=t.ID LEFT JOIN southernlakesconference.LC_listings lev ON e.level=lev.ID LEFT JOIN southernlakesconference.LC_listings ls ON e.schoolonly_location=ls.ID LEFT JOIN southernlakesconference.LC_listings opp ON e.away_schools=opp.ID LEFT JOIN southernlakesconference.LC_schools away ON e.away_schools=away.ID LEFT JOIN southernlakesconference.LC_schools h ON e.home_school=h.ID LEFT JOIN lakeconference.LC_seasons s ON e.season=s.ID LEFT JOIN southernlakesconference.LC_worksheets AS w ON e.worksheet=w.ID LEFT JOIN southernlakesconference.LC_bus_times AS b ON (b.event_id=e.id AND IF(b.lc_calendar_dates_id>0,b.lc_calendar_dates_id=d.ID,1)) AND IF('127'>'0',b.school IN(127),b.school=e.school) LEFT JOIN southernlakesconference.LC_bus_companies AS bc ON bc.ID=b.bus_company_id LEFT JOIN southernlakesconference.LC_comments AS cmt ON cmt.event_id=e.id AND cmt.school=0 left join southernlakesconference.rel_listings_settings rel1 on (rel1.listingID=e.event_type and rel1.settingID=1) LEFT JOIN lakeconference.CS_divisions dv ON e.division_id=dv.ID WHERE e.status='normal' AND e.publish>0 and ((e.activity=4 and e.gender=2 and e.level='6691') or (e.activity=4 and e.gender=2 and e.level='6692') or (e.activity=4 and e.gender=2 and e.level='199')) AND d.date>='2019-07-01' AND d.date<='2020-06-30' AND(IF(t.name>'' AND t.name IN('bye','opening day','start of season'),((((e.home_school IN(127,1117,1146,1317) OR IF(w.ID>'',w.school IN(127),e.school IN(127)) OR( (e.show_on_alias=1117 AND e.school IN(127,131))OR(e.show_on_alias=1146 AND e.school IN(131,126,127))OR(e.show_on_alias=1317 AND e.school IN(127)) )) )) OR ( FIND_IN_SET('127',e.away_schools) OR FIND_IN_SET('1117',e.away_schools) OR FIND_IN_SET('1146',e.away_schools) OR FIND_IN_SET('1317',e.away_schools) )),1)) AND IF(e.school>0,e.school IN(127) OR( (e.show_on_alias=1117 AND e.school IN(127,131))OR(e.show_on_alias=1146 AND e.school IN(131,126,127))OR(e.show_on_alias=1317 AND e.school IN(127)) ), ((((e.home_school IN(127,1117,1146,1317) OR IF(w.ID>'',w.school IN(127),e.school IN(127)) OR( (e.show_on_alias=1117 AND e.school IN(127,131))OR(e.show_on_alias=1146 AND e.school IN(131,126,127))OR(e.show_on_alias=1317 AND e.school IN(127)) )) ))OR( FIND_IN_SET('127',e.away_schools) OR FIND_IN_SET('1117',e.away_schools) OR FIND_IN_SET('1146',e.away_schools) OR FIND_IN_SET('1317',e.away_schools) )) ) AND IF(e.worksheet>0,w.status='normal',1) and (rel1.settingID is null or rel1.settingID=1) GROUP BY e.type,activity,gender,level,e.event_type,e.home_school,e.away_schools,d.date,d.time_from,d.ID ORDER BY dDate,IF(tName in ('bye','opening day','start of season'),'24:00:00',dTime_from),aName,IF(isnull(eGender),0,eGender),IF(isnull(eLevel),0,if(levName='All',1,if(levName='Varsity',2,if(levName='JV',3,if(levName regexp '^[a-zA-Z]',4,if(levName regexp '^1[0-9]',5,15-substring(levName,1,1))))))),IF(isnull(levName),0,levName)
HTTP/1.1 200 OK Date: Thu, 12 Dec 2019 08:49:56 GMT Server: Apache/1.3.42 (Unix) PHP/5.3.2 mod_perl/1.31 Set-Cookie: VISITORID=862165884815168048; path=/; expires=Thu, 12-Dec-2019 09:19:59 GMT Connection: close Transfer-Encoding: chunked Content-Type: text/html; charset=utf-8 1e1c4 Calendar Report
logo Waterford High School Waterford High School

Basketball Boys Multiple Levels Schedule

    (as of 12-12-19)
 
Activity Time  Opponent  Location  Leaves  Comments
Saturday, Nov 23, 2019
  Basketball: Boys JV2 Scrimmage 9:30AM  Away vs. Multiple Schools  Elkhorn Area High School  8:30AM     
 
  Basketball: Boys JV1 Scrimmage 11:30AM  Away vs. Multiple Schools  Elkhorn Area High School  8:30AM     
 
  Basketball: Boys Varsity Scrimmage 1:00PM  Away vs. Multiple Schools  Kettle Moraine High School  12:00PM     
 
Tuesday, Nov 26, 2019
  Basketball: Boys JV1 Game 5:30PM  Mukwonago  Waterford High School
Gym - Main
 
     
 
  Basketball: Boys JV2 Game 5:30PM  Mukwonago  Waterford High School
Gym - Old
 
     
 
  Basketball: Boys Varsity Game 7:00PM  Mukwonago  Waterford High School
Gym - Main
 
     
 
Thursday, Dec 5, 2019
  Basketball: Boys JV2 Game 4:15PM  Away vs. Shoreland Lutheran  Shoreland Lutheran High School  3:00PM     
 
  Basketball: Boys JV1 Game 5:30PM  Away vs. Shoreland Lutheran  Shoreland Lutheran High School  3:00PM     
 
  Basketball: Boys Varsity Game 7:00PM  Away vs. Shoreland Lutheran  Shoreland Lutheran High School  3:00PM     
 
Saturday, Dec 7, 2019
  Basketball: Boys JV1 Game 3:00PM  Away vs. Cudahy  Cudahy High School  1:15PM     
 
  Basketball: Boys JV2 Game 3:00PM  Away vs. Cudahy  Cudahy High School  1:15PM     
 
  Basketball: Boys Varsity Game 4:30PM  Away vs. Cudahy  Cudahy High School  1:15PM     
 
Tuesday, Dec 10, 2019
  Basketball: Boys JV1 Game 5:30PM  Away vs. Union Grove  Union Grove High School  4:30PM     
 
  Basketball: Boys JV2 Game 5:30PM  Away vs. Union Grove  Union Grove High School  4:30PM     
 
  Basketball: Boys Varsity Game 7:00PM  Away vs. Union Grove  Union Grove High School  4:30PM     
 
Friday, Dec 13, 2019
  Basketball: Boys JV2 Game 4:00PM  Elkhorn Area  Waterford High School
Gym - Main
 
     
 
 (Time Changed)
  Basketball: Boys JV1 Game 5:30PM  Elkhorn Area  Waterford High School
Gym - Main
 
     
 
  Basketball: Boys Varsity Game 7:00PM  Elkhorn Area  Waterford High School
Gym - Main
 
     
 
Tuesday, Dec 17, 2019
  Basketball: Boys JV2 Game 4:15PM  Away vs. St. Francis  St. Francis High School  2:45PM     
 
  Basketball: Boys JV1 Game 5:45PM  Away vs. St. Francis  St. Francis High School  2:45PM     
 
  Basketball: Boys Varsity Game 7:15PM  Away vs. St. Francis  St. Francis High School  2:45PM     
 
Thursday, Dec 19, 2019
  Basketball: Boys JV1 Game 5:30PM  Westosha Central  Waterford High School
Gym - Main
 
     
 
  Basketball: Boys JV2 Game 5:30PM  Westosha Central  Waterford High School
Gym - Old
 
     
 
  Basketball: Boys Varsity Game 7:00PM  Westosha Central  Waterford High School
Gym - Main
 
     
 
"Hero Night"
Friday, Jan 3, 2020
  Basketball: Boys JV2 Game 4:15PM  Away vs. Greendale  Greendale High School  3:00PM     
 
  Basketball: Boys JV1 Game 5:45PM  Away vs. Greendale  Greendale High School  3:00PM     
 
  Basketball: Boys Varsity Game 7:15PM  Away vs. Greendale  Greendale High School  3:00PM     
 
Saturday, Jan 4, 2020
  Basketball: Boys JV2 Game 11:15AM  Away vs. Burlington  Burlington High School       
 
Wednesday, Jan 8, 2020
  Basketball: Boys JV2 Game 4:00PM  Away vs. Milwaukee Ronald Reagan  Ronald Reagan High School  2:45PM     
 
  Basketball: Boys JV1 Game 5:30PM  Away vs. Milwaukee Ronald Reagan  Ronald Reagan High School  2:45PM     
 
  Basketball: Boys Varsity Game 7:00PM  Away vs. Milwaukee Ronald Reagan  Ronald Reagan High School  2:45PM     
 
Friday, Jan 10, 2020
  Basketball: Boys JV1 Doubleheader 4:00PM  Wilmot Union  Waterford High School
Gym - Main
 
     
 
  Basketball: Boys JV2 Doubleheader 5:30PM  Wilmot Union  Waterford High School
Gym - Old
 
     
 
  Basketball: Boys Varsity Doubleheader 7:00PM  Wilmot Union  Waterford High School
Gym - Main
 
     
 
"Youth Night"
Friday, Jan 17, 2020
  Basketball: Boys JV1 Game 4:00PM  Away vs. Burlington  Burlington High School  3:00PM     
 
  Basketball: Boys JV2 Game 5:00PM  Away vs. Burlington  Karcher Middle School  3:00PM     
 
  Basketball: Boys Varsity Game 7:00PM  Away vs. Burlington  Burlington High School  5:00PM     
 
Tuesday, Jan 21, 2020
  Basketball: Boys JV1 Game 5:30PM  Away vs. Badger High School  Badger High School  4:15PM     
 
  Basketball: Boys JV2 Game 5:30PM  Away vs. Badger High School  Badger High School  4:15PM     
 
  Basketball: Boys Varsity Game 7:00PM  Away vs. Badger High School  Badger High School  4:15PM     
 
Friday, Jan 24, 2020
  Basketball: Boys JV1 Doubleheader 4:00PM  Delavan-Darien  Waterford High School
Gym - Old
 
     
 
  Basketball: Boys JV2 Doubleheader 5:30PM  Delavan-Darien  Waterford High School
Gym - Old
 
     
 
  Basketball: Boys Varsity Doubleheader 7:00PM  Delavan-Darien  Waterford High School
Gym - Main
 
     
 
Tuesday, Jan 28, 2020
  Basketball: Boys JV1 Game 4:00PM  Union Grove  Waterford High School
Gym - Main
 
     
 
  Basketball: Boys JV2 Game 5:30PM  Union Grove  Waterford High School
Gym - Old
 
     
 
  Basketball: Boys Varsity Game 7:00PM  Union Grove  Waterford High School
Gym - Main
 
     
 
Friday, Jan 31, 2020
  Basketball: Boys JV1 Game 5:30PM  Away vs. Elkhorn Area  Elkhorn Area High School  4:15PM     
 
  Basketball: Boys JV2 Game 5:30PM  Away vs. Elkhorn Area  Elkhorn Area High School  4:15PM     
 
  Basketball: Boys Varsity Game 7:00PM  Away vs. Elkhorn Area  Elkhorn Area High School       
 
Monday, Feb 3, 2020
  Basketball: Boys JV1 Game 5:30PM  Hope Christian  Waterford High School
Gym - Main
 
     
 
  Basketball: Boys JV2 Game 5:30PM  Hope Christian  Waterford High School
Gym - Old
 
     
 
"Parent's Night"
  Basketball: Boys Varsity Game 7:00PM  Hope Christian  Waterford High School
Gym - Main
 
     
 
"Parent's Night"
Thursday, Feb 6, 2020
  Basketball: Boys JV2 Game 4:00PM  Away vs. Westosha Central  Westosha Central High School  3:00PM     
 
  Basketball: Boys JV1 Game 5:15PM  Away vs. Westosha Central  Westosha Central High School  3:00PM     
 
  Basketball: Boys Varsity Game 7:00PM  Away vs. Westosha Central  Westosha Central High School  3:00PM     
 
Friday, Feb 14, 2020
  Basketball: Boys JV1 Game 5:30PM  Away vs. Wilmot Union  Wilmot Union High School  4:15PM     
 
  Basketball: Boys JV2 Game 5:30PM  Away vs. Wilmot Union  Wilmot Union High School  4:15PM     
 
  Basketball: Boys Varsity Game 7:00PM  Away vs. Wilmot Union  Wilmot Union High School  4:15PM     
 
Saturday, Feb 15, 2020
  Basketball: Boys JV1 Game 3:00PM  Richmond (R.-Burton)  Waterford High School
Gym - Main
 
     
 
  Basketball: Boys JV2 Game 3:00PM  Richmond (R.-Burton)  Waterford High School
Gym - Old
 
     
 
  Basketball: Boys Varsity Game 4:30PM  Richmond (R.-Burton)  Waterford High School
Gym - Main
 
     
 
Tuesday, Feb 18, 2020
  Basketball: Boys JV1 Game 5:30PM  Badger High School  Waterford High School
Gym - Main
 
     
 
  Basketball: Boys JV2 Game 5:30PM  Badger High School  Waterford High School
Gym - Old
 
     
 
  Basketball: Boys Varsity Game 7:00PM  Badger High School  Waterford High School
Gym - Main
 
     
 
"Senior Night"
Friday, Feb 21, 2020
  Basketball: Boys JV1 Game 5:30PM  Burlington  Waterford High School
Gym - Main
 
     
 
  Basketball: Boys JV2 Game 5:30PM  Burlington  Waterford High School
Gym - Old
 
     
 
  Basketball: Boys Varsity Game 7:00PM  Burlington  Waterford High School
Gym - Main
 
     
 
Thursday, Feb 27, 2020
  Basketball: Boys JV1 Game 5:30PM  Away vs. Delavan-Darien  Delavan-Darien High School  4:00PM     
 
  Basketball: Boys JV2 Game 5:30PM  Away vs. Delavan-Darien  Delavan-Darien High School  4:00PM     
 
  Basketball: Boys Varsity Game 7:00PM  Away vs. Delavan-Darien  Delavan-Darien High School  4:00PM     
 
0