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 = 9
INNER JOIN ps_feature_value_lang fvl
ON pf.id_feature_value = fvl.id_feature_value
AND fvl.id_lang = 9
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
2 ans
Acier
Rond
Argenté
Bleu
Bracelet
Hématite
Nacre
Pierre Lannier Bracelet Acier Nacre Bleue BJ24A1161
Pierre Lannier
49,00 €
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
Produits liés
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)