Wechseln zu

  1. Navigation
  2. Inhalt
 
SELECT o.product, o.option, p.name, p.seourl as seoUrl, o.colour, os.`de-eur-online` as status, c.name AS colourName, o.waseur AS wasPrice, o.noweur AS nowPrice, `option-image`.`filename` AS image, IF(o.`swatch` IS NULL, c.`swatch`, o.`swatch`) as swatch, sku.sku, sku.stock, sku.backorderable, sku.`base-size`, `base-size`.`locale-size`, `base-size`.`locale-leg-size`, `base-size`.`order` AS `base-size-order`, sku.due, o.rating, CONCAT( CONCAT('d', GROUP_CONCAT(DISTINCT CAST(bsm.`dress-size` AS char) SEPARATOR ',d')), ',', CONCAT('t', GROUP_CONCAT(DISTINCT CAST(bsm.`trouser-size` AS char) SEPARATOR ',t')), ',', CONCAT('l', GROUP_CONCAT(DISTINCT CAST(bsm.`leg-length` AS char) SEPARATOR ',l')), ',', CONCAT('s', GROUP_CONCAT(DISTINCT CAST(bsm.`shoe-size` AS char) SEPARATOR ',s')) ) AS sizes, GROUP_CONCAT(DISTINCT om.`modifierID`) AS 'modifiers', GROUP_CONCAT(DISTINCT od.`departmentID`) AS 'departments', GROUP_CONCAT(DISTINCT ob.`brandID`) AS 'brands' FROM `sku-de-eur` AS sku LEFT JOIN `base-size` ON sku.`base-size` = `base-size`.`base-size` AND `base-size`.`currency` = 'eur' LEFT JOIN `option-de` o ON o.`option` = sku.option LEFT JOIN `product-de` p ON p.product = o.product LEFT JOIN colour c ON c.colour = o.colour LEFT JOIN `option-image` ON `option-image`.`option` = o.`option` LEFT JOIN `option-modifier` AS om ON (om.`option` = o.`option`) LEFT JOIN `option-status`as os ON o.`option` = os.`option` LEFT JOIN `option-brand`as ob ON o.`option` = ob.`option` LEFT JOIN `base-size-map` AS bsm ON sku.`base-size` = bsm.`base-size` LEFT JOIN `option-department` AS od ON sku.`option` = od.`option` WHERE sku.option IN (?) AND os.`de-eur-online` != 'O' -- Exclude obsolete status options GROUP BY sku.sku ORDER BY o.colour ASC, sku.`base-size` ASC

Neckholder-Badeanzug

0,00 €

  • 38
  • 40
  • 42
  • 44
  • 46
  • 48
  • 50
Größentabelle Ausverkauft
Bitte wählen Sie zunächst eine Größe

Beschreibung

Klassischer Neckholder im Stil der 50er Jahre mit neuer und verbesserter, gerüschter Vorderseite für zusätzliche Stützfunktion am Bauch. Tiefes Dekolleté und herausnehmbare Brustpolster.

Passform und Pflege

Passform:
Enge Passform.
Material:
80 % Polyamid, 20 % Elastan. Innenfutter: 100 % Polyester. Saum und Stütze: 88 % Polyamid, 12 % Elastan.

Waschanleitung:
Handwäsche.

Versandinformationen werden geladen ...

Teilen

Bewertungen (3)

Gesamtbewertung: { (3 Bewertungen | Schreiben Sie eine Bewertung }

  • Passform: Sehr klein
  • Qualität:
  • Preis:

    Fabulous suit

    • Passform: Passgenau
    • Qualität:
    • Preis:

    This suit is fabulous. i love the cut, and it's very comfortable. the neckline is my favorite and the ruching is very flattering! overall, excellent!

    Katie would recommend this product to a friend.

    Love the suit!

      Yes, it runs big, ordered one size smaller, a 12 and had to return it for a 10. Makes me feel small! It is almost too long in the body, but not by much. So comfortable. Customer service was wonderful and helpful. I needed the replacement suit by the 4th of July and they made sure I received it in time. Thank you.

      Runs big

        I love this suit except it runs a lot bigger. I am a size 16 & that was huge so I ordered a 14 & that is too big but I still love this suit!! It s flattering.