SELECT G.GameID, GameDate, G.GameTime , G.HomeTeamID, G.AwayTeamID, Home.TeamName as Home, Away.TeamName as Away, Complete, G.HomeTeamResult, G.AwayTeamResult, G.HomeTeamScore, G.AwayTeamScore, Description, G.AMorPM, SH.school_name as HomeSchool , SA.school_name as AwaySchool, Home.short_name as HShort, Away.short_name as AShort, L.short_name, CASE WHEN AMorPM = 'PM' and GameTime < 12000 THEN GameTime +120005 ELSE GameTime +5 END as 'NEWTIME', L.LeagueName, sport_name, Away.school_id_fk as AwaySchools, Home.school_id_fk as HomeSchools , Home.logo as homelogo, Away.logo as awaylogo, S.sport_icon, RTA.ResultName as AwayResult, RTH.ResultName as HomeResult, Home.* From Games G Left Join Teams Home on Home.TeamID = HomeTeamID Left Join Teams Away on Away.TeamID = AwayTeamID Left Join Schools SH on SH.school_id = Home.school_id_fk Left Join Schools SA on SA.school_id = Away.school_id_fk LEFT JOIN Leagues L on L.LeagueID = G.LeagueID Left Join Sports S on S.sport_id = L.sport_id_fk LEFT JOIN ResultTypes RTH on HomeTeamResult = RTH.ResultTypeID LEFT JOIN ResultTypes RTA on AwayTeamResult = RTA.ResultTypeID Where G.is_deleted = 0 AND (Home.school_id_fk = 32 or Away.school_id_fk = 32) AND GameDate > '10/1/2014' ORDER BY GameDate, NEWTIME ASC, GameTime ASC Fri Apr 25 2014 01:00:00
  • MAY
     
  • (5-1-0-0)
@

  • RAMBAM
     
  • (2-4-0-0)
Result
Loss: 3-8
Fri May 2 2014 01:45:00
  • HAFTR
     
  • (7-1-0-0)
@

  • MAY
     
  • (7-1-0-0)
Result
Loss: 3-5
Fri May 2 2014 01:45:00 22:00:00
  • DRS
     
  • (5-1-0-0)
@

  • MAY
     
  • (5-1-0-0)
Result
Loss: 4-7
Fri May 2 2014 01:45:00 22:00:00
  • HAFTR
     
  • (7-1-0-0)
@

  • MAY
     
  • (7-1-0-0)
Result
Win: 7-6
Fri May 2 2014 01:00:00 22:00:00
  • DRS
     
  • (5-1-0-0)
@

  • MAY
     
  • (5-1-0-0)
Result
Win: 12-2
Sun May 4 2014 01:30:00 22:00:00
  • MAY
     
  • (7-1-0-0)
@

  • HANC
    Hurricanes 
  • (1-7-0-0)
Result
Loss: 9-13
Sun May 4 2014 01:30:00 22:00:00
  • MAY
     
  • (7-1-0-0)
@

  • HANC
    Hurricanes 
  • (1-7-0-0)
Result
Loss: 7-9
Fri May 9 2014 02:45:00 22:00:00
  • HANC
    Hurricanes 
  • (3-3-0-0)
@

  • MAY
     
  • (5-1-0-0)
Result
Win: 14-3
Fri May 9 2014 01:00:00 22:00:00
  • MAY
     
  • (7-1-0-0)
@

  • RAMBAM
     
  • (4-4-0-0)
Result
Loss: 1-5
Fri May 16 2014 01:30:00 22:00:00
  • HAFTR
     
  • (0-6-0-0)
@

  • MAY
     
  • (5-1-0-0)
Result
Win: 12-1
Fri May 16 2014 01:30:00 22:00:00
  • HAFTR
     
  • (0-6-0-0)
@

  • MAY
     
  • (5-1-0-0)
Result
Win: 13-3
Fri May 16 2014 01:00:00 22:00:00
  • DRS
     
  • (3-5-0-0)
@

  • MAY
     
  • (7-1-0-0)
Result
Win: 6-4
Mon May 19 2014 06:30:00 22:00:00
  • MAY
     
  • (7-1-0-0)
@

  • NORTH SHORE
     
  • (2-6-0-0)
