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 37
Date Game Result   Spectators Venue Info
1/23/2009 7:00:0 Borås HC - Växjö Lakers HC 4 - 5 ( 2-1, 2-3, 0-1 ) 1594 Borås Ishall  
1/23/2009 7:00:0 IK Oskarshamn - IF Björklöven 3 - 0 ( 0-0, 0-0, 3-0 ) 1682 Arena Oskarshamn  
1/23/2009 7:00:0 Nybro Vikings IF - Huddinge IK 3 - 2 ( 1-0, 1-1, 0-1, 1-0 ) 1028 Victoriahallen  
1/23/2009 7:15:0 Leksands IF - Mora IK 3 - 4 ( 1-3, 1-0, 1-0, 0-0, 0-1 ) 7650 Ejendals Arena  
1/25/2009 4:00:0 Almtuna IS - Mariestad BoIS HC 3 - 1 ( 1-0, 0-0, 2-1 ) 1359 Gränbyhallen  
1/25/2009 4:00:0 AIK IF - Bofors IK 4 - 0 ( 1-0, 0-0, 3-0 ) 2642 Hovet, Johanneshov  
2/1/2009 4:00:00 VIK Västerås HK - IF Troja/Ljungby 6 - 0 ( 0-0, 3-0, 3-0 ) 2709 ABB Arena  
2/1/2009 4:00:00 IF Malmö Redhawks - IF Sundsvall Hockey 4 - 1 ( 2-0, 0-1, 2-0 ) 4444 Malmö Arena