See sizes

Double-click to enlarge

SKU: SLTI8844

Tights without toes and without marks

MADE IN

Stock:

Plus size tights with seamless thighs and open toe.

Size:

Not sure which size to choose? See our size guide

Color:

Quantity:

16.95 €

Help and advice

by chat, facebook or e-mail

Free returns

within 15 days *

Plus size tights without toes and without demarcations

Description
Specifications

Product description

Open toe tights.

Clear, shiny, wide hips and thighs.

transparent, shiny, wide hips and thighs.

Comfortable, perfect fit, flat seam and reinforced pantyhose.

20 Denier / 22 DTEX

Technical details

Available sizes

Available from 42-44 to 56-58

Available colors

Black and Beige

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

410

isprivate

string

rating

string

all

src

string

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

type

string

img

width

string

891

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.59 ms Record Count: 2 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,beige') > 0 and product_variations.productuid = 'B1437285-0A15-48CA-AC4954EFC25BC58C' group by product_colors.range,product_colors.color order by product_colors.range,product_colors.color
	recorduid	type	code	color	range	hexvalue	available	stock
1	black	color	blak	black	black	#000000	-1	0
2	beige	color	beig	beige	brown	#F6DBAC	-1	7

colorrange

string

brown

colors

string

black,beige

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-09 10:16:40'}

defect

number

dimensions

Struct
Entries: 14

acrylicbones

string

backsideheight

string

diameter

string

flatsteelbones

string

frontsideheight

string

fullheight

string

length

string

modestysize

string

panels

string

sides

string

spiralsteelbones

string

totallength

string

unit

string

wiresize

string

display

string

all

displayfrom

string

displayto

string

grossweight

string

hasbrandinfos

boolean

false

hascareinstructions

boolean

false

hascolorinfos

boolean

true

hascompositions

boolean

false

hasdescription

boolean

true

hasdimensions

boolean

false

hasmaterials

boolean

false

hasotherspecifications

boolean

false

haspromo

number

hasshortdescription

boolean

true

hassizeinfos

boolean

true

hasspecifications

boolean

false

hasstockinfos

boolean

false

hasstylingtips

boolean

false

hasusageinstructions

boolean

false

hasvariations

boolean

true

import

string

inpromo

number

instockvariations

string

isactive

number

iscustommade

number

isdivasize

number

isfirstprice

number

isfixedprice

number

ishot

number

isnew

number

isonline

number

isoutletprice

number

itemprice

number

14.125

itempromo

string

key

string

50223-toeless-20-make-up

language

string

all

lastupdated

Date Time (Europe/Paris)

{ts '2025-10-05 16:50:44'}

