See sizes

Double-click to enlarge

SKU: SLTI3183

Open-toe opaque tights

MADE IN

Stock:

Large mircofiber tights, wide open, opaque and very strong.

Size:

Not sure which size to choose? See our size guide

Color:

Quantity:

29.95 €

Help and advice

by chat, facebook or e-mail

Free returns

within 15 days *

Plus size opaque open tights

Name: Plus size opaque open tights - -1
Brand: Diva's Boudoir
SKU: SLTI3183
Price: 29.95 EUR
Availability: InStock

Product description

Open-toe opaque tights.

Made of microfiber, with wide hips and thighs.

Comfortable and strong

Perfect fit, flat seam.

60 Denier / 66 DTEX

Technical details

Available sizes

Available from 4 to 9

Available colors

Black , Red and White

Composition

Polyamide	88 %
Elastane	12 %

Sizing guide

Check the right size for you

International	Thigh
4	49-55
5	56-62
6	62-69
7	69-76
8	76-83
9	83-89

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

glamory

brandcode

string

gjjm

branding

string

divasboudoir,legsboudoir

brandmedias

string

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

brandmetas

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

brandname

string

Glamory

breasts

string

careinstructions

string

category

string

hoisery

categorygender

string

categorymediadatas

Struct

adult

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

414

isprivate

string

rating

string

all

src

string

/photobank/categories/divasboudoir/lingerie/hoisery/collants-ouverts-grande-taille.jpg

type

string

img

width

string

900

divasboudoir

Struct

plus

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

video

Struct

embedsrc

string

height

string

isprivate

string

rating

string

src

string

thumb

Struct

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

high

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

maxres

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

medium

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

standard

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

type

string

width

string

small

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

video

Struct

embedsrc

string

height

string

isprivate

string

rating

string

src

string

thumb

Struct

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

high

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

maxres

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

medium

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

standard

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

type

string

width

string

standard

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

video

Struct

embedsrc

string

height

string

isprivate

string

rating

string

src

string

thumb

Struct

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

high

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

maxres

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

medium

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

standard

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

type

string

width

string

fetishboudoir

Struct

plus

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

video

Struct

embedsrc

string

height

string

isprivate

string

rating

string

src

string

thumb

Struct

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

high

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

maxres

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

medium

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

standard

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

type

string

width

string

small

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

video

Struct

embedsrc

string

height

string

isprivate

string

rating

string

src

string

thumb

Struct

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

high

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

maxres

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

medium

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

standard

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

type

string

width

string

standard

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

video

Struct

embedsrc

string

height

string

isprivate

string

rating

string

src

string

thumb

Struct

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

high

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

maxres

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

medium

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

standard

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

type

string

width

string

latexboudoir

Struct

plus

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

video

Struct

embedsrc

string

height

string

isprivate

string

rating

string

src

string

thumb

Struct

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

high

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

maxres

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

medium

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

standard

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

type

string

width

string

small

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

video

Struct

embedsrc

string

height

string

isprivate

string

rating

string

src

string

thumb

Struct

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

high

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

maxres

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

medium

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

standard

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

type

string

width

string

standard

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

video

Struct

embedsrc

string

height

string

isprivate

string

rating

string

src

string

thumb

Struct

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

high

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

maxres

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

medium

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

standard

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

type

string

width

string

legsboudoir

Struct

plus

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

video

Struct

embedsrc

string

height

string

isprivate

string

rating

string

src

string

thumb

Struct

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

high

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

maxres

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

medium

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

standard

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

type

string

width

string

small

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

video

Struct

embedsrc

string

height

string

isprivate

string

rating

string

src

string

thumb

Struct

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

high

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

maxres

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

medium

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

standard

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

type

string

width

string

standard

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

video

Struct

embedsrc

string

height

string

isprivate

string

rating

string

src

string

thumb

Struct

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

high

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

maxres

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

medium

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

standard

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

type

string

width

string

lustboudoir

Struct

plus

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

video

Struct

embedsrc

string

height

string

isprivate

string

rating

string

src

string

thumb

Struct

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

high

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

maxres

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

medium

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

standard

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

type

string

width

string

small

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

video

Struct

embedsrc

string

height

string

isprivate

string

rating

string

src

string

thumb

Struct

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

high

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

maxres

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

medium

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

standard

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

type

string

width

string

standard

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

video

Struct

embedsrc

string

height

string

isprivate

string

rating

string

src

string

thumb

Struct

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

high

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

maxres

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

medium

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

standard

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

type

string

width

string

private

Struct

height

string

1016

isprivate

string

rating

string

all

src

string

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

type

string

img

width

string

703

smboudoir

Struct

plus

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

video

Struct

embedsrc

string

height

string

isprivate

string

rating

string

src

string

thumb

Struct

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

high

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

maxres

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

medium

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

standard

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

type

string

width

string

small

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

video

Struct

embedsrc

string

height

string

isprivate

string

rating

string

src

string

thumb

Struct

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

high

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

maxres

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

medium

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

standard

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

type

string

width

string

standard

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

video

Struct

embedsrc

string

height

string

isprivate

string

rating

string

src

string

thumb

Struct

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

high

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

maxres

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

medium

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

standard

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

type

string

width

string

categorysizerange

string

auto

colorinfos

Query Template: /system/api/product/colors.cfc:13 Execution Time: 1.87 ms Record Count: 3 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,red,white') > 0 and product_variations.productuid = 'C09E6E43-5EFC-491C-B9DBEC16C3D936AF' 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	2
2	red	color	red	red	red	#F50000	-1	4
3	white	color	whit	white	white	#FFFFFF	-1	2

colorrange

string

black

colors

string

black,red,white

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 '2019-10-10 08:52:08'}

defect

number

dimensions

Struct
Entries: 14

acrylicbones

string

backsideheight

string

diameter

string

flatsteelbones

string

frontsideheight

string

fullheight

string

length

string

modestysize

string

panels

string

sides

string

spiralsteelbones

string

totallength

string

unit

string

wiresize

string

display

string

all

displayfrom

string

displayto

string

grossweight

string

hasbrandinfos

boolean

false

hascareinstructions

boolean

false

hascolorinfos

boolean

true

hascompositions

boolean

true

hasdescription

boolean

true

hasdimensions

boolean

false

hasmaterials

boolean

false

hasotherspecifications

boolean

false

haspromo

number

hasshortdescription

boolean

true

hassizeinfos

boolean

true

hasspecifications

boolean

false

hasstockinfos

boolean

false

hasstylingtips

boolean

false

hasusageinstructions

boolean

false

hasvariations

boolean

true

import

string

inpromo

number

instockvariations

string

isactive

number

iscustommade

number

isdivasize

number

isfirstprice

number

isfixedprice

number

ishot

number

isnew

number

isonline

number

isoutletprice

number

itemprice

number

24.9583

itempromo

string

key

string

50126-collants-ouverts-noirs

language

string

all

lastupdated

Date Time (Europe/Paris)

