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 = 41 or Away.school_id_fk = 41) AND GameDate > '10/1/2014' ORDER BY GameDate, NEWTIME ASC, GameTime ASC Tue Oct 24 2017 07:30:00
  • WATERBURY
    Wolfpack 
  • (8-6-0-0)
@

  • KUSHNER
    Cobras 
  • (3-11-0-0)
Result
Loss: 30-39
Wed Oct 25 2017 07:30:00
  • FRISCH
    Cougars 
  • (13-1-0-0)
@

  • WATERBURY
    Wolfpack 
  • (8-6-0-0)
Result
Loss: 44-68
Mon Oct 30 2017 07:30:00
  • WATERBURY
    Wolfpack 
  • (8-6-0-0)
@

  • TABC
    Storm 
  • (8-6-0-0)
Result
Win: 58-44
Wed Nov 1 2017 07:30:00
  • WATERBURY
    Wolfpack 
  • (8-6-0-0)
@

  • HESCHEL
    Heat 
  • (8-4-0-2)
Result
Win: 51-44
Thu Nov 9 2017 07:30:00
  • WATERBURY
    Wolfpack 
  • (8-6-0-0)
@

  • JEC
    Thunder 
  • (6-8-0-0)
Result
Loss: 41-64
Sun Nov 12 2017 01:00:00
  • WATERBURY
    Wolfpack 
  • (8-6-0-0)
@

  • NORTH SHORE
    Stars 
  • (6-7-0-1)
Result
Overtime Loss: 76-78
Wed Nov 15 2017 07:30:00
  • HILLEL
    Heat 
  • (2-12-0-0)
@

  • WATERBURY
    Wolfpack 
  • (8-6-0-0)
Result
Win: 52-33
Thu Nov 30 2017 07:30:00
  • WATERBURY
    Wolfpack 
  • (8-6-0-0)
@

  • SAR
    Sting 
  • (13-1-0-0)
Result
Win: 62-45
Sun Dec 3 2017 01:30:00
  • WATERBURY
    Wolfpack 
  • (8-6-0-0)
@

  • RAMAZ
    Rams 
  • (8-6-0-0)
Result
Win: 69-60
Thu Dec 7 2017 07:30:00
  • WATERBURY
    Wolfpack 
  • (8-6-0-0)
@

  • MTA
    Lions 
  • (5-7-0-2)
Result
Loss: 26-42
Thu Dec 21 2017 07:30:00
  • WATERBURY
    Wolfpack 
  • (8-6-0-0)
@

  • HILLEL
    Heat 
  • (2-12-0-0)
Result
Loss: 39-53
Wed Dec 27 2017 07:30:00
  • WATERBURY
    Wolfpack 
  • (8-6-0-0)
@

  • RAMBAM
    Ravens 
  • (9-5-0-0)
Result
Loss: 47-50
Tue Jan 23 2018 07:30:00
  • WATERBURY
    Wolfpack 
  • (8-6-0-0)
@

  • SAR
    Sting 
  • (13-1-0-0)
Result
Win: 48-38
Mon Feb 5 2018 07:30:00
  • WATERBURY
    Wolfpack 
  • (8-6-0-0)
@

  • KUSHNER
    Cobras 
  • (3-11-0-0)
Result
Loss: 35-54
Thu Feb 15 2018 08:00:00
  • WATERBURY
    Wolfpack 
  • (8-6-0-0)
@

  • TABC
    Storm 
  • (8-6-0-0)
Result
Loss: 50-56
Tue Feb 27 2018 08:15:00
  • WATERBURY
    Wolfpack 
  • (8-6-0-0)
@

  • MAGEN DAVID
    Warriors 
  • (14-0-0-0)
08:15
  • 2130 Mcdonald Ave
  • bet S & T
  • Brooklyn, NY 11223
  • Map it!

Click on game to see more info