SELECT p.brandID FROM SC_products p WHERE p.categoryID<>1 and enabled=1 AND (p.productID IN ()) GROUP BY p.brandID