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 till Allsv. kval [Back]

Round 1
Date Game Result   Spectators Venue Info
2/26/2010 7:00:0 Visby/Roma HK - Nyköpings HK 1 - 2 ( 0-0, 0-2, 1-0 ) 975 Visby Ishall Po1 1:4
2/27/2010 3:00:0 Bodens HF - Hudiksvalls HC 1 - 2 ( 0-1, 0-0, 1-1 ) 1018 Björknäshallen Po1 1:1
2/27/2010 3:00:0 Sollefteå HK - Piteå HC 1 - 5 ( 0-1, 0-2, 1-2 ) 226 Niphallen Po1 1:2
2/27/2010 3:00:0 Tranås AIF IF - Olofströms IK 4 - 7 ( 2-3, 2-1, 0-3 ) 750 Bredstorpshallen Po1 1:5
2/27/2010 3:00:0 Karlskrona HK - Nybro Vikings IF 3 - 2 ( 1-0, 0-1, 2-1 ) 3221 Telenor Arena Po1 1:6
2/27/2010 4:30:0 Valbo HC - IFK Arboga IK 1 - 4 ( 1-1, 0-2, 0-1 ) 112 Skutskärs Ishall Po1 1:3