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 = 35 or Away.school_id_fk = 35) AND GameDate > '10/1/2014' ORDER BY GameDate, NEWTIME ASC, GameTime ASC Fri Apr 15 2016 22:00:00
  • DARCHEI
     
  • (1-7-0-0)
@

  • RAMBAM
     
  • (3-5-0-0)
Result
Win: 14-1
Fri Apr 15 2016 01:00:00 22:00:00
  • DARCHEI
     
  • (1-7-0-0)
@

  • RAMBAM
     
  • (3-5-0-0)
Result
Win: 4-2
Sun Apr 17 2016 03:00:00 22:00:00
  • DARCHEI
     
  • (1-7-0-0)
@

  • HANC
    Hurricanes 
  • (5-3-0-0)
Result
Win: 8-3
Wed May 11 2016 06:45:00 22:00:00
  • DARCHEI
     
  • (1-7-0-0)
@

  • HAFTR
     
  • (2-6-0-0)
Result
Win: 3-1
Fri May 13 2016 06:45:00 22:00:00
  • DARCHEI
     
  • (1-7-0-0)
@

  • MAY
     
  • (5-3-0-0)
Result
Win: 5-3
Fri May 13 2016 01:00:00 22:00:00
  • DARCHEI
     
  • (1-7-0-0)
@

  • MAY
     
  • (5-3-0-0)
Result
Loss: 2-5
Sun May 15 2016 04:45:00 22:00:00
  • DARCHEI
     
  • (1-7-0-0)
@

  • DRS
     
  • (8-0-0-0)
Result
Win: 9-5
Sun May 15 2016 04:45:00 22:00:00
  • DRS
     
  • (8-0-0-0)
@

  • DARCHEI
     
  • (1-7-0-0)
Result
Loss: 2-5
Fri Apr 7 2017 04:45:00 22:00:00
  • DARCHEI
     
  • (4-4-0-0)
@

  • DRS
    wildcats  
  • (6-2-0-0)
Result
Win: 8-3
Fri Apr 7 2017 12:00:00 22:00:00
  • DARCHEI
     
  • (4-4-0-0)
@

  • DRS
    wildcats  
  • (6-2-0-0)
Result
Win: 12-6
Sun May 7 2017 12:00:00 22:00:00
  • DARCHEI
     
  • (4-4-0-0)
@

  • HANC
    Hurricanes 
  • (0-8-0-0)
Result
Loss: 4-12
Sun May 7 2017 03:45:00 22:00:00
  • DARCHEI
     
  • (4-4-0-0)
@

  • HANC
    Hurricanes 
  • (0-8-0-0)
Result
Loss: 1-9
Mon May 8 2017 06:00:00 22:00:00
  • DARCHEI
     
  • (4-4-0-0)
@

  • HAFTR
     
  • (4-3-1-0)
Result
Loss: 2-3
Wed May 10 2017 06:30:00 22:00:00
  • DARCHEI
     
  • (4-4-0-0)
@

  • RAMBAM
     
  • (4-4-0-0)
Result
Loss: 3-13
Fri May 12 2017 01:45:00 22:00:00
  • DARCHEI
     
  • (4-4-0-0)
@

  • HAFTR
     
  • (4-3-1-0)
Result
Win: 1-0
Fri May 12 2017 03:15:00 22:00:00
  • DARCHEI
     
  • (4-4-0-0)
@

  • MAY
     
  • (5-2-1-0)
Result
Win: 5-0

Click on game to see more info