linkedactions

Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 1.21 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('b1437285-0a15-48ca-ac4954efc25bc58c',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.58 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 <> 'SLTI8844'
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/slti8844/50223-toeless-20-make-up-plus-size.jpg

type

string

img

width

string

5320

back

Struct

height

string

2539

isprivate

string

rating

string

all

src

string

/photobank/products/gjjm/slti8844/50223-toeless-20-make-up-plus-size_crop_2.jpg

type

string

img

width

string

2134

default

Struct

height

string

2214

isprivate

string

rating

string

all

src

string

/photobank/products/gjjm/slti8844/50223-toeless-20-black-plus-size_crop_2.jpg

type

string

img

width

string

1877

variations

Struct

colors

Struct

beige

Struct

height

string

2539

isprivate

string

rating

string

all

src

string

/photobank/products/gjjm/slti8844/50223-toeless-20-make-up-plus-size_crop_2.jpg

type

string

img

width

string

2134

black

Struct

height

string

2553

isprivate

string

rating

string

all

src

string

/photobank/products/gjjm/slti8844/50223-toeless-20-black-plus-size_crop.jpg

type

string

img

width

string

2092

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-ou-beige

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-ou-mpez

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-ou-beige

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-ou-beige

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-ou-beige

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-ou-beige

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-ou-beige

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-ou-bege

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

divasboudoir

Struct

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

An den Zehen offene Strumpfhose. Ohne Abgrenzungen an den Oberschenkeln. transparent, glänzend, Hüften und Oberschenkel schön breit. Bequem, perfekte Passform, flache Nähte und verstärkte Höschen. 20 Denier / 22 DTEX

guid

string

https://dev.divasboudoir.com/de/strumpfhosen-in-grossen-grossen-ohne-zehen-und-ohne-abgrenzungen-schwarz-ou-beige/slti8844.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Strumpfhose in großen Größen ohne Abgrenzungen an den Oberschenkeln und offen an den Zehen.

keywords

string

title

string

Strumpfhosen in großen Größen ohne Zehen und ohne Abgrenzungen

seotitle

string

Strumpfhosen in großen Größen ohne Zehen und ohne Abgrenzungen

seouri

string

strumpfhosen-in-grossen-grossen-ohne-zehen-und-ohne-abgrenzungen-schwarz-ou-beige

specifications

string

stylingtips

string

summary

string

Strumpfhose in großen Größen ohne Abgrenzungen an den Oberschenkeln und offen an den Zehen.

title

string

Strumpfhosen ohne Zehen und ohne Abgrenzungen

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Κολάν με ανοιχτή μύτη. Χωρίς οριοθέτηση στους μηρούς. διαφανές, γυαλιστερό, φαρδύ στους γοφούς και τους μηρούς. Άνετο, με τέλεια εφαρμογή, επίπεδη ραφή και ενισχυμένο εσώρουχο. 20 Denier / 22 DTEX

guid

string

https://dev.divasboudoir.com/el/megala-kalson-chwris-dachtyla-kai-chwris-grammes-mayro-ou-mpez/slti8844.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Κολάν μέχρι τον μηρό σε μεγάλο μέγεθος, χωρίς οριοθέτηση στους μηρούς και με ανοιχτά δάχτυλα.

keywords

string

title

string

Μεγάλα καλσόν χωρίς δάχτυλα και χωρίς γραμμές

seotitle

string

Μεγάλα καλσόν χωρίς δάχτυλα και χωρίς γραμμές

seouri

string

megala-kalson-chwris-dachtyla-kai-chwris-grammes-mayro-ou-mpez

specifications

string

stylingtips

string

summary

string

Κολάν μέχρι τον μηρό σε μεγάλο μέγεθος, χωρίς οριοθέτηση στους μηρούς και με ανοιχτά δάχτυλα.

title

string

Καλσόν χωρίς δάχτυλα ή σημάδια

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Open toe tights. Clear, shiny, wide hips and thighs. transparent, shiny, wide hips and thighs. Comfortable, perfect fit, flat seam and reinforced pantyhose. 20 Denier / 22 DTEX

guid

string

https://dev.divasboudoir.com/en/plus-size-tights-without-toes-and-without-demarcations-black-ou-beige/slti8844.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Plus size tights with seamless thighs and open toe.

keywords

string

title

string

Plus size tights without toes and without demarcations

seotitle

string

Plus size tights without toes and without demarcations

seouri

string

plus-size-tights-without-toes-and-without-demarcations-black-ou-beige

specifications

string

stylingtips

string

summary

string

Plus size tights with seamless thighs and open toe.

title

string

Tights without toes and without marks

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Mallas con puntera abierta. Sin demarcación en los muslos. transparente, brillante, caderas y muslos anchos. Cómodo, ajuste perfecto, costura plana y braga reforzada. 20 Denier / 22 DTEX

guid

string

https://dev.divasboudoir.com/es/medias-de-talla-grande-sin-dedos-ni-lineas-negro-ou-beige/slti8844.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Medias hasta el muslo en talla grande, sin demarcación en los muslos y punteras abiertas.

keywords

string

title

string

Medias de talla grande sin dedos ni líneas

seotitle

string

Medias de talla grande sin dedos ni líneas

seouri

string

medias-de-talla-grande-sin-dedos-ni-lineas-negro-ou-beige

specifications

string

stylingtips

string

summary

string

Medias hasta el muslo en talla grande, sin demarcación en los muslos y punteras abiertas.

title

string

Leotardos sin dedos ni marcas

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Collants ouvert aux orteils.  Sans démarcations au cuisses.  transparent, brillant, hanches et cuisses bien larges. Confortables, coupe parfaite, couture plate et culotte renforcée.  20 Denier / 22 DTEX

guid

string

https://dev.divasboudoir.com/fr/collants-grande-taille-sans-orteils-et-sans-demarcations-noir-ou-beige/slti8844.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Collants grande taille sans démarcations au cuisses, et ouvert au niveau des orteils.

keywords

string

title

string

Collants grande taille sans orteils et sans démarcations

seotitle

string

Collants grande taille sans orteils et sans démarcations

seouri

string

collants-grande-taille-sans-orteils-et-sans-demarcations-noir-ou-beige

specifications

string

stylingtips

string

summary

string

Collants grande taille sans démarcations au cuisses, et ouvert au niveau des orteils.

title

string

Collants sans orteils et sans démarcations

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Collant con punta aperta. Nessuna demarcazione sulle cosce. trasparente, lucida, ampia su fianchi e cosce. Confortevole, vestibilità perfetta, cucitura piatta e mutandina rinforzata. 20 denari / 22 DTEX

guid

string

https://dev.divasboudoir.com/it/collant-di-taglia-grande-senza-punte-e-senza-righe-nero-ou-beige/slti8844.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Collant di taglia grande, senza delimitazione delle cosce e con punte aperte.

keywords

string

title

string

Collant di taglia grande senza punte e senza righe

seotitle

string

Collant di taglia grande senza punte e senza righe

seouri

string

collant-di-taglia-grande-senza-punte-e-senza-righe-nero-ou-beige

specifications

string

stylingtips

string

summary

string

Collant di taglia grande, senza delimitazioni sulle cosce e con punte aperte.

title

string

Collant senza punte o segni

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Panty met open teen. Geen afbakening bij de dijen. stevig, glanzend, brede heupen en dijen. Comfortabel, perfecte pasvorm, platte naad en versterkte panty. 20 Denier / 22 DTEX

guid

string

https://dev.divasboudoir.com/nl/groote-maat-zonder-tenen-en-zonder-lijnen-zwart-ou-beige/slti8844.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Groote maat panty, zonder afbakening bij de dijen en met open tenen.

keywords

string

title

string

Groote maat zonder tenen en zonder lijnen

seotitle

string

Groote maat zonder tenen en zonder lijnen

seouri

string

groote-maat-zonder-tenen-en-zonder-lijnen-zwart-ou-beige

specifications

string

stylingtips

string

summary

string

Groote maat panty, zonder afbakening bij de dijen en met open tenen.

title

string

Panty zonder tenen of vlekken

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Collants de biqueira aberta. Sem demarcação nas coxas. transparente, brilhante, ancas e coxas largas. Confortável, ajuste perfeito, costura plana e cuecas reforçadas. 20 Denier / 22 DTEX

guid

string

https://dev.divasboudoir.com/pt/meias-calcas-largas-sem-dedos-e-sem-linhas-preto-ou-bege/slti8844.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Collants à altura das coxas em tamanho grande, sem demarcação nas coxas e com os dedos dos pés abertos.

keywords

string

title

string

Meias-calças largas sem dedos e sem linhas

seotitle

string

Meias-calças largas sem dedos e sem linhas

seouri

string

meias-calcas-largas-sem-dedos-e-sem-linhas-preto-ou-bege

specifications

string

stylingtips

string

summary

string

Collants à altura das coxas em tamanho grande, sem demarcação nas coxas e com os dedos dos pés abertos.

title

string

Collants sem dedos ou marcas

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-ou-beige

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-ou-mpez

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-ou-beige

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-ou-beige

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-ou-beige

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-ou-beige

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-ou-beige

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-ou-bege

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-ou-beige

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-ou-mpez

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-ou-beige

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-ou-beige

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-ou-beige

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-ou-beige

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-ou-beige

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-ou-bege

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

legsboudoir

Struct

Struct
Entries: 14

abstract

string

careinstructions

string

<ul> <li>Handwäsche in kaltem Wasser</li> <li>Nicht auswringen oder schleudern</li> <li>Flach im Schatten trocknen</li> <li>Nicht bügeln</li> </ul>

description

string

Eine Strumpfhose, die Komfort neu definiert, entwickelt, um Ihren Füßen totale Freiheit zu bieten. Die glänzende Transparenz betont Ihre Beine, während der großzügige Schnitt eine perfekte Passform garantiert. Ohne Abzeichnungen an den Oberschenkeln für einen unsichtbaren und natürlichen Effekt.

highlights

string

<ul> <li>Offene Zehen für maximale Freiheit</li> <li>Ohne Abzeichnungen an den Oberschenkeln</li> <li>Transparent glänzend 20 Denier</li> <li>Breite Hüften und Oberschenkel für optimalen Komfort</li> <li>Flache Naht und verstärktes Höschen</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Strumpfhose mit offenen Zehen in Übergröße 20 Denier von Leg's Boudoir. Transparent glänzend, ohne Abzeichnungen. Erhältlich in Beige oder Schwarz. Komfort und Eleganz garantiert.

keywords

string

title

string

Strumpfhose mit offenen Zehen Übergröße | Leg's Boudoir

seotitle

string

Übergröße Strumpfhose mit offenen Zehen - Transparent Glänzend 20 Denier

seouri

string

uebergroesse-strumpfhose-offene-zehen-transparent-glaenzend

specifications

string

<ul> <li>Material : 20 Denier / 22 DTEX</li> <li>Farben : Beige oder Schwarz</li> <li>Finish : Transparent glänzend</li> <li>Schnitt : Breite Hüften und Oberschenkel</li> <li>Merkmale : Offene Zehen, ohne Abzeichnungen, flache Naht, verstärktes Höschen</li> </ul>

stylingtips

string

Perfekt zu kombinieren mit High-Heel-Sandalen oder eleganten offenen Schuhen. Ideal zu einem Sommerkleid oder einem schicken Ensemble für einen sophistizierten und komfortablen Look.

summary

string

Entdecken Sie totale Freiheit mit dieser Übergröße-Strumpfhose mit offenen Zehen. Ein innovatives Accessoire, das glänzende Transparenz und absoluten Komfort für einen einzigartigen Stil kombiniert.

title

string

Strumpfhosen ohne Zehen und ohne Abgrenzungen

usageinstructions

string

Diese Strumpfhose bietet dank ihres großzügigen Designs einen perfekten Schnitt. Die offenen Zehen ermöglichen es Ihnen, Ihre Lieblingssandalen zu tragen und gleichzeitig die Eleganz einer Strumpfhose zu genießen. Das verstärkte Höschen sorgt den ganzen Tag über für komfortable Unterstützung.

Struct
Entries: 14

abstract

string

careinstructions

string

<ul> <li>Πλύσιμο στο χέρι με κρύο νερό</li> <li>Μην στρίβετε ή στύβετε</li> <li>Στεγνώστε επίπεδα στη σκιά</li> <li>Μην σιδερώνετε</li> </ul>

description

string

Ένα καλσόν που επαναπροσδιορίζει την άνεση, σχεδιασμένο για να προσφέρει απόλυτη ελευθερία στα πόδια σα&sigmaf;. Η λαμπερή διαφάνεια αναδεικνύει τα πόδια σα&sigmaf;, ενώ η γενναιόδωρη γραμμή εγγυάται τέλεια εφαρμογή. Χωρί&sigmaf; ραφέ&sigmaf; στου&sigmaf; μηρού&sigmaf; για ένα αόρατο και φυσικό αποτέλεσμα.

highlights

string

<ul> <li>Ελεύθερα δάχτυλα για μέγιστη ελευθερία</li> <li>Χωρί&sigmaf; ραφέ&sigmaf; στου&sigmaf; μηρού&sigmaf;</li> <li>Διάφανο λαμπερό 20 Denier</li> <li>Φαρδιά γοφιά και μηροί για βέλτιστη άνεση</li> <li>Επίπεδη ραφή και ενισχυμένο εσώρουχο</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Καλσόν με ελεύθερα δάχτυλα μεγάλου μεγέθους 20 Denier από το Leg's Boudoir. Διάφανο λαμπερό, χωρίς ραφές. Διαθέσιμο σε μπεζ ή μαύρο. Άνεση και κομψότητα εγγυημένα.

keywords

string

title

string

Καλσόν με Ελεύθερα Δάχτυλα Μεγάλου Μεγέθους | Leg's Boudoir

seotitle

string

Καλσόν Μεγάλου Μεγέθους με Ελεύθερα Δάχτυλα - Διάφανα Λαμπερά 20 Denier

seouri

string

kalson-megalou-megethous-eleythera-dachtyla-diafana-lampera

specifications

string

<ul> <li>Υλικό : 20 Denier / 22 DTEX</li> <li>Χρώματα : Μπεζ ή μαύρο</li> <li>Τελείωμα : Διάφανο λαμπερό</li> <li>Γραμμή : Φαρδιά γοφιά και μηροί</li> <li>Χαρακτηριστικά : Ελεύθερα δάχτυλα, χωρί&sigmaf; ραφέ&sigmaf;, επίπεδη ραφή, ενισχυμένο εσώρουχο</li> </ul>

stylingtips

string

Τέλειο για να συνδυαστεί με πέδιλα με τακούνι ή κομψά ανοιχτά παπούτσια. Ιδανικό με ένα καλοκαιρινό φόρεμα ή ένα κομψό σύνολο για ένα εκλεπτυσμένο και άνετο look.

summary

string

Ανακαλύψτε την απόλυτη ελευθερία με αυτό το καλσόν μεγάλου μεγέθου&sigmaf; με ελεύθερα δάχτυλα. Ένα καινοτόμο αξεσουάρ που συνδυάζει λαμπερή διαφάνεια και απόλυτη άνεση για ένα μοναδικό στιλ.

title

string

Καλσόν χωρίς δάχτυλα ή σημάδια

usageinstructions

string

Αυτό το καλσόν προσφέρει τέλεια γραμμή χάρη στο γενναιόδωρο σχεδιασμό του. Τα ελεύθερα δάχτυλα σα&sigmaf; επιτρέπουν να φορέσετε τα αγαπημένα σα&sigmaf; σανδάλια απολαμβάνοντα&sigmaf; την κομψότητα ενό&sigmaf; καλσόν. Το ενισχυμένο εσώρουχο εξασφαλίζει άνετη στήριξη καθ' όλη τη διάρκεια τη&sigmaf; ημέρα&sigmaf;.

Struct
Entries: 14

abstract

string

careinstructions

string

<ul> <li>Hand wash in cold water</li> <li>Do not wring or spin</li> <li>Dry flat in the shade</li> <li>Do not iron</li> </ul>

description

string

A tight that reinvents comfort, designed to offer total freedom to your feet. The glossy transparency enhances your legs, while the generous cut ensures a perfect fit. Seamless at the thighs for an invisible and natural effect.

highlights

string

<ul> <li>Open toe for maximum freedom</li> <li>Seamless at the thighs</li> <li>Transparent glossy 20 Denier</li> <li>Wide hips and thighs for optimal comfort</li> <li>Flat seam and reinforced panty</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Plus size open toe tights 20 Denier from Leg's Boudoir. Transparent glossy, seamless. Available in beige or black. Comfort and elegance guaranteed.

keywords

string

title

string

Open Toe Plus Size Tights | Leg's Boudoir

seotitle

string

Plus Size Open Toe Tights - Transparent Glossy 20 Denier

seouri

string

plus-size-open-toe-tights-transparent-glossy

specifications

string

<ul> <li>Material : 20 Denier / 22 DTEX</li> <li>Colors : Beige or black</li> <li>Finish : Transparent glossy</li> <li>Fit : Wide hips and thighs</li> <li>Features : Open toe, seamless, flat seam, reinforced panty</li> </ul>

stylingtips

string

Perfect to pair with high-heeled sandals or elegant open shoes. Ideal with a summer dress or a chic ensemble for a sophisticated and comfortable look.

summary

string

Discover total freedom with these plus-size open toe tights. An innovative accessory that combines glossy transparency and absolute comfort for a unique style.

title

string

Tights without toes and without marks

usageinstructions

string

These tights offer a perfect cut thanks to their generous design. The open toe allows you to wear your favorite sandals while enjoying the elegance of a tight. The reinforced panty ensures comfortable support all day long.

Struct
Entries: 14

abstract

string

careinstructions

string

<ul> <li>Lavado a mano en agua fría</li> <li>No retorcer ni centrifugar</li> <li>Secar extendido a la sombra</li> <li>No planchar</li> </ul>

description

string

Un diseño que reinventa el confort, pensado para ofrecer total libertad a tus pies. La transparencia brillante realza tus piernas, mientras el corte generoso garantiza un ajuste perfecto. Sin marcas en los muslos para un efecto invisible y natural.

highlights

string

<ul> <li>Dedos libres para máxima libertad</li> <li>Sin marcas en los muslos</li> <li>Transparentes brillantes 20 Denier</li> <li>Caderas y muslos anchos para un confort óptimo</li> <li>Costura plana y braga reforzada</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Medias con dedos libres talla grande 20 Denier de Leg's Boudoir. Transparentes brillantes, sin marcas. Disponibles en beige o negro. Confort y elegancia garantizados.

keywords

string

title

string

Medias con Dedos Libres Talla Grande | Leg's Boudoir

seotitle

string

Medias Talla Grande con Dedos Libres - Transparentes Brillantes 20 Denier

seouri

string

medias-talla-grande-dedos-libres-transparentes-brillantes

specifications

string

<ul> <li>Material : 20 Denier / 22 DTEX</li> <li>Colores : Beige o negro</li> <li>Acabado : Transparente brillante</li> <li>Corte : Caderas y muslos anchos</li> <li>Características : Dedos libres, sin marcas, costura plana, braga reforzada</li> </ul>

stylingtips

string

Perfectas para combinar con sandalias de tacón o zapatos abiertos elegantes. Ideales con un vestido de verano o un conjunto chic para un look sofisticado y cómodo.

summary

string

Descubre la libertad total con estas medias talla grande con dedos libres. Un accesorio innovador que combina transparencia brillante y confort absoluto para un estilo único.

title

string

Leotardos sin dedos ni marcas

usageinstructions

string

Estas medias ofrecen un corte perfecto gracias a su diseño generoso. Los dedos libres te permiten usar tus sandalias favoritas mientras disfrutas de la elegancia de unas medias. La braga reforzada asegura un soporte cómodo durante todo el día.

Struct
Entries: 14

abstract

string

careinstructions

string

<ul> <li>Lavage à la main en eau froide</li> <li>Ne pas tordre ni essorer</li> <li>Séchage à plat à l'ombre</li> <li>Ne pas repasser</li> </ul>

description

string

Un collant qui réinvente le confort, pensé pour offrir une liberté totale à vos pieds. La transparence brillante met en valeur vos jambes, tandis que la coupe généreuse garantit un ajustement parfait. Sans démarcations aux cuisses pour un effet invisible et naturel.

highlights

string

<ul> <li>Ouverts aux orteils pour une liberté maximale</li> <li>Sans démarcations aux cuisses</li> <li>Transparent brillant 20 Denier</li> <li>Hanches et cuisses larges pour un confort optimal</li> <li>Couture plate et culotte renforcée</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Collants grande taille ouverts orteils 20 Denier de Leg's Boudoir. Transparent brillant, sans démarcations. Disponibles en beige ou noir. Confort et élégance garantis.

keywords

string

title

string

Collants Ouverts Orteils Grande Taille | Leg's Boudoir

seotitle

string

Collants Grande Taille Ouverts Orteils - Transparent Brillant 20 Denier

seouri

string

collants-grande-taille-ouverts-orteils-transparent-brillant

specifications

string

<ul> <li>Matière : 20 Denier / 22 DTEX</li> <li>Couleurs : Beige ou noir</li> <li>Finition : Transparent brillant</li> <li>Coupe : Hanches et cuisses larges</li> <li>Caractéristiques : Ouverts aux orteils, sans démarcations, couture plate, culotte renforcée</li> </ul>

stylingtips

string

Parfaits pour accompagner des sandales à talons ou des nu-pieds élégants. Idéaux avec une robe d'été ou un ensemble chic pour un look sophistiqué et confortable. Explorez nos <a href="https://www.legsboudoir.com/fr/bas-autofixants-grande-taille/">collants ouverts grande taille</a> pour plus d'audace.<a href="/collections/collants-grande-taille"></a>

summary

string

Découvrez une liberté totale avec ces collants grande taille ouverts aux orteils. Un accessoire innovant qui allie transparence brillante et confort absolu pour un style unique.

title

string

Collants sans orteils et sans démarcations

usageinstructions

string

Ces collants offrent une coupe parfaite grâce à leur conception généreuse. L'ouverture aux orteils permet de porter vos sandales préférées tout en profitant de l'élégance d'un collant. La culotte renforcée assure un maintien confortable toute la journée.

Struct
Entries: 14

abstract

string

careinstructions

string

<ul> <li>Lavaggio a mano in acqua fredda</li> <li>Non strizzare o centrifugare</li> <li>Asciugare steso all'ombra</li> <li>Non stirare</li> </ul>

description

string

Un collant che reinventa il comfort, progettato per offrire totale libertà ai tuoi piedi. La trasparenza lucente esalta le tue gambe, mentre il taglio generoso garantisce una vestibilità perfetta. Senza segni sulle cosce per un effetto invisibile e naturale.

highlights

string

<ul> <li>Dita libere per la massima libertà</li> <li>Senza segni sulle cosce</li> <li>Trasparenti lucenti 20 Denier</li> <li>Fianchi e cosce larghe per un comfort ottimale</li> <li>Cucitura piatta e culotte rinforzata</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Collant con dita libere taglie forti 20 Denier di Leg's Boudoir. Trasparenti lucenti, senza segni. Disponibili in beige o nero. Comfort ed eleganza garantiti.

keywords

string

title

string

Collant con Dita Libere Taglie Forti | Leg's Boudoir

seotitle

string

Collant Taglie Forti con Dita Libere - Trasparenti Lucenti 20 Denier

seouri

string

collant-taglie-forti-dita-libere-trasparenti-lucenti

specifications

string

<ul> <li>Materiale : 20 Denier / 22 DTEX</li> <li>Colori : Beige o nero</li> <li>Finitura : Trasparente lucente</li> <li>Taglio : Fianchi e cosce larghe</li> <li>Caratteristiche : Dita libere, senza segni, cucitura piatta, culotte rinforzata</li> </ul>

stylingtips

string

Perfetti da abbinare a sandali con tacco o scarpe aperte eleganti. Ideali con un abito estivo o un completo chic per un look sofisticato e comodo.

summary

string

Scopri la libertà totale con questi collant taglie forti con dita libere. Un accessorio innovativo che combina trasparenza lucente e comfort assoluto per uno stile unico.

title

string

Collant senza punte o segni

usageinstructions

string

Questi collant offrono un taglio perfetto grazie al loro design generoso. Le dita libere ti permettono di indossare i tuoi sandali preferiti godendoti l'eleganza di un collant. La culotte rinforzata assicura un supporto confortevole durante l'intera giornata.

Struct
Entries: 14

abstract

string

careinstructions

string

<ul> <li>Handwas in koud water</li> <li>Niet wringen of centrifugeren</li> <li>Liggend in de schaduw laten drogen</li> <li>Niet strijken</li> </ul>

description

string

Een panty die comfort heruitvindt, ontworpen om uw voeten totale vrijheid te bieden. De glanzende transparantie benadrukt uw benen, terwijl de ruime pasvorm een perfecte fit garandeert. Zonder zichtbare lijnen bij de dijen voor een onzichtbaar en natuurlijk effect.

highlights

string

<ul> <li>Open tenen voor maximale vrijheid</li> <li>Zonder zichtbare lijnen bij de dijen</li> <li>Transparant glanzend 20 Denier</li> <li>Brede heupen en dijen voor optimaal comfort</li> <li>Platte naad en versterkt broekje</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Grote maat open teen panty 20 Denier van Leg's Boudoir. Transparant glanzend, zonder zichtbare lijnen. Verkrijgbaar in beige of zwart. Comfort en elegantie gegarandeerd.

keywords

string

title

string

Open Teen Panty Grote Maat | Leg's Boudoir

seotitle

string

Grote Maat Open Teen Panty - Transparant Glanzend 20 Denier

seouri

string

grote-maat-open-teen-panty-transparant-glanzend

specifications

string

<ul> <li>Materiaal : 20 Denier / 22 DTEX</li> <li>Kleuren : Beige of zwart</li> <li>Afwerking : Transparant glanzend</li> <li>Pasvorm : Brede heupen en dijen</li> <li>Kenmerken : Open tenen, zonder zichtbare lijnen, platte naad, versterkt broekje</li> </ul>

stylingtips

string

Perfect te combineren met sandalen met hak of elegante open schoenen. Ideaal met een zomerjurk of een chique ensemble voor een verfijnde en comfortabele look.

summary

string

Ontdek totale vrijheid met deze grote maat panty met open tenen. Een innovatief accessoire dat glanzende transparantie en absoluut comfort combineert voor een unieke stijl.

title

string

Panty zonder tenen of vlekken

usageinstructions

string

Deze panty's bieden een perfecte pasvorm dankzij hun ruime ontwerp. De open tenen stellen u in staat uw favoriete sandalen te dragen terwijl u geniet van de elegantie van een panty. Het versterkte broekje zorgt voor comfortabele ondersteuning de hele dag.

Struct
Entries: 14

abstract

string

careinstructions

string

<ul> <li>Lavar à mão em água fria</li> <li>Não torcer ou centrifugar</li> <li>Secar deitada à sombra</li> <li>Não passar</li> </ul>

description

string

Uma meia-calça que reinventa o conforto, projetada para oferecer liberdade total aos seus pés. A transparência brilhante realça suas pernas, enquanto o corte generoso garante um ajuste perfeito. Sem marcações nas coxas para um efeito invisível e natural.

highlights

string

<ul> <li>Dedos livres para máxima liberdade</li> <li>Sem marcações nas coxas</li> <li>Transparente brilhante 20 Denier</li> <li>Quadris e coxas largos para conforto máximo</li> <li>Costura plana e parte íntima reforçada</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

Meia-Calça com Dedos Livres Plus Size | Leg's Boudoir

seotitle

string

Meia-Calça Plus Size com Dedos Livres - Transparente Brilhante 20 Denier

seouri

string

meia-calca-plus-size-dedos-livres-transparente-brilhante

specifications

string

<ul> <li>Material : 20 Denier / 22 DTEX</li> <li>Cores : Bege ou preto</li> <li>Acabamento : Transparente brilhante</li> <li>Corte : Quadris e coxas largos</li> <li>Características : Dedos livres, sem marcações, costura plana, parte íntima reforçada</li> </ul>

stylingtips

string

Perfeitas para combinar com sandálias de salto ou sapatos abertos elegantes. Ideais com um vestido de verão ou um conjunto chique para um visual sofisticado e confortável.

summary

string

Descubra a liberdade total com esta meia-calça plus size com dedos livres. Um acessório inovador que combina transparência brilhante e conforto absoluto para um estilo único.

title

string

Collants sem dedos ou marcas

usageinstructions

string

Estas meias-calça oferecem um corte perfeito graças ao seu design generoso. Os dedos livres permitem que você use suas sandálias favoritas enquanto desfruta da elegância de uma meia-calça. A parte íntima reforçada garante suporte confortável durante todo o dia.

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-ou-beige

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-ou-mpez

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-ou-beige

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-ou-beige

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-ou-beige

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-ou-beige

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-ou-beige

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-ou-bege

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-ou-beige

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-ou-mpez

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-ou-beige

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-ou-beige

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-ou-beige

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-ou-beige

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-ou-beige

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-ou-bege

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

name

string

50223 Toeless 20 make up

netweight

string

nextshipment

string

tomorrow

ordered

number

orderidx

number

origin

string

originalsize

string

packaging

string

productshipment

string

auto

productuid

string

B1437285-0A15-48CA-AC4954EFC25BC58C

promountil

string

rating

string

none

recorduid

string

B1437285-0A15-48CA-AC4954EFC25BC58C

reference

string

SLTI8844

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.5 ms Record Count: 10 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,'1046,1047,1048,1049,1050') > 0 and product_variations.productuid = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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	1046	42-44	intlsize	beige	42	44	-1	999999	6	w	plus	lingerie	L	42-44		42-44	12-14	16-18	44-46	44-46	42-44	48-50	42-44	42-44
2	1046	42-44	intlsize	black	42	44	-1	999999	0	w	plus	lingerie	L	42-44		42-44	12-14	16-18	44-46	44-46	42-44	48-50	42-44	42-44
3	1047	46-48	intlsize	beige	46	48	-1	999999	0	w	plus	lingerie	XL	46-48		46-48	16-18	20-22	48-50	48-50	46-48	52-54	48-50	46-48
4	1047	46-48	intlsize	black	46	48	-1	999999	0	w	plus	lingerie	XL	46-48		46-48	16-18	20-22	48-50	48-50	46-48	52-54	48-50	46-48
5	1048	50-52	intlsize	beige	50	52	-1	999999	0	w	plus	lingerie	2XL	50-52		50-52	20-22	24-26	52-54	52-54	50-52	56-58	52-54	50-52
6	1048	50-52	intlsize	black	50	52	-1	999999	0	w	plus	lingerie	2XL	50-52		50-52	20-22	24-26	52-54	52-54	50-52	56-58	52-54	50-52
7	1049	54-56	intlsize	black	54	56	-1	999999	1	w	plus	lingerie	3XL	54-56		54-56	24-26	28-30	56-58	56-58	54-56	60-62	56-58	54-56
8	1049	54-56	intlsize	beige	54	56	-1	999999	0	w	plus	lingerie	3XL	54-56		54-56	24-26	28-30	56-58	56-58	54-56	60-62	56-58	54-56
9	1050	56-58	intlsize	beige	56	58	-1	999999	1	w	plus	lingerie	4XL	56-58		56-58	26-28	30-32	58-60	58-60	56-58	62-64	58-60	56-58
10	1050	56-58	intlsize	black	56	58	-1	999999	0	w	plus	lingerie	4XL	56-58		56-58	26-28	30-32	58-60	58-60	56-58	62-64	58-60	56-58

