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 (837,137,146,133,124,135,141,138,503,500,123,131,130,489,136,125,132,140,143,504,144,498,506,496,134,501,142,145,139) AND (p.products_status>0 OR (p.products_status=0 AND p.products_all_sale=1))