See sizes

Double-click to enlarge

SKU: SLAU3469

Leslie hold ups

Stock:

Self-fastening stockings full of class and sensuality.

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 *

Stockings plus size Autofixants Leslie

Name: Stockings plus size Autofixants Leslie - -1
Brand: Kixies
SKU: SLAU3469
Price: 24.95 EUR
Availability: InStock

Product description

Leslie stockings skilfully combine the sensuality of a leg-shaping Cuban line with the modernity of an unusual gripper band.

They won't roll, so be sure to check your size.

High quality, resolutely innovative design.

Technical details

Available sizes

Available from 4-5 to 8-9

Available color

Black

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

de

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

el

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

en

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

es

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

fr

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

it

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

nl

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

pt

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

brandname

string

Kixies

breasts

string

na

careinstructions

string

category

string

hoisery

categorygender

string

f

categorymediadatas

Struct

adult

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

628

isprivate

string

0

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

id

string

isprivate

string

rating

string

src

string

thumb

Struct

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

high

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

maxres

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

medium

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

standard

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

type

string

width

string

small

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

video

Struct

embedsrc

string

height

string

id

string

isprivate

string

rating

string

src

string

thumb

Struct

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

high

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

maxres

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

medium

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

standard

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

type

string

width

string

standard

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

video

Struct

embedsrc

string

height

string

id

string

isprivate

string

rating

string

src

string

thumb

Struct

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

high

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

maxres

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

medium

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

standard

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

type

string

width

string

fetishboudoir

Struct

plus

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

video

Struct

embedsrc

string

height

string

id

string

isprivate

string

rating

string

src

string

thumb

Struct

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

high

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

maxres

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

medium

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

standard

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

type

string

width

string

small

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

video

Struct

embedsrc

string

height

string

id

string

isprivate

string

rating

string

src

string

thumb

Struct

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

high

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

maxres

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

medium

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

standard

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

type

string

width

string

standard

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

video

Struct

embedsrc

string

height

string

id

string

isprivate

string

rating

string

src

string

thumb

Struct

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

high

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

maxres

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

medium

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

standard

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

type

string

width

string

latexboudoir

Struct

plus

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

video

Struct

embedsrc

string

height

string

id

string

isprivate

string

rating

string

src

string

thumb

Struct

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

high

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

maxres

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

medium

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

standard

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

type

string

width

string

small

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

video

Struct

embedsrc

string

height

string

id

string

isprivate

string

rating

string

src

string

thumb

Struct

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

high

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

maxres

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

medium

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

standard

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

type

string

width

string

standard

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

video

Struct

embedsrc

string

height

string

id

string

isprivate

string

rating

string

src

string

thumb

Struct

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

high

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

maxres

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

medium

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

standard

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

type

string

width

string

legsboudoir

Struct

plus

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

video

Struct

embedsrc

string

height

string

id

string

isprivate

string

rating

string

src

string

thumb

Struct

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

high

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

maxres

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

medium

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

standard

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

type

string

width

string

small

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

video

Struct

embedsrc

string

height

string

id

string

isprivate

string

rating

string

src

string

thumb

Struct

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

high

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

maxres

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

medium

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

standard

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

type

string

width

string

standard

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

video

Struct

embedsrc

string

height

string

id

string

isprivate

string

rating

string

src

string

thumb

Struct

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

high

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

maxres

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

medium

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

standard

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

type

string

width

string

lustboudoir

Struct

plus

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

video

Struct

embedsrc

string

height

string

id

string

isprivate

string

rating

string

src

string

thumb

Struct

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

high

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

maxres

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

medium

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

standard

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

type

string

width

string

small

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

video

Struct

embedsrc

string

height

string

id

string

isprivate

string

rating

string

src

string

thumb

Struct

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

high

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

maxres

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

medium

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

standard

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

type

string

width

string

standard

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

video

Struct

embedsrc

string

height

string

id

string

isprivate

string

rating

string

src

string

thumb

Struct

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

high

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

maxres

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

medium

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

standard

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

type

string

width

string

private

Struct

height

string

1016

isprivate

string

0

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

id

string

isprivate

string

rating

string

src

string

thumb

Struct

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

high

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

maxres

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

medium

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

standard

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

type

string

width

string

small

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

