(en)
SELECT sc.CatID, sc.CatName_en, sc.CatURLName, sc.CatDesc_en FROM bikecategories sc JOIN bikes b ON sc.CatID = b.CatID WHERE sc.ParentID = '1' AND b.Active = 1 AND b.Price_CA > 0 GROUP BY sc.CatID
Downhill
Enduro
All-Mountain
Trail
Fat Bikes
XC Race
XC Recreational
Dirt/Street
SELECT sc.CatID, sc.CatName_en, sc.CatURLName, sc.CatDesc_en FROM bikecategories sc JOIN bikes b ON sc.CatID = b.CatID WHERE sc.ParentID = '2' AND b.Active = 1 AND b.Price_CA > 0 GROUP BY sc.CatID
Race
Adventure
Cyclocross
Endurance
SELECT sc.CatID, sc.CatName_en, sc.CatURLName, sc.CatDesc_en FROM bikecategories sc JOIN bikes b ON sc.CatID = b.CatID WHERE sc.ParentID = '3' AND b.Active = 1 AND b.Price_CA > 0 GROUP BY sc.CatID
Crossover
Urban
Urban-E
Hybrids
SELECT sc.CatID, sc.CatName_en, sc.CatURLName, sc.CatDesc_en FROM bikecategories sc JOIN bikes b ON sc.CatID = b.CatID WHERE sc.ParentID = '4' AND b.Active = 1 AND b.Price_CA > 0 GROUP BY sc.CatID
Pavement
Mountain Geared
All Purpose
