Mon panier

❌
Total articles
Voir le panier
Menu
Voir les tailles
Robe Similicuir et Résille - Rock Glamour et Sophistication Absolue
Double-cliquez pour agrandir
SKU: CDBU9377
Robe Similicuir et Résille - Rock Glamour et Sophistication Absolue
Stock:

Découvrez cette robe spectaculaire en similicuir élastique qui révolutionne l'art du rock glamour ! Son bustier alliant similicuir et résille transparente et ses fronces latérales créent une silhouette parfaitement sculptée.

Avec sa matière seconde peau et sa longueur midi, cette création transforme chaque apparition en moment de pure fascination.

Points forts

  • Similicuir élastique qui épouse parfaitement vos courbes naturelles
  • Bustier bi-matière similicuir et résille transparente sophistiquée
  • Fronces latérales sculptantes qui harmonisent naturellement la silhouette
  • Effet seconde peau grâce à la matière ultra-moulante
  • Longueur midi parfaite ni trop courte ni trop longue
  • Brillant subtil qui accroche la lumière avec élégance
  • Coupe body-con maîtrisée qui révèle sans vulgarité
  • Style rock-chic qui sort des codes traditionnels
Taille:

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

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

Robe grande taille similicuir résille avec bustier laçage

Description du produit

Cette robe révolutionne l'art du rock glamour avec son similicuir élastique qui crée un effet seconde peau saisissant. La matière épouse délicatement chaque courbe, révélant votre beauté naturelle avec une précision troublante. Le bustier bi-matière au niveau de la taille conjugue brillamment similicuir et résille transparente. Ce jeu entre matières opaque et transparente crée un contraste visuel captivant qui révèle votre audace avec sophistication.

Les fronces latérales apportent cette touche technique géniale qui harmonise naturellement la silhouette. Elles créent un effet sculptant délicat qui met en valeur vos atouts tout en gommant discrètement les petites zones que vous souhaitez adoucir, comme les hanches ou le ventre.

La longueur midi parfaitement équilibrée révèle vos jambes avec audace sans tomber dans l'excès. Cette proportion étudiée crée une harmonie parfaite qui s'adapte à toutes les morphologies avec une élégance naturelle.

Le brillant subtil du similicuir accroche délicatement la lumière à chaque mouvement, créant cette aura glamour qui attire tous les regards. Cette matière technique garantit un confort optimal toute la soirée grâce à son élasticité exceptionnelle. Quand vous portez cette robe, vous devenez cette bad girl sophistiquée qui hypnotise avec son style rock-chic et son assurance magnétique irrésistible.

Détails techniques

  • Type : Robe moulante midi
  • Matière : Similicuir élastique haute qualité
  • Bustier : Bi-matière similicuir et résille transparente
  • Détails : Fronces latérales sculptantes
  • Longueur : Midi élégante
  • Coupe : Body-con avec effet seconde peau
  • Style : Rock glamour sophistiqué
  • Occasions : Soirées audacieuses et événements spéciaux

Tailles disponibles

Disponible du 4X au 3X

Couleur disponible

Noir

Guide de taille

Vérifiez la taille qui vous convient

International
  • Poitrine
  • Taille
  • Hanches
4X
  • 128-134
  • 107-112
  • 133-140
XL
  • 100-107
  • 79-86
  • 105-112
1X
  • 107-114
  • 86-93
  • 112-119
2XL
  • 114-121
  • 93-100
  • 119-126
3X
  • 121-128
  • 100-107
  • 126-133

Conseils d'entretien

  • Lavage à la main à l'eau froide pour préserver le similicuir
  • Utiliser une lessive douce sans agents agressifs
  • Séchage à plat pour maintenir la forme moulante
  • Ne jamais repasser directement sur le similicuir
  • Manipuler délicatement le système de laçage
  • Ranger suspendue pour éviter les plis permanents

Conseils d'utilisation

Enfilez délicatement cette robe en prenant soin du similicuir élastique. Le bustier bi-matière se positionne naturellement pour créer cet effet sophistiqué entre similicuir et résille transparente. La matière extensible épouse naturellement vos formes sans contrainte, permettant une liberté de mouvement totale. Les fronces latérales se positionnent automatiquement pour créer cet effet sculptant qui harmonise toutes les morphologies. Cette robe révèle votre côté audacieux avec une sophistication rock-chic assumée.

Conseils de style

Sublimez votre robe avec nos bas grande taille résille pour un look total rock, ou ajoutez nos culottes grande taille noires pour une harmonie parfaite.

Complétez avec nos tenues sexys grande taille pour créer des looks variés, ou explorez nos robes sexys grande taille de la même collection pour multiplier les possibilités rock-glamour. Cette création unique révèle votre côté rebelle avec une élégance troublante.

