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/9/2008 Hedemora SK - Falu IF 4 - 2 ( 0-1, 3-0, 1-1 ) 200 Sparbankshallen  
3/9/2008 Skedvi/Säter IF - Bålsta HC 5 - 6 ( 2-1, 1-2, 2-3 ) 470 Milko Arena  
3/12/2008 Skedvi/Säter IF - Hedemora SK 0 - 2 ( 0-0, 0-0, 0-2 ) 659 Milko Arena  
3/12/2008 Falu IF - Team Uppsala HC 2 - 3 ( 1-2, 0-1, 1-0 ) 189 Lugnets Ishall  
3/14/2008 Team Uppsala HC - Hedemora SK 1 - 5 ( 0-3, 1-0, 0-2 ) 157 Gränbyhallen  
3/14/2008 Bålsta HC - Falu IF 3 - 2 ( 0-1, 0-0, 2-1, 1-0 ) 302 Bålsta Ishall  
3/16/2008 Team Uppsala HC - Skedvi/Säter IF 1 - 4 ( 0-2, 1-1, 0-1 ) 112 Gränbyhallen  
3/16/2008 Hedemora SK - Bålsta HC 2 - 5 ( 0-2, 1-2, 1-1 ) 450 Sparbankshallen  
3/19/2008 Bålsta HC - Team Uppsala HC 4 - 3 ( 0-1, 2-2, 2-0 ) 338 Bålsta Ishall  
3/19/2008 Skedvi/Säter IF - Falu IF 2 - 4 ( 1-1, 1-0, 0-3 ) 420 Milko Arena  
3/23/2008 Bålsta HC - Skedvi/Säter IF 7 - 1 ( 0-0, 7-0, 0-1 ) 462 Bålsta Ishall  
3/23/2008 Falu IF - Hedemora SK 1 - 5 ( 0-0, 0-3, 1-2 ) 200 Lugnets Ishall  
3/26/2008 Team Uppsala HC - Falu IF 0 - 3 ( 0-1, 0-0, 0-2 ) 127 Gränbyhallen  
3/26/2008 Hedemora SK - Skedvi/Säter IF 5 - 4 ( 2-2, 2-1, 1-1 ) 500 Sparbankshallen  
3/28/2008 Hedemora SK - Team Uppsala HC 2 - 2 ( 2-2, 0-0, 0-0 ) 325 Sparbankshallen  
3/28/2008 Falu IF - Bålsta HC 5 - 1 ( 0-1, 2-0, 3-0 ) 50 Lugnets Ishall  
3/30/2008 Bålsta HC - Hedemora SK 9 - 1 ( 3-0, 2-0, 4-1 ) 267 Bålsta Ishall  
3/30/2008 Skedvi/Säter IF - Team Uppsala HC 3 - 5 ( 0-0, 0-0, 3-5 ) 200 Milko Arena  
4/2/2008 Team Uppsala HC - Bålsta HC 7 - 0 ( 2-0, 4-0, 1-0 ) 74 Gränbyhallen  
4/2/2008 Falu IF - Skedvi/Säter IF 4 - 4 ( 2-1, 1-0, 1-3 ) 98 Lugnets Ishall