Mi cesta

❌
Total de artículos
Ver cesta
Menú
Ver tallas
Chacha Open Panties: encaje sensual y placer travieso
Doble clic para ampliar
SKU: SBGA3525
Chacha Open Panties: encaje sensual y placer travieso
Promo
Stock:

Descubre estas braguitas abiertas supersexys de encaje integral que revelan tu lado más travieso.

Su entrepierna abierta y su sensual encaje crean un efecto irresistible para momentos de puro placer.

Puntos destacados

  • Entrepierna abierta para un acceso directo y travieso
  • Encaje integral con sensuales motivos florales
  • Muy cómodo de llevar gracias a su ajuste perfecto
  • 4 sexys colores: negro, rosa, blanco y malva
  • Lazo decorativo para atraer todas las miradas
  • Corte envolvente para realzar tus generosas curvas
Talla:

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

Color:
Cantidad:
19.95 € 13.95 €
Envío rápido
para los impacientes...
Ayuda y consejos
por chat, facebook o correo electrónico
Devoluciones gratuitas
en un plazo de 15 días *

Bragas grandes de encaje con entrepierna abierta

Descripción del producto

Estas braguitas abiertas son el epítome de la seducción traviesa, con encaje integral que revela sutilmente tu piel. Laentrepierna abierta transforma cada momento íntimo en una experiencia de puro placer, ofreciendo un acceso directo que sube la temperatura.

Su encaje floral abraza perfectamente tus generosas curvas, creando un efecto visual supersexy que no deja indiferente a nadie. El lacito decorativo en la cintura añade ese toque travieso que marca la diferencia. Disponible en cuatro colores ultrasensuales -negro misterioso, rosa provocativo, blanco inocente pero travieso y malva atrevido-, cada versión revela una faceta diferente de tu sensualidad.

Estas braguitas son muy cómodas de llevar, pero están perfectamente diseñadas para tus momentos más íntimos. El corte de cobertura total realza tus curvas sin perder ese toque terriblemente sexy que hace que esta traviesa creación sea tan encantadora.

Detalles técnicos

  • Material: Encaje floral (92% poliamida, 8% elastán)
  • Colores: negro, rosa, blanco, malva
  • Tallas: de la 42 a la 56
  • Estilo : Braguita con entrepierna abierta
  • Detalles: Pequeño lazo decorativo, encaje integral
  • Cuidados: Se recomienda un lavado a mano delicado

Tallas disponibles

Disponible de 4XL+ a 4XL

Colores disponibles

Negro , Rosa , Lila y Blanco

Guía de tallas

Comprueba cuál es tu talla

Internacional
  • Caderas
4XL+
  • 127-132
L
  • 102-107
XL
  • 107-112
2XL
  • 112-117
3XL
  • 117-123
4XL
  • 123-127

Consejos de uso

Estas braguitas abiertas están diseñadas para tus momentos más traviesos y sensuales. Su entrepierna abierta ofrece un acceso directo que convierte cada momento íntimo en una experiencia de puro placer. Llévalas con confianza para revelar tu lado más sexy y atrevido.

Su corte se ajusta cómodamente, sin renunciar a esa tremenda excitación que sube la temperatura con cada mirada.

Consejos de estilo

Estas braguitas abiertas de encaje son perfectas para crear un look muy sexy. Para potenciar su efecto seductor, combínalas con piezas que revelen su presencia sutilmente. L

l color negro añade un misterio inquietante, el rosa revela tu lado provocativo, el blanco juega con la inocencia traviesa, mientras que el malva afirma tu audacia.

Completa tu look con nuestros bodys abiertos para una seducción total, o descubre nuestros picardías para un acercamiento más gradual al placer.