To Top
Voir le panier
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.747 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 = '3C50F72E-46D4-4EA6-A8A89E5C9E7DAD3C'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1blackcolorblakblackblack#000000-10
colorrange
stringblack
colors
stringblack
colortype
stringcolor
comments
string
compositions
Struct
Entries: 13
coton
string
elastane
string
free
string
leather
string
lycra
string
metal
string
nylon
string
polyamide
string
polyester
string
polyurethane
string
silk
string
spandex
string
viscose
string
datecreated
Date Time (Europe/Paris)
{ts '2025-07-23 17:50:13'}
defect
number0
dimensions
Struct
Entries: 14
acrylicbones
string
backsideheight
string
diameter
string
flatsteelbones
string
frontsideheight
string
fullheight
string
length
string
modestysize
string
panels
string
sides
string
spiralsteelbones
string
totallength
string
unit
stringcm
wiresize
string
display
stringall
displayfrom
string
displayto
string
grossweight
string
hasbrandinfos
booleanfalse
hascareinstructions
booleantrue
hascolorinfos
booleantrue
hascompositions
booleanfalse
hasdescription
booleantrue
hasdimensions
booleanfalse
hasmaterials
booleanfalse
hasotherspecifications
booleanfalse
haspromo
number0
hasshortdescription
booleantrue
hassizeinfos
booleantrue
hasspecifications
booleantrue
hasstockinfos
booleanfalse
hasstylingtips
booleantrue
hasusageinstructions
booleantrue
hasvariations
booleantrue
import
string
inpromo
number0
instockvariations
number1
isactive
number1
iscustommade
number0
isdivasize
number0
isfirstprice
number0
isfixedprice
number0
ishot
number0
isnew
number0
isonline
number0
isoutletprice
number0
itemprice
number41.625
itempromo
string
key
stringsz2406183353797637-similicuir
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-09-12 10:24:20'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.659 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('3c50f72e-46d4-4ea6-a8a89e5c9e7dad3c',lcase(cart_actions.linkedproducts)) > 0 and cart_actions.linkedproducts is not null
)
id_actionbrandinglanguagenamecodetypeminimumOrdermaximumOrderminimumItemsmaximumItemsmaximumUseallowedItemsquotasusedCountlinkedproductslinkedthemeslinkedbrandslinkeditemparamsactiveFromactiveToisActive
linkedproducts
Query
Template: /system/api/products.cfc:1305
Execution Time: 1.3 ms
Record Count: 0
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select products.productuid as productuid, products.reference, 'default' as type, products.key, products.language, products.name,
product_links.linkuid,
products.colors, products.vatrate, products.metadatas, products.dimensions,
products.mediadatas, products.tags, products.themes, products.isdivasize,
count(distinct product_variations.variationuid) as totalvariations,
group_concat(distinct product_variations.variationuid) as variationlist,
count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END) as inpromo,
if(count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END)>0,1,0) as haspromo,
(select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0) END)) as itempromo,
IFNULL(min(product_variations.itemprice),0) as itemprice,
(select IF (products.isfixedprice = 0 and sum(product_variations.itempromo) > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null), IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0), IFNULL(min(NULLIF(product_variations.itemprice, 0)), 0) )) as unitprice,
count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.itempromo ELSE product_variations.itemprice END) as prices,
(select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN min(NULLIF(product_variations.promountil, 0)) END)) as promountil,
products.isfixedprice, products.ishot, products.isnew, if(products.orderidx > 0, products.orderidx, 999999999) as orderidx,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
count(distinct CASE WHEN ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) > 0 OR ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) <= 0 AND product_variations.supplier = 0)) THEN product_variations.variationuid END) as instockvariations,
products.brand, brands.name as brandname, IFNULL(brands.ispublic, 0) as showbrand, brands.display,
product_categories.sizetype,GROUP_CONCAT(DISTINCT product_sizes.suppliersize) as intlsize,products.sizes,product_sizes.sizerange,product_categories.mediadatas as categorymediadatas, product_categories.sizerange as categorysizerange,
product_categorymap.section, product_categorymap.category, product_categorymap.key as subcategory
from products
left outer join product_categorymap on products.productuid = product_categorymap.productuid
left outer join product_categories on (product_categories.branding = product_categorymap.branding and product_categories.section = product_categorymap.section and product_categories.category = product_categorymap.category and product_categories.key = product_categorymap.key)
left outer join product_sizes on product_sizes.id_size IN (products.sizes)
left outer join brands on products.brand = brands.brand
left outer join product_variations on product_variations.productuid = products.productuid and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
left outer join product_links on product_links.reference = products.reference
where products.isactive = 1 and products.isdeleted = 0
and brands.isactive = 1 and brands.isdeleted = 0
and product_categories.isactive = 1 and product_categories.isdeleted = 0
and product_variations.isactive = 1
and FIND_IN_SET('divasboudoir',products.branding)
and product_categories.branding IN ('all','divasboudoir')
and product_categorymap.branding IN ('all','divasboudoir')
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and products.language in ('all','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 <> 'CDBU9377'
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
string1008
isprivate
string0
rating
stringall
src
string/photobank/products/dvqc/cdbu9377/robe_grande_taille_similicuir_et_resille_front.jpg
type
stringimg
width
string697
back
Struct
height
string884
isprivate
string0
rating
stringall
src
string/photobank/products/dvqc/cdbu9377/robe_grande_taille_similicuir_et_resille_dos.jpg
type
stringimg
width
string611
default
Struct
height
string988
isprivate
string0
rating
stringall
src
string/photobank/products/dvqc/cdbu9377/robe_grande_taille_similicuir_et_resille.jpg
type
stringimg
width
string683
variations
Struct
colors
Struct
black
Struct
height
string988
isprivate
string0
rating
stringall
src
string/photobank/products/dvqc/cdbu9377/robe_grande_taille_similicuir_et_resille.jpg
type
stringimg
width
string683
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
mediagallery
string
metadatas
Struct
darkboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
divasboudoir
Struct
de
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Handwäsche mit kaltem Wasser, um das Kunstleder zu schonen</li> <li>Verwenden Sie ein mildes Waschmittel ohne aggressive Wirkstoffe</li> <li>Trocknen Sie das Kleidungsstück liegend, um die eng anliegende Form zu erhalten</li> <li>Niemals direkt über das Kunstleder bügeln</li> <li>Das Schnürsystem vorsichtig handhaben</li> <li>Hängend aufbewahren, um bleibende Falten zu vermeiden</li> </ul>
description
string<p>Dieses Kleid revolutioniert die Kunst des glamourösen Rocks mit seinem <strong>elastischen Kunstleder</strong>, das einen atemberaubenden Zweite-Haut-Effekt erzeugt. Das Material schmiegt sich sanft an jede Kurve an und enthüllt Ihre natürliche Schönheit mit beunruhigender Präzision. Das <strong>Bustier aus zwei Materialien</strong> im Taillenbereich ist eine brillante Kombination aus Kunstleder und transparentem Netzstoff. Dieses Spiel zwischen undurchsichtigen und transparenten Materialien schafft einen spannenden visuellen Kontrast, der Ihre Kühnheit auf raffinierte Weise offenbart.</p> <p>Die <strong>seitlichen Raffungen</strong> sorgen für den genialen technischen Touch, der die Silhouette auf natürliche Weise harmonisiert. Sie erzeugen einen zarten Shaping-Effekt, der Ihre Vorzüge betont und gleichzeitig kleine Zonen, die Sie weicher wirken lassen möchten, wie Hüften oder Bauch, dezent ausradiert.</p> <p>Die <strong>perfekt ausbalancierte Midi-Länge</strong> enthüllt Ihre Beine kühn, ohne übertrieben zu wirken. Diese durchdachte Proportion schafft eine perfekte Harmonie, die <strong>sich</strong> mit natürlicher Eleganz <strong>an jede Körperform anpasst</strong>.</p> <p>Der <strong>subtile Glanz des Kunstleders</strong> fängt bei jeder Bewegung sanft das Licht ein und schafft diese glamouröse Aura, die alle Blicke auf sich zieht. Dieses technische Material garantiert dank seiner außergewöhnlichen Elastizität <strong>den ganzen Abend lang einen optimalen Tragekomfort</strong>. Wenn Sie dieses Kleid tragen, werden Sie zu diesem raffinierten Bad Girl, das mit seinem rockig-schicken Stil und seiner unwiderstehlichen magnetischen Selbstsicherheit hypnotisiert.</p>
guid
stringhttps://dev.divasboudoir.com/de/kleid-in-großer-Größe-aus-Kunstleder,-Netzstoff,-Bustier-und-Schnürung/cdbu9377.htm
highlights
string<ul> <li><strong>Elastisches Kunstleder</strong>, das sich perfekt an Ihre natürlichen Kurven anpasst</li> <li><strong>Büstenteil aus zwei Materialien</strong>, Kunstleder und raffiniertes transparentes Netzgewebe</li> <li><strong>Formgebende Seitenfalten</strong>, die die Silhouette auf natürliche Weise harmonisieren</li> <li><strong>Zweite-Haut-Effekt</strong> dank des ultra-formbaren Materials</li> <li><strong>Perfekte Midi-Länge</strong>, weder zu kurz noch zu lang</li> <li><strong>Subtiler Glanz</strong>, der das Licht elegant einfängt</li> <li><strong>Kontrollierter Body-Con-Schnitt</strong>, der enthüllt, ohne vulgar zu sein</li> <li><strong>Rockig-schicker Stil</strong>, der sich von den traditionellen Codes abhebt</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringKunstlederkleid in großen Größen aus Netzstoff: Bustier mit Schnürung, formende Raffungen, Zweithaut-Effekt, Midi-Länge. Anspruchsvoller Glamour-Rock | Diva's Boudoir
keywords
string
title
stringKunstlederkleid in Übergröße aus Netzstoff Rock Glamour | Diva's Boudoir
seotitle
stringKleid in Übergröße aus Netzimitatleder mit Schnürung am Bustier
seouri
stringkleid-in-großer-Größe-aus-Kunstleder,-Netzstoff,-Bustier-und-Schnürung
specifications
string<ul> <li><strong>Typ:</strong> Eng anliegendes Midi-Kleid</li> <li><strong>Material:</strong> Hochwertiges, elastisches Kunstleder</li> <li><strong>Bustier:</strong> Bi-Material aus Kunstleder und transparentem Netzgewebe</li> <li><strong>Details:</strong> Formgebende seitliche Raffungen<strong></strong> </li> <li><strong>Länge:</strong> Elegante<strong>Midi-Länge</strong> </li> <li><strong>Schnitt:</strong> Body-con mit Zweithaut-Effekt</li> <li><strong>Stil:</strong> Anspruchsvoller Glamour-Rock</li> <li><strong>Anlässe:</strong> Gewagte Abendveranstaltungen und besondere<strong>Anlässe</strong> </li> </ul>
stylingtips
string<p>Veredeln Sie Ihr Kleid mit unseren <a href="https://www.divasboudoir.com/de/strumpfe-in-grossen-grossen/">Netzstrümpfen in Übergröße</a> für einen total rockigen Look, oder fügen Sie unsere schwarzen <a href="https://www.divasboudoir.com/de/slips-in-grossen-grossen/">Slips in Übergröße</a> hinzu, um eine perfekte Harmonie zu erzielen.</p> <p>Vervollständigen Sie es mit unseren <a href="https://www.divasboudoir.com/fr/tenues-sexy-grande-taille/">Sex-Outfits in großen Größen</a>, um verschiedene Looks zu kreieren, oder erkunden Sie unsere <a href="https://www.divasboudoir.com/de/sexy-kleider-in-grossen-grossen/">Sex-Kleider in großen Größen</a> aus der gleichen Kollektion, um die Möglichkeiten des Rock-Glamours zu vervielfachen. Diese einzigartige Kreation enthüllt Ihre rebellische Seite mit einer beunruhigenden Eleganz.</p>
summary
string<p>Entdecken Sie dieses spektakuläre Kleid aus elastischem Kunstleder, das die Kunst des glamourösen Rocks revolutioniert! Sein Bustier, das Kunstleder und transparentes Netzgewebe kombiniert, und die seitlichen Raffungen schaffen eine perfekt geformte Silhouette.</p> <p>Mit seinem Zweite-Haut-Material und der Midi-Länge verwandelt diese Kreation jeden Auftritt in einen Moment der puren Faszination.</p>
title
stringKleid aus Kunstleder und Netzstoff - Rock Glamour und absolute Sophistication
usageinstructions
string<p>Ziehen Sie dieses Kleid vorsichtig an und achten Sie dabei auf das elastische Kunstleder. Das <strong>Bustier aus zwei Materialien</strong> wird natürlich positioniert, um diesen raffinierten Effekt zwischen Kunstleder und transparentem Netz zu erzeugen. Das dehnbare Material schmiegt sich ganz natürlich und ohne Zwang an Ihre Formen an und ermöglicht so absolute Bewegungsfreiheit. Die seitlichen Raffungen positionieren sich automatisch, um diesen figurformenden Effekt zu erzielen, der <strong>alle Körperformen harmonisiert</strong>. Dieses Kleid zeigt Ihre kühne Seite mit einer selbstbewussten Rock-Chic-Raffinesse.</p>
el
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Πλύνετε στο χέρι με κρύο νερό για να διατηρήσετε την απομίμηση δέρματος</li> <li>Χρησιμοποιήστε ήπιο απορρυπαντικό χωρίς επιθετικούς παράγοντες</li> <li>Στεγνώνετε σε επίπεδη επιφάνεια για να διατηρήσετε το σχήμα που σας ταιριάζει</li> <li>Ποτέ μην σιδερώνετε απευθείας το απομίμηση δέρματος</li> <li>Να χειρίζεστε προσεκτικά το σύστημα κορδονιών</li> <li>Αποθηκεύστε το κρεμασμένο για να αποφύγετε τις μόνιμες τσακίσεις</li> </ul>
description
string<p>Αυτό το φόρεμα φέρνει επανάσταση στην τέχνη του glam rock με το <strong>ελαστικό faux leather</strong> που δημιουργεί ένα εντυπωσιακό εφέ δεύτερης επιδερμίδας. Το υλικό αγκαλιάζει απαλά κάθε καμπύλη, αποκαλύπτοντας τη φυσική σας ομορφιά με ανατριχιαστική ακρίβεια. Το <strong>μπουστάκι από δύο υλικά</strong> στη μέση είναι ένας εξαιρετικός συνδυασμός από faux leather και διαφανές δίχτυ. Αυτή η αλληλεπίδραση μεταξύ αδιαφανών και διαφανών υλικών δημιουργεί μια γοητευτική οπτική αντίθεση που αποκαλύπτει την τόλμη σας με φινέτσα.</p> <p>Τα <strong>πλαϊνά ραφτάκια</strong> προσθέτουν μια έξυπνη τεχνική πινελιά που εναρμονίζει φυσικά τη σιλουέτα. Δημιουργούν ένα λεπτό εφέ γλυπτικής που αναδεικνύει τα προσόντα σας, ενώ παράλληλα εξομαλύνει διακριτικά τις μικρές περιοχές που θέλετε να απαλύνετε, όπως οι γοφοί ή η κοιλιά.</p> <p>Το <strong>απόλυτα ισορροπημένο μίντι μήκος</strong> αποκαλύπτει με τόλμη τα πόδια σας χωρίς να το παρακάνετε. Αυτή η μελετημένη αναλογία δημιουργεί μια τέλεια αρμονία που <strong>προσαρμόζεται σε όλα τα σχήματα σώματος</strong> με φυσική κομψότητα.</p> <p>Η <strong>λεπτή γυαλάδα του faux</strong> leather πιάνει απαλά το φως σε κάθε κίνηση, δημιουργώντας μια λαμπερή αύρα που σίγουρα θα τραβήξει τα βλέμματα όλων. Αυτό το τεχνικό υλικό εγγυάται <strong>βέλτιστη άνεση όλο το βράδυ</strong> χάρη στην εξαιρετική ελαστικότητά του. Όταν φοράτε αυτό το φόρεμα, γίνεστε το εκλεπτυσμένο κακό κορίτσι που μαγνητίζει με το rock-chic στυλ και την ακαταμάχητη μαγνητική αυτοπεποίθησή της.</p>
guid
stringhttps://dev.divasboudoir.com/el/forema-megaloy-megethoys-apo-faux-derma-me-straples-danteles-mprosta/cdbu9377.htm
highlights
string<ul> <li><strong>Ελαστικό ψεύτικο δέρμα</strong> που αγκαλιάζει τέλεια τις φυσικές σας καμπύλες</li> <li>Εκλεπτυσμένο<strong>μπουστάκι από δύο υλικά,</strong> ψεύτικο δέρμα και διαφανές δίχτυ</li> <li><strong>Γλυπτικές πλαϊνές φουρκέτες</strong> που εναρμονίζουν φυσικά τη σιλουέτα</li> <li><strong>Επίδραση δεύτερης επιδερμίδας</strong> χάρη στο εξαιρετικά εύπλαστο ύφασμα</li> <li><strong>Τέλειο μήκος midi</strong>, ούτε πολύ κοντό ούτε πολύ μακρύ</li> <li><strong>Η διακριτική γυαλάδα</strong> πιάνει το φως με κομψότητα</li> <li><strong>Ελεγχόμενο κόψιμο σε σχήμα σώματος</strong> που αποκαλύπτει χωρίς να είναι χυδαίο</li> <li><strong>Ροκ-σικ στυλ</strong> που σπάει τους παραδοσιακούς κώδικες</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringΦόρεμα από απομίμηση δέρματος plus size με διχτυωτό φόρεμα: μπουστάκι με κορδόνια, σμιλευτικές ραφές, εφέ δεύτερης επιδερμίδας, μήκος midi. Εκλεπτυσμένη ροκ λάμψη | Diva's Boudoir
keywords
string
title
stringRock glamour φόρεμα σε faux δέρμα μεγάλο μέγεθος | Diva's Boudoir
seotitle
stringΦόρεμα από faux leather fishnet σε μεγάλο μέγεθος με δαντελωτό μπουστάκι
seouri
stringφόρεμα-μεγάλου-μεγέθους-από-faux-δέρμα-με-στράπλες-δαντέλες-μπροστά
specifications
string<ul> <li><strong>Τύπος :</strong> Μίντι φόρεμα</li> <li><strong>Υλικό :</strong> Υψηλής ποιότητας ελαστικό faux δέρμα</li> <li><strong>Μπουστάκι :</strong> Δι-υλικό από ψεύτικο δέρμα και διαφανές δίχτυ</li> <li><strong>Λεπτομέρειες :</strong> Γλυπτικές πλαϊνές φουρκέτες</li> <li><strong>Μήκος :</strong> Κομψό μίντι</li> <li><strong>Κοπή :</strong> Body-con με εφέ δεύτερου δέρματος</li> <li><strong>Στυλ:</strong> Εκλεπτυσμένη ροκ γοητεία</li> <li><strong>Περιστάσεις :</strong> Τολμηρές βραδιές και ειδικές εκδηλώσεις</li> </ul>
stylingtips
string<p>Ενισχύστε το φόρεμά σας με τις διχτυωτές <a href="https://www.divasboudoir.com/el/kaltses-megaloy-megethoys/">κάλτσες plus size</a> για μια απόλυτα ροκ εμφάνιση, ή προσθέστε το μαύρο <a href="https://www.divasboudoir.com/el/eswroychwn-syn-megethos/">plus size βρακί</a> μας για τέλεια αρμονία.</p> <p>Συμπληρώστε το με τα <a href="https://www.divasboudoir.com/fr/tenues-sexy-grande-taille/">σέξι plus size σύνολά</a> μας για να δημιουργήσετε μια ποικιλία εμφανίσεων, ή εξερευνήστε τα <a href="https://www.divasboudoir.com/el/sexi-foremata-syn-megethos/">σέξι plus size φορέματά</a> μας από την ίδια συλλογή για ακόμα περισσότερες ροκ λαμπερές δυνατότητες. Αυτή η μοναδική δημιουργία αποκαλύπτει την επαναστατική σας πλευρά με ανησυχητική κομψότητα.</p>
summary
string<p>Ανακαλύψτε αυτό το εντυπωσιακό φόρεμα από ελαστικό faux leather που φέρνει επανάσταση στην τέχνη του glam rock! Ο στράπλες σχεδιασμός του συνδυάζει το faux leather και το διαφανές δίχτυ, ενώ τα πλαϊνά ραφτάκια του δημιουργούν μια τέλεια σμιλεμένη σιλουέτα.</p> <p>Με το second-skin υλικό του και το midi μήκος του, αυτή η δημιουργία μετατρέπει κάθε εμφάνιση σε μια στιγμή καθαρής γοητείας.</p>
title
stringΦόρεμα από σιμιλικιούρ και δίχτυ - Ροκ λάμψη και απόλυτη σοφιστεία
usageinstructions
string<p>Φορέστε απαλά αυτό το φόρεμα, προσέχοντας το ελαστικό faux leather. Το <strong>μπουστάκι από δύο υλικά</strong> τοποθετείται φυσικά για να δημιουργήσει αυτό το εκλεπτυσμένο αποτέλεσμα μεταξύ του faux leather και του διαφανούς διχτυωτού. Το ελαστικό ύφασμα αγκαλιάζει φυσικά το σχήμα σας χωρίς περιορισμούς, επιτρέποντας απόλυτη ελευθερία κινήσεων. Τα πλαϊνά πιασίματα τοποθετούνται αυτόματα για να δημιουργήσουν ένα εφέ γλυπτικής που <strong>συμπληρώνει όλα τα σχήματα σώματος</strong>. Αυτό το φόρεμα αποκαλύπτει την τολμηρή πλευρά σας με ροκ-σικ εκλέπτυνση.</p>
en
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Hand-wash in cold water to preserve the imitation leather</li> <li>Use a mild detergent without aggressive agents</li> <li>Dry flat to maintain shape</li> <li>Never iron directly on imitation leather</li> <li>Handle lacing system with care</li> <li>Store hanging to avoid permanent creases</li> </ul>
description
string<p>This dress revolutionizes the art of glam rock with its <strong>elastic faux leather</strong> that creates a striking second-skin effect. The material delicately hugs every curve, revealing your natural beauty with uncanny precision. The <strong>two-material bustier</strong> at the waist brilliantly combines faux leather and transparent fishnet. This interplay of opaque and transparent materials creates a captivating visual contrast that reveals your boldness with sophistication.</p> <p>The <strong>side gathers</strong> add that ingenious technical touch that naturally harmonizes the silhouette. They create a delicate sculpting effect that highlights your assets while discreetly erasing small areas you'd like to soften, such as the hips or tummy.</p> <p>The <strong>perfectly balanced midi length</strong> boldly reveals your legs without going overboard. This studied proportion creates a perfect harmony that <strong>adapts to all morphologies</strong> with natural elegance.</p> <p>The <strong>subtle sheen of imitation leather</strong> delicately catches the light with every movement, creating that glamorous aura that draws all eyes. This technical material guarantees <strong>optimal comfort all evening long</strong> thanks to its exceptional elasticity. When you wear this dress, you become that sophisticated bad girl who hypnotizes with rock-chic style and irresistible magnetic confidence.</p>
guid
stringhttps://dev.divasboudoir.com/en/plus-size-strapless-lace-up-faux-leather-dress/cdbu9377.htm
highlights
string<ul> <li><strong>Elastic faux leather</strong> that perfectly hugs your natural curves</li> <li>Sophisticated<strong>two-material bustier of</strong> leatherette and sheer fishnet</li> <li><strong>Sculpting side gathers</strong> naturally harmonize the silhouette</li> <li><strong>Second-skin effect</strong> thanks to ultra-mouldable fabric</li> <li><strong>Perfect midi length</strong>, neither too short nor too long</li> <li><strong>Subtle shimmer</strong> that catches the light with elegance</li> <li><strong>Controlled body-con cut</strong> that reveals without vulgarity</li> <li><strong>Rock-chic style</strong> that breaks with traditional codes</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringImitation leather plus size fishnet dress: strapless lacing, sculpting gathers, second-skin effect, midi length. Rock glamour sophistication | Diva's Boudoir
keywords
string
title
stringDress faux leather plus size fishnet rock glamour | Diva's Boudoir
seotitle
stringPlus size faux-leather fishnet dress with lace-up bustier
seouri
stringplus-size-strapless-lace-up-faux-leather-dress
specifications
string<ul> <li><strong>Type :</strong> Midi dress</li> <li><strong>Material:</strong> High-quality elastic faux leather</li> <li><strong>Bustier:</strong> Bi-material faux leather and transparent fishnet</li> <li><strong>Details:</strong> Sculpting side gathers</li> <li><strong>Length:</strong> Elegant midi</li> <li><strong>Cut:</strong> Body-con with second-skin effect</li> <li><strong>Style:</strong> Sophisticated rock glamour</li> <li><strong>Occasions:</strong> Bold evenings and special events</li> </ul>
stylingtips
string<p>Enhance your dress with our <a href="https://www.divasboudoir.com/en/socks-large-size/">plus size</a> fishnet <a href="https://www.divasboudoir.com/en/socks-large-size/">stockings</a> for a total rock look, or add our black <a href="https://www.divasboudoir.com/en/plus-size-panties/">plus size panties</a> for perfect harmony.</p> <p>Complete your look with our <a href="https://www.divasboudoir.com/fr/tenues-sexy-grande-taille/">sexy plus size outfits</a> to create a variety of looks, or explore our <a href="https://www.divasboudoir.com/en/sexys-plus-size-dresses/">sexy plus size dresses</a> from the same collection to multiply your rock-glamour possibilities. This unique creation reveals your rebellious side with unsettling elegance.</p>
summary
string<p>Discover this spectacular dress in stretch faux leather that revolutionizes the art of rock glamour! Its strapless design combines faux-leather with transparent fishnet and side gathers to create a perfectly sculpted silhouette.</p> <p>With its second-skin material and midi length, this creation transforms every appearance into a moment of pure fascination.</p>
title
stringSimilicuir et Résille Dress - Rock Glamour and Absolute Sophistication
usageinstructions
string<p>Carefully slip on this dress, taking care of the elastic faux leather. The <strong>two-material bustier</strong> positions itself naturally to create that sophisticated effect between faux leather and transparent fishnet. The stretch fabric naturally hugs your shape without constraint, allowing total freedom of movement. The side gathers position themselves automatically to create a sculpting effect that <strong>harmonizes every body type</strong>. This dress reveals your bold side with rock-chic sophistication.</p>
es
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavar a mano en agua fría para preservar la imitación de cuero</li> <li>Utilice un detergente suave sin agentes agresivos</li> <li>Séquelo en plano para mantener la forma</li> <li>No planchar nunca directamente sobre la polipiel</li> <li>Manipule con cuidado el sistema de cordones</li> <li>Guárdelo colgado para evitar arrugas permanentes</li> </ul>
description
string<p>Este vestido revoluciona el arte del glam rock con su <strong>piel sintética elástica</strong> que crea un sorprendente efecto segunda piel. El material abraza suavemente cada curva, revelando tu belleza natural con una precisión asombrosa. El <strong>corpiño de dos materiales</strong> en la cintura es una brillante combinación de piel sintética y rejilla transparente. Este juego de materiales opacos y transparentes crea un cautivador contraste visual que revela tu audacia con sofisticación.</p> <p>Los <strong>fruncidos laterales</strong> añaden ese ingenioso toque técnico que armoniza naturalmente la silueta. Crean un delicado efecto esculpido que realza tus activos a la vez que alisa discretamente las pequeñas zonas que quieras suavizar, como las caderas o el vientre.</p> <p>El <strong>largo midi, perfectamente equilibrado</strong>, deja al descubierto las piernas sin exagerar. Esta estudiada proporción crea una armonía perfecta que <strong>se adapta a todas las formas del cuerpo</strong> con una elegancia natural.</p> <p><strong>El sutil brillo de la piel sintética</strong> capta delicadamente la luz con cada movimiento, creando un aura de glamour que atraerá todas las miradas. Este material técnico garantiza <strong>un confort óptimo durante toda la velada</strong> gracias a su excepcional elasticidad. Con este vestido, te convertirás en esa sofisticada chica mala que cautiva con su estilo rock-chic y su irresistible seguridad magnética.</p>
guid
stringhttps://dev.divasboudoir.com/es/talla-grande-vestido-de-piel-sintética-con-lazada-delantera-sin-tirantes/cdbu9377.htm
highlights
string<ul> <li><strong>Piel sintética elástica</strong> que se adapta perfectamente a tus curvas naturales</li> <li>Sofisticado<strong>corpiño bimateria de</strong> piel sintética y rejilla transparente</li> <li><strong>Fruncidos laterales esculturales</strong> que armonizan naturalmente la silueta</li> <li><strong>Efecto segunda piel</strong> gracias al tejido ultramoldeable</li> <li><strong>Largo midi perfecto</strong>, ni demasiado corto ni demasiado largo</li> <li><strong>Brillo sutil</strong> que capta la luz con elegancia</li> <li><strong>Corte ajustado</strong> que revela sin ser vulgar</li> <li><strong>Estilo rock-chic</strong> que rompe con los códigos tradicionales</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringVestido de rejilla talla grande de polipiel: corpiño con cordones, fruncidos esculturales, efecto segunda piel, largo midi. Sofisticado glamour rockero | Diva's Boudoir
keywords
string
title
stringRock glamour vestido de cuero de imitación de talla grande | Diva's Boudoir
seotitle
stringVestido de rejilla de piel sintética talla grande con corpiño con cordones
seouri
stringtalla-grande-vestido-de-piel-sintética-con-lazada-delantera-sin-tirantes
specifications
string<ul> <li><strong>Tipo :</strong> Vestido midi</li> <li><strong>Material :</strong> Piel sintética elástica de alta calidad</li> <li><strong>Bustier :</strong> Piel sintética bimateria y rejilla transparente</li> <li><strong>Detalles :</strong> Esculpido fruncido lateral</li> <li><strong>Largo :</strong> Elegante midi</li> <li><strong>Corte :</strong> Body-con con efecto segunda piel</li> <li><strong>Estilo :</strong> Sofisticado glamour rockero</li> <li><strong>Ocasiones :</strong> Noches atrevidas y eventos especiales</li> </ul>
stylingtips
string<p>Realza tu vestido con nuestras <a href="https://www.divasboudoir.com/es/medias-grandes/">medias de</a> rejilla <a href="https://www.divasboudoir.com/es/medias-grandes/">talla grande</a> para un look rockero total, o añade nuestras <a href="https://www.divasboudoir.com/es/braguitas-de-talla-grande/">bragas</a> negras <a href="https://www.divasboudoir.com/es/braguitas-de-talla-grande/">talla grande</a> para una armonía perfecta.</p> <p>Compleméntalo con nuestros <a href="https://www.divasboudoir.com/fr/tenues-sexy-grande-taille/">conjuntos de talla grande sexy</a> para crear una gran variedad de looks, o explora nuestros <a href="https://www.divasboudoir.com/es/sexys-vestidos-talla-grande/">vestidos de talla grande sexy</a> de la misma colección para obtener aún más posibilidades de glamour rockero. Esta creación única revela tu lado rebelde con una elegancia inquietante.</p>
summary
string<p>Descubre este espectacular vestido de piel sintética elástica que revoluciona el arte del glam rock Su diseño sin tirantes combina piel sintética y rejilla transparente, y sus fruncidos laterales crean una silueta perfectamente esculpida.</p> <p>Con su material de segunda piel y su largo midi, esta creación transforma cada aparición en un momento de pura fascinación.</p>
title
stringSimilicuir y vestido de rejilla - Glamour rockero y sofisticación absoluta
usageinstructions
string<p>Desliza suavemente este vestido, teniendo cuidado con la piel sintética elástica. El <strong>corpiño de dos materiales</strong> se coloca de forma natural para crear ese efecto sofisticado entre la piel sintética y la red transparente. El tejido elástico se ciñe naturalmente a la silueta, permitiendo una total libertad de movimientos. Los fruncidos laterales se posicionan automáticamente para crear un efecto escultural que <strong>complementa todas las formas del cuerpo</strong>. Este vestido revela tu lado más atrevido con una sofisticación rock-chic.</p>
fr
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavage &agrave; la main &agrave; l'eau froide pour pr&eacute;server le similicuir</li> <li>Utiliser une lessive douce sans agents agressifs</li> <li>S&eacute;chage &agrave; plat pour maintenir la forme moulante</li> <li>Ne jamais repasser directement sur le similicuir</li> <li>Manipuler d&eacute;licatement le syst&egrave;me de la&ccedil;age</li> <li>Ranger suspendue pour &eacute;viter les plis permanents</li> </ul>
description
string<p>Cette robe r&eacute;volutionne l'art du rock glamour avec son <strong>similicuir &eacute;lastique</strong> qui cr&eacute;e un effet seconde peau saisissant. La mati&egrave;re &eacute;pouse d&eacute;licatement chaque courbe, r&eacute;v&eacute;lant votre beaut&eacute; naturelle avec une pr&eacute;cision troublante. Le <strong>bustier bi-mati&egrave;re</strong> au niveau de la taille conjugue brillamment similicuir et r&eacute;sille transparente. Ce jeu entre mati&egrave;res opaque et transparente cr&eacute;e un contraste visuel captivant qui r&eacute;v&egrave;le votre audace avec sophistication.</p> <p>Les&nbsp;<strong>fronces lat&eacute;rales</strong> apportent cette touche technique g&eacute;niale qui harmonise naturellement la silhouette. Elles cr&eacute;ent un effet sculptant d&eacute;licat qui met en valeur vos atouts tout en gommant discr&egrave;tement les petites zones que vous souhaitez adoucir, comme les hanches ou le ventre.</p> <p>La&nbsp;<strong>longueur midi parfaitement &eacute;quilibr&eacute;e</strong> r&eacute;v&egrave;le vos jambes avec audace sans tomber dans l'exc&egrave;s. Cette proportion &eacute;tudi&eacute;e cr&eacute;e une harmonie parfaite qui <strong>s'adapte &agrave; toutes les morphologies</strong> avec une &eacute;l&eacute;gance naturelle.</p> <p>Le&nbsp;<strong>brillant subtil du similicuir</strong> accroche d&eacute;licatement la lumi&egrave;re &agrave; chaque mouvement, cr&eacute;ant cette aura glamour qui attire tous les regards. Cette mati&egrave;re technique garantit un <strong>confort optimal toute la soir&eacute;e</strong> gr&acirc;ce &agrave; son &eacute;lasticit&eacute; exceptionnelle. Quand vous portez cette robe, vous devenez cette bad girl sophistiqu&eacute;e qui hypnotise avec son style rock-chic et son assurance magn&eacute;tique irr&eacute;sistible.</p>
guid
stringhttps://dev.divasboudoir.com/fr/robe-grande-taille-similicuir-resille-bustier-lacage/cdbu9377.htm
highlights
string<ul> <li><strong>Similicuir &eacute;lastique</strong> qui &eacute;pouse parfaitement vos courbes naturelles</li> <li><strong>Bustier bi-mati&egrave;re</strong> similicuir et r&eacute;sille transparente sophistiqu&eacute;e</li> <li><strong>Fronces lat&eacute;rales sculptantes</strong> qui harmonisent naturellement la silhouette</li> <li><strong>Effet seconde peau</strong> gr&acirc;ce &agrave; la mati&egrave;re ultra-moulante</li> <li><strong>Longueur midi parfaite</strong> ni trop courte ni trop longue</li> <li><strong>Brillant subtil</strong> qui accroche la lumi&egrave;re avec &eacute;l&eacute;gance</li> <li><strong>Coupe body-con ma&icirc;tris&eacute;e</strong> qui r&eacute;v&egrave;le sans vulgarit&eacute;</li> <li><strong>Style rock-chic</strong> qui sort des codes traditionnels</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringRobe similicuir grande taille résille : bustier laçage, fronces sculptantes, effet seconde peau, longueur midi. Rock glamour sophistiqué | Diva's Boudoir
keywords
string
title
stringRobe similicuir grande taille résille rock glamour | Diva's Boudoir
seotitle
stringRobe grande taille similicuir résille avec bustier laçage
seouri
stringrobe-grande-taille-similicuir-resille-bustier-lacage
specifications
string<ul> <li><strong>Type :</strong> Robe moulante midi</li> <li><strong>Mati&egrave;re :</strong> Similicuir &eacute;lastique haute qualit&eacute;</li> <li><strong>Bustier :</strong> Bi-mati&egrave;re similicuir et r&eacute;sille transparente</li> <li><strong>D&eacute;tails :</strong> Fronces lat&eacute;rales sculptantes</li> <li><strong>Longueur :</strong> Midi &eacute;l&eacute;gante</li> <li><strong>Coupe :</strong> Body-con avec effet seconde peau</li> <li><strong>Style :</strong> Rock glamour sophistiqu&eacute;</li> <li><strong>Occasions :</strong> Soir&eacute;es audacieuses et &eacute;v&eacute;nements sp&eacute;ciaux</li> </ul>
stylingtips
string<p>Sublimez votre robe avec nos <a href="https://www.divasboudoir.com/fr/bas-grande-taille/">bas grande taille</a> r&eacute;sille pour un look total rock, ou ajoutez nos <a href="https://www.divasboudoir.com/fr/culottes-grande-taille/">culottes grande taille</a> noires pour une harmonie parfaite.</p> <p>Compl&eacute;tez avec nos&nbsp;<a href="https://www.divasboudoir.com/fr/tenues-sexy-grande-taille/">tenues sexys grande taille</a> pour cr&eacute;er des looks vari&eacute;s, ou explorez nos <a href="https://www.divasboudoir.com/fr/robes-sexys-grande-taille/">robes sexys grande taille</a> de la m&ecirc;me collection pour multiplier les possibilit&eacute;s rock-glamour. Cette cr&eacute;ation unique r&eacute;v&egrave;le votre c&ocirc;t&eacute; rebelle avec une &eacute;l&eacute;gance troublante.</p>
summary
string<p>D&eacute;couvrez cette robe spectaculaire en similicuir &eacute;lastique qui r&eacute;volutionne l'art du rock glamour ! Son bustier alliant similicuir et r&eacute;sille transparente et ses fronces lat&eacute;rales cr&eacute;ent une silhouette parfaitement sculpt&eacute;e.</p> <p>Avec sa mati&egrave;re seconde peau et sa longueur midi, cette cr&eacute;ation transforme chaque apparition en moment de pure fascination.</p>
title
stringRobe Similicuir et Résille - Rock Glamour et Sophistication Absolue
usageinstructions
string<p>Enfilez d&eacute;licatement cette robe en prenant soin du similicuir &eacute;lastique. Le <strong>bustier bi-mati&egrave;re</strong> se positionne naturellement pour cr&eacute;er cet effet sophistiqu&eacute; entre similicuir et r&eacute;sille transparente. La mati&egrave;re extensible &eacute;pouse naturellement vos formes sans contrainte, permettant une libert&eacute; de mouvement totale. Les fronces lat&eacute;rales se positionnent automatiquement pour cr&eacute;er cet effet sculptant qui <strong>harmonise toutes les morphologies</strong>. Cette robe r&eacute;v&egrave;le votre c&ocirc;t&eacute; audacieux avec une sophistication rock-chic assum&eacute;e.</p>
it
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavare a mano in acqua fredda per preservare l'imitazione della pelle</li> <li>Utilizzare un detergente delicato senza agenti aggressivi</li> <li>Asciugare in piano per mantenere la forma aderente</li> <li>Non stirare mai direttamente l'imitazione della pelle</li> <li>Maneggiare con cura il sistema di allacciatura</li> <li>Conservare appeso per evitare pieghe permanenti</li> </ul>
description
string<p>Questo abito rivoluziona l'arte del glam rock grazie all'<strong>ecopelle elasticizzata</strong> che crea un sorprendente effetto seconda pelle. Il materiale abbraccia delicatamente ogni curva, rivelando la vostra bellezza naturale con una precisione sorprendente. Il <strong>bustier bimateriale</strong> in vita è una brillante combinazione di ecopelle e rete trasparente. Questo gioco di materiali opachi e trasparenti crea un accattivante contrasto visivo che rivela la vostra audacia con raffinatezza.</p> <p>Le <strong>arricciature laterali</strong> aggiungono un ingegnoso tocco tecnico che armonizza naturalmente la silhouette. Creano un delicato effetto scultura che mette in risalto i vostri punti di forza, attenuando con discrezione le piccole zone che desiderate ammorbidire, come i fianchi o la pancia.</p> <p>La <strong>lunghezza midi, perfettamente bilanciata</strong>, mette in evidenza le gambe senza esagerare. Questa studiata proporzione crea un'armonia perfetta che si <strong>adatta a tutte le forme del corpo</strong> con naturale eleganza.</p> <p>La <strong>sottile lucentezza dell'ecopelle</strong> cattura delicatamente la luce a ogni movimento, creando un'aura glamour che cattura gli sguardi di tutti. Questo materiale tecnico garantisce <strong>un comfort ottimale per tutta la sera</strong> grazie alla sua eccezionale elasticità. Quando indossate questo abito, diventate la sofisticata bad girl che incanta con il suo stile rock-chic e la sua irresistibile sicurezza magnetica.</p>
guid
stringhttps://dev.divasboudoir.com/it/abito-taglia-grande-in-ecopelle-con-lacci-senza-spalline-sul-davanti/cdbu9377.htm
highlights
string<ul> <li><strong>Ecopelle elastica</strong> che abbraccia perfettamente le vostre curve naturali</li> <li>Sofisticato<strong>bustier bimateriale</strong> in ecopelle e rete trasparente</li> <li><strong>Arricciature laterali scolpite</strong> che armonizzano naturalmente la silhouette</li> <li><strong>Effetto seconda pelle</strong> grazie al tessuto ultra-modellabile</li> <li><strong>Lunghezza midi perfetta</strong>, né troppo corta né troppo lunga</li> <li><strong>Sottile lucentezza</strong> che cattura la luce con eleganza</li> <li><strong>Taglio body-con controllato</strong> che rivela senza essere volgare</li> <li><strong>Stile rock-chic</strong> che rompe i codici tradizionali</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringAbito a rete in finta pelle taglia grande: bustier con lacci, arricciature scultoree, effetto seconda pelle, lunghezza midi. Sofisticato glamour rock | Diva's Boudoir
keywords
string
title
stringAbito rock glamour in ecopelle taglia grande | Diva's Boudoir
seotitle
stringAbito a rete in ecopelle di taglia grande con bustier allacciato
seouri
stringabito-taglia-grande-in-ecopelle-con-lacci-senza-spalline-sul-davanti
specifications
string<ul> <li><strong>Tipo :</strong> abito midi</li> <li><strong>Materiale :</strong> Ecopelle elastica di alta qualità</li> <li><strong>Bustier :</strong> Ecopelle bi-materiale e rete trasparente</li> <li><strong>Dettagli :</strong> arricciature laterali che scolpiscono</li> <li><strong>Lunghezza :</strong> Elegante midi</li> <li><strong>Taglio :</strong> Body-con con effetto seconda pelle</li> <li><strong>Stile :</strong> Sofisticato glamour rock</li> <li><strong>Occasioni :</strong> Serate audaci ed eventi speciali</li> </ul>
stylingtips
string<p>Arricchite il vostro abito con le nostre <a href="https://www.divasboudoir.com/it/calze-di-grandi-dimensioni/">calze</a> a rete <a href="https://www.divasboudoir.com/it/calze-di-grandi-dimensioni/">plus size</a> per un look totalmente rock, oppure aggiungete le nostre <a href="https://www.divasboudoir.com/it/mutande-curvy/">mutandine</a> nere <a href="https://www.divasboudoir.com/it/mutande-curvy/">taglia grande</a> per un'armonia perfetta.</p> <p>Completate il tutto con i nostri <a href="https://www.divasboudoir.com/fr/tenues-sexy-grande-taille/">abiti sexy taglia grande</a> per creare una varietà di look, oppure esplorate i nostri <a href="https://www.divasboudoir.com/it/abiti-sexys-taglia-grande/">abiti sexy taglia grande</a> della stessa collezione per avere ancora più possibilità rock-glamour. Questa creazione unica rivela il vostro lato ribelle con un'eleganza sconvolgente.</p>
summary
string<p>Scoprite questo spettacolare abito in ecopelle elasticizzata che rivoluziona l'arte del glam rock! Il suo design senza spalline combina l'ecopelle e la rete trasparente, mentre le arricciature laterali creano una silhouette perfettamente scolpita.</p> <p>Con il suo materiale seconda pelle e la lunghezza midi, questa creazione trasforma ogni apparizione in un momento di puro fascino.</p>
title
stringAbito in Similicuir e rete - Glamour rock e raffinatezza assoluta
usageinstructions
string<p>Indossate questo abito con delicatezza, facendo attenzione all'ecopelle elasticizzata. Il <strong>bustier a due materiali</strong> si posiziona in modo naturale per creare quell'effetto sofisticato tra ecopelle e rete trasparente. Il tessuto elasticizzato abbraccia naturalmente le forme senza costringerle, consentendo una totale libertà di movimento. Le arricciature laterali si posizionano automaticamente per creare un effetto scultura che <strong>si adatta a tutte le forme del corpo</strong>. Questo abito rivela il vostro lato più audace con una raffinatezza rock-chic.</p>
nl
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Handwas in koud water om het imitatieleer te behouden</li> <li>Gebruik een mild wasmiddel zonder agressieve middelen</li> <li>Plat drogen om de vorm te behouden</li> <li>Nooit direct op het imitatieleer strijken</li> <li>Ga voorzichtig om met het vetersysteem</li> <li>Hangend bewaren om blijvende kreuken te voorkomen</li> </ul>
description
string<p>Deze jurk revolutioneert de kunst van glamrock met zijn <strong>stretch imitatieleer</strong> dat een opvallend tweede-huid effect creëert. Het materiaal omhelst zachtjes elke ronding en onthult je natuurlijke schoonheid met griezelige precisie. De <strong>bustier van twee materialen</strong> in de taille is een briljante combinatie van imitatieleer en transparant visnet. Dit samenspel van ondoorzichtige en transparante materialen creëert een fascinerend visueel contrast dat je vrijpostigheid op geraffineerde wijze onthult.</p> <p>De <strong>plooien aan de zijkanten</strong> voegen een ingenieus technisch detail toe dat het silhouet op natuurlijke wijze harmoniseert. Ze creëren een delicaat sculpturerend effect dat je pluspunten benadrukt en tegelijkertijd discreet kleine zones gladstrijkt die je wilt verzachten, zoals de heupen of buik.</p> <p>De <strong>perfect uitgebalanceerde midilengte</strong> onthult je benen zonder te overdrijven. Deze uitgekiende proportie creëert een perfecte harmonie die <strong>zich</strong> met natuurlijke elegantie <strong>aan alle lichaamsvormen aanpast</strong>.</p> <p>De <strong>subtiele glans van het kunstleer</strong> vangt subtiel het licht bij elke beweging en creëert een glamoureuze uitstraling die zeker in het oog springt. Dit technische materiaal garandeert <strong>de hele avond optimaal comfort</strong> dankzij de uitzonderlijke elasticiteit. Als je deze jurk draagt, word je de geraffineerde bad girl die betovert met haar rock-chic stijl en onweerstaanbare magnetische zelfverzekerdheid.</p>
guid
stringhttps://dev.divasboudoir.com/nl/grote-maat-jurk-van-imitatieleer-met-strapless-vetersluiting-voor/cdbu9377.htm
highlights
string<ul> <li><strong>Elastisch imitatieleer</strong> dat je natuurlijke rondingen perfect omhelst</li> <li>Geraffineerde<strong>bustier van twee materialen,</strong> kunstleer en doorschijnend visnet</li> <li><strong>Sculpterende plooien aan de zijkant</strong> die het silhouet op natuurlijke wijze harmoniseren</li> <li><strong>Tweede-huid effect</strong> dankzij de zeer vormbare stof</li> <li><strong>Perfecte midilengte</strong>, niet te kort en niet te lang</li> <li><strong>Subtiele glans</strong> die het licht met elegantie vangt</li> <li><strong>Gecontroleerde body-con snit</strong> die onthult zonder vulgair te zijn</li> <li><strong>Rock-chique stijl</strong> die breekt met traditionele codes</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringVisnetjurk van imitatieleer op grote maat: bustier met vetersluiting, beeldhouwende plooien, tweedehuideffect, midielengte. Verfijnde rockglamour | Diva's Boudoir
keywords
string
title
stringRock glamour jurk in kunstleer grote maat | Diva's Boudoir
seotitle
stringGrote maat visnet jurk van imitatieleer met kanten bustier
seouri
stringgrote-maat-jurk-van-imitatieleer-met-strapless-vetersluiting-voor
specifications
string<ul> <li><strong>Type :</strong> Midi-jurk</li> <li><strong>Materiaal :</strong> Hoogwaardig elastisch kunstleer</li> <li><strong>Bustier :</strong> Bi-materiaal kunstleer en transparant visnet</li> <li><strong>Details :</strong> Sculpting zijwaartse plooien</li> <li><strong>Lengte :</strong> Elegante midi</li> <li><strong>Snit :</strong> Body-con met tweede huid effect</li> <li><strong>Stijl:</strong> Verfijnde rockglamour</li> <li><strong>Gelegenheden :</strong> Gedurfde avonden en speciale evenementen</li> </ul>
stylingtips
string<p>Maak je jurk af met onze <a href="https://www.divasboudoir.com/nl/grote-maat-kousen/">grote maten</a> visnet <a href="https://www.divasboudoir.com/nl/grote-maat-kousen/">kousen</a> voor een totale rock look, of voeg onze zwarte <a href="https://www.divasboudoir.com/nl/groote-maten-slipjes/">grote maten onderbroeken</a> toe voor een perfecte harmonie.</p> <p>Maak het af met onze <a href="https://www.divasboudoir.com/fr/tenues-sexy-grande-taille/">sexy outfits van grote maten</a> om verschillende looks te creëren, of ontdek onze <a href="https://www.divasboudoir.com/nl/sexys-jurken-grote-maat/">sexy jurken</a> van <a href="https://www.divasboudoir.com/nl/sexys-jurken-grote-maat/">grote maten</a> uit dezelfde collectie voor nog meer rock-glamour mogelijkheden. Deze unieke creatie onthult je rebelse kant met verontrustende elegantie.</p>
summary
string<p>Ontdek deze spectaculaire jurk van stretch imitatieleer die een revolutie teweegbrengt in de glamrockkunst! Het strapless ontwerp combineert kunstleer en transparant visnet en de plooien aan de zijkanten creëren een perfect gebeeldhouwd silhouet.</p> <p>Met zijn tweedehuidmateriaal en midielengte maakt deze creatie van elke verschijning een moment van pure fascinatie.</p>
title
stringSimilicuir en visnet jurk - Rock Glamour en Absolute Sophistication
usageinstructions
string<p>Trek deze jurk voorzichtig aan en let op het elastische imitatieleer. De <strong>bustier van twee materialen</strong> positioneert zich op natuurlijke wijze om dat geraffineerde effect te creëren tussen imitatieleer en transparant visnet. De stretchstof omhelst je vorm op een natuurlijke manier en zorgt voor volledige bewegingsvrijheid. De plooien aan de zijkanten positioneren zichzelf automatisch om een modellerend effect te creëren dat <strong>bij alle lichaamsvormen</strong> past. Deze jurk onthult je gedurfde kant met rock-chique raffinement.</p>
pt
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavar à mão em água fria para preservar a imitação de couro</li> <li>Utilizar um detergente suave sem agentes agressivos</li> <li>Secar na horizontal para manter a forma correta</li> <li>Nunca passar a ferro diretamente sobre a imitação de pele</li> <li>Manusear o sistema de atacadores com cuidado</li> <li>Guardar pendurado para evitar vincos permanentes</li> </ul>
description
string<p>Este vestido revoluciona a arte do glam rock com a sua <strong>pele sintética el</strong> ástica que cria um efeito de segunda pele impressionante. O material abraça suavemente todas as curvas, revelando a sua beleza natural com uma precisão incrível. O <strong>corpete de dois materiais</strong> na cintura é uma combinação brilhante de pele sintética e rede transparente. Esta interação entre materiais opacos e transparentes cria um contraste visual cativante que revela a sua ousadia com sofisticação.</p> <p>Os <strong>franzidos laterais</strong> acrescentam um toque técnico engenhoso que harmoniza naturalmente a silhueta. Criam um efeito de escultura delicado que realça os seus atributos, ao mesmo tempo que alisam discretamente as pequenas áreas que pretende suavizar, como as ancas ou a barriga.</p> <p>O <strong>comprimento midi perfeitamente equilibrado</strong> revela as suas pernas sem exagerar. Esta proporção estudada cria uma harmonia perfeita que <strong>se adapta a todas as formas do corpo</strong> com uma elegância natural.</p> <p>O <strong>brilho subtil da pele sintética</strong> capta delicadamente a luz a cada movimento, criando uma aura de glamour que não deixará de chamar a atenção de ninguém. Este material técnico garante <strong>um conforto ótimo durante toda a noite</strong> graças à sua elasticidade excecional. Quando veste este vestido, torna-se a bad girl sofisticada que fascina com o seu estilo rock-chic e uma confiança magnética irresistível.</p>
guid
stringhttps://dev.divasboudoir.com/pt/vestido-de-tamanho-grande-em-pele-sintética-com-frente-em-renda-sem-alças/cdbu9377.htm
highlights
string<ul> <li><strong>Pele sintética elástica</strong> que abraça perfeitamente as suas curvas naturais</li> <li><strong>Corpete</strong> sofisticado de<strong>dois materiais</strong>, em pele sintética e rede transparente</li> <li><strong>Franzidos laterais esculturais</strong> que harmonizam naturalmente a silhueta</li> <li><strong>Efeito de segunda pele</strong> graças ao tecido ultra-moldável</li> <li><strong>Comprimento midi perfeito</strong>, nem demasiado curto nem demasiado comprido</li> <li><strong>Brilho subtil</strong> que capta a luz com elegância</li> <li><strong>Corte body-con controlado</strong> que revela sem ser vulgar</li> <li><strong>Estilo rock-chic</strong> que rompe com os códigos tradicionais</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringVestido de rede em imitação de pele plus size: corpete com cordões, franzidos esculturais, efeito de segunda pele, comprimento midi. Glamour sofisticado do rock | Diva's Boudoir
keywords
string
title
stringVestido rock glamour em pele sintética tamanho grande | Diva's Boudoir
seotitle
stringVestido de rede em pele sintética de tamanho grande com corpete com cordões
seouri
stringvestido-de-tamanho-grande-em-pele-sintética-com-frente-em-renda-sem-alças
specifications
string<ul> <li><strong>Tipo :</strong> Vestido midi</li> <li><strong>Material :</strong> Pele sintética elástica de alta qualidade</li> <li>Corpete<strong>:</strong> Couro sintético bi-material e rede transparente</li> <li><strong>Pormenores :</strong> Pregas laterais esculpidas</li> <li><strong>Comprimento :</strong> Midi elegante</li> <li><strong>Corte :</strong> Body-con com efeito de segunda pele</li> <li><strong>Estilo:</strong> Glamour sofisticado do rock</li> <li><strong>Ocasiões :</strong> Noites ousadas e eventos especiais</li> </ul>
stylingtips
string<p>Realce o seu vestido com as nossas <a href="https://www.divasboudoir.com/pt/meias-de-tamanho-grande/">meias</a> de rede <a href="https://www.divasboudoir.com/pt/meias-de-tamanho-grande/">plus size</a> para um look totalmente rock, ou adicione <a href="https://www.divasboudoir.com/pt/calcinhas-curvy/">as</a> nossas <a href="https://www.divasboudoir.com/pt/calcinhas-curvy/">cuecas plus size</a> pretas para uma harmonia perfeita.</p> <p>Complete-o com os nossos <a href="https://www.divasboudoir.com/fr/tenues-sexy-grande-taille/">conjuntos sexy plus size</a> para criar uma variedade de looks, ou explore os nossos <a href="https://www.divasboudoir.com/pt/vestidos-sexys-plus-size/">vestidos sexy plus size</a> da mesma coleção para ainda mais possibilidades rock-glamour. Esta criação única revela o seu lado rebelde com uma elegância inquietante.</p>
summary
string<p>Descubra este vestido espetacular em pele sintética elástica que revoluciona a arte do glam rock! O seu design sem alças combina pele sintética e rede transparente, e as suas pregas laterais criam uma silhueta perfeitamente esculpida.</p> <p>Com a sua matéria de segunda pele e comprimento midi, esta criação transforma cada aparição num momento de puro fascínio.</p>
title
stringVestido de rede e símil - Rock Glamour e Sofisticação Absoluta
usageinstructions
string<p>Calce suavemente este vestido, tendo cuidado com a pele sintética elástica. O <strong>corpete de dois materiais</strong> posiciona-se naturalmente para criar esse efeito sofisticado entre a pele sintética e a rede transparente. O tecido elástico abraça naturalmente a sua forma sem constrangimentos, permitindo uma total liberdade de movimentos. As pregas laterais posicionam-se automaticamente para criar um efeito de escultura que <strong>complementa todas as formas do corpo</strong>. Este vestido revela o seu lado ousado com uma sofisticação rock-chic.</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
stringsz2406183353797637 similicuir
netweight
string
nextshipment
stringtomorrow
ordered
number3
orderidx
number0
origin
string
originalsize
string
packaging
number0
productshipment
stringauto
productuid
string3C50F72E-46D4-4EA6-A8A89E5C9E7DAD3C
promountil
string
rating
stringnone
recorduid
string3C50F72E-46D4-4EA6-A8A89E5C9E7DAD3C
reference
stringCDBU9377
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.41 ms
Record Count: 5
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_sizes.id_size as recorduid, if(intlsize <> '',intlsize,eusize) as size, if(intlsize <> '','intlsize','eusize') as sizetype,
product_variations.color,
if(product_sizes.sizegroup = 'bra',
if(intlsize <> '', cast(intlsize as SIGNED ), cast(eusize as SIGNED ))
,
SUBSTRING_INDEX(intlsize,'-',1)
) as param1,
if(product_sizes.sizegroup = 'bra',
if(intlsize <> '',
MID(intlsize,length(cast(intlsize as SIGNED ))+1,length(intlsize)),
MID(eusize,length(cast(eusize as SIGNED ))+1,length(eusize))
)
,
SUBSTRING_INDEX(intlsize,'-',-1)
) as param2,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as available,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
999999,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as groupavailable,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
product_sizes.gender, product_sizes.sizerange, product_sizes.sizegroup, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize,
product_sizes.bust, product_sizes.waist, product_sizes.hip, product_sizes.underbust, product_sizes.cup, product_sizes.thigh, product_sizes.legheight, product_sizes.bodyheight, product_sizes.bodyweight
from product_sizes
left outer join product_variations on product_sizes.suppliersize = product_variations.size and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
where FIND_IN_SET(product_sizes.id_size,'2334,2335,2336,2337,2338') > 0
and product_variations.productuid = '3C50F72E-46D4-4EA6-A8A89E5C9E7DAD3C'
and intlsize <> 'na'
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_sizes.id_size, product_variations.color
order by FIELD(product_sizes.gender,'w','m'), product_sizes.sizegroup, FIELD(intlsize,'XS','S','S/M','S-M','M','M/L','M-L','L','L-XL','L/XL','XL','0X','0XL','lXL','1X','1X-2X','1X/2X','XL/2XL','XL-2XL','1XL-2XL','2XL','2X','XXL','2X-3X','2X/3X','2XL-3XL','2XL/3XL','XXXL','3XL','3X','3X-4X','3X/4X','3XL-4XL','3XL/4XL','4XL','5XL','5X','5X-6X','5X/6X','5XL-6XL','5XL/6XL','6XL','6X','7XL','7X','8XL','8X'), cast(intlsize as SIGNED ), groupavailable desc, stock desc
recorduidsizesizetypecolorparam1param2availablegroupavailablestockgendersizerangesizegroupsuppliersizeintlsizeincheseusizeussizeuksizefrsizeessizedesizeitsizeptsizeelsizebustwaisthipunderbustcupthighlegheightbodyheightbodyweight
123384Xintlsizeblack4X4X-19999990wplusdress4XL4X502024525250565250128-134107-112133-140
22334XLintlsizeblackXLXL-19999990wplusdress0XLXL421216444442484442100-10779-86105-112
323351Xintlsizeblack1X1X000wplusdress1XL1X441418464644504644107-11486-93112-119
423362XLintlsizeblack2XL2XL-19999990wplusdress2XL2XL461620484846524846114-12193-100119-126
523373Xintlsizeblack3X3X-19999990wplusdress3XL3X481822505048545048121-128100-107126-133
sizeranges
stringplus
sizes
string2334,2335,2336,2337,2338
sizetype
stringauto
specifications
Struct
Entries: 23
belly
string
bones
string
bra
string
breasts
string
bust
string
closing
string
crochtless
string
cups
string
cut
string
garter
string
halter
string
lacing
string
lining
string
modestypanel
string
panty
string
sheathing
string
sleeves
string
stocking
string
straps
string
stretch
string
suspenders
string
transparency
string
underwires
string
stock
number0
stocks
Query
Template: /system/api/product/stocks.cfc:25
Execution Time: 6.12 ms
Record Count: 5
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select * from (
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '3C50F72E-46D4-4EA6-A8A89E5C9E7DAD3C'
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 = '3C50F72E-46D4-4EA6-A8A89E5C9E7DAD3C'
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 = '3C50F72E-46D4-4EA6-A8A89E5C9E7DAD3C'
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 = '3C50F72E-46D4-4EA6-A8A89E5C9E7DAD3C'
and product_variations.isactive = 1
and product_sizes.id_size = 2337
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '3C50F72E-46D4-4EA6-A8A89E5C9E7DAD3C'
and product_variations.isactive = 1
and product_sizes.id_size = 2338
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
) tbl
group by productuid, variationuid, stockuid
order by stockuid, FIELD(gender,'w','m'), sizegroup, FIELD(intlsize,'XS','S','S/M','S-M','M','M/L','M-L','L','L-XL','L/XL','XL','0X','0XL','lXL','1X','1X-2X','1X/2X','XL/2XL','XL-2XL','1XL-2XL','2XL','2X','XXL','2X-3X','2X/3X','2XL-3XL','2XL/3XL','XXXL','3XL','3X','3X-4X','3X/4X','3XL-4XL','3XL/4XL','4XL','5XL','5X','5X-6X','5X/6X','5XL-6XL','5XL/6XL','6XL','6X','7XL','7X','8XL','8X'), cast(intlsize as SIGNED ), color
productuidvariationuidrecorduidcolorhexvaluesuppliersizeintlsizeincheseusizeussizeuksizefrsizeessizedesizeitsizeptsizeelsizegendersizegroupcupsizesizetypeitempriceitempromopromoUntilstockuidwarehouseontourpackagingsupplierreservedorderedreturneddefectmanufacturerreferenceeanavailablestockdisplaycomments
13C50F72E-46D4-4EA6-A8A89E5C9E7DAD3CEE84F732-A34C-4951-A2649984DF4CFCB82338black#0000004XL4X502024525250565250wdress4Xintlsize41.62533.2917{ts '2025-08-16 15:00:00'}STOCK01000-10200JIT234374382GHJK7C0394525742-10all
23C50F72E-46D4-4EA6-A8A89E5C9E7DAD3C3ADE3424-B78A-4B45-8445CE9CB8C4C86A2334black#0000000XLXL421216444442484442wdressXLintlsize41.62533.2917{ts '2025-08-16 15:00:00'}STOCK01000-10000-10all
33C50F72E-46D4-4EA6-A8A89E5C9E7DAD3C2A30B11B-4EDA-4F00-9E418644E100BA042335black#0000001XL1X441418464644504644wdress1Xintlsize41.62533.2917{ts '2025-08-16 15:00:00'}STOCK010000000000all
43C50F72E-46D4-4EA6-A8A89E5C9E7DAD3C297E4A5A-879C-4D56-B02BA2B38EA0A0402336black#0000002XL2XL461620484846524846wdress2XLintlsize41.62533.2917{ts '2025-08-16 15:00:00'}STOCK01000-10000-10all
53C50F72E-46D4-4EA6-A8A89E5C9E7DAD3C1ACAC4C5-76A2-4ABD-A1B6D70362E1E5322337black#0000003XL3X481822505048545048wdress3Xintlsize41.62533.2917{ts '2025-08-16 15:00:00'}STOCK01000-10100JIT188112082CS3UML0394525777-10all
subcategory
stringall
supplier
number-1
supplierreference
stringSZ2406183353797637
tags
string
themes
string
totalvariations
number5
type
stringdefault
unitprice
number41.625
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 8.82 ms
Record Count: 5
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '3C50F72E-46D4-4EA6-A8A89E5C9E7DAD3C' 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 = '3C50F72E-46D4-4EA6-A8A89E5C9E7DAD3C' 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 = '3C50F72E-46D4-4EA6-A8A89E5C9E7DAD3C' 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 = '3C50F72E-46D4-4EA6-A8A89E5C9E7DAD3C' 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 = '3C50F72E-46D4-4EA6-A8A89E5C9E7DAD3C' 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 = '3C50F72E-46D4-4EA6-A8A89E5C9E7DAD3C' 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 = '3C50F72E-46D4-4EA6-A8A89E5C9E7DAD3C'
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 = '3C50F72E-46D4-4EA6-A8A89E5C9E7DAD3C' 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 = '3C50F72E-46D4-4EA6-A8A89E5C9E7DAD3C' 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 = '3C50F72E-46D4-4EA6-A8A89E5C9E7DAD3C' 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 = '3C50F72E-46D4-4EA6-A8A89E5C9E7DAD3C' 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 = '3C50F72E-46D4-4EA6-A8A89E5C9E7DAD3C' 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 = '3C50F72E-46D4-4EA6-A8A89E5C9E7DAD3C' 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 = '3C50F72E-46D4-4EA6-A8A89E5C9E7DAD3C'
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 = '3C50F72E-46D4-4EA6-A8A89E5C9E7DAD3C' 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 = '3C50F72E-46D4-4EA6-A8A89E5C9E7DAD3C' 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 = '3C50F72E-46D4-4EA6-A8A89E5C9E7DAD3C' 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 = '3C50F72E-46D4-4EA6-A8A89E5C9E7DAD3C' 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 = '3C50F72E-46D4-4EA6-A8A89E5C9E7DAD3C' 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 = '3C50F72E-46D4-4EA6-A8A89E5C9E7DAD3C' 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 = '3C50F72E-46D4-4EA6-A8A89E5C9E7DAD3C'
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 = '3C50F72E-46D4-4EA6-A8A89E5C9E7DAD3C' 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 = '3C50F72E-46D4-4EA6-A8A89E5C9E7DAD3C' 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 = '3C50F72E-46D4-4EA6-A8A89E5C9E7DAD3C' 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 = '3C50F72E-46D4-4EA6-A8A89E5C9E7DAD3C' 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 = '3C50F72E-46D4-4EA6-A8A89E5C9E7DAD3C' 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 = '3C50F72E-46D4-4EA6-A8A89E5C9E7DAD3C' 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 = '3C50F72E-46D4-4EA6-A8A89E5C9E7DAD3C'
and product_variations.isactive = 1
and product_sizes.id_size = 2337
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '3C50F72E-46D4-4EA6-A8A89E5C9E7DAD3C' 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 = '3C50F72E-46D4-4EA6-A8A89E5C9E7DAD3C' 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 = '3C50F72E-46D4-4EA6-A8A89E5C9E7DAD3C' 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 = '3C50F72E-46D4-4EA6-A8A89E5C9E7DAD3C' 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 = '3C50F72E-46D4-4EA6-A8A89E5C9E7DAD3C' 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 = '3C50F72E-46D4-4EA6-A8A89E5C9E7DAD3C' 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 = '3C50F72E-46D4-4EA6-A8A89E5C9E7DAD3C'
and product_variations.isactive = 1
and product_sizes.id_size = 2338
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
order by FIELD(gender,'w','m'), sizegroup, FIELD(intlsize,'XS','S','S/M','S-M','M','M/L','M-L','L','L-XL','L/XL','XL','0X','0XL','lXL','1X','1X-2X','1X/2X','XL/2XL','XL-2XL','1XL-2XL','2XL','2X','XXL','2X-3X','2X/3X','2XL-3XL','2XL/3XL','XXXL','3XL','3X','3X-4X','3X/4X','3XL-4XL','3XL/4XL','4XL','5XL','5X','5X-6X','5X/6X','5XL-6XL','5XL/6XL','6XL','6X','7XL','7X','8XL','8X'), cast(intlsize as SIGNED ), color
variationuidrecorduidcolorhexvaluesuppliersizeintlsizeincheseusizeussizeuksizefrsizeessizedesizeitsizeptsizeelsizegendersizegroupcupsizesizetypeitempriceitempromopromoUntilstockuidwarehouseontourpackagingsupplierreservedorderedreturneddefectmanufacturerreferenceeanavailablestockavailablepersizestockpersizeavailablepercolorstockpercolorhaspromounitpricedisplaycomments
1EE84F732-A34C-4951-A2649984DF4CFCB82338black#0000004XL4X502024525250565250wdress4Xintlsize41.62533.2917{ts '2025-08-16 15:00:00'}STOCK01000-10200JIT234374382GHJK7C0394525742-10-10-10041.625all
23ADE3424-B78A-4B45-8445CE9CB8C4C86A2334black#0000000XLXL421216444442484442wdressXLintlsize41.62533.2917{ts '2025-08-16 15:00:00'}STOCK01000-10000-10-10-10041.625all
32A30B11B-4EDA-4F00-9E418644E100BA042335black#0000001XL1X441418464644504644wdress1Xintlsize41.62533.2917{ts '2025-08-16 15:00:00'}STOCK01000000000000-10041.625all
4297E4A5A-879C-4D56-B02BA2B38EA0A0402336black#0000002XL2XL461620484846524846wdress2XLintlsize41.62533.2917{ts '2025-08-16 15:00:00'}STOCK01000-10000-10-10-10041.625all
51ACAC4C5-76A2-4ABD-A1B6D70362E1E5322337black#0000003XL3X481822505048545048wdress3Xintlsize41.62533.2917{ts '2025-08-16 15:00:00'}STOCK01000-10100JIT188112082CS3UML0394525777-10-10-10041.625all
vatrate
number20
warehouse
number0