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 = 12 or Away.school_id_fk = 12) AND GameDate > '10/1/2014' ORDER BY GameDate, NEWTIME ASC, GameTime ASC Thu Oct 31 2013 07:15:00
  • MSH
     
  • (5-7-0-0)
@

  • ILAN
     
  • (8-3-0-0)
Result
Win: 49-19
Tue Nov 5 2013 07:30:00
  • ILAN
     
  • (8-3-0-0)
@

  • BRURIAH
    Lightning 
  • (10-2-0-0)
Result
Loss: 27-30
Thu Nov 14 2013 07:30:00
  • SHULAMITH-BK
    Cyclones 
  • (1-11-0-0)
@

  • ILAN
     
  • (8-3-0-0)
Result
Win: 36-14
Thu Nov 21 2013 07:30:00
  • MAGEN DAVID
    Warriors 
  • (6-6-0-0)
@

  • ILAN
     
  • (8-3-0-0)
Result
Loss: 28-31
Tue Nov 26 2013 07:15:00
  • ILAN
     
  • (8-3-0-0)
@

  • MSH
     
  • (5-7-0-0)
Result
Loss: 28-37
Mon Dec 16 2013 07:30:00
  • ILAN
     
  • (8-3-0-0)
@

  • MAGEN DAVID
    Warriors 
  • (6-6-0-0)
Result
Loss: 16-41
Thu Dec 19 2013 07:00:00
  • SHAARE T.
    Stars 
  • (1-10-0-0)
@

  • ILAN
     
  • (8-3-0-0)
Result
Win: 1-0
Mon Dec 23 2013 07:30:00
  • ILAN
     
  • (8-3-0-0)
@

  • SHULAMITH-BK
    Cyclones 
  • (1-11-0-0)
Result
Loss: 0-1
Mon Dec 30 2013 07:45:00
  • SKA
    Sonics 
  • (10-2-0-0)
@

  • ILAN
     
  • (8-3-0-0)
Result
Win: 41-19
Thu Jan 30 2014 07:30:00
  • BRURIAH
    Lightning 
  • (10-2-0-0)
@

  • ILAN
     
  • (8-3-0-0)
Result
Loss: 23-29
Thu Feb 6 2014 07:30:00
  • ILAN
     
  • (8-3-0-0)
@

  • SKA
    Sonics 
  • (10-2-0-0)
Result
Win: 32-16
Wed Feb 19 2014 07:00:00
  • ILAN
     
  • (8-3-0-0)
@

  • SKA
    Sonics 
  • (10-2-0-0)
Result
Win: 52-28
Wed Mar 19 2014 08:15:00
  • SAR
    Sting 
  • (5-3-0-0)
@

  • ILAN
     
  • (0-8-0-0)
Result
Loss: 2-9
Sun Mar 23 2014 01:00:00
  • ILAN
     
  • (0-8-0-0)
@

  • SAR
    Sting 
  • (5-3-0-0)
Result
Win: 9-2
Sun Mar 30 2014 12:00:00
  • ILAN
     
  • (0-8-0-0)
@

  • KUSHNER
    Cobras 
  • (4-2-0-2)
Result
Win: 1-0
Thu Apr 3 2014 07:30:00
  • BRURIAH
    Lightning 
  • (3-5-0-0)
@

  • ILAN
     
  • (0-8-0-0)
Result
Loss: 3-10
Wed Apr 9 2014 07:30:00
  • FRISCH
    Cougars 
  • (5-3-0-0)
@

  • ILAN
     
  • (0-8-0-0)
Result
Loss: 2-7
Thu Apr 24 2014 08:00:00
  • MAAYANOT
    Rapids 
  • (7-1-0-0)
@

  • ILAN
     
  • (0-8-0-0)
Result
Loss: 4-11
Sun Apr 27 2014 02:30:00
  • ILAN
     
  • (3-4-0-0)
@

  • BRURIAH
     
  • (8-0-0-0)