To Top
Ver cesta
Artículos
Total de artículos
Struct
Entries: 108
actions
Array
available
number17
brand
stringparishollywood
brandcode
stringpuun
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
stringParis Hollywood
breasts
stringna
careinstructions
string
categories
stringdivasboudoir.lingerie.briefs.openpanty
category
stringbriefs
categorygender
stringf
categorymediadatas
Struct
adult
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string287
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/lingerie/sexylingerie/openpanty.jpg
type
stringimg
width
string623
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: 1.01 ms
Record Count: 4
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_colors.color as recorduid, product_colors.type, product_colors.code, product_colors.color, product_colors.range, product_colors.hexvalue,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock
from product_colors
left outer join product_variations on product_colors.color = product_variations.color and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
where FIND_IN_SET(product_colors.color,'black,pink,purple,white') > 0
and product_variations.productuid = 'A4D0F8CE-5259-477B-926D2759D3E5E595'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1blackcolorblakblackblack#000000-11
2pinkcolorpinkpinkpink#FE70BD-15
3purplecolorpurppurplepurple#9400D4-15
4whitecolorwhitwhitewhite#FFFFFF-16
colorrange
stringpink
colors
stringblack,pink,purple,white
colortype
stringcolor
comments
string
compositions
Struct
Entries: 13
coton
string
elastane
string
free
string
leather
string
lycra
string
metal
string
nylon
string
polyamide
string
polyester
string
polyurethane
string
silk
string
spandex
string
viscose
string
datecreated
Date Time (Europe/Paris)
{ts '2024-09-06 12:34:39'}
defect
number0
dimensions
Struct
Entries: 14
acrylicbones
string
backsideheight
string
diameter
string
flatsteelbones
string
frontsideheight
string
fullheight
string
length
string
modestysize
string
panels
string
sides
string
spiralsteelbones
string
totallength
string
unit
stringcm
wiresize
string
display
stringall
displayfrom
string
displayto
string
grossweight
string
hasbrandinfos
booleanfalse
hascareinstructions
booleanfalse
hascolorinfos
booleantrue
hascompositions
booleanfalse
hasdescription
booleantrue
hasdimensions
booleanfalse
hasmaterials
booleanfalse
hasotherspecifications
booleanfalse
haspromo
number1
hasshortdescription
booleantrue
hassizeinfos
booleantrue
hasspecifications
booleantrue
hasstockinfos
booleanfalse
hasstylingtips
booleantrue
hasusageinstructions
booleantrue
hasvariations
booleantrue
import
string
inpromo
number20
instockvariations
number9
isactive
number1
iscustommade
number0
isdivasize
number0
isfirstprice
number0
isfixedprice
number0
ishot
number0
isnew
number0
isonline
number0
isoutletprice
number0
itemprice
number16.625
itempromo
number11.625
key
string5178
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-09-29 12:22:33'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.634 ms
Record Count: 0
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select cart_actions.*
from cart_actions
where cart_actions.branding IN ('all','divasboudoir')
and cart_actions.language IN ('all','es')
and (cart_actions.quotas = -1 or (cart_actions.usedCount < cart_actions.quotas))
and cart_actions.isactive = 1
and (date(cart_actions.activeFrom) <= '2025-11-24' OR cart_actions.activeFrom is null)
and (date(cart_actions.activeTo) >= '2025-11-24' OR cart_actions.activeTo is null)
and (
FIND_IN_SET('a4d0f8ce-5259-477b-926d2759d3e5e595',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.29 ms
Record Count: 0
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select products.productuid as productuid, products.reference, 'default' as type, products.key, products.language, products.name,
product_links.linkuid,
products.colors, products.vatrate, products.metadatas, products.dimensions,
products.mediadatas, products.tags, products.themes, products.isdivasize,
count(distinct product_variations.variationuid) as totalvariations,
group_concat(distinct product_variations.variationuid) as variationlist,
count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END) as inpromo,
if(count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END)>0,1,0) as haspromo,
(select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0) END)) as itempromo,
IFNULL(min(product_variations.itemprice),0) as itemprice,
(select IF (products.isfixedprice = 0 and sum(product_variations.itempromo) > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null), IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0), IFNULL(min(NULLIF(product_variations.itemprice, 0)), 0) )) as unitprice,
count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.itempromo ELSE product_variations.itemprice END) as prices,
(select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN min(NULLIF(product_variations.promountil, 0)) END)) as promountil,
products.isfixedprice, products.ishot, products.isnew, if(products.orderidx > 0, products.orderidx, 999999999) as orderidx,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
count(distinct CASE WHEN ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) > 0 OR ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) <= 0 AND product_variations.supplier = 0)) THEN product_variations.variationuid END) as instockvariations,
products.brand, brands.name as brandname, IFNULL(brands.ispublic, 0) as showbrand, brands.display,
product_categories.sizetype,GROUP_CONCAT(DISTINCT product_sizes.suppliersize) as intlsize,products.sizes,product_sizes.sizerange,product_categories.mediadatas as categorymediadatas, product_categories.sizerange as categorysizerange,
product_categorymap.section, product_categorymap.category, product_categorymap.key as subcategory
from products
left outer join product_categorymap on products.productuid = product_categorymap.productuid
left outer join product_categories on (product_categories.branding = product_categorymap.branding and product_categories.section = product_categorymap.section and product_categories.category = product_categorymap.category and product_categories.key = product_categorymap.key)
left outer join product_sizes on product_sizes.id_size IN (products.sizes)
left outer join brands on products.brand = brands.brand
left outer join product_variations on product_variations.productuid = products.productuid and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
left outer join product_links on product_links.reference = products.reference
where products.isactive = 1 and products.isdeleted = 0
and brands.isactive = 1 and brands.isdeleted = 0
and product_categories.isactive = 1 and product_categories.isdeleted = 0
and product_variations.isactive = 1
and FIND_IN_SET('divasboudoir',products.branding)
and product_categories.branding IN ('all','divasboudoir')
and product_categorymap.branding IN ('all','divasboudoir')
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and products.language in ('all','es')
and product_categories.language in ('all','es')
and (products.displayFrom <= DATE(NOW()) or products.displayFrom is null)
and (products.displayTo >= DATE(NOW()) or products.displayTo IS null)
and product_links.linkuid = '' and product_links.linkuid is not null and product_links.linkuid <> ''
and products.reference <> 'SBGA3525'
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
string1628
isprivate
string0
rating
stringall
src
string/photobank/products/puun/sbga3525/culotte_chacha_grande_taille_mauve_arriere.jpg
type
stringimg
width
string1126
back
Struct
height
string860
isprivate
string0
rating
stringall
src
string/photobank/products/puun/sbga3525/20190809184651435143.jpg
type
stringimg
width
string595
default
Struct
height
string1123
isprivate
string0
rating
stringall
src
string/photobank/products/puun/sbga3525/culotte_grande_taille_chacha_mauve.jpg
type
stringimg
width
string777
variations
Struct
colors
Struct
black
Struct
height
string860
isprivate
string0
rating
stringall
src
string/photobank/products/puun/sbga3525/20190809184425352535.jpg
type
stringimg
width
string595
pink
Struct
height
string795
isprivate
string0
rating
stringall
src
string/photobank/products/puun/sbga3525/st_9294x_pnk_4_ps01082019-edit_1.jpg
type
stringimg
width
string550
purple
Struct
height
string1123
isprivate
string0
rating
stringall
src
string/photobank/products/puun/sbga3525/culotte_grande_taille_chacha_mauve.jpg
type
stringimg
width
string777
white
Struct
height
string1652
isprivate
string0
rating
stringall
src
string/photobank/products/puun/sbga3525/culotte_chacha_grande_taille_blanche.jpg
type
stringimg
width
string1143
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-malvenfarben
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-mwv
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-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-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-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-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-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-lilas
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
divasboudoir
Struct
de
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>Dieser offene Slip verkörpert die <strong>frechste</strong> Verführung mit seiner integralen Spitze, die Ihre Haut subtil enthüllt. Der<strong>offene Schritt</strong> verwandelt jeden intimen Moment in ein Erlebnis purer Lust und bietet einen direkten Zugang, der die Temperatur ansteigen lässt.</p> <p>Die <strong>Spitze mit Blumenmuster</strong> schmiegt sich perfekt an Ihre üppigen Kurven und sorgt für einen <strong>hypersexy</strong> visuellen Effekt, der niemanden gleichgültig lässt. Die <strong>kleine Zierschleife</strong> an der Taille sorgt für den verruchten Touch, der den Unterschied ausmacht. Erhältlich in vier <strong>ultra-sinnlichen</strong> Farben - geheimnisvolles Schwarz, provokantes Pink, unschuldiges, aber freches Weiß und kühnes Lila - jede Version enthüllt eine andere Facette Ihrer Sinnlichkeit.</p> <p>Dieser Slip ist <strong>sehr angenehm zu tragen</strong>, während er gleichzeitig perfekt für Ihre intimsten Momente entworfen wurde. Der bedeckende Schnitt hebt Ihre Formen hervor und behält gleichzeitig diese <strong>schrecklich sexy</strong> Seite bei, die den Reiz dieser frechen Kreation ausmacht.</p>
guid
stringhttps://dev.divasboudoir.com/de/slip-in-grosser-grosse-offen-fuzzy-mauve/sbga3525.htm
highlights
string<ul> <li><strong>Offener Schritt</strong> für einen direkten, verruchten Zugang</li> <li><strong>Integrale Spitze</strong> mit sinnlichen Blumenmotiven</li> <li><strong>Sehr angenehm zu tragen</strong> dank der perfekten Passform</li> <li><strong>4 sexy Farben</strong>: Schwarz, Pink, Weiß und Mauve</li> <li><strong>Kleine Zierschleife</strong>, die die Blicke auf sich zieht</li> <li><strong>Bedeckender Schnitt</strong>, der Ihre üppigen Kurven hervorhebt</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringOffenes Höschen in großen Größen aus integraler Spitze. Offener Schritt, 4 sexy Farben. Sehr angenehm zu tragen. Schnelle Lieferung. Diva's Boudoir.
keywords
string
title
stringOffenes Höschen mit Spitze in großer Größe | Diva's Boudoir
seotitle
stringOffener Slip große Größen Spitze mit offenem Schritt
seouri
stringslip-in-grosser-grosse-offen-fuzzy-mauve
specifications
string<ul> <li><strong>Material:</strong> Blumenspitze (92% Polyamid, 8% Elasthan)</li> <li><strong>Farben:</strong> Schwarz, Pink, Weiß, Malve</li> <li><strong>Größen:</strong> 42 bis 56</li> <li><strong>Stil:</strong> Im Schritt offenes Höschen</li> <li><strong>Details:</strong> Kleine Zierschleife, durchgehende Spitze</li> <li><strong>Pflege:</strong> Schonende Handwäsche empfohlen</li> </ul>
stylingtips
string<p>Dieser offene Slip aus Spitze ist für sich allein genommen schon ein <strong>sexy</strong> Look. Um den verführerischen Effekt zu verstärken, kombinieren Sie sie mit Teilen, die ihre Präsenz subtil offenbaren. L</p> <p>ie Farbe <strong>Schwarz</strong> verleiht Ihnen ein beunruhigendes Geheimnis, <strong>Rosa</strong> zeigt Ihre provokante Seite, <strong>Weiß</strong> wirkt unschuldig und verrucht, während <strong>Mauve</strong> Ihre Kühnheit unterstreicht.</p> <p>Vervollständigen Sie Ihren Look mit unseren <a href="https://www.divasboudoir.com/de/offener-body-in-grossen-grossen/">offenen Bodies</a>, um Ihre Verführungskraft zu steigern, oder entdecken Sie unsere <a href="https://www.divasboudoir.com/de/neglige-in-grosse-grossen/">Neglig&eacute;s</a> für eine schrittweise Annäherung an die Lust.</p>
summary
string<p>Entdecken Sie diesen <strong>hypersexy</strong> offenen Slip aus integraler Spitze, der Ihre <strong>frechste</strong> Seite offenbart.</p> <p>Der <strong>offene Schritt</strong> und die <strong>sinnliche Spitze</strong> sorgen für einen unwiderstehlichen Effekt für Momente der puren Lust.</p>
title
stringChacha Offener Slip: Sinnliche Spitze und freches Vergnügen
usageinstructions
string<p>Dieser offene Slip wurde für Ihre <strong>frechsten</strong> und sinnlichsten Momente entworfen. Sein <strong>offener Schritt</strong> bietet einen direkten Zugang, der jeden intimen Moment in ein Erlebnis purer Lust verwandelt. Tragen Sie ihn selbstbewusst, um Ihre <strong>sexieste</strong> und gewagteste Seite zu enthüllen.</p> <p>Seine <strong>sehr angenehme</strong> Passform begleitet Sie bequem und bewahrt gleichzeitig diese schrecklich aufregende Seite, die bei jedem Blick die Temperatur steigen lässt.</p>
el
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>Αυτά τα ανοιχτά εσώρουχα είναι η επιτομή της <strong>άτακτης</strong> αποπλάνησης, με πλήρη δαντέλα που αποκαλύπτει διακριτικά το δέρμα σας. Ο<strong>ανοιχτός καβάλος</strong> μετατρέπει κάθε προσωπική στιγμή σε μια εμπειρία καθαρής απόλαυσης, προσφέροντας άμεση πρόσβαση που ανεβάζει τη θερμοκρασία.</p> <p>Η <strong>φλοράλ δαντέλα</strong> του αγκαλιάζει τέλεια τις γενναιόδωρες καμπύλες σας, δημιουργώντας ένα <strong>σούπερ σέξι</strong> οπτικό αποτέλεσμα που δεν αφήνει κανέναν αδιάφορο. Ο <strong>μικρός διακοσμητικός φιόγκος</strong> στη μέση προσθέτει αυτή την άτακτη πινελιά που κάνει τη διαφορά. Διατίθεται σε τέσσερα <strong>εξαιρετικά αισθησιακά</strong> χρώματα - μυστηριώδες μαύρο, προκλητικό ροζ, αθώο αλλά άτακτο λευκό και τολμηρό μοβ - κάθε έκδοση αποκαλύπτει μια διαφορετική πτυχή του αισθησιασμού σας.</p> <p>Αυτά τα εσώρουχα είναι <strong>πολύ άνετα στη χρήση</strong>, αλλά και τέλεια σχεδιασμένα για τις πιο προσωπικές σας στιγμές. Το πλήρως καλυπτικό κόψιμο ενισχύει τις καμπύλες σας, διατηρώντας παράλληλα αυτή την <strong>τρομερά σέξι</strong> άκρη που κάνει αυτή την άτακτη δημιουργία τόσο γοητευτική.</p>
guid
stringhttps://dev.divasboudoir.com/el/chnoydwto-mwv-megalo-anoichto-vraki/sbga3525.htm
highlights
string<ul> <li><strong>Ανοιχτό καβάλο</strong> για άμεση, άτακτη πρόσβαση</li> <li><strong>Πλήρης δαντέλα</strong> με αισθησιακά φλοράλ μοτίβα</li> <li><strong>Πολύ άνετο στη χρήση</strong> χάρη στην τέλεια εφαρμογή του</li> <li><strong>4 σέξι χρώματα</strong>: μαύρο, ροζ, λευκό και μοβ</li> <li><strong>Διακοσμητικός φιόγκος</strong> για να τραβάει τα βλέμματα</li> <li><strong>Καλυπτικό κόψιμο</strong> για να αναδεικνύει τις πλούσιες καμπύλες σας</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringΟλόσωμο δαντελένιο εσώρουχο. Ανοιχτό καβάλο, 4 σέξι χρώματα. Πολύ άνετα στη χρήση. Γρήγορη παράδοση. Diva's Boudoir.
keywords
string
title
stringΑνοιχτό εσώρουχο μεγάλο μέγεθος με δαντέλα | Diva's Boudoir
seotitle
stringΜεγάλο δαντελένιο εσώρουχο με ανοιχτό καβάλο
seouri
stringchnoydwto-mwv-megalo-anoichto-vraki
specifications
string<ul> <li><strong>Υλικό:</strong> Φλοράλ δαντέλα (92% πολυαμίδιο, 8% ελαστάν)</li> <li><strong>Χρώματα:</strong> Μαύρο, Ροζ, Λευκό, Μωβ</li> <li><strong>Μεγέθη:</strong> 42 έως 56</li> <li><strong>Στυλ :</strong> Εσώρουχο με ανοιχτό καβάλο</li> <li><strong>Λεπτομέρειες</strong>: Μικρός διακοσμητικός φιόγκος, πλήρης δαντέλα</li> <li><strong>Φροντίδα:</strong> Συνιστάται απαλό πλύσιμο στο χέρι</li> </ul>
stylingtips
string<p>Αυτά τα ανοιχτά δαντελένια εσώρουχα στέκονται μόνα τους για να δημιουργήσουν μια <strong>σούπερ σέξι</strong> εμφάνιση. Για να ενισχύσετε το σαγηνευτικό αποτέλεσμα, συνδυάστε τα με κομμάτια που αποκαλύπτουν διακριτικά την παρουσία τους. L</p> <p>ο <strong>μαύρο</strong> χρώμα προσθέτει ένα ανησυχητικό μυστήριο, <strong>το ροζ</strong> αποκαλύπτει την προκλητική σας πλευρά, <strong>το λευκό</strong> παίζει με την άτακτη αθωότητα, ενώ <strong>το μωβ</strong> επιβεβαιώνει την τόλμη σας.</p> <p>Ολοκληρώστε την εμφάνισή σας με τα <a href="https://www.divasboudoir.com/el/megalo-anoichto-kormaki/">ανοιχτά κορμάκια</a> μας για απόλυτη αποπλάνηση ή ανακαλύψτε τα <a href="https://www.divasboudoir.com/el/negklize-megaloy-megethoys/">νεγκλιζέ</a> μας για μια πιο σταδιακή προσέγγιση της απόλαυσης.</p>
summary
string<p>Ανακαλύψτε αυτά τα <strong>σούπερ σέξι</strong> ανοιχτά εσώρουχα με πλήρη δαντέλα που αποκαλύπτουν την <strong>πιο άτακτη</strong> πλευρά σας.</p> <p>Το <strong>ανοιχτό καβάλο</strong> και η <strong>αισθησιακή δαντέλα</strong> του δημιουργούν ένα ακαταμάχητο αποτέλεσμα για στιγμές καθαρής απόλαυσης.</p>
title
stringChacha Open Panties: Αισθησιακή δαντέλα και άτακτη ευχαρίστηση
usageinstructions
string<p>Αυτά τα ανοιχτά εσώρουχα είναι σχεδιασμένα για τις <strong>πιο άτακτες</strong>, αισθησιακές σας στιγμές. Ο <strong>ανοιχτός καβάλος</strong> του προσφέρει άμεση πρόσβαση που μετατρέπει κάθε προσωπική στιγμή σε μια εμπειρία καθαρής απόλαυσης. Φορέστε τα με αυτοπεποίθηση για να αποκαλύψετε την <strong>πιο σέξι</strong>, τολμηρή πλευρά σας.</p> <p>Είναι κομμένο <strong>για να</strong> εφαρμόζει άνετα, διατηρώντας παράλληλα αυτό το καταπληκτικό ερεθισμό που ανεβάζει τη θερμοκρασία με κάθε ματιά.</p>
en
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>These open panties embody the <strong>naughtiest</strong> seduction with full lace that subtly reveals your skin. The<strong>open crotch</strong> transforms every intimate moment into an experience of pure pleasure, offering direct access that raises the temperature.</p> <p>Its <strong>floral lace</strong> perfectly hugs your generous curves, creating a <strong>hyper-sexy</strong> visual effect that leaves no one indifferent. The <strong>little decorative bow</strong> on the waist adds that naughty touch that makes all the difference. Available in four <strong>ultra-sensual</strong> colors - mysterious black, provocative pink, innocent yet naughty white and bold mauve - each version reveals a different facet of your sensuality.</p> <p>These panties are <strong>extremely comfortable to wear</strong>, yet perfectly designed for your most intimate moments. The full-coverage cut enhances your curves while retaining that <strong>terribly sexy</strong> edge that makes this naughty creation so charming.</p>
guid
stringhttps://dev.divasboudoir.com/en/plus-size-open-knickers-fuzzy-mauve/sbga3525.htm
highlights
string<ul> <li><strong>Open crotch</strong> for direct, naughty access</li> <li><strong>Full lace</strong> with sensual floral motifs</li> <li><strong>Very comfortable to wear</strong> thanks to perfect fit</li> <li><strong>4 sexy colors</strong>: black, pink, white and mauve</li> <li>Eye-catching<strong>decorative bow</strong> </li> <li><strong>Covering cut</strong> to enhance your generous curves</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringPlus size open panties in full lace. Open crotch, 4 sexy colors. Very comfortable to wear. Fast delivery. Diva's Boudoir.
keywords
string
title
stringOpen panties plus size lace | Diva's Boudoir
seotitle
stringPlus size lace panties with open crotch
seouri
stringplus-size-open-knickers-fuzzy-mauve
specifications
string<ul> <li><strong>Material:</strong> Floral lace (92% polyamide, 8% elastane)</li> <li><strong>Colors:</strong> Black, Pink, White, Mauve</li> <li><strong>Sizes:</strong> 42 to 56</li> <li><strong>Style:</strong> Open crotch panty</li> <li><strong>Details :</strong> Small decorative bow, full lace</li> <li><strong>Care:</strong> Delicate hand wash recommended</li> </ul>
stylingtips
string<p>These open lace panties stand on their own to create an <strong>ultra-sexy</strong> look. To amplify the seductive effect, pair them with pieces that subtly reveal their presence. L</p> <p><strong>black</strong> brings an unsettling mystery, <strong>pink</strong> reveals your provocative side, <strong>white</strong> plays on naughty innocence, while <strong>mauve</strong> asserts your audacity.</p> <p>Complete your look with our <a href="https://www.divasboudoir.com/en/open-bodysuit-plus-size/">open bodysuits</a> for total seduction, or discover our <a href="https://www.divasboudoir.com/en/plus-size-robes/">negligees</a> for a more gradual approach to pleasure.</p>
summary
string<p>Discover these <strong>hyper-sexy</strong> open panties in full lace that reveal your <strong>naughtiest</strong> side.</p> <p>Its <strong>open crotch</strong> and <strong>sensual lace</strong> create an irresistible effect for moments of pure pleasure.</p>
title
stringChacha Open Panties: Sensual Lace and Naughty Pleasure
usageinstructions
string<p>These open panties are designed for your <strong>naughtiest</strong>, most sensual moments. Its <strong>open crotch</strong> offers direct access that transforms every intimate moment into an experience of pure pleasure. Wear them with confidence to reveal your <strong>sexiest</strong>, boldest side.</p> <p>It's <strong>comfortably</strong> cut to keep you company, while retaining that terribly arousing side that raises the temperature with every glance.</p>
es
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>Estas braguitas abiertas son el epítome de la seducción <strong>traviesa</strong>, con encaje integral que revela sutilmente tu piel. La<strong>entrepierna abierta</strong> transforma cada momento íntimo en una experiencia de puro placer, ofreciendo un acceso directo que sube la temperatura.</p> <p>Su <strong>encaje floral</strong> abraza perfectamente tus generosas curvas, creando un efecto visual <strong>supersexy</strong> que no deja indiferente a nadie. El <strong>lacito decorativo</strong> en la cintura añade ese toque travieso que marca la diferencia. Disponible en cuatro colores <strong>ultrasensuales</strong> -negro misterioso, rosa provocativo, blanco inocente pero travieso y malva atrevido-, cada versión revela una faceta diferente de tu sensualidad.</p> <p>Estas braguitas son <strong>muy cómodas de llevar</strong>, pero están perfectamente diseñadas para tus momentos más íntimos. El corte de cobertura total realza tus curvas sin perder ese toque <strong>terriblemente sexy</strong> que hace que esta traviesa creación sea tan encantadora.</p>
guid
stringhttps://dev.divasboudoir.com/es/braguita-abierta-talla-grande-fuzzy-mauve/sbga3525.htm
highlights
string<ul> <li><strong>Entrepierna abierta</strong> para un acceso directo y travieso</li> <li><strong>Encaje integral</strong> con sensuales motivos florales</li> <li><strong>Muy cómodo de llevar</strong> gracias a su ajuste perfecto</li> <li><strong>4 sexys colores</strong>: negro, rosa, blanco y malva</li> <li><strong>Lazo decorativo</strong> para atraer todas las miradas</li> <li><strong>Corte envolvente</strong> para realzar tus generosas curvas</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringBraguitas de encaje de talla grande. Entrepierna abierta, 4 sexys colores. Muy cómodas de llevar. Entrega rápida. Diva's Boudoir.
keywords
string
title
stringBragas abiertas talla grande encaje | Diva's Boudoir
seotitle
stringBragas grandes de encaje con entrepierna abierta
seouri
stringbraguita-abierta-talla-grande-fuzzy-mauve
specifications
string<ul> <li><strong>Material:</strong> Encaje floral (92% poliamida, 8% elastán)</li> <li><strong>Colores:</strong> negro, rosa, blanco, malva</li> <li><strong>Tallas</strong>: de la 42 a la 56</li> <li><strong>Estilo :</strong> Braguita con entrepierna abierta</li> <li><strong>Detalles:</strong> Pequeño lazo decorativo, encaje integral</li> <li><strong>Cuidados:</strong> Se recomienda un lavado a mano delicado</li> </ul>
stylingtips
string<p>Estas braguitas abiertas de encaje son perfectas para crear un look <strong>muy sexy</strong>. Para potenciar su efecto seductor, combínalas con piezas que revelen su presencia sutilmente. L</p> <p>l color <strong>negro</strong> añade un misterio inquietante, <strong>el rosa</strong> revela tu lado provocativo, <strong>el blanco</strong> juega con la inocencia traviesa, mientras que <strong>el malva</strong> afirma tu audacia.</p> <p>Completa tu look con nuestros <a href="https://www.divasboudoir.com/es/body-abierto-talla-grande/">bodys abiertos</a> para una seducción total, o descubre nuestros <a href="https://www.divasboudoir.com/es/picardias-talla-grande/">picardías</a> para un acercamiento más gradual al placer.</p>
summary
string<p>Descubre estas braguitas abiertas <strong>supersexys</strong> de encaje integral que revelan tu lado <strong>más travieso</strong>.</p> <p>Su <strong>entrepierna abierta</strong> y su <strong>sensual encaje</strong> crean un efecto irresistible para momentos de puro placer.</p>
title
stringChacha Open Panties: encaje sensual y placer travieso
usageinstructions
string<p>Estas braguitas abiertas están diseñadas para tus momentos <strong>más traviesos</strong> y sensuales. Su <strong>entrepierna</strong> abierta ofrece un acceso directo que convierte cada momento íntimo en una experiencia de puro placer. Llévalas con confianza para revelar tu lado <strong>más sexy</strong> y atrevido.</p> <p>Su corte <strong>se</strong> ajusta cómodamente, sin renunciar a esa tremenda excitación que sube la temperatura con cada mirada.</p>
fr
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>Cette culotte ouverte incarne la s&eacute;duction la plus <strong>coquine</strong> avec sa dentelle int&eacute;grale qui r&eacute;v&egrave;le subtilement votre peau. L'<strong>entrejambe ouvert</strong> transforme chaque moment intime en exp&eacute;rience de pur plaisir, offrant un acc&egrave;s direct qui fait monter la temp&eacute;rature.</p> <p>Sa&nbsp;<strong>dentelle aux motifs floraux</strong> &eacute;pouse parfaitement vos courbes g&eacute;n&eacute;reuses, cr&eacute;ant un effet visuel <strong>hyper sexy</strong> qui ne laisse personne indiff&eacute;rent. Le <strong>petit n&oelig;ud d&eacute;coratif</strong> sur la taille ajoute cette touche coquine qui fait toute la diff&eacute;rence. Disponible en quatre coloris <strong>ultra sensuels</strong> - noir myst&eacute;rieux, rose provocant, blanc innocent mais coquin, et mauve audacieux - chaque version r&eacute;v&egrave;le une facette diff&eacute;rente de votre sensualit&eacute;.</p> <p>Cette culotte est&nbsp;<strong>tr&egrave;s agr&eacute;able &agrave; porter</strong> tout en &eacute;tant parfaitement con&ccedil;ue pour vos moments les plus intimes. La coupe couvrante met en valeur vos formes tout en conservant ce c&ocirc;t&eacute; <strong>terriblement sexy</strong> qui fait le charme de cette cr&eacute;ation coquine.</p>
guid
stringhttps://dev.divasboudoir.com/fr/culotte-grande-taille-ouverte-fuzzy-mauve/sbga3525.htm
highlights
string<ul> <li><strong>Entrejambe ouvert</strong> pour un acc&egrave;s direct et coquin</li> <li><strong>Dentelle int&eacute;grale</strong> avec motifs floraux sensuels</li> <li><strong>Tr&egrave;s agr&eacute;able &agrave; porter</strong> gr&acirc;ce &agrave; sa coupe parfaite</li> <li><strong>4 coloris sexy</strong> : noir, rose, blanc et mauve</li> <li><strong>Petit n&oelig;ud d&eacute;coratif</strong> qui attire le regard</li> <li><strong>Coupe couvrante</strong> qui sublime vos courbes g&eacute;n&eacute;reuses</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringCulotte ouverte grande taille en dentelle intégrale. Entrejambe ouvert, 4 coloris sexy. Très agréable à porter. Livraison rapide. Diva's Boudoir.
keywords
string
title
stringCulotte ouverte grande taille dentelle | Diva's Boudoir
seotitle
stringCulotte ouverte grande taille dentelle avec entrejambe ouvert
seouri
stringculotte-grande-taille-ouverte-fuzzy-mauve
specifications
string<ul> <li><strong>Mati&egrave;re :</strong> Dentelle florale (92% polyamide, 8% &eacute;lasthanne)</li> <li><strong>Couleurs :</strong> Noir, Rose, Blanc, Mauve</li> <li><strong>Tailles :</strong> 42 &agrave; 56</li> <li><strong>Style :</strong> Culotte ouverte &agrave; l'entrejambe</li> <li><strong>D&eacute;tails :</strong> Petit n&oelig;ud d&eacute;coratif, dentelle int&eacute;grale</li> <li><strong>Entretien :</strong> Lavage d&eacute;licat &agrave; la main recommand&eacute;</li> </ul>
stylingtips
string<p>Cette culotte ouverte en dentelle se suffit &agrave; elle-m&ecirc;me pour cr&eacute;er un look <strong>hyper sexy</strong>. Pour amplifier l'effet de s&eacute;duction, associez-la &agrave; des pi&egrave;ces qui r&eacute;v&egrave;lent subtilement sa pr&eacute;sence. L</p> <p>e coloris&nbsp;<strong>noir</strong> apporte un myst&egrave;re troublant, le <strong>rose</strong> r&eacute;v&egrave;le votre c&ocirc;t&eacute; provocant, le <strong>blanc</strong> joue sur l'innocence coquine, tandis que le <strong>mauve</strong> affirme votre audace.</p> <p>Compl&eacute;tez votre look avec nos <a href="https://www.divasboudoir.com/fr/body-ouvert-grande-taille/">bodys ouverts</a> pour une s&eacute;duction totale, ou d&eacute;couvrez nos <a href="https://www.divasboudoir.com/fr/deshabille-grande-taille/">d&eacute;shabill&eacute;s</a>&nbsp;pour une approche plus progressive du plaisir.</p>
summary
string<p>D&eacute;couvrez cette culotte ouverte <strong>hyper sexy</strong> en dentelle int&eacute;grale qui r&eacute;v&egrave;le votre c&ocirc;t&eacute; le plus <strong>coquin</strong>.</p> <p>Son&nbsp;<strong>entrejambe ouvert</strong> et sa <strong>dentelle sensuelle</strong> cr&eacute;ent un effet irr&eacute;sistible pour des moments de pur plaisir.</p>
title
stringCulotte Ouverte Chacha: Dentelle Sensuelle et Plaisir Coquin
usageinstructions
string<p>Cette culotte ouverte est con&ccedil;ue pour vos moments les plus <strong>coquins</strong> et sensuels. Son <strong>entrejambe ouvert</strong> offre un acc&egrave;s direct qui transforme chaque instant intime en exp&eacute;rience de pur plaisir. Portez-la avec assurance pour r&eacute;v&eacute;ler votre c&ocirc;t&eacute; le plus <strong>sexy</strong> et audacieux.</p> <p>Sa coupe&nbsp;<strong>tr&egrave;s agr&eacute;able</strong> vous accompagne confortablement tout en conservant ce c&ocirc;t&eacute; terriblement excitant qui fait monter la temp&eacute;rature &agrave; chaque regard.</p>
it
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>Queste mutandine aperte sono l'epitome della seduzione <strong>maliziosa</strong>, con un pizzo pieno che rivela sottilmente la vostra pelle. Il<strong>cavallo aperto</strong> trasforma ogni momento intimo in un'esperienza di puro piacere, offrendo un accesso diretto che alza la temperatura.</p> <p>Il <strong>pizzo floreale</strong> abbraccia perfettamente le vostre curve generose, creando un effetto visivo <strong>supersexy</strong> che non lascia indifferenti. Il <strong>piccolo fiocco decorativo</strong> in vita aggiunge quel tocco malizioso che fa la differenza. Disponibile in quattro colori <strong>ultra-sensuali</strong> - nero misterioso, rosa provocante, bianco innocente ma malizioso e malva audace - ogni versione rivela una diversa sfaccettatura della vostra sensualità.</p> <p>Queste mutandine sono <strong>molto comode da indossare</strong>, ma perfettamente studiate per i vostri momenti più intimi. Il taglio a copertura totale esalta le vostre curve, pur conservando quel tocco <strong>terribilmente sexy</strong> che rende questa creazione maliziosa così affascinante.</p>
guid
stringhttps://dev.divasboudoir.com/it/mutandine-aperte-di-grande-taglia-color-malva/sbga3525.htm
highlights
string<ul> <li><strong>Cavallo aperto</strong> per un accesso diretto e malizioso</li> <li><strong>Pieno pizzo</strong> con sensuali motivi floreali</li> <li><strong>Molto comodo da indossare</strong> grazie alla sua perfetta vestibilità</li> <li><strong>4 colori sexy</strong>: nero, rosa, bianco e malva</li> <li><strong>Fiocco decorativo</strong> per attirare l'attenzione</li> <li><strong>Taglio coprente</strong> per esaltare le vostre curve generose</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringMutandine in pizzo a taglia grande. Cavallo aperto, 4 colori sexy. Molto comode da indossare. Consegna rapida. Diva's Boudoir.
keywords
string
title
stringMutandine aperte taglia grande in pizzo | Diva's Boudoir
seotitle
stringMutandine di pizzo di taglia grande con cavallo aperto
seouri
stringmutandine-aperte-di-grande-taglia-color-malva
specifications
string<ul> <li><strong>Materiale:</strong> pizzo floreale (92% poliammide, 8% elastan)</li> <li><strong>Colori:</strong> Nero, Rosa, Bianco, Malva</li> <li><strong>Taglie:</strong> dalla 42 alla 56</li> <li><strong>Stile :</strong> Mutandina a cavallo aperto</li> <li><strong>Dettagli:</strong> Piccolo fiocco decorativo, pizzo integrale</li> <li><strong>Cura:</strong> Si consiglia un lavaggio delicato a mano</li> </ul>
stylingtips
string<p>Queste mutandine aperte in pizzo sono adatte a creare un look <strong>super sexy</strong>. Per aumentare l'effetto seduttivo, abbinatele a capi che ne rivelino sottilmente la presenza. L</p> <p>l colore <strong>nero</strong> aggiunge un mistero inquietante, il <strong>rosa</strong> rivela il vostro lato provocante, il <strong>bianco</strong> gioca sull'innocenza maliziosa, mentre il <strong>malva</strong> afferma la vostra audacia.</p> <p>Completate il vostro look con i nostri <a href="https://www.divasboudoir.com/it/body-aperto-di-grande-taglia/">body aperti</a> per una seduzione totale, oppure scoprite le nostre <a href="https://www.divasboudoir.com/it/vestaglia-taglia-grande/">vestaglie</a> per un approccio più graduale al piacere.</p>
summary
string<p>Scoprite queste mutandine aperte <strong>supersexy</strong> in pizzo integrale che rivelano il vostro lato <strong>più cattivo</strong>.</p> <p>Il <strong>cavallo aperto</strong> e il <strong>pizzo sensuale</strong> creano un effetto irresistibile per momenti di puro piacere.</p>
title
stringMutandine aperte Chacha: pizzo sensuale e piacere birichino
usageinstructions
string<p>Queste mutandine aperte sono state progettate per i vostri momenti <strong>più cattivi</strong> e sensuali. Il <strong>cavallo aperto</strong> offre un accesso diretto che trasforma ogni momento di intimità in un'esperienza di puro piacere. Indossatele con fiducia per rivelare il vostro lato <strong>più sexy</strong> e audace.</p> <p>Il taglio è comodo <strong>,</strong> ma conserva quella straordinaria eccitazione che fa salire la temperatura a ogni sguardo.</p>
nl
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>Dit open slipje is het toppunt van <strong>ondeugende</strong> verleiding, met volledig kant dat je huid subtiel onthult. Het<strong>open kruis</strong> verandert elk intiem moment in een ervaring van puur genot en biedt directe toegang die de temperatuur doet stijgen.</p> <p>Het <strong>gebloemde kant</strong> omhelst perfect je royale rondingen en cre&euml;ert een <strong>supersexy</strong> visueel effect dat niemand onverschillig laat. Het <strong>decoratieve strikje</strong> in de taille geeft het ondeugende accent dat het verschil maakt. Verkrijgbaar in vier <strong>ultra-sensuele</strong> kleuren - mysterieus zwart, uitdagend roze, onschuldig maar ondeugend wit en gedurfd paars - elke versie onthult een ander facet van je sensualiteit.</p> <p>Deze slips zijn <strong>zeer comfortabel om te dragen</strong>, maar toch perfect ontworpen voor je meest intieme momenten. De volledig bedekkende snit accentueert je rondingen met behoud van dat <strong>vreselijk sexy</strong> randje dat deze ondeugende creatie zo charmant maakt.</p>
guid
stringhttps://dev.divasboudoir.com/nl/wollige-mauve-grote-maat-open-onderbroek/sbga3525.htm
highlights
string<ul> <li><strong>Open kruis</strong> voor directe, ondeugende toegang</li> <li><strong>Volledig kant</strong> met sensuele bloemmotieven</li> <li><strong>Zeer comfortabel om te dragen</strong> dankzij de perfecte pasvorm</li> <li><strong>4 sexy kleuren</strong>: zwart, roze, wit en paars</li> <li><strong>Decoratieve strik</strong> om op te vallen</li> <li><strong>Bedekkende snit</strong> om je royale rondingen te benadrukken</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringGrote maten kanten slips. Open kruis, 4 sexy kleuren. Zeer comfortabel om te dragen. Snelle levering. Diva's Boudoir.
keywords
string
title
stringOpen slipje grote maat kant | Diva's Boudoir
seotitle
stringGrote kanten slip met open kruis
seouri
stringwollige-mauve-grote-maat-open-onderbroek
specifications
string<ul> <li><strong>Materiaal:</strong> Bloemenkant (92% polyamide, 8% elastaan)</li> <li><strong>Kleuren:</strong> Zwart, Roze, Wit, Mauve</li> <li><strong>Maten:</strong> 42 tot 56</li> <li><strong>Stijl :</strong> Panty met open kruis</li> <li><strong>Details :</strong> Klein decoratief strikje, volledig kant</li> <li><strong>Onderhoud:</strong> Fijne handwas aanbevolen</li> </ul>
stylingtips
string<p>Deze open kanten slip staat op zichzelf en cre&euml;ert een <strong>super sexy</strong> look. Om het verleidelijke effect te versterken, combineer je ze met stukken die hun aanwezigheid subtiel onthullen. L</p> <p>e kleur <strong>zwart</strong> voegt een verontrustend mysterie toe, <strong>roze</strong> onthult je provocerende kant, <strong>wit</strong> speelt met ondeugende onschuld, terwijl <strong>paars</strong> je brutaliteit benadrukt.</p> <p>Maak je look compleet met onze <a href="https://www.divasboudoir.com/nl/groote-open-romper/">open bodysuits</a> voor totale verleiding, of ontdek onze <a href="https://www.divasboudoir.com/nl/grote-maat-neglige/">neglig&eacute;s</a> voor een meer geleidelijke benadering van plezier.</p>
summary
string<p>Ontdek deze <strong>supersexy</strong> open slips van volledig kant die je <strong>stoutste</strong> kant laten zien.</p> <p>Het <strong>open kruis</strong> en <strong>sensuele kant</strong> cre&euml;ren een onweerstaanbaar effect voor momenten van puur plezier.</p>
title
stringChacha Open Slipjes: Sensueel Kant en Ondeugend Genot
usageinstructions
string<p>Dit open slipje is ontworpen voor je <strong>ondeugendste</strong>, meest sensuele momenten. Het <strong>open kruis</strong> biedt directe toegang waardoor elk intiem moment een ervaring van puur genot wordt. Draag ze met vertrouwen om je <strong>meest sexy</strong>, brutale kant te onthullen.</p> <p>Het <strong>zit</strong> comfortabel, maar behoudt toch die geweldige opwinding die bij elke blik de temperatuur doet stijgen.</p>
pt
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>Estas cuecas abertas s&atilde;o o ep&iacute;tome da sedu&ccedil;&atilde;o <strong>marota</strong>, com renda completa que revela subtilmente a sua pele. A<strong>virilha aberta</strong> transforma cada momento &iacute;ntimo numa experi&ecirc;ncia de puro prazer, oferecendo um acesso direto que faz subir a temperatura.</p> <p>A sua <strong>renda floral</strong> abra&ccedil;a perfeitamente as suas curvas generosas, criando um efeito visual <strong>super-sexy</strong> que n&atilde;o deixa ningu&eacute;m indiferente. O <strong>pequeno la&ccedil;o decorativo</strong> na cintura d&aacute; aquele toque maroto que faz toda a diferen&ccedil;a. Dispon&iacute;vel em quatro cores <strong>ultra-sensuais</strong> - preto misterioso, rosa provocante, branco inocente mas maroto e malva ousado - cada vers&atilde;o revela uma faceta diferente da sua sensualidade.</p> <p>Estas cuecas s&atilde;o <strong>muito confort&aacute;veis de usar</strong>, mas perfeitamente concebidas para os seus momentos mais &iacute;ntimos. O corte de cobertura total real&ccedil;a as suas curvas, mantendo aquele toque <strong>terrivelmente sexy</strong> que torna esta cria&ccedil;&atilde;o marota t&atilde;o encantadora.</p>
guid
stringhttps://dev.divasboudoir.com/pt/cuecas-largas-abertas-em-malva-felpuda/sbga3525.htm
highlights
string<ul> <li><strong>Entrepernas aberta</strong> para um acesso direto e atrevido</li> <li><strong>Renda completa</strong> com motivos florais sensuais</li> <li><strong>Muito confort&aacute;vel de usar</strong> gra&ccedil;as ao seu ajuste perfeito</li> <li><strong>4 cores sensuais</strong>: preto, cor-de-rosa, branco e malva</li> <li><strong>La&ccedil;o decorativo</strong> para chamar a aten&ccedil;&atilde;o</li> <li><strong>Corte coberto</strong> para real&ccedil;ar as suas curvas generosas</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringCuecas de renda a todo o comprimento. Entrepernas abertas, 4 cores sensuais. Muito confortável de usar. Entrega rápida. Diva's Boudoir.
keywords
string
title
stringCalcinhas abertas tamanho grande de renda | Diva's Boudoir
seotitle
stringCalcinhas grandes de renda com abertura na virilha
seouri
stringcuecas-largas-abertas-em-malva-felpuda
specifications
string<ul> <li><strong>Material:</strong> Renda floral (92% poliamida, 8% elastano)</li> <li><strong>Cores:</strong> Preto, Rosa, Branco, Malva</li> <li><strong>Tamanhos:</strong> 42 a 56</li> <li><strong>Estilo :</strong> Calcinha com abertura na virilha</li> <li><strong>Detalhes :</strong> Pequeno la&ccedil;o decorativo, renda completa</li> <li><strong>Cuidados:</strong> Recomenda-se uma lavagem delicada &agrave; m&atilde;o</li> </ul>
stylingtips
string<p>Estas cuecas de renda abertas criam um visual <strong>super sexy</strong>. Para aumentar o efeito sedutor, combine-as com pe&ccedil;as que revelem subtilmente a sua presen&ccedil;a. L</p> <p>cor <strong>preta</strong> acrescenta um mist&eacute;rio inquietante, <strong>o cor-de-rosa</strong> revela o seu lado provocador, <strong>o branco</strong> joga com a inoc&ecirc;ncia marota, enquanto <strong>o malva</strong> afirma a sua aud&aacute;cia.</p> <p>Complete o seu look com os nossos <a href="https://www.divasboudoir.com/pt/body-grande-aberto/">bodies abertos</a> para uma sedu&ccedil;&atilde;o total, ou descubra os nossos <a href="https://www.divasboudoir.com/pt/batotas-plus-size/">negligees</a> para uma abordagem mais gradual do prazer.</p>
summary
string<p>Descubra estas cuecas abertas <strong>super sensuais</strong> em renda que revelam o seu lado <strong>mais atrevido</strong>.</p> <p>A sua <strong>virilha aberta</strong> e a <strong>renda sensual</strong> criam um efeito irresist&iacute;vel para momentos de puro prazer.</p>
title
stringChacha Open Panties: Renda Sensual e Prazer Maroto
usageinstructions
string<p>Estas cuecas abertas foram concebidas para os seus momentos <strong>mais</strong> sensuais e atrevidos. A sua <strong>virilha aberta</strong> oferece um acesso direto que transforma cada momento &iacute;ntimo numa experi&ecirc;ncia de puro prazer. Use-as com confian&ccedil;a para revelar o seu lado <strong>mais</strong> sexy e ousado.</p> <p>O corte foi concebido <strong>para</strong> se ajustar confortavelmente, mantendo a excita&ccedil;&atilde;o fant&aacute;stica que aumenta a temperatura a cada olhar.</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-malvenfarben
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-mwv
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-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-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-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-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-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-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-malvenfarben
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-mwv
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-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-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-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-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-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-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-malvenfarben
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-mwv
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-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-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-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-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-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-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-malvenfarben
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-mwv
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-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-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-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-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-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-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-malvenfarben
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-mwv
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-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-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-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-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-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-lilas
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
name
string5178
netweight
string
nextshipment
stringtoday
ordered
number3
orderidx
number0
origin
string
originalsize
string
packaging
number0
productshipment
stringauto
productuid
stringA4D0F8CE-5259-477B-926D2759D3E5E595
promountil
string
rating
stringnone
recorduid
stringA4D0F8CE-5259-477B-926D2759D3E5E595
reference
stringSBGA3525
related
string
reserved
number4
returned
number0
returnsallowed
number1
section
stringlingerie
shipment
string5to7days
showbrand
number0
sizeinfos
Query
Template: /system/api/product/sizes.cfc:20
Execution Time: 2.29 ms
Record Count: 24
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,'2382,2383,2384,2385,2386,2388') > 0
and product_variations.productuid = 'A4D0F8CE-5259-477B-926D2759D3E5E595'
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
123884XL+intlsizepink4XL+4XL+-19999992wpluslingerie4XL4XL+50-5220-2224-2652-5452-5450-5256-5852-5450-52127-132
223884XL+intlsizeblack4XL+4XL+-19999991wpluslingerie4XL4XL+50-5220-2224-2652-5452-5450-5256-5852-5450-52127-132
323884XL+intlsizewhite4XL+4XL+-19999990wpluslingerie4XL4XL+50-5220-2224-2652-5452-5450-5256-5852-5450-52127-132
423884XL+intlsizepurple4XL+4XL+-19999990wpluslingerie4XL4XL+50-5220-2224-2652-5452-5450-5256-5852-5450-52127-132
52382LintlsizepurpleLL-19999993wpluslingerieLL40-4210-1214-1642-4442-4440-4246-4842-4440-42102-107
62382LintlsizewhiteLL-19999991wpluslingerieLL40-4210-1214-1642-4442-4440-4246-4842-4440-42102-107
72382LintlsizeblackLL-19999990wpluslingerieLL40-4210-1214-1642-4442-4440-4246-4842-4440-42102-107
82382LintlsizepinkLL-19999990wpluslingerieLL40-4210-1214-1642-4442-4440-4246-4842-4440-42102-107
92383XLintlsizepinkXLXL-19999990wpluslingerieXLXL42-4412-1416-1844-4644-4642-4448-5044-4642-44107-112
102383XLintlsizewhiteXLXL-19999990wpluslingerieXLXL42-4412-1416-1844-4644-4642-4448-5044-4642-44107-112
112383XLintlsizeblackXLXL-19999990wpluslingerieXLXL42-4412-1416-1844-4644-4642-4448-5044-4642-44107-112
122383XLintlsizepurpleXLXL-19999990wpluslingerieXLXL42-4412-1416-1844-4644-4642-4448-5044-4642-44107-112
1323842XLintlsizepink2XL2XL-19999993wpluslingerie2XL2XL44-4614-1618-2046-4846-4844-4650-5246-4844-46112-117
1423842XLintlsizewhite2XL2XL-19999993wpluslingerie2XL2XL44-4614-1618-2046-4846-4844-4650-5246-4844-46112-117
1523842XLintlsizepurple2XL2XL-19999992wpluslingerie2XL2XL44-4614-1618-2046-4846-4844-4650-5246-4844-46112-117
1623842XLintlsizeblack2XL2XL-19999990wpluslingerie2XL2XL44-4614-1618-2046-4846-4844-4650-5246-4844-46112-117
1723853XLintlsizewhite3XL3XL-19999992wpluslingerie3XL3XL46-4816-1820-2248-5048-5046-4852-5448-5046-48117-123
1823853XLintlsizepurple3XL3XL-19999991wpluslingerie3XL3XL46-4816-1820-2248-5048-5046-4852-5448-5046-48117-123
1923853XLintlsizepink3XL3XL-19999990wpluslingerie3XL3XL46-4816-1820-2248-5048-5046-4852-5448-5046-48117-123
2023853XLintlsizeblack3XL3XL-19999990wpluslingerie3XL3XL46-4816-1820-2248-5048-5046-4852-5448-5046-48117-123
2123864XLintlsizepink4XL4XL-19999992wpluslingerie4XL4XL48-5018-2022-2450-5250-5248-5054-5650-5248-50123-127
2223864XLintlsizeblack4XL4XL-19999991wpluslingerie4XL4XL48-5018-2022-2450-5250-5248-5054-5650-5248-50123-127
2323864XLintlsizepurple4XL4XL-19999990wpluslingerie4XL4XL48-5018-2022-2450-5250-5248-5054-5650-5248-50123-127
2423864XLintlsizewhite4XL4XL-19999990wpluslingerie4XL4XL48-5018-2022-2450-5250-5248-5054-5650-5248-50123-127
sizeranges
stringplus
sizes
string2382,2383,2384,2385,2386,2388
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
number17
stocks
Query
Template: /system/api/product/stocks.cfc:25
Execution Time: 10.2 ms
Record Count: 20
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 = 'A4D0F8CE-5259-477B-926D2759D3E5E595'
and product_variations.isactive = 1
and product_sizes.id_size = 2382
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 = 'A4D0F8CE-5259-477B-926D2759D3E5E595'
and product_variations.isactive = 1
and product_sizes.id_size = 2383
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 = 'A4D0F8CE-5259-477B-926D2759D3E5E595'
and product_variations.isactive = 1
and product_sizes.id_size = 2384
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 = 'A4D0F8CE-5259-477B-926D2759D3E5E595'
and product_variations.isactive = 1
and product_sizes.id_size = 2385
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 = 'A4D0F8CE-5259-477B-926D2759D3E5E595'
and product_variations.isactive = 1
and product_sizes.id_size = 2386
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 = 'A4D0F8CE-5259-477B-926D2759D3E5E595'
and product_variations.isactive = 1
and product_sizes.id_size = 2388
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
1A4D0F8CE-5259-477B-926D2759D3E5E59556D2D3B5-506D-4DF2-BF9C21779B37609E2382black#000000LL40-4210-1214-1642-4442-4440-4246-4842-4440-42wlingerieLintlsize16.62511.625STOCK01000-10000-10all
2A4D0F8CE-5259-477B-926D2759D3E5E595F628F517-7965-4A4F-8330A06D12FE53072382pink#FE70BDLL40-4210-1214-1642-4442-4440-4246-4842-4440-42wlingerieLintlsize16.62511.625STOCK01000-10000-10all
3A4D0F8CE-5259-477B-926D2759D3E5E595F2F720B8-E743-4C6A-9C1BFB54F811BD982382purple#9400D4LL40-4210-1214-1642-4442-4440-4246-4842-4440-42wlingerieLintlsize16.62511.625STOCK01300-1000033all
4A4D0F8CE-5259-477B-926D2759D3E5E59589B5AC19-FBDA-4211-A42B598606AF4B772382white#FFFFFFLL40-4210-1214-1642-4442-4440-4246-4842-4440-42wlingerieLintlsize16.62511.625STOCK01100-1000011all
5A4D0F8CE-5259-477B-926D2759D3E5E59523ECCE09-BA2D-4E72-BB3A5724C0AE4D722383black#000000XLXL42-4412-1416-1844-4644-4642-4448-5044-4642-44wlingerieXLintlsize16.62511.625STOCK01000-10000-10all
6A4D0F8CE-5259-477B-926D2759D3E5E595070E9BD2-BA02-48C2-893B54CB001282A22383pink#FE70BDXLXL42-4412-1416-1844-4644-4642-4448-5044-4642-44wlingerieXLintlsize16.62511.625STOCK01000-10000-10all
7A4D0F8CE-5259-477B-926D2759D3E5E5957BF6DE69-08CD-4C67-B55A133889E99A672383purple#9400D4XLXL42-4412-1416-1844-4644-4642-4448-5044-4642-44wlingerieXLintlsize16.62511.625STOCK01000-11100-10all
8A4D0F8CE-5259-477B-926D2759D3E5E595D637F612-1272-44B3-81520F2EF391BF2F2383white#FFFFFFXLXL42-4412-1416-1844-4644-4642-4448-5044-4642-44wlingerieXLintlsize16.62511.625STOCK01000-10000-10all
9A4D0F8CE-5259-477B-926D2759D3E5E5951DD2F5FA-33CC-462B-88C74BB7514EDFA82384black#0000002XL2XL44-4614-1618-2046-4846-4844-4650-5246-4844-46wlingerie2XLintlsize16.62511.625STOCK01000-10000-10all
10A4D0F8CE-5259-477B-926D2759D3E5E5950EE2DE8B-AD1A-4027-A0D2B51D0B898B8D2384pink#FE70BD2XL2XL44-4614-1618-2046-4846-4844-4650-5246-4844-46wlingerie2XLintlsize16.62511.625STOCK01300-1000033all
11A4D0F8CE-5259-477B-926D2759D3E5E59535CB5B8F-16CC-47D0-9F680AB105A39D332384purple#9400D42XL2XL44-4614-1618-2046-4846-4844-4650-5246-4844-46wlingerie2XLintlsize16.62511.625STOCK01200-1000022all
12A4D0F8CE-5259-477B-926D2759D3E5E595076C5C2F-8FDA-4491-BABFDBE9D628C42D2384white#FFFFFF2XL2XL44-4614-1618-2046-4846-4844-4650-5246-4844-46wlingerie2XLintlsize16.62511.625STOCK01300-1000033all
13A4D0F8CE-5259-477B-926D2759D3E5E59576F9AD53-67B1-4EB4-BEE05CA4AEE1F3D82385black#0000003XL3XL46-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie3XLintlsize16.62511.625STOCK01000-10000P5278-10all
14A4D0F8CE-5259-477B-926D2759D3E5E5958FE91780-E2E3-47AF-86107C4FEBF94EB32385pink#FE70BD3XL3XL46-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie3XLintlsize16.62511.625STOCK01000-10000-10all
15A4D0F8CE-5259-477B-926D2759D3E5E595685ED9CD-BCB4-457C-A2301574E71733502385purple#9400D43XL3XL46-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie3XLintlsize16.62511.625STOCK01100-1000011all
16A4D0F8CE-5259-477B-926D2759D3E5E595F0B9C656-BFE1-48A1-9A93AA6F4C01A4CC2385white#FFFFFF3XL3XL46-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie3XLintlsize16.62511.625STOCK01200-1000022all
17A4D0F8CE-5259-477B-926D2759D3E5E595B54E3035-833D-490C-9E03BA3ED19AF2682386black#0000004XL4XL48-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie4XLintlsize16.62511.625STOCK01200-11100P5278-1011911all
18A4D0F8CE-5259-477B-926D2759D3E5E5952C1D7BDC-F8B8-484D-A33F32B44D60CA2B2386pink#FE70BD4XL4XL48-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie4XLintlsize16.62511.625STOCK01300-11100P5178-3P111922all
19A4D0F8CE-5259-477B-926D2759D3E5E595AA3CECAB-B952-4223-B546A81500124DC42386purple#9400D44XL4XL48-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie4XLintlsize16.62511.625STOCK01100-11200P5278P5278-40719-10all
20A4D0F8CE-5259-477B-926D2759D3E5E595D0A2BDD7-878F-4C24-80E1EC36B33AB6862386white#FFFFFF4XL4XL48-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie4XLintlsize16.62511.625STOCK01000-10000-10all
subcategory
stringopenpanty
supplier
number-1
supplierreference
string5178
tags
string
themes
stringhot,sexystrings
totalvariations
number36
type
stringdefault
unitprice
number11.625
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 15.6 ms
Record Count: 24
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 = 'A4D0F8CE-5259-477B-926D2759D3E5E595' 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 = 'A4D0F8CE-5259-477B-926D2759D3E5E595' 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 = 'A4D0F8CE-5259-477B-926D2759D3E5E595' 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 = 'A4D0F8CE-5259-477B-926D2759D3E5E595' 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 = 'A4D0F8CE-5259-477B-926D2759D3E5E595' 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 = 'A4D0F8CE-5259-477B-926D2759D3E5E595' 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 = 'A4D0F8CE-5259-477B-926D2759D3E5E595'
and product_variations.isactive = 1
and product_sizes.id_size = 2382
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 = 'A4D0F8CE-5259-477B-926D2759D3E5E595' 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 = 'A4D0F8CE-5259-477B-926D2759D3E5E595' 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 = 'A4D0F8CE-5259-477B-926D2759D3E5E595' 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 = 'A4D0F8CE-5259-477B-926D2759D3E5E595' 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 = 'A4D0F8CE-5259-477B-926D2759D3E5E595' 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 = 'A4D0F8CE-5259-477B-926D2759D3E5E595' 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 = 'A4D0F8CE-5259-477B-926D2759D3E5E595'
and product_variations.isactive = 1
and product_sizes.id_size = 2383
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 = 'A4D0F8CE-5259-477B-926D2759D3E5E595' 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 = 'A4D0F8CE-5259-477B-926D2759D3E5E595' 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 = 'A4D0F8CE-5259-477B-926D2759D3E5E595' 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 = 'A4D0F8CE-5259-477B-926D2759D3E5E595' 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 = 'A4D0F8CE-5259-477B-926D2759D3E5E595' 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 = 'A4D0F8CE-5259-477B-926D2759D3E5E595' 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 = 'A4D0F8CE-5259-477B-926D2759D3E5E595'
and product_variations.isactive = 1
and product_sizes.id_size = 2384
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 = 'A4D0F8CE-5259-477B-926D2759D3E5E595' 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 = 'A4D0F8CE-5259-477B-926D2759D3E5E595' 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 = 'A4D0F8CE-5259-477B-926D2759D3E5E595' 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 = 'A4D0F8CE-5259-477B-926D2759D3E5E595' 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 = 'A4D0F8CE-5259-477B-926D2759D3E5E595' 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 = 'A4D0F8CE-5259-477B-926D2759D3E5E595' 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 = 'A4D0F8CE-5259-477B-926D2759D3E5E595'
and product_variations.isactive = 1
and product_sizes.id_size = 2385
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 = 'A4D0F8CE-5259-477B-926D2759D3E5E595' 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 = 'A4D0F8CE-5259-477B-926D2759D3E5E595' 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 = 'A4D0F8CE-5259-477B-926D2759D3E5E595' 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 = 'A4D0F8CE-5259-477B-926D2759D3E5E595' 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 = 'A4D0F8CE-5259-477B-926D2759D3E5E595' 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 = 'A4D0F8CE-5259-477B-926D2759D3E5E595' 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 = 'A4D0F8CE-5259-477B-926D2759D3E5E595'
and product_variations.isactive = 1
and product_sizes.id_size = 2386
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 = 'A4D0F8CE-5259-477B-926D2759D3E5E595' 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 = 'A4D0F8CE-5259-477B-926D2759D3E5E595' 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 = 'A4D0F8CE-5259-477B-926D2759D3E5E595' 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 = 'A4D0F8CE-5259-477B-926D2759D3E5E595' 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 = 'A4D0F8CE-5259-477B-926D2759D3E5E595' 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 = 'A4D0F8CE-5259-477B-926D2759D3E5E595' 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 = 'A4D0F8CE-5259-477B-926D2759D3E5E595'
and product_variations.isactive = 1
and product_sizes.id_size = 2388
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
1B54E3035-833D-490C-9E03BA3ED19AF2682388black#0000004XL4XL+50-5220-2224-2652-5452-5450-5256-5852-5450-52wlingerie4XL+intlsize16.62511.625STOCK01200-11100P5278-1011911-13-11111.625all
22C1D7BDC-F8B8-484D-A33F32B44D60CA2B2388pink#FE70BD4XL4XL+50-5220-2224-2652-5452-5450-5256-5852-5450-52wlingerie4XL+intlsize16.62511.625STOCK01300-11100P5178-3P111922-13-15111.625all
3AA3CECAB-B952-4223-B546A81500124DC42388purple#9400D44XL4XL+50-5220-2224-2652-5452-5450-5256-5852-5450-52wlingerie4XL+intlsize16.62511.625STOCK01100-11200P5278P5278-40719-10-13-15111.625all
4D0A2BDD7-878F-4C24-80E1EC36B33AB6862388white#FFFFFF4XL4XL+50-5220-2224-2652-5452-5450-5256-5852-5450-52wlingerie4XL+intlsize16.62511.625STOCK01000-10000-10-13-16111.625all
556D2D3B5-506D-4DF2-BF9C21779B37609E2382black#000000LL40-4210-1214-1642-4442-4440-4246-4842-4440-42wlingerieLintlsize16.62511.625STOCK01000-10000-10-14-11111.625all
6F628F517-7965-4A4F-8330A06D12FE53072382pink#FE70BDLL40-4210-1214-1642-4442-4440-4246-4842-4440-42wlingerieLintlsize16.62511.625STOCK01000-10000-10-14-15111.625all
7F2F720B8-E743-4C6A-9C1BFB54F811BD982382purple#9400D4LL40-4210-1214-1642-4442-4440-4246-4842-4440-42wlingerieLintlsize16.62511.625STOCK01300-1000033-14-15111.625all
889B5AC19-FBDA-4211-A42B598606AF4B772382white#FFFFFFLL40-4210-1214-1642-4442-4440-4246-4842-4440-42wlingerieLintlsize16.62511.625STOCK01100-1000011-14-16111.625all
923ECCE09-BA2D-4E72-BB3A5724C0AE4D722383black#000000XLXL42-4412-1416-1844-4644-4642-4448-5044-4642-44wlingerieXLintlsize16.62511.625STOCK01000-10000-10-10-11111.625all
10070E9BD2-BA02-48C2-893B54CB001282A22383pink#FE70BDXLXL42-4412-1416-1844-4644-4642-4448-5044-4642-44wlingerieXLintlsize16.62511.625STOCK01000-10000-10-10-15111.625all
117BF6DE69-08CD-4C67-B55A133889E99A672383purple#9400D4XLXL42-4412-1416-1844-4644-4642-4448-5044-4642-44wlingerieXLintlsize16.62511.625STOCK01000-11100-10-10-15111.625all
12D637F612-1272-44B3-81520F2EF391BF2F2383white#FFFFFFXLXL42-4412-1416-1844-4644-4642-4448-5044-4642-44wlingerieXLintlsize16.62511.625STOCK01000-10000-10-10-16111.625all
131DD2F5FA-33CC-462B-88C74BB7514EDFA82384black#0000002XL2XL44-4614-1618-2046-4846-4844-4650-5246-4844-46wlingerie2XLintlsize16.62511.625STOCK01000-10000-10-18-11111.625all
140EE2DE8B-AD1A-4027-A0D2B51D0B898B8D2384pink#FE70BD2XL2XL44-4614-1618-2046-4846-4844-4650-5246-4844-46wlingerie2XLintlsize16.62511.625STOCK01300-1000033-18-15111.625all
1535CB5B8F-16CC-47D0-9F680AB105A39D332384purple#9400D42XL2XL44-4614-1618-2046-4846-4844-4650-5246-4844-46wlingerie2XLintlsize16.62511.625STOCK01200-1000022-18-15111.625all
16076C5C2F-8FDA-4491-BABFDBE9D628C42D2384white#FFFFFF2XL2XL44-4614-1618-2046-4846-4844-4650-5246-4844-46wlingerie2XLintlsize16.62511.625STOCK01300-1000033-18-16111.625all
1776F9AD53-67B1-4EB4-BEE05CA4AEE1F3D82385black#0000003XL3XL46-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie3XLintlsize16.62511.625STOCK01000-10000P5278-10-13-11111.625all
188FE91780-E2E3-47AF-86107C4FEBF94EB32385pink#FE70BD3XL3XL46-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie3XLintlsize16.62511.625STOCK01000-10000-10-13-15111.625all
19685ED9CD-BCB4-457C-A2301574E71733502385purple#9400D43XL3XL46-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie3XLintlsize16.62511.625STOCK01100-1000011-13-15111.625all
20F0B9C656-BFE1-48A1-9A93AA6F4C01A4CC2385white#FFFFFF3XL3XL46-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie3XLintlsize16.62511.625STOCK01200-1000022-13-16111.625all
21B54E3035-833D-490C-9E03BA3ED19AF2682386black#0000004XL4XL48-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie4XLintlsize16.62511.625STOCK01200-11100P5278-1011911-13-11111.625all
222C1D7BDC-F8B8-484D-A33F32B44D60CA2B2386pink#FE70BD4XL4XL48-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie4XLintlsize16.62511.625STOCK01300-11100P5178-3P111922-13-15111.625all
23AA3CECAB-B952-4223-B546A81500124DC42386purple#9400D44XL4XL48-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie4XLintlsize16.62511.625STOCK01100-11200P5278P5278-40719-10-13-15111.625all
24D0A2BDD7-878F-4C24-80E1EC36B33AB6862386white#FFFFFF4XL4XL48-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie4XLintlsize16.62511.625STOCK01000-10000-10-13-16111.625all
vatrate
number20
warehouse
number21