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 = 3 or Away.school_id_fk = 3) AND GameDate > '10/1/2014' ORDER BY GameDate, NEWTIME ASC, GameTime ASC Tue Oct 22 2013 07:30:00
  • D. HATORAH
     
  • (3-11-0-0)
@

  • HAFTR
    Hawks 
  • (12-2-0-0)
Result
Win: 60-33
Mon Oct 28 2013 07:30:00
  • YDE
    Thunder 
  • (6-7-0-1)
@

  • D. HATORAH
     
  • (3-11-0-0)
Result
Loss: 42-52
Mon Nov 4 2013 07:45:00
  • DRS
    Wildcats 
  • (6-7-0-1)
@

  • D. HATORAH
     
  • (3-11-0-0)
Result
Loss: 27-43
Thu Nov 7 2013 07:30:00
  • MAGEN DAVID
    Warriors 
  • (5-9-0-0)
@

  • D. HATORAH
     
  • (3-11-0-0)
Result
Loss: 35-56
Tue Nov 12 2013 08:30:00
  • D. HATORAH
     
  • (3-11-0-0)
@

  • HILLEL
    Heat 
  • (4-10-0-0)
Result
Win: 39-33
Wed Nov 20 2013 07:30:00
  • RAMBAM
    Ravens 
  • (1-13-0-0)
@

  • D. HATORAH
     
  • (3-11-0-0)
Result
Win: 44-34
Mon Nov 25 2013 07:30:00
  • FLATBUSH
    Falcons 
  • (8-6-0-0)
@

  • D. HATORAH
     
  • (3-11-0-0)
Result
Loss: 44-78
Thu Dec 5 2013 08:00:00
  • D. HATORAH
     
  • (3-11-0-0)
@

  • NORTH SHORE
    Stars 
  • (14-0-0-0)
Result
Win: 61-32
Mon Dec 16 2013 07:30:00
  • HANC
    Hurricanes 
  • (5-9-0-0)
@

  • D. HATORAH
     
  • (3-11-0-0)
Result
Win: 64-58
Wed Dec 18 2013 07:15:00
  • D. HATORAH
     
  • (3-11-0-0)
@

  • YDE
    Thunder 
  • (6-7-0-1)
Result
Win: 46-44
Sat Dec 21 2013 07:30:00
  • D. HATORAH
     
  • (3-11-0-0)
@

  • RAMBAM
    Ravens 
  • (1-13-0-0)
Result
Loss: 49-63
Mon Jan 6 2014 07:30:00
  • KUSHNER
    Cobras 
  • (6-8-0-0)
@

  • D. HATORAH
     
  • (3-11-0-0)
Result
Loss: 37-46
Thu Jan 30 2014 08:00:00
  • D. HATORAH
     
  • (3-11-0-0)
@

  • DRS
    Wildcats 
  • (6-7-0-1)
Result
Win: 52-31
Sat Feb 1 2014 08:30:00
  • D. HATORAH
     
  • (3-11-0-0)
@

  • HANC
    Hurricanes 
  • (5-9-0-0)
Result
Win: 1-0
Thu Oct 23 2014 07:15:00
  • RAMBAM
    Ravens 
  • (1-13-0-0)
@

  • D. HATORAH
     
  • (1-13-0-0)
Result
Win: 61-53
Tue Oct 28 2014 08:30:00
  • D. HATORAH
     
  • (1-13-0-0)
@

  • DRS
    Wildcats 
  • (11-3-0-0)
Result
Win: 84-35
Thu Oct 30 2014 07:30:00
  • MAGEN DAVID
    Warriors 
  • (9-5-0-0)
@

  • D. HATORAH
     
  • (1-13-0-0)
Result
Loss: 55-66
Tue Nov 4 2014 09:00:00
  • D. HATORAH
     
  • (1-13-0-0)
@

  • HILLEL
    Heat 
  • (9-5-0-0)
