Mi cesta

❌
Total de artículos
Ver cesta
Menú
Maten bekijken
Adèle Gedrapeerde Jurk
Dubbelklikken om te vergroten
SKU: CDBU8229
Vestido drapeado Adèle
Voorraad:

Deze gedrapeerde jurk benadrukt royale rondingen met zijn romantische snit en uitzonderlijke stretchstof.

Het asymmetrische drapeereffect en de split opzij creëren een sensueel silhouet dat elk lichaamstype met natuurlijke elegantie benadrukt.

Sterke punten

  • Stretchstof voor een perfecte pasvorm
  • Romantisch gedrapeerd model met sculpting effect
  • Off-the-shoulderboothalslijn
  • Sensuelesplit aan de zijkant om de benen te accentueren
  • Vier kleuren: zwart, smaragdgroen, koningsblauw en fuchsiaroze
Maat:

Weet je niet zeker welke maat je moet kiezen? Raadpleeg onze maattabel

Kleur:
Hoeveelheid:
56.95 €
Goed advies
via chat, facebook of e-mail
Gratis retourneren
binnen 15 dagen *

Gedrapeerde asymmetrische jurk met korte mouwen, grote maat

Productomschrijving

Deze gedrapeerde jurk is het toppunt van sensuele romantiek, met een snit die ontworpen is om elk figuur te verbeteren. De uitzonderlijke stretchstof omhelst op harmonieuze wijze royale rondingen, terwijl het asymmetrische drapeereffect een geraffineerd spel van volumes creëert dat elk lichaamstype tot zijn recht laat komen. De off-the-shoulder boothalslijn voegt een vleugje moderne sensualiteit toe, perfect in balans gebracht door de gedrapeerde korte mouwen die de armen subtiel vormgeven.

De strategisch geplaatste split aan de zijkant onthult subtiel de benen terwijl het een romantische allure behoudt. De rekbare, ademende stoffen bieden de hele dag door uitzonderlijk comfort en zorgen voor een ongeëvenaarde bewegingsvrijheid. Deze jurk is verkrijgbaar in vier opvallende kleuren: tijdloos zwart voor klassieke elegantie, levendig smaragdgroen voor natuurlijke verfijning, diep koningsblauw voor majestueuze allure en levendig fuchsiaroze om je van je gewaagde kant te laten zien.

Het ontwerp is perfect voor alle vormen en maten en de verstelbare snit zorgt ervoor dat je buste perfect wordt ondersteund, waardoor je figuur op natuurlijke wijze wordt benadrukt. Het wrap-around effect van de drapering creëert een gebeeldhouwd silhouet dat de taille laat zien terwijl het een comfortabele, flatterende pasvorm biedt.

Technische details

  • Materiaal: hoogwaardige stretchstof
  • Kleuren: zwart, smaragdgroen, koningsblauw, fuchsiaroze
  • Maten: Verkrijgbaar in alle maten
  • Sluiting: Gemakkelijk aan te trekken
  • Onderhoud: machinewas aanbevolen

Beschikbaar maten

Beschikbaar van 4X tot 3X

Beschikbare kleuren

Zwart , Blauw en Roze

Maattabel

Controleer de juiste maat voor jou

Internationale
  • Borst
  • Maat
  • Heupen
4X
  • 128-134
  • 107-112
  • 133-140
XL
  • 100-107
  • 79-86
  • 105-112
1X
  • 107-114
  • 86-93
  • 112-119
2XL
  • 114-121
  • 93-100
  • 119-126
3X
  • 121-128
  • 100-107
  • 126-133

Onderhoudstips

  • Machinewasbaar op maximaal 30°C op fijnwasprogramma
  • Gebruik een mild wasmiddel zonder bleekmiddelen
  • Plat drogen om het drapeereffect te behouden
  • Strijken op lage temperatuur indien nodig
  • vermijd intensief centrifugeren om de elasticiteit te behouden

Gebruikstips

Deze gedrapeerde jurk is ideaal om te dragen met onzichtbaar ondergoed om de schoonheid van de lage halslijn te behouden. Dankzij de uitzonderlijke stretchstof past hij zich perfect aan bewegingen aan en behoudt hij toch zijn kenmerkende gedrapeerde vorm.

Dankzij de verstelbare romantische snit kun je het gedrapeerde effect aanpassen aan jouw voorkeuren, terwijl de split aan de zijkant een ongeëvenaarde bewegingsvrijheid biedt. Voor speciale gelegenheden verander je deze jurk eenvoudig van dag naar avond door simpelweg de accessoires te veranderen.

Je bent de hele dag verzekerd van comfort dankzij de ademende stoffen die zich onbeperkt aan alle lichaamsvormen aanpassen.

Stijltips

De zwarte versie past perfect bij gouden of zilveren pumps voor een avondlook, terwijl sandalen met hak zorgen voor een meer casual look. Het levendige smaragdgroen staat geweldig met gouden accessoires of roségouden sieraden.

Maak je look compleet met onze transparante kousen of panty's om je benen te laten opvallen. Deze jurk is perfect te combineren met onze nachtkleding om een complete garderobe te creëren, of met onze kimono's voor een bohemian chique gelaagde look.

