0.001 SELECT COUNT(*) AS product_count FROM Product WHERE (Product.categoryId IN (13) OR Product.category2Id IN (13))AND Product.active = "yes" AND Product.trademarkId = "1" GROUP BY Product.id ORDER BY Product.sequence ASC