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
Homme
Acier
Doré
Acier
Collier
copy of Lotus Style Collier Homme Acier LS1937-1/1
Lotus Style
Lotus Style - Collier Homme - Chaîne acier maille anglaise - Gamme Men In Black - LS1937-1/1. 55cm.
€ 44,00
Door dit product te kopen verzamel je
4
punten.
Je winkelwagen komt in totaal 4
punten dat kan worden omgezet in een tegoedbon van
€ 0,80.
-
Expédié sous 24h
Read more
Lotus Style - Collier Homme, Chaine acier maille anglaise - Gamme Men In Black - LS1937-1/1. 55cm.