Voir les tailles
Robe-Chemisier Élégance Urbaine - Coupe flatteuse et confort absolu
Double-cliquez pour agrandir
SKU: CDBU6307
Robe-Chemisier Élégance Urbaine - Coupe flatteuse et confort absolu
Stock:

Découvrez notre robe-chemisier sans manche, une pièce polyvalente alliant élégance et confort. Cette robe cintrée met en valeur vos épaules et sublime votre silhouette grâce à sa coupe parfaitement ajustée. Son tissu infroissable vous garantit une allure impeccable du matin au soir.

Points forts

  • Coupe cintrée qui met élégamment la silhouette en valeur
  • Boutonnage intégral pour un style ajustable selon vos envies
  • Tissu infroissable 100% polyester pour un confort optimal toute la journée
  • Design sans manche qui sublime délicatement vos épaules
  • Polyvalence exceptionnelle : se porte seule ou sur un pantalon
Taille:

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

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

Robe-chemisier grande taille sans manche cintrée boutonnée

Description du produit

Cette robe-chemisier sans manche incarne l'équilibre parfait entre élégance intemporelle et praticité moderne. Sa coupe cintrée a été spécialement conçue pour mettre en valeur les courbes naturelles de votre silhouette, créant une ligne harmonieuse et flatteuse sans effet gainant.
Le boutonnage intégral sur toute la longueur vous offre une flexibilité unique : portez-la entièrement fermée pour une allure sophistiquée, ou partiellement déboutonnée pour un style plus décontracté. Cette caractéristique vous permet également d'ajuster le vêtement parfaitement à votre morphologie.
Le design sans manche sublime délicatement vos épaules tout en offrant une liberté de mouvement appréciable, idéale pour les journées actives comme pour les soirées élégantes. La silhouette est parfaitement équilibrée, avec une attention particulière portée aux proportions pour créer un effet visuel harmonieux.
Confectionnée dans un tissu 100% polyester de haute qualité, cette robe allie durabilité et facilité d'entretien. Sa propriété infroissable est particulièrement appréciable pour maintenir une apparence impeccable tout au long de la journée, même lors de vos déplacements.

Détails techniques

  • Composition : 100% polyester infroissable
  • Style : Robe-chemisier sans manche cintrée
  • Fermeture : Boutonnage intégral sur toute la longueur
  • Coupe : Cintrée à la taille pour mettre en valeur la silhouette naturellement, sans effet gainant
  • Longueur : Midi 
  • Couleur : noir élégant

Tailles disponibles

Disponible du XL au 3X

Couleur disponible

Noir

Guide de taille

Vérifiez la taille qui vous convient

International
  • Poitrine
  • Taille
  • Hanches
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 en machine à 30°C recommandé
  • Programme délicat avec essorage réduit
  • Séchage à l'air libre pour préserver la qualité du tissu
  • Repassage inutile grâce au tissu infroissable
  • En cas de besoin, repasser à basse température

Conseils d'utilisation

Pour un ajustement optimal, choisissez votre taille habituelle - la coupe cintrée mettra naturellement votre silhouette en valeur sans compression. Le boutonnage intégral vous permet d'ajuster l'ouverture du décolleté selon vos préférences. Pour une silhouette plus définie, ajoutez une ceinture fine à la taille. Cette robe est conçue pour être confortable toute la journée, du bureau aux sorties en soirée, sans se froisser même après de longues heures assise.

Conseils de style

