O meu cesto

❌
Total de itens
Ver cesto
Menu
Ver tamanhos
Body Evangelina
Clique duplo para aumentar
SKU: SBBO0072
Body Evangelina
Novo
Stock:

Cores magníficas e rendas florais para este bonito body, disponível em belos tamanhos grandes.

Destaques

  • Corpete em microfibra opaca que realça perfeitamente todos os seios
  • Renda floral em dois tons no busto e na parte inferior do corpo
  • Delicados bordados pretos e roxos adornam sensualmente as nádegas
  • Abertura com botões de pressão nas virilhas para um acesso atrevido
  • Qualidade impecável especialmente concebida para as suas curvas
Tamanho:

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

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

Evangeline body plus size

Descrição do produto

Evangelina

Este body é confeccionado em microfibra opaca para o corpete e em magnífica renda floral bicolor para o busto e a parte inferior do corpo.

Especialmente concebido para as nossas curvas, adorna as nádegas com delicados bordados pretos e roxos.

Qualidade impecável, abertura com botões de pressão na virilha.

Pormenores técnicos

  • Material do corpete: microfibra opaca de alta qualidade
  • Material decorativo: Renda floral em dois tons
  • Bordado: Delicados motivos pretos e roxos nas nádegas
  • Tamanhos: Disponível em toda a gama plus size
  • Fecho: Abertura com botões de pressão nas virilhas
  • Design: Especialmente adaptado a curvas generosas

Tamanhos disponíveis

Disponível de XL+ a 4XL

Cor disponível

Preto e lilás

Composição

Poliamida 45 %
Spandex 10 %
Poliéster 45 %

Guia de tamanhos

Verificar o tamanho certo para si

Internacional
  • Peito
  • Tamanho
  • Ancas
XL+
  • 113-118
  • 96-102
  • 117-121
2XL+
  • 125-130
  • 109-114
  • 127-132
3XL+
  • 137-142
  • 122-128
  • 138-144
4XL+
  • 149-154
  • 135-140
  • 151-156
L
  • 103-106
  • 86-90
  • 109-112
XL
  • 107-112
  • 91-95
  • 113-116
2XL
  • 119-124
  • 103-108
  • 122-126
3XL
  • 131-136
  • 115-121
  • 133-138
4XL
  • 143-148
  • 129-134
  • 145-150

Instruções de cuidados

  • Lavar à mão em água tépida (30°C no máximo)
  • Utilizar um detergente suave para preservar a renda floral
  • Manusear os bordados pretos e malva com cuidado
  • Secar em local plano, longe da luz direta
  • Não passar a ferro diretamente sobre bordados delicados

Dicas de utilização

O body Evangeline foi concebido para revelar a sua sensualidade com sofisticação. A abertura com botões de pressão na virilha é fácil de manipular para um acesso atrevido de acordo com a sua disposição. A microfibra opaca proporciona um suporte ótimo para o busto, mantendo um aspeto ultra-sexy. Os delicados bordados nas nádegas criam um efeito provocante que certamente chamará a atenção de todos.

Perfeita para momentos íntimos sensuais ou para se sentir irresistivelmente sexy debaixo da roupa. Esta lingerie abraça as suas curvas para um conforto ótimo que dura todo o dia.

Dicas de estilo

O body Evangeline é tudo o que precisa para criar um look ultra-sensual. A renda floral de dois tons e o bordado delicado já criam um efeito visual marcante que revela o seu lado mais sexy. Para intensificar o efeito atrevido, combine-o com acessórios que façam eco dos tons preto e roxo do bordado. Esta peça, especialmente concebida para as suas curvas, combina na perfeição com tons sensuais e sofisticados.

Para uma abordagem ainda mais erótica, brinque com a abertura de encaixe para criar diferentes efeitos surpresa. Complete o seu look com os provocantes bodys abertos para variar, combine-os com negligés ultra-sensuais ou sublimar as suas pernas com as nossas sofisticadas meias de ligas e collants atrevidos.

