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 (3799, 3803, 3805, 3817, 3818, 3819, 3820, 3825, 3826, 3845, 3853, 3854, 3862, 3886, 3887, 3888, 3889, 3895, 3896, 3898)) ORDER BY FIELD(e.entity_id,3799,3803,3805,3817,3818,3819,3820,3825,3826,3845,3853,3854,3862,3886,3887,3888,3889,3895,3896,3898)
"
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 (3799, 3803, 3805, 3817, 3818, 3819, 3820, 3825, 3826, 3845, 3853, 3854, 3862, 3886, 3887, 3888, 3889, 3895, 3896, 3898)) ORDER BY FIELD(e.entity_id,3799,3803,3805,3817,3818,3819,3820,3825,3826,3845,3853,3854,3862,3886,3887,3888,3889,3895,3896,3898)
"
Collier Pendentif | 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 »
Le collier pendentif de Gemperles est une pièce maîtresse qui incarne à la fois élégance et raffinement. Chaque collier est conçu avec une attention méticuleuse aux détails, mettant en valeur un pendentif délicatement suspendu qui attire l'œil. Réalisé en or 18 carats, qu'il soit blanc, jaune ou rose, et souvent orné de pierres précieuses comme des diamants, des saphirs ou des émeraudes, ce bijou apporte une touche de luxe et de sophistication à toute tenue. Le design du collier pendentif allie à la perfection modernité et tradition, faisant de chaque pièce un ajout intemporel à votre collection de bijoux.
Chaque collier pendentif chez Gemperles est une œuvre d'art unique, créée par des artisans experts qui maîtrisent l'art de la bijouterie. Le pendentif, qu'il soit en forme de cœur, de fleur, de croix ou d'autres motifs symboliques, est soigneusement sélectionné et monté pour garantir une brillance et une qualité exceptionnelles. Ce collier est parfait pour marquer des moments spéciaux ou pour offrir un cadeau significatif à un être cher. Offrir un collier pendentif de Gemperles, c'est offrir un symbole de beauté et d'émotion, idéal pour toutes les occasions.
Le collier pendentif est également un bijou extrêmement polyvalent, s'adaptant à une variété de styles et de préférences. Il peut être porté seul pour une déclaration de style subtile et élégante, ou associé à d'autres colliers pour un look plus audacieux et contemporain. Disponible dans une gamme variée de designs, du plus épuré au plus sophistiqué, chaque collier pendentif est conçu pour durer et être chéri pendant des années. Avec un collier pendentif de Gemperles, vous portez un bijou qui raconte une histoire, celle de la passion, de l'artisanat et de l'élégance intemporelle.
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 (3799, 3803, 3805, 3817, 3818, 3819, 3820, 3825, 3826, 3845, 3853, 3854, 3862, 3886, 3887, 3888, 3889, 3895, 3896, 3898)) ORDER BY FIELD(e.entity_id,3799,3803,3805,3817,3818,3819,3820,3825,3826,3845,3853,3854,3862,3886,3887,3888,3889,3895,3896,3898)
"
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 (3799, 3803, 3805, 3817, 3818, 3819, 3820, 3825, 3826, 3845, 3853, 3854, 3862, 3886, 3887, 3888, 3889, 3895, 3896, 3898)) ORDER BY FIELD(e.entity_id,3799,3803,3805,3817,3818,3819,3820,3825,3826,3845,3853,3854,3862,3886,3887,3888,3889,3895,3896,3898)
"
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 (3799, 3803, 3805, 3817, 3818, 3819, 3820, 3825, 3826, 3845, 3853, 3854, 3862, 3886, 3887, 3888, 3889, 3895, 3896, 3898)) ORDER BY FIELD(e.entity_id,3799,3803,3805,3817,3818,3819,3820,3825,3826,3845,3853,3854,3862,3886,3887,3888,3889,3895,3896,3898)
"
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 (3799, 3803, 3805, 3817, 3818, 3819, 3820, 3825, 3826, 3845, 3853, 3854, 3862, 3886, 3887, 3888, 3889, 3895, 3896, 3898)) ORDER BY FIELD(e.entity_id,3799,3803,3805,3817,3818,3819,3820,3825,3826,3845,3853,3854,3862,3886,3887,3888,3889,3895,3896,3898)
"
