My cart

❌
Total items
View basket
Menu
See sizes
Garter tights
Double-click to enlarge
SKU: CGOC0778
Garter tights
Stock:

The sensuality of a garter belt without the drawbacks of stockings and garters.

Highlights

  • Sensual garter belt without the traditional constraints
  • Silky, sheer texture creates the illusion of graceful legs
  • Delicate lace at the fastening points for seductive femininity
  • Perfect fit for all body types
  • 20-denier voile for a sophisticated, refined effect
  • Optimum comfort without compromising sensual elegance
  • Cuban heel and decorative stitching for luxurious details
  • Sublime generous curves with optimal support
Size:

Not sure which size to choose? See our size guide

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

Plus size lace garter tights

Product description

These garter tights are an elegant, refined accessory that offers you sensuality and eroticism without the drawbacks of a traditional garter belt.

The silky, sheer texture of the leg creates the illusion of long, graceful legs, while the delicate lace around the garter fastening areas adds a seductive touch of femininity, absent in many more daring outfits.

This accessory lets you enhance your silhouette with a look that's both elegant and sensual, without compromising comfort.

Technical details

  • Style: Sensual illusion effect garter tights
  • Denier: 20 denier silky sheer texture
  • Lace: Delicate, feminine suspender zones
  • Heel: Cuban sophisticated luxury detail
  • Seam: Decorative, refined craftsmanship
  • Composition: 86% polyamide 14% stretch spandex
  • Support: Optimal for all body shapes
  • Comfort: Absolute without compromising sensual elegance

Available sizes

Available from 7-8 to 13-14

Available color

Black

Sizing guide

Check the right size for you

International
  • Size (height)
  • Weight
7-8
  • 168-178
  • 77-100
9-10
  • 168-183
  • 91-118
11-12
  • 168-183
  • 104-132
13-14
  • 168-183
  • 118-150

Care instructions

  • Hand washing recommended with mild soap or machine wash at 30°C maximum in a protective mesh bag
  • Avoid fabric softeners which weaken the elasticity of the fibers
  • Air dry flat, never in the dryer
  • Handle with clean hands and without jewelry to avoid snags
  • For standard and plus sizes (up to 64), put on delicately by rolling up the stocking/tight and avoiding pulling
  • Store separately from garments with closures or hooks that could damage them
  • For fancy styles, fishnet or patterned models, wash inside out to preserve details
  • Hand wash in cold water to preserve silky texture
  • Use a mild detergent without bleaching agents
  • Dry flat away from direct light
  • avoid spin-drying to maintain 20-denier elasticity
  • Do not iron to preserve delicate lace
  • Handle delicately to avoid snags

Usage tips

Gently slip on these garter tights, starting at the feet and working your way up.

The 20-denier texture adapts naturally to your morphology to create the illusion of graceful legs.

This accessory reveals the sensuality of a traditional garter belt while offering the comfort of tights, transforming every moment into an elegant experience.

Styling tips

These garter tights stand on their own thanks to a design that combines sensuality and practicality. Wear them for those special occasions when you want to reveal your femininity with sophistication.

The delicate lace and illusion effect create a captivating silhouette that enhances your natural beauty.

Perfect under a dress or skirt, it adds that discreet touch of sensuality that reveals your seductive side. The ideal accessory to express your elegance with that accessible sensuality that celebrates your femininity in all its generous splendor.

