Το καλάθι μου

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

Κολάν μέχρι τον μηρό σε μεγάλο μέγεθος, χωρίς οριοθέτηση στους μηρούς και με ανοιχτά δάχτυλα.

Μέγεθος:

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

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

Μεγάλα καλσόν χωρίς δάχτυλα και χωρίς γραμμές

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

Κολάν με ανοιχτή μύτη.

Χωρίς οριοθέτηση στους μηρούς.

διαφανές, γυαλιστερό, φαρδύ στους γοφούς και τους μηρούς.

Άνετο, με τέλεια εφαρμογή, επίπεδη ραφή και ενισχυμένο εσώρουχο.

20 Denier / 22 DTEX

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

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

Διαθέσιμο από 42-44 έως 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.739 ms
Record Count: 2
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_colors.color as recorduid, product_colors.type, product_colors.code, product_colors.color, product_colors.range, product_colors.hexvalue,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock
from product_colors
left outer join product_variations on product_colors.color = product_variations.color and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
where FIND_IN_SET(product_colors.color,'black,beige') > 0
and product_variations.productuid = 'B1437285-0A15-48CA-AC4954EFC25BC58C'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1blackcolorblakblackblack#000000-10
2beigecolorbeigbeigebrown#F6DBAC-17
colorrange
stringbrown
colors
stringblack,beige
colortype
stringcolor
comments
string
compositions
Struct
Entries: 13
coton
string
elastane
string
free
string
leather
string
lycra
string
metal
string
nylon
string
polyamide
string
polyester
string
polyurethane
string
silk
string
spandex
string
viscose
string
datecreated
Date Time (Europe/Paris)
{ts '2019-10-09 10:16:40'}
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
number14.125
itempromo
string
key
string50223-toeless-20-make-up
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-10-05 16:50:44'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.61 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('b1437285-0a15-48ca-ac4954efc25bc58c',lcase(cart_actions.linkedproducts)) > 0 and cart_actions.linkedproducts is not null
)
id_actionbrandinglanguagenamecodetypeminimumOrdermaximumOrderminimumItemsmaximumItemsmaximumUseallowedItemsquotasusedCountlinkedproductslinkedthemeslinkedbrandslinkeditemparamsactiveFromactiveToisActive
linkedproducts
Query
Template: /system/api/products.cfc:1305
Execution Time: 1.32 ms
Record Count: 0
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select products.productuid as productuid, products.reference, 'default' as type, products.key, products.language, products.name,
product_links.linkuid,
products.colors, products.vatrate, products.metadatas, products.dimensions,
products.mediadatas, products.tags, products.themes, products.isdivasize,
count(distinct product_variations.variationuid) as totalvariations,
group_concat(distinct product_variations.variationuid) as variationlist,
count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END) as inpromo,
if(count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END)>0,1,0) as haspromo,
(select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0) END)) as itempromo,
IFNULL(min(product_variations.itemprice),0) as itemprice,
(select IF (products.isfixedprice = 0 and sum(product_variations.itempromo) > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null), IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0), IFNULL(min(NULLIF(product_variations.itemprice, 0)), 0) )) as unitprice,
count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.itempromo ELSE product_variations.itemprice END) as prices,
(select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN min(NULLIF(product_variations.promountil, 0)) END)) as promountil,
products.isfixedprice, products.ishot, products.isnew, if(products.orderidx > 0, products.orderidx, 999999999) as orderidx,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
count(distinct CASE WHEN ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) > 0 OR ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) <= 0 AND product_variations.supplier = 0)) THEN product_variations.variationuid END) as instockvariations,
products.brand, brands.name as brandname, IFNULL(brands.ispublic, 0) as showbrand, brands.display,
product_categories.sizetype,GROUP_CONCAT(DISTINCT product_sizes.suppliersize) as intlsize,products.sizes,product_sizes.sizerange,product_categories.mediadatas as categorymediadatas, product_categories.sizerange as categorysizerange,
product_categorymap.section, product_categorymap.category, product_categorymap.key as subcategory
from products
left outer join product_categorymap on products.productuid = product_categorymap.productuid
left outer join product_categories on (product_categories.branding = product_categorymap.branding and product_categories.section = product_categorymap.section and product_categories.category = product_categorymap.category and product_categories.key = product_categorymap.key)
left outer join product_sizes on product_sizes.id_size IN (products.sizes)
left outer join brands on products.brand = brands.brand
left outer join product_variations on product_variations.productuid = products.productuid and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
left outer join product_links on product_links.reference = products.reference
where products.isactive = 1 and products.isdeleted = 0
and brands.isactive = 1 and brands.isdeleted = 0
and product_categories.isactive = 1 and product_categories.isdeleted = 0
and product_variations.isactive = 1
and FIND_IN_SET('divasboudoir',products.branding)
and product_categories.branding IN ('all','divasboudoir')
and product_categorymap.branding IN ('all','divasboudoir')
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and products.language in ('all','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 <> 'SLTI8844'
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
string6600
isprivate
string0
rating
stringall
src
string/photobank/products/gjjm/slti8844/50223-toeless-20-make-up-plus-size.jpg
type
stringimg
width
string5320
back
Struct
height
string2539
isprivate
string0
rating
stringall
src
string/photobank/products/gjjm/slti8844/50223-toeless-20-make-up-plus-size_crop_2.jpg
type
stringimg
width
string2134
default
Struct
height
string2214
isprivate
string0
rating
stringall
src
string/photobank/products/gjjm/slti8844/50223-toeless-20-black-plus-size_crop_2.jpg
type
stringimg
width
string1877
variations
Struct
colors
Struct
beige
Struct
height
string2539
isprivate
string0
rating
stringall
src
string/photobank/products/gjjm/slti8844/50223-toeless-20-make-up-plus-size_crop_2.jpg
type
stringimg
width
string2134
black
Struct
height
string2553
isprivate
string0
rating
stringall
src
string/photobank/products/gjjm/slti8844/50223-toeless-20-black-plus-size_crop.jpg
type
stringimg
width
string2092
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
mediagallery
string
metadatas
Struct
darkboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz-ou-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro-ou-mpez
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black-ou-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro-ou-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-ou-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero-ou-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart-ou-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto-ou-bege
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
divasboudoir
Struct
de
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringAn den Zehen offene Strumpfhose.<br /><br />Ohne Abgrenzungen an den Oberschenkeln.<br /><br />transparent, gl&auml;nzend, H&uuml;ften und Oberschenkel sch&ouml;n breit.<br /><br />Bequem, perfekte Passform, flache N&auml;hte und verst&auml;rkte H&ouml;schen.<br /><br />20 Denier / 22 DTEX
guid
stringhttps://dev.divasboudoir.com/de/strumpfhosen-in-grossen-grossen-ohne-zehen-und-ohne-abgrenzungen-schwarz-ou-beige/slti8844.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringStrumpfhose in großen Größen ohne Abgrenzungen an den Oberschenkeln und offen an den Zehen.
keywords
string
title
stringStrumpfhosen in großen Größen ohne Zehen und ohne Abgrenzungen
seotitle
stringStrumpfhosen in großen Größen ohne Zehen und ohne Abgrenzungen
seouri
stringstrumpfhosen-in-grossen-grossen-ohne-zehen-und-ohne-abgrenzungen-schwarz-ou-beige
specifications
string
stylingtips
string
summary
stringStrumpfhose in gro&szlig;en Gr&ouml;&szlig;en ohne Abgrenzungen an den Oberschenkeln und offen an den Zehen.
title
stringStrumpfhosen ohne Zehen und ohne Abgrenzungen
usageinstructions
string
el
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringΚολάν με ανοιχτή μύτη.<br /><br />Χωρίς οριοθέτηση στους μηρούς.<br /><br />διαφανές, γυαλιστερό, φαρδύ στους γοφούς και τους μηρούς.<br /><br />Άνετο, με τέλεια εφαρμογή, επίπεδη ραφή και ενισχυμένο εσώρουχο.<br /><br />20 Denier / 22 DTEX
guid
stringhttps://dev.divasboudoir.com/el/megala-kalson-chwris-dachtyla-kai-chwris-grammes-mayro-ou-mpez/slti8844.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringΚολάν μέχρι τον μηρό σε μεγάλο μέγεθος, χωρίς οριοθέτηση στους μηρούς και με ανοιχτά δάχτυλα.
keywords
string
title
stringΜεγάλα καλσόν χωρίς δάχτυλα και χωρίς γραμμές
seotitle
stringΜεγάλα καλσόν χωρίς δάχτυλα και χωρίς γραμμές
seouri
stringmegala-kalson-chwris-dachtyla-kai-chwris-grammes-mayro-ou-mpez
specifications
string
stylingtips
string
summary
stringΚολάν μέχρι τον μηρό σε μεγάλο μέγεθος, χωρίς οριοθέτηση στους μηρούς και με ανοιχτά δάχτυλα.
title
stringΚαλσόν χωρίς δάχτυλα ή σημάδια
usageinstructions
string
en
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringOpen toe tights.<br /><br />Clear, shiny, wide hips and thighs.<br /><br />transparent, shiny, wide hips and thighs.<br /><br />Comfortable, perfect fit, flat seam and reinforced pantyhose.<br /><br />20 Denier / 22 DTEX
guid
stringhttps://dev.divasboudoir.com/en/plus-size-tights-without-toes-and-without-demarcations-black-ou-beige/slti8844.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringPlus size tights with seamless thighs and open toe.
keywords
string
title
stringPlus size tights without toes and without demarcations
seotitle
stringPlus size tights without toes and without demarcations
seouri
stringplus-size-tights-without-toes-and-without-demarcations-black-ou-beige
specifications
string
stylingtips
string
summary
stringPlus size tights with seamless thighs and open toe.
title
stringTights without toes and without marks
usageinstructions
string
es
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringMallas con puntera abierta.<br /><br />Sin demarcaci&oacute;n en los muslos.<br /><br />transparente, brillante, caderas y muslos anchos.<br /><br />C&oacute;modo, ajuste perfecto, costura plana y braga reforzada.<br /><br />20 Denier / 22 DTEX
guid
stringhttps://dev.divasboudoir.com/es/medias-de-talla-grande-sin-dedos-ni-lineas-negro-ou-beige/slti8844.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringMedias hasta el muslo en talla grande, sin demarcación en los muslos y punteras abiertas.
keywords
string
title
stringMedias de talla grande sin dedos ni líneas
seotitle
stringMedias de talla grande sin dedos ni líneas
seouri
stringmedias-de-talla-grande-sin-dedos-ni-lineas-negro-ou-beige
specifications
string
stylingtips
string
summary
stringMedias hasta el muslo en talla grande, sin demarcaci&oacute;n en los muslos y punteras abiertas.
title
stringLeotardos sin dedos ni marcas
usageinstructions
string
fr
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>Collants ouvert aux orteils.&nbsp;<br><br>Sans d&eacute;marcations au cuisses.&nbsp;<br><br>transparent, brillant, hanches et cuisses bien larges.<br><br>Confortables, coupe parfaite, couture plate et culotte renforc&eacute;e.&nbsp;<br><br>20 Denier / 22 DTEX</p>
guid
stringhttps://dev.divasboudoir.com/fr/collants-grande-taille-sans-orteils-et-sans-demarcations-noir-ou-beige/slti8844.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringCollants grande taille sans démarcations au cuisses, et ouvert au niveau des orteils.
keywords
string
title
stringCollants grande taille sans orteils et sans démarcations
seotitle
stringCollants grande taille sans orteils et sans démarcations
seouri
stringcollants-grande-taille-sans-orteils-et-sans-demarcations-noir-ou-beige
specifications
string
stylingtips
string
summary
string<p>Collants grande taille sans d&eacute;marcations au cuisses, et ouvert au niveau des orteils.</p>
title
stringCollants sans orteils et sans démarcations
usageinstructions
string
it
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringCollant con punta aperta.<br /><br />Nessuna demarcazione sulle cosce.<br /><br />trasparente, lucida, ampia su fianchi e cosce.<br /><br />Confortevole, vestibilità perfetta, cucitura piatta e mutandina rinforzata.<br /><br />20 denari / 22 DTEX
guid
stringhttps://dev.divasboudoir.com/it/collant-di-taglia-grande-senza-punte-e-senza-righe-nero-ou-beige/slti8844.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringCollant di taglia grande, senza delimitazione delle cosce e con punte aperte.
keywords
string
title
stringCollant di taglia grande senza punte e senza righe
seotitle
stringCollant di taglia grande senza punte e senza righe
seouri
stringcollant-di-taglia-grande-senza-punte-e-senza-righe-nero-ou-beige
specifications
string
stylingtips
string
summary
stringCollant di taglia grande, senza delimitazioni sulle cosce e con punte aperte.
title
stringCollant senza punte o segni
usageinstructions
string
nl
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringPanty met open teen.<br /><br />Geen afbakening bij de dijen.<br /><br />stevig, glanzend, brede heupen en dijen.<br /><br />Comfortabel, perfecte pasvorm, platte naad en versterkte panty.<br /><br />20 Denier / 22 DTEX
guid
stringhttps://dev.divasboudoir.com/nl/groote-maat-zonder-tenen-en-zonder-lijnen-zwart-ou-beige/slti8844.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringGroote maat panty, zonder afbakening bij de dijen en met open tenen.
keywords
string
title
stringGroote maat zonder tenen en zonder lijnen
seotitle
stringGroote maat zonder tenen en zonder lijnen
seouri
stringgroote-maat-zonder-tenen-en-zonder-lijnen-zwart-ou-beige
specifications
string
stylingtips
string
summary
stringGroote maat panty, zonder afbakening bij de dijen en met open tenen.
title
stringPanty zonder tenen of vlekken
usageinstructions
string
pt
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringCollants de biqueira aberta.<br /><br />Sem demarcação nas coxas.<br /><br />transparente, brilhante, ancas e coxas largas.<br /><br />Confortável, ajuste perfeito, costura plana e cuecas reforçadas.<br /><br />20 Denier / 22 DTEX
guid
stringhttps://dev.divasboudoir.com/pt/meias-calcas-largas-sem-dedos-e-sem-linhas-preto-ou-bege/slti8844.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringCollants à altura das coxas em tamanho grande, sem demarcação nas coxas e com os dedos dos pés abertos.
keywords
string
title
stringMeias-calças largas sem dedos e sem linhas
seotitle
stringMeias-calças largas sem dedos e sem linhas
seouri
stringmeias-calcas-largas-sem-dedos-e-sem-linhas-preto-ou-bege
specifications
string
stylingtips
string
summary
stringCollants à altura das coxas em tamanho grande, sem demarcação nas coxas e com os dedos dos pés abertos.
title
stringCollants sem dedos ou marcas
usageinstructions
string
fetishboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz-ou-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro-ou-mpez
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black-ou-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro-ou-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-ou-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero-ou-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart-ou-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto-ou-bege
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
latexboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz-ou-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro-ou-mpez
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black-ou-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro-ou-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-ou-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero-ou-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart-ou-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto-ou-bege
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
legsboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string<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, die Komfort neu definiert</strong>, entwickelt, um Ihren F&uuml;&szlig;en totale Freiheit zu bieten. Die gl&auml;nzende Transparenz betont Ihre Beine, w&auml;hrend der gro&szlig;z&uuml;gige Schnitt eine perfekte Passform garantiert. Ohne Abzeichnungen an den Oberschenkeln f&uuml;r einen unsichtbaren und nat&uuml;rlichen Effekt.</p>
highlights
string<ul> <li><strong>Offene Zehen</strong> f&uuml;r maximale Freiheit</li> <li><strong>Ohne Abzeichnungen</strong> an den Oberschenkeln</li> <li><strong>Transparent gl&auml;nzend</strong> 20 Denier</li> <li><strong>Breite H&uuml;ften und Oberschenkel</strong> f&uuml;r optimalen Komfort</li> <li><strong>Flache Naht</strong> und verst&auml;rktes H&ouml;schen</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringStrumpfhose mit offenen Zehen in Übergröße 20 Denier von Leg's Boudoir. Transparent glänzend, ohne Abzeichnungen. Erhältlich in Beige oder Schwarz. Komfort und Eleganz garantiert.
keywords
string
title
stringStrumpfhose mit offenen Zehen Übergröße | Leg's Boudoir
seotitle
stringÜbergröße Strumpfhose mit offenen Zehen - Transparent Glänzend 20 Denier
seouri
stringuebergroesse-strumpfhose-offene-zehen-transparent-glaenzend
specifications
string<ul> <li><strong>Material :</strong> 20 Denier / 22 DTEX</li> <li><strong>Farben :</strong> Beige oder Schwarz</li> <li><strong>Finish :</strong> Transparent gl&auml;nzend</li> <li><strong>Schnitt :</strong> Breite H&uuml;ften und Oberschenkel</li> <li><strong>Merkmale :</strong> Offene Zehen, ohne Abzeichnungen, flache Naht, verst&auml;rktes H&ouml;schen</li> </ul>
stylingtips
string<p>Perfekt zu kombinieren mit <strong>High-Heel-Sandalen</strong> oder <strong>eleganten offenen Schuhen</strong>. Ideal zu einem <strong>Sommerkleid</strong> oder einem <strong>schicken Ensemble</strong> f&uuml;r einen sophistizierten und komfortablen Look.</p>
summary
string<p><strong>Entdecken Sie totale Freiheit</strong> mit dieser &Uuml;bergr&ouml;&szlig;e-Strumpfhose mit offenen Zehen. Ein <u>innovatives Accessoire</u>, das gl&auml;nzende Transparenz und absoluten Komfort f&uuml;r einen einzigartigen Stil kombiniert.</p>
title
stringStrumpfhosen ohne Zehen und ohne Abgrenzungen
usageinstructions
string<p>Diese Strumpfhose bietet dank ihres gro&szlig;z&uuml;gigen Designs einen perfekten Schnitt. Die offenen Zehen erm&ouml;glichen es Ihnen, Ihre Lieblingssandalen zu tragen und gleichzeitig die Eleganz einer Strumpfhose zu genie&szlig;en. Das verst&auml;rkte H&ouml;schen sorgt den ganzen Tag &uuml;ber f&uuml;r komfortable Unterst&uuml;tzung.</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; &pi;&omicron;&upsilon; &epsilon;&pi;&alpha;&nu;&alpha;&pi;&rho;&omicron;&sigma;&delta;&iota;&omicron;&rho;ί&zeta;&epsilon;&iota; &tau;&eta;&nu; ά&nu;&epsilon;&sigma;&eta;</strong>, &sigma;&chi;&epsilon;&delta;&iota;&alpha;&sigma;&mu;έ&nu;&omicron; &gamma;&iota;&alpha; &nu;&alpha; &pi;&rho;&omicron;&sigma;&phi;έ&rho;&epsilon;&iota; &alpha;&pi;ό&lambda;&upsilon;&tau;&eta; &epsilon;&lambda;&epsilon;&upsilon;&theta;&epsilon;&rho;ί&alpha; &sigma;&tau;&alpha; &pi;ό&delta;&iota;&alpha; &sigma;&alpha;&sigmaf;. &Eta; &lambda;&alpha;&mu;&pi;&epsilon;&rho;ή &delta;&iota;&alpha;&phi;ά&nu;&epsilon;&iota;&alpha; &alpha;&nu;&alpha;&delta;&epsilon;&iota;&kappa;&nu;ύ&epsilon;&iota; &tau;&alpha; &pi;ό&delta;&iota;&alpha; &sigma;&alpha;&sigmaf;, &epsilon;&nu;ώ &eta; &gamma;&epsilon;&nu;&nu;&alpha;&iota;ό&delta;&omega;&rho;&eta; &gamma;&rho;&alpha;&mu;&mu;ή &epsilon;&gamma;&gamma;&upsilon;ά&tau;&alpha;&iota; &tau;έ&lambda;&epsilon;&iota;&alpha; &epsilon;&phi;&alpha;&rho;&mu;&omicron;&gamma;ή. &Chi;&omega;&rho;ί&sigmaf; &rho;&alpha;&phi;έ&sigmaf; &sigma;&tau;&omicron;&upsilon;&sigmaf; &mu;&eta;&rho;&omicron;ύ&sigmaf; &gamma;&iota;&alpha; έ&nu;&alpha; &alpha;ό&rho;&alpha;&tau;&omicron; &kappa;&alpha;&iota; &phi;&upsilon;&sigma;&iota;&kappa;ό &alpha;&pi;&omicron;&tau;έ&lambda;&epsilon;&sigma;&mu;&alpha;.</p>
highlights
string<ul> <li><strong>&Epsilon;&lambda;&epsilon;ύ&theta;&epsilon;&rho;&alpha; &delta;ά&chi;&tau;&upsilon;&lambda;&alpha;</strong> &gamma;&iota;&alpha; &mu;έ&gamma;&iota;&sigma;&tau;&eta; &epsilon;&lambda;&epsilon;&upsilon;&theta;&epsilon;&rho;ί&alpha;</li> <li><strong>&Chi;&omega;&rho;ί&sigmaf; &rho;&alpha;&phi;έ&sigmaf;</strong> &sigma;&tau;&omicron;&upsilon;&sigmaf; &mu;&eta;&rho;&omicron;ύ&sigmaf;</li> <li><strong>&Delta;&iota;ά&phi;&alpha;&nu;&omicron; &lambda;&alpha;&mu;&pi;&epsilon;&rho;ό</strong> 20 Denier</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;&eta; &rho;&alpha;&phi;ή</strong> &kappa;&alpha;&iota; &epsilon;&nu;&iota;&sigma;&chi;&upsilon;&mu;έ&nu;&omicron; &epsilon;&sigma;ώ&rho;&omicron;&upsilon;&chi;&omicron;</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringΚαλσόν με ελεύθερα δάχτυλα μεγάλου μεγέθους 20 Denier από το Leg's Boudoir. Διάφανο λαμπερό, χωρίς ραφές. Διαθέσιμο σε μπεζ ή μαύρο. Άνεση και κομψότητα εγγυημένα.
keywords
string
title
stringΚαλσόν με Ελεύθερα Δάχτυλα Μεγάλου Μεγέθους | Leg's Boudoir
seotitle
stringΚαλσόν Μεγάλου Μεγέθους με Ελεύθερα Δάχτυλα - Διάφανα Λαμπερά 20 Denier
seouri
stringkalson-megalou-megethous-eleythera-dachtyla-diafana-lampera
specifications
string<ul> <li><strong>&Upsilon;&lambda;&iota;&kappa;ό :</strong> 20 Denier / 22 DTEX</li> <li><strong>&Chi;&rho;ώ&mu;&alpha;&tau;&alpha; :</strong> &Mu;&pi;&epsilon;&zeta; ή &mu;&alpha;ύ&rho;&omicron;</li> <li><strong>&Tau;&epsilon;&lambda;&epsilon;ί&omega;&mu;&alpha; :</strong> &Delta;&iota;ά&phi;&alpha;&nu;&omicron; &lambda;&alpha;&mu;&pi;&epsilon;&rho;ό</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>&Chi;&alpha;&rho;&alpha;&kappa;&tau;&eta;&rho;&iota;&sigma;&tau;&iota;&kappa;ά :</strong> &Epsilon;&lambda;&epsilon;ύ&theta;&epsilon;&rho;&alpha; &delta;ά&chi;&tau;&upsilon;&lambda;&alpha;, &chi;&omega;&rho;ί&sigmaf; &rho;&alpha;&phi;έ&sigmaf;, &epsilon;&pi;ί&pi;&epsilon;&delta;&eta; &rho;&alpha;&phi;ή, &epsilon;&nu;&iota;&sigma;&chi;&upsilon;&mu;έ&nu;&omicron; &epsilon;&sigma;ώ&rho;&omicron;&upsilon;&chi;&omicron;</li> </ul>
stylingtips
string<p>&Tau;έ&lambda;&epsilon;&iota;&omicron; &gamma;&iota;&alpha; &nu;&alpha; &sigma;&upsilon;&nu;&delta;&upsilon;&alpha;&sigma;&tau;&epsilon;ί &mu;&epsilon; <strong>&pi;έ&delta;&iota;&lambda;&alpha; &mu;&epsilon; &tau;&alpha;&kappa;&omicron;ύ&nu;&iota;</strong> ή <strong>&kappa;&omicron;&mu;&psi;ά &alpha;&nu;&omicron;&iota;&chi;&tau;ά &pi;&alpha;&pi;&omicron;ύ&tau;&sigma;&iota;&alpha;</strong>. &Iota;&delta;&alpha;&nu;&iota;&kappa;ό &mu;&epsilon; έ&nu;&alpha; <strong>&kappa;&alpha;&lambda;&omicron;&kappa;&alpha;&iota;&rho;&iota;&nu;ό &phi;ό&rho;&epsilon;&mu;&alpha;</strong> ή έ&nu;&alpha; <strong>&kappa;&omicron;&mu;&psi;ό &sigma;ύ&nu;&omicron;&lambda;&omicron;</strong> &gamma;&iota;&alpha; έ&nu;&alpha; &epsilon;&kappa;&lambda;&epsilon;&pi;&tau;&upsilon;&sigma;&mu;έ&nu;&omicron; &kappa;&alpha;&iota; ά&nu;&epsilon;&tau;&omicron; look.</p>
summary
string<p><strong>&Alpha;&nu;&alpha;&kappa;&alpha;&lambda;ύ&psi;&tau;&epsilon; &tau;&eta;&nu; &alpha;&pi;ό&lambda;&upsilon;&tau;&eta; &epsilon;&lambda;&epsilon;&upsilon;&theta;&epsilon;&rho;ί&alpha;</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; &mu;&epsilon; &epsilon;&lambda;&epsilon;ύ&theta;&epsilon;&rho;&alpha; &delta;ά&chi;&tau;&upsilon;&lambda;&alpha;. Έ&nu;&alpha; <u>&kappa;&alpha;&iota;&nu;&omicron;&tau;ό&mu;&omicron; &alpha;&xi;&epsilon;&sigma;&omicron;&upsilon;ά&rho;</u> &pi;&omicron;&upsilon; &sigma;&upsilon;&nu;&delta;&upsilon;ά&zeta;&epsilon;&iota; &lambda;&alpha;&mu;&pi;&epsilon;&rho;ή &delta;&iota;&alpha;&phi;ά&nu;&epsilon;&iota;&alpha; &kappa;&alpha;&iota; &alpha;&pi;ό&lambda;&upsilon;&tau;&eta; ά&nu;&epsilon;&sigma;&eta; &gamma;&iota;&alpha; έ&nu;&alpha; &mu;&omicron;&nu;&alpha;&delta;&iota;&kappa;ό &sigma;&tau;&iota;&lambda;.</p>
title
stringΚαλσόν χωρίς δάχτυλα ή σημάδια
usageinstructions
string<p>&Alpha;&upsilon;&tau;ό &tau;&omicron; &kappa;&alpha;&lambda;&sigma;ό&nu; &pi;&rho;&omicron;&sigma;&phi;έ&rho;&epsilon;&iota; &tau;έ&lambda;&epsilon;&iota;&alpha; &gamma;&rho;&alpha;&mu;&mu;ή &chi;ά&rho;&eta; &sigma;&tau;&omicron; &gamma;&epsilon;&nu;&nu;&alpha;&iota;ό&delta;&omega;&rho;&omicron; &sigma;&chi;&epsilon;&delta;&iota;&alpha;&sigma;&mu;ό &tau;&omicron;&upsilon;. &Tau;&alpha; &epsilon;&lambda;&epsilon;ύ&theta;&epsilon;&rho;&alpha; &delta;ά&chi;&tau;&upsilon;&lambda;&alpha; &sigma;&alpha;&sigmaf; &epsilon;&pi;&iota;&tau;&rho;έ&pi;&omicron;&upsilon;&nu; &nu;&alpha; &phi;&omicron;&rho;έ&sigma;&epsilon;&tau;&epsilon; &tau;&alpha; &alpha;&gamma;&alpha;&pi;&eta;&mu;έ&nu;&alpha; &sigma;&alpha;&sigmaf; &sigma;&alpha;&nu;&delta;ά&lambda;&iota;&alpha; &alpha;&pi;&omicron;&lambda;&alpha;&mu;&beta;ά&nu;&omicron;&nu;&tau;&alpha;&sigmaf; &tau;&eta;&nu; &kappa;&omicron;&mu;&psi;ό&tau;&eta;&tau;&alpha; &epsilon;&nu;ό&sigmaf; &kappa;&alpha;&lambda;&sigma;ό&nu;. &Tau;&omicron; &epsilon;&nu;&iota;&sigma;&chi;&upsilon;&mu;έ&nu;&omicron; &epsilon;&sigma;ώ&rho;&omicron;&upsilon;&chi;&omicron; &epsilon;&xi;&alpha;&sigma;&phi;&alpha;&lambda;ί&zeta;&epsilon;&iota; ά&nu;&epsilon;&tau;&eta; &sigma;&tau;ή&rho;&iota;&xi;&eta; &kappa;&alpha;&theta;' ό&lambda;&eta; &tau;&eta; &delta;&iota;ά&rho;&kappa;&epsilon;&iota;&alpha; &tau;&eta;&sigmaf; &eta;&mu;έ&rho;&alpha;&sigmaf;.</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>A tight that reinvents comfort</strong>, designed to offer total freedom to your feet. The glossy transparency enhances your legs, while the generous cut ensures a perfect fit. Seamless at the thighs for an invisible and natural effect.</p>
highlights
string<ul> <li><strong>Open toe</strong> for maximum freedom</li> <li><strong>Seamless</strong> at the thighs</li> <li><strong>Transparent glossy</strong> 20 Denier</li> <li><strong>Wide hips and thighs</strong> for optimal comfort</li> <li><strong>Flat seam</strong> and reinforced panty</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringPlus size open toe tights 20 Denier from Leg's Boudoir. Transparent glossy, seamless. Available in beige or black. Comfort and elegance guaranteed.
keywords
string
title
stringOpen Toe Plus Size Tights | Leg's Boudoir
seotitle
stringPlus Size Open Toe Tights - Transparent Glossy 20 Denier
seouri
stringplus-size-open-toe-tights-transparent-glossy
specifications
string<ul> <li><strong>Material :</strong> 20 Denier / 22 DTEX</li> <li><strong>Colors :</strong> Beige or black</li> <li><strong>Finish :</strong> Transparent glossy</li> <li><strong>Fit :</strong> Wide hips and thighs</li> <li><strong>Features :</strong> Open toe, seamless, flat seam, reinforced panty</li> </ul>
stylingtips
string<p>Perfect to pair with <strong>high-heeled sandals</strong> or <strong>elegant open shoes</strong>. Ideal with a <strong>summer dress</strong> or a <strong>chic ensemble</strong> for a sophisticated and comfortable look.</p>
summary
string<p><strong>Discover total freedom</strong> with these plus-size open toe tights. An <u>innovative accessory</u> that combines glossy transparency and absolute comfort for a unique style.</p>
title
stringTights without toes and without marks
usageinstructions
string<p>These tights offer a perfect cut thanks to their generous design. The open toe allows you to wear your favorite sandals while enjoying the elegance of a tight. The reinforced panty ensures comfortable support all day long.</p>
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>Un dise&ntilde;o que reinventa el confort</strong>, pensado para ofrecer total libertad a tus pies. La transparencia brillante realza tus piernas, mientras el corte generoso garantiza un ajuste perfecto. Sin marcas en los muslos para un efecto invisible y natural.</p>
highlights
string<ul> <li><strong>Dedos libres</strong> para m&aacute;xima libertad</li> <li><strong>Sin marcas</strong> en los muslos</li> <li><strong>Transparentes brillantes</strong> 20 Denier</li> <li><strong>Caderas y muslos anchos</strong> para un confort &oacute;ptimo</li> <li><strong>Costura plana</strong> y braga reforzada</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringMedias con dedos libres talla grande 20 Denier de Leg's Boudoir. Transparentes brillantes, sin marcas. Disponibles en beige o negro. Confort y elegancia garantizados.
keywords
string
title
stringMedias con Dedos Libres Talla Grande | Leg's Boudoir
seotitle
stringMedias Talla Grande con Dedos Libres - Transparentes Brillantes 20 Denier
seouri
stringmedias-talla-grande-dedos-libres-transparentes-brillantes
specifications
string<ul> <li><strong>Material :</strong> 20 Denier / 22 DTEX</li> <li><strong>Colores :</strong> Beige o negro</li> <li><strong>Acabado :</strong> Transparente brillante</li> <li><strong>Corte :</strong> Caderas y muslos anchos</li> <li><strong>Caracter&iacute;sticas :</strong> Dedos libres, sin marcas, costura plana, braga reforzada</li> </ul>
stylingtips
string<p>Perfectas para combinar con <strong>sandalias de tac&oacute;n</strong> o <strong>zapatos abiertos elegantes</strong>. Ideales con un <strong>vestido de verano</strong> o un <strong>conjunto chic</strong> para un look sofisticado y c&oacute;modo.</p>
summary
string<p><strong>Descubre la libertad total</strong> con estas medias talla grande con dedos libres. Un <u>accesorio innovador</u> que combina transparencia brillante y confort absoluto para un estilo &uacute;nico.</p>
title
stringLeotardos sin dedos ni marcas
usageinstructions
string<p>Estas medias ofrecen un corte perfecto gracias a su dise&ntilde;o generoso. Los dedos libres te permiten usar tus sandalias favoritas mientras disfrutas de la elegancia de unas medias. La braga reforzada asegura un soporte c&oacute;modo durante todo el d&iacute;a.</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 qui r&eacute;invente le confort</strong>, pens&eacute; pour offrir une libert&eacute; totale &agrave; vos pieds. La transparence brillante met en valeur vos jambes, tandis que la coupe g&eacute;n&eacute;reuse garantit un ajustement parfait. Sans d&eacute;marcations aux cuisses pour un effet invisible et naturel.</p>
highlights
string<ul> <li><strong>Ouverts aux orteils</strong> pour une libert&eacute; maximale</li> <li><strong>Sans d&eacute;marcations</strong> aux cuisses</li> <li><strong>Transparent brillant</strong> 20 Denier</li> <li><strong>Hanches et cuisses larges</strong> pour un confort optimal</li> <li><strong>Couture plate</strong> et culotte renforc&eacute;e</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringCollants grande taille ouverts orteils 20 Denier de Leg's Boudoir. Transparent brillant, sans démarcations. Disponibles en beige ou noir. Confort et élégance garantis.
keywords
string
title
stringCollants Ouverts Orteils Grande Taille | Leg's Boudoir
seotitle
stringCollants Grande Taille Ouverts Orteils - Transparent Brillant 20 Denier
seouri
stringcollants-grande-taille-ouverts-orteils-transparent-brillant
specifications
string<ul> <li><strong>Mati&egrave;re :</strong> 20 Denier / 22 DTEX</li> <li><strong>Couleurs :</strong> Beige ou noir</li> <li><strong>Finition :</strong> Transparent brillant</li> <li><strong>Coupe :</strong> Hanches et cuisses larges</li> <li><strong>Caract&eacute;ristiques :</strong> Ouverts aux orteils, sans d&eacute;marcations, couture plate, culotte renforc&eacute;e</li> </ul>
stylingtips
string<p>Parfaits pour accompagner des <strong>sandales &agrave; talons</strong> ou des <strong>nu-pieds &eacute;l&eacute;gants</strong>. Id&eacute;aux avec une <strong>robe d'&eacute;t&eacute;</strong> ou un <strong>ensemble chic</strong> pour un look sophistiqu&eacute; et confortable.</p> <p>Explorez nos <a href="https://www.legsboudoir.com/fr/bas-autofixants-grande-taille/">collants ouverts grande taille</a> pour plus d'audace.<a href="/collections/collants-grande-taille"></a></p>
summary
string<p><strong>D&eacute;couvrez une libert&eacute; totale</strong> avec ces collants grande taille ouverts aux orteils. Un <u>accessoire innovant</u> qui allie transparence brillante et confort absolu pour un style unique.</p>
title
stringCollants sans orteils et sans démarcations
usageinstructions
string<p>Ces collants offrent une coupe parfaite gr&acirc;ce &agrave; leur conception g&eacute;n&eacute;reuse. L'ouverture aux orteils permet de porter vos sandales pr&eacute;f&eacute;r&eacute;es tout en profitant de l'&eacute;l&eacute;gance d'un collant. La culotte renforc&eacute;e assure un maintien confortable toute la journ&eacute;e.</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 che reinventa il comfort</strong>, progettato per offrire totale libert&agrave; ai tuoi piedi. La trasparenza lucente esalta le tue gambe, mentre il taglio generoso garantisce una vestibilit&agrave; perfetta. Senza segni sulle cosce per un effetto invisibile e naturale.</p>
highlights
string<ul> <li><strong>Dita libere</strong> per la massima libert&agrave;</li> <li><strong>Senza segni</strong> sulle cosce</li> <li><strong>Trasparenti lucenti</strong> 20 Denier</li> <li><strong>Fianchi e cosce larghe</strong> per un comfort ottimale</li> <li><strong>Cucitura piatta</strong> e culotte rinforzata</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringCollant con dita libere taglie forti 20 Denier di Leg's Boudoir. Trasparenti lucenti, senza segni. Disponibili in beige o nero. Comfort ed eleganza garantiti.
keywords
string
title
stringCollant con Dita Libere Taglie Forti | Leg's Boudoir
seotitle
stringCollant Taglie Forti con Dita Libere - Trasparenti Lucenti 20 Denier
seouri
stringcollant-taglie-forti-dita-libere-trasparenti-lucenti
specifications
string<ul> <li><strong>Materiale :</strong> 20 Denier / 22 DTEX</li> <li><strong>Colori :</strong> Beige o nero</li> <li><strong>Finitura :</strong> Trasparente lucente</li> <li><strong>Taglio :</strong> Fianchi e cosce larghe</li> <li><strong>Caratteristiche :</strong> Dita libere, senza segni, cucitura piatta, culotte rinforzata</li> </ul>
stylingtips
string<p>Perfetti da abbinare a <strong>sandali con tacco</strong> o <strong>scarpe aperte eleganti</strong>. Ideali con un <strong>abito estivo</strong> o un <strong>completo chic</strong> per un look sofisticato e comodo.</p>
summary
string<p><strong>Scopri la libert&agrave; totale</strong> con questi collant taglie forti con dita libere. Un <u>accessorio innovativo</u> che combina trasparenza lucente e comfort assoluto per uno stile unico.</p>
title
stringCollant senza punte o segni
usageinstructions
string<p>Questi collant offrono un taglio perfetto grazie al loro design generoso. Le dita libere ti permettono di indossare i tuoi sandali preferiti godendoti l'eleganza di un collant. La culotte rinforzata assicura un supporto confortevole durante l'intera giornata.</p>
nl
Struct
Entries: 14
abstract
string
careinstructions
string<ul> <li>Handwas in koud water</li> <li>Niet wringen of centrifugeren</li> <li>Liggend in de schaduw laten drogen</li> <li>Niet strijken</li> </ul>
description
string<p><strong>Een panty die comfort heruitvindt</strong>, ontworpen om uw voeten totale vrijheid te bieden. De glanzende transparantie benadrukt uw benen, terwijl de ruime pasvorm een perfecte fit garandeert. Zonder zichtbare lijnen bij de dijen voor een onzichtbaar en natuurlijk effect.</p>
highlights
string<ul> <li><strong>Open tenen</strong> voor maximale vrijheid</li> <li><strong>Zonder zichtbare lijnen</strong> bij de dijen</li> <li><strong>Transparant glanzend</strong> 20 Denier</li> <li><strong>Brede heupen en dijen</strong> voor optimaal comfort</li> <li><strong>Platte naad</strong> en versterkt broekje</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringGrote maat open teen panty 20 Denier van Leg's Boudoir. Transparant glanzend, zonder zichtbare lijnen. Verkrijgbaar in beige of zwart. Comfort en elegantie gegarandeerd.
keywords
string
title
stringOpen Teen Panty Grote Maat | Leg's Boudoir
seotitle
stringGrote Maat Open Teen Panty - Transparant Glanzend 20 Denier
seouri
stringgrote-maat-open-teen-panty-transparant-glanzend
specifications
string<ul> <li><strong>Materiaal :</strong> 20 Denier / 22 DTEX</li> <li><strong>Kleuren :</strong> Beige of zwart</li> <li><strong>Afwerking :</strong> Transparant glanzend</li> <li><strong>Pasvorm :</strong> Brede heupen en dijen</li> <li><strong>Kenmerken :</strong> Open tenen, zonder zichtbare lijnen, platte naad, versterkt broekje</li> </ul>
stylingtips
string<p>Perfect te combineren met <strong>sandalen met hak</strong> of <strong>elegante open schoenen</strong>. Ideaal met een <strong>zomerjurk</strong> of een <strong>chique ensemble</strong> voor een verfijnde en comfortabele look.</p>
summary
string<p><strong>Ontdek totale vrijheid</strong> met deze grote maat panty met open tenen. Een <u>innovatief accessoire</u> dat glanzende transparantie en absoluut comfort combineert voor een unieke stijl.</p>
title
stringPanty zonder tenen of vlekken
usageinstructions
string<p>Deze panty's bieden een perfecte pasvorm dankzij hun ruime ontwerp. De open tenen stellen u in staat uw favoriete sandalen te dragen terwijl u geniet van de elegantie van een panty. Het versterkte broekje zorgt voor comfortabele ondersteuning de hele dag.</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</li> </ul>
description
string<p><strong>Uma meia-cal&ccedil;a que reinventa o conforto</strong>, projetada para oferecer liberdade total aos seus p&eacute;s. A transpar&ecirc;ncia brilhante real&ccedil;a suas pernas, enquanto o corte generoso garante um ajuste perfeito. Sem marca&ccedil;&otilde;es nas coxas para um efeito invis&iacute;vel e natural.</p>
highlights
string<ul> <li><strong>Dedos livres</strong> para m&aacute;xima liberdade</li> <li><strong>Sem marca&ccedil;&otilde;es</strong> nas coxas</li> <li><strong>Transparente brilhante</strong> 20 Denier</li> <li><strong>Quadris e coxas largos</strong> para conforto m&aacute;ximo</li> <li><strong>Costura plana</strong> e parte &iacute;ntima refor&ccedil;ada</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
stringMeia-Calça com Dedos Livres Plus Size | Leg's Boudoir
seotitle
stringMeia-Calça Plus Size com Dedos Livres - Transparente Brilhante 20 Denier
seouri
stringmeia-calca-plus-size-dedos-livres-transparente-brilhante
specifications
string<ul> <li><strong>Material :</strong> 20 Denier / 22 DTEX</li> <li><strong>Cores :</strong> Bege ou preto</li> <li><strong>Acabamento :</strong> Transparente brilhante</li> <li><strong>Corte :</strong> Quadris e coxas largos</li> <li><strong>Caracter&iacute;sticas :</strong> Dedos livres, sem marca&ccedil;&otilde;es, costura plana, parte &iacute;ntima refor&ccedil;ada</li> </ul>
stylingtips
string<p>Perfeitas para combinar com <strong>sand&aacute;lias de salto</strong> ou <strong>sapatos abertos elegantes</strong>. Ideais com um <strong>vestido de ver&atilde;o</strong> ou um <strong>conjunto chique</strong> para um visual sofisticado e confort&aacute;vel.</p>
summary
string<p><strong>Descubra a liberdade total</strong> com esta meia-cal&ccedil;a plus size com dedos livres. Um <u>acess&oacute;rio inovador</u> que combina transpar&ecirc;ncia brilhante e conforto absoluto para um estilo &uacute;nico.</p>
title
stringCollants sem dedos ou marcas
usageinstructions
string<p>Estas meias-cal&ccedil;a oferecem um corte perfeito gra&ccedil;as ao seu design generoso. Os dedos livres permitem que voc&ecirc; use suas sand&aacute;lias favoritas enquanto desfruta da eleg&acirc;ncia de uma meia-cal&ccedil;a. A parte &iacute;ntima refor&ccedil;ada garante suporte confort&aacute;vel durante todo o dia.</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-ou-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro-ou-mpez
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black-ou-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro-ou-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-ou-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero-ou-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart-ou-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto-ou-bege
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
smboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz-ou-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro-ou-mpez
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black-ou-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro-ou-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-ou-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero-ou-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart-ou-beige
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto-ou-bege
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
name
string50223 Toeless 20 make up
netweight
string
nextshipment
stringtomorrow
ordered
number3
orderidx
number0
origin
stringeu
originalsize
string
packaging
string
productshipment
stringauto
productuid
stringB1437285-0A15-48CA-AC4954EFC25BC58C
promountil
string
rating
stringnone
recorduid
stringB1437285-0A15-48CA-AC4954EFC25BC58C
reference
stringSLTI8844
related
string
reserved
string
returned
number0
returnsallowed
number1
section
stringlingerie
shipment
string4to6days
showbrand
number0
sizeinfos
Query
Template: /system/api/product/sizes.cfc:20
Execution Time: 1.72 ms
Record Count: 10
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_sizes.id_size as recorduid, if(intlsize <> '',intlsize,eusize) as size, if(intlsize <> '','intlsize','eusize') as sizetype,
product_variations.color,
if(product_sizes.sizegroup = 'bra',
if(intlsize <> '', cast(intlsize as SIGNED ), cast(eusize as SIGNED ))
,
SUBSTRING_INDEX(intlsize,'-',1)
) as param1,
if(product_sizes.sizegroup = 'bra',
if(intlsize <> '',
MID(intlsize,length(cast(intlsize as SIGNED ))+1,length(intlsize)),
MID(eusize,length(cast(eusize as SIGNED ))+1,length(eusize))
)
,
SUBSTRING_INDEX(intlsize,'-',-1)
) as param2,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as available,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
999999,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as groupavailable,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
product_sizes.gender, product_sizes.sizerange, product_sizes.sizegroup, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize,
product_sizes.bust, product_sizes.waist, product_sizes.hip, product_sizes.underbust, product_sizes.cup, product_sizes.thigh, product_sizes.legheight, product_sizes.bodyheight, product_sizes.bodyweight
from product_sizes
left outer join product_variations on product_sizes.suppliersize = product_variations.size and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
where FIND_IN_SET(product_sizes.id_size,'1046,1047,1048,1049,1050') > 0
and product_variations.productuid = 'B1437285-0A15-48CA-AC4954EFC25BC58C'
and intlsize <> 'na'
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_sizes.id_size, product_variations.color
order by FIELD(product_sizes.gender,'w','m'), product_sizes.sizegroup, FIELD(intlsize,'XS','S','S/M','S-M','M','M/L','M-L','L','L-XL','L/XL','XL','0X','0XL','lXL','1X','1X-2X','1X/2X','XL/2XL','XL-2XL','1XL-2XL','2XL','2X','XXL','2X-3X','2X/3X','2XL-3XL','2XL/3XL','XXXL','3XL','3X','3X-4X','3X/4X','3XL-4XL','3XL/4XL','4XL','5XL','5X','5X-6X','5X/6X','5XL-6XL','5XL/6XL','6XL','6X','7XL','7X','8XL','8X'), cast(intlsize as SIGNED ), groupavailable desc, stock desc
recorduidsizesizetypecolorparam1param2availablegroupavailablestockgendersizerangesizegroupsuppliersizeintlsizeincheseusizeussizeuksizefrsizeessizedesizeitsizeptsizeelsizebustwaisthipunderbustcupthighlegheightbodyheightbodyweight
1104642-44intlsizebeige4244-19999996wpluslingerieL42-4442-4412-1416-1844-4644-4642-4448-5042-4442-44
2104642-44intlsizeblack4244-19999990wpluslingerieL42-4442-4412-1416-1844-4644-4642-4448-5042-4442-44
3104746-48intlsizebeige4648-19999990wpluslingerieXL46-4846-4816-1820-2248-5048-5046-4852-5448-5046-48
4104746-48intlsizeblack4648-19999990wpluslingerieXL46-4846-4816-1820-2248-5048-5046-4852-5448-5046-48
5104850-52intlsizebeige5052-19999990wpluslingerie2XL50-5250-5220-2224-2652-5452-5450-5256-5852-5450-52
6104850-52intlsizeblack5052-19999990wpluslingerie2XL50-5250-5220-2224-2652-5452-5450-5256-5852-5450-52
7104954-56intlsizeblack5456-19999991wpluslingerie3XL54-5654-5624-2628-3056-5856-5854-5660-6256-5854-56
8104954-56intlsizebeige5456-19999990wpluslingerie3XL54-5654-5624-2628-3056-5856-5854-5660-6256-5854-56
9105056-58intlsizebeige5658-19999991wpluslingerie4XL56-5856-5826-2830-3258-6058-6056-5862-6458-6056-58
10105056-58intlsizeblack5658-19999990wpluslingerie4XL56-5856-5826-2830-3258-6058-6056-5862-6458-6056-58
sizeranges
stringplus
sizes
string1046,1047,1048,1049,1050
sizetype
stringauto
specifications
Struct
Entries: 23
belly
string
bones
string
bra
string
breasts
string
bust
string
closing
string
crochtless
string
cups
string
cut
string
garter
string
halter
string
lacing
string
lining
string
modestypanel
string
panty
string
sheathing
string
sleeves
string
stocking
string
straps
string
stretch
string
suspenders
string
transparency
string
underwires
string
stock
number0
stocks
Query
Template: /system/api/product/stocks.cfc:25
Execution Time: 34.7 ms
Record Count: 10
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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C'
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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C'
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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C'
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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C'
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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C'
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
1B1437285-0A15-48CA-AC4954EFC25BC58C32B5994F-F2CD-474E-83CA95F3DCC20C971046beige#F6DBACL42-4442-4412-1416-1844-4644-4642-4448-5042-4442-44wlingerie42-44intlsize14.1250STOCK01600-1000050223426027713817266all
2B1437285-0A15-48CA-AC4954EFC25BC58CA2AAD0E1-89B7-48FE-B2F7CC0BF5EAD62E1046black#000000L42-4442-4412-1416-1844-4644-4642-4448-5042-4442-44wlingerie42-44intlsize14.1250STOCK01000-10000502234260277138110-10all
3B1437285-0A15-48CA-AC4954EFC25BC58C7CE008F6-FD2E-45FC-A0DCEEF5BFB6D4B61047beige#F6DBACXL46-4846-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie46-48intlsize14.1250STOCK01000-10000502234260277138189-10all
4B1437285-0A15-48CA-AC4954EFC25BC58C37282DD5-085C-4DFA-B04037A53CA697E41047black#000000XL46-4846-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie46-48intlsize14.1250STOCK01000-11000502234260277138127-10all
5B1437285-0A15-48CA-AC4954EFC25BC58C5F746030-18AD-41BC-A5841F1E399701B31048beige#F6DBAC2XL50-5250-5220-2224-2652-5452-5450-5256-5852-5450-52wlingerie50-52intlsize14.1250STOCK01100-11200502234260277138196-10all
6B1437285-0A15-48CA-AC4954EFC25BC58C0FF8B067-AE0B-4A0C-9CD2E1BB05071A781048black#0000002XL50-5250-5220-2224-2652-5452-5450-5256-5852-5450-52wlingerie50-52intlsize14.1250STOCK01000-10200502234260277138134-10all
7B1437285-0A15-48CA-AC4954EFC25BC58C17967FDF-6087-4B3C-963A325E5E9C3ED71049beige#F6DBAC3XL54-5654-5624-2628-3056-5856-5854-5660-6256-5854-56wlingerie54-56intlsize14.1250STOCK01000-10000502234260277138202-10all
8B1437285-0A15-48CA-AC4954EFC25BC58C02F7F2D5-AEF8-4A80-BE8A83B3DB725AB21049black#0000003XL54-5654-5624-2628-3056-5856-5854-5660-6256-5854-56wlingerie54-56intlsize14.1250STOCK01100-1000050223426027713814111all
9B1437285-0A15-48CA-AC4954EFC25BC58C47015F66-30CC-40C3-AC10804C301F86C01050beige#F6DBAC4XL56-5856-5826-2830-3258-6058-6056-5862-6458-6056-58wlingerie56-58intlsize14.1250STOCK01100-1000050223426027713821911all
10B1437285-0A15-48CA-AC4954EFC25BC58C31AB031F-63FB-491C-98BF34A940D972EC1050black#0000004XL56-5856-5826-2830-3258-6058-6056-5862-6458-6056-58wlingerie56-58intlsize14.1250STOCK01000-10100502234260277138158-10all
subcategory
stringtights
supplier
number-1
supplierreference
string50223
tags
string
themes
string
totalvariations
string
type
stringdefault
unitprice
number14.125
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 12.2 ms
Record Count: 10
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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C'
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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C'
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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C'
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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C'
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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C'
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
132B5994F-F2CD-474E-83CA95F3DCC20C971046beige#F6DBACL42-4442-4412-1416-1844-4644-4642-4448-5042-4442-44wlingerie42-44intlsize14.1250STOCK01600-1000050223426027713817266-16-17014.125all
2A2AAD0E1-89B7-48FE-B2F7CC0BF5EAD62E1046black#000000L42-4442-4412-1416-1844-4644-4642-4448-5042-4442-44wlingerie42-44intlsize14.1250STOCK01000-10000502234260277138110-10-16-10014.125all
37CE008F6-FD2E-45FC-A0DCEEF5BFB6D4B61047beige#F6DBACXL46-4846-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie46-48intlsize14.1250STOCK01000-10000502234260277138189-10-10-17014.125all
437282DD5-085C-4DFA-B04037A53CA697E41047black#000000XL46-4846-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie46-48intlsize14.1250STOCK01000-11000502234260277138127-10-10-10014.125all
55F746030-18AD-41BC-A5841F1E399701B31048beige#F6DBAC2XL50-5250-5220-2224-2652-5452-5450-5256-5852-5450-52wlingerie50-52intlsize14.1250STOCK01100-11200502234260277138196-10-10-17014.125all
60FF8B067-AE0B-4A0C-9CD2E1BB05071A781048black#0000002XL50-5250-5220-2224-2652-5452-5450-5256-5852-5450-52wlingerie50-52intlsize14.1250STOCK01000-10200502234260277138134-10-10-10014.125all
717967FDF-6087-4B3C-963A325E5E9C3ED71049beige#F6DBAC3XL54-5654-5624-2628-3056-5856-5854-5660-6256-5854-56wlingerie54-56intlsize14.1250STOCK01000-10000502234260277138202-10-11-17014.125all
802F7F2D5-AEF8-4A80-BE8A83B3DB725AB21049black#0000003XL54-5654-5624-2628-3056-5856-5854-5660-6256-5854-56wlingerie54-56intlsize14.1250STOCK01100-1000050223426027713814111-11-10014.125all
947015F66-30CC-40C3-AC10804C301F86C01050beige#F6DBAC4XL56-5856-5826-2830-3258-6058-6056-5862-6458-6056-58wlingerie56-58intlsize14.1250STOCK01100-1000050223426027713821911-11-17014.125all
1031AB031F-63FB-491C-98BF34A940D972EC1050black#0000004XL56-5856-5826-2830-3258-6058-6056-5862-6458-6056-58wlingerie56-58intlsize14.1250STOCK01000-10100502234260277138158-10-11-10014.125all
vatrate
number20
warehouse
string