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 25
Date Game Result   Spectators Venue Info
10/11/2006 7:00: Leksands IF - Hammarby IF 4 - 5 ( 1-0, 1-4, 2-1 ) 3460 Ejendals Arena  
11/10/2006 7:00: IF Björklöven - VIK Västerås HK 3 - 1 ( 1-0, 1-0, 1-1 ) 2763 Umeå Arena  
11/12/2006 4:00: Nyköpings HK - IF Sundsvall Hockey 4 - 5 ( 2-1, 0-4, 2-0 ) 1225 Rosvalla Arena  
11/24/2006 7:00: Södertälje SK - Nybro Vikings IF 4 - 0 ( 2-0, 1-0, 1-0 ) 2423 AXA Sports Center  
12/8/2006 7:00:0 Bofors IK - IFK Arboga IK 3 - 2 ( 1-0, 2-0, 0-2 ) 1383 Nobelhallen  
12/8/2006 7:00:0 Rögle BK - Huddinge IK 3 - 1 ( 0-0, 1-1, 2-0 ) 2113 Ängelholms Ishall  
12/8/2006 7:00:0 IK Oskarshamn - Almtuna IS 4 - 0 ( 1-0, 0-0, 3-0 ) 1342 Arena Oskarshamn  
2/2/2007 7:00:00 AIK IF - Växjö Lakers HC 0 - 2 ( 0-0, 0-1, 0-1 ) 1150 Hovet, Johanneshov