{ts '2025-08-18 19:17:29'}

linkedactions

Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 1.19 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('c09e6e43-5efc-491c-b9dbec16c3d936af',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: 2.53 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 <> 'SLTI3183'
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

6600

isprivate

string

rating

string

all

src

string

/photobank/products/gjjm/slti3183/50126-ouvert-60-red-plus-size.jpg

type

string

img

width

string

3800

back

Struct

height

string

6600

isprivate

string

rating

string

all

src

string

/photobank/products/gjjm/slti3183/50126-ouvert-60-white-plus-size.jpg

type

string

img

width

string

3800

default

Struct

height

string

6600

isprivate

string

rating

string

all

src

string

/photobank/products/gjjm/slti3183/50126-ouvert-60-black-plus-size_crop.jpg

type

string

img

width

string

6384

variations

Struct

colors

Struct

black

Struct

height

string

6600

isprivate

string

rating

string

all

src

string

/photobank/products/gjjm/slti3183/50126-ouvert-60-black-plus-size.jpg

type

string

img

width

string

6384

red

Struct

height

string

6600

isprivate

string

rating

string

all

src

string

/photobank/products/gjjm/slti3183/50126-ouvert-60-red-plus-size.jpg

type

string

img

width

string

3800

white

Struct

height

string

6600

isprivate

string

rating

string

all

src

string

/photobank/products/gjjm/slti3183/50126-ouvert-60-white-plus-size.jpg

type

string

img

width

string

3800

video

Struct

embedsrc

string

height

string

isprivate

string

rating

string

src

string

thumb

Struct

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

high

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

maxres

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

medium

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

standard

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

type

string

width

string

mediagallery

string

metadatas

Struct

darkboudoir

Struct

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-schwarz-rot-ou-weiss

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-mayro-kokkino-ou-leyko

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-black-red-ou-white

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-negro-rojo-ou-blanco

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-noir-rouge-ou-blanc

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-nero-rosso-ou-bianco

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-zwart-rood-ou-wit

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-preto-vermelho-ou-branco

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

divasboudoir

Struct

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Blickdichte, offene Strumpfhose. Aus Mikrofaser, Hüften und Oberschenkel schön weit. Bequem und strapazierfähig Perfekte Passform, flache Nähte. 60 Denier / 66 DTEX

guid

string

https://dev.divasboudoir.com/de/offene,-blickdichte-strumpfhose-in-grossen-grossen-schwarz-rot-ou-weiss/slti3183.htm

highlights

string

keypoint

string

keywords

string

strumpfhose, blickdicht, offen, Schritt, schwarz, rot, weiß, Mikrofaser, Komfort, fest, 60 Denier, Diva's Boudoir, Dessous, Kühnheit, Weiblichkeit

metas

Struct

description

string

Große Strumpfhose aus Mirkofaser, weit offen, blickdicht und sehr strapazierfähig.

keywords

string

strumpfhose, blickdicht, offen, Schritt, schwarz, rot, weiß, Mikrofaser, Komfort, fest, 60 Denier, Diva's Boudoir, Dessous, Kühnheit, Weiblichkeit

title

string

Offene, blickdichte Strumpfhose in großen Größen

seotitle

string

Offene, blickdichte Strumpfhose in großen Größen

seouri

string

offene,-blickdichte-strumpfhose-in-grossen-grossen-schwarz-rot-ou-weiss

specifications

string

stylingtips

string

summary

string

Große Strumpfhose aus Mirkofaser, weit offen, blickdicht und sehr strapazierfähig.

title

string

Offene blickdichte Strumpfhosen

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Ανοιχτό αδιαφανέ&sigmaf; καλσόν. Κατασκευασμένο από μικροΐνε&sigmaf;, με φαρδιά ισχία και μηρού&sigmaf;. Άνετο και ανθεκτικό Τέλεια εφαρμογή, επίπεδη ραφή. 60 Denier / 66 DTEX

guid

string

https://dev.divasboudoir.com/el/megalo-adiafanes-anoichto-kalson-mayro-kokkino-ou-leyko/slti3183.htm

highlights

string

keypoint

string

keywords

string

καλσόν, αδιαφανές, ανοιχτό, καβάλο, μαύρο, κόκκινο, λευκό, μικροΐνες, άνεση, συμπαγές, 60 denier, Diva's Boudoir, εσώρουχα, τολμηρό, θηλυκότητα

metas

Struct

description

string

Μεγάλο καλσόν από ίνες καθρέφτη, ανοιχτό, αδιαφανές και πολύ ανθεκτικό.

keywords

string

title

string

Μεγάλο αδιαφανές ανοιχτό καλσόν

seotitle

string

Μεγάλο αδιαφανές ανοιχτό καλσόν

seouri

string

megalo-adiafanes-anoichto-kalson-mayro-kokkino-ou-leyko

specifications

string

stylingtips

string

summary

string

Μεγάλο καλσόν από ίνε&sigmaf; καθρέφτη, ανοιχτό, αδιαφανέ&sigmaf; και πολύ ανθεκτικό.

title

string

Ανοιχτό αδιαφανές καλσόν

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Open-toe opaque tights. Made of microfiber, with wide hips and thighs. Comfortable and strong Perfect fit, flat seam. 60 Denier / 66 DTEX

guid

string

https://dev.divasboudoir.com/en/plus-size-opaque-open-tights-black-red-ou-white/slti3183.htm

highlights

string

keypoint

string

keywords

string

tights, opaque, open, crotch, black, red, white, microfiber, comfort, solid, 60 denier, Diva's Boudoir, lingerie, bold, femininity

metas

Struct

description

string

Large mircofiber tights, wide open, opaque and very strong.

keywords

string

tights, opaque, open, crotch, black, red, white, microfiber, comfort, solid, 60 denier, Diva's Boudoir, lingerie, bold, femininity

title

string

Plus size opaque open tights

seotitle

string

Plus size opaque open tights

seouri

string

plus-size-opaque-open-tights-black-red-ou-white

specifications

string

stylingtips

string

summary

string

Large mircofiber tights, wide open, opaque and very strong.

title

string

Open-toe opaque tights

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Mallas opacas con puntera abierta. De microfibra, con caderas y muslos anchos. Cómodas y resistentes Ajuste perfecto, costura plana. 60 Denier / 66 DTEX

guid

string

https://dev.divasboudoir.com/es/mallas-opacas-abiertas-talla-grande-negro-rojo-ou-blanco/slti3183.htm

highlights

string

keypoint

string

keywords

string

medias, opaco, abierto, entrepierna, negro, rojo, blanco, microfibra, comodidad, sólido, 60 denier, Diva's Boudoir, lencería, atrevido, feminidad

metas

Struct

description

string

Mallas grandes de mircofibra, muy abiertas, opacas y muy resistentes.

keywords

string

medias, opaco, abierto, entrepierna, negro, rojo, blanco, microfibra, comodidad, sólido, 60 denier, Diva's Boudoir, lencería, atrevido, feminidad

title

string

Mallas opacas abiertas talla grande

seotitle

string

Mallas opacas abiertas talla grande

seouri

string

mallas-opacas-abiertas-talla-grande-negro-rojo-ou-blanco

specifications

string

stylingtips

string

summary

string

Mallas grandes de mircofibra, muy abiertas, opacas y muy resistentes.

title

string

Medias opacas con puntera abierta

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

<div> Affirmez votre sensualité avec ces collants opaques ouverts à l'entrejambe. Leur coupe parfaite et leur couture plate vous garantissent un confort optimal, tandis que leur design audacieux vous invite à explorer votre féminité. Confectionnés en microfibre douce et résistante, ils offrent une opacité parfaite et une sensation agréable sur la peau. Les hanches et les cuisses sont bien larges, assurant une liberté de mouvement totale. Disponibles en noir, rouge et blanc, ces collants s'adapteront à toutes vos envies et à toutes vos tenues. Avec un grammage de 60 deniers et 66 DTEX, ils offrent un équilibre parfait entre opacité et résistance. </div>

guid

string

https://dev.divasboudoir.com/fr/collants-grande-taille-opaques-ouverts-entrejambe--lingerie-divas-boudoir-noir-rouge-ou-blanc/slti3183.htm

highlights

string

keypoint

string

keywords

string

collants, opaques, ouverts, entrejambe, noir, rouge, blanc, microfibre, confort, solide, 60 deniers, Diva's Boudoir, lingerie, audace, féminité

metas

Struct

description

string

Découvrez nos collants opaques ouverts à l'entrejambe, disponibles en noir, rouge et blanc. Osez l'audace et la féminité sur Diva's Boudoir. 60 deniers.

keywords

string

collants, opaques, ouverts, entrejambe, noir, rouge, blanc, microfibre, confort, solide, 60 deniers, Diva's Boudoir, lingerie, audace, féminité

title

string

Collants Opaques Ouverts Entrejambe - Lingerie Diva's Boudoir

seotitle

string

Collants grande taille Opaques Ouverts Entrejambe - Lingerie Diva's Boudoir

seouri

string

collants-grande-taille-opaques-ouverts-entrejambe--lingerie-divas-boudoir-noir-rouge-ou-blanc

specifications

string

stylingtips

string

summary

string

Osez l'audace avec ces collants opaques ouverts à l'entrejambe, disponibles en noir, rouge et blanc. Un symbole de féminité et de liberté, conçu pour vous offrir un confort inégalé.

title

string

Collants Ouverts Opaque - Audace & Confort

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Collant coprente con punta aperta. Realizzato in microfibra, con fianchi e cosce larghi. Confortevole e resistente Vestibilità perfetta, cuciture piatte. 60 denari / 66 DTEX

guid

string

https://dev.divasboudoir.com/it/collant-aperti-di-grande-taglia-e-coprenti-nero-rosso-ou-bianco/slti3183.htm

highlights

string

keypoint

string

keywords

string

collant, coprente, aperto, cavallo, nero, rosso, bianco, microfibra, comfort, tinta unita, 60 denari, Diva's Boudoir, lingerie, audacia, femminilità

metas

Struct

description

string

Collant in mircofibra di grandi dimensioni, ampio, coprente e molto resistente.

keywords

string

collant, coprente, aperto, cavallo, nero, rosso, bianco, microfibra, comfort, tinta unita, 60 denari, Diva's Boudoir, lingerie, audacia, femminilità

title

string

Collant aperti di grande taglia e coprenti

seotitle

string

Collant aperti di grande taglia e coprenti

seouri

string

collant-aperti-di-grande-taglia-e-coprenti-nero-rosso-ou-bianco

specifications

string

stylingtips

string

summary

string

Collant in mircofibra di grandi dimensioni, ampio, coprente e molto resistente.

title

string

Collant opachi open-toe

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Ondoorzichtige panty met open teen. Gemaakt van microvezel, met brede heupen en dijen. Comfortabel en sterk Perfecte pasvorm, platte naad. 60 Densiteit / 66 DTEX

guid

string

https://dev.divasboudoir.com/nl/groote-ondoorzichtige-open-panty-zwart-rood-ou-wit/slti3183.htm

highlights

string

keypoint

string

keywords

string

panty, ondoorzichtig, open, kruis, zwart, rood, wit, microvezel, comfort, effen, 60 denier, Diva's Boudoir, lingerie, durf, vrouwelijkheid

metas

Struct

description

string

Grote panty vanircofiber, wijd open, ondoorzichtig en zeer sterk.

keywords

string

panty, ondoorzichtig, open, kruis, zwart, rood, wit, microvezel, comfort, effen, 60 denier, Diva's Boudoir, lingerie, durf, vrouwelijkheid

title

string

Groote ondoorzichtige open panty

seotitle

string

Groote ondoorzichtige open panty

seouri

string

groote-ondoorzichtige-open-panty-zwart-rood-ou-wit

specifications

string

stylingtips

string

summary

string

Grote panty vanircofiber, wijd open, ondoorzichtig en zeer sterk.

title

string

Ondoorzichtige panty met open teen

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Collants opacos de biqueira aberta. Fabricados em microfibra, com ancas e coxas largas. Confortáveis e resistentes Ajuste perfeito, costura plana. 60 Denier / 66 DTEX

guid

string

https://dev.divasboudoir.com/pt/collants-abertos-grandes-e-opacos-preto-vermelho-ou-branco/slti3183.htm

highlights

string

keypoint

string

keywords

string

collants, opaco, aberto, entrepernas, preto, vermelho, branco, microfibra, conforto, sólido, 60 denier, Diva's Boudoir, lingerie, ousadia, feminilidade

metas

Struct

description

string

Collants de mircofibra grandes, bem abertos, opacos e muito resistentes.

keywords

string

collants, opaco, aberto, entrepernas, preto, vermelho, branco, microfibra, conforto, sólido, 60 denier, Diva's Boudoir, lingerie, ousadia, feminilidade

title

string

Collants abertos grandes e opacos

seotitle

string

Collants abertos grandes e opacos

seouri

string

collants-abertos-grandes-e-opacos-preto-vermelho-ou-branco

specifications

string

stylingtips

string

summary

string

Collants de mircofibra grandes, bem abertos, opacos e muito resistentes.

title

string

Collants opacos de biqueira aberta

usageinstructions

string

fetishboudoir

Struct

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-schwarz-rot-ou-weiss

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-mayro-kokkino-ou-leyko

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-black-red-ou-white

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-negro-rojo-ou-blanco

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-noir-rouge-ou-blanc

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-nero-rosso-ou-bianco

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-zwart-rood-ou-wit

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-preto-vermelho-ou-branco

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

latexboudoir

Struct

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-schwarz-rot-ou-weiss

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-mayro-kokkino-ou-leyko

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-black-red-ou-white

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-negro-rojo-ou-blanco

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-noir-rouge-ou-blanc

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-nero-rosso-ou-bianco

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-zwart-rood-ou-wit

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-preto-vermelho-ou-branco

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

legsboudoir

Struct

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

strumpfhose, blickdicht, offen, Schritt, große Größen, schwarz, rot, weiß, Mikrofaser, Komfort, fest, 60 Denier, Leg's Boudoir, geschwungene Beine, alle Größen

metas

Struct

description

string

Entdecken Sie unsere blickdichten, im Schritt offenen Strumpfhosen, die speziell für mollige Frauen entworfen wurden. Wagen Sie Sinnlichkeit und Komfort auf Leg's Boudoir. 60 Denier.

keywords

string

strumpfhose, blickdicht, offen, Schritt, große Größen, schwarz, rot, weiß, Mikrofaser, Komfort, fest, 60 Denier, Leg's Boudoir, geschwungene Beine, alle Größen

title

string

Opake Strumpfhosen mit offenem Schritt Große Größe | Leg's Boudoir

seotitle

string

Opake Strumpfhosen mit offenem Schritt Große Größe - Leg's Boudoir

seouri

string

opake-strumpfhosen-mit-offenem-schritt-grosse-grosse--legs-boudoir-schwarz-rot-ou-weiss

specifications

string

stylingtips

string

summary

string

title

string

Opaque Offene Strumpfhose - Komfort & Kühnheit

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

καλσόν, αδιαφανές, ανοιχτό, καβάλο, μεγάλο, μαύρο, κόκκινο, λευκό, μικροΐνες, άνεση, συμπαγές, 60 denier, Leg's Boudoir, καλλίγραμμα πόδια, όλα τα μεγέθη

metas

Struct

description

string

Ανακαλύψτε το αδιαφανές καλσόν μας με ανοιχτό καβάλο, ειδικά σχεδιασμένο για γυναίκες με καμπύλες. Τολμήστε να είστε αισθησιακές και άνετες με το Leg's Boudoir. 60 denier.

keywords

string

title

string

Ανοιχτό καλσόν με αδιαφανές καβάλο Large | Leg's Boudoir

seotitle

string

Ανοιχτό καλσόν με αδιαφανές καβάλο Large - Leg's Boudoir

seouri

string

anoichto-kalson-me-adiafanes-kavalo-large--legs-boudoir-mayro-kokkino-ou-leyko

specifications

string

stylingtips

string

summary

string

title

string

Αδιαφανές ανοιχτό καλσόν - Άνεση & Τόλμη

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

tights, opaque, open, crotch, plus size, black, red, white, microfiber, comfort, solid, 60 denier, Leg's Boudoir, shapely legs, all sizes

metas

Struct

description

string

Discover our open crotch opaque tights, specially designed for curvy women. Dare to be sensual and comfortable with Leg's Boudoir. 60 denier.

keywords

string

tights, opaque, open, crotch, plus size, black, red, white, microfiber, comfort, solid, 60 denier, Leg's Boudoir, shapely legs, all sizes

title

string

Open Crotch Opaque Tights Plus Size | Leg's Boudoir

seotitle

string

Open Crotch Opaque Tights Plus Size - Leg's Boudoir

seouri

string

open-crotch-opaque-tights-plus-size--legs-boudoir-black-red-ou-white

specifications

string

stylingtips

string

summary

string

title

string

Opaque Open Tights - Comfort & Daring

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

medias, opaco, abierto, entrepierna, talla grande, negro, rojo, blanco, microfibra, comodidad, sólido, 60 denier, Leg's Boudoir, piernas torneadas, todas las tallas

metas

Struct

description

string

Descubre nuestras mallas opacas de entrepierna abierta, especialmente diseñadas para mujeres con curvas. Atrévete a ser sensual y cómoda con Leg's Boudoir. 60 deniers.

keywords

string

medias, opaco, abierto, entrepierna, talla grande, negro, rojo, blanco, microfibra, comodidad, sólido, 60 denier, Leg's Boudoir, piernas torneadas, todas las tallas

title

string

Medias opacas de entrepierna abierta talla grande | Leg's Boudoir

seotitle

string

Mallas opacas con la entrepierna abierta talla grande - Leg's Boudoir

seouri

string

mallas-opacas-con-la-entrepierna-abierta-talla-grande--legs-boudoir-negro-rojo-ou-blanco

specifications

string

stylingtips

string

summary

string

title

string

Mallas opacas abiertas - Comodidad y atrevimiento

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

collants, opaques, ouverts, entrejambe, grande taille, noir, rouge, blanc, microfibre, confort, solide, 60 deniers, Leg's Boudoir, jambes galbées, toutes tailles

metas

Struct

description

string

Découvrez nos collants opaques ouverts à l'entrejambe, spécialement conçus pour les femmes rondes. Osez la sensualité et le confort sur Leg's Boudoir. 60 deniers.

keywords

string

collants, opaques, ouverts, entrejambe, grande taille, noir, rouge, blanc, microfibre, confort, solide, 60 deniers, Leg's Boudoir, jambes galbées, toutes tailles

title

string

Collants Opaques Ouverts Entrejambe Grande Taille | Leg's Boudoir

seotitle

string

Collants Opaques Ouverts Entrejambe Grande Taille - Leg's Boudoir

seouri

string

collants-opaques-ouverts-entrejambe-grande-taille--legs-boudoir-noir-rouge-ou-blanc

specifications

string

stylingtips

string

summary

string

title

string

Collants Ouverts Opaque - Confort & Audace

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

collant, coprente, aperto, cavallo, taglia grande, nero, rosso, bianco, microfibra, comfort, tinta unita, 60 denari, Leg's Boudoir, gambe formose, tutte le taglie

metas

Struct

description

string

Scoprite i nostri collant opachi a cavallo aperto, appositamente studiati per le donne formose. Osate essere sensuali e comode con Leg's Boudoir. 60 denari.

keywords

string

collant, coprente, aperto, cavallo, taglia grande, nero, rosso, bianco, microfibra, comfort, tinta unita, 60 denari, Leg's Boudoir, gambe formose, tutte le taglie

title

string

Collant coprenti a cavallo aperto di taglia grande | Leg's Boudoir

seotitle

string

Collant coprenti a cavallo aperto di taglia grande - Leg's Boudoir

seouri

string

collant-coprenti-a-cavallo-aperto-di-taglia-grande--legs-boudoir-nero-rosso-ou-bianco

specifications

string

stylingtips

string

summary

string

title

string

Collant aperti coprenti - Comfort e audacia

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

panty, ondoorzichtig, open, kruis, groot, zwart, rood, wit, microvezel, comfort, stevig, 60 denier, Leg's Boudoir, mooie benen, alle maten

metas

Struct

description

string

Ontdek onze ondoorzichtige panty met open kruis, speciaal ontworpen voor vrouwen met rondingen. Durf sensueel en comfortabel te zijn met Leg's Boudoir. 60 denier.

keywords

string

panty, ondoorzichtig, open, kruis, groot, zwart, rood, wit, microvezel, comfort, stevig, 60 denier, Leg's Boudoir, mooie benen, alle maten

title

string

Opaque panty met open kruis grote maat | Leg's Boudoir

seotitle

string

Opaque panty met open kruis grote maat - Leg's Boudoir

seouri

string

opaque-panty-met-open-kruis-grote-maat--legs-boudoir-zwart-rood-ou-wit

specifications

string

stylingtips

string

summary

string

title

string

Ondoorzichtige open panty - Comfort & durf

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

collants, opacos, abertos, entrepernas, grandes, preto, vermelho, branco, microfibra, conforto, sólidos, 60 denier, Leg's Boudoir, pernas torneadas, todos os tamanhos

metas

Struct

description

string

Descubra os nossos collants opacos com abertura entre pernas, especialmente concebidos para mulheres com curvas. Atreva-se a ser sensual e confortável com Leg's Boudoir. 60 denier.

keywords

string

collants, opacos, abertos, entrepernas, grandes, preto, vermelho, branco, microfibra, conforto, sólidos, 60 denier, Leg's Boudoir, pernas torneadas, todos os tamanhos

title

string

Meias-calças opacas de entrepernas abertas Grande | Leg's Boudoir

seotitle

string

Collants opacos com abertura entre pernas Grande - Leg's Boudoir

seouri

string

collants-opacos-com-abertura-entre-pernas-grande--legs-boudoir-preto-vermelho-ou-branco

specifications

string

stylingtips

string

summary

string

title

string

Collants abertos opacos - Conforto e ousadia

usageinstructions

string

lustboudoir

Struct

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-schwarz-rot-ou-weiss

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-mayro-kokkino-ou-leyko

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-black-red-ou-white

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-negro-rojo-ou-blanco

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-noir-rouge-ou-blanc

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-nero-rosso-ou-bianco

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-zwart-rood-ou-wit

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-preto-vermelho-ou-branco

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

smboudoir

Struct

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-schwarz-rot-ou-weiss

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-mayro-kokkino-ou-leyko

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-black-red-ou-white

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-negro-rojo-ou-blanco

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-noir-rouge-ou-blanc

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-nero-rosso-ou-bianco

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-zwart-rood-ou-wit

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-preto-vermelho-ou-branco

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

name

string

50126 collants ouverts noirs

netweight

string

nextshipment

string

tomorrow

ordered

number

orderidx

number

origin

string

originalsize

string

packaging

string

productshipment

string

auto

productuid

string

C09E6E43-5EFC-491C-B9DBEC16C3D936AF

promountil

string

rating

string

none

recorduid

string

C09E6E43-5EFC-491C-B9DBEC16C3D936AF

reference

string

SLTI3183

string

reserved

string

returned

number

returnsallowed

number

section

string

lingerie

shipment

string

4to6days

showbrand

number

sizeinfos

Query Template: /system/api/product/sizes.cfc:20 Execution Time: 3.36 ms Record Count: 18 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,'1039,1040,1041,1042,1043,1044') > 0 and product_variations.productuid = 'C09E6E43-5EFC-491C-B9DBEC16C3D936AF' 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	1039	4	intlsize	black	4	4	-1	999999	1	w	plus	stocking	4-M	4		40-42	10-12	14-16	42-44	42-44	40-42	46-48	42-44	40-42						49-55
2	1039	4	intlsize	white	4	4	-1	999999	0	w	plus	stocking	4-M	4		40-42	10-12	14-16	42-44	42-44	40-42	46-48	42-44	40-42						49-55
3	1039	4	intlsize	red	4	4	-1	999999	0	w	plus	stocking	4-M	4		40-42	10-12	14-16	42-44	42-44	40-42	46-48	42-44	40-42						49-55
4	1040	5	intlsize	red	5	5	-1	999999	2	w	plus	stocking	5-L	5		42-44	12-14	16-18	44-46	44-46	42-44	48-50	44-46	42-44						56-62
5	1040	5	intlsize	black	5	5	-1	999999	1	w	plus	stocking	5-L	5		42-44	12-14	16-18	44-46	44-46	42-44	48-50	44-46	42-44						56-62
6	1040	5	intlsize	white	5	5	-1	999999	0	w	plus	stocking	5-L	5		42-44	12-14	16-18	44-46	44-46	42-44	48-50	44-46	42-44						56-62
7	1041	6	intlsize	white	6	6	-1	999999	1	w	plus	stocking	6-XL	6		46-48	16-18	20-22	48-50	48-50	46-48	52-54	48-50	46-48						62-69
8	1041	6	intlsize	red	6	6	-1	999999	1	w	plus	stocking	6-XL	6		46-48	16-18	20-22	48-50	48-50	46-48	52-54	48-50	46-48						62-69
9	1041	6	intlsize	black	6	6	-1	999999	0	w	plus	stocking	6-XL	6		46-48	16-18	20-22	48-50	48-50	46-48	52-54	48-50	46-48						62-69
10	1042	7	intlsize	red	7	7	-1	999999	0	w	plus	stocking	7-2XL	7		48-50	18-20	22-24	50-52	50-52	48-50	54-56	50-52	48-50						69-76
11	1042	7	intlsize	black	7	7	-1	999999	0	w	plus	stocking	7-2XL	7		48-50	18-20	22-24	50-52	50-52	48-50	54-56	50-52	48-50						69-76
12	1042	7	intlsize	white	7	7	-1	999999	0	w	plus	stocking	7-2XL	7		48-50	18-20	22-24	50-52	50-52	48-50	54-56	50-52	48-50						69-76
13	1043	8	intlsize	white	8	8	-1	999999	1	w	plus	stocking	8-3XL	8		50-52	20-22	24-26	52-54	52-54	50-52	56-58	52-54	50-52						76-83
14	1043	8	intlsize	red	8	8	-1	999999	0	w	plus	stocking	8-3XL	8		50-52	20-22	24-26	52-54	52-54	50-52	56-58	52-54	50-52						76-83
15	1043	8	intlsize	black	8	8	-1	999999	0	w	plus	stocking	8-3XL	8		50-52	20-22	24-26	52-54	52-54	50-52	56-58	52-54	50-52						76-83
16	1044	9	intlsize	red	9	9	-1	999999	1	w	plus	stocking	9-4XL	9		52-54	22-24	26-28	54-56	54-56	52-54	58-60	54-56	52-54						83-89
17	1044	9	intlsize	black	9	9	-1	999999	0	w	plus	stocking	9-4XL	9		52-54	22-24	26-28	54-56	54-56	52-54	58-60	54-56	52-54						83-89
18	1044	9	intlsize	white	9	9	-1	999999	0	w	plus	stocking	9-4XL	9		52-54	22-24	26-28	54-56	54-56	52-54	58-60	54-56	52-54						83-89

