Menu
SELECT pf.id_feature, fl.name AS feature_name, pf.id_feature_value, fvl.value AS feature_value FROM ps_product p INNER JOIN ps_category_product cp ON p.id_product = cp.id_product INNER JOIN ps_feature_product pf ON p.id_product = pf.id_product INNER JOIN ps_feature_lang fl ON pf.id_feature = fl.id_feature AND fl.id_lang = 4 INNER JOIN ps_feature_value_lang fvl ON pf.id_feature_value = fvl.id_feature_value AND fvl.id_lang = 4 WHERE cp.id_category = 48 AND p.active = 1 AND pf.id_feature IN (99,102,103) ORDER BY pf.id_feature, fvl.value




Technical specifications
Homme
Noir
Acier/Cuir
Rond
Boucles d'oreilles
Lotus Style Boucles D'Oreilles Homme Acier Noir - LS2154-4/2
Lotus Style
Lotus Style Collier Femme Acier inoxydable - Gamme Woman'S Heart - Cur
19,00 €
Al comprar este producto puedes recolectar hasta
1
punto
.
Su carrito totalizará 1
punto que se puede convertir en un vale de
0,20 €.
-
Expédié sous 24h
Read more
Ce Collier Femme Lotus Style de la gamme Woman'S Heart est un Collier en Acier inoxydable . Ce bijou, référence LS1944-2/1 est l'une des pièces de la marque Lotus Style à retrouver sur gperdumesaiguilles.com