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

SIFlogo.jpg   J20SuperElit 2001/2002
  www.swehockey.se

Round 3
Date Game Result   Spectators Venue Info
9/29/2001 10:30: IF Björklöven - Hammarby IF 5 - 7 ( 0-2, 3-4, 2-1 ) 118 Umeå Arena
9/29/2001 12:00: Luleå HF - Huddinge IK 1 - 4 ( 1-1, 0-1, 0-2 ) 200 Delfinen
9/29/2001 12:00: Brynäs IF - MIF Redhawks 3 - 1 ( 1-0, 2-0, 0-1 ) 39 Läkerol Arena (B)
9/29/2001 1:00:0 Södertälje SK - Timrå IK 6 - 2 ( 2-0, 2-0, 2-2 ) 62 Scaniarinken
9/29/2001 2:15:0 Färjestads BK - MODO Hockey 2 - 3 ( 2-1, 0-1, 0-0, 0-0, 0-1 ) 114 Kristallen
9/29/2001 3:30:0 Rögle BK - Leksands IF 4 - 6 ( 2-1, 1-1, 1-4 ) 62 Ängelholms Ishall
9/29/2001 4:00:0 HV 71 - Mora IK 5 - 1 ( 1-1, 1-0, 3-0 ) 115 Kinnarps Arena
9/29/2001 6:30:0 AIK - Västra Frölunda HC 3 - 4 ( 1-1, 0-2, 2-1 ) 100 Hovet, Johanneshov
3/17/2002 10:00: HV 71 - MIF Redhawks 2 - 3 ( 1-0, 0-1, 1-1, 0-0, 0-1 ) 139 Rocklundahallen
3/17/2002 11:00: Luleå HF - Brynäs IF 7 - 4 ( 2-1, 4-2, 1-1 ) 153 Skellefteå Kraft Arena
3/17/2002 12:00: Södertälje SK - Rögle BK 4 - 2 ( 0-1, 1-1, 3-0 ) 250 Stångebro Ishall
3/17/2002 1:10:0 Leksands IF - Timrå IK 10 - 7 ( 1-1, 5-1, 4-5 ) 113 Vallentuna Ishall
3/17/2002 1:30:0 Västerås IK Ungdom - Hammarby IF 2 - 9 ( 1-2, 1-3, 0-4 ) 212 Rocklundahallen
3/17/2002 2:30:0 Skellefteå AIK - Mora IK 4 - 5 ( 1-2, 1-2, 2-0, 0-0, 0-1 ) 104 Skellefteå Kraft Arena
3/17/2002 3:30:0 Linköpings HC - Färjestads BK 4 - 6 ( 0-3, 1-2, 3-1 ) 250 Stångebro Ishall
3/17/2002 4:30:0 IF Vallentuna BK - IF Björklöven 0 - 3 ( 0-0, 0-2, 0-1 ) 337 Vallentuna Ishall
3/30/2002 3:00:0 MIF Redhawks - AIK 2 - 3 ( 0-1, 0-2, 2-0 ) 586 Malmö Isstadion Semi 1:2
3/30/2002 7:00:0 Huddinge IK - Västra Frölunda HC 2 - 2 ( 1-0, 0-1, 1-1 ) 198 Björkängshallen Semi 1:1