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/29/2008 7:00:0 Leksands IF - IF Sundsvall Hockey 8 - 1 ( 3-1, 4-0, 1-0 ) 4638 Ejendals Arena  
2/29/2008 7:00:0 Bofors IK - Borås HC 1 - 3 ( 0-1, 1-1, 0-1 ) 2620 Nobelhallen  
2/29/2008 7:00:0 Almtuna IS - Nyköpings HK 4 - 3 ( 0-1, 1-2, 2-0, 1-0 ) 615 Gränbyhallen  
2/29/2008 7:00:0 IF Björklöven - Växjö Lakers HC 2 - 2 ( 0-0, 1-0, 1-2, 0-0 ) 3114 Umeå Arena  
2/29/2008 7:00:0 Rögle BK - VIK Västerås HK 0 - 4 ( 0-1, 0-2, 0-1 ) 2641 Ängelholms Ishall  
3/2/2008 4:00:00 IF Malmö Redhawks - Huddinge IK 4 - 3 ( 1-0, 2-1, 1-2 ) 3293 Malmö Isstadion  
3/2/2008 4:00:00 AIK IF - Nybro Vikings IF 7 - 1 ( 1-0, 4-1, 2-0 ) 872 Hovet, Johanneshov  
3/3/2008 7:00:00 Hammarby IF - IK Oskarshamn 0 - 7 ( 0-2, 0-2, 0-3 ) 329 Hovet, Johanneshov