Help and contact

Menu

0
My cart 0 article 
        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
copy of Lotus Style Collier Homme Acier LS1937-1/1

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 punt punten. Je winkelwagen komt in totaal 4 punten dat kan worden omgezet in een tegoedbon van € 0,80.

Niet op voorraad
  • Expédié sous 24h

Read more

Lotus Style - Collier Homme, Chaine acier maille anglaise - Gamme Men In Black - LS1937-1/1. 55cm.

Delivery for free
Delivery for free
from 69€ purchase
Payment secured
Payment secured
Credit card, Paypal or bank transfer
Payment from 2 to 4 times
Payment from 2 to 4 times
free of charge
Satisfied or your money back
Satisfied or your money back
within 14 days
Contact us
Contact us
06 20 43 38 42 (9am-6pm)
0