Gem Search

Browse our collection of beautiful gemstones or use our interactive tool at the bottom of the web page to search for additional options. Additionally we have thousands of callibrated and uniques sizes of different gemstones in stock. Use the message tab at the bottom right side of the page to ask any questions or if you would like to view a gemstone in person.
SELECT `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` 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 = '377' AND cat_index.is_parent=1 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 INNER JOIN `catalog_product_index_eav` AS `gf_gemstone_type_idx` ON gf_gemstone_type_idx.entity_id = e.entity_id AND gf_gemstone_type_idx.attribute_id = '195' AND gf_gemstone_type_idx.store_id = 1 AND gf_gemstone_type_idx.value = '235' ORDER BY `price_index`.`min_price` desc LIMIT 24 Mage_Catalog_Block_Product_List
   
Loading...