Complementos señora BIENVE l-0311 burdeos
22,23 €
Ref:
9654000
Medida:
33 x 37 x 17 cm
SELECT DISTINCT p.id_product, p.id_manufacturer, p.id_category_default, p.price, p.reference, product_shop.active FROM ps_product p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) WHERE 1 AND product_shop.active = 1 LIMIT 0,17