Το καλάθι μου

❌
Σύνολο αντικειμένων
Προβολή καλαθιού
Μενού
Δείτε τα μεγέθη
Καλσόν υποστήριξης ζωτικής σημασίας
Διπλό κλικ για μεγέθυνση
SKU: SLTI8723
Καλσόν υποστήριξης ζωτικής σημασίας
MADE IN
Απόθεμα:

Μεγάλα καλσόν ειδικά σχεδιασμένα για να στηρίζουν και να ανακουφίζουν τα πόδια σας.

Μέγεθος:

Δεν είστε σίγουροι για το μέγεθος που πρέπει να επιλέξετε Συμβουλευτείτε τον οδηγό μεγεθών μας

Χρώμα:
Ποσότητα:
23.95 €
Βοήθεια και συμβουλές
μέσω chat, facebook ή e-mail
Δωρεάν επιστροφές
εντός 15 ημερών *

Vital plus size καλσόν υποστήριξης

Περιγραφή του προϊόντος

Το καλσόν Vital είναι ένα πολύ σταθερό καλσόν 40 den που υποστηρίζει όλο το μήκος των ποδιών.

Είναι ημι-αδιαφανή, φαρδιά στους γοφούς και τους μηρούς, καθιστώντας τα πολύ άνετα στη χρήση.

Με επίπεδες ραφές και ενισχυμένα δάχτυλα στα δάχτυλα των ποδιών.

Τεχνικές λεπτομέρειες

Διαθέσιμα μεγέθη

Διαθέσιμο από 38-40 έως 56-58

Διαθέσιμα χρώματα

Μαύρο , Μπεζ και Σάρκα

