Mi cesta

❌
Total de artículos
Ver cesta
Menú
Ver tallas
Vestido Elsa
Doble clic para ampliar
SKU: SFBA1493
Vestido Elsa
Stock:

¿Lista para entregarte por completo?

Da rienda suelta a la sumisa que llevas dentro, sea cual sea tu talla.

Talla:

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

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

Vestido camisero talla grande

Descripción del producto

Señoras, ¿buscan realzar sus curvas? Tenemos justo lo que necesitas

Te enamorarás de este vestido Elsa súper sexy y ceñido. Todo en negro mate brillante, está diseñado para realzar tus generosas curvas con estilo y comodidad.

La parte superior se abre fácilmente sobre el busto gracias a discretas cremalleras. Práctico, ¿verdad?

También tiene una cremallera en la espalda para que puedas ponértelo sin problemas. El cuello alto con anilla le da un toque sexy.

¿Quieres darle un toque más picante? Los brazaletes de sujeción incluidos se sujetan fácilmente a los lados. Y si prefieres un look más discreto, ¡no te preocupes! Los tirantes del pecho y la cintura son extraíbles.

Cómodo, ajustable y terriblemente sexy, este conjunto se adapta a todas las formas del cuerpo.

Detalles técnicos

Tallas disponibles

Disponible de XL+ a 3XL

Color disponible

Negro

Composición

Poliamida 90 %
Elastano 10 %

Otras especificaciones técnicas

Material Wetlook

Guía de tallas

Comprueba cuál es tu talla

Internacional
  • Pecho
  • Talla
  • Caderas
XL+
  • 113-118
  • 96-102
  • 117-121
2XL+
  • 125-130
  • 109-114
  • 127-132
3XL+
  • 137-142
  • 122-128
  • 138-144
L
  • 103-106
  • 86-90
  • 109-112
XL
  • 107-112
  • 91-95
  • 113-116
2XL
  • 119-124
  • 103-108
  • 122-126
3XL
  • 131-136
  • 115-121
  • 133-138