Result
Loss: 2-12
Wed May 21 2014 06:15:00 22:00:00
  • MAY
     
  • (7-1-0-0)
@

  • DRS
     
  • (3-5-0-0)
Result
Loss: 2-7
Wed May 28 2014 06:30:00 22:00:00
  • FRISCH
     
  • (6-2-0-0)
@

  • MAY
     
  • (7-1-0-0)
Result
Win: 9-8
Fri May 30 2014 02:00:00 22:00:00
  • MAY
     
  • (7-1-0-0)
@

  • HAFTR
     
  • (7-1-0-0)
Result
Loss: 1-6
Fri May 30 2014 02:30:00 22:00:00
  • MAY
     
  • (5-1-0-0)
@

  • HILLEL
     
  • (5-1-0-0)
Result
Win: 5-0
Wed Jun 18 2014 05:00:00 22:00:00
  • YDE
     
  • (5-3-0-0)
@

  • MAY
     
  • (7-1-0-0)
Result
Win: 4-1
Fri Apr 24 2015 05:00:00 22:00:00
  • HAFTR
     
  • (6-2-0-0)
@

  • MAY
     
  • (7-1-0-0)
Result
Loss: 2-3
Fri Apr 24 2015 13:00:00 22:00:00
  • DRS
     
  • (5-0-1-0)
@

  • MAY
     
  • (4-2-0-0)
Result
Loss: 3-4
Fri Apr 24 2015 14:00:00 22:00:00
  • HAFTR
     
  • (6-2-0-0)
@

  • MAY
     
  • (7-1-0-0)
Result
Win: 9-6
Fri May 1 2015 14:00:00 22:00:00
  • MAY
     
  • (4-2-0-0)
@

  • RAMBAM
     
  • (1-5-0-0)
Result
Loss: 1-11
Fri May 1 2015 14:00:00 22:00:00
  • DRS
     
  • (1-7-0-0)
@

  • MAY
     
  • (7-1-0-0)
Result
Win: 13-3
Fri May 1 2015 13:00:00 22:00:00
  • MAY
     
  • (4-2-0-0)
@

  • RAMBAM
     
  • (1-5-0-0)
Result
Loss: 4-5
Fri May 1 2015 13:30:00 22:00:00
  • DRS
     
  • (1-7-0-0)
@

  • MAY
     
  • (7-1-0-0)
Result
Win: 10-0
Mon May 4 2015 18:30:00 22:00:00
  • MAY
     
  • (4-2-0-0)
@

  • HAFTR
     
  • (4-1-1-0)
Result
Win: 2-0
Fri May 8 2015 18:30:00 22:00:00
  • RAMBAM
     
  • (4-4-0-0)
@

  • MAY
     
  • (7-1-0-0)
Result
Win: 10-0
Fri May 8 2015 13:00:00 22:00:00
  • RAMBAM
     
  • (4-4-0-0)
@

  • MAY
     
  • (7-1-0-0)
Result
Win: 12-6
Tue May 12 2015 13:00:00 22:00:00
  • MAY
     
  • (4-2-0-0)
@

  • HANC
    Hurricanes 
  • (0-6-0-0)
Result
Loss: 1-5
Tue May 12 2015 13:00:00 22:00:00
  • MAY
     
  • (4-2-0-0)
@

  • HANC
    Hurricanes 
  • (0-6-0-0)
Result
Loss: 0-3
Wed May 13 2015 06:00:00 22:00:00
  • MAY
     
  • (7-1-0-0)
@

  • HANC
    Hurricanes 
  • (2-6-0-0)
Result
Loss: 0-8
Wed May 13 2015 06:00:00 22:00:00
  • MAY
     
  • (7-1-0-0)
@

  • HANC
    Hurricanes 
  • (2-6-0-0)
Result
Loss: 2-13
Tue May 26 2015 06:30:00 22:00:00
  • MAY
     
  • (4-2-0-0)
@

  • YDE
     
  • (4-2-0-0)
Result
Loss: 2-4
Wed May 27 2015 06:00:00 22:00:00
  • FRISCH
     
  • (5-3-0-0)
@

  • MAY
     
  • (7-1-0-0)
Result
Win: 3-2
Fri May 29 2015 01:00:00 22:00:00
  • MAY
     
  • (4-2-0-0)