sizeranges

string

plus

sizes

string

1046,1047,1048,1049,1050

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: 55.2 ms Record Count: 10 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' and product_variations.isactive = 1 and product_sizes.id_size = 1046 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' and product_variations.isactive = 1 and product_sizes.id_size = 1047 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' and product_variations.isactive = 1 and product_sizes.id_size = 1048 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' and product_variations.isactive = 1 and product_sizes.id_size = 1049 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' and product_variations.isactive = 1 and product_sizes.id_size = 1050 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	B1437285-0A15-48CA-AC4954EFC25BC58C	32B5994F-F2CD-474E-83CA95F3DCC20C97	1046	beige	#F6DBAC	L	42-44		42-44	12-14	16-18	44-46	44-46	42-44	48-50	42-44	42-44	w	lingerie		42-44	intlsize	14.125	0		STOCK01	6	0	0	-1	0	0	0	0	50223	4260277138172	6	6	all
2	B1437285-0A15-48CA-AC4954EFC25BC58C	A2AAD0E1-89B7-48FE-B2F7CC0BF5EAD62E	1046	black	#000000	L	42-44		42-44	12-14	16-18	44-46	44-46	42-44	48-50	42-44	42-44	w	lingerie		42-44	intlsize	14.125	0		STOCK01	0	0	0	-1	0	0	0	0	50223	4260277138110	-1	0	all
3	B1437285-0A15-48CA-AC4954EFC25BC58C	7CE008F6-FD2E-45FC-A0DCEEF5BFB6D4B6	1047	beige	#F6DBAC	XL	46-48		46-48	16-18	20-22	48-50	48-50	46-48	52-54	48-50	46-48	w	lingerie		46-48	intlsize	14.125	0		STOCK01	0	0	0	-1	0	0	0	0	50223	4260277138189	-1	0	all
4	B1437285-0A15-48CA-AC4954EFC25BC58C	37282DD5-085C-4DFA-B04037A53CA697E4	1047	black	#000000	XL	46-48		46-48	16-18	20-22	48-50	48-50	46-48	52-54	48-50	46-48	w	lingerie		46-48	intlsize	14.125	0		STOCK01	0	0	0	-1	1	0	0	0	50223	4260277138127	-1	0	all
5	B1437285-0A15-48CA-AC4954EFC25BC58C	5F746030-18AD-41BC-A5841F1E399701B3	1048	beige	#F6DBAC	2XL	50-52		50-52	20-22	24-26	52-54	52-54	50-52	56-58	52-54	50-52	w	lingerie		50-52	intlsize	14.125	0		STOCK01	1	0	0	-1	1	2	0	0	50223	4260277138196	-1	0	all
6	B1437285-0A15-48CA-AC4954EFC25BC58C	0FF8B067-AE0B-4A0C-9CD2E1BB05071A78	1048	black	#000000	2XL	50-52		50-52	20-22	24-26	52-54	52-54	50-52	56-58	52-54	50-52	w	lingerie		50-52	intlsize	14.125	0		STOCK01	0	0	0	-1	0	2	0	0	50223	4260277138134	-1	0	all
7	B1437285-0A15-48CA-AC4954EFC25BC58C	17967FDF-6087-4B3C-963A325E5E9C3ED7	1049	beige	#F6DBAC	3XL	54-56		54-56	24-26	28-30	56-58	56-58	54-56	60-62	56-58	54-56	w	lingerie		54-56	intlsize	14.125	0		STOCK01	0	0	0	-1	0	0	0	0	50223	4260277138202	-1	0	all
8	B1437285-0A15-48CA-AC4954EFC25BC58C	02F7F2D5-AEF8-4A80-BE8A83B3DB725AB2	1049	black	#000000	3XL	54-56		54-56	24-26	28-30	56-58	56-58	54-56	60-62	56-58	54-56	w	lingerie		54-56	intlsize	14.125	0		STOCK01	1	0	0	-1	0	0	0	0	50223	4260277138141	1	1	all
9	B1437285-0A15-48CA-AC4954EFC25BC58C	47015F66-30CC-40C3-AC10804C301F86C0	1050	beige	#F6DBAC	4XL	56-58		56-58	26-28	30-32	58-60	58-60	56-58	62-64	58-60	56-58	w	lingerie		56-58	intlsize	14.125	0		STOCK01	1	0	0	-1	0	0	0	0	50223	4260277138219	1	1	all
10	B1437285-0A15-48CA-AC4954EFC25BC58C	31AB031F-63FB-491C-98BF34A940D972EC	1050	black	#000000	4XL	56-58		56-58	26-28	30-32	58-60	58-60	56-58	62-64	58-60	56-58	w	lingerie		56-58	intlsize	14.125	0		STOCK01	0	0	0	-1	0	1	0	0	50223	4260277138158	-1	0	all

