SELECT count(p.products_id) FROM house.products p  JOIN house.products_description pd ON p.products_id=pd.products_id JOIN house.products_to_categories p2c ON p.products_id=p2c.products_id  JOIN house.categories c ON p2c.categories_id = c.categories_id WHERE 1=1  AND c.web_id=8 AND p2c.categories_id IN (764,868,875,73,85,70,870,866,83,86,76,877,871,77,71,869,878,863,872,64,862,75,65,874,532,865,74,864,873,72,67,876,84,867,5,4,6,7,8) AND (p.products_status>0 OR (p.products_status=0 AND p.products_all_sale=1))