Yael Jewelry

Yael Designs creates elegant, award-winning, cutting edge bridal and fashion jewelry. The innovative collections of Yael jewelry are inspired by nature and human ingenuity. Yael Jewelry has won numerous AGTA Spectrum Awards and JCK Jewelers Choice Awards. A fusion of modern technology, intricate handwork, top quality metals, and superior gems ensure that every piece by Yael Designs is a masterpiece.

SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, price_index.price AS `indexed_price`, `price_index`.`price`, `price_index`.`final_price`, IF(`price_index`.`tier_price`, 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` FROM `magento_catalog_product_entity` AS `e` INNER JOIN `magento_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='91' INNER JOIN `magento_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 `cat_index`.`position` DESC LIMIT 15

10 Item(s)

Set Ascending Direction
per page

Grid  List 

10 Item(s)

Set Ascending Direction
per page

Grid  List