To Top
Ver cesto
Artigos
Total de itens
Struct
Entries: 108
actions
Array
available
number-1
brand
stringcottelli
brandcode
stringcwhd
branding
stringdivasboudoir
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
stringCottelli
breasts
stringna
careinstructions
string
categories
stringdivasboudoir.lingerie.sexylingerie.body
category
stringsexylingerie
categorygender
stringm
categorymediadatas
Struct
adult
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string276
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/lingerie/sexylingerie/body.jpg
type
stringimg
width
string600
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.722 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,'blackpurple') > 0
and product_variations.productuid = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1blackpurplecolorbpurblackpurplepurplelinear-gradient(90deg, #000000 50%, #9400D4 50%)-10
colorrange
stringpurple
colors
stringblackpurple
colortype
stringcolor
comments
string
compositions
Struct
Entries: 13
coton
string
elastane
string
free
string
leather
string
lycra
string
metal
string
nylon
string
polyamide
string45
polyester
string45
polyurethane
string
silk
string
spandex
string10
viscose
string
datecreated
Date Time (Europe/Paris)
{ts '2021-10-25 16:04:54'}
defect
number0
dimensions
Struct
Entries: 14
acrylicbones
string
backsideheight
string
diameter
string
flatsteelbones
string
frontsideheight
string
fullheight
string
length
string
modestysize
string
panels
string
sides
string
spiralsteelbones
string
totallength
string
unit
stringcm
wiresize
string
display
stringall
displayfrom
string
displayto
string
grossweight
string
hasbrandinfos
booleanfalse
hascareinstructions
booleantrue
hascolorinfos
booleantrue
hascompositions
booleantrue
hasdescription
booleantrue
hasdimensions
booleanfalse
hasmaterials
booleanfalse
hasotherspecifications
booleanfalse
haspromo
number0
hasshortdescription
booleantrue
hassizeinfos
booleantrue
hasspecifications
booleantrue
hasstockinfos
booleanfalse
hasstylingtips
booleantrue
hasusageinstructions
booleantrue
hasvariations
booleantrue
import
string
inpromo
number0
instockvariations
number1
isactive
number1
iscustommade
number0
isdivasize
number0
isfirstprice
number0
isfixedprice
number0
ishot
number0
isnew
number1
isonline
number0
isoutletprice
number0
itemprice
number41.625
itempromo
string
key
stringbody
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-11-02 17:13:17'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.649 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('0d33af60-78d4-489b-ae88e9ebac8b09b7',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.37 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 <> 'SBBO0072'
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
string1590
isprivate
string0
rating
stringall
src
string/photobank/products/cwhd/sbbo0072/body_evangeline.jpg
type
stringimg
width
string1100
back
Struct
height
string1631
isprivate
string0
rating
stringall
src
string/photobank/products/cwhd/sbbo0072/body_evangeline_dos_grande_taille_dos.jpg
type
stringimg
width
string1128
default
Struct
height
string1843
isprivate
string0
rating
stringall
src
string/photobank/products/cwhd/sbbo0072/body_evangeline_dos_grande_taille_avant.jpg
type
stringimg
width
string1275
variations
Struct
colors
Struct
blackpurple
Struct
height
string900
isprivate
string0
rating
stringall
src
string/photobank/products/cwhd/sbbo0072/body-sexy-grande-taille1.jpg
type
stringimg
width
string622
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
mediagallery
string
metadatas
Struct
darkboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz-und-lila
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro-kai-mov
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black-and-purple
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro-y-lila
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-et-mauve
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero-e-malva
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart-en-mauve
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto-e-lilas
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
divasboudoir
Struct
de
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Handwäsche in lauwarmem Wasser (maximal 30&deg;C)</li> <li>Verwenden Sie ein mildes Waschmittel, um die Blumenspitze zu schonen</li> <li>Behutsame Handhabung der schwarzen und lilafarbenen Stickereien</li> <li>Flach trocknen, vor direktem Licht schützen</li> <li>Nicht direkt über die zarten Stickereien bügeln</li> </ul>
description
stringEvangeline<br /><br />Dieser Body besteht aus blickdichter Mikrofaser f&uuml;r das Mieder und aus wundersch&ouml;ner zweifarbiger floraler Spitze f&uuml;r die Brust und den Unterk&ouml;rper.<br /><br />Speziell f&uuml;r unsere Rundungen entworfen, schm&uuml;ckt er das Ges&auml;&szlig; mit zarten schwarzen und lilafarbenen Stickereien.<br /><br />Einwandfreie Qualit&auml;t, im Schritt mit Druckkn&ouml;pfen zu &ouml;ffnen.
guid
stringhttps://dev.divasboudoir.com/de/body-in-grossen-grossen-evangeline-schwarz-und-lila/sbbo0072.htm
highlights
string<ul> <li><strong>Blickdichte Miedermikrofaser</strong>, die jede Brust perfekt sublimiert</li> <li><strong>Zweifarbige Blumenspitze</strong> auf der Brust und am Unterkörper</li> <li><strong>Zarte schwarze und lilafarbene Stickereien</strong>, die sinnlich das Gesäß zieren</li> <li><strong>Druckknopf-Öffnung</strong> im Schritt für einen verruchten Zugang</li> <li><strong>Makellose Qualität</strong> speziell für Ihre Rundungen</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringWunderschöne Farben und florale Spitze für diesen hübschen Body, den es auch in schönen großen Größen gibt.
keywords
string
title
stringBody in großen Größen Evangeline
seotitle
stringBody in großen Größen Evangeline
seouri
stringbody-in-grossen-grossen-evangeline-schwarz-und-lila
specifications
string<ul> <li><strong>Miedermaterial:</strong> Hochwertige, blickdichte Mikrofaser</li> <li><strong>Dekoratives Material:</strong> Zweifarbige Blumenspitze</li> <li><strong>Stickereien:</strong> Zarte schwarze und lilafarbene Motive auf dem Gesäß</li> <li><strong>Größen:</strong> Erhältlich in der gesamten Palette für große Größen</li> <li><strong>Verschluss:</strong> Im Schritt mit Druckknöpfen zu öffnen</li> <li><strong>Design:</strong> Speziell für üppige Rundungen geeignet</li> </ul>
stylingtips
string<p>Der Evangeline-Body genügt sich selbst, um einen <strong>ultra-sinnlichen</strong> Look zu kreieren. Die zweifarbige Blumenspitze und die zarten Stickereien sorgen bereits für einen <strong>atemberaubenden</strong> visuellen Effekt, der <strong>Ihre heißeste Seite offenbart</strong>. Um den <strong>verruchten</strong> Effekt noch zu intensivieren, kombinieren Sie es mit Accessoires, die die Schwarz- und Lilatöne der Stickereien aufgreifen. Dieses <strong>speziell für Ihre Rundungen entworfene</strong> Stück passt perfekt zu <strong>sinnlichen</strong> und raffinierten <strong>Tönen</strong>.</p> <p>Für einen noch <strong> erotischeren</strong> Ansatz spielen Sie mit der Öffnung durch Druckknöpfe, um verschiedene Überraschungseffekte zu erzeugen. Vervollständigen Sie Ihren Look mit <strong>aufreizend</strong> <a href="https://www.divasboudoir.com/de/offener-body-in-grossen-grossen/">offenen Bodies</a>, die für Abwechslung sorgen, kombinieren Sie sie mit <strong>ultra-sinnlichen</strong> <a href="https://www.divasboudoir.com/de/neglige-in-grosse-grossen/">Neglig&eacute;s</a> oder betonen Sie Ihre Beine mit unseren raffinierten <a href="https://www.divasboudoir.com/de/strumpfe-in-grossen-grossen/">Strümpfen</a> und <strong>verruchten</strong> <a href="https://www.divasboudoir.com/de/offene-strumpfhose-grosse-grosse/">Strumpfhosen</a>.</p>
summary
stringWundersch&ouml;ne Farben und florale Spitze f&uuml;r diesen h&uuml;bschen Body, den es auch in sch&ouml;nen gro&szlig;en Gr&ouml;&szlig;en gibt.
title
stringBody Evangeline
usageinstructions
string<p>Der Evangeline-Body wurde entworfen, um <strong>Ihre Sinnlichkeit</strong> auf raffinierte Weise zu enthüllen. Die Druckknopf-Öffnung im Schritt ist leicht zu handhaben und ermöglicht Ihnen einen <strong>frechen Zugang</strong>, ganz nach Ihren momentanen Wünschen. Die blickdichte Mikrofaser bietet <strong>optimalen Halt</strong> für die Brust und sorgt gleichzeitig für einen <strong>ultra-sexy</strong> Look. Die zarten Stickereien auf dem Gesäß sorgen für einen <strong>provokanten</strong> Effekt, der alle Blicke auf sich zieht.</p> <p>Perfekt für <strong>sinnliche</strong> intime Momente oder um sich unter Ihrer Kleidung <strong>unwiderstehlich sexy</strong> zu fühlen. Diese Dessous <strong> schmiegen sich perfekt an Ihre Rundungen</strong> an und sorgen für einen <strong>optimalen Tragekomfort</strong>, der den ganzen Tag anhält.</p>
el
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Πλένετε στο χέρι με χλιαρό νερό (30&deg;C το πολύ)</li> <li>Χρησιμοποιήστε ήπιο απορρυπαντικό για να διατηρήσετε τη δαντέλα των λουλουδιών</li> <li>Χειριστείτε τα μαύρα και μωβ κεντήματα με προσοχή</li> <li>Στεγνώνετε σε επίπεδη επιφάνεια, μακριά από το άμεσο φως</li> <li>Μην σιδερώνετε απευθείας τα ευαίσθητα κεντήματα</li> </ul>
description
stringEvangeline<br /><br />&Alpha;&upsilon;&tau;ό &tau;&omicron; &kappa;&omicron;&rho;&mu;ά&kappa;&iota; &epsilon;ί&nu;&alpha;&iota; &kappa;&alpha;&tau;&alpha;&sigma;&kappa;&epsilon;&upsilon;&alpha;&sigma;&mu;έ&nu;&omicron; &alpha;&pi;ό &alpha;&delta;&iota;&alpha;&phi;&alpha;&nu;ή &mu;&iota;&kappa;&rho;&omicron;ΐ&nu;&alpha; &gamma;&iota;&alpha; &tau;&omicron; &mu;&pi;&omicron;ύ&sigma;&tau;&omicron; &kappa;&alpha;&iota; &upsilon;&pi;έ&rho;&omicron;&chi;&eta; &delta;ί&chi;&rho;&omega;&mu;&eta; &phi;&lambda;&omicron;&rho;ά&lambda; &delta;&alpha;&nu;&tau;έ&lambda;&alpha; &gamma;&iota;&alpha; &tau;&omicron; &mu;&pi;&omicron;ύ&sigma;&tau;&omicron; &kappa;&alpha;&iota; &tau;&omicron; &kappa;ά&tau;&omega; &mu;έ&rho;&omicron;&sigmaf; &tau;&omicron;&upsilon; &sigma;ώ&mu;&alpha;&tau;&omicron;&sigmaf;.<br /><br />&Epsilon;&iota;&delta;&iota;&kappa;ά &sigma;&chi;&epsilon;&delta;&iota;&alpha;&sigma;&mu;έ&nu;&omicron; &gamma;&iota;&alpha; &tau;&iota;&sigmaf; &kappa;&alpha;&mu;&pi;ύ&lambda;&epsilon;&sigmaf; &mu;&alpha;&sigmaf;, &kappa;&omicron;&sigma;&mu;&epsilon;ί &tau;&omicron;&upsilon;&sigmaf; &gamma;&lambda;&omicron;&upsilon;&tau;&omicron;ύ&sigmaf; &mu;&epsilon; &lambda;&epsilon;&pi;&tau;&epsilon;&pi;ί&lambda;&epsilon;&pi;&tau;&alpha; &kappa;&epsilon;&nu;&tau;ή&mu;&alpha;&tau;&alpha; &sigma;&epsilon; &mu;&alpha;ύ&rho;&omicron; &kappa;&alpha;&iota; &mu;&omicron;&beta; &chi;&rho;ώ&mu;&alpha;.<br /><br />Ά&psi;&omicron;&gamma;&eta; &pi;&omicron;&iota;ό&tau;&eta;&tau;&alpha;, ά&nu;&omicron;&iota;&gamma;&mu;&alpha; &mu;&epsilon; &pi;&iota;&epsilon;&sigma;&tau;&iota;&kappa;ά &sigma;&tau;&omicron; &kappa;&alpha;&beta;ά&lambda;&omicron;.
guid
stringhttps://dev.divasboudoir.com/el/evangeline-plus-size-kormaki-mayro-kai-mov/sbbo0072.htm
highlights
string<ul> <li><strong>Αδιαφανές μπούστο από μικροΐνες</strong> που αναδεικνύει τέλεια όλα τα στήθη</li> <li><strong>Δίχρωμη φλοράλ δαντέλα</strong> στο μπούστο και στο κάτω μέρος του σώματος</li> <li><strong>Λεπτό μαύρο και μοβ κέντημα</strong> κοσμεί αισθησιακά τους γλουτούς</li> <li><strong>Άνοιγμα με πρέσα</strong> στον καβάλο για άτακτη πρόσβαση</li> <li><strong>Άψογη ποιότητα</strong> ειδικά σχεδιασμένη για τις καμπύλες σας</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringΥπέροχα χρώματα και φλοράλ δαντέλα για αυτό το όμορφο κορμάκι που διατίθεται σε όμορφα μεγάλα μεγέθη.
keywords
string
title
stringEvangeline plus size κορμάκι
seotitle
stringEvangeline plus size κορμάκι
seouri
stringevangeline-plus-size-kormaki-mayro-kai-mov
specifications
string<ul> <li><strong>Υλικό μπούστου:</strong> Υψηλής ποιότητας αδιαφανής μικροΐνα</li> <li><strong>Διακοσμητικό υλικό:</strong> Δίχρωμη δαντέλα με λουλούδια</li> <li><strong>Κέντημα:</strong> Λεπτά μοτίβα σε μαύρο και μοβ χρώμα στους γλουτούς</li> <li><strong>Μεγέθη:</strong> Διατίθεται στην πλήρη σειρά plus size</li> <li><strong>Κλείσιμο:</strong> Άνοιγμα με πρέσα στον καβάλο</li> <li><strong>Σχεδιασμός:</strong> Ειδικά προσαρμοσμένο στις γενναιόδωρες καμπύλες</li> </ul>
stylingtips
string<p>Το κορμάκι Evangeline είναι ό,τι χρειάζεστε για να δημιουργήσετε μια <strong>άκρως αισθησιακή</strong> εμφάνιση. Η δίχρωμη φλοράλ δαντέλα και τα λεπτά κεντήματα δημιουργούν ήδη ένα <strong>εντυπωσιακό</strong> οπτικό αποτέλεσμα που <strong>αποκαλύπτει την πιο σέξι πλευρά σας</strong>. Για να εντείνετε το <strong>άτακτο</strong> αποτέλεσμα, συνδυάστε το με αξεσουάρ που απηχούν τους μαύρους και μοβ τόνους του κεντήματος. Αυτό το κομμάτι, <strong>ειδικά σχεδιασμένο για τις καμπύλες σας</strong>, ταιριάζει απόλυτα με <strong>αισθησιακούς</strong>, εκλεπτυσμένους <strong>τόνους</strong>.</p> <p>Για μια ακόμα πιο <strong> ερωτική</strong> προσέγγιση, παίξτε με το άνοιγμα με κουμπώματα για να δημιουργήσετε διαφορετικά εφέ έκπληξης. Ολοκληρώστε την εμφάνισή σας με <strong>προκλητικά</strong> <a href="https://www.divasboudoir.com/el/megalo-anoichto-kormaki/">ανοιχτά κορμάκια</a> για ποικιλία, συνδυάστε τα με <strong>εξαιρετικά αισθησιακά</strong> <a href="https://www.divasboudoir.com/el/negklize-megaloy-megethoys/">νεγκλιζέ</a>, ή αναδείξτε τα πόδια σας με τις εκλεπτυσμένες <a href="https://www.divasboudoir.com/el/kaltses-megaloy-megethoys/">κάλτσες</a> και τα <strong>άτακτα</strong> <a href="https://www.divasboudoir.com/el/anoichto-kalson-megalo/">καλσόν</a> μας.</p>
summary
string&Upsilon;&pi;έ&rho;&omicron;&chi;&alpha; &chi;&rho;ώ&mu;&alpha;&tau;&alpha; &kappa;&alpha;&iota; &phi;&lambda;&omicron;&rho;ά&lambda; &delta;&alpha;&nu;&tau;έ&lambda;&alpha; &gamma;&iota;&alpha; &alpha;&upsilon;&tau;ό &tau;&omicron; ό&mu;&omicron;&rho;&phi;&omicron; &kappa;&omicron;&rho;&mu;ά&kappa;&iota; &pi;&omicron;&upsilon; &delta;&iota;&alpha;&tau;ί&theta;&epsilon;&tau;&alpha;&iota; &sigma;&epsilon; ό&mu;&omicron;&rho;&phi;&alpha; &mu;&epsilon;&gamma;ά&lambda;&alpha; &mu;&epsilon;&gamma;έ&theta;&eta;.
title
stringΣώμα Evangeline
usageinstructions
string<p>Το κορμάκι Evangeline είναι σχεδιασμένο για να <strong>αποκαλύπτει τον αισθησιασμό σας</strong> με εκλεπτυσμένο τρόπο. Το άνοιγμα με πρέσα στον καβάλο χειρίζεται εύκολα για <strong>άτακτη πρόσβαση</strong> ανάλογα με τη διάθεσή σας. Η αδιαφανής μικροΐνα παρέχει <strong>βέλτιστη στήριξη</strong> στο μπούστο, διατηρώντας παράλληλα μια <strong>εξαιρετικά σέξι</strong> εμφάνιση. Το λεπτό κέντημα στα οπίσθια δημιουργεί ένα <strong>προκλητικό</strong> αποτέλεσμα που σίγουρα θα τραβήξει τα βλέμματα όλων.</p> <p>Ιδανικό για <strong>αισθησιακές</strong> προσωπικές στιγμές ή για να νιώθετε <strong>ακαταμάχητα σέξι</strong> κάτω από τα ρούχα σας. Αυτό το εσώρουχο <strong> αγκαλιάζει τις καμπύλες σας</strong> για <strong>βέλτιστη άνεση</strong> που διαρκεί όλη την ημέρα.</p>
en
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Hand wash in lukewarm water (30&deg;C maximum)</li> <li>Use a mild detergent to preserve floral lace</li> <li>Handle black and mauve embroidery with care</li> <li>Dry flat, away from direct light</li> <li>Do not iron directly on delicate embroideries</li> </ul>
description
stringEvangeline<br /><br />This bodysuit is made from opaque microfiber for the bodice and gorgeous two-tone floral lace for the bust and lower body.<br /><br />Specially designed for our curves, it adorns the buttocks with delicate black and purple embroidery.<br /><br />Impeccable quality, snap opening at crotch.
guid
stringhttps://dev.divasboudoir.com/en/evangeline-plus-size-bodysuit-black-and-purple/sbbo0072.htm
highlights
string<ul> <li><strong>Opaque microfibre bodice</strong> perfectly enhances all breasts</li> <li><strong>Two-tone floral lace</strong> on bust and lower body</li> <li><strong>Delicate black and purple embroidery</strong> sensually adorns the buttocks</li> <li><strong>Snaps</strong> at crotch for naughty access</li> <li><strong>Impeccable quality</strong> specially designed for your curves</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringSuperb colors and floral lace for this pretty bodysuit, available in beautiful plus sizes.
keywords
string
title
stringEvangeline plus size bodysuit
seotitle
stringEvangeline plus size bodysuit
seouri
stringevangeline-plus-size-bodysuit-black-and-purple
specifications
string<ul> <li><strong>Bodice material:</strong> High-quality opaque microfibre</li> <li><strong>Decorative material:</strong> Two-tone floral lace</li> <li><strong>Embroidery</strong>: Delicate black and mauve motifs on buttocks</li> <li><strong>Sizes:</strong> Available in all plus size ranges</li> <li><strong>Closure:</strong> Press stud opening at crotch</li> <li><strong>Design:</strong> Specially adapted to generous curves</li> </ul>
stylingtips
string<p>The Evangeline bodysuit is all you need to create an <strong>ultra-sensual</strong> look. The two-tone floral lace and delicate embroidery already create a <strong>striking</strong> visual effect that <strong>reveals your sexiest side</strong>. To intensify the <strong>naughty</strong> effect, pair it with accessories that echo the black and mauve tones of the embroidery. This piece, <strong>specially designed for your curves</strong>, goes perfectly with <strong>sensual</strong>, sophisticated <strong>tones</strong>.</p> <p>For an even more <strong> erotic</strong> approach, play with the snap opening to create different surprise effects. Complete your look with <strong>provocative</strong> <a href="https://www.divasboudoir.com/en/open-bodysuit-plus-size/">open bodysuits</a> for variety, pair with <strong>ultra-sensual</strong> <a href="https://www.divasboudoir.com/en/plus-size-robes/">negligees</a>, or sublimate your legs with our sophisticated <a href="https://www.divasboudoir.com/en/socks-large-size/">stockings</a> and <strong>naughty</strong> <a href="https://www.divasboudoir.com/en/open-tights-plus-size/">tights</a>.</p>
summary
stringSuperb colors and floral lace for this pretty bodysuit, available in beautiful plus sizes.
title
stringBody Evangeline
usageinstructions
string<p>The Evangeline bodysuit is designed to <strong>reveal your sensuality</strong> with sophistication. The snap opening at the crotch is easy to manipulate for <strong>naughty access</strong> according to your mood. The opaque microfiber provides <strong>optimum support</strong> for the bust while maintaining an <strong>ultra-sexy</strong> look. Delicate embroidery on the buttocks creates a <strong>provocative</strong>, eye-catching effect.</p> <p>Perfect for <strong>sensual</strong> intimate moments or for feeling <strong>irresistibly sexy</strong> under your clothes. This lingerie <strong> hugs your curves</strong> for <strong>optimum comfort</strong> that lasts all day.</p>
es
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavar a mano con agua tibia (30&deg;C máximo)</li> <li>Utilice un detergente suave para conservar el encaje floral</li> <li>Manipular con cuidado los bordados negros y malvas</li> <li>Séquelo en plano, lejos de la luz directa</li> <li>No planchar directamente sobre bordados delicados</li> </ul>
description
stringEvangeline<br /><br />Este body est&aacute; confeccionado en microfibra opaca para el corpi&ntilde;o y magn&iacute;fico encaje floral bicolor para el busto y la parte inferior del cuerpo.<br /><br />Especialmente dise&ntilde;ado para nuestras curvas, adorna las nalgas con delicados bordados negros y morados.<br /><br />Calidad impecable, abertura con botones a presi&oacute;n en la entrepierna.
guid
stringhttps://dev.divasboudoir.com/es/body-talla-grande-evangeline-negro-y-lila/sbbo0072.htm
highlights
string<ul> <li><strong>Corpiño de microfibra opaca</strong> que realza perfectamente todos los pechos</li> <li><strong>Encaje floral bicolor</strong> en el busto y la parte inferior del cuerpo</li> <li><strong>Delicado bordado negro y morado</strong> que adorna sensualmente las nalgas</li> <li><strong>Abertura con botones a presión</strong> en la entrepierna para un acceso travieso</li> <li><strong>Calidad impecable</strong> especialmente diseñada para tus curvas</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringMagníficos colores y encaje floral para este bonito body que se presenta en preciosas tallas grandes.
keywords
string
title
stringBody talla grande Evangeline
seotitle
stringBody talla grande Evangeline
seouri
stringbody-talla-grande-evangeline-negro-y-lila
specifications
string<ul> <li><strong>Material del corpiño</strong>: microfibra opaca de alta calidad</li> <li><strong>Material decorativo:</strong> Encaje floral bicolor</li> <li><strong>Bordado:</strong> Delicados motivos negros y morados en las nalgas</li> <li><strong>Tallas</strong>: Disponible en toda la gama de tallas grandes</li> <li><strong>Cierre:</strong> Abertura con botones a presión en la entrepierna</li> <li><strong>Diseño:</strong> Especialmente adaptado a las curvas generosas</li> </ul>
stylingtips
string<p>El body Evangeline es todo lo que necesitas para crear un look <strong>ultrasensual</strong>. El encaje floral bicolor y los delicados bordados ya crean un efecto visual <strong>impactante</strong> que <strong>revela tu lado más sexy</strong>. Para intensificar el efecto <strong>travieso</strong>, combínalo con accesorios que hagan eco de los tonos negros y morados del bordado. Esta pieza, <strong>especialmente diseñada para tus curvas</strong>, combina a la perfección con <strong>tonos sensuales</strong> y sofisticados.</p> <p>Para un enfoque aún más <strong> erótico</strong>, juega con la abertura a presión para crear diferentes efectos sorpresa. Completa tu look con <strong>provocativos</strong> <a href="https://www.divasboudoir.com/es/body-abierto-talla-grande/">bodys</a> abiertos para variar, combínalos con <a href="https://www.divasboudoir.com/es/picardias-talla-grande/">picardías</a> <strong>ultrasensuales</strong> o sublima tus piernas con nuestras sofisticadas <a href="https://www.divasboudoir.com/es/medias-grandes/">medias</a> y <strong>traviesos</strong> <a href="https://www.divasboudoir.com/es/medias-abiertas-talla-grande/">pantys</a>.</p>
summary
stringMagn&iacute;ficos colores y encaje floral para este bonito body que se presenta en preciosas tallas grandes.
title
stringBody Evangeline
usageinstructions
string<p>El body Evangeline está diseñado para <strong>revelar tu sensualidad</strong> con sofisticación. La abertura a presión de la entrepierna es fácil de manipular para <strong>un acceso travieso</strong> según tu estado de ánimo. La microfibra opaca proporciona <strong>una sujeción óptima</strong> al busto, al tiempo que mantiene un aspecto <strong>ultra sexy</strong>. Los delicados bordados de las nalgas crean un efecto <strong>provocativo</strong> que atraerá todas las miradas.</p> <p>Perfecto para momentos íntimos <strong>sensuales</strong> o para sentirse <strong>irresistiblemente sexy</strong> bajo la ropa. Esta lencería <strong> abraza tus curvas</strong> para ofrecerte <strong>un confort óptimo</strong> que dura todo el día.</p>
fr
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavage &agrave; la main &agrave; l'eau ti&egrave;de (30&deg;C maximum)</li> <li>Utiliser une lessive douce pour pr&eacute;server la dentelle florale</li> <li>Manipuler d&eacute;licatement les broderies noires et mauves</li> <li>S&eacute;chage &agrave; plat, &agrave; l'abri de la lumi&egrave;re directe</li> <li>Ne pas repasser directement sur les broderies d&eacute;licates</li> </ul>
description
string<p>Le body Evangeline incarne la <strong>sensualit&eacute; raffin&eacute;e</strong> avec sa combinaison audacieuse de microfibre opaque et dentelle florale bicolore.</p> <p>Cette lingerie&nbsp;<strong>ultra sexy</strong> <strong>sublime vos courbes g&eacute;n&eacute;reuses</strong> gr&acirc;ce &agrave; sa conception sp&eacute;cialement pens&eacute;e pour vos rondeurs. Le corsage en microfibre opaque <strong>&eacute;pouse parfaitement toutes les morphologies</strong>, tandis que la dentelle florale bicolore sur la poitrine et le bas du corps cr&eacute;e un effet visuel <strong>irr&eacute;sistiblement coquin</strong>.</p> <p>Les broderies d&eacute;licates noires et mauves qui ornent les fesses ajoutent une touche&nbsp;<strong>&eacute;rotique</strong> sophistiqu&eacute;e. L'ouverture par pressions &agrave; l'entrejambe offre un <strong>acc&egrave;s sensuel</strong> tout en conservant l'&eacute;l&eacute;gance de la pi&egrave;ce.</p> <p>Cette cr&eacute;ation&nbsp;<strong>s'adapte parfaitement &agrave; toutes les morphologies</strong> gr&acirc;ce &agrave; ses <strong>mati&egrave;res extensibles</strong> et sa <strong>qualit&eacute; impeccable</strong> qui garantit un <strong>confort optimal toute la journ&eacute;e</strong>.</p>
guid
stringhttps://dev.divasboudoir.com/fr/body-microfibre-dentelle-florale-grande-taille/sbbo0072.htm
highlights
string<ul> <li><strong>Microfibre opaque corsage</strong> qui sublime parfaitement toutes les poitrines</li> <li><strong>Dentelle florale bicolore</strong> sur la poitrine et le bas du corps</li> <li><strong>Broderies d&eacute;licates noires et mauves</strong> qui ornent sensuellement les fesses</li> <li><strong>Ouverture par pressions</strong> &agrave; l'entrejambe pour un acc&egrave;s coquin</li> <li><strong>Qualit&eacute; impeccable</strong> sp&eacute;cialement con&ccedil;ue pour vos rondeurs</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringBody Evangeline ultra sexy grande taille : microfibre opaque, dentelle florale bicolore, broderies délicates fesses, ouverture pressions. Sensualité raffinée | Diva's Boudoir
keywords
string
title
stringBody Evangeline microfibre dentelle grande taille | Diva's Boudoir
seotitle
stringBody grande taille microfibre et dentelle florale avec ouverture
seouri
stringbody-microfibre-dentelle-florale-grande-taille
specifications
string<ul> <li><strong>Mati&egrave;re corsage :</strong> Microfibre opaque de qualit&eacute; sup&eacute;rieure</li> <li><strong>Mati&egrave;re d&eacute;corative :</strong> Dentelle florale bicolore</li> <li><strong>Broderies :</strong> Motifs d&eacute;licats noires et mauves sur les fesses</li> <li><strong>Tailles :</strong> Disponible dans toute la gamme grande taille</li> <li><strong>Fermeture :</strong> Ouverture par pressions &agrave; l'entrejambe</li> <li><strong>Conception :</strong> Sp&eacute;cialement adapt&eacute;e aux rondeurs g&eacute;n&eacute;reuses</li> </ul>
stylingtips
string<p>Le body Evangeline se suffit &agrave; lui-m&ecirc;me pour cr&eacute;er un look <strong>ultra sensuel</strong>. La dentelle florale bicolore et les broderies d&eacute;licates cr&eacute;ent d&eacute;j&agrave; un effet visuel <strong>saisissant</strong> qui <strong>r&eacute;v&egrave;le votre c&ocirc;t&eacute; le plus sexy</strong>. Pour intensifier l'effet <strong>coquin</strong>, associez-le &agrave; des accessoires qui rappellent les tons noirs et mauves des broderies. Cette pi&egrave;ce <strong>sp&eacute;cialement con&ccedil;ue pour vos rondeurs</strong> s'accorde parfaitement avec des <strong>tons sensuels</strong> et sophistiqu&eacute;s.</p> <p>Pour une approche encore plus&nbsp;<strong>&eacute;rotique</strong>, jouez avec l'ouverture par pressions pour cr&eacute;er diff&eacute;rents effets de surprise. Compl&eacute;tez votre look avec des <a href="https://www.divasboudoir.com/fr/body-ouvert-grande-taille/">bodys ouverts</a> <strong>provocants</strong> pour varier les plaisirs, associez &agrave; des <a href="https://www.divasboudoir.com/fr/deshabille-grande-taille/">d&eacute;shabill&eacute;s</a> <strong>ultra sensuels</strong>, ou sublimez vos jambes avec nos <a href="https://www.divasboudoir.com/fr/bas-grande-taille/">bas</a> sophistiqu&eacute;s et nos <a href="https://www.divasboudoir.com/fr/collant-ouvert-grande-taille/">collants</a> <strong>coquins</strong>.</p> <p>Envie de superbes bas autofixants &agrave; votre taille, retrouvez la s&eacute;lection de <a href="https://www.legsboudoir.com/fr/bas-autofixants-grande-taille/">Legs Boudoir</a>, jusqu'&agrave; la taille 64!</p>
summary
string<p>D&eacute;couvrez le body Evangeline, une cr&eacute;ation ultra sensuelle qui marie microfibre opaque et dentelle florale bicolore.</p> <p>Sp&eacute;cialement con&ccedil;u pour sublimer vos rondeurs avec des broderies d&eacute;licates et une ouverture coquine &agrave; l'entrejambe.</p>
title
stringBody Evangeline : Microfibre Opaque et Dentelle Florale Bicolore Ultra Sexy
usageinstructions
string<p>Le body Evangeline est con&ccedil;u pour <strong>r&eacute;v&eacute;ler votre sensualit&eacute;</strong> avec sophistication. L'ouverture par pressions &agrave; l'entrejambe se manipule facilement pour un <strong>acc&egrave;s coquin</strong> selon vos envies du moment. La microfibre opaque offre un <strong>maintien optimal</strong> de la poitrine tout en conservant un look <strong>ultra sexy</strong>. Les broderies d&eacute;licates sur les fesses cr&eacute;ent un effet <strong>provocant</strong> qui attire tous les regards.</p> <p>Parfait pour les moments intimes&nbsp;<strong>sensuels</strong> ou pour vous sentir <strong>irr&eacute;sistiblement sexy</strong> sous vos v&ecirc;tements. Cette lingerie <strong>&eacute;pouse parfaitement vos rondeurs</strong> pour un <strong>confort optimal</strong> qui dure toute la journ&eacute;e.</p>
it
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavare a mano in acqua tiepida (massimo 30&deg;C)</li> <li>Utilizzare un detergente delicato per preservare il pizzo floreale</li> <li>Maneggiare con cura i ricami neri e malva</li> <li>Asciugare in piano, al riparo dalla luce diretta</li> <li>Non stirare direttamente i ricami delicati</li> </ul>
description
stringEvangeline<br /><br />Questo body &egrave; realizzato in microfibra opaca per il corpetto e in superbo pizzo floreale bicolore per il busto e la parte inferiore del corpo.<br /><br />Appositamente studiato per le nostre curve, adorna i glutei con delicati ricami neri e viola.<br /><br />Qualit&agrave; impeccabile, apertura con bottoni a pressione sul cavallo.
guid
stringhttps://dev.divasboudoir.com/it/body-evangeline-taglia-grande-nero-e-malva/sbbo0072.htm
highlights
string<ul> <li><strong>Corpetto in microfibra opaca</strong> che valorizza perfettamente tutti i seni</li> <li><strong>Pizzo floreale bicolore</strong> sul busto e sulla parte inferiore del corpo</li> <li><strong>Delicati ricami neri e viola</strong> adornano sensualmente i glutei</li> <li><strong>Apertura con bottoni a pressione</strong> sul cavallo per un accesso più malizioso</li> <li><strong>Qualità impeccabile</strong>, appositamente studiata per le vostre curve</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringColori superbi e pizzo floreale per questo grazioso body disponibile in una bella taglia grande.
keywords
string
title
stringBody Evangeline taglia grande
seotitle
stringBody Evangeline taglia grande
seouri
stringbody-evangeline-taglia-grande-nero-e-malva
specifications
stringEntdecken Sie die "Hot"-Kollektion offener Lingerie in großen Größen bei Diva's Boudoir. Wagen Sie Sinnlichkeit mit gewagten Schnitten und verführerischen Materialien. Zeigen Sie sich von Ihrer heißesten Seite!
stylingtips
string<p>Il body Evangeline è tutto ciò che vi serve per creare un look <strong>ultra-sensuale</strong>. Il pizzo floreale bicolore e i delicati ricami creano già un effetto visivo <strong>sorprendente</strong> che <strong>rivela il vostro lato più sexy</strong>. Per intensificare l'effetto <strong>malizioso</strong>, abbinatelo ad accessori che riprendano i toni neri e viola dei ricami. Questo capo, <strong>studiato appositamente per le vostre curve</strong>, si abbina perfettamente a <strong>toni sensuali</strong> e sofisticati.</p> <p>Per un approccio ancora più <strong> erotico</strong>, giocate con l'apertura a scatto per creare diversi effetti sorpresa. Completate il vostro look con <strong>provocanti</strong> <a href="https://www.divasboudoir.com/it/body-aperto-di-grande-taglia/">body aperti</a> per variare, abbinateli a <a href="https://www.divasboudoir.com/it/vestaglia-taglia-grande/">vestaglie</a> <strong>ultra-sensuali</strong> o sublimate le vostre gambe con le nostre sofisticate <a href="https://www.divasboudoir.com/it/calze-di-grandi-dimensioni/">calze</a> e <a href="https://www.divasboudoir.com/it/collant-aperti-di-taglia-grande/">collant</a> <strong>maliziosi</strong>.</p>
summary
stringColori superbi e pizzo floreale per questo grazioso body disponibile in una bella taglia grande.
title
stringBody Evangeline
usageinstructions
string<p>Il body Evangeline è progettato per <strong>rivelare la vostra sensualità</strong> con raffinatezza. L'apertura con bottoni a pressione sul cavallo è facile da manipolare per un <strong>accesso malizioso</strong> a seconda del vostro umore. La microfibra opaca offre un <strong>sostegno ottimale</strong> al seno, mantenendo un look <strong>ultra-sexy</strong>. I delicati ricami sui glutei creano un effetto <strong>provocante</strong> che attirerà sicuramente l'attenzione di tutti.</p> <p>Perfetto per i momenti di intimità <strong>sensuale</strong> o per sentirsi <strong>irresistibilmente sexy</strong> sotto i vestiti. Questa lingerie <strong> abbraccia le vostre curve</strong> per un <strong>comfort ottimale</strong> che dura tutto il giorno.</p>
nl
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Handwas in lauw water (maximaal 30&deg;C)</li> <li>Gebruik een mild wasmiddel om het bloemenkant te behouden</li> <li>Ga voorzichtig om met zwart en mauve borduurwerk</li> <li>Plat drogen, niet in direct licht</li> <li>Niet rechtstreeks strijken op delicaat borduurwerk</li> </ul>
description
stringEvangeline<br /><br />Deze bodysuit is gemaakt van ondoorzichtig microvezel voor het lijfje en prachtig tweekleurig bloemenkant voor de buste en het onderlichaam.<br /><br />Speciaal ontworpen voor onze rondingen, versiert het de billen met delicaat zwart en paars borduurwerk.<br /><br />Onberispelijke kwaliteit, opening met drukknoop in het kruis.
guid
stringhttps://dev.divasboudoir.com/nl/rompertje-evangeline-groote-maat-zwart-en-mauve/sbbo0072.htm
highlights
string<ul> <li><strong>Ondoorzichtig lijfje van microvezel</strong> dat alle borsten perfect laat uitkomen</li> <li><strong>Tweekleurig bloemenkant</strong> op buste en onderlichaam</li> <li><strong>Delicaat zwart en paars borduurwerk</strong> siert sensueel de billen</li> <li><strong>Drukknoopopenopening</strong> in het kruis voor ondeugende toegang</li> <li><strong>Onberispelijke kwaliteit</strong>, speciaal ontworpen voor jouw rondingen</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringSchitterende kleuren en bloemenkant voor dit mooie rompertje dat verkrijgbaar is in mooie groote maten.
keywords
string
title
stringRompertje Evangeline groote maat
seotitle
stringRompertje Evangeline groote maat
seouri
stringrompertje-evangeline-groote-maat-zwart-en-mauve
specifications
string<ul> <li><strong>Materiaal lijfje:</strong> Hoogwaardige ondoorzichtige microvezel</li> <li><strong>Decoratiemateriaal:</strong> Tweekleurig bloemenkant</li> <li><strong>Borduursel:</strong> Delicate zwarte en paarse motieven op billen</li> <li><strong>Maten:</strong> Verkrijgbaar in de grote maten</li> <li><strong>Sluiting:</strong> Drukknoopsluiting in kruis</li> <li><strong>Ontwerp:</strong> Speciaal aangepast aan royale rondingen</li> </ul>
stylingtips
string<p>De Evangeline bodysuit is alles wat je nodig hebt om een <strong>ultra-sensuele</strong> look te creëren. Het tweekleurige bloemenkant en het delicate borduursel creëren al een <strong>opvallend</strong> visueel effect dat <strong>je van je meest sexy kant laat zien</strong>. Om het <strong>ondeugende</strong> effect te versterken, combineer je het met accessoires die de zwarte en paarse tinten van het borduursel weerspiegelen. Dit stuk, <strong>speciaal ontworpen voor je rondingen</strong>, past perfect bij <strong>sensuele</strong>, geraffineerde <strong>tinten</strong>.</p> <p>Voor een nog <strong> erotischere</strong> aanpak kun je spelen met de drukknoopopen om verschillende verrassingseffecten te creëren. Maak je look compleet met <strong>provocerende</strong> <a href="https://www.divasboudoir.com/nl/groote-open-romper/">open bodysuits</a> voor afwisseling, combineer met <strong>ultra-sensuele</strong> <a href="https://www.divasboudoir.com/nl/grote-maat-neglige/">negligés</a>, of sublimeer je benen met onze geraffineerde <a href="https://www.divasboudoir.com/nl/grote-maat-kousen/">kousen</a> en <strong>ondeugende</strong> <a href="https://www.divasboudoir.com/nl/open-panty-groote-maat/">panty's</a>.</p>
summary
stringSchitterende kleuren en bloemenkant voor dit mooie rompertje dat verkrijgbaar is in mooie groote maten.
title
stringBodysuit Evangeline
usageinstructions
string<p>De Evangeline bodysuit is ontworpen om <strong>je sensualiteit</strong> geraffineerd <strong>te onthullen</strong>. De drukknoopsluiting in het kruis is gemakkelijk te manipuleren voor <strong>ondeugende toegang</strong>, afhankelijk van je stemming. De ondoorzichtige microvezel biedt <strong>optimale ondersteuning</strong> voor de buste terwijl het een <strong>ultra-sexy</strong> look behoudt. Delicaat borduurwerk op de billen creëert een <strong>provocerend</strong> effect dat zeker ieders aandacht zal trekken.</p> <p>Perfect voor <strong>sensuele</strong> intieme momenten of om je <strong>onweerstaanbaar sexy</strong> te voelen onder je kleding. Deze lingerie <strong> omhelst je rondingen</strong> voor <strong>optimaal comfort</strong> dat de hele dag aanhoudt.</p>
pt
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavar à mão em água tépida (30&deg;C no máximo)</li> <li>Utilizar um detergente suave para preservar a renda floral</li> <li>Manusear os bordados pretos e malva com cuidado</li> <li>Secar em local plano, longe da luz direta</li> <li>Não passar a ferro diretamente sobre bordados delicados</li> </ul>
description
stringEvangelina<br /><br />Este body &eacute; confeccionado em microfibra opaca para o corpete e em magn&iacute;fica renda floral bicolor para o busto e a parte inferior do corpo.<br /><br />Especialmente concebido para as nossas curvas, adorna as n&aacute;degas com delicados bordados pretos e roxos.<br /><br />Qualidade impec&aacute;vel, abertura com bot&otilde;es de press&atilde;o na virilha.
guid
stringhttps://dev.divasboudoir.com/pt/evangeline-body-plus-size-preto-e-lilas/sbbo0072.htm
highlights
string<ul> <li><strong>Corpete em microfibra opaca</strong> que realça perfeitamente todos os seios</li> <li><strong>Renda floral em dois tons</strong> no busto e na parte inferior do corpo</li> <li><strong>Delicados bordados pretos e roxos</strong> adornam sensualmente as nádegas</li> <li><strong>Abertura com botões de pressão</strong> nas virilhas para um acesso atrevido</li> <li><strong>Qualidade impecável</strong> especialmente concebida para as suas curvas</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringCores magníficas e rendas florais para este bonito body, disponível em belos tamanhos grandes.
keywords
string
title
stringEvangeline body plus size
seotitle
stringEvangeline body plus size
seouri
stringevangeline-body-plus-size-preto-e-lilas
specifications
string<ul> <li><strong>Material do corpete:</strong> microfibra opaca de alta qualidade</li> <li><strong>Material decorativo:</strong> Renda floral em dois tons</li> <li><strong>Bordado:</strong> Delicados motivos pretos e roxos nas nádegas</li> <li><strong>Tamanhos:</strong> Disponível em toda a gama plus size</li> <li><strong>Fecho:</strong> Abertura com botões de pressão nas virilhas</li> <li><strong>Design:</strong> Especialmente adaptado a curvas generosas</li> </ul>
stylingtips
string<p>O body Evangeline é tudo o que precisa para criar um look <strong>ultra-sensual</strong>. A renda floral de dois tons e o bordado delicado já criam um efeito visual <strong>marcante</strong> que <strong>revela o seu lado mais sexy</strong>. Para intensificar o efeito <strong>atrevido</strong>, combine-o com acessórios que façam eco dos tons preto e roxo do bordado. Esta peça, <strong>especialmente concebida para as suas curvas</strong>, combina na perfeição com <strong>tons sensuais</strong> e sofisticados.</p> <p>Para uma abordagem ainda mais <strong> erótica</strong>, brinque com a abertura de encaixe para criar diferentes efeitos surpresa. Complete o seu look com os <strong>provocantes</strong> <a href="https://www.divasboudoir.com/pt/body-grande-aberto/">bodys abertos</a> para variar, combine-os com <a href="https://www.divasboudoir.com/pt/batotas-plus-size/">negligés</a> <strong>ultra-sensuais</strong> ou sublimar as suas pernas com as nossas sofisticadas <a href="https://www.divasboudoir.com/pt/meias-de-tamanho-grande/">meias</a> de ligas e <a href="https://www.divasboudoir.com/pt/meias-abertas-tamanho-grande/">collants</a> <strong>atrevidos</strong>.</p>
summary
stringCores magn&iacute;ficas e rendas florais para este bonito body, dispon&iacute;vel em belos tamanhos grandes.
title
stringBody Evangelina
usageinstructions
string<p>O body Evangeline foi concebido para <strong>revelar a sua sensualidade</strong> com sofisticação. A abertura com botões de pressão na virilha é fácil de manipular para um <strong>acesso atrevido</strong> de acordo com a sua disposição. A microfibra opaca proporciona <strong>um suporte ótimo</strong> para o busto, mantendo um aspeto <strong>ultra-sexy</strong>. Os delicados bordados nas nádegas criam um efeito <strong>provocante</strong> que certamente chamará a atenção de todos.</p> <p>Perfeita para momentos íntimos <strong>sensuais</strong> ou para se sentir <strong>irresistivelmente sexy</strong> debaixo da roupa. Esta lingerie <strong> abraça as suas curvas</strong> para um <strong>conforto ótimo</strong> que dura todo o dia.</p>
fetishboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz-und-lila
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro-kai-mov
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black-and-purple
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro-y-lila
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-et-mauve
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero-e-malva
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart-en-mauve
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto-e-lilas
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
latexboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz-und-lila
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro-kai-mov
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black-and-purple
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro-y-lila
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-et-mauve
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero-e-malva
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart-en-mauve
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto-e-lilas
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
legsboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz-und-lila
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro-kai-mov
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black-and-purple
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro-y-lila
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-et-mauve
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero-e-malva
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart-en-mauve
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto-e-lilas
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
lustboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz-und-lila
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro-kai-mov
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black-and-purple
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro-y-lila
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-et-mauve
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero-e-malva
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart-en-mauve
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto-e-lilas
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
smboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz-und-lila
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro-kai-mov
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black-and-purple
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro-y-lila
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-et-mauve
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero-e-malva
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart-en-mauve
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto-e-lilas
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
name
stringBody
netweight
string
nextshipment
stringtoday
ordered
number22
orderidx
number0
origin
string
originalsize
string
packaging
number0
productshipment
stringauto
productuid
string0D33AF60-78D4-489B-AE88E9EBAC8B09B7
promountil
string
rating
stringnone
recorduid
string0D33AF60-78D4-489B-AE88E9EBAC8B09B7
reference
stringSBBO0072
related
string
reserved
number1
returned
number0
returnsallowed
number1
section
stringlingerie
shipment
string4to6days
showbrand
number0
sizeinfos
Query
Template: /system/api/product/sizes.cfc:20
Execution Time: 1.67 ms
Record Count: 9
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,'1408,736,737,738,739,740,741,742,743') > 0
and product_variations.productuid = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7'
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
1737XL+intlsizeblackpurpleXL+XL+-19999990wpluslingerieXLXL+48-5018-2022-2450-5250-5248-5054-5650-5248-50113-11896-102117-121
27392XL+intlsizeblackpurple2XL+2XL+-19999990wpluslingerie2XL2XL+52-5422-2426-2854-5654-5652-5458-6054-5652-54125-130109-114127-132
37413XL+intlsizeblackpurple3XL+3XL+-19999991wpluslingerie3XL3XL+56-5826-2830-3258-6058-6056-5862-6458-6056-58137-142122-128138-144
47434XL+intlsizeblackpurple4XL+4XL+-19999990wpluslingerie4XL4XL+60-6230-3234-3862-6462-6460-6266-6862-6460-62149-154135-140151-156
51408LintlsizeblackpurpleLL-19999990wpluslingerieXLL44-4614-1618-2046-4846-4844-4650-5246-4844-46103-10686-90109-112
6736XLintlsizeblackpurpleXLXL-19999990wpluslingerieXLXL46-4816-1820-2248-5048-5046-4852-5448-5046-48107-11291-95113-116
77382XLintlsizeblackpurple2XL2XL-19999990wpluslingerie2XL2XL50-5220-2424-2852-5452-5450-5256-5852-5450-52119-124103-108122-126
87403XLintlsizeblackpurple3XL3XL-19999991wpluslingerie3XL3XL54-5624-2628-3056-5856-5854-5660-6256-5854-56131-136115-121133-138
97424XLintlsizeblackpurple4XL4XL-19999990wpluslingerie4XL4XL58-6028-3032-3460-6260-6258-6064-6860-6258-60143-148129-134145-150
sizeranges
stringplus
sizes
string1408,736,737,738,739,740,741,742,743
sizetype
stringauto
specifications
Struct
Entries: 23
belly
string
bones
string
bra
string
breasts
string
bust
string
closing
string
crochtless
string
cups
string
cut
string
garter
string
halter
string
lacing
string
lining
string
modestypanel
string
panty
string
sheathing
string
sleeves
string
stocking
string
straps
string
stretch
string
suspenders
string
transparency
string
underwires
string
stock
number0
stocks
Query
Template: /system/api/product/stocks.cfc:25
Execution Time: 9.5 ms
Record Count: 4
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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7'
and product_variations.isactive = 1
and product_sizes.id_size = 1408
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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7'
and product_variations.isactive = 1
and product_sizes.id_size = 736
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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7'
and product_variations.isactive = 1
and product_sizes.id_size = 737
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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7'
and product_variations.isactive = 1
and product_sizes.id_size = 738
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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7'
and product_variations.isactive = 1
and product_sizes.id_size = 739
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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7'
and product_variations.isactive = 1
and product_sizes.id_size = 740
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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7'
and product_variations.isactive = 1
and product_sizes.id_size = 741
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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7'
and product_variations.isactive = 1
and product_sizes.id_size = 742
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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7'
and product_variations.isactive = 1
and product_sizes.id_size = 743
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
10D33AF60-78D4-489B-AE88E9EBAC8B09B7B92C18A0-956D-4474-AB1599317F123D3F1408blackpurplelinear-gradient(90deg, #000000 50%, #9400D4 50%)XLL44-4614-1618-2046-4846-4844-4650-5246-4844-46wlingerieLintlsize41.6250STOCK01000-101200264294810514024144122172-10all
20D33AF60-78D4-489B-AE88E9EBAC8B09B70EF110CC-DD9F-40B8-81D96288720637EF738blackpurplelinear-gradient(90deg, #000000 50%, #9400D4 50%)2XL2XL50-5220-2424-2852-5452-5450-5256-5852-5450-52wlingerie2XLintlsize41.6250STOCK01000-11500264294810614024144122189-10all
30D33AF60-78D4-489B-AE88E9EBAC8B09B78A34A41F-D177-46E7-B9B53AE1E6F31E2D740blackpurplelinear-gradient(90deg, #000000 50%, #9400D4 50%)3XL3XL54-5624-2628-3056-5856-5854-5660-6256-5854-56wlingerie3XLintlsize41.6250STOCK01100-1020026429481071402414412219611all
40D33AF60-78D4-489B-AE88E9EBAC8B09B770AFAD13-C9D0-4EAE-AA18E923F9318A1A742blackpurplelinear-gradient(90deg, #000000 50%, #9400D4 50%)4XL4XL58-6028-3032-3460-6260-6258-6064-6860-6258-60wlingerie4XLintlsize41.6250STOCK01000-10300264294810814024144122202-10all
subcategory
stringbody
supplier
number-1
supplierreference
string26429481051
tags
string
themes
string
totalvariations
number4
type
stringdefault
unitprice
number41.625
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 20.4 ms
Record Count: 9
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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7'
and product_variations.isactive = 1
and product_sizes.id_size = 1408
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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7'
and product_variations.isactive = 1
and product_sizes.id_size = 736
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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7'
and product_variations.isactive = 1
and product_sizes.id_size = 737
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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7'
and product_variations.isactive = 1
and product_sizes.id_size = 738
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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7'
and product_variations.isactive = 1
and product_sizes.id_size = 739
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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7'
and product_variations.isactive = 1
and product_sizes.id_size = 740
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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7'
and product_variations.isactive = 1
and product_sizes.id_size = 741
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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7'
and product_variations.isactive = 1
and product_sizes.id_size = 742
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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7'
and product_variations.isactive = 1
and product_sizes.id_size = 743
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
1B92C18A0-956D-4474-AB1599317F123D3F737blackpurplelinear-gradient(90deg, #000000 50%, #9400D4 50%)XLXL+48-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerieXL+intlsize41.6250STOCK01000-101200264294810514024144122172-10-10-10041.625all
20EF110CC-DD9F-40B8-81D96288720637EF739blackpurplelinear-gradient(90deg, #000000 50%, #9400D4 50%)2XL2XL+52-5422-2426-2854-5654-5652-5458-6054-5652-54wlingerie2XL+intlsize41.6250STOCK01000-11500264294810614024144122189-10-10-10041.625all
38A34A41F-D177-46E7-B9B53AE1E6F31E2D741blackpurplelinear-gradient(90deg, #000000 50%, #9400D4 50%)3XL3XL+56-5826-2830-3258-6058-6056-5862-6458-6056-58wlingerie3XL+intlsize41.6250STOCK01100-1020026429481071402414412219611-11-10041.625all
470AFAD13-C9D0-4EAE-AA18E923F9318A1A743blackpurplelinear-gradient(90deg, #000000 50%, #9400D4 50%)4XL4XL+60-6230-3234-3862-6462-6460-6266-6862-6460-62wlingerie4XL+intlsize41.6250STOCK01000-10300264294810814024144122202-10-10-10041.625all
5B92C18A0-956D-4474-AB1599317F123D3F1408blackpurplelinear-gradient(90deg, #000000 50%, #9400D4 50%)XLL44-4614-1618-2046-4846-4844-4650-5246-4844-46wlingerieLintlsize41.6250STOCK01000-101200264294810514024144122172-10-10-10041.625all
6B92C18A0-956D-4474-AB1599317F123D3F736blackpurplelinear-gradient(90deg, #000000 50%, #9400D4 50%)XLXL46-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerieXLintlsize41.6250STOCK01000-101200264294810514024144122172-10-10-10041.625all
70EF110CC-DD9F-40B8-81D96288720637EF738blackpurplelinear-gradient(90deg, #000000 50%, #9400D4 50%)2XL2XL50-5220-2424-2852-5452-5450-5256-5852-5450-52wlingerie2XLintlsize41.6250STOCK01000-11500264294810614024144122189-10-10-10041.625all
88A34A41F-D177-46E7-B9B53AE1E6F31E2D740blackpurplelinear-gradient(90deg, #000000 50%, #9400D4 50%)3XL3XL54-5624-2628-3056-5856-5854-5660-6256-5854-56wlingerie3XLintlsize41.6250STOCK01100-1020026429481071402414412219611-11-10041.625all
970AFAD13-C9D0-4EAE-AA18E923F9318A1A742blackpurplelinear-gradient(90deg, #000000 50%, #9400D4 50%)4XL4XL58-6028-3032-3460-6260-6258-6064-6860-6258-60wlingerie4XLintlsize41.6250STOCK01000-10300264294810814024144122202-10-10-10041.625all
vatrate
number20
warehouse
number1