Pour une tenue de bureau élégante, portez cette robe-chemisier avec des escarpins à talon moyen et des accessoires discrets. Pour un look plus décontracté, associez-la à des sandales plates et un sac en bandoulière. En soirée, superposez-la sur un pantalon slim noir et ajoutez des bijoux statement pour un style contemporain. Pour les journées plus fraîches, complétez avec un blazer structuré ou un cardigan long. Cette pièce polyvalente s'adapte à toutes les occasions, de la journée de travail au dîner entre amis.

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.688 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1blackcolorblakblackblack#000000-10
colorrange
stringblack
colors
stringblack
colortype
stringcolor
comments
string
compositions
Struct
Entries: 13
coton
string
elastane
string
free
string
leather
string
lycra
string
metal
string
nylon
string
polyamide
string
polyester
string
polyurethane
string
silk
string
spandex
string
viscose
string
datecreated
Date Time (Europe/Paris)
{ts '2025-05-21 15:38:33'}
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
number29.125
itempromo
string
key
stringsz2412072044038983
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-05-31 19:33:26'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.605 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('32529e83-f60f-44c6-af1fae0590320c7b',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.25 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 <> 'CDBU6307'
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
string1899
isprivate
string0
rating
stringall
src
string/photobank/products/dvqc/cdbu6307/robe-chemisier-grande-taille-noire2.jpg
type
stringimg
width
string1314
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string1931
isprivate
string0
rating
stringall
src
string/photobank/products/dvqc/cdbu6307/robe-chemisier-grande-taille-noire3.jpg
type
stringimg
width
string1336
variations
Struct
colors
Struct
black
Struct
height
string1931
isprivate
string0
rating
stringall
src
string/photobank/products/dvqc/cdbu6307/robe-chemisier-grande-taille-noire3.jpg
type
stringimg
width
string1336
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>Maschinenwäsche bei 30&deg;C empfohlen.</li> <li>Schonprogramm mit reduziertem Schleudergang</li> <li>An der Luft trocknen, um die Qualität des Stoffes zu erhalten</li> <li>Bügeln ist dank des knitterfreien Stoffes nicht nötig</li> <li>Bei Bedarf bei niedriger Temperatur bügeln</li> </ul>
description
string<p>Dieses ärmellose Hemdblusenkleid verkörpert die perfekte Balance zwischen zeitloser Eleganz und moderner Praktikabilität. Der taillierte Schnitt wurde speziell dafür entworfen, die natürlichen Kurven Ihrer Figur zu betonen und eine harmonische, schmeichelhafte Linie zu schaffen, ohne dabei einen figurbetonten Effekt zu erzielen.<br>Die durchgehende Knopfleiste bietet Ihnen eine einzigartige Flexibilität: Tragen Sie es ganz geschlossen für einen raffinierten Look oder teilweise aufgeknöpft für einen lässigen Stil. Diese Eigenschaft ermöglicht es Ihnen auch, das Kleidungsstück perfekt an Ihre Körperform anzupassen.<br>Das ärmellose Design umspielt sanft Ihre Schultern und bietet gleichzeitig viel Bewegungsfreiheit - ideal für einen aktiven Tag oder einen eleganten Abend. Die Silhouette ist perfekt ausbalanciert, wobei besonders auf die Proportionen geachtet wurde, um einen harmonischen visuellen Effekt zu erzielen.<br>Das Kleid ist aus einem hochwertigen Stoff aus 100% Polyester gefertigt und vereint Haltbarkeit und Pflegeleichtigkeit. Seine knitterfreie Eigenschaft ist besonders wertvoll, um den ganzen Tag über ein makelloses Aussehen zu bewahren, auch wenn Sie unterwegs sind.</p>
guid
stringhttps://dev.divasboudoir.com/de/sexy-kleider-schwarz/cdbu6307.htm
highlights
string<ul> <li>Taillierter Schnitt, der die Silhouette elegant betont</li> <li>Durchgehende Knopfleiste für einen Stil, der sich nach Lust und Laune anpassen lässt</li> <li>Knitterfreies Gewebe aus 100% Polyester für ganztägigen Tragekomfort</li> <li>Ärmelloses Design, das Ihre Schultern sanft umspielt</li> <li>Außergewöhnliche Vielseitigkeit: kann allein oder über einer Hose getragen werden</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringEntdecken Sie unser ärmelloses Blusenkleid in großen Größen mit tailliertem Schnitt und knitterfreiem Stoff. Eleganz und Komfort für alle Figurtypen. Kostenlose Lieferung!
keywords
string
title
stringBlusenkleid Große Größe Ärmellos Tailliert Knitterfrei | Diva's Boudoir
seotitle
stringBlusenkleid in großer Größe ohne Ärmel tailliert geknöpft
seouri
stringsexy-kleider-schwarz
specifications
string<ul> <li>Zusammensetzung: 100% knitterfreies Polyester</li> <li>Stil: Ärmelloses, tailliertes Blusenkleid</li> <li>Verschluss: Durchgehende Knopfleiste über die gesamte Länge</li> <li>Schnitt: An der Taille tailliert, um die Silhouette natürlich zu betonen, ohne einen formenden Effekt</li> <li>Länge: Midi</li> <li>Farbe: Elegantes Schwarz</li> </ul>
stylingtips
string<p>Für ein elegantes Büro-Outfit tragen Sie dieses Blusenkleid mit Pumps mit mittelhohem Absatz und dezenten Accessoires. Für einen legeren Look kombinieren Sie es mit flachen Sandalen und einer Umhängetasche. Am Abend tragen Sie es über einer schwarzen schmalen Hose und fügen Statement-Schmuck für einen modernen Stil hinzu. An kühleren Tagen ergänzen Sie es mit einem strukturierten Blazer oder einer langen Strickjacke. Dieses vielseitige Stück passt zu jedem Anlass, vom Arbeitstag bis zum Abendessen mit Freunden.</p>
summary
string<p>Entdecken Sie unser ärmelloses Blusenkleid, ein vielseitiges Kleidungsstück, das Eleganz und Komfort vereint. Dieses taillierte Kleid betont Ihre Schultern und verleiht Ihrer Silhouette dank des perfekt sitzenden Schnitts eine schöne Silhouette. Sein knitterfreier Stoff garantiert Ihnen einen makellosen Look von morgens bis abends.</p>
title
stringBlusenkleid Urbane Eleganz - Schmeichelnde Passform und absoluter Komfort
usageinstructions
string<p>Für eine optimale Passform wählen Sie Ihre übliche Größe - der taillierte Schnitt betont Ihre Figur auf natürliche Weise, ohne zu drücken. Dank der durchgehenden Knopfleiste können Sie die Öffnung des Dekollet&eacute;s nach Belieben anpassen. Für eine definierte Silhouette fügen Sie einen schmalen Gürtel an der Taille hinzu. Dieses Kleid wurde so entworfen, dass es den ganzen Tag über bequem ist, vom Büro bis zum Ausgehen am Abend, und auch nach langem Sitzen nicht knittert.</p>
el
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Συνιστάται πλύσιμο στο πλυντήριο στους 30&deg;C</li> <li>Λεπτό πρόγραμμα με χαμηλό στύψιμο</li> <li>Στεγνώστε στον αέρα για να διατηρήσετε την ποιότητα του υφάσματος</li> <li>Δεν χρειάζεται σιδέρωμα χάρη στο ύφασμα που δεν τσαλακώνεται</li> <li>Εάν είναι απαραίτητο, σιδερώστε σε χαμηλή θερμοκρασία</li> </ul>
description
string<p>Αυτό το αμάνικο φόρεμα με μπλούζα επιτυγχάνει την τέλεια ισορροπία ανάμεσα στη διαχρονική κομψότητα και τη σύγχρονη πρακτικότητα. Η στενή του γραμμή έχει σχεδιαστεί ειδικά για να ενισχύει τις φυσικές καμπύλες της σιλουέτας σας, δημιουργώντας μια αρμονική, κολακευτική γραμμή χωρίς φαινόμενο θήκης.<br>Το ολόσωμο κούμπωμα σας δίνει μοναδική ευελιξία: φορέστε το εντελώς κλειστό για μια εκλεπτυσμένη εμφάνιση ή μερικώς ξεκούμπωτο για ένα πιο χαλαρό στυλ. Αυτό το χαρακτηριστικό σας επιτρέπει επίσης να προσαρμόσετε το ρούχο τέλεια στο σχήμα του σώματός σας.<br>Ο αμάνικος σχεδιασμός λικνίζει απαλά τους ώμους σας, προσφέροντας παράλληλα μεγάλη ελευθερία κινήσεων, ιδανικό τόσο για δραστήριες ημέρες όσο και για κομψές βραδινές εξόδους. Η σιλουέτα είναι απόλυτα ισορροπημένη, με ιδιαίτερη προσοχή στις αναλογίες για τη δημιουργία ενός αρμονικού οπτικού αποτελέσματος.<br>Κατασκευασμένο από υψηλής ποιότητας ύφασμα από 100% πολυεστέρα, αυτό το φόρεμα συνδυάζει την ανθεκτικότητα με την ευκολία στη φροντίδα. Οι ανθεκτικές στις τσακίσεις ιδιότητές του είναι ιδιαίτερα χρήσιμες για τη διατήρηση μιας άψογης εμφάνισης όλη την ημέρα, ακόμη και όταν βρίσκεστε σε κίνηση.</p>
guid
stringhttps://dev.divasboudoir.com/el/sexi-foremata-mayro/cdbu6307.htm
highlights
string<ul> <li>Στενή γραμμή για κομψή σιλουέτα</li> <li>Κλείσιμο με κουμπιά για ένα στυλ που μπορεί να προσαρμοστεί ανάλογα με τις ανάγκες σας</li> <li>100% πολυεστερικό ύφασμα ανθεκτικό στις τσακίσεις για άνεση όλη την ημέρα</li> <li>Ο αμάνικος σχεδιασμός τονίζει απαλά τους ώμους σας</li> <li>Εξαιρετική ευελιξία: μπορεί να φορεθεί μόνη της ή πάνω από παντελόνι</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringΑνακαλύψτε το μεγάλο αμάνικο φόρεμα-μπλούζα με λεπτή γραμμή και ύφασμα ανθεκτικό στις τσακίσεις. Κομψότητα και άνεση για κάθε σιλουέτα. Δωρεάν παράδοση!
keywords
string
title
stringΜεγάλο αμάνικο φόρεμα με πλισέ μπλούζα | Diva's Boudoir
seotitle
stringΜεγάλο αμάνικο φόρεμα μπλούζα με κουμπιά μπροστά
seouri
stringsexi-foremata-mayro
specifications
string<ul> <li>Σύνθεση: 100% πολυεστέρας ανθεκτικός στις τσακίσεις</li> <li>Στυλ : Φόρεμα με εφαρμοστή αμάνικη μπλούζα</li> <li>Κλείσιμο: Κλείσιμο με κουμπιά σε όλο το μήκος</li> <li>Κοπή: Μέση που σφίγγεται για να ενισχύει φυσικά τη σιλουέτα, χωρίς να έχει το φαινόμενο της θήκης</li> <li>Μήκος: Midi</li> <li>Χρώμα: Κομψό μαύρο</li> </ul>
stylingtips
string<p>Για μια κομψή εμφάνιση στο γραφείο, φορέστε αυτό το φόρεμα-μπλούζα με γόβες με μεσαίο τακούνι και διακριτικά αξεσουάρ. Για μια πιο casual εμφάνιση, συνδυάστε το με φλατ σανδάλια και μια τσάντα ώμου. Για το βράδυ, τοποθετήστε το πάνω από ένα λεπτό μαύρο παντελόνι και προσθέστε statement κοσμήματα για ένα σύγχρονο στυλ. Για τις πιο δροσερές ημέρες, συμπληρώστε με ένα δομημένο σακάκι ή μια μακριά ζακέτα. Αυτό το ευέλικτο κομμάτι είναι ιδανικό για κάθε περίσταση, από μια μέρα στο γραφείο μέχρι ένα δείπνο με φίλους.</p>
summary
string<p>Ανακαλύψτε το αμάνικο φόρεμα με μπλούζα, ένα ευέλικτο κομμάτι που συνδυάζει κομψότητα και άνεση. Αυτό το φόρεμα σε στενή γραμμή αναδεικνύει τους ώμους σας και ενισχύει τη σιλουέτα σας με την τέλεια εφαρμογή του. Το ύφασμα που είναι ανθεκτικό στις τσακίσεις σημαίνει ότι θα δείχνετε υπέροχη από το πρωί μέχρι το βράδυ.</p>
title
stringΦόρεμα με μπλούζα Élégance Urbaine - Κολακευτική εφαρμογή και απόλυτη άνεση
usageinstructions
string<p>Για καλύτερη εφαρμογή, επιλέξτε το συνηθισμένο σας μέγεθος - η λεπτή εφαρμογή θα ενισχύσει φυσικά τη σιλουέτα σας χωρίς συμπίεση. Το πλήρες κούμπωμα με κουμπιά σας επιτρέπει να προσαρμόσετε τη λαιμόκοψη στις προτιμήσεις σας. Για μια πιο καθορισμένη σιλουέτα, προσθέστε μια λεπτή ζώνη στη μέση. Αυτό το φόρεμα έχει σχεδιαστεί για να είναι άνετο όλη μέρα, από το γραφείο μέχρι τις βραδινές εξόδους, χωρίς να τσαλακώνεται ακόμα και μετά από πολύωρη καθιστή εργασία.</p>
en
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Machine wash at 30&deg;C recommended</li> <li>Delicate program with low spin</li> <li>Air-dry to preserve fabric quality</li> <li>Wrinkle-free fabric means no ironing required</li> <li>If necessary, iron at low temperature</li> </ul>
description
string<p>This sleeveless blouse dress embodies the perfect balance between timeless elegance and modern practicality. Its slim fit has been specially designed to enhance the natural curves of your figure, creating a harmonious, flattering line without a sheathing effect.<br>Full-length buttoning gives you unique flexibility: wear it fully closed for a sophisticated look, or partially unbuttoned for a more relaxed style. This feature also allows you to adjust the garment perfectly to your body shape.<br>The sleeveless design delicately sublimates your shoulders while offering appreciable freedom of movement, ideal for both active days and elegant evenings. The silhouette is perfectly balanced, with particular attention paid to proportions to create a harmonious visual effect.<br>Made from high-quality 100% polyester fabric, this dress combines durability with ease of care. Its crease-resistant property is particularly appreciated for maintaining an impeccable appearance all day long, even when you're on the move.</p>
guid
stringhttps://dev.divasboudoir.com/en/sexy-dresses-black/cdbu6307.htm
highlights
string<ul> <li>A slim fit that elegantly accentuates the silhouette</li> <li>Full buttoning for adjustable styling to suit your needs</li> <li>100% polyester crease-resistant fabric for all-day comfort</li> <li>Sleeveless design delicately sublimates your shoulders</li> <li>Exceptional versatility: wear alone or over pants</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringDiscover our plus size sleeveless blouse dress with slim fit and crease-resistant fabric. Elegance and comfort for every figure. Free delivery!
keywords
string
title
stringPlus Size Sleeveless Fitted Pleated Blouse Dress | Diva's Boudoir
seotitle
stringPlus size sleeveless buttoned blouse dress
seouri
stringsexy-dresses-black
specifications
string<ul> <li>Composition: 100% wrinkle-resistant polyester</li> <li>Style: Sleeveless fitted blouse dress</li> <li>Closure: Full-length button fastening</li> <li>Cut: Curved at the waist to naturally enhance the silhouette, with no sheathing effect</li> <li>Length: Midi</li> <li>Color: Elegant black</li> </ul>
stylingtips
string<p>For an elegant office look, wear this blouse dress with mid-heeled pumps and discreet accessories. For a more casual look, pair it with flat sandals and a shoulder bag. For evening, layer over slim black pants and add statement jewelry for a contemporary look. For cooler days, complete with a structured blazer or long cardigan. This versatile piece is perfect for any occasion, from a day at work to dinner with friends.</p>
summary
string<p>Discover our sleeveless blouse dress, a versatile piece that combines elegance and comfort. This slim-fitting dress emphasizes your shoulders and enhances your silhouette with its perfect fit. Its crease-resistant fabric guarantees a flawless look from morning to night.</p>
title
stringÉlégance Urbaine blouse-dress - Flattering cut and absolute comfort
usageinstructions
string<p>For optimum fit, choose your usual size - the slim fit will naturally enhance your silhouette without compression. Full buttoning lets you adjust the neckline opening to your preference. For a more defined silhouette, add a slim belt at the waist. This dress is designed for all-day comfort, from the office to evening outings, without wrinkling even after long hours of sitting.</p>
es
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Se recomienda lavar a máquina a 30&deg;C</li> <li>Programa delicado con centrifugado bajo</li> <li>Secado al aire para preservar la calidad del tejido</li> <li>No necesita plancha gracias a su tejido resistente a las arrugas</li> <li>Si es necesario, planchar a baja temperatura</li> </ul>
description
string<p>Este vestido blusón sin mangas logra el equilibrio perfecto entre elegancia atemporal y practicidad moderna. Su corte entallado se ha diseñado especialmente para realzar las curvas naturales de tu figura, creando una línea armoniosa y favorecedora sin efecto enfundado.<br>La abotonadura completa le ofrece una flexibilidad única: llévelo completamente cerrado para un look sofisticado, o parcialmente desabrochado para un estilo más relajado. Esta característica también le permite ajustar la prenda perfectamente a la forma de su cuerpo.<br>El diseño sin mangas acuna suavemente los hombros, al tiempo que ofrece una gran libertad de movimientos, ideal tanto para los días activos como para las noches elegantes. La silueta está perfectamente equilibrada, con especial atención a las proporciones para crear un efecto visual armonioso.<br>Confeccionado en un tejido 100% poliéster de gran calidad, este vestido combina durabilidad y facilidad de cuidado. Su resistencia a las arrugas es especialmente útil para mantener un aspecto impecable durante todo el día, incluso en movimiento.</p>
guid
stringhttps://dev.divasboudoir.com/es/vestido-sexy-negro/cdbu6307.htm
highlights
string<ul> <li>Corte entallado para una silueta elegante</li> <li>Cierre con botones para un estilo que se puede ajustar a tu gusto</li> <li>Tejido 100% poliéster resistente a las arrugas para una mayor comodidad durante todo el día</li> <li>Diseño sin mangas que acentúa delicadamente los hombros</li> <li>Versatilidad excepcional: puede llevarse sola o sobre pantalones</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringDescubra nuestro vestido blusa sin mangas de talla grande con corte entallado y tejido resistente a las arrugas. Elegancia y comodidad para todas las figuras. Entrega gratuita
keywords
string
title
stringVestido plisado sin mangas talla grande | Diva's Boudoir
seotitle
stringVestido blusa grande sin mangas con botones delanteros
seouri
stringvestido-sexy-negro
specifications
string<ul> <li>Composición: 100% poliéster resistente a las arrugas</li> <li>Estilo : Vestido blusón entallado sin mangas</li> <li>Cierre: Cierre integral con botones</li> <li>Corte: Cintura ceñida para realzar la silueta de forma natural, sin efecto enfundado</li> <li>Largo: Midi</li> <li>Color: Negro elegante</li> </ul>
stylingtips
string<p>Para un look de oficina elegante, lleva este vestido blusón con zapatos de tacón medio y accesorios discretos. Para un look más informal, combínalo con sandalias planas y un bolso bandolera. Para la noche, póntelo sobre unos pantalones negros ajustados y añade joyas llamativas para un estilo contemporáneo. Para los días más fríos, combínalo con un blazer estructurado o un cárdigan largo. Esta prenda versátil es perfecta para cualquier ocasión, desde un día en la oficina hasta una cena con amigos.</p>
summary
string<p>Descubra nuestro vestido blusón sin mangas, una pieza versátil que combina elegancia y comodidad. Este vestido entallado muestra tus hombros y realza tu figura con su ajuste perfecto. Gracias a su tejido resistente a las arrugas, te verás estupenda de la mañana a la noche.</p>
title
stringVestido blusón Élégance Urbaine - Corte favorecedor y comodidad absoluta
usageinstructions
string<p>Para un ajuste óptimo, elija su talla habitual: el corte entallado realzará naturalmente su figura sin comprimirla. El cierre con botones permite ajustar el escote a su gusto. Para una silueta más definida, añada un cinturón fino en la cintura. Este vestido está diseñado para que resulte cómodo todo el día, desde la oficina hasta las salidas nocturnas, sin arrugarse incluso después de pasar largas horas sentada.</p>
fr
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavage en machine &agrave; 30&deg;C recommand&eacute;</li> <li>Programme d&eacute;licat avec essorage r&eacute;duit</li> <li>S&eacute;chage &agrave; l'air libre pour pr&eacute;server la qualit&eacute; du tissu</li> <li>Repassage inutile gr&acirc;ce au tissu infroissable</li> <li>En cas de besoin, repasser &agrave; basse temp&eacute;rature</li> </ul>
description
string<p>Cette robe-chemisier sans manche incarne l'&eacute;quilibre parfait entre &eacute;l&eacute;gance intemporelle et praticit&eacute; moderne. Sa coupe cintr&eacute;e a &eacute;t&eacute; sp&eacute;cialement con&ccedil;ue pour mettre en valeur les courbes naturelles de votre silhouette, cr&eacute;ant une ligne harmonieuse et flatteuse sans effet gainant.<br>Le boutonnage int&eacute;gral sur toute la longueur vous offre une flexibilit&eacute; unique : portez-la enti&egrave;rement ferm&eacute;e pour une allure sophistiqu&eacute;e, ou partiellement d&eacute;boutonn&eacute;e pour un style plus d&eacute;contract&eacute;. Cette caract&eacute;ristique vous permet &eacute;galement d'ajuster le v&ecirc;tement parfaitement &agrave; votre morphologie.<br>Le design sans manche sublime d&eacute;licatement vos &eacute;paules tout en offrant une libert&eacute; de mouvement appr&eacute;ciable, id&eacute;ale pour les journ&eacute;es actives comme pour les soir&eacute;es &eacute;l&eacute;gantes. La silhouette est parfaitement &eacute;quilibr&eacute;e, avec une attention particuli&egrave;re port&eacute;e aux proportions pour cr&eacute;er un effet visuel harmonieux.<br>Confectionn&eacute;e dans un tissu 100% polyester de haute qualit&eacute;, cette robe allie durabilit&eacute; et facilit&eacute; d'entretien. Sa propri&eacute;t&eacute; infroissable est particuli&egrave;rement appr&eacute;ciable pour maintenir une apparence impeccable tout au long de la journ&eacute;e, m&ecirc;me lors de vos d&eacute;placements.</p>
guid
stringhttps://dev.divasboudoir.com/fr/grande-taille-robe-chemisier-sans-manche-cintree/cdbu6307.htm
highlights
string<ul> <li>Coupe cintr&eacute;e qui met &eacute;l&eacute;gamment la silhouette en valeur</li> <li>Boutonnage int&eacute;gral pour un style ajustable selon vos envies</li> <li>Tissu infroissable 100% polyester pour un confort optimal toute la journ&eacute;e</li> <li>Design sans manche qui sublime d&eacute;licatement vos &eacute;paules</li> <li>Polyvalence exceptionnelle : se porte seule ou sur un pantalon</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringDécouvrez notre robe-chemisier grande taille sans manche avec coupe cintrée et tissu infroissable. Élégance et confort pour toutes les silhouettes. Livraison gratuite !
keywords
string
title
stringRobe-Chemisier Grande Taille Sans Manche Cintrée Infroissable | Diva's Boudoir
seotitle
stringRobe-chemisier grande taille sans manche cintrée boutonnée
seouri
stringgrande-taille-robe-chemisier-sans-manche-cintree
specifications
string<ul> <li>Composition : 100% polyester infroissable</li> <li>Style : Robe-chemisier sans manche cintr&eacute;e</li> <li>Fermeture : Boutonnage int&eacute;gral sur toute la longueur</li> <li>Coupe : Cintr&eacute;e &agrave; la taille pour mettre en valeur la silhouette naturellement, sans effet gainant</li> <li>Longueur : Midi&nbsp;</li> <li>Couleur : noir &eacute;l&eacute;gant</li> </ul>
stylingtips
string<p>Pour une tenue de bureau &eacute;l&eacute;gante, portez cette robe-chemisier avec des escarpins &agrave; talon moyen et des accessoires discrets. Pour un look plus d&eacute;contract&eacute;, associez-la &agrave; des sandales plates et un sac en bandouli&egrave;re. En soir&eacute;e, superposez-la sur un pantalon slim noir et ajoutez des bijoux statement pour un style contemporain. Pour les journ&eacute;es plus fra&icirc;ches, compl&eacute;tez avec un blazer structur&eacute; ou un cardigan long. Cette pi&egrave;ce polyvalente s'adapte &agrave; toutes les occasions, de la journ&eacute;e de travail au d&icirc;ner entre amis.</p>
summary
string<p>D&eacute;couvrez notre robe-chemisier sans manche, une pi&egrave;ce polyvalente alliant &eacute;l&eacute;gance et confort. Cette robe cintr&eacute;e met en valeur vos &eacute;paules et sublime votre silhouette gr&acirc;ce &agrave; sa coupe parfaitement ajust&eacute;e. Son tissu infroissable vous garantit une allure impeccable du matin au soir.</p>
title
stringRobe-Chemisier Élégance Urbaine - Coupe flatteuse et confort absolu
usageinstructions
string<p>Pour un ajustement optimal, choisissez votre taille habituelle - la coupe cintr&eacute;e mettra naturellement votre silhouette en valeur sans compression. Le boutonnage int&eacute;gral vous permet d'ajuster l'ouverture du d&eacute;collet&eacute; selon vos pr&eacute;f&eacute;rences. Pour une silhouette plus d&eacute;finie, ajoutez une ceinture fine &agrave; la taille. Cette robe est con&ccedil;ue pour &ecirc;tre confortable toute la journ&eacute;e, du bureau aux sorties en soir&eacute;e, sans se froisser m&ecirc;me apr&egrave;s de longues heures assise.</p>
it
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Si consiglia il lavaggio in lavatrice a 30&deg;C</li> <li>Programma delicato con bassa centrifuga</li> <li>Asciugare all'aria per preservare la qualità del tessuto</li> <li>Non è necessario stirare grazie al tessuto antipiega</li> <li>Se necessario, stirare a bassa temperatura</li> </ul>
description
string<p>Questo abito camicetta senza maniche rappresenta il perfetto equilibrio tra eleganza senza tempo e praticità moderna. La sua vestibilità slim è stata appositamente studiata per esaltare le curve naturali della vostra figura, creando una linea armoniosa e lusinghiera senza effetto guaina.<br>L'abbottonatura su tutta la lunghezza vi offre una flessibilità unica: indossatela completamente chiusa per un look sofisticato, o parzialmente sbottonata per uno stile più rilassato. Questa caratteristica consente inoltre di adattare il capo perfettamente alla forma del corpo.<br>Il design senza maniche culla delicatamente le spalle, offrendo al contempo una grande libertà di movimento, ideale sia per le giornate attive che per le serate eleganti. La silhouette è perfettamente bilanciata, con particolare attenzione alle proporzioni per creare un effetto visivo armonioso.<br>Realizzato in un tessuto di alta qualità in 100% poliestere, questo abito combina la durata con la facilità di manutenzione. Le sue proprietà antipiega sono particolarmente utili per mantenere un look impeccabile per tutto il giorno, anche quando si è in movimento.</p>
guid
stringhttps://dev.divasboudoir.com/it/abiti-sexy-nero/cdbu6307.htm
highlights
string<ul> <li>Vestibilità slim per una silhouette elegante</li> <li>Chiusura con bottoni per uno stile che può essere regolato in base alle proprie esigenze</li> <li>Tessuto 100% poliestere antipiega per un comfort che dura tutto il giorno</li> <li>Il design senza maniche mette delicatamente in risalto le spalle</li> <li>Eccezionale versatilità: può essere indossato da solo o sopra i pantaloni</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringScoprite il nostro abito camicetta senza maniche di taglia grande, con vestibilità slim e tessuto antipiega. Eleganza e comfort per ogni figura. Consegna gratuita!
keywords
string
title
stringAbito a camicetta plissettato senza maniche di taglia grande | Diva's Boudoir
seotitle
stringAbito a camicetta di grande taglia senza maniche e con chiusura a bottoni
seouri
stringabiti-sexy-nero
specifications
string<ul> <li>Composizione: 100% poliestere antipiega</li> <li>Stile: abito camicetta aderente senza maniche</li> <li>Chiusura: Chiusura con bottoni su tutta la lunghezza</li> <li>Taglio: Vita stretta per esaltare naturalmente la silhouette, senza effetto guaina</li> <li>Lunghezza: midi</li> <li>Colore: Nero elegante</li> </ul>
stylingtips
string<p>Per un look elegante da ufficio, indossate questo abito blusa con décolleté con tacco medio e accessori discreti. Per un look più casual, abbinatelo a sandali piatti e a una borsa a tracolla. Per la sera, indossatelo su pantaloni neri slim e aggiungete gioielli di rilievo per uno stile contemporaneo. Per le giornate più fresche, completate con un blazer strutturato o un cardigan lungo. Questo capo versatile è perfetto per ogni occasione, dalla giornata in ufficio alla cena con gli amici.</p>
summary
string<p>Scoprite il nostro abito blusa senza maniche, un capo versatile che unisce eleganza e comfort. Questo abito aderente mette in mostra le spalle e valorizza la figura grazie alla sua perfetta vestibilità. Grazie al suo tessuto antipiega, sarà perfetto da mattina a sera.</p>
title
stringAbito blusa Élégance Urbaine - Vestibilità perfetta e comfort assoluto
usageinstructions
string<p>Per una vestibilità ottimale, scegliete la vostra taglia abituale: la vestibilità slim valorizzerà naturalmente la vostra figura senza comprimere. L'allacciatura a bottoni permette di regolare la scollatura a piacimento. Per una silhouette più definita, aggiungete una cintura sottile in vita. Questo abito è progettato per essere comodo tutto il giorno, dall'ufficio alle uscite serali, senza sgualcirsi anche dopo lunghe ore di seduta.</p>
nl
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Machinewas op 30&deg;C aanbevolen</li> <li>Fijnwasprogramma met laag centrifugeren</li> <li>Aan de lucht drogen om de kwaliteit van de stof te behouden</li> <li>Strijken is niet nodig dankzij kreukherstellende stof</li> <li>Indien nodig, strijken op lage temperatuur</li> </ul>
description
string<p>Deze mouwloze blousejurk vormt de perfecte balans tussen tijdloze elegantie en moderne functionaliteit. De slanke pasvorm is speciaal ontworpen om de natuurlijke rondingen van je figuur te benadrukken, waardoor er een harmonieuze, flatterende lijn ontstaat zonder een scherend effect.<br>De doorlopende knoopsluiting geeft je unieke flexibiliteit: draag hem volledig gesloten voor een verfijnde look, of gedeeltelijk opengeknoopt voor een meer ontspannen stijl. Hierdoor kun je het kledingstuk perfect aanpassen aan je lichaamsvorm.<br>Het mouwloze ontwerp omsluit je schouders zachtjes en biedt veel bewegingsvrijheid, ideaal voor zowel actieve dagen als elegante avondjes uit. Het silhouet is perfect in balans, met speciale aandacht voor proporties om een harmonieus visueel effect te creëren.<br>Deze jurk is gemaakt van een hoogwaardige 100% polyester stof en combineert duurzaamheid met onderhoudsgemak. De kreukherstellende eigenschappen zijn bijzonder handig om er de hele dag onberispelijk uit te blijven zien, zelfs als je onderweg bent.</p>
guid
stringhttps://dev.divasboudoir.com/nl/sexy-outfit-zwart/cdbu6307.htm
highlights
string<ul> <li>Slanke pasvorm voor een elegant silhouet</li> <li>Volledige knoopsluiting voor een stijl die naar wens kan worden aangepast</li> <li>100% polyester kreukherstellende stof voor de hele dag comfort</li> <li>Mouwloos ontwerp accentueert subtiel je schouders</li> <li>Uitzonderlijke veelzijdigheid: kan alleen of over een broek worden gedragen</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringOntdek onze grote maat mouwloze blousejurk met slanke pasvorm en kreukvrije stof. Elegantie en comfort voor elk figuur. Gratis levering!
keywords
string
title
stringGrote Mouwloze Geplooide Blouse Jurk | Diva's Boudoir
seotitle
stringGrote maat mouwloze blousejurk met knoopsluiting
seouri
stringsexy-outfit-zwart
specifications
string<ul> <li>Samenstelling: 100% kreukvrij polyester</li> <li>Stijl: Aansluitende mouwloze blousejurk</li> <li>Sluiting: knoopsluiting over de hele lengte</li> <li>Snit: In de taille geknoopt om het silhouet op natuurlijke wijze te accentueren, zonder scheringeffect</li> <li>Lengte: Midi</li> <li>Kleur: Elegant zwart</li> </ul>
stylingtips
string<p>Voor een elegante kantoorlook draag je deze blousejurk met pumps met middelhoge hakken en discrete accessoires. Voor een meer casual look combineer je hem met platte sandalen en een schoudertas. Voor de avond draag je hem over een slanke zwarte broek en voeg je opvallende sieraden toe voor een eigentijdse stijl. Voor koelere dagen maak je het af met een gestructureerde blazer of lang vest. Dit veelzijdige stuk is perfect voor elke gelegenheid, van een dag op kantoor tot een etentje met vrienden.</p>
summary
string<p>Ontdek onze mouwloze blousejurk, een veelzijdig stuk dat elegantie en comfort combineert. Deze nauwsluitende jurk pronkt met je schouders en laat je figuur beter uitkomen dankzij de perfecte pasvorm. Dankzij de kreukvrije stof zie je er van 's ochtends vroeg tot 's avonds laat geweldig uit.</p>
title
stringÉlégance Urbaine blousejurk - Flatterende pasvorm en absoluut comfort
usageinstructions
string<p>Voor de beste pasvorm kies je je gebruikelijke maat - de slanke pasvorm verbetert je figuur op natuurlijke wijze zonder compressie. Met de volledige knoopsluiting kun je de halslijn naar wens aanpassen. Voor een meer gedefinieerd silhouet voeg je een smalle riem toe in de taille. Deze jurk is ontworpen om de hele dag comfortabel te zitten, van kantoor tot een avondje uit, zonder te kreuken, zelfs na lang zitten.</p>
pt
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Recomenda-se a lavagem na máquina a 30&deg;C</li> <li>Programa delicado com centrifugação baixa</li> <li>Secagem ao ar para preservar a qualidade do tecido</li> <li>Não é necessário passar a ferro graças ao tecido resistente aos vincos</li> <li>Se necessário, passar a ferro a baixa temperatura</li> </ul>
description
string<p>Este vestido blusa sem mangas atinge o equilíbrio perfeito entre elegância intemporal e praticidade moderna. O seu corte justo foi especialmente concebido para realçar as curvas naturais da sua figura, criando uma linha harmoniosa e lisonjeira sem um efeito de bainha.<br>O abotoamento a todo o comprimento dá-lhe uma flexibilidade única: use-o totalmente fechado para um look sofisticado ou parcialmente desabotoado para um estilo mais descontraído. Esta caraterística permite-lhe também ajustar a peça de vestuário perfeitamente à forma do seu corpo.<br>O design sem mangas aconchega suavemente os seus ombros, oferecendo ao mesmo tempo uma grande liberdade de movimentos, ideal tanto para dias activos como para noites elegantes. A silhueta é perfeitamente equilibrada, com especial atenção às proporções para criar um efeito visual harmonioso.<br>Fabricado num tecido 100% poliéster de alta qualidade, este vestido combina durabilidade e facilidade de manutenção. As suas propriedades de resistência aos vincos são particularmente úteis para manter um look impecável durante todo o dia, mesmo quando está em movimento.</p>
guid
stringhttps://dev.divasboudoir.com/pt/vestido-sexy-preto/cdbu6307.htm
highlights
string<ul> <li>Ajuste fino para uma silhueta elegante</li> <li>Totalmente abotoado para um estilo que pode ser ajustado à sua medida</li> <li>Tecido 100% poliéster resistente a vincos para conforto durante todo o dia</li> <li>O design sem mangas acentua delicadamente os seus ombros</li> <li>Versatilidade excecional: pode ser usado sozinho ou por cima de calças</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringDescubra o nosso vestido blusa grande sem mangas com um corte justo e tecido resistente aos vincos. Elegância e conforto para todas as silhuetas. Entrega gratuita!
keywords
string
title
stringVestido grande com blusa plissada e sem mangas | Diva's Boudoir
seotitle
stringVestido blusa grande sem mangas e com botões à frente
seouri
stringvestido-sexy-preto
specifications
string<ul> <li>Composição: 100% poliéster resistente aos vincos</li> <li>Estilo: Vestido com blusa sem mangas e justo</li> <li>Aperto: Aperto de botão a todo o comprimento</li> <li>Corte: Cintura cingida para realçar naturalmente a silhueta, sem efeito de bainha</li> <li>Comprimento: Midi</li> <li>Cor: Preto elegante</li> </ul>
stylingtips
string<p>Para um look de escritório elegante, use este vestido blusa com sapatos de salto médio e acessórios discretos. Para um look mais casual, combine-o com sandálias rasas e uma mala a tiracolo. Para a noite, vista-o por cima de calças pretas justas e adicione jóias de destaque para um estilo contemporâneo. Para os dias mais frios, complete com um blazer estruturado ou um casaco de malha comprido. Esta peça versátil é perfeita para qualquer ocasião, desde um dia no escritório a um jantar com amigos.</p>
summary
string<p>Descubra o nosso vestido blusa sem mangas, uma peça versátil que alia elegância e conforto. Este vestido de corte justo deixa os seus ombros à mostra e realça a sua figura graças ao seu ajuste perfeito. O seu tecido resistente aos vincos permite-lhe ter um ótimo aspeto de manhã à noite.</p>
title
stringVestido com blusa Élégance Urbaine - Ajuste lisonjeiro e conforto absoluto
usageinstructions
string<p>Para um melhor ajuste, escolha o seu tamanho habitual - o ajuste fino realçará naturalmente a sua figura sem compressão. O fecho completo com botões permite-lhe ajustar o decote de acordo com a sua preferência. Para uma silhueta mais definida, adicione um cinto fino na cintura. Este vestido foi concebido para ser confortável durante todo o dia, desde o escritório até às saídas à noite, sem vincos mesmo após longas horas sentada.</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
stringsz2412072044038983
netweight
string
nextshipment
stringtomorrow
ordered
number8
orderidx
number0
origin
string
originalsize
string
packaging
number0
productshipment
stringauto
productuid
string32529E83-F60F-44C6-AF1FAE0590320C7B
promountil
string
rating
stringnone
recorduid
string32529E83-F60F-44C6-AF1FAE0590320C7B
reference
stringCDBU6307
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.34 ms
Record Count: 4
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_sizes.id_size as recorduid, if(intlsize <> '',intlsize,eusize) as size, if(intlsize <> '','intlsize','eusize') as sizetype,
product_variations.color,
if(product_sizes.sizegroup = 'bra',
if(intlsize <> '', cast(intlsize as SIGNED ), cast(eusize as SIGNED ))
,
SUBSTRING_INDEX(intlsize,'-',1)
) as param1,
if(product_sizes.sizegroup = 'bra',
if(intlsize <> '',
MID(intlsize,length(cast(intlsize as SIGNED ))+1,length(intlsize)),
MID(eusize,length(cast(eusize as SIGNED ))+1,length(eusize))
)
,
SUBSTRING_INDEX(intlsize,'-',-1)
) as param2,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as available,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
999999,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as groupavailable,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
product_sizes.gender, product_sizes.sizerange, product_sizes.sizegroup, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize,
product_sizes.bust, product_sizes.waist, product_sizes.hip, product_sizes.underbust, product_sizes.cup, product_sizes.thigh, product_sizes.legheight, product_sizes.bodyheight, product_sizes.bodyweight
from product_sizes
left outer join product_variations on product_sizes.suppliersize = product_variations.size and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
where FIND_IN_SET(product_sizes.id_size,'2334,2335,2336,2337') > 0
and product_variations.productuid = '32529E83-F60F-44C6-AF1FAE0590320C7B'
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
12334XLintlsizeblackXLXL-19999990wplusdress0XLXL421216444442484442100-10779-86105-112
223351Xintlsizeblack1X1X-19999990wplusdress1XL1X441418464644504644107-11486-93112-119
323362XLintlsizeblack2XL2XL-19999990wplusdress2XL2XL461620484846524846114-12193-100119-126
423373Xintlsizeblack3X3X-19999990wplusdress3XL3X481822505048545048121-128100-107126-133
sizeranges
stringplus
sizes
string2334,2335,2336,2337
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: 5.38 ms
Record Count: 4
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 = '32529E83-F60F-44C6-AF1FAE0590320C7B'
and product_variations.isactive = 1
and product_sizes.id_size = 2334
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '32529E83-F60F-44C6-AF1FAE0590320C7B'
and product_variations.isactive = 1
and product_sizes.id_size = 2335
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '32529E83-F60F-44C6-AF1FAE0590320C7B'
and product_variations.isactive = 1
and product_sizes.id_size = 2336
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '32529E83-F60F-44C6-AF1FAE0590320C7B'
and product_variations.isactive = 1
and product_sizes.id_size = 2337
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
) 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
132529E83-F60F-44C6-AF1FAE0590320C7B404F398E-E2D4-4E85-A01F8CADEA95FE342334black#0000000XLXL421216444442484442wdressXLintlsize29.1250STOCK01000-10100YML588532FRM33J0917972117-10all
232529E83-F60F-44C6-AF1FAE0590320C7B2951D02B-F664-436B-9CDB2E415EEF9C782335black#0000001XL1X441418464644504644wdress1Xintlsize29.1250STOCK01000-10200YML588532G2Z69Z0917972087-10all
332529E83-F60F-44C6-AF1FAE0590320C7BD76C86FF-6E44-4122-9C7FA27A3F0D91842336black#0000002XL2XL461620484846524846wdress2XLintlsize29.1250STOCK01000-10500YML588532FRM33J0917972077-10all
432529E83-F60F-44C6-AF1FAE0590320C7B1229EE73-996D-4559-80FDA013D8F1BD902337black#0000003XL3X481822505048545048wdress3Xintlsize29.1250STOCK01000-10100YML588532GHGFOE0917972097-10all
subcategory
stringall
supplier
number-1
supplierreference
stringSZ2412072044038983
tags
string
themes
string
totalvariations
number5
type
stringdefault
unitprice
number29.125
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 7.42 ms
Record Count: 4
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 = '32529E83-F60F-44C6-AF1FAE0590320C7B' 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B' 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B' 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B' 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B' 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B' 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B'
and product_variations.isactive = 1
and product_sizes.id_size = 2334
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '32529E83-F60F-44C6-AF1FAE0590320C7B' 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B' 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B' 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B' 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B' 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B' 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B'
and product_variations.isactive = 1
and product_sizes.id_size = 2335
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '32529E83-F60F-44C6-AF1FAE0590320C7B' 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B' 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B' 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B' 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B' 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B' 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B'
and product_variations.isactive = 1
and product_sizes.id_size = 2336
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '32529E83-F60F-44C6-AF1FAE0590320C7B' 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B' 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B' 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B' 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B' 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B' 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B'
and product_variations.isactive = 1
and product_sizes.id_size = 2337
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
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
1404F398E-E2D4-4E85-A01F8CADEA95FE342334black#0000000XLXL421216444442484442wdressXLintlsize29.1250STOCK01000-10100YML588532FRM33J0917972117-10-10-10029.125all
22951D02B-F664-436B-9CDB2E415EEF9C782335black#0000001XL1X441418464644504644wdress1Xintlsize29.1250STOCK01000-10200YML588532G2Z69Z0917972087-10-10-10029.125all
3D76C86FF-6E44-4122-9C7FA27A3F0D91842336black#0000002XL2XL461620484846524846wdress2XLintlsize29.1250STOCK01000-10500YML588532FRM33J0917972077-10-10-10029.125all
41229EE73-996D-4559-80FDA013D8F1BD902337black#0000003XL3X481822505048545048wdress3Xintlsize29.1250STOCK01000-10100YML588532GHGFOE0917972097-10-10-10029.125all
vatrate
number20
warehouse
number0