See sizes

Double-click to enlarge

SKU: SLAU7351

Kylie hold ups

Stock:

Shine ladies, shine with these plus size hold ups, and be unique.

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 *

Kylie plus size hold ups Autofixants

Name: Kylie plus size hold ups Autofixants - -1
Brand: Kixies
SKU: SLAU7351
Price: 24.95 EUR
Availability: InStock

Product description

Kylie hold-ups

High-quality, shiny, satin-finish mesh with a triple hook-and-loop fastening that won't roll off (be sure to check your size).

Technical details

Available sizes

Available from 4-5 to 8-9

Available color

Grey

Sizing guide

Check the right size for you

International	Thigh
4-5	55-63
6-7	63-76
8-9	75-90

To Top

Your location is:
United States of America

Your language is: English

Prices are in: EUR (€)

Save my preferences

Continue

Change my settings

Country Language

Save my preferences

Cancel

Struct
Entries: 108

actions

Array

available

number

-1

brand

string

kixies

brandcode

string

kbvy

branding

string

divasboudoir,smboudoir,legsboudoir

brandmedias

string

{"default":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"editorial":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"logo":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""}}

brandmetas

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

brandname

string

Kixies

breasts

string

careinstructions

string

category

string

hoisery

categorygender

string

categorymediadatas

Struct

adult

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

628

isprivate

string

rating

string

all

src

string

/photobank/categories/divasboudoir/lingerie/hoisery/stockings.jpg

type

string

img

width

string

1365

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

string

1016

isprivate

string

rating

string

all

src

string

/photobank/categories/divasboudoir/private/default.jpg

type

string

img

width

string

703

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

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

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

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

string

auto

colorinfos

Query Template: /system/api/product/colors.cfc:13 Execution Time: 0.698 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,'grey') > 0 and product_variations.productuid = '7E653324-77A5-42BA-89329B5B0C413627' group by product_colors.range,product_colors.color order by product_colors.range,product_colors.color
	recorduid	type	code	color	range	hexvalue	available	stock
1	grey	color	grey	grey	grey	#A9A9A9	-1	0

colorrange

string

grey

colors

string

grey

colortype

string

color

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 14:41:14'}

defect

number

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

string

wiresize

string

display

string

all

displayfrom

string

displayto

string

grossweight

string

hasbrandinfos

boolean

false

hascareinstructions

boolean

false

hascolorinfos

boolean

true

hascompositions

boolean

false

hasdescription

boolean

true

hasdimensions

boolean

false

hasmaterials

boolean

false

hasotherspecifications

boolean

false

haspromo

number

hasshortdescription

boolean

true

hassizeinfos

boolean

true

hasspecifications

boolean

false

hasstockinfos

boolean

false

hasstylingtips

boolean

false

hasusageinstructions

boolean

false

hasvariations

boolean

true

import

string

inpromo

number

instockvariations

string

isactive

number

iscustommade

number

isdivasize

number

isfirstprice

number

isfixedprice

number

ishot

number

isnew

number

isonline

number

isoutletprice

number

itemprice

number

20.7917

itempromo

string

key

string

kaylee

language

string

all

lastupdated

Date Time (Europe/Paris)

{ts '2025-08-16 11:05:09'}

linkedactions

Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.646 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('7e653324-77a5-42ba-89329b5b0c413627',lcase(cart_actions.linkedproducts)) > 0 and cart_actions.linkedproducts is not null
)

id_action

branding

language

name

code

type

minimumOrder

maximumOrder

minimumItems

maximumItems

maximumUse

allowedItems

quotas

usedCount

linkedproducts

linkedthemes

linkedbrands

linkeditem

params

activeFrom

activeTo

isActive

linkedproducts

