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 = 48 or Away.school_id_fk = 48) AND GameDate > '10/1/2014' ORDER BY GameDate, NEWTIME ASC, GameTime ASC Thu Nov 4 2021 07:00:00
  • OHR YISROEL
     
  • (2-11-0-0)
@

  • SAR
    STING 
  • (9-5-0-0)
Result
Win: 18-1
Sun Nov 7 2021 01:00:00
  • OHR YISROEL
     
  • (2-12-0-0)
@

  • HESCHEL
    Heat 
  • (3-11-0-0)
Result
Win: 73-54
Thu Nov 11 2021 08:30:00
  • FRISCH
    Cougars 
  • (9-5-0-0)
@

  • OHR YISROEL
     
  • (2-12-0-0)
Result
Loss: 39-63
Sun Nov 14 2021 07:00:00
  • MTA
    Lions 
  • (9-4-0-1)
@

  • OHR YISROEL
     
  • (2-12-0-0)
Result
Loss: 26-41
Sun Nov 21 2021 05:30:00
  • OHR YISROEL
     
  • (2-12-0-0)
@

  • RAMBAM
    Ravens 
  • (0-14-0-0)
Result
Loss: 39-87
Mon Dec 6 2021 07:30:00
  • OHR YISROEL
     
  • (2-11-0-0)
@

  • RAMAZ
    Rams 
  • (8-6-0-0)
Result
Win: 5-4
Thu Dec 16 2021 08:45:00
  • TABC
    Storm 
  • (12-1-0-1)
@

  • OHR YISROEL
     
  • (2-11-0-0)
Result
Loss: 0-11
Sat Dec 18 2021 07:15:00
  • OHR YISROEL
     
  • (2-11-0-0)
@

  • FRISCH
    Cougars 
  • (11-2-0-1)
Result
Win: 11-2
Thu Dec 23 2021 08:30:00
  • OHR YISROEL
     
  • (2-11-0-0)
@

  • KUSHNER
    Cobras 
  • (5-8-0-1)
Result
Win: 7-1
Sun Dec 26 2021 07:00:00
  • TABC
    Storm 
  • (10-3-0-1)
@

  • OHR YISROEL
     
  • (2-12-0-0)
Result
Loss: 57-59
Thu Jan 6 2022 08:30:00
  • WATERBURY
    Wolfpack 
  • (9-5-0-0)
@

  • OHR YISROEL
     
  • (2-12-0-0)
Result
Loss: 42-74
Sun Jan 9 2022 07:00:00
  • SAR
    STING 
  • (9-5-0-0)
@

  • OHR YISROEL
     
  • (2-11-0-0)
Result
Loss: 1-15
Mon Jan 10 2022 08:45:00
  • OHR YISROEL
     
  • (2-12-0-0)
@

  • KUSHNER
    Cobras 
  • (6-7-0-1)
Result
Win: 47-45
Wed Jan 12 2022 08:00:00
  • OHR YISROEL
     
  • (2-12-0-0)
@

  • HILLEL
    Heat 
  • (6-7-0-1)
Result
Win: 72-54
Sat Jan 15 2022 07:30:00
  • KUSHNER
    Cobras 
  • (6-7-0-1)
@

  • OHR YISROEL
     
  • (2-12-0-0)
Result
Loss: 42-70
Sun Jan 16 2022 07:00:00
  • MTA
    Lions 
  • (10-3-0-1)
@

  • OHR YISROEL
     
  • (2-11-0-0)
Result
Loss: 1-7
Mon Jan 17 2022 06:30:00
  • OHR YISROEL
     
  • (2-12-0-0)
@

  • SAR
    Sting 
  • (13-1-0-0)
Result
Win: 72-54
Wed Feb 2 2022 08:00:00
  • OHR YISROEL
     
  • (2-12-0-0)
@

  • TABC
    Storm 
  • (10-3-0-1)
Result
Win: 81-53
Tue Feb 8 2022 08:30:00
  • JEC
    Thunder 
  • (3-11-0-0)
@

  • OHR YISROEL
     
  • (2-12-0-0)
Result
Win: 58-51
Wed Feb 9 2022 07:00:00
  • RAMAZ
    Rams 
  • (8-6-0-0)
@

  • OHR YISROEL
     
  • (2-11-0-0)