Result
Win: 84-47
Sat Nov 8 2014 09:00:00
  • D. HATORAH
     
  • (1-13-0-0)
@

  • FLATBUSH
    Falcons 
  • (4-10-0-0)
Result
Win: 75-25
Mon Nov 10 2014 07:45:00
  • MTA
    Lions 
  • (3-11-0-0)
@

  • D. HATORAH
     
  • (1-13-0-0)
Result
Loss: 60-67
Mon Nov 24 2014 07:30:00
  • NORTH SHORE
    Stars 
  • (9-5-0-0)
@

  • D. HATORAH
     
  • (1-13-0-0)
Result
Loss: 50-84
Mon Dec 1 2014 07:45:00
  • HANC
    Hurricanes 
  • (5-9-0-0)
@

  • D. HATORAH
     
  • (1-13-0-0)
Result
Loss: 48-73
Mon Dec 8 2014 07:30:00
  • YDE
    Thunder 
  • (8-6-0-0)
@

  • D. HATORAH
     
  • (1-13-0-0)
Result
Loss: 63-82
Sat Dec 13 2014 08:00:00
  • D. HATORAH
     
  • (1-13-0-0)
@

  • RAMBAM
    Ravens 
  • (1-13-0-0)
Result
Win: 87-76
Mon Dec 15 2014 07:30:00
  • FLATBUSH
    Falcons 
  • (4-10-0-0)
@

  • D. HATORAH
     
  • (1-13-0-0)
Result
Loss: 55-73
Mon Dec 29 2014 08:00:00
  • D. HATORAH
     
  • (1-13-0-0)
@

  • MAGEN DAVID
    Warriors 
  • (9-5-0-0)
Result
Win: 70-28
Mon Jan 5 2015 08:30:00
  • D. HATORAH
     
  • (1-13-0-0)
@

  • HAFTR
    Hawks 
  • (14-0-0-0)
Result
Win: 88-44
Mon Feb 2 2015 07:15:00
  • D. HATORAH
     
  • (1-13-0-0)
@

  • YDE
    Thunder 
  • (8-6-0-0)
Result
Win: 74-40
Fri Apr 24 2015 00:00:02
  • D. HATORAH
     
  • (0-8-0-0)
@

  • YDE
     
  • (6-2-0-0)
Result
Win: 10-0
Fri Apr 24 2015 00:00:03
  • D. HATORAH
     
  • (0-8-0-0)
@

  • YDE
     
  • (6-2-0-0)
Result
Win: 11-1
Fri May 8 2015 00:00:03 22:00:00
  • D. HATORAH
     
  • (0-8-0-0)
@

  • FLATBUSH
     
  • (2-6-0-0)
Result
Win: 10-0
Sun May 10 2015 00:00:03 22:00:00
  • D. HATORAH
     
  • (0-8-0-0)
@

  • SHAARE T.
    Stars 
  • (7-1-0-0)
Result
Win: 10-0
Sun May 10 2015 13:00:00 22:00:00
  • D. HATORAH
     
  • (0-8-0-0)
@

  • SHAARE T.
    Stars 
  • (7-1-0-0)
Result
Win: 18-1
Tue May 12 2015 06:00:00 22:00:00
  • D. HATORAH
     
  • (0-8-0-0)
@

  • FLATBUSH
     
  • (2-6-0-0)
Result
Win: 11-4
Fri May 15 2015 06:00:00 22:00:00
  • D. HATORAH
     
  • (0-8-0-0)
@

  • MAGEN DAVID
     
  • (5-3-0-0)
Result
Win: 1-0
Fri May 15 2015 14:00:00 22:00:00
  • D. HATORAH
     
  • (0-8-0-0)
@

  • MAGEN DAVID
     
  • (5-3-0-0)
Result
Win: 1-0
Mon Oct 26 2015 07:30:00 22:00:00
  • NORTH SHORE
    Stars 
  • (4-6-0-0)
