Mi cesta

❌
Total de artículos
Ver cesta
Menú
Ver tallas
Mallas con costura trasera
Doble clic para ampliar
SKU: SLTI1539
Mallas con costura trasera
MADE IN
Stock:

Medias de talla grande ultra glamurosas con costura trasera.

Talla:

¿No sabe qué talla elegir? Consulte nuestra guía de tallas

Color:
Cantidad:
24.95 €
Ayuda y consejos
por chat, facebook o correo electrónico
Devoluciones gratuitas
en un plazo de 15 días *

Mallas grandes con costura trasera

Descripción del producto

Medias con costura trasera.

transparentes, mates y ultrasuaves.

Caderas y muslos extra anchos para una comodidad absoluta.

Forma perfecta.

Braga, talón y puntera reforzados.

20 Denier/20 Dtex

Detalles técnicos

Tallas disponibles

Disponible de 38-40 a 56-58

Color disponible

Negro

Consejos de cuidado

  • Se recomienda lavado a mano con jabón suave o en máquina a 30°C máximo en una bolsa de protección
  • Evite los suavizantes que debilitan la elasticidad de las fibras
  • Secar al aire libre en plano, nunca en secadora
  • Manipule con manos limpias y sin joyas para evitar enganchones
  • Para tallas estándar y plus (hasta 64), póngalas delicadamente enrollando la media/panty y evitando tirar
  • Guarde separadamente de prendas con cierres o ganchos que podrían dañarlas
  • Para modelos de fantasía, de rejilla o con patrones, lave del revés para preservar los detalles

Consejos de uso

  • Quítese anillos y joyas antes de ponérselas para evitar enganches
  • Recoja suavemente las pantys enrollándolas desde los dedos hasta el talón
  • Siéntese para mayor comodidad, especialmente para tallas 42-64
  • Inserte su pie y desenrolle gradualmente las pantys por la pierna sin tirar
  • Suba suavemente hasta la cintura, distribuyendo el tejido uniformemente
  • Ajuste la entrepierna entre sus piernas para un confort óptimo
  • Para pantys moldeadoras, asegúrese de que el área de compresión esté bien posicionada
