|
Snowboarding
You've heard about it! You've seen it! Now go grab a board and try it!
This wildly popular and growing winter sport is similar to skiing, but combines the fine art of both surfing and skateboarding. Lake Louise and Jasper in Alberta, Whistler, Grouse Mountain in Vancouver, Okanagan Valley, Kootenay region in BC, Barrie, Collingwood in Ontario, parts of Montreal and Quebec City are great for snowboarding. |
SELECT
l.Datacode AS Datacode,
e.URL AS URL,
l.Listing_Name AS Listing_Name,
l.Listing_Detail AS Listing_Detail,
l.Locationcode AS Locationcode
FROM listing l
JOIN activity_link a ON l.Datacode = a.Datacode
JOIN data_entry e ON l.Datacode = e.Datacode
JOIN location o ON l.Locationcode = o.Locationcode
JOIN location sp ON o.Parentcode = sp.Locationcode
JOIN account ac ON ac.Datacode = l.Datacode
WHERE e.Status = 'A'
AND l.Activity = 'Y'
AND a.Activitycode = 1
AND ( sp.Parentcode = 8 OR o.Parentcode = 8 )
AND(
(ac.Account_Status != 'D' AND ac.Type = 'Premier')
OR
(ac.Account_Status != 'D' AND ac.Type = 'Normal')
)
GROUP BY l.Datacode
ORDER BY ac.Type DESC,l.Listing_Indexafter query:
9 sec
|
Snow Valley Barrie, Barrie
At Snow Valley, our goal is to be the best resort in Ontario for families to learn to ski or snowboard. To this end we provide ticket and lesson options for every age and skill level. For example, our... |
|
Back