Il mio cestino

❌
Totale articoli
Visualizza il carrello
Menu
Vedere le dimensioni
Collant Plaisir Ouvert nero
Doppio clic per ingrandire
SKU: SLTI8843
Collant Plaisir Ouvert nero
FATTO IN
Stock:

Collant aperti di grande taglia, neri. Disponibile fino alla taglia 62.

Taglia:

Non siete sicuri della taglia da scegliere? Consultare la nostra guida alle taglie

Colore:
Quantità:
29.95 €
Aiuto e consulenza
via chat, facebook o e-mail
Restituzione gratuita
entro 15 giorni *

Collant Plaisir Ouvert nero taglia grande

Descrizione del prodotto

Collant a grande apertura per il piacere, nero.

velato, opaco come la seta, extra largo in vita e sulla coscia.

Molto confortevole da indossare, vestibilità perfetta.

Punta rinforzata.

20 denari / 22 DTEX

Combinate la libertà di indossare le calze con la sicurezza di indossare un collant super confortevole.

Dettagli tecnici

Dimensioni disponibili

Disponibile da 4 a 9

Colore disponibile

Nero

Guida alle taglie

Controllare la taglia giusta per voi

Internazionale
  • Coscia
4
  • 49-55
5
  • 56-62
6
  • 62-69
7
  • 69-76
8
  • 76-83
9
  • 83-89
