My cart

❌
Total items
View basket
Menu
See sizes
Ivanka dress
Double-click to enlarge
SKU: DRCH6902
Ivanka dress
Stock:

Plus size dress in wetlook and lace, available up to size 62.

Highlights

  • Wet look quality for a shiny, sophisticated effect
  • Refined black lace on sleeves, hem and under bust
  • Shapely cut to enhance every figure
  • Short length for bold, modern style
  • Eye-catching design with meticulous finishing touches
Size:

Not sure which size to choose? See our size guide

Color:
Quantity:
49.95 €
Help and advice
by chat, facebook or e-mail
Free returns
within 15 days *

Ivanka plus size dress

Product description

Whether worn as lingerie or a sexy outfit, this Ivanka dress in wetlook and lace will leave no one indifferent.

Wetlook is a fabric similar in appearance to vinyl, but much softer and more comfortable. Here it's presented in matte, which we love. This fabric always has a smoothing, slightly sheathing effect on the silhouette.

Laces on the arms, under the plunging décolleté and at the bottom of the dress.

Technical details

  • Material: High-quality black wet look
  • Details: Black lace on sleeves, hem and under bust
  • Cut: Shapely and fitted
  • Length: Short for modern style
  • Style: Bold and sophisticated

Available sizes

Available from L+ to 4XL

Available color

Black

Sizing guide

Check the right size for you

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

Care instructions

  • Hand wash only with mild, non-abrasive soap
  • Gently wipe with a damp cloth between uses
  • Air dry flat, away from heat sources
  • Avoid any ironing which would damage the material
  • Store flat in a cool, dry place, avoid sharp folding
  • For sizes 42-64, avoid excessive friction in contact areas to preserve the material's appearance
  •  

Usage tips

For optimum comfort, gently slip on the dress, avoiding pulling on the lace.

Be sure to adjust the dress so that the lace details under the bust are perfectly positioned.

Styling tips

The Ivanka dress can be worn with confidence for daring evenings out or sophisticated moments of intimacy. Its shiny wet look and lace details make it a statement piece that stands on its own.

Pair it with gold or silver accessories to create the perfect harmony, or wear it with high heels to accentuate its natural elegance and assertive glamour. Complete your look with our sexy dresses for a daring wardrobe, or explore our sexy ensembles for an assertive style.

