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 = 25 or Away.school_id_fk = 25) AND GameDate > '10/1/2014' ORDER BY GameDate, NEWTIME ASC, GameTime ASC Thu Oct 17 2013 07:00:00
  • SKA
    Sonics 
  • (10-2-0-0)
@

  • MSH
     
  • (5-7-0-0)
Result
Loss: 40-55
Tue Oct 22 2013 07:00:00
  • MSH
     
  • (5-7-0-0)
@

  • SHULAMITH-BK
    Cyclones 
  • (1-11-0-0)
Result
Loss: 14-38
Thu Oct 31 2013 07:15:00
  • MSH
     
  • (5-7-0-0)
@

  • ILAN
     
  • (8-3-0-0)
Result
Win: 49-19
Thu Nov 7 2013 07:00:00
  • SHAARE T.
    Stars 
  • (1-10-0-0)
@

  • MSH
     
  • (5-7-0-0)
Result
Win: 34-10
Tue Nov 19 2013 07:30:00
  • MSH
     
  • (5-7-0-0)
@

  • BRURIAH
    Lightning 
  • (10-2-0-0)
Result
Win: 36-16
Thu Nov 21 2013 07:15:00
  • SHULAMITH-BK
    Cyclones 
  • (1-11-0-0)
@

  • MSH
     
  • (5-7-0-0)
Result
Win: 1-0
Tue Nov 26 2013 07:15:00
  • ILAN
     
  • (8-3-0-0)
@

  • MSH
     
  • (5-7-0-0)
Result
Loss: 28-37
Thu Dec 12 2013 07:15:00
  • BRURIAH
    Lightning 
  • (10-2-0-0)
@

  • MSH
     
  • (5-7-0-0)
Result
Loss: 18-38
Thu Dec 26 2013 07:30:00
  • MAGEN DAVID
    Warriors 
  • (6-6-0-0)
@

  • MSH
     
  • (5-7-0-0)
Result
Win: 45-34
Tue Jan 7 2014 07:15:00
  • MSH
     
  • (5-7-0-0)
@

  • MAGEN DAVID
    Warriors 
  • (6-6-0-0)
Result
Win: 37-22
Tue Jan 28 2014 07:15:00
  • MSH
     
  • (5-7-0-0)
@

  • SHAARE T.
    Stars 
  • (1-10-0-0)
Result
Loss: 0-1
Sun Feb 9 2014 11:30:00
  • MSH
     
  • (5-7-0-0)
@

  • SKA
    Sonics 
  • (10-2-0-0)
Result
Win: 46-33
Sun Apr 6 2014 05:00:00
  • MSH
     
  • (2-6-0-0)
@

  • HANC
    Hurricanes 
  • (1-6-0-1)
Result
Loss: 5-9
Thu Apr 24 2014 06:15:00
  • CENTRAL
    WILDCATS 
  • (7-0-1-0)
@

  • MSH
     
  • (2-6-0-0)
Result
Loss: 0-22
Tue Apr 29 2014 06:00:00
  • SAR
     
  • (5-2-1-0)
@

  • MSH
     
  • (2-6-0-0)
Result
Loss: 0-22
Wed May 7 2014 06:00:00
  • MSH
     
  • (2-6-0-0)
@

  • SKA
     
  • (7-1-0-0)
Result
Win: 14-4
Tue May 13 2014 06:00:00
  • HAFTR
     
  • (2-6-0-0)
@

  • MSH
     
  • (2-6-0-0)
Result
Win: 4-3
Wed May 14 2014 06:30:00
  • MSH
     
  • (2-6-0-0)
@

  • WESTCHESTER
     
  • (1-7-0-0)
Result
Win: 14-12
Sun May 18 2014 11:00:00
  • MSH
     
  • (2-6-0-0)
@

  • FLATBUSH
     
  • (4-3-0-0)
Result
Win: 11-8
Tue May 20 2014 06:00:00
  • NORTH SHORE
     
  • (5-2-0-0)
@

  • MSH
     
  • (2-6-0-0)
Result
Loss: 0-9
Tue Oct 28 2014 06:15:00
  • SKA
    Sonics 
  • (12-0-0-0)
@

  • MSH
     
  • (6-6-0-0)
