Alex A

Alex A Jewelry is dedicated to high quality craftsmanship and extreme detail in every piece of Jewelry. The intricate designs by Alex Ahanchian, designer of Alex A Jewelry, reflect his passion for the art of fine Jewelry-making. Each design is meticulously crafted down to the smallest detail. Alex is confident that his creations will become heirloom pieces that will be cherished by families for generations to come.

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='122' 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

11 Item(s)

Set Ascending Direction
per page

Grid  List 

11 Item(s)

Set Ascending Direction
per page

Grid  List