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

HockeyAllsvenskan [Back]

Round 3
Date Game Result   Spectators Venue Info
9/21/2007 7:00:0 IF Björklöven - Nybro Vikings IF 1 - 2 ( 0-0, 1-0, 0-2 ) 2960 Umeå Arena  
9/21/2007 7:00:0 Almtuna IS - AIK IF 2 - 3 ( 0-0, 1-1, 1-1, 0-1 ) 1008 Gränbyhallen  
9/22/2007 3:00:0 Bofors IK - Leksands IF 3 - 4 ( 0-1, 1-1, 2-2 ) 2805 Nobelhallen  
9/23/2007 4:00:0 Huddinge IK - Växjö Lakers HC 2 - 4 ( 0-2, 1-2, 1-0 ) 304 Björkängshallen  
9/23/2007 4:00:0 IF Malmö Redhawks - Borås HC 6 - 2 ( 3-0, 1-1, 2-1 ) 2575 Malmö Isstadion  
9/23/2007 4:00:0 Rögle BK - IF Sundsvall Hockey 3 - 2 ( 2-0, 1-0, 0-2 ) 2044 Ängelholms Ishall  
9/23/2007 4:00:0 VIK Västerås HK - IK Oskarshamn 4 - 1 ( 1-1, 1-0, 2-0 ) 2601 ABB Arena  
9/23/2007 6:00:0 Hammarby IF - Nyköpings HK 3 - 4 ( 1-1, 0-2, 2-1 ) 501 Hovet, Johanneshov