Result
Win: 14-9
Sun Apr 27 2014 11:00:00
  • ILAN
     
  • (0-8-0-0)
@

  • FRISCH
    Cougars 
  • (5-3-0-0)
Result
Win: 7-0
Sun May 4 2014 04:30:00
  • ILAN
     
  • (0-8-0-0)
@

  • MAAYANOT
    Rapids 
  • (7-1-0-0)
Result
Win: 9-2
Tue May 6 2014 05:30:00
  • ILAN
     
  • (3-4-0-0)
@

  • HILLEL
     
  • (4-4-0-0)
Result
Loss: 4-5
Mon May 12 2014 05:30:00
  • KUSHNER
     
  • (2-6-0-0)
@

  • ILAN
     
  • (3-4-0-0)
Result
Win: 1-0
Tue May 13 2014 07:00:00
  • ILAN
     
  • (3-4-0-0)
@

  • MAAYANOT
     
  • (7-1-0-0)
Result
Win: 5-0
Thu May 15 2014 07:00:00
  • HESCHEL
     
  • (0-7-1-0)
@

  • ILAN
     
  • (3-4-0-0)
Result
Win: 12-2
Sun May 18 2014 02:00:00
  • FRISCH
     
  • (5-3-0-0)
@

  • ILAN
     
  • (3-4-0-0)
Result
Loss: 2-13
Tue May 27 2014 06:15:00
  • HILLEL
     
  • (4-4-0-0)
@

  • ILAN
     
  • (3-4-0-0)
Result
Loss: 8-9
Sun Jun 1 2014 09:30:00
  • ILAN
     
  • (3-4-0-0)
@

  • CENTRAL
    WILDCATS 
  • (7-0-1-0)
Result
Win: 13-10
Wed Nov 12 2014 07:30:00
  • SHAARE T.
    Stars 
  • (2-10-0-0)
@

  • ILAN
     
  • (6-6-0-0)
Result
Win: 40-17
Mon Nov 17 2014 07:30:00
  • MSH
     
  • (6-6-0-0)
@

  • ILAN
     
  • (6-6-0-0)
Result
Win: 39-27
Mon Nov 24 2014 07:30:00
  • ILAN
     
  • (6-6-0-0)
@

  • BRURIAH
    Lightning 
  • (10-2-0-0)
Result
Win: 34-30
Tue Nov 25 2014 07:30:00
  • SHULAMITH-BK
    Cyclones 
  • (0-12-0-0)
@

  • ILAN
     
  • (6-6-0-0)
Result
Win: 36-12
Thu Dec 4 2014 07:30:00
  • BRURIAH
    Lightning 
  • (10-2-0-0)
@

  • ILAN
     
  • (6-6-0-0)
Result
Loss: 24-43
Mon Dec 8 2014 07:30:00
  • ILAN
     
  • (6-6-0-0)
@

  • SHAARE T.
    Stars 
  • (2-10-0-0)
Result
Loss: 24-37
Thu Dec 18 2014 07:30:00
  • ILAN
     
  • (6-6-0-0)
@

  • MSH
     
  • (6-6-0-0)
Result
Win: 35-33
Tue Dec 23 2014 07:30:00
  • MAGEN DAVID
    Warriors 
  • (6-6-0-0)
@

  • ILAN
     
  • (6-6-0-0)
Result
Win: 23-22
Tue Jan 6 2015 07:00:00
  • ILAN
     
  • (6-6-0-0)
@

  • SHULAMITH-BK
    Cyclones 
  • (0-12-0-0)
Result
Loss: 21-48
Sun Feb 1 2015 11:00:00
  • ILAN
     
  • (6-6-0-0)
@

  • MAGEN DAVID
    Warriors 
  • (6-6-0-0)
Result
Win: 36-26
Tue Feb 3 2015 07:00:00
  • ILAN
     
  • (6-6-0-0)
@

  • SKA
    Sonics 
  • (12-0-0-0)
