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

Kval till Div. 1 [Back]

Game Schedule
Date Game Result   Spectators Venue Info
3/8/2009 AIK-Hockey Härnösand - Sollefteå HK 5 - 1 ( 2-0, 1-0, 2-1 ) 150 Höglandsrinken  
3/8/2009 ÖSK HK - Njurunda SK 4 - 2 ( 0-0, 1-0, 3-2 ) 121 Skyttishallen  
3/11/2009 Njurunda SK - AIK-Hockey Härnösand 4 - 2 ( 1-0, 2-1, 1-1 ) 128 Njurunda Ishall  
3/11/2009 Sollefteå HK - ÖSK HK 4 - 5 ( 1-1, 3-3, 0-1 ) 150 Niphallen  
3/15/2009 ÖSK HK - AIK-Hockey Härnösand 2 - 0 ( 0-0, 1-0, 1-0 ) 123 Skyttishallen  
3/15/2009 Sollefteå HK - Njurunda SK 2 - 8 ( 0-3, 0-2, 2-3 ) 170 Niphallen  
3/18/2009 AIK-Hockey Härnösand - ÖSK HK 5 - 2 ( 1-0, 2-2, 2-0 ) 80 Högslättens Ishall  
3/18/2009 Njurunda SK - Sollefteå HK 6 - 0 ( 2-0, 2-0, 2-0 ) 268 Njurunda Ishall  
3/22/2009 AIK-Hockey Härnösand - Njurunda SK 4 - 4 ( 1-3, 3-1, 0-0, 0-0 ) 140 Högslättens Ishall  
3/22/2009 ÖSK HK - Sollefteå HK 7 - 1 ( 3-0, 1-1, 3-0 ) 160 Skyttishallen  
3/25/2009 Njurunda SK - ÖSK HK 6 - 1 ( 0-0, 3-0, 3-1 ) 140 Njurunda Ishall  
3/25/2009 Sollefteå HK - AIK-Hockey Härnösand 3 - 3 ( 3-2, 0-1, 0-0, 0-0 ) 118 Niphallen