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

Division 1 A [Back]

Round 22
Date Game Result   Spectators Venue Info
1/16/2005 3:00:0 Kovlands IF - Team Kiruna IF 5 - 3 ( 2-0, 1-2, 2-1 ) 345 Ånäshallen  
1/16/2005 4:00:0 Bräcke IK-Polar Bears - Älvsby IF 3 - 3 ( 0-2, 1-1, 2-0, 0-0 ) 123 Bräcke ishall  
1/16/2005 4:00:0 Överkalix IF - AIK-Hockey Härnösand 4 - 4 ( 1-3, 2-0, 1-1, 0-0 ) 69 Skogshallen  
1/16/2005 4:00:0 Asplöven HC - LN 91 Hockey 4 - 6 ( 0-3, 2-1, 2-2 ) 269 Arena Polarica  
1/16/2005 4:00:0 Vännäs HC - Jämtlands HF 3 - 5 ( 1-1, 1-2, 1-2 ) 103 Vännäs Ishall  
1/16/2005 4:00:0 Clemensnäs HC - Brunflo IK 4 - 2 ( 1-1, 2-0, 1-1 ) 117 Kopparhallen