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 = 33 or Away.school_id_fk = 33) AND GameDate > '10/1/2014' ORDER BY GameDate, NEWTIME ASC, GameTime ASC Wed Apr 15 2015 18:15:00
  • MAOR
     
  • (2-6-0-0)
@

  • JEC
     
  • (4-4-0-0)
Result
Win: 8-3
Fri Apr 17 2015 14:30:00
  • MAOR
     
  • (2-6-0-0)
@

  • HILLEL
     
  • (6-2-0-0)
Result
Win: 7-3
Sun Apr 19 2015 14:30:00 22:00:00
  • JEC
     
  • (4-4-0-0)
@

  • MAOR
     
  • (2-6-0-0)
Result
Win: 4-3
Sun Apr 19 2015 15:30:00 22:00:00
  • MTA
     
  • (1-7-0-0)
@

  • MAOR
     
  • (2-6-0-0)
Result
Loss: 3-5
Fri Apr 24 2015 14:30:00 22:00:00
  • HILLEL
     
  • (6-2-0-0)
@

  • MAOR
     
  • (2-6-0-0)
Result
Loss: 4-7
Sun Apr 26 2015 11:15:00 22:00:00
  • MAOR
     
  • (2-6-0-0)
@

  • SAR
     
  • (6-2-0-0)
Result
Win: 7-5
Sun Apr 26 2015 11:15:00 22:00:00
  • MAOR
     
  • (2-6-0-0)
@

  • FRISCH
     
  • (5-3-0-0)
Result
Win: 9-2
Sun May 3 2015 11:15:00 22:00:00
  • TABC
     
  • (4-4-0-0)
@

  • MAOR
     
  • (2-6-0-0)
Result
Win: 5-4
Sun Oct 25 2015 06:00:00 22:00:00
  • MAOR
    Mavericks 
  • (5-4-0-1)
@

  • SAR
    Sting 
  • (9-1-0-0)
Result
Win: 63-17
Thu Oct 29 2015 07:30:00 22:00:00
  • FRISCH
    Cougars 
  • (10-0-0-0)
@

  • MAOR
    Mavericks 
  • (5-4-0-1)
Result
Loss: 24-60
Sun Nov 1 2015 12:00:00 22:00:00
  • MAOR
    Mavericks 
  • (5-4-0-1)
@

  • KUSHNER
    Cobras 
  • (2-7-0-1)
Result
Loss: 41-59
Sun Nov 15 2015 02:00:00 22:00:00
  • MAOR
    Mavericks 
  • (5-4-0-1)
@

  • RAMAZ
    Rams 
  • (6-4-0-0)
Result
Win: 66-58
Sun Nov 29 2015 12:00:00 22:00:00
  • MAOR
    Mavericks 
  • (5-4-0-1)
@

  • TABC
    Storm 
  • (7-2-0-1)
Result
Win: 52-43
Sun Dec 6 2015 02:30:00 22:00:00
  • MTA
    Lions 
  • (5-5-0-0)
@

  • MAOR
    Mavericks 
  • (5-4-0-1)
Result
Win: 30-25
Sun Dec 20 2015 06:00:00 22:00:00
  • MAOR
    Mavericks 
  • (5-4-0-1)
@

  • WESTCHESTER
    Wildcats 
  • (0-10-0-0)
Result
Loss: 19-59
Wed Dec 30 2015 08:15:00 22:00:00
  • JEC
    Thunder 
  • (7-3-0-0)
@

  • MAOR
    Mavericks 
  • (5-4-0-1)
Result
Loss: 51-55
Wed Jan 6 2016 07:00:00 22:00:00
  • HESCHEL
    Heat 
  • (3-7-0-0)
@

  • MAOR
    Mavericks 
  • (5-4-0-1)
Result
Win: 55-45
Tue Jan 12 2016 06:30:00 22:00:00
  • HILLEL
    Heat 
  • (1-9-0-0)
@

  • MAOR
    Mavericks 
  • (5-4-0-1)
