Mi cesta

❌
Total de artículos
Ver cesta
Menú
Ver tallas
Conjunto Elvira
Doble clic para ampliar
SKU: CDBU8938
Conjunto Elvira
Stock:

Un conjunto impresionante de calidad perfecta y aspecto increíble.

Puntos destacados

  • Estilo provocativo y dominante que revela con audacia tu lado de corista
  • Sujetador con arnés de piel sintética elástica que se adapta perfectamente a todas las formas del cuerpo
  • Espalda descubierta con cierre de corchetes para un ajuste personalizado perfecto
  • Falda larga a juego con detalle de rayas negras en las nalgas para un efecto cautivador
  • Materiales de primera calidad: piel sintética elástica y cadenas metálicas para una calidad excepcional
Talla:

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

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

Conjunto de talla grande Elvira

Descripción del producto

El estilo provocativo y dominante de Elvira es tan seductor... una show girl con esta silueta arquitectónica ajustada...

Sujetador de arnés grande de piel sintética elástica con cinturilla de cadena negra en el cuello. Espalda descubierta con cierre de corchetes.Falda larga a juego con detalle de cadena negra en las nalgas.

Tanga no incluido

Composición: Sujetador arnés/falda larga: Piel sintética: 95% poliéster, 5% elastán; Cadena: 100% metal; Decoración exclusiva.

Instrucciones de cuidado: Lavar a mano por separado en agua fría, no secar en secadora.

Detalles técnicos

  • Color: negro intenso
  • Composición: Sujetador con arnés + falda larga a juego
  • Accesorio: tanga no incluido

Tallas disponibles

Disponible de XL a 3X

Color disponible

Negro

Guía de tallas

Comprueba cuál es tu talla

Internacional
  • Pecho
  • Talla
  • Caderas
XL
  • 97-102
  • 79-84
  • 101-107
1X
  • 102-112
  • 91-97
  • 107-119
2X
  • 112-122
  • 97-102
  • 119-129
3X
  • 122-132
  • 102-107
  • 129-145

Consejos de cuidado

  • Lavar a mano por separado sólo en agua fría
  • Utilice un detergente suave para tejidos delicados
  • evite el contacto con productos químicos o perfumes
  • No secar en secadora para preservar la imitación de cuero y la urdimbre
  • Séquela en plano, lejos de la luz directa y de fuentes de calor
  • Cuélguelo para evitar arrugas y conservar la forma

Consejos de uso

Para conseguir un efecto óptimo, ajuste primero los cierres de corchete a la forma de su cuerpo. La piel sintética elástica se ajusta cómodamente a tu figura, revelando tu lado dominante de forma natural.

La falda larga es fácil de llevar, con detalles de rayas negras que crean un efecto visual impactante.

Este conjunto transforma instantáneamente tu look en el de una auténtica corista, perfecto para revelar tu sensualidad con audacia y confianza.

Consejos de estilo

Sublima este conjunto con zapatos de salón altos para acentuar el efecto dominante, o combínalo con accesorios metálicos para reforzar el estilo provocativo.

Completa tu look con nuestras medias para completar tu look sensual, nuestros accesorios de bienestar para una experiencia completa, o nuestros vestidos sexys para variar los placeres.

El negro intenso combina a la perfección con los tonos metalizados para crear una armonía atrevida y cautivadora.

