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 (833,329,330,304,324,327,305,325,328,306,326,307,308) AND (p.products_status>0 OR (p.products_status=0 AND p.products_all_sale=1))