Mi cesta

❌
Total de artículos
Ver cesta
Menú
Ver tallas
Bustier Vixen de polipiel
Doble clic para ampliar
SKU: SBBU2383
Bustier Vixen de polipiel
Stock:

Este top de talla grande sin tirantes es muy cómodo de llevar, moldeará tu figura y será un top precioso y sexy para llevar con todos tus conjuntos.

Talla:

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

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

Bustier talla grande en polipiel

Descripción del producto

Bustier Vixen de piel sintética, cómodo y fácil de llevar.

Su corte está especialmente adaptado a nuestras curvas, y sus 14 varillas acrílicas le permiten moldear tu silueta sin comprimirte, para que puedas llevarlo todo el tiempo que quieras.

Sus costuras esculpen visualmente tu cintura.

Cierre delantero con cremallera y lazada tipo corsé en la espalda.

Incluye tanga a juego.

Detalles técnicos

Tallas disponibles

Disponible de 38-40 a 52+

Color disponible

Negro

Guía de tallas

Comprueba cuál es tu talla

Internacional
  • Pecho
  • Talla
  • Caderas
38-40
  • 92-100
  • 74-82
  • 98-106
44-46
  • 102-108
  • 86-92
  • 108-114
48-50
  • 110-116
  • 96-102
  • 116-122
52+
  • 116-126
  • 102-116
  • 122-132