Result
Loss: 2-6
Sun Feb 13 2022 01:00:00
  • OHR YISROEL
     
  • (2-12-0-0)
@

  • RAMAZ
    Rams 
  • (12-2-0-0)
Result
Win: 57-38
Mon Feb 14 2022 08:00:00
  • OHR YISROEL
     
  • (2-11-0-0)
@

  • MAGEN DAVID
    Warriors 
  • (8-5-1-0)
Result
Win: 8-3
Mon Feb 14 2022 08:15:00
  • OHR YISROEL
     
  • (2-12-0-0)
@

  • JEC
    Thunder 
  • (3-11-0-0)
Result
Win: 67-63
Tue Feb 15 2022 07:00:00
  • OHR YISROEL
     
  • (2-11-0-0)
@

  • JEC
     
  • (1-12-0-0)
Result
Loss: 2-8
Thu Feb 17 2022 08:00:00
  • OHR YISROEL
     
  • (2-11-0-0)
@

  • HAFTR
    Hawks 
  • (0-14-0-0)
Result
Loss: 3-6
Sat Feb 19 2022 08:15:00
  • OHR YISROEL
     
  • (2-11-0-0)
@

  • TABC
    Storm 
  • (12-1-0-1)
Result
Win: 14-0
Sun Feb 20 2022 04:30:00
  • KUSHNER
    Cobras 
  • (5-8-0-1)
@

  • OHR YISROEL
     
  • (2-11-0-0)
Result
Loss: 2-4
Sun Oct 30 2022 06:00:00
  • OHR YISROEL
     
  • (3-10-0-0)
@

  • FRISCH
    Cougars 
  • (12-2-0-0)
Result
Win: 85-53
Thu Nov 3 2022 06:30:00
  • OHR YISROEL
     
  • (4-6-0-0)
@

  • KUSHNER
    Cobras 
  • (2-8-0-0)
Result
Loss: 0-7
Thu Nov 3 2022 08:45:00
  • OHR YISROEL
     
  • (3-10-0-0)
@

  • HANC
    Hurricanes 
  • (3-10-0-1)
Result
Overtime Loss: 44-55
Sun Nov 6 2022 06:30:00
  • JEC
    Thunder 
  • (8-5-0-1)
@

  • OHR YISROEL
     
  • (3-10-0-0)
Result
Loss: 46-59
Tue Nov 8 2022 07:15:00
  • OHR YISROEL
     
  • (4-6-0-0)
@

  • NORTH SHORE
    Lions 
  • (7-2-0-1)
Result
Win: 6-3
Thu Nov 10 2022 08:00:00
  • OHR YISROEL
     
  • (3-10-0-0)
@

  • SAR
    Sting 
  • (12-2-0-0)
Result
Win: 63-48
Sun Nov 13 2022 04:30:00
  • RAMAZ
    Rams 
  • (6-8-0-0)
@

  • OHR YISROEL
     
  • (3-10-0-0)
Result
Loss: 48-64
Wed Nov 16 2022 07:15:00
  • OHR YISROEL
     
  • (3-10-0-0)
@

  • KUSHNER
    Cobras 
  • (3-11-0-0)
Result
Loss: 40-57
Sun Nov 20 2022 04:30:00
  • HILLEL
    Heat 
  • (10-3-0-1)
@

  • OHR YISROEL
     
  • (3-10-0-0)
Result
Loss: 49-62
Sun Nov 20 2022 06:30:00
  • YDE
    Thunder 
  • (2-8-0-0)
@

  • OHR YISROEL
     
  • (4-6-0-0)
Result
Win: 3-1
Wed Nov 23 2022 06:15:00
  • TABC
    Storm 
  • (10-0-0-0)
@

  • OHR YISROEL
     
  • (4-6-0-0)
Result
Loss: 1-5
Tue Nov 29 2022 07:30:00
  • OHR YISROEL
     
  • (4-6-0-0)
@

  • JEC
    Thunder 
  • (0-10-0-0)
Result
Loss: 2-7
Sun Dec 4 2022 05:00:00
  • MTA
    Lions 
  • (4-10-0-0)
@

  • OHR YISROEL
     
  • (3-10-0-0)
Result
Win: 56-52
Sat Dec 10 2022 08:30:00
  • HAFTR
    Hawks 
  • (8-6-0-0)
