Bikes

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
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
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
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

BMX

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 = '5' AND b.Active = 1 AND b.Price_CA > 0 GROUP BY sc.CatID
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 = '6' AND b.Active = 1 AND b.Price_CA > 0 GROUP BY sc.CatID