Mijn mand

❌
Totaal aantal items
Winkelmand bekijken
Menu
Maten bekijken
Vinyl jurk met lange mouwen
Dubbelklikken om te vergroten
SKU: CDBU9935
Vinyl jurk met lange mouwen
Voorraad:
Diane Elastische Vinyl Jurk - Flatterende Rater Snit & Alle Modologieën
Maat:

Weet je niet zeker welke maat je moet kiezen? Raadpleeg onze maattabel

Kleur:
Hoeveelheid:
44.95 €
Goed advies
via chat, facebook of e-mail
Gratis retourneren
binnen 15 dagen *

Diane grote maat elastische vinyl jurk - Flatterende skater snit & alle morfologieën

Productomschrijving

Verbeter je figuur met de Diane-jurk van stretchvinyl, een veelzijdig stuk dat zich aanpast aan alle lichaamsvormen. De originele brede kraag en flatterende skater snit laten je rondingen zien met elegantie en comfort. Perfect voor een speciale avond of een gewaagde alledaagse look.

Details die het verschil maken:

  • Geschikt voor alle lichaamstypes: Gesneden om elk figuur te flatteren, van de slankste tot de meest voluptueuze.
  • Comfortabel elastisch vinyl: Past bij je figuur zonder het te beperken, voor totale bewegingsvrijheid.
  • Brede originele kraag: Voegt een vleugje verfijning en originaliteit toe aan de jurk.
  • Flatterende Skater Cut: Laat je taille zien en verbergt kleine imperfecties.
  • Lange mouwen: Elegantie en comfort gegarandeerd, ongeacht het seizoen.
  • Opening met rits aan de achterkant: Makkelijk aan te trekken en perfecte ondersteuning.

Waarom voor deze jurk kiezen?

  • Verbetert je figuur, ongeacht je lichaamsbouw.
  • Optimaal comfort dankzij elastisch vinyl.
  • De unieke, elegante stijl zal je doen opvallen.
  • Perfect voor een speciale avond of een gedurfde alledaagse look.
  • Makkelijk te combineren om verschillende looks te creëren.

Technische details

Beschikbaar maten

Beschikbaar van XL tot 3XL

Beschikbaar kleur

Zwart

Samenstelling

Polyurethaan 25 %
Polyester 70 %
Elastaan 5 %

Maattabel

Controleer de juiste maat voor jou

Internationale
  • Borst
  • Maat
  • Heupen
XL
  • 104-108
  • 80-86
  • 106-110
2XL
  • 108-112
  • 86-92
  • 110-114
3XL
  • 112-114
  • 92-98
  • 114-118