To Top
Visualizza il carrello
Articoli
Totale articoli
Struct
Entries: 108
actions
Array
available
number-1
brand
stringglamory
brandcode
stringgjjm
branding
stringdivasboudoir,legsboudoir
brandmedias
string{"default":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"editorial":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"logo":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""}}
brandmetas
Struct
de
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
el
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
en
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
es
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
fr
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
it
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
nl
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
pt
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
brandname
stringGlamory
breasts
stringna
careinstructions
string
categories
stringdivasboudoir.lingerie.hoisery.crotchless
category
stringhoisery
categorygender
stringm
categorymediadatas
Struct
adult
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string414
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/lingerie/hoisery/collants-ouverts-grande-taille.jpg
type
stringimg
width
string900
divasboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
fetishboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
latexboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
legsboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
lustboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
private
Struct
height
string1016
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/private/default.jpg
type
stringimg
width
string703
smboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
categorysizerange
stringauto
colorinfos
Query
Template: /system/api/product/colors.cfc:13
Execution Time: 0.781 ms
Record Count: 1
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_colors.color as recorduid, product_colors.type, product_colors.code, product_colors.color, product_colors.range, product_colors.hexvalue,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock
from product_colors
left outer join product_variations on product_colors.color = product_variations.color and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
where FIND_IN_SET(product_colors.color,'black') > 0
and product_variations.productuid = '4C1C6979-53F5-47DF-9CDEC1BF5D666004'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1blackcolorblakblackblack#000000-10
colorrange
stringblack
colors
stringblack
colortype
stringcolor
comments
string
compositions
Struct
Entries: 13
coton
string
elastane
string
free
string
leather
string
lycra
string
metal
string
nylon
string
polyamide
string
polyester
string
polyurethane
string
silk
string
spandex
string
viscose
string
datecreated
Date Time (Europe/Paris)
{ts '2019-10-09 09:46:30'}
defect
number0
dimensions
Struct
Entries: 14
acrylicbones
string
backsideheight
string
diameter
string
flatsteelbones
string
frontsideheight
string
fullheight
string
length
string
modestysize
string
panels
string
sides
string
spiralsteelbones
string
totallength
string
unit
stringcm
wiresize
string
display
stringall
displayfrom
string
displayto
string
grossweight
string
hasbrandinfos
booleanfalse
hascareinstructions
booleanfalse
hascolorinfos
booleantrue
hascompositions
booleanfalse
hasdescription
booleantrue
hasdimensions
booleanfalse
hasmaterials
booleanfalse
hasotherspecifications
booleanfalse
haspromo
number0
hasshortdescription
booleantrue
hassizeinfos
booleantrue
hasspecifications
booleanfalse
hasstockinfos
booleanfalse
hasstylingtips
booleanfalse
hasusageinstructions
booleanfalse
hasvariations
booleantrue
import
string
inpromo
number0
instockvariations
string
isactive
number1
iscustommade
number0
isdivasize
number1
isfirstprice
number0
isfixedprice
number0
ishot
number0
isnew
number0
isonline
number0
isoutletprice
number0
itemprice
number24.9583
itempromo
string
key
stringplaisir-ouvert-50121-noir
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-10-04 18:34:50'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.65 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','it')
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('4c1c6979-53f5-47df-9cdec1bf5d666004',lcase(cart_actions.linkedproducts)) > 0 and cart_actions.linkedproducts is not null
)
id_actionbrandinglanguagenamecodetypeminimumOrdermaximumOrderminimumItemsmaximumItemsmaximumUseallowedItemsquotasusedCountlinkedproductslinkedthemeslinkedbrandslinkeditemparamsactiveFromactiveToisActive
linkedproducts
Query
Template: /system/api/products.cfc:1305
Execution Time: 1.42 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','it')
and product_categories.language in ('all','it')
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 <> 'SLTI8843'
group by products.reference
order by products.ishot desc, products.isnew desc, orderidx asc, products.lastupdated desc
productuidreferencetypekeylanguagenamelinkuidcolorsvatratemetadatasdimensionsmediadatastagsthemesisdivasizetotalvariationsvariationlistinpromohaspromoitempromoitempriceunitpricepricespromountilisfixedpriceishotisneworderidxavailablestockinstockvariationsbrandbrandnameshowbranddisplaysizetypeintlsizesizessizerangecategorymediadatascategorysizerangesectioncategorysubcategory
linkuid
string
materials
string
mediadatas
Struct
alt
Struct
height
string
isprivate
string0
rating
stringall
src
string/photobank/products/gjjm/slti8843/50121-black-4.jpg
type
stringimg
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string1920
isprivate
string0
rating
stringall
src
string/photobank/products/gjjm/slti8843/50121-plaisir-ouvert-20-black-plus-size.jpg
type
stringimg
width
string940
variations
Struct
colors
Struct
black
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
mediagallery
string
metadatas
Struct
darkboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
divasboudoir
Struct
de
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringOffene Strumpfhose große Größe offenes Vergnügen, Farbe schwarz.<br /><br />transparent, seidig matt, extra breit in der Taille und am Oberschenkel.<br /><br />Sehr bequem zu tragen, perfekte Passform.<br /><br />Die Spitze ist verstärkt.<br /><br />20 Denier / 22 DTEX<br /><br />Kombinieren Sie die Freiheit, Strümpfe zu tragen, mit der Sicherheit, eine superbequeme Strumpfhose zu tragen.
guid
stringhttps://dev.divasboudoir.com/de/strumpfhose-in-grossen-grossen-plaisir-ouvert-schwarz-schwarz/slti8843.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringOffene Strumpfhose in großen Größen, Farbe Schwarz. Erhältlich bis Größe 62.
keywords
string
title
stringStrumpfhose in großen Größen Plaisir Ouvert schwarz
seotitle
stringStrumpfhose in großen Größen Plaisir Ouvert schwarz
seouri
stringstrumpfhose-in-grossen-grossen-plaisir-ouvert-schwarz-schwarz
specifications
string
stylingtips
string
summary
stringOffene Strumpfhose in großen Größen, Farbe Schwarz. Erhältlich bis Größe 62.
title
stringStrumpfhose Plaisir Ouvert schwarz
usageinstructions
string
el
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringΜεγάλο ανοιχτό καλσόν ευχαρίστησης, μαύρο.<br /><br />διαφανές, μεταξένιο ματ, πολύ φαρδύ στη μέση και το μηρό.<br /><br />Πολύ άνετο στη χρήση, τέλεια εφαρμογή.<br /><br />Ενισχυμένη μύτη.<br /><br />20 Denier / 22 DTEX<br /><br />Συνδυάστε την ελευθερία του να φοράτε κάλτσες με την ασφάλεια του να φοράτε ένα εξαιρετικά άνετο καλσόν.
guid
stringhttps://dev.divasboudoir.com/el/kolan-megaloy-megethoys-plaisir-ouvert-mayro-mayro/slti8843.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringΑνοιχτό καλσόν σε μεγάλο μέγεθος, μαύρο. Διατίθεται μέχρι το μέγεθος 62.
keywords
string
title
stringΚολάν μεγάλου μεγέθους Plaisir Ouvert μαύρο
seotitle
stringΚολάν μεγάλου μεγέθους Plaisir Ouvert μαύρο
seouri
stringkolan-megaloy-megethoys-plaisir-ouvert-mayro-mayro
specifications
string
stylingtips
string
summary
stringΑνοιχτό καλσόν σε μεγάλο μέγεθος, μαύρο. Διατίθεται μέχρι το μέγεθος 62.
title
stringPlaisir Ouvert καλσόν μαύρο
usageinstructions
string
en
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringOpen tights plus size open pleasure, color black.<br /><br />sheer, silky matte, extra wide in waist and thigh.<br /><br />Very comfortable to wear, perfect fit.<br /><br />Reinforced toe.<br /><br />20 Denier / 22 DTEX<br /><br />Combine the freedom of wearing stockings with the security of wearing super-comfortable tights.
guid
stringhttps://dev.divasboudoir.com/en/plus-size-tights-plaisir-ouvert-black-black/slti8843.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringOpen tights plus size, color black. Available up to size 62.
keywords
string
title
stringPlus size tights Plaisir Ouvert black
seotitle
stringPlus size tights Plaisir Ouvert black
seouri
stringplus-size-tights-plaisir-ouvert-black-black
specifications
string
stylingtips
string
summary
stringOpen tights plus size, color black. Available up to size 62.
title
stringPlaisir Ouvert tights black
usageinstructions
string
es
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringMedias de placer abiertas de talla grande, negras.<br /><br />transparentes, mate sedoso, extra anchas en la cintura y el muslo.<br /><br />Muy cómodas de llevar, ajuste perfecto.<br /><br />Puntera reforzada.<br /><br />20 deniers / 22 DTEX<br /><br />Combina la libertad de llevar medias con la seguridad de llevar unos pantys supercómodos.
guid
stringhttps://dev.divasboudoir.com/es/medias-de-talla-grande-plaisir-ouvert-negras-negro/slti8843.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringMedias abiertas de talla grande, negras. Disponibles hasta la talla 62.
keywords
string
title
stringMedias de talla grande Plaisir Ouvert negras
seotitle
stringMedias de talla grande Plaisir Ouvert negras
seouri
stringmedias-de-talla-grande-plaisir-ouvert-negras-negro
specifications
string
stylingtips
string
summary
stringMedias abiertas de talla grande, negras. Disponibles hasta la talla 62.
title
stringMedias Plaisir Ouvert negras
usageinstructions
string
fr
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>Collants ouverts grande taille plaisir ouvert, couleur noir.<br><br>transparents, soyeux mat, extra large dans la taille et la cuisse.<br><br>Tr&egrave;s confortables &agrave; porter, ajusement parfait.&nbsp;<br><br>Pointe renforc&eacute;e.&nbsp;<br><br>20 Denier / 22 DTEX<br><br>Combinez la libert&eacute; de porter des bas avec la s&eacute;curit&eacute; de porter un collant hyper confortable.</p>
guid
stringhttps://dev.divasboudoir.com/fr/collants-grande-taille-plaisir-ouvert-noir-noir/slti8843.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringCollants ouverts grande taille, couleur noir. Disponibles jusqu'à la taille 62.
keywords
string
title
stringCollants grande taille Plaisir Ouvert noir
seotitle
stringCollants grande taille Plaisir Ouvert noir
seouri
stringcollants-grande-taille-plaisir-ouvert-noir-noir
specifications
string
stylingtips
string
summary
string<p>Collants ouverts grande taille, couleur noir. Disponibles jusqu'&agrave; la taille 62.</p>
title
stringCollants Plaisir Ouvert noir
usageinstructions
string
it
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringCollant a grande apertura per il piacere, nero.<br /><br />velato, opaco come la seta, extra largo in vita e sulla coscia.<br /><br />Molto confortevole da indossare, vestibilità perfetta.<br /><br />Punta rinforzata.<br /><br />20 denari / 22 DTEX<br /><br />Combinate la libertà di indossare le calze con la sicurezza di indossare un collant super confortevole.
guid
stringhttps://dev.divasboudoir.com/it/collant-plaisir-ouvert-nero-taglia-grande-nero/slti8843.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringCollant aperti di grande taglia, neri. Disponibile fino alla taglia 62.
keywords
string
title
stringCollant Plaisir Ouvert nero taglia grande
seotitle
stringCollant Plaisir Ouvert nero taglia grande
seouri
stringcollant-plaisir-ouvert-nero-taglia-grande-nero
specifications
string
stylingtips
string
summary
stringCollant aperti di grande taglia, neri. Disponibile fino alla taglia 62.
title
stringCollant Plaisir Ouvert nero
usageinstructions
string
nl
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringGroote maat open pleasure panty, zwart.<br /><br />transparant, zijdeachtig mat, extra wijd in de taille en bovenbenen.<br /><br />Zeer comfortabel om te dragen, perfecte pasvorm.<br /><br />Versterkte teen.<br /><br />20 Denier / 22 DTEX<br /><br />Combineer de vrijheid van het dragen van kousen met de zekerheid van een supercomfortabele panty.
guid
stringhttps://dev.divasboudoir.com/nl/groote-maat-plaisir-ouvert-zwart-zwart/slti8843.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringGroote maat open panty, zwart. Verkrijgbaar tot maat 62.
keywords
string
title
stringGroote maat Plaisir Ouvert zwart
seotitle
stringGroote maat Plaisir Ouvert zwart
seouri
stringgroote-maat-plaisir-ouvert-zwart-zwart
specifications
string
stylingtips
string
summary
stringGroote maat open panty, zwart. Verkrijgbaar tot maat 62.
title
stringPlaisir Ouvert panty zwart
usageinstructions
string
pt
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringCollants de prazer abertos grandes, pretos.<br /><br />transparentes, sedosos e mate, extra largos na cintura e na coxa.<br /><br />Muito confortáveis, ajustam-se perfeitamente.<br /><br />Biqueira reforçada.<br /><br />20 Denier / 22 DTEX<br /><br />Combine a liberdade de usar meias com a segurança de usar collants super confortáveis.
guid
stringhttps://dev.divasboudoir.com/pt/collants-de-tamanho-grande-plaisir-ouvert-preto-preto/slti8843.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringCollants abertos de tamanho grande, pretos. Disponível até ao tamanho 62.
keywords
string
title
stringCollants de tamanho grande Plaisir Ouvert preto
seotitle
stringCollants de tamanho grande Plaisir Ouvert preto
seouri
stringcollants-de-tamanho-grande-plaisir-ouvert-preto-preto
specifications
string
stylingtips
string
summary
stringCollants abertos de tamanho grande, pretos. Disponível até ao tamanho 62.
title
stringCollants Plaisir Ouvert preto
usageinstructions
string
fetishboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
latexboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
legsboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Die <strong>offene Strumpfhose Plaisir</strong> revolutioniert Ihr Dessous-Erlebnis, indem sie auf geniale Weise die Freiheit, Strümpfe zu tragen, mit der Sicherheit und dem Komfort einer hyperbequemen Strumpfhose verbindet.</p> <p>Die <strong>seidig-matte Transparenz</strong> sorgt für ein elegantes und raffiniertes Aussehen. Dieses matte Finish verleiht eine Dimension der Raffinesse, die Ihre Beine ohne den manchmal künstlich wirkenden Glanzeffekt hervorhebt. Jede Bewegung enthüllt die natürliche Schönheit Ihrer Beine auf subtile Weise.</p> <p>Das <strong>extrabreite</strong> Design <strong>im Taillenbereich und an den Oberschenkeln</strong> ist die wichtigste Innovation dieser Strumpfhose. Unangenehme Kompressionen und unschöne Abdrücke gehören der Vergangenheit an. Der großzügige Schnitt schmiegt sich sanft an Ihre Kurven an und bietet auch an langen Tagen einen bemerkenswerten Tragekomfort. Die<strong>perfekte Passform</strong> sorgt dafür, dass die Strumpfhose an Ort und Stelle bleibt, ohne zu verrutschen oder zu rollen.</p> <p>Jedes Detail wurde durchdacht, um ein außergewöhnliches Trageerlebnis zu bieten. Sie vergessen, dass Sie eine Strumpfhose tragen, so absolut bequem ist sie. Die <strong>verstärkte Spitze</strong> zeugt von der Aufmerksamkeit, die auf Qualität und Haltbarkeit gelegt wurde. Dieser Bereich, der oft am empfindlichsten ist, wurde speziell entwickelt, um der täglichen Abnutzung standzuhalten, wodurch die Lebensdauer Ihrer Strumpfhose erheblich verlängert wird. Mit <strong>20 Denier / 22 DTEX</strong> bietet diese Strumpfhose die ideale Feinheit: transparent genug, um elegant zu sein, und blickdicht genug, um beruhigend zu wirken. Sie ist die perfekte Balance zwischen Ästhetik und Praktikabilität.</p> <p>Die<strong>Öffnung</strong> der Strumpfhose bietet Ihnen völlige Freiheit für Ihre intimen Momente, indem sie die Praktikabilität einer Strumpfhose mit der Zugänglichkeit von Strümpfen kombiniert. Sie ist das perfekte Accessoire für alle, die sich nicht zwischen Komfort und Sinnlichkeit entscheiden wollen.</p>
highlights
string<ul> <li><strong>Offene Strumpfhose</strong> für völlige Freiheit</li> <li><strong>Seidig-matte Transparenz</strong> für ein elegantes Aussehen</li> <li><strong>Extra breiter Bund und Oberschenkel</strong> für optimalen Tragekomfort</li> <li><strong>Perfekte Passform</strong> ohne übermäßige Kompression</li> <li><strong>Verstärkte Spitze</strong> für längere Haltbarkeit</li> <li><strong>20 Denier / 22 DTEX</strong> für ideale Feinheit</li> <li><strong>Höchste Qualität</strong></li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringOffene Plaisir-Strumpfhose in großen Größen, schwarz, 20 Denier, seidig matt transparent, extra weit, verstärkte Spitze. Bequemlichkeit und Freiheit. Boudoir-Leggings.
keywords
string
title
stringOffene Strumpfhose Große Größe Plaisir Schwarz | Legs Boudoir
seotitle
stringOffene Strumpfhose Große Größe Plaisir Schwarz 20 Denier
seouri
stringoffene-strumpfhose-grosse-grosse-vergnugen
specifications
string<ul> <li><strong>Typ</strong>: Offene Strumpfhose</li> <li><strong>Farbe</strong>: Schwarz</li> <li><strong>Finish</strong>: Transparent seidig matt</li> <li><strong>Passform</strong>: Extra breite Taille und Oberschenkel</li> <li><strong>stärke</strong>: 20 Denier / 22 DTEX</li> <li><strong>Detail</strong>: Verstärkte Spitze</li> <li><strong>Größen</strong>: Große<strong>Größen</strong> </li> </ul>
stylingtips
string<p>Tragen Sie diese wunderschönen Strumpfhosen unter einem <a href="https://www.legsboudoir.com/de/babydolls-in-großen-Größen/">Babydoll</a> oder über einem <a href="https://www.legsboudoir.com/de/sexy-Sets-in-großen-Größen/">Body</a>. Wenn Sie hier nicht fündig werden, schauen Sie doch mal bei <a href="https://www.divasboudoir.com/de/dessous-in-grossen-grossen/">Diva's Boudoir</a> vorbei, dem Spezialisten für sexy Lingerie in großen Größen.</p>
summary
string<p>Entdecken Sie die <strong>offene Strumpfhose Plaisir</strong>, die perfekte Kombination aus Freiheit und Sicherheit. <strong>Seidenmatte Transparenz</strong>, <strong>extra breite Taille und Oberschenkel</strong>, sie bietet eine <strong>perfekte Passform</strong> und <strong>außergewöhnlichen Komfort</strong>.</p> <p><strong>Verstärkte Spitze,</strong> <strong>20 Denier</strong>.</p> <p>Die Freiheit von Strümpfen mit dem Komfort einer Strumpfhose.</p>
title
stringOffene Strumpfhose Plaisir - Absolute Freiheit und Komfort
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><strong>Το ανοιχτό καλσόν Plaisir</strong> φέρνει επανάσταση στην εμπειρία των εσωρούχων σας, συνδυάζοντας έξυπνα την ελευθερία του να φοράτε κάλτσες με την ασφάλεια και την άνεση του εξαιρετικά άνετου καλσόν.</p> <p>Η <strong>μεταξένια ματ διαφάνεια</strong> χαρίζει μια κομψή, εκλεπτυσμένη εμφάνιση. Αυτό το ματ φινίρισμα προσθέτει μια διάσταση φινέτσας που αναδεικνύει τα πόδια σας χωρίς την ενίοτε τεχνητή λάμψη. Κάθε κίνηση αποκαλύπτει τη φυσική ομορφιά των ποδιών σας με λεπτότητα.</p> <p>Ο <strong>πολύ φαρδύς</strong> σχεδιασμός στη <strong>μέση και τους μηρούς</strong> είναι η κύρια καινοτομία αυτού του καλσόν. Τέρμα οι άβολες συμπιέσεις ή τα αντιαισθητικά σημάδια. Το γενναιόδωρο κόψιμο αγκαλιάζει απαλά τις καμπύλες σας, προσφέροντας αξιοσημείωτη άνεση ακόμα και τις μεγάλες ημέρες. Η<strong>τέλεια εφαρμογή</strong> εξασφαλίζει ότι το καλσόν παραμένει στη θέση του χωρίς να γλιστράει ή να κυλάει.</p> <p>Κάθε λεπτομέρεια έχει μελετηθεί για να προσφέρει μια εξαιρετική εμπειρία φθοράς. Θα ξεχάσετε ότι φοράτε καλσόν, επειδή είναι τόσο άνετο. Η <strong>ενισχυμένη μύτη</strong> είναι απόδειξη της προσοχής που έχει δοθεί στην ποιότητα και την ανθεκτικότητα. Αυτή η περιοχή, που συχνά είναι η πιο ευαίσθητη, έχει σχεδιαστεί ειδικά για να αντέχει στην καθημερινή φθορά, παρατείνοντας σημαντικά τη διάρκεια ζωής του καλσόν σας. Με <strong>20 denier / 22 DTEX</strong>, αυτό το καλσόν προσφέρει την ιδανική λεπτότητα: αρκετά διαφανές για να είναι κομψό, αρκετά αδιαφανές για να είναι καθησυχαστικό. Είναι η τέλεια ισορροπία μεταξύ αισθητικής και πρακτικότητας.</p> <p>Ο τρόπος που<strong>ανοίγει</strong> το καλσόν σας δίνει απόλυτη ελευθερία για προσωπικές στιγμές, συνδυάζοντας την πρακτικότητα του καλσόν με την προσβασιμότητα των καλτσών. Είναι το τέλειο αξεσουάρ για όσες αρνούνται να επιλέξουν ανάμεσα στην άνεση και τον αισθησιασμό.</p>
highlights
string<ul> <li><strong>Ανοιχτό καλσόν</strong> για απόλυτη ελευθερία</li> <li><strong>Μεταξένια ματ διαφάνεια</strong> για κομψή εμφάνιση</li> <li><strong>Εξαιρετικά φαρδιά μέση και μηροί</strong> για βέλτιστη άνεση</li> <li><strong>Τέλεια εφαρμογή</strong> χωρίς υπερβολική συμπίεση</li> <li><strong>Ενισχυμένη μύτη</strong> για επιπλέον ανθεκτικότητα</li> <li><strong>20 denier / 22 DTEX</strong> για ιδανική λεπτότητα</li> <li><strong>Ανώτερη ποιότητα</strong></li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringPlaisir ανοιχτό καλσόν μεγάλου μεγέθους, μαύρο, 20 denier, μεταξένιο ματ διαφανές, πολύ φαρδύ, ενισχυμένη μύτη. Άνεση και ελευθερία. Κολάν μπομπονιέρας.
keywords
string
title
stringΑνοιχτό καλσόν μεγάλο μέγεθος Plaisir μαύρο | Πόδια Μπουντουάρ
seotitle
stringΑνοιχτό καλσόν μεγάλο μέγεθος Plaisir μαύρο 20 Deniers
seouri
stringanoichto-kalson-megalo-megethos-eycharisthsh
specifications
string<ul> <li><strong>Τύπος</strong>: Κολάν με ανοιχτή μύτη</li> <li><strong>Χρώμα</strong>: Μαύρο</li> <li><strong>Φινίρισμα</strong>: Μεταξένια ματ διαφάνεια</li> <li><strong>Κοπή</strong>: Εξαιρετικά μεγάλη μέση και μηρός</li> <li><strong>πάχος</strong>: 20 deniers / 22 DTEX</li> <li><strong>Λεπτομέρεια</strong>: Ενισχυμένη μύτη</li> <li><strong>Μεγέθη</strong>: Large</li> </ul>
stylingtips
string<p>Φορέστε αυτό το υπέροχο καλσόν κάτω από ένα <a href="https://www.legsboudoir.com/el/plus-size-νυχτικά/">νυχτικό</a> ή πάνω από ένα <a href="https://www.legsboudoir.com/el/σέξι-σύνολα-συν-μέγεθος/">κορμάκι</a>. Αν δεν μπορείτε να βρείτε αυτό που ψάχνετε εδώ, μη διστάσετε να επισκεφθείτε <a href="https://www.divasboudoir.com/el/eswroycha-syn-megethos/">το Diva's Boudoir</a>, τον ειδικό στα σέξι εσώρουχα plus-size.</p>
summary
string<p>Ανακαλύψτε <strong>το ανοιχτό καλσόν Plaisir</strong>, τον τέλειο συνδυασμό ελευθερίας και ασφάλειας. <strong>Μεταξένια-ματ διαφάνεια</strong>, <strong>πολύ φαρδιά μέση και μπούτια</strong> για <strong>τέλεια εφαρμογή</strong> και <strong>εξαιρετική άνεση</strong>.</p> <p><strong>Ενισχυμένη μύτη,</strong> <strong>20 denier</strong>.</p> <p>Η ελευθερία των καλτσών με την άνεση του καλσόν.</p>
title
stringPlaisir Open Tights - Απόλυτη ελευθερία και άνεση
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><strong>Plaisir open tights</strong> revolutionize your lingerie experience by ingeniously combining the freedom of wearing stockings with the security and comfort of super-comfortable tights.</p> <p>The <strong>silky matte sheer</strong> gives an elegant, sophisticated look. This matte finish adds a dimension of refinement that enhances your legs without the sometimes artificial shine. Every movement reveals the natural beauty of your legs with subtlety.</p> <p>The <strong>extra-wide</strong> design at <strong>the waist and thighs</strong> is the major innovation of these tights. No more unpleasant compressions and unsightly marks. This generous cut gently hugs your curves, offering remarkable comfort even on long days. The<strong>perfect fit</strong> ensures that the tights stay in place without slipping or rolling.</p> <p>Every detail has been designed to deliver an exceptional wearing experience. You'll forget you're wearing tights, as the comfort is absolute. The <strong>reinforced toe</strong> is testimony to the attention paid to quality and durability. This area, often the most fragile, has been specially designed to withstand daily wear and tear, considerably extending the life of your tights. At <strong>20 denier / 22 DTEX</strong>, these tights offer the ideal thinness: sheer enough to be elegant, opaque enough to be reassuring. It's the perfect balance between aesthetics and practicality.</p> <p><strong>Opening</strong> the pantyhose gives you total freedom for intimate moments, combining the practicality of pantyhose with the accessibility of stockings. The perfect accessory for those who refuse to choose between comfort and sensuality.</p>
highlights
string<ul> <li><strong>Open pantyhose</strong> for total freedom</li> <li><strong>Silky-matt sheer</strong> for an elegant look</li> <li><strong>Extra wide waist and thighs</strong> for optimal comfort</li> <li><strong>Perfect fit</strong> without excessive compression</li> <li><strong>Reinforced toe</strong> for extra durability</li> <li><strong>20 denier / 22 DTEX</strong> for ideal fineness</li> <li><strong>Superior quality</strong></li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringPlaisir black open tights plus size, 20 denier, silky-matt sheer, extra wide, reinforced toe. Comfort and freedom. Boudoir leg.
keywords
string
title
stringOpen Tights Plus Size Plaisir Black | Legs Boudoir
seotitle
stringOpen Tights Plus Size Plaisir Black 20 Deniers
seouri
stringopen-tights-plus-size-plaisir
specifications
string<ul> <li><strong>Type</strong>: Open-toe tights</li> <li><strong>Color</strong>: Black</li> <li><strong>Finish</strong>: Silky matte sheer</li> <li><strong>Cut</strong>: Extra large waist and thigh</li> <li><strong>thickness</strong>: 20 deniers / 22 DTEX</li> <li><strong>Detail</strong>: Reinforced toe</li> <li><strong>Sizes</strong>: Plus size</li> </ul>
stylingtips
string<p>Wear these gorgeous tights under a <a href="https://www.legsboudoir.com/en/plus-size-nighties/">babydoll</a> or over a <a href="https://www.legsboudoir.com/en/sexy-plus-size-sets/">bodysuit</a>. If you can't find what you're looking for here, check out <a href="https://www.divasboudoir.com/en/curvy-lingerie/">Diva's Boudoir</a>, the specialist in sexy plus size lingerie.</p>
summary
string<p>Discover <strong>Plaisir open tights</strong>, the perfect combination of freedom and security. <strong>Silky-matt sheer</strong>, <strong>extra-wide waist and thigh</strong>, for a <strong>perfect fit</strong> and <strong>exceptional comfort</strong>.</p> <p><strong>Reinforced toe,</strong> <strong>20 denier</strong>.</p> <p>The freedom of stockings with the comfort of tights.</p>
title
stringPlaisir Open Tights - Absolute Freedom and Comfort
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><strong>Las medias abiertas Plaisir</strong> revolucionan tu experiencia en lencería combinando ingeniosamente la libertad de llevar medias con la seguridad y comodidad de unas medias supercómodas.</p> <p>La <strong>transparencia mate y sedosa</strong> le confiere un aspecto elegante y sofisticado. Este acabado mate añade una dimensión de refinamiento que realza tus piernas sin el brillo a veces artificial. Cada movimiento revela la belleza natural de tus piernas con sutileza.</p> <p>El diseño <strong>extra ancho</strong> en la <strong>cintura y los muslos</strong> es la mayor innovación de estas mallas. Se acabaron las incómodas compresiones y las antiestéticas marcas. El generoso corte abraza suavemente tus curvas, proporcionando una comodidad extraordinaria incluso en las jornadas más largas. El<strong>ajuste perfecto</strong> garantiza que las mallas permanezcan en su sitio sin deslizarse ni enrollarse.</p> <p>Cada detalle ha sido pensado para proporcionar una experiencia de uso excepcional. Te olvidarás de que llevas mallas porque son muy cómodas. La <strong>puntera reforzada</strong> es una prueba de la atención prestada a la calidad y la durabilidad. Esta zona, a menudo la más frágil, ha sido especialmente diseñada para resistir el desgaste diario, alargando considerablemente la vida de tus mallas. Con <strong>20 deniers / 22 DTEX</strong>, estas mallas ofrecen la finura ideal: lo suficientemente transparentes para ser elegantes, lo suficientemente opacas para ser tranquilizadoras. Es el equilibrio perfecto entre estética y funcionalidad.</p> <p>La forma en que<strong>se abren</strong> los pantys te da total libertad para los momentos íntimos, combinando la practicidad de los pantys con la accesibilidad de las medias. Es el accesorio perfecto para quienes se niegan a elegir entre comodidad y sensualidad.</p>
highlights
string<ul> <li><strong>Mallas abiertas</strong> para una libertad total</li> <li><strong>Transparente mate sedoso</strong> para un aspecto elegante</li> <li><strong>Cintura y muslos extra anchos</strong> para un confort óptimo</li> <li><strong>Ajuste perfecto</strong> sin compresión excesiva</li> <li><strong>Puntera reforzada</strong> para mayor durabilidad</li> <li><strong>20 deniers / 22 DTEX</strong> para una finura ideal</li> <li><strong>Calidad superior</strong></li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringMedias abiertas Plaisir talla grande, negras, 20 deniers, transparentes mate sedoso, extra anchas, puntera reforzada. Comodidad y libertad. Leggings de tocador.
keywords
string
title
stringMedias abiertas talla grande Plaisir Negro | Piernas Boudoir
seotitle
stringMallas abiertas talla grande Plaisir Negro 20 deniers
seouri
stringmedias-abiertas-talla-grande-pleasure
specifications
string<ul> <li><strong>Tipo</strong>: Medias con puntera abierta</li> <li><strong>Color</strong>: Negro</li> <li><strong>Acabado</strong>: Transparente mate sedoso</li> <li><strong>Corte</strong>: Cintura y muslo extra grandes</li> <li><strong>grosor</strong>: 20 deniers / 22 DTEX</li> <li><strong>Detalle</strong>: Puntera reforzada</li> <li><strong>Tallas</strong>: Talla grande</li> </ul>
stylingtips
string<p>Lleva estas preciosas medias bajo un <a href="https://www.legsboudoir.com/es/camisones-talla-grande/">camisón</a> o sobre un <a href="https://www.legsboudoir.com/es/conjuntos-sexy-de-talla-grande/">body</a>. Si no encuentras lo que buscas aquí, no dudes en visitar <a href="https://www.divasboudoir.com/es/lenceria-de-tallas-grandes/">Diva's Boudoir</a>, el especialista en lencería sexy de talla grande.</p>
summary
string<p>Descubra <strong>las mallas abiertas Plaisir</strong>, la combinación perfecta de libertad y seguridad. <strong>Transparencia mate sedosa</strong>, <strong>cintura y muslos extra anchos</strong> para un <strong>ajuste perfecto</strong> y <strong>una comodidad excepcional</strong>.</p> <p><strong>Puntera reforzada,</strong> <strong>20 deniers</strong>.</p> <p>La libertad de las medias con la comodidad de los pantys.</p>
title
stringMallas abiertas Plaisir - Libertad y comodidad absolutas
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Le <strong>collant ouvert Plaisir</strong> r&eacute;volutionne votre exp&eacute;rience de la lingerie en combinant ing&eacute;nieusement la libert&eacute; de porter des bas avec la s&eacute;curit&eacute; et le confort d'un collant hyper confortable.</p> <p>Le&nbsp;<strong>transparent soyeux mat</strong> offre un rendu &eacute;l&eacute;gant et sophistiqu&eacute;. Cette finition mate apporte une dimension de raffinement qui sublime vos jambes sans l'effet brillant parfois artificiel. Chaque mouvement r&eacute;v&egrave;le la beaut&eacute; naturelle de vos jambes avec subtilit&eacute;.</p> <p>La conception&nbsp;<strong>extra large au niveau de la taille et des cuisses</strong> constitue l'innovation majeure de ce collant. Fini les compressions d&eacute;sagr&eacute;ables et les marques disgracieuses. Cette coupe g&eacute;n&eacute;reuse &eacute;pouse vos courbes avec douceur, offrant un confort remarquable m&ecirc;me lors de longues journ&eacute;es. L'<strong>ajustement parfait</strong> garantit que le collant reste en place sans glisser ni rouler.</p> <p>Chaque d&eacute;tail a &eacute;t&eacute; pens&eacute; pour offrir une exp&eacute;rience de port exceptionnelle. Vous oubliez que vous portez un collant tant le confort est absolu. La&nbsp;<strong>pointe renforc&eacute;e</strong> t&eacute;moigne de l'attention port&eacute;e &agrave; la qualit&eacute; et &agrave; la durabilit&eacute;. Cette zone, souvent la plus fragile, a &eacute;t&eacute; sp&eacute;cialement con&ccedil;ue pour r&eacute;sister &agrave; l'usure quotidienne, prolongeant consid&eacute;rablement la vie de votre collant. Avec ses <strong>20 deniers / 22 DTEX</strong>, ce collant offre la finesse id&eacute;ale : suffisamment transparent pour &ecirc;tre &eacute;l&eacute;gant, suffisamment opaque pour &ecirc;tre rassurant. C'est l'&eacute;quilibre parfait entre esth&eacute;tique et praticit&eacute;.</p> <p>L'<strong>ouverture</strong> du collant vous offre une libert&eacute; totale pour vos moments intimes, combinant la praticit&eacute; d'un collant avec l'accessibilit&eacute; des bas. C'est l'accessoire parfait pour celles qui refusent de choisir entre confort et sensualit&eacute;.</p>
highlights
string<ul> <li><strong>Collant ouvert</strong> pour une libert&eacute; totale</li> <li><strong>Transparent soyeux mat</strong> pour un rendu &eacute;l&eacute;gant</li> <li><strong>Extra large taille et cuisses</strong> pour un confort optimal</li> <li><strong>Ajustement parfait</strong> sans compression excessive</li> <li><strong>Pointe renforc&eacute;e</strong> pour une durabilit&eacute; accrue</li> <li><strong>20 deniers / 22 DTEX</strong> pour une finesse id&eacute;ale</li> <li><strong>Qualit&eacute; sup&eacute;rieure</strong></li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringCollant ouvert grande taille Plaisir noir, 20 deniers, transparent soyeux mat, extra large, pointe renforcée. Confort et liberté. Legs Boudoir.
keywords
string
title
stringCollant Ouvert Grande Taille Plaisir Noir | Legs Boudoir
seotitle
stringCollant Ouvert Grande Taille Plaisir Noir 20 Deniers
seouri
stringcollant-ouvert-grande-taille-plaisir
specifications
string<ul> <li><strong>Type</strong> : Collant ouvert</li> <li><strong>Couleur</strong> : Noir</li> <li><strong>Finition</strong> : Transparent soyeux mat</li> <li><strong>Coupe</strong> : Extra large taille et cuisses</li> <li><strong>&Eacute;paisseur</strong> : 20 deniers / 22 DTEX</li> <li><strong>D&eacute;tail</strong> : Pointe renforc&eacute;e</li> <li><strong>Tailles</strong> : Grande taille</li> </ul>
stylingtips
string<p>Portez ces superbes collants sous une <a href="https://www.legsboudoir.com/fr/nuisettes-grande-taille/">nuisette</a> ou sur un <a href="https://www.legsboudoir.com/fr/ensembles-sexy-grande-taille/">body</a>. Si vous ne trouvez pas votre bonheur ici, n'h&eacute;sitez pas &agrave; aller faire un tour sur <a href="https://www.divasboudoir.com/fr/lingerie-grande-taille/">Diva's Boudoir</a>, le sp&eacute;cialiste de la lingerie sexy grande taille.</p>
summary
string<p>D&eacute;couvrez le <strong>collant ouvert Plaisir</strong>, l'alliance parfaite entre libert&eacute; et s&eacute;curit&eacute;. <strong>Transparent soyeux mat</strong>, <strong>extra large taille et cuisses</strong>, il offre un <strong>ajustement parfait</strong> et un <strong>confort exceptionnel</strong>.</p> <p><strong>Pointe renforc&eacute;e</strong>, <strong>20 deniers</strong>.</p> <p>La libert&eacute; des bas avec le confort d'un collant.</p>
title
stringCollant Ouvert Plaisir - Liberté et Confort Absolu
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>I <strong>collant aperti Plaisir</strong> rivoluzionano l'esperienza della lingerie combinando in modo ingegnoso la libertà di indossare le calze con la sicurezza e il comfort di un collant super confortevole.</p> <p>La <strong>trasparenza setosa e opaca</strong> conferisce un aspetto elegante e sofisticato. Questa finitura opaca aggiunge una dimensione di raffinatezza che esalta le gambe senza la lucentezza a volte artificiale. Ogni movimento rivela la bellezza naturale delle gambe con delicatezza.</p> <p>Il design <strong>extra-largo</strong> in <strong>vita e sulle cosce</strong> è la principale innovazione di questi collant. Niente più compressioni scomode o segni antiestetici. Il taglio generoso abbraccia delicatamente le vostre curve, offrendo un notevole comfort anche nelle giornate più lunghe. La<strong>perfetta vestibilità</strong> garantisce che il collant rimanga al suo posto senza scivolare o arrotolarsi.</p> <p>Ogni dettaglio è stato pensato per offrire un'esperienza d'uso eccezionale. Vi dimenticherete di indossare i collant perché sono così comodi. La <strong>punta rinforzata</strong> è la prova dell'attenzione prestata alla qualità e alla durata. Questa zona, spesso la più fragile, è stata appositamente studiata per resistere all'usura quotidiana, prolungando notevolmente la vita del collant. Con <strong>20 denari / 22 DTEX</strong>, questo collant offre la sottigliezza ideale: abbastanza velato per essere elegante, abbastanza coprente per essere rassicurante. È il perfetto equilibrio tra estetica e praticità.</p> <p>Il modo in cui il collant<strong>si apre</strong> offre una libertà totale per i momenti di intimità, combinando la praticità dei collant con l'accessibilità delle calze. È l'accessorio perfetto per chi si rifiuta di scegliere tra comfort e sensualità.</p>
highlights
string<ul> <li><strong>Collant aperti</strong> per una libertà totale</li> <li><strong>Trasparente opaco e setoso</strong> per un look elegante</li> <li><strong>Vita e cosce extra larghe</strong> per un comfort ottimale</li> <li><strong>Vestibilità perfetta</strong> senza eccessiva compressione</li> <li><strong>Punta rinforzata</strong> per una maggiore durata</li> <li><strong>20 denari / 22 DTEX</strong> per una finezza ideale</li> <li><strong>Qualità superiore</strong></li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringCollant aperto Plaisir taglia grande, nero, 20 denari, velato opaco, extra largo, punta rinforzata. Comfort e libertà. Leggings da boudoir.
keywords
string
title
stringCollant aperti Taglia grande Plaisir Nero | Gambe Boudoir
seotitle
stringCollant aperto taglia grande Plaisir nero 20 denari
seouri
stringcollant-aperti-taglia-grande-piacere
specifications
string<ul> <li><strong>Tipo</strong>: Collant aperti</li> <li><strong>Colore</strong>: Nero</li> <li><strong>Finitura</strong>: Trasparente opaco e setoso</li> <li><strong>Taglio</strong>: Vita e coscia extra large</li> <li><strong>spessore</strong>: 20 denari / 22 DTEX</li> <li><strong>Dettaglio</strong>: Punta rinforzata</li> <li><strong>Taglie</strong>: Grande</li> </ul>
stylingtips
string<p>Indossate questi splendidi collant sotto una <a href="https://www.legsboudoir.com/it/camicie-da-notte-taglia-grande/">camicia da notte</a> o sopra un <a href="https://www.legsboudoir.com/it/set-sexy-taglia-grande/">body</a>. Se non trovate quello che cercate qui, non esitate a visitare <a href="https://www.divasboudoir.com/it/plus-size-lingerie/">Diva's Boudoir</a>, lo specialista della lingerie sexy per taglie grandi.</p>
summary
string<p>Scoprite i <strong>collant aperti Plaisir</strong>, la combinazione perfetta di libertà e sicurezza. <strong>Velatura setosa e opaca</strong>, <strong>vita e cosce extra larghe</strong> per una <strong>vestibilità perfetta</strong> e un <strong>comfort eccezionale</strong>.</p> <p><strong>Punta rinforzata,</strong> <strong>20 denari</strong>.</p> <p>La libertà delle calze con il comfort dei collant.</p>
title
stringCollant aperti Plaisir - Libertà e comfort assoluti
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><strong>Plaisir open panty's</strong> revolutioneren je lingerie-ervaring door op ingenieuze wijze de vrijheid van het dragen van kousen te combineren met de veiligheid en het comfort van een supercomfortabele panty.</p> <p>De <strong>zijdezachte, matte transparante stof</strong> geeft een elegante, geraffineerde look. Deze matte afwerking voegt een dimensie van verfijning toe die je benen verfraait zonder de soms kunstmatige glans. Bij elke beweging komt de natuurlijke schoonheid van je benen subtiel naar voren.</p> <p>Het <strong>extra brede</strong> ontwerp bij <strong>de taille en dijen</strong> is de belangrijkste innovatie van deze panty. Geen oncomfortabele compressies of lelijke vlekken meer. De royale snit omhelst zachtjes je rondingen en biedt opmerkelijk comfort, zelfs op lange dagen. De<strong>perfecte pasvorm</strong> zorgt ervoor dat de panty op zijn plaats blijft zitten zonder af te glijden of te rollen.</p> <p>Aan elk detail is gedacht voor een uitzonderlijke draagervaring. Je vergeet dat je een panty draagt omdat hij zo comfortabel is. De <strong>versterkte teen</strong> is een bewijs van de aandacht voor kwaliteit en duurzaamheid. Deze zone, die vaak het meest kwetsbaar is, is speciaal ontworpen om bestand te zijn tegen dagelijkse slijtage, waardoor de levensduur van je panty aanzienlijk wordt verlengd. Met <strong>20 denier / 22 DTEX</strong> biedt deze panty de ideale dunheid: transparant genoeg om elegant te zijn, ondoorzichtig genoeg om geruststellend te zijn. Het is de perfecte balans tussen esthetiek en functionaliteit.</p> <p>De manier waarop de panty<strong>opengaat</strong> geeft je volledige vrijheid voor intieme momenten, waarbij het praktische van een panty wordt gecombineerd met de toegankelijkheid van kousen. Het is het perfecte accessoire voor wie weigert te kiezen tussen comfort en sensualiteit.</p>
highlights
string<ul> <li><strong>Open panty</strong> voor totale vrijheid</li> <li><strong>Zijdeachtige matte transparante</strong> voor een elegante look</li> <li><strong>Extra brede taille en dijen</strong> voor optimaal comfort</li> <li><strong>Perfecte pasvorm</strong> zonder overmatige compressie</li> <li><strong>Versterkte teen</strong> voor extra duurzaamheid</li> <li><strong>20 denier / 22 DTEX</strong> voor ideale fijnheid</li> <li><strong>Superieure kwaliteit</strong></li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringPlaisir grote maat open panty, zwart, 20 denier, zijdemat doorschijnend, extra wijd, versterkte teen. Comfort en vrijheid. Boudoir legging.
keywords
string
title
stringOpen panty grote maat Plaisir zwart benen Boudoir
seotitle
stringOpen panty grote maat Plaisir zwart 20 Deniers
seouri
stringopen-panty-grote-maat-plezier
specifications
string<ul> <li><strong>Type</strong>: Panty met open teen</li> <li><strong>Kleur</strong>: Zwart</li> <li><strong>Afwerking</strong>: Zijdeachtige matte transparante</li> <li><strong>Snit</strong>: Extra grote taille en dij</li> <li><strong>dikte</strong>: 20 deniers / 22 DTEX</li> <li><strong>Detail</strong>: Versterkte teen</li> <li><strong>Maten</strong>: Grote maten</li> </ul>
stylingtips
string<p>Draag deze prachtige panty onder een <a href="https://www.legsboudoir.com/nl/nachthemden-grote-maten/">nachtpon</a> of over een <a href="https://www.legsboudoir.com/nl/sexy-grote-maten-setjes/">body</a>. Als je hier niet vindt wat je zoekt, ga dan naar <a href="https://www.divasboudoir.com/nl/lingerie-groote-maat/">Diva's Boudoir</a>, de specialist in sexy lingerie voor grote maten.</p>
summary
string<p>Ontdek <strong>de Plaisir open panty</strong>, de perfecte combinatie van vrijheid en zekerheid. <strong>Zijdezacht,</strong> <strong>extra brede tailleband en dijen</strong> voor een <strong>perfecte pasvorm</strong> en <strong>uitzonderlijk comfort</strong>.</p> <p><strong>Versterkte teen,</strong> <strong>20 denier</strong>.</p> <p>De vrijheid van kousen met het comfort van panty's.</p>
title
stringPlaisir Open Panty - Absolute vrijheid en comfort
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><strong>Os collants abertos Plaisir</strong> revolucionam a sua experiência de lingerie, combinando de forma engenhosa a liberdade de usar meias com a segurança e o conforto de collants superconfortáveis.</p> <p>A <strong>transparência sedosa e mate</strong> confere um aspeto elegante e sofisticado. Este acabamento mate acrescenta uma dimensão de requinte que realça as suas pernas sem o brilho por vezes artificial. Cada movimento revela a beleza natural das suas pernas com subtileza.</p> <p>O design <strong>extra largo</strong> na <strong>cintura e nas coxas</strong> é a grande inovação destes collants. Acabaram-se as compressões incómodas e as marcas inestéticas. O corte generoso abraça suavemente as suas curvas, proporcionando um conforto notável mesmo em dias longos. O<strong>ajuste perfeito</strong> garante que os collants se mantêm no sítio sem escorregar ou enrolar.</p> <p>Todos os pormenores foram pensados para proporcionar uma experiência de utilização excecional. Até se esquece que está a usar collants, de tão confortáveis que são. A <strong>biqueira reforçada</strong> é a prova da atenção dada à qualidade e à durabilidade. Esta zona, frequentemente a mais frágil, foi especialmente concebida para resistir ao desgaste diário, prolongando consideravelmente a vida útil dos seus collants. Com <strong>20 denier / 22 DTEX</strong>, estes collants oferecem a espessura ideal: suficientemente transparentes para serem elegantes, mas suficientemente opacos para serem tranquilizadores. É o equilíbrio perfeito entre estética e praticidade.</p> <p>A<strong>abertura</strong> dos collants dá-lhe total liberdade para os momentos íntimos, combinando a praticidade dos collants com a acessibilidade das meias. É o acessório perfeito para quem não quer escolher entre conforto e sensualidade.</p>
highlights
string<ul> <li><strong>Collants abertos</strong> para uma liberdade total</li> <li>Tecido<strong>transparente mate sedoso</strong> para um visual elegante</li> <li><strong>Cintura e coxas extra largas</strong> para um conforto ótimo</li> <li><strong>Ajuste perfeito</strong> sem compressão excessiva</li> <li><strong>Biqueira reforçada</strong> para maior durabilidade</li> <li><strong>20 denier / 22 DTEX</strong> para uma finura ideal</li> <li><strong>Qualidade superior</strong></li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringMeias-calças abertas Plaisir tamanho grande, pretas, 20 denier, sedosas e mate, extra largas, biqueira reforçada. Conforto e liberdade. Leggings boudoir.
keywords
string
title
stringCollants abertos Tamanho grande Plaisir Preto | Legs Boudoir
seotitle
stringCollants abertos Tamanho grande Plaisir Preto 20 Deniers
seouri
stringcollants-abertos-tamanho-grande-prazer
specifications
string<ul> <li><strong>Tipo</strong>: Collants de biqueira aberta</li> <li><strong>Cor</strong>: Preto</li> <li><strong>Acabamento</strong>: Sedoso mate transparente</li> <li><strong>Corte</strong>: Extra largo na cintura e nas coxas</li> <li><strong>espessura</strong>: 20 deniers / 22 DTEX</li> <li><strong>Pormenores</strong>: Biqueira reforçada</li> <li><strong>Tamanhos</strong>: Grande</li> </ul>
stylingtips
string<p>Use estes lindos collants por baixo de uma camisa <a href="https://www.legsboudoir.com/pt/camisas-de-noite-plus-size/">de noite</a> ou por cima de um <a href="https://www.legsboudoir.com/pt/conjuntos-sexy-plus-size/">body</a>. Se não encontrar aqui o que procura, não hesite em visitar a <a href="https://www.divasboudoir.com/pt/lingerie-tamanho-grande/">Diva's Boudoir</a>, a especialista em lingerie sexy plus size.</p>
summary
string<p>Descubra <strong>os collants abertos Plaisir</strong>, a combinação perfeita de liberdade e segurança. <strong>Cós e coxas extra largos</strong> para um <strong>ajuste perfeito</strong> e um <strong>conforto excecional</strong>.</p> <p><strong>Biqueira reforçada,</strong> <strong>20 denier</strong>.</p> <p>A liberdade das meias com o conforto dos collants.</p>
title
stringCollants abertos Plaisir - Liberdade e conforto absolutos
usageinstructions
string
lustboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
smboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
name
stringplaisir ouvert 50121 noir
netweight
string
nextshipment
stringtomorrow
ordered
number97
orderidx
number0
origin
stringeu
originalsize
string
packaging
string
productshipment
stringauto
productuid
string4C1C6979-53F5-47DF-9CDEC1BF5D666004
promountil
string
rating
stringnone
recorduid
string4C1C6979-53F5-47DF-9CDEC1BF5D666004
reference
stringSLTI8843
related
string
reserved
string
returned
number0
returnsallowed
number1
section
stringlingerie
shipment
string4to6days
showbrand
number0
sizeinfos
Query
Template: /system/api/product/sizes.cfc:20
Execution Time: 1.53 ms
Record Count: 6
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_sizes.id_size as recorduid, if(intlsize <> '',intlsize,eusize) as size, if(intlsize <> '','intlsize','eusize') as sizetype,
product_variations.color,
if(product_sizes.sizegroup = 'bra',
if(intlsize <> '', cast(intlsize as SIGNED ), cast(eusize as SIGNED ))
,
SUBSTRING_INDEX(intlsize,'-',1)
) as param1,
if(product_sizes.sizegroup = 'bra',
if(intlsize <> '',
MID(intlsize,length(cast(intlsize as SIGNED ))+1,length(intlsize)),
MID(eusize,length(cast(eusize as SIGNED ))+1,length(eusize))
)
,
SUBSTRING_INDEX(intlsize,'-',-1)
) as param2,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as available,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
999999,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as groupavailable,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
product_sizes.gender, product_sizes.sizerange, product_sizes.sizegroup, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize,
product_sizes.bust, product_sizes.waist, product_sizes.hip, product_sizes.underbust, product_sizes.cup, product_sizes.thigh, product_sizes.legheight, product_sizes.bodyheight, product_sizes.bodyweight
from product_sizes
left outer join product_variations on product_sizes.suppliersize = product_variations.size and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
where FIND_IN_SET(product_sizes.id_size,'1039,1040,1041,1042,1043,1044') > 0
and product_variations.productuid = '4C1C6979-53F5-47DF-9CDEC1BF5D666004'
and intlsize <> 'na'
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_sizes.id_size, product_variations.color
order by FIELD(product_sizes.gender,'w','m'), product_sizes.sizegroup, FIELD(intlsize,'XS','S','S/M','S-M','M','M/L','M-L','L','L-XL','L/XL','XL','0X','0XL','lXL','1X','1X-2X','1X/2X','XL/2XL','XL-2XL','1XL-2XL','2XL','2X','XXL','2X-3X','2X/3X','2XL-3XL','2XL/3XL','XXXL','3XL','3X','3X-4X','3X/4X','3XL-4XL','3XL/4XL','4XL','5XL','5X','5X-6X','5X/6X','5XL-6XL','5XL/6XL','6XL','6X','7XL','7X','8XL','8X'), cast(intlsize as SIGNED ), groupavailable desc, stock desc
recorduidsizesizetypecolorparam1param2availablegroupavailablestockgendersizerangesizegroupsuppliersizeintlsizeincheseusizeussizeuksizefrsizeessizedesizeitsizeptsizeelsizebustwaisthipunderbustcupthighlegheightbodyheightbodyweight
110394intlsizeblack44-19999990wplusstocking4-M440-4210-1214-1642-4442-4440-4246-4842-4440-4249-55
210405intlsizeblack55-19999990wplusstocking5-L542-4412-1416-1844-4644-4642-4448-5044-4642-4456-62
310416intlsizeblack66-19999990wplusstocking6-XL646-4816-1820-2248-5048-5046-4852-5448-5046-4862-69
410427intlsizeblack77-19999991wplusstocking7-2XL748-5018-2022-2450-5250-5248-5054-5650-5248-5069-76
510438intlsizeblack88-19999990wplusstocking8-3XL850-5220-2224-2652-5452-5450-5256-5852-5450-5276-83
610449intlsizeblack99-19999991wplusstocking9-4XL952-5422-2426-2854-5654-5652-5458-6054-5652-5483-89
sizeranges
stringplus
sizes
string1039,1040,1041,1042,1043,1044
sizetype
stringauto
specifications
Struct
Entries: 23
belly
string
bones
string
bra
string
breasts
string
bust
string
closing
string
crochtless
string
cups
string
cut
string
garter
string
halter
string
lacing
string
lining
string
modestypanel
string
panty
string
sheathing
string
sleeves
string
stocking
string
straps
string
stretch
string
suspenders
string
transparency
string
underwires
string
stock
number0
stocks
Query
Template: /system/api/product/stocks.cfc:25
Execution Time: 26.5 ms
Record Count: 6
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 = '4C1C6979-53F5-47DF-9CDEC1BF5D666004'
and product_variations.isactive = 1
and product_sizes.id_size = 1039
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '4C1C6979-53F5-47DF-9CDEC1BF5D666004'
and product_variations.isactive = 1
and product_sizes.id_size = 1040
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '4C1C6979-53F5-47DF-9CDEC1BF5D666004'
and product_variations.isactive = 1
and product_sizes.id_size = 1041
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '4C1C6979-53F5-47DF-9CDEC1BF5D666004'
and product_variations.isactive = 1
and product_sizes.id_size = 1042
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '4C1C6979-53F5-47DF-9CDEC1BF5D666004'
and product_variations.isactive = 1
and product_sizes.id_size = 1043
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '4C1C6979-53F5-47DF-9CDEC1BF5D666004'
and product_variations.isactive = 1
and product_sizes.id_size = 1044
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
) tbl
group by productuid, variationuid, stockuid
order by stockuid, FIELD(gender,'w','m'), sizegroup, FIELD(intlsize,'XS','S','S/M','S-M','M','M/L','M-L','L','L-XL','L/XL','XL','0X','0XL','lXL','1X','1X-2X','1X/2X','XL/2XL','XL-2XL','1XL-2XL','2XL','2X','XXL','2X-3X','2X/3X','2XL-3XL','2XL/3XL','XXXL','3XL','3X','3X-4X','3X/4X','3XL-4XL','3XL/4XL','4XL','5XL','5X','5X-6X','5X/6X','5XL-6XL','5XL/6XL','6XL','6X','7XL','7X','8XL','8X'), cast(intlsize as SIGNED ), color
productuidvariationuidrecorduidcolorhexvaluesuppliersizeintlsizeincheseusizeussizeuksizefrsizeessizedesizeitsizeptsizeelsizegendersizegroupcupsizesizetypeitempriceitempromopromoUntilstockuidwarehouseontourpackagingsupplierreservedorderedreturneddefectmanufacturerreferenceeanavailablestockdisplaycomments
14C1C6979-53F5-47DF-9CDEC1BF5D66600409F24E68-D9F0-4901-8E3EA83F0E46246B1039black#0000004-M440-4210-1214-1642-4442-4440-4246-4842-4440-42wstocking4intlsize24.95830STOCK01000-10200501214260277136222-10all
24C1C6979-53F5-47DF-9CDEC1BF5D66600478215D95-E45A-4733-A8766336D12D66EE1040black#0000005-L542-4412-1416-1844-4644-4642-4448-5044-4642-44wstocking5intlsize24.95830STOCK01000-101300501214260277136239-10all
34C1C6979-53F5-47DF-9CDEC1BF5D66600415686D74-C04D-415F-BE953DEE06F1FE181041black#0000006-XL646-4816-1820-2248-5048-5046-4852-5448-5046-48wstocking6intlsize24.95830STOCK01000-101900501214260277136246-10all
44C1C6979-53F5-47DF-9CDEC1BF5D666004DBE06352-31EF-47D5-B967F8C88F7126031042black#0000007-2XL748-5018-2022-2450-5250-5248-5054-5650-5248-50wstocking7intlsize24.95830STOCK01200-11320050121426027713625311all
54C1C6979-53F5-47DF-9CDEC1BF5D66600414971AE6-CE98-4819-9D61E28CBBCCE4BF1043black#0000008-3XL850-5220-2224-2652-5452-5450-5256-5852-5450-52wstocking8intlsize24.95830STOCK01000-143100501214260277136260-10all
64C1C6979-53F5-47DF-9CDEC1BF5D6660040168F6F0-6ACE-44E0-887F0B388AB77DF21044black#0000009-4XL952-5422-2426-2854-5654-5652-5458-6054-5652-54wstocking9intlsize24.95830STOCK01100-10190050121426027713627711all
subcategory
stringcrotchless
supplier
number-1
supplierreference
string50121
tags
string
themes
stringhot
totalvariations
string
type
stringdefault
unitprice
number24.9583
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 12.3 ms
Record Count: 6
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 = '4C1C6979-53F5-47DF-9CDEC1BF5D666004' 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 = '4C1C6979-53F5-47DF-9CDEC1BF5D666004' 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 = '4C1C6979-53F5-47DF-9CDEC1BF5D666004' 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 = '4C1C6979-53F5-47DF-9CDEC1BF5D666004' 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 = '4C1C6979-53F5-47DF-9CDEC1BF5D666004' 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 = '4C1C6979-53F5-47DF-9CDEC1BF5D666004' 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 = '4C1C6979-53F5-47DF-9CDEC1BF5D666004'
and product_variations.isactive = 1
and product_sizes.id_size = 1039
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '4C1C6979-53F5-47DF-9CDEC1BF5D666004' 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 = '4C1C6979-53F5-47DF-9CDEC1BF5D666004' 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 = '4C1C6979-53F5-47DF-9CDEC1BF5D666004' 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 = '4C1C6979-53F5-47DF-9CDEC1BF5D666004' 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 = '4C1C6979-53F5-47DF-9CDEC1BF5D666004' 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 = '4C1C6979-53F5-47DF-9CDEC1BF5D666004' 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 = '4C1C6979-53F5-47DF-9CDEC1BF5D666004'
and product_variations.isactive = 1
and product_sizes.id_size = 1040
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '4C1C6979-53F5-47DF-9CDEC1BF5D666004' 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 = '4C1C6979-53F5-47DF-9CDEC1BF5D666004' 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 = '4C1C6979-53F5-47DF-9CDEC1BF5D666004' 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 = '4C1C6979-53F5-47DF-9CDEC1BF5D666004' 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 = '4C1C6979-53F5-47DF-9CDEC1BF5D666004' 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 = '4C1C6979-53F5-47DF-9CDEC1BF5D666004' 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 = '4C1C6979-53F5-47DF-9CDEC1BF5D666004'
and product_variations.isactive = 1
and product_sizes.id_size = 1041
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '4C1C6979-53F5-47DF-9CDEC1BF5D666004' 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 = '4C1C6979-53F5-47DF-9CDEC1BF5D666004' 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 = '4C1C6979-53F5-47DF-9CDEC1BF5D666004' 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 = '4C1C6979-53F5-47DF-9CDEC1BF5D666004' 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 = '4C1C6979-53F5-47DF-9CDEC1BF5D666004' 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 = '4C1C6979-53F5-47DF-9CDEC1BF5D666004' 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 = '4C1C6979-53F5-47DF-9CDEC1BF5D666004'
and product_variations.isactive = 1
and product_sizes.id_size = 1042
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '4C1C6979-53F5-47DF-9CDEC1BF5D666004' 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 = '4C1C6979-53F5-47DF-9CDEC1BF5D666004' 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 = '4C1C6979-53F5-47DF-9CDEC1BF5D666004' 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 = '4C1C6979-53F5-47DF-9CDEC1BF5D666004' 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 = '4C1C6979-53F5-47DF-9CDEC1BF5D666004' 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 = '4C1C6979-53F5-47DF-9CDEC1BF5D666004' 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 = '4C1C6979-53F5-47DF-9CDEC1BF5D666004'
and product_variations.isactive = 1
and product_sizes.id_size = 1043
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '4C1C6979-53F5-47DF-9CDEC1BF5D666004' 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 = '4C1C6979-53F5-47DF-9CDEC1BF5D666004' 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 = '4C1C6979-53F5-47DF-9CDEC1BF5D666004' 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 = '4C1C6979-53F5-47DF-9CDEC1BF5D666004' 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 = '4C1C6979-53F5-47DF-9CDEC1BF5D666004' 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 = '4C1C6979-53F5-47DF-9CDEC1BF5D666004' 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 = '4C1C6979-53F5-47DF-9CDEC1BF5D666004'
and product_variations.isactive = 1
and product_sizes.id_size = 1044
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
order by FIELD(gender,'w','m'), sizegroup, FIELD(intlsize,'XS','S','S/M','S-M','M','M/L','M-L','L','L-XL','L/XL','XL','0X','0XL','lXL','1X','1X-2X','1X/2X','XL/2XL','XL-2XL','1XL-2XL','2XL','2X','XXL','2X-3X','2X/3X','2XL-3XL','2XL/3XL','XXXL','3XL','3X','3X-4X','3X/4X','3XL-4XL','3XL/4XL','4XL','5XL','5X','5X-6X','5X/6X','5XL-6XL','5XL/6XL','6XL','6X','7XL','7X','8XL','8X'), cast(intlsize as SIGNED ), color
variationuidrecorduidcolorhexvaluesuppliersizeintlsizeincheseusizeussizeuksizefrsizeessizedesizeitsizeptsizeelsizegendersizegroupcupsizesizetypeitempriceitempromopromoUntilstockuidwarehouseontourpackagingsupplierreservedorderedreturneddefectmanufacturerreferenceeanavailablestockavailablepersizestockpersizeavailablepercolorstockpercolorhaspromounitpricedisplaycomments
109F24E68-D9F0-4901-8E3EA83F0E46246B1039black#0000004-M440-4210-1214-1642-4442-4440-4246-4842-4440-42wstocking4intlsize24.95830STOCK01000-10200501214260277136222-10-10-10024.9583all
278215D95-E45A-4733-A8766336D12D66EE1040black#0000005-L542-4412-1416-1844-4644-4642-4448-5044-4642-44wstocking5intlsize24.95830STOCK01000-101300501214260277136239-10-10-10024.9583all
315686D74-C04D-415F-BE953DEE06F1FE181041black#0000006-XL646-4816-1820-2248-5048-5046-4852-5448-5046-48wstocking6intlsize24.95830STOCK01000-101900501214260277136246-10-10-10024.9583all
4DBE06352-31EF-47D5-B967F8C88F7126031042black#0000007-2XL748-5018-2022-2450-5250-5248-5054-5650-5248-50wstocking7intlsize24.95830STOCK01200-11320050121426027713625311-11-10024.9583all
514971AE6-CE98-4819-9D61E28CBBCCE4BF1043black#0000008-3XL850-5220-2224-2652-5452-5450-5256-5852-5450-52wstocking8intlsize24.95830STOCK01000-143100501214260277136260-10-10-10024.9583all
60168F6F0-6ACE-44E0-887F0B388AB77DF21044black#0000009-4XL952-5422-2426-2854-5654-5652-5458-6054-5652-54wstocking9intlsize24.95830STOCK01100-10190050121426027713627711-11-10024.9583all
vatrate
number20
warehouse
string