To Top
Winkelmand bekijken
Artikelen
Totaal aantal items
Struct
Entries: 108
actions
Array
available
number-1
brand
stringdivasfashion
brandcode
stringdvqc
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
stringDiva's Fashion
breasts
stringna
careinstructions
string
categories
stringdivasboudoir.cabaret.dresses.all
category
stringdresses
categorygender
stringf
categorymediadatas
Struct
adult
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string615
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/cabaret/dresses1.jpg
type
stringimg
width
string1336
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.909 ms
Record Count: 3
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,blue,pink') > 0
and product_variations.productuid = '79CEC95F-CDF7-404A-9AC92EEEF9E74A06'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1blackcolorblakblackblack#000000-10
2bluecolorblueblueblue#022293-10
3pinkcolorpinkpinkpink#FE70BD-10
colorrange
stringblue
colors
stringblack,blue,pink
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 '2025-06-16 16:45:59'}
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
booleanfalse
hasotherspecifications
booleanfalse
haspromo
number0
hasshortdescription
booleantrue
hassizeinfos
booleantrue
hasspecifications
booleantrue
hasstockinfos
booleanfalse
hasstylingtips
booleantrue
hasusageinstructions
booleantrue
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
number47.4583
itempromo
string
key
stringsz2407250689635633
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-09-04 10:35:52'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.619 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','es')
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('79cec95f-cdf7-404a-9ac92eeef9e74a06',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.3 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','es')
and product_categories.language in ('all','es')
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 <> 'CDBU8229'
group by products.reference
order by products.ishot desc, products.isnew desc, orderidx asc, products.lastupdated desc
productuidreferencetypekeylanguagenamelinkuidcolorsvatratemetadatasdimensionsmediadatastagsthemesisdivasizetotalvariationsvariationlistinpromohaspromoitempromoitempriceunitpricepricespromountilisfixedpriceishotisneworderidxavailablestockinstockvariationsbrandbrandnameshowbranddisplaysizetypeintlsizesizessizerangecategorymediadatascategorysizerangesectioncategorysubcategory
linkuid
string
materials
string
mediadatas
Struct
alt
Struct
height
string1676
isprivate
string0
rating
stringall
src
string/photobank/products/dvqc/cdbu8229/39093885.jpg
type
stringimg
width
string1159
back
Struct
height
string1763
isprivate
string0
rating
stringall
src
string/photobank/products/dvqc/cdbu8229/39094110.jpg
type
stringimg
width
string1219
default
Struct
height
string1745
isprivate
string0
rating
stringall
src
string/photobank/products/dvqc/cdbu8229/39093886.jpg
type
stringimg
width
string1207
variations
Struct
colors
Struct
black
Struct
height
string1745
isprivate
string0
rating
stringall
src
string/photobank/products/dvqc/cdbu8229/39093886.jpg
type
stringimg
width
string1207
blue
Struct
height
string1676
isprivate
string0
rating
stringall
src
string/photobank/products/dvqc/cdbu8229/39093885.jpg
type
stringimg
width
string1159
pink
Struct
height
string1763
isprivate
string0
rating
stringall
src
string/photobank/products/dvqc/cdbu8229/39094110.jpg
type
stringimg
width
string1219
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-blau-grun-ou-rosa
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-mple-prasino-ou-roz
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-blue-green-ou-pink
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-azul-verde-ou-rosa
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-bleu-vert-ou-rose
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-blu-verde-ou-rosa
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-blauw-groen-ou-roze
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-azul-verde-ou-cor-de-rosa
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
divasboudoir
Struct
de
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Maschinenwäsche bei maximal 30&deg;C im Schonwaschgang</li> <li>Verwenden Sie ein mildes Waschmittel ohne Bleichmittel</li> <li>Flach trocknen, um den Drapierungseffekt zu erhalten.</li> <li>Bügeln bei niedriger Temperatur, wenn nötig</li> <li>vermeiden Sie intensives Schleudern, um die Elastizität zu erhalten.</li> </ul>
description
string<p>Dieses drapierte Kleid verkörpert <strong>sinnliche Romantik</strong> und ist so geschnitten, dass es jeder Figur schmeichelt. Der außergewöhnliche Stretch-Stoff schmiegt sich harmonisch an die Kurven an, während der asymmetrische Drapierungseffekt ein raffiniertes Volumenspiel erzeugt, das jede Körperform aufwertet. Der über eine Schulter ausgeschnittene U-Boot-Ausschnitt sorgt für einen Hauch moderner Sinnlichkeit, der durch die drapierten kurzen Ärmel, die die Arme sanft formen, perfekt ausbalanciert wird.</p> <p>Der <strong>strategisch platzierte Seitenschlitz</strong> enthüllt subtil die Beine, während er gleichzeitig einen romantischen Look bewahrt. Die <strong>dehnbaren und atmungsaktiven Materialien</strong> bieten den ganzen Tag über einen außergewöhnlichen Tragekomfort und ermöglichen eine unvergleichliche Bewegungsfreiheit. Dieses Kleid ist in vier atemberaubenden Farben erhältlich: zeitloses Schwarz für klassische Eleganz, strahlendes Smaragdgrün für natürliche Raffinesse, tiefes Königsblau für einen majestätischen Auftritt und vibrierendes Fuchsia-Pink, das Ihre kühne Seite offenbart.</p> <p>Das <strong>Design ist für jede Figur geeignet</strong> und bietet dank des verstellbaren Schnitts einen perfekten Halt für große Brüste, die auf natürliche Weise aufgewertet werden. Der Wickeleffekt der Drapierung schafft eine wohlgeformte Silhouette, die die Taille betont und gleichzeitig eine bequeme und schmeichelhafte Passform bietet.</p>
guid
stringhttps://dev.divasboudoir.com/de/sexy-kleider-schwarz-blau-grun-ou-rosa/cdbu8229.htm
highlights
string<ul> <li><strong>Dehnbarer Stoff</strong>, der sich perfekt an die Formen anpasst</li> <li><strong>Romantischer drapierter Schnitt</strong> mit figurformendem Effekt</li> <li><strong>Boot-Ausschnitt</strong>, der an einer Schulter dekolletiert ist</li> <li>Sinnlicher<strong>Seitenschlitz</strong>, der die Beine betont</li> <li><strong>Vier Farben</strong>: Schwarz, Smaragdgrün, Königsblau und Fuchsia-Pink</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringAsymmetrisches, drapiertes Kleid in Übergröße aus dehnbarem Stoff, romantischer Schnitt. Schwarz oder smaragdgrün, sinnlicher Seitenschlitz. Schnelle Lieferung bei Diva's Boudoir.
keywords
string
title
stringAsymmetrisches drapiertes Kleid in Übergröße | Diva's Boudoir
seotitle
stringDrapiertes Kleid in Übergröße asymmetrisch mit kurzen Ärmeln
seouri
stringsexy-kleider-schwarz-blau-grun-ou-rosa
specifications
string<ul> <li><strong>Material:</strong> Hochwertiger Stretchstoff</li> <li><strong>Farben:</strong> Schwarz, Smaragdgrün, Königsblau, Fuchsia-Pink</li> <li><strong>Größen:</strong> In allen Größen erhältlich</li> <li><strong>Verschluss:</strong> Leichtes Anziehen</li> <li><strong>Pflege:</strong> Schonende Maschinenwäsche empfohlen</li> </ul>
stylingtips
string<p>Die schwarze Variante passt perfekt zu goldenen oder silbernen Pumps für einen Abendlook, während Sandalen mit Absätzen einen lässigen Look kreieren. Das strahlende Smaragdgrün harmoniert wunderbar mit goldenen Accessoires oder ros&eacute;goldenem Schmuck.</p> <p>Vervollständigen Sie Ihren Look mit unseren Feinstrümpfen oder durchsichtigen <a href="https://www.divasboudoir.com/de/strumpfhosen-in-grossen-grossen/">Strumpfhosen</a>, um Ihre Beine zu betonen. Dieses Kleid lässt sich perfekt mit unserer <a href="https://www.divasboudoir.com/de/nachtwasche-grosse-grossen/">Nachtwäsche</a> kombinieren, um eine komplette Garderobe zu kreieren, oder mit unseren <a href="https://www.divasboudoir.com/de/kimonos-in-grossen-grossen/">Kimonos</a> für einen Lagenlook im Boho-Chic.</p>
summary
string<p>Dieses drapierte Kleid betont großzügige Kurven mit seinem romantischen Schnitt und dem außergewöhnlichen Stretchmaterial.</p> <p>Der asymmetrische Drapierungseffekt und der Seitenschlitz schaffen eine sinnliche Silhouette, die jede Körperform mit natürlicher Eleganz aufwertet.</p>
title
stringDrapiertes Kleid Adele
usageinstructions
string<p>Dieses drapierte Kleid lässt sich am besten mit unsichtbarer Unterwäsche tragen, um die Schönheit des tief ausgeschnittenen Halsausschnitts zu bewahren. Dank des <strong>außergewöhnlichen Stretchmaterials</strong> passt sich das Kleid perfekt an Ihre Bewegungen an und behält dabei seine unverwechselbare drapierte Form bei.</p> <p>Der <strong>verstellbare romantische Schnitt</strong> ermöglicht es, den Drapierungseffekt nach Belieben zu variieren, während der Seitenschlitz eine unvergleichliche Bewegungsfreiheit bietet. Für besondere Anlässe lässt sich dieses Kleid leicht vom Tag zum Abend verwandeln, indem Sie einfach die Accessoires austauschen.</p> <p><strong>Optimaler Tragekomfort den ganzen Tag über</strong> ist dank der atmungsaktiven Materialien garantiert, die sich jeder Körperform ohne Einschränkungen anpassen.</p>
el
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Πλύσιμο στο πλυντήριο στους 30&deg;C το πολύ σε λεπτό κύκλο πλύσης</li> <li>Χρησιμοποιήστε ήπιο απορρυπαντικό χωρίς λευκαντικούς παράγοντες</li> <li>Στεγνώνετε επίπεδα για να διατηρήσετε το εφέ του ντραπέ</li> <li>Σιδερώστε σε χαμηλή θερμοκρασία εάν είναι απαραίτητο</li> <li>αποφύγετε το έντονο στύψιμο για να διατηρήσετε την ελαστικότητά σας.</li> </ul>
description
string<p>Αυτό το ντραπέ φόρεμα είναι η επιτομή του <strong>αισθησιακού ρομαντισμού</strong>, με κόψιμο που έχει σχεδιαστεί για να αναδεικνύει κάθε σιλουέτα. Το εξαιρετικό ελαστικό ύφασμα αγκαλιάζει αρμονικά τις γενναιόδωρες καμπύλες, ενώ το ασύμμετρο εφέ draping δημιουργεί ένα εκλεπτυσμένο παιχνίδι όγκων που αναδεικνύει κάθε σωματότυπο. Η λαιμόκοψη off-the-shoulder προσθέτει μια πινελιά σύγχρονου αισθησιασμού, που εξισορροπείται τέλεια από τα ντραπέ κοντομάνικα που σμιλεύουν απαλά τα χέρια.</p> <p>Το <strong>στρατηγικά τοποθετημένο πλαϊνό σκίσιμο</strong> αποκαλύπτει διακριτικά τα πόδια, διατηρώντας παράλληλα μια ρομαντική γοητεία. Τα <strong>ελαστικά, αναπνέοντα υφάσματα</strong> προσφέρουν εξαιρετική άνεση όλη την ημέρα, επιτρέποντας απαράμιλλη ελευθερία κινήσεων. Αυτό το φόρεμα διατίθεται σε τέσσερα εντυπωσιακά χρώματα: διαχρονικό μαύρο για κλασική κομψότητα, ζωηρό σμαραγδένιο πράσινο για φυσική φινέτσα, βαθύ βασιλικό μπλε για μεγαλοπρεπή εμφάνιση και ζωηρό φούξια ροζ για να αποκαλύψετε την τολμηρή πλευρά σας.</p> <p>Ο <strong>σχεδιασμός</strong> του <strong>είναι ιδανικός για όλα τα σχήματα και</strong> μεγέθη, ενώ το ρυθμιζόμενο κόψιμο εξασφαλίζει ότι το μπούστο σας υποστηρίζεται τέλεια, αναδεικνύοντας φυσικά τη σιλουέτα σας. Το εφέ περιτύλιξης του υφάσματος δημιουργεί μια σμιλεμένη σιλουέτα που αναδεικνύει τη μέση, ενώ παράλληλα προσφέρει μια άνετη, κολακευτική εφαρμογή.</p>
guid
stringhttps://dev.divasboudoir.com/el/sexi-foremata-mayro-mple-prasino-ou-roz/cdbu8229.htm
highlights
string<ul> <li><strong>Stretch ύφασμα</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
stringΑσύμμετρο μεγάλο φόρεμα με ντραπέ, ελαστικό ύφασμα, ρομαντικό κόψιμο. μαύρο ή σμαραγδένιο πράσινο, αισθησιακό σκίσιμο στο πλάι. Γρήγορη παράδοση στο Diva's Boudoir.
keywords
string
title
stringΜεγάλο ασύμμετρο φόρεμα με ντραπέ | Diva's Boudoir
seotitle
stringΦόρεμα με κοντό μανίκι και ασύμμετρο ντραπέ, μεγάλο νούμερο
seouri
stringsexi-foremata-mayro-mple-prasino-ou-roz
specifications
string<ul> <li><strong>Υλικό:</strong> υψηλής ποιότητας ελαστικό ύφασμα</li> <li><strong>Χρώματα:</strong> μαύρο, σμαραγδένιο πράσινο, βασιλικό μπλε, ροζ φούξια</li> <li><strong>Μεγέθη:</strong> Διατίθεται σε όλα τα μεγέθη</li> <li><strong>Κλείσιμο:</strong> Εύκολη ολίσθηση</li> <li><strong>Φροντίδα:</strong> Συνιστάται απαλό πλύσιμο στο πλυντήριο</li> </ul>
stylingtips
string<p>Η μαύρη εκδοχή ταιριάζει τέλεια με χρυσές ή ασημένιες γόβες για μια βραδινή εμφάνιση, ενώ τα πέδιλα με τακούνι δημιουργούν μια πιο casual εμφάνιση. Το ζωηρό σμαραγδένιο πράσινο ταιριάζει υπέροχα με χρυσά αξεσουάρ ή κοσμήματα από ροζ χρυσό.</p> <p>Ολοκληρώστε την εμφάνισή σας με τις διάφανες <a href="https://www.divasboudoir.com/el/kaltses-megaloy-megethoys/">κάλτσες</a> ή το <a href="https://www.divasboudoir.com/el/syn-megethos-kalson/">καλσόν</a> μας για να αναδείξετε τα πόδια σας. Αυτό το φόρεμα συνδυάζεται τέλεια με τα <a href="https://www.divasboudoir.com/el/nychtika-syn-megethos/">νυχτικά</a> μας για να δημιουργήσετε μια ολοκληρωμένη γκαρνταρόμπα, ή με τα <a href="https://www.divasboudoir.com/el/megala-kimono/">κιμονό</a> μας για ένα μποέμικο κομψό layered look.</p>
summary
string<p>Αυτό το ντραπέ φόρεμα τονίζει τις γενναιόδωρες καμπύλες με το ρομαντικό του κόψιμο και το εξαιρετικό ελαστικό ύφασμα.</p> <p>Το ασύμμετρο εφέ ντραπέ και το πλαϊνό σκίσιμο δημιουργούν μια αισθησιακή σιλουέτα που αναδεικνύει κάθε σωματότυπο με φυσική κομψότητα.</p>
title
stringAdèle Draped φόρεμα
usageinstructions
string<p>Αυτό το ντραπέ φόρεμα είναι ιδανικό για να το φορέσετε με αόρατο εσώρουχο για να διατηρήσετε την ομορφιά του χαμηλού ντεκολτέ. Χάρη στο <strong>εξαιρετικό ελαστικό</strong> του <strong>ύφασμα</strong>, προσαρμόζεται τέλεια στις κινήσεις, διατηρώντας παράλληλα το χαρακτηριστικό ντραπέ σχήμα του.</p> <p>Το <strong>ρυθμιζόμενο ρομαντικό κόψιμο</strong> σάς επιτρέπει να διαμορφώνετε το ντραπέ αποτέλεσμα ανάλογα με τις προτιμήσεις σας, ενώ το πλαϊνό σκίσιμο προσφέρει ασύγκριτη ελευθερία κινήσεων. Για ειδικές περιστάσεις, αυτό το φόρεμα μεταμορφώνεται εύκολα από το πρωί στο βράδυ αλλάζοντας απλώς τα αξεσουάρ.</p> <p>Η <strong>άνεση</strong> όλη την ημέρα είναι εγγυημένη χάρη στα υφάσματα που αναπνέουν και προσαρμόζονται σε όλα τα σχήματα σώματος χωρίς περιορισμούς.</p>
en
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Machine wash at 30&deg;C maximum on delicate cycle</li> <li>Use a mild detergent without bleaching agents</li> <li>Dry flat to preserve drape effect</li> <li>Iron at low temperature if necessary</li> <li>avoid intensive spinning to preserve elasticity</li> </ul>
description
string<p>This draped dress embodies <strong>sensual romance</strong> with a cut designed to sublimate every figure. The exceptional stretch fabric harmoniously hugs generous curves, while the asymmetrical draped effect creates a sophisticated play of volumes that enhances every morphology. The off-the-shoulder bateau neckline adds that touch of modern sensuality, perfectly balanced by draped short sleeves that delicately sculpt the arms.</p> <p>The <strong>strategically placed side slit</strong> subtly reveals the legs while maintaining a romantic allure. <strong>Stretchy, breathable fabrics</strong> offer exceptional all-day comfort, allowing incomparable freedom of movement. This dress comes in four striking colors: timeless black for classic elegance, vibrant emerald green for natural sophistication, deep royal blue for majestic allure, and vibrant fuchsia pink to reveal your bold side.</p> <p>A <strong>design for every figure</strong> ensures perfect support for generous breasts, thanks to an adjustable cut that naturally enhances the look. The wrap-around effect of the drape creates a sculpted silhouette that enhances the waist while offering a comfortable, flattering fit.</p>
guid
stringhttps://dev.divasboudoir.com/en/sexy-dresses-black-blue-green-ou-pink/cdbu8229.htm
highlights
string<ul> <li><strong>Stretch fabric</strong> for a perfect fit</li> <li><strong>Romantic draped cut</strong> with sculpting effect</li> <li>Off-the-shoulder<strong>boat neckline</strong></li> <li>Sensual<strong>side slit</strong> to enhance legs</li> <li><strong>Four colors</strong>: black, emerald green, royal blue and fuchsia pink</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringAsymmetrical plus size draped dress, stretch fabric, romantic cut. black or emerald green, sensual side slit. Fast delivery at Diva's Boudoir.
keywords
string
title
stringAsymmetrical plus size draped dress | Diva's Boudoir
seotitle
stringPlus size asymmetrical draped dress with short sleeves
seouri
stringsexy-dresses-black-blue-green-ou-pink
specifications
string<ul> <li><strong>Material:</strong> high-quality stretch fabric</li> <li><strong>Colors:</strong> black, emerald green, royal blue, fuchsia pink</li> <li><strong>Sizes:</strong> Available in all sizes</li> <li><strong>Closure:</strong> Easy slip-on</li> <li><strong>Care:</strong> Delicate machine wash recommended</li> </ul>
stylingtips
string<p>The black version pairs perfectly with gold or silver pumps for an evening look, while heeled sandals create a more casual look. The vibrant emerald green looks great with gold accessories or rose gold jewelry.</p> <p>Complete your look with our thin <a href="https://www.divasboudoir.com/en/socks-large-size/">stockings</a> or sheer <a href="https://www.divasboudoir.com/en/plus-size-tights/">tights</a> to enhance your legs. This dress pairs perfectly with our <a href="https://www.divasboudoir.com/en/nightwear-plus-size/">nightwear</a> to create a complete wardrobe, or with our <a href="https://www.divasboudoir.com/en/plus-size-kimonos/">kimonos</a> for a bohemian chic layered look.</p>
summary
string<p>This draped dress enhances generous curves with its romantic cut and exceptional stretch fabric.</p> <p>The asymmetrical draped effect and side slit create a sensual silhouette that enhances every body type with natural elegance.</p>
title
stringAdèle Draped Dress
usageinstructions
string<p>This draped dress is ideal for wearing with invisible undergarments to preserve the beauty of the scoop neckline. Thanks to its <strong>exceptional stretch fabric</strong>, it adapts perfectly to movement while retaining its distinctive draped shape.</p> <p>The <strong>adjustable romantic cut</strong> allows you to modulate the draped effect to your preference, while the side slit offers incomparable freedom of movement. For special occasions, this dress is easily transformed from day to evening by simply changing accessories.</p> <p>All-day <strong>comfort</strong> is guaranteed thanks to breathable fabrics that adapt to all morphologies without constraint.</p>
es
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavar a máquina a 30&deg;C máximo en ciclo delicado</li> <li>Utilizar un detergente suave sin blanqueantes</li> <li>Secar en plano para conservar el efecto de caída</li> <li>Planchar a baja temperatura si es necesario</li> <li>evitar el centrifugado intensivo para conservar la elasticidad</li> </ul>
description
string<p>Este vestido drapeado es el epítome del <strong>romanticismo sensual</strong>, con un corte diseñado para realzar todas las figuras. El excepcional tejido elástico abraza armoniosamente las curvas generosas, mientras que el efecto de drapeado asimétrico crea un sofisticado juego de volúmenes que realza cada tipo de cuerpo. El escote barco sin hombros aporta un toque de moderna sensualidad, perfectamente equilibrado por las mangas cortas drapeadas que esculpen delicadamente los brazos.</p> <p>La <strong>abertura lateral, estratégicamente colocada</strong>, deja ver sutilmente las piernas sin perder el romanticismo. <strong>Los tejidos elásticos y transpirables</strong> ofrecen una comodidad excepcional durante todo el día, permitiendo una libertad de movimientos inigualable. Este vestido está disponible en cuatro llamativos colores: negro atemporal para una elegancia clásica, verde esmeralda vibrante para una sofisticación natural, azul real profundo para un encanto majestuoso y rosa fucsia vibrante para revelar tu lado más atrevido.</p> <p>El <strong>diseño es perfecto para todas las formas y</strong> tallas, y el corte ajustable garantiza una sujeción perfecta del busto, realzando naturalmente su figura. El efecto envolvente del drapeado crea una silueta esculpida que muestra la cintura al tiempo que ofrece un ajuste cómodo y favorecedor.</p>
guid
stringhttps://dev.divasboudoir.com/es/vestidos-sexys-negro-azul-verde-ou-rosa/cdbu8229.htm
highlights
string<ul> <li><strong>Tejido elástico</strong> para un ajuste perfecto</li> <li><strong>Corte romántico drapeado</strong> con efecto esculpido</li> <li><strong>Escote barco</strong> sin hombros</li> <li>Sensual<strong>abertura lateral</strong> para realzar las piernas</li> <li><strong>Cuatro colores</strong>: negro, verde esmeralda, azul real y rosa fucsia</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringVestido asimétrico talla grande drapeado, tejido elástico, corte romántico. negro o verde esmeralda, sensual abertura lateral. Entrega rápida en Diva's Boudoir.
keywords
string
title
stringVestido drapeado asimétrico de talla grande | Diva's Boudoir
seotitle
stringVestido drapeado asimétrico de manga corta, talla grande
seouri
stringvestidos-sexys-negro-azul-verde-ou-rosa
specifications
string<ul> <li><strong>Material:</strong> tejido elástico de alta calidad</li> <li><strong>Colores:</strong> negro, verde esmeralda, azul real, rosa fucsia</li> <li><strong>Tallas</strong>: disponible en todas las tallas</li> <li><strong>Cierre:</strong> Fácil de poner</li> <li><strong>Cuidados:</strong> Se recomienda un lavado delicado a máquina</li> </ul>
stylingtips
string<p>La versión en negro combina a la perfección con zapatos de tacón dorados o plateados para un look de noche, mientras que las sandalias de tacón crean un look más informal. El vibrante verde esmeralda queda genial con accesorios dorados o joyas de oro rosa.</p> <p>Completa tu look con nuestras <a href="https://www.divasboudoir.com/es/medias-grandes/">medias</a> transparentes o <a href="https://www.divasboudoir.com/es/mallas-tallas-grandes/">leotardos</a> para resaltar tus piernas. Este vestido combina a la perfección con nuestra <a href="https://www.divasboudoir.com/es/camisones-tallas-grandes/">ropa de noche</a> para crear un fondo de armario completo, o con nuestros <a href="https://www.divasboudoir.com/es/kimonos-tallas-grandes/">kimonos</a> para un look bohemio chic a capas.</p>
summary
string<p>Este vestido drapeado realza las curvas generosas con su corte romántico y su excepcional tejido elástico.</p> <p>El efecto drapeado asimétrico y la abertura lateral crean una silueta sensual que realza cada tipo de cuerpo con elegancia natural.</p>
title
stringVestido drapeado Adèle
usageinstructions
string<p>Este vestido drapeado es ideal para llevarlo con ropa interior invisible para preservar la belleza del escote. Gracias a su <strong>excepcional tejido elástico</strong>, se adapta perfectamente al movimiento conservando su característica forma drapeada.</p> <p>El <strong>corte romántico ajustable</strong> permite modular el efecto drapeado según sus preferencias, mientras que la abertura lateral ofrece una libertad de movimiento incomparable. Para las ocasiones especiales, este vestido se transforma fácilmente del día a la noche con sólo cambiar los accesorios.</p> <p>La <strong>comodidad</strong> durante todo el día está garantizada gracias a los tejidos transpirables que se adaptan a todas las formas del cuerpo sin apretar.</p>
fr
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavage machine &agrave; 30&deg;C maximum en cycle d&eacute;licat</li> <li>Utiliser une lessive douce sans agents blanchissants</li> <li>S&eacute;chage &agrave; plat pour pr&eacute;server l'effet drap&eacute;</li> <li>Repassage &agrave; basse temp&eacute;rature si n&eacute;cessaire</li> <li>&Eacute;viter l'essorage intensif pour pr&eacute;server l'&eacute;lasticit&eacute;</li> </ul>
description
string<p>Cette robe drap&eacute;e incarne la <strong>romance sensuelle</strong> avec sa coupe pens&eacute;e pour sublimer toutes les silhouettes. Le tissu extensible d'exception &eacute;pouse harmonieusement les courbes g&eacute;n&eacute;reuses, tandis que l'effet drap&eacute; asym&eacute;trique cr&eacute;e un jeu de volumes sophistiqu&eacute; qui valorise chaque morphologie. L'encolure bateau d&eacute;collet&eacute;e sur une &eacute;paule apporte cette touche de sensualit&eacute; moderne, parfaitement &eacute;quilibr&eacute;e par les manches courtes drap&eacute;es qui sculptent d&eacute;licatement les bras.</p> <p>La&nbsp;<strong>fente lat&eacute;rale strat&eacute;giquement plac&eacute;e</strong> r&eacute;v&egrave;le subtilement les jambes tout en conservant une allure romantique. Les <strong>mati&egrave;res extensibles et respirantes</strong> offrent un confort exceptionnel toute la journ&eacute;e, permettant une libert&eacute; de mouvement incomparable. Cette robe se d&eacute;cline en quatre coloris saisissants : le noir intemporel pour une &eacute;l&eacute;gance classique, le vert &eacute;meraude &eacute;clatant qui apporte une sophistication naturelle, le bleu roi profond pour une allure majestueuse, et le rose fuchsia vibrant qui r&eacute;v&egrave;le votre c&ocirc;t&eacute; audacieux.</p> <p>Le&nbsp;<strong>design pens&eacute; pour toutes les silhouettes</strong> assure un maintien parfait poitrine g&eacute;n&eacute;reuse gr&acirc;ce &agrave; la coupe ajustable qui valorise naturellement. L'effet enveloppant du drap&eacute; cr&eacute;e une silhouette sculpt&eacute;e qui met en valeur la taille tout en offrant une coupe confortable et flatteuse.</p>
guid
stringhttps://dev.divasboudoir.com/fr/robe-drapee-grande-taille-asymetrique/cdbu8229.htm
highlights
string<ul> <li><strong>Tissu extensible</strong> qui &eacute;pouse parfaitement les formes</li> <li><strong>Coupe drap&eacute;e romantique</strong> avec effet sculptant</li> <li><strong>Encolure bateau</strong> d&eacute;collet&eacute;e sur une &eacute;paule</li> <li><strong>Fente lat&eacute;rale</strong> sensuelle qui sublime les jambes</li> <li><strong>Quatre coloris</strong> : noir, vert &eacute;meraude, bleu roi et rose fuchsia</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringRobe drapée grande taille asymétrique, tissu extensible, coupe romantique. noir ou vert émeraude, fente latérale sensuelle. Livraison rapide chez Diva's Boudoir.
keywords
string
title
stringRobe drapée grande taille asymétrique | Diva's Boudoir
seotitle
stringRobe drapée grande taille asymétrique manches courtes
seouri
stringrobe-drapee-grande-taille-asymetrique
specifications
string<ul> <li><strong>Mati&egrave;re :</strong> Tissu extensible haute qualit&eacute;</li> <li><strong>Couleurs :</strong> noir, vert &eacute;meraude, bleu roi, rose fuchsia</li> <li><strong>Tailles :</strong> Disponible dans toutes les tailles</li> <li><strong>Fermeture :</strong> Enfilage facile</li> <li><strong>Entretien :</strong> Lavage machine d&eacute;licat recommand&eacute;</li> </ul>
stylingtips
string<p>La version noire se marie parfaitement avec des escarpins dor&eacute;s ou argent&eacute;s pour un look de soir&eacute;e, tandis que des sandales &agrave; talons cr&eacute;ent une allure plus d&eacute;contract&eacute;e. Le vert &eacute;meraude &eacute;clatant s'harmonise magnifiquement avec des accessoires dor&eacute;s ou des bijoux en or rose.</p> <p>Compl&eacute;tez votre look avec nos&nbsp;<a href="https://www.divasboudoir.com/fr/bas-grande-taille/">bas</a> fins ou nos <a href="https://www.divasboudoir.com/fr/collants-grande-taille/">collants</a> transparents pour sublimer vos jambes. Cette robe s'associe parfaitement avec nos <a href="https://www.divasboudoir.com/fr/lingerie-de-nuit-grande-taille/">lingerie de nuit</a> pour cr&eacute;er une garde-robe compl&egrave;te, ou avec nos <a href="https://www.divasboudoir.com/fr/kimonos-grande-taille/">kimonos</a> pour un look superpos&eacute; boh&egrave;me chic.&nbsp;</p>
summary
string<p>Cette robe drap&eacute;e sublime les courbes g&eacute;n&eacute;reuses avec sa coupe romantique et son tissu extensible d'exception.</p> <p>L'effet drap&eacute; asym&eacute;trique et la fente lat&eacute;rale cr&eacute;ent une silhouette sensuelle qui valorise chaque morphologie avec une &eacute;l&eacute;gance naturelle.</p>
title
stringRobe Drapée Adèle
usageinstructions
string<p>Cette robe drap&eacute;e se porte id&eacute;alement avec des sous-v&ecirc;tements invisibles pour pr&eacute;server la beaut&eacute; de l'encolure d&eacute;collet&eacute;e. Gr&acirc;ce &agrave; son <strong>tissu extensible exceptionnel</strong>, elle s'adapte parfaitement aux mouvements tout en conservant sa forme drap&eacute;e distinctive.</p> <p>La&nbsp;<strong>coupe romantique ajustable</strong> permet de moduler l'effet drap&eacute; selon vos pr&eacute;f&eacute;rences, tandis que la fente lat&eacute;rale offre une libert&eacute; de mouvement incomparable. Pour les occasions sp&eacute;ciales, cette robe se transforme facilement du jour &agrave; la soir&eacute;e en changeant simplement d'accessoires.</p> <p>Le&nbsp;<strong>confort optimal toute la journ&eacute;e</strong> est garanti gr&acirc;ce aux mati&egrave;res respirantes qui s'adaptent &agrave; toutes les morphologies sans contrainte.</p>
it
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavare in lavatrice a 30&deg;C al massimo con ciclo delicato</li> <li>Utilizzare un detersivo delicato senza agenti sbiancanti</li> <li>Asciugare in piano per preservare l'effetto drappeggio</li> <li>Stirare a bassa temperatura se necessario</li> <li>evitare l'asciugatura intensiva in centrifuga per preservare l'elasticità</li> </ul>
description
string<p>Questo abito drappeggiato è l'epitome del <strong>romanticismo sensuale</strong>, con un taglio studiato per valorizzare ogni figura. L'eccezionale tessuto elasticizzato abbraccia armoniosamente le curve generose, mentre l'effetto drappeggio asimmetrico crea un sofisticato gioco di volumi che esalta ogni tipo di corpo. Lo scollo a barca off-the-shoulder aggiunge un tocco di moderna sensualità, perfettamente bilanciato dalle maniche corte drappeggiate che scolpiscono delicatamente le braccia.</p> <p>Lo <strong>spacco laterale, strategicamente posizionato</strong>, lascia intravedere le gambe mantenendo un'allure romantica. I <strong>tessuti elastici e traspiranti</strong> offrono un comfort eccezionale per tutto il giorno, consentendo una libertà di movimento senza pari. Questo abito è disponibile in quattro colori sorprendenti: l'intramontabile nero per un'eleganza classica, il vibrante verde smeraldo per una raffinatezza naturale, il profondo blu reale per un'allure maestosa e il vibrante rosa fucsia per rivelare il vostro lato più audace.</p> <p>Il <strong>design è perfetto per tutte le forme e le</strong> taglie e il taglio regolabile garantisce un perfetto sostegno del busto, valorizzando in modo naturale la vostra figura. L'effetto avvolgente del drappeggio crea una silhouette scolpita che mette in risalto il punto vita e offre una vestibilità comoda e lusinghiera.</p>
guid
stringhttps://dev.divasboudoir.com/it/abiti-sexy-nero-blu-verde-ou-rosa/cdbu8229.htm
highlights
string<ul> <li><strong>Tessuto elasticizzato</strong> per una vestibilità perfetta</li> <li><strong>Romantico taglio drappeggiato</strong> con effetto scultura</li> <li><strong>Scollo a barca</strong> off-the-shoulder</li> <li>Sensuale<strong>spacco laterale</strong> per valorizzare le gambe</li> <li><strong>Quattro colori</strong>: nero, verde smeraldo, blu royal e rosa fucsia</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringAbito asimmetrico di grande taglia con drappeggio, tessuto elasticizzato, taglio romantico. nero o verde smeraldo, sensuale spacco laterale. Consegna rapida da Diva's Boudoir.
keywords
string
title
stringAbito asimmetrico drappeggiato di taglia grande | Diva's Boudoir
seotitle
stringAbito asimmetrico drappeggiato a maniche corte, taglia grande
seouri
stringabiti-sexy-nero-blu-verde-ou-rosa
specifications
string<ul> <li><strong>Materiale:</strong> tessuto elasticizzato di alta qualità</li> <li><strong>Colori:</strong> nero, verde smeraldo, blu reale, rosa fucsia</li> <li><strong>Taglie:</strong> Disponibile in tutte le taglie</li> <li><strong>Chiusura:</strong> facile da indossare</li> <li><strong>Cura:</strong> si consiglia un lavaggio delicato in lavatrice</li> </ul>
stylingtips
string<p>La versione nera si abbina perfettamente a décolleté dorate o argentate per un look da sera, mentre i sandali con tacco creano un look più casual. Il vivace verde smeraldo è perfetto con accessori dorati o gioielli in oro rosa.</p> <p>Completate il vostro look con le nostre <a href="https://www.divasboudoir.com/it/calze-di-grandi-dimensioni/">calze</a> o <a href="https://www.divasboudoir.com/it/collant-plus-size/">collant</a> velati per far risaltare le vostre gambe. Questo abito si abbina perfettamente con la nostra <a href="https://www.divasboudoir.com/it/abbigliamento-da-notte-per-taglie-forti/">biancheria da notte</a> per creare un guardaroba completo, o con i nostri <a href="https://www.divasboudoir.com/it/kimono-taglie-forti/">kimono</a> per un look bohémien chic a strati.</p>
summary
string<p>Questo abito drappeggiato esalta le curve generose grazie al taglio romantico e all'eccezionale tessuto elasticizzato.</p> <p>L'effetto drappeggio asimmetrico e lo spacco laterale creano una silhouette sensuale che valorizza ogni tipo di corpo con naturale eleganza.</p>
title
stringAbito drappeggiato Adèle
usageinstructions
string<p>Questo abito drappeggiato è ideale da indossare con biancheria intima invisibile per preservare la bellezza della scollatura. Grazie all'<strong>eccezionale tessuto elasticizzato</strong>, si adatta perfettamente ai movimenti mantenendo la sua caratteristica forma drappeggiata.</p> <p>Il <strong>taglio romantico regolabile</strong> permette di modulare l'effetto drappeggiato in base alle proprie preferenze, mentre lo spacco laterale offre un'incomparabile libertà di movimento. Per le occasioni speciali, questo abito si trasforma facilmente da giorno a sera semplicemente cambiando gli accessori.</p> <p><strong>Il comfort</strong> è garantito per tutto il giorno grazie ai tessuti traspiranti che si adattano a tutte le forme del corpo senza costringere.</p>
nl
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Machinewasbaar op maximaal 30&deg;C op fijnwasprogramma</li> <li>Gebruik een mild wasmiddel zonder bleekmiddelen</li> <li>Plat drogen om het drapeereffect te behouden</li> <li>Strijken op lage temperatuur indien nodig</li> <li>vermijd intensief centrifugeren om de elasticiteit te behouden</li> </ul>
description
string<p>Deze gedrapeerde jurk is het toppunt van <strong>sensuele romantiek</strong>, met een snit die ontworpen is om elk figuur te verbeteren. De uitzonderlijke stretchstof omhelst op harmonieuze wijze royale rondingen, terwijl het asymmetrische drapeereffect een geraffineerd spel van volumes cre&euml;ert dat elk lichaamstype tot zijn recht laat komen. De off-the-shoulder boothalslijn voegt een vleugje moderne sensualiteit toe, perfect in balans gebracht door de gedrapeerde korte mouwen die de armen subtiel vormgeven.</p> <p>De <strong>strategisch geplaatste split aan de zijkant</strong> onthult subtiel de benen terwijl het een romantische allure behoudt. De <strong>rekbare, ademende stoffen</strong> bieden de hele dag door uitzonderlijk comfort en zorgen voor een onge&euml;venaarde bewegingsvrijheid. Deze jurk is verkrijgbaar in vier opvallende kleuren: tijdloos zwart voor klassieke elegantie, levendig smaragdgroen voor natuurlijke verfijning, diep koningsblauw voor majestueuze allure en levendig fuchsiaroze om je van je gewaagde kant te laten zien.</p> <p>Het <strong>ontwerp is perfect voor alle vormen en</strong> maten en de verstelbare snit zorgt ervoor dat je buste perfect wordt ondersteund, waardoor je figuur op natuurlijke wijze wordt benadrukt. Het wrap-around effect van de drapering cre&euml;ert een gebeeldhouwd silhouet dat de taille laat zien terwijl het een comfortabele, flatterende pasvorm biedt.</p>
guid
stringhttps://dev.divasboudoir.com/nl/sexy-jurken-zwart-blauw-groen-ou-roze/cdbu8229.htm
highlights
string<ul> <li><strong>Stretchstof</strong> voor een perfecte pasvorm</li> <li><strong>Romantisch gedrapeerd model</strong> met sculpting effect</li> <li>Off-the-shoulder<strong>boothalslijn</strong></li> <li>Sensuele<strong>split aan de zijkant</strong> om de benen te accentueren</li> <li><strong>Vier kleuren</strong>: zwart, smaragdgroen, koningsblauw en fuchsiaroze</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringAsymmetrische grote gedrapeerde jurk, stretchstof, romantische snit. Zwart of smaragdgroen, sensuele split aan de zijkant. Snelle levering bij Diva's Boudoir.
keywords
string
title
stringGrote gedrapeerde asymmetrische jurk | Diva's Boudoir
seotitle
stringGedrapeerde asymmetrische jurk met korte mouwen, grote maat
seouri
stringsexy-jurken-zwart-blauw-groen-ou-roze
specifications
string<ul> <li><strong>Materiaal:</strong> hoogwaardige stretchstof</li> <li><strong>Kleuren:</strong> zwart, smaragdgroen, koningsblauw, fuchsiaroze</li> <li><strong>Maten:</strong> Verkrijgbaar in alle maten</li> <li><strong>Sluiting:</strong> Gemakkelijk aan te trekken</li> <li><strong>Onderhoud:</strong> machinewas aanbevolen</li> </ul>
stylingtips
string<p>De zwarte versie past perfect bij gouden of zilveren pumps voor een avondlook, terwijl sandalen met hak zorgen voor een meer casual look. Het levendige smaragdgroen staat geweldig met gouden accessoires of ros&eacute;gouden sieraden.</p> <p>Maak je look compleet met onze transparante <a href="https://www.divasboudoir.com/nl/grote-maat-kousen/">kousen</a> of <a href="https://www.divasboudoir.com/nl/grote-maten-pantys/">panty's</a> om je benen te laten opvallen. Deze jurk is perfect te combineren met onze <a href="https://www.divasboudoir.com/nl/plus-maat-nachtkleding/">nachtkleding</a> om een complete garderobe te cre&euml;ren, of met onze <a href="https://www.divasboudoir.com/nl/plus-size-kimonos/">kimono's</a> voor een bohemian chique gelaagde look.</p>
summary
string<p>Deze gedrapeerde jurk benadrukt royale rondingen met zijn romantische snit en uitzonderlijke stretchstof.</p> <p>Het asymmetrische drapeereffect en de split opzij cre&euml;ren een sensueel silhouet dat elk lichaamstype met natuurlijke elegantie benadrukt.</p>
title
stringAdèle Gedrapeerde Jurk
usageinstructions
string<p>Deze gedrapeerde jurk is ideaal om te dragen met onzichtbaar ondergoed om de schoonheid van de lage halslijn te behouden. Dankzij de <strong>uitzonderlijke stretchstof</strong> past hij zich perfect aan bewegingen aan en behoudt hij toch zijn kenmerkende gedrapeerde vorm.</p> <p>Dankzij de <strong>verstelbare romantische snit</strong> kun je het gedrapeerde effect aanpassen aan jouw voorkeuren, terwijl de split aan de zijkant een onge&euml;venaarde bewegingsvrijheid biedt. Voor speciale gelegenheden verander je deze jurk eenvoudig van dag naar avond door simpelweg de accessoires te veranderen.</p> <p>Je bent de hele dag verzekerd <strong>van comfort</strong> dankzij de ademende stoffen die zich onbeperkt aan alle lichaamsvormen aanpassen.</p>
pt
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavar à máquina a 30&deg;C, no máximo, num ciclo delicado</li> <li>Utilizar um detergente suave sem agentes branqueadores</li> <li>Secar na horizontal para preservar o efeito drapeado</li> <li>Se necessário, passar a ferro a baixa temperatura</li> <li>evitar a secagem por centrifugação intensiva para preservar a elasticidade</li> </ul>
description
string<p>Este vestido drapeado é o epítome do <strong>romance sensual</strong>, com um corte concebido para realçar todas as figuras. O excecional tecido elástico abraça harmoniosamente as curvas generosas, enquanto o efeito drapeado assimétrico cria um sofisticado jogo de volumes que realça todos os tipos de corpo. O decote à barco sem ombros acrescenta um toque de sensualidade moderna, perfeitamente equilibrado pelas mangas curtas drapeadas que esculpem delicadamente os braços.</p> <p>A <strong>fenda lateral estrategicamente colocada</strong> revela subtilmente as pernas, mantendo um encanto romântico. <strong>Os tecidos elásticos e respiráveis</strong> oferecem um conforto excecional durante todo o dia, permitindo uma liberdade de movimentos sem igual. Este vestido está disponível em quatro cores marcantes: preto intemporal para uma elegância clássica, verde esmeralda vibrante para uma sofisticação natural, azul real profundo para um encanto majestoso e rosa fúcsia vibrante para revelar o seu lado ousado.</p> <p>O <strong>design é perfeito para todas as silhuetas</strong> e o corte ajustável garante que o seu peito fica perfeitamente apoiado e naturalmente realçado. O efeito envolvente do drapeado cria uma silhueta esculpida que mostra a cintura enquanto oferece um ajuste confortável e lisonjeiro.</p>
guid
stringhttps://dev.divasboudoir.com/pt/vestidos-sensuais-preto-azul-verde-ou-cor-de-rosa/cdbu8229.htm
highlights
string<ul> <li><strong>Tecido elástico</strong> para um ajuste perfeito</li> <li><strong>Corte drapeado romântico</strong> com efeito esculpido</li> <li><strong>Decote</strong> à<strong>barco</strong> sem ombros</li> <li><strong>Fenda lateral</strong> sensual para realçar as pernas</li> <li><strong>Quatro cores</strong>: preto, verde esmeralda, azul real e rosa fúcsia</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringVestido assimétrico drapeado grande, tecido elástico, corte romântico. Preto ou verde-esmeralda, fenda lateral sensual. Entrega rápida na Diva's Boudoir.
keywords
string
title
stringVestido drapeado assimétrico grande | Diva's Boudoir
seotitle
stringVestido drapeado assimétrico de manga curta, tamanho grande
seouri
stringvestidos-sensuais-preto-azul-verde-ou-cor-de-rosa
specifications
string<ul> <li><strong>Material:</strong> tecido elástico de alta qualidade</li> <li><strong>Cores:</strong> preto, verde esmeralda, azul royal, rosa fúcsia</li> <li><strong>Tamanhos:</strong> Disponível em todos os tamanhos</li> <li><strong>Fecho:</strong> Fácil de calçar</li> <li><strong>Cuidados:</strong> Recomenda-se uma lavagem delicada na máquina</li> </ul>
stylingtips
string<p>A versão preta combina perfeitamente com sapatos dourados ou prateados para um look noturno, enquanto as sandálias de salto alto criam um look mais casual. O verde-esmeralda vibrante fica ótimo com acessórios dourados ou jóias em ouro rosa.</p> <p>Complete o seu look com as nossas <a href="https://www.divasboudoir.com/pt/meias-de-tamanho-grande/">meias</a> ou <a href="https://www.divasboudoir.com/pt/collants-plus-size/">collants</a> transparentes para fazer sobressair as suas pernas. Este vestido combina perfeitamente com a nossa <a href="https://www.divasboudoir.com/pt/roupa-de-noite-plus-size/">roupa de noite</a> para criar um guarda-roupa completo, ou com os nossos <a href="https://www.divasboudoir.com/pt/quimonos-de-tamanho-grande/">quimonos</a> para um look boémio e chique em camadas.</p>
summary
string<p>Este vestido drapeado realça as curvas generosas com o seu corte romântico e tecido elástico excecional.</p> <p>O efeito drapeado assimétrico e a fenda lateral criam uma silhueta sensual que realça todos os tipos de corpo com uma elegância natural.</p>
title
stringVestido drapeado Adèle
usageinstructions
string<p>Este vestido drapeado é ideal para usar com roupa interior invisível para preservar a beleza do decote baixo. Graças ao seu <strong>excecional tecido elástico</strong>, adapta-se perfeitamente ao movimento, mantendo a sua forma drapeada caraterística.</p> <p>O <strong>corte romântico ajustável</strong> permite-lhe modular o efeito drapeado de acordo com as suas preferências, enquanto a fenda lateral oferece uma liberdade de movimentos incomparável. Para ocasiões especiais, este vestido transforma-se facilmente do dia para a noite, bastando mudar os acessórios.</p> <p><strong>O conforto</strong> durante todo o dia é garantido graças aos tecidos respiráveis que se adaptam a todas as formas do corpo sem constrangimentos.</p>
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-blau-grun-ou-rosa
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-mple-prasino-ou-roz
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-blue-green-ou-pink
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-azul-verde-ou-rosa
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-bleu-vert-ou-rose
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-blu-verde-ou-rosa
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-blauw-groen-ou-roze
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-azul-verde-ou-cor-de-rosa
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-blau-grun-ou-rosa
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-mple-prasino-ou-roz
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-blue-green-ou-pink
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-azul-verde-ou-rosa
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-bleu-vert-ou-rose
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-blu-verde-ou-rosa
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-blauw-groen-ou-roze
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-azul-verde-ou-cor-de-rosa
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-blau-grun-ou-rosa
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-mple-prasino-ou-roz
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-blue-green-ou-pink
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-azul-verde-ou-rosa
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-bleu-vert-ou-rose
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-blu-verde-ou-rosa
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-blauw-groen-ou-roze
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-azul-verde-ou-cor-de-rosa
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-blau-grun-ou-rosa
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-mple-prasino-ou-roz
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-blue-green-ou-pink
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-azul-verde-ou-rosa
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-bleu-vert-ou-rose
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-blu-verde-ou-rosa
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-blauw-groen-ou-roze
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-azul-verde-ou-cor-de-rosa
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-blau-grun-ou-rosa
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-mple-prasino-ou-roz
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-blue-green-ou-pink
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-azul-verde-ou-rosa
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-bleu-vert-ou-rose
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-blu-verde-ou-rosa
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-blauw-groen-ou-roze
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-azul-verde-ou-cor-de-rosa
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
name
stringsz2407250689635633
netweight
string
nextshipment
stringtomorrow
ordered
number1
orderidx
number0
origin
string
originalsize
string
packaging
number0
productshipment
stringauto
productuid
string79CEC95F-CDF7-404A-9AC92EEEF9E74A06
promountil
string
rating
stringnone
recorduid
string79CEC95F-CDF7-404A-9AC92EEEF9E74A06
reference
stringCDBU8229
related
string
reserved
number0
returned
number0
returnsallowed
number1
section
stringcabaret
shipment
string5to7days
showbrand
number0
sizeinfos
Query
Template: /system/api/product/sizes.cfc:20
Execution Time: 1.83 ms
Record Count: 15
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,'2351,2352,2353,2354,2355') > 0
and product_variations.productuid = '79CEC95F-CDF7-404A-9AC92EEEF9E74A06'
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
123554Xintlsizeblack4X4X-19999990wplusdress4XL4X50-5220-2224-2652-5452-5450-5256-5852-5450-52128-134107-112133-140
223554Xintlsizepink4X4X-19999990wplusdress4XL4X50-5220-2224-2652-5452-5450-5256-5852-5450-52128-134107-112133-140
323554Xintlsizeblue4X4X-19999990wplusdress4XL4X50-5220-2224-2652-5452-5450-5256-5852-5450-52128-134107-112133-140
42351XLintlsizepinkXLXL-19999990wplusdress0XLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42100-10779-86105-112
52351XLintlsizeblueXLXL-19999990wplusdress0XLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42100-10779-86105-112
62351XLintlsizeblackXLXL-19999990wplusdress0XLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42100-10779-86105-112
723521Xintlsizeblue1X1X-19999990wplusdress1XL1X44-4614-1618-2046-4846-4844-4650-5246-4844-46107-11486-93112-119
823521Xintlsizeblack1X1X-19999990wplusdress1XL1X44-4614-1618-2046-4846-4844-4650-5246-4844-46107-11486-93112-119
923521Xintlsizepink1X1X-19999990wplusdress1XL1X44-4614-1618-2046-4846-4844-4650-5246-4844-46107-11486-93112-119
1023532XLintlsizeblue2XL2XL-19999990wplusdress2XL2XL46-4816-1820-2248-5048-5046-4852-5448-5046-48114-12193-100119-126
1123532XLintlsizeblack2XL2XL-19999990wplusdress2XL2XL46-4816-1820-2248-5048-5046-4852-5448-5046-48114-12193-100119-126
1223532XLintlsizepink2XL2XL-19999990wplusdress2XL2XL46-4816-1820-2248-5048-5046-4852-5448-5046-48114-12193-100119-126
1323543Xintlsizeblue3X3X-19999990wplusdress3XL3X48-5018-2022-2450-5250-5248-5054-5650-5248-50121-128100-107126-133
1423543Xintlsizeblack3X3X-19999990wplusdress3XL3X48-5018-2022-2450-5250-5248-5054-5650-5248-50121-128100-107126-133
1523543Xintlsizepink3X3X-19999990wplusdress3XL3X48-5018-2022-2450-5250-5248-5054-5650-5248-50121-128100-107126-133
sizeranges
stringplus
sizes
string2351,2352,2353,2354,2355
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: 23.8 ms
Record Count: 15
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 = '79CEC95F-CDF7-404A-9AC92EEEF9E74A06'
and product_variations.isactive = 1
and product_sizes.id_size = 2351
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 = '79CEC95F-CDF7-404A-9AC92EEEF9E74A06'
and product_variations.isactive = 1
and product_sizes.id_size = 2352
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 = '79CEC95F-CDF7-404A-9AC92EEEF9E74A06'
and product_variations.isactive = 1
and product_sizes.id_size = 2353
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 = '79CEC95F-CDF7-404A-9AC92EEEF9E74A06'
and product_variations.isactive = 1
and product_sizes.id_size = 2354
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 = '79CEC95F-CDF7-404A-9AC92EEEF9E74A06'
and product_variations.isactive = 1
and product_sizes.id_size = 2355
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
179CEC95F-CDF7-404A-9AC92EEEF9E74A0621836CCD-8CB0-4AAC-BE2F2D005969553B2355black#0000004XL4X50-5220-2224-2652-5452-5450-5256-5852-5450-52wdress4Xintlsize47.458333.2917{ts '2025-08-16 15:00:00'}STOCK01000-10000-10all
279CEC95F-CDF7-404A-9AC92EEEF9E74A060908934A-4AB3-48D2-BE6F93CDBE7CC80D2355blue#0222934XL4X50-5220-2224-2652-5452-5450-5256-5852-5450-52wdress4Xintlsize47.458333.2917{ts '2025-08-16 15:00:00'}STOCK01000-10100-10all
379CEC95F-CDF7-404A-9AC92EEEF9E74A061016B721-139F-4790-8170F09E15A0D7612355pink#FE70BD4XL4X50-5220-2224-2652-5452-5450-5256-5852-5450-52wdress4Xintlsize47.458333.2917{ts '2025-08-16 15:00:00'}STOCK01000-10100-10all
479CEC95F-CDF7-404A-9AC92EEEF9E74A06FC068EE0-8C19-42E7-A9C8BCB38C9F1E6A2351black#0000000XLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42wdressXLintlsize47.458333.2917{ts '2025-08-16 15:00:00'}STOCK01000-10000-10all
579CEC95F-CDF7-404A-9AC92EEEF9E74A065D14B1A7-22B0-4A9A-B70412A53D92B68C2351blue#0222930XLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42wdressXLintlsize47.458333.2917{ts '2025-08-16 15:00:00'}STOCK01000-10000-10all
679CEC95F-CDF7-404A-9AC92EEEF9E74A066E90A954-890E-44EF-AB1EC1C73512FCDB2351pink#FE70BD0XLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42wdressXLintlsize47.458333.2917{ts '2025-08-16 15:00:00'}STOCK01000-10000-10all
779CEC95F-CDF7-404A-9AC92EEEF9E74A0622702779-9D50-4476-8A17F358FE412E5F2352black#0000001XL1X44-4614-1618-2046-4846-4844-4650-5246-4844-46wdress1Xintlsize47.458333.2917{ts '2025-08-16 15:00:00'}STOCK01000-10000-10all
879CEC95F-CDF7-404A-9AC92EEEF9E74A065C72C7AA-F866-4B0A-9706CE2C6F24928A2352blue#0222931XL1X44-4614-1618-2046-4846-4844-4650-5246-4844-46wdress1Xintlsize47.458333.2917{ts '2025-08-16 15:00:00'}STOCK01000-10000-10all
979CEC95F-CDF7-404A-9AC92EEEF9E74A069C244986-7FEA-45D7-9F198F49F516CC4D2352pink#FE70BD1XL1X44-4614-1618-2046-4846-4844-4650-5246-4844-46wdress1Xintlsize47.458333.2917{ts '2025-08-16 15:00:00'}STOCK01000-10000-10all
1079CEC95F-CDF7-404A-9AC92EEEF9E74A0663AD4447-BFB1-410A-82638D445F4050892353black#0000002XL2XL46-4816-1820-2248-5048-5046-4852-5448-5046-48wdress2XLintlsize47.458333.2917{ts '2025-08-16 15:00:00'}STOCK01000-10100-10all
1179CEC95F-CDF7-404A-9AC92EEEF9E74A06BE5D9881-96BE-4EC9-82B226C2107B475D2353blue#0222932XL2XL46-4816-1820-2248-5048-5046-4852-5448-5046-48wdress2XLintlsize47.458333.2917{ts '2025-08-16 15:00:00'}STOCK01000-10000-10all
1279CEC95F-CDF7-404A-9AC92EEEF9E74A0620A0E291-D997-4740-9EDBD357EE84CE1B2353pink#FE70BD2XL2XL46-4816-1820-2248-5048-5046-4852-5448-5046-48wdress2XLintlsize47.458333.2917{ts '2025-08-16 15:00:00'}STOCK01000-10000-10all
1379CEC95F-CDF7-404A-9AC92EEEF9E74A060B1234F5-9058-46F3-9628B9698D4B57942354black#0000003XL3X48-5018-2022-2450-5250-5248-5054-5650-5248-50wdress3Xintlsize47.458333.2917{ts '2025-08-16 15:00:00'}STOCK01000-10000-10all
1479CEC95F-CDF7-404A-9AC92EEEF9E74A063D1A37FA-4736-45F0-BCBAF4499140CD092354blue#0222933XL3X48-5018-2022-2450-5250-5248-5054-5650-5248-50wdress3Xintlsize47.458333.2917{ts '2025-08-16 15:00:00'}STOCK01000-10100-10all
1579CEC95F-CDF7-404A-9AC92EEEF9E74A06576FC8DA-C994-4F13-82943D4B84FA83592354pink#FE70BD3XL3X48-5018-2022-2450-5250-5248-5054-5650-5248-50wdress3Xintlsize47.458333.2917{ts '2025-08-16 15:00:00'}STOCK01000-10000-10all
subcategory
stringall
supplier
number-1
supplierreference
stringSZ2407250689627577
tags
string
themes
string
totalvariations
number20
type
stringdefault
unitprice
number47.4583
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 10.2 ms
Record Count: 15
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 = '79CEC95F-CDF7-404A-9AC92EEEF9E74A06' 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 = '79CEC95F-CDF7-404A-9AC92EEEF9E74A06' 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 = '79CEC95F-CDF7-404A-9AC92EEEF9E74A06' 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 = '79CEC95F-CDF7-404A-9AC92EEEF9E74A06' 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 = '79CEC95F-CDF7-404A-9AC92EEEF9E74A06' 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 = '79CEC95F-CDF7-404A-9AC92EEEF9E74A06' 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 = '79CEC95F-CDF7-404A-9AC92EEEF9E74A06'
and product_variations.isactive = 1
and product_sizes.id_size = 2351
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 = '79CEC95F-CDF7-404A-9AC92EEEF9E74A06' 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 = '79CEC95F-CDF7-404A-9AC92EEEF9E74A06' 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 = '79CEC95F-CDF7-404A-9AC92EEEF9E74A06' 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 = '79CEC95F-CDF7-404A-9AC92EEEF9E74A06' 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 = '79CEC95F-CDF7-404A-9AC92EEEF9E74A06' 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 = '79CEC95F-CDF7-404A-9AC92EEEF9E74A06' 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 = '79CEC95F-CDF7-404A-9AC92EEEF9E74A06'
and product_variations.isactive = 1
and product_sizes.id_size = 2352
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 = '79CEC95F-CDF7-404A-9AC92EEEF9E74A06' 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 = '79CEC95F-CDF7-404A-9AC92EEEF9E74A06' 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 = '79CEC95F-CDF7-404A-9AC92EEEF9E74A06' 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 = '79CEC95F-CDF7-404A-9AC92EEEF9E74A06' 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 = '79CEC95F-CDF7-404A-9AC92EEEF9E74A06' 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 = '79CEC95F-CDF7-404A-9AC92EEEF9E74A06' 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 = '79CEC95F-CDF7-404A-9AC92EEEF9E74A06'
and product_variations.isactive = 1
and product_sizes.id_size = 2353
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 = '79CEC95F-CDF7-404A-9AC92EEEF9E74A06' 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 = '79CEC95F-CDF7-404A-9AC92EEEF9E74A06' 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 = '79CEC95F-CDF7-404A-9AC92EEEF9E74A06' 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 = '79CEC95F-CDF7-404A-9AC92EEEF9E74A06' 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 = '79CEC95F-CDF7-404A-9AC92EEEF9E74A06' 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 = '79CEC95F-CDF7-404A-9AC92EEEF9E74A06' 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 = '79CEC95F-CDF7-404A-9AC92EEEF9E74A06'
and product_variations.isactive = 1
and product_sizes.id_size = 2354
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 = '79CEC95F-CDF7-404A-9AC92EEEF9E74A06' 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 = '79CEC95F-CDF7-404A-9AC92EEEF9E74A06' 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 = '79CEC95F-CDF7-404A-9AC92EEEF9E74A06' 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 = '79CEC95F-CDF7-404A-9AC92EEEF9E74A06' 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 = '79CEC95F-CDF7-404A-9AC92EEEF9E74A06' 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 = '79CEC95F-CDF7-404A-9AC92EEEF9E74A06' 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 = '79CEC95F-CDF7-404A-9AC92EEEF9E74A06'
and product_variations.isactive = 1
and product_sizes.id_size = 2355
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
121836CCD-8CB0-4AAC-BE2F2D005969553B2355black#0000004XL4X50-5220-2224-2652-5452-5450-5256-5852-5450-52wdress4Xintlsize47.458333.2917{ts '2025-08-16 15:00:00'}STOCK01000-10000-10-10-10047.4583all
20908934A-4AB3-48D2-BE6F93CDBE7CC80D2355blue#0222934XL4X50-5220-2224-2652-5452-5450-5256-5852-5450-52wdress4Xintlsize47.458333.2917{ts '2025-08-16 15:00:00'}STOCK01000-10100-10-10-10047.4583all
31016B721-139F-4790-8170F09E15A0D7612355pink#FE70BD4XL4X50-5220-2224-2652-5452-5450-5256-5852-5450-52wdress4Xintlsize47.458333.2917{ts '2025-08-16 15:00:00'}STOCK01000-10100-10-10-10047.4583all
4FC068EE0-8C19-42E7-A9C8BCB38C9F1E6A2351black#0000000XLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42wdressXLintlsize47.458333.2917{ts '2025-08-16 15:00:00'}STOCK01000-10000-10-10-10047.4583all
55D14B1A7-22B0-4A9A-B70412A53D92B68C2351blue#0222930XLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42wdressXLintlsize47.458333.2917{ts '2025-08-16 15:00:00'}STOCK01000-10000-10-10-10047.4583all
66E90A954-890E-44EF-AB1EC1C73512FCDB2351pink#FE70BD0XLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42wdressXLintlsize47.458333.2917{ts '2025-08-16 15:00:00'}STOCK01000-10000-10-10-10047.4583all
722702779-9D50-4476-8A17F358FE412E5F2352black#0000001XL1X44-4614-1618-2046-4846-4844-4650-5246-4844-46wdress1Xintlsize47.458333.2917{ts '2025-08-16 15:00:00'}STOCK01000-10000-10-10-10047.4583all
85C72C7AA-F866-4B0A-9706CE2C6F24928A2352blue#0222931XL1X44-4614-1618-2046-4846-4844-4650-5246-4844-46wdress1Xintlsize47.458333.2917{ts '2025-08-16 15:00:00'}STOCK01000-10000-10-10-10047.4583all
99C244986-7FEA-45D7-9F198F49F516CC4D2352pink#FE70BD1XL1X44-4614-1618-2046-4846-4844-4650-5246-4844-46wdress1Xintlsize47.458333.2917{ts '2025-08-16 15:00:00'}STOCK01000-10000-10-10-10047.4583all
1063AD4447-BFB1-410A-82638D445F4050892353black#0000002XL2XL46-4816-1820-2248-5048-5046-4852-5448-5046-48wdress2XLintlsize47.458333.2917{ts '2025-08-16 15:00:00'}STOCK01000-10100-10-10-10047.4583all
11BE5D9881-96BE-4EC9-82B226C2107B475D2353blue#0222932XL2XL46-4816-1820-2248-5048-5046-4852-5448-5046-48wdress2XLintlsize47.458333.2917{ts '2025-08-16 15:00:00'}STOCK01000-10000-10-10-10047.4583all
1220A0E291-D997-4740-9EDBD357EE84CE1B2353pink#FE70BD2XL2XL46-4816-1820-2248-5048-5046-4852-5448-5046-48wdress2XLintlsize47.458333.2917{ts '2025-08-16 15:00:00'}STOCK01000-10000-10-10-10047.4583all
130B1234F5-9058-46F3-9628B9698D4B57942354black#0000003XL3X48-5018-2022-2450-5250-5248-5054-5650-5248-50wdress3Xintlsize47.458333.2917{ts '2025-08-16 15:00:00'}STOCK01000-10000-10-10-10047.4583all
143D1A37FA-4736-45F0-BCBAF4499140CD092354blue#0222933XL3X48-5018-2022-2450-5250-5248-5054-5650-5248-50wdress3Xintlsize47.458333.2917{ts '2025-08-16 15:00:00'}STOCK01000-10100-10-10-10047.4583all
15576FC8DA-C994-4F13-82943D4B84FA83592354pink#FE70BD3XL3X48-5018-2022-2450-5250-5248-5054-5650-5248-50wdress3Xintlsize47.458333.2917{ts '2025-08-16 15:00:00'}STOCK01000-10000-10-10-10047.4583all
vatrate
number20
warehouse
number0