Result
Win: 52-32
Tue Feb 16 2016 08:00:00 22:00:00
  • MAOR
    Mavericks 
  • (5-4-0-1)
@

  • JEC
    Thunder 
  • (7-3-0-0)
Result
Loss: 45-55
Mon Feb 29 2016 07:00:00 22:00:00
  • MAOR
    Mavericks 
  • (5-4-0-1)
@

  • DRS
    Wildcats 
  • (10-0-0-0)
Result
Win: 63-34
Sun Apr 10 2016 03:00:00 22:00:00
  • MTA
     
  • (4-2-0-0)
@

  • MAOR
    Mavericks 
  • (4-2-0-0)
Result
Win: 11-10
Wed Apr 13 2016 05:00:00 22:00:00
  • MAOR
    Mavericks 
  • (4-2-0-0)
@

  • HILLEL
    Heat 
  • (5-1-0-0)
Result
Win: 8-5
Tue Apr 19 2016 08:00:00 22:00:00
  • JEC
     
  • (4-2-0-0)
@

  • MAOR
    Mavericks 
  • (4-2-0-0)
Result
Loss: 2-5
Tue May 10 2016 06:00:00 22:00:00
  • MAOR
    Mavericks 
  • (4-2-0-0)
@

  • SAR
     
  • (0-6-0-0)
Result
Loss: 6-19
Sun May 15 2016 02:15:00 22:00:00
  • TABC
    Storm 
  • (2-3-0-1)
@

  • MAOR
    Mavericks 
  • (4-2-0-0)
Result
Win: 12-1
Sun May 15 2016 04:00:00 22:00:00
  • FRISCH
     
  • (2-4-0-0)
@

  • MAOR
    Mavericks 
  • (4-2-0-0)
Result
Win: 5-1
Sun May 22 2016 03:30:00 22:00:00
  • MAOR
    Mavericks 
  • (4-2-0-0)
@

  • JEC
     
  • (4-2-0-0)
Result
Win: 2-1
Thu Mar 2 2017 08:00:00 22:00:00
  • MAOR
     
  • (0-8-0-0)
@

  • JEC
     
  • (4-3-1-0)
Result
Win: 9-4
Tue Mar 14 2017 07:30:00 22:00:00
  • KUSHNER
    Cobras 
  • (5-3-0-0)
@

  • MAOR
     
  • (0-8-0-0)
Result
Loss: 0-1
Thu Mar 16 2017 07:30:00 22:00:00
  • HILLEL
     
  • (2-5-1-0)
@

  • MAOR
     
  • (0-8-0-0)
Result
Loss: 1-8
Mon Mar 20 2017 08:00:00 22:00:00
  • FRISCH
    Cougars 
  • (4-4-0-0)
@

  • MAOR
     
  • (0-8-0-0)
Result
Loss: 0-7
Wed Mar 22 2017 08:00:00 22:00:00
  • MAOR
     
  • (0-8-0-0)
@

  • TABC
    Storm 
  • (8-0-0-0)
Result
Win: 9-2
Tue Mar 28 2017 07:30:00 22:00:00
  • MAOR
     
  • (0-8-0-0)
@

  • HILLEL
     
  • (2-5-1-0)
Result
Win: 8-4
Mon Apr 3 2017 08:00:00 22:00:00
  • JEC
     
  • (4-3-1-0)
@

  • MAOR
     
  • (0-8-0-0)
Result
Loss: 1-8
Thu Apr 6 2017 08:00:00 22:00:00
  • MAOR
     
  • (0-8-0-0)
@

  • FRISCH
    Cougars 
  • (4-4-0-0)
Result
Win: 8-1
Fri Apr 21 2017 02:00:00 22:00:00
  • MAOR
    Mavericks 
  • (3-4-0-1)
@

  • HILLEL
     
  • (8-0-0-0)
Result
Win: 5-1
Fri Apr 21 2017 02:00:00 22:00:00
  • HILLEL
     
  • (8-0-0-0)