@

  • D. HATORAH
     
  • (6-4-0-0)
Result
Win: 58-49
Tue Nov 3 2015 08:00:00 22:00:00
  • D. HATORAH
     
  • (6-4-0-0)
@

  • SHAARE T.
    Stars 
  • (0-10-0-0)
Result
Loss: 44-58
Sun Nov 8 2015 08:00:00 22:00:00
  • D. HATORAH
     
  • (6-4-0-0)
@

  • DRS
    Wildcats 
  • (10-0-0-0)
Result
Win: 56-52
Thu Nov 12 2015 07:30:00 22:00:00
  • EZRA
     
  • (1-9-0-0)
@

  • D. HATORAH
     
  • (6-4-0-0)
Result
Win: 56-43
Mon Nov 16 2015 07:45:00 22:00:00
  • HANC
    Hurricanes 
  • (7-1-0-2)
@

  • D. HATORAH
     
  • (6-4-0-0)
Result
Win: 45-39
Wed Dec 2 2015 07:30:00 22:00:00
  • D. HATORAH
     
  • (6-4-0-0)
@

  • YDE
    Thunder 
  • (4-6-0-0)
Result
Loss: 61-72
Thu Dec 17 2015 07:30:00 22:00:00
  • HAFTR
    Hawks 
  • (8-2-0-0)
@

  • D. HATORAH
     
  • (6-4-0-0)
Result
Loss: 58-68
Mon Dec 21 2015 07:45:00 22:00:00
  • RAMBAM
    Ravens 
  • (2-7-0-1)
@

  • D. HATORAH
     
  • (6-4-0-0)
Result
Win: 64-59
Tue Dec 29 2015 07:30:00 22:00:00
  • D. HATORAH
     
  • (6-4-0-0)
@

  • MAGEN DAVID
    Warriors 
  • (8-2-0-0)
Result
Win: 62-61
Tue Jan 5 2016 07:00:00 22:00:00
  • D. HATORAH
     
  • (6-4-0-0)
@

  • FLATBUSH
    Falcons 
  • (5-4-0-1)
Result
Win: 50-39
Wed Feb 17 2016 07:30:00 22:00:00
  • D. HATORAH
     
  • (6-4-0-0)
@

  • HANC
    Hurricanes 
  • (7-1-0-2)
Result
Win: 49-48
Thu Nov 3 2016 07:30:00 22:00:00
  • MAGEN DAVID
    Warriors 
  • (6-8-0-0)
@

  • D. HATORAH
    Bulldogs 
  • (3-11-0-0)
Result
Win: 52-49
Mon Nov 7 2016 07:30:00 22:00:00
  • YDE
    Thunder 
  • (11-3-0-0)
@

  • D. HATORAH
    Bulldogs 
  • (3-11-0-0)
Result
Loss: 37-50
Thu Nov 10 2016 07:30:00 22:00:00
  • DRS
    Wildcats 
  • (10-4-0-0)
@

  • D. HATORAH
    Bulldogs 
  • (3-11-0-0)
Result
Loss: 50-51
Mon Nov 28 2016 08:30:00 22:00:00
  • D. HATORAH
    Bulldogs 
  • (3-11-0-0)
@

  • NORTH SHORE
    Stars 
  • (4-9-0-1)
Result
Win: 47-46
Thu Dec 1 2016 07:30:00 22:00:00
  • SSLI
    Storm 
  • (0-14-0-0)
@

  • D. HATORAH
    Bulldogs 
  • (3-11-0-0)
Result
Win: 72-45
Wed Dec 7 2016 07:30:00 22:00:00
  • D. HATORAH
    Bulldogs 
  • (3-11-0-0)
@

  • YDE
    Thunder 
  • (11-3-0-0)
Result
Win: 69-55
Sat Dec 10 2016 07:30:00 22:00:00
  • D. HATORAH
    Bulldogs 
  • (3-11-0-0)