@

  • DRS
     
  • (5-0-1-0)
Result
Loss: 3-7
Fri Jun 5 2015 01:30:00 22:00:00
  • SAR
     
  • (6-2-0-0)
@

  • MAY
     
  • (7-1-0-0)
Result
Win: 14-13
Fri Jun 5 2015 04:15:00 22:00:00
  • MAY
     
  • (4-2-0-0)
@

  • HAFTR
     
  • (4-1-1-0)
Result
Loss: 3-13
Fri Jun 19 2015 01:00:00 22:00:00
  • HILLEL
     
  • (6-2-0-0)
@

  • MAY
     
  • (7-1-0-0)
Result
Loss: 0-1
Fri Apr 8 2016 01:00:00 22:00:00
  • DRS
     
  • (3-1-0-1)
@

  • MAY
     
  • (5-1-0-0)
Result
Loss: 2-3
Fri Apr 8 2016 01:15:00 22:00:00
  • DRS
     
  • (3-1-0-1)
@

  • MAY
     
  • (5-1-0-0)
Result
Win: 9-5
Sun Apr 10 2016 04:00:00 22:00:00
  • MAY
     
  • (5-3-0-0)
@

  • DRS
     
  • (8-0-0-0)
Result
Win: 6-4
Fri Apr 15 2016 04:00:00 22:00:00
  • MAY
     
  • (5-1-0-0)
@

  • RAMBAM
     
  • (0-6-0-0)
Result
Loss: 1-8
Fri Apr 15 2016 02:00:00 22:00:00
  • HAFTR
     
  • (2-6-0-0)
@

  • MAY
     
  • (5-3-0-0)
Result
Win: 13-3
Fri Apr 15 2016 02:00:00 22:00:00
  • HAFTR
     
  • (2-6-0-0)
@

  • MAY
     
  • (5-3-0-0)
Result
Win: 13-5
Fri Apr 15 2016 01:15:00 22:00:00
  • RAMBAM
     
  • (0-6-0-0)
@

  • MAY
     
  • (5-1-0-0)
Result
Win: 11-1
Sun Apr 17 2016 01:00:00 22:00:00
  • MAY
     
  • (5-3-0-0)
@

  • HANC
    Hurricanes 
  • (5-3-0-0)
Result
Win: 6-3
Mon May 9 2016 06:40:00 22:00:00
  • HAFTR
     
  • (3-2-0-0)
@

  • MAY
     
  • (5-1-0-0)
Result
Win: 5-1
Fri May 13 2016 06:40:00 22:00:00
  • DARCHEI
     
  • (1-7-0-0)
@

  • MAY
     
  • (5-3-0-0)
Result
Win: 5-3
Fri May 13 2016 01:00:00 22:00:00
  • DARCHEI
     
  • (1-7-0-0)
@

  • MAY
     
  • (5-3-0-0)
Result
Loss: 2-5
Sun May 15 2016 01:30:00 22:00:00
  • RAMBAM
     
  • (3-5-0-0)
@

  • MAY
     
  • (5-3-0-0)
Result
Win: 13-4
Sun May 15 2016 01:30:00 22:00:00
  • RAMBAM
     
  • (3-5-0-0)
@

  • MAY
     
  • (5-3-0-0)
Result
Win: 9-8
Mon May 16 2016 06:40:00 22:00:00
  • HAFTR
     
  • (3-2-0-0)
@

  • MAY
     
  • (5-1-0-0)
Result
Win: 4-3
Fri May 20 2016 02:00:00 22:00:00
  • HAFTR
     
  • (3-2-0-0)
@

  • MAY
     
  • (5-1-0-0)
Result
Loss: 8-11
Fri May 20 2016 02:00:00 22:00:00
  • MAY
     
  • (5-3-0-0)
@

  • SHAARE T.
    Stars 
  • (8-0-0-0)
Result
Loss: 0-6
Fri Jun 3 2016 01:45:00 22:00:00
  • MAY
     
  • (5-3-0-0)
@

  • YDE
     
  • (5-3-0-0)
Result
Win: 4-3
Fri Apr 21 2017 02:15:00 22:00:00
  • HAFTR
     
  • (4-2-0-0)
