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

Kval till Div. 1 [Back]

Game Schedule
Date Game Result   Spectators Venue Info
3/8/2009 Jonstorps IF - Helsingborgs HC 2 - 1 ( 1-0, 1-1, 0-0 ) 622 Jonstorps Ishall  
3/8/2009 Mörrums GoIS IK - Ulricehamns IF 2 - 5 ( 1-1, 0-3, 1-1 ) 1779 Jössarinken A-hall  
3/11/2009 Ulricehamns IF - Halmstad HF 3 - 4 ( 0-3, 1-0, 2-0, 0-1 ) 478 Lassarinken  
3/11/2009 Helsingborgs HC - Mörrums GoIS IK 3 - 4 ( 1-2, 0-1, 2-1 ) 340 Olympiarinken A-Hall  
3/13/2009 Jonstorps IF - Halmstad HF 0 - 6 ( 0-2, 0-3, 0-1 ) 330 Jonstorps Ishall  
3/13/2009 Ulricehamns IF - Helsingborgs HC 6 - 0 ( 4-0, 2-0, 0-0 ) 404 Lassarinken  
3/15/2009 Jonstorps IF - Ulricehamns IF 7 - 1 ( 2-0, 2-0, 3-1 ) 95 Jonstorps Ishall  
3/15/2009 Halmstad HF - Mörrums GoIS IK 4 - 3 ( 2-1, 2-0, 0-2 ) 1243 Sannarpshallen  
3/18/2009 Mörrums GoIS IK - Jonstorps IF 5 - 2 ( 1-1, 2-0, 2-1 ) 1662 Jössarinken A-hall  
3/18/2009 Helsingborgs HC - Halmstad HF 4 - 5 ( 3-1, 0-1, 1-3 ) 825 Olympiarinken A-Hall  
3/22/2009 Helsingborgs HC - Jonstorps IF 5 - 2 ( 3-0, 0-1, 2-1 ) 289 Olympiarinken A-Hall  
3/22/2009 Ulricehamns IF - Mörrums GoIS IK 3 - 1 ( 1-0, 1-1, 1-0 ) 448 Lassarinken  
3/25/2009 Halmstad HF - Ulricehamns IF 7 - 2 ( 1-0, 5-1, 1-1 ) 1047 Sannarpshallen  
3/25/2009 Mörrums GoIS IK - Helsingborgs HC 8 - 2 ( 4-1, 3-1, 1-0 ) 959 Jössarinken A-hall  
3/27/2009 Halmstad HF - Jonstorps IF 6 - 1 ( 2-0, 2-1, 2-0 ) 1017 Sannarpshallen  
3/27/2009 Helsingborgs HC - Ulricehamns IF 2 - 1 ( 1-0, 0-1, 1-0 ) 112 Olympiarinken A-Hall  
3/29/2009 Ulricehamns IF - Jonstorps IF 6 - 3 ( 1-1, 2-0, 3-2 ) 376 Lassarinken  
3/29/2009 Mörrums GoIS IK - Halmstad HF 5 - 3 ( 1-1, 1-2, 3-0 ) 2051 Jössarinken A-hall  
4/1/2009 Jonstorps IF - Mörrums GoIS IK 3 - 6 ( 0-4, 1-0, 2-2 ) 450 Jonstorps Ishall  
4/1/2009 Halmstad HF - Helsingborgs HC 3 - 1 ( 0-0, 2-1, 1-0 ) 516 Sannarpshallen