To Top
View basket
Items
Total items
Struct
Entries: 108
actions
Array
available
number-1
brand
stringmemoi
brandcode
stringmzpm
branding
stringdivasboudoir,legsboudoir
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
stringMeMoi
breasts
stringna
careinstructions
stringstockings
categories
stringdivasboudoir.lingerie.hoisery.crotchless
category
stringhoisery
categorygender
stringm
categorymediadatas
Struct
adult
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string414
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/lingerie/hoisery/collants-ouverts-grande-taille.jpg
type
stringimg
width
string900
divasboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
fetishboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
latexboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
legsboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
lustboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
private
Struct
height
string1016
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/private/default.jpg
type
stringimg
width
string703
smboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
categorysizerange
stringauto
colorinfos
Query
Template: /system/api/product/colors.cfc:13
Execution Time: 1 ms
Record Count: 1
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_colors.color as recorduid, product_colors.type, product_colors.code, product_colors.color, product_colors.range, product_colors.hexvalue,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock
from product_colors
left outer join product_variations on product_colors.color = product_variations.color and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
where FIND_IN_SET(product_colors.color,'black') > 0
and product_variations.productuid = '6503065D-BFA9-44CE-BF37CD1F33FBC728'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1blackcolorblakblackblack#000000-12
colorrange
stringblack
colors
stringblack
colortype
stringcolor
comments
string
compositions
Struct
Entries: 13
coton
string
elastane
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 '2024-09-25 16:21:57'}
defect
number0
dimensions
Struct
Entries: 14
acrylicbones
string
backsideheight
string
diameter
string
flatsteelbones
string
frontsideheight
string
fullheight
string
length
string
modestysize
string
panels
string
sides
string
spiralsteelbones
string
totallength
string
unit
stringcm
wiresize
string
display
stringall
displayfrom
string
displayto
string
grossweight
string
hasbrandinfos
booleanfalse
hascareinstructions
booleantrue
hascolorinfos
booleantrue
hascompositions
booleanfalse
hasdescription
booleantrue
hasdimensions
booleanfalse
hasmaterials
booleanfalse
hasotherspecifications
booleanfalse
haspromo
number0
hasshortdescription
booleantrue
hassizeinfos
booleantrue
hasspecifications
booleantrue
hasstockinfos
booleanfalse
hasstylingtips
booleantrue
hasusageinstructions
booleantrue
hasvariations
booleantrue
import
string
inpromo
number0
instockvariations
string
isactive
number1
iscustommade
number0
isdivasize
number1
isfirstprice
number0
isfixedprice
number0
ishot
number0
isnew
number0
isonline
number0
isoutletprice
number0
itemprice
number16.625
itempromo
string
key
stringmm-2619-00001-collants-en-dentelle-a-bretelles-incurvees
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-10-13 12:46:57'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.864 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('6503065d-bfa9-44ce-bf37cd1f33fbc728',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.66 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 <> 'CGOC0778'
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
string856
isprivate
string0
rating
stringall
src
string/photobank/products/mzpm/cgoc0778/25c9ece88dfeb24991ee4c03f92272f5.jpg
type
stringimg
width
string592
back
Struct
height
string856
isprivate
string0
rating
stringall
src
string/photobank/products/mzpm/cgoc0778/138390a8646e40628ebb35103d445f7f.jpg
type
stringimg
width
string592
default
Struct
height
string844
isprivate
string0
rating
stringall
src
string/photobank/products/mzpm/cgoc0778/6fb281c4f375fd78e7a721b861948787.jpg
type
stringimg
width
string584
variations
Struct
colors
Struct
black
Struct
height
string844
isprivate
string0
rating
stringall
src
string/photobank/products/mzpm/cgoc0778/6fb281c4f375fd78e7a721b861948787.jpg
type
stringimg
width
string584
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 seidige Textur zu erhalten</li> <li>Verwenden Sie ein mildes Waschmittel ohne Bleichmittel</li> <li>Trocknen Sie das Kleidungsstück liegend, ohne direkte Sonneneinstrahlung</li> <li>schleudern vermeiden, um die 20-Denier-Elastizität zu erhalten</li> <li>Nicht bügeln, um die zarte Spitze zu erhalten</li> <li>Vorsichtig handhaben, um ein Verhaken zu vermeiden</li> </ul>
description
string<p><span>Diese Strapsstrumpfhose ist ein elegantes und raffiniertes Accessoire, das Ihnen Sinnlichkeit und Erotik bietet, ohne die Nachteile eines herkömmlichen Strapsgürtels. </span></p> <p><span>Die seidig-transparente Textur des Beines erzeugt die Illusion von langen, anmutigen Beinen, während die zarte Spitze um die Befestigungsbereiche der Strumpfhalter einen verführerischen Hauch von Weiblichkeit verleiht, der in vielen gewagteren Outfits nicht vorhanden ist. </span></p> <p><span>Mit diesem Accessoire können Sie Ihre Figur mit einem eleganten und zugleich sinnlichen Look betonen, ohne dabei Kompromisse beim Tragekomfort eingehen zu müssen.</span></p>
guid
stringhttps://dev.divasboudoir.com/de/strapsstrumpfhose-grosse-grosse-aus-spitze-schwarz/cgoc0778.htm
highlights
string<ul> <li style="font-weight: bold;"><strong>Sinnlichkeit von Strapsgürteln ohne die traditionellen Einschränkungen</strong></li> <li>Seidige, transparente Textur schafft die Illusion anmutiger Beine</li> <li>Zarte Spitze an den Befestigungsstellen für verführerische Weiblichkeit</li> <li>Passt sich perfekt an und passt sich jeder Körperform an</li> <li><strong>20-Denier-Voile</strong> für einen anspruchsvollen und raffinierten Effekt.</li> <li>Optimaler Tragekomfort, ohne die sinnliche Eleganz zu beeinträchtigen</li> <li>Kubanischer Absatz und Ziernaht für luxuriöse Details</li> <li>Erhabene, großzügige Kurven mit optimalem Halt</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringDiese Strapsstrumpfhose ist ein elegantes und raffiniertes Accessoire, das Ihnen Sinnlichkeit und Raffinesse bietet, ohne die Nachteile eines herkömmlichen Strapsgürtels.
keywords
string
title
stringStrumpfhose in großen Größen - Strapsgürtel-Effekt
seotitle
stringStrapsstrumpfhose große Größe aus Spitze
seouri
stringstrapsstrumpfhose-grosse-grosse-aus-spitze-schwarz
specifications
string<ul> <li>Stil: Strapsstrumpfhose mit sinnlichem Illusionseffekt</li> <li>Denier: 20 Denier transparente, seidige Textur</li> <li>Spitze: Zarte, feminine Strumpfhalterbereiche</li> <li>Ferse: Kubanisch anspruchsvolles Luxusdetail</li> <li>Naht: Dekorative raffinierte handwerkliche Verarbeitung</li> <li>Zusammensetzung: 86% Polyamid 14% Stretch-Spandex</li> <li>Halt: Optimal, passt sich jeder Körperform an</li> <li>Tragekomfort: Absolut ohne Kompromisse bei der sinnlichen Eleganz</li> </ul>
stylingtips
string<p>Diese Strapsstrumpfhose ist dank ihres Designs, das Sinnlichkeit und Praktikabilität vereint, selbsterklärend. Tragen Sie sie zu besonderen Anlässen, bei denen Sie Ihre Weiblichkeit auf raffinierte Weise enthüllen möchten.</p> <p>Die zarte Spitze und der Illusionseffekt schaffen eine fesselnde Silhouette, die Ihre natürliche Schönheit unterstreicht.</p> <p>Perfekt unter einem Kleid oder einem Rock, verleiht es Ihnen diesen diskreten Hauch von Sinnlichkeit, der Ihre verführerische Seite offenbart. Das ideale Accessoire, um Ihre Eleganz mit dieser zugänglichen Sinnlichkeit auszudrücken, die Ihre Weiblichkeit in all ihrer großzügigen Pracht feiert.</p>
summary
stringDie Sinnlichkeit eines Strapsgürtels ohne die Nachteile von Strümpfen und Strumpfhaltern.
title
stringStrumpfhalter Strumpfhose
usageinstructions
string<p>Ziehen Sie diese Strapsstrumpfhose sanft von den Füßen beginnend nach oben an.</p> <p>Die <strong>20-Denier-Textur </strong>passt sich auf natürliche Weise Ihrer Körperform an, um die Illusion graziler Beine zu erzeugen.</p> <p>Dieses Accessoire enthüllt die Sinnlichkeit eines traditionellen Strapsgürtels und bietet gleichzeitig den Komfort einer Strumpfhose, wodurch jeder Moment zu einem eleganten Erlebnis wird.</p>
el
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Πλύνετε στο χέρι με κρύο νερό για να διατηρήσετε τη μεταξένια υφή</li> <li>Χρησιμοποιήστε ήπιο απορρυπαντικό χωρίς λευκαντικούς παράγοντες</li> <li>Στεγνώνετε σε επίπεδη επιφάνεια μακριά από το άμεσο φως</li> <li>αποφύγετε το στύψιμο για να διατηρήσετε την ελαστικότητα των 20 denier</li> <li>Μην σιδερώνετε για να διατηρήσετε την ευαίσθητη δαντέλα</li> <li>Χειριστείτε απαλά για να αποφύγετε τα κολλήματα</li> </ul>
description
string<p><span>Αυτές οι καλτσοδέτες είναι ένα κομψό και εκλεπτυσμένο αξεσουάρ που σας προσφέρει αισθησιασμό και ερωτισμό χωρίς τα μειονεκτήματα μιας παραδοσιακής ζαρτιέρας. </span></p> <p><span>Η μεταξένια, διάφανη υφή του ποδιού δημιουργεί την ψευδαίσθηση μακρών, χαριτωμένων ποδιών, ενώ η λεπτή δαντέλα γύρω από τις περιοχές που δένουν οι τιράντες προσθέτει μια σαγηνευτική πινελιά θηλυκότητας που λείπει από πολλά πιο τολμηρά ρούχα. </span></p> <p><span>Αυτό το αξεσουάρ σας επιτρέπει να αναδείξετε τη σιλουέτα σας με μια εμφάνιση που είναι κομψή και αισθησιακή, χωρίς συμβιβασμούς στην άνεση.</span></p>
guid
stringhttps://dev.divasboudoir.com/el/megalo-dantelenio-kalson-me-kaltsodetes-mayro/cgoc0778.htm
highlights
string<ul> <li style="font-weight: bold;"><strong>Ο αισθησιασμός μιας ζαρτιέρας χωρίς τους παραδοσιακούς περιορισμούς</strong></li> <li>Η μεταξένια, διάφανη υφή δημιουργεί την ψευδαίσθηση χαριτωμένων ποδιών</li> <li>Λεπτή δαντέλα στα σημεία στερέωσης για σαγηνευτική θηλυκότητα</li> <li>Τέλεια εφαρμογή για όλα τα σχήματα σώματος</li> <li><strong>20 denier</strong> voile για ένα εκλεπτυσμένο και εκλεπτυσμένο αποτέλεσμα</li> <li>Βέλτιστη άνεση χωρίς συμβιβασμούς στην αισθησιακή κομψότητα</li> <li>Κουβανέζικο τακούνι και διακοσμητικές ραφές για πολυτελή λεπτομέρεια</li> <li>Υπέροχες γενναιόδωρες καμπύλες με βέλτιστη στήριξη</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringΑυτές οι καλτσοδέτες είναι ένα κομψό, εκλεπτυσμένο αξεσουάρ που προσφέρει αισθησιασμό και εκλέπτυνση χωρίς τα μειονεκτήματα μιας παραδοσιακής ζαρτιέρας.
keywords
string
title
stringΚαλσόν για μεγάλα μεγέθη - Εφέ καλτσοδέτας
seotitle
stringΜεγάλο δαντελένιο καλσόν με καλτσοδέτες
seouri
stringmegalo-dantelenio-kalson-me-kaltsodetes-mayro
specifications
string<ul> <li>Στυλ : Αισθησιακό καλσόν με καλσόν με εφέ ψευδαίσθησης</li> <li>Denier : 20 denier μεταξένια διάφανη υφή</li> <li>Δαντέλα: Ντελικάτες θηλυκές ζώνες ζαρτιέρας</li> <li>Φτέρνα: Κουβανέζικη εκλεπτυσμένη λεπτομέρεια πολυτέλειας</li> <li>Ραφή: Διακοσμητική με εκλεπτυσμένο χειροποίητο φινίρισμα</li> <li>Σύνθεση: 86% πολυαμίδιο 14% ελαστικό spandex</li> <li>Στήριξη: Βέλτιστη για όλα τα σχήματα σώματος</li> <li>Άνεση: Απόλυτη χωρίς συμβιβασμούς στην αισθησιακή κομψότητα</li> </ul>
stylingtips
string<p>Αυτά τα καλσόν με καλτσοδέτες στέκονται μόνα τους χάρη σε ένα σχέδιο που συνδυάζει αισθησιασμό και πρακτικότητα. Φορέστε το για τις ειδικές περιστάσεις που θέλετε να αποκαλύψετε τη θηλυκότητά σας με φινέτσα.</p> <p>Η λεπτή δαντέλα και το εφέ ψευδαίσθησης δημιουργούν μια σαγηνευτική σιλουέτα που αναδεικνύει τη φυσική σας ομορφιά.</p> <p>Ιδανικό κάτω από ένα φόρεμα ή μια φούστα, προσθέτει αυτή τη διακριτική πινελιά αισθησιασμού που αποκαλύπτει τη σαγηνευτική σας πλευρά. Το τέλειο αξεσουάρ για να εκφράσετε την κομψότητά σας με αυτόν τον προσιτό αισθησιασμό που εξυμνεί τη θηλυκότητά σας σε όλο της το γενναιόδωρο μεγαλείο.</p>
summary
stringΟ αισθησιασμός μιας ζώνης καλτσοδέτας χωρίς τα μειονεκτήματα των καλτσών και των καλτσοδέτων.
title
stringΚαλσόν καλσόν
usageinstructions
string<p>Φορέστε απαλά αυτό το καλσόν, ξεκινώντας από τα πόδια και ανεβαίνοντας προς τα πάνω.</p> <p>Η υφή <strong>20 denier </strong>προσαρμόζεται φυσικά στο σχήμα σας και δημιουργεί την ψευδαίσθηση χαριτωμένων ποδιών.</p> <p>Αυτό το αξεσουάρ αποκαλύπτει τον αισθησιασμό μιας παραδοσιακής ζαρτιέρας, ενώ προσφέρει την άνεση του καλσόν, μετατρέποντας κάθε στιγμή σε μια κομψή εμπειρία.</p>
en
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Hand wash in cold water to preserve silky texture</li> <li>Use a mild detergent without bleaching agents</li> <li>Dry flat away from direct light</li> <li>avoid spin-drying to maintain 20-denier elasticity</li> <li>Do not iron to preserve delicate lace</li> <li>Handle delicately to avoid snags</li> </ul>
description
string<p><span>These garter tights are an elegant, refined accessory that offers you sensuality and eroticism without the drawbacks of a traditional garter belt. </span></p> <p><span>The silky, sheer texture of the leg creates the illusion of long, graceful legs, while the delicate lace around the garter fastening areas adds a seductive touch of femininity, absent in many more daring outfits. </span></p> <p><span>This accessory lets you enhance your silhouette with a look that's both elegant and sensual, without compromising comfort.</span></p>
guid
stringhttps://dev.divasboudoir.com/en/plus-size-lace-garter-tights-black/cgoc0778.htm
highlights
string<ul> <li style="font-weight: bold;"><strong>Sensual garter belt without the traditional constraints</strong></li> <li>Silky, sheer texture creates the illusion of graceful legs</li> <li>Delicate lace at the fastening points for seductive femininity</li> <li>Perfect fit for all body types</li> <li><strong>20-denier</strong> voile for a sophisticated, refined effect</li> <li>Optimum comfort without compromising sensual elegance</li> <li>Cuban heel and decorative stitching for luxurious details</li> <li>Sublime generous curves with optimal support</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringThese garter tights are an elegant, refined accessory that offers sensuality and sophistication without the drawbacks of a traditional garter belt.
keywords
string
title
stringPlus size tights - Garter effect
seotitle
stringPlus size lace garter tights
seouri
stringplus-size-lace-garter-tights-black
specifications
string<ul> <li>Style: Sensual illusion effect garter tights</li> <li>Denier: 20 denier silky sheer texture</li> <li>Lace: Delicate, feminine suspender zones</li> <li>Heel: Cuban sophisticated luxury detail</li> <li>Seam: Decorative, refined craftsmanship</li> <li>Composition: 86% polyamide 14% stretch spandex</li> <li>Support: Optimal for all body shapes</li> <li>Comfort: Absolute without compromising sensual elegance</li> </ul>
stylingtips
string<p>These garter tights stand on their own thanks to a design that combines sensuality and practicality. Wear them for those special occasions when you want to reveal your femininity with sophistication.</p> <p>The delicate lace and illusion effect create a captivating silhouette that enhances your natural beauty.</p> <p>Perfect under a dress or skirt, it adds that discreet touch of sensuality that reveals your seductive side. The ideal accessory to express your elegance with that accessible sensuality that celebrates your femininity in all its generous splendor.</p>
summary
stringThe sensuality of a garter belt without the drawbacks of stockings and garters.
title
stringGarter tights
usageinstructions
string<p>Gently slip on these garter tights, starting at the feet and working your way up.</p> <p>The <strong>20-denier </strong>texture adapts naturally to your morphology to create the illusion of graceful legs.</p> <p>This accessory reveals the sensuality of a traditional garter belt while offering the comfort of tights, transforming every moment into an elegant experience.</p>
es
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavar a mano en agua fría para conservar la textura sedosa</li> <li>Utilizar un detergente suave sin blanqueantes</li> <li>Secar en plano lejos de la luz directa</li> <li>evitar el centrifugado para mantener la elasticidad de 20 deniers</li> <li>No planchar para conservar el delicado encaje</li> <li>Manipular con cuidado para evitar enganches</li> </ul>
description
string<p><span>Estas medias con liguero son un accesorio elegante y refinado que te ofrece sensualidad y erotismo sin los inconvenientes de un liguero tradicional. </span></p> <p><span>Su textura sedosa y transparente crea la ilusión de unas piernas largas y gráciles, mientras que el delicado encaje que rodea las zonas de sujeción de los ligueros añade un seductor toque de feminidad que falta en muchos conjuntos más atrevidos. </span></p> <p><span>Este accesorio te permite realzar tu figura con un look a la vez elegante y sensual, sin renunciar a la comodidad.</span></p>
guid
stringhttps://dev.divasboudoir.com/es/medias-de-liga-de-encaje-talla-grande-negro/cgoc0778.htm
highlights
string<ul> <li style="font-weight: bold;"><strong>La sensualidad de un liguero sin las restricciones tradicionales</strong></li> <li>La textura sedosa y transparente crea la ilusión de unas piernas gráciles</li> <li>Delicado encaje en los puntos de sujeción para una feminidad seductora</li> <li>Ajuste perfecto para todas las formas</li> <li>Tejido de gasa <strong>de 20 deniers</strong> para un efecto sofisticado y refinado</li> <li>Comodidad óptima sin comprometer la elegancia sensual</li> <li>Tacón cubano y costuras decorativas para un detalle de lujo</li> <li>Sublimes curvas generosas con una sujeción óptima</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringEstas medias con liguero son un accesorio elegante y refinado que ofrece sensualidad y sofisticación sin los inconvenientes de un liguero tradicional.
keywords
string
title
stringMedias de talla grande - Efecto liguero
seotitle
stringMedias de liga de encaje talla grande
seouri
stringmedias-de-liga-de-encaje-talla-grande-negro
specifications
string<ul> <li>Estilo : Sensuales medias de liguero efecto ilusión</li> <li>Denier: 20 deniers de textura sedosa y transparente</li> <li>Encaje: Delicadas zonas de liguero femenino</li> <li>Tacón: Cubano sofisticado detalle de lujo</li> <li>Costura: Decorativa con refinado acabado artesanal</li> <li>Composición: 86% poliamida 14% elastán</li> <li>Sujeción: Óptima para todas las formas de cuerpo</li> <li>Comodidad: Absoluta sin comprometer la elegancia sensual</li> </ul>
stylingtips
string<p>Estas medias con liguero destacan por sí solas gracias a un diseño que combina sensualidad y practicidad. Póntelas en esas ocasiones especiales en las que quieres revelar tu feminidad con sofisticación.</p> <p>El delicado encaje y el efecto ilusión crean una silueta cautivadora que realza tu belleza natural.</p> <p>Perfecto bajo un vestido o una falda, añade ese discreto toque de sensualidad que revela tu lado seductor. El accesorio perfecto para expresar tu elegancia con esa sensualidad accesible que celebra tu feminidad en todo su generoso esplendor.</p>
summary
stringLa sensualidad de un liguero sin los inconvenientes de las medias y los ligueros.
title
stringLeotardos
usageinstructions
string<p>Desliza suavemente estas medias con liguero, empezando por los pies y subiendo hacia arriba.</p> <p>La textura <strong>de 20 deniers </strong>se adapta de forma natural a tu figura para crear la ilusión de unas piernas elegantes.</p> <p>Este accesorio revela la sensualidad de un liguero tradicional a la vez que ofrece la comodidad de unas medias, convirtiendo cada momento en una experiencia elegante.</p>
fr
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavage &agrave; la main &agrave; l'eau froide pour pr&eacute;server texture soyeuse</li> <li>Utiliser une lessive douce sans agents blanchissants</li> <li>S&eacute;chage &agrave; plat &agrave; l'abri de la lumi&egrave;re directe</li> <li>&Eacute;viter l'essorage pour maintenir &eacute;lasticit&eacute; 20 deniers</li> <li>Ne pas repasser pour pr&eacute;server dentelle d&eacute;licate</li> <li>Manipuler d&eacute;licatement pour &eacute;viter les accrocs</li> </ul>
description
string<p style="text-align: left;">Ce collant porte-jarretelles incarne la solution parfaite pour toutes celles qui recherchent la sensualit&eacute; d'un porte-jarretelles sans les inconv&eacute;nients. Cette cr&eacute;ation &eacute;l&eacute;gante et raffin&eacute;e vous offre cette sophistication s&eacute;duisante tout en &eacute;pousant parfaitement toutes les morphologies avec cette gr&acirc;ce contemporaine.<br><br>La texture soyeuse et transparente de <strong>20 deniers</strong> cr&eacute;e cette illusion remarquable de jambes longues et gracieuses qui sublime courbes g&eacute;n&eacute;reuses. Cette finition d&eacute;licate offre un maintien optimal qui &eacute;pouse vos formes naturelles, r&eacute;v&eacute;lant votre beaut&eacute; avec cette &eacute;l&eacute;gance intemporelle.<br><br>La d&eacute;licate dentelle autour des zones des jarretelles apporte cette touche de f&eacute;minit&eacute; s&eacute;duisante qui distingue cet accessoire des tenues plus conventionnelles. Cette finition artisanale r&eacute;v&egrave;le votre go&ucirc;t pour les d&eacute;tails raffin&eacute;s tout en conservant cette modernit&eacute; sophistiqu&eacute;e.<br><br>Le talon cubain et la couture d&eacute;corative ajoutent ces d&eacute;tails luxueux qui transforment ce collant en v&eacute;ritable accessoire de mode. Cette finition haut de gamme r&eacute;v&egrave;le votre pr&eacute;f&eacute;rence pour l'excellence tout en c&eacute;l&eacute;brant votre f&eacute;minit&eacute; avec audace assum&eacute;e.<br><br>Parfait pour sublimer votre silhouette avec une allure &agrave; la fois &eacute;l&eacute;gante et sensuelle, cet accessoire transforme chaque moment en opportunit&eacute; de r&eacute;v&eacute;ler votre sophistication avec ce confort qui c&eacute;l&egrave;bre votre beaut&eacute; dans toute sa splendeur g&eacute;n&eacute;reuse.</p>
guid
stringhttps://dev.divasboudoir.com/fr/collant-porte-jarretelles-grande-taille-sensualite-elegante/cgoc0778.htm
highlights
string<ul> <li style="font-weight: bold;"><strong>Sensualit&eacute; du porte-jarretelles sans les contraintes traditionnelles</strong></li> <li>Texture soyeuse et transparente cr&eacute;ant l'illusion de jambes gracieuses</li> <li>Dentelle d&eacute;licate aux zones de fixation pour une f&eacute;minit&eacute; s&eacute;duisante</li> <li>S'adapte parfaitement &eacute;pousant toutes les morphologies</li> <li>Voile <strong>20 deniers</strong> pour un effet sophistiqu&eacute; et raffin&eacute;</li> <li>Confort optimal sans compromettre l'&eacute;l&eacute;gance sensuelle</li> <li>Talon cubain et couture d&eacute;corative pour des d&eacute;tails luxueux</li> <li>Sublime courbes g&eacute;n&eacute;reuses avec maintien optimal</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringCollant porte-jarretelles grande taille, texture soyeuse 20 deniers, dentelle délicate, effet illusion jambes gracieuses. Sensualité sans contraintes. Diva's Boudoir.
keywords
string
title
stringCollant Porte-Jarretelles Grande Taille | Sensualité Élégante | Diva's Boudoir
seotitle
stringCollant Porte-Jarretelles Grande Taille - Sensualité Élégante
seouri
stringcollant-porte-jarretelles-grande-taille-sensualite-elegante
specifications
string<ul> <li>Style : Collant porte-jarretelles effet illusion sensuel</li> <li>Denier : 20 deniers texture soyeuse transparente</li> <li>Dentelle : D&eacute;licate zones jarretelles f&eacute;minit&eacute;</li> <li>Talon : Cubain d&eacute;tail luxueux sophistiqu&eacute;</li> <li>Couture : D&eacute;corative finition artisanale raffin&eacute;e</li> <li>Composition : 86% polyamide 14% spandex extensible</li> <li>Maintien : Optimal &eacute;pousant toutes les morphologies</li> <li>Confort : Absolu sans compromettre &eacute;l&eacute;gance sensuelle</li> </ul>
stylingtips
string<p>Ce collant porte-jarretelles se suffit &agrave; lui-m&ecirc;me gr&acirc;ce &agrave; son design qui allie sensualit&eacute; et praticit&eacute;. Portez-le pour vos occasions sp&eacute;ciales o&ugrave; vous voulez r&eacute;v&eacute;ler votre f&eacute;minit&eacute; avec sophistication.</p> <p>La dentelle d&eacute;licate et l'effet illusion cr&eacute;ent une silhouette captivante qui sublime votre beaut&eacute; naturelle.&nbsp;</p> <p>Parfait sous une robe ou une jupe, il apporte cette touche de sensualit&eacute; discr&egrave;te qui r&eacute;v&egrave;le votre c&ocirc;t&eacute; s&eacute;ducteur. L'accessoire id&eacute;al pour exprimer votre &eacute;l&eacute;gance avec cette sensualit&eacute; accessible qui c&eacute;l&egrave;bre votre f&eacute;minit&eacute; dans toute sa splendeur g&eacute;n&eacute;reuse.</p>
summary
string<p>Ce collant porte-jarretelles r&eacute;v&egrave;le la <strong>sensualit&eacute; d'un porte-jarretelles traditionnel sans les inconv&eacute;nients.</strong><br><br>Sa texture soyeuse <strong>20 deniers</strong> cr&eacute;e l'illusion de jambes longues et gracieuses, tandis que la dentelle d&eacute;licate apporte cette f&eacute;minit&eacute; s&eacute;duisante. Con&ccedil;u pour sublimer toutes les morphologies avec &eacute;l&eacute;gance et confort absolu.</p>
title
stringCollant Porte-Jarretelles Effet Illusion - Sensualité Sans Contraintes
usageinstructions
string<p>Enfilez d&eacute;licatement ce collant porte-jarretelles en commen&ccedil;ant par les pieds, puis remontez progressivement.</p> <p>La texture&nbsp;<strong>20 deniers </strong>s'adapte naturellement &agrave; votre morphologie pour cr&eacute;er cet effet illusion de jambes gracieuses.</p> <p>Cet accessoire r&eacute;v&egrave;le la sensualit&eacute; d'un porte-jarretelles traditionnel tout en offrant le confort d'un collant, transformant chaque moment en exp&eacute;rience &eacute;l&eacute;gante.</p>
it
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavare a mano in acqua fredda per preservare la consistenza setosa</li> <li>Utilizzare un detergente delicato senza agenti sbiancanti</li> <li>Asciugare in piano lontano dalla luce diretta</li> <li>evitare l'asciugatura in centrifuga per mantenere l'elasticità di 20 denari</li> <li>Non stirare per preservare il pizzo delicato</li> <li>Maneggiare delicatamente per evitare strappi</li> </ul>
description
string<p><span>Questi collant da reggicalze sono un accessorio elegante e raffinato che offre sensualità ed erotismo senza gli inconvenienti di un reggicalze tradizionale. </span></p> <p><span>La texture setosa e trasparente della gamba crea l'illusione di gambe lunghe e aggraziate, mentre il delicato pizzo intorno alle zone di allacciatura del reggicalze aggiunge un seducente tocco di femminilità che manca in molti abiti più audaci. </span></p> <p><span>Questo accessorio vi permette di valorizzare la vostra figura con un look elegante e sensuale, senza compromettere il comfort.</span></p>
guid
stringhttps://dev.divasboudoir.com/it/collant-a-giarrettiera-di-pizzo-di-taglia-grande-nero/cgoc0778.htm
highlights
string<ul> <li style="font-weight: bold;"><strong>La sensualità di un reggicalze senza i vincoli tradizionali</strong></li> <li>La texture setosa e trasparente crea l'illusione di gambe aggraziate</li> <li>Delicato pizzo nei punti di chiusura per una femminilità seducente</li> <li>Vestibilità perfetta per tutte le forme del corpo</li> <li>Voile <strong>20 denari</strong> per un effetto sofisticato e raffinato</li> <li>Comfort ottimale senza compromettere l'eleganza sensuale</li> <li>Tacco cubano e cuciture decorative per un dettaglio di lusso</li> <li>Curve sublimi e generose con un sostegno ottimale</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringQuesti collant sono un accessorio elegante e raffinato che offre sensualità e raffinatezza senza gli inconvenienti di un reggicalze tradizionale.
keywords
string
title
stringCollant taglia grande - Effetto giarrettiera
seotitle
stringCollant a giarrettiera di pizzo di taglia grande
seouri
stringcollant-a-giarrettiera-di-pizzo-di-taglia-grande-nero
specifications
string<ul> <li>Stile : Sensuale collant con effetto illusione</li> <li>Denier : 20 denari di texture setosa e trasparente</li> <li>Pizzo: delicate zone di reggicalze femminili</li> <li>Tacco: dettaglio cubano di lusso sofisticato</li> <li>Cuciture: Decorative con raffinata finitura artigianale</li> <li>Composizione: 86% poliammide 14% spandex elasticizzato</li> <li>Sostegno: ottimale per tutte le forme del corpo</li> <li>Comfort: Assoluto senza compromettere l'eleganza sensuale</li> </ul>
stylingtips
string<p>Questi collant reggicalze si distinguono per un design che unisce sensualità e praticità. Indossateli per le occasioni speciali in cui volete rivelare la vostra femminilità con raffinatezza.</p> <p>Il pizzo delicato e l'effetto illusione creano una silhouette accattivante che esalta la vostra bellezza naturale.</p> <p>Perfetto sotto un abito o una gonna, aggiunge quel tocco discreto di sensualità che rivela il vostro lato seducente. L'accessorio perfetto per esprimere la vostra eleganza con quella sensualità accessibile che celebra la vostra femminilità in tutto il suo generoso splendore.</p>
summary
stringLa sensualità di un reggicalze senza gli inconvenienti di calze e giarrettiere.
title
stringCollant con giarrettiera
usageinstructions
string<p>Infilate delicatamente questi collant da reggicalze, partendo dai piedi e salendo verso l'alto.</p> <p>La texture <strong>da 20 denari </strong>si adatta naturalmente alle vostre forme per creare l'illusione di gambe aggraziate.</p> <p>Questo accessorio rivela la sensualità di un reggicalze tradizionale offrendo al contempo il comfort di un collant, trasformando ogni momento in un'esperienza elegante.</p>
nl
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Handwas in koud water om de zijdezachte textuur te behouden</li> <li>Gebruik een mild wasmiddel zonder bleekmiddelen</li> <li>Plat drogen uit de buurt van direct licht</li> <li>vermijd centrifugeren om de elasticiteit van 20 denier te behouden</li> <li>Niet strijken om delicaat kant te behouden</li> <li>Voorzichtig behandelen om knopen te voorkomen</li> </ul>
description
string<p><span>Deze jarretelpanty is een elegant en verfijnd accessoire dat je sensualiteit en erotiek biedt zonder de nadelen van een traditionele jarretelgordel. </span></p> <p><span>De zijdeachtige, transparante textuur van het been creëert de illusie van lange, sierlijke benen, terwijl het delicate kant rond de jarretels een verleidelijk vleugje vrouwelijkheid toevoegt dat ontbreekt in veel meer gewaagde outfits. </span></p> <p><span>Met dit accessoire kun je je figuur verbeteren met een look die zowel elegant als sensueel is, zonder afbreuk te doen aan comfort.</span></p>
guid
stringhttps://dev.divasboudoir.com/nl/grote-kanten-kousenbroek-zwart/cgoc0778.htm
highlights
string<ul> <li style="font-weight: bold;"><strong>De sensualiteit van een jarretelgordel zonder de traditionele beperkingen</strong></li> <li>Zijdeachtige, transparante textuur creëert de illusie van sierlijke benen</li> <li>Delicaat kant op de bevestigingspunten voor verleidelijke vrouwelijkheid</li> <li>Perfecte pasvorm voor alle lichaamsvormen</li> <li><strong>20 denier</strong> voile voor een geraffineerd en verfijnd effect</li> <li>Optimaal comfort zonder afbreuk te doen aan sensuele elegantie</li> <li>Cubaanse hak en decoratieve stiksels voor luxueuze details</li> <li>Sublieme gulle rondingen met optimale ondersteuning</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringDeze jarretelleggings zijn een elegant, verfijnd accessoire dat je sensualiteit en verfijning geeft zonder de nadelen van een traditionele jarretelgordel.
keywords
string
title
stringGrote maten panty's - Kousenbandeffect
seotitle
stringGrote kanten kousenbroek
seouri
stringgrote-kanten-kousenbroek-zwart
specifications
string<ul> <li>Stijl : Sensuele kousenbandpanty met illusie-effect</li> <li>Denier : 20 denier zijdeachtige transparante textuur</li> <li>Kant: Delicate vrouwelijke jarretelzones</li> <li>Hak: Cubaans verfijnd luxe detail</li> <li>Naad: Decoratief met verfijnde handgemaakte afwerking</li> <li>Samenstelling: 86% polyamide 14% stretch spandex</li> <li>Ondersteuning: Optimaal voor alle lichaamsvormen</li> <li>Comfort: Absoluut zonder afbreuk te doen aan sensuele elegantie</li> </ul>
stylingtips
string<p>Deze jarretelpanty staat op zichzelf dankzij een ontwerp dat sensualiteit en functionaliteit combineert. Draag ze voor die speciale gelegenheden waarbij je je vrouwelijkheid op geraffineerde wijze wilt onthullen.</p> <p>Het delicate kant en het illusie-effect creëren een betoverend silhouet dat je natuurlijke schoonheid benadrukt.</p> <p>Perfect onder een jurk of rok, voegt het dat discrete vleugje sensualiteit toe dat je verleidelijke kant laat zien. Het perfecte accessoire om je elegantie uit te drukken met die toegankelijke sensualiteit die je vrouwelijkheid viert in al haar genereuze pracht.</p>
summary
stringDe sensualiteit van een jarretelgordel zonder de nadelen van kousen en jarretels.
title
stringKousenband
usageinstructions
string<p>Trek deze jarretelpanty zachtjes aan, begin bij de voeten en werk zo naar boven.</p> <p>De <strong>20 denier </strong>textuur past zich op natuurlijke wijze aan je vorm aan om de illusie van gracieuze benen te creëren.</p> <p>Dit accessoire onthult de sensualiteit van een traditionele jarretelgordel en biedt tegelijkertijd het comfort van een panty, waardoor elk moment een elegante ervaring wordt.</p>
pt
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavar à mão em água fria para preservar a textura sedosa</li> <li>Utilizar um detergente suave sem agentes branqueadores</li> <li>Secar ao ar livre, longe da luz direta</li> <li>evitar secar à centrifugação para manter a elasticidade de 20 deniers</li> <li>Não passar a ferro para preservar as rendas delicadas</li> <li>Manusear suavemente para evitar que a renda fique presa</li> </ul>
description
string<p><span>Estes collants de ligas são um acessório elegante e requintado que lhe oferece sensualidade e erotismo sem os inconvenientes de um cinto de ligas tradicional. </span></p> <p><span>A textura sedosa e transparente da perna cria a ilusão de pernas longas e graciosas, enquanto a delicada renda em torno das zonas de fecho dos meias acrescenta um toque sedutor de feminilidade que falta em muitos conjuntos mais ousados. </span></p> <p><span>Este acessório permite-lhe realçar a sua figura com um visual simultaneamente elegante e sensual, sem comprometer o conforto.</span></p>
guid
stringhttps://dev.divasboudoir.com/pt/collants-de-ligas-de-renda-grandes-preto/cgoc0778.htm
highlights
string<ul> <li style="font-weight: bold;"><strong>A sensualidade de um cinto de ligas sem os constrangimentos tradicionais</strong></li> <li>A textura sedosa e transparente cria a ilusão de pernas graciosas</li> <li>Renda delicada nos pontos de fixação para uma feminilidade sedutora</li> <li>Ajuste perfeito para todas as formas do corpo</li> <li>Voile <strong>de 20 deniers</strong> para um efeito sofisticado e requintado</li> <li>Ótimo conforto sem comprometer a elegância sensual</li> <li>Salto cubano e costura decorativa para um pormenor de luxo</li> <li>Curvas sublimes e generosas com um apoio ótimo</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringEstes collants de ligas são um acessório elegante e requintado que oferece sensualidade e sofisticação sem os inconvenientes de um cinto de ligas tradicional.
keywords
string
title
stringCollants plus size - Efeito cinta-liga
seotitle
stringCollants de ligas de renda grandes
seouri
stringcollants-de-ligas-de-renda-grandes-preto
specifications
string<ul> <li>Estilo : Collants de liga com efeito de ilusão sensual</li> <li>Denier : 20 denier textura sedosa e transparente</li> <li>Renda: Delicadas zonas femininas de meias</li> <li>Salto: Pormenor cubano de luxo sofisticado</li> <li>Costura: Decorativa com acabamento refinado feito à mão</li> <li>Composição: 86% poliamida 14% spandex elástico</li> <li>Apoio: Ótimo para todas as formas do corpo</li> <li>Conforto: Absoluto sem comprometer a elegância sensual</li> </ul>
stylingtips
string<p>Estes collants de liga destacam-se graças a um design que combina sensualidade e praticidade. Use-os para aquelas ocasiões especiais em que quer revelar a sua feminilidade com sofisticação.</p> <p>A renda delicada e o efeito ilusão criam uma silhueta cativante que realça a sua beleza natural.</p> <p>Perfeitos por baixo de um vestido ou saia, dão aquele toque discreto de sensualidade que revela o seu lado sedutor. O acessório perfeito para expressar a sua elegância com aquela sensualidade acessível que celebra a sua feminilidade em todo o seu generoso esplendor.</p>
summary
stringA sensualidade de um cinto de ligas sem os inconvenientes das meias e ligas.
title
stringCollants de ligas
usageinstructions
string<p>Calce suavemente estes collants de ligas, começando pelos pés e subindo.</p> <p>A textura <strong>de 20 denier </strong>adapta-se naturalmente à sua forma para criar a ilusão de pernas graciosas.</p> <p>Este acessório revela a sensualidade de um cinto de ligas tradicional ao mesmo tempo que oferece o conforto dos collants, transformando cada momento numa experiência elegante.</p>
fetishboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
latexboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
legsboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>Diese Strapsstrumpfhose ist ein elegantes und raffiniertes Accessoire, das Ihnen Sinnlichkeit und Raffinesse bietet, ohne die Nachteile eines herkömmlichen Strapsgürtels. </span></p> <p><span>Die seidig-transparente Textur des Beins erzeugt die Illusion von langen, anmutigen Beinen, während die zarte Spitze um die Befestigungsbereiche der Strumpfhalter einen verführerischen Hauch von Weiblichkeit verleiht, der in vielen gewagteren Outfits nicht vorhanden ist. </span></p> <p><span>Mit diesem Accessoire können Sie Ihre Figur mit einem eleganten und zugleich sinnlichen Look betonen, ohne dabei Kompromisse beim Tragekomfort eingehen zu müssen.</span></p>
highlights
string<ul> <li><strong>Sinnlichkeit von Strapsgürteln</strong> ohne die traditionellen Einschränkungen</li> <li>Seidige, transparente Textur schafft die Illusion anmutiger Beine</li> <li>Zarte Spitze an den Befestigungsstellen für verführerische Weiblichkeit</li> <li>Passt sich perfekt an jede Beinform an</li> <li>Erhältlich in einer großen Auswahl an Größen, die schwer zu finden sind</li> <li><strong>20-Denier-Voile</strong> für einen anspruchsvollen und raffinierten Effekt.</li> <li>Optimaler Tragekomfort, ohne die sinnliche Eleganz zu beeinträchtigen</li> <li><strong>Kubanischer Absatz und Ziernaht</strong> für luxuriöse Details</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringDiese Strapsstrumpfhose ist ein elegantes und raffiniertes Accessoire, das Ihnen Sinnlichkeit und Raffinesse bietet, ohne die Nachteile eines herkömmlichen Strapsgürtels.
keywords
string
title
stringStrumpfhose in großen Größen - Strapsgürtel-Effekt
seotitle
stringStrapsstrumpfhose große Größe
seouri
stringstrapsstrumpfhose-grosse-grosse-schwarz
specifications
string<ul> <li>Stil: Strapsstrumpfhose mit sinnlichem Illusionseffekt</li> <li>Denier: 20 Denier transparente, seidige Textur</li> <li>Spitze: Zarte Bereiche fixieren Strapse Weiblichkeit</li> <li>Ferse: Kubanisch anspruchsvolles Luxusdetail</li> <li>Naht: Dekorative raffinierte handwerkliche Verarbeitung</li> <li>Zusammensetzung: 86% Polyamid 14% Stretch-Spandex</li> <li>Größen: Große Bandbreite schwer zu finden</li> <li>Tragekomfort: Optimal, ohne sinnliche Eleganz zu beeinträchtigen</li> </ul>
stylingtips
string<p>Diese Strapsstrumpfhose ist dank ihres Designs, das Sinnlichkeit und Praktikabilität vereint, selbsterklärend. Tragen Sie sie zu besonderen Anlässen, bei denen Sie Ihre Weiblichkeit auf raffinierte Weise enthüllen möchten.</p> <p>Die zarte Spitze und der Illusionseffekt schaffen eine fesselnde Silhouette, die Ihre natürliche Schönheit unterstreicht. Perfekt unter einem Kleid oder einem Rock, verleiht es Ihnen diesen diskreten Hauch von Sinnlichkeit, der Ihre verführerische Seite offenbart.</p> <p>Das ideale Accessoire, um Ihre Eleganz mit dieser zugänglichen Sinnlichkeit zum Ausdruck zu bringen, die niemals Ihren Komfort in all seiner raffinierten Pracht beeinträchtigt.</p>
summary
stringDie Sinnlichkeit eines Strapsgürtels ohne seine Nachteile.
title
stringStrapsstrumpfhose große Größe
usageinstructions
string<p>Ziehen Sie diese Strapsstrumpfhose sanft von den Füßen beginnend nach oben an.</p> <p>Die 20-Denier-Textur passt sich auf natürliche Weise Ihrer Körperform an, um die Illusion graziler Beine zu erzeugen.</p> <p>Dieses Accessoire enthüllt die Sinnlichkeit eines traditionellen Strapsgürtels und bietet gleichzeitig den Komfort einer Strumpfhose, wodurch jeder Moment zu einem eleganten Erlebnis wird.</p>
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>Αυτές οι καλτσοδέτες είναι ένα κομψό και εκλεπτυσμένο αξεσουάρ που σας προσφέρει αισθησιασμό και εκλέπτυνση χωρίς τα μειονεκτήματα μιας παραδοσιακής ζώνης καλτσοδέτας. </span></p> <p><span>Η μεταξένια, διάφανη υφή του ποδιού δημιουργεί την ψευδαίσθηση μακρών, χαριτωμένων ποδιών, ενώ η λεπτή δαντέλα γύρω από τις περιοχές που δένουν οι τιράντες προσθέτει μια σαγηνευτική πινελιά θηλυκότητας που λείπει από πολλά πιο τολμηρά ρούχα. </span></p> <p><span>Αυτό το αξεσουάρ σας επιτρέπει να αναδείξετε τη σιλουέτα σας με μια εμφάνιση που είναι κομψή και αισθησιακή, χωρίς συμβιβασμούς στην άνεση.</span></p>
highlights
string<ul> <li><strong>Ο αισθησιασμός μιας ζαρτιέρας</strong> χωρίς τους παραδοσιακούς περιορισμούς</li> <li>Η μεταξένια, διάφανη υφή δημιουργεί την ψευδαίσθηση χαριτωμένων ποδιών</li> <li>Λεπτή δαντέλα στα σημεία στερέωσης για σαγηνευτική θηλυκότητα</li> <li>Ταιριάζει απόλυτα σε όλα τα σχήματα ποδιών</li> <li>Διατίθεται σε ένα ευρύ φάσμα δυσεύρετων μεγεθών</li> <li><strong>20 denier</strong> voile για ένα εκλεπτυσμένο και εκλεπτυσμένο αποτέλεσμα</li> <li>Βέλτιστη άνεση χωρίς συμβιβασμούς στην αισθησιακή κομψότητα</li> <li><strong>Κουβανέζικο τακούνι και διακοσμητικές ραφές</strong> για πολυτελείς λεπτομέρειες</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringΑυτές οι καλτσοδέτες είναι ένα κομψό, εκλεπτυσμένο αξεσουάρ που προσφέρει αισθησιασμό και εκλέπτυνση χωρίς τα μειονεκτήματα μιας παραδοσιακής ζώνης καλτσοδέτας.
keywords
string
title
stringΚαλσόν για μεγάλα μεγέθη - Εφέ καλτσοδέτας
seotitle
stringΚαλσόν καλσόν μεγάλου μεγέθους
seouri
stringkalson-kalson-megaloy-megethoys-mayro
specifications
string<ul> <li>Στυλ : Αισθησιακό καλσόν με καλσόν με εφέ ψευδαίσθησης</li> <li>Denier: 20 denier μεταξένια διαφανής υφή</li> <li>Δαντέλα: Ντελικάτες, θηλυκές ζώνες πρόσδεσης με τιράντες</li> <li>Φτέρνα: Κουβανέζικη εκλεπτυσμένη λεπτομέρεια πολυτέλειας</li> <li>Ραφή: Διακοσμητική με εκλεπτυσμένη δεξιοτεχνία</li> <li>Σύνθεση: 86% πολυαμίδιο 14% ελαστικό spandex</li> <li>Μεγέθη: Ευρεία γκάμα που είναι δύσκολο να βρεθεί</li> <li>Άνεση: Βέλτιστη χωρίς συμβιβασμούς στην αισθησιακή κομψότητα</li> </ul>
stylingtips
string<p>Αυτά τα καλσόν με καλτσοδέτες στέκονται μόνα τους χάρη σε ένα σχέδιο που συνδυάζει αισθησιασμό και πρακτικότητα. Φορέστε το για τις ειδικές περιστάσεις που θέλετε να αποκαλύψετε τη θηλυκότητά σας με φινέτσα.</p> <p>Η λεπτή δαντέλα και το εφέ ψευδαίσθησης δημιουργούν μια σαγηνευτική σιλουέτα που αναδεικνύει τη φυσική σας ομορφιά. Ιδανικό κάτω από ένα φόρεμα ή μια φούστα, προσθέτει αυτή τη διακριτική πινελιά αισθησιασμού που αποκαλύπτει τη σαγηνευτική σας πλευρά.</p> <p>Το τέλειο αξεσουάρ για να εκφράσετε την κομψότητά σας με προσιτό αισθησιασμό που δεν συμβιβάζει ποτέ την άνεσή σας σε όλο του το εκλεπτυσμένο μεγαλείο.</p>
summary
stringΟ αισθησιασμός μιας ζαρτιέρας χωρίς τα μειονεκτήματα.
title
stringΚαλσόν καλσόν μεγάλου μεγέθους
usageinstructions
string<p>Φορέστε απαλά αυτό το καλσόν, ξεκινώντας από τα πόδια και ανεβαίνοντας προς τα πάνω.</p> <p>Η υφή 20 denier προσαρμόζεται φυσικά στο σχήμα σας για να δημιουργήσει την ψευδαίσθηση χαριτωμένων ποδιών.</p> <p>Αυτό το αξεσουάρ αποκαλύπτει τον αισθησιασμό μιας παραδοσιακής ζαρτιέρας, ενώ προσφέρει την άνεση του καλσόν, μετατρέποντας κάθε στιγμή σε μια κομψή εμπειρία.</p>
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>These garter tights are an elegant, refined accessory that offers sensuality and sophistication without the drawbacks of a traditional garter belt. </span></p> <p><span>The silky, sheer texture of the leg creates the illusion of long, graceful legs, while the delicate lace around the garter fastening areas adds a seductive touch of femininity, absent in many more daring outfits. </span></p> <p><span>This accessory lets you enhance your silhouette with a look that's both elegant and sensual, without compromising comfort.</span></p>
highlights
string<ul> <li><strong>Sensual garter belt</strong> without the traditional constraints</li> <li>Silky, sheer texture creates the illusion of graceful legs</li> <li>Delicate lace at the fastening points for seductive femininity</li> <li>Fits all leg morphologies perfectly</li> <li>Available in a wide range of hard-to-find sizes</li> <li><strong>20-denier</strong> voile for a sophisticated, refined effect</li> <li>Optimum comfort without compromising sensual elegance</li> <li><strong>Cuban heel and decorative stitching</strong> for luxurious details</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringThese garter tights are an elegant, refined accessory that offers sensuality and sophistication without the drawbacks of a traditional garter belt.
keywords
string
title
stringPlus size tights - Garter effect
seotitle
stringPlus size garter tights
seouri
stringplus-size-garter-tights-black
specifications
string<ul> <li>Style: Sensual illusion effect garter tights</li> <li>Denier: 20 denier silky sheer texture</li> <li>Lace: Delicate, feminine suspender fastening zones</li> <li>Heel: Cuban sophisticated luxury detail</li> <li>Seam: Decorative, refined hand-crafted finish</li> <li>Composition: 86% polyamide 14% stretch spandex</li> <li>Sizes: Wide range hard to find</li> <li>Comfort: Optimal without compromising sensual elegance</li> </ul>
stylingtips
string<p>These garter tights stand on their own thanks to a design that combines sensuality and practicality. Wear them for those special occasions when you want to reveal your femininity with sophistication.</p> <p>The delicate lace and illusion effect create a captivating silhouette that enhances your natural beauty. Perfect under a dress or skirt, it adds that discreet touch of sensuality that reveals your seductive side.</p> <p>The ideal accessory to express your elegance with accessible sensuality that never compromises your comfort in all its refined splendor.</p>
summary
stringThe sensuality of a garter belt without the drawbacks.
title
stringPlus size garter tights
usageinstructions
string<p>Gently slip on these garter tights, starting at the feet and working your way up.</p> <p>The 20-denier texture adapts naturally to your morphology to create the illusion of graceful legs.</p> <p>This accessory reveals the sensuality of a traditional garter belt while offering the comfort of tights, transforming every moment into an elegant experience.</p>
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>Estas medias con liguero son un accesorio elegante y refinado que te ofrece sensualidad y sofisticación sin los inconvenientes de un liguero tradicional. </span></p> <p><span>Su textura sedosa y transparente crea la ilusión de unas piernas largas y gráciles, mientras que el delicado encaje que rodea las zonas de sujeción de los ligueros añade un seductor toque de feminidad que falta en muchos conjuntos más atrevidos. </span></p> <p><span>Este accesorio te permite realzar tu figura con un look a la vez elegante y sensual, sin renunciar a la comodidad.</span></p>
highlights
string<ul> <li><strong>La sensualidad de un liguero</strong> sin las restricciones tradicionales</li> <li>La textura sedosa y transparente crea la ilusión de unas piernas gráciles</li> <li>Delicado encaje en los puntos de sujeción para una feminidad seductora</li> <li>Se adapta perfectamente a todas las formas de pierna</li> <li>Disponible en una amplia gama de tallas difíciles de encontrar</li> <li>Tejido de gasa <strong>de 20 deniers</strong> para un efecto sofisticado y refinado</li> <li>Comodidad óptima sin renunciar a una elegancia sensual</li> <li><strong>Tacón cubano y costuras decorativas</strong> para un detalle de lujo</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringEstas medias con liguero son un accesorio elegante y refinado que ofrece sensualidad y sofisticación sin los inconvenientes de un liguero tradicional.
keywords
string
title
stringMedias de talla grande - Efecto liguero
seotitle
stringMedias de liga de talla grande
seouri
stringmedias-de-liga-de-talla-grande-negro
specifications
string<ul> <li>Estilo: Sensuales medias de liguero efecto ilusión</li> <li>Denier: 20 deniers de textura sedosa y transparente</li> <li>Encaje: Delicadas y femeninas zonas de sujeción del liguero</li> <li>Tacón: Cubano sofisticado detalle de lujo</li> <li>Costura: Decorativa con refinada artesanía</li> <li>Composición: 86% poliamida 14% elastán</li> <li>Tallas: Amplia gama difícil de encontrar</li> <li>Comodidad: Óptima sin comprometer la elegancia sensual</li> </ul>
stylingtips
string<p>Estas medias con liguero destacan por sí solas gracias a un diseño que combina sensualidad y practicidad. Póntelas en esas ocasiones especiales en las que quieres revelar tu feminidad con sofisticación.</p> <p>El delicado encaje y el efecto ilusión crean una silueta cautivadora que realza tu belleza natural. Perfecto bajo un vestido o una falda, añade ese discreto toque de sensualidad que revela tu lado seductor.</p> <p>El accesorio perfecto para expresar tu elegancia con una sensualidad accesible que nunca compromete tu comodidad en todo su refinado esplendor.</p>
summary
stringLa sensualidad de un liguero sin sus inconvenientes.
title
stringMedias de liga de talla grande
usageinstructions
string<p>Desliza suavemente estas medias con liguero, empezando por los pies y subiendo hacia arriba.</p> <p>La textura de 20 deniers se adapta de forma natural a tu figura para crear la ilusión de unas piernas elegantes.</p> <p>Este accesorio revela la sensualidad de un liguero tradicional a la vez que ofrece la comodidad de unas medias, convirtiendo cada momento en una experiencia elegante.</p>
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Ce <strong>collant porte-jarretelles</strong> incarne la solution parfaite pour toutes celles qui recherchent la sensualit&eacute; d'un porte-jarretelles sans les inconv&eacute;nients. Cette cr&eacute;ation &eacute;l&eacute;gante et raffin&eacute;e vous offre cette sophistication s&eacute;duisante tout en s'adaptant parfaitement &agrave; toutes les morphologies de jambes.<br><br>La texture soyeuse et transparente de <strong>20 deniers</strong> cr&eacute;e cette illusion remarquable de jambes longues et gracieuses qui valorise la silhouette des jambes. Cette finition d&eacute;licate offre un effet gainant et allongeant naturel, sublimant les mollets et affinant la cheville avec cette gr&acirc;ce intemporelle.<br><br>La d&eacute;licate dentelle autour des jarretelles apporte cette touche de f&eacute;minit&eacute; s&eacute;duisante qui distingue cet accessoire des tenues plus conventionnelles. Cette finition artisanale r&eacute;v&egrave;le votre go&ucirc;t pour les d&eacute;tails raffin&eacute;s tout en conservant cette &eacute;l&eacute;gance moderne.<br><br>Disponible dans <strong>une gamme &eacute;tendue de tailles</strong>, cet accessoire r&eacute;pond &agrave; une demande sp&eacute;cifique difficile &agrave; satisfaire sur le march&eacute;. Cette disponibilit&eacute; exceptionnelle permet &agrave; toutes les femmes de d&eacute;couvrir cette sensualit&eacute; accessible, quelle que soit leur morphologie.<br><br>Le talon cubain et la couture d&eacute;corative ajoutent ces <strong>d&eacute;tails luxueux</strong> qui transforment ce collant en v&eacute;ritable accessoire de mode. Cette conception &eacute;tudi&eacute;e assure un maintien optimal sans compression excessive, garantissant un confort longue dur&eacute;e.<br><br>Parfait pour sublimer votre silhouette avec une allure &agrave; la fois &eacute;l&eacute;gante et sensuelle, cet accessoire r&eacute;volutionnaire transforme chaque moment en opportunit&eacute; de r&eacute;v&eacute;ler votre f&eacute;minit&eacute; avec cette sophistication qui ne compromet jamais votre confort.</p>
highlights
string<ul> <li><strong>Sensualit&eacute; du porte-jarretelles</strong> sans les contraintes traditionnelles</li> <li>Texture soyeuse et transparente cr&eacute;ant l'illusion de jambes gracieuses</li> <li>Dentelle d&eacute;licate aux zones de fixation pour une f&eacute;minit&eacute; s&eacute;duisante</li> <li>S'adapte parfaitement &agrave; toutes les morphologies de jambes</li> <li>Disponible dans une gamme &eacute;tendue de tailles difficile &agrave; trouver</li> <li>Voile <strong>20 deniers</strong> pour un effet sophistiqu&eacute; et raffin&eacute;</li> <li>Confort optimal sans compromettre l'&eacute;l&eacute;gance sensuelle</li> <li><strong>Talon cubain et couture d&eacute;corative</strong> pour des d&eacute;tails luxueux</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringCe collant porte-jarretelles est un accessoire élégant et raffiné qui vous offre la sensualité et la sophistication sans les inconvénients d'un porte-jarretelles traditionnel.
keywords
string
title
stringCollant grande taille - Effet porte-jarretelles
seotitle
stringCollant Porte-Jarretelles Grandes Tailles - Sensualité Élégante
seouri
stringcollant-porte-jarretelles-grandes-tailles-sensualite-elegante
specifications
string<ul> <li>Style : Collant porte-jarretelles effet illusion sensuel</li> <li>Denier : 20 deniers texture soyeuse transparente</li> <li>Dentelle : D&eacute;licate zones fixation jarretelles f&eacute;minit&eacute;</li> <li>Talon : Cubain d&eacute;tail luxueux sophistiqu&eacute;</li> <li>Couture : D&eacute;corative finition artisanale raffin&eacute;e</li> <li>Composition : 86% polyamide 14% spandex extensible</li> <li>Tailles : Gamme &eacute;tendue difficile &agrave; trouver</li> <li>Confort : Optimal sans compromettre &eacute;l&eacute;gance sensuelle</li> </ul>
stylingtips
string<p>Ce collant porte-jarretelles se suffit &agrave; lui-m&ecirc;me gr&acirc;ce &agrave; son design qui allie sensualit&eacute; et praticit&eacute;. Portez-le pour vos occasions sp&eacute;ciales o&ugrave; vous voulez r&eacute;v&eacute;ler votre f&eacute;minit&eacute; avec sophistication.</p> <p>La dentelle d&eacute;licate et l'effet illusion cr&eacute;ent une silhouette captivante qui sublime votre beaut&eacute; naturelle. Parfait sous une robe ou une jupe, il apporte cette touche de sensualit&eacute; discr&egrave;te qui r&eacute;v&egrave;le votre c&ocirc;t&eacute; s&eacute;ducteur.</p> <p>L'accessoire id&eacute;al pour exprimer votre &eacute;l&eacute;gance avec cette sensualit&eacute; accessible qui ne compromet jamais votre confort dans toute sa splendeur raffin&eacute;e.</p>
summary
string<p>Ce collant porte-jarretelles r&eacute;v&egrave;le la sensualit&eacute; d'un porte-jarretelles traditionnel sans les inconv&eacute;nients.</p> <p>Sa texture soyeuse&nbsp;<strong>20 deniers</strong> cr&eacute;e l'illusion de jambes longues et gracieuses, tandis que la dentelle d&eacute;licate apporte cette f&eacute;minit&eacute; s&eacute;duisante.</p> <p>Disponible dans une&nbsp;<strong>gamme &eacute;tendue de tailles</strong>, cet accessoire rare sublime votre silhouette avec &eacute;l&eacute;gance.</p>
title
stringCollant Porte-Jarretelles Effet Illusion - Sensualité Sans Contraintes
usageinstructions
string<p>Enfilez d&eacute;licatement ce collant porte-jarretelles en commen&ccedil;ant par les pieds, puis remontez progressivement.</p> <p>La texture 20 deniers s'adapte naturellement &agrave; votre morphologie pour cr&eacute;er cet effet illusion de jambes gracieuses.</p> <p>Cet accessoire r&eacute;v&egrave;le la sensualit&eacute; d'un porte-jarretelles traditionnel tout en offrant le confort d'un collant, transformant chaque moment en exp&eacute;rience &eacute;l&eacute;gante.</p>
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>Questi collant da reggicalze sono un accessorio elegante e raffinato che vi offre sensualità e raffinatezza senza gli inconvenienti di un reggicalze tradizionale. </span></p> <p><span>La texture setosa e trasparente della gamba crea l'illusione di gambe lunghe e aggraziate, mentre il delicato pizzo intorno alle zone di allacciatura del reggicalze aggiunge un seducente tocco di femminilità che manca in molti abiti più audaci. </span></p> <p><span>Questo accessorio vi permette di valorizzare la vostra figura con un look elegante e sensuale, senza compromettere il comfort.</span></p>
highlights
string<ul> <li><strong>La sensualità di un reggicalze</strong> senza i vincoli tradizionali</li> <li>La texture setosa e trasparente crea l'illusione di gambe aggraziate</li> <li>Delicato pizzo nei punti di chiusura per una femminilità seducente</li> <li>Si adatta perfettamente a tutte le forme di gamba</li> <li>Disponibile in un'ampia gamma di taglie difficili da trovare</li> <li>Voile <strong>20 denari</strong> per un effetto sofisticato e raffinato</li> <li>Comfort ottimale senza compromettere la sensuale eleganza</li> <li><strong>Tacco cubano e cuciture decorative</strong> per un dettaglio di lusso</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringQuesti collant sono un accessorio elegante e raffinato che offre sensualità e raffinatezza senza gli inconvenienti di un reggicalze tradizionale.
keywords
string
title
stringCollant taglia grande - Effetto giarrettiera
seotitle
stringCollant da reggicalze di taglia grande
seouri
stringcollant-da-reggicalze-di-taglia-grande-nero
specifications
string<ul> <li>Stile: collant sensuale con effetto illusorio</li> <li>Denier: 20 denari di texture setosa e trasparente</li> <li>Pizzo: zone di chiusura delicata e femminile con reggicalze</li> <li>Tacco: dettaglio cubano di lusso sofisticato</li> <li>Cuciture: Decorative con una raffinata lavorazione artigianale</li> <li>Composizione: 86% poliammide 14% spandex elasticizzato</li> <li>Taglie: Ampia gamma difficile da trovare</li> <li>Comfort: Ottimale senza compromettere la sensuale eleganza</li> </ul>
stylingtips
string<p>Questi collant reggicalze si distinguono per un design che unisce sensualità e praticità. Indossateli per le occasioni speciali in cui volete rivelare la vostra femminilità con raffinatezza.</p> <p>Il pizzo delicato e l'effetto illusione creano una silhouette accattivante che esalta la vostra bellezza naturale. Perfetto sotto un abito o una gonna, aggiunge quel tocco di sensualità discreta che rivela il vostro lato seducente.</p> <p>L'accessorio perfetto per esprimere la vostra eleganza con una sensualità accessibile che non compromette mai il vostro comfort in tutto il suo raffinato splendore.</p>
summary
stringLa sensualità di un reggicalze senza gli inconvenienti.
title
stringCollant a giarrettiera di taglia grande
usageinstructions
string<p>Infilate delicatamente questi collant da reggicalze, partendo dai piedi e salendo verso l'alto.</p> <p>La texture da 20 denari si adatta naturalmente alle vostre forme per creare l'illusione di gambe aggraziate.</p> <p>Questo accessorio rivela la sensualità di un reggicalze tradizionale offrendo al contempo il comfort di un collant, trasformando ogni momento in un'esperienza elegante.</p>
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>Deze jarretelpanty is een elegant en verfijnd accessoire dat je sensualiteit en verfijning biedt zonder de nadelen van een traditionele jarretelgordel. </span></p> <p><span>De zijdeachtige, transparante textuur van het been creëert de illusie van lange, sierlijke benen, terwijl het delicate kant rond de jarretels een verleidelijk vleugje vrouwelijkheid toevoegt dat ontbreekt bij veel meer gewaagde outfits. </span></p> <p><span>Met dit accessoire kun je je figuur verbeteren met een look die zowel elegant als sensueel is, zonder afbreuk te doen aan comfort.</span></p>
highlights
string<ul> <li><strong>De sensualiteit van een jarretelgordel</strong> zonder de traditionele beperkingen</li> <li>Zijdeachtige, transparante textuur creëert de illusie van sierlijke benen</li> <li>Delicaat kant op de bevestigingspunten voor verleidelijke vrouwelijkheid</li> <li>Past perfect bij alle beenvormen</li> <li>Verkrijgbaar in een groot aantal moeilijk te vinden maten</li> <li><strong>20 denier</strong> voile voor een geraffineerd en verfijnd effect</li> <li>Optimaal comfort zonder afbreuk te doen aan sensuele elegantie</li> <li><strong>Cubaanse hak en decoratieve stiksels</strong> voor luxueuze details</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringDeze jarretelleggings zijn een elegant, verfijnd accessoire dat sensualiteit en raffinement biedt zonder de nadelen van een traditionele jarretelgordel.
keywords
string
title
stringGrote maten panty's - Kousenbandeffect
seotitle
stringGrote maat kousenbroek
seouri
stringgrote-maat-kousenbroek-zwart
specifications
string<ul> <li>Stijl: Sensuele kousenbandpanty met illusie-effect</li> <li>Denier: 20 denier zijdeachtige, transparante textuur</li> <li>Kant: Delicate, vrouwelijke jarretelbevestigingszones</li> <li>Hak: Cubaans verfijnd luxe detail</li> <li>Naad: Decoratief met verfijnd vakmanschap</li> <li>Samenstelling: 86% polyamide 14% stretch spandex</li> <li>Maten: Moeilijk te vinden</li> <li>Comfort: Optimaal zonder afbreuk te doen aan sensuele elegantie</li> </ul>
stylingtips
string<p>Deze jarretelpanty staat op zichzelf dankzij een ontwerp dat sensualiteit en functionaliteit combineert. Draag ze voor speciale gelegenheden wanneer je je vrouwelijkheid op geraffineerde wijze wilt onthullen.</p> <p>Het delicate kant en het illusie-effect creëren een betoverend silhouet dat je natuurlijke schoonheid benadrukt. Perfect onder een jurk of rok, voegt het dat discrete vleugje sensualiteit toe dat je verleidelijke kant laat zien.</p> <p>Het perfecte accessoire om je elegantie uit te drukken met toegankelijke sensualiteit die nooit concessies doet aan je comfort in al zijn verfijnde pracht.</p>
summary
stringDe sensualiteit van een jarretelgordel zonder de nadelen.
title
stringGrote maat kousenbroek
usageinstructions
string<p>Trek deze jarretelpanty zachtjes aan, begin bij de voeten en werk zo naar boven.</p> <p>De 20 denier textuur past zich op natuurlijke wijze aan je vorm aan om de illusie van gracieuze benen te creëren.</p> <p>Dit accessoire onthult de sensualiteit van een traditionele jarretelgordel en biedt tegelijkertijd het comfort van een panty, waardoor elk moment een elegante ervaring wordt.</p>
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>Estes collants de ligas são um acessório elegante e requintado que lhe oferece sensualidade e sofisticação sem os inconvenientes de um cinto de ligas tradicional. </span></p> <p><span>A textura sedosa e transparente da perna cria a ilusão de pernas longas e graciosas, enquanto a delicada renda à volta das zonas de fecho dos meias acrescenta um toque sedutor de feminilidade que falta em muitos conjuntos mais ousados. </span></p> <p><span>Este acessório permite-lhe realçar a sua figura com um visual simultaneamente elegante e sensual, sem comprometer o conforto.</span></p>
highlights
string<ul> <li><strong>A sensualidade de um cinto de ligas</strong> sem os constrangimentos tradicionais</li> <li>A textura sedosa e transparente cria a ilusão de pernas graciosas</li> <li>Renda delicada nos pontos de fixação para uma feminilidade sedutora</li> <li>Adapta-se perfeitamente a todas as formas de pernas</li> <li>Disponível numa vasta gama de tamanhos difíceis de encontrar</li> <li>Voile <strong>de 20 deniers</strong> para um efeito sofisticado e requintado</li> <li>Conforto ótimo sem comprometer a elegância sensual</li> <li><strong>Salto cubano e costura decorativa</strong> para um pormenor de luxo</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringEstes collants de ligas são um acessório elegante e requintado que oferece sensualidade e sofisticação sem os inconvenientes de um cinto de ligas tradicional.
keywords
string
title
stringCollants plus size - Efeito cinta-liga
seotitle
stringCollants de ligas de tamanho grande
seouri
stringcollants-de-ligas-de-tamanho-grande-preto
specifications
string<ul> <li>Estilo : Collants de liga com efeito de ilusão sensual</li> <li>Denier: 20 denier de textura sedosa e transparente</li> <li>Renda: Zonas delicadas e femininas de fecho de suspensório</li> <li>Salto: Pormenor cubano de luxo sofisticado</li> <li>Costura: Decorativa com artesanato refinado</li> <li>Composição: 86% poliamida 14% elastano</li> <li>Tamanhos: Grande variedade difícil de encontrar</li> <li>Conforto: Ótimo sem comprometer a elegância sensual</li> </ul>
stylingtips
string<p>Estes collants de liga destacam-se graças a um design que combina sensualidade e praticidade. Use-os em ocasiões especiais quando quiser revelar a sua feminilidade com sofisticação.</p> <p>A renda delicada e o efeito ilusão criam uma silhueta cativante que realça a sua beleza natural. Perfeitas por baixo de um vestido ou de uma saia, dão aquele toque discreto de sensualidade que revela o seu lado sedutor.</p> <p>O acessório perfeito para expressar a sua elegância com uma sensualidade acessível que nunca compromete o seu conforto em todo o seu esplendor refinado.</p>
summary
stringA sensualidade de um cinto de ligas sem os inconvenientes.
title
stringCollants de ligas de tamanho grande
usageinstructions
string<p>Calce suavemente estes collants de ligas, começando pelos pés e subindo.</p> <p>A textura de 20 denier adapta-se naturalmente à sua forma para criar a ilusão de pernas graciosas.</p> <p>Este acessório revela a sensualidade de um cinto de ligas tradicional ao mesmo tempo que oferece o conforto dos collants, transformando cada momento numa experiência elegante.</p>
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
stringMM-2619-00001 Collants en dentelle à bretelles incurvées
netweight
string
nextshipment
stringtomorrow
ordered
number7
orderidx
number0
origin
string
originalsize
string
packaging
string
productshipment
stringauto
productuid
string6503065D-BFA9-44CE-BF37CD1F33FBC728
promountil
string
rating
stringnone
recorduid
string6503065D-BFA9-44CE-BF37CD1F33FBC728
reference
stringCGOC0778
related
string
reserved
string
returned
number0
returnsallowed
number1
section
stringlingerie
shipment
string5to7days
showbrand
number0
sizeinfos
Query
Template: /system/api/product/sizes.cfc:20
Execution Time: 1.79 ms
Record Count: 4
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,'2268,2269,2270,2271') > 0
and product_variations.productuid = '6503065D-BFA9-44CE-BF37CD1F33FBC728'
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
122687-8intlsizeblack78-19999990wplusstocking1X-2X7-848-5018-2022-2450-5250-5248-5054-5650-5248-50168-17877-100
222699-10intlsizeblack910-19999992wplusstocking3X-4X9-1052-5422-2426-2854-5654-5652-5458-6054-5652-54168-18391-118
3227011-12intlsizeblack1112-19999990wplusstocking5X-6X11-1256-5826-2830-3258-6058-6056-5862-6458-6056-58168-183104-132
4227113-14intlsizeblack1314-19999990wplusstocking7X13-1460-6230-3234-3662-6462-6460-6266-6862-6460-62168-183118-150
sizeranges
stringplus
sizes
string2268,2269,2270,2271
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: 7.7 ms
Record Count: 4
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select * from (
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '6503065D-BFA9-44CE-BF37CD1F33FBC728'
and product_variations.isactive = 1
and product_sizes.id_size = 2268
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 = '6503065D-BFA9-44CE-BF37CD1F33FBC728'
and product_variations.isactive = 1
and product_sizes.id_size = 2269
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 = '6503065D-BFA9-44CE-BF37CD1F33FBC728'
and product_variations.isactive = 1
and product_sizes.id_size = 2270
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 = '6503065D-BFA9-44CE-BF37CD1F33FBC728'
and product_variations.isactive = 1
and product_sizes.id_size = 2271
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
16503065D-BFA9-44CE-BF37CD1F33FBC728D162FB85-4FB9-40FD-951A5DE94B7B252F2268black#0000001X-2X7-848-5018-2022-2450-5250-5248-5054-5650-5248-50wstocking7-8intlsize16.6250STOCK01000-10300MM-2619802025225518-10all
26503065D-BFA9-44CE-BF37CD1F33FBC728752B93EE-CD9D-4641-9E9914CE3D5B643A2269black#0000003X-4X9-1052-5422-2426-2854-5654-5652-5458-6054-5652-54wstocking9-10intlsize16.6250STOCK01200-10400MM-261980202522552522all
36503065D-BFA9-44CE-BF37CD1F33FBC728996DEA95-D438-42BE-910C193C981833362270black#0000005X-6X11-1256-5826-2830-3258-6058-6056-5862-6458-6056-58wstocking11-12intlsize16.6250STOCK01000-10300MM-2619802025225532-10all
46503065D-BFA9-44CE-BF37CD1F33FBC728E872D355-BC62-46CF-8055AC5E1FE0877E2271black#0000007X13-1460-6230-3234-3662-6462-6460-6266-6862-6460-62wstocking13-14intlsize16.6250STOCK01000-10300MM-2619802025225549-10all
subcategory
stringcrotchless
supplier
number-1
supplierreference
stringMM-2619-00001
tags
string
themes
string
totalvariations
string
type
stringdefault
unitprice
number16.625
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 10.8 ms
Record Count: 4
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 = '6503065D-BFA9-44CE-BF37CD1F33FBC728' 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 = '6503065D-BFA9-44CE-BF37CD1F33FBC728' 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 = '6503065D-BFA9-44CE-BF37CD1F33FBC728' 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 = '6503065D-BFA9-44CE-BF37CD1F33FBC728' 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 = '6503065D-BFA9-44CE-BF37CD1F33FBC728' 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 = '6503065D-BFA9-44CE-BF37CD1F33FBC728' 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 = '6503065D-BFA9-44CE-BF37CD1F33FBC728'
and product_variations.isactive = 1
and product_sizes.id_size = 2268
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 = '6503065D-BFA9-44CE-BF37CD1F33FBC728' 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 = '6503065D-BFA9-44CE-BF37CD1F33FBC728' 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 = '6503065D-BFA9-44CE-BF37CD1F33FBC728' 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 = '6503065D-BFA9-44CE-BF37CD1F33FBC728' 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 = '6503065D-BFA9-44CE-BF37CD1F33FBC728' 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 = '6503065D-BFA9-44CE-BF37CD1F33FBC728' 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 = '6503065D-BFA9-44CE-BF37CD1F33FBC728'
and product_variations.isactive = 1
and product_sizes.id_size = 2269
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 = '6503065D-BFA9-44CE-BF37CD1F33FBC728' 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 = '6503065D-BFA9-44CE-BF37CD1F33FBC728' 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 = '6503065D-BFA9-44CE-BF37CD1F33FBC728' 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 = '6503065D-BFA9-44CE-BF37CD1F33FBC728' 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 = '6503065D-BFA9-44CE-BF37CD1F33FBC728' 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 = '6503065D-BFA9-44CE-BF37CD1F33FBC728' 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 = '6503065D-BFA9-44CE-BF37CD1F33FBC728'
and product_variations.isactive = 1
and product_sizes.id_size = 2270
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 = '6503065D-BFA9-44CE-BF37CD1F33FBC728' 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 = '6503065D-BFA9-44CE-BF37CD1F33FBC728' 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 = '6503065D-BFA9-44CE-BF37CD1F33FBC728' 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 = '6503065D-BFA9-44CE-BF37CD1F33FBC728' 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 = '6503065D-BFA9-44CE-BF37CD1F33FBC728' 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 = '6503065D-BFA9-44CE-BF37CD1F33FBC728' 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 = '6503065D-BFA9-44CE-BF37CD1F33FBC728'
and product_variations.isactive = 1
and product_sizes.id_size = 2271
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
1D162FB85-4FB9-40FD-951A5DE94B7B252F2268black#0000001X-2X7-848-5018-2022-2450-5250-5248-5054-5650-5248-50wstocking7-8intlsize16.6250STOCK01000-10300MM-2619802025225518-10-10-12016.625all
2752B93EE-CD9D-4641-9E9914CE3D5B643A2269black#0000003X-4X9-1052-5422-2426-2854-5654-5652-5458-6054-5652-54wstocking9-10intlsize16.6250STOCK01200-10400MM-261980202522552522-12-12016.625all
3996DEA95-D438-42BE-910C193C981833362270black#0000005X-6X11-1256-5826-2830-3258-6058-6056-5862-6458-6056-58wstocking11-12intlsize16.6250STOCK01000-10300MM-2619802025225532-10-10-12016.625all
4E872D355-BC62-46CF-8055AC5E1FE0877E2271black#0000007X13-1460-6230-3234-3662-6462-6460-6266-6862-6460-62wstocking13-14intlsize16.6250STOCK01000-10300MM-2619802025225549-10-10-12016.625all
vatrate
number20
warehouse
string