Mi cesta

❌
Total de artículos
Ver cesta
Menú
Ver tallas
Vestido Katia
Doble clic para ampliar
SKU: LFNU9693
Vestido Katia
Promo
Stock:

Un magnífico efecto ultra envolvente para realzar todas las figuras.

Puntos destacados

  • Lujoso y sofisticado vinilo elástico premium
  • Efecto ultra envolvente para realzar cualquier figura
  • Corte ceñido al cuerpo que revela tus curvas
  • Sofisticado glamour de elegancia atemporal
  • Cremallera invisible en la espalda para un look refinado
  • Diseño moldeador que se adapta perfectamente a la forma de tu cuerpo
  • El objeto de todos los deseos sensualidad asumida
  • Calidad superior con acabados impecables y lujosos
Talla:

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

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

Vestido talla grande Katia

Descripción del producto

Este magnífico vestido de talla grande Katia está confeccionado en vinilo elástico de excelente calidad y es tan moldeador como puedas desear.

Su glamuroso largo y su corte ceñido te convertirán en el objeto de deseo.

Cremallera invisible en la espalda.

Detalles técnicos

  • Estilo : Glamuroso vestido de vinilo con efecto ultra envolvente
  • Material : Lujoso vinilo elástico de alta calidad
  • Corte : ceñido al cuerpo, esculpido
  • Largo : Glamour sofisticado elegante moderno
  • Cierre : Cremallera invisible hasta la refinada espalda
  • Efecto : Ultra envolvente para realzar cualquier figura
  • Acabados: Lujo impecable de primera calidad
  • Uso: Veladas privilegiadas de seductora seguridad en sí misma

Tallas disponibles

Disponible de XL a 3XL

Colores disponibles

Negro y Rojo

Composición

Polyurethano 25 %
Poliéster 70 %
Elastano 5 %

Guía de tallas

Comprueba cuál es tu talla

Internacional
  • Pecho
  • Talla
  • Caderas
XL
  • 104-108
  • 80-86
  • 106-110
2XL
  • 108-112
  • 86-92
  • 110-114
3XL
  • 112-114
  • 92-98
  • 114-118

Consejos de cuidado

  • Lavar a mano únicamente con jabón suave no abrasivo
  • Limpiar suavemente con un paño húmedo entre usos
  • Secar al aire libre en plano, lejos de fuentes de calor
  • Evitar cualquier planchado que dañaría el material
  • Guardar en plano en un lugar fresco y seco, evitar dobleces marcados
  • Para tallas 42-64, evitar la fricción excesiva en áreas de contacto para preservar la apariencia del material
  •  

Consejos de uso

  • Para un ajuste perfecto, deslice suavemente este vestido por la cremallera invisible de la espalda.
  • El vinilo elástico se adapta naturalmente a la forma de tu cuerpo para crear este efecto ultra envolvente.
  • Este vestido revela tu glamour y convierte cada salida en un momento de pura seducción con este elegante vinilo que celebra tu belleza moderna.

Consejos de estilo

Este vestido Katia destaca por sí solo gracias a su glamuroso diseño que revela tu sensualidad con sofisticación.

Llévalo en esas veladas especiales en las que quieres causar un impacto memorable y convertirte en el objeto de deseo de todos. El vinilo elástico y el corte moldeado crean una silueta irresistible que realza tu belleza natural.

Compleméntalo con accesorios minimalistas para dejar que el vestido sea la estrella de tu look.

El accesorio perfecto para expresar tu feminidad segura de ti misma con este glamuroso vinilo que revela tu gusto por la elegancia moderna en todo su seductor esplendor.

