Philip Zahm Jewelry

Philip Zahm Jewelry combines some of the world's finest exotic gemstones, brilliant artistic creativity, and high quality craftsmanship to bring you award winning one-of-a-kind Jewelry. For over 30 years, Philip Zahm traveled the world in search of the finest gemstones to add to his amazing collection. He now designs Jewelry to bring out the unique beauty of each gemstone. Each piece of Philip Zahm Jewelry is designed with the aid of cutting-edge 3D modeling technology to bring out perfect precision and world-class quality.

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