0.001 SELECT Product.* FROM Product WHERE (Product.categoryId IN (12) OR Product.category2Id IN (12))AND Product.active = "yes" GROUP BY Product.id ORDER BY Product.sequence ASC LIMIT 0,20