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 = 37 or Away.school_id_fk = 37) AND GameDate > '10/1/2014' ORDER BY GameDate, NEWTIME ASC, GameTime ASC Thu Nov 9 2017 07:30:00
  • SHULAMITH-LI
    Sparks 
  • (2-10-0-0)
@

  • MSH
    Sabers 
  • (4-8-0-0)
Result
Win: 33-17
Wed Nov 22 2017 07:30:00
  • SHULAMITH-LI
    Sparks 
  • (2-10-0-0)
@

  • BRURIAH
    Lightning 
  • (12-0-0-0)
Result
Win: 52-12
Wed Dec 6 2017 07:00:00
  • SHAARE T. Girls
    Stars 
  • (0-12-0-0)
@

  • SHULAMITH-LI
    Sparks 
  • (2-10-0-0)
Result
Win: 31-18
Wed Dec 13 2017 07:30:00
  • ILAN
    Invaders 
  • (8-4-0-0)
@

  • SHULAMITH-LI
    Sparks 
  • (2-10-0-0)
Result
Loss: 14-50
Wed Dec 20 2017 07:30:00
  • MSH
    Sabers 
  • (4-8-0-0)
@

  • SHULAMITH-LI
    Sparks 
  • (2-10-0-0)
Result
Loss: 18-21
Thu Dec 21 2017 07:00:00
  • SKA
    Sonics 
  • (8-4-0-0)
@

  • SHULAMITH-LI
    Sparks 
  • (2-10-0-0)
Result
Loss: 18-58
Wed Dec 27 2017 08:00:00
  • SHULAMITH-LI
    Sparks 
  • (2-10-0-0)
@

  • MAGEN DAVID
    Warriors 
  • (8-4-0-0)
Result
Win: 58-18
Tue Jan 2 2018 07:30:00
  • SHULAMITH-LI
    Sparks 
  • (2-10-0-0)
@

  • ILAN
    Invaders 
  • (8-4-0-0)
Result
Win: 50-20
Wed Jan 31 2018 07:30:00
  • BRURIAH
    Lightning 
  • (12-0-0-0)
@

  • SHULAMITH-LI
    Sparks 
  • (2-10-0-0)
Result
Loss: 9-49
Thu Feb 1 2018 07:30:00
  • SHULAMITH-LI
    Sparks 
  • (2-10-0-0)
@

  • MAGEN DAVID
    Warriors 
  • (8-4-0-0)
Result
Win: 39-23
Sun Feb 4 2018 11:00:00
  • SHULAMITH-LI
    Sparks 
  • (2-10-0-0)
@

  • SKA
    Sonics 
  • (8-4-0-0)
Result
Win: 46-14
Wed Feb 7 2018 07:00:00
  • SHULAMITH-LI
    Sparks 
  • (2-10-0-0)
@

  • SHAARE T. Girls
    Stars 
  • (0-12-0-0)
Result
Loss: 9-35
Wed Oct 17 2018 06:30:00
  • SKA
    Sonics 
  • (4-2-0-0)
@

  • SHULAMITH-LI
    Sharks 
  • (1-4-0-0)
Result
Loss: 0-0
Thu Oct 25 2018 08:00:00
  • NAALEH
    Eagles 
  • (0-6-0-0)
@

  • SHULAMITH-LI
    Sharks 
  • (5-4-0-0)
Result
Win: 30-21
Wed Oct 31 2018 07:30:00
  • SHAARE T. Girls
    Stars 
  • (1-6-0-0)
@

  • SHULAMITH-LI
    Sharks 
  • (5-4-0-0)
Result
Win: 35-23
Mon Nov 5 2018 08:00:00
  • SHULAMITH-LI
    Sharks 
  • (1-4-0-0)
@

  • MAGEN DAVID
    Warriors 
  • (5-0-0-0)
Result
Win: 0-0
Wed Nov 7 2018 08:00:00
  • ILAN
    Invaders 
  • (3-1-0-0)
@

  • SHULAMITH-LI
    Sharks 
  • (5-4-0-0)
Result
Loss: 17-32
Thu Nov 8 2018 08:15:00
  • MAAYANOT
    Rapids 
  • (1-5-0-0)
