My cart

❌
Total items
View basket
Menu
See sizes
Open pantyhose without demarcation
Double-click to enlarge
SKU: SLTI8515
Open pantyhose without demarcation
MADE IN
Stock:

Plus size tights open at the crotch and without demarcation.

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 *

Open-back plus size tights without demarcation

Product description

Open crotch pantyhose.

Demarcation-free.

transparent, shiny and open 9cm T-band.

Wide hips and thighs.

High wearing comfort, perfect fit, flat seam and reinforced toe.

20 Denier / 22 DTEX

Technical details

Available sizes

Available from 38-40 to 56-58

Available colors

Black , Beige , Red and White

Composition

Polyamide 82 %
Elastane 18 %
To Top
View basket
Items
Total items
Struct
Entries: 108
actions
Array
available
number-1
brand
stringglamory
brandcode
stringgjjm
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
stringGlamory
breasts
stringna
careinstructions
string
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: 0.98 ms
Record Count: 4
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_colors.color as recorduid, product_colors.type, product_colors.code, product_colors.color, product_colors.range, product_colors.hexvalue,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock
from product_colors
left outer join product_variations on product_colors.color = product_variations.color and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
where FIND_IN_SET(product_colors.color,'black,beige,red,white') > 0
and product_variations.productuid = 'A0288747-8A14-4809-AEC7E079453D88CA'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1blackcolorblakblackblack#000000-10
2beigecolorbeigbeigebrown#F6DBAC-10
3redcolorredredred#F50000-10
4whitecolorwhitwhitewhite#FFFFFF-10
colorrange
stringbrown
colors
stringblack,beige,red,white
colortype
stringcolor
comments
string
compositions
Struct
Entries: 13
coton
string
elastane
string18
free
string
leather
string
lycra
string
metal
string
nylon
string
polyamide
string82
polyester
string
polyurethane
string
silk
string
spandex
string
viscose
string
datecreated
Date Time (Europe/Paris)
{ts '2019-10-09 10:59:00'}
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
booleanfalse
hascolorinfos
booleantrue
hascompositions
booleantrue
hasdescription
booleantrue
hasdimensions
booleanfalse
hasmaterials
booleanfalse
hasotherspecifications
booleanfalse
haspromo
number0
hasshortdescription
booleantrue
hassizeinfos
booleantrue
hasspecifications
booleanfalse
hasstockinfos
booleanfalse
hasstylingtips
booleanfalse
hasusageinstructions
booleanfalse
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
string50129-collants-ouvert-20-unicolor
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-10-05 15:31:49'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.613 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('a0288747-8a14-4809-aec7e079453d88ca',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.3 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 <> 'SLTI8515'
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
string888
isprivate
string0
rating
stringall
src
string/photobank/products/gjjm/slti8515/50129-ouvert-20-make-up-plus-size_crop_2.jpg
type
stringimg
width
string793
back
Struct
height
string2137
isprivate
string0
rating
stringall
src
string/photobank/products/gjjm/slti8515/50129-ouvert-20-white-plus-size_crop.jpg
type
stringimg
width
string1768
default
Struct
height
string2408
isprivate
string0
rating
stringall
src
string/photobank/products/gjjm/slti8515/50129-ouvert-20-red-plus-size_crop.jpg
type
stringimg
width
string1816
variations
Struct
colors
Struct
beige
Struct
height
string888
isprivate
string0
rating
stringall
src
string/photobank/products/gjjm/slti8515/50129-ouvert-20-make-up-plus-size_crop_2.jpg
type
stringimg
width
string793
black
Struct
height
string754
isprivate
string0
rating
stringall
src
string/photobank/products/gjjm/slti8515/50129-ouvert-20-black-plus-size_crop_2.jpg
type
stringimg
width
string618
red
Struct
height
string5200
isprivate
string0
rating
stringall
src
string/photobank/products/gjjm/slti8515/50129-ouvert-20-red-plus-size.jpg
type
stringimg
width
string4854
white
Struct
height
string2137
isprivate
string0
rating
stringall
src
string/photobank/products/gjjm/slti8515/50129-ouvert-20-white-plus-size_crop.jpg
type
stringimg
width
string1768
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-beige-rot-ou-weiss
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-mpez-kokkino-ou-leyko
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-beige-red-ou-white
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-beige-rojo-ou-blanco
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-beige-rouge-ou-blanc
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-beige-rosso-ou-bianco
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-beige-rood-ou-wit
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-bege-vermelho-ou-branco
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
divasboudoir
Struct
de
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringStrumpfhose, die im Schritt offen ist.<br /><br />Ohne Abgrenzungen.<br /><br />transparent, gl&auml;nzend und offener 9 cm T-Band.<br /><br />Sch&ouml;n breite H&uuml;ften und Oberschenkel.<br /><br />Hoher Tragekomfort, perfekte Passform, flache N&auml;hte und verst&auml;rkte Spitzen.<br /><br />20 Denier / 22 DTEX
guid
stringhttps://dev.divasboudoir.com/de/offene-strumpfhose-in-grossen-grossen-ohne-abgrenzungen-schwarz-beige-rot-ou-weiss/slti8515.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringStrumpfhose in großen Größen, die im Schritt offen ist und keine Abgrenzungen aufweist.
keywords
string
title
stringOffene Strumpfhose in großen Größen ohne Abgrenzungen
seotitle
stringOffene Strumpfhose in großen Größen ohne Abgrenzungen
seouri
stringoffene-strumpfhose-in-grossen-grossen-ohne-abgrenzungen-schwarz-beige-rot-ou-weiss
specifications
string
stylingtips
string
summary
stringStrumpfhose in gro&szlig;en Gr&ouml;&szlig;en, die im Schritt offen ist und keine Abgrenzungen aufweist.
title
stringOffene Strumpfhose ohne Abgrenzungen
usageinstructions
string
el
Struct
Entries: 15
abstract
string
careinstructions
string
description
string&Kappa;&alpha;&lambda;&sigma;ό&nu; &mu;&epsilon; &alpha;&nu;&omicron;&iota;&chi;&tau;ό &kappa;&alpha;&beta;ά&lambda;&omicron;.<br /><br />&Mu;&eta; &omicron;&rho;&iota;&omicron;&theta;&epsilon;&tau;&eta;&mu;έ&nu;&omicron;.<br /><br />&delta;&iota;&alpha;&phi;&alpha;&nu;έ&sigmaf;, &gamma;&upsilon;&alpha;&lambda;&iota;&sigma;&tau;&epsilon;&rho;ό &kappa;&alpha;&iota; &alpha;&nu;&omicron;&iota;&chi;&tau;ό &Tau;-&mu;&pi;&rho;ά&tau;&sigma;&omicron; 9 cm.<br /><br />&Phi;&alpha;&rho;&delta;ύ&sigmaf; &gamma;&omicron;&phi;ό&sigmaf; &kappa;&alpha;&iota; &mu;&eta;&rho;&omicron;ί.<br /><br />&Mu;&epsilon;&gamma;ά&lambda;&eta; ά&nu;&epsilon;&sigma;&eta; &sigma;&tau;&eta; &chi;&rho;ή&sigma;&eta;, &tau;έ&lambda;&epsilon;&iota;&alpha; &epsilon;&phi;&alpha;&rho;&mu;&omicron;&gamma;ή, &epsilon;&pi;ί&pi;&epsilon;&delta;&eta; &rho;&alpha;&phi;ή &kappa;&alpha;&iota; &epsilon;&nu;&iota;&sigma;&chi;&upsilon;&mu;έ&nu;&omicron; &delta;ά&chi;&tau;&upsilon;&lambda;&omicron;.<br /><br />20 Denier / 22 DTEX
guid
stringhttps://dev.divasboudoir.com/el/megalo-anoichto-kalson-chwris-oriothethsh-mayro-mpez-kokkino-ou-leyko/slti8515.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringΚολάν μεγάλου μεγέθους με ανοιχτό καβάλο και χωρίς οριοθέτηση.
keywords
string
title
stringΜεγάλο ανοιχτό καλσόν χωρίς οριοθέτηση
seotitle
stringΜεγάλο ανοιχτό καλσόν χωρίς οριοθέτηση
seouri
stringmegalo-anoichto-kalson-chwris-oriothethsh-mayro-mpez-kokkino-ou-leyko
specifications
string
stylingtips
string
summary
string&Kappa;&omicron;&lambda;ά&nu; &mu;&epsilon;&gamma;ά&lambda;&omicron;&upsilon; &mu;&epsilon;&gamma;έ&theta;&omicron;&upsilon;&sigmaf; &mu;&epsilon; &alpha;&nu;&omicron;&iota;&chi;&tau;ό &kappa;&alpha;&beta;ά&lambda;&omicron; &kappa;&alpha;&iota; &chi;&omega;&rho;ί&sigmaf; &omicron;&rho;&iota;&omicron;&theta;έ&tau;&eta;&sigma;&eta;.
title
stringΑνοιχτό καλσόν χωρίς σημάδια
usageinstructions
string
en
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringOpen crotch pantyhose.<br /><br />Demarcation-free.<br /><br />transparent, shiny and open 9cm T-band.<br /><br />Wide hips and thighs.<br /><br />High wearing comfort, perfect fit, flat seam and reinforced toe.<br /><br />20 Denier / 22 DTEX
guid
stringhttps://dev.divasboudoir.com/en/open-back-plus-size-tights-without-demarcation-black-beige-red-ou-white/slti8515.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringPlus size tights open at the crotch and without demarcation.
keywords
string
title
stringOpen-back plus size tights without demarcation
seotitle
stringOpen-back plus size tights without demarcation
seouri
stringopen-back-plus-size-tights-without-demarcation-black-beige-red-ou-white
specifications
string
stylingtips
string
summary
stringPlus size tights open at the crotch and without demarcation.
title
stringOpen pantyhose without demarcation
usageinstructions
string
es
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringPantimedias de entrepierna abierta.<br /><br />Sin demarcaci&oacute;n.<br /><br />tira de 9 cm transparente, brillante y abierta.<br /><br />Caderas y muslos anchos.<br /><br />Gran comodidad de uso, ajuste perfecto, costura plana y puntera reforzada.<br /><br />20 Denier / 22 DTEX
guid
stringhttps://dev.divasboudoir.com/es/tallas-grandes-abiertas-sin-demarcacion-negro-beige-rojo-ou-blanco/slti8515.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringMallas de talla grande con entrepierna abierta y sin demarcación.
keywords
string
title
stringTallas grandes abiertas sin demarcación
seotitle
stringTallas grandes abiertas sin demarcación
seouri
stringtallas-grandes-abiertas-sin-demarcacion-negro-beige-rojo-ou-blanco
specifications
string
stylingtips
string
summary
stringMallas de talla grande con entrepierna abierta y sin demarcaci&oacute;n.
title
stringBraga abierta sin marcas
usageinstructions
string
fr
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>Collant ouvert &agrave; l'entre-jambes.&nbsp;<br><br>Sans d&eacute;marcations.<br><br>transparent, brillant et T-bande de 9cm ouverte.&nbsp;<br><br>Hanches et cuisses bien larges.&nbsp;<br><br>Grand confort de port, coupe parfaite, couture plate et pointe renforc&eacute;es.&nbsp;<br><br>20 Denier / 22 DTEX</p>
guid
stringhttps://dev.divasboudoir.com/fr/collant-grande-taille-ouvert-sans-demarcations-noir-beige-rouge-ou-blanc/slti8515.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringCollant grande taille ouvert à l'entrejambe et sans démarcations.
keywords
string
title
stringCollant grande taille ouvert sans démarcations
seotitle
stringCollant grande taille ouvert sans démarcations
seouri
stringcollant-grande-taille-ouvert-sans-demarcations-noir-beige-rouge-ou-blanc
specifications
string
stylingtips
string
summary
string<p>Collant grande taille ouvert &agrave; l'entrejambe et sans d&eacute;marcations.</p>
title
stringCollant ouvert sans démarcations
usageinstructions
string
it
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringCollant a cavallo aperto.<br /><br />Non demarcante.<br /><br />fascia a T trasparente, lucida e aperta di 9 cm.<br /><br />Fianchi e cosce larghi.<br /><br />Grande comfort, vestibilit&agrave; perfetta, cuciture piatte e punta rinforzata.<br /><br />20 denari / 22 DTEX
guid
stringhttps://dev.divasboudoir.com/it/collant-aperti-di-grande-taglia-senza-demarcazione-nero-beige-rosso-ou-bianco/slti8515.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringCollant di taglia grande con cavallo aperto e senza demarcazione.
keywords
string
title
stringCollant aperti di grande taglia senza demarcazione
seotitle
stringCollant aperti di grande taglia senza demarcazione
seouri
stringcollant-aperti-di-grande-taglia-senza-demarcazione-nero-beige-rosso-ou-bianco
specifications
string
stylingtips
string
summary
stringCollant di taglia grande con cavallo aperto e senza demarcazione.
title
stringCollant aperti senza segni
usageinstructions
string
nl
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringPanty met open kruis.<br /><br />Niet afscheurend.<br /><br />zeere, glanzende en open T-band van 9 cm.<br /><br />Brede heupen en dijen.<br /><br />Geweldig draagcomfort, perfecte pasvorm, platte naad en versterkte teen.<br /><br />20 Denier / 22 DTEX
guid
stringhttps://dev.divasboudoir.com/nl/groote-open-panty-zonder-afbakening-zwart-beige-rood-ou-wit/slti8515.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringGroote maat panty met open kruis en geen afbakening.
keywords
string
title
stringGroote open panty zonder afbakening
seotitle
stringGroote open panty zonder afbakening
seouri
stringgroote-open-panty-zonder-afbakening-zwart-beige-rood-ou-wit
specifications
string
stylingtips
string
summary
stringGroote maat panty met open kruis en geen afbakening.
title
stringOpen panty zonder vlekken
usageinstructions
string
pt
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringMeia-cal&ccedil;a aberta na virilha.<br /><br />N&atilde;o demarc&aacute;veis.<br /><br />faixa em T de 9 cm transparente, brilhante e aberta.<br /><br />Ancas e coxas largas.<br /><br />Grande conforto de utiliza&ccedil;&atilde;o, ajuste perfeito, costura plana e biqueira refor&ccedil;ada.<br /><br />20 Denier / 22 DTEX
guid
stringhttps://dev.divasboudoir.com/pt/collants-largos-e-abertos-sem-demarcacao-preto-bege-vermelho-ou-branco/slti8515.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringCollants de tamanho grande com virilha aberta e sem demarcação.
keywords
string
title
stringCollants largos e abertos sem demarcação
seotitle
stringCollants largos e abertos sem demarcação
seouri
stringcollants-largos-e-abertos-sem-demarcacao-preto-bege-vermelho-ou-branco
specifications
string
stylingtips
string
summary
stringCollants de tamanho grande com virilha aberta e sem demarca&ccedil;&atilde;o.
title
stringMeias-calças abertas sem marcas
usageinstructions
string
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-beige-rot-ou-weiss
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-mpez-kokkino-ou-leyko
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-beige-red-ou-white
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-beige-rojo-ou-blanco
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-beige-rouge-ou-blanc
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-beige-rosso-ou-bianco
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-beige-rood-ou-wit
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-bege-vermelho-ou-branco
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-beige-rot-ou-weiss
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-mpez-kokkino-ou-leyko
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-beige-red-ou-white
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-beige-rojo-ou-blanco
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-beige-rouge-ou-blanc
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-beige-rosso-ou-bianco
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-beige-rood-ou-wit
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-bege-vermelho-ou-branco
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
legsboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string<ul> <li>Handw&auml;sche in kaltem Wasser</li> <li>Nicht auswringen oder schleudern</li> <li>Flach im Schatten trocknen</li> <li>Nicht b&uuml;geln</li> </ul>
description
string<p><strong>Eine Strumpfhose, die Sinnlichkeit und Komfort verbindet</strong>, entwickelt, um sich allen K&ouml;rpertypen anzupassen. Die gl&auml;nzende Transparenz betont Ihre Beine, w&auml;hrend der gro&szlig;z&uuml;gige Schnitt an H&uuml;ften und Oberschenkeln einen au&szlig;ergew&ouml;hnlichen Tragekomfort den ganzen Tag &uuml;ber garantiert.</p>
highlights
string<ul> <li><strong>Im Schritt offen</strong> mit 9cm T-Band</li> <li><strong>Ohne Abzeichnungen</strong> f&uuml;r einen unsichtbaren Effekt</li> <li><strong>Transparent und gl&auml;nzend</strong> 20 Denier</li> <li><strong>Breite H&uuml;ften und Oberschenkel</strong> f&uuml;r optimalen Komfort</li> <li><strong>Flache Naht</strong> und verst&auml;rkte Spitze</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringOffene Strumpfhose in Übergröße, transparent glänzend 20 Denier. Ohne Abzeichnungen, optimaler Komfort. Breite Hüften und Oberschenkel für alle Körpertypen.
keywords
string
title
stringOffene Strumpfhose in Übergröße 20 Denier | Leg's Boudoir
seotitle
stringOffene Strumpfhose in Übergröße - Transparent Glänzend 20 Denier
seouri
stringoffene-strumpfhose-uebergroesse-transparent-glaenzend-20-denier
specifications
string<ul> <li><strong>Material :</strong> 20 Denier / 22 DTEX</li> <li><strong>Finish :</strong> Transparent gl&auml;nzend</li> <li><strong>T-Band :</strong> 9 cm offen</li> <li><strong>Schnitt :</strong> Breite H&uuml;ften und Oberschenkel</li> <li><strong>Merkmale :</strong> Ohne Abzeichnungen, flache Naht, verst&auml;rkte Spitze</li> </ul>
stylingtips
string<p>Perfekt zu einem <strong>kurzen Kleid</strong> oder einem <strong>Bleistiftrock</strong> für einen sinnlichen und raffinierten Look. Ideal für einen intimen Abend oder ein gewagtes Outfit im Alltag.</p> <p><a href="https://www.legsboudoir.com/de/strumpfhosen-grosse-grosse/">Entdecken Sie unsere Kollektion an Strumpfhosen in großen Größen</a></p> <p><a href="https://www.legsboudoir.com/de/selbstfixierende-strumpfe-grosse-grosse/">Entdecken Sie unsere selbstfixierenden Strümpfe</a></p>
summary
string<p><strong>Erleben Sie etwas Einzigartiges</strong> mit dieser &Uuml;bergr&ouml;&szlig;e-Strumpfhose, die gl&auml;nzende Transparenz und absoluten Komfort vereint. Ein <u>gewagtes Accessoire</u>, das Ihre Beine mit Eleganz betont.</p>
title
stringTransparente Glänzende Strumpfhose
usageinstructions
string<p>Diese Strumpfhose l&auml;sst sich dank des gro&szlig;z&uuml;gigen Schnitts an H&uuml;ften und Oberschenkeln leicht anziehen. Die flache Naht und die verst&auml;rkte Spitze garantieren eine au&szlig;ergew&ouml;hnliche Haltbarkeit und optimalen Komfort den ganzen Tag &uuml;ber.</p>
el
Struct
Entries: 14
abstract
string
careinstructions
string<ul> <li>&Pi;&lambda;ύ&sigma;&iota;&mu;&omicron; &sigma;&tau;&omicron; &chi;έ&rho;&iota; &mu;&epsilon; &kappa;&rho;ύ&omicron; &nu;&epsilon;&rho;ό</li> <li>&Mu;&eta;&nu; &sigma;&tau;&rho;ί&beta;&epsilon;&tau;&epsilon; ή &sigma;&tau;ύ&beta;&epsilon;&tau;&epsilon;</li> <li>&Sigma;&tau;&epsilon;&gamma;&nu;ώ&sigma;&tau;&epsilon; &epsilon;&pi;ί&pi;&epsilon;&delta;&alpha; &sigma;&tau;&eta; &sigma;&kappa;&iota;ά</li> <li>&Mu;&eta;&nu; &sigma;&iota;&delta;&epsilon;&rho;ώ&nu;&epsilon;&tau;&epsilon;</li> </ul>
description
string<p><strong>&Mu;&iota;&alpha; &kappa;&alpha;&lambda;&sigma;ό&nu; &pi;&omicron;&upsilon; &sigma;&upsilon;&nu;&delta;&upsilon;ά&zeta;&epsilon;&iota; &alpha;&iota;&sigma;&theta;&eta;&sigma;&iota;&alpha;&kappa;ό&tau;&eta;&tau;&alpha; &kappa;&alpha;&iota; ά&nu;&epsilon;&sigma;&eta;</strong>, &sigma;&chi;&epsilon;&delta;&iota;&alpha;&sigma;&mu;έ&nu;&eta; &nu;&alpha; &pi;&rho;&omicron;&sigma;&alpha;&rho;&mu;ό&zeta;&epsilon;&tau;&alpha;&iota; &sigma;&epsilon; ό&lambda;&omicron;&upsilon;&sigmaf; &tau;&omicron;&upsilon;&sigmaf; &tau;ύ&pi;&omicron;&upsilon;&sigmaf; &sigma;ώ&mu;&alpha;&tau;&omicron;&sigmaf;. &Eta; &delta;&iota;ά&phi;&alpha;&nu;&eta; &lambda;ά&mu;&psi;&eta; &alpha;&nu;&alpha;&delta;&epsilon;&iota;&kappa;&nu;ύ&epsilon;&iota; &tau;&alpha; &pi;ό&delta;&iota;&alpha; &sigma;&alpha;&sigmaf;, &epsilon;&nu;ώ &eta; &gamma;&epsilon;&nu;&nu;&alpha;&iota;ό&delta;&omega;&rho;&eta; &gamma;&rho;&alpha;&mu;&mu;ή &sigma;&tau;&alpha; &gamma;&omicron;&phi;&iota;ά &kappa;&alpha;&iota; &tau;&omicron;&upsilon;&sigmaf; &mu;&eta;&rho;&omicron;ύ&sigmaf; &epsilon;&gamma;&gamma;&upsilon;ά&tau;&alpha;&iota; &epsilon;&xi;&alpha;&iota;&rho;&epsilon;&tau;&iota;&kappa;ή ά&nu;&epsilon;&sigma;&eta; &kappa;&alpha;&theta;' ό&lambda;&eta; &tau;&eta; &delta;&iota;ά&rho;&kappa;&epsilon;&iota;&alpha; &tau;&eta;&sigmaf; &eta;&mu;έ&rho;&alpha;&sigmaf;.</p>
highlights
string<ul> <li><strong>&Alpha;&nu;&omicron;&iota;&chi;&tau;ή &sigma;&tau;&eta;&nu; &pi;&epsilon;&rho;&iota;&omicron;&chi;ή &tau;&omega;&nu; &gamma;&epsilon;&nu;&nu;&eta;&tau;&iota;&kappa;ώ&nu; &omicron;&rho;&gamma;ά&nu;&omega;&nu;</strong> &mu;&epsilon; &lambda;&omega;&rho;ί&delta;&alpha; &Tau; 9cm</li> <li><strong>&Chi;&omega;&rho;ί&sigmaf; &rho;&alpha;&phi;έ&sigmaf;</strong> &gamma;&iota;&alpha; έ&nu;&alpha; &alpha;ό&rho;&alpha;&tau;&omicron; &alpha;&pi;&omicron;&tau;έ&lambda;&epsilon;&sigma;&mu;&alpha;</li> <li><strong>&Delta;&iota;ά&phi;&alpha;&nu;&eta; &kappa;&alpha;&iota; &lambda;&alpha;&mu;&pi;&epsilon;&rho;ή</strong> 20 Denier</li> <li><strong>&Phi;&alpha;&rho;&delta;&iota;ά &gamma;&omicron;&phi;&iota;ά &kappa;&alpha;&iota; &mu;&eta;&rho;&omicron;ί</strong> &gamma;&iota;&alpha; &beta;έ&lambda;&tau;&iota;&sigma;&tau;&eta; ά&nu;&epsilon;&sigma;&eta;</li> <li><strong>&Epsilon;&pi;ί&pi;&epsilon;&delta;&eta; &rho;&alpha;&phi;ή</strong> &kappa;&alpha;&iota; &epsilon;&nu;&iota;&sigma;&chi;&upsilon;&mu;έ&nu;&eta; &mu;ύ&tau;&eta;</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringΑνοιχτή καλσόν μεγάλου μεγέθους, διάφανη λαμπερή 20 Denier. Χωρίς ραφές, βέλτιστη άνεση. Φαρδιά γοφιά και μηροί για όλους τους τύπους σώματος.
keywords
string
title
stringΑνοιχτή Καλσόν Μεγάλου Μεγέθους 20 Denier | Leg's Boudoir
seotitle
stringΑνοιχτή Καλσόν Μεγάλου Μεγέθους - Διάφανη Λαμπερή 20 Denier
seouri
stringanoichti-kalson-megalou-megethous-diafani-lamperi-20-denier
specifications
string<ul> <li><strong>&Upsilon;&lambda;&iota;&kappa;ό :</strong> 20 Denier / 22 DTEX</li> <li><strong>&Phi;&iota;&nu;ί&rho;&iota;&sigma;&mu;&alpha; :</strong> &Delta;&iota;ά&phi;&alpha;&nu;&omicron; &lambda;&alpha;&mu;&pi;&epsilon;&rho;ό</li> <li><strong>&Lambda;&omega;&rho;ί&delta;&alpha; &Tau; :</strong> 9 cm &alpha;&nu;&omicron;&iota;&chi;&tau;ή</li> <li><strong>&Gamma;&rho;&alpha;&mu;&mu;ή :</strong> &Phi;&alpha;&rho;&delta;&iota;ά &gamma;&omicron;&phi;&iota;ά &kappa;&alpha;&iota; &mu;&eta;&rho;&omicron;ί</li> <li><strong>&Chi;&alpha;&rho;&alpha;&kappa;&tau;&eta;&rho;&iota;&sigma;&tau;&iota;&kappa;ά :</strong> &Chi;&omega;&rho;ί&sigmaf; &rho;&alpha;&phi;έ&sigmaf;, &epsilon;&pi;ί&pi;&epsilon;&delta;&eta; &rho;&alpha;&phi;ή, &epsilon;&nu;&iota;&sigma;&chi;&upsilon;&mu;έ&nu;&eta; &mu;ύ&tau;&eta;</li> </ul>
stylingtips
string<p>Ιδανικό με ένα <strong>κοντό φόρεμα</strong> ή μια <strong>pencil φούστα</strong> για μια αισθησιακή, εκλεπτυσμένη εμφάνιση. Ιδανικό για μια οικεία βραδιά ή ένα τολμηρό καθημερινό ντύσιμο.</p> <p><a href="https://www.legsboudoir.com/el/syn-megethos-kalson/">Ανακαλύψτε τη συλλογή καλσόν για μεγάλα μεγέθη</a></p> <p><a href="https://www.legsboudoir.com/el/hold-ups-large/">Εξερευνήστε τα hold ups μας</a></p>
summary
string<p><strong>&Zeta;ή&sigma;&tau;&epsilon; &mu;&iota;&alpha; &mu;&omicron;&nu;&alpha;&delta;&iota;&kappa;ή &epsilon;&mu;&pi;&epsilon;&iota;&rho;ί&alpha;</strong> &mu;&epsilon; &alpha;&upsilon;&tau;ή &tau;&eta;&nu; &kappa;&alpha;&lambda;&sigma;ό&nu; &mu;&epsilon;&gamma;ά&lambda;&omicron;&upsilon; &mu;&epsilon;&gamma;έ&theta;&omicron;&upsilon;&sigmaf; &pi;&omicron;&upsilon; &sigma;&upsilon;&nu;&delta;&upsilon;ά&zeta;&epsilon;&iota; &delta;&iota;ά&phi;&alpha;&nu;&eta; &lambda;ά&mu;&psi;&eta; &kappa;&alpha;&iota; &alpha;&pi;ό&lambda;&upsilon;&tau;&eta; ά&nu;&epsilon;&sigma;&eta;. Έ&nu;&alpha; <u>&tau;&omicron;&lambda;&mu;&eta;&rho;ό &alpha;&xi;&epsilon;&sigma;&omicron;&upsilon;ά&rho;</u> &pi;&omicron;&upsilon; &alpha;&nu;&alpha;&delta;&epsilon;&iota;&kappa;&nu;ύ&epsilon;&iota; &tau;&alpha; &pi;ό&delta;&iota;&alpha; &sigma;&alpha;&sigmaf; &mu;&epsilon; &kappa;&omicron;&mu;&psi;ό&tau;&eta;&tau;&alpha;.</p>
title
stringΔιάφανες Λαμπερές Καλσόν
usageinstructions
string<p>&Alpha;&upsilon;&tau;ή &eta; &kappa;&alpha;&lambda;&sigma;ό&nu; &phi;&omicron;&rho;&iota;έ&tau;&alpha;&iota; &epsilon;ύ&kappa;&omicron;&lambda;&alpha; &chi;ά&rho;&eta; &sigma;&tau;&eta; &gamma;&epsilon;&nu;&nu;&alpha;&iota;ό&delta;&omega;&rho;&eta; &gamma;&rho;&alpha;&mu;&mu;ή &sigma;&tau;&alpha; &gamma;&omicron;&phi;&iota;ά &kappa;&alpha;&iota; &tau;&omicron;&upsilon;&sigmaf; &mu;&eta;&rho;&omicron;ύ&sigmaf;. &Eta; &epsilon;&pi;ί&pi;&epsilon;&delta;&eta; &rho;&alpha;&phi;ή &kappa;&alpha;&iota; &eta; &epsilon;&nu;&iota;&sigma;&chi;&upsilon;&mu;έ&nu;&eta; &mu;ύ&tau;&eta; &epsilon;&gamma;&gamma;&upsilon;ώ&nu;&tau;&alpha;&iota; &epsilon;&xi;&alpha;&iota;&rho;&epsilon;&tau;&iota;&kappa;ή &alpha;&nu;&theta;&epsilon;&kappa;&tau;&iota;&kappa;ό&tau;&eta;&tau;&alpha; &kappa;&alpha;&iota; &beta;έ&lambda;&tau;&iota;&sigma;&tau;&eta; ά&nu;&epsilon;&sigma;&eta; &kappa;&alpha;&theta;' ό&lambda;&eta; &tau;&eta; &delta;&iota;ά&rho;&kappa;&epsilon;&iota;&alpha; &tau;&eta;&sigmaf; &eta;&mu;έ&rho;&alpha;&sigmaf;.</p>
en
Struct
Entries: 14
abstract
string
careinstructions
string<ul> <li>Hand wash in cold water</li> <li>Do not wring or spin</li> <li>Dry flat in the shade</li> <li>Do not iron</li> </ul>
description
string<p><strong>Tights that combine sensuality and comfort</strong>, designed to adapt to all body types. The glossy transparency enhances your legs while the generous fit around hips and thighs guarantees exceptional wearing comfort throughout the day.</p>
highlights
string<ul> <li><strong>Open crotch</strong> with 9cm T-band</li> <li><strong>Seamless appearance</strong> for an invisible effect</li> <li><strong>Transparent and glossy</strong> 20 Denier</li> <li><strong>Wide hips and thighs</strong> for optimal comfort</li> <li><strong>Flat seam</strong> and reinforced toe</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringOpen crotch tights plus size, transparent glossy 20 Denier. Seamless appearance, optimal comfort. Wide hips and thighs for all body types.
keywords
string
title
stringOpen Crotch Tights Plus Size 20 Denier | Leg's Boudoir
seotitle
stringOpen Crotch Tights Plus Size - Transparent Glossy 20 Denier
seouri
stringopen-crotch-tights-plus-size-transparent-glossy-20-denier
specifications
string<ul> <li><strong>Material :</strong> 20 Denier / 22 DTEX</li> <li><strong>Finish :</strong> Transparent glossy</li> <li><strong>T-band :</strong> 9 cm open</li> <li><strong>Fit :</strong> Wide hips and thighs</li> <li><strong>Features :</strong> Seamless appearance, flat seam, reinforced toe</li> </ul>
stylingtips
string<p>Perfect with a <strong>short dress</strong> or <strong>pencil skirt</strong> for a sensual, sophisticated look. Ideal for an intimate evening or bold everyday wear.</p> <p><a href="https://www.legsboudoir.com/en/plus-size-tights/">Discover our plus size tights collection</a></p> <p><a href="https://www.legsboudoir.com/en/hold-ups-plus-size/">Explore our hold-ups</a></p>
summary
string<p><strong>Experience something unique</strong> with these plus size open crotch tights combining glossy transparency and absolute comfort. A <u>daring accessory</u> that enhances your legs with elegance.</p>
title
stringTransparent Glossy Tights
usageinstructions
string<p>These tights slip on easily thanks to the generous fit around hips and thighs. The flat seam and reinforced toe guarantee exceptional durability and optimal comfort all day long.</p>
es
Struct
Entries: 14
abstract
string
careinstructions
string<ul> <li>Lavado a mano en agua fr&iacute;a</li> <li>No retorcer ni centrifugar</li> <li>Secar extendido a la sombra</li> <li>No planchar</li> </ul>
description
string<p><strong>Unas medias que combinan sensualidad y comodidad</strong>, dise&ntilde;adas para adaptarse a todos los tipos de cuerpo. La transparencia brillante resalta tus piernas mientras el corte generoso en caderas y muslos garantiza un confort excepcional durante todo el d&iacute;a.</p>
highlights
string<ul> <li><strong>Abiertas en la entrepierna</strong> con banda T de 9cm</li> <li><strong>Sin marcas</strong> para un efecto invisible</li> <li><strong>Transparentes y brillantes</strong> 20 Denier</li> <li><strong>Caderas y muslos amplios</strong> para un confort &oacute;ptimo</li> <li><strong>Costura plana</strong> y puntera reforzada</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringMedias abiertas talla grande, transparentes brillantes 20 Denier. Sin marcas, confort óptimo. Caderas y muslos amplios para todos los tipos de cuerpo.
keywords
string
title
stringMedias Abiertas Talla Grande 20 Denier | Leg's Boudoir
seotitle
stringMedias Abiertas Talla Grande - Transparentes Brillantes 20 Denier
seouri
stringmedias-abiertas-talla-grande-transparentes-brillantes-20-denier
specifications
string<ul> <li><strong>Material :</strong> 20 Denier / 22 DTEX</li> <li><strong>Acabado :</strong> Transparente brillante</li> <li><strong>Banda T :</strong> 9 cm abierta</li> <li><strong>Corte :</strong> Caderas y muslos amplios</li> <li><strong>Caracter&iacute;sticas :</strong> Sin marcas, costura plana, puntera reforzada</li> </ul>
stylingtips
string<p>Perfecto con un <strong>vestido corto</strong> o una <strong>falda lápiz</strong> para un look sensual y sofisticado. Ideales para una velada íntima o un atrevido conjunto de diario.</p> <p><a href="https://www.legsboudoir.com/es/mallas-de-talla-grande/">Descubre nuestra colección de medias de talla grande</a></p> <p><a href="https://www.legsboudoir.com/es/medias-de-liga-talla-grande/">Explora nuestras medias de sujeción</a></p>
summary
string<p><strong>Vive una experiencia &uacute;nica</strong> con estas medias abiertas de talla grande que combinan transparencia brillante y comodidad absoluta. Un <u>accesorio audaz</u> que realza tus piernas con elegancia.</p>
title
stringMedias Transparentes Brillantes
usageinstructions
string<p>Estas medias se colocan f&aacute;cilmente gracias a su corte generoso en caderas y muslos. La costura plana y la puntera reforzada garantizan una durabilidad excepcional y un confort &oacute;ptimo durante todo el d&iacute;a.</p>
fr
Struct
Entries: 14
abstract
string
careinstructions
string<ul> <li>Lavage &agrave; la main en eau froide</li> <li>Ne pas tordre ni essorer</li> <li>S&eacute;chage &agrave; plat &agrave; l'ombre</li> <li>Ne pas repasser</li> </ul>
description
string<p><strong>Un collant qui allie sensualit&eacute; et confort</strong>, pens&eacute; pour s'adapter &agrave; toutes les morphologies. La transparence brillante met en valeur vos jambes tandis que la coupe large au niveau des hanches et des cuisses garantit un confort de port exceptionnel toute la journ&eacute;e.</p>
highlights
string<ul> <li><strong>Ouvert &agrave; l'entre-jambes</strong> avec T-bande de 9cm</li> <li><strong>Sans d&eacute;marcations</strong> pour un effet invisible</li> <li><strong>Transparent et brillant</strong> 20 Denier</li> <li><strong>Hanches et cuisses larges</strong> pour un confort optimal</li> <li><strong>Couture plate</strong> et pointe renforc&eacute;e</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringCollant ouvert grande taille transparent brillant 20 Denier. Sans démarcations, confort optimal. Hanches et cuisses larges pour toutes les morphologies. Legs Boudoir.
keywords
string
title
stringCollant Ouvert Grande Taille 20 Denier | Leg's Boudoir
seotitle
stringCollant Ouvert Grande Taille - Transparent Brillant 20 Denier
seouri
stringcollant-ouvert-grande-taille-transparent-brillant-20-denier
specifications
string<ul> <li><strong>Mati&egrave;re :</strong> 20 Denier / 22 DTEX</li> <li><strong>Finition :</strong> Transparent brillant</li> <li><strong>T-bande :</strong> 9 cm ouverte</li> <li><strong>Coupe :</strong> Hanches et cuisses larges</li> <li><strong>Caract&eacute;ristiques :</strong> Sans d&eacute;marcations, couture plate, pointe renforc&eacute;e</li> </ul>
stylingtips
string<p>Parfait pour accompagner une <strong>robe courte</strong> ou une <strong>jupe crayon</strong> pour un look sensuel et sophistiqu&eacute;. Id&eacute;al pour une soir&eacute;e intime ou une tenue audacieuse au quotidien.</p> <p><a href="https://www.legsboudoir.com/fr/collants-grande-taille/">D&eacute;couvrez notre collection de collants grande taille</a></p> <p><a href="https://www.legsboudoir.com/fr/bas-autofixants-grande-taille/">Explorez nos bas autofixants</a></p>
summary
string<p><strong>Vivez une exp&eacute;rience unique</strong> avec ce collant ouvert grande taille alliant transparence brillante et confort absolu. Un <u>accessoire audacieux</u> qui sublime vos jambes avec &eacute;l&eacute;gance.</p>
title
stringCollant Ouvert Transparence Brillante
usageinstructions
string<p>Ce collant s'enfile facilement gr&acirc;ce &agrave; sa coupe g&eacute;n&eacute;reuse au niveau des hanches et des cuisses. La couture plate et la pointe renforc&eacute;e garantissent une durabilit&eacute; exceptionnelle et un confort optimal tout au long de la journ&eacute;e.</p>
it
Struct
Entries: 14
abstract
string
careinstructions
string<ul> <li>Lavaggio a mano in acqua fredda</li> <li>Non strizzare n&eacute; centrifugare</li> <li>Asciugare stesi all'ombra</li> <li>Non stirare</li> </ul>
description
string<p><strong>Un collant che unisce sensualit&agrave; e comfort</strong>, progettato per adattarsi a tutti i tipi di corpo. La trasparenza lucente valorizza le tue gambe, mentre il taglio generoso su fianchi e cosce garantisce un comfort eccezionale durante l'intera giornata.</p>
highlights
string<ul> <li><strong>Aperti nell'entrejambe</strong> con fascia T da 9cm</li> <li><strong>Senza segni</strong> per un effetto invisibile</li> <li><strong>Trasparenti e lucenti</strong> 20 Denier</li> <li><strong>Fianchi e cosce larghe</strong> per un comfort ottimale</li> <li><strong>Cucitura piatta</strong> e punta rinforzata</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringCollant aperti taglie forti, trasparenti lucenti 20 Denier. Senza segni, comfort ottimale. Fianchi e cosce larghe per tutti i tipi di corpo.
keywords
string
title
stringCollant Aperti Taglie Forti 20 Denier | Leg's Boudoir
seotitle
stringCollant Aperti Taglie Forti - Trasparenti Lucenti 20 Denier
seouri
stringcollant-aperti-taglie-forti-trasparenti-lucenti-20-denier
specifications
string<ul> <li><strong>Materiale :</strong> 20 Denier / 22 DTEX</li> <li><strong>Finitura :</strong> Trasparente lucente</li> <li><strong>Fascia T :</strong> 9 cm aperta</li> <li><strong>Taglio :</strong> Fianchi e cosce larghe</li> <li><strong>Caratteristiche :</strong> Senza segni, cucitura piatta, punta rinforzata</li> </ul>
stylingtips
string<p>Perfetto con un <strong>abito corto</strong> o una <strong>gonna a tubino</strong> per un look sensuale e sofisticato. Ideale per una serata intima o per un outfit audace da tutti i giorni.</p> <p><a href="https://www.legsboudoir.com/it/collant-taglia-grande/">Scopri la nostra collezione di collant taglia grande</a></p> <p><a href="https://www.legsboudoir.com/it/calze-autoreggenti-di-taglia-grande/">Esplora le nostre autoreggenti</a></p>
summary
string<p><strong>Vivi un'esperienza unica</strong> con questi collant taglie forti che combinano trasparenza lucente e comfort assoluto. Un <u>accessorio audace</u> che esalta le tue gambe con eleganza.</p>
title
stringCollant Trasparenti Lucenti
usageinstructions
string<p>Questi collant si indossano facilmente grazie al taglio generoso su fianchi e cosce. La cucitura piatta e la punta rinforzata garantiscono una durata eccezionale e un comfort ottimale per tutta la giornata.</p>
nl
Struct
Entries: 14
abstract
string
careinstructions
string<ul> <li>Handwas in koud water</li> <li>Niet wringen of centrifugeren</li> <li>Liggend in de schaduw laten drogen</li> <li>Niet strijken</li> </ul>
description
string<p><strong>Een panty die sensualiteit en comfort combineert</strong>, ontworpen om zich aan te passen aan alle lichaamstypes. De glanzende transparantie benadrukt je benen terwijl de ruime pasvorm rond heupen en dijen een uitzonderlijk draagcomfort garandeert.</p>
highlights
string<ul> <li><strong>Open kruis</strong> met 9cm T-string</li> <li><strong>Zonder zichtbare lijnen</strong> voor een onzichtbaar effect</li> <li><strong>Transparant en glanzend</strong> 20 Denier</li> <li><strong>Brede heupen en dijen</strong> voor optimaal comfort</li> <li><strong>Platte naad</strong> en versterkte teen</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringOpen kruis panty grote maat, transparant glanzend 20 Denier. Zonder zichtbare lijnen, optimaal comfort. Brede heupen en dijen voor alle lichaamstypes.
keywords
string
title
stringOpen Kruis Panty Grote Maat 20 Denier | Leg's Boudoir
seotitle
stringOpen Kruis Panty in Grote Maat - Transparant Glanzend 20 Denier
seouri
stringopen-kruis-panty-grote-maat-transparant-glanzend-20-denier
specifications
string<ul> <li><strong>Materiaal :</strong> 20 Denier / 22 DTEX</li> <li><strong>Afwerking :</strong> Transparant glanzend</li> <li><strong>T-string :</strong> 9 cm open</li> <li><strong>Pasvorm :</strong> Brede heupen en dijen</li> <li><strong>Kenmerken :</strong> Zonder zichtbare lijnen, platte naad, versterkte teen</li> </ul>
stylingtips
string<p>Perfect met een <strong>korte jurk</strong> of <strong>kokerrok</strong> voor een sensuele, geraffineerde look. Ideaal voor een intieme avond of een gewaagde alledaagse outfit.</p> <p><a href="https://www.legsboudoir.com/nl/grote-maten-pantys/">Ontdek onze grote maten panty's</a></p> <p><a href="https://www.legsboudoir.com/nl/hold-ups-grote-maten/">Ontdek onze hold-ups</a></p>
summary
string<p><strong>Beleef een unieke ervaring</strong> met deze open kruis panty in grote maat, die transparantie en glans combineert met ultiem comfort. Een <u>gedurfd accessoire</u> dat je benen verfraait met elegantie.</p>
title
stringDoorschijnende Glanzende Panty
usageinstructions
string<p>Deze panty glijdt moeiteloos op dankzij de ruime pasvorm rond heupen en dijen. De platte naad en versterkte teen garanderen een uitzonderlijke duurzaamheid en optimaal comfort gedurende de hele dag.</p>
pt
Struct
Entries: 14
abstract
string
careinstructions
string<ul> <li>Lavar &agrave; m&atilde;o em &aacute;gua fria</li> <li>N&atilde;o torcer nem centrifugar</li> <li>Secar deitada &agrave; sombra</li> <li>N&atilde;o passar a ferro</li> </ul>
description
string<p><strong>Uma meia-cal&ccedil;a que une sensualidade e conforto</strong>, projetada para se adaptar a todos os tipos de corpo. A transpar&ecirc;ncia brilhante destaca suas pernas, enquanto o corte generoso nos quadris e coxas garante um conforto excepcional durante todo o dia.</p>
highlights
string<ul> <li><strong>Aberta na virilha</strong> com tira T de 9cm</li> <li><strong>Sem marca&ccedil;&otilde;es</strong> para um efeito invis&iacute;vel</li> <li><strong>Transparente e brilhante</strong> 20 Denier</li> <li><strong>Quadris e coxas largas</strong> para conforto m&aacute;ximo</li> <li><strong>Costura plana</strong> e refor&ccedil;o na ponta</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringMeia-calça aberta plus size, transparente brilhante 20 Denier. Sem marcações, conforto máximo. Quadris e coxas largos para todos os tipos de corpo.
keywords
string
title
stringMeia-Calça Aberta Plus Size 20 Denier | Leg's Boudoir
seotitle
stringMeia-Calça Aberta Plus Size - Transparente Brilhante 20 Denier
seouri
stringmeia-calca-aberta-plus-size-transparente-brilhante-20-denier
specifications
string<ul> <li><strong>Material :</strong> 20 Denier / 22 DTEX</li> <li><strong>Acabamento :</strong> Transparente brilhante</li> <li><strong>Tira T :</strong> 9 cm aberta</li> <li><strong>Corte :</strong> Quadris e coxas largos</li> <li><strong>Caracter&iacute;sticas :</strong> Sem marca&ccedil;&otilde;es, costura plana, refor&ccedil;o na ponta</li> </ul>
stylingtips
string<p>Perfeito com um <strong>vestido curto</strong> ou uma <strong>saia lápis</strong> para um look sensual e sofisticado. Ideal para uma noite íntima ou para um look quotidiano ousado.</p> <p><a href="https://www.legsboudoir.com/pt/collants-plus-size/">Descubra a nossa coleção de collants plus size</a></p> <p><a href="https://www.legsboudoir.com/pt/meias-de-liga-tamanho-grande/">Explore os nossos hold ups</a></p>
summary
string<p><strong>Viva uma experi&ecirc;ncia &uacute;nica</strong> com esta meia-cal&ccedil;a plus size que combina transpar&ecirc;ncia brilhante e conforto absoluto. Um <u>acess&oacute;rio ousado</u> que real&ccedil;a suas pernas com eleg&acirc;ncia.</p>
title
stringMeia-Calça Transparente Brilhante
usageinstructions
string<p>Esta meia-cal&ccedil;a desliza facilmente gra&ccedil;as ao corte generoso nos quadris e coxas. A costura plana e o refor&ccedil;o na ponta garantem durabilidade excepcional e conforto m&aacute;ximo durante todo o dia.</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-beige-rot-ou-weiss
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-mpez-kokkino-ou-leyko
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-beige-red-ou-white
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-beige-rojo-ou-blanco
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-beige-rouge-ou-blanc
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-beige-rosso-ou-bianco
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-beige-rood-ou-wit
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-bege-vermelho-ou-branco
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-beige-rot-ou-weiss
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-mpez-kokkino-ou-leyko
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-beige-red-ou-white
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-beige-rojo-ou-blanco
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-beige-rouge-ou-blanc
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-beige-rosso-ou-bianco
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-beige-rood-ou-wit
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-bege-vermelho-ou-branco
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
name
string50129 collants ouvert 20 unicolor
netweight
string
nextshipment
stringtomorrow
ordered
number0
orderidx
number0
origin
stringeu
originalsize
string
packaging
string
productshipment
stringauto
productuid
stringA0288747-8A14-4809-AEC7E079453D88CA
promountil
string
rating
stringnone
recorduid
stringA0288747-8A14-4809-AEC7E079453D88CA
reference
stringSLTI8515
related
string
reserved
string
returned
number0
returnsallowed
number1
section
stringlingerie
shipment
string4to6days
showbrand
number0
sizeinfos
Query
Template: /system/api/product/sizes.cfc:20
Execution Time: 2.31 ms
Record Count: 20
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,'2130,1046,1047,1048,1050') > 0
and product_variations.productuid = 'A0288747-8A14-4809-AEC7E079453D88CA'
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
1213038-40intlsizered3840-19999990wpluslingerieM38-4038-408-1012-1440-4240-4238-4044-4640-4238-40
2213038-40intlsizeblack3840-19999990wpluslingerieM38-4038-408-1012-1440-4240-4238-4044-4640-4238-40
3213038-40intlsizewhite3840-19999990wpluslingerieM38-4038-408-1012-1440-4240-4238-4044-4640-4238-40
4213038-40intlsizebeige3840-19999990wpluslingerieM38-4038-408-1012-1440-4240-4238-4044-4640-4238-40
5104642-44intlsizered4244-19999990wpluslingerieL42-4442-4412-1416-1844-4644-4642-4448-5042-4442-44
6104642-44intlsizeblack4244-19999990wpluslingerieL42-4442-4412-1416-1844-4644-4642-4448-5042-4442-44
7104642-44intlsizewhite4244-19999990wpluslingerieL42-4442-4412-1416-1844-4644-4642-4448-5042-4442-44
8104642-44intlsizebeige4244-19999990wpluslingerieL42-4442-4412-1416-1844-4644-4642-4448-5042-4442-44
9104746-48intlsizewhite4648-19999990wpluslingerieXL46-4846-4816-1820-2248-5048-5046-4852-5448-5046-48
10104746-48intlsizebeige4648-19999990wpluslingerieXL46-4846-4816-1820-2248-5048-5046-4852-5448-5046-48
11104746-48intlsizered4648-19999990wpluslingerieXL46-4846-4816-1820-2248-5048-5046-4852-5448-5046-48
12104746-48intlsizeblack4648-19999990wpluslingerieXL46-4846-4816-1820-2248-5048-5046-4852-5448-5046-48
13104850-52intlsizered5052-19999990wpluslingerie2XL50-5250-5220-2224-2652-5452-5450-5256-5852-5450-52
14104850-52intlsizeblack5052-19999990wpluslingerie2XL50-5250-5220-2224-2652-5452-5450-5256-5852-5450-52
15104850-52intlsizewhite5052-19999990wpluslingerie2XL50-5250-5220-2224-2652-5452-5450-5256-5852-5450-52
16104850-52intlsizebeige5052-19999990wpluslingerie2XL50-5250-5220-2224-2652-5452-5450-5256-5852-5450-52
17105056-58intlsizewhite5658-19999990wpluslingerie4XL56-5856-5826-2830-3258-6058-6056-5862-6458-6056-58
18105056-58intlsizebeige5658-19999990wpluslingerie4XL56-5856-5826-2830-3258-6058-6056-5862-6458-6056-58
19105056-58intlsizered5658-19999990wpluslingerie4XL56-5856-5826-2830-3258-6058-6056-5862-6458-6056-58
20105056-58intlsizeblack5658-19999990wpluslingerie4XL56-5856-5826-2830-3258-6058-6056-5862-6458-6056-58
sizeranges
stringplus
sizes
string2130,1046,1047,1048,1050
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: 52.4 ms
Record Count: 20
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 = 'A0288747-8A14-4809-AEC7E079453D88CA'
and product_variations.isactive = 1
and product_sizes.id_size = 2130
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 = 'A0288747-8A14-4809-AEC7E079453D88CA'
and product_variations.isactive = 1
and product_sizes.id_size = 1046
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 = 'A0288747-8A14-4809-AEC7E079453D88CA'
and product_variations.isactive = 1
and product_sizes.id_size = 1047
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 = 'A0288747-8A14-4809-AEC7E079453D88CA'
and product_variations.isactive = 1
and product_sizes.id_size = 1048
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 = 'A0288747-8A14-4809-AEC7E079453D88CA'
and product_variations.isactive = 1
and product_sizes.id_size = 1050
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
1A0288747-8A14-4809-AEC7E079453D88CAD0EDF1CD-1619-4D55-BC4EDDC760A08ED22130beige#F6DBACM38-4038-408-1012-1440-4240-4238-4044-4640-4238-40wlingerie38-40intlsize16.6250STOCK01000-10000-10all
2A0288747-8A14-4809-AEC7E079453D88CA96222A60-C9E5-49F9-8C96E3B8C43BBC3D2130black#000000M38-4038-408-1012-1440-4240-4238-4044-4640-4238-40wlingerie38-40intlsize16.6250STOCK01000-10000-10all
3A0288747-8A14-4809-AEC7E079453D88CA23A57CBD-0FB1-4C51-82350482CD9A375E2130red#F50000M38-4038-408-1012-1440-4240-4238-4044-4640-4238-40wlingerie38-40intlsize16.6250STOCK01000-10000-10all
4A0288747-8A14-4809-AEC7E079453D88CAD87236F1-C48B-419E-B706EBA0344734812130white#FFFFFFM38-4038-408-1012-1440-4240-4238-4044-4640-4238-40wlingerie38-40intlsize16.6250STOCK01000-10000-10all
5A0288747-8A14-4809-AEC7E079453D88CA5077322A-E2D2-49D8-9F6E212F0AD3D7371046beige#F6DBACL42-4442-4412-1416-1844-4644-4642-4448-5042-4442-44wlingerie42-44intlsize16.6250STOCK01000-10000-10all
6A0288747-8A14-4809-AEC7E079453D88CAF5773C3C-519D-4F48-93946F09C204A62B1046black#000000L42-4442-4412-1416-1844-4644-4642-4448-5042-4442-44wlingerie42-44intlsize16.6250STOCK01000-10000-10all
7A0288747-8A14-4809-AEC7E079453D88CA3763BE5B-30F2-470C-840FDA6DE0D5EC631046red#F50000L42-4442-4412-1416-1844-4644-4642-4448-5042-4442-44wlingerie42-44intlsize16.6250STOCK01000-10000-10all
8A0288747-8A14-4809-AEC7E079453D88CA49A50E3B-F3C8-4DAA-B695C9D0B78ABA821046white#FFFFFFL42-4442-4412-1416-1844-4644-4642-4448-5042-4442-44wlingerie42-44intlsize16.6250STOCK01000-10000-10all
9A0288747-8A14-4809-AEC7E079453D88CA3FE2ACD7-B024-4174-8D1C23E749C44AEB1047beige#F6DBACXL46-4846-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie46-48intlsize16.6250STOCK01000-10000-10all
10A0288747-8A14-4809-AEC7E079453D88CA48124200-5278-43AE-877F704891C7A2571047black#000000XL46-4846-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie46-48intlsize16.6250STOCK01000-10000-10all
11A0288747-8A14-4809-AEC7E079453D88CA209CA9F3-11BE-4A7D-A7B15A148E4FF5071047red#F50000XL46-4846-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie46-48intlsize16.6250STOCK01000-10000-10all
12A0288747-8A14-4809-AEC7E079453D88CA52A0F554-A846-4504-97EEDE3759CC6B021047white#FFFFFFXL46-4846-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie46-48intlsize16.6250STOCK01000-10000-10all
13A0288747-8A14-4809-AEC7E079453D88CA164FA8DA-97D8-4AF3-9B57664D7ECE12AA1048beige#F6DBAC2XL50-5250-5220-2224-2652-5452-5450-5256-5852-5450-52wlingerie50-52intlsize16.6250STOCK01000-10000-10all
14A0288747-8A14-4809-AEC7E079453D88CA60EE4118-19A6-4DD1-80193546AE671BB21048black#0000002XL50-5250-5220-2224-2652-5452-5450-5256-5852-5450-52wlingerie50-52intlsize16.6250STOCK01000-11000-10all
15A0288747-8A14-4809-AEC7E079453D88CA8AE335F3-9EFD-4184-B52CCE27DB30F1561048red#F500002XL50-5250-5220-2224-2652-5452-5450-5256-5852-5450-52wlingerie50-52intlsize16.6250STOCK01000-10000-10all
16A0288747-8A14-4809-AEC7E079453D88CA99A9F747-5DC2-4A4C-987FD4CB34B06CF11048white#FFFFFF2XL50-5250-5220-2224-2652-5452-5450-5256-5852-5450-52wlingerie50-52intlsize16.6250STOCK01000-10000-10all
17A0288747-8A14-4809-AEC7E079453D88CAA30BB010-6CF5-44AB-B4DCEA669A19E8691050beige#F6DBAC4XL56-5856-5826-2830-3258-6058-6056-5862-6458-6056-58wlingerie56-58intlsize16.6250STOCK01000-10000-10all
18A0288747-8A14-4809-AEC7E079453D88CA17B253E7-1A4D-43C4-9EE7F963907CDFF51050black#0000004XL56-5856-5826-2830-3258-6058-6056-5862-6458-6056-58wlingerie56-58intlsize16.6250STOCK01000-10000-10all
19A0288747-8A14-4809-AEC7E079453D88CA1240672A-CA07-47FF-B8B81FB5018427FA1050red#F500004XL56-5856-5826-2830-3258-6058-6056-5862-6458-6056-58wlingerie56-58intlsize16.6250STOCK01000-11000-10all
20A0288747-8A14-4809-AEC7E079453D88CA3E391378-E154-4032-AF291CF8ADC5E2021050white#FFFFFF4XL56-5856-5826-2830-3258-6058-6056-5862-6458-6056-58wlingerie56-58intlsize16.6250STOCK01000-10000-10all
subcategory
stringcrotchless
supplier
number-1
supplierreference
string50129
tags
string
themes
stringchristmas
totalvariations
string
type
stringdefault
unitprice
number16.625
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 15 ms
Record Count: 20
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 = 'A0288747-8A14-4809-AEC7E079453D88CA' 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 = 'A0288747-8A14-4809-AEC7E079453D88CA' 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 = 'A0288747-8A14-4809-AEC7E079453D88CA' 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 = 'A0288747-8A14-4809-AEC7E079453D88CA' 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 = 'A0288747-8A14-4809-AEC7E079453D88CA' 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 = 'A0288747-8A14-4809-AEC7E079453D88CA' 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 = 'A0288747-8A14-4809-AEC7E079453D88CA'
and product_variations.isactive = 1
and product_sizes.id_size = 2130
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 = 'A0288747-8A14-4809-AEC7E079453D88CA' 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 = 'A0288747-8A14-4809-AEC7E079453D88CA' 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 = 'A0288747-8A14-4809-AEC7E079453D88CA' 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 = 'A0288747-8A14-4809-AEC7E079453D88CA' 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 = 'A0288747-8A14-4809-AEC7E079453D88CA' 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 = 'A0288747-8A14-4809-AEC7E079453D88CA' 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 = 'A0288747-8A14-4809-AEC7E079453D88CA'
and product_variations.isactive = 1
and product_sizes.id_size = 1046
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 = 'A0288747-8A14-4809-AEC7E079453D88CA' 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 = 'A0288747-8A14-4809-AEC7E079453D88CA' 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 = 'A0288747-8A14-4809-AEC7E079453D88CA' 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 = 'A0288747-8A14-4809-AEC7E079453D88CA' 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 = 'A0288747-8A14-4809-AEC7E079453D88CA' 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 = 'A0288747-8A14-4809-AEC7E079453D88CA' 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 = 'A0288747-8A14-4809-AEC7E079453D88CA'
and product_variations.isactive = 1
and product_sizes.id_size = 1047
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 = 'A0288747-8A14-4809-AEC7E079453D88CA' 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 = 'A0288747-8A14-4809-AEC7E079453D88CA' 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 = 'A0288747-8A14-4809-AEC7E079453D88CA' 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 = 'A0288747-8A14-4809-AEC7E079453D88CA' 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 = 'A0288747-8A14-4809-AEC7E079453D88CA' 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 = 'A0288747-8A14-4809-AEC7E079453D88CA' 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 = 'A0288747-8A14-4809-AEC7E079453D88CA'
and product_variations.isactive = 1
and product_sizes.id_size = 1048
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 = 'A0288747-8A14-4809-AEC7E079453D88CA' 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 = 'A0288747-8A14-4809-AEC7E079453D88CA' 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 = 'A0288747-8A14-4809-AEC7E079453D88CA' 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 = 'A0288747-8A14-4809-AEC7E079453D88CA' 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 = 'A0288747-8A14-4809-AEC7E079453D88CA' 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 = 'A0288747-8A14-4809-AEC7E079453D88CA' 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 = 'A0288747-8A14-4809-AEC7E079453D88CA'
and product_variations.isactive = 1
and product_sizes.id_size = 1050
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
1D0EDF1CD-1619-4D55-BC4EDDC760A08ED22130beige#F6DBACM38-4038-408-1012-1440-4240-4238-4044-4640-4238-40wlingerie38-40intlsize16.6250STOCK01000-10000-10-10-10016.625all
296222A60-C9E5-49F9-8C96E3B8C43BBC3D2130black#000000M38-4038-408-1012-1440-4240-4238-4044-4640-4238-40wlingerie38-40intlsize16.6250STOCK01000-10000-10-10-10016.625all
323A57CBD-0FB1-4C51-82350482CD9A375E2130red#F50000M38-4038-408-1012-1440-4240-4238-4044-4640-4238-40wlingerie38-40intlsize16.6250STOCK01000-10000-10-10-10016.625all
4D87236F1-C48B-419E-B706EBA0344734812130white#FFFFFFM38-4038-408-1012-1440-4240-4238-4044-4640-4238-40wlingerie38-40intlsize16.6250STOCK01000-10000-10-10-10016.625all
55077322A-E2D2-49D8-9F6E212F0AD3D7371046beige#F6DBACL42-4442-4412-1416-1844-4644-4642-4448-5042-4442-44wlingerie42-44intlsize16.6250STOCK01000-10000-10-10-10016.625all
6F5773C3C-519D-4F48-93946F09C204A62B1046black#000000L42-4442-4412-1416-1844-4644-4642-4448-5042-4442-44wlingerie42-44intlsize16.6250STOCK01000-10000-10-10-10016.625all
73763BE5B-30F2-470C-840FDA6DE0D5EC631046red#F50000L42-4442-4412-1416-1844-4644-4642-4448-5042-4442-44wlingerie42-44intlsize16.6250STOCK01000-10000-10-10-10016.625all
849A50E3B-F3C8-4DAA-B695C9D0B78ABA821046white#FFFFFFL42-4442-4412-1416-1844-4644-4642-4448-5042-4442-44wlingerie42-44intlsize16.6250STOCK01000-10000-10-10-10016.625all
93FE2ACD7-B024-4174-8D1C23E749C44AEB1047beige#F6DBACXL46-4846-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie46-48intlsize16.6250STOCK01000-10000-10-10-10016.625all
1048124200-5278-43AE-877F704891C7A2571047black#000000XL46-4846-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie46-48intlsize16.6250STOCK01000-10000-10-10-10016.625all
11209CA9F3-11BE-4A7D-A7B15A148E4FF5071047red#F50000XL46-4846-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie46-48intlsize16.6250STOCK01000-10000-10-10-10016.625all
1252A0F554-A846-4504-97EEDE3759CC6B021047white#FFFFFFXL46-4846-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie46-48intlsize16.6250STOCK01000-10000-10-10-10016.625all
13164FA8DA-97D8-4AF3-9B57664D7ECE12AA1048beige#F6DBAC2XL50-5250-5220-2224-2652-5452-5450-5256-5852-5450-52wlingerie50-52intlsize16.6250STOCK01000-10000-10-10-10016.625all
1460EE4118-19A6-4DD1-80193546AE671BB21048black#0000002XL50-5250-5220-2224-2652-5452-5450-5256-5852-5450-52wlingerie50-52intlsize16.6250STOCK01000-11000-10-10-10016.625all
158AE335F3-9EFD-4184-B52CCE27DB30F1561048red#F500002XL50-5250-5220-2224-2652-5452-5450-5256-5852-5450-52wlingerie50-52intlsize16.6250STOCK01000-10000-10-10-10016.625all
1699A9F747-5DC2-4A4C-987FD4CB34B06CF11048white#FFFFFF2XL50-5250-5220-2224-2652-5452-5450-5256-5852-5450-52wlingerie50-52intlsize16.6250STOCK01000-10000-10-10-10016.625all
17A30BB010-6CF5-44AB-B4DCEA669A19E8691050beige#F6DBAC4XL56-5856-5826-2830-3258-6058-6056-5862-6458-6056-58wlingerie56-58intlsize16.6250STOCK01000-10000-10-10-10016.625all
1817B253E7-1A4D-43C4-9EE7F963907CDFF51050black#0000004XL56-5856-5826-2830-3258-6058-6056-5862-6458-6056-58wlingerie56-58intlsize16.6250STOCK01000-10000-10-10-10016.625all
191240672A-CA07-47FF-B8B81FB5018427FA1050red#F500004XL56-5856-5826-2830-3258-6058-6056-5862-6458-6056-58wlingerie56-58intlsize16.6250STOCK01000-11000-10-10-10016.625all
203E391378-E154-4032-AF291CF8ADC5E2021050white#FFFFFF4XL56-5856-5826-2830-3258-6058-6056-5862-6458-6056-58wlingerie56-58intlsize16.6250STOCK01000-10000-10-10-10016.625all
vatrate
number20
warehouse
string