My cart

❌
Total items
View basket
Menu
See sizes
Black dress with asymmetrical slit - Cocktail elegance and sensuality
Double-click to enlarge
SKU: CDBU1722
Black dress with asymmetrical slit - Cocktail elegance and sensuality
Stock:

This black dress reveals your elegance with its close-fitting cut and side slit.

The lace embellished neckline and asymmetrical hemline create a sophisticated cocktail look.

Adjustable straps and a bare back add a sensual touch that enhances your silhouette.

Highlights

  • Flattering, modern fit
  • Side slit reveals leg in style
  • Décolleté adorned with lace for refined femininity
  • Asymmetrical hem with sophisticated voile finish
  • Slim, adjustable straps for optimum support
  • Bare back with elegant criss-cross straps
  • Versatile midi length for cocktails and evenings
  • Perfect fit for all body types
Size:

Not sure which size to choose? See our size guide

Color:
Quantity:
34.95 €
Fast shipping
for the impatient...
Help and advice
by chat, facebook or e-mail
Free returns
within 15 days *

Plus Size Asymmetric Slit Black Dress - Cocktail Elegance

Product description

This black dress is the epitome of modern elegance, with a close-fitting cut that enhances generous curves. The side slit subtly reveals your leg, creating the sophisticated allure that characterizes successful cocktail outfits.

The lace embellished neckline adds that touch of femininity that sets this dress apart from conventional models. This finish reveals your taste for refined details while retaining that timeless elegance.

The asymmetrical hem with its voile finish creates that modern dimension that transforms your silhouette. This studied design brings that graceful movement that reveals your personality with contemporary sophistication.

The slim, adjustable straps ensure optimum support that perfectly hugs your shape. The halterneck with crossed straps reveals your back with the sensuality that characterizes your personal style.

This midi length offers the perfect versatility between cocktail chic and evening glamour. Stretch fabrics harmoniously embrace all body shapes, guaranteeing the comfort that accompanies you throughout your special events.

Technical details

  • Style: Modern asymmetrical cocktail dress
  • Cut: Flattering and fitted close to the body
  • Décolleté: Embellished with refined feminine lace
  • Slit : Side slit reveals leg with style
  • Hem: Asymmetrical, sophisticated voile finish
  • Straps: Thin adjustable straps for optimum support
  • Back: Nude with elegant crossed straps
  • Length: Versatile midi cocktail evening

Available sizes

Available from 4X to 3X

Available color

Black

Sizing guide

Check the right size for you

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

Care instructions

  • Hand wash in cold water to preserve fabrics
  • Use a mild detergent without bleaching agents
  • Dry flat away from direct light
  • avoid spin-drying to maintain shape
  • Iron at low temperature if necessary
  • Hang on a hanger to avoid wrinkles

Usage tips

Slip on this dress, adjusting the straps to your body shape for perfect support.

The body-hugging cut naturally adapts to your shape to create this elegant silhouette.

This dress reveals your sophistication with the modern sensuality that turns every appearance into a memorable moment.