To Top
Προβολή καλαθιού
Άρθρα
Σύνολο αντικειμένων
Struct
Entries: 108
actions
Array
available
number-1
brand
stringglamory
brandcode
stringgjjm
branding
stringdivasboudoir,legsboudoir
brandmedias
string{"default":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"editorial":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"logo":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""}}
brandmetas
Struct
de
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
el
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
en
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
es
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
fr
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
it
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
nl
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
pt
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
brandname
stringGlamory
breasts
stringna
careinstructions
string
categories
stringdivasboudoir.lingerie.hoisery.tights
category
stringhoisery
categorygender
stringm
categorymediadatas
Struct
adult
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string410
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/lingerie/hoisery/tights.jpg
type
stringimg
width
string891
divasboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
fetishboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
latexboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
legsboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
lustboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
private
Struct
height
string1016
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/private/default.jpg
type
stringimg
width
string703
smboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
categorysizerange
stringauto
colorinfos
Query
Template: /system/api/product/colors.cfc:13
Execution Time: 0.977 ms
Record Count: 3
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_colors.color as recorduid, product_colors.type, product_colors.code, product_colors.color, product_colors.range, product_colors.hexvalue,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock
from product_colors
left outer join product_variations on product_colors.color = product_variations.color and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
where FIND_IN_SET(product_colors.color,'black,beige,nude') > 0
and product_variations.productuid = '9B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1blackcolorblakblackblack#000000-14
2beigecolorbeigbeigebrown#F6DBAC-13
3nudecolornudenudepink#E3BC9A-12
colorrange
stringbrown
colors
stringblack,beige,nude
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 '2020-09-17 10:25:41'}
defect
number0
dimensions
Struct
Entries: 14
acrylicbones
string
backsideheight
string
diameter
string
flatsteelbones
string
frontsideheight
string
fullheight
string
length
string
modestysize
string
panels
string
sides
string
spiralsteelbones
string
totallength
string
unit
stringcm
wiresize
string
display
stringall
displayfrom
string
displayto
string
grossweight
string
hasbrandinfos
booleanfalse
hascareinstructions
booleanfalse
hascolorinfos
booleantrue
hascompositions
booleanfalse
hasdescription
booleantrue
hasdimensions
booleanfalse
hasmaterials
booleanfalse
hasotherspecifications
booleanfalse
haspromo
number0
hasshortdescription
booleantrue
hassizeinfos
booleantrue
hasspecifications
booleanfalse
hasstockinfos
booleanfalse
hasstylingtips
booleanfalse
hasusageinstructions
booleanfalse
hasvariations
booleantrue
import
string
inpromo
number0
instockvariations
string
isactive
number1
iscustommade
number0
isdivasize
number1
isfirstprice
number0
isfixedprice
number0
ishot
number0
isnew
number0
isonline
number0
isoutletprice
number0
itemprice
number19.9583
itempromo
string
key
string5124-vital
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-10-05 16:49:28'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.591 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','el')
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('9b28d5b4-bbcb-4de6-8f6dcd138ca69de7',lcase(cart_actions.linkedproducts)) > 0 and cart_actions.linkedproducts is not null
)
id_actionbrandinglanguagenamecodetypeminimumOrdermaximumOrderminimumItemsmaximumItemsmaximumUseallowedItemsquotasusedCountlinkedproductslinkedthemeslinkedbrandslinkeditemparamsactiveFromactiveToisActive
linkedproducts
Query
Template: /system/api/products.cfc:1305
Execution Time: 1.31 ms
Record Count: 0
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select products.productuid as productuid, products.reference, 'default' as type, products.key, products.language, products.name,
product_links.linkuid,
products.colors, products.vatrate, products.metadatas, products.dimensions,
products.mediadatas, products.tags, products.themes, products.isdivasize,
count(distinct product_variations.variationuid) as totalvariations,
group_concat(distinct product_variations.variationuid) as variationlist,
count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END) as inpromo,
if(count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END)>0,1,0) as haspromo,
(select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0) END)) as itempromo,
IFNULL(min(product_variations.itemprice),0) as itemprice,
(select IF (products.isfixedprice = 0 and sum(product_variations.itempromo) > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null), IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0), IFNULL(min(NULLIF(product_variations.itemprice, 0)), 0) )) as unitprice,
count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.itempromo ELSE product_variations.itemprice END) as prices,
(select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN min(NULLIF(product_variations.promountil, 0)) END)) as promountil,
products.isfixedprice, products.ishot, products.isnew, if(products.orderidx > 0, products.orderidx, 999999999) as orderidx,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
count(distinct CASE WHEN ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) > 0 OR ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) <= 0 AND product_variations.supplier = 0)) THEN product_variations.variationuid END) as instockvariations,
products.brand, brands.name as brandname, IFNULL(brands.ispublic, 0) as showbrand, brands.display,
product_categories.sizetype,GROUP_CONCAT(DISTINCT product_sizes.suppliersize) as intlsize,products.sizes,product_sizes.sizerange,product_categories.mediadatas as categorymediadatas, product_categories.sizerange as categorysizerange,
product_categorymap.section, product_categorymap.category, product_categorymap.key as subcategory
from products
left outer join product_categorymap on products.productuid = product_categorymap.productuid
left outer join product_categories on (product_categories.branding = product_categorymap.branding and product_categories.section = product_categorymap.section and product_categories.category = product_categorymap.category and product_categories.key = product_categorymap.key)
left outer join product_sizes on product_sizes.id_size IN (products.sizes)
left outer join brands on products.brand = brands.brand
left outer join product_variations on product_variations.productuid = products.productuid and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
left outer join product_links on product_links.reference = products.reference
where products.isactive = 1 and products.isdeleted = 0
and brands.isactive = 1 and brands.isdeleted = 0
and product_categories.isactive = 1 and product_categories.isdeleted = 0
and product_variations.isactive = 1
and FIND_IN_SET('divasboudoir',products.branding)
and product_categories.branding IN ('all','divasboudoir')
and product_categorymap.branding IN ('all','divasboudoir')
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and products.language in ('all','el')
and product_categories.language in ('all','el')
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 <> 'SLTI8723'
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
string1960
isprivate
string0
rating
stringall
src
string/photobank/products/gjjm/slti8723/50124-vital-40-black-plus-size.jpg
type
stringimg
width
string960
back
Struct
height
string759
isprivate
string0
rating
stringall
src
string/photobank/products/gjjm/slti8723/50124-vital-40_crop.jpg
type
stringimg
width
string529
default
Struct
height
string837
isprivate
string0
rating
stringall
src
string/photobank/products/gjjm/slti8723/50124-vital-40-make-up-plus-size_crop.jpg
type
stringimg
width
string711
variations
Struct
colors
Struct
beige
Struct
height
string1960
isprivate
string0
rating
stringall
src
string/photobank/products/gjjm/slti8723/50124-vital-40-make-up-plus-size.jpg
type
stringimg
width
string960
black
Struct
height
string1960
isprivate
string0
rating
stringall
src
string/photobank/products/gjjm/slti8723/50124-vital-40-black-plus-size.jpg
type
stringimg
width
string960
nude
Struct
height
string1960
isprivate
string0
rating
stringall
src
string/photobank/products/gjjm/slti8723/50124-vital-40-teint-plus-size.jpg
type
stringimg
width
string961
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
mediagallery
string
metadatas
Struct
darkboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz-beige-ou-fleisch
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro-mpez-ou-sarka
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black-beige-ou-nude
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro-beige-ou-carne
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-beige-ou-chair
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero-beige-ou-carne
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart-beige-ou-vlees
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto-bege-ou-carne
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
divasboudoir
Struct
de
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringDie Vital-Strumpfhose ist eine sehr starke 40-Den-Strumpfhose, die die Beine &uuml;ber die gesamte L&auml;nge st&uuml;tzt.<br /><br />Halbdurchsichtig, die H&uuml;ften und Oberschenkel sind sch&ouml;n breit f&uuml;r einen sehr guten Tragekomfort.<br /><br />Flache N&auml;hte und verst&auml;rkte Spitzen.
guid
stringhttps://dev.divasboudoir.com/de/vital-stutzstrumpfhose-in-grossen-grossen-schwarz-beige-ou-fleisch/slti8723.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringStrumpfhose in großen Größen, die speziell zur Unterstützung und Entlastung Ihrer Beine hergestellt wurde.
keywords
string
title
stringVital Stützstrumpfhose in großen Größen
seotitle
stringVital Stützstrumpfhose in großen Größen
seouri
stringvital-stutzstrumpfhose-in-grossen-grossen-schwarz-beige-ou-fleisch
specifications
string
stylingtips
string
summary
stringStrumpfhose in gro&szlig;en Gr&ouml;&szlig;en, die speziell zur Unterst&uuml;tzung und Entlastung Ihrer Beine hergestellt wurde.
title
stringVital Stützstrumpfhose
usageinstructions
string
el
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringΤο καλσόν Vital είναι ένα πολύ σταθερό καλσόν 40 den που υποστηρίζει όλο το μήκος των ποδιών.<br /><br />Είναι ημι-αδιαφανή, φαρδιά στους γοφούς και τους μηρούς, καθιστώντας τα πολύ άνετα στη χρήση.<br /><br />Με επίπεδες ραφές και ενισχυμένα δάχτυλα στα δάχτυλα των ποδιών.
guid
stringhttps://dev.divasboudoir.com/el/vital-plus-size-kalson-yposthrixhs-mayro-mpez-ou-sarka/slti8723.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringΜεγάλα καλσόν ειδικά σχεδιασμένα για να στηρίζουν και να ανακουφίζουν τα πόδια σας.
keywords
string
title
stringVital plus size καλσόν υποστήριξης
seotitle
stringVital plus size καλσόν υποστήριξης
seouri
stringvital-plus-size-kalson-yposthrixhs-mayro-mpez-ou-sarka
specifications
string
stylingtips
string
summary
stringΜεγάλα καλσόν ειδικά σχεδιασμένα για να στηρίζουν και να ανακουφίζουν τα πόδια σας.
title
stringΚαλσόν υποστήριξης ζωτικής σημασίας
usageinstructions
string
en
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringVital tights are very strong 40 den tights that support the entire length of the legs.<br /><br />Semi-opaque, the hips and thighs are wide and comfortable to wear.<br /><br />Flat seams and reinforced toes.
guid
stringhttps://dev.divasboudoir.com/en/vital-plus-size-support-tights-black-beige-ou-nude/slti8723.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringPlus size tights specially designed to support and relieve your legs.
keywords
string
title
stringVital plus size support tights
seotitle
stringVital plus size support tights
seouri
stringvital-plus-size-support-tights-black-beige-ou-nude
specifications
string
stylingtips
string
summary
stringPlus size tights specially designed to support and relieve your legs.
title
stringVital support pantyhose
usageinstructions
string
es
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>Las mallas Vital son mallas muy s&oacute;lidas de 40 den que sujetan toda la longitud de las piernas.<br><br>Semiopacas, son anchas en las caderas y los muslos, lo que las hace muy c&oacute;modas de llevar.<br><br>Costuras planas y punteras reforzadas.</p>
guid
stringhttps://dev.divasboudoir.com/es/mallas-de-sujecion-talla-grande-vital-negro-beige-ou-carne/slti8723.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringMedias de talla grande especialmente diseñadas para sujetar y aliviar las piernas.
keywords
string
title
stringMallas de sujeción talla grande Vital
seotitle
stringMallas de sujeción talla grande Vital
seouri
stringmallas-de-sujecion-talla-grande-vital-negro-beige-ou-carne
specifications
string
stylingtips
string
summary
string<p>Medias de talla grande especialmente dise&ntilde;adas para sujetar y aliviar las piernas.</p>
title
stringMallas de sujeción vital
usageinstructions
string
fr
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>Le collant Vital est un collant 40 den, tr&egrave;s solide, qui soutient les jambes sur toute leur longueur.&nbsp;<br><br>Semi-opaque, les hanches et les cuisses sont bien larges pour un tr&egrave;s bon confort de port.&nbsp;<br><br>Coutures plates et pointes renforc&eacute;es.</p>
guid
stringhttps://dev.divasboudoir.com/fr/collant-grande-taille-de-soutien-vital-noir-beige-ou-chair/slti8723.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringCollant grande taille spécialement fabriqué pour soutenir et pour soulager vos jambes.
keywords
string
title
stringCollant grande taille de soutien Vital
seotitle
stringCollant grande taille de soutien Vital
seouri
stringcollant-grande-taille-de-soutien-vital-noir-beige-ou-chair
specifications
string
stylingtips
string
summary
string<p>Collant grande taille sp&eacute;cialement fabriqu&eacute; pour soutenir et pour soulager vos jambes.</p>
title
stringCollant de soutien Vital
usageinstructions
string
it
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringI collant Vital sono collant 40 den molto solidi che sostengono l'intera lunghezza delle gambe.<br /><br />Semi-opachi, sono larghi sui fianchi e sulle cosce, il che li rende molto comodi da indossare.<br /><br />Cuciture piatte e punte rinforzate.
guid
stringhttps://dev.divasboudoir.com/it/collant-di-sostegno-vital-taglia-grande-nero-beige-ou-carne/slti8723.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringCollant di grande taglia appositamente progettati per sostenere e alleviare le gambe.
keywords
string
title
stringCollant di sostegno Vital taglia grande
seotitle
stringCollant di sostegno Vital taglia grande
seouri
stringcollant-di-sostegno-vital-taglia-grande-nero-beige-ou-carne
specifications
string
stylingtips
string
summary
stringCollant di grande taglia appositamente progettati per sostenere e alleviare le gambe.
title
stringCollant di sostegno vitale
usageinstructions
string
nl
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>Vital panty's zijn zeer stevige 40 den panty's die de hele lengte van de benen ondersteunen.<br><br>Ze zijn half doorschijnend en wijd bij de heupen en dijen, waardoor ze zeer comfortabel dragen.<br><br>Platte naden en versterkte tenen.</p>
guid
stringhttps://dev.divasboudoir.com/nl/vital-steunpanty-groote-maat-zwart-beige-ou-vlees/slti8723.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringGroote maten panty's die speciaal zijn ontworpen om je benen te ondersteunen en te ontlasten.
keywords
string
title
stringVital steunpanty groote maat
seotitle
stringVital steunpanty groote maat
seouri
stringvital-steunpanty-groote-maat-zwart-beige-ou-vlees
specifications
string
stylingtips
string
summary
string<p>Groote maten panty's die speciaal zijn ontworpen om je benen te ondersteunen en te ontlasten.</p>
title
stringVitale ondersteunende panty
usageinstructions
string
pt
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringOs collants Vital são collants 40 den muito sólidos que suportam todo o comprimento das pernas.<br /><br />Semi-opacos, são largos nas ancas e nas coxas, o que os torna muito confortáveis de usar.<br /><br />Costuras planas e dedos reforçados.
guid
stringhttps://dev.divasboudoir.com/pt/collants-de-apoio-vital-plus-size-preto-bege-ou-carne/slti8723.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringCollants largos especialmente concebidos para apoiar e aliviar as pernas.
keywords
string
title
stringCollants de apoio Vital plus size
seotitle
stringCollants de apoio Vital plus size
seouri
stringcollants-de-apoio-vital-plus-size-preto-bege-ou-carne
specifications
string
stylingtips
string
summary
stringCollants largos especialmente concebidos para apoiar e aliviar as pernas.
title
stringCollants de apoio vital
usageinstructions
string
fetishboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz-beige-ou-fleisch
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro-mpez-ou-sarka
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black-beige-ou-nude
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro-beige-ou-carne
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-beige-ou-chair
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero-beige-ou-carne
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart-beige-ou-vlees
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto-bege-ou-carne
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
latexboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz-beige-ou-fleisch
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro-mpez-ou-sarka
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black-beige-ou-nude
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro-beige-ou-carne
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-beige-ou-chair
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero-beige-ou-carne
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart-beige-ou-vlees
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto-bege-ou-carne
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
legsboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string<ul> <li>Handw&auml;sche in kaltem Wasser</li> <li>Nicht auswringen oder schleudern</li> <li>Flach im Schatten trocknen</li> <li>Nicht b&uuml;geln</li> </ul>
description
string<p><strong>Eine Strumpfhose, konzipiert f&uuml;r Ihr t&auml;gliches Wohlbefinden</strong>, speziell hergestellt, um Ihre Beine den ganzen Tag &uuml;ber zu st&uuml;tzen und zu entlasten. Die semi-transparente 40 Denier Textur bietet au&szlig;ergew&ouml;hnliche Belastbarkeit, w&auml;hrend der gro&szlig;z&uuml;gige Schnitt an H&uuml;ften und Oberschenkeln absoluten Komfort garantiert.</p>
highlights
string<ul> <li><strong>Aktive Unterst&uuml;tzung</strong> entlang der gesamten Beinl&auml;nge</li> <li><strong>40 Denier</strong> semi-transparent und robust</li> <li><strong>Breite H&uuml;ften und Oberschenkel</strong> f&uuml;r optimalen Komfort</li> <li><strong>Flache N&auml;hte</strong> und verst&auml;rkte Spitze</li> <li><strong>Speziell entwickelt</strong> zur Beinunterst&uuml;tzung</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
stringVital Strumpfhose 40 Denier Übergröße | Leg's Boudoir
seotitle
stringÜbergröße Strumpfhose 40 Denier - Optimale Unterstützung und Komfort
seouri
stringuebergroesse-strumpfhose-40-denier-stuetz-komfort
specifications
string<ul> <li><strong>Material :</strong> 40 Denier</li> <li><strong>Deckkraft :</strong> Semi-transparent</li> <li><strong>Schnitt :</strong> Breite H&uuml;ften und Oberschenkel</li> <li><strong>Verarbeitung :</strong> Flache N&auml;hte, verst&auml;rkte Spitze</li> <li><strong>Funktion :</strong> Beinunterst&uuml;tzung und -entlastung</li> </ul>
stylingtips
string<p>Ideal für einen Arbeitstag oder lange Stehzeiten. Kombinieren Sie sie mit einem <strong>geraden Rock</strong> oder einer <strong>Hose mit weitem Bein</strong> für einen professionellen und bequemen Look.</p>
summary
string<p><strong>Entlasten Sie Ihre Beine</strong> mit dieser &Uuml;bergr&ouml;&szlig;e 40 Denier Strumpfhose, entwickelt f&uuml;r Unterst&uuml;tzung und Komfort. Ein <u>Wohlf&uuml;hl-Begleiter</u>, der au&szlig;ergew&ouml;hnliche Belastbarkeit und ein Gef&uuml;hl von Leichtigkeit vereint.</p>
title
stringVital Strumpfhose Optimale Unterstützung und Komfort
usageinstructions
string<p>Diese Strumpfhose bietet progressive Unterst&uuml;tzung entlang der gesamten Beinl&auml;nge, f&ouml;rdert die Durchblutung und reduziert das Gef&uuml;hl schwerer Beine. Der extra breite Schnitt garantiert au&szlig;ergew&ouml;hnlichen Tragekomfort ohne &uuml;berm&auml;&szlig;ige Kompression.</p>
el
Struct
Entries: 14
abstract
string
careinstructions
string<ul> <li>&Pi;&lambda;ύ&sigma;&iota;&mu;&omicron; &sigma;&tau;&omicron; &chi;έ&rho;&iota; &mu;&epsilon; &kappa;&rho;ύ&omicron; &nu;&epsilon;&rho;ό</li> <li>&Mu;&eta;&nu; &sigma;&tau;&rho;ί&beta;&epsilon;&tau;&epsilon; ή &sigma;&tau;ύ&beta;&epsilon;&tau;&epsilon;</li> <li>&Sigma;&tau;&epsilon;&gamma;&nu;ώ&sigma;&tau;&epsilon; &epsilon;&pi;ί&pi;&epsilon;&delta;&alpha; &sigma;&tau;&eta; &sigma;&kappa;&iota;ά</li> <li>&Mu;&eta;&nu; &sigma;&iota;&delta;&epsilon;&rho;ώ&nu;&epsilon;&tau;&epsilon;</li> </ul>
description
string<p><strong>Έ&nu;&alpha; &kappa;&alpha;&lambda;&sigma;ό&nu; &sigma;&kappa;&epsilon;&pi;&tau;ό&mu;&epsilon;&nu;&omicron; &tau;&eta;&nu; &kappa;&alpha;&theta;&eta;&mu;&epsilon;&rho;&iota;&nu;ή &sigma;&alpha;&sigmaf; &epsilon;&upsilon;&epsilon;&xi;ί&alpha;</strong>, &epsilon;&iota;&delta;&iota;&kappa;ά &kappa;&alpha;&tau;&alpha;&sigma;&kappa;&epsilon;&upsilon;&alpha;&sigma;&mu;έ&nu;&omicron; &gamma;&iota;&alpha; &nu;&alpha; &sigma;&tau;&eta;&rho;ί&zeta;&epsilon;&iota; &kappa;&alpha;&iota; &nu;&alpha; &alpha;&nu;&alpha;&kappa;&omicron;&upsilon;&phi;ί&zeta;&epsilon;&iota; &tau;&alpha; &pi;ό&delta;&iota;&alpha; &sigma;&alpha;&sigmaf; &kappa;&alpha;&theta;' ό&lambda;&eta; &tau;&eta; &delta;&iota;ά&rho;&kappa;&epsilon;&iota;&alpha; &tau;&eta;&sigmaf; &eta;&mu;έ&rho;&alpha;&sigmaf;. &Eta; &eta;&mu;&iota;-&delta;&iota;&alpha;&phi;&alpha;&nu;ή&sigmaf; &upsilon;&phi;ή 40 denier &pi;&rho;&omicron;&sigma;&phi;έ&rho;&epsilon;&iota; &epsilon;&xi;&alpha;&iota;&rho;&epsilon;&tau;&iota;&kappa;ή &alpha;&nu;&tau;&omicron;&chi;ή, &epsilon;&nu;ώ &eta; &gamma;&epsilon;&nu;&nu;&alpha;&iota;ό&delta;&omega;&rho;&eta; &gamma;&rho;&alpha;&mu;&mu;ή &sigma;&tau;&alpha; &gamma;&omicron;&phi;&iota;ά &kappa;&alpha;&iota; &tau;&omicron;&upsilon;&sigmaf; &mu;&eta;&rho;&omicron;ύ&sigmaf; &epsilon;&gamma;&gamma;&upsilon;ά&tau;&alpha;&iota; &alpha;&pi;ό&lambda;&upsilon;&tau;&eta; ά&nu;&epsilon;&sigma;&eta;.</p>
highlights
string<ul> <li><strong>&Epsilon;&nu;&epsilon;&rho;&gamma;ή &upsilon;&pi;&omicron;&sigma;&tau;ή&rho;&iota;&xi;&eta;</strong> &sigma;&epsilon; ό&lambda;&omicron; &tau;&omicron; &mu;ή&kappa;&omicron;&sigmaf; &tau;&omicron;&upsilon; &pi;&omicron;&delta;&iota;&omicron;ύ</li> <li><strong>40 Denier</strong> &eta;&mu;&iota;-&delta;&iota;&alpha;&phi;&alpha;&nu;έ&sigmaf; &kappa;&alpha;&iota; &alpha;&nu;&theta;&epsilon;&kappa;&tau;&iota;&kappa;ό</li> <li><strong>&Phi;&alpha;&rho;&delta;&iota;ά &gamma;&omicron;&phi;&iota;ά &kappa;&alpha;&iota; &mu;&eta;&rho;&omicron;ί</strong> &gamma;&iota;&alpha; &beta;έ&lambda;&tau;&iota;&sigma;&tau;&eta; ά&nu;&epsilon;&sigma;&eta;</li> <li><strong>&Epsilon;&pi;ί&pi;&epsilon;&delta;&epsilon;&sigmaf; &rho;&alpha;&phi;έ&sigmaf;</strong> &kappa;&alpha;&iota; &epsilon;&nu;&iota;&sigma;&chi;&upsilon;&mu;έ&nu;&eta; &mu;ύ&tau;&eta;</li> <li><strong>&Epsilon;&iota;&delta;&iota;&kappa;ά &sigma;&chi;&epsilon;&delta;&iota;&alpha;&sigma;&mu;έ&nu;&omicron;</strong> &gamma;&iota;&alpha; &upsilon;&pi;&omicron;&sigma;&tau;ή&rho;&iota;&xi;&eta; &pi;&omicron;&delta;&iota;ώ&nu;</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringΚαλσόν Vital 40 denier μεγάλου μεγέθους από το Leg's Boudoir. Ενεργή υποστήριξη, ανακουφίζει τα πόδια. Φαρδιά γοφιά και μηροί. Άνεση και ευεξία εγγυημένα.
keywords
string
title
stringΚαλσόν Vital 40 Denier Μεγάλου Μεγέθους | Leg's Boudoir
seotitle
stringΚαλσόν Μεγάλου Μεγέθους 40 Denier - Βέλτιστη Υποστήριξη και Άνεση
seouri
stringkalson-megalou-megethous-40-denier-ypostirixis-anesis
specifications
string<ul> <li><strong>&Upsilon;&lambda;&iota;&kappa;ό :</strong> 40 Denier</li> <li><strong>&Delta;&iota;&alpha;&phi;ά&nu;&epsilon;&iota;&alpha; :</strong> &Eta;&mu;&iota;-&delta;&iota;&alpha;&phi;&alpha;&nu;έ&sigmaf;</li> <li><strong>&Gamma;&rho;&alpha;&mu;&mu;ή :</strong> &Phi;&alpha;&rho;&delta;&iota;ά &gamma;&omicron;&phi;&iota;ά &kappa;&alpha;&iota; &mu;&eta;&rho;&omicron;ί</li> <li><strong>&Tau;&epsilon;&lambda;&epsilon;&iota;ώ&mu;&alpha;&tau;&alpha; :</strong> &Epsilon;&pi;ί&pi;&epsilon;&delta;&epsilon;&sigmaf; &rho;&alpha;&phi;έ&sigmaf;, &epsilon;&nu;&iota;&sigma;&chi;&upsilon;&mu;έ&nu;&eta; &mu;ύ&tau;&eta;</li> <li><strong>&Lambda;&epsilon;&iota;&tau;&omicron;&upsilon;&rho;&gamma;ί&alpha; :</strong> &Upsilon;&pi;&omicron;&sigma;&tau;ή&rho;&iota;&xi;&eta; &kappa;&alpha;&iota; &alpha;&nu;&alpha;&kappa;&omicron;ύ&phi;&iota;&sigma;&eta; &pi;&omicron;&delta;&iota;ώ&nu;</li> </ul>
stylingtips
string<p>Ιδανικό για μια εργάσιμη ημέρα ή για μεγάλες περιόδους ορθοστασίας. Συνδυάστε το με μια <strong>ίσια φούστα</strong> ή ένα <strong>παντελόνι με φαρδιά πόδια</strong> για μια επαγγελματική και άνετη εμφάνιση.</p>
summary
string<p><strong>&Alpha;&nu;&alpha;&kappa;&omicron;&upsilon;&phi;ί&sigma;&tau;&epsilon; &tau;&alpha; &pi;ό&delta;&iota;&alpha; &sigma;&alpha;&sigmaf;</strong> &mu;&epsilon; &alpha;&upsilon;&tau;ό &tau;&omicron; &kappa;&alpha;&lambda;&sigma;ό&nu; &mu;&epsilon;&gamma;ά&lambda;&omicron;&upsilon; &mu;&epsilon;&gamma;έ&theta;&omicron;&upsilon;&sigmaf; 40 denier, &sigma;&chi;&epsilon;&delta;&iota;&alpha;&sigma;&mu;έ&nu;&omicron; &gamma;&iota;&alpha; &upsilon;&pi;&omicron;&sigma;&tau;ή&rho;&iota;&xi;&eta; &kappa;&alpha;&iota; ά&nu;&epsilon;&sigma;&eta;. Έ&nu;&alpha;&sigmaf; <u>&sigma;ύ&mu;&mu;&alpha;&chi;&omicron;&sigmaf; &epsilon;&upsilon;&epsilon;&xi;ί&alpha;&sigmaf;</u> &pi;&omicron;&upsilon; &sigma;&upsilon;&nu;&delta;&upsilon;ά&zeta;&epsilon;&iota; &epsilon;&xi;&alpha;&iota;&rho;&epsilon;&tau;&iota;&kappa;ή &alpha;&nu;&tau;&omicron;&chi;ή &kappa;&alpha;&iota; &alpha;ί&sigma;&theta;&eta;&sigma;&eta; &epsilon;&lambda;&alpha;&phi;&rho;ό&tau;&eta;&tau;&alpha;&sigmaf;.</p>
title
stringΚαλσόν βέλτιστης υποστήριξης και άνεσης Vital
usageinstructions
string<p>&Alpha;&upsilon;&tau;ό &tau;&omicron; &kappa;&alpha;&lambda;&sigma;ό&nu; &pi;&rho;&omicron;&sigma;&phi;έ&rho;&epsilon;&iota; &pi;&rho;&omicron;&omicron;&delta;&epsilon;&upsilon;&tau;&iota;&kappa;ή &upsilon;&pi;&omicron;&sigma;&tau;ή&rho;&iota;&xi;&eta; &sigma;&epsilon; ό&lambda;&omicron; &tau;&omicron; &mu;ή&kappa;&omicron;&sigmaf; &tau;&omicron;&upsilon; &pi;&omicron;&delta;&iota;&omicron;ύ, &pi;&rho;&omicron;&omega;&theta;ώ&nu;&tau;&alpha;&sigmaf; &kappa;&alpha;&lambda;ύ&tau;&epsilon;&rho;&eta; &kappa;&upsilon;&kappa;&lambda;&omicron;&phi;&omicron;&rho;ί&alpha; &kappa;&alpha;&iota; &mu;&epsilon;&iota;ώ&nu;&omicron;&nu;&tau;&alpha;&sigmaf; &tau;&eta;&nu; &alpha;ί&sigma;&theta;&eta;&sigma;&eta; &beta;&alpha;&rho;έ&omega;&nu; &pi;&omicron;&delta;&iota;ώ&nu;. &Eta; extra &mu;&epsilon;&gamma;ά&lambda;&eta; &gamma;&rho;&alpha;&mu;&mu;ή &epsilon;&gamma;&gamma;&upsilon;ά&tau;&alpha;&iota; &epsilon;&xi;&alpha;&iota;&rho;&epsilon;&tau;&iota;&kappa;ή ά&nu;&epsilon;&sigma;&eta; &chi;&omega;&rho;ί&sigmaf; &upsilon;&pi;&epsilon;&rho;&beta;&omicron;&lambda;&iota;&kappa;ή &sigma;&upsilon;&mu;&pi;ί&epsilon;&sigma;&eta;.</p>
en
Struct
Entries: 14
abstract
string
careinstructions
string<ul> <li>Hand wash in cold water</li> <li>Do not wring or spin</li> <li>Dry flat in the shade</li> <li>Do not iron</li> </ul>
description
string<p><strong>Tights designed for your daily well-being</strong>, specially manufactured to support and relieve your legs throughout the day. The semi-opaque 40 denier texture offers exceptional resistance, while the generous cut around hips and thighs guarantees absolute comfort.</p>
highlights
string<ul> <li><strong>Active support</strong> along the entire leg length</li> <li><strong>40 Denier</strong> semi-opaque and resistant</li> <li><strong>Wide hips and thighs</strong> for optimal comfort</li> <li><strong>Flat seams</strong> and reinforced toe</li> <li><strong>Specially designed</strong> to support legs</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
stringPlus Size Tights 40 Denier - Optimal Support and Comfort
seouri
stringplus-size-tights-40-denier-support-comfort
specifications
string<ul> <li><strong>Material :</strong> 40 Denier</li> <li><strong>Opacity :</strong> Semi-opaque</li> <li><strong>Fit :</strong> Wide hips and thighs</li> <li><strong>Finishes :</strong> Flat seams, reinforced toe</li> <li><strong>Function :</strong> Leg support and relief</li> </ul>
stylingtips
string<p>Ideal for a work day or long periods of standing. Pair with a <strong>straight skirt</strong> or <strong>wide leg pants</strong> for a professional and comfortable look.</p>
summary
string<p><strong>Relieve your legs</strong> with these plus size 40 denier tights designed for support and comfort. A <u>well-being ally</u> that combines exceptional resistance and a feeling of lightness.</p>
title
stringVital Optimal Comfort and Support Tights
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string<ul> <li>Lavado a mano en agua fr&iacute;a</li> <li>No retorcer ni centrifugar</li> <li>Secar extendido a la sombra</li> <li>No planchar</li> </ul>
description
string<p><strong>Unas medias pensadas para su bienestar diario</strong>, fabricadas especialmente para sostener y aliviar sus piernas durante todo el d&iacute;a. La textura semi-opaca de 40 denier ofrece una resistencia excepcional, mientras el corte generoso en caderas y muslos garantiza un confort absoluto.</p>
highlights
string<ul> <li><strong>Soporte activo</strong> a lo largo de toda la pierna</li> <li><strong>40 Denier</strong> semi-opaco y resistente</li> <li><strong>Caderas y muslos anchos</strong> para un confort &oacute;ptimo</li> <li><strong>Costuras planas</strong> y puntera reforzada</li> <li><strong>Especialmente dise&ntilde;ado</strong> para apoyar las piernas</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringMedias Vital 40 denier talla grande de Leg's Boudoir. Soporte activo, alivia las piernas. Caderas y muslos anchos. Confort y bienestar garantizados.
keywords
string
title
stringMedias Vital 40 Denier Talla Grande | Leg's Boudoir
seotitle
stringMedias Talla Grande 40 Denier - Soporte y Confort Óptimo
seouri
stringmedias-talla-grande-40-denier-soporte-confort
specifications
string<ul> <li><strong>Material :</strong> 40 Denier</li> <li><strong>Opacidad :</strong> Semi-opaco</li> <li><strong>Corte :</strong> Caderas y muslos anchos</li> <li><strong>Acabados :</strong> Costuras planas, puntera reforzada</li> <li><strong>Funci&oacute;n :</strong> Soporte y alivio de piernas</li> </ul>
stylingtips
string<p>Ideal para un d&iacute;a de trabajo o largos periodos de pie. Comb&iacute;nalos con una <strong>falda recta</strong> o <strong>unos pantalones de pata ancha</strong> para un look profesional y c&oacute;modo.</p>
summary
string<p><strong>Alivie sus piernas</strong> con estas medias talla grande 40 denier dise&ntilde;adas para soporte y confort. Un <u>aliado de bienestar</u> que combina resistencia excepcional y sensaci&oacute;n de ligereza.</p>
title
stringMallas de sujeción y confort Vital Optimal
usageinstructions
string<p>Estas medias ofrecen un soporte progresivo a lo largo de toda la longitud de la pierna, favoreciendo una mejor circulaci&oacute;n y reduciendo la sensaci&oacute;n de piernas pesadas. El corte extra ancho garantiza un confort excepcional sin compresi&oacute;n excesiva.</p>
fr
Struct
Entries: 14
abstract
string
careinstructions
string<ul> <li>Lavage &agrave; la main en eau froide</li> <li>Ne pas tordre ni essorer</li> <li>S&eacute;chage &agrave; plat &agrave; l'ombre</li> <li>Ne pas repasser</li> </ul>
description
string<p><strong>Un collant pens&eacute; pour votre bien-&ecirc;tre quotidien</strong>, sp&eacute;cialement fabriqu&eacute; pour soutenir et soulager vos jambes tout au long de la journ&eacute;e. La texture semi-opaque 40 denier offre une r&eacute;sistance exceptionnelle, tandis que la coupe g&eacute;n&eacute;reuse au niveau des hanches et des cuisses garantit un confort absolu.</p>
highlights
string<ul> <li><strong>Soutien actif</strong> sur toute la longueur des jambes</li> <li><strong>40 Denier</strong> semi-opaque et r&eacute;sistant</li> <li><strong>Hanches et cuisses larges</strong> pour un confort optimal</li> <li><strong>Coutures plates</strong> et pointes renforc&eacute;es</li> <li><strong>Sp&eacute;cialement con&ccedil;u</strong> pour soulager les jambes</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringCollant Vital 40 denier grande taille chez Leg's Boudoir. Soutien actif, soulage les jambes. Hanches et cuisses larges. Confort et bien-être garantis.
keywords
string
title
stringCollant Vital 40 Denier Grande Taille | Leg's Boudoir
seotitle
stringCollant Grande Taille 40 Denier - Soutien et Confort Optimal
seouri
stringcollant-grande-taille-40-denier-soutien-confort
specifications
string<ul> <li><strong>Mati&egrave;re :</strong> 40 Denier</li> <li><strong>Opacit&eacute; :</strong> Semi-opaque</li> <li><strong>Coupe :</strong> Hanches et cuisses larges</li> <li><strong>Finitions :</strong> Coutures plates, pointes renforc&eacute;es</li> <li><strong>Fonction :</strong> Soutien et soulagement des jambes</li> </ul>
stylingtips
string<p>Id&eacute;al pour une journ&eacute;e de travail ou de longues p&eacute;riodes debout. Associez-les &agrave; une <strong>jupe droite</strong> ou &agrave; un <strong>pantalon large</strong> pour un look professionnel et confortable.</p>
summary
string<p><strong>Soulagez vos jambes</strong> avec ce collant grande taille 40 denier con&ccedil;u pour le soutien et le confort. Un <u>alli&eacute; bien-&ecirc;tre</u> qui combine r&eacute;sistance exceptionnelle et sensation de l&eacute;g&egrave;ret&eacute;.</p>
title
stringCollant Vital Soutien et Confort Optimal
usageinstructions
string<p>Ce collant offre un soutien progressif sur toute la longueur des jambes, favorisant une meilleure circulation et r&eacute;duisant la sensation de jambes lourdes. La coupe extra large garantit un confort de port exceptionnel sans compression excessive.</p>
it
Struct
Entries: 14
abstract
string
careinstructions
string<ul> <li>Lavaggio a mano in acqua fredda</li> <li>Non strizzare o centrifugare</li> <li>Asciugare steso all'ombra</li> <li>Non stirare</li> </ul>
description
string<p><strong>Un collant pensato per il tuo benessere quotidiano</strong>, appositamente fabbricato per sostenere e alleviare le tue gambe durante l'intera giornata. La texture semi-opaca 40 denier offre una resistenza eccezionale, mentre il taglio generoso su fianchi e cosce garantisce un comfort assoluto.</p>
highlights
string<ul> <li><strong>Supporto attivo</strong> lungo tutta la lunghezza della gamba</li> <li><strong>40 Denier</strong> semi-opaco e resistente</li> <li><strong>Fianchi e cosce larghe</strong> per un comfort ottimale</li> <li><strong>Cuciture piatte</strong> e punta rinforzata</li> <li><strong>Appositamente progettato</strong> per sostenere le gambe</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringCollant Vital 40 denier taglie forti di Leg's Boudoir. Supporto attivo, allevia le gambe. Fianchi e cosce larghe. Comfort e benessere garantiti.
keywords
string
title
stringCollant Vital 40 Denier Taglie Forti | Leg's Boudoir
seotitle
stringCollant Taglie Forti 40 Denier - Supporto e Comfort Ottimale
seouri
stringcollant-taglie-forti-40-denier-supporto-comfort
specifications
string<ul> <li><strong>Materiale :</strong> 40 Denier</li> <li><strong>Opacit&agrave; :</strong> Semi-opaco</li> <li><strong>Taglio :</strong> Fianchi e cosce larghe</li> <li><strong>Finiture :</strong> Cuciture piatte, punta rinforzata</li> <li><strong>Funzione :</strong> Supporto e sollievo delle gambe</li> </ul>
stylingtips
string<p>Ideale per una giornata di lavoro o per lunghi periodi in piedi. Abbinate a una <strong>gonna dritta</strong> o a un <strong>pantalone a gamba larga</strong> per un look professionale e confortevole.</p>
summary
string<p><strong>Allevia le tue gambe</strong> con questi collant taglie forti 40 denier progettati per supporto e comfort. Un <u>alleato del benessere</u> che combina resistenza eccezionale e sensazione di leggerezza.</p>
title
stringCollant Vital Optimal Support e Comfort
usageinstructions
string<p>Questi collant offrono un supporto progressivo lungo tutta la lunghezza della gamba, favorendo una migliore circolazione e riducendo la sensazione di gambe pesanti. Il taglio extra large garantisce un comfort eccezionale senza compressione eccessiva.</p>
nl
Struct
Entries: 14
abstract
string
careinstructions
string<ul> <li>Handwas in koud water</li> <li>Niet wringen of centrifugeren</li> <li>Plat liggend in de schaduw drogen</li> <li>Niet strijken</li> </ul>
description
string<p><strong>Een panty bedacht voor uw dagelijks welzijn</strong>, speciaal vervaardigd om uw benen de hele dag te ondersteunen en te verlichten. De semi-ondoorzichtige 40 denier textuur biedt uitzonderlijke weerstand, terwijl de ruime pasvorm rond heupen en dijen absoluut comfort garandeert.</p>
highlights
string<ul> <li><strong>Actieve ondersteuning</strong> over de volledige beenlengte</li> <li><strong>40 Denier</strong> semi-ondoorzichtig en stevig</li> <li><strong>Brede heupen en dijen</strong> voor optimaal comfort</li> <li><strong>Platte naden</strong> en versterkte teen</li> <li><strong>Speciaal ontworpen</strong> om benen te ondersteunen</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringVital panty 40 denier grote maat bij Leg's Boudoir. Actieve ondersteuning, verlicht benen. Brede heupen en dijen. Comfort en welzijn gegarandeerd.
keywords
string
title
stringVital Panty 40 Denier Grote Maat | Leg's Boudoir
seotitle
stringGrote Maat Panty 40 Denier - Optimale Steun en Comfort
seouri
stringgrote-maat-panty-40-denier-steun-comfort
specifications
string<ul> <li><strong>Materiaal :</strong> 40 Denier</li> <li><strong>Ondoorzichtigheid :</strong> Semi-ondoorzichtig</li> <li><strong>Pasvorm :</strong> Brede heupen en dijen</li> <li><strong>Afwerking :</strong> Platte naden, versterkte teen</li> <li><strong>Functie :</strong> Ondersteuning en verlichting van benen</li> </ul>
stylingtips
string<p>Ideaal voor een werkdag of lange periodes staand. Combineer met een <strong>rechte rok</strong> of een <strong>wijde broek</strong> voor een professionele en comfortabele look.</p>
summary
string<p><strong>Verlich uw benen</strong> met deze grote maat 40 denier panty, ontworpen voor steun en comfort. Een <u>welzijns-bondgenoot</u> die uitzonderlijke weerstand en een licht gevoel combineert.</p>
title
stringVital Optimale ondersteuning en comfort panty
usageinstructions
string<p>Deze panty biedt progressieve ondersteuning over de volledige beenlengte, bevordert de bloedsomloop en vermindert het gevoel van zware benen. De extra brede pasvorm garandeert een uitzonderlijk draagcomfort zonder overmatige compressie.</p>
pt
Struct
Entries: 14
abstract
string
careinstructions
string<ul> <li>Lavar &agrave; m&atilde;o em &aacute;gua fria</li> <li>N&atilde;o torcer ou centrifugar</li> <li>Secar deitada &agrave; sombra</li> <li>N&atilde;o passar a ferro</li> </ul>
description
string<p><strong>Uma meia-cal&ccedil;a pensada para seu bem-estar di&aacute;rio</strong>, especialmente fabricada para sustentar e aliviar suas pernas durante todo o dia. A textura semi-opaca de 40 denier oferece resist&ecirc;ncia excepcional, enquanto o corte generoso nos quadris e coxas garante conforto absoluto.</p>
highlights
string<ul> <li><strong>Suporte ativo</strong> ao longo de toda a extens&atilde;o da perna</li> <li><strong>40 Denier</strong> semi-opaco e resistente</li> <li><strong>Quadris e coxas largos</strong> para conforto m&aacute;ximo</li> <li><strong>Costura plana</strong> e ponta refor&ccedil;ada</li> <li><strong>Especialmente projetada</strong> para apoiar as pernas</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringMeia-calça Vital 40 denier plus size de Leg's Boudoir. Suporte ativo, alivia as pernas. Quadris e coxas largos. Conforto e bem-estar garantidos.
keywords
string
title
stringMeia-Calça Vital 40 Denier Plus Size | Leg's Boudoir
seotitle
stringMeia-Calça Plus Size 40 Denier - Suporte e Conforto Ideal
seouri
stringmeia-calca-plus-size-40-denier-suporte-conforto
specifications
string<ul> <li><strong>Material :</strong> 40 Denier</li> <li><strong>Opacidade :</strong> Semi-opaca</li> <li><strong>Corte :</strong> Quadris e coxas largos</li> <li><strong>Acabamentos :</strong> Costura plana, ponta refor&ccedil;ada</li> <li><strong>Fun&ccedil;&atilde;o :</strong> Suporte e al&iacute;vio das pernas</li> </ul>
stylingtips
string<p>Ideal para um dia de trabalho ou longos períodos de pé. Combine com uma <strong>saia direita</strong> ou <strong>calças de perna larga</strong> para um look profissional e confortável.</p>
summary
string<p><strong>Alivie suas pernas</strong> com esta meia-cal&ccedil;a plus size 40 denier projetada para suporte e conforto. Um <u>aliado de bem-estar</u> que combina resist&ecirc;ncia excepcional e sensa&ccedil;&atilde;o de leveza.</p>
title
stringCollants Vital Optimal Support and Comfort
usageinstructions
string<p>Estas meias-cal&ccedil;a oferecem suporte progressivo ao longo de toda a extens&atilde;o da perna, favorecendo melhor circula&ccedil;&atilde;o e reduzindo a sensa&ccedil;&atilde;o de pernas pesadas. O corte extra largo garante conforto excepcional sem compress&atilde;o excessiva.</p>
lustboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz-beige-ou-fleisch
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro-mpez-ou-sarka
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black-beige-ou-nude
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro-beige-ou-carne
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-beige-ou-chair
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero-beige-ou-carne
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart-beige-ou-vlees
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto-bege-ou-carne
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
smboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz-beige-ou-fleisch
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro-mpez-ou-sarka
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black-beige-ou-nude
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro-beige-ou-carne
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-beige-ou-chair
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero-beige-ou-carne
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart-beige-ou-vlees
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto-bege-ou-carne
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
name
string5124 vital
netweight
string
nextshipment
stringtomorrow
ordered
number3
orderidx
number0
origin
stringeu
originalsize
string
packaging
string
productshipment
stringauto
productuid
string9B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7
promountil
string
rating
stringnone
recorduid
string9B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7
reference
stringSLTI8723
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: 2.8 ms
Record Count: 18
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_sizes.id_size as recorduid, if(intlsize <> '',intlsize,eusize) as size, if(intlsize <> '','intlsize','eusize') as sizetype,
product_variations.color,
if(product_sizes.sizegroup = 'bra',
if(intlsize <> '', cast(intlsize as SIGNED ), cast(eusize as SIGNED ))
,
SUBSTRING_INDEX(intlsize,'-',1)
) as param1,
if(product_sizes.sizegroup = 'bra',
if(intlsize <> '',
MID(intlsize,length(cast(intlsize as SIGNED ))+1,length(intlsize)),
MID(eusize,length(cast(eusize as SIGNED ))+1,length(eusize))
)
,
SUBSTRING_INDEX(intlsize,'-',-1)
) as param2,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as available,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
999999,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as groupavailable,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
product_sizes.gender, product_sizes.sizerange, product_sizes.sizegroup, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize,
product_sizes.bust, product_sizes.waist, product_sizes.hip, product_sizes.underbust, product_sizes.cup, product_sizes.thigh, product_sizes.legheight, product_sizes.bodyheight, product_sizes.bodyweight
from product_sizes
left outer join product_variations on product_sizes.suppliersize = product_variations.size and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
where FIND_IN_SET(product_sizes.id_size,'2130,1046,1047,1048,1049,1050') > 0
and product_variations.productuid = '9B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7'
and intlsize <> 'na'
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_sizes.id_size, product_variations.color
order by FIELD(product_sizes.gender,'w','m'), product_sizes.sizegroup, FIELD(intlsize,'XS','S','S/M','S-M','M','M/L','M-L','L','L-XL','L/XL','XL','0X','0XL','lXL','1X','1X-2X','1X/2X','XL/2XL','XL-2XL','1XL-2XL','2XL','2X','XXL','2X-3X','2X/3X','2XL-3XL','2XL/3XL','XXXL','3XL','3X','3X-4X','3X/4X','3XL-4XL','3XL/4XL','4XL','5XL','5X','5X-6X','5X/6X','5XL-6XL','5XL/6XL','6XL','6X','7XL','7X','8XL','8X'), cast(intlsize as SIGNED ), groupavailable desc, stock desc
recorduidsizesizetypecolorparam1param2availablegroupavailablestockgendersizerangesizegroupsuppliersizeintlsizeincheseusizeussizeuksizefrsizeessizedesizeitsizeptsizeelsizebustwaisthipunderbustcupthighlegheightbodyheightbodyweight
1213038-40intlsizebeige3840-19999990wpluslingerieM38-4038-408-1012-1440-4240-4238-4044-4640-4238-40
2213038-40intlsizenude3840-19999990wpluslingerieM38-4038-408-1012-1440-4240-4238-4044-4640-4238-40
3213038-40intlsizeblack3840-19999990wpluslingerieM38-4038-408-1012-1440-4240-4238-4044-4640-4238-40
4104642-44intlsizenude4244-19999990wpluslingerieL42-4442-4412-1416-1844-4644-4642-4448-5042-4442-44
5104642-44intlsizeblack4244-19999990wpluslingerieL42-4442-4412-1416-1844-4644-4642-4448-5042-4442-44
6104642-44intlsizebeige4244-19999990wpluslingerieL42-4442-4412-1416-1844-4644-4642-4448-5042-4442-44
7104746-48intlsizeblack4648-19999990wpluslingerieXL46-4846-4816-1820-2248-5048-5046-4852-5448-5046-48
8104746-48intlsizebeige4648-19999990wpluslingerieXL46-4846-4816-1820-2248-5048-5046-4852-5448-5046-48
9104746-48intlsizenude4648-19999990wpluslingerieXL46-4846-4816-1820-2248-5048-5046-4852-5448-5046-48
10104850-52intlsizeblack5052-19999992wpluslingerie2XL50-5250-5220-2224-2652-5452-5450-5256-5852-5450-52
11104850-52intlsizenude5052-19999991wpluslingerie2XL50-5250-5220-2224-2652-5452-5450-5256-5852-5450-52
12104850-52intlsizebeige5052-19999990wpluslingerie2XL50-5250-5220-2224-2652-5452-5450-5256-5852-5450-52
13104954-56intlsizeblack5456-19999992wpluslingerie3XL54-5654-5624-2628-3056-5856-5854-5660-6256-5854-56
14104954-56intlsizebeige5456-19999992wpluslingerie3XL54-5654-5624-2628-3056-5856-5854-5660-6256-5854-56
15104954-56intlsizenude5456-19999991wpluslingerie3XL54-5654-5624-2628-3056-5856-5854-5660-6256-5854-56
16105056-58intlsizebeige5658-19999991wpluslingerie4XL56-5856-5826-2830-3258-6058-6056-5862-6458-6056-58
17105056-58intlsizenude5658-19999990wpluslingerie4XL56-5856-5826-2830-3258-6058-6056-5862-6458-6056-58
18105056-58intlsizeblack5658-19999990wpluslingerie4XL56-5856-5826-2830-3258-6058-6056-5862-6458-6056-58
sizeranges
stringplus
sizes
string2130,1046,1047,1048,1049,1050
sizetype
stringauto
specifications
Struct
Entries: 23
belly
string
bones
string
bra
string
breasts
string
bust
string
closing
string
crochtless
string
cups
string
cut
string
garter
string
halter
string
lacing
string
lining
string
modestypanel
string
panty
string
sheathing
string
sleeves
string
stocking
string
straps
string
stretch
string
suspenders
string
transparency
string
underwires
string
stock
number0
stocks
Query
Template: /system/api/product/stocks.cfc:25
Execution Time: 47.9 ms
Record Count: 18
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 = '9B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7'
and product_variations.isactive = 1
and product_sizes.id_size = 2130
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '9B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7'
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 = '9B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7'
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 = '9B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7'
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 = '9B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7'
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 = '9B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7'
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
19B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7445C9489-DB0E-439B-B29D8411192DA5F02130beige#F6DBACM38-4038-408-1012-1440-4240-4238-4044-4640-4238-40wlingerie38-40intlsize19.95830STOCK01000-10000-10all
29B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7A7DD402C-D3CE-4A25-8C8CF98A9743084B2130black#000000M38-4038-408-1012-1440-4240-4238-4044-4640-4238-40wlingerie38-40intlsize19.95830STOCK01000-10000-10all
39B28D5B4-BBCB-4DE6-8F6DCD138CA69DE712457598-0227-41E8-892C595E297024B72130nude#E3BC9AM38-4038-408-1012-1440-4240-4238-4044-4640-4238-40wlingerie38-40intlsize19.95830STOCK01000-10000-10all
49B28D5B4-BBCB-4DE6-8F6DCD138CA69DE774F6C46F-CAEB-498D-82E324D249815E801046beige#F6DBACL42-4442-4412-1416-1844-4644-4642-4448-5042-4442-44wlingerie42-44intlsize19.95830STOCK01000-10000501244260277130565-10all
59B28D5B4-BBCB-4DE6-8F6DCD138CA69DE73471693F-1842-4581-B753226D0E1944001046black#000000L42-4442-4412-1416-1844-4644-4642-4448-5042-4442-44wlingerie42-44intlsize19.95830STOCK01000-10000501244260277130442-10all
69B28D5B4-BBCB-4DE6-8F6DCD138CA69DE71CA04AFA-ABA1-43D8-827BC25DB30B523C1046nude#E3BC9AL42-4442-4412-1416-1844-4644-4642-4448-5042-4442-44wlingerie42-44intlsize19.95830STOCK01000-10000501244260277130503-10all
79B28D5B4-BBCB-4DE6-8F6DCD138CA69DE711CA7847-DE3F-4E53-821B392E5CF929331047beige#F6DBACXL46-4846-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie46-48intlsize19.95830STOCK01000-10000501244260277130572-10all
89B28D5B4-BBCB-4DE6-8F6DCD138CA69DE754BCE625-BFCD-462F-962D6903634FB8301047black#000000XL46-4846-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie46-48intlsize19.95830STOCK01000-10000501244260277130459-10all
99B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7D70AF845-9D51-4686-870EFAB5F52A98121047nude#E3BC9AXL46-4846-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie46-48intlsize19.95830STOCK01000-10100501244260277130510-10all
109B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7FAB88219-FBF0-4A99-9D7E6F9BD95EC2091048beige#F6DBAC2XL50-5250-5220-2224-2652-5452-5450-5256-5852-5450-52wlingerie50-52intlsize19.95830STOCK01000-10100501244260277130589-10all
119B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7BDB2A6D6-A96B-4556-AD9FE09C17749F321048black#0000002XL50-5250-5220-2224-2652-5452-5450-5256-5852-5450-52wlingerie50-52intlsize19.95830STOCK01200-1020050124426027713046622all
129B28D5B4-BBCB-4DE6-8F6DCD138CA69DE75C1676F4-87DA-473F-99AF2D226DB248B71048nude#E3BC9A2XL50-5250-5220-2224-2652-5452-5450-5256-5852-5450-52wlingerie50-52intlsize19.95830STOCK01100-1000050124426027713052711all
139B28D5B4-BBCB-4DE6-8F6DCD138CA69DE70AEBCB14-65C1-4720-ADD2D2612BB45CBC1049beige#F6DBAC3XL54-5654-5624-2628-3056-5856-5854-5660-6256-5854-56wlingerie54-56intlsize19.95830STOCK01200-1000050124426027713059622all
149B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7E6EB78BB-F7F4-44F6-A25E5F75CB82409D1049black#0000003XL54-5654-5624-2628-3056-5856-5854-5660-6256-5854-56wlingerie54-56intlsize19.95830STOCK01200-1000050124426027713047322all
159B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7AE52D60D-B3C5-46BC-BDAC7BC25EE9D4561049nude#E3BC9A3XL54-5654-5624-2628-3056-5856-5854-5660-6256-5854-56wlingerie54-56intlsize19.95830STOCK01100-1010050124426027713053411all
169B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7C3CD808A-BEC7-4118-837B902ECD25BDCA1050beige#F6DBAC4XL56-5856-5826-2830-3258-6058-6056-5862-6458-6056-58wlingerie56-58intlsize19.95830STOCK01100-1010050124426027713060211all
179B28D5B4-BBCB-4DE6-8F6DCD138CA69DE78ABFA0ED-E0EA-4FC6-BA8C301536F2BB371050black#0000004XL56-5856-5826-2830-3258-6058-6056-5862-6458-6056-58wlingerie56-58intlsize19.95830STOCK01000-10000501244260277130480-10all
189B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7BE87DF6D-9439-48D1-A3AA147FB29E8F1A1050nude#E3BC9A4XL56-5856-5826-2830-3258-6058-6056-5862-6458-6056-58wlingerie56-58intlsize19.95830STOCK01000-10000501244260277130541-10all
subcategory
stringtights
supplier
number-1
supplierreference
string50124
tags
string
themes
stringpinkday
totalvariations
string
type
stringdefault
unitprice
number19.9583
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 25.2 ms
Record Count: 18
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 = '9B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7' 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 = '9B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7' 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 = '9B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7' 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 = '9B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7' 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 = '9B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7' 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 = '9B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7' 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 = '9B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7'
and product_variations.isactive = 1
and product_sizes.id_size = 2130
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '9B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7' 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 = '9B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7' 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 = '9B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7' 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 = '9B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7' 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 = '9B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7' 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 = '9B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7' 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 = '9B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7'
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 = '9B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7' 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 = '9B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7' 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 = '9B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7' 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 = '9B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7' 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 = '9B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7' 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 = '9B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7' 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 = '9B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7'
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 = '9B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7' 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 = '9B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7' 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 = '9B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7' 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 = '9B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7' 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 = '9B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7' 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 = '9B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7' 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 = '9B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7'
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 = '9B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7' 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 = '9B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7' 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 = '9B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7' 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 = '9B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7' 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 = '9B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7' 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 = '9B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7' 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 = '9B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7'
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 = '9B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7' 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 = '9B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7' 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 = '9B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7' 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 = '9B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7' 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 = '9B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7' 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 = '9B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7' 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 = '9B28D5B4-BBCB-4DE6-8F6DCD138CA69DE7'
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
1445C9489-DB0E-439B-B29D8411192DA5F02130beige#F6DBACM38-4038-408-1012-1440-4240-4238-4044-4640-4238-40wlingerie38-40intlsize19.95830STOCK01000-10000-10-10-13019.9583all
2A7DD402C-D3CE-4A25-8C8CF98A9743084B2130black#000000M38-4038-408-1012-1440-4240-4238-4044-4640-4238-40wlingerie38-40intlsize19.95830STOCK01000-10000-10-10-14019.9583all
312457598-0227-41E8-892C595E297024B72130nude#E3BC9AM38-4038-408-1012-1440-4240-4238-4044-4640-4238-40wlingerie38-40intlsize19.95830STOCK01000-10000-10-10-12019.9583all
474F6C46F-CAEB-498D-82E324D249815E801046beige#F6DBACL42-4442-4412-1416-1844-4644-4642-4448-5042-4442-44wlingerie42-44intlsize19.95830STOCK01000-10000501244260277130565-10-10-13019.9583all
53471693F-1842-4581-B753226D0E1944001046black#000000L42-4442-4412-1416-1844-4644-4642-4448-5042-4442-44wlingerie42-44intlsize19.95830STOCK01000-10000501244260277130442-10-10-14019.9583all
61CA04AFA-ABA1-43D8-827BC25DB30B523C1046nude#E3BC9AL42-4442-4412-1416-1844-4644-4642-4448-5042-4442-44wlingerie42-44intlsize19.95830STOCK01000-10000501244260277130503-10-10-12019.9583all
711CA7847-DE3F-4E53-821B392E5CF929331047beige#F6DBACXL46-4846-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie46-48intlsize19.95830STOCK01000-10000501244260277130572-10-10-13019.9583all
854BCE625-BFCD-462F-962D6903634FB8301047black#000000XL46-4846-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie46-48intlsize19.95830STOCK01000-10000501244260277130459-10-10-14019.9583all
9D70AF845-9D51-4686-870EFAB5F52A98121047nude#E3BC9AXL46-4846-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie46-48intlsize19.95830STOCK01000-10100501244260277130510-10-10-12019.9583all
10FAB88219-FBF0-4A99-9D7E6F9BD95EC2091048beige#F6DBAC2XL50-5250-5220-2224-2652-5452-5450-5256-5852-5450-52wlingerie50-52intlsize19.95830STOCK01000-10100501244260277130589-10-13-13019.9583all
11BDB2A6D6-A96B-4556-AD9FE09C17749F321048black#0000002XL50-5250-5220-2224-2652-5452-5450-5256-5852-5450-52wlingerie50-52intlsize19.95830STOCK01200-1020050124426027713046622-13-14019.9583all
125C1676F4-87DA-473F-99AF2D226DB248B71048nude#E3BC9A2XL50-5250-5220-2224-2652-5452-5450-5256-5852-5450-52wlingerie50-52intlsize19.95830STOCK01100-1000050124426027713052711-13-12019.9583all
130AEBCB14-65C1-4720-ADD2D2612BB45CBC1049beige#F6DBAC3XL54-5654-5624-2628-3056-5856-5854-5660-6256-5854-56wlingerie54-56intlsize19.95830STOCK01200-1000050124426027713059622-15-13019.9583all
14E6EB78BB-F7F4-44F6-A25E5F75CB82409D1049black#0000003XL54-5654-5624-2628-3056-5856-5854-5660-6256-5854-56wlingerie54-56intlsize19.95830STOCK01200-1000050124426027713047322-15-14019.9583all
15AE52D60D-B3C5-46BC-BDAC7BC25EE9D4561049nude#E3BC9A3XL54-5654-5624-2628-3056-5856-5854-5660-6256-5854-56wlingerie54-56intlsize19.95830STOCK01100-1010050124426027713053411-15-12019.9583all
16C3CD808A-BEC7-4118-837B902ECD25BDCA1050beige#F6DBAC4XL56-5856-5826-2830-3258-6058-6056-5862-6458-6056-58wlingerie56-58intlsize19.95830STOCK01100-1010050124426027713060211-11-13019.9583all
178ABFA0ED-E0EA-4FC6-BA8C301536F2BB371050black#0000004XL56-5856-5826-2830-3258-6058-6056-5862-6458-6056-58wlingerie56-58intlsize19.95830STOCK01000-10000501244260277130480-10-11-14019.9583all
18BE87DF6D-9439-48D1-A3AA147FB29E8F1A1050nude#E3BC9A4XL56-5856-5826-2830-3258-6058-6056-5862-6458-6056-58wlingerie56-58intlsize19.95830STOCK01000-10000501244260277130541-10-11-12019.9583all
vatrate
number20
warehouse
string