@

  • SHAARE T.
    Stars 
  • (5-9-0-0)
Result
Win: 72-50
Mon Dec 12 2016 07:30:00 22:00:00
  • HANC
    Hurricanes 
  • (9-5-0-0)
@

  • D. HATORAH
    Bulldogs 
  • (3-11-0-0)
Result
Win: 76-58
Thu Dec 15 2016 07:30:00 22:00:00
  • FLATBUSH
    Falcons 
  • (10-3-0-1)
@

  • D. HATORAH
    Bulldogs 
  • (3-11-0-0)
Result
Loss: 58-86
Mon Dec 19 2016 08:15:00 22:00:00
  • D. HATORAH
    Bulldogs 
  • (3-11-0-0)
@

  • MAGEN DAVID
    Warriors 
  • (6-8-0-0)
Result
Win: 62-45
Thu Dec 22 2016 07:30:00 22:00:00
  • RAMBAM
    Ravens 
  • (10-3-0-1)
@

  • D. HATORAH
    Bulldogs 
  • (3-11-0-0)
Result
Loss: 48-63
Thu Feb 2 2017 07:30:00 22:00:00
  • SAR
    Sting 
  • (10-3-0-0)
@

  • D. HATORAH
    Bulldogs 
  • (3-11-0-0)
Result
Loss: 52-72
Tue Feb 7 2017 08:30:00 22:00:00
  • D. HATORAH
    Bulldogs 
  • (3-11-0-0)
@

  • HANC
    Hurricanes 
  • (9-5-0-0)
Result
Win: 74-49
Tue Feb 14 2017 08:30:00 22:00:00
  • D. HATORAH
    Bulldogs 
  • (3-11-0-0)
@

  • HAFTR
    Hawks 
  • (8-6-0-0)
Result
Win: 96-47
Sun Oct 22 2017 07:00:00 22:00:00
  • D. HATORAH
    Bulldogs 
  • (0-14-0-0)
@

  • RAMBAM
    Ravens 
  • (9-5-0-0)
Result
Win: 91-28
Thu Oct 26 2017 07:30:00 22:00:00
  • NORTH SHORE
    Stars 
  • (6-7-0-1)
@

  • D. HATORAH
    Bulldogs 
  • (0-14-0-0)
Result
Loss: 34-71
Thu Nov 2 2017 07:30:00 22:00:00
  • D. HATORAH
    Bulldogs 
  • (0-14-0-0)
@

  • YDE
    Thunder 
  • (5-9-0-0)
Result
Win: 92-27
Mon Nov 6 2017 07:30:00 22:00:00
  • SHAARE T.
    Stars 
  • (3-10-0-0)
@

  • D. HATORAH
    Bulldogs 
  • (0-14-0-0)
Result
Loss: 44-61
Sat Nov 11 2017 08:00:00 22:00:00
  • D. HATORAH
    Bulldogs 
  • (0-14-0-0)
@

  • DRS
    Wildcats 
  • (12-1-0-1)
Result
Win: 87-22
Thu Nov 16 2017 08:30:00 22:00:00
  • D. HATORAH
    Bulldogs 
  • (0-14-0-0)
@

  • FLATBUSH
    Falcons 
  • (6-7-0-1)
Result
Win: 75-25
Mon Nov 27 2017 07:30:00 22:00:00
  • HAFTR
    Hawks 
  • (7-7-0-0)
@

  • D. HATORAH
    Bulldogs 
  • (0-14-0-0)
Result
Loss: 22-80
Mon Dec 4 2017 07:30:00 22:00:00
  • SSLI
    Lions 
  • (2-11-0-0)
@

  • D. HATORAH
    Bulldogs 
  • (0-14-0-0)
Result
Loss: 56-57
Thu Dec 7 2017 07:45:00 22:00:00
  • MAGEN DAVID
    Warriors 
  • (14-0-0-0)
