Mein Warenkorb

❌
Gesamtartikel
Zum Warenkorb
Menü
Vedere le dimensioni
Dominatrice: abito Wetlook, potere e seduzione
Doppio clic per ingrandire
SKU: SFBA4245
Domina : Wetlook-Kleid, Macht und Verführung
Stock:

Affermate il vostro potere con questo abito Dominatrix Wetlook. Vestibilità aderente, tessuto elasticizzato e dettagli audaci per un look irresistibile.

Taglia:

Non siete sicuri della taglia da scegliere? Consultare la nostra guida alle taglie

Colore:
Quantità:
44.95 €
Aiuto e consulenza
via chat, facebook o e-mail
Restituzione gratuita
entro 15 giorni *

Abito Wetlook Dominatrix di grande taglia - Diva's Boudoir

Descrizione del prodotto

Incarnate la femme fatale con questo abito Dominatrix Wetlook, un capo di lingerie che farà sicuramente colpo. Realizzato in tessuto elasticizzato di alta qualità, abbraccia le vostre curve con eleganza, creando una silhouette provocante ma sofisticata.

Il collo alto aggiunge un tocco di mistero, mentre le maniche lunghe accentuano sensualmente le braccia. La zip posteriore assicura una vestibilità perfetta e il tessuto effetto pelle bagnata aggiunge un tocco di audacia e ribellione.

  • In evidenza
    • Tessuto elasticizzato di alta qualità e aderente
    • Misterioso collo alto
    • Sensuali maniche lunghe
    • Chiusura con zip sul retro
    • Audace tessuto effetto pelle bagnata

Dettagli tecnici

Dimensioni disponibili

Disponibile da XL+ a XL

Colore disponibile

Nero

Guida alle taglie

Controllare la taglia giusta per voi

Internazionale
  • Petto
  • Fianchi
XL+
  • 106-109
  • 112-115
S
  • 92-94
  • 92-96
M
  • 95-98
  • 97-101
L
  • 99-103
  • 102-106
L/XL
  • 94-107
  • 99-111
XL
  • 103-106
  • 106-112