Result
Loss: 20-37
Thu Nov 6 2014 07:00:00
  • SHAARE T.
    Stars 
  • (2-10-0-0)
@

  • MSH
     
  • (6-6-0-0)
Result
Win: 36-10
Mon Nov 10 2014 07:30:00
  • MSH
     
  • (6-6-0-0)
@

  • BRURIAH
    Lightning 
  • (10-2-0-0)
Result
Win: 45-26
Mon Nov 17 2014 07:30:00
  • MSH
     
  • (6-6-0-0)
@

  • ILAN
     
  • (6-6-0-0)
Result
Win: 39-27
Tue Nov 18 2014 07:00:00
  • MSH
     
  • (6-6-0-0)
@

  • SHULAMITH-BK
    Cyclones 
  • (0-12-0-0)
Result
Loss: 16-53
Tue Dec 2 2014 07:00:00
  • SHULAMITH-BK
    Cyclones 
  • (0-12-0-0)
@

  • MSH
     
  • (6-6-0-0)
Result
Win: 35-26
Thu Dec 4 2014 07:00:00
  • MSH
     
  • (6-6-0-0)
@

  • SHAARE T.
    Stars 
  • (2-10-0-0)
Result
Loss: 29-34
Mon Dec 15 2014 07:30:00
  • MSH
     
  • (6-6-0-0)
@

  • MAGEN DAVID
    Warriors 
  • (6-6-0-0)
Result
Win: 38-30
Thu Dec 18 2014 07:30:00
  • ILAN
     
  • (6-6-0-0)
@

  • MSH
     
  • (6-6-0-0)
Result
Win: 35-33
Tue Dec 30 2014 06:15:00
  • MSH
     
  • (6-6-0-0)
@

  • SKA
    Sonics 
  • (12-0-0-0)
Result
Win: 46-32
Tue Jan 6 2015 07:30:00
  • MAGEN DAVID
    Warriors 
  • (6-6-0-0)
@

  • MSH
     
  • (6-6-0-0)
Result
Win: 53-29
Thu Feb 5 2015 07:30:00
  • BRURIAH
    Lightning 
  • (10-2-0-0)
@

  • MSH
     
  • (6-6-0-0)
Result
Loss: 21-49
Tue Feb 24 2015 07:30:00
  • MSH
     
  • (6-6-0-0)
@

  • MAGEN DAVID
    Warriors 
  • (6-6-0-0)
Result
Win: 19-17
Tue Feb 24 2015 07:30:00
  • ILAN
     
  • (6-6-0-0)
@

  • MSH
     
  • (6-6-0-0)
Result
Loss: 14-21
Fri Apr 24 2015 14:30:00
  • MSH
     
  • (2-6-0-0)
@

  • SKA
     
  • (5-3-0-0)
Result
Win: 6-1
Tue Apr 28 2015 18:00:00
  • WESTCHESTER
     
  • (5-3-0-0)
@

  • MSH
     
  • (2-6-0-0)
Result
Loss: 0-9
Wed Apr 29 2015 06:15:00
  • MSH
     
  • (2-6-0-0)
@

  • CENTRAL
    WILDCATS 
  • (4-4-0-0)
Result
Win: 17-9
Thu Apr 30 2015 18:00:00
  • HAFTR
     
  • (2-6-0-0)
@

  • MSH
     
  • (2-6-0-0)
Result
Win: 9-2
Tue May 5 2015 18:15:00
  • NORTH SHORE
     
  • (7-1-0-0)
@

  • MSH
     
  • (2-6-0-0)
Result
Loss: 0-18
Mon May 11 2015 18:30:00
  • MSH
     
  • (2-6-0-0)
@

  • FLATBUSH
     
  • (2-6-0-0)
Result
Win: 13-3
Tue May 12 2015 18:15:00
  • HANC
    Hurricanes 
  • (1-7-0-0)
@

  • MSH
     
  • (2-6-0-0)
Result
Win: 12-2
Thu May 14 2015 18:30:00
  • MSH
     
  • (2-6-0-0)
@

  • SAR
     
  • (8-0-0-0)
Result
Win: 19-1
Thu Nov 12 2015 07:00:00
  • MSH
    Sabers 
  • (8-4-0-0)