To Top
Ver cesta
Artículos
Total de artículos
Struct
Entries: 108
actions
Array
available
number-1
brand
stringsoisbelle
brandcode
stringswta
branding
stringdivasboudoir,smboudoir
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
stringSois Belle
breasts
stringna
careinstructions
stringwetlook
categories
stringdivasboudoir.cabaret.dresses.all
category
stringdresses
categorygender
stringf
categorymediadatas
Struct
adult
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string615
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/cabaret/dresses1.jpg
type
stringimg
width
string1336
divasboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
fetishboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
latexboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
legsboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
lustboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
private
Struct
height
string1016
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/private/default.jpg
type
stringimg
width
string703
smboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
categorysizerange
stringauto
colorinfos
Query
Template: /system/api/product/colors.cfc:13
Execution Time: 0.854 ms
Record Count: 2
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,red') > 0
and product_variations.productuid = 'B4B6B8FA-6E68-4A2F-B88D270B506A080A'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1blackcolorblakblackblack#000000-13
2redcolorredredred#F50000-12
colorrange
stringblack
colors
stringblack,red
colortype
stringcolor
comments
string
compositions
Struct
Entries: 13
coton
string
elastane
string5
free
string
leather
string
lycra
string
metal
string
nylon
string
polyamide
string
polyester
string70
polyurethane
string25
silk
string
spandex
string
viscose
string
datecreated
Date Time (Europe/Paris)
{ts '2023-09-08 15:57:23'}
defect
number0
dimensions
Struct
Entries: 14
acrylicbones
string
backsideheight
string
diameter
string
flatsteelbones
string
frontsideheight
string
fullheight
string
length
string
modestysize
string
panels
string
sides
string
spiralsteelbones
string
totallength
string
unit
stringcm
wiresize
string
display
stringall
displayfrom
string
displayto
string
grossweight
string
hasbrandinfos
booleanfalse
hascareinstructions
booleantrue
hascolorinfos
booleantrue
hascompositions
booleantrue
hasdescription
booleantrue
hasdimensions
booleanfalse
hasmaterials
booleanfalse
hasotherspecifications
booleanfalse
haspromo
number1
hasshortdescription
booleantrue
hassizeinfos
booleantrue
hasspecifications
booleantrue
hasstockinfos
booleanfalse
hasstylingtips
booleantrue
hasusageinstructions
booleantrue
hasvariations
booleantrue
import
string
inpromo
number12
instockvariations
string
isactive
number1
iscustommade
number0
isdivasize
number0
isfirstprice
number0
isfixedprice
number0
ishot
number0
isnew
number0
isonline
number0
isoutletprice
number0
itemprice
number58.2917
itempromo
number41.625
key
string20332-bk
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-08-01 17:20:38'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.609 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('b4b6b8fa-6e68-4a2f-b88d270b506a080a',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.27 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 <> 'LFNU9693'
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
string2048
isprivate
string0
rating
stringall
src
string/photobank/products/swta/lfnu9693/24827405.jpg
type
stringimg
width
string1417
back
Struct
height
string1964
isprivate
string0
rating
stringall
src
string/photobank/products/swta/lfnu9693/24825390.jpg
type
stringimg
width
string1359
default
Struct
height
string2048
isprivate
string0
rating
stringall
src
string/photobank/products/swta/lfnu9693/24811815.jpg
type
stringimg
width
string1417
variations
Struct
colors
Struct
black
Struct
height
string2048
isprivate
string0
rating
stringall
src
string/photobank/products/swta/lfnu9693/24811815.jpg
type
stringimg
width
string1417
red
Struct
height
string2048
isprivate
string0
rating
stringall
src
string/photobank/products/swta/lfnu9693/24827405.jpg
type
stringimg
width
string1417
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
mediagallery
string
metadatas
Struct
darkboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz-ou-rot
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro-ou-kokkino
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black-ou-red
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro-ou-rojo
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-ou-rouge
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero-ou-rosso
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart-ou-rood
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto-ou-vermelho
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
divasboudoir
Struct
de
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringDieses wundersch&ouml;ne Kleid in &Uuml;bergr&ouml;&szlig;e von Katia besteht aus hochwertigem, elastischem Vinyl und ist sehr figurformend.<br /><br />Die glamour&ouml;se L&auml;nge und der k&ouml;rpernahe Schnitt machen Sie zum Objekt der Begierde.<br /><br />Unsichtbarer Rei&szlig;verschluss &uuml;ber die gesamte R&uuml;ckseite.
guid
stringhttps://dev.divasboudoir.com/de/kleid-in-ubergrosse-katia-schwarz-ou-rot/lfnu9693.htm
highlights
string<ul> <li>Luxuriöses und anspruchsvolles elastisches Vinyl in Premium-Qualität.</li> <li><strong>Ultra-straffende Wirkung</strong>, die jede Figur betont</li> <li>Körpernaher Schnitt, der Ihre Kurven zum Vorschein bringt</li> <li>Glamouröse Länge raffiniert zeitlos elegant</li> <li>Raffinierter, unsichtbarer Reißverschluss auf der Rückseite</li> <li>Formgebendes Design, das sich <strong> perfekt an</strong> Ihre Körperform <strong> anpasst</strong> </li> <li>Objekt der Begierde Selbstbewusste Sinnlichkeit</li> <li>Hochwertige Qualität Makellose, luxuriöse Verarbeitung</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringEin toller, ultra-straffender Effekt, der jede Silhouette zur Geltung bringt.
keywords
string
title
stringKleid in Übergröße Katia
seotitle
stringKleid in Übergröße Katia
seouri
stringkleid-in-ubergrosse-katia-schwarz-ou-rot
specifications
string<ul> <li>Stil: Glamouröses Vinylkleid mit ultra-straffendem Effekt</li> <li>Material: Luxuriöses, elastisches Vinyl in Premium-Qualität</li> <li>Schnitt: Eng anliegend figurformend skulpturierend</li> <li>Länge: Glamourös anspruchsvoll elegant modern</li> <li>Verschluss: Unsichtbarer Reißverschluss ganz hinten raffiniert</li> <li>Wirkung: Ultra-straffend, betont jede Figur</li> <li>Verarbeitung: Hochwertige Qualität, makellos und luxuriös</li> <li>Verwendungszweck: Privilegierte Abende mit verführerischem Charakter</li> </ul>
stylingtips
string<p>Dieses Kleid von Katia ist dank seines glamourösen Designs, das Ihre Sinnlichkeit auf raffinierte Weise offenbart, selbstgenügsam.</p> <p>Tragen Sie es zu besonderen Anlässen, an denen Sie eine unvergessliche Wirkung erzielen und zum Objekt der Begierde werden wollen. Das elastische Vinyl und der figurformende Schnitt schaffen eine unwiderstehliche Silhouette, die Ihre natürliche Schönheit unterstreicht.</p> <p>Ergänzen Sie es mit minimalistischen Accessoires, um das Kleid zum Star Ihres Looks werden zu lassen.</p> <p>Das perfekte Accessoire, um Ihre selbstbewusste Weiblichkeit mit diesem glamourösen Vinyl auszudrücken, das Ihre Vorliebe für moderne Eleganz in all ihrer verführerischen Pracht offenbart.</p>
summary
stringEin toller, ultra-straffender Effekt, der jede Silhouette zur Geltung bringt.
title
stringKleid Katia
usageinstructions
string<ul> <li>Ziehen Sie dieses Kleid sanft an und nutzen Sie den verdeckten Reißverschluss auf der Rückseite für eine perfekte Passform.</li> <li>Das elastische Vinyl passt sich auf natürliche Weise Ihrer Körperform an, um diesen ultra-umhüllenden Effekt zu erzielen.</li> <li>Dieses Kleid enthüllt Ihren Glamour und verwandelt jedes Date in einen Moment der puren Verführung mit dieser Vinyl-Eleganz, die Ihre moderne Schönheit zelebriert.</li> </ul>
el
Struct
Entries: 15
abstract
string
careinstructions
string
description
string&Alpha;&upsilon;&tau;ό &tau;&omicron; &upsilon;&pi;έ&rho;&omicron;&chi;&omicron; &phi;ό&rho;&epsilon;&mu;&alpha; Katia plus size &epsilon;ί&nu;&alpha;&iota; &kappa;&alpha;&tau;&alpha;&sigma;&kappa;&epsilon;&upsilon;&alpha;&sigma;&mu;έ&nu;&omicron; &alpha;&pi;ό &epsilon;&xi;&alpha;&iota;&rho;&epsilon;&tau;&iota;&kappa;ή&sigmaf; &pi;&omicron;&iota;ό&tau;&eta;&tau;&alpha;&sigmaf; &epsilon;&lambda;&alpha;&sigma;&tau;&iota;&kappa;ό &beta;&iota;&nu;ύ&lambda;&iota;&omicron; &kappa;&alpha;&iota; &epsilon;ί&nu;&alpha;&iota; &tau;ό&sigma;&omicron; &kappa;&alpha;&lambda;&lambda;ί&gamma;&rho;&alpha;&mu;&mu;&omicron; ό&sigma;&omicron; &theta;&alpha; &mu;&pi;&omicron;&rho;&omicron;ύ&sigma;&alpha;&tau;&epsilon; &nu;&alpha; &epsilon;&pi;&iota;&theta;&upsilon;&mu;&epsilon;ί&tau;&epsilon;.<br /><br />&Tau;&omicron; &gamma;&omicron;&eta;&tau;&epsilon;&upsilon;&tau;&iota;&kappa;ό &mu;ή&kappa;&omicron;&sigmaf; &tau;&omicron;&upsilon; &kappa;&alpha;&iota; &eta; &sigma;&tau;&epsilon;&nu;ή &epsilon;&phi;&alpha;&rho;&mu;&omicron;&gamma;ή &tau;&omicron;&upsilon; &theta;&alpha; &sigma;&alpha;&sigmaf; &kappa;ά&nu;&omicron;&upsilon;&nu; &tau;&omicron; &alpha;&nu;&tau;&iota;&kappa;&epsilon;ί&mu;&epsilon;&nu;&omicron; &tau;&omicron;&upsilon; &pi;ό&theta;&omicron;&upsilon;.<br /><br />&Alpha;ό&rho;&alpha;&tau;&omicron; &phi;&epsilon;&rho;&mu;&omicron;&upsilon;ά&rho; &sigma;&tau;&eta;&nu; &pi;&lambda;ά&tau;&eta;.
guid
stringhttps://dev.divasboudoir.com/el/katia-plus-size-forema-mayro-ou-kokkino/lfnu9693.htm
highlights
string<ul> <li>Πολυτελές και εκλεπτυσμένο premium ελαστικό βινύλιο</li> <li><strong>Εξαιρετικά περιτυλιγμένο αποτέλεσμα</strong> για να αναδεικνύει κάθε φιγούρα</li> <li>Το κόψιμο που αγκαλιάζει το σώμα αποκαλύπτει τις καμπύλες σας</li> <li>Εκλεπτυσμένη γοητεία σε μήκος διαχρονικής κομψότητας</li> <li>Αόρατο φερμουάρ στην πλάτη για εκλεπτυσμένη εμφάνιση</li> <li>Σχεδιασμός διαμόρφωσης <strong> που προσαρμόζεται τέλεια</strong> στο σχήμα του σώματός σας</li> <li>Το αντικείμενο κάθε επιθυμίας αισθησιασμού που αναλαμβάνεται</li> <li>Ανώτερη ποιότητα με άψογα, πολυτελή φινιρίσματα</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringΈνα υπέροχο αποτέλεσμα που τονίζει κάθε σιλουέτα.
keywords
string
title
stringKatia plus size φόρεμα
seotitle
stringKatia plus size φόρεμα
seouri
stringkatia-plus-size-forema-mayro-ou-kokkino
specifications
string<ul> <li>Στυλ : Γοητευτικό φόρεμα από βινύλιο με ultra-sheathing effect</li> <li>Υλικό : Πολυτελές ελαστικό βινύλιο υψηλής ποιότητας</li> <li>Κοπή : Αγκαλιάζει το σώμα, σμιλεύει το σώμα</li> <li>Μήκος : Γκλάμουρ εκλεπτυσμένο κομψό μοντέρνο</li> <li>Κλείσιμο: Αόρατο φερμουάρ μέχρι την εκλεπτυσμένη πλάτη</li> <li>Επίδραση : Υπερβολική περιβολή για να αναδεικνύει κάθε σιλουέτα</li> <li>Τελειώματα: Άψογα πολυτελές κορυφαίας ποιότητας</li> <li>Φορέστε: Προνομιακές βραδιές σαγηνευτικής αυτοπεποίθησης</li> </ul>
stylingtips
string<p>Αυτό το φόρεμα Katia στέκεται από μόνο του χάρη στο λαμπερό του σχέδιο που αποκαλύπτει τον αισθησιασμό σας με φινέτσα.</p> <p>Φορέστε το για εκείνες τις ξεχωριστές βραδιές που θέλετε να κάνετε μια αξέχαστη εντύπωση και να γίνετε το αντικείμενο του πόθου όλων. Το ελαστικό βινύλιο και το καλοσχηματισμένο κόψιμο δημιουργούν μια ακαταμάχητη σιλουέτα που αναδεικνύει τη φυσική σας ομορφιά.</p> <p>Συμπληρώστε με μινιμαλιστικά αξεσουάρ για να αφήσετε το φόρεμα να γίνει ο πρωταγωνιστής της εμφάνισής σας.</p> <p>Το τέλειο αξεσουάρ για να εκφράσετε τη σίγουρη θηλυκότητά σας με αυτό το λαμπερό βινύλιο που αποκαλύπτει το γούστο σας για μοντέρνα κομψότητα σε όλο το σαγηνευτικό της μεγαλείο.</p>
summary
stringΈ&nu;&alpha; &upsilon;&pi;έ&rho;&omicron;&chi;&omicron; &alpha;&pi;&omicron;&tau;έ&lambda;&epsilon;&sigma;&mu;&alpha; &pi;&omicron;&upsilon; &tau;&omicron;&nu;ί&zeta;&epsilon;&iota; &kappa;ά&theta;&epsilon; &sigma;&iota;&lambda;&omicron;&upsilon;έ&tau;&alpha;.
title
stringΦόρεμα Katia
usageinstructions
string<ul> <li>Φορέστε αυτό το φόρεμα απαλά χρησιμοποιώντας το αόρατο φερμουάρ στο πίσω μέρος για τέλεια εφαρμογή.</li> <li>Το ελαστικό βινύλιο προσαρμόζεται φυσικά στο σχήμα του σώματός σας για να δημιουργήσει αυτό το εξαιρετικά στενό αποτέλεσμα.</li> <li>Αυτό το φόρεμα αποκαλύπτει τη λάμψη σας και μετατρέπει κάθε σας έξοδο σε μια στιγμή καθαρής αποπλάνησης με αυτό το κομψό βινύλιο που εξυμνεί τη σύγχρονη ομορφιά σας.</li> </ul>
en
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringThis gorgeous Katia plus size dress is made of high-quality elastic vinyl and is as shapely as you'd like.<br /><br />Its glamorous length and body-hugging cut will make you the object of desire.<br /><br />Invisible full-back zipper.
guid
stringhttps://dev.divasboudoir.com/en/katia-plus-size-dress-black-ou-red/lfnu9693.htm
highlights
string<ul> <li>Luxurious, sophisticated premium elastic vinyl</li> <li><strong>Ultra-sheathing effect</strong> enhances every figure</li> <li>Body-hugging cut reveals your curves</li> <li>Sophisticated glamour length timeless elegance</li> <li>Sophisticated invisible zipper at back</li> <li>Shaping design <strong> perfectly matches</strong> your body shape</li> <li>The object of every desire sensuality assumed</li> <li>Superior quality impeccable, luxurious finish</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringA superb ultra-sheathing effect to enhance every figure.
keywords
string
title
stringKatia plus size dress
seotitle
stringKatia plus size dress
seouri
stringkatia-plus-size-dress-black-ou-red
specifications
string<ul> <li>Style: Glamorous vinyl dress with ultra-sheathing effect</li> <li>Material: Luxurious, high-quality elastic vinyl</li> <li>Cut: Body-hugging, sculpting</li> <li>Length: Sophisticated glamour, modern elegance</li> <li>Closure: Invisible zipper all the way to the refined back</li> <li>Effect: Ultra-sheathing to enhance every figure</li> <li>Finishes: Luxurious impeccable superior quality</li> <li>Wear: Privileged evenings of assumed seduction</li> </ul>
stylingtips
string<p>This Katia dress stands on its own thanks to its glamorous design that reveals your sensuality with sophistication.</p> <p>Wear it for those special evenings when you want to make a memorable impact and become the object of everyone's desire. Elastic vinyl and a shapely cut create an irresistible silhouette that enhances your natural beauty.</p> <p>Complete with minimalist accessories to let the dress be the star of your look.</p> <p>The perfect accessory to express your assumed femininity with this glamorous vinyl that reveals your taste for modern elegance in all its seductive splendor.</p>
summary
stringA superb ultra-sheathing effect to enhance every figure.
title
stringKatia dress
usageinstructions
string<ul> <li>Gently slip on this dress, using the invisible zipper at the back for a perfect fit.</li> <li>The elastic vinyl naturally adapts to your body shape to create this ultra-sheathing effect.</li> <li>This dress reveals your glamour and transforms every outing into a moment of pure seduction with vinyl elegance that celebrates your modern beauty.</li> </ul>
es
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringEste magn&iacute;fico vestido de talla grande Katia est&aacute; confeccionado en vinilo el&aacute;stico de excelente calidad y es tan moldeador como puedas desear.<br /><br />Su glamuroso largo y su corte ce&ntilde;ido te convertir&aacute;n en el objeto de deseo.<br /><br />Cremallera invisible en la espalda.
guid
stringhttps://dev.divasboudoir.com/es/vestido-talla-grande-katia-negro-ou-rojo/lfnu9693.htm
highlights
string<ul> <li>Lujoso y sofisticado vinilo elástico premium</li> <li><strong>Efecto ultra envolvente</strong> para realzar cualquier figura</li> <li>Corte ceñido al cuerpo que revela tus curvas</li> <li>Sofisticado glamour de elegancia atemporal</li> <li>Cremallera invisible en la espalda para un look refinado</li> <li>Diseño moldeador que <strong> se adapta perfectamente a</strong> la forma de tu cuerpo</li> <li>El objeto de todos los deseos sensualidad asumida</li> <li>Calidad superior con acabados impecables y lujosos</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringUn magnífico efecto ultra envolvente para realzar todas las figuras.
keywords
string
title
stringVestido talla grande Katia
seotitle
stringVestido talla grande Katia
seouri
stringvestido-talla-grande-katia-negro-ou-rojo
specifications
string<ul> <li>Estilo : Glamuroso vestido de vinilo con efecto ultra envolvente</li> <li>Material : Lujoso vinilo elástico de alta calidad</li> <li>Corte : ceñido al cuerpo, esculpido</li> <li>Largo : Glamour sofisticado elegante moderno</li> <li>Cierre : Cremallera invisible hasta la refinada espalda</li> <li>Efecto : Ultra envolvente para realzar cualquier figura</li> <li>Acabados: Lujo impecable de primera calidad</li> <li>Uso: Veladas privilegiadas de seductora seguridad en sí misma</li> </ul>
stylingtips
string<p>Este vestido Katia destaca por sí solo gracias a su glamuroso diseño que revela tu sensualidad con sofisticación.</p> <p>Llévalo en esas veladas especiales en las que quieres causar un impacto memorable y convertirte en el objeto de deseo de todos. El vinilo elástico y el corte moldeado crean una silueta irresistible que realza tu belleza natural.</p> <p>Compleméntalo con accesorios minimalistas para dejar que el vestido sea la estrella de tu look.</p> <p>El accesorio perfecto para expresar tu feminidad segura de ti misma con este glamuroso vinilo que revela tu gusto por la elegancia moderna en todo su seductor esplendor.</p>
summary
stringUn magn&iacute;fico efecto ultra envolvente para realzar todas las figuras.
title
stringVestido Katia
usageinstructions
string<ul> <li>Para un ajuste perfecto, deslice suavemente este vestido por la cremallera invisible de la espalda.</li> <li>El vinilo elástico se adapta naturalmente a la forma de tu cuerpo para crear este efecto ultra envolvente.</li> <li>Este vestido revela tu glamour y convierte cada salida en un momento de pura seducción con este elegante vinilo que celebra tu belleza moderna.</li> </ul>
fr
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>Cette superbe robe Katia incarne le glamour moderne avec son <strong>vinyle &eacute;lastique de qualit&eacute; sup&eacute;rieure</strong> qui r&eacute;v&egrave;le votre sensualit&eacute; avec sophistication. Un superbe effet ultra gainant pour mettre toutes les silhouettes en valeur, c&eacute;l&eacute;brant votre beaut&eacute; naturelle avec cette &eacute;l&eacute;gance contemporaine qui vous d&eacute;finit.<br><br>Le vinyle &eacute;lastique de qualit&eacute; exceptionnelle &eacute;pouse d&eacute;licatement chaque courbe, cr&eacute;ant cette silhouette galbante qui r&eacute;v&egrave;le votre f&eacute;minit&eacute; avec audace raffin&eacute;e. Cette mati&egrave;re luxueuse apporte ce <strong>brillant subtil</strong> qui capte la lumi&egrave;re et transforme chaque mouvement en spectacle captivant.<br><br>La coupe pr&egrave;s du corps constitue le secret de cette robe exceptionnelle, sculptant votre silhouette avec cette pr&eacute;cision qui r&eacute;v&egrave;le votre beaut&eacute; sous son meilleur jour. Cette conception &eacute;tudi&eacute;e transforme chaque morphologie en atout s&eacute;duction, vous rendant litt&eacute;ralement l'objet de tous les d&eacute;sirs.<br><br>La longueur glamour apporte cette dimension sophistiqu&eacute;e qui &eacute;quilibre parfaitement sensualit&eacute; et &eacute;l&eacute;gance. Cette proportion &eacute;tudi&eacute;e r&eacute;v&egrave;le vos jambes avec subtilit&eacute; tout en conservant cette classe intemporelle qui caract&eacute;rise votre style personnel.<br><br>La <strong>fermeture &eacute;clair invisible</strong> sur tout l'arri&egrave;re constitue le d&eacute;tail technique qui fait toute la diff&eacute;rence. Cette finition haut de gamme cr&eacute;e cette ligne pure et continue qui sublime votre dos, r&eacute;v&eacute;lant cette attention aux d&eacute;tails qui distingue les cr&eacute;ations d'exception.<br><br>Parfaite pour vos soir&eacute;es privil&eacute;gi&eacute;es o&ugrave; vous voulez cr&eacute;er un impact m&eacute;morable, cette robe Katia transforme chaque apparition en moment de pure s&eacute;duction avec ce glamour vinyle qui c&eacute;l&egrave;bre votre beaut&eacute; avec audace moderne.</p>
guid
stringhttps://dev.divasboudoir.com/fr/robe-grande-taille-katia-vinyle-elastique-effet-ultra-gainant/lfnu9693.htm
highlights
string<ul> <li>Vinyle &eacute;lastique qualit&eacute; sup&eacute;rieure luxueux et sophistiqu&eacute;</li> <li><strong>Effet ultra gainant</strong> mettant toutes silhouettes en valeur</li> <li>Coupe pr&egrave;s du corps r&eacute;v&eacute;lant vos courbes</li> <li>Longueur glamour sophistiqu&eacute;e &eacute;l&eacute;gante intemporelle</li> <li>Fermeture &eacute;clair invisible tout l'arri&egrave;re raffin&eacute;e</li> <li>Design galbant <strong>&eacute;pousant parfaitement</strong> votre morphologie</li> <li>Objet de tous les d&eacute;sirs sensualit&eacute; assum&eacute;e</li> <li>Qualit&eacute; sup&eacute;rieure finitions impeccables luxueuses</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringRobe grande taille Katia vinyle élastique, effet ultra gainant, coupe près du corps, fermeture éclair invisible. Glamour absolu. Diva's Boudoir.
keywords
string
title
stringRobe Katia Vinyle Élastique Grande Taille | Effet Gainant | Diva's Boudoir
seotitle
stringRobe Grande Taille Katia Vinyle Élastique - Effet Ultra Gainant
seouri
stringrobe-grande-taille-katia-vinyle-elastique-effet-ultra-gainant
specifications
string<ul> <li>Style : Robe glamour vinyle effet ultra gainant</li> <li>Mati&egrave;re : Vinyle &eacute;lastique qualit&eacute; sup&eacute;rieure luxueux</li> <li>Coupe : Pr&egrave;s du corps galbante sculptante</li> <li>Longueur : Glamour sophistiqu&eacute;e &eacute;l&eacute;gante moderne</li> <li>Fermeture : &Eacute;clair invisible tout l'arri&egrave;re raffin&eacute;e</li> <li>Effet : Ultra gainant valorisant toutes silhouettes</li> <li>Finitions : Qualit&eacute; sup&eacute;rieure impeccables luxueuses</li> <li>Usage : Soir&eacute;es privil&eacute;gi&eacute;es s&eacute;duction assum&eacute;e</li> </ul>
stylingtips
string<p>Cette robe Katia se suffit &agrave; elle-m&ecirc;me gr&acirc;ce &agrave; son design glamour qui r&eacute;v&egrave;le votre sensualit&eacute; avec sophistication.</p> <p>Portez-la pour vos soir&eacute;es sp&eacute;ciales o&ugrave; vous voulez cr&eacute;er un impact m&eacute;morable et devenir l'objet de tous les d&eacute;sirs. Le vinyle &eacute;lastique et la coupe galbante cr&eacute;ent une silhouette irr&eacute;sistible qui sublime votre beaut&eacute; naturelle.</p> <p>Compl&eacute;tez avec des accessoires minimalistes pour laisser la robe &ecirc;tre la star de votre look.</p> <p>L'accessoire parfait pour exprimer votre f&eacute;minit&eacute; assum&eacute;e avec ce glamour vinyle qui r&eacute;v&egrave;le votre go&ucirc;t pour l'&eacute;l&eacute;gance moderne dans toute sa splendeur s&eacute;ductrice.</p>
summary
string<p>Cette superbe robe Katia r&eacute;v&egrave;le votre glamour avec son vinyle &eacute;lastique de qualit&eacute; sup&eacute;rieure et son effet ultra gainant.</p> <p>Sa coupe pr&egrave;s du corps et sa longueur sophistiqu&eacute;e cr&eacute;ent <strong>une silhouette irr&eacute;sistible,</strong> tandis que la fermeture &eacute;clair invisible sublime votre dos avec &eacute;l&eacute;gance moderne.</p>
title
stringRobe Katia Vinyle Élastique - Effet Ultra Gainant et Glamour Absolu
usageinstructions
string<ul> <li>Enfilez d&eacute;licatement cette robe en utilisant la fermeture &eacute;clair invisible &agrave; l'arri&egrave;re pour un ajustement parfait.</li> <li>Le vinyle &eacute;lastique s'adapte naturellement &agrave; votre morphologie pour cr&eacute;er cet effet ultra gainant.</li> <li>Cette robe r&eacute;v&egrave;le votre glamour et transforme chaque sortie en moment de pure s&eacute;duction avec cette &eacute;l&eacute;gance vinyle qui c&eacute;l&egrave;bre votre beaut&eacute; moderne.</li> </ul>
it
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringQuesto superbo abito Katia di taglia grande &egrave; realizzato in vinile elasticizzato di qualit&agrave; superba ed &egrave; quanto di pi&ugrave; formoso si possa desiderare.<br /><br />La sua lunghezza affascinante e la sua vestibilit&agrave; aderente vi renderanno l'oggetto del desiderio.<br /><br />Zip invisibile sul retro.
guid
stringhttps://dev.divasboudoir.com/it/abito-katia-taglia-grande-nero-ou-rosso/lfnu9693.htm
highlights
string<ul> <li>Lussuoso e sofisticato vinile elastico premium</li> <li><strong>Effetto ultra-guaina</strong> per valorizzare qualsiasi figura</li> <li>Il taglio aderente al corpo rivela le vostre curve</li> <li>Eleganza sofisticata e glamour senza tempo</li> <li>Zip invisibile sul retro per un look raffinato</li> <li>Il design modellante <strong> si adatta perfettamente alle</strong> forme del corpo</li> <li>L'oggetto di ogni desiderio: la sensualità assunta</li> <li>Qualità superiore con finiture impeccabili e lussuose</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringUn superbo effetto ultra-guaina per valorizzare ogni figura.
keywords
string
title
stringAbito Katia taglia grande
seotitle
stringAbito Katia taglia grande
seouri
stringabito-katia-taglia-grande-nero-ou-rosso
specifications
string<ul> <li>Stile : abito in vinile glamour con effetto ultra-guaina</li> <li>Materiale: lussuoso vinile elastico di alta qualità</li> <li>Taglio : aderente al corpo, modellante</li> <li>Lunghezza : Glamour, sofisticato, elegante e moderno</li> <li>Chiusura: Zip invisibile fino alla raffinata schiena</li> <li>Effetto : Ultra inguainante per esaltare qualsiasi figura</li> <li>Finiture: Impeccabilmente lussuose di alta qualità</li> <li>Da indossare: Serate privilegiate all'insegna di una seducente sicurezza di sé</li> </ul>
stylingtips
string<p>Questo abito Katia si distingue per il suo design glamour che rivela la vostra sensualità con raffinatezza.</p> <p>Indossatelo per quelle serate speciali in cui volete avere un impatto memorabile e diventare l'oggetto del desiderio di tutti. Il vinile elastico e il taglio sagomato creano una silhouette irresistibile che esalta la vostra bellezza naturale.</p> <p>Completate con accessori minimalisti per lasciare che l'abito sia il protagonista del vostro look.</p> <p>L'accessorio perfetto per esprimere la vostra femminilità sicura con questo vinile glamour che rivela il vostro gusto per l'eleganza moderna in tutto il suo splendore seducente.</p>
summary
stringUn superbo effetto ultra-guaina per valorizzare ogni figura.
title
stringAbito Katia
usageinstructions
string<ul> <li>Infilate delicatamente questo abito utilizzando la cerniera invisibile sul retro per una vestibilità perfetta.</li> <li>Il vinile elastico si adatta naturalmente alle forme del corpo per creare un effetto ultra-guaina.</li> <li>Questo abito rivela il vostro fascino e trasforma ogni uscita in un momento di pura seduzione con questo elegante vinile che celebra la vostra bellezza moderna.</li> </ul>
nl
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringDeze prachtige Katia jurk voor groote maten is gemaakt van stretchvinyl van uitstekende kwaliteit en is zo mooi als je je maar kunt wensen.<br /><br />De glamoureuze lengte en nauwsluitende pasvorm maken van jou het voorwerp van verlangen.<br /><br />Onzichtbare ritssluiting aan de achterkant.
guid
stringhttps://dev.divasboudoir.com/nl/katia-jurk-groote-maat-zwart-ou-rood/lfnu9693.htm
highlights
string<ul> <li>Luxueus en verfijnd premium elastisch vinyl</li> <li><strong>Ultra-hullend effect</strong> om elk figuur te verbeteren</li> <li>De nauwsluitende snit onthult je rondingen</li> <li>Geraffineerde glamourlengte tijdloze elegantie</li> <li>Onzichtbare ritssluiting aan de achterkant voor een verfijnde look</li> <li>Vormgevend ontwerp <strong> past perfect bij</strong> je lichaamsvorm</li> <li>Het object van elk verlangen sensualiteit verondersteld</li> <li>Superieure kwaliteit met onberispelijke, luxueuze afwerkingen</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringEen prachtig ultrazacht effect om elk figuur te benadrukken.
keywords
string
title
stringKatia jurk groote maat
seotitle
stringKatia jurk groote maat
seouri
stringkatia-jurk-groote-maat-zwart-ou-rood
specifications
string<ul> <li>Stijl : Glamoureuze vinyl jurk met ultra-sheathing effect</li> <li>Materiaal: Luxueus elastisch vinyl van hoge kwaliteit</li> <li>Snit : Lichamelijk aansluitend, modellerend</li> <li>Lengte : Glamour verfijnd elegant modern</li> <li>Sluiting: Onzichtbare ritssluiting tot op de geraffineerde rug</li> <li>Effect : Ultra omhullend om elk figuur te verbeteren</li> <li>Afwerking: Onberispelijk luxueuze topkwaliteit</li> <li>Dragen: Geprivilegieerde avonden van verleidelijke zelfverzekerdheid</li> </ul>
stylingtips
string<p>Deze Katia jurk staat op zichzelf dankzij het glamoureuze ontwerp dat je sensualiteit onthult met verfijning.</p> <p>Draag het voor die speciale avonden waarop je een gedenkwaardige indruk wilt maken en het voorwerp van ieders verlangen wilt worden. Het elastische vinyl en de mooie snit creëren een onweerstaanbaar silhouet dat je natuurlijke schoonheid benadrukt.</p> <p>Complementeer met minimalistische accessoires om de jurk de ster van je look te laten zijn.</p> <p>Het perfecte accessoire om je zelfverzekerde vrouwelijkheid uit te drukken met dit glamoureuze vinyl dat je smaak voor moderne elegantie in al zijn verleidelijke glorie onthult.</p>
summary
stringEen prachtig ultrazacht effect om elk figuur te benadrukken.
title
stringKatia jurk
usageinstructions
string<ul> <li>Trek deze jurk voorzichtig aan met de onzichtbare rits aan de achterkant voor een perfecte pasvorm.</li> <li>Het elastische vinyl past zich op natuurlijke wijze aan je lichaamsvorm aan om dit ultra-sheathing effect te creëren.</li> <li>Deze jurk onthult je glamour en maakt van elk uitje een moment van pure verleiding met dit elegante vinyl dat je moderne schoonheid viert.</li> </ul>
pt
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringEste soberbo vestido Katia plus size &eacute; feito de vinil el&aacute;stico de qualidade soberba e &eacute; t&atilde;o elegante como poderia desejar.<br /><br />O seu comprimento glamoroso e o ajuste justo far&atilde;o de si o objeto de desejo.<br /><br />Fecho invis&iacute;vel na parte de tr&aacute;s.
guid
stringhttps://dev.divasboudoir.com/pt/vestido-katia-plus-size-preto-ou-vermelho/lfnu9693.htm
highlights
string<ul> <li>Vinil elástico de alta qualidade, luxuoso e sofisticado</li> <li><strong>Efeito ultra-revestido</strong> para realçar qualquer figura</li> <li>O corte justo ao corpo revela as suas curvas</li> <li>Comprimento sofisticado e glamouroso, elegância intemporal</li> <li>Fecho invisível nas costas para um look requintado</li> <li>O design modelador <strong> adapta-se perfeitamente à</strong> forma do seu corpo</li> <li>O objeto de todos os desejos sensualidade assumida</li> <li>Qualidade superior com acabamentos impecáveis e luxuosos</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringUm efeito ultra-revestido soberbo para realçar qualquer figura.
keywords
string
title
stringVestido Katia plus size
seotitle
stringVestido Katia plus size
seouri
stringvestido-katia-plus-size-preto-ou-vermelho
specifications
string<ul> <li>Estilo : Vestido de vinil glamoroso com efeito ultra-transparente</li> <li>Material : Vinil elástico luxuoso de alta qualidade</li> <li>Corte : Modelar e esculpir junto ao corpo</li> <li>Comprimento : Glamour sofisticado elegante moderno</li> <li>Fecho : Fecho de correr invisível até às costas requintadas</li> <li>Efeito: Ultra-encolhedor: Ultra-revestimento para realçar qualquer figura</li> <li>Acabamentos: Impecavelmente luxuosos e de qualidade superior</li> <li>Utilização: Noites privilegiadas de autoconfiança sedutora</li> </ul>
stylingtips
string<p>Este vestido Katia destaca-se por si só graças ao seu design glamoroso que revela a sua sensualidade com sofisticação.</p> <p>Use-o para aquelas noites especiais em que quer causar um impacto memorável e tornar-se o objeto de desejo de todos. O vinil elástico e o corte modelado criam uma silhueta irresistível que realça a sua beleza natural.</p> <p>Complete com acessórios minimalistas para deixar que o vestido seja a estrela do seu look.</p> <p>O acessório perfeito para expressar a sua feminilidade confiante com este vinil glamoroso que revela o seu gosto pela elegância moderna em toda a sua glória sedutora.</p>
summary
stringUm efeito ultra-revestido soberbo para real&ccedil;ar qualquer figura.
title
stringVestido Katia
usageinstructions
string<ul> <li>Coloque suavemente este vestido utilizando o fecho invisível nas costas para um ajuste perfeito.</li> <li>O vinil elástico adapta-se naturalmente à forma do seu corpo para criar este efeito ultra-revestido.</li> <li>Este vestido revela o seu glamour e transforma cada saída num momento de pura sedução com este vinil elegante que celebra a sua beleza moderna.</li> </ul>
fetishboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz-ou-rot
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro-ou-kokkino
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black-ou-red
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro-ou-rojo
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-ou-rouge
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero-ou-rosso
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart-ou-rood
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto-ou-vermelho
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
latexboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz-ou-rot
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro-ou-kokkino
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black-ou-red
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro-ou-rojo
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-ou-rouge
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero-ou-rosso
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart-ou-rood
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto-ou-vermelho
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
legsboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz-ou-rot
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro-ou-kokkino
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black-ou-red
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro-ou-rojo
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-ou-rouge
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero-ou-rosso
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart-ou-rood
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto-ou-vermelho
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
lustboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz-ou-rot
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro-ou-kokkino
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black-ou-red
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro-ou-rojo
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-ou-rouge
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero-ou-rosso
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart-ou-rood
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto-ou-vermelho
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
smboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringDieses wundersch&ouml;ne Kleid von Katia besteht aus hochwertigem, elastischem Vinyl und ist sehr figurformend.<br /><br />Die glamour&ouml;se L&auml;nge und der k&ouml;rpernahe Schnitt machen Sie zum Objekt der Begierde.<br /><br />Unsichtbarer Rei&szlig;verschluss &uuml;ber die gesamte R&uuml;ckseite.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringEin toller Shaping-Effekt, der jede Silhouette zur Geltung bringt.
keywords
string
title
stringKleid Katia aus elastischem Vinyl
seotitle
stringKleid Katia aus elastischem Vinyl
seouri
stringkleid-katia-aus-elastischem-vinyl-schwarz-ou-rot
specifications
string
stylingtips
string
summary
stringEin toller Shaping-Effekt, der jede Silhouette zur Geltung bringt.
title
stringKleid Katia aus elastischem Vinyl
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string&Alpha;&upsilon;&tau;ό &tau;&omicron; &upsilon;&pi;έ&rho;&omicron;&chi;&omicron; &phi;ό&rho;&epsilon;&mu;&alpha; Katia &epsilon;ί&nu;&alpha;&iota; &kappa;&alpha;&tau;&alpha;&sigma;&kappa;&epsilon;&upsilon;&alpha;&sigma;&mu;έ&nu;&omicron; &alpha;&pi;ό &upsilon;&psi;&eta;&lambda;ή&sigmaf; &pi;&omicron;&iota;ό&tau;&eta;&tau;&alpha;&sigmaf; &epsilon;&lambda;&alpha;&sigma;&tau;&iota;&kappa;ό &beta;&iota;&nu;ύ&lambda;&iota;&omicron; &kappa;&alpha;&iota; &epsilon;ί&nu;&alpha;&iota; &tau;ό&sigma;&omicron; &kappa;&alpha;&lambda;&lambda;ί&gamma;&rho;&alpha;&mu;&mu;&omicron; ό&sigma;&omicron; &theta;&alpha; &mu;&pi;&omicron;&rho;&omicron;ύ&sigma;&alpha;&tau;&epsilon; &nu;&alpha; &epsilon;&pi;&iota;&theta;&upsilon;&mu;&epsilon;ί&tau;&epsilon;.<br /><br />&Tau;&omicron; &gamma;&omicron;&eta;&tau;&epsilon;&upsilon;&tau;&iota;&kappa;ό &mu;ή&kappa;&omicron;&sigmaf; &tau;&omicron;&upsilon; &kappa;&alpha;&iota; &eta; &sigma;&tau;&epsilon;&nu;ή &epsilon;&phi;&alpha;&rho;&mu;&omicron;&gamma;ή &tau;&omicron;&upsilon; &theta;&alpha; &sigma;&alpha;&sigmaf; &kappa;ά&nu;&omicron;&upsilon;&nu; &tau;&omicron; &alpha;&nu;&tau;&iota;&kappa;&epsilon;ί&mu;&epsilon;&nu;&omicron; &tau;&omicron;&upsilon; &pi;ό&theta;&omicron;&upsilon;.<br /><br />&Alpha;ό&rho;&alpha;&tau;&omicron; &phi;&epsilon;&rho;&mu;&omicron;&upsilon;ά&rho; &sigma;&tau;&eta;&nu; &pi;&lambda;ά&tau;&eta;.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringΈνα υπέροχο αποτέλεσμα διαμόρφωσης για την ενίσχυση κάθε σιλουέτας.
keywords
string
title
stringΦόρεμα Katia από ελαστικό βινύλιο
seotitle
stringΦόρεμα Katia από ελαστικό βινύλιο
seouri
stringforema-katia-apo-elastiko-vinylio-mayro-ou-kokkino
specifications
string
stylingtips
string
summary
stringΈ&nu;&alpha; &upsilon;&pi;έ&rho;&omicron;&chi;&omicron; &alpha;&pi;&omicron;&tau;έ&lambda;&epsilon;&sigma;&mu;&alpha; &delta;&iota;&alpha;&mu;ό&rho;&phi;&omega;&sigma;&eta;&sigmaf; &gamma;&iota;&alpha; &tau;&eta;&nu; &epsilon;&nu;ί&sigma;&chi;&upsilon;&sigma;&eta; &kappa;ά&theta;&epsilon; &sigma;&iota;&lambda;&omicron;&upsilon;έ&tau;&alpha;&sigmaf;.
title
stringΦόρεμα Katia από ελαστικό βινύλιο
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringThis gorgeous Katia dress is made from superb-quality stretch vinyl and is as shapely as they come.<br /><br />Its glamorous length and close-fitting cut will make you the object of desire.<br /><br />Invisible full-back zipper.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringA superb shaping effect to enhance every figure.
keywords
string
title
stringKatia dress in stretch vinyl
seotitle
stringKatia dress in stretch vinyl
seouri
stringkatia-dress-in-stretch-vinyl-black-ou-red
specifications
string
stylingtips
string
summary
stringA superb shaping effect to enhance every figure.
title
stringKatia dress in stretch vinyl
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringEste magn&iacute;fico vestido Katia est&aacute; confeccionado en vinilo el&aacute;stico de alta calidad y no puede tener m&aacute;s forma.<br /><br />Su largo glamuroso y su corte ce&ntilde;ido te convertir&aacute;n en el objeto de deseo.<br /><br />Cremallera invisible en la espalda.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringUn magnífico efecto moldeador para realzar todas las figuras.
keywords
string
title
stringVestido Katia de vinilo elástico
seotitle
stringVestido Katia de vinilo elástico
seouri
stringvestido-katia-de-vinilo-elastico-negro-ou-rojo
specifications
string
stylingtips
string
summary
stringUn magn&iacute;fico efecto moldeador para realzar todas las figuras.
title
stringVestido Katia de vinilo elástico
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Cette superbe robe Katia est fabriqu&eacute;e en vinyle &eacute;lastique de superbe qualit&eacute; et elle est galbante &agrave; souhait.<br><br>Sa longueur glamour et sa coupe pr&egrave;s du corps feront de vous l'objet de tous les d&eacute;sirs.&nbsp;<br><br>Fermeture &eacute;clair invisible sur tout l'arri&egrave;re.</p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringUn superbe effet galbant pour mettre toutes les silhouettes en valeur.
keywords
string
title
stringRobe Katia en vinyle élastique
seotitle
stringRobe Katia en vinyle élastique
seouri
stringrobe-katia-en-vinyle-elastique-noir-ou-rouge
specifications
string
stylingtips
string
summary
string<p>Un superbe effet galbant pour mettre toutes les silhouettes en valeur.</p>
title
stringRobe Katia en vinyle élastique
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringQuesto superbo abito Katia &egrave; realizzato in vinile elasticizzato di alta qualit&agrave; ed &egrave; quanto di pi&ugrave; formoso si possa desiderare.<br /><br />La sua lunghezza affascinante e la sua vestibilit&agrave; aderente vi renderanno l'oggetto del desiderio.<br /><br />Zip invisibile sul retro.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringUn superbo effetto modellante per valorizzare ogni figura.
keywords
string
title
stringAbito Katia in vinile elasticizzato
seotitle
stringAbito Katia in vinile elasticizzato
seouri
stringabito-katia-in-vinile-elasticizzato-nero-ou-rosso
specifications
string
stylingtips
string
summary
stringUn superbo effetto modellante per valorizzare ogni figura.
title
stringAbito Katia in vinile elasticizzato
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringDeze prachtige Katia jurk is gemaakt van hoogwaardig stretchvinyl en is zo mooi als je maar kunt wensen.<br /><br />De glamoureuze lengte en nauwsluitende pasvorm maken van jou het voorwerp van verlangen.<br /><br />Onzichtbare ritssluiting aan de achterkant.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringEen prachtig vormgevend effect om elk figuur te verbeteren.
keywords
string
title
stringKatia jurk van stretch vinyl
seotitle
stringKatia jurk van stretch vinyl
seouri
stringkatia-jurk-van-stretch-vinyl-zwart-ou-rood
specifications
string
stylingtips
string
summary
stringEen prachtig vormgevend effect om elk figuur te verbeteren.
title
stringKatia jurk van stretch vinyl
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringEste soberbo vestido Katia &eacute; feito de vinil el&aacute;stico de alta qualidade e &eacute; t&atilde;o elegante como poderia desejar.<br /><br />O seu comprimento glamoroso e o seu corte justo far&atilde;o de si o objeto de desejo.<br /><br />Fecho invis&iacute;vel na parte de tr&aacute;s.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringUm efeito de modelação soberbo para realçar qualquer figura.
keywords
string
title
stringVestido Katia em vinil elástico
seotitle
stringVestido Katia em vinil elástico
seouri
stringvestido-katia-em-vinil-elastico-preto-ou-vermelho
specifications
string
stylingtips
string
summary
stringUm efeito de modela&ccedil;&atilde;o soberbo para real&ccedil;ar qualquer figura.
title
stringVestido Katia em vinil elástico
usageinstructions
string
name
string20332-BK
netweight
string
nextshipment
stringtomorrow
ordered
number5
orderidx
number0
origin
string
originalsize
string
packaging
string
productshipment
stringauto
productuid
stringB4B6B8FA-6E68-4A2F-B88D270B506A080A
promountil
string
rating
stringnone
recorduid
stringB4B6B8FA-6E68-4A2F-B88D270B506A080A
reference
stringLFNU9693
related
string
reserved
string
returned
number0
returnsallowed
number1
section
stringcabaret
shipment
string5to7days
showbrand
number0
sizeinfos
Query
Template: /system/api/product/sizes.cfc:20
Execution Time: 1.66 ms
Record Count: 6
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_sizes.id_size as recorduid, if(intlsize <> '',intlsize,eusize) as size, if(intlsize <> '','intlsize','eusize') as sizetype,
product_variations.color,
if(product_sizes.sizegroup = 'bra',
if(intlsize <> '', cast(intlsize as SIGNED ), cast(eusize as SIGNED ))
,
SUBSTRING_INDEX(intlsize,'-',1)
) as param1,
if(product_sizes.sizegroup = 'bra',
if(intlsize <> '',
MID(intlsize,length(cast(intlsize as SIGNED ))+1,length(intlsize)),
MID(eusize,length(cast(eusize as SIGNED ))+1,length(eusize))
)
,
SUBSTRING_INDEX(intlsize,'-',-1)
) as param2,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as available,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
999999,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as groupavailable,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
product_sizes.gender, product_sizes.sizerange, product_sizes.sizegroup, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize,
product_sizes.bust, product_sizes.waist, product_sizes.hip, product_sizes.underbust, product_sizes.cup, product_sizes.thigh, product_sizes.legheight, product_sizes.bodyheight, product_sizes.bodyweight
from product_sizes
left outer join product_variations on product_sizes.suppliersize = product_variations.size and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
where FIND_IN_SET(product_sizes.id_size,'2087,2086,2085,2084,2083,2082') > 0
and product_variations.productuid = 'B4B6B8FA-6E68-4A2F-B88D270B506A080A'
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
12087XLintlsizeblackXLXL-19999990wplusdressXLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42104-10880-86106-110
22087XLintlsizeredXLXL-19999990wplusdressXLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42104-10880-86106-110
320862XLintlsizeblack2XL2XL-19999991wplusdress2XL2XL44-4614-1618-2046-4846-4844-4650-5246-4844-46108-11286-92110-114
420862XLintlsizered2XL2XL-19999991wplusdress2XL2XL44-4614-1618-2046-4846-4844-4650-5246-4844-46108-11286-92110-114
520853XLintlsizeblack3XL3XL-19999992wplusdress3XL3XL48-5018-2022-2650-5250-5248-5052-5450-5248-50112-11492-98114-118
620853XLintlsizered3XL3XL-19999991wplusdress3XL3XL48-5018-2022-2650-5250-5248-5052-5450-5248-50112-11492-98114-118
sizeranges
stringstandard,plus
sizes
string2087,2086,2085,2084,2083,2082
sizetype
stringauto
specifications
Struct
Entries: 23
belly
string
bones
string
bra
string
breasts
string
bust
string
closing
string
crochtless
string
cups
string
cut
string
garter
string
halter
string
lacing
string
lining
string
modestypanel
string
panty
string
sheathing
string
sleeves
string
stocking
string
straps
string
stretch
string
suspenders
string
transparency
string
underwires
string
stock
number0
stocks
Query
Template: /system/api/product/stocks.cfc:25
Execution Time: 5.49 ms
Record Count: 6
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select * from (
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = 'B4B6B8FA-6E68-4A2F-B88D270B506A080A'
and product_variations.isactive = 1
and product_sizes.id_size = 2087
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 = 'B4B6B8FA-6E68-4A2F-B88D270B506A080A'
and product_variations.isactive = 1
and product_sizes.id_size = 2086
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 = 'B4B6B8FA-6E68-4A2F-B88D270B506A080A'
and product_variations.isactive = 1
and product_sizes.id_size = 2085
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 = 'B4B6B8FA-6E68-4A2F-B88D270B506A080A'
and product_variations.isactive = 1
and product_sizes.id_size = 2084
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 = 'B4B6B8FA-6E68-4A2F-B88D270B506A080A'
and product_variations.isactive = 1
and product_sizes.id_size = 2083
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 = 'B4B6B8FA-6E68-4A2F-B88D270B506A080A'
and product_variations.isactive = 1
and product_sizes.id_size = 2082
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
1B4B6B8FA-6E68-4A2F-B88D270B506A080A2AEC6D6A-CF90-4FFC-9C2C64AAEEC49EA82087black#000000XLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42wdressXLintlsize58.291741.625STOCK01000-1000020332-10all
2B4B6B8FA-6E68-4A2F-B88D270B506A080ABD6EA519-89EF-47CB-A7FD146983D0215B2087red#F50000XLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42wdressXLintlsize58.291741.625STOCK01000-1000020332-10all
3B4B6B8FA-6E68-4A2F-B88D270B506A080AECF69501-4ADD-439F-AB746A5154258C682086black#0000002XL2XL44-4614-1618-2046-4846-4844-4650-5246-4844-46wdress2XLintlsize58.291741.625STOCK01100-1020020332366408607205311all
4B4B6B8FA-6E68-4A2F-B88D270B506A080AC12A02BA-D0C6-477D-B3102E2BC1B5F29E2086red#F500002XL2XL44-4614-1618-2046-4846-4844-4650-5246-4844-46wdress2XLintlsize58.291741.625STOCK01100-1000020332366408607207711all
5B4B6B8FA-6E68-4A2F-B88D270B506A080A848669DD-BE50-44E3-9D72BADD3C7851382085black#0000003XL3XL48-5018-2022-2650-5250-5248-5052-5450-5248-50wdress3XLintlsize58.291741.625STOCK01200-1020020332366408607206022all
6B4B6B8FA-6E68-4A2F-B88D270B506A080AF24FEC30-C0E5-422D-A53E54083DEE0DD22085red#F500003XL3XL48-5018-2022-2650-5250-5248-5052-5450-5248-50wdress3XLintlsize58.291741.625STOCK01100-1030020332366408607208411all
subcategory
stringall
supplier
number-1
supplierreference
string20332-BK
tags
stringnoirdesir
themes
stringdark
totalvariations
string
type
stringdefault
unitprice
number41.625
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 9.36 ms
Record Count: 6
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = 'B4B6B8FA-6E68-4A2F-B88D270B506A080A' 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 = 'B4B6B8FA-6E68-4A2F-B88D270B506A080A' 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 = 'B4B6B8FA-6E68-4A2F-B88D270B506A080A' 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 = 'B4B6B8FA-6E68-4A2F-B88D270B506A080A' 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 = 'B4B6B8FA-6E68-4A2F-B88D270B506A080A' 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 = 'B4B6B8FA-6E68-4A2F-B88D270B506A080A' 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 = 'B4B6B8FA-6E68-4A2F-B88D270B506A080A'
and product_variations.isactive = 1
and product_sizes.id_size = 2087
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 = 'B4B6B8FA-6E68-4A2F-B88D270B506A080A' 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 = 'B4B6B8FA-6E68-4A2F-B88D270B506A080A' 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 = 'B4B6B8FA-6E68-4A2F-B88D270B506A080A' 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 = 'B4B6B8FA-6E68-4A2F-B88D270B506A080A' 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 = 'B4B6B8FA-6E68-4A2F-B88D270B506A080A' 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 = 'B4B6B8FA-6E68-4A2F-B88D270B506A080A' 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 = 'B4B6B8FA-6E68-4A2F-B88D270B506A080A'
and product_variations.isactive = 1
and product_sizes.id_size = 2086
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 = 'B4B6B8FA-6E68-4A2F-B88D270B506A080A' 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 = 'B4B6B8FA-6E68-4A2F-B88D270B506A080A' 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 = 'B4B6B8FA-6E68-4A2F-B88D270B506A080A' 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 = 'B4B6B8FA-6E68-4A2F-B88D270B506A080A' 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 = 'B4B6B8FA-6E68-4A2F-B88D270B506A080A' 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 = 'B4B6B8FA-6E68-4A2F-B88D270B506A080A' 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 = 'B4B6B8FA-6E68-4A2F-B88D270B506A080A'
and product_variations.isactive = 1
and product_sizes.id_size = 2085
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 = 'B4B6B8FA-6E68-4A2F-B88D270B506A080A' 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 = 'B4B6B8FA-6E68-4A2F-B88D270B506A080A' 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 = 'B4B6B8FA-6E68-4A2F-B88D270B506A080A' 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 = 'B4B6B8FA-6E68-4A2F-B88D270B506A080A' 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 = 'B4B6B8FA-6E68-4A2F-B88D270B506A080A' 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 = 'B4B6B8FA-6E68-4A2F-B88D270B506A080A' 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 = 'B4B6B8FA-6E68-4A2F-B88D270B506A080A'
and product_variations.isactive = 1
and product_sizes.id_size = 2084
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 = 'B4B6B8FA-6E68-4A2F-B88D270B506A080A' 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 = 'B4B6B8FA-6E68-4A2F-B88D270B506A080A' 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 = 'B4B6B8FA-6E68-4A2F-B88D270B506A080A' 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 = 'B4B6B8FA-6E68-4A2F-B88D270B506A080A' 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 = 'B4B6B8FA-6E68-4A2F-B88D270B506A080A' 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 = 'B4B6B8FA-6E68-4A2F-B88D270B506A080A' 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 = 'B4B6B8FA-6E68-4A2F-B88D270B506A080A'
and product_variations.isactive = 1
and product_sizes.id_size = 2083
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 = 'B4B6B8FA-6E68-4A2F-B88D270B506A080A' 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 = 'B4B6B8FA-6E68-4A2F-B88D270B506A080A' 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 = 'B4B6B8FA-6E68-4A2F-B88D270B506A080A' 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 = 'B4B6B8FA-6E68-4A2F-B88D270B506A080A' 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 = 'B4B6B8FA-6E68-4A2F-B88D270B506A080A' 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 = 'B4B6B8FA-6E68-4A2F-B88D270B506A080A' 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 = 'B4B6B8FA-6E68-4A2F-B88D270B506A080A'
and product_variations.isactive = 1
and product_sizes.id_size = 2082
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
12AEC6D6A-CF90-4FFC-9C2C64AAEEC49EA82087black#000000XLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42wdressXLintlsize58.291741.625STOCK01000-1000020332-10-10-13141.625all
2BD6EA519-89EF-47CB-A7FD146983D0215B2087red#F50000XLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42wdressXLintlsize58.291741.625STOCK01000-1000020332-10-10-12141.625all
3ECF69501-4ADD-439F-AB746A5154258C682086black#0000002XL2XL44-4614-1618-2046-4846-4844-4650-5246-4844-46wdress2XLintlsize58.291741.625STOCK01100-1020020332366408607205311-12-13141.625all
4C12A02BA-D0C6-477D-B3102E2BC1B5F29E2086red#F500002XL2XL44-4614-1618-2046-4846-4844-4650-5246-4844-46wdress2XLintlsize58.291741.625STOCK01100-1000020332366408607207711-12-12141.625all
5848669DD-BE50-44E3-9D72BADD3C7851382085black#0000003XL3XL48-5018-2022-2650-5250-5248-5052-5450-5248-50wdress3XLintlsize58.291741.625STOCK01200-1020020332366408607206022-13-13141.625all
6F24FEC30-C0E5-422D-A53E54083DEE0DD22085red#F500003XL3XL48-5018-2022-2650-5250-5248-5052-5450-5248-50wdress3XLintlsize58.291741.625STOCK01100-1030020332366408607208411-13-12141.625all
vatrate
number20
warehouse
string