To Top
Ver cesta
Artículos
Total de artículos
Struct
Entries: 108
actions
Array
available
number-1
brand
stringcottelli
brandcode
stringcwhd
branding
stringdivasboudoir,smboudoir
brandmedias
string{"default":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"editorial":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"logo":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""}}
brandmetas
Struct
de
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
el
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
en
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
es
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
fr
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
it
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
nl
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
pt
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
brandname
stringCottelli
breasts
stringna
careinstructions
string
categories
stringdivasboudoir.cabaret.dresses.all,divasboudoir.lingerie.sexylingerie.babydoll
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.694 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 = '65EFFF76-2E98-4769-9C9A883411D50AB7'
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
string10
free
string
leather
string
lycra
string
metal
string
nylon
string
polyamide
string90
polyester
string
polyurethane
string
silk
string
spandex
string
viscose
string
datecreated
Date Time (Europe/Paris)
{ts '2025-01-20 15:48:36'}
defect
number0
dimensions
Struct
Entries: 14
acrylicbones
string
backsideheight
string
diameter
string
flatsteelbones
string
frontsideheight
string
fullheight
string
length
string
modestysize
string
panels
string
sides
string
spiralsteelbones
string
totallength
string
unit
stringcm
wiresize
string
display
stringall
displayfrom
string
displayto
string
grossweight
string
hasbrandinfos
booleanfalse
hascareinstructions
booleanfalse
hascolorinfos
booleantrue
hascompositions
booleantrue
hasdescription
booleantrue
hasdimensions
booleanfalse
hasmaterials
booleantrue
hasotherspecifications
booleanfalse
haspromo
number0
hasshortdescription
booleantrue
hassizeinfos
booleantrue
hasspecifications
booleanfalse
hasstockinfos
booleanfalse
hasstylingtips
booleanfalse
hasusageinstructions
booleanfalse
hasvariations
booleantrue
import
string
inpromo
number0
instockvariations
string
isactive
number1
iscustommade
number0
isdivasize
number1
isfirstprice
number0
isfixedprice
number0
ishot
number0
isnew
number0
isonline
number0
isoutletprice
number0
itemprice
number99.125
itempromo
string
key
string27189441061
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-08-01 18:59:13'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.649 ms
Record Count: 0
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select cart_actions.*
from cart_actions
where cart_actions.branding IN ('all','divasboudoir')
and cart_actions.language IN ('all','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('65efff76-2e98-4769-9c9a883411d50ab7',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.33 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 <> 'SFBA1493'
group by products.reference
order by products.ishot desc, products.isnew desc, orderidx asc, products.lastupdated desc
productuidreferencetypekeylanguagenamelinkuidcolorsvatratemetadatasdimensionsmediadatastagsthemesisdivasizetotalvariationsvariationlistinpromohaspromoitempromoitempriceunitpricepricespromountilisfixedpriceishotisneworderidxavailablestockinstockvariationsbrandbrandnameshowbranddisplaysizetypeintlsizesizessizerangecategorymediadatascategorysizerangesectioncategorysubcategory
linkuid
string
materials
stringwetlook
mediadatas
Struct
alt
Struct
height
string997
isprivate
string0
rating
stringall
src
string/photobank/products/cwhd/sfba1493/29951572.jpg
type
stringimg
width
string689
back
Struct
height
string1000
isprivate
string0
rating
stringall
src
string/photobank/products/cwhd/sfba1493/27189441051_det_b.avif.jpg
type
stringimg
width
string1000
default
Struct
height
string1000
isprivate
string0
rating
stringall
src
string/photobank/products/cwhd/sfba1493/29951529.jpg
type
stringimg
width
string692
variations
Struct
colors
Struct
black
Struct
height
string1000
isprivate
string0
rating
stringall
src
string/photobank/products/cwhd/sfba1493/29951529.jpg
type
stringimg
width
string692
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
description
string<div> <p class="text-base">Meine Damen, suchen Sie nach einer Möglichkeit, Ihre Kurven zu betonen? Wir haben genau das Richtige für Sie!</p> <p class="text-base">Dieses eng anliegende, hypersexy Elsa-Kleid wird Sie umhauen. Es ist ganz in glänzendem Mattschwarz gehalten und soll Ihre üppigen Formen mit Stil und Komfort betonen.</p> <p class="text-base">Das Oberteil lässt sich dank diskreter Reißverschlüsse leicht über der Brust öffnen. Praktisch, nicht wahr?</p> <p class="text-base">Ein Reißverschluss im Rücken sorgt dafür, dass Sie es ohne Galanterie anziehen können. Der Stehkragen mit Ring verleiht dem Ganzen einen sexy Touch.</p> <p class="text-base">Lust, die Sache etwas aufzupeppen? Die enthaltenen Zwangsarmbänder lassen sich ganz einfach an den Seiten befestigen. Und wenn Sie einen braveren Look bevorzugen - kein Problem! Die Brust- und Taillenbänder sind abnehmbar.</p> <p class="text-base">Bequem, anpassungsfähig und furchtbar sexy - dieses Set passt sich jeder Körperform an.</p> </div>
guid
stringhttps://dev.divasboudoir.com/de/unterhemdkleid-grosse-grosse-schwarz/sfba1493.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringDieses eng anliegende, hypersexy Kleid von Elsa wird Sie umhauen. Es ist ganz in glänzendem Mattschwarz gehalten und soll Ihre üppigen Formen mit Stil und Komfort betonen.
keywords
string
title
stringElsa Kleid in Übergröße - Unterwürfiger und BDSM-Stil
seotitle
stringUnterhemdkleid Große Größe
seouri
stringunterhemdkleid-grosse-grosse-schwarz
specifications
string
stylingtips
string
summary
string<div> <p class="text-base">Sind Sie bereit, sich völlig hinzugeben?</p> <p class="text-base">Entfesseln Sie die Unterwürfige in Ihnen, unabhängig von Ihrer Körpergröße.</p> </div>
title
stringKleid Elsa
usageinstructions
string
el
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Κυρίες, θέλετε να ενισχύσετε τις καμπύλες σας Έχουμε ακριβώς αυτό που χρειάζεστε!</p> <p class="text-base">Θα ερωτευτείτε αυτό το σούπερ σέξι, εφαρμοστό φόρεμα Elsa. Σε γυαλιστερό μαύρο ματ χρώμα, έχει σχεδιαστεί για να αναδεικνύει τις πλούσιες καμπύλες σας με στυλ και άνεση.</p> <p class="text-base">Το πάνω μέρος ανοίγει εύκολα στο μπούστο χάρη στα διακριτικά φερμουάρ. Πρακτικό, έτσι δεν είναι</p> <p class="text-base">Υπάρχει επίσης ένα φερμουάρ στο πίσω μέρος, ώστε να μπορείτε να το φορέσετε χωρίς καθόλου φασαρία. Ο ψηλός γιακάς με το δαχτυλίδι του προσθέτει μια σέξι πινελιά.</p> <p class="text-base">Θέλεις να κάνεις τα πράγματα πιο πικάντικα Τα βραχιόλια συγκράτησης που περιλαμβάνονται προσαρτώνται εύκολα στα πλαϊνά. Και αν προτιμάτε μια πιο σοφή εμφάνιση, μην ανησυχείτε! Οι ιμάντες στο στήθος και στη μέση είναι αποσπώμενοι.</p> <p class="text-base">Άνετο, ρυθμιζόμενο και τρομερά σέξι, αυτό το σετ ταιριάζει σε όλα τα σχήματα σώματος.</p> </div>
guid
stringhttps://dev.divasboudoir.com/el/forema-poykamiso-megaloy-megethoys-mayro/sfba1493.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringΘα ξετρελαθείτε με αυτό το σούπερ σέξι, εφαρμοστό φόρεμα Elsa. Σε γυαλιστερό μαύρο ματ χρώμα, έχει σχεδιαστεί για να αναδεικνύει τις πλούσιες καμπύλες σας με στυλ και άνεση.
keywords
string
title
stringElsa plus size φόρεμα - υποτακτικό και BDSM στυλ
seotitle
stringΦόρεμα πουκάμισο μεγάλου μεγέθους
seouri
stringforema-poykamiso-megaloy-megethoys-mayro
specifications
string
stylingtips
string
summary
string<div> <p class="text-base">Είστε έτοιμοι να παραδοθείτε ολοκληρωτικά</p> <p class="text-base">Απελευθερώστε την εσωτερική σας υποταγή, ανεξάρτητα από το μέγεθός σας.</p> </div>
title
stringΦόρεμα Elsa
usageinstructions
string
en
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Ladies, looking to enhance your curves? We've got just what you need!</p> <p class="text-base">This super-sexy, form-fitting Elsa dress will make you fall in love. All in shiny matte black, it's designed to enhance your generous curves with style and comfort.</p> <p class="text-base">The top opens easily over the bust thanks to discreet zips. Practical, isn't it?</p> <p class="text-base">A back zipper makes it easy to put on. The high collar with ring adds a sexy touch.</p> <p class="text-base">Want to spice things up? The included restraint bracelets attach easily to the sides. And if you prefer a wiser look, don't worry! Chest and waist straps are removable.</p> <p class="text-base">Comfortable, adjustable and wickedly sexy, this set adapts to all body shapes.</p> </div>
guid
stringhttps://dev.divasboudoir.com/en/shirt-dress-plus-size-black/sfba1493.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringYou'll fall in love with this super-sexy, form-fitting Elsa dress. All in shiny matte black, it's designed to enhance your generous curves with style and comfort.
keywords
string
title
stringElsa plus size dress - Submissive and BDSM style
seotitle
stringShirt Dress Plus size
seouri
stringshirt-dress-plus-size-black
specifications
string
stylingtips
string
summary
string<div> <p class="text-base">Ready to give yourself over completely?</p> <p class="text-base">Unleash your inner submissive, whatever your size.</p> </div>
title
stringElsa dress
usageinstructions
string
es
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Señoras, ¿buscan realzar sus curvas? Tenemos justo lo que necesitas</p> <p class="text-base">Te enamorarás de este vestido Elsa súper sexy y ceñido. Todo en negro mate brillante, está diseñado para realzar tus generosas curvas con estilo y comodidad.</p> <p class="text-base">La parte superior se abre fácilmente sobre el busto gracias a discretas cremalleras. Práctico, ¿verdad?</p> <p class="text-base">También tiene una cremallera en la espalda para que puedas ponértelo sin problemas. El cuello alto con anilla le da un toque sexy.</p> <p class="text-base">¿Quieres darle un toque más picante? Los brazaletes de sujeción incluidos se sujetan fácilmente a los lados. Y si prefieres un look más discreto, ¡no te preocupes! Los tirantes del pecho y la cintura son extraíbles.</p> <p class="text-base">Cómodo, ajustable y terriblemente sexy, este conjunto se adapta a todas las formas del cuerpo.</p> </div>
guid
stringhttps://dev.divasboudoir.com/es/vestido-camisero-talla-grande-negro/sfba1493.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringTe enamorarás de este vestido Elsa súper sexy y ceñido. Todo en negro mate brillante, está diseñado para realzar tus generosas curvas con estilo y comodidad.
keywords
string
title
stringVestido talla grande Elsa - Estilo sumiso y BDSM
seotitle
stringVestido camisero talla grande
seouri
stringvestido-camisero-talla-grande-negro
specifications
string
stylingtips
string
summary
string<div> <p class="text-base">¿Lista para entregarte por completo?</p> <p class="text-base">Da rienda suelta a la sumisa que llevas dentro, sea cual sea tu talla.</p> </div>
title
stringVestido Elsa
usageinstructions
string
fr
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>Mesdames, vous cherchez &agrave; mettre vos courbes en valeur ? On a ce qu'il vous faut !</p> <p>Cet robe moulante et hyper sexy Elsa va vous faire craquer. Tout en noir mat brillant, elle est con&ccedil;ue pour sublimer vos formes g&eacute;n&eacute;reuses avec style et confort.</p> <p>Le haut s'ouvre facilement sur la poitrine gr&acirc;ce &agrave; des zips discrets. Pratique, non ?</p> <p>Une fermeture &eacute;clair dans le dos pour l'enfiler sans gal&egrave;re. Le col montant avec son anneau ajoute une touche sexy.</p> <p>Envie de pimenter les choses ? Les bracelets de contrainte inclus s'attachent facilement sur les c&ocirc;t&eacute;s. Et si vous pr&eacute;f&eacute;rez un look plus sage, pas de souci ! Les sangles de poitrine et de taille sont amovibles.</p> <p>Confortable, ajustable et terriblement sexy, cet ensemble s'adapte &agrave; toutes les morphologies.</p>
guid
stringhttps://dev.divasboudoir.com/fr/robe-de-soumise-grande-taille-noir/sfba1493.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringCet robe moulante et hyper sexy Elsa va vous faire craquer. Tout en noir mat brillant, elle est conçue pour sublimer vos formes généreuses avec style et confort.
keywords
string
title
stringRobe grande taille Elsa - Style Soumise et BDSM
seotitle
stringRobe de Soumise Grande taille
seouri
stringrobe-de-soumise-grande-taille-noir
specifications
string
stylingtips
string
summary
string<p>Pr&ecirc;te &agrave; vous abandonner totalement ?</p> <p>Lib&eacute;rez la soumise qui sommeille en vous, quelle que soit votre taille.</p>
title
stringRobe Elsa ouvrable sur la poitrine
usageinstructions
string
it
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Signore, volete valorizzare le vostre curve? Abbiamo quello che fa per voi!</p> <p class="text-base">Vi innamorerete di questo abito Elsa super sexy e aderente. In nero lucido e opaco, è progettato per esaltare le vostre curve generose con stile e comfort.</p> <p class="text-base">La parte superiore si apre facilmente sul seno grazie a discrete cerniere. Pratico, vero?</p> <p class="text-base">C'è anche una cerniera sul retro per poterlo infilare senza problemi. Il collo alto con anello aggiunge un tocco sexy.</p> <p class="text-base">Volete rendere le cose più piccanti? I braccialetti di contenzione inclusi si attaccano facilmente ai lati. E se preferite un look più saggio, non preoccupatevi! Le cinghie sul petto e in vita sono rimovibili.</p> <p class="text-base">Comodo, regolabile e terribilmente sexy, questo set si adatta a tutte le forme del corpo.</p> </div>
guid
stringhttps://dev.divasboudoir.com/it/abito-camicia-taglia-grande-nero/sfba1493.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringQuesto abito Elsa, super sexy e aderente, vi farà perdere la testa. In nero lucido e opaco, è progettato per esaltare le vostre curve generose con stile e comfort.
keywords
string
title
stringAbito Elsa taglia grande - Stile sottomesso e BDSM
seotitle
stringAbito camicia taglia grande
seouri
stringabito-camicia-taglia-grande-nero
specifications
string
stylingtips
string
summary
string<div> <p class="text-base">Siete pronte a concedervi completamente?</p> <p class="text-base">Liberate la sottomessa che è in voi, qualunque sia la vostra taglia.</p> </div>
title
stringAbito Elsa
usageinstructions
string
nl
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Dames, willen jullie je rondingen verbeteren? We hebben precies wat je nodig hebt!</p> <p class="text-base">Je zult verliefd worden op deze super sexy, nauwsluitende Elsa jurk. Helemaal in glanzend matzwart en ontworpen om je royale rondingen stijlvol en comfortabel te accentueren.</p> <p class="text-base">De top opent gemakkelijk over de buste dankzij discrete ritsen. Praktisch, nietwaar?</p> <p class="text-base">Er zit ook een rits aan de achterkant zodat je hem zonder gedoe kunt aantrekken. De hoge kraag met ring zorgt voor een sexy touch.</p> <p class="text-base">Wil je het wat spannender maken? De bijgeleverde armbanden zijn gemakkelijk te bevestigen aan de zijkanten. En als je liever een wijzere look hebt, geen zorgen! De borst- en taillebanden zijn afneembaar.</p> <p class="text-base">Comfortabel, verstelbaar en vreselijk sexy, dit setje past bij alle lichaamsvormen.</p> </div>
guid
stringhttps://dev.divasboudoir.com/nl/grote-maat-overhemdjurk-zwart/sfba1493.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringJe zult hals over kop vallen voor deze super sexy, nauwsluitende Elsa jurk. Helemaal in glanzend matzwart en ontworpen om je royale rondingen stijlvol en comfortabel te accentueren.
keywords
string
title
stringElsa jurk grote maat - onderdanige en BDSM-stijl
seotitle
stringGrote maat overhemdjurk
seouri
stringgrote-maat-overhemdjurk-zwart
specifications
string
stylingtips
string
summary
string<div> <p class="text-base">Klaar om jezelf helemaal over te geven?</p> <p class="text-base">Ontketen je innerlijke onderdanigheid, ongeacht je grootte.</p> </div>
title
stringElsa jurk
usageinstructions
string
pt
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Senhoras, querem melhorar as vossas curvas? Temos exatamente o que precisa!</p> <p class="text-base">Vai-se apaixonar por este vestido Elsa super sexy e justo. Todo em preto mate brilhante, foi concebido para realçar as suas curvas generosas com estilo e conforto.</p> <p class="text-base">A parte superior abre-se facilmente sobre o busto graças a fechos discretos. Prático, não é?</p> <p class="text-base">Há também um fecho de correr na parte de trás para o poder vestir sem problemas. A gola alta com a sua argola dá um toque sexy.</p> <p class="text-base">Quer apimentar as coisas? As pulseiras de retenção incluídas prendem-se facilmente aos lados. E se preferir um look mais sensato, não se preocupe! As tiras do peito e da cintura são amovíveis.</p> <p class="text-base">Confortável, ajustável e terrivelmente sexy, este conjunto adapta-se a todas as formas do corpo.</p> </div>
guid
stringhttps://dev.divasboudoir.com/pt/vestido-com-camisa-de-tamanho-grande-preto/sfba1493.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringVai apaixonar-se por este vestido Elsa super sexy e justo. Todo em preto mate brilhante, foi concebido para realçar as suas curvas generosas com estilo e conforto.
keywords
string
title
stringVestido Elsa plus size - Estilo submisso e BDSM
seotitle
stringVestido com camisa de tamanho grande
seouri
stringvestido-com-camisa-de-tamanho-grande-preto
specifications
string
stylingtips
string
summary
string<div> <p class="text-base">Pronta para se entregar completamente?</p> <p class="text-base">Liberte a sua submissa interior, qualquer que seja o seu tamanho.</p> </div>
title
stringVestido Elsa
usageinstructions
string
fetishboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-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 class="text-base">Unterwerfungskleid in Übergröße Elsa</p> <p class="text-base">Eng anliegend und provokant: Dieser Look in matt glänzendem Schwarz schmiegt sich an Ihre üppigen Kurven und verwandelt Sie in eine wahre Opfergabe für Ihre dominante Person. Die Reißverschlüsse an der Brust werden es ihm ermöglichen, Sie nach Belieben zu enthüllen, wodurch das Verlangen und die Vorfreude geschürt werden.</p> <p class="text-base">Der Stehkragen mit seinem Ring wartet nur darauf, an einer Leine befestigt zu werden, und erinnert Sie an Ihren Platz. Die seitlichen Ringe sind ideal, um die mitgelieferten Zwangsbänder daran zu befestigen, wodurch Sie völlig den Launen Ihres Herrn/Ihrer Herrin ausgeliefert sind.</p> <p class="text-base">Die verstellbaren Riemen an Brust und Taille betonen Ihre Figur und halten Sie gleichzeitig fest im Griff. Ihr dominanter Partner kann entscheiden, ob er sie anbehält oder abnimmt, um die Empfindungen zu variieren.</p> <p class="text-base">Dieses bequeme und unglaublich aufregende Set passt sich jeder Körperform und der Intensität Ihrer Spiele an. Sind Sie also bereit, sich völlig hinzugeben?</p> <p class="text-base">Entfesseln Sie die Unterwürfige in Ihnen, unabhängig von Ihrer Größe!</p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringÜppige Damen, bereit, sich Ihren tiefsten Fantasien hinzugeben? Dieses Kleid von The BDSM Boudoir wird Ihre unterwürfige Seite wecken!
keywords
string
title
stringUnterwerfungskleid in Übergröße - The BDSM Boudoir
seotitle
stringUnterkleid Große Größe Elsa
seouri
stringunterkleid-grosse-grosse-elsa-schwarz
specifications
string
stylingtips
string
summary
string<p>Üppige Damen, bereit, sich Ihren tiefsten Fantasien hinzugeben? Dieses Kleid von The BDSM Boudoir wird Ihre unterwürfige Seite wecken!</p>
title
stringKleid in großen Größen von Soumise Elsa
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p class="text-base">Elsa plus size φόρεμα υποβολής</p> <p class="text-base">Φόρμα και προκλητικό, αυτό το look σε γυαλιστερό ματ μαύρο θα αγκαλιάσει τις γενναιόδωρες καμπύλες σας, μετατρέποντάς σας σε πραγματική προσφορά για τον κυρίαρχο σας. Τα φερμουάρ στο στήθος θα τον αφήσουν να σας αποκαλύψει όπως θέλει, φουντώνοντας την επιθυμία και την προσμονή.</p> <p class="text-base">Το ψηλό κολάρο με το δαχτυλίδι του περιμένει να συνδεθεί με ένα λουρί, υπενθυμίζοντάς σας τη θέση σας. Οι πλευρικοί κρίκοι είναι ιδανικοί για να προσαρτήσετε τα βραχιόλια περιορισμού που περιλαμβάνονται, αφήνοντάς σας εντελώς στην ιδιοτροπία του ιδιοκτήτη σας.</p> <p class="text-base">Οι ρυθμιζόμενοι ιμάντες στο στήθος και στη μέση τονίζουν τη σιλουέτα σας, ενώ σας κρατούν σταθερά στη θέση σας. Ο κυρίαρχος σας μπορεί να αποφασίσει αν θα κρατήσει τους ιμάντες ή θα τους βγάλει για να ποικίλλουν οι αισθήσεις.</p> <p class="text-base">Άνετο και τρομερά συναρπαστικό, αυτό το σετ προσαρμόζεται σε όλα τα σχήματα σώματος και στην ένταση του παιχνιδιού σας. Είστε λοιπόν έτοιμη να παραδοθείτε ολοκληρωτικά</p> <p class="text-base">Απελευθερώστε την υποτακτική που κρύβετε μέσα σας, όποιο κι αν είναι το μέγεθός σας!</p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringΛαχταριστές κυρίες, έτοιμες να ενδώσουν στις βαθύτερες φαντασιώσεις σας Αυτό το φόρεμα The BDSM Boudoir θα ξυπνήσει την υποτακτική σας πλευρά!
keywords
string
title
stringΦόρεμα υποταγής μεγάλο - The Bdsm Boudoir
seotitle
stringElsa Φόρεμα πουκάμισο συν μέγεθος
seouri
stringelsa-forema-poykamiso-syn-megethos-mayro
specifications
string
stylingtips
string
summary
string<p>Λαχταριστές κυρίες, έτοιμες να ενδώσουν στις βαθύτερες φαντασιώσεις σας Αυτό το The BDSM Boudoir φόρεμα θα ξυπνήσει την υποτακτική σας πλευρά!</p>
title
stringΦόρεμα μεγάλου μεγέθους από την Soumise Elsa
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p class="text-base">Elsa plus size submission dress</p> <p class="text-base">Form-fitting and provocative, this look in glossy matte black will hug your generous curves, transforming you into a veritable offering for your dominant. Chest zippers let her reveal you at will, fanning desire and anticipation.</p> <p class="text-base">The high collar with its ring is just waiting to be attached to a leash, reminding you of your place. The side rings are perfect for attaching the included restraint bracelets, leaving you totally at the whim of your master(s).</p> <p class="text-base">Adjustable chest and waist straps accentuate your silhouette while holding you firmly in place. Your dominant can decide whether to keep them on or take them off to vary the sensations.</p> <p class="text-base">Comfortable and terribly exciting, this set adapts to all body shapes and to the intensity of your play. So, are you ready for total surrender?</p> <p class="text-base">Unleash your inner submissive, whatever your size!</p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringLuscious ladies, ready to give in to your deepest fantasies? This The BDSM Boudoir dress will awaken your submissive side!
keywords
string
title
stringSubmission dress plus size - The BDSM Boudoir
seotitle
stringElsa Plus Size Shirt Dress
seouri
stringelsa-plus-size-shirt-dress-black
specifications
string
stylingtips
string
summary
string<p>Luscious ladies, ready to give in to your deepest fantasies? This The BDSM Boudoir dress will awaken your submissive side!</p>
title
stringPlus size dress by Soumise Elsa
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p class="text-base">Vestido de sumisión talla grande Elsa</p> <p class="text-base">Ceñido y provocativo, este look en negro mate brillante abrazará tus generosas curvas, convirtiéndote en una auténtica ofrenda para tu dominante. Los cierres de cremallera en el pecho le permitirán descubrirte a su antojo, avivando el deseo y la expectación.</p> <p class="text-base">El cuello alto con su anilla está a la espera de ser atado a una correa, recordándote cuál es tu lugar. Las anillas laterales son perfectas para enganchar los brazaletes de sujeción incluidos, dejándote totalmente al capricho de tu dueño.</p> <p class="text-base">Las correas ajustables de pecho y cintura acentúan tu figura mientras te mantienen firmemente en tu sitio. Tu dominante puede decidir si mantener las correas puestas o quitárselas para variar las sensaciones.</p> <p class="text-base">Cómodo y terriblemente excitante, este conjunto se adapta a todas las formas del cuerpo y a la intensidad de tu juego. ¿Estás lista para entregarte por completo?</p> <p class="text-base">Da rienda suelta a la sumisa que llevas dentro, sea cual sea tu talla</p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringSeñoritas exquisitas, ¿listas para dar rienda suelta a sus fantasías más profundas? ¡Este vestido The BDSM Boudoir despertará tu lado sumiso!
keywords
string
title
stringVestido de sumisión talla grande - The BDSM Boudoir
seotitle
stringVestido camisero talla grande Elsa
seouri
stringvestido-camisero-talla-grande-elsa-negro
specifications
string
stylingtips
string
summary
string<p>Señoritas exquisitas, ¿listas para dar rienda suelta a sus fantasías más profundas? ¡Este vestido The BDSM Boudoir despertará tu lado sumiso!</p>
title
stringVestido talla grande de Soumise Elsa
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p class="text-base">Robe de soumission grande taille Elsa</p> <p class="text-base">Moulant et provocant, ce look en noir mat brillant &eacute;pousera vos courbes g&eacute;n&eacute;reuses, vous transformant en une v&eacute;ritable offrande pour votre dominant(e). Les fermetures &eacute;clair sur la poitrine lui permettront de vous d&eacute;voiler &agrave; sa guise, attisant le d&eacute;sir et l'anticipation.</p> <p class="text-base">Le col montant avec son anneau n'attend que d'&ecirc;tre attach&eacute; &agrave; une laisse, vous rappelant votre place. Les anneaux lat&eacute;raux sont parfaits pour y fixer les bracelets de contrainte inclus, vous livrant totalement aux caprices de votre ma&icirc;tre(sse).</p> <p class="text-base">Les sangles ajustables sur la poitrine et la taille accentuent votre silhouette tout en vous maintenant fermement. Votre dominant(e) d&eacute;cidera s'il les garde ou les retire pour varier les sensations.</p> <p class="text-base">Confortable et terriblement excitant, cet ensemble s'adapte &agrave; toutes les morphologies et &agrave; l'intensit&eacute; de vos jeux. Alors, pr&ecirc;te &agrave; vous abandonner totalement ?</p> <p class="text-base">Lib&eacute;rez la soumise qui sommeille en vous, quelle que soit votre taille !</p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringMesdames pulpeuses, prêtes à vous abandonner à vos fantasmes les plus profonds ? Cette robe The BDSM Boudoir va éveiller votre côté soumis !
keywords
string
title
stringRobe de Soumission grande taille - The Bdsm Boudoir
seotitle
stringRobe de Soumise Grande taille Elsa
seouri
stringrobe-de-soumise-grande-taille-elsa-noir
specifications
string
stylingtips
string
summary
string<p>Mesdames pulpeuses, pr&ecirc;tes &agrave; vous abandonner &agrave; vos fantasmes les plus profonds ? Cette robe The BDSM Boudoir va &eacute;veiller votre c&ocirc;t&eacute; soumis !</p>
title
stringRobe grande taille de Soumise Elsa
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p class="text-base">Abito di sottomissione Elsa taglia grande</p> <p class="text-base">Aderente e provocante, questo look in nero lucido e opaco abbraccerà le vostre curve generose, trasformandovi in una vera e propria offerta per il vostro dominatore. Le chiusure lampo sul petto gli permetteranno di scoprirvi a suo piacimento, accendendo il desiderio e l'attesa.</p> <p class="text-base">Il collare alto con anello aspetta solo di essere attaccato al guinzaglio per ricordarvi il vostro posto. Gli anelli laterali sono perfetti per agganciare i braccialetti di contenzione inclusi, lasciandovi completamente ai capricci del vostro padrone.</p> <p class="text-base">Le cinghie regolabili sul petto e in vita accentuano la vostra figura e vi tengono saldamente in posizione. Il vostro dominatore può decidere se tenere le cinghie o toglierle per variare le sensazioni.</p> <p class="text-base">Confortevole e terribilmente eccitante, questo set si adatta a tutte le forme del corpo e all'intensità del gioco. Allora, siete pronti a concedervi completamente?</p> <p class="text-base">Scatenate la vostra sottomessa interiore, qualunque sia la vostra taglia!</p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringDonne lussuriose, pronte a cedere alle vostre fantasie più profonde? Questo abito BDSM Boudoir risveglierà il vostro lato sottomesso!
keywords
string
title
stringAbito da sottomissione di taglia grande - The BDSM Boudoir
seotitle
stringElsa - Vestito camicia taglia grande
seouri
stringelsa--vestito-camicia-taglia-grande-nero
specifications
string
stylingtips
string
summary
string<p>Donne lussuriose, pronte a cedere alle vostre fantasie più profonde? Questo abito BDSM Boudoir risveglierà il vostro lato sottomesso!</p>
title
stringAbito di taglia grande di Soumise Elsa
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p class="text-base">Elsa grote maat overgave jurk</p> <p class="text-base">Deze nauwsluitende en uitdagende look in glanzend matzwart omhelst je royale rondingen en verandert je in een waar offer voor je dominante. Met de ritssluiting op de borst kan hij je naar believen onthullen, wat het verlangen en de verwachting aanwakkert.</p> <p class="text-base">De hoge halsband met ring wacht erop om aan een riem te worden vastgemaakt, zodat je aan je plaats wordt herinnerd. De ringen aan de zijkant zijn perfect voor het bevestigen van de bijgeleverde dwangarmbanden, zodat je helemaal bent overgeleverd aan de grillen van je eigenaar.</p> <p class="text-base">Verstelbare borst- en taillebandjes accentueren je figuur terwijl ze je stevig op je plaats houden. Je dominante kan beslissen of je de bandjes omhoudt of afdoet om de sensaties te variëren.</p> <p class="text-base">Comfortabel en vreselijk opwindend, deze set past zich aan alle lichaamsvormen aan en aan de intensiteit van je spel. Dus, ben je klaar om jezelf helemaal over te geven?</p> <p class="text-base">Ontketen je innerlijke onderdanige, ongeacht je maat!</p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringWeelderige dames, klaar om toe te geven aan je diepste fantasieën? Deze BDSM Boudoir jurk zal je onderdanige kant doen ontwaken!
keywords
string
title
stringOnderwerpingsjurk grote maat - The BDSM Boudoir
seotitle
stringElsa Overhemdjurk Grote Maat
seouri
stringelsa-overhemdjurk-grote-maat-zwart
specifications
string
stylingtips
string
summary
string<p>Weelderige dames, klaar om toe te geven aan je diepste fantasieën? Deze BDSM Boudoir jurk zal je onderdanige kant doen ontwaken!</p>
title
stringGrote maat jurk van Soumise Elsa
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p class="text-base">Vestido de submissão Elsa plus size</p> <p class="text-base">Bem ajustado e provocante, este look em preto mate brilhante vai abraçar as suas curvas generosas, transformando-a numa verdadeira oferenda para a sua dominante. Os fechos no peito permitirão que ela a revele como quiser, alimentando o desejo e a antecipação.</p> <p class="text-base">A gola alta com argola está à espera de ser presa a uma trela, lembrando-lhe o seu lugar. As argolas laterais são perfeitas para prender as pulseiras de restrição incluídas, deixando-o totalmente à mercê dos caprichos da sua dona.</p> <p class="text-base">As tiras ajustáveis no peito e na cintura acentuam a sua forma, mantendo-o firmemente no lugar. O seu dominador pode decidir se quer manter as tiras colocadas ou tirá-las para variar as sensações.</p> <p class="text-base">Confortável e terrivelmente excitante, este conjunto adapta-se a todas as formas do corpo e à intensidade das suas brincadeiras. Então, está pronta para se entregar completamente?</p> <p class="text-base">Liberte a sua submissa interior, qualquer que seja o seu tamanho!</p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringSenhoras deliciosas, prontas para se entregarem às vossas fantasias mais profundas? Este vestido The BDSM Boudoir vai despertar o seu lado submisso!
keywords
string
title
stringVestido de submissão grande - The Bdsm Boudoir
seotitle
stringVestido com camisa Elsa Plus Size
seouri
stringvestido-com-camisa-elsa-plus-size-preto
specifications
string
stylingtips
string
summary
string<p>Senhoras deliciosas, prontas para se entregarem às vossas fantasias mais profundas? Este vestido Boudoir BDSM vai despertar o seu lado submisso!</p>
title
stringVestido de tamanho grande de Soumise Elsa
usageinstructions
string
name
string27189441061
netweight
string
nextshipment
stringtomorrow
ordered
number0
orderidx
number0
origin
string
originalsize
string
packaging
string
productshipment
stringauto
productuid
string65EFFF76-2E98-4769-9C9A883411D50AB7
promountil
string
rating
stringnone
recorduid
string65EFFF76-2E98-4769-9C9A883411D50AB7
reference
stringSFBA1493
related
string
reserved
string
returned
number0
returnsallowed
number1
section
stringcabaret
shipment
string4to6days
showbrand
number0
sizeinfos
Query
Template: /system/api/product/sizes.cfc:20
Execution Time: 1.55 ms
Record Count: 7
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_sizes.id_size as recorduid, if(intlsize <> '',intlsize,eusize) as size, if(intlsize <> '','intlsize','eusize') as sizetype,
product_variations.color,
if(product_sizes.sizegroup = 'bra',
if(intlsize <> '', cast(intlsize as SIGNED ), cast(eusize as SIGNED ))
,
SUBSTRING_INDEX(intlsize,'-',1)
) as param1,
if(product_sizes.sizegroup = 'bra',
if(intlsize <> '',
MID(intlsize,length(cast(intlsize as SIGNED ))+1,length(intlsize)),
MID(eusize,length(cast(eusize as SIGNED ))+1,length(eusize))
)
,
SUBSTRING_INDEX(intlsize,'-',-1)
) as param2,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as available,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
999999,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as groupavailable,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
product_sizes.gender, product_sizes.sizerange, product_sizes.sizegroup, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize,
product_sizes.bust, product_sizes.waist, product_sizes.hip, product_sizes.underbust, product_sizes.cup, product_sizes.thigh, product_sizes.legheight, product_sizes.bodyheight, product_sizes.bodyweight
from product_sizes
left outer join product_variations on product_sizes.suppliersize = product_variations.size and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
where FIND_IN_SET(product_sizes.id_size,'1408,736,737,738,739,740,741') > 0
and product_variations.productuid = '65EFFF76-2E98-4769-9C9A883411D50AB7'
and intlsize <> 'na'
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_sizes.id_size, product_variations.color
order by FIELD(product_sizes.gender,'w','m'), product_sizes.sizegroup, FIELD(intlsize,'XS','S','S/M','S-M','M','M/L','M-L','L','L-XL','L/XL','XL','0X','0XL','lXL','1X','1X-2X','1X/2X','XL/2XL','XL-2XL','1XL-2XL','2XL','2X','XXL','2X-3X','2X/3X','2XL-3XL','2XL/3XL','XXXL','3XL','3X','3X-4X','3X/4X','3XL-4XL','3XL/4XL','4XL','5XL','5X','5X-6X','5X/6X','5XL-6XL','5XL/6XL','6XL','6X','7XL','7X','8XL','8X'), cast(intlsize as SIGNED ), groupavailable desc, stock desc
recorduidsizesizetypecolorparam1param2availablegroupavailablestockgendersizerangesizegroupsuppliersizeintlsizeincheseusizeussizeuksizefrsizeessizedesizeitsizeptsizeelsizebustwaisthipunderbustcupthighlegheightbodyheightbodyweight
1737XL+intlsizeblackXL+XL+-19999990wpluslingerieXLXL+48-5018-2022-2450-5250-5248-5054-5650-5248-50113-11896-102117-121
27392XL+intlsizeblack2XL+2XL+-19999990wpluslingerie2XL2XL+52-5422-2426-2854-5654-5652-5458-6054-5652-54125-130109-114127-132
37413XL+intlsizeblack3XL+3XL+-19999990wpluslingerie3XL3XL+56-5826-2830-3258-6058-6056-5862-6458-6056-58137-142122-128138-144
41408LintlsizeblackLL-19999990wpluslingerieXLL44-4614-1618-2046-4846-4844-4650-5246-4844-46103-10686-90109-112
5736XLintlsizeblackXLXL-19999990wpluslingerieXLXL46-4816-1820-2248-5048-5046-4852-5448-5046-48107-11291-95113-116
67382XLintlsizeblack2XL2XL-19999990wpluslingerie2XL2XL50-5220-2424-2852-5452-5450-5256-5852-5450-52119-124103-108122-126
77403XLintlsizeblack3XL3XL-19999990wpluslingerie3XL3XL54-5624-2628-3056-5856-5854-5660-6256-5854-56131-136115-121133-138
sizeranges
stringplus
sizes
string1408,736,737,738,739,740,741
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: 45.9 ms
Record Count: 3
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select * from (
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '65EFFF76-2E98-4769-9C9A883411D50AB7'
and product_variations.isactive = 1
and product_sizes.id_size = 1408
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '65EFFF76-2E98-4769-9C9A883411D50AB7'
and product_variations.isactive = 1
and product_sizes.id_size = 736
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '65EFFF76-2E98-4769-9C9A883411D50AB7'
and product_variations.isactive = 1
and product_sizes.id_size = 737
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '65EFFF76-2E98-4769-9C9A883411D50AB7'
and product_variations.isactive = 1
and product_sizes.id_size = 738
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '65EFFF76-2E98-4769-9C9A883411D50AB7'
and product_variations.isactive = 1
and product_sizes.id_size = 739
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '65EFFF76-2E98-4769-9C9A883411D50AB7'
and product_variations.isactive = 1
and product_sizes.id_size = 740
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '65EFFF76-2E98-4769-9C9A883411D50AB7'
and product_variations.isactive = 1
and product_sizes.id_size = 741
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
) 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
165EFFF76-2E98-4769-9C9A883411D50AB73B02F1C8-29F5-4633-9E7160FCA3DDEE151408black#000000XLL44-4614-1618-2046-4846-4844-4650-5246-4844-46wlingerieLintlsize99.1250STOCK01000-10000-10all
265EFFF76-2E98-4769-9C9A883411D50AB7AD4CCB80-974A-4AAF-9E3E02D60D54CADC738black#0000002XL2XL50-5220-2424-2852-5452-5450-5256-5852-5450-52wlingerie2XLintlsize99.1250STOCK01000-10000-10all
365EFFF76-2E98-4769-9C9A883411D50AB763BF6C81-E5A3-4022-9FEA3BB4ABC7DCDB740black#0000003XL3XL54-5624-2628-3056-5856-5854-5660-6256-5854-56wlingerie3XLintlsize99.1250STOCK01000-10000-10all
subcategory
stringall
supplier
number-1
supplierreference
string27189441061
tags
stringnoirdesir
themes
stringdark,luxe
totalvariations
string
type
stringdefault
unitprice
number99.125
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 11.9 ms
Record Count: 7
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 = '65EFFF76-2E98-4769-9C9A883411D50AB7' 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 = '65EFFF76-2E98-4769-9C9A883411D50AB7' 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 = '65EFFF76-2E98-4769-9C9A883411D50AB7' 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 = '65EFFF76-2E98-4769-9C9A883411D50AB7' 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 = '65EFFF76-2E98-4769-9C9A883411D50AB7' 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 = '65EFFF76-2E98-4769-9C9A883411D50AB7' 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 = '65EFFF76-2E98-4769-9C9A883411D50AB7'
and product_variations.isactive = 1
and product_sizes.id_size = 1408
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '65EFFF76-2E98-4769-9C9A883411D50AB7' 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 = '65EFFF76-2E98-4769-9C9A883411D50AB7' 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 = '65EFFF76-2E98-4769-9C9A883411D50AB7' 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 = '65EFFF76-2E98-4769-9C9A883411D50AB7' 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 = '65EFFF76-2E98-4769-9C9A883411D50AB7' 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 = '65EFFF76-2E98-4769-9C9A883411D50AB7' 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 = '65EFFF76-2E98-4769-9C9A883411D50AB7'
and product_variations.isactive = 1
and product_sizes.id_size = 736
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '65EFFF76-2E98-4769-9C9A883411D50AB7' 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 = '65EFFF76-2E98-4769-9C9A883411D50AB7' 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 = '65EFFF76-2E98-4769-9C9A883411D50AB7' 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 = '65EFFF76-2E98-4769-9C9A883411D50AB7' 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 = '65EFFF76-2E98-4769-9C9A883411D50AB7' 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 = '65EFFF76-2E98-4769-9C9A883411D50AB7' 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 = '65EFFF76-2E98-4769-9C9A883411D50AB7'
and product_variations.isactive = 1
and product_sizes.id_size = 737
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '65EFFF76-2E98-4769-9C9A883411D50AB7' 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 = '65EFFF76-2E98-4769-9C9A883411D50AB7' 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 = '65EFFF76-2E98-4769-9C9A883411D50AB7' 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 = '65EFFF76-2E98-4769-9C9A883411D50AB7' 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 = '65EFFF76-2E98-4769-9C9A883411D50AB7' 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 = '65EFFF76-2E98-4769-9C9A883411D50AB7' 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 = '65EFFF76-2E98-4769-9C9A883411D50AB7'
and product_variations.isactive = 1
and product_sizes.id_size = 738
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '65EFFF76-2E98-4769-9C9A883411D50AB7' 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 = '65EFFF76-2E98-4769-9C9A883411D50AB7' 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 = '65EFFF76-2E98-4769-9C9A883411D50AB7' 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 = '65EFFF76-2E98-4769-9C9A883411D50AB7' 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 = '65EFFF76-2E98-4769-9C9A883411D50AB7' 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 = '65EFFF76-2E98-4769-9C9A883411D50AB7' 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 = '65EFFF76-2E98-4769-9C9A883411D50AB7'
and product_variations.isactive = 1
and product_sizes.id_size = 739
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '65EFFF76-2E98-4769-9C9A883411D50AB7' 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 = '65EFFF76-2E98-4769-9C9A883411D50AB7' 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 = '65EFFF76-2E98-4769-9C9A883411D50AB7' 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 = '65EFFF76-2E98-4769-9C9A883411D50AB7' 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 = '65EFFF76-2E98-4769-9C9A883411D50AB7' 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 = '65EFFF76-2E98-4769-9C9A883411D50AB7' 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 = '65EFFF76-2E98-4769-9C9A883411D50AB7'
and product_variations.isactive = 1
and product_sizes.id_size = 740
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '65EFFF76-2E98-4769-9C9A883411D50AB7' 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 = '65EFFF76-2E98-4769-9C9A883411D50AB7' 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 = '65EFFF76-2E98-4769-9C9A883411D50AB7' 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 = '65EFFF76-2E98-4769-9C9A883411D50AB7' 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 = '65EFFF76-2E98-4769-9C9A883411D50AB7' 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 = '65EFFF76-2E98-4769-9C9A883411D50AB7' 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 = '65EFFF76-2E98-4769-9C9A883411D50AB7'
and product_variations.isactive = 1
and product_sizes.id_size = 741
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
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
13B02F1C8-29F5-4633-9E7160FCA3DDEE15737black#000000XLXL+48-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerieXL+intlsize99.1250STOCK01000-10000-10-10-10099.125all
2AD4CCB80-974A-4AAF-9E3E02D60D54CADC739black#0000002XL2XL+52-5422-2426-2854-5654-5652-5458-6054-5652-54wlingerie2XL+intlsize99.1250STOCK01000-10000-10-10-10099.125all
363BF6C81-E5A3-4022-9FEA3BB4ABC7DCDB741black#0000003XL3XL+56-5826-2830-3258-6058-6056-5862-6458-6056-58wlingerie3XL+intlsize99.1250STOCK01000-10000-10-10-10099.125all
43B02F1C8-29F5-4633-9E7160FCA3DDEE151408black#000000XLL44-4614-1618-2046-4846-4844-4650-5246-4844-46wlingerieLintlsize99.1250STOCK01000-10000-10-10-10099.125all
53B02F1C8-29F5-4633-9E7160FCA3DDEE15736black#000000XLXL46-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerieXLintlsize99.1250STOCK01000-10000-10-10-10099.125all
6AD4CCB80-974A-4AAF-9E3E02D60D54CADC738black#0000002XL2XL50-5220-2424-2852-5452-5450-5256-5852-5450-52wlingerie2XLintlsize99.1250STOCK01000-10000-10-10-10099.125all
763BF6C81-E5A3-4022-9FEA3BB4ABC7DCDB740black#0000003XL3XL54-5624-2628-3056-5856-5854-5660-6256-5854-56wlingerie3XLintlsize99.1250STOCK01000-10000-10-10-10099.125all
vatrate
number20
warehouse
string