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

SM-Slutspel Damer [Back]

Game Schedule
Date Game Result   Spectators Venue Info
3/17/2007 3:00:0 Skellefteå AIK - Leksands IF 5 - 2 ( 2-0, 3-1, 0-1 ) 173 Skellefteå Kraft Arena FK 2:1
3/17/2007 5:00:0 Örebro HK - Jönköpings IF Queens 12 - 0 ( 3-0, 6-0, 3-0 ) 49 Vinterstadion FK 3:1
3/17/2007 5:00:0 Brynäs IF - IF Sundsvall Hockey 5 - 4 ( 1-2, 2-2, 2-0 ) 104 Läkerol Arena FK 1:1
3/17/2007 6:00:0 Växjö Lakers HC - Västerhaninge IF 4 - 1 ( 2-0, 2-0, 0-1 ) 130 Växjö Ishall FK 4:1
3/21/2007 7:00:0 MODO Hockey - Brynäs IF 5 - 4 ( 2-0, 2-1, 1-3 ) 107 Modo-Hallen K 1:1
3/21/2007 7:00:0 AIK IF - Växjö Lakers HC 10 - 1 ( 6-0, 2-1, 2-0 ) 135 Ritorps Ishall K 3:1
3/21/2007 7:00:0 Segeltorps IF - Skellefteå AIK 4 - 2 ( 0-0, 2-1, 2-1 ) 112 Visättra Ishall K 2:1
3/24/2007 3:00:0 MODO Hockey - Segeltorps IF 0 - 5 ( 0-2, 0-1, 0-2 ) 220 Ritorps Ishall S 1:1
3/24/2007 6:00:0 AIK IF - Örebro HK 12 - 1 ( 3-1, 7-0, 2-0 ) 323 Ritorps Ishall S 2:1
3/25/2007 11:30: MODO Hockey - Örebro HK 5 - 1 ( 1-0, 2-0, 2-1 ) 112 Ritorps Ishall 3:e 1:1
3/25/2007 3:00:0 Segeltorps IF - AIK IF 1 - 2 ( 0-0, 0-0, 1-1, 0-1 ) 434 Ritorps Ishall F 1:1