Mein Warenkorb

❌
Gesamtartikel
Zum Warenkorb
Menü
Siehe Größen
Raquel Guêpière - Elastische Maschenware und luxuriöser Satin
Doppelklicken Sie zum Vergrößern
SKU: SBBU0754
Raquel Guêpière - Elastische Maschenware und luxuriöser Satin
Lager:

Entdecken Sie Raquel, ein kleines Miederjuwel, das Ihre Rundungen elegant formt. Es ist aus elastischer Maschenware und luxuriösem Satin gefertigt und bringt Ihre Brüste perfekt zur Geltung.

Mit seinen verstellbaren Strumpfbändern und dem passenden String ist dieses Mieder ein wahrer Trumpf der Verführung.

Highlights / Vorteile

  • Elastische Maschenware und luxuriöser Satin formen Ihre Kurven
  • Hervorhebung der Brust mit einem raffinierten Schnitt
  • Verstellbare Strumpfbänder für einen individuellen Halt
  • Passender String für ein harmonisches Ensemble
  • Hochwertige Materialien für optimalen Tragekomfort
  • Design, das die Rundungen hervorhebt
Größe:

Sie wissen nicht, welche Größe Sie wählen sollen? Sehen Sie sich unseren Größenratgeber an

Farbe:
Menge:
79.95 €
Fundierte Ratschläge
per Chat, Facebook oder E-Mail
Kostenlose Rücksendungen
innerhalb von 15 Tagen *

Raquel Guêpière Große Größe Elastische Maschenware Satin

Produktbeschreibung

Entdecken Sie Raquel, ein Mieder, das nicht nur ein einfaches Kleidungsstück ist, sondern ein wahres kleines verführerisches Schmuckstück. Jedes Detail wurde durchdacht, um Ihre Kurven mit absoluter Eleganz zu feiern und zu sublimieren. Die elastische Maschenware schmiegt sich wie eine zweite Haut an Ihre Silhouette und schafft eine perfekte Formgebung, die Ihre natürlichen Rundungen hervorhebt. Dieses technische Material bietet eine optimale Passform und garantiert gleichzeitig einen bemerkenswerten Komfort bei jeder Bewegung.

Der luxuriöse Satin fügt eine Dimension raffinierter Raffinesse hinzu.

Seine glatte, glänzende Textur umschmeichelt Ihre Haut und sorgt für einen atemberaubenden visuellen Effekt. Jede Reflexion des Satin wird zu einer Einladung zur Verführung und verwandelt Ihre Silhouette in ein lebendiges Kunstwerk. Der Schnitt ist besonders darauf ausgelegt, Ihre Brust zu betonen. Er modelliert und stützt Ihre Kurven mit einer Präzision, die den Unterschied ausmacht. Jedes Detail ist durchdacht, um eine elegante und sinnliche Linie zu schaffen, die die Blicke auf sich zieht. Mit den verstellbaren Strumpfbändern können Sie Ihren Halt mit millimetergenauer Präzision individuell anpassen. Sie können die Spannung genau so einstellen, wie Sie es wünschen, und garantieren so optimalen Komfort und einen makellosen Stil. Der passende String ergänzt das Mieder harmonisch. Er verlängert das Design und die Raffinesse des Hauptteils und schafft so ein Ensemble, das Sinnlichkeit und Stimmigkeit ausstrahlt.

Raquel ist in großen Größen erhältlich und feiert alle Körperformen. Sie beweist, dass Verführung keine Grenzen kennt und dass Schönheit im Selbstvertrauen und in der Selbstakzeptanz zu finden ist.

Technische Details

  • Name: Raquel
  • Zusammensetzung: Guêpière + passender String
  • Material: Elastische Maschenware und luxuriöser Satin
  • Details: Verstellbare Strumpfbänder
  • Schnitt: Figurbetont, betont die Brüste
  • Stil: Elegant und sinnlich

Verfügbare Größen

Erhältlich von 1X/2X- bis 3X/4X

Verfügbare Farbe

Schwarz

Weitere technische Daten

Material Elastischer Satin

Größenanleitung

Uberprüfen Sie die für Sie passende Größe

International
  • Brust
  • Größe
  • Hüften
1X/2X-
  • 104-110
  • 86-91
  • 112-120
3X/4X+
  • 128-132
  • 102-108
  • 132-138
XL
  • 99-104
  • 81-86
  • 107-112
1X/2X
  • 112-118
  • 92-96
  • 122-128
3X/4X
  • 120-128
  • 98-102
  • 128-132

Pflegehinweise

  • Handwäsche mit milder Seife oder Schonwaschgang in der Maschine (max. 30°C) in einem Wäschenetz empfohlen
  • Flach im Schatten trocknen, niemals im Trockner
  • Bügeln nicht empfohlen oder bei sehr niedriger Temperatur, falls nötig
  • Flach an einem trockenen Ort aufbewahren
  • Um die Elastizität und den Halt Ihrer Teile zu bewahren (Größen 42-64), wechseln Sie deren Gebrauch ab
  •  
  • Feinwäsche von Hand in kaltem Wasser
  • Verwenden Sie ein mildes Waschmittel speziell für feine Dessous
  • Nicht wringen oder auswringen
  • vermeiden Sie direkte Sonneneinstrahlung
  • Flach trocknen
  • Gehen Sie vorsichtig mit Satin und elastischer Maschenware um
  • Überprüfen Sie regelmäßig die Strumpfhalter
  • Flach aufbewahren, um die Form zu bewahren
