| | Product Categories for Bassani: |
SELECT Cat_ID, Cat_Name, Cat_MenuColour FROM bike_Category WHERE Cat_ID IN (SELECT DISTINCT Root_Cat_ID FROM bike_ProdGroup_Lookup WHERE ProdGroup_ID IN (SELECT ProdGroup_ID FROM bike_ProdGroup WHERE ProdGroup_BrandID = 16)) AND Cat_Display = 1 ORDER BY Cat_MenuOrder| No categories for this brand | |
