Voir les tailles
Robe Longue noire Col Montant - Majesté Moderne et Allure Statuesque
Double-cliquez pour agrandir
SKU: CDBU4359
Robe Longue noire Col Montant - Majesté Moderne et Allure Statuesque
Stock:

Incarnez la majesté moderne avec cette robe longue noire au col montant sculptural ! Son drapé magistral au niveau de la taille et sa longueur au sol créent une silhouette statuesque d'une élégance absolue.

Avec son effet architectural et sa fluidité gracieuse, cette création transforme chaque apparition en moment de pure fascination.

Points forts

  • Col montant sculptural qui allonge délicatement le cou avec modernité
  • Drapé magistral au niveau de la taille qui affine naturellement la silhouette
  • Longueur maxi au sol pour un effet balayage théâtral
  • noir intemporel qui sublime toutes les carnations
  • Coupe sans manches qui révèle les bras avec élégance
  • Effet sculptant qui harmonise parfaitement toutes les morphologies
  • Fluidité gracieuse qui crée un mouvement hypnotique
  • Style architectural parfait pour événements prestigieux
Taille:

Vous ne savez pas quelle taille choisir? Consultez notre guide des tailles

Couleur:
Quantité:
74.95 €
Conseils avisés
par chat, facebook ou par e-mail
Retours gratuits
sous 15 jours *

Robe grande taille longue noire col montant drapé sculptant

Description du produit

Cette robe longue révolutionne l'art de l'élégance moderne avec son col montant sculptural qui crée un effet architectural saisissant. Cette ligne épurée allonge délicatement votre cou tout en apportant cette dimension contemporaine qui fait sensation.

Le drapé magistral au niveau de la taille transforme cette robe en véritable œuvre d'art portable. Ces plis et fronces créent un effet sculptant qui affine naturellement la silhouette tout en gommant discrètement les petites zones que vous souhaitez harmoniser. La longueur maxi au sol crée cette allure de déesse moderne qui ne passe jamais inaperçue. L'effet balayage apporte cette théâtralité sophistiquée qui transforme chaque pas en moment de pure grâce. Le noir profond intemporel sublime toutes les carnations et s'adapte à toutes les occasions les plus prestigieuses. Cette couleur révèle votre goût pour l'excellence et votre sens du style affirmé.

La coupe sans manches révèle vos bras avec une élégance naturelle, créant cette ligne épurée qui s'adapte parfaitement à toutes les morphologies. Le tissu fluide épouse délicatement vos courbes sans contrainte. La fluidité gracieuse du tissu crée ce mouvement hypnotique à chaque déplacement, révélant votre beauté naturelle avec une sophistication qui transcende les conventions. Quand vous portez cette robe, vous devenez cette icône moderne qui hypnotise avec sa majesté architecturale et son aura magnétique irrésistible.

Détails techniques

  • Type : Robe longue maxi
  • Couleur : noir profond intemporel
  • Col : Montant sculptural sans manches
  • Drapé : Magistral au niveau de la taille
  • Longueur : Maxi au sol avec effet balayage
  • Coupe : Fluide avec effet sculptant
  • Style : Architectural moderne
  • Occasions : Événements prestigieux et soirées d'exception

Tailles disponibles

Disponible du 4X au 3X

Couleur disponible

Noir

Guide de taille

Vérifiez la taille qui vous convient

International
  • Poitrine
  • Taille
  • Hanches
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

Conseils d'entretien

  • Lavage à la main à l'eau froide pour préserver le noir profond
  • Utiliser une lessive douce sans agents blanchissants
  • Séchage à plat pour maintenir la forme du drapé
  • Ne jamais repasser directement sur les plis sculptants
  • Suspendre délicatement pour éviter les marques
  • Ranger dans une housse pour protéger la longueur maxi

Conseils d'utilisation

Enfilez délicatement cette robe en prenant soin du col montant sculptural qui se positionne naturellement. Le drapé magistral se place automatiquement pour créer cet effet sculptant qui harmonise votre silhouette. La longueur maxi demande une attention particulière lors des déplacements pour préserver l'effet balayage élégant. Cette robe sublime toutes les morphologies grâce à son drapé technique et sa coupe fluide. Portez-la avec assurance pour révéler votre côté majestueux lors de vos événements les plus prestigieux.

Conseils de style

Sublimez votre robe avec nos bas grande taille fins pour un look total black sophistiqué, ou ajoutez nos kimonos grande taille en soie pour une élégance superposée.

Complétez avec nos culottes grande taille noires pour une harmonie parfaite, ou explorez nos robes sexys grande taille de la même collection pour multiplier les looks architecturaux. Cette création unique révèle votre sens du style avec une majesté moderne troublante.

