SELECT e.IpNamn as Arena, S_Match.Speltid, hasSerie.Division, hasGame.SpelOmgang AS Omg, hasGame.Speldatum as dat, hasGame.Matchnr, hasGame.Status, a.LagNamn AS Home, b.LagNamn AS Guest, hasGame.HemmaMal AS H, hasGame.BortaMal AS G, hasGame.Publik, hasGame.PeriodText, hasGame.Information, hasSerie.SerieID FROM hasGame inner join hasSerie on hasSerie.SeasonId = hasGame.SeasonId and hasSerie.SerieId = hasGame.SerieId inner join hasPlace e on e.IpId = hasGame.IpId left outer join S_Match on S_Match.Matchnr = hasGame.Matchnr inner join hasTeamMap c on c.SeasonId = hasGame.SeasonId and c.ForbLagId = hasGame.HemmalagId inner join hasTeamMap d on d.SeasonId = hasGame.SeasonId and d.ForbLagId = hasGame.BortalagId inner join hasTeam a on a.SeasonId = c.SeasonId and a.LagId = c.LagId inner join hasTeam b on b.SeasonId = d.SeasonId and b.LagId = d.LagId WHERE

HockeyAllsvenskan [Back]

Round 27
Date Game Result   Spectators Venue Info
12/14/2007 7:00: Huddinge IK - IF Björklöven 3 - 6 ( 2-3, 0-2, 1-1 ) 320 Björkängshallen  
12/14/2007 7:00: Hammarby IF - Rögle BK 2 - 5 ( 1-1, 0-1, 1-3 ) 174 Hovet, Johanneshov  
12/14/2007 7:00: IF Malmö Redhawks - IK Oskarshamn 4 - 3 ( 0-1, 1-1, 2-1, 1-0 ) 2711 Malmö Isstadion  
12/14/2007 7:00: IF Sundsvall Hockey - Nybro Vikings IF 4 - 2 ( 1-1, 2-1, 1-0 ) 590 Gärdehov  
12/14/2007 7:00: Nyköpings HK - Leksands IF 1 - 8 ( 1-2, 0-5, 0-1 ) 2705 Rosvalla Arena  
12/14/2007 7:00: Växjö Lakers HC - Bofors IK 4 - 3 ( 1-0, 1-1, 1-2, 1-0 ) 2088 Växjö Ishall  
12/14/2007 7:00: VIK Västerås HK - Almtuna IS 3 - 2 ( 0-1, 2-0, 1-1 ) 1898 ABB Arena  
1/6/2008 4:00:00 Borås HC - AIK IF 0 - 5 ( 0-1, 0-3, 0-1 ) 1459 Borås Ishall