@

  • MAOR
    Mavericks 
  • (3-4-0-1)
Result
Overtime Loss: 2-3
Sun Apr 23 2017 03:00:00 22:00:00
  • MTA
     
  • (4-4-0-0)
@

  • MAOR
    Mavericks 
  • (3-4-0-1)
Result
Win: 8-2
Wed Apr 26 2017 06:00:00 22:00:00
  • MAOR
    Mavericks 
  • (3-4-0-1)
@

  • JEC
     
  • (3-5-0-0)
Result
Win: 5-2
Sun Apr 30 2017 04:30:00 22:00:00
  • HEICHAL HATORAH
     
  • (0-8-0-0)
@

  • MAOR
    Mavericks 
  • (3-4-0-1)
Result
Win: 10-9
Wed May 3 2017 06:15:00 22:00:00
  • MAOR
    Mavericks 
  • (3-4-0-1)
@

  • TABC
    Storm 
  • (4-4-0-0)
Result
Win: 6-3
Thu May 4 2017 06:30:00 22:00:00
  • MAOR
    Mavericks 
  • (3-4-0-1)
@

  • FRISCH
     
  • (7-1-0-0)
Result
Win: 4-3
Thu May 18 2017 06:15:00 22:00:00
  • SAR
     
  • (3-5-0-0)
@

  • MAOR
    Mavericks 
  • (3-4-0-1)
Result
Win: 9-8
Sun Oct 29 2017 12:30:00 22:00:00
  • FRISCH
    Cougars 
  • (10-0-0-0)
@

  • MAOR
    Mavericks 
  • (1-9-0-0)
Result
Loss: 34-74
Tue Oct 31 2017 08:00:00 22:00:00
  • MAOR
    Mavericks 
  • (1-9-0-0)
@

  • SAR
    Sting 
  • (7-2-0-1)
Result
Win: 72-18
Sat Nov 11 2017 08:15:00 22:00:00
  • HESCHEL
    Heat 
  • (5-5-0-0)
@

  • MAOR
    Mavericks 
  • (1-9-0-0)
Result
Loss: 39-63
Mon Nov 13 2017 07:45:00 22:00:00
  • MAOR
    Mavericks 
  • (1-9-0-0)
@

  • TABC
    Storm 
  • (8-1-0-1)
Result
Win: 78-23
Sat Nov 18 2017 08:00:00 22:00:00
  • MAOR
    Mavericks 
  • (1-9-0-0)
@

  • KUSHNER
    Cobras 
  • (2-7-0-1)
Result
Win: 58-44
Mon Nov 27 2017 08:00:00 22:00:00
  • JEC
    Thunder 
  • (9-1-0-0)
@

  • MAOR
    Mavericks 
  • (1-9-0-0)
Result
Loss: 34-67
Mon Dec 11 2017 08:15:00 22:00:00
  • MAOR
    Mavericks 
  • (1-9-0-0)
@

  • RAMAZ
    Rams 
  • (6-4-0-0)
Result
Win: 66-36
Sun Dec 24 2017 01:45:00 22:00:00
  • MTA
    Lions 
  • (3-7-0-0)
@

  • MAOR
    Mavericks 
  • (1-9-0-0)
Result
Loss: 36-41
Wed Dec 27 2017 07:15:00 22:00:00
  • HILLEL
    Heat 
  • (4-6-0-0)
@

  • MAOR
    Mavericks 
  • (1-9-0-0)
Result
Loss: 33-52
Mon Jan 8 2018 08:15:00 22:00:00
  • MAOR
    Mavericks 
  • (1-9-0-0)
@

  • WESTCHESTER
    Wildcats 
  • (0-10-0-0)
Result
Loss: 26-34
Tue Apr 17 2018 06:00:00 22:00:00
  • MAOR
    Mavericks 
  • (2-5-0-0)
@

  • SAR
    Sting 
  • (5-3-0-0)
