Mon panier

❌
Total articles
Voir le panier
Menu
Voir les tailles
Robe Dark à laçages
Double-cliquez pour agrandir
SKU: CDAC1348
Robe Dark à laçages
Stock:

Que ce soit pour une sortie entre amis, une soirée romantique ou une occasion spéciale, cette sublime robe saura vous accompagner avec style et confiance.

Taille:

Vous ne savez pas quelle taille choisir? Consultez notre guide des tailles

Couleur:
Quantité:
49.95 €
Conseils avisés
par chat, facebook ou par e-mail
Retours gratuits
sous 15 jours *

Robe grande taille en similicuir noir

Description du produit

Découvrez notre magnifique robe en similicuir sans manche avec laçage sensuel sur la poitrine et les cuisses. Fermeture à glissière dans le dos. Un style audacieux et sexy pour toutes les occasions.

La robe Darque à laçages est conçue pour mettre en valeur votre silhouette et vous offrir un look captivant. Sa coupe s'adapte parfaitement aux courbes féminines, soulignant vos atouts avec élégance.

Le tissu Wetlook (similicuir élastique) de haute qualité confère à cette robe une allure sensuelle, attirant tous les regards. Le laçage subtil sur la poitrine et les cuisses ajoute une touche de séduction supplémentaire, permettant de doser l'intensité de votre décolleté et de vos jambes.

La fermeture à glissière dans le dos garantit un enfilage facile et surtout, une ouverture facile... 

Détails techniques

Tailles disponibles

Disponible du XL au 3XL

Couleur disponible

Noir

Composition

Polyuréthane 5 %
Polyester 90 %
Elasthanne 5 %

Guide de taille

Vérifiez la taille qui vous convient

International
  • Poitrine
  • Taille
  • Hanches
XL
  • 104-108
  • 80-86
  • 106-110
2XL
  • 108-112
  • 86-92
  • 110-114
3XL
  • 112-114
  • 92-98
  • 114-118
