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)
Result
Win: 61-52
Thu Oct 25 2018 07:15:00
  • WATERBURY
    Wolfpack 
  • (6-8-0-0)
@

  • HESCHEL
    Heat 
  • (10-4-0-0)
Result
Win: 64-55
Mon Oct 29 2018 07:30:00
  • WATERBURY
    Wolfpack 
  • (6-8-0-0)
@

  • TABC
    Storm 
  • (10-4-0-0)
Result
Loss: 38-52
Wed Oct 31 2018 07:30:00
  • WATERBURY
    Wolfpack 
  • (6-8-0-0)
@

  • JEC
    Thunder 
  • (8-6-0-0)
Result
Loss: 52-71
Thu Nov 8 2018 07:15:00
  • RAMAZ
    Rams 
  • (4-8-0-2)
@

  • WATERBURY
    Wolfpack 
  • (6-8-0-0)
Result
Loss: 40-55
Sat Nov 10 2018 08:15:00
  • WATERBURY
    Wolfpack 
  • (6-8-0-0)
@

  • SAR
    Sting 
  • (9-5-0-0)
Result
Win: 54-53
Tue Nov 20 2018 08:00:00
  • HILLEL
    Heat 
  • (3-11-0-0)
@

  • WATERBURY
    Wolfpack 
  • (6-8-0-0)
Result
Loss: 58-67
Sat Dec 1 2018 08:30:00
  • JEC
    Thunder 
  • (8-6-0-0)
@

  • WATERBURY
    Wolfpack 
  • (6-8-0-0)
Result
Win: 54-47
Sun Dec 16 2018 02:00:00
  • WATERBURY
    Wolfpack 
  • (6-8-0-0)
@

  • MTA
    Lions 
  • (6-8-0-0)
Result
Win: 51-36
Wed Dec 19 2018 08:15:00
  • WATERBURY
    Wolfpack 
  • (6-8-0-0)
@

  • RAMAZ
    Rams 
  • (4-8-0-2)
Result
Win: 61-48
Thu Dec 27 2018 09:00:00
  • WATERBURY
    Wolfpack 
  • (6-8-0-0)
@

  • YDE
    Thunder 
  • (7-7-0-0)
Result
Loss: 54-61
Wed Jan 2 2019 07:30:00
  • WATERBURY
    Wolfpack 
  • (6-8-0-0)
@

  • KUSHNER
    Cobras 
  • (5-8-0-1)
Result
Win: 45-37
Thu Jan 31 2019 08:00:00
  • WATERBURY
    Wolfpack 
  • (6-8-0-0)
@

  • FRISCH
    Cougars 
  • (11-3-0-0)
Result
Win: 56-51
Mon Feb 4 2019 08:00:00
  • WATERBURY
    Wolfpack 
  • (6-8-0-0)
@

  • NORTH SHORE
    Stars 
  • (7-7-0-0)
Result
Loss: 47-48
Tue Feb 5 2019 08:00:00
  • WATERBURY
    Wolfpack 
  • (6-8-0-0)
@

  • HILLEL
    Heat 
  • (3-11-0-0)
Result
Loss: 46-59
Tue Oct 29 2019 07:30:00
  • WATERBURY
    Wolfpack 
  • (4-10-0-0)
@

  • TABC
    Storm 
  • (10-4-0-0)
Result
Win: 49-42
Thu Oct 31 2019 07:30:00
  • WATERBURY
    Wolfpack 
  • (4-10-0-0)
@

  • SAR
    Sting 
  • (8-6-0-0)
Result
Loss: 45-52
Sun Nov 3 2019 06:00:00
  • WATERBURY
    Wolfpack 
  • (4-10-0-0)
@

  • HESCHEL
    Heat 
  • (11-2-0-1)
Result
Win: 65-38
Mon Nov 18 2019 07:00:00
  • WATERBURY
    Wolfpack 
  • (4-10-0-0)
@

  • SHAARE T.
    Stars 
  • (11-3-0-0)
Result
Win: 80-69
Wed Nov 20 2019 08:15:00
  • WATERBURY
    Wolfpack 
  • (4-10-0-0)
