Il mio cestino

❌
Totale articoli
Visualizza il carrello
Menu
Vedere le dimensioni
Allie hold up
Doppio clic per ingrandire
SKU: SLST0809
Allie hold up
Stock:

Eleganza e glamour in queste calze taglia grande, con un tocco moderno.

Taglia:

Non siete sicuri della taglia da scegliere? Consultare la nostra guida alle taglie

Colore:
Quantità:
24.95 €
Aiuto e consulenza
via chat, facebook o e-mail
Restituzione gratuita
entro 15 giorni *

Calzetteria taglia grande Allie

Descrizione del prodotto

Calze autoreggenti Allie

Riportiamo in auge i pois con questo modello di alta qualità che non si arrotola (se si prende la taglia giusta).

Ci piace il contrasto tra il glamour del motivo e la modernità della fascia.

Dettagli tecnici

Dimensioni disponibili

Disponibile da 4-5 a 8-9

Colore disponibile

Nero

Guida alle taglie

Controllare la taglia giusta per voi

Internazionale
  • Coscia
4-5
  • 55-63
6-7
  • 63-76
8-9
  • 75-90
To Top
Visualizza il carrello
Articoli
Totale articoli
Struct
Entries: 108
actions
Array
available
number-1
brand
stringkixies
brandcode
stringkbvy
branding
stringdivasboudoir,smboudoir,legsboudoir
brandmedias
string{"default":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"editorial":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"logo":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""}}
brandmetas
Struct
de
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
el
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
en
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
es
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
fr
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
it
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
nl
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
pt
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
brandname
stringKixies
breasts
stringna
careinstructions
string
categories
stringdivasboudoir.lingerie.hoisery.stocking
category
stringhoisery
categorygender
stringf
categorymediadatas
Struct
adult
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string628
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/lingerie/hoisery/stockings.jpg
type
stringimg
width
string1365
divasboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
fetishboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
latexboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
legsboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
lustboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
private
Struct
height
string1016
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/private/default.jpg
type
stringimg
width
string703
smboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
categorysizerange
stringauto
colorinfos
Query
Template: /system/api/product/colors.cfc:13
Execution Time: 0.702 ms
Record Count: 1
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_colors.color as recorduid, product_colors.type, product_colors.code, product_colors.color, product_colors.range, product_colors.hexvalue,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock
from product_colors
left outer join product_variations on product_colors.color = product_variations.color and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
where FIND_IN_SET(product_colors.color,'black') > 0
and product_variations.productuid = 'A5EAA760-E93C-4923-BF5C51236229AF75'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1blackcolorblakblackblack#000000-10
colorrange
stringblack
colors
stringblack
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 '2021-09-22 15:19:36'}
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
number0
isfirstprice
number0
isfixedprice
number0
ishot
number0
isnew
number0
isonline
number0
isoutletprice
number0
itemprice
number20.7917
itempromo
string
key
stringally
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-08-01 18:23:24'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.65 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','it')
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('a5eaa760-e93c-4923-bf5c51236229af75',lcase(cart_actions.linkedproducts)) > 0 and cart_actions.linkedproducts is not null
)
id_actionbrandinglanguagenamecodetypeminimumOrdermaximumOrderminimumItemsmaximumItemsmaximumUseallowedItemsquotasusedCountlinkedproductslinkedthemeslinkedbrandslinkeditemparamsactiveFromactiveToisActive
linkedproducts
Query
Template: /system/api/products.cfc:1305
Execution Time: 1.31 ms
Record Count: 0
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select products.productuid as productuid, products.reference, 'default' as type, products.key, products.language, products.name,
product_links.linkuid,
products.colors, products.vatrate, products.metadatas, products.dimensions,
products.mediadatas, products.tags, products.themes, products.isdivasize,
count(distinct product_variations.variationuid) as totalvariations,
group_concat(distinct product_variations.variationuid) as variationlist,
count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END) as inpromo,
if(count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END)>0,1,0) as haspromo,
(select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0) END)) as itempromo,
IFNULL(min(product_variations.itemprice),0) as itemprice,
(select IF (products.isfixedprice = 0 and sum(product_variations.itempromo) > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null), IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0), IFNULL(min(NULLIF(product_variations.itemprice, 0)), 0) )) as unitprice,
count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.itempromo ELSE product_variations.itemprice END) as prices,
(select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN min(NULLIF(product_variations.promountil, 0)) END)) as promountil,
products.isfixedprice, products.ishot, products.isnew, if(products.orderidx > 0, products.orderidx, 999999999) as orderidx,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
count(distinct CASE WHEN ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) > 0 OR ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) <= 0 AND product_variations.supplier = 0)) THEN product_variations.variationuid END) as instockvariations,
products.brand, brands.name as brandname, IFNULL(brands.ispublic, 0) as showbrand, brands.display,
product_categories.sizetype,GROUP_CONCAT(DISTINCT product_sizes.suppliersize) as intlsize,products.sizes,product_sizes.sizerange,product_categories.mediadatas as categorymediadatas, product_categories.sizerange as categorysizerange,
product_categorymap.section, product_categorymap.category, product_categorymap.key as subcategory
from products
left outer join product_categorymap on products.productuid = product_categorymap.productuid
left outer join product_categories on (product_categories.branding = product_categorymap.branding and product_categories.section = product_categorymap.section and product_categories.category = product_categorymap.category and product_categories.key = product_categorymap.key)
left outer join product_sizes on product_sizes.id_size IN (products.sizes)
left outer join brands on products.brand = brands.brand
left outer join product_variations on product_variations.productuid = products.productuid and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
left outer join product_links on product_links.reference = products.reference
where products.isactive = 1 and products.isdeleted = 0
and brands.isactive = 1 and brands.isdeleted = 0
and product_categories.isactive = 1 and product_categories.isdeleted = 0
and product_variations.isactive = 1
and FIND_IN_SET('divasboudoir',products.branding)
and product_categories.branding IN ('all','divasboudoir')
and product_categorymap.branding IN ('all','divasboudoir')
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and products.language in ('all','it')
and product_categories.language in ('all','it')
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 <> 'SLST0809'
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
string1220
isprivate
string0
rating
stringall
src
string/photobank/products/kbvy/slau2960/bas-autofixants-grande-taille-petis-pois-sexy.jpg
type
stringimg
width
string900
back
Struct
height
string509
isprivate
string0
rating
stringall
src
string/pictures/smallres/products/kbvy/slau2960/autofixants-petits-pois-curvy-sexy.jpg
type
stringimg
width
string331
default
Struct
height
string551
isprivate
string0
rating
stringall
src
string/photobank/products/kbvy/slau2960/showpicture_13.jpg
type
stringimg
width
string388
variations
Struct
colors
Struct
black
Struct
height
string1797
isprivate
string0
rating
stringall
src
string/photobank/products/kbvy/slau2960/bas-autofixants-petits-pois-grande-taille.png
type
stringimg
width
string900
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-kixies-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
divasboudoir
Struct
de
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringSelbstbindende Str&uuml;mpfe Allie<br /><br />Wir bringen die Erbsen wieder in Mode mit diesem Modell von sehr sch&ouml;ner Qualit&auml;t, das nicht rollt (wenn Sie es in der richtigen Gr&ouml;&szlig;e nehmen).<br /><br />Wir m&ouml;gen den Kontrast zwischen dem glamour&ouml;sen Muster und dem modernen Band sehr.
guid
stringhttps://dev.divasboudoir.com/de/strumpfe-grosse-grosse-selbstfixierend-allie-kixies-schwarz/slst0809.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringEleganz und Glamour in diesen Strümpfen in großen Größen mit einem Hauch von Modernität.
keywords
string
title
stringStrümpfe große Größe Selbstfixierend Allie
seotitle
stringStrümpfe große Größe Selbstfixierend Allie
seouri
stringstrumpfe-grosse-grosse-selbstfixierend-allie-kixies-schwarz
specifications
string
stylingtips
string
summary
stringEleganz und Glamour in diesen Str&uuml;mpfen in gro&szlig;en Gr&ouml;&szlig;en mit einem Hauch von Modernit&auml;t.
title
stringSelbstfixierende Strümpfe Allie
usageinstructions
string
el
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringAllie hold-ups<br /><br />&Xi;&alpha;&nu;&alpha;&phi;έ&rho;&nu;&omicron;&upsilon;&mu;&epsilon; &tau;&omicron; &pi;&omicron;&upsilon;ά &sigma;&tau;&eta; &mu;ό&delta;&alpha; &mu;&epsilon; &alpha;&upsilon;&tau;ό &tau;&omicron; &mu;&omicron;&nu;&tau;έ&lambda;&omicron; &upsilon;&psi;&eta;&lambda;ή&sigmaf; &pi;&omicron;&iota;ό&tau;&eta;&tau;&alpha;&sigmaf; &pi;&omicron;&upsilon; &delta;&epsilon;&nu; &theta;&alpha; &kappa;&upsilon;&lambda;ή&sigma;&epsilon;&iota; (&alpha;&nu; &pi;ά&rho;&epsilon;&tau;&epsilon; &tau;&omicron; &sigma;&omega;&sigma;&tau;ό &mu;έ&gamma;&epsilon;&theta;&omicron;&sigmaf;).<br /><br />&Lambda;&alpha;&tau;&rho;&epsilon;ύ&omicron;&upsilon;&mu;&epsilon; &tau;&eta;&nu; &alpha;&nu;&tau;ί&theta;&epsilon;&sigma;&eta; &alpha;&nu;ά&mu;&epsilon;&sigma;&alpha; &sigma;&tau;&eta;&nu; &alpha;ί&gamma;&lambda;&eta; &tau;&omicron;&upsilon; &mu;&omicron;&tau;ί&beta;&omicron;&upsilon; &kappa;&alpha;&iota; &tau;&eta; &mu;&omicron;&nu;&tau;έ&rho;&nu;&alpha; &epsilon;&mu;&phi;ά&nu;&iota;&sigma;&eta; &tau;&eta;&sigmaf; &zeta;ώ&nu;&eta;&sigmaf;.
guid
stringhttps://dev.divasboudoir.com/el/kaltses-megalo-megethos-allie-kixies-mayro/slst0809.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringΚομψότητα και γοητεία σε αυτές τις κάλτσες plus-size, με μια μοντέρνα πινελιά.
keywords
string
title
stringΚάλτσες μεγάλο μέγεθος Allie
seotitle
stringΚάλτσες μεγάλο μέγεθος Allie
seouri
stringkaltses-megalo-megethos-allie-kixies-mayro
specifications
string
stylingtips
string
summary
string&Kappa;&omicron;&mu;&psi;ό&tau;&eta;&tau;&alpha; &kappa;&alpha;&iota; &gamma;&omicron;&eta;&tau;&epsilon;ί&alpha; &sigma;&epsilon; &alpha;&upsilon;&tau;έ&sigmaf; &tau;&iota;&sigmaf; &kappa;ά&lambda;&tau;&sigma;&epsilon;&sigmaf; plus-size, &mu;&epsilon; &mu;&iota;&alpha; &mu;&omicron;&nu;&tau;έ&rho;&nu;&alpha; &pi;&iota;&nu;&epsilon;&lambda;&iota;ά.
title
stringAllie hold ups
usageinstructions
string
en
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringAllie hold-ups<br /><br />We're bringing polka dots back into fashion with this high-quality model that won't roll (if you get the right size).<br /><br />We love the contrast between the glamour of the pattern and the modernity of the band.
guid
stringhttps://dev.divasboudoir.com/en/stockings-plus-size-autofixants-allie-kixies-black/slst0809.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringElegance and glamour in these plus size stockings, with a modern twist.
keywords
string
title
stringStockings plus size Autofixants Allie
seotitle
stringStockings plus size Autofixants Allie
seouri
stringstockings-plus-size-autofixants-allie-kixies-black
specifications
string
stylingtips
string
summary
stringElegance and glamour in these plus size stockings, with a modern twist.
title
stringAllie hold ups
usageinstructions
string
es
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringPolainas Allie<br /><br />Volvemos a poner de moda los lunares con este modelo de alta calidad que no se enrolla (si coges la talla adecuada).<br /><br />Nos encanta el contraste entre el glamour del estampado y la modernidad de la banda.
guid
stringhttps://dev.divasboudoir.com/es/medias-talla-grande-allie-kixies-negro/slst0809.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringElegancia y glamour en estas medias de talla grande, con un toque moderno.
keywords
string
title
stringMedias talla grande Allie
seotitle
stringMedias talla grande Allie
seouri
stringmedias-talla-grande-allie-kixies-negro
specifications
string
stylingtips
string
summary
stringElegancia y glamour en estas medias de talla grande, con un toque moderno.
title
stringAllie atraca
usageinstructions
string
fr
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>Bas autofixants Allie<br><br>On remet les petits pois au go&ucirc;t du jour avec ce mod&egrave;le de tr&egrave;s belle qualit&eacute; et qui ne roulera pas (si vous le prenez &agrave; la bonne taille).<br><br>On aime beaucoup le contraste entre le glamour des motifs et la modernit&eacute; de la bande.</p>
guid
stringhttps://dev.divasboudoir.com/fr/bas-grande-taille-autofixants-allie-kixies-noir/slst0809.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringElegance et glamour dans ces bas grande taille, avec une touche de modernité.
keywords
string
title
stringBas grande taille Autofixants Allie
seotitle
stringBas grande taille Autofixants Allie
seouri
stringbas-grande-taille-autofixants-allie-kixies-noir
specifications
string
stylingtips
string
summary
string<p>Elegance et glamour dans ces bas grande taille, avec une touche de modernit&eacute;.</p>
title
stringBas Autofixants Allie
usageinstructions
string
it
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringCalze autoreggenti Allie<br /><br />Riportiamo in auge i pois con questo modello di alta qualit&agrave; che non si arrotola (se si prende la taglia giusta).<br /><br />Ci piace il contrasto tra il glamour del motivo e la modernit&agrave; della fascia.
guid
stringhttps://dev.divasboudoir.com/it/calzetteria-taglia-grande-allie-kixies-nero/slst0809.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringEleganza e glamour in queste calze taglia grande, con un tocco moderno.
keywords
string
title
stringCalzetteria taglia grande Allie
seotitle
stringCalzetteria taglia grande Allie
seouri
stringcalzetteria-taglia-grande-allie-kixies-nero
specifications
string
stylingtips
string
summary
stringEleganza e glamour in queste calze taglia grande, con un tocco moderno.
title
stringAllie hold up
usageinstructions
string
nl
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringAllie hold-ups<br /><br />We brengen polkadots terug in de mode met dit hoogwaardige model dat niet gaat rollen (als je de juiste maat hebt).<br /><br />We houden van het contrast tussen de glamour van het patroon en de moderniteit van de band.
guid
stringhttps://dev.divasboudoir.com/nl/kousen-groote-maat-allie-kixies-zwart/slst0809.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringElegantie en glamour in deze kousen van groote maat, met een moderne twist.
keywords
string
title
stringKousen groote maat Allie
seotitle
stringKousen groote maat Allie
seouri
stringkousen-groote-maat-allie-kixies-zwart
specifications
string
stylingtips
string
summary
stringElegantie en glamour in deze kousen van groote maat, met een moderne twist.
title
stringAllie hold-ups
usageinstructions
string
pt
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringAl&ccedil;as Allie<br /><br />Estamos a trazer as bolinhas de volta &agrave; moda com este modelo de alta qualidade que n&atilde;o se enrola (se comprar o tamanho certo).<br /><br />Adoramos o contraste entre o glamour do padr&atilde;o e a modernidade da banda.
guid
stringhttps://dev.divasboudoir.com/pt/meias-de-tamanho-grande-allie-kixies-preto/slst0809.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringElegância e glamour nestas meias de tamanho grande, com um toque moderno.
keywords
string
title
stringMeias de tamanho grande Allie
seotitle
stringMeias de tamanho grande Allie
seouri
stringmeias-de-tamanho-grande-allie-kixies-preto
specifications
string
stylingtips
string
summary
stringEleg&acirc;ncia e glamour nestas meias de tamanho grande, com um toque moderno.
title
stringAgarrões Allie
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-kixies-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
latexboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
legsboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Machen Sie eine Zeitreise mit diesen selbstfixierenden Strümpfen mit Pünktchenmuster von Kix'ies, die vom glamourösen Stil der 40er Jahre inspiriert sind. Das zeitlose Pünktchenmuster verleiht Ihrem Outfit einen Hauch von Fantasie und Eleganz.</p> <p><strong>Warum Sie sie lieben werden</strong>:</p> <ul> <li><strong>Retro-Charme</strong>: Das gepunktete Muster erinnert an die Eleganz der 40er Jahre.</li> <li>Tadelloser<strong>Halt</strong>: Der Kix'ies-Klettverschluss sorgt den ganzen Tag lang für einen perfekten Sitz, ohne zu verrutschen.</li> <li>Hoher<strong>Tragekomfort</strong>: Das weiche Material und die sorgfältige Verarbeitung sorgen dafür, dass Sie sich wie eine zweite Haut fühlen.</li> <li><strong> Große Größen</strong>: Entwickelt, um alle Figurtypen bis hin zu großen Größen zu betonen.</li> </ul> <p>Diese Strümpfe sind perfekt für einen Retro-Look oder um Ihrem Alltag einen Hauch von Originalität zu verleihen und werden schnell zu Ihren charmanten Verbündeten. Betonen Sie Ihre Weiblichkeit mit zeitloser Eleganz!</p> <p>Größenberater: Messen Sie zuerst Ihre Höhe und dann den Umfang Ihres Oberschenkels. Das Gewicht ist für die Wahl der idealen Größe nicht ausschlaggebend.</p>
highlights
string
keypoint
string
keywords
stringselbstfixierende Strümpfe, Punkte, Kixies, große Größen, Dessous, Retro, 40er Jahre, Eleganz, Komfort, Beine, Halt, Anti-Rutsch, Legs Boudoir
metas
Struct
description
stringVerleihen Sie sich einen Retro-Chic-Look mit unseren selbstfixierenden Strümpfen mit Punkten von Kix'ies. Komfort, Eleganz und perfekter Halt. Erhältlich in großen Größen auf Legs Boudoir.
keywords
stringselbstfixierende Strümpfe, Punkte, Kixies, große Größen, Dessous, Retro, 40er Jahre, Eleganz, Komfort, Beine, Halt, Anti-Rutsch, Legs Boudoir
title
stringSelbstfixierende Strümpfe mit Pois Kix'ies Große Größe | Legs Boudoir
seotitle
stringselbstfixierende Strümpfe mit Punkten Kixies große Größe
seouri
stringselbstfixierende-strumpfe-mit-punkten-kixies-grosse-grosse-kixies-schwarz
specifications
string
stylingtips
string
summary
string<p>Retro-Charme: Selbstfixierende Strümpfe mit Punkten von Kix'ies, zeitlose Eleganz und unübertroffener Halt für unwiderstehliche Beine. Erhältlich in großen Größen.</p>
title
stringRetro-Charme: Kix'ies Selbstfesselnde Strümpfe mit Punkten, Eleganz und Halt ohnegleichen
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Ταξιδέψτε πίσω στο χρόνο με αυτά τα πουά hold-ups της Kix'ies, εμπνευσμένα από το λαμπερό στυλ της δεκαετίας του '40. Το διαχρονικό πουά μοτίβο τους θα προσθέσει μια πινελιά φαντασίας και κομψότητας στο ντύσιμό σας.</p> <p><strong>Γιατί θα τα λατρέψετε</strong>:</p> <ul> <li><strong>Ρετρό γοητεία</strong>: Το πουά μοτίβο θυμίζει την κομψότητα της δεκαετίας του '40.</li> <li><strong>Άψογη στήριξη</strong>: Η ζώνη λαβής Kix'ies εξασφαλίζει τέλεια στήριξη όλη την ημέρα, χωρίς να γλιστράει.</li> <li><strong>Βέλτιστη άνεση</strong>: Το μαλακό ύφασμα και ο σχολαστικός σχεδιασμός σας χαρίζουν μια αίσθηση δεύτερου δέρματος.</li> <li><strong> Μεγάλα μεγέθη</strong>: Σχεδιασμένο για να αναδεικνύει κάθε σιλουέτα, μέχρι και τα plus sizes.</li> </ul> <p>Ιδανικές για μια ρετρό εμφάνιση ή για να προσθέσετε μια πινελιά πρωτοτυπίας στην καθημερινότητά σας, αυτές οι κάλτσες θα γίνουν γρήγορα οι γοητευτικοί σύμμαχοί σας. Επιβεβαιώστε τη θηλυκότητά σας με διαχρονική κομψότητα!</p> <p>Οδηγός μεγέθους: Πρώτα μετρήστε το ύψος σας και στη συνέχεια την περιφέρεια του μηρού σας. Το βάρος δεν αποτελεί καθοριστικό παράγοντα για την επιλογή του ιδανικού μεγέθους.</p>
highlights
string
keypoint
string
keywords
stringhold ups, πουά, kixies, plus size, εσώρουχα, ρετρό, 40s, κομψότητα, άνεση, πόδια, υποστήριξη, αντιολισθητική, Legs Boudoir
metas
Struct
description
stringΥιοθετήστε μια ρετρό-σικ εμφάνιση με τα πουά hold-ups Kix'ies. Άνεση, κομψότητα και τέλεια στήριξη, διαθέσιμα σε μεγάλα μεγέθη από το Legs Boudoir.
keywords
stringhold ups, πουά, kixies, plus size, εσώρουχα, ρετρό, 40s, κομψότητα, άνεση, πόδια, υποστήριξη, αντιολισθητική, Legs Boudoir
title
stringKix'ies Stay-up Pois Grande Taille | Legs Boudoir
seotitle
stringπουά κρατάει ups kixies μεγάλο
seouri
stringpoya-krataei-ups-kixies-megalo-kixies-mayro
specifications
string
stylingtips
string
summary
string<p>Ρετρό γοητεία: Τα πουά hold-ups της Kix'ies, διαχρονική κομψότητα και ασυναγώνιστη υποστήριξη για ακαταμάχητα πόδια. Διατίθενται σε μεγάλα μεγέθη.</p>
title
stringΡετρό γοητεία: Τα πουά hold ups της Kix'ies, απαράμιλλη κομψότητα και υποστήριξη
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Travel back in time with these Kix'ies polka-dot hold-ups, inspired by the glamorous style of the '40s. Their timeless polka dot pattern will bring a touch of whimsy and elegance to your outfit.</p> <p><strong>Why you'll love them</strong> </p> <ul> <li><strong>Retro charm</strong>: The polka dot pattern evokes the elegance of the '40s.</li> <li><strong>Impeccable support</strong>: The Kix'ies grip band ensures perfect support all day long, without slipping.</li> <li><strong>Optimal comfort</strong>: The soft fabric and meticulous design give you a second-skin feel.</li> <li><strong> Plus size</strong>: Designed to enhance every figure, up to plus size.</li> </ul> <p>Perfect for an assertive retro look or to bring a touch of originality to your everyday life, these stockings will quickly become your charming allies. Assert your femininity with timeless elegance!</p> <p>Size guide: First measure your height, then your thigh circumference. Weight is not a determining factor in choosing the right size.</p>
highlights
string
keypoint
string
keywords
stringhold ups, polka dots, kixies, plus size, lingerie, retro, 40's, elegance, comfort, legs, support, anti-slip, Legs Boudoir
metas
Struct
description
stringAdopt a retro-chic look with our Kix'ies polka-dot hold-ups. Comfort, elegance and perfect support, available in plus size at Legs Boudoir.
keywords
stringhold ups, polka dots, kixies, plus size, lingerie, retro, 40's, elegance, comfort, legs, support, anti-slip, Legs Boudoir
title
stringKix'ies Pea Stay-up Plus Size | Legs Boudoir
seotitle
stringkixies polka dot hold ups plus size
seouri
stringkixies-polka-dot-hold-ups-plus-size-kixies-black
specifications
string
stylingtips
string
summary
string<p>Retro charm: Kix'ies polka-dot hold-ups, timeless elegance and unrivalled support for irresistible legs. Available in plus size.</p>
title
stringRetro charm: Kix'ies polka dot hold ups, unrivalled elegance and support
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Viaja en el tiempo con estos pendientes de lunares Kix'ies, inspirados en el glamuroso estilo de los años 40. Su atemporal estampado de lunares añadirá un toque de fantasía y elegancia a tu atuendo. Su atemporal estampado de lunares aportará un toque de fantasía y elegancia a tu atuendo.</p> <p><strong>Te encantarán</strong>:</p> <ul> <li><strong>Encanto retro</strong>: el estampado de lunares evoca la elegancia de los años 40.</li> <li><strong>Sujeción impecable</strong>: La banda de sujeción Kix'ies garantiza una sujeción perfecta durante todo el día, sin resbalar.</li> <li><strong>Comodidad óptima</strong>: El suave tejido y el cuidado diseño le proporcionan una sensación de segunda piel.</li> <li><strong> Tallas grandes</strong>: Diseñados para realzar todas las figuras, hasta las tallas grandes.</li> </ul> <p>Perfectas para un look retro o para añadir un toque de originalidad a su día a día, estas medias se convertirán rápidamente en sus aliadas encantadoras. ¡Afirme su feminidad con una elegancia atemporal!</p> <p>Guía de tallas: Mida primero su estatura y después la circunferencia del muslo. El peso no es determinante para elegir la talla ideal.</p>
highlights
string
keypoint
string
keywords
stringmedias, lunares, kixies, talla grande, lencería, retro, años 40, elegancia, comodidad, piernas, sujeción, antideslizante, Legs Boudoir
metas
Struct
description
stringAdopta un look retro-chic con nuestras medias Kix'ies de lunares. Comodidad, elegancia y sujeción perfecta, disponibles en talla grande en Legs Boudoir.
keywords
stringmedias, lunares, kixies, talla grande, lencería, retro, años 40, elegancia, comodidad, piernas, sujeción, antideslizante, Legs Boudoir
title
stringKix'ies Stay-up Pois Talla grande | Legs Boudoir
seotitle
stringpolka dot hold ups kixies talla grande
seouri
stringpolka-dot-hold-ups-kixies-talla-grande-kixies-negro
specifications
string
stylingtips
string
summary
string<p>Encanto retro: Kix'ies polka dot hold-ups, elegancia atemporal y sujeción insuperable para unas piernas irresistibles. Disponibles en talla grande.</p>
title
stringEncanto retro: Kix'ies polka dot hold ups, elegancia y sujeción sin igual
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Voyagez dans le temps avec ces bas autofixants &agrave; pois Kix'ies, inspir&eacute;s du style glamour des ann&eacute;es 40. Leur motif &agrave; pois intemporel apportera une touche de fantaisie et d'&eacute;l&eacute;gance &agrave; votre tenue.</p> <p><strong>Pourquoi vous allez les adorer</strong> :</p> <ul> <li><strong>Charme r&eacute;tro</strong> : Le motif &agrave; pois &eacute;voque l'&eacute;l&eacute;gance des ann&eacute;es 40.</li> <li><strong>Maintien impeccable</strong> : La bande agrippante Kix'ies assure un maintien parfait tout au long de la journ&eacute;e, sans glisser.</li> <li><strong>Confort optimal</strong> : La mati&egrave;re douce et la conception soign&eacute;e vous offrent une sensation seconde peau.</li> <li><strong> Grande taille</strong> : Con&ccedil;us pour sublimer toutes les silhouettes, jusqu'&agrave; la grande taille.</li> </ul> <p>Parfaits pour un look r&eacute;tro assum&eacute; ou pour apporter une touche d'originalit&eacute; &agrave; votre quotidien, ces bas deviendront vite vos alli&eacute;s charme. Affirmez votre f&eacute;minit&eacute; avec une &eacute;l&eacute;gance intemporelle !</p> <p>Guide des tailles : Mesurez d'abord votre hauteur, puis la circonf&eacute;rence de votre cuisse. Le poids n'est pas un facteur d&eacute;terminant pour choisir la taille id&eacute;ale.</p>
highlights
string
keypoint
string
keywords
stringbas autofixants, pois, kixies, grande taille, lingerie, rétro, années 40, élégance, confort, jambes, maintien, anti-glisse, Legs Boudoir
metas
Struct
description
stringAdoptez un look rétro-chic avec nos bas autofixants à pois Kix'ies. Confort, élégance et maintien parfait, disponibles en grande taille sur Legs Boudoir.
keywords
stringbas autofixants, pois, kixies, grande taille, lingerie, rétro, années 40, élégance, confort, jambes, maintien, anti-glisse, Legs Boudoir
title
stringBas Autofixants Pois Kix'ies Grande Taille | Legs Boudoir
seotitle
stringbas autofixants pois kixies grande taille
seouri
stringbas-autofixants-pois-kixies-grande-taille-kixies-noir
specifications
string
stylingtips
string
summary
string<p>Charme r&eacute;tro : bas autofixants &agrave; pois Kix'ies, une &eacute;l&eacute;gance intemporelle et un maintien in&eacute;gal&eacute; pour des jambes irr&eacute;sistibles. Disponibles en grande taille.</p>
title
stringCharme Rétro : Bas Autofixants à Pois Kix'ies, Élégance et Maintien Inégalés
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Viaggiate indietro nel tempo con queste autoreggenti a pois di Kix'ies, ispirate allo stile glamour degli anni '40. Il loro intramontabile motivo a pois aggiungerà un tocco di fantasia ed eleganza al vostro abbigliamento. Il loro intramontabile motivo a pois aggiungerà un tocco di fantasia ed eleganza al vostro abbigliamento.</p> <p><strong>Perché vi piaceranno</strong>:</p> <ul> <li><strong>Fascino retrò</strong>: il motivo a pois evoca l'eleganza degli anni '40.</li> <li><strong>Sostegno impeccabile</strong>: la fascia Kix'ies grip garantisce un sostegno perfetto per tutto il giorno, senza scivolare.</li> <li><strong>Comfort ottimale</strong>: il tessuto morbido e il design accurato regalano una sensazione di seconda pelle.</li> <li><strong> Taglie grandi</strong>: Progettate per valorizzare ogni figura, fino alle taglie forti.</li> </ul> <p>Perfette per un look retrò o per aggiungere un tocco di originalità alla vostra vita quotidiana, queste calze diventeranno rapidamente le vostre affascinanti alleate. Affermate la vostra femminilità con un'eleganza senza tempo!</p> <p>Guida alle taglie: misurate prima la vostra altezza, poi la circonferenza della coscia. Il peso non è un fattore determinante nella scelta della taglia ideale.</p>
highlights
string
keypoint
string
keywords
stringautoreggenti, pois, kixies, taglia grande, lingerie, retrò, anni '40, eleganza, comfort, gambe, sostegno, antiscivolo, Legs Boudoir
metas
Struct
description
stringAdottate un look retro-chic con le nostre autoreggenti a pois Kix'ies. Comfort, eleganza e sostegno perfetto, disponibili in taglia grande da Legs Boudoir.
keywords
stringautoreggenti, pois, kixies, taglia grande, lingerie, retrò, anni '40, eleganza, comfort, gambe, sostegno, antiscivolo, Legs Boudoir
title
stringKix'ies Stay-up Pois Taglia Grande | Gambe Boudoir
seotitle
stringkixies hold up a pois di taglia grande
seouri
stringkixies-hold-up-a-pois-di-taglia-grande-kixies-nero
specifications
string
stylingtips
string
summary
string<p>Fascino retrò: le calze autoreggenti a pois di Kix'ies, eleganza senza tempo e sostegno imbattibile per gambe irresistibili. Disponibile in taglia grande.</p>
title
stringFascino retrò: le autoreggenti a pois di Kix'ies, eleganza e sostegno senza pari
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Reis terug in de tijd met deze Kix'ies polka dot hold-ups, geïnspireerd op de glamoureuze stijl van de jaren '40. Het tijdloze stippenpatroon voegt een vleugje fantasie en elegantie toe aan je outfit.</p> <p><strong>Waarom je ze leuk zult vinden</strong>:</p> <ul> <li><strong>Retro charme</strong>: Het stippenpatroon roept de elegantie van de jaren 40 op.</li> <li><strong>Onberispelijke ondersteuning</strong>: De gripband van Kix'ies zorgt de hele dag voor perfecte ondersteuning, zonder af te glijden.</li> <li><strong>Optimaal comfort</strong>: De zachte stof en het zorgvuldige ontwerp geven je een tweede-huid gevoel.</li> <li><strong> Grote maten</strong>: Ontworpen om elk figuur te verbeteren, tot en met grote maten.</li> </ul> <p>Perfect voor een retro look of om een vleugje originaliteit toe te voegen aan je dagelijkse leven, deze kousen zullen snel je charmante bondgenoten worden. Laat je vrouwelijkheid zien met tijdloze elegantie!</p> <p>Maattabel: Meet eerst je lengte, dan de omtrek van je dij. Gewicht is geen bepalende factor bij het kiezen van de ideale maat.</p>
highlights
string
keypoint
string
keywords
stringhold-ups, polka dots, kixies, grote maten, lingerie, retro, jaren 40, elegantie, comfort, benen, ondersteuning, antislip, Legs Boudoir
metas
Struct
description
stringKies voor een retro-chique look met onze Kix'ies polka dot hold-ups. Comfort, elegantie en perfecte ondersteuning, verkrijgbaar in grote maten bij Legs Boudoir.
keywords
stringhold-ups, polka dots, kixies, grote maten, lingerie, retro, jaren 40, elegantie, comfort, benen, ondersteuning, antislip, Legs Boudoir
title
stringKix'ies Stay-up Pois Grote Maat | Benen Boudoir
seotitle
stringpolka dot hold ups kixies grote maat
seouri
stringpolka-dot-hold-ups-kixies-grote-maat-kixies-zwart
specifications
string
stylingtips
string
summary
string<p>Retro charme: Kix'ies polka dot hold-ups, tijdloze elegantie en onovertroffen ondersteuning voor onweerstaanbare benen. Verkrijgbaar in grote maten.</p>
title
stringRetro charme: Kix'ies polka dot hold ups, ongeëvenaarde elegantie en ondersteuning
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Viaje no tempo com estas presilhas de bolinhas Kix'ies, inspiradas no estilo glamoroso dos anos 40. O seu padrão intemporal de bolinhas dará um toque de fantasia e elegância ao seu conjunto.</p> <p><strong>Porque é que as vai adorar</strong>:</p> <ul> <li><strong>Charme retro</strong>: O padrão de bolinhas evoca a elegância dos anos 40.</li> <li><strong>Apoio impecável</strong>: A banda de aderência Kix'ies garante um apoio perfeito durante todo o dia, sem escorregar.</li> <li><strong>Conforto ideal</strong>: O tecido macio e o design meticuloso proporcionam-lhe uma sensação de segunda pele.</li> <li><strong> Tamanhos grandes</strong>: Concebidos para valorizar todas as figuras, até aos tamanhos grandes.</li> </ul> <p>Perfeitas para um look retro ou para dar um toque de originalidade ao seu quotidiano, estas meias tornar-se-ão rapidamente suas aliadas de charme. Afirme a sua feminilidade com uma elegância intemporal!</p> <p>Guia de tamanhos: Meça primeiro a sua altura e depois a circunferência da coxa. O peso não é um fator determinante na escolha do tamanho ideal.</p>
highlights
string
keypoint
string
keywords
stringhold ups, bolinhas, kixies, plus size, lingerie, retro, anos 40, elegância, conforto, pernas, apoio, antiderrapante, Legs Boudoir
metas
Struct
description
stringAdopte um look retro-chique com as nossas meias de ligas de bolinhas Kix'ies. Conforto, elegância e apoio perfeito, disponíveis em tamanhos grandes na Legs Boudoir.
keywords
stringhold ups, bolinhas, kixies, plus size, lingerie, retro, anos 40, elegância, conforto, pernas, apoio, antiderrapante, Legs Boudoir
title
stringKix'ies Stay-up Pois Grande Taille | Legs Boudoir
seotitle
stringpolka dot hold ups kixies grande
seouri
stringpolka-dot-hold-ups-kixies-grande-kixies-preto
specifications
string
stylingtips
string
summary
string<p>Charme retro: as cuecas de bolinhas Kix'ies, elegância intemporal e apoio imbatível para umas pernas irresistíveis. Disponível em tamanhos grandes.</p>
title
stringCharme retro: os meias de bolinhas Kix'ies, elegância e apoio inigualáveis
usageinstructions
string
lustboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
smboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringStr&uuml;mpfe B&eacute;r&eacute;nice<br /><br />Wir bringen die Erbsen wieder in Mode mit diesem Modell von sehr sch&ouml;ner Qualit&auml;t, das nicht rollen wird (wenn Sie es in der richtigen Gr&ouml;&szlig;e nehmen).<br /><br />Wir m&ouml;gen den Kontrast zwischen dem glamour&ouml;sen Muster und dem modernen Band sehr.<br /><br />Sie sind ungebunden, k&ouml;nnen aber wie alle unsere Str&uuml;mpfe auch mit einem Strapsg&uuml;rtel getragen werden.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringEleganz und Glamour in diesen selbstfixierenden Strümpfen mit einem Hauch von Modernität.
keywords
string
title
stringNiedrige Berenice
seotitle
stringNiedrige Berenice
seouri
stringniedrige-berenice-kixies-schwarz
specifications
string
stylingtips
string
summary
stringEleganz und Glamour in diesen selbstfixierenden Str&uuml;mpfen mit einem Hauch von Modernit&auml;t.
title
stringNiedrige Berenice
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string&Kappa;ά&lambda;&tau;&sigma;&epsilon;&sigmaf; B&eacute;r&eacute;nice<br /><br />&Xi;&alpha;&nu;&alpha;&phi;έ&rho;&nu;&omicron;&upsilon;&mu;&epsilon; &tau;&omicron; &pi;&omicron;&upsilon;ά &sigma;&tau;&eta; &mu;ό&delta;&alpha; &mu;&epsilon; &alpha;&upsilon;&tau;ό &tau;&omicron; &pi;&omicron;&lambda;ύ &pi;&omicron;&iota;&omicron;&tau;&iota;&kappa;ό &mu;&omicron;&nu;&tau;έ&lambda;&omicron; &pi;&omicron;&upsilon; &delta;&epsilon;&nu; &theta;&alpha; &kappa;&upsilon;&lambda;ή&sigma;&epsilon;&iota; &pi;&rho;&omicron;&sigmaf; &tau;&alpha; &kappa;ά&tau;&omega; (&alpha;&nu; &tau;&omicron; &pi;ά&rho;&epsilon;&tau;&epsilon; &sigma;&tau;&omicron; &sigma;&omega;&sigma;&tau;ό &mu;έ&gamma;&epsilon;&theta;&omicron;&sigmaf;).<br /><br />&Mu;&alpha;&sigmaf; &alpha;&rho;έ&sigma;&epsilon;&iota; &eta; &alpha;&nu;&tau;ί&theta;&epsilon;&sigma;&eta; &alpha;&nu;ά&mu;&epsilon;&sigma;&alpha; &sigma;&tau;&eta;&nu; &alpha;ί&gamma;&lambda;&eta; &tau;&omicron;&upsilon; &mu;&omicron;&tau;ί&beta;&omicron;&upsilon; &kappa;&alpha;&iota; &tau;&eta; &mu;&omicron;&nu;&tau;έ&rho;&nu;&alpha; &epsilon;&mu;&phi;ά&nu;&iota;&sigma;&eta; &tau;&eta;&sigmaf; &zeta;ώ&nu;&eta;&sigmaf;.<br /><br />&Epsilon;ί&nu;&alpha;&iota; &sigma;&tau;&alpha;&theta;&epsilon;&rho;έ&sigmaf; &alpha;&lambda;&lambda;ά, ό&pi;&omega;&sigmaf; ό&lambda;&epsilon;&sigmaf; &omicron;&iota; &kappa;ά&lambda;&tau;&sigma;&epsilon;&sigmaf; &mu;&alpha;&sigmaf;, &mu;&pi;&omicron;&rho;&omicron;ύ&nu; &epsilon;&pi;ί&sigma;&eta;&sigmaf; &nu;&alpha; &phi;&omicron;&rho;&epsilon;&theta;&omicron;ύ&nu; &mu;&epsilon; &zeta;ώ&nu;&eta; &kappa;&alpha;&lambda;&tau;&sigma;&omicron;&delta;έ&tau;&alpha;&sigmaf;.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringΚομψότητα και γοητεία σε αυτά τα hold-ups, με ένα μοντέρνο twist.
keywords
string
title
stringBas Bérénice
seotitle
stringBas Bérénice
seouri
stringbas-berenice-kixies-mayro
specifications
string
stylingtips
string
summary
string&Kappa;&omicron;&mu;&psi;ό&tau;&eta;&tau;&alpha; &kappa;&alpha;&iota; &gamma;&omicron;&eta;&tau;&epsilon;ί&alpha; &sigma;&epsilon; &alpha;&upsilon;&tau;ά &tau;&alpha; hold-ups, &mu;&epsilon; έ&nu;&alpha; &mu;&omicron;&nu;&tau;έ&rho;&nu;&omicron; twist.
title
stringBas Bérénice
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringB&eacute;r&eacute;nice stockings<br /><br />We're bringing polka dots back into fashion with this high-quality model that won't roll down (if you take it in the right size).<br /><br />We love the contrast between the glamour of the pattern and the modernity of the band.<br /><br />They're aufixant, but like all our stockings, they can also be worn with a garter belt.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringElegance and glamour in these self-fastening stockings, with a modern twist.
keywords
string
title
stringBas Bérénice
seotitle
stringBas Bérénice
seouri
stringbas-berenice-kixies-black
specifications
string
stylingtips
string
summary
stringElegance and glamour in these self-fastening stockings, with a modern twist.
title
stringBas Bérénice
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringMedias B&eacute;r&eacute;nice<br /><br />Volvemos a poner de moda los lunares con este modelo de gran calidad que no se enrolla (si lo coges en la talla adecuada).<br /><br />Nos encanta el contraste entre el glamour del estampado y la modernidad de la banda.<br /><br />Son fijas pero, como todas nuestras medias, tambi&eacute;n se pueden llevar con liguero.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringElegancia y glamour en estos medias, con un toque moderno.
keywords
string
title
stringBas Bérénice
seotitle
stringBas Bérénice
seouri
stringbas-berenice-kixies-negro
specifications
string
stylingtips
string
summary
stringElegancia y glamour en estos medias, con un toque moderno.
title
stringBas Bérénice
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Bas B&eacute;r&eacute;nice<br><br>On remet les petits pois au go&ucirc;t du jour avec ce mod&egrave;le de tr&egrave;s belle qualit&eacute; et qui ne roulera pas (si vous le prenez &agrave; la bonne taille).<br><br>On aime beaucoup le contraste entre le glamour des motifs et la modernit&eacute; de la bande.<br><br>Ils sont aufixants mais, comme tous nos bas, ils peuvent &eacute;galement &ecirc;tre port&eacute;s avec un porte-jarretelles.</p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringElegance et glamour dans ces bas autofixants, avec une touche de modernité.
keywords
string
title
stringBas Bérénice
seotitle
stringBas Bérénice
seouri
stringbas-berenice-kixies-noir
specifications
string
stylingtips
string
summary
string<p>Elegance et glamour dans ces bas autofixants, avec une touche de modernit&eacute;.</p>
title
stringBas Bérénice
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringCalze B&eacute;r&eacute;nice<br /><br />Riportiamo di moda i pois con questo modello di altissima qualit&agrave; che non si arrotola (se lo prendete della misura giusta).<br /><br />Ci piace il contrasto tra il glamour del motivo e la modernit&agrave; della fascia.<br /><br />Sono fisse ma, come tutte le nostre calze, possono essere indossate anche con un reggicalze.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringEleganza e glamour in queste autoreggenti, con un tocco moderno.
keywords
string
title
stringBas Bérénice
seotitle
stringBas Bérénice
seouri
stringbas-berenice-kixies-nero
specifications
string
stylingtips
string
summary
stringEleganza e glamour in queste autoreggenti, con un tocco moderno.
title
stringBas Bérénice
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringB&eacute;r&eacute;nice kousen<br /><br />We brengen stippen weer terug in de mode met dit model van zeer hoge kwaliteit dat niet afrolt (als je het in de juiste maat neemt).<br /><br />We houden van het contrast tussen de glamour van het patroon en de moderniteit van de band.<br /><br />Ze zitten vast maar kunnen, net als al onze kousen, ook met een jarretelgordel gedragen worden.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringElegantie en glamour in deze hold-ups, met een moderne twist.
keywords
string
title
stringBas Bérénice
seotitle
stringBas Bérénice
seouri
stringbas-berenice-kixies-zwart
specifications
string
stylingtips
string
summary
stringElegantie en glamour in deze hold-ups, met een moderne twist.
title
stringBas Bérénice
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringMeias de ligas B&eacute;r&eacute;nice<br /><br />Trazemos de novo as bolinhas para a moda com este modelo de grande qualidade que n&atilde;o se enrola (se o comprar no tamanho certo).<br /><br />Adoramos o contraste entre o glamour do padr&atilde;o e a modernidade da banda.<br /><br />S&atilde;o fixas mas, como todas as nossas meias, tamb&eacute;m podem ser usadas com um cinto de ligas.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringElegância e glamour nestes hold-ups, com um toque moderno.
keywords
string
title
stringBas Bérénice
seotitle
stringBas Bérénice
seouri
stringbas-berenice-kixies-preto
specifications
string
stylingtips
string
summary
stringEleg&acirc;ncia e glamour nestes hold-ups, com um toque moderno.
title
stringBas Bérénice
usageinstructions
string
name
stringally
netweight
string
nextshipment
stringtomorrow
ordered
number4
orderidx
number0
origin
string
originalsize
string
packaging
string
productshipment
stringauto
productuid
stringA5EAA760-E93C-4923-BF5C51236229AF75
promountil
string
rating
stringnone
recorduid
stringA5EAA760-E93C-4923-BF5C51236229AF75
reference
stringSLST0809
related
string
reserved
string
returned
number0
returnsallowed
number1
section
stringlingerie
shipment
string3to5days
showbrand
number1
sizeinfos
Query
Template: /system/api/product/sizes.cfc:20
Execution Time: 1.31 ms
Record Count: 3
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,'1583,1584,1585,2109') > 0
and product_variations.productuid = 'A5EAA760-E93C-4923-BF5C51236229AF75'
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
115834-5intlsizeblack45-19999990wplusstockingB4-54-54-54-54-54-54-54-54-54-555-63
215846-7intlsizeblack67-19999990wplusstockingC6-76-76-76-76-76-76-76-76-76-763-76
315858-9intlsizeblack89-19999990wplusstockingD8-98-98-98-98-98-98-98-98-98-975-90
sizeranges
stringplus,standard
sizes
string1583,1584,1585,2109
sizetype
stringintlsize
specifications
Struct
Entries: 23
belly
string
bones
string
bra
string
breasts
string
bust
string
closing
string
crochtless
string
cups
string
cut
string
garter
string
halter
string
lacing
string
lining
string
modestypanel
string
panty
string
sheathing
string
sleeves
string
stocking
string
straps
string
stretch
string
suspenders
string
transparency
string
underwires
string
stock
number0
stocks
Query
Template: /system/api/product/stocks.cfc:25
Execution Time: 4.75 ms
Record Count: 3
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 = 'A5EAA760-E93C-4923-BF5C51236229AF75'
and product_variations.isactive = 1
and product_sizes.id_size = 1583
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 = 'A5EAA760-E93C-4923-BF5C51236229AF75'
and product_variations.isactive = 1
and product_sizes.id_size = 1584
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 = 'A5EAA760-E93C-4923-BF5C51236229AF75'
and product_variations.isactive = 1
and product_sizes.id_size = 1585
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 = 'A5EAA760-E93C-4923-BF5C51236229AF75'
and product_variations.isactive = 1
and product_sizes.id_size = 2109
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
1A5EAA760-E93C-4923-BF5C51236229AF75D6355318-E963-4F6A-AEB8AABD7EC0AE2E1583black#000000B4-54-54-54-54-54-54-54-54-54-5wstocking4-5intlsize20.79170STOCK01000-100001304-10all
2A5EAA760-E93C-4923-BF5C51236229AF7540546824-6AC9-40CE-BE5CE3470F90D20E1584black#000000C6-76-76-76-76-76-76-76-76-76-7wstocking6-7intlsize20.79170STOCK01000-101001304-10all
3A5EAA760-E93C-4923-BF5C51236229AF75C1EC941E-82F8-41BD-A22B1EFAB0CA02A71585black#000000D8-98-98-98-98-98-98-98-98-98-9wstocking8-9intlsize20.79170STOCK01000-103001304852531004152-10all
subcategory
stringstocking
supplier
number-1
supplierreference
stringALLY
tags
string
themes
stringbadgirl
totalvariations
string
type
stringdefault
unitprice
number20.7917
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 6.79 ms
Record Count: 3
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 = 'A5EAA760-E93C-4923-BF5C51236229AF75' 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 = 'A5EAA760-E93C-4923-BF5C51236229AF75' 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 = 'A5EAA760-E93C-4923-BF5C51236229AF75' 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 = 'A5EAA760-E93C-4923-BF5C51236229AF75' 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 = 'A5EAA760-E93C-4923-BF5C51236229AF75' 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 = 'A5EAA760-E93C-4923-BF5C51236229AF75' 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 = 'A5EAA760-E93C-4923-BF5C51236229AF75'
and product_variations.isactive = 1
and product_sizes.id_size = 1583
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 = 'A5EAA760-E93C-4923-BF5C51236229AF75' 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 = 'A5EAA760-E93C-4923-BF5C51236229AF75' 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 = 'A5EAA760-E93C-4923-BF5C51236229AF75' 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 = 'A5EAA760-E93C-4923-BF5C51236229AF75' 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 = 'A5EAA760-E93C-4923-BF5C51236229AF75' 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 = 'A5EAA760-E93C-4923-BF5C51236229AF75' 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 = 'A5EAA760-E93C-4923-BF5C51236229AF75'
and product_variations.isactive = 1
and product_sizes.id_size = 1584
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 = 'A5EAA760-E93C-4923-BF5C51236229AF75' 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 = 'A5EAA760-E93C-4923-BF5C51236229AF75' 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 = 'A5EAA760-E93C-4923-BF5C51236229AF75' 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 = 'A5EAA760-E93C-4923-BF5C51236229AF75' 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 = 'A5EAA760-E93C-4923-BF5C51236229AF75' 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 = 'A5EAA760-E93C-4923-BF5C51236229AF75' 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 = 'A5EAA760-E93C-4923-BF5C51236229AF75'
and product_variations.isactive = 1
and product_sizes.id_size = 1585
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 = 'A5EAA760-E93C-4923-BF5C51236229AF75' 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 = 'A5EAA760-E93C-4923-BF5C51236229AF75' 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 = 'A5EAA760-E93C-4923-BF5C51236229AF75' 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 = 'A5EAA760-E93C-4923-BF5C51236229AF75' 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 = 'A5EAA760-E93C-4923-BF5C51236229AF75' 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 = 'A5EAA760-E93C-4923-BF5C51236229AF75' 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 = 'A5EAA760-E93C-4923-BF5C51236229AF75'
and product_variations.isactive = 1
and product_sizes.id_size = 2109
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
1D6355318-E963-4F6A-AEB8AABD7EC0AE2E1583black#000000B4-54-54-54-54-54-54-54-54-54-5wstocking4-5intlsize20.79170STOCK01000-100001304-10-10-10020.7917all
240546824-6AC9-40CE-BE5CE3470F90D20E1584black#000000C6-76-76-76-76-76-76-76-76-76-7wstocking6-7intlsize20.79170STOCK01000-101001304-10-10-10020.7917all
3C1EC941E-82F8-41BD-A22B1EFAB0CA02A71585black#000000D8-98-98-98-98-98-98-98-98-98-9wstocking8-9intlsize20.79170STOCK01000-103001304852531004152-10-10-10020.7917all
vatrate
number20
warehouse
string