Result
Win: 41-23
Thu Feb 5 2015 08:00:00
  • SKA
    Sonics 
  • (12-0-0-0)
@

  • ILAN
     
  • (6-6-0-0)
Result
Loss: 23-24
Tue Feb 24 2015 07:30:00
  • MAGEN DAVID
    Warriors 
  • (6-6-0-0)
@

  • ILAN
     
  • (6-6-0-0)
Result
Win: 24-16
Tue Feb 24 2015 07:30:00
  • ILAN
     
  • (6-6-0-0)
@

  • MSH
     
  • (6-6-0-0)
Result
Loss: 14-21
Mon Mar 9 2015 07:30:00
  • ILAN
     
  • (6-6-0-0)
@

  • BRURIAH
    Lightning 
  • (10-2-0-0)
Result
Win: 52-24
Tue Apr 21 2015 18:00:00
  • HILLEL
     
  • (6-2-0-0)
@

  • ILAN
     
  • (4-4-0-0)
Result
Loss: 6-8
Sun Apr 26 2015 04:00:00
  • MAAYANOT
     
  • (7-1-0-0)
@

  • ILAN
     
  • (4-4-0-0)
Result
Win: 7-3
Sun Apr 26 2015 14:00:00
  • BRURIAH
     
  • (5-3-0-0)
@

  • ILAN
     
  • (4-4-0-0)
Result
Loss: 3-17
Mon Apr 27 2015 17:30:00
  • HESCHEL
     
  • (2-6-0-0)
@

  • ILAN
     
  • (4-4-0-0)
Result
Win: 12-3
Wed Apr 29 2015 18:00:00
  • ILAN
     
  • (4-4-0-0)
@

  • HILLEL
     
  • (6-2-0-0)
Result
Win: 15-0
Tue May 5 2015 06:00:00
  • ILAN
     
  • (4-4-0-0)
@

  • KUSHNER
     
  • (1-7-0-0)
Result
Loss: 1-18
Mon May 11 2015 18:00:00
  • ILAN
     
  • (4-4-0-0)
@

  • FRISCH
     
  • (6-2-0-0)
Result
Win: 15-4
Tue May 12 2015 18:15:00
  • ILAN
     
  • (4-4-0-0)
@

  • RAMAZ
     
  • (1-7-0-0)
Result
Loss: 1-9
Tue Nov 17 2015 07:30:00
  • SHULAMITH-BK
    Cyclones 
  • (0-12-0-0)
@

  • ILAN
     
  • (7-5-0-0)
Result
Win: 46-14
Mon Nov 30 2015 07:30:00
  • SKA
    Sonics 
  • (11-1-0-0)
@

  • ILAN
     
  • (7-5-0-0)
Result
Loss: 27-35
Tue Dec 1 2015 07:30:00
  • BRURIAH
    Lightning 
  • (8-3-0-1)
@

  • ILAN
     
  • (7-5-0-0)
Result
Loss: 12-28
Tue Dec 8 2015 07:30:00
  • ILAN
     
  • (7-5-0-0)
@

  • MSH
    Sabers 
  • (8-4-0-0)
Result
Win: 46-26
Thu Dec 10 2015 07:30:00
  • MAGEN DAVID
    Warriors 
  • (2-10-0-0)
@

  • ILAN
     
  • (7-5-0-0)
Result
Win: 39-32
Tue Dec 15 2015 07:15:00
  • ILAN
     
  • (7-5-0-0)
@

  • SHULAMITH-BK
    Cyclones 
  • (0-12-0-0)
Result
Loss: 25-46
Mon Dec 21 2015 08:00:00
  • ILAN
     
  • (7-5-0-0)
@

  • SKA
    Sonics 
  • (11-1-0-0)
Result
Win: 33-21
Tue Dec 29 2015 07:30:00
  • ILAN
     
  • (7-5-0-0)
@

  • BRURIAH
    Lightning 
  • (8-3-0-1)
