Mi cesta

❌
Total de artículos
Ver cesta
Menú
Ver tallas
Vestido asimétrico con velo negro - Dramática elegancia y sofisticación
Doble clic para ampliar
SKU: CDBU3069
Vestido asimétrico con velo negro - Dramática elegancia y sofisticación
Stock:

Descubre este vestido asimétrico de gasa negra que revoluciona el arte de la elegancia moderna Sus hombros al descubierto y sus detalles transparentes crean un efecto espectacular.

Con su caída natural y su largo midi perfecto, esta creación transforma cada aparición en un momento de pura sofisticación.

Puntos destacados

  • Moderno diseño asimétrico con espectacular hombro descubierto
  • El velo transparente revela con sofisticación
  • Esculpida caída natural que abraza tus curvas a la perfección
  • Elegante largo midi, ni demasiado corto ni demasiado largo
  • Corte favorecedor y ceñido para todo tipo de cuerpos
  • negro atemporal para todos los tonos de piel
  • Efecto de capas opacas y transparentes perfectamente dominado
  • Silueta icónica para veladas elegantes y eventos especiales
Talla:

¿No sabe qué talla elegir? Consulte nuestra guía de tallas

Color:
Cantidad:
49.95 €
Ayuda y consejos
por chat, facebook o correo electrónico
Devoluciones gratuitas
en un plazo de 15 días *

Talla grande asimétrica de gasa negra con hombro descubierto

Descripción del producto

Este vestido asimétrico revoluciona los códigos de la elegancia con su diseño moderno y rompedor. El hombro al descubierto crea un impactante efecto dramático que atrae inmediatamente las miradas, revelando tu audacia con absoluta sofisticación.

El velo transparente de la parte inferior añade una dimensión sensual controlada que juega sutilmente entre la revelación y el misterio. Esta superposición opaca-transparente crea un juego visual cautivador que revela lo justo con gran clase. La caída natural abraza suavemente sus curvas sin constreñir, creando una silueta esculpida que realza con naturalidad todo tipo de cuerpos. El estudiado corte resalta tus activos sin llegar a ser vulgar. El largo midi, perfectamente equilibrado, aporta una elegancia atemporal que ha superado la prueba del tiempo.

Esta proporción revela sus piernas con sofisticación, conservando la clase absoluta que caracteriza a las grandes creaciones. Atemporal, el negro profundo sublima todos los tonos de piel y se adapta a todas las ocasiones, desde las veladas más elegantes hasta los eventos más prestigiosos. Este color revela su gusto por la excelencia y su fuerte sentido del estilo. Cuando llevas este vestido, ya no pasas desapercibida: te conviertes en ese icono de estilo moderno que hipnotiza con una gracia asimétrica y un aura magnética irresistible.

Detalles técnicos

  • Tipo : Vestido midi asimétrico
  • Color : Negro intenso
  • Diseño : Hombros descubiertos con efecto dramático
  • Material : Voile transparente y tejido opaco
  • Largo : Elegante midi
  • Corte: ceñido al cuerpo con caída natural
  • Estilo: Sofisticado y moderno
  • Ocasiones: Veladas elegantes y eventos especiales

Tallas disponibles

Disponible de 4X a 3X

Color disponible

Negro

Guía de tallas

Comprueba cuál es tu talla

Internacional
  • Pecho
  • Talla
  • Caderas
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

Consejos de cuidado

  • Lavar a mano en agua fría para preservar el voile
  • Utilizar un detergente suave sin blanqueantes
  • Séquelo en plano para mantener la forma del velo
  • Nunca planchar directamente sobre el velo transparente
  • Cuélguelo suavemente para evitar arrugas
  • Guárdelo en una funda para proteger el delicado tejido

Consejos de uso

Deslice suavemente este vestido, teniendo cuidado con el velo transparente. La caída asimétrica se coloca de forma natural para crear esa silueta icónica que te distingue. El corte ceñido se adapta a su silueta sin constreñirla, permitiéndole una total libertad de movimientos.

Este vestido se adapta perfectamente a todas las formas del cuerpo gracias a su estudiado diseño y a sus materiales flexibles. Llévalo con confianza para revelar tu lado más sofisticado en tus veladas más elegantes.

Consejos de estilo

Realza tu vestido con nuestras finas medias talla grande para un sofisticado look total black, o añade nuestra ropa de dormir negra talla grande para conseguir la armonía perfecta.

Completa el look con nuestros vestidos sexys talla grande para crear un vestuario elegante, o explora nuestros conjuntos sexys talla grande para looks más sofisticados. Esta creación única revela tu sentido del estilo con una inquietante elegancia moderna.