@

  • FRISCH
    Cougars 
  • (8-6-0-0)
Result
Win: 55-29
Sun Nov 24 2019 02:00:00
  • WATERBURY
    Wolfpack 
  • (4-10-0-0)
@

  • NORTH SHORE
    Stars 
  • (7-7-0-0)
Result
Win: 47-31
Wed Nov 27 2019 08:00:00
  • WATERBURY
    Wolfpack 
  • (4-10-0-0)
@

  • JEC
    Thunder 
  • (5-9-0-0)
Result
Loss: 47-51
Thu Dec 5 2019 07:30:00
  • WATERBURY
    Wolfpack 
  • (4-10-0-0)
@

  • KUSHNER
    Cobras 
  • (2-11-0-1)
Result
Loss: 42-47
Thu Dec 19 2019 07:30:00
  • WATERBURY
    Wolfpack 
  • (4-10-0-0)
@

  • KUSHNER
    Cobras 
  • (2-11-0-1)
Result
Loss: 40-55
Mon Jan 6 2020 07:30:00
  • WATERBURY
    Wolfpack 
  • (4-10-0-0)
@

  • MTA
    Lions 
  • (4-10-0-0)
Result
Win: 44-40
Wed Jan 8 2020 08:00:00
  • WATERBURY
    Wolfpack 
  • (4-10-0-0)
@

  • JEC
    Thunder 
  • (5-9-0-0)
Result
Win: 45-37
Thu Jan 23 2020 07:30:00
  • WATERBURY
    Wolfpack 
  • (4-10-0-0)
@

  • SAR
    Sting 
  • (8-6-0-0)
Result
Win: 54-41
Wed Jan 29 2020 07:30:00
  • WATERBURY
    Wolfpack 
  • (4-10-0-0)
@

  • RAMAZ
    Rams 
  • (8-6-0-0)
Result
Win: 62-29
Wed Feb 5 2020 08:00:00
  • WATERBURY
    Wolfpack 
  • (4-10-0-0)
@

  • HILLEL
    Heat 
  • (12-2-0-0)
Result
Win: 1-0
Thu Nov 4 2021 08:00:00
  • WATERBURY
    Wolfpack 
  • (9-5-0-0)
@

  • YDE
    Thunder 
  • (8-6-0-0)
Result
Win: 69-61
Tue Nov 9 2021 08:00:00
  • WATERBURY
    Wolfpack 
  • (9-5-0-0)
@

  • DRS
    Wildcats 
  • (12-2-0-0)
Result
Loss: 39-46
Mon Nov 15 2021 08:00:00
  • WATERBURY
    Wolfpack 
  • (9-5-0-0)
@

  • MAGEN DAVID
    Warriors 
  • (9-3-0-2)
Result
Win: 52-29
Thu Nov 18 2021 08:00:00
  • WATERBURY
    Wolfpack 
  • (9-5-0-0)
@

  • FLATBUSH
    Falcons 
  • (9-5-0-0)
Result
Win: 56-51
Thu Dec 9 2021 08:00:00
  • WATERBURY
    Wolfpack 
  • (9-5-0-0)
@

  • HAFTR
    Hawks 
  • (7-7-0-0)
Result
Win: 60-38
Thu Dec 16 2021 08:30:00
  • WATERBURY
    Wolfpack 
  • (9-5-0-0)
@

  • NORTH SHORE
    Stars 
  • (4-10-0-0)
Result
Loss: 45-61
Sun Dec 19 2021 03:00:00
  • WATERBURY
    Wolfpack 
  • (9-5-0-0)
@

  • NORTH SHORE
    Stars 
  • (4-10-0-0)
Result
Loss: 53-65
Thu Dec 30 2021 08:00:00
  • WATERBURY
    Wolfpack 
  • (9-5-0-0)
@

  • YDE
    Thunder 
  • (8-6-0-0)
Result
Loss: 49-54
Thu Jan 6 2022 08:30:00
  • WATERBURY
    Wolfpack 
  • (9-5-0-0)
@

  • OHR YISROEL
     
  • (2-12-0-0)
