Help and contact

Menu

0
My cart 0 article 
SELECT DISTINCT m.id_manufacturer, m.name
        FROM ps_product p
        INNER JOIN ps_category_product cp ON p.id_product = cp.id_product
        INNER JOIN ps_manufacturer m ON p.id_manufacturer = m.id_manufacturer
        WHERE cp.id_category = 48
          AND p.active = 1
          AND p.id_manufacturer != 0
SELECT DISTINCT m.id_manufacturer, m.name
        FROM ps_product p
        INNER JOIN ps_category_product cp ON p.id_product = cp.id_product
        INNER JOIN ps_manufacturer m ON p.id_manufacturer = m.id_manufacturer
        WHERE cp.id_category = 3
          AND p.active = 1
          AND p.id_manufacturer != 0
SELECT DISTINCT m.id_manufacturer, m.name
        FROM ps_product p
        INNER JOIN ps_category_product cp ON p.id_product = cp.id_product
        INNER JOIN ps_manufacturer m ON p.id_manufacturer = m.id_manufacturer
        WHERE cp.id_category = 5
          AND p.active = 1
          AND p.id_manufacturer != 0
SELECT DISTINCT m.id_manufacturer, m.name
        FROM ps_product p
        INNER JOIN ps_category_product cp ON p.id_product = cp.id_product
        INNER JOIN ps_manufacturer m ON p.id_manufacturer = m.id_manufacturer
        WHERE cp.id_category = 4
          AND p.active = 1
          AND p.id_manufacturer != 0
SELECT DISTINCT m.id_manufacturer, m.name
        FROM ps_product p
        INNER JOIN ps_category_product cp ON p.id_product = cp.id_product
        INNER JOIN ps_manufacturer m ON p.id_manufacturer = m.id_manufacturer
        WHERE cp.id_category = 63
          AND p.active = 1
          AND p.id_manufacturer != 0
SELECT DISTINCT m.id_manufacturer, m.name
        FROM ps_product p
        INNER JOIN ps_category_product cp ON p.id_product = cp.id_product
        INNER JOIN ps_manufacturer m ON p.id_manufacturer = m.id_manufacturer
        WHERE cp.id_category = 11
          AND p.active = 1
          AND p.id_manufacturer != 0
SELECT DISTINCT m.id_manufacturer, m.name
        FROM ps_product p
        INNER JOIN ps_category_product cp ON p.id_product = cp.id_product
        INNER JOIN ps_manufacturer m ON p.id_manufacturer = m.id_manufacturer
        WHERE cp.id_category = 13
          AND p.active = 1
          AND p.id_manufacturer != 0
SELECT DISTINCT m.id_manufacturer, m.name
        FROM ps_product p
        INNER JOIN ps_category_product cp ON p.id_product = cp.id_product
        INNER JOIN ps_manufacturer m ON p.id_manufacturer = m.id_manufacturer
        WHERE cp.id_category = 15
          AND p.active = 1
          AND p.id_manufacturer != 0
SELECT DISTINCT m.id_manufacturer, m.name
        FROM ps_product p
        INNER JOIN ps_category_product cp ON p.id_product = cp.id_product
        INNER JOIN ps_manufacturer m ON p.id_manufacturer = m.id_manufacturer
        WHERE cp.id_category = 142
          AND p.active = 1
          AND p.id_manufacturer != 0
SELECT DISTINCT m.id_manufacturer, m.name
        FROM ps_product p
        INNER JOIN ps_category_product cp ON p.id_product = cp.id_product
        INNER JOIN ps_manufacturer m ON p.id_manufacturer = m.id_manufacturer
        WHERE cp.id_category = 143
          AND p.active = 1
          AND p.id_manufacturer != 0
SELECT DISTINCT m.id_manufacturer, m.name
        FROM ps_product p
        INNER JOIN ps_category_product cp ON p.id_product = cp.id_product
        INNER JOIN ps_manufacturer m ON p.id_manufacturer = m.id_manufacturer
        WHERE cp.id_category = 144
          AND p.active = 1
          AND p.id_manufacturer != 0
SELECT DISTINCT m.id_manufacturer, m.name
        FROM ps_product p
        INNER JOIN ps_category_product cp ON p.id_product = cp.id_product
        INNER JOIN ps_manufacturer m ON p.id_manufacturer = m.id_manufacturer
        WHERE cp.id_category = 145
          AND p.active = 1
          AND p.id_manufacturer != 0
SELECT DISTINCT m.id_manufacturer, m.name
        FROM ps_product p
        INNER JOIN ps_category_product cp ON p.id_product = cp.id_product
        INNER JOIN ps_manufacturer m ON p.id_manufacturer = m.id_manufacturer
        WHERE cp.id_category = 146
          AND p.active = 1
          AND p.id_manufacturer != 0
SELECT DISTINCT m.id_manufacturer, m.name
        FROM ps_product p
        INNER JOIN ps_category_product cp ON p.id_product = cp.id_product
        INNER JOIN ps_manufacturer m ON p.id_manufacturer = m.id_manufacturer
        WHERE cp.id_category = 106
          AND p.active = 1
          AND p.id_manufacturer != 0
SELECT DISTINCT m.id_manufacturer, m.name
        FROM ps_product p
        INNER JOIN ps_category_product cp ON p.id_product = cp.id_product
        INNER JOIN ps_manufacturer m ON p.id_manufacturer = m.id_manufacturer
        WHERE cp.id_category = 106
          AND p.active = 1
          AND p.id_manufacturer != 0
SELECT DISTINCT m.id_manufacturer, m.name
        FROM ps_product p
        INNER JOIN ps_category_product cp ON p.id_product = cp.id_product
        INNER JOIN ps_manufacturer m ON p.id_manufacturer = m.id_manufacturer
        WHERE cp.id_category = 68
          AND p.active = 1
          AND p.id_manufacturer != 0
Pierre Lannier Bracelet Acier Doré Nacre Blanche BJ24A5211

Technical specifications

Femme
2 ans
Acier/Silicone
Rond
Blanc Doré
Bracelet
Hématite Nacre

Pierre Lannier Bracelet Acier Doré Nacre Blanche BJ24A5211

Pierre Lannier

55,00 €

Al comprar este producto puedes recolectar hasta 5 punto puntos. Su carrito totalizará 5 puntos que se puede convertir en un vale de 1,00 €.

  • Garantie 2 ans
  • Expédié sous 24h
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