video

Struct

embedsrc

string

height

string

id

string

isprivate

string

rating

string

src

string

thumb

Struct

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

high

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

maxres

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

medium

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

standard

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

type

string

width

string

standard

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

video

Struct

embedsrc

string

height

string

id

string

isprivate

string

rating

string

src

string

thumb

Struct

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

high

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

maxres

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

medium

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

standard

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

type

string

width

string

categorysizerange

string

auto

colorinfos

Query Template: /system/api/product/colors.cfc:13 Execution Time: 0.969 ms Record Count: 1 Cached: No Datasource: divasboudoir_sitedatas Lazy: No SQL: select product_colors.color as recorduid, product_colors.type, product_colors.code, product_colors.color, product_colors.range, product_colors.hexvalue, (if( (select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0, -1, if( sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0, sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved), 0 ) )) as available, IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock from product_colors left outer join product_variations on product_colors.color = product_variations.color and product_variations.isactive = 1 left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01' where FIND_IN_SET(product_colors.color,'black') > 0 and product_variations.productuid = '5D66E0F2-DDC6-4E56-B797DFC566A8872F' 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	black	color	blak	black	black	#000000	-1	0

colorrange

string

black

colors

string

black

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 13:18:02'}

defect

number

0

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

cm

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

0

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

0

instockvariations

number

1

isactive

number

1

iscustommade

number

0

isdivasize

number

0

isfirstprice

number

0

isfixedprice

number

0

ishot

number

0

isnew

number

0

isonline

number

0

isoutletprice

number

0

itemprice

number

20.7917

itempromo

string

key

string

lois

language

string

all

lastupdated

Date Time (Europe/Paris)

{ts '2025-08-16 11:20:25'}