@

  • OHR YISROEL
     
  • (3-10-0-0)
Result
Loss: 40-55
Sun Dec 11 2022 06:30:00
  • JEC
    Thunder 
  • (0-10-0-0)
@

  • OHR YISROEL
     
  • (4-6-0-0)
Result
Win: 6-1
Tue Dec 13 2022 07:00:00
  • OHR YISROEL
     
  • (4-6-0-0)
@

  • FRISCH
    Cougars 
  • (5-5-0-0)
Result
Win: 3-1
Wed Dec 14 2022 07:15:00
  • OHR YISROEL
     
  • (3-10-0-0)
@

  • TABC
    Storm 
  • (10-4-0-0)
Result
Win: 71-42
Thu Dec 29 2022 08:30:00
  • FRISCH
    Cougars 
  • (5-5-0-0)
@

  • OHR YISROEL
     
  • (4-6-0-0)
Result
Loss: 1-4
Sun Jan 8 2023 04:30:00
  • KUSHNER
    Cobras 
  • (3-11-0-0)
@

  • OHR YISROEL
     
  • (3-10-0-0)
Result
Loss: 35-49
Sun Jan 8 2023 06:30:00
  • SAR
    Sting 
  • (8-2-0-0)
@

  • OHR YISROEL
     
  • (4-6-0-0)
Result
Loss: 1-5
Tue Jan 31 2023 06:30:00
  • OHR YISROEL
     
  • (4-6-0-0)
@

  • MTA
    Lions 
  • (6-3-1-0)
Result
Win: 8-5
Sun Feb 5 2023 02:00:00
  • OHR YISROEL
     
  • (3-10-0-0)
@

  • HILLEL
    Heat 
  • (10-3-0-1)
Result
Win: 70-47
Tue Feb 7 2023 07:30:00
  • OHR YISROEL
     
  • (3-10-0-0)
@

  • JEC
    Thunder 
  • (8-5-0-1)
Result
Win: 53-25
Mon Oct 23 2023 08:30:00
  • OHR YISROEL
    Ohr yisroel  
  • (4-9-0-0)
@

  • RAMBAM
    Ravens 
  • (7-6-0-1)
Result
Win: 5-2
Thu Oct 26 2023 07:00:00
  • OHR YISROEL
    Ohr yisroel  
  • (4-9-0-0)
@

  • SAR
    STING 
  • (7-7-0-0)
Result
Win: 9-3
Sun Oct 29 2023 06:30:00
  • MTA
    Lions 
  • (2-12-0-0)
@

  • OHR YISROEL
    Flames 
  • (8-6-0-0)
Result
Win: 51-40
Thu Nov 2 2023 08:00:00
  • OHR YISROEL
    Flames 
  • (8-6-0-0)
@

  • HESCHEL
    Heat 
  • (9-5-0-0)
Result
Win: 65-63
Sun Nov 5 2023 06:30:00
  • KUSHNER
    Cobras 
  • (9-5-0-0)
@

  • OHR YISROEL
    Ohr yisroel  
  • (4-9-0-0)
Result
Loss: 2-6
Thu Nov 9 2023 06:00:00
  • OHR YISROEL
    Ohr yisroel  
  • (4-9-0-0)
@

  • TABC
    Storm 
  • (12-2-0-0)
Result
Win: 11-0
Sun Nov 12 2023 04:30:00
  • RAMAZ
    Rams 
  • (10-4-0-0)
@

  • OHR YISROEL
    Flames 
  • (8-6-0-0)
Result
Win: 63-62
Sun Nov 12 2023 06:30:00
  • NORTH SHORE
    Lions 
  • (3-11-0-0)
@

  • OHR YISROEL
    Ohr yisroel  
  • (4-9-0-0)
Result
Win: 5-4
Thu Nov 16 2023 08:00:00
  • OHR YISROEL
    Flames 
  • (8-6-0-0)
@

  • SAR
    Sting 
  • (7-7-0-0)
Result
Win: 45-35
Mon Nov 27 2023 07:15:00
  • OHR YISROEL
    Ohr yisroel  
  • (4-9-0-0)
@

  • FRISCH
    Cougars 
  • (10-4-0-0)
