Maten bekijken
Divine Élégance Maxi Dress - Split en laag uitgesneden voor de look van een godin
Dubbelklikken om te vergroten
SKU: CDBU0840
Divine Élégance Maxi Dress - Με σκίσιμο και χαμηλό ντεκολτέ για την εμφάνιση μιας θεάς
Voorraad:

Verfraai je figuur met onze maxi-jurk met hoge split, een creatie die elegantie en sensualiteit combineert. De Empire snit laat je buste prachtig uitkomen met de diep uitgesneden halslijn, terwijl de gewaagde split je benen subtiel onthult bij elke stap. Gemaakt van een ondoorzichtige stretchstof garandeert deze uitzonderlijke jurk absoluut comfort terwijl hij je de uitstraling van een Hollywoodster geeft.

Sterke punten

  • Uitpuilende V-halslijn die de buste prachtig doet uitkomen en in het oog springt
  • Universeel flatterend empire model dat bij alle lichaamsvormen past
  • Gedurfde zijsplit die het been elegant onthult en beweging vergemakkelijkt
  • Blote rug met nekband voor een dramatisch en sensueel effect
  • Elastische, ondoorzichtige stof voor optimaal comfort en een perfect omhuld silhouet
Maat:

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

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

Maxi-jurk met diep uitgesneden halsuitsnijding

Productomschrijving

De Divine Élégance maxi-jurk belichaamt de essentie van vrouwelijkheid met zijn geraffineerde en toch sensuele silhouet. De universeel flatterende empire snit creëert een harmonieuze lijn die de natuurlijke pluspunten van elk lichaamstype benadrukt.
De diepe V-hals is een van de belangrijkste kenmerken van deze creatie. De perfecte maat benadrukt de buste op elegante wijze en creëert een boeiend middelpunt dat op natuurlijke wijze de aandacht trekt. Dit zorgvuldige ontwerp zorgt ervoor dat elke vrouw zich begeerlijk en zelfverzekerd voelt.
De split aan de zijkant, die brutaal oploopt tot halverwege de dij, voegt een dynamische dimensie toe aan deze uitzonderlijke jurk. Het been wordt subtiel onthuld bij elke beweging, waardoor een sensueel verstoppertje wordt gespeeld dat de verleidelijke kracht versterkt. Deze strategische opening vergemakkelijkt ook de bewegingsvrijheid en combineert praktisch en esthetisch.
De achterkant van de jurk is net zo zorgvuldig ontworpen, met een elegante halssluiting die de rug sierlijk bloot laat . Deze opening creëert een fascinerende visuele lijn die de aandacht trekt als je wegloopt en zorgt voor een even opmerkelijke entree als een gedenkwaardige exit.
De ondoorzichtige stretchstof van hoge kwaliteit omhelst je rondingen zonder ze ooit samen te drukken.

De zachte textuur en stretch bieden uitzonderlijk comfort, zodat je deze jurk urenlang kunt dragen zonder het minste ongemak. De zorgvuldig geselecteerde stof zorgt ook voor een onberispelijke pasvorm die je figuur in beweging verbetert.

Technische details

  • Samenstelling : Hoogwaardige elastische ondoorzichtige stof
  • Stijl : Maxi-jurk met split, diepe halsuitsnijding en blote rug
  • Snit : Empire met hoge taille
  • Opvallende details: split opzij bij de dijen, nekbandje
  • Kleur: diepzwart
  • Onderhoud: Fijne was aanbevolen

Beschikbaar maten

Beschikbaar van 4X tot 3X

Beschikbaar kleur

Zwart

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

  • Handwas in koud water aanbevolen
  • Gebruik een milde zeep voor delicaat textiel
  • Grondig spoelen zonder wringen om de elasticiteit te behouden
  • Plat drogen in de schaduw, uit de buurt van warmtebronnen
  • Strijken op lage temperatuur indien nodig, bij voorkeur binnenstebuiten

Gebruikstips

Om deze lange jurk nog mooier te maken, kun je het nekbandje aanpassen aan je voorkeur voor een diepere of ondiepere halslijn.

De empire snit past zich op natuurlijke wijze aan je lichaamsvorm aan, maar je kunt de definitie van de taille accentueren door de drapering onder de buste iets aan te passen.

De zijsplit is ideaal geplaatst aan de zijkant van het been - je kunt hem iets naar voren of naar achteren plaatsen, afhankelijk van het gewenste effect. Voor optimaal comfort op lange avonden kies je voor naadloos ondergoed dat onzichtbaar blijft onder de vloeiende stof.

Stijltips

Voor een elegante avond combineer je deze maxi-jurk met sandalen met hoge hakken en een minimalistische clutch die niet afleidt van de opvallende snit. Gouden of zilveren sieraden passen perfect bij deze outfit - kies voor bungelende oorbellen en een slanke armband voor een perfecte balans met de diepe halslijn. Voor formele gelegenheden kan een sjaal of lichte stola over de schouders worden gedrapeerd en strategisch worden verwijderd om de blote rug te onthullen. Deze jurk kan ook worden aangepast met een dunne metallic riem net onder de buste om het empire model te accentueren. Als finishing touch verlengt een sensueel parfum de aura van vrouwelijkheid die deze creatie van nature uitstraalt.