To Top
Articles
Total articles
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.74 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129'
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 18:59:52'}
defect
number0
dimensions
Struct
Entries: 14
acrylicbones
string
backsideheight
string
diameter
string
flatsteelbones
string
frontsideheight
string
fullheight
string
length
string
modestysize
string
panels
string
sides
string
spiralsteelbones
string
totallength
string
unit
stringcm
wiresize
string
display
stringall
displayfrom
string
displayto
string
grossweight
string
hasbrandinfos
booleanfalse
hascareinstructions
booleantrue
hascolorinfos
booleantrue
hascompositions
booleanfalse
hasdescription
booleantrue
hasdimensions
booleanfalse
hasmaterials
booleanfalse
hasotherspecifications
booleanfalse
haspromo
number0
hasshortdescription
booleantrue
hassizeinfos
booleantrue
hasspecifications
booleantrue
hasstockinfos
booleanfalse
hasstylingtips
booleantrue
hasusageinstructions
booleantrue
hasvariations
booleantrue
import
string
inpromo
number0
instockvariations
number0
isactive
number1
iscustommade
number0
isdivasize
number0
isfirstprice
number0
isfixedprice
number0
ishot
number0
isnew
number0
isonline
number0
isoutletprice
number0
itemprice
number62.4583
itempromo
string
key
stringsz2412104818876472-longue
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-08-07 12:00:32'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.685 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','fr')
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('6be1b1ec-c4b1-4e0d-83e7b3321b764129',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.38 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','fr')
and product_categories.language in ('all','fr')
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 <> 'CDBU4359'
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
string1736
isprivate
string0
rating
stringall
src
string/photobank/products/dvqc/cdbu4359/longue_robe_grande_taille_col_montant_detail.jpg
type
stringimg
width
string1201
back
Struct
height
string1697
isprivate
string0
rating
stringall
src
string/photobank/products/dvqc/cdbu4359/longue_robe_grande_taille_col_montant_dos.jpg
type
stringimg
width
string1174
default
Struct
height
string988
isprivate
string0
rating
stringall
src
string/photobank/products/dvqc/cdbu4359/longue_robe_grande_taille_col_montant.jpg
type
stringimg
width
string683
variations
Struct
colors
Struct
black
Struct
height
string1736
isprivate
string0
rating
stringall
src
string/photobank/products/dvqc/cdbu4359/longue_robe_grande_taille_col_montant_detail.jpg
type
stringimg
width
string1201
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 das tiefe Schwarz zu erhalten</li> <li>Verwenden Sie ein mildes Waschmittel ohne Bleichmittel</li> <li>Flach trocknen, um die Form der Drapierung zu erhalten.</li> <li>Niemals direkt über die formgebenden Falten bügeln</li> <li>Vorsichtig aufhängen, um Abdrücke zu vermeiden</li> <li>In einer Hülle aufbewahren, um die maximale Länge zu schützen</li> </ul>
description
string<p>Dieses lange Kleid revolutioniert die Kunst der modernen Eleganz mit seinem <strong>skulpturalen Stehkragen</strong>, der einen auffallenden architektonischen Effekt erzeugt. Diese klare Linie verlängert sanft Ihren Hals und verleiht ihm gleichzeitig diese zeitgenössische Dimension, die für Aufsehen sorgt.</p> <p>Die <strong>meisterhafte Drapierung im Taillenbereich</strong> verwandelt dieses Kleid in ein tragbares Kunstwerk. Diese Falten und Kräuselungen erzeugen einen formenden Effekt, der die Silhouette auf natürliche Weise schlanker erscheinen lässt und gleichzeitig kleine Bereiche, die Sie harmonisieren möchten, dezent ausgleicht. Die <strong>bodenlange Maxilänge</strong> schafft den Look einer modernen Göttin, die nie unbemerkt bleibt. Der Balayage-Effekt sorgt für diese raffinierte Theatralik, die jeden Schritt in einen Moment purer Anmut verwandelt. Das <strong>zeitlose Tiefschwarz</strong> unterstreicht jeden Hautton und passt zu den prestigeträchtigsten Anlässen. Diese Farbe verrät Ihre Vorliebe für Exzellenz und Ihren ausgeprägten Sinn für Stil.</p> <p>Der <strong>ärmellose Schnitt</strong> enthüllt Ihre Arme mit natürlicher Eleganz und schafft eine klare Linie, die <strong>sich perfekt an jede Körperform anpasst</strong>. Der fließende Stoff schmiegt sich sanft und ohne Zwang an Ihre Kurven. Der <strong>anmutig fließende</strong> Stoff erzeugt bei jeder Bewegung diese hypnotische Bewegung und enthüllt Ihre natürliche Schönheit mit einer Raffinesse, die Konventionen überwindet. Wenn Sie dieses Kleid tragen, werden Sie zu dieser modernen Ikone, die mit ihrer architektonischen Erhabenheit und ihrer unwiderstehlichen magnetischen Aura hypnotisiert.</p>
guid
stringhttps://dev.divasboudoir.com/de/kleid-große-Größe-lang-schwarz-Stehkragen-drapiert/cdbu4359.htm
highlights
string<ul> <li><strong>Skulpturaler Stehkragen</strong>, der den Hals sanft und modern verlängert.</li> <li><strong>Meisterhafte Drapierung</strong> auf Taillenhöhe, die die Silhouette auf natürliche Weise schlanker wirken lässt</li> <li><strong>Bodenlange Maxilänge</strong> für einen theatralischen Sweep-Effekt</li> <li><strong>zeitloses Schwarz</strong>, das alle Hauttöne hervorhebt</li> <li><strong>Ärmelloser Schnitt</strong>, der die Arme elegant enthüllt</li> <li><strong>Figurformender Effekt</strong>, der alle Körperformen perfekt harmonisiert</li> <li><strong>Anmutige fließende Linien</strong>, die eine hypnotische Bewegung erzeugen</li> <li>Perfekter<strong>architektonischer Stil</strong> für prestigeträchtige Veranstaltungen</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringLanges Kleid in großen Größen schwarz mit Stehkragen: formende Drapierung, Maxilänge, Architektureffekt, fließender Schnitt. Moderne Majestät und Eleganz | Diva's Boudoir
keywords
string
title
stringLanges Kleid in großer Größe schwarz Stehkragen drapiert | Diva's Boudoir
seotitle
stringKleid große Größe lang schwarz Stehkragen drapiert skulptural
seouri
stringkleid-große-Größe-lang-schwarz-Stehkragen-drapiert
specifications
string<ul> <li><strong>Typ:</strong> Langes Maxikleid</li> <li><strong>Farbe:</strong> zeitloses Tiefschwarz</li> <li><strong>Kragen:</strong> Skulptural ansteigend<strong>,</strong> ärmellos</li> <li><strong>Drapierung:</strong> Magistral auf Taillenhöhe</li> <li><strong>Länge:</strong> Maxi bodenlang mit Sweeping-Effekt</li> <li><strong>Schnitt:</strong> Fließend mit skulpturaler Wirkung</li> <li><strong>Stil:</strong> Modernes architektonisches Design</li> <li><strong>Anlässe:</strong> Prestigeträchtige Veranstaltungen und außergewöhnliche Abende</li> </ul>
stylingtips
string<p>Veredeln Sie Ihr Kleid mit unseren <a href="https://www.divasboudoir.com/de/strumpfe-in-grossen-grossen/">Feinstrümpfen in</a> Übergröße für einen raffinierten Total-Black-Look, oder fügen Sie unsere <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">Seidenkimonos in Übergröße</a> für einen eleganten Lagenlook hinzu.</p> <p>Ergänzen Sie sie mit unseren schwarzen <a href="https://www.divasboudoir.com/de/slips-in-grossen-grossen/">Slips</a> in Übergröße für eine perfekte Harmonie, oder erkunden Sie unsere <a href="https://www.divasboudoir.com/de/sexy-kleider-in-grossen-grossen/">sexy Kleider in Übergröße</a> aus der gleichen Kollektion, um die architektonischen Looks zu vervielfachen. Diese einzigartige Kreation offenbart Ihren Sinn für Stil mit einer beunruhigenden modernen Majestät.</p>
summary
string<p>Verkörpern Sie die moderne Majestät mit diesem schwarzen Maxikleid mit skulpturalem Stehkragen! Seine meisterhafte Drapierung auf Taillenhöhe und seine Bodenlänge schaffen eine statueske Silhouette von absoluter Eleganz.</p> <p>Mit ihrem architektonischen Effekt und dem anmutig fließenden Muster verwandelt diese Kreation jeden Auftritt in einen Moment purer Faszination.</p>
title
stringLanges schwarzes Kleid mit Stehkragen - Moderne Majestät und Statuenhafte Ausstrahlung
usageinstructions
string<p>Ziehen Sie dieses Kleid sanft an und achten Sie dabei auf den skulpturalen Stehkragen, der sich natürlich positioniert. Die <strong>meisterhafte Drapierung</strong> platziert sich automatisch, um diesen figurformenden Effekt zu erzeugen, der Ihre Silhouette harmonisiert. Die Maxilänge erfordert besondere Aufmerksamkeit beim Tragen, um den eleganten Sweep-Effekt zu erhalten. Dieses Kleid ist dank der technischen Drapierung und des fließenden Schnitts für <strong>jeden Körperbau</strong> geeignet. Tragen Sie es selbstbewusst, um Ihre majestätische Seite bei Ihren prestigeträchtigsten Veranstaltungen 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> υποβόσκει σε όλους τους τόνους του δέρματος και είναι ιδανικό για τις πιο επίσημες περιστάσεις. Αυτό το χρώμα αποκαλύπτει το γούστο σας για την τελειότητα και τη διεκδικητική αίσθηση του στυλ σας.</p> <p>Το <strong>αμάνικο κόψιμο</strong> αποκαλύπτει τα μπράτσα σας με φυσική κομψότητα, δημιουργώντας μια κομψή γραμμή που <strong>είναι ιδανική για κάθε σωματότυπο</strong>. Το ρευστό ύφασμα αγκαλιάζει απαλά τις καμπύλες σας χωρίς περιορισμούς. Η <strong>χαριτωμένη ρευστότητα</strong> του υφάσματος δημιουργεί αυτή την υπνωτική κίνηση σε κάθε σας κίνηση, αποκαλύπτοντας τη φυσική σας ομορφιά με μια φινέτσα που ξεπερνά τις συμβάσεις. Όταν φοράτε αυτό το φόρεμα, γίνεστε αυτό το σύγχρονο είδωλο που υπνωτίζει με το αρχιτεκτονικό του μεγαλείο και την ακαταμάχητη μαγνητική του αύρα.</p>
guid
stringhttps://dev.divasboudoir.com/el/makry-mayro-forema-me-pshlo-gIaka/cdbu4359.htm
highlights
string<ul> <li><strong>Το γλυπτό κολάρο επι</strong> μηκύνει απαλά το λαιμό με ένα μοντέρνο twist.</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Μαύρο μάξι φόρεμα με ψηλό λαιμό: σμιλευτικό ντραπέ, μάξι μήκος, αρχιτεκτονικό αποτέλεσμα, ρευστό κόψιμο. Σύγχρονη μεγαλοπρέπεια και κομψότητα | Diva's Boudoir
keywords
string
title
stringΜαύρο μάξι φόρεμα με ψηλή λαιμόκοψη | Diva's Boudoir
seotitle
stringΜακρύ μαύρο φόρεμα με ψηλό λαιμό και σμιλευτικό ντραπέ
seouri
stringμακρύ-μαύρο-φόρεμα-με-ψηλό-γιακά
specifications
string<ul> <li><strong>Τύπος :</strong> Maxi φόρεμα</li> <li><strong>Χρώμα :</strong> διαχρονικό βαθύ μαύρο</li> <li><strong>Κολάρο :</strong> Γλυπτικός αμάνικος γιακάς</li> <li><strong>Drap&eacute; :</strong> Μαγκιστράλ στη μέση</li> <li><strong>Μήκος :</strong> Maxi μήκος δαπέδου με σαρωτικό αποτέλεσμα</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 look ή προσθέστε τα μεταξωτά μας <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">κιμονό plus size</a> για κομψότητα σε στρώσεις.</p> <p>Ολοκληρώστε την εμφάνιση με τα μαύρα <a href="https://www.divasboudoir.com/el/eswroychwn-syn-megethos/">plus size εσώρουχά</a> μας για τέλεια αρμονία, ή εξερευνήστε τα <a href="https://www.divasboudoir.com/el/sexi-foremata-syn-megethos/">σέξι plus size φορέματά</a> μας από την ίδια συλλογή για πιο αρχιτεκτονικές εμφανίσεις. Αυτή η μοναδική δημιουργία αποκαλύπτει την αίσθηση του στυλ σας με ανησυχητική σύγχρονη μεγαλοπρέπεια.</p>
summary
string<p>Ενσαρκώστε τη σύγχρονη μεγαλοπρέπεια σε αυτό το μαύρο μάξι φόρεμα με τον γλυπτικό όρθιο γιακά! Το αριστοτεχνικό ντραπέ του στη μέση και το μήκος του στο πάτωμα δημιουργούν μια αγαλματένια σιλουέτα απόλυτης κομψότητας.</p> <p>Με το αρχιτεκτονικό του αποτέλεσμα και τη χαριτωμένη ρευστότητά του, αυτή η δημιουργία μετατρέπει κάθε εμφάνιση σε μια στιγμή καθαρής γοητείας.</p>
title
stringΜαύρο Maxi φόρεμα με ψηλό λαιμό - Σύγχρονη μεγαλοπρέπεια και αγαλματένια γοητεία
usageinstructions
string<p>Φορέστε απαλά αυτό το φόρεμα, φροντίζοντας να τοποθετήσετε φυσικά το γλυπτικό όρθιο κολάρο. Το <strong>αριστοτεχνικό τύλιγμα</strong> τοποθετείται αυτόματα για να δημιουργήσει αυτό το γλυπτικό αποτέλεσμα που εναρμονίζει τη σιλουέτα σας. Το μάξι μήκος απαιτεί ιδιαίτερη προσοχή όταν κινείστε για να διατηρήσετε το κομψό σαρωτικό αποτέλεσμα. Αυτό το φόρεμα <strong>είναι ιδανικό για όλους τους σωματότυπους</strong> χάρη στο τεχνικό ντραπέ του και το ρευστό του κόψιμο. Φορέστε το με αυτοπεποίθηση για να αποκαλύψετε τη μεγαλοπρεπή πλευρά σας στις πιο σημαντικές εκδηλώσεις σας.</p>
en
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Hand wash in cold water to preserve the deep black color</li> <li>Use a mild detergent without bleaching agents</li> <li>Dry flat to maintain drape shape</li> <li>Never iron directly over sculpting folds</li> <li>Hang delicately to avoid marks</li> <li>Store in a bag to protect maxi length</li> </ul>
description
string<p>This maxi dress revolutionizes the art of modern elegance with its <strong>sculptural stand-up collar</strong> that creates a striking architectural effect. The sleek lines delicately elongate your neck, while adding a contemporary dimension that's sure to make a statement.</p> <p>The <strong>masterful draping at the waist</strong> transforms this dress into a wearable work of art. These pleats and gathers create a sculpting effect that naturally refines the silhouette while discreetly erasing any small areas you wish to harmonize. The <strong>floor-length maxi</strong> creates that modern goddess look that never goes unnoticed. The sweeping effect adds a sophisticated theatricality that transforms every step into a moment of pure grace. <strong>Timeless deep black</strong> sublimates all skin tones and adapts to the most prestigious occasions. This color reveals your taste for excellence and your assertive sense of style.</p> <p>The <strong>sleeveless cut</strong> reveals your arms with natural elegance, creating a sleek line that <strong>adapts perfectly to all body types</strong>. The flowing fabric gently hugs your curves without constraint. The <strong>graceful fluidity</strong> of the fabric creates that hypnotic movement with every shift, revealing your natural beauty with a sophistication that transcends convention. When you wear this dress, you become that modern icon that hypnotizes with its architectural majesty and irresistible magnetic aura.</p>
guid
stringhttps://dev.divasboudoir.com/en/plus-size-long-black-high-neck-drape-dress/cdbu4359.htm
highlights
string<ul> <li><strong>Sculptural stand-up collar</strong> delicately elongates the neck with modernity</li> <li><strong>Masterful draping</strong> at the waist naturally refines the silhouette</li> <li><strong>Floor-length maxi</strong> for a theatrical sweeping effect</li> <li><strong>timeless black</strong> to sublimate all skin tones</li> <li><strong>Sleeveless cut</strong> that elegantly reveals the arms</li> <li><strong>Sculpting effect</strong> perfectly harmonizes all morphologies</li> <li><strong>Graceful fluidity</strong> creates hypnotic movement</li> <li><strong>Architectural style</strong> perfect for prestigious events</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringBlack high neck plus size maxi dress: sculpting drape, maxi length, architectural effect, fluid cut. Modern majesty and elegance | Diva's Boudoir
keywords
string
title
stringLong dress plus size black high collar draped | Diva's Boudoir
seotitle
stringPlus size long black dress with high collar and sculpting drape
seouri
stringplus-size-long-black-high-neck-drape-dress
specifications
string<ul> <li><strong>Type:</strong> maxi long dress</li> <li><strong>Color:</strong> timeless deep black</li> <li><strong>Collar</strong>: Sculptural, sleeveless stand-up collar</li> <li><strong>Drap&eacute;:</strong> Magistral at the waist</li> <li><strong>Length:</strong> floor-length maxi with sweeping effect</li> <li><strong>Cut:</strong> Fluid with sculpting effect</li> <li><strong>Style:</strong> Modern architectural</li> <li><strong>Occasions:</strong> Prestigious events and special evenings</li> </ul>
stylingtips
string<p>Enhance your dress with our slim <a href="https://www.divasboudoir.com/en/socks-large-size/">plus-size stockings</a> for a sophisticated total black look, or add our silk <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">plus-size kimonos</a> for layered elegance.</p> <p>Complete the look with our black <a href="https://www.divasboudoir.com/en/plus-size-panties/">plus size panties</a> for perfect harmony, or explore our <a href="https://www.divasboudoir.com/en/sexys-plus-size-dresses/">sexy plus size dresses</a> from the same collection to multiply architectural looks. This unique creation reveals your sense of style with unsettling modern majesty.</p>
summary
string<p>Embody modern majesty in this black maxi dress with sculptural stand-up collar! Its masterful waist drape and floor-length create a statuesque silhouette of absolute elegance.</p> <p>With its architectural effect and graceful fluidity, this creation transforms every appearance into a moment of pure fascination.</p>
title
stringBlack High Neck Maxi Dress - Modern Majesty and Statuesque Allure
usageinstructions
string<p>Gently slip this dress on, taking care to position the sculptural stand-up collar naturally. The <strong>magisterial drape</strong> moves into place automatically to create that sculpting effect that harmonizes your silhouette. The maxi length requires special attention when moving to preserve the elegant sweeping effect. Thanks to its technical drape and fluid cut, this dress <strong>is perfect for all body types</strong>. Wear it with confidence to reveal your majestic side at your most prestigious events.</p>
es
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavar a mano en agua fría para conservar el color negro intenso</li> <li>Utilizar un detergente suave sin blanqueantes</li> <li>Séquela en plano para mantener la forma del drapeado</li> <li>Nunca planchar directamente sobre los pliegues esculpidos</li> <li>Colgar suavemente para evitar marcas</li> <li>Guardar en una bolsa para proteger la longitud máxima</li> </ul>
description
string<p>Este maxi vestido revoluciona el arte de la elegancia moderna con su <strong>escultural cuello alzado</strong> que crea un sorprendente efecto arquitectónico. Su elegante diseño alarga el cuello con delicadeza y añade una dimensión contemporánea que no pasa desapercibida.</p> <p>El <strong>magistral drapeado en la cintura</strong> transforma este vestido en una obra de arte ponible. Los pliegues y fruncidos crean un efecto escultural que afina la silueta de forma natural al tiempo que borra discretamente cualquier pequeña zona que desee armonizar. El <strong>maxi largo hasta el suelo</strong> crea ese look de diosa moderna que nunca pasa desapercibido. El efecto barrido añade una sofisticada teatralidad que transforma cada paso en un momento de pura gracia. <strong>El atemporal negro intenso</strong> sublima todos los tonos de piel y es perfecto para las ocasiones más prestigiosas. Este color revela su gusto por la excelencia y su asertivo sentido del estilo.</p> <p>El <strong>corte sin mangas</strong> revela sus brazos con elegancia natural, creando una línea elegante <strong>perfecta para cada tipo de cuerpo</strong>. El tejido fluido abraza suavemente sus curvas sin constreñirlas. La <strong>grácil fluidez</strong> del tejido crea ese movimiento hipnótico con cada movimiento, revelando tu belleza natural con una sofisticación que trasciende las convenciones. Cuando llevas este vestido, te conviertes en ese icono moderno que hipnotiza con su majestuosidad arquitectónica y su irresistible aura magnética.</p>
guid
stringhttps://dev.divasboudoir.com/es/maxi-vestido-negro-largo-con-cuello-alto-drapeado/cdbu4359.htm
highlights
string<ul> <li><strong>El escultural cuello alzado</strong> alarga suavemente el cuello con un toque moderno</li> <li><strong>Magistral drapeado</strong> en la cintura que afina la silueta de forma natural</li> <li><strong>Largo maxi hasta el suelo</strong> para un efecto de barrido teatral</li> <li><strong>negro atemporal</strong> que realza todos los tonos de piel</li> <li><strong>Corte sin mangas</strong> que deja ver los brazos con elegancia</li> <li><strong>Efecto esculpido</strong> que se adapta perfectamente a todas las formas del cuerpo</li> <li><strong>Su fluidez</strong> crea un movimiento hipnótico</li> <li><strong>Estilo arquitectónico</strong> perfecto para eventos de prestigio</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringMaxi vestido negro de cuello alto: caída escultural, largo maxi, efecto arquitectónico, corte fluido. Majestuosidad y elegancia modernas | Diva's Boudoir
keywords
string
title
stringMaxi vestido negro con cuello alto drapeado | Diva's Boudoir
seotitle
stringVestido largo negro de cuello grande y caída escultural
seouri
stringmaxi-vestido-negro-largo-con-cuello-alto-drapeado
specifications
string<ul> <li><strong>Tipo :</strong> Maxi vestido</li> <li><strong>Color :</strong> Negro profundo atemporal</li> <li><strong>Cuello :</strong> Cuello escultural sin mangas</li> <li><strong>Drap&eacute; :</strong> Magistral en la cintura</li> <li><strong>Largo :</strong> Maxi largo hasta el suelo con efecto barrido</li> <li><strong>Corte :</strong> Fluido con efecto esculpido</li> <li><strong>Estilo:</strong> Moderno y arquitectónico</li> <li><strong>Ocasiones :</strong> Eventos de prestigio y veladas especiales</li> </ul>
stylingtips
string<p>Realza tu vestido con nuestros <a href="https://www.divasboudoir.com/es/medias-grandes/">pantalones</a> slim <a href="https://www.divasboudoir.com/es/medias-grandes/">talla</a> grande para un sofisticado look total black, o añade nuestros <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">kimonos</a> de seda <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">talla grande</a> para una elegancia a capas.</p> <p>Completa el look con nuestras <a href="https://www.divasboudoir.com/es/braguitas-de-talla-grande/">braguitas</a> negras <a href="https://www.divasboudoir.com/es/braguitas-de-talla-grande/">talla grande</a> para una armonía perfecta, o explora nuestros <a href="https://www.divasboudoir.com/es/sexys-vestidos-talla-grande/">sexys vestidos talla grande</a> de la misma colección para looks más arquitectónicos. Esta creación única revela tu sentido del estilo con una inquietante majestuosidad moderna.</p>
summary
string<p>Encarna la majestuosidad moderna con este maxivestido negro de escultural cuello alto Su magistral drapeado en la cintura y su largo hasta el suelo crean una silueta escultural de elegancia absoluta.</p> <p>Con su efecto arquitectónico y su grácil fluidez, esta creación transforma cada aparición en un momento de pura fascinación.</p>
title
stringMaxivestido negro de cuello alto - Majestad moderna y encanto escultural
usageinstructions
string<p>Deslice suavemente este vestido, teniendo cuidado de colocar el escultural cuello alto de forma natural. La <strong>magistral caída</strong> se coloca automáticamente para crear ese efecto escultural que armoniza tu silueta. El largo maxi requiere especial atención al moverse para preservar el elegante efecto de barrido. Gracias a su caída técnica y su corte vaporoso, este vestido <strong>se adapta a todo tipo de cuerpos</strong>. Llévelo con confianza para revelar su lado majestuoso en sus eventos más prestigiosos.</p>
fr
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavage &agrave; la main &agrave; l'eau froide pour pr&eacute;server le noir profond</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 les plis sculptants</li> <li>Suspendre d&eacute;licatement pour &eacute;viter les marques</li> <li>Ranger dans une housse pour prot&eacute;ger la longueur maxi</li> </ul>
description
string<p>Cette robe longue r&eacute;volutionne l'art de l'&eacute;l&eacute;gance moderne avec son <strong>col montant sculptural</strong> qui cr&eacute;e un effet architectural saisissant. Cette ligne &eacute;pur&eacute;e allonge d&eacute;licatement votre cou tout en apportant cette dimension contemporaine qui fait sensation.</p> <p>Le&nbsp;<strong>drap&eacute; magistral au niveau de la taille</strong> transforme cette robe en v&eacute;ritable &oelig;uvre d'art portable. Ces plis et fronces cr&eacute;ent un effet sculptant qui affine naturellement la silhouette tout en gommant discr&egrave;tement les petites zones que vous souhaitez harmoniser. La <strong>longueur maxi au sol</strong> cr&eacute;e cette allure de d&eacute;esse moderne qui ne passe jamais inaper&ccedil;ue. L'effet balayage apporte cette th&eacute;&acirc;tralit&eacute; sophistiqu&eacute;e qui transforme chaque pas en moment de pure gr&acirc;ce. Le <strong>noir profond intemporel</strong> sublime toutes les carnations et s'adapte &agrave; toutes les occasions les plus prestigieuses. Cette couleur r&eacute;v&egrave;le votre go&ucirc;t pour l'excellence et votre sens du style affirm&eacute;.</p> <p>La&nbsp;<strong>coupe sans manches</strong> r&eacute;v&egrave;le vos bras avec une &eacute;l&eacute;gance naturelle, cr&eacute;ant cette ligne &eacute;pur&eacute;e qui <strong>s'adapte parfaitement &agrave; toutes les morphologies</strong>. Le tissu fluide &eacute;pouse d&eacute;licatement vos courbes sans contrainte. La <strong>fluidit&eacute; gracieuse</strong> du tissu cr&eacute;e ce mouvement hypnotique &agrave; chaque d&eacute;placement, r&eacute;v&eacute;lant votre beaut&eacute; naturelle avec une sophistication qui transcende les conventions. Quand vous portez cette robe, vous devenez cette ic&ocirc;ne moderne qui hypnotise avec sa majest&eacute; architecturale et son aura magn&eacute;tique irr&eacute;sistible.</p>
guid
stringhttps://dev.divasboudoir.com/fr/robe-grande-taille-longue-noire-col-montant-drape/cdbu4359.htm
highlights
string<ul> <li><strong>Col montant sculptural</strong> qui allonge d&eacute;licatement le cou avec modernit&eacute;</li> <li><strong>Drap&eacute; magistral</strong> au niveau de la taille qui affine naturellement la silhouette</li> <li><strong>Longueur maxi au sol</strong> pour un effet balayage th&eacute;&acirc;tral</li> <li><strong>noir intemporel</strong> qui sublime toutes les carnations</li> <li><strong>Coupe sans manches</strong> qui r&eacute;v&egrave;le les bras avec &eacute;l&eacute;gance</li> <li><strong>Effet sculptant</strong> qui harmonise parfaitement toutes les morphologies</li> <li><strong>Fluidit&eacute; gracieuse</strong> qui cr&eacute;e un mouvement hypnotique</li> <li><strong>Style architectural</strong> parfait pour &eacute;v&eacute;nements prestigieux</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringRobe longue grande taille noire col montant : drapé sculptant, longueur maxi, effet architectural, coupe fluide. Majesté moderne et élégance | Diva's Boudoir
keywords
string
title
stringRobe longue grande taille noire col montant drapé | Diva's Boudoir
seotitle
stringRobe grande taille longue noire col montant drapé sculptant
seouri
stringrobe-grande-taille-longue-noire-col-montant-drape
specifications
string<ul> <li><strong>Type :</strong> Robe longue maxi</li> <li><strong>Couleur :</strong> noir profond intemporel</li> <li><strong>Col :</strong> Montant sculptural sans manches</li> <li><strong>Drap&eacute; :</strong> Magistral au niveau de la taille</li> <li><strong>Longueur :</strong> Maxi au sol avec effet balayage</li> <li><strong>Coupe :</strong> Fluide avec effet sculptant</li> <li><strong>Style :</strong> Architectural moderne</li> <li><strong>Occasions :</strong> &Eacute;v&eacute;nements prestigieux et soir&eacute;es d'exception</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/kimono-grande-taille/">kimonos grande taille</a> en soie pour une &eacute;l&eacute;gance superpos&eacute;e.</p> <p>Compl&eacute;tez avec nos&nbsp;<a href="https://www.divasboudoir.com/fr/culottes-grande-taille/">culottes grande taille</a> noires pour une harmonie parfaite, ou explorez nos <a href="https://www.divasboudoir.com/fr/robes-sexys-grande-taille/">robes sexys grande taille</a> de la m&ecirc;me collection pour multiplier les looks architecturaux. Cette cr&eacute;ation unique r&eacute;v&egrave;le votre sens du style avec une majest&eacute; moderne troublante.</p>
summary
string<p>Incarnez la majest&eacute; moderne avec cette robe longue noire au col montant sculptural ! Son drap&eacute; magistral au niveau de la taille et sa longueur au sol cr&eacute;ent une silhouette statuesque d'une &eacute;l&eacute;gance absolue.</p> <p>Avec son effet architectural et sa fluidit&eacute; gracieuse, cette cr&eacute;ation transforme chaque apparition en moment de pure fascination.</p>
title
stringRobe Longue noire Col Montant - Majesté Moderne et Allure Statuesque
usageinstructions
string<p>Enfilez d&eacute;licatement cette robe en prenant soin du col montant sculptural qui se positionne naturellement. Le <strong>drap&eacute; magistral</strong> se place automatiquement pour cr&eacute;er cet effet sculptant qui harmonise votre silhouette. La longueur maxi demande une attention particuli&egrave;re lors des d&eacute;placements pour pr&eacute;server l'effet balayage &eacute;l&eacute;gant. Cette robe <strong>sublime toutes les morphologies</strong> gr&acirc;ce &agrave; son drap&eacute; technique et sa coupe fluide. Portez-la avec assurance pour r&eacute;v&eacute;ler votre c&ocirc;t&eacute; majestueux lors de vos &eacute;v&eacute;nements les plus prestigieux.</p>
it
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavare a mano in acqua fredda per preservare il colore nero intenso</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 sulle pieghe di scolpitura</li> <li>Appendere delicatamente per evitare segni</li> <li>Conservare in un sacchetto per proteggere la lunghezza massima</li> </ul>
description
string<p>Questo maxi abito rivoluziona l'arte dell'eleganza moderna con il suo <strong>colletto scultoreo che</strong> crea un sorprendente effetto architettonico. Il design elegante allunga delicatamente il collo, aggiungendo una dimensione contemporanea che si fa notare.</p> <p>Il <strong>magistrale drappeggio in vita</strong> trasforma questo abito in un'opera d'arte da indossare. Le pieghe e le arricciature creano un effetto scultura che affina naturalmente la silhouette e cancella con discrezione le piccole aree che si desidera armonizzare. La <strong>maxi lunghezza al pavimento</strong> crea un look da dea moderna che non passa mai inosservato. L'effetto "sweeping" aggiunge una sofisticata teatralità che trasforma ogni passo in un momento di pura grazia. <strong>L'intramontabile nero profondo</strong> sublima tutte le tonalità della pelle ed è perfetto per le occasioni più prestigiose. Questo colore rivela il vostro gusto per l'eccellenza e il vostro senso dello stile.</p> <p>Il <strong>taglio senza maniche</strong> rivela le braccia con naturale eleganza, creando una linea elegante <strong>perfetta per ogni tipo di corpo</strong>. Il tessuto fluido abbraccia delicatamente le vostre curve senza costringerle. La <strong>leggiadra fluidità</strong> del tessuto crea un movimento ipnotico a ogni movimento, rivelando la vostra bellezza naturale con una raffinatezza che trascende le convenzioni. Quando indossate questo abito, diventate l'icona moderna che ipnotizza con la sua maestosità architettonica e la sua irresistibile aura magnetica.</p>
guid
stringhttps://dev.divasboudoir.com/it/grande-abito-nero-lungo-con-collo-alto-drappeggiato/cdbu4359.htm
highlights
string<ul> <li><strong>Il colletto scultoreo</strong> allunga delicatamente il collo con un tocco moderno</li> <li><strong>Magistrale drappeggio</strong> in vita che slancia naturalmente la silhouette</li> <li><strong>Maxi lunghezza al pavimento</strong> per un effetto teatrale e avvolgente</li> <li><strong>nero senza tempo</strong> per esaltare tutte le tonalità della pelle</li> <li><strong>Taglio senza maniche</strong> che scopre elegantemente le braccia</li> <li><strong>Effetto scultura</strong> che si adatta perfettamente a tutte le forme del corpo</li> <li><strong>La leggiadra fluidità</strong> crea un movimento ipnotico</li> <li><strong>Stile architettonico</strong> perfetto per eventi prestigiosi</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringMaxi abito nero a collo alto: drappeggio scultoreo, lunghezza maxi, effetto architettonico, taglio fluido. Maestosità ed eleganza moderna | Diva's Boudoir
keywords
string
title
stringGrande abito nero con collo alto drappeggiato | Diva's Boudoir
seotitle
stringAbito lungo nero a collo alto con drappeggio scultoreo
seouri
stringgrande-abito-nero-lungo-con-collo-alto-drappeggiato
specifications
string<ul> <li><strong>Tipo :</strong> maxi abito</li> <li><strong>Colore :</strong> nero profondo senza tempo</li> <li><strong>Colletto :</strong> Colletto scultoreo senza maniche</li> <li><strong>Drappeggio :</strong> Magistrale in vita</li> <li><strong>Lunghezza :</strong> Maxi lunghezza fino al pavimento con effetto ampio</li> <li><strong>Taglio :</strong> Fluido con effetto scultura</li> <li><strong>Stile:</strong> Moderno e architettonico</li> <li><strong>Occasioni:</strong> Eventi prestigiosi e serate speciali</li> </ul>
stylingtips
string<p>Arricchite il vostro abito con i nostri slip slim <a href="https://www.divasboudoir.com/it/calze-di-grandi-dimensioni/">plus size</a> per un sofisticato look total black, oppure aggiungete i nostri <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">kimono</a> in seta <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">taglia grande</a> per un'eleganza a strati.</p> <p>Completate il look con le nostre <a href="https://www.divasboudoir.com/it/mutande-curvy/">mutandine</a> nere <a href="https://www.divasboudoir.com/it/mutande-curvy/">plus size</a> per un'armonia perfetta, oppure esplorate i nostri <a href="https://www.divasboudoir.com/it/abiti-sexys-taglia-grande/">abiti sexy taglia grande</a> della stessa collezione per look più architettonici. Questa creazione unica rivela il vostro senso dello stile con una maestosità moderna e sconvolgente.</p>
summary
string<p>Incarnate la moderna maestosità con questo maxi abito nero dal colletto scultoreo! Il suo magistrale drappeggio in vita e la lunghezza al pavimento creano una silhouette statuaria di assoluta eleganza.</p> <p>Con il suo effetto architettonico e la sua leggiadra fluidità, questa creazione trasforma ogni apparizione in un momento di puro fascino.</p>
title
stringMaxi abito nero a collo alto - Maestosità moderna e fascino statuario
usageinstructions
string<p>Infilate delicatamente questo abito, avendo cura di posizionare naturalmente il colletto scultoreo. Il <strong>magistrale drappeggio</strong> si posiziona automaticamente per creare quell'effetto scultura che armonizza la silhouette. La lunghezza maxi richiede un'attenzione particolare quando ci si muove, per preservare l'elegante effetto ampio. Questo abito <strong>è perfetto per tutte le corporature</strong>, grazie al suo drappeggio tecnico e al taglio fluido. Indossatelo con disinvoltura per rivelare il vostro lato maestoso agli eventi più prestigiosi.</p>
nl
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Handwas in koud water om de diepzwarte kleur te behouden</li> <li>Gebruik een mild wasmiddel zonder bleekmiddelen</li> <li>Plat drogen om de vorm van de stof te behouden</li> <li>Nooit rechtstreeks op de plooien strijken</li> <li>Voorzichtig ophangen om vlekken te voorkomen</li> <li>Bewaar in een zak om de maximale lengte te beschermen</li> </ul>
description
string<p>Deze maxi-jurk revolutioneert de kunst van moderne elegantie met zijn <strong>sculpturale opstaande kraag</strong> die een opvallend architecturaal effect creëert. Het slanke ontwerp verlengt je nek op subtiele wijze en voegt een eigentijdse dimensie toe die een statement maakt.</p> <p>De <strong>meesterlijke drapering in de taille</strong> maakt van deze jurk een draagbaar kunstwerk. Deze plooien en plooien creëren een sculpturaal effect dat het silhouet op natuurlijke wijze verfijnt en tegelijkertijd discreet alle kleine zones wegwerkt die je wilt harmoniseren. De <strong>vloerlange maxi</strong> creëert die moderne godinnenlook die nooit onopgemerkt blijft. Het zwierige effect voegt een geraffineerde theatraliteit toe die elke stap verandert in een moment van pure gratie. <strong>Tijdloos diepzwart</strong> sublimeert alle huidtinten en is perfect voor de meest prestigieuze gelegenheden. Deze kleur onthult je smaak voor uitmuntendheid en je assertieve gevoel voor stijl.</p> <p>De <strong>mouwloze snit</strong> onthult je armen met natuurlijke elegantie en creëert een strakke lijn die <strong>perfect is voor elk lichaamstype</strong>. De vloeiende stof omhelst je rondingen zonder beperkingen. De <strong>sierlijke vloeiendheid</strong> van de stof creëert een hypnotiserende beweging bij elke beweging en onthult je natuurlijke schoonheid met een raffinement dat boven alle conventies uitstijgt. Als je deze jurk draagt, word je dat moderne icoon dat hypnotiseert met zijn architectonische majesteit en onweerstaanbare magnetische uitstraling.</p>
guid
stringhttps://dev.divasboudoir.com/nl/grote-maat-lange-zwarte-jurk-met-gedrapeerde-hoge-kraag/cdbu4359.htm
highlights
string<ul> <li><strong>Sculpturale opstaande kraag</strong> verlengt de hals met een moderne twist</li> <li><strong>Meesterlijke drapering</strong> in de taille die het silhouet op natuurlijke wijze verfijnt</li> <li><strong>Vloerlange maxi</strong> voor een theatraal vegend effect</li> <li><strong>tijdloos zwart</strong> voor alle huidtinten</li> <li><strong>Mouwloze snit</strong> die de armen elegant onthult</li> <li><strong>Sculpturerend effect</strong> dat perfect past bij alle lichaamsvormen</li> <li><strong>Gracieuze vloeiendheid</strong> creëert hypnotiserende beweging</li> <li><strong>Architecturale stijl</strong>, perfect voor prestigieuze evenementen</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringZwarte maxi-jurk met grote maat: sculpturale drapering, maxilengte, architecturaal effect, vloeiende snit. Moderne majesteit en elegantie | Diva's Boudoir
keywords
string
title
stringZwarte grote maat jurk met gedrapeerde hoge hals | Diva's Boudoir
seotitle
stringLange zwarte jurk met grote maat en sculpturale drapering
seouri
stringgrote-maat-lange-zwarte-jurk-met-gedrapeerde-hoge-kraag
specifications
string<ul> <li><strong>Type :</strong> Maxi jurk</li> <li><strong>Kleur :</strong> tijdloos diepzwart</li> <li><strong>Kraag :</strong> Sculpturale mouwloze kraag</li> <li><strong>Drap&eacute; :</strong> Magistraal in de taille</li> <li><strong>Lengte :</strong> Maxi vloerlengte met vloeiend effect</li> <li><strong>Snit :</strong> Vloeiend met sculpturaal effect</li> <li><strong>Stijl:</strong> Modern architecturaal</li> <li><strong>Gelegenheden:</strong> Prestigieuze evenementen en speciale avonden</li> </ul>
stylingtips
string<p>Maak je jurk af met onze slanke <a href="https://www.divasboudoir.com/nl/grote-maat-kousen/">plus size broekjes</a> voor een geraffineerde total black look, of voeg onze zijden <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">plus size kimono's</a> toe voor gelaagde elegantie.</p> <p>Maak de look compleet met onze zwarte <a href="https://www.divasboudoir.com/nl/groote-maten-slipjes/">grote maten slips</a> voor een perfecte harmonie, of ontdek onze <a href="https://www.divasboudoir.com/nl/sexys-jurken-grote-maat/">sexy grote maten jurken</a> uit dezelfde collectie voor meer architectonische looks. Deze unieke creatie onthult je gevoel voor stijl met verontrustende moderne majesteit.</p>
summary
string<p>Belichaam moderne majesteit in deze zwarte maxi-jurk met zijn sculpturale opstaande kraag! De meesterlijke drapering in de taille en de lengte tot op de grond creëren een statuesk silhouet van absolute elegantie.</p> <p>Met zijn architecturale effect en sierlijke vloeiendheid verandert deze creatie elke verschijning in een moment van pure fascinatie.</p>
title
stringZwarte Maxi Dress met hoge hals - Moderne majesteit en statueske allure
usageinstructions
string<p>Trek deze jurk zachtjes aan en zorg ervoor dat de sculpturale opstaande kraag op een natuurlijke manier zit. De <strong>meesterlijke drapering</strong> wordt automatisch gepositioneerd om dat sculpturale effect te creëren dat je silhouet harmoniseert. De maxilengte vraagt speciale aandacht bij het bewegen om het elegante vegende effect te behouden. Deze jurk <strong>is perfect voor alle lichaamstypes</strong>, dankzij de technische drapering en vloeiende snit. Draag hem vol vertrouwen om je van je majestueuze kant te laten zien op je meest prestigieuze evenementen.</p>
pt
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavar à mão em água fria para preservar a cor preta profunda</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 as dobras esculpidas</li> <li>Pendurar suavemente para evitar marcas</li> <li>Guardar num saco para proteger o comprimento máximo</li> </ul>
description
string<p>Este vestido maxi revoluciona a arte da elegância moderna com o seu <strong>colarinho escultural</strong> que cria um efeito arquitetónico impressionante. O design elegante alonga delicadamente o pescoço, acrescentando uma dimensão contemporânea que faz uma afirmação.</p> <p>O drapeado <strong>magistral na cintura</strong> transforma este vestido numa obra de arte que pode ser usada. Estas pregas e franzidos criam um efeito de escultura que afina naturalmente a silhueta, ao mesmo tempo que apaga discretamente quaisquer pequenas áreas que queira harmonizar. O <strong>maxi comprimento até ao chão</strong> cria aquele visual de deusa moderna que nunca passa despercebido. O efeito de varrimento acrescenta uma teatralidade sofisticada que transforma cada passo num momento de pura graça. <strong>O preto profundo e intemporal</strong> sublima todos os tons de pele e é perfeito para as ocasiões mais prestigiadas. Esta cor revela o seu gosto pela excelência e o seu sentido de estilo assertivo.</p> <p>O <strong>corte sem mangas</strong> revela os seus braços com uma elegância natural, criando uma linha elegante que <strong>é perfeita para todos os tipos de corpo</strong>. O tecido fluido abraça suavemente as suas curvas sem constrangimentos. A <strong>fluidez graciosa</strong> do tecido cria um movimento hipnótico em cada movimento, revelando a sua beleza natural com uma sofisticação que transcende as convenções. Quando usa este vestido, torna-se naquele ícone moderno que hipnotiza com a sua majestade arquitetónica e a sua aura magnética irresistível.</p>
guid
stringhttps://dev.divasboudoir.com/pt/vestido-preto-comprido-maxi-com-gola-alta-drapeada/cdbu4359.htm
highlights
string<ul> <li><strong>A gola escultural de pé</strong> alonga suavemente o pescoço com um toque moderno</li> <li>Um drapeado<strong>magistral</strong> na cintura que adelgaça naturalmente a silhueta</li> <li><strong>Maxi até ao chão</strong> para um efeito teatral</li> <li><strong>preto intemporal</strong> para realçar todos os tons de pele</li> <li><strong>Corte sem mangas</strong> que revela elegantemente os braços</li> <li><strong>Efeito esculpido</strong> que combina na perfeição com todos os tipos de corpo</li> <li><strong>A fluidez graciosa</strong> cria um movimento hipnótico</li> <li><strong>Estilo arquitetónico</strong> perfeito para eventos de prestígio</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringVestido maxi preto com gola alta: drapeado esculpido, comprimento maxi, efeito arquitetónico, corte fluido. Majestade e elegância modernas | Diva's Boudoir
keywords
string
title
stringVestido maxi preto com gola alta drapeada | Diva's Boudoir
seotitle
stringVestido preto comprido de gola alta com drapeado esculpido
seouri
stringvestido-preto-comprido-maxi-com-gola-alta-drapeada
specifications
string<ul> <li><strong>Tipo :</strong> Vestido maxi</li> <li><strong>Cor :</strong> Preto profundo intemporal</li> <li><strong>Gola :</strong> Gola escultural sem mangas</li> <li><strong>Drap&eacute;:</strong> Magistral na cintura</li> <li><strong>Comprimento :</strong> Maxi ao nível do chão com efeito de varrimento</li> <li><strong>Corte :</strong> Fluido com efeito esculpido</li> <li><strong>Estilo:</strong> Arquitetónico moderno</li> <li><strong>Ocasiões:</strong> Eventos de prestígio e noites 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/">plus size</a> para um look total black sofisticado, ou adicione <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">os</a> nossos <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">quimonos plus size</a> de seda para uma elegância em camadas.</p> <p>Complete o look com as nossas <a href="https://www.divasboudoir.com/pt/calcinhas-curvy/">cuecas</a> pretas <a href="https://www.divasboudoir.com/pt/calcinhas-curvy/">plus size</a> para uma harmonia perfeita, ou explore os nossos <a href="https://www.divasboudoir.com/pt/vestidos-sexys-plus-size/">vestidos sexy plus size</a> da mesma coleção para looks mais arquitectónicos. Esta criação única revela o seu sentido de estilo com uma majestade moderna inquietante.</p>
summary
string<p>Encarne a majestade moderna neste vestido maxi preto com a sua gola escultural! O seu drapeado magistral na cintura e o comprimento no chão criam uma silhueta escultural de absoluta elegância.</p> <p>Com o seu efeito arquitetónico e fluidez graciosa, esta criação transforma cada aparição num momento de puro fascínio.</p>
title
stringVestido maxi preto de gola alta - Majestade moderna e fascínio escultural
usageinstructions
string<p>Vista suavemente este vestido, tendo o cuidado de posicionar naturalmente a gola escultural de pé. O <strong>drapeado magistral</strong> é posicionado automaticamente para criar o efeito escultural que harmoniza a sua silhueta. O comprimento maxi requer uma atenção especial ao movimentar-se para preservar o elegante efeito de varrimento. Este vestido <strong>é perfeito para todos os tipos de corpo</strong>, graças ao seu drapeado técnico e corte fluido. Use-o com confiança para revelar o seu lado majestoso nos seus eventos mais prestigiados.</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
stringsz2412104818876472 longue
netweight
string
nextshipment
stringtomorrow
ordered
number0
orderidx
number0
origin
string
originalsize
string
packaging
number0
productshipment
stringauto
productuid
string6BE1B1EC-C4B1-4E0D-83E7B3321B764129
promountil
string
rating
stringnone
recorduid
string6BE1B1EC-C4B1-4E0D-83E7B3321B764129
reference
stringCDBU4359
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.44 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129'
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
22351XLintlsizeblackXLXL-19999990wplusdress0XLXL40-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: 60.2 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129'
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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129'
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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129'
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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129'
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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129'
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
16BE1B1EC-C4B1-4E0D-83E7B3321B7641295A570D2E-01F1-4ADB-98DBBFBED4C5198D2355black#0000004XL4X50-5220-2224-2652-5452-5450-5256-5852-5450-52wdress4Xintlsize62.45830STOCK01000-10000-10all
26BE1B1EC-C4B1-4E0D-83E7B3321B764129FAF2F574-C665-4676-9DDB06B852B956152351black#0000000XLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42wdressXLintlsize62.45830STOCK01000-10000-10all
36BE1B1EC-C4B1-4E0D-83E7B3321B7641297E00044A-0C24-4549-B94D5FC233586E9D2352black#0000001XL1X44-4614-1618-2046-4846-4844-4650-5246-4844-46wdress1Xintlsize62.45830STOCK01000-10000-10all
46BE1B1EC-C4B1-4E0D-83E7B3321B76412984932E1A-4641-45BA-90E4B91BED2338DD2353black#0000002XL2XL46-4816-1820-2248-5048-5046-4852-5448-5046-48wdress2XLintlsize62.45830STOCK01000-10000-10all
56BE1B1EC-C4B1-4E0D-83E7B3321B764129D81E880A-229F-4E78-A835D9C65B9DCD2F2354black#0000003XL3X48-5018-2022-2450-5250-5248-5054-5650-5248-50wdress3Xintlsize62.45830STOCK01000-10000-10all
subcategory
stringall
supplier
number-1
supplierreference
stringSZ2412104818876472
tags
string
themes
string
totalvariations
number5
type
stringdefault
unitprice
number62.4583
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 12.1 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129'
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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129'
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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129'
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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129'
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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129'
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
15A570D2E-01F1-4ADB-98DBBFBED4C5198D2355black#0000004XL4X50-5220-2224-2652-5452-5450-5256-5852-5450-52wdress4Xintlsize62.45830STOCK01000-10000-10-10-10062.4583all
2FAF2F574-C665-4676-9DDB06B852B956152351black#0000000XLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42wdressXLintlsize62.45830STOCK01000-10000-10-10-10062.4583all
37E00044A-0C24-4549-B94D5FC233586E9D2352black#0000001XL1X44-4614-1618-2046-4846-4844-4650-5246-4844-46wdress1Xintlsize62.45830STOCK01000-10000-10-10-10062.4583all
484932E1A-4641-45BA-90E4B91BED2338DD2353black#0000002XL2XL46-4816-1820-2248-5048-5046-4852-5448-5046-48wdress2XLintlsize62.45830STOCK01000-10000-10-10-10062.4583all
5D81E880A-229F-4E78-A835D9C65B9DCD2F2354black#0000003XL3X48-5018-2022-2450-5250-5248-5054-5650-5248-50wdress3Xintlsize62.45830STOCK01000-10000-10-10-10062.4583all
vatrate
number20
warehouse
number0