Mein Warenkorb

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

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

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 *

Make up Mikrofaser- und Netzstrumpfhosen in großen Größen

Produktbeschreibung

Zeitloser Retro-Look für diese Mesh Make Up Strumpfhose.
Mikrofaser, Netzoptik und perfekte Passform.

Verstärkte Höschen und Spitzen

Technische Details

Verfügbare Größen

Erhältlich von 42-44 bis 56-58

Verfügbare Farbe

Beige

Styling-Tipps


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: 1.45 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,'beige') > 0
and product_variations.productuid = 'A9E1C32E-04DD-4C67-B3A8BF62163841CA'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1beigecolorbeigbeigebrown#F6DBAC-13
colorrange
stringbrown
colors
stringbeige
colortype
stringcolor
comments
string
compositions
Struct
Entries: 13
coton
string
elastane
string
free
string
leather
string
lycra
string
metal
string
nylon
string
polyamide
string
polyester
string
polyurethane
string
silk
string
spandex
string
viscose
string
datecreated
Date Time (Europe/Paris)
{ts '2019-10-10 08:33:53'}
defect
number0
dimensions
Struct
Entries: 14
acrylicbones
string
backsideheight
string
diameter
string
flatsteelbones
string
frontsideheight
string
fullheight
string
length
string
modestysize
string
panels
string
sides
string
spiralsteelbones
string
totallength
string
unit
stringcm
wiresize
string
display
stringall
displayfrom
string
displayto
string
grossweight
string
hasbrandinfos
booleanfalse
hascareinstructions
booleanfalse
hascolorinfos
booleantrue
hascompositions
booleanfalse
hasdescription
booleantrue
hasdimensions
booleanfalse
hasmaterials
booleanfalse
hasotherspecifications
booleanfalse
haspromo
number0
hasshortdescription
booleantrue
hassizeinfos
booleantrue
hasspecifications
booleanfalse
hasstockinfos
booleanfalse
hasstylingtips
booleantrue
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-make-up
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-10-05 16:04:43'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 1.23 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('a9e1c32e-04dd-4c67-b3a8bf62163841ca',lcase(cart_actions.linkedproducts)) > 0 and cart_actions.linkedproducts is not null
)
id_actionbrandinglanguagenamecodetypeminimumOrdermaximumOrderminimumItemsmaximumItemsmaximumUseallowedItemsquotasusedCountlinkedproductslinkedthemeslinkedbrandslinkeditemparamsactiveFromactiveToisActive
linkedproducts
Query
Template: /system/api/products.cfc:1305
Execution Time: 2.66 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 <> 'SLTI4200'
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
string
isprivate
string0
rating
stringall
src
string/photobank/products/gjjm/slti4200/50351-mesh-make-up-plus-size.jpg
type
stringimg
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string6600
isprivate
string0
rating
stringall
src
string/photobank/products/gjjm/slti4200/50351-mesh-make-up-plus-size_crop.jpg
type
stringimg
width
string5320
variations
Struct
colors
Struct
beige
Struct
height
string
isprivate
string
rating
string
src
string/photobank/products/gjjm/slti4200/50351-mesh-make-up-plus-size.jpg
type
string
width
string
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-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mpez
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-bege
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 Make Up Strumpfhose.<br />Mikrofaser, Netzoptik und perfekte Passform.<br /><br />Verst&auml;rkte H&ouml;schen und Spitzen
guid
stringhttps://dev.divasboudoir.com/de/make-up-mikrofaser-und-netzstrumpfhosen-in-grossen-grossen-beige/slti4200.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. Hier in der Farbe Make Up.
keywords
string
title
stringMake up Mikrofaser- und Netzstrumpfhosen in großen Größen
seotitle
stringMake up Mikrofaser- und Netzstrumpfhosen in großen Größen
seouri
stringmake-up-mikrofaser-und-netzstrumpfhosen-in-grossen-grossen-beige
specifications
string
stylingtips
string<p><br data-mce-bogus="1"></p>
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. Hier in der Farbe Make Up.
title
stringMake up Mikrofaser- und Netzstrumpfhosen
usageinstructions
string
el
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringΈνα διαχρονικό ρετρό look για αυτά τα καλσόν Mesh Make Up.<br />Μικροΐνες, εμφάνιση διχτυωτού υφάσματος και τέλειο σχήμα.<br /><br />Ενισχυμένα εσώρουχα και δάχτυλα των ποδιών
guid
stringhttps://dev.divasboudoir.com/el/kalson-apo-mikroΐnes-kai-dichtywto-kalson-makigiaz-mpez/slti4200.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringΚαλσόν plus-size με όμορφα εσώρουχα από μικροΐνες και δικτυωτά πόδια. Μια υπέροχη ρετρό εμφάνιση. Εμφανίζεται στο χρώμα Make Up.
keywords
string
title
stringΚαλσόν από μικροΐνες και διχτυωτό καλσόν Μακιγιάζ
seotitle
stringΚαλσόν από μικροΐνες και διχτυωτό καλσόν Μακιγιάζ
seouri
stringkalson-apo-mikroΐnes-kai-dichtywto-kalson-makigiaz-mpez
specifications
string
stylingtips
string<p><br data-mce-bogus="1"></p>
summary
stringΚαλσόν plus-size με όμορφα εσώρουχα από μικροΐνες και δικτυωτά πόδια. Μια υπέροχη ρετρό εμφάνιση. Εμφανίζεται στο χρώμα Make Up.
title
stringΚαλσόν από μικροΐνες και διχτυωτό καλσόν Μακιγιάζ
usageinstructions
string
en
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringTimeless retro look for these Mesh Make Up tights.<br />Microfiber, fishnet look and perfect shape.<br /><br />Reinforced panty and toe
guid
stringhttps://dev.divasboudoir.com/en/plus-size-microfiber-and-fishnet-tights-make-up-beige/slti4200.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringPlus-size tights with pretty microfiber panties and fishnet legs. A great retro look. Shown here in Make Up color.
keywords
string
title
stringPlus size microfiber and fishnet tights Make up
seotitle
stringPlus size microfiber and fishnet tights Make up
seouri
stringplus-size-microfiber-and-fishnet-tights-make-up-beige
specifications
string
stylingtips
string<p><br data-mce-bogus="1"></p>
summary
stringPlus-size tights with pretty microfiber panties and fishnet legs. A great retro look. Shown here in Make Up color.
title
stringMicrofiber and fishnet tights Make up
usageinstructions
string
es
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringUn look retro atemporal para estas mallas Mesh Make Up.<br />Microfibra, aspecto de rejilla y forma perfecta.<br /><br />Braguitas y punteras reforzadas
guid
stringhttps://dev.divasboudoir.com/es/microfibra-y-medias-de-rejilla-maquillaje-beige/slti4200.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. En la imagen en color Make Up.
keywords
string
title
stringMicrofibra y medias de rejilla Maquillaje
seotitle
stringMicrofibra y medias de rejilla Maquillaje
seouri
stringmicrofibra-y-medias-de-rejilla-maquillaje-beige
specifications
string
stylingtips
string<p><br data-mce-bogus="1"></p>
summary
stringMedias de talla grande con bonitas braguitas de microfibra y piernas de rejilla. Un look retro estupendo. En la imagen en color Make Up.
title
stringMedias de microfibra y rejilla Maquillaje
usageinstructions
string
fr
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>Look r&eacute;tro ind&eacute;modable pour ces collants Mesh Make Up.<br>Microfibre, aspect r&eacute;sille et forme parfaite.<br><br>Culotte et pointes renforc&eacute;es</p>
guid
stringhttps://dev.divasboudoir.com/fr/collants-grande-taille-microfibre-et-resille-make-up-beige/slti4200.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. Ici en couleur Make Up.
keywords
string
title
stringCollants grande taille Microfibre et Résille Make up
seotitle
stringCollants grande taille Microfibre et Résille Make up
seouri
stringcollants-grande-taille-microfibre-et-resille-make-up-beige
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. Ici en couleur Make Up.</p>
title
stringCollants Microfibre et Résille Make up
usageinstructions
string
it
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringUn look retrò senza tempo per questi collant Mesh Make Up.<br />Microfibra, look a rete e forma perfetta.<br /><br />Mutandine e punte rinforzate
guid
stringhttps://dev.divasboudoir.com/it/collant-in-microfibra-e-a-rete-make-up-beige/slti4200.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. Mostrato qui nel colore Make Up.
keywords
string
title
stringCollant in microfibra e a rete Make up
seotitle
stringCollant in microfibra e a rete Make up
seouri
stringcollant-in-microfibra-e-a-rete-make-up-beige
specifications
string
stylingtips
string<p><br data-mce-bogus="1"></p>
summary
stringCollant di taglia grande con graziose mutandine in microfibra e gambe a rete. Un look retrò di grande effetto. Mostrato qui nel colore Make Up.
title
stringCollant in microfibra e a rete Make up
usageinstructions
string
nl
Struct
Entries: 15
abstract
string
careinstructions
string<p><br data-mce-bogus="1"></p>
description
string<p>Een tijdloze retro look voor deze Mesh Make Up panty.<br>Microvezel, visnet-look en perfecte vorm.<br><br>Versterkte panty en tenen</p>
guid
stringhttps://dev.divasboudoir.com/nl/microvezel-en-netpantys-make-up-beige/slti4200.htm
highlights
string<p><br data-mce-bogus="1"></p>
keypoint
string
keywords
string
metas
Struct
description
stringPanty van groote maat met mooie microvezelslipjes en visnetpijpen. Een geweldige retro look. Hier afgebeeld in de kleur Make Up.
keywords
string
title
stringMicrovezel en netpanty's Make-up
seotitle
stringMicrovezel en netpanty's Make-up
seouri
stringmicrovezel-en-netpantys-make-up-beige
specifications
string<p><br data-mce-bogus="1"></p>
stylingtips
string<p><br data-mce-bogus="1"></p>
summary
string<p>Panty van groote maat met mooie microvezelslipjes en visnetpijpen. Een geweldige retro look. Hier afgebeeld in de kleur Make Up.</p>
title
stringMicrovezel en netpanty's Make-up
usageinstructions
string<p><br data-mce-bogus="1"></p>
pt
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringUm look retro intemporal para estes collants Mesh Make Up.<br />Microfibra, aspeto de rede e forma perfeita.<br /><br />Calcinhas e dedos dos pés reforçados
guid
stringhttps://dev.divasboudoir.com/pt/collants-de-microfibra-e-de-rede-maquilhagem-bege/slti4200.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. Mostrado aqui na cor Make Up.
keywords
string
title
stringCollants de microfibra e de rede Maquilhagem
seotitle
stringCollants de microfibra e de rede Maquilhagem
seouri
stringcollants-de-microfibra-e-de-rede-maquilhagem-bege
specifications
string
stylingtips
string<p><br data-mce-bogus="1"></p>
summary
stringCollants de tamanho grande com bonitas cuecas de microfibra e pernas de rede. Um ótimo look retro. Mostrado aqui na cor Make Up.
title
stringCollants de microfibra e de rede Maquilhagem
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-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mpez
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-bege
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
latexboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mpez
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-bege
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
legsboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string<ul><li>Handwäsche in kaltem Wasser</li><li>Nicht auswringen</li><li>Flach im Schatten trocknen</li><li>Vorsichtige Behandlung zum Erhalt des Mesh</li></ul>
description
string<p><strong>Eine Strumpfhose, die Retro-Eleganz feiert</strong>, entwickelt, um Vintage-Stil mit modernem Komfort zu verbinden. Das Mikrofaser-Höschen bietet eine undurchsichtige und komfortable Bedeckung, während die Mesh-Beine einen raffinierten sinnlichen Akzent setzen. Der weite Schnitt an Hüften und Oberschenkeln garantiert eine perfekte Passform.</p>
highlights
string<ul><li><strong>Retro-Look</strong> zeitlos und elegant</li><li><strong>Mikrofaser-Höschen</strong> undurchsichtig und komfortabel</li><li><strong>Mesh-Beine</strong> für einen sinnlichen Effekt</li><li><strong>Make-up Farbe</strong> sophistiziertes Beige</li><li><strong>Verstärktes Höschen und Spitze</strong> für optimale Haltbarkeit</li></ul>
keypoint
string
keywords
string
metas
Struct
description
stringMesh Strumpfhose in Übergröße make-up von Leg's Boudoir. Zeitloser Retro-Look, Mikrofaser und Mesh. Komfort und Vintage-Eleganz garantiert.
keywords
string
title
stringRetro Mesh Strumpfhose Übergröße Make-up | Leg's Boudoir
seotitle
stringÜbergröße Mesh Strumpfhose Make-up - Zeitloser Retro Look
seouri
stringuebergroesse-mesh-strumpfhose-make-up-retro
specifications
string<ul><li><strong>Material :</strong> Mikrofaser und Mesh</li><li><strong>Farbe :</strong> Make-up (Beige)</li><li><strong>Stil :</strong> Undurchsichtiges Höschen, Mesh-Beine</li><li><strong>Schnitt :</strong> Weit an Hüften und Oberschenkeln</li><li><strong>Verarbeitung :</strong> Verstärktes Höschen und Spitze</li></ul>
stylingtips
string<p>Kombinieren Sie diese Strumpfhose mit einem <strong>Tellerrock</strong> oder einem <strong>Vintage-Bleistiftrock</strong> für einen kompletten Retro-Look. Perfekt mit <strong>High Heels</strong> und einer <strong>Seidenbluse</strong> für zeitlose Eleganz.</p>
summary
string<p><strong>Erleben Sie den Retro-Charme</strong> mit dieser Übergröße-Strumpfhose im zeitlosen Look. Ein <u>Vintage-Accessoire</u>, das Mikrofaser-Eleganz und Mesh-Sinnlichkeit zu einem einzigartigen Stil vereint.</p>
title
stringRetro Mesh Eleganz Strumpfhose
usageinstructions
string<p>Diese Strumpfhose lässt sich dank ihres großzügigen Schnitts leicht anziehen. Das verstärkte Höschen sorgt für komfortable Unterstützung, während die Mesh-Beine einen fesselnden visuellen Effekt erzeugen. Perfekt für einen Retro-Chic-Look im Alltag oder für besondere Anlässe.</p>
el
Struct
Entries: 14
abstract
string
careinstructions
string<ul><li>Πλύσιμο στο χέρι με κρύο νερό</li><li>Μην στρίβετε</li><li>Στεγνώστε επίπεδα στη σκιά</li><li>Προσεκτικός χειρισμός για να διατηρηθεί το δίχτυ</li></ul>
description
string<p><strong>Ένα καλσόν που γιορτάζει τη ρετρό κομψότητα</strong>, σχεδιασμένο να συνδυάζει vintage στιλ και σύγχρονη άνεση. Το εσώρουχο από μικροΐνες προσφέρει αδιαφανή και άνετη κάλυψη, ενώ τα διχτυωτά πόδια προσθέτουν έναν εκλεπτυσμένο αισθησιακό τόνο. Η ευρεία γραμμή στους γοφούς και τους μηρούς εγγυάται τέλεια εφαρμογή.</p>
highlights
string<ul><li><strong>Ρετρό look</strong> διαχρονικό και κομψό</li><li><strong>Εσώρουχο από μικροΐνες</strong> αδιαφανές και άνετο</li><li><strong>Πόδια διχτυωτά</strong> για αισθησιακό εφέ</li><li><strong>Χρώμα make-up</strong> εκλεπτυσμένο μπεζ</li><li><strong>Ενισχυμένο εσώρουχο και μύτη</strong> για βέλτιστη ανθεκτικότητα</li></ul>
keypoint
string
keywords
string
metas
Struct
description
stringΔιχτυωτό καλσόν μεγάλου μεγέθους make-up από το Leg's Boudoir. Διαχρονικό ρετρό στιλ, μικροΐνες και δίχτυ. Άνεση και vintage κομψότητα εγγυημένα.
keywords
string
title
stringΡετρό Διχτυωτό Καλσόν Μεγάλου Μεγέθους Make-up | Leg's Boudoir
seotitle
stringΚαλσόν Μεγάλου Μεγέθους Διχτυωτό Make-up - Διαχρονικό Ρετρό Στιλ
seouri
stringkalson-megalou-megethous-dichtyoto-make-up-retro
specifications
string<ul><li><strong>Υλικό :</strong> Μικροΐνες και δίχτυ</li><li><strong>Χρώμα :</strong> Make-up (μπεζ)</li><li><strong>Στιλ :</strong> Αδιαφανές εσώρουχο, διχτυωτά πόδια</li><li><strong>Γραμμή :</strong> Ευρεία στους γοφούς και τους μηρούς</li><li><strong>Τελειώματα :</strong> Ενισχυμένο εσώρουχο και μύτη</li></ul>
stylingtips
string<p>Συνδυάστε το με ένα <strong>φόρεμα σε γραμμή Α</strong> ή μια <strong>vintage φούστα μολύβι</strong> για ένα ολοκληρωμένο ρετρό look. Τέλειο με <strong>ψηλοτάκουνα</strong> και μια <strong>μεταξωτή μπλούζα</strong> για διαχρονική κομψότητα.</p>
summary
string<p><strong>Αγκαλιάστε τη ρετρό γοητεία</strong> με αυτό το καλσόν μεγάλου μεγέθους και διαχρονικό look. Ένα <u>vintage αξεσουάρ</u> που συνδυάζει την κομψότητα της μικροΐνας και τη θηλυκότητα του διχτυωτού για ένα μοναδικό στιλ.</p>
title
stringΡετρό Μεταξωτή Κομψότητα Καλσόν
usageinstructions
string<p>Αυτό το καλσόν φοριέται εύκολα χάρη στη γενναιόδωρη γραμμή του. Το ενισχυμένο εσώρουχο εξασφαλίζει άνετη στήριξη, ενώ τα διχτυωτά πόδια δημιουργούν ένα συναρπαστικό οπτικό εφέ. Ιδανικό για ένα ρετρό σικ look καθημερινά ή για μια ειδική περίσταση.</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 celebrate retro elegance</strong>, designed to blend vintage style with modern comfort. The microfiber panty offers opaque and comfortable coverage, while the mesh legs add a sophisticated sensual touch. The wide cut around hips and thighs guarantees a perfect fit.</p>
highlights
string<ul><li><strong>Retro look</strong> timeless and elegant</li><li><strong>Microfiber panty</strong> opaque and comfortable</li><li><strong>Mesh legs</strong> for a sensual effect</li><li><strong>Make-up color</strong> sophisticated beige</li><li><strong>Reinforced panty and toe</strong> for optimal durability</li></ul>
keypoint
string
keywords
string
metas
Struct
description
stringPlus size mesh tights make-up from Leg's Boudoir. Timeless retro look, microfiber and mesh. Comfort and vintage elegance guaranteed.
keywords
string
title
stringRetro Mesh Tights Plus Size Make-up | Leg's Boudoir
seotitle
stringPlus Size Mesh Tights Make-up - Timeless Retro Look
seouri
stringplus-size-mesh-tights-make-up-retro
specifications
string<ul><li><strong>Material :</strong> Microfiber and mesh</li><li><strong>Color :</strong> Make-up (beige)</li><li><strong>Style :</strong> Opaque panty, mesh legs</li><li><strong>Fit :</strong> Wide around hips and thighs</li><li><strong>Finishes :</strong> Reinforced panty and toe</li></ul>
stylingtips
string<p>Pair these tights with a <strong>skater dress</strong> or a <strong>vintage pencil skirt</strong> for a complete retro look. Perfect with <strong>high heels</strong> and a <strong>silk blouse</strong> for timeless elegance.</p>
summary
string<p><strong>Embrace retro charm</strong> with these plus-size tights featuring a timeless look. A <u>vintage accessory</u> that combines microfiber elegance and mesh sensuality for a unique style.</p>
title
stringRetro Mesh Elegance Tights
usageinstructions
string<p>These tights slip on easily thanks to their generous cut. The reinforced panty ensures comfortable support, while the mesh legs create a captivating visual effect. Perfect for a retro chic look every day or for a special occasion.</p>
es
Struct
Entries: 14
abstract
string
careinstructions
string<ul><li>Lavado a mano en agua fría</li><li>No retorcer</li><li>Secar extendido a la sombra</li><li>Manipulación delicada para preservar la red</li></ul>
description
string<p><strong>Unas medias que celebran la elegancia retro</strong>, diseñadas para combinar estilo vintage y comodidad moderna. La braga de microfibre ofrece una cobertura opaca y cómoda, mientras que las piernas de red añaden un toque sensual sofisticado. El corte ancho en caderas y muslos garantiza un ajuste perfecto.</p>
highlights
string<ul><li><strong>Look retro</strong> atemporal y elegante</li><li><strong>Braga de microfibre</strong> opaca y cómoda</li><li><strong>Piernas de red</strong> para un efecto sensual</li><li><strong>Color make-up</strong> beige sofisticado</li><li><strong>Braga y punta reforzadas</strong> para durabilidad óptima</li></ul>
keypoint
string
keywords
string
metas
Struct
description
stringMedias mesh talla grande make-up de Leg's Boudoir. Look retro atemporal, microfibre y red. Confort y elegancia vintage garantizados.
keywords
string
title
stringMedias Retro Mesh Talla Grande Make-up | Leg's Boudoir
seotitle
stringMedias Talla Grande Mesh Make-up - Look Retro Atemporal
seouri
stringmedias-talla-grande-mesh-make-up-retro
specifications
string<ul><li><strong>Material :</strong> Microfibre y red</li><li><strong>Color :</strong> Make-up (beige)</li><li><strong>Estilo :</strong> Braga opaca, piernas de red</li><li><strong>Corte :</strong> Ancho en caderas y muslos</li><li><strong>Acabados :</strong> Braga y punta reforzadas</li></ul>
stylingtips
string<p>Combina estas medias con un <strong>vestido de vuelo</strong> o una <strong>falda lápiz vintage</strong> para un look retro completo. Perfectas con <strong>tacones</strong> y una <strong>blusa de seda</strong> para una elegancia atemporal.</p>
summary
string<p><strong>Adopta el encanto retro</strong> con estas medias talla grande de look atemporal. Un <u>accesorio vintage</u> que combina elegancia de microfibre y sensualidad de red para un estilo único.</p>
title
stringElegancia Retro con nuestras Medias Rejilla
usageinstructions
string<p>Estas medias se colocan fácilmente gracias a su generoso corte. La braga reforzada asegura un soporte cómodo, mientras que las piernas de red crean un efecto visual cautivador. Perfectas para un look retro chic en el día a día o para una ocasión especial.</p>
fr
Struct
Entries: 14
abstract
string
careinstructions
string<ul><li>Lavage à la main en eau froide</li><li>Ne pas tordre</li><li>Séchage à plat à l'ombre</li><li>Manipulation délicate pour préserver la résille</li></ul>
description
string<p><strong>Un collant qui célèbre l'élégance rétro</strong>, pensé pour allier style vintage et confort moderne. La culotte en microfibre offre une couverture opaque et confortable, tandis que les jambes en résille apportent une touche de sensualité sophistiquée. La coupe large aux hanches et aux cuisses garantit un ajustement parfait.</p>
highlights
string<ul><li><strong>Look rétro</strong> indémodable et élégant</li><li><strong>Culotte microfibre</strong> opaque et confortable</li><li><strong>Jambes en résille</strong> pour un effet sensuel</li><li><strong>Couleur make-up</strong> beige sophistiquée</li><li><strong>Culotte et pointes renforcées</strong> pour une durabilité optimale</li></ul>
keypoint
string
keywords
string
metas
Struct
description
stringCollants grande taille résille make-up de Leg's Boudoir. Look rétro indémodable, microfibre et résille. Confort et élégance vintage garantis.
keywords
string
title
stringCollants Résille Rétro Grande Taille Make-up | Leg's Boudoir
seotitle
stringCollants Grande Taille Résille Make-up - Look Rétro Indémodable
seouri
stringcollants-grande-taille-resille-make-up-retro
specifications
string<ul><li><strong>Matière :</strong> Microfibre et résille</li><li><strong>Couleur :</strong> Make-up (beige)</li><li><strong>Style :</strong> Culotte opaque, jambes résille</li><li><strong>Coupe :</strong> Large aux hanches et aux cuisses</li><li><strong>Finitions :</strong> Culotte et pointes renforcées</li></ul>
stylingtips
string<p>Associez ces collants avec une <strong>robe patineuse</strong> ou une <strong>jupe crayon vintage</strong> pour un look rétro complet. Parfaits avec des <strong>escarpins à talons</strong> et un <strong>chemisier en soie</strong> pour une élégance intemporelle.</p><p>Maillage interne :</p><ul><li><a href="https://www.legsboudoir.com/fr/collants-grande-taille/" data-mce-href="https://www.legsboudoir.com/fr/collants-grande-taille/" rel="noreferrer">Découvrez notre collection de collants grande taille</a></li><li><a data-mce-href="https://www.legsboudoir.com/fr/collants-ouverts-grande-taille/" href="https://www.legsboudoir.com/fr/collants-ouverts-grande-taille/" rel="noreferrer">Explorez notre collection de collants ouverts</a></li></ul>
summary
string<p><strong>Adoptez le charme rétro</strong> avec ces collants grande taille au look indémodable. Un <u>accessoire vintage</u> qui allie élégance microfibre et sensualité résille pour un style unique.</p>
title
stringCollants Mesh Rétro Élégance
usageinstructions
string<p>Ces collants s'enfilent facilement grâce à leur coupe généreuse. La culotte renforcée assure un maintien confortable, tandis que les jambes en résille créent un effet visuel captivant. Parfaits pour un look rétro chic au quotidien ou pour une occasion spéciale.</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 celebra l'eleganza retrò</strong>, progettato per fondere stile vintage e comfort moderno. La culotte in microfibra offre una copertura opaca e confortevole, mentre le gambe in rete aggiungono un tocco sensuale sofisticato. Il taglio ampio su fianchi e cosce garantisce una vestibilità perfetta.</p>
highlights
string<ul><li><strong>Look retrò</strong> intramontabile ed elegante</li><li><strong>Culotte in microfibra</strong> opaca e confortevole</li><li><strong>Gambe in rete</strong> per un effetto sensuale</li><li><strong>Colore make-up</strong> beige sofisticato</li><li><strong>Culotte e punta rinforzate</strong> per durabilità ottimale</li></ul>
keypoint
string
keywords
string
metas
Struct
description
stringCollant mesh taglie forti make-up di Leg's Boudoir. Look retrò intramontabile, microfibra e rete. Comfort ed eleganza vintage garantiti.
keywords
string
title
stringCollant Retrò Mesh Taglie Forti Make-up | Leg's Boudoir
seotitle
stringCollant Taglie Forti Mesh Make-up - Look Retrò Intramontabile
seouri
stringcollant-taglie-forti-mesh-make-up-retro
specifications
string<ul><li><strong>Materiale :</strong> Microfibra e rete</li><li><strong>Colore :</strong> Make-up (beige)</li><li><strong>Stile :</strong> Culotte opaca, gambe in rete</li><li><strong>Taglio :</strong> Ampio su fianchi e cosce</li><li><strong>Finiture :</strong> Culotte e punta rinforzate</li></ul>
stylingtips
string<p>Abbina questi collant con un <strong>abito a ruota</strong> o una <strong>gonna a matita vintage</strong> per un look retrò completo. Perfetti con <strong>décolleté</strong> e una <strong>blusa di seta</strong> per un'eleganza senza tempo.</p>
summary
string<p><strong>Abbraccia il fascino retrò</strong> con questi collant taglie forti dal look intramontabile. Un <u>accessorio vintage</u> che combina l'eleganza della microfibra e la sensualità della rete per uno stile unico.</p>
title
stringEleganza Retrò Collant Mesh
usageinstructions
string<p>Questi collant si infilano facilmente grazie al loro taglio generoso. La culotte rinforzata assicura un supporto confortevole, mentre le gambe in rete creano un effetto visivo affascinante. Perfetti per un look retrò chic di ogni giorno o per un'occasione speciale.</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 retro elegantie viert</strong>, ontworpen om vintage stijl en modern comfort te combineren. Het microfiber broekje biedt ondoorzichtige en comfortabele bedekking, terwijl de netbenen een verfijnde sensuele touch toevoegen. De ruime pasvorm rond heupen en dijen garandeert een perfecte fit.</p>
highlights
string<ul><li><strong>Retro look</strong> tijdloos en elegant</li><li><strong>Microfiber broekje</strong> ondoorzichtig en comfortabel</li><li><strong>Netbenen</strong> voor een sensueel effect</li><li><strong>Make-up kleur</strong> verfijnd beige</li><li><strong>Versterkt broekje en teen</strong> voor optimale duurzaamheid</li></ul>
keypoint
string
keywords
string
metas
Struct
description
stringGrote maat netpanty make-up van Leg's Boudoir. Tijdloze retro look, microfiber en net. Comfort en vintage elegantie gegarandeerd.
keywords
string
title
stringRetro Netpanty Grote Maat Make-up | Leg's Boudoir
seotitle
stringGrote Maat Netpanty Make-up - Tijdloze Retro Look
seouri
stringgrote-maat-netpanty-make-up-retro
specifications
string<ul><li><strong>Materiaal :</strong> Microfiber en net</li><li><strong>Kleur :</strong> Make-up (beige)</li><li><strong>Stijl :</strong> Ondoorzichtig broekje, netbenen</li><li><strong>Pasvorm :</strong> Breed rond heupen en dijen</li><li><strong>Afwerking :</strong> Versterkt broekje en teen</li></ul>
stylingtips
string<p>Combineer deze panty's met een <strong>skater jurk</strong> of een <strong>vintage kokerrok</strong> voor een complete retro look. Perfect met <strong>pumps met hak</strong> en een <strong>zijden blouse</strong> voor tijdloze elegantie.</p>
summary
string<p><strong>Omarm de retro charme</strong> met deze grote maat panty met tijdloze uitstraling. Een <u>vintage accessoire</u> dat microfiber elegantie en net sensualiteit combineert voor een unieke stijl.</p>
title
stringMesh Retro Elegantie Panty
usageinstructions
string<p>Deze panty's glijden gemakkelijk aan dankzij hun ruime pasvorm. Het versterkte broekje zorgt voor comfortabele ondersteuning, terwijl de netbenen een boeiend visueel effect creëren. Perfect voor een retro chique look voor elke dag of voor een speciale gelegenheid.</p>
pt
Struct
Entries: 14
abstract
string
careinstructions
string<ul><li>Lavar à mão em água fria</li><li>Não torcer</li><li>Secar deitada à sombra</li><li>Manuseio delicado para preservar a tela</li></ul>
description
string<p><strong>Uma meia-calça que celebra a elegância retrô</strong>, projetada para combinar estilo vintage e conforto moderno. A parte íntima de microfibra oferece cobertura opaca e confortável, enquanto as pernas em tela adicionam um toque sensual sofisticado. O corte largo nos quadris e coxas garante um ajuste perfeito.</p>
highlights
string<ul><li><strong>Look retrô</strong> atemporal e elegante</li><li><strong>Parte íntima de microfibra</strong> opaca e confortável</li><li><strong>Pernas em tela</strong> para um efeito sensual</li><li><strong>Cor make-up</strong> bege sofisticado</li><li><strong>Parte íntima e ponta reforçadas</strong> para durabilidade máxima</li></ul>
keypoint
string
keywords
string
metas
Struct
description
stringMeia-calça mesh plus size make-up de Leg's Boudoir. Look retrô atemporal, microfibra e tela. Conforto e elegância vintage garantidos.
keywords
string
title
stringMeia-Calça Retrô Mesh Plus Size Make-up | Leg's Boudoir
seotitle
stringMeia-Calça Plus Size Mesh Make-up - Look Retrô Atemporal
seouri
stringmeia-calca-plus-size-mesh-make-up-retro
specifications
string<ul><li><strong>Material :</strong> Microfibra e tela</li><li><strong>Cor :</strong> Make-up (bege)</li><li><strong>Estilo :</strong> Parte íntima opaca, pernas em tela</li><li><strong>Corte :</strong> Largo nos quadris e coxas</li><li><strong>Acabamentos :</strong> Parte íntima e ponta reforçadas</li></ul>
stylingtips
string<p>Combine estas meias-calça com um <strong>vestido godê</strong> ou uma <strong>saia lápis vintage</strong> para um look retrô completo. Perfeitas com <strong>scarpin</strong> e uma <strong>blusa de seda</strong> para uma elegância atemporal.</p>
summary
string<p><strong>Abrace o charme retrô</strong> com esta meia-calça plus size de look atemporal. Um <u>acessório vintage</u> que combina elegância de microfibra e sensualidade de tela para um estilo único.</p>
title
stringElegância Retro Meia-Calça Mesh
usageinstructions
string<p>Estas meias-calça deslizam facilmente graças ao seu corte generoso. A parte íntima reforçada garante suporte confortável, enquanto as pernas em tela criam um efeito visual cativante. Perfeitas para um look retrô chique no dia a dia ou para uma ocasião especial.</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-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mpez
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-bege
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-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mpez
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-bege
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
name
string50351 Mesh collants make up
netweight
string
nextshipment
stringtomorrow
ordered
number1
orderidx
number0
origin
stringeu
originalsize
string
packaging
string
productshipment
stringauto
productuid
stringA9E1C32E-04DD-4C67-B3A8BF62163841CA
promountil
string
rating
stringnone
recorduid
stringA9E1C32E-04DD-4C67-B3A8BF62163841CA
reference
stringSLTI4200
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: 3.03 ms
Record Count: 5
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,'1046,1047,1048,1049,1050') > 0
and product_variations.productuid = 'A9E1C32E-04DD-4C67-B3A8BF62163841CA'
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
1104642-44intlsizebeige4244-19999992wpluslingerieL42-4442-4412-1416-1844-4644-4642-4448-5042-4442-44
2104746-48intlsizebeige4648-19999990wpluslingerieXL46-4846-4816-1820-2248-5048-5046-4852-5448-5046-48
3104850-52intlsizebeige5052-19999990wpluslingerie2XL50-5250-5220-2224-2652-5452-5450-5256-5852-5450-52
4104954-56intlsizebeige5456-19999991wpluslingerie3XL54-5654-5624-2628-3056-5856-5854-5660-6256-5854-56
5105056-58intlsizebeige5658-19999990wpluslingerie4XL56-5856-5826-2830-3258-6058-6056-5862-6458-6056-58
sizeranges
stringplus
sizes
string1046,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: 93.8 ms
Record Count: 5
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 = 'A9E1C32E-04DD-4C67-B3A8BF62163841CA'
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 = 'A9E1C32E-04DD-4C67-B3A8BF62163841CA'
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 = 'A9E1C32E-04DD-4C67-B3A8BF62163841CA'
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 = 'A9E1C32E-04DD-4C67-B3A8BF62163841CA'
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 = 'A9E1C32E-04DD-4C67-B3A8BF62163841CA'
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
1A9E1C32E-04DD-4C67-B3A8BF62163841CAEC8CF0F5-588B-4754-8121A685982841FC1046beige#F6DBACL42-4442-4412-1416-1844-4644-4642-4448-5042-4442-44wlingerie42-44intlsize24.95830STOCK01200-1000050351426027713769422all
2A9E1C32E-04DD-4C67-B3A8BF62163841CA124C8726-2C77-4E9C-ADA9CE4B18B6EEE21047beige#F6DBACXL46-4846-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie46-48intlsize24.95830STOCK01000-10000503514260277137700-10all
3A9E1C32E-04DD-4C67-B3A8BF62163841CAAF5550CB-85D6-4D38-B8455631D6F0BE5E1048beige#F6DBAC2XL50-5250-5220-2224-2652-5452-5450-5256-5852-5450-52wlingerie50-52intlsize24.95830STOCK01000-10000503514260277137717-10all
4A9E1C32E-04DD-4C67-B3A8BF62163841CA269070F5-A430-46E8-83356336B96248461049beige#F6DBAC3XL54-5654-5624-2628-3056-5856-5854-5660-6256-5854-56wlingerie54-56intlsize24.95830STOCK01100-1010050351426027713772411all
5A9E1C32E-04DD-4C67-B3A8BF62163841CAE1B73F3C-8661-464E-9556069AD61878091050beige#F6DBAC4XL56-5856-5826-2830-3258-6058-6056-5862-6458-6056-58wlingerie56-58intlsize24.95830STOCK01000-10000503514260277137731-10all
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: 13.3 ms
Record Count: 5
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 = 'A9E1C32E-04DD-4C67-B3A8BF62163841CA' 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 = 'A9E1C32E-04DD-4C67-B3A8BF62163841CA' 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 = 'A9E1C32E-04DD-4C67-B3A8BF62163841CA' 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 = 'A9E1C32E-04DD-4C67-B3A8BF62163841CA' 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 = 'A9E1C32E-04DD-4C67-B3A8BF62163841CA' 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 = 'A9E1C32E-04DD-4C67-B3A8BF62163841CA' 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 = 'A9E1C32E-04DD-4C67-B3A8BF62163841CA'
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 = 'A9E1C32E-04DD-4C67-B3A8BF62163841CA' 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 = 'A9E1C32E-04DD-4C67-B3A8BF62163841CA' 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 = 'A9E1C32E-04DD-4C67-B3A8BF62163841CA' 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 = 'A9E1C32E-04DD-4C67-B3A8BF62163841CA' 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 = 'A9E1C32E-04DD-4C67-B3A8BF62163841CA' 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 = 'A9E1C32E-04DD-4C67-B3A8BF62163841CA' 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 = 'A9E1C32E-04DD-4C67-B3A8BF62163841CA'
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 = 'A9E1C32E-04DD-4C67-B3A8BF62163841CA' 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 = 'A9E1C32E-04DD-4C67-B3A8BF62163841CA' 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 = 'A9E1C32E-04DD-4C67-B3A8BF62163841CA' 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 = 'A9E1C32E-04DD-4C67-B3A8BF62163841CA' 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 = 'A9E1C32E-04DD-4C67-B3A8BF62163841CA' 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 = 'A9E1C32E-04DD-4C67-B3A8BF62163841CA' 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 = 'A9E1C32E-04DD-4C67-B3A8BF62163841CA'
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 = 'A9E1C32E-04DD-4C67-B3A8BF62163841CA' 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 = 'A9E1C32E-04DD-4C67-B3A8BF62163841CA' 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 = 'A9E1C32E-04DD-4C67-B3A8BF62163841CA' 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 = 'A9E1C32E-04DD-4C67-B3A8BF62163841CA' 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 = 'A9E1C32E-04DD-4C67-B3A8BF62163841CA' 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 = 'A9E1C32E-04DD-4C67-B3A8BF62163841CA' 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 = 'A9E1C32E-04DD-4C67-B3A8BF62163841CA'
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 = 'A9E1C32E-04DD-4C67-B3A8BF62163841CA' 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 = 'A9E1C32E-04DD-4C67-B3A8BF62163841CA' 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 = 'A9E1C32E-04DD-4C67-B3A8BF62163841CA' 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 = 'A9E1C32E-04DD-4C67-B3A8BF62163841CA' 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 = 'A9E1C32E-04DD-4C67-B3A8BF62163841CA' 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 = 'A9E1C32E-04DD-4C67-B3A8BF62163841CA' 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 = 'A9E1C32E-04DD-4C67-B3A8BF62163841CA'
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
1EC8CF0F5-588B-4754-8121A685982841FC1046beige#F6DBACL42-4442-4412-1416-1844-4644-4642-4448-5042-4442-44wlingerie42-44intlsize24.95830STOCK01200-1000050351426027713769422-12-13024.9583all
2124C8726-2C77-4E9C-ADA9CE4B18B6EEE21047beige#F6DBACXL46-4846-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie46-48intlsize24.95830STOCK01000-10000503514260277137700-10-10-13024.9583all
3AF5550CB-85D6-4D38-B8455631D6F0BE5E1048beige#F6DBAC2XL50-5250-5220-2224-2652-5452-5450-5256-5852-5450-52wlingerie50-52intlsize24.95830STOCK01000-10000503514260277137717-10-10-13024.9583all
4269070F5-A430-46E8-83356336B96248461049beige#F6DBAC3XL54-5654-5624-2628-3056-5856-5854-5660-6256-5854-56wlingerie54-56intlsize24.95830STOCK01100-1010050351426027713772411-11-13024.9583all
5E1B73F3C-8661-464E-9556069AD61878091050beige#F6DBAC4XL56-5856-5826-2830-3258-6058-6056-5862-6458-6056-58wlingerie56-58intlsize24.95830STOCK01000-10000503514260277137731-10-10-13024.9583all
vatrate
number20
warehouse
string