string(1493) "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 = '2' LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 4 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 (35149, 35153, 35154, 42701, 42704, 43173, 43191, 46083, 46084, 46149, 3828, 23799, 23841, 27129, 27131, 27132, 27134, 27135, 27136, 28383)) ORDER BY FIELD(e.entity_id,35149,35153,35154,42701,42704,43173,43191,46083,46084,46149,3828,23799,23841,27129,27131,27132,27134,27135,27136,28383) " string(1493) "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 = '2' LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 4 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 (35149, 35153, 35154, 42701, 42704, 43173, 43191, 46083, 46084, 46149, 3828, 23799, 23841, 27129, 27131, 27132, 27134, 27135, 27136, 28383)) ORDER BY FIELD(e.entity_id,35149,35153,35154,42701,42704,43173,43191,46083,46084,46149,3828,23799,23841,27129,27131,27132,27134,27135,27136,28383) " Consegna Rapida di Gioielli - Gioiello in Consegna Espressa Dhl | Gemperles | Pagina 2 di 82

Consegna Rapida | Pagina 2 di 7

Consegna Rapida (Pagina 2)
Ora acquista per
  1. Tipo
    Ciondolo
  2. Tipo
    Collana
  3. Gemme
    Rubini
  4. Gemme
    Perle Akoya
  5. Gemme
    Miste
  6. Gemme
    Zaffiri
Opzioni di acquisto
Prezzo
Diametro (mm)
  1. 6/6.5 2 elementi
  2. 6.5/7 5 elementi
  3. 7/7.5 6 elementi
  4. 7.5/8 24 elementi
  5. 8/8.5 25 elementi
  6. 8.5/9 6 elementi
  7. 9/9.5 1 elemento
  8. 10/13 1 elemento
  9. 11/13 1 elemento
  10. 5/5.5 + 8/8.5 2 elementi
Mostra meno
string(1493) "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 = '2' LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 4 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 (35149, 35153, 35154, 42701, 42704, 43173, 43191, 46083, 46084, 46149, 3828, 23799, 23841, 27129, 27131, 27132, 27134, 27135, 27136, 28383)) ORDER BY FIELD(e.entity_id,35149,35153,35154,42701,42704,43173,43191,46083,46084,46149,3828,23799,23841,27129,27131,27132,27134,27135,27136,28383) " string(1493) "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 = '2' LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 4 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 (35149, 35153, 35154, 42701, 42704, 43173, 43191, 46083, 46084, 46149, 3828, 23799, 23841, 27129, 27131, 27132, 27134, 27135, 27136, 28383)) ORDER BY FIELD(e.entity_id,35149,35153,35154,42701,42704,43173,43191,46083,46084,46149,3828,23799,23841,27129,27131,27132,27134,27135,27136,28383) "
string(1493) "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 = '2' LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 4 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 (35149, 35153, 35154, 42701, 42704, 43173, 43191, 46083, 46084, 46149, 3828, 23799, 23841, 27129, 27131, 27132, 27134, 27135, 27136, 28383)) ORDER BY FIELD(e.entity_id,35149,35153,35154,42701,42704,43173,43191,46083,46084,46149,3828,23799,23841,27129,27131,27132,27134,27135,27136,28383) " string(1493) "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 = '2' LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 4 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 (35149, 35153, 35154, 42701, 42704, 43173, 43191, 46083, 46084, 46149, 3828, 23799, 23841, 27129, 27131, 27132, 27134, 27135, 27136, 28383)) ORDER BY FIELD(e.entity_id,35149,35153,35154,42701,42704,43173,43191,46083,46084,46149,3828,23799,23841,27129,27131,27132,27134,27135,27136,28383) "

140 elementi

  1. Wakasa

    Collana di perle Akoya bianche. Diametro 8.5/9mm. Qualità AA+

    Valutazione:
    100%
    3.860 €
  2. Dewa Collana di perle Akoya Giappone bianche - 6.5/7mm, GEMMA / HANADAMA

    Valutazione:
    100%
    Prezzo speciale 500 € Prezzo normale 1.350 €
per pagina