To Top
View basket
Items
Total items
Struct
Entries: 108
actions
Array
available
number-1
brand
stringcottelli
brandcode
stringcwhd
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
stringCottelli
breasts
stringna
careinstructions
stringwetlook
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.671 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1blackcolorblakblackblack#000000-10
colorrange
stringblack
colors
stringblack
colortype
stringcolor
comments
string
compositions
Struct
Entries: 13
coton
string
elastane
string
free
string
leather
string
lycra
string
metal
string
nylon
string
polyamide
string
polyester
string
polyurethane
string
silk
string
spandex
string
viscose
string
datecreated
Date Time (Europe/Paris)
{ts '2019-05-29 17:58:54'}
defect
number0
dimensions
Struct
Entries: 14
acrylicbones
string
backsideheight
string
diameter
string
flatsteelbones
string
frontsideheight
string
fullheight
string
length
string
modestysize
string
panels
string
sides
string
spiralsteelbones
string
totallength
string
unit
stringcm
wiresize
string
display
stringall
displayfrom
string
displayto
string
grossweight
string
hasbrandinfos
booleanfalse
hascareinstructions
booleantrue
hascolorinfos
booleantrue
hascompositions
booleanfalse
hasdescription
booleantrue
hasdimensions
booleanfalse
hasmaterials
booleanfalse
hasotherspecifications
booleanfalse
haspromo
number0
hasshortdescription
booleantrue
hassizeinfos
booleantrue
hasspecifications
booleantrue
hasstockinfos
booleanfalse
hasstylingtips
booleantrue
hasusageinstructions
booleantrue
hasvariations
booleantrue
import
string
inpromo
number0
instockvariations
number0
isactive
number1
iscustommade
number0
isdivasize
number1
isfirstprice
number0
isfixedprice
number0
ishot
number0
isnew
number0
isonline
number0
isoutletprice
number0
itemprice
number41.625
itempromo
string
key
stringwetlook-kleid-27151471051
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-08-01 18:38:43'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.628 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','en')
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('fcbd8028-95ca-4c9d-a601bd8c4928ebe5',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','en')
and product_categories.language in ('all','en')
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 <> 'DRCH6902'
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
string1076
isprivate
string0
rating
stringall
src
string/photobank/products/cwhd/drch6902/32039501.jpg
type
stringimg
width
string744
back
Struct
height
string936
isprivate
string0
rating
stringall
src
string/photobank/products/cwhd/drch6902/32039530.jpg
type
stringimg
width
string647
default
Struct
height
string920
isprivate
string0
rating
stringall
src
string/photobank/products/cwhd/drch6902/moi.jpg
type
stringimg
width
string636
variations
Struct
colors
Struct
black
Struct
height
string920
isprivate
string0
rating
stringall
src
string/photobank/products/cwhd/drch6902/moi.jpg
type
stringimg
width
string636
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
stringOb als Dessous oder sexy Outfit, dieses Ivanka-Kleid aus Wetlook und Spitze wird niemanden unberührt lassen.<br /><br />Wetlook ist ein Stoff, der äußerlich Vinyl ähnelt, aber viel weicher und bequemer ist. Hier wird er in matt präsentiert, was uns sehr gut gefällt. Dieser Stoff hat immer einen glättenden und leicht formenden Effekt auf die Silhouette.<br /><br />Spitzen an den Armen, unter dem plosierenden Ausschnitt und im unteren Teil des Kleides.
guid
stringhttps://dev.divasboudoir.com/de/kleid-in-ubergrosse-ivanka-schwarz/drch6902.htm
highlights
string<ul> <li>Hochwertiger<strong>Wetlook</strong> für einen raffinierten Glanzeffekt</li> <li><strong>Raffinierte schwarze Spitze</strong> an Ärmeln, Saum und unter der Brust</li> <li><strong>Figurformender Schnitt</strong>, der jede Figur umschmeichelt und aufwertet</li> <li><strong>Kurze Länge</strong> für einen kühnen, modernen Stil</li> <li><strong>Auffälliges Design</strong> mit sorgfältigen Abschlüssen</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringKleid in großen Größen aus Wetlook und Spitze, erhältlich bis Größe 62.
keywords
string
title
stringKleid in Übergröße Ivanka
seotitle
stringKleid in Übergröße Ivanka
seouri
stringkleid-in-ubergrosse-ivanka-schwarz
specifications
string<ul> <li><strong>Material:</strong> Hochwertiger schwarzer Wetlook</li> <li><strong>Details:</strong> Schwarze Spitze an Ärmeln, Saum und Unterbrust</li> <li><strong>Schnitt: Figurbetont</strong> und eng anliegend<strong></strong> </li> <li><strong>Länge:</strong> Kurz für einen modernen Stil</li> <li><strong>Stil:</strong> Kühn und anspruchsvoll</li> </ul>
stylingtips
string<p>Das Ivanka-Kleid lässt sich selbstbewusst zu gewagten Abendveranstaltungen oder raffinierten intimen Momenten tragen. Sein glänzender Wetlook und die Spitzendetails machen es zu einem Statement-Piece, das für sich allein steht.</p> <p>Kombinieren Sie es mit goldenen oder silbernen Accessoires, um eine perfekte Harmonie zu schaffen, oder tragen Sie es mit hohen Absätzen, um seine <strong> natürliche Eleganz</strong> und seinen selbstbewussten Glamour zu unterstreichen. Vervollständigen Sie Ihren Look mit unseren <a href="https://www.divasboudoir.com/de/sexy-kleider-in-grossen-grossen/">sexy Kleidern</a> für eine gewagte Garderobe oder erkunden Sie unsere <a href="https://www.divasboudoir.com/de/grossen-grossen-sexy-set/">sexy Ensembles</a> für einen selbstbewussten Stil.</p>
summary
stringKleid in großen Größen aus Wetlook und Spitze, erhältlich bis Größe 62.
title
stringKleid Ivanka
usageinstructions
string<p>Für einen optimalen Tragekomfort ziehen Sie das Kleid sanft an und vermeiden Sie es, an der Spitze zu ziehen.</p> <p>Achten Sie darauf, dass Sie das Kleid gut anpassen, damit die Spitzendetails unterhalb der Brust perfekt positioniert sind.</p>
el
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringΕίτε φορεθεί ως εσώρουχο είτε ως σέξι σύνολο, αυτό το φόρεμα Ivanka σε wetlook και δαντέλα δεν θα αφήσει κανέναν αδιάφορο.<br /><br />Το wetlook είναι ένα ύφασμα που μοιάζει με βινύλιο, αλλά είναι πολύ πιο μαλακό και άνετο. Εδώ παρουσιάζεται σε ματ χρώμα, το οποίο μας αρέσει πολύ. Αυτό το ύφασμα έχει πάντα ένα εξομαλυντικό και ελαφρώς θωρακισμένο αποτέλεσμα στη σιλουέτα.<br /><br />Δαντέλα στα μπράτσα, κάτω από το βαθύ ντεκολτέ και στο κάτω μέρος του φορέματος.
guid
stringhttps://dev.divasboudoir.com/el/ivanka-syn-megethos-forema-mayro/drch6902.htm
highlights
string<ul> <li><strong>Ποιότητα Wet look</strong> για ένα λαμπερό, εκλεπτυσμένο αποτέλεσμα</li> <li><strong>Εκλεπτυσμένη μαύρη δαντέλα</strong> στα μανίκια, στο στρίφωμα και κάτω από το μπούστο</li> <li><strong>Καλοσχηματισμένο κόψιμο</strong> που αναδεικνύει κάθε σιλουέτα</li> <li><strong>Κοντό μήκος</strong> για μια τολμηρή, μοντέρνα εμφάνιση</li> <li><strong>Σχεδιασμός που τραβάει τα βλέμματα</strong> με σχολαστικό φινίρισμα</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringΜεγάλο φόρεμα από wetlook και δαντέλα, διαθέσιμο σε μεγέθη έως 62.
keywords
string
title
stringIvanka συν μέγεθος φόρεμα
seotitle
stringIvanka συν μέγεθος φόρεμα
seouri
stringivanka-syn-megethos-forema-mayro
specifications
string<ul> <li><strong>Υλικό</strong>: Υψηλής ποιότητας μαύρη υγρή εμφάνιση</li> <li><strong>Λεπτομέρειες</strong>: Μαύρη δαντέλα στα μανίκια, στο στρίφωμα και κάτω από το μπούστο</li> <li><strong>Κοπή:</strong> Καλοσχηματισμένο και εφαρμοστό</li> <li><strong>Μήκος :</strong> Κοντό για μοντέρνο στυλ</li> <li><strong>Στυλ:</strong> Τολμηρό και εκλεπτυσμένο</li> </ul>
stylingtips
string<p>Το φόρεμα Ivanka μπορεί να φορεθεί με αυτοπεποίθηση για τολμηρές βραδινές εξόδους ή εκλεπτυσμένες στιγμές οικειότητας. Η γυαλιστερή υγρή εμφάνιση και οι λεπτομέρειες από δαντέλα το καθιστούν ένα statement κομμάτι που στέκεται από μόνο του.</p> <p>Συνδυάστε το με χρυσά ή ασημένια αξεσουάρ για να δημιουργήσετε την τέλεια αρμονία ή φορέστε το με ψηλοτάκουνα για να τονίσετε τη <strong> φυσική κομψότητα</strong> και την αυτοπεποίθηση της αίγλης του. Ολοκληρώστε την εμφάνισή σας με τα <a href="https://www.divasboudoir.com/el/sexi-foremata-syn-megethos/">σέξι φορέματά</a> μας για μια τολμηρή γκαρνταρόμπα ή εξερευνήστε τα <a href="https://www.divasboudoir.com/el/set-megaloy-megethoys/">σέξι σύνολα</a> μας για ένα διεκδικητικό στυλ.</p>
summary
stringΜεγάλο φόρεμα από wetlook και δαντέλα, διαθέσιμο σε μεγέθη έως 62.
title
stringΦόρεμα Ivanka
usageinstructions
string<p>Για βέλτιστη άνεση, φορέστε το φόρεμα απαλά, αποφεύγοντας να τραβήξετε τη δαντέλα.</p> <p>Φροντίστε να προσαρμόσετε το φόρεμα έτσι ώστε οι λεπτομέρειες της δαντέλας κάτω από το μπούστο να είναι τέλεια τοποθετημένες.</p>
en
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringWhether worn as lingerie or a sexy outfit, this Ivanka dress in wetlook and lace will leave no one indifferent.<br /><br />Wetlook is a fabric similar in appearance to vinyl, but much softer and more comfortable. Here it's presented in matte, which we love. This fabric always has a smoothing, slightly sheathing effect on the silhouette.<br /><br />Laces on the arms, under the plunging d&eacute;collet&eacute; and at the bottom of the dress.
guid
stringhttps://dev.divasboudoir.com/en/ivanka-plus-size-dress-black/drch6902.htm
highlights
string<ul> <li><strong>Wet look quality</strong> for a shiny, sophisticated effect</li> <li><strong>Refined black lace</strong> on sleeves, hem and under bust</li> <li><strong>Shapely cut</strong> to enhance every figure</li> <li><strong>Short length</strong> for bold, modern style</li> <li><strong>Eye-catching design</strong> with meticulous finishing touches</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringPlus size dress in wetlook and lace, available up to size 62.
keywords
string
title
stringIvanka plus size dress
seotitle
stringIvanka plus size dress
seouri
stringivanka-plus-size-dress-black
specifications
string<ul> <li><strong>Material:</strong> High-quality black wet look</li> <li><strong>Details:</strong> Black lace on sleeves, hem and under bust</li> <li><strong>Cut:</strong> Shapely and fitted</li> <li><strong>Length:</strong> Short for modern style</li> <li><strong>Style:</strong> Bold and sophisticated</li> </ul>
stylingtips
string<p>The Ivanka dress can be worn with confidence for daring evenings out or sophisticated moments of intimacy. Its shiny wet look and lace details make it a statement piece that stands on its own.</p> <p>Pair it with gold or silver accessories to create the perfect harmony, or wear it with high heels to accentuate its <strong> natural elegance</strong> and assertive glamour. Complete your look with our <a href="https://www.divasboudoir.com/en/sexys-plus-size-dresses/">sexy dresses</a> for a daring wardrobe, or explore our <a href="https://www.divasboudoir.com/en/plus-size-set/">sexy ensembles</a> for an assertive style.</p>
summary
stringPlus size dress in wetlook and lace, available up to size 62.
title
stringIvanka dress
usageinstructions
string<p>For optimum comfort, gently slip on the dress, avoiding pulling on the lace.</p> <p>Be sure to adjust the dress so that the lace details under the bust are perfectly positioned.</p>
es
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringYa sea como lencería o como conjunto sexy, este vestido Ivanka de wetlook y encaje no dejará indiferente a nadie.<br /><br />El wetlook es un tejido parecido al vinilo, pero mucho más suave y cómodo. Aquí se presenta en mate, que nos gusta mucho. Este tejido siempre tiene un efecto alisador y ligeramente envolvente en la silueta.<br /><br />Encaje en los brazos, bajo el escote pronunciado y en la parte inferior del vestido.
guid
stringhttps://dev.divasboudoir.com/es/vestido-talla-grande-ivanka-negro/drch6902.htm
highlights
string<ul> <li><strong>Calidad efecto mojado</strong> para un efecto brillante y sofisticado</li> <li><strong>Refinado encaje negro</strong> en mangas, bajo y bajo el pecho</li> <li><strong>Corte estilizado</strong> que realza todas las figuras</li> <li><strong>Longitud corta</strong> para un look atrevido y moderno</li> <li><strong>Diseño llamativo</strong> con meticulosos acabados</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringVestido de talla grande en wetlook y encaje, disponible en tallas hasta la 62.
keywords
string
title
stringVestido talla grande Ivanka
seotitle
stringVestido talla grande Ivanka
seouri
stringvestido-talla-grande-ivanka-negro
specifications
string<ul> <li><strong>Material:</strong> wet look negro de alta calidad</li> <li><strong>Detalles:</strong> Encaje negro en las mangas, el bajo y debajo del pecho</li> <li><strong>Corte:</strong> Moldeado y entallado</li> <li><strong>Largo :</strong> Corto para un estilo moderno</li> <li><strong>Estilo:</strong> Atrevido y sofisticado</li> </ul>
stylingtips
string<p>El vestido Ivanka puede lucirse con confianza para salidas nocturnas atrevidas o sofisticados momentos de intimidad. Su brillante efecto mojado y sus detalles de encaje lo convierten en una pieza que destaca por sí sola.</p> <p>Combínalo con accesorios dorados o plateados para crear la armonía perfecta, o llévalo con tacones altos para acentuar su <strong> elegancia natural</strong> y su glamour asertivo. Completa tu look con nuestros <a href="https://www.divasboudoir.com/es/sexys-vestidos-talla-grande/">vestidos sexys</a> para un vestuario atrevido, o explora nuestros <a href="https://www.divasboudoir.com/es/connunto-sexy-talla-grande/">conjuntos sexys</a> para un estilo asertivo.</p>
summary
stringVestido de talla grande en wetlook y encaje, disponible en tallas hasta la 62.
title
stringVestido Ivanka
usageinstructions
string<p>Para un confort óptimo, deslice el vestido suavemente, evitando tirar del encaje.</p> <p>Asegúrese de ajustar el vestido para que los detalles de encaje bajo el pecho queden perfectamente colocados.</p>
fr
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>La robe Ivanka incarne l'audace sophistiqu&eacute;e avec son wet look noir brillant sublim&eacute; par des d&eacute;tails de dentelle noire exceptionnels. Ce <strong>design pens&eacute; pour toutes les silhouettes</strong> se distingue par sa coupe galbante qui <strong>&eacute;pouse parfaitement les formes</strong> avec &eacute;l&eacute;gance.</p> <p>Les&nbsp;<strong>finitions soign&eacute;es et raffin&eacute;es</strong> de dentelle sur les manches, l'ourlet et sous la poitrine cr&eacute;ent un v&eacute;ritable accroche-regard qui apporte une <strong>&eacute;l&eacute;gance naturelle et sophistiqu&eacute;e</strong>.</p> <p>Cette robe courte au style audacieux offre un&nbsp;<strong>confort optimal</strong> gr&acirc;ce &agrave; ses <strong>mati&egrave;res douces et respirantes</strong>. Un mod&egrave;le si r&eacute;ussi qu'il serait presque dommage de le porter uniquement en intimit&eacute; !</p>
guid
stringhttps://dev.divasboudoir.com/fr/robe-ivanka-wet-look-dentelle-grande-taille/drch6902.htm
highlights
string<ul> <li><strong>Wet look de qualit&eacute;</strong> pour un effet brillant et sophistiqu&eacute;</li> <li><strong>Dentelle noire raffin&eacute;e</strong> sur manches, ourlet et sous la poitrine</li> <li><strong>Coupe galbante</strong> qui sublime et valorise toutes les silhouettes</li> <li><strong>Longueur courte</strong> pour un style audacieux et moderne</li> <li><strong>Design accroche-regard</strong> avec finitions soign&eacute;es</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringRobe Ivanka grande taille wet look noir avec dentelle. Coupe galbante, manches dentelle, style audacieux et sophistiqué. Livraison discrète.
keywords
string
title
stringRobe Ivanka wet look dentelle grande taille | Diva's Boudoir
seotitle
stringRobe Ivanka grande taille - Wet look dentelle noire
seouri
stringrobe-ivanka-wet-look-dentelle-grande-taille
specifications
string<ul> <li><strong>Mati&egrave;re :</strong> Wet look noir de qualit&eacute; sup&eacute;rieure</li> <li><strong>D&eacute;tails :</strong> Dentelle noire sur manches, ourlet et sous poitrine</li> <li><strong>Coupe :</strong> Galbante et ajust&eacute;e</li> <li><strong>Longueur :</strong> Courte pour un style moderne</li> <li><strong>Style :</strong> Audacieux et sophistiqu&eacute;</li> </ul>
stylingtips
string<p>La robe Ivanka se porte avec assurance pour des soir&eacute;es audacieuses ou des moments d'intimit&eacute; sophistiqu&eacute;s. Son wet look brillant et ses d&eacute;tails de dentelle en font une pi&egrave;ce statement qui se suffit &agrave; elle-m&ecirc;me.</p> <p>Associez-la &agrave; des accessoires dor&eacute;s ou argent&eacute;s pour cr&eacute;er une harmonie parfaite, ou portez-la avec des talons hauts pour accentuer son&nbsp;<strong>&eacute;l&eacute;gance naturelle</strong> et son c&ocirc;t&eacute; glamour assum&eacute;. Compl&eacute;tez votre look avec nos <a href="https://www.divasboudoir.com/fr/robes-sexys-grande-taille/">robes sexy</a> pour une garde-robe audacieuse, ou explorez nos <a href="https://www.divasboudoir.com/fr/ensemble-grande-taille/">ensembles sexy</a> pour un style assum&eacute;.</p>
summary
string<p>D&eacute;couvrez la robe Ivanka, une cr&eacute;ation audacieuse en wet look noir qui sublime courbes g&eacute;n&eacute;reuses avec ses d&eacute;tails de dentelle raffin&eacute;s.</p> <p>Un mod&egrave;le galbant qui s'adapte &agrave; toutes les morphologies avec sophistication et sensualit&eacute;.</p>
title
stringRobe Ivanka - Wet Look et Dentelle noire
usageinstructions
string<p>Pour un confort optimal, enfilez d&eacute;licatement la robe en &eacute;vitant de tirer sur la dentelle.&nbsp;</p> <p>Veillez &agrave; bien ajuster la robe pour que les d&eacute;tails de dentelle sous la poitrine soient parfaitement positionn&eacute;s.</p>
it
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringChe sia indossato come lingerie o come completo sexy, questo abito Ivanka in wetlook e pizzo non lascerà nessuno indifferente.<br /><br />Il wetlook è un tessuto che assomiglia al vinile, ma è molto più morbido e confortevole. Qui è presentato in versione opaca, che ci piace molto. Questo tessuto ha sempre un effetto levigante e leggermente inguainante sulla silhouette.<br /><br />Pizzo sulle braccia, sotto la scollatura e sul fondo dell'abito.
guid
stringhttps://dev.divasboudoir.com/it/abito-ivanka-taglia-grande-nero/drch6902.htm
highlights
string<ul> <li><strong>Qualità wet look</strong> per un effetto lucido e sofisticato</li> <li><strong>Raffinato pizzo nero</strong> su maniche, orlo e sotto il seno</li> <li><strong>Taglio sagomato</strong> che valorizza ogni figura</li> <li><strong>Lunghezza corta</strong> per un look audace e moderno</li> <li><strong>Design accattivante</strong> con rifiniture curate nei minimi dettagli</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringAbito di taglia grande in wetlook e pizzo, disponibile in taglie fino alla 62.
keywords
string
title
stringAbito Ivanka taglia grande
seotitle
stringAbito Ivanka taglia grande
seouri
stringabito-ivanka-taglia-grande-nero
specifications
string<ul> <li><strong>Materiale:</strong> Nero di alta qualità, effetto bagnato</li> <li><strong>Dettagli:</strong> pizzo nero su maniche, orlo e sotto il seno</li> <li><strong>Taglio:</strong> Sagomato e aderente</li> <li><strong>Lunghezza:</strong> corta per uno stile moderno</li> <li><strong>Stile:</strong> audace e sofisticato</li> </ul>
stylingtips
string<p>L'abito Ivanka può essere indossato con disinvoltura per serate audaci o per sofisticati momenti di intimità. Il suo aspetto lucido e bagnato e i suoi dettagli in pizzo lo rendono un pezzo forte che si fa notare da solo.</p> <p>Abbinatelo ad accessori dorati o argentati per creare un'armonia perfetta, oppure indossatelo con tacchi alti per accentuare la sua <strong> naturale eleganza</strong> e il suo glamour sicuro. Completate il vostro look con i nostri <a href="https://www.divasboudoir.com/it/abiti-sexys-taglia-grande/">abiti sexy</a> per un guardaroba audace, o esplorate i nostri <a href="https://www.divasboudoir.com/it/set-taglia-grande/">ensemble sexy</a> per uno stile deciso.</p>
summary
stringAbito di taglia grande in wetlook e pizzo, disponibile in taglie fino alla 62.
title
stringAbito Ivanka
usageinstructions
string<p>Per un comfort ottimale, infilare l'abito delicatamente, evitando di tirare il pizzo.</p> <p>Assicurarsi di regolare l'abito in modo che i dettagli in pizzo sotto il seno siano perfettamente posizionati.</p>
nl
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringOf het nu gedragen wordt als lingerie of als sexy outfit, deze Ivanka jurk in wetlook en kant zal niemand onverschillig laten.<br /><br />Wetlook is een stof die op vinyl lijkt, maar veel zachter en comfortabeler is. Hier is het uitgevoerd in mat, wat we erg mooi vinden. Deze stof heeft altijd een gladmakend en lichtjes omhullend effect op het silhouet.<br /><br />Kant op de armen, onder de diepe halslijn en onderaan de jurk.
guid
stringhttps://dev.divasboudoir.com/nl/ivanka-jurk-groote-maat-zwart/drch6902.htm
highlights
string<ul> <li><strong>Wet look kwaliteit</strong> voor een glanzend, geraffineerd effect</li> <li><strong>Geraffineerd zwart kant</strong> op de mouwen, zoom en onder de buste</li> <li><strong>Mooi model</strong> dat elk figuur benadrukt</li> <li><strong>Korte lengte</strong> voor een gedurfde, moderne look</li> <li><strong>Opvallend ontwerp</strong> met zorgvuldige afwerking</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringGroote maat jurk in wetlook en kant, verkrijgbaar in maten tot 62.
keywords
string
title
stringIvanka jurk groote maat
seotitle
stringIvanka jurk groote maat
seouri
stringivanka-jurk-groote-maat-zwart
specifications
string<ul> <li><strong>Materiaal:</strong> Hoogwaardige zwarte wetlook</li> <li><strong>Details:</strong> Zwart kant op mouwen, zoom en onder buste</li> <li><strong>Snit:</strong> Aansluitend en getailleerd</li> <li><strong>Lengte :</strong> Kort voor een moderne stijl</li> <li><strong>Stijl:</strong> Gedurfd en geraffineerd</li> </ul>
stylingtips
string<p>De Ivanka jurk kan met vertrouwen gedragen worden voor gewaagde avondjes uit of verfijnde momenten van intimiteit. De glanzende wetlook en kanten details maken het een statement stuk dat op zichzelf staat.</p> <p>Combineer het met gouden of zilveren accessoires om de perfecte harmonie te creëren, of draag het met hoge hakken om de <strong> natuurlijke elegantie</strong> en assertieve glamour te accentueren. Maak je look compleet met onze <a href="https://www.divasboudoir.com/nl/sexys-jurken-grote-maat/">sexy jurken</a> voor een gedurfde garderobe, of ontdek onze <a href="https://www.divasboudoir.com/nl/groote-maat-set/">sexy ensembles</a> voor een assertieve stijl.</p>
summary
stringGroote maat jurk in wetlook en kant, verkrijgbaar in maten tot 62.
title
stringIvanka jurk
usageinstructions
string<p>Voor optimaal comfort moet je de jurk voorzichtig aantrekken en niet aan het kant trekken.</p> <p>Zorg ervoor dat je de jurk zo aanpast dat de kanten details onder de buste perfect zitten.</p>
pt
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringQuer seja usado como lingerie ou como um conjunto sexy, este vestido Ivanka em wetlook e renda não deixará ninguém indiferente.<br /><br />O Wetlook é um tecido que se assemelha ao vinil, mas é muito mais macio e confortável. Aqui é apresentado em mate, o que nos agrada bastante. Este tecido tem sempre um efeito de alisamento e de ligeira bainha na silhueta.<br /><br />Renda nos braços, por baixo do decote e na parte inferior do vestido.
guid
stringhttps://dev.divasboudoir.com/pt/vestido-ivanka-plus-size-preto/drch6902.htm
highlights
string<ul> <li><strong>Qualidade de aspeto húmido</strong> para um efeito brilhante e sofisticado</li> <li><strong>Renda preta refinada</strong> nas mangas, na bainha e por baixo do busto</li> <li><strong>Corte elegante</strong> que realça qualquer figura</li> <li><strong>Comprimento curto</strong> para um look arrojado e moderno</li> <li><strong>Design apelativo</strong> com toques de acabamento meticulosos</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringVestido grande em wetlook e renda, disponível em tamanhos até 62.
keywords
string
title
stringVestido Ivanka plus size
seotitle
stringVestido Ivanka plus size
seouri
stringvestido-ivanka-plus-size-preto
specifications
string<ul> <li><strong>Material:</strong> tecido húmido preto de alta qualidade</li> <li><strong>Detalhes:</strong> Renda preta nas mangas, bainha e sob o busto</li> <li><strong>Corte:</strong> Formoso e ajustado</li> <li><strong>Comprimento:</strong> Curto para um estilo moderno</li> <li><strong>Estilo:</strong> Arrojado e sofisticado</li> </ul>
stylingtips
string<p>O vestido Ivanka pode ser usado com confiança para noites ousadas ou momentos sofisticados de intimidade. O seu aspeto molhado brilhante e os detalhes em renda fazem dele uma peça de afirmação que se destaca por si só.</p> <p>Combine-o com acessórios dourados ou prateados para criar a harmonia perfeita, ou use-o com saltos altos para acentuar a sua <strong> elegância natural</strong> e glamour assertivo. Complete o seu look com os nossos <a href="https://www.divasboudoir.com/pt/vestidos-sexys-plus-size/">vestidos sensuais</a> para um guarda-roupa ousado, ou explore os nossos <a href="https://www.divasboudoir.com/pt/connunto-sexy-plus-size/">conjuntos sensuais</a> para um estilo assertivo.</p>
summary
stringVestido grande em wetlook e renda, disponível em tamanhos até 62.
title
stringVestido Ivanka
usageinstructions
string<p>Para um conforto ótimo, vista o vestido com cuidado, evitando puxar a renda.</p> <p>Certifique-se de que ajusta o vestido de modo a que os pormenores de renda sob o busto fiquem perfeitamente posicionados.</p>
fetishboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
latexboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
legsboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
lustboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
smboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringOb als Dessous oder sexy Outfit, dieses Ivanka-Kleid aus Wetlook und Spitze wird niemanden unberührt lassen.<br /><br />Wetlook ist ein Stoff, der äußerlich Vinyl ähnelt, aber viel weicher und bequemer ist. Hier wird er in matt präsentiert, was uns sehr gut gefällt. Dieser Stoff hat immer einen glättenden und leicht formenden Effekt auf die Silhouette.<br /><br />Spitze an den Armen, unter dem plosierenden Ausschnitt und im unteren Teil des Kleides.
highlights
string<ul> <li><strong>Wetlook-Fetisch</strong> für einen raffinierten Glanzeffekt</li> <li><strong>Raffinierte schwarze Spitze</strong> an Ärmeln, Saum und unter der Brust</li> <li><strong>Figurformender Schnitt</strong>, der jede Figur umschmeichelt und aufwertet</li> <li><strong>Kurze Länge</strong> für einen kühnen, modernen Stil</li> <li><strong>Eyecatcher-Design</strong> mit sorgfältigen Abschlüssen</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringKleid in Übergröße aus Wetlook und Spitze, erhältlich bis Größe 62. Die Referenz für Fetisch-Lingerie im Web. Bis Größe 62.
keywords
string
title
stringKleid in Übergröße Ivanka - BDSM-Outfit
seotitle
stringLederkleid Ivanka
seouri
stringlederkleid-ivanka-schwarz
specifications
string<ul> <li><strong>Material:</strong> Hochwertiger schwarzer Wetlook</li> <li><strong>Details:</strong> Schwarze Spitze an Ärmeln, Saum und Unterbrust</li> <li><strong>Schnitt: Figurbetont</strong> und eng anliegend<strong></strong> </li> <li><strong>Länge:</strong> Kurz für einen modernen Stil</li> <li><strong>Stil:</strong> Fetischistisch und anspruchsvoll</li> </ul>
stylingtips
string<p>Das Kleid Ivanka etabliert sich als Highlight in der Fetischwelt und eignet sich perfekt für gewagte Partys oder raffinierte Rollenspiele. Sein glänzender Wetlook und die Spitzendetails machen es zu einer idealen Wahl, um Ihre dominante oder unterwürfige Seite auf elegante Weise zu betonen.</p> <p>Kombinieren Sie es mit Accessoires aus Leder oder Metall, um eine perfekte Harmonie zu schaffen, oder tragen Sie es mit hohen Absätzen, um seine selbstbewusste glamouröse Seite zu unterstreichen.</p>
summary
stringKleid in großen Größen aus elastischem Kunstleder und Spitze, erhältlich bis Größe 62.
title
stringKleid Ivanka große Größe
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringΕίτε φορεθεί ως εσώρουχο είτε ως σέξι ρούχο, αυτό το φόρεμα Ivanka σε wetlook και δαντέλα δεν θα αφήσει κανέναν αδιάφορο.<br /><br />Το wetlook είναι ένα ύφασμα που μοιάζει με βινύλιο, αλλά είναι πολύ πιο μαλακό και άνετο. Εδώ παρουσιάζεται σε ματ χρώμα, το οποίο μας αρέσει πολύ. Αυτό το ύφασμα έχει πάντα ένα εξομαλυντικό και ελαφρώς θωρακισμένο αποτέλεσμα στη σιλουέτα.<br /><br />Δαντέλα στα μπράτσα, κάτω από το βαθύ ντεκολτέ και στο κάτω μέρος του φορέματος.
highlights
string<ul> <li><strong>Wet look fetish</strong> για ένα λαμπερό, εκλεπτυσμένο αποτέλεσμα</li> <li><strong>Εκλεπτυσμένη μαύρη δαντέλα</strong> στα μανίκια, το στρίφωμα και κάτω από το μπούστο</li> <li><strong>Καλοσχηματισμένο κόψιμο</strong> που αναδεικνύει κάθε σιλουέτα</li> <li><strong>Κοντό μήκος</strong> για μια τολμηρή, μοντέρνα εμφάνιση</li> <li><strong>Σχεδιασμός που τραβάει τα βλέμματα</strong> με σχολαστικό φινίρισμα</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringΜεγάλο φόρεμα από wetlook και δαντέλα, διαθέσιμο μέχρι το νούμερο 62. Το σημείο αναφοράς για εσώρουχα φετίχ στο διαδίκτυο. Διαθέσιμο μέχρι το μέγεθος 62.
keywords
string
title
stringIvanka plus size φόρεμα - Tenue BDSM
seotitle
stringΔερμάτινο φόρεμα Ivanka
seouri
stringdermatino-forema-ivanka-mayro
specifications
string<ul> <li><strong>Υλικό</strong>: Υψηλής ποιότητας μαύρη υγρή εμφάνιση</li> <li><strong>Λεπτομέρειες</strong>: Μαύρη δαντέλα στα μανίκια, στο στρίφωμα και κάτω από το μπούστο</li> <li><strong>Κοπή:</strong> Καλοσχηματισμένο και εφαρμοστό</li> <li><strong>Μήκος :</strong> Κοντό για μοντέρνο στυλ</li> <li><strong>Στυλ :</strong> Φετίχ και εκλεπτυσμένο</li> </ul>
stylingtips
string<p>Το φόρεμα Ivanka είναι ένα βασικό κομμάτι στον κόσμο του φετίχ, ιδανικό για τολμηρές βραδιές ή εκλεπτυσμένα παιχνίδια ρόλων. Η γυαλιστερή υγρή του εμφάνιση και οι λεπτομέρειες από δαντέλα το καθιστούν ιδανική επιλογή για να επιβεβαιώσετε με κομψότητα την κυρίαρχη ή υποτακτική πλευρά σας.</p> <p>Συνδυάστε το με δερμάτινα ή μεταλλικά αξεσουάρ για να δημιουργήσετε την τέλεια αρμονία ή φορέστε το με ψηλοτάκουνα για να τονίσετε την υποτιθέμενη αίγλη του.</p>
summary
stringΨηλό φόρεμα από ελαστικό faux δέρμα και δαντέλα, διαθέσιμο μέχρι το νούμερο 62.
title
stringIvanka συν μέγεθος φόρεμα
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringWhether worn as lingerie or a sexy outfit, this Ivanka dress in wetlook and lace will leave no one indifferent.<br /><br />Wetlook is a fabric similar in appearance to vinyl, but much softer and more comfortable. Here it's presented in matte, which we love. This fabric always has a smoothing, slightly sheathing effect on the silhouette.<br /><br />Laces on the arms, under the plunging d&eacute;collet&eacute; and at the bottom of the dress.
highlights
string<ul> <li><strong>Wet look fetish</strong> for a shiny, sophisticated effect</li> <li><strong>Refined black lace</strong> on sleeves, hem and under bust</li> <li><strong>Shapely cut</strong> to enhance every figure</li> <li><strong>Short length</strong> for bold, modern style</li> <li><strong>Eye-catching design</strong> with meticulous finishing touches</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringPlus size dress in wetlook and lace, available up to size 62. The web's reference for fetish lingerie. Up to size 62.
keywords
string
title
stringIvanka plus size dress - BDSM attire
seotitle
stringIvanka leather dress
seouri
stringivanka-leather-dress-black
specifications
string<ul> <li><strong>Material:</strong> High-quality black wet look</li> <li><strong>Details:</strong> Black lace on sleeves, hem and under bust</li> <li><strong>Cut:</strong> Shapely and fitted</li> <li><strong>Length:</strong> Short for modern style</li> <li><strong>Style:</strong> Fetishistic and sophisticated</li> </ul>
stylingtips
string<p>The Ivanka dress is a must-have in the fetish world, perfect for daring parties or sophisticated role-playing. Its shiny wet look and lace details make it an ideal choice for asserting your dominant or submissive side with elegance.</p> <p>Pair it with leather or metal accessories to create the perfect harmony, or wear it with high heels to accentuate its assertive glamour.</p>
summary
stringPlus size dress in stretch leatherette and lace, available up to size 62.
title
stringIvanka plus size dress
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringYa sea como lencería o como conjunto sexy, este vestido Ivanka de wetlook y encaje no dejará indiferente a nadie.<br /><br />El wetlook es un tejido parecido al vinilo, pero mucho más suave y cómodo. Aquí se presenta en mate, que nos gusta mucho. Este tejido siempre tiene un efecto alisador y ligeramente envolvente en la silueta.<br /><br />Encaje en los brazos, bajo el escote pronunciado y en la parte inferior del vestido.
highlights
string<ul> <li><strong>Fetiche de efecto mojado</strong> para un efecto brillante y sofisticado</li> <li><strong>Refinado encaje negro</strong> en mangas, bajo y bajo el pecho</li> <li><strong>Corte moldeado</strong> que realza todas las figuras</li> <li><strong>Longitud corta</strong> para un look atrevido y moderno</li> <li><strong>Diseño llamativo</strong> con meticulosos acabados</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringVestido talla grande en wetlook y encaje, disponible hasta la talla 62. La referencia de lencería fetichista en la web. Disponible hasta la talla 62.
keywords
string
title
stringVestido talla grande Ivanka - Tenue BDSM
seotitle
stringVestido de cuero Ivanka
seouri
stringvestido-de-cuero-ivanka-negro
specifications
string<ul> <li><strong>Material:</strong> wet look negro de alta calidad</li> <li><strong>Detalles:</strong> Encaje negro en mangas, bajo y bajo el pecho</li> <li><strong>Corte:</strong> Moldeado y entallado</li> <li><strong>Largo :</strong> Corto para un estilo moderno</li> <li><strong>Estilo :</strong> Fetichista y sofisticado</li> </ul>
stylingtips
stringGrote maten lingerie uitverkoop: tot 85% korting | Diva's Boudoir
summary
stringVestido talla grande de piel sintética elástica y encaje, disponible hasta la talla 62.
title
stringVestido talla grande Ivanka
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>La robe Ivanka incarne l'audace f&eacute;tichiste avec son wet look noir brillant sublim&eacute; par des d&eacute;tails de dentelle noire exceptionnels. Ce <strong>design pens&eacute; pour toutes les silhouettes</strong> se distingue par sa coupe galbante qui <strong>&eacute;pouse parfaitement les formes</strong> avec &eacute;l&eacute;gance.</p> <p>Les&nbsp;<strong>finitions soign&eacute;es et raffin&eacute;es</strong> de dentelle sur les manches, l'ourlet et sous la poitrine cr&eacute;ent un v&eacute;ritable accroche-regard qui apporte une <strong>&eacute;l&eacute;gance naturelle et sophistiqu&eacute;e</strong>.</p> <p>Cette robe courte au style audacieux offre un&nbsp;<strong>confort optimal</strong> gr&acirc;ce &agrave; ses <strong>mati&egrave;res douces et respirantes</strong>. Un mod&egrave;le si r&eacute;ussi qu'il transcende l'intimit&eacute; pour s'affirmer dans l'univers f&eacute;tichiste avec sophistication.</p>
highlights
string<ul> <li><strong>Wet look f&eacute;tichiste</strong> pour un effet brillant et sophistiqu&eacute;</li> <li><strong>Dentelle noire raffin&eacute;e</strong> sur manches, ourlet et sous la poitrine</li> <li><strong>Coupe galbante</strong> qui sublime et valorise toutes les silhouettes</li> <li><strong>Longueur courte</strong> pour un style audacieux et moderne</li> <li><strong>Design accroche-regard</strong> avec finitions soign&eacute;es</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringRobe grande taille Ivanka wet look fétichiste avec dentelle noire. Coupe galbante, style audacieux, parfaite pour l'univers BDSM. Livraison discrète.
keywords
string
title
stringRobe grande taille Ivanka wet look fétichiste dentelle | The BDSM Boudoir
seotitle
stringRobe Grande Taille Ivanka wet look fétichiste - Dentelle noire sensuelle
seouri
stringrobe-grande-taille-ivanka-wet-look-fetichiste-dentelle
specifications
string<ul> <li><strong>Mati&egrave;re :</strong> Wet look noir de qualit&eacute; sup&eacute;rieure</li> <li><strong>D&eacute;tails :</strong> Dentelle noire sur manches, ourlet et sous poitrine</li> <li><strong>Coupe :</strong> Galbante et ajust&eacute;e</li> <li><strong>Longueur :</strong> Courte pour un style moderne</li> <li><strong>Style :</strong> F&eacute;tichiste et sophistiqu&eacute;</li> </ul>
stylingtips
string<p>La robe Ivanka s'affirme comme une pi&egrave;ce phare de l'univers f&eacute;tichiste, parfaite pour des soir&eacute;es audacieuses ou des jeux de r&ocirc;les sophistiqu&eacute;s. Son wet look brillant et ses d&eacute;tails de dentelle en font un choix id&eacute;al pour affirmer votre c&ocirc;t&eacute; dominant ou soumis avec &eacute;l&eacute;gance.</p> <p>Associez-la &agrave; des accessoires en cuir ou m&eacute;tal pour cr&eacute;er une harmonie parfaite, ou portez-la avec des talons hauts pour accentuer son c&ocirc;t&eacute; glamour assum&eacute;.&nbsp;</p>
summary
string<p>D&eacute;couvrez la robe Ivanka, une cr&eacute;ation audacieuse en wet look noir qui incarne l'esprit f&eacute;tichiste avec ses d&eacute;tails de dentelle raffin&eacute;s.</p> <p>Un mod&egrave;le galbant qui sublime toutes les silhouettes avec sophistication et sensualit&eacute; assum&eacute;e.</p>
title
stringRobe Ivanka - Wet Look Fétichiste et Dentelle noire
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringChe sia indossato come lingerie o come completo sexy, questo abito Ivanka in wetlook e pizzo non lascerà nessuno indifferente.<br /><br />Il wetlook è un tessuto che assomiglia al vinile, ma è molto più morbido e confortevole. Qui è presentato in versione opaca, che ci piace molto. Questo tessuto ha sempre un effetto levigante e leggermente inguainante sulla silhouette.<br /><br />Pizzo sulle braccia, sotto la scollatura e sul fondo dell'abito.
highlights
string<ul> <li><strong>Feticcio wet look</strong> per un effetto lucido e sofisticato</li> <li><strong>Raffinato pizzo nero</strong> su maniche, orlo e sotto il seno</li> <li><strong>Taglio sagomato</strong> che valorizza ogni figura</li> <li><strong>Lunghezza corta</strong> per un look audace e moderno</li> <li><strong>Design accattivante</strong> con rifiniture meticolose</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringAbito di taglia grande in wetlook e pizzo, disponibile fino alla taglia 62. Il riferimento per la lingerie fetish sul web. Disponibile fino alla taglia 62.
keywords
string
title
stringAbito Ivanka taglia grande - Tenue BDSM
seotitle
stringAbito in pelle Ivanka
seouri
stringabito-in-pelle-ivanka-nero
specifications
string<ul> <li><strong>Materiale:</strong> Nero di alta qualità, effetto bagnato</li> <li><strong>Dettagli:</strong> pizzo nero su maniche, orlo e sotto il seno</li> <li><strong>Taglio:</strong> Sagomato e aderente</li> <li><strong>Lunghezza :</strong> Corto per uno stile moderno</li> <li><strong>Stile:</strong> fetish e sofisticato</li> </ul>
stylingtips
string<p>L'abito Ivanka è un pezzo chiave del mondo fetish, perfetto per serate audaci o sofisticati giochi di ruolo. Il suo aspetto lucido e bagnato e i dettagli in pizzo lo rendono una scelta ideale per affermare il vostro lato dominante o sottomesso con eleganza.</p> <p>Abbinatelo ad accessori in pelle o in metallo per creare un'armonia perfetta, oppure indossatelo con tacchi alti per accentuare il suo presunto glamour.</p>
summary
stringAbito a taglia grande in ecopelle elasticizzata e pizzo, disponibile fino alla taglia 62.
title
stringAbito Ivanka taglia grande
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringOf het nu gedragen wordt als lingerie of als sexy outfit, deze Ivanka jurk in wetlook en kant zal niemand onverschillig laten.<br /><br />Wetlook is een stof die op vinyl lijkt, maar veel zachter en comfortabeler is. Hier is het uitgevoerd in mat, wat we erg mooi vinden. Deze stof heeft altijd een gladmakend en lichtjes omhullend effect op het silhouet.<br /><br />Kant op de armen, onder de diepe halslijn en onderaan de jurk.
highlights
string<ul> <li><strong>Wet look fetisj</strong> voor een glanzend, geraffineerd effect</li> <li><strong>Geraffineerd zwart kant</strong> op de mouwen, zoom en onder de buste</li> <li><strong>Mooi model</strong> dat elk figuur benadrukt</li> <li><strong>Korte lengte</strong> voor een gedurfde, moderne look</li> <li><strong>Opvallend ontwerp</strong> met zorgvuldige afwerking</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringGrote maat jurk in wetlook en kant, verkrijgbaar tot maat 62. De referentie voor fetisjlingerie op het web. Beschikbaar tot maat 62.
keywords
string
title
stringIvanka jurk grote maat - Tenue BDSM
seotitle
stringIvanka jurk groote maat
seouri
stringivanka-jurk-groote-maat-zwart
specifications
string<ul> <li><strong>Materiaal:</strong> Hoogwaardige zwarte wetlook</li> <li><strong>Details:</strong> Zwart kant op mouwen, zoom en onder buste</li> <li><strong>Snit:</strong> Aansluitend en getailleerd</li> <li><strong>Lengte :</strong> Kort voor een moderne stijl</li> <li><strong>Stijl :</strong> Fetish en verfijnd</li> </ul>
stylingtips
string<p>De Ivanka jurk is een belangrijk stuk in de fetisjwereld, perfect voor gewaagde avondjes uit of verfijnde rollenspellen. De glanzende wetlook en kanten details maken het een ideale keuze om je dominante of onderdanige kant met elegantie te laten zien.</p> <p>Combineer het met leren of metalen accessoires om de perfecte harmonie te creëren, of draag het met hoge hakken om de veronderstelde glamour te accentueren.</p>
summary
stringGrote maat jurk van stretch imitatieleer en kant, verkrijgbaar tot maat 62.
title
stringIvanka jurk
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringQuer seja usado como lingerie ou como um conjunto sexy, este vestido Ivanka em wetlook e renda não deixará ninguém indiferente.<br /><br />O Wetlook é um tecido que se assemelha ao vinil, mas é muito mais macio e confortável. Aqui é apresentado em mate, o que nos agrada bastante. Este tecido tem sempre um efeito de alisamento e de ligeira bainha na silhueta.<br /><br />Renda nos braços, por baixo do decote e na parte inferior do vestido.
highlights
string<ul> <li><strong>Fetiche de aspeto molhado</strong> para um efeito brilhante e sofisticado</li> <li><strong>Renda preta refinada</strong> nas mangas, na bainha e por baixo do busto</li> <li><strong>Corte elegante</strong> que realça qualquer figura</li> <li><strong>Comprimento curto</strong> para um look arrojado e moderno</li> <li><strong>Design apelativo</strong> com toques de acabamento meticulosos</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringVestido grande em wetlook e renda, disponível até ao tamanho 62. A referência para lingerie fetiche na web. Disponível até ao tamanho 62.
keywords
string
title
stringVestido plus size Ivanka - Tenue BDSM
seotitle
stringVestido de couro Ivanka
seouri
stringvestido-de-couro-ivanka-preto
specifications
string<ul> <li><strong>Material:</strong> tecido húmido preto de alta qualidade</li> <li><strong>Detalhes:</strong> Renda preta nas mangas, bainha e sob o busto</li> <li><strong>Corte:</strong> Formoso e ajustado</li> <li><strong>Comprimento :</strong> Curto para um estilo moderno</li> <li><strong>Estilo :</strong> Fetiche e sofisticado</li> </ul>
stylingtips
string<p>O vestido Ivanka é uma peça-chave no mundo fetichista, perfeito para noites ousadas ou para um role-playing sofisticado. O seu aspeto molhado brilhante e os detalhes em renda fazem dele a escolha ideal para afirmar o seu lado dominante ou submisso com elegância.</p> <p>Combine-o com acessórios em pele ou metal para criar a harmonia perfeita, ou use-o com saltos altos para acentuar o seu glamour assumido.</p>
summary
stringVestido alto em pele sintética elástica e renda, disponível até ao tamanho 62.
title
stringVestido Ivanka plus size
usageinstructions
string
name
stringWetlook-Kleid 27151471051
netweight
string
nextshipment
stringtomorrow
ordered
number20
orderidx
number0
origin
string
originalsize
string
packaging
number1
productshipment
stringauto
productuid
stringFCBD8028-95CA-4C9D-A601BD8C4928EBE5
promountil
string
rating
stringnone
recorduid
stringFCBD8028-95CA-4C9D-A601BD8C4928EBE5
reference
stringDRCH6902
related
string
reserved
number1
returned
number0
returnsallowed
number1
section
stringcabaret
shipment
string4to6days
showbrand
number0
sizeinfos
Query
Template: /system/api/product/sizes.cfc:20
Execution Time: 1.54 ms
Record Count: 9
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_sizes.id_size as recorduid, if(intlsize <> '',intlsize,eusize) as size, if(intlsize <> '','intlsize','eusize') as sizetype,
product_variations.color,
if(product_sizes.sizegroup = 'bra',
if(intlsize <> '', cast(intlsize as SIGNED ), cast(eusize as SIGNED ))
,
SUBSTRING_INDEX(intlsize,'-',1)
) as param1,
if(product_sizes.sizegroup = 'bra',
if(intlsize <> '',
MID(intlsize,length(cast(intlsize as SIGNED ))+1,length(intlsize)),
MID(eusize,length(cast(eusize as SIGNED ))+1,length(eusize))
)
,
SUBSTRING_INDEX(intlsize,'-',-1)
) as param2,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as available,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
999999,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as groupavailable,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
product_sizes.gender, product_sizes.sizerange, product_sizes.sizegroup, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize,
product_sizes.bust, product_sizes.waist, product_sizes.hip, product_sizes.underbust, product_sizes.cup, product_sizes.thigh, product_sizes.legheight, product_sizes.bodyheight, product_sizes.bodyweight
from product_sizes
left outer join product_variations on product_sizes.suppliersize = product_variations.size and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
where FIND_IN_SET(product_sizes.id_size,'2052,896,895,898,897,900,899,901,902') > 0
and product_variations.productuid = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5'
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
12052L+intlsizeblackL+L+-19999990wplusskirtXLL+42-4412-1416-1844-4644-4642-4448-5044-4642-4498-10582-85105-108
2895XL+intlsizeblackXL+XL+-19999990wplusskirtXLXL+48-5018-2022-2650-5250-5248-5054-5650-5248-50113-11896-102117-121
38972XL+intlsizeblack2XL+2XL+-19999990wplusskirt2XL2XL+52-5422-2426-3054-5654-5652-5458-6054-5652-54125-130109-114127-132
48993XL+intlsizeblack3XL+3XL+-19999990wplusskirt3XL3XL+56-5826-2830-3258-6056-6056-5862-6458-6056-58137-142122-128138-144
59024XL+intlsizeblack4XL+4XL+-19999990wplusskirt4XL4XL+60-6230-3234-3662-6462-6460-6266-6862-6460-52149-154135-140151-156
6896XLintlsizeblackXLXL-19999990wplusskirtXLXL44-4614-1618-2046-4846-4844-4650-5246-4844-46107-11291-95113-116
78982XLintlsizeblack2XL2XL-19999990wplusskirt2XL2XL50-5220-2224-2652-5452-5450-5256-5852-5450-52119-124103-108122-126
89003XLintlsizeblack3XL3XL-19999990wplusskirt3XL3XL54-5624-2628-3056-5856-5854-5660-6256-5854-56131-136115-121133-138
99014XLintlsizeblack4XL4XL-19999990wplusskirt4XL4XL58-6028-3032-3460-6260-6258-6064-6660-6258-60143-148129-134145-150
sizeranges
stringplus
sizes
string2052,896,895,898,897,900,899,901,902
sizetype
stringauto
specifications
Struct
Entries: 23
belly
string
bones
string
bra
string
breasts
string
bust
string
closing
string
crochtless
string
cups
string
cut
string
garter
string
halter
string
lacing
string
lining
string
modestypanel
string
panty
string
sheathing
string
sleeves
string
stocking
string
straps
string
stretch
string
suspenders
string
transparency
string
underwires
string
stock
number0
stocks
Query
Template: /system/api/product/stocks.cfc:25
Execution Time: 58.3 ms
Record Count: 4
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select * from (
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5'
and product_variations.isactive = 1
and product_sizes.id_size = 2052
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5'
and product_variations.isactive = 1
and product_sizes.id_size = 896
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5'
and product_variations.isactive = 1
and product_sizes.id_size = 895
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5'
and product_variations.isactive = 1
and product_sizes.id_size = 898
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5'
and product_variations.isactive = 1
and product_sizes.id_size = 897
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5'
and product_variations.isactive = 1
and product_sizes.id_size = 900
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5'
and product_variations.isactive = 1
and product_sizes.id_size = 899
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5'
and product_variations.isactive = 1
and product_sizes.id_size = 901
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5'
and product_variations.isactive = 1
and product_sizes.id_size = 902
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
) tbl
group by productuid, variationuid, stockuid
order by stockuid, FIELD(gender,'w','m'), sizegroup, FIELD(intlsize,'XS','S','S/M','S-M','M','M/L','M-L','L','L-XL','L/XL','XL','0X','0XL','lXL','1X','1X-2X','1X/2X','XL/2XL','XL-2XL','1XL-2XL','2XL','2X','XXL','2X-3X','2X/3X','2XL-3XL','2XL/3XL','XXXL','3XL','3X','3X-4X','3X/4X','3XL-4XL','3XL/4XL','4XL','5XL','5X','5X-6X','5X/6X','5XL-6XL','5XL/6XL','6XL','6X','7XL','7X','8XL','8X'), cast(intlsize as SIGNED ), color
productuidvariationuidrecorduidcolorhexvaluesuppliersizeintlsizeincheseusizeussizeuksizefrsizeessizedesizeitsizeptsizeelsizegendersizegroupcupsizesizetypeitempriceitempromopromoUntilstockuidwarehouseontourpackagingsupplierreservedorderedreturneddefectmanufacturerreferenceeanavailablestockdisplaycomments
1FCBD8028-95CA-4C9D-A601BD8C4928EBE54281121E-0716-48B6-80A483BE6541CCCB2052black#000000XLL+42-4412-1416-1844-4644-4642-4448-5044-4642-44wskirtL+intlsize41.6250STOCK01001-111100271514710514024144298112-10all
2FCBD8028-95CA-4C9D-A601BD8C4928EBE5084B4717-AD35-49A9-97F547396B46CB47898black#0000002XL2XL50-5220-2224-2652-5452-5450-5256-5852-5450-52wskirt2XLintlsize41.6250STOCK01000-10600271514710614024144298129-10all
3FCBD8028-95CA-4C9D-A601BD8C4928EBE5FA03B49F-572C-4974-9AF12084EAF568BD900black#0000003XL3XL54-5624-2628-3056-5856-5854-5660-6256-5854-56wskirt3XLintlsize41.6250STOCK01000-10300271514710714024144298136-10all
4FCBD8028-95CA-4C9D-A601BD8C4928EBE53A5D3395-C332-45AB-A4FF857F1BEA835C901black#0000004XL4XL58-6028-3032-3460-6260-6258-6064-6660-6258-60wskirt4XLintlsize41.6250STOCK01000-10600271514710814024144298143-10all
subcategory
stringall
supplier
number-1
supplierreference
string27151471051
tags
stringnoirdesir
themes
stringdark
totalvariations
number5
type
stringdefault
unitprice
number41.625
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 14.7 ms
Record Count: 9
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5' 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5' 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5' 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5' 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5' 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5' 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5'
and product_variations.isactive = 1
and product_sizes.id_size = 2052
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5' 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5' 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5' 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5' 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5' 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5' 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5'
and product_variations.isactive = 1
and product_sizes.id_size = 896
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5' 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5' 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5' 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5' 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5' 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5' 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5'
and product_variations.isactive = 1
and product_sizes.id_size = 895
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5' 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5' 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5' 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5' 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5' 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5' 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5'
and product_variations.isactive = 1
and product_sizes.id_size = 898
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5' 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5' 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5' 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5' 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5' 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5' 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5'
and product_variations.isactive = 1
and product_sizes.id_size = 897
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5' 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5' 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5' 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5' 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5' 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5' 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5'
and product_variations.isactive = 1
and product_sizes.id_size = 900
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5' 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5' 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5' 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5' 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5' 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5' 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5'
and product_variations.isactive = 1
and product_sizes.id_size = 899
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5' 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5' 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5' 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5' 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5' 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5' 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5'
and product_variations.isactive = 1
and product_sizes.id_size = 901
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5' 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5' 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5' 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5' 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5' 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5' 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 = 'FCBD8028-95CA-4C9D-A601BD8C4928EBE5'
and product_variations.isactive = 1
and product_sizes.id_size = 902
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
order by FIELD(gender,'w','m'), sizegroup, FIELD(intlsize,'XS','S','S/M','S-M','M','M/L','M-L','L','L-XL','L/XL','XL','0X','0XL','lXL','1X','1X-2X','1X/2X','XL/2XL','XL-2XL','1XL-2XL','2XL','2X','XXL','2X-3X','2X/3X','2XL-3XL','2XL/3XL','XXXL','3XL','3X','3X-4X','3X/4X','3XL-4XL','3XL/4XL','4XL','5XL','5X','5X-6X','5X/6X','5XL-6XL','5XL/6XL','6XL','6X','7XL','7X','8XL','8X'), cast(intlsize as SIGNED ), color
variationuidrecorduidcolorhexvaluesuppliersizeintlsizeincheseusizeussizeuksizefrsizeessizedesizeitsizeptsizeelsizegendersizegroupcupsizesizetypeitempriceitempromopromoUntilstockuidwarehouseontourpackagingsupplierreservedorderedreturneddefectmanufacturerreferenceeanavailablestockavailablepersizestockpersizeavailablepercolorstockpercolorhaspromounitpricedisplaycomments
14281121E-0716-48B6-80A483BE6541CCCB2052black#000000XLL+42-4412-1416-1844-4644-4642-4448-5044-4642-44wskirtL+intlsize41.6250STOCK01001-111100271514710514024144298112-10-10-10041.625all
24281121E-0716-48B6-80A483BE6541CCCB895black#000000XLXL+48-5018-2022-2650-5250-5248-5054-5650-5248-50wskirtXL+intlsize41.6250STOCK01001-111100271514710514024144298112-10-10-10041.625all
3084B4717-AD35-49A9-97F547396B46CB47897black#0000002XL2XL+52-5422-2426-3054-5654-5652-5458-6054-5652-54wskirt2XL+intlsize41.6250STOCK01000-10600271514710614024144298129-10-10-10041.625all
4FA03B49F-572C-4974-9AF12084EAF568BD899black#0000003XL3XL+56-5826-2830-3258-6056-6056-5862-6458-6056-58wskirt3XL+intlsize41.6250STOCK01000-10300271514710714024144298136-10-10-10041.625all
53A5D3395-C332-45AB-A4FF857F1BEA835C902black#0000004XL4XL+60-6230-3234-3662-6462-6460-6266-6862-6460-52wskirt4XL+intlsize41.6250STOCK01000-10600271514710814024144298143-10-10-10041.625all
64281121E-0716-48B6-80A483BE6541CCCB896black#000000XLXL44-4614-1618-2046-4846-4844-4650-5246-4844-46wskirtXLintlsize41.6250STOCK01001-111100271514710514024144298112-10-10-10041.625all
7084B4717-AD35-49A9-97F547396B46CB47898black#0000002XL2XL50-5220-2224-2652-5452-5450-5256-5852-5450-52wskirt2XLintlsize41.6250STOCK01000-10600271514710614024144298129-10-10-10041.625all
8FA03B49F-572C-4974-9AF12084EAF568BD900black#0000003XL3XL54-5624-2628-3056-5856-5854-5660-6256-5854-56wskirt3XLintlsize41.6250STOCK01000-10300271514710714024144298136-10-10-10041.625all
93A5D3395-C332-45AB-A4FF857F1BEA835C901black#0000004XL4XL58-6028-3032-3460-6260-6258-6064-6660-6258-60wskirt4XLintlsize41.6250STOCK01000-10600271514710814024144298143-10-10-10041.625all
vatrate
number20
warehouse
number0