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 = 7
INNER JOIN ps_feature_value_lang fvl
ON pf.id_feature_value = fvl.id_feature_value
AND fvl.id_lang = 7
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
Mystic
Infini
Argent
Bracelet
Lotus Silver Bracelet Femme Doré Signe Infini LP1859-2/3
Lotus Silver
Lotus Silver Collier Femme Argent - Gamme Pure Essential - Tube
€34.00
By buying this product you can collect up to
3
points.
Your cart will total 3
points that can be converted into a voucher of
€0.60.
-
Expédié sous 24h
Read more
Ce Collier Femme Lotus Silver de la gamme Pure Essential est un Collier en Argent . Ce bijou, référence LP1747-1/1 est l'une des pièces de la marque Lotus Silver à retrouver sur gperdumesaiguilles.com
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)