Result
Win: 49-21
Tue Jan 5 2016 07:15:00
  • ILAN
     
  • (7-5-0-0)
@

  • SHULAMITH-BK
    Cyclones 
  • (0-12-0-0)
Result
Loss: 16-25
Thu Feb 4 2016 07:30:00
  • MSH
    Sabers 
  • (8-4-0-0)
@

  • ILAN
     
  • (7-5-0-0)
Result
Win: 57-36
Mon Feb 8 2016 07:30:00
  • ILAN
     
  • (7-5-0-0)
@

  • MAGEN DAVID
    Warriors 
  • (2-10-0-0)
Result
Loss: 25-46
Tue Feb 16 2016 07:30:00
  • BRURIAH
    Lightning 
  • (8-3-0-1)
@

  • ILAN
     
  • (7-5-0-0)
Result
Win: 38-34
Wed Mar 2 2016 07:30:00
  • ILAN
     
  • (7-5-0-0)
@

  • SKA
    Sonics 
  • (11-1-0-0)
Result
Win: 38-22
Tue Mar 22 2016 06:00:00
  • HILLEL
     
  • (4-4-0-0)
@

  • ILAN
     
  • (0-7-1-0)
Result
Loss: 4-6
Sun Apr 10 2016 06:00:00
  • ILAN
     
  • (0-7-1-0)
@

  • SAR
    Sting 
  • (7-1-0-0)
Result
Win: 11-4
Mon Apr 11 2016 07:00:00
  • BRURIAH
    Lightning 
  • (0-6-2-0)
@

  • ILAN
     
  • (0-7-1-0)
Result
Tie: 3-3
Wed Apr 13 2016 05:00:00
  • ILAN
     
  • (0-7-1-0)
@

  • HILLEL
     
  • (4-4-0-0)
Result
Win: 4-3
Sun Apr 17 2016 03:00:00
  • ILAN
     
  • (0-7-1-0)
@

  • KUSHNER
    Cobras 
  • (5-3-0-0)
Result
Win: 12-8
Mon May 2 2016 08:00:00
  • ILAN
     
  • (0-7-1-0)
@

  • FRISCH
    Cougars 
  • (3-4-1-0)
Result
Win: 8-7
Tue May 3 2016 07:30:00
  • KUSHNER
    Cobras 
  • (5-3-0-0)
@

  • ILAN
     
  • (0-7-1-0)
Result
Loss: 5-12
Tue May 10 2016 07:45:00
  • MAAYANOT
    Rapids 
  • (7-1-0-0)
@

  • ILAN
     
  • (0-7-1-0)
Result
Loss: 4-11
Mon Nov 7 2016 07:30:00
  • SHAARE T. Girls
    STARS 
  • (0-12-0-0)
@

  • ILAN
    Invaders 
  • (5-7-0-0)
Result
Win: 59-12
Mon Nov 14 2016 07:30:00
  • ILAN
    Invaders 
  • (5-7-0-0)
@

  • MAGEN DAVID
    Warriors 
  • (6-6-0-0)
Result
Win: 36-28
Mon Nov 21 2016 07:30:00
  • SKA
    Sonics 
  • (12-0-0-0)
@

  • ILAN
    Invaders 
  • (5-7-0-0)
Result
Loss: 20-34
Mon Nov 28 2016 07:30:00
  • ILAN
    Invaders 
  • (5-7-0-0)
@

  • BRURIAH
    Lightning 
  • (10-2-0-0)
Result
Win: 42-21
Wed Dec 7 2016 07:30:00
  • ILAN
    Invaders 
  • (5-7-0-0)
@

  • SKA
    Sonics 
  • (12-0-0-0)
Result
Win: 55-15
Mon Dec 12 2016 07:30:00
  • ILAN
    Invaders 
  • (5-7-0-0)
@

  • BRURIAH
    Lightning 
  • (10-2-0-0)
