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 = 5 or Away.school_id_fk = 5) AND GameDate > '10/1/2014' ORDER BY GameDate, NEWTIME ASC, GameTime ASC Tue Nov 5 2013 07:30:00
  • EZRA
     
  • (0-10-0-0)
@

  • DRS
    Wildcats 
  • (10-0-0-0)
Result
Win: 60-17
Mon Nov 25 2013 08:10:00
  • HANC
    Hurricanes 
  • (7-3-0-0)
@

  • EZRA
     
  • (0-10-0-0)
Result
Loss: 21-52
Mon Dec 2 2013 08:15:00
  • NORTH SHORE
    Stars 
  • (3-7-0-0)
@

  • EZRA
     
  • (0-10-0-0)
Result
Loss: 0-1
Mon Dec 9 2013 08:15:00
  • RAMBAM
    Ravens 
  • (4-6-0-0)
@

  • EZRA
     
  • (0-10-0-0)
Result
Loss: 24-48
Wed Dec 11 2013 08:15:00
  • EZRA
     
  • (0-10-0-0)
@

  • NORTH SHORE
    Stars 
  • (3-7-0-0)
Result
Win: 1-0
Sat Dec 14 2013 07:30:00
  • EZRA
     
  • (0-10-0-0)
@

  • RAMBAM
    Ravens 
  • (4-6-0-0)
Result
Win: 1-0
Mon Dec 16 2013 07:30:00
  • EZRA
     
  • (0-10-0-0)
@

  • HANC
    Hurricanes 
  • (7-3-0-0)
Result
Win: 55-31
Mon Dec 23 2013 07:00:00
  • EZRA
     
  • (0-10-0-0)
@

  • DRS
    Wildcats 
  • (10-0-0-0)
Result
Win: 1-0
Mon Jan 6 2014 08:15:00
  • HAFTR
    Hawks 
  • (6-4-0-0)
@

  • EZRA
     
  • (0-10-0-0)
Result
Loss: 0-1
Thu Jan 30 2014 08:15:00 22:00:00
  • EZRA
     
  • (0-10-0-0)
@

  • HAFTR
    Hawks 
  • (6-4-0-0)
Result
Win: 1-0
Mon Mar 3 2014 08:00:00 22:00:00
  • SAR
    Sting 
  • (8-0-0-0)
@

  • EZRA
     
  • (0-8-0-0)
Result
Loss: 3-10
Mon Mar 10 2014 08:00:00 22:00:00
  • RAMAZ
     
  • (2-6-0-0)
@

  • EZRA
     
  • (0-8-0-0)
Result
Loss: 3-10
Mon Mar 17 2014 08:00:00 22:00:00
  • MAGEN DAVID
     
  • (5-3-0-0)
@

  • EZRA
     
  • (0-8-0-0)
Result
Loss: 1-8
Tue Mar 25 2014 07:15:00 22:00:00
  • EZRA
     
  • (0-8-0-0)
@

  • MAGEN DAVID
     
  • (5-3-0-0)
Result
Win: 8-1
Thu Apr 3 2014 07:30:00 22:00:00
  • EZRA
     
  • (0-8-0-0)
@

  • FLATBUSH
    Falcons 
  • (3-5-0-0)
Result
Win: 8-1
Wed Apr 9 2014 07:30:00 22:00:00
  • EZRA
     
  • (0-8-0-0)
@

  • MTA
    Lions 
  • (6-2-0-0)
Result
Win: 9-2
Mon Apr 28 2014 08:00:00 22:00:00
  • FLATBUSH
    Falcons 
  • (3-5-0-0)
@

  • EZRA
     
  • (0-8-0-0)
Result
Loss: 1-8
Thu May 1 2014 06:45:00 22:00:00
  • EZRA
     
  • (0-8-0-0)
@

  • RAMAZ
     
  • (2-6-0-0)
Result
Win: 9-2
Mon Oct 27 2014 08:15:00 22:00:00
  • HANC
    Hurricanes 
  • (4-6-0-0)
@

  • EZRA
     
  • (0-10-0-0)
Result
Loss: 34-52
Mon Nov 10 2014 08:15:00 22:00:00
  • YDE
    Thunder 
  • (4-6-0-0)
@

  • EZRA
     
  • (0-10-0-0)
Result
Loss: 32-62
Mon Nov 17 2014 08:15:00 22:00:00
  • MAGEN DAVID
    Warriors 
  • (3-7-0-0)
