My cart

❌
Total items
View basket
Menu
See sizes
Body gainant noir Résille - Perfect support and seduction
Double-click to enlarge
SKU: SBBO4109
Body gainant noir Résille - Perfect support and seduction
Stock:

Discover this black sheathing bodysuit with sophisticated fishnet detailing that offers perfect support while revealing your sensuality.

With its crotch opening and versatile style, it can be worn as lingerie or as a sexy top under a dress.

Highlights

  • Sheathing effect enhances generous curves
  • Transparent fishnet details on the décolleté for a sophisticated effect
  • Central lacing for natural bust enhancement
  • Crotch opening for optimum comfort and practicality
  • Absolute versatility - sexy lingerie or trendy top
Size:

Not sure which size to choose? See our size guide

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

Plus size black fishnet body with crotch opening

Product description

This exceptional sheathing bodysuit revolutionizes your wardrobe with its dual lingerie and fashion function. Designed to fit all body types, it offers optimal support thanks to a sheathing cut that elegantly enhances generous curves.

Transparent fishnet details on the décolleté create a captivating play of transparencies, while the central lacing adds a touch of refined sensuality. The crotch opening guarantees all-day comfort without compromising aesthetic appeal. The soft, breathable fabric perfectly matches the shape, creating a harmonious silhouette.

Whether worn as intimate lingerie or as a sexy top under a dress or skirt, this design for every figure reveals your natural, sophisticated elegance.

Technical details

  • Style: Sheer bodysuit with fishnet details
  • Color: timeless black
  • Details: transparent fishnet neckline, central lacing
  • Opening: crotch for maximum practicality
  • Effect: Sheathing and sculpting
  • Usage: Lingerie or versatile sexy top

Available sizes

Available from 4X to 3X

Available colors

Black and Beige

Sizing guide

Check the right size for you

International
  • Chest
  • Size
  • Hips
4X
  • 118-126
  • 104-112
  • 128-136
1X
  • 94-104
  • 80-88
  • 102-112
2XL
  • 104-110
  • 88-96
  • 112-120
3X
  • 110-118
  • 96-104
  • 120-128

Care instructions

  • Hand wash in lukewarm water (30°C maximum) to preserve the fishnet
  • Use a mild detergent without bleach or fabric softener
  • Dry flat, out of direct sunlight
  • Do not iron directly on fishnet details
  • Store with care to avoid snags on delicate fishnet

Usage tips

This sheathing bodysuit is easy to put on thanks to its practical crotch opening. For optimum support, gently adjust the central lacing to suit your comfort. Perfect support all day long without excessive compression.

The crotch opening makes it easy to use, while retaining its aesthetic appeal. This design, conceived for every figure, adapts naturally to your morphology for a harmonious, elegant look.

Styling tips

The versatility of this bodysuit makes it an essential part of your wardrobe. Wear it as sexy lingerie for special intimate moments, or dare to wear it as a sophisticated top under a blazer jacket for a bold look.

Under a dress or skirt, it creates a perfectly sculpted silhouette while remaining invisible. Its fishnet details add a touch of mystery that is subtly revealed. Pair it with a pencil skirt for a professional look with a touch of sensuality. Complete your look with our elegant negligees for a gradual seduction, explore our sexy matching panties, or sublimate your legs with our sophisticated stockings.

