My cart

❌
Total items
View basket
Menu
See sizes
Dana hold ups
Double-click to enlarge
SKU: SLAU6896
Dana hold ups
Stock:

Mischievous, very sturdy and of excellent quality, don't be afraid to show off these superb plus size stockings under your clothes.

Size:

Not sure which size to choose? See our size guide

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

Stockings plus size Autofixants Dana

Product description

Dana hold-ups are made in the USA from a very strong, comfortable mesh.

Their wide garters grip the thighs perfectly and won't roll down (check your size).

They can also be worn as knee-high socks, just above the knee, for a super-sexy look with a shorter dress or skirt.

Line texture.

Technical details

Available sizes

Available from 4-5 to 8-9

Available color

Black

Sizing guide

Check the right size for you

International
  • Thigh
4-5
  • 55-63
6-7
  • 63-76
8-9
  • 75-90
To Top
View basket
Items
Total items
Struct
Entries: 108
actions
Array
available
number-1
brand
stringkixies
brandcode
stringkbvy
branding
stringdivasboudoir,smboudoir,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
stringKixies
breasts
stringna
careinstructions
string
categories
stringdivasboudoir.lingerie.hoisery.stocking
category
stringhoisery
categorygender
stringf
categorymediadatas
Struct
adult
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string628
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/lingerie/hoisery/stockings.jpg
type
stringimg
width
string1365
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.724 ms
Record Count: 1
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_colors.color as recorduid, product_colors.type, product_colors.code, product_colors.color, product_colors.range, product_colors.hexvalue,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock
from product_colors
left outer join product_variations on product_colors.color = product_variations.color and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
where FIND_IN_SET(product_colors.color,'black') > 0
and product_variations.productuid = '715FBABF-42FC-40B0-86A430026CAB2A53'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1blackcolorblakblackblack#000000-10
colorrange
stringblack
colors
stringblack
colortype
stringcolor
comments
string
compositions
Struct
Entries: 13
coton
string
elastane
string
free
string
leather
string
lycra
string
metal
string
nylon
string
polyamide
string
polyester
string
polyurethane
string
silk
string
spandex
string
viscose
string
datecreated
Date Time (Europe/Paris)
{ts '2021-09-22 11:36:09'}
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
booleanfalse
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
number0
isfirstprice
number0
isfixedprice
number0
ishot
number0
isnew
number0
isonline
number0
isoutletprice
number0
itemprice
number20.7917
itempromo
string
key
stringkixies-dana-lynn1303d
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-08-02 18:23:37'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.626 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('715fbabf-42fc-40b0-86a430026cab2a53',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.31 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 <> 'SLAU6896'
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
string5616
isprivate
string0
rating
stringall
src
string/photobank/products/kbvy/slau6896/bas-aufofixants-grande-taille-noirs-deux.jpg
type
stringimg
width
string3744
back
Struct
height
string1350
isprivate
string0
rating
stringall
src
string/photobank/products/kbvy/slau6896/1303-4plus_900x.jpg
type
stringimg
width
string900
default
Struct
height
string797
isprivate
string0
rating
stringall
src
string/photobank/products/kbvy/slau6896/1303gala2_900x.jpg
type
stringimg
width
string551
variations
Struct
colors
Struct
black
Struct
height
string1800
isprivate
string0
rating
stringall
src
string/photobank/products/kbvy/slau6896/48c4a25889b225d1c6ab696a5685ad72156dd09845e5964a291fd274dcb44a03.png
type
stringimg
width
string1800
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-kixies-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
divasboudoir
Struct
de
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringDie selbstfixierenden Dana Strümpfe werden in den USA hergestellt und bestehen aus einem sehr festen und angenehm zu tragenden Netz.<br /><br />Ihre breiten Strumpfhalter liegen perfekt an den Oberschenkeln an und rollen nicht (überprüfen Sie Ihre Größe).<br /><br />Sie können auch als hohe Socken getragen werden, knapp über dem Knie, für einen hypersexy Look mit einem Kleid oder einem kürzeren Rock.<br /><br />Linienförmige Textur.
guid
stringhttps://dev.divasboudoir.com/de/strumpfe-grosse-grosse-autofixants-dana-kixies-schwarz/slau6896.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringVerspielt, sehr robust und von sehr guter Qualität. Haben Sie keine Angst, diese tollen Strümpfe in Übergröße unter Ihrer Kleidung zu zeigen.
keywords
string
title
stringStrümpfe große Größe Autofixants Dana
seotitle
stringStrümpfe große Größe Autofixants Dana
seouri
stringstrumpfe-grosse-grosse-autofixants-dana-kixies-schwarz
specifications
string
stylingtips
string
summary
stringVerspielt, sehr robust und von sehr guter Qualität. Haben Sie keine Angst, diese tollen Strümpfe in Übergröße unter Ihrer Kleidung zu zeigen.
title
stringSelbstbindende Strümpfe Dana
usageinstructions
string
el
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringΤα hold-ups Dana κατασκευάζονται στις ΗΠΑ από πολύ ισχυρή, άνετη πλεκτή ύλη.<br /><br />Οι φαρδιές καλτσοδέτες τους πιάνουν τέλεια τους μηρούς και δεν θα κυλήσουν προς τα κάτω (ελέγξτε το μέγεθός σας).<br /><br />Μπορούν επίσης να φορεθούν ως κάλτσες μέχρι το γόνατο, ακριβώς πάνω από το γόνατο, για μια σούπερ σέξι εμφάνιση με ένα κοντότερο φόρεμα ή φούστα.<br /><br />Υφή γραμμής.
guid
stringhttps://dev.divasboudoir.com/el/megalo-megethos-hold-ups-dana-kixies-mayro/slau6896.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringΑταίριαστες, πολύ δυνατές και εξαιρετικής ποιότητας, μη φοβηθείτε να αναδείξετε αυτές τις υπέροχες κάλτσες plus-size κάτω από τα ρούχα σας.
keywords
string
title
stringΜεγάλο μέγεθος hold ups Dana
seotitle
stringΜεγάλο μέγεθος hold ups Dana
seouri
stringmegalo-megethos-hold-ups-dana-kixies-mayro
specifications
string
stylingtips
string
summary
stringΑταίριαστες, πολύ δυνατές και εξαιρετικής ποιότητας, μη φοβηθείτε να αναδείξετε αυτές τις υπέροχες κάλτσες plus-size κάτω από τα ρούχα σας.
title
stringDana hold ups
usageinstructions
string
en
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringDana hold-ups are made in the USA from a very strong, comfortable mesh.<br /><br />Their wide garters grip the thighs perfectly and won't roll down (check your size).<br /><br />They can also be worn as knee-high socks, just above the knee, for a super-sexy look with a shorter dress or skirt.<br /><br />Line texture.
guid
stringhttps://dev.divasboudoir.com/en/stockings-plus-size-autofixants-dana-kixies-black/slau6896.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringMischievous, very sturdy and of excellent quality, don't be afraid to show off these superb plus size stockings under your clothes.
keywords
string
title
stringStockings plus size Autofixants Dana
seotitle
stringStockings plus size Autofixants Dana
seouri
stringstockings-plus-size-autofixants-dana-kixies-black
specifications
string
stylingtips
string
summary
stringMischievous, very sturdy and of excellent quality, don't be afraid to show off these superb plus size stockings under your clothes.
title
stringDana hold ups
usageinstructions
string
es
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringLas ligas Dana están fabricadas en EE.UU. con un tejido de punto muy resistente y cómodo.<br /><br />Sus anchas ligas se agarran perfectamente a los muslos y no se enrollan (comprueba tu talla).<br /><br />También se pueden llevar como medias hasta la rodilla, justo por encima de la rodilla, para un look supersexy con un vestido o una falda más cortos.<br /><br />Textura de la línea.
guid
stringhttps://dev.divasboudoir.com/es/medias-de-talla-grande-dana-kixies-negro/slau6896.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringTraviesas, muy resistentes y de gran calidad, no temas lucir estas magníficas medias de talla grande bajo tu ropa.
keywords
string
title
stringMedias de talla grande Dana
seotitle
stringMedias de talla grande Dana
seouri
stringmedias-de-talla-grande-dana-kixies-negro
specifications
string
stylingtips
string
summary
stringTraviesas, muy resistentes y de gran calidad, no temas lucir estas magníficas medias de talla grande bajo tu ropa.
title
stringMedias Dana
usageinstructions
string
fr
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringLes bas autofixants Dana sont fabriqu&eacute;s aux Etats-Unis dans une maille tr&egrave;s solide et agr&eacute;able &agrave; porter.<br /><br />Leurs jarreti&egrave;res bien larges s'agrippent parfaitement aux cuisses et ne roulent pas (v&eacute;rifiez bien votre taille).&nbsp;<br /><br />Ils peuvent &eacute;galement se porter comme des chaussettes hautes, juste au dessus du genoux, pour un look hyper sexy avec une robe ou une jupe plus courte.&nbsp;<br /><br />Texture lign&eacute;e.
guid
stringhttps://dev.divasboudoir.com/fr/bas-grande-taille-autofixants-dana-kixies-noir/slau6896.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringEspiègles, très solides et de très belle qualité, n'ayez pas peur de montrer ces superbes bas grande taille sous vos vêtements.
keywords
string
title
stringBas grande taille Autofixants Dana
seotitle
stringBas grande taille Autofixants Dana
seouri
stringbas-grande-taille-autofixants-dana-kixies-noir
specifications
string
stylingtips
string
summary
stringEspi&egrave;gles, tr&egrave;s solides et de tr&egrave;s belle qualit&eacute;, n'ayez pas peur de montrer ces superbes bas grande taille sous vos v&ecirc;tements.
title
stringBas Autofixants Dana
usageinstructions
string
it
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringLe calze autoreggenti Dana sono realizzate negli Stati Uniti con una maglia molto resistente e confortevole.<br /><br />Le loro ampie giarrettiere aderiscono perfettamente alle cosce e non si abbassano (controllate la vostra taglia).<br /><br />Possono essere indossate anche come calze alte, appena sopra il ginocchio, per un look super-sexy con un abito o una gonna più corti.<br /><br />Struttura della linea.
guid
stringhttps://dev.divasboudoir.com/it/taglia-grande-dana-kixies-nero/slau6896.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringMaliziose, molto resistenti e di grande qualità, non abbiate paura di sfoggiare queste superbe calze taglia grande sotto i vostri vestiti.
keywords
string
title
stringTaglia grande Dana
seotitle
stringTaglia grande Dana
seouri
stringtaglia-grande-dana-kixies-nero
specifications
string
stylingtips
string
summary
stringMaliziose, molto resistenti e di grande qualità, non abbiate paura di sfoggiare queste superbe calze taglia grande sotto i vostri vestiti.
title
stringDana si ferma
usageinstructions
string
nl
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringDana hold-ups zijn gemaakt in de VS van een zeer sterk, comfortabel breisel.<br /><br />De brede kousenbanden hebben een perfecte grip op de dijen en rollen niet af (controleer je maat).<br /><br />Ze kunnen ook gedragen worden als kniehoge sokken, net boven de knie, voor een supersexy look bij een kortere jurk of rok.<br /><br />Lijntextuur.
guid
stringhttps://dev.divasboudoir.com/nl/groote-maten-dana-kixies-zwart/slau6896.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringOndeugend, zeer sterk en van geweldige kwaliteit, wees niet bang om te pronken met deze prachtige kousen van groote maat onder je kleding.
keywords
string
title
stringGroote maten Dana
seotitle
stringGroote maten Dana
seouri
stringgroote-maten-dana-kixies-zwart
specifications
string
stylingtips
string
summary
stringOndeugend, zeer sterk en van geweldige kwaliteit, wees niet bang om te pronken met deze prachtige kousen van groote maat onder je kleding.
title
stringDana hold-ups
usageinstructions
string
pt
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringAs ligas Dana são fabricadas nos EUA a partir de uma malha muito resistente e confortável.<br /><br />As suas ligas largas agarram-se perfeitamente às coxas e não se enrolam (verifique o seu tamanho).<br /><br />Também podem ser usadas como meias até ao joelho, mesmo acima do joelho, para um look super-sexy com um vestido ou saia mais curtos.<br /><br />Textura da linha.
guid
stringhttps://dev.divasboudoir.com/pt/tamanho-grande-dana-kixies-preto/slau6896.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringTravessas, muito resistentes e de grande qualidade, não tenha medo de exibir estas magníficas meias de tamanho grande por baixo da roupa.
keywords
string
title
stringTamanho grande Dana
seotitle
stringTamanho grande Dana
seouri
stringtamanho-grande-dana-kixies-preto
specifications
string
stylingtips
string
summary
stringTravessas, muito resistentes e de grande qualidade, não tenha medo de exibir estas magníficas meias de tamanho grande por baixo da roupa.
title
stringDana hold ups
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-kixies-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
latexboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
legsboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Erliegen Sie dem amerikanischen Charme der Dana-Strümpfe.</p> <p>Die Strümpfe werden in den USA aus einem festen, angenehm zu tragenden Netzstoff hergestellt und bieten Ihnen einen hohen Tragekomfort und eine lange Lebensdauer.</p> <p>Die breiten Strumpfbänder liegen eng an Ihren Schenkeln an, ohne zu rollen (achten Sie auf Ihre Größe, um einen optimalen Sitz zu gewährleisten).</p> <p>Tragen Sie sie als klassische selbstfixierende Strümpfe oder wagen Sie einen gewagteren Look, indem Sie sie bis knapp über das Knie hochziehen.</p> <p>Ihre linierte Textur verleiht Ihrem Outfit einen Hauch von Originalität.</p>
highlights
string
keypoint
string
keywords
stringselbstfixierende Strümpfe, feste Maschenware, hergestellt in den USA, Dessous, Damenstrümpfe, elegante Beine, breite Strumpfbänder, linierte Textur, Legs Boudoir
metas
Struct
description
stringEntdecken Sie die Dana Strümpfe, die in den USA hergestellt werden und für außergewöhnlichen Komfort und Haltbarkeit stehen. Finden Sie den Stil, der zu Ihnen passt, auf Legs Boudoir.
keywords
stringselbstfixierende Strümpfe, feste Maschenware, hergestellt in den USA, Dessous, Damenstrümpfe, elegante Beine, breite Strumpfbänder, linierte Textur, Legs Boudoir
title
stringDana Selbstfixierende Strümpfe Solid Mesh Curvy | Legs Boudoir
seotitle
stringselbstfixierende Strümpfe dana festes Netz große Größe
seouri
stringselbstfixierende-strumpfe-dana-festes-netz-grosse-grosse-kixies-schwarz
specifications
string
stylingtips
string
summary
string<p>Komfort und Vielseitigkeit: Selbstfixierende Dana-Strümpfe, ein festes Netz und ein anpassungsfähiger Stil für alle Ihre Wünsche.</p>
title
stringDana: Eleganz, die sich Ihren Wünschen anpasst
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Αφεθείτε στην αμερικανική γοητεία των καλσόν Dana.</p> <p>Φτιαγμένα στις ΗΠΑ από ισχυρή, άνετη πλέξη, εγγυώνται εξαιρετική άνεση και ανθεκτικότητα.</p> <p>Οι φαρδιές καλτσοδέτες τους προσκολλώνται τέλεια στους μηρούς σας χωρίς να κυλούν (ελέγξτε το μέγεθός σας για βέλτιστη στήριξη!).</p> <p>Φορέστε τα ως κλασικά hold-ups ή επιλέξτε μια πιο τολμηρή εμφάνιση τραβώντας τα λίγο πάνω από το γόνατο.</p> <p>Η φόδρα τους προσθέτει μια πινελιά πρωτοτυπίας στο ντύσιμό σας.</p>
highlights
string
keypoint
string
keywords
stringhold ups, συμπαγές πλεκτό, made in the usa, εσώρουχα, γυναικεία hold ups, κομψά πόδια, φαρδιές καλτσοδέτες, υφή γραμμής, Legs Boudoir
metas
Struct
description
stringΑνακαλύψτε τις κάλτσες Dana, κατασκευασμένες στις ΗΠΑ για εξαιρετική άνεση και ανθεκτικότητα. Βρείτε το στυλ που σας ταιριάζει στο Legs Boudoir.
keywords
stringhold ups, συμπαγές πλεκτό, made in the usa, εσώρουχα, γυναικεία hold ups, κομψά πόδια, φαρδιές καλτσοδέτες, υφή γραμμής, Legs Boudoir
title
stringDana Solid Mesh Curvy καλσόν | Legs Boudoir
seotitle
stringdana στερεά πλέγμα hold ups μεγάλο
seouri
stringdana-sterea-plegma-hold-ups-megalo-kixies-mayro
specifications
string
stylingtips
string
summary
string<p>Άνεση και ευελιξία: Dana hold-ups, ισχυρή πλέξη και προσαρμόσιμο στυλ για να ταιριάζει σε κάθε σας ιδιοτροπία.</p>
title
stringDana: Κομψότητα που προσαρμόζεται στις επιθυμίες σας
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Succumb to the American charm of Dana stockings.</p> <p>Made in the U.S.A. from sturdy, wearable knit fabric, they guarantee exceptional comfort and durability.</p> <p>Their wide garters cling perfectly to your thighs without rolling (check your size for optimum support!).</p> <p>Wear them as classic hold-ups, or dare a bolder look by pulling them up just above the knee.</p> <p>Their lined texture adds a touch of originality to your outfit.</p>
highlights
string
keypoint
string
keywords
stringhold ups, solid knit, made in usa, lingerie, women's stockings, elegant legs, wide garters, line texture, Legs Boudoir
metas
Struct
description
stringDiscover Dana stockings, made in the USA for exceptional comfort and durability. Find the style that's right for you at Legs Boudoir.
keywords
stringhold ups, solid knit, made in usa, lingerie, women's stockings, elegant legs, wide garters, line texture, Legs Boudoir
title
stringStay-ups Dana Maille Solide Curvy | Legs Boudoir
seotitle
stringdana solid mesh hold ups plus size
seouri
stringdana-solid-mesh-hold-ups-plus-size-kixies-black
specifications
string
stylingtips
string
summary
string<p>Comfort and versatility: Dana hold-ups, a solid knit and adaptable style for all your desires.</p>
title
stringDana: Elegance that adapts to your desires
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Déjate seducir por el encanto americano de las medias Dana.</p> <p>Fabricadas en EE.UU. con un tejido de punto resistente y cómodo, garantizan una comodidad y una durabilidad excepcionales.</p> <p>Sus anchos ligueros se ajustan perfectamente a tus muslos sin enrollarse (¡comprueba tu talla para una sujeción óptima!).</p> <p>Llévalos como los clásicos ligueros, o con un look más atrevido subiéndolos justo por encima de la rodilla.</p> <p>Su textura forrada añade un toque de originalidad a tu conjunto.</p>
highlights
string
keypoint
string
keywords
stringmedias, punto sólido, made in usa, lencería, medias para mujer, piernas elegantes, ligueros anchos, textura de líneas, Legs Boudoir
metas
Struct
description
stringDescubre las medias Dana, fabricadas en EE.UU. para una comodidad y durabilidad excepcionales. Encuentra el estilo más adecuado para ti en Legs Boudoir.
keywords
stringmedias, punto sólido, made in usa, lencería, medias para mujer, piernas elegantes, ligueros anchos, textura de líneas, Legs Boudoir
title
stringDana Solid Mesh Curvy Hosiery | Legs Boudoir
seotitle
stringdana solid mesh hold ups talla grande
seouri
stringdana-solid-mesh-hold-ups-talla-grande-kixies-negro
specifications
string
stylingtips
string
summary
string<p>Comodidad y versatilidad: medias Dana, un punto resistente y un estilo adaptable a todos tus caprichos.</p>
title
stringDana: Elegancia que se adapta a sus deseos
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Succombez au charme am&eacute;ricain des bas Dana.</p> <p>Fabriqu&eacute;s aux &Eacute;tats-Unis dans une maille solide et agr&eacute;able &agrave; porter, ils vous garantissent un confort et une durabilit&eacute; exceptionnels.</p> <p>Leurs larges jarreti&egrave;res s'agrippent parfaitement &agrave; vos cuisses sans rouler (v&eacute;rifiez bien votre taille pour un maintien optimal !).</p> <p>Portez-les comme des bas autofixants classiques, ou osez un look plus audacieux en les remontant juste au-dessus du genou.</p> <p>Leur texture lign&eacute;e apporte une touche d'originalit&eacute; &agrave; votre tenue.</p>
highlights
string
keypoint
string
keywords
stringbas autofixants, maille solide, fabriqués aux etats unis, lingerie, bas femme, jambes élégantes, jarretières larges, texture lignée, Legs Boudoir
metas
Struct
description
stringDécouvrez les bas Dana, fabriqués aux États-Unis pour un confort et une durabilité exceptionnels. Trouvez le style qui vous correspond sur Legs Boudoir.
keywords
stringbas autofixants, maille solide, fabriqués aux etats unis, lingerie, bas femme, jambes élégantes, jarretières larges, texture lignée, Legs Boudoir
title
stringBas Autofixants Dana Maille Solide Curvy | Legs Boudoir
seotitle
stringbas autofixants dana maille solide grande taille
seouri
stringbas-autofixants-dana-maille-solide-grande-taille-kixies-noir
specifications
string
stylingtips
string
summary
string<p>Confort et polyvalence : bas autofixants Dana, une maille solide et un style adaptable pour toutes vos envies.</p>
title
stringDana : L'Élégance Qui S'Adapte à Vos Envies
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Lasciatevi conquistare dal fascino americano delle calze Dana.</p> <p>Realizzate negli Stati Uniti con una maglia robusta e confortevole, garantiscono un comfort e una durata eccezionali.</p> <p>I loro ampi reggicalze aderiscono perfettamente alle cosce senza arrotolarsi (controllate la vostra taglia per un sostegno ottimale!).</p> <p>Indossateli come classiche calze autoreggenti o per un look più audace tirateli su appena sopra il ginocchio.</p> <p>La loro texture foderata aggiunge un tocco di originalità al vostro abbigliamento.</p>
highlights
string
keypoint
string
keywords
stringautoreggenti, maglia unita, made in usa, lingerie, autoreggenti da donna, gambe eleganti, giarrettiere larghe, struttura della linea, Legs Boudoir
metas
Struct
description
stringScoprite le calze Dana, realizzate negli Stati Uniti per un comfort e una durata eccezionali. Trova lo stile più adatto a te su Legs Boudoir.
keywords
stringautoreggenti, maglia unita, made in usa, lingerie, autoreggenti da donna, gambe eleganti, giarrettiere larghe, struttura della linea, Legs Boudoir
title
stringDana Solid Mesh Curvy Hosiery | Legs Boudoir
seotitle
stringdana solid mesh hold up taglia grande
seouri
stringdana-solid-mesh-hold-up-taglia-grande-kixies-nero
specifications
string
stylingtips
string
summary
string<p>Comfort e versatilità: autoreggenti Dana, maglia robusta e stile adattabile per ogni esigenza.</p>
title
stringDana: un'eleganza che si adatta ai vostri desideri
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Val voor de Amerikaanse charme van Dana kousen.</p> <p>Gemaakt in de VS van een sterk, comfortabel breisel, staan ze garant voor uitzonderlijk comfort en duurzaamheid.</p> <p>De brede kousenbanden sluiten perfect aan op je dijen zonder te rollen (controleer je maat voor optimale ondersteuning!).</p> <p>Draag ze als klassieke hold-ups of ga voor een meer gedurfde look door ze net boven de knie op te trekken.</p> <p>Hun gevoerde textuur voegt een vleugje originaliteit toe aan je outfit.</p>
highlights
string
keypoint
string
keywords
stringhold ups, stevig breisel, made in the usa, lingerie, dames hold ups, elegante benen, brede kousenbanden, lijntextuur, Legs Boudoir
metas
Struct
description
stringOntdek Dana kousen, gemaakt in de VS voor uitzonderlijk comfort en duurzaamheid. Vind de stijl die bij jou past op Legs Boudoir.
keywords
stringhold ups, stevig breisel, made in the usa, lingerie, dames hold ups, elegante benen, brede kousenbanden, lijntextuur, Legs Boudoir
title
stringDana Massief Mesh Curvy Kousen | Benen Boudoir
seotitle
stringdana stevig gaas hold ups grote maat
seouri
stringdana-stevig-gaas-hold-ups-grote-maat-kixies-zwart
specifications
string
stylingtips
string
summary
string<p>Comfort en veelzijdigheid: Dana hold-ups, een sterk breisel en een aanpasbare stijl die bij elke gril past.</p>
title
stringDana: Elegantie die zich aanpast aan je wensen
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Apaixone-se pelo charme americano das meias Dana.</p> <p>Fabricadas nos Estados Unidos a partir de uma malha forte e confortável, garantem um conforto e uma durabilidade excepcionais.</p> <p>As suas ligas largas agarram-se perfeitamente às coxas sem enrolar (verifique o seu tamanho para um apoio ótimo!).</p> <p>Use-as como as clássicas calças de cintura subida, ou opte por um look mais ousado, puxando-as para cima, mesmo acima do joelho.</p> <p>A sua textura forrada confere um toque de originalidade ao seu conjunto.</p>
highlights
string
keypoint
string
keywords
stringcintas de fixação, malha sólida, fabricadas nos EUA, lingerie, cintas de fixação para mulher, pernas elegantes, ligas largas, textura de linha, Legs Boudoir
metas
Struct
description
stringDescubra as meias Dana, fabricadas nos EUA para um conforto e durabilidade excepcionais. Encontre o estilo certo para si em Legs Boudoir.
keywords
stringcintas de fixação, malha sólida, fabricadas nos EUA, lingerie, cintas de fixação para mulher, pernas elegantes, ligas largas, textura de linha, Legs Boudoir
title
stringMeias Dana Solid Mesh Curvy | Legs Boudoir
seotitle
stringdana solid mesh hold ups large
seouri
stringdana-solid-mesh-hold-ups-large-kixies-preto
specifications
string
stylingtips
string
summary
string<p>Conforto e versatilidade: as molas Dana, uma malha forte e um estilo adaptável para se adaptar a todos os seus caprichos.</p>
title
stringDana: Elegância que se adapta aos seus desejos
usageinstructions
string
lustboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
smboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringDie in den USA hergestellten Dana-Strümpfe bestehen aus einem sehr festen und angenehm zu tragenden Netz.<br /><br />Ihre breiten Strumpfbänder liegen perfekt an den Oberschenkeln an und rollen nicht (überprüfen Sie Ihre Größe).<br /><br />Sie können auch als hohe Socken getragen werden, knapp über dem Knie, für einen hypersexy Look mit einem Kleid oder einem kürzeren Rock.<br /><br />Die Textur ist liniert.<br /><br />Sie können auch mit Ihrem Lieblingsstrapsgürtel getragen werden.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringVerspielt, sehr robust und von sehr guter Qualität. Haben Sie keine Angst, diese tollen Strümpfe unter Ihrer Kleidung zu zeigen.
keywords
string
title
stringBas Dana
seotitle
stringBas Dana
seouri
stringbas-dana-kixies-schwarz
specifications
string
stylingtips
string
summary
stringVerspielt, sehr robust und von sehr guter Qualität. Haben Sie keine Angst, diese tollen Strümpfe unter Ihrer Kleidung zu zeigen.
title
stringBas Dana
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringΟι κάλτσες Dana είναι κατασκευασμένες στις ΗΠΑ από ένα πολύ ισχυρό, άνετο πλεκτό.<br /><br />Οι φαρδιές καλτσοδέτες τους πιάνουν τέλεια τους μηρούς και δεν θα κυλήσουν προς τα κάτω (ελέγξτε το μέγεθός σας).<br /><br />Μπορούν επίσης να φορεθούν ως κάλτσες μέχρι το γόνατο, ακριβώς πάνω από το γόνατο, για μια σούπερ σέξι εμφάνιση με ένα κοντότερο φόρεμα ή φούστα.<br /><br />Υφή με ραβδώσεις.<br /><br />Μπορείτε επίσης να τις φορέσετε με την αγαπημένη σας ζώνη καλτσοδέτας.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringΑταίριαστες, πολύ δυνατές και εξαιρετικής ποιότητας, μη φοβηθείτε να αναδείξετε αυτές τις υπέροχες κάλτσες κάτω από τα ρούχα σας.
keywords
string
title
stringBas Dana
seotitle
stringBas Dana
seouri
stringbas-dana-kixies-mayro
specifications
string
stylingtips
string
summary
stringΑταίριαστες, πολύ δυνατές και εξαιρετικής ποιότητας, μη φοβηθείτε να αναδείξετε αυτές τις υπέροχες κάλτσες κάτω από τα ρούχα σας.
title
stringBas Dana
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringDana stockings are made in the USA from a very strong, comfortable knit.<br /><br />Their wide garters grip the thighs perfectly and won't roll down (check your size).<br /><br />They can also be worn as knee-high socks, just above the knee, for a super-sexy look with a shorter dress or skirt.<br /><br />Ruched texture.<br /><br />You can also wear them with your favorite garter belt.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringMischievous, very strong and of excellent quality, don't be afraid to show off these superb stockings under your clothes.
keywords
string
title
stringBas Dana
seotitle
stringBas Dana
seouri
stringbas-dana-kixies-black
specifications
string
stylingtips
string
summary
stringMischievous, very strong and of excellent quality, don't be afraid to show off these superb stockings under your clothes.
title
stringBas Dana
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringLas medias Dana están fabricadas en EE.UU. con un tejido de punto muy resistente y cómodo.<br /><br />Sus anchas ligas se agarran perfectamente a los muslos y no se enrollan (comprueba tu talla).<br /><br />También se pueden llevar como medias hasta la rodilla, justo por encima de la rodilla, para un look supersexy con un vestido o una falda más cortos.<br /><br />Textura fruncida.<br /><br />También puedes llevarlas con tu liguero favorito.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringTraviesas, muy resistentes y de gran calidad, no temas lucir estas magníficas medias bajo tu ropa.
keywords
string
title
stringBas Dana
seotitle
stringBas Dana
seouri
stringbas-dana-kixies-negro
specifications
string
stylingtips
string
summary
stringTraviesas, muy resistentes y de gran calidad, no temas lucir estas magníficas medias bajo tu ropa.
title
stringBas Dana
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Les bas Dana sont fabriqu&eacute;s aux Etats-Unis sont fabriqu&eacute;s dans une maille tr&egrave;s solide et agr&eacute;able &agrave; porter.<br><br>Leurs jarreti&egrave;res bien larges s'agrippent parfaitement aux cuisses et ne roulent pas (v&eacute;rifiez bien votre taille).&nbsp;<br><br>Ils peuvent &eacute;galement se porter comme des chaussettes hautes, juste au dessus du genoux, pour un look hyper sexy avec une robe ou une jupe plus courte.&nbsp;<br><br>Texture lign&eacute;e.<br><br>Vous pourrez &eacute;galement porter avec votre porte-jarretelles pr&eacute;f&eacute;r&eacute;.</p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringEspiègles, très solides et de très belle qualité, n'ayez pas peur de montrer ces superbes bas sous vos vêtements.
keywords
string
title
stringBas Dana
seotitle
stringBas Dana
seouri
stringbas-dana-kixies-noir
specifications
string
stylingtips
string
summary
string<p>Espi&egrave;gles, tr&egrave;s solides et de tr&egrave;s belle qualit&eacute;, n'ayez pas peur de montrer ces superbes bas sous vos v&ecirc;tements.</p>
title
stringBas Dana
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringLe calze Dana sono realizzate negli Stati Uniti con una maglia molto resistente e confortevole.<br /><br />I loro ampi reggicalze aderiscono perfettamente alle cosce e non si abbassano (controllate la vostra taglia).<br /><br />Possono essere indossate anche come calze alte, appena sopra il ginocchio, per un look super-sexy con un abito o una gonna più corti.<br /><br />Struttura increspata.<br /><br />Potete anche indossarli con il vostro reggicalze preferito.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringMaliziose, molto resistenti e di grande qualità, non abbiate paura di sfoggiare queste superbe calze sotto i vostri vestiti.
keywords
string
title
stringBas Dana
seotitle
stringBas Dana
seouri
stringbas-dana-kixies-nero
specifications
string
stylingtips
string
summary
stringMaliziose, molto resistenti e di grande qualità, non abbiate paura di sfoggiare queste superbe calze sotto i vostri vestiti.
title
stringBas Dana
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringDana kousen zijn gemaakt in de VS van een zeer sterk, comfortabel breisel.<br /><br />Hun brede kousenbanden grijpen perfect aan op de dijen en rollen niet af (controleer je maat).<br /><br />Ze kunnen ook gedragen worden als kniehoge kousen, net boven de knie, voor een supersexy look bij een kortere jurk of rok.<br /><br />Gerimpelde textuur.<br /><br />Je kunt ze ook dragen met je favoriete jarretelgordel.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringOndeugend, zeer sterk en van geweldige kwaliteit, wees niet bang om met deze prachtige kousen onder je kleding te pronken.
keywords
string
title
stringBas Dana
seotitle
stringBas Dana
seouri
stringbas-dana-kixies-zwart
specifications
string
stylingtips
string
summary
stringOndeugend, zeer sterk en van geweldige kwaliteit, wees niet bang om met deze prachtige kousen onder je kleding te pronken.
title
stringBas Dana
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringAs meias Dana são fabricadas nos EUA a partir de uma malha muito resistente e confortável.<br /><br />As suas ligas largas agarram-se perfeitamente às coxas e não se enrolam (verifique o seu tamanho).<br /><br />Também podem ser usadas como meias até ao joelho, mesmo acima do joelho, para um look super-sexy com um vestido ou saia mais curtos.<br /><br />Textura com rufos.<br /><br />Também pode usá-las com o seu cinto de ligas preferido.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringTravessas, muito resistentes e de grande qualidade, não tenha medo de mostrar estas meias soberbas por baixo da roupa.
keywords
string
title
stringBas Dana
seotitle
stringBas Dana
seouri
stringbas-dana-kixies-preto
specifications
string
stylingtips
string
summary
stringTravessas, muito resistentes e de grande qualidade, não tenha medo de mostrar estas meias soberbas por baixo da roupa.
title
stringBas Dana
usageinstructions
string
name
stringKixies Dana-Lynn1303d
netweight
string
nextshipment
stringtomorrow
ordered
number19
orderidx
number0
origin
string
originalsize
string
packaging
string
productshipment
stringauto
productuid
string715FBABF-42FC-40B0-86A430026CAB2A53
promountil
string
rating
stringnone
recorduid
string715FBABF-42FC-40B0-86A430026CAB2A53
reference
stringSLAU6896
related
string
reserved
string
returned
number0
returnsallowed
number1
section
stringlingerie
shipment
string3to5days
showbrand
number1
sizeinfos
Query
Template: /system/api/product/sizes.cfc:20
Execution Time: 1.28 ms
Record Count: 3
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,'1583,1584,1585,2109') > 0
and product_variations.productuid = '715FBABF-42FC-40B0-86A430026CAB2A53'
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
115834-5intlsizeblack45-19999990wplusstockingB4-54-54-54-54-54-54-54-54-54-555-63
215846-7intlsizeblack67-19999990wplusstockingC6-76-76-76-76-76-76-76-76-76-763-76
315858-9intlsizeblack89-19999990wplusstockingD8-98-98-98-98-98-98-98-98-98-975-90
sizeranges
stringplus,standard
sizes
string1583,1584,1585,2109
sizetype
stringintlsize
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: 4.74 ms
Record Count: 3
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 = '715FBABF-42FC-40B0-86A430026CAB2A53'
and product_variations.isactive = 1
and product_sizes.id_size = 1583
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 = '715FBABF-42FC-40B0-86A430026CAB2A53'
and product_variations.isactive = 1
and product_sizes.id_size = 1584
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 = '715FBABF-42FC-40B0-86A430026CAB2A53'
and product_variations.isactive = 1
and product_sizes.id_size = 1585
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 = '715FBABF-42FC-40B0-86A430026CAB2A53'
and product_variations.isactive = 1
and product_sizes.id_size = 2109
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
1715FBABF-42FC-40B0-86A430026CAB2A53A9A9FAAA-DA43-49D3-BAB0C063921E4D751583black#000000B4-54-54-54-54-54-54-54-54-54-5wstocking4-5intlsize20.79170STOCK01000-102001303B852531004091-10all
2715FBABF-42FC-40B0-86A430026CAB2A539D5B3039-6936-408E-977EBE74F1AFCF811584black#000000C6-76-76-76-76-76-76-76-76-76-7wstocking6-7intlsize20.79170STOCK01000-1010001303C852531004107-10all
3715FBABF-42FC-40B0-86A430026CAB2A5316054B1F-E1CB-4A3A-8998F424C5CC3EA31585black#000000D8-98-98-98-98-98-98-98-98-98-9wstocking8-9intlsize20.79170STOCK01000-127001303852531004114-10all
subcategory
stringstocking
supplier
number-1
supplierreference
string1303D
tags
string
themes
string
totalvariations
string
type
stringdefault
unitprice
number20.7917
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 6.89 ms
Record Count: 3
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 = '715FBABF-42FC-40B0-86A430026CAB2A53' 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 = '715FBABF-42FC-40B0-86A430026CAB2A53' 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 = '715FBABF-42FC-40B0-86A430026CAB2A53' 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 = '715FBABF-42FC-40B0-86A430026CAB2A53' 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 = '715FBABF-42FC-40B0-86A430026CAB2A53' 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 = '715FBABF-42FC-40B0-86A430026CAB2A53' 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 = '715FBABF-42FC-40B0-86A430026CAB2A53'
and product_variations.isactive = 1
and product_sizes.id_size = 1583
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 = '715FBABF-42FC-40B0-86A430026CAB2A53' 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 = '715FBABF-42FC-40B0-86A430026CAB2A53' 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 = '715FBABF-42FC-40B0-86A430026CAB2A53' 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 = '715FBABF-42FC-40B0-86A430026CAB2A53' 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 = '715FBABF-42FC-40B0-86A430026CAB2A53' 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 = '715FBABF-42FC-40B0-86A430026CAB2A53' 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 = '715FBABF-42FC-40B0-86A430026CAB2A53'
and product_variations.isactive = 1
and product_sizes.id_size = 1584
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 = '715FBABF-42FC-40B0-86A430026CAB2A53' 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 = '715FBABF-42FC-40B0-86A430026CAB2A53' 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 = '715FBABF-42FC-40B0-86A430026CAB2A53' 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 = '715FBABF-42FC-40B0-86A430026CAB2A53' 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 = '715FBABF-42FC-40B0-86A430026CAB2A53' 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 = '715FBABF-42FC-40B0-86A430026CAB2A53' 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 = '715FBABF-42FC-40B0-86A430026CAB2A53'
and product_variations.isactive = 1
and product_sizes.id_size = 1585
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 = '715FBABF-42FC-40B0-86A430026CAB2A53' 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 = '715FBABF-42FC-40B0-86A430026CAB2A53' 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 = '715FBABF-42FC-40B0-86A430026CAB2A53' 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 = '715FBABF-42FC-40B0-86A430026CAB2A53' 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 = '715FBABF-42FC-40B0-86A430026CAB2A53' 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 = '715FBABF-42FC-40B0-86A430026CAB2A53' 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 = '715FBABF-42FC-40B0-86A430026CAB2A53'
and product_variations.isactive = 1
and product_sizes.id_size = 2109
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
1A9A9FAAA-DA43-49D3-BAB0C063921E4D751583black#000000B4-54-54-54-54-54-54-54-54-54-5wstocking4-5intlsize20.79170STOCK01000-102001303B852531004091-10-10-10020.7917all
29D5B3039-6936-408E-977EBE74F1AFCF811584black#000000C6-76-76-76-76-76-76-76-76-76-7wstocking6-7intlsize20.79170STOCK01000-1010001303C852531004107-10-10-10020.7917all
316054B1F-E1CB-4A3A-8998F424C5CC3EA31585black#000000D8-98-98-98-98-98-98-98-98-98-9wstocking8-9intlsize20.79170STOCK01000-127001303852531004114-10-10-10020.7917all
vatrate
number20
warehouse
string