Result
Loss: 42-74
Wed Jan 12 2022 07:30:00
  • WATERBURY
    Wolfpack 
  • (9-5-0-0)
@

  • MAGEN ABRAHAM
    YMA KINGS 
  • (7-7-0-0)
Result
Loss: 30-31
Sun Jan 16 2022 03:00:00
  • WATERBURY
    Wolfpack 
  • (9-5-0-0)
@

  • RAMAZ
    Rams 
  • (12-2-0-0)
Result
Win: 40-39
Wed Feb 2 2022 07:00:00
  • WATERBURY
    Wolfpack 
  • (9-5-0-0)
@

  • RAMBAM
    Ravens 
  • (0-14-0-0)
Result
Loss: 36-73
Thu Feb 10 2022 08:30:00
  • WATERBURY
    Wolfpack 
  • (9-5-0-0)
@

  • HANC
    Hurricanes 
  • (2-12-0-0)
Result
Loss: 40-52
Thu Feb 17 2022 07:40:00
  • WATERBURY
    Wolfpack 
  • (9-5-0-0)
@

  • MAGEN ABRAHAM
    YMA KINGS 
  • (7-7-0-0)
Result
Loss: 29-41
Sat Feb 26 2022 10:00:00
  • YDE
    Thunder 
  • (8-6-0-0)
@

  • WATERBURY
    Wolfpack 
  • (9-5-0-0)
Result
Loss: 50-53
Thu Nov 3 2022 08:00:00
  • WATERBURY
    Wolfpack 
  • (6-8-0-0)
@

  • HAFTR
    Hawks 
  • (8-6-0-0)
Result
Loss: 40-48
Wed Nov 9 2022 08:00:00
  • WATERBURY
    Wolfpack 
  • (6-8-0-0)
@

  • FRISCH
    Cougars 
  • (12-2-0-0)
Result
Win: 61-53
Tue Nov 15 2022 08:00:00
  • WATERBURY
    Wolfpack 
  • (6-8-0-0)
@

  • NORTH SHORE
    Lions 
  • (14-0-0-0)
Result
Win: 42-38
Mon Nov 28 2022 08:00:00
  • WATERBURY
    Wolfpack 
  • (6-8-0-0)
@

  • MAGEN DAVID
    Warriors 
  • (10-4-0-0)
Result
Win: 49-47
Thu Dec 1 2022 08:30:00
  • WATERBURY
    Wolfpack 
  • (6-8-0-0)
@

  • MAGEN ABRAHAM
    Kings 
  • (0-13-0-1)
Result
Loss: 57-76
Sun Dec 4 2022 06:30:00
  • WATERBURY
    Wolfpack 
  • (6-8-0-0)
@

  • YDE
    Thunder 
  • (5-9-0-0)
Result
Win: 39-33
Thu Dec 8 2022 08:45:00
  • WATERBURY
    Wolfpack 
  • (6-8-0-0)
@

  • HANC
    Hurricanes 
  • (3-10-0-1)
Result
Loss: 38-68
Tue Dec 13 2022 07:30:00
  • WATERBURY
    Wolfpack 
  • (6-8-0-0)
@

  • FLATBUSH
    Falcons 
  • (9-5-0-0)
Result
Win: 63-41
Thu Dec 15 2022 08:00:00
  • WATERBURY
    Wolfpack 
  • (6-8-0-0)
@

  • DRS
    Wildcats 
  • (10-2-0-2)
Result
Overtime Loss: 55-57
Tue Dec 27 2022 08:00:00
  • WATERBURY
    Wolfpack 
  • (6-8-0-0)
@

  • RAMBAM
    Ravens 
  • (3-11-0-0)
Result
Loss: 34-65
Tue Jan 10 2023 08:00:00
  • WATERBURY
    Wolfpack 
  • (6-8-0-0)
@

  • NORTH SHORE
    Lions 
  • (14-0-0-0)
Result
Win: 40-30
Thu Jan 12 2023 08:30:00
  • WATERBURY
    Wolfpack 
  • (6-8-0-0)
@

  • MAGEN ABRAHAM
    Kings 
  • (0-13-0-1)
