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

Game Schedule
Date Game Result   Spectators Venue Info
2008-03-09 Hedemora SK - Falu IF 4 - 2 ( 0-1, 3-0, 1-1 ) 200 Sparbankshallen  
2008-03-09 Skedvi/Säter IF - Bålsta HC 5 - 6 ( 2-1, 1-2, 2-3 ) 470 Milko Arena  
2008-03-12 Skedvi/Säter IF - Hedemora SK 0 - 2 ( 0-0, 0-0, 0-2 ) 659 Milko Arena  
2008-03-12 Falu IF - Team Uppsala HC 2 - 3 ( 1-2, 0-1, 1-0 ) 189 Lugnets Ishall  
2008-03-14 Team Uppsala HC - Hedemora SK 1 - 5 ( 0-3, 1-0, 0-2 ) 157 Gränbyhallen  
2008-03-14 Bålsta HC - Falu IF 3 - 2 ( 0-1, 0-0, 2-1, 1-0 ) 302 Bålsta Ishall  
2008-03-16 Team Uppsala HC - Skedvi/Säter IF 1 - 4 ( 0-2, 1-1, 0-1 ) 112 Gränbyhallen  
2008-03-16 Hedemora SK - Bålsta HC 2 - 5 ( 0-2, 1-2, 1-1 ) 450 Sparbankshallen  
2008-03-19 Bålsta HC - Team Uppsala HC 4 - 3 ( 0-1, 2-2, 2-0 ) 338 Bålsta Ishall  
2008-03-19 Skedvi/Säter IF - Falu IF 2 - 4 ( 1-1, 1-0, 0-3 ) 420 Milko Arena  
2008-03-23 Bålsta HC - Skedvi/Säter IF 7 - 1 ( 0-0, 7-0, 0-1 ) 462 Bålsta Ishall  
2008-03-23 Falu IF - Hedemora SK 1 - 5 ( 0-0, 0-3, 1-2 ) 200 Lugnets Ishall  
2008-03-26 Team Uppsala HC - Falu IF 0 - 3 ( 0-1, 0-0, 0-2 ) 127 Gränbyhallen  
2008-03-26 Hedemora SK - Skedvi/Säter IF 5 - 4 ( 2-2, 2-1, 1-1 ) 500 Sparbankshallen  
2008-03-28 Hedemora SK - Team Uppsala HC 2 - 2 ( 2-2, 0-0, 0-0 ) 325 Sparbankshallen  
2008-03-28 Falu IF - Bålsta HC 5 - 1 ( 0-1, 2-0, 3-0 ) 50 Lugnets Ishall  
2008-03-30 Bålsta HC - Hedemora SK 9 - 1 ( 3-0, 2-0, 4-1 ) 267 Bålsta Ishall  
2008-03-30 Skedvi/Säter IF - Team Uppsala HC 3 - 5 ( 0-0, 0-0, 3-5 ) 200 Milko Arena  
2008-04-02 Team Uppsala HC - Bålsta HC 7 - 0 ( 2-0, 4-0, 1-0 ) 74 Gränbyhallen  
2008-04-02 Falu IF - Skedvi/Säter IF 4 - 4 ( 2-1, 1-0, 1-3 ) 98 Lugnets Ishall