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 26
Date Game Result   Spectators Venue Info
1/4/2006 7:00:00 Almtuna IS - IFK Arboga IK 1 - 2 ( 0-0, 0-1, 1-1 ) 1526 Gränbyhallen  
1/4/2006 7:00:00 IF Björklöven - AIK IF 7 - 4 ( 2-2, 1-1, 4-1 ) 3772 Umeå Arena  
1/4/2006 7:00:00 Skellefteå AIK - VIK Västerås HK 5 - 4 ( 2-2, 1-1, 2-1 ) 3280 Skellefteå Kraft Arena  
1/4/2006 7:00:00 Hammarby IF - IF Sundsvall Hockey 3 - 3 ( 2-1, 1-0, 0-2, 0-0 ) 443 Hovet, Johanneshov  
1/4/2006 7:00:00 Nybro Vikings IF - Rögle BK 1 - 2 ( 0-0, 0-0, 1-1, 0-1 ) 1136 Victoriahallen  
1/4/2006 7:00:00 IK Oskarshamn - IK Nyköping Hockey 4 - 1 ( 1-1, 1-0, 2-0 ) 1898 Arena Oskarshamn  
1/4/2006 7:00:00 Bofors IK - Växjö Lakers HC 5 - 1 ( 2-0, 1-1, 2-0 ) 2412 Nobelhallen