Menu
SELECT DISTINCT
f.id_feature,
fl.name AS feature_name,
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 fp
ON p.id_product = fp.id_product
INNER JOIN ps_feature f
ON f.id_feature = fp.id_feature
INNER JOIN ps_feature_lang fl
ON f.id_feature = fl.id_feature
AND fl.id_lang = 9
INNER JOIN ps_feature_value_lang fvl
ON fp.id_feature_value = fvl.id_feature_value
AND fvl.id_lang = 9
WHERE cp.id_category = 48
AND p.active = 1
AND fp.id_feature IN (99,102,103)
ORDER BY f.id_feature, fvl.value
Technical specifications
Go Girl Montre Femme Acier Argenté 695216
Go Girl Only
Boitier rond acier 30mm - Quartz (pile) - affichage analogique 3 aiguilles - bracelet Acier - cadran violet.
Garantie internationale fabricant de 2 ans
By buying this product you can collect up to
4
points.
Your cart will total 4
points that can be converted into a voucher of
0,80 €.
-
Garantie 2 ans -
Expédié sous 24h
Read more
Comme le papillon, symbole de la marque, tout l’univers de GO est volontairement frais, léger, coloré, optimiste, harmonieux, attirant, impertinent, novateur…cette montre femme ref 695216 avec son boitier en acier rond, son cadran violet ainsi que son bracelet acier sera un accessoire chic reflétant les dernières tendances de la mode française et internationale. Les montres GO bénéficient de la garantie internationale du fabricant de 2 ans.
