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 42
Date Game Result   Spectators Venue Info
2/9/2009 7:00:00 IF Sundsvall Hockey - Växjö Lakers HC 5 - 3 ( 1-1, 2-1, 2-1 ) 655 Gärdehov  
2/17/2009 7:15:0 Mora IK - IF Björklöven 2 - 3 ( 1-1, 0-1, 1-1 ) 2022 FM Mattsson Arena  
2/18/2009 7:00:0 AIK IF - Leksands IF 3 - 4 ( 1-1, 2-1, 0-2 ) 8094 Hovet, Johanneshov  
2/18/2009 7:00:0 Nybro Vikings IF - IF Malmö Redhawks 4 - 5 ( 2-0, 2-3, 0-1, 0-0, 0-1 ) 1387 Victoriahallen  
2/18/2009 7:00:0 IF Troja/Ljungby - Almtuna IS 4 - 3 ( 1-2, 1-1, 2-0 ) 2209 Sunnerbohov  
2/18/2009 7:00:0 Mariestad BoIS HC - VIK Västerås HK 1 - 8 ( 1-2, 0-4, 0-2 ) 924 Katrinhallen  
2/18/2009 7:00:0 Huddinge IK - Borås HC 3 - 4 ( 1-1, 2-1, 0-2 ) 355 Björkängshallen  
2/18/2009 7:00:0 Bofors IK - IK Oskarshamn 6 - 3 ( 1-0, 1-2, 4-1 ) 1571 Nobelhallen