@

  • SHULAMITH-LI
    Sharks 
  • (1-4-0-0)
Result
Win: 0-0
Wed Nov 14 2018 07:30:00
  • SHULAMITH-BK
    Dynamites 
  • (3-6-0-0)
@

  • SHULAMITH-LI
    Sharks 
  • (1-4-0-0)
Result
Loss: 0-0
Thu Nov 15 2018 06:30:00
  • MSH
    Sabers 
  • (1-6-0-0)
@

  • SHULAMITH-LI
    Sharks 
  • (5-4-0-0)
Result
Win: 14-7
Sun Nov 18 2018 05:30:00
  • SHULAMITH-LI
    Sharks 
  • (5-4-0-0)
@

  • BRURIAH
    Lightning 
  • (6-2-0-0)
Result
Win: 39-19
Wed Nov 21 2018 07:30:00
  • SHULAMITH-LI
    Sharks 
  • (5-4-0-0)
@

  • SHAARE T. Girls
    Stars 
  • (1-6-0-0)
Result
Loss: 23-40
Mon Nov 26 2018 07:45:00
  • BRURIAH
    Lightning 
  • (6-2-0-0)
@

  • SHULAMITH-LI
    Sharks 
  • (5-4-0-0)
Result
Loss: 22-41
Wed Nov 28 2018 06:15:00
  • SHULAMITH-LI
    Sharks 
  • (5-4-0-0)
@

  • SKA
    Sonics 
  • (6-0-0-0)
Result
Win: 45-20
Thu Nov 29 2018 08:00:00
  • BRURIAH
    Lightning 
  • (4-1-0-0)
@

  • SHULAMITH-LI
    Sharks 
  • (1-4-0-0)
Result
Loss: 0-0
Thu Dec 13 2018 08:00:00
  • SHULAMITH-LI
    Sharks 
  • (5-4-0-0)
@

  • NAALEH
    Eagles 
  • (0-6-0-0)
Result
Loss: 10-30
Sun Dec 16 2018 01:00:00
  • SHULAMITH-LI
    Sharks 
  • (1-4-0-0)
@

  • MAAYANOT
    Rapids 
  • (1-5-0-0)
01:00
  • 1650 Palisade Avenue
  • Teaneck, NJ 07666
  • Map it!
Mon Dec 17 2018 07:30:00
  • SHULAMITH-LI
    Sharks 
  • (1-4-0-0)
@

  • SHULAMITH-BK
    Dynamites 
  • (3-6-0-0)
07:30
  • 60 West End Avenue
  • 7th Floor
  • Brooklyn, NY 11235
  • Map it!
Thu Dec 20 2018 07:45:00
  • MAGEN DAVID
    Warriors 
  • (5-0-0-0)
@

  • SHULAMITH-LI
    Sharks 
  • (1-4-0-0)
07:45
  • 195 Broadway
  • Lawrence, NY 11559
  • Map it!
Mon Dec 31 2018 06:15:00
  • SHULAMITH-LI
    Sharks 
  • (1-4-0-0)
@

  • SKA
    Sonics 
  • (4-2-0-0)
06:15
  • 291 Meadowview Ave
  • Hewlett Bay Park, NY 11557
  • Map it!
Thu Jan 3 2019 06:30:00
  • SHULAMITH-LI
    Sharks 
  • (5-4-0-0)
@

  • MSH
    Sabers 
  • (1-6-0-0)
06:30
  • 195 Broadway
  • Lawrence, NY 11559
  • Map it!
Tue Jan 29 2019 08:00:00
  • SHULAMITH-LI
    Sharks 
  • (1-4-0-0)
@

  • BRURIAH
    Lightning 
  • (4-1-0-0)
08:00
  • 35 North Avenue
  • Elizabeth, NJ 07208
  • Map it!
Thu Jan 31 2019 08:00:00
  • MAGEN DAVID
    Warriors 
  • (4-1-0-0)
@

  • SHULAMITH-LI
    Sharks 
  • (5-4-0-0)
08:00
  • 195 Broadway
  • Lawrence , NY 11559
  • Map it!

Click on game to see more info