@

  • EZRA
     
  • (0-10-0-0)
Result
Loss: 58-73
Mon Nov 24 2014 08:00:00 22:00:00
  • EZRA
     
  • (0-10-0-0)
@

  • SHAARE T.
    Stars 
  • (3-7-0-0)
Result
Win: 70-41
Mon Dec 1 2014 07:00:00 22:00:00
  • EZRA
     
  • (0-10-0-0)
@

  • FLATBUSH
    Falcons 
  • (10-0-0-0)
Result
Win: 74-31
Tue Dec 9 2014 06:30:00 22:00:00
  • EZRA
     
  • (0-10-0-0)
@

  • NORTH SHORE
    Stars 
  • (8-2-0-0)
Result
Win: 76-32
Mon Dec 15 2014 08:15:00 22:00:00
  • RAMBAM
    Ravens 
  • (4-6-0-0)
@

  • EZRA
     
  • (0-10-0-0)
Result
Loss: 32-52
Thu Dec 25 2014 08:00:00 22:00:00
  • EZRA
     
  • (0-10-0-0)
@

  • RAMBAM
    Ravens 
  • (4-6-0-0)
Result
Win: 58-32
Tue Dec 30 2014 07:00:00 22:00:00
  • EZRA
     
  • (0-10-0-0)
@

  • DRS
    Wildcats 
  • (5-5-0-0)
Result
Win: 64-23
Mon Jan 5 2015 08:15:00 22:00:00
  • HAFTR
    Hawks 
  • (9-1-0-0)
@

  • EZRA
     
  • (0-10-0-0)
Result
Loss: 42-74
Wed Mar 18 2015 06:45:00 22:00:00
  • EZRA
     
  • (1-6-1-0)
@

  • RAMAZ
     
  • (2-5-1-0)
Result
Win: 9-4
Wed Mar 25 2015 07:30:00 22:00:00
  • EZRA
     
  • (1-6-1-0)
@

  • MTA
    Lions 
  • (7-1-0-0)
Result
Win: 11-6
Mon Mar 30 2015 08:00:00 22:00:00
  • SAR
    Sting 
  • (8-0-0-0)
@

  • EZRA
     
  • (1-6-1-0)
Result
Loss: 1-8
Tue Mar 31 2015 06:45:00 22:00:00
  • EZRA
     
  • (1-6-1-0)
@

  • FLATBUSH
    Falcons 
  • (3-4-0-1)
Result
Win: 10-4
Mon Apr 20 2015 08:00:00 22:00:00
  • RAMAZ
     
  • (2-5-1-0)
@

  • EZRA
     
  • (1-6-1-0)
Result
Tie: 3-3
Mon Apr 27 2015 08:00:00 22:00:00
  • MTA
    Lions 
  • (7-1-0-0)
@

  • EZRA
     
  • (1-6-1-0)
Result
Loss: 3-7
Wed Apr 29 2015 07:30:00 22:00:00
  • EZRA
     
  • (1-6-1-0)
@

  • SAR
    Sting 
  • (8-0-0-0)
Result
Win: 9-2
Mon May 4 2015 07:30:00 22:00:00
  • EZRA
     
  • (1-6-1-0)
@

  • MAGEN DAVID
     
  • (2-5-0-1)
Result
Loss: 8-15
Wed Oct 28 2015 07:00:00 22:00:00
  • EZRA
     
  • (1-9-0-0)
@

  • FLATBUSH
    Falcons 
  • (5-4-0-1)
Result
Win: 56-26
Mon Nov 2 2015 08:15:00 22:00:00
  • NORTH SHORE
    Stars 
  • (4-6-0-0)
@

  • EZRA
     
  • (1-9-0-0)
Result
Loss: 17-57
Thu Nov 12 2015 07:30:00 22:00:00
  • EZRA
     
  • (1-9-0-0)
@

  • D. HATORAH
     
  • (6-4-0-0)
Result
Win: 56-43
Mon Nov 16 2015 08:00:00 22:00:00
  • DRS
    Wildcats 
  • (10-0-0-0)
@

  • EZRA
     
  • (1-9-0-0)
Result
Loss: 18-78
Mon Nov 23 2015 06:30:00 22:00:00
  • EZRA
     
  • (1-9-0-0)
@

  • HAFTR
    Hawks 
  • (8-2-0-0)
Result
Win: 74-40
Mon Nov 30 2015 08:15:00 22:00:00
  • RAMBAM
    Ravens 
  • (2-7-0-1)
