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 (162) AND products_status>0