SELECT 1 AS `status`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`created_at`, `e`.`updated_at`, `e`.`sku`, `e`.`price`, `cat_index`.`position` AS `cat_index_position`, `e`.`entity_id` FROM `catalog_product_flat_4` AS `e` INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='4' AND cat_index.visibility IN(3, 2, 4) AND cat_index.category_id='2' WHERE (e.entity_id IN('14784', '14786', '14826', '14836')) ORDER BY FIELD(e.entity_id, ) LIMIT 4 2.5KG ONE MED/MAX AD POULET - Tom&Co

Trouver un magasin

Gold

  • + 900 passionnés
  • + 160 magasins
  • + 7.000 produits

2.5KG ONE MED/MAX AD POULET

9,36 €
G 216526 / H
Trouver un magasin
Repeat order

Jamais

Every 3 minutes

Every 2 weeks

Every 4 weeks

Every 6 weeks

Every 8 weeks

En stock

Commentaire

Trouver ce produit dans un magasin