To Top
Ver cesta
Artículos
Total de artículos
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.751 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 = '9FAA34B1-01C4-4877-BACCC4F0E820BCC9'
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-07-23 17:35:15'}
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
number1
isactive
number1
iscustommade
number0
isdivasize
number0
isfirstprice
number0
isfixedprice
number0
ishot
number0
isnew
number0
isonline
number0
isoutletprice
number0
itemprice
number41.625
itempromo
string
key
stringsz2410311303517507
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-08-07 12:00:34'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.632 ms
Record Count: 0
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select cart_actions.*
from cart_actions
where cart_actions.branding IN ('all','divasboudoir')
and cart_actions.language IN ('all','es')
and (cart_actions.quotas = -1 or (cart_actions.usedCount < cart_actions.quotas))
and cart_actions.isactive = 1
and (date(cart_actions.activeFrom) <= '2025-11-24' OR cart_actions.activeFrom is null)
and (date(cart_actions.activeTo) >= '2025-11-24' OR cart_actions.activeTo is null)
and (
FIND_IN_SET('9faa34b1-01c4-4877-baccc4f0e820bcc9',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.35 ms
Record Count: 0
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select products.productuid as productuid, products.reference, 'default' as type, products.key, products.language, products.name,
product_links.linkuid,
products.colors, products.vatrate, products.metadatas, products.dimensions,
products.mediadatas, products.tags, products.themes, products.isdivasize,
count(distinct product_variations.variationuid) as totalvariations,
group_concat(distinct product_variations.variationuid) as variationlist,
count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END) as inpromo,
if(count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END)>0,1,0) as haspromo,
(select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0) END)) as itempromo,
IFNULL(min(product_variations.itemprice),0) as itemprice,
(select IF (products.isfixedprice = 0 and sum(product_variations.itempromo) > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null), IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0), IFNULL(min(NULLIF(product_variations.itemprice, 0)), 0) )) as unitprice,
count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.itempromo ELSE product_variations.itemprice END) as prices,
(select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN min(NULLIF(product_variations.promountil, 0)) END)) as promountil,
products.isfixedprice, products.ishot, products.isnew, if(products.orderidx > 0, products.orderidx, 999999999) as orderidx,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
count(distinct CASE WHEN ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) > 0 OR ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) <= 0 AND product_variations.supplier = 0)) THEN product_variations.variationuid END) as instockvariations,
products.brand, brands.name as brandname, IFNULL(brands.ispublic, 0) as showbrand, brands.display,
product_categories.sizetype,GROUP_CONCAT(DISTINCT product_sizes.suppliersize) as intlsize,products.sizes,product_sizes.sizerange,product_categories.mediadatas as categorymediadatas, product_categories.sizerange as categorysizerange,
product_categorymap.section, product_categorymap.category, product_categorymap.key as subcategory
from products
left outer join product_categorymap on products.productuid = product_categorymap.productuid
left outer join product_categories on (product_categories.branding = product_categorymap.branding and product_categories.section = product_categorymap.section and product_categories.category = product_categorymap.category and product_categories.key = product_categorymap.key)
left outer join product_sizes on product_sizes.id_size IN (products.sizes)
left outer join brands on products.brand = brands.brand
left outer join product_variations on product_variations.productuid = products.productuid and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
left outer join product_links on product_links.reference = products.reference
where products.isactive = 1 and products.isdeleted = 0
and brands.isactive = 1 and brands.isdeleted = 0
and product_categories.isactive = 1 and product_categories.isdeleted = 0
and product_variations.isactive = 1
and FIND_IN_SET('divasboudoir',products.branding)
and product_categories.branding IN ('all','divasboudoir')
and product_categorymap.branding IN ('all','divasboudoir')
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and products.language in ('all','es')
and product_categories.language in ('all','es')
and (products.displayFrom <= DATE(NOW()) or products.displayFrom is null)
and (products.displayTo >= DATE(NOW()) or products.displayTo IS null)
and product_links.linkuid = '' and product_links.linkuid is not null and product_links.linkuid <> ''
and products.reference <> 'CDBU3069'
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
string1644
isprivate
string0
rating
stringall
src
string/photobank/products/dvqc/cdbu3069/robe_grande_taille_asymetrique_voile_noire_dos.jpg
type
stringimg
width
string1137
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string1641
isprivate
string0
rating
stringall
src
string/photobank/products/dvqc/cdbu3069/robe_grande_taille_asymetrique_voile_noire.jpg
type
stringimg
width
string1135
variations
Struct
colors
Struct
black
Struct
height
string1641
isprivate
string0
rating
stringall
src
string/photobank/products/dvqc/cdbu3069/robe_grande_taille_asymetrique_voile_noire.jpg
type
stringimg
width
string1135
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, um den Schleier zu erhalten</li> <li>Verwenden Sie ein mildes Waschmittel ohne Bleichmittel</li> <li>Flach trocknen, um die Form des Drapierens zu erhalten.</li> <li>Niemals direkt über den transparenten Schleier bügeln</li> <li>Vorsichtig aufhängen, um Falten zu vermeiden</li> <li>In einer Hülle aufbewahren, um den empfindlichen Stoff zu schützen</li> </ul>
description
string<p>Dieses asymmetrische Kleid revolutioniert die Codes der Eleganz mit seinem <strong>modernen Design, das mit allen Konventionen bricht</strong>. Die entblößte Schulter erzeugt einen atemberaubenden dramatischen Effekt, der sofort alle Blicke auf sich zieht und Ihre Kühnheit mit absoluter Raffinesse offenbart.</p> <p>Der <strong>transparente Schleier am unteren Teil</strong> fügt eine kontrollierte sinnliche Dimension hinzu, die subtil zwischen Enthüllung und Geheimnis spielt. Diese opak-transparente Überlagerung schafft ein fesselndes visuelles Spiel, das mit großer Klasse genau das Richtige enthüllt. Die <strong>natürliche Drapierung</strong> schmiegt sich sanft an Ihre Kurven, ohne einzuengen, und schafft diese wohlgeformte Silhouette, die <strong>jeden Körperbau auf natürliche Weise hervorhebt</strong>. Der durchdachte Schnitt hebt Ihre Vorzüge hervor, ohne jemals vulgär zu wirken. Die <strong>perfekt ausbalancierte Midi-Länge</strong> sorgt für eine zeitlose Eleganz, die die Epochen überdauert.</p> <p>Diese Proportion enthüllt Ihre Beine auf raffinierte Weise und bewahrt gleichzeitig die absolute Klasse, die große Kreationen auszeichnet. Das <strong>zeitlose Tiefschwarz</strong> unterstreicht jeden Hautton und passt zu jedem Anlass, von der elegantesten Party bis hin zu den prestigeträchtigsten Events. Diese Farbe verrät Ihre Vorliebe für Exzellenz und Ihren ausgeprägten Sinn für Stil. Wenn Sie dieses Kleid tragen, bleiben Sie nicht länger unbemerkt - Sie werden zu dieser modernen Stilikone, die mit ihrer asymmetrischen Anmut und ihrer unwiderstehlichen magnetischen Aura hypnotisiert.</p>
guid
stringhttps://dev.divasboudoir.com/de/kleid-in-großer-Größe-asymmetrisch-Schleier-schwarz-Schulter/cdbu3069.htm
highlights
string<ul> <li><strong>Modernes asymmetrisches Design</strong> mit spektakulärer entblößter Schulter</li> <li><strong>Kühner transparenter Schleier</strong>, der raffiniert enthüllt</li> <li><strong>Formgebende natürliche Drapierung</strong>, die sich perfekt an Ihre Kurven anpasst</li> <li><strong>Elegante Midi-Länge</strong>, weder zu kurz noch zu lang</li> <li>Schmeichelnder,<strong>eng anliegender Schnitt</strong>, der jede Körperform betont</li> <li><strong>zeitloses Schwarz</strong>, das zu jedem Hautton passt</li> <li>Perfektes Zusammenspiel von opakem und transparentem<strong>Lagenlook</strong> </li> <li><strong>Ikonische Silhouette</strong> für elegante Abende und besondere Anlässe</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringAsymmetrisches Kleid in Übergröße aus schwarzem Voile: entblößte Schulter, raffinierte Transparenzen, natürliche Drapierung, Midi-Länge. Moderne dramatische Eleganz | Diva's Boudoir
keywords
string
title
stringAsymmetrisches Kleid mit großer Taille aus schwarzem Schleier | Diva's Boudoir
seotitle
stringKleid in Übergröße asymmetrisch Schleier schwarz schulterfrei
seouri
stringkleid-in-großer-Größe-asymmetrisch-Schleier-schwarz-Schulter
specifications
string<ul> <li><strong>Typ:</strong> Asymmetrisches Midikleid</li> <li><strong>Farbe:</strong> Tiefschwarz</li> <li><strong>Design:</strong> Entblößte Schulter mit dramatischem Effekt</li> <li><strong>Material:</strong> Transparenter Voile und blickdichter Stoff</li> <li><strong>Länge:</strong> Eleganter Midi</li> <li><strong>Schnitt:</strong> Eng anliegend mit natürlicher Drapierung</li> <li><strong>Stil:</strong> Anspruchsvolle Moderne</li> <li><strong>Anlässe:</strong> Elegante Abendveranstaltungen und besondere<strong>Anlässe</strong> </li> </ul>
stylingtips
string<p>Veredeln Sie Ihr Kleid mit unseren Feinstrümpfen <a href="https://www.divasboudoir.com/de/strumpfe-in-grossen-grossen/">in großen Größen</a> für einen raffinierten Total-Black-Look, oder fügen Sie unsere schwarzen <a href="https://www.divasboudoir.com/de/nachtwasche-grosse-grossen/">Nachtwäsche in großen Größen</a> hinzu, um eine perfekte Harmonie zu erzielen.</p> <p>Vervollständigen Sie Ihre Garderobe mit unseren <a href="https://www.divasboudoir.com/de/sexy-kleider-in-grossen-grossen/">sexy Kleidern in großen Größen</a>, um eine elegante Garderobe zu kreieren, oder erkunden Sie unsere <a href="https://www.divasboudoir.com/fr/tenues-sexy-grande-taille/">sexy Outfits in großen Größen,</a> um die Zahl der raffinierten Looks zu vervielfachen. Diese einzigartige Kreation offenbart Ihren Sinn für Stil mit einer beunruhigenden modernen Eleganz.</p>
summary
string<p>Entdecken Sie dieses asymmetrische Kleid aus schwarzem Voile, das die Kunst der modernen Eleganz revolutioniert! Die entblößte Schulter und das Spiel mit Transparenzen sorgen für einen dramatischen Effekt.</p> <p>Mit seiner natürlichen Drapierung und der perfekten Midi-Länge verwandelt diese Kreation jeden Auftritt in einen Moment purer Raffinesse.</p>
title
stringAsymmetrisches Kleid aus schwarzem Voile - Dramatische Eleganz und Sophistication
usageinstructions
string<p>Ziehen Sie dieses Kleid sanft an und achten Sie dabei auf den transparenten Schleier. Die <strong>asymmetrische Drapierung wird natürlich positioniert</strong>, um diese ikonische Silhouette zu schaffen, die Sie auszeichnet. Der eng anliegende Schnitt schmiegt sich locker an Ihre Formen an und ermöglicht so absolute Bewegungsfreiheit.</p> <p>Dieses Kleid <strong>passt</strong> sich dank seines durchdachten Designs und der weichen Materialien <strong>perfekt an jede Körperform</strong> an. Tragen Sie es selbstbewusst, um Ihre kultivierte Seite auf den elegantesten Partys zu zeigen.</p>
el
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Πλύνετε στο χέρι με κρύο νερό για να διατηρήσετε το ύφασμα</li> <li>Χρησιμοποιήστε ήπιο απορρυπαντικό χωρίς λευκαντικούς παράγοντες</li> <li>Στεγνώνετε επίπεδα για να διατηρήσετε το σχήμα του υφάσματος</li> <li>Ποτέ μην σιδερώνετε απευθείας πάνω στο διαφανές ύφασμα</li> <li>Κρεμάστε απαλά για να αποφύγετε τις ζάρες</li> <li>Αποθηκεύστε σε κάλυμμα για να προστατεύσετε το ευαίσθητο ύφασμα</li> </ul>
description
string<p>Αυτό το ασύμμετρο φόρεμα φέρνει επανάσταση στους κώδικες της κομψότητας με το <strong>μοντέρνο, σπάσιμο των συμβάσεων</strong>. Ο γυμνός ώμος δημιουργεί ένα εντυπωσιακό δραματικό αποτέλεσμα που τραβάει αμέσως τα βλέμματα, αποκαλύπτοντας την τόλμη σας με απόλυτη εκλέπτυνση.</p> <p>Το <strong>διάφανο πέπλο στο κάτω μέρος</strong> προσθέτει μια ελεγχόμενη αισθησιακή διάσταση που παίζει διακριτικά ανάμεσα στην αποκάλυψη και το μυστήριο. Αυτή η αδιαφανής-διαφανής επικάλυψη δημιουργεί ένα σαγηνευτικό οπτικό παιχνίδι που αποκαλύπτει όσο χρειάζεται με μεγάλη φινέτσα. Το <strong>φυσικό πέπλο</strong> αγκαλιάζει απαλά τις καμπύλες σας χωρίς να σας περιορίζει, δημιουργώντας μια σμιλεμένη σιλουέτα που <strong>ενισχύει φυσικά κάθε σωματότυπο</strong>. Το μελετημένο κόψιμο αναδεικνύει τα προσόντα σας χωρίς ποτέ να γίνεται χυδαίο. Το <strong>απόλυτα ισορροπημένο μίντι μήκος</strong> φέρνει διαχρονική κομψότητα που έχει αντέξει στο χρόνο.</p> <p>Αυτή η αναλογία αποκαλύπτει τα πόδια σας με φινέτσα, διατηρώντας παράλληλα την απόλυτη τάξη που χαρακτηρίζει τις μεγάλες δημιουργίες. <strong>Το διαχρονικό, βαθύ μαύρο</strong> υποδύεται όλους τους τόνους του δέρματος και είναι κατάλληλο για όλες τις περιστάσεις, από τις πιο κομψές βραδιές μέχρι τις πιο διάσημες εκδηλώσεις. Αυτό το χρώμα αποκαλύπτει το γούστο σας για την τελειότητα και την έντονη αίσθηση του στυλ σας. Όταν φοράτε αυτό το φόρεμα, δεν περνάτε πλέον απαρατήρητη - γίνεστε το σύγχρονο είδωλο του στυλ που μαγνητίζει με την ασύμμετρη χάρη και την ακαταμάχητη μαγνητική αύρα.</p>
guid
stringhttps://dev.divasboudoir.com/el/asymmetro-forema-megaloy-megethoys-me-mayro-peplo-ston-wmo/cdbu3069.htm
highlights
string<ul> <li><strong>Μοντέρνο ασύμμετρο σχέδιο</strong> με εντυπωσιακό γυμνό ώμο</li> <li><strong>Το τολμηρό διάφανο πέπλο</strong> αποκαλύπτει με φινέτσα</li> <li><strong>Γλυπτική φυσική κουρτίνα</strong> αγκαλιάζει τέλεια τις καμπύλες σας</li> <li><strong>Κομψό μίντι μήκος</strong> που δεν είναι ούτε πολύ κοντό ούτε πολύ μακρύ</li> <li><strong>Κολακευτικό, εφαρμοστό κόψιμο</strong> για κάθε σωματότυπο</li> <li><strong>διαχρονικό μαύρο</strong> για όλους τους τόνους δέρματος</li> <li>Τέλεια επεξεργασμένο αδιαφανές και διαφανές<strong>εφέ διαστρωμάτωσης</strong> </li> <li><strong>Εικονική σιλουέτα</strong> για κομψές βραδιές και ειδικές εκδηλώσεις</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringΑσύμμετρο φόρεμα plus size σε μαύρο voile: γυμνός ώμος, εκλεπτυσμένη διαφάνεια, φυσικό ντραπέ, μήκος midi. Δραματική μοντέρνα κομψότητα | Diva's Boudoir
keywords
string
title
stringΑσύμμετρο φόρεμα μεγάλο μέγεθος μαύρο πέπλο | Diva's Boudoir
seotitle
stringΜεγάλο ασύμμετρο μαύρο φόρεμα με γυμνό ώμο
seouri
stringασύμμετρο-φόρεμα-μεγάλου-μεγέθους-με-μαύρο-πέπλο-στον-ώμο
specifications
string<ul> <li><strong>Τύπος :</strong> Ασύμμετρο μίντι φόρεμα</li> <li><strong>Χρώμα :</strong> Βαθύ μαύρο</li> <li><strong>Σχέδιο</strong>: Γυμνός ώμος με δραματικό εφέ</li> <li><strong>Υλικό:</strong> διαφανές ύφασμα και αδιαφανές ύφασμα</li> <li><strong>Μήκος :</strong> Κομψό μίντι</li> <li><strong>Κοπή :</strong> Αγκαλιάζει το σώμα με φυσικό ντραπέ</li> <li><strong>Στυλ:</strong> Εκλεπτυσμένο μοντέρνο</li> <li><strong>Περιστάσεις:</strong> Κομψές βραδιές και ειδικές εκδηλώσεις</li> </ul>
stylingtips
string<p>Ενισχύστε το φόρεμά σας με τις λεπτές μας <a href="https://www.divasboudoir.com/el/kaltses-megaloy-megethoys/">κάλτσες plus size</a> για μια εκλεπτυσμένη total black εμφάνιση ή προσθέστε τα μαύρα μας <a href="https://www.divasboudoir.com/el/nychtika-syn-megethos/">νυχτικά plus size</a> για τέλεια αρμονία.</p> <p>Ολοκληρώστε την εμφάνιση με τα <a href="https://www.divasboudoir.com/el/sexi-foremata-syn-megethos/">σέξι φορέματα plus size</a> για να δημιουργήσετε μια κομψή γκαρνταρόμπα ή εξερευνήστε τα <a href="https://www.divasboudoir.com/fr/tenues-sexy-grande-taille/">σέξι ρούχα plus size για</a> πιο εκλεπτυσμένες εμφανίσεις. Αυτή η μοναδική δημιουργία αποκαλύπτει την αίσθηση του στυλ σας με μια ενοχλητική μοντέρνα κομψότητα.</p>
summary
string<p>Ανακαλύψτε αυτό το ασύμμετρο φόρεμα από μαύρο voile που φέρνει επανάσταση στην τέχνη της σύγχρονης κομψότητας! Ο γυμνός ώμος και οι διάφανες λεπτομέρειες δημιουργούν ένα εντυπωσιακά δραματικό αποτέλεσμα.</p> <p>Με το φυσικό ντύσιμο και το τέλειο μίντι μήκος του, αυτή η δημιουργία μετατρέπει κάθε εμφάνιση σε μια στιγμή καθαρής φινέτσας.</p>
title
stringΑσύμμετρο μαύρο φόρεμα με πέπλο - Δραματική κομψότητα και εκλέπτυνση
usageinstructions
string<p>Φορέστε απαλά αυτό το φόρεμα, προσέχοντας το διάφανο πέπλο. Το <strong>ασύμμετρο ντραπέ τοποθετείται φυσικά</strong> για να δημιουργήσει αυτή την εμβληματική σιλουέτα που σας κάνει να ξεχωρίζετε. Το εφαρμοστό κόψιμο αγκαλιάζει τη σιλουέτα σας χωρίς περιορισμούς, επιτρέποντας απόλυτη ελευθερία κινήσεων.</p> <p>Αυτό το φόρεμα <strong>προσαρμόζεται τέλεια σε όλα τα σχήματα σώματος</strong> χάρη στο μελετημένο σχεδιασμό και τα εύπλαστα υλικά του. Φορέστε το με αυτοπεποίθηση για να αποκαλύψετε την εκλεπτυσμένη πλευρά σας στις πιο κομψές βραδινές σας εξόδους.</p>
en
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Hand wash in cold water to preserve the voile</li> <li>Use a mild detergent without bleaching agents</li> <li>Dry flat to maintain drape shape</li> <li>Never iron directly on the transparent voile</li> <li>Hang delicately to avoid wrinkles</li> <li>Store in a cover to protect delicate fabric</li> </ul>
description
string<p>This asymmetrical dress revolutionizes the codes of elegance with its <strong>modern, convention-busting design</strong>. The bare shoulder creates a striking dramatic effect that immediately catches the eye, revealing your boldness with absolute sophistication.</p> <p>The <strong>transparent veil on the lower part</strong> adds a masterfully sensual dimension that plays subtly between revelation and mystery. This opaque-transparent superimposition creates a captivating visual play that reveals just enough with great class. The <strong>natural drape</strong> gently hugs your curves without constricting, creating a sculpted silhouette that <strong>naturally enhances every body type</strong>. The studied cut highlights your assets without ever falling into vulgarity. The <strong>perfectly balanced midi length</strong> brings timeless elegance that endures through the ages.</p> <p>This proportion reveals your legs with sophistication, while retaining the absolute class that characterizes great creations. <strong>Timeless deep black</strong> sublimates all skin tones and adapts to all occasions, from the most elegant evenings to the most prestigious events. This color reveals your taste for excellence and your assertive sense of style. When you wear this dress, you no longer go unnoticed - you become that icon of modern style that hypnotizes with its asymmetrical grace and irresistible magnetic aura.</p>
guid
stringhttps://dev.divasboudoir.com/en/plus-size-asymmetrical-black-veil-shoulder-dress/cdbu3069.htm
highlights
string<ul> <li><strong>Modern asymmetrical design</strong> with spectacular bare shoulder</li> <li><strong>Bold sheer veil</strong> reveals with sophistication</li> <li><strong>Sculpting natural drape</strong> hugs your curves perfectly</li> <li><strong>Elegant midi length,</strong> neither too short nor too long</li> <li><strong>Flattering, form-fitting cut</strong> for every body type</li> <li><strong>timeless black</strong> for all skin tones</li> <li>Perfectly mastered opaque and transparent<strong>layering effect</strong> </li> <li><strong>Iconic silhouette</strong> for elegant evenings and special events</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringAsymmetrical plus-size dress in black voile: bare shoulder, sophisticated transparencies, natural drape, midi length. Dramatic modern elegance | Diva's Boudoir
keywords
string
title
stringAsymmetrical plus size black veil dress | Diva's Boudoir
seotitle
stringPlus size asymmetrical black voile off shoulder dress
seouri
stringplus-size-asymmetrical-black-veil-shoulder-dress
specifications
string<ul> <li><strong>Type:</strong> Asymmetrical midi dress</li> <li><strong>Color:</strong> deep black</li> <li><strong>Design:</strong> Bare shoulder with dramatic effect</li> <li><strong>Material:</strong> sheer voile and opaque fabric</li> <li><strong>Length:</strong> Elegant midi</li> <li><strong>Cut:</strong> Form-fitting with natural drape</li> <li><strong>Style:</strong> Sophisticated modern</li> <li><strong>Occasions:</strong> Elegant evenings and special events</li> </ul>
stylingtips
string<p>Enhance your dress with our slender <a href="https://www.divasboudoir.com/en/socks-large-size/">plus size stockings</a> for a sophisticated total black look, or add our black <a href="https://www.divasboudoir.com/en/nightwear-plus-size/">plus size nightwear</a> for perfect harmony.</p> <p>Complete the look with our <a href="https://www.divasboudoir.com/en/sexys-plus-size-dresses/">sexy plus size dresses</a> to create an elegant wardrobe, or explore our <a href="https://www.divasboudoir.com/fr/tenues-sexy-grande-taille/">sexy plus size outfits</a> to multiply sophisticated looks. This unique creation reveals your sense of style with unsettling modern elegance.</p>
summary
string<p>Discover this asymmetrical dress in black voile that revolutionizes the art of modern elegance! Its bare shoulder and play of transparencies create a strikingly dramatic effect.</p> <p>With its natural drape and perfect midi length, this creation transforms every appearance into a moment of pure sophistication.</p>
title
stringAsymmetrical black veil dress - Dramatic elegance and sophistication
usageinstructions
string<p>Gently slip on this dress, taking care with the sheer veil. The <strong>asymmetrical drape positions itself naturally</strong> to create that iconic silhouette that sets you apart. The form-fitting cut hugs your curves without constraint, allowing total freedom of movement.</p> <p>This dress <strong>adapts perfectly to all morphologies</strong> thanks to its studied design and supple materials. Wear it with confidence to reveal your sophisticated side at your most elegant evenings.</p>
es
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavar a mano en agua fría para preservar el voile</li> <li>Utilizar un detergente suave sin blanqueantes</li> <li>Séquelo en plano para mantener la forma del velo</li> <li>Nunca planchar directamente sobre el velo transparente</li> <li>Cuélguelo suavemente para evitar arrugas</li> <li>Guárdelo en una funda para proteger el delicado tejido</li> </ul>
description
string<p>Este vestido asimétrico revoluciona los códigos de la elegancia con su <strong>diseño moderno y rompedor</strong>. El hombro al descubierto crea un impactante efecto dramático que atrae inmediatamente las miradas, revelando tu audacia con absoluta sofisticación.</p> <p>El <strong>velo transparente de la parte inferior</strong> añade una dimensión sensual controlada que juega sutilmente entre la revelación y el misterio. Esta superposición opaca-transparente crea un juego visual cautivador que revela lo justo con gran clase. La <strong>caída natural</strong> abraza suavemente sus curvas sin constreñir, creando una silueta esculpida que <strong>realza con naturalidad todo tipo de cuerpos</strong>. El estudiado corte resalta tus activos sin llegar a ser vulgar. El <strong>largo midi, perfectamente equilibrado</strong>, aporta una elegancia atemporal que ha superado la prueba del tiempo.</p> <p>Esta proporción revela sus piernas con sofisticación, conservando la clase absoluta que caracteriza a las grandes creaciones. <strong>Atemporal, el negro profundo</strong> sublima todos los tonos de piel y se adapta a todas las ocasiones, desde las veladas más elegantes hasta los eventos más prestigiosos. Este color revela su gusto por la excelencia y su fuerte sentido del estilo. Cuando llevas este vestido, ya no pasas desapercibida: te conviertes en ese icono de estilo moderno que hipnotiza con una gracia asimétrica y un aura magnética irresistible.</p>
guid
stringhttps://dev.divasboudoir.com/es/vestido-asimétrico-talla-grande-con-velo-negro-en-el-hombro/cdbu3069.htm
highlights
string<ul> <li><strong>Moderno diseño asimétrico</strong> con espectacular hombro descubierto</li> <li><strong>El velo transparente</strong> revela con sofisticación</li> <li><strong>Esculpida caída natural</strong> que abraza tus curvas a la perfección</li> <li><strong>Elegante largo midi</strong>, ni demasiado corto ni demasiado largo</li> <li><strong>Corte favorecedor y ceñido</strong> para todo tipo de cuerpos</li> <li><strong>negro atemporal</strong> para todos los tonos de piel</li> <li><strong>Efecto de capas</strong> opacas y transparentes perfectamente dominado</li> <li><strong>Silueta icónica</strong> para veladas elegantes y eventos especiales</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringVestido asimétrico talla grande en gasa negra: hombros descubiertos, sofisticados visillos, caída natural, largo midi. Elegancia moderna y dramática | Diva's Boudoir
keywords
string
title
stringVestido asimétrico talla grande velo negro | Diva's Boudoir
seotitle
stringTalla grande asimétrica de gasa negra con hombro descubierto
seouri
stringvestido-asimétrico-talla-grande-con-velo-negro-en-el-hombro
specifications
string<ul> <li><strong>Tipo :</strong> Vestido midi asimétrico</li> <li><strong>Color :</strong> Negro intenso</li> <li><strong>Diseño :</strong> Hombros descubiertos con efecto dramático</li> <li><strong>Material :</strong> Voile transparente y tejido opaco</li> <li><strong>Largo :</strong> Elegante midi</li> <li><strong>Corte:</strong> ceñido al cuerpo con caída natural</li> <li><strong>Estilo:</strong> Sofisticado y moderno</li> <li><strong>Ocasiones:</strong> Veladas elegantes y eventos especiales</li> </ul>
stylingtips
string<p>Realza tu vestido con nuestras finas <a href="https://www.divasboudoir.com/es/medias-grandes/">medias talla grande</a> para un sofisticado look total black, o añade nuestra <a href="https://www.divasboudoir.com/es/camisones-tallas-grandes/">ropa de dormir</a> negra <a href="https://www.divasboudoir.com/es/camisones-tallas-grandes/">talla grande</a> para conseguir la armonía perfecta.</p> <p>Completa el look con nuestros <a href="https://www.divasboudoir.com/es/sexys-vestidos-talla-grande/">vestidos sexys talla</a> grande para crear un vestuario elegante, o explora nuestros <a href="https://www.divasboudoir.com/fr/tenues-sexy-grande-taille/">conjuntos sexys talla</a> grande para looks más sofisticados. Esta creación única revela tu sentido del estilo con una inquietante elegancia moderna.</p>
summary
string<p>Descubre este vestido asimétrico de gasa negra que revoluciona el arte de la elegancia moderna Sus hombros al descubierto y sus detalles transparentes crean un efecto espectacular.</p> <p>Con su caída natural y su largo midi perfecto, esta creación transforma cada aparición en un momento de pura sofisticación.</p>
title
stringVestido asimétrico con velo negro - Dramática elegancia y sofisticación
usageinstructions
string<p>Deslice suavemente este vestido, teniendo cuidado con el velo transparente. La <strong>caída asimétrica se coloca de forma natural</strong> para crear esa silueta icónica que te distingue. El corte ceñido se adapta a su silueta sin constreñirla, permitiéndole una total libertad de movimientos.</p> <p>Este vestido <strong>se adapta perfectamente a todas las formas del cuerpo</strong> gracias a su estudiado diseño y a sus materiales flexibles. Llévalo con confianza para revelar tu lado más sofisticado en tus veladas más elegantes.</p>
fr
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavage &agrave; la main &agrave; l'eau froide pour pr&eacute;server le voile</li> <li>Utiliser une lessive douce sans agents blanchissants</li> <li>S&eacute;chage &agrave; plat pour maintenir la forme du drap&eacute;</li> <li>Ne jamais repasser directement sur le voile transparent</li> <li>Suspendre d&eacute;licatement pour &eacute;viter les plis</li> <li>Ranger dans une housse pour prot&eacute;ger le tissu d&eacute;licat</li> </ul>
description
string<p>Cette robe asym&eacute;trique r&eacute;volutionne les codes de l'&eacute;l&eacute;gance avec son <strong>design moderne qui brise les conventions</strong>. L'&eacute;paule d&eacute;nud&eacute;e cr&eacute;e un effet dramatique saisissant qui attire imm&eacute;diatement tous les regards, r&eacute;v&eacute;lant votre audace avec une sophistication absolue.</p> <p>Le&nbsp;<strong>voile transparent sur la partie basse</strong> ajoute une dimension sensuelle ma&icirc;tris&eacute;e qui joue subtilement entre r&eacute;v&eacute;lation et myst&egrave;re. Cette superposition opaque-transparent cr&eacute;e un jeu visuel captivant qui r&eacute;v&egrave;le juste ce qu'il faut avec beaucoup de classe. Le <strong>drap&eacute; naturel</strong> &eacute;pouse d&eacute;licatement vos courbes sans serrer, cr&eacute;ant cette silhouette sculpt&eacute;e qui <strong>sublime naturellement toutes les morphologies</strong>. La coupe &eacute;tudi&eacute;e met en valeur vos atouts sans jamais tomber dans la vulgarit&eacute;. La <strong>longueur midi parfaitement &eacute;quilibr&eacute;e</strong> apporte cette &eacute;l&eacute;gance intemporelle qui traverse les &eacute;poques.</p> <p>Cette proportion r&eacute;v&egrave;le vos jambes avec sophistication tout en conservant cette classe absolue qui caract&eacute;rise les grandes cr&eacute;ations. Le&nbsp;<strong>noir profond intemporel</strong> sublime toutes les carnations et s'adapte &agrave; toutes les occasions, des soir&eacute;es les plus &eacute;l&eacute;gantes aux &eacute;v&eacute;nements les plus prestigieux. Cette couleur r&eacute;v&egrave;le votre go&ucirc;t pour l'excellence et votre sens du style affirm&eacute;. Quand vous portez cette robe, vous ne passez plus inaper&ccedil;ue - vous devenez cette ic&ocirc;ne de style moderne qui hypnotise avec sa gr&acirc;ce asym&eacute;trique et son aura magn&eacute;tique irr&eacute;sistible.</p>
guid
stringhttps://dev.divasboudoir.com/fr/robe-grande-taille-asymetrique-voile-noire-epaule/cdbu3069.htm
highlights
string<ul> <li><strong>Design asym&eacute;trique moderne</strong> avec &eacute;paule d&eacute;nud&eacute;e spectaculaire</li> <li><strong>Voile transparent audacieux</strong> qui r&eacute;v&egrave;le avec sophistication</li> <li><strong>Drap&eacute; naturel sculptant</strong> qui &eacute;pouse parfaitement vos courbes</li> <li><strong>Longueur midi &eacute;l&eacute;gante</strong> ni trop courte ni trop longue</li> <li><strong>Coupe moulante flatteuse</strong> qui sublime toutes les morphologies</li> <li><strong>noir intemporel</strong> qui va &agrave; toutes les carnations</li> <li><strong>Effet superposition</strong> opaque et transparent parfaitement ma&icirc;tris&eacute;</li> <li><strong>Silhouette iconique</strong> pour soir&eacute;es &eacute;l&eacute;gantes et &eacute;v&eacute;nements sp&eacute;ciaux</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringRobe asymétrique grande taille voile noir : épaule dénudée, transparences sophistiquées, drapé naturel, longueur midi. Élégance dramatique moderne | Diva's Boudoir
keywords
string
title
stringRobe asymétrique grande taille voile noire | Diva's Boudoir
seotitle
stringRobe grande taille asymétrique voile noire épaule dénudée
seouri
stringrobe-grande-taille-asymetrique-voile-noire-epaule
specifications
string<ul> <li><strong>Type :</strong> Robe asym&eacute;trique midi</li> <li><strong>Couleur :</strong> noir profond</li> <li><strong>Design :</strong> &Eacute;paule d&eacute;nud&eacute;e avec effet dramatique</li> <li><strong>Mati&egrave;re :</strong> Voile transparent et tissu opaque</li> <li><strong>Longueur :</strong> Midi &eacute;l&eacute;gante</li> <li><strong>Coupe :</strong> Moulante avec drap&eacute; naturel</li> <li><strong>Style :</strong> Moderne sophistiqu&eacute;</li> <li><strong>Occasions :</strong> Soir&eacute;es &eacute;l&eacute;gantes et &eacute;v&eacute;nements sp&eacute;ciaux</li> </ul>
stylingtips
string<p>Sublimez votre robe avec nos <a href="https://www.divasboudoir.com/fr/bas-grande-taille/">bas grande taille</a> fins pour un look total black sophistiqu&eacute;, ou ajoutez nos <a href="https://www.divasboudoir.com/fr/lingerie-de-nuit-grande-taille/">lingerie de nuit grande taille</a> noire pour une harmonie parfaite.</p> <p>Compl&eacute;tez avec nos&nbsp;<a href="https://www.divasboudoir.com/fr/robes-sexys-grande-taille/">robes sexys grande taille</a> pour cr&eacute;er une garde-robe &eacute;l&eacute;gante, ou explorez nos <a href="https://www.divasboudoir.com/fr/tenues-sexy-grande-taille/">tenues sexys grande taille</a> pour multiplier les looks sophistiqu&eacute;s. Cette cr&eacute;ation unique r&eacute;v&egrave;le votre sens du style avec une &eacute;l&eacute;gance moderne troublante.</p>
summary
string<p>D&eacute;couvrez cette robe asym&eacute;trique en voile noir qui r&eacute;volutionne l'art de l'&eacute;l&eacute;gance moderne ! Son &eacute;paule d&eacute;nud&eacute;e et son jeu de transparences cr&eacute;ent un effet dramatique saisissant.</p> <p>Avec son drap&eacute; naturel et sa longueur midi parfaite, cette cr&eacute;ation transforme chaque apparition en moment de pure sophistication.</p>
title
stringRobe Asymétrique Voile noire - Élégance Dramatique et Sophistication
usageinstructions
string<p>Enfilez d&eacute;licatement cette robe en prenant soin du voile transparent. Le <strong>drap&eacute; asym&eacute;trique se positionne naturellement</strong> pour cr&eacute;er cette silhouette iconique qui vous distingue. La coupe moulante &eacute;pouse vos formes sans contrainte, permettant une libert&eacute; de mouvement totale.</p> <p>Cette robe&nbsp;<strong>s'adapte parfaitement &agrave; toutes les morphologies</strong> gr&acirc;ce &agrave; son design &eacute;tudi&eacute; et ses mati&egrave;res souples. Portez-la avec confiance pour r&eacute;v&eacute;ler votre c&ocirc;t&eacute; sophistiqu&eacute; lors de vos soir&eacute;es les plus &eacute;l&eacute;gantes.</p>
it
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavare a mano in acqua fredda per preservare il velo</li> <li>Utilizzare un detergente delicato senza agenti sbiancanti</li> <li>Asciugare in piano per mantenere la forma del drappeggio</li> <li>Non stirare mai direttamente il voile trasparente</li> <li>Appendere delicatamente per evitare le pieghe</li> <li>Conservare in una copertina per proteggere il tessuto delicato</li> </ul>
description
string<p>Questo abito asimmetrico rivoluziona i codici dell'eleganza con il suo <strong>design moderno e che rompe le convenzioni</strong>. La spalla nuda crea un sorprendente effetto drammatico che cattura immediatamente lo sguardo, rivelando la vostra audacia con assoluta raffinatezza.</p> <p>Il <strong>velo trasparente sul fondo</strong> aggiunge una dimensione sensuale e controllata che gioca sottilmente tra rivelazione e mistero. Questa sovrapposizione opaca-trasparente crea un gioco visivo accattivante che rivela quanto basta con grande classe. Il <strong>drappeggio naturale</strong> abbraccia delicatamente le curve senza costringere, creando una silhouette scolpita che <strong>valorizza naturalmente ogni tipo di corpo</strong>. Il taglio studiato mette in risalto le vostre caratteristiche senza mai diventare volgare. La <strong>lunghezza midi, perfettamente bilanciata</strong>, conferisce un'eleganza senza tempo che ha superato la prova del tempo.</p> <p>Questa proporzione rivela le gambe con raffinatezza, pur mantenendo la classe assoluta che caratterizza le grandi creazioni. <strong>Il nero profondo e senza tempo</strong> sublima tutte le tonalità della pelle ed è adatto a tutte le occasioni, dalle serate più eleganti agli eventi più prestigiosi. Questo colore rivela il vostro gusto per l'eccellenza e il vostro forte senso dello stile. Quando indossate questo abito, non passate più inosservate: diventate l'icona di stile moderno che affascina con una grazia asimmetrica e un'irresistibile aura magnetica.</p>
guid
stringhttps://dev.divasboudoir.com/it/abito-asimmetrico-di-taglia-grande-con-velo-nero-sulle-spalle/cdbu3069.htm
highlights
string<ul> <li><strong>Moderno design asimmetrico</strong> con spettacolare spalla nuda</li> <li>L<strong>'audace velo trasparente</strong> rivela con raffinatezza</li> <li><strong>Il drappeggio naturale e scultoreo</strong> abbraccia perfettamente le vostre curve</li> <li><strong>Elegante lunghezza midi</strong>, né troppo corta né troppo lunga</li> <li><strong>Taglio aderente e lusinghiero</strong> per ogni tipo di corpo</li> <li><strong>nero senza tempo</strong> per tutte le tonalità di pelle</li> <li><strong>Effetto stratificato</strong> opaco e trasparente perfettamente padroneggiato</li> <li><strong>Silhouette iconica</strong> per serate eleganti ed eventi speciali</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringAbito asimmetrico taglia grande in voile nero: spalla scoperta, sofisticate trasparenze, drappeggio naturale, lunghezza midi. Drammatica eleganza moderna | Diva's Boudoir
keywords
string
title
stringAbito asimmetrico taglia grande velo nero | Diva's Boudoir
seotitle
stringGrande abito asimmetrico in voile nero con spalle scoperte
seouri
stringabito-asimmetrico-di-taglia-grande-con-velo-nero-sulle-spalle
specifications
string<ul> <li><strong>Tipo :</strong> Abito midi asimmetrico</li> <li><strong>Colore :</strong> Nero profondo</li> <li><strong>Design :</strong> Spalla nuda con effetto scenografico</li> <li><strong>Materiale :</strong> voile trasparente e tessuto opaco</li> <li><strong>Lunghezza :</strong> Elegante midi</li> <li><strong>Taglio :</strong> aderente al corpo con drappeggio naturale</li> <li><strong>Stile:</strong> Sofisticato e moderno</li> <li><strong>Occasioni:</strong> serate eleganti ed eventi speciali</li> </ul>
stylingtips
string<p>Arricchite il vostro abito con le nostre <a href="https://www.divasboudoir.com/it/calze-di-grandi-dimensioni/">calze</a> sottili <a href="https://www.divasboudoir.com/it/calze-di-grandi-dimensioni/">plus size</a> per un sofisticato look total black, oppure aggiungete la nostra <a href="https://www.divasboudoir.com/it/abbigliamento-da-notte-per-taglie-forti/">biancheria da notte</a> nera <a href="https://www.divasboudoir.com/it/abbigliamento-da-notte-per-taglie-forti/">taglia grande</a> per un'armonia perfetta.</p> <p>Completate il look con i nostri <a href="https://www.divasboudoir.com/it/abiti-sexys-taglia-grande/">abiti sexy taglie forti</a> per creare un guardaroba elegante, oppure esplorate i nostri <a href="https://www.divasboudoir.com/fr/tenues-sexy-grande-taille/">completi sexy taglie forti</a> per look più sofisticati. Questa creazione unica rivela il vostro senso dello stile con una conturbante eleganza moderna.</p>
summary
string<p>Scoprite questo abito asimmetrico in voile nero che rivoluziona l'arte dell'eleganza moderna! Le spalle scoperte e i dettagli trasparenti creano un effetto drammatico di grande impatto.</p> <p>Con il suo drappeggio naturale e la perfetta lunghezza midi, questa creazione trasforma ogni apparizione in un momento di pura raffinatezza.</p>
title
stringAbito asimmetrico con velo nero - Eleganza drammatica e raffinatezza
usageinstructions
string<p>Indossate delicatamente questo abito, facendo attenzione al velo trasparente. Il <strong>drappeggio asimmetrico è posizionato in modo naturale</strong> per creare la silhouette iconica che vi contraddistingue. Il taglio aderente abbraccia le forme senza costringerle, consentendo una totale libertà di movimento.</p> <p>Questo abito <strong>si adatta perfettamente a tutte le forme del corpo</strong> grazie al design studiato e ai materiali morbidi. Indossatelo con disinvoltura per rivelare il vostro lato sofisticato nelle serate più eleganti.</p>
nl
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Handwas in koud water om de voile te behouden</li> <li>Gebruik een mild wasmiddel zonder bleekmiddelen</li> <li>Plat drogen om de vorm van de voile te behouden</li> <li>Strijk nooit rechtstreeks op de transparante voile</li> <li>Voorzichtig ophangen om kreuken te voorkomen</li> <li>Bewaar in een hoes om de delicate stof te beschermen</li> </ul>
description
string<p>Deze asymmetrische jurk revolutioneert de codes van elegantie met zijn <strong>moderne, conventionele ontwerp</strong>. De blote schouder creëert een opvallend dramatisch effect dat meteen in het oog springt en je brutaliteit onthult met absolute verfijning.</p> <p>De <strong>doorzichtige sluier onderaan</strong> voegt een gecontroleerde sensuele dimensie toe die subtiel speelt tussen onthulling en mysterie. Deze ondoorzichtige overlapping creëert een boeiend visueel spel dat precies genoeg onthult met grote klasse. De <strong>natuurlijke drapering</strong> omhelst zachtjes je rondingen zonder in te perken, waardoor een gebeeldhouwd silhouet ontstaat dat <strong>elk lichaamstype op natuurlijke wijze tot zijn recht laat komen</strong>. De bestudeerde snit benadrukt je pluspunten zonder ooit vulgair te worden. De <strong>perfect uitgebalanceerde midilengte</strong> brengt tijdloze elegantie die de tand des tijds heeft doorstaan.</p> <p>Deze proportie onthult je benen met verfijning, terwijl de absolute klasse behouden blijft die kenmerkend is voor geweldige creaties. <strong>Tijdloos, diepzwart</strong> sublimeert alle huidtinten en is geschikt voor alle gelegenheden, van de meest elegante avonden tot de meest prestigieuze evenementen. Deze kleur onthult je smaak voor uitmuntendheid en je sterke gevoel voor stijl. Als je deze jurk draagt, blijf je niet langer onopgemerkt - je wordt dat moderne stijlicoon dat betovert met asymmetrische gratie en een onweerstaanbare magnetische uitstraling.</p>
guid
stringhttps://dev.divasboudoir.com/nl/asymmetrische-jurk-van-grote-maat-met-zwarte-schouderluier/cdbu3069.htm
highlights
string<ul> <li><strong>Modern asymmetrisch ontwerp</strong> met spectaculaire blote schouder</li> <li><strong>Gewaagde, transparante sluier</strong> onthult met raffinement</li> <li><strong>Sculpting natuurlijke drapering</strong> omhelst je rondingen perfect</li> <li><strong>Elegante midilengte</strong> die niet te kort en niet te lang is</li> <li><strong>Flatterende, vormvaste snit</strong> voor elk lichaamstype</li> <li><strong>tijdloos zwart</strong> voor alle huidtinten</li> <li>Perfect beheerst ondoorzichtig en transparant<strong>gelaagd effect</strong> </li> <li><strong>Iconisch silhouet</strong> voor elegante avonden en speciale evenementen</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringAsymmetrische jurk van grote maat in zwarte voile: blote schouder, geraffineerde ruiten, natuurlijke drapering, midielengte. Dramatische moderne elegantie | Diva's Boudoir
keywords
string
title
stringAsymmetrische jurk grote maat zwarte sluier | Diva's Boudoir
seotitle
stringGrote asymmetrische zwarte voile jurk met blote schouder
seouri
stringasymmetrische-jurk-van-grote-maat-met-zwarte-schouderluier
specifications
string<ul> <li><strong>Type :</strong> Asymmetrische midi-jurk</li> <li><strong>Kleur :</strong> Diepzwart</li> <li><strong>Ontwerp :</strong> Blote schouder met dramatisch effect</li> <li><strong>Materiaal:</strong> transparante voile en ondoorzichtige stof</li> <li><strong>Lengte :</strong> Elegante midi</li> <li><strong>Snit:</strong> nauwsluitend met natuurlijke drapering</li> <li><strong>Stijl:</strong> verfijnd modern</li> <li><strong>Gelegenheden:</strong> Elegante avonden en speciale evenementen</li> </ul>
stylingtips
string<p>Maak je jurk af met onze slanke <a href="https://www.divasboudoir.com/nl/grote-maat-kousen/">plus size kousen</a> voor een geraffineerde total black look, of voeg onze zwarte <a href="https://www.divasboudoir.com/nl/plus-maat-nachtkleding/">plus size nachtkleding</a> toe voor de perfecte harmonie.</p> <p>Vul aan met onze <a href="https://www.divasboudoir.com/nl/sexys-jurken-grote-maat/">sexy jurken van grote maten</a> om een elegante garderobe te creëren, of ontdek onze <a href="https://www.divasboudoir.com/fr/tenues-sexy-grande-taille/">sexy outfits van grote maten</a> voor meer geraffineerde looks. Deze unieke creatie onthult je gevoel voor stijl met een verontrustende moderne elegantie.</p>
summary
string<p>Ontdek deze asymmetrische jurk in zwarte voile die een revolutie teweegbrengt in de kunst van moderne elegantie! De blote schouder en de doorschijnende details zorgen voor een opvallend dramatisch effect.</p> <p>Met zijn natuurlijke drapering en perfecte midielengte maakt deze creatie van elke verschijning een moment van pure verfijning.</p>
title
stringAsymmetrische zwarte sluierjurk - Dramatische elegantie en verfijning
usageinstructions
string<p>Trek deze jurk voorzichtig aan en let op de doorschijnende sluier. De <strong>asymmetrische drapering is op natuurlijke wijze geplaatst</strong> om dat iconische silhouet te creëren waarmee je je onderscheidt. De nauwsluitende snit omhelst je vorm zonder beperkingen en biedt volledige bewegingsvrijheid.</p> <p>Deze jurk <strong>past perfect bij alle lichaamsvormen</strong> dankzij het bestudeerde ontwerp en de soepele materialen. Draag hem vol vertrouwen om je van je geraffineerde kant te laten zien tijdens je meest elegante avondjes uit.</p>
pt
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavar à mão em água fria para preservar o voile</li> <li>Utilizar um detergente suave sem agentes branqueadores</li> <li>Secar na horizontal para manter a forma do drapeado</li> <li>Nunca passar a ferro diretamente sobre o voile transparente</li> <li>Pendurar suavemente para evitar vincos</li> <li>Guardar numa capa para proteger o tecido delicado</li> </ul>
description
string<p>Este vestido assimétrico revoluciona os códigos de elegância com o seu <strong>design moderno que quebra as convenções</strong>. O ombro descoberto cria um efeito dramático impressionante que chama imediatamente a atenção, revelando a sua ousadia com absoluta sofisticação.</p> <p>O <strong>véu transparente na parte inferior</strong> acrescenta uma dimensão sensual controlada que joga subtilmente entre a revelação e o mistério. Esta sobreposição opaco-transparente cria um jogo visual cativante que revela apenas o suficiente com grande classe. O drapeado <strong>natural</strong> abraça suavemente as suas curvas sem apertar, criando uma silhueta esculpida que <strong>realça naturalmente todos os tipos de corpo</strong>. O corte estudado realça os seus atributos sem nunca se tornar vulgar. O <strong>comprimento midi perfeitamente equilibrado</strong> confere uma elegância intemporal que resiste ao teste do tempo.</p> <p>Esta proporção revela as suas pernas com sofisticação, mantendo a classe absoluta que caracteriza as grandes criações. <strong>O preto intemporal e profundo</strong> sublima todos os tons de pele e é adequado para todas as ocasiões, desde as noites mais elegantes até aos eventos mais prestigiados. Esta cor revela o seu gosto pela excelência e o seu forte sentido de estilo. Quando usa este vestido, já não passa despercebida - torna-se naquele ícone de estilo moderno que fascina com uma graça assimétrica e uma aura magnética irresistível.</p>
guid
stringhttps://dev.divasboudoir.com/pt/vestido-assimétrico-de-tamanho-grande-com-véu-de-ombros-preto/cdbu3069.htm
highlights
string<ul> <li><strong>Design assimétrico moderno</strong> com um espetacular ombro descoberto</li> <li><strong>O véu transparente e arrojado</strong> revela-se com sofisticação</li> <li><strong>O dra</strong> peado<strong>natural esculpido</strong> abraça as suas curvas na perfeição</li> <li><strong>Comprimento midi elegante</strong> que não é nem demasiado curto nem demasiado comprido</li> <li><strong>Corte lisonjeador e justo</strong> para todos os tipos de corpo</li> <li><strong>preto intemporal</strong> para todos os tons de pele</li> <li><strong>Efeito de camadas</strong> opacas e transparentes perfeitamente dominado</li> <li><strong>Silhueta icónica</strong> para noites elegantes e eventos especiais</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringVestido assimétrico plus size em voile preto: ombros descobertos, folhos sofisticados, drapeado natural, comprimento midi. Elegância moderna e dramática | Diva's Boudoir
keywords
string
title
stringVestido assimétrico tamanho grande véu preto | Diva's Boudoir
seotitle
stringVestido grande assimétrico em voile preto com ombros à mostra
seouri
stringvestido-assimétrico-de-tamanho-grande-com-véu-de-ombros-preto
specifications
string<ul> <li><strong>Tipo :</strong> Vestido midi assimétrico</li> <li><strong>Cor :</strong> Preto profundo</li> <li><strong>Design:</strong> Ombros descobertos com efeito dramático</li> <li><strong>Material:</strong> voile transparente e tecido opaco</li> <li><strong>Comprimento :</strong> Elegante midi</li> <li><strong>Corte :</strong> Body-hugging com drapeado natural</li> <li><strong>Estilo:</strong> Sofisticado e moderno</li> <li><strong>Ocasiões:</strong> Noites elegantes e eventos especiais</li> </ul>
stylingtips
string<p>Realce o seu vestido com as nossas <a href="https://www.divasboudoir.com/pt/meias-de-tamanho-grande/">meias</a> finas <a href="https://www.divasboudoir.com/pt/meias-de-tamanho-grande/">de tamanho</a> grande para um visual sofisticado totalmente preto, ou adicione a nossa <a href="https://www.divasboudoir.com/pt/roupa-de-noite-plus-size/">roupa de noite</a> preta de <a href="https://www.divasboudoir.com/pt/roupa-de-noite-plus-size/">tamanho</a> grande para a harmonia perfeita.</p> <p>Complete o look com os nossos <a href="https://www.divasboudoir.com/pt/vestidos-sexys-plus-size/">vestidos sexy plus size</a> para criar um guarda-roupa elegante, ou explore os nossos <a href="https://www.divasboudoir.com/fr/tenues-sexy-grande-taille/">conjuntos sexy plus size</a> para looks mais sofisticados. Esta criação única revela o seu sentido de estilo com uma elegância moderna perturbadora.</p>
summary
string<p>Descubra este vestido assimétrico em voile preto que revoluciona a arte da elegância moderna! Os seus ombros descobertos e os pormenores transparentes criam um efeito dramático impressionante.</p> <p>Com o seu drapeado natural e o seu comprimento midi perfeito, esta criação transforma cada aparição num momento de pura sofisticação.</p>
title
stringVestido preto assimétrico com véu - Elegância e sofisticação dramáticas
usageinstructions
string<p>Coloque suavemente este vestido, tendo cuidado com o véu transparente. O drapeado <strong>assimétrico é posicionado naturalmente</strong> para criar aquela silhueta icónica que a distingue. O corte justo abraça a sua forma sem constrangimentos, permitindo uma total liberdade de movimentos.</p> <p>Este vestido <strong>adapta-se perfeitamente a todas as formas do corpo</strong> graças ao seu design estudado e aos materiais flexíveis. Use-o com confiança para revelar o seu lado sofisticado nas suas noites mais elegantes.</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
stringsz2410311303517507
netweight
string
nextshipment
stringtomorrow
ordered
number3
orderidx
number0
origin
string
originalsize
string
packaging
number0
productshipment
stringauto
productuid
string9FAA34B1-01C4-4877-BACCC4F0E820BCC9
promountil
string
rating
stringnone
recorduid
string9FAA34B1-01C4-4877-BACCC4F0E820BCC9
reference
stringCDBU3069
related
string
reserved
number0
returned
number0
returnsallowed
number1
section
stringcabaret
shipment
string5to7days
showbrand
number0
sizeinfos
Query
Template: /system/api/product/sizes.cfc:20
Execution Time: 1.52 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,'2351,2352,2353,2354,2355') > 0
and product_variations.productuid = '9FAA34B1-01C4-4877-BACCC4F0E820BCC9'
and intlsize <> 'na'
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_sizes.id_size, product_variations.color
order by FIELD(product_sizes.gender,'w','m'), product_sizes.sizegroup, FIELD(intlsize,'XS','S','S/M','S-M','M','M/L','M-L','L','L-XL','L/XL','XL','0X','0XL','lXL','1X','1X-2X','1X/2X','XL/2XL','XL-2XL','1XL-2XL','2XL','2X','XXL','2X-3X','2X/3X','2XL-3XL','2XL/3XL','XXXL','3XL','3X','3X-4X','3X/4X','3XL-4XL','3XL/4XL','4XL','5XL','5X','5X-6X','5X/6X','5XL-6XL','5XL/6XL','6XL','6X','7XL','7X','8XL','8X'), cast(intlsize as SIGNED ), groupavailable desc, stock desc
recorduidsizesizetypecolorparam1param2availablegroupavailablestockgendersizerangesizegroupsuppliersizeintlsizeincheseusizeussizeuksizefrsizeessizedesizeitsizeptsizeelsizebustwaisthipunderbustcupthighlegheightbodyheightbodyweight
123554Xintlsizeblack4X4X-19999990wplusdress4XL4X50-5220-2224-2652-5452-5450-5256-5852-5450-52128-134107-112133-140
22351XLintlsizeblackXLXL000wplusdress0XLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42100-10779-86105-112
323521Xintlsizeblack1X1X-19999990wplusdress1XL1X44-4614-1618-2046-4846-4844-4650-5246-4844-46107-11486-93112-119
423532XLintlsizeblack2XL2XL-19999990wplusdress2XL2XL46-4816-1820-2248-5048-5046-4852-5448-5046-48114-12193-100119-126
523543Xintlsizeblack3X3X-19999990wplusdress3XL3X48-5018-2022-2450-5250-5248-5054-5650-5248-50121-128100-107126-133
sizeranges
stringplus
sizes
string2351,2352,2353,2354,2355
sizetype
stringauto
specifications
Struct
Entries: 23
belly
string
bones
string
bra
string
breasts
string
bust
string
closing
string
crochtless
string
cups
string
cut
string
garter
string
halter
string
lacing
string
lining
string
modestypanel
string
panty
string
sheathing
string
sleeves
string
stocking
string
straps
string
stretch
string
suspenders
string
transparency
string
underwires
string
stock
number0
stocks
Query
Template: /system/api/product/stocks.cfc:25
Execution Time: 49.6 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 = '9FAA34B1-01C4-4877-BACCC4F0E820BCC9'
and product_variations.isactive = 1
and product_sizes.id_size = 2351
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '9FAA34B1-01C4-4877-BACCC4F0E820BCC9'
and product_variations.isactive = 1
and product_sizes.id_size = 2352
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '9FAA34B1-01C4-4877-BACCC4F0E820BCC9'
and product_variations.isactive = 1
and product_sizes.id_size = 2353
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '9FAA34B1-01C4-4877-BACCC4F0E820BCC9'
and product_variations.isactive = 1
and product_sizes.id_size = 2354
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '9FAA34B1-01C4-4877-BACCC4F0E820BCC9'
and product_variations.isactive = 1
and product_sizes.id_size = 2355
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
) tbl
group by productuid, variationuid, stockuid
order by stockuid, FIELD(gender,'w','m'), sizegroup, FIELD(intlsize,'XS','S','S/M','S-M','M','M/L','M-L','L','L-XL','L/XL','XL','0X','0XL','lXL','1X','1X-2X','1X/2X','XL/2XL','XL-2XL','1XL-2XL','2XL','2X','XXL','2X-3X','2X/3X','2XL-3XL','2XL/3XL','XXXL','3XL','3X','3X-4X','3X/4X','3XL-4XL','3XL/4XL','4XL','5XL','5X','5X-6X','5X/6X','5XL-6XL','5XL/6XL','6XL','6X','7XL','7X','8XL','8X'), cast(intlsize as SIGNED ), color
productuidvariationuidrecorduidcolorhexvaluesuppliersizeintlsizeincheseusizeussizeuksizefrsizeessizedesizeitsizeptsizeelsizegendersizegroupcupsizesizetypeitempriceitempromopromoUntilstockuidwarehouseontourpackagingsupplierreservedorderedreturneddefectmanufacturerreferenceeanavailablestockdisplaycomments
19FAA34B1-01C4-4877-BACCC4F0E820BCC91FE52D12-0B1B-489C-A8D34C273947B3BD2355black#0000004XL4X50-5220-2224-2652-5452-5450-5256-5852-5450-52wdress4Xintlsize41.6250STOCK01000-10100JIT23389189-10all
29FAA34B1-01C4-4877-BACCC4F0E820BCC9D18929CA-AE19-44EF-9DDA87756D09095C2351black#0000000XLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42wdressXLintlsize41.6250STOCK0100000000JIT2338918900all
39FAA34B1-01C4-4877-BACCC4F0E820BCC97930837E-7396-408A-B56AB0194FC5F3022352black#0000001XL1X44-4614-1618-2046-4846-4844-4650-5246-4844-46wdress1Xintlsize41.6250STOCK01000-10200JIT234798452GJ8M0%0161488127-10all
49FAA34B1-01C4-4877-BACCC4F0E820BCC9480C51F8-7ECC-4833-A2C872DACC20A5282353black#0000002XL2XL46-4816-1820-2248-5048-5046-4852-5448-5046-48wdress2XLintlsize41.6250STOCK01000-10000JIT23389189-10all
59FAA34B1-01C4-4877-BACCC4F0E820BCC92CDCB56B-6088-417C-A001CD7A382B0D632354black#0000003XL3X48-5018-2022-2450-5250-5248-5054-5650-5248-50wdress3Xintlsize41.6250STOCK01000-10000JIT23389189-10all
subcategory
stringall
supplier
number-1
supplierreference
stringSZ2410311303517507
tags
string
themes
string
totalvariations
number5
type
stringdefault
unitprice
number41.625
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 10.9 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 = '9FAA34B1-01C4-4877-BACCC4F0E820BCC9' 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 = '9FAA34B1-01C4-4877-BACCC4F0E820BCC9' 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 = '9FAA34B1-01C4-4877-BACCC4F0E820BCC9' 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 = '9FAA34B1-01C4-4877-BACCC4F0E820BCC9' 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 = '9FAA34B1-01C4-4877-BACCC4F0E820BCC9' 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 = '9FAA34B1-01C4-4877-BACCC4F0E820BCC9' 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 = '9FAA34B1-01C4-4877-BACCC4F0E820BCC9'
and product_variations.isactive = 1
and product_sizes.id_size = 2351
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '9FAA34B1-01C4-4877-BACCC4F0E820BCC9' 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 = '9FAA34B1-01C4-4877-BACCC4F0E820BCC9' 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 = '9FAA34B1-01C4-4877-BACCC4F0E820BCC9' 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 = '9FAA34B1-01C4-4877-BACCC4F0E820BCC9' 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 = '9FAA34B1-01C4-4877-BACCC4F0E820BCC9' 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 = '9FAA34B1-01C4-4877-BACCC4F0E820BCC9' 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 = '9FAA34B1-01C4-4877-BACCC4F0E820BCC9'
and product_variations.isactive = 1
and product_sizes.id_size = 2352
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '9FAA34B1-01C4-4877-BACCC4F0E820BCC9' 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 = '9FAA34B1-01C4-4877-BACCC4F0E820BCC9' 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 = '9FAA34B1-01C4-4877-BACCC4F0E820BCC9' 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 = '9FAA34B1-01C4-4877-BACCC4F0E820BCC9' 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 = '9FAA34B1-01C4-4877-BACCC4F0E820BCC9' 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 = '9FAA34B1-01C4-4877-BACCC4F0E820BCC9' 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 = '9FAA34B1-01C4-4877-BACCC4F0E820BCC9'
and product_variations.isactive = 1
and product_sizes.id_size = 2353
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '9FAA34B1-01C4-4877-BACCC4F0E820BCC9' 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 = '9FAA34B1-01C4-4877-BACCC4F0E820BCC9' 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 = '9FAA34B1-01C4-4877-BACCC4F0E820BCC9' 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 = '9FAA34B1-01C4-4877-BACCC4F0E820BCC9' 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 = '9FAA34B1-01C4-4877-BACCC4F0E820BCC9' 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 = '9FAA34B1-01C4-4877-BACCC4F0E820BCC9' 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 = '9FAA34B1-01C4-4877-BACCC4F0E820BCC9'
and product_variations.isactive = 1
and product_sizes.id_size = 2354
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '9FAA34B1-01C4-4877-BACCC4F0E820BCC9' 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 = '9FAA34B1-01C4-4877-BACCC4F0E820BCC9' 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 = '9FAA34B1-01C4-4877-BACCC4F0E820BCC9' 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 = '9FAA34B1-01C4-4877-BACCC4F0E820BCC9' 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 = '9FAA34B1-01C4-4877-BACCC4F0E820BCC9' 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 = '9FAA34B1-01C4-4877-BACCC4F0E820BCC9' 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 = '9FAA34B1-01C4-4877-BACCC4F0E820BCC9'
and product_variations.isactive = 1
and product_sizes.id_size = 2355
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
order by FIELD(gender,'w','m'), sizegroup, FIELD(intlsize,'XS','S','S/M','S-M','M','M/L','M-L','L','L-XL','L/XL','XL','0X','0XL','lXL','1X','1X-2X','1X/2X','XL/2XL','XL-2XL','1XL-2XL','2XL','2X','XXL','2X-3X','2X/3X','2XL-3XL','2XL/3XL','XXXL','3XL','3X','3X-4X','3X/4X','3XL-4XL','3XL/4XL','4XL','5XL','5X','5X-6X','5X/6X','5XL-6XL','5XL/6XL','6XL','6X','7XL','7X','8XL','8X'), cast(intlsize as SIGNED ), color
variationuidrecorduidcolorhexvaluesuppliersizeintlsizeincheseusizeussizeuksizefrsizeessizedesizeitsizeptsizeelsizegendersizegroupcupsizesizetypeitempriceitempromopromoUntilstockuidwarehouseontourpackagingsupplierreservedorderedreturneddefectmanufacturerreferenceeanavailablestockavailablepersizestockpersizeavailablepercolorstockpercolorhaspromounitpricedisplaycomments
11FE52D12-0B1B-489C-A8D34C273947B3BD2355black#0000004XL4X50-5220-2224-2652-5452-5450-5256-5852-5450-52wdress4Xintlsize41.6250STOCK01000-10100JIT23389189-10-10-10041.625all
2D18929CA-AE19-44EF-9DDA87756D09095C2351black#0000000XLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42wdressXLintlsize41.6250STOCK0100000000JIT233891890000-10041.625all
37930837E-7396-408A-B56AB0194FC5F3022352black#0000001XL1X44-4614-1618-2046-4846-4844-4650-5246-4844-46wdress1Xintlsize41.6250STOCK01000-10200JIT234798452GJ8M0%0161488127-10-10-10041.625all
4480C51F8-7ECC-4833-A2C872DACC20A5282353black#0000002XL2XL46-4816-1820-2248-5048-5046-4852-5448-5046-48wdress2XLintlsize41.6250STOCK01000-10000JIT23389189-10-10-10041.625all
52CDCB56B-6088-417C-A001CD7A382B0D632354black#0000003XL3X48-5018-2022-2450-5250-5248-5054-5650-5248-50wdress3Xintlsize41.6250STOCK01000-10000JIT23389189-10-10-10041.625all
vatrate
number20
warehouse
number0