@

  • EZRA
     
  • (1-9-0-0)
Result
Loss: 30-50
Tue Dec 15 2015 08:00:00 22:00:00
  • EZRA
     
  • (1-9-0-0)
@

  • MAGEN DAVID
    Warriors 
  • (8-2-0-0)
Result
Win: 84-37
Mon Dec 28 2015 08:15:00 22:00:00
  • SHAARE T.
    Stars 
  • (0-10-0-0)
@

  • EZRA
     
  • (1-9-0-0)
Result
Win: 45-37
Mon Jan 4 2016 08:15:00 22:00:00
  • HANC
    Hurricanes 
  • (7-1-0-2)
@

  • EZRA
     
  • (1-9-0-0)
Result
Loss: 22-57
Thu Feb 4 2016 07:30:00 22:00:00
  • EZRA
     
  • (1-9-0-0)
@

  • YDE
    Thunder 
  • (4-6-0-0)
Result
Win: 70-32
Mon Mar 7 2016 08:00:00 22:00:00
  • YDE
     
  • (1-7-0-0)
@

  • EZRA
     
  • (2-5-1-0)
Result
Loss: 4-5
Thu Mar 10 2016 08:30:00 22:00:00
  • EZRA
     
  • (2-5-1-0)
@

  • YDE
     
  • (1-7-0-0)
Result
Loss: 3-7
Thu Mar 17 2016 07:30:00 22:00:00
  • EZRA
     
  • (2-5-1-0)
@

  • MAGEN DAVID
    Warriors 
  • (6-2-0-0)
Result
Win: 8-1
Mon Mar 21 2016 08:00:00 22:00:00
  • FLATBUSH
     
  • (5-2-1-0)
@

  • EZRA
     
  • (2-5-1-0)
Result
Loss: 0-7
Mon Mar 28 2016 08:00:00 22:00:00
  • NORTH SHORE
    Stars 
  • (2-4-2-0)
@

  • EZRA
     
  • (2-5-1-0)
Result
Loss: 0-3
Mon Apr 4 2016 08:00:00 22:00:00
  • MAGEN DAVID
    Warriors 
  • (6-2-0-0)
@

  • EZRA
     
  • (2-5-1-0)
Result
Loss: 2-6
Sun Apr 10 2016 10:00:00 22:00:00
  • EZRA
     
  • (2-5-1-0)
@

  • FRISCH
    Cougars 
  • (2-5-1-0)
Result
Loss: 5-6
Thu Apr 14 2016 06:30:00 22:00:00
  • EZRA
     
  • (2-5-1-0)
@

  • FLATBUSH
     
  • (5-2-1-0)
Result
Tie: 6-6
Thu Nov 10 2016 07:30:00 22:00:00
  • EZRA
     
  • (0-10-0-0)
@

  • DRS
    Wildcats 
  • (7-3-0-0)
Result
Win: 81-28
Tue Nov 15 2016 08:15:00 22:00:00
  • EZRA
     
  • (0-10-0-0)
@

  • NORTH SHORE
    Stars 
  • (6-4-0-0)
Result
Win: 70-25
Mon Nov 21 2016 08:00:00 22:00:00
  • FLATBUSH
    Falcons 
  • (5-5-0-0)
@

  • EZRA
     
  • (0-10-0-0)
Result
Loss: 16-69
Tue Nov 22 2016 07:00:00 22:00:00
  • EZRA
     
  • (0-10-0-0)
@

  • RAMBAM
    Ravens 
  • (3-7-0-0)
Result
Win: 57-26
Mon Nov 28 2016 08:00:00 22:00:00
  • MAGEN DAVID
    Warriors 
  • (9-1-0-0)
@

  • EZRA
     
  • (0-10-0-0)
Result
Loss: 20-89
Mon Dec 12 2016 08:00:00 22:00:00
  • HAFTR
    Hawks 
  • (8-2-0-0)
@

  • EZRA
     
  • (0-10-0-0)
Result
Loss: 24-64
Wed Dec 21 2016 07:30:00 22:00:00
  • EZRA
     
  • (0-10-0-0)
@

  • SHAARE T.
    Stars 
  • (2-8-0-0)
Result
Win: 66-33
Mon Jan 9 2017 08:15:00 22:00:00
  • YDE
    Thunder 
  • (6-4-0-0)
@

  • EZRA
     
  • (0-10-0-0)
Result
Loss: 0-1
Mon Feb 6 2017 08:00:00 22:00:00
  • WESTCHESTER
    Wildcats 
  • (1-9-0-0)
