O meu cesto

❌
Total de itens
Ver cesto
Menu
Ver tamanhos
Assaltos à Mónica
Clique duplo para aumentar
SKU: SLAU8553
Assaltos à Mónica
Stock:

Atreva-se a ficar vermelho com estas meias de tamanho grande que quebram o molde.

Tamanho:

Não sabe qual o tamanho a escolher? Consultar o nosso guia de tamanhos

Cor:
Quantidade:
24.95 €
Ajuda e aconselhamento
por chat, facebook ou correio eletrónico
Devoluções gratuitas
no prazo de 15 dias *

Mónica Meias de tamanho grande Autofixans

Descrição do produto

Meias Mónica

Meias de alta qualidade com uma banda de aperto moderna que não se desprende (verifique o seu tamanho).

Malha vermelha com uma linha cubana que curva a perna.

Pormenores técnicos

Tamanhos disponíveis

Disponível de 4-5 a 8-9

Cor disponível

Preto e vermelho

Guia de tamanhos

Verificar o tamanho certo para si

Internacional
  • Coxa
4-5
  • 55-63
6-7
  • 63-76
8-9
  • 75-90
To Top
Ver cesto
Artigos
Total de itens
Struct
Entries: 108
actions
Array
available
number-1
brand
stringkixies
brandcode
stringkbvy
branding
stringdivasboudoir,smboudoir,legsboudoir
brandmedias
string{"default":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"editorial":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"logo":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""}}
brandmetas
Struct
de
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
el
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
en
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
es
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
fr
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
it
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
nl
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
pt
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
brandname
stringKixies
breasts
stringna
careinstructions
string
categories
stringdivasboudoir.lingerie.hoisery.stocking
category
stringhoisery
categorygender
stringf
categorymediadatas
Struct
adult
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string628
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/lingerie/hoisery/stockings.jpg
type
stringimg
width
string1365
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.692 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,'blackred') > 0
and product_variations.productuid = '1ED431B3-C040-4EE4-A61EA3E8AF762BE8'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1blackredcolorbredblackredredlinear-gradient(90deg, #000000 50%, #F50000 50%)-10
colorrange
stringred
colors
stringblackred
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 '2021-09-22 14:33:58'}
defect
number0
dimensions
Struct
Entries: 14
acrylicbones
string
backsideheight
string
diameter
string
flatsteelbones
string
frontsideheight
string
fullheight
string
length
string
modestysize
string
panels
string
sides
string
spiralsteelbones
string
totallength
string
unit
stringcm
wiresize
string
display
stringall
displayfrom
string
displayto
string
grossweight
string
hasbrandinfos
booleanfalse
hascareinstructions
booleanfalse
hascolorinfos
booleantrue
hascompositions
booleanfalse
hasdescription
booleantrue
hasdimensions
booleanfalse
hasmaterials
booleanfalse
hasotherspecifications
booleanfalse
haspromo
number0
hasshortdescription
booleantrue
hassizeinfos
booleantrue
hasspecifications
booleanfalse
hasstockinfos
booleanfalse
hasstylingtips
booleanfalse
hasusageinstructions
booleanfalse
hasvariations
booleantrue
import
string
inpromo
number0
instockvariations
string
isactive
number1
iscustommade
number0
isdivasize
number0
isfirstprice
number0
isfixedprice
number0
ishot
number0
isnew
number0
isonline
number0
isoutletprice
number0
itemprice
number20.7917
itempromo
string
key
stringmonica
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-08-02 18:23:03'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.677 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','pt')
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('1ed431b3-c040-4ee4-a61ea3e8af762be8',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.32 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','pt')
and product_categories.language in ('all','pt')
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 <> 'SLAU8553'
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
string970
isprivate
string0
rating
stringall
src
string/photobank/products/kbvy/slau8553/23989202-1-1.jpg
type
stringimg
width
string671
back
Struct
height
string551
isprivate
string0
rating
stringall
src
string/photobank/products/kbvy/slau8553/showpicture_17.jpg
type
stringimg
width
string388
default
Struct
height
string736
isprivate
string0
rating
stringall
src
string/photobank/products/kbvy/slau8553/bas_autofixants_gaelle_rouges_editorial_3.jpg
type
stringimg
width
string509
variations
Struct
colors
Struct
blackred
Struct
height
string865
isprivate
string0
rating
stringall
src
string/photobank/products/kbvy/slau8553/bas-autofixants-rouges-ligne-grande-taille.jpg
type
stringimg
width
string904
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
mediagallery
string
metadatas
Struct
darkboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-schwarz-und-rot
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-mayro-kai-kokkino
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-black-and-red
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-negro-y-rojo
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-noir-et-rouge
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-nero-e-rosso
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-zwart-en-rood
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-preto-e-vermelho
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
divasboudoir
Struct
de
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringMonica Strümpfe<br /><br />Schöne, qualitativ hochwertige Selbstfixierungen mit einem modernen Klettverschluss, der nicht wegrollen wird (überprüfen Sie Ihre Größe).<br /><br />Rote Maschenware mit einer kubanischen Linie verziert, die das Bein formt.
guid
stringhttps://dev.divasboudoir.com/de/strumpfe-grosse-grosse-autofixans-monica-kixies-schwarz-und-rot/slau8553.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringWagen Sie die Farbe Rot mit diesen Strümpfen in Übergröße, die mit den Codes brechen.
keywords
string
title
stringStrümpfe große Größe Autofixans Monica
seotitle
stringStrümpfe große Größe Autofixans Monica
seouri
stringstrumpfe-grosse-grosse-autofixans-monica-kixies-schwarz-und-rot
specifications
string
stylingtips
string
summary
stringWagen Sie die Farbe Rot mit diesen Strümpfen in Übergröße, die mit den Codes brechen.
title
stringAutofixans-Strümpfe Monica
usageinstructions
string
el
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringΚάλτσες Monica<br /><br />Υψηλής ποιότητας ζαρτιέρες με μοντέρνα λαβή που δεν θα ξεκολλήσει (ελέγξτε το μέγεθός σας).<br /><br />Κόκκινο πλέγμα με κουβανέζικη γραμμή που καμπυλώνει το πόδι.
guid
stringhttps://dev.divasboudoir.com/el/monica-autofixans-kaltses-megaloy-megethoys-kixies-mayro-kai-kokkino/slau8553.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringΤολμήστε το κόκκινο χρώμα με αυτές τις κάλτσες plus-size που σπάνε το καλούπι.
keywords
string
title
stringMonica Autofixans κάλτσες μεγάλου μεγέθους
seotitle
stringMonica Autofixans κάλτσες μεγάλου μεγέθους
seouri
stringmonica-autofixans-kaltses-megaloy-megethoys-kixies-mayro-kai-kokkino
specifications
string
stylingtips
string
summary
stringΤολμήστε το κόκκινο χρώμα με αυτές τις κάλτσες plus-size που σπάνε το καλούπι.
title
stringΜόνικα ληστείες
usageinstructions
string
en
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringMonica stockings<br /><br />High-quality hold-ups with a modern grip band that won't roll off (be sure to check your size).<br /><br />Red mesh adorned with a Cuban line that curves the leg.
guid
stringhttps://dev.divasboudoir.com/en/monica-autofixans-plus-size-stockings-kixies-black-and-red/slau8553.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringDare to wear red with these plus size stockings that break the mould.
keywords
string
title
stringMonica Autofixans plus size stockings
seotitle
stringMonica Autofixans plus size stockings
seouri
stringmonica-autofixans-plus-size-stockings-kixies-black-and-red
specifications
string
stylingtips
string
summary
stringDare to wear red with these plus size stockings that break the mould.
title
stringMonica Autofixans stockings
usageinstructions
string
es
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringMedias Monica<br /><br />Medias de alta calidad con una moderna banda de agarre que no se sale (comprueba tu talla).<br /><br />Malla roja con línea cubana que curva la pierna.
guid
stringhttps://dev.divasboudoir.com/es/monica-autofixans-medias-de-talla-grande-kixies-negro-y-rojo/slau8553.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringAtrévete con el rojo con estas medias de talla grande que rompen moldes.
keywords
string
title
stringMonica Autofixans medias de talla grande
seotitle
stringMonica Autofixans medias de talla grande
seouri
stringmonica-autofixans-medias-de-talla-grande-kixies-negro-y-rojo
specifications
string
stylingtips
string
summary
stringAtrévete con el rojo con estas medias de talla grande que rompen moldes.
title
stringMonica atracos
usageinstructions
string
fr
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringBas Monica<br /><br />Des autofixants de belle qualit&eacute;, avec une bande agrippante moderne et qui ne roulera pas (v&eacute;rifiez bien votre taille).&nbsp;&nbsp;<br /><br />Maille rouge orn&eacute;e d'une ligne cubaine qui galbe la jambe.
guid
stringhttps://dev.divasboudoir.com/fr/bas-grande-taille-autofixants-monica-kixies-noir-et-rouge/slau8553.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringOsez le rouge avec ces bas grande taille qui cassent les codes.
keywords
string
title
stringBas grande taille Autofixans Monica
seotitle
stringBas grande taille Autofixants Monica
seouri
stringbas-grande-taille-autofixants-monica-kixies-noir-et-rouge
specifications
string
stylingtips
string
summary
stringOsez le rouge avec ces bas grande taille qui cassent les codes.
title
stringBas Autofixants Monica
usageinstructions
string
it
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringCalze Monica<br /><br />Calze autoreggenti di alta qualità con una moderna fascia di aderenza che non si stacca (controllate la vostra taglia).<br /><br />Maglia rossa con linea cubana che curva la gamba.
guid
stringhttps://dev.divasboudoir.com/it/monica-autofixans-calze-di-taglia-grande-kixies-nero-e-rosso/slau8553.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringOsate il rosso con queste calze taglia grande che rompono gli schemi.
keywords
string
title
stringMonica Autofixans calze di taglia grande
seotitle
stringMonica Autofixans calze di taglia grande
seouri
stringmonica-autofixans-calze-di-taglia-grande-kixies-nero-e-rosso
specifications
string
stylingtips
string
summary
stringOsate il rosso con queste calze taglia grande che rompono gli schemi.
title
stringMonica hold-up
usageinstructions
string
nl
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringMonica kousen<br /><br />Hoogwaardige hold-ups met een moderne gripband die niet afrolt (controleer je maat).<br /><br />Rood mesh met een Cubaanse lijn die het been rondt.
guid
stringhttps://dev.divasboudoir.com/nl/monica-autofixans-groote-maat-kousen-kixies-zwart-en-rood/slau8553.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringDurf voor rood te gaan met deze kousen van groote maat die de norm doorbreken.
keywords
string
title
stringMonica Autofixans groote maat kousen
seotitle
stringMonica Autofixans groote maat kousen
seouri
stringmonica-autofixans-groote-maat-kousen-kixies-zwart-en-rood
specifications
string
stylingtips
string
summary
stringDurf voor rood te gaan met deze kousen van groote maat die de norm doorbreken.
title
stringMonica hold-ups
usageinstructions
string
pt
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringMeias Mónica<br /><br />Meias de alta qualidade com uma banda de aperto moderna que não se desprende (verifique o seu tamanho).<br /><br />Malha vermelha com uma linha cubana que curva a perna.
guid
stringhttps://dev.divasboudoir.com/pt/monica-meias-de-tamanho-grande-autofixans-kixies-preto-e-vermelho/slau8553.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringAtreva-se a ficar vermelho com estas meias de tamanho grande que quebram o molde.
keywords
string
title
stringMónica Meias de tamanho grande Autofixans
seotitle
stringMónica Meias de tamanho grande Autofixans
seouri
stringmonica-meias-de-tamanho-grande-autofixans-kixies-preto-e-vermelho
specifications
string
stylingtips
string
summary
stringAtreva-se a ficar vermelho com estas meias de tamanho grande que quebram o molde.
title
stringAssaltos à Mónica
usageinstructions
string
fetishboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-schwarz-und-rot
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-mayro-kai-kokkino
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-black-and-red
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-negro-y-rojo
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-noir-et-rouge
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-nero-e-rosso
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-zwart-en-rood
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-preto-e-vermelho
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
latexboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-schwarz-und-rot
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-mayro-kai-kokkino
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-black-and-red
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-negro-y-rojo
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-noir-et-rouge
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-nero-e-rosso
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-zwart-en-rood
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-preto-e-vermelho
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
legsboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringMonica Strümpfe<br /><br />Schöne, qualitativ hochwertige Selbstfixierungen mit einem modernen Klettverschluss, der nicht wegrollen wird (überprüfen Sie Ihre Größe).<br /><br />Rote Maschenware mit einer kubanischen Linie verziert, die das Bein formt.
highlights
string
keypoint
string
keywords
stringselbstfixierende Strümpfe, rot, kubanische Linie, große Größe, Dessous, Damenstrümpfe, elegante Beine, modernes Strumpfband, Komfort, Legs Boudoir
metas
Struct
description
stringWagen Sie die Farbe Rot mit diesen Strümpfen in Übergröße, die mit den Codes brechen.
keywords
string
title
stringStrümpfe große Größe Autofixans Monica
seotitle
stringStrümpfe große Größe Autofixans Monica
seouri
stringstrumpfe-grosse-grosse-autofixans-monica-kixies-schwarz-und-rot
specifications
string
stylingtips
string
summary
stringWagen Sie die Farbe Rot mit diesen Strümpfen in Übergröße, die mit den Codes brechen.
title
stringSelbstfixierende Strümpfe Monica
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringΚάλτσες Monica<br /><br />Υψηλής ποιότητας ζαρτιέρες με μοντέρνα λαβή που δεν θα ξεκολλήσει (ελέγξτε το μέγεθός σας).<br /><br />Κόκκινο πλέγμα με κουβανέζικη γραμμή που καμπυλώνει το πόδι.
highlights
string
keypoint
string
keywords
stringhold ups, κόκκινο, κουβανέζικη γραμμή, μεγάλο μέγεθος, εσώρουχα, γυναικείες κάλτσες, κομψά πόδια, μοντέρνα καλτσοδέτα, άνεση, Legs Boudoir
metas
Struct
description
stringΤολμήστε το κόκκινο χρώμα με αυτές τις κάλτσες plus-size που σπάνε το καλούπι.
keywords
string
title
stringMonica Autofixans κάλτσες μεγάλου μεγέθους
seotitle
stringMonica Autofixans κάλτσες μεγάλου μεγέθους
seouri
stringmonica-autofixans-kaltses-megaloy-megethoys-kixies-mayro-kai-kokkino
specifications
string
stylingtips
string
summary
stringΤολμήστε το κόκκινο χρώμα με αυτές τις κάλτσες plus-size που σπάνε το καλούπι.
title
stringMonica hold ups
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringMonica stockings<br /><br />High-quality hold-ups with a modern grip band that won't roll off (be sure to check your size).<br /><br />Red mesh adorned with a Cuban line that curves the leg.
highlights
string
keypoint
string
keywords
stringhold ups, red, cuban line, plus size, lingerie, women's stockings, elegant legs, modern garter, comfort, Legs Boudoir
metas
Struct
description
stringDare to wear red with these plus size stockings that break the mould.
keywords
string
title
stringMonica Autofixans plus size stockings
seotitle
stringMonica Autofixans plus size stockings
seouri
stringmonica-autofixans-plus-size-stockings-kixies-black-and-red
specifications
string
stylingtips
string
summary
stringDare to wear red with these plus size stockings that break the mould.
title
stringMonica hold ups
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringMedias Monica<br /><br />Medias de alta calidad con una moderna banda de agarre que no se sale (comprueba tu talla).<br /><br />Malla roja con línea cubana que curva la pierna.
highlights
string
keypoint
string
keywords
stringmedias, rojo, línea cubana, talla grande, lencería, medias de mujer, piernas elegantes, liguero moderno, comodidad, Legs Boudoir
metas
Struct
description
stringAtrévete con el rojo con estas medias de talla grande que rompen moldes.
keywords
string
title
stringMonica Autofixans medias de talla grande
seotitle
stringMonica Autofixans medias de talla grande
seouri
stringmonica-autofixans-medias-de-talla-grande-kixies-negro-y-rojo
specifications
string
stylingtips
string
summary
stringAtrévete con el rojo con estas medias de talla grande que rompen moldes.
title
stringMonica atracos
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Osez la couleur de la passion avec les bas Monica.</p> <p>Ces bas autofixants de belle qualit&eacute; vous offrent un confort exceptionnel gr&acirc;ce &agrave; leur bande agrippante moderne, con&ccedil;ue pour ne pas rouler (pensez &agrave; v&eacute;rifier votre taille !).</p> <p>Leur maille rouge, orn&eacute;e d'une ligne cubaine qui galbe d&eacute;licatement votre jambe, apportera une touche d'audace et de sophistication &agrave; votre tenue.</p> <p>Disponibles en grande taille, ils sublimeront toutes les silhouettes. Laissez la passion vous envahir avec les bas Monica !</p>
highlights
string
keypoint
string
keywords
stringbas autofixants, rouge, ligne cubaine, grande taille, lingerie, bas femme, jambes élégantes, jarretière moderne, confort, Legs Boudoir
metas
Struct
description
stringAffirmez votre féminité avec les bas Monica et leur maille rouge passionnée. Confort, maintien parfait et silhouette sublimée à découvrir sur Legs Boudoir. Disponibles en grande taille.
keywords
string
title
stringBas Autofixants Monica rouge Ligne Cubaine Grande Taille | Legs Boudoir
seotitle
stringbas autofixants monica rouge ligne cubaine grande taille
seouri
stringbas-autofixants-monica-rouge-ligne-cubaine-grande-taille-kixies-noir-et-rouge
specifications
string
stylingtips
string
summary
string<p>Passion et &eacute;l&eacute;gance : bas autofixants Monica, une maille rouge vibrante et une ligne cubaine sculptante pour des jambes irr&eacute;sistibles.</p>
title
stringMonica : L'Élégance Passionnée du rouge sur Vos Jambes
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringCalze Monica<br /><br />Calze autoreggenti di alta qualità con una moderna fascia di aderenza che non si stacca (controllate la vostra taglia).<br /><br />Maglia rossa con linea cubana che curva la gamba.
highlights
string
keypoint
string
keywords
stringautoreggenti, rosso, linea cubana, taglia grande, lingerie, calze da donna, gambe eleganti, giarrettiera moderna, comfort, Legs Boudoir
metas
Struct
description
stringOsate il rosso con queste calze taglia grande che rompono gli schemi.
keywords
string
title
stringMonica Autofixans calze di taglia grande
seotitle
stringMonica Autofixans calze di taglia grande
seouri
stringmonica-autofixans-calze-di-taglia-grande-kixies-nero-e-rosso
specifications
string
stylingtips
string
summary
stringOsate il rosso con queste calze taglia grande che rompono gli schemi.
title
stringMonica hold up
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringMonica kousen<br /><br />Hoogwaardige hold-ups met een moderne gripband die niet afrolt (controleer je maat).<br /><br />Rood mesh met een Cubaanse lijn die het been rondt.
highlights
string
keypoint
string
keywords
stringhold ups, rood, cubaanse lijn, grote maat, lingerie, dameskousen, elegante benen, moderne jarretel, comfort, Legs Boudoir
metas
Struct
description
stringDurf voor rood te gaan met deze kousen van grote maten die de norm breken.
keywords
string
title
stringMonica Autofixans grote maat kousen
seotitle
stringMonica Autofixans groote maat kousen
seouri
stringmonica-autofixans-groote-maat-kousen-kixies-zwart-en-rood
specifications
string
stylingtips
string
summary
stringDurf voor rood te gaan met deze kousen van grote maten die de norm breken.
title
stringMonica hold-ups
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringMeias Mónica<br /><br />Meias de alta qualidade com uma banda de aperto moderna que não se desprende (verifique o seu tamanho).<br /><br />Malha vermelha com uma linha cubana que curva a perna.
highlights
string
keypoint
string
keywords
stringmeias de ligas, vermelho, linha cubana, tamanho grande, lingerie, meias de senhora, pernas elegantes, liga moderna, conforto, Legs Boudoir
metas
Struct
description
stringAtreva-se a ficar vermelho com estas meias de tamanho grande que quebram o molde.
keywords
string
title
stringMónica Meias de tamanho grande Autofixans
seotitle
stringMónica Meias de tamanho grande Autofixans
seouri
stringmonica-meias-de-tamanho-grande-autofixans-kixies-preto-e-vermelho
specifications
string
stylingtips
string
summary
stringAtreva-se a ficar vermelho com estas meias de tamanho grande que quebram o molde.
title
stringMónica aguenta
usageinstructions
string
lustboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-schwarz-und-rot
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-mayro-kai-kokkino
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-black-and-red
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-negro-y-rojo
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-noir-et-rouge
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-nero-e-rosso
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-zwart-en-rood
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kixies-preto-e-vermelho
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
smboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringMonique Strümpfe<br /><br />Schöne, qualitativ hochwertige Selbstfixierungen mit einem modernen Klettverschluss, der nicht wegrollt (überprüfen Sie Ihre Größe genau).<br /><br />Rote Maschenware mit einer kubanischen Linie verziert, die das Bein formt.<br /><br />Sie können sie auch mit Ihrem Lieblingsstrapsgürtel tragen.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringWagen Sie die Farbe Rot mit diesen Strümpfen, die mit den Codes brechen. Sie können sie auch mit Ihrem Lieblingsstrumpfhalter tragen.
keywords
string
title
stringBas Monique
seotitle
stringBas Monique
seouri
stringbas-monique-kixies-schwarz-und-rot
specifications
string
stylingtips
string
summary
stringWagen Sie die Farbe Rot mit diesen Strümpfen, die mit den Codes brechen. Sie können sie auch mit Ihrem Lieblingsstrumpfhalter tragen.
title
stringBas Monique
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringΚάλτσες Monique<br /><br />Υψηλής ποιότητας καλσόν με μοντέρνα λαβή που δεν θα ξεκολλήσει (ελέγξτε το μέγεθός σας).<br /><br />Κόκκινο πλέγμα με κουβανέζικη γραμμή που διαμορφώνει το πόδι.<br /><br />Μπορείτε επίσης να τις φορέσετε με την αγαπημένη σας ζώνη καλτσοδέτας.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringΤολμήστε το κόκκινο με αυτές τις πρωτοποριακές κάλτσες, οι οποίες μπορούν επίσης να φορεθούν με την αγαπημένη σας ζώνη καλτσοδέτας.
keywords
string
title
stringBas Monique
seotitle
stringBas Monique
seouri
stringbas-monique-kixies-mayro-kai-kokkino
specifications
string
stylingtips
string
summary
stringΤολμήστε το κόκκινο με αυτές τις πρωτοποριακές κάλτσες, οι οποίες μπορούν επίσης να φορεθούν με την αγαπημένη σας ζώνη καλτσοδέτας.
title
stringBas Monique
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringMonique stockings<br /><br />High-quality hold-ups with a modern grip band that won't roll off (be sure to check your size).<br /><br />Red mesh adorned with a Cuban line that curves the leg.<br /><br />You can also wear them with your favorite garter belt.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringDare to go red with these code-breaking stockings, which can also be worn with your favorite garter belt.
keywords
string
title
stringBas Monique
seotitle
stringBas Monique
seouri
stringbas-monique-kixies-black-and-red
specifications
string
stylingtips
string
summary
stringDare to go red with these code-breaking stockings, which can also be worn with your favorite garter belt.
title
stringBas Monique
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringMedias Monique<br /><br />Medias de alta calidad con una moderna banda de agarre que no se sale (comprueba tu talla).<br /><br />Malla roja con línea cubana que moldea la pierna.<br /><br />También puedes llevarlas con tu liguero favorito.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringAtrévete con el rojo con estas medias rompedoras, que también puedes llevar con tu liguero favorito.
keywords
string
title
stringBas Monique
seotitle
stringBas Monique
seouri
stringbas-monique-kixies-negro-y-rojo
specifications
string
stylingtips
string
summary
stringAtrévete con el rojo con estas medias rompedoras, que también puedes llevar con tu liguero favorito.
title
stringBas Monique
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Bas Monique<br><br>Des autofixants de belle qualit&eacute;, avec une bande agrippante moderne et qui ne roulera pas (v&eacute;rifiez bien votre taille).&nbsp;&nbsp;<br><br>Maille rouge orn&eacute;e d'une ligne cubaine qui galbe la jambe.<br><br>Vous pourrez &eacute;galement porter avec votre porte-jarretelles pr&eacute;f&eacute;r&eacute;.</p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringOsez le rouge avec ces bas qui cassent les codes, vous pourrez également porter avec votre porte-jarretelles préféré. 
keywords
string
title
stringBas Monique
seotitle
stringBas Monique
seouri
stringbas-monique-kixies-noir-et-rouge
specifications
string
stylingtips
string
summary
string<p>Osez le rouge avec ces bas qui cassent les codes, vous pourrez &eacute;galement porter avec votre porte-jarretelles pr&eacute;f&eacute;r&eacute;.</p>
title
stringBas Monique
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringCalze Monique<br /><br />Calze autoreggenti di alta qualità con una moderna fascia di aderenza che non si stacca (controllate la vostra taglia).<br /><br />Maglia rossa con linea cubana che modella la gamba.<br /><br />Potete indossarle anche con il vostro reggicalze preferito.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringOsate il rosso con queste calze innovative, che possono essere indossate anche con il vostro reggicalze preferito.
keywords
string
title
stringBas Monique
seotitle
stringBas Monique
seouri
stringbas-monique-kixies-nero-e-rosso
specifications
string
stylingtips
string
summary
stringOsate il rosso con queste calze innovative, che possono essere indossate anche con il vostro reggicalze preferito.
title
stringBas Monique
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringMonique kousen<br /><br />Hoogwaardige hold-ups met een moderne gripband die niet afrolt (controleer je maat).<br /><br />Rood mesh met een Cubaanse lijn die het been vormt.<br /><br />Je kunt ze ook dragen met je favoriete jarretelgordel.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringDurf voor rood te gaan met deze baanbrekende kousen, die ook gedragen kunnen worden met je favoriete jarretelgordel.
keywords
string
title
stringBas Monique
seotitle
stringBas Monique
seouri
stringbas-monique-kixies-zwart-en-rood
specifications
string
stylingtips
string
summary
stringDurf voor rood te gaan met deze baanbrekende kousen, die ook gedragen kunnen worden met je favoriete jarretelgordel.
title
stringBas Monique
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringMeias Monique<br /><br />Meias de alta qualidade com uma banda de aperto moderna que não se desprende (verifique o seu tamanho).<br /><br />Malha vermelha com uma linha cubana que modela a perna.<br /><br />Também pode usá-las com o seu cinto de ligas preferido.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringAtreva-se a ficar vermelha com estas meias inovadoras, que também podem ser usadas com o seu cinto de ligas preferido.
keywords
string
title
stringBas Monique
seotitle
stringBas Monique
seouri
stringbas-monique-kixies-preto-e-vermelho
specifications
string
stylingtips
string
summary
stringAtreva-se a ficar vermelha com estas meias inovadoras, que também podem ser usadas com o seu cinto de ligas preferido.
title
stringBas Monique
usageinstructions
string
name
stringmonica
netweight
string
nextshipment
stringtomorrow
ordered
number2
orderidx
number0
origin
string
originalsize
string
packaging
string
productshipment
stringauto
productuid
string1ED431B3-C040-4EE4-A61EA3E8AF762BE8
promountil
string
rating
stringnone
recorduid
string1ED431B3-C040-4EE4-A61EA3E8AF762BE8
reference
stringSLAU8553
related
string
reserved
string
returned
number0
returnsallowed
number1
section
stringlingerie
shipment
string3to5days
showbrand
number1
sizeinfos
Query
Template: /system/api/product/sizes.cfc:20
Execution Time: 1.3 ms
Record Count: 3
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_sizes.id_size as recorduid, if(intlsize <> '',intlsize,eusize) as size, if(intlsize <> '','intlsize','eusize') as sizetype,
product_variations.color,
if(product_sizes.sizegroup = 'bra',
if(intlsize <> '', cast(intlsize as SIGNED ), cast(eusize as SIGNED ))
,
SUBSTRING_INDEX(intlsize,'-',1)
) as param1,
if(product_sizes.sizegroup = 'bra',
if(intlsize <> '',
MID(intlsize,length(cast(intlsize as SIGNED ))+1,length(intlsize)),
MID(eusize,length(cast(eusize as SIGNED ))+1,length(eusize))
)
,
SUBSTRING_INDEX(intlsize,'-',-1)
) as param2,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as available,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
999999,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as groupavailable,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
product_sizes.gender, product_sizes.sizerange, product_sizes.sizegroup, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize,
product_sizes.bust, product_sizes.waist, product_sizes.hip, product_sizes.underbust, product_sizes.cup, product_sizes.thigh, product_sizes.legheight, product_sizes.bodyheight, product_sizes.bodyweight
from product_sizes
left outer join product_variations on product_sizes.suppliersize = product_variations.size and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
where FIND_IN_SET(product_sizes.id_size,'1583,1584,1585,2109') > 0
and product_variations.productuid = '1ED431B3-C040-4EE4-A61EA3E8AF762BE8'
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
115834-5intlsizeblackred45-19999990wplusstockingB4-54-54-54-54-54-54-54-54-54-555-63
215846-7intlsizeblackred67-19999990wplusstockingC6-76-76-76-76-76-76-76-76-76-763-76
315858-9intlsizeblackred89-19999990wplusstockingD8-98-98-98-98-98-98-98-98-98-975-90
sizeranges
stringplus,standard
sizes
string1583,1584,1585,2109
sizetype
stringintlsize
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: 4.73 ms
Record Count: 3
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select * from (
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '1ED431B3-C040-4EE4-A61EA3E8AF762BE8'
and product_variations.isactive = 1
and product_sizes.id_size = 1583
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '1ED431B3-C040-4EE4-A61EA3E8AF762BE8'
and product_variations.isactive = 1
and product_sizes.id_size = 1584
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '1ED431B3-C040-4EE4-A61EA3E8AF762BE8'
and product_variations.isactive = 1
and product_sizes.id_size = 1585
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '1ED431B3-C040-4EE4-A61EA3E8AF762BE8'
and product_variations.isactive = 1
and product_sizes.id_size = 2109
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
) tbl
group by productuid, variationuid, stockuid
order by stockuid, FIELD(gender,'w','m'), sizegroup, FIELD(intlsize,'XS','S','S/M','S-M','M','M/L','M-L','L','L-XL','L/XL','XL','0X','0XL','lXL','1X','1X-2X','1X/2X','XL/2XL','XL-2XL','1XL-2XL','2XL','2X','XXL','2X-3X','2X/3X','2XL-3XL','2XL/3XL','XXXL','3XL','3X','3X-4X','3X/4X','3XL-4XL','3XL/4XL','4XL','5XL','5X','5X-6X','5X/6X','5XL-6XL','5XL/6XL','6XL','6X','7XL','7X','8XL','8X'), cast(intlsize as SIGNED ), color
productuidvariationuidrecorduidcolorhexvaluesuppliersizeintlsizeincheseusizeussizeuksizefrsizeessizedesizeitsizeptsizeelsizegendersizegroupcupsizesizetypeitempriceitempromopromoUntilstockuidwarehouseontourpackagingsupplierreservedorderedreturneddefectmanufacturerreferenceeanavailablestockdisplaycomments
11ED431B3-C040-4EE4-A61EA3E8AF762BE86E5840CC-8857-40EF-98DFF2C11BDBA0381583blackredlinear-gradient(90deg, #000000 50%, #F50000 50%)B4-54-54-54-54-54-54-54-54-54-5wstocking4-5intlsize20.79170STOCK01000-100001328B-10all
21ED431B3-C040-4EE4-A61EA3E8AF762BE8DD45AD79-E681-45EC-B782E4C52BC4572A1584blackredlinear-gradient(90deg, #000000 50%, #F50000 50%)C6-76-76-76-76-76-76-76-76-76-7wstocking6-7intlsize20.79170STOCK01000-112001328C850017512092-10all
31ED431B3-C040-4EE4-A61EA3E8AF762BE8585E89DE-DAE7-4DC6-B9195D1DEBAF69F81585blackredlinear-gradient(90deg, #000000 50%, #F50000 50%)D8-98-98-98-98-98-98-98-98-98-9wstocking8-9intlsize20.79170STOCK01000-102001328D850017512108-10all
subcategory
stringstocking
supplier
number-1
supplierreference
stringMONICA
tags
string
themes
stringchristmas
totalvariations
string
type
stringdefault
unitprice
number20.7917
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 6.77 ms
Record Count: 3
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '1ED431B3-C040-4EE4-A61EA3E8AF762BE8' 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 = '1ED431B3-C040-4EE4-A61EA3E8AF762BE8' 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 = '1ED431B3-C040-4EE4-A61EA3E8AF762BE8' 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 = '1ED431B3-C040-4EE4-A61EA3E8AF762BE8' 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 = '1ED431B3-C040-4EE4-A61EA3E8AF762BE8' 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 = '1ED431B3-C040-4EE4-A61EA3E8AF762BE8' 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 = '1ED431B3-C040-4EE4-A61EA3E8AF762BE8'
and product_variations.isactive = 1
and product_sizes.id_size = 1583
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '1ED431B3-C040-4EE4-A61EA3E8AF762BE8' 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 = '1ED431B3-C040-4EE4-A61EA3E8AF762BE8' 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 = '1ED431B3-C040-4EE4-A61EA3E8AF762BE8' 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 = '1ED431B3-C040-4EE4-A61EA3E8AF762BE8' 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 = '1ED431B3-C040-4EE4-A61EA3E8AF762BE8' 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 = '1ED431B3-C040-4EE4-A61EA3E8AF762BE8' 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 = '1ED431B3-C040-4EE4-A61EA3E8AF762BE8'
and product_variations.isactive = 1
and product_sizes.id_size = 1584
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '1ED431B3-C040-4EE4-A61EA3E8AF762BE8' 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 = '1ED431B3-C040-4EE4-A61EA3E8AF762BE8' 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 = '1ED431B3-C040-4EE4-A61EA3E8AF762BE8' 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 = '1ED431B3-C040-4EE4-A61EA3E8AF762BE8' 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 = '1ED431B3-C040-4EE4-A61EA3E8AF762BE8' 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 = '1ED431B3-C040-4EE4-A61EA3E8AF762BE8' 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 = '1ED431B3-C040-4EE4-A61EA3E8AF762BE8'
and product_variations.isactive = 1
and product_sizes.id_size = 1585
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '1ED431B3-C040-4EE4-A61EA3E8AF762BE8' 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 = '1ED431B3-C040-4EE4-A61EA3E8AF762BE8' 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 = '1ED431B3-C040-4EE4-A61EA3E8AF762BE8' 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 = '1ED431B3-C040-4EE4-A61EA3E8AF762BE8' 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 = '1ED431B3-C040-4EE4-A61EA3E8AF762BE8' 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 = '1ED431B3-C040-4EE4-A61EA3E8AF762BE8' 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 = '1ED431B3-C040-4EE4-A61EA3E8AF762BE8'
and product_variations.isactive = 1
and product_sizes.id_size = 2109
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
order by FIELD(gender,'w','m'), sizegroup, FIELD(intlsize,'XS','S','S/M','S-M','M','M/L','M-L','L','L-XL','L/XL','XL','0X','0XL','lXL','1X','1X-2X','1X/2X','XL/2XL','XL-2XL','1XL-2XL','2XL','2X','XXL','2X-3X','2X/3X','2XL-3XL','2XL/3XL','XXXL','3XL','3X','3X-4X','3X/4X','3XL-4XL','3XL/4XL','4XL','5XL','5X','5X-6X','5X/6X','5XL-6XL','5XL/6XL','6XL','6X','7XL','7X','8XL','8X'), cast(intlsize as SIGNED ), color
variationuidrecorduidcolorhexvaluesuppliersizeintlsizeincheseusizeussizeuksizefrsizeessizedesizeitsizeptsizeelsizegendersizegroupcupsizesizetypeitempriceitempromopromoUntilstockuidwarehouseontourpackagingsupplierreservedorderedreturneddefectmanufacturerreferenceeanavailablestockavailablepersizestockpersizeavailablepercolorstockpercolorhaspromounitpricedisplaycomments
16E5840CC-8857-40EF-98DFF2C11BDBA0381583blackredlinear-gradient(90deg, #000000 50%, #F50000 50%)B4-54-54-54-54-54-54-54-54-54-5wstocking4-5intlsize20.79170STOCK01000-100001328B-10-10-10020.7917all
2DD45AD79-E681-45EC-B782E4C52BC4572A1584blackredlinear-gradient(90deg, #000000 50%, #F50000 50%)C6-76-76-76-76-76-76-76-76-76-7wstocking6-7intlsize20.79170STOCK01000-112001328C850017512092-10-10-10020.7917all
3585E89DE-DAE7-4DC6-B9195D1DEBAF69F81585blackredlinear-gradient(90deg, #000000 50%, #F50000 50%)D8-98-98-98-98-98-98-98-98-98-9wstocking8-9intlsize20.79170STOCK01000-102001328D850017512108-10-10-10020.7917all
vatrate
number20
warehouse
string