Result
Win: 9-3
Sun Dec 3 2023 04:00:00
  • MTA
    Lions 
  • (7-6-0-1)
@

  • OHR YISROEL
    Ohr yisroel  
  • (4-9-0-0)
Result
Win: 4-3
Sun Dec 3 2023 06:30:00
  • TABC
    Storm 
  • (12-2-0-0)
@

  • OHR YISROEL
    Flames 
  • (8-6-0-0)
Result
Loss: 44-66
Mon Dec 4 2023 07:00:00
  • OHR YISROEL
    Flames 
  • (8-6-0-0)
@

  • KUSHNER
    Cobras 
  • (1-13-0-0)
Result
Loss: 39-58
Sun Dec 10 2023 06:30:00
  • HESCHEL
    Heat 
  • (9-5-0-0)
@

  • OHR YISROEL
    Flames 
  • (8-6-0-0)
Result
Win: 58-47
Sat Dec 16 2023 08:30:00
  • JEC
    Thunder 
  • (7-7-0-0)
@

  • OHR YISROEL
    Flames 
  • (8-6-0-0)
Result
Loss: 46-51
Sun Dec 17 2023 06:30:00
  • KUSHNER
    Cobras 
  • (1-13-0-0)
@

  • OHR YISROEL
    Flames 
  • (8-6-0-0)
Result
Win: 85-49
Wed Dec 20 2023 08:00:00
  • OHR YISROEL
    Flames 
  • (8-6-0-0)
@

  • FRISCH
    Cougars 
  • (10-4-0-0)
Result
Win: 80-67
Sun Dec 24 2023 07:00:00
  • OHR YISROEL
    Flames 
  • (8-6-0-0)
@

  • YDE
    Thunder 
  • (5-9-0-0)
Result
Loss: 45-48
Sun Dec 31 2023 05:15:00
  • WATERBURY
    Wolfpack 
  • (5-9-0-0)
@

  • OHR YISROEL
    Flames 
  • (8-6-0-0)
Result
Win: 66-49
Sun Dec 31 2023 01:00:00
  • OHR YISROEL
    Ohr yisroel  
  • (4-9-0-0)
@

  • JEC
    Thunder 
  • (2-11-0-0)
Result
Loss: 3-8
Tue Jan 2 2024 06:30:00
  • OHR YISROEL
    Ohr yisroel  
  • (4-9-0-0)
@

  • MTA
    Lions 
  • (7-6-0-1)
Result
Win: 4-2
Sun Jan 7 2024 04:30:00
  • TABC
    Storm 
  • (12-2-0-0)
@

  • OHR YISROEL
    Ohr yisroel  
  • (4-9-0-0)
Result
Loss: 0-1
Mon Jan 15 2024 08:00:00
  • OHR YISROEL
    Ohr yisroel  
  • (4-9-0-0)
@

  • FRISCH
    Cougars 
  • (10-4-0-0)
Result
Win: 8-1
Tue Jan 16 2024 07:00:00
  • OHR YISROEL
    Flames 
  • (8-6-0-0)
@

  • RAMAZ
    Rams 
  • (10-4-0-0)
Result
Win: 65-57
Wed Jan 31 2024 07:00:00
  • OHR YISROEL
    Ohr yisroel  
  • (4-9-0-0)
@

  • HILLEL
    Heat 
  • (1-13-0-0)
Result
Win: 6-5
Sun Feb 4 2024 04:30:00
  • HILLEL
    Heat 
  • (1-13-0-0)
@

  • OHR YISROEL
    Ohr yisroel  
  • (4-9-0-0)
Result
Win: 1-0
Tue Feb 6 2024 08:30:00
  • OHR YISROEL
    Flames 
  • (8-6-0-0)
@

  • HILLEL
    Heat 
  • (5-9-0-0)
Result
Loss: 29-69
Wed Feb 14 2024 07:30:00
  • OHR YISROEL
    Flames 
  • (8-6-0-0)
@

  • HESCHEL
    Heat 
  • (9-5-0-0)
Result
Loss: 37-47
Tue Feb 27 2024 08:00:00
  • OHR YISROEL
    Flames 
  • (8-6-0-0)
@

  • FLATBUSH
    Falcons 
  • (12-2-0-0)
Result
Win: 69-47

Click on game to see more info