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

Playoff 1 till Allsv. kval

Game Schedule
Date Game Result   Spectators Venue Info
2009-02-21 15:00 Karlskrona HK - Mjölby HC 7 - 3 ( 2-0, 2-2, 3-1 ) 3046 Vodafone Arena Po 1:3:1
2009-02-21 15:00 Clemensnäs HC - Hudiksvalls HC 3 - 7 ( 3-3, 0-2, 0-2 ) 70 Kopparhallen Po1:1:1
2009-02-21 15:15 Botkyrka HC - Borlänge HF 5 - 6 ( 0-2, 4-2, 1-1, 0-1 ) 148 Ishuset Po 1:2:1
2009-02-23 19:00 Borlänge HF - Botkyrka HC 5 - 4 ( 2-2, 1-2, 2-0 ) 640 Borlänge Ishall Po 1:2:2
2009-02-23 19:00 Hudiksvalls HC - Clemensnäs HC 2 - 3 ( 0-0, 0-2, 2-1 ) 1198 Glysishallen Po 1:1:2
2009-02-23 19:00 Mjölby HC - Karlskrona HK 0 - 1 ( 0-1, 0-0, 0-0 ) 1057 BT Rinken Po 1:3:2
2009-02-24 19:00 Hudiksvalls HC - Clemensnäs HC 4 - 2 ( 0-0, 4-0, 0-2 ) 745 Glysishallen Po 1:1:3