Query
Template: /system/api/products.cfc:1305
Execution Time: 1.32 ms
Record Count: 0
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select products.productuid as productuid, products.reference, 'default' as type, products.key, products.language, products.name,
product_links.linkuid,
products.colors, products.vatrate, products.metadatas, products.dimensions,
products.mediadatas, products.tags, products.themes, products.isdivasize,
count(distinct product_variations.variationuid) as totalvariations,
group_concat(distinct product_variations.variationuid) as variationlist,
count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END) as inpromo,
if(count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END)>0,1,0) as haspromo,
(select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0) END)) as itempromo,
IFNULL(min(product_variations.itemprice),0) as itemprice,
(select IF (products.isfixedprice = 0 and sum(product_variations.itempromo) > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null), IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0), IFNULL(min(NULLIF(product_variations.itemprice, 0)), 0) )) as unitprice,
count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.itempromo ELSE product_variations.itemprice END) as prices,
(select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN min(NULLIF(product_variations.promountil, 0)) END)) as promountil,
products.isfixedprice, products.ishot, products.isnew, if(products.orderidx > 0, products.orderidx, 999999999) as orderidx,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
count(distinct CASE WHEN ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) > 0 OR ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) <= 0 AND product_variations.supplier = 0)) THEN product_variations.variationuid END) as instockvariations,
products.brand, brands.name as brandname, IFNULL(brands.ispublic, 0) as showbrand, brands.display,
product_categories.sizetype,GROUP_CONCAT(DISTINCT product_sizes.suppliersize) as intlsize,products.sizes,product_sizes.sizerange,product_categories.mediadatas as categorymediadatas, product_categories.sizerange as categorysizerange,
product_categorymap.section, product_categorymap.category, product_categorymap.key as subcategory
from products
left outer join product_categorymap on products.productuid = product_categorymap.productuid
left outer join product_categories on (product_categories.branding = product_categorymap.branding and product_categories.section = product_categorymap.section and product_categories.category = product_categorymap.category and product_categories.key = product_categorymap.key)
left outer join product_sizes on product_sizes.id_size IN (products.sizes)
left outer join brands on products.brand = brands.brand
left outer join product_variations on product_variations.productuid = products.productuid and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
left outer join product_links on product_links.reference = products.reference
where products.isactive = 1 and products.isdeleted = 0
and brands.isactive = 1 and brands.isdeleted = 0
and product_categories.isactive = 1 and product_categories.isdeleted = 0
and product_variations.isactive = 1
and FIND_IN_SET('divasboudoir',products.branding)
and product_categories.branding IN ('all','divasboudoir')
and product_categorymap.branding IN ('all','divasboudoir')
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and products.language in ('all','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 <> 'SLAU7351'
group by products.reference
order by products.ishot desc, products.isnew desc, orderidx asc, products.lastupdated desc

productuid

reference

type

key

language

name

linkuid

colors

vatrate

metadatas

dimensions

mediadatas

category

subcategory

linkuid

string

materials

string

mediadatas

Struct

alt

Struct

height

string

1175

isprivate

string

rating

string

all

src

string

/photobank/products/kbvy/slau7351/bas-autofixants-gris-satines-grande-taille.jpg

type

string

img

width

string

813

back

Struct

height

string

1080

isprivate

string

rating

string

all

src

string

/photobank/products/kbvy/slau7351/bas_autofixants_gris_brillants_grande_taille_dos.jpg

type

string

img

width

string

747

default

Struct

height

string

722

isprivate

string

rating

string

all

src

string

/photobank/products/kbvy/slau7351/ruby_kixies_028_900x.jpg

type

string

img

width

string

546

variations

Struct

colors

Struct

grey

Struct

height

string

722

isprivate

string

rating

string

all

src

string

/photobank/products/kbvy/slau7351/ruby_kixies_028_900x.jpg

type

string

img

width

string

546

video

Struct

embedsrc

string

height

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

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-grau

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

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-gkri

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

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-grey

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

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-gris

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

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-gris

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

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-grigio

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

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-grijs

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

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-cinzento

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

divasboudoir

Struct

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Selbstfixierende Strümpfe Kylie Hochwertige, glänzende, satinierte Maschenware, verziert mit einem dreifachen Klettverschluss, der nicht wegrollen wird (überprüfen Sie Ihre Größe genau).

guid

string

https://dev.divasboudoir.com/de/strumpfe-grosse-grosse-selbstfixierend-kylie-kixies-grau/slau7351.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Glänzen Sie, meine Damen, glänzen Sie mit diesen selbstfixierenden Strümpfen in Übergröße und seien Sie einzigartig.

keywords

string

title

string

Strümpfe große Größe Selbstfixierend Kylie

seotitle

string

Strümpfe große Größe Selbstfixierend Kylie

seouri

string

strumpfe-grosse-grosse-selbstfixierend-kylie-kixies-grau

specifications

string

stylingtips

string

summary

string

Glänzen Sie, meine Damen, glänzen Sie mit diesen selbstfixierenden Strümpfen in Übergröße und seien Sie einzigartig.

title

string

Kylie Selbstbindende Strümpfe

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Kylie hold ups Πλεκτό υψηλής ποιότητας, γυαλιστερό, σατινέ φινίρισμα με τριπλό κούμπωμα με αγκίστρι και θηλιές που δεν θα ξεκολλήσει (ελέγξτε το μέγεθός σας).

guid

string

https://dev.divasboudoir.com/el/kylie-megaloy-megethoys-hold-ups-kixies-gkri/slau7351.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Λάμψτε, κυρίες μου, λάμψτε με αυτά τα hold ups μεγάλου μεγέθους και γίνετε μοναδικές.

keywords

string

title

string

Kylie μεγάλου μεγέθους hold ups

seotitle

string

Kylie μεγάλου μεγέθους hold ups

seouri

string

kylie-megaloy-megethoys-hold-ups-kixies-gkri

specifications

string

stylingtips

string

summary

string

Λάμψτε, κυρίες μου, λάμψτε με αυτά τα hold ups μεγάλου μεγέθους και γίνετε μοναδικές.

title

string

Kylie hold ups

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Kylie hold-ups High-quality, shiny, satin-finish mesh with a triple hook-and-loop fastening that won't roll off (be sure to check your size).

guid

string

https://dev.divasboudoir.com/en/kylie-plus-size-hold-ups-autofixants-kixies-grey/slau7351.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Shine ladies, shine with these plus size hold ups, and be unique.

keywords

string

title

string

Kylie plus size hold ups Autofixants

seotitle

string

Kylie plus size hold ups Autofixants

seouri

string

kylie-plus-size-hold-ups-autofixants-kixies-grey

specifications

string

stylingtips

string

summary

string

Shine ladies, shine with these plus size hold ups, and be unique.

title

string

Kylie hold ups

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Medias Kylie Punto satinado brillante de alta calidad con triple cierre autoadherente que no se enrolla (comprueba tu talla).

guid

string

https://dev.divasboudoir.com/es/kylie-talla-grande-hold-ups-kixies-gris/slau7351.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Brillen, señoras, brillen con estas medias de talla grande y sean únicas.

keywords

string

title

string

Kylie talla grande hold ups

seotitle

string

Kylie talla grande hold ups

seouri

string

kylie-talla-grande-hold-ups-kixies-gris

specifications

string

stylingtips

string

summary

string

Brillen, señoras, brillen con estas medias de talla grande y sean únicas.

title

string

Kylie atraca

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Bas autofixants Kylie Maille de qualité, brillante et satinée, ornée d'une triple bande auto-agrippante qui ne roulera pas (vérifiez bien votre taille).

guid

string

https://dev.divasboudoir.com/fr/bas-grande-taille-autofixants-kylie-kixies-gris/slau7351.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Brillez Mesdames, brillez avec ces bas autofixants grande taille, et soyez uniques.

keywords

string

title

string

Bas grande taille Autofixants Kylie

seotitle

string

Bas grande taille Autofixants Kylie

seouri

string

bas-grande-taille-autofixants-kylie-kixies-gris

specifications

string

stylingtips

string

summary

string

Brillez Mesdames, brillez avec ces bas autofixants grande taille, et soyez uniques.

title

string

Bas Autofixants Kylie

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Kylie autoreggenti Maglia di alta qualità, lucida e satinata, con tripla chiusura a strappo che non si abbassa (controllare la taglia).

guid

string

https://dev.divasboudoir.com/it/kylie-taglia-grande-autoreggente-kixies-grigio/slau7351.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Brillate, signore, brillate con queste autoreggenti di taglia grande e siate uniche.

keywords

string

title

string

Kylie taglia grande autoreggente

seotitle

string

Kylie taglia grande autoreggente

seouri

string

kylie-taglia-grande-autoreggente-kixies-grigio

specifications

string

stylingtips

string

summary

string

Brillate, signore, brillate con queste autoreggenti di taglia grande e siate uniche.

title

string

Kylie hold up

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Kylie hold-ups Hoogwaardig, glanzend breisel met satijnglans en een drievoudige klittenbandsluiting die niet afrolt (controleer je maat).

guid

string

https://dev.divasboudoir.com/nl/kylie-hold-ups-groote-maat-kixies-grijs/slau7351.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Schitter, dames, schitter met deze hold-ups in groote maten en wees uniek.

keywords

string

title

string

Kylie hold-ups groote maat

seotitle

string

Kylie hold-ups groote maat

seouri

string

kylie-hold-ups-groote-maat-kixies-grijs

specifications

string

stylingtips

string

summary

string

Schitter, dames, schitter met deze hold-ups in groote maten en wees uniek.

title

string

Kylie hold-ups

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Kylie hold ups Malha de alta qualidade, brilhante e acetinada, com um fecho triplo de gancho e laço que não se enrola (verifique o seu tamanho).

guid

string

https://dev.divasboudoir.com/pt/kylie-plus-size-hold-ups-kixies-cinzento/slau7351.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Brilhem, senhoras, brilhem com estas bolsas de tamanho grande e sejam únicas.

keywords

string

title

string

Kylie plus size hold ups

seotitle

string

Kylie plus size hold ups

seouri

string

kylie-plus-size-hold-ups-kixies-cinzento

specifications

string

stylingtips

string

summary

string

Brilhem, senhoras, brilhem com estas bolsas de tamanho grande e sejam únicas.

title

string

Kylie hold ups

usageinstructions

string

fetishboudoir

Struct

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-grau

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

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-gkri

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

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-grey

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

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-gris

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

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-gris

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

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-grigio

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

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-grijs

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

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-cinzento

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

latexboudoir

Struct

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-grau

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

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-gkri

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

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-grey

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

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-gris

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

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-gris

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

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-grigio

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

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-grijs

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

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-cinzento

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

legsboudoir

Struct

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Beleuchten Sie Ihre Beine mit dem subtilen Glanz der selbstfixierenden Kylie-Strümpfe. Ihre hochwertige Maschenware, die sowohl glänzt als auch satiniert ist, verleiht Ihrem Outfit einen Hauch von Raffinesse. Warum Sie sie lieben werden : feiner Glanz: Die satinierte Maschenware verleiht jedem Outfit einen Hauch von Raffinesse. Tadelloser Halt: Das dreifache Klettband sorgt den ganzen Tag lang für einen perfekten Sitz, ohne zu rollen (überprüfen Sie Ihre Größe!). Optimaler Tragekomfort: Das weiche Material und die sorgfältige Verarbeitung sorgen dafür, dass Sie sich wie eine zweite Haut fühlen. Perfekt für einen besonderen Anlass oder für einen eleganten Alltagslook, diese Strümpfe werden schnell zu Ihren charmanten Verbündeten werden. Betonen Sie Ihre Weiblichkeit mit zeitloser Eleganz!

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Bringen Sie Ihre Beine mit unseren selbstfixierenden Kylie-Strümpfen mit satinierter Maschenware zum Leuchten. Komfort, Eleganz und perfekter Halt auf Legs Boudoir!

keywords

string

selbstfixierende Strümpfe, Kylie, Satin-Mesh, Triple-Band, Dessous, Eleganz, Glanz, Komfort, Beine, Halt, rutschfest, alle Größen, Legs Boudoir

title

string

Kylie Satin Mesh Autostrings | Legs Boudoir

seotitle

string

selbstfixierende Strümpfe große Größe Kylie satinierte Maschenware

seouri

string

selbstfixierende-strumpfe-grosse-grosse-kylie-satinierte-maschenware-kixies-grau

specifications

string

stylingtips

string

summary

string

glanz und Halt: Selbstfixierende Kylie-Strümpfe, ein satinierter Glanz und absoluter Komfort für unwiderstehliche Beine.

title

string

Glanz und Halt: Kylies selbstbindende Strümpfe, Seidenglanz und absoluter Komfort

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Φωτίστε τα πόδια σας με τη διακριτική λάμψη των hold-ups Kylie. Το ποιοτικό πλέγμα τους, γυαλιστερό και σατινέ, προσθέτει μια πινελιά εκλέπτυνσης στο ντύσιμό σας. Γιατί θα τα λατρέψετε: λεπτή λάμψη: Το σατινέ πλέγμα προσθέτει μια πινελιά εκλέπτυνσης σε κάθε ντύσιμο. Άψογη στήριξη: Η τριπλή ζώνη εξασφαλίζει τέλεια στήριξη όλη την ημέρα, χωρίς να κυλάει (βεβαιωθείτε ότι γνωρίζετε το μέγεθός σας!). Βέλτιστη άνεση: Το μαλακό ύφασμα και ο προσεγμένος σχεδιασμός σας χαρίζουν μια αίσθηση δεύτερου δέρματος. Ιδανικές για μια ειδική περίσταση ή μια κομψή καθημερινή εμφάνιση, αυτές οι κάλτσες θα γίνουν γρήγορα οι γοητευτικοί σύμμαχοί σας. Επιβεβαιώστε τη θηλυκότητά σας με διαχρονική κομψότητα!

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Φωτίστε τα πόδια σας με τα σατέν πλεκτά Kylie hold-ups. Άνεση, κομψότητα και τέλεια στήριξη στο Legs Boudoir!

keywords

string

hold ups, kylie, σατέν πλεκτό, τριπλή ζώνη, εσώρουχα, κομψότητα, λάμψη, άνεση, πόδια, υποστήριξη, αντιολισθητικό, όλα τα μεγέθη, Legs Boudoir

title

string

Autofixants Kylie Maille Satinée | Legs Boudoir

seotitle

string

μεγάλο μέγεθος kylie σατέν mesh hold ups

seouri

string

megalo-megethos-kylie-saten-mesh-hold-ups-kixies-gkri

specifications

string

stylingtips

string

summary

string

λάμψη και στήριξη: Kylie hold-ups, σατέν λάμψη και απόλυτη άνεση για ακαταμάχητα πόδια.

title

string

Λάμψη και υποστήριξη: Kylie hold ups, Satin Shine και Absolute Comfort

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Illuminate your legs with the subtle sparkle of Kylie's hold-ups. Their quality mesh, both shiny and satiny, adds a touch of sophistication to your outfit. Why you'll love them: subtle sparkle: Satin-finish mesh adds a touch of sophistication to any outfit. Impeccable support: The triple-band grip ensures perfect support all day long, without rolling (check your size!). Optimal comfort: The soft fabric and meticulous design give you a second-skin feel. Perfect for a special occasion or an elegant everyday look, these stockings will quickly become your charming allies. Assert your femininity with timeless elegance!

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Brighten up your legs with our satin-knit Kylie hold-ups. Comfort, elegance and perfect support on Legs Boudoir!

keywords

string

hold ups, kylie, satin knit, triple band, lingerie, elegance, shine, comfort, legs, support, non-slip, all sizes, Legs Boudoir

title

string

Autofixants Kylie Maille Satinée | Legs Boudoir

seotitle

string

plus size kylie satin mesh hold ups

seouri

string

plus-size-kylie-satin-mesh-hold-ups-kixies-grey

specifications

string

stylingtips

string

summary

string

shine and support: Kylie hold-ups, satin shine and absolute comfort for irresistible legs.

title

string

Radiance and support: Kylie hold-ups, Satin sheen and Absolute comfort

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Ilumina tus piernas con el sutil brillo de las medias Kylie. Su malla de calidad, tanto brillante como satinada, añade un toque de sofisticación a tu atuendo. Por qué te encantarán: brillo sutil: La malla satinada añade un toque de sofisticación a cualquier conjunto. Sujeción impecable: La triple banda garantiza una sujeción perfecta durante todo el día, sin enrollarse (¡asegúrate de conocer tu talla!). Comodidad óptima: El suave tejido y el cuidado diseño le proporcionan una sensación de segunda piel. Perfectas para una ocasión especial o un look elegante de diario, estas medias se convertirán rápidamente en tus aliadas encantadoras. ¡Afirme su feminidad con una elegancia atemporal!

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Alegra tus piernas con nuestras medias Kylie de punto satinado. ¡Comodidad, elegancia y sujeción perfecta en Legs Boudoir!

keywords

string

medias, kylie, punto satinado, triple banda, lencería, elegancia, brillo, comodidad, piernas, sujeción, antideslizante, todas las tallas, Legs Boudoir

title

string

Autofixants Kylie Maille Satinée | Legs Boudoir

seotitle

string

talla grande kylie satin mesh hold ups

seouri

string

talla-grande-kylie-satin-mesh-hold-ups-kixies-gris

specifications

string

stylingtips

string

summary

string

brillo y sujeción: medias Kylie, brillo satinado y comodidad absoluta para unas piernas irresistibles.

title

string

Luminosidad y sujeción: Kylie hold ups, Satin Shine y Absolute Comfort

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Illuminez vos jambes avec l'éclat subtil des bas autofixants Kylie. Leur maille de qualité, à la fois brillante et satinée, apporte une touche de sophistication à votre tenue. Pourquoi vous allez les adorer : Éclat subtil : La maille satinée apporte une touche de sophistication à toutes vos tenues. Maintien impeccable : La bande agrippante à triple bande assure un maintien parfait tout au long de la journée, sans rouler (vérifiez bien votre taille !). Confort optimal : La matière douce et la conception soignée vous offrent une sensation seconde peau. Parfaits pour une occasion spéciale ou pour un look quotidien élégant, ces bas deviendront vite vos alliés charme. Affirmez votre féminité avec une élégance intemporelle !

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Illuminez vos jambes avec nos bas autofixants Kylie et leur maille satinée. Confort, élégance et maintien parfait sur Legs Boudoir !

keywords

string

bas autofixants, kylie, maille satinée, triple bande, lingerie, élégance, brillance, confort, jambes, maintien, anti-glisse, toutes tailles, Legs Boudoir

title

string

Autofixants Kylie Maille Satinée | Legs Boudoir

seotitle

string

bas autofixants grande taille kylie maille satinee

seouri

string

bas-autofixants-grande-taille-kylie-maille-satinee-kixies-gris

specifications

string

stylingtips

string

summary

string

Éclat et maintien : bas autofixants Kylie, une brillance satinée et un confort absolu pour des jambes irrésistibles.

title

string

Éclat et Maintien : Bas Autofixants Kylie, Brillance Satinée et Confort Absolu

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Illuminate le vostre gambe con il sottile scintillio delle autoreggenti Kylie. La loro maglia di qualità, sia lucida che satinata, aggiunge un tocco di raffinatezza al vostro abbigliamento. Perché vi piaceranno: sottile lucentezza: la rete satinata aggiunge un tocco di raffinatezza a qualsiasi outfit. Sostegno impeccabile: la tripla fascia assicura un sostegno perfetto per tutto il giorno, senza rotolare (assicuratevi di conoscere la vostra taglia!). Comfort ottimale: il tessuto morbido e il design accurato regalano una sensazione di seconda pelle. Perfette per un'occasione speciale o per un look elegante da tutti i giorni, queste calze diventeranno rapidamente le vostre affascinanti alleate. Affermate la vostra femminilità con un'eleganza senza tempo!

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Ravvivate le vostre gambe con le nostre autoreggenti Kylie in maglia satinata. Comfort, eleganza e sostegno perfetto su Legs Boudoir!

keywords

string

autoreggenti, Kylie, maglia di raso, tripla fascia, lingerie, eleganza, lucentezza, comfort, gambe, sostegno, antiscivolo, tutte le taglie, Legs Boudoir

title

string

Autofixants Kylie Maille Satinée | Legs Boudoir

seotitle

string

taglia grande kylie satin mesh hold ups

seouri

string

taglia-grande-kylie-satin-mesh-hold-ups-kixies-grigio

specifications

string

stylingtips

string

summary

string

lucentezza e sostegno: autoreggenti Kylie, lucentezza satinata e comfort assoluto per gambe irresistibili.

title

string

Radiosità e sostegno: Kylie hold ups, Satin Shine e Absolute Comfort

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Verlicht je benen met de subtiele schittering van Kylie hold-ups. Het kwaliteitsgaas, zowel glanzend als satijnachtig, voegt een vleugje verfijning toe aan je outfit. Waarom je ze mooi zult vinden: subtiele glans: Het satijnen mesh voegt een vleugje verfijning toe aan elke outfit. Onberispelijke ondersteuning: De driedubbele band zorgt de hele dag door voor perfecte ondersteuning, zonder te rollen (zorg dat je je maat kent!). Optimaal comfort: De zachte stof en het zorgvuldige ontwerp geven je een tweede-huid gevoel. Perfect voor een speciale gelegenheid of een elegante alledaagse look, deze kousen zullen snel je charmante bondgenoten worden. Laat je vrouwelijkheid zien met tijdloze elegantie!

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Fleur je benen op met onze satijngebreide Kylie hold-ups. Comfort, elegantie en perfecte ondersteuning op Legs Boudoir!

keywords

string

hold ups, Kylie, satijn breisel, driedubbele band, lingerie, elegantie, glans, comfort, benen, ondersteuning, antislip, alle maten, Legs Boudoir

title

string

Autofixants Kylie Maille Satinée | Benen Boudoir

seotitle

string

Kylie hold-ups groote maat

seouri

string

kylie-hold-ups-groote-maat-kixies-grijs

specifications

string

stylingtips

string

summary

string

glans en ondersteuning: Kylie hold-ups, satijnen glans en absoluut comfort voor onweerstaanbare benen.

title

string

Kylie hold-ups

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Ilumine as suas pernas com o subtil brilho das Kylie hold-ups. A sua malha de qualidade, tanto brilhante como acetinada, acrescenta um toque de sofisticação ao seu visual. Porque é que as vai adorar: brilho subtil: A malha acetinada dá um toque de sofisticação a qualquer roupa. Apoio impecável: A banda tripla garante um apoio perfeito durante todo o dia, sem enrolar (certifique-se de que sabe o seu tamanho!). Conforto ideal: O tecido macio e o design meticuloso proporcionam-lhe uma sensação de segunda pele. Perfeitas para uma ocasião especial ou para um look elegante no dia a dia, estas meias tornar-se-ão rapidamente suas aliadas de charme. Afirme a sua feminilidade com uma elegância intemporal!

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Ilumine as suas pernas com as nossas meias de ligas acetinadas Kylie. Conforto, elegância e apoio perfeito em Legs Boudoir!

keywords

string

hold ups, kylie, malha de cetim, banda tripla, lingerie, elegância, brilho, conforto, pernas, apoio, antiderrapante, todos os tamanhos, Legs Boudoir

title

string

Autofixantes Kylie Maille Satinée | Legs Boudoir

seotitle

string

kylie de tamanho grande em malha de cetim

seouri

string

kylie-de-tamanho-grande-em-malha-de-cetim-kixies-cinzento

specifications

string

stylingtips

string

summary

string

brilho e apoio: meias Kylie, brilho acetinado e conforto absoluto para umas pernas irresistíveis.

title

string

Brilho e suporte: Kylie hold ups, Satin Shine e Absolute Comfort

usageinstructions

string

lustboudoir

Struct

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-grau

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

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-gkri

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

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-grey

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

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-gris

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

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-gris

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

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-grigio

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

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-grijs

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

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-cinzento

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

smboudoir

Struct

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Kylie Strümpfe Hochwertige, glänzende, satinierte Maschenware, verziert mit einem dreifachen Klettverschluss, der nicht wegrollen wird (überprüfen Sie Ihre Größe). Sie können sie auch mit Ihrem Lieblingsstrumpfhalter tragen.

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Glänzen Sie, meine Damen, glänzen Sie mit diesen selbstfixierenden Strümpfen und seien Sie einzigartig. Sie können sie auch mit Ihrem Lieblingsstrumpfhalter tragen.

keywords

string

title

string

Kylie Selbstbindende Strümpfe

seotitle

string

Kylie Selbstbindende Strümpfe

seouri

string

kylie-selbstbindende-strumpfe-kixies-grau

specifications

string

stylingtips

string

summary

string

Glänzen Sie, meine Damen, glänzen Sie mit diesen selbstfixierenden Strümpfen und seien Sie einzigartig. können Sie auch mit Ihrem Lieblingsstrapsgürtel tragen.

title

string

Kylie Selbstbindende Strümpfe

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Kylie κάλτσες Υψηλής ποιότητας, γυαλιστερή, σατινέ πλέξη με τριπλό κούμπωμα με αγκίστρι και θηλιές που δεν κατεβαίνει (ελέγξτε οπωσδήποτε το μέγεθός σας). Μπορείτε επίσης να τις φορέσετε με την αγαπημένη σας ζώνη καλτσοδέτας.

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

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

keywords

string

title

string

Kylie hold ups

seotitle

string

Kylie hold ups

seouri

string

kylie-hold-ups-kixies-gkri

specifications

string

stylingtips

string

summary

string

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

title

string

Kylie hold ups

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Kylie stockings High-quality, shiny, satin-finish knit with a triple hook-and-loop fastening that won't roll off (be sure to check your size). Can also be worn with your favorite garter belt.

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Shine, ladies, shine with these self-fastening stockings and be unique. You can also wear them with your favorite garter belt.

keywords

string

title

string

Kylie hold ups

seotitle

string

Kylie hold ups

seouri

string

kylie-hold-ups-kixies-grey

specifications

string

stylingtips

string

summary

string

Shine, ladies, shine with these self-fastening stockings and be unique. you can also wear them with your favorite garter belt.

title

string

Kylie hold ups

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Medias Kylie Punto satinado brillante de alta calidad con triple cierre autoadherente que no se enrolla (asegúrate de comprobar tu talla). También puedes llevarlas con tu liguero favorito.

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Brillad, señoritas, brillad con estas medias autofixants y sed únicas. También podéis llevarlas con vuestro liguero favorito.

keywords

string

title

string

Kylie atraca

seotitle

string

Kylie atraca

seouri

string

kylie-atraca-kixies-gris

specifications

string

stylingtips

string

summary

string

Brillen, señoras, brillen con estas medias con lazo y sean únicas. también puedes llevarlas con tu liguero favorito.

title

string

Kylie atraca

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Bas Kylie Maille de qualité, brillante et satinée, ornée d'une triple bande auto-agrippante qui ne roulera pas (vérifiez bien votre taille). Vous pourrez également porter avec votre porte-jarretelles préféré.

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Brillez Mesdames, brillez avec ces bas autofixants et soyez uniques. vous pourrez également porter avec votre porte-jarretelles préféré.

keywords

string

title

string

Bas Autofixants Kylie

seotitle

string

Bas Autofixants Kylie

seouri

string

bas-autofixants-kylie-kixies-gris

specifications

string

stylingtips

string

summary

string

Brillez Mesdames, brillez avec ces bas autofixants  et soyez uniques. vous pourrez également porter avec votre porte-jarretelles préféré.

title

string

Bas Autofixants Kylie

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Calze Kylie Maglia di alta qualità, lucida e satinata, con tripla chiusura a gancetti che non si abbassano (controllate la vostra taglia). Potete indossarle anche con il vostro reggicalze preferito.

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Brillate, signore, brillate con queste calze autofissanti e siate uniche. Potete anche indossarle con il vostro reggicalze preferito.

keywords

string

title

string

Kylie hold up

seotitle

string

Kylie hold up

seouri

string

kylie-hold-up-kixies-grigio

specifications

string

stylingtips

string

summary

string

Brillate, signore, brillate con queste calze autoreggenti e siate uniche. potete anche indossarle con il vostro reggicalze preferito.

title

string

Kylie hold up

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Kylie kousen Hoogwaardig, glanzend breisel met satijnglans en een drievoudige klittenbandsluiting die niet afrolt (controleer je maat). Je kunt ze ook dragen met je favoriete jarretelgordel.

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Schitter, dames, schitter met deze zelfbevestigende kousen en wees uniek. Je kunt ze ook dragen met je favoriete jarretelgordel.

keywords

string

title

string

Kylie hold-ups

seotitle

string

Kylie hold-ups

seouri

string

kylie-hold-ups-kixies-grijs

specifications

string

stylingtips

string

summary

string

Schitter, dames, schitter met deze zelfbinderkousen en wees uniek. je kunt ze ook dragen met je favoriete jarretelgordel.

title

string

Kylie hold-ups

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Meias de ligas Kylie Malhas de alta qualidade, brilhantes e acetinadas, com um fecho triplo de gancho e laço que não cai (verifique o seu tamanho). Também pode usá-las com o seu cinto de ligas preferido.

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Brilhem, senhoras, brilhem com estas meias auto-fixantes e sejam únicas. Também as podem usar com o seu cinto de ligas preferido.

keywords

string

title

string

Kylie hold ups

seotitle

string

Kylie hold ups

seouri

string

kylie-hold-ups-kixies-cinzento

specifications

string

stylingtips

string

summary

string

Brilhem, senhoras, brilhem com estas meias de ligas e sejam únicas. também as pode usar com o seu cinto de ligas preferido.

title

string

Kylie hold ups

usageinstructions

string

name

string

kaylee

netweight

string

nextshipment

string

tomorrow

ordered

number

orderidx

number

origin

string

originalsize

string

packaging

string

productshipment

string

auto

productuid

string

7E653324-77A5-42BA-89329B5B0C413627

promountil

string

rating

string

none

recorduid

string

7E653324-77A5-42BA-89329B5B0C413627

reference

string

SLAU7351

string

reserved

string

returned

number

returnsallowed

number

section

string

lingerie

shipment

string

3to5days

showbrand

number

sizeinfos

Query Template: /system/api/product/sizes.cfc:20 Execution Time: 1.25 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 = '7E653324-77A5-42BA-89329B5B0C413627' 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
	recorduid	size	sizetype	color	param1	param2	available	groupavailable	stock	gender	sizerange	sizegroup	suppliersize	intlsize	inches	eusize	ussize	uksize	frsize	essize	desize	itsize	ptsize	elsize	bust	waist	hip	underbust	cup	thigh	legheight	bodyheight	bodyweight
1	1583	4-5	intlsize	grey	4	5	-1	999999	0	w	plus	stocking	B	4-5		4-5	4-5	4-5	4-5	4-5	4-5	4-5	4-5	4-5						55-63
2	1584	6-7	intlsize	grey	6	7	-1	999999	0	w	plus	stocking	C	6-7		6-7	6-7	6-7	6-7	6-7	6-7	6-7	6-7	6-7						63-76
3	1585	8-9	intlsize	grey	8	9	0	0	0	w	plus	stocking	D	8-9		8-9	8-9	8-9	8-9	8-9	8-9	8-9	8-9	8-9						75-90

sizeranges

string

plus,standard

sizes

string

1583,1584,1585,2109

sizetype

string

intlsize

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

number

stocks

Query Template: /system/api/product/stocks.cfc:25 Execution Time: 4.67 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 = '7E653324-77A5-42BA-89329B5B0C413627' 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 = '7E653324-77A5-42BA-89329B5B0C413627' 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 = '7E653324-77A5-42BA-89329B5B0C413627' 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 = '7E653324-77A5-42BA-89329B5B0C413627' 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
	productuid	variationuid	recorduid	color	hexvalue	suppliersize	intlsize	inches	eusize	ussize	uksize	frsize	essize	desize	itsize	ptsize	elsize	gender	sizegroup	cup	size	sizetype	itemprice	itempromo	promoUntil	stockuid	warehouse	ontour	packaging	supplier	reserved	ordered	returned	defect	manufacturerreference	ean	available	stock	display	comments
1	7E653324-77A5-42BA-89329B5B0C413627	34423A7F-CC4E-4CE8-9C05AF6E78A2B0E5	1583	grey	#A9A9A9	B	4-5		4-5	4-5	4-5	4-5	4-5	4-5	4-5	4-5	4-5	w	stocking		4-5	intlsize	20.7917	0		STOCK01	0	0	0	-1	0	0	0	0			-1	0	all
2	7E653324-77A5-42BA-89329B5B0C413627	552DEDE8-5809-4ADA-BE50DE91BFFAC553	1584	grey	#A9A9A9	C	6-7		6-7	6-7	6-7	6-7	6-7	6-7	6-7	6-7	6-7	w	stocking		6-7	intlsize	20.7917	0		STOCK01	0	0	0	-1	0	0	0	0			-1	0	all
3	7E653324-77A5-42BA-89329B5B0C413627	2D9EB4A6-1FD5-4B4A-8CA7222B7487547C	1585	grey	#A9A9A9	D	8-9		8-9	8-9	8-9	8-9	8-9	8-9	8-9	8-9	8-9	w	stocking		8-9	intlsize	20.7917	0		STOCK01	0	0	0	0	0	0	0	0			0	0	all

subcategory

string

stocking

supplier

number

-1

supplierreference

string

KAYLEE

tags

string

themes

string

totalvariations

string

type

string

default

unitprice

number

20.7917

usageinstructions

string

variations

Query Template: /system/api/product/variations.cfc:171 Execution Time: 8.02 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 = '7E653324-77A5-42BA-89329B5B0C413627' 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 = '7E653324-77A5-42BA-89329B5B0C413627' 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 = '7E653324-77A5-42BA-89329B5B0C413627' 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 = '7E653324-77A5-42BA-89329B5B0C413627' 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 = '7E653324-77A5-42BA-89329B5B0C413627' 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 = '7E653324-77A5-42BA-89329B5B0C413627' 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 = '7E653324-77A5-42BA-89329B5B0C413627' 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 = '7E653324-77A5-42BA-89329B5B0C413627' 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 = '7E653324-77A5-42BA-89329B5B0C413627' 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 = '7E653324-77A5-42BA-89329B5B0C413627' 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 = '7E653324-77A5-42BA-89329B5B0C413627' 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 = '7E653324-77A5-42BA-89329B5B0C413627' 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 = '7E653324-77A5-42BA-89329B5B0C413627' 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 = '7E653324-77A5-42BA-89329B5B0C413627' 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 = '7E653324-77A5-42BA-89329B5B0C413627' 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 = '7E653324-77A5-42BA-89329B5B0C413627' 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 = '7E653324-77A5-42BA-89329B5B0C413627' 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 = '7E653324-77A5-42BA-89329B5B0C413627' 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 = '7E653324-77A5-42BA-89329B5B0C413627' 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 = '7E653324-77A5-42BA-89329B5B0C413627' 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 = '7E653324-77A5-42BA-89329B5B0C413627' 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 = '7E653324-77A5-42BA-89329B5B0C413627' 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 = '7E653324-77A5-42BA-89329B5B0C413627' 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 = '7E653324-77A5-42BA-89329B5B0C413627' 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 = '7E653324-77A5-42BA-89329B5B0C413627' 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 = '7E653324-77A5-42BA-89329B5B0C413627' 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 = '7E653324-77A5-42BA-89329B5B0C413627' 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 = '7E653324-77A5-42BA-89329B5B0C413627' 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
	variationuid	recorduid	color	hexvalue	suppliersize	intlsize	inches	eusize	ussize	uksize	frsize	essize	desize	itsize	ptsize	elsize	gender	sizegroup	cup	size	sizetype	itemprice	itempromo	promoUntil	stockuid	warehouse	ontour	packaging	supplier	reserved	ordered	returned	defect	manufacturerreference	ean	available	stock	availablepersize	stockpersize	availablepercolor	stockpercolor	haspromo	unitprice	display	comments
1	34423A7F-CC4E-4CE8-9C05AF6E78A2B0E5	1583	grey	#A9A9A9	B	4-5		4-5	4-5	4-5	4-5	4-5	4-5	4-5	4-5	4-5	w	stocking		4-5	intlsize	20.7917	0		STOCK01	0	0	0	-1	0	0	0	0			-1	0	-1	0	-1	0	0	20.7917	all
2	552DEDE8-5809-4ADA-BE50DE91BFFAC553	1584	grey	#A9A9A9	C	6-7		6-7	6-7	6-7	6-7	6-7	6-7	6-7	6-7	6-7	w	stocking		6-7	intlsize	20.7917	0		STOCK01	0	0	0	-1	0	0	0	0			-1	0	-1	0	-1	0	0	20.7917	all
3	2D9EB4A6-1FD5-4B4A-8CA7222B7487547C	1585	grey	#A9A9A9	D	8-9		8-9	8-9	8-9	8-9	8-9	8-9	8-9	8-9	8-9	w	stocking		8-9	intlsize	20.7917	0		STOCK01	0	0	0	0	0	0	0	0			0	0	0	0	-1	0	0	20.7917	all

vatrate

number

warehouse

string

Kylie plus size hold ups Autofixants

Product description

Technical details

Available sizes

Available color

Sizing guide

INFORMATION

MEMBER AREA

SERVICES

CONTACT US

Kylie plus size hold ups Autofixants

Product description

Technical details

Available sizes

Available color

Sizing guide

Newsletter

Change my settings

Save my preferences