SELECT DISTINCT c.categoryID FROM SC_products p LEFT JOIN SC_category_product c ON p.productID=c.productID WHERE p.categoryID<>1 and enabled=1 AND ( p.brandID=98 ) AND (categoryID IN (3200))