To Top
Ver cesta
Artículos
Total de artículos
Struct
Entries: 108
actions
Array
available
number-1
brand
stringdreamgirl
brandcode
stringddru
branding
stringdivasboudoir
brandmedias
string{"default":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"editorial":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"logo":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""}}
brandmetas
Struct
de
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
el
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
en
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
es
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
fr
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
it
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
nl
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
pt
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
brandname
stringDreamgirl
breasts
stringna
careinstructions
string
categories
stringdivasboudoir.cabaret.dresses.all,divasboudoir.lingerie.sexylingerie.set
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.762 ms
Record Count: 1
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_colors.color as recorduid, product_colors.type, product_colors.code, product_colors.color, product_colors.range, product_colors.hexvalue,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock
from product_colors
left outer join product_variations on product_colors.color = product_variations.color and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
where FIND_IN_SET(product_colors.color,'black') > 0
and product_variations.productuid = '27E48C45-EA2A-487A-83CB50B8128F81EF'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1blackcolorblakblackblack#000000-10
colorrange
stringblack
colors
stringblack
colortype
stringcolor
comments
string
compositions
Struct
Entries: 13
coton
string
elastane
string
free
string
leather
string
lycra
string
metal
string
nylon
string
polyamide
string
polyester
string
polyurethane
string
silk
string
spandex
string
viscose
string
datecreated
Date Time (Europe/Paris)
{ts '2024-01-19 13:16:17'}
defect
number0
dimensions
Struct
Entries: 14
acrylicbones
string
backsideheight
string
diameter
string
flatsteelbones
string
frontsideheight
string
fullheight
string
length
string
modestysize
string
panels
string
sides
string
spiralsteelbones
string
totallength
string
unit
stringcm
wiresize
string
display
stringall
displayfrom
string
displayto
string
grossweight
string
hasbrandinfos
booleanfalse
hascareinstructions
booleantrue
hascolorinfos
booleantrue
hascompositions
booleanfalse
hasdescription
booleantrue
hasdimensions
booleanfalse
hasmaterials
booleanfalse
hasotherspecifications
booleanfalse
haspromo
number0
hasshortdescription
booleantrue
hassizeinfos
booleantrue
hasspecifications
booleantrue
hasstockinfos
booleanfalse
hasstylingtips
booleantrue
hasusageinstructions
booleantrue
hasvariations
booleantrue
import
string
inpromo
number0
instockvariations
string
isactive
number1
iscustommade
number0
isdivasize
number1
isfirstprice
number0
isfixedprice
number0
ishot
number0
isnew
number0
isonline
number0
isoutletprice
number0
itemprice
number83.2917
itempromo
string
key
stringdg13198xblk
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-08-07 12:01:06'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.641 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('27e48c45-ea2a-487a-83cb50b8128f81ef',lcase(cart_actions.linkedproducts)) > 0 and cart_actions.linkedproducts is not null
)
id_actionbrandinglanguagenamecodetypeminimumOrdermaximumOrderminimumItemsmaximumItemsmaximumUseallowedItemsquotasusedCountlinkedproductslinkedthemeslinkedbrandslinkeditemparamsactiveFromactiveToisActive
linkedproducts
Query
Template: /system/api/products.cfc:1305
Execution Time: 1.32 ms
Record Count: 0
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select products.productuid as productuid, products.reference, 'default' as type, products.key, products.language, products.name,
product_links.linkuid,
products.colors, products.vatrate, products.metadatas, products.dimensions,
products.mediadatas, products.tags, products.themes, products.isdivasize,
count(distinct product_variations.variationuid) as totalvariations,
group_concat(distinct product_variations.variationuid) as variationlist,
count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END) as inpromo,
if(count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END)>0,1,0) as haspromo,
(select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0) END)) as itempromo,
IFNULL(min(product_variations.itemprice),0) as itemprice,
(select IF (products.isfixedprice = 0 and sum(product_variations.itempromo) > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null), IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0), IFNULL(min(NULLIF(product_variations.itemprice, 0)), 0) )) as unitprice,
count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.itempromo ELSE product_variations.itemprice END) as prices,
(select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN min(NULLIF(product_variations.promountil, 0)) END)) as promountil,
products.isfixedprice, products.ishot, products.isnew, if(products.orderidx > 0, products.orderidx, 999999999) as orderidx,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
count(distinct CASE WHEN ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) > 0 OR ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) <= 0 AND product_variations.supplier = 0)) THEN product_variations.variationuid END) as instockvariations,
products.brand, brands.name as brandname, IFNULL(brands.ispublic, 0) as showbrand, brands.display,
product_categories.sizetype,GROUP_CONCAT(DISTINCT product_sizes.suppliersize) as intlsize,products.sizes,product_sizes.sizerange,product_categories.mediadatas as categorymediadatas, product_categories.sizerange as categorysizerange,
product_categorymap.section, product_categorymap.category, product_categorymap.key as subcategory
from products
left outer join product_categorymap on products.productuid = product_categorymap.productuid
left outer join product_categories on (product_categories.branding = product_categorymap.branding and product_categories.section = product_categorymap.section and product_categories.category = product_categorymap.category and product_categories.key = product_categorymap.key)
left outer join product_sizes on product_sizes.id_size IN (products.sizes)
left outer join brands on products.brand = brands.brand
left outer join product_variations on product_variations.productuid = products.productuid and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
left outer join product_links on product_links.reference = products.reference
where products.isactive = 1 and products.isdeleted = 0
and brands.isactive = 1 and brands.isdeleted = 0
and product_categories.isactive = 1 and product_categories.isdeleted = 0
and product_variations.isactive = 1
and FIND_IN_SET('divasboudoir',products.branding)
and product_categories.branding IN ('all','divasboudoir')
and product_categorymap.branding IN ('all','divasboudoir')
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and products.language in ('all','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 <> 'CDBU8938'
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
string1346
isprivate
string0
rating
stringall
src
string/photobank/products/ddru/cdbu8938/ensemble-cuir-grande-taille.jpg
type
stringimg
width
string900
back
Struct
height
string1443
isprivate
string0
rating
stringall
src
string/photobank/products/ddru/cdbu8938/ensemble-cuir-grande-taille1.jpg
type
stringimg
width
string998
default
Struct
height
string1443
isprivate
string0
rating
stringall
src
string/photobank/products/ddru/cdbu8938/ensemble-cuir-grande-taille1.jpg
type
stringimg
width
string998
variations
Struct
colors
Struct
black
Struct
height
string1443
isprivate
string0
rating
stringall
src
string/photobank/products/ddru/cdbu8938/ensemble-cuir-grande-taille1.jpg
type
stringimg
width
string998
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
mediagallery
string
metadatas
Struct
darkboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
divasboudoir
Struct
de
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Separate Handwäsche ausschließlich mit kaltem Wasser</li> <li>Verwenden Sie ein mildes Spezialwaschmittel für empfindliche Textilien</li> <li>vermeiden Sie den Kontakt mit Chemikalien oder Duftstoffen</li> <li>Nicht im Trockner trocknen, um Kunstleder und Ketten zu schonen</li> <li>Flach trocknen, vor direktem Licht und Wärmequellen schützen</li> <li>Hängend aufbewahren, um Falten zu vermeiden und die Form zu erhalten</li> </ul>
description
string<p>Elvira-Set mit provokativem und dominantem Stil, aber so verführerisch... Showgirl mit dieser eng anliegenden architektonischen Silhouette...</p> <p>BH aus Kunstleder, große Größe, dehnbar, mit schwarzem Kettenband am Hals. Rückenfrei, mit Haken- und Ösenverschlüssen.<span>Passender langer Rock mit schwarzen Kettendetails am Gesäß.</span></p> <p>String nicht im Lieferumfang enthalten.</p> <p>Zusammensetzung: Harnisch-BH/Slip-Jupe: Kunstleder: 95 % Polyester, 5 % Elasthan; Kette: 100 % Metall; Exklusivität der Dekoration.</p> <p>Pflegehinweis: Separat von Hand in kaltem Wasser waschen, nicht im Trockner trocknen.</p>
guid
stringhttps://dev.divasboudoir.com/de/set-in-ubergrosse-elvira-schwarz/cdbu8938.htm
highlights
string<ul> <li><strong>Provokativer, dominanter Stil</strong>, der Ihre Showgirl-Seite kühn enthüllt</li> <li><strong>Harnisch-BH aus dehnbarem Kunstleder</strong>, der sich perfekt an jede Körperform anpasst</li> <li><strong>Neckholder mit Haken- und Ösenverschlüssen</strong> für eine perfekte individuelle Passform</li> <li><strong>Passender langer Rock</strong> mit schwarzen Streifendetails am Gesäß für einen aufregenden Effekt</li> <li><strong>Premium-Materialien</strong>: dehnbares Kunstleder und Metallketten für außergewöhnliche Qualität</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringDas Elvira-Set mit provokativem Stil und Dominanz, aber so verführerisch... Showgirl mit dieser eng anliegenden architektonischen Silhouette. Schneller Versand.
keywords
string
title
stringElvira Set in Übergröße - BDSM Similicuir
seotitle
stringSet in Übergröße Elvira
seouri
stringset-in-ubergrosse-elvira-schwarz
specifications
string<ul> <li><strong>Farbe:</strong> Intensives Schwarz</li> <li><strong>Zusammensetzung:</strong> Harnisch-BH + passender langer Rock</li> <li><strong>Zubehör:</strong> String nicht enthalten</li> </ul>
stylingtips
string<p>Veredeln Sie dieses Outfit mit hohen Pumps, um den dominanten Effekt zu betonen, oder kombinieren Sie es mit metallischen Accessoires, um den provokativen Stil zu verstärken.</p> <p>Vervollständigen Sie Ihren Look mit unseren <a href="https://www.divasboudoir.com/de/strumpfe-in-grossen-grossen/">Strümpfen</a>, um Ihren sinnlichen Look zu perfektionieren, mit unseren <a href="https://www.divasboudoir.com/de/loveshop/">Wellness-Accessoires</a> für ein komplettes Erlebnis oder mit unseren <a href="https://www.divasboudoir.com/de/sexy-kleider-in-grossen-grossen/">sexy Kleidern</a>, um für Abwechslung zu sorgen.</p> <p>Intensives Schwarz passt perfekt zu Metallic-Tönen, um eine gewagte und fesselnde Harmonie zu schaffen.</p>
summary
stringAtemberaubendes Ensemble in perfekter Qualität und mit unglaublichem Aussehen.
title
stringElvira Ensemble
usageinstructions
string<p>Um eine optimale Wirkung zu erzielen, stellen Sie zunächst die Haken- und Ösenverschlüsse auf Ihre Körperform ein. Das dehnbare Kunstleder passt sich bequem der Silhouette an und enthüllt Ihre dominante Seite auf natürliche Weise.</p> <p>Der lange Rock sitzt locker, wobei die schwarzen Streifendetails einen auffallenden visuellen Effekt erzeugen.</p> <p>Dieses Outfit verwandelt Ihren Look sofort in ein echtes Showgirl, perfekt, um Ihre Sinnlichkeit kühn und selbstbewusst zu enthüllen.</p>
el
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Πλύνετε στο χέρι ξεχωριστά σε κρύο νερό μόνο</li> <li>Χρησιμοποιήστε ήπιο απορρυπαντικό για ευαίσθητα υφάσματα</li> <li>αποφύγετε την επαφή με χημικά ή αρώματα</li> <li>Μην στεγνώνετε στο στεγνωτήριο για να διατηρήσετε την απομίμηση δέρματος και τα στημόνια</li> <li>Στεγνώνετε επίπεδα, μακριά από άμεσο φως και πηγές θερμότητας</li> <li>Κρεμάστε για να αποφύγετε τις τσακίσεις και να διατηρήσετε το σχήμα σας</li> </ul>
description
string<p>Το προκλητικό και κυρίαρχο στυλ της Elvira είναι τόσο σαγηνευτικό... ένα κορίτσι του θεάματος με αυτή τη στενή αρχιτεκτονική σιλουέτα...</p> <p>Μεγάλο, ελαστικό σουτιέν με ιμάντες από ψεύτικο δέρμα με μαύρη αλυσίδα στη μέση στο λαιμό. Γυμνή πλάτη με κούμπωμα με γάντζο και μάτι.<span>Ασορτί μακριά φούστα με λεπτομέρεια μαύρης αλυσίδας στους γλουτούς</span>.</p> <p>Το στρινγκ δεν περιλαμβάνεται</p> <p>Σύνθεση: Στηθόδεσμος καλωδίωσης/φούστα: Ψεύτικο δέρμα: 95% πολυεστέρας, 5% ελαστάν- αλυσίδα: 100% μέταλλο- αποκλειστική διακόσμηση.</p> <p>Οδηγίες φροντίδας: Πλένετε στο χέρι ξεχωριστά σε κρύο νερό, μην στεγνώνετε στο στεγνωτήριο.</p>
guid
stringhttps://dev.divasboudoir.com/el/elvira-plus-size-set-mayro/cdbu8938.htm
highlights
string<ul> <li><strong>Προκλητικό, κυρίαρχο στυλ</strong> που αποκαλύπτει με τόλμη την πλευρά του showgirl σας</li> <li><strong>Στηθόδεσμος με λουριά από τεντωμένο faux-δέρμα</strong> που προσαρμόζεται τέλεια σε όλα τα σχήματα σώματος</li> <li><strong>Απογυμνωμένη πλάτη με αγκίστρι και μάτια</strong> για τέλεια προσαρμογή</li> <li><strong>Ασορτί μακριά φούστα</strong> με λεπτομέρεια από μαύρη ρίγα στα οπίσθια για σαγηνευτικό αποτέλεσμα</li> <li><strong>Υλικά υψηλής ποιότητας</strong>: ελαστικό faux leather και μεταλλικές αλυσίδες για εξαιρετική ποιότητα</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringΤο σετ Elvira είναι προκλητικό και κυρίαρχο, αλλά τόσο σαγηνευτικό... ένα κορίτσι της επίδειξης σε αυτή την αρχιτεκτονική, εφαρμοστή σιλουέτα. Γρήγορη αποστολή.
keywords
string
title
stringElvira plus size σετ - Similicuir BDSM
seotitle
stringElvira plus size σετ
seouri
stringelvira-plus-size-set-mayro
specifications
string<ul> <li><strong>Χρώμα:</strong> βαθύ μαύρο</li> <li><strong>Σύνθεση:</strong> σουτιέν με ιμάντες + ασορτί μακριά φούστα</li> <li><strong>Αξεσουάρ:</strong> Δεν περιλαμβάνεται στρινγκ</li> </ul>
stylingtips
string<p>Αναβαθμίστε αυτό το σύνολο με ψηλές γόβες για να τονίσετε το κυρίαρχο αποτέλεσμα ή συνδυάστε το με μεταλλικά αξεσουάρ για να ενισχύσετε το προκλητικό στυλ.</p> <p>Ολοκληρώστε την εμφάνισή σας με τις <a href="https://www.divasboudoir.com/el/kaltses-megaloy-megethoys/">κάλτσες</a> μας για να ολοκληρώσετε την αισθησιακή σας εμφάνιση, τα <a href="https://www.divasboudoir.com/el/loveshop/">αξεσουάρ ευεξίας</a> για μια ολοκληρωμένη εμπειρία ή τα <a href="https://www.divasboudoir.com/el/sexi-foremata-syn-megethos/">σέξι φορέματά</a> μας για να διαφοροποιήσετε τις απολαύσεις.</p> <p>Το έντονο μαύρο συνεργάζεται τέλεια με μεταλλικούς τόνους για να δημιουργήσει μια τολμηρή, σαγηνευτική αρμονία.</p>
summary
stringΈνα εκπληκτικό σύνολο τέλειας ποιότητας και απίστευτης εμφάνισης.
title
stringΣύνολο Elvira
usageinstructions
string<p>Για βέλτιστο αποτέλεσμα, ρυθμίστε πρώτα το κούμπωμα με αγκίστρι και μάτι στο σχήμα του σώματός σας. Το ελαστικό faux leather εφαρμόζει άνετα γύρω από τη σιλουέτα σας, αποκαλύπτοντας την κυρίαρχη πλευρά σας με φυσικό τρόπο.</p> <p>Η μακριά φούστα φοριέται εύκολα, με λεπτομέρειες σε μαύρες ρίγες που δημιουργούν ένα εντυπωσιακό οπτικό αποτέλεσμα.</p> <p>Αυτό το ρούχο μεταμορφώνει αμέσως την εμφάνισή σας σε ένα πραγματικό showgirl, ιδανικό για να αποκαλύψετε τον αισθησιασμό σας με τόλμη και αυτοπεποίθηση.</p>
en
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Hand wash separately in cold water only</li> <li>Use a mild detergent for delicate textiles</li> <li>avoid contact with chemicals or perfumes</li> <li>Do not tumble dry to preserve imitation leather and warps</li> <li>Dry flat, away from direct light and heat sources</li> <li>Hang to avoid wrinkles and preserve shape</li> </ul>
description
string<p>Elvira set with a provocative, dominating style that's so seductive... show girl with this tight architectural silhouette...</p> <p>Plus-size, stretch, faux-leather harness bra with black chain waistband at neck. Bare back with hook and eye closures.<span>Matching long skirt with black chain detail on buttocks.</span></p> <p>G-string not included.</p> <p>Composition: Harness bra/slip skirt: Faux leather: 95% polyester, 5% elastane; Chain: 100% metal; Decoration exclusive</p> <p>Care instructions: Hand wash separately in cold water, do not tumble dry.</p>
guid
stringhttps://dev.divasboudoir.com/en/elvira-plus-size-set-black/cdbu8938.htm
highlights
string<ul> <li><strong>Provocative, dominating style</strong> that boldly reveals your showgirl side</li> <li><strong>Stretch faux-leather harness bra</strong> that adapts perfectly to all body shapes</li> <li><strong>Bare back with hook and eye fastenings</strong> for a perfect custom fit</li> <li><strong>Matching long skirt</strong> with black stripe detail on the buttocks for a captivating effect</li> <li><strong>Premium materials</strong>: stretch faux leather and metal chains for exceptional quality</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringThe Elvira set is provocative and domineering, but so seductive... a show girl in this tight-fitting architectural silhouette. Fast shipping.
keywords
string
title
stringElvira plus size set - Similicuir BDSM
seotitle
stringElvira plus size set
seouri
stringelvira-plus-size-set-black
specifications
string<ul> <li><strong>Color:</strong> deep black</li> <li><strong>Composition:</strong> Harness bra + matching long skirt</li> <li><strong>Accessory:</strong> Thong not included</li> </ul>
stylingtips
string<p>Enhance this ensemble with high pumps to accentuate the dominating effect, or pair it with metallic accessories to reinforce the provocative style.</p> <p>Complete your look with our <a href="https://www.divasboudoir.com/en/socks-large-size/">stockings</a> to perfect your sensual allure, our <a href="https://www.divasboudoir.com/en/loveshop/">wellness accessories</a> for a complete experience, or our <a href="https://www.divasboudoir.com/en/sexys-plus-size-dresses/">sexy dresses</a> to vary the pleasures.</p> <p>Intense black works perfectly with metallic tones to create a bold, captivating harmony.</p>
summary
stringBreathtaking set, perfect quality and incredible looks.
title
stringEnsemble Elvira
usageinstructions
string<p>For optimum effect, first adjust the hook-and-eye fasteners to your body shape. The stretch imitation leather fits comfortably around the figure, revealing your dominant side with naturalness.</p> <p>The long skirt is easy to wear, with black stripe detailing creating a striking visual effect.</p> <p>This outfit instantly transforms your look into a true show girl, perfect for revealing your sensuality with boldness and confidence.</p>
es
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavar a mano por separado sólo en agua fría</li> <li>Utilice un detergente suave para tejidos delicados</li> <li>evite el contacto con productos químicos o perfumes</li> <li>No secar en secadora para preservar la imitación de cuero y la urdimbre</li> <li>Séquela en plano, lejos de la luz directa y de fuentes de calor</li> <li>Cuélguelo para evitar arrugas y conservar la forma</li> </ul>
description
string<p>El estilo provocativo y dominante de Elvira es tan seductor... una show girl con esta silueta arquitectónica ajustada...</p> <p>Sujetador de arnés grande de piel sintética elástica con cinturilla de cadena negra en el cuello. Espalda descubierta con cierre de corchetes.<span>Falda larga a juego con detalle de cadena negra en las nalgas</span>.</p> <p>Tanga no incluido</p> <p>Composición: Sujetador arnés/falda larga: Piel sintética: 95% poliéster, 5% elastán; Cadena: 100% metal; Decoración exclusiva.</p> <p>Instrucciones de cuidado: Lavar a mano por separado en agua fría, no secar en secadora.</p>
guid
stringhttps://dev.divasboudoir.com/es/conjunto-de-talla-grande-elvira-negro/cdbu8938.htm
highlights
string<ul> <li><strong>Estilo provocativo y dominante</strong> que revela con audacia tu lado de corista</li> <li><strong>Sujetador con arnés de piel sintética elástica</strong> que se adapta perfectamente a todas las formas del cuerpo</li> <li><strong>Espalda descubierta con cierre de corchetes</strong> para un ajuste personalizado perfecto</li> <li><strong>Falda larga a juego</strong> con detalle de rayas negras en las nalgas para un efecto cautivador</li> <li><strong>Materiales de primera</strong> calidad: piel sintética elástica y cadenas metálicas para una calidad excepcional</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringEl conjunto Elvira es provocativo y dominante, pero tan seductor... una show girl en esta silueta arquitectónica y ajustada. Envío rápido.
keywords
string
title
stringConjunto Elvira talla grande - Similicuir BDSM
seotitle
stringConjunto de talla grande Elvira
seouri
stringconjunto-de-talla-grande-elvira-negro
specifications
string<ul> <li><strong>Color:</strong> negro intenso</li> <li><strong>Composición:</strong> Sujetador con arnés + falda larga a juego</li> <li><strong>Accesorio:</strong> tanga no incluido</li> </ul>
stylingtips
string<p>Sublima este conjunto con zapatos de salón altos para acentuar el efecto dominante, o combínalo con accesorios metálicos para reforzar el estilo provocativo.</p> <p>Completa tu look con nuestras <a href="https://www.divasboudoir.com/es/medias-grandes/">medias</a> para completar tu look sensual, nuestros <a href="https://www.divasboudoir.com/es/loveshop/">accesorios de bienestar</a> para una experiencia completa, o nuestros <a href="https://www.divasboudoir.com/es/sexys-vestidos-talla-grande/">vestidos sexys</a> para variar los placeres.</p> <p>El negro intenso combina a la perfección con los tonos metalizados para crear una armonía atrevida y cautivadora.</p>
summary
stringUn conjunto impresionante de calidad perfecta y aspecto increíble.
title
stringConjunto Elvira
usageinstructions
string<p>Para conseguir un efecto óptimo, ajuste primero los cierres de corchete a la forma de su cuerpo. La piel sintética elástica se ajusta cómodamente a tu figura, revelando tu lado dominante de forma natural.</p> <p>La falda larga es fácil de llevar, con detalles de rayas negras que crean un efecto visual impactante.</p> <p>Este conjunto transforma instantáneamente tu look en el de una auténtica corista, perfecto para revelar tu sensualidad con audacia y confianza.</p>
fr
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavage &agrave; la main s&eacute;par&eacute;ment &agrave; l'eau froide exclusivement</li> <li>Utiliser une lessive douce sp&eacute;ciale textiles d&eacute;licats</li> <li>&Eacute;viter tout contact avec des produits chimiques ou parfums</li> <li>Pas de s&egrave;che-linge pour pr&eacute;server le similicuir et les cha&icirc;nes</li> <li>S&eacute;chage &agrave; plat, &agrave; l'abri de la lumi&egrave;re directe et des sources de chaleur</li> <li>Ranger suspendu pour &eacute;viter les plis et pr&eacute;server la forme</li> </ul>
description
string<p>L'ensemble Elvira incarne la s&eacute;duction provocatrice avec son <strong>style dominateur</strong> qui <strong>sublime les courbes g&eacute;n&eacute;reuses</strong> avec une audace assum&eacute;e. Cette cr&eacute;ation exceptionnelle transforme chaque femme en v&eacute;ritable <strong>show girl</strong> gr&acirc;ce &agrave; son <strong>soutien-gorge harnais en similicuir extensible</strong> qui <strong>&eacute;pouse parfaitement toutes les morphologies</strong>.</p> <p>Le&nbsp;<strong>dos nu</strong> avec <strong>fermetures &agrave; crochets et &agrave; &oelig;illets</strong> assure un <strong>ajustement personnalis&eacute; parfait</strong> et un <strong>maintien optimal</strong>. La <strong>jupe longue assortie</strong> r&eacute;v&egrave;le d&eacute;licatement la silhouette avec ses <strong>d&eacute;tails de bandes noires sur les fesses</strong> qui cr&eacute;ent un effet visuel captivant.</p> <p>Les&nbsp;<strong>mati&egrave;res premium</strong> combinent <strong>similicuir extensible</strong> (95% polyester, 5% &eacute;lasthanne) et <strong>cha&icirc;nes 100% m&eacute;tal</strong> pour une qualit&eacute; exceptionnelle.</p> <p>&nbsp;Cette <strong>coupe ajustable</strong> <strong>s'adapte &agrave; chaque silhouette</strong> avec naturel, r&eacute;v&eacute;lant votre allure dominatrice avec une sensualit&eacute; moderne et irr&eacute;sistible.</p>
guid
stringhttps://dev.divasboudoir.com/fr/ensemble-grande-taille-elvira-noir-style-dominatrice-harnais/cdbu8938.htm
highlights
string<ul> <li><strong>Style provocateur dominateur</strong> qui r&eacute;v&egrave;le votre c&ocirc;t&eacute; show girl avec audace</li> <li><strong>Soutien-gorge harnais en similicuir extensible</strong> qui s'adapte parfaitement &agrave; toutes les morphologies</li> <li><strong>Dos nu avec fermetures crochets et &oelig;illets</strong> pour un ajustement personnalis&eacute; parfait</li> <li><strong>Jupe longue assortie</strong> avec d&eacute;tails de bandes noires sur les fesses pour un effet captivant</li> <li><strong>Mati&egrave;res premium</strong> : similicuir extensible et cha&icirc;nes m&eacute;talliques pour une qualit&eacute; exceptionnelle</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringEnsemble grande taille Elvira noir style dominatrice avec soutien-gorge harnais similicuir et jupe longue. Allure show girl provocatrice chez Diva's Boudoir.
keywords
string
title
stringEnsemble grande taille Elvira noir style dominatrice | Diva's Boudoir
seotitle
stringEnsemble grande taille Elvira noir style dominatrice harnais
seouri
stringensemble-grande-taille-elvira-noir-style-dominatrice-harnais
specifications
string<ul> <li><strong>Couleur :</strong> noir intense</li> <li><strong>Composition :</strong> Soutien-gorge harnais + Jupe longue assortie</li> <li><strong>Accessoire :</strong> String non inclus</li> </ul>
stylingtips
string<p>Sublimez cet ensemble avec des escarpins hauts pour accentuer l'effet dominateur, ou associez-le &agrave; des accessoires m&eacute;talliques pour renforcer le style provocateur.</p> <p>Compl&eacute;tez votre look avec nos&nbsp;<a href="https://www.divasboudoir.com/fr/bas-grande-taille/">bas</a> pour parfaire votre allure sensuelle, nos <a href="https://www.divasboudoir.com/fr/loveshop/">accessoires bien-&ecirc;tre</a> pour une exp&eacute;rience compl&egrave;te, ou nos <a href="https://www.divasboudoir.com/fr/robes-sexys-grande-taille/">robes sexys</a> pour varier les plaisirs.</p> <p>Le noir intense s'accorde parfaitement avec des tons m&eacute;talliques pour cr&eacute;er une harmonie audacieuse et captivante.</p>
summary
string<p>D&eacute;couvrez l'ensemble Elvira au <strong>style provocateur</strong> qui <strong>sublime vos courbes g&eacute;n&eacute;reuses</strong> avec son <strong>allure dominatrice tellement s&eacute;duisante</strong>.</p> <p>Cette cr&eacute;ation audacieuse r&eacute;v&egrave;le votre c&ocirc;t&eacute; show girl avec un charme irr&eacute;sistible et une sensualit&eacute; assum&eacute;e.</p>
title
stringEnsemble Elvira : Style Dominatrice et Séduction Provocatrice
usageinstructions
string<p>Pour un effet optimal, ajustez d'abord les fermetures &agrave; crochets et &oelig;illets selon votre morphologie. Le similicuir extensible s'adapte confortablement &agrave; la silhouette, r&eacute;v&eacute;lant votre c&ocirc;t&eacute; dominateur avec naturel.</p> <p>La jupe longue se porte avec aisance, les d&eacute;tails de bandes noires cr&eacute;ant un effet visuel saisissant.</p> <p>Cette tenue transforme instantan&eacute;ment votre allure en v&eacute;ritable show girl, parfaite pour r&eacute;v&eacute;ler votre sensualit&eacute; avec audace et confiance.</p>
it
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavare a mano separatamente solo in acqua fredda</li> <li>Utilizzare un detergente delicato per i tessuti delicati</li> <li>evitare il contatto con sostanze chimiche o profumi</li> <li>Non asciugare in asciugatrice per preservare l'imitazione della pelle e le orditure</li> <li>Asciugare in piano, lontano dalla luce diretta e da fonti di calore</li> <li>Appendere per evitare pieghe e preservare la forma</li> </ul>
description
string<p>Lo stile provocante e dominante di Elvira è così seducente... una show girl con questa silhouette architettonica aderente...</p> <p>Ampio reggiseno a bretella in ecopelle elasticizzata con cintura a catena nera sul collo. Schiena nuda con chiusura a gancio e occhiello.<span>Gonna lunga abbinata con dettaglio a catena nera sui glutei</span>.</p> <p>Perizoma non incluso</p> <p>Composizione: Reggiseno a bretella/gonna a slip: Ecopelle: 95% poliestere, 5% elastan; Catena: 100% metallo; Decorazione esclusiva.</p> <p>Istruzioni per la cura: lavare a mano separatamente in acqua fredda, non asciugare in asciugatrice.</p>
guid
stringhttps://dev.divasboudoir.com/it/set-elvira-taglia-grande-nero/cdbu8938.htm
highlights
string<ul> <li><strong>Stile provocante e dominante</strong> che svela il vostro lato da showgirl</li> <li><strong>Reggiseno a bretella in ecopelle elasticizzata</strong> che si adatta perfettamente a tutte le forme del corpo</li> <li><strong>Schiena nuda con chiusura a gancio e occhiello</strong> per una perfetta vestibilità personalizzata</li> <li><strong>Gonna lunga abbinata</strong> con dettaglio a righe nere sui glutei per un effetto accattivante</li> <li><strong>Materiali pregiati</strong>: ecopelle elasticizzata e catene metalliche per una qualità eccezionale</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringIl set Elvira è provocante e dominante, ma così seducente... una show girl in questa silhouette architettonica e aderente. Spedizione rapida.
keywords
string
title
stringSet Elvira taglia grande - Similicuir BDSM
seotitle
stringSet Elvira taglia grande
seouri
stringset-elvira-taglia-grande-nero
specifications
string<ul> <li><strong>Colore:</strong> nero profondo</li> <li><strong>Composizione:</strong> reggiseno + gonna lunga coordinata</li> <li><strong>Accessorio:</strong> perizoma non incluso</li> </ul>
stylingtips
string<p>Sublimate questo ensemble con decolté alte per accentuare l'effetto dominante, oppure abbinatelo ad accessori metallici per rafforzare lo stile provocante.</p> <p>Completate il vostro look con le nostre <a href="https://www.divasboudoir.com/it/calze-di-grandi-dimensioni/">calze</a> per completare il vostro look sensuale, i nostri <a href="https://www.divasboudoir.com/it/negozio-damore/">accessori wellness</a> per un'esperienza completa o i nostri <a href="https://www.divasboudoir.com/it/abiti-sexys-taglia-grande/">abiti sexy</a> per variare i piaceri.</p> <p>Il nero intenso funziona perfettamente con i toni metallici per creare un'armonia audace e accattivante.</p>
summary
stringUn ensemble mozzafiato dalla qualità perfetta e dall'aspetto incredibile.
title
stringEnsemble Elvira
usageinstructions
string<p>Per un effetto ottimale, regolate prima le chiusure con gancio e occhiello in base alla forma del vostro corpo. L'ecopelle elasticizzata si adatta comodamente alla vostra figura, rivelando il vostro lato dominante in modo naturale.</p> <p>La gonna lunga è facile da indossare, con dettagli a righe nere che creano un effetto visivo di grande impatto.</p> <p>Questo completo trasforma immediatamente il vostro look in quello di una vera showgirl, perfetto per rivelare la vostra sensualità con audacia e sicurezza.</p>
nl
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Apart met de hand wassen in koud water</li> <li>Gebruik een mild wasmiddel voor delicaat textiel</li> <li>vermijd contact met chemicaliën of parfums</li> <li>Niet in de droogtrommel drogen om imitatieleer en kromtrekken te behouden</li> <li>Plat drogen, uit de buurt van direct licht en warmtebronnen</li> <li>Ophangen om kreuken te voorkomen en de vorm te behouden</li> </ul>
description
string<p>Elvira's provocerende en dominante stijl is zo verleidelijk... een show girl met dit strakke architectonische silhouet...</p> <p>Grote, stretch, kunstlederen harnasbeha met zwarte ketting in de nek. Blote rug met haak- en oogsluitingen.<span>Bijpassende lange rok met zwart ketting detail op de billen</span>.</p> <p>String niet inbegrepen</p> <p>Samenstelling: Harnas-bh/slip rok: Kunstleer: 95% polyester, 5% elastaan; Ketting: 100% metaal; Decoratie exclusief.</p> <p>Onderhoudsinstructies: apart met de hand wassen in koud water, niet in de droger.</p>
guid
stringhttps://dev.divasboudoir.com/nl/elvira-set-grote-maten-zwart/cdbu8938.htm
highlights
string<ul> <li><strong>Provocerende, dominante stijl</strong> die je showgirl kant laat zien</li> <li><strong>Stretch harnasbeha van imitatieleer</strong> die zich perfect aanpast aan alle lichaamsvormen</li> <li><strong>Halternek met haak- en oogsluitingen</strong> voor een perfecte pasvorm op maat</li> <li><strong>Bijpassende lange rok</strong> met zwart streepdetail op de billen voor een betoverend effect</li> <li><strong>Hoogwaardige materialen</strong>: stretch imitatieleer en metalen kettingen voor uitzonderlijke kwaliteit</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringDe Elvira set is uitdagend en dominant, maar zo verleidelijk... een showgirl in dit architectonische, nauwsluitende silhouet. Snelle verzending.
keywords
string
title
stringElvira grote maat set - Similicuir BDSM
seotitle
stringElvira set grote maten
seouri
stringelvira-set-grote-maten-zwart
specifications
string<ul> <li><strong>Kleur:</strong> diepzwart</li> <li><strong>Samenstelling:</strong> Harnas bh + bijpassende lange rok</li> <li><strong>Accessoire:</strong> G-string niet inbegrepen</li> </ul>
stylingtips
string<p>Sublimeer dit ensemble met hoge pumps om het dominante effect te accentueren, of combineer het met metallic accessoires om de provocerende stijl te versterken.</p> <p>Maak je look compleet met onze <a href="https://www.divasboudoir.com/nl/grote-maat-kousen/">kousen</a> om je sensuele look af te maken, onze <a href="https://www.divasboudoir.com/nl/loveshop/">wellness-accessoires</a> voor een complete ervaring, of onze <a href="https://www.divasboudoir.com/nl/sexys-jurken-grote-maat/">sexy jurkjes</a> om het plezier af te wisselen.</p> <p>Intens zwart werkt perfect met metallic tinten om een gedurfde, fascinerende harmonie te creëren.</p>
summary
stringEen adembenemend ensemble van perfecte kwaliteit en ongelooflijke looks.
title
stringEnsemble Elvira
usageinstructions
string<p>Voor een optimaal effect pas je eerst de haak- en oogsluitingen aan je lichaamsvorm aan. Het stretch imitatieleer zit comfortabel om je figuur en laat je dominante kant op een natuurlijke manier zien.</p> <p>De lange rok is gemakkelijk te dragen en de zwarte streepdetails zorgen voor een opvallend visueel effect.</p> <p>Deze outfit verandert je look direct in een echte showgirl, perfect om je sensualiteit met durf en zelfvertrouwen te onthullen.</p>
pt
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavar à mão separadamente apenas em água fria</li> <li>Utilizar um detergente suave para têxteis delicados</li> <li>evitar o contacto com produtos químicos ou perfumes</li> <li>Não secar na máquina de secar roupa para preservar a imitação de pele e as teias</li> <li>Secar em local plano, longe da luz direta e de fontes de calor</li> <li>Pendurar para evitar vincos e preservar a forma</li> </ul>
description
string<p>O estilo provocador e dominador de Elvira é tão sedutor... uma rapariga do espetáculo com esta silhueta arquitetónica justa...</p> <p>Sutiã de arnês grande, elástico, em pele sintética, com cintura de corrente preta no pescoço. Costas nuas com fechos de gancho e olho.<span>Saia comprida a condizer com pormenor de corrente preta nas nádegas</span>.</p> <p>Tanga não incluída</p> <p>Composição: Soutien-arnês/saia comprida: Pele sintética: 95% poliéster, 5% elastano; Corrente: 100% metal; Decoração exclusiva.</p> <p>Conselhos de manutenção: Lavar à mão separadamente em água fria, não secar na máquina.</p>
guid
stringhttps://dev.divasboudoir.com/pt/conjunto-elvira-plus-size-preto/cdbu8938.htm
highlights
string<ul> <li><strong>Estilo provocador e dominador</strong> que revela corajosamente o seu lado de rapariga de programa</li> <li><strong>Soutien elástico em pele sintética</strong> que se adapta perfeitamente a todas as formas do corpo</li> <li><strong>Halterneck com fechos de gancho e olho</strong> para um ajuste perfeito e personalizado</li> <li><strong>Saia comprida a condizer</strong> com pormenor de riscas pretas nas nádegas para um efeito cativante</li> <li><strong>Materiais de primeira qualidade</strong>: pele sintética elástica e correntes metálicas para uma qualidade excecional</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringO conjunto Elvira é provocante e dominador, mas tão sedutor... uma rapariga do espetáculo nesta silhueta arquitetónica e ajustada à forma. Envio rápido.
keywords
string
title
stringConjunto Elvira plus size - Similicuir BDSM
seotitle
stringConjunto Elvira plus size
seouri
stringconjunto-elvira-plus-size-preto
specifications
string<ul> <li><strong>Cor:</strong> preto profundo</li> <li><strong>Composição:</strong> Soutien arnês + saia comprida a condizer</li> <li><strong>Acessório:</strong> fio dental não incluído</li> </ul>
stylingtips
string<p>Sublimar este conjunto com sapatos altos para acentuar o efeito dominante, ou combiná-lo com acessórios metálicos para reforçar o estilo provocador.</p> <p>Complete o seu look com as nossas <a href="https://www.divasboudoir.com/pt/meias-de-tamanho-grande/">meias</a> para completar o seu look sensual, os nossos <a href="https://www.divasboudoir.com/pt/loja-de-amor/">acessórios de bem-estar</a> para uma experiência completa ou os nossos <a href="https://www.divasboudoir.com/pt/vestidos-sexys-plus-size/">vestidos sensuais</a> para variar os prazeres.</p> <p>O preto intenso combina perfeitamente com os tons metálicos para criar uma harmonia ousada e cativante.</p>
summary
stringUm conjunto de cortar a respiração com uma qualidade perfeita e uma aparência incrível.
title
stringConjunto Elvira
usageinstructions
string<p>Para um efeito ótimo, ajuste primeiro os fechos de gancho e olho à forma do seu corpo. A pele sintética elástica adapta-se confortavelmente à sua figura, revelando o seu lado dominante de uma forma natural.</p> <p>A saia comprida é fácil de usar, com pormenores de riscas pretas que criam um efeito visual impressionante.</p> <p>Este conjunto transforma instantaneamente o seu look numa verdadeira showgirl, perfeito para revelar a sua sensualidade com ousadia e confiança.</p>
fetishboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
latexboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
legsboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
lustboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
smboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Elvira-Set mit provokativem und dominantem Stil, aber so verführerisch... Showgirl mit dieser eng anliegenden architektonischen Silhouette...</p> <p>BH aus Kunstleder, große Größe, dehnbar, mit schwarzem Kettenband am Hals. Rückenfrei, mit Haken- und Ösenverschlüssen.<span>Passender langer Rock mit schwarzen Kettendetails am Gesäß.</span></p> <p>String nicht im Lieferumfang enthalten.</p> <p>Zusammensetzung: Harnisch-BH/Slip-Jupe: Kunstleder: 95 % Polyester, 5 % Elasthan; Kette: 100 % Metall; Exklusivität der Dekoration.</p> <p>Pflegehinweis: Separat von Hand in kaltem Wasser waschen, nicht im Trockner trocknen.</p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringDas Elvira-Set mit provokativem Stil und Dominanz, aber so verführerisch... Showgirl mit dieser eng anliegenden architektonischen Silhouette. Schneller Versand.
keywords
string
title
stringElvira Set in Übergröße - BDSM Similicuir
seotitle
stringSet in Übergröße Elvira
seouri
stringset-in-ubergrosse-elvira-schwarz
specifications
string
stylingtips
string
summary
stringAtemberaubendes Ensemble in perfekter Qualität und mit unglaublichem Aussehen.
title
stringElvira-Set aus Kunstleder
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Το προκλητικό και κυρίαρχο στυλ της Elvira είναι τόσο σαγηνευτικό... ένα κορίτσι του θεάματος με αυτή τη στενή αρχιτεκτονική σιλουέτα...</p> <p>Μεγάλο, ελαστικό σουτιέν με ιμάντες από ψεύτικο δέρμα με μαύρη αλυσίδα στη μέση στο λαιμό. Γυμνή πλάτη με κούμπωμα με γάντζο και μάτι.<span>Ασορτί μακριά φούστα με λεπτομέρεια μαύρης αλυσίδας στους γλουτούς</span>.</p> <p>Το στρινγκ δεν περιλαμβάνεται</p> <p>Σύνθεση: Στηθόδεσμος καλωδίωσης/φούστα: Ψεύτικο δέρμα: 95% πολυεστέρας, 5% ελαστάν- αλυσίδα: 100% μέταλλο- αποκλειστική διακόσμηση.</p> <p>Οδηγίες φροντίδας: Πλένετε στο χέρι ξεχωριστά σε κρύο νερό, μην στεγνώνετε στο στεγνωτήριο.</p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringΤο σετ Elvira είναι προκλητικό και κυρίαρχο, αλλά τόσο σαγηνευτικό... ένα κορίτσι της επίδειξης σε αυτή την αρχιτεκτονική, εφαρμοστή σιλουέτα. Γρήγορη αποστολή.
keywords
string
title
stringElvira plus size σετ - Similicuir BDSM
seotitle
stringElvira plus size σετ
seouri
stringelvira-plus-size-set-mayro
specifications
string
stylingtips
string
summary
stringΈνα εκπληκτικό σύνολο τέλειας ποιότητας και απίστευτης εμφάνισης.
title
stringΣετ Elvira σε απομίμηση δέρματος
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Elvira set with a provocative, dominating style that's so seductive... show girl with this tight architectural silhouette...</p> <p>Plus-size, stretch, faux-leather harness bra with black chain waistband at neck. Bare back with hook and eye closures.<span>Matching long skirt with black chain detail on buttocks.</span></p> <p>G-string not included.</p> <p>Composition: Harness bra/slip skirt: Faux leather: 95% polyester, 5% elastane; Chain: 100% metal; Decoration exclusive</p> <p>Care instructions: Hand wash separately in cold water, do not tumble dry.</p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringThe Elvira set is provocative and domineering, but so seductive... a show girl in this tight-fitting architectural silhouette. Fast shipping.
keywords
string
title
stringElvira plus size set - Similicuir BDSM
seotitle
stringElvira plus size set
seouri
stringelvira-plus-size-set-black
specifications
string
stylingtips
string
summary
stringBreathtaking set, perfect quality and incredible looks.
title
stringElvira set in imitation leather
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>El estilo provocativo y dominante de Elvira es tan seductor... una show girl con esta silueta arquitectónica ajustada...</p> <p>Sujetador de arnés grande de piel sintética elástica con cinturilla de cadena negra en el cuello. Espalda descubierta con cierre de corchetes.<span>Falda larga a juego con detalle de cadena negra en las nalgas</span>.</p> <p>Tanga no incluido</p> <p>Composición: Sujetador arnés/falda larga: Piel sintética: 95% poliéster, 5% elastán; Cadena: 100% metal; Decoración exclusiva.</p> <p>Instrucciones de cuidado: Lavar a mano por separado en agua fría, no secar en secadora.</p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringEl conjunto Elvira es provocativo y dominante, pero tan seductor... una show girl en esta silueta arquitectónica y ajustada. Envío rápido.
keywords
string
title
stringConjunto Elvira talla grande - Similicuir BDSM
seotitle
stringConjunto de talla grande Elvira
seouri
stringconjunto-de-talla-grande-elvira-negro
specifications
string
stylingtips
string
summary
stringUn conjunto impresionante de calidad perfecta y aspecto increíble.
title
stringConjunto Elvira en polipiel
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Ensemble Elvira au style provocateur et pour une allure dominatrice mais tellement s&eacute;duisante... devenez une vraie show girl le temps d'une soir&eacute;e ou d'une nuit.</p> <p>Soutien-gorge harnais en simili cuir extensible.<br /><br />Dos nu, avec fermetures &agrave; crochets et &agrave; &oelig;illets.<br /><br />J<span>upe longue assortie avec d&eacute;tails de bandes noires sur les fesses.</span></p> <p>String non inclus&nbsp;</p> <p>Composition : Soutien-gorge harnais/Jupe slip : Simili cuir : 95 % polyester, 5 % &eacute;lasthanne ; Cha&icirc;ne : 100 % m&eacute;tal ; Exclusivit&eacute; D&eacute;coration&nbsp;</p> <p>Conseil d'entretien : Laver &agrave; la main s&eacute;par&eacute;ment &agrave; l'eau froide, pas de s&egrave;che linge.</p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringL'ensemble Elvira au style provocateur et dominatrice mais tellement séduisante... show girl avec cette silhouette architecturale moulante. Envoi Rapide.
keywords
string
title
stringEnsemble grande taille Elvira - Similicuir BDSM
seotitle
stringTenue BDSM Elvira
seouri
stringtenue-bdsm-elvira-noir
specifications
string
stylingtips
string
summary
stringEnsemble &agrave; couper le souffle, de qualit&eacute; parfaite et au look incroyable quelque soit votre morphologie.
title
stringEnsemble Elvira en similicuir
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Lo stile provocante e dominante di Elvira è così seducente... mostratevi con questa silhouette architettonica aderente...</p> <p>Ampio reggiseno a bretella in ecopelle elasticizzata con cintura a catena nera sul collo. Schiena nuda con chiusura a gancio e occhiello.<span>Gonna lunga abbinata con dettaglio a catena nera sui glutei</span>.</p> <p>Perizoma non incluso</p> <p>Composizione: Reggiseno a bretella/gonna a slip: Ecopelle: 95% poliestere, 5% elastan; Catena: 100% metallo; Decorazione esclusiva.</p> <p>Istruzioni per la cura: lavare a mano separatamente in acqua fredda, non asciugare in asciugatrice.</p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringIl set Elvira è provocante e dominante, ma così seducente... una show girl in questa silhouette architettonica e aderente. Spedizione rapida.
keywords
string
title
stringSet Elvira taglia grande - Similicuir BDSM
seotitle
stringSet Elvira taglia grande
seouri
stringset-elvira-taglia-grande-nero
specifications
string
stylingtips
string
summary
stringUn ensemble mozzafiato dalla qualità perfetta e dall'aspetto incredibile.
title
stringSet Elvira in similpelle
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Elvira's provocerende en dominante stijl is zo verleidelijk... een show girl met dit strakke architectonische silhouet...</p> <p>Grote, stretch, kunstlederen harnasbeha met zwarte ketting in de nek. Blote rug met haak- en oogsluitingen.<span>Bijpassende lange rok met zwart ketting detail op de billen</span>.</p> <p>String niet inbegrepen</p> <p>Samenstelling: Harnas-bh/slip rok: Kunstleer: 95% polyester, 5% elastaan; Ketting: 100% metaal; Decoratie exclusief.</p> <p>Onderhoudsinstructies: apart met de hand wassen in koud water, niet in de droger.</p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringDe Elvira set is uitdagend en dominant, maar zo verleidelijk... een showgirl in dit architectonische, nauwsluitende silhouet. Snelle verzending.
keywords
string
title
stringElvira grote maat set - Similicuir BDSM
seotitle
stringElvira set grote maten
seouri
stringelvira-set-grote-maten-zwart
specifications
string
stylingtips
string
summary
stringEen adembenemend ensemble van perfecte kwaliteit en ongelooflijke looks.
title
stringElvira set in imitatieleer
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>O estilo provocador e dominador de Elvira é tão sedutor... uma rapariga do espetáculo com esta silhueta arquitetónica justa...</p> <p>Sutiã de arnês grande, elástico, em pele sintética, com cintura de corrente preta no pescoço. Costas nuas com fechos de gancho e olho.<span>Saia comprida a condizer com pormenor de corrente preta nas nádegas</span>.</p> <p>Tanga não incluída</p> <p>Composição: Soutien-arnês/saia comprida: Pele sintética: 95% poliéster, 5% elastano; Corrente: 100% metal; Decoração exclusiva.</p> <p>Conselhos de manutenção: Lavar à mão separadamente em água fria, não secar na máquina.</p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringO conjunto Elvira é provocante e dominador, mas tão sedutor... uma rapariga do espetáculo nesta silhueta arquitetónica e ajustada à forma. Envio rápido.
keywords
string
title
stringConjunto Elvira plus size - Similicuir BDSM
seotitle
stringConjunto Elvira plus size
seouri
stringconjunto-elvira-plus-size-preto
specifications
string
stylingtips
string
summary
stringUm conjunto de cortar a respiração com uma qualidade perfeita e uma aparência incrível.
title
stringConjunto Elvira em imitação de pele
usageinstructions
string
name
stringDG13198XBLK
netweight
string
nextshipment
stringtomorrow
ordered
number1
orderidx
number0
origin
string
originalsize
string
packaging
string
productshipment
string1to2days
productuid
string27E48C45-EA2A-487A-83CB50B8128F81EF
promountil
string
rating
stringnone
recorduid
string27E48C45-EA2A-487A-83CB50B8128F81EF
reference
stringCDBU8938
related
string
reserved
string
returned
number0
returnsallowed
number1
section
stringcabaret
shipment
string1to2days
showbrand
number0
sizeinfos
Query
Template: /system/api/product/sizes.cfc:20
Execution Time: 1.53 ms
Record Count: 4
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,'1812,330,329,331,1809,1810,1811') > 0
and product_variations.productuid = '27E48C45-EA2A-487A-83CB50B8128F81EF'
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
11812XLintlsizeblackXLXL-19999990wpluslingerieXLXL42-4412-1416-1844-4644-4642-4448-5044-4642-4497-10279-84101-107
23301Xintlsizeblack1X1X-19999990wpluslingerie1X1X44-4614-1618-2046-4846-4844-4650-5246-4844-46102-11291-97107-119
33292Xintlsizeblack2X2X-19999990wpluslingerie2X2X48-5018-2022-2450-5250-5248-5054-5650-5248-50112-12297-102119-129
43313Xintlsizeblack3X3X-19999990wpluslingerie3X3X52-5422-2426-2854-5654-5652-5458-6054-5652-54122-132102-107129-145
sizeranges
stringplus,standard
sizes
string1812,330,329,331,1809,1810,1811
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: 6.48 ms
Record Count: 4
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select * from (
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '27E48C45-EA2A-487A-83CB50B8128F81EF'
and product_variations.isactive = 1
and product_sizes.id_size = 1812
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 = '27E48C45-EA2A-487A-83CB50B8128F81EF'
and product_variations.isactive = 1
and product_sizes.id_size = 330
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 = '27E48C45-EA2A-487A-83CB50B8128F81EF'
and product_variations.isactive = 1
and product_sizes.id_size = 329
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 = '27E48C45-EA2A-487A-83CB50B8128F81EF'
and product_variations.isactive = 1
and product_sizes.id_size = 331
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 = '27E48C45-EA2A-487A-83CB50B8128F81EF'
and product_variations.isactive = 1
and product_sizes.id_size = 1809
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 = '27E48C45-EA2A-487A-83CB50B8128F81EF'
and product_variations.isactive = 1
and product_sizes.id_size = 1810
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 = '27E48C45-EA2A-487A-83CB50B8128F81EF'
and product_variations.isactive = 1
and product_sizes.id_size = 1811
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
127E48C45-EA2A-487A-83CB50B8128F81EF2B383903-EBEB-487B-BBAF6939860242AB1812black#000000XLXL42-4412-1416-1844-4644-4642-4448-5044-4642-44wlingerie XLintlsize83.29170STOCK01000-10000-10all
227E48C45-EA2A-487A-83CB50B8128F81EF5A481D9B-6866-4D17-B15EE624053BBCB1330black#0000001X1X44-4614-1618-2046-4846-4844-4650-5246-4844-46wlingerie 1Xintlsize83.29170STOCK01000-11100-10all
327E48C45-EA2A-487A-83CB50B8128F81EF3E862733-2776-41AF-8C60A97ECF86B6F9329black#0000002X2X48-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie 2Xintlsize83.29170STOCK01000-1010013198X888368344291-10all
427E48C45-EA2A-487A-83CB50B8128F81EFE40CA50F-C940-4180-BE72E2C7135D4A5C331black#0000003X3X52-5422-2426-2854-5654-5652-5458-6054-5652-54wlingerie 3Xintlsize83.29170STOCK01000-1010013198X888368344307-10all
subcategory
stringall
supplier
number-1
supplierreference
stringDG13198XBLK
tags
string
themes
stringdark,luxe
totalvariations
string
type
stringdefault
unitprice
number83.2917
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 11.1 ms
Record Count: 4
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 = '27E48C45-EA2A-487A-83CB50B8128F81EF' 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 = '27E48C45-EA2A-487A-83CB50B8128F81EF' 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 = '27E48C45-EA2A-487A-83CB50B8128F81EF' 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 = '27E48C45-EA2A-487A-83CB50B8128F81EF' 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 = '27E48C45-EA2A-487A-83CB50B8128F81EF' 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 = '27E48C45-EA2A-487A-83CB50B8128F81EF' 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 = '27E48C45-EA2A-487A-83CB50B8128F81EF'
and product_variations.isactive = 1
and product_sizes.id_size = 1812
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 = '27E48C45-EA2A-487A-83CB50B8128F81EF' 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 = '27E48C45-EA2A-487A-83CB50B8128F81EF' 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 = '27E48C45-EA2A-487A-83CB50B8128F81EF' 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 = '27E48C45-EA2A-487A-83CB50B8128F81EF' 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 = '27E48C45-EA2A-487A-83CB50B8128F81EF' 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 = '27E48C45-EA2A-487A-83CB50B8128F81EF' 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 = '27E48C45-EA2A-487A-83CB50B8128F81EF'
and product_variations.isactive = 1
and product_sizes.id_size = 330
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 = '27E48C45-EA2A-487A-83CB50B8128F81EF' 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 = '27E48C45-EA2A-487A-83CB50B8128F81EF' 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 = '27E48C45-EA2A-487A-83CB50B8128F81EF' 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 = '27E48C45-EA2A-487A-83CB50B8128F81EF' 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 = '27E48C45-EA2A-487A-83CB50B8128F81EF' 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 = '27E48C45-EA2A-487A-83CB50B8128F81EF' 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 = '27E48C45-EA2A-487A-83CB50B8128F81EF'
and product_variations.isactive = 1
and product_sizes.id_size = 329
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 = '27E48C45-EA2A-487A-83CB50B8128F81EF' 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 = '27E48C45-EA2A-487A-83CB50B8128F81EF' 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 = '27E48C45-EA2A-487A-83CB50B8128F81EF' 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 = '27E48C45-EA2A-487A-83CB50B8128F81EF' 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 = '27E48C45-EA2A-487A-83CB50B8128F81EF' 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 = '27E48C45-EA2A-487A-83CB50B8128F81EF' 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 = '27E48C45-EA2A-487A-83CB50B8128F81EF'
and product_variations.isactive = 1
and product_sizes.id_size = 331
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 = '27E48C45-EA2A-487A-83CB50B8128F81EF' 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 = '27E48C45-EA2A-487A-83CB50B8128F81EF' 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 = '27E48C45-EA2A-487A-83CB50B8128F81EF' 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 = '27E48C45-EA2A-487A-83CB50B8128F81EF' 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 = '27E48C45-EA2A-487A-83CB50B8128F81EF' 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 = '27E48C45-EA2A-487A-83CB50B8128F81EF' 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 = '27E48C45-EA2A-487A-83CB50B8128F81EF'
and product_variations.isactive = 1
and product_sizes.id_size = 1809
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 = '27E48C45-EA2A-487A-83CB50B8128F81EF' 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 = '27E48C45-EA2A-487A-83CB50B8128F81EF' 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 = '27E48C45-EA2A-487A-83CB50B8128F81EF' 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 = '27E48C45-EA2A-487A-83CB50B8128F81EF' 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 = '27E48C45-EA2A-487A-83CB50B8128F81EF' 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 = '27E48C45-EA2A-487A-83CB50B8128F81EF' 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 = '27E48C45-EA2A-487A-83CB50B8128F81EF'
and product_variations.isactive = 1
and product_sizes.id_size = 1810
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 = '27E48C45-EA2A-487A-83CB50B8128F81EF' 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 = '27E48C45-EA2A-487A-83CB50B8128F81EF' 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 = '27E48C45-EA2A-487A-83CB50B8128F81EF' 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 = '27E48C45-EA2A-487A-83CB50B8128F81EF' 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 = '27E48C45-EA2A-487A-83CB50B8128F81EF' 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 = '27E48C45-EA2A-487A-83CB50B8128F81EF' 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 = '27E48C45-EA2A-487A-83CB50B8128F81EF'
and product_variations.isactive = 1
and product_sizes.id_size = 1811
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
12B383903-EBEB-487B-BBAF6939860242AB1812black#000000XLXL42-4412-1416-1844-4644-4642-4448-5044-4642-44wlingerie XLintlsize83.29170STOCK01000-10000-10-10-10083.2917all
25A481D9B-6866-4D17-B15EE624053BBCB1330black#0000001X1X44-4614-1618-2046-4846-4844-4650-5246-4844-46wlingerie 1Xintlsize83.29170STOCK01000-11100-10-10-10083.2917all
33E862733-2776-41AF-8C60A97ECF86B6F9329black#0000002X2X48-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie 2Xintlsize83.29170STOCK01000-1010013198X888368344291-10-10-10083.2917all
4E40CA50F-C940-4180-BE72E2C7135D4A5C331black#0000003X3X52-5422-2426-2854-5654-5652-5458-6054-5652-54wlingerie 3Xintlsize83.29170STOCK01000-1010013198X888368344307-10-10-10083.2917all
vatrate
number20
warehouse
string