To Top
Zum Warenkorb
Artikel
Gesamtartikel
Struct
Entries: 108
actions
Array
available
number-1
brand
stringhouseofdesire
brandcode
stringhecs
branding
stringdivasboudoir
brandmedias
string{"default":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"editorial":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"logo":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""}}
brandmetas
Struct
de
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
el
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
en
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
es
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
fr
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
it
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
nl
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
pt
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
brandname
stringHouse of Desire
breasts
stringna
careinstructions
stringlace
categories
stringdivasboudoir.lingerie.sexylingerie.bustier
category
stringsexylingerie
categorygender
stringf
categorymediadatas
Struct
adult
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string276
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/lingerie/sexylingerie/bustier.jpg
type
stringimg
width
string600
divasboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
fetishboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
latexboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
legsboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
lustboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
private
Struct
height
string1016
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/private/default.jpg
type
stringimg
width
string703
smboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
categorysizerange
stringauto
colorinfos
Query
Template: /system/api/product/colors.cfc:13
Execution Time: 0.743 ms
Record Count: 1
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_colors.color as recorduid, product_colors.type, product_colors.code, product_colors.color, product_colors.range, product_colors.hexvalue,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock
from product_colors
left outer join product_variations on product_colors.color = product_variations.color and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
where FIND_IN_SET(product_colors.color,'black') > 0
and product_variations.productuid = 'B698842E-0918-45A5-B403B27B1D5D4460'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1blackcolorblakblackblack#000000-10
colorrange
stringblack
colors
stringblack
colortype
stringcolor
comments
string
compositions
Struct
Entries: 13
coton
string
elastane
string
free
string
leather
string
lycra
string
metal
string
nylon
string
polyamide
string
polyester
string
polyurethane
string
silk
string
spandex
string
viscose
string
datecreated
Date Time (Europe/Paris)
{ts '2024-05-09 20:06:20'}
defect
number0
dimensions
Struct
Entries: 14
acrylicbones
string
backsideheight
string
diameter
string
flatsteelbones
string
frontsideheight
string
fullheight
string
length
string
modestysize
string
panels
string
sides
string
spiralsteelbones
string
totallength
string
unit
stringcm
wiresize
string
display
stringall
displayfrom
string
displayto
string
grossweight
string
hasbrandinfos
booleanfalse
hascareinstructions
booleantrue
hascolorinfos
booleantrue
hascompositions
booleanfalse
hasdescription
booleantrue
hasdimensions
booleanfalse
hasmaterials
booleantrue
hasotherspecifications
booleanfalse
haspromo
number0
hasshortdescription
booleantrue
hassizeinfos
booleantrue
hasspecifications
booleantrue
hasstockinfos
booleanfalse
hasstylingtips
booleanfalse
hasusageinstructions
booleanfalse
hasvariations
booleantrue
import
string
inpromo
number0
instockvariations
number0
isactive
number1
iscustommade
number0
isdivasize
number0
isfirstprice
number0
isfixedprice
number0
ishot
number0
isnew
number0
isonline
number0
isoutletprice
number0
itemprice
number66.625
itempromo
string
key
stringhd04406a
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-10-22 18:45:11'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.607 ms
Record Count: 0
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select cart_actions.*
from cart_actions
where cart_actions.branding IN ('all','divasboudoir')
and cart_actions.language IN ('all','de')
and (cart_actions.quotas = -1 or (cart_actions.usedCount < cart_actions.quotas))
and cart_actions.isactive = 1
and (date(cart_actions.activeFrom) <= '2025-11-24' OR cart_actions.activeFrom is null)
and (date(cart_actions.activeTo) >= '2025-11-24' OR cart_actions.activeTo is null)
and (
FIND_IN_SET('b698842e-0918-45a5-b403b27b1d5d4460',lcase(cart_actions.linkedproducts)) > 0 and cart_actions.linkedproducts is not null
)
id_actionbrandinglanguagenamecodetypeminimumOrdermaximumOrderminimumItemsmaximumItemsmaximumUseallowedItemsquotasusedCountlinkedproductslinkedthemeslinkedbrandslinkeditemparamsactiveFromactiveToisActive
linkedproducts
Query
Template: /system/api/products.cfc:1305
Execution Time: 1.32 ms
Record Count: 0
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select products.productuid as productuid, products.reference, 'default' as type, products.key, products.language, products.name,
product_links.linkuid,
products.colors, products.vatrate, products.metadatas, products.dimensions,
products.mediadatas, products.tags, products.themes, products.isdivasize,
count(distinct product_variations.variationuid) as totalvariations,
group_concat(distinct product_variations.variationuid) as variationlist,
count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END) as inpromo,
if(count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END)>0,1,0) as haspromo,
(select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0) END)) as itempromo,
IFNULL(min(product_variations.itemprice),0) as itemprice,
(select IF (products.isfixedprice = 0 and sum(product_variations.itempromo) > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null), IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0), IFNULL(min(NULLIF(product_variations.itemprice, 0)), 0) )) as unitprice,
count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.itempromo ELSE product_variations.itemprice END) as prices,
(select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN min(NULLIF(product_variations.promountil, 0)) END)) as promountil,
products.isfixedprice, products.ishot, products.isnew, if(products.orderidx > 0, products.orderidx, 999999999) as orderidx,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
count(distinct CASE WHEN ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) > 0 OR ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) <= 0 AND product_variations.supplier = 0)) THEN product_variations.variationuid END) as instockvariations,
products.brand, brands.name as brandname, IFNULL(brands.ispublic, 0) as showbrand, brands.display,
product_categories.sizetype,GROUP_CONCAT(DISTINCT product_sizes.suppliersize) as intlsize,products.sizes,product_sizes.sizerange,product_categories.mediadatas as categorymediadatas, product_categories.sizerange as categorysizerange,
product_categorymap.section, product_categorymap.category, product_categorymap.key as subcategory
from products
left outer join product_categorymap on products.productuid = product_categorymap.productuid
left outer join product_categories on (product_categories.branding = product_categorymap.branding and product_categories.section = product_categorymap.section and product_categories.category = product_categorymap.category and product_categories.key = product_categorymap.key)
left outer join product_sizes on product_sizes.id_size IN (products.sizes)
left outer join brands on products.brand = brands.brand
left outer join product_variations on product_variations.productuid = products.productuid and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
left outer join product_links on product_links.reference = products.reference
where products.isactive = 1 and products.isdeleted = 0
and brands.isactive = 1 and brands.isdeleted = 0
and product_categories.isactive = 1 and product_categories.isdeleted = 0
and product_variations.isactive = 1
and FIND_IN_SET('divasboudoir',products.branding)
and product_categories.branding IN ('all','divasboudoir')
and product_categorymap.branding IN ('all','divasboudoir')
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and products.language in ('all','de')
and product_categories.language in ('all','de')
and (products.displayFrom <= DATE(NOW()) or products.displayFrom is null)
and (products.displayTo >= DATE(NOW()) or products.displayTo IS null)
and product_links.linkuid = '' and product_links.linkuid is not null and product_links.linkuid <> ''
and products.reference <> 'SBBU0754'
group by products.reference
order by products.ishot desc, products.isnew desc, orderidx asc, products.lastupdated desc
productuidreferencetypekeylanguagenamelinkuidcolorsvatratemetadatasdimensionsmediadatastagsthemesisdivasizetotalvariationsvariationlistinpromohaspromoitempromoitempriceunitpricepricespromountilisfixedpriceishotisneworderidxavailablestockinstockvariationsbrandbrandnameshowbranddisplaysizetypeintlsizesizessizerangecategorymediadatascategorysizerangesectioncategorysubcategory
linkuid
string
materials
stringstretchsatin
mediadatas
Struct
alt
Struct
height
string834
isprivate
string0
rating
stringall
src
string/photobank/products/hecs/sbbu0754/longue-guepiere-grande-taille-dos.jpg
type
stringimg
width
string577
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string738
isprivate
string0
rating
stringall
src
string/photobank/products/hecs/sbbu0754/longue_guepiere_grande_taille.jpg
type
stringimg
width
string510
variations
Struct
colors
Struct
black
Struct
height
string738
isprivate
string0
rating
stringall
src
string/photobank/products/hecs/sbbu0754/longue_guepiere_grande_taille.jpg
type
stringimg
width
string510
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
mediagallery
string
metadatas
Struct
darkboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz-ou-grau
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro-ou-gkri
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black-ou-grey
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro-ou-gris
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-ou-gris
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero-ou-grigio
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart-ou-grijs
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto-ou-cinzento
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
divasboudoir
Struct
de
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Feinwäsche von Hand in kaltem Wasser</li> <li>Verwenden Sie ein mildes Waschmittel speziell für feine Dessous</li> <li>Nicht wringen oder auswringen</li> <li>vermeiden Sie direkte Sonneneinstrahlung</li> <li>Flach trocknen</li> <li>Gehen Sie vorsichtig mit Satin und elastischer Maschenware um</li> <li>Überprüfen Sie regelmäßig die Strumpfhalter</li> <li>Flach aufbewahren, um die Form zu bewahren</li> </ul>
description
string<p>Entdecken Sie <strong>Raquel</strong>, ein Mieder, das nicht nur ein einfaches Kleidungsstück ist, sondern ein wahres kleines verführerisches Schmuckstück. Jedes Detail wurde durchdacht, um Ihre Kurven mit absoluter Eleganz zu feiern und zu sublimieren. Die <strong>elastische Maschenware</strong> schmiegt sich wie eine zweite Haut an Ihre Silhouette und schafft eine perfekte Formgebung, die Ihre natürlichen Rundungen hervorhebt. Dieses technische Material bietet eine optimale Passform und garantiert gleichzeitig einen bemerkenswerten Komfort bei jeder Bewegung.</p> <p>Der <strong>luxuriöse Satin</strong> fügt eine Dimension raffinierter Raffinesse hinzu.</p> <p>Seine glatte, glänzende Textur umschmeichelt Ihre Haut und sorgt für einen atemberaubenden visuellen Effekt. Jede Reflexion des Satin wird zu einer Einladung zur Verführung und verwandelt Ihre Silhouette in ein lebendiges Kunstwerk. Der Schnitt ist besonders darauf ausgelegt, <strong>Ihre Brust</strong> zu betonen. Er modelliert und stützt Ihre Kurven mit einer Präzision, die den Unterschied ausmacht. Jedes Detail ist durchdacht, um eine elegante und sinnliche Linie zu schaffen, die die Blicke auf sich zieht. Mit den <strong>verstellbaren Strumpfbändern</strong> können Sie Ihren Halt mit millimetergenauer Präzision individuell anpassen. Sie können die Spannung genau so einstellen, wie Sie es wünschen, und garantieren so optimalen Komfort und einen makellosen Stil. Der <strong>passende String</strong> ergänzt das Mieder harmonisch. Er verlängert das Design und die Raffinesse des Hauptteils und schafft so ein Ensemble, das Sinnlichkeit und Stimmigkeit ausstrahlt.</p> <p><strong>Raquel</strong> ist in <strong>großen Größen</strong> erhältlich und feiert alle Körperformen. Sie beweist, dass Verführung keine Grenzen kennt und dass Schönheit im Selbstvertrauen und in der Selbstakzeptanz zu finden ist.</p>
guid
stringhttps://dev.divasboudoir.com/de/raquel-mieder-in-grossen-grossen-schwarz-ou-grau/sbbu0754.htm
highlights
string<ul> <li><strong>Elastische Maschenware und luxuriöser Satin</strong> formen Ihre Kurven</li> <li><strong>Hervorhebung der Brust</strong> mit einem raffinierten Schnitt</li> <li><strong>Verstellbare Strumpfbänder</strong> für einen individuellen Halt</li> <li><strong>Passender String</strong> für ein harmonisches Ensemble</li> <li><strong>Hochwertige Materialien</strong> für optimalen Tragekomfort</li> <li><strong>Design, das die Rundungen hervorhebt</strong></li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringRaquel Guêpière in großen Größen: elastische Maschenware und luxuriöser Satin, verstellbare Strapshalter, passender String. Figurformend und sinnlich. Diva's Boudoir.
keywords
string
title
stringRaquel Guêpière Grande Taille | Diva's Boudoir
seotitle
stringRaquel Guêpière Große Größe Elastische Maschenware Satin
seouri
stringraquel-mieder-in-grossen-grossen-schwarz-ou-grau
specifications
string<ul> <li><strong>Name</strong>: Raquel</li> <li><strong>Zusammensetzung</strong>: Gu&ecirc;pi&egrave;re + passender String</li> <li><strong>Material</strong>: Elastische Maschenware und luxuriöser Satin</li> <li><strong>Details</strong>: Verstellbare Strumpfbänder</li> <li><strong>Schnitt</strong>: Figurbetont, betont die Brüste</li> <li><strong>Stil</strong>: Elegant und sinnlich</li> </ul>
stylingtips
string
summary
string<p>Entdecken Sie <strong>Raquel</strong>, ein kleines Miederjuwel, das Ihre Rundungen elegant formt. Es ist aus <strong>elastischer Maschenware und luxuriösem Satin</strong> gefertigt und bringt Ihre Brüste perfekt zur Geltung.</p> <p>Mit seinen <strong>verstellbaren</strong> Strumpfbändern und dem <strong>passenden String</strong> ist dieses Mieder ein wahrer Trumpf der Verführung.</p>
title
stringRaquel Guêpière - Elastische Maschenware und luxuriöser Satin
usageinstructions
string
el
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Πλύσιμο στο χέρι με κρύο νερό</li> <li>Χρησιμοποιήστε ένα ήπιο απορρυπαντικό για τα ωραία εσώρουχα</li> <li>Μην στύβετε ή στίβετε</li> <li>αποφύγετε το άμεσο ηλιακό φως</li> <li>Στεγνώστε σε επίπεδη επιφάνεια</li> <li>Να χειρίζεστε τα σατέν και τα ελαστικά πλεκτά με προσοχή</li> <li>Ελέγχετε τακτικά τις καλτσοδέτες</li> <li>Αποθηκεύστε τα σε επίπεδη μορφή για να διατηρήσετε το σχήμα σας</li> </ul>
description
string<p>Ανακαλύψτε <strong>τη Raquel</strong>, μια gu&ecirc;pi&egrave;re που δεν είναι απλώς ένα ρούχο, αλλά ένα πραγματικό μικρό κόσμημα αποπλάνησης. Κάθε λεπτομέρεια έχει σχεδιαστεί για να γιορτάζει και να αναδεικνύει τις καμπύλες σας με απόλυτη κομψότητα. Το <strong>ελαστικό πλεκτό</strong> αγκαλιάζει τη σιλουέτα σας σαν δεύτερο δέρμα, δημιουργώντας μια τέλεια καμπύλη που αναδεικνύει τις φυσικές σας καμπύλες. Αυτό το τεχνικό ύφασμα προσφέρει βέλτιστη στήριξη, ενώ εγγυάται αξιοσημείωτη άνεση σε κάθε σας κίνηση.</p> <p>Το <strong>πολυτελές σατέν</strong> προσθέτει μια διάσταση εκλεπτυσμένης φινέτσας.</p> <p>Η απαλή, γυαλιστερή υφή του χαϊδεύει το δέρμα σας, δημιουργώντας ένα εντυπωσιακό οπτικό αποτέλεσμα. Κάθε αντανάκλαση του σατέν γίνεται πρόσκληση για αποπλάνηση, μετατρέποντας τη σιλουέτα σας σε ένα ζωντανό έργο τέχνης. Το κόψιμο είναι ειδικά σχεδιασμένο για να <strong>αναδεικνύει το μπούστο σας</strong>. Διαμορφώνει και υποστηρίζει τις καμπύλες σας με ακρίβεια που κάνει τη διαφορά. Κάθε λεπτομέρεια έχει σχεδιαστεί για να δημιουργεί μια κομψή, αισθησιακή γραμμή που μαγνητίζει τα βλέμματα. Οι <strong>ρυθμιζόμενες καλτσοδέτες</strong> σας επιτρέπουν να προσαρμόσετε την εφαρμογή σας με ακρίβεια χιλιοστού. Μπορείτε να ρυθμίσετε την ένταση ακριβώς όπως τη θέλετε, εξασφαλίζοντας βέλτιστη άνεση και άψογο στυλ. Το <strong>ασορτί στρινγκ</strong> συμπληρώνει την καλτσοδέτα. Επεκτείνει τον σχεδιασμό και την εκλέπτυνση του κύριου κομματιού, δημιουργώντας ένα σύνολο που αποπνέει αισθησιασμό και συνέπεια.</p> <p>Διατίθεται σε <strong>μεγάλα μεγέθη</strong>, η <strong>Raquel</strong> εξυμνεί όλους τους σωματότυπους. Αποδεικνύει ότι η αποπλάνηση δεν έχει όρια και ότι η ομορφιά βρίσκεται στην αυτοπεποίθηση και την αυτοαποδοχή.</p>
guid
stringhttps://dev.divasboudoir.com/el/raquel-mpoystaki-megaloy-megethoys-mayro-ou-gkri/sbbu0754.htm
highlights
string<ul> <li><strong>Ελαστικό πλέγμα και πολυτελές σατέν</strong> διαμορφώνουν τις καμπύλες σας</li> <li>Το εκλεπτυσμένο κόψιμο<strong>ενισχύει το στήθος</strong> </li> <li><strong>Ρυθμιζόμενες καλτσοδέτες</strong> για εξατομικευμένη υποστήριξη</li> <li><strong>Ασορτί στρινγκ</strong> για ένα αρμονικό σύνολο</li> <li><strong>Υλικά υψηλής ποιότητας</strong> για βέλτιστη άνεση</li> <li><strong>Σχεδιασμός που αναδεικνύει τις καμπύλες</strong></li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringRaquel plus size ζώνη με τιράντες: ελαστικό πλέγμα και πολυτελές σατέν, ρυθμιζόμενες τιράντες, ασορτί στρινγκ. Σχηματισμένη και αισθησιακή. Μπουντουάρ της Ντίβας.
keywords
string
title
stringGuêpière Raquel Grande Taille | Diva's Boudoir
seotitle
stringRaquel μεγάλο μέγεθος Suspender ελαστικό πλέγμα σατέν
seouri
stringraquel-mpoystaki-megaloy-megethoys-mayro-ou-gkri
specifications
string<ul> <li><strong>Όνομα</strong>: Raquel</li> <li><strong>Σύνθεση</strong>: Bustier + ασορτί στρινγκ</li> <li><strong>Υλικό</strong>: Ελαστικό πλέγμα και πολυτελές σατέν</li> <li><strong>Λεπτομέρειες</strong>: Ρυθμιζόμενες καλτσοδέτες</li> <li><strong>Κοπή</strong>: Καλοσχηματισμένο, που ενισχύει το στήθος</li> <li><strong>Στυλ</strong>: Κομψό και αισθησιακό</li> </ul>
stylingtips
string
summary
string<p>Ανακαλύψτε <strong>τη Raquel</strong>, ένα μικρό κόσμημα από γκεπιέρα που θα διαμορφώσει τις καμπύλες σας με κομψότητα. Κατασκευασμένο από <strong>ελαστικό πλέγμα και πολυτελές σατέν</strong>, αναδεικνύει το μπούστο σας με εξαίσιο αποτέλεσμα.</p> <p>Με τις <strong>ρυθμιζόμενες καλτσοδέτες</strong> και το <strong>ασορτί στρινγκ</strong>, αυτή η καλτσοδέτα είναι ένα πραγματικό πλεονέκτημα αποπλάνησης.</p>
title
stringRaquel Bustier - Ελαστικό πλέγμα και πολυτελές σατέν
usageinstructions
string
en
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Delicate hand wash in cold water</li> <li>Use a mild detergent for fine lingerie</li> <li>Do not wring or spin</li> <li>avoid direct sunlight</li> <li>Dry flat</li> <li>Handle satin and elastic knitwear with care</li> <li>Check garters regularly</li> <li>Store flat to preserve shape</li> </ul>
description
string<p>Discover <strong>Raquel</strong>, a gu&ecirc;pi&egrave;re that's not just a garment, but a veritable jewel of seduction. Every detail has been designed to celebrate and enhance your curves with absolute elegance. <strong>Elastic mesh</strong> hugs your silhouette like a second skin, creating perfect curves that enhance your natural curves. This technical fabric offers optimum support while guaranteeing remarkable comfort with every movement.</p> <p><strong>Luxurious satin</strong> adds a dimension of refined sophistication.</p> <p>Its smooth, shiny texture caresses your skin, creating a striking visual effect. Every satin reflection becomes an invitation to seduction, transforming your silhouette into a living work of art. The cut is specially designed to <strong>enhance your bust</strong>. It sculpts and supports your curves with a precision that makes all the difference. Every detail is designed to create an elegant, sensual and eye-catching line. <strong>Adjustable garters</strong> let you customize your fit with millimeter precision. You can adjust the tension exactly as you wish, guaranteeing optimum comfort and impeccable style. The <strong>matching thong</strong> complements the garter. It extends the design and sophistication of the main piece, creating an ensemble that exudes sensuality and consistency.</p> <p>Available in <strong>plus size</strong>, <strong>Raquel</strong> celebrates all body types. She proves that seduction has no limits, and that beauty lies in self-confidence and self-acceptance.</p>
guid
stringhttps://dev.divasboudoir.com/en/raquel-plus-size-bustier-black-ou-grey/sbbu0754.htm
highlights
string<ul> <li><strong>Elastic mesh and luxurious satin</strong> shape your curves</li> <li>Sophisticated cut<strong>enhances the bosom</strong> </li> <li><strong>Adjustable garters</strong> for personalized support</li> <li><strong>Matching thong</strong> for a harmonious ensemble</li> <li><strong>High-quality materials</strong> for optimum comfort</li> <li><strong>Design that enhances curves</strong></li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringRaquel plus size basque: luxurious satin and elastic mesh, adjustable suspenders, matching thong. Shapely and sensual. Diva's Boudoir.
keywords
string
title
stringGuêpière Raquel Plus Size | Diva's Boudoir
seotitle
stringRaquel Plus Size Suspender Elastic Mesh Satin
seouri
stringraquel-plus-size-bustier-black-ou-grey
specifications
string<ul> <li><strong>Name</strong>: Raquel</li> <li><strong>Composition</strong>: Bustier + matching thong</li> <li><strong>Material</strong>: Elastic mesh and luxurious satin</li> <li><strong>Details</strong>: Adjustable garters</li> <li><strong>Cut</strong>: Shapely, chest-enhancing</li> <li><strong>Style</strong>: Elegant and sensual</li> </ul>
stylingtips
string
summary
string<p>Discover <strong>Raquel</strong>, a little jewel of a gu&ecirc;pi&egrave;re that will shape your curves with elegance. Made from <strong>elastic mesh and luxurious satin</strong>, it sublimely enhances your bust.</p> <p>With its <strong>adjustable garters</strong> and <strong>matching thong</strong>, this garter is a real seductive asset.</p>
title
stringRaquel Bustier - Elastic Mesh and Luxurious Satin
usageinstructions
string
es
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavado delicado a mano en agua fría</li> <li>Utilizar un detergente suave para lencería fina</li> <li>No escurrir ni centrifugar</li> <li>evitar la luz solar directa</li> <li>Secar en plano</li> <li>Manipule con cuidado las prendas de satén y punto elástico</li> <li>Compruebe regularmente los ligueros</li> <li>Guardar en plano para conservar la forma</li> </ul>
description
string<p>Descubre <strong>Raquel</strong>, una gu&ecirc;pi&egrave;re que no es sólo una prenda, sino una auténtica joyita de seducción. Cada detalle ha sido diseñado para celebrar y realzar tus curvas con absoluta elegancia. El <strong>punto elástico</strong> abraza tu figura como una segunda piel, creando una curva perfecta que realza tus curvas naturales. Este tejido técnico ofrece una sujeción óptima a la vez que garantiza un notable confort con cada movimiento.</p> <p>El <strong>lujoso satén</strong> añade una dimensión de refinada sofisticación.</p> <p>Su textura suave y brillante acaricia su piel, creando un efecto visual impactante. Cada reflejo del satén se convierte en una invitación a la seducción, transformando su silueta en una obra de arte viviente. El corte está especialmente diseñado para <strong>realzar su busto</strong>. Esculpe y sujeta sus curvas con una precisión que marca la diferencia. Cada detalle está pensado para crear una línea elegante y sensual que atraiga todas las miradas. Los <strong>ligueros ajustables</strong> le permiten personalizar su ajuste con precisión milimétrica. Puede ajustar la tensión exactamente como lo desee, garantizando una comodidad óptima y un estilo impecable. El <strong>tanga a juego</strong> complementa el liguero. Amplía el diseño y la sofisticación de la pieza principal, creando un conjunto que destila sensualidad y coherencia.</p> <p>Disponible en <strong>talla grande</strong>, <strong>Raquel</strong> celebra todos los tipos de cuerpo. Demuestra que la seducción no tiene límites y que la belleza se encuentra en la confianza en uno mismo y en la aceptación de uno mismo.</p>
guid
stringhttps://dev.divasboudoir.com/es/bustier-raquel-talla-grande-negro-ou-gris/sbbu0754.htm
highlights
string<ul> <li><strong>La malla elástica y el lujoso satén</strong> moldean tus curvas</li> <li>Corte sofisticado<strong>que realza el pecho</strong> </li> <li><strong>Ligas ajustables</strong> para una sujeción personalizada</li> <li><strong>Tanga a juego</strong> para un conjunto armonioso</li> <li><strong>Materiales de alta calidad</strong> para un confort óptimo</li> <li><strong>Diseño que realza las curvas</strong></li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringLiguero Raquel talla grande: malla elástica y lujoso satén, tirantes ajustables, tanga a juego. Moldeado y sensual. Diva's Boudoir.
keywords
string
title
stringGuêpière Raquel talla grande | Diva's Boudoir
seotitle
stringRaquel talla grande tirante malla elástica satén
seouri
stringbustier-raquel-talla-grande-negro-ou-gris
specifications
string<ul> <li><strong>Nombre</strong>: Raquel</li> <li><strong>Composición</strong>: Bustier + tanga a juego</li> <li><strong>Material</strong>: Malla elástica y lujoso satén</li> <li><strong>Detalles</strong>: Ligueros ajustables</li> <li><strong>Corte</strong>: Moldeado, realza el pecho</li> <li><strong>Estilo</strong>: Elegante y sensual</li> </ul>
stylingtips
string
summary
string<p>Descubre <strong>Raquel</strong>, una pequeña joya de gu&ecirc;pi&egrave;re que moldeará tus curvas con elegancia. Confeccionado <strong>en malla elástica y lujoso satén</strong>, realza el busto de forma sublime.</p> <p>Con sus <strong>ligueros ajustables</strong> y su <strong>tanga a juego</strong>, este liguero es una auténtica baza de seducción.</p>
title
stringRaquel Bustier - Malla elástica y lujoso satén
usageinstructions
string
fr
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavage d&eacute;licat &agrave; la main &agrave; l'eau froide</li> <li>Utilisez un d&eacute;tergent doux sp&eacute;cial lingerie fine</li> <li>Ne pas tordre ni essorer</li> <li>&Eacute;vitez l'exposition directe au soleil</li> <li>S&eacute;chage &agrave; plat</li> <li>Manipulez avec pr&eacute;caution le satin et la maille &eacute;lastique</li> <li>V&eacute;rifiez r&eacute;guli&egrave;rement les jarreti&egrave;res</li> <li>Rangez &agrave; plat pour pr&eacute;server la forme</li> </ul>
description
string<p>D&eacute;couvrez <strong>Raquel</strong>, une gu&ecirc;pi&egrave;re qui n'est pas qu'un simple v&ecirc;tement, mais un v&eacute;ritable petit bijou de s&eacute;duction. Chaque d&eacute;tail a &eacute;t&eacute; pens&eacute; pour c&eacute;l&eacute;brer et sublimer vos courbes avec une &eacute;l&eacute;gance absolue. La <strong>maille &eacute;lastique</strong> &eacute;pouse votre silhouette comme une seconde peau, cr&eacute;ant un galbage parfait qui met en valeur vos rondeurs naturelles. Cette mati&egrave;re technique offre un maintien optimal tout en garantissant un confort remarquable &agrave; chaque mouvement.</p> <p>Le&nbsp;<strong>satin luxueux</strong> ajoute une dimension de sophistication raffin&eacute;e.</p> <p>Sa texture lisse et brillante caresse votre peau, cr&eacute;ant un effet visuel saisissant. Chaque reflet du satin devient une invitation &agrave; la s&eacute;duction, transformant votre silhouette en &oelig;uvre d'art vivante. La coupe est particuli&egrave;rement &eacute;tudi&eacute;e pour&nbsp;<strong>mettre votre poitrine en valeur</strong>. Elle sculpte et soutient vos courbes avec une pr&eacute;cision qui fait toute la diff&eacute;rence. Chaque d&eacute;tail est pens&eacute; pour cr&eacute;er une ligne &eacute;l&eacute;gante et sensuelle qui attire le regard. Les <strong>jarreti&egrave;res r&eacute;glables</strong> vous permettent de personnaliser votre maintien avec une pr&eacute;cision millim&eacute;trique. Vous pourrez ajuster la tension exactement comme vous le souhaitez, garantissant un confort optimal et un style impeccable. Le <strong>string assorti</strong> compl&egrave;te harmonieusement la gu&ecirc;pi&egrave;re. Il prolonge le design et la sophistication de la pi&egrave;ce principale, cr&eacute;ant un ensemble qui respire la sensualit&eacute; et la coh&eacute;rence.</p> <p>Disponible en&nbsp;<strong>grande taille</strong>, <strong>Raquel</strong> c&eacute;l&egrave;bre toutes les morphologies. Elle prouve que la s&eacute;duction n'a pas de limite, que la beaut&eacute; se trouve dans la confiance et l'acceptation de soi.</p>
guid
stringhttps://dev.divasboudoir.com/fr/guepiere-grande-taille-raquel-noir-ou-gris/sbbu0754.htm
highlights
string<ul> <li><strong>Maille &eacute;lastique et satin luxueux</strong> qui galbe vos courbes</li> <li><strong>Mise en valeur de la poitrine</strong> avec une coupe sophistiqu&eacute;e</li> <li><strong>Jarreti&egrave;res r&eacute;glables</strong> pour un maintien personnalis&eacute;</li> <li><strong>String assorti</strong> pour un ensemble harmonieux</li> <li><strong>Mati&egrave;res de haute qualit&eacute;</strong> pour un confort optimal</li> <li><strong>Design qui sublime les rondeurs</strong></li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringGuêpière Raquel grande taille : maille élastique et satin luxueux, jarretelles réglables, string assorti. Galbante et sensuelle. Diva's Boudoir.
keywords
string
title
stringGuêpière Raquel Grande Taille | Diva's Boudoir
seotitle
stringGuêpière Raquel Grande Taille Maille Élastique Satin
seouri
stringguepiere-grande-taille-raquel-noir-ou-gris
specifications
string<ul> <li><strong>Nom</strong> : Raquel</li> <li><strong>Composition</strong> : Gu&ecirc;pi&egrave;re + string assorti</li> <li><strong>Mati&egrave;re</strong> : Maille &eacute;lastique et satin luxueux</li> <li><strong>D&eacute;tails</strong> : Jarreti&egrave;res r&eacute;glables</li> <li><strong>Coupe</strong> : Galbante, mise en valeur de la poitrine</li> <li><strong>Style</strong> : &Eacute;l&eacute;gant et sensuel</li> </ul>
stylingtips
string
summary
string<p>D&eacute;couvrez <strong>Raquel</strong>, un petit bijou de gu&ecirc;pi&egrave;re qui galbera vos rondeurs avec &eacute;l&eacute;gance. Confectionn&eacute;e en <strong>maille &eacute;lastique et satin luxueux</strong>, elle met sublimement votre poitrine en valeur.</p> <p>Avec ses&nbsp;<strong>jarreti&egrave;res r&eacute;glables</strong> et son <strong>string assorti</strong>, cette gu&ecirc;pi&egrave;re est un v&eacute;ritable atout s&eacute;duction.</p>
title
stringGuêpière Raquel - Maille Élastique et Satin Luxueux
usageinstructions
string
it
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavaggio delicato a mano in acqua fredda</li> <li>Utilizzare un detersivo delicato per la lingerie fine</li> <li>Non strizzare o centrifugare</li> <li>evitare la luce diretta del sole</li> <li>Asciugare in piano</li> <li>Maneggiare con cura la maglieria di raso ed elastica</li> <li>Controllare regolarmente le giarrettiere</li> <li>Conservare in piano per preservare la forma</li> </ul>
description
string<p>Scoprite <strong>Raquel</strong>, una gu&ecirc;pi&egrave;re che non &egrave; solo un capo d'abbigliamento, ma un vero e proprio piccolo gioiello di seduzione. Ogni dettaglio è stato studiato per celebrare ed esaltare le vostre curve con assoluta eleganza. La <strong>maglia elasticizzata</strong> abbraccia la figura come una seconda pelle, creando una curva perfetta che esalta le vostre curve naturali. Questo tessuto tecnico offre un sostegno ottimale e garantisce un notevole comfort a ogni movimento.</p> <p>Il <strong>lussuoso raso</strong> aggiunge una dimensione di raffinata eleganza.</p> <p>La sua texture liscia e lucida accarezza la pelle, creando un effetto visivo di grande impatto. Ogni riflesso del raso diventa un invito alla seduzione, trasformando la silhouette in un'opera d'arte vivente. Il taglio è stato appositamente studiato per <strong>valorizzare il seno</strong>. Scolpisce e sostiene le vostre curve con una precisione che fa la differenza. Ogni dettaglio è studiato per creare una linea elegante e sensuale che cattura lo sguardo. Il <strong>reggicalze regolabile</strong> consente di personalizzare la vestibilità con precisione millimetrica. Potete regolare la tensione esattamente come volete, garantendovi un comfort ottimale e uno stile impeccabile. Il <strong>perizoma coordinato</strong> completa la giarrettiera. Estende il design e la raffinatezza del pezzo principale, creando un insieme che emana sensualità e coerenza.</p> <p>Disponibile in <strong>taglia grande</strong>, <strong>Raquel</strong> celebra tutti i tipi di corpo. Dimostra che la seduzione non ha limiti e che la bellezza si trova nella fiducia e nell'accettazione di sé.</p>
guid
stringhttps://dev.divasboudoir.com/it/bustier-raquel-taglia-grande-nero-ou-grigio/sbbu0754.htm
highlights
string<ul> <li>La<strong>rete elastica e il lussuoso raso</strong> modellano le vostre curve</li> <li>Il taglio sofisticato<strong>esalta il seno</strong> </li> <li><strong>Giarrettiere regolabili</strong> per un sostegno personalizzato</li> <li><strong>Perizoma abbinato</strong> per un insieme armonioso</li> <li><strong>Materiali di alta qualità</strong> per un comfort ottimale</li> <li><strong>Design che esalta le curve</strong></li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringReggicalze Raquel taglia grande: rete elastica e raso di lusso, bretelle regolabili, perizoma coordinato. Formoso e sensuale. Diva's Boudoir.
keywords
string
title
stringGuêpière Raquel Taglia Grande | Diva's Boudoir
seotitle
stringRaquel Bretella di taglia grande Elastico a rete in raso
seouri
stringbustier-raquel-taglia-grande-nero-ou-grigio
specifications
string<ul> <li><strong>Nome</strong>: Raquel</li> <li><strong>Composizione</strong>: Bustier + perizoma coordinato</li> <li><strong>Materiale</strong>: Rete elastica e raso di lusso</li> <li><strong>Dettagli</strong>: giarrettiere regolabili</li> <li><strong>Taglio</strong>: Formoso, che valorizza il petto</li> <li><strong>Stile</strong>: Elegante e sensuale</li> </ul>
stylingtips
string
summary
string<p>Scoprite <strong>Raquel</strong>, un piccolo gioiello di gu&ecirc;pi&egrave;re che modellerà le vostre curve con eleganza. Realizzata in <strong>rete elastica e raso di lusso</strong>, mette in mostra il vostro seno con un effetto sublime.</p> <p>Con le sue <strong>giarrettiere regolabili</strong> e il <strong>perizoma abbinato</strong>, questa giarrettiera è una vera risorsa di seduzione.</p>
title
stringBustier Raquel - Rete elastica e raso di lusso
usageinstructions
string
nl
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Fijne handwas in koud water</li> <li>Gebruik een mild wasmiddel voor fijne lingerie</li> <li>Niet wringen of centrifugeren</li> <li>vermijd direct zonlicht</li> <li>Plat drogen</li> <li>Ga voorzichtig om met satijn en elastisch breiwerk</li> <li>Controleer kousenbanden regelmatig</li> <li>Plat opbergen om vorm te behouden</li> </ul>
description
string<p>Ontdek <strong>Raquel</strong>, een gu&ecirc;pi&egrave;re die niet zomaar een kledingstuk is, maar een echt juweeltje van verleiding. Elk detail is ontworpen om je rondingen te vieren en te verbeteren met absolute elegantie. Het <strong>stretch breisel</strong> omhelst je figuur als een tweede huid en cre&euml;ert een perfecte ronding die je natuurlijke rondingen benadrukt. Deze technische stof biedt optimale ondersteuning en garandeert opmerkelijk comfort bij elke beweging.</p> <p>Het <strong>luxueuze satijn</strong> voegt een dimensie van verfijning toe.</p> <p>De gladde, glanzende textuur streelt je huid en cre&euml;ert een opvallend visueel effect. Elke reflectie van het satijn wordt een uitnodiging tot verleiding en verandert je silhouet in een levend kunstwerk. De snit is speciaal ontworpen om <strong>je buste te verbeteren</strong>. Het modelleert en ondersteunt je rondingen met een precisie die het verschil maakt. Elk detail is ontworpen om een elegante, sensuele lijn te cre&euml;ren die in het oog springt. Met de <strong>verstelbare kousenbanden</strong> kun je je pasvorm tot op de millimeter nauwkeurig aanpassen. Je kunt de spanning precies instellen zoals jij dat wilt, voor optimaal comfort en een onberispelijke stijl. De <strong>bijpassende string</strong> is een aanvulling op de kousenband. Hij breidt het ontwerp en de verfijning van het hoofdstuk uit en cre&euml;ert een ensemble dat sensualiteit en consistentie uitstraalt.</p> <p><strong>Raquel</strong> is verkrijgbaar in <strong>grote maten</strong> en viert alle lichaamstypes. Ze bewijst dat verleiding geen grenzen kent en dat schoonheid te vinden is in zelfvertrouwen en zelfacceptatie.</p>
guid
stringhttps://dev.divasboudoir.com/nl/raquel-grote-maat-bustier-zwart-ou-grijs/sbbu0754.htm
highlights
string<ul> <li><strong>Elastisch mesh en luxueus satijn</strong> vormen je rondingen</li> <li>Geraffineerde snit<strong>verbetert de boezem</strong></li> <li><strong>Verstelbare kousenbanden</strong> voor persoonlijke ondersteuning</li> <li><strong>Bijpassende string</strong> voor een harmonieus geheel</li> <li><strong>Hoogwaardige materialen</strong> voor optimaal comfort</li> <li><strong>Ontwerp dat rondingen verbetert</strong></li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringRaquel grote maat jarretelgordel: stretch mesh en luxe satijn, verstelbare jarretels, bijpassende string. Welgevormd en sensueel. Diva's Boudoir.
keywords
string
title
stringGuêpière Raquel Grote Maat | Diva's Boudoir
seotitle
stringRaquel Grote Maat Jarretel Elastisch Mesh Satijn
seouri
stringraquel-grote-maat-bustier-zwart-ou-grijs
specifications
string<ul> <li><strong>Naam</strong>: Raquel</li> <li><strong>Samenstelling</strong>: Bustier + bijpassende string</li> <li><strong>Materiaal</strong>: Elastisch gaas en luxe satijn</li> <li><strong>Details</strong>: Verstelbare kousenbanden</li> <li><strong>Snit</strong>: Welgevormd, borstvergrotend</li> <li><strong>Stijl</strong>: Elegant en sensueel</li> </ul>
stylingtips
string
summary
string<p>Ontdek <strong>Raquel</strong>, een juweeltje van een gu&ecirc;pi&egrave;re die je rondingen elegant vormgeeft. Ze is gemaakt van <strong>elastisch netweefsel en luxueus satijn</strong> en laat je buste subliem uitkomen.</p> <p>Met zijn <strong>verstelbare kousenband</strong> en <strong>bijpassende string</strong> is deze gu&ecirc;pi&egrave;re een echte verleidingstroef.</p>
title
stringRaquel Bustier - Elastische mesh en luxueus satijn
usageinstructions
string
pt
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavagem delicada à mão em água fria</li> <li>Utilizar um detergente suave para lingerie fina</li> <li>Não torcer nem centrifugar</li> <li>evitar a luz solar direta</li> <li>Secar na horizontal</li> <li>Manusear com cuidado as malhas de cetim e elásticas</li> <li>Verificar regularmente as ligas</li> <li>Guardar em local plano para preservar a forma</li> </ul>
description
string<p>Descubra <strong>Raquel</strong>, uma gu&ecirc;pi&egrave;re que não é apenas uma peça de vestuário, mas uma verdadeira joia de sedução. Cada detalhe foi concebido para celebrar e realçar as suas curvas com uma elegância absoluta. A <strong>malha elástica</strong> abraça a sua figura como uma segunda pele, criando uma curva perfeita que realça as suas curvas naturais. Este tecido técnico oferece um apoio ótimo, garantindo um conforto notável em cada movimento.</p> <p>O <strong>cetim luxuoso</strong> acrescenta uma dimensão de sofisticação refinada.</p> <p>A sua textura suave e brilhante acaricia a sua pele, criando um efeito visual impressionante. Cada reflexo do cetim torna-se um convite à sedução, transformando a sua silhueta numa obra de arte viva. O corte foi especialmente concebido para <strong>realçar o seu busto</strong>. Esculpe e sustenta as suas curvas com uma precisão que faz toda a diferença. Cada pormenor foi concebido para criar uma linha elegante e sensual que chama a atenção. As <strong>ligas ajustáveis</strong> permitem-lhe personalizar o seu ajuste com uma precisão milimétrica. Pode ajustar a tensão exatamente da forma que desejar, garantindo um conforto ótimo e um estilo impecável. A <strong>tanga a condizer</strong> complementa a liga. Prolonga o design e a sofisticação da peça principal, criando um conjunto que exala sensualidade e consistência.</p> <p>Disponível em <strong>tamanhos grandes</strong>, <strong>Raquel</strong> celebra todos os tipos de corpo. Ela prova que a sedução não tem limites e que a beleza se encontra na auto-confiança e na auto-aceitação.</p>
guid
stringhttps://dev.divasboudoir.com/pt/corpete-de-tamanho-grande-raquel-preto-ou-cinzento/sbbu0754.htm
highlights
string<ul> <li><strong>A malha elástica e o cetim luxuoso</strong> modelam as suas curvas</li> <li>O corte sofisticado<strong>realça o peito</strong> </li> <li><strong>Ligas ajustáveis</strong> para um apoio personalizado</li> <li><strong>Tanga a condizer</strong> para um conjunto harmonioso</li> <li><strong>Materiais de alta qualidade</strong> para um conforto ótimo</li> <li><strong>Design que realça as curvas</strong></li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringCinto suspensório Raquel plus size: malha elástica e cetim luxuoso, suspensórios ajustáveis, tanga a condizer. Formoso e sensual. Diva's Boudoir.
keywords
string
title
stringGuêpière Raquel Grande Taille | Diva's Boudoir
seotitle
stringRaquel Suspensório tamanho grande Malha elástica Cetim
seouri
stringcorpete-de-tamanho-grande-raquel-preto-ou-cinzento
specifications
string<ul> <li><strong>Nome</strong>: Raquel</li> <li><strong>Composição</strong>: Corpete + tanga a condizer</li> <li><strong>Material</strong>: Malha elástica e cetim luxuoso</li> <li><strong>Detalhes</strong>: Ligas ajustáveis</li> <li><strong>Corte</strong>: Formoso, realça o peito</li> <li><strong>Estilo</strong>: Elegante e sensual</li> </ul>
stylingtips
string
summary
string<p>Descubra <strong>Raquel</strong>, uma pequena joia de gu&ecirc;pi&egrave;re que irá moldar as suas curvas com elegância. Feita de <strong>malha elástica e cetim luxuoso</strong>, exibe o seu busto com um efeito sublime.</p> <p>Com as suas <strong>ligas ajustáveis</strong> e <strong>a tanga a condizer</strong>, esta liga é um verdadeiro trunfo de sedução.</p>
title
stringRaquel Bustier - Malha elástica e cetim luxuoso
usageinstructions
string
fetishboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz-ou-grau
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro-ou-gkri
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black-ou-grey
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro-ou-gris
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-ou-gris
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero-ou-grigio
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart-ou-grijs
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto-ou-cinzento
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
latexboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz-ou-grau
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro-ou-gkri
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black-ou-grey
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro-ou-gris
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-ou-gris
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero-ou-grigio
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart-ou-grijs
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto-ou-cinzento
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
legsboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz-ou-grau
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro-ou-gkri
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black-ou-grey
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro-ou-gris
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-ou-gris
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero-ou-grigio
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart-ou-grijs
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto-ou-cinzento
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
lustboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz-ou-grau
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro-ou-gkri
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black-ou-grey
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro-ou-gris
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-ou-gris
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero-ou-grigio
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart-ou-grijs
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto-ou-cinzento
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
smboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz-ou-grau
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro-ou-gkri
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black-ou-grey
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro-ou-gris
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-ou-gris
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero-ou-grigio
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart-ou-grijs
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto-ou-cinzento
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
name
stringHD04406A-
netweight
string
nextshipment
stringtoday
ordered
number4
orderidx
number0
origin
string
originalsize
string
packaging
number0
productshipment
string4to6days
productuid
stringB698842E-0918-45A5-B403B27B1D5D4460
promountil
string
rating
stringnone
recorduid
stringB698842E-0918-45A5-B403B27B1D5D4460
reference
stringSBBU0754
related
string
reserved
number0
returned
number0
returnsallowed
number1
section
stringlingerie
shipment
string4to6days
showbrand
number0
sizeinfos
Query
Template: /system/api/product/sizes.cfc:20
Execution Time: 1.41 ms
Record Count: 5
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_sizes.id_size as recorduid, if(intlsize <> '',intlsize,eusize) as size, if(intlsize <> '','intlsize','eusize') as sizetype,
product_variations.color,
if(product_sizes.sizegroup = 'bra',
if(intlsize <> '', cast(intlsize as SIGNED ), cast(eusize as SIGNED ))
,
SUBSTRING_INDEX(intlsize,'-',1)
) as param1,
if(product_sizes.sizegroup = 'bra',
if(intlsize <> '',
MID(intlsize,length(cast(intlsize as SIGNED ))+1,length(intlsize)),
MID(eusize,length(cast(eusize as SIGNED ))+1,length(eusize))
)
,
SUBSTRING_INDEX(intlsize,'-',-1)
) as param2,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as available,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
999999,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as groupavailable,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
product_sizes.gender, product_sizes.sizerange, product_sizes.sizegroup, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize,
product_sizes.bust, product_sizes.waist, product_sizes.hip, product_sizes.underbust, product_sizes.cup, product_sizes.thigh, product_sizes.legheight, product_sizes.bodyheight, product_sizes.bodyweight
from product_sizes
left outer join product_variations on product_sizes.suppliersize = product_variations.size and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
where FIND_IN_SET(product_sizes.id_size,'2069,2074,2067,2073,2075') > 0
and product_variations.productuid = 'B698842E-0918-45A5-B403B27B1D5D4460'
and intlsize <> 'na'
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_sizes.id_size, product_variations.color
order by FIELD(product_sizes.gender,'w','m'), product_sizes.sizegroup, FIELD(intlsize,'XS','S','S/M','S-M','M','M/L','M-L','L','L-XL','L/XL','XL','0X','0XL','lXL','1X','1X-2X','1X/2X','XL/2XL','XL-2XL','1XL-2XL','2XL','2X','XXL','2X-3X','2X/3X','2XL-3XL','2XL/3XL','XXXL','3XL','3X','3X-4X','3X/4X','3XL-4XL','3XL/4XL','4XL','5XL','5X','5X-6X','5X/6X','5XL-6XL','5XL/6XL','6XL','6X','7XL','7X','8XL','8X'), cast(intlsize as SIGNED ), groupavailable desc, stock desc
recorduidsizesizetypecolorparam1param2availablegroupavailablestockgendersizerangesizegroupsuppliersizeintlsizeincheseusizeussizeuksizefrsizeessizedesizeitsizeptsizeelsizebustwaisthipunderbustcupthighlegheightbodyheightbodyweight
120741X/2X-intlsizeblack1X/2X-19999990wpluslingerie1X/2X1X/2X-42-4412-1416-1844-4644-4642-4446-4844-4642-44104-11086-91112-120
220753X/4X+intlsizeblack3X/4X+3X/4X+-19999990wpluslingerie3X/4X3X/4X+50-5220-2224-2852-5452-5450-5256-5852-5450-52128-132102-108132-138
32069XLintlsizeblackXLXL-19999990wpluslingerieXLXL40-4210-1214-1642-4442-4440-4246-4842-4440-4299-10481-86107-112
420671X/2Xintlsizeblack1X/2X1X/2X-19999990wpluslingerie1X/2X1X/2X46-4816-1820-2248-5048-5046-4852-5448-5046-48112-11892-96122-128
520733X/4Xintlsizeblack3X/4X3X/4X-19999990wpluslingerie3X/4X3X/4X48-5018-2022-2450-5250-5248-5054-5650-5248-50120-12898-102128-132
sizeranges
stringplus
sizes
string2069,2074,2067,2073,2075
sizetype
stringauto
specifications
Struct
Entries: 23
belly
string
bones
string
bra
string
breasts
string
bust
string
closing
string
crochtless
string
cups
string
cut
string
garter
string
halter
string
lacing
string
lining
string
modestypanel
string
panty
string
sheathing
string
sleeves
string
stocking
string
straps
string
stretch
string
suspenders
string
transparency
string
underwires
string
stock
number0
stocks
Query
Template: /system/api/product/stocks.cfc:25
Execution Time: 36.1 ms
Record Count: 3
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select * from (
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = 'B698842E-0918-45A5-B403B27B1D5D4460'
and product_variations.isactive = 1
and product_sizes.id_size = 2069
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = 'B698842E-0918-45A5-B403B27B1D5D4460'
and product_variations.isactive = 1
and product_sizes.id_size = 2074
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = 'B698842E-0918-45A5-B403B27B1D5D4460'
and product_variations.isactive = 1
and product_sizes.id_size = 2067
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = 'B698842E-0918-45A5-B403B27B1D5D4460'
and product_variations.isactive = 1
and product_sizes.id_size = 2073
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = 'B698842E-0918-45A5-B403B27B1D5D4460'
and product_variations.isactive = 1
and product_sizes.id_size = 2075
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
) tbl
group by productuid, variationuid, stockuid
order by stockuid, FIELD(gender,'w','m'), sizegroup, FIELD(intlsize,'XS','S','S/M','S-M','M','M/L','M-L','L','L-XL','L/XL','XL','0X','0XL','lXL','1X','1X-2X','1X/2X','XL/2XL','XL-2XL','1XL-2XL','2XL','2X','XXL','2X-3X','2X/3X','2XL-3XL','2XL/3XL','XXXL','3XL','3X','3X-4X','3X/4X','3XL-4XL','3XL/4XL','4XL','5XL','5X','5X-6X','5X/6X','5XL-6XL','5XL/6XL','6XL','6X','7XL','7X','8XL','8X'), cast(intlsize as SIGNED ), color
productuidvariationuidrecorduidcolorhexvaluesuppliersizeintlsizeincheseusizeussizeuksizefrsizeessizedesizeitsizeptsizeelsizegendersizegroupcupsizesizetypeitempriceitempromopromoUntilstockuidwarehouseontourpackagingsupplierreservedorderedreturneddefectmanufacturerreferenceeanavailablestockdisplaycomments
1B698842E-0918-45A5-B403B27B1D5D44602E583E29-12D9-4DCA-BA916AAD0D29BF222074black#0000001X/2X1X/2X-42-4412-1416-1844-4644-4642-4446-4844-4642-44wlingerie1X/2X-intlsize66.62533.2917{ts '2025-10-05 15:00:00'}STOCK01000-10100HD04406A-BLAK840312877330-10all
2B698842E-0918-45A5-B403B27B1D5D4460C5174BBE-95AA-466B-9DDE80DF766561F32069black#000000XLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42wlingerieXLintlsize66.62533.2917{ts '2025-10-05 15:00:00'}STOCK01000-10000HD04406A-BLAK-10all
3B698842E-0918-45A5-B403B27B1D5D4460086E1091-3396-48E7-8CE5CE441A8AC5DA2073black#0000003X/4X3X/4X48-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie3X/4Xintlsize66.62533.2917{ts '2025-10-05 15:00:00'}STOCK01000-10300HD04406A-BLAK840312877347-10all
subcategory
stringbustier
supplier
number-1
supplierreference
stringHD04406A
tags
string
themes
stringplum
totalvariations
number6
type
stringdefault
unitprice
number66.625
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 24.6 ms
Record Count: 5
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = 'B698842E-0918-45A5-B403B27B1D5D4460' and b.size = product_variations.size and b.supplier < 0) > 0,
-1,
(select
sum(distinct if(b.supplier >= 0,b.supplier,0)) +
if((sum(bb.warehouse)+sum(bb.packaging)-sum(bb.reserved))>=0,sum(bb.warehouse)+sum(bb.packaging)-sum(bb.reserved),0)
from product_variations b left outer join product_stocks bb on bb.productuid = b.productuid and bb.variationuid = b.variationuid and bb.stockuid = 'STOCK01'
where b.isactive = 1 and b.productuid = 'B698842E-0918-45A5-B403B27B1D5D4460' and b.size = product_variations.size)
)) as availablepersize,
(
select if((sum(cc.warehouse)+sum(cc.packaging)-sum(cc.reserved))>=0,sum(cc.warehouse)+sum(cc.packaging)-sum(cc.reserved),0)
from product_variations c left outer join product_stocks cc on cc.productuid = c.productuid and cc.variationuid = c.variationuid and cc.stockuid = 'STOCK01'
where c.isactive = 1 and c.productuid = 'B698842E-0918-45A5-B403B27B1D5D4460' and c.size = product_variations.size
) as stockpersize,
(if(
(select count(distinct d.variationuid) from product_variations d where d.isactive = 1 and d.productuid = 'B698842E-0918-45A5-B403B27B1D5D4460' and d.color = product_variations.color and d.supplier < 0) > 0,
-1,
(select sum(distinct if(d.supplier >= 0,d.supplier,0)) +
if((sum(dd.warehouse)+sum(dd.packaging)-sum(dd.reserved))>=0,sum(dd.warehouse)+sum(dd.packaging)-sum(dd.reserved),0)
from product_variations d left outer join product_stocks dd on dd.productuid = d.productuid and dd.variationuid = d.variationuid and dd.stockuid = 'STOCK01'
where d.isactive = 1 and d.productuid = 'B698842E-0918-45A5-B403B27B1D5D4460' and d.color = product_variations.color)
)) as availablepercolor,
(
select if((sum(ee.warehouse)+sum(ee.packaging)-sum(ee.reserved))>=0,sum(ee.warehouse)+sum(ee.packaging)-sum(ee.reserved),0)
from product_variations e left outer join product_stocks ee on ee.productuid = e.productuid and ee.variationuid = e.variationuid and ee.stockuid = 'STOCK01'
where e.isactive = 1 and e.productuid = 'B698842E-0918-45A5-B403B27B1D5D4460' and e.color = product_variations.color
) as stockpercolor,
if((product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null)),1,0) as haspromo,
if((product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null)),product_variations.itempromo,product_variations.itemprice) as unitprice,
'all' as display,
product_variations.comments
from product_variations
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_variations.productuid = 'B698842E-0918-45A5-B403B27B1D5D4460'
and product_variations.isactive = 1
and product_sizes.id_size = 2069
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = 'B698842E-0918-45A5-B403B27B1D5D4460' and b.size = product_variations.size and b.supplier < 0) > 0,
-1,
(select
sum(distinct if(b.supplier >= 0,b.supplier,0)) +
if((sum(bb.warehouse)+sum(bb.packaging)-sum(bb.reserved))>=0,sum(bb.warehouse)+sum(bb.packaging)-sum(bb.reserved),0)
from product_variations b left outer join product_stocks bb on bb.productuid = b.productuid and bb.variationuid = b.variationuid and bb.stockuid = 'STOCK01'
where b.isactive = 1 and b.productuid = 'B698842E-0918-45A5-B403B27B1D5D4460' and b.size = product_variations.size)
)) as availablepersize,
(
select if((sum(cc.warehouse)+sum(cc.packaging)-sum(cc.reserved))>=0,sum(cc.warehouse)+sum(cc.packaging)-sum(cc.reserved),0)
from product_variations c left outer join product_stocks cc on cc.productuid = c.productuid and cc.variationuid = c.variationuid and cc.stockuid = 'STOCK01'
where c.isactive = 1 and c.productuid = 'B698842E-0918-45A5-B403B27B1D5D4460' and c.size = product_variations.size
) as stockpersize,
(if(
(select count(distinct d.variationuid) from product_variations d where d.isactive = 1 and d.productuid = 'B698842E-0918-45A5-B403B27B1D5D4460' and d.color = product_variations.color and d.supplier < 0) > 0,
-1,
(select sum(distinct if(d.supplier >= 0,d.supplier,0)) +
if((sum(dd.warehouse)+sum(dd.packaging)-sum(dd.reserved))>=0,sum(dd.warehouse)+sum(dd.packaging)-sum(dd.reserved),0)
from product_variations d left outer join product_stocks dd on dd.productuid = d.productuid and dd.variationuid = d.variationuid and dd.stockuid = 'STOCK01'
where d.isactive = 1 and d.productuid = 'B698842E-0918-45A5-B403B27B1D5D4460' and d.color = product_variations.color)
)) as availablepercolor,
(
select if((sum(ee.warehouse)+sum(ee.packaging)-sum(ee.reserved))>=0,sum(ee.warehouse)+sum(ee.packaging)-sum(ee.reserved),0)
from product_variations e left outer join product_stocks ee on ee.productuid = e.productuid and ee.variationuid = e.variationuid and ee.stockuid = 'STOCK01'
where e.isactive = 1 and e.productuid = 'B698842E-0918-45A5-B403B27B1D5D4460' and e.color = product_variations.color
) as stockpercolor,
if((product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null)),1,0) as haspromo,
if((product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null)),product_variations.itempromo,product_variations.itemprice) as unitprice,
'all' as display,
product_variations.comments
from product_variations
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_variations.productuid = 'B698842E-0918-45A5-B403B27B1D5D4460'
and product_variations.isactive = 1
and product_sizes.id_size = 2074
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = 'B698842E-0918-45A5-B403B27B1D5D4460' and b.size = product_variations.size and b.supplier < 0) > 0,
-1,
(select
sum(distinct if(b.supplier >= 0,b.supplier,0)) +
if((sum(bb.warehouse)+sum(bb.packaging)-sum(bb.reserved))>=0,sum(bb.warehouse)+sum(bb.packaging)-sum(bb.reserved),0)
from product_variations b left outer join product_stocks bb on bb.productuid = b.productuid and bb.variationuid = b.variationuid and bb.stockuid = 'STOCK01'
where b.isactive = 1 and b.productuid = 'B698842E-0918-45A5-B403B27B1D5D4460' and b.size = product_variations.size)
)) as availablepersize,
(
select if((sum(cc.warehouse)+sum(cc.packaging)-sum(cc.reserved))>=0,sum(cc.warehouse)+sum(cc.packaging)-sum(cc.reserved),0)
from product_variations c left outer join product_stocks cc on cc.productuid = c.productuid and cc.variationuid = c.variationuid and cc.stockuid = 'STOCK01'
where c.isactive = 1 and c.productuid = 'B698842E-0918-45A5-B403B27B1D5D4460' and c.size = product_variations.size
) as stockpersize,
(if(
(select count(distinct d.variationuid) from product_variations d where d.isactive = 1 and d.productuid = 'B698842E-0918-45A5-B403B27B1D5D4460' and d.color = product_variations.color and d.supplier < 0) > 0,
-1,
(select sum(distinct if(d.supplier >= 0,d.supplier,0)) +
if((sum(dd.warehouse)+sum(dd.packaging)-sum(dd.reserved))>=0,sum(dd.warehouse)+sum(dd.packaging)-sum(dd.reserved),0)
from product_variations d left outer join product_stocks dd on dd.productuid = d.productuid and dd.variationuid = d.variationuid and dd.stockuid = 'STOCK01'
where d.isactive = 1 and d.productuid = 'B698842E-0918-45A5-B403B27B1D5D4460' and d.color = product_variations.color)
)) as availablepercolor,
(
select if((sum(ee.warehouse)+sum(ee.packaging)-sum(ee.reserved))>=0,sum(ee.warehouse)+sum(ee.packaging)-sum(ee.reserved),0)
from product_variations e left outer join product_stocks ee on ee.productuid = e.productuid and ee.variationuid = e.variationuid and ee.stockuid = 'STOCK01'
where e.isactive = 1 and e.productuid = 'B698842E-0918-45A5-B403B27B1D5D4460' and e.color = product_variations.color
) as stockpercolor,
if((product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null)),1,0) as haspromo,
if((product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null)),product_variations.itempromo,product_variations.itemprice) as unitprice,
'all' as display,
product_variations.comments
from product_variations
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_variations.productuid = 'B698842E-0918-45A5-B403B27B1D5D4460'
and product_variations.isactive = 1
and product_sizes.id_size = 2067
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = 'B698842E-0918-45A5-B403B27B1D5D4460' and b.size = product_variations.size and b.supplier < 0) > 0,
-1,
(select
sum(distinct if(b.supplier >= 0,b.supplier,0)) +
if((sum(bb.warehouse)+sum(bb.packaging)-sum(bb.reserved))>=0,sum(bb.warehouse)+sum(bb.packaging)-sum(bb.reserved),0)
from product_variations b left outer join product_stocks bb on bb.productuid = b.productuid and bb.variationuid = b.variationuid and bb.stockuid = 'STOCK01'
where b.isactive = 1 and b.productuid = 'B698842E-0918-45A5-B403B27B1D5D4460' and b.size = product_variations.size)
)) as availablepersize,
(
select if((sum(cc.warehouse)+sum(cc.packaging)-sum(cc.reserved))>=0,sum(cc.warehouse)+sum(cc.packaging)-sum(cc.reserved),0)
from product_variations c left outer join product_stocks cc on cc.productuid = c.productuid and cc.variationuid = c.variationuid and cc.stockuid = 'STOCK01'
where c.isactive = 1 and c.productuid = 'B698842E-0918-45A5-B403B27B1D5D4460' and c.size = product_variations.size
) as stockpersize,
(if(
(select count(distinct d.variationuid) from product_variations d where d.isactive = 1 and d.productuid = 'B698842E-0918-45A5-B403B27B1D5D4460' and d.color = product_variations.color and d.supplier < 0) > 0,
-1,
(select sum(distinct if(d.supplier >= 0,d.supplier,0)) +
if((sum(dd.warehouse)+sum(dd.packaging)-sum(dd.reserved))>=0,sum(dd.warehouse)+sum(dd.packaging)-sum(dd.reserved),0)
from product_variations d left outer join product_stocks dd on dd.productuid = d.productuid and dd.variationuid = d.variationuid and dd.stockuid = 'STOCK01'
where d.isactive = 1 and d.productuid = 'B698842E-0918-45A5-B403B27B1D5D4460' and d.color = product_variations.color)
)) as availablepercolor,
(
select if((sum(ee.warehouse)+sum(ee.packaging)-sum(ee.reserved))>=0,sum(ee.warehouse)+sum(ee.packaging)-sum(ee.reserved),0)
from product_variations e left outer join product_stocks ee on ee.productuid = e.productuid and ee.variationuid = e.variationuid and ee.stockuid = 'STOCK01'
where e.isactive = 1 and e.productuid = 'B698842E-0918-45A5-B403B27B1D5D4460' and e.color = product_variations.color
) as stockpercolor,
if((product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null)),1,0) as haspromo,
if((product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null)),product_variations.itempromo,product_variations.itemprice) as unitprice,
'all' as display,
product_variations.comments
from product_variations
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_variations.productuid = 'B698842E-0918-45A5-B403B27B1D5D4460'
and product_variations.isactive = 1
and product_sizes.id_size = 2073
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = 'B698842E-0918-45A5-B403B27B1D5D4460' and b.size = product_variations.size and b.supplier < 0) > 0,
-1,
(select
sum(distinct if(b.supplier >= 0,b.supplier,0)) +
if((sum(bb.warehouse)+sum(bb.packaging)-sum(bb.reserved))>=0,sum(bb.warehouse)+sum(bb.packaging)-sum(bb.reserved),0)
from product_variations b left outer join product_stocks bb on bb.productuid = b.productuid and bb.variationuid = b.variationuid and bb.stockuid = 'STOCK01'
where b.isactive = 1 and b.productuid = 'B698842E-0918-45A5-B403B27B1D5D4460' and b.size = product_variations.size)
)) as availablepersize,
(
select if((sum(cc.warehouse)+sum(cc.packaging)-sum(cc.reserved))>=0,sum(cc.warehouse)+sum(cc.packaging)-sum(cc.reserved),0)
from product_variations c left outer join product_stocks cc on cc.productuid = c.productuid and cc.variationuid = c.variationuid and cc.stockuid = 'STOCK01'
where c.isactive = 1 and c.productuid = 'B698842E-0918-45A5-B403B27B1D5D4460' and c.size = product_variations.size
) as stockpersize,
(if(
(select count(distinct d.variationuid) from product_variations d where d.isactive = 1 and d.productuid = 'B698842E-0918-45A5-B403B27B1D5D4460' and d.color = product_variations.color and d.supplier < 0) > 0,
-1,
(select sum(distinct if(d.supplier >= 0,d.supplier,0)) +
if((sum(dd.warehouse)+sum(dd.packaging)-sum(dd.reserved))>=0,sum(dd.warehouse)+sum(dd.packaging)-sum(dd.reserved),0)
from product_variations d left outer join product_stocks dd on dd.productuid = d.productuid and dd.variationuid = d.variationuid and dd.stockuid = 'STOCK01'
where d.isactive = 1 and d.productuid = 'B698842E-0918-45A5-B403B27B1D5D4460' and d.color = product_variations.color)
)) as availablepercolor,
(
select if((sum(ee.warehouse)+sum(ee.packaging)-sum(ee.reserved))>=0,sum(ee.warehouse)+sum(ee.packaging)-sum(ee.reserved),0)
from product_variations e left outer join product_stocks ee on ee.productuid = e.productuid and ee.variationuid = e.variationuid and ee.stockuid = 'STOCK01'
where e.isactive = 1 and e.productuid = 'B698842E-0918-45A5-B403B27B1D5D4460' and e.color = product_variations.color
) as stockpercolor,
if((product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null)),1,0) as haspromo,
if((product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null)),product_variations.itempromo,product_variations.itemprice) as unitprice,
'all' as display,
product_variations.comments
from product_variations
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_variations.productuid = 'B698842E-0918-45A5-B403B27B1D5D4460'
and product_variations.isactive = 1
and product_sizes.id_size = 2075
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
order by FIELD(gender,'w','m'), sizegroup, FIELD(intlsize,'XS','S','S/M','S-M','M','M/L','M-L','L','L-XL','L/XL','XL','0X','0XL','lXL','1X','1X-2X','1X/2X','XL/2XL','XL-2XL','1XL-2XL','2XL','2X','XXL','2X-3X','2X/3X','2XL-3XL','2XL/3XL','XXXL','3XL','3X','3X-4X','3X/4X','3XL-4XL','3XL/4XL','4XL','5XL','5X','5X-6X','5X/6X','5XL-6XL','5XL/6XL','6XL','6X','7XL','7X','8XL','8X'), cast(intlsize as SIGNED ), color
variationuidrecorduidcolorhexvaluesuppliersizeintlsizeincheseusizeussizeuksizefrsizeessizedesizeitsizeptsizeelsizegendersizegroupcupsizesizetypeitempriceitempromopromoUntilstockuidwarehouseontourpackagingsupplierreservedorderedreturneddefectmanufacturerreferenceeanavailablestockavailablepersizestockpersizeavailablepercolorstockpercolorhaspromounitpricedisplaycomments
12E583E29-12D9-4DCA-BA916AAD0D29BF222074black#0000001X/2X1X/2X-42-4412-1416-1844-4644-4642-4446-4844-4642-44wlingerie1X/2X-intlsize66.62533.2917{ts '2025-10-05 15:00:00'}STOCK01000-10100HD04406A-BLAK840312877330-10-10-10066.625all
2086E1091-3396-48E7-8CE5CE441A8AC5DA2075black#0000003X/4X3X/4X+50-5220-2224-2852-5452-5450-5256-5852-5450-52wlingerie3X/4X+intlsize66.62533.2917{ts '2025-10-05 15:00:00'}STOCK01000-10300HD04406A-BLAK840312877347-10-10-10066.625all
3C5174BBE-95AA-466B-9DDE80DF766561F32069black#000000XLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42wlingerieXLintlsize66.62533.2917{ts '2025-10-05 15:00:00'}STOCK01000-10000HD04406A-BLAK-10-10-10066.625all
42E583E29-12D9-4DCA-BA916AAD0D29BF222067black#0000001X/2X1X/2X46-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie1X/2Xintlsize66.62533.2917{ts '2025-10-05 15:00:00'}STOCK01000-10100HD04406A-BLAK840312877330-10-10-10066.625all
5086E1091-3396-48E7-8CE5CE441A8AC5DA2073black#0000003X/4X3X/4X48-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie3X/4Xintlsize66.62533.2917{ts '2025-10-05 15:00:00'}STOCK01000-10300HD04406A-BLAK840312877347-10-10-10066.625all
vatrate
number20
warehouse
number0