Complementos señora BIENVE b31104b azul
18,93 €
22,23 €
15%
Ref:
9604200
Medida:
28 x 35 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