SELECT DISTINCT `e`.*, `cat_index`.`position` AS `cat_index_position`, `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`, IF((
SELECT vm.view_mode AS required_options
FROM catalog_product_option AS cpo
LEFT JOIN mageworx_custom_options_option_view_mode AS vm ON cpo.option_id=vm.option_id AND (vm.store_id='1' OR vm.store_id=0)
WHERE e.entity_id=cpo.product_id AND cpo.is_require=1 ORDER BY vm.store_id DESC LIMIT 0,1)='1','1','0') AS `required_options` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '37'
INNER JOIN `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 ORDER BY `price_index`.`min_price` asc LIMIT 500
Floral engagement rings from Petalo Collection by Danhov
The Petalo collection from Danhov symbolizes a man and woman uniting to become a loving couple more beautiful than their individual parts. Just as a petal undergoes a metamorphosis and, when united with others, forms the whole of a flower. Using nature as a muse has always been an ideal way to create beautiful designs that not only represent symmetry, poetry, and elegance, but an embrace of change with the seasons blossom. The Petalo collection was created for the woman who loves organic shapes and floral motifs, and it enables her to express her personal style in her favorite piece of jewelry. The vintage-inspired collection encompasses feelings of love, passion and romance in a floral and feminine presentation. The combination of organic design and timeless elegance is sure to make her heart flutter. The perfect engagement ring is meant to represent the eternal bond between two people. What better way to show that love, than to draw inspiration from natural beauty? Available in both halo and solitaire settings, these diamond rings truly represent the serenity and beauty of the world around us. Your perfect Danhov Petalo wedding ring is awaiting.