To Top
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.749 ms
Record Count: 1
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_colors.color as recorduid, product_colors.type, product_colors.code, product_colors.color, product_colors.range, product_colors.hexvalue,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock
from product_colors
left outer join product_variations on product_colors.color = product_variations.color and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
where FIND_IN_SET(product_colors.color,'black') > 0
and product_variations.productuid = '002B6A2A-9B25-45EE-ACE6ADB3B0964BB5'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1blackcolorblakblackblack#000000-10
colorrange
stringblack
colors
stringblack
colortype
stringcolor
comments
string
compositions
Struct
Entries: 13
coton
string
elastane
string
free
string
leather
string
lycra
string
metal
string
nylon
string
polyamide
string
polyester
string
polyurethane
string
silk
string
spandex
string
viscose
string
datecreated
Date Time (Europe/Paris)
{ts '2025-05-25 19:38:10'}
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
number48.2917
itempromo
string
key
stringsz2411058191297111
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-09-12 16:17:11'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.631 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','el')
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('002b6a2a-9b25-45ee-ace6adb3b0964bb5',lcase(cart_actions.linkedproducts)) > 0 and cart_actions.linkedproducts is not null
)
id_actionbrandinglanguagenamecodetypeminimumOrdermaximumOrderminimumItemsmaximumItemsmaximumUseallowedItemsquotasusedCountlinkedproductslinkedthemeslinkedbrandslinkeditemparamsactiveFromactiveToisActive
linkedproducts
Query
Template: /system/api/products.cfc:1305
Execution Time: 1.32 ms
Record Count: 0
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select products.productuid as productuid, products.reference, 'default' as type, products.key, products.language, products.name,
product_links.linkuid,
products.colors, products.vatrate, products.metadatas, products.dimensions,
products.mediadatas, products.tags, products.themes, products.isdivasize,
count(distinct product_variations.variationuid) as totalvariations,
group_concat(distinct product_variations.variationuid) as variationlist,
count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END) as inpromo,
if(count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END)>0,1,0) as haspromo,
(select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0) END)) as itempromo,
IFNULL(min(product_variations.itemprice),0) as itemprice,
(select IF (products.isfixedprice = 0 and sum(product_variations.itempromo) > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null), IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0), IFNULL(min(NULLIF(product_variations.itemprice, 0)), 0) )) as unitprice,
count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.itempromo ELSE product_variations.itemprice END) as prices,
(select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN min(NULLIF(product_variations.promountil, 0)) END)) as promountil,
products.isfixedprice, products.ishot, products.isnew, if(products.orderidx > 0, products.orderidx, 999999999) as orderidx,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
count(distinct CASE WHEN ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) > 0 OR ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) <= 0 AND product_variations.supplier = 0)) THEN product_variations.variationuid END) as instockvariations,
products.brand, brands.name as brandname, IFNULL(brands.ispublic, 0) as showbrand, brands.display,
product_categories.sizetype,GROUP_CONCAT(DISTINCT product_sizes.suppliersize) as intlsize,products.sizes,product_sizes.sizerange,product_categories.mediadatas as categorymediadatas, product_categories.sizerange as categorysizerange,
product_categorymap.section, product_categorymap.category, product_categorymap.key as subcategory
from products
left outer join product_categorymap on products.productuid = product_categorymap.productuid
left outer join product_categories on (product_categories.branding = product_categorymap.branding and product_categories.section = product_categorymap.section and product_categories.category = product_categorymap.category and product_categories.key = product_categorymap.key)
left outer join product_sizes on product_sizes.id_size IN (products.sizes)
left outer join brands on products.brand = brands.brand
left outer join product_variations on product_variations.productuid = products.productuid and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
left outer join product_links on product_links.reference = products.reference
where products.isactive = 1 and products.isdeleted = 0
and brands.isactive = 1 and brands.isdeleted = 0
and product_categories.isactive = 1 and product_categories.isdeleted = 0
and product_variations.isactive = 1
and FIND_IN_SET('divasboudoir',products.branding)
and product_categories.branding IN ('all','divasboudoir')
and product_categorymap.branding IN ('all','divasboudoir')
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and products.language in ('all','el')
and product_categories.language in ('all','el')
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 <> 'CDBU0840'
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
string1873
isprivate
string0
rating
stringall
src
string/photobank/products/dvqc/cdbu0840/longue-robe-fendue-grande-taille.jpg
type
stringimg
width
string1296
back
Struct
height
string1870
isprivate
string0
rating
stringall
src
string/photobank/products/dvqc/cdbu0840/longue-robe-fendue-grande-taille1.jpg
type
stringimg
width
string1294
default
Struct
height
string1873
isprivate
string0
rating
stringall
src
string/photobank/products/dvqc/cdbu0840/longue-robe-fendue-grande-taille.jpg
type
stringimg
width
string1296
variations
Struct
colors
Struct
black
Struct
height
string1870
isprivate
string0
rating
stringall
src
string/photobank/products/dvqc/cdbu0840/longue-robe-fendue-grande-taille1.jpg
type
stringimg
width
string1294
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
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
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
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
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
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
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
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
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
divasboudoir
Struct
de
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Handwäsche mit kaltem Wasser empfohlen.</li> <li>Verwenden Sie eine milde Seife speziell für empfindliche Textilien</li> <li>Gründlich spülen, ohne zu wringen, um die Elastizität zu erhalten.</li> <li>Liegend im Schatten trocknen, nicht in der Nähe von Wärmequellen</li> <li>Bei Bedarf bei niedriger Temperatur bügeln, am besten von links</li> </ul>
description
string<p>Das lange Kleid Divine &Eacute;l&eacute;gance verkörpert mit seiner raffinierten und zugleich sinnlichen Silhouette die Quintessenz der Weiblichkeit. Der allgemein schmeichelhafte <strong>Empire-Schnitt</strong> schafft eine harmonische Linie, die die natürlichen Vorzüge jeder Körperform hervorhebt.<br>Das <strong>tiefe V-Dekollet&eacute;</strong> ist eines der Markenzeichen dieser Kreation. Es ist perfekt dimensioniert, betont die Brüste auf elegante Weise und schafft gleichzeitig einen fesselnden Fokus, der die Blicke natürlich auf sich zieht. Durch dieses sorgfältige Design fühlt sich jede Frau begehrenswert und selbstbewusst.<br>Der Seitenschlitz, der kühn bis zur Mitte des Oberschenkels ansteigt, verleiht diesem außergewöhnlichen Kleid eine dynamische Dimension. Er enthüllt bei jeder Bewegung subtil das Bein und schafft so ein sinnliches Versteckspiel, das seine <strong>Verführungskraft</strong> intensiviert. Diese strategische Öffnung erleichtert auch die Bewegungsfreiheit und vereint so Praktikabilität und Ästhetik.<br>Die Rückseite des Kleides offenbart ein ebenso sorgfältiges Design mit einem eleganten Halsband, das den Rücken anmutig <strong>entblößt</strong>. Diese Öffnung schafft eine faszinierende visuelle Linie, die die Aufmerksamkeit auf sich zieht, wenn Sie sich entfernen, und garantiert einen ebenso bemerkenswerten Auftritt wie einen unvergesslichen Abgang.<br>Der hochwertige, blickdichte und elastische Stoff schmiegt sich perfekt an Ihre Kurven an, ohne sie einzuengen.</p> <p>Die weiche Textur und die Dehnbarkeit sorgen für einen <strong>außergewöhnlichen Tragekomfort</strong>, sodass Sie das Kleid stundenlang ohne jegliche Beschwerden tragen können. Das sorgfältig ausgewählte Material sorgt außerdem für einen makellosen Fall, der Ihre bewegte Silhouette umwerfend aussehen lässt.</p>
guid
stringhttps://dev.divasboudoir.com/de/sexy-kleider-schwarz/cdbu0840.htm
highlights
string<ul> <li>Tiefer V-Ausschnitt, der die Brust wunderschön betont und die Blicke auf sich zieht</li> <li>Universell schmeichelhafter Empire-Schnitt, der sich jeder Körperform anpasst</li> <li>Gewagter Seitenschlitz, der das Bein elegant enthüllt und die Bewegungen erleichtert</li> <li>Rückenfrei mit Neckholder für einen dramatischen und sinnlichen Effekt</li> <li>Elastischer, blickdichter Stoff bietet optimalen Tragekomfort und eine perfekt umhüllte Silhouette</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringEntdecken Sie unser langes Kleid in großen Größen mit Schlitz am Oberschenkel und tiefem Ausschnitt. Schmeichelnder Empire-Schnitt für alle Körperformen. Diskrete Lieferung!
keywords
string
title
stringLanges Kleid Grosse Grösse Geschlitzt Tiefliegender Ausschnitt | Diva's Boudoir
seotitle
stringLanges Kleid in Übergröße mit Schlitz und tiefem Ausschnitt
seouri
stringsexy-kleider-schwarz
specifications
string<ul> <li>Zusammensetzung: Hochwertiger, elastischer, blickdichter Stoff.</li> <li>Stil: Langes, geschlitztes Kleid mit tiefem Ausschnitt und Neckholder</li> <li>Schnitt: Empire mit markanter hoher Taille</li> <li>Unterscheidende Details: Seitenschlitz am Oberschenkel, Neckholder</li> <li>Farbe: Tiefschwarz</li> <li>Pflege: Feinwäsche empfohlen</li> </ul>
stylingtips
string<p>Für einen eleganten Abend kombinieren Sie dieses lange Kleid mit hochhackigen Sandalen und einer minimalistischen Clutch, die nicht von seinem bemerkenswerten Schnitt ablenken. Goldener oder silberner Schmuck rundet das Outfit perfekt ab - entscheiden Sie sich für Hängeohrringe und ein schmales Armband, um ein perfektes Gleichgewicht mit dem tiefen Ausschnitt herzustellen. Bei formellen Anlässen kann ein leichter Schal oder eine Stola über die Schultern drapiert werden, die Sie strategisch entfernen sollten, um den nackten Rücken freizulegen. Dieses Kleid eignet sich auch für eine individuelle Gestaltung mit einem schmalen Metallgürtel, der direkt unter der Brust platziert wird, um den Empire-Schnitt noch stärker zu betonen. Für den letzten Schliff verlängert ein Parfüm mit sinnlichen Noten die Aura der Weiblichkeit, die diese Kreation von Natur aus ausstrahlt.</p>
summary
string<p>Veredeln Sie Ihre Silhouette mit unserem langen, am Oberschenkel geschlitzten Kleid, einer Kreation, die Eleganz und Sinnlichkeit vereint. Der Empire-Schnitt bringt Ihre Brust mit seinem tiefen Ausschnitt wunderbar zur Geltung, während der gewagte Schlitz Ihr Bein bei jedem Schritt subtil enthüllt. Dieses außergewöhnliche Kleid aus blickdichtem, elastischem Stoff garantiert Ihnen absoluten Tragekomfort und lässt Sie wie einen Hollywood-Star aussehen.</p>
title
stringLanges Kleid Divine Élégance - Geschlitzt und tief ausgeschnitten für den Look einer Göttin
usageinstructions
string<p>Um dieses lange Kleid zu betonen, stellen Sie den Neckholder entsprechend Ihrer Vorliebe für ein mehr oder weniger tiefes Dekollet&eacute; ein.</p> <p>Der Empire-Schnitt passt sich natürlich Ihrer Körperform an, aber Sie können die Definition der Taille betonen, indem Sie die Drapierung unter der Brust leicht anpassen.</p> <p>Der Seitenschlitz sitzt ideal an der Seite des Beins - je nach gewünschtem Effekt können Sie ihn leicht nach vorne oder hinten platzieren. Für optimalen Tragekomfort an langen Abenden wählen Sie nahtlose Unterwäsche, die unter dem fließenden Stoff unsichtbar bleibt.</p>
el
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Συνιστάται πλύσιμο στο χέρι με κρύο νερό</li> <li>Χρησιμοποιήστε ένα ήπιο σαπούνι για ευαίσθητα υφάσματα</li> <li>Ξεπλύνετε καλά χωρίς στύψιμο για να διατηρήσετε την ελαστικότητα</li> <li>Στεγνώνετε επίπεδα στη σκιά, μακριά από κάθε πηγή θερμότητας</li> <li>Σιδερώστε σε χαμηλή θερμοκρασία αν χρειαστεί, κατά προτίμηση με την ανάποδη πλευρά προς τα έξω</li> </ul>
description
string<p>Το μάξι φόρεμα Divine &Eacute;l&eacute;gance ενσαρκώνει την πεμπτουσία της θηλυκότητας με την εκλεπτυσμένη και ταυτόχρονα αισθησιακή σιλουέτα του. Το καθολικά κολακευτικό <strong>αυτοκρατορικό</strong> του <strong>κόψιμο</strong> δημιουργεί μια αρμονική γραμμή που αναδεικνύει τα φυσικά πλεονεκτήματα κάθε σωματότυπου.<br>Η <strong>βαθιά V-λαιμός</strong> είναι ένα από τα χαρακτηριστικά γνωρίσματα αυτής της δημιουργίας. Με τέλειο μέγεθος, τονίζει κομψά το μπούστο, ενώ δημιουργεί ένα μαγευτικό σημείο εστίασης που τραβάει φυσικά τα βλέμματα. Αυτός ο προσεγμένος σχεδιασμός κάνει κάθε γυναίκα να αισθάνεται επιθυμητή και με αυτοπεποίθηση.<br>Το πλαϊνό σκίσιμο, που ανεβαίνει τολμηρά μέχρι το μέσο του μηρού, προσθέτει μια δυναμική διάσταση σε αυτό το εξαιρετικό φόρεμα. Αποκαλύπτει διακριτικά το πόδι με κάθε κίνηση, δημιουργώντας ένα αισθησιακό παιχνίδι κρυφτού που εντείνει τη <strong>σαγηνευτική</strong> του δύναμη. Αυτό το στρατηγικό άνοιγμα διευκολύνει επίσης την ελευθερία κινήσεων, συνδυάζοντας πρακτικότητα και αισθητική.<br>Το πίσω μέρος του φορέματος είναι εξίσου προσεκτικά σχεδιασμένο, με ένα κομψό κούμπωμα στο λαιμό που αφήνει την πλάτη χαριτωμένα <strong>γυμνή.</strong> Αυτό το άνοιγμα δημιουργεί μια συναρπαστική οπτική γραμμή που αιχμαλωτίζει την προσοχή καθώς απομακρύνεστε, εξασφαλίζοντας μια είσοδο τόσο αξιοσημείωτη όσο και μια αξέχαστη έξοδο.<br>Το αδιαφανές, υψηλής ποιότητας ελαστικό ύφασμα αγκαλιάζει τις καμπύλες σας χωρίς ποτέ να τις συμπιέζει.</p> <p>Η απαλή υφή και το τέντωμά του προσφέρουν <strong>εξαιρετική άνεση</strong>, επιτρέποντάς σας να φοράτε αυτό το φόρεμα για ώρες χωρίς την παραμικρή ενόχληση. Το προσεκτικά επιλεγμένο ύφασμα εξασφαλίζει επίσης άψογη εφαρμογή που αναδεικνύει τη σιλουέτα σας εν κινήσει.</p>
guid
stringhttps://dev.divasboudoir.com/el/sexi-foremata-mayro/cdbu0840.htm
highlights
string<ul> <li>Το βαθύ ντεκολτέ V ενισχύει υπέροχα το μπούστο και τραβάει το βλέμμα</li> <li>Καθολικά κολακευτικό αυτοκρατορικό κόψιμο που ταιριάζει σε όλα τα σχήματα σώματος</li> <li>Τολμηρό πλαϊνό σκίσιμο που αποκαλύπτει κομψά το πόδι και διευκολύνει την κίνηση</li> <li>Γυμνή πλάτη με δέσιμο στο λαιμό για δραματικό και αισθησιακό αποτέλεσμα</li> <li>Ελαστικό αδιαφανές ύφασμα για βέλτιστη άνεση και τέλεια περιποιημένη σιλουέτα</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringΑνακαλύψτε το plus-size μάξι φόρεμά μας με σκίσιμο μέχρι τον μηρό και βαθύ ντεκολτέ. Κολακευτικό αυτοκρατορικό κόψιμο για όλα τα σχήματα σώματος. Διακριτική παράδοση!
keywords
string
title
stringΜακρύ φόρεμα μεγάλο μέγεθος σχισμή Plunging ντεκολτέ | Μπουντουάρ της Ντίβας
seotitle
stringΜάξι φόρεμα με σχισμή στη λαιμόκοψη
seouri
stringsexi-foremata-mayro
specifications
string<ul> <li>Σύνθεση : Υψηλής ποιότητας ελαστικό αδιαφανές ύφασμα</li> <li>Στυλ : Μάξι φόρεμα με σκίσιμο, βαθύ ντεκολτέ και γυμνή πλάτη</li> <li>Κοπή : Αυτοκρατορικό με ψηλή σημαδεμένη μέση</li> <li>Χαρακτηριστικές λεπτομέρειες : Πλευρικό σκίσιμο στο μηρό, δέσιμο στο λαιμό</li> <li>Χρώμα: βαθύ μαύρο</li> <li>Φροντίδα: Συνιστάται απαλό πλύσιμο</li> </ul>
stylingtips
string<p>Για μια κομψή βραδιά, συνδυάστε αυτό το μάξι φόρεμα με ψηλοτάκουνα πέδιλα και ένα μίνιμαλ clutch που δεν θα αποσπάσει την προσοχή από το εντυπωσιακό του κόψιμο. Τα χρυσά ή ασημένια κοσμήματα θα συμπληρώσουν τέλεια αυτό το ντύσιμο - επιλέξτε κρεμαστά σκουλαρίκια και ένα λεπτό βραχιόλι για την τέλεια ισορροπία με το βαθύ ντεκολτέ. Για επίσημες περιστάσεις, ένα σάλι ή μια ελαφριά σκολάτα μπορεί να απλωθεί στους ώμους και να αφαιρεθεί στρατηγικά για να αποκαλυφθεί η γυμνή πλάτη. Αυτό το φόρεμα μπορεί επίσης να προσαρμοστεί με μια λεπτή μεταλλική ζώνη που τοποθετείται ακριβώς κάτω από το μπούστο για να τονίσει το αυτοκρατορικό κόψιμο. Για την τελική πινελιά, ένα αισθησιακό άρωμα θα παρατείνει την αύρα θηλυκότητας που αποπνέει φυσικά αυτή η δημιουργία.</p>
summary
string<p>Αναδείξτε τη σιλουέτα σας με το μάξι φόρεμά μας με σκίσιμο μέχρι τον μηρό, μια δημιουργία που συνδυάζει κομψότητα και αισθησιασμό. Το αυτοκρατορικό του κόψιμο αναδεικνύει υπέροχα το μπούστο σας με τη βαθιά του λαιμόκοψη, ενώ το τολμηρό του σκίσιμο αποκαλύπτει διακριτικά το πόδι σας σε κάθε σας βήμα. Κατασκευασμένο από αδιαφανές, ελαστικό ύφασμα, αυτό το εξαιρετικό φόρεμα εγγυάται απόλυτη άνεση, ενώ σας χαρίζει την εμφάνιση μιας σταρ του Χόλιγουντ.</p>
title
stringDivine Élégance Maxi Dress - Με σκίσιμο και χαμηλό ντεκολτέ για την εμφάνιση μιας θεάς
usageinstructions
string<p>Για να ενισχύσετε αυτό το μακρύ φόρεμα, προσαρμόστε το δέσιμο στο λαιμό ανάλογα με την προτίμησή σας για πιο βαθύ ή πιο ρηχό ντεκολτέ.</p> <p>Το αυτοκρατορικό κόψιμο προσαρμόζεται φυσικά στο σχήμα του σώματός σας, αλλά μπορείτε να τονίσετε τον ορισμό της μέσης ρυθμίζοντας ελαφρώς το τύλιγμα κάτω από το μπούστο.</p> <p>Το πλαϊνό σκίσιμο είναι ιδανικά τοποθετημένο στο πλάι του ποδιού - μπορείτε να το τοποθετήσετε ελαφρώς προς τα εμπρός ή προς τα πίσω ανάλογα με το επιθυμητό αποτέλεσμα. Για βέλτιστη άνεση στις μεγάλες βραδιές, επιλέξτε εσώρουχα χωρίς ραφές που θα παραμείνουν αόρατα κάτω από το ρέον ύφασμα.</p>
en
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Hand wash in cold water recommended</li> <li>Use a mild soap for delicate textiles</li> <li>Rinse thoroughly without wringing to preserve elasticity</li> <li>Dry flat in the shade, away from sources of heat</li> <li>Iron at low temperature if necessary, preferably inside out</li> </ul>
description
string<p>The Divine &Eacute;l&eacute;gance long dress embodies the quintessence of femininity with its sophisticated yet sensual silhouette. Its universally flattering <strong>empire cut</strong> creates a harmonious line that highlights the natural assets of every body type.<br>The <strong>plunging V-neckline</strong> is one of the signature elements of this creation. Perfectly sized, it sublimates the bust with elegance, creating a captivating focal point that naturally draws the eye. This meticulous design makes every woman feel desirable and confident.<br>The side slit, boldly rising to mid-thigh, adds a dynamic dimension to this exceptional dress. It subtly reveals the leg with every movement, creating a sensual game of hide-and-seek that intensifies its <strong>seductive</strong> power. This strategic opening also facilitates freedom of movement, combining practicality and aesthetics.<br>The back of the dress reveals an equally meticulous design, with an elegant neck tie that leaves the back gracefully <strong>bare.</strong> This opening creates a fascinating visual line that captures attention as you walk away, guaranteeing an entrance as remarkable as a memorable exit.<br>The opaque, high-grade stretch fabric perfectly hugs your curves without ever compressing them.</p> <p>Its soft texture and stretch offer <strong>exceptional comfort</strong>, allowing you to wear this dress for hours without the slightest discomfort. This carefully selected fabric also ensures an impeccable fit that enhances your figure on the move.</p>
guid
stringhttps://dev.divasboudoir.com/en/sexy-dresses-black/cdbu0840.htm
highlights
string<ul> <li>Plunging V-neckline that magnificently enhances the bust and draws the eye</li> <li>Universally flattering empire cut to suit every body type</li> <li>Bold side slit that elegantly reveals the leg and facilitates movement</li> <li>Bare back with neck tie for dramatic, sensual effect</li> <li>Elastic opaque fabric for optimum comfort and a perfectly sheathed silhouette</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringDiscover our plus size long dress with thigh-high slit and plunging neckline. Flattering empire cut for all body types. Discreet delivery!
keywords
string
title
stringPlus Size Slit Plunging Neckline Maxi Dress | Diva's Boudoir
seotitle
stringPlus size long dress with slit and plunging neckline
seouri
stringsexy-dresses-black
specifications
string<ul> <li>Composition: High-quality elastic opaque fabric</li> <li>Style: Slit maxi dress with plunging neckline and bare back</li> <li>Cut: Empire with marked high waist</li> <li>Distinctive details: Side thigh slit, neck tie</li> <li>Color: deep black</li> <li>Care: Delicate wash recommended</li> </ul>
stylingtips
string<p>For an elegant evening, team this maxi dress with high-heeled sandals and a minimalist clutch that won't distract from its striking cut. Gold or silver jewelry will complete this outfit perfectly - opt for dangling earrings and a slender bracelet for a perfect balance with the plunging neckline. For formal occasions, a shawl or light stole can be draped over the shoulders, strategically removed to reveal the bare back. This dress also lends itself to customization with a thin metallic belt placed just below the bust to further accentuate the empire cut. For a finishing touch, a perfume with sensual notes will prolong the aura of femininity this creation naturally exudes.</p>
summary
string<p>Sublimate your silhouette with our thigh-high slit maxi dress, a creation that combines elegance and sensuality. Its Empire cut beautifully enhances your bust with a plunging neckline, while its bold slit subtly reveals your leg with every step. Made from an opaque, stretch fabric, this exceptional dress guarantees absolute comfort while giving you the look of a Hollywood star.</p>
title
stringDivine Élégance Maxi Dress - Slit and low-cut for a goddess-like look
usageinstructions
string<p>To enhance this long dress, adjust the neck tie according to your preference for a deeper or shallower neckline.</p> <p>The empire cut naturally adapts to your morphology, but you can accentuate the definition of the waist by slightly adjusting the drape under the bust.</p> <p>The side slit is ideally positioned on the side of the leg - you can place it slightly forward or backward, depending on the desired effect. For optimum comfort on long evenings, opt for seamless undergarments that remain invisible beneath the flowing fabric.</p>
es
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Se recomienda lavar a mano en agua fría</li> <li>Utilizar un jabón suave para tejidos delicados</li> <li>Aclarar a fondo sin escurrir para conservar la elasticidad</li> <li>Secar en plano a la sombra, lejos de cualquier fuente de calor</li> <li>Planchar a baja temperatura si es necesario, preferiblemente del revés</li> </ul>
description
string<p>El maxivestido Divine &Eacute;l&eacute;gance encarna la quintaesencia de la feminidad con su silueta sofisticada y sensual a la vez. Su <strong>corte imperio</strong>, universalmente favorecedor, crea una línea armoniosa que realza los atributos naturales de cada tipo de cuerpo.<br>El <strong>escote en V</strong> es uno de los rasgos distintivos de esta creación. Su tamaño perfecto realza con elegancia el busto y crea un cautivador punto focal que atrae naturalmente las miradas. Este cuidado diseño hace que toda mujer se sienta deseable y segura de sí misma.<br>La abertura lateral, que se eleva audazmente hasta medio muslo, añade una dimensión dinámica a este vestido excepcional. Revela sutilmente la pierna con cada movimiento, creando un sensual juego del escondite que intensifica su poder <strong>seductor</strong>. Esta abertura estratégica también facilita la libertad de movimientos, combinando practicidad y estética.<br>La parte trasera del vestido está igual de cuidada, con un elegante cierre en el cuello que deja la espalda graciosamente <strong>al descubierto.</strong> Esta abertura crea una fascinante línea visual que capta la atención al alejarse, asegurando una entrada tan notable como una salida memorable.<br>El tejido opaco y elástico de alta calidad abraza sus curvas sin comprimirlas en ningún momento.</p> <p>Su textura suave y su elasticidad ofrecen <strong>una comodidad excepcional</strong>, permitiéndole llevar este vestido durante horas sin la menor incomodidad. El tejido cuidadosamente seleccionado también garantiza un ajuste impecable que realza su figura en movimiento.</p>
guid
stringhttps://dev.divasboudoir.com/es/vestido-sexy-negro/cdbu0840.htm
highlights
string<ul> <li>Escote en V que realza magníficamente el busto y atrae todas las miradas</li> <li>Corte imperio universalmente favorecedor que se adapta a todas las formas del cuerpo</li> <li>Atrevida abertura lateral que deja ver la pierna con elegancia y facilita el movimiento</li> <li>Espalda descubierta con lazada en el cuello para un efecto espectacular y sensual</li> <li>Tejido opaco elástico para un confort óptimo y una silueta perfectamente enfundada</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringDescubre nuestro vestido maxi de talla grande con abertura hasta el muslo y escote pronunciado. Corte imperio muy favorecedor. ¡Entrega discreta!
keywords
string
title
stringVestido largo talla grande escote pronunciado | Diva's Boudoir
seotitle
stringVestido talla grande con escote palabra de honor
seouri
stringvestido-sexy-negro
specifications
string<ul> <li>Composición : Tejido opaco elástico de alta calidad</li> <li>Estilo : Maxivestido con abertura, escote pronunciado y espalda descubierta</li> <li>Corte : Imperio con cintura alta marcada</li> <li>Detalles distintivos : Abertura lateral en el muslo, lazo en el cuello</li> <li>Color: negro intenso</li> <li>Cuidados: Se recomienda un lavado delicado</li> </ul>
stylingtips
string<p>Para una noche elegante, combina este vestido maxi con sandalias de tacón y un bolso de mano minimalista que no distraiga la atención de su llamativo corte. Las joyas doradas o plateadas complementarán a la perfección este atuendo: opta por unos pendientes colgantes y una pulsera fina para conseguir un equilibrio perfecto con el escote pronunciado. Para las ocasiones formales, se puede colocar un chal o una estola ligera sobre los hombros y retirarla estratégicamente para dejar al descubierto la espalda. Este vestido también puede personalizarse con un fino cinturón metálico colocado justo debajo del pecho para acentuar el corte imperio. Como toque final, un perfume sensual prolongará el aura de feminidad que desprende naturalmente esta creación.</p>
summary
string<p>Sublima tu figura con nuestro maxivestido con abertura hasta el muslo, una creación que combina elegancia y sensualidad. Su corte imperio realza el busto gracias a su escote pronunciado, mientras que su atrevida abertura deja entrever sutilmente la pierna a cada paso. Confeccionado en un tejido opaco y elástico, este vestido excepcional le garantiza una comodidad absoluta, al tiempo que le confiere el aspecto de una estrella de Hollywood.</p>
title
stringMaxi Vestido Divine Élégance - Abertura y escote para un look de diosa
usageinstructions
string<p>Para realzar este vestido largo, ajuste el lazo del cuello según su preferencia por un escote más o menos pronunciado.</p> <p>El corte imperio se adapta naturalmente a la forma de tu cuerpo, pero puedes acentuar la definición de la cintura ajustando ligeramente la caída bajo el busto.</p> <p>La abertura lateral está idealmente situada en el lateral de la pierna - puedes colocarla ligeramente hacia delante o hacia atrás según el efecto deseado. Para un confort óptimo en las largas veladas, opte por una ropa interior sin costuras que permanecerá invisible bajo el vaporoso tejido.</p>
fr
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavage &agrave; la main &agrave; l'eau froide recommand&eacute;</li> <li>Utiliser un savon doux sp&eacute;cial textiles d&eacute;licats</li> <li>Rincer abondamment sans tordre pour pr&eacute;server l'&eacute;lasticit&eacute;</li> <li>S&eacute;chage &agrave; plat &agrave; l'ombre, loin de toute source de chaleur</li> <li>Repasser &agrave; basse temp&eacute;rature si n&eacute;cessaire, de pr&eacute;f&eacute;rence sur l'envers</li> </ul>
description
string<p>La robe longue Divine &Eacute;l&eacute;gance incarne la quintessence de la f&eacute;minit&eacute; avec sa silhouette &agrave; la fois sophistiqu&eacute;e et sensuelle. Sa <strong>coupe empire</strong>, universellement flatteuse, cr&eacute;e une ligne harmonieuse qui met en valeur les atouts naturels de chaque morphologie.<br>Le <strong>d&eacute;collet&eacute; plongeant en V</strong> constitue l'un des &eacute;l&eacute;ments signature de cette cr&eacute;ation. Parfaitement dimensionn&eacute;, il sublime la poitrine avec &eacute;l&eacute;gance tout en cr&eacute;ant un point focal captivant qui attire naturellement le regard. Cette conception soign&eacute;e permet &agrave; chaque femme de se sentir d&eacute;sirable et confiante.<br>La fente lat&eacute;rale, montant audacieusement jusqu'&agrave; mi-cuisse, apporte une dimension dynamique &agrave; cette robe d'exception. Elle d&eacute;voile subtilement la jambe &agrave; chaque mouvement, cr&eacute;ant un jeu de cache-cache sensuel qui intensifie son pouvoir de <strong>s&eacute;duction</strong>. Cette ouverture strat&eacute;gique facilite &eacute;galement la libert&eacute; de mouvement, alliant ainsi praticit&eacute; et esth&eacute;tique.<br>Le dos de la robe r&eacute;v&egrave;le une conception tout aussi soign&eacute;e avec son &eacute;l&eacute;gante attache au cou qui laisse le dos gracieusement <strong>d&eacute;nud&eacute;</strong>. Cette ouverture cr&eacute;e une ligne visuelle fascinante qui captive l'attention lorsque vous vous &eacute;loignez, garantissant une entr&eacute;e aussi remarquable qu'une sortie m&eacute;morable.<br>Le tissu opaque et &eacute;lastique de qualit&eacute; sup&eacute;rieure &eacute;pouse parfaitement vos courbes sans jamais les comprimer.</p> <p>Sa texture douce et son extensibilit&eacute; offrent un <strong>confort exceptionnel</strong>, vous permettant de porter cette robe pendant des heures sans la moindre g&ecirc;ne. Cette mati&egrave;re soigneusement s&eacute;lectionn&eacute;e assure &eacute;galement un tomb&eacute; impeccable qui sublime votre silhouette en mouvement.</p>
guid
stringhttps://dev.divasboudoir.com/fr/robe-longue-fendue-decollete-plongeant/cdbu0840.htm
highlights
string<ul> <li>D&eacute;collet&eacute; plongeant en V qui sublime magnifiquement la poitrine et attire le regard</li> <li>Coupe empire universellement flatteuse qui s'adapte &agrave; toutes les morphologies</li> <li>Fente lat&eacute;rale audacieuse qui d&eacute;voile &eacute;l&eacute;gamment la jambe et facilite les mouvements</li> <li>Dos nu avec attache au cou pour un effet dramatique et sensuel</li> <li>Tissu opaque &eacute;lastique offrant un confort optimal et une silhouette parfaitement gain&eacute;e</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringDécouvrez notre robe longue grande taille avec fente sur la cuisse et décolleté plongeant. Coupe empire flatteuse pour toutes les morphologies. Livraison discrète !
keywords
string
title
stringRobe Longue Grande Taille Fendue Décolleté Plongeant | Diva's Boudoir
seotitle
stringRobe longue grande taille fendue décolleté plongeant
seouri
stringrobe-longue-fendue-decollete-plongeant
specifications
string<ul> <li>Composition : Tissu opaque &eacute;lastique de haute qualit&eacute;</li> <li>Style : Robe longue fendue avec d&eacute;collet&eacute; plongeant et dos nu</li> <li>Coupe : Empire avec taille haute marqu&eacute;e</li> <li>D&eacute;tails distinctifs : Fente lat&eacute;rale sur la cuisse, attache au cou</li> <li>Couleur : noir profond</li> <li>Entretien : Lavage d&eacute;licat recommand&eacute;</li> </ul>
stylingtips
string<p>Pour une soir&eacute;e &eacute;l&eacute;gante, associez cette robe longue &agrave; des sandales &agrave; talons hauts et une pochette minimaliste qui ne d&eacute;tourneront pas l'attention de sa coupe remarquable. Les bijoux dor&eacute;s ou argent&eacute;s compl&egrave;teront parfaitement cette tenue - optez pour des boucles d'oreilles pendantes et un bracelet fin pour un &eacute;quilibre parfait avec le d&eacute;collet&eacute; plongeant. Pour les occasions formelles, un ch&acirc;le ou une &eacute;tole l&eacute;g&egrave;re peut &ecirc;tre drap&eacute; sur les &eacute;paules, &agrave; retirer strat&eacute;giquement pour r&eacute;v&eacute;ler le dos nu. Cette robe se pr&ecirc;te &eacute;galement &agrave; une customisation avec une fine ceinture m&eacute;tallique plac&eacute;e juste sous la poitrine pour accentuer encore la coupe empire. Pour une touche finale, un parfum aux notes sensuelles prolongera l'aura de f&eacute;minit&eacute; que cette cr&eacute;ation d&eacute;gage naturellement.</p>
summary
string<p>Sublimez votre silhouette avec notre robe longue fendue sur la cuisse, une cr&eacute;ation qui allie &eacute;l&eacute;gance et sensualit&eacute;. Sa coupe Empire met admirablement en valeur votre poitrine gr&acirc;ce &agrave; son d&eacute;collet&eacute; plongeant, tandis que sa fente audacieuse d&eacute;voile subtilement votre jambe &agrave; chaque pas. Confectionn&eacute;e dans un tissu opaque et &eacute;lastique, cette robe d'exception vous garantit un confort absolu tout en vous offrant une allure de star hollywoodienne.</p>
title
stringRobe Longue Divine Élégance - Fendue et décolletée pour une allure de déesse
usageinstructions
string<p>Pour sublimer cette robe longue, ajustez l'attache au cou selon votre pr&eacute;f&eacute;rence pour un d&eacute;collet&eacute; plus ou moins profond.</p> <p>La coupe empire s'adapte naturellement &agrave; votre morphologie, mais vous pouvez accentuer la d&eacute;finition de la taille en ajustant l&eacute;g&egrave;rement le drap&eacute; sous la poitrine.</p> <p>La fente lat&eacute;rale se positionne id&eacute;alement sur le c&ocirc;t&eacute; de la jambe - vous pouvez la placer l&eacute;g&egrave;rement vers l'avant ou l'arri&egrave;re selon l'effet d&eacute;sir&eacute;. Pour un confort optimal lors des longues soir&eacute;es, optez pour des sous-v&ecirc;tements sans coutures qui resteront invisibles sous le tissu fluide.</p>
it
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Si consiglia il lavaggio a mano in acqua fredda</li> <li>Utilizzare un sapone delicato per i tessuti delicati</li> <li>Risciacquare accuratamente senza strizzare per preservare l'elasticità</li> <li>Asciugare in piano all'ombra, lontano da qualsiasi fonte di calore</li> <li>Se necessario, stirare a bassa temperatura, preferibilmente al rovescio</li> </ul>
description
string<p>Il maxi abito Divine &Eacute;l&eacute;gance incarna la quintessenza della femminilità con la sua silhouette sofisticata e sensuale. Il suo <strong>taglio impero</strong>, universalmente lusinghiero, crea una linea armoniosa che mette in risalto le caratteristiche naturali di ogni tipo di corpo.<br>La <strong>scollatura a V</strong> è uno dei tratti distintivi di questa creazione. Perfettamente dimensionato, valorizza elegantemente il seno e crea un punto focale accattivante che attira naturalmente lo sguardo. Questo design accurato fa sentire ogni donna desiderabile e sicura di sé.<br>Lo spacco laterale, che sale audacemente a metà coscia, aggiunge una dimensione dinamica a questo abito eccezionale. Ad ogni movimento scopre sottilmente la gamba, creando un sensuale gioco di nascondino che ne intensifica il potere <strong>seduttivo</strong>. Questa apertura strategica facilita inoltre la libertà di movimento, unendo praticità ed estetica.<br>La parte posteriore dell'abito è altrettanto curata, con un'elegante allacciatura al collo che lascia la schiena graziosamente <strong>scoperta.</strong> Questa apertura crea un'affascinante linea visiva che cattura l'attenzione mentre si cammina, assicurando un'entrata notevole e un'uscita memorabile.<br>Il tessuto opaco ed elasticizzato di alta qualità abbraccia le vostre curve senza mai comprimerle.</p> <p>La sua consistenza morbida e l'elasticità offrono un <strong>comfort eccezionale</strong>, permettendovi di indossare questo abito per ore senza il minimo disagio. Il tessuto accuratamente selezionato assicura inoltre una vestibilità impeccabile che valorizza la vostra figura anche in movimento.</p>
guid
stringhttps://dev.divasboudoir.com/it/abiti-sexy-nero/cdbu0840.htm
highlights
string<ul> <li>La scollatura a V esalta il busto e cattura gli sguardi</li> <li>Taglio impero universalmente lusinghiero che si adatta a tutte le forme del corpo</li> <li>Audace spacco laterale che scopre elegantemente la gamba e facilita i movimenti</li> <li>Schiena nuda con laccetto al collo per un effetto drammatico e sensuale</li> <li>Tessuto elastico e coprente per un comfort ottimale e una silhouette perfettamente inguainata</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringScoprite il nostro maxi abito taglia grande con spacco sulla coscia e scollatura profonda. Taglio impero lusinghiero per tutte le forme del corpo. Consegna discreta!
keywords
string
title
stringAbito lungo Taglia grande con fessura e scollatura, Diva's Boudoir
seotitle
stringMaxi abito con spacco e scollatura profonda
seouri
stringabiti-sexy-nero
specifications
string<ul> <li>Composizione : Tessuto elastico opaco di alta qualità</li> <li>Stile : maxi abito con spacco, scollatura e schiena scoperta</li> <li>Taglio : Impero con vita alta segnata</li> <li>Dettagli distintivi: spacco laterale sulla coscia, laccetto sul collo</li> <li>Colore: nero profondo</li> <li>Cura: si consiglia un lavaggio delicato</li> </ul>
stylingtips
string<p>Per una serata elegante, abbinate questo maxi abito a sandali con tacco alto e a una pochette minimalista che non distragga dal suo taglio sorprendente. I gioielli in oro o argento completeranno perfettamente questo outfit: optate per orecchini pendenti e un braccialetto sottile per un perfetto equilibrio con la scollatura profonda. Per le occasioni formali, si può drappeggiare sulle spalle uno scialle o una stola leggera, da togliere strategicamente per scoprire la schiena nuda. Questo abito può anche essere personalizzato con una sottile cintura metallica posizionata appena sotto il seno per accentuare il taglio impero. Per un tocco finale, un profumo sensuale prolungherà l'aura di femminilità che questa creazione emana naturalmente.</p>
summary
string<p>Sublimate la vostra figura con il nostro maxi abito con spacco alle cosce, una creazione che unisce eleganza e sensualità. Il suo taglio impero mette in risalto il busto grazie alla scollatura profonda, mentre lo spacco audace lascia intravedere le gambe a ogni passo. Realizzato in tessuto opaco ed elasticizzato, questo abito eccezionale garantisce un comfort assoluto e vi regala un look da star di Hollywood.</p>
title
stringMaxi abito Divine Élégance - Spacco e scollatura per un look da dea
usageinstructions
string<p>Per valorizzare questo abito lungo, regolate il laccetto del collo in base alla vostra preferenza per una scollatura più profonda o meno profonda.</p> <p>Il taglio impero si adatta naturalmente alla forma del corpo, ma è possibile accentuare la definizione della vita regolando leggermente il drappeggio sotto il seno.</p> <p>Lo spacco laterale è posizionato in modo ideale sul lato della gamba: potete posizionarlo leggermente in avanti o indietro a seconda dell'effetto desiderato. Per un comfort ottimale nelle lunghe serate, optate per una biancheria intima senza cuciture che rimarrà invisibile sotto il tessuto fluente.</p>
nl
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Handwas in koud water aanbevolen</li> <li>Gebruik een milde zeep voor delicaat textiel</li> <li>Grondig spoelen zonder wringen om de elasticiteit te behouden</li> <li>Plat drogen in de schaduw, uit de buurt van warmtebronnen</li> <li>Strijken op lage temperatuur indien nodig, bij voorkeur binnenstebuiten</li> </ul>
description
string<p>De Divine &Eacute;l&eacute;gance maxi-jurk belichaamt de essentie van vrouwelijkheid met zijn geraffineerde en toch sensuele silhouet. De universeel flatterende <strong>empire snit</strong> creëert een harmonieuze lijn die de natuurlijke pluspunten van elk lichaamstype benadrukt.<br>De <strong>diepe V-hals</strong> is een van de belangrijkste kenmerken van deze creatie. De perfecte maat benadrukt de buste op elegante wijze en creëert een boeiend middelpunt dat op natuurlijke wijze de aandacht trekt. Dit zorgvuldige ontwerp zorgt ervoor dat elke vrouw zich begeerlijk en zelfverzekerd voelt.<br>De split aan de zijkant, die brutaal oploopt tot halverwege de dij, voegt een dynamische dimensie toe aan deze uitzonderlijke jurk. Het been wordt subtiel onthuld bij elke beweging, waardoor een sensueel verstoppertje wordt gespeeld dat de <strong>verleidelijke</strong> kracht versterkt. Deze strategische opening vergemakkelijkt ook de bewegingsvrijheid en combineert praktisch en esthetisch.<br>De achterkant van de jurk is net zo zorgvuldig ontworpen, met een elegante halssluiting die de rug sierlijk <strong>bloot</strong> laat <strong>.</strong> Deze opening creëert een fascinerende visuele lijn die de aandacht trekt als je wegloopt en zorgt voor een even opmerkelijke entree als een gedenkwaardige exit.<br>De ondoorzichtige stretchstof van hoge kwaliteit omhelst je rondingen zonder ze ooit samen te drukken.</p> <p>De zachte textuur en stretch bieden <strong>uitzonderlijk comfort</strong>, zodat je deze jurk urenlang kunt dragen zonder het minste ongemak. De zorgvuldig geselecteerde stof zorgt ook voor een onberispelijke pasvorm die je figuur in beweging verbetert.</p>
guid
stringhttps://dev.divasboudoir.com/nl/sexy-outfit-zwart/cdbu0840.htm
highlights
string<ul> <li>Uitpuilende V-halslijn die de buste prachtig doet uitkomen en in het oog springt</li> <li>Universeel flatterend empire model dat bij alle lichaamsvormen past</li> <li>Gedurfde zijsplit die het been elegant onthult en beweging vergemakkelijkt</li> <li>Blote rug met nekband voor een dramatisch en sensueel effect</li> <li>Elastische, ondoorzichtige stof voor optimaal comfort en een perfect omhuld silhouet</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringOntdek onze maxi-jurk van grote maat met dijhoge split en diep uitgesneden halslijn. Flatterende empire snit voor alle lichaamsvormen. Discrete levering!
keywords
string
title
stringLange jurk grote maat Plunging Décolleté | Diva's Boudoir
seotitle
stringMaxi-jurk met diep uitgesneden halsuitsnijding
seouri
stringsexy-outfit-zwart
specifications
string<ul> <li>Samenstelling : Hoogwaardige elastische ondoorzichtige stof</li> <li>Stijl : Maxi-jurk met split, diepe halsuitsnijding en blote rug</li> <li>Snit : Empire met hoge taille</li> <li>Opvallende details: split opzij bij de dijen, nekbandje</li> <li>Kleur: diepzwart</li> <li>Onderhoud: Fijne was aanbevolen</li> </ul>
stylingtips
string<p>Voor een elegante avond combineer je deze maxi-jurk met sandalen met hoge hakken en een minimalistische clutch die niet afleidt van de opvallende snit. Gouden of zilveren sieraden passen perfect bij deze outfit - kies voor bungelende oorbellen en een slanke armband voor een perfecte balans met de diepe halslijn. Voor formele gelegenheden kan een sjaal of lichte stola over de schouders worden gedrapeerd en strategisch worden verwijderd om de blote rug te onthullen. Deze jurk kan ook worden aangepast met een dunne metallic riem net onder de buste om het empire model te accentueren. Als finishing touch verlengt een sensueel parfum de aura van vrouwelijkheid die deze creatie van nature uitstraalt.</p>
summary
string<p>Verfraai je figuur met onze maxi-jurk met hoge split, een creatie die elegantie en sensualiteit combineert. De Empire snit laat je buste prachtig uitkomen met de diep uitgesneden halslijn, terwijl de gewaagde split je benen subtiel onthult bij elke stap. Gemaakt van een ondoorzichtige stretchstof garandeert deze uitzonderlijke jurk absoluut comfort terwijl hij je de uitstraling van een Hollywoodster geeft.</p>
title
stringDivine Élégance Maxi Dress - Split en laag uitgesneden voor de look van een godin
usageinstructions
string<p>Om deze lange jurk nog mooier te maken, kun je het nekbandje aanpassen aan je voorkeur voor een diepere of ondiepere halslijn.</p> <p>De empire snit past zich op natuurlijke wijze aan je lichaamsvorm aan, maar je kunt de definitie van de taille accentueren door de drapering onder de buste iets aan te passen.</p> <p>De zijsplit is ideaal geplaatst aan de zijkant van het been - je kunt hem iets naar voren of naar achteren plaatsen, afhankelijk van het gewenste effect. Voor optimaal comfort op lange avonden kies je voor naadloos ondergoed dat onzichtbaar blijft onder de vloeiende stof.</p>
pt
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Recomenda-se a lavagem à mão em água fria</li> <li>Utilizar um sabão suave para têxteis delicados</li> <li>Enxaguar bem sem torcer para preservar a elasticidade</li> <li>Secar à sombra, longe de qualquer fonte de calor</li> <li>Se necessário, passar a ferro a baixa temperatura, de preferência do avesso</li> </ul>
description
string<p>O vestido maxi Divine &Eacute;l&eacute;gance encarna a quintessência da feminilidade com a sua silhueta sofisticada mas sensual. O seu <strong>corte império</strong>, universalmente lisonjeador, cria uma linha harmoniosa que realça os atributos naturais de cada tipo de corpo.<br>O <strong>decote em V profundo</strong> é uma das caraterísticas desta criação. De tamanho perfeito, realça elegantemente o busto, criando um ponto focal cativante que atrai naturalmente o olhar. Este design cuidado faz com que todas as mulheres se sintam desejáveis e confiantes.<br>A fenda lateral, que sobe corajosamente até meio da coxa, acrescenta uma dimensão dinâmica a este vestido excecional. Revela subtilmente a perna em cada movimento, criando um jogo sensual de esconde-esconde que intensifica o seu poder <strong>de sedução</strong>. Esta abertura estratégica também facilita a liberdade de movimentos, combinando praticidade e estética.<br>A parte de trás do vestido é igualmente cuidada, com um elegante fecho no pescoço que deixa as costas graciosamente <strong>nuas.</strong> Esta abertura cria uma linha visual fascinante que capta a atenção à medida que se afasta, garantindo uma entrada tão notável como uma saída memorável.<br>O tecido elástico opaco e de alta qualidade envolve as suas curvas sem nunca as comprimir.</p> <p>A sua textura suave e a sua elasticidade oferecem <strong>um conforto excecional</strong>, permitindo-lhe usar este vestido durante horas sem o mínimo desconforto. O tecido cuidadosamente selecionado garante também um ajuste impecável que realça a sua figura em movimento.</p>
guid
stringhttps://dev.divasboudoir.com/pt/vestido-sexy-preto/cdbu0840.htm
highlights
string<ul> <li>O decote em V profundo realça magnificamente o busto e chama a atenção</li> <li>Corte império universalmente lisonjeiro para se adaptar a todas as formas do corpo</li> <li>Fenda lateral ousada que revela elegantemente a perna e facilita o movimento</li> <li>Costas nuas com laço no pescoço para um efeito dramático e sensual</li> <li>Tecido elástico opaco para um conforto ótimo e uma silhueta perfeitamente cingida</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringDescubra o nosso vestido maxi plus size com fenda até à altura da coxa e decote profundo. Corte império lisonjeiro para todas as formas do corpo. Entrega discreta!
keywords
string
title
stringVestido comprido Tamanho grande com fenda Decote profundo | Diva's Boudoir
seotitle
stringVestido maxi com decote profundo e fenda
seouri
stringvestido-sexy-preto
specifications
string<ul> <li>Composição : Tecido elástico opaco de alta qualidade</li> <li>Estilo : Vestido maxi com fendas, decote profundo e costas nuas</li> <li>Corte : Império com cintura alta marcada</li> <li>Detalhes distintivos: Fenda lateral na coxa, laço no pescoço</li> <li>Cor: preto profundo</li> <li>Cuidados: Lavagem delicada recomendada</li> </ul>
stylingtips
string<p>Para uma noite elegante, combine este vestido maxi com sandálias de salto alto e uma clutch minimalista que não distraia do seu corte marcante. As jóias douradas ou prateadas complementarão este conjunto na perfeição - opte por brincos pendentes e uma pulseira fina para um equilíbrio perfeito com o decote profundo. Para ocasiões formais, um xaile ou uma estola leve podem ser colocados sobre os ombros, estrategicamente retirados para revelar as costas nuas. Este vestido também pode ser personalizado com um cinto metálico fino colocado mesmo abaixo do busto para acentuar o corte império. Para um toque final, um perfume sensual prolongará a aura de feminilidade que esta criação naturalmente exala.</p>
summary
string<p>Sublime a sua figura com o nosso vestido maxi com fenda até à altura da coxa, uma criação que combina elegância e sensualidade. O seu corte império deixa o seu busto à mostra com o seu decote profundo, enquanto a sua fenda ousada revela subtilmente a sua perna a cada passo. Confeccionado num tecido opaco e elástico, este vestido excecional garante um conforto absoluto, ao mesmo tempo que lhe dá o aspeto de uma estrela de Hollywood.</p>
title
stringDivine Élégance Maxi Dress - Fenda e decote para um look de deusa
usageinstructions
string<p>Para realçar este vestido comprido, ajuste o laço do pescoço de acordo com a sua preferência por um decote mais profundo ou mais raso.</p> <p>O corte império adapta-se naturalmente à forma do seu corpo, mas pode acentuar a definição da cintura ajustando ligeiramente o drapeado sob o busto.</p> <p>A fenda lateral está idealmente posicionada no lado da perna - pode colocá-la ligeiramente para a frente ou para trás, dependendo do efeito desejado. Para um conforto ótimo em noites longas, opte por roupa interior sem costuras que ficará invisível sob o tecido esvoaçante.</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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
name
stringsz2411058191297111
netweight
string
nextshipment
stringtomorrow
ordered
number3
orderidx
number0
origin
string
originalsize
string
packaging
number0
productshipment
stringauto
productuid
string002B6A2A-9B25-45EE-ACE6ADB3B0964BB5
promountil
string
rating
stringnone
recorduid
string002B6A2A-9B25-45EE-ACE6ADB3B0964BB5
reference
stringCDBU0840
related
string
reserved
number1
returned
number0
returnsallowed
number1
section
stringcabaret
shipment
string5to7days
showbrand
number0
sizeinfos
Query
Template: /system/api/product/sizes.cfc:20
Execution Time: 1.35 ms
Record Count: 5
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_sizes.id_size as recorduid, if(intlsize <> '',intlsize,eusize) as size, if(intlsize <> '','intlsize','eusize') as sizetype,
product_variations.color,
if(product_sizes.sizegroup = 'bra',
if(intlsize <> '', cast(intlsize as SIGNED ), cast(eusize as SIGNED ))
,
SUBSTRING_INDEX(intlsize,'-',1)
) as param1,
if(product_sizes.sizegroup = 'bra',
if(intlsize <> '',
MID(intlsize,length(cast(intlsize as SIGNED ))+1,length(intlsize)),
MID(eusize,length(cast(eusize as SIGNED ))+1,length(eusize))
)
,
SUBSTRING_INDEX(intlsize,'-',-1)
) as param2,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as available,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
999999,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as groupavailable,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
product_sizes.gender, product_sizes.sizerange, product_sizes.sizegroup, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize,
product_sizes.bust, product_sizes.waist, product_sizes.hip, product_sizes.underbust, product_sizes.cup, product_sizes.thigh, product_sizes.legheight, product_sizes.bodyheight, product_sizes.bodyweight
from product_sizes
left outer join product_variations on product_sizes.suppliersize = product_variations.size and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
where FIND_IN_SET(product_sizes.id_size,'2334,2335,2336,2337,2338') > 0
and product_variations.productuid = '002B6A2A-9B25-45EE-ACE6ADB3B0964BB5'
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
123384Xintlsizeblack4X4X-19999990wplusdress4XL4X502024525250565250128-134107-112133-140
22334XLintlsizeblackXLXL-19999990wplusdress0XLXL421216444442484442100-10779-86105-112
323351Xintlsizeblack1X1X-19999990wplusdress1XL1X441418464644504644107-11486-93112-119
423362XLintlsizeblack2XL2XL-19999990wplusdress2XL2XL461620484846524846114-12193-100119-126
523373Xintlsizeblack3X3X-19999990wplusdress3XL3X481822505048545048121-128100-107126-133
sizeranges
stringplus
sizes
string2334,2335,2336,2337,2338
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: 57.4 ms
Record Count: 5
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 = '002B6A2A-9B25-45EE-ACE6ADB3B0964BB5'
and product_variations.isactive = 1
and product_sizes.id_size = 2334
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 = '002B6A2A-9B25-45EE-ACE6ADB3B0964BB5'
and product_variations.isactive = 1
and product_sizes.id_size = 2335
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 = '002B6A2A-9B25-45EE-ACE6ADB3B0964BB5'
and product_variations.isactive = 1
and product_sizes.id_size = 2336
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 = '002B6A2A-9B25-45EE-ACE6ADB3B0964BB5'
and product_variations.isactive = 1
and product_sizes.id_size = 2337
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 = '002B6A2A-9B25-45EE-ACE6ADB3B0964BB5'
and product_variations.isactive = 1
and product_sizes.id_size = 2338
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
1002B6A2A-9B25-45EE-ACE6ADB3B0964BB5DFE5ED3E-4760-4FF7-9432AD3BEC5A2A192338black#0000004XL4X502024525250565250wdress4Xintlsize48.291737.4583{ts '2025-09-13 14:00:00'}STOCK01000-10100-10all
2002B6A2A-9B25-45EE-ACE6ADB3B0964BB54EFB1C6C-7A12-4D13-B6ED1650C350566B2334black#0000000XLXL421216444442484442wdressXLintlsize48.291737.4583{ts '2025-09-13 14:00:00'}STOCK01000-112002153772E8QGAY0556401252-10all
3002B6A2A-9B25-45EE-ACE6ADB3B0964BB50D71B880-1AE8-411C-BDCB762FCC7273672335black#0000001XL1X441418464644504644wdress1Xintlsize48.291737.4583{ts '2025-09-13 14:00:00'}STOCK01000-102002153772E8QGAY0556401247-10all
4002B6A2A-9B25-45EE-ACE6ADB3B0964BB5ED4410CA-5308-4DEC-908579A85FBC34702336black#0000002XL2XL461620484846524846wdress2XLintlsize48.291737.4583{ts '2025-09-13 14:00:00'}STOCK01000-10000-10all
5002B6A2A-9B25-45EE-ACE6ADB3B0964BB51D24350B-7CF3-4377-849C81AA607327542337black#0000003XL3X481822505048545048wdress3Xintlsize48.291737.4583{ts '2025-09-13 14:00:00'}STOCK01000-10100-10all
subcategory
stringall
supplier
number-1
supplierreference
stringSZ2411058191297111
tags
string
themes
string
totalvariations
number5
type
stringdefault
unitprice
number48.2917
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 8.85 ms
Record Count: 5
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '002B6A2A-9B25-45EE-ACE6ADB3B0964BB5' 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 = '002B6A2A-9B25-45EE-ACE6ADB3B0964BB5' 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 = '002B6A2A-9B25-45EE-ACE6ADB3B0964BB5' 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 = '002B6A2A-9B25-45EE-ACE6ADB3B0964BB5' 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 = '002B6A2A-9B25-45EE-ACE6ADB3B0964BB5' 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 = '002B6A2A-9B25-45EE-ACE6ADB3B0964BB5' 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 = '002B6A2A-9B25-45EE-ACE6ADB3B0964BB5'
and product_variations.isactive = 1
and product_sizes.id_size = 2334
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 = '002B6A2A-9B25-45EE-ACE6ADB3B0964BB5' 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 = '002B6A2A-9B25-45EE-ACE6ADB3B0964BB5' 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 = '002B6A2A-9B25-45EE-ACE6ADB3B0964BB5' 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 = '002B6A2A-9B25-45EE-ACE6ADB3B0964BB5' 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 = '002B6A2A-9B25-45EE-ACE6ADB3B0964BB5' 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 = '002B6A2A-9B25-45EE-ACE6ADB3B0964BB5' 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 = '002B6A2A-9B25-45EE-ACE6ADB3B0964BB5'
and product_variations.isactive = 1
and product_sizes.id_size = 2335
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 = '002B6A2A-9B25-45EE-ACE6ADB3B0964BB5' 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 = '002B6A2A-9B25-45EE-ACE6ADB3B0964BB5' 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 = '002B6A2A-9B25-45EE-ACE6ADB3B0964BB5' 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 = '002B6A2A-9B25-45EE-ACE6ADB3B0964BB5' 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 = '002B6A2A-9B25-45EE-ACE6ADB3B0964BB5' 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 = '002B6A2A-9B25-45EE-ACE6ADB3B0964BB5' 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 = '002B6A2A-9B25-45EE-ACE6ADB3B0964BB5'
and product_variations.isactive = 1
and product_sizes.id_size = 2336
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 = '002B6A2A-9B25-45EE-ACE6ADB3B0964BB5' 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 = '002B6A2A-9B25-45EE-ACE6ADB3B0964BB5' 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 = '002B6A2A-9B25-45EE-ACE6ADB3B0964BB5' 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 = '002B6A2A-9B25-45EE-ACE6ADB3B0964BB5' 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 = '002B6A2A-9B25-45EE-ACE6ADB3B0964BB5' 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 = '002B6A2A-9B25-45EE-ACE6ADB3B0964BB5' 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 = '002B6A2A-9B25-45EE-ACE6ADB3B0964BB5'
and product_variations.isactive = 1
and product_sizes.id_size = 2337
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 = '002B6A2A-9B25-45EE-ACE6ADB3B0964BB5' 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 = '002B6A2A-9B25-45EE-ACE6ADB3B0964BB5' 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 = '002B6A2A-9B25-45EE-ACE6ADB3B0964BB5' 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 = '002B6A2A-9B25-45EE-ACE6ADB3B0964BB5' 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 = '002B6A2A-9B25-45EE-ACE6ADB3B0964BB5' 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 = '002B6A2A-9B25-45EE-ACE6ADB3B0964BB5' 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 = '002B6A2A-9B25-45EE-ACE6ADB3B0964BB5'
and product_variations.isactive = 1
and product_sizes.id_size = 2338
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
1DFE5ED3E-4760-4FF7-9432AD3BEC5A2A192338black#0000004XL4X502024525250565250wdress4Xintlsize48.291737.4583{ts '2025-09-13 14:00:00'}STOCK01000-10100-10-10-10048.2917all
24EFB1C6C-7A12-4D13-B6ED1650C350566B2334black#0000000XLXL421216444442484442wdressXLintlsize48.291737.4583{ts '2025-09-13 14:00:00'}STOCK01000-112002153772E8QGAY0556401252-10-10-10048.2917all
30D71B880-1AE8-411C-BDCB762FCC7273672335black#0000001XL1X441418464644504644wdress1Xintlsize48.291737.4583{ts '2025-09-13 14:00:00'}STOCK01000-102002153772E8QGAY0556401247-10-10-10048.2917all
4ED4410CA-5308-4DEC-908579A85FBC34702336black#0000002XL2XL461620484846524846wdress2XLintlsize48.291737.4583{ts '2025-09-13 14:00:00'}STOCK01000-10000-10-10-10048.2917all
51D24350B-7CF3-4377-849C81AA607327542337black#0000003XL3X481822505048545048wdress3Xintlsize48.291737.4583{ts '2025-09-13 14:00:00'}STOCK01000-10100-10-10-10048.2917all
vatrate
number20
warehouse
number0