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.
Carolina Curado's collection is known for sophistication. The pieces are produced in materials such as zircons, pearls and stones, with brass being the main material of choice. Within the brand, there is a range of jewellery, from embellished earrings and bracelets, to pendant necklaces and "bug" rings. Look for the designer's best seller - the gold-plated brass earring with green stones.
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 (78471, 78477, 78474, 78472, 78469, 78470, 78468, 78455, 78457, 78456, 80846, 80832, 80835, 80833, 80826, 80808, 78454, 78437, 78446, 78452, 78453, 78479, 78461, 78476, 78473, 78459, 78460, 78458, 78420, 78438, 78428, 78385, 78406, 78413, 78405, 78336, 78379, 78384, 78366, 78334))
