TESTTEST

Gioielli

  SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `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_category_product_index_store7` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=7 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=454
 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 = '4'
 INNER JOIN `temp_13038ba373a064fa6ae7c15622a1713bdf619fb9` AS `search_result` ON `e`.`entity_id` = `search_result`.`entity_id`
 LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 7 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product'))
 LEFT 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 ORDER BY `cat_index`.`position` asc, `e`.`entity_id` DESC, `e`.`entity_id` DESC, `e`.`entity_id` ASC
 LIMIT 40

46 modelli

Pagina
  1. Anello Elena, My Star Away
    Anello Elena, My Star Away
    -51% Da 295 € 605 €
  2. Solitario Vie, Liberté, Amour
    Solitario Vie, Liberté, Amour
    Da 705 €
  3. Anello Capsule d'émotions
    Anello Capsule d'émotions
    Da 420 €
  4. Anello Capsule d'émotions
    Anello Capsule d'émotions
    Da 420 €
  5. Anello Capsule d'émotions
    Anello Capsule d'émotions
    Da 420 €
  6. Anello Capsule d'émotions
    Anello Capsule d'émotions
    Da 420 €
  7. Anello Capsule d'émotions
    Anello Capsule d'émotions
    Da 420 €
  8. Anello Capsule d'émotions
    Anello Capsule d'émotions
    Da 420 €
  9. Anello Capsule d'émotions
    Anello Capsule d'émotions
    Da 420 €
  10. Anello E' Nata Una Nuova Stella
    Anello E' Nata Una Nuova Stella
    Da 805 €
  11. Anello A la Croisée des Chemins
    Anello A la Croisée des Chemins
    Da 665 €
  12. Ciondolo À la Croisée des Étoiles
    Ciondolo À la Croisée des Étoiles
    A partire da 500 €
  13. Anello Etoilement Divine
    Anello Etoilement Divine
    Da 1.035 €
  14. Solitario Chance of Love N°1
    Solitario Chance of Love N°1
    Da 1.005 €
  15. Anello Etoile Divine
    Anello Etoile Divine
    Da 2.465 €
  16. Orecchini Chance of Love
    Orecchini Chance of Love
    A partire da 1.830 €
  17. Ciondolo Chance of Love n°2
    Ciondolo Chance of Love n°2
    A partire da 1.865 €
  18. Anello Trois grains d'amour
    Anello Trois grains d'amour
    Da 525 €
  19. Bracciale French Valentine
    Bracciale French Valentine
    A partire da 755 €
  20. Solitario Six de Toi
    Solitario Six de Toi
    Da 1.025 €
  21. Fede nuziale Parce que je l'aime
    Fede nuziale Parce que je l'aime
    Da 1.055 €
  22. Solitario Chance of Love N°2
    Solitario Chance of Love N°2
    Da 1.350 €
  23. Anello Le Premier Jour
    Anello Le Premier Jour
    Da 835 €
  24. Orecchini French Valentine
    Orecchini French Valentine
    A partire da 785 €
  25. Fede nuziale Lovissime
    Fede nuziale Lovissime
    Da 1.620 €
  26. Collana French Valentine
    Collana French Valentine
    A partire da 805 €
  27. Fede nuziale Parce que je t'Adore
    Fede nuziale Parce que je t'Adore
    Da 1.005 €
  28. Anello Tu es le Sel de ma vie n°3
    Anello Tu es le Sel de ma vie n°3
    Da 2.490 €

46 modelli

Pagina