Result
Win: 54-20
Mon Dec 19 2016 07:30:00
  • MAGEN DAVID
    Warriors 
  • (6-6-0-0)
@

  • ILAN
    Invaders 
  • (5-7-0-0)
Result
Loss: 19-28
Thu Dec 22 2016 07:30:00
  • MSH
    Sabers 
  • (3-8-0-1)
@

  • ILAN
    Invaders 
  • (5-7-0-0)
Result
Win: 35-10
Thu Dec 29 2016 07:30:00
  • MAGEN DAVID
    Warriors 
  • (6-6-0-0)
@

  • ILAN
    Invaders 
  • (5-7-0-0)
Result
Win: 42-30
Tue Jan 3 2017 07:30:00
  • BRURIAH
    Lightning 
  • (10-2-0-0)
@

  • ILAN
    Invaders 
  • (5-7-0-0)
Result
Loss: 16-23
Thu Feb 2 2017 07:30:00
  • ILAN
    Invaders 
  • (5-7-0-0)
@

  • SHAARE T. Girls
    STARS 
  • (0-12-0-0)
Result
Loss: 0-1
Tue Feb 7 2017 07:30:00
  • ILAN
    Invaders 
  • (5-7-0-0)
@

  • MSH
    Sabers 
  • (3-8-0-1)
Result
Loss: 19-40
Mon Mar 6 2017 07:30:00
  • ILAN
    Invaders 
  • (5-7-0-0)
@

  • SKA
    Sonics 
  • (12-0-0-0)
Result
Win: 34-21
Sun Apr 23 2017 02:00:00
  • BRURIAH
     
  • (5-3-0-0)
@

  • ILAN
     
  • (2-6-0-0)
Result
Loss: 2-12
Sun Apr 23 2017 11:30:00
  • SAR
     
  • (7-1-0-0)
@

  • ILAN
     
  • (2-6-0-0)
Result
Loss: 0-10
Sun Apr 30 2017 03:15:00
  • FRISCH
     
  • (5-3-0-0)
@

  • ILAN
     
  • (2-6-0-0)
Result
Loss: 1-7
Mon May 1 2017 06:00:00
  • ILAN
     
  • (2-6-0-0)
@

  • KUSHNER
     
  • (2-6-0-0)
Result
Loss: 2-12
Tue May 2 2017 05:30:00
  • ILAN
     
  • (2-6-0-0)
@

  • HILLEL
     
  • (5-3-0-0)
Result
Win: 11-1
Thu May 4 2017 07:30:00
  • ILAN
     
  • (2-6-0-0)
@

  • HESCHEL
     
  • (0-8-0-0)
Result
Loss: 4-19
Sun May 7 2017 04:00:00
  • MAAYANOT
     
  • (6-2-0-0)
@

  • ILAN
     
  • (2-6-0-0)
Result
Loss: 1-11
Mon May 15 2017 05:45:00
  • HILLEL
     
  • (5-3-0-0)
@

  • ILAN
     
  • (2-6-0-0)
Result
Loss: 1-11
Thu Nov 16 2017 07:30:00
  • BRURIAH
    Lightning 
  • (12-0-0-0)
@

  • ILAN
    Invaders 
  • (8-4-0-0)
Result
Loss: 29-40
Wed Nov 22 2017 07:30:00
  • ILAN
    Invaders 
  • (8-4-0-0)
@

  • SHAARE T. Girls
    Stars 
  • (0-12-0-0)
Result
Loss: 4-60
Thu Nov 30 2017 07:30:00
  • ILAN
    Invaders 
  • (8-4-0-0)
@

  • SKA
    Sonics 
  • (8-4-0-0)
Result
Win: 40-33
Thu Dec 7 2017 07:30:00
  • MAGEN DAVID
    Warriors 
  • (8-4-0-0)
@

  • ILAN
    Invaders 
  • (8-4-0-0)
Result
Win: 27-10
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
  • ILAN
    Invaders 
  • (8-4-0-0)
