My cart

❌
Total items
View basket
Menu
See sizes
Dotty hold ups
Double-click to enlarge
SKU: SLAU4244
Dotty hold ups
MADE IN
Stock:

Cute and glamorous plus size hold-ups with polka dots.

Size:

Not sure which size to choose? See our size guide

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

Dotty self-tie stockings plus size

Product description

Dotty hold-ups

sheer, matte and silky.

Polka Dot pattern

Double silicone band.

Highly elastic for comfort.

Reinforced toes.

30DEN/33DTEX

Technical details

Available sizes

Available from 4 to 9

Available color

Black

Composition

Polyamide 88 %
Elastane 12 %

Sizing guide

Check the right size for you

International
  • Thigh
4
  • 49-55
5
  • 56-62
6
  • 62-69
7
  • 69-76
8
  • 76-83
9
  • 83-89
To Top
View basket
Items
Total items
Struct
Entries: 108
actions
Array
available
number-1
brand
stringglamory
brandcode
stringgjjm
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
stringGlamory
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.797 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 = '35EF9B32-B387-4241-A0C3FDC32B11D032'
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
string12
free
string
leather
string
lycra
string
metal
string
nylon
string
polyamide
string88
polyester
string
polyurethane
string
silk
string
spandex
string
viscose
string
datecreated
Date Time (Europe/Paris)
{ts '2020-09-17 13:07:32'}
defect
number0
dimensions
Struct
Entries: 14
acrylicbones
string
backsideheight
string
diameter
string
flatsteelbones
string
frontsideheight
string
fullheight
string
length
string
modestysize
string
panels
string
sides
string
spiralsteelbones
string
totallength
string
unit
stringcm
wiresize
string
display
stringall
displayfrom
string
displayto
string
grossweight
string
hasbrandinfos
booleanfalse
hascareinstructions
booleanfalse
hascolorinfos
booleantrue
hascompositions
booleantrue
hasdescription
booleantrue
hasdimensions
booleanfalse
hasmaterials
booleanfalse
hasotherspecifications
booleanfalse
haspromo
number0
hasshortdescription
booleantrue
hassizeinfos
booleantrue
hasspecifications
booleanfalse
hasstockinfos
booleanfalse
hasstylingtips
booleanfalse
hasusageinstructions
booleanfalse
hasvariations
booleantrue
import
string
inpromo
number0
instockvariations
string
isactive
number1
iscustommade
number0
isdivasize
number1
isfirstprice
number0
isfixedprice
number0
ishot
number0
isnew
number0
isonline
number0
isoutletprice
number0
itemprice
number18.2917
itempromo
string
key
string50503-dotty-30
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-08-01 18:29:32'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.652 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('35ef9b32-b387-4241-a0c3fdc32b11d032',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.35 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 <> 'SLAU4244'
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
string1455
isprivate
string0
rating
stringall
src
string/photobank/products/gjjm/slau4244/dotty30_01-50503-corrected.jpg
type
stringimg
width
string1164
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string774
isprivate
string0
rating
stringall
src
string/photobank/products/gjjm/slau4244/bas-autofixant-dotty-30d-glamory.jpg
type
stringimg
width
string535
variations
Struct
colors
Struct
black
Struct
height
string774
isprivate
string0
rating
stringall
src
string/photobank/products/gjjm/slau4244/bas-autofixant-dotty-30d-glamory.jpg
type
stringimg
width
string535
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
mediagallery
string
metadatas
Struct
darkboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
divasboudoir
Struct
de
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringSelbstfixierende Strümpfe Dotty<br /><br />transparent, matt und seidig glänzend.<br /><br />Polka Dot Muster<br /><br />Doppeltes Silikonband.<br /><br />Sehr elastisch für einen guten Tragekomfort.<br /><br />Mit verstärkter Spitze.<br /><br />30DEN/33DTEX
guid
stringhttps://dev.divasboudoir.com/de/selbstfixierende-strumpfe-in-grosser-grosse-dotty-schwarz/slau4244.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringSelbstfixierende Strümpfe in großer Größe Niedlich und glamourös mit ihren kleinen Punkten.
keywords
string
title
stringSelbstfixierende Strümpfe in großer Größe Dotty
seotitle
stringSelbstfixierende Strümpfe in großer Größe Dotty
seouri
stringselbstfixierende-strumpfe-in-grosser-grosse-dotty-schwarz
specifications
string
stylingtips
string
summary
stringSelbstfixierende Strümpfe in großer Größe Niedlich und glamourös mit ihren kleinen Punkten.
title
stringSelbstfixierende Strümpfe Dotty
usageinstructions
string
el
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringDotty hold-ups<br /><br />διαφανή, ματ και μεταξένια.<br /><br />Μοτίβο πουά<br /><br />Διπλή ζώνη σιλικόνης.<br /><br />Εξαιρετικά ελαστική για άνεση.<br /><br />Ενισχυμένα δάχτυλα των ποδιών.<br /><br />30DEN/33DTEX
guid
stringhttps://dev.divasboudoir.com/el/dotty-megaloy-megethoys-hold-ups-mayro/slau4244.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringΧαριτωμένα και λαμπερά hold ups με πουά.
keywords
string
title
stringDotty μεγάλου μεγέθους hold ups
seotitle
stringDotty μεγάλου μεγέθους hold ups
seouri
stringdotty-megaloy-megethoys-hold-ups-mayro
specifications
string
stylingtips
string
summary
stringΧαριτωμένα και λαμπερά hold ups με πουά.
title
stringDotty hold ups
usageinstructions
string
en
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringDotty hold-ups<br /><br />sheer, matte and silky.<br /><br />Polka Dot pattern<br /><br />Double silicone band.<br /><br />Highly elastic for comfort.<br /><br />Reinforced toes.<br /><br />30DEN/33DTEX
guid
stringhttps://dev.divasboudoir.com/en/dotty-self-tie-stockings-plus-size-black/slau4244.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringCute and glamorous plus size hold-ups with polka dots.
keywords
string
title
stringDotty self-tie stockings plus size
seotitle
stringDotty self-tie stockings plus size
seouri
stringdotty-self-tie-stockings-plus-size-black
specifications
string
stylingtips
string
summary
stringCute and glamorous plus size hold-ups with polka dots.
title
stringDotty hold ups
usageinstructions
string
es
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringMedias de puntos<br /><br />transparentes, mates y sedosos.<br /><br />Estampado de lunares<br /><br />Doble banda de silicona.<br /><br />Muy elástica para mayor comodidad.<br /><br />Puntera reforzada.<br /><br />30DEN/33DTEX
guid
stringhttps://dev.divasboudoir.com/es/dotty-talla-grande-hold-ups-negro/slau4244.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringBonitas y glamurosas tallas grandes con lunares.
keywords
string
title
stringDotty talla grande hold ups
seotitle
stringDotty talla grande hold ups
seouri
stringdotty-talla-grande-hold-ups-negro
specifications
string
stylingtips
string
summary
stringBonitas y glamurosas tallas grandes con lunares.
title
stringMedias
usageinstructions
string
fr
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringBas autofixants Dotty<br /><br />Ils sont transparents, mats et soyeux.<br /><br />Motif Polka Dot<br /><br />Double bande de silicone.&nbsp;<br /><br />Tr&egrave;s &eacute;lastique pour un bon confort.<br /><br />Pointes renforc&eacute;e.<br /><br />30DEN/33DTEX
guid
stringhttps://dev.divasboudoir.com/fr/bas-grande-taille-autofixants-dotty-noir/slau4244.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringBas grande taille autofixants mignons et glamours avec leur petits pois.
keywords
string
title
stringBas grande taille autofixants Dotty
seotitle
stringBas grande taille autofixants Dotty
seouri
stringbas-grande-taille-autofixants-dotty-noir
specifications
string
stylingtips
string
summary
stringBas grande taille autofixants mignons et glamours avec leur petits pois.
title
stringBas autofixants Dotty
usageinstructions
string
it
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringAutoreggenti puntinate<br /><br />trasparenti, opache e setose.<br /><br />Motivo a pois<br /><br />Doppia fascia in silicone.<br /><br />Altamente elastica per il massimo comfort.<br /><br />Punta rinforzata.<br /><br />30DEN/33DTEX
guid
stringhttps://dev.divasboudoir.com/it/calze-di-taglia-grande-dotty-nero/slau4244.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringSimpatiche e glamour, le autoreggenti a pois con chiusura a strappo.
keywords
string
title
stringCalze di taglia grande Dotty
seotitle
stringCalze di taglia grande Dotty
seouri
stringcalze-di-taglia-grande-dotty-nero
specifications
string
stylingtips
string
summary
stringSimpatiche e glamour, le autoreggenti a pois con chiusura a strappo.
title
stringCalze Dotty
usageinstructions
string
nl
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringStippelige hold-ups<br /><br />doorzichtig, mat en zijdeachtig.<br /><br />Stippenpatroon<br /><br />Dubbele siliconen band.<br /><br />Zeer elastisch voor comfort.<br /><br />Versterkte tenen.<br /><br />30DEN/33DTEX
guid
stringhttps://dev.divasboudoir.com/nl/dotty-groote-maat-hold-ups-zwart/slau4244.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringSchattige en glamoureuze groote maten met stippen.
keywords
string
title
stringDotty groote maat hold ups
seotitle
stringDotty groote maat hold ups
seouri
stringdotty-groote-maat-hold-ups-zwart
specifications
string
stylingtips
string
summary
stringSchattige en glamoureuze groote maten met stippen.
title
stringDotty hold-ups
usageinstructions
string
pt
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringPrendedores pontilhados<br /><br />transparentes, mate e sedosas.<br /><br />Padrão de bolinhas<br /><br />Banda dupla de silicone.<br /><br />Altamente elástica para maior conforto.<br /><br />Biqueira reforçada.<br /><br />30DEN/33DTEX
guid
stringhttps://dev.divasboudoir.com/pt/agarras-de-tamanho-grande-dotty-preto/slau4244.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringFofos e glamorosos com bolinhas.
keywords
string
title
stringAgarras de tamanho grande Dotty
seotitle
stringAgarras de tamanho grande Dotty
seouri
stringagarras-de-tamanho-grande-dotty-preto
specifications
string
stylingtips
string
summary
stringFofos e glamorosos com bolinhas.
title
stringAgarras pontilhadas
usageinstructions
string
fetishboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
latexboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
legsboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>Polkay Str&uuml;mpfe</span></p> <p><span>Transparent, matt und weich im Griff. </span></p> <p><span>Polka-Dot-Muster </span></p> <p><span>Doppeltes Silikonband </span></p> <p><span>Hochgradig dehnbar f&uuml;r hohen Tragekomfort. </span></p> <p><span>Verst&auml;rkte Zehen. </span></p> <p><span>30DEN/33DTEX </span></p>
highlights
string
keypoint
string
keywords
stringselbstfixierende Strümpfe, Punkte, transparent, matt, weich, Silikon, Komfort, verstärkt, 30 Denier, Diva's Boudoir, Dessous, Eleganz, Retro, große Größen
metas
Struct
description
stringEntdecken Sie unsere Strümpfe in Übergrößen, niedlich und elegant mit kleinen Tupfenmustern. Spezialisierter Online-Shop, hergestellt in Europa.
keywords
stringselbstfixierende Strümpfe, Punkte, transparent, matt, weich, Silikon, Komfort, verstärkt, 30 Denier, Diva's Boudoir, Dessous, Eleganz, Retro, große Größen
title
stringPolkay plus Größe Strümpfe - Polka dot Muster
seotitle
stringPlus size Strümpfe Polkay
seouri
stringplus-size-strumpfe-polkay-schwarz
specifications
string
stylingtips
string
summary
string<p><span>Niedliche und elegante Str&uuml;mpfe in &Uuml;bergr&ouml;&szlig;e mit kleinen Tupfenmotiven.</span></p>
title
stringPolkay Strümpfe
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>&Kappa;ά&lambda;&tau;&sigma;&epsilon;&sigmaf; Polkay</span></p> <p><span>&Delta;&iota;&alpha;&phi;&alpha;&nu;&epsilon;ί&sigmaf;, &mu;&alpha;&tau; &kappa;&alpha;&iota; &alpha;&pi;&alpha;&lambda;έ&sigmaf; &sigma;&tau;&eta;&nu; &alpha;&phi;ή. </span></p> <p><span>&Mu;&omicron;&tau;ί&beta;&omicron; &pi;&omicron;&upsilon;ά </span></p> <p><span>&Delta;&iota;&pi;&lambda;ή &zeta;ώ&nu;&eta; &sigma;&iota;&lambda;&iota;&kappa;ό&nu;&eta;&sigmaf; </span></p> <p><span>&Iota;&delta;&iota;&alpha;ί&tau;&epsilon;&rho;&alpha; &epsilon;&lambda;&alpha;&sigma;&tau;&iota;&kappa;έ&sigmaf; &gamma;&iota;&alpha; &upsilon;&psi;&eta;&lambda;ή ά&nu;&epsilon;&sigma;&eta; &sigma;&tau;&eta; &chi;&rho;ή&sigma;&eta;. </span></p> <p><span>&Epsilon;&nu;&iota;&sigma;&chi;&upsilon;&mu;έ&nu;&alpha; &delta;ά&chi;&tau;&upsilon;&lambda;&alpha; &tau;&omega;&nu; &pi;&omicron;&delta;&iota;ώ&nu;. </span></p> <p><span>30DEN/33DTEX </span></p>
highlights
string
keypoint
string
keywords
stringhold ups, πουά, διάφανο, ματ, μαλακό, σιλικόνη, άνεση, ενισχυμένο, 30 denier, Diva's Boudoir, εσώρουχα, κομψότητα, ρετρό, plus size
metas
Struct
description
stringΑνακαλύψτε τις plus size κάλτσες μας, χαριτωμένες και κομψές με μικρά πουά μοτίβα. Εξειδικευμένο ηλεκτρονικό κατάστημα, κατασκευασμένο στην Ευρώπη.
keywords
stringhold ups, πουά, διάφανο, ματ, μαλακό, σιλικόνη, άνεση, ενισχυμένο, 30 denier, Diva's Boudoir, εσώρουχα, κομψότητα, ρετρό, plus size
title
stringPolkay plus size κάλτσες - μοτίβο πουά
seotitle
stringPlus μέγεθος κάλτσες Polkay
seouri
stringplus-megethos-kaltses-polkay-mayro
specifications
string
stylingtips
string
summary
string<p><span>&Chi;&alpha;&rho;&iota;&tau;&omega;&mu;έ&nu;&epsilon;&sigmaf; &kappa;&alpha;&iota; &kappa;&omicron;&mu;&psi;έ&sigmaf; &upsilon;&pi;&epsilon;&rho;&mu;&epsilon;&gamma;έ&theta;&epsilon;&iota;&sigmaf; &kappa;ά&lambda;&tau;&sigma;&epsilon;&sigmaf; &mu;&epsilon; &mu;&iota;&kappa;&rho;ά &pi;&omicron;&upsilon;ά &mu;&omicron;&tau;ί&beta;&alpha;.</span></p>
title
stringΚάλτσες Polkay
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>Polkay stockings</span></p> <p><span>Sheer, matte and soft to the touch. </span></p> <p><span>Polka dot pattern </span></p> <p><span>Double silicone band </span></p> <p><span>Highly stretchable for great comfort. </span></p> <p><span>Reinforced toes. </span></p> <p><span>30DEN/33DTEX </span></p>
highlights
string
keypoint
string
keywords
stringhold ups, polka dots, sheer, matte, soft, silicone, comfort, reinforced, 30 denier, Diva's Boudoir, lingerie, elegance, retro, plus size
metas
Struct
description
stringDiscover our plus size stockings, cute and elegant with little polka dot patterns. Specialized online store, made in Europe.
keywords
stringhold ups, polka dots, sheer, matte, soft, silicone, comfort, reinforced, 30 denier, Diva's Boudoir, lingerie, elegance, retro, plus size
title
stringPolkay plus size stockings - Polka dot pattern
seotitle
stringPlus size stockings Polkay
seouri
stringplus-size-stockings-polkay-black
specifications
string
stylingtips
string
summary
string<p><span>Cute and elegant plus size stockings with small polka dot motifs.</span></p>
title
stringPolkay stockings
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>Medias Polkay</span></p> <p><span>Transparentes, mates y suaves al tacto. </span></p> <p><span>Estampado de lunares </span></p> <p><span>Doble banda de silicona </span></p> <p><span>Muy el&aacute;sticas para una gran comodidad. </span></p> <p><span>Puntera reforzada. </span></p> <p><span>30DEN/33DTEX </span></p>
highlights
string
keypoint
string
keywords
stringmedias, lunares, transparente, mate, suave, silicona, comodidad, reforzado, 30 deniers, Diva's Boudoir, lencería, elegancia, retro, talla grande
metas
Struct
description
stringDescubre nuestras medias de tallas grandes, bonitas y elegantes con estampados de lunares. Tienda online especializada, made in Europe.
keywords
stringmedias, lunares, transparente, mate, suave, silicona, confort, reforzado, 30 deniers, Diva's Boudoir, lencería, elegancia, retro, talla grande
title
stringMedias de tallas grandes Polkay - estampado de lunares
seotitle
stringMedias tallas grandes Polkay
seouri
stringmedias-tallas-grandes-polkay-negro
specifications
string
stylingtips
string
summary
string<p><span>Bonitas y elegantes medias de tallas grandes con peque&ntilde;os motivos de lunares.</span></p>
title
stringMedias Polkay
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Craquez pour le charme vintage de ces bas autofixants Polkay. Leur motif &agrave; pois d&eacute;licat apportera une touche d'originalit&eacute; &agrave; votre tenue, tout en vous assurant un confort optimal.</p> <p class="text-base">Confectionn&eacute;s dans une mati&egrave;re transparente, mate et douce au toucher, ils &eacute;pouseront vos jambes avec &eacute;l&eacute;gance. La double bande de silicone garantit un maintien parfait, sans aucune sensation d'inconfort.</p> <p class="text-base">Tr&egrave;s extensibles, ils s'adaptent &agrave; toutes les morphologies. Renforc&eacute;s au niveau des orteils, ils offrent une durabilit&eacute; accrue. Avec un grammage de 30 deniers et 33 DTEX, ces bas sont parfaits pour toutes les occasions.</p> </div>
highlights
string
keypoint
string
keywords
stringbas autofixants, pois, transparent, mat, doux, silicone, confort, renforcés, 30 deniers, Diva's Boudoir, lingerie, élégance, rétro, grande taille
metas
Struct
description
stringDécouvrez nos bas autofixants à pois, alliant élégance rétro et confort. Disponibles en grande taille sur Diva's Boudoir, pour sublimer toutes les silhouettes. 30 deniers.
keywords
stringbas autofixants, pois, transparent, mat, doux, silicone, confort, renforcés, 30 deniers, Diva's Boudoir, lingerie, élégance, rétro, grande taille
title
stringBas Autofixants GT Pois transparent - Lingerie Diva's Boudoir
seotitle
stringBas Autofixants Pois transparent Microfibre Lingerie Diva's Boudoir
seouri
stringbas-autofixants-pois-transparent-microfibre-lingerie-divas-boudoir-noir
specifications
string
stylingtips
string
summary
string<p>Adoptez un style r&eacute;tro-chic avec ces bas autofixants &agrave; pois, alliant &eacute;l&eacute;gance et confort. Un symbole de f&eacute;minit&eacute; et d'audace, pour une allure irr&eacute;sistible.</p>
title
stringBas Autofixants Pois - Élégance Rétro & Confort
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>Calze Polkay</span></p> <p><span>Trasparenti, opache e morbide al tatto. </span></p> <p><span>Stampa a pois </span></p> <p><span>Doppia banda in silicone </span></p> <p><span>Altamente elastica per un grande comfort. </span></p> <p><span>Punta rinforzata. </span></p> <p><span>30DEN/33DTEX </span></p>
highlights
string
keypoint
string
keywords
stringautoreggenti, pois, velato, opaco, morbido, silicone, comfort, rinforzato, 30 denari, Diva's Boudoir, lingerie, eleganza, retrò, taglia grande
metas
Struct
description
stringScoprite le nostre calze plus size, belle ed eleganti con stampe a pois. Negozio online specializzato, made in Europe.
keywords
stringautoreggenti, pois, velato, opaco, morbido, silicone, comfort, rinforzato, 30 denari, Diva's Boudoir, lingerie, eleganza, retrò, taglia grande
title
stringCalzini Polkay plus size - stampa a pois
seotitle
stringCalze Polkay plus size
seouri
stringcalze-polkay-plus-size-nero
specifications
string
stylingtips
string
summary
string<p><span>Belle ed eleganti calze plus size con motivi a piccoli pois.</span></p>
title
stringCalzini Polkay
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>Polkay hold-ups </span></p> <p><span>Transparant, mat en voelt zacht aan. </span></p> <p><span>Stippenpatroon </span></p> <p><span>Dubbele siliconen band </span></p> <p><span>Zeer rekbaar voor veel comfort. </span></p> <p><span>Versterkte tenen. </span></p> <p><span>30DEN/33DTEX </span></p>
highlights
string
keypoint
string
keywords
stringhold-ups, stippen, transparant, mat, zacht, siliconen, comfort, versterkt, 30 denier, Diva's Boudoir, lingerie, elegantie, retro, grote maten
metas
Struct
description
stringOntdek onze grote maten hold-ups, schattig en elegant met kleine stippenpatronen. Gespecialiseerde online winkel, gemaakt in Europa.
keywords
stringhold-ups, stippen, transparant, mat, zacht, siliconen, comfort, versterkt, 30 denier, Diva's Boudoir, lingerie, elegantie, retro, grote maten
title
stringPolkay grote maat hold ups - Polka dot patroon
seotitle
stringPolkay grote maat hold ups
seouri
stringpolkay-grote-maat-hold-ups-zwart
specifications
string
stylingtips
string
summary
string<p><span>Schattige en elegante grote maten hold-ups met kleine stippenmotiefjes.</span></p>
title
stringPolkay hold ups
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>Meias de ligas Polkay</span></p> <p><span>Transparentes, mate e suaves ao tato. </span></p> <p><span>Estampado de bolinhas </span></p> <p><span>Banda dupla de silicone </span></p> <p><span>Muito el&aacute;stico para um grande conforto. </span></p> <p><span>Biqueira refor&ccedil;ada. </span></p> <p><span>30DEN/33DTEX </span></p>
highlights
string
keypoint
string
keywords
stringmolas, bolinhas, transparente, mate, macio, silicone, conforto, reforçado, 30 denier, Diva's Boudoir, lingerie, elegância, retro, plus size
metas
Struct
description
stringDescubra as nossas meias de tamanho grande, bonitas e elegantes com estampados de bolinhas. Loja online especializada, fabricada na Europa.
keywords
stringmolas, bolinhas, transparente, mate, macio, silicone, conforto, reforçado, 30 denier, Diva's Boudoir, lingerie, elegância, retro, plus size
title
stringCollants plus size Polkay - estampado de bolinhas
seotitle
stringMeias Polkay plus size
seouri
stringmeias-polkay-plus-size-preto
specifications
string
stylingtips
string
summary
string<p><span>Belas e elegantes meias de tamanho grande com pequenos motivos de bolinhas.</span></p>
title
stringMeias Polkay
usageinstructions
string
lustboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
smboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Wagen Sie eine diskrete Verführung mit diesen selbstfixierenden Strümpfen von Polkay. Ihr zartes Pünktchenmuster verbirgt ein ungeahntes Potenzial für Transgression, perfekt für Rollenspiele und die kühnsten Fantasien.</p> <p class="text-base">Sie sind aus einem transparenten, matten Material gefertigt, das sich weich anfühlt und sich elegant an Ihre Beine schmiegt. Das doppelte Silikonband sorgt für einen perfekten Sitz, selbst bei den intensivsten Sitzungen.</p> <p class="text-base">Sie sind sehr dehnbar und passen sich jeder Körperform an. Sie sind im Zehenbereich verstärkt und bieten so eine längere Haltbarkeit. Mit einer Grammatur von 30 Denier und 33 DTEX sind diese Strümpfe das ideale Accessoire, um Ihr Liebesleben aufzupeppen.</p> </div>
highlights
string
keypoint
string
keywords
stringselbstfixierende Strümpfe, gepunktet, transparent, matt, weich, Silikon, Komfort, verstärkt, 30 Denier, The Bdsm Boudoir, BDSM, Fetisch, Unterwerfung, Versuchung
metas
Struct
description
stringEntdecken Sie unsere selbstfixierenden Strümpfe mit Punkten, die sich perfekt für Ihre BDSM-Spiele eignen. Lassen Sie die subtilen Punkte Ihre Fantasien auf The BDSM Boudoir wecken. 30 Denier.
keywords
stringselbstfixierende Strümpfe, gepunktet, transparent, matt, weich, Silikon, Komfort, verstärkt, 30 Denier, The Bdsm Boudoir, BDSM, Fetisch, Unterwerfung, Versuchung
title
stringBDSM GT Autofixierende Strümpfe mit Punkten - Dessous The BDSM Boudoir
seotitle
stringAutofixierende Strümpfe GT Pois BDSM The Bdsm Boudoir
seouri
stringautofixierende-strumpfe-gt-pois-bdsm-the-bdsm-boudoir-schwarz
specifications
string
stylingtips
string
summary
string<p>Lassen Sie die Subtilität der Tupfen Ihre kühnsten Fantasien erwecken. Diese selbstfixierenden Strümpfe, Symbole der Versuchung und des verbotenen Vergnügens, werden Sie der Unterwerfung erliegen lassen.</p>
title
stringSelbstfixierende Strümpfe mit Punkten in großen Größen - Subtilität & Versuchung
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Τολμήστε να γίνετε διακριτικά σαγηνευτική με αυτά τα Polkay hold-ups. Το λεπτεπίλεπτο πουά μοτίβο τους κρύβει μια ανυποψίαστη δυνατότητα για παραβάσεις, ιδανική για παιχνίδια ρόλων και τις πιο τολμηρές φαντασιώσεις.</p> <p class="text-base">Κατασκευασμένα από διαφανές, ματ υλικό που είναι μαλακό στην αφή, θα αγκαλιάζουν τα πόδια σας με κομψότητα. Η διπλή ζώνη σιλικόνης εξασφαλίζει τέλεια στήριξη, ακόμη και κατά τη διάρκεια των πιο έντονων συνεδριών.</p> <p class="text-base">Και είναι αρκετά ελαστικά ώστε να ταιριάζουν σε όλα τα σχήματα σώματος. Ενισχυμένα δάχτυλα στα δάχτυλα των ποδιών για επιπλέον ανθεκτικότητα. Με βάρος 30 denier και 33 DTEX, αυτές οι κάλτσες είναι το ιδανικό αξεσουάρ για να απογειώσετε την ερωτική σας ζωή.</p> </div>
highlights
string
keypoint
string
keywords
stringhold ups, πουά, διάφανο, ματ, μαλακό, σιλικόνη, άνεση, ενισχυμένο, 30 denier, The Bdsm Boudoir, BDSM, φετίχ, υποταγή, πειρασμός
metas
Struct
description
stringΑνακαλύψτε τα πουά hold ups μας, ιδανικά για τα παιχνίδια BDSM σας. Αφήστε τη λεπτότητα των πουά να ξυπνήσει τις φαντασιώσεις σας στο The Bdsm Boudoir. 30 denier.
keywords
stringhold ups, πουά, διάφανο, ματ, μαλακό, σιλικόνη, άνεση, ενισχυμένο, 30 denier, The Bdsm Boudoir, BDSM, φετίχ, υποταγή, πειρασμός
title
stringGT Pois BDSM hold ups - Εσώρουχα Το Bdsm Boudoir
seotitle
stringGT Pois κρατήσει ups BDSM Το Bdsm Boudoir
seouri
stringgt-pois-krathsei-ups-bdsm-to-bdsm-boudoir-mayro
specifications
string
stylingtips
string
summary
string<p>Αφήστε τη λεπτότητα του πουά να ξυπνήσει τις πιο τολμηρές φαντασιώσεις σας. Αυτά τα hold-ups, σύμβολα του πειρασμού και της απαγορευμένης απόλαυσης, θα σας κάνουν να υποκύψετε στην υποταγή.</p>
title
stringStay-up Pois Grande Taille - Λεπτότητα & Πειρασμός
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Dare to be discreetly seductive with these Polkay hold-ups. Their delicate polka-dot pattern conceals an unsuspected potential for transgression, perfect for role-playing and the most daring fantasies.</p> <p class="text-base">Made from a transparent, matte material that's soft to the touch, they'll hug your legs with elegance. The double silicone band ensures perfect support, even during the most intense sessions.</p> <p class="text-base">Highly stretchable, they adapt to all body shapes. Reinforced toes for extra durability. With 30 denier and 33 DTEX, these stockings are the ideal accessory to spice up your love life.</p> </div>
highlights
string
keypoint
string
keywords
stringhold ups, polka dot, sheer, matte, soft, silicone, comfort, reinforced, 30 denier, The Bdsm Boudoir, BDSM, fetish, submission, temptation
metas
Struct
description
stringDiscover our polka-dot hold-ups, perfect for your BDSM games. Let the subtlety of polka dots awaken your fantasies on The BDSM Boudoir. 30 denier.
keywords
stringhold ups, polka dot, sheer, matte, soft, silicone, comfort, reinforced, 30 denier, The Bdsm Boudoir, BDSM, fetish, submission, temptation
title
stringGT Pois BDSM hold ups - Lingerie The Bdsm Boudoir
seotitle
stringGT Pois hold ups The BDSM Boudoir
seouri
stringgt-pois-hold-ups-the-bdsm-boudoir-black
specifications
string
stylingtips
string
summary
string<p>Let the subtlety of polka dots awaken your most daring fantasies. These hold-ups, symbols of temptation and forbidden pleasure, will make you succumb to submission.</p>
title
stringBas Autofixants Pois Plus Size - Subtilité & Tentation
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Atrévete a ser discretamente seductora con estos medias Polkay. Su delicado estampado de lunares esconde un insospechado potencial de transgresión, perfecto para los juegos de rol y las fantasías más atrevidas.</p> <p class="text-base">Fabricadas en un material transparente, mate y suave al tacto, abrazarán tus piernas con elegancia. La doble banda de silicona garantiza una sujeción perfecta, incluso durante las sesiones más intensas.</p> <p class="text-base">Muy extensibles, se adaptan a todas las morfologías. Punteras reforzadas para una mayor durabilidad. Con un gramaje de 30 deniers y 33 DTEX, estas medias son el accesorio ideal para animar tu vida amorosa.</p> </div>
highlights
string
keypoint
string
keywords
stringmedias, lunares, transparente, mate, suave, silicona, comodidad, reforzado, 30 denier, The BDSM Boudoir, BDSM, fetiche, sumisión, tentación
metas
Struct
description
stringDescubre nuestros medias de lunares, perfectos para tus juegos BDSM. Deja que la sutileza de los lunares despierte tus fantasías en The BDSM Boudoir. 30 deniers.
keywords
stringmedias, lunares, transparente, mate, suave, silicona, comodidad, reforzado, 30 denier, The BDSM Boudoir, BDSM, fetiche, sumisión, tentación
title
stringGT Pois BDSM medias - Lencería The BDSM Boudoir
seotitle
stringGT Pois asaltos BDSM The BDSM Boudoir
seouri
stringgt-pois-asaltos-bdsm-the-bdsm-boudoir-negro
specifications
string
stylingtips
string
summary
string<p>Deja que la sutileza de los lunares despierte tus fantasías más atrevidas. Estos medias, símbolos de tentación y placer prohibido, te harán sucumbir a la sumisión.</p>
title
stringStay-up Pois talla grande - Sutileza y tentación
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Osez la s&eacute;duction discr&egrave;te avec ces bas autofixants Polkay. Leur motif &agrave; pois d&eacute;licat cache un potentiel de transgression insoup&ccedil;onn&eacute;, parfait pour les jeux de r&ocirc;le et les fantasmes les plus audacieux.</p> <p class="text-base">Confectionn&eacute;s dans une mati&egrave;re transparente, mate et douce au toucher, ils &eacute;pouseront vos jambes avec &eacute;l&eacute;gance. La double bande de silicone garantit un maintien parfait, m&ecirc;me lors des s&eacute;ances les plus intenses.</p> <p class="text-base">Tr&egrave;s extensibles, ils s'adaptent &agrave; toutes les morphologies. Renforc&eacute;s au niveau des orteils, ils offrent une durabilit&eacute; accrue. Avec un grammage de 30 deniers et 33 DTEX, ces bas sont l'accessoire id&eacute;al pour pimenter votre vie amoureuse.</p> </div>
highlights
string
keypoint
string
keywords
stringbas autofixants, pois, transparent, mat, doux, silicone, confort, renforcés, 30 deniers, The Bdsm Boudoir, BDSM, fétichiste, soumission, tentation
metas
Struct
description
stringDécouvrez nos bas autofixants à pois, parfaits pour vos jeux BDSM. Laissez la subtilité des pois éveiller vos fantasmes sur The Bdsm Boudoir. 30 deniers.
keywords
stringbas autofixants, pois, transparent, mat, doux, silicone, confort, renforcés, 30 deniers, The Bdsm Boudoir, BDSM, fétichiste, soumission, tentation
title
stringBas Autofixants GT à Pois BDSM - Lingerie The Bdsm Boudoir
seotitle
stringBas Autofixants GT Pois BDSM The Bdsm Boudoir
seouri
stringbas-autofixants-gt-pois-bdsm-the-bdsm-boudoir-noir
specifications
string
stylingtips
string
summary
string<p>Laissez la subtilit&eacute; des pois &eacute;veiller vos fantasmes les plus audacieux. Ces bas autofixants, symboles de tentation et de plaisir interdit, vous feront succomber &agrave; la soumission.</p>
title
stringBas Autofixants Pois Grande Taille - Subtilité & Tentation
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Osate essere discretamente seducenti con queste autoreggenti Polkay. Il loro delicato motivo a pois nasconde un insospettabile potenziale di trasgressione, perfetto per i giochi di ruolo e le fantasie più audaci.</p> <p class="text-base">Realizzate in un materiale trasparente e opaco, morbido al tatto, abbracceranno le vostre gambe con eleganza. La doppia fascia in silicone assicura un sostegno perfetto, anche durante le sessioni più intense.</p> <p class="text-base">E sono abbastanza elastici da adattarsi a tutte le forme del corpo. Dita rinforzate per una maggiore durata. Con un peso di 30 denari e 33 DTEX, queste calze sono l'accessorio ideale per vivacizzare la vostra vita amorosa.</p> </div>
highlights
string
keypoint
string
keywords
stringautoreggenti, pois, velato, opaco, morbido, silicone, comfort, rinforzato, 30 denari, The BDSM Boudoir, BDSM, fetish, sottomissione, tentazione
metas
Struct
description
stringScoprite le nostre autoreggenti a pois, perfette per i vostri giochi BDSM. Lasciate che la delicatezza dei pois risvegli le vostre fantasie su The BDSM Boudoir. 30 denari.
keywords
stringautoreggenti, pois, velato, opaco, morbido, silicone, comfort, rinforzato, 30 denari, The BDSM Boudoir, BDSM, fetish, sottomissione, tentazione
title
stringCalze GT Pois BDSM - Lingerie The BDSM Boudoir
seotitle
stringGT Pois autoreggenti BDSM The BDSM Boudoir
seouri
stringgt-pois-autoreggenti-bdsm-the-bdsm-boudoir-nero
specifications
string
stylingtips
string
summary
string<p>Lasciate che la delicatezza dei pois risvegli le vostre fantasie più audaci. Queste autoreggenti, simbolo di tentazione e piacere proibito, vi faranno soccombere alla sottomissione.</p>
title
stringStay-up Pois Taglia Grande - Sottigliezza e Tentazione
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Durf discreet verleidelijk te zijn met deze Polkay hold-ups. Hun delicate stippenpatroon verbergt een onvermoed potentieel voor overtredingen, perfect voor rollenspellen en de meest gedurfde fantasieën.</p> <p class="text-base">Gemaakt van een doorzichtig, mat materiaal dat zacht aanvoelt, omhelzen ze je benen met elegantie. De dubbele siliconen band zorgt voor perfecte ondersteuning, zelfs tijdens de meest intense sessies.</p> <p class="text-base">Zeer rekbaar, dus geschikt voor alle lichaamsvormen. Versterkte tenen voor extra duurzaamheid. Met een gewicht van 30 denier en 33 DTEX zijn deze kousen het ideale accessoire om je liefdesleven op te fleuren.</p> </div>
highlights
string
keypoint
string
keywords
stringhold-ups, stippen, transparant, mat, zacht, siliconen, comfort, versterkt, 30 denier, The BDSM Boudoir, BDSM, fetisj, onderwerping, verleiding
metas
Struct
description
stringOntdek onze polka dot hold ups, perfect voor je BDSM spelletjes. Laat de subtiliteit van stippen je fantasieën prikkelen op The BDSM Boudoir. 30 denier.
keywords
stringhold-ups, stippen, transparant, mat, zacht, siliconen, comfort, versterkt, 30 denier, The BDSM Boudoir, BDSM, fetisj, onderwerping, verleiding
title
stringGT Pois BDSM hold ups - Lingerie The BDSM Boudoir
seotitle
stringGT Pois hold-ups BDSM The BDSM Boudoir
seouri
stringgt-pois-hold-ups-bdsm-the-bdsm-boudoir-zwart
specifications
string
stylingtips
string
summary
string<p>Laat de subtiliteit van stippen je meest gedurfde fantasieën wakker maken. Deze hold-ups, symbolen van verleiding en verboden genot, zullen je doen bezwijken voor overgave.</p>
title
stringStay-up Pois Grote Maat - Subtiliteit & Verleiding
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Atreva-se a ser discretamente sedutora com estas abraçadeiras Polkay. O seu delicado padrão de bolinhas esconde um potencial insuspeito de transgressão, perfeito para jogos de papéis e as fantasias mais ousadas.</p> <p class="text-base">Fabricadas num material transparente, mate e suave ao toque, vão abraçar as suas pernas com elegância. A dupla banda de silicone garante um suporte perfeito, mesmo durante as sessões mais intensas.</p> <p class="text-base">Altamente extensíveis, adaptam-se a todas as formas do corpo. Biqueira reforçada para uma maior durabilidade. Com um peso de 30 denier e 33 DTEX, estas meias são o acessório ideal para apimentar a sua vida amorosa.</p> </div>
highlights
string
keypoint
string
keywords
stringpegas, bolinhas, transparente, mate, macio, silicone, conforto, reforçado, 30 denier, The Bdsm Boudoir, BDSM, fetiche, submissão, tentação
metas
Struct
description
stringDescubra os nossos hold ups de bolinhas, perfeitos para os seus jogos BDSM. Deixe que a subtileza das bolinhas desperte as suas fantasias em The Bdsm Boudoir. 30 denier.
keywords
stringpegas, bolinhas, transparente, mate, macio, silicone, conforto, reforçado, 30 denier, The Bdsm Boudoir, BDSM, fetiche, submissão, tentação
title
stringGT Pois BDSM hold ups - Lingerie O Boudoir Bdsm
seotitle
stringGT Pois hold ups BDSM O Boudoir Bdsm
seouri
stringgt-pois-hold-ups-bdsm-o-boudoir-bdsm-preto
specifications
string
stylingtips
string
summary
string<p>Deixe que a subtileza das bolinhas desperte as suas fantasias mais ousadas. Estas agarradinhas, símbolos da tentação e do prazer proibido, vão fazê-la sucumbir à submissão.</p>
title
stringStay-up Pois Grande Taille - Subtileza e Tentação
usageinstructions
string
name
string50503 dotty 30
netweight
string
nextshipment
stringtomorrow
ordered
number18
orderidx
number0
origin
stringeu
originalsize
string
packaging
string
productshipment
stringauto
productuid
string35EF9B32-B387-4241-A0C3FDC32B11D032
promountil
string
rating
stringnone
recorduid
string35EF9B32-B387-4241-A0C3FDC32B11D032
reference
stringSLAU4244
related
string
reserved
string
returned
number0
returnsallowed
number1
section
stringlingerie
shipment
string4to6days
showbrand
number0
sizeinfos
Query
Template: /system/api/product/sizes.cfc:20
Execution Time: 1.47 ms
Record Count: 6
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,'1039,1040,1041,1042,1043,1044') > 0
and product_variations.productuid = '35EF9B32-B387-4241-A0C3FDC32B11D032'
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
110394intlsizeblack44-19999990wplusstocking4-M440-4210-1214-1642-4442-4440-4246-4842-4440-4249-55
210405intlsizeblack55-19999990wplusstocking5-L542-4412-1416-1844-4644-4642-4448-5044-4642-4456-62
310416intlsizeblack66-19999990wplusstocking6-XL646-4816-1820-2248-5048-5046-4852-5448-5046-4862-69
410427intlsizeblack77-19999990wplusstocking7-2XL748-5018-2022-2450-5250-5248-5054-5650-5248-5069-76
510438intlsizeblack88-19999990wplusstocking8-3XL850-5220-2224-2652-5452-5450-5256-5852-5450-5276-83
610449intlsizeblack99-19999990wplusstocking9-4XL952-5422-2426-2854-5654-5652-5458-6054-5652-5483-89
sizeranges
stringplus
sizes
string1039,1040,1041,1042,1043,1044
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: 50.8 ms
Record Count: 6
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select * from (
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '35EF9B32-B387-4241-A0C3FDC32B11D032'
and product_variations.isactive = 1
and product_sizes.id_size = 1039
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 = '35EF9B32-B387-4241-A0C3FDC32B11D032'
and product_variations.isactive = 1
and product_sizes.id_size = 1040
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 = '35EF9B32-B387-4241-A0C3FDC32B11D032'
and product_variations.isactive = 1
and product_sizes.id_size = 1041
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 = '35EF9B32-B387-4241-A0C3FDC32B11D032'
and product_variations.isactive = 1
and product_sizes.id_size = 1042
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 = '35EF9B32-B387-4241-A0C3FDC32B11D032'
and product_variations.isactive = 1
and product_sizes.id_size = 1043
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 = '35EF9B32-B387-4241-A0C3FDC32B11D032'
and product_variations.isactive = 1
and product_sizes.id_size = 1044
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
135EF9B32-B387-4241-A0C3FDC32B11D03297DEA79F-601A-4550-BC9A85EAEA22BCF51039black#0000004-M440-4210-1214-1642-4442-4440-4246-4842-4440-42wstocking4intlsize18.29170STOCK01000-10300505034260277134600-10all
235EF9B32-B387-4241-A0C3FDC32B11D032F10230AA-03A2-4685-B20C16FC4848D01E1040black#0000005-L542-4412-1416-1844-4644-4642-4448-5044-4642-44wstocking5intlsize18.29170STOCK01000-10000505034260277134617-10all
335EF9B32-B387-4241-A0C3FDC32B11D032FA460FAA-4286-498C-842FB2D9C7A01E2F1041black#0000006-XL646-4816-1820-2248-5048-5046-4852-5448-5046-48wstocking6intlsize18.29170STOCK01000-10600505034260277134624-10all
435EF9B32-B387-4241-A0C3FDC32B11D0327123E6E0-6A71-49DD-839E9D946D36633C1042black#0000007-2XL748-5018-2022-2450-5250-5248-5054-5650-5248-50wstocking7intlsize18.29170STOCK01000-10300505034260277134631-10all
535EF9B32-B387-4241-A0C3FDC32B11D032BE60C711-DE17-4018-8C2103284A9B5D451043black#0000008-3XL850-5220-2224-2652-5452-5450-5256-5852-5450-52wstocking8intlsize18.29170STOCK01000-10400505034260277132750-10all
635EF9B32-B387-4241-A0C3FDC32B11D032678B3E8A-690F-426D-8917B0648894B1C81044black#0000009-4XL952-5422-2426-2854-5654-5652-5458-6054-5652-54wstocking9intlsize18.29170STOCK01000-10500505034260277132767-10all
subcategory
stringstocking
supplier
number-1
supplierreference
string50503
tags
string
themes
string
totalvariations
string
type
stringdefault
unitprice
number18.2917
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 20.9 ms
Record Count: 6
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 = '35EF9B32-B387-4241-A0C3FDC32B11D032' 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 = '35EF9B32-B387-4241-A0C3FDC32B11D032' 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 = '35EF9B32-B387-4241-A0C3FDC32B11D032' 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 = '35EF9B32-B387-4241-A0C3FDC32B11D032' 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 = '35EF9B32-B387-4241-A0C3FDC32B11D032' 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 = '35EF9B32-B387-4241-A0C3FDC32B11D032' 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 = '35EF9B32-B387-4241-A0C3FDC32B11D032'
and product_variations.isactive = 1
and product_sizes.id_size = 1039
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 = '35EF9B32-B387-4241-A0C3FDC32B11D032' 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 = '35EF9B32-B387-4241-A0C3FDC32B11D032' 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 = '35EF9B32-B387-4241-A0C3FDC32B11D032' 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 = '35EF9B32-B387-4241-A0C3FDC32B11D032' 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 = '35EF9B32-B387-4241-A0C3FDC32B11D032' 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 = '35EF9B32-B387-4241-A0C3FDC32B11D032' 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 = '35EF9B32-B387-4241-A0C3FDC32B11D032'
and product_variations.isactive = 1
and product_sizes.id_size = 1040
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 = '35EF9B32-B387-4241-A0C3FDC32B11D032' 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 = '35EF9B32-B387-4241-A0C3FDC32B11D032' 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 = '35EF9B32-B387-4241-A0C3FDC32B11D032' 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 = '35EF9B32-B387-4241-A0C3FDC32B11D032' 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 = '35EF9B32-B387-4241-A0C3FDC32B11D032' 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 = '35EF9B32-B387-4241-A0C3FDC32B11D032' 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 = '35EF9B32-B387-4241-A0C3FDC32B11D032'
and product_variations.isactive = 1
and product_sizes.id_size = 1041
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 = '35EF9B32-B387-4241-A0C3FDC32B11D032' 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 = '35EF9B32-B387-4241-A0C3FDC32B11D032' 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 = '35EF9B32-B387-4241-A0C3FDC32B11D032' 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 = '35EF9B32-B387-4241-A0C3FDC32B11D032' 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 = '35EF9B32-B387-4241-A0C3FDC32B11D032' 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 = '35EF9B32-B387-4241-A0C3FDC32B11D032' 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 = '35EF9B32-B387-4241-A0C3FDC32B11D032'
and product_variations.isactive = 1
and product_sizes.id_size = 1042
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 = '35EF9B32-B387-4241-A0C3FDC32B11D032' 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 = '35EF9B32-B387-4241-A0C3FDC32B11D032' 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 = '35EF9B32-B387-4241-A0C3FDC32B11D032' 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 = '35EF9B32-B387-4241-A0C3FDC32B11D032' 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 = '35EF9B32-B387-4241-A0C3FDC32B11D032' 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 = '35EF9B32-B387-4241-A0C3FDC32B11D032' 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 = '35EF9B32-B387-4241-A0C3FDC32B11D032'
and product_variations.isactive = 1
and product_sizes.id_size = 1043
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 = '35EF9B32-B387-4241-A0C3FDC32B11D032' 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 = '35EF9B32-B387-4241-A0C3FDC32B11D032' 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 = '35EF9B32-B387-4241-A0C3FDC32B11D032' 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 = '35EF9B32-B387-4241-A0C3FDC32B11D032' 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 = '35EF9B32-B387-4241-A0C3FDC32B11D032' 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 = '35EF9B32-B387-4241-A0C3FDC32B11D032' 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 = '35EF9B32-B387-4241-A0C3FDC32B11D032'
and product_variations.isactive = 1
and product_sizes.id_size = 1044
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
197DEA79F-601A-4550-BC9A85EAEA22BCF51039black#0000004-M440-4210-1214-1642-4442-4440-4246-4842-4440-42wstocking4intlsize18.29170STOCK01000-10300505034260277134600-10-10-10018.2917all
2F10230AA-03A2-4685-B20C16FC4848D01E1040black#0000005-L542-4412-1416-1844-4644-4642-4448-5044-4642-44wstocking5intlsize18.29170STOCK01000-10000505034260277134617-10-10-10018.2917all
3FA460FAA-4286-498C-842FB2D9C7A01E2F1041black#0000006-XL646-4816-1820-2248-5048-5046-4852-5448-5046-48wstocking6intlsize18.29170STOCK01000-10600505034260277134624-10-10-10018.2917all
47123E6E0-6A71-49DD-839E9D946D36633C1042black#0000007-2XL748-5018-2022-2450-5250-5248-5054-5650-5248-50wstocking7intlsize18.29170STOCK01000-10300505034260277134631-10-10-10018.2917all
5BE60C711-DE17-4018-8C2103284A9B5D451043black#0000008-3XL850-5220-2224-2652-5452-5450-5256-5852-5450-52wstocking8intlsize18.29170STOCK01000-10400505034260277132750-10-10-10018.2917all
6678B3E8A-690F-426D-8917B0648894B1C81044black#0000009-4XL952-5422-2426-2854-5654-5652-5458-6054-5652-54wstocking9intlsize18.29170STOCK01000-10500505034260277132767-10-10-10018.2917all
vatrate
number20
warehouse
string