Result
Win: 5-4
Mon Apr 30 2018 06:15:00 22:00:00
  • FRISCH
    Cougars 
  • (5-3-0-0)
@

  • MAOR
    Mavericks 
  • (2-5-0-0)
Result
Win: 7-6
Tue May 1 2018 06:15:00 22:00:00
  • JEC
     
  • (5-3-0-0)
@

  • MAOR
    Mavericks 
  • (2-5-0-0)
Result
Loss: 1-4
Sun May 6 2018 05:30:00 22:00:00
  • MAOR
    Mavericks 
  • (2-5-0-0)
@

  • MTA
    Lions 
  • (1-7-0-0)
Result
Loss: 7-11
Tue May 8 2018 06:00:00 22:00:00
  • TABC
    Storm 
  • (6-2-0-0)
@

  • MAOR
    Mavericks 
  • (2-5-0-0)
Result
Loss: 0-6
Fri May 11 2018 02:00:00 22:00:00
  • MAOR
    Mavericks 
  • (2-5-0-0)
@

  • HILLEL
     
  • (7-1-0-0)
Result
Win: 2-1
Fri May 11 2018 03:00:00 22:00:00
  • HILLEL
     
  • (7-1-0-0)
@

  • MAOR
    Mavericks 
  • (2-5-0-0)
Result
Loss: 3-6
Wed Apr 10 2019 06:00:00 22:00:00
  • MAOR
    Mavericks 
  • (5-1-0-0)
@

  • SHAARE T.
    Stars 
  • (3-3-0-0)
Result
Loss: 3-4
Wed May 1 2019 06:15:00 22:00:00
  • MAOR
    Mavericks 
  • (5-1-0-0)
@

  • YDE
    Thunder 
  • (5-1-0-0)
Result
Win: 8-4
Fri May 3 2019 03:00:00 22:00:00
  • MAOR
    Mavericks 
  • (5-1-0-0)
@

  • HILLEL
    Heat 
  • (3-3-0-0)
Result
Loss: 3-7
Wed May 8 2019 05:30:00 22:00:00
  • HILLEL
    Heat 
  • (3-3-0-0)
@

  • MAOR
    Mavericks 
  • (5-1-0-0)
Result
Win: 3-1
Thu May 9 2019 05:30:00 22:00:00
  • FLATBUSH
    Falcons 
  • (1-5-0-0)
@

  • MAOR
    Mavericks 
  • (5-1-0-0)
Result
Win: 13-3
Mon May 20 2019 05:15:00 22:00:00
  • MAGEN DAVID
    Warriors 
  • (1-5-0-0)
@

  • MAOR
    Mavericks 
  • (5-1-0-0)
Result
Win: 16-3
Mon May 27 2019 06:15:00 22:00:00
  • DARCHEI
    Astros 
  • (5-1-0-0)
@

  • MAOR
    Mavericks 
  • (5-1-0-0)
Result
Loss: 2-5
Fri Apr 30 2021 11:00:00 22:00:00
  • MTA
    Loins 
  • (0-8-0-0)
@

  • MAOR
    Mavericks 
  • (7-1-0-0)
Result
Win: 5-2
Fri Apr 30 2021 11:00:00 22:00:00
  • MAOR
    Mavericks 
  • (7-1-0-0)
@

  • MTA
    Loins 
  • (0-8-0-0)
Result
Loss: 2-10
Sun May 2 2021 01:00:00 22:00:00
  • HEICHAL HATORAH
    Hornets 
  • (4-2-0-2)
@

  • MAOR
    Mavericks 
  • (7-1-0-0)
Result
Win: 6-5
Mon May 3 2021 07:00:00 22:00:00
  • TABC
    Storm 
  • (2-6-0-0)
@

  • MAOR
    Mavericks 
  • (7-1-0-0)
Result
Win: 15-0
Mon May 3 2021 07:00:00 22:00:00
  • MAOR
    Mavericks 
  • (7-1-0-0)
@

  • TABC
    Storm 
  • (2-6-0-0)