@

  • MAY
     
  • (5-1-0-0)
Result
Loss: 0-4
Fri Apr 21 2017 02:15:00 22:00:00
  • HAFTR
     
  • (4-2-0-0)
@

  • MAY
     
  • (5-1-0-0)
Result
Win: 6-1
Fri Apr 28 2017 02:15:00 22:00:00
  • DRS
    wildcats  
  • (6-2-0-0)
@

  • MAY
     
  • (5-2-1-0)
Result
Loss: 4-6
Fri Apr 28 2017 01:30:00 22:00:00
  • DRS
     
  • (3-3-0-0)
@

  • MAY
     
  • (5-1-0-0)
Result
Win: 5-0
Fri Apr 28 2017 01:30:00 22:00:00
  • DRS
     
  • (3-3-0-0)
@

  • MAY
     
  • (5-1-0-0)
Result
Win: 7-2
Fri Apr 28 2017 01:00:00 22:00:00
  • DRS
    wildcats  
  • (6-2-0-0)
@

  • MAY
     
  • (5-2-1-0)
Result
Win: 7-4
Sun Apr 30 2017 01:30:00 22:00:00
  • MAY
     
  • (5-2-1-0)
@

  • HANC
    Hurricanes 
  • (0-8-0-0)
Result
Loss: 0-12
Sun Apr 30 2017 01:30:00 22:00:00
  • MAY
     
  • (5-2-1-0)
@

  • HANC
    Hurricanes 
  • (0-8-0-0)
Result
Loss: 1-6
Sun May 7 2017 01:30:00 22:00:00
  • MAY
     
  • (5-1-0-0)
@

  • RAMBAM
     
  • (0-6-0-0)
Result
Loss: 5-9
Sun May 7 2017 02:30:00 22:00:00
  • MAY
     
  • (5-1-0-0)
@

  • RAMBAM
     
  • (0-6-0-0)
Result
Loss: 10-12
Wed May 10 2017 06:30:00 22:00:00
  • MAY
     
  • (5-2-1-0)
@

  • HAFTR
     
  • (4-3-1-0)
Result
Tie: 3-3
Fri May 12 2017 03:15:00 22:00:00
  • DARCHEI
     
  • (4-4-0-0)
@

  • MAY
     
  • (5-2-1-0)
Result
Win: 5-0
Fri May 19 2017 03:15:00 22:00:00
  • RAMBAM
     
  • (4-4-0-0)
@

  • MAY
     
  • (5-2-1-0)
Result
Win: 9-4
Fri May 19 2017 01:00:00 22:00:00
  • RAMBAM
     
  • (4-4-0-0)
@

  • MAY
     
  • (5-2-1-0)
Result
Loss: 1-2
Thu May 25 2017 08:00:00 22:00:00
  • FRISCH
     
  • (3-3-0-0)
@

  • MAY
     
  • (5-1-0-0)
Result
Loss: 8-9
Mon May 29 2017 11:00:00 22:00:00
  • MAY
     
  • (5-2-1-0)
@

  • DRS
    wildcats  
  • (6-2-0-0)
Result
Loss: 7-10
Fri Jun 9 2017 01:30:00 22:00:00
  • MAY
     
  • (5-2-1-0)
@

  • YDE
     
  • (7-1-0-0)
Result
Win: 11-8
Mon Jan 1 2018 09:30:00 22:00:00
  • HAFTR
    HAWKS 
  • (1-6-1-0)
@

  • MAY
    May 
  • (1-6-1-0)
Result
Tie: 0-0
Mon Feb 26 2018 09:00:00 22:00:00
  • MAY
    May 
  • (1-6-1-0)
@

  • NORTH SHORE
    Stars 
  • (7-1-0-0)
Result
Win: 9-4
Tue Mar 6 2018 09:00:00 22:00:00
  • MAY
    May 
  • (1-6-1-0)
@

  • HAFTR
    HAWKS 
  • (1-6-1-0)
Result
Win: 10-9
Mon Mar 12 2018 07:00:00 22:00:00
  • MAY
    May 
  • (1-6-1-0)
@

  • DRS
    Wildcats 
  • (7-0-0-1)
