My cart

❌
Total items
View basket
Menu
See sizes
Jasmine Set - Sparkling seduction and absolute audacity
Double-click to enlarge
SKU: SBBU5925
Jasmine Set - Sparkling seduction and absolute audacity
Stock:

Unleash your provocative side with the Jasmin set in shimmering mesh!

This form-fitting chemise sculpts your figure, while its underwired cups sublimate your décolleté.

With its rhinestone rings and thigh-high garters, this set transforms every woman into a seductive goddess.

Highlights

  • Shimmering mesh catches the light with every movement
  • Underwired cups for optimum support and a push-up effect
  • O-ring rhinestones for a sophisticated, flirtatious effect
  • Bold front and backcut-outs that reveal your skin
  • Adjustable thigh garters for a uniquely provocative look
  • Matching transparent thong with cotton lining for comfort
  • Form-fitting cut naturally sculpts your figure
  • Perfectly coordinatedtwo-piece shirt and thongdesign
Size:

Not sure which size to choose? See our size guide

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

Plus size set Jasmin shimmering mesh shirt with thigh-high garters

Product description

The Jasmin set revolutionizes the art of provocation with its glittering mesh that transforms your silhouette into a living work of art. This unique material catches the light with every movement, creating a hypnotic visual game that captivates every eye.

Ultra-fine underwired cups sculpt a perfect décolleté while offering exceptional bra support that adapts naturally to all body types. Their technical design reveals your assets with uncanny precision, creating that sought-after push-up effect.

strategically positioned O-ring rhinestones on the bust add that precious dimension that makes all the difference. These details create a sophisticated naughty effect that reveals your boldness with unsettling elegance. Bold front and back cut-outs strategically reveal your skin, creating that unsettling interplay between what shows and what hides. This design sculpts your silhouette with surgical precision, revealing your sensuality from every angle.

Adjustable thigh garters revolutionize traditional codes, creating a unique, provocative silhouette. This innovation transforms your legs into assets of absolute seduction, adding that playful dimension that awakens every fantasy.

The transparent cotton-lined thong completes this exceptional set. This attention to comfort reveals the technical know-how of this creation, combining bold aesthetics with optimal well-being. When you wear this Jasmin set, you no longer go unnoticed - you become that fascinating creature who hypnotizes with her sparkling grace and irresistible magnetic aura.

Technical details

  • Set: Two-piece (matching shirt and thong)
  • Material: Shimmering shimmer mesh
  • Cups: Ultra-fine wired with fabric underlay
  • Details: O-ring rhinestones on bust
  • Cut-outs : Bold front and back
  • Garters: Adjustable thighs for provocative effect
  • G-string: Transparent with cotton lining
  • Cut: Form-fitting and sculpting

Available sizes

Available from 1X/2X- to 3X/4X

Available colors

Black and Deep rose

Sizing guide

Check the right size for you

International
  • Chest
  • Size
  • Hips
1X/2X-
  • 104-110
  • 86-91
  • 112-120
3X/4X+
  • 128-132
  • 102-108
  • 132-138
XL
  • 99-104
  • 81-86
  • 107-112
1X/2X
  • 112-118
  • 92-96
  • 122-128
3X/4X
  • 120-128
  • 98-102
  • 128-132

Care instructions

  • Hand wash in cold water to preserve glitter
  • Use a mild detergent without bleaching agents
  • Dry flat to maintain the shape of the underwiring
  • Never iron directly on the glittering mesh
  • Handle rhinestone rings with care
  • Store hanging to avoid snags on the mesh

Usage tips

For optimum support of your generous breasts, gently position the underwired cups before adjusting the thigh garters. The shimmering mesh naturally hugs your shape without constraint, allowing total freedom of movement. The garters are easily adjusted to create the provocative effect you desire. This set adapts to all body shapes thanks to its form-fitting cut and stretch fabrics. The cotton lining of the thong guarantees optimum comfort all evening long.

Styling tips

Enhance your Jasmine ensemble with our plus size fishnet stockings to complete the provocative look, or add a plus size silk kimono for contrasting elegance. Explore our sexy plus size outfits to create daring overlays, or discover our plus size negligees to play with transparencies. This unique creation reveals your provocative side with scintillating sophistication.

