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 40
Date Game Result   Spectators Venue Info
1/29/2010 7:00:0 Växjö Lakers HC - Bofors IK 3 - 4 ( 1-1, 2-2, 0-0, 0-0, 0-1 ) 2175 Växjö Ishall  
1/30/2010 6:00:0 Mora IK - IK Oskarshamn 2 - 3 ( 0-1, 1-0, 1-2 ) 1759 FM Mattsson Arena  
1/31/2010 4:00:0 IF Troja/Ljungby - Leksands IF 2 - 5 ( 1-2, 0-3, 1-0 ) 1885 Sunnerbohov  
1/31/2010 4:00:0 Örebro HK - IF Malmö Redhawks 3 - 4 ( 1-1, 1-1, 1-1, 0-1 ) 1685 Behrn Arena  
1/31/2010 4:00:0 A I K  IF - IF Björklöven 4 - 1 ( 1-0, 0-0, 3-1 ) 1945 Johanneshovs Isstadion  
1/31/2010 4:00:0 IF Sundsvall Hockey - Almtuna IS 2 - 6 ( 0-1, 1-3, 1-2 ) 532 Gärdehov  
1/31/2010 4:00:0 VIK Västerås HK - Borås HC 3 - 2 ( 2-0, 1-1, 0-1 ) 1326 ABB Arena