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 (4178, 4179, 4180, 4181, 4182, 4183, 4184, 4185, 4194, 4195, 4201, 4202, 4294, 4295, 4296, 4297, 4298, 4299, 4300, 4303)) ORDER BY FIELD(e.entity_id,4178,4179,4180,4181,4182,4183,4184,4185,4194,4195,4201,4202,4294,4295,4296,4297,4298,4299,4300,4303)
"
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 (4178, 4179, 4180, 4181, 4182, 4183, 4184, 4185, 4194, 4195, 4201, 4202, 4294, 4295, 4296, 4297, 4298, 4299, 4300, 4303)) ORDER BY FIELD(e.entity_id,4178,4179,4180,4181,4182,4183,4184,4185,4194,4195,4201,4202,4294,4295,4296,4297,4298,4299,4300,4303)
"
Bague Perle de Culture | 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 perle - Bague perle de culture - Bagues perles de culture
BAGUES PERLE
Les bagues en perle de Gemperles allient élégance et pureté, offrant des designs où chaque perle, sélectionnée pour sa brillance unique, est mise en valeur dans une monture sophistiquée. Ces bijoux, symboles d'élégance intemporelle, incarnent un style raffiné et authentique, idéal pour ceux qui recherchent à la fois simplicité et raffinement.
Notre collection variée comprend des bagues en perles fines, perles d'eau douce, perles de Tahiti, et perles d'Akoya, répondant à tous les goûts, que vous soyez à la recherche d'une bague de fiançailles en perle, d'une bague de mariage, ou d'un anneau élégant pour compléter votre collection. Nos créations vont des bagues solitaires en perle aux modèles combinant perles et diamants, en passant par les bagues en perle de culture, offrant une diversité pour chaque occasion.
Découvrez chez Gemperles des bagues en perles classiques, modernes, ou personnalisées, conçues pour refléter une beauté durable et un luxe discret. Chaque pièce est un hommage à la splendeur des océans, transformant chaque bague en un trésor précieux et intemporel.
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 (4178, 4179, 4180, 4181, 4182, 4183, 4184, 4185, 4194, 4195, 4201, 4202, 4294, 4295, 4296, 4297, 4298, 4299, 4300, 4303)) ORDER BY FIELD(e.entity_id,4178,4179,4180,4181,4182,4183,4184,4185,4194,4195,4201,4202,4294,4295,4296,4297,4298,4299,4300,4303)
"
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 (4178, 4179, 4180, 4181, 4182, 4183, 4184, 4185, 4194, 4195, 4201, 4202, 4294, 4295, 4296, 4297, 4298, 4299, 4300, 4303)) ORDER BY FIELD(e.entity_id,4178,4179,4180,4181,4182,4183,4184,4185,4194,4195,4201,4202,4294,4295,4296,4297,4298,4299,4300,4303)
"
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 (4178, 4179, 4180, 4181, 4182, 4183, 4184, 4185, 4194, 4195, 4201, 4202, 4294, 4295, 4296, 4297, 4298, 4299, 4300, 4303)) ORDER BY FIELD(e.entity_id,4178,4179,4180,4181,4182,4183,4184,4185,4194,4195,4201,4202,4294,4295,4296,4297,4298,4299,4300,4303)
"
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 (4178, 4179, 4180, 4181, 4182, 4183, 4184, 4185, 4194, 4195, 4201, 4202, 4294, 4295, 4296, 4297, 4298, 4299, 4300, 4303)) ORDER BY FIELD(e.entity_id,4178,4179,4180,4181,4182,4183,4184,4185,4194,4195,4201,4202,4294,4295,4296,4297,4298,4299,4300,4303)
"