To Top
Voir le panier
Articles
Total articles
Struct
Entries: 108
actions
Array
available
number-1
brand
stringsoisbelle
brandcode
stringswta
branding
stringdivasboudoir,smboudoir
brandmedias
string{"default":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"editorial":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"logo":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""}}
brandmetas
Struct
de
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
el
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
en
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
es
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
fr
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
it
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
nl
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
pt
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
brandname
stringSois Belle
breasts
stringna
careinstructions
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.18 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 = '5D141F23-71D6-4699-BEDC49FD4B95491F'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1blackcolorblakblackblack#000000-13
colorrange
stringblack
colors
stringblack
colortype
stringcolor
comments
string
compositions
Struct
Entries: 13
coton
string
elastane
string5
free
string
leather
string
lycra
string
metal
string
nylon
string
polyamide
string
polyester
string90
polyurethane
string5
silk
string
spandex
string
viscose
string
datecreated
Date Time (Europe/Paris)
{ts '2023-10-23 10:49:23'}
defect
number0
dimensions
Struct
Entries: 14
acrylicbones
string
backsideheight
string
diameter
string
flatsteelbones
string
frontsideheight
string
fullheight
string
length
string
modestysize
string
panels
string
sides
string
spiralsteelbones
string
totallength
string
unit
stringcm
wiresize
string
display
stringall
displayfrom
string
displayto
string
grossweight
string
hasbrandinfos
booleanfalse
hascareinstructions
booleanfalse
hascolorinfos
booleantrue
hascompositions
booleantrue
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
number41.625
itempromo
string
key
string19630-bk
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-09-11 14:21:44'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 1.08 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','fr')
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('5d141f23-71d6-4699-bedc49fd4b95491f',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.22 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','fr')
and product_categories.language in ('all','fr')
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 <> 'CDAC1348'
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
string1815
isprivate
string0
rating
stringall
src
string/photobank/products/swta/cdac1348/32730219.jpg
type
stringimg
width
string1255
back
Struct
height
string1996
isprivate
string0
rating
stringall
src
string/photobank/products/swta/cdac1348/32729871.jpg
type
stringimg
width
string1304
default
Struct
height
string1298
isprivate
string0
rating
stringall
src
string/photobank/products/swta/cdac1348/32729870.jpg
type
stringimg
width
string898
variations
Struct
colors
Struct
black
Struct
height
string1298
isprivate
string0
rating
stringall
src
string/photobank/products/swta/cdac1348/32729870.jpg
type
stringimg
width
string898
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<p><span>Entdecken Sie unser wundersch&ouml;nes &auml;rmelloses Kleid in gro&szlig;en Gr&ouml;&szlig;en aus Kunstleder mit sinnlicher Schn&uuml;rung im Brustbereich und an den Oberschenkeln. Rei&szlig;verschluss im R&uuml;cken. Ein gewagter und sexy Stil f&uuml;r jeden Anlass.</span><br /><br /><span>Das Darque-Kleid mit Schn&uuml;rung wurde entworfen, um Ihre Figur zu betonen und Ihnen einen aufregenden Look zu verleihen. Sein Schnitt passt sich perfekt an die weiblichen Kurven an und betont Ihre Vorz&uuml;ge auf elegante Weise.</span><br /><br /><span>Der hochwertige Wetlook-Stoff (elastisches Kunstleder) verleiht diesem Kleid eine sinnliche Ausstrahlung, die alle Blicke auf sich zieht. Die subtile Schn&uuml;rung im Brustbereich und an den Oberschenkeln sorgt f&uuml;r einen zus&auml;tzlichen verf&uuml;hrerischen Touch, sodass Sie die Intensit&auml;t Ihres Dekollet&eacute;s und Ihrer Beine dosieren k&ouml;nnen.</span><br /><br /><span>Der Rei&szlig;verschluss im R&uuml;cken garantiert ein einfaches Anziehen und vor allem ein leichtes &Ouml;ffnen... </span></p>
guid
stringhttps://dev.divasboudoir.com/de/kleid-in-ubergrosse-aus-schwarzem-kunstleder-schwarz/cdac1348.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringEntdecken Sie unser wunderschönes, ärmelloses Wetlook-Kleid mit sinnlicher Schnürung im Brustbereich und an den Oberschenkeln. Reißverschluss im Rücken. Ein gewagter, sexy Stil für jeden Anlass
keywords
string
title
stringKleid in großen Größen ohne Ärmel. Schnürung an Brust und Oberschenkeln
seotitle
stringKleid in Übergröße aus schwarzem Kunstleder
seouri
stringkleid-in-ubergrosse-aus-schwarzem-kunstleder-schwarz
specifications
string
stylingtips
string
summary
string<p><span>Ob f&uuml;r einen Ausflug mit Freunden, einen romantischen Abend oder einen besonderen Anlass - dieses erhabene Kleid wird Sie stilvoll und selbstbewusst begleiten.</span></p>
title
stringDarque-Kleid mit Schnürung
usageinstructions
string
el
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p><span>&Alpha;&nu;&alpha;&kappa;&alpha;&lambda;ύ&psi;&tau;&epsilon; &tau;&omicron; &pi;&alpha;&nu;έ&mu;&omicron;&rho;&phi;&omicron; &mu;&epsilon;&gamma;ά&lambda;&omicron; &alpha;&mu;ά&nu;&iota;&kappa;&omicron; &phi;ό&rho;&epsilon;&mu;ά &mu;&alpha;&sigmaf; &alpha;&pi;ό &psi;&epsilon;ύ&tau;&iota;&kappa;&omicron; &delta;έ&rho;&mu;&alpha; &mu;&epsilon; &alpha;&iota;&sigma;&theta;&eta;&sigma;&iota;&alpha;&kappa;ά &kappa;&omicron;&rho;&delta;ό&nu;&iota;&alpha; &sigma;&tau;&omicron; &sigma;&tau;ή&theta;&omicron;&sigmaf; &kappa;&alpha;&iota; &tau;&omicron;&upsilon;&sigmaf; &mu;&eta;&rho;&omicron;ύ&sigmaf;. &Kappa;&lambda;&epsilon;ί&nu;&epsilon;&iota; &mu;&epsilon; &phi;&epsilon;&rho;&mu;&omicron;&upsilon;ά&rho; &sigma;&tau;&eta;&nu; &pi;&lambda;ά&tau;&eta;. &Tau;&omicron;&lambda;&mu;&eta;&rho;ό, &sigma;έ&xi;&iota; &sigma;&tau;&upsilon;&lambda; &gamma;&iota;&alpha; &kappa;ά&theta;&epsilon; &pi;&epsilon;&rho;ί&sigma;&tau;&alpha;&sigma;&eta;.</span><br /><br /><span>&Tau;&omicron; &delta;&alpha;&nu;&tau;&epsilon;&lambda;&omega;&tau;ό &phi;ό&rho;&epsilon;&mu;&alpha; Darque έ&chi;&epsilon;&iota; &sigma;&chi;&epsilon;&delta;&iota;&alpha;&sigma;&tau;&epsilon;ί &gamma;&iota;&alpha; &nu;&alpha; &alpha;&nu;&alpha;&delta;&epsilon;&iota;&kappa;&nu;ύ&epsilon;&iota; &tau;&eta; &sigma;&iota;&lambda;&omicron;&upsilon;έ&tau;&alpha; &sigma;&alpha;&sigmaf; &kappa;&alpha;&iota; &nu;&alpha; &sigma;&alpha;&sigmaf; &chi;&alpha;&rho;ί&zeta;&epsilon;&iota; &mu;&iota;&alpha; &sigma;&alpha;&gamma;&eta;&nu;&epsilon;&upsilon;&tau;&iota;&kappa;ή &epsilon;&mu;&phi;ά&nu;&iota;&sigma;&eta;. &Tau;&omicron; &kappa;ό&psi;&iota;&mu;ό &tau;&omicron;&upsilon; &pi;&rho;&omicron;&sigma;&alpha;&rho;&mu;ό&zeta;&epsilon;&tau;&alpha;&iota; &tau;έ&lambda;&epsilon;&iota;&alpha; &sigma;&tau;&iota;&sigmaf; &gamma;&upsilon;&nu;&alpha;&iota;&kappa;&epsilon;ί&epsilon;&sigmaf; &kappa;&alpha;&mu;&pi;ύ&lambda;&epsilon;&sigmaf;, &tau;&omicron;&nu;ί&zeta;&omicron;&nu;&tau;&alpha;&sigmaf; &tau;&alpha; &pi;&rho;&omicron;&sigma;ό&nu;&tau;&alpha; &sigma;&alpha;&sigmaf; &mu;&epsilon; &kappa;&omicron;&mu;&psi;ό&tau;&eta;&tau;&alpha;.</span><br /><br /><span>&Tau;&omicron; &upsilon;&psi;&eta;&lambda;ή&sigmaf; &pi;&omicron;&iota;ό&tau;&eta;&tau;&alpha;&sigmaf; wetlook ύ&phi;&alpha;&sigma;&mu;&alpha; &chi;&alpha;&rho;ί&zeta;&epsilon;&iota; &sigma;&epsilon; &alpha;&upsilon;&tau;ό &tau;&omicron; &phi;ό&rho;&epsilon;&mu;&alpha; &mu;&iota;&alpha; &alpha;&iota;&sigma;&theta;&eta;&sigma;&iota;&alpha;&kappa;ή, &epsilon;&nu;&tau;&upsilon;&pi;&omega;&sigma;&iota;&alpha;&kappa;ή &epsilon;&mu;&phi;ά&nu;&iota;&sigma;&eta;. &Tau;&alpha; &delta;&iota;&alpha;&kappa;&rho;&iota;&tau;&iota;&kappa;ά &kappa;&omicron;&rho;&delta;ό&nu;&iota;&alpha; &sigma;&tau;&omicron; &sigma;&tau;ή&theta;&omicron;&sigmaf; &kappa;&alpha;&iota; &tau;&omicron;&upsilon;&sigmaf; &mu;&eta;&rho;&omicron;ύ&sigmaf; &pi;&rho;&omicron;&sigma;&theta;έ&tau;&omicron;&upsilon;&nu; &mu;&iota;&alpha; &epsilon;&pi;&iota;&pi;&lambda;έ&omicron;&nu; &pi;&iota;&nu;&epsilon;&lambda;&iota;ά &alpha;&pi;&omicron;&pi;&lambda;ά&nu;&eta;&sigma;&eta;&sigmaf;, &epsilon;&pi;&iota;&tau;&rho;έ&pi;&omicron;&nu;&tau;ά&sigmaf; &sigma;&alpha;&sigmaf; &nu;&alpha; &epsilon;&lambda;έ&gamma;&chi;&epsilon;&tau;&epsilon; &tau;&eta;&nu; έ&nu;&tau;&alpha;&sigma;&eta; &tau;&omicron;&upsilon; &nu;&tau;&epsilon;&kappa;&omicron;&lambda;&tau;έ &kappa;&alpha;&iota; &tau;&omega;&nu; &pi;&omicron;&delta;&iota;ώ&nu; &sigma;&alpha;&sigmaf;.</span><br /><br /><span>&Tau;&omicron; &phi;&epsilon;&rho;&mu;&omicron;&upsilon;ά&rho; &pi;&omicron;&upsilon; &kappa;&lambda;&epsilon;ί&nu;&epsilon;&iota; &sigma;&tau;&omicron; &pi;ί&sigma;&omega; &mu;έ&rho;&omicron;&sigmaf; &tau;&omicron; &kappa;&alpha;&theta;&iota;&sigma;&tau;ά &epsilon;ύ&kappa;&omicron;&lambda;&omicron; &nu;&alpha; &tau;&omicron; &phi;&omicron;&rho;έ&sigma;&epsilon;&tau;&epsilon; &kappa;&alpha;&iota;, &kappa;&upsilon;&rho;ί&omega;&sigmaf;, &epsilon;ύ&kappa;&omicron;&lambda;&omicron; &nu;&alpha; &tau;&omicron; &alpha;&nu;&omicron;ί&xi;&epsilon;&tau;&epsilon;... </span></p>
guid
stringhttps://dev.divasboudoir.com/el/darque-fetish-dress-forema-mayro/cdac1348.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringΑνακαλύψτε το υπέροχο αμάνικο φόρεμά μας Wetlook με αισθησιακά κορδόνια στο στήθος και τους μηρούς. Κλείσιμο με φερμουάρ στην πλάτη. Τολμηρό, σέξι στυλ για κάθε περίσταση
keywords
string
title
stringΑμάνικο plus size φόρεμα. Δαντέλα στο στήθος και τους μηρούς
seotitle
stringDarque Fetish Dress Φόρεμα
seouri
stringdarque-fetish-dress-forema-mayro
specifications
string
stylingtips
string
summary
string<p><span>&Epsilon;ί&tau;&epsilon; &pi;&rho;ό&kappa;&epsilon;&iota;&tau;&alpha;&iota; &gamma;&iota;&alpha; &mu;&iota;&alpha; &beta;&rho;&alpha;&delta;&iota;&nu;ή έ&xi;&omicron;&delta;&omicron; &mu;&epsilon; &phi;ί&lambda;&omicron;&upsilon;&sigmaf;, &epsilon;ί&tau;&epsilon; &gamma;&iota;&alpha; &mu;&iota;&alpha; &rho;&omicron;&mu;&alpha;&nu;&tau;&iota;&kappa;ή &beta;&rho;&alpha;&delta;&iota;ά &epsilon;ί&tau;&epsilon; &gamma;&iota;&alpha; &mu;&iota;&alpha; &epsilon;&iota;&delta;&iota;&kappa;ή &pi;&epsilon;&rho;ί&sigma;&tau;&alpha;&sigma;&eta;, &alpha;&upsilon;&tau;ό &tau;&omicron; &upsilon;&pi;έ&rho;&omicron;&chi;&omicron; &phi;ό&rho;&epsilon;&mu;&alpha; &theta;&alpha; &sigma;&alpha;&sigmaf; &sigma;&upsilon;&nu;&omicron;&delta;&epsilon;ύ&sigma;&epsilon;&iota; &mu;&epsilon; &sigma;&tau;&upsilon;&lambda; &kappa;&alpha;&iota; &alpha;&upsilon;&tau;&omicron;&pi;&epsilon;&pi;&omicron;ί&theta;&eta;&sigma;&eta;.</span></p>
title
stringDarque φόρεμα με δαντέλα
usageinstructions
string
en
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p><span>Discover our gorgeous plus size sleeveless faux-leather dress with sensual lacing on the chest and thighs. Back zipper closure. Bold, sexy style for every occasion.</span><br /><br /><span>The Darque lacing dress is designed to enhance your figure and give you a captivating look. Its cut adapts perfectly to feminine curves, emphasizing your assets with elegance.</span><br /><br /><span>High-quality Wetlook fabric gives this dress a sensual, eye-catching allure. Subtle lacing on the chest and thighs adds an extra touch of seduction, allowing you to control the intensity of your d&eacute;collet&eacute; and legs.</span><br /><br /><span>The back zipper ensures easy donning and, above all, easy opening... </span></p>
guid
stringhttps://dev.divasboudoir.com/en/plus-size-dress-in-black-leatherette-black/cdac1348.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringDiscover our gorgeous sleeveless Wetlook dress with sensual lacing on the chest and thighs. Back zipper closure. Bold, sexy style for every occasion
keywords
string
title
stringSleeveless plus size dress. Breast and thigh lacing
seotitle
stringPlus size dress in black leatherette
seouri
stringplus-size-dress-in-black-leatherette-black
specifications
string
stylingtips
string
summary
string<p><span>Whether for a night out with friends, a romantic evening or a special occasion, this sublime dress will accompany you with style and confidence.</span></p>
title
stringDarque lace-up dress
usageinstructions
string
es
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p><span>Descubre nuestro precioso vestido talla grande de piel sint&eacute;tica sin mangas con sensuales lazadas en el pecho y los muslos. Cierre de cremallera en la espalda. Un estilo atrevido y sexy para cualquier ocasi&oacute;n.</span><br /><br /><span>El vestido con cordones Darque est&aacute; dise&ntilde;ado para realzar tu figura y proporcionarte un look cautivador. Su corte se adapta perfectamente a las curvas femeninas, realzando tus atributos con elegancia.</span><br /><br /><span>El tejido wetlook de alta calidad confiere a este vestido un aspecto sensual y llamativo. La sutil lazada en el pecho y los muslos a&ntilde;ade un toque extra de seducci&oacute;n, permiti&eacute;ndote controlar la intensidad de tu escote y tus piernas.</span><br /><br /><span>El cierre de cremallera en la espalda facilita la colocaci&oacute;n y, sobre todo, la apertura... </span></p>
guid
stringhttps://dev.divasboudoir.com/es/vestido-talla-grande-de-piel-sintetica-negra-negro/cdac1348.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringDescubre nuestro magnífico vestido Wetlook sin mangas con sensuales lazadas en el pecho y los muslos. Cierre de cremallera en la espalda. Un estilo atrevido y sexy para cualquier ocasión
keywords
string
title
stringVestido de talla grande sin mangas. Pecho y muslos con cordones
seotitle
stringVestido talla grande de piel sintética negra
seouri
stringvestido-talla-grande-de-piel-sintetica-negra-negro
specifications
string
stylingtips
string
summary
string<p><span>Ya sea para una noche con amigos, una velada rom&aacute;ntica o una ocasi&oacute;n especial, este sublime vestido te acompa&ntilde;ar&aacute; con estilo y confianza.</span></p>
title
stringVestido con cordones Darque
usageinstructions
string
fr
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p><span>D&eacute;couvrez notre magnifique robe en similicuir sans manche avec la&ccedil;age sensuel sur la poitrine et les cuisses. Fermeture &agrave; glissi&egrave;re dans le dos. Un style audacieux et sexy pour toutes les occasions.</span><br><br><span>La robe Darque &agrave; la&ccedil;ages est con&ccedil;ue pour mettre en valeur votre silhouette et vous offrir un look captivant. Sa coupe s'adapte parfaitement aux courbes f&eacute;minines, soulignant vos atouts avec &eacute;l&eacute;gance.</span><br><br><span>Le tissu Wetlook (similicuir &eacute;lastique) de haute qualit&eacute; conf&egrave;re &agrave; cette robe une allure sensuelle, attirant tous les regards. Le la&ccedil;age subtil sur la poitrine et les cuisses ajoute une touche de s&eacute;duction suppl&eacute;mentaire, permettant de doser l'intensit&eacute; de votre d&eacute;collet&eacute; et de vos jambes.</span><br><br><span>La fermeture &agrave; glissi&egrave;re dans le dos garantit un enfilage facile et surtout, une ouverture facile...&nbsp;</span></p>
guid
stringhttps://dev.divasboudoir.com/fr/robe-grande-taille-en-similicuir-noir-noir/cdac1348.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringDécouvrez notre magnifique robe en Wetlook sans manche avec laçage sensuel sur la poitrine et les cuisses. Fermeture à glissière dans le dos. Un style audacieux et sexy pour toutes les occasions
keywords
string
title
stringRobe grande taille sans manche. Laçage poitrine et cuisses
seotitle
stringRobe grande taille en similicuir noir
seouri
stringrobe-grande-taille-en-similicuir-noir-noir
specifications
string
stylingtips
string
summary
string<p><span>Que ce soit pour une sortie entre amis, une soir&eacute;e romantique ou une occasion sp&eacute;ciale, cette sublime robe saura vous accompagner avec style et confiance.</span></p>
title
stringRobe Dark à laçages
usageinstructions
string
it
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p><span>Scoprite il nostro splendido abito in ecopelle a taglia grande e senza maniche, con sensuale allacciatura sul petto e sulle cosce. Chiusura con zip sul retro. Stile audace e sexy per ogni occasione.</span><br /><br /><span>L'abito stringato Darque &egrave; stato progettato per valorizzare la vostra figura e donarvi un look accattivante. Il suo taglio si adatta perfettamente alle curve femminili, mettendo in risalto le vostre caratteristiche con eleganza.</span><br /><br /><span>Il tessuto wetlook di alta qualit&agrave; conferisce a questo abito un aspetto sensuale e accattivante. La sottile allacciatura sul petto e sulle cosce aggiunge un tocco di seduzione in pi&ugrave;, permettendovi di controllare l'intensit&agrave; del decollet&eacute; e delle gambe.</span><br /><br /><span>La chiusura a zip sul retro lo rende facile da indossare e, soprattutto, da aprire... </span></p>
guid
stringhttps://dev.divasboudoir.com/it/abito-nero-in-ecopelle-taglia-grande-nero/cdac1348.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringScoprite il nostro magnifico abito Wetlook senza maniche con sensuale allacciatura sul petto e sulle cosce. Chiusura con zip sul retro. Stile audace e sexy per ogni occasione
keywords
string
title
stringAbito senza maniche di taglia grande. Allacciatura sul petto e sulle cosce
seotitle
stringAbito nero in ecopelle taglia grande
seouri
stringabito-nero-in-ecopelle-taglia-grande-nero
specifications
string
stylingtips
string
summary
string<p><span>Che si tratti di una serata tra amici, di una serata romantica o di un'occasione speciale, questo abito sublime vi accompagner&agrave; con stile e sicurezza.</span></p>
title
stringAbito stringato Darque
usageinstructions
string
nl
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p><span>Ontdek onze prachtige groote maat mouwloze jurk van imitatieleer met sensuele vetersluiting op de borst en dijen. Ritssluiting aan de achterkant. Gewaagde, sexy stijl voor elke gelegenheid.</span><br /><br /><span>De Darque-jurk met vetersluiting is ontworpen om je figuur te verbeteren en je een fascinerende look te geven. De snit past zich perfect aan vrouwelijke rondingen aan en benadrukt je pluspunten met elegantie.</span><br /><br /><span>De hoogwaardige wetlook stof geeft deze jurk een sensuele, opvallende look. De subtiele vetersluiting op de borst en dijen voegt een extra vleugje verleiding toe, zodat je zelf de intensiteit van je decollet&eacute; en benen kunt bepalen.</span><br /><br /><span>De ritssluiting aan de achterkant maakt het gemakkelijk om aan te trekken en vooral... </span></p>
guid
stringhttps://dev.divasboudoir.com/nl/zwarte-jurk-van-imitatieleer-in-grote-maat-zwart/cdac1348.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringOntdek onze prachtige mouwloze Wetlook-jurk met sensuele vetersluiting op de borst en dijen. Ritssluiting op de rug. Gedurfde, sexy stijl voor elke gelegenheid
keywords
string
title
stringMouwloze jurk van groote maat. Kanten op de borst en dijen
seotitle
stringZwarte jurk van imitatieleer in grote maat
seouri
stringzwarte-jurk-van-imitatieleer-in-grote-maat-zwart
specifications
string
stylingtips
string
summary
string<p><span>Of het nu voor een avondje uit met vrienden, een romantische avond of een speciale gelegenheid is, deze sublieme jurk zal je stijlvol en zelfverzekerd begeleiden.</span></p>
title
stringDarque jurk met kant
usageinstructions
string
pt
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p><span>Descubra o nosso deslumbrante vestido grande em pele sint&eacute;tica sem mangas com la&ccedil;os sensuais no peito e nas coxas. Fecho de correr nas costas. Estilo ousado e sexy para todas as ocasi&otilde;es.</span><br /><br /><span>O vestido Darque com cord&otilde;es foi concebido para real&ccedil;ar a sua figura e proporcionar-lhe um visual cativante. O seu corte adapta-se perfeitamente &agrave;s curvas femininas, real&ccedil;ando os seus atributos com eleg&acirc;ncia.</span><br /><br /><span>O tecido wetlook de alta qualidade confere a este vestido um aspeto sensual e atraente. O subtil la&ccedil;o no peito e nas coxas d&aacute; um toque extra de sedu&ccedil;&atilde;o, permitindo-lhe controlar a intensidade do seu decote e das suas pernas.</span><br /><br /><span>O fecho de correr na parte de tr&aacute;s facilita a coloca&ccedil;&atilde;o e, sobretudo, a abertura... </span></p>
guid
stringhttps://dev.divasboudoir.com/pt/vestido-plus-size-em-pele-sintetica-preta-preto/cdac1348.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringDescubra o nosso magnífico vestido Wetlook sem mangas com um sensual laço no peito e nas coxas. Fecho de correr nas costas. Estilo ousado e sexy para todas as ocasiões
keywords
string
title
stringVestido plus size sem mangas. Peito e coxas com cordões
seotitle
stringVestido plus size em pele sintética preta
seouri
stringvestido-plus-size-em-pele-sintetica-preta-preto
specifications
string
stylingtips
string
summary
string<p><span>Quer seja para uma sa&iacute;da &agrave; noite com os amigos, uma noite rom&acirc;ntica ou uma ocasi&atilde;o especial, este vestido sublime acompanh&aacute;-la-&aacute; com estilo e confian&ccedil;a.</span></p>
title
stringVestido Darque com renda
usageinstructions
string
fetishboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
latexboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
legsboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
lustboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
smboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>Entdecken Sie unser wunderschönes ärmelloses Kleid aus Kunstleder mit sinnlicher Schnürung im Brustbereich und an den Oberschenkeln. Reißverschluss im Rücken. Ein gewagter und sexy Stil für jeden Anlass.</span><br /><br /><span>Das Darque-Kleid mit Schnürung wurde entworfen, um Ihre Figur zu betonen und Ihnen einen aufregenden Look zu verleihen. Sein Schnitt passt sich perfekt an die weiblichen Kurven an und betont Ihre Vorzüge auf elegante Weise.</span><br /><br /><span>Der hochwertige Wetlook-Stoff (elastisches Kunstleder) verleiht diesem Kleid eine sinnliche Ausstrahlung, die alle Blicke auf sich zieht. Die subtile Schnürung im Brustbereich und an den Oberschenkeln sorgt für einen zusätzlichen verführerischen Touch, sodass Sie die Intensität Ihres Dekollet&eacute;s und Ihrer Beine dosieren können.</span><br /><br /><span>Der Reißverschluss im Rücken garantiert ein einfaches Anziehen und vor allem ein leichtes Öffnen... </span></p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringEntdecken Sie unser wunderschönes ärmelloses Fetischkleid mit sinnlicher Schnürung an der Brust und den Oberschenkeln. Reißverschluss auf dem Rücken. BDSM-Boutique.
keywords
string
title
stringÄrmelloses Fetisch-Kleid. Brust- und Oberschenkelschnürung
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string<p><span>Ob für einen Ausflug mit Freunden, einen frechen Abend oder einen besonderen Anlass - dieses erhabene Kleid wird Sie stilvoll und selbstbewusst begleiten.</span></p>
title
stringDarque Fetischisten-Kleid
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>&Alpha;&nu;&alpha;&kappa;&alpha;&lambda;ύ&psi;&tau;&epsilon; &tau;&omicron; &pi;&alpha;&nu;έ&mu;&omicron;&rho;&phi;&omicron; &alpha;&mu;ά&nu;&iota;&kappa;&omicron; &phi;ό&rho;&epsilon;&mu;ά &mu;&alpha;&sigmaf; &alpha;&pi;ό &psi;&epsilon;ύ&tau;&iota;&kappa;&omicron; &delta;έ&rho;&mu;&alpha; &mu;&epsilon; &alpha;&iota;&sigma;&theta;&eta;&sigma;&iota;&alpha;&kappa;ά &kappa;&omicron;&rho;&delta;ό&nu;&iota;&alpha; &sigma;&tau;&omicron; &sigma;&tau;ή&theta;&omicron;&sigmaf; &kappa;&alpha;&iota; &tau;&omicron;&upsilon;&sigmaf; &mu;&eta;&rho;&omicron;ύ&sigmaf;. &Kappa;&lambda;&epsilon;ί&nu;&epsilon;&iota; &mu;&epsilon; &phi;&epsilon;&rho;&mu;&omicron;&upsilon;ά&rho; &sigma;&tau;&eta;&nu; &pi;&lambda;ά&tau;&eta;. &Tau;&omicron;&lambda;&mu;&eta;&rho;ό, &sigma;έ&xi;&iota; &sigma;&tau;&upsilon;&lambda; &gamma;&iota;&alpha; &kappa;ά&theta;&epsilon; &pi;&epsilon;&rho;ί&sigma;&tau;&alpha;&sigma;&eta;.</span><br /><br /><span>&Tau;&omicron; &delta;&alpha;&nu;&tau;&epsilon;&lambda;&omega;&tau;ό &phi;ό&rho;&epsilon;&mu;&alpha; Darque έ&chi;&epsilon;&iota; &sigma;&chi;&epsilon;&delta;&iota;&alpha;&sigma;&tau;&epsilon;ί &gamma;&iota;&alpha; &nu;&alpha; &alpha;&nu;&alpha;&delta;&epsilon;&iota;&kappa;&nu;ύ&epsilon;&iota; &tau;&eta; &sigma;&iota;&lambda;&omicron;&upsilon;έ&tau;&alpha; &sigma;&alpha;&sigmaf; &kappa;&alpha;&iota; &nu;&alpha; &sigma;&alpha;&sigmaf; &chi;&alpha;&rho;ί&zeta;&epsilon;&iota; &mu;&iota;&alpha; &sigma;&alpha;&gamma;&eta;&nu;&epsilon;&upsilon;&tau;&iota;&kappa;ή &epsilon;&mu;&phi;ά&nu;&iota;&sigma;&eta;. &Tau;&omicron; &kappa;ό&psi;&iota;&mu;ό &tau;&omicron;&upsilon; &pi;&rho;&omicron;&sigma;&alpha;&rho;&mu;ό&zeta;&epsilon;&tau;&alpha;&iota; &tau;έ&lambda;&epsilon;&iota;&alpha; &sigma;&tau;&iota;&sigmaf; &gamma;&upsilon;&nu;&alpha;&iota;&kappa;&epsilon;ί&epsilon;&sigmaf; &kappa;&alpha;&mu;&pi;ύ&lambda;&epsilon;&sigmaf;, &tau;&omicron;&nu;ί&zeta;&omicron;&nu;&tau;&alpha;&sigmaf; &tau;&alpha; &pi;&rho;&omicron;&sigma;ό&nu;&tau;&alpha; &sigma;&alpha;&sigmaf; &mu;&epsilon; &kappa;&omicron;&mu;&psi;ό&tau;&eta;&tau;&alpha;.</span><br /><br /><span>&Tau;&omicron; &upsilon;&psi;&eta;&lambda;ή&sigmaf; &pi;&omicron;&iota;ό&tau;&eta;&tau;&alpha;&sigmaf; wetlook ύ&phi;&alpha;&sigma;&mu;&alpha; &chi;&alpha;&rho;ί&zeta;&epsilon;&iota; &sigma;&epsilon; &alpha;&upsilon;&tau;ό &tau;&omicron; &phi;ό&rho;&epsilon;&mu;&alpha; &mu;&iota;&alpha; &alpha;&iota;&sigma;&theta;&eta;&sigma;&iota;&alpha;&kappa;ή, &epsilon;&nu;&tau;&upsilon;&pi;&omega;&sigma;&iota;&alpha;&kappa;ή &epsilon;&mu;&phi;ά&nu;&iota;&sigma;&eta;. &Tau;&alpha; &delta;&iota;&alpha;&kappa;&rho;&iota;&tau;&iota;&kappa;ά &kappa;&omicron;&rho;&delta;ό&nu;&iota;&alpha; &sigma;&tau;&omicron; &sigma;&tau;ή&theta;&omicron;&sigmaf; &kappa;&alpha;&iota; &tau;&omicron;&upsilon;&sigmaf; &mu;&eta;&rho;&omicron;ύ&sigmaf; &pi;&rho;&omicron;&sigma;&theta;έ&tau;&omicron;&upsilon;&nu; &mu;&iota;&alpha; &epsilon;&pi;&iota;&pi;&lambda;έ&omicron;&nu; &pi;&iota;&nu;&epsilon;&lambda;&iota;ά &alpha;&pi;&omicron;&pi;&lambda;ά&nu;&eta;&sigma;&eta;&sigmaf;, &epsilon;&pi;&iota;&tau;&rho;έ&pi;&omicron;&nu;&tau;ά&sigmaf; &sigma;&alpha;&sigmaf; &nu;&alpha; &epsilon;&lambda;έ&gamma;&chi;&epsilon;&tau;&epsilon; &tau;&eta;&nu; έ&nu;&tau;&alpha;&sigma;&eta; &tau;&omicron;&upsilon; &nu;&tau;&epsilon;&kappa;&omicron;&lambda;&tau;έ &kappa;&alpha;&iota; &tau;&omega;&nu; &pi;&omicron;&delta;&iota;ώ&nu; &sigma;&alpha;&sigmaf;.</span><br /><br /><span>&Tau;&omicron; &phi;&epsilon;&rho;&mu;&omicron;&upsilon;ά&rho; &pi;&omicron;&upsilon; &kappa;&lambda;&epsilon;ί&nu;&epsilon;&iota; &sigma;&tau;&omicron; &pi;ί&sigma;&omega; &mu;έ&rho;&omicron;&sigmaf; &tau;&omicron; &kappa;&alpha;&theta;&iota;&sigma;&tau;ά &epsilon;ύ&kappa;&omicron;&lambda;&omicron; &nu;&alpha; &tau;&omicron; &phi;&omicron;&rho;έ&sigma;&epsilon;&tau;&epsilon; &kappa;&alpha;&iota;, &kappa;&upsilon;&rho;ί&omega;&sigmaf;, &epsilon;ύ&kappa;&omicron;&lambda;&omicron; &nu;&alpha; &tau;&omicron; &alpha;&nu;&omicron;ί&xi;&epsilon;&tau;&epsilon;... </span></p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringΑνακαλύψτε το υπέροχο αμάνικο φόρεμα φετίχ μας με αισθησιακά κορδόνια στο στήθος και τους μηρούς. Κλείσιμο με φερμουάρ στην πλάτη. Κατάστημα BDSM.
keywords
string
title
stringDarque Fetish Dress Φόρεμα
seotitle
stringDarque Fetish Dress Φόρεμα
seouri
stringdarque-fetish-dress-forema-mayro
specifications
string
stylingtips
string
summary
string<p><span>&Epsilon;ί&tau;&epsilon; &pi;&rho;ό&kappa;&epsilon;&iota;&tau;&alpha;&iota; &gamma;&iota;&alpha; &mu;&iota;&alpha; &beta;&rho;&alpha;&delta;&iota;&nu;ή έ&xi;&omicron;&delta;&omicron; &mu;&epsilon; &phi;ί&lambda;&omicron;&upsilon;&sigmaf;, &epsilon;ί&tau;&epsilon; &gamma;&iota;&alpha; έ&nu;&alpha; ά&tau;&alpha;&kappa;&tau;&omicron; &pi;ά&rho;&tau;&iota; &epsilon;ί&tau;&epsilon; &gamma;&iota;&alpha; &mu;&iota;&alpha; &epsilon;&iota;&delta;&iota;&kappa;ή &pi;&epsilon;&rho;ί&sigma;&tau;&alpha;&sigma;&eta;, &alpha;&upsilon;&tau;ό &tau;&omicron; &upsilon;&pi;έ&rho;&omicron;&chi;&omicron; &phi;ό&rho;&epsilon;&mu;&alpha; &theta;&alpha; &sigma;&alpha;&sigmaf; &sigma;&upsilon;&nu;&omicron;&delta;&epsilon;ύ&sigma;&epsilon;&iota; &mu;&epsilon; &sigma;&tau;&upsilon;&lambda; &kappa;&alpha;&iota; &alpha;&upsilon;&tau;&omicron;&pi;&epsilon;&pi;&omicron;ί&theta;&eta;&sigma;&eta;.</span></p>
title
stringDarque Fetish Dress Φόρεμα
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>Discover our gorgeous sleeveless faux-leather dress with sensual lacing on the chest and thighs. Back zipper closure. Bold, sexy style for every occasion.</span><br /><br /><span>The Darque lacing dress is designed to enhance your figure and give you a captivating look. Its cut adapts perfectly to feminine curves, emphasizing your assets with elegance.</span><br /><br /><span>High-quality Wetlook fabric gives this dress a sensual, eye-catching allure. Subtle lacing on the chest and thighs adds an extra touch of seduction, allowing you to control the intensity of your d&eacute;collet&eacute; and legs.</span><br /><br /><span>The back zipper ensures easy donning and, above all, easy opening... </span></p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringDiscover our magnificent sleeveless fetish dress with sensual lacing on the chest and thighs. Back zipper closure. Boutique BDSM.
keywords
string
title
stringSleeveless fetish dress. Breast and thigh lacing
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string<p><span>Whether for a night out with friends, a naughty party or a special occasion, this sublime dress will accompany you with style and confidence.</span></p>
title
stringDarque Fetish Dress
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>Descubre nuestro precioso vestido sin mangas de piel sintética con sensuales lazadas en el pecho y los muslos. Cierre de cremallera en la espalda. Un estilo atrevido y sexy para cualquier ocasión.</span><br /><br /><span>El vestido con cordones Darque está diseñado para realzar tu figura y proporcionarte un look cautivador. Su corte se adapta perfectamente a las curvas femeninas, realzando tus atributos con elegancia.</span><br /><br /><span>El tejido wetlook de alta calidad confiere a este vestido un aspecto sensual y llamativo. La sutil lazada en el pecho y los muslos añade un toque extra de seducción, permiti&eacute;ndote controlar la intensidad de tu escote y tus piernas.</span><br /><br /><span>El cierre de cremallera en la espalda facilita la colocación y, sobre todo, la apertura... </span></p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringDescubre nuestro magnífico vestido fetiche sin mangas con sensuales lazadas en el pecho y los muslos. Cierre de cremallera en la espalda. Tienda BDSM.
keywords
string
title
stringVestido fetiche sin mangas. Pecho y muslos con cordones
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string<p><span>Ya sea para una noche con amigos, una fiesta traviesa o una ocasión especial, este vestido sublime te acompañará con estilo y confianza.</span></p>
title
stringVestido Darque Fetish
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>D&eacute;couvrez notre magnifique robe en similicuir sans manche avec la&ccedil;age sensuel sur la poitrine et les cuisses. Fermeture &agrave; glissi&egrave;re dans le dos. Un style audacieux et sexy pour toutes les occasions.</span><br><br><span>La robe Darque &agrave; la&ccedil;ages est con&ccedil;ue pour mettre en valeur votre silhouette et vous offrir un look captivant. Sa coupe s'adapte parfaitement aux courbes f&eacute;minines, soulignant vos atouts avec &eacute;l&eacute;gance.</span><br><br><span>Le tissu Wetlook (similicuir &eacute;lastique) de haute qualit&eacute; conf&egrave;re &agrave; cette robe une allure sensuelle, attirant tous les regards. Le la&ccedil;age subtil sur la poitrine et les cuisses ajoute une touche de s&eacute;duction suppl&eacute;mentaire, permettant de doser l'intensit&eacute; de votre d&eacute;collet&eacute; et de vos jambes.</span><br><br><span>La fermeture &agrave; glissi&egrave;re dans le dos garantit un enfilage facile et surtout, une ouverture facile...&nbsp;</span></p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringDécouvrez notre magnifique robe fétichiste sans manche avec laçage sensuel sur la poitrine et les cuisses. Fermeture à glissière dans le dos. Boutique BDSM.
keywords
string
title
stringRobe fétichiste sans manche. Laçage poitrine et cuisses
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string<p><span>Que ce soit pour une sortie entre amis, une soir&eacute;e coquine ou une occasion sp&eacute;ciale, cette sublime robe saura vous accompagner avec style et assurance.</span></p>
title
stringRobe Fétichiste Darque
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>Scoprite il nostro splendido abito senza maniche in ecopelle con sensuale allacciatura sul petto e sulle cosce. Chiusura con zip sul retro. Stile audace e sexy per ogni occasione.</span><br /><br /><span>L'abito stringato Darque è stato progettato per valorizzare la vostra figura e donarvi un look accattivante. Il suo taglio si adatta perfettamente alle curve femminili, mettendo in risalto le vostre caratteristiche con eleganza.</span><br /><br /><span>Il tessuto wetlook di alta qualità conferisce a questo abito un aspetto sensuale e accattivante. La sottile allacciatura sul petto e sulle cosce aggiunge un tocco di seduzione in più, permettendovi di controllare l'intensità del decollet&eacute; e delle gambe.</span><br /><br /><span>La chiusura a zip sul retro lo rende facile da indossare e, soprattutto, da aprire... </span></p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringScoprite il nostro magnifico abito fetish senza maniche con sensuale allacciatura sul petto e sulle cosce. Chiusura con zip sul retro. Negozio BDSM.
keywords
string
title
stringAbito fetish senza maniche. Allacciatura sul petto e sulle cosce
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string<p><span>Che si tratti di una serata tra amici, di un party malizioso o di un'occasione speciale, questo abito sublime vi accompagnerà con stile e sicurezza.</span></p>
title
stringAbito Darque Fetish
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>Ontdek onze prachtige mouwloze jurk van imitatieleer met sensuele vetersluiting op de borst en dijen. Ritssluiting aan de achterkant. Gewaagde, sexy stijl voor elke gelegenheid.</span><br /><br /><span>De Darque-jurk met vetersluiting is ontworpen om je figuur te verbeteren en je een fascinerende look te geven. De snit past zich perfect aan vrouwelijke rondingen aan en benadrukt je pluspunten met elegantie.</span><br /><br /><span>De hoogwaardige wetlook stof geeft deze jurk een sensuele, opvallende look. De subtiele vetersluiting op de borst en dijen voegt een extra vleugje verleiding toe, zodat je zelf de intensiteit van je decollet&eacute; en benen kunt bepalen.</span><br /><br /><span>De ritssluiting aan de achterkant maakt het gemakkelijk om aan te trekken en vooral... </span></p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringOntdek onze prachtige mouwloze fetisjjjurk met sensuele vetersluiting op de borst en dijen. Ritssluiting op de rug. BDSM winkel.
keywords
string
title
stringMouwloze fetisj jurk. Kanten op borst en dijen
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string<p><span>Of het nu voor een avondje uit met vrienden, een ondeugend feestje of een speciale gelegenheid is, dit sublieme jurkje zal je stijlvol en zelfverzekerd vergezellen.</span></p>
title
stringDarque Fetish Jurk
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>Descubra o nosso deslumbrante vestido em pele sintética sem mangas com um sensual laço no peito e nas coxas. Fecho de correr nas costas. Estilo ousado e sexy para qualquer ocasião.</span><br /><br /><span>O vestido Darque com cordões foi concebido para realçar a sua silhueta e proporcionar-lhe um visual cativante. O seu corte adapta-se perfeitamente às curvas femininas, realçando os seus atributos com elegância.</span><br /><br /><span>O tecido wetlook de alta qualidade confere a este vestido um aspeto sensual e atraente. O subtil laço no peito e nas coxas dá um toque extra de sedução, permitindo-lhe controlar a intensidade do seu decote e das suas pernas.</span><br /><br /><span>O fecho de correr na parte de trás facilita a colocação e, sobretudo, a abertura... </span></p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringDescubra o nosso magnífico vestido fetiche sem mangas com laços sensuais no peito e nas coxas. Fecho de correr nas costas. Loja BDSM.
keywords
string
title
stringVestido fetiche sem mangas. Peito e coxas com cordões
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string<p><span>Quer seja para uma saída à noite com os amigos, uma festa marota ou uma ocasião especial, este vestido sublime acompanhá-la-á com estilo e confiança.</span></p>
title
stringVestido Darque Fetish
usageinstructions
string
name
string19630-BK
netweight
string
nextshipment
stringtomorrow
ordered
number13
orderidx
number0
origin
string
originalsize
string
packaging
string
productshipment
stringauto
productuid
string5D141F23-71D6-4699-BEDC49FD4B95491F
promountil
string
rating
stringnone
recorduid
string5D141F23-71D6-4699-BEDC49FD4B95491F
reference
stringCDAC1348
related
string
reserved
string
returned
number0
returnsallowed
number1
section
stringcabaret
shipment
string5to7days
showbrand
number0
sizeinfos
Query
Template: /system/api/product/sizes.cfc:20
Execution Time: 2.39 ms
Record Count: 3
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_sizes.id_size as recorduid, if(intlsize <> '',intlsize,eusize) as size, if(intlsize <> '','intlsize','eusize') as sizetype,
product_variations.color,
if(product_sizes.sizegroup = 'bra',
if(intlsize <> '', cast(intlsize as SIGNED ), cast(eusize as SIGNED ))
,
SUBSTRING_INDEX(intlsize,'-',1)
) as param1,
if(product_sizes.sizegroup = 'bra',
if(intlsize <> '',
MID(intlsize,length(cast(intlsize as SIGNED ))+1,length(intlsize)),
MID(eusize,length(cast(eusize as SIGNED ))+1,length(eusize))
)
,
SUBSTRING_INDEX(intlsize,'-',-1)
) as param2,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as available,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
999999,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as groupavailable,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
product_sizes.gender, product_sizes.sizerange, product_sizes.sizegroup, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize,
product_sizes.bust, product_sizes.waist, product_sizes.hip, product_sizes.underbust, product_sizes.cup, product_sizes.thigh, product_sizes.legheight, product_sizes.bodyheight, product_sizes.bodyweight
from product_sizes
left outer join product_variations on product_sizes.suppliersize = product_variations.size and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
where FIND_IN_SET(product_sizes.id_size,'2087,2086,2085,2084,2083,2082') > 0
and product_variations.productuid = '5D141F23-71D6-4699-BEDC49FD4B95491F'
and intlsize <> 'na'
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_sizes.id_size, product_variations.color
order by FIELD(product_sizes.gender,'w','m'), product_sizes.sizegroup, FIELD(intlsize,'XS','S','S/M','S-M','M','M/L','M-L','L','L-XL','L/XL','XL','0X','0XL','lXL','1X','1X-2X','1X/2X','XL/2XL','XL-2XL','1XL-2XL','2XL','2X','XXL','2X-3X','2X/3X','2XL-3XL','2XL/3XL','XXXL','3XL','3X','3X-4X','3X/4X','3XL-4XL','3XL/4XL','4XL','5XL','5X','5X-6X','5X/6X','5XL-6XL','5XL/6XL','6XL','6X','7XL','7X','8XL','8X'), cast(intlsize as SIGNED ), groupavailable desc, stock desc
recorduidsizesizetypecolorparam1param2availablegroupavailablestockgendersizerangesizegroupsuppliersizeintlsizeincheseusizeussizeuksizefrsizeessizedesizeitsizeptsizeelsizebustwaisthipunderbustcupthighlegheightbodyheightbodyweight
12087XLintlsizeblackXLXL-19999991wplusdressXLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42104-10880-86106-110
220862XLintlsizeblack2XL2XL-19999990wplusdress2XL2XL44-4614-1618-2046-4846-4844-4650-5246-4844-46108-11286-92110-114
320853XLintlsizeblack3XL3XL-19999992wplusdress3XL3XL48-5018-2022-2650-5250-5248-5052-5450-5248-50112-11492-98114-118
sizeranges
stringstandard,plus
sizes
string2087,2086,2085,2084,2083,2082
sizetype
stringauto
specifications
Struct
Entries: 23
belly
string
bones
string
bra
string
breasts
string
bust
string
closing
string
crochtless
string
cups
string
cut
string
garter
string
halter
string
lacing
string
lining
string
modestypanel
string
panty
string
sheathing
string
sleeves
string
stocking
string
straps
string
stretch
string
suspenders
string
transparency
string
underwires
string
stock
number0
stocks
Query
Template: /system/api/product/stocks.cfc:25
Execution Time: 9.23 ms
Record Count: 3
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select * from (
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '5D141F23-71D6-4699-BEDC49FD4B95491F'
and product_variations.isactive = 1
and product_sizes.id_size = 2087
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '5D141F23-71D6-4699-BEDC49FD4B95491F'
and product_variations.isactive = 1
and product_sizes.id_size = 2086
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '5D141F23-71D6-4699-BEDC49FD4B95491F'
and product_variations.isactive = 1
and product_sizes.id_size = 2085
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '5D141F23-71D6-4699-BEDC49FD4B95491F'
and product_variations.isactive = 1
and product_sizes.id_size = 2084
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '5D141F23-71D6-4699-BEDC49FD4B95491F'
and product_variations.isactive = 1
and product_sizes.id_size = 2083
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '5D141F23-71D6-4699-BEDC49FD4B95491F'
and product_variations.isactive = 1
and product_sizes.id_size = 2082
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
) tbl
group by productuid, variationuid, stockuid
order by stockuid, FIELD(gender,'w','m'), sizegroup, FIELD(intlsize,'XS','S','S/M','S-M','M','M/L','M-L','L','L-XL','L/XL','XL','0X','0XL','lXL','1X','1X-2X','1X/2X','XL/2XL','XL-2XL','1XL-2XL','2XL','2X','XXL','2X-3X','2X/3X','2XL-3XL','2XL/3XL','XXXL','3XL','3X','3X-4X','3X/4X','3XL-4XL','3XL/4XL','4XL','5XL','5X','5X-6X','5X/6X','5XL-6XL','5XL/6XL','6XL','6X','7XL','7X','8XL','8X'), cast(intlsize as SIGNED ), color
productuidvariationuidrecorduidcolorhexvaluesuppliersizeintlsizeincheseusizeussizeuksizefrsizeessizedesizeitsizeptsizeelsizegendersizegroupcupsizesizetypeitempriceitempromopromoUntilstockuidwarehouseontourpackagingsupplierreservedorderedreturneddefectmanufacturerreferenceeanavailablestockdisplaycomments
15D141F23-71D6-4699-BEDC49FD4B95491FC8961F91-F5BF-4854-8A47D406DDF318DD2087black#000000XLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42wdressXLintlsize41.6250STOCK01100-1030019630366408606366211all
25D141F23-71D6-4699-BEDC49FD4B95491FD1593B13-4C99-43B8-947AA879FA1427A72086black#0000002XL2XL44-4614-1618-2046-4846-4844-4650-5246-4844-46wdress2XLintlsize41.6250STOCK01000-10400196303664086060333-10all
35D141F23-71D6-4699-BEDC49FD4B95491FCE371ECC-5A9B-4387-AF37CE65D10F8CEB2085black#0000003XL3XL48-5018-2022-2650-5250-5248-5052-5450-5248-50wdress3XLintlsize41.6250STOCK01200-1060019630366408606034022all
subcategory
stringall
supplier
number-1
supplierreference
string19630-BK
tags
stringnoirdesir
themes
stringdark
totalvariations
string
type
stringdefault
unitprice
number41.625
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 13.5 ms
Record Count: 3
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 = '5D141F23-71D6-4699-BEDC49FD4B95491F' 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 = '5D141F23-71D6-4699-BEDC49FD4B95491F' 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 = '5D141F23-71D6-4699-BEDC49FD4B95491F' 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 = '5D141F23-71D6-4699-BEDC49FD4B95491F' 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 = '5D141F23-71D6-4699-BEDC49FD4B95491F' 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 = '5D141F23-71D6-4699-BEDC49FD4B95491F' 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 = '5D141F23-71D6-4699-BEDC49FD4B95491F'
and product_variations.isactive = 1
and product_sizes.id_size = 2087
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '5D141F23-71D6-4699-BEDC49FD4B95491F' 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 = '5D141F23-71D6-4699-BEDC49FD4B95491F' 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 = '5D141F23-71D6-4699-BEDC49FD4B95491F' 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 = '5D141F23-71D6-4699-BEDC49FD4B95491F' 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 = '5D141F23-71D6-4699-BEDC49FD4B95491F' 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 = '5D141F23-71D6-4699-BEDC49FD4B95491F' 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 = '5D141F23-71D6-4699-BEDC49FD4B95491F'
and product_variations.isactive = 1
and product_sizes.id_size = 2086
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '5D141F23-71D6-4699-BEDC49FD4B95491F' 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 = '5D141F23-71D6-4699-BEDC49FD4B95491F' 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 = '5D141F23-71D6-4699-BEDC49FD4B95491F' 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 = '5D141F23-71D6-4699-BEDC49FD4B95491F' 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 = '5D141F23-71D6-4699-BEDC49FD4B95491F' 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 = '5D141F23-71D6-4699-BEDC49FD4B95491F' 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 = '5D141F23-71D6-4699-BEDC49FD4B95491F'
and product_variations.isactive = 1
and product_sizes.id_size = 2085
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '5D141F23-71D6-4699-BEDC49FD4B95491F' 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 = '5D141F23-71D6-4699-BEDC49FD4B95491F' 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 = '5D141F23-71D6-4699-BEDC49FD4B95491F' 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 = '5D141F23-71D6-4699-BEDC49FD4B95491F' 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 = '5D141F23-71D6-4699-BEDC49FD4B95491F' 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 = '5D141F23-71D6-4699-BEDC49FD4B95491F' 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 = '5D141F23-71D6-4699-BEDC49FD4B95491F'
and product_variations.isactive = 1
and product_sizes.id_size = 2084
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '5D141F23-71D6-4699-BEDC49FD4B95491F' 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 = '5D141F23-71D6-4699-BEDC49FD4B95491F' 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 = '5D141F23-71D6-4699-BEDC49FD4B95491F' 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 = '5D141F23-71D6-4699-BEDC49FD4B95491F' 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 = '5D141F23-71D6-4699-BEDC49FD4B95491F' 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 = '5D141F23-71D6-4699-BEDC49FD4B95491F' 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 = '5D141F23-71D6-4699-BEDC49FD4B95491F'
and product_variations.isactive = 1
and product_sizes.id_size = 2083
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '5D141F23-71D6-4699-BEDC49FD4B95491F' 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 = '5D141F23-71D6-4699-BEDC49FD4B95491F' 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 = '5D141F23-71D6-4699-BEDC49FD4B95491F' 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 = '5D141F23-71D6-4699-BEDC49FD4B95491F' 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 = '5D141F23-71D6-4699-BEDC49FD4B95491F' 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 = '5D141F23-71D6-4699-BEDC49FD4B95491F' 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 = '5D141F23-71D6-4699-BEDC49FD4B95491F'
and product_variations.isactive = 1
and product_sizes.id_size = 2082
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
order by FIELD(gender,'w','m'), sizegroup, FIELD(intlsize,'XS','S','S/M','S-M','M','M/L','M-L','L','L-XL','L/XL','XL','0X','0XL','lXL','1X','1X-2X','1X/2X','XL/2XL','XL-2XL','1XL-2XL','2XL','2X','XXL','2X-3X','2X/3X','2XL-3XL','2XL/3XL','XXXL','3XL','3X','3X-4X','3X/4X','3XL-4XL','3XL/4XL','4XL','5XL','5X','5X-6X','5X/6X','5XL-6XL','5XL/6XL','6XL','6X','7XL','7X','8XL','8X'), cast(intlsize as SIGNED ), color
variationuidrecorduidcolorhexvaluesuppliersizeintlsizeincheseusizeussizeuksizefrsizeessizedesizeitsizeptsizeelsizegendersizegroupcupsizesizetypeitempriceitempromopromoUntilstockuidwarehouseontourpackagingsupplierreservedorderedreturneddefectmanufacturerreferenceeanavailablestockavailablepersizestockpersizeavailablepercolorstockpercolorhaspromounitpricedisplaycomments
1C8961F91-F5BF-4854-8A47D406DDF318DD2087black#000000XLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42wdressXLintlsize41.6250STOCK01100-1030019630366408606366211-11-13041.625all
2D1593B13-4C99-43B8-947AA879FA1427A72086black#0000002XL2XL44-4614-1618-2046-4846-4844-4650-5246-4844-46wdress2XLintlsize41.6250STOCK01000-10400196303664086060333-10-10-13041.625all
3CE371ECC-5A9B-4387-AF37CE65D10F8CEB2085black#0000003XL3XL48-5018-2022-2650-5250-5248-5052-5450-5248-50wdress3XLintlsize41.6250STOCK01200-1060019630366408606034022-12-13041.625all
vatrate
number20
warehouse
string