@

  • D. HATORAH
    Bulldogs 
  • (0-14-0-0)
Result
Loss: 20-67
Sat Dec 9 2017 09:00:00 22:00:00
  • D. HATORAH
    Bulldogs 
  • (0-14-0-0)
@

  • SHAARE T.
    Stars 
  • (3-10-0-0)
Result
Win: 97-48
Mon Dec 11 2017 07:30:00 22:00:00
  • HANC
    Hurricanes 
  • (8-6-0-0)
@

  • D. HATORAH
    Bulldogs 
  • (0-14-0-0)
Result
Loss: 46-86
Thu Dec 14 2017 07:15:00 22:00:00
  • D. HATORAH
    Bulldogs 
  • (0-14-0-0)
@

  • SSLI
    Lions 
  • (2-11-0-0)
Result
Win: 65-49
Tue Dec 19 2017 08:00:00 22:00:00
  • D. HATORAH
    Bulldogs 
  • (0-14-0-0)
@

  • RAMAZ
    Rams 
  • (8-6-0-0)
Result
Win: 68-45
Mon Jan 8 2018 08:45:00 22:00:00
  • D. HATORAH
    Bulldogs 
  • (0-14-0-0)
@

  • JEC
    Thunder 
  • (6-8-0-0)
Result
Win: 81-49
Tue Oct 30 2018 07:30:00 22:00:00
  • D. HATORAH
    Bulldogs 
  • (0-8-0-0)
@

  • HANC
    Hurricanes 
  • (3-5-0-0)
Result
Win: 74-16
Mon Nov 5 2018 07:30:00 22:00:00
  • HAFTR
    Hawks 
  • (5-1-0-0)
@

  • D. HATORAH
    Bulldogs 
  • (0-8-0-0)
Result
Loss: 21-81
Sun Nov 11 2018 06:00:00 22:00:00
  • D. HATORAH
    Bulldogs 
  • (0-8-0-0)
@

  • DRS
    Wildcats 
  • (5-0-0-2)
Result
Win: 60-13
Thu Nov 15 2018 07:30:00 22:00:00
  • FLATBUSH
    Falcons 
  • (3-5-0-0)
@

  • D. HATORAH
    Bulldogs 
  • (0-8-0-0)
Result
Loss: 19-61
Mon Nov 19 2018 07:30:00 22:00:00
  • SHAARE T.
    Stars 
  • (5-3-0-0)
@

  • D. HATORAH
    Bulldogs 
  • (0-8-0-0)
Result
Loss: 19-75
Thu Nov 29 2018 07:30:00 22:00:00
  • MAGEN DAVID
    Warriors 
  • (5-0-0-0)
@

  • D. HATORAH
    Bulldogs 
  • (0-8-0-0)
Result
Loss: 18-71
Tue Dec 4 2018 08:00:00 22:00:00
  • D. HATORAH
    Bulldogs 
  • (0-8-0-0)
@

  • NORTH SHORE
    Stars 
  • (8-1-0-0)
Result
Win: 53-27
Tue Dec 11 2018 08:00:00 22:00:00
  • D. HATORAH
    Bulldogs 
  • (0-8-0-0)
@

  • MAGEN DAVID
    Warriors 
  • (5-0-0-0)
Result
Win: 82-25
Thu Dec 20 2018 07:30:00 22:00:00
  • YDE
    Thunder 
  • (1-3-0-1)
@

  • D. HATORAH
    Bulldogs 
  • (0-8-0-0)
07:30
  • 2500 nostrand ave
  • Brooklyn , ny 11210
  • Map it!
Tue Dec 25 2018 07:30:00 22:00:00
  • D. HATORAH
    Bulldogs 
  • (0-8-0-0)
@

  • RAMBAM
    Ravens 
  • (0-6-0-0)
07:30
  • 15 frost lane
  • Lawrence, NY 11559
  • Map it!

Click on game to see more info