To Top
Ver cesta
Artículos
Total de artículos
Struct
Entries: 108
actions
Array
available
number-1
brand
stringparishollywood
brandcode
stringpuun
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
stringParis Hollywood
breasts
stringna
careinstructions
string
categories
stringdivasboudoir.lingerie.sexylingerie.bustier
category
stringsexylingerie
categorygender
stringf
categorymediadatas
Struct
adult
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string276
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/lingerie/sexylingerie/bustier.jpg
type
stringimg
width
string600
divasboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
fetishboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
latexboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
legsboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
lustboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
private
Struct
height
string1016
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/private/default.jpg
type
stringimg
width
string703
smboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
categorysizerange
stringauto
colorinfos
Query
Template: /system/api/product/colors.cfc:13
Execution Time: 0.76 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 = 'A39EDD7B-DB57-45FA-8CA06E685FE602F4'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1blackcolorblakblackblack#000000-10
colorrange
stringblack
colors
stringblack
colortype
stringcolor
comments
string
compositions
Struct
Entries: 13
coton
string
elastane
string
free
string
leather
string
lycra
string
metal
string
nylon
string
polyamide
string
polyester
string
polyurethane
string
silk
string
spandex
string
viscose
string
datecreated
Date Time (Europe/Paris)
{ts '2023-07-21 12:06:07'}
defect
number0
dimensions
Struct
Entries: 14
acrylicbones
string
backsideheight
string
diameter
string
flatsteelbones
string
frontsideheight
string
fullheight
string
length
string
modestysize
string
panels
string
sides
string
spiralsteelbones
string
totallength
string
unit
stringcm
wiresize
string
display
stringall
displayfrom
string
displayto
string
grossweight
string
hasbrandinfos
booleanfalse
hascareinstructions
booleanfalse
hascolorinfos
booleantrue
hascompositions
booleanfalse
hasdescription
booleantrue
hasdimensions
booleanfalse
hasmaterials
booleanfalse
hasotherspecifications
booleanfalse
haspromo
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
number41.625
itempromo
string
key
string14-pieces-plastic-bones-wholesale-sexy-leather-corset
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-10-22 18:43:07'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.64 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('a39edd7b-db57-45fa-8ca06e685fe602f4',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.3 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 <> 'SBBU2383'
group by products.reference
order by products.ishot desc, products.isnew desc, orderidx asc, products.lastupdated desc
productuidreferencetypekeylanguagenamelinkuidcolorsvatratemetadatasdimensionsmediadatastagsthemesisdivasizetotalvariationsvariationlistinpromohaspromoitempromoitempriceunitpricepricespromountilisfixedpriceishotisneworderidxavailablestockinstockvariationsbrandbrandnameshowbranddisplaysizetypeintlsizesizessizerangecategorymediadatascategorysizerangesectioncategorysubcategory
linkuid
string
materials
string
mediadatas
Struct
alt
Struct
height
string1350
isprivate
string0
rating
stringall
src
string/photobank/products/puun/sbbu2383/img_0227.jpg
type
stringimg
width
string900
back
Struct
height
string1350
isprivate
string0
rating
stringall
src
string/photobank/products/puun/sbbu2383/img_0238.jpg
type
stringimg
width
string900
default
Struct
height
string598
isprivate
string0
rating
stringall
src
string/photobank/products/puun/sbbu2383/illustration_bustier.jpg
type
stringimg
width
string413
variations
Struct
colors
Struct
black
Struct
height
string1350
isprivate
string0
rating
stringall
src
string/photobank/products/puun/sbbu2383/img_0234.jpg
type
stringimg
width
string900
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
stringVixen-Bustier aus Kunstleder, bequem und angenehm zu tragen.<br /><br />Der Schnitt ist speziell auf unsere Kurven abgestimmt und die 14 Acrylst&auml;bchen formen Ihre Silhouette, ohne Sie einzuengen, sodass Sie es so lange tragen k&ouml;nnen, wie Sie m&ouml;chten.<br /><br />Die N&auml;hte formen Ihre Taille optisch.<br /><br />Vorne mit Rei&szlig;verschluss, hinten mit korsett&auml;hnlicher Schn&uuml;rung.<br /><br />Passender String im Lieferumfang enthalten.
guid
stringhttps://dev.divasboudoir.com/de/bustier-in-grosser-grosse-aus-kunstleder-schwarz/sbbu2383.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringEin sehr angenehm zu tragendes Bustier in Übergröße, das Ihnen keine Taillenverkleinerung bietet, aber Ihre Silhouette formt.
keywords
string
title
stringBequemes Bustier aus Kunstleder
seotitle
stringBustier in großer Größe aus Kunstleder
seouri
stringbustier-in-grosser-grosse-aus-kunstleder-schwarz
specifications
string
stylingtips
string
summary
stringEin sehr angenehm zu tragendes Bustier in &Uuml;bergr&ouml;&szlig;e, das Ihre Silhouette formt und ein wundersch&ouml;nes, sexy Oberteil ist, das Sie zu all Ihren Outfits tragen k&ouml;nnen.
title
stringVixen-Bustier aus Kunstleder
usageinstructions
string
el
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringVixen bustier &alpha;&pi;ό &psi;&epsilon;ύ&tau;&iota;&kappa;&omicron; &delta;έ&rho;&mu;&alpha;, ά&nu;&epsilon;&tau;&omicron; &kappa;&alpha;&iota; &epsilon;&upsilon;&kappa;&omicron;&lambda;&omicron;&phi;ό&rho;&epsilon;&tau;&omicron;.<br /><br />&Tau;&omicron; &kappa;ό&psi;&iota;&mu;ό &tau;&omicron;&upsilon; &epsilon;ί&nu;&alpha;&iota; &epsilon;&iota;&delta;&iota;&kappa;ά &pi;&rho;&omicron;&sigma;&alpha;&rho;&mu;&omicron;&sigma;&mu;έ&nu;&omicron; &sigma;&tau;&iota;&sigmaf; &kappa;&alpha;&mu;&pi;ύ&lambda;&epsilon;&sigmaf; &mu;&alpha;&sigmaf; &kappa;&alpha;&iota; &omicron;&iota; 14 &alpha;&kappa;&rho;&upsilon;&lambda;&iota;&kappa;έ&sigmaf; &rho;ά&gamma;&epsilon;&sigmaf; &tau;&omicron;&upsilon; &epsilon;&pi;&iota;&tau;&rho;έ&pi;&omicron;&upsilon;&nu; &nu;&alpha; &delta;&iota;&alpha;&mu;&omicron;&rho;&phi;ώ&nu;&epsilon;&iota; &tau;&eta; &sigma;&iota;&lambda;&omicron;&upsilon;έ&tau;&alpha; &sigma;&alpha;&sigmaf; &chi;&omega;&rho;ί&sigmaf; &nu;&alpha; &sigma;&alpha;&sigmaf; &sigma;&upsilon;&mu;&pi;&iota;έ&zeta;&epsilon;&iota;, ώ&sigma;&tau;&epsilon; &nu;&alpha; &mu;&pi;&omicron;&rho;&epsilon;ί&tau;&epsilon; &nu;&alpha; &tau;&omicron; &phi;&omicron;&rho;ά&tau;&epsilon; &gamma;&iota;&alpha; ό&sigma;&omicron; &kappa;&alpha;&iota;&rho;ό &theta;έ&lambda;&epsilon;&tau;&epsilon;.<br /><br />&Omicron;&iota; &rho;&alpha;&phi;έ&sigmaf; &tau;&omicron;&upsilon; &sigma;&mu;&iota;&lambda;&epsilon;ύ&omicron;&upsilon;&nu; &omicron;&pi;&tau;&iota;&kappa;ά &tau;&eta; &mu;έ&sigma;&eta; &sigma;&alpha;&sigmaf;.<br /><br />&Kappa;&lambda;&epsilon;ί&nu;&epsilon;&iota; &mu;&pi;&rho;&omicron;&sigma;&tau;ά &mu;&epsilon; &phi;&epsilon;&rho;&mu;&omicron;&upsilon;ά&rho;, &kappa;&omicron;&rho;&sigma;έ &mu;&epsilon; &kappa;&omicron;&rho;&delta;ό&nu;&iota;&alpha; &sigma;&tau;&eta;&nu; &pi;&lambda;ά&tau;&eta;.<br /><br />&Pi;&epsilon;&rho;&iota;&lambda;&alpha;&mu;&beta;ά&nu;&epsilon;&tau;&alpha;&iota; &tau;&omicron; &alpha;&sigma;&omicron;&rho;&tau;ί &sigma;&tau;&rho;&iota;&nu;&gamma;&kappa;.
guid
stringhttps://dev.divasboudoir.com/el/megalo-mpoystaki-apo-apomimhsh-dermatos-mayro/sbbu2383.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringΈνα πολύ άνετο μπουστάκι plus-size που δεν θα μειώσει τη μέση σας, αλλά θα διαμορφώσει τη σιλουέτα σας.
keywords
string
title
stringΆνετο μπουστάκι από απομίμηση δέρματος
seotitle
stringΜεγάλο μπουστάκι από απομίμηση δέρματος
seouri
stringmegalo-mpoystaki-apo-apomimhsh-dermatos-mayro
specifications
string
stylingtips
string
summary
string&Alpha;&upsilon;&tau;ό &tau;&omicron; &sigma;&tau;&rho;ά&pi;&lambda;&epsilon;&sigmaf; plus size &tau;&omicron;&pi; &epsilon;ί&nu;&alpha;&iota; &tau;ό&sigma;&omicron; ά&nu;&epsilon;&tau;&omicron; &sigma;&tau;&eta; &chi;&rho;ή&sigma;&eta;, &theta;&alpha; &delta;&iota;&alpha;&mu;&omicron;&rho;&phi;ώ&sigma;&epsilon;&iota; &tau;&eta; &sigma;&iota;&lambda;&omicron;&upsilon;έ&tau;&alpha; &sigma;&alpha;&sigmaf; &kappa;&alpha;&iota; &theta;&alpha; &alpha;&pi;&omicron;&tau;&epsilon;&lambda;έ&sigma;&epsilon;&iota; έ&nu;&alpha; &pi;&alpha;&nu;έ&mu;&omicron;&rho;&phi;&omicron;, &sigma;έ&xi;&iota; &tau;&omicron;&pi; &gamma;&iota;&alpha; &nu;&alpha; &tau;&omicron; &phi;&omicron;&rho;έ&sigma;&epsilon;&tau;&epsilon; &mu;&epsilon; ό&lambda;&alpha; &sigma;&alpha;&sigmaf; &tau;&alpha; &rho;&omicron;ύ&chi;&alpha;.
title
stringVixen μπουστάκι από απομίμηση δέρματος
usageinstructions
string
en
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringVixen bustier in faux leather, comfortable and easy to wear.<br /><br />Its cut is specially adapted to our curves, and its 14 acrylic ribs allow it to style your silhouette without compressing you, so you can wear it for as long as you like.<br /><br />Its seams visually sculpt your waist.<br /><br />Front zipper, corset-style lacing at back.<br /><br />Matching thong included.
guid
stringhttps://dev.divasboudoir.com/en/plus-size-bustier-in-imitation-leather-black/sbbu2383.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringA wearable plus size bustier that won't reduce your waist but will shape your silhouette.
keywords
string
title
stringComfortable bustier in imitation leather
seotitle
stringPlus size bustier in imitation leather
seouri
stringplus-size-bustier-in-imitation-leather-black
specifications
string
stylingtips
string
summary
stringA wearable plus size strapless top that'll shape your figure and make a gorgeous, sexy top to wear with all your outfits.
title
stringVixen bustier in imitation leather
usageinstructions
string
es
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringBustier Vixen de piel sint&eacute;tica, c&oacute;modo y f&aacute;cil de llevar.<br /><br />Su corte est&aacute; especialmente adaptado a nuestras curvas, y sus 14 varillas acr&iacute;licas le permiten moldear tu silueta sin comprimirte, para que puedas llevarlo todo el tiempo que quieras.<br /><br />Sus costuras esculpen visualmente tu cintura.<br /><br />Cierre delantero con cremallera y lazada tipo cors&eacute; en la espalda.<br /><br />Incluye tanga a juego.
guid
stringhttps://dev.divasboudoir.com/es/bustier-talla-grande-en-polipiel-negro/sbbu2383.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringUn corpiño de talla grande muy cómodo que no reducirá tu cintura pero moldeará tu silueta.
keywords
string
title
stringCómodo corpiño de polipiel
seotitle
stringBustier talla grande en polipiel
seouri
stringbustier-talla-grande-en-polipiel-negro
specifications
string
stylingtips
string
summary
stringEste top de talla grande sin tirantes es muy c&oacute;modo de llevar, moldear&aacute; tu figura y ser&aacute; un top precioso y sexy para llevar con todos tus conjuntos.
title
stringBustier Vixen de polipiel
usageinstructions
string
fr
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>Bustier Vixen en similicuir, confortable et agr&eacute;able &agrave; porter.<br><br>Sa coupe est sp&eacute;cialement adapt&eacute;e &agrave; nos rondeurs, et ses 14 baleines en acrylique lui permettent de styliser votre silhouette sans vous comprimer, vous pourrez le porter aussi longtemps que vous le d&eacute;sirez.<br><br>Ses coutures sculptent visuellement votre taille.&nbsp;<br><br>Fermeture &eacute;clair &agrave; l'avant, la&ccedil;age type corset &agrave; l'arri&egrave;re.<br><br>String assorti inclus.</p>
guid
stringhttps://dev.divasboudoir.com/fr/bustier-grande-taille-en-similicuir-noir/sbbu2383.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringUn bustier grande taille très agréable à porter, qui ne vous offrira pas de réduction de taille mais galbera votre silhouette.
keywords
string
title
stringBustier confortable en similicuir
seotitle
stringBustier grande taille en similicuir
seouri
stringbustier-grande-taille-en-similicuir-noir
specifications
string
stylingtips
string
summary
string<p>Un bustier grande taille tr&egrave;s agr&eacute;able &agrave; porter, qui galbera votre silhouette et fera un magnifique haut sexy &agrave; porter avec toutes vos tenues.</p>
title
stringBustier Vixen en similicuir
usageinstructions
string
it
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringBustier Vixen in ecopelle, comodo e facile da indossare.<br /><br />Il suo taglio &egrave; appositamente adattato alle nostre curve e le 14 stecche in acrilico permettono di modellare la silhouette senza comprimere, in modo da poterlo indossare per tutto il tempo che si desidera.<br /><br />Le cuciture scolpiscono visivamente il punto vita.<br /><br />Chiusura frontale con zip, allacciatura a corsetto sul retro.<br /><br />Perizoma abbinato incluso.
guid
stringhttps://dev.divasboudoir.com/it/grande-bustier-in-similpelle-nero/sbbu2383.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringUn bustier taglia grande molto comodo che non riduce il girovita ma modella la silhouette.
keywords
string
title
stringComodo bustier in similpelle
seotitle
stringGrande bustier in similpelle
seouri
stringgrande-bustier-in-similpelle-nero
specifications
string
stylingtips
string
summary
stringQuesto top senza spalline di taglia grande &egrave; cos&igrave; comodo da indossare, modeller&agrave; la vostra figura e sar&agrave; un top splendido e sexy da indossare con tutti i vostri abiti.
title
stringBustier Vixen in similpelle
usageinstructions
string
nl
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringVixen bustier van kunstleer, comfortabel en gemakkelijk te dragen.<br /><br />De snit is speciaal aangepast aan onze rondingen en de 14 acrylstaven geven je silhouet vorm zonder je samen te drukken, zodat je het zo lang kunt dragen als je wilt.<br /><br />De naden geven je taille optisch vorm.<br /><br />Ritssluiting vooraan, korsetachtige vetersluiting achteraan.<br /><br />Inclusief bijpassende string.
guid
stringhttps://dev.divasboudoir.com/nl/groote-maat-bustier-van-imitatieleer-zwart/sbbu2383.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringEen zeer comfortabele bustier van groote maat die je taille niet vermindert, maar je silhouet vorm geeft.
keywords
string
title
stringComfortabele bustier van imitatieleer
seotitle
stringGroote maat bustier van imitatieleer
seouri
stringgroote-maat-bustier-van-imitatieleer-zwart
specifications
string
stylingtips
string
summary
stringDit strapless topje van groote maat is zo comfortabel om te dragen, het geeft je figuur vorm en is een prachtig, sexy topje om bij al je outfits te dragen.
title
stringVixen bustier van imitatieleer
usageinstructions
string
pt
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringCorpete Vixen em pele sint&eacute;tica, confort&aacute;vel e f&aacute;cil de usar.<br /><br />O seu corte est&aacute; especialmente adaptado &agrave;s nossas curvas e os seus 14 encaixes em acr&iacute;lico permitem-lhe modelar a sua silhueta sem a comprimir, para que possa us&aacute;-lo durante o tempo que quiser.<br /><br />As suas costuras esculpem visualmente a cintura.<br /><br />Fecho de correr &agrave; frente, la&ccedil;o tipo espartilho nas costas.<br /><br />Tanga a condizer inclu&iacute;da.
guid
stringhttps://dev.divasboudoir.com/pt/corpete-grande-em-imitacao-de-pele-preto/sbbu2383.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringUm corpete plus size muito confortável que não reduz a cintura mas modela a silhueta.
keywords
string
title
stringCorpete confortável em imitação de pele
seotitle
stringCorpete grande em imitação de pele
seouri
stringcorpete-grande-em-imitacao-de-pele-preto
specifications
string
stylingtips
string
summary
stringEste top plus size sem al&ccedil;as &eacute; t&atilde;o confort&aacute;vel de usar, vai moldar a sua figura e fazer um top lindo e sexy para usar com todos os seus trajes.
title
stringCorpete Vixen em imitação de pele
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<div> <div><strong>Vixen-Bustier: Die Rüstung der modernen Domina</strong></div> <p class="text-base">Das Vixen-Bustier ist mehr als nur ein Kleidungsstück: Es ist ein Statement der Macht. Aus sinnlichem Kunstleder gefertigt, schmiegt es sich an Ihre Kurven und unterstreicht Ihre Autorität auf elegante Weise. Machen Sie sich bereit, alle Blicke auf sich zu ziehen.</p> <p class="text-base"><strong>Wichtigste Merkmale :</strong></p> <ul> <li><strong>Sinnliches Kunstleder:</strong> Weicher Griff und provokanter Look.</li> <li><strong>Schmeichelnder Schnitt:</strong> Betont die Brust und lässt die Taille schlanker wirken.</li> <li><strong>14 Acryl-Walfisch:</strong> Strukturiert die Silhouette, ohne den Tragekomfort zu beeinträchtigen.</li> <li><strong>Vorderer Reißverschluss :</strong> Erleichtert das An- und Ausziehen und ermöglicht einen schnellen Wechsel des Outfits.</li> <li><strong>Hintere Korsettschnürung:</strong> Bietet eine individuelle Passform und perfekten Halt für eine wohlgeformte Silhouette.</li> <li><strong>Inklusive passendem String:</strong> Für ein komplettes und verführerisches BDSM-Set.</li> </ul> <p class="text-base"><strong>Verwendung &amp; Spielideen :</strong></p> <p class="text-base">Tragen Sie dieses Vixen-Bustier bei Ihren BDSM-Sitzungen, bei einem Fotoshooting oder bei einer Party, die im Zeichen der Dominanz steht. Kombinieren Sie es mit einer Lederhose, hochhackigen Stiefeln und Bondage-Accessoires für einen unwiderstehlichen Look.</p> <p class="text-base"><strong>Zusammensetzung :</strong></p> <ul> <li>Kunstleder</li> <li>Acryl</li> </ul> </div>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringDominieren Sie stilvoll mit dem Vixen-Bustier aus Kunstleder. Ein Stück BDSM-Lingerie, das Ihre Silhouette betont und Ihre Macht unterstreicht. Der String ist im Lieferumfang enthalten. Bestellen Sie bei The BDSM Boudoir!
keywords
string
title
stringBustier Vixen Kunstleder | BDSM Dessous | The BDSM Boudoir
seotitle
stringBustier Vixen Kunstleder | BDSM Dessous | The BDSM Boudoir
seouri
stringbustier-vixen-kunstleder-|-bdsm-dessous-|-the-bdsm-boudoir-schwarz
specifications
string
stylingtips
string
summary
string<p>Dominieren Sie stilvoll mit diesem Vixen-Bustier aus Kunstleder. Ein Stück BDSM-Lingerie, das Ihre Silhouette betont und gleichzeitig Ihre Macht bekräftigt. Passender String im Lieferumfang enthalten.</p>
title
stringVixen-Bustier aus Kunstleder - Dominanz & sinnliche Silhouette
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<div> <div><strong>Vixen Bustier: Η πανοπλία της σύγχρονης Dominatrix</strong></div> <p class="text-base">Το Vixen bustier είναι κάτι περισσότερο από ένα απλό ρούχο: είναι μια δήλωση δύναμης. Κατασκευασμένο από αισθησιακό faux leather, αγκαλιάζει τις καμπύλες σας και επιβεβαιώνει την εξουσία σας με κομψότητα. Ετοιμαστείτε να γίνετε το επίκεντρο της προσοχής.</p> <p class="text-base"><strong>Βασικά χαρακτηριστικά: Το φουστάνι είναι ένα από τα πιο εντυπωσιακά σουτιέν που έχει ποτέ φορεθεί:</strong></p> <ul> <li><strong>Αισθησιακό faux leather:</strong> απαλή αίσθηση και προκλητική εμφάνιση.</li> <li><strong>Κολακευτική εφαρμογή:</strong> Ενισχύει το μπούστο και αδυνατίζει τη μέση.</li> <li><strong>14 Ακρυλικά stays:</strong> Δομούν τη σιλουέτα χωρίς να διακυβεύεται η άνεση.</li> <li><strong>Μπροστινό φερμουάρ:</strong> Κάνει εύκολη την τοποθέτηση και την αφαίρεση, για γρήγορες αλλαγές στο ντύσιμο.</li> <li><strong>Πίσω κορσέ με κορδόνια</strong>: Προσφέρει εξατομικευμένη εφαρμογή και τέλεια στήριξη για μια σμιλεμένη σιλουέτα.</li> <li><strong>Συμπεριλαμβάνεται ασορτί στρινγκ:</strong> Για ένα πλήρες και σαγηνευτικό σύνολο BDSM.</li> </ul> <p class="text-base"><strong>Ιδέες χρήσης &amp; παιχνιδιού: Χρησιμοποιήστε το:</strong></p> <p class="text-base">Φορέστε αυτό το μπουστάκι Vixen κατά τη διάρκεια των BDSM συνεδριών σας, για μια φωτογράφιση ή για μια βραδινή έξοδο που θα τεθεί υπό το σήμα της κυριαρχίας. Συνδυάστε το με δερμάτινο παντελόνι, ψηλοτάκουνες μπότες και αξεσουάρ bondage για μια ακαταμάχητη εμφάνιση.</p> <p class="text-base"><strong>Σύνθεση :</strong></p> <ul> <li>Δερματίνη</li> <li>Ακρυλικό</li> </ul> </div>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringΚυριαρχήστε με στυλ με το στράπλες τοπ Vixen από ψεύτικο δέρμα. Ένα κομμάτι εσωρούχων BDSM που ενισχύει τη σιλουέτα σας και επιβεβαιώνει τη δύναμή σας. Περιλαμβάνεται στρινγκ. Παραγγείλετε τώρα στο The Bdsm Boudoir!
keywords
string
title
stringBustier Vixen Similicuir | Εσώρουχα BDSM | The Bdsm Boudoir
seotitle
stringBustier Vixen Similicuir | Εσώρουχα BDSM | The Bdsm Boudoir
seouri
stringbustier-vixen-similicuir-|-eswroycha-bdsm-|-the-bdsm-boudoir-mayro
specifications
string
stylingtips
string
summary
string<p>Κυριαρχήστε με στυλ με αυτό το μπουστάκι Vixen από ψεύτικο δέρμα. Ένα κομμάτι εσωρούχων BDSM που ενισχύει τη σιλουέτα σας, ενώ ταυτόχρονα επιβεβαιώνει τη δύναμή σας. Περιλαμβάνεται το αντίστοιχο στρινγκ.</p>
title
stringBustier Vixen Similicuir - Κυριαρχία & αισθησιακή σιλουέτα
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<div> <div><strong>Vixen Bustier: The Armor of the Modern Dominatrix</strong></div> <p class="text-base">The Vixen bustier is more than just a garment: it's a statement of power. Designed in sensual faux leather, it hugs your curves and asserts your authority with elegance. Prepare to subjugate all eyes.</p> <p class="text-base"><strong>Key features :</strong></p> <ul> <li><strong>Sensual imitation leather:</strong> A soft touch and a provocative allure.</li> <li><strong>Flattering cut:</strong> Enhances the bust and refines the waist.</li> <li><strong>14 Acrylic stays:</strong> Structure the silhouette without compromising comfort.</li> <li><strong>Front zipper:</strong> Facilitates donning and doffing, allowing quick outfit changes.</li> <li><strong>Rear Corset Lacing</strong>: Offers a personalized fit and perfect support for a sculpted silhouette.</li> <li><strong>Matching thong included:</strong> For a complete and seductive BDSM ensemble.</li> </ul> <p class="text-base"><strong>Use &amp; Play Ideas:</strong></p> <p class="text-base">Wear this Vixen bustier during your BDSM sessions, for a photo shoot, or for an evening placed under the sign of domination. Pair it with leather pants, high-heeled boots and bondage accessories for an irresistible look.</p> <p class="text-base"><strong>Composition:</strong></p> <ul> <li>Leatherette</li> <li>Acrylic</li> </ul> </div>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringDominate in style with the Vixen bustier in faux leather. A piece of BDSM lingerie that enhances your figure and asserts your power. Thong included. Order now on The Bdsm Boudoir!
keywords
string
title
stringBustier Vixen Similicuir | Lingerie BDSM | The Bdsm Boudoir
seotitle
stringBustier Vixen Similicuir | Lingerie BDSM | The Bdsm Boudoir
seouri
stringbustier-vixen-similicuir-|-lingerie-bdsm-|-the-bdsm-boudoir-black
specifications
string
stylingtips
string
summary
string<p>Dominate in style with this Vixen bustier in faux leather. A piece of BDSM lingerie that enhances your figure while asserting your power. Matching thong included.</p>
title
stringBustier Vixen Similicuir - Domination & Sensual Silhouette
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<div> <div><strong>Bustier Vixen: la armadura de la dominatrix moderna</strong></div> <p class="text-base">El bustier Vixen es más que una prenda: es una declaración de poder. Fabricado en sensual piel sintética, abraza tus curvas y afirma tu autoridad con elegancia. Prepárate para ser el centro de todas las miradas.</p> <p class="text-base"><strong>Características principales :</strong></p> <ul> <li>Sensual<strong>piel sintética</strong>: tacto suave y aspecto provocativo.</li> <li><strong>Corte favorecedor:</strong> realza el pecho y estiliza la cintura.</li> <li><strong>14 varillas acrílicas:</strong> Estructuran la silueta sin comprometer la comodidad.</li> <li><strong>Cremallera frontal :</strong> Fácil de poner y quitar, para cambiar rápidamente de atuendo.</li> <li><strong>Lazada trasera del corsé</strong>: Ofrece un ajuste personalizado y una sujeción perfecta para esculpir la silueta.</li> <li><strong>Tanga a juego incluido:</strong> Para un conjunto BDSM completo y seductor.</li> </ul> <p class="text-base"><strong>Ideas de uso y juego:</strong></p> <p class="text-base">Ponte este bustier Vixen durante tus sesiones BDSM, para una sesión de fotos o para una noche de fiesta bajo el signo de la dominación. Combínalo con pantalones de cuero, botas de tacón alto y accesorios bondage para conseguir un look irresistible.</p> <p class="text-base"><strong>Composición :</strong></p> <ul> <li>Polipiel</li> <li>Acrílico</li> </ul> </div>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringDomina con estilo con el top sin tirantes Vixen de piel sintética. Una pieza de lencería BDSM que realza tu figura y afirma tu poder. Incluye tanga. ¡Haz tu pedido ahora en The BDSM Boudoir!
keywords
string
title
stringBustier Vixen Similicuir | Lencería BDSM | The BDSM Boudoir
seotitle
stringBustier Vixen Similicuir | Lencería BDSM | The BDSM Boudoir
seouri
stringbustier-vixen-similicuir-|-lenceria-bdsm-|-the-bdsm-boudoir-negro
specifications
string
stylingtips
string
summary
string<p>Domina con estilo con este corpiño Vixen de piel sintética. Una pieza de lencería BDSM que realza tu figura a la vez que afirma tu poder. Incluye tanga a juego.</p>
title
stringBustier Vixen Similicuir - Dominación y Silueta Sensual
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<div> <div><strong>Bustier Vixen : L'Armure de la Dominatrice Moderne</strong></div> <p class="text-base">Le bustier Vixen est bien plus qu'un simple v&ecirc;tement : c'est une d&eacute;claration de pouvoir. Con&ccedil;u en similicuir sensuel, il &eacute;pouse vos courbes et affirme votre autorit&eacute; avec &eacute;l&eacute;gance. Pr&eacute;parez-vous &agrave; subjuguer tous les regards.</p> <p class="text-base"><strong>Caract&eacute;ristiques cl&eacute;s :</strong></p> <ul> <li><strong>Similicuir Sensuel :</strong> Un toucher doux et une allure provocante.</li> <li><strong>Coupe Flatteuse :</strong> Met en valeur la poitrine et affine la taille.</li> <li><strong>14 Baleines en Acrylique :</strong> Structurent la silhouette sans compromettre le confort.</li> <li><strong>Fermeture &Eacute;clair Avant :</strong> Facilite l'enfilage et le retrait, permettant des changements rapides de tenue.</li> <li><strong>La&ccedil;age Corset Arri&egrave;re :</strong> Offre un ajustement personnalis&eacute; et un maintien parfait pour une silhouette sculpt&eacute;e.</li> <li><strong>String Assorti Inclus :</strong> Pour un ensemble BDSM complet et s&eacute;duisant.</li> </ul> <p class="text-base"><strong>Utilisation &amp; Id&eacute;es de Jeu :</strong></p> <p class="text-base">Portez ce bustier Vixen lors de vos s&eacute;ances de BDSM, pour un shooting photo, ou pour une soir&eacute;e plac&eacute;e sous le signe de la domination. Associez-le &agrave; un pantalon en cuir, des bottes &agrave; talons hauts et des accessoires de bondage pour un look irr&eacute;sistible.</p> <p class="text-base"><strong>Composition :</strong></p> <ul> <li>Similicuir</li> <li>Acrylique</li> </ul> </div>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringDominez avec style grâce au bustier Vixen en similicuir. Une pièce de lingerie BDSM qui sublime votre silhouette et affirme votre pouvoir. String inclus. Commandez sur The Bdsm Boudoir !
keywords
string
title
stringBustier Vixen Similicuir | Lingerie BDSM | The Bdsm Boudoir
seotitle
stringBustier Vixen Similicuir | Lingerie BDSM | The Bdsm Boudoir
seouri
stringbustier-vixen-similicuir-|-lingerie-bdsm-|-the-bdsm-boudoir-noir
specifications
string
stylingtips
string
summary
string<p>Dominez avec style gr&acirc;ce &agrave; ce bustier Vixen en similicuir. Une pi&egrave;ce de lingerie BDSM qui sublime votre silhouette tout en affirmant votre pouvoir. String assorti inclus.</p>
title
stringBustier Vixen Similicuir - Domination & Silhouette Sensuelle
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<div> <div><strong>Bustier Vixen: l'armatura della dominatrice moderna</strong></div> <p class="text-base">Il bustier Vixen è più di un semplice indumento: è una dichiarazione di potere. Realizzato in sensuale ecopelle, abbraccia le vostre curve e afferma la vostra autorità con eleganza. Preparatevi ad essere al centro dell'attenzione.</p> <p class="text-base"><strong>Caratteristiche principali:</strong></p> <ul> <li><strong>Sensuale ecopelle:</strong> sensazione di morbidezza e look provocante.</li> <li><strong>Vestibilità comoda:</strong> valorizza il seno e snellisce la vita.</li> <li><strong>14 stecche in acrilico:</strong> strutturano la silhouette senza compromettere il comfort.</li> <li><strong>Zip frontale:</strong> Facilita l'indossamento e la rimozione, per un rapido cambio d'abito.</li> <li><strong>Allacciatura posteriore del corsetto</strong>: offre una vestibilità personalizzata e un sostegno perfetto per una silhouette scolpita.</li> <li><strong>Perizoma coordinato incluso:</strong> per un insieme BDSM completo e seducente.</li> </ul> <p class="text-base"><strong>Idee di utilizzo e gioco:</strong></p> <p class="text-base">Indossate questo bustier Vixen durante le vostre sessioni BDSM, per un servizio fotografico o per una serata all'insegna della dominazione. Abbinatelo a pantaloni di pelle, stivali con tacco alto e accessori bondage per un look irresistibile.</p> <p class="text-base"><strong>Composizione :</strong></p> <ul> <li>Similpelle</li> <li>Acrilico</li> </ul> </div>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringDominate con stile con il top senza spalline Vixen in ecopelle. Un capo di lingerie BDSM che esalta la vostra figura e afferma il vostro potere. Perizoma incluso. Ordina ora su The BDSM Boudoir!
keywords
string
title
stringBustier Vixen Similicuir | Lingerie BDSM | The BDSM Boudoir
seotitle
stringBustier Vixen Similicuir | Lingerie BDSM | The BDSM Boudoir
seouri
stringbustier-vixen-similicuir-|-lingerie-bdsm-|-the-bdsm-boudoir-nero
specifications
string
stylingtips
string
summary
string<p>Dominate con stile con questo bustier Vixen in ecopelle. Un capo di lingerie BDSM che esalta la vostra figura e afferma il vostro potere. Perizoma abbinato incluso.</p>
title
stringBustier Vixen Similicuir - Silhouette di dominazione e sensualità
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<div> <div><strong>Vixen Bustier: Het harnas van de moderne dominatrix</strong></div> <p class="text-base">De Vixen bustier is meer dan alleen een kledingstuk: het is een statement van macht. Gemaakt van sensueel kunstleer, omhelst het je rondingen en laat je elegantie zien. Bereid je voor om in het middelpunt van de belangstelling te staan.</p> <p class="text-base"><strong>Belangrijkste kenmerken :</strong></p> <ul> <li><strong>Sensueel kunstleer:</strong> voelt zacht aan en ziet er uitdagend uit.</li> <li><strong>Flatterende pasvorm:</strong> Vergroot de buste en maakt de taille slanker.</li> <li><strong>14 Acrylstrengen:</strong> structureren het silhouet zonder afbreuk te doen aan het comfort.</li> <li><strong>Ritssluiting aan de voorkant:</strong> Gemakkelijk aan en uit te trekken voor snelle outfitwisselingen.</li> <li><strong>Korsetrijgsluiting achter</strong>: Biedt een persoonlijke pasvorm en perfecte ondersteuning voor een gebeeldhouwd silhouet.</li> <li><strong>Inclusief bijpassende string:</strong> Voor een compleet en verleidelijk BDSM ensemble.</li> </ul> <p class="text-base"><strong>Gebruik &amp; Speel Ideeën:</strong></p> <p class="text-base">Draag deze Vixen bustier tijdens je BDSM-sessies, voor een fotoshoot of voor een avondje uit in het teken van dominantie. Combineer het met een leren broek, laarzen met hoge hakken en bondage-accessoires voor een onweerstaanbare look.</p> <p class="text-base"><strong>Samenstelling :</strong></p> <ul> <li>Kunstleer</li> <li>Acryl</li> </ul> </div>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringDomineer in stijl met de Vixen strapless top van kunstleer. Een BDSM-lingerie die je figuur verbetert en je macht laat gelden. String inbegrepen. Bestel nu op The BDSM Boudoir!
keywords
string
title
stringBustier Vixen Similicuir | Lingerie BDSM | The BDSM Boudoir
seotitle
stringGroote maat bustier van imitatieleer
seouri
stringgroote-maat-bustier-van-imitatieleer-zwart
specifications
string
stylingtips
string
summary
string<p>Domineer in stijl met deze Vixen bustier van kunstleer. Een stukje BDSM-lingerie dat je figuur verbetert en tegelijkertijd je macht laat gelden. Inclusief bijpassende string.</p>
title
stringVixen bustier van imitatieleer
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<div> <div><strong>Corpete Vixen: A armadura da dominatrix moderna</strong></div> <p class="text-base">O corpete Vixen é mais do que uma simples peça de vestuário: é uma declaração de poder. Feito de pele sintética sensual, abraça as suas curvas e afirma a sua autoridade com elegância. Prepare-se para ser o centro das atenções.</p> <p class="text-base"><strong>Caraterísticas principais :</strong></p> <ul> <li><strong>Pele sintética sensual:</strong> Um toque suave e um aspeto provocante.</li> <li><strong>Ajuste lisonjeiro:</strong> Realça o busto e adelgaça a cintura.</li> <li><strong>14 Bainhas em acrílico:</strong> estruturam a silhueta sem comprometer o conforto.</li> <li><strong>Fecho de correr à frente :</strong> Facilita a colocação e a remoção, para mudanças rápidas de roupa.</li> <li><strong>Laço traseiro do espartilho</strong>: Oferece um ajuste personalizado e um apoio perfeito para uma silhueta esculpida.</li> <li><strong>Tanga a condizer incluída:</strong> Para um conjunto BDSM completo e sedutor.</li> </ul> <p class="text-base"><strong>Ideias para usar e brincar:</strong></p> <p class="text-base">Use este corpete Vixen durante as suas sessões de BDSM, para uma sessão fotográfica ou para uma saída nocturna sob o signo da dominação. Combine-o com calças de couro, botas de salto alto e acessórios bondage para um look irresistível.</p> <p class="text-base"><strong>Composição :</strong></p> <ul> <li>Couro sintético</li> <li>Acrílico</li> </ul> </div>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringDomine em grande estilo com o top sem alças Vixen em pele sintética. Uma peça de lingerie BDSM que realça a sua figura e afirma o seu poder. Tanga incluída. Encomende já no The Bdsm Boudoir!
keywords
string
title
stringBustier Vixen Similicuir | Lingerie BDSM | The Bdsm Boudoir
seotitle
stringBustier Vixen Similicuir | Lingerie BDSM | The Bdsm Boudoir
seouri
stringbustier-vixen-similicuir-|-lingerie-bdsm-|-the-bdsm-boudoir-preto
specifications
string
stylingtips
string
summary
string<p>Domine em grande estilo com este corpete Vixen em pele sintética. Uma peça de lingerie BDSM que realça a sua figura enquanto afirma o seu poder. Tanga a condizer incluída.</p>
title
stringBustier Vixen Similicuir - Dominação e silhueta sensual
usageinstructions
string
name
string14 Pieces Plastic Bones Wholesale sexy leather corset
netweight
string
nextshipment
stringtoday
ordered
number5
orderidx
number0
origin
string
originalsize
string
packaging
string
productshipment
stringauto
productuid
stringA39EDD7B-DB57-45FA-8CA06E685FE602F4
promountil
string
rating
stringnone
recorduid
stringA39EDD7B-DB57-45FA-8CA06E685FE602F4
reference
stringSBBU2383
related
string
reserved
string
returned
number0
returnsallowed
number1
section
stringlingerie
shipment
string5to7days
showbrand
number0
sizeinfos
Query
Template: /system/api/product/sizes.cfc:20
Execution Time: 1.28 ms
Record Count: 4
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_sizes.id_size as recorduid, if(intlsize <> '',intlsize,eusize) as size, if(intlsize <> '','intlsize','eusize') as sizetype,
product_variations.color,
if(product_sizes.sizegroup = 'bra',
if(intlsize <> '', cast(intlsize as SIGNED ), cast(eusize as SIGNED ))
,
SUBSTRING_INDEX(intlsize,'-',1)
) as param1,
if(product_sizes.sizegroup = 'bra',
if(intlsize <> '',
MID(intlsize,length(cast(intlsize as SIGNED ))+1,length(intlsize)),
MID(eusize,length(cast(eusize as SIGNED ))+1,length(eusize))
)
,
SUBSTRING_INDEX(intlsize,'-',-1)
) as param2,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as available,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
999999,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as groupavailable,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
product_sizes.gender, product_sizes.sizerange, product_sizes.sizegroup, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize,
product_sizes.bust, product_sizes.waist, product_sizes.hip, product_sizes.underbust, product_sizes.cup, product_sizes.thigh, product_sizes.legheight, product_sizes.bodyheight, product_sizes.bodyweight
from product_sizes
left outer join product_variations on product_sizes.suppliersize = product_variations.size and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
where FIND_IN_SET(product_sizes.id_size,'1093,1137,1136,1116,1888') > 0
and product_variations.productuid = 'A39EDD7B-DB57-45FA-8CA06E685FE602F4'
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
1109338-40intlsizeblack3840-19999990wpluslingerieM-L38-4038-408-1012-1440-4240-4238-4044-4640-4238-4092-10074-8298-106
2113744-46intlsizeblack4446-19999990wpluslingerieXL-2XL44-4644-4614-1618-2246-4846-4844-4650-5246-4844-46102-10886-92108-114
3113648-50intlsizeblack4850-19999990wpluslingerie3XL-4XL48-5048-5018-2022-2450-5250-5248-5054-5650-5248-50110-11696-102116-122
4111652+intlsizeblack52+52+-19999990wpluslingerie5XL-6XL52+52-5422-2426-2854-5654-5652-5458-6054-5652-54116-126102-116122-132
sizeranges
stringplus,standard
sizes
string1093,1137,1136,1116,1888
sizetype
stringauto
specifications
Struct
Entries: 23
belly
string
bones
string
bra
string
breasts
string
bust
string
closing
string
crochtless
string
cups
string
cut
string
garter
string
halter
string
lacing
string
lining
string
modestypanel
string
panty
string
sheathing
string
sleeves
string
stocking
string
straps
string
stretch
string
suspenders
string
transparency
string
underwires
string
stock
number0
stocks
Query
Template: /system/api/product/stocks.cfc:25
Execution Time: 6.63 ms
Record Count: 4
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select * from (
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = 'A39EDD7B-DB57-45FA-8CA06E685FE602F4'
and product_variations.isactive = 1
and product_sizes.id_size = 1093
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 = 'A39EDD7B-DB57-45FA-8CA06E685FE602F4'
and product_variations.isactive = 1
and product_sizes.id_size = 1137
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 = 'A39EDD7B-DB57-45FA-8CA06E685FE602F4'
and product_variations.isactive = 1
and product_sizes.id_size = 1136
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 = 'A39EDD7B-DB57-45FA-8CA06E685FE602F4'
and product_variations.isactive = 1
and product_sizes.id_size = 1116
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 = 'A39EDD7B-DB57-45FA-8CA06E685FE602F4'
and product_variations.isactive = 1
and product_sizes.id_size = 1888
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
1A39EDD7B-DB57-45FA-8CA06E685FE602F421072B21-8056-4D96-994F5743CE042CEA1093black#000000M-L38-4038-408-1012-1440-4240-4238-4044-4640-4238-40wlingerie38-40intlsize41.6250STOCK01000-10100A2803A28031115-10all
2A39EDD7B-DB57-45FA-8CA06E685FE602F4C946EB12-127C-400E-95A71366E5DB49251137black#000000XL-2XL44-4644-4614-1618-2246-4846-4844-4650-5246-4844-46wlingerie44-46intlsize41.6250STOCK01000-10100A2803A28031117-10all
3A39EDD7B-DB57-45FA-8CA06E685FE602F42EF9BBC4-03A4-4C66-8ED1D5B98D9475CC1136black#0000003XL-4XL48-5048-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie48-50intlsize41.6250STOCK01000-10400A2803A28031119-10all
4A39EDD7B-DB57-45FA-8CA06E685FE602F43AC6BA32-1698-4C05-B3567CA9BCB53C7A1116black#0000005XL-6XL52+52-5422-2426-2854-5654-5652-5458-6054-5652-54wlingerie52+intlsize41.6250STOCK01000-10000-10all
subcategory
stringbustier
supplier
number-1
supplierreference
stringA2803
tags
string
themes
string
totalvariations
string
type
stringdefault
unitprice
number41.625
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 10.3 ms
Record Count: 4
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = 'A39EDD7B-DB57-45FA-8CA06E685FE602F4' 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 = 'A39EDD7B-DB57-45FA-8CA06E685FE602F4' 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 = 'A39EDD7B-DB57-45FA-8CA06E685FE602F4' 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 = 'A39EDD7B-DB57-45FA-8CA06E685FE602F4' 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 = 'A39EDD7B-DB57-45FA-8CA06E685FE602F4' 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 = 'A39EDD7B-DB57-45FA-8CA06E685FE602F4' 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 = 'A39EDD7B-DB57-45FA-8CA06E685FE602F4'
and product_variations.isactive = 1
and product_sizes.id_size = 1093
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 = 'A39EDD7B-DB57-45FA-8CA06E685FE602F4' 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 = 'A39EDD7B-DB57-45FA-8CA06E685FE602F4' 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 = 'A39EDD7B-DB57-45FA-8CA06E685FE602F4' 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 = 'A39EDD7B-DB57-45FA-8CA06E685FE602F4' 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 = 'A39EDD7B-DB57-45FA-8CA06E685FE602F4' 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 = 'A39EDD7B-DB57-45FA-8CA06E685FE602F4' 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 = 'A39EDD7B-DB57-45FA-8CA06E685FE602F4'
and product_variations.isactive = 1
and product_sizes.id_size = 1137
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 = 'A39EDD7B-DB57-45FA-8CA06E685FE602F4' 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 = 'A39EDD7B-DB57-45FA-8CA06E685FE602F4' 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 = 'A39EDD7B-DB57-45FA-8CA06E685FE602F4' 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 = 'A39EDD7B-DB57-45FA-8CA06E685FE602F4' 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 = 'A39EDD7B-DB57-45FA-8CA06E685FE602F4' 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 = 'A39EDD7B-DB57-45FA-8CA06E685FE602F4' 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 = 'A39EDD7B-DB57-45FA-8CA06E685FE602F4'
and product_variations.isactive = 1
and product_sizes.id_size = 1136
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 = 'A39EDD7B-DB57-45FA-8CA06E685FE602F4' 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 = 'A39EDD7B-DB57-45FA-8CA06E685FE602F4' 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 = 'A39EDD7B-DB57-45FA-8CA06E685FE602F4' 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 = 'A39EDD7B-DB57-45FA-8CA06E685FE602F4' 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 = 'A39EDD7B-DB57-45FA-8CA06E685FE602F4' 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 = 'A39EDD7B-DB57-45FA-8CA06E685FE602F4' 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 = 'A39EDD7B-DB57-45FA-8CA06E685FE602F4'
and product_variations.isactive = 1
and product_sizes.id_size = 1116
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 = 'A39EDD7B-DB57-45FA-8CA06E685FE602F4' 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 = 'A39EDD7B-DB57-45FA-8CA06E685FE602F4' 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 = 'A39EDD7B-DB57-45FA-8CA06E685FE602F4' 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 = 'A39EDD7B-DB57-45FA-8CA06E685FE602F4' 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 = 'A39EDD7B-DB57-45FA-8CA06E685FE602F4' 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 = 'A39EDD7B-DB57-45FA-8CA06E685FE602F4' 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 = 'A39EDD7B-DB57-45FA-8CA06E685FE602F4'
and product_variations.isactive = 1
and product_sizes.id_size = 1888
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
121072B21-8056-4D96-994F5743CE042CEA1093black#000000M-L38-4038-408-1012-1440-4240-4238-4044-4640-4238-40wlingerie38-40intlsize41.6250STOCK01000-10100A2803A28031115-10-10-10041.625all
2C946EB12-127C-400E-95A71366E5DB49251137black#000000XL-2XL44-4644-4614-1618-2246-4846-4844-4650-5246-4844-46wlingerie44-46intlsize41.6250STOCK01000-10100A2803A28031117-10-10-10041.625all
32EF9BBC4-03A4-4C66-8ED1D5B98D9475CC1136black#0000003XL-4XL48-5048-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie48-50intlsize41.6250STOCK01000-10400A2803A28031119-10-10-10041.625all
43AC6BA32-1698-4C05-B3567CA9BCB53C7A1116black#0000005XL-6XL52+52-5422-2426-2854-5654-5652-5458-6054-5652-54wlingerie52+intlsize41.6250STOCK01000-10000-10-10-10041.625all
vatrate
number20
warehouse
string