To Top
View basket
Items
Total items
Struct
Entries: 108
actions
Array
available
number-1
brand
stringdivasboudoir
brandcode
stringdrdu
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 Boudoir
breasts
stringna
careinstructions
string
categories
stringdivasboudoir.lingerie.essentials.shapewear,divasboudoir.lingerie.sexylingerie.body
category
stringessentials
categorygender
stringm
categorymediadatas
Struct
adult
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string331
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/lingerie/essentials/shapewear.jpg
type
stringimg
width
string719
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: 1.18 ms
Record Count: 2
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,beige') > 0
and product_variations.productuid = '8368959F-8F8F-4F72-8D2CF608CF07D3AB'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1blackcolorblakblackblack#000000-10
2beigecolorbeigbeigebrown#F6DBAC-10
colorrange
stringbrown
colors
stringblack,beige
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-08-17 18:26:27'}
defect
number0
dimensions
Struct
Entries: 14
acrylicbones
string
backsideheight
string
diameter
string
flatsteelbones
string
frontsideheight
string
fullheight
string
length
string
modestysize
string
panels
string
sides
string
spiralsteelbones
string
totallength
string
unit
stringcm
wiresize
string
display
stringall
displayfrom
string
displayto
string
grossweight
string
hasbrandinfos
booleanfalse
hascareinstructions
booleantrue
hascolorinfos
booleantrue
hascompositions
booleanfalse
hasdescription
booleantrue
hasdimensions
booleanfalse
hasmaterials
booleanfalse
hasotherspecifications
booleanfalse
haspromo
number0
hasshortdescription
booleantrue
hassizeinfos
booleantrue
hasspecifications
booleantrue
hasstockinfos
booleanfalse
hasstylingtips
booleantrue
hasusageinstructions
booleantrue
hasvariations
booleantrue
import
string
inpromo
number0
instockvariations
string
isactive
number1
iscustommade
number0
isdivasize
number0
isfirstprice
number0
isfixedprice
number0
ishot
number0
isnew
number0
isonline
number0
isoutletprice
number0
itemprice
number29.125
itempromo
string
key
stringsi25031467773083946-body-gainant
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-10-31 11:40:50'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 1.08 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('8368959f-8f8f-4f72-8d2cf608cf07d3ab',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.75 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 <> 'SBBO4109'
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
string2048
isprivate
string0
rating
stringall
src
string/photobank/products/drdu/sbbo4109/body_gainant_grande_taille.jpg
type
stringimg
width
string1417
back
Struct
height
string1989
isprivate
string0
rating
stringall
src
string/photobank/products/drdu/sbbo4109/body_gainant_noir.jpg
type
stringimg
width
string1376
default
Struct
height
string1781
isprivate
string0
rating
stringall
src
string/photobank/products/drdu/sbbo4109/body_gainant_isa.jpg
type
stringimg
width
string1232
variations
Struct
colors
Struct
beige
Struct
height
string1764
isprivate
string0
rating
stringall
src
string/photobank/products/drdu/sbbo4109/body_gainant_grande_taille_chair.jpg
type
stringimg
width
string1220
black
Struct
height
string1989
isprivate
string0
rating
stringall
src
string/photobank/products/drdu/sbbo4109/body_gainant_noir.jpg
type
stringimg
width
string1376
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
stringproducts.divasboudoir.sbbo4109
metadatas
Struct
darkboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
divasboudoir
Struct
de
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Handwäsche in lauwarmem Wasser (maximal 30&deg;C), um das Netzgewebe zu schonen</li> <li>Verwenden Sie ein mildes Waschmittel ohne Bleichmittel oder Weichspüler</li> <li>Flach trocknen, vor direkter Sonneneinstrahlung schützen</li> <li>Nicht direkt über die Netzdetails bügeln</li> <li>Sorgfältig aufbewahren, um ein Hängenbleiben auf dem empfindlichen Netzmaterial zu vermeiden</li> </ul>
description
string<p>Dieser außergewöhnliche formende Body revolutioniert Ihre Garderobe mit seiner Doppelfunktion als Lingerie und Mode. Er wurde so entworfen, dass er <strong>sich jeder Körperform an</strong>passt und bietet dank seines formenden Schnitts <strong>optimalen Halt</strong>, der <strong>großzügige Kurven</strong> elegant betont.</p> <p>Die <strong>transparenten Netzdetails</strong> am Dekollet&eacute; sorgen für ein fesselndes Spiel mit Transparenzen, während die <strong>zentrale Schnürung</strong> einen raffinierten Hauch von Sinnlichkeit verleiht. Die <strong>Öffnung im Schritt</strong> garantiert <strong>den ganzen Tag über optimalen Tragekomfort</strong>, ohne die Ästhetik zu beeinträchtigen. Die <strong>weichen, atmungsaktiven Materialien</strong> passen sich perfekt an die Formen an und schaffen eine harmonische Silhouette.</p> <p>Dieses <strong>Design, das für alle Figuren gedacht</strong> ist, enthüllt Ihre <strong> natürliche und raffinierte Eleganz</strong>, egal ob Sie es als intime Unterwäsche oder als sexy Oberteil unter einem Kleid oder Rock tragen.</p>
guid
stringhttps://dev.divasboudoir.com/de/body-schwarz/sbbo4109.htm
highlights
string<ul> <li><strong>Umhüllende Wirkung</strong>, die großzügige Kurven betont</li> <li><strong>Transparente Netzdetails</strong> am Dekollet&eacute; für einen raffinierten Effekt</li> <li><strong>Zentrale Schnürung</strong>, die die Brust natürlich betont</li> <li><strong>Öffnung im Schritt</strong> für optimalen Komfort und Zweckmäßigkeit</li> <li><strong>Absolute Vielseitigkeit</strong> - sexy Dessous oder trendiges Oberteil</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringSchwarzer, formender Body in großen Größen mit Netzdetails und Öffnung im Schritt. Perfekter Halt, vielseitig einsetzbar für Lingerie/Mode. Kostenlose Lieferung ab 59€. Diva's Boudoir.
keywords
string
title
stringBody Gainant Grande Taille schwarz Netz | Diva's Boudoir
seotitle
stringBody in Übergröße, umhüllend, schwarz, Netz, Öffnung im Schritt
seouri
stringbody-schwarz
specifications
string<ul> <li><strong>Stil: Formgebender</strong> Body mit Netzdetails</li> <li><strong>Farbe:</strong> zeitloses Schwarz</li> <li><strong>Details:</strong> Transparentes Netz am Dekollet&eacute;, zentrale Schnürung</li> <li><strong>Öffnung:</strong> Im Schritt für optimale Praktikabilität<strong></strong> </li> <li><strong>Wirkung:</strong> Straffend und formend</li> <li><strong>Verwendung:</strong> Dessous oder vielseitiges sexy Oberteil</li> </ul>
stylingtips
string<p>Die Vielseitigkeit dieses Bodys macht ihn zu einem unverzichtbaren Teil Ihrer Garderobe. Tragen Sie ihn als sexy Dessous für besondere intime Momente oder wagen Sie es, ihn als raffiniertes Oberteil unter einer Blazerjacke für einen gewagten Look zu tragen.</p> <p>Unter einem Kleid oder Rock sorgt es für eine perfekt geformte Silhouette und bleibt dabei unsichtbar. Seine Netzdetails verleihen ihm einen geheimnisvollen Touch, der sich subtil entfaltet. Kombinieren Sie es mit einem Bleistiftrock für einen Business-Look mit einem Hauch von Sinnlichkeit. Vervollständigen Sie Ihren Look mit unseren eleganten <a href="https://www.divasboudoir.com/de/neglige-in-grosse-grossen/">Neglig&eacute;s</a> für eine schrittweise Verführung, erkunden Sie unsere passenden <a href="https://www.divasboudoir.com/de/sexy-hoschen-in-ubergrosse/">sexy Höschen</a> oder betonen Sie Ihre Beine mit unseren raffinierten <a href="https://www.divasboudoir.com/de/strumpfe-in-grossen-grossen/">Strümpfen</a>.</p>
summary
string<p>Entdecken Sie diesen <strong>schwarzen, formenden Body</strong> mit raffinierten Netzdetails, der <strong>perfekten Halt</strong> bietet und gleichzeitig Ihre Sinnlichkeit offenbart.</p> <p>Mit seiner <strong>Öffnung im Schritt</strong> und seinem vielseitigen Stil kann er sowohl als Dessous als auch als sexy Oberteil unter einem Kleid getragen werden.</p>
title
stringSchwarzer Gaining-Body aus Netzgewebe - Perfekter Halt und Verführung
usageinstructions
string<p>Dieser formende Body lässt sich dank der praktischen Schrittöffnung leicht anziehen. Für eine optimale formende Wirkung stellen Sie die zentrale Schnürung sanft auf Ihre Bequemlichkeit ein. Die <strong>perfekte Passform</strong> begleitet Sie den ganzen Tag, ohne dass Sie sich zu sehr eingeengt fühlen.</p> <p>Die Öffnung im Schritt erleichtert das Tragen erheblich, ohne dabei die Ästhetik zu vernachlässigen. Das <strong>für alle Figuren gedachte Design</strong> passt sich natürlich an Ihre Morphologie an und sorgt für ein harmonisches und elegantes Erscheinungsbild.</p>
el
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Πλύνετε στο χέρι με χλιαρό νερό (30&deg;C το πολύ) για να διατηρήσετε το δίχτυ</li> <li>Χρησιμοποιήστε ήπιο απορρυπαντικό χωρίς λευκαντικά ή μαλακτικά υφάσματος</li> <li>Στεγνώστε σε επίπεδη επιφάνεια, μακριά από το άμεσο ηλιακό φως</li> <li>Μην σιδερώνετε απευθείας τις λεπτομέρειες του διχτυού</li> <li>Αποθηκεύστε με προσοχή για να αποφύγετε τα τσιμπήματα στο ευαίσθητο δίχτυ</li> </ul>
description
string<p>Αυτό το εξαιρετικό κορμάκι θα φέρει επανάσταση στην γκαρνταρόμπα σας με τη διπλή λειτουργία του ως εσώρουχα και μόδα. Σχεδιασμένο για να <strong>ταιριάζει σε όλα τα σχήματα του σώματος</strong>, προσφέρει <strong>βέλτιστη στήριξη</strong> χάρη στο κόψιμό του, το οποίο <strong>ενισχύει</strong> κομψά <strong>τις γενναιόδωρες καμπύλες</strong>.</p> <p><strong>Η διάφανη λεπτομέρεια από δίχτυ</strong> στη λαιμόκοψη δημιουργεί ένα συναρπαστικό παιχνίδι διαφανειών, ενώ το <strong>κεντρικό κορδόνι</strong> προσθέτει μια πινελιά εκλεπτυσμένου αισθησιασμού. Το <strong>άνοιγμα στον καβάλο</strong> εξασφαλίζει <strong>άνεση</strong> όλη την ημέρα χωρίς να διακυβεύεται η αισθητική. Το <strong>μαλακό, αναπνεύσιμο ύφασμα</strong> προσαρμόζεται τέλεια στο σχήμα σας, δημιουργώντας μια αρμονική σιλουέτα.</p> <p>Αυτό το <strong>σχέδιο είναι ιδανικό για κάθε σιλουέτα</strong>, αποκαλύπτοντας τη <strong> φυσική, εκλεπτυσμένη κομψότητά</strong> σας είτε το φοράτε ως οικείο εσώρουχο είτε ως σέξι τοπ κάτω από φόρεμα ή φούστα.</p>
guid
stringhttps://dev.divasboudoir.com/el/swma-mayro/sbbo4109.htm
highlights
string<ul> <li><strong>Επίδραση μανδύα</strong> που ενισχύει τις γενναιόδωρες καμπύλες</li> <li><strong>Διαφανείς διχτυωτές λεπτομέρειες</strong> στη λαιμόκοψη για ένα εκλεπτυσμένο αποτέλεσμα</li> <li><strong>Κεντρικό κορδόνι</strong> που τονίζει φυσικά το μπούστο</li> <li><strong>Άνοιγμα στον καβάλο</strong> για βέλτιστη άνεση και πρακτικότητα</li> <li><strong>Απόλυτη ευελιξία</strong> - σέξι εσώρουχα ή μοντέρνο τοπ</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringΜεγάλο μαύρο διάφανο κορμάκι με λεπτομέρεια από δίχτυ και άνοιγμα στον καβάλο. Τέλεια στήριξη, ευέλικτο για εσώρουχα και μόδα. Δωρεάν παράδοση από €59. Μπουντουάρ της Ντίβας.
keywords
string
title
stringBody gainant Grande Taille noir Résille | Diva's Boudoir
seotitle
stringΜεγάλο μέγεθος μαύρο διχτυωτό σώμα με άνοιγμα καβάλου
seouri
stringswma-mayro
specifications
string<ul> <li><strong>Στυλ</strong>: Διαφανές κορμάκι με διχτυωτές λεπτομέρειες</li> <li><strong>Χρώμα:</strong> διαχρονικό μαύρο</li> <li><strong>Λεπτομέρειες</strong>: Διαφανής λαιμόκοψη από δίχτυ, κεντρικό κορδόνι</li> <li><strong>Άνοιγμα:</strong> καβάλο για μέγιστη πρακτικότητα</li> <li><strong>Επίδραση :</strong> Περικαλύπτει και σμιλεύει</li> <li><strong>Χρήση:</strong> Εσώρουχα ή ευέλικτο σέξι τοπ</li> </ul>
stylingtips
string<p>Η ευελιξία αυτού του κορμάκι το καθιστά απαραίτητο μέρος της γκαρνταρόμπας σας. Φορέστε το ως σέξι εσώρουχα για τις ιδιαίτερες προσωπικές στιγμές ή τολμήστε να το φορέσετε ως εκλεπτυσμένο τοπ κάτω από ένα σακάκι σακάκι για μια τολμηρή εμφάνιση.</p> <p>Κάτω από ένα φόρεμα ή μια φούστα, δημιουργεί μια τέλεια σμιλεμένη σιλουέτα, ενώ παραμένει αόρατο. Οι διχτυωτές λεπτομέρειες του προσθέτουν μια πινελιά μυστηρίου που αποκαλύπτεται διακριτικά. Συνδυάστε το με μια pencil φούστα για μια επαγγελματική εμφάνιση με μια πινελιά αισθησιασμού. Ολοκληρώστε την εμφάνισή σας με τα κομψά <a href="https://www.divasboudoir.com/el/negklize-megaloy-megethoys/">νεγκλιζέ</a> μας για προοδευτική αποπλάνηση, εξερευνήστε τα <a href="https://www.divasboudoir.com/el/sexi-eswroycha-megaloy-megethoys/">σέξι</a> ασορτί <a href="https://www.divasboudoir.com/el/sexi-eswroycha-megaloy-megethoys/">εσώρουχά</a> μας ή ενισχύστε τα πόδια σας με τις εκλεπτυσμένες <a href="https://www.divasboudoir.com/el/kaltses-megaloy-megethoys/">κάλτσες</a> μας.</p>
summary
string<p>Ανακαλύψτε αυτό το <strong>μαύρο κορμάκι με</strong> εκλεπτυσμένες λεπτομέρειες από δίχτυ που προσφέρει <strong>τέλεια στήριξη</strong>, ενώ αποκαλύπτει τον αισθησιασμό σας.</p> <p>Με <strong>άνοιγμα στον καβάλο</strong> και ευέλικτο στυλ, μπορεί να φορεθεί ως εσώρουχο ή ως σέξι τοπ κάτω από ένα φόρεμα.</p>
title
stringΜαύρο διχτυωτό κορμάκι - Τέλεια υποστήριξη και αποπλάνηση
usageinstructions
string<p>Αυτό το διαμορφωτικό κορμάκι φοριέται εύκολα χάρη στο πρακτικό άνοιγμα του καβάλου του. Για βέλτιστη στήριξη, ρυθμίστε απαλά το κεντρικό κορδόνι για να ταιριάζει στην άνεσή σας. <strong>Τέλεια στήριξη</strong> όλη την ημέρα χωρίς να αισθάνεστε υπερβολικά συμπιεσμένοι.</p> <p>Το άνοιγμα στον καβάλο το καθιστά πολύ πιο εύκολο στη χρήση, διατηρώντας παράλληλα την αισθητική του γοητεία. Αυτός ο <strong>σχεδιασμός είναι ιδανικός για όλα τα σχήματα σώματος</strong> και προσαρμόζεται φυσικά στο σχήμα του σώματός σας για μια αρμονική, κομψή εμφάνιση.</p>
en
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Hand wash in lukewarm water (30&deg;C maximum) to preserve the fishnet</li> <li>Use a mild detergent without bleach or fabric softener</li> <li>Dry flat, out of direct sunlight</li> <li>Do not iron directly on fishnet details</li> <li>Store with care to avoid snags on delicate fishnet</li> </ul>
description
string<p>This exceptional sheathing bodysuit revolutionizes your wardrobe with its dual lingerie and fashion function. Designed to <strong>fit all body types</strong>, it offers <strong>optimal support</strong> thanks to a sheathing cut that elegantly <strong>enhances generous curves</strong>.</p> <p><strong>Transparent fishnet details</strong> on the d&eacute;collet&eacute; create a captivating play of transparencies, while the <strong>central lacing</strong> adds a touch of refined sensuality. The <strong>crotch opening</strong> guarantees all-day <strong>comfort</strong> without compromising aesthetic appeal. The <strong>soft, breathable fabric</strong> perfectly matches the shape, creating a harmonious silhouette.</p> <p>Whether worn as intimate lingerie or as a sexy top under a dress or skirt, this <strong>design for every figure</strong> reveals your <strong> natural, sophisticated elegance</strong>.</p>
guid
stringhttps://dev.divasboudoir.com/en/body-black/sbbo4109.htm
highlights
string<ul> <li><strong>Sheathing effect</strong> enhances generous curves</li> <li><strong>Transparent fishnet details</strong> on the d&eacute;collet&eacute; for a sophisticated effect</li> <li><strong>Central lacing</strong> for natural bust enhancement</li> <li><strong>Crotch opening</strong> for optimum comfort and practicality</li> <li><strong>Absolute versatility</strong> - sexy lingerie or trendy top</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringPlus size black sheath bodysuit with fishnet detail and crotch opening. Perfect support, versatile for lingerie/fashion. Free delivery from €59. Diva's Boudoir.
keywords
string
title
stringBody Gainant Plus Size black fishnet | Diva's Boudoir
seotitle
stringPlus size black fishnet body with crotch opening
seouri
stringbody-black
specifications
string<ul> <li><strong>Style:</strong> Sheer bodysuit with fishnet details</li> <li><strong>Color:</strong> timeless black</li> <li><strong>Details:</strong> transparent fishnet neckline, central lacing</li> <li><strong>Opening:</strong> crotch for maximum practicality</li> <li><strong>Effect:</strong> Sheathing and sculpting</li> <li><strong>Usage:</strong> Lingerie or versatile sexy top</li> </ul>
stylingtips
string<p>The versatility of this bodysuit makes it an essential part of your wardrobe. Wear it as sexy lingerie for special intimate moments, or dare to wear it as a sophisticated top under a blazer jacket for a bold look.</p> <p>Under a dress or skirt, it creates a perfectly sculpted silhouette while remaining invisible. Its fishnet details add a touch of mystery that is subtly revealed. Pair it with a pencil skirt for a professional look with a touch of sensuality. Complete your look with our elegant <a href="https://www.divasboudoir.com/en/plus-size-robes/">negligees</a> for a gradual seduction, explore our <a href="https://www.divasboudoir.com/en/sexy-panties-plus-size/">sexy</a> matching <a href="https://www.divasboudoir.com/en/sexy-panties-plus-size/">panties</a>, or sublimate your legs with our sophisticated <a href="https://www.divasboudoir.com/en/socks-large-size/">stockings</a>.</p>
summary
string<p>Discover this <strong>black sheathing bodysuit</strong> with sophisticated fishnet detailing that offers <strong>perfect support</strong> while revealing your sensuality.</p> <p>With its <strong>crotch opening</strong> and versatile style, it can be worn as lingerie or as a sexy top under a dress.</p>
title
stringBody gainant noir Résille - Perfect support and seduction
usageinstructions
string<p>This sheathing bodysuit is easy to put on thanks to its practical crotch opening. For optimum support, gently adjust the central lacing to suit your comfort. <strong>Perfect support</strong> all day long without excessive compression.</p> <p>The crotch opening makes it easy to use, while retaining its aesthetic appeal. This <strong>design, conceived for every figure</strong>, adapts naturally to your morphology for a harmonious, elegant look.</p>
es
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavar a mano con agua tibia (30&deg;C como máximo) para preservar la malla</li> <li>Utilizar un detergente suave sin blanqueantes ni suavizantes</li> <li>Secar en plano, lejos de la luz solar directa</li> <li>No planchar directamente sobre los detalles de red</li> <li>Guardar con cuidado para evitar enganches en la delicada red de pesca</li> </ul>
description
string<p>Este excepcional body enfundado revolucionará su guardarropa por su doble función lencera y de moda. Diseñado para <strong>adaptarse a todas las formas del cuerpo</strong>, ofrece <strong>una sujeción óptima</strong> gracias a su corte envolvente, que <strong>realza</strong> con elegancia <strong>las curvas generosas</strong>.</p> <p><strong>Los detalles de rejilla</strong> en el escote crean un cautivador juego de transparencias, mientras que la <strong>lazada</strong> central añade un toque de refinada sensualidad. La <strong>abertura en la entrepierna</strong> garantiza <strong>comodidad</strong> durante todo el día sin comprometer el atractivo estético. El <strong>tejido suave y transpirable</strong> se amolda perfectamente a tu figura, creando una silueta armoniosa.</p> <p>Este <strong>diseño es perfecto para todas las figuras</strong>, revelando tu <strong> elegancia natural y sofisticada</strong> tanto si lo llevas como lencería íntima o como top sexy bajo un vestido o una falda.</p>
guid
stringhttps://dev.divasboudoir.com/es/cuerpo-negro/sbbo4109.htm
highlights
string<ul> <li><strong>Efecto enfundado</strong> que realza las curvas generosas</li> <li><strong>Detalles de rejilla transparente</strong> en el escote para un efecto sofisticado</li> <li><strong>Lazada central</strong> que realza el busto de forma natural</li> <li><strong>Abertura en la entrepierna</strong> para mayor comodidad y practicidad</li> <li><strong>Polivalencia absoluta</strong>: lencería sexy o top de moda</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringBody negro de talla grande con detalle de rejilla y abertura en la entrepierna. Sujeción perfecta, versátil para lencería y moda. Envío gratuito a partir de 59 €. Diva's Boudoir.
keywords
string
title
stringBody gainant talla grande noir Résille | Diva's Boudoir
seotitle
stringBody de rejilla negro talla grande con abertura en la entrepierna
seouri
stringcuerpo-negro
specifications
string<ul> <li><strong>Estilo :</strong> Body transparente con detalles de rejilla</li> <li><strong>Color:</strong> negro atemporal</li> <li><strong>Detalles :</strong> Escote de rejilla transparente, lazada central</li> <li><strong>Abertura:</strong> entrepierna para máxima practicidad</li> <li><strong>Efecto :</strong> Envainar y esculpir</li> <li><strong>Uso:</strong> lencería o top sexy versátil</li> </ul>
stylingtips
string<p>La versatilidad de este body lo convierte en un imprescindible de tu armario. Llévalo como lencería sexy para esos momentos íntimos especiales, o atrévete a llevarlo como top sofisticado bajo una chaqueta blazer para un look atrevido.</p> <p>Bajo un vestido o una falda, crea una silueta perfectamente esculpida sin dejar de ser invisible. Sus detalles de rejilla añaden un toque de misterio que se revela sutilmente. Combínela con una falda lápiz para un look profesional con un toque de sensualidad. Completa tu look con nuestros elegantes <a href="https://www.divasboudoir.com/es/picardias-talla-grande/">picardías</a> para una seducción progresiva, explora nuestras <a href="https://www.divasboudoir.com/es/bragas-sexys-talla-grande/">sensuales braguitas</a> a juego o realza tus piernas con nuestras sofisticadas <a href="https://www.divasboudoir.com/es/medias-grandes/">medias</a>.</p>
summary
string<p>Descubre este <strong>body negro enfundado</strong> con sofisticados detalles de rejilla que ofrece <strong>una sujeción perfecta</strong> al tiempo que revela tu sensualidad.</p> <p>Con su <strong>abertura en la entrepierna</strong> y su estilo versátil, puede llevarse como lencería o como top sexy bajo un vestido.</p>
title
stringBody de rejilla negro - Sujeción y seducción perfectas
usageinstructions
string<p>Este body moldeador es fácil de poner gracias a su práctica abertura en la entrepierna. Para una sujeción óptima, ajuste suavemente el cordón central según su comodidad. <strong>Sujeción perfecta</strong> durante todo el día sin sensación de compresión excesiva.</p> <p>La abertura en la entrepierna facilita mucho su uso, manteniendo al mismo tiempo su atractivo estético. Este <strong>diseño es perfecto para todas las formas del</strong> cuerpo y se adapta de forma natural a su silueta para lograr un aspecto armonioso y elegante.</p>
fr
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavage &agrave; la main &agrave; l'eau ti&egrave;de (30&deg;C maximum) pour pr&eacute;server la r&eacute;sille</li> <li>Utiliser une lessive douce sans agents blanchissants ni assouplissants</li> <li>S&eacute;chage &agrave; plat, &agrave; l'abri de la lumi&egrave;re directe du soleil</li> <li>Ne pas repasser directement sur les d&eacute;tails r&eacute;sille</li> <li>Ranger avec soin pour &eacute;viter les accrocs sur la r&eacute;sille d&eacute;licate</li> </ul>
description
string<p>Ce body gainant d'exception r&eacute;volutionne votre garde-robe avec sa double fonction lingerie et mode. Con&ccedil;u pour <strong>s'adapter &agrave; toutes les morphologies</strong>, il offre un <strong>maintien optimal</strong> gr&acirc;ce &agrave; sa coupe gainante qui <strong>sublime les courbes g&eacute;n&eacute;reuses</strong> avec &eacute;l&eacute;gance.</p> <p>Les&nbsp;<strong>d&eacute;tails r&eacute;sille transparente</strong> sur le d&eacute;collet&eacute; cr&eacute;ent un jeu de transparences captivant, tandis que le <strong>la&ccedil;age central</strong> apporte une touche de sensualit&eacute; raffin&eacute;e. Son <strong>ouverture &agrave; l'entrejambe</strong> garantit un <strong>confort optimal toute la journ&eacute;e</strong> sans compromettre l'esth&eacute;tisme. Les <strong>mati&egrave;res douces et respirantes</strong> &eacute;pousent parfaitement les formes, cr&eacute;ant une silhouette harmonieuse.</p> <p>Ce&nbsp;<strong>design pens&eacute; pour toutes les silhouettes</strong> r&eacute;v&egrave;le votre <strong>&eacute;l&eacute;gance naturelle et sophistiqu&eacute;e</strong> que vous le portiez en lingerie intime ou comme haut sexy sous une robe ou une jupe.</p>
guid
stringhttps://dev.divasboudoir.com/fr/body-gainant-noir-resille-grande-taille/sbbo4109.htm
highlights
string<ul> <li><strong>Effet gainant</strong> qui sublime les courbes g&eacute;n&eacute;reuses</li> <li><strong>D&eacute;tails r&eacute;sille transparente</strong> sur le d&eacute;collet&eacute; pour un effet sophistiqu&eacute;</li> <li><strong>La&ccedil;age central</strong> qui met en valeur la poitrine naturellement</li> <li><strong>Ouverture entrejambe</strong> pour un confort et une praticit&eacute; optimaux</li> <li><strong>Polyvalence absolue</strong> - lingerie sexy ou haut tendance</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringBody gainant grande taille noir avec détails résille et ouverture entrejambe. Maintien parfait, polyvalent lingerie/mode. Livraison gratuite dès 59€. Diva's Boudoir.
keywords
string
title
stringBody Gainant Grande Taille noir Résille | Diva's Boudoir
seotitle
stringBody grande taille gainant spécial ventre plat
seouri
stringbody-gainant-noir-resille-grande-taille
specifications
string<ul> <li><strong>Style :</strong> Body gainant avec d&eacute;tails r&eacute;sille</li> <li><strong>Couleur :</strong> noir intemporel ou beige naturel</li> <li><strong>D&eacute;tails :</strong> R&eacute;sille transparente d&eacute;collet&eacute;, la&ccedil;age central</li> <li><strong>Ouverture :</strong> Entrejambe pour praticit&eacute; optimale</li> <li><strong>Effet :</strong> Gainant et sculptant</li> <li><strong>Usage :</strong> Lingerie ou haut sexy polyvalent</li> </ul>
stylingtips
string<p>La polyvalence de ce body en fait une pi&egrave;ce indispensable de votre garde-robe. Portez-le en lingerie sexy pour des moments intimes privil&eacute;gi&eacute;s, ou osez le porter comme haut sophistiqu&eacute; sous une veste blazer pour un look audacieux.</p> <p>Sous une robe ou une jupe, il cr&eacute;e une silhouette parfaitement sculpt&eacute;e tout en restant invisible. Ses d&eacute;tails r&eacute;sille apportent une touche de myst&egrave;re qui se r&eacute;v&egrave;le subtilement. Associez-le &agrave; une jupe crayon pour un look professionnel avec une pointe de sensualit&eacute;. Compl&eacute;tez votre look avec nos&nbsp;<a href="https://www.divasboudoir.com/fr/deshabille-grande-taille/">d&eacute;shabill&eacute;s</a> &eacute;l&eacute;gants pour une s&eacute;duction progressive, explorez nos <a href="https://www.divasboudoir.com/fr/culotte-sexy-grande-taille/">culottes sexys</a> assorties, ou sublimez vos jambes avec nos <a href="https://www.divasboudoir.com/fr/bas-grande-taille/">bas</a> sophistiqu&eacute;s.</p>
summary
string<p>D&eacute;couvrez ce <strong>body gainant sp&eacute;cial ventre plat</strong> aux d&eacute;tails r&eacute;sille sophistiqu&eacute;s qui offre un <strong>maintien parfait</strong> tout en r&eacute;v&eacute;lant votre sensualit&eacute;.</p> <p>Avec son&nbsp;<strong>ouverture &agrave; l'entrejambe</strong> et son style polyvalent, il se porte aussi bien en lingerie qu'en haut sexy sous une robe.</p>
title
stringBody Gainant noir Résille - Spécial Ventre Plat
usageinstructions
string<p>Ce body gainant s'enfile facilement gr&acirc;ce &agrave; son ouverture entrejambe pratique. Pour un effet gainant optimal, ajustez d&eacute;licatement le la&ccedil;age central selon votre confort. Son <strong>maintien parfait</strong> vous accompagne toute la journ&eacute;e sans sensation de compression excessive.</p> <p>L'ouverture &agrave; l'entrejambe facilite grandement l'utilisation tout en conservant l'esth&eacute;tisme. Ce&nbsp;<strong>design pens&eacute; pour toutes les silhouettes</strong> s'adapte naturellement &agrave; votre morphologie pour un rendu harmonieux et &eacute;l&eacute;gant.</p>
it
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavare a mano in acqua tiepida (massimo 30&deg;C) per preservare la rete</li> <li>Utilizzare un detersivo delicato senza agenti sbiancanti o ammorbidenti</li> <li>Asciugare in piano, al riparo dalla luce diretta del sole</li> <li>Non stirare direttamente i dettagli della rete</li> <li>Conservare con cura per evitare strappi alla delicata rete</li> </ul>
description
string<p>Questo eccezionale body a guaina rivoluzionerà il vostro guardaroba grazie alla sua doppia funzione di lingerie e moda. Progettato per <strong>adattarsi a tutte le forme del corpo</strong>, offre un <strong>sostegno ottimale</strong> grazie al taglio a guaina, che <strong>esalta</strong> con eleganza <strong>le curve generose</strong>.</p> <p><strong>I dettagli a rete</strong> sulla scollatura creano un accattivante gioco di trasparenze, mentre l'<strong>allacciatura centrale</strong> aggiunge un tocco di raffinata sensualità. L'<strong>apertura all'inguine</strong> assicura il <strong>comfort</strong> per tutto il giorno senza compromettere l'estetica. Il <strong>tessuto morbido e traspirante</strong> si modella perfettamente alle vostre forme, creando una silhouette armoniosa.</p> <p>Questo <strong>design è perfetto per ogni figura</strong> e rivela la vostra <strong> naturale e sofisticata eleganza</strong>, sia che lo indossiate come lingerie intima o come top sexy sotto un abito o una gonna.</p>
guid
stringhttps://dev.divasboudoir.com/it/corpo-nero/sbbo4109.htm
highlights
string<ul> <li><strong>Effetto guaina</strong> che esalta le curve generose</li> <li><strong>Dettagli in rete trasparente</strong> sulla scollatura per un effetto sofisticato</li> <li><strong>Allacciatura centrale</strong> che valorizza naturalmente il busto</li> <li><strong>Apertura sul cavallo</strong> per un comfort e una praticità ottimali</li> <li><strong>Versatilità assoluta</strong>: lingerie sexy o top di tendenza</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringGrande body nero trasparente con dettaglio a rete e apertura al cavallo. Sostegno perfetto, versatile per la lingerie e la moda. Consegna gratuita a partire da 59 euro. Diva's Boudoir.
keywords
string
title
stringBody gainant Taglia grande noir Résille | Diva's Boudoir
seotitle
stringCorpo a rete nero di taglia grande con apertura inguinale
seouri
stringcorpo-nero
specifications
string<ul> <li><strong>Stile :</strong> Body trasparente con dettagli a rete</li> <li><strong>Colore:</strong> nero senza tempo</li> <li><strong>Dettagli:</strong> scollatura a rete trasparente, allacciatura centrale</li> <li><strong>Apertura:</strong> cavallo per la massima praticità</li> <li><strong>Effetto :</strong> Guaina e scultura</li> <li><strong>Uso:</strong> lingerie o top sexy versatile</li> </ul>
stylingtips
string<p>La versatilità di questo body lo rende un capo essenziale del vostro guardaroba. Indossatelo come lingerie sexy per i momenti di intimità più speciali, oppure osate come top sofisticato sotto una giacca blazer per un look audace.</p> <p>Sotto un abito o una gonna, crea una silhouette perfettamente scolpita rimanendo invisibile. I dettagli a rete aggiungono un tocco di mistero che si svela con discrezione. Abbinatelo a una gonna a tubino per un look professionale con un tocco di sensualità. Completate il vostro look con le nostre eleganti <a href="https://www.divasboudoir.com/it/vestaglia-taglia-grande/">vestaglie</a> per una seduzione progressiva, esplorate le nostre <a href="https://www.divasboudoir.com/it/mutandine-sexy-taglia-grande/">sexy mutandine</a> abbinate o valorizzate le vostre gambe con le nostre sofisticate <a href="https://www.divasboudoir.com/it/calze-di-grandi-dimensioni/">calze</a>.</p>
summary
string<p>Scoprite questo <strong>body nero a guaina</strong> con sofisticati dettagli a rete che offre un <strong>sostegno perfetto</strong> e allo stesso tempo rivela la vostra sensualità.</p> <p>Grazie all'<strong>apertura sul cavallo</strong> e allo stile versatile, può essere indossato come lingerie o come top sexy sotto un abito.</p>
title
stringBody a rete nero - Perfetto sostegno e seduzione
usageinstructions
string<p>Questo body modellante è facile da indossare grazie alla pratica apertura sul cavallo. Per un sostegno ottimale, regolate delicatamente l'allacciatura centrale in base al vostro comfort. <strong>Sostegno perfetto</strong> per tutto il giorno senza sentirsi eccessivamente compressi.</p> <p>L'apertura inguinale ne facilita l'uso, pur mantenendo il suo fascino estetico. Questo <strong>design è perfetto per tutte le forme del corpo</strong> e si adatta naturalmente alle vostre forme per un look armonioso ed elegante.</p>
nl
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Handwas in lauw water (maximaal 30&deg;C) om het visnet te sparen</li> <li>Gebruik een mild wasmiddel zonder bleekmiddelen of wasverzachters</li> <li>Plat drogen, niet in direct zonlicht</li> <li>Niet rechtstreeks op visnetdetails strijken</li> <li>Voorzichtig opbergen om te voorkomen dat het delicate visnet gaat haperen</li> </ul>
description
string<p>Deze uitzonderlijke bodysuit zal je garderobe revolutioneren met zijn dubbele lingerie- en modefunctie. Hij is ontworpen voor <strong>alle lichaamsvormen</strong> en biedt <strong>optimale ondersteuning</strong> dankzij het scherende model, dat <strong>royale rondingen</strong> elegant <strong>benadrukt</strong>.</p> <p><strong>De doorschijnende visnetdetails</strong> in de halslijn creëren een fascinerend spel van transparanties, terwijl <strong>de centrale vetersluiting</strong> een vleugje verfijnde sensualiteit toevoegt. De <strong>opening in het kruis</strong> zorgt de hele dag voor <strong>comfort</strong> zonder afbreuk te doen aan de esthetische aantrekkingskracht. De <strong>zachte, ademende stof</strong> vormt zich perfect naar je figuur en creëert een harmonieus silhouet.</p> <p>Dit <strong>ontwerp is perfect voor elk figuur</strong> en onthult je <strong> natuurlijke, verfijnde elegantie</strong>, of je het nu draagt als intieme lingerie of als een sexy topje onder een jurk of rok.</p>
guid
stringhttps://dev.divasboudoir.com/nl/lichaam-zwart/sbbo4109.htm
highlights
string<ul> <li><strong>Manteleffect</strong> dat royale rondingen benadrukt</li> <li><strong>Transparante visnetdetails</strong> aan de halslijn voor een geraffineerd effect</li> <li><strong>Centrale vetersluiting</strong> die de buste op natuurlijke wijze accentueert</li> <li><strong>Opening in het kruis</strong> voor optimaal comfort en praktisch gemak</li> <li><strong>Absolute veelzijdigheid</strong> - sexy lingerie of trendy topje</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringGrote zwarte, transparante bodysuit met visnetdetail en kruisopening. Perfecte ondersteuning, veelzijdig voor lingerie en mode. Gratis bezorging vanaf €59. Diva's Boudoir.
keywords
string
title
stringBody gainant Grote maat noir Résille | Diva's Boudoir
seotitle
stringGrote maat zwarte visnet body met kruisopening
seouri
stringlichaam-zwart
specifications
string<ul> <li><strong>Stijl:</strong> Sheer bodysuit met visnetdetails</li> <li><strong>Kleur:</strong> tijdloos zwart</li> <li><strong>Details :</strong> doorschijnende visnet halslijn, centrale vetersluiting</li> <li><strong>Opening:</strong> kruis voor maximaal gebruiksgemak</li> <li><strong>Effect :</strong> Omhullend en modellerend</li> <li><strong>Gebruik:</strong> Lingerie of veelzijdige sexy top</li> </ul>
stylingtips
string<p>De veelzijdigheid van deze bodysuit maakt het een essentieel onderdeel van je garderobe. Draag hem als sexy lingerie voor die speciale intieme momenten, of durf hem te dragen als geraffineerde top onder een blazerjack voor een gedurfde look.</p> <p>Onder een jurk of rok creëert het een perfect gebeeldhouwd silhouet terwijl het onzichtbaar blijft. De visnetdetails voegen een vleugje mysterie toe dat subtiel wordt onthuld. Combineer het met een kokerrok voor een professionele look met een vleugje sensualiteit. Maak je look compleet met onze elegante <a href="https://www.divasboudoir.com/nl/grote-maat-neglige/">negligés</a> voor progressieve verleiding, ontdek onze <a href="https://www.divasboudoir.com/nl/sexy-slipje-groote-maat/">sexy</a> bijpassende <a href="https://www.divasboudoir.com/nl/sexy-slipje-groote-maat/">slips</a>, of verfraai je benen met onze geraffineerde <a href="https://www.divasboudoir.com/nl/grote-maat-kousen/">kousen</a>.</p>
summary
string<p>Ontdek deze <strong>zwarte bodysuit met</strong> geraffineerde visnetdetails die <strong>perfecte ondersteuning</strong> biedt en tegelijkertijd je sensualiteit onthult.</p> <p>Met zijn <strong>kruisopening</strong> en veelzijdige stijl kan het gedragen worden als lingerie of als een sexy top onder een jurk.</p>
title
stringZwarte netbody - Perfecte ondersteuning en verleiding
usageinstructions
string<p>Deze shaping bodysuit is gemakkelijk aan te trekken dankzij de praktische kruisopening. Voor optimale ondersteuning kun je de centrale vetersluiting zachtjes aanpassen aan jouw comfort. <strong>Perfecte ondersteuning</strong>, de hele dag door, zonder een overmatig gecomprimeerd gevoel.</p> <p>De kruisopening maakt het gemakkelijk in gebruik, terwijl het esthetische aspect behouden blijft. Dit <strong>ontwerp is perfect voor alle lichaamsvormen</strong> en past zich op natuurlijke wijze aan je lichaamsvorm aan voor een harmonieuze, elegante look.</p>
pt
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavar à mão em água tépida (30&deg;C no máximo) para preservar a rede</li> <li>Utilizar um detergente suave sem agentes branqueadores ou amaciadores de roupa</li> <li>Secar em local plano, longe da luz solar direta</li> <li>Não passar a ferro diretamente sobre os detalhes da rede</li> <li>Guardar com cuidado para evitar que a delicada rede de pesca fique presa</li> </ul>
description
string<p>Este excecional body com bainha vai revolucionar o seu guarda-roupa com a sua dupla função de lingerie e moda. Concebido para <strong>se adaptar a todas as formas do corpo</strong>, oferece <strong>um apoio ótimo</strong> graças ao seu corte em bainha, que <strong>realça</strong> elegantemente <strong>as curvas generosas</strong>.</p> <p><strong>Os detalhes em rede transparente</strong> no decote criam um jogo cativante de transparências, enquanto o <strong>laço central</strong> acrescenta um toque de sensualidade refinada. A <strong>abertura entrepernas</strong> garante <strong>conforto</strong> durante todo o dia sem comprometer a estética. O <strong>tecido macio e respirável</strong> molda-se perfeitamente à sua forma, criando uma silhueta harmoniosa.</p> <p>Este <strong>design é perfeito para todas as silhuetas</strong>, revelando a sua <strong> elegância natural e sofisticada</strong>, quer o use como lingerie íntima ou como um top sexy por baixo de um vestido ou saia.</p>
guid
stringhttps://dev.divasboudoir.com/pt/corpo-preto/sbbo4109.htm
highlights
string<ul> <li><strong>Efeito de bainha</strong> que realça as curvas generosas</li> <li><strong>Detalhes em rede transparente</strong> no decote para um efeito sofisticado</li> <li><strong>Laço central</strong> que realça naturalmente o busto</li> <li><strong>Abertura entrepernas</strong> para um conforto e uma praticidade óptimos</li> <li><strong>Versatilidade absoluta</strong> - lingerie sexy ou top da moda</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringBody preto grande e transparente com pormenor em rede e abertura nas virilhas. Suporte perfeito, versátil para lingerie e moda. Entrega gratuita a partir de 59 euros. Diva's Boudoir.
keywords
string
title
stringBody gainant Grande Taille noir Résille | Diva's Boudoir
seotitle
stringCorpo em rede preta de tamanho grande com abertura nas virilhas
seouri
stringcorpo-preto
specifications
string<ul> <li><strong>Estilo :</strong> Body transparente com detalhes em rede</li> <li><strong>Cor:</strong> Preto intemporal</li> <li><strong>Detalhes :</strong> Decote em rede transparente, laço central</li> <li><strong>Abertura:</strong> entrepernas para maior praticidade</li> <li><strong>Efeito :</strong> Corte e escultura</li> <li><strong>Utilização:</strong> Lingerie ou top sexy versátil</li> </ul>
stylingtips
string<p>A versatilidade deste body torna-o numa peça essencial do seu guarda-roupa. Use-o como lingerie sexy para aqueles momentos íntimos especiais, ou atreva-se a usá-lo como um top sofisticado sob um blazer para um look ousado.</p> <p>Sob um vestido ou uma saia, cria uma silhueta perfeitamente esculpida, permanecendo invisível. Os seus detalhes em rede acrescentam um toque de mistério que é subtilmente revelado. Combine-o com uma saia lápis para um look profissional com um toque de sensualidade. Complemente o seu look com as nossas elegantes <a href="https://www.divasboudoir.com/pt/batotas-plus-size/">negligés</a> para uma sedução progressiva, explore <a href="https://www.divasboudoir.com/pt/cuecas-sexy-tamanho-grande/">as</a> nossas <a href="https://www.divasboudoir.com/pt/cuecas-sexy-tamanho-grande/">sensuais cuecas</a> a condizer ou realce as suas pernas com as nossas sofisticadas <a href="https://www.divasboudoir.com/pt/meias-de-tamanho-grande/">meias de ligas</a>.</p>
summary
string<p>Descubra este <strong>body preto</strong> com detalhes sofisticados em rede que oferece <strong>um apoio perfeito</strong> enquanto revela a sua sensualidade.</p> <p>Com a sua <strong>abertura na virilha</strong> e estilo versátil, pode ser usado como lingerie ou como um top sexy por baixo de um vestido.</p>
title
stringBody de rede preto - Apoio e sedução perfeitos
usageinstructions
string<p>Este body modelador é fácil de vestir graças à sua prática abertura na virilha. Para um apoio ótimo, ajuste suavemente o laço central de acordo com o seu conforto. <strong>Apoio perfeito</strong> durante todo o dia sem sentir-se excessivamente comprimida.</p> <p>A abertura entrepernas facilita a sua utilização, mantendo o seu carácter estético. Este <strong>design é perfeito para todas as formas do corpo</strong> e adapta-se naturalmente à forma do seu corpo para um aspeto harmonioso e elegante.</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
stringsi25031467773083946 body gainant
netweight
string
nextshipment
stringtoday
ordered
number6
orderidx
number0
origin
string
originalsize
string
packaging
string
productshipment
stringauto
productuid
string8368959F-8F8F-4F72-8D2CF608CF07D3AB
promountil
string
rating
stringnone
recorduid
string8368959F-8F8F-4F72-8D2CF608CF07D3AB
reference
stringSBBO4109
related
string
reserved
string
returned
number0
returnsallowed
number1
section
stringlingerie
shipment
string5to7days
showbrand
number0
sizeinfos
Query
Template: /system/api/product/sizes.cfc:20
Execution Time: 2.21 ms
Record Count: 8
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,'1062,1063,1064,1065') > 0
and product_variations.productuid = '8368959F-8F8F-4F72-8D2CF608CF07D3AB'
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
110654Xintlsizeblack4X4X-19999990wpluslingerie4X4X50-5220-2224-2652-5452-5450-5256-5852-5450-52118-126104-112128-136
210654Xintlsizebeige4X4X-19999990wpluslingerie4X4X50-5220-2224-2652-5452-5450-5256-5852-5450-52118-126104-112128-136
310621Xintlsizebeige1X1X-19999990wpluslingerie1X1X42-4412-1416-1844-4644-4642-4450-5244-4642-4494-10480-88102-112
410621Xintlsizeblack1X1X-19999990wpluslingerie1X1X42-4412-1416-1844-4644-4642-4450-5244-4642-4494-10480-88102-112
510632XLintlsizeblack2XL2XL-19999990wpluslingerie2X2XL46-4816-1820-2248-5048-5046-4852-5448-5046-48104-11088-96112-120
610632XLintlsizebeige2XL2XL-19999990wpluslingerie2X2XL46-4816-1820-2248-5048-5046-4852-5448-5046-48104-11088-96112-120
710643Xintlsizeblack3X3X-19999990wpluslingerie3X3X48-5018-2022-2450-5250-5248-5054-5650-5248-50110-11896-104120-128
810643Xintlsizebeige3X3X-19999990wpluslingerie3X3X48-5018-2022-2450-5250-5248-5054-5650-5248-50110-11896-104120-128
sizeranges
stringplus
sizes
string1062,1063,1064,1065
sizetype
stringauto
specifications
Struct
Entries: 23
belly
string
bones
string
bra
string
breasts
string
bust
string
closing
string
crochtless
string
cups
string
cut
string
garter
string
halter
string
lacing
string
lining
string
modestypanel
string
panty
string
sheathing
string
sleeves
string
stocking
string
straps
string
stretch
string
suspenders
string
transparency
string
underwires
string
stock
number0
stocks
Query
Template: /system/api/product/stocks.cfc:25
Execution Time: 9.18 ms
Record Count: 8
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 = '8368959F-8F8F-4F72-8D2CF608CF07D3AB'
and product_variations.isactive = 1
and product_sizes.id_size = 1062
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 = '8368959F-8F8F-4F72-8D2CF608CF07D3AB'
and product_variations.isactive = 1
and product_sizes.id_size = 1063
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 = '8368959F-8F8F-4F72-8D2CF608CF07D3AB'
and product_variations.isactive = 1
and product_sizes.id_size = 1064
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 = '8368959F-8F8F-4F72-8D2CF608CF07D3AB'
and product_variations.isactive = 1
and product_sizes.id_size = 1065
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
18368959F-8F8F-4F72-8D2CF608CF07D3ABF3541472-9DC4-4945-9F0D76F25C6B55541065beige#F6DBAC4X4X50-5220-2224-2652-5452-5450-5256-5852-5450-52wlingerie4Xintlsize29.12519.125{ts '2025-11-03 00:00:00'}STOCK01000-10000-10all
28368959F-8F8F-4F72-8D2CF608CF07D3AB369531B3-1542-4F35-919E8E75EF9B84A91065black#0000004X4X50-5220-2224-2652-5452-5450-5256-5852-5450-52wlingerie4Xintlsize29.12519.125{ts '2025-11-03 00:00:00'}STOCK01100-11300SP2502B2H2SORS0834203107-10all
38368959F-8F8F-4F72-8D2CF608CF07D3AB621A01A7-E85A-4E80-981B8CC063C4D83D1062beige#F6DBAC1X1X42-4412-1416-1844-4644-4642-4450-5244-4642-44wlingerie1Xintlsize29.12519.125{ts '2025-11-03 00:00:00'}STOCK01000-10000-10all
48368959F-8F8F-4F72-8D2CF608CF07D3AB86359705-1659-471A-823758A75CB3F0221062black#0000001X1X42-4412-1416-1844-4644-4642-4450-5244-4642-44wlingerie1Xintlsize29.12519.125{ts '2025-11-03 00:00:00'}STOCK01000-10200SP2502B2H5PKMI0834203102-10all
58368959F-8F8F-4F72-8D2CF608CF07D3AB49D1BFB6-FC41-4C70-B9A44FED53C634AB1063beige#F6DBAC2X2XL46-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie2XLintlsize29.12519.125{ts '2025-11-03 00:00:00'}STOCK01000-10000-10all
68368959F-8F8F-4F72-8D2CF608CF07D3AB7B874D52-22B5-4B2E-B75F430011635B431063black#0000002X2XL46-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie2XLintlsize29.12519.125{ts '2025-11-03 00:00:00'}STOCK01100-12100SP2502B2H5PKMI0834203112-10all
78368959F-8F8F-4F72-8D2CF608CF07D3AB35F37240-E7FB-4E0C-A473EAC356FEE81D1064beige#F6DBAC3X3X48-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie3Xintlsize29.12519.125{ts '2025-11-03 00:00:00'}STOCK01000-10000-10all
88368959F-8F8F-4F72-8D2CF608CF07D3AB6387D185-3160-4A45-916C0AFA39DEB9131064black#0000003X3X48-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie3Xintlsize29.12519.125{ts '2025-11-03 00:00:00'}STOCK01000-10000SP2502B-10all
subcategory
stringshapewear
supplier
number-1
supplierreference
stringSI25031467773083946
tags
string
themes
string
totalvariations
string
type
stringdefault
unitprice
number29.125
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 13 ms
Record Count: 8
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 = '8368959F-8F8F-4F72-8D2CF608CF07D3AB' 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 = '8368959F-8F8F-4F72-8D2CF608CF07D3AB' 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 = '8368959F-8F8F-4F72-8D2CF608CF07D3AB' 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 = '8368959F-8F8F-4F72-8D2CF608CF07D3AB' 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 = '8368959F-8F8F-4F72-8D2CF608CF07D3AB' 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 = '8368959F-8F8F-4F72-8D2CF608CF07D3AB' 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 = '8368959F-8F8F-4F72-8D2CF608CF07D3AB'
and product_variations.isactive = 1
and product_sizes.id_size = 1062
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 = '8368959F-8F8F-4F72-8D2CF608CF07D3AB' 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 = '8368959F-8F8F-4F72-8D2CF608CF07D3AB' 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 = '8368959F-8F8F-4F72-8D2CF608CF07D3AB' 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 = '8368959F-8F8F-4F72-8D2CF608CF07D3AB' 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 = '8368959F-8F8F-4F72-8D2CF608CF07D3AB' 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 = '8368959F-8F8F-4F72-8D2CF608CF07D3AB' 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 = '8368959F-8F8F-4F72-8D2CF608CF07D3AB'
and product_variations.isactive = 1
and product_sizes.id_size = 1063
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 = '8368959F-8F8F-4F72-8D2CF608CF07D3AB' 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 = '8368959F-8F8F-4F72-8D2CF608CF07D3AB' 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 = '8368959F-8F8F-4F72-8D2CF608CF07D3AB' 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 = '8368959F-8F8F-4F72-8D2CF608CF07D3AB' 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 = '8368959F-8F8F-4F72-8D2CF608CF07D3AB' 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 = '8368959F-8F8F-4F72-8D2CF608CF07D3AB' 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 = '8368959F-8F8F-4F72-8D2CF608CF07D3AB'
and product_variations.isactive = 1
and product_sizes.id_size = 1064
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 = '8368959F-8F8F-4F72-8D2CF608CF07D3AB' 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 = '8368959F-8F8F-4F72-8D2CF608CF07D3AB' 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 = '8368959F-8F8F-4F72-8D2CF608CF07D3AB' 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 = '8368959F-8F8F-4F72-8D2CF608CF07D3AB' 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 = '8368959F-8F8F-4F72-8D2CF608CF07D3AB' 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 = '8368959F-8F8F-4F72-8D2CF608CF07D3AB' 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 = '8368959F-8F8F-4F72-8D2CF608CF07D3AB'
and product_variations.isactive = 1
and product_sizes.id_size = 1065
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
1F3541472-9DC4-4945-9F0D76F25C6B55541065beige#F6DBAC4X4X50-5220-2224-2652-5452-5450-5256-5852-5450-52wlingerie4Xintlsize29.12519.125{ts '2025-11-03 00:00:00'}STOCK01000-10000-10-10-10029.125all
2369531B3-1542-4F35-919E8E75EF9B84A91065black#0000004X4X50-5220-2224-2652-5452-5450-5256-5852-5450-52wlingerie4Xintlsize29.12519.125{ts '2025-11-03 00:00:00'}STOCK01100-11300SP2502B2H2SORS0834203107-10-10-10029.125all
3621A01A7-E85A-4E80-981B8CC063C4D83D1062beige#F6DBAC1X1X42-4412-1416-1844-4644-4642-4450-5244-4642-44wlingerie1Xintlsize29.12519.125{ts '2025-11-03 00:00:00'}STOCK01000-10000-10-10-10029.125all
486359705-1659-471A-823758A75CB3F0221062black#0000001X1X42-4412-1416-1844-4644-4642-4450-5244-4642-44wlingerie1Xintlsize29.12519.125{ts '2025-11-03 00:00:00'}STOCK01000-10200SP2502B2H5PKMI0834203102-10-10-10029.125all
549D1BFB6-FC41-4C70-B9A44FED53C634AB1063beige#F6DBAC2X2XL46-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie2XLintlsize29.12519.125{ts '2025-11-03 00:00:00'}STOCK01000-10000-10-10-10029.125all
67B874D52-22B5-4B2E-B75F430011635B431063black#0000002X2XL46-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie2XLintlsize29.12519.125{ts '2025-11-03 00:00:00'}STOCK01100-12100SP2502B2H5PKMI0834203112-10-10-10029.125all
735F37240-E7FB-4E0C-A473EAC356FEE81D1064beige#F6DBAC3X3X48-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie3Xintlsize29.12519.125{ts '2025-11-03 00:00:00'}STOCK01000-10000-10-10-10029.125all
86387D185-3160-4A45-916C0AFA39DEB9131064black#0000003X3X48-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie3Xintlsize29.12519.125{ts '2025-11-03 00:00:00'}STOCK01000-10000SP2502B-10-10-10029.125all
vatrate
number20
warehouse
string