Mon panier

❌
Total articles
Voir le panier
Menu
Voir les tailles
Robe Solina : Audacieux Mélange Wetlook et Dentelle Élastique
Double-cliquez pour agrandir
SKU: DRCH7452
Robe Solina : Audacieux Mélange Wetlook et Dentelle Élastique
Stock:

Découvrez la robe Solina, un audacieux mélange de tissu wetlook et dentelles élastiques qui sculpte votre silhouette tout en douceur.

Avec ses grands décolletés avant et arrière, ses petites manches et sa grande ouverture zippée modulable, cette création bi-matière offre un look ultra sexy.

Points forts

  • Mélange audacieux wetlook et dentelles élastiques
  • Sculpte la silhouette tout en douceur et confort
  • Grands décolletés avant et arrière pour un effet saisissant
  • Ouverture zippée modulable pour jouer entre sexy et sage
  • Design bi-matière avec petites manches élégantes
Taille:

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

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

Robe grande taille bi-matière wetlook avec ouverture zippée

Description du produit

La robe Solina sublime vos courbes généreuses avec son audacieux mélange de tissu wetlook et dentelles élastiques qui sculpte votre silhouette tout en douceur. Cette création bi-matière s'adapte à toutes les morphologies grâce aux tissus extensibles qui épousent parfaitement vos formes.

Les grands décolletés à l'avant et à l'arrière créent un effet visuel captivant qui révèle votre côté le plus séduisant. Les petites manches ajoutent une touche d'élégance raffinée à l'ensemble.

La grande ouverture zippée constitue l'atout majeur de cette robe : elle vous permet de jouer entre un look plus sexy ou plus sage selon vos envies et l'occasion. 

Cette coupe ajustable valorise chaque silhouette avec ses matières extensibles qui garantissent un confort optimal toute la soirée. Les finitions soignées de cette belle combinaison de styles créent un look ultra sexy sophistiqué.

Détails techniques

  • Matières : Tissu wetlook et dentelles élastiques
  • Design : Bi-matière avec petites manches
  • Décolletés : Grands décolletés avant et arrière
  • Fermeture : Grande ouverture zippée modulable
  • Coupe : Ajustable qui sculpte la silhouette
  • Style : Ultra sexy avec effet wetlook sophistiqué

Tailles disponibles

Disponible du XL+ au 4XL

Couleur disponible

Noir

Guide de taille

Vérifiez la taille qui vous convient

International
  • Poitrine
  • Taille
  • Hanches
XL+
  • 113-118
  • 96-102
  • 117-121
L+
  • 98-105
  • 82-85
  • 105-108
2XL+
  • 125-130
  • 109-114
  • 127-132
3XL+
  • 137-142
  • 122-128
  • 138-144
4XL+
  • 149-154
  • 135-140
  • 151-156
XL
  • 107-112
  • 91-95
  • 113-116
2XL
  • 119-124
  • 103-108
  • 122-126
3XL
  • 131-136
  • 115-121
  • 133-138
4XL
  • 143-148
  • 129-134
  • 145-150

Conseils d'entretien

  • Lavage à la main à l'eau tiède (30°C maximum)
  • Utiliser une lessive douce pour préserver le tissu wetlook
  • Manipuler délicatement la fermeture zippée
  • Séchage à plat, à l'abri de la lumière directe
  • Ne pas repasser directement sur les parties wetlook

Conseils d'utilisation

La robe Solina est conçue pour révéler votre sensualité avec polyvalence. La grande ouverture zippée vous permet d'adapter votre look selon l'occasion : fermée pour un effet plus sage, ouverte pour un rendu ultra sexy. Les matières extensibles garantissent un confort optimal même lors de longues soirées.

Le mélange wetlook et dentelle crée un contraste saisissant qui sublime vos rondeurs naturellement. Cette coupe qui s'adapte à toutes les morphologies vous assure une élégance naturelle en toutes circonstances.

Conseils de style

La robe Solina se suffit à elle-même pour créer un look ultra sexy grâce à son design bi-matière audacieux. Jouez avec la fermeture zippée pour moduler l'intensité de votre look selon vos envies.

Le contraste wetlook et dentelle s'accorde parfaitement avec des accessoires sophistiqués. Pour une soirée glamour, laissez la zip légèrement ouverte pour révéler votre audace naturelle. Complétez votre look avec nos robes sexys pour varier les plaisirs, sublimez vos jambes avec nos bas élégants, ou explorez nos tenues sexys pour une garde-robe complète.