To Top
View basket
Items
Total items
Struct
Entries: 108
actions
Array
available
number1
brand
stringdivasfashion
brandcode
stringdvqc
branding
stringdivasboudoir
brandmedias
string{"default":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"editorial":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"logo":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""}}
brandmetas
Struct
de
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
el
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
en
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
es
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
fr
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
it
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
nl
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
pt
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
brandname
stringDiva's Fashion
breasts
stringna
careinstructions
string
categories
stringdivasboudoir.cabaret.dresses.all
category
stringdresses
categorygender
stringf
categorymediadatas
Struct
adult
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string615
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/cabaret/dresses1.jpg
type
stringimg
width
string1336
divasboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
fetishboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
latexboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
legsboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
lustboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
private
Struct
height
string1016
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/private/default.jpg
type
stringimg
width
string703
smboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
categorysizerange
stringauto
colorinfos
Query
Template: /system/api/product/colors.cfc:13
Execution Time: 0.729 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1blackcolorblakblackblack#00000011
colorrange
stringblack
colors
stringblack
colortype
stringcolor
comments
string
compositions
Struct
Entries: 13
coton
string
elastane
string
free
string
leather
string
lycra
string
metal
string
nylon
string
polyamide
string
polyester
string
polyurethane
string
silk
string
spandex
string
viscose
string
datecreated
Date Time (Europe/Paris)
{ts '2025-06-04 12:22:52'}
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
booleanfalse
hasusageinstructions
booleantrue
hasvariations
booleantrue
import
string
inpromo
number0
instockvariations
number5
isactive
number1
iscustommade
number0
isdivasize
number0
isfirstprice
number0
isfixedprice
number0
ishot
number0
isnew
number0
isonline
number0
isoutletprice
number0
itemprice
number29.125
itempromo
string
key
stringsz2412057319121359
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-08-22 18:21:25'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.642 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('1ddcea9c-946a-48e2-9aa3cc02e3ed81a3',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.35 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 <> 'CDBU1722'
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
string1003
isprivate
string0
rating
stringall
src
string/photobank/products/dvqc/cdbu1722/robe-sexy-grande-taille.jpg
type
stringimg
width
string694
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string1012
isprivate
string0
rating
stringall
src
string/photobank/products/dvqc/cdbu1722/robe-sexy-grande-taille1.jpg
type
stringimg
width
string700
variations
Struct
colors
Struct
black
Struct
height
string1012
isprivate
string0
rating
stringall
src
string/photobank/products/dvqc/cdbu1722/robe-sexy-grande-taille1.jpg
type
stringimg
width
string700
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
mediagallery
string
metadatas
Struct
darkboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
divasboudoir
Struct
de
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Handwäsche mit kaltem Wasser, um das Gewebe zu schonen</li> <li>Verwenden Sie ein mildes Waschmittel ohne Bleichmittel</li> <li>Trocknen Sie das Kleidungsstück liegend und vor direktem Licht geschützt</li> <li>vermeiden Sie Schleudern, um die Form zu erhalten</li> <li>Bei niedriger Temperatur bügeln, wenn nötig</li> <li>Auf Bügel hängen, um Falten zu vermeiden</li> </ul>
description
string<p>Dieses schwarze Kleid verkörpert moderne Eleganz mit seinem körpernahen Schnitt, der die üppigen <strong>Kurven betont</strong>. Der Seitenschlitz enthüllt Ihr Bein auf subtile Weise und sorgt für den raffinierten Look, der ein gelungenes Cocktail-Outfit auszeichnet.<br><br>Das mit Spitze verzierte Dekollet&eacute; verleiht diesem Kleid den femininen Touch, der es von herkömmlichen Modellen unterscheidet. Diese Verarbeitung offenbart Ihre Vorliebe für raffinierte Details und bewahrt gleichzeitig diese zeitlose Eleganz.<br><br><strong>Der asymmetrische Saum</strong> mit Voile-Finish schafft diese moderne Dimension, die Ihre Silhouette verwandelt. Das durchdachte Design sorgt für eine anmutige Bewegung, die Ihre Persönlichkeit mit dieser zeitgemäßen Raffinesse zum Ausdruck bringt.<br><br>Die schmalen, verstellbaren Träger sorgen für einen optimalen Halt, der sich perfekt an Ihre Formen anpasst. Der Neckholder mit gekreuzten Trägern enthüllt Ihren Rücken mit dieser selbstbewussten Sinnlichkeit, die Ihren persönlichen Stil kennzeichnet.<br><br>Die Midi-Länge bietet diese perfekte Vielseitigkeit zwischen schickem Cocktail und glamourösem Abend. Die dehnbaren Stoffe passen sich harmonisch an jede Körperform an und garantieren diesen Komfort, der Sie während Ihrer privilegierten Veranstaltungen begleitet.</p>
guid
stringhttps://dev.divasboudoir.com/de/sexy-kleider-schwarz/cdbu1722.htm
highlights
string<ul> <li>Schmeichelnder, moderner, körpernaher Schnitt</li> <li>Seitenschlitz enthüllt stilvoll das Bein</li> <li>Mit Spitze verziertes Dekollet&eacute; für raffinierte Weiblichkeit</li> <li>Asymmetrischer Saum mit raffiniertem Voile-Finish</li> <li>Schmale, verstellbare Träger für optimalen Halt</li> <li>Neckholder mit eleganten, überkreuzten Trägern</li> <li>Vielseitige Midi-Länge Cocktail und Abendveranstaltung</li> <li>Perfekte Passform passt sich jeder Körperform an</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringSchwarzes Kleid in Übergröße mit asymmetrischem Schlitz, Spitzenausschnitt, Neckholder, gekreuzten Trägern und Schleiersaum. Schmeichelnde Passform Eleganter Cocktail. Diva's Boudoir.
keywords
string
title
stringSchwarzes Kleid Große Größe Asymmetrischer Schlitz | Elegante Cocktailkleider | Diva's Boudoir
seotitle
stringSchwarzes Kleid Grosse Grösse Asymmetrischer Schlitz - Eleganz Cocktail
seouri
stringsexy-kleider-schwarz
specifications
string<ul> <li>Stil: Modernes Cocktailkleid mit asymmetrischem Schlitz</li> <li>Schnitt: Schmeichelnder, eng anliegender Körpernaher Schnitt</li> <li>Ausschnitt: Mit Spitze verziert Raffinierte Weiblichkeit</li> <li>Schlitz : Seitlich enthüllt Bein mit Stil</li> <li>Saum: Asymmetrischer Saum mit raffiniertem Voile-Finish</li> <li>Träger: Dünne, verstellbare Träger mit optimalem Halt</li> <li>Rücken: Nackt mit eleganten Kreuzträgern</li> <li>Länge: Midi Vielseitig Cocktail Abend</li> </ul>
stylingtips
string
summary
string<p>Dieses schwarze Kleid enthüllt Ihre Eleganz mit seinem körpernahen Schnitt und dem Seitenschlitz.</p> <p>Das mit Spitze verzierte Dekollet&eacute; und der asymmetrische Saum sorgen für <strong>einen raffinierten Cocktail-Look</strong>.</p> <p>Die verstellbaren Träger und der Neckholder sorgen für den <strong>sinnlichen Touch</strong>, der Ihre Silhouette betont.</p>
title
stringSchwarzes Kleid Asymmetrischer Schlitz - Cocktail-Eleganz und Sinnlichkeit
usageinstructions
string<p>Ziehen Sie dieses Kleid an und stellen Sie die Träger entsprechend Ihrer Körperform ein, um einen perfekten Sitz zu gewährleisten.</p> <p>Der körpernahe Schnitt passt sich auf natürliche Weise Ihren Formen an und schafft so diese elegante Silhouette.</p> <p>Dieses Kleid enthüllt Ihre Raffinesse mit dieser modernen Sinnlichkeit, die jeden Auftritt zu einem unvergesslichen Moment macht.</p>
el
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Πλύνετε στο χέρι με κρύο νερό για να διατηρήσετε τα υφάσματα</li> <li>Χρησιμοποιήστε ήπιο απορρυπαντικό χωρίς λευκαντικούς παράγοντες</li> <li>Στεγνώστε σε επίπεδη επιφάνεια μακριά από το άμεσο φως</li> <li>αποφύγετε το στύψιμο για να διατηρήσετε το σχήμα σας</li> <li>Σιδερώστε σε χαμηλή θερμοκρασία εάν είναι απαραίτητο</li> <li>Κρεμάστε σε κρεμάστρα για να αποφύγετε τις τσαλακώσεις</li> </ul>
description
string<p>Αυτό το μαύρο φόρεμα είναι η επιτομή της σύγχρονης κομψότητας, με κόψιμο σε στενή γραμμή που <strong>αναδεικνύει τις γενναιόδωρες καμπύλες</strong>. Το πλαϊνό σκίσιμο αποκαλύπτει διακριτικά το πόδι σας, δημιουργώντας την εκλεπτυσμένη εμφάνιση που χαρακτηρίζει τα επιτυχημένα κοκτέιλ σύνολα.<br><br>Η διακοσμημένη με δαντέλα λαιμόκοψη προσθέτει εκείνη την πινελιά θηλυκότητας που κάνει αυτό το φόρεμα να ξεχωρίζει από τα συμβατικά μοντέλα. Αυτό το τελείωμα αποκαλύπτει το γούστο σας για εκλεπτυσμένες λεπτομέρειες, διατηρώντας παράλληλα αυτή τη διαχρονική κομψότητα.<br><br><strong>Το ασύμμετρο στρίφωμα</strong> με το φινίρισμα voile δημιουργεί αυτή τη μοντέρνα διάσταση που μεταμορφώνει τη σιλουέτα σας. Αυτό το μελετημένο σχέδιο παρέχει αυτή τη χαριτωμένη κίνηση που αποκαλύπτει την προσωπικότητά σας με σύγχρονη εκλέπτυνση.<br><br>Οι λεπτές, ρυθμιζόμενες τιράντες παρέχουν βέλτιστη στήριξη που αγκαλιάζει τέλεια το σχήμα σας. Η λαιμόκοψη με τις σταυρωτές τιράντες αποκαλύπτει την πλάτη σας με τον αισθησιασμό που χαρακτηρίζει το προσωπικό σας στυλ.<br><br>Αυτό το μίντι μήκος προσφέρει την τέλεια ευελιξία μεταξύ ενός κομψού κοκτέιλ πάρτι και μιας λαμπερής βραδινής εξόδου. Τα ελαστικά υφάσματα εφαρμόζουν αρμονικά σε κάθε σωματότυπο, εξασφαλίζοντας άνεση καθ' όλη τη διάρκεια των ιδιαίτερων εκδηλώσεών σας.</p>
guid
stringhttps://dev.divasboudoir.com/el/sexi-foremata-mayro/cdbu1722.htm
highlights
string<ul> <li>Κολακευτική, μοντέρνα εφαρμογή</li> <li>Το πλαϊνό σκίσιμο αποκαλύπτει το πόδι με στυλ</li> <li>Ντεκολτέ με δαντέλα για εκλεπτυσμένη θηλυκότητα</li> <li>Ασύμμετρο στρίφωμα με εκλεπτυσμένο φινίρισμα voile</li> <li>Λεπτές ρυθμιζόμενες τιράντες για βέλτιστη στήριξη</li> <li>Λαιμόκοψη με κομψές τιράντες σταυρωτές</li> <li>Ευέλικτο μήκος midi για κοκτέιλ και βραδιές</li> <li>Ιδανική εφαρμογή για όλα τα σχήματα σώματος</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringΜαύρο φόρεμα μεγάλου μεγέθους με ασύμμετρο σκίσιμο, δαντελένιο ντεκολτέ, λαιμόκοψη, διασταυρωμένες τιράντες και στρίφωμα από voile. Κολακευτική εφαρμογή για ένα κομψό κοκτέιλ. Μπουντουάρ της Ντίβας.
keywords
string
title
stringΜαύρο φόρεμα Μεγάλο μέγεθος Ασύμμετρη σχισμή | Κομψό κοκτέιλ | Diva's Boudoir
seotitle
stringΜαύρο φόρεμα με μεγάλο ασύμμετρο σκίσιμο - Cocktail Elegance
seouri
stringsexi-foremata-mayro
specifications
string<ul> <li>Στυλ : Μοντέρνο ασύμμετρο κοκτέιλ φόρεμα με σκίσιμο</li> <li>Κομμένο : Κολακευτικό και εφαρμοστό κοντά στο σώμα</li> <li>Λαιμόκοψη : Στολισμένο με εκλεπτυσμένη θηλυκή δαντέλα</li> <li>Κοπή : Αποκαλύπτει το πόδι στο πλάι με στυλ</li> <li>Hem : Ασύμμετρο με εκλεπτυσμένο φινίρισμα voile</li> <li>Ιμάντες: Λεπτοί ρυθμιζόμενοι ιμάντες για βέλτιστη στήριξη</li> <li>Πλάτη: Γυμνή με κομψές τιράντες σταυρωτές</li> <li>Μήκος: Ευέλικτο μίντι κοκτέιλ βραδινό</li> </ul>
stylingtips
string
summary
string<p>Αυτό το μαύρο φόρεμα αναδεικνύει την κομψότητά σας με το εφαρμοστό κόψιμο και το πλαϊνό σκίσιμο.</p> <p>Η διακοσμημένη με δαντέλα λαιμόκοψη και το ασύμμετρο τελείωμα δημιουργούν <strong>μια εκλεπτυσμένη κοκτέιλ εμφάνιση.</strong></p> <p>Οι ρυθμιζόμενες τιράντες και ο αχλαδινός λαιμός προσθέτουν μια <strong>αισθησιακή πινελιά</strong> που αναδεικνύει τη σιλουέτα σας.</p>
title
stringΑσύμμετρο μαύρο φόρεμα με σκίσιμο - Κοκτέιλ κομψότητα και αισθησιασμός
usageinstructions
string<p>Φορέστε αυτό το φόρεμα, προσαρμόζοντας τις τιράντες στο σχήμα του σώματός σας για τέλεια στήριξη.</p> <p>Το κόψιμο που αγκαλιάζει το σώμα προσαρμόζεται φυσικά στο σχήμα σας για να δημιουργήσει αυτή την κομψή σιλουέτα.</p> <p>Αυτό το φόρεμα αποκαλύπτει τη φινέτσα σας με έναν σύγχρονο αισθησιασμό που μετατρέπει κάθε σας εμφάνιση σε μια αξέχαστη στιγμή.</p>
en
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Hand wash in cold water to preserve fabrics</li> <li>Use a mild detergent without bleaching agents</li> <li>Dry flat away from direct light</li> <li>avoid spin-drying to maintain shape</li> <li>Iron at low temperature if necessary</li> <li>Hang on a hanger to avoid wrinkles</li> </ul>
description
string<p>This black dress is the epitome of modern elegance, with a close-fitting cut that <strong>enhances generous curves</strong>. The side slit subtly reveals your leg, creating the sophisticated allure that characterizes successful cocktail outfits.<br><br>The lace embellished neckline adds that touch of femininity that sets this dress apart from conventional models. This finish reveals your taste for refined details while retaining that timeless elegance.<br><br><strong>The asymmetrical hem</strong> with its voile finish creates that modern dimension that transforms your silhouette. This studied design brings that graceful movement that reveals your personality with contemporary sophistication.<br><br>The slim, adjustable straps ensure optimum support that perfectly hugs your shape. The halterneck with crossed straps reveals your back with the sensuality that characterizes your personal style.<br><br>This midi length offers the perfect versatility between cocktail chic and evening glamour. Stretch fabrics harmoniously embrace all body shapes, guaranteeing the comfort that accompanies you throughout your special events.</p>
guid
stringhttps://dev.divasboudoir.com/en/sexy-dresses-black/cdbu1722.htm
highlights
string<ul> <li>Flattering, modern fit</li> <li>Side slit reveals leg in style</li> <li>D&eacute;collet&eacute; adorned with lace for refined femininity</li> <li>Asymmetrical hem with sophisticated voile finish</li> <li>Slim, adjustable straps for optimum support</li> <li>Bare back with elegant criss-cross straps</li> <li>Versatile midi length for cocktails and evenings</li> <li>Perfect fit for all body types</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringPlus-size black dress with asymmetrical slit, lace décolleté, bare back, crossed straps, voile hem. Flattering cocktail cut. Diva's Boudoir.
keywords
string
title
stringBlack Dress Plus Size Asymmetric Slit | Elegant Cocktail | Diva's Boudoir
seotitle
stringPlus Size Asymmetric Slit Black Dress - Cocktail Elegance
seouri
stringsexy-dresses-black
specifications
string<ul> <li>Style: Modern asymmetrical cocktail dress</li> <li>Cut: Flattering and fitted close to the body</li> <li>D&eacute;collet&eacute;: Embellished with refined feminine lace</li> <li>Slit : Side slit reveals leg with style</li> <li>Hem: Asymmetrical, sophisticated voile finish</li> <li>Straps: Thin adjustable straps for optimum support</li> <li>Back: Nude with elegant crossed straps</li> <li>Length: Versatile midi cocktail evening</li> </ul>
stylingtips
string
summary
string<p>This black dress reveals your elegance with its close-fitting cut and side slit.</p> <p>The lace embellished neckline and asymmetrical hemline create <strong>a sophisticated cocktail look.</strong></p> <p>Adjustable straps and a bare back add a <strong>sensual touch</strong> that enhances your silhouette.</p>
title
stringBlack dress with asymmetrical slit - Cocktail elegance and sensuality
usageinstructions
string<p>Slip on this dress, adjusting the straps to your body shape for perfect support.</p> <p>The body-hugging cut naturally adapts to your shape to create this elegant silhouette.</p> <p>This dress reveals your sophistication with the modern sensuality that turns every appearance into a memorable moment.</p>
es
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavar a mano en agua fría para preservar los tejidos</li> <li>Utilizar un detergente suave sin blanqueantes</li> <li>Secar en plano y lejos de la luz directa</li> <li>evite el centrifugado para mantener la forma</li> <li>Planchar a baja temperatura si es necesario</li> <li>Colgar en una percha para evitar arrugas</li> </ul>
description
string<p>Este vestido negro es el epítome de la elegancia moderna, con un corte ceñido que <strong>realza las curvas generosas</strong>. La abertura lateral revela sutilmente la pierna, creando el look sofisticado que caracteriza a los conjuntos de cóctel de éxito.<br><br>El escote adornado con encaje añade ese toque de feminidad que diferencia a este vestido de los estilos convencionales. Este acabado revela tu gusto por los detalles refinados, conservando al mismo tiempo esa elegancia atemporal.<br><br><strong>El dobladillo asimétrico</strong> con acabado de gasa crea esa dimensión moderna que transforma su silueta. Este estudiado diseño proporciona ese movimiento grácil que revela su personalidad con sofisticación contemporánea.<br><br>Los tirantes finos y ajustables proporcionan una sujeción óptima que se adapta perfectamente a su silueta. El escote halterneck con tirantes entrecruzados revela tu espalda con la sensualidad que caracteriza tu estilo personal.<br><br>Este largo midi ofrece la versatilidad perfecta entre un cóctel chic y una salida nocturna glamurosa. Los tejidos elásticos se adaptan armoniosamente a todas las formas del cuerpo, garantizando la comodidad durante todos sus eventos especiales.</p>
guid
stringhttps://dev.divasboudoir.com/es/vestido-sexy-negro/cdbu1722.htm
highlights
string<ul> <li>Corte moderno y favorecedor</li> <li>Abertura lateral que deja ver la pierna con estilo</li> <li>Escote adornado con encaje para una feminidad refinada</li> <li>Dobladillo asimétrico con sofisticado acabado de gasa</li> <li>Tirantes finos ajustables para una sujeción óptima</li> <li>Cuello halterneck con elegantes tirantes entrecruzados</li> <li>Largo midi versátil para cócteles y noches</li> <li>Ajuste perfecto para todas las formas</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringVestido negro de talla grande con abertura asimétrica, escote de encaje, cuello halterneck, tirantes cruzados y bajo de gasa. Corte favorecedor para un cóctel elegante. Diva's Boudoir.
keywords
string
title
stringVestido negro talla grande asimétrico | Cocktail elegante | Diva's Boudoir
seotitle
stringVestido negro talla grande asimétrico - Cocktail Elegance
seouri
stringvestido-sexy-negro
specifications
string<ul> <li>Estilo : Moderno vestido de cóctel con abertura asimétrica</li> <li>Corte : Favorecedor y ceñido al cuerpo</li> <li>Escote : Adornado con refinado encaje femenino</li> <li>Abertura : Pierna al descubierto con estilo</li> <li>Dobladillo: Asimétrico con sofisticado acabado de gasa</li> <li>Tirantes: Finos tirantes ajustables para una sujeción óptima</li> <li>Espalda: Nude con elegantes tirantes entrecruzados</li> <li>Largo: Midi de cóctel versátil</li> </ul>
stylingtips
string
summary
string<p>Este vestido negro muestra tu elegancia con su corte ceñido y abertura lateral.</p> <p>El escote adornado con encaje y el bajo asimétrico crean <strong>un sofisticado look de cóctel.</strong></p> <p>Los tirantes ajustables y el escote halterneck añaden un <strong>toque sensual</strong> que realza tu figura.</p>
title
stringVestido negro con abertura asimétrica - Elegancia y sensualidad de cóctel
usageinstructions
string<p>Ponte este vestido ajustando los tirantes a la forma de tu cuerpo para una sujeción perfecta.</p> <p>El corte ceñido al cuerpo se adapta de forma natural a tu figura para crear esta elegante silueta.</p> <p>Este vestido revela tu sofisticación con una sensualidad moderna que convierte cada aparición en un momento memorable.</p>
fr
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavage &agrave; la main &agrave; l'eau froide pour pr&eacute;server les tissus</li> <li>Utiliser une lessive douce sans agents blanchissants</li> <li>S&eacute;chage &agrave; plat &agrave; l'abri de la lumi&egrave;re directe</li> <li>&Eacute;viter l'essorage pour maintenir la forme</li> <li>Repasser &agrave; basse temp&eacute;rature si n&eacute;cessaire</li> <li>Suspendre sur cintre pour &eacute;viter les plis</li> </ul>
description
string<p>Cette robe noire incarne l'&eacute;l&eacute;gance moderne avec sa coupe pr&egrave;s du corps qui <strong>sublime courbes g&eacute;n&eacute;reuses</strong>. La fente lat&eacute;rale r&eacute;v&egrave;le votre jambe avec subtilit&eacute;, cr&eacute;ant cette allure sophistiqu&eacute;e qui caract&eacute;rise les tenues cocktail r&eacute;ussies.<br><br>Le d&eacute;collet&eacute; orn&eacute; de dentelle apporte cette touche de f&eacute;minit&eacute; qui distingue cette robe des mod&egrave;les conventionnels. Cette finition r&eacute;v&egrave;le votre go&ucirc;t pour les d&eacute;tails raffin&eacute;s tout en conservant cette &eacute;l&eacute;gance intemporelle.<br><br><strong>L'ourlet asym&eacute;trique</strong> avec sa finition voile cr&eacute;e cette dimension moderne qui transforme votre silhouette. Cette conception &eacute;tudi&eacute;e apporte ce mouvement gracieux qui r&eacute;v&egrave;le votre personnalit&eacute; avec cette sophistication contemporaine.<br><br>Les bretelles fines ajustables assurent un maintien optimal qui &eacute;pouse parfaitement vos formes. Le dos nu avec bretelles crois&eacute;es r&eacute;v&egrave;le votre dos avec cette sensualit&eacute; assum&eacute;e qui caract&eacute;rise votre style personnel.<br><br>Cette longueur midi offre cette polyvalence parfaite entre cocktail chic et soir&eacute;e glamour. Les tissus extensibles &eacute;pousent harmonieusement toutes les morphologies, garantissant ce confort qui vous accompagne tout au long de vos &eacute;v&eacute;nements privil&eacute;gi&eacute;s.</p>
guid
stringhttps://dev.divasboudoir.com/fr/robe-noire-grande-taille-fente-asymetrique-elegance-cocktail/cdbu1722.htm
highlights
string<ul> <li>Coupe pr&egrave;s du corps flatteuse et moderne</li> <li>Fente lat&eacute;rale r&eacute;v&eacute;lant la jambe avec style</li> <li>D&eacute;collet&eacute; orn&eacute; de dentelle pour une f&eacute;minit&eacute; raffin&eacute;e</li> <li>Ourlet asym&eacute;trique avec finition voile sophistiqu&eacute;e</li> <li>Bretelles fines ajustables pour un maintien optimal</li> <li>Dos nu avec bretelles crois&eacute;es &eacute;l&eacute;gantes</li> <li>Longueur midi polyvalente cocktail et soir&eacute;e</li> <li>S'adapte parfaitement &eacute;pousant toutes les morphologies</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringRobe noire grande taille fente asymétrique, décolleté dentelle, dos nu bretelles croisées, ourlet voile. Coupe flatteuse cocktail élégant. Diva's Boudoir.
keywords
string
title
stringRobe noire Grande Taille Fente Asymétrique | Cocktail Élégant | Diva's Boudoir
seotitle
stringRobe noire Grande Taille Fente Asymétrique - Élégance Cocktail
seouri
stringrobe-noire-grande-taille-fente-asymetrique-elegance-cocktail
specifications
string<ul> <li>Style : Robe cocktail fente asym&eacute;trique moderne</li> <li>Coupe : Pr&egrave;s du corps flatteuse et ajust&eacute;e</li> <li>D&eacute;collet&eacute; : Orn&eacute; dentelle f&eacute;minit&eacute; raffin&eacute;e</li> <li>Fente : Lat&eacute;rale r&eacute;v&eacute;lant jambe avec style</li> <li>Ourlet : Asym&eacute;trique finition voile sophistiqu&eacute;e</li> <li>Bretelles : Fines ajustables maintien optimal</li> <li>Dos : Nu avec bretelles crois&eacute;es &eacute;l&eacute;gantes</li> <li>Longueur : Midi polyvalente cocktail soir&eacute;e</li> </ul>
stylingtips
string
summary
string<p>Cette robe noire r&eacute;v&egrave;le votre &eacute;l&eacute;gance avec sa coupe pr&egrave;s du corps et sa fente lat&eacute;rale.</p> <p>Le d&eacute;collet&eacute; orn&eacute; de dentelle et l'ourlet asym&eacute;trique cr&eacute;ent <strong>un look cocktail sophistiqu&eacute;</strong>.</p> <p>Les bretelles ajustables et le dos nu apportent cette <strong>touche sensuelle</strong> qui sublime votre silhouette.</p>
title
stringRobe noire Fente Asymétrique - Élégance Cocktail et Sensualité
usageinstructions
string<p>Enfilez cette robe en ajustant les bretelles selon votre morphologie pour un maintien parfait.</p> <p>La coupe pr&egrave;s du corps s'adapte naturellement &agrave; vos formes pour cr&eacute;er cette silhouette &eacute;l&eacute;gante.</p> <p>Cette robe r&eacute;v&egrave;le votre sophistication avec cette sensualit&eacute; moderne qui transforme chaque apparition en moment m&eacute;morable.</p>
it
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavare a mano in acqua fredda per preservare i tessuti</li> <li>Utilizzare un detersivo delicato senza agenti sbiancanti</li> <li>Asciugare in piano lontano dalla luce diretta</li> <li>evitare la centrifuga per mantenere la forma</li> <li>Stirare a bassa temperatura se necessario</li> <li>Appendere su una gruccia per evitare le pieghe</li> </ul>
description
string<p>Questo abito nero è l'epitome dell'eleganza moderna, con un taglio aderente che <strong>esalta le curve generose</strong>. Lo spacco laterale scopre sottilmente la gamba, creando quel look sofisticato che caratterizza gli outfit da cocktail di successo.<br><br>La scollatura impreziosita dal pizzo aggiunge quel tocco di femminilità che distingue questo abito dai modelli convenzionali. Questa finitura rivela il vostro gusto per i dettagli raffinati, pur mantenendo un'eleganza senza tempo.<br><br><strong>L'orlo asimmetrico</strong> con finitura in voile crea una dimensione moderna che trasforma la silhouette. Questo design studiato offre quel movimento aggraziato che rivela la vostra personalità con raffinatezza contemporanea.<br><br>Le spalline sottili e regolabili offrono un sostegno ottimale che abbraccia perfettamente le vostre forme. Il collo alto con spalline incrociate rivela la schiena con la sensualità che caratterizza il vostro stile personale.<br><br>La lunghezza midi offre la perfetta versatilità tra un cocktail party chic e una serata glamour. I tessuti elasticizzati si adattano armoniosamente a ogni corporatura, garantendo il comfort durante i vostri eventi speciali.</p>
guid
stringhttps://dev.divasboudoir.com/it/abiti-sexy-nero/cdbu1722.htm
highlights
string<ul> <li>Vestibilità moderna e lusinghiera</li> <li>Lo spacco laterale scopre la gamba con stile</li> <li>Scollatura impreziosita da pizzo per una femminilità raffinata</li> <li>Orlo asimmetrico con sofisticata finitura in voile</li> <li>Spalline sottili regolabili per un sostegno ottimale</li> <li>Scollo a mezzaluna con eleganti spalline incrociate</li> <li>Versatile lunghezza midi per aperitivi e serate</li> <li>Vestibilità perfetta per tutte le forme del corpo</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringAbito nero di taglia grande con spacco asimmetrico, scollatura in pizzo, collo alto, spalline incrociate e orlo in voile. Vestibilità comoda per un cocktail elegante. Boudoir della Diva.
keywords
string
title
stringAbito nero Taglia grande Spacco asimmetrico | Cocktail elegante | Diva's Boudoir
seotitle
stringAbito nero Grande spacco asimmetrico - Cocktail Elegance
seouri
stringabiti-sexy-nero
specifications
string<ul> <li>Stile : moderno abito da cocktail con spacco asimmetrico</li> <li>Taglio: Lusinghiero e aderente al corpo</li> <li>Scollatura : Impreziosita da un raffinato pizzo femminile</li> <li>Spacco: Gamba scoperta lateralmente con stile</li> <li>Orlo: asimmetrico con sofisticata finitura in voile</li> <li>Spalline: spalline sottili regolabili per un sostegno ottimale</li> <li>Schiena: nuda con eleganti spalline incrociate</li> <li>Lunghezza: Versatile cocktail midi da sera</li> </ul>
stylingtips
string
summary
string<p>Questo abito nero mette in mostra la vostra eleganza grazie al taglio aderente e allo spacco laterale.</p> <p>La scollatura impreziosita da pizzo e l'orlo asimmetrico creano <strong>un sofisticato look da cocktail.</strong></p> <p>Le spalline regolabili e il collo alto aggiungono un <strong>tocco sensuale</strong> che esalta la vostra figura.</p>
title
stringAbito nero con spacco asimmetrico - Eleganza e sensualità da cocktail
usageinstructions
string<p>Indossate questo abito, regolando le spalline in base alla forma del corpo per un sostegno perfetto.</p> <p>Il taglio aderente al corpo si adatta naturalmente alle vostre forme per creare una silhouette elegante.</p> <p>Questo abito rivela la vostra raffinatezza con una sensualità moderna che trasforma ogni apparizione in un momento memorabile.</p>
nl
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Handwas in koud water om de stoffen te sparen</li> <li>Gebruik een mild wasmiddel zonder bleekmiddelen</li> <li>Plat drogen uit de buurt van direct licht</li> <li>vermijd centrifugeren om de vorm te behouden</li> <li>Indien nodig op lage temperatuur strijken</li> <li>Op een kleerhanger hangen om kreuken te voorkomen</li> </ul>
description
string<p>Deze zwarte jurk is het toppunt van moderne elegantie, met een nauwsluitende snit die <strong>royale rondingen benadrukt</strong>. De split aan de zijkant onthult subtiel je been en creëert de geraffineerde look die kenmerkend is voor geslaagde cocktailoutfits.<br><br>De met kant versierde halslijn voegt dat vleugje vrouwelijkheid toe dat deze jurk onderscheidt van conventionele stijlen. Deze afwerking onthult je smaak voor verfijnde details met behoud van die tijdloze elegantie.<br><br><strong>De asymmetrische zoom</strong> met voile afwerking creëert die moderne dimensie die je silhouet transformeert. Dit bestudeerde ontwerp zorgt voor die sierlijke beweging die je persoonlijkheid onthult met hedendaagse verfijning.<br><br>De smalle, verstelbare bandjes bieden optimale ondersteuning die je vorm perfect omhelst. De halternek met kriskrasbandjes onthult je rug met de sensualiteit die jouw persoonlijke stijl kenmerkt.<br><br>Deze midilengte biedt de perfecte veelzijdigheid tussen een chique cocktailparty en een glamoureuze avond uit. De stretchstoffen passen harmonieus bij alle lichaamsvormen en garanderen comfort tijdens al je speciale evenementen.</p>
guid
stringhttps://dev.divasboudoir.com/nl/sexy-outfit-zwart/cdbu1722.htm
highlights
string<ul> <li>Flatterende, moderne pasvorm</li> <li>Split aan de zijkant onthult het been in stijl</li> <li>Met kant versierde halslijn voor verfijnde vrouwelijkheid</li> <li>Asymmetrische zoom met geraffineerde voile afwerking</li> <li>Dunne verstelbare bandjes voor optimale ondersteuning</li> <li>Halternek met elegante kriskrasbandjes</li> <li>Veelzijdige midilengte voor cocktails en avonden</li> <li>Perfecte pasvorm voor alle lichaamsvormen</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringZwart jurkje van grote maat met asymmetrische split, kanten halslijn, halternek, gekruiste bandjes en voile zoom. Flatterende pasvorm voor een elegante cocktail. Diva's Boudoir.
keywords
string
title
stringZwarte jurk grote maat met asymmetrische split | Elegante Cocktail | Diva's Boudoir
seotitle
stringZwarte jurk grote maat met asymmetrische split - Cocktail Elegance
seouri
stringsexy-outfit-zwart
specifications
string<ul> <li>Stijl : Moderne asymmetrische cocktailjurk met split</li> <li>Snit : Flatterend en nauwsluitend</li> <li>Halslijn : Versierd met verfijnd vrouwelijk kant</li> <li>Split : Stijlvolle beenopening aan de zijkant</li> <li>Zoom: Asymmetrisch met geraffineerde voile afwerking</li> <li>Bandjes: Fijne verstelbare bandjes voor optimale ondersteuning</li> <li>Rug: Nude met elegante kriskras bandjes</li> <li>Lengte: Veelzijdige midi cocktail avond</li> </ul>
stylingtips
string
summary
string<p>Deze zwarte jurk laat je elegantie zien met zijn nauwsluitende snit en split aan de zijkant.</p> <p>De met kant versierde halslijn en asymmetrische zoomlijn creëren <strong>een geraffineerde cocktaillook.</strong></p> <p>De verstelbare bandjes en halternek geven je figuur een <strong>sensuele touch</strong>.</p>
title
stringZwarte jurk met asymmetrische split - elegante en sensuele cocktailjurk
usageinstructions
string<p>Trek deze jurk aan en pas de bandjes aan je lichaamsvorm aan voor perfecte ondersteuning.</p> <p>De nauwsluitende snit past zich op natuurlijke wijze aan je vorm aan om dit elegante silhouet te creëren.</p> <p>Deze jurk onthult je verfijning met een moderne sensualiteit die van elke verschijning een gedenkwaardig moment maakt.</p>
pt
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavar à mão em água fria para preservar os tecidos</li> <li>Utilizar um detergente suave sem agentes branqueadores</li> <li>Secar em local plano e afastado da luz direta</li> <li>evitar a secagem por centrifugação para manter a forma</li> <li>Se necessário, passar a ferro a baixa temperatura</li> <li>Pendurar num cabide para evitar vincos</li> </ul>
description
string<p>Este vestido preto é o epítome da elegância moderna, com um corte justo que <strong>realça as curvas generosas</strong>. A fenda lateral revela subtilmente a sua perna, criando o visual sofisticado que caracteriza os conjuntos de cocktail de sucesso.<br><br>O decote com renda embelezada acrescenta aquele toque de feminilidade que distingue este vestido dos estilos convencionais. Este acabamento revela o seu gosto por detalhes refinados, mantendo uma elegância intemporal.<br><br><strong>A bainha assimétrica</strong> com acabamento em voile cria essa dimensão moderna que transforma a sua silhueta. Este design estudado proporciona aquele movimento gracioso que revela a sua personalidade com sofisticação contemporânea.<br><br>As alças finas e ajustáveis proporcionam um apoio ótimo que abraça perfeitamente a sua forma. O decote haltere com alças cruzadas revela as suas costas com a sensualidade que caracteriza o seu estilo pessoal.<br><br>Este comprimento midi oferece a versatilidade perfeita entre um cocktail chique e uma saída à noite glamorosa. Os tecidos elásticos adaptam-se harmoniosamente a todas as formas do corpo, garantindo conforto durante os seus eventos especiais.</p>
guid
stringhttps://dev.divasboudoir.com/pt/vestido-sexy-preto/cdbu1722.htm
highlights
string<ul> <li>Ajuste moderno e lisonjeiro</li> <li>A fenda lateral revela a perna com estilo</li> <li>Decote com renda embelezada para uma feminilidade refinada</li> <li>Bainha assimétrica com acabamento em voile sofisticado</li> <li>Alças finas e ajustáveis para um apoio ótimo</li> <li>Halterneck com elegantes alças cruzadas</li> <li>Comprimento midi versátil para cocktails e noites</li> <li>Ajuste perfeito para todas as formas do corpo</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringVestido preto de tamanho grande com fenda assimétrica, decote em renda, haltere, alças cruzadas e bainha em voile. Um vestido lisonjeiro para um cocktail elegante. Diva's Boudoir.
keywords
string
title
stringVestido preto Tamanho grande Fenda assimétrica | Cocktail elegante | Diva's Boudoir
seotitle
stringVestido preto com fenda assimétrica grande - Cocktail Elegance
seouri
stringvestido-sexy-preto
specifications
string<ul> <li>Estilo : Vestido de cocktail moderno com fenda assimétrica</li> <li>Corte : Lisonjeador e justo junto ao corpo</li> <li>Decote : Enriquecido com renda feminina refinada</li> <li>Fenda : Perna lateral reveladora com estilo</li> <li>Bainha: Assimétrica com sofisticado acabamento em voile</li> <li>Alças: Alças finas e ajustáveis para um apoio ótimo</li> <li>Costas: Nude com elegantes alças cruzadas</li> <li>Comprimento: Versátil midi cocktail noite</li> </ul>
stylingtips
string
summary
string<p>Este vestido preto mostra a sua elegância com o seu corte justo e a sua fenda lateral.</p> <p>O decote com adornos de renda e a bainha assimétrica criam <strong>um sofisticado look de cocktail.</strong></p> <p>As alças ajustáveis e o decote haltere dão um <strong>toque sensual</strong> que realça a sua figura.</p>
title
stringVestido preto com fenda assimétrica - Cocktail Elegância e Sensualidade
usageinstructions
string<p>Vista este vestido, ajustando as alças à forma do seu corpo para um apoio perfeito.</p> <p>O corte justo ao corpo adapta-se naturalmente à sua forma para criar esta silhueta elegante.</p> <p>Este vestido revela a sua sofisticação com uma sensualidade moderna que transforma cada aparição num momento memorável.</p>
fetishboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
latexboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
legsboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
lustboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
smboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
name
stringsz2412057319121359
netweight
string
nextshipment
stringtomorrow
ordered
number1
orderidx
number0
origin
string
originalsize
string
packaging
number0
productshipment
stringauto
productuid
string1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3
promountil
string
rating
stringnone
recorduid
string1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3
reference
stringCDBU1722
related
string
reserved
number0
returned
number0
returnsallowed
number1
section
stringcabaret
shipment
string5to7days
showbrand
number0
sizeinfos
Query
Template: /system/api/product/sizes.cfc:20
Execution Time: 1.45 ms
Record Count: 5
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_sizes.id_size as recorduid, if(intlsize <> '',intlsize,eusize) as size, if(intlsize <> '','intlsize','eusize') as sizetype,
product_variations.color,
if(product_sizes.sizegroup = 'bra',
if(intlsize <> '', cast(intlsize as SIGNED ), cast(eusize as SIGNED ))
,
SUBSTRING_INDEX(intlsize,'-',1)
) as param1,
if(product_sizes.sizegroup = 'bra',
if(intlsize <> '',
MID(intlsize,length(cast(intlsize as SIGNED ))+1,length(intlsize)),
MID(eusize,length(cast(eusize as SIGNED ))+1,length(eusize))
)
,
SUBSTRING_INDEX(intlsize,'-',-1)
) as param2,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as available,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
999999,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as groupavailable,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
product_sizes.gender, product_sizes.sizerange, product_sizes.sizegroup, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize,
product_sizes.bust, product_sizes.waist, product_sizes.hip, product_sizes.underbust, product_sizes.cup, product_sizes.thigh, product_sizes.legheight, product_sizes.bodyheight, product_sizes.bodyweight
from product_sizes
left outer join product_variations on product_sizes.suppliersize = product_variations.size and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
where FIND_IN_SET(product_sizes.id_size,'2334,2335,2336,2337,2338') > 0
and product_variations.productuid = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3'
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
123384Xintlsizeblack4X4X000wplusdress4XL4X502024525250565250128-134107-112133-140
22334XLintlsizeblackXLXL111wplusdress0XLXL421216444442484442100-10779-86105-112
323351Xintlsizeblack1X1X000wplusdress1XL1X441418464644504644107-11486-93112-119
423362XLintlsizeblack2XL2XL000wplusdress2XL2XL461620484846524846114-12193-100119-126
523373Xintlsizeblack3X3X000wplusdress3XL3X481822505048545048121-128100-107126-133
sizeranges
stringplus
sizes
string2334,2335,2336,2337,2338
sizetype
stringauto
specifications
Struct
Entries: 23
belly
string
bones
string
bra
string
breasts
string
bust
string
closing
string
crochtless
string
cups
string
cut
string
garter
string
halter
string
lacing
string
lining
string
modestypanel
string
panty
string
sheathing
string
sleeves
string
stocking
string
straps
string
stretch
string
suspenders
string
transparency
string
underwires
string
stock
number1
stocks
Query
Template: /system/api/product/stocks.cfc:25
Execution Time: 23.9 ms
Record Count: 5
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select * from (
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3'
and product_variations.isactive = 1
and product_sizes.id_size = 2334
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3'
and product_variations.isactive = 1
and product_sizes.id_size = 2335
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3'
and product_variations.isactive = 1
and product_sizes.id_size = 2336
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3'
and product_variations.isactive = 1
and product_sizes.id_size = 2337
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3'
and product_variations.isactive = 1
and product_sizes.id_size = 2338
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
) tbl
group by productuid, variationuid, stockuid
order by stockuid, FIELD(gender,'w','m'), sizegroup, FIELD(intlsize,'XS','S','S/M','S-M','M','M/L','M-L','L','L-XL','L/XL','XL','0X','0XL','lXL','1X','1X-2X','1X/2X','XL/2XL','XL-2XL','1XL-2XL','2XL','2X','XXL','2X-3X','2X/3X','2XL-3XL','2XL/3XL','XXXL','3XL','3X','3X-4X','3X/4X','3XL-4XL','3XL/4XL','4XL','5XL','5X','5X-6X','5X/6X','5XL-6XL','5XL/6XL','6XL','6X','7XL','7X','8XL','8X'), cast(intlsize as SIGNED ), color
productuidvariationuidrecorduidcolorhexvaluesuppliersizeintlsizeincheseusizeussizeuksizefrsizeessizedesizeitsizeptsizeelsizegendersizegroupcupsizesizetypeitempriceitempromopromoUntilstockuidwarehouseontourpackagingsupplierreservedorderedreturneddefectmanufacturerreferenceeanavailablestockdisplaycomments
11DDCEA9C-946A-48E2-9AA3CC02E3ED81A30B94B201-D16A-4099-9A73C8C71FBF88072338black#0000004XL4X502024525250565250wdress4Xintlsize29.1250STOCK0100000100205089162E255HN064802143200all
21DDCEA9C-946A-48E2-9AA3CC02E3ED81A3F7B4CF44-CBFD-48E2-883D7F84D8A1996F2334black#0000000XLXL421216444442484442wdressXLintlsize29.1250STOCK01100000002050691611all
31DDCEA9C-946A-48E2-9AA3CC02E3ED81A33FB14C8F-E1F0-46C0-BE11A68BEBDCFDE12335black#0000001XL1X441418464644504644wdress1Xintlsize29.1250STOCK01000000002050691600all
41DDCEA9C-946A-48E2-9AA3CC02E3ED81A36377C138-F86C-4832-B76AFE5239445E6A2336black#0000002XL2XL461620484846524846wdress2XLintlsize29.1250STOCK0100000100205069162E255HN064802144200all
51DDCEA9C-946A-48E2-9AA3CC02E3ED81A3B3CAD1D3-0606-4261-899A55CC01B4089E2337black#0000003XL3X481822505048545048wdress3Xintlsize29.1250STOCK01000001002050691600all
subcategory
stringall
supplier
number0
supplierreference
stringSZ2412057319121359
tags
string
themes
string
totalvariations
number5
type
stringdefault
unitprice
number29.125
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 9.77 ms
Record Count: 5
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3'
and product_variations.isactive = 1
and product_sizes.id_size = 2334
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3'
and product_variations.isactive = 1
and product_sizes.id_size = 2335
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3'
and product_variations.isactive = 1
and product_sizes.id_size = 2336
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3'
and product_variations.isactive = 1
and product_sizes.id_size = 2337
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3'
and product_variations.isactive = 1
and product_sizes.id_size = 2338
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
order by FIELD(gender,'w','m'), sizegroup, FIELD(intlsize,'XS','S','S/M','S-M','M','M/L','M-L','L','L-XL','L/XL','XL','0X','0XL','lXL','1X','1X-2X','1X/2X','XL/2XL','XL-2XL','1XL-2XL','2XL','2X','XXL','2X-3X','2X/3X','2XL-3XL','2XL/3XL','XXXL','3XL','3X','3X-4X','3X/4X','3XL-4XL','3XL/4XL','4XL','5XL','5X','5X-6X','5X/6X','5XL-6XL','5XL/6XL','6XL','6X','7XL','7X','8XL','8X'), cast(intlsize as SIGNED ), color
variationuidrecorduidcolorhexvaluesuppliersizeintlsizeincheseusizeussizeuksizefrsizeessizedesizeitsizeptsizeelsizegendersizegroupcupsizesizetypeitempriceitempromopromoUntilstockuidwarehouseontourpackagingsupplierreservedorderedreturneddefectmanufacturerreferenceeanavailablestockavailablepersizestockpersizeavailablepercolorstockpercolorhaspromounitpricedisplaycomments
10B94B201-D16A-4099-9A73C8C71FBF88072338black#0000004XL4X502024525250565250wdress4Xintlsize29.1250STOCK0100000100205089162E255HN0648021432000011029.125all
2F7B4CF44-CBFD-48E2-883D7F84D8A1996F2334black#0000000XLXL421216444442484442wdressXLintlsize29.1250STOCK011000000020506916111111029.125all
33FB14C8F-E1F0-46C0-BE11A68BEBDCFDE12335black#0000001XL1X441418464644504644wdress1Xintlsize29.1250STOCK010000000020506916000011029.125all
46377C138-F86C-4832-B76AFE5239445E6A2336black#0000002XL2XL461620484846524846wdress2XLintlsize29.1250STOCK0100000100205069162E255HN0648021442000011029.125all
5B3CAD1D3-0606-4261-899A55CC01B4089E2337black#0000003XL3X481822505048545048wdress3Xintlsize29.1250STOCK010000010020506916000011029.125all
vatrate
number20
warehouse
number1