sizeranges

string

plus

sizes

string

1039,1040,1041,1042,1043,1044

sizetype

string

auto

specifications

Struct
Entries: 23

belly

string

bones

string

bra

string

breasts

string

bust

string

closing

string

crochtless

string

cups

string

cut

string

garter

string

halter

string

lacing

string

lining

string

modestypanel

string

panty

string

sheathing

string

sleeves

string

stocking

string

straps

string

stretch

string

suspenders

string

transparency

string

underwires

string

stock

number

stocks

Query Template: /system/api/product/stocks.cfc:25 Execution Time: 61.5 ms Record Count: 18 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 = 'C09E6E43-5EFC-491C-B9DBEC16C3D936AF' and product_variations.isactive = 1 and product_sizes.id_size = 1039 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 = 'C09E6E43-5EFC-491C-B9DBEC16C3D936AF' and product_variations.isactive = 1 and product_sizes.id_size = 1040 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 = 'C09E6E43-5EFC-491C-B9DBEC16C3D936AF' and product_variations.isactive = 1 and product_sizes.id_size = 1041 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 = 'C09E6E43-5EFC-491C-B9DBEC16C3D936AF' and product_variations.isactive = 1 and product_sizes.id_size = 1042 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 = 'C09E6E43-5EFC-491C-B9DBEC16C3D936AF' and product_variations.isactive = 1 and product_sizes.id_size = 1043 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 = 'C09E6E43-5EFC-491C-B9DBEC16C3D936AF' and product_variations.isactive = 1 and product_sizes.id_size = 1044 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	C09E6E43-5EFC-491C-B9DBEC16C3D936AF	BAB1CCC5-E85F-464B-BD173447755AFD4C	1039	black	#000000	4-M	4		40-42	10-12	14-16	42-44	42-44	40-42	46-48	42-44	40-42	w	stocking		4	intlsize	24.9583	0		STOCK01	1	0	0	-1	0	2	0	1	50126	4260277137861	1	1	all
2	C09E6E43-5EFC-491C-B9DBEC16C3D936AF	FF8BB3AF-C930-42C0-97E2D6C698BF77AB	1039	red	#F50000	4-M	4		40-42	10-12	14-16	42-44	42-44	40-42	46-48	42-44	40-42	w	stocking		4	intlsize	24.9583	0		STOCK01	0	0	0	-1	0	0	0	0	50126	4260277137922	-1	0	all
3	C09E6E43-5EFC-491C-B9DBEC16C3D936AF	A1C5B455-E2C9-44F8-A3DD8D3A739FE7BD	1039	white	#FFFFFF	4-M	4		40-42	10-12	14-16	42-44	42-44	40-42	46-48	42-44	40-42	w	stocking		4	intlsize	24.9583	0		STOCK01	0	0	0	-1	0	0	0	0	50126	4260277137984	-1	0	all
4	C09E6E43-5EFC-491C-B9DBEC16C3D936AF	5574FFD6-37DD-4F08-B1E87C84B5BD69A1	1040	black	#000000	5-L	5		42-44	12-14	16-18	44-46	44-46	42-44	48-50	44-46	42-44	w	stocking		5	intlsize	24.9583	0		STOCK01	1	0	0	-1	0	9	0	0	50126	4260277137878	1	1	all
5	C09E6E43-5EFC-491C-B9DBEC16C3D936AF	21497FBF-3D3A-4A47-BA62719C700EDBA4	1040	red	#F50000	5-L	5		42-44	12-14	16-18	44-46	44-46	42-44	48-50	44-46	42-44	w	stocking		5	intlsize	24.9583	0		STOCK01	2	0	0	-1	0	1	0	0	50126	4260277137939	2	2	all
6	C09E6E43-5EFC-491C-B9DBEC16C3D936AF	1C1B610A-8EE3-4737-AD8FAD52A10AF1FC	1040	white	#FFFFFF	5-L	5		42-44	12-14	16-18	44-46	44-46	42-44	48-50	44-46	42-44	w	stocking		5	intlsize	24.9583	0		STOCK01	0	0	0	-1	0	0	0	0	50126	4260277137991	-1	0	all
7	C09E6E43-5EFC-491C-B9DBEC16C3D936AF	5FC02BC3-59EB-4202-A54E700110DBAC13	1041	black	#000000	6-XL	6		46-48	16-18	20-22	48-50	48-50	46-48	52-54	48-50	46-48	w	stocking		6	intlsize	24.9583	0		STOCK01	0	0	0	-1	0	8	0	0	50126	4260277137885	-1	0	all
8	C09E6E43-5EFC-491C-B9DBEC16C3D936AF	76688CE5-2ABD-4E03-8ED3D848F6F17172	1041	red	#F50000	6-XL	6		46-48	16-18	20-22	48-50	48-50	46-48	52-54	48-50	46-48	w	stocking		6	intlsize	24.9583	0		STOCK01	1	0	0	-1	0	1	0	0	50126	4260277137946	1	1	all
9	C09E6E43-5EFC-491C-B9DBEC16C3D936AF	CC3D23BD-973B-4D2B-92CD73CD96C7539D	1041	white	#FFFFFF	6-XL	6		46-48	16-18	20-22	48-50	48-50	46-48	52-54	48-50	46-48	w	stocking		6	intlsize	24.9583	0		STOCK01	1	0	0	-1	0	0	0	0	50126	4260277138004	1	1	all
10	C09E6E43-5EFC-491C-B9DBEC16C3D936AF	E18D25E8-46E2-4C1D-93DF5EAB50F63795	1042	black	#000000	7-2XL	7		48-50	18-20	22-24	50-52	50-52	48-50	54-56	50-52	48-50	w	stocking		7	intlsize	24.9583	0		STOCK01	0	0	0	-1	0	15	0	0	50126	4260277137892	-1	0	all
11	C09E6E43-5EFC-491C-B9DBEC16C3D936AF	E74292C0-B37C-4934-B6D68A2E43C3F111	1042	red	#F50000	7-2XL	7		48-50	18-20	22-24	50-52	50-52	48-50	54-56	50-52	48-50	w	stocking		7	intlsize	24.9583	0		STOCK01	0	0	0	-1	0	0	0	0	50126	4260277137953	-1	0	all
12	C09E6E43-5EFC-491C-B9DBEC16C3D936AF	4E13E6F0-60B8-4EA5-9925A50917CA0428	1042	white	#FFFFFF	7-2XL	7		48-50	18-20	22-24	50-52	50-52	48-50	54-56	50-52	48-50	w	stocking		7	intlsize	24.9583	0		STOCK01	0	0	0	-1	0	1	0	0	50126	4260277138011	-1	0	all
13	C09E6E43-5EFC-491C-B9DBEC16C3D936AF	FE614637-7B32-418F-B357C4129B4EDD25	1043	black	#000000	8-3XL	8		50-52	20-22	24-26	52-54	52-54	50-52	56-58	52-54	50-52	w	stocking		8	intlsize	24.9583	0		STOCK01	0	0	0	-1	0	11	0	0	50126	4260277137908	-1	0	all
14	C09E6E43-5EFC-491C-B9DBEC16C3D936AF	4A678172-4856-4B90-AAB75835D66A78FD	1043	red	#F50000	8-3XL	8		50-52	20-22	24-26	52-54	52-54	50-52	56-58	52-54	50-52	w	stocking		8	intlsize	24.9583	0		STOCK01	0	0	0	-1	0	0	0	0	50126	4260277137960	-1	0	all
15	C09E6E43-5EFC-491C-B9DBEC16C3D936AF	042F7E26-FC3C-4596-9C987800E3681054	1043	white	#FFFFFF	8-3XL	8		50-52	20-22	24-26	52-54	52-54	50-52	56-58	52-54	50-52	w	stocking		8	intlsize	24.9583	0		STOCK01	1	0	0	-1	0	2	0	0	50126	4260277138028	1	1	all
16	C09E6E43-5EFC-491C-B9DBEC16C3D936AF	FCD05B12-7529-42C3-8D7A6695F04D09A7	1044	black	#000000	9-4XL	9		52-54	22-24	26-28	54-56	54-56	52-54	58-60	54-56	52-54	w	stocking		9	intlsize	24.9583	0		STOCK01	0	0	0	-1	0	6	0	0	50126	4260277137915	-1	0	all
17	C09E6E43-5EFC-491C-B9DBEC16C3D936AF	45925516-1102-485B-8C03F43A7D047662	1044	red	#F50000	9-4XL	9		52-54	22-24	26-28	54-56	54-56	52-54	58-60	54-56	52-54	w	stocking		9	intlsize	24.9583	0		STOCK01	1	0	0	-1	0	1	0	0	50126	4260277137977	1	1	all
18	C09E6E43-5EFC-491C-B9DBEC16C3D936AF	9457D319-FE7A-4F99-ADAC9DAD9A32B8CF	1044	white	#FFFFFF	9-4XL	9		52-54	22-24	26-28	54-56	54-56	52-54	58-60	54-56	52-54	w	stocking		9	intlsize	24.9583	0		STOCK01	0	0	0	-1	0	0	0	0	50126	4260277138035	-1	0	all

