string(1489) "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 (3832, 3833, 3834, 21818, 21819, 21820, 21821, 21822, 21823, 24855, 24910, 25292, 25294, 25295, 33171, 33172, 33173, 33174, 33179, 33180)) ORDER BY FIELD(e.entity_id,3832,3833,3834,21818,21819,21820,21821,21822,21823,24855,24910,25292,25294,25295,33171,33172,33173,33174,33179,33180)
"
string(1489) "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 (3832, 3833, 3834, 21818, 21819, 21820, 21821, 21822, 21823, 24855, 24910, 25292, 25294, 25295, 33171, 33172, 33173, 33174, 33179, 33180)) ORDER BY FIELD(e.entity_id,3832,3833,3834,21818,21819,21820,21821,21822,21823,24855,24910,25292,25294,25295,33171,33172,33173,33174,33179,33180)
"
Clous d'Oreille Femme - Boucle Puce pour Homme | 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 »
Les clous d'oreilles de Gemperles, disponibles en or jaune et en or blanc, incarnent l'apogée de la grâce subtile, fusionnant avec brio minimalisme et raffinement élégant pour une élégance discrète et intemporelle. Notre collection, soigneusement sélectionnée, présente une diversité de styles, des designs les plus épurés aux modèles richement ornés de perles d'eau douce, d'Akoya, de Tahiti, et d'Australie, chacun façonné avec un souci méticuleux du détail. Ces bijoux, véritables symboles de l'élégance contenue, sont conçus pour s'harmoniser sans effort avec vos tenues les plus variées, conférant une allure naturellement élégante et dépourvue de toute prétention.
Que vos journées nécessitent la subtilité d'un bijou de tous les jours ou l'éclat d'un accessoire pour des occasions notables, nos clous d'oreilles représentent le summum du style durable et du raffinement exquis. Laissez-vous séduire par l'essence même de la sophistication avec notre gamme, où chaque paire célèbre la beauté pure, le lustre nacré des perles, et l'excellence artistique. Découvrez l'équilibre parfait entre le chic intemporel et le confort de port, faisant de chaque pièce un choix privilégié pour enrichir votre collection de bijoux avec une touche de pureté et une finesse incomparable.
string(1489) "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 (3832, 3833, 3834, 21818, 21819, 21820, 21821, 21822, 21823, 24855, 24910, 25292, 25294, 25295, 33171, 33172, 33173, 33174, 33179, 33180)) ORDER BY FIELD(e.entity_id,3832,3833,3834,21818,21819,21820,21821,21822,21823,24855,24910,25292,25294,25295,33171,33172,33173,33174,33179,33180)
"
string(1489) "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 (3832, 3833, 3834, 21818, 21819, 21820, 21821, 21822, 21823, 24855, 24910, 25292, 25294, 25295, 33171, 33172, 33173, 33174, 33179, 33180)) ORDER BY FIELD(e.entity_id,3832,3833,3834,21818,21819,21820,21821,21822,21823,24855,24910,25292,25294,25295,33171,33172,33173,33174,33179,33180)
"
string(1489) "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 (3832, 3833, 3834, 21818, 21819, 21820, 21821, 21822, 21823, 24855, 24910, 25292, 25294, 25295, 33171, 33172, 33173, 33174, 33179, 33180)) ORDER BY FIELD(e.entity_id,3832,3833,3834,21818,21819,21820,21821,21822,21823,24855,24910,25292,25294,25295,33171,33172,33173,33174,33179,33180)
"
string(1489) "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 (3832, 3833, 3834, 21818, 21819, 21820, 21821, 21822, 21823, 24855, 24910, 25292, 25294, 25295, 33171, 33172, 33173, 33174, 33179, 33180)) ORDER BY FIELD(e.entity_id,3832,3833,3834,21818,21819,21820,21821,21822,21823,24855,24910,25292,25294,25295,33171,33172,33173,33174,33179,33180)
"