To Top
View basket
Items
Total items
Struct
Entries: 108
actions
Array
available
number-1
brand
stringhouseofdesire
brandcode
stringhecs
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
stringHouse of Desire
breasts
stringna
careinstructions
string
categories
stringdivasboudoir.lingerie.sexylingerie.bustier
category
stringsexylingerie
categorygender
stringf
categorymediadatas
Struct
adult
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string276
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/lingerie/sexylingerie/bustier.jpg
type
stringimg
width
string600
divasboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
fetishboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
latexboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
legsboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
lustboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
private
Struct
height
string1016
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/private/default.jpg
type
stringimg
width
string703
smboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
categorysizerange
stringauto
colorinfos
Query
Template: /system/api/product/colors.cfc:13
Execution Time: 0.703 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,deeprose') > 0
and product_variations.productuid = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1blackcolorblakblackblack#000000-10
2deeprosecolordrosdeeprosepink#880E4F-10
colorrange
stringpink
colors
stringblack,deeprose
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-07-20 18:12:17'}
defect
number0
dimensions
Struct
Entries: 14
acrylicbones
string
backsideheight
string
diameter
string
flatsteelbones
string
frontsideheight
string
fullheight
string
length
string
modestysize
string
panels
string
sides
string
spiralsteelbones
string
totallength
string
unit
stringcm
wiresize
string
display
stringall
displayfrom
string
displayto
string
grossweight
string
hasbrandinfos
booleanfalse
hascareinstructions
booleantrue
hascolorinfos
booleantrue
hascompositions
booleanfalse
hasdescription
booleantrue
hasdimensions
booleanfalse
hasmaterials
booleanfalse
hasotherspecifications
booleanfalse
haspromo
number0
hasshortdescription
booleantrue
hassizeinfos
booleantrue
hasspecifications
booleantrue
hasstockinfos
booleanfalse
hasstylingtips
booleantrue
hasusageinstructions
booleantrue
hasvariations
booleantrue
import
string
inpromo
number0
instockvariations
number0
isactive
number1
iscustommade
number0
isdivasize
number0
isfirstprice
number0
isfixedprice
number0
ishot
number0
isnew
number0
isonline
number0
isoutletprice
number0
itemprice
number48.2917
itempromo
string
key
stringensemble-de-chemise-porte-jarretelles--yasmine
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-08-07 11:59:27'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.608 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('b0ed1cdb-9d86-4302-b0ab33f3a45cafd1',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.34 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 <> 'SBBU5925'
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
string831
isprivate
string0
rating
stringall
src
string/photobank/products/hecs/sbbu5925/guepiere_grande_taille_yasmine_noire.jpg
type
stringimg
width
string575
back
Struct
height
string834
isprivate
string0
rating
stringall
src
string/photobank/products/hecs/sbbu5925/guepiere_grande_taille_yasmine_mauve_dos.jpg
type
stringimg
width
string577
default
Struct
height
string856
isprivate
string0
rating
stringall
src
string/photobank/products/hecs/sbbu5925/guepiere_grande_taille_yasmine_mauve.jpg
type
stringimg
width
string592
variations
Struct
colors
Struct
black
Struct
height
string831
isprivate
string0
rating
stringall
src
string/photobank/products/hecs/sbbu5925/guepiere_grande_taille_yasmine_noire.jpg
type
stringimg
width
string575
deeprose
Struct
height
string856
isprivate
string0
rating
stringall
src
string/photobank/products/hecs/sbbu5925/guepiere_grande_taille_yasmine_mauve.jpg
type
stringimg
width
string592
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
mediagallery
string
metadatas
Struct
darkboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
divasboudoir
Struct
de
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Handwäsche mit kaltem Wasser, um die Pailletten zu erhalten</li> <li>Verwenden Sie ein mildes Waschmittel ohne Bleichmittel</li> <li>Liegend trocknen, um die Form der Bügel zu erhalten</li> <li>Niemals direkt über die glitzernde Maschenware bügeln</li> <li>Die Strassringe vorsichtig handhaben</li> <li>Hängend aufbewahren, um ein Hängenbleiben auf der Masche zu vermeiden</li> </ul>
description
string<p>Das Jasmin-Set revolutioniert die Kunst der Provokation mit seinem <strong>glitzernden Maschengewebe</strong>, das Ihre Silhouette in ein lebendes Kunstwerk verwandelt. Dieses einzigartige Material fängt bei jeder Bewegung das Licht ein und schafft ein hypnotisches visuelles Spiel, das alle Blicke auf sich zieht.</p> <p>Die <strong>hauchdünnen Bügel-Cups</strong> formen ein perfektes Dekollet&eacute; und bieten gleichzeitig außergewöhnlichen BH-Stütz, der <strong>sich ganz natürlich an jede Körperform anpasst</strong>. Das technische Design enthüllt Ihre Vorzüge mit einer beunruhigenden Präzision und sorgt für den begehrten Push-up-Effekt.</p> <p>strategisch platzierte <strong>O-Ringe aus Strass</strong> auf der Brust verleihen dem Ganzen eine kostbare Dimension, die den Unterschied ausmacht. Diese Details erzeugen einen raffinierten, frechen Effekt, der Ihre Kühnheit mit beunruhigender Eleganz offenbart. Die <strong>gewagten Ausschnitte auf der Vorder- und Rückseite</strong> enthüllen strategisch Ihre Haut und schaffen dieses verwirrende Spiel zwischen dem, was man sieht, und dem, was man verbirgt. Dieses Design formt Ihre Silhouette mit chirurgischer Präzision und enthüllt Ihre Sinnlichkeit aus jedem Blickwinkel.</p> <p>Die <strong>verstellbaren Strumpfhalter an den Oberschenkeln</strong> revolutionieren die traditionellen Codes, indem sie diese einzigartige, provokative Silhouette schaffen. Diese Innovation verwandelt Ihre Beine in einen absoluten Verführungsvorteil und fügt eine spielerische Dimension hinzu, die alle Fantasien weckt.</p> <p>Der <strong>transparente String mit Baumwollfutter</strong> rundet dieses außergewöhnliche Ensemble harmonisch ab. Diese Aufmerksamkeit für den Komfort zeigt das technische Know-how dieser Kreation, die ästhetische Kühnheit mit optimalem Wohlbefinden verbindet. Wenn Sie dieses Jasmin-Set tragen, bleiben Sie nicht länger unbemerkt - Sie werden zu diesem faszinierenden Wesen, das mit seiner glitzernden Anmut und seiner unwiderstehlichen magnetischen Aura hypnotisiert.</p>
guid
stringhttps://dev.divasboudoir.com/de/set-in-Übergröße-Jasmin-Glitzerndes-Netzhemd/sbbu5925.htm
highlights
string<ul> <li><strong>Glitzernde Maschenware</strong>, die bei jeder Bewegung das Licht fängt</li> <li><strong>Armaturierte Cups</strong>, die optimalen Halt und einen Push-up-Effekt bieten</li> <li><strong>O-Ring-Strassringe</strong> für einen frechen und raffinierten Effekt</li> <li><strong>Gewagte Ausschnitte</strong> auf der Vorder- und Rückseite, die Ihre Haut enthüllen</li> <li><strong>Verstellbare Oberschenkel-Strumpfbänder</strong> für einen einzigartigen provokativen Look</li> <li><strong>Passender transparenter String</strong> mit Baumwollfutter für Komfort</li> <li><strong>Eng anliegender Schnitt</strong>, der Ihre Silhouette natürlich formt</li> <li>Perfekt aufeinander abgestimmtes<strong>zweiteiliges Design</strong> aus Shirt und String</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringSet Jasmin in großen Größen aus glitzernder Maschenware: gepanzerte Cups, Strassringe, Strumpfbänder an den Oberschenkeln, transparenter String. Provokative Verführung | Diva's Boudoir
keywords
string
title
stringSet Jasmin in großer Größe aus glitzernder Maschenware | Diva's Boudoir
seotitle
stringSet große Größe Jasmin Glitzerndes Netzhemd mit Strumpfhaltern Oberschenkel
seouri
stringset-in-Übergröße-Jasmin-Glitzerndes-Netzhemd
specifications
string<ul> <li><strong>Set:</strong> Zweiteilig (passendes Shirt und String)</li> <li><strong>Material:</strong> Glitzernde Maschenware mit Shimmer-Effekt</li> <li><strong>Cups:</strong> Ultradünn armaturiert mit Stoffunterlage</li> <li><strong>Details:</strong> Strass-O-Ringe auf der Brust</li> <li><strong>Ausschnitte:</strong> Gewagt vorne und hinten</li> <li><strong>Strumpfbänder:</strong> Verstellbare Oberschenkel für einen provokativen Effekt</li> <li><strong>String:</strong> Transparent mit Baumwollunterlage</li> <li><strong>Schnitt:</strong> Eng anliegend und formend</li> </ul>
stylingtips
string<p>Veredeln Sie Ihr Jasmin-Ensemble mit unseren Netzstrümpfen <a href="https://www.divasboudoir.com/de/strumpfe-in-grossen-grossen/">in großen Größen</a>, um den provokativen Look zu vervollständigen, oder fügen Sie einen <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">Kimono in großen Größen</a> aus Seide für kontrastierende Eleganz hinzu. Erkunden Sie unsere <a href="https://www.divasboudoir.com/fr/tenues-sexy-grande-taille/">sexy Outfits</a> in <a href="https://www.divasboudoir.com/fr/tenues-sexy-grande-taille/">großen Größen</a>, um gewagte Lagenlooks zu kreieren, oder entdecken Sie unsere <a href="https://www.divasboudoir.com/de/neglige-in-grosse-grossen/">Neglig&eacute;s in großen Größen,</a> um mit Transparenzen zu spielen. Diese einzigartige Kreation enthüllt Ihre provokative Seite mit glitzernder Raffinesse.</p>
summary
string<p>Lassen Sie Ihrer provokativen Seite freien Lauf mit dem Ensemble Jasmin aus glitzernder Maschenware!</p> <p>Dieses eng anliegende Shirt formt Ihre Silhouette, während die Bügel-Cups Ihr Dekollet&eacute; betonen.</p> <p>Mit seinen Strassringen und den Strumpfhaltern an den Oberschenkeln verwandelt dieses Ensemble jede Frau in eine Göttin der Verführung.</p>
title
stringJasmin Set - Schimmernde Verführung und absolute Kühnheit
usageinstructions
string<p>Um <strong>Ihren üppigen Brüsten optimalen Halt</strong> zu geben, positionieren Sie vorsichtig die armaturierten Körbchen, bevor Sie die Strumpfbänder an den Oberschenkeln anpassen. Die glitzernde Maschenware schmiegt sich natürlich an Ihre Formen an, ohne einzuengen, und ermöglicht so absolute Bewegungsfreiheit. Die Strumpfhalter lassen sich leicht verstellen, um den gewünschten provokativen Effekt zu erzielen. Dieses Set <strong>passt sich</strong> dank seines figurbetonten Schnitts und der dehnbaren Materialien <strong>jeder Körperform an</strong>. Das Baumwollfutter des Strings garantiert optimalen Tragekomfort den ganzen Abend lang.</p>
el
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Πλύνετε στο χέρι με κρύο νερό για να διατηρήσετε τις πούλιες</li> <li>Χρησιμοποιήστε ήπιο απορρυπαντικό χωρίς λευκαντικούς παράγοντες</li> <li>Στεγνώστε σε επίπεδη επιφάνεια για να διατηρήσετε το σχήμα των κορδονιών</li> <li>Ποτέ μην σιδερώνετε απευθείας πάνω στο αφρώδες πλέγμα</li> <li>Χειριστείτε τα δαχτυλίδια με στρας με προσοχή</li> <li>Κρεμάστε τα για να αποφύγετε τα τσιμπήματα στο ύφασμα</li> </ul>
description
string<p>Το σετ Jasmin φέρνει επανάσταση στην τέχνη της πρόκλησης με το <strong>λαμπερό πλέγμα</strong> του που μεταμορφώνει τη σιλουέτα σας σε ένα ζωντανό έργο τέχνης. Αυτό το μοναδικό υλικό πιάνει το φως με κάθε κίνηση, δημιουργώντας ένα υπνωτικό οπτικό αποτέλεσμα που αιχμαλωτίζει το μάτι.</p> <p>Τα <strong>εξαιρετικά λεπτά underwired cups</strong> σμιλεύουν ένα τέλειο ντεκολτέ, ενώ προσφέρουν εξαιρετική στήριξη που <strong>προσαρμόζεται φυσικά σε όλα τα σχήματα σώματος</strong>. Ο τεχνικός σχεδιασμός τους αποκαλύπτει τα προσόντα σας με απίστευτη ακρίβεια, δημιουργώντας το περιζήτητο push-up αποτέλεσμα.</p> <p>τα στρατηγικά τοποθετημένα <strong>στρας O-ring</strong> στο μπούστο προσθέτουν αυτή την πολύτιμη διάσταση που κάνει τη διαφορά. Αυτές οι λεπτομέρειες δημιουργούν ένα εκλεπτυσμένο, άτακτο αποτέλεσμα που αποκαλύπτει την τόλμη σας με ανησυχητική κομψότητα. <strong>Τα τολμηρά κοψίματα μπροστά και πίσω</strong> αποκαλύπτουν στρατηγικά το δέρμα σας, δημιουργώντας αυτή την ανησυχητική αλληλεπίδραση μεταξύ του τι φαίνεται και του τι κρύβεται. Αυτό το σχέδιο σμιλεύει τη σιλουέτα σας με χειρουργική ακρίβεια, αποκαλύπτοντας τον αισθησιασμό σας από κάθε γωνία.</p> <p>Οι <strong>ρυθμιζόμενες καλτσοδέτες μέχρι τον μηρό</strong> φέρνουν επανάσταση στους παραδοσιακούς κώδικες δημιουργώντας αυτή τη μοναδικά προκλητική σιλουέτα. Αυτή η καινοτομία μετατρέπει τα πόδια σας στο απόλυτο πλεονέκτημα αποπλάνησης, προσθέτοντας αυτή την παιχνιδιάρικη διάσταση που ξυπνά κάθε φαντασίωση.</p> <p>Το <strong>διαφανές στρινγκ με βαμβακερή επένδυση</strong> ολοκληρώνει αυτό το εξαιρετικό σετ. Αυτή η προσοχή στην άνεση αποκαλύπτει την τεχνική εξειδίκευση αυτής της δημιουργίας, συνδυάζοντας την τολμηρή αισθητική με τη βέλτιστη ευεξία. Όταν φοράτε αυτό το σετ Jasmin, δεν περνάτε πλέον απαρατήρητη - γίνεστε αυτό το συναρπαστικό πλάσμα που υπνωτίζει με τη λαμπερή χάρη και την ακαταμάχητη μαγνητική αύρα του.</p>
guid
stringhttps://dev.divasboudoir.com/el/megalo-megethos-set-gIasemI-poykamIso-shimmering-mesh/sbbu5925.htm
highlights
string<ul> <li><strong>Το λαμπερό πλέγμα</strong> πιάνει το φως με κάθε κίνηση</li> <li><strong>Κορδόνια με μπανέλα</strong> για βέλτιστη στήριξη και push-up αποτέλεσμα</li> <li><strong>Στρας σε σχήμα δακτυλίου</strong> για ένα εκλεπτυσμένο, φλερτ αποτέλεσμα</li> <li><strong>Τολμηρά κοψίματα</strong> μπροστά και πίσω που αποκαλύπτουν το δέρμα σας</li> <li><strong>Ρυθμιζόμενες καλτσοδέτες</strong> για μια μοναδικά προκλητική εμφάνιση</li> <li><strong>Ασορτί διαφανές στρινγκ</strong> με βαμβακερή επένδυση για άνεση</li> <li><strong>Κούρεμα που αγκαλιάζει το σώμα</strong> σας και σμιλεύει φυσικά τη σιλουέτα σας</li> <li>Τέλεια συντονισμένο<strong>σχέδιο</strong> πουκάμισο και στρινγκ<strong>δύο τεμαχίων</strong> </li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringΣετ Jasmin μεγάλο μέγεθος με λαμπερό πλέγμα: ενισχυμένα κύπελλα, δαχτυλίδια με στρας, καλτσοδέτες μέχρι τον μηρό, διαφανές στρινγκ. Προκλητική αποπλάνηση | Diva's Boudoir
keywords
string
title
stringJasmine μεγάλο μέγεθος αφρώδες σετ πλέγματος | Diva's Boudoir
seotitle
stringJasmin μεγάλο μέγεθος shimmering mesh πουκάμισο με σετ καλτσοδέτες μέχρι τον μηρό
seouri
stringμεγάλο-μέγεθος-σετ-γιασεμί-πουκάμισο-shimmering-mesh
specifications
string<ul> <li><strong>Σετ:</strong> Δύο τεμάχια (ασορτί πουκάμισο και στρινγκ)</li> <li><strong>Υλικό:</strong> Αστραφτερό πλέγμα με λάμψη</li> <li><strong>Κύπελλα:</strong> Εξαιρετικά λεπτά ενσύρματα με υφασμάτινο υπόστρωμα</li> <li><strong>Λεπτομέρειες :</strong> Ο-δακτύλιος με στρας στο μπούστο</li> <li><strong>Cut-outs :</strong> Τολμηρά μπροστά και πίσω</li> <li><strong>Κορσέδες :</strong> Ρυθμιζόμενες στους μηρούς για προκλητικό αποτέλεσμα</li> <li><strong>Στρινγκ</strong>: Διαφανές με βαμβακερή επένδυση</li> <li><strong>Κοπή :</strong> Φόρμα που εφαρμόζει και σμιλεύει</li> </ul>
stylingtips
string<p>Ενισχύστε το σύνολο Jasmine με τις δικτυωτές <a href="https://www.divasboudoir.com/el/kaltses-megaloy-megethoys/">κάλτσες plus size</a> για να ολοκληρώσετε την προκλητική εμφάνιση, ή προσθέστε ένα μεταξωτό <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">κιμονό plus size</a> για κομψότητα σε αντίθεση. Εξερευνήστε τα <a href="https://www.divasboudoir.com/fr/tenues-sexy-grande-taille/">σέξι plus size σύνολά</a> μας για να δημιουργήσετε τολμηρές επικαλύψεις ή ανακαλύψτε <a href="https://www.divasboudoir.com/el/negklize-megaloy-megethoys/">τα plus size νεγκλιζέ</a> μας για να παίξετε με τις διαφάνειες. Αυτή η μοναδική δημιουργία αποκαλύπτει την προκλητική σας πλευρά με αστραφτερή εκλέπτυνση.</p>
summary
string<p>Απελευθερώστε την προκλητική σας πλευρά με το σετ Jasmin σε λαμπερό πλέγμα!</p> <p>Αυτό το εφαρμοστό σεμινάριο σμιλεύει τη σιλουέτα σας, ενώ τα ενισχυμένα κυπελάκια του αναδεικνύουν το ντεκολτέ σας.</p> <p>Με τα δαχτυλίδια με στρας και τις ψηλές καλτσοδέτες, αυτό το σετ μεταμορφώνει κάθε γυναίκα σε μια σαγηνευτική θεά.</p>
title
stringJasmine Set - Αστραφτερή αποπλάνηση και απόλυτη τόλμη
usageinstructions
string<p>Για <strong>τη βέλτιστη στήριξη του πλούσιου στήθους σας</strong>, τοποθετήστε απαλά τα ενισχυμένα κύπελλα πριν ρυθμίσετε τις καλτσοδέτες των μηρών. Το λαμπερό πλέγμα αγκαλιάζει φυσικά το σχήμα σας χωρίς περιορισμούς, επιτρέποντας απόλυτη ελευθερία κινήσεων. Οι καλτσοδέτες ρυθμίζονται εύκολα για να δημιουργήσετε το προκλητικό αποτέλεσμα που θέλετε. Αυτό το σετ <strong>προσαρμόζεται σε όλα τα σχήματα σώματος</strong> χάρη στο εφαρμοστό κόψιμο και τα ελαστικά υφάσματα. Η βαμβακερή επένδυση του στρινγκ εγγυάται βέλτιστη άνεση όλο το βράδυ.</p>
en
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Hand wash in cold water to preserve glitter</li> <li>Use a mild detergent without bleaching agents</li> <li>Dry flat to maintain the shape of the underwiring</li> <li>Never iron directly on the glittering mesh</li> <li>Handle rhinestone rings with care</li> <li>Store hanging to avoid snags on the mesh</li> </ul>
description
string<p>The Jasmin set revolutionizes the art of provocation with its <strong>glittering mesh</strong> that transforms your silhouette into a living work of art. This unique material catches the light with every movement, creating a hypnotic visual game that captivates every eye.</p> <p><strong>Ultra-fine underwired cups</strong> sculpt a perfect d&eacute;collet&eacute; while offering exceptional bra support that <strong>adapts naturally to all body types</strong>. Their technical design reveals your assets with uncanny precision, creating that sought-after push-up effect.</p> <p>strategically positioned <strong>O-ring rhinestones</strong> on the bust add that precious dimension that makes all the difference. These details create a sophisticated naughty effect that reveals your boldness with unsettling elegance. <strong>Bold front and back cut-outs</strong> strategically reveal your skin, creating that unsettling interplay between what shows and what hides. This design sculpts your silhouette with surgical precision, revealing your sensuality from every angle.</p> <p><strong>Adjustable thigh garters</strong> revolutionize traditional codes, creating a unique, provocative silhouette. This innovation transforms your legs into assets of absolute seduction, adding that playful dimension that awakens every fantasy.</p> <p>The <strong>transparent cotton-lined thong</strong> completes this exceptional set. This attention to comfort reveals the technical know-how of this creation, combining bold aesthetics with optimal well-being. When you wear this Jasmin set, you no longer go unnoticed - you become that fascinating creature who hypnotizes with her sparkling grace and irresistible magnetic aura.</p>
guid
stringhttps://dev.divasboudoir.com/en/plus-size-set-jasmin-chemise-maille-scintillante/sbbu5925.htm
highlights
string<ul> <li><strong>Shimmering mesh</strong> catches the light with every movement</li> <li><strong>Underwired cups</strong> for optimum support and a push-up effect</li> <li><strong>O-ring rhinestones</strong> for a sophisticated, flirtatious effect</li> <li><strong>Bold</strong> front and back<strong>cut-outs</strong> that reveal your skin</li> <li><strong>Adjustable thigh garters</strong> for a uniquely provocative look</li> <li><strong>Matching transparent thong</strong> with cotton lining for comfort</li> <li><strong>Form-fitting cut</strong> naturally sculpts your figure</li> <li>Perfectly coordinated<strong>two-piece</strong> shirt and thong<strong>design</strong> </li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringJasmin plus size sparkling mesh set: underwired cups, rhinestone rings, thigh-high garters, transparent thong. Provocative seduction | Diva's Boudoir
keywords
string
title
stringJasmine plus size sparkling mesh set | Diva's Boudoir
seotitle
stringPlus size set Jasmin shimmering mesh shirt with thigh-high garters
seouri
stringplus-size-set-jasmin-chemise-maille-scintillante
specifications
string<ul> <li><strong>Set:</strong> Two-piece (matching shirt and thong)</li> <li><strong>Material:</strong> Shimmering shimmer mesh</li> <li><strong>Cups:</strong> Ultra-fine wired with fabric underlay</li> <li><strong>Details:</strong> O-ring rhinestones on bust</li> <li><strong>Cut-outs :</strong> Bold front and back</li> <li><strong>Garters:</strong> Adjustable thighs for provocative effect</li> <li><strong>G-string</strong>: Transparent with cotton lining</li> <li><strong>Cut:</strong> Form-fitting and sculpting</li> </ul>
stylingtips
string<p>Enhance your Jasmine ensemble with our <a href="https://www.divasboudoir.com/en/socks-large-size/">plus size</a> fishnet <a href="https://www.divasboudoir.com/en/socks-large-size/">stockings</a> to complete the provocative look, or add a <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">plus size</a> silk <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">kimono</a> for contrasting elegance. Explore our <a href="https://www.divasboudoir.com/fr/tenues-sexy-grande-taille/">sexy plus size outfits</a> to create daring overlays, or discover our <a href="https://www.divasboudoir.com/en/plus-size-robes/">plus size negligees</a> to play with transparencies. This unique creation reveals your provocative side with scintillating sophistication.</p>
summary
string<p>Unleash your provocative side with the Jasmin set in shimmering mesh!</p> <p>This form-fitting chemise sculpts your figure, while its underwired cups sublimate your d&eacute;collet&eacute;.</p> <p>With its rhinestone rings and thigh-high garters, this set transforms every woman into a seductive goddess.</p>
title
stringJasmine Set - Sparkling seduction and absolute audacity
usageinstructions
string<p>For <strong>optimum support of your generous breasts</strong>, gently position the underwired cups before adjusting the thigh garters. The shimmering mesh naturally hugs your shape without constraint, allowing total freedom of movement. The garters are easily adjusted to create the provocative effect you desire. This set <strong>adapts to all body shapes</strong> thanks to its form-fitting cut and stretch fabrics. The cotton lining of the thong guarantees optimum comfort all evening long.</p>
es
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavar a mano en agua fría para conservar las lentejuelas</li> <li>Utilizar un detergente suave sin blanqueantes</li> <li>Secar en plano para mantener la forma de los aros</li> <li>No planchar nunca directamente sobre la malla brillante</li> <li>Manipule los anillos de strass con cuidado</li> <li>Colgar para evitar enganches en el tejido</li> </ul>
description
string<p>El conjunto Jasmin revoluciona el arte de la provocación con su <strong>malla brillante</strong> que transforma tu silueta en una obra de arte viviente. Este material único atrapa la luz con cada movimiento, creando un efecto visual hipnótico que cautiva la mirada.</p> <p><strong>Las copas ultrafinas con aros</strong> esculpen un escote perfecto al tiempo que ofrecen un sujetador excepcional que <strong>se adapta con naturalidad a todas las formas del cuerpo</strong>. Su diseño técnico revela sus activos con una precisión asombrosa, creando ese codiciado efecto push-up.</p> <p><strong>los brillantes</strong> estratégicamente situados en el busto añaden esa preciosa dimensión que marca la diferencia. Estos detalles crean un efecto sofisticado y travieso que revela tu atrevimiento con una elegancia inquietante. <strong>Las atrevidas aberturas en la parte delantera y trasera</strong> revelan estratégicamente tu piel, creando esa inquietante interacción entre lo que se muestra y lo que se oculta. Este diseño esculpe tu silueta con precisión quirúrgica, revelando tu sensualidad desde todos los ángulos.</p> <p><strong>Los ligueros ajustables hasta el muslo</strong> revolucionan los códigos tradicionales creando esta silueta única y provocativa. Esta innovación convierte tus piernas en la mejor baza de seducción, añadiendo esa dimensión lúdica que despierta todas las fantasías.</p> <p>El <strong>tanga transparente con forro de</strong> algodón completa este conjunto excepcional. Esta atención al confort revela la pericia técnica de esta creación, que combina una estética audaz con un bienestar óptimo. Cuando llevas este conjunto Jasmin, ya no pasas desapercibida: te conviertes en esta criatura fascinante que hipnotiza con su gracia chispeante y su aura magnética irresistible.</p>
guid
stringhttps://dev.divasboudoir.com/es/talla-grande-conjunto-jazmín-camisa-malla-brillante/sbbu5925.htm
highlights
string<ul> <li><strong>Malla</strong> brillante que capta la luz con cada movimiento</li> <li><strong>Copas con aros</strong> para una sujeción óptima y un efecto push-up</li> <li><strong>Pedrería en forma de O</strong> para un efecto sofisticado y coqueto</li> <li><strong>Atrevidas aberturas</strong> delanteras y traseras que dejan al descubierto tu piel</li> <li><strong>Ligas ajustables en los muslos</strong> para un look provocador único</li> <li><strong>Tanga transparente a juego</strong> con forro de algodón para mayor comodidad</li> <li><strong>Corte ceñido</strong> al cuerpo que esculpe la silueta de forma natural</li> <li><strong>Diseño</strong> perfectamente coordinado<strong>de</strong> camiseta y tanga de<strong>dos piezas</strong> </li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringConjunto de malla brillante Jasmin talla grande: copas con aros, aros de strass, ligueros hasta el muslo, tanga transparente. Seducción provocativa | Diva's Boudoir
keywords
string
title
stringConjunto de malla brillante talla grande Jasmine | Diva's Boudoir
seotitle
stringJasmin talla grande camisa de malla brillante con ligueros hasta el muslo conjunto
seouri
stringtalla-grande-conjunto-jazmín-camisa-malla-brillante
specifications
string<ul> <li><strong>Conjunto:</strong> Dos piezas (camiseta y tanga a juego)</li> <li><strong>Material:</strong> Malla brillante</li> <li><strong>Copas :</strong> Alambre ultrafino con base de tela</li> <li><strong>Detalles :</strong> Anilla de strass en el pecho</li> <li><strong>Recortes :</strong> Atrevidos por delante y por detrás</li> <li><strong>Ligueros :</strong> Ajustables en los muslos para un efecto provocativo</li> <li><strong>Tanga</strong>: Transparente con forro de algodón</li> <li><strong>Corte :</strong> Moldeado y esculpido</li> </ul>
stylingtips
string<p>Mejora tu conjunto Jasmine con nuestras <a href="https://www.divasboudoir.com/es/medias-grandes/">medias de</a> rejilla <a href="https://www.divasboudoir.com/es/medias-grandes/">talla grande</a> para completar el look provocativo, o añade un <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">kimono</a> de seda <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">talla grande</a> para contrastar la elegancia. Explora nuestros <a href="https://www.divasboudoir.com/fr/tenues-sexy-grande-taille/">sexys conjuntos de talla grande</a> para crear atrevidas superposiciones, o descubre nuestros <a href="https://www.divasboudoir.com/es/picardias-talla-grande/">picardías</a> de <a href="https://www.divasboudoir.com/es/picardias-talla-grande/">talla</a> grande para jugar con las transparencias. Esta creación única revela tu lado provocativo con una sofisticación chispeante.</p>
summary
string<p>Desata tu lado más provocativo con el conjunto Jasmin de malla brillante</p> <p>Este ajustado picardías esculpe tu figura, mientras que sus copas con aros realzan tu escote.</p> <p>Con sus aros de strass y sus ligueros hasta el muslo, este conjunto transforma a toda mujer en una seductora diosa.</p>
title
stringJasmine Set - Seducción chispeante y atrevimiento absoluto
usageinstructions
string<p>Para <strong>una sujeción óptima de su generoso busto</strong>, coloque suavemente las copas con aros antes de ajustar los ligueros de los muslos. La malla brillante abraza naturalmente tu figura sin constreñirte, permitiendo una total libertad de movimientos. Los ligueros son fáciles de ajustar para crear el efecto provocativo que desee. Este conjunto <strong>se adapta a todas las formas</strong> gracias a su corte ceñido y sus tejidos elásticos. El forro de algodón del tanga garantiza un confort óptimo durante toda la velada.</p>
fr
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavage &agrave; la main &agrave; l'eau froide pour pr&eacute;server les paillettes</li> <li>Utiliser une lessive douce sans agents blanchissants</li> <li>S&eacute;chage &agrave; plat pour maintenir la forme des armatures</li> <li>Ne jamais repasser directement sur la maille scintillante</li> <li>Manipuler d&eacute;licatement les anneaux strass</li> <li>Ranger suspendu pour &eacute;viter les accrocs sur la maille</li> </ul>
description
string<p>L'ensemble Jasmin r&eacute;volutionne l'art de la provocation avec sa <strong>maille scintillante</strong> qui transforme votre silhouette en &oelig;uvre d'art vivante. Cette mati&egrave;re unique accroche la lumi&egrave;re &agrave; chaque mouvement, cr&eacute;ant un jeu visuel hypnotique qui captive tous les regards.</p> <p>Les&nbsp;<strong>bonnets armatur&eacute;s ultra-fins</strong> sculptent un d&eacute;collet&eacute; parfait tout en offrant un soutien exceptionnel qui <strong>s'adapte naturellement &agrave; toutes les morphologies</strong>. Leur conception technique r&eacute;v&egrave;le vos atouts avec une pr&eacute;cision troublante, cr&eacute;ant cet effet push-up si recherch&eacute;.</p> <p>&nbsp;Les <strong>anneaux strass O-ring</strong> positionn&eacute;s strat&eacute;giquement sur la poitrine ajoutent cette dimension pr&eacute;cieuse qui fait toute la diff&eacute;rence. Ces d&eacute;tails cr&eacute;ent un effet coquin sophistiqu&eacute; qui r&eacute;v&egrave;le votre audace avec une &eacute;l&eacute;gance troublante. Les <strong>d&eacute;coupes audacieuses devant et dos</strong> r&eacute;v&egrave;lent strat&eacute;giquement votre peau, cr&eacute;ant ce jeu troublant entre ce qui se montre et ce qui se cache. Cette conception sculpte votre silhouette avec une pr&eacute;cision chirurgicale, r&eacute;v&eacute;lant votre sensualit&eacute; sous tous les angles.</p> <p>Les&nbsp;<strong>jarreti&egrave;res cuisses ajustables</strong> r&eacute;volutionnent les codes traditionnels en cr&eacute;ant cette silhouette provocatrice unique. Cette innovation transforme vos jambes en atouts de s&eacute;duction absolue, ajoutant cette dimension ludique qui &eacute;veille tous les fantasmes.</p> <p>Le&nbsp;<strong>string transparent avec doublure coton</strong> compl&egrave;te harmonieusement cet ensemble d'exception. Cette attention au confort r&eacute;v&egrave;le le savoir-faire technique de cette cr&eacute;ation, alliant audace esth&eacute;tique et bien-&ecirc;tre optimal. Quand vous portez cet ensemble Jasmin, vous ne passez plus inaper&ccedil;ue - vous devenez cette cr&eacute;ature fascinante qui hypnotise avec sa gr&acirc;ce scintillante et son aura magn&eacute;tique irr&eacute;sistible.</p>
guid
stringhttps://dev.divasboudoir.com/fr/ensemble-grande-taille-jasmin-chemise-maille-scintillante/sbbu5925.htm
highlights
string<ul> <li><strong>Maille scintillante</strong> qui accroche la lumi&egrave;re &agrave; chaque mouvement</li> <li><strong>Bonnets armatur&eacute;s</strong> qui offrent un maintien optimal et un effet push-up</li> <li><strong>Anneaux strass O-ring</strong> pour un effet coquin et sophistiqu&eacute;</li> <li><strong>D&eacute;coupes audacieuses</strong> devant et dos qui r&eacute;v&egrave;lent votre peau</li> <li><strong>Jarreti&egrave;res cuisses ajustables</strong> pour un look provocateur unique</li> <li><strong>String transparent assorti</strong> avec doublure coton pour le confort</li> <li><strong>Coupe moulante</strong> qui sculpte naturellement votre silhouette</li> <li><strong>Design deux pi&egrave;ces</strong> chemise et string parfaitement coordonn&eacute;s</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringEnsemble Jasmin grande taille maille scintillante : bonnets armaturés, anneaux strass, jarretières cuisses, string transparent. Séduction provocatrice | Diva's Boudoir
keywords
string
title
stringEnsemble Jasmin grande taille maille scintillante | Diva's Boudoir
seotitle
stringEnsemble grande taille Jasmin chemise maille scintillante avec jarretières cuisses
seouri
stringensemble-grande-taille-jasmin-chemise-maille-scintillante
specifications
string<ul> <li><strong>Ensemble :</strong> Deux pi&egrave;ces (chemise et string assortis)</li> <li><strong>Mati&egrave;re :</strong> Maille scintillante effet shimmer</li> <li><strong>Bonnets :</strong> Armatur&eacute;s ultra-fins avec sous-couche tissu</li> <li><strong>D&eacute;tails :</strong> Anneaux strass O-ring sur la poitrine</li> <li><strong>D&eacute;coupes :</strong> Audacieuses devant et dos</li> <li><strong>Jarreti&egrave;res :</strong> Cuisses ajustables pour effet provocateur</li> <li><strong>String :</strong> Transparent avec doublure coton</li> <li><strong>Coupe :</strong> Moulante et sculptante</li> </ul>
stylingtips
string<p>Sublimez votre ensemble Jasmin avec nos <a href="https://www.divasboudoir.com/fr/bas-grande-taille/">bas grande taille</a> r&eacute;sille pour compl&eacute;ter le look provocateur, ou ajoutez un <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">kimono grande taille</a> en soie pour une &eacute;l&eacute;gance contrast&eacute;e. Explorez nos <a href="https://www.divasboudoir.com/fr/tenues-sexy-grande-taille/">tenues sexys grande taille</a> pour cr&eacute;er des superpositions audacieuses, ou d&eacute;couvrez nos <a href="https://www.divasboudoir.com/fr/deshabille-grande-taille/">d&eacute;shabill&eacute;s grande taille</a> pour jouer avec les transparences. Cette cr&eacute;ation unique r&eacute;v&egrave;le votre c&ocirc;t&eacute; provocateur avec une sophistication scintillante.</p>
summary
string<p>Lib&eacute;rez votre c&ocirc;t&eacute; provocateur avec l'ensemble Jasmin en maille scintillante !</p> <p>Cette chemise moulante sculpte votre silhouette tandis que ses bonnets &agrave; armatures subliment votre d&eacute;collet&eacute;.</p> <p>Avec ses anneaux strass et ses jarreti&egrave;res cuisses, cet ensemble transforme chaque femme en d&eacute;esse de la s&eacute;duction.</p>
title
stringEnsemble Jasmin - Séduction Scintillante et Audace Absolue
usageinstructions
string<p>Pour un <strong>maintien optimal de votre poitrine g&eacute;n&eacute;reuse</strong>, positionnez d&eacute;licatement les bonnets armatur&eacute;s avant d'ajuster les jarreti&egrave;res cuisses. La maille scintillante &eacute;pouse naturellement vos formes sans contrainte, permettant une libert&eacute; de mouvement totale. Les jarreti&egrave;res se r&egrave;glent facilement pour cr&eacute;er l'effet provocateur d&eacute;sir&eacute;. Cet ensemble <strong>s'adapte &agrave; toutes les morphologies</strong> gr&acirc;ce &agrave; sa coupe moulante et ses mati&egrave;res extensibles. La doublure coton du string garantit un confort optimal toute la soir&eacute;e.</p>
it
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavare a mano in acqua fredda per preservare le paillettes</li> <li>Utilizzare un detergente delicato senza agenti sbiancanti</li> <li>Asciugare in piano per mantenere la forma del sottofilo</li> <li>Non stirare mai direttamente sulle maglie scintillanti</li> <li>Maneggiare con cura gli anelli di strass</li> <li>Appendere per evitare strappi al tessuto</li> </ul>
description
string<p>Il set Jasmin rivoluziona l'arte della provocazione con la sua <strong>rete scintillante</strong> che trasforma la silhouette in un'opera d'arte vivente. Questo materiale unico cattura la luce a ogni movimento, creando un effetto visivo ipnotico che cattura lo sguardo.</p> <p>Le <strong>coppe ultrasottili con ferretto</strong> scolpiscono un d&eacute;collet&eacute; perfetto e offrono un reggiseno eccezionale che <strong>si adatta naturalmente a tutte le forme del corpo</strong>. Il loro design tecnico rivela le vostre forme con una precisione sorprendente, creando il ricercato effetto push-up.</p> <p><strong>gli strass O-ring</strong> strategicamente posizionati sul seno aggiungono quella dimensione preziosa che fa la differenza. Questi dettagli creano un effetto sofisticato e malizioso che rivela la vostra audacia con un'eleganza sconvolgente. <strong>Audaci cut-out sul davanti e sul retro</strong> rivelano strategicamente la vostra pelle, creando un'inquietante interazione tra ciò che è mostrato e ciò che è nascosto. Questo design scolpisce la silhouette con precisione chirurgica, rivelando la vostra sensualità da ogni angolazione.</p> <p>Il <strong>reggicalze regolabile</strong> rivoluziona i codici tradizionali creando una silhouette unica e provocante. Questa innovazione trasforma le vostre gambe nella risorsa di seduzione per eccellenza, aggiungendo quella dimensione giocosa che risveglia ogni fantasia.</p> <p>Il <strong>perizoma trasparente con fodera in cotone</strong> completa questo set eccezionale. L'attenzione al comfort rivela la competenza tecnica di questa creazione, che unisce un'estetica audace a un benessere ottimale. Quando indossate questo set Jasmin, non passate più inosservate: diventate questa affascinante creatura che ipnotizza con la sua grazia scintillante e la sua irresistibile aura magnetica.</p>
guid
stringhttps://dev.divasboudoir.com/it/set-taglia-grande-camicia-jasmine-maglia-scintillante/sbbu5925.htm
highlights
string<ul> <li><strong>La rete scintillante</strong> cattura la luce ad ogni movimento</li> <li><strong>Coppe con ferretto</strong> per un sostegno ottimale e un effetto push-up</li> <li><strong>Strass a forma di anello per</strong> un effetto sofisticato e civettuolo</li> <li><strong>Audaci cut-out</strong> anteriori e posteriori che lasciano intravedere la pelle</li> <li><strong>Giarrettiere regolabili sulle cosce</strong> per un look unico e provocante</li> <li><strong>Perizoma trasparente abbinato</strong> con fodera in cotone per il massimo comfort</li> <li><strong>Il taglio aderente al corpo</strong> scolpisce la figura in modo naturale</li> <li>Camicia e perizoma in<strong>due pezzi</strong> perfettamente coordinati</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringSet Jasmin taglia grande in rete scintillante: coppe con ferretto, anelli di strass, reggicalze, perizoma trasparente. Seduzione provocante | Diva's Boudoir
keywords
string
title
stringSet di rete scintillante taglia grande Jasmine | Diva's Boudoir
seotitle
stringJasmin taglia grande camicia in rete scintillante con reggicalze
seouri
stringset-taglia-grande-camicia-jasmine-maglia-scintillante
specifications
string<ul> <li><strong>Set:</strong> Due pezzi (camicia e perizoma coordinati)</li> <li><strong>Materiale:</strong> Rete scintillante</li> <li><strong>Coppe :</strong> Ultra finemente cablate con sottotazza in tessuto</li> <li><strong>Dettagli :</strong> O-ring con strass sul busto</li> <li><strong>Tagli:</strong> Audaci davanti e dietro</li> <li><strong>Giarrettiere :</strong> Regolabili sulle cosce per un effetto provocante</li> <li><strong>Perizoma</strong>: Trasparente con fodera in cotone</li> <li><strong>Taglio :</strong> aderente e modellante</li> </ul>
stylingtips
string<p>Arricchite il vostro ensemble Jasmine con le nostre <a href="https://www.divasboudoir.com/it/calze-di-grandi-dimensioni/">calze</a> a rete <a href="https://www.divasboudoir.com/it/calze-di-grandi-dimensioni/">taglia grande</a> per completare il look provocante, o aggiungete un <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">kimono</a> di seta <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">taglia grande</a> per un'eleganza a contrasto. Esplorate i nostri <a href="https://www.divasboudoir.com/fr/tenues-sexy-grande-taille/">completi sexy taglia grande</a> per creare audaci sovrapposizioni o scoprite i nostri <a href="https://www.divasboudoir.com/it/vestaglia-taglia-grande/">negligé taglia grande</a> per giocare con le trasparenze. Questa creazione unica rivela il vostro lato provocante con una raffinatezza scintillante.</p>
summary
string<p>Liberate il vostro lato provocante con il set Jasmin in rete scintillante!</p> <p>Questa chemise aderente scolpisce la vostra figura, mentre le coppe con ferretto esaltano il vostro d&eacute;collet&eacute;.</p> <p>Con i suoi anelli di strass e le giarrettiere alte fino alle cosce, questo set trasforma ogni donna in una dea seducente.</p>
title
stringSet Gelsomino - Seduzione scintillante e audacia assoluta
usageinstructions
string<p>Per un <strong>sostegno ottimale del vostro seno generoso</strong>, posizionate delicatamente le coppe con ferretto prima di regolare i reggicosce. La rete scintillante abbraccia naturalmente le vostre forme senza costringervi, permettendovi una totale libertà di movimento. Le giarrettiere sono facili da regolare per creare l'effetto provocante desiderato. Questo set <strong>si adatta a tutte le forme del corpo</strong> grazie al taglio aderente e ai tessuti elasticizzati. La fodera in cotone del perizoma garantisce un comfort ottimale per tutta la serata.</p>
nl
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Handwas in koud water om de lovertjes te behouden</li> <li>Gebruik een mild wasmiddel zonder bleekmiddelen</li> <li>Plat drogen om de vorm van de bedrading te behouden</li> <li>Strijk nooit rechtstreeks op het fonkelende gaas</li> <li>Ga voorzichtig om met strassringen</li> <li>Ophangen om te voorkomen dat de stof blijft haken</li> </ul>
description
string<p>De Jasmin-set brengt een revolutie teweeg in de kunst van het provoceren met het <strong>glinsterende gaas</strong> dat je silhouet verandert in een levend kunstwerk. Dit unieke materiaal vangt het licht bij elke beweging en cre&euml;ert zo een hypnotiserend visueel effect dat de aandacht trekt.</p> <p>De <strong>ultradunne beugelcups</strong> vormen een perfect decollet&eacute; en bieden uitzonderlijke bh die <strong>zich op natuurlijke wijze aan alle lichaamsvormen aanpast</strong>. Het technische ontwerp onthult je pluspunten met griezelige precisie en cre&euml;ert dat gewilde push-up effect.</p> <p>strategisch geplaatste <strong>O-ring strassteentjes</strong> op de buste voegen die kostbare dimensie toe die het verschil maakt. Deze details cre&euml;ren een geraffineerd, ondeugend effect dat je brutaliteit onthult met een verontrustende elegantie. <strong>De gedurfde uitsnijdingen aan de voor- en achterkant</strong> onthullen je huid op een strategische manier, waardoor een verontrustend samenspel ontstaat tussen wat getoond wordt en wat verborgen blijft. Dit ontwerp vormt je silhouet met chirurgische precisie en onthult je sensualiteit vanuit elke hoek.</p> <p>De <strong>verstelbare dij-hoge kousenbanden</strong> revolutioneren traditionele codes door dit unieke provocerende silhouet te cre&euml;ren. Deze innovatie verandert je benen in de ultieme verleiding en voegt die speelse dimensie toe die elke fantasie doet ontwaken.</p> <p>De <strong>transparante string met katoenen voering</strong> maakt deze uitzonderlijke set compleet. Deze aandacht voor comfort onthult de technische expertise van deze creatie, die gedurfde esthetiek combineert met optimaal welzijn. Als je dit Jasmin-setje draagt, blijf je niet langer onopgemerkt - je wordt dit fascinerende wezen dat hypnotiseert met haar sprankelende gratie en onweerstaanbare magnetische uitstraling.</p>
guid
stringhttps://dev.divasboudoir.com/nl/grote-maat-set-jasmijn-shirt-glinsterend-mesh/sbbu5925.htm
highlights
string<ul> <li><strong>Glinsterende mesh</strong> vangt het licht bij elke beweging</li> <li><strong>Beugelcups</strong> voor optimale ondersteuning en een push-up effect</li> <li><strong>O-ring strassteentjes</strong> voor een geraffineerd, flirterig effect</li> <li><strong>Gewaagde uitsnijdingen</strong> voor en achter die je huid onthullen</li> <li><strong>Verstelbare dijbeenkousenband</strong> voor een unieke, uitdagende look</li> <li><strong>Bijpassende transparante string</strong> met katoenen voering voor comfort</li> <li><strong>De nauwsluitende snit</strong> geeft je silhouet een natuurlijke vorm</li> <li>Perfect geco&ouml;rdineerd<strong>tweedelig</strong> shirt en string<strong>ontwerp</strong></li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringJasmin grote maat glinsterende mesh set: beugel cups, strass ringen, dij-hoge kousenbanden, transparante string. Provocerende verleiding | Diva's Boudoir
keywords
string
title
stringJasmine grote maat sparkling mesh set | Diva's Boudoir
seotitle
stringJasmin grote maat glinsterende mesh shirt met dijhoge kousenband set
seouri
stringgrote-maat-set-jasmijn-shirt-glinsterend-mesh
specifications
string<ul> <li><strong>Set:</strong> Tweedelig (bijpassend shirt en string)</li> <li><strong>Materiaal:</strong> Glinsterende mesh</li> <li><strong>Cups :</strong> Ultrafijn bedraad met stoffen onderlaag</li> <li><strong>Details :</strong> O-ring strassteentjes op de buste</li> <li><strong>Uitsparingen :</strong> Gewaagde voor- en achterkant</li> <li><strong>Kousenband :</strong> Verstelbare dijen voor een uitdagend effect</li> <li><strong>G-string</strong>: Transparant met katoenen voering</li> <li><strong>Snit :</strong> Aansluitend en modellerend</li> </ul>
stylingtips
string<p>Verfraai je Jasmine ensemble met onze <a href="https://www.divasboudoir.com/nl/grote-maat-kousen/">grote maten</a> visnet <a href="https://www.divasboudoir.com/nl/grote-maat-kousen/">kousen</a> om de provocerende look compleet te maken, of voeg een <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">grote maat</a> zijden <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">kimono</a> toe voor contrasterende elegantie. Ontdek onze <a href="https://www.divasboudoir.com/fr/tenues-sexy-grande-taille/">sexy outfits van grote maten</a> om gewaagde overlays te cre&euml;ren of ontdek onze <a href="https://www.divasboudoir.com/nl/grote-maat-neglige/">neglig&eacute;s van grote maten</a> om te spelen met transparanties. Deze unieke creatie onthult je uitdagende kant met sprankelende verfijning.</p>
summary
string<p>Laat je van je uitdagende kant zien met de Jasmin set van glinsterend mesh!</p> <p>Deze nauwsluitende chemise vormt je figuur, terwijl de beugelcups je decollet&eacute; verbeteren.</p> <p>Met zijn strasringen en dijhoge kousenbanden verandert deze set elke vrouw in een verleidelijke godin.</p>
title
stringJasmijn Set - Sprankelende verleiding en absolute durf
usageinstructions
string<p>Voor <strong>optimale ondersteuning van je royale buste</strong> plaats je de beugelcups voorzichtig voordat je de dijbeugels aanpast. Het glinsterende gaas omhelst op natuurlijke wijze je vorm zonder beperkingen, waardoor je volledige bewegingsvrijheid hebt. De kousenbanden zijn eenvoudig te verstellen om het provocerende effect te cre&euml;ren dat jij wilt. Dit setje <strong>past zich aan alle lichaamsvormen</strong> aan dankzij de vormvaste snit en de stretchstoffen. De katoenen voering van de string garandeert optimaal comfort, de hele avond lang.</p>
pt
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavar à mão em água fria para preservar as lantejoulas</li> <li>Utilizar um detergente suave sem agentes branqueadores</li> <li>Secar na horizontal para manter a forma dos fios inferiores</li> <li>Nunca passar a ferro diretamente sobre a malha brilhante</li> <li>Manusear as argolas de strass com cuidado</li> <li>Pendurar para evitar que o tecido fique preso</li> </ul>
description
string<p>O conjunto Jasmin revoluciona a arte da provocação com a sua <strong>malha brilhante</strong> que transforma a sua silhueta numa obra de arte viva. Este material único capta a luz a cada movimento, criando um efeito visual hipnótico que cativa o olhar.</p> <p><strong>As copas ultra-finas com arame</strong> esculpem um decote perfeito, oferecendo um apoio excecional que <strong>se adapta naturalmente a todas as formas do corpo</strong>. O seu design técnico revela os seus atributos com uma precisão incrível, criando o tão procurado efeito push-up.</p> <p><strong>os strass em O-ring</strong> estrategicamente colocados no busto acrescentam aquela dimensão preciosa que faz toda a diferença. Estes detalhes criam um efeito sofisticado e atrevido que revela a sua ousadia com uma elegância inquietante. <strong>Recortes ousados na frente e nas costas</strong> revelam estrategicamente a sua pele, criando aquela interação inquietante entre o que é mostrado e o que é escondido. Este design esculpe a sua silhueta com precisão cirúrgica, revelando a sua sensualidade de todos os ângulos.</p> <p>As <strong>ligas ajustáveis na altura das coxas</strong> revolucionam os códigos tradicionais, criando esta silhueta única e provocante. Esta inovação transforma as suas pernas no derradeiro trunfo de sedução, acrescentando aquela dimensão lúdica que desperta todas as fantasias.</p> <p>A <strong>tanga transparente com forro de algodão</strong> completa este conjunto excecional. Esta atenção ao conforto revela a perícia técnica desta criação, combinando uma estética arrojada com um bem-estar ótimo. Ao usar este conjunto Jasmin, já não passa despercebida, transforma-se nesta criatura fascinante que hipnotiza com a sua graça cintilante e a sua aura magnética irresistível.</p>
guid
stringhttps://dev.divasboudoir.com/pt/conjunto-tamanho-grande-jasmim-camisa-malha-cintilante/sbbu5925.htm
highlights
string<ul> <li><strong>A malha cintilante</strong> capta a luz em cada movimento</li> <li><strong>Copas com aros</strong> para um apoio ótimo e um efeito push-up</li> <li><strong>Brilhantes em forma de anel</strong> para um efeito sofisticado e sedutor</li> <li><strong>Recortes ousados</strong> à frente e atrás que revelam a sua pele</li> <li><strong>Ligas ajustáveis nas coxas</strong> para um look único e provocante</li> <li><strong>Tanga transparente a condizer</strong> com forro de algodão para maior conforto</li> <li><strong>O corte justo ao corpo</strong> esculpe naturalmente a sua figura</li> <li>Camisa e tanga<strong>de duas peças</strong> perfeitamente coordenadas</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringConjunto de malha cintilante Jasmin tamanho grande: copas com aros, anéis de strass, ligas até à coxa, tanga transparente. Sedução provocante | Diva's Boudoir
keywords
string
title
stringConjunto de malha cintilante Jasmine tamanho grande | Diva's Boudoir
seotitle
stringConjunto de camisa de malha cintilante e ligas até à coxa Jasmin tamanho grande
seouri
stringconjunto-tamanho-grande-jasmim-camisa-malha-cintilante
specifications
string<ul> <li><strong>Conjunto:</strong> Duas peças (camisa e tanga a condizer)</li> <li><strong>Material:</strong> Malha cintilante</li> <li><strong>Copas :</strong> Com arame ultra-fino e base em tecido</li> <li><strong>Pormenores:</strong> Anel em O com brilhantes no busto</li> <li><strong>Recortes :</strong> Frente e costas ousadas</li> <li><strong>Ligas :</strong> Ajustáveis nas coxas para um efeito provocante</li> <li><strong>Fio-dental</strong>: Transparente com forro de algodão</li> <li><strong>Corte :</strong> Adaptável e esculpido</li> </ul>
stylingtips
string<p>Melhore o seu conjunto Jasmine com as nossas <a href="https://www.divasboudoir.com/pt/meias-de-tamanho-grande/">meias</a> de rede <a href="https://www.divasboudoir.com/pt/meias-de-tamanho-grande/">plus size</a> para completar o visual provocante, ou adicione um <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">quimono</a> de seda <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">plus size</a> para uma elegância contrastante. Explore os nossos <a href="https://www.divasboudoir.com/fr/tenues-sexy-grande-taille/">conjuntos sexy plus size</a> para criar sobreposições ousadas, ou descubra os nossos <a href="https://www.divasboudoir.com/pt/batotas-plus-size/">negligees plus size</a> para brincar com as transparências. Esta criação única revela o seu lado provocante com uma sofisticação cintilante.</p>
summary
string<p>Liberte o seu lado provocante com o conjunto Jasmin em malha cintilante!</p> <p>Esta camisa de noite esculpe a sua figura, enquanto as copas com aros realçam o seu decote.</p> <p>Com os seus anéis de strass e ligas até às coxas, este conjunto transforma qualquer mulher numa deusa sedutora.</p>
title
stringConjunto Jasmine - Sedução cintilante e ousadia absoluta
usageinstructions
string<p>Para um <strong>apoio ótimo do seu busto generoso</strong>, posicione suavemente as copas com arame antes de ajustar as ligas das coxas. A malha cintilante abraça naturalmente a sua forma sem constrangimentos, permitindo uma total liberdade de movimentos. As ligas são fáceis de ajustar para criar o efeito provocante que deseja. Este conjunto <strong>adapta-se a todas as formas do corpo</strong> graças ao seu corte justo e aos tecidos elásticos. O forro em algodão da tanga garante um conforto ótimo durante toda a noite.</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
stringENSEMBLE DE CHEMISE PORTE-JARRETELLES yasmine
netweight
string
nextshipment
stringtoday
ordered
number1
orderidx
number0
origin
string
originalsize
string
packaging
number0
productshipment
stringauto
productuid
stringB0ED1CDB-9D86-4302-B0AB33F3A45CAFD1
promountil
string
rating
stringnone
recorduid
stringB0ED1CDB-9D86-4302-B0AB33F3A45CAFD1
reference
stringSBBU5925
related
string
reserved
number1
returned
number0
returnsallowed
number1
section
stringlingerie
shipment
string5to7days
showbrand
number0
sizeinfos
Query
Template: /system/api/product/sizes.cfc:20
Execution Time: 1.58 ms
Record Count: 10
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,'2069,2074,2067,2073,2075') > 0
and product_variations.productuid = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1'
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
120741X/2X-intlsizedeeprose1X/2X-19999990wpluslingerie1X/2X1X/2X-42-4412-1416-1844-4644-4642-4446-4844-4642-44104-11086-91112-120
220741X/2X-intlsizeblack1X/2X-19999990wpluslingerie1X/2X1X/2X-42-4412-1416-1844-4644-4642-4446-4844-4642-44104-11086-91112-120
320753X/4X+intlsizeblack3X/4X+3X/4X+-19999990wpluslingerie3X/4X3X/4X+50-5220-2224-2852-5452-5450-5256-5852-5450-52128-132102-108132-138
420753X/4X+intlsizedeeprose3X/4X+3X/4X+-19999990wpluslingerie3X/4X3X/4X+50-5220-2224-2852-5452-5450-5256-5852-5450-52128-132102-108132-138
52069XLintlsizeblackXLXL-19999990wpluslingerieXLXL40-4210-1214-1642-4442-4440-4246-4842-4440-4299-10481-86107-112
62069XLintlsizedeeproseXLXL-19999990wpluslingerieXLXL40-4210-1214-1642-4442-4440-4246-4842-4440-4299-10481-86107-112
720671X/2Xintlsizeblack1X/2X1X/2X-19999990wpluslingerie1X/2X1X/2X46-4816-1820-2248-5048-5046-4852-5448-5046-48112-11892-96122-128
820671X/2Xintlsizedeeprose1X/2X1X/2X-19999990wpluslingerie1X/2X1X/2X46-4816-1820-2248-5048-5046-4852-5448-5046-48112-11892-96122-128
920733X/4Xintlsizedeeprose3X/4X3X/4X-19999990wpluslingerie3X/4X3X/4X48-5018-2022-2450-5250-5248-5054-5650-5248-50120-12898-102128-132
1020733X/4Xintlsizeblack3X/4X3X/4X-19999990wpluslingerie3X/4X3X/4X48-5018-2022-2450-5250-5248-5054-5650-5248-50120-12898-102128-132
sizeranges
stringplus
sizes
string2069,2074,2067,2073,2075
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: 59.4 ms
Record Count: 6
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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1'
and product_variations.isactive = 1
and product_sizes.id_size = 2069
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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1'
and product_variations.isactive = 1
and product_sizes.id_size = 2074
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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1'
and product_variations.isactive = 1
and product_sizes.id_size = 2067
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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1'
and product_variations.isactive = 1
and product_sizes.id_size = 2073
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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1'
and product_variations.isactive = 1
and product_sizes.id_size = 2075
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
1B0ED1CDB-9D86-4302-B0AB33F3A45CAFD188BC89A4-BF56-4DFD-894B6C7A1788EC332074black#0000001X/2X1X/2X-42-4412-1416-1844-4644-4642-4446-4844-4642-44wlingerie1X/2X-intlsize48.29170STOCK01000-10000HD06606A-BLAK-10all
2B0ED1CDB-9D86-4302-B0AB33F3A45CAFD18A28DF21-A6F6-49A3-88BA0B094322AA1B2074deeprose#880E4F1X/2X1X/2X-42-4412-1416-1844-4644-4642-4446-4844-4642-44wlingerie1X/2X-intlsize48.29170STOCK01000-10100HD06606A-PLUM198680005283-10all
3B0ED1CDB-9D86-4302-B0AB33F3A45CAFD13E52F1AD-AAE7-4DBF-B6CD7D0B694B5EA82069black#000000XLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42wlingerieXLintlsize48.29170STOCK01000-10000HD06606A-BLAK-10all
4B0ED1CDB-9D86-4302-B0AB33F3A45CAFD11A9DB1A7-3403-45E1-B648E2D45F70DC742069deeprose#880E4FXLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42wlingerieXLintlsize48.29170STOCK01000-10000HD06606A-PLUM-10all
5B0ED1CDB-9D86-4302-B0AB33F3A45CAFD15BF95579-3AC2-4A07-B904E5A12F7CF4512073black#0000003X/4X3X/4X48-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie3X/4Xintlsize48.29170STOCK01000-10000HD06606A-BLAK-10all
6B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1EBF9D481-0471-4AAE-A66578CE1D4436372073deeprose#880E4F3X/4X3X/4X48-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie3X/4Xintlsize48.29170STOCK01000-11000HD06606A-PLUM-10all
subcategory
stringbustier
supplier
number-1
supplierreference
stringYASMINE
tags
string
themes
string
totalvariations
number6
type
stringdefault
unitprice
number48.2917
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 9.39 ms
Record Count: 10
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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1'
and product_variations.isactive = 1
and product_sizes.id_size = 2069
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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1'
and product_variations.isactive = 1
and product_sizes.id_size = 2074
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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1'
and product_variations.isactive = 1
and product_sizes.id_size = 2067
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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1'
and product_variations.isactive = 1
and product_sizes.id_size = 2073
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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1'
and product_variations.isactive = 1
and product_sizes.id_size = 2075
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
188BC89A4-BF56-4DFD-894B6C7A1788EC332074black#0000001X/2X1X/2X-42-4412-1416-1844-4644-4642-4446-4844-4642-44wlingerie1X/2X-intlsize48.29170STOCK01000-10000HD06606A-BLAK-10-10-10048.2917all
28A28DF21-A6F6-49A3-88BA0B094322AA1B2074deeprose#880E4F1X/2X1X/2X-42-4412-1416-1844-4644-4642-4446-4844-4642-44wlingerie1X/2X-intlsize48.29170STOCK01000-10100HD06606A-PLUM198680005283-10-10-10048.2917all
35BF95579-3AC2-4A07-B904E5A12F7CF4512075black#0000003X/4X3X/4X+50-5220-2224-2852-5452-5450-5256-5852-5450-52wlingerie3X/4X+intlsize48.29170STOCK01000-10000HD06606A-BLAK-10-10-10048.2917all
4EBF9D481-0471-4AAE-A66578CE1D4436372075deeprose#880E4F3X/4X3X/4X+50-5220-2224-2852-5452-5450-5256-5852-5450-52wlingerie3X/4X+intlsize48.29170STOCK01000-11000HD06606A-PLUM-10-10-10048.2917all
53E52F1AD-AAE7-4DBF-B6CD7D0B694B5EA82069black#000000XLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42wlingerieXLintlsize48.29170STOCK01000-10000HD06606A-BLAK-10-10-10048.2917all
61A9DB1A7-3403-45E1-B648E2D45F70DC742069deeprose#880E4FXLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42wlingerieXLintlsize48.29170STOCK01000-10000HD06606A-PLUM-10-10-10048.2917all
788BC89A4-BF56-4DFD-894B6C7A1788EC332067black#0000001X/2X1X/2X46-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie1X/2Xintlsize48.29170STOCK01000-10000HD06606A-BLAK-10-10-10048.2917all
88A28DF21-A6F6-49A3-88BA0B094322AA1B2067deeprose#880E4F1X/2X1X/2X46-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie1X/2Xintlsize48.29170STOCK01000-10100HD06606A-PLUM198680005283-10-10-10048.2917all
95BF95579-3AC2-4A07-B904E5A12F7CF4512073black#0000003X/4X3X/4X48-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie3X/4Xintlsize48.29170STOCK01000-10000HD06606A-BLAK-10-10-10048.2917all
10EBF9D481-0471-4AAE-A66578CE1D4436372073deeprose#880E4F3X/4X3X/4X48-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie3X/4Xintlsize48.29170STOCK01000-11000HD06606A-PLUM-10-10-10048.2917all
vatrate
number20
warehouse
number0