subcategory

string

crotchless

supplier

number

-1

supplierreference

string

50126

tags

string

themes

string

hot

totalvariations

string

type

string

default

unitprice

number

24.9583

usageinstructions

string

variations

Query Template: /system/api/product/variations.cfc:171 Execution Time: 17.9 ms Record Count: 18 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 = 'C09E6E43-5EFC-491C-B9DBEC16C3D936AF' 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 = 'C09E6E43-5EFC-491C-B9DBEC16C3D936AF' 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 = 'C09E6E43-5EFC-491C-B9DBEC16C3D936AF' 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 = 'C09E6E43-5EFC-491C-B9DBEC16C3D936AF' 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 = 'C09E6E43-5EFC-491C-B9DBEC16C3D936AF' 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 = 'C09E6E43-5EFC-491C-B9DBEC16C3D936AF' 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 = 'C09E6E43-5EFC-491C-B9DBEC16C3D936AF' and product_variations.isactive = 1 and product_sizes.id_size = 1039 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 = 'C09E6E43-5EFC-491C-B9DBEC16C3D936AF' 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 = 'C09E6E43-5EFC-491C-B9DBEC16C3D936AF' 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 = 'C09E6E43-5EFC-491C-B9DBEC16C3D936AF' 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 = 'C09E6E43-5EFC-491C-B9DBEC16C3D936AF' 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 = 'C09E6E43-5EFC-491C-B9DBEC16C3D936AF' 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 = 'C09E6E43-5EFC-491C-B9DBEC16C3D936AF' 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 = 'C09E6E43-5EFC-491C-B9DBEC16C3D936AF' and product_variations.isactive = 1 and product_sizes.id_size = 1040 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 = 'C09E6E43-5EFC-491C-B9DBEC16C3D936AF' 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 = 'C09E6E43-5EFC-491C-B9DBEC16C3D936AF' 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 = 'C09E6E43-5EFC-491C-B9DBEC16C3D936AF' 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 = 'C09E6E43-5EFC-491C-B9DBEC16C3D936AF' 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 = 'C09E6E43-5EFC-491C-B9DBEC16C3D936AF' 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 = 'C09E6E43-5EFC-491C-B9DBEC16C3D936AF' 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 = 'C09E6E43-5EFC-491C-B9DBEC16C3D936AF' and product_variations.isactive = 1 and product_sizes.id_size = 1041 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 = 'C09E6E43-5EFC-491C-B9DBEC16C3D936AF' 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 = 'C09E6E43-5EFC-491C-B9DBEC16C3D936AF' 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 = 'C09E6E43-5EFC-491C-B9DBEC16C3D936AF' 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 = 'C09E6E43-5EFC-491C-B9DBEC16C3D936AF' 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 = 'C09E6E43-5EFC-491C-B9DBEC16C3D936AF' 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 = 'C09E6E43-5EFC-491C-B9DBEC16C3D936AF' 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 = 'C09E6E43-5EFC-491C-B9DBEC16C3D936AF' and product_variations.isactive = 1 and product_sizes.id_size = 1042 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 = 'C09E6E43-5EFC-491C-B9DBEC16C3D936AF' 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 = 'C09E6E43-5EFC-491C-B9DBEC16C3D936AF' 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 = 'C09E6E43-5EFC-491C-B9DBEC16C3D936AF' 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 = 'C09E6E43-5EFC-491C-B9DBEC16C3D936AF' 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 = 'C09E6E43-5EFC-491C-B9DBEC16C3D936AF' 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 = 'C09E6E43-5EFC-491C-B9DBEC16C3D936AF' 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 = 'C09E6E43-5EFC-491C-B9DBEC16C3D936AF' and product_variations.isactive = 1 and product_sizes.id_size = 1043 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 = 'C09E6E43-5EFC-491C-B9DBEC16C3D936AF' 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 = 'C09E6E43-5EFC-491C-B9DBEC16C3D936AF' 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 = 'C09E6E43-5EFC-491C-B9DBEC16C3D936AF' 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 = 'C09E6E43-5EFC-491C-B9DBEC16C3D936AF' 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 = 'C09E6E43-5EFC-491C-B9DBEC16C3D936AF' 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 = 'C09E6E43-5EFC-491C-B9DBEC16C3D936AF' 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 = 'C09E6E43-5EFC-491C-B9DBEC16C3D936AF' and product_variations.isactive = 1 and product_sizes.id_size = 1044 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	BAB1CCC5-E85F-464B-BD173447755AFD4C	1039	black	#000000	4-M	4		40-42	10-12	14-16	42-44	42-44	40-42	46-48	42-44	40-42	w	stocking		4	intlsize	24.9583	0		STOCK01	1	0	0	-1	0	2	0	1	50126	4260277137861	1	1	-1	1	-1	2	0	24.9583	all
2	FF8BB3AF-C930-42C0-97E2D6C698BF77AB	1039	red	#F50000	4-M	4		40-42	10-12	14-16	42-44	42-44	40-42	46-48	42-44	40-42	w	stocking		4	intlsize	24.9583	0		STOCK01	0	0	0	-1	0	0	0	0	50126	4260277137922	-1	0	-1	1	-1	4	0	24.9583	all
3	A1C5B455-E2C9-44F8-A3DD8D3A739FE7BD	1039	white	#FFFFFF	4-M	4		40-42	10-12	14-16	42-44	42-44	40-42	46-48	42-44	40-42	w	stocking		4	intlsize	24.9583	0		STOCK01	0	0	0	-1	0	0	0	0	50126	4260277137984	-1	0	-1	1	-1	2	0	24.9583	all
4	5574FFD6-37DD-4F08-B1E87C84B5BD69A1	1040	black	#000000	5-L	5		42-44	12-14	16-18	44-46	44-46	42-44	48-50	44-46	42-44	w	stocking		5	intlsize	24.9583	0		STOCK01	1	0	0	-1	0	9	0	0	50126	4260277137878	1	1	-1	3	-1	2	0	24.9583	all
5	21497FBF-3D3A-4A47-BA62719C700EDBA4	1040	red	#F50000	5-L	5		42-44	12-14	16-18	44-46	44-46	42-44	48-50	44-46	42-44	w	stocking		5	intlsize	24.9583	0		STOCK01	2	0	0	-1	0	1	0	0	50126	4260277137939	2	2	-1	3	-1	4	0	24.9583	all
6	1C1B610A-8EE3-4737-AD8FAD52A10AF1FC	1040	white	#FFFFFF	5-L	5		42-44	12-14	16-18	44-46	44-46	42-44	48-50	44-46	42-44	w	stocking		5	intlsize	24.9583	0		STOCK01	0	0	0	-1	0	0	0	0	50126	4260277137991	-1	0	-1	3	-1	2	0	24.9583	all
7	5FC02BC3-59EB-4202-A54E700110DBAC13	1041	black	#000000	6-XL	6		46-48	16-18	20-22	48-50	48-50	46-48	52-54	48-50	46-48	w	stocking		6	intlsize	24.9583	0		STOCK01	0	0	0	-1	0	8	0	0	50126	4260277137885	-1	0	-1	2	-1	2	0	24.9583	all
8	76688CE5-2ABD-4E03-8ED3D848F6F17172	1041	red	#F50000	6-XL	6		46-48	16-18	20-22	48-50	48-50	46-48	52-54	48-50	46-48	w	stocking		6	intlsize	24.9583	0		STOCK01	1	0	0	-1	0	1	0	0	50126	4260277137946	1	1	-1	2	-1	4	0	24.9583	all
9	CC3D23BD-973B-4D2B-92CD73CD96C7539D	1041	white	#FFFFFF	6-XL	6		46-48	16-18	20-22	48-50	48-50	46-48	52-54	48-50	46-48	w	stocking		6	intlsize	24.9583	0		STOCK01	1	0	0	-1	0	0	0	0	50126	4260277138004	1	1	-1	2	-1	2	0	24.9583	all
10	E18D25E8-46E2-4C1D-93DF5EAB50F63795	1042	black	#000000	7-2XL	7		48-50	18-20	22-24	50-52	50-52	48-50	54-56	50-52	48-50	w	stocking		7	intlsize	24.9583	0		STOCK01	0	0	0	-1	0	15	0	0	50126	4260277137892	-1	0	-1	0	-1	2	0	24.9583	all
11	E74292C0-B37C-4934-B6D68A2E43C3F111	1042	red	#F50000	7-2XL	7		48-50	18-20	22-24	50-52	50-52	48-50	54-56	50-52	48-50	w	stocking		7	intlsize	24.9583	0		STOCK01	0	0	0	-1	0	0	0	0	50126	4260277137953	-1	0	-1	0	-1	4	0	24.9583	all
12	4E13E6F0-60B8-4EA5-9925A50917CA0428	1042	white	#FFFFFF	7-2XL	7		48-50	18-20	22-24	50-52	50-52	48-50	54-56	50-52	48-50	w	stocking		7	intlsize	24.9583	0		STOCK01	0	0	0	-1	0	1	0	0	50126	4260277138011	-1	0	-1	0	-1	2	0	24.9583	all
13	FE614637-7B32-418F-B357C4129B4EDD25	1043	black	#000000	8-3XL	8		50-52	20-22	24-26	52-54	52-54	50-52	56-58	52-54	50-52	w	stocking		8	intlsize	24.9583	0		STOCK01	0	0	0	-1	0	11	0	0	50126	4260277137908	-1	0	-1	1	-1	2	0	24.9583	all
14	4A678172-4856-4B90-AAB75835D66A78FD	1043	red	#F50000	8-3XL	8		50-52	20-22	24-26	52-54	52-54	50-52	56-58	52-54	50-52	w	stocking		8	intlsize	24.9583	0		STOCK01	0	0	0	-1	0	0	0	0	50126	4260277137960	-1	0	-1	1	-1	4	0	24.9583	all
15	042F7E26-FC3C-4596-9C987800E3681054	1043	white	#FFFFFF	8-3XL	8		50-52	20-22	24-26	52-54	52-54	50-52	56-58	52-54	50-52	w	stocking		8	intlsize	24.9583	0		STOCK01	1	0	0	-1	0	2	0	0	50126	4260277138028	1	1	-1	1	-1	2	0	24.9583	all
16	FCD05B12-7529-42C3-8D7A6695F04D09A7	1044	black	#000000	9-4XL	9		52-54	22-24	26-28	54-56	54-56	52-54	58-60	54-56	52-54	w	stocking		9	intlsize	24.9583	0		STOCK01	0	0	0	-1	0	6	0	0	50126	4260277137915	-1	0	-1	1	-1	2	0	24.9583	all
17	45925516-1102-485B-8C03F43A7D047662	1044	red	#F50000	9-4XL	9		52-54	22-24	26-28	54-56	54-56	52-54	58-60	54-56	52-54	w	stocking		9	intlsize	24.9583	0		STOCK01	1	0	0	-1	0	1	0	0	50126	4260277137977	1	1	-1	1	-1	4	0	24.9583	all
18	9457D319-FE7A-4F99-ADAC9DAD9A32B8CF	1044	white	#FFFFFF	9-4XL	9		52-54	22-24	26-28	54-56	54-56	52-54	58-60	54-56	52-54	w	stocking		9	intlsize	24.9583	0		STOCK01	0	0	0	-1	0	0	0	0	50126	4260277138035	-1	0	-1	1	-1	2	0	24.9583	all

vatrate

number

warehouse

string

Plus size opaque open tights

Product description

Technical details

Available sizes

Available colors

Composition

Sizing guide

INFORMATION

MEMBER AREA

SERVICES

CONTACT US

Plus size opaque open tights

Product description

Technical details

Available sizes

Available colors

Composition

Sizing guide

Newsletter

Change my settings

Save my preferences