Result
Win: 9-2
Tue Apr 10 2018 08:30:00 22:00:00
  • NORTH SHORE
    Stars 
  • (7-1-0-0)
@

  • MAY
    May 
  • (1-6-1-0)
Result
Loss: 3-10
Mon Apr 16 2018 07:00:00 22:00:00
  • DRS
    Wildcats 
  • (7-0-0-1)
@

  • MAY
    May 
  • (1-6-1-0)
Result
Loss: 4-11
Tue Apr 17 2018 08:45:00 22:00:00
  • MAY
    May 
  • (1-6-1-0)
@

  • HANC
    Hurricanes 
  • (6-2-0-0)
Result
Win: 10-2
Wed Apr 18 2018 06:15:00 22:00:00
  • MAY
     
  • (5-3-0-0)
@

  • HAFTR
    Hawks 
  • (4-4-0-0)
Result
Win: 11-1
Tue Apr 24 2018 08:00:00 22:00:00
  • RAMBAM
    Ravens 
  • (1-7-0-0)
@

  • MAY
    May 
  • (1-6-1-0)
Result
Win: 6-4
Fri Apr 27 2018 08:00:00 22:00:00
  • DRS
    Wildcats  
  • (6-2-0-0)
@

  • MAY
     
  • (5-3-0-0)
Result
Loss: 6-7
Fri Apr 27 2018 01:00:00 22:00:00
  • DRS
    Wildcats  
  • (6-2-0-0)
@

  • MAY
     
  • (5-3-0-0)
Result
Win: 8-2
Sun Apr 29 2018 02:00:00 22:00:00
  • MAY
    Eagles 
  • (3-3-0-0)
@

  • RAMBAM
     
  • (0-6-0-0)
Result
Loss: 1-2
Fri May 4 2018 02:00:00 22:00:00
  • DRS
    Wildcats 
  • (3-3-0-0)
@

  • MAY
    Eagles 
  • (3-3-0-0)
Result
Loss: 6-11
Fri May 4 2018 01:30:00 22:00:00
  • DRS
    Wildcats 
  • (3-3-0-0)
@

  • MAY
    Eagles 
  • (3-3-0-0)
Result
Win: 5-2
Fri May 4 2018 01:30:00 22:00:00
  • DARCHEI
     
  • (7-0-0-1)
@

  • MAY
     
  • (5-3-0-0)
Result
Loss: 4-10
Fri May 4 2018 01:00:00 22:00:00
  • DARCHEI
     
  • (7-0-0-1)
@

  • MAY
     
  • (5-3-0-0)
Result
Win: 5-3
Sun May 6 2018 01:15:00 22:00:00
  • MAY
     
  • (5-3-0-0)
@

  • HANC
    Hurricanes 
  • (0-8-0-0)
Result
Loss: 1-11
Wed May 9 2018 06:45:00 22:00:00
  • RAMBAM
     
  • (0-6-0-0)
@

  • MAY
    Eagles 
  • (3-3-0-0)
Result
Win: 5-3
Fri May 11 2018 06:45:00 22:00:00
  • MAY
    Eagles 
  • (3-3-0-0)
@

  • HAFTR
    Hawks 
  • (6-0-0-0)
Result
Win: 13-5
Fri May 11 2018 02:15:00 22:00:00
  • MAY
    Eagles 
  • (3-3-0-0)
@

  • HAFTR
    Hawks 
  • (6-0-0-0)
Result
Win: 18-0
Fri May 11 2018 03:00:00 22:00:00
  • MAY
     
  • (5-3-0-0)
@

  • HAFTR
    Hawks 
  • (4-4-0-0)
Result
Loss: 6-15
Fri May 11 2018 01:00:00 22:00:00
  • RAMBAM
     
  • (2-6-0-0)
@

  • MAY
     
  • (5-3-0-0)
Result
Win: 5-2
Wed May 30 2018 05:45:00 22:00:00
  • MAY
    Eagles 
  • (3-3-0-0)
@

  • FRISCH
    Cougars 
  • (6-0-0-0)
Result
Win: 7-1
Fri Jun 1 2018 02:00:00 22:00:00
  • MAY
     
  • (5-3-0-0)
@

  • YDE
    Thunder 
  • (7-1-0-0)
Result
Win: 8-4

Click on game to see more info