Mijn mand

❌
Totaal aantal items
Winkelmand bekijken
Menu
Maten bekijken
Ondoorzichtige kousen 60 Den
Dubbelklikken om te vergroten
SKU: SLAU6935
Ondoorzichtige kousen 60 Den
GEMAAKT IN
Voorraad:

Dikke, ondoorzichtige, zelfbevestigende, groote maten.

Maat:

Weet je niet zeker welke maat je moet kiezen? Raadpleeg onze maattabel

Kleur:
Hoeveelheid:
24.95 €
Goed advies
via chat, facebook of e-mail
Gratis retourneren
binnen 15 dagen *

Groote maat ondoorzichtige kousen 60 Den

Productomschrijving

Kousen voor de winter.

Ondoorzichtig en dik, ze zijn heel, heel stevig, maar toch heel vrouwelijk en sexy.

Dubbele siliconenband, verstevigde hiel en teen.

Zeer zacht.

60 denier/66 Datex

Technische details

Beschikbaar maten

Beschikbaar van 4 tot 9

Beschikbare kleuren

Zwart en Beige

Maattabel

Controleer de juiste maat voor jou

Internationale
  • Dij
4
  • 49-55
5
  • 56-62
6
  • 62-69
7
  • 69-76
8
  • 76-83
9
  • 83-89
