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 40
Date Game Result   Spectators Venue Info
2/10/2009 7:15:0 IF Troja/Ljungby - Nybro Vikings IF 4 - 3 ( 1-2, 2-1, 1-0 ) 1279 Sunnerbohov  
2/11/2009 7:00:0 Huddinge IK - Leksands IF 4 - 3 ( 1-0, 1-3, 2-0 ) 1137 Björkängshallen  
2/11/2009 7:00:0 Bofors IK - IF Malmö Redhawks 3 - 4 ( 2-1, 0-1, 1-1, 0-1 ) 4399 Nobelhallen  
2/11/2009 7:00:0 AIK IF - Almtuna IS 3 - 2 ( 2-1, 1-0, 0-1 ) 2588 Hovet, Johanneshov  
2/11/2009 7:00:0 IF Björklöven - Växjö Lakers HC 0 - 1 ( 0-0, 0-0, 0-0, 0-0, 0-1 ) 3507 Umeå Arena  
2/11/2009 7:00:0 Mora IK - VIK Västerås HK 6 - 5 ( 1-1, 2-0, 2-4, 0-0, 1-0 ) 3479 FM Mattsson Arena  
2/11/2009 7:00:0 IF Sundsvall Hockey - Borås HC 3 - 2 ( 0-2, 2-0, 1-0 ) 566 Gärdehov  
2/11/2009 7:00:0 Mariestad BoIS HC - IK Oskarshamn 2 - 6 ( 0-0, 0-4, 2-2 ) 1323 Katrinhallen