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

J20SuperElit [Back]

Round 31
Date Game Result   Spectators Venue Info
2/19/2005 11:30: MODO Hockey - Västerås IK Ungdom 1 - 4 ( 1-2, 0-2, 0-0 ) 157 Modo-Hallen  
2/19/2005 2:00:0 Djurgårdens IF - Luleå HF 3 - 1 ( 0-0, 1-0, 2-1 ) 72 Hovet, Johanneshov  
2/19/2005 3:00:0 Leksands IF - HV 71 7 - 4 ( 1-0, 2-1, 4-3 ) 250 Leksands Isstadion  
2/19/2005 3:00:0 Timrå IK - Södertälje SK 1 - 9 ( 0-4, 0-2, 1-3 ) 150 E.ON Arena  
2/19/2005 3:30:0 Rögle BK - Brynäs IF 1 - 2 ( 0-0, 1-0, 0-2 ) 87 Ängelholms Ishall  
2/19/2005 4:00:0 Huddinge IK - Hammarby IF 2 - 2 ( 0-1, 0-1, 2-0, 0-0 ) 230 Björkängshallen  
2/19/2005 4:00:0 Mora IK - Frölunda HC 2 - 3 ( 0-2, 1-0, 1-1 ) 76 FM Mattsson Arena  
2/19/2005 4:00:0 IF Malmö Redhawks - AIK 4 - 3 ( 2-1, 0-1, 2-1 ) 131 Malmö Isstadion  
2/19/2005 4:00:0 Linköpings HC - Skellefteå AIK 5 - 2 ( 1-0, 3-1, 1-1 ) 97 Stångebro Ishall