We use cookies to provide and improve our service and your shopping experience. If you continue browsing, we’ll assume that you consent to receiving all cookies. Learn more.
Kaoâ is a lifestyle brand with a timeless and confident aesthetic, and one that gives women the opportunity to define their own style. The brand’s collections encompass dresses, gowns, and jumpsuits. The brand is known for modern formalwear and beautiful wearable pieces that make event dressing a breeze.
SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `stock_status_index`.`stock_status` AS `is_salable` FROM `tb_catalog_product_entity` AS `e`
INNER JOIN `tb_catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
LEFT JOIN `tb_cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1 WHERE (e.entity_id IN (81173, 80730, 80666, 80497, 80193, 72108, 72103, 71425, 71417, 71367, 71338, 70969, 70700, 70464, 64552, 64547, 41372, 40885, 35204, 32064, 31507, 26590, 26522, 25328, 23349))