To Top
Ver cesta
Artículos
Total de artículos
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
stringstockings
categories
stringdivasboudoir.lingerie.hoisery.tights
category
stringhoisery
categorygender
stringm
categorymediadatas
Struct
adult
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string410
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/lingerie/hoisery/tights.jpg
type
stringimg
width
string891
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.766 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 = '0F362380-E624-4C90-BAD2F9305AF93EEB'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1blackcolorblakblackblack#000000-11
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 '2020-09-17 10:05:27'}
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
booleantrue
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
booleantrue
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
number20.7917
itempromo
string
key
string50570-amore
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-10-14 10:32:38'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.643 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','es')
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('0f362380-e624-4c90-bad2f9305af93eeb',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.36 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','es')
and product_categories.language in ('all','es')
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 <> 'SLTI1539'
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
string547
isprivate
string0
rating
stringall
src
string/photobank/products/gjjm/slti1539/50570-amore-20-black-plus-size_crop_2.jpg
type
stringimg
width
string493
back
Struct
height
string903
isprivate
string0
rating
stringall
src
string/photobank/products/gjjm/slti1539/collants-couture-grande-taille-curvy-sexy.jpg
type
stringimg
width
string600
default
Struct
height
string908
isprivate
string0
rating
stringall
src
string/photobank/products/gjjm/slti1539/50570-amore-20-black-plus-size_crop.jpg
type
stringimg
width
string681
variations
Struct
colors
Struct
black
Struct
height
string908
isprivate
string0
rating
stringall
src
string/photobank/products/gjjm/slti1539/50570-amore-20-black-plus-size_crop.jpg
type
stringimg
width
string681
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
stringStrumpfhose mit R&uuml;ckennaht.<br /><br />transparent, matt und ultra-seidig.<br /><br />Extra breite H&uuml;ften und Oberschenkel f&uuml;r absoluten Komfort.<br /><br />Perfekte Passform.<br /><br />H&ouml;schen, Ferse und Spitze verst&auml;rkt.<br /><br />20 Denier/20 Dtex
guid
stringhttps://dev.divasboudoir.com/de/strumpfhose-in-grossen-grossen-mit-ruckennaht-schwarz/slti1539.htm
highlights
string
keypoint
string
keywords
stringstrumpfhose, Rückennaht, transparent, matt, seidig, Komfort, verstärkt, 20 Denier, Diva's Boudoir, Dessous, Eleganz, Retro
metas
Struct
description
stringUltra-glamouröse Strumpfhose in großen Größen mit Rückennaht.
keywords
stringstrumpfhose, Rückennaht, transparent, matt, seidig, Komfort, verstärkt, 20 Denier, Diva's Boudoir, Dessous, Eleganz, Retro
title
stringStrumpfhose in großen Größen mit Rückennaht
seotitle
stringStrumpfhose in großen Größen mit Rückennaht
seouri
stringstrumpfhose-in-grossen-grossen-mit-ruckennaht-schwarz
specifications
string
stylingtips
string
summary
stringUltra-glamour&ouml;se Strumpfhose in gro&szlig;en Gr&ouml;&szlig;en mit R&uuml;ckennaht.
title
stringStrumpfhose mit Rückennaht
usageinstructions
string
el
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringΚαλσόν με ραφή στην πλάτη.<br /><br />διαφανές, ματ και εξαιρετικά μεταξένιο.<br /><br />Εξαιρετικά φαρδιά στους γοφούς και τους μηρούς για απόλυτη άνεση.<br /><br />Τέλειο σχήμα.<br /><br />Ενισχυμένο εσώρουχο, φτέρνα και δάχτυλο.<br /><br />20 Denier/20 Dtex
guid
stringhttps://dev.divasboudoir.com/el/megalo-kalson-me-rafh-sthn-plath-mayro/slti1539.htm
highlights
string
keypoint
string
keywords
stringκαλσόν, πίσω ραφή, διάφανο, ματ, μεταξένιο, άνεση, ενισχυμένο, 20 denier, Diva's Boudoir, εσώρουχα, κομψότητα, ρετρό
metas
Struct
description
stringΕξαιρετικά λαμπερό καλσόν plus-size με ραφή στην πλάτη.
keywords
stringκαλσόν, πίσω ραφή, διάφανο, ματ, μεταξένιο, άνεση, ενισχυμένο, 20 denier, Diva's Boudoir, εσώρουχα, κομψότητα, ρετρό
title
stringΜεγάλο καλσόν με ραφή στην πλάτη
seotitle
stringΜεγάλο καλσόν με ραφή στην πλάτη
seouri
stringmegalo-kalson-me-rafh-sthn-plath-mayro
specifications
string
stylingtips
string
summary
stringΕξαιρετικά λαμπερό καλσόν plus-size με ραφή στην πλάτη.
title
stringΚαλσόν με πίσω ραφή
usageinstructions
string
en
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringTights with back seam.<br /><br />sheer, matte and ultra-silky.<br /><br />Extra-wide hips and thighs for absolute comfort.<br /><br />Perfectly shaped.<br /><br />Reinforced panty, heel and toe.<br /><br />20 Denier/20 Dtex
guid
stringhttps://dev.divasboudoir.com/en/plus-size-tights-with-back-seam-black/slti1539.htm
highlights
string
keypoint
string
keywords
stringtights, back seam, sheer, matte, silky, comfort, reinforced, 20 denier, Diva's Boudoir, lingerie, elegance, retro
metas
Struct
description
stringUltra-glamorous plus size tights with back seam.
keywords
stringtights, back seam, sheer, matte, silky, comfort, reinforced, 20 denier, Diva's Boudoir, lingerie, elegance, retro
title
stringPlus size tights with back seam
seotitle
stringPlus size tights with back seam
seouri
stringplus-size-tights-with-back-seam-black
specifications
string
stylingtips
string
summary
stringUltra-glamorous plus size tights with back seam.
title
stringBack-seam tights
usageinstructions
string
es
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringMedias con costura trasera.<br /><br />transparentes, mates y ultrasuaves.<br /><br />Caderas y muslos extra anchos para una comodidad absoluta.<br /><br />Forma perfecta.<br /><br />Braga, tal&oacute;n y puntera reforzados.<br /><br />20 Denier/20 Dtex
guid
stringhttps://dev.divasboudoir.com/es/mallas-grandes-con-costura-trasera-negro/slti1539.htm
highlights
string
keypoint
string
keywords
stringmedias, costura trasera, transparentes, mates, sedosas, comodidad, reforzadas, 20 deniers, Diva's Boudoir, lencería, elegancia, retro
metas
Struct
description
stringMedias de talla grande ultra glamurosas con costura trasera.
keywords
stringmedias, costura trasera, transparentes, mates, sedosas, comodidad, reforzadas, 20 deniers, Diva's Boudoir, lencería, elegancia, retro
title
stringMallas grandes con costura trasera
seotitle
stringMallas grandes con costura trasera
seouri
stringmallas-grandes-con-costura-trasera-negro
specifications
string
stylingtips
string
summary
stringMedias de talla grande ultra glamurosas con costura trasera.
title
stringMallas con costura trasera
usageinstructions
string
fr
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Laissez-vous s&eacute;duire par le style vintage de ces collants &agrave; couture arri&egrave;re. Leur transparence d&eacute;licate et leur aspect mat apporteront une touche de sophistication &agrave; votre tenue.</p> <p class="text-base">Con&ccedil;us pour un confort optimal, ils sont ultra soyeux et &eacute;pousent vos formes avec &eacute;l&eacute;gance. La forme parfaite, la culotte, le talon et la pointe renforc&eacute;s garantissent une durabilit&eacute; accrue. Les hanches et les cuisses sont extra-larges pour plus de confort.</p> <p class="text-base">Avec un grammage de 20 deniers et 20 Dtex, ces collants offrent un &eacute;quilibre parfait entre finesse et r&eacute;sistance. Ils vous offriront une sensation de bien-&ecirc;tre incomparable, tout en sublimant vos jambes avec subtilit&eacute;.</p> </div>
guid
stringhttps://dev.divasboudoir.com/fr/collants-couture-arriere-transparents-lingerie-divas-boudoir-noir/slti1539.htm
highlights
string
keypoint
string
keywords
stringcollants, couture arrière, transparent, mat, soyeux, confort, renforcé, 20 deniers, Diva's Boudoir, lingerie, élégance, rétro
metas
Struct
description
stringDécouvrez nos collants à couture arrière, un symbole d'élégance rétro et de confort. Laissez-vous séduire par leur qualité exceptionnelle sur Diva's Boudoir. 20 deniers.
keywords
stringcollants, couture arrière, transparent, mat, soyeux, confort, renforcé, 20 deniers, Diva's Boudoir, lingerie, élégance, rétro
title
stringCollants Couture Arrière transparents - Lingerie Diva's Boudoir
seotitle
stringCollants Couture Arrière transparents Lingerie Diva's Boudoir
seouri
stringcollants-couture-arriere-transparents-lingerie-divas-boudoir-noir
specifications
string
stylingtips
string
summary
string<p>Succombez au charme intemporel de ces collants &agrave; couture arri&egrave;re. Un symbole d'&eacute;l&eacute;gance r&eacute;tro, con&ccedil;u pour offrir un confort in&eacute;gal&eacute; et sublimer votre silhouette.</p>
title
stringCollants Couture Arrière - Élégance Rétro & Confort Suprême
usageinstructions
string
it
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringCollant con cucitura posteriore.<br /><br />trasparente, opaco e ultra-setoso.<br /><br />Fianchi e cosce extra-large per un comfort assoluto.<br /><br />Forma perfetta.<br /><br />Mutandina, tallone e punta rinforzati.<br /><br />20 denari/20 Dtex
guid
stringhttps://dev.divasboudoir.com/it/collant-di-taglia-grande-con-cucitura-posteriore-nero/slti1539.htm
highlights
string
keypoint
string
keywords
stringcollant, cucitura posteriore, velato, opaco, setoso, comfort, rinforzato, 20 denari, Diva's Boudoir, lingerie, eleganza, retrò
metas
Struct
description
stringCollant taglia grande ultra-glamour con cucitura posteriore.
keywords
stringcollant, cucitura posteriore, velato, opaco, setoso, comfort, rinforzato, 20 denari, Diva's Boudoir, lingerie, eleganza, retrò
title
stringCollant di taglia grande con cucitura posteriore
seotitle
stringCollant di taglia grande con cucitura posteriore
seouri
stringcollant-di-taglia-grande-con-cucitura-posteriore-nero
specifications
string
stylingtips
string
summary
stringCollant taglia grande ultra-glamour con cucitura posteriore.
title
stringCollant con cucitura posteriore
usageinstructions
string
nl
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringPanty met naad aan de achterkant.<br /><br />sheer, mat en ultra-silky.<br /><br />Extra brede heupen en dijen voor absoluut comfort.<br /><br />Perfecte vorm.<br /><br />Versterkt broekje, hiel en teen.<br /><br />20 Denier/20 Dtex
guid
stringhttps://dev.divasboudoir.com/nl/groote-maat-met-naad-aan-de-achterkant-zwart/slti1539.htm
highlights
string
keypoint
string
keywords
stringpanty, rugnaad, doorschijnend, mat, zijdeachtig, comfort, verstevigd, 20 denier, Diva's Boudoir, lingerie, elegantie, retro
metas
Struct
description
stringUltra-glamoureuze panty van groote maat met naad aan de achterkant.
keywords
stringpanty, rugnaad, doorschijnend, mat, zijdeachtig, comfort, verstevigd, 20 denier, Diva's Boudoir, lingerie, elegantie, retro
title
stringGroote maat met naad aan de achterkant
seotitle
stringGroote maat met naad aan de achterkant
seouri
stringgroote-maat-met-naad-aan-de-achterkant-zwart
specifications
string
stylingtips
string
summary
stringUltra-glamoureuze panty van groote maat met naad aan de achterkant.
title
stringAchternaadse panty
usageinstructions
string
pt
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringCollants com costura atrás.<br /><br />transparentes, mate e ultra-silenciosos.<br /><br />Ancas e coxas extra largas para um conforto absoluto.<br /><br />Forma perfeita.<br /><br />Calcinha, calcanhar e biqueira reforçados.<br /><br />20 Denier/20 Dtex
guid
stringhttps://dev.divasboudoir.com/pt/collants-grandes-com-costura-atras-preto/slti1539.htm
highlights
string
keypoint
string
keywords
stringcollants, costura traseira, transparente, mate, sedoso, conforto, reforçado, 20 denier, Diva's Boudoir, lingerie, elegância, retro
metas
Struct
description
stringCollants ultra-glamorosos de tamanho grande com costura traseira.
keywords
stringcollants, costura traseira, transparente, mate, sedoso, conforto, reforçado, 20 denier, Diva's Boudoir, lingerie, elegância, retro
title
stringCollants grandes com costura atrás
seotitle
stringCollants grandes com costura atrás
seouri
stringcollants-grandes-com-costura-atras-preto
specifications
string
stylingtips
string
summary
stringCollants ultra-glamorosos de tamanho grande com costura traseira.
title
stringCollants com costuras nas costas
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<p>Handw&auml;sche empfohlen. Kaltes Wasser. Flach trocknen. Vorsichtige Behandlung.</p>
description
string<p><strong>Retro-Charme neu interpretiert</strong>. Diese Str&uuml;mpfe mit R&uuml;cknaht bringen einen Hauch von Raffinesse in Ihr Outfit. Ihre zarte Transparenz und matte Oberfl&auml;che schaffen einen eleganten und zeitlosen Effekt.</p> <p>Entwickelt f&uuml;r optimalen Komfort, sind sie ultra weich und verf&uuml;gen &uuml;ber extra breite H&uuml;ften und Oberschenkel. Ihr perfekter Sitz schmeichelt Ihren Kurven mit Eleganz. Der verst&auml;rkte Schritt, die verst&auml;rkte Ferse und Spitze garantieren eine erh&ouml;hte Haltbarkeit f&uuml;r l&auml;ngeren Gebrauch.</p>
highlights
string<ul> <li><strong>R&uuml;cknaht</strong> retro</li> <li><strong>20 Denier</strong> transparent</li> <li><strong>Matte Oberfl&auml;che</strong> sophistiziert</li> <li><strong>Ultra weich</strong></li> <li><strong>Extra breite H&uuml;ften und Oberschenkel</strong></li> </ul>
keypoint
string
keywords
stringstrumpfhose, Rückennaht, große Größen, transparent, matt, seidig, Komfort, verstärkt, 20 Denier, Leg's Boudoir, wohlgeformte Beine, alle Größen
metas
Struct
description
stringÜbergröße Strümpfe mit Rücknaht 20 Denier. Matt, ultra weich, extra breite Hüften. Legs Boudoir: Retro-Charme und Komfort garantiert.
keywords
stringstrumpfhose, Rückennaht, große Größen, transparent, matt, seidig, Komfort, verstärkt, 20 Denier, Leg's Boudoir, wohlgeformte Beine, alle Größen
title
stringRücknaht Strümpfe Übergröße | Legs Boudoir
seotitle
stringÜbergröße Rücknaht Strümpfe 20 Denier
seouri
stringuebergroesse-ruecknaht-struempfe-20-denier
specifications
string<ul> <li><strong>Gewicht :</strong> 20 Denier / 20 Dtex</li> <li><strong>Oberfl&auml;che :</strong> Matt und transparent</li> <li><strong>Details :</strong> R&uuml;cknaht, verst&auml;rkter Schritt, verst&auml;rkte Ferse und Spitze</li> <li><strong>Komfort :</strong> Ultra weich, extra breite H&uuml;ften und Oberschenkel</li> <li><strong>Stil :</strong> Retro und sophistiziert</li> <li><strong>Verf&uuml;gbarkeit :</strong> Alle Gr&ouml;&szlig;en, speziell f&uuml;r &Uuml;bergr&ouml;&szlig;e entwickelt</li> </ul>
stylingtips
string<p>Perfekt für :</p> <ul> <li><strong>Retro-Chic-Looks</strong></li> <li><strong>Elegante Outfits</strong></li> <li><strong>Vintage-Stil</strong></li> <li><strong>Besondere Anlässe</strong></li> </ul> <p>Vervollständigen Sie Ihren Look :</p> <ul> <li><a href="https://www.legsboudoir.com/de/strumpfhosen/">Entdecken Sie unsere anderen Strumpfhosen</a></li> <li><a href="https://www.legsboudoir.com/de/selbstfixierende-strumpfe-und-strumpfhosen/">Erkunden Sie unsere Strümpfe</a></li> </ul>
summary
string<p><strong>Str&uuml;mpfe, die Retro-Charme verk&ouml;rpern</strong>. Zarte Transparenz mit <u>R&uuml;cknaht und matter Oberfl&auml;che</u> f&uuml;r einen Hauch von Raffinesse.</p>
title
stringRücknaht Strümpfe - Mattes Retro Flair
usageinstructions
string<p>Diese Str&uuml;mpfe sind leicht anzuziehen. Die extra breite Passform an H&uuml;ften und Oberschenkeln gew&auml;hrleistet optimalen Komfort. Die R&uuml;cknaht muss korrekt positioniert werden f&uuml;r einen perfekten Retro-Effekt. Die Verst&auml;rkungen garantieren eine lange Lebensdauer.</p>
el
Struct
Entries: 14
abstract
string
careinstructions
string<p>&Sigma;&upsilon;&nu;&iota;&sigma;&tau;ά&tau;&alpha;&iota; &pi;&lambda;ύ&sigma;&iota;&mu;&omicron; &sigma;&tau;&omicron; &chi;έ&rho;&iota;. &Kappa;&rho;ύ&omicron; &nu;&epsilon;&rho;ό. &Sigma;&tau;έ&gamma;&nu;&omega;&mu;&alpha; &epsilon;&pi;ί&pi;&epsilon;&delta;&alpha;. &Pi;&rho;&omicron;&sigma;&epsilon;&kappa;&tau;&iota;&kappa;ό&sigmaf; &chi;&epsilon;&iota;&rho;&iota;&sigma;&mu;ό&sigmaf;.</p>
description
string<p><strong>&Rho;&epsilon;&tau;&rho;ό &gamma;&omicron;&eta;&tau;&epsilon;ί&alpha; &epsilon;&pi;&alpha;&nu;&epsilon;&pi;&iota;&nu;&omicron;&eta;&mu;έ&nu;&eta;</strong>. &Alpha;&upsilon;&tau;ό &tau;&omicron; &kappa;&alpha;&lambda;&sigma;ό&nu; &mu;&epsilon; &pi;ί&sigma;&omega; &rho;&alpha;&phi;ή &pi;&rho;&omicron;&sigma;&theta;έ&tau;&epsilon;&iota; &mu;&iota;&alpha; &pi;&iota;&nu;&epsilon;&lambda;&iota;ά &epsilon;&kappa;&lambda;έ&pi;&tau;&upsilon;&nu;&sigma;&eta;&sigmaf; &sigma;&tau;&omicron; &sigma;ύ&nu;&omicron;&lambda;ό &sigma;&alpha;&sigmaf;. &Eta; &lambda;&epsilon;&pi;&tau;ή &delta;&iota;&alpha;&phi;ά&nu;&epsilon;&iota;&alpha; &kappa;&alpha;&iota; &tau;&omicron; &mu;&alpha;&tau; &tau;&epsilon;&lambda;&epsilon;ί&omega;&mu;&alpha; &delta;&eta;&mu;&iota;&omicron;&upsilon;&rho;&gamma;&omicron;ύ&nu; έ&nu;&alpha; &kappa;&omicron;&mu;&psi;ό &kappa;&alpha;&iota; &delta;&iota;&alpha;&chi;&rho;&omicron;&nu;&iota;&kappa;ό &epsilon;&phi;έ.</p> <p>&Sigma;&chi;&epsilon;&delta;&iota;&alpha;&sigma;&mu;έ&nu;&omicron; &gamma;&iota;&alpha; &beta;έ&lambda;&tau;&iota;&sigma;&tau;&eta; ά&nu;&epsilon;&sigma;&eta;, &epsilon;ί&nu;&alpha;&iota; &epsilon;&xi;&alpha;&iota;&rho;&epsilon;&tau;&iota;&kappa;ά &alpha;&pi;&alpha;&lambda;ό &kappa;&alpha;&iota; &delta;&iota;&alpha;&theta;έ&tau;&epsilon;&iota; &pi;&omicron;&lambda;ύ &phi;&alpha;&rho;&delta;&iota;ά &iota;&sigma;&chi;ί&alpha; &kappa;&alpha;&iota; &mu;&eta;&rho;&omicron;ύ&sigmaf;. &Eta; &tau;έ&lambda;&epsilon;&iota;&alpha; &epsilon;&phi;&alpha;&rho;&mu;&omicron;&gamma;ή &tau;&omicron;&upsilon; &alpha;&gamma;&kappa;&alpha;&lambda;&iota;ά&zeta;&epsilon;&iota; &tau;&iota;&sigmaf; &kappa;&alpha;&mu;&pi;ύ&lambda;&epsilon;&sigmaf; &sigma;&alpha;&sigmaf; &mu;&epsilon; &kappa;&omicron;&mu;&psi;ό&tau;&eta;&tau;&alpha;. &Eta; &epsilon;&nu;&iota;&sigma;&chi;&upsilon;&mu;έ&nu;&eta; &pi;&epsilon;&rho;&iota;&omicron;&chi;ή &tau;&eta;&sigmaf; &epsilon;&phi;&eta;&beta;&alpha;ί&alpha;&sigmaf;, &eta; &pi;&tau;έ&rho;&nu;&alpha; &kappa;&alpha;&iota; &eta; &mu;ύ&tau;&eta; &epsilon;&gamma;&gamma;&upsilon;ώ&nu;&tau;&alpha;&iota; &alpha;&upsilon;&xi;&eta;&mu;έ&nu;&eta; &alpha;&nu;&theta;&epsilon;&kappa;&tau;&iota;&kappa;ό&tau;&eta;&tau;&alpha; &gamma;&iota;&alpha; &pi;&alpha;&rho;&alpha;&tau;&epsilon;&tau;&alpha;&mu;έ&nu;&eta; &chi;&rho;ή&sigma;&eta;.</p>
highlights
string<ul> <li><strong>&Pi;ί&sigma;&omega; &rho;&alpha;&phi;ή</strong> &rho;&epsilon;&tau;&rho;ό</li> <li><strong>20 denier</strong> &delta;&iota;&alpha;&phi;&alpha;&nu;έ&sigmaf;</li> <li><strong>&Mu;&alpha;&tau; &tau;&epsilon;&lambda;&epsilon;ί&omega;&mu;&alpha;</strong> &epsilon;&kappa;&lambda;&epsilon;&pi;&tau;&upsilon;&sigma;&mu;έ&nu;&omicron;</li> <li><strong>&Epsilon;&xi;&alpha;&iota;&rho;&epsilon;&tau;&iota;&kappa;ά &alpha;&pi;&alpha;&lambda;ό</strong></li> <li><strong>&Pi;&omicron;&lambda;ύ &phi;&alpha;&rho;&delta;&iota;ά &iota;&sigma;&chi;ί&alpha; &kappa;&alpha;&iota; &mu;&eta;&rho;&omicron;ί</strong></li> </ul>
keypoint
string
keywords
stringκαλσόν, πίσω ραφή, μεγάλο, διάφανο, ματ, μεταξένιο, άνεση, ενισχυμένο, 20 denier, Leg's Boudoir, καλοσχηματισμένα πόδια, όλα τα μεγέθη
metas
Struct
description
stringΚαλσόν μεγάλου μεγέθους με πίσω ραφή 20 denier. Ματ, εξαιρετικά απαλό, πολύ φαρδιά ισχία. Legs Boudoir: ρετρό γοητεία και άνεση εγγυημένα.
keywords
stringκαλσόν, πίσω ραφή, μεγάλο, διάφανο, ματ, μεταξένιο, άνεση, ενισχυμένο, 20 denier, Leg's Boudoir, καλοσχηματισμένα πόδια, όλα τα μεγέθη
title
stringΚαλσόν με Πίσω Ραφή Μεγάλου Μεγέθους | Legs Boudoir
seotitle
stringΚαλσόν Μεγάλου Μεγέθους με Πίσω Ραφή 20 Denier
seouri
stringkalson-megalou-megethous-piso-rafi-20-denier
specifications
string<ul> <li><strong>&Beta;ά&rho;&omicron;&sigmaf; :</strong> 20 denier / 20 Dtex</li> <li><strong>&Tau;&epsilon;&lambda;&epsilon;ί&omega;&mu;&alpha; :</strong> &Mu;&alpha;&tau; &kappa;&alpha;&iota; &delta;&iota;&alpha;&phi;&alpha;&nu;έ&sigmaf;</li> <li><strong>&Lambda;&epsilon;&pi;&tau;&omicron;&mu;έ&rho;&epsilon;&iota;&epsilon;&sigmaf; :</strong> &Pi;ί&sigma;&omega; &rho;&alpha;&phi;ή, &epsilon;&nu;&iota;&sigma;&chi;&upsilon;&mu;έ&nu;&eta; &pi;&epsilon;&rho;&iota;&omicron;&chi;ή &epsilon;&phi;&eta;&beta;&alpha;ί&alpha;&sigmaf;, &epsilon;&nu;&iota;&sigma;&chi;&upsilon;&mu;έ&nu;&eta; &pi;&tau;έ&rho;&nu;&alpha; &kappa;&alpha;&iota; &mu;ύ&tau;&eta;</li> <li><strong>Ά&nu;&epsilon;&sigma;&eta; :</strong> &Epsilon;&xi;&alpha;&iota;&rho;&epsilon;&tau;&iota;&kappa;ά &alpha;&pi;&alpha;&lambda;ό, &pi;&omicron;&lambda;ύ &phi;&alpha;&rho;&delta;&iota;ά &iota;&sigma;&chi;ί&alpha; &kappa;&alpha;&iota; &mu;&eta;&rho;&omicron;ί</li> <li><strong>&Sigma;&tau;&iota;&lambda; :</strong> &Rho;&epsilon;&tau;&rho;ό &kappa;&alpha;&iota; &epsilon;&kappa;&lambda;&epsilon;&pi;&tau;&upsilon;&sigma;&mu;έ&nu;&omicron;</li> <li><strong>&Delta;&iota;&alpha;&theta;&epsilon;&sigma;&iota;&mu;ό&tau;&eta;&tau;&alpha; :</strong> Ό&lambda;&alpha; &tau;&alpha; &mu;&epsilon;&gamma;έ&theta;&eta;, &epsilon;&iota;&delta;&iota;&kappa;ά &sigma;&chi;&epsilon;&delta;&iota;&alpha;&sigma;&mu;έ&nu;&omicron; &gamma;&iota;&alpha; &mu;&epsilon;&gamma;ά&lambda;&alpha; &mu;&epsilon;&gamma;έ&theta;&eta;</li> </ul>
stylingtips
string<p>Ιδανικό για:</p> <ul> <li><strong>Ρετρό κομψές εμφανίσεις</strong></li> <li><strong>Κομψά ρούχα</strong></li> <li><strong>Vintage στυλ</strong></li> <li><strong>Ειδικές περιστάσεις</strong></li> </ul> <p>Ολοκληρώστε την εμφάνισή σας:</p> <ul> <li><a href="https://www.legsboudoir.com/el/kalson/">Ανακαλύψτε τα άλλα καλσόν μας</a></li> <li><a href="https://www.legsboudoir.com/el/kaltses-kai-hold-ups/">Εξερευνήστε τις κάλτσες μας</a></li> </ul>
summary
string<p><strong>&Kappa;&alpha;&lambda;&sigma;ό&nu; &pi;&omicron;&upsilon; &epsilon;&nu;&sigma;&alpha;&rho;&kappa;ώ&nu;&epsilon;&iota; &tau;&eta; &rho;&epsilon;&tau;&rho;ό &gamma;&omicron;&eta;&tau;&epsilon;ί&alpha;</strong>. &Lambda;&epsilon;&pi;&tau;ή &delta;&iota;&alpha;&phi;ά&nu;&epsilon;&iota;&alpha; &mu;&epsilon; <u>&pi;ί&sigma;&omega; &rho;&alpha;&phi;ή &kappa;&alpha;&iota; &mu;&alpha;&tau; &tau;&epsilon;&lambda;&epsilon;ί&omega;&mu;&alpha;</u> &gamma;&iota;&alpha; &mu;&iota;&alpha; &pi;&iota;&nu;&epsilon;&lambda;&iota;ά &epsilon;&kappa;&lambda;έ&pi;&tau;&upsilon;&nu;&sigma;&eta;&sigmaf;.</p>
title
stringΚαλσόν με Πίσω Ραφή - Ματ Ρετρό Γοητεία
usageinstructions
string<p>&Alpha;&upsilon;&tau;ό &tau;&omicron; &kappa;&alpha;&lambda;&sigma;ό&nu; &epsilon;ί&nu;&alpha;&iota; &epsilon;ύ&kappa;&omicron;&lambda;&omicron; &nu;&alpha; &phi;&omicron;&rho;&epsilon;&theta;&epsilon;ί. &Eta; &pi;&omicron;&lambda;ύ &phi;&alpha;&rho;&delta;&iota;ά &epsilon;&phi;&alpha;&rho;&mu;&omicron;&gamma;ή &sigma;&tau;&alpha; &iota;&sigma;&chi;ί&alpha; &kappa;&alpha;&iota; &tau;&omicron;&upsilon;&sigmaf; &mu;&eta;&rho;&omicron;ύ&sigmaf; &epsilon;&gamma;&gamma;&upsilon;ά&tau;&alpha;&iota; &beta;έ&lambda;&tau;&iota;&sigma;&tau;&eta; ά&nu;&epsilon;&sigma;&eta;. &Eta; &pi;ί&sigma;&omega; &rho;&alpha;&phi;ή &pi;&rho;έ&pi;&epsilon;&iota; &nu;&alpha; &tau;&omicron;&pi;&omicron;&theta;&epsilon;&tau;&eta;&theta;&epsilon;ί &sigma;&omega;&sigma;&tau;ά &gamma;&iota;&alpha; έ&nu;&alpha; &tau;έ&lambda;&epsilon;&iota;&omicron; &rho;&epsilon;&tau;&rho;ό &epsilon;&phi;έ. &Omicron;&iota; &epsilon;&nu;&iota;&sigma;&chi;ύ&sigma;&epsilon;&iota;&sigmaf; &epsilon;&gamma;&gamma;&upsilon;ώ&nu;&tau;&alpha;&iota; &mu;&epsilon;&gamma;ά&lambda;&eta; &delta;&iota;ά&rho;&kappa;&epsilon;&iota;&alpha; &zeta;&omega;ή&sigmaf;.</p>
en
Struct
Entries: 14
abstract
string
careinstructions
string<p>Hand wash recommended. Cold water. Flat drying. Delicate handling.</p>
description
string<p><strong>Retro charm reimagined</strong>. These back seam stockings bring a touch of sophistication to your outfit. Their delicate transparency and matte finish create an elegant and timeless effect.</p> <p>Designed for optimal comfort, they are ultra-soft and feature extra-wide hips and thighs. Their perfect fit embraces your curves with elegance. The reinforced gusset, heel, and toe guarantee increased durability for prolonged use.</p>
highlights
string<ul> <li><strong>Back seam</strong> retro</li> <li><strong>20 denier</strong> transparent</li> <li><strong>Matte finish</strong> sophisticated</li> <li><strong>Ultra soft</strong></li> <li><strong>Extra-wide hips and thighs</strong></li> </ul>
keypoint
string
keywords
stringtights, back seam, plus size, sheer, matte, silky, comfort, reinforced, 20 denier, Leg's Boudoir, shapely legs, all sizes
metas
Struct
description
stringPlus size back seam stockings 20 denier. Matte, ultra-soft, extra-wide hips. Legs Boudoir: retro charm and comfort guaranteed.
keywords
stringtights, back seam, plus size, sheer, matte, silky, comfort, reinforced, 20 denier, Leg's Boudoir, shapely legs, all sizes
title
stringBack Seam Stockings Plus Size | Legs Boudoir
seotitle
stringPlus Size Back Seam Stockings 20 Denier
seouri
stringplus-size-back-seam-stockings-20-denier
specifications
string<ul> <li><strong>Weight :</strong> 20 denier / 20 Dtex</li> <li><strong>Finish :</strong> Matte and transparent</li> <li><strong>Details :</strong> Back seam, reinforced gusset, reinforced heel and toe</li> <li><strong>Comfort :</strong> Ultra-soft, extra-wide hips and thighs</li> <li><strong>Style :</strong> Retro and sophisticated</li> <li><strong>Availability :</strong> All sizes, specially designed for plus size</li> </ul>
stylingtips
string<p>Perfect for :</p> <ul> <li><strong>Retro chic looks</strong></li> <li><strong>Elegant outfits</strong></li> <li><strong>Vintage style</strong></li> <li><strong>Special occasions</strong></li> </ul> <p>Complete your look:</p> <ul> <li><a href="https://www.legsboudoir.com/en/tights/">Discover our other tights</a></li> <li><a href="https://www.legsboudoir.com/en/stockings-and-hold-ups/">Explore our stockings</a></li> </ul>
summary
string<p><strong>Stockings that embody retro charm</strong>. Delicate transparency with <u>back seam and matte finish</u> for a touch of sophistication.</p>
title
stringBack Seam Stockings - Matte Retro Charm
usageinstructions
string<p>These stockings are easy to put on. The extra-wide fit around hips and thighs ensures optimal comfort. The back seam should be correctly positioned for a perfect retro effect. The reinforcements guarantee a long lifespan.</p>
es
Struct
Entries: 14
abstract
string
careinstructions
string<p>Lavado a mano recomendado. Agua fr&iacute;a. Secar extendido. Manipulaci&oacute;n delicada.</p>
description
string<p><strong>Encanto retro reinventado</strong>. Estas medias con costura trasera aportan un toque de sofisticaci&oacute;n a su outfit. Su delicada transparencia y acabado mate crean un efecto elegante e intemporal.</p> <p>Dise&ntilde;adas para un confort &oacute;ptimo, son ultra suaves y presentan caderas y muslos extra anchos. Su ajuste perfecto abraza sus curvas con elegancia. La entrepierna, el tal&oacute;n y la punta reforzados garantizan una durabilidad aumentada para un uso prolongado.</p>
highlights
string<ul> <li><strong>Costura trasera</strong> retro</li> <li><strong>20 denier</strong> transparente</li> <li><strong>Acabado mate</strong> sofisticado</li> <li><strong>Ultra suaves</strong></li> <li><strong>Caderas y muslos extra anchos</strong></li> </ul>
keypoint
string
keywords
stringmedias, costura trasera, talla grande, transparentes, mates, sedosas, comodidad, reforzadas, 20 deniers, Leg's Boudoir, piernas torneadas, todas las tallas
metas
Struct
description
stringMedias talla grande con costura trasera 20 denier. Mate, ultra suaves, caderas extra anchas. Legs Boudoir: encanto retro y comodidad garantizados.
keywords
stringmedias, costura trasera, talla grande, transparentes, mates, sedosas, comodidad, reforzadas, 20 deniers, Leg's Boudoir, piernas torneadas, todas las tallas
title
stringMedias Costura Trasera Talla Grande | Legs Boudoir
seotitle
stringMedias Talla Grande Costura Trasera 20 Denier
seouri
stringmedias-talla-grande-costura-trasera-20-denier
specifications
string<ul> <li><strong>Gramaje :</strong> 20 denier / 20 Dtex</li> <li><strong>Acabado :</strong> Mate y transparente</li> <li><strong>Detalles :</strong> Costura trasera, entrepierna reforzada, tal&oacute;n y punta reforzados</li> <li><strong>Confort :</strong> Ultra suaves, caderas y muslos extra anchos</li> <li><strong>Estilo :</strong> Retro y sofisticado</li> <li><strong>Disponibilidad :</strong> Todos los tama&ntilde;os, dise&ntilde;adas especialmente para tallas grandes</li> </ul>
stylingtips
string<p>Perfecto para :</p> <ul> <li><strong>Looks retro chic</strong></li> <li><strong>Trajes elegantes</strong></li> <li><strong>Estilo vintage</strong></li> <li><strong>Ocasiones especiales</strong></li> </ul> <p>Completa tu look:</p> <ul> <li><a href="https://www.legsboudoir.com/es/medias-y-mallas/">Descubre nuestras otras medias</a></li> <li><a href="https://www.legsboudoir.com/es/medias/">Descubra nuestras medias</a></li> </ul>
summary
string<p><strong>Medias que encarnan el encanto retro</strong>. Transparencia delicada con <u>costura trasera y acabado mate</u> para un toque de sofisticaci&oacute;n.</p>
title
stringMedias Costura Trasera - Encanto Retro Mate
usageinstructions
string<p>Estas medias son f&aacute;ciles de poner. El ajuste extra ancho en caderas y muslos garantiza un confort &oacute;ptimo. La costura trasera debe colocarse correctamente para un efecto retro perfecto. Los refuerzos garantizan una larga vida &uacute;til.</p>
fr
Struct
Entries: 14
abstract
string
careinstructions
string<p>Lavage &agrave; la main recommand&eacute;. Eau froide. S&eacute;chage &agrave; plat. Manipulation d&eacute;licate.</p>
description
string<p><strong>Le charme r&eacute;tro revisit&eacute;</strong>. Ces collants &agrave; couture arri&egrave;re apportent une touche de sophistication &agrave; votre tenue. Leur transparence d&eacute;licate et leur aspect mat cr&eacute;ent un effet &eacute;l&eacute;gant et intemporel.</p> <p>Con&ccedil;us pour un confort optimal, ils sont ultra soyeux et disposent de hanches et de cuisses extra-larges. Leur forme parfaite &eacute;pouse vos courbes avec &eacute;l&eacute;gance. La culotte, le talon et la pointe renforc&eacute;s garantissent une durabilit&eacute; accrue pour un usage prolong&eacute;.</p>
highlights
string<ul> <li><strong>Couture arri&egrave;re</strong> r&eacute;tro</li> <li><strong>20 deniers</strong> transparents</li> <li><strong>Aspect mat</strong> sophistiqu&eacute;</li> <li><strong>Ultra soyeux</strong></li> <li><strong>Hanches et cuisses extra-larges</strong></li> </ul>
keypoint
string
keywords
stringcollants, couture arrière, grande taille, transparent, mat, soyeux, confort, renforcé, 20 deniers, Leg's Boudoir, jambes galbées, toutes tailles
metas
Struct
description
stringCollants grande taille couture arrière 20 deniers. Mat, ultra soyeux, hanches extra-larges. Legs Boudoir : charme rétro et confort garantis.
keywords
stringcollants, couture arrière, grande taille, transparent, mat, soyeux, confort, renforcé, 20 deniers, Leg's Boudoir, jambes galbées, toutes tailles
title
stringCollants Couture Arrière Grande Taille | Legs Boudoir
seotitle
stringCollants Grande Taille Couture Arrière 20 Deniers
seouri
stringcollants-grande-taille-couture-arriere-20-deniers
specifications
string<ul> <li><strong>Grammage :</strong> 20 deniers / 20 Dtex</li> <li><strong>Aspect :</strong> Mat et transparent</li> <li><strong>D&eacute;tails :</strong> Couture arri&egrave;re, culotte renforc&eacute;e, talon et pointe renforc&eacute;s</li> <li><strong>Confort :</strong> Ultra soyeux, hanches et cuisses extra-larges</li> <li><strong>Style :</strong> R&eacute;tro et sophistiqu&eacute;</li> <li><strong>Disponibilit&eacute; :</strong> Toutes tailles, sp&eacute;cialement con&ccedil;u pour grande taille</li> </ul>
stylingtips
string<p>Parfaits pour :</p> <ul> <li><strong>Looks r&eacute;tro chic</strong></li> <li><strong>Tenues &eacute;l&eacute;gantes</strong></li> <li><strong>Style vintage</strong></li> <li><strong>Occasions sp&eacute;ciales</strong></li> </ul> <p>Compl&eacute;tez votre look :</p> <ul> <li><a href="https://www.legsboudoir.com/fr/collants/">D&eacute;couvrez nos autres collants</a></li> <li><a href="https://www.legsboudoir.com/fr/bas-et-bas-autofixants/">Explorez nos bas</a></li> </ul>
summary
string<p><strong>Des collants qui incarnent le charme r&eacute;tro</strong>. Transparence d&eacute;licate avec <u>couture arri&egrave;re et aspect mat</u> pour une touche de sophistication.</p>
title
stringCollants Couture Arrière - Charme Rétro Mat
usageinstructions
string<p>Ces collants s'enfilent facilement. La forme extra-large au niveau des hanches et des cuisses assure un confort optimal. La couture arri&egrave;re doit &ecirc;tre bien positionn&eacute;e pour un effet r&eacute;tro parfait. Les renforts garantissent une longue dur&eacute;e de vie.</p>
it
Struct
Entries: 14
abstract
string
careinstructions
string<p>Lavaggio a mano consigliato. Acqua fredda. Asciugatura stesa. Manipolazione delicata.</p>
description
string<p><strong>Fascino retr&ograve; rivisitato</strong>. Queste calze con cucitura posteriore portano un tocco di sophistication al vostro outfit. La loro delicata trasparenza e finitura opaca creano un effetto elegante e senza tempo.</p> <p>Progettate per un comfort ottimale, sono ultra morbide e presentano fianchi e cosce extra large. Il loro perfetto fit abbraccia le vostre curve con eleganza. La zona intima, il tallone e la punta rinforzati garantiscono una maggiore durabilit&agrave; per un uso prolungato.</p>
highlights
string<ul> <li><strong>Cucitura posteriore</strong> retr&ograve;</li> <li><strong>20 denari</strong> trasparente</li> <li><strong>Finitura opaca</strong> raffinata</li> <li><strong>Ultra morbide</strong></li> <li><strong>Fianchi e cosce extra large</strong></li> </ul>
keypoint
string
keywords
stringcollant, cucitura posteriore, taglia grande, velato, opaco, setoso, comfort, rinforzato, 20 denari, Leg's Boudoir, gambe formose, tutte le taglie
metas
Struct
description
stringCalze taglie forti con cucitura posteriore 20 denari. Opache, ultra morbide, fianchi extra large. Legs Boudoir: fascino retrò e comfort garantiti.
keywords
stringcollant, cucitura posteriore, taglia grande, velato, opaco, setoso, comfort, rinforzato, 20 denari, Leg's Boudoir, gambe formose, tutte le taglie
title
stringCalze Cucitura Posteriore Taglie Forti | Legs Boudoir
seotitle
stringCalze Taglie Forti Cucitura Posteriore 20 Denari
seouri
stringcalze-taglie-forti-cucitura-posteriore-20-denari
specifications
string<ul> <li><strong>Grammatura :</strong> 20 denari / 20 Dtex</li> <li><strong>Finitura :</strong> Opaca e trasparente</li> <li><strong>Dettagli :</strong> Cucitura posteriore, zona intima rinforzata, tallone e punta rinforzati</li> <li><strong>Comfort :</strong> Ultra morbide, fianchi e cosce extra large</li> <li><strong>Stile :</strong> Retr&ograve; e raffinato</li> <li><strong>Disponibilit&agrave; :</strong> Tutti i tagli, appositamente progettate per taglie forti</li> </ul>
stylingtips
string<p>Perfetto per :</p> <ul> <li><strong>Look retro chic</strong></li> <li><strong>Abiti eleganti</strong></li> <li><strong>Stile vintage</strong></li> <li><strong>Occasioni speciali</strong></li> </ul> <p>Completa il tuo look:</p> <ul> <li><a href="https://www.legsboudoir.com/it/collant-e-calze/">Scopri gli altri collant</a></li> <li><a href="https://www.legsboudoir.com/it/calze-e-autoreggenti/">Esplora le nostre calze</a></li> </ul>
summary
string<p><strong>Calze che incarnano il fascino retr&ograve;</strong>. Trasparenza delicata con <u>cucitura posteriore e finitura opaca</u> per un tocco di sophistication.</p>
title
stringCalze Cucitura Posteriore - Fascino Retrò Opaco
usageinstructions
string<p>Queste calze sono facili da indossare. L'ampiezza extra nei fianchi e nelle cosce garantisce un comfort ottimale. La cucitura posteriore deve essere posizionata correttamente per un perfetto effetto retr&ograve;. I rinforzi garantiscono una lunga durata.</p>
nl
Struct
Entries: 14
abstract
string
careinstructions
string<p>Handwas aanbevolen. Koud water. Plat laten drogen. Voorzichtige behandeling.</p>
description
string<p><strong>Retro charme opnieuw uitgevonden</strong>. Deze panty's met achternaad brengen een vleugje sophisticatie aan uw outfit. Hun delicate transparantie en matte afwerking cre&euml;ren een elegant en tijdloos effect.</p> <p>Ontworpen voor optimaal comfort, zijn ze ultra zacht en hebben extra brede heupen en dijen. Hun perfecte pasvorm omarmt uw curves met elegantie. De versterkte kruisnaad, hiel en teen garanderen een verhoogde duurzaamheid voor langdurig gebruik.</p>
highlights
string<ul> <li><strong>Achternaad</strong> retro</li> <li><strong>20 denier</strong> transparant</li> <li><strong>Matte afwerking</strong> verfijnd</li> <li><strong>Ultra zacht</strong></li> <li><strong>Extra brede heupen en dijen</strong></li> </ul>
keypoint
string
keywords
stringpanty, achternaad, grote maat, transparant, mat, zijdeachtig, comfort, verstevigd, 20 denier, Leg's Boudoir, mooie benen, alle maten
metas
Struct
description
stringGrote maat panty met achternaad 20 denier. Mat, ultra zacht, extra brede heupen. Legs Boudoir: retro charme en comfort gegarandeerd.
keywords
stringpanty, achternaad, grote maat, transparant, mat, zijdeachtig, comfort, verstevigd, 20 denier, Leg's Boudoir, mooie benen, alle maten
title
stringPanty met Achternaad Grote Maat | Legs Boudoir
seotitle
stringGrote Maat Panty met Achternaad 20 Denier
seouri
stringgrote-maat-panty-achternaad-20-denier
specifications
string<ul> <li><strong>Gewicht :</strong> 20 denier / 20 Dtex</li> <li><strong>Afwerking :</strong> Mat en transparant</li> <li><strong>Details :</strong> Achternaad, versterkte kruisnaad, versterkte hiel en teen</li> <li><strong>Comfort :</strong> Ultra zacht, extra brede heupen en dijen</li> <li><strong>Stijl :</strong> Retro en verfijnd</li> <li><strong>Beschikbaarheid :</strong> Alle maten, speciaal ontworpen voor grote maten</li> </ul>
stylingtips
string<p>Perfect voor :</p> <ul> <li><strong>Retro chique looks</strong></li> <li><strong>Elegante outfits</strong></li> <li><strong>Vintage stijl</strong></li> <li><strong>Speciale gelegenheden</strong></li> </ul> <p>Maak je look compleet:</p> <ul> <li><a href="https://www.legsboudoir.com/nl/panty/">Ontdek onze andere panty's</a></li> <li><a href="https://www.legsboudoir.com/nl/kousen-en-hold-ups/">Ontdek onze kousen</a></li> </ul>
summary
string<p><strong>Panty's die retro charme belichamen</strong>. Delicate transparantie met <u>achternaad en matte afwerking</u> voor een vleugje sophisticatie.</p>
title
stringPanty met Achternaad - Matte Retro Charme
usageinstructions
string<p>Deze panty's zijn gemakkelijk aan te trekken. De extra brede pasvorm rond heupen en dijen zorgt voor optimaal comfort. De achternaad moet correct worden gepositioneerd voor een perfect retro effect. De versterkingen garanderen een lange levensduur.</p>
pt
Struct
Entries: 14
abstract
string
careinstructions
string<p>Lavagem &agrave; m&atilde;o recomendada. &Aacute;gua fria. Secar deitado. Manuseio delicado.</p>
description
string<p><strong>Charme retr&ocirc; reinventado</strong>. Estas meias-cal&ccedil;a com costura traseira trazem um toque de sofistica&ccedil;&atilde;o ao seu visual. Sua transpar&ecirc;ncia delicada e acabamento fosco criam um efeito elegante e atemporal.</p> <p>Projetadas para conforto m&aacute;ximo, s&atilde;o ultra macias e apresentam quadris e coxas extra largas. Seu ajuste perfeito abra&ccedil;a suas curvas com eleg&acirc;ncia. A parte &iacute;ntima, calcanhar e ponta refor&ccedil;ados garantem maior durabilidade para um uso prolongado.</p>
highlights
string<ul> <li><strong>Costura traseira</strong> retr&ocirc;</li> <li><strong>20 denier</strong> transparente</li> <li><strong>Acabamento fosco</strong> sofisticado</li> <li><strong>Ultra macia</strong></li> <li><strong>Quadris e coxas extra largas</strong></li> </ul>
keypoint
string
keywords
stringcollants, costura posterior, grandes, transparentes, mate, sedosos, conforto, reforçados, 20 denier, Leg's Boudoir, pernas torneadas, todos os tamanhos
metas
Struct
description
stringMeia-calça plus size com costura traseira 20 denier. Fosca, ultra macia, quadris extra largos. Legs Boudoir: charme retrô e conforto garantidos.
keywords
stringcollants, costura posterior, grandes, transparentes, mate, sedosos, conforto, reforçados, 20 denier, Leg's Boudoir, pernas torneadas, todos os tamanhos
title
stringMeia-Calça Costura Traseira Plus Size | Legs Boudoir
seotitle
stringMeia-Calça Plus Size Costura Traseira 20 Denier
seouri
stringmeia-calca-plus-size-costura-traseira-20-denier
specifications
string<ul> <li><strong>Gramatura :</strong> 20 denier / 20 Dtex</li> <li><strong>Acabamento :</strong> Fosco e transparente</li> <li><strong>Detalhes :</strong> Costura traseira, parte &iacute;ntima refor&ccedil;ada, calcanhar e ponta refor&ccedil;ados</li> <li><strong>Conforto :</strong> Ultra macia, quadris e coxas extra largas</li> <li><strong>Estilo :</strong> Retr&ocirc; e sofisticado</li> <li><strong>Disponibilidade :</strong> Todos os tamanhos, especialmente projetada para plus size</li> </ul>
stylingtips
string<p>Perfeito para :</p> <ul> <li><strong>Looks retro chiques</strong></li> <li><strong>Roupas elegantes</strong></li> <li><strong>Estilo vintage</strong></li> <li><strong>Ocasiões especiais</strong></li> </ul> <p>Complete o seu look:</p> <ul> <li><a href="https://www.legsboudoir.com/pt/collants-e-meias-de-ligas/">Descubra os nossos outros collants</a></li> <li><a href="https://www.legsboudoir.com/pt/meias-e-meias-de-ligas/">Explore as nossas meias-calças</a></li> </ul>
summary
string<p><strong>Meia-cal&ccedil;a que encarna o charme retr&ocirc;</strong>. Transpar&ecirc;ncia delicada com <u>costura traseira e acabamento fosco</u> para um toque de sofistica&ccedil;&atilde;o.</p>
title
stringMeia-Calça Costura Traseira - Charme Retrô Fosco
usageinstructions
string<p>Estas meias-cal&ccedil;a s&atilde;o f&aacute;ceis de vestir. O ajuste extra largo nos quadris e coxas garante conforto m&aacute;ximo. A costura traseira deve ser posicionada corretamente para um efeito retr&ocirc; perfeito. Os refor&ccedil;os garantem uma longa vida &uacute;til.</p>
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
string50570 amore
netweight
string
nextshipment
stringtomorrow
ordered
number6
orderidx
number0
origin
stringeu
originalsize
string
packaging
string
productshipment
stringauto
productuid
string0F362380-E624-4C90-BAD2F9305AF93EEB
promountil
string
rating
stringnone
recorduid
string0F362380-E624-4C90-BAD2F9305AF93EEB
reference
stringSLTI1539
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.65 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,'2130,1046,1047,1048,1049,1050') > 0
and product_variations.productuid = '0F362380-E624-4C90-BAD2F9305AF93EEB'
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
1213038-40intlsizeblack3840-19999990wpluslingerieM38-4038-408-1012-1440-4240-4238-4044-4640-4238-40
2104642-44intlsizeblack4244-19999991wpluslingerieL42-4442-4412-1416-1844-4644-4642-4448-5042-4442-44
3104746-48intlsizeblack4648-19999990wpluslingerieXL46-4846-4816-1820-2248-5048-5046-4852-5448-5046-48
4104850-52intlsizeblack5052-19999990wpluslingerie2XL50-5250-5220-2224-2652-5452-5450-5256-5852-5450-52
5104954-56intlsizeblack5456-19999990wpluslingerie3XL54-5654-5624-2628-3056-5856-5854-5660-6256-5854-56
6105056-58intlsizeblack5658-19999990wpluslingerie4XL56-5856-5826-2830-3258-6058-6056-5862-6458-6056-58
sizeranges
stringplus
sizes
string2130,1046,1047,1048,1049,1050
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 = '0F362380-E624-4C90-BAD2F9305AF93EEB'
and product_variations.isactive = 1
and product_sizes.id_size = 2130
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 = '0F362380-E624-4C90-BAD2F9305AF93EEB'
and product_variations.isactive = 1
and product_sizes.id_size = 1046
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '0F362380-E624-4C90-BAD2F9305AF93EEB'
and product_variations.isactive = 1
and product_sizes.id_size = 1047
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '0F362380-E624-4C90-BAD2F9305AF93EEB'
and product_variations.isactive = 1
and product_sizes.id_size = 1048
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '0F362380-E624-4C90-BAD2F9305AF93EEB'
and product_variations.isactive = 1
and product_sizes.id_size = 1049
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '0F362380-E624-4C90-BAD2F9305AF93EEB'
and product_variations.isactive = 1
and product_sizes.id_size = 1050
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
) tbl
group by productuid, variationuid, stockuid
order by stockuid, FIELD(gender,'w','m'), sizegroup, FIELD(intlsize,'XS','S','S/M','S-M','M','M/L','M-L','L','L-XL','L/XL','XL','0X','0XL','lXL','1X','1X-2X','1X/2X','XL/2XL','XL-2XL','1XL-2XL','2XL','2X','XXL','2X-3X','2X/3X','2XL-3XL','2XL/3XL','XXXL','3XL','3X','3X-4X','3X/4X','3XL-4XL','3XL/4XL','4XL','5XL','5X','5X-6X','5X/6X','5XL-6XL','5XL/6XL','6XL','6X','7XL','7X','8XL','8X'), cast(intlsize as SIGNED ), color
productuidvariationuidrecorduidcolorhexvaluesuppliersizeintlsizeincheseusizeussizeuksizefrsizeessizedesizeitsizeptsizeelsizegendersizegroupcupsizesizetypeitempriceitempromopromoUntilstockuidwarehouseontourpackagingsupplierreservedorderedreturneddefectmanufacturerreferenceeanavailablestockdisplaycomments
10F362380-E624-4C90-BAD2F9305AF93EEBF1C3A842-C504-4AB7-B6516308D67A66FC2130black#000000M38-4038-408-1012-1440-4240-4238-4044-4640-4238-40wlingerie38-40intlsize20.79170STOCK01000-10000-10all
20F362380-E624-4C90-BAD2F9305AF93EEBA47B6766-B12A-4FB6-B01DF9B6E13ED4011046black#000000L42-4442-4412-1416-1844-4644-4642-4448-5042-4442-44wlingerie42-44intlsize20.79170STOCK01100-1000050570426027713597311all
30F362380-E624-4C90-BAD2F9305AF93EEB27C9667A-77ED-422C-88F5AC80FC831DF81047black#000000XL46-4846-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie46-48intlsize20.79170STOCK01000-10200505704260277135980-10all
40F362380-E624-4C90-BAD2F9305AF93EEBCA344A1D-F4FC-4595-81C701CB5E37FA4E1048black#0000002XL50-5250-5220-2224-2652-5452-5450-5256-5852-5450-52wlingerie50-52intlsize20.79170STOCK01100-11300505704260277135997-10all
50F362380-E624-4C90-BAD2F9305AF93EEB78B8BE8B-E8FF-44FC-AEABE95D75458B4E1049black#0000003XL54-5654-5624-2628-3056-5856-5854-5660-6256-5854-56wlingerie54-56intlsize20.79170STOCK01000-10100505704260277136000-10all
60F362380-E624-4C90-BAD2F9305AF93EEB70150DE5-63C5-431D-B98D24217837F50E1050black#0000004XL56-5856-5826-2830-3258-6058-6056-5862-6458-6056-58wlingerie56-58intlsize20.79170STOCK01000-10200505704260277132835-10all
subcategory
stringtights
supplier
number-1
supplierreference
string50570
tags
string
themes
string
totalvariations
string
type
stringdefault
unitprice
number20.7917
usageinstructions
stringtights
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 12.5 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 = '0F362380-E624-4C90-BAD2F9305AF93EEB' 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 = '0F362380-E624-4C90-BAD2F9305AF93EEB' 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 = '0F362380-E624-4C90-BAD2F9305AF93EEB' 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 = '0F362380-E624-4C90-BAD2F9305AF93EEB' 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 = '0F362380-E624-4C90-BAD2F9305AF93EEB' 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 = '0F362380-E624-4C90-BAD2F9305AF93EEB' 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 = '0F362380-E624-4C90-BAD2F9305AF93EEB'
and product_variations.isactive = 1
and product_sizes.id_size = 2130
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 = '0F362380-E624-4C90-BAD2F9305AF93EEB' 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 = '0F362380-E624-4C90-BAD2F9305AF93EEB' 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 = '0F362380-E624-4C90-BAD2F9305AF93EEB' 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 = '0F362380-E624-4C90-BAD2F9305AF93EEB' 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 = '0F362380-E624-4C90-BAD2F9305AF93EEB' 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 = '0F362380-E624-4C90-BAD2F9305AF93EEB' 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 = '0F362380-E624-4C90-BAD2F9305AF93EEB'
and product_variations.isactive = 1
and product_sizes.id_size = 1046
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '0F362380-E624-4C90-BAD2F9305AF93EEB' 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 = '0F362380-E624-4C90-BAD2F9305AF93EEB' 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 = '0F362380-E624-4C90-BAD2F9305AF93EEB' 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 = '0F362380-E624-4C90-BAD2F9305AF93EEB' 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 = '0F362380-E624-4C90-BAD2F9305AF93EEB' 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 = '0F362380-E624-4C90-BAD2F9305AF93EEB' 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 = '0F362380-E624-4C90-BAD2F9305AF93EEB'
and product_variations.isactive = 1
and product_sizes.id_size = 1047
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '0F362380-E624-4C90-BAD2F9305AF93EEB' 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 = '0F362380-E624-4C90-BAD2F9305AF93EEB' 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 = '0F362380-E624-4C90-BAD2F9305AF93EEB' 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 = '0F362380-E624-4C90-BAD2F9305AF93EEB' 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 = '0F362380-E624-4C90-BAD2F9305AF93EEB' 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 = '0F362380-E624-4C90-BAD2F9305AF93EEB' 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 = '0F362380-E624-4C90-BAD2F9305AF93EEB'
and product_variations.isactive = 1
and product_sizes.id_size = 1048
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '0F362380-E624-4C90-BAD2F9305AF93EEB' 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 = '0F362380-E624-4C90-BAD2F9305AF93EEB' 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 = '0F362380-E624-4C90-BAD2F9305AF93EEB' 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 = '0F362380-E624-4C90-BAD2F9305AF93EEB' 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 = '0F362380-E624-4C90-BAD2F9305AF93EEB' 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 = '0F362380-E624-4C90-BAD2F9305AF93EEB' 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 = '0F362380-E624-4C90-BAD2F9305AF93EEB'
and product_variations.isactive = 1
and product_sizes.id_size = 1049
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '0F362380-E624-4C90-BAD2F9305AF93EEB' 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 = '0F362380-E624-4C90-BAD2F9305AF93EEB' 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 = '0F362380-E624-4C90-BAD2F9305AF93EEB' 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 = '0F362380-E624-4C90-BAD2F9305AF93EEB' 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 = '0F362380-E624-4C90-BAD2F9305AF93EEB' 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 = '0F362380-E624-4C90-BAD2F9305AF93EEB' 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 = '0F362380-E624-4C90-BAD2F9305AF93EEB'
and product_variations.isactive = 1
and product_sizes.id_size = 1050
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
order by FIELD(gender,'w','m'), sizegroup, FIELD(intlsize,'XS','S','S/M','S-M','M','M/L','M-L','L','L-XL','L/XL','XL','0X','0XL','lXL','1X','1X-2X','1X/2X','XL/2XL','XL-2XL','1XL-2XL','2XL','2X','XXL','2X-3X','2X/3X','2XL-3XL','2XL/3XL','XXXL','3XL','3X','3X-4X','3X/4X','3XL-4XL','3XL/4XL','4XL','5XL','5X','5X-6X','5X/6X','5XL-6XL','5XL/6XL','6XL','6X','7XL','7X','8XL','8X'), cast(intlsize as SIGNED ), color
variationuidrecorduidcolorhexvaluesuppliersizeintlsizeincheseusizeussizeuksizefrsizeessizedesizeitsizeptsizeelsizegendersizegroupcupsizesizetypeitempriceitempromopromoUntilstockuidwarehouseontourpackagingsupplierreservedorderedreturneddefectmanufacturerreferenceeanavailablestockavailablepersizestockpersizeavailablepercolorstockpercolorhaspromounitpricedisplaycomments
1F1C3A842-C504-4AB7-B6516308D67A66FC2130black#000000M38-4038-408-1012-1440-4240-4238-4044-4640-4238-40wlingerie38-40intlsize20.79170STOCK01000-10000-10-10-11020.7917all
2A47B6766-B12A-4FB6-B01DF9B6E13ED4011046black#000000L42-4442-4412-1416-1844-4644-4642-4448-5042-4442-44wlingerie42-44intlsize20.79170STOCK01100-1000050570426027713597311-11-11020.7917all
327C9667A-77ED-422C-88F5AC80FC831DF81047black#000000XL46-4846-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie46-48intlsize20.79170STOCK01000-10200505704260277135980-10-10-11020.7917all
4CA344A1D-F4FC-4595-81C701CB5E37FA4E1048black#0000002XL50-5250-5220-2224-2652-5452-5450-5256-5852-5450-52wlingerie50-52intlsize20.79170STOCK01100-11300505704260277135997-10-10-11020.7917all
578B8BE8B-E8FF-44FC-AEABE95D75458B4E1049black#0000003XL54-5654-5624-2628-3056-5856-5854-5660-6256-5854-56wlingerie54-56intlsize20.79170STOCK01000-10100505704260277136000-10-10-11020.7917all
670150DE5-63C5-431D-B98D24217837F50E1050black#0000004XL56-5856-5826-2830-3258-6058-6056-5862-6458-6056-58wlingerie56-58intlsize20.79170STOCK01000-10200505704260277132835-10-10-11020.7917all
vatrate
number20
warehouse
string