To Top
Winkelmand bekijken
Artikelen
Totaal aantal 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.871 ms
Record Count: 2
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_colors.color as recorduid, product_colors.type, product_colors.code, product_colors.color, product_colors.range, product_colors.hexvalue,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock
from product_colors
left outer join product_variations on product_colors.color = product_variations.color and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
where FIND_IN_SET(product_colors.color,'black,beige') > 0
and product_variations.productuid = '3DB4EDC9-8296-48E4-B8AB159A91DEEF3F'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1blackcolorblakblackblack#000000-14
2beigecolorbeigbeigebrown#F6DBAC-16
colorrange
stringbrown
colors
stringblack,beige
colortype
stringcolor
comments
string
compositions
Struct
Entries: 13
coton
string
elastane
string
free
string
leather
string
lycra
string
metal
string
nylon
string
polyamide
string
polyester
string
polyurethane
string
silk
string
spandex
string
viscose
string
datecreated
Date Time (Europe/Paris)
{ts '2019-11-19 13:49:50'}
defect
number2
dimensions
Struct
Entries: 14
acrylicbones
string
backsideheight
string
diameter
string
flatsteelbones
string
frontsideheight
string
fullheight
string
length
string
modestysize
string
panels
string
sides
string
spiralsteelbones
string
totallength
string
unit
stringcm
wiresize
string
display
stringall
displayfrom
string
displayto
string
grossweight
string
hasbrandinfos
booleanfalse
hascareinstructions
booleanfalse
hascolorinfos
booleantrue
hascompositions
booleanfalse
hasdescription
booleantrue
hasdimensions
booleanfalse
hasmaterials
booleanfalse
hasotherspecifications
booleanfalse
haspromo
number0
hasshortdescription
booleantrue
hassizeinfos
booleantrue
hasspecifications
booleanfalse
hasstockinfos
booleanfalse
hasstylingtips
booleanfalse
hasusageinstructions
booleanfalse
hasvariations
booleantrue
import
string
inpromo
number0
instockvariations
string
isactive
number1
iscustommade
number0
isdivasize
number1
isfirstprice
number0
isfixedprice
number0
ishot
number0
isnew
number0
isonline
number0
isoutletprice
number0
itemprice
number20.7917
itempromo
string
key
string50118-mrco-60
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-09-24 11:23:32'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.629 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','nl')
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('3db4edc9-8296-48e4-b8ab159a91deef3f',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.32 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','nl')
and product_categories.language in ('all','nl')
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 <> 'SLAU6935'
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
string1730
isprivate
string0
rating
stringall
src
string/photobank/products/gjjm/slau6935/lacetop_1800x1800.jpg
type
stringimg
width
string1197
back
Struct
height
string722
isprivate
string0
rating
stringall
src
string/photobank/products/gjjm/slau6935/50118-micro-60-black-plus-size_crop_2.jpg
type
stringimg
width
string628
default
Struct
height
string1615
isprivate
string0
rating
stringall
src
string/photobank/products/gjjm/slau6935/glamory_promo_-_50118-micro-60-black-2.jpg
type
stringimg
width
string1166
variations
Struct
colors
Struct
beige
Struct
height
string1960
isprivate
string0
rating
stringall
src
string/photobank/products/gjjm/slau6935/50118-micro-60-make-up-plus-size.jpg
type
stringimg
width
string1613
black
Struct
height
string784
isprivate
string0
rating
stringall
src
string/photobank/products/gjjm/slau6935/50118-micro-60-black-plus-size_crop.jpg
type
stringimg
width
string615
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-ou-beige
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-ou-mpez
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-ou-beige
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-ou-beige
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-ou-beige
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-ou-beige
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-ou-beige
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-ou-bege
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
divasboudoir
Struct
de
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringStr&uuml;mpfe f&uuml;r den Winter.<br /><br />Sie sind blickdicht und dick, sehr, sehr robust und trotzdem super feminin und sexy.<br /><br />Doppeltes Silikonband, verst&auml;rkte Ferse und Spitze.<br /><br />Ganz weich.<br /><br />60 Denier/66 Datex
guid
stringhttps://dev.divasboudoir.com/de/strumpfe-grosse-grosse-blickdicht-60-den-schwarz-ou-beige/slau6935.htm
highlights
string
keypoint
string
keywords
stringblickdichte Strümpfe, Thermostrümpfe, große Größen, Komfort, elegant, sexy, Silikon, verstärkt, weich, 60 Denier, Diva's Boudoir, Dessous, Weiblichkeit
metas
Struct
description
stringDicke, blickdichte, selbstfixierende Strümpfe in großen Größen, die sehr stabil sind.
keywords
stringblickdichte Strümpfe, Thermos, große Größen, Komfort, elegant, sexy, Silikon, verstärkt, weich, 60 Denier, Diva's Boudoir, Dessous, Weiblichkeit
title
stringStrümpfe große Größe blickdicht 60 Den
seotitle
stringStrümpfe große Größe blickdicht 60 Den
seouri
stringstrumpfe-grosse-grosse-blickdicht-60-den-schwarz-ou-beige
specifications
string
stylingtips
string
summary
stringDicke, blickdichte, selbstfixierende Str&uuml;mpfe in gro&szlig;en Gr&ouml;&szlig;en, die sehr stabil sind.
title
stringBlickdichte Strümpfe 60 Den
usageinstructions
string
el
Struct
Entries: 15
abstract
string
careinstructions
string
description
string&Kappa;ά&lambda;&tau;&sigma;&epsilon;&sigmaf; &gamma;&iota;&alpha; &tau;&omicron; &chi;&epsilon;&iota;&mu;ώ&nu;&alpha;.<br /><br />&Alpha;&delta;&iota;&alpha;&phi;&alpha;&nu;&epsilon;ί&sigmaf; &kappa;&alpha;&iota; &chi;&omicron;&nu;&tau;&rho;έ&sigmaf;, &epsilon;ί&nu;&alpha;&iota; &pi;&omicron;&lambda;ύ, &pi;&omicron;&lambda;ύ &alpha;&nu;&theta;&epsilon;&kappa;&tau;&iota;&kappa;έ&sigmaf;, &alpha;&lambda;&lambda;ά &epsilon;&xi;&alpha;&kappa;&omicron;&lambda;&omicron;&upsilon;&theta;&omicron;ύ&nu; &nu;&alpha; &epsilon;ί&nu;&alpha;&iota; &pi;&omicron;&lambda;ύ &theta;&eta;&lambda;&upsilon;&kappa;έ&sigmaf; &kappa;&alpha;&iota; &sigma;έ&xi;&iota;.<br /><br />&Delta;&iota;&pi;&lambda;ή &zeta;ώ&nu;&eta; &sigma;&iota;&lambda;&iota;&kappa;ό&nu;&eta;&sigmaf;, &epsilon;&nu;&iota;&sigma;&chi;&upsilon;&mu;έ&nu;&eta; &phi;&tau;έ&rho;&nu;&alpha; &kappa;&alpha;&iota; &mu;ύ&tau;&eta;.<br /><br />&Pi;&omicron;&lambda;ύ &mu;&alpha;&lambda;&alpha;&kappa;ό.<br /><br />60 Denier/66 Datex
guid
stringhttps://dev.divasboudoir.com/el/megalo-megethos-adiafaneis-kaltses-60-den-mayro-ou-mpez/slau6935.htm
highlights
string
keypoint
string
keywords
stringαδιαφανείς κάλτσες, θερμικές, μεγάλο μέγεθος, άνεση, κομψές, σέξι, σιλικόνη, ενισχυμένες, μαλακές, 60 denier, Diva's Boudoir, εσώρουχα, θηλυκότητα
metas
Struct
description
stringΠαχιά, αδιαφανή, αυτοκόλλητα, πολύ ισχυρά συγκρατητικά.
keywords
stringαδιαφανείς κάλτσες, θερμικές, μεγάλο μέγεθος, άνεση, κομψές, σέξι, σιλικόνη, ενισχυμένες, μαλακές, 60 denier, Diva's Boudoir, εσώρουχα, θηλυκότητα
title
stringΜεγάλο μέγεθος αδιαφανείς κάλτσες 60 Den
seotitle
stringΜεγάλο μέγεθος αδιαφανείς κάλτσες 60 Den
seouri
stringmegalo-megethos-adiafaneis-kaltses-60-den-mayro-ou-mpez
specifications
string
stylingtips
string
summary
string&Pi;&alpha;&chi;&iota;ά, &alpha;&delta;&iota;&alpha;&phi;&alpha;&nu;ή, &alpha;&upsilon;&tau;&omicron;&kappa;ό&lambda;&lambda;&eta;&tau;&alpha;, &pi;&omicron;&lambda;ύ &iota;&sigma;&chi;&upsilon;&rho;ά &sigma;&upsilon;&gamma;&kappa;&rho;&alpha;&tau;&eta;&tau;&iota;&kappa;ά.
title
stringΑδιαφανείς κάλτσες 60 Den
usageinstructions
string
en
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringStockings for winter.<br /><br />Opaque and thick, they're very, very sturdy, yet feminine and sexy.<br /><br />Double silicone band, reinforced heel and toe.<br /><br />Very soft.<br /><br />60 Denier/66 Datex
guid
stringhttps://dev.divasboudoir.com/en/opaque-plus-size-stockings-60-den-black-ou-beige/slau6935.htm
highlights
string
keypoint
string
keywords
stringopaque stockings, thermal, plus size, comfort, elegant, sexy, silicone, reinforced, soft, 60 denier, Diva's Boudoir, lingerie, femininity
metas
Struct
description
stringThick, opaque, self-fastening, extra-strong plus size stockings.
keywords
stringopaque stockings, thermal, plus size, comfort, elegant, sexy, silicone, reinforced, soft, 60 denier, Diva's Boudoir, lingerie, femininity
title
stringOpaque plus size stockings 60 Den
seotitle
stringOpaque plus size stockings 60 Den
seouri
stringopaque-plus-size-stockings-60-den-black-ou-beige
specifications
string
stylingtips
string
summary
stringThick, opaque, self-fastening, extra-strong plus size stockings.
title
stringOpaque stockings 60 Den
usageinstructions
string
es
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringMedias para el invierno.<br /><br />Opacas y gruesas, son muy, muy resistentes, pero siguen siendo muy femeninas y sexys.<br /><br />Doble banda de silicona, tal&oacute;n y puntera reforzados.<br /><br />Muy suaves.<br /><br />60 Denier/66 Datex
guid
stringhttps://dev.divasboudoir.com/es/medias-opacas-de-talla-grande-60-den-negro-ou-beige/slau6935.htm
highlights
string
keypoint
string
keywords
stringmedias opacas, térmicas, talla grande, comodidad, elegantes, sexy, silicona, reforzadas, suaves, 60 deniers, Diva's Boudoir, lencería, feminidad
metas
Struct
description
stringMedias gruesas, opacas, autoadherentes y de talla grande.
keywords
stringmedias opacas, térmicas, talla grande, comodidad, elegantes, sexy, silicona, reforzadas, suaves, 60 deniers, Diva's Boudoir, lencería, feminidad
title
stringMedias opacas de talla grande 60 Den
seotitle
stringMedias opacas de talla grande 60 Den
seouri
stringmedias-opacas-de-talla-grande-60-den-negro-ou-beige
specifications
string
stylingtips
string
summary
stringMedias gruesas, opacas, autoadherentes y de talla grande.
title
stringMedias opacas 60 Den
usageinstructions
string
fr
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Laissez-vous s&eacute;duire par ces bas magnifiques, parfaits pour toutes les saisons fra&icirc;ches. Leur opacit&eacute; et leur &eacute;paisseur vous offriront une protection optimale contre le froid, tout en sublimant vos jambes avec &eacute;l&eacute;gance.</p> <p class="text-base">Tr&egrave;s solides et r&eacute;sistants, ils vous accompagneront avec style au quotidien. La double bande de silicone garantit un maintien parfait, tandis que le talon et la pointe renforc&eacute;s assurent une durabilit&eacute; accrue.</p> <p class="text-base">Confectionn&eacute;s dans une mati&egrave;re douce et agr&eacute;able &agrave; porter, ils vous procureront une sensation de bien-&ecirc;tre in&eacute;galable. Avec un grammage de 60 deniers et 66 DTEX, ces bas allient confort, r&eacute;sistance et &eacute;l&eacute;gance.</p> </div>
guid
stringhttps://dev.divasboudoir.com/fr/bas-opaques-thermiques-grande-taille-lingerie-divas-boudoir-noir-ou-beige/slau6935.htm
highlights
string
keypoint
string
keywords
stringbas opaques, thermiques, grande taille, confort, élégant, sexy, silicone, renforcés, doux, 60 deniers, Diva's Boudoir, lingerie, féminité
metas
Struct
description
stringDécouvrez nos bas opaques et thermiques, conçus pour les grandes tailles. Chaleur, confort et élégance sur Diva's Boudoir. 60 deniers.
keywords
stringbas opaques, thermiques, grande taille, confort, élégant, sexy, silicone, renforcés, doux, 60 deniers, Diva's Boudoir, lingerie, féminité
title
stringBas Opaques Thermiques Grande Taille | Diva's Boudoir
seotitle
stringBas Opaques Thermiques Grande Taille Lingerie Diva's Boudoir
seouri
stringbas-opaques-thermiques-grande-taille-lingerie-divas-boudoir-noir-ou-beige
specifications
string
stylingtips
string
summary
string<p>Affrontez les saisons fra&icirc;ches avec &eacute;l&eacute;gance gr&acirc;ce &agrave; ces bas opaques et &eacute;pais, con&ccedil;us pour sublimer votre f&eacute;minit&eacute; avec confort et sensualit&eacute;. Un indispensable pour un look chaleureux et raffin&eacute;.</p>
title
stringBas Opaques Thermiques - Élégance & Confort
usageinstructions
string
it
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringCalze per l'inverno.<br /><br />Opache e spesse, sono molto, molto robuste, ma sempre molto femminili e sexy.<br /><br />Doppia banda in silicone, tallone e punta rinforzati.<br /><br />Molto morbide.<br /><br />60 denari/66 Datex
guid
stringhttps://dev.divasboudoir.com/it/calze-coprenti-di-grande-taglia-60-den-nero-ou-beige/slau6935.htm
highlights
string
keypoint
string
keywords
stringcalze coprenti, termiche, taglia grande, comfort, eleganti, sexy, silicone, rinforzate, morbide, 60 denari, Diva's Boudoir, lingerie, femminilità
metas
Struct
description
stringAutoreggenti spesse, opache, autofissanti e di taglia grande.
keywords
stringcalze coprenti, termiche, taglia grande, comfort, eleganti, sexy, silicone, rinforzate, morbide, 60 denari, Diva's Boudoir, lingerie, femminilità
title
stringCalze coprenti di grande taglia 60 Den
seotitle
stringCalze coprenti di grande taglia 60 Den
seouri
stringcalze-coprenti-di-grande-taglia-60-den-nero-ou-beige
specifications
string
stylingtips
string
summary
stringAutoreggenti spesse, opache, autofissanti e di taglia grande.
title
stringCalze coprenti 60 Den
usageinstructions
string
nl
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringKousen voor de winter.<br /><br />Ondoorzichtig en dik, ze zijn heel, heel stevig, maar toch heel vrouwelijk en sexy.<br /><br />Dubbele siliconenband, verstevigde hiel en teen.<br /><br />Zeer zacht.<br /><br />60 denier/66 Datex
guid
stringhttps://dev.divasboudoir.com/nl/groote-maat-ondoorzichtige-kousen-60-den-zwart-ou-beige/slau6935.htm
highlights
string
keypoint
string
keywords
stringondoorzichtige kousen, thermisch, grote maat, comfort, elegant, sexy, siliconen, versterkt, zacht, 60 denier, Diva's Boudoir, lingerie, vrouwelijkheid
metas
Struct
description
stringDikke, ondoorzichtige, zelfbevestigende, groote maten.
keywords
stringondoorzichtige kousen, thermisch, grote maat, comfort, elegant, sexy, siliconen, versterkt, zacht, 60 denier, Diva's Boudoir, lingerie, vrouwelijkheid
title
stringGroote maat ondoorzichtige kousen 60 Den
seotitle
stringGroote maat ondoorzichtige kousen 60 Den
seouri
stringgroote-maat-ondoorzichtige-kousen-60-den-zwart-ou-beige
specifications
string
stylingtips
string
summary
stringDikke, ondoorzichtige, zelfbevestigende, groote maten.
title
stringOndoorzichtige kousen 60 Den
usageinstructions
string
pt
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringMeias para o inverno.<br /><br />Opacas e grossas, s&atilde;o muito, muito resistentes, mas ainda assim muito femininas e sensuais.<br /><br />Banda dupla de silicone, calcanhar e biqueira refor&ccedil;ados.<br /><br />Muito macias.<br /><br />60 Denier/66 Datex
guid
stringhttps://dev.divasboudoir.com/pt/meias-opacas-de-tamanho-grande-60-den-preto-ou-bege/slau6935.htm
highlights
string
keypoint
string
keywords
stringmeias opacas, térmicas, tamanho grande, conforto, elegante, sexy, silicone, reforçadas, macias, 60 denier, Diva's Boudoir, lingerie, feminilidade
metas
Struct
description
stringMeias espessos, opacos, auto-fixantes e extra-fortes.
keywords
stringmeias opacas, térmicas, tamanho grande, conforto, elegante, sexy, silicone, reforçadas, macias, 60 denier, Diva's Boudoir, lingerie, feminilidade
title
stringMeias opacas de tamanho grande 60 Den
seotitle
stringMeias opacas de tamanho grande 60 Den
seouri
stringmeias-opacas-de-tamanho-grande-60-den-preto-ou-bege
specifications
string
stylingtips
string
summary
stringMeias espessos, opacos, auto-fixantes e extra-fortes.
title
stringMeias opacas 60 Den
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-ou-beige
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-ou-mpez
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-ou-beige
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-ou-beige
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-ou-beige
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-ou-beige
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-ou-beige
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-ou-bege
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-ou-beige
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-ou-mpez
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-ou-beige
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-ou-beige
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-ou-beige
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-ou-beige
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-ou-beige
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-ou-bege
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
legsboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringWunderschöne Strümpfe für alle kühlen Jahreszeiten.<br /><br />Sie sind blickdicht und dick, sehr, sehr robust und trotzdem super feminin und sexy.<br /><br />Doppeltes Silikonband, verstärkte Ferse und Spitze.<br /><br />Sehr weich und geschmeidig.<br /><br />60 Denier/66 Datex
highlights
string
keypoint
string
keywords
stringblickdichte, thermische Strümpfe, große Größe, Komfort, elegant, sexy, Silikon, verstärkt, weich, 60 Denier, Leg's Boudoir, geformte Beine, alle Größen, Winter
metas
Struct
description
stringBlickdichte Strümpfe in großen Größen: solide und sexy für die kühleren Jahreszeiten. Doppeltes Silikonband, verstärkte Ferse/Spitze. XXL-Feminität garantiert
keywords
stringblickdichte, thermische Strümpfe, große Größe, Komfort, elegant, sexy, Silikon, verstärkt, weich, 60 Denier, Leg's Boudoir, geformte Beine, alle Größen, Winter
title
stringBlickdichte Strümpfe in großen Größen: solide und sexy für die kühleren Jahreszeiten.
seotitle
stringStrümpfe große Größe selbstfixierend opak 60 Den
seouri
stringstrumpfe-grosse-grosse-selbstfixierend-opak-60-den-schwarz-ou-beige
specifications
string
stylingtips
string
summary
stringStrümpfe 60 Den, dick und blickdicht, selbstfixierend und sehr stabil.
title
stringOpake selbstfixierende Strümpfe 60 Den
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringΥπέροχες κάλτσες για όλες τις δροσερές εποχές.<br /><br />Αδιαφανείς και χοντρές, είναι πολύ, πολύ ανθεκτικές, αλλά ταυτόχρονα εξαιρετικά θηλυκές και σέξι.<br /><br />Διπλή ζώνη σιλικόνης, ενισχυμένη φτέρνα και μύτη.<br /><br />Πολύ απαλές.<br /><br />60 Denier/66 Datex
highlights
string
keypoint
string
keywords
stringαδιαφανείς κάλτσες, θερμικές, μεγάλες, άνεση, κομψές, σέξι, σιλικόνη, ενισχυμένες, μαλακές, 60 denier, Leg's Boudoir, καλοσχηματισμένα πόδια, όλα τα μεγέθη, χειμώνας
metas
Struct
description
stringΜεγάλες αδιαφανείς κάλτσες: δυνατές και σέξι για τις πιο δροσερές εποχές. Διπλή ζώνη σιλικόνης, ενισχυμένη φτέρνα και μύτη. Εγγυημένη θηλυκότητα XXL
keywords
stringαδιαφανείς κάλτσες, θερμικές, μεγάλες, άνεση, κομψές, σέξι, σιλικόνη, ενισχυμένες, μαλακές, 60 denier, Leg's Boudoir, καλοσχηματισμένα πόδια, όλα τα μεγέθη, χειμώνας
title
stringΜεγάλες αδιαφανείς κάλτσες: δυνατές και σέξι για τις πιο δροσερές εποχές.
seotitle
stringΜεγάλο μέγεθος αδιαφανών hold ups 60 Den
seouri
stringmegalo-megethos-adiafanwn-hold-ups-60-den-mayro-ou-mpez
specifications
string
stylingtips
string
summary
stringΠυκνές, αδιαφανείς, αυτοκόλλητες, πολύ ισχυρές κάλτσες 60 Den.
title
stringΑδιαφανή hold ups 60 Den
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringBeautiful stockings for all cool seasons.<br /><br />Opaque and thick, they're very, very sturdy, yet feminine and sexy.<br /><br />Double silicone band, reinforced heel and toe.<br /><br />Very soft.<br /><br />60 Denier/66 Datex
highlights
string
keypoint
string
keywords
stringopaque stockings, thermal, plus size, comfort, elegant, sexy, silicone, reinforced, soft, 60 denier, Leg's Boudoir, shapely legs, all sizes, winter
metas
Struct
description
stringOpaque plus size stockings: strong and sexy for cooler seasons. Double silicone band, reinforced heel/toe. XXL femininity guaranteed
keywords
stringopaque stockings, thermal, plus size, comfort, elegant, sexy, silicone, reinforced, soft, 60 denier, Leg's Boudoir, shapely legs, all sizes, winter
title
stringOpaque stockings plus size: strong and sexy for cooler seasons.
seotitle
stringPlus size opaque hold ups 60 Den
seouri
stringplus-size-opaque-hold-ups-60-den-black-ou-beige
specifications
string
stylingtips
string
summary
string60 Den stockings, thick and opaque, self-fastening and very strong.
title
stringOpaque hold ups 60 Den
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringMagníficas medias para todas las estaciones frescas.<br /><br />Opacas y gruesas, son muy, muy resistentes, sin dejar de ser súper femeninas y sexys.<br /><br />Doble banda de silicona, talón y puntera reforzados.<br /><br />Muy suaves.<br /><br />60 Denier/66 Datex
highlights
string
keypoint
string
keywords
stringmedias opacas, térmicas, talla grande, comodidad, elegantes, sexy, silicona, reforzadas, suaves, 60 deniers, Leg's Boudoir, piernas torneadas, todas las tallas, invierno
metas
Struct
description
stringMedias opacas de talla grande: resistentes y sexys para las estaciones más frescas. Doble banda de silicona, talón y puntera reforzados. Feminidad XXL garantizada
keywords
stringmedias opacas, térmicas, talla grande, comodidad, elegantes, sexy, silicona, reforzadas, suaves, 60 deniers, Leg's Boudoir, piernas torneadas, todas las tallas, invierno
title
stringMedias opacas de talla grande: resistentes y sexys para las estaciones más frías.
seotitle
stringMedias opacas de talla grande 60 Den
seouri
stringmedias-opacas-de-talla-grande-60-den-negro-ou-beige
specifications
string
stylingtips
string
summary
stringMedias 60 Den gruesas, opacas, autoadherentes y muy resistentes.
title
stringMedias opacas 60 Den
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Craquez pour ces bas magnifiques, parfaits pour toutes les saisons fra&icirc;ches. Leur opacit&eacute; et leur &eacute;paisseur vous offriront une protection optimale contre le froid, sans sacrifier votre f&eacute;minit&eacute;.</p> <p class="text-base">Tr&egrave;s solides et r&eacute;sistants, ils vous accompagneront avec style au quotidien. La double bande de silicone garantit un maintien parfait, tandis que le talon et la pointe renforc&eacute;s assurent une durabilit&eacute; accrue.</p> <p class="text-base">Confectionn&eacute;s dans une mati&egrave;re douce et agr&eacute;able &agrave; porter, ils vous procureront une sensation de bien-&ecirc;tre in&eacute;galable. Avec un grammage de 60 deniers et 66 DTEX, ces bas allient confort, r&eacute;sistance et &eacute;l&eacute;gance. Sp&eacute;cialement pens&eacute;s pour les grandes tailles.</p> </div>
highlights
string
keypoint
string
keywords
stringbas opaques, thermiques, grande taille, confort, élégant, sexy, silicone, renforcés, doux, 60 deniers, Leg's Boudoir, jambes galbées, toutes tailles, hiver
metas
Struct
description
stringDécouvrez nos bas opaques et thermiques, spécialement conçus pour les femmes rondes. Confort, chaleur et grande taille disponibles sur Leg's Boudoir. 60 deniers.
keywords
stringbas opaques, thermiques, grande taille, confort, élégant, sexy, silicone, renforcés, doux, 60 deniers, Leg's Boudoir, jambes galbées, toutes tailles, hiver
title
stringBas Opaques Thermiques Grande Taille Hiver | Leg's Boudoir
seotitle
stringBas Opaques Luxe Grande Taille Hiver Leg's Boudoir
seouri
stringbas-opaques-luxe-grande-taille-hiver-legs-boudoir-noir-ou-beige
specifications
string
stylingtips
string
summary
string<p>Affrontez les saisons fra&icirc;ches avec &eacute;l&eacute;gance gr&acirc;ce &agrave; ces bas opaques et &eacute;pais, con&ccedil;us pour sublimer toutes les silhouettes avec confort et sensualit&eacute;. Un indispensable pour un look f&eacute;minin et chaleureux.</p>
title
stringBas Opaques de Luxe - Confort & Élégance
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringMagnifiche calze per tutte le stagioni fredde.<br /><br />Opache e spesse, sono molto, molto robuste, ma sempre super femminili e sexy.<br /><br />Doppia banda in silicone, tallone e punta rinforzati.<br /><br />Molto morbide.<br /><br />60 denari/66 Datex
highlights
string
keypoint
string
keywords
stringcalze coprenti, termiche, taglia grande, comfort, eleganti, sexy, silicone, rinforzate, morbide, 60 denari, Leg's Boudoir, gambe formose, tutte le taglie, inverno
metas
Struct
description
stringCalze coprenti di grande taglia: forti e sexy per le stagioni più fresche. Doppia banda in silicone, tallone e punta rinforzati. Femminilità XXL garantita
keywords
stringcalze coprenti, termiche, taglia grande, comfort, eleganti, sexy, silicone, rinforzate, morbide, 60 denari, Leg's Boudoir, gambe formose, tutte le taglie, inverno
title
stringCalze grandi e coprenti: forti e sexy per le stagioni più fredde.
seotitle
stringTaglia grande autoreggenti opachi 60 Den
seouri
stringtaglia-grande-autoreggenti-opachi-60-den-nero-ou-beige
specifications
string
stylingtips
string
summary
stringCalze spesse, opache, autoaderenti e molto resistenti 60 Den.
title
stringCalze opachi 60 Den
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringPrachtige kousen voor alle koele seizoenen.<br /><br />Ondoorzichtig en dik, ze zijn heel erg stevig, maar toch super vrouwelijk en sexy.<br /><br />Dubbele siliconenband, verstevigde hiel en teen.<br /><br />Zeer zacht.<br /><br />60 Denier/66 Datex
highlights
string
keypoint
string
keywords
stringondoorzichtige kousen, thermisch, grote maat, comfort, elegant, sexy, siliconen, verstevigd, zacht, 60 denier, Leg's Boudoir, mooie benen, alle maten, winter
metas
Struct
description
stringGrote ondoorzichtige kousen: sterk en sexy voor koelere seizoenen. Dubbele siliconen band, verstevigde hiel en teen. XXL vrouwelijkheid gegarandeerd
keywords
stringondoorzichtige kousen, thermisch, grote maat, comfort, elegant, sexy, siliconen, verstevigd, zacht, 60 denier, Leg's Boudoir, mooie benen, alle maten, winter
title
stringGrote ondoorzichtige kousen: sterk en sexy voor koelere seizoenen.
seotitle
stringGroote maat ondoorzichtige kousen 60 Den
seouri
stringgroote-maat-ondoorzichtige-kousen-60-den-zwart-ou-beige
specifications
string
stylingtips
string
summary
stringDikke, ondoorzichtige, zelfsluitende, zeer sterke 60 Den kousen.
title
stringOndoorzichtige kousen 60 Den
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringMeias magníficas para todas as estações frias.<br /><br />Opacas e grossas, são muito, muito resistentes, mas ainda assim super femininas e sensuais.<br /><br />Banda dupla de silicone, calcanhar e biqueira reforçados.<br /><br />Muito macias.<br /><br />60 Denier/66 Datex
highlights
string
keypoint
string
keywords
stringmeias opacas, térmicas, grandes, conforto, elegantes, sexy, silicone, reforçadas, macias, 60 denier, Leg's Boudoir, pernas torneadas, todos os tamanhos, inverno
metas
Struct
description
stringMeias grandes opacas: fortes e sensuais para as estações mais frias. Banda dupla de silicone, calcanhar e biqueira reforçados. Feminilidade XXL garantida
keywords
stringmeias opacas, térmicas, grandes, conforto, elegantes, sexy, silicone, reforçadas, macias, 60 denier, Leg's Boudoir, pernas torneadas, todos os tamanhos, inverno
title
stringMeias grandes opacas: fortes e sensuais para as estações mais frias.
seotitle
stringAgarras opacas de tamanho grande 60 Den
seouri
stringagarras-opacas-de-tamanho-grande-60-den-preto-ou-bege
specifications
string
stylingtips
string
summary
stringMeias 60 Den grossas, opacas, auto-fixantes e muito resistentes.
title
stringAgarras opacas 60 Den
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-ou-beige
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-ou-mpez
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-ou-beige
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-ou-beige
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-ou-beige
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-ou-beige
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-ou-beige
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-ou-bege
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
smboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringStr&uuml;mpfe f&uuml;r den Winter.<br /><br />Sie sind blickdicht und dick, sehr, sehr robust und trotzdem super feminin und sexy.<br /><br />Doppeltes Silikonband, verst&auml;rkte Ferse und Spitze.<br /><br />Sehr weich und angenehm zu tragen.<br /><br />60 Denier/66 Datex
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringDicke, blickdichte, selbstfixierende Strümpfe mit hoher Festigkeit.
keywords
stringblickdichte Strümpfe, Thermos, große Größen, BDSM, Fetisch, Unterwerfung, sexy, Silikon, verstärkt, weich, 60 Denier, The Bdsm Boudoir, Dominanz
title
stringBlickdichte Strümpfe
seotitle
stringBlickdichte Strümpfe
seouri
stringblickdichte-strumpfe-schwarz-ou-beige
specifications
string
stylingtips
string
summary
stringDicke, blickdichte, selbstfixierende Str&uuml;mpfe mit hoher Festigkeit.
title
stringBlickdichte Strümpfe
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string&Kappa;ά&lambda;&tau;&sigma;&epsilon;&sigmaf; &gamma;&iota;&alpha; &tau;&omicron; &chi;&epsilon;&iota;&mu;ώ&nu;&alpha;.<br /><br />&Alpha;&delta;&iota;&alpha;&phi;&alpha;&nu;&epsilon;ί&sigmaf; &kappa;&alpha;&iota; &chi;&omicron;&nu;&tau;&rho;έ&sigmaf;, &epsilon;ί&nu;&alpha;&iota; &pi;&omicron;&lambda;ύ, &pi;&omicron;&lambda;ύ &alpha;&nu;&theta;&epsilon;&kappa;&tau;&iota;&kappa;έ&sigmaf;, &alpha;&lambda;&lambda;ά &epsilon;&xi;&alpha;&kappa;&omicron;&lambda;&omicron;&upsilon;&theta;&omicron;ύ&nu; &nu;&alpha; &epsilon;ί&nu;&alpha;&iota; &pi;&omicron;&lambda;ύ &theta;&eta;&lambda;&upsilon;&kappa;έ&sigmaf; &kappa;&alpha;&iota; &sigma;έ&xi;&iota;.<br /><br />&Delta;&iota;&pi;&lambda;ή &zeta;ώ&nu;&eta; &sigma;&iota;&lambda;&iota;&kappa;ό&nu;&eta;&sigmaf;, &epsilon;&nu;&iota;&sigma;&chi;&upsilon;&mu;έ&nu;&eta; &phi;&tau;έ&rho;&nu;&alpha; &kappa;&alpha;&iota; &mu;ύ&tau;&eta;.<br /><br />&Mu;&alpha;&lambda;&alpha;&kappa;ά &kappa;&alpha;&iota; ά&nu;&epsilon;&tau;&alpha; &sigma;&tau;&eta; &chi;&rho;ή&sigma;&eta;.<br /><br />60 Denier/66 Datex
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringΠαχύ, αδιαφανές, αυτοκόλλητο και πολύ ισχυρό.
keywords
stringαδιαφανείς κάλτσες, θερμικές, μεγάλο μέγεθος, BDSM, φετίχ, υποταγή, σέξι, σιλικόνη, ενισχυμένη, μαλακή, 60 denier, The Bdsm Boudoir, κυριαρχία
title
stringΑδιαφανείς κάλτσες
seotitle
stringΑδιαφανείς κάλτσες
seouri
stringadiafaneis-kaltses-mayro-ou-mpez
specifications
string
stylingtips
string
summary
string&Pi;&alpha;&chi;ύ, &alpha;&delta;&iota;&alpha;&phi;&alpha;&nu;έ&sigmaf;, &alpha;&upsilon;&tau;&omicron;&kappa;ό&lambda;&lambda;&eta;&tau;&omicron; &kappa;&alpha;&iota; &pi;&omicron;&lambda;ύ &iota;&sigma;&chi;&upsilon;&rho;ό.
title
stringΑδιαφανείς κάλτσες
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringStockings for winter.<br /><br />Opaque and thick, they're very, very sturdy, yet feminine and sexy.<br /><br />Double silicone band, reinforced heel and toe.<br /><br />Soft and pleasant to wear.<br /><br />60 Denier/66 Datex
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringThick, opaque, self-ties and very strong.
keywords
stringopaque stockings, thermal, plus size, BDSM, fetish, submission, sexy, silicone, reinforced, soft, 60 denier, The Bdsm Boudoir, domination
title
stringOpaque stockings
seotitle
stringOpaque stockings
seouri
stringopaque-stockings-black-ou-beige
specifications
string
stylingtips
string
summary
stringThick, opaque, self-ties and very strong.
title
stringOpaque stockings
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringMedias para el invierno.<br /><br />Opacas y gruesas, son muy, muy resistentes, pero siguen siendo muy femeninas y sexys.<br /><br />Doble banda de silicona, tal&oacute;n y puntera reforzados.<br /><br />Suaves y c&oacute;modas de llevar.<br /><br />60 Denier/66 Datex
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringGruesa, opaca, se anuda sola y es muy resistente.
keywords
stringmedias opacas, térmicas, talla grande, BDSM, fetiche, sumisión, sexy, silicona, reforzadas, suaves, 60 deniers, The BDSM Boudoir, dominación
title
stringMedias opacas
seotitle
stringMedias opacas
seouri
stringmedias-opacas-negro-ou-beige
specifications
string
stylingtips
string
summary
stringGruesa, opaca, se anuda sola y es muy resistente.
title
stringMedias opacas
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Osez la transgression avec ces bas magnifiques, parfaits pour toutes les saisons fra&icirc;ches. Leur opacit&eacute; et leur &eacute;paisseur vous offriront une protection optimale contre le froid, tout en sublimant vos courbes avec sensualit&eacute;.</p> <p class="text-base">Tr&egrave;s solides et r&eacute;sistants, ils vous accompagneront avec style au quotidien. La double bande de silicone garantit un maintien parfait, m&ecirc;me lors des jeux les plus intenses. Le talon et la pointe renforc&eacute;s assurent une durabilit&eacute; accrue.</p> <p class="text-base">Confectionn&eacute;s dans une mati&egrave;re douce et agr&eacute;able &agrave; porter, ils vous procureront une sensation de bien-&ecirc;tre in&eacute;galable. Avec un grammage de 60 deniers et 66 DTEX, ces bas allient confort, r&eacute;sistance et &eacute;l&eacute;gance. Sp&eacute;cialement con&ccedil;us pour les grandes tailles.</p> </div>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringDécouvrez nos bas opaques et thermiques, spécialement conçus pour les grandes tailles et parfaits pour vos jeux BDSM. Chaleur, soumission et tentation sur The Bdsm Boudoir. 60 deniers.
keywords
stringbas opaques, thermiques, grande taille, BDSM, fétichiste, soumission, sexy, silicone, renforcés, doux, 60 deniers, The Bdsm Boudoir, domination
title
stringBas Opaques Thermiques Grande Taille BDSM | The Bdsm Boudoir
seotitle
stringBas Opaques Luxe Grande Taille BDSM - The Bdsm Boudoir
seouri
stringbas-opaques-luxe-grande-taille-bdsm--the-bdsm-boudoir-noir-ou-beige
specifications
string
stylingtips
string
summary
string<p>Enveloppez vos jambes de chaleur et de myst&egrave;re avec ces bas opaques et &eacute;pais. Un symbole de sensualit&eacute; interdite et de soumission hivernale, pour des jeux sans limites.</p>
title
stringBas Opaques Luxe - Chaleur Interdite
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringCalze per l'inverno.<br /><br />Opache e spesse, sono molto, molto robuste, ma sempre molto femminili e sexy.<br /><br />Doppia banda in silicone, tallone e punta rinforzati.<br /><br />Morbide e confortevoli da indossare.<br /><br />60 denari/66 Datex
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringSpessa, opaca, auto-legante e molto resistente.
keywords
stringcalze coprenti, termiche, taglia grande, BDSM, fetish, sottomissione, sexy, silicone, rinforzato, morbido, 60 denari, The BDSM Boudoir, dominazione
title
stringCalze coprenti
seotitle
stringCalze coprenti
seouri
stringcalze-coprenti-nero-ou-beige
specifications
string
stylingtips
string
summary
stringSpessa, opaca, auto-legante e molto resistente.
title
stringCalze coprenti
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringKousen voor de winter.<br /><br />Ondoorzichtig en dik, ze zijn heel, heel stevig, maar toch heel vrouwelijk en sexy.<br /><br />Dubbele siliconenband, verstevigde hiel en teen.<br /><br />Zacht en comfortabel om te dragen.<br /><br />60 Denier/66 Datex
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringDik, ondoorzichtig, zelfbindend en zeer sterk.
keywords
stringondoorzichtige kousen, thermisch, grote maat, BDSM, fetisj, onderwerping, sexy, siliconen, verstevigd, zacht, 60 denier, The BDSM Boudoir, dominantie
title
stringOndoorzichtige kousen
seotitle
stringOndoorzichtige kousen
seouri
stringondoorzichtige-kousen-zwart-ou-beige
specifications
string
stylingtips
string
summary
stringDik, ondoorzichtig, zelfbindend en zeer sterk.
title
stringOndoorzichtige kousen
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringMeias para o inverno.<br /><br />Opacas e grossas, s&atilde;o muito, muito resistentes, mas ainda assim muito femininas e sensuais.<br /><br />Banda dupla de silicone, calcanhar e biqueira refor&ccedil;ados.<br /><br />Suaves e confort&aacute;veis de usar.<br /><br />60 Denier/66 Datex
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringEspesso, opaco, autoadesivo e muito forte.
keywords
stringmeias opacas, térmicas, tamanho grande, BDSM, fetiche, submissão, sexy, silicone, reforçadas, macias, 60 denier, The Bdsm Boudoir, dominação
title
stringMeias opacas
seotitle
stringMeias opacas
seouri
stringmeias-opacas-preto-ou-bege
specifications
string
stylingtips
string
summary
stringEspesso, opaco, autoadesivo e muito forte.
title
stringMeias opacas
usageinstructions
string
name
string50118 Mrco 60
netweight
string
nextshipment
stringtomorrow
ordered
number95
orderidx
number0
origin
stringeu
originalsize
string
packaging
string
productshipment
stringauto
productuid
string3DB4EDC9-8296-48E4-B8AB159A91DEEF3F
promountil
string
rating
stringnone
recorduid
string3DB4EDC9-8296-48E4-B8AB159A91DEEF3F
reference
stringSLAU6935
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.61 ms
Record Count: 12
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 = '3DB4EDC9-8296-48E4-B8AB159A91DEEF3F'
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
210394intlsizebeige44-19999990wplusstocking4-M440-4210-1214-1642-4442-4440-4246-4842-4440-4249-55
310405intlsizebeige55-19999991wplusstocking5-L542-4412-1416-1844-4644-4642-4448-5044-4642-4456-62
410405intlsizeblack55-19999990wplusstocking5-L542-4412-1416-1844-4644-4642-4448-5044-4642-4456-62
510416intlsizebeige66-19999992wplusstocking6-XL646-4816-1820-2248-5048-5046-4852-5448-5046-4862-69
610416intlsizeblack66-19999992wplusstocking6-XL646-4816-1820-2248-5048-5046-4852-5448-5046-4862-69
710427intlsizebeige77-19999992wplusstocking7-2XL748-5018-2022-2450-5250-5248-5054-5650-5248-5069-76
810427intlsizeblack77-19999991wplusstocking7-2XL748-5018-2022-2450-5250-5248-5054-5650-5248-5069-76
910438intlsizeblack88-19999990wplusstocking8-3XL850-5220-2224-2652-5452-5450-5256-5852-5450-5276-83
1010438intlsizebeige88-19999990wplusstocking8-3XL850-5220-2224-2652-5452-5450-5256-5852-5450-5276-83
1110449intlsizebeige99-19999991wplusstocking9-4XL952-5422-2426-2854-5654-5652-5458-6054-5652-5483-89
1210449intlsizeblack99-19999991wplusstocking9-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: 42 ms
Record Count: 12
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 = '3DB4EDC9-8296-48E4-B8AB159A91DEEF3F'
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 = '3DB4EDC9-8296-48E4-B8AB159A91DEEF3F'
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 = '3DB4EDC9-8296-48E4-B8AB159A91DEEF3F'
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 = '3DB4EDC9-8296-48E4-B8AB159A91DEEF3F'
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 = '3DB4EDC9-8296-48E4-B8AB159A91DEEF3F'
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 = '3DB4EDC9-8296-48E4-B8AB159A91DEEF3F'
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
13DB4EDC9-8296-48E4-B8AB159A91DEEF3F5ABFE4F0-2645-4788-B0E90F3A0EDA082A1039beige#F6DBAC4-M440-4210-1214-1642-4442-4440-4246-4842-4440-42wstocking4intlsize20.79170STOCK01000-10100501184260277131210-10all
23DB4EDC9-8296-48E4-B8AB159A91DEEF3F4525FE5F-53B0-40B6-B54F7C1CBC018EAB1039black#0000004-M440-4210-1214-1642-4442-4440-4246-4842-4440-42wstocking4intlsize20.79170STOCK01000-10300501184260277131159-10all
33DB4EDC9-8296-48E4-B8AB159A91DEEF3FD29FBB18-F03E-454A-B187F702F5362FE51040beige#F6DBAC5-L542-4412-1416-1844-4644-4642-4448-5044-4642-44wstocking5intlsize20.79170STOCK01100-1020050118426027713122711all
43DB4EDC9-8296-48E4-B8AB159A91DEEF3FAF28BE6C-E0E9-4EAB-8BFF20C6454A9C551040black#0000005-L542-4412-1416-1844-4644-4642-4448-5044-4642-44wstocking5intlsize20.79170STOCK01000-101400501184260277131166-10all
53DB4EDC9-8296-48E4-B8AB159A91DEEF3F3CC54FAB-ACAB-4E2E-ABEA5E674D9B51E51041beige#F6DBAC6-XL646-4816-1820-2248-5048-5046-4852-5448-5046-48wstocking6intlsize20.79170STOCK01200-1010050118426027713123422all
63DB4EDC9-8296-48E4-B8AB159A91DEEF3FF854A951-D158-4E7C-A0165C02BBFCCB261041black#0000006-XL646-4816-1820-2248-5048-5046-4852-5448-5046-48wstocking6intlsize20.79170STOCK01200-10150050118426027713117322all
73DB4EDC9-8296-48E4-B8AB159A91DEEF3F1D38759D-1442-4A99-BF4D333CC0E4FB161042beige#F6DBAC7-2XL748-5018-2022-2450-5250-5248-5054-5650-5248-50wstocking7intlsize20.79170STOCK01200-1040050118426027713124122all
83DB4EDC9-8296-48E4-B8AB159A91DEEF3F4FFD1947-45C6-4B62-98E0D19BA257AE5B1042black#0000007-2XL748-5018-2022-2450-5250-5248-5054-5650-5248-50wstocking7intlsize20.79170STOCK01100-10340250118426027713118011all
93DB4EDC9-8296-48E4-B8AB159A91DEEF3F3139B475-162D-42F6-BD292F97385C8A6F1043beige#F6DBAC8-3XL850-5220-2224-2652-5452-5450-5256-5852-5450-52wstocking8intlsize20.79170STOCK01000-10000501184260277131258-10all
103DB4EDC9-8296-48E4-B8AB159A91DEEF3FBAF56D22-DCD9-470B-8E5CF254C57A23511043black#0000008-3XL850-5220-2224-2652-5452-5450-5256-5852-5450-52wstocking8intlsize20.79170STOCK01000-102200501184260277131197-10all
113DB4EDC9-8296-48E4-B8AB159A91DEEF3F497B0846-5621-40AE-9CEDC315064ADF4D1044beige#F6DBAC9-4XL952-5422-2426-2854-5654-5652-5458-6054-5652-54wstocking9intlsize20.79170STOCK01100-1020050118426027713126511all
123DB4EDC9-8296-48E4-B8AB159A91DEEF3FDBD6EA5A-31AA-45CA-B845AC40260A69951044black#0000009-4XL952-5422-2426-2854-5654-5652-5458-6054-5652-54wstocking9intlsize20.79170STOCK01200-11220050118426027713120311all
subcategory
stringstocking
supplier
number-1
supplierreference
string50118
tags
string
themes
string
totalvariations
string
type
stringdefault
unitprice
number20.7917
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 12.6 ms
Record Count: 12
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 = '3DB4EDC9-8296-48E4-B8AB159A91DEEF3F' 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 = '3DB4EDC9-8296-48E4-B8AB159A91DEEF3F' 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 = '3DB4EDC9-8296-48E4-B8AB159A91DEEF3F' 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 = '3DB4EDC9-8296-48E4-B8AB159A91DEEF3F' 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 = '3DB4EDC9-8296-48E4-B8AB159A91DEEF3F' 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 = '3DB4EDC9-8296-48E4-B8AB159A91DEEF3F' 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 = '3DB4EDC9-8296-48E4-B8AB159A91DEEF3F'
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 = '3DB4EDC9-8296-48E4-B8AB159A91DEEF3F' 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 = '3DB4EDC9-8296-48E4-B8AB159A91DEEF3F' 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 = '3DB4EDC9-8296-48E4-B8AB159A91DEEF3F' 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 = '3DB4EDC9-8296-48E4-B8AB159A91DEEF3F' 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 = '3DB4EDC9-8296-48E4-B8AB159A91DEEF3F' 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 = '3DB4EDC9-8296-48E4-B8AB159A91DEEF3F' 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 = '3DB4EDC9-8296-48E4-B8AB159A91DEEF3F'
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 = '3DB4EDC9-8296-48E4-B8AB159A91DEEF3F' 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 = '3DB4EDC9-8296-48E4-B8AB159A91DEEF3F' 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 = '3DB4EDC9-8296-48E4-B8AB159A91DEEF3F' 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 = '3DB4EDC9-8296-48E4-B8AB159A91DEEF3F' 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 = '3DB4EDC9-8296-48E4-B8AB159A91DEEF3F' 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 = '3DB4EDC9-8296-48E4-B8AB159A91DEEF3F' 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 = '3DB4EDC9-8296-48E4-B8AB159A91DEEF3F'
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 = '3DB4EDC9-8296-48E4-B8AB159A91DEEF3F' 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 = '3DB4EDC9-8296-48E4-B8AB159A91DEEF3F' 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 = '3DB4EDC9-8296-48E4-B8AB159A91DEEF3F' 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 = '3DB4EDC9-8296-48E4-B8AB159A91DEEF3F' 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 = '3DB4EDC9-8296-48E4-B8AB159A91DEEF3F' 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 = '3DB4EDC9-8296-48E4-B8AB159A91DEEF3F' 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 = '3DB4EDC9-8296-48E4-B8AB159A91DEEF3F'
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 = '3DB4EDC9-8296-48E4-B8AB159A91DEEF3F' 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 = '3DB4EDC9-8296-48E4-B8AB159A91DEEF3F' 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 = '3DB4EDC9-8296-48E4-B8AB159A91DEEF3F' 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 = '3DB4EDC9-8296-48E4-B8AB159A91DEEF3F' 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 = '3DB4EDC9-8296-48E4-B8AB159A91DEEF3F' 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 = '3DB4EDC9-8296-48E4-B8AB159A91DEEF3F' 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 = '3DB4EDC9-8296-48E4-B8AB159A91DEEF3F'
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 = '3DB4EDC9-8296-48E4-B8AB159A91DEEF3F' 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 = '3DB4EDC9-8296-48E4-B8AB159A91DEEF3F' 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 = '3DB4EDC9-8296-48E4-B8AB159A91DEEF3F' 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 = '3DB4EDC9-8296-48E4-B8AB159A91DEEF3F' 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 = '3DB4EDC9-8296-48E4-B8AB159A91DEEF3F' 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 = '3DB4EDC9-8296-48E4-B8AB159A91DEEF3F' 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 = '3DB4EDC9-8296-48E4-B8AB159A91DEEF3F'
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
15ABFE4F0-2645-4788-B0E90F3A0EDA082A1039beige#F6DBAC4-M440-4210-1214-1642-4442-4440-4246-4842-4440-42wstocking4intlsize20.79170STOCK01000-10100501184260277131210-10-10-16020.7917all
24525FE5F-53B0-40B6-B54F7C1CBC018EAB1039black#0000004-M440-4210-1214-1642-4442-4440-4246-4842-4440-42wstocking4intlsize20.79170STOCK01000-10300501184260277131159-10-10-14020.7917all
3D29FBB18-F03E-454A-B187F702F5362FE51040beige#F6DBAC5-L542-4412-1416-1844-4644-4642-4448-5044-4642-44wstocking5intlsize20.79170STOCK01100-1020050118426027713122711-11-16020.7917all
4AF28BE6C-E0E9-4EAB-8BFF20C6454A9C551040black#0000005-L542-4412-1416-1844-4644-4642-4448-5044-4642-44wstocking5intlsize20.79170STOCK01000-101400501184260277131166-10-11-14020.7917all
53CC54FAB-ACAB-4E2E-ABEA5E674D9B51E51041beige#F6DBAC6-XL646-4816-1820-2248-5048-5046-4852-5448-5046-48wstocking6intlsize20.79170STOCK01200-1010050118426027713123422-14-16020.7917all
6F854A951-D158-4E7C-A0165C02BBFCCB261041black#0000006-XL646-4816-1820-2248-5048-5046-4852-5448-5046-48wstocking6intlsize20.79170STOCK01200-10150050118426027713117322-14-14020.7917all
71D38759D-1442-4A99-BF4D333CC0E4FB161042beige#F6DBAC7-2XL748-5018-2022-2450-5250-5248-5054-5650-5248-50wstocking7intlsize20.79170STOCK01200-1040050118426027713124122-13-16020.7917all
84FFD1947-45C6-4B62-98E0D19BA257AE5B1042black#0000007-2XL748-5018-2022-2450-5250-5248-5054-5650-5248-50wstocking7intlsize20.79170STOCK01100-10340250118426027713118011-13-14020.7917all
93139B475-162D-42F6-BD292F97385C8A6F1043beige#F6DBAC8-3XL850-5220-2224-2652-5452-5450-5256-5852-5450-52wstocking8intlsize20.79170STOCK01000-10000501184260277131258-10-10-16020.7917all
10BAF56D22-DCD9-470B-8E5CF254C57A23511043black#0000008-3XL850-5220-2224-2652-5452-5450-5256-5852-5450-52wstocking8intlsize20.79170STOCK01000-102200501184260277131197-10-10-14020.7917all
11497B0846-5621-40AE-9CEDC315064ADF4D1044beige#F6DBAC9-4XL952-5422-2426-2854-5654-5652-5458-6054-5652-54wstocking9intlsize20.79170STOCK01100-1020050118426027713126511-12-16020.7917all
12DBD6EA5A-31AA-45CA-B845AC40260A69951044black#0000009-4XL952-5422-2426-2854-5654-5652-5458-6054-5652-54wstocking9intlsize20.79170STOCK01200-11220050118426027713120311-12-14020.7917all
vatrate
number20
warehouse
string