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 Sunne IK - Arvika HC 6 - 3 ( 3-0, 2-1, 1-2 ) 328 Helmia Arena  
3/8/2009 IFK Munkfors - Boro/Vetlanda HC 3 - 4 ( 1-3, 2-1, 0-0 ) 326 Klingevi Ishall  
3/11/2009 Grums IK - Sunne IK 2 - 5 ( 2-3, 0-1, 0-1 ) 357 Billerudhallen  
3/11/2009 Arvika HC - IFK Munkfors 3 - 4 ( 2-2, 1-1, 0-1 ) 555 Coffee Queen Arena  
3/13/2009 IFK Munkfors - Grums IK 4 - 3 ( 1-0, 1-1, 2-2 ) 346 Klingevi Ishall  
3/13/2009 Boro/Vetlanda HC - Arvika HC 5 - 2 ( 3-1, 2-1, 0-0 ) 1058 Borohallen  
3/15/2009 Sunne IK - Boro/Vetlanda HC 5 - 2 ( 1-0, 1-1, 3-1 ) 286 Helmia Arena  
3/15/2009 Grums IK - Arvika HC 2 - 4 ( 0-0, 1-2, 1-2 ) 377 Billerudhallen  
3/18/2009 IFK Munkfors - Sunne IK 0 - 4 ( 0-2, 0-1, 0-1 ) 599 Klingevi Ishall  
3/18/2009 Boro/Vetlanda HC - Grums IK 5 - 3 ( 2-0, 2-1, 1-2 ) 769 Borohallen  
3/22/2009 Arvika HC - Sunne IK 3 - 6 ( 0-3, 3-0, 0-3 ) 276 Coffee Queen Arena  
3/22/2009 Boro/Vetlanda HC - IFK Munkfors 3 - 5 ( 0-1, 2-2, 1-2 ) 880 Borohallen  
3/25/2009 Sunne IK - Grums IK 6 - 4 ( 1-1, 0-2, 5-1 ) 205 Helmia Arena  
3/25/2009 IFK Munkfors - Arvika HC 9 - 5 ( 2-0, 6-3, 1-2 ) 257 Klingevi Ishall  
3/27/2009 Grums IK - IFK Munkfors 3 - 8 ( 0-1, 2-2, 1-5 ) 164 Billerudhallen  
3/27/2009 Arvika HC - Boro/Vetlanda HC 3 - 5 ( 1-0, 1-2, 1-3 ) 150 Coffee Queen Arena  
3/29/2009 Boro/Vetlanda HC - Sunne IK 1 - 2 ( 0-1, 0-1, 1-0 ) 768 Borohallen  
3/29/2009 Arvika HC - Grums IK 5 - 4 ( 0-2, 1-2, 4-0 ) 163 Coffee Queen Arena  
4/1/2009 Sunne IK - IFK Munkfors 3 - 1 ( 1-0, 2-0, 0-1 ) 349 Helmia Arena  
4/1/2009 Grums IK - Boro/Vetlanda HC 0 - 4 ( 0-0, 0-1, 0-3 ) 101 Billerudhallen