To Top
Visualizza il carrello
Articoli
Totale articoli
Struct
Entries: 108
actions
Array
available
number-1
brand
stringbewicked
brandcode
stringbdbr
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
stringBewicked
breasts
stringna
careinstructions
string
categories
stringdivasboudoir.cabaret.dresses.all,divasboudoir.lingerie.sexylingerie.babydoll
category
stringdresses
categorygender
stringf
categorymediadatas
Struct
adult
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string615
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/cabaret/dresses1.jpg
type
stringimg
width
string1336
divasboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
fetishboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
latexboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
legsboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
lustboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
private
Struct
height
string1016
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/private/default.jpg
type
stringimg
width
string703
smboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
categorysizerange
stringauto
colorinfos
Query
Template: /system/api/product/colors.cfc:13
Execution Time: 1.51 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 = '048BAB38-81DC-4C37-9DF673CA522C5652'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1blackcolorblakblackblack#000000-11
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 '2025-04-21 19:04:09'}
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
number0
isfirstprice
number0
isfixedprice
number0
ishot
number0
isnew
number0
isonline
number0
isoutletprice
number0
itemprice
number37.4583
itempromo
string
key
stringrobe-wet-look-dominatrix-1858
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-08-01 16:40:10'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 1.17 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','de')
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('048bab38-81dc-4c37-9df673ca522c5652',lcase(cart_actions.linkedproducts)) > 0 and cart_actions.linkedproducts is not null
)
id_actionbrandinglanguagenamecodetypeminimumOrdermaximumOrderminimumItemsmaximumItemsmaximumUseallowedItemsquotasusedCountlinkedproductslinkedthemeslinkedbrandslinkeditemparamsactiveFromactiveToisActive
linkedproducts
Query
Template: /system/api/products.cfc:1305
Execution Time: 2.76 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','de')
and product_categories.language in ('all','de')
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 <> 'SFBA4245'
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
string1629
isprivate
string0
rating
stringall
src
string/photobank/products/bdbr/sfba4245/35153310.jpg
type
stringimg
width
string1127
back
Struct
height
string1633
isprivate
string0
rating
stringall
src
string/photobank/products/bdbr/sfba4245/35156668.jpg
type
stringimg
width
string1130
default
Struct
height
string1768
isprivate
string0
rating
stringall
src
string/photobank/products/bdbr/sfba4245/35155141.jpg
type
stringimg
width
string1223
variations
Struct
colors
Struct
black
Struct
height
string1768
isprivate
string0
rating
stringall
src
string/photobank/products/bdbr/sfba4245/35155141.jpg
type
stringimg
width
string1223
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
mediagallery
string
metadatas
Struct
darkboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
divasboudoir
Struct
de
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Verkörpern Sie die Femme fatale mit diesem Dominatrix Wetlook-Kleid, einem Dessous-Stück, das garantiert alle Köpfe verdrehen wird. Aus hochwertigem Stretchmaterial gefertigt, schmiegt es sich elegant an Ihre Kurven und sorgt für eine provokante und zugleich raffinierte Silhouette.</p> <p class="text-base">Der Stehkragen sorgt für einen geheimnisvollen Touch, während die langen Ärmel Ihre Arme sinnlich betonen. Der Reißverschluss am Rücken sorgt für eine perfekte Passform, und das Material in Nasslederoptik verleiht dem Ganzen einen Hauch von Kühnheit und Rebellion.</p> <ul> <li><strong>Highlights :</strong> <ul> <li>Hochwertiger Stretchstoff, der sich an die Formen anpasst</li> <li>Geheimnisvoller Stehkragen</li> <li>Sinnliche lange Ärmel</li> <li>Reißverschluss am Rücken</li> <li>Kühnes Material in Nasslederoptik</li> </ul> </li> </ul> </div>
guid
stringhttps://dev.divasboudoir.com/de/wetlook-kleid-dominatrix-grosse-grosse--divas-boudoir-schwarz/sfba4245.htm
highlights
string
keypoint
string
keywords
stringKleid in Übergröße, Dessous in Übergröße, Wetlook-Kleid in Übergröße, Wetlook-Dessous in Übergröße, Domina-Kleid, Domina-Dessous, Sexy Dessous in Übergröße, Diva's Boudoir, Wetlook-Material, Eng anliegendes Kleid, Fatale Ausstrahlung
metas
Struct
description
stringZeigen Sie Ihre Macht mit dem Dominatrix Wetlook-Kleid von Diva's Boudoir. Enganliegende Passform, Stretchmaterial und gewagte Details sorgen für einen unwiderstehlichen Look. Schnelle Lieferung.
keywords
stringKleid in Übergröße, Dessous in Übergröße, Wetlook-Kleid in Übergröße, Wetlook-Dessous in Übergröße, Domina-Kleid, Domina-Dessous, Sexy Dessous in Übergröße, Diva's Boudoir, Wetlook-Material, Eng anliegendes Kleid, Fatale Ausstrahlung
title
stringKleid Dominatrix Wetlook Große Größe - Diva's Boudoir
seotitle
stringWetlook-Kleid Dominatrix Große Größe - Diva's Boudoir
seouri
stringwetlook-kleid-dominatrix-grosse-grosse--divas-boudoir-schwarz
specifications
string
stylingtips
string
summary
string<p>Zeigen Sie Ihre Macht mit diesem Dominatrix Wetlook-Kleid. Enge Passform, Stretchmaterial und gewagte Details sorgen für einen unwiderstehlichen Look.</p>
title
stringDomina : Wetlook-Kleid, Macht und Verführung
usageinstructions
string
el
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Ενσαρκώστε τη μοιραία γυναίκα με αυτό το φόρεμα Dominatrix Wetlook, ένα κομμάτι εσωρούχων που σίγουρα θα τραβήξει τα βλέμματα. Κατασκευασμένο από υψηλής ποιότητας ελαστικό ύφασμα, αγκαλιάζει κομψά τις καμπύλες σας, δημιουργώντας μια προκλητική αλλά και εκλεπτυσμένη σιλουέτα.</p> <p class="text-base">Ο όρθιος γιακάς προσθέτει μια πινελιά μυστηρίου, ενώ τα μακριά μανίκια τονίζουν αισθησιακά τα χέρια σας. Το φερμουάρ στην πλάτη εξασφαλίζει τέλεια εφαρμογή, ενώ το ύφασμα με εφέ υγρού δέρματος προσθέτει μια πινελιά τόλμης και επαναστατικότητας.</p> <ul> <li><strong>Highlights</strong> <ul> <li>Υψηλής ποιότητας, εφαρμοστό ελαστικό ύφασμα</li> <li>Μυστηριώδης όρθιος γιακάς</li> <li>Αισθησιακά μακριά μανίκια</li> <li>Κλείσιμο με φερμουάρ στην πλάτη</li> <li>Τολμηρό ύφασμα με εφέ υγρού δέρματος</li> </ul> </li> </ul> </div>
guid
stringhttps://dev.divasboudoir.com/el/forema-dominatrix-grande-taille-wetlook--divas-boudoir-mayro/sfba4245.htm
highlights
string
keypoint
string
keywords
stringΦόρεμα μεγάλου μεγέθους, Εσώρουχα μεγάλου μεγέθους, Φόρεμα wetlook μεγάλου μεγέθους, Εσώρουχα wetlook μεγάλου μεγέθους, Φόρεμα dominatrix, Εσώρουχα dominatrix, Εσώρουχα σέξι μεγάλου μεγέθους, Μπουντουάρ της Ντίβας, Matière wetlook, Φόρεμα moulante, Allure fatale
metas
Struct
description
stringΕπιβεβαιώστε τη δύναμή σας με το φόρεμα Dominatrix Wetlook από το Diva's Boudoir. Στενή εφαρμογή, ελαστικό ύφασμα και τολμηρές λεπτομέρειες για μια ακαταμάχητη εμφάνιση. Γρήγορη παράδοση.
keywords
stringΦόρεμα μεγάλου μεγέθους, Εσώρουχα μεγάλου μεγέθους, Φόρεμα wetlook μεγάλου μεγέθους, Εσώρουχα wetlook μεγάλου μεγέθους, Φόρεμα dominatrix, Εσώρουχα dominatrix, Εσώρουχα σέξι μεγάλου μεγέθους, Μπουντουάρ της Ντίβας, Matière wetlook, Φόρεμα moulante, Allure fatale
title
stringDominatrix Μεγάλο μέγεθος Wetlook φόρεμα - Diva's Boudoir
seotitle
stringΦόρεμα Dominatrix Grande Taille Wetlook - Diva's Boudoir
seouri
stringforema-dominatrix-grande-taille-wetlook--divas-boudoir-mayro
specifications
string
stylingtips
string
summary
string<p>Επιβεβαιώστε τη δύναμή σας με αυτό το φόρεμα Dominatrix Wetlook. Στενή εφαρμογή, ελαστικό ύφασμα και τολμηρές λεπτομέρειες για μια ακαταμάχητη εμφάνιση.</p>
title
stringDominatrix: Wetlook φόρεμα, Δύναμη και Αποπλάνηση
usageinstructions
string
en
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Embody the femme fatale with this Dominatrix Wetlook dress, a lingerie piece that's sure to turn heads. Crafted from high-quality stretch fabric, it hugs your curves with elegance, offering a silhouette that's both provocative and sophisticated.</p> <p class="text-base">The stand-up collar adds a touch of mystery, while the long sleeves highlight your arms with sensuality. The back zipper ensures a perfect fit, and the wet leather-effect fabric adds a note of boldness and rebellion.</p> <ul> <li><strong>Highlights</strong> <ul> <li>High-quality, form-fitting stretch fabric</li> <li>Mysterious stand-up collar</li> <li>Sensual long sleeves</li> <li>Back zipper</li> <li>Bold wet-leather-effect fabric</li> </ul> </li> </ul> </div>
guid
stringhttps://dev.divasboudoir.com/en/wetlook-dress-dominatrix-plus-size--divas-boudoir-black/sfba4245.htm
highlights
string
keypoint
string
keywords
stringDress plus size, Lingerie plus size, Dress wetlook plus size, Lingerie wetlook plus size, Dress dominatrix, Lingerie dominatrix, Lingerie sexy plus size, Diva's Boudoir, Matière wetlook, Dress moulante, Allure fatale
metas
Struct
description
stringAssert your power with the Dominatrix Wetlook dress from Diva's Boudoir. Tight fit, stretch fabric and bold details for an irresistible look. Fast delivery.
keywords
stringDress plus size, Lingerie plus size, Dress wetlook plus size, Lingerie wetlook plus size, Dress dominatrix, Lingerie dominatrix, Lingerie sexy plus size, Diva's Boudoir, Matière wetlook, Dress moulante, Allure fatale
title
stringDominatrix Wetlook Plus Size Dress - Diva's Boudoir
seotitle
stringWetlook Dress Dominatrix Plus Size - Diva's Boudoir
seouri
stringwetlook-dress-dominatrix-plus-size--divas-boudoir-black
specifications
string
stylingtips
string
summary
string<p>Assert your power with this Dominatrix Wetlook dress. Tight fit, stretch fabric and bold details for an irresistible look.</p>
title
stringDominatrix: Wetlook dress, Power and Seduction
usageinstructions
string
es
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Encarna a la mujer fatal con este vestido Dominatrix Wetlook, una prenda de lencería que sin duda atraerá todas las miradas. Confeccionado en tejido elástico de alta calidad, se adapta a tus curvas con elegancia, creando una silueta provocativa pero sofisticada.</p> <p class="text-base">El cuello alto añade un toque de misterio, mientras que las mangas largas acentúan sensualmente tus brazos. La cremallera trasera garantiza un ajuste perfecto, y el tejido efecto piel mojada añade un toque de atrevimiento y rebeldía.</p> <ul> <li><strong>Destacados</strong> <ul> <li>Tejido elástico de gran calidad y ajuste perfecto</li> <li>Misterioso cuello alto</li> <li>Sensuales mangas largas</li> <li>Cremallera trasera</li> <li>Atrevido tejido con efecto cuero mojado</li> </ul> </li> </ul> </div>
guid
stringhttps://dev.divasboudoir.com/es/dominatrix-talla-grande-vestido-mojado--divas-boudoir-negro/sfba4245.htm
highlights
string
keypoint
string
keywords
stringVestido talla grande, Lencería talla grande, Vestido wetlook talla grande, Lencería wetlook talla grande, Vestido dominatrix, Lencería dominatrix, Lencería sexy talla grande, Diva's Boudoir, Matière wetlook, Vestido moulante, Allure fatale
metas
Struct
description
stringAfirma tu poder con el vestido Dominatrix Wetlook de Diva's Boudoir. Corte ajustado, tejido elástico y detalles atrevidos para un look irresistible. Entrega rápida.
keywords
stringVestido talla grande, Lencería talla grande, Vestido wetlook talla grande, Lencería wetlook talla grande, Vestido dominatrix, Lencería dominatrix, Lencería sexy talla grande, Diva's Boudoir, Matière wetlook, Vestido moulante, Allure fatale
title
stringDominatrix talla grande Wetlook Dress - Diva's Boudoir
seotitle
stringDominatrix talla grande vestido mojado - Diva's Boudoir
seouri
stringdominatrix-talla-grande-vestido-mojado--divas-boudoir-negro
specifications
string
stylingtips
string
summary
string<p>Afirma tu poder con este vestido Dominatrix Wetlook. Corte ajustado, tejido elástico y detalles atrevidos para un look irresistible.</p>
title
stringDominatrix: Vestido mojado, poder y seducción
usageinstructions
string
fr
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Incarnez la femme fatale avec cette robe Dominatrix Wetlook, une pi&egrave;ce de lingerie qui ne manquera pas de faire tourner les t&ecirc;tes. Confectionn&eacute;e dans un tissu stretch de haute qualit&eacute;, elle &eacute;pouse vos courbes avec &eacute;l&eacute;gance, offrant une silhouette &agrave; la fois provocante et sophistiqu&eacute;e.</p> <p class="text-base">Son col montant apporte une touche de myst&egrave;re, tandis que ses manches longues soulignent vos bras avec sensualit&eacute;. La fermeture &eacute;clair au dos permet un ajustement parfait, et la mati&egrave;re effet cuir mouill&eacute; ajoute une note d'audace et de r&eacute;bellion.</p> <ul> <li><strong>Points Forts :</strong> <ul> <li>Tissu stretch de haute qualit&eacute; &eacute;pousant les formes</li> <li>Col montant myst&eacute;rieux</li> <li>Manches longues sensuelles</li> <li>Fermeture &eacute;clair au dos</li> <li>Mati&egrave;re effet cuir mouill&eacute; audacieuse</li> </ul> </li> </ul> </div>
guid
stringhttps://dev.divasboudoir.com/fr/robe-wetlook-dominatrix-grande-taille--divas-boudoir-noir/sfba4245.htm
highlights
string
keypoint
string
keywords
stringRobe grande taille, Lingerie grande taille, Robe wetlook grande taille, Lingerie wetlook grande taille, Robe dominatrix, Lingerie dominatrix, Lingerie sexy grande taille, Diva's Boudoir, Matière wetlook, Robe moulante, Allure fatale
metas
Struct
description
stringAffirmez votre pouvoir avec la robe Dominatrix Wetlook de Diva's Boudoir. Coupe moulante, matière stretch et détails audacieux pour une allure irrésistible. Livraison rapide.
keywords
stringRobe grande taille, Lingerie grande taille, Robe wetlook grande taille, Lingerie wetlook grande taille, Robe dominatrix, Lingerie dominatrix, Lingerie sexy grande taille, Diva's Boudoir, Matière wetlook, Robe moulante, Allure fatale
title
stringRobe Dominatrix Wetlook Grande Taille - Diva's Boudoir
seotitle
stringRobe Wetlook Dominatrix Grande Taille - Diva's Boudoir
seouri
stringrobe-wetlook-dominatrix-grande-taille--divas-boudoir-noir
specifications
string
stylingtips
string
summary
string<p>Affirmez votre pouvoir avec cette robe Dominatrix Wetlook. Coupe moulante, mati&egrave;re stretch et d&eacute;tails audacieux pour une allure irr&eacute;sistible.</p>
title
stringDominatrix : Robe Wetlook, Pouvoir et Séduction
usageinstructions
string
it
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Incarnate la femme fatale con questo abito Dominatrix Wetlook, un capo di lingerie che farà sicuramente colpo. Realizzato in tessuto elasticizzato di alta qualità, abbraccia le vostre curve con eleganza, creando una silhouette provocante ma sofisticata.</p> <p class="text-base">Il collo alto aggiunge un tocco di mistero, mentre le maniche lunghe accentuano sensualmente le braccia. La zip posteriore assicura una vestibilità perfetta e il tessuto effetto pelle bagnata aggiunge un tocco di audacia e ribellione.</p> <ul> <li><strong>In evidenza</strong> <ul> <li>Tessuto elasticizzato di alta qualità e aderente</li> <li>Misterioso collo alto</li> <li>Sensuali maniche lunghe</li> <li>Chiusura con zip sul retro</li> <li>Audace tessuto effetto pelle bagnata</li> </ul> </li> </ul> </div>
guid
stringhttps://dev.divasboudoir.com/it/abito-wetlook-dominatrix-di-grande-taglia--divas-boudoir-nero/sfba4245.htm
highlights
string
keypoint
string
keywords
stringAbito taglia grande, Lingerie taglia grande, Abito wetlook taglia grande, Lingerie wetlook taglia grande, Abito da dominatrice, Lingerie da dominatrice, Lingerie sexy taglia grande, Diva's Boudoir, Matière wetlook, Abito moulante, Allure fatale
metas
Struct
description
stringAffermate il vostro potere con l'abito Dominatrix Wetlook di Diva's Boudoir. Vestibilità aderente, tessuto elasticizzato e dettagli audaci per un look irresistibile. Consegna rapida.
keywords
stringAbito taglia grande, Lingerie taglia grande, Abito wetlook taglia grande, Lingerie wetlook taglia grande, Abito da dominatrice, Lingerie da dominatrice, Lingerie sexy taglia grande, Diva's Boudoir, Matière wetlook, Abito moulante, Allure fatale
title
stringAbito Wetlook da dominatrice di taglia grande - Diva's Boudoir
seotitle
stringAbito Wetlook Dominatrix di grande taglia - Diva's Boudoir
seouri
stringabito-wetlook-dominatrix-di-grande-taglia--divas-boudoir-nero
specifications
string
stylingtips
string
summary
string<p>Affermate il vostro potere con questo abito Dominatrix Wetlook. Vestibilità aderente, tessuto elasticizzato e dettagli audaci per un look irresistibile.</p>
title
stringDominatrice: abito Wetlook, potere e seduzione
usageinstructions
string
nl
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Belichaam de femme fatale in deze Dominatrix Wetlook jurk, een lingeriestuk dat zeker de aandacht zal trekken. Het is gemaakt van stretchstof van hoge kwaliteit en omhelst je rondingen op elegante wijze, waardoor een uitdagend maar geraffineerd silhouet ontstaat.</p> <p class="text-base">De opstaande kraag voegt een vleugje mysterie toe, terwijl de lange mouwen je armen sensueel accentueren. De ritssluiting aan de achterkant zorgt voor een perfecte pasvorm en de stof met nat leder-effect voegt een vleugje durf en rebellie toe.</p> <ul> <li><strong>Highlights</strong> <ul> <li>Hoogwaardige, vormvaste stretchstof</li> <li>Mysterieuze hoge kraag</li> <li>Sensuele lange mouwen</li> <li>Ritssluiting achter</li> <li>Gedurfde stof met nat-leder-effect</li> </ul> </li> </ul> </div>
guid
stringhttps://dev.divasboudoir.com/nl/dominatrix-grote-maat-wetlook-jurk--divas-boudoir-zwart/sfba4245.htm
highlights
string
keypoint
string
keywords
stringJurk grote maat, Lingerie grote maat, Jurk wetlook grote maat, Lingerie wetlook grote maat, Jurk dominatrix, Lingerie dominatrix, Lingerie sexy grote maat, Diva's Boudoir, Matière wetlook, Jurk moulante, Allure fatale
metas
Struct
description
stringLaat je macht gelden met de Dominatrix Wetlook jurk van Diva's Boudoir. Strakke pasvorm, stretchstof en gedurfde details voor een onweerstaanbare look. Snelle levering.
keywords
stringJurk grote maat, Lingerie grote maat, Jurk wetlook grote maat, Lingerie wetlook grote maat, Jurk dominatrix, Lingerie dominatrix, Lingerie sexy grote maat, Diva's Boudoir, Matière wetlook, Jurk moulante, Allure fatale
title
stringDominatrix grote maat wetlook jurk - Diva's Boudoir
seotitle
stringDominatrix Grote Maat Wetlook Jurk - Diva's Boudoir
seouri
stringdominatrix-grote-maat-wetlook-jurk--divas-boudoir-zwart
specifications
string
stylingtips
string
summary
string<p>Laat je macht gelden met deze Dominatrix Wetlook jurk. Strakke pasvorm, stretchstof en gedurfde details voor een onweerstaanbare look.</p>
title
stringDominatrix: Wetlook jurk, Macht en Verleiding
usageinstructions
string
pt
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Encarne a femme fatale com este vestido Dominatrix Wetlook, uma peça de lingerie que irá certamente chamar a atenção. Feito de tecido elástico de alta qualidade, abraça as suas curvas com elegância, criando uma silhueta provocante mas sofisticada.</p> <p class="text-base">A gola subida acrescenta um toque de mistério, enquanto as mangas compridas acentuam sensualmente os seus braços. O fecho de correr nas costas garante um ajuste perfeito, e o tecido com efeito de pele molhada acrescenta um toque de ousadia e rebeldia.</p> <ul> <li><strong>Destaques</strong> <ul> <li>Tecido elástico de alta qualidade e ajustado à forma</li> <li>Gola alta misteriosa</li> <li>Mangas compridas sensuais</li> <li>Fecho de correr nas costas</li> <li>Tecido arrojado com efeito de pele molhada</li> </ul> </li> </ul> </div>
guid
stringhttps://dev.divasboudoir.com/pt/vestido-de-dominatrix-grande-taille-wetlook--divas-boudoir-preto/sfba4245.htm
highlights
string
keypoint
string
keywords
stringVestido tamanho grande, Lingerie tamanho grande, Vestido wetlook tamanho grande, Lingerie wetlook tamanho grande, Vestido dominatrix, Lingerie dominatrix, Lingerie sexy tamanho grande, Diva's Boudoir, Matière wetlook, Vestido moulante, Allure fatale
metas
Struct
description
stringAfirme o seu poder com o vestido Dominatrix Wetlook da Diva's Boudoir. Ajuste justo, tecido elástico e detalhes arrojados para um visual irresistível. Entrega rápida.
keywords
stringVestido tamanho grande, Lingerie tamanho grande, Vestido wetlook tamanho grande, Lingerie wetlook tamanho grande, Vestido dominatrix, Lingerie dominatrix, Lingerie sexy tamanho grande, Diva's Boudoir, Matière wetlook, Vestido moulante, Allure fatale
title
stringVestido de dominatrix tamanho grande com teto molhado - Diva's Boudoir
seotitle
stringVestido de Dominatrix Grande Taille Wetlook - Diva's Boudoir
seouri
stringvestido-de-dominatrix-grande-taille-wetlook--divas-boudoir-preto
specifications
string
stylingtips
string
summary
string<p>Afirme o seu poder com este vestido Dominatrix Wetlook. Ajuste justo, tecido elástico e detalhes arrojados para um visual irresistível.</p>
title
stringDominatrix: Vestido Wetlook, Poder e Sedução
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> <p class="text-base">Verkörpern Sie die Femme fatale mit diesem Dominatrix Wetlook-Kleid, einem Dessous-Stück, das garantiert alle Köpfe verdrehen wird. Aus hochwertigem Stretchmaterial gefertigt, schmiegt es sich elegant an Ihre Kurven und sorgt für eine provokante und zugleich raffinierte Silhouette.</p> <p class="text-base">Der Stehkragen sorgt für einen geheimnisvollen Touch, während die langen Ärmel Ihre Arme sinnlich betonen. Der Reißverschluss am Rücken sorgt für eine perfekte Passform, und das Material in Nasslederoptik verleiht dem Ganzen einen Hauch von Kühnheit und Rebellion.</p> <ul> <li><strong>Highlights :</strong> <ul> <li>Hochwertiger Stretchstoff, der sich an die Formen anpasst</li> <li>Geheimnisvoller Stehkragen</li> <li>Sinnliche lange Ärmel</li> <li>Reißverschluss am Rücken</li> <li>Kühnes Material in Nasslederoptik</li> </ul> </li> </ul> </div>
highlights
string
keypoint
string
keywords
stringKleid in Übergröße, Dessous in Übergröße, Wetlook-Kleid in Übergröße, Wetlook-Dessous in Übergröße, Domina-Kleid, Domina-Dessous, Sexy Dessous in Übergröße, Diva's Boudoir, Wetlook-Material, Eng anliegendes Kleid, Fatale Ausstrahlung
metas
Struct
description
stringZeigen Sie Ihre Macht mit dem Dominatrix Wetlook-Kleid von The BDSM Boudoir. Enge Passform, Stretchmaterial und gewagte Details sorgen für einen unwiderstehlichen Look. Schnelle Lieferung.
keywords
stringKleid in Übergröße, Dessous in Übergröße, Wetlook-Kleid in Übergröße, Wetlook-Dessous in Übergröße, Domina-Kleid, Domina-Dessous, Sexy Dessous in Übergröße, Diva's Boudoir, Wetlook-Material, Eng anliegendes Kleid, Fatale Ausstrahlung
title
stringKleid Dominatrix Wetlook Große Größen - The BDSM Boudoir
seotitle
stringWetlook-Kleid Dominatrix Große Größe - The BDSM Boudoir
seouri
stringwetlook-kleid-dominatrix-grosse-grosse--the-bdsm-boudoir-schwarz
specifications
string
stylingtips
string
summary
string<p>Zeigen Sie Ihre Macht mit diesem Dominatrix Wetlook-Kleid. Enge Passform, Stretchmaterial und gewagte Details sorgen für einen unwiderstehlichen Look.</p>
title
stringDomina : Wetlook-Kleid, Macht und Verführung
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Ενσαρκώστε τη μοιραία γυναίκα με αυτό το φόρεμα Dominatrix Wetlook, ένα κομμάτι εσωρούχων που σίγουρα θα τραβήξει τα βλέμματα. Κατασκευασμένο από υψηλής ποιότητας ελαστικό ύφασμα, αγκαλιάζει κομψά τις καμπύλες σας, δημιουργώντας μια προκλητική αλλά και εκλεπτυσμένη σιλουέτα.</p> <p class="text-base">Ο όρθιος γιακάς προσθέτει μια πινελιά μυστηρίου, ενώ τα μακριά μανίκια τονίζουν αισθησιακά τα χέρια σας. Το φερμουάρ στην πλάτη εξασφαλίζει τέλεια εφαρμογή, ενώ το ύφασμα με εφέ υγρού δέρματος προσθέτει μια πινελιά τόλμης και επαναστατικότητας.</p> <ul> <li><strong>Highlights</strong> <ul> <li>Υψηλής ποιότητας, εφαρμοστό ελαστικό ύφασμα</li> <li>Μυστηριώδης όρθιος γιακάς</li> <li>Αισθησιακά μακριά μανίκια</li> <li>Κλείσιμο με φερμουάρ στην πλάτη</li> <li>Τολμηρό ύφασμα με εφέ υγρού δέρματος</li> </ul> </li> </ul> </div>
highlights
string
keypoint
string
keywords
stringΦόρεμα μεγάλου μεγέθους, Εσώρουχα μεγάλου μεγέθους, Φόρεμα wetlook μεγάλου μεγέθους, Εσώρουχα wetlook μεγάλου μεγέθους, Φόρεμα dominatrix, Εσώρουχα dominatrix, Εσώρουχα σέξι μεγάλου μεγέθους, Μπουντουάρ της Ντίβας, Matière wetlook, Φόρεμα moulante, Allure fatale
metas
Struct
description
stringΕπιβεβαιώστε τη δύναμή σας με το φόρεμα Dominatrix Wetlook από το The Bdsm Boudoir. Στενή εφαρμογή, ελαστικό ύφασμα και τολμηρές λεπτομέρειες για μια ακαταμάχητη εμφάνιση. Γρήγορη παράδοση.
keywords
stringΦόρεμα μεγάλου μεγέθους, Εσώρουχα μεγάλου μεγέθους, Φόρεμα wetlook μεγάλου μεγέθους, Εσώρουχα wetlook μεγάλου μεγέθους, Φόρεμα dominatrix, Εσώρουχα dominatrix, Εσώρουχα σέξι μεγάλου μεγέθους, Μπουντουάρ της Ντίβας, Matière wetlook, Φόρεμα moulante, Allure fatale
title
stringΦόρεμα Dominatrix Wetlook Grande Taille - The Bdsm Boudoir
seotitle
stringDominatrix Grande Taille Wetlook φόρεμα - The Bdsm Boudoir
seouri
stringdominatrix-grande-taille-wetlook-forema--the-bdsm-boudoir-mayro
specifications
string
stylingtips
string
summary
string<p>Επιβεβαιώστε τη δύναμή σας με αυτό το φόρεμα Dominatrix Wetlook. Στενή εφαρμογή, ελαστικό ύφασμα και τολμηρές λεπτομέρειες για μια ακαταμάχητη εμφάνιση.</p>
title
stringDominatrix: Wetlook φόρεμα, Δύναμη και Αποπλάνηση
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Embody the femme fatale with this Dominatrix Wetlook dress, a lingerie piece that's sure to turn heads. Made from high-quality stretch fabric, it hugs your curves with elegance, offering a silhouette that's both provocative and sophisticated.</p> <p class="text-base">The stand-up collar adds a touch of mystery, while the long sleeves highlight your arms with sensuality. The back zipper ensures a perfect fit, and the wet leather-effect fabric adds a note of boldness and rebellion.</p> <ul> <li><strong>Highlights</strong> <ul> <li>High-quality, form-fitting stretch fabric</li> <li>Mysterious stand-up collar</li> <li>Sensual long sleeves</li> <li>Back zipper</li> <li>Bold wet-leather-effect fabric</li> </ul> </li> </ul> </div>
highlights
string
keypoint
string
keywords
stringDress plus size, Lingerie plus size, Dress wetlook plus size, Lingerie wetlook plus size, Dress dominatrix, Lingerie dominatrix, Lingerie sexy plus size, Diva's Boudoir, Matière wetlook, Dress moulante, Allure fatale
metas
Struct
description
stringAssert your power with the Dominatrix Wetlook dress from The BDSM Boudoir. Tight fit, stretch fabric and bold details for an irresistible look. Fast delivery.
keywords
stringDress plus size, Lingerie plus size, Dress wetlook plus size, Lingerie wetlook plus size, Dress dominatrix, Lingerie dominatrix, Lingerie sexy plus size, Diva's Boudoir, Matière wetlook, Dress moulante, Allure fatale
title
stringDominatrix Wetlook Plus Size Dress - The BDSM Boudoir
seotitle
stringWetlook Dress Dominatrix Plus Size - The BDSM Boudoir
seouri
stringwetlook-dress-dominatrix-plus-size--the-bdsm-boudoir-black
specifications
string
stylingtips
string
summary
string<p>Assert your power with this Dominatrix Wetlook dress. Tight fit, stretch fabric and bold details for an irresistible look.</p>
title
stringDominatrix: Wetlook dress, Power and Seduction
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Encarna a la mujer fatal con este vestido Dominatrix Wetlook, una prenda de lencería que sin duda atraerá todas las miradas. Confeccionado en tejido elástico de alta calidad, se adapta a tus curvas con elegancia, creando una silueta provocativa pero sofisticada.</p> <p class="text-base">El cuello alto añade un toque de misterio, mientras que las mangas largas acentúan sensualmente tus brazos. La cremallera trasera garantiza un ajuste perfecto, y el tejido efecto piel mojada añade un toque de atrevimiento y rebeldía.</p> <ul> <li><strong>Destacados</strong> <ul> <li>Tejido elástico de alta calidad que se adapta a la forma</li> <li>Misterioso cuello alto</li> <li>Sensuales mangas largas</li> <li>Cremallera trasera</li> <li>Atrevido tejido con efecto cuero mojado</li> </ul> </li> </ul> </div>
highlights
string
keypoint
string
keywords
stringVestido talla grande, Lencería talla grande, Vestido wetlook talla grande, Lencería wetlook talla grande, Vestido dominatrix, Lencería dominatrix, Lencería sexy talla grande, Diva's Boudoir, Matière wetlook, Vestido moulante, Allure fatale
metas
Struct
description
stringAfirma tu poder con el vestido Dominatrix Wetlook de The BDSM Boudoir. Ajuste ceñido, tejido elástico y detalles atrevidos para un look irresistible. Entrega rápida.
keywords
stringVestido talla grande, Lencería talla grande, Vestido wetlook talla grande, Lencería wetlook talla grande, Vestido dominatrix, Lencería dominatrix, Lencería sexy talla grande, Diva's Boudoir, Matière wetlook, Vestido moulante, Allure fatale
title
stringDominatrix Wetlook Talla grande vestido - The BDSM Boudoir
seotitle
stringDominatrix talla grande vestido mojado - The BDSM Boudoir
seouri
stringdominatrix-talla-grande-vestido-mojado--the-bdsm-boudoir-negro
specifications
string
stylingtips
string
summary
string<p>Afirma tu poder con este vestido Dominatrix Wetlook. Corte ajustado, tejido elástico y detalles atrevidos para un look irresistible.</p>
title
stringDominatrix: Vestido mojado, poder y seducción
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Incarnez la femme fatale avec cette robe Dominatrix Wetlook, une pi&egrave;ce de lingerie qui ne manquera pas de faire tourner les t&ecirc;tes. Confectionn&eacute;e dans un tissu stretch de haute qualit&eacute;, elle &eacute;pouse vos courbes avec &eacute;l&eacute;gance, offrant une silhouette &agrave; la fois provocante et sophistiqu&eacute;e.</p> <p class="text-base">Son col montant apporte une touche de myst&egrave;re, tandis que ses manches longues soulignent vos bras avec sensualit&eacute;. La fermeture &eacute;clair au dos permet un ajustement parfait, et la mati&egrave;re effet cuir mouill&eacute; ajoute une note d'audace et de r&eacute;bellion.</p> <ul> <li><strong>Points Forts :</strong> <ul> <li>Tissu stretch de haute qualit&eacute; &eacute;pousant les formes</li> <li>Col montant myst&eacute;rieux</li> <li>Manches longues sensuelles</li> <li>Fermeture &eacute;clair au dos</li> <li>Mati&egrave;re effet cuir mouill&eacute; audacieuse</li> </ul> </li> </ul> </div>
highlights
string
keypoint
string
keywords
stringRobe grande taille, Lingerie grande taille, Robe wetlook grande taille, Lingerie wetlook grande taille, Robe dominatrix, Lingerie dominatrix, Lingerie sexy grande taille, Diva's Boudoir, Matière wetlook, Robe moulante, Allure fatale
metas
Struct
description
stringAffirmez votre pouvoir avec la robe Dominatrix Wetlook de The Bdsm Boudoir. Coupe moulante, matière stretch et détails audacieux pour une allure irrésistible. Livraison rapide.
keywords
stringRobe grande taille, Lingerie grande taille, Robe wetlook grande taille, Lingerie wetlook grande taille, Robe dominatrix, Lingerie dominatrix, Lingerie sexy grande taille, Diva's Boudoir, Matière wetlook, Robe moulante, Allure fatale
title
stringRobe Dominatrix Wetlook Grande Taille - The Bdsm Boudoir
seotitle
stringRobe Wetlook Dominatrix Grande Taille - The Bdsm Boudoir
seouri
stringrobe-wetlook-dominatrix-grande-taille--the-bdsm-boudoir-noir
specifications
string
stylingtips
string
summary
string<p>Affirmez votre pouvoir avec cette robe Dominatrix Wetlook. Coupe moulante, mati&egrave;re stretch et d&eacute;tails audacieux pour une allure irr&eacute;sistible.</p>
title
stringDominatrix : Robe Wetlook, Pouvoir et Séduction
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Incarnate la femme fatale con questo abito Dominatrix Wetlook, un capo di lingerie che farà sicuramente colpo. Realizzato in tessuto elasticizzato di alta qualità, abbraccia le vostre curve con eleganza, creando una silhouette provocante ma sofisticata.</p> <p class="text-base">Il collo alto aggiunge un tocco di mistero, mentre le maniche lunghe accentuano sensualmente le braccia. La zip posteriore assicura una vestibilità perfetta e il tessuto effetto pelle bagnata aggiunge un tocco di audacia e ribellione.</p> <ul> <li><strong>In evidenza</strong> <ul> <li>Tessuto elasticizzato di alta qualità e aderente</li> <li>Misterioso collo alto</li> <li>Sensuali maniche lunghe</li> <li>Chiusura con zip sul retro</li> <li>Audace tessuto effetto pelle bagnata</li> </ul> </li> </ul> </div>
highlights
string
keypoint
string
keywords
stringAbito taglia grande, Lingerie taglia grande, Abito wetlook taglia grande, Lingerie wetlook taglia grande, Abito da dominatrice, Lingerie da dominatrice, Lingerie sexy taglia grande, Diva's Boudoir, Matière wetlook, Abito moulante, Allure fatale
metas
Struct
description
stringAffermate il vostro potere con l'abito Dominatrix Wetlook di The BDSM Boudoir. Vestibilità aderente, tessuto elasticizzato e dettagli audaci per un look irresistibile. Consegna rapida.
keywords
stringAbito taglia grande, Lingerie taglia grande, Abito wetlook taglia grande, Lingerie wetlook taglia grande, Abito da dominatrice, Lingerie da dominatrice, Lingerie sexy taglia grande, Diva's Boudoir, Matière wetlook, Abito moulante, Allure fatale
title
stringAbito da dominatrice Wetlook Taglia Grande - The BDSM Boudoir
seotitle
stringAbito da dominatrice di grande taglia - The BDSM Boudoir
seouri
stringabito-da-dominatrice-di-grande-taglia--the-bdsm-boudoir-nero
specifications
string
stylingtips
string
summary
string<p>Affermate il vostro potere con questo abito Dominatrix Wetlook. Vestibilità aderente, tessuto elasticizzato e dettagli audaci per un look irresistibile.</p>
title
stringDominatrice: abito Wetlook, potere e seduzione
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Belichaam de femme fatale in deze Dominatrix Wetlook jurk, een lingeriestuk dat zeker de aandacht zal trekken. Het is gemaakt van stretchstof van hoge kwaliteit en omhelst je rondingen op elegante wijze, waardoor een uitdagend maar geraffineerd silhouet ontstaat.</p> <p class="text-base">De opstaande kraag voegt een vleugje mysterie toe, terwijl de lange mouwen je armen sensueel accentueren. De ritssluiting aan de achterkant zorgt voor een perfecte pasvorm en de stof met nat leder-effect voegt een vleugje durf en rebellie toe.</p> <ul> <li><strong>Highlights</strong> <ul> <li>Hoogwaardige, vormvaste stretchstof</li> <li>Mysterieuze hoge kraag</li> <li>Sensuele lange mouwen</li> <li>Ritssluiting achter</li> <li>Gedurfde stof met nat-leder-effect</li> </ul> </li> </ul> </div>
highlights
string
keypoint
string
keywords
stringJurk grote maat, Lingerie grote maat, Jurk wetlook grote maat, Lingerie wetlook grote maat, Jurk dominatrix, Lingerie dominatrix, Lingerie sexy grote maat, Diva's Boudoir, Matière wetlook, Jurk moulante, Allure fatale
metas
Struct
description
stringLaat je macht gelden met de Dominatrix Wetlook jurk van The BDSM Boudoir. Strakke pasvorm, stretchstof en gedurfde details voor een onweerstaanbare look. Snelle levering.
keywords
stringJurk grote maat, Lingerie grote maat, Jurk wetlook grote maat, Lingerie wetlook grote maat, Jurk dominatrix, Lingerie dominatrix, Lingerie sexy grote maat, Diva's Boudoir, Matière wetlook, Jurk moulante, Allure fatale
title
stringDominatrix Wetlook Grote Maat Jurk - The BDSM Boudoir
seotitle
stringDominatrix Grote Maat Wetlook Jurk - The BDSM Boudoir
seouri
stringdominatrix-grote-maat-wetlook-jurk--the-bdsm-boudoir-zwart
specifications
string
stylingtips
string
summary
string<p>Laat je macht gelden met deze Dominatrix Wetlook jurk. Strakke pasvorm, stretchstof en gedurfde details voor een onweerstaanbare look.</p>
title
stringDominatrix: Wetlook jurk, Macht en Verleiding
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Encarne a femme fatale com este vestido Dominatrix Wetlook, uma peça de lingerie que irá certamente chamar a atenção. Feito de tecido elástico de alta qualidade, abraça as suas curvas com elegância, criando uma silhueta provocante mas sofisticada.</p> <p class="text-base">A gola subida acrescenta um toque de mistério, enquanto as mangas compridas acentuam sensualmente os seus braços. O fecho de correr nas costas garante um ajuste perfeito, e o tecido com efeito de pele molhada acrescenta um toque de ousadia e rebeldia.</p> <ul> <li><strong>Destaques</strong> <ul> <li>Tecido elástico de alta qualidade e ajustado à forma</li> <li>Misteriosa gola subida</li> <li>Mangas compridas sensuais</li> <li>Fecho de correr nas costas</li> <li>Tecido arrojado com efeito de pele molhada</li> </ul> </li> </ul> </div>
highlights
string
keypoint
string
keywords
stringVestido tamanho grande, Lingerie tamanho grande, Vestido wetlook tamanho grande, Lingerie wetlook tamanho grande, Vestido dominatrix, Lingerie dominatrix, Lingerie sexy tamanho grande, Diva's Boudoir, Matière wetlook, Vestido moulante, Allure fatale
metas
Struct
description
stringAfirme o seu poder com o vestido Dominatrix Wetlook da The Bdsm Boudoir. Ajuste justo, tecido elástico e detalhes arrojados para um visual irresistível. Entrega rápida.
keywords
stringVestido tamanho grande, Lingerie tamanho grande, Vestido wetlook tamanho grande, Lingerie wetlook tamanho grande, Vestido dominatrix, Lingerie dominatrix, Lingerie sexy tamanho grande, Diva's Boudoir, Matière wetlook, Vestido moulante, Allure fatale
title
stringVestido Dominatrix Wetlook Grande Taille - The Bdsm Boudoir
seotitle
stringVestido de Dominatrix Grande Taille Wetlook - The Bdsm Boudoir
seouri
stringvestido-de-dominatrix-grande-taille-wetlook--the-bdsm-boudoir-preto
specifications
string
stylingtips
string
summary
string<p>Afirme o seu poder com este vestido Dominatrix Wetlook. Ajuste justo, tecido elástico e detalhes arrojados para um visual irresistível.</p>
title
stringDominatrix: Vestido Wetlook, Poder e Sedução
usageinstructions
string
name
stringRobe Wet Look Dominatrix 1858
netweight
string
nextshipment
stringtomorrow
ordered
number0
orderidx
number0
origin
string
originalsize
string
packaging
string
productshipment
stringauto
productuid
string048BAB38-81DC-4C37-9DF673CA522C5652
promountil
string
rating
stringnone
recorduid
string048BAB38-81DC-4C37-9DF673CA522C5652
reference
stringSFBA4245
related
string
reserved
string
returned
number0
returnsallowed
number1
section
stringcabaret
shipment
string4to6days
showbrand
number0
sizeinfos
Query
Template: /system/api/product/sizes.cfc:20
Execution Time: 2.97 ms
Record Count: 6
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_sizes.id_size as recorduid, if(intlsize <> '',intlsize,eusize) as size, if(intlsize <> '','intlsize','eusize') as sizetype,
product_variations.color,
if(product_sizes.sizegroup = 'bra',
if(intlsize <> '', cast(intlsize as SIGNED ), cast(eusize as SIGNED ))
,
SUBSTRING_INDEX(intlsize,'-',1)
) as param1,
if(product_sizes.sizegroup = 'bra',
if(intlsize <> '',
MID(intlsize,length(cast(intlsize as SIGNED ))+1,length(intlsize)),
MID(eusize,length(cast(eusize as SIGNED ))+1,length(eusize))
)
,
SUBSTRING_INDEX(intlsize,'-',-1)
) as param2,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as available,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
999999,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as groupavailable,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
product_sizes.gender, product_sizes.sizerange, product_sizes.sizegroup, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize,
product_sizes.bust, product_sizes.waist, product_sizes.hip, product_sizes.underbust, product_sizes.cup, product_sizes.thigh, product_sizes.legheight, product_sizes.bodyheight, product_sizes.bodyweight
from product_sizes
left outer join product_variations on product_sizes.suppliersize = product_variations.size and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
where FIND_IN_SET(product_sizes.id_size,'2247,2248,2249,1278,2250,2301') > 0
and product_variations.productuid = '048BAB38-81DC-4C37-9DF673CA522C5652'
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
12301XL+intlsizeblackXL+XL+-19999990wpluslingerieXLXL+46-4816-1820-2248-5048-5046-4852-5448-5046-48106-109112-115
22247SintlsizeblackSS-19999990wpluslingerieSS34-364-68-1036-3836-3834-3640-4436-3834-3692-9492-96
32248MintlsizeblackMM-19999990wpluslingerieMM38-408-1012-1440-4240-4238-4044-4640-4238-4095-9897-101
42249LintlsizeblackLL-19999990wpluslingerieLL40-4210-1214-1642-4444-4642-4448-5044-4642-4499-103102-106
51278L/XLintlsizeblackL/XLL/XL-19999991wpluslingerieL/XLL/XL42-4412-1416-1844-4644-4642-4448-5044-4642-4494-10774-8699-111
62250XLintlsizeblackXLXL-19999990wpluslingerieXLXL44-4614-1618-2046-4846-4844-4650-5246-4844-46103-106106-112
sizeranges
stringplus,standard
sizes
string2247,2248,2249,1278,2250,2301
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: 60.2 ms
Record Count: 5
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 = '048BAB38-81DC-4C37-9DF673CA522C5652'
and product_variations.isactive = 1
and product_sizes.id_size = 2247
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 = '048BAB38-81DC-4C37-9DF673CA522C5652'
and product_variations.isactive = 1
and product_sizes.id_size = 2248
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 = '048BAB38-81DC-4C37-9DF673CA522C5652'
and product_variations.isactive = 1
and product_sizes.id_size = 2249
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 = '048BAB38-81DC-4C37-9DF673CA522C5652'
and product_variations.isactive = 1
and product_sizes.id_size = 1278
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 = '048BAB38-81DC-4C37-9DF673CA522C5652'
and product_variations.isactive = 1
and product_sizes.id_size = 2250
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 = '048BAB38-81DC-4C37-9DF673CA522C5652'
and product_variations.isactive = 1
and product_sizes.id_size = 2301
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
1048BAB38-81DC-4C37-9DF673CA522C56523BCA5B67-B032-483C-A84448B3DAFBC6342247black#000000SS34-364-68-1036-3836-3834-3640-4436-3834-36wlingerieSintlsize37.45830STOCK01000-10000-10all
2048BAB38-81DC-4C37-9DF673CA522C5652E47957D3-A7E3-4ED4-AA615CCCC5340A242248black#000000MM38-408-1012-1440-4240-4238-4044-4640-4238-40wlingerieMintlsize37.45830STOCK01000-10000-10all
3048BAB38-81DC-4C37-9DF673CA522C565251620F7C-BC0B-4904-ADB4E3F6BDFAB4372249black#000000LL40-4210-1214-1642-4444-4642-4448-5044-4642-44wlingerieLintlsize37.45830STOCK01000-10000-10all
4048BAB38-81DC-4C37-9DF673CA522C56526EFEDE58-D6BF-481B-8DF1AC02827CE4191278black#000000L/XLL/XL42-4412-1416-1844-4644-4642-4448-5044-4642-44wlingerieL/XLintlsize37.45830STOCK01100-1000011all
5048BAB38-81DC-4C37-9DF673CA522C5652D39A1B1A-0EF7-4456-864E29DF1F632B5D2250black#000000XLXL44-4614-1618-2046-4846-4844-4650-5246-4844-46wlingerieXLintlsize37.45830STOCK01000-10000-10all
subcategory
stringall
supplier
number-1
supplierreference
string1858-BLACK
tags
string
themes
stringdark
totalvariations
string
type
stringdefault
unitprice
number37.4583
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 18.6 ms
Record Count: 6
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '048BAB38-81DC-4C37-9DF673CA522C5652' 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 = '048BAB38-81DC-4C37-9DF673CA522C5652' 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 = '048BAB38-81DC-4C37-9DF673CA522C5652' 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 = '048BAB38-81DC-4C37-9DF673CA522C5652' 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 = '048BAB38-81DC-4C37-9DF673CA522C5652' 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 = '048BAB38-81DC-4C37-9DF673CA522C5652' 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 = '048BAB38-81DC-4C37-9DF673CA522C5652'
and product_variations.isactive = 1
and product_sizes.id_size = 2247
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 = '048BAB38-81DC-4C37-9DF673CA522C5652' 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 = '048BAB38-81DC-4C37-9DF673CA522C5652' 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 = '048BAB38-81DC-4C37-9DF673CA522C5652' 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 = '048BAB38-81DC-4C37-9DF673CA522C5652' 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 = '048BAB38-81DC-4C37-9DF673CA522C5652' 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 = '048BAB38-81DC-4C37-9DF673CA522C5652' 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 = '048BAB38-81DC-4C37-9DF673CA522C5652'
and product_variations.isactive = 1
and product_sizes.id_size = 2248
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 = '048BAB38-81DC-4C37-9DF673CA522C5652' 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 = '048BAB38-81DC-4C37-9DF673CA522C5652' 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 = '048BAB38-81DC-4C37-9DF673CA522C5652' 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 = '048BAB38-81DC-4C37-9DF673CA522C5652' 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 = '048BAB38-81DC-4C37-9DF673CA522C5652' 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 = '048BAB38-81DC-4C37-9DF673CA522C5652' 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 = '048BAB38-81DC-4C37-9DF673CA522C5652'
and product_variations.isactive = 1
and product_sizes.id_size = 2249
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 = '048BAB38-81DC-4C37-9DF673CA522C5652' 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 = '048BAB38-81DC-4C37-9DF673CA522C5652' 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 = '048BAB38-81DC-4C37-9DF673CA522C5652' 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 = '048BAB38-81DC-4C37-9DF673CA522C5652' 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 = '048BAB38-81DC-4C37-9DF673CA522C5652' 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 = '048BAB38-81DC-4C37-9DF673CA522C5652' 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 = '048BAB38-81DC-4C37-9DF673CA522C5652'
and product_variations.isactive = 1
and product_sizes.id_size = 1278
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 = '048BAB38-81DC-4C37-9DF673CA522C5652' 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 = '048BAB38-81DC-4C37-9DF673CA522C5652' 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 = '048BAB38-81DC-4C37-9DF673CA522C5652' 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 = '048BAB38-81DC-4C37-9DF673CA522C5652' 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 = '048BAB38-81DC-4C37-9DF673CA522C5652' 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 = '048BAB38-81DC-4C37-9DF673CA522C5652' 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 = '048BAB38-81DC-4C37-9DF673CA522C5652'
and product_variations.isactive = 1
and product_sizes.id_size = 2250
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 = '048BAB38-81DC-4C37-9DF673CA522C5652' 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 = '048BAB38-81DC-4C37-9DF673CA522C5652' 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 = '048BAB38-81DC-4C37-9DF673CA522C5652' 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 = '048BAB38-81DC-4C37-9DF673CA522C5652' 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 = '048BAB38-81DC-4C37-9DF673CA522C5652' 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 = '048BAB38-81DC-4C37-9DF673CA522C5652' 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 = '048BAB38-81DC-4C37-9DF673CA522C5652'
and product_variations.isactive = 1
and product_sizes.id_size = 2301
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
1D39A1B1A-0EF7-4456-864E29DF1F632B5D2301black#000000XLXL+46-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerieXL+intlsize37.45830STOCK01000-10000-10-10-11037.4583all
23BCA5B67-B032-483C-A84448B3DAFBC6342247black#000000SS34-364-68-1036-3836-3834-3640-4436-3834-36wlingerieSintlsize37.45830STOCK01000-10000-10-10-11037.4583all
3E47957D3-A7E3-4ED4-AA615CCCC5340A242248black#000000MM38-408-1012-1440-4240-4238-4044-4640-4238-40wlingerieMintlsize37.45830STOCK01000-10000-10-10-11037.4583all
451620F7C-BC0B-4904-ADB4E3F6BDFAB4372249black#000000LL40-4210-1214-1642-4444-4642-4448-5044-4642-44wlingerieLintlsize37.45830STOCK01000-10000-10-10-11037.4583all
56EFEDE58-D6BF-481B-8DF1AC02827CE4191278black#000000L/XLL/XL42-4412-1416-1844-4644-4642-4448-5044-4642-44wlingerieL/XLintlsize37.45830STOCK01100-1000011-11-11037.4583all
6D39A1B1A-0EF7-4456-864E29DF1F632B5D2250black#000000XLXL44-4614-1618-2046-4846-4844-4650-5246-4844-46wlingerieXLintlsize37.45830STOCK01000-10000-10-10-11037.4583all
vatrate
number20
warehouse
string