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 31
Date Game Result   Spectators Venue Info
1/15/2006 4:00:0 Växjö Lakers HC - Almtuna IS 2 - 3 ( 0-0, 2-3, 0-0 ) 2505 Växjö Ishall  
1/15/2006 4:00:0 Bofors IK - VIK Västerås HK 3 - 2 ( 0-1, 2-1, 1-0 ) 2478 Nobelhallen  
1/15/2006 4:00:0 IK Nyköping Hockey - Hammarby IF 2 - 6 ( 1-1, 1-2, 0-3 ) 1441 Rosvalla Arena  
1/15/2006 4:00:0 IFK Arboga IK - Rögle BK 1 - 3 ( 0-1, 1-0, 0-2 ) 836 Sparbanken Arena  
1/15/2006 4:00:0 AIK IF - IF Malmö Redhawks 2 - 4 ( 1-1, 0-3, 1-0 ) 1576 Hovet, Johanneshov  
1/15/2006 4:00:0 Skellefteå AIK - Nybro Vikings IF 4 - 3 ( 0-2, 3-1, 1-0 ) 2415 Skellefteå Kraft Arena  
1/15/2006 4:00:0 IF Björklöven - IK Oskarshamn 3 - 0 ( 1-0, 1-0, 1-0 ) 3225 Umeå Arena