@

  • EZRA
     
  • (0-10-0-0)
Result
Loss: 40-56
Tue Feb 7 2017 07:00:00 22:00:00
  • EZRA
     
  • (0-10-0-0)
@

  • HANC
    Hurricanes 
  • (7-3-0-0)
Result
Win: 65-25
Mon Mar 6 2017 08:00:00 22:00:00
  • EZRA
     
  • (0-6-2-0)
@

  • MAGEN DAVID
     
  • (4-3-1-0)
Result
Win: 10-3
Thu Mar 16 2017 07:00:00 22:00:00
  • EZRA
     
  • (0-6-2-0)
@

  • FLATBUSH
    Falcons 
  • (6-2-0-0)
Result
Win: 7-0
Thu Mar 23 2017 06:45:00 22:00:00
  • EZRA
     
  • (0-6-2-0)
@

  • YDE
    Thunder 
  • (1-6-1-0)
Result
Win: 10-3
Mon Mar 27 2017 06:45:00 22:00:00
  • EZRA
     
  • (0-6-2-0)
@

  • YDE
    Thunder 
  • (1-6-1-0)
Result
Tie: 12-12
Wed Apr 5 2017 07:00:00 22:00:00
  • EZRA
     
  • (0-6-2-0)
@

  • FLATBUSH
    Falcons 
  • (6-2-0-0)
Result
Win: 7-0
Mon Apr 24 2017 08:00:00 22:00:00
  • EZRA
     
  • (0-6-2-0)
@

  • MTA
    Lions 
  • (8-0-0-0)
Result
Win: 9-2
Wed Apr 26 2017 06:45:00 22:00:00
  • EZRA
     
  • (0-6-2-0)
@

  • RAMAZ
     
  • (1-6-1-0)
Result
Win: 9-2
Mon May 8 2017 08:00:00 22:00:00
  • EZRA
     
  • (0-6-2-0)
@

  • MAGEN DAVID
     
  • (4-3-1-0)
Result
Tie: 0-0
Tue Oct 24 2017 08:00:00 22:00:00
  • NORTH SHORE
    Stars 
  • (7-3-0-0)
@

  • EZRA
    Ezra Academy 
  • (0-10-0-0)
Result
Loss: 28-71
Mon Oct 30 2017 09:00:00 22:00:00
  • EZRA
    Ezra Academy 
  • (0-10-0-0)
@

  • SHAARE T.
    Stars 
  • (8-2-0-0)
Result
Win: 81-35
Thu Nov 2 2017 08:00:00 22:00:00
  • EZRA
    Ezra Academy 
  • (0-10-0-0)
@

  • HAFTR
    Hawks 
  • (9-0-0-1)
Result
Win: 84-20
Thu Nov 9 2017 08:30:00 22:00:00
  • EZRA
    Ezra Academy 
  • (0-10-0-0)
@

  • FLATBUSH
    Falcons 
  • (3-7-0-0)
Result
Win: 58-14
Tue Nov 14 2017 08:00:00 22:00:00
  • RAMBAM
    Ravens 
  • (1-9-0-0)
@

  • EZRA
    Ezra Academy 
  • (0-10-0-0)
Result
Loss: 32-45
Mon Dec 4 2017 07:00:00 22:00:00
  • EZRA
    Ezra Academy 
  • (0-10-0-0)
@

  • YDE
    Thunder 
  • (5-5-0-0)
Result
Win: 62-28
Sun Dec 10 2017 12:30:00 22:00:00
  • EZRA
    Ezra Academy 
  • (0-10-0-0)
@

  • HANC
    Hurricanes 
  • (4-6-0-0)
Result
Win: 71-19
Tue Jan 2 2018 08:00:00 22:00:00
  • DRS
    Wildcats 
  • (7-3-0-0)
@

  • EZRA
    Ezra Academy 
  • (0-10-0-0)
Result
Loss: 15-84
Tue Jan 9 2018 08:00:00 22:00:00
  • EZRA
    Ezra Academy 
  • (0-10-0-0)
@

  • MAGEN DAVID
    Warriors 
  • (6-4-0-0)
Result
Win: 1-0
Tue Feb 6 2018 08:00:00 22:00:00
  • SHAARE T.
    Stars 
  • (8-2-0-0)
@

  • EZRA
    Ezra Academy 
  • (0-10-0-0)
Result
Loss: 0-1

Click on game to see more info