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
Femme
Acier
Doré
Argenté
Acier
Argenté
Rond
Boucle déployante
3 ATM
?
QUARTZ
Analogique
40
2 ans
Minéral
Guess Cubed Montre Femme Acier GW0606L1
Guess
129,00 €
Al comprar este producto puedes recolectar hasta
12
puntos.
Su carrito totalizará 12
puntos que se puede convertir en un vale de
2,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)