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 2/3 till Allsv. kval

Game Schedule
Date Game Result   Spectators Venue Info
2/27/2009 7:00:0 Karlskrona HK - Skåre BK 3 - 5 ( 0-1, 1-0, 2-4 ) 3444 Vodafone Arena Po 2:3:1
2/28/2009 3:00:0 Borlänge HF - Nyköpings HK 1 - 4 ( 0-1, 0-1, 1-2 ) 608 Borlänge Ishall Po 2:2:1
2/28/2009 3:00:0 Hudiksvalls HC - Piteå HC 0 - 1 ( 0-0, 0-1, 0-0 ) 947 Glysishallen Po 2:1:1
3/2/2009 7:00:00 Nyköpings HK - Borlänge HF 5 - 4 ( 2-3, 1-1, 1-0, 1-0 ) 1613 Rosvalla Arena Po 2:2:2
3/2/2009 7:00:00 Piteå HC - Hudiksvalls HC 8 - 1 ( 1-0, 1-0, 6-1 ) 857 Isstadion LF Arena Po 2:1:2
3/2/2009 7:00:00 Skåre BK - Karlskrona HK 7 - 5 ( 1-1, 1-2, 5-2 ) 985 Löfbergs Lila Arena Po 2:3:2
3/7/2009 3:00:00 Piteå HC - Asplöven HC 3 - 2 ( 2-0, 1-2, 0-0 ) 707 Isstadion LF Arena Po 3:1:1
3/7/2009 3:00:00 Enköpings SK HK - Örebro HK 1 - 4 ( 0-1, 0-2, 1-1 ) 1349 Bahcohallen Po 3:1:4
3/7/2009 3:00:00 Nyköpings HK - Tingsryds AIF 1 - 4 ( 1-0, 0-3, 0-1 ) 1730 Rosvalla Arena Po 3:1:3
3/7/2009 7:30:00 Skåre BK - Valbo HC 4 - 3 ( 1-1, 1-0, 1-2, 1-0 ) 1123 Löfbergs Lila Arena Po 3:1:2
3/9/2009 7:00:00 Örebro HK - Enköpings SK HK 5 - 1 ( 2-0, 1-0, 2-1 ) 2539 Vinterstadion Po 3:2:4
3/9/2009 7:00:00 Asplöven HC - Piteå HC 4 - 1 ( 0-1, 1-0, 3-0 ) 627 Arena Polarica Po 3:2:1
3/9/2009 7:00:00 Valbo HC - Skåre BK 6 - 2 ( 1-0, 1-0, 4-2 ) 524 Borr & Tång Arena Po 3:2:2
3/9/2009 7:00:00 Tingsryds AIF - Nyköpings HK 8 - 2 ( 3-0, 1-1, 4-1 ) 2651 Dackehallen Po 3;2:3
3/10/2009 7:00:0 Valbo HC - Skåre BK 2 - 0 ( 0-0, 1-0, 1-0 ) 637 Borr & Tång Arena Po 3:3:2
3/10/2009 7:00:0 Asplöven HC - Piteå HC 4 - 1 ( 0-0, 2-1, 2-0 ) 600 Arena Polarica Po 3:3:1