subcategory

string

tights

supplier

number

-1

supplierreference

string

50223

tags

string

themes

string

totalvariations

string

type

string

default

unitprice

number

14.125

usageinstructions

string

variations

Query Template: /system/api/product/variations.cfc:171 Execution Time: 20.6 ms Record Count: 10 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' and product_variations.isactive = 1 and product_sizes.id_size = 1046 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' and product_variations.isactive = 1 and product_sizes.id_size = 1047 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' and product_variations.isactive = 1 and product_sizes.id_size = 1048 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' and product_variations.isactive = 1 and product_sizes.id_size = 1049 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' 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 = 'B1437285-0A15-48CA-AC4954EFC25BC58C' and product_variations.isactive = 1 and product_sizes.id_size = 1050 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	32B5994F-F2CD-474E-83CA95F3DCC20C97	1046	beige	#F6DBAC	L	42-44		42-44	12-14	16-18	44-46	44-46	42-44	48-50	42-44	42-44	w	lingerie		42-44	intlsize	14.125	0		STOCK01	6	0	0	-1	0	0	0	0	50223	4260277138172	6	6	-1	6	-1	7	0	14.125	all
2	A2AAD0E1-89B7-48FE-B2F7CC0BF5EAD62E	1046	black	#000000	L	42-44		42-44	12-14	16-18	44-46	44-46	42-44	48-50	42-44	42-44	w	lingerie		42-44	intlsize	14.125	0		STOCK01	0	0	0	-1	0	0	0	0	50223	4260277138110	-1	0	-1	6	-1	0	0	14.125	all
3	7CE008F6-FD2E-45FC-A0DCEEF5BFB6D4B6	1047	beige	#F6DBAC	XL	46-48		46-48	16-18	20-22	48-50	48-50	46-48	52-54	48-50	46-48	w	lingerie		46-48	intlsize	14.125	0		STOCK01	0	0	0	-1	0	0	0	0	50223	4260277138189	-1	0	-1	0	-1	7	0	14.125	all
4	37282DD5-085C-4DFA-B04037A53CA697E4	1047	black	#000000	XL	46-48		46-48	16-18	20-22	48-50	48-50	46-48	52-54	48-50	46-48	w	lingerie		46-48	intlsize	14.125	0		STOCK01	0	0	0	-1	1	0	0	0	50223	4260277138127	-1	0	-1	0	-1	0	0	14.125	all
5	5F746030-18AD-41BC-A5841F1E399701B3	1048	beige	#F6DBAC	2XL	50-52		50-52	20-22	24-26	52-54	52-54	50-52	56-58	52-54	50-52	w	lingerie		50-52	intlsize	14.125	0		STOCK01	1	0	0	-1	1	2	0	0	50223	4260277138196	-1	0	-1	0	-1	7	0	14.125	all
6	0FF8B067-AE0B-4A0C-9CD2E1BB05071A78	1048	black	#000000	2XL	50-52		50-52	20-22	24-26	52-54	52-54	50-52	56-58	52-54	50-52	w	lingerie		50-52	intlsize	14.125	0		STOCK01	0	0	0	-1	0	2	0	0	50223	4260277138134	-1	0	-1	0	-1	0	0	14.125	all
7	17967FDF-6087-4B3C-963A325E5E9C3ED7	1049	beige	#F6DBAC	3XL	54-56		54-56	24-26	28-30	56-58	56-58	54-56	60-62	56-58	54-56	w	lingerie		54-56	intlsize	14.125	0		STOCK01	0	0	0	-1	0	0	0	0	50223	4260277138202	-1	0	-1	1	-1	7	0	14.125	all
8	02F7F2D5-AEF8-4A80-BE8A83B3DB725AB2	1049	black	#000000	3XL	54-56		54-56	24-26	28-30	56-58	56-58	54-56	60-62	56-58	54-56	w	lingerie		54-56	intlsize	14.125	0		STOCK01	1	0	0	-1	0	0	0	0	50223	4260277138141	1	1	-1	1	-1	0	0	14.125	all
9	47015F66-30CC-40C3-AC10804C301F86C0	1050	beige	#F6DBAC	4XL	56-58		56-58	26-28	30-32	58-60	58-60	56-58	62-64	58-60	56-58	w	lingerie		56-58	intlsize	14.125	0		STOCK01	1	0	0	-1	0	0	0	0	50223	4260277138219	1	1	-1	1	-1	7	0	14.125	all
10	31AB031F-63FB-491C-98BF34A940D972EC	1050	black	#000000	4XL	56-58		56-58	26-28	30-32	58-60	58-60	56-58	62-64	58-60	56-58	w	lingerie		56-58	intlsize	14.125	0		STOCK01	0	0	0	-1	0	1	0	0	50223	4260277138158	-1	0	-1	1	-1	0	0	14.125	all

vatrate

number

warehouse

string

Plus size tights without toes and without demarcations

Product description

Technical details

Available sizes

Available colors

INFORMATION

MEMBER AREA

SERVICES

CONTACT US

Plus size tights without toes and without demarcations

Product description

Technical details

Available sizes

Available colors

Newsletter

Change my settings

Save my preferences