0.001 SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (3,4,2,5,6,7,8,9,10,11,12,13,14,25,26,27,28,1) OR category2Id IN (3,4,2,5,6,7,8,9,10,11,12,13,14,25,26,27,28,1)) AND active = 'yes'