Mein Warenkorb

❌
Gesamtartikel
Zum Warenkorb
Menü
Siehe Größen
Mikrofaser- und Netzstrumpfhose
Doppelklicken Sie zum Vergrößern
SKU: SLTI8033
Mikrofaser- und Netzstrumpfhose
MADE IN
Lager:

Strumpfhose in großen Größen mit einem hübschen Höschen aus Mikrofaser und Netzbeinen. Ein toller Retro-Look.

Größe:

Sie wissen nicht, welche Größe Sie wählen sollen? Sehen Sie sich unseren Größenratgeber an

Farbe:
Menge:
29.95 €
Fundierte Ratschläge
per Chat, Facebook oder E-Mail
Kostenlose Rücksendungen
innerhalb von 15 Tagen *

Strumpfhose in großen Größen Mikrofaser und Netzstoff

Produktbeschreibung

Zeitloser Retro-Look für diese Mesh-Strumpfhose.
Mikrofaser, Netzoptik und perfekte Passform.
Das Höschen passt sich jeder Körperform an.

Verstärkte Höschen und Spitzen

Technische Details

Verfügbare Größen

Erhältlich von 38-40 bis 56-58

Verfügbare Farbe

Schwarz

Zusammensetzung

Polyamid 80 %
Elastan 20 %
To Top
Zum Warenkorb
Artikel
Gesamtartikel
Struct
Entries: 108
actions
Array
available
number-1
brand
stringglamory
brandcode
stringgjjm
branding
stringdivasboudoir,legsboudoir
brandmedias
string{"default":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"editorial":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"logo":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""}}
brandmetas
Struct
de
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
el
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
en
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
es
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
fr
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
it
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
nl
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
pt
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
brandname
stringGlamory
breasts
stringna
careinstructions
string
categories
stringdivasboudoir.lingerie.hoisery.tights
category
stringhoisery
categorygender
stringm
categorymediadatas
Struct
adult
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string410
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/lingerie/hoisery/tights.jpg
type
stringimg
width
string891
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.757 ms
Record Count: 1
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_colors.color as recorduid, product_colors.type, product_colors.code, product_colors.color, product_colors.range, product_colors.hexvalue,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock
from product_colors
left outer join product_variations on product_colors.color = product_variations.color and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
where FIND_IN_SET(product_colors.color,'black') > 0
and product_variations.productuid = '616509E5-A749-4AC2-B83E715A2B6BB6D9'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1blackcolorblakblackblack#000000-14
colorrange
stringblack
colors
stringblack
colortype
stringcolor
comments
string
compositions
Struct
Entries: 13
coton
string
elastane
string20
free
string
leather
string
lycra
string
metal
string
nylon
string
polyamide
string80
polyester
string
polyurethane
string
silk
string
spandex
string
viscose
string
datecreated
Date Time (Europe/Paris)
{ts '2019-10-09 17:05:32'}
defect
number0
dimensions
Struct
Entries: 14
acrylicbones
string
backsideheight
string
diameter
string
flatsteelbones
string
frontsideheight
string
fullheight
string
length
string
modestysize
string
panels
string
sides
string
spiralsteelbones
string
totallength
string
unit
stringcm
wiresize
string
display
stringall
displayfrom
string
displayto
string
grossweight
string
hasbrandinfos
booleanfalse
hascareinstructions
booleanfalse
hascolorinfos
booleantrue
hascompositions
booleantrue
hasdescription
booleantrue
hasdimensions
booleanfalse
hasmaterials
booleanfalse
hasotherspecifications
booleanfalse
haspromo
number0
hasshortdescription
booleantrue
hassizeinfos
booleantrue
hasspecifications
booleanfalse
hasstockinfos
booleanfalse
hasstylingtips
booleanfalse
hasusageinstructions
booleanfalse
hasvariations
booleantrue
import
string
inpromo
number0
instockvariations
string
isactive
number1
iscustommade
number0
isdivasize
number1
isfirstprice
number0
isfixedprice
number0
ishot
number0
isnew
number0
isonline
number0
isoutletprice
number0
itemprice
number24.9583
itempromo
string
key
string50351-mesh-collants
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-10-10 17:20:31'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.628 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','de')
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('616509e5-a749-4ac2-b83e715a2b6bb6d9',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','de')
and product_categories.language in ('all','de')
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 <> 'SLTI8033'
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
string804
isprivate
string0
rating
stringall
src
string/photobank/products/gjjm/slti8033/50351-mesh-black-plus-size_crop.jpg
type
stringimg
width
string643
back
Struct
height
string675
isprivate
string0
rating
stringall
src
string/photobank/products/gjjm/slti8033/50351-mesh-black-plus-size_crop_2.jpg
type
stringimg
width
string550
default
Struct
height
string1479
isprivate
string0
rating
stringall
src
string/photobank/products/gjjm/slti8033/50351.jpg
type
stringimg
width
string1081
variations
Struct
colors
Struct
black
Struct
height
string1479
isprivate
string0
rating
stringall
src
string/photobank/products/gjjm/slti8033/50351.jpg
type
stringimg
width
string1081
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
mediagallery
string
metadatas
Struct
darkboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
divasboudoir
Struct
de
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringZeitloser Retro-Look f&uuml;r diese Mesh-Strumpfhose.<br />Mikrofaser, Netzoptik und perfekte Passform.<br />Das H&ouml;schen passt sich jeder K&ouml;rperform an.<br /><br />Verst&auml;rkte H&ouml;schen und Spitzen
guid
stringhttps://dev.divasboudoir.com/de/strumpfhose-in-grossen-grossen-mikrofaser-und-netzstoff-schwarz/slti8033.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringStrumpfhose in großen Größen mit einem hübschen Höschen aus Mikrofaser und Netzbeinen. Ein toller Retro-Look.
keywords
string
title
stringStrumpfhose in großen Größen Mikrofaser und Netzstoff
seotitle
stringStrumpfhose in großen Größen Mikrofaser und Netzstoff
seouri
stringstrumpfhose-in-grossen-grossen-mikrofaser-und-netzstoff-schwarz
specifications
string
stylingtips
string
summary
stringStrumpfhose in gro&szlig;en Gr&ouml;&szlig;en mit einem h&uuml;bschen H&ouml;schen aus Mikrofaser und Netzbeinen. Ein toller Retro-Look.
title
stringMikrofaser- und Netzstrumpfhose
usageinstructions
string
el
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringΔιαχρονική ρετρό εμφάνιση για αυτό το καλσόν Mesh.<br />Μικροΐνες, εμφάνιση διχτυωτού υφάσματος και τέλειο σχήμα.<br />Το καλσόν προσαρμόζεται σε όλα τα σχήματα σώματος.<br /><br />Ενισχυμένο καλσόν και δάχτυλα των ποδιών
guid
stringhttps://dev.divasboudoir.com/el/megalo-kalson-apo-mikroΐnes-kai-dichtywto-kalson-mayro/slti8033.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringΚαλσόν plus-size με όμορφα εσώρουχα από μικροΐνες και δικτυωτά πόδια. Μια υπέροχη ρετρό εμφάνιση.
keywords
string
title
stringΜεγάλο καλσόν από μικροΐνες και διχτυωτό καλσόν
seotitle
stringΜεγάλο καλσόν από μικροΐνες και διχτυωτό καλσόν
seouri
stringmegalo-kalson-apo-mikroΐnes-kai-dichtywto-kalson-mayro
specifications
string
stylingtips
string
summary
stringΚαλσόν plus-size με όμορφα εσώρουχα από μικροΐνες και δικτυωτά πόδια. Μια υπέροχη ρετρό εμφάνιση.
title
stringΚαλσόν από μικροΐνες και διχτυωτό καλσόν
usageinstructions
string
en
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringTimeless retro look for these Mesh tights.<br />Microfiber, fishnet look and perfect shape.<br />The panty adapts to all body shapes.<br /><br />Reinforced panty and toe
guid
stringhttps://dev.divasboudoir.com/en/plus-size-microfiber-and-fishnet-tights-black/slti8033.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringPlus-size tights with pretty microfiber panties and fishnet legs. A great retro look.
keywords
string
title
stringPlus size microfiber and fishnet tights
seotitle
stringPlus size microfiber and fishnet tights
seouri
stringplus-size-microfiber-and-fishnet-tights-black
specifications
string
stylingtips
string
summary
stringPlus-size tights with pretty microfiber panties and fishnet legs. A great retro look.
title
stringMicrofiber and fishnet tights
usageinstructions
string
es
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringUn look retro atemporal para estas mallas Mesh.<br />Microfibra, aspecto de rejilla y forma perfecta.<br />Las braguitas se adaptan a todas las formas del cuerpo.<br /><br />Braguitas y punteras reforzadas
guid
stringhttps://dev.divasboudoir.com/es/medias-grandes-de-microfibra-y-rejilla-negro/slti8033.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringMedias de talla grande con bonitas braguitas de microfibra y piernas de rejilla. Un look retro estupendo.
keywords
string
title
stringMedias grandes de microfibra y rejilla
seotitle
stringMedias grandes de microfibra y rejilla
seouri
stringmedias-grandes-de-microfibra-y-rejilla-negro
specifications
string
stylingtips
string
summary
stringMedias de talla grande con bonitas braguitas de microfibra y piernas de rejilla. Un look retro estupendo.
title
stringMedias de microfibra y rejilla
usageinstructions
string
fr
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>Look r&eacute;tro ind&eacute;modable pour ces collants Mesh.<br>Microfibre, aspect r&eacute;sille et forme parfaite.<br>La culotte s'adapte &agrave; toutes les morphologies.&nbsp;<br><br>Culotte et pointes renforc&eacute;es</p>
guid
stringhttps://dev.divasboudoir.com/fr/collant-grande-taille-microfibre-et-resille-noir/slti8033.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringCollants grande taille, avec une jolie culotte en microfibre et des jambes en résille. Un superbe look rétro.
keywords
string
title
stringCollant grande taille Microfibre et Résille
seotitle
stringCollant grande taille Microfibre et Résille
seouri
stringcollant-grande-taille-microfibre-et-resille-noir
specifications
string
stylingtips
string
summary
string<p>Collants grande taille, avec une jolie culotte en microfibre et des jambes en r&eacute;sille. Un superbe look r&eacute;tro.</p>
title
stringCollant Microfibre et Résille
usageinstructions
string
it
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringUn look retrò senza tempo per questi collant Mesh.<br />Microfibra, aspetto a rete e forma perfetta.<br />Le mutande si adattano a tutte le forme del corpo.<br /><br />Collant e punte rinforzate
guid
stringhttps://dev.divasboudoir.com/it/collant-a-rete-e-microfibra-di-grande-taglia-nero/slti8033.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringCollant di taglia grande con graziose mutandine in microfibra e gambe a rete. Un look retrò di grande effetto.
keywords
string
title
stringCollant a rete e microfibra di grande taglia
seotitle
stringCollant a rete e microfibra di grande taglia
seouri
stringcollant-a-rete-e-microfibra-di-grande-taglia-nero
specifications
string
stylingtips
string
summary
stringCollant di taglia grande con graziose mutandine in microfibra e gambe a rete. Un look retrò di grande effetto.
title
stringCollant in microfibra e a rete
usageinstructions
string
nl
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringEen tijdloze retrolook voor deze panty van Mesh.<br />Microvezel, visnet-look en perfecte vorm.<br />De panty past zich aan alle lichaamsvormen aan.<br /><br />Versterkte panty en tenen
guid
stringhttps://dev.divasboudoir.com/nl/groote-maat-van-microvezel-en-visnet-zwart/slti8033.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringPanty van groote maat met mooie microvezelslipjes en visnetpijpen. Een geweldige retro look.
keywords
string
title
stringGroote maat van microvezel en visnet
seotitle
stringGroote maat van microvezel en visnet
seouri
stringgroote-maat-van-microvezel-en-visnet-zwart
specifications
string
stylingtips
string
summary
stringPanty van groote maat met mooie microvezelslipjes en visnetpijpen. Een geweldige retro look.
title
stringMicrovezel en visnet panty's
usageinstructions
string
pt
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringUm look retro intemporal para estes collants Mesh.<br />Microfibra, aspeto de rede e forma perfeita.<br />As cuecas adaptam-se a todas as formas do corpo.<br /><br />Meias-calças e dedos dos pés reforçados
guid
stringhttps://dev.divasboudoir.com/pt/collants-grandes-de-microfibra-e-rede-preto/slti8033.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringCollants de tamanho grande com bonitas cuecas de microfibra e pernas de rede. Um ótimo look retro.
keywords
string
title
stringCollants grandes de microfibra e rede
seotitle
stringCollants grandes de microfibra e rede
seouri
stringcollants-grandes-de-microfibra-e-rede-preto
specifications
string
stylingtips
string
summary
stringCollants de tamanho grande com bonitas cuecas de microfibra e pernas de rede. Um ótimo look retro.
title
stringCollants de microfibra e rede
usageinstructions
string
fetishboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
latexboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
legsboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string<ul> <li>Handw&auml;sche in kaltem Wasser</li> <li>Nicht auswringen</li> <li>Flach im Schatten trocknen</li> <li>Vorsichtige Behandlung zum Erhalt des Netzes</li> </ul>
description
string<p><strong>Eine Strumpfhose, die Vintage-Eleganz verk&ouml;rpert</strong>, entwickelt, um jede Silhouette zu betonen. Das Mikrofaser-H&ouml;schen passt sich nat&uuml;rlich allen K&ouml;rperformen an, w&auml;hrend die Netz-Beine einen raffinierten Retro-Stil hinzuf&uuml;gen. Ein Dessous-Accessoire, das Trends &uuml;berdauert.</p>
highlights
string<ul> <li><strong>Retro-Look</strong> zeitlos und luxuri&ouml;s</li> <li><strong>Mikrofaser-H&ouml;schen</strong> passend f&uuml;r alle K&ouml;rperformen</li> <li><strong>Netz-Beine</strong> von herausragender Qualit&auml;t</li> <li><strong>Intensives Schwarz</strong> sophistiziert</li> <li><strong>Verst&auml;rktes H&ouml;schen und Spitze</strong> f&uuml;r optimale Haltbarkeit</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringLuxus schwarze Netzstrumpfhose in Übergröße von Leg's Boudoir. Zeitloser Retro-Look, Mikrofaser und Netz. Komfort und Eleganz garantiert für alle Körperformen.
keywords
string
title
stringLuxus Schwarze Netzstrumpfhose Übergröße | Leg's Boudoir
seotitle
stringÜbergröße Netz-Strumpfhose Schwarz - Luxuriöser Retro Look
seouri
stringuebergroesse-netz-strumpfhose-luxus-schwarz-retro
specifications
string<ul> <li><strong>Material :</strong> Mikrofaser und Netz</li> <li><strong>Farbe :</strong> Intensives Schwarz</li> <li><strong>Stil :</strong> Mikrofaser-H&ouml;schen, Netz-Beine</li> <li><strong>Schnitt :</strong> Weite H&uuml;ften und Oberschenkel</li> <li><strong>Verarbeitung :</strong> Verst&auml;rktes H&ouml;schen und Spitze</li> </ul>
stylingtips
string<p>Kombinieren Sie diese Strumpfhose mit einem <strong>Vintage-Bleistiftkleid</strong> oder einem <strong>Rock-Jacken-Ensemble</strong> für einen glamourösen Retro-Look. Perfekt mit <strong>Pumps mit Absätzen</strong> und einem <strong>Trenchcoat</strong> für zeitlose Eleganz.</p>
summary
string<p><strong>Enth&uuml;llen Sie Ihre Vintage-Eleganz</strong> mit diesen Luxus-Strumpfhosen in &Uuml;bergr&ouml;&szlig;e. Ein <u>zeitloses Accessoire</u>, das alle K&ouml;rperformen mit Raffinesse und Sinnlichkeit betont.</p>
title
stringLuxus Retro Netzstrumpfhose
usageinstructions
string<p>Diese Strumpfhose bietet dank ihres gro&szlig;z&uuml;gigen Schnitts perfekten Komfort. Das Mikrofaser-H&ouml;schen passt sich nat&uuml;rlich allen K&ouml;rperformen an, w&auml;hrend die Netz-Beine eine raffinierte Retro-Eleganz verleihen. Ein Dessous-Accessoire, das Komfort und Sinnlichkeit vereint.</p>
el
Struct
Entries: 14
abstract
string
careinstructions
string<ul> <li>&Pi;&lambda;ύ&sigma;&iota;&mu;&omicron; &sigma;&tau;&omicron; &chi;έ&rho;&iota; &mu;&epsilon; &kappa;&rho;ύ&omicron; &nu;&epsilon;&rho;ό</li> <li>&Mu;&eta;&nu; &sigma;&tau;&rho;ί&beta;&epsilon;&tau;&epsilon;</li> <li>&Sigma;&tau;&epsilon;&gamma;&nu;ώ&sigma;&tau;&epsilon; &epsilon;&pi;ί&pi;&epsilon;&delta;&alpha; &sigma;&tau;&eta; &sigma;&kappa;&iota;ά</li> <li>&Pi;&rho;&omicron;&sigma;&epsilon;&kappa;&tau;&iota;&kappa;ό&sigmaf; &chi;&epsilon;&iota;&rho;&iota;&sigma;&mu;ό&sigmaf; &gamma;&iota;&alpha; &nu;&alpha; &delta;&iota;&alpha;&tau;&eta;&rho;&eta;&theta;&epsilon;ί &tau;&omicron; &delta;ί&chi;&tau;&upsilon;</li> </ul>
description
string<p><strong>Έ&nu;&alpha; &kappa;&alpha;&lambda;&sigma;ό&nu; &pi;&omicron;&upsilon; &epsilon;&nu;&sigma;&alpha;&rho;&kappa;ώ&nu;&epsilon;&iota; &tau;&eta; vintage &kappa;&omicron;&mu;&psi;ό&tau;&eta;&tau;&alpha;</strong>, &sigma;&chi;&epsilon;&delta;&iota;&alpha;&sigma;&mu;έ&nu;&omicron; &gamma;&iota;&alpha; &nu;&alpha; &alpha;&nu;&alpha;&delta;&epsilon;&iota;&kappa;&nu;ύ&epsilon;&iota; &kappa;ά&theta;&epsilon; &sigma;&iota;&lambda;&omicron;&upsilon;έ&tau;&alpha;. &Tau;&omicron; &epsilon;&sigma;ώ&rho;&omicron;&upsilon;&chi;&omicron; &alpha;&pi;ό &mu;&iota;&kappa;&rho;&omicron;ΐ&nu;&epsilon;&sigmaf; &pi;&rho;&omicron;&sigma;&alpha;&rho;&mu;ό&zeta;&epsilon;&tau;&alpha;&iota; &phi;&upsilon;&sigma;&iota;&kappa;ά &sigma;&epsilon; ό&lambda;&omicron;&upsilon;&sigmaf; &tau;&omicron;&upsilon;&sigmaf; &tau;ύ&pi;&omicron;&upsilon;&sigmaf; &sigma;ώ&mu;&alpha;&tau;&omicron;&sigmaf;, &epsilon;&nu;ώ &tau;&alpha; &delta;&iota;&chi;&tau;&upsilon;&omega;&tau;ά &pi;ό&delta;&iota;&alpha; &pi;&rho;&omicron;&sigma;&theta;έ&tau;&omicron;&upsilon;&nu; &mu;&iota;&alpha; &epsilon;&kappa;&lambda;&epsilon;&pi;&tau;&upsilon;&sigma;&mu;έ&nu;&eta; &rho;&epsilon;&tau;&rho;ό &pi;&iota;&nu;&epsilon;&lambda;&iota;ά. Έ&nu;&alpha; &alpha;&xi;&epsilon;&sigma;&omicron;&upsilon;ά&rho; lingerie &pi;&omicron;&upsilon; &xi;&epsilon;&pi;&epsilon;&rho;&nu;ά &tau;&iota;&sigmaf; &tau;ά&sigma;&epsilon;&iota;&sigmaf;.</p>
highlights
string<ul> <li><strong>&Rho;&epsilon;&tau;&rho;ό look</strong> &delta;&iota;&alpha;&chi;&rho;&omicron;&nu;&iota;&kappa;ό &kappa;&alpha;&iota; &pi;&omicron;&lambda;&upsilon;&tau;&epsilon;&lambda;έ&sigmaf;</li> <li><strong>&Epsilon;&sigma;ώ&rho;&omicron;&upsilon;&chi;&omicron; &alpha;&pi;ό &mu;&iota;&kappa;&rho;&omicron;ΐ&nu;&epsilon;&sigmaf;</strong> &pi;&rho;&omicron;&sigma;&alpha;&rho;&mu;ό&sigma;&iota;&mu;&omicron; &sigma;&epsilon; ό&lambda;&omicron;&upsilon;&sigmaf; &tau;&omicron;&upsilon;&sigmaf; &tau;ύ&pi;&omicron;&upsilon;&sigmaf; &sigma;ώ&mu;&alpha;&tau;&omicron;&sigmaf;</li> <li><strong>&Pi;ό&delta;&iota;&alpha; &delta;&iota;&chi;&tau;&upsilon;&omega;&tau;ά</strong> &epsilon;&xi;&alpha;&iota;&rho;&epsilon;&tau;&iota;&kappa;ή&sigmaf; &pi;&omicron;&iota;ό&tau;&eta;&tau;&alpha;&sigmaf;</li> <li><strong>Έ&nu;&tau;&omicron;&nu;&omicron; &mu;&alpha;ύ&rho;&omicron;</strong> &epsilon;&kappa;&lambda;&epsilon;&pi;&tau;&upsilon;&sigma;&mu;έ&nu;&omicron;</li> <li><strong>&Epsilon;&nu;&iota;&sigma;&chi;&upsilon;&mu;έ&nu;&omicron; &epsilon;&sigma;ώ&rho;&omicron;&upsilon;&chi;&omicron; &kappa;&alpha;&iota; &mu;ύ&tau;&eta;</strong> &gamma;&iota;&alpha; &beta;έ&lambda;&tau;&iota;&sigma;&tau;&eta; &alpha;&nu;&theta;&epsilon;&kappa;&tau;&iota;&kappa;ό&tau;&eta;&tau;&alpha;</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringΠολυτελές μαύρο διχτυωτό καλσόν μεγάλου μεγέθους από το Leg's Boudoir. Διαχρονικό ρετρό στιλ, μικροΐνες και δίχτυ. Άνεση και κομψότητα εγγυημένα για όλους τους τύπους σώματος.
keywords
string
title
stringΠολυτελές Μαύρο Διχτυωτό Καλσόν Μεγάλου Μεγέθους | Leg's Boudoir
seotitle
stringΚαλσόν Μεγάλου Μεγέθους Δικτυωτό Μαύρο - Πολυτελής Ρετρό Εμφάνιση
seouri
stringkalson-megalou-megethous-dichtyoto-polyteleia-mavro-retro
specifications
string<ul> <li><strong>&Upsilon;&lambda;&iota;&kappa;ό :</strong> &Mu;&iota;&kappa;&rho;&omicron;ΐ&nu;&epsilon;&sigmaf; &kappa;&alpha;&iota; &delta;ί&chi;&tau;&upsilon;</li> <li><strong>&Chi;&rho;ώ&mu;&alpha; :</strong> Έ&nu;&tau;&omicron;&nu;&omicron; &mu;&alpha;ύ&rho;&omicron;</li> <li><strong>&Sigma;&tau;&iota;&lambda; :</strong> &Epsilon;&sigma;ώ&rho;&omicron;&upsilon;&chi;&omicron; &mu;&iota;&kappa;&rho;&omicron;ϊ&nu;ώ&nu;, &delta;&iota;&chi;&tau;&upsilon;&omega;&tau;ά &pi;ό&delta;&iota;&alpha;</li> <li><strong>&Kappa;&omicron;&pi;ή :</strong> &Phi;&alpha;&rho;&delta;&iota;ά &gamma;&omicron;&phi;&iota;ά &kappa;&alpha;&iota; &mu;&eta;&rho;&omicron;ί</li> <li><strong>&Tau;&epsilon;&lambda;&epsilon;&iota;ώ&mu;&alpha;&tau;&alpha; :</strong> &Epsilon;&nu;&iota;&sigma;&chi;&upsilon;&mu;έ&nu;&omicron; &epsilon;&sigma;ώ&rho;&omicron;&upsilon;&chi;&omicron; &kappa;&alpha;&iota; &mu;ύ&tau;&eta;</li> </ul>
stylingtips
string<p>Συνδυάστε αυτό το καλσόν με ένα <strong>vintage pencil φόρεμα</strong> ή ένα <strong>σύνολο φούστα-ζακέτα</strong> για μια ρετρό λαμπερή εμφάνιση. Ιδανικό με <strong>γόβες με τακούνια</strong> και μια <strong>καμπαρντίνα</strong> για διαχρονική κομψότητα.</p>
summary
string<p><strong>&Alpha;&pi;&omicron;&kappa;&alpha;&lambda;ύ&psi;&tau;&epsilon; &tau;&eta; vintage &kappa;&omicron;&mu;&psi;ό&tau;&eta;&tau;ά &sigma;&alpha;&sigmaf;</strong> &mu;&epsilon; &alpha;&upsilon;&tau;ό &tau;&omicron; &pi;&omicron;&lambda;&upsilon;&tau;&epsilon;&lambda;έ&sigmaf; &kappa;&alpha;&lambda;&sigma;ό&nu; &mu;&epsilon;&gamma;ά&lambda;&omicron;&upsilon; &mu;&epsilon;&gamma;έ&theta;&omicron;&upsilon;&sigmaf;. Έ&nu;&alpha; <u>&delta;&iota;&alpha;&chi;&rho;&omicron;&nu;&iota;&kappa;ό &alpha;&xi;&epsilon;&sigma;&omicron;&upsilon;ά&rho;</u> &pi;&omicron;&upsilon; &alpha;&nu;&alpha;&delta;&epsilon;&iota;&kappa;&nu;ύ&epsilon;&iota; ό&lambda;&omicron;&upsilon;&sigmaf; &tau;&omicron;&upsilon;&sigmaf; &tau;ύ&pi;&omicron;&upsilon;&sigmaf; &sigma;ώ&mu;&alpha;&tau;&omicron;&sigmaf; &mu;&epsilon; &epsilon;&kappa;&lambda;έ&pi;&tau;&upsilon;&nu;&sigma;&eta; &kappa;&alpha;&iota; &alpha;&iota;&sigma;&theta;&eta;&sigma;&iota;&alpha;&kappa;ό&tau;&eta;&tau;&alpha;.</p>
title
stringΠολυτελές Ρετρό Καλσόν Δίχτυ
usageinstructions
string<p>&Alpha;&upsilon;&tau;ό &tau;&omicron; &kappa;&alpha;&lambda;&sigma;ό&nu; &pi;&rho;&omicron;&sigma;&phi;έ&rho;&epsilon;&iota; &tau;έ&lambda;&epsilon;&iota;&omicron; comfort &chi;ά&rho;&eta; &sigma;&tau;&eta;&nu; &gamma;&epsilon;&nu;&nu;&alpha;&iota;ό&delta;&omega;&rho;&eta; &gamma;&rho;&alpha;&mu;&mu;ή &tau;&omicron;&upsilon;. &Tau;&omicron; &epsilon;&sigma;ώ&rho;&omicron;&upsilon;&chi;&omicron; &alpha;&pi;ό &mu;&iota;&kappa;&rho;&omicron;ΐ&nu;&epsilon;&sigmaf; &pi;&rho;&omicron;&sigma;&alpha;&rho;&mu;ό&zeta;&epsilon;&tau;&alpha;&iota; &phi;&upsilon;&sigma;&iota;&kappa;ά &sigma;&epsilon; ό&lambda;&omicron;&upsilon;&sigmaf; &tau;&omicron;&upsilon;&sigmaf; &tau;ύ&pi;&omicron;&upsilon;&sigmaf; &sigma;ώ&mu;&alpha;&tau;&omicron;&sigmaf;, &epsilon;&nu;ώ &tau;&alpha; &delta;&iota;&chi;&tau;&upsilon;&omega;&tau;ά &pi;ό&delta;&iota;&alpha; &pi;&rho;&omicron;&sigma;&delta;ί&delta;&omicron;&upsilon;&nu; &mu;&iota;&alpha; &epsilon;&kappa;&lambda;&epsilon;&pi;&tau;&upsilon;&sigma;&mu;έ&nu;&eta; &rho;&epsilon;&tau;&rho;ό &kappa;&omicron;&mu;&psi;ό&tau;&eta;&tau;&alpha;. Έ&nu;&alpha; &alpha;&xi;&epsilon;&sigma;&omicron;&upsilon;ά&rho; lingerie &pi;&omicron;&upsilon; &sigma;&upsilon;&nu;&delta;&upsilon;ά&zeta;&epsilon;&iota; ά&nu;&epsilon;&sigma;&eta; &kappa;&alpha;&iota; &alpha;&iota;&sigma;&theta;&eta;&sigma;&iota;&alpha;&kappa;ό&tau;&eta;&tau;&alpha;.</p>
en
Struct
Entries: 14
abstract
string
careinstructions
string<ul> <li>Hand wash in cold water</li> <li>Do not wring</li> <li>Dry flat in the shade</li> <li>Delicate handling to preserve mesh</li> </ul>
description
string<p><strong>Tights that embody vintage elegance</strong>, designed to highlight every silhouette. The microfiber panty naturally adapts to all body types, while the mesh legs add a touch of sophisticated retro style. A lingerie accessory that transcends trends.</p>
highlights
string<ul> <li><strong>Retro look</strong> timeless and luxurious</li> <li><strong>Microfiber panty</strong> suitable for all body types</li> <li><strong>Mesh legs</strong> of superb quality</li> <li><strong>Intense black</strong> sophisticated</li> <li><strong>Reinforced panty and toe</strong> for optimal durability</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringLuxury black mesh plus-size tights from Leg's Boudoir. Timeless retro look, microfiber and mesh. Comfort and elegance guaranteed for all body types.
keywords
string
title
stringLuxury Black Mesh Tights Plus Size | Leg's Boudoir
seotitle
stringPlus Size Black Mesh Tights - Luxury Retro Look
seouri
stringplus-size-mesh-tights-luxury-black-retro
specifications
string<ul> <li><strong>Material :</strong> Microfiber and mesh</li> <li><strong>Color :</strong> Intense black</li> <li><strong>Style :</strong> Microfiber panty, mesh legs</li> <li><strong>Fit :</strong> Wide hips and thighs</li> <li><strong>Finishes :</strong> Reinforced panty and toe</li> </ul>
stylingtips
string<p>Pair these tights with a <strong>vintage pencil dress</strong> or a <strong>skirt-jacket ensemble</strong> for a retro glamorous look. Perfect with <strong>pumps with heels</strong> and a <strong>trench coat</strong> for timeless elegance.</p>
summary
string<p><strong>Reveal your vintage elegance</strong> with these luxury plus-size mesh tights. A <u>timeless accessory</u> that enhances all body types with refinement and sensuality.</p>
title
stringLuxury Retro Mesh Tights
usageinstructions
string<p>These tights offer perfect comfort thanks to their generous cut. The microfiber panty naturally adapts to all body types, while the mesh legs bring a sophisticated retro elegance. A lingerie accessory that combines comfort and sensuality.</p>
es
Struct
Entries: 14
abstract
string
careinstructions
string<ul> <li>Lavado a mano en agua fr&iacute;a</li> <li>No retorcer</li> <li>Secar extendido a la sombra</li> <li>Manipulaci&oacute;n delicada para preservar la malla</li> </ul>
description
string<p><strong>Unas medias que encarnan la elegancia vintage</strong>, dise&ntilde;adas para realzar cada silueta. La braga de microfibre se adapta naturalmente a todas las morfolog&iacute;as, mientras que las piernas de malla aportan un toque de sofisticaci&oacute;n retro. Un accesorio de lencer&iacute;a que trasciende las tendencias.</p>
highlights
string<ul> <li><strong>Look retro</strong> atemporal y lujoso</li> <li><strong>Braga de microfibre</strong> adaptable a todas las morfolog&iacute;as</li> <li><strong>Piernas de malla</strong> de calidad excepcional</li> <li><strong>Negro intenso</strong> sofisticado</li> <li><strong>Braga y punta reforzadas</strong> para durabilidad &oacute;ptima</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringMedias de lujo negras talla grande de Leg's Boudoir. Look retro atemporal, microfibre y malla. Confort y elegancia garantizados para todas las morfologías.
keywords
string
title
stringMedias de Lujo Negras Talla Grande | Leg's Boudoir
seotitle
stringMedias Talla Grande de Malla Negras - Look Retro de Lujo
seouri
stringmedias-talla-grande-malla-lujo-negro-retro
specifications
string<ul> <li><strong>Material :</strong> Microfibre y malla</li> <li><strong>Color :</strong> Negro intenso</li> <li><strong>Estilo :</strong> Braga de microfibre, piernas de malla</li> <li><strong>Corte :</strong> Caderas y muslos anchos</li> <li><strong>Acabados :</strong> Braga y punta reforzadas</li> </ul>
stylingtips
string<p>Combina estas medias con un <strong>vestido lápiz vintage</strong> o un <strong>conjunto de falda y chaqueta</strong> para conseguir un look retro glamuroso. Perfectas con <strong>zapatos de tacón</strong> y una <strong>gabardina</strong> para una elegancia atemporal.</p>
summary
string<p><strong>Revela tu elegancia vintage</strong> con estas medias de lujo talla grande. Un <u>accesorio atemporal</u> que realza todas las morfolog&iacute;as con refinamiento y sensualidad.</p>
title
stringMedias Retro de Lujo
usageinstructions
string<p>Estas medias ofrecen un confort perfecto gracias a su generoso corte. La braga de microfibre se adapta naturalmente a todas las morfolog&iacute;as, mientras que las piernas de malla aportan una elegancia retro sofisticada. Un accesorio de lencer&iacute;a que combina comodidad y sensualidad.</p>
fr
Struct
Entries: 14
abstract
string
careinstructions
string<ul> <li>Lavage &agrave; la main en eau froide</li> <li>Ne pas tordre</li> <li>S&eacute;chage &agrave; plat &agrave; l'ombre</li> <li>Manipulation d&eacute;licate pour pr&eacute;server la r&eacute;sille</li> </ul>
description
string<p><strong>Un collant qui incarne l'&eacute;l&eacute;gance vintage</strong>, pens&eacute; pour mettre en valeur chaque silhouette. La culotte en microfibre s'adapte naturellement &agrave; toutes les morphologies, tandis que les jambes en r&eacute;sille apportent une touche de sophistication r&eacute;tro. Un accessoire de lingerie qui transcende les tendances.</p>
highlights
string<ul> <li><strong>Look r&eacute;tro</strong> ind&eacute;modable et luxueux</li> <li><strong>Culotte microfibre</strong> adapt&eacute;e &agrave; toutes les morphologies</li> <li><strong>Jambes en r&eacute;sille</strong> de superbe qualit&eacute;</li> <li><strong>Noir intense</strong> sophistiqu&eacute;</li> <li><strong>Culotte et pointes renforc&eacute;es</strong> pour une durabilit&eacute; optimale</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringCollants grande taille résille noire de luxe chez Leg's Boudoir. Look rétro indémodable, microfibre et résille. Confort et élégance garantis pour toutes les morphologies.
keywords
string
title
stringCollants Résille Luxe Grande Taille Noir | Leg's Boudoir
seotitle
stringCollants Grande Taille Résille Noire - Look Rétro de Luxe
seouri
stringcollants-grande-taille-resille-luxe-noir-retro
specifications
string<ul> <li><strong>Mati&egrave;re :</strong> Microfibre et r&eacute;sille</li> <li><strong>Couleur :</strong> Noir intense</li> <li><strong>Style :</strong> Culotte microfibre, jambes r&eacute;sille</li> <li><strong>Coupe :</strong> Hanches et cuisses larges</li> <li><strong>Finitions :</strong> Culotte et pointes renforc&eacute;es</li> </ul>
stylingtips
string<p>Associez ces collants &agrave; une <strong>robe crayon vintage</strong> ou &agrave; un <strong>ensemble jupe-veste</strong> pour un look r&eacute;tro glamour. Parfait avec des <strong>escarpins &agrave; talons</strong> et un <strong>trench-coat</strong> pour une &eacute;l&eacute;gance intemporelle.</p>
summary
string<p><strong>R&eacute;v&eacute;lez votre &eacute;l&eacute;gance vintage</strong> avec ces collants grande taille en r&eacute;sille de luxe. Un <u>accessoire intemporel</u> qui sublime toutes les morphologies avec raffinement et sensualit&eacute;.</p>
title
stringCollants Résille Luxe Rétro
usageinstructions
string<p>Ces collants offrent un confort parfait gr&acirc;ce &agrave; leur coupe g&eacute;n&eacute;reuse. La culotte en microfibre s'adapte naturellement &agrave; toutes les morphologies, tandis que les jambes en r&eacute;sille apportent une &eacute;l&eacute;gance r&eacute;tro sophistiqu&eacute;e. Un accessoire de lingerie qui allie confort et sensualit&eacute;.</p>
it
Struct
Entries: 14
abstract
string
careinstructions
string<ul> <li>Lavaggio a mano in acqua fredda</li> <li>Non strizzare</li> <li>Asciugare steso all'ombra</li> <li>Manipolazione delicata per preservare la rete</li> </ul>
description
string<p><strong>Un collant che incarna l'eleganza vintage</strong>, progettato per esaltare ogni silhouette. La culotte in microfibra si adatta naturalmente a tutte le forme, mentre le gambe in rete aggiungono un tocco di raffinatezza retr&ograve;. Un accessorio di lingerie che trascende le tendenze.</p>
highlights
string<ul> <li><strong>Look retr&ograve;</strong> intramontabile e lussuoso</li> <li><strong>Culotte in microfibra</strong> adattabile a tutte le forme</li> <li><strong>Gambe in rete</strong> di qualit&agrave; eccezionale</li> <li><strong>Nero intenso</strong> sofisticato</li> <li><strong>Culotte e punta rinforzate</strong> per durabilit&agrave; ottimale</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringCollant di lusso neri taglie forti di Leg's Boudoir. Look retrò intramontabile, microfibra e rete. Comfort ed eleganza garantiti per tutte le forme.
keywords
string
title
stringCollant di Lusso Neri Taglie Forti | Leg's Boudoir
seotitle
stringCollant Taglie Forti in Rete Neri - Look Retrò di Lusso
seouri
stringcollant-taglie-forti-rete-lusso-nero-retro
specifications
string<ul> <li><strong>Materiale :</strong> Microfibra e rete</li> <li><strong>Colore :</strong> Nero intenso</li> <li><strong>Stile :</strong> Culotte in microfibra, gambe in rete</li> <li><strong>Taglio :</strong> Fianchi e cosce larghe</li> <li><strong>Finiture :</strong> Culotte e punta rinforzate</li> </ul>
stylingtips
string<p>Abbinate questi collant a un <strong>abito a matita vintage</strong> o a un <strong>insieme gonna-giacca</strong> per un look glamour retrò. Perfetti con le <strong>décolleté con tacco e</strong> un <strong>trench</strong> per un'eleganza senza tempo.</p>
summary
string<p><strong>Rivela la tua eleganza vintage</strong> con questi collant di lusso taglie forti. Un <u>accessorio intramontabile</u> che esalta tutte le forme con raffinatezza e sensualit&agrave;.</p>
title
stringCollant Retrò di Lusso
usageinstructions
string<p>Questi collant offrono un comfort perfetto grazie al loro taglio generoso. La culotte in microfibra si adatta naturalmente a tutte le forme, mentre le gambe in rete donano un'eleganza retr&ograve; sofisticata. Un accessorio di lingerie che combina comfort e sensualit&agrave;.</p>
nl
Struct
Entries: 14
abstract
string
careinstructions
string<ul> <li>Handwas in koud water</li> <li>Niet wringen</li> <li>Plat drogen in de schaduw</li> <li>Voorzichtige behandeling om het net te behouden</li> </ul>
description
string<p><strong>Een panty die vintage elegantie belichaamt</strong>, ontworpen om elk silhouet te benadrukken. Het microfiber broekje past zich natuurlijk aan alle lichaamstypes aan, terwijl de netbenen een verfijnde retro touch toevoegen. Een lingerie-accessoire dat trends overstijgt.</p>
highlights
string<ul> <li><strong>Retro look</strong> tijdloos en luxueus</li> <li><strong>Microfiber broekje</strong> geschikt voor alle lichaamstypes</li> <li><strong>Netbenen</strong> van prachtige kwaliteit</li> <li><strong>Intens zwart</strong> verfijnd</li> <li><strong>Versterkt broekje en teen</strong> voor optimale duurzaamheid</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringGrote maat luxe netpanty zwart van Leg's Boudoir. Tijdloze retro look, microfiber en net. Comfort en elegantie gegarandeerd voor alle lichaamstypes.
keywords
string
title
stringLuxe Netpanty Grote Maat Zwart | Leg's Boudoir
seotitle
stringGrote Maat Netpanty Zwart - Luxe Retro Look
seouri
stringgrote-maat-netpanty-luxe-zwart-retro
specifications
string<ul> <li><strong>Materiaal :</strong> Microfiber en net</li> <li><strong>Kleur :</strong> Intens zwart</li> <li><strong>Stijl :</strong> Microfiber broekje, netbenen</li> <li><strong>Pasvorm :</strong> Brede heupen en dijen</li> <li><strong>Afwerking :</strong> Versterkt broekje en teen</li> </ul>
stylingtips
string<p>Combineer deze panty's met een <strong>vintage koker jurk</strong> of een <strong>rok-jasje ensemble</strong> voor een retro glamour look. Perfect met <strong>pumps met hak</strong> en een <strong>trenchcoat</strong> voor tijdloze elegantie.</p>
summary
string<p><strong>Onthul je vintage elegantie</strong> met deze grote maat luxe netpanty. Een <u>tijdloos accessoire</u> dat alle lichaamstypes verfraait met verfijning en sensualiteit.</p>
title
stringLuxe Retro Netpanty
usageinstructions
string<p>Deze panty's bieden perfect comfort dankzij hun ruime pasvorm. Het microfiber broekje past zich natuurlijk aan alle lichaamstypes aan, terwijl de netbenen een verfijnde retro elegantie toevoegen. Een lingerie-accessoire dat comfort en sensualiteit combineert.</p>
pt
Struct
Entries: 14
abstract
string
careinstructions
string<ul> <li>Lavar &agrave; m&atilde;o em &aacute;gua fria</li> <li>N&atilde;o torcer</li> <li>Secar deitada &agrave; sombra</li> <li>Manuseio delicado para preservar a tela</li> </ul>
description
string<p><strong>Uma meia-cal&ccedil;a que encarna a eleg&acirc;ncia vintage</strong>, projetada para real&ccedil;ar cada silhueta. A parte &iacute;ntima de microfibra se adapta naturalmente a todos os tipos de corpo, enquanto as pernas em tela adicionam um toque de sofistica&ccedil;&atilde;o retr&ocirc;. Um acess&oacute;rio de lingerie que transcende as tend&ecirc;ncias.</p>
highlights
string<ul> <li><strong>Look retr&ocirc;</strong> atemporal e luxuoso</li> <li><strong>Parte &iacute;ntima de microfibra</strong> adapt&aacute;vel a todos os tipos de corpo</li> <li><strong>Pernas em tela</strong> de qualidade excepcional</li> <li><strong>Preto intenso</strong> sofisticado</li> <li><strong>Parte &iacute;ntima e ponta refor&ccedil;adas</strong> para durabilidade m&aacute;xima</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringMeia-calça de luxo preta plus size de Leg's Boudoir. Look retrô atemporal, microfibra e tela. Conforto e elegância garantidos para todos os tipos de corpo.
keywords
string
title
stringMeia-Calça de Luxo Preta Plus Size | Leg's Boudoir
seotitle
stringMeia-Calça Plus Size de Tela Preta - Look Retrô de Luxo
seouri
stringmeia-calca-plus-size-tela-luxo-preto-retro
specifications
string<ul> <li><strong>Material :</strong> Microfibra e tela</li> <li><strong>Cor :</strong> Preto intenso</li> <li><strong>Estilo :</strong> Parte &iacute;ntima de microfibra, pernas em tela</li> <li><strong>Corte :</strong> Quadris e coxas largos</li> <li><strong>Acabamentos :</strong> Parte &iacute;ntima e ponta refor&ccedil;adas</li> </ul>
stylingtips
string<p>Combine estes collants com um <strong>vestido lápis vintage</strong> ou um <strong>conjunto de saia e casaco</strong> para um look retro glamoroso. Perfeitos com <strong>sapatos de salto alto</strong> e uma <strong>gabardina</strong> para uma elegância intemporal.</p>
summary
string<p><strong>Revele sua eleg&acirc;ncia vintage</strong> com esta meia-cal&ccedil;a de luxo plus size. Um <u>acess&oacute;rio atemporal</u> que real&ccedil;a todos os tipos de corpo com requinte e sensualidade.</p>
title
stringMeia-Calça Retrô de Luxo
usageinstructions
string<p>Estas meias-cal&ccedil;a oferecem conforto perfeito gra&ccedil;as ao seu corte generoso. A parte &iacute;ntima de microfibra se adapta naturalmente a todos os tipos de corpo, enquanto as pernas em tela trazem uma eleg&acirc;ncia retr&ocirc; sofisticada. Um acess&oacute;rio de lingerie que combina conforto e sensualidade.</p>
lustboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
smboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
name
string50351 Mesh collants
netweight
string
nextshipment
stringtomorrow
ordered
number3
orderidx
number0
origin
stringeu
originalsize
string
packaging
string
productshipment
stringauto
productuid
string616509E5-A749-4AC2-B83E715A2B6BB6D9
promountil
string
rating
stringnone
recorduid
string616509E5-A749-4AC2-B83E715A2B6BB6D9
reference
stringSLTI8033
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.54 ms
Record Count: 6
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_sizes.id_size as recorduid, if(intlsize <> '',intlsize,eusize) as size, if(intlsize <> '','intlsize','eusize') as sizetype,
product_variations.color,
if(product_sizes.sizegroup = 'bra',
if(intlsize <> '', cast(intlsize as SIGNED ), cast(eusize as SIGNED ))
,
SUBSTRING_INDEX(intlsize,'-',1)
) as param1,
if(product_sizes.sizegroup = 'bra',
if(intlsize <> '',
MID(intlsize,length(cast(intlsize as SIGNED ))+1,length(intlsize)),
MID(eusize,length(cast(eusize as SIGNED ))+1,length(eusize))
)
,
SUBSTRING_INDEX(intlsize,'-',-1)
) as param2,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as available,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
999999,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as groupavailable,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
product_sizes.gender, product_sizes.sizerange, product_sizes.sizegroup, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize,
product_sizes.bust, product_sizes.waist, product_sizes.hip, product_sizes.underbust, product_sizes.cup, product_sizes.thigh, product_sizes.legheight, product_sizes.bodyheight, product_sizes.bodyweight
from product_sizes
left outer join product_variations on product_sizes.suppliersize = product_variations.size and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
where FIND_IN_SET(product_sizes.id_size,'2130,1046,1047,1048,1049,1050') > 0
and product_variations.productuid = '616509E5-A749-4AC2-B83E715A2B6BB6D9'
and intlsize <> 'na'
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_sizes.id_size, product_variations.color
order by FIELD(product_sizes.gender,'w','m'), product_sizes.sizegroup, FIELD(intlsize,'XS','S','S/M','S-M','M','M/L','M-L','L','L-XL','L/XL','XL','0X','0XL','lXL','1X','1X-2X','1X/2X','XL/2XL','XL-2XL','1XL-2XL','2XL','2X','XXL','2X-3X','2X/3X','2XL-3XL','2XL/3XL','XXXL','3XL','3X','3X-4X','3X/4X','3XL-4XL','3XL/4XL','4XL','5XL','5X','5X-6X','5X/6X','5XL-6XL','5XL/6XL','6XL','6X','7XL','7X','8XL','8X'), cast(intlsize as SIGNED ), groupavailable desc, stock desc
recorduidsizesizetypecolorparam1param2availablegroupavailablestockgendersizerangesizegroupsuppliersizeintlsizeincheseusizeussizeuksizefrsizeessizedesizeitsizeptsizeelsizebustwaisthipunderbustcupthighlegheightbodyheightbodyweight
1213038-40intlsizeblack3840-19999990wpluslingerieM38-4038-408-1012-1440-4240-4238-4044-4640-4238-40
2104642-44intlsizeblack4244-19999991wpluslingerieL42-4442-4412-1416-1844-4644-4642-4448-5042-4442-44
3104746-48intlsizeblack4648-19999990wpluslingerieXL46-4846-4816-1820-2248-5048-5046-4852-5448-5046-48
4104850-52intlsizeblack5052-19999990wpluslingerie2XL50-5250-5220-2224-2652-5452-5450-5256-5852-5450-52
5104954-56intlsizeblack5456-19999991wpluslingerie3XL54-5654-5624-2628-3056-5856-5854-5660-6256-5854-56
6105056-58intlsizeblack5658-19999992wpluslingerie4XL56-5856-5826-2830-3258-6058-6056-5862-6458-6056-58
sizeranges
stringplus
sizes
string2130,1046,1047,1048,1049,1050
sizetype
stringauto
specifications
Struct
Entries: 23
belly
string
bones
string
bra
string
breasts
string
bust
string
closing
string
crochtless
string
cups
string
cut
string
garter
string
halter
string
lacing
string
lining
string
modestypanel
string
panty
string
sheathing
string
sleeves
string
stocking
string
straps
string
stretch
string
suspenders
string
transparency
string
underwires
string
stock
number0
stocks
Query
Template: /system/api/product/stocks.cfc:25
Execution Time: 6.95 ms
Record Count: 6
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select * from (
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '616509E5-A749-4AC2-B83E715A2B6BB6D9'
and product_variations.isactive = 1
and product_sizes.id_size = 2130
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '616509E5-A749-4AC2-B83E715A2B6BB6D9'
and product_variations.isactive = 1
and product_sizes.id_size = 1046
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '616509E5-A749-4AC2-B83E715A2B6BB6D9'
and product_variations.isactive = 1
and product_sizes.id_size = 1047
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '616509E5-A749-4AC2-B83E715A2B6BB6D9'
and product_variations.isactive = 1
and product_sizes.id_size = 1048
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '616509E5-A749-4AC2-B83E715A2B6BB6D9'
and product_variations.isactive = 1
and product_sizes.id_size = 1049
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 = '616509E5-A749-4AC2-B83E715A2B6BB6D9'
and product_variations.isactive = 1
and product_sizes.id_size = 1050
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
) tbl
group by productuid, variationuid, stockuid
order by stockuid, FIELD(gender,'w','m'), sizegroup, FIELD(intlsize,'XS','S','S/M','S-M','M','M/L','M-L','L','L-XL','L/XL','XL','0X','0XL','lXL','1X','1X-2X','1X/2X','XL/2XL','XL-2XL','1XL-2XL','2XL','2X','XXL','2X-3X','2X/3X','2XL-3XL','2XL/3XL','XXXL','3XL','3X','3X-4X','3X/4X','3XL-4XL','3XL/4XL','4XL','5XL','5X','5X-6X','5X/6X','5XL-6XL','5XL/6XL','6XL','6X','7XL','7X','8XL','8X'), cast(intlsize as SIGNED ), color
productuidvariationuidrecorduidcolorhexvaluesuppliersizeintlsizeincheseusizeussizeuksizefrsizeessizedesizeitsizeptsizeelsizegendersizegroupcupsizesizetypeitempriceitempromopromoUntilstockuidwarehouseontourpackagingsupplierreservedorderedreturneddefectmanufacturerreferenceeanavailablestockdisplaycomments
1616509E5-A749-4AC2-B83E715A2B6BB6D91457B8B6-5924-4424-9BE4B552745FCF462130black#000000M38-4038-408-1012-1440-4240-4238-4044-4640-4238-40wlingerie38-40intlsize24.95830STOCK01000-10000-10all
2616509E5-A749-4AC2-B83E715A2B6BB6D981DEAC19-5EF4-4C86-A5B1492D144886751046black#000000L42-4442-4412-1416-1844-4644-4642-4448-5042-4442-44wlingerie42-44intlsize24.95830STOCK01100-1000050351426027713859211all
3616509E5-A749-4AC2-B83E715A2B6BB6D9CA10F853-20ED-4963-B5B14DCB20454FBD1047black#000000XL46-4846-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie46-48intlsize24.95830STOCK01000-10200503514260277138608-10all
4616509E5-A749-4AC2-B83E715A2B6BB6D9791543A7-6DA4-491C-A79081EC01E936C21048black#0000002XL50-5250-5220-2224-2652-5452-5450-5256-5852-5450-52wlingerie50-52intlsize24.95830STOCK01000-10100503514260277138615-10all
5616509E5-A749-4AC2-B83E715A2B6BB6D9B483C5A0-E7CA-421C-BD9433A5DE4B75841049black#0000003XL54-5654-5624-2628-3056-5856-5854-5660-6256-5854-56wlingerie54-56intlsize24.95830STOCK01100-1010050351426027713862211all
6616509E5-A749-4AC2-B83E715A2B6BB6D9786FCA00-27EB-4F2D-85F0ABE01183A93D1050black#0000004XL56-5856-5826-2830-3258-6058-6056-5862-6458-6056-58wlingerie56-58intlsize24.95830STOCK01200-1010050351426027713863922all
subcategory
stringtights
supplier
number-1
supplierreference
string50351
tags
string
themes
string
totalvariations
string
type
stringdefault
unitprice
number24.9583
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 11.2 ms
Record Count: 6
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '616509E5-A749-4AC2-B83E715A2B6BB6D9' 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 = '616509E5-A749-4AC2-B83E715A2B6BB6D9' 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 = '616509E5-A749-4AC2-B83E715A2B6BB6D9' 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 = '616509E5-A749-4AC2-B83E715A2B6BB6D9' 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 = '616509E5-A749-4AC2-B83E715A2B6BB6D9' 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 = '616509E5-A749-4AC2-B83E715A2B6BB6D9' 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 = '616509E5-A749-4AC2-B83E715A2B6BB6D9'
and product_variations.isactive = 1
and product_sizes.id_size = 2130
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '616509E5-A749-4AC2-B83E715A2B6BB6D9' 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 = '616509E5-A749-4AC2-B83E715A2B6BB6D9' 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 = '616509E5-A749-4AC2-B83E715A2B6BB6D9' 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 = '616509E5-A749-4AC2-B83E715A2B6BB6D9' 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 = '616509E5-A749-4AC2-B83E715A2B6BB6D9' 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 = '616509E5-A749-4AC2-B83E715A2B6BB6D9' 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 = '616509E5-A749-4AC2-B83E715A2B6BB6D9'
and product_variations.isactive = 1
and product_sizes.id_size = 1046
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '616509E5-A749-4AC2-B83E715A2B6BB6D9' 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 = '616509E5-A749-4AC2-B83E715A2B6BB6D9' 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 = '616509E5-A749-4AC2-B83E715A2B6BB6D9' 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 = '616509E5-A749-4AC2-B83E715A2B6BB6D9' 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 = '616509E5-A749-4AC2-B83E715A2B6BB6D9' 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 = '616509E5-A749-4AC2-B83E715A2B6BB6D9' 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 = '616509E5-A749-4AC2-B83E715A2B6BB6D9'
and product_variations.isactive = 1
and product_sizes.id_size = 1047
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '616509E5-A749-4AC2-B83E715A2B6BB6D9' 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 = '616509E5-A749-4AC2-B83E715A2B6BB6D9' 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 = '616509E5-A749-4AC2-B83E715A2B6BB6D9' 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 = '616509E5-A749-4AC2-B83E715A2B6BB6D9' 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 = '616509E5-A749-4AC2-B83E715A2B6BB6D9' 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 = '616509E5-A749-4AC2-B83E715A2B6BB6D9' 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 = '616509E5-A749-4AC2-B83E715A2B6BB6D9'
and product_variations.isactive = 1
and product_sizes.id_size = 1048
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '616509E5-A749-4AC2-B83E715A2B6BB6D9' 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 = '616509E5-A749-4AC2-B83E715A2B6BB6D9' 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 = '616509E5-A749-4AC2-B83E715A2B6BB6D9' 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 = '616509E5-A749-4AC2-B83E715A2B6BB6D9' 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 = '616509E5-A749-4AC2-B83E715A2B6BB6D9' 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 = '616509E5-A749-4AC2-B83E715A2B6BB6D9' 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 = '616509E5-A749-4AC2-B83E715A2B6BB6D9'
and product_variations.isactive = 1
and product_sizes.id_size = 1049
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 = '616509E5-A749-4AC2-B83E715A2B6BB6D9' 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 = '616509E5-A749-4AC2-B83E715A2B6BB6D9' 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 = '616509E5-A749-4AC2-B83E715A2B6BB6D9' 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 = '616509E5-A749-4AC2-B83E715A2B6BB6D9' 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 = '616509E5-A749-4AC2-B83E715A2B6BB6D9' 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 = '616509E5-A749-4AC2-B83E715A2B6BB6D9' 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 = '616509E5-A749-4AC2-B83E715A2B6BB6D9'
and product_variations.isactive = 1
and product_sizes.id_size = 1050
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
order by FIELD(gender,'w','m'), sizegroup, FIELD(intlsize,'XS','S','S/M','S-M','M','M/L','M-L','L','L-XL','L/XL','XL','0X','0XL','lXL','1X','1X-2X','1X/2X','XL/2XL','XL-2XL','1XL-2XL','2XL','2X','XXL','2X-3X','2X/3X','2XL-3XL','2XL/3XL','XXXL','3XL','3X','3X-4X','3X/4X','3XL-4XL','3XL/4XL','4XL','5XL','5X','5X-6X','5X/6X','5XL-6XL','5XL/6XL','6XL','6X','7XL','7X','8XL','8X'), cast(intlsize as SIGNED ), color
variationuidrecorduidcolorhexvaluesuppliersizeintlsizeincheseusizeussizeuksizefrsizeessizedesizeitsizeptsizeelsizegendersizegroupcupsizesizetypeitempriceitempromopromoUntilstockuidwarehouseontourpackagingsupplierreservedorderedreturneddefectmanufacturerreferenceeanavailablestockavailablepersizestockpersizeavailablepercolorstockpercolorhaspromounitpricedisplaycomments
11457B8B6-5924-4424-9BE4B552745FCF462130black#000000M38-4038-408-1012-1440-4240-4238-4044-4640-4238-40wlingerie38-40intlsize24.95830STOCK01000-10000-10-10-14024.9583all
281DEAC19-5EF4-4C86-A5B1492D144886751046black#000000L42-4442-4412-1416-1844-4644-4642-4448-5042-4442-44wlingerie42-44intlsize24.95830STOCK01100-1000050351426027713859211-11-14024.9583all
3CA10F853-20ED-4963-B5B14DCB20454FBD1047black#000000XL46-4846-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie46-48intlsize24.95830STOCK01000-10200503514260277138608-10-10-14024.9583all
4791543A7-6DA4-491C-A79081EC01E936C21048black#0000002XL50-5250-5220-2224-2652-5452-5450-5256-5852-5450-52wlingerie50-52intlsize24.95830STOCK01000-10100503514260277138615-10-10-14024.9583all
5B483C5A0-E7CA-421C-BD9433A5DE4B75841049black#0000003XL54-5654-5624-2628-3056-5856-5854-5660-6256-5854-56wlingerie54-56intlsize24.95830STOCK01100-1010050351426027713862211-11-14024.9583all
6786FCA00-27EB-4F2D-85F0ABE01183A93D1050black#0000004XL56-5856-5826-2830-3258-6058-6056-5862-6458-6056-58wlingerie56-58intlsize24.95830STOCK01200-1010050351426027713863922-12-14024.9583all
vatrate
number20
warehouse
string