Result
Loss: 34-68
Thu Feb 2 2023 08:00:00
  • WATERBURY
    Wolfpack 
  • (6-8-0-0)
@

  • MAGEN DAVID
    Warriors 
  • (10-4-0-0)
Result
Win: 70-33
Tue Feb 7 2023 06:45:00
  • WATERBURY
    Wolfpack 
  • (6-8-0-0)
@

  • HILLEL
    Heat 
  • (10-3-0-1)
Result
Win: 57-42
Sat Feb 11 2023 09:00:00
  • WATERBURY
    Wolfpack 
  • (6-8-0-0)
@

  • DRS
    Wildcats 
  • (10-2-0-2)
Result
Win: 49-37
Wed Oct 25 2023 06:00:00
  • WATERBURY
    Wolfpack 
  • (5-9-0-0)
@

  • MAGEN DAVID
    Warriors 
  • (13-1-0-0)
Result
Win: 71-32
Tue Oct 31 2023 07:00:00
  • WATERBURY
    Wolfpack 
  • (5-9-0-0)
@

  • HANC
    Hurricanes 
  • (3-11-0-0)
Result
Loss: 46-58
Thu Nov 9 2023 08:30:00
  • WATERBURY
    Wolfpack 
  • (5-9-0-0)
@

  • HAFTR
    Hawks 
  • (9-5-0-0)
Result
Win: 58-43
Tue Nov 21 2023 07:30:00
  • WATERBURY
    Wolfpack 
  • (5-9-0-0)
@

  • RAMBAM
    Ravens 
  • (1-13-0-0)
Result
Loss: 41-66
Wed Nov 29 2023 06:00:00
  • WATERBURY
    Wolfpack 
  • (5-9-0-0)
@

  • MAGEN DAVID
    Warriors 
  • (13-1-0-0)
Result
Win: 48-41
Sat Dec 2 2023 08:30:00
  • WATERBURY
    Wolfpack 
  • (5-9-0-0)
@

  • HAFTR
    Hawks 
  • (9-5-0-0)
Result
Win: 60-40
Sat Dec 16 2023 09:15:00
  • WATERBURY
    Wolfpack 
  • (5-9-0-0)
@

  • HANC
    Hurricanes 
  • (3-11-0-0)
Result
Loss: 45-58
Wed Dec 20 2023 07:00:00
  • WATERBURY
    Wolfpack 
  • (5-9-0-0)
@

  • NORTH SHORE
    Lions 
  • (7-7-0-0)
Result
Win: 57-54
Sat Dec 23 2023 08:00:00
  • WATERBURY
    Wolfpack 
  • (5-9-0-0)
@

  • DRS
    Wildcats 
  • (7-7-0-0)
Result
Win: 47-43
Wed Dec 27 2023 06:45:00
  • WATERBURY
    Wolfpack 
  • (5-9-0-0)
@

  • FLATBUSH
    Falcons 
  • (12-2-0-0)
Result
Win: 84-36
Sun Dec 31 2023 05:15:00
  • WATERBURY
    Wolfpack 
  • (5-9-0-0)
@

  • OHR YISROEL
    Flames 
  • (8-6-0-0)
Result
Win: 66-49
Thu Jan 4 2024 06:00:00
  • WATERBURY
    Wolfpack 
  • (5-9-0-0)
@

  • YDE
    Thunder 
  • (5-9-0-0)
Result
Loss: 55-57
Sun Feb 4 2024 02:00:00
  • WATERBURY
    Wolfpack 
  • (5-9-0-0)
@

  • RAMBAM
    Ravens 
  • (1-13-0-0)
Result
Loss: 29-66
Tue Feb 6 2024 07:45:00
  • WATERBURY
    Wolfpack 
  • (5-9-0-0)
@

  • JEC
    Thunder 
  • (7-7-0-0)
Result
Win: 64-61
Tue Feb 20 2024 07:45:00
  • WATERBURY
    Wolfpack 
  • (5-9-0-0)
@

  • HAFTR
    Hawks 
  • (9-5-0-0)
Result
Win: 58-56

Click on game to see more info