To Top
Voir le panier
Articles
Total articles
Struct
Entries: 108
actions
Array
available
number-1
brand
stringcottelli
brandcode
stringcwhd
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
stringCottelli
breasts
stringna
careinstructions
string
categories
stringdivasboudoir.cabaret.dresses.all,divasboudoir.lingerie.sexylingerie.babydoll
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.782 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12'
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 '2019-07-17 19:16:16'}
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
string
isactive
number1
iscustommade
number0
isdivasize
number1
isfirstprice
number0
isfixedprice
number0
ishot
number0
isnew
number0
isonline
number0
isoutletprice
number0
itemprice
number58.2917
itempromo
string
key
string27169761051-kleid
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-06-25 09:02:52'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.758 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('df4e0a50-1dd4-43b2-ae06b15e3f0e1c12',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.33 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 <> 'DRCH7452'
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
string1000
isprivate
string0
rating
stringall
src
string/photobank/products/cwhd/drch7452/27169761051_nor_a_1.jpg
type
stringimg
width
string800
back
Struct
height
string900
isprivate
string0
rating
stringall
src
string/photobank/products/cwhd/drch7452/27169761051_rs.jpg
type
stringimg
width
string622
default
Struct
height
string900
isprivate
string0
rating
stringall
src
string/photobank/products/cwhd/drch7452/robe-grande-taille-similicuir.jpg
type
stringimg
width
string622
variations
Struct
colors
Struct
black
Struct
height
string900
isprivate
string0
rating
stringall
src
string/photobank/products/cwhd/drch7452/robe-grande-taille-similicuir.jpg
type
stringimg
width
string622
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 in lauwarmem Wasser (maximal 30&deg;C)</li> <li>Verwende ein mildes Waschmittel, um den Wetlook-Stoff zu schonen</li> <li>Behutsam mit dem Reißverschluss umgehen</li> <li>Flach trocknen, vor direktem Licht schützen</li> <li>Nicht direkt auf den Wetlook-Teilen bügeln</li> </ul>
description
stringDieses Kleid von Solina bietet uns eine gewagte Mischung aus Wetlook-Stoff und elastischer Spitze, um Ihre Silhouette sanft zu skulptieren.<br /><br />Das Kleid hat einen großen Ausschnitt vorne und hinten, kleine Ärmel und vor allem eine große Öffnung mit Reißverschluss, mit der Sie spielen können, um einen sexy oder braven Effekt zu erzielen.
guid
stringhttps://dev.divasboudoir.com/de/kleid-in-ubergrosse-solina-schwarz/drch7452.htm
highlights
string<ul> <li><strong>Gewagte Mischung aus</strong> Wetlook und elastischer Spitze</li> <li><strong>Formt die Silhouette</strong> auf sanfte und bequeme Weise</li> <li><strong>Große Ausschnitte</strong> vorne und hinten für einen atemberaubenden Effekt</li> <li><strong>Verstellbare Reißverschlussöffnung</strong> für ein Spiel zwischen sexy und brav</li> <li><strong>Design aus zwei Materialien</strong> mit kleinen, eleganten Ärmeln</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringDieses Kleid in großen Größen aus zwei Materialien ist eine tolle Stilkombination für einen ultra-sexy Look. Und das bis Größe 64.
keywords
string
title
stringKleid in Übergröße Solina
seotitle
stringKleid in Übergröße Solina
seouri
stringkleid-in-ubergrosse-solina-schwarz
specifications
string<ul> <li><strong>Material:</strong> Wetlook-Stoff und elastische Spitze</li> <li><strong>Design:</strong> Bi-Material mit kleinen Ärmeln</li> <li><strong>Ausschnitte:</strong> Große Ausschnitte vorne und hinten</li> <li><strong>Verschluss:</strong> Große, veränderbare Reißverschlussöffnung</li> <li><strong>Schnitt:</strong> Verstellbarer Schnitt, der die Silhouette formt</li> <li><strong>Stil:</strong> Ultra sexy mit raffiniertem Wetlook-Effekt</li> </ul>
stylingtips
string<p>Das Kleid Solina ist selbsterklärend und kreiert mit seinem gewagten Design aus zwei Materialien einen ultra-sexy Look. Spielen Sie mit dem Reißverschluss, um die Intensität Ihres Looks nach Lust und Laune zu modulieren.</p> <p>Der Kontrast von Wetlook und Spitze passt perfekt zu raffinierten Accessoires. Für einen glamourösen Abend lassen Sie den Reißverschluss leicht geöffnet, um Ihre natürliche Kühnheit zu enthüllen. Vervollständigen Sie Ihren Look mit unseren <a href="https://www.divasboudoir.com/de/sexy-outfit-in-ubergrosse/">sexy Kleidern</a>, um Abwechslung zu schaffen, betonen Sie Ihre Beine mit unseren eleganten <a href="https://www.divasboudoir.com/de/strumpfe-in-grossen-grossen/">Strümpfen</a> oder erkunden Sie unsere <a href="https://www.divasboudoir.com/de/sexy-kleider-in-grossen-grossen/">sexy Outfits</a> für eine komplette Garderobe.</p>
summary
stringDieses Kleid in großen Größen aus zwei Materialien ist eine tolle Stilkombination für einen ultra-sexy Look. Und das bis Größe 64.
title
stringKleid Solina
usageinstructions
string<p>Das Kleid Solina wurde entworfen, um <strong>Ihre Sinnlichkeit</strong> auf vielseitige Weise zu enthüllen. Die große Öffnung mit Reißverschluss ermöglicht es Ihnen, Ihren Look je nach Anlass anzupassen: geschlossen für einen braveren Look, geöffnet für einen ultra-sexy Look. Die <strong>dehnbaren Materialien</strong> sorgen auch an langen Abenden für <strong>optimalen Tragekomfort</strong>.</p> <p>Die Mischung aus Wetlook und Spitze schafft einen spannenden Kontrast, der <strong>Ihre Rundungen</strong> auf natürliche Weise hervorhebt. Dieser <strong>Schnitt, der sich jeder Körperform anpasst</strong>, sorgt dafür, dass Sie in jeder Situation <strong> natürlich elegant</strong> aussehen.</p>
el
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Πλένετε στο χέρι με χλιαρό νερό (30&deg;C το πολύ)</li> <li>Χρησιμοποιήστε ένα ήπιο απορρυπαντικό για να διατηρήσετε το ύφασμα wetlook</li> <li>Χειριστείτε το φερμουάρ με προσοχή</li> <li>Στεγνώστε σε επίπεδη επιφάνεια, μακριά από το άμεσο φως</li> <li>Μην σιδερώνετε απευθείας τα τμήματα wetlook</li> </ul>
description
stringΑυτό το φόρεμα Solina είναι ένα τολμηρό μείγμα από wetlook ύφασμα και ελαστική δαντέλα που σμιλεύει απαλά τη σιλουέτα σας.<br /><br />Διαθέτει μεγάλη λαιμόκοψη μπροστά και πίσω, μικρά μανίκια και, πάνω απ' όλα, ένα μεγάλο άνοιγμα με φερμουάρ με το οποίο μπορείτε να παίξετε για ένα πιο σέξι ή πιο σοφό αποτέλεσμα.
guid
stringhttps://dev.divasboudoir.com/el/solina-plus-size-forema-mayro/drch7452.htm
highlights
string<ul> <li><strong>Τολμηρός συνδυασμός</strong> wetlook και ελαστικής δαντέλας</li> <li><strong>Διαμορφώνει τη σιλουέτα</strong> με απαλότητα και άνεση</li> <li><strong>Μεγάλη λαιμόκοψη</strong> μπροστά και πίσω για εντυπωσιακό αποτέλεσμα</li> <li><strong>Ρυθμιζόμενο άνοιγμα με φερμουάρ</strong> για παιχνίδι μεταξύ σέξι και σοφού</li> <li><strong>Σχεδιασμός από δύο υλικά</strong> με κομψά κοντά μανίκια</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringΈνα φόρεμα από δύο υλικά σε μεγάλα μεγέθη, ένας όμορφος συνδυασμός στυλ για μια εξαιρετικά σέξι εμφάνιση. Διατίθεται σε μεγέθη έως 64.
keywords
string
title
stringSolina plus size φόρεμα
seotitle
stringSolina plus size φόρεμα
seouri
stringsolina-plus-size-forema-mayro
specifications
string<ul> <li><strong>Υλικά:</strong> Wetlook ύφασμα και ελαστική δαντέλα</li> <li><strong>Σχεδιασμός:</strong> Δι-υλικό με μικρά μανίκια</li> <li><strong>Λαιμόκοψη</strong>: Μεγάλη λαιμόκοψη μπροστά και πίσω</li> <li><strong>Κλείσιμο:</strong> Μεγάλο αρθρωτό άνοιγμα με φερμουάρ</li> <li><strong>Κοπή:</strong> Ρυθμιζόμενο για να σμιλεύει τη σιλουέτα</li> <li><strong>Στυλ:</strong> Εξαιρετικά σέξι με εκλεπτυσμένο wetlook εφέ</li> </ul>
stylingtips
string<p>Το φόρεμα Solina στέκεται από μόνο του για να δημιουργήσει μια εξαιρετικά σέξι εμφάνιση χάρη στον τολμηρό σχεδιασμό του από δύο υλικά. Παίξτε με το φερμουάρ για να ρυθμίσετε την ένταση της εμφάνισής σας ανάλογα με τη διάθεσή σας.</p> <p>Η αντίθεση του wetlook και της δαντέλας λειτουργεί τέλεια με εκλεπτυσμένα αξεσουάρ. Για μια λαμπερή βραδινή έξοδο, αφήστε το φερμουάρ ελαφρώς ανοιχτό για να αποκαλύψετε τη φυσική σας τόλμη. Ολοκληρώστε την εμφάνισή σας με τα <a href="https://www.divasboudoir.com/el/sexi-syn-megethos-stolh/">σέξι φορέματά</a> μας για ποικιλία, ενισχύστε τα πόδια σας με τις κομψές <a href="https://www.divasboudoir.com/el/kaltses-megaloy-megethoys/">κάλτσες</a> μας ή εξερευνήστε τα <a href="https://www.divasboudoir.com/el/sexi-foremata-syn-megethos/">σέξι σύνολά</a> μας για μια ολοκληρωμένη γκαρνταρόμπα.</p>
summary
stringΈνα φόρεμα από δύο υλικά σε μεγάλα μεγέθη, ένας όμορφος συνδυασμός στυλ για μια εξαιρετικά σέξι εμφάνιση. Διατίθεται σε μεγέθη έως 64.
title
stringΦόρεμα Solina
usageinstructions
string<p>Το φόρεμα Solina έχει σχεδιαστεί για να <strong>αποκαλύπτει τον αισθησιασμό σας</strong> με ευελιξία. Το μεγάλο άνοιγμα με φερμουάρ σάς επιτρέπει να προσαρμόζετε την εμφάνισή σας ανάλογα με την περίσταση: κλειστό για ένα πιο σοφό αποτέλεσμα, ανοιχτό για μια εξαιρετικά σέξι εμφάνιση. Τα <strong>ελαστικά υφάσματα</strong> εξασφαλίζουν <strong>βέλτιστη άνεση</strong>, ακόμη και σε μακρινές βραδιές.</p> <p>Ο συνδυασμός wetlook και δαντέλας δημιουργεί μια εντυπωσιακή αντίθεση που <strong>τονίζει</strong> φυσικά <strong>τις καμπύλες σας</strong>. Το <strong>κόψιμο προσαρμόζεται σε όλα τα σχήματα σώματος</strong>, ώστε να δείχνετε <strong> φυσικά κομψή</strong> σε κάθε περίσταση.</p>
en
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Hand wash in lukewarm water (30&deg;C maximum)</li> <li>Use a mild detergent to preserve the wetlook fabric</li> <li>Handle zipper with care</li> <li>Dry flat, away from direct light</li> <li>Do not iron directly on wetlook parts</li> </ul>
description
stringThis Solina dress features a daring blend of wetlook fabric and elastic lace to gently sculpt your figure.<br /><br />Large d&eacute;collet&eacute; front and back, small sleeves and, above all, a large zip opening you can play with for a sexier or wiser effect.
guid
stringhttps://dev.divasboudoir.com/en/solina-plus-size-dress-black/drch7452.htm
highlights
string<ul> <li><strong>Bold mix of</strong> wetlook and elastic lace</li> <li><strong>Sculpts the figure</strong> with softness and comfort</li> <li><strong>Large</strong> front and back<strong>necklines</strong> for a striking effect</li> <li><strong>Adjustable zipper opening</strong> to play between sexy and wise</li> <li><strong>Two-material design</strong> with elegant short sleeves</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringPlus size bi-material dress, a beautiful combination of styles for an ultra sexy look. Available in sizes up to 64.
keywords
string
title
stringSolina plus size dress
seotitle
stringSolina plus size dress
seouri
stringsolina-plus-size-dress-black
specifications
string<ul> <li><strong>Materials:</strong> Wetlook fabric and elastic lace</li> <li><strong>Design:</strong> Bi-material with small sleeves</li> <li><strong>Necklines:</strong> Large front and back necklines</li> <li><strong>Closure:</strong> Large, modular zip opening</li> <li><strong>Cut:</strong> Adjustable for a figure-sculpting fit</li> <li><strong>Style:</strong> Ultra sexy with sophisticated wetlook effect</li> </ul>
stylingtips
string<p>The Solina dress stands on its own to create an ultra-sexy look, thanks to its daring two-material design. Play with the zipper to modulate the intensity of your look as you please.</p> <p>The contrast of wetlook and lace goes perfectly with sophisticated accessories. For a glamorous evening, leave the zipper slightly open to reveal your natural boldness. Complete your look with our <a href="https://www.divasboudoir.com/en/sexy-plus-size-outfit/">sexy dresses</a> for variety, enhance your legs with our elegant <a href="https://www.divasboudoir.com/en/socks-large-size/">stockings</a>, or explore our <a href="https://www.divasboudoir.com/en/sexys-plus-size-dresses/">sexy outfits</a> for a complete wardrobe.</p>
summary
stringPlus size bi-material dress, a beautiful combination of styles for an ultra sexy look. Available in sizes up to 64.
title
stringSolina dress
usageinstructions
string<p>The Solina dress is designed to <strong>reveal your sensuality</strong> with versatility. The large zipper opening lets you adapt your look to the occasion: closed for a wiser effect, open for an ultra-sexy look. <strong>Stretch fabrics</strong> guarantee <strong>optimum comfort</strong>, even on long evenings.</p> <p>The mix of wetlook and lace creates a striking contrast that naturally <strong>enhances your curves</strong>. This <strong>cut, which adapts to all body shapes</strong>, ensures <strong> natural elegance</strong> in all circumstances.</p>
es
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavar a mano con agua tibia (30&deg;C máximo)</li> <li>Utiliza un detergente suave para conservar el aspecto mojado del tejido</li> <li>Manipular la cremallera con cuidado</li> <li>Secar en plano, lejos de la luz directa</li> <li>No planchar directamente sobre las partes con efecto mojado</li> </ul>
description
stringEste vestido Solina es una atrevida mezcla de tejido wetlook y encaje elástico para esculpir suavemente tu figura.<br /><br />Tiene un gran escote delantero y trasero, mangas pequeñas y, sobre todo, una gran abertura con cremallera con la que puedes jugar para conseguir un efecto más sexy o más sabio.
guid
stringhttps://dev.divasboudoir.com/es/vestido-talla-grande-solina-negro/drch7452.htm
highlights
string<ul> <li><strong>Atrevida mezcla de</strong> wetlook y encaje elástico</li> <li><strong>Esculpe la figura</strong> con suavidad y comodidad</li> <li><strong>Grandes escotes</strong> delantero y trasero para un efecto llamativo</li> <li><strong>Abertura de cremallera ajustable</strong> para jugar entre sexy y prudente</li> <li><strong>Diseño bimateria</strong> con elegantes mangas cortas</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringUn vestido de talla grande de dos materiales, una bonita combinación de estilos para un look ultra sexy. Disponible en tallas hasta la 64.
keywords
string
title
stringVestido talla grande Solina
seotitle
stringVestido talla grande Solina
seouri
stringvestido-talla-grande-solina-negro
specifications
string<ul> <li><strong>Materiales:</strong> Tejido wetlook y encaje elástico</li> <li><strong>Diseño:</strong> Bi-material con pequeñas mangas</li> <li><strong>Escotes</strong>: Grandes escotes delantero y trasero</li> <li><strong>Cierre:</strong> Gran abertura con cremallera modular</li> <li><strong>Corte:</strong> Ajustable para esculpir la figura</li> <li><strong>Estilo</strong>: Ultra sexy con sofisticado efecto wetlook</li> </ul>
stylingtips
string<p>El vestido Solina se impone por sí solo para crear un look ultrasexy gracias a su atrevido diseño bimateria. Juega con el cierre de cremallera para modular la intensidad de tu look según tu estado de ánimo.</p> <p>El contraste de wetlook y encaje combina a la perfección con accesorios sofisticados. Para una salida nocturna glamurosa, deja la cremallera ligeramente abierta para revelar tu atrevimiento natural. Completa tu look con nuestros <a href="https://www.divasboudoir.com/es/ropa-sexy-de-tallas-grandes/">vestidos sexys</a> para variar, realza tus piernas con nuestras elegantes <a href="https://www.divasboudoir.com/es/medias-grandes/">medias</a> o explora nuestros <a href="https://www.divasboudoir.com/es/sexys-vestidos-talla-grande/">conjuntos sexys</a> para completar tu vestuario.</p>
summary
stringUn vestido de talla grande de dos materiales, una bonita combinación de estilos para un look ultra sexy. Disponible en tallas hasta la 64.
title
stringVestido Solina
usageinstructions
string<p>El vestido Solina está diseñado para <strong>revelar tu sensualidad</strong> con versatilidad. La gran abertura con cremallera te permite adaptar tu look según la ocasión: cerrado para un efecto más prudente, abierto para un look ultra sexy. <strong>Los tejidos elásticos</strong> garantizan <strong>un confort óptimo</strong>, incluso en las largas veladas.</p> <p>La mezcla de wetlook y encaje crea un llamativo contraste que <strong>realza</strong> naturalmente <strong>tus curvas</strong>. El <strong>corte se adapta a todas las formas del cuerpo</strong>, por lo que lucirás <strong> una elegancia natural</strong> en cualquier situación.</p>
fr
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavage &agrave; la main &agrave; l'eau ti&egrave;de (30&deg;C maximum)</li> <li>Utiliser une lessive douce pour pr&eacute;server le tissu wetlook</li> <li>Manipuler d&eacute;licatement la fermeture zipp&eacute;e</li> <li>S&eacute;chage &agrave; plat, &agrave; l'abri de la lumi&egrave;re directe</li> <li>Ne pas repasser directement sur les parties wetlook</li> </ul>
description
string<p>La robe Solina <strong>sublime vos courbes g&eacute;n&eacute;reuses</strong> avec son audacieux m&eacute;lange de tissu wetlook et dentelles &eacute;lastiques qui <strong>sculpte votre silhouette tout en douceur</strong>. Cette cr&eacute;ation bi-mati&egrave;re <strong>s'adapte &agrave; toutes les morphologies</strong> gr&acirc;ce aux <strong>tissus extensibles</strong> qui <strong>&eacute;pousent parfaitement vos formes</strong>.</p> <p>Les grands d&eacute;collet&eacute;s &agrave; l'avant et &agrave; l'arri&egrave;re cr&eacute;ent un effet visuel captivant qui r&eacute;v&egrave;le votre c&ocirc;t&eacute; le plus s&eacute;duisant. Les petites manches ajoutent une touche d'&eacute;l&eacute;gance raffin&eacute;e &agrave; l'ensemble.</p> <p>La grande ouverture zipp&eacute;e constitue l'atout majeur de cette robe : elle vous permet de jouer entre un look plus sexy ou plus sage selon vos envies et l'occasion.&nbsp;</p> <p>Cette <strong>coupe ajustable valorise</strong> chaque silhouette avec ses <strong>mati&egrave;res extensibles</strong> qui garantissent un <strong>confort optimal toute la soir&eacute;e</strong>. Les <strong>finitions soign&eacute;es</strong> de cette belle combinaison de styles cr&eacute;ent un look ultra sexy sophistiqu&eacute;.</p>
guid
stringhttps://dev.divasboudoir.com/fr/robe-bi-matiere-wetlook-dentelle-grande-taille/drch7452.htm
highlights
string<ul> <li><strong>M&eacute;lange audacieux</strong> wetlook et dentelles &eacute;lastiques</li> <li><strong>Sculpte la silhouette</strong> tout en douceur et confort</li> <li><strong>Grands d&eacute;collet&eacute;s</strong> avant et arri&egrave;re pour un effet saisissant</li> <li><strong>Ouverture zipp&eacute;e modulable</strong> pour jouer entre sexy et sage</li> <li><strong>Design bi-mati&egrave;re</strong> avec petites manches &eacute;l&eacute;gantes</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringRobe grande taille bi-matière, une belle combinaison de style pour un look ultra sexy. Et cela jusqu'à la taille 64.
keywords
string
title
stringRobe grande taille Solina
seotitle
stringRobe grande taille bi-matière wetlook avec ouverture zippée
seouri
stringrobe-bi-matiere-wetlook-dentelle-grande-taille
specifications
string<ul> <li><strong>Mati&egrave;res :</strong> Tissu wetlook et dentelles &eacute;lastiques</li> <li><strong>Design :</strong> Bi-mati&egrave;re avec petites manches</li> <li><strong>D&eacute;collet&eacute;s :</strong> Grands d&eacute;collet&eacute;s avant et arri&egrave;re</li> <li><strong>Fermeture :</strong> Grande ouverture zipp&eacute;e modulable</li> <li><strong>Coupe :</strong> Ajustable qui sculpte la silhouette</li> <li><strong>Style :</strong> Ultra sexy avec effet wetlook sophistiqu&eacute;</li> </ul>
stylingtips
string<p>La robe Solina se suffit &agrave; elle-m&ecirc;me pour cr&eacute;er un look ultra sexy gr&acirc;ce &agrave; son design bi-mati&egrave;re audacieux. Jouez avec la fermeture zipp&eacute;e pour moduler l'intensit&eacute; de votre look selon vos envies.</p> <p>Le contraste wetlook et dentelle s'accorde parfaitement avec des accessoires sophistiqu&eacute;s. Pour une soir&eacute;e glamour, laissez la zip l&eacute;g&egrave;rement ouverte pour r&eacute;v&eacute;ler votre audace naturelle. Compl&eacute;tez votre look avec nos&nbsp;<a href="https://www.divasboudoir.com/fr/tenue-sexy-grande-taille/">robes sexys</a> pour varier les plaisirs, sublimez vos jambes avec nos <a href="https://www.divasboudoir.com/fr/bas-grande-taille/">bas</a> &eacute;l&eacute;gants, ou explorez nos <a href="https://www.divasboudoir.com/fr/robes-sexys-grande-taille/">tenues sexys</a> pour une garde-robe compl&egrave;te.</p>
summary
string<p>D&eacute;couvrez la robe Solina, un audacieux m&eacute;lange de tissu wetlook et dentelles &eacute;lastiques qui sculpte votre silhouette tout en douceur.</p> <p>Avec ses grands d&eacute;collet&eacute;s avant et arri&egrave;re, ses petites manches et sa grande ouverture zipp&eacute;e modulable, cette cr&eacute;ation bi-mati&egrave;re offre un look ultra sexy.</p>
title
stringRobe Solina : Audacieux Mélange Wetlook et Dentelle Élastique
usageinstructions
string<p>La robe Solina est con&ccedil;ue pour <strong>r&eacute;v&eacute;ler votre sensualit&eacute;</strong> avec polyvalence. La grande ouverture zipp&eacute;e vous permet d'adapter votre look selon l'occasion : ferm&eacute;e pour un effet plus sage, ouverte pour un rendu ultra sexy. Les <strong>mati&egrave;res extensibles</strong> garantissent un <strong>confort optimal</strong> m&ecirc;me lors de longues soir&eacute;es.</p> <p>Le m&eacute;lange wetlook et dentelle cr&eacute;e un contraste saisissant qui&nbsp;<strong>sublime vos rondeurs</strong> naturellement. Cette&nbsp;<strong>coupe qui s'adapte &agrave; toutes les morphologies</strong> vous assure une <strong>&eacute;l&eacute;gance naturelle</strong> en toutes circonstances.</p>
it
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavare a mano in acqua tiepida (massimo 30&deg;C)</li> <li>Utilizzare un detergente delicato per preservare il tessuto wetlook</li> <li>Maneggiare la cerniera con cura</li> <li>Asciugare in piano, al riparo dalla luce diretta</li> <li>Non stirare direttamente sulle parti wetlook</li> </ul>
description
stringQuesto abito Solina è un audace mix di tessuto wetlook e pizzo elastico che scolpisce delicatamente la figura.<br /><br />Ha un'ampia scollatura anteriore e posteriore, piccole maniche e, soprattutto, un'ampia apertura con zip con cui si può giocare per un effetto più sexy o più saggio.
guid
stringhttps://dev.divasboudoir.com/it/abito-solina-taglia-grande-nero/drch7452.htm
highlights
string<ul> <li><strong>Audace mix di</strong> pizzo wetlook ed elastico</li> <li><strong>Scolpisce la figura</strong> con morbidezza e comfort</li> <li><strong>Ampie scollature</strong> sul davanti e sulla schiena per un effetto sorprendente</li> <li><strong>Apertura con zip regolabile</strong> per giocare tra il sexy e il saggio</li> <li><strong>Design a due materiali</strong> con eleganti maniche corte</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringAbito a due materiali per taglie grandi, una bella combinazione di stili per un look ultra-sexy. Disponibile nelle taglie fino alla 64.
keywords
string
title
stringAbito Solina taglia grande
seotitle
stringAbito Solina taglia grande
seouri
stringabito-solina-taglia-grande-nero
specifications
string<ul> <li><strong>Materiali:</strong> Tessuto wetlook e pizzo elastico</li> <li><strong>Design:</strong> Bi-materiale con piccole maniche</li> <li><strong>Scollature</strong>: ampie scollature anteriori e posteriori</li> <li><strong>Chiusura:</strong> ampia apertura con zip modulare</li> <li><strong>Taglio:</strong> Regolabile per scolpire la figura</li> <li><strong>Stile:</strong> Ultra sexy con sofisticato effetto wetlook</li> </ul>
stylingtips
string<p>L'abito Solina è in grado di creare un look ultra-sexy grazie al suo audace design a due materiali. Giocate con la chiusura a zip per modulare l'intensità del vostro look in base al vostro umore.</p> <p>Il contrasto tra wetlook e pizzo si abbina perfettamente ad accessori sofisticati. Per una serata glamour, lasciate la cerniera leggermente aperta per rivelare la vostra naturale audacia. Completate il vostro look con i nostri <a href="https://www.divasboudoir.com/it/vestito-sexy-plus-size/">abiti sexy</a> per variare, valorizzate le vostre gambe con le nostre <a href="https://www.divasboudoir.com/it/calze-di-grandi-dimensioni/">calze</a> eleganti o esplorate i nostri <a href="https://www.divasboudoir.com/it/abiti-sexys-taglia-grande/">completi sexy</a> per un guardaroba completo.</p>
summary
stringAbito a due materiali per taglie grandi, una bella combinazione di stili per un look ultra-sexy. Disponibile nelle taglie fino alla 64.
title
stringAbito Solina
usageinstructions
string<p>L'abito Solina è progettato per <strong>rivelare la vostra sensualità</strong> con versatilità. L'ampia apertura con zip consente di adattare il look all'occasione: chiuso per un effetto più saggio, aperto per un look ultra-sexy. I <strong>tessuti elasticizzati</strong> garantiscono <strong>un comfort ottimale</strong>, anche nelle lunghe serate.</p> <p>Il mix di wetlook e pizzo crea un contrasto sorprendente che <strong>esalta</strong> naturalmente <strong>le vostre curve</strong>. Il <strong>taglio si adatta a tutte le forme del corpo</strong>, per un'<strong>eleganza naturale</strong> in ogni situazione.</p>
nl
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Handwas in lauw water (maximaal 30&deg;C)</li> <li>Gebruik een mild wasmiddel om de wetlook stof te behouden</li> <li>Behandel de rits voorzichtig</li> <li>Plat drogen, niet in direct licht</li> <li>Niet rechtstreeks op de wetlook delen strijken</li> </ul>
description
stringDeze Solina jurk is een gedurfde mix van wetlook stof en elastisch kant om je figuur zachtjes te modelleren.<br /><br />Het heeft een grote halsuitsnijding voor en achter, kleine mouwen en vooral een grote ritsopening waarmee je kunt spelen voor een sexier of wijzer effect.
guid
stringhttps://dev.divasboudoir.com/nl/solina-jurk-groote-maat-zwart/drch7452.htm
highlights
string<ul> <li><strong>Gedurfde mix van</strong> wetlook en elastisch kant</li> <li><strong>Vormt het figuur</strong> met zachtheid en comfort</li> <li><strong>Grote halslijnen</strong> voor en achter voor een opvallend effect</li> <li><strong>Verstelbare ritsopening</strong> om te spelen tussen sexy en wijs</li> <li><strong>Tweematerialenontwerp</strong> met elegante korte mouwen</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringEen jurk van twee materialen voor groote maten, een prachtige combinatie van stijlen voor een ultra-sexy look. Verkrijgbaar in maten tot 64.
keywords
string
title
stringSolina jurk groote maat
seotitle
stringSolina jurk groote maat
seouri
stringsolina-jurk-groote-maat-zwart
specifications
string<ul> <li><strong>Materialen:</strong> Wetlook stof en elastisch kant</li> <li><strong>Ontwerp:</strong> Bi-materiaal met kleine mouwen</li> <li><strong>Halslijnen</strong>: Grote halslijnen voor en achter</li> <li><strong>Sluiting:</strong> Grote modulaire ritsopening</li> <li><strong>Snit:</strong> Verstelbaar om het figuur te modelleren</li> <li><strong>Stijl:</strong> Ultrasexy met geraffineerd wetlook effect</li> </ul>
stylingtips
string<p>De Solina jurk staat op zichzelf en creëert een ultra-sexy look dankzij het gedurfde ontwerp van twee materialen. Speel met de ritssluiting om de intensiteit van je look aan te passen aan je stemming.</p> <p>Het contrast van wetlook en kant werkt perfect met geraffineerde accessoires. Voor een glamoureuze avond uit laat je de ritssluiting iets open om je natuurlijke brutaliteit te onthullen. Maak je look compleet met onze <a href="https://www.divasboudoir.com/nl/plus-size-sexy-kleding/">sexy jurkjes</a> voor de afwisseling, verfraai je benen met onze elegante <a href="https://www.divasboudoir.com/nl/grote-maat-kousen/">kousen</a>, of ontdek onze <a href="https://www.divasboudoir.com/nl/sexys-jurken-grote-maat/">sexy outfits</a> voor een complete garderobe.</p>
summary
stringEen jurk van twee materialen voor groote maten, een prachtige combinatie van stijlen voor een ultra-sexy look. Verkrijgbaar in maten tot 64.
title
stringSolina jurk
usageinstructions
string<p>De Solina jurk is ontworpen om <strong>je sensualiteit te onthullen</strong> met veelzijdigheid. Dankzij de grote ritsopening kun je je look aanpassen aan de gelegenheid: gesloten voor een wijzer effect, open voor een ultra-sexy look. De <strong>stretchstoffen</strong> zorgen voor <strong>optimaal comfort</strong>, zelfs op lange avonden.</p> <p>De mix van wetlook en kant zorgt voor een opvallend contrast dat <strong>je rondingen</strong> op natuurlijke wijze <strong>benadrukt</strong>. De <strong>snit past zich aan alle lichaamsvormen</strong> aan, zodat je er in elke situatie <strong> natuurlijk elegant</strong> uitziet.</p>
pt
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavar à mão em água tépida (30&deg;C no máximo)</li> <li>Utilizar um detergente suave para preservar o tecido de aspeto húmido</li> <li>Manusear o fecho de correr com cuidado</li> <li>Secar em local plano, longe da luz direta</li> <li>Não passar a ferro diretamente sobre as peças wetlook</li> </ul>
description
stringEste vestido Solina é uma mistura ousada de tecido wetlook e renda elástica para esculpir suavemente a sua figura.<br /><br />Tem um grande decote à frente e atrás, mangas pequenas e, acima de tudo, uma grande abertura com fecho de correr com a qual pode brincar para um efeito mais sexy ou mais sensato.
guid
stringhttps://dev.divasboudoir.com/pt/vestido-solina-plus-size-preto/drch7452.htm
highlights
string<ul> <li>Mistura<strong>arrojada de</strong> wetlook e renda elástica</li> <li><strong>Esculpe a figura</strong> com suavidade e conforto</li> <li><strong>Grandes decotes</strong> à frente e atrás para um efeito marcante</li> <li><strong>Abertura com fecho de correr ajustável</strong> para jogar entre o sexy e o sensato</li> <li><strong>Design bicolor</strong> com elegantes mangas curtas</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringUm vestido plus size de dois materiais, uma bela combinação de estilos para um look ultra-sexy. Disponível em tamanhos até 64.
keywords
string
title
stringVestido Solina plus size
seotitle
stringVestido Solina plus size
seouri
stringvestido-solina-plus-size-preto
specifications
string<ul> <li><strong>Materiais:</strong> Tecido Wetlook e renda elástica</li> <li><strong>Design:</strong> Bi-material com mangas pequenas</li> <li><strong>Decotes</strong>: Grandes decotes à frente e nas costas</li> <li><strong>Fecho:</strong> Grande abertura modular com fecho de correr</li> <li><strong>Corte:</strong> Ajustável para esculpir a figura</li> <li><strong>Estilo:</strong> Ultra sexy com um sofisticado efeito wetlook</li> </ul>
stylingtips
string<p>O vestido Solina é autónomo para criar um look ultra-sexy graças ao seu design ousado em dois materiais. Use o fecho de correr para modular a intensidade do seu look de acordo com o seu estado de espírito.</p> <p>O contraste entre o wetlook e a renda funciona na perfeição com acessórios sofisticados. Para uma saída à noite glamorosa, deixe o fecho ligeiramente aberto para revelar a sua ousadia natural. Complete o seu look com os nossos <a href="https://www.divasboudoir.com/pt/roupa-sexy-plus-size/">vestidos sensuais</a> para variar, realce as suas pernas com as nossas <a href="https://www.divasboudoir.com/pt/meias-de-tamanho-grande/">meias</a> elegantes ou explore os nossos <a href="https://www.divasboudoir.com/pt/vestidos-sexys-plus-size/">conjuntos sensuais</a> para um guarda-roupa completo.</p>
summary
stringUm vestido plus size de dois materiais, uma bela combinação de estilos para um look ultra-sexy. Disponível em tamanhos até 64.
title
stringVestido Solina
usageinstructions
string<p>O vestido Solina foi concebido para <strong>revelar a sua sensualidade</strong> com versatilidade. O grande fecho de correr permite-lhe adaptar o seu look em função da ocasião: fechado para um efeito mais sensato, aberto para um look ultra-sexy. <strong>Os tecidos elásticos</strong> garantem <strong>um conforto ótimo</strong>, mesmo em noites longas.</p> <p>A mistura de wetlook e renda cria um contraste marcante que <strong>realça</strong> naturalmente <strong>as suas curvas</strong>. O <strong>corte adapta-se a todas as formas do corpo</strong>, para que fique <strong> naturalmente elegante</strong> em qualquer situação.</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
string27169761051 kleid
netweight
string
nextshipment
stringtomorrow
ordered
number53
orderidx
number0
origin
string
originalsize
string
packaging
string
productshipment
stringauto
productuid
stringDF4E0A50-1DD4-43B2-AE06B15E3F0E1C12
promountil
string
rating
stringnone
recorduid
stringDF4E0A50-1DD4-43B2-AE06B15E3F0E1C12
reference
stringDRCH7452
related
string
reserved
string
returned
number0
returnsallowed
number1
section
stringcabaret
shipment
string4to6days
showbrand
number0
sizeinfos
Query
Template: /system/api/product/sizes.cfc:20
Execution Time: 1.63 ms
Record Count: 9
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,'2052,896,895,898,897,900,899,901,902') > 0
and product_variations.productuid = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12'
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
1895XL+intlsizeblackXL+XL+-19999990wplusskirtXLXL+48-5018-2022-2650-5250-5248-5054-5650-5248-50113-11896-102117-121
22052L+intlsizeblackL+L+-19999990wplusskirtXLL+42-4412-1416-1844-4644-4642-4448-5044-4642-4498-10582-85105-108
38972XL+intlsizeblack2XL+2XL+-19999990wplusskirt2XL2XL+52-5422-2426-3054-5654-5652-5458-6054-5652-54125-130109-114127-132
48993XL+intlsizeblack3XL+3XL+-19999990wplusskirt3XL3XL+56-5826-2830-3258-6056-6056-5862-6458-6056-58137-142122-128138-144
59024XL+intlsizeblack4XL+4XL+000wplusskirt4XL4XL+60-6230-3234-3662-6462-6460-6266-6862-6460-52149-154135-140151-156
6896XLintlsizeblackXLXL-19999990wplusskirtXLXL44-4614-1618-2046-4846-4844-4650-5246-4844-46107-11291-95113-116
78982XLintlsizeblack2XL2XL-19999990wplusskirt2XL2XL50-5220-2224-2652-5452-5450-5256-5852-5450-52119-124103-108122-126
89003XLintlsizeblack3XL3XL-19999990wplusskirt3XL3XL54-5624-2628-3056-5856-5854-5660-6256-5854-56131-136115-121133-138
99014XLintlsizeblack4XL4XL000wplusskirt4XL4XL58-6028-3032-3460-6260-6258-6064-6660-6258-60143-148129-134145-150
sizeranges
stringplus
sizes
string2052,896,895,898,897,900,899,901,902
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: 10.2 ms
Record Count: 4
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select * from (
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12'
and product_variations.isactive = 1
and product_sizes.id_size = 2052
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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12'
and product_variations.isactive = 1
and product_sizes.id_size = 896
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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12'
and product_variations.isactive = 1
and product_sizes.id_size = 895
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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12'
and product_variations.isactive = 1
and product_sizes.id_size = 898
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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12'
and product_variations.isactive = 1
and product_sizes.id_size = 897
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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12'
and product_variations.isactive = 1
and product_sizes.id_size = 900
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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12'
and product_variations.isactive = 1
and product_sizes.id_size = 899
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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12'
and product_variations.isactive = 1
and product_sizes.id_size = 901
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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12'
and product_variations.isactive = 1
and product_sizes.id_size = 902
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
1DF4E0A50-1DD4-43B2-AE06B15E3F0E1C127155C762-0503-43FB-B41A8197991942282052black#000000XLL+42-4412-1416-1844-4644-4642-4448-5044-4642-44wskirtL+intlsize58.29170STOCK01000-103700271697610514024144404223-10all
2DF4E0A50-1DD4-43B2-AE06B15E3F0E1C129D9A689C-DB6A-4C4F-A40A7D9F6EBA6E5D898black#0000002XL2XL50-5220-2224-2652-5452-5450-5256-5852-5450-52wskirt2XLintlsize58.29170STOCK01000-11900271697610614024144404230-10all
3DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12DDE99E95-2508-4DC4-BB01BF07E98D1128900black#0000003XL3XL54-5624-2628-3056-5856-5854-5660-6256-5854-56wskirt3XLintlsize58.29170STOCK01000-10700271697610714024144404247-10all
4DF4E0A50-1DD4-43B2-AE06B15E3F0E1C1210543EC6-9B07-441F-93FEC0E6F0175964901black#0000004XL4XL58-6028-3032-3460-6260-6258-6064-6660-6258-60wskirt4XLintlsize58.29170STOCK010000090027169761081402414440425400all
subcategory
stringall
supplier
number-1
supplierreference
string27169761051
tags
string
themes
stringdark
totalvariations
string
type
stringdefault
unitprice
number58.2917
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 22.7 ms
Record Count: 9
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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12' 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12' 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12' 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12' 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12' 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12' 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12'
and product_variations.isactive = 1
and product_sizes.id_size = 2052
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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12' 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12' 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12' 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12' 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12' 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12' 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12'
and product_variations.isactive = 1
and product_sizes.id_size = 896
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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12' 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12' 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12' 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12' 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12' 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12' 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12'
and product_variations.isactive = 1
and product_sizes.id_size = 895
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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12' 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12' 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12' 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12' 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12' 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12' 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12'
and product_variations.isactive = 1
and product_sizes.id_size = 898
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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12' 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12' 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12' 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12' 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12' 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12' 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12'
and product_variations.isactive = 1
and product_sizes.id_size = 897
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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12' 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12' 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12' 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12' 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12' 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12' 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12'
and product_variations.isactive = 1
and product_sizes.id_size = 900
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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12' 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12' 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12' 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12' 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12' 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12' 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12'
and product_variations.isactive = 1
and product_sizes.id_size = 899
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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12' 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12' 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12' 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12' 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12' 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12' 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12'
and product_variations.isactive = 1
and product_sizes.id_size = 901
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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12' 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12' 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12' 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12' 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12' 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12' 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 = 'DF4E0A50-1DD4-43B2-AE06B15E3F0E1C12'
and product_variations.isactive = 1
and product_sizes.id_size = 902
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
17155C762-0503-43FB-B41A8197991942282052black#000000XLL+42-4412-1416-1844-4644-4642-4448-5044-4642-44wskirtL+intlsize58.29170STOCK01000-103700271697610514024144404223-10-10-10058.2917all
27155C762-0503-43FB-B41A819799194228895black#000000XLXL+48-5018-2022-2650-5250-5248-5054-5650-5248-50wskirtXL+intlsize58.29170STOCK01000-103700271697610514024144404223-10-10-10058.2917all
39D9A689C-DB6A-4C4F-A40A7D9F6EBA6E5D897black#0000002XL2XL+52-5422-2426-3054-5654-5652-5458-6054-5652-54wskirt2XL+intlsize58.29170STOCK01000-11900271697610614024144404230-10-10-10058.2917all
4DDE99E95-2508-4DC4-BB01BF07E98D1128899black#0000003XL3XL+56-5826-2830-3258-6056-6056-5862-6458-6056-58wskirt3XL+intlsize58.29170STOCK01000-10700271697610714024144404247-10-10-10058.2917all
510543EC6-9B07-441F-93FEC0E6F0175964902black#0000004XL4XL+60-6230-3234-3662-6462-6460-6266-6862-6460-52wskirt4XL+intlsize58.29170STOCK01000009002716976108140241444042540000-10058.2917all
67155C762-0503-43FB-B41A819799194228896black#000000XLXL44-4614-1618-2046-4846-4844-4650-5246-4844-46wskirtXLintlsize58.29170STOCK01000-103700271697610514024144404223-10-10-10058.2917all
79D9A689C-DB6A-4C4F-A40A7D9F6EBA6E5D898black#0000002XL2XL50-5220-2224-2652-5452-5450-5256-5852-5450-52wskirt2XLintlsize58.29170STOCK01000-11900271697610614024144404230-10-10-10058.2917all
8DDE99E95-2508-4DC4-BB01BF07E98D1128900black#0000003XL3XL54-5624-2628-3056-5856-5854-5660-6256-5854-56wskirt3XLintlsize58.29170STOCK01000-10700271697610714024144404247-10-10-10058.2917all
910543EC6-9B07-441F-93FEC0E6F0175964901black#0000004XL4XL58-6028-3032-3460-6260-6258-6064-6660-6258-60wskirt4XLintlsize58.29170STOCK01000009002716976108140241444042540000-10058.2917all
vatrate
number20
warehouse
string