@

  • BRURIAH
    Lightning 
  • (12-0-0-0)
Result
Win: 36-26
Tue Dec 26 2017 06:40:00
  • SHAARE T. Girls
    Stars 
  • (0-12-0-0)
@

  • ILAN
    Invaders 
  • (8-4-0-0)
Result
Win: 64-3
Tue Jan 2 2018 07:30:00
  • SHULAMITH-LI
    Sparks 
  • (2-10-0-0)
@

  • ILAN
    Invaders 
  • (8-4-0-0)
Result
Win: 50-20
Mon Jan 8 2018 08:00:00
  • ILAN
    Invaders 
  • (8-4-0-0)
@

  • MAGEN DAVID
    Warriors 
  • (8-4-0-0)
Result
Loss: 35-36
Thu Feb 1 2018 07:00:00
  • SKA
    Sonics 
  • (8-4-0-0)
@

  • ILAN
    Invaders 
  • (8-4-0-0)
Result
Loss: 41-42
Thu Feb 8 2018 07:30:00
  • ILAN
    Invaders 
  • (8-4-0-0)
@

  • MSH
    Sabers 
  • (4-8-0-0)
Result
Loss: 19-52
Tue Feb 13 2018 06:30:00
  • MSH
    Sabers 
  • (4-8-0-0)
@

  • ILAN
    Invaders 
  • (8-4-0-0)
Result
Win: 45-15
Wed Feb 21 2018 06:30:00
  • SKA
    Sonics 
  • (8-4-0-0)
@

  • ILAN
    Invaders 
  • (8-4-0-0)
Result
Win: 38-30
Tue Mar 6 2018 08:30:00
  • BRURIAH
    Lightning 
  • (12-0-0-0)
@

  • ILAN
    Invaders 
  • (8-4-0-0)
Result
Win: 37-35
Tue Mar 13 2018 07:00:00
  • SAR
    Sting 
  • (5-3-0-0)
@

  • ILAN
    Ilan High School 
  • (0-6-1-1)
Result
Loss: 4-7
Thu Mar 15 2018 06:15:00
  • ILAN
    Ilan High School 
  • (0-6-1-1)
@

  • KUSHNER
    Cobras 
  • (7-1-0-0)
Result
Win: 9-2
Mon Mar 26 2018 07:30:00
  • MAAYANOT
    Rapids 
  • (8-0-0-0)
@

  • ILAN
    Ilan High School 
  • (0-6-1-1)
Result
Loss: 3-10
Thu Apr 19 2018 06:00:00
  • HILLEL
    Hillel Heat 
  • (2-5-1-0)
@

  • ILAN
    Ilan High School 
  • (0-6-1-1)
Result
Overtime Loss: 4-5
Mon Apr 30 2018 07:30:00
  • KUSHNER
    Cobras 
  • (7-1-0-0)
@

  • ILAN
    Ilan High School 
  • (0-6-1-1)
Result
Loss: 1-8
Tue May 1 2018 06:30:00
  • ILAN
    Ilan High School 
  • (0-6-1-1)
@

  • FRISCH
    Cougars 
  • (2-6-0-0)
Result
Win: 10-3
Thu May 3 2018 06:15:00
  • ILAN
    Ilan High School 
  • (0-6-1-1)
@

  • BRURIAH
    Lightning 
  • (3-5-0-0)
Result
Win: 9-2
Wed May 9 2018 06:00:00
  • ILAN
    Ilan High School 
  • (0-6-1-1)
@

  • HILLEL
    Hillel Heat 
  • (2-5-1-0)
Result
Tie: 0-0
TBA TBA
  • RAMAZ
     
  • (1-5-1-0)
@

  • ILAN
     
  • (3-4-0-0)
Result
: 0-0
TBA TBA
  • ILAN
     
  • (8-3-0-0)
@

  • SHAARE T.
    Stars 
  • (1-10-0-0)
Result
: 0-0

Click on game to see more info