SELECT 1 AS `status`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`created_at`, `e`.`updated_at`, `e`.`sku`, `at_inventory_in_stock`.`is_in_stock` AS `inventory_in_stock`, `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`, `e`.`name`, `e`.`short_description`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`image`, `e`.`small_image`, `e`.`thumbnail`, `e`.`color`, `e`.`color_value`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`required_options`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`url_key`, `e`.`msrp`, `e`.`msrp_display_actual_price_type`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`links_purchased_separately`, `e`.`links_exist`, `e`.`swatch_image`, `e`.`tax_class_id`, `e`.`diamon_shape`, `e`.`diamon_shape_value`, `e`.`diamon_finish`, `e`.`diamon_finish_value`, `e`.`diamond_type_sw`, `e`.`diamond_type_sw_value`, `e`.`diamond_pre_mental_sw`, `e`.`diamond_pre_mental_sw_value`, `e`.`diamond_alt_mental_sw`, `e`.`diamond_alt_mental_sw_value`, `e`.`diamond_width`, `e`.`diamond_wedding_ring_design_sw`, `e`.`diamond_wedding_ring_design_sw_value`, `e`.`diamond_color`, `e`.`diamond_color_value`, `e`.`diamond_clarity`, `e`.`diamond_clarity_value`, `e`.`diamond_cut`, `e`.`diamond_cut_value`, `e`.`diamond_polish`, `e`.`diamond_polish_value`, `e`.`diamond_symmetry`, `e`.`diamond_symmetry_value`, `e`.`diamond_lab`, `e`.`diamond_lab_value`, `e`.`diamond_fluorescence`, `e`.`diamond_fluorescence_value`, `e`.`suitable_diamond_shape`, `e`.`gemstone_shape`, `e`.`gemstone_shape_value`, `e`.`diamond_carat`, `e`.`diamond_depth`, `e`.`diamond_table`, `e`.`diamond_fancy_color`, `e`.`diamond_fancy_color_value`, `e`.`diamond_girdle_min`, `e`.`diamond_girdle_max`, `e`.`diamond_stock_num`, `e`.`diamond_culet`, `e`.`diamond_meas_length`, `e`.`diamond_meas_width`, `e`.`diamond_meas_depth`, `e`.`canonical`, `e`.`gemstone_attributes`, `cat_index`.`position` AS `cat_index_position`, `stock_status_index`.`stock_status` AS `is_salable`, `links`.`link_id`, `link_attribute_position_int`.`value` AS `position` FROM `catalog_product_flat_1` AS `e`
INNER JOIN `cataloginventory_stock_item` AS `at_inventory_in_stock` ON (at_inventory_in_stock.`product_id`=e.entity_id) AND ((at_inventory_in_stock.use_config_manage_stock = 0 AND at_inventory_in_stock.manage_stock=1 AND at_inventory_in_stock.is_in_stock=1) OR (at_inventory_in_stock.use_config_manage_stock = 0 AND at_inventory_in_stock.manage_stock=0) OR (at_inventory_in_stock.use_config_manage_stock = 1 AND at_inventory_in_stock.is_in_stock=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_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='2'
LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1
INNER JOIN `catalog_product_link` AS `links` ON links.linked_product_id = e.entity_id AND links.link_type_id = 4
LEFT JOIN `catalog_product_link_attribute_int` AS `link_attribute_position_int` ON link_attribute_position_int.link_id = links.link_id AND link_attribute_position_int.product_link_attribute_id = '2'
INNER JOIN `catalog_product_entity` AS `product_entity_table` ON links.product_id = product_entity_table.entity_id WHERE (links.product_id = 3929733) AND (e.entity_id != '3929733') ORDER BY `position` ASC
Pear Shaped Moissanite Engagement Ring Set, White Gold Gift Halo Diamond Band ,Chevron Ring, Twisted Band Vintage Anniversary Ring
JavaScript seems to be disabled in your browser. For the best experience on our site, be sure to turn on Javascript in your browser.
Pear Shaped Moissanite Engagement Ring Set,...
Home Pear Shaped Moissanite Engagement Ring Set, White Gold Gift Halo 14k White Gold
Pear Shaped Moissanite Engagement Ring Set, White Gold Gift Halo A beautiful pear shaped diamond or moissanite halo over the moissanite center stone, with a split shank, and a half moon halo on the top, filled with dazzle and sparkle, this ring is just pure perfection, this ring can be purchased with a matching diamond band - that completes a halo of diamonds or moissanites around it.
---IMAGE SHOWS THE 1.5CT SIZE OPTION ---
Center moissanite gemstone is D color, VVS clarity and ideal cut
FREE SHIPPING AND RETURN
DESIGN & CRAFTSMANSHIP
Our highly experienced jewelry experts will be more than happy to offer you any other metal or gemstone you desire. As part of our industry-leading service, we are able to alter an existing model to your requirements.
TOP