My cart

❌
Total items
View basket
Menu
See sizes
Gaëlle hold-ups
Double-click to enlarge
SKU: SLAU1555
Gaëlle hold-ups
Stock:

Cuban-style (line at the back) self-fastening plus size stockings that add a touch of originality and class to all your outfits.

Size:

Not sure which size to choose? See our size guide

Color:
Quantity:
24.95 €
Help and advice
by chat, facebook or e-mail
Free returns
within 15 days *

Gaëlle self-fixing plus size stockings

Product description

Out of the ordinary, these Gaëlle hold-ups can be worn every day or only on special occasions.

Flesh-colored, with a Cuban line that outlines and shapes the leg, they are reinforced at the feet.

The sturdy grip band is specially designed not to roll off (check your size). We love their innovative, modern design.

Technical details

Available sizes

Available from 4-5 to 8-9

Available color

Red

Sizing guide

Check the right size for you

International
  • Thigh
4-5
  • 55-63
6-7
  • 63-76
8-9
  • 75-90
To Top
View basket
Items
Total items
Struct
Entries: 108
actions
Array
available
number-1
brand
stringkixies
brandcode
stringkbvy
branding
stringdivasboudoir,legsboudoir
brandmedias
string{"default":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"editorial":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"logo":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""}}
brandmetas
Struct
de
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
el
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
en
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
es
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
fr
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
it
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
nl
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
pt
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
brandname
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.731 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,'red') > 0
and product_variations.productuid = '0A6143D0-4DC2-4780-982B0EE09FA08962'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1redcolorredredred#F50000-10
colorrange
stringred
colors
stringred
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 13:00:58'}
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
stringbas-whitney-1334
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-08-16 11:27:54'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.648 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','en')
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('0a6143d0-4dc2-4780-982b0ee09fa08962',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.29 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','en')
and product_categories.language in ('all','en')
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 <> 'SLAU1555'
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
string879
isprivate
string0
rating
stringall
src
string/photobank/products/kbvy/slau1555/bas-rouges-lignes-grande-taille.jpg
type
stringimg
width
string669
back
Struct
height
string1003
isprivate
string0
rating
stringall
src
string/photobank/products/kbvy/slau1555/bas_autofixants_gaelle_rouges_grande_taille_editorial.jpg
type
stringimg
width
string694
default
Struct
height
string551
isprivate
string0
rating
stringall
src
string/photobank/products/kbvy/slau1555/withney.jpg
type
stringimg
width
string388
variations
Struct
colors
Struct
red
Struct
height
string1270
isprivate
string0
rating
stringall
src
string/photobank/products/kbvy/slau1555/img_18162_900x.jpg
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-rot
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-kokkino
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-red
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-rojo
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-rouge
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-rosso
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-rood
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-vermelho
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
divasboudoir
Struct
de
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringDiese ungewöhnlichen, selbstfixierenden Strümpfe von Ga&euml;lle können jeden Tag oder nur zu besonderen Anlässen getragen werden.<br /><br />Die hautfarbenen Strümpfe sind mit einer kubanischen Linie verziert, die das Bein zeichnet und formt, und sind an den Füßen verstärkt.<br /><br />Der starke Klettverschluss wurde speziell entwickelt, damit er nicht wegrollt (überprüfen Sie Ihre Größe). Wir lieben das innovative und moderne Design.
guid
stringhttps://dev.divasboudoir.com/de/selbstfixierende-strumpfe-in-grosser-grosse-gaelle-kixies-rot/slau1555.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringSelbstfixierende Strümpfe in Übergröße im kubanischen Stil (Linie auf der Rückseite), die jedem Outfit einen Hauch von Originalität und Klasse verleihen werden.
keywords
string
title
stringSelbstfixierende Strümpfe in großer Größe Gaëlle
seotitle
stringSelbstfixierende Strümpfe in großer Größe Gaëlle
seouri
stringselbstfixierende-strumpfe-in-grosser-grosse-gaelle-kixies-rot
specifications
string
stylingtips
string
summary
stringSelbstfixierende Strümpfe in Übergröße im kubanischen Stil (Linie auf der Rückseite), die jedem Outfit einen Hauch von Originalität und Klasse verleihen werden.
title
stringSelbstfixierende Strümpfe Gaëlle
usageinstructions
string
el
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringΑυτά τα ασυνήθιστα Ga&euml;lle hold-ups μπορούν να φορεθούν καθημερινά ή μόνο για ειδικές περιστάσεις.<br /><br />Σαρκώδους χρώματος, με κουβανέζικη γραμμή που διαμορφώνει και περιγράφει το πόδι, είναι ενισχυμένα στα πέλματα.<br /><br />Ο εξαιρετικά ανθεκτικός ιμάντας Velcro είναι ειδικά σχεδιασμένος για να μην ξεκολλάει (ελέγξτε το μέγεθός σας). Μας αρέσει ο καινοτόμος, μοντέρνος σχεδιασμός.
guid
stringhttps://dev.divasboudoir.com/el/gaelle-megalo-megethos-hold-ups-kixies-kokkino/slau1555.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringΚουβανέζικα αυτοκόλλητα hold-ups για plus sizes (γραμμή στο πίσω μέρος), τα οποία θα προσθέσουν μια πινελιά πρωτοτυπίας και φινέτσας σε όλα σας τα ρούχα.
keywords
string
title
stringGaëlle μεγάλο μέγεθος hold ups
seotitle
stringGaëlle μεγάλο μέγεθος hold ups
seouri
stringgaelle-megalo-megethos-hold-ups-kixies-kokkino
specifications
string
stylingtips
string
summary
stringΚουβανέζικα αυτοκόλλητα hold-ups για plus sizes (γραμμή στο πίσω μέρος), τα οποία θα προσθέσουν μια πινελιά πρωτοτυπίας και φινέτσας σε όλα σας τα ρούχα.
title
stringGaëlle hold-ups
usageinstructions
string
en
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringOut of the ordinary, these Ga&euml;lle hold-ups can be worn every day or only on special occasions.<br /><br />Flesh-colored, with a Cuban line that outlines and shapes the leg, they are reinforced at the feet.<br /><br />The sturdy grip band is specially designed not to roll off (check your size). We love their innovative, modern design.
guid
stringhttps://dev.divasboudoir.com/en/gaelle-self-fixing-plus-size-stockings-kixies-red/slau1555.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringCuban-style (line at the back) self-fastening plus size stockings that add a touch of originality and class to all your outfits.
keywords
string
title
stringGaëlle self-fixing plus size stockings
seotitle
stringGaëlle self-fixing plus size stockings
seouri
stringgaelle-self-fixing-plus-size-stockings-kixies-red
specifications
string
stylingtips
string
summary
stringCuban-style (line at the back) self-fastening plus size stockings that add a touch of originality and class to all your outfits.
title
stringGaëlle hold-ups
usageinstructions
string
es
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringEstas originales bailarinas Ga&euml;lle pueden llevarse a diario o en ocasiones especiales.<br /><br />De color carne, con una línea cubana que moldea y contornea la pierna, están reforzadas en los pies.<br /><br />La tira de velcro extrafuerte está especialmente diseñada para que no se salga (comprueba tu talla). Nos encanta su diseño innovador y moderno.
guid
stringhttps://dev.divasboudoir.com/es/gaelle-talla-grande-medias-kixies-rojo/slau1555.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringMedias autoadherentes de estilo cubano para tallas grandes (línea en la espalda), que añadirán un toque de originalidad y clase a todos sus conjuntos.
keywords
string
title
stringGaëlle talla grande medias
seotitle
stringGaëlle talla grande medias
seouri
stringgaelle-talla-grande-medias-kixies-rojo
specifications
string
stylingtips
string
summary
stringMedias autoadherentes de estilo cubano para tallas grandes (línea en la espalda), que añadirán un toque de originalidad y clase a todos sus conjuntos.
title
stringGaëlle atracos
usageinstructions
string
fr
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringHors du comun, ces bas autofixants Ga&euml;lle peuvent &ecirc;tre port&eacute;s tous les jours ou uniquement lors d'occasions sp&eacute;ciales.<br /><br />Couleur chair, orn&eacute;s d'une ligne cubaine qui dessine et galbe la jambe, ils sont renforc&eacute;s aux pieds.<br /><br />La bande agrippante, tr&egrave;s solide, est sp&eacute;cialement con&ccedil;ue pour ne pas rouler (v&eacute;rifiez bien votre taille). On aime son design innovant et moderne.
guid
stringhttps://dev.divasboudoir.com/fr/bas-grande-taille-autofixants-gaelle-kixies-rouge/slau1555.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringSublimez votre silhouette avec les bas Gaëlle et leur ligne cubaine élégante. Confort, maintien parfait et design innovant à découvrir sur Legs Boudoir. Disponibles en toutes tailles.
keywords
string
title
stringBas Autofixants Gaëlle Couleur chair Ligne Cubaine | Legs Boudoir
seotitle
stringBas grande taille autofixants Gaëlle
seouri
stringbas-grande-taille-autofixants-gaelle-kixies-rouge
specifications
string
stylingtips
string
summary
stringDes bas grande taille autofixants au style cubain (ligne &agrave; l'arri&egrave;re), qui sauront mettre une touche d'originalit&eacute; et de classe dans toutes vos tenues.
title
stringBas autofixants Gaëlle
usageinstructions
string
it
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringQueste insolite autoreggenti Ga&euml;lle possono essere indossate tutti i giorni o solo per le occasioni speciali.<br /><br />Color carne, con una linea cubana che modella e modella la gamba, sono rinforzate ai piedi.<br /><br />Il cinturino in velcro extra-forte è stato appositamente studiato per non scivolare via (controllate la vostra taglia). Ci piace il design innovativo e moderno.
guid
stringhttps://dev.divasboudoir.com/it/gaelle-taglia-grande-autoreggente-kixies-rosso/slau1555.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringAutoreggenti cubane per taglie grandi (linea sul retro), che daranno un tocco di originalità e classe a tutti i vostri outfit.
keywords
string
title
stringGaëlle taglia grande autoreggente
seotitle
stringGaëlle taglia grande autoreggente
seouri
stringgaelle-taglia-grande-autoreggente-kixies-rosso
specifications
string
stylingtips
string
summary
stringAutoreggenti cubane per taglie grandi (linea sul retro), che daranno un tocco di originalità e classe a tutti i vostri outfit.
title
stringGaëlle autoreggenti
usageinstructions
string
nl
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringDeze bijzondere hold-ups van Ga&euml;lle kunnen elke dag gedragen worden of alleen voor speciale gelegenheden.<br /><br />Ze zijn vleeskleurig, hebben een Cubaanse lijn die het been vormt en zijn verstevigd bij de voeten.<br /><br />De extra sterke klittenband is speciaal ontworpen om niet af te rollen (controleer je maat). Wij houden van het innovatieve, moderne ontwerp.
guid
stringhttps://dev.divasboudoir.com/nl/gaelle-groote-maat-hold-ups-kixies-rood/slau1555.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringCubaanse hold-ups met zelfsluiting voor groote maten (lijn op de rug), die een vleugje originaliteit en klasse toevoegen aan al je outfits.
keywords
string
title
stringGaëlle groote maat hold ups
seotitle
stringGaëlle groote maat hold ups
seouri
stringgaelle-groote-maat-hold-ups-kixies-rood
specifications
string
stylingtips
string
summary
stringCubaanse hold-ups met zelfsluiting voor groote maten (lijn op de rug), die een vleugje originaliteit en klasse toevoegen aan al je outfits.
title
stringGaëlle hold-ups
usageinstructions
string
pt
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringEstas invulgares calças Ga&euml;lle podem ser usadas todos os dias ou apenas em ocasiões especiais.<br /><br />Cor de carne, com uma linha cubana que modela e contorna a perna, são reforçadas nos pés.<br /><br />A tira de velcro extra-forte foi especialmente concebida para não se soltar (verifique o seu tamanho). Adoramos o design inovador e moderno.
guid
stringhttps://dev.divasboudoir.com/pt/gaelle-tamanho-grande-kixies-vermelho/slau1555.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringAs presilhas de fecho automático de estilo cubano para tamanhos grandes (linha atrás), que darão um toque de originalidade e de classe a todos os seus conjuntos.
keywords
string
title
stringGaëlle tamanho grande
seotitle
stringGaëlle tamanho grande
seouri
stringgaelle-tamanho-grande-kixies-vermelho
specifications
string
stylingtips
string
summary
stringAs presilhas de fecho automático de estilo cubano para tamanhos grandes (linha atrás), que darão um toque de originalidade e de classe a todos os seus conjuntos.
title
stringGaëlle hold-ups
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-rot
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-kokkino
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-red
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-rojo
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-rouge
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-rosso
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-rood
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-vermelho
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-rot
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-kokkino
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-red
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-rojo
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-rouge
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-rosso
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-rood
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-vermelho
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
legsboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>Diese selbstfixierenden Strümpfe von Ga&euml;lle sind wirklich außergewöhnlich. </span></p> <p><span>Sie können täglich oder nur zu besonderen Anlässen getragen werden und verleihen Ihrer Garderobe eine unvergleichliche Vielseitigkeit. </span></p> <p><span>Diese verführerischen hautfarbenen Strümpfe sind mit einer eleganten kubanischen Linie versehen, die sich sanft um Ihr Bein schmiegt und Ihre Silhouette anmutig formt. </span></p> <p><span>Die Fußverstärkung sorgt für einen dauerhaften und bequemen Halt, sodass Sie sich ganz entspannt Ihren Aufgaben widmen können. Der starke Klettverschluss ist so konzipiert, dass er nicht wegrollt und so Unbehagen verhindert. </span></p> <p><span>Sie werden von seinem innovativen und modernen Design begeistert sein, das eine Einladung zur Kultiviertheit darstellt.</span></p>
highlights
string
keypoint
string
keywords
stringselbstfixierende Strümpfe, hautfarben, kubanische Linie, alle Größen, Dessous, Damenstrümpfe, elegante Beine, Komfort, innovatives Design, Legs Boudoir
metas
Struct
description
stringGroße Strümpfe mit Silikonstreifen im kubanischen Stil (Linie auf der Rückseite), die all Ihren Kleidungsstücken einen Hauch von Originalität und Eleganz verleihen.
keywords
stringselbstfixierende Strümpfe, hautfarben, kubanische Linie, alle Größen, Dessous, Damenstrümpfe, elegante Beine, Komfort, innovatives Design, Legs Boudoir
title
stringSelbstfixierende Strümpfe in großer Größe Gaëlle - Perfekte Qualität
seotitle
stringStrümpfe in großen Größen Gaëlle
seouri
stringstrumpfe-in-grossen-grossen-gaelle-kixies-rot
specifications
string
stylingtips
string
summary
string<p><span>Große Strümpfe mit Silikonstreifen im kubanischen Stil (Linie auf der Rückseite), die all Ihren Kleidungsstücken einen Hauch von Originalität und Eleganz verleihen.</span></p>
title
stringBas Gaëlle
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>Αυτά τα hold ups της Ga&euml;lle είναι πραγματικά εξωπραγματικά. </span></p> <p><span>Μπορούν να φορεθούν καθημερινά ή μόνο για ειδικές περιστάσεις, προσφέροντας απαράμιλλη ευελιξία στην γκαρνταρόμπα σας. </span></p> <p><span>Σε ένα σαγηνευτικό σαρκικό χρώμα, αυτές οι κάλτσες διαθέτουν μια κομψή κουβανέζικη γραμμή που αγκαλιάζει απαλά το σχήμα του ποδιού σας, σμιλεύοντας τη σιλουέτα σας με χάρη. </span></p> <p><span>Τα ενισχυμένα πέλματα εξασφαλίζουν μια μακράς διάρκειας, άνετη εφαρμογή, ώστε να μπορείτε να κάνετε τις δουλειές σας με απόλυτη ψυχική ηρεμία. Η εξαιρετικά ισχυρή ζώνη πρόσφυσης έχει σχεδιαστεί ειδικά για να μην κυλάει, ώστε να μην αισθάνεστε καμία ενόχληση. </span></p> <p><span>Θα σας σαγηνεύσει ο καινοτόμος, μοντέρνος σχεδιασμός του, μια πραγματική πρόσκληση για εκλέπτυνση.</span></p>
highlights
string
keypoint
string
keywords
stringhold ups, χρώμα σάρκας, κουβανέζικη γραμμή, όλα τα μεγέθη, εσώρουχα, γυναικεία hold ups, κομψά πόδια, άνεση, καινοτόμος σχεδιασμός, Legs Boudoir
metas
Struct
description
stringΚάλτσες μεγάλων διαστάσεων με ταινίες σιλικόνης, σε στυλ Κουβανέζικου στυλ (γραμμή στο πίσω μέρος), που θα προσθέσουν μια πινελιά πρωτοτυπίας και κομψότητας σε όλα σας τα ρούχα.
keywords
stringhold ups, χρώμα σάρκας, κουβανέζικη γραμμή, όλα τα μεγέθη, εσώρουχα, γυναικεία hold ups, κομψά πόδια, άνεση, καινοτόμος σχεδιασμός, Legs Boudoir
title
stringGaëlle large size hold ups - Τέλεια ποιότητα
seotitle
stringΚάλτσες Gaëlle plus size
seouri
stringkaltses-gaelle-plus-size-kixies-kokkino
specifications
string
stylingtips
string
summary
string<p><span>Κάλτσες μεγάλων διαστάσεων με ταινίες σιλικόνης, σε στυλ Κουβανέζικου στυλ (γραμμή στο πίσω μέρος), που θα προσθέσουν μια πινελιά πρωτοτυπίας και κομψότητας σε όλα σας τα ρούχα.</span></p>
title
stringBas Gaëlle
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>These Ga&euml;lle hold-ups are truly out of this world. </span></p> <p><span>They can be worn every day or only on special occasions, offering unparalleled versatility to your wardrobe. </span></p> <p><span>In a seductive flesh-toned color, these stockings are embellished with an elegant Cuban line that delicately hugs the shape of your leg, sculpting your silhouette with grace. </span></p> <p><span>Reinforced feet ensure a long-lasting, comfortable fit, so you can go about your business with complete peace of mind. The remarkably strong grip band has been specially designed not to roll, preventing any discomfort. </span></p> <p><span>You'll be seduced by its innovative, modern design, a true invitation to sophistication.</span></p>
highlights
string
keypoint
string
keywords
stringhold ups, flesh color, cuban line, all sizes, lingerie, women's stockings, elegant legs, comfort, innovative design, Legs Boudoir
metas
Struct
description
stringPlus size stockings with silicone bands, Cuban style (line at the back), that will add a touch of originality and elegance to all your outfits.
keywords
stringhold ups, flesh color, cuban line, all sizes, lingerie, women's stockings, elegant legs, comfort, innovative design, Legs Boudoir
title
stringGaëlle plus size hold ups - Perfect quality
seotitle
stringGaëlle plus size stockings
seouri
stringgaelle-plus-size-stockings-kixies-red
specifications
string
stylingtips
string
summary
string<p><span>Plus size stockings with silicone bands, Cuban style (line at the back), that will add a touch of originality and elegance to all your outfits.</span></p>
title
stringBas Gaëlle
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>Estos pendientes Ga&euml;lle son realmente únicos. </span></p> <p><span>Se pueden llevar a diario o sólo para ocasiones especiales, ofreciendo una versatilidad sin igual a tu vestuario. </span></p> <p><span>En un seductor color carne, estas medias presentan una elegante línea cubana que abraza delicadamente la forma de tu pierna, esculpiendo tu silueta con gracia. </span></p> <p><span>Los pies reforzados garantizan un ajuste cómodo y duradero, para que pueda dedicarse a sus asuntos con total tranquilidad. La banda de sujeción, extraordinariamente resistente, ha sido especialmente diseñada para no enrollarse, por lo que no sentirás ninguna molestia. </span></p> <p><span>Le seducirá su diseño innovador y moderno, una auténtica invitación a la sofisticación.</span></p>
highlights
string
keypoint
string
keywords
stringmedias, color carne, línea cubana, todas las tallas, lencería, medias para mujer, piernas elegantes, comodidad, diseño innovador, Legs Boudoir
metas
Struct
description
stringMedias de talla grande con bandas de silicona, estilo cubano (línea en la parte posterior), que añadirán un toque de originalidad y elegancia a todos sus conjuntos.
keywords
stringmedias, color carne, línea cubana, todas las tallas, lencería, medias para mujer, piernas elegantes, comodidad, diseño innovador, Legs Boudoir
title
stringGaëlle talla grande - Calidad perfecta
seotitle
stringMedias de talla grande Gaëlle
seouri
stringmedias-de-talla-grande-gaelle-kixies-rojo
specifications
string
stylingtips
string
summary
string<p><span>Medias de talla grande con bandas de silicona, estilo cubano (línea en la parte posterior), que añadirán un toque de originalidad y elegancia a todos sus conjuntos.</span></p>
title
stringBas Gaëlle
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>Ces bas autofixants Ga&euml;lle sont v&eacute;ritablement hors du commun. </span></p> <p><span>Ils peuvent &ecirc;tre port&eacute;s tous les jours ou seulement lors d'occasions sp&eacute;ciales, offrant ainsi une versatilit&eacute; in&eacute;gal&eacute;e &agrave; votre garde-robe. </span></p> <p><span>D'une s&eacute;duisante couleur chair, ces bas sont agr&eacute;ment&eacute;s d'une &eacute;l&eacute;gante ligne cubaine qui &eacute;pouse d&eacute;licatement la forme de votre jambe, sculpant ainsi votre silhouette avec gr&acirc;ce. </span></p> <p><span>Leur renfort aux pieds assure un maintien durable et confortable, vous permettant de vaquer &agrave; vos occupations en toute tranquillit&eacute;. La bande agrippante, d'une solidit&eacute; remarquable, a &eacute;t&eacute; sp&eacute;cialement con&ccedil;ue pour ne pas rouler, &eacute;vitant ainsi tout inconfort. </span></p> <p><span>Vous serez s&eacute;duits par son design innovant et moderne, une v&eacute;ritable invitation &agrave; la sophistication.</span></p>
highlights
string
keypoint
string
keywords
stringbas autofixants, couleur chair, ligne cubaine, toutes tailles, lingerie, bas femme, jambes élégantes, confort, design innovant, Legs Boudoir
metas
Struct
description
stringDes bas de grande taille avec bandes de silicone, au style cubain (ligne à l'arrière), qui ajouteront une note d'originalité et d'élégance à tous vos vêtements.
keywords
stringbas autofixants, couleur chair, ligne cubaine, toutes tailles, lingerie, bas femme, jambes élégantes, confort, design innovant, Legs Boudoir
title
stringBas grande taille autofixants Gaëlle - Qualité parfaite
seotitle
stringbas autofixants gaelle couleur chair ligne cubaine
seouri
stringbas-autofixants-gaelle-couleur-chair-ligne-cubaine-kixies-rouge
specifications
string
stylingtips
string
summary
string<p><span>Des bas de grande taille avec bandes de silicone, au style cubain (ligne &agrave; l'arri&egrave;re), qui ajouteront une note d'originalit&eacute; et d'&eacute;l&eacute;gance &agrave; tous vos v&ecirc;tements.</span></p>
title
stringGaëlle : L'Élégance Absolue Qui Sublime Votre Silhouette
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>Queste Ga&euml;lle hold up sono davvero fuori dal mondo. </span></p> <p><span>Possono essere indossate tutti i giorni o solo per le occasioni speciali, offrendo una versatilità senza pari al vostro guardaroba. </span></p> <p><span>In un seducente color carne, queste calze presentano un'elegante linea cubana che abbraccia delicatamente la forma della gamba, scolpendo la silhouette con grazia. </span></p> <p><span>I piedini rinforzati assicurano una vestibilità comoda e duratura, per permettervi di svolgere le vostre attività in tutta tranquillità. La fascia di aderenza, straordinariamente resistente, è stata appositamente studiata per non arrotolarsi, in modo da non creare alcun disagio. </span></p> <p><span>Sarete sedotti dal suo design innovativo e moderno, un vero invito alla raffinatezza.</span></p>
highlights
string
keypoint
string
keywords
stringautoreggenti, color carne, linea cubana, tutte le taglie, lingerie, autoreggenti donna, gambe eleganti, comfort, design innovativo, Legs Boudoir
metas
Struct
description
stringCalze di taglia grande con bande in silicone, stile cubano (linea sul retro), che aggiungeranno un tocco di originalità ed eleganza a tutti i vostri outfit.
keywords
stringautoreggenti, color carne, linea cubana, tutte le taglie, lingerie, autoreggenti donna, gambe eleganti, comfort, design innovativo, Legs Boudoir
title
stringGaëlle taglia grande autoreggenti - Qualità perfetta
seotitle
stringCalze Gaëlle taglia grande
seouri
stringcalze-gaelle-taglia-grande-kixies-rosso
specifications
string
stylingtips
string
summary
string<p><span>Calze di taglia grande con bande in silicone, stile cubano (linea sul retro), che aggiungeranno un tocco di originalità ed eleganza a tutti i vostri outfit.</span></p>
title
stringBas Gaëlle
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>Deze hold-ups van Ga&euml;lle zijn echt niet van deze wereld. </span></p> <p><span>Ze kunnen elke dag gedragen worden of alleen voor speciale gelegenheden en bieden een ongeëvenaarde veelzijdigheid aan je garderobe. </span></p> <p><span>In een verleidelijke vleeskleur hebben deze kousen een elegante Cubaanse lijn die delicaat de vorm van je been omhelst en je silhouet met gratie vormgeeft. </span></p> <p><span>De verstevigde voetjes zorgen voor een langdurige, comfortabele pasvorm, zodat je met een gerust hart je gang kunt gaan. De opmerkelijk sterke gripband is speciaal ontworpen om niet te rollen, zodat je geen ongemak voelt. </span></p> <p><span>Je zult verleid worden door het innovatieve, moderne ontwerp, een echte uitnodiging tot verfijning.</span></p>
highlights
string
keypoint
string
keywords
stringhold ups, vleeskleur, cubaanse lijn, alle maten, lingerie, dames hold ups, elegante benen, comfort, innovatief ontwerp, Legs Boudoir
metas
Struct
description
stringGrote maten kousen met siliconen bandjes, Cubaanse stijl (lijn aan de achterkant), die een vleugje originaliteit en elegantie toevoegen aan al je outfits.
keywords
stringhold ups, vleeskleur, cubaanse lijn, alle maten, lingerie, dames hold ups, elegante benen, comfort, innovatief ontwerp, Legs Boudoir
title
stringGaëlle grote maat hold ups - Perfecte kwaliteit
seotitle
stringGaëlle groote maat hold ups
seouri
stringgaelle-groote-maat-hold-ups-kixies-rood
specifications
string
stylingtips
string
summary
string<p><span>Grote maten kousen met siliconen bandjes, Cubaanse stijl (lijn aan de achterkant), die een vleugje originaliteit en elegantie toevoegen aan al je outfits.</span></p>
title
stringGaëlle hold-ups
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>Estes hold ups Ga&euml;lle são verdadeiramente fora deste mundo. </span></p> <p><span>Podem ser usadas todos os dias ou apenas em ocasiões especiais, oferecendo uma versatilidade sem igual ao seu guarda-roupa. </span></p> <p><span>Numa sedutora cor de carne, estas meias apresentam uma elegante linha cubana que abraça delicadamente a forma da sua perna, esculpindo a sua silhueta com graça. </span></p> <p><span>Os pés reforçados asseguram um ajuste duradouro e confortável, para que possa fazer o seu trabalho com toda a tranquilidade. A banda de aderência extraordinariamente forte foi especialmente concebida para não enrolar, pelo que não sentirá qualquer desconforto. </span></p> <p><span>O seu design inovador e moderno seduzir-vos-á, um verdadeiro convite à sofisticação.</span></p>
highlights
string
keypoint
string
keywords
stringcintas de fixação, cor da pele, linha cubana, todos os tamanhos, lingerie, cintas de fixação para mulher, pernas elegantes, conforto, design inovador, Legs Boudoir
metas
Struct
description
stringMeias de tamanho grande com fitas de silicone, estilo cubano (linha na parte de trás), que darão um toque de originalidade e elegância a todos os seus conjuntos.
keywords
stringcintas de fixação, cor da pele, linha cubana, todos os tamanhos, lingerie, cintas de fixação para mulher, pernas elegantes, conforto, design inovador, Legs Boudoir
title
stringGaëlle - Tamanho grande - Qualidade perfeita
seotitle
stringMeias de liga Gaëlle plus size
seouri
stringmeias-de-liga-gaelle-plus-size-kixies-vermelho
specifications
string
stylingtips
string
summary
string<p><span>Meias de tamanho grande com fitas de silicone, estilo cubano (linha na parte de trás), que darão um toque de originalidade e elegância a todos os seus conjuntos.</span></p>
title
stringBas Gaëlle
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-rot
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-kokkino
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-red
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-rojo
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-rouge
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-rosso
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-rood
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-vermelho
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
smboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-rot
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-kokkino
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-red
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-rojo
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-rouge
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-rosso
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-rood
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-vermelho
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
name
stringbas whitney 1334
netweight
string
nextshipment
stringtomorrow
ordered
number19
orderidx
number0
origin
string
originalsize
string
packaging
string
productshipment
stringauto
productuid
string0A6143D0-4DC2-4780-982B0EE09FA08962
promountil
string
rating
stringnone
recorduid
string0A6143D0-4DC2-4780-982B0EE09FA08962
reference
stringSLAU1555
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.35 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 = '0A6143D0-4DC2-4780-982B0EE09FA08962'
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-5intlsizered45-19999990wplusstockingB4-54-54-54-54-54-54-54-54-54-555-63
215846-7intlsizered67-19999990wplusstockingC6-76-76-76-76-76-76-76-76-76-763-76
315858-9intlsizered89-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.82 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 = '0A6143D0-4DC2-4780-982B0EE09FA08962'
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 = '0A6143D0-4DC2-4780-982B0EE09FA08962'
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 = '0A6143D0-4DC2-4780-982B0EE09FA08962'
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 = '0A6143D0-4DC2-4780-982B0EE09FA08962'
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
10A6143D0-4DC2-4780-982B0EE09FA0896256C7755C-DF2A-421A-B9F4C814048797FD1583red#F50000B4-54-54-54-54-54-54-54-54-54-5wstocking4-5intlsize20.79170STOCK01000-126001334B-NUD850017512160-10all
20A6143D0-4DC2-4780-982B0EE09FA089628273DB8F-635B-4CC1-88424D2CC53BF9891584red#F50000C6-76-76-76-76-76-76-76-76-76-7wstocking6-7intlsize20.79170STOCK01000-118001334850017512177-10all
30A6143D0-4DC2-4780-982B0EE09FA08962DEF7B056-DB63-43FC-A8D35166DBE5A6531585red#F50000D8-98-98-98-98-98-98-98-98-98-9wstocking8-9intlsize20.79170STOCK01000-105001334850017512184-10all
subcategory
stringstocking
supplier
number-1
supplierreference
string1334
tags
string
themes
stringchristmas
totalvariations
string
type
stringdefault
unitprice
number20.7917
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 8.44 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 = '0A6143D0-4DC2-4780-982B0EE09FA08962' 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 = '0A6143D0-4DC2-4780-982B0EE09FA08962' 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 = '0A6143D0-4DC2-4780-982B0EE09FA08962' 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 = '0A6143D0-4DC2-4780-982B0EE09FA08962' 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 = '0A6143D0-4DC2-4780-982B0EE09FA08962' 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 = '0A6143D0-4DC2-4780-982B0EE09FA08962' 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 = '0A6143D0-4DC2-4780-982B0EE09FA08962'
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 = '0A6143D0-4DC2-4780-982B0EE09FA08962' 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 = '0A6143D0-4DC2-4780-982B0EE09FA08962' 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 = '0A6143D0-4DC2-4780-982B0EE09FA08962' 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 = '0A6143D0-4DC2-4780-982B0EE09FA08962' 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 = '0A6143D0-4DC2-4780-982B0EE09FA08962' 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 = '0A6143D0-4DC2-4780-982B0EE09FA08962' 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 = '0A6143D0-4DC2-4780-982B0EE09FA08962'
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 = '0A6143D0-4DC2-4780-982B0EE09FA08962' 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 = '0A6143D0-4DC2-4780-982B0EE09FA08962' 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 = '0A6143D0-4DC2-4780-982B0EE09FA08962' 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 = '0A6143D0-4DC2-4780-982B0EE09FA08962' 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 = '0A6143D0-4DC2-4780-982B0EE09FA08962' 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 = '0A6143D0-4DC2-4780-982B0EE09FA08962' 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 = '0A6143D0-4DC2-4780-982B0EE09FA08962'
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 = '0A6143D0-4DC2-4780-982B0EE09FA08962' 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 = '0A6143D0-4DC2-4780-982B0EE09FA08962' 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 = '0A6143D0-4DC2-4780-982B0EE09FA08962' 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 = '0A6143D0-4DC2-4780-982B0EE09FA08962' 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 = '0A6143D0-4DC2-4780-982B0EE09FA08962' 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 = '0A6143D0-4DC2-4780-982B0EE09FA08962' 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 = '0A6143D0-4DC2-4780-982B0EE09FA08962'
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
156C7755C-DF2A-421A-B9F4C814048797FD1583red#F50000B4-54-54-54-54-54-54-54-54-54-5wstocking4-5intlsize20.79170STOCK01000-126001334B-NUD850017512160-10-10-10020.7917all
28273DB8F-635B-4CC1-88424D2CC53BF9891584red#F50000C6-76-76-76-76-76-76-76-76-76-7wstocking6-7intlsize20.79170STOCK01000-118001334850017512177-10-10-10020.7917all
3DEF7B056-DB63-43FC-A8D35166DBE5A6531585red#F50000D8-98-98-98-98-98-98-98-98-98-9wstocking8-9intlsize20.79170STOCK01000-105001334850017512184-10-10-10020.7917all
vatrate
number20
warehouse
string