@

  • SHULAMITH-BK
    Cyclones 
  • (0-12-0-0)
Result
Loss: 12-51
Tue Nov 24 2015 07:45:00
  • BRURIAH
    Lightning 
  • (8-3-0-1)
@

  • MSH
    Sabers 
  • (8-4-0-0)
Result
Win: 35-23
Tue Dec 1 2015 07:00:00
  • SHULAMITH-BK
    Cyclones 
  • (0-12-0-0)
@

  • MSH
    Sabers 
  • (8-4-0-0)
Result
Win: 41-26
Thu Dec 3 2015 06:30:00
  • SKA
    Sonics 
  • (11-1-0-0)
@

  • MSH
    Sabers 
  • (8-4-0-0)
Result
Loss: 33-43
Tue Dec 8 2015 07:30:00
  • ILAN
     
  • (7-5-0-0)
@

  • MSH
    Sabers 
  • (8-4-0-0)
Result
Win: 46-26
Thu Dec 17 2015 07:15:00
  • MAGEN DAVID
    Warriors 
  • (2-10-0-0)
@

  • MSH
    Sabers 
  • (8-4-0-0)
Result
Win: 54-38
Mon Dec 28 2015 07:30:00
  • MSH
    Sabers 
  • (8-4-0-0)
@

  • MAGEN DAVID
    Warriors 
  • (2-10-0-0)
Result
Loss: 31-42
Mon Jan 4 2016 07:45:00
  • MSH
    Sabers 
  • (8-4-0-0)
@

  • BRURIAH
    Lightning 
  • (8-3-0-1)
Result
Loss: 33-34
Thu Jan 7 2016 06:30:00
  • MSH
    Sabers 
  • (8-4-0-0)
@

  • SKA
    Sonics 
  • (11-1-0-0)
Result
Win: 30-24
Thu Feb 4 2016 07:30:00
  • MSH
    Sabers 
  • (8-4-0-0)
@

  • ILAN
     
  • (7-5-0-0)
Result
Win: 57-36
Tue Feb 16 2016 07:00:00
  • SHULAMITH-BK
    Cyclones 
  • (0-12-0-0)
@

  • MSH
    Sabers 
  • (8-4-0-0)
Result
Win: 46-26
Thu Feb 18 2016 06:30:00
  • MSH
    Sabers 
  • (8-4-0-0)
@

  • SKA
    Sonics 
  • (11-1-0-0)
Result
Win: 42-23
Tue Mar 8 2016 08:00:00
  • BRURIAH
    Lightning 
  • (8-3-0-1)
@

  • MSH
    Sabers 
  • (8-4-0-0)
Result
Loss: 20-53
Sun Apr 10 2016 02:00:00
  • CENTRAL
    WILDCATS 
  • (8-0-0-0)
@

  • MSH
     
  • (4-4-0-0)
Result
Loss: 2-12
Thu Apr 14 2016 06:15:00
  • SKA
     
  • (6-2-0-0)
@

  • MSH
     
  • (4-4-0-0)
Result
Loss: 6-30
Mon May 9 2016 06:30:00
  • MSH
     
  • (4-4-0-0)
@

  • NORTH SHORE
     
  • (2-6-0-0)
Result
Loss: 6-8
Thu May 12 2016 06:00:00
  • FLATBUSH
     
  • (4-3-0-0)
@

  • MSH
     
  • (4-4-0-0)
Result
Loss: 4-16
Sun May 15 2016 10:30:00
  • MSH
     
  • (4-4-0-0)
@

  • HANC
    Hurricanes 
  • (0-8-0-0)
Result
Loss: 3-17
Sun May 15 2016 12:00:00
  • MSH
     
  • (4-4-0-0)
@

  • HANC
    Hurricanes 
  • (0-8-0-0)
Result
Loss: 17-21
Mon May 16 2016 05:15:00
  • MSH
     
  • (4-4-0-0)
@

  • WESTCHESTER
    Wildcats 
  • (6-1-0-0)
Result
Win: 9-1
Wed May 18 2016 06:00:00
  • MSH
     
  • (4-4-0-0)
@

  • HAFTR
     
  • (1-7-0-0)
