Eleganza Jewelry

A stunning collection of sterling silver jewelry highlighted with 18K gold and beautiful genuine stones. With style, affordability, and attention to detail, Eleganza is sure to become your most treasured designer collection.

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`, `cisi`.`stock_status` 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='75' 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 LEFT JOIN `magento_cataloginventory_stock_status` AS `cisi` ON (cisi.product_id=e.entity_id) AND (cisi.website_id = '1') ORDER BY `stock_status` desc, `cat_index`.`position` DESC LIMIT 15

Items 1 to 15 of 26 total

Set Ascending Direction
per page

Grid  List 

Page:
  1. 1
  2. 2

Items 1 to 15 of 26 total

Set Ascending Direction
per page

Grid  List 

Page:
  1. 1
  2. 2