string(1495) "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 (26515, 26247, 26270, 26321, 26339, 26355, 26403, 26419, 26451, 26467, 26483, 26499, 26531, 26547, 26563, 26579, 26595, 26611, 26627, 26675)) ORDER BY FIELD(e.entity_id,26515,26247,26270,26321,26339,26355,26403,26419,26451,26467,26483,26499,26531,26547,26563,26579,26595,26611,26627,26675)
"
string(1495) "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 (26515, 26247, 26270, 26321, 26339, 26355, 26403, 26419, 26451, 26467, 26483, 26499, 26531, 26547, 26563, 26579, 26595, 26611, 26627, 26675)) ORDER BY FIELD(e.entity_id,26515,26247,26270,26321,26339,26355,26403,26419,26451,26467,26483,26499,26531,26547,26563,26579,26595,26611,26627,26675)
"
Bague Rubis - Bijou Or Jaune, Blanc et Diamant | 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 rubis - Bague or rubis - Bague rubis diamant
BAGUES RUBIS
Plongez au cœur de l'élégance et de la passion avec la collection exclusive de bagues en rubis de Maison Gemperles. Des pièces exceptionnelles où l'intensité captivante du rubis certifié se marie harmonieusement à l'éclat de l'or blanc, de l'or rose, et de l'or jaune. Chaque pièce est méticuleusement agrémentée de diamants étincelants, ajoutant une touche de lumière à ces joyaux raffinés. Nos bagues en rubis, sélectionnées avec soin pour leur couleur profonde et leur vivacité éblouissante, sont le symbole du luxe et du raffinement, incarnant un amour éternel.
Gemperles vous invite à explorer sa gamme variée, incluant des bagues de fiançailles en rubis ainsi que des alliances et solitaires en rubis, conçues pour célébrer les moments les plus précieux de la vie. Chaque création est une véritable œuvre d'art, témoignant de notre engagement indéfectible envers l'excellence et la haute joaillerie. Nos bijoux en rubis, parfaits pour des occasions spéciales ou comme expression d'un amour intemporel, sont le fruit d'un savoir-faire d'exception.
Célébrez avec nous les instants inoubliables grâce à notre collection de bagues serties de rubis naturels et de diamants, proposant une variété de designs allant du classique intemporel à l'audacieuse modernité. En choisissant une bague en rubis de Maison Gemperles, vous optez pour un symbole de passion, de désir, et d'élégance, transformant chaque bijou en un gage d'amour profond et durable. Nos pièces, reflet d'un luxe authentique et d'un design sur mesure, promettent de capturer l'essence de vos moments les plus précieux.
string(1495) "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 (26515, 26247, 26270, 26321, 26339, 26355, 26403, 26419, 26451, 26467, 26483, 26499, 26531, 26547, 26563, 26579, 26595, 26611, 26627, 26675)) ORDER BY FIELD(e.entity_id,26515,26247,26270,26321,26339,26355,26403,26419,26451,26467,26483,26499,26531,26547,26563,26579,26595,26611,26627,26675)
"
string(1495) "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 (26515, 26247, 26270, 26321, 26339, 26355, 26403, 26419, 26451, 26467, 26483, 26499, 26531, 26547, 26563, 26579, 26595, 26611, 26627, 26675)) ORDER BY FIELD(e.entity_id,26515,26247,26270,26321,26339,26355,26403,26419,26451,26467,26483,26499,26531,26547,26563,26579,26595,26611,26627,26675)
"
string(1495) "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 (26515, 26247, 26270, 26321, 26339, 26355, 26403, 26419, 26451, 26467, 26483, 26499, 26531, 26547, 26563, 26579, 26595, 26611, 26627, 26675)) ORDER BY FIELD(e.entity_id,26515,26247,26270,26321,26339,26355,26403,26419,26451,26467,26483,26499,26531,26547,26563,26579,26595,26611,26627,26675)
"
string(1495) "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 (26515, 26247, 26270, 26321, 26339, 26355, 26403, 26419, 26451, 26467, 26483, 26499, 26531, 26547, 26563, 26579, 26595, 26611, 26627, 26675)) ORDER BY FIELD(e.entity_id,26515,26247,26270,26321,26339,26355,26403,26419,26451,26467,26483,26499,26531,26547,26563,26579,26595,26611,26627,26675)
"