Result
Loss: 0-1
Wed Nov 23 2016 06:30:00
  • SKA
    Sonics 
  • (12-0-0-0)
@

  • MSH
    Sabers 
  • (3-8-0-1)
Result
Loss: 21-52
Wed Nov 30 2016 06:30:00
  • MSH
    Sabers 
  • (3-8-0-1)
@

  • SKA
    Sonics 
  • (12-0-0-0)
Result
Win: 77-20
Wed Dec 7 2016 07:00:00
  • MSH
    Sabers 
  • (3-8-0-1)
@

  • SHAARE T. Girls
    STARS 
  • (0-12-0-0)
Result
Loss: 21-53
Mon Dec 12 2016 07:15:00
  • MSH
    Sabers 
  • (3-8-0-1)
@

  • SHAARE T. Girls
    STARS 
  • (0-12-0-0)
Result
Loss: 22-44
Wed Dec 14 2016 07:45:00
  • BRURIAH
    Lightning 
  • (10-2-0-0)
@

  • MSH
    Sabers 
  • (3-8-0-1)
Result
Loss: 18-38
Wed Dec 21 2016 07:15:00
  • SHAARE T. Girls
    STARS 
  • (0-12-0-0)
@

  • MSH
    Sabers 
  • (3-8-0-1)
Result
Win: 49-4
Thu Dec 22 2016 07:30:00
  • MSH
    Sabers 
  • (3-8-0-1)
@

  • ILAN
    Invaders 
  • (5-7-0-0)
Result
Win: 35-10
Thu Jan 5 2017 07:45:00
  • MSH
    Sabers 
  • (3-8-0-1)
@

  • BRURIAH
    Lightning 
  • (10-2-0-0)
Result
Win: 54-18
Mon Jan 9 2017 07:30:00
  • MSH
    Sabers 
  • (3-8-0-1)
@

  • MAGEN DAVID
    Warriors 
  • (6-6-0-0)
Result
Win: 56-27
Tue Jan 10 2017 07:30:00
  • MAGEN DAVID
    Warriors 
  • (6-6-0-0)
@

  • MSH
    Sabers 
  • (3-8-0-1)
Result
Loss: 44-46
Sun Feb 5 2017 03:00:00
  • SKA
    Sonics 
  • (12-0-0-0)
@

  • MSH
    Sabers 
  • (3-8-0-1)
Result
Loss: 26-42
Tue Feb 7 2017 07:30:00
  • ILAN
    Invaders 
  • (5-7-0-0)
@

  • MSH
    Sabers 
  • (3-8-0-1)
Result
Loss: 19-40
Sun Apr 2 2017 01:30:00
  • MSH
     
  • (1-7-0-0)
@

  • SKA
     
  • (8-0-0-0)
Result
Win: 12-1
Thu Apr 20 2017 05:45:00
  • SSLI
    LIONS 
  • (7-1-0-0)
@

  • MSH
     
  • (1-7-0-0)
Result
Loss: 1-27
Sun Apr 23 2017 04:15:00
  • MSH
     
  • (1-7-0-0)
@

  • FLATBUSH
     
  • (5-3-0-0)
Result
Win: 17-3
Thu Apr 27 2017 06:30:00
  • NORTH SHORE
     
  • (2-6-0-0)
@

  • MSH
     
  • (1-7-0-0)
Result
Loss: 0-13
Mon May 1 2017 06:30:00
  • MSH
     
  • (1-7-0-0)
@

  • NORTH SHORE
     
  • (2-6-0-0)
Result
Win: 13-10
Thu May 11 2017 06:30:00
  • MSH
     
  • (1-7-0-0)
@

  • CENTRAL
    WILDCATS 
  • (4-4-0-0)
Result
Win: 1-0
Tue May 16 2017 06:15:00
  • HANC
    Hurricanes 
  • (4-4-0-0)
@

  • MSH
     
  • (1-7-0-0)
Result
Loss: 1-4
Thu May 18 2017 06:15:00
  • WESTCHESTER
    Wildcats 
  • (1-7-0-0)
@

  • MSH
     
  • (1-7-0-0)
Result
Win: 8-1
Thu Nov 2 2017 06:15:00
  • SKA
    Sonics 
  • (8-4-0-0)