Result
Loss: 1-10
Thu May 6 2021 07:30:00 22:00:00
  • MAOR
    Mavericks 
  • (7-1-0-0)
@

  • FRISCH
    Cougars 
  • (4-3-0-1)
Result
Loss: 0-10
Fri May 7 2021 02:30:00 22:00:00
  • MAOR
    Mavericks 
  • (7-1-0-0)
@

  • HILLEL
    Heat 
  • (7-1-0-0)
Result
Win: 10-9
Fri May 7 2021 02:30:00 22:00:00
  • HILLEL
    Heat 
  • (7-1-0-0)
@

  • MAOR
    Mavericks 
  • (7-1-0-0)
Result
Win: 7-0
Mon May 31 2021 02:30:00 22:00:00
  • MAOR
    Mavericks 
  • (7-1-0-0)
@

  • DRS
    Wildcats 
  • (7-1-0-0)
Result
Loss: 0-11
Thu Jun 10 2021 06:00:00 22:00:00
  • MAOR
    Mavericks 
  • (7-1-0-0)
@

  • MAY
    Eagles 
  • (7-1-0-0)
Result
Loss: 2-3
Sun Jun 20 2021 04:30:00 22:00:00
  • MAOR
    Mavericks 
  • (7-1-0-0)
@

  • YDE
    Thunder 
  • (7-1-0-0)
Result
Loss: 0-5
Mon Apr 11 2022 02:00:00 22:00:00
  • KETER TORAH
    keter lions 
  • (4-4-0-0)
@

  • MAOR
    Sharks  
  • (5-2-1-0)
Result
Win: 5-2
Mon Apr 11 2022 02:00:00 22:00:00
  • KETER TORAH
    keter lions 
  • (4-4-0-0)
@

  • MAOR
    Sharks  
  • (5-2-1-0)
Result
Win: 4-0
Wed Apr 27 2022 08:15:00 22:00:00
  • SAR
    Sting 
  • (5-3-0-0)
@

  • MAOR
    Sharks  
  • (5-2-1-0)
Result
Loss: 1-2
Fri Apr 29 2022 02:00:00 22:00:00
  • HILLEL
    Heat 
  • (5-1-0-2)
@

  • MAOR
    Sharks  
  • (5-2-1-0)
Result
Loss: 6-9
Tue May 3 2022 07:00:00 22:00:00
  • MAOR
    Sharks  
  • (5-2-1-0)
@

  • MTA
    Lions 
  • (4-4-0-0)
Result
Loss: 1-6
Tue May 3 2022 08:30:00 22:00:00
  • MAOR
    Sharks  
  • (5-2-1-0)
@

  • HEICHAL HATORAH
    Hornets 
  • (3-5-0-0)
Result
Loss: 3-12
Thu May 5 2022 07:00:00 22:00:00
  • MAOR
    Sharks  
  • (5-2-1-0)
@

  • TABC
    Storm 
  • (5-2-1-0)
Result
Tie: 6-6
Tue May 24 2022 05:30:00 22:00:00
  • FRISCH
    Cougars 
  • (0-8-0-0)
@

  • MAOR
    Sharks  
  • (5-2-1-0)
Result
Win: 7-0
Tue Jun 7 2022 08:30:00 22:00:00
  • MAOR
    Sharks  
  • (5-2-1-0)
@

  • TABC
    Storm 
  • (5-2-1-0)
Result
Loss: 3-5
Fri Jun 17 2022 11:30:00 22:00:00
  • MAOR
    Sharks  
  • (5-2-1-0)
@

  • DRS
    Wildcats  
  • (7-1-0-0)
Result
Win: 1-0
Tue Nov 8 2022 06:30:00 22:00:00
  • SAR
    Sting 
  • (7-2-0-1)
@

  • MAOR
    Mavericks 
  • (0-9-0-1)
Result
Loss: 37-69
Wed Nov 9 2022 07:15:00 22:00:00
  • MAOR
    Mavericks 
  • (0-9-0-1)
