string(1455) "SELECT `e`.*, `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`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'
LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product'))
INNER 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 WHERE (stock_status_index.stock_status = 1) AND (e.entity_id IN (3811, 3823, 3866, 3891, 3961, 4178, 4180, 4182, 4184, 4194, 4201, 4295, 4296, 4298, 4303, 4306, 4342, 4348, 4350, 4352)) ORDER BY FIELD(e.entity_id,3811,3823,3866,3891,3961,4178,4180,4182,4184,4194,4201,4295,4296,4298,4303,4306,4342,4348,4350,4352)
"
string(1455) "SELECT `e`.*, `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`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'
LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product'))
INNER 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 WHERE (stock_status_index.stock_status = 1) AND (e.entity_id IN (3811, 3823, 3866, 3891, 3961, 4178, 4180, 4182, 4184, 4194, 4201, 4295, 4296, 4298, 4303, 4306, 4342, 4348, 4350, 4352)) ORDER BY FIELD(e.entity_id,3811,3823,3866,3891,3961,4178,4180,4182,4184,4194,4201,4295,4296,4298,4303,4306,4342,4348,4350,4352)
"
Bague Or Blanc - Bijou de Mariage et Fiancaille | Gemperles
The store will not work correctly in the case when cookies are disabled.
Offre de Juin : -5% sur les Alliances Couples avec le code « DUO »
Bague or blanc - Alliance mariage or blanc - Bague de fiancaille or blanc
BAGUES OR BLANC
Plongez dans l'univers des bagues en or blanc de Gemperles, une collection où chaque pièce reflète une élégance intemporelle, conçue pour capturer et célébrer la magie de moments inoubliables. Avec une attention méticuleuse portée aux détails, chaque bague femme ou homme est un hommage au luxe et au style raffiné. Qu'il s'agisse d'une bague de fiançailles sertie d'un diamant solitaire éclatant, d'une bague mariée ornée d'une perle, d'un saphir ou d'un rubis, chaque bijou est une célébration de l'amour et de la personnalité.
Nos bagues solitaire, qu'elles soient simples ou agrémentées de coussins de diamants, sont faites pour devenir des héritages précieux. Avec des options telles que les bagues de fiançailles diamant en or blanc ou les alliances délicates, Gemperles s'engage à offrir la perfection en 18 carats, pour que chaque choix soit aussi unique que l'histoire qu'il représente.
string(1455) "SELECT `e`.*, `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`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'
LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product'))
INNER 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 WHERE (stock_status_index.stock_status = 1) AND (e.entity_id IN (3811, 3823, 3866, 3891, 3961, 4178, 4180, 4182, 4184, 4194, 4201, 4295, 4296, 4298, 4303, 4306, 4342, 4348, 4350, 4352)) ORDER BY FIELD(e.entity_id,3811,3823,3866,3891,3961,4178,4180,4182,4184,4194,4201,4295,4296,4298,4303,4306,4342,4348,4350,4352)
"
string(1455) "SELECT `e`.*, `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`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'
LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product'))
INNER 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 WHERE (stock_status_index.stock_status = 1) AND (e.entity_id IN (3811, 3823, 3866, 3891, 3961, 4178, 4180, 4182, 4184, 4194, 4201, 4295, 4296, 4298, 4303, 4306, 4342, 4348, 4350, 4352)) ORDER BY FIELD(e.entity_id,3811,3823,3866,3891,3961,4178,4180,4182,4184,4194,4201,4295,4296,4298,4303,4306,4342,4348,4350,4352)
"
string(1455) "SELECT `e`.*, `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`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'
LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product'))
INNER 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 WHERE (stock_status_index.stock_status = 1) AND (e.entity_id IN (3811, 3823, 3866, 3891, 3961, 4178, 4180, 4182, 4184, 4194, 4201, 4295, 4296, 4298, 4303, 4306, 4342, 4348, 4350, 4352)) ORDER BY FIELD(e.entity_id,3811,3823,3866,3891,3961,4178,4180,4182,4184,4194,4201,4295,4296,4298,4303,4306,4342,4348,4350,4352)
"
string(1455) "SELECT `e`.*, `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`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'
LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product'))
INNER 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 WHERE (stock_status_index.stock_status = 1) AND (e.entity_id IN (3811, 3823, 3866, 3891, 3961, 4178, 4180, 4182, 4184, 4194, 4201, 4295, 4296, 4298, 4303, 4306, 4342, 4348, 4350, 4352)) ORDER BY FIELD(e.entity_id,3811,3823,3866,3891,3961,4178,4180,4182,4184,4194,4201,4295,4296,4298,4303,4306,4342,4348,4350,4352)
"