@

  • MSH
    Sabers 
  • (4-8-0-0)
Result
Loss: 12-38
Thu Nov 9 2017 07:30:00
  • SHULAMITH-LI
    Sparks 
  • (2-10-0-0)
@

  • MSH
    Sabers 
  • (4-8-0-0)
Result
Win: 33-17
Tue Nov 28 2017 07:00:00
  • SHAARE T. Girls
    Stars 
  • (0-12-0-0)
@

  • MSH
    Sabers 
  • (4-8-0-0)
Result
Win: 41-12
Thu Nov 30 2017 08:00:00
  • MSH
    Sabers 
  • (4-8-0-0)
@

  • MAGEN DAVID
    Warriors 
  • (8-4-0-0)
Result
Win: 37-8
Wed Dec 13 2017 07:00:00
  • MSH
    Sabers 
  • (4-8-0-0)
@

  • SHAARE T. Girls
    Stars 
  • (0-12-0-0)
Result
Loss: 15-33
Thu Dec 14 2017 07:30:00
  • MAGEN DAVID
    Warriors 
  • (8-4-0-0)
@

  • MSH
    Sabers 
  • (4-8-0-0)
Result
Loss: 31-53
Wed Dec 20 2017 07:30:00
  • MSH
    Sabers 
  • (4-8-0-0)
@

  • SHULAMITH-LI
    Sparks 
  • (2-10-0-0)
Result
Loss: 18-21
Wed Dec 27 2017 07:30:00
  • MSH
    Sabers 
  • (4-8-0-0)
@

  • BRURIAH
    Lightning 
  • (12-0-0-0)
Result
Win: 49-18
Wed Jan 3 2018 06:30:00
  • MSH
    Sabers 
  • (4-8-0-0)
@

  • SKA
    Sonics 
  • (8-4-0-0)
Result
Win: 55-15
Thu Feb 1 2018 07:30:00
  • BRURIAH
    Lightning 
  • (12-0-0-0)
@

  • MSH
    Sabers 
  • (4-8-0-0)
Result
Loss: 32-50
Thu Feb 8 2018 07:30:00
  • ILAN
    Invaders 
  • (8-4-0-0)
@

  • MSH
    Sabers 
  • (4-8-0-0)
Result
Loss: 19-52
Tue Feb 13 2018 06:30:00
  • MSH
    Sabers 
  • (4-8-0-0)
@

  • ILAN
    Invaders 
  • (8-4-0-0)
Result
Win: 45-15
Thu Apr 12 2018 06:15:00
  • MSH
    Sabers 
  • (0-8-0-0)
@

  • CENTRAL
    Wildcards 
  • (5-2-0-0)
Result
Win: 6-0
Tue Apr 17 2018 06:15:00
  • CENTRAL
    Wildcards 
  • (5-2-0-0)
@

  • MSH
    Sabers 
  • (0-8-0-0)
Result
Loss: 1-16
Fri Apr 20 2018 01:45:00
  • MSH
    Sabers 
  • (0-8-0-0)
@

  • SKA
    Sonics 
  • (7-1-0-0)
Result
Win: 11-0
Tue Apr 24 2018 06:30:00
  • NORTH SHORE
     
  • (2-6-0-0)
@

  • MSH
    Sabers 
  • (0-8-0-0)
Result
Loss: 4-6
Thu Apr 26 2018 06:30:00
  • MSH
    Sabers 
  • (0-8-0-0)
@

  • NORTH SHORE
     
  • (2-6-0-0)
Result
Win: 12-1
Fri May 4 2018 02:00:00
  • MSH
    Sabers 
  • (0-8-0-0)
@

  • FLATBUSH
    Falcons 
  • (4-3-0-0)
Result
Win: 10-0
Wed May 9 2018 06:15:00
  • MSH
    Sabers 
  • (0-8-0-0)
@

  • HANC
    Hurricanes 
  • (5-3-0-0)
Result
Win: 8-1
Thu May 10 2018 06:15:00
  • HANC
    Hurricanes 
  • (5-3-0-0)
@

  • MSH
    Sabers 
  • (0-8-0-0)
Result
Loss: 0-16

Click on game to see more info