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 = 5
INNER JOIN ps_feature_value_lang fvl
ON fp.id_feature_value = fvl.id_feature_value
AND fvl.id_lang = 5
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
Femme
Cuir
Rose
Rose
Acier
Doré rose
Rond
Boucle déployante
3 ATM
?
QUARTZ
Analogique
2 ans
Minéral
Go Girl Montre Femme Acier Doré Rose Cuir Rose 699496
Go Girl Only
79,90 €
Acquistando questo prodotto puoi ricevere fino a
7
punti.
Il tuo carrello ti offrirà 7
punti convertibili in un voucher di:
1,40 €.
-
Garantie 2 ans -
Expédié sous 24h -
Livraison gratuite
Recommended products
Delivery for free
from 69€ purchase
Payment secured
Credit card, Paypal or bank transfer
Payment from 2 to 4 times
free of charge
Satisfied or your money back
within 14 days
Contact us
06 20 43 38 42 (9am-6pm)