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 Oct 24 2018 08:00:00 22:00:00
  • MAOR
    Mavericks 
  • (0-6-0-0)
@

  • HESCHEL
    Heat 
  • (2-1-0-0)
Result
Win: 74-26
Sun Oct 28 2018 01:30:00 22:00:00
  • TABC
    Storm 
  • (5-1-0-0)
@

  • MAOR
    Mavericks 
  • (0-6-0-0)
Result
Loss: 20-67
Sun Nov 11 2018 03:00:00 22:00:00
  • MAOR
    Mavericks 
  • (0-6-0-0)
@

  • MTA
    Lions 
  • (4-1-0-0)
Result
Win: 64-42
Mon Nov 19 2018 07:30:00 22:00:00
  • WESTCHESTER
    Wildcats 
  • (1-6-0-0)
@

  • MAOR
    Mavericks 
  • (0-6-0-0)
Result
Loss: 38-39
Wed Nov 21 2018 08:30:00 22:00:00
  • MAOR
    Mavericks 
  • (0-6-0-0)
@

  • FRISCH
    Cougars 
  • (5-1-0-0)
Result
Win: 81-27
Mon Dec 10 2018 07:00:00 22:00:00
  • KUSHNER
    Cobras 
  • (3-4-0-0)
@

  • MAOR
    Mavericks 
  • (0-6-0-0)
Result
Loss: 34-44
Sun Dec 16 2018 05:00:00 22:00:00
  • SAR
    Sting 
  • (7-1-0-0)
@

  • MAOR
    Mavericks 
  • (0-6-0-0)
05:00
  • 100 grant ave
  • DEAL, new jersey 07723
  • Map it!
Sat Dec 22 2018 07:00:00 22:00:00
  • MAOR
    Mavericks 
  • (0-6-0-0)
@

  • HILLEL
    Heat 
  • (1-4-0-0)
07:00
Sun Dec 30 2018 03:30:00 22:00:00
  • MAOR
    Mavericks 
  • (0-6-0-0)
@

  • JEC
    Thunder 
  • (2-4-0-0)
03:30
  • 330 Elmora Ave
  • Elizabeth, NJ 07208
  • Map it!
Sun Jan 6 2019 02:30:00 22:00:00
  • RAMAZ
    Rams 
  • (3-3-0-1)
@

  • MAOR
    Mavericks 
  • (0-6-0-0)
02:30
  • 100 grant ave
  • DEAL, new jersey 07723
  • Map it!

Click on game to see more info