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 44
Date Game Result   Spectators Venue Info
2/21/2007 7:00:0 Nyköpings HK - IF Sundsvall Hockey 2 - 3 ( 0-0, 1-2, 1-0, 0-1 ) 3214 Rosvalla Arena  
2/21/2007 7:00:0 AIK IF - Växjö Lakers HC 4 - 1 ( 1-0, 1-1, 2-0 ) 842 Hovet, Johanneshov  
2/21/2007 7:00:0 Bofors IK - IFK Arboga IK 9 - 3 ( 5-1, 2-0, 2-2 ) 1002 Nobelhallen  
2/21/2007 7:00:0 Södertälje SK - Nybro Vikings IF 9 - 1 ( 3-1, 2-0, 4-0 ) 2686 AXA Sports Center  
2/21/2007 7:00:0 Rögle BK - Huddinge IK 2 - 3 ( 0-1, 1-0, 1-1, 0-1 ) 1937 Ängelholms Ishall  
2/21/2007 7:00:0 IF Björklöven - VIK Västerås HK 3 - 4 ( 1-1, 1-1, 1-2 ) 2570 Umeå Arena  
2/21/2007 7:00:0 Leksands IF - Hammarby IF 8 - 2 ( 4-0, 2-2, 2-0 ) 3749 Ejendals Arena  
2/21/2007 7:00:0 IK Oskarshamn - Almtuna IS 10 - 1 ( 3-0, 3-0, 4-1 ) 1575 Arena Oskarshamn