To Top
Winkelmand bekijken
Artikelen
Totaal aantal items
Struct
Entries: 108
actions
Array
available
number-1
brand
stringsoisbelle
brandcode
stringswta
branding
stringdivasboudoir,smboudoir
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
stringSois Belle
breasts
stringna
careinstructions
string
categories
stringdivasboudoir.cabaret.dresses.all
category
stringdresses
categorygender
stringf
categorymediadatas
Struct
adult
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string615
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/cabaret/dresses1.jpg
type
stringimg
width
string1336
divasboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
fetishboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
latexboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
legsboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
lustboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
private
Struct
height
string1016
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/private/default.jpg
type
stringimg
width
string703
smboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
categorysizerange
stringauto
colorinfos
Query
Template: /system/api/product/colors.cfc:13
Execution Time: 0.734 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 = 'DAA488AA-0EA1-4E8A-A8F5236515B22111'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1blackcolorblakblackblack#000000-12
colorrange
stringblack
colors
stringblack
colortype
stringcolor
comments
string
compositions
Struct
Entries: 13
coton
string
elastane
string5
free
string
leather
string
lycra
string
metal
string
nylon
string
polyamide
string
polyester
string70
polyurethane
string25
silk
string
spandex
string
viscose
string
datecreated
Date Time (Europe/Paris)
{ts '2025-03-04 18:48:20'}
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
booleanfalse
hascolorinfos
booleantrue
hascompositions
booleantrue
hasdescription
booleantrue
hasdimensions
booleanfalse
hasmaterials
booleanfalse
hasotherspecifications
booleanfalse
haspromo
number0
hasshortdescription
booleantrue
hassizeinfos
booleantrue
hasspecifications
booleanfalse
hasstockinfos
booleanfalse
hasstylingtips
booleanfalse
hasusageinstructions
booleanfalse
hasvariations
booleantrue
import
string
inpromo
number0
instockvariations
string
isactive
number1
iscustommade
number0
isdivasize
number0
isfirstprice
number0
isfixedprice
number0
ishot
number0
isnew
number0
isonline
number0
isoutletprice
number0
itemprice
number37.4583
itempromo
string
key
string2114500sdrt-36bk
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-10-22 18:41:51'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.637 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','nl')
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('daa488aa-0ea1-4e8a-a8f5236515b22111',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','nl')
and product_categories.language in ('all','nl')
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 <> 'CDBU9935'
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
string1964
isprivate
string0
rating
stringall
src
string/photobank/products/swta/cdbu9935/31928243.jpg
type
stringimg
width
string1359
back
Struct
height
string1964
isprivate
string0
rating
stringall
src
string/photobank/products/swta/cdbu9935/31928201.jpg
type
stringimg
width
string1359
default
Struct
height
string1661
isprivate
string0
rating
stringall
src
string/photobank/products/swta/cdbu9935/31928240.jpg
type
stringimg
width
string1149
variations
Struct
colors
Struct
black
Struct
height
string1964
isprivate
string0
rating
stringall
src
string/photobank/products/swta/cdbu9935/31928243.jpg
type
stringimg
width
string1359
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
description
string<div> <p class="text-base">Betonen Sie Ihre Silhouette mit dem Kleid Diane aus elastischem Vinyl, einem vielseitigen Kleidungsstück, das sich jeder Körperform anpasst. Der breite, originelle Kragen und der schmeichelhafte Patinaschnitt betonen Ihre Kurven auf elegante und bequeme Weise. Perfekt für einen besonderen Abend oder einen gewagten Alltagslook.</p> <p class="text-base"><strong>Details, die den Unterschied ausmachen :</strong></p> <ul> <li><strong>Für alle Körperformen geeignet:</strong> Der Schnitt ist so konzipiert, dass er jeder Figur schmeichelt, von der zierlichsten bis zur üppigsten.</li> <li><strong>Bequemes, elastisches Vinyl:</strong> Passt sich Ihren Formen an, ohne sie einzuschränken, und bietet Ihnen so absolute Bewegungsfreiheit.</li> <li><strong>Breiter Originalkragen:</strong> Verleiht dem Kleid einen Hauch von Raffinesse und Originalität.</li> <li><strong>Flacher Patinaschnitt:</strong> Betont Ihre Taille und kaschiert kleine Unvollkommenheiten.</li> <li><strong>Lange Ärmel:</strong> Elegant und bequem, egal zu welcher Jahreszeit.</li> <li><strong>Reißverschluss hinten:</strong> Erleichtert das Anziehen und sorgt für einen perfekten Sitz.</li> </ul> <p class="text-base"><strong>Warum Sie dieses Kleid wählen sollten:</strong></p> <ul> <li>Betont Ihre Silhouette unabhängig von Ihrem Körperbau.</li> <li>Bietet dank des elastischen Vinyls optimalen Tragekomfort.</li> <li>Mit seinem einzigartigen und eleganten Stil werden Sie sich von der Masse abheben.</li> <li>Perfekt für einen besonderen Abend oder einen gewagten Look im Alltag.</li> <li>Leicht mit Accessoires zu versehen, um verschiedene Looks zu kreieren.</li> </ul> </div>
guid
stringhttps://dev.divasboudoir.com/de/diane-kleid-in-grossen-grossen-aus-elastischem-vinyl--flacher-patinierter-schnitt-amp;-alle-morphologien-schwarz/cdbu9935.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringVerlieben Sie sich in das Diane-Kleid aus Vinyl! Schmeichelnder Patinaschnitt und optimaler Tragekomfort für alle Körperformen. Eleganz und Originalität sind garantiert. Tipps :
keywords
string
title
stringKleid Große Größen Diane Vinyl - Fetischistischer Patinaschnitt
seotitle
stringDiane-Kleid in großen Größen aus elastischem Vinyl - Flacher patinierter Schnitt & alle Morphologien
seouri
stringdiane-kleid-in-grossen-grossen-aus-elastischem-vinyl--flacher-patinierter-schnitt-amp;-alle-morphologien-schwarz
specifications
string
stylingtips
string
summary
string<div>Diane Vinyl Elastisches Kleid - Flacher patinierter Schnitt &amp; Alle Morphologien</div> <div></div> <div></div>
title
stringVinylkleid mit langen Ärmeln
usageinstructions
string
el
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Αναδείξτε τη σιλουέτα σας με το φόρεμα Diane από ελαστικό βινύλιο, ένα ευέλικτο κομμάτι που προσαρμόζεται σε όλα τα σχήματα του σώματος. Ο πρωτότυπος φαρδύς γιακάς του και το κολακευτικό skater κόψιμο θα αναδείξουν τις καμπύλες σας με κομψότητα και άνεση. Ιδανικό για μια ξεχωριστή βραδιά ή μια τολμηρή καθημερινή εμφάνιση.</p> <p class="text-base"><strong>Λεπτομέρειες που κάνουν τη διαφορά:</strong></p> <ul> <li><strong>Κατάλληλο για όλους τους σωματότυπους:</strong> Κομμένο για να κολακεύει κάθε σιλουέτα, από την πιο λεπτή έως την πιο πληθωρική.</li> <li><strong>Άνετο ελαστικό βινύλιο:</strong> Ταιριάζει στο σχήμα σας χωρίς να το περιορίζει, για απόλυτη ελευθερία κινήσεων.</li> <li><strong>Ευρύς πρωτότυπος γιακάς</strong>: Προσθέτει μια πινελιά εκλέπτυνσης και πρωτοτυπίας στο φόρεμα.</li> <li><strong>Κολακευτικό κόψιμο Skater:</strong> Αναδεικνύει τη μέση σας και κρύβει τις μικρές ατέλειες.</li> <li><strong>Μακριά μανίκια</strong>: Η κομψότητα και η άνεση είναι εγγυημένες, ανεξαρτήτως εποχής.</li> <li><strong>Άνοιγμα με φερμουάρ στην πλάτη:</strong> Το καθιστά εύκολο να φορεθεί και εξασφαλίζει τέλεια στήριξη.</li> </ul> <p class="text-base"><strong>Γιατί να επιλέξετε αυτό το φόρεμα :</strong></p> <ul> <li>Ενισχύει τη σιλουέτα σας ανεξάρτητα από τη μορφολογία σας.</li> <li>Βέλτιστη άνεση χάρη στο ελαστικό βινύλιο.</li> <li>Το μοναδικό, κομψό στυλ του θα σας κάνει να ξεχωρίσετε από το πλήθος.</li> <li>Ιδανικό για μια ξεχωριστή βραδιά ή μια τολμηρή καθημερινή εμφάνιση.</li> <li>Εύκολα αξεσουάρ για να δημιουργήσετε μια ποικιλία εμφανίσεων.</li> </ul> </div>
guid
stringhttps://dev.divasboudoir.com/el/diane-megalo-elastiko-forema-apo-vinylio--kolakeytiko-skater-kopsimo-amp;-oles-oi-morfologies-mayro/cdbu9935.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringΛάτρεψε το φόρεμα Diane από βινύλιο! Κολακευτικό skater κόψιμο και βέλτιστη άνεση για όλα τα σχήματα σώματος. Εγγυημένη κομψότητα και πρωτοτυπία. Συμβουλές :
keywords
string
title
stringDiane Vinyle maxi φόρεμα - Fetish skater cut
seotitle
stringDiane μεγάλο ελαστικό φόρεμα από βινύλιο - Κολακευτικό skater κόψιμο & όλες οι μορφολογίες
seouri
stringdiane-megalo-elastiko-forema-apo-vinylio--kolakeytiko-skater-kopsimo-amp;-oles-oi-morfologies-mayro
specifications
string
stylingtips
string
summary
string<div>Diane Φόρεμα από ελαστικό βινύλιο - κολακευτικό κόψιμο Skater &amp; όλες οι μορφολογίες</div> <div></div> <div></div>
title
stringΦόρεμα από βινύλιο με μακριά μανίκια
usageinstructions
string
en
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Sublimate your silhouette with the Diane dress in elastic vinyl, a versatile piece that adapts to all body types. Its original wide collar and flattering skater cut will enhance your curves with elegance and comfort. Perfect for a special evening or a bold everyday look.</p> <p class="text-base"><strong>Details that make all the difference:</strong></p> <ul> <li><strong>Adapted to All Morphologies:</strong> Cut designed to flatter all silhouettes, from the slimmest to the most voluptuous.</li> <li><strong>Comfortable elastic vinyl:</strong> Fits your shape without constricting it, for total freedom of movement.</li> <li><strong>Original Wide Collar</strong>: Adds a touch of sophistication and originality to the dress.</li> <li><strong>Flattering skater cut:</strong> Highlights your waist and conceals small imperfections.</li> <li><strong>Long sleeves</strong>: Elegance and comfort guaranteed, whatever the season.</li> <li><strong>Back zipper opening:</strong> Makes it easy to put on and ensures perfect support.</li> </ul> <p class="text-base"><strong>Why choose this dress:</strong></p> <ul> <li>Enhances your figure, whatever your morphology.</li> <li>Optimal comfort thanks to elastic vinyl.</li> <li>Its unique, elegant style will make you stand out from the crowd.</li> <li>Perfect for a special evening or a bold everyday look.</li> <li>Easy to accessorize for a variety of looks.</li> </ul> </div>
guid
stringhttps://dev.divasboudoir.com/en/diane-plus-size-elastic-vinyl-dress--flattering-skater-cut-amp;-all-morphologies-black/cdbu9935.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringFall for the Diane dress in vinyl! Flattering skater cut and optimal comfort for all body types. Elegance and originality guaranteed. Advice :
keywords
string
title
stringDiane Vinyle plus size dress - Fetish skater cut
seotitle
stringDiane plus size Elastic Vinyl Dress - Flattering Skater Cut & All Morphologies
seouri
stringdiane-plus-size-elastic-vinyl-dress--flattering-skater-cut-amp;-all-morphologies-black
specifications
string
stylingtips
string
summary
string<div>Diane Elastic Vinyl Dress - Flattering Skater Cut &amp; All Morphologies</div> <div></div> <div></div>
title
stringVinyl dress with long sleeves
usageinstructions
string
es
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Realza tu figura con el vestido Diane de vinilo elástico, una pieza versátil que se adapta a todas las formas del cuerpo. Su original cuello ancho y su favorecedor corte skater lucirán tus curvas con elegancia y comodidad. Perfecto para una velada especial o un atrevido look de diario.</p> <p class="text-base"><strong>Detalles que marcan la diferencia:</strong></p> <ul> <li>Apto<strong>para todo tipo de cuerpos:</strong> Corte que favorece todas las figuras, desde las más delgadas hasta las más voluptuosas.</li> <li><strong>Cómodo vinilo elástico:</strong> Se ajusta a tu figura sin constreñirla, para una total libertad de movimientos.</li> <li><strong>Original cuello ancho</strong>: Añade un toque de sofisticación y originalidad al vestido.</li> <li><strong>Favorecedor corte skater:</strong> Muestra tu cintura y disimula las pequeñas imperfecciones.</li> <li><strong>Mangas largas</strong>: Elegancia y comodidad garantizadas, sea cual sea la estación del año.</li> <li><strong>Abertura trasera con cremallera:</strong> Facilita la colocación y garantiza una sujeción perfecta.</li> </ul> <p class="text-base"><strong>Por qué elegir este vestido :</strong></p> <ul> <li>Realza tu silueta sea cual sea tu morfología.</li> <li>Comodidad óptima gracias al vinilo elástico.</li> <li>Su estilo único y elegante te hará destacar entre la multitud.</li> <li>Perfecto para una velada especial o un look atrevido de diario.</li> <li>Fácil de combinar para crear diferentes looks.</li> </ul> </div>
guid
stringhttps://dev.divasboudoir.com/es/vestido-de-vinilo-elastico-talla-grande-diane--corte-skater-favorecedor-amp;-todas-las-morfologias-negro/cdbu9935.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string¡Enamórate del vestido Diane de vinilo! Corte skater favorecedor y comodidad óptima para todas las morfologías. Elegancia y originalidad garantizadas. Consejos :
keywords
string
title
stringVestido talla grande Diane Vinyle - Fetiche corte skater
seotitle
stringVestido de vinilo elástico talla grande Diane - Corte skater favorecedor & todas las morfologías
seouri
stringvestido-de-vinilo-elastico-talla-grande-diane--corte-skater-favorecedor-amp;-todas-las-morfologias-negro
specifications
string
stylingtips
string
summary
string<div>Vestido de vinilo elástico Diane - Corte skater favorecedor y todas las morfologías</div> <div></div> <div></div>
title
stringVestido de vinilo de manga larga
usageinstructions
string
fr
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Sublimez votre silhouette avec la robe Diane en vinyle &eacute;lastique, une pi&egrave;ce versatile qui s'adapte &agrave; toutes les morphologies. Son large col original et sa coupe patineuse flatteuse mettront en valeur vos courbes avec &eacute;l&eacute;gance et confort. Parfaite pour une soir&eacute;e sp&eacute;ciale ou un look audacieux au quotidien.</p> <p class="text-base"><strong>D&eacute;tails qui font la diff&eacute;rence :</strong></p> <ul> <li><strong>Adapt&eacute;e &agrave; Toutes les Morphologies :</strong> Coupe &eacute;tudi&eacute;e pour flatter toutes les silhouettes, des plus menues aux plus voluptueuses.</li> <li><strong>Vinyle &Eacute;lastique Confortable :</strong> &Eacute;pouse vos formes sans les contraindre, pour une libert&eacute; de mouvement totale.</li> <li><strong>Large Col Original :</strong> Apporte une touche de sophistication et d'originalit&eacute; &agrave; la robe.</li> <li><strong>Coupe Patineuse Flateuse :</strong> Met en valeur votre taille et dissimule les petites imperfections.</li> <li><strong>Longues Manches :</strong> &Eacute;l&eacute;gance et confort assur&eacute;s, quelle que soit la saison.</li> <li><strong>Ouverture Zipp&eacute;e &agrave; l'Arri&egrave;re :</strong> Facilite l'enfilage et assure un maintien parfait.</li> </ul> <p class="text-base"><strong>Pourquoi choisir cette robe :</strong></p> <ul> <li>Sublime votre silhouette quelle que soit votre morphologie.</li> <li>Offre un confort optimal gr&acirc;ce au vinyle &eacute;lastique.</li> <li>Son style unique et &eacute;l&eacute;gant vous permettra de vous d&eacute;marquer.</li> <li>Parfaite pour une soir&eacute;e sp&eacute;ciale ou un look audacieux au quotidien.</li> <li>Facile &agrave; accessoiriser pour cr&eacute;er des looks vari&eacute;s.</li> </ul> </div>
guid
stringhttps://dev.divasboudoir.com/fr/robe-diane-grande-taille-en-vinyle-elastique--coupe-patineuse-flateuse--toutes-morphologies-noir/cdbu9935.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringCraquez pour la robe Diane en vinyle ! Coupe patineuse flatteuse et confort optimal pour toutes les morphologies. Élégance et originalité garanties. Conseils :
keywords
string
title
stringRobe grande taille Diane Vinyle - Coupe Patineuse Fétichiste
seotitle
stringRobe Diane grande taille en Vinyle Élastique - Coupe Patineuse Flateuse & Toutes Morphologies
seouri
stringrobe-diane-grande-taille-en-vinyle-elastique--coupe-patineuse-flateuse--toutes-morphologies-noir
specifications
string
stylingtips
string
summary
string<div>Robe Diane Vinyle &Eacute;lastique - Coupe Patineuse Flateuse &amp; Toutes Morphologies</div> <div>&nbsp;</div> <div>&nbsp;</div>
title
stringRobe en Vinyle à manches longues
usageinstructions
string
it
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Valorizzate la vostra figura con l'abito Diane in vinile elasticizzato, un capo versatile che si adatta a tutte le forme del corpo. Il suo originale collo ampio e il taglio skater lusinghiero metteranno in mostra le vostre curve con eleganza e comfort. Perfetto per una serata speciale o per un look audace da tutti i giorni.</p> <p class="text-base"><strong>Dettagli che fanno la differenza:</strong></p> <ul> <li><strong>Adatto a tutti i tipi di corpo:</strong> tagliato in modo da valorizzare ogni figura, dalla più snella alla più voluttuosa.</li> <li><strong>Confortevole vinile elastico: si</strong> adatta alle vostre forme senza costringerle, per una totale libertà di movimento.</li> <li><strong>Ampio colletto originale</strong>: aggiunge un tocco di raffinatezza e originalità all'abito.</li> <li><strong>Taglio skater lusinghiero:</strong> mette in risalto il punto vita e nasconde le piccole imperfezioni.</li> <li><strong>Maniche lunghe</strong>: eleganza e comfort garantiti, in qualsiasi stagione.</li> <li><strong>Apertura posteriore con cerniera:</strong> facilita la vestizione e assicura un sostegno perfetto.</li> </ul> <p class="text-base"><strong>Perché scegliere questo abito:</strong></p> <ul> <li>Valorizza la vostra figura, qualunque sia la vostra morfologia.</li> <li>Comfort ottimale grazie al vinile elasticizzato.</li> <li>Il suo stile unico ed elegante vi farà distinguere dalla massa.</li> <li>Perfetto per una serata speciale o per un look audace da tutti i giorni.</li> <li>Facile da accessoriare per creare una varietà di look.</li> </ul> </div>
guid
stringhttps://dev.divasboudoir.com/it/abito-in-vinile-elastico-di-taglia-grande-diane--taglio-skater-lusinghiero-e-tutte-le-morfologie-nero/cdbu9935.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringInnamoratevi dell'abito Diane in vinile! Taglio skater lusinghiero e comfort ottimale per tutte le forme del corpo. Eleganza e originalità garantite. Consigli:
keywords
string
title
stringDiane Taglia grande in vinile - Taglio fetish skater
seotitle
stringAbito in vinile elastico di taglia grande Diane - Taglio skater lusinghiero e tutte le morfologie
seouri
stringabito-in-vinile-elastico-di-taglia-grande-diane--taglio-skater-lusinghiero-e-tutte-le-morfologie-nero
specifications
string
stylingtips
string
summary
string<div>Abito in vinile elastico Diane - Taglio skater e tutte le morfologie</div> <div></div> <div></div>
title
stringAbito in vinile a maniche lunghe
usageinstructions
string
nl
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Verbeter je figuur met de Diane-jurk van stretchvinyl, een veelzijdig stuk dat zich aanpast aan alle lichaamsvormen. De originele brede kraag en flatterende skater snit laten je rondingen zien met elegantie en comfort. Perfect voor een speciale avond of een gewaagde alledaagse look.</p> <p class="text-base"><strong>Details die het verschil maken:</strong></p> <ul> <li><strong>Geschikt voor alle lichaamstypes:</strong> Gesneden om elk figuur te flatteren, van de slankste tot de meest voluptueuze.</li> <li><strong>Comfortabel elastisch vinyl:</strong> Past bij je figuur zonder het te beperken, voor totale bewegingsvrijheid.</li> <li><strong>Brede originele kraag</strong>: Voegt een vleugje verfijning en originaliteit toe aan de jurk.</li> <li><strong>Flatterende Skater Cut:</strong> Laat je taille zien en verbergt kleine imperfecties.</li> <li><strong>Lange mouwen</strong>: Elegantie en comfort gegarandeerd, ongeacht het seizoen.</li> <li><strong>Opening met rits aan de achterkant:</strong> Makkelijk aan te trekken en perfecte ondersteuning.</li> </ul> <p class="text-base"><strong>Waarom voor deze jurk kiezen?</strong></p> <ul> <li>Verbetert je figuur, ongeacht je lichaamsbouw.</li> <li>Optimaal comfort dankzij elastisch vinyl.</li> <li>De unieke, elegante stijl zal je doen opvallen.</li> <li>Perfect voor een speciale avond of een gedurfde alledaagse look.</li> <li>Makkelijk te combineren om verschillende looks te creëren.</li> </ul> </div>
guid
stringhttps://dev.divasboudoir.com/nl/diane-grote-maat-elastische-vinyl-jurk--flatterende-skater-snit-amp;-alle-morfologieen-zwart/cdbu9935.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringVal voor de Diane jurk in vinyl! Flatterende skater snit en optimaal comfort voor alle lichaamsvormen. Elegantie en originaliteit gegarandeerd. Advies :
keywords
string
title
stringDiane Vinyle grote maat jurk - Fetish skater snit
seotitle
stringDiane grote maat elastische vinyl jurk - Flatterende skater snit & alle morfologieën
seouri
stringdiane-grote-maat-elastische-vinyl-jurk--flatterende-skater-snit-amp;-alle-morfologieen-zwart
specifications
string
stylingtips
string
summary
string<div>Diane Elastische Vinyl Jurk - Flatterende Rater Snit &amp; Alle Modologieën</div> <div></div> <div></div>
title
stringVinyl jurk met lange mouwen
usageinstructions
string
pt
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Realce a sua figura com o vestido Diane em vinil elástico, uma peça versátil que se adapta a todas as formas do corpo. A sua original gola larga e o seu corte de skater lisonjeador farão sobressair as suas curvas com elegância e conforto. Perfeito para uma noite especial ou para um look quotidiano ousado.</p> <p class="text-base"><strong>Pormenores que fazem toda a diferença:</strong></p> <ul> <li><strong>Adequado para todos os tipos de corpo:</strong> cortado para favorecer todas as figuras, desde a mais esbelta à mais voluptuosa.</li> <li><strong>Vinil elástico confortável:</strong> Adapta-se à sua forma sem a constranger, para uma total liberdade de movimentos.</li> <li><strong>Gola larga original</strong>: Dá um toque de sofisticação e originalidade ao vestido.</li> <li><strong>Corte skater lisonjeiro:</strong> exibe a cintura e esconde pequenas imperfeições.</li> <li><strong>Manga comprida</strong>: Elegância e conforto garantidos, seja qual for a estação do ano.</li> <li><strong>Abertura nas costas com fecho de correr:</strong> facilita a colocação e garante um apoio perfeito.</li> </ul> <p class="text-base"><strong>Porquê escolher este vestido :</strong></p> <ul> <li>Valoriza a sua figura, qualquer que seja a sua morfologia.</li> <li>Conforto ótimo graças ao vinil elástico.</li> <li>O seu estilo único e elegante fará com que se destaque da multidão.</li> <li>Perfeito para uma noite especial ou para um look quotidiano arrojado.</li> <li>Fácil de combinar para criar uma variedade de looks.</li> </ul> </div>
guid
stringhttps://dev.divasboudoir.com/pt/vestido-de-vinil-elastico-grande-diane--corte-skater-lisonjeiro-e-todas-as-morfologias-preto/cdbu9935.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringApaixone-se pelo vestido Diane em vinil! Corte de skater lisonjeiro e conforto ótimo para todas as formas do corpo. Elegância e originalidade garantidas. Conselhos :
keywords
string
title
stringVestido maxi Diane Vinyle - Corte skater fetiche
seotitle
stringVestido de vinil elástico grande Diane - Corte skater lisonjeiro e todas as morfologias
seouri
stringvestido-de-vinil-elastico-grande-diane--corte-skater-lisonjeiro-e-todas-as-morfologias-preto
specifications
string
stylingtips
string
summary
string<div>Vestido de vinil elástico Diane - Corte de saia lisonjeiro e todas as morfologias</div> <div></div> <div></div>
title
stringVestido de vinil de manga comprida
usageinstructions
string
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<div> <p class="text-base">Unterstreichen Sie Ihren Stil mit dem Vinylkleid Diane, einem gewagten Stück, das einen schmeichelhaften patinierten Schnitt mit einer schicken und subtilen BDSM-Ästhetik verbindet. Das Kleid wurde für alle Körperformen entworfen und schmiegt sich bequem und elegant an Ihre Kurven, wodurch Sie einen sinnlichen und zugleich raffinierten Look erhalten.</p> <p class="text-base"><strong>Details, die den Unterschied ausmachen :</strong></p> <ul> <li><strong>Für alle Körperformen geeignet:</strong> Der Schnitt ist so konzipiert, dass jede Figur, ob zierlich oder üppig, perfekt zur Geltung kommt.</li> <li><strong>Bequemes, elastisches Vinyl:</strong> Passt sich Ihren Formen an, ohne sie einzuschränken, und sorgt so für Bewegungsfreiheit und Komfort.</li> <li><strong>Flacher Patinaschnitt:</strong> Betont Ihre Taille und kaschiert sanft die Bereiche, die Sie weniger zeigen möchten.</li> <li><strong>Breiter Original-Kragen:</strong> Ein Hauch von Originalität, der subtil an die BDSM-Ästhetik erinnert.</li> <li><strong>BDSM Chic-Stil:</strong> Das glänzende Vinyl und der körpernahe Schnitt erinnern an eine Welt der Sinnlichkeit und Dominanz, bleiben aber dennoch elegant.</li> <li><strong>Lange Ärmel:</strong> Für einen anspruchsvollen Look und ein angenehmes Tragegefühl.</li> <li><strong>Reißverschlussöffnung auf der Rückseite:</strong> Erleichtert das Anziehen und sorgt für einen perfekten Sitz.</li> </ul> <p class="text-base"><strong>Warum Sie dieses Kleid wählen sollten:</strong></p> <ul> <li>Betont Ihre Silhouette unabhängig von Ihrem Körperbau dank des schmeichelhaften Patinaschnitts.</li> <li>Wagen Sie einen schicken und subtilen BDSM-Stil.</li> <li>Bietet dank des elastischen Vinyls optimalen Tragekomfort.</li> <li>Perfekt für eine gewagte Party oder ein besonderes Ereignis.</li> <li>Gibt Ihnen die Möglichkeit, Ihre Individualität auf elegante Weise auszudrücken.</li> </ul> </div>
highlights
string
keypoint
string
keywords
stringVinyl-Kleid, Kleid mit Pistolenschnitt, BDSM-Kleid, Kleid für alle Körperformen, Sexy Kleid, Elegantes Kleid, Kleid mit langen Ärmeln, Frauenmode, Alternative Kleider, BDSM Chic.
metas
Struct
description
stringWagen Sie es, das Diane-Kleid aus Vinyl zu tragen! Schlittschuh-Schnitt, schicker BDSM-Stil und Komfort für alle Körperformen. Drücken Sie Ihre Kühnheit mit Eleganz aus! Kostenlose Rücksendungen.
keywords
string
title
stringVinyl-Patinenkleid in Übergröße - Fetisch-Look
seotitle
stringDiane Vinyl Kleid - Patinaschnitt, BDSM Chic & Alle Morphologien
seouri
stringdiane-vinyl-kleid--patinaschnitt,-bdsm-chic-amp;-alle-morphologien-schwarz
specifications
string
stylingtips
string
summary
string<p>Diane Vinyl Kleid - Patinaschnitt, BDSM Chic &amp; Alle Morphologien</p>
title
stringKleid Diane Vinyl
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Κάντε μια τολμηρή δήλωση στυλ με το φόρεμα βινυλίου Diane, το οποίο συνδυάζει ένα κολακευτικό skater κόψιμο με μια λεπτή, κομψή BDSM αισθητική. Σχεδιασμένο για όλους τους σωματότυπους, αυτό το φόρεμα αγκαλιάζει τις καμπύλες σας με άνεση και κομψότητα, χαρίζοντάς σας μια εμφάνιση που είναι ταυτόχρονα αισθησιακή και εκλεπτυσμένη.</p> <p class="text-base"><strong>Λεπτομέρειες που κάνουν τη διαφορά:</strong></p> <ul> <li><strong>Κατάλληλο για όλα τα σχήματα σώματος:</strong> Κομμένο για να αναδεικνύει κάθε σιλουέτα, είτε μικροσκοπική είτε πληθωρική.</li> <li><strong>Άνετο ελαστικό βινύλιο:</strong> Προσαρμόζεται στο σχήμα σας χωρίς να το περιορίζει, για απόλυτη ελευθερία κινήσεων και βέλτιστη άνεση.</li> <li><strong>Κολακευτικό κόψιμο Skater:</strong> Αναδεικνύει τη μέση σας και κρύβει απαλά τις περιοχές που δεν θέλετε να εκτίθενται.</li> <li><strong>Ευρύς πρωτότυπος γιακάς</strong>: Μια πινελιά πρωτοτυπίας που θυμίζει διακριτικά την αισθητική του BDSM.</li> <li><strong>BDSM Chic Style: Το</strong> γυαλιστερό βινύλιο και το στενό κόψιμο παραπέμπουν σε έναν κόσμο αισθησιασμού και κυριαρχίας, ενώ παράλληλα παραμένουν κομψά.</li> <li><strong>Μακριά μανίκια</strong>: Για μια εκλεπτυσμένη εμφάνιση και μια άνετη αίσθηση.</li> <li><strong>Άνοιγμα με φερμουάρ στην πλάτη:</strong> Το καθιστά εύκολο να φορεθεί και εξασφαλίζει τέλεια στήριξη.</li> </ul> <p class="text-base"><strong>Γιατί να επιλέξετε αυτό το φόρεμα :</strong></p> <ul> <li>Αναδείξτε τη σιλουέτα σας, όποιο κι αν είναι το σχήμα σας, χάρη στο κολακευτικό skater κόψιμό του.</li> <li>Τολμήστε να είστε κομψές και διακριτικές στο στυλ BDSM.</li> <li>Βέλτιστη άνεση χάρη στο ελαστικό βινύλιο.</li> <li>Ιδανικό για μια τολμηρή βραδινή έξοδο ή μια ξεχωριστή εκδήλωση.</li> <li>Σας επιτρέπει να εκφράσετε την ατομικότητά σας με στυλ.</li> </ul> </div>
highlights
string
keypoint
string
keywords
stringΦόρεμα βινυλίου, Φόρεμα skater, Φόρεμα BDSM, Φόρεμα όλων των μορφολογιών, Σέξι φόρεμα, Κομψό φόρεμα, Φόρεμα με μακρύ μανίκι, Γυναικεία μόδα, Εναλλακτικό φόρεμα, BDSM Chic.
metas
Struct
description
stringΤολμήστε να φορέσετε το φόρεμα Diane vinyl! Κόψιμο skater, κομψό BDSM στυλ και άνεση για όλους τους σωματότυπους. Εκφράστε την τόλμη σας με κομψότητα! Δωρεάν επιστροφές.
keywords
string
title
stringΜεγάλο φόρεμα skater από βινύλιο - Fétichiste Look
seotitle
stringDiane Vinyl Dress - Skater cut, BDSM Chic & All Morphologies
seouri
stringdiane-vinyl-dress--skater-cut,-bdsm-chic-amp;-all-morphologies-mayro
specifications
string
stylingtips
string
summary
string<p>Diane Vinyl Dress - Skater cut, BDSM Chic &amp; All Morphologies</p>
title
stringDiane Φόρεμα βινυλίου
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Make a style statement with the Diane vinyl dress, a bold piece that combines a flattering skater cut with a subtle, chic BDSM aesthetic. Designed for all body types, this dress hugs your curves with comfort and elegance, giving you a look that's both sensual and sophisticated.</p> <p class="text-base"><strong>Details that make all the difference:</strong></p> <ul> <li><strong>Adapted to All Morphologies:</strong> Cut designed to sublimate every silhouette, whether petite or voluptuous.</li> <li><strong>Comfortable Elastic Vinyl:</strong> Fits your shape without constricting it, for total freedom of movement and optimal comfort.</li> <li><strong>Flattering skater cut:</strong> Highlights your waistline and gently conceals areas you don't want exposed.</li> <li><strong>Original Wide Collar</strong>: A touch of originality that subtly recalls the BDSM aesthetic.</li> <li><strong>BDSM Chic:</strong> Shiny vinyl and a close-fitting cut evoke a world of sensuality and domination, while remaining elegant.</li> <li><strong>Long sleeves</strong>: For a sophisticated look and a feeling of comfort.</li> <li><strong>Back zipper opening:</strong> Makes it easy to put on and ensures perfect support.</li> </ul> <p class="text-base"><strong>Why choose this dress:</strong></p> <ul> <li>Sublimates your figure whatever your morphology thanks to its flattering skater cut.</li> <li>Dare to be chic and subtle in BDSM style.</li> <li>Optimal comfort thanks to elastic vinyl.</li> <li>Perfect for a daring evening out or a special event.</li> <li>Allows you to express your individuality with elegance.</li> </ul> </div>
highlights
string
keypoint
string
keywords
stringVinyl Dress, Skater Dress, BDSM Dress, All Morphologies Dress, Sexy Dress, Elegant Dress, Long Sleeve Dress, Women's Fashion, Alternative Dress, BDSM Chic.
metas
Struct
description
stringDare to wear the Diane vinyl dress! Skater cut, BDSM chic style and comfort for all body types. Express your audacity with elegance! Free returns.
keywords
string
title
stringPlus size skater dress in Vinyl - Fetish Look
seotitle
stringDiane Vinyl Dress - Skater cut, BDSM Chic & All Morphologies
seouri
stringdiane-vinyl-dress--skater-cut,-bdsm-chic-amp;-all-morphologies-black
specifications
string
stylingtips
string
summary
string<p>Diane Vinyl Dress - Skater cut, BDSM Chic &amp; All Morphologies</p>
title
stringDiane Vinyl Dress
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Haz una atrevida declaración de estilo con el vestido de vinilo Diane, que combina un favorecedor corte skater con una estética BDSM sutil y chic. Diseñado para todo tipo de cuerpos, este vestido abraza tus curvas con comodidad y elegancia, proporcionándote un look sensual y sofisticado a la vez.</p> <p class="text-base"><strong>Detalles que marcan la diferencia:</strong></p> <ul> <li><strong>Adecuado para todas las formas de cuerpo:</strong> Cortado para realzar cada figura, ya sea menuda o voluptuosa.</li> <li><strong>Cómodo vinilo elástico:</strong> Se adapta a tu silueta sin apretarla, para una total libertad de movimientos y un confort óptimo.</li> <li><strong>Favorecedor corte skater:</strong> Muestra tu cintura y oculta suavemente las zonas que no quieres que queden al descubierto.</li> <li><strong>Original cuello ancho</strong>: Un toque de originalidad que recuerda sutilmente la estética BDSM.</li> <li><strong>Estilo BDSM Chic: El</strong> vinilo brillante y el corte ceñido evocan un mundo de sensualidad y dominación, sin dejar de ser elegantes.</li> <li><strong>Mangas largas</strong>: Para un look sofisticado y una sensación de comodidad.</li> <li><strong>Abertura trasera con cremallera</strong>: Facilita la colocación y garantiza una sujeción perfecta.</li> </ul> <p class="text-base"><strong>Por qué elegir este vestido :</strong></p> <ul> <li>Realza tu figura sea cual sea tu figura gracias a su favorecedor corte skater.</li> <li>Atrévete con un estilo BDSM chic y sutil.</li> <li>Comodidad óptima gracias al vinilo elástico.</li> <li>Perfecta para una salida nocturna atrevida o un evento especial.</li> <li>Te permite expresar tu individualidad con estilo.</li> </ul> </div>
highlights
string
keypoint
string
keywords
stringVestido Vinilo, Vestido Skater, Vestido BDSM, Vestido Todas las Morfologías, Vestido Sexy, Vestido Elegante, Vestido Manga Larga, Moda Femenina, Vestido Alternativo, BDSM Chic.
metas
Struct
description
string¡Atrévete con el vestido de vinilo Diane! Corte skater, estilo BDSM chic y comodidad para todo tipo de cuerpos. ¡Expresa tu atrevimiento con elegancia! Devoluciones gratuitas.
keywords
string
title
stringVestido skater talla grande de vinilo - Fétichiste Look
seotitle
stringVestido Vinilo Diane - Corte Skater, BDSM Chic & Todas las Morfologías
seouri
stringvestido-vinilo-diane--corte-skater,-bdsm-chic-amp;-todas-las-morfologias-negro
specifications
string
stylingtips
string
summary
string<p>Vestido Vinilo Diane - Corte Skater, BDSM Chic &amp; Todas las Morfologías</p>
title
stringVestido de vinilo Diane
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Affirmez votre style avec la robe Diane en vinyle, une pi&egrave;ce audacieuse qui combine une coupe patineuse flatteuse avec une esth&eacute;tique BDSM chic et subtile. Con&ccedil;ue pour toutes les morphologies, cette robe &eacute;pouse vos courbes avec confort et &eacute;l&eacute;gance, vous offrant un look &agrave; la fois sensuel et sophistiqu&eacute;.</p> <p class="text-base"><strong>D&eacute;tails qui font la diff&eacute;rence :</strong></p> <ul> <li><strong>Adapt&eacute;e &agrave; Toutes les Morphologies :</strong> Coupe &eacute;tudi&eacute;e pour sublimer chaque silhouette, qu'elle soit menue ou voluptueuse.</li> <li><strong>Vinyle &Eacute;lastique Confortable :</strong> &Eacute;pouse vos formes sans les contraindre, pour une libert&eacute; de mouvement totale et un confort optimal.</li> <li><strong>Coupe Patineuse Flateuse :</strong> Met en valeur votre taille et dissimule d&eacute;licatement les zones que vous souhaitez moins exposer.</li> <li><strong>Large Col Original :</strong> Une touche d'originalit&eacute; qui rappelle subtilement l'esth&eacute;tique BDSM.</li> <li><strong>Style BDSM Chic :</strong> Le vinyle brillant et la coupe pr&egrave;s du corps &eacute;voquent un univers de sensualit&eacute; et de domination, tout en restant &eacute;l&eacute;gant.</li> <li><strong>Longues Manches :</strong> Pour une allure sophistiqu&eacute;e et une sensation de confort.</li> <li><strong>Ouverture Zipp&eacute;e &agrave; l'Arri&egrave;re :</strong> Facilite l'enfilage et assure un maintien parfait.</li> </ul> <p class="text-base"><strong>Pourquoi choisir cette robe :</strong></p> <ul> <li>Sublime votre silhouette quelle que soit votre morphologie gr&acirc;ce &agrave; sa coupe patineuse flatteuse.</li> <li>Osez un style BDSM chic et subtil.</li> <li>Offre un confort optimal gr&acirc;ce au vinyle &eacute;lastique.</li> <li>Parfaite pour une soir&eacute;e audacieuse ou un &eacute;v&eacute;nement sp&eacute;cial.</li> <li>Vous permet d'exprimer votre individualit&eacute; avec &eacute;l&eacute;gance.</li> </ul> </div>
highlights
string
keypoint
string
keywords
stringRobe Vinyle, Robe Coupe Patineuse, Robe BDSM, Robe Toutes Morphologies, Robe Sexy, Robe Élégante, Robe Longues Manches, Mode Femme, Robe Alternative, BDSM Chic.
metas
Struct
description
stringOsez la robe Diane en vinyle ! Coupe patineuse, style BDSM chic et confort pour toutes les morphologies. Exprimez votre audace avec élégance ! Retours gratuits.
keywords
string
title
stringRobe patineuse grande taille en Vinyle - Look Fétichiste
seotitle
stringRobe Diane Vinyle - Coupe Patineuse, BDSM Chic & Toutes Morphologies
seouri
stringrobe-diane-vinyle--coupe-patineuse,-bdsm-chic--toutes-morphologies-noir
specifications
string
stylingtips
string
summary
string<p>Robe Diane Vinyle - Coupe Patineuse, BDSM Chic &amp; Toutes Morphologies</p>
title
stringRobe Diane Vinyle
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Fate una dichiarazione di stile audace con l'abito in vinile Diane, che combina un taglio skater lusinghiero con un'estetica BDSM sottile e chic. Progettato per tutti i tipi di corpo, questo abito abbraccia le vostre curve con comfort ed eleganza, regalandovi un look sensuale e sofisticato.</p> <p class="text-base"><strong>Dettagli che fanno la differenza:</strong></p> <ul> <li><strong>Adatto a tutte le forme del corpo:</strong> tagliato per valorizzare ogni figura, sia minuta che voluttuosa.</li> <li><strong>Confortevole vinile elastico: si</strong> adatta alle vostre forme senza costringerle, per una totale libertà di movimento e un comfort ottimale.</li> <li><strong>Taglio skater:</strong> mette in risalto il punto vita e nasconde delicatamente le zone che non si desidera esporre.</li> <li><strong>Ampio colletto originale</strong>: un tocco di originalità che richiama sottilmente l'estetica BDSM.</li> <li><strong>Stile BDSM Chic: il</strong> vinile lucido e il taglio aderente evocano un mondo di sensualità e dominazione, pur rimanendo eleganti.</li> <li><strong>Maniche lunghe</strong>: per un look sofisticato e una sensazione di comfort.</li> <li><strong>Apertura posteriore con cerniera:</strong> facilita la vestizione e assicura una perfetta aderenza.</li> </ul> <p class="text-base"><strong>Perché scegliere questo abito:</strong></p> <ul> <li>Valorizza la tua figura, qualunque sia la tua forma, grazie al suo taglio skater lusinghiero.</li> <li>Osate essere chic e sottili in stile BDSM.</li> <li>Comfort ottimale grazie al vinile elasticizzato.</li> <li>Perfetto per una serata audace o un evento speciale.</li> <li>Permette di esprimere la propria individualità con stile.</li> </ul> </div>
highlights
string
keypoint
string
keywords
stringAbito in vinile, abito skater, abito BDSM, abito per tutte le morfologie, abito sexy, abito elegante, abito a maniche lunghe, moda femminile, abito alternativo, BDSM Chic.
metas
Struct
description
stringOsate indossare l'abito in vinile Diane! Taglio skater, stile BDSM chic e comfort per tutti i tipi di corpo. Esprimete la vostra audacia con eleganza! Restituzione gratuita.
keywords
string
title
stringAbito skater in vinile di taglia grande - Look Fétichiste
seotitle
stringAbito in vinile Diane - Taglio skater, BDSM Chic e tutte le morfologie
seouri
stringabito-in-vinile-diane--taglio-skater,-bdsm-chic-e-tutte-le-morfologie-nero
specifications
string
stylingtips
string
summary
string<p>Abito in vinile Diane - Taglio skater, BDSM Chic e tutte le morfologie</p>
title
stringAbito in vinile Diane
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Maak een gedurfd stijlstatement met de Diane vinyl jurk, die een flatterend skater model combineert met een subtiele, chique BDSM-esthetiek. Deze jurk is ontworpen voor alle lichaamstypes en omhelst je rondingen met comfort en elegantie, waardoor je een look krijgt die zowel sensueel als geraffineerd is.</p> <p class="text-base"><strong>Details die het verschil maken:</strong></p> <ul> <li><strong>Geschikt voor alle lichaamsvormen:</strong> Gesneden om elk figuur te verbeteren, of je nu klein of voluptueus bent.</li> <li><strong>Comfortabel elastisch vinyl:</strong> Past bij je figuur zonder het te beperken, voor totale bewegingsvrijheid en optimaal comfort.</li> <li><strong>Flatterende rokkostuumsnit:</strong> Laat je taille zien en verbergt zachtjes delen die je niet bloot wilt hebben.</li> <li><strong>Brede originele kraag</strong>: Een vleugje originaliteit dat subtiel herinnert aan de BDSM-esthetiek.</li> <li><strong>BDSM Chic Style:</strong> Glanzend vinyl en een nauwsluitende snit roepen een wereld van sensualiteit en dominantie op, terwijl het toch elegant blijft.</li> <li><strong>Lange mouwen</strong>: Voor een geraffineerde look en een comfortabel gevoel.</li> <li><strong>Opening met rits aan de achterkant:</strong> maakt het gemakkelijk om aan te trekken en zorgt voor perfecte ondersteuning.</li> </ul> <p class="text-base"><strong>Waarom voor deze jurk kiezen?</strong></p> <ul> <li>Laat je figuur beter uitkomen, ongeacht je vorm, dankzij de flatterende skater-uitsnijding.</li> <li>Durf chique en subtiel te zijn in BDSM stijl.</li> <li>Optimaal comfort dankzij het elastische vinyl.</li> <li>Perfect voor een gewaagde avond uit of een speciaal evenement.</li> <li>Laat je individualiteit zien in stijl.</li> </ul> </div>
highlights
string
keypoint
string
keywords
stringVinyl Jurk, Skater Jurk, BDSM Jurk, Alle Morfologieën Jurk, Sexy Jurk, Elegante Jurk, Jurk met Lange Mouwen, Damesmode, Alternatieve Jurk, BDSM Chic.
metas
Struct
description
stringDurf de Diane vinyl jurk te dragen! Skater snit, chique BDSM stijl en comfort voor alle lichaamstypes. Laat je vrijmoedigheid zien met elegantie! Gratis retourneren.
keywords
string
title
stringGrote maat Vinyl Skater Jurk - Fétichiste Look
seotitle
stringDiane Vinyl Jurk - Rater gesneden, BDSM Chic & Alle vormen
seouri
stringdiane-vinyl-jurk--rater-gesneden,-bdsm-chic-amp;-alle-vormen-zwart
specifications
string
stylingtips
string
summary
string<p>Diane Vinyl Jurk - Rater gesneden, BDSM Chic &amp; Alle vormen</p>
title
stringDiane Vinyl Jurk
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Faça uma declaração de estilo ousada com o vestido de vinil Diane, que combina um corte de skater lisonjeiro com uma estética BDSM subtil e chique. Concebido para todos os tipos de corpo, este vestido abraça as suas curvas com conforto e elegância, dando-lhe um visual que é simultaneamente sensual e sofisticado.</p> <p class="text-base"><strong>Pormenores que fazem toda a diferença:</strong></p> <ul> <li><strong>Adequado para todas as formas do corpo:</strong> cortado para realçar todas as figuras, sejam elas pequenas ou voluptuosas.</li> <li><strong>Vinil elástico confortável:</strong> Adapta-se à sua forma sem a apertar, para uma total liberdade de movimentos e um conforto ótimo.</li> <li><strong>Corte de skater lisonjeiro:</strong> mostra a sua cintura e esconde suavemente as áreas que não quer ver expostas.</li> <li><strong>Gola larga original</strong>: Um toque de originalidade que recorda subtilmente a estética BDSM.</li> <li><strong>Estilo BDSM Chic:</strong> O vinil brilhante e o corte justo evocam um mundo de sensualidade e dominação, sem deixar de ser elegante.</li> <li><strong>Mangas compridas</strong>: Para um visual sofisticado e uma sensação de conforto.</li> <li><strong>Abertura nas costas com fecho de correr:</strong> Facilita a colocação e garante um ajuste perfeito.</li> </ul> <p class="text-base"><strong>Porquê escolher este vestido :</strong></p> <ul> <li>Realce a sua figura, seja qual for a sua forma, graças ao seu corte de skater lisonjeiro.</li> <li>Atreva-se a ser chique e subtil no estilo BDSM.</li> <li>Conforto ótimo graças ao vinil elástico.</li> <li>Perfeito para uma saída à noite ousada ou um evento especial.</li> <li>Permite-lhe exprimir a sua individualidade com estilo.</li> </ul> </div>
highlights
string
keypoint
string
keywords
stringVestido Vinil, Vestido Skater, Vestido BDSM, Vestido Todas as Morfologias, Vestido Sexy, Vestido Elegante, Vestido Manga Comprida, Moda Feminina, Vestido Alternativo, BDSM Chic.
metas
Struct
description
stringAtreva-se a usar o vestido de vinil Diane! Corte skater, estilo BDSM chique e conforto para todos os tipos de corpo. Exprima a sua ousadia com elegância! Devoluções gratuitas.
keywords
string
title
stringVestido skater de vinil grande - Look Fétichiste
seotitle
stringVestido de vinil Diane - corte skater, BDSM Chic e todas as morfologias
seouri
stringvestido-de-vinil-diane--corte-skater,-bdsm-chic-e-todas-as-morfologias-preto
specifications
string
stylingtips
string
summary
string<p>Vestido de vinil Diane - corte skater, BDSM Chic e todas as morfologias</p>
title
stringVestido de vinil Diane
usageinstructions
string
name
string2114500SDRT-36BK
netweight
string
nextshipment
stringtomorrow
ordered
number1
orderidx
number0
origin
string
originalsize
string
packaging
string
productshipment
stringauto
productuid
stringDAA488AA-0EA1-4E8A-A8F5236515B22111
promountil
string
rating
stringnone
recorduid
stringDAA488AA-0EA1-4E8A-A8F5236515B22111
reference
stringCDBU9935
related
string
reserved
string
returned
number0
returnsallowed
number1
section
stringcabaret
shipment
string5to7days
showbrand
number0
sizeinfos
Query
Template: /system/api/product/sizes.cfc:20
Execution Time: 1.52 ms
Record Count: 3
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,'2087,2086,2085,2084,2083,2082') > 0
and product_variations.productuid = 'DAA488AA-0EA1-4E8A-A8F5236515B22111'
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
12087XLintlsizeblackXLXL-19999991wplusdressXLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42104-10880-86106-110
220862XLintlsizeblack2XL2XL-19999991wplusdress2XL2XL44-4614-1618-2046-4846-4844-4650-5246-4844-46108-11286-92110-114
320853XLintlsizeblack3XL3XL-19999990wplusdress3XL3XL48-5018-2022-2650-5250-5248-5052-5450-5248-50112-11492-98114-118
sizeranges
stringstandard,plus
sizes
string2087,2086,2085,2084,2083,2082
sizetype
stringauto
specifications
Struct
Entries: 23
belly
string
bones
string
bra
string
breasts
string
bust
string
closing
string
crochtless
string
cups
string
cut
string
garter
string
halter
string
lacing
string
lining
string
modestypanel
string
panty
string
sheathing
string
sleeves
string
stocking
string
straps
string
stretch
string
suspenders
string
transparency
string
underwires
string
stock
number0
stocks
Query
Template: /system/api/product/stocks.cfc:25
Execution Time: 5.51 ms
Record Count: 3
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 = 'DAA488AA-0EA1-4E8A-A8F5236515B22111'
and product_variations.isactive = 1
and product_sizes.id_size = 2087
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 = 'DAA488AA-0EA1-4E8A-A8F5236515B22111'
and product_variations.isactive = 1
and product_sizes.id_size = 2086
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 = 'DAA488AA-0EA1-4E8A-A8F5236515B22111'
and product_variations.isactive = 1
and product_sizes.id_size = 2085
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 = 'DAA488AA-0EA1-4E8A-A8F5236515B22111'
and product_variations.isactive = 1
and product_sizes.id_size = 2084
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 = 'DAA488AA-0EA1-4E8A-A8F5236515B22111'
and product_variations.isactive = 1
and product_sizes.id_size = 2083
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 = 'DAA488AA-0EA1-4E8A-A8F5236515B22111'
and product_variations.isactive = 1
and product_sizes.id_size = 2082
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
1DAA488AA-0EA1-4E8A-A8F5236515B221119879FBDC-44BA-479E-A88A3D09E92C66822087black#000000XLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42wdressXLintlsize37.458327.4583{ts '2025-09-09 12:07:00'}STOCK01100-100002114511all
2DAA488AA-0EA1-4E8A-A8F5236515B221117FD555FF-42D0-4658-A921A5A711E8DC982086black#0000002XL2XL44-4614-1618-2046-4846-4844-4650-5246-4844-46wdress2XLintlsize37.458327.4583{ts '2025-09-09 12:07:00'}STOCK01100-1000021145366408611155411all
3DAA488AA-0EA1-4E8A-A8F5236515B22111E0C43E5A-6B24-4BF9-B574622F5995F8CD2085black#0000003XL3XL48-5018-2022-2650-5250-5248-5052-5450-5248-50wdress3XLintlsize37.458327.4583{ts '2025-09-09 12:07:00'}STOCK01100-11100211453664086111561-10all
subcategory
stringall
supplier
number-1
supplierreference
string2114500SDRT-36BK
tags
stringnoirdesir
themes
stringdark
totalvariations
string
type
stringdefault
unitprice
number37.4583
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 9.58 ms
Record Count: 3
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 = 'DAA488AA-0EA1-4E8A-A8F5236515B22111' 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 = 'DAA488AA-0EA1-4E8A-A8F5236515B22111' 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 = 'DAA488AA-0EA1-4E8A-A8F5236515B22111' 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 = 'DAA488AA-0EA1-4E8A-A8F5236515B22111' 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 = 'DAA488AA-0EA1-4E8A-A8F5236515B22111' 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 = 'DAA488AA-0EA1-4E8A-A8F5236515B22111' 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 = 'DAA488AA-0EA1-4E8A-A8F5236515B22111'
and product_variations.isactive = 1
and product_sizes.id_size = 2087
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 = 'DAA488AA-0EA1-4E8A-A8F5236515B22111' 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 = 'DAA488AA-0EA1-4E8A-A8F5236515B22111' 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 = 'DAA488AA-0EA1-4E8A-A8F5236515B22111' 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 = 'DAA488AA-0EA1-4E8A-A8F5236515B22111' 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 = 'DAA488AA-0EA1-4E8A-A8F5236515B22111' 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 = 'DAA488AA-0EA1-4E8A-A8F5236515B22111' 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 = 'DAA488AA-0EA1-4E8A-A8F5236515B22111'
and product_variations.isactive = 1
and product_sizes.id_size = 2086
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 = 'DAA488AA-0EA1-4E8A-A8F5236515B22111' 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 = 'DAA488AA-0EA1-4E8A-A8F5236515B22111' 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 = 'DAA488AA-0EA1-4E8A-A8F5236515B22111' 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 = 'DAA488AA-0EA1-4E8A-A8F5236515B22111' 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 = 'DAA488AA-0EA1-4E8A-A8F5236515B22111' 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 = 'DAA488AA-0EA1-4E8A-A8F5236515B22111' 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 = 'DAA488AA-0EA1-4E8A-A8F5236515B22111'
and product_variations.isactive = 1
and product_sizes.id_size = 2085
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 = 'DAA488AA-0EA1-4E8A-A8F5236515B22111' 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 = 'DAA488AA-0EA1-4E8A-A8F5236515B22111' 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 = 'DAA488AA-0EA1-4E8A-A8F5236515B22111' 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 = 'DAA488AA-0EA1-4E8A-A8F5236515B22111' 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 = 'DAA488AA-0EA1-4E8A-A8F5236515B22111' 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 = 'DAA488AA-0EA1-4E8A-A8F5236515B22111' 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 = 'DAA488AA-0EA1-4E8A-A8F5236515B22111'
and product_variations.isactive = 1
and product_sizes.id_size = 2084
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 = 'DAA488AA-0EA1-4E8A-A8F5236515B22111' 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 = 'DAA488AA-0EA1-4E8A-A8F5236515B22111' 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 = 'DAA488AA-0EA1-4E8A-A8F5236515B22111' 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 = 'DAA488AA-0EA1-4E8A-A8F5236515B22111' 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 = 'DAA488AA-0EA1-4E8A-A8F5236515B22111' 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 = 'DAA488AA-0EA1-4E8A-A8F5236515B22111' 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 = 'DAA488AA-0EA1-4E8A-A8F5236515B22111'
and product_variations.isactive = 1
and product_sizes.id_size = 2083
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 = 'DAA488AA-0EA1-4E8A-A8F5236515B22111' 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 = 'DAA488AA-0EA1-4E8A-A8F5236515B22111' 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 = 'DAA488AA-0EA1-4E8A-A8F5236515B22111' 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 = 'DAA488AA-0EA1-4E8A-A8F5236515B22111' 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 = 'DAA488AA-0EA1-4E8A-A8F5236515B22111' 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 = 'DAA488AA-0EA1-4E8A-A8F5236515B22111' 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 = 'DAA488AA-0EA1-4E8A-A8F5236515B22111'
and product_variations.isactive = 1
and product_sizes.id_size = 2082
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
19879FBDC-44BA-479E-A88A3D09E92C66822087black#000000XLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42wdressXLintlsize37.458327.4583{ts '2025-09-09 12:07:00'}STOCK01100-100002114511-11-12037.4583all
27FD555FF-42D0-4658-A921A5A711E8DC982086black#0000002XL2XL44-4614-1618-2046-4846-4844-4650-5246-4844-46wdress2XLintlsize37.458327.4583{ts '2025-09-09 12:07:00'}STOCK01100-1000021145366408611155411-11-12037.4583all
3E0C43E5A-6B24-4BF9-B574622F5995F8CD2085black#0000003XL3XL48-5018-2022-2650-5250-5248-5052-5450-5248-50wdress3XLintlsize37.458327.4583{ts '2025-09-09 12:07:00'}STOCK01100-11100211453664086111561-10-10-12037.4583all
vatrate
number20
warehouse
string