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 = 8
INNER JOIN ps_feature_value_lang fvl
ON pf.id_feature_value = fvl.id_feature_value
AND fvl.id_lang = 8
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
Tree Of Life
Argenté
Arbre de vie
Argent
Boucles d'oreilles
Lotus Silver Boucles d'oreilles Femme Argent - LP1746-4/1
Lotus Silver
Lotus Silver Boucles d'oreilles Femme Argent - Gamme Tree Of Life - Arbre de vie
€ 34,00
Door dit product te kopen verzamel je
3
punten.
Je winkelwagen komt in totaal 3
punten dat kan worden omgezet in een tegoedbon van
€ 0,60.
-
Expédié sous 24h
Read more
Ces Boucles d'oreilles Femme Lotus Silver de la gamme Tree Of Life sont des Boucles d'oreilles en Argent . Ce bijou, référence LP1746-4/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)