linkedactions

Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.852 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('5d66e0f2-ddc6-4e56-b797dfc566a8872f',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.61 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 <> 'SLAU3469'
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

594

isprivate

string

0

rating

string

all

src

string

/photobank/products/kbvy/slau3469/bas-autofixants-grande-taille-sexy1.jpg

type

string

img

width

string

477

back

Struct

height

string

1373

isprivate

string

0

rating

string

all

src

string

/photobank/products/kbvy/slau3469/bas-autofixants-curvy.jpg

type

string

img

width

string

900

default

Struct

height

string

770

isprivate

string

0

rating

string

all

src

string

/photobank/products/kbvy/slau3469/bas-autofixants-noir-kixies.jpg

type

string

img

width

string

532

variations

Struct

colors

Struct

black

Struct

height

string

1627

isprivate

string

0

rating

string

all

src

string

/photobank/products/kbvy/slau3469/bas-autofixants-grande-taille-bande.png

type

string

img

width

string

900

video

Struct

embedsrc

string

height

string

id

string

isprivate

string

rating

string

src

string

thumb

Struct

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

high

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

maxres

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

medium

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

standard

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

type

string

width

string

mediagallery

string

metadatas

Struct

darkboudoir

Struct

de

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-kixies-schwarz

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

el

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-kixies-mayro

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

en

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-kixies-black

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

es

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-kixies-negro

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

fr

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-kixies-noir

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

it

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-kixies-nero

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

nl

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-kixies-zwart

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

pt

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-kixies-preto

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

divasboudoir

Struct

de

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Die Leslie-Strümpfe verbinden geschickt die Sinnlichkeit der kubanischen Linie, die das Bein formt, mit der Modernität eines ungewöhnlichen Klettverschlusses. Die Strümpfe rollen nicht, achten Sie also auf Ihre Größe. Gute Qualität, innovatives Design.

guid

string

https://dev.divasboudoir.com/de/strumpfe-grosse-grosse-autofixants-leslie-kixies-schwarz/slau3469.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Selbstfixierende Strümpfe voller Klasse und Sinnlichkeit.

keywords

string

title

string

Strümpfe große Größe Autofixants Leslie

seotitle

string

Strümpfe große Größe Autofixants Leslie

seouri

string

strumpfe-grosse-grosse-autofixants-leslie-kixies-schwarz

specifications

string

stylingtips

string

summary

string

Selbstfixierende Strümpfe voller Klasse und Sinnlichkeit.

title

string

Selbstfixierende Strümpfe Leslie

usageinstructions

string

el

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Οι κάλτσες Leslie συνδυάζουν επιδέξια τον αισθησιασμό μιας κουβανέζικης γραμμής που καμπυλώνει το πόδι με τον μοντερνισμό μιας ασυνήθιστης, πιασάρικης ζώνης. Δεν θα κυλήσουν προς τα κάτω, γι' αυτό βεβαιωθείτε ότι έχετε ελέγξει το μέγεθός σας. Υψηλής ποιότητας, αποφασιστικά καινοτόμος σχεδιασμός.

guid

string

https://dev.divasboudoir.com/el/leslie-megaloy-megethoys-hold-ups-kixies-mayro/slau3469.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Αυτοκόλλητες κάλτσες γεμάτες φινέτσα και αισθησιασμό.

keywords

string

title

string

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

seotitle

string

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

seouri

string

leslie-megaloy-megethoys-hold-ups-kixies-mayro

specifications

string

stylingtips

string

summary

string

Αυτοκόλλητες κάλτσες γεμάτες φινέτσα και αισθησιασμό.

title

string

Leslie hold ups

usageinstructions

string

en

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Leslie stockings skilfully combine the sensuality of a leg-shaping Cuban line with the modernity of an unusual gripper band. They won't roll, so be sure to check your size. High quality, resolutely innovative design.

guid

string

https://dev.divasboudoir.com/en/stockings-plus-size-autofixants-leslie-kixies-black/slau3469.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Self-fastening stockings full of class and sensuality.

keywords

string

title

string

Stockings plus size Autofixants Leslie

seotitle

string

Stockings plus size Autofixants Leslie

seouri

string

stockings-plus-size-autofixants-leslie-kixies-black

specifications

string

stylingtips

string

summary

string

Self-fastening stockings full of class and sensuality.

title

string

Leslie hold ups

usageinstructions

string

es

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Las medias Leslie combinan hábilmente la sensualidad de una línea cubana que curva la pierna con la modernidad de una banda de agarre inusual. No se bajan, así que asegúrese de comprobar su talla. Alta calidad, diseño decididamente innovador.

guid

string

https://dev.divasboudoir.com/es/leslie-talla-grande-hold-ups-kixies-negro/slau3469.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Medias autoadherentes llenas de clase y sensualidad.

keywords

string

title

string

Leslie talla grande hold ups

seotitle

string

Leslie talla grande hold ups

seouri

string

leslie-talla-grande-hold-ups-kixies-negro

specifications

string

stylingtips

string

summary

string

Medias autoadherentes llenas de clase y sensualidad.

title

string

Medias Leslie

usageinstructions

string

fr

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Les bas Leslie conjuge habilement la sensualité de la ligne cubaine qui galbe la jambe et la modernité d'une bande aggripante hors du comun.  Ils ne rouleront pas, vérifiez bien votre taille. Belle qualité, design résolument novateur.

guid

string

https://dev.divasboudoir.com/fr/bas-grande-taille-autofixants-leslie-kixies-noir/slau3469.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Des bas autofixants emplis de classe et de sensualité.

keywords

string

title

string

Bas grande taille Autofixants Leslie

seotitle

string

Bas grande taille Autofixants Leslie

seouri

string

bas-grande-taille-autofixants-leslie-kixies-noir

specifications

string

stylingtips

string

summary

string

Des bas autofixants emplis de classe et de sensualité.

title

string

Bas Autofixants Leslie

usageinstructions

string

it

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Le calze Leslie combinano sapientemente la sensualità di una linea cubana che curva la gamba con la modernità di una fascia insolita e aderente. Non si abbassano, quindi controllate la vostra taglia. Alta qualità, design decisamente innovativo.

guid

string

https://dev.divasboudoir.com/it/leslie-hold-up-di-taglia-grande-kixies-nero/slau3469.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Calze autoreggenti piene di classe e sensualità.

keywords

string

title

string

Leslie hold up di taglia grande

seotitle

string

Leslie hold up di taglia grande

seouri

string

leslie-hold-up-di-taglia-grande-kixies-nero

specifications

string

stylingtips

string

summary

string

Calze autoreggenti piene di classe e sensualità.

title

string

Leslie hold up

usageinstructions

string

nl

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Leslie kousen combineren vakkundig de sensualiteit van een Cubaanse lijn die het been rondt met de moderniteit van een ongebruikelijke, gripvaste band. Ze rollen niet af, dus controleer zeker je maat. Hoge kwaliteit, resoluut innovatief ontwerp.

guid

string

https://dev.divasboudoir.com/nl/leslie-groote-maat-hold-ups-kixies-zwart/slau3469.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Zelfsluitende kousen vol klasse en sensualiteit.

keywords

string

title

string

Leslie groote maat hold ups

seotitle

string

Leslie groote maat hold ups

seouri

string

leslie-groote-maat-hold-ups-kixies-zwart

specifications

string

stylingtips

string

summary

string

Zelfsluitende kousen vol klasse en sensualiteit.

title

string

Leslie wacht

usageinstructions

string

pt

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

As meias Leslie combinam habilmente a sensualidade de uma linha cubana que curva a perna com a modernidade de uma banda invulgar e aderente. Não se enrolam, por isso, verifique o seu tamanho. Alta qualidade, design decididamente inovador.

guid

string

https://dev.divasboudoir.com/pt/leslie,-tamanho-grande-kixies-preto/slau3469.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Meias auto-fixantes cheias de classe e sensualidade.

keywords

string

title

string

Leslie, tamanho grande

seotitle

string

Leslie, tamanho grande

seouri

string

leslie,-tamanho-grande-kixies-preto

specifications

string

stylingtips

string

summary

string

Meias auto-fixantes cheias de classe e sensualidade.

title

string

Leslie hold ups

usageinstructions

string

fetishboudoir

Struct

de

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-kixies-schwarz

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

el

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-kixies-mayro

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

en

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-kixies-black

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

es

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-kixies-negro

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

fr

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-kixies-noir

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

it

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-kixies-nero

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

nl

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-kixies-zwart

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

pt

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-kixies-preto

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

latexboudoir

Struct

de

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-kixies-schwarz

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

el

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-kixies-mayro

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

en

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-kixies-black

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

es

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-kixies-negro

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

fr

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-kixies-noir

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

it

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-kixies-nero

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

nl

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-kixies-zwart

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

pt

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-kixies-preto

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

legsboudoir

Struct

de

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Die Lizzy-Strümpfe verbinden gekonnt die Sinnlichkeit der kubanischen Linie, die das Bein formt, mit der Modernität eines ungewöhnlichen Klettbandes. Die Strümpfe rollen nicht. Achten Sie auf Ihre Größe. Gute Qualität, innovatives Design.

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Selbstfixierende Strümpfe voller Klasse und Sinnlichkeit - Lizzy-Strümpfe in großen Größen werden nicht rollen. Wir sind auf große Größen spezialisiert. Kostenlose Rücksendungen

keywords

string

title

string

Selbstfixierende Strümpfe in großer Größe Lizzy - Kostenlose Rücksendungen

seotitle

string

Strümpfe große Größe Selbstfixierende Lizzy

seouri

string

strumpfe-grosse-grosse-selbstfixierende-lizzy-kixies-schwarz

specifications

string

stylingtips

string

summary

string

Ultramodische und verführerische Strümpfe.

title

string

Selbstfixierende Strümpfe Lizzy

usageinstructions

string

el

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Οι κάλτσες Lizzy συνδυάζουν επιδέξια τον αισθησιασμό της κουβανέζικης γραμμής, η οποία καμπυλώνει το πόδι, με τον μοντερνισμό μιας ασυνήθιστης, πιασάρικης ζώνης. Δεν θα κυλήσουν προς τα κάτω, γι' αυτό βεβαιωθείτε ότι έχετε ελέγξει το μέγεθός σας. Υψηλής ποιότητας, αποφασιστικά καινοτόμος σχεδιασμός.

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Ένα αριστοκρατικό και αισθησιακό ζευγάρι hold ups, τα plus size hold ups της Lizzy δεν θα ξεκολλήσουν από τη γλώσσα. Ειδικευόμαστε στα plus sizes. Δωρεάν επιστροφές

keywords

string

title

string

Lizzy large size hold ups - Δωρεάν επιστροφές

seotitle

string

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

seouri

string

lizzy-megaloy-megethoys-hold-ups-kixies-mayro

specifications

string

stylingtips

string

summary

string

Εξαιρετικά μοντέρνες, σαγηνευτικές κάλτσες.

title

string

Lizzy hold ups

usageinstructions

string

en

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Lizzy stockings skilfully combine the sensuality of a Cuban line that curves the leg with the modernity of an unusual gripper band. They won't roll, so be sure to check your size. High quality, resolutely innovative design.

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Classy and sensual, Lizzy's plus size hold-ups won't roll off the tongue. We specialize in plus size. Free returns

keywords

string

title

string

Lizzy plus size hold ups - Free Returns

seotitle

string

Lizzy hold ups plus size Autofixants

seouri

string

lizzy-hold-ups-plus-size-autofixants-kixies-black

specifications

string

stylingtips

string

summary

string

Trendy, seductive stockings.

title

string

Lizzy hold ups

usageinstructions

string

es

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Las medias Lizzy combinan hábilmente la sensualidad de la línea cubana, que curva la pierna, con la modernidad de una inusual banda de agarre. No se bajan, así que asegúrese de comprobar su talla. Alta calidad y diseño decididamente innovador.

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Un par de medias elegantes y sensuales, los medias de talla grande de Lizzy no se irán de la lengua. Estamos especializados en tallas grandes. Devoluciones gratuitas

keywords

string

title

string

Lizzy talla grande hold ups - Devoluciones Gratuitas

seotitle

string

Lizzy talla grande hold ups

seouri

string

lizzy-talla-grande-hold-ups-kixies-negro

specifications

string

stylingtips

string

summary

string

Medias ultramodernas y seductoras.

title

string

Lizzy hold ups

usageinstructions

string

fr

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Les bas Lizzy conjuge habilement la sensualité de la ligne cubaine qui galbe la jambe et la modernité d'une bande aggripante hors du comun. Ils ne rouleront pas, vérifiez bien votre taille. Belle qualité, design résolument novateur..

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Des bas autofixants emplis de classe et de sensualité, les bas grande taille Lizzy ne rouleront pas. Nous sommes spécialisés en grande taille. Retours Gratuits

keywords

string

title

string

Bas grande taille Autofixants Lizzy - Retours Gratuits

seotitle

string

Bas grande taille Autofixants Lizzy

seouri

string

bas-grande-taille-autofixants-lizzy-kixies-noir

specifications

string

stylingtips

string

summary

string

Des bas ultra tendance et séduisants.

title

string

Bas Autofixants Lizzy

usageinstructions

string

it

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Le calze Lizzy combinano sapientemente la sensualità della linea cubana, che curva la gamba, con la modernità di una fascia insolita e aderente. Non si abbassano, quindi controllate la vostra taglia. Alta qualità, design decisamente innovativo.

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Un paio di autoreggenti di classe e sensuali, le autoreggenti per taglie grandi di Lizzy non passano inosservate. Siamo specializzati in taglie grandi. Restituzione gratuita

keywords

string

title

string

Lizzy taglia grande - Restituzione gratuita

seotitle

string

Lizzy taglia grande autoreggenti

seouri

string

lizzy-taglia-grande-autoreggenti-kixies-nero

specifications

string

stylingtips

string

summary

string

Calze ultra-fashion e seducenti.

title

string

Lizzy hold up

usageinstructions

string

nl

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Lizzy kousen combineren vakkundig de sensualiteit van de Cubaanse lijn, die het been rondt, met de moderniteit van een ongebruikelijke, gripvaste band. Ze rollen niet af, dus controleer zeker je maat. Hoge kwaliteit, resoluut innovatief ontwerp.

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Een stijlvol en sensueel paar hold-ups, Lizzy's hold-ups in grote maten rollen niet van de tong. Wij zijn gespecialiseerd in grote maten. Gratis retourneren

keywords

string

title

string

Lizzy grote maat hold ups - Gratis retourneren

seotitle

string

Leslie groote maat hold ups

seouri

string

leslie-groote-maat-hold-ups-kixies-zwart

specifications

string

stylingtips

string

summary

string

Ultramodieuze, verleidelijke kousen.

title

string

Leslie wacht

usageinstructions

string

pt

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

As meias Lizzy combinam habilmente a sensualidade da linha cubana, que curva a perna, com a modernidade de uma banda invulgar e aderente. Não se enrolam, por isso, verifique o seu tamanho. Alta qualidade, design absolutamente inovador.

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Um par de cuecas com classe e sensualidade, as cuecas Lizzy's plus size não vão sair da língua. Somos especializados em tamanhos grandes. Devoluções gratuitas

keywords

string

title

string

Lizzy tamanho grande - Devoluções gratuitas

seotitle

string

Lizzy tamanho grande

seouri

string

lizzy-tamanho-grande-kixies-preto

specifications

string

stylingtips

string

summary

string

Meias ultra-modernas e sedutoras.

title

string

Lizzy hold ups

usageinstructions

string

lustboudoir

Struct

de

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-kixies-schwarz

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

el

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-kixies-mayro

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

en

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-kixies-black

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

es

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-kixies-negro

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

fr

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-kixies-noir

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

it

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-kixies-nero

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

nl

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-kixies-zwart

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

pt

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-kixies-preto

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

smboudoir

Struct

de

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Die Leslie-Strümpfe verbinden geschickt die Sinnlichkeit der kubanischen Linie, die das Bein formt, mit der Modernität eines ungewöhnlichen Klettverschlusses. Die Strümpfe werden nicht rollen, prüfen Sie Ihre Größe. Gute Qualität und innovatives Design. Sie können sie auch mit Ihrem Lieblingsstrumpfhalter tragen.

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Strümpfe voller Klasse und Sinnlichkeit, die Sie auch mit Ihrem Lieblingsstrumpfhalter tragen können. .

keywords

string

title

string

Strumpf Leslie

seotitle

string

Strumpf Leslie

seouri

string

strumpf-leslie-kixies-schwarz

specifications

string

stylingtips

string

summary

string

Strümpfe voller Klasse und Sinnlichkeit, die Sie auch mit Ihrem Lieblingsstrumpfhalter tragen können. .

title

string

Strumpf Leslie

usageinstructions

string

el

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Οι κάλτσες Leslie συνδυάζουν επιδέξια τον αισθησιασμό μιας κουβανέζικης γραμμής που καμπυλώνει το πόδι με τον μοντερνισμό μιας ασυνήθιστης, πιασάρικης ζώνης. Δεν θα κυλήσουν προς τα κάτω, γι' αυτό βεβαιωθείτε ότι έχετε ελέγξει το μέγεθός σας. Υψηλής ποιότητας, καινοτόμος σχεδιασμός. Μπορείτε επίσης να τα φορέσετε με την αγαπημένη σας ζώνη καλτσοδέτας.

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

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

keywords

string

title

string

Bas Leslie

seotitle

string

Bas Leslie

seouri

string

bas-leslie-kixies-mayro

specifications

string

stylingtips

string

summary

string

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

title

string

Bas Leslie

usageinstructions

string

en

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Leslie stockings skilfully combine the sensuality of a leg-shaping Cuban line with the modernity of an unusual gripper band. They won't roll, so be sure to check your size. High quality, resolutely innovative design. You can also wear them with your favorite garter belt.

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Stockings full of class and sensuality, which you can also wear with your favourite garter belt.

keywords

string

title

string

Bas Leslie

seotitle

string

Bas Leslie

seouri

string

bas-leslie-kixies-black

specifications

string

stylingtips

string

summary

string

Stockings full of class and sensuality, which you can also wear with your favourite garter belt.

title

string

Bas Leslie

usageinstructions

string

es

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Las medias Leslie combinan hábilmente la sensualidad de una línea cubana que curva la pierna con la modernidad de una banda de agarre inusual. No se enrollan, así que asegúrese de comprobar su talla. Alta calidad y diseño innovador. También puedes llevarlos con tu liguero favorito.

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Medias llenas de clase y sensualidad, que también puedes llevar con tu liguero favorito.

keywords

string

title

string

Bas Leslie

seotitle

string

Bas Leslie

seouri

string

bas-leslie-kixies-negro

specifications

string

stylingtips

string

summary

string

Medias llenas de clase y sensualidad, que también puedes llevar con tu liguero favorito.

title

string

Bas Leslie

usageinstructions

string

fr

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Les bas Leslie conjuge habilement la sensualité de la ligne cubaine qui galbe la jambe et la modernité d'une bande aggripante hors du comun.  Ils ne rouleront pas, vérifiez bien votre taille. Belle qualité, design résolument novateur. Vous pourrez également porter avec votre porte-jarretelles préféré.

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Des bas emplis de classe et de sensualité, vous pourrez également porter avec votre porte-jarretelles préféré. .

keywords

string

title

string

Bas Leslie

seotitle

string

Bas Leslie

seouri

string

bas-leslie-kixies-noir

specifications

string

stylingtips

string

summary

string

Des bas emplis de classe et de sensualité, vous pourrez également porter avec votre porte-jarretelles préféré. .

title

string

Bas Leslie

usageinstructions

string

it

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Le calze Leslie combinano sapientemente la sensualità di una linea cubana che curva la gamba con la modernità di una fascia insolita e aderente. Non si abbassano, quindi controllate la vostra taglia. Design innovativo e di alta qualità. Potete indossarli anche con il vostro reggicalze preferito.

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Calze piene di classe e sensualità, che potrete indossare anche con il vostro reggicalze preferito.

keywords

string

title

string

Bas Leslie

seotitle

string

Bas Leslie

seouri

string

bas-leslie-kixies-nero

specifications

string

stylingtips

string

summary

string

Calze piene di classe e sensualità, che potrete indossare anche con il vostro reggicalze preferito.

title

string

Bas Leslie

usageinstructions

string

nl

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Leslie kousen combineren vakkundig de sensualiteit van een Cubaanse lijn die het been rondt met de moderniteit van een ongebruikelijke, gripvaste band. Ze rollen niet af, dus controleer je maat. Innovatief ontwerp van hoge kwaliteit. Je kunt ze ook dragen met je favoriete jarretelgordel.

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Kousen vol klasse en sensualiteit, die je ook kunt dragen met je favoriete jarretelgordel.

keywords

string

title

string

Bas Leslie

seotitle

string

Bas Leslie

seouri

string

bas-leslie-kixies-zwart

specifications

string

stylingtips

string

summary

string

Kousen vol klasse en sensualiteit, die je ook kunt dragen met je favoriete jarretelgordel.

title

string

Bas Leslie

usageinstructions

string

pt

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

As meias Leslie combinam habilmente a sensualidade de uma linha cubana que curva a perna com a modernidade de uma banda invulgar e aderente. Não se enrolam, por isso, verifique o seu tamanho. Alta qualidade, design inovador. Também pode usá-las com o seu cinto de ligas preferido.

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Meias cheias de classe e sensualidade, que também podem ser usadas com o seu cinto de ligas preferido.

keywords

string

title

string

Bas Leslie

seotitle

string

Bas Leslie

seouri

string

bas-leslie-kixies-preto

specifications

string

stylingtips

string

summary

string

Meias cheias de classe e sensualidade, que também podem ser usadas com o seu cinto de ligas preferido.

title

string

Bas Leslie

usageinstructions

string

name

string

lois

netweight

string

nextshipment

string

tomorrow

ordered

number

21

orderidx

number

0

origin

string

originalsize

string

packaging

number

0

productshipment

string

auto

productuid

string

5D66E0F2-DDC6-4E56-B797DFC566A8872F

promountil

string

rating

string

none

recorduid

string

5D66E0F2-DDC6-4E56-B797DFC566A8872F

reference

string

SLAU3469

reserved

number

2

returned

number

0

returnsallowed

number

1

section

string

lingerie

shipment

string

3to5days

showbrand

number

1

sizeinfos

Query Template: /system/api/product/sizes.cfc:20 Execution Time: 1.67 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 = '5D66E0F2-DDC6-4E56-B797DFC566A8872F' 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	black	4	5	0	0	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	black	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	black	8	9	-1	999999	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

0

stocks

Query Template: /system/api/product/stocks.cfc:25 Execution Time: 6.65 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 = '5D66E0F2-DDC6-4E56-B797DFC566A8872F' 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 = '5D66E0F2-DDC6-4E56-B797DFC566A8872F' 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 = '5D66E0F2-DDC6-4E56-B797DFC566A8872F' 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 = '5D66E0F2-DDC6-4E56-B797DFC566A8872F' 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	5D66E0F2-DDC6-4E56-B797DFC566A8872F	38F34D8B-A881-4CE4-B7DC9E20714EA0F4	1583	black	#000000	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	0	0	1	0	0	1307	852531004251	0	0	all
2	5D66E0F2-DDC6-4E56-B797DFC566A8872F	CB1B755D-FDDF-458C-8E336374ED612055	1584	black	#000000	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	2	14	0	0	1307	852531004268	-1	0	all
3	5D66E0F2-DDC6-4E56-B797DFC566A8872F	D8A00494-4379-4192-A8D082D76B76AB3B	1585	black	#000000	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	-1	0	6	0	0	1307	852531004275	-1	0	all

subcategory

string

stocking

supplier

number

-1

supplierreference

string

LOIS

tags

string

themes

string

totalvariations

number

4

type

string

default

unitprice

number

20.7917

usageinstructions

string

variations

Query Template: /system/api/product/variations.cfc:171 Execution Time: 9.81 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 = '5D66E0F2-DDC6-4E56-B797DFC566A8872F' 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 = '5D66E0F2-DDC6-4E56-B797DFC566A8872F' 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 = '5D66E0F2-DDC6-4E56-B797DFC566A8872F' 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 = '5D66E0F2-DDC6-4E56-B797DFC566A8872F' 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 = '5D66E0F2-DDC6-4E56-B797DFC566A8872F' 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 = '5D66E0F2-DDC6-4E56-B797DFC566A8872F' 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 = '5D66E0F2-DDC6-4E56-B797DFC566A8872F' 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 = '5D66E0F2-DDC6-4E56-B797DFC566A8872F' 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 = '5D66E0F2-DDC6-4E56-B797DFC566A8872F' 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 = '5D66E0F2-DDC6-4E56-B797DFC566A8872F' 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 = '5D66E0F2-DDC6-4E56-B797DFC566A8872F' 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 = '5D66E0F2-DDC6-4E56-B797DFC566A8872F' 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 = '5D66E0F2-DDC6-4E56-B797DFC566A8872F' 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 = '5D66E0F2-DDC6-4E56-B797DFC566A8872F' 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 = '5D66E0F2-DDC6-4E56-B797DFC566A8872F' 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 = '5D66E0F2-DDC6-4E56-B797DFC566A8872F' 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 = '5D66E0F2-DDC6-4E56-B797DFC566A8872F' 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 = '5D66E0F2-DDC6-4E56-B797DFC566A8872F' 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 = '5D66E0F2-DDC6-4E56-B797DFC566A8872F' 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 = '5D66E0F2-DDC6-4E56-B797DFC566A8872F' 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 = '5D66E0F2-DDC6-4E56-B797DFC566A8872F' 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 = '5D66E0F2-DDC6-4E56-B797DFC566A8872F' 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 = '5D66E0F2-DDC6-4E56-B797DFC566A8872F' 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 = '5D66E0F2-DDC6-4E56-B797DFC566A8872F' 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 = '5D66E0F2-DDC6-4E56-B797DFC566A8872F' 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 = '5D66E0F2-DDC6-4E56-B797DFC566A8872F' 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 = '5D66E0F2-DDC6-4E56-B797DFC566A8872F' 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 = '5D66E0F2-DDC6-4E56-B797DFC566A8872F' 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	38F34D8B-A881-4CE4-B7DC9E20714EA0F4	1583	black	#000000	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	0	0	1	0	0	1307	852531004251	0	0	0	0	-1	0	0	20.7917	all
2	CB1B755D-FDDF-458C-8E336374ED612055	1584	black	#000000	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	2	14	0	0	1307	852531004268	-1	0	-1	0	-1	0	0	20.7917	all
3	D8A00494-4379-4192-A8D082D76B76AB3B	1585	black	#000000	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	-1	0	6	0	0	1307	852531004275	-1	0	-1	0	-1	0	0	20.7917	all

vatrate

number

20

warehouse

number

0

Stockings plus size Autofixants Leslie

Product description

Technical details

Available sizes

Available color

Sizing guide

INFORMATION

MEMBER AREA

SERVICES

CONTACT US

Stockings plus size Autofixants Leslie

Product description

Technical details

Available sizes

Available color

Sizing guide

Newsletter

Change my settings

Save my preferences