Complementos señora BIENVE 28707 marron
23,88 €
Ref:
9651700
Medida:
40 x 30 x 13 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