@

  • FRISCH
    Cougars 
  • (6-4-0-0)
Result
Win: 71-38
Tue Nov 15 2022 07:30:00 22:00:00
  • MTA
    Lions 
  • (5-5-0-0)
@

  • MAOR
    Mavericks 
  • (0-9-0-1)
Result
Loss: 44-62
Tue Nov 22 2022 06:30:00 22:00:00
  • HILLEL
    Heat 
  • (6-4-0-0)
@

  • MAOR
    Mavericks 
  • (0-9-0-1)
Result
Loss: 38-67
Tue Nov 29 2022 06:30:00 22:00:00
  • KUSHNER
    Cobras 
  • (1-9-0-0)
@

  • MAOR
    Mavericks 
  • (0-9-0-1)
Result
Loss: 50-57
Wed Nov 30 2022 07:30:00 22:00:00
  • MAOR
    Mavericks 
  • (0-9-0-1)
@

  • JEC
    Thunder 
  • (4-6-0-0)
Result
Win: 65-58
Tue Dec 6 2022 07:30:00 22:00:00
  • TABC
    Storm 
  • (10-0-0-0)
@

  • MAOR
    Mavericks 
  • (0-9-0-1)
Result
Loss: 21-64
Mon Dec 12 2022 08:00:00 22:00:00
  • MAOR
    Mavericks 
  • (0-9-0-1)
@

  • RAMAZ
    Rams 
  • (8-2-0-0)
Result
Win: 62-42
Tue Dec 27 2022 06:00:00 22:00:00
  • MAOR
    Mavericks 
  • (0-9-0-1)
@

  • HILLEL
    Heat 
  • (6-4-0-0)
Result
Win: 74-47
Mon Jan 9 2023 07:30:00 22:00:00
  • MAOR
    Mavericks 
  • (0-9-0-1)
@

  • HESCHEL
    Heat 
  • (3-7-0-0)
Result
Win: 61-55
Tue Mar 28 2023 06:00:00 22:00:00
  • KETER TORAH
    keter lions 
  • (6-1-0-1)
@

  • MAOR
    Sharks  
  • (5-2-1-0)
Result
Loss: 1-3
Sun Apr 23 2023 01:30:00 22:00:00
  • MTA
    Lions 
  • (1-7-0-0)
@

  • MAOR
    Sharks  
  • (5-2-1-0)
Result
Win: 10-0
Sun Apr 23 2023 07:00:00 22:00:00
  • TABC
    Storm 
  • (0-8-0-0)
@

  • MAOR
    Sharks  
  • (5-2-1-0)
Result
Win: 5-1
Wed May 3 2023 06:15:00 22:00:00
  • MAOR
    Sharks  
  • (5-2-1-0)
@

  • FRISCH
    Cougars 
  • (3-5-0-0)
Result
Loss: 2-7
Fri May 5 2023 03:30:00 22:00:00
  • MAOR
    Sharks  
  • (5-2-1-0)
@

  • HILLEL
    Heat 
  • (7-0-1-0)
Result
Tie: 1-1
Sun May 7 2023 05:30:00 22:00:00
  • MAOR
    Sharks  
  • (5-2-1-0)
@

  • KETER TORAH
    keter lions 
  • (6-1-0-1)
Result
Loss: 2-4
Tue May 16 2023 07:00:00 22:00:00
  • HEICHAL HATORAH
    Hornets 
  • (6-2-0-0)
@

  • MAOR
    Sharks  
  • (5-2-1-0)
Result
Loss: 2-4
Wed May 24 2023 06:15:00 22:00:00
  • MAOR
    Sharks  
  • (5-2-1-0)
@

  • SAR
    Sting 
  • (3-5-0-0)
Result
Loss: 7-10
Mon May 29 2023 12:30:00 22:00:00
  • MAOR
    Sharks  
  • (5-2-1-0)
@

  • HILLEL
    Heat 
  • (7-0-1-0)
Result
Win: 5-0

Click on game to see more info