Maten bekijken
Adeline jurk
Dubbelklikken om te vergroten
SKU: SFBA4638
Adeline jurk
Voorraad:

Mooie mix van stretch imitatieleer en gebloemd visnet.

Sterke punten

  • Volledige ritssluiting aan de voorkant voor een progressief en meeslepend verleidingsspel
  • Flatterende skater snit die je figuur met elegantie en beweging verbetert
  • Sheer kanten inzetstukken aan de zijkanten creëren een sensueel contrast met het kunstleer
  • Afneembare en verstelbare kousenbanden verborgen onder de rok voor een extra verleidelijke touch
  • Achter-de-hals aanpassing voor perfecte ondersteuning en decolleté
Maat:

Weet je niet zeker welke maat je moet kiezen? Raadpleeg onze maattabel

Kleur:
Hoeveelheid:
39.95 €
Goed advies
via chat, facebook of e-mail
Gratis retourneren
binnen 15 dagen *

Adeline jurk grote maat

Productomschrijving

Adeline jurk

Skater model, rits aan de voorkant om met de zenuwen van je partner te spelen.

Verstelbaar achter de hals.

Afneembare kousenbanden onder de rok voor eenvoudig verstellen en verwijderen.

Technische details

  • Samenstelling: Hoogwaardig imitatieleer en transparante kant
  • Stijl: Skaterjurk met volledige ritssluiting aan de voorkant
  • Halslijn: Verstelbaar met striksluiting achter in de nek
  • Bijzondere kenmerken: inzetstukken van transparante kant, decoratieve ritssluiting, afneembare kousenbanden
  • Lengte: halverwege de dij met uitlopende rok
  • Kleur: diepzwart met glanzend effect
  • Inbegrepen accessoires: afneembare en verstelbare kousenbanden

Beschikbaar maten

Beschikbaar van 38-40 tot 48-50

Beschikbare kleuren

Zwart en Rood

Overige technische specificaties

Materiaal Synthetisch leer

Maattabel

Controleer de juiste maat voor jou

Internationale
  • Borst
  • Maat
  • Heupen
38-40
  • 92-100
  • 74-82
  • 98-106
44-46
  • 102-108
  • 86-92
  • 108-114
48-50
  • 110-116
  • 96-102
  • 116-122

Onderhoudstips

  • Alleen met de hand wassen met milde, niet-schurende zeep
  • Veeg voorzichtig schoon met een vochtige doek tussen gebruik
  • Plat aan de lucht laten drogen, uit de buurt van warmtebronnen
  • Vermijd strijken dat het materiaal zou beschadigen
  • Plat bewaren op een koele, droge plaats, vermijd scherpe vouwen
  • Voor maten 42-64, vermijd overmatige wrijving in contactgebieden om het uiterlijk van het materiaal te behouden
  •  

Gebruikstips

Voor de beste pasvorm rits je de jurk helemaal dicht voordat je hem aantrekt en maak je het bandje achter de hals vast, waarbij je het verstelt voor meer of minder decolleté.

De kousenbanden zijn zo ontworpen dat ze gemakkelijk verstelbaar zijn - maak ze vast aan je kousen voordat je ze onder de rok vastmaakt voor meer gemak. Voor een boeiend verleidingsspel laat je je partner geleidelijk de ritssluiting ontdekken en hoe die werkt.

De jurk is ontworpen om met of zonder ondergoed gedragen te worden, afhankelijk van je voorkeur, waarbij de binnenvoering zorgt voor optimaal comfort.

Stijltips

Voor een avondje uit combineer je deze jurk met netkousen en pumps met hoge hakken voor een uitgesproken sensuele look. Minimalistische zilveren sieraden vullen de glanzende look van het kunstleer perfect aan. Voor een extra vleugje durf kies je voor kousen met naden aan de achterkant om de aandacht te vestigen op je benen en kousenbanden. Wat je kapsel betreft, licht golvend haar dat op je schouders valt of een ongestructureerd knotje zal de das achter in je nek benadrukken. Een dieprode lippenstift maakt deze fascinerende look helemaal af en zorgt voor een opvallend contrast met het intense zwart van de jurk.

To Top
Artikelen
Totaal aantal items
Struct
Entries: 108
actions
Array
available
number-1
brand
stringparishollywood
brandcode
stringpuun
branding
stringdivasboudoir,smboudoir
brandmedias
string{"default":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"editorial":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"logo":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""}}
brandmetas
Struct
de
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
el
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
en
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
es
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
fr
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
it
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
nl
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
pt
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
brandname
stringParis Hollywood
breasts
stringna
careinstructions
stringwetlook
categories
stringdivasboudoir.cabaret.dresses.all,divasboudoir.lingerie.sexylingerie.babydoll
category
stringdresses
categorygender
stringf
categorymediadatas
Struct
adult
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string615
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/cabaret/dresses1.jpg
type
stringimg
width
string1336
divasboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
fetishboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
latexboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
legsboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
lustboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
private
Struct
height
string1016
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/private/default.jpg
type
stringimg
width
string703
smboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
categorysizerange
stringauto
colorinfos
Query
Template: /system/api/product/colors.cfc:13
Execution Time: 0.773 ms
Record Count: 2
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,red') > 0
and product_variations.productuid = 'C74B0521-2498-4C95-ADF7D85A1754DA3E'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1blackcolorblakblackblack#000000-11
2redcolorredredred#F50000-10
colorrange
stringblack
colors
stringblack,red
colortype
stringcolor
comments
string
compositions
Struct
Entries: 13
coton
string
elastane
string
free
string
leather
string
lycra
string
metal
string
nylon
string
polyamide
string
polyester
string
polyurethane
string
silk
string
spandex
string
viscose
string
datecreated
Date Time (Europe/Paris)
{ts '2024-10-11 18:53:26'}
defect
number0
dimensions
Struct
Entries: 14
acrylicbones
string
backsideheight
string
diameter
string
flatsteelbones
string
frontsideheight
string
fullheight
string
length
string
modestysize
string
panels
string
sides
string
spiralsteelbones
string
totallength
string
unit
stringcm
wiresize
string
display
stringall
displayfrom
string
displayto
string
grossweight
string
hasbrandinfos
booleanfalse
hascareinstructions
booleantrue
hascolorinfos
booleantrue
hascompositions
booleanfalse
hasdescription
booleantrue
hasdimensions
booleanfalse
hasmaterials
booleantrue
hasotherspecifications
booleanfalse
haspromo
number0
hasshortdescription
booleantrue
hassizeinfos
booleantrue
hasspecifications
booleantrue
hasstockinfos
booleanfalse
hasstylingtips
booleantrue
hasusageinstructions
booleantrue
hasvariations
booleantrue
import
string
inpromo
number0
instockvariations
string
isactive
number1
iscustommade
number0
isdivasize
number0
isfirstprice
number0
isfixedprice
number0
ishot
number0
isnew
number0
isonline
number0
isoutletprice
number0
itemprice
number33.2917
itempromo
string
key
stringr82347-1
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-08-01 16:55:35'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.605 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','nl')
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('c74b0521-2498-4c95-adf7d85a1754da3e',lcase(cart_actions.linkedproducts)) > 0 and cart_actions.linkedproducts is not null
)
id_actionbrandinglanguagenamecodetypeminimumOrdermaximumOrderminimumItemsmaximumItemsmaximumUseallowedItemsquotasusedCountlinkedproductslinkedthemeslinkedbrandslinkeditemparamsactiveFromactiveToisActive
linkedproducts
Query
Template: /system/api/products.cfc:1305
Execution Time: 1.29 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','nl')
and product_categories.language in ('all','nl')
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 <> 'SFBA4638'
group by products.reference
order by products.ishot desc, products.isnew desc, orderidx asc, products.lastupdated desc
productuidreferencetypekeylanguagenamelinkuidcolorsvatratemetadatasdimensionsmediadatastagsthemesisdivasizetotalvariationsvariationlistinpromohaspromoitempromoitempriceunitpricepricespromountilisfixedpriceishotisneworderidxavailablestockinstockvariationsbrandbrandnameshowbranddisplaysizetypeintlsizesizessizerangecategorymediadatascategorysizerangesectioncategorysubcategory
linkuid
string
materials
stringfauxleather
mediadatas
Struct
alt
Struct
height
string1016
isprivate
string0
rating
stringall
src
string/photobank/products/puun/sfba4638/task-31512984-2-1.jpg
type
stringimg
width
string703
back
Struct
height
string1296
isprivate
string0
rating
stringall
src
string/photobank/products/puun/sfba4638/30895705.jpg
type
stringimg
width
string896
default
Struct
height
string1296
isprivate
string0
rating
stringall
src
string/photobank/products/puun/sfba4638/30895705.jpg
type
stringimg
width
string896
variations
Struct
colors
Struct
black
Struct
height
string1212
isprivate
string0
rating
stringall
src
string/photobank/products/puun/sfba4638/30895584.jpg
type
stringimg
width
string838
red
Struct
height
string1016
isprivate
string0
rating
stringall
src
string/photobank/products/puun/sfba4638/task-31512984-2-1.jpg
type
stringimg
width
string703
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-ou-rot
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-ou-kokkino
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-ou-red
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-ou-rojo
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-ou-rouge
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-ou-rosso
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-ou-rood
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-ou-vermelho
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
divasboudoir
Struct
de
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringKleid Adeline<br /><br />Skaterschnitt, Reißverschluss vorne, um mit den Nerven Ihres Partners zu spielen.<br /><br />Anpassung hinter dem Nacken.<br /><br />Abnehmbare Strumpfbänder unter dem Rock platziert, die Sie leicht verstellen oder entfernen können.
guid
stringhttps://dev.divasboudoir.com/de/kleid-in-ubergrosse-adeline-schwarz-ou-rot/sfba4638.htm
highlights
string<ul> <li>Durchgehender Frontreißverschluss für ein progressives und fesselndes Spiel der Verführung</li> <li>Schmeichelnder Patinaschnitt, der Ihre Silhouette mit Eleganz und Bewegung betont</li> <li>Transparente Spitzeneinsätze an den Seiten, die einen sinnlichen Kontrast zum Kunstleder bilden</li> <li>Abnehmbare und verstellbare Strumpfbänder, die unter dem Rock versteckt sind, für einen zusätzlichen verführerischen Touch</li> <li>Hinter dem Nacken anpassbar für einen perfekten Sitz und ein makelloses Dekollet&eacute</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringEntdecken Sie das Kleid Adeline von Diva's Boudoir, dem Spezialisten für sexy Lingerie in großen Größen. Schneller und kostenloser Versand. Französische Boutique.
keywords
string
title
stringKleid in Übergröße Adeline - Kostenloser Schnellversand
seotitle
stringKleid in Übergröße Adeline
seouri
stringkleid-in-ubergrosse-adeline-schwarz-ou-rot
specifications
string<ul> <li>Zusammensetzung: Hochwertiges Kunstleder und transparente Spitze</li> <li>Style: Skaterkleid mit durchgehendem Frontreißverschluss</li> <li>Ausschnitt: Verstellbar mit Befestigung hinter dem Nacken</li> <li>Unterscheidende Details: Einsätze aus transparenter Spitze, dekorativer Reißverschluss, abnehmbare Strumpfbänder</li> <li>Länge: Mitte Oberschenkel mit ausgestelltem Rock</li> <li>Farbe: Tiefschwarz mit Glanzeffekt</li> <li>Inklusive Zubehör: Abnehmbare und verstellbare Strumpfbänder</li> </ul>
stylingtips
string<p>Für einen Abend zu zweit kombinieren Sie dieses Kleid mit Netzstrümpfen und hochhackigen Pumps, um einen ausgesprochen sinnlichen Look zu erzielen. Minimalistischer Silberschmuck ist eine perfekte Ergänzung zum glänzenden Kunstleder. Für einen zusätzlichen Hauch von Kühnheit entscheiden Sie sich für Strümpfe mit Rückennaht, die die Aufmerksamkeit auf Ihre Beine und die Strumpfbänder lenken. Was die Frisur angeht: Leicht gewelltes Haar, das über die Schultern fällt, oder ein unstrukturierter Dutt betonen den Ansatz hinter dem Nacken. Ein Lippenstift in tiefen Rottönen verleiht diesem aufregenden Look den letzten Schliff und bildet einen starken Kontrast zum intensiven Schwarz des Kleides.</p>
summary
stringHübsche Mischung aus elastischem Kunstleder und Netzstoff mit Blumenmuster.
title
stringKleid Adeline
usageinstructions
string<p>Für eine optimale Passform schließen Sie zunächst den Reißverschluss vollständig, bevor Sie das Kleid anziehen. Befestigen Sie dann den Riemen hinter dem Nacken und passen Sie ihn je nach Ihrer Vorliebe für ein mehr oder weniger ausgeprägtes Dekollet&eacute; an.</p> <p>Die Strumpfbänder sind so konzipiert, dass sie sich leicht verstellen lassen - befestigen Sie sie an Ihren Strümpfen, bevor Sie sie unter dem Rock befestigen, um es einfacher zu machen. Um ein fesselndes Spiel der Verführung zu schaffen, lassen Sie Ihre Partnerin den Reißverschluss und seine Funktionsweise nach und nach entdecken.</p> <p>Das Kleid ist so konzipiert, dass es je nach Vorliebe mit oder ohne Unterwäsche getragen werden kann, wobei das Innenfutter in jedem Fall für einen optimalen Tragekomfort sorgt.</p>
el
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringΦόρεμα Adeline<br /><br />Κοπή skater, μπροστινό φερμουάρ για να παίζετε με τα νεύρα του συντρόφου σας.<br /><br />Ρυθμιζόμενο πίσω από το λαιμό.<br /><br />Αποσπώμενες καλτσοδέτες κάτω από τη φούστα για εύκολη ρύθμιση και αφαίρεση.
guid
stringhttps://dev.divasboudoir.com/el/adeline-plus-size-forema-mayro-ou-kokkino/sfba4638.htm
highlights
string<ul> <li>Πλήρες φερμουάρ μπροστά για ένα προοδευτικό και σαγηνευτικό παιχνίδι αποπλάνησης</li> <li>Κολακευτικό skater κόψιμο που αναδεικνύει τη σιλουέτα σας με κομψότητα και κίνηση</li> <li>Διαφανή δαντελένια ένθετα στα πλάγια δημιουργούν μια αισθησιακή αντίθεση με το faux leather</li> <li>Αποσπώμενες και ρυθμιζόμενες καλτσοδέτες κρυμμένες κάτω από τη φούστα για μια επιπλέον σαγηνευτική πινελιά</li> <li>Ρύθμιση πίσω από το λαιμό για τέλεια στήριξη και ντεκολτέ</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringΑνακαλύψτε το φόρεμα Adeline από το Diva's Boudoir, τον ειδικό στα σέξι εσώρουχα για μεγάλα μεγέθη. Δωρεάν γρήγορη παράδοση. Γαλλικό κατάστημα.
keywords
string
title
stringAdeline plus size φόρεμα - Δωρεάν γρήγορη αποστολή
seotitle
stringAdeline plus size φόρεμα
seouri
stringadeline-plus-size-forema-mayro-ou-kokkino
specifications
string<ul> <li>Σύνθεση: Υψηλής ποιότητας ψεύτικο δέρμα και διάφανη δαντέλα</li> <li>Στυλ: Φόρεμα skater με φερμουάρ μπροστά</li> <li>Λαιμόκοψη: Ρυθμιζόμενο με δέσιμο στο πίσω μέρος του λαιμού</li> <li>Διακριτικά χαρακτηριστικά: Διαφανή δαντελένια ένθετα, διακοσμητικό φερμουάρ, αποσπώμενες καλτσοδέτες</li> <li>Μήκος: Μέσο του μηρού με φουσκωτή φούστα</li> <li>Χρώμα: βαθύ μαύρο με γυαλιστερό εφέ</li> <li>Περιλαμβάνονται αξεσουάρ: Αποσπώμενες και ρυθμιζόμενες καλτσοδέτες</li> </ul>
stylingtips
string<p>Για μια βραδινή έξοδο, συνδυάστε αυτό το φόρεμα με διχτυωτές κάλτσες και ψηλοτάκουνες γόβες για μια άκρως αισθησιακή εμφάνιση. Τα μινιμαλιστικά ασημένια κοσμήματα θα συμπληρώσουν τέλεια τη γυαλιστερή όψη του faux leather. Για μια έξτρα πινελιά τόλμης, επιλέξτε κάλτσες με ραφές στο πίσω μέρος για να τραβήξετε την προσοχή στα πόδια και τις καλτσοδέτες σας. Όσον αφορά το χτένισμά σας, τα ελαφρώς κυματιστά μαλλιά που πέφτουν στους ώμους σας ή ένας αδόμητος κότσος θα αναδείξουν τη γραβάτα στο πίσω μέρος του λαιμού σας. Ένα βαθύ κόκκινο κραγιόν θα δώσει την τελευταία πινελιά σε αυτή τη σαγηνευτική εμφάνιση, δημιουργώντας μια εντυπωσιακή αντίθεση με το έντονο μαύρο του φορέματος.</p>
summary
stringΥπέροχο μείγμα από ελαστικό faux δέρμα και φλοράλ διχτυωτό ύφασμα.
title
stringΦόρεμα Adeline
usageinstructions
string<p>Για καλύτερη εφαρμογή, κλείστε το φόρεμα με φερμουάρ μέχρι πάνω πριν το φορέσετε και, στη συνέχεια, κλείστε το λουρί πίσω από το λαιμό, ρυθμίζοντας το για περισσότερο ή λιγότερο ντεκολτέ.</p> <p>Οι καλτσοδέτες έχουν σχεδιαστεί για να ρυθμίζονται εύκολα - συνδέστε τις στις κάλτσες σας πριν τις στερεώσετε κάτω από τη φούστα για ευκολία. Για να δημιουργήσετε ένα σαγηνευτικό παιχνίδι αποπλάνησης, αφήστε τη σύντροφό σας να ανακαλύψει σταδιακά το φερμουάρ και τον τρόπο λειτουργίας του.</p> <p>Το φόρεμα έχει σχεδιαστεί για να φοριέται με ή χωρίς εσώρουχα, ανάλογα με τις προτιμήσεις σας, με την εσωτερική επένδυση να εξασφαλίζει βέλτιστη άνεση σε κάθε περίπτωση.</p>
en
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringAdeline dress<br /><br />Skater cut, front zipper to play with your partner's nerves.<br /><br />Behind-the-neck adjustment.<br /><br />Detachable garters under the skirt for easy adjustment and removal.
guid
stringhttps://dev.divasboudoir.com/en/adeline-plus-size-dress-black-ou-red/sfba4638.htm
highlights
string<ul> <li>Full front zipper for a progressive and captivating game of seduction</li> <li>Flattering skater cut that enhances your silhouette with elegance and movement</li> <li>Sheer lace inserts on sides create a sensual contrast with faux leather</li> <li>Detachable, adjustable garters concealed under the skirt for an extra touch of seduction</li> <li>Behind-the-neck adjustment guarantees perfect support and impeccable d&eacute;collet&eacute</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringDiscover the Adeline dress from Diva's Boudoir, the specialist in sexy plus size lingerie. Fast, free shipping. French boutique.
keywords
string
title
stringAdeline plus size dress - Free fast shipping
seotitle
stringAdeline plus size dress
seouri
stringadeline-plus-size-dress-black-ou-red
specifications
string<ul> <li>Composition: High-quality faux leather and sheer lace</li> <li>Style: Skater dress with full front zipper</li> <li>Neckline: Adjustable with tie at back of neck</li> <li>Distinctive details: Sheer lace inserts, decorative zipper, detachable garters</li> <li>Length: Mid-thigh with flared skirt</li> <li>Color: deep black with shiny effect</li> <li>Accessories included: Detachable and adjustable garters</li> </ul>
stylingtips
string<p>For an evening t&ecirc;te-&agrave;-t&ecirc;te, pair this dress with fishnet stockings and high-heeled pumps for a resolutely sensual look. Minimalist silver jewelry perfectly complements the shiny look of faux leather. For an extra touch of daring, opt for back-seamed stockings that will draw attention to your legs and garters. As for your hairstyle, lightly waved shoulder-length hair or an unstructured chignon will highlight the tie at the nape of your neck. Deep red lipstick adds the finishing touch to this captivating look, creating a striking contrast with the intense black of the dress.</p>
summary
stringLovely mix of elastic faux leather and floral-print fishnet.
title
stringAdeline dress
usageinstructions
string<p>For optimum fit, first zip up fully before putting on the dress, then fasten the strap behind the neck, adjusting according to your preference for more or less neckline.</p> <p>The garters are designed to be easily adjustable - attach them to your stockings before fastening them under the skirt for ease. To create a captivating game of seduction, let your partner gradually discover the zipper and how it works.</p> <p>The dress is designed to be worn with or without underwear, depending on your preference, with the inner lining ensuring optimum comfort either way.</p>
es
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringVestido Adeline<br /><br />Corte skater, cremallera delantera para jugar con los nervios de tu pareja.<br /><br />Ajustable detrás del cuello.<br /><br />Ligueros desmontables bajo la falda para ajustar y quitar fácilmente.
guid
stringhttps://dev.divasboudoir.com/es/vestido-talla-grande-adeline-negro-ou-rojo/sfba4638.htm
highlights
string<ul> <li>Cremallera frontal completa para un juego de seducción progresivo y cautivador</li> <li>Favorecedor corte skater que realza tu figura con elegancia y movimiento</li> <li>Inserciones de encaje transparente en los laterales que crean un sensual contraste con la piel sintética</li> <li>Ligueros desmontables y ajustables ocultos bajo la falda para un toque extra de seducción</li> <li>Ajuste detrás del cuello para una sujeción y un escote perfectos</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringDescubre el vestido Adeline de Diva's Boudoir, la especialista en lencería sexy de talla grande. Entrega rápida y gratuita. Tienda francesa.
keywords
string
title
stringVestido talla grande Adeline - Envío rápido gratuito
seotitle
stringVestido talla grande Adeline
seouri
stringvestido-talla-grande-adeline-negro-ou-rojo
specifications
string<ul> <li>Composición: Piel sintética de alta calidad y encaje transparente</li> <li>Estilo: Vestido skater con cremallera frontal completa</li> <li>Escote: Ajustable con lazo en la nuca</li> <li>Características distintivas: Inserciones de encaje transparente, cremallera decorativa, ligueros desmontables</li> <li>Largo: Medio muslo con falda acampanada</li> <li>Color: negro intenso con efecto brillante</li> <li>Accesorios incluidos: Ligas desmontables y ajustables</li> </ul>
stylingtips
string<p>Para salir por la noche, combina este vestido con medias de rejilla y zapatos de tacón para conseguir un look decididamente sensual. Las joyas plateadas minimalistas complementarán a la perfección el aspecto brillante de la piel sintética. Para un toque extra de atrevimiento, opta por unas medias con costuras traseras para llamar la atención sobre tus piernas y tus ligueros. En cuanto al peinado, una melena ligeramente ondulada que caiga hasta los hombros o un moño desestructurado resaltarán el lazo en la nuca. Un pintalabios rojo intenso dará el toque final a este look cautivador, creando un llamativo contraste con el negro intenso del vestido.</p>
summary
stringEncantadora mezcla de piel sintética elástica y rejilla floral.
title
stringVestido Adeline
usageinstructions
string<p>Para un ajuste óptimo, suba la cremallera del vestido antes de ponérselo y, a continuación, abroche el tirante por detrás del cuello, ajustándolo para tener más o menos escote.</p> <p>Los ligueros se han diseñado para que puedan ajustarse fácilmente: sujételos a las medias antes de abrocharlos bajo la falda para mayor facilidad. Para crear un cautivador juego de seducción, deja que tu pareja descubra poco a poco la cremallera y su funcionamiento.</p> <p>El vestido está diseñado para llevarlo con o sin ropa interior, según sus preferencias, y el forro interior garantiza una comodidad óptima en ambos casos.</p>
fr
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>La robe <strong>Adeline</strong> incarne l'&eacute;quilibre parfait entre audace et sophistication. Sa silhouette patineuse soigneusement &eacute;tudi&eacute;e met en valeur vos courbes avec &eacute;l&eacute;gance, tandis que la jupe &eacute;vas&eacute;e apporte mouvement et dynamisme &agrave; chacun de vos pas, cr&eacute;ant une allure captivante qui ne manquera pas d'attirer tous les regards.</p> <p><br>L'&eacute;l&eacute;ment signature de cette cr&eacute;ation est sans conteste sa <strong>fermeture &eacute;clair int&eacute;grale &agrave; l'avant</strong>. Ce d&eacute;tail aussi fonctionnel que provocant vous permet de contr&ocirc;ler le rythme de la s&eacute;duction, d&eacute;voilant progressivement votre silhouette selon vos envies. Un v&eacute;ritable jeu de patience qui saura faire monter la tension et l'anticipation chez votre partenaire.</p> <p><br>Les empi&egrave;cements en dentelle transparente positionn&eacute;s strat&eacute;giquement sur les c&ocirc;t&eacute;s cr&eacute;ent un contraste saisissant avec le similicuir brillant. Cette dualit&eacute; entre opacit&eacute; et transparence ajoute une dimension visuelle fascinante &agrave; l'ensemble, tout en laissant entrevoir subtilement votre peau pour un effet r&eacute;solument sensuel.</p> <p><br>L'attache derri&egrave;re la nuque assure un ajustement personnalis&eacute; et un maintien optimal du d&eacute;collet&eacute;, vous permettant de vous sentir &agrave; la fois s&eacute;duisante et parfaitement &agrave; l'aise. Ce syst&egrave;me d'attache soigneusement con&ccedil;u garantit que la robe &eacute;pouse parfaitement votre silhouette tout au long de la soir&eacute;e.</p> <p><br>Pour compl&eacute;ter cette cr&eacute;ation d&eacute;j&agrave; remarquable, des <strong>jarreti&egrave;res d&eacute;tachables</strong> sont discr&egrave;tement int&eacute;gr&eacute;es sous la jupe. Enti&egrave;rement r&eacute;glables, elles vous permettent d'accessoiriser votre tenue avec des bas pour une touche de s&eacute;duction suppl&eacute;mentaire, ou de les retirer facilement selon vos pr&eacute;f&eacute;rences et l'occasion.</p>
guid
stringhttps://dev.divasboudoir.com/fr/grande-taille-robe-patineuse-similicuir-zip-integral/sfba4638.htm
highlights
string<ul> <li>Fermeture &eacute;clair int&eacute;grale &agrave; l'avant pour un jeu de s&eacute;duction progressif et captivant</li> <li>Coupe patineuse flatteuse qui sublime votre silhouette avec &eacute;l&eacute;gance et mouvement</li> <li>Empi&egrave;cements en dentelle transparente sur les c&ocirc;t&eacute;s cr&eacute;ant un contraste sensuel avec le similicuir</li> <li>Jarreti&egrave;res d&eacute;tachables et r&eacute;glables dissimul&eacute;es sous la jupe pour une touche de s&eacute;duction suppl&eacute;mentaire</li> <li>Ajustement derri&egrave;re la nuque garantissant un maintien parfait et un d&eacute;collet&eacute; impeccable</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringDécouvrez la robe Adeline de chez Diva's Boudoir, le spécialiste en lingerie sexy grande taille. Envoi rapide et offert. Boutique française.
keywords
string
title
stringRobe grande taille Adeline - Envoi rapide gratuit
seotitle
stringRobe grande taille patineuse en similicuir zip intégral
seouri
stringgrande-taille-robe-patineuse-similicuir-zip-integral
specifications
string<ul> <li>Composition : Similicuir haute qualit&eacute; et dentelle transparente</li> <li>Style : Robe patineuse avec fermeture &eacute;clair frontale int&eacute;grale</li> <li>Encolure : Ajustable avec attache derri&egrave;re la nuque</li> <li>D&eacute;tails distinctifs : Empi&egrave;cements en dentelle transparente, fermeture &eacute;clair d&eacute;corative, jarreti&egrave;res d&eacute;tachables</li> <li>Longueur : Mi-cuisse avec jupe &eacute;vas&eacute;e</li> <li>Couleur : noir intense avec effet brillant</li> <li>Accessoires inclus : Jarreti&egrave;res d&eacute;tachables et r&eacute;glables</li> </ul>
stylingtips
string<p>Pour une soir&eacute;e en t&ecirc;te-&agrave;-t&ecirc;te, associez cette robe avec des bas r&eacute;sille et des escarpins &agrave; talons hauts pour un look r&eacute;solument sensuel. Des bijoux minimalistes en argent compl&eacute;teront parfaitement l'aspect brillant du similicuir. Pour une touche d'audace suppl&eacute;mentaire, optez pour des bas avec couture arri&egrave;re qui attireront l'attention sur vos jambes et les jarreti&egrave;res. C&ocirc;t&eacute; coiffure, des cheveux l&eacute;g&egrave;rement ondul&eacute;s tombant sur les &eacute;paules ou un chignon d&eacute;structur&eacute; mettront en valeur l'attache derri&egrave;re la nuque. Un rouge &agrave; l&egrave;vres dans les tons rouges profonds apportera la touche finale &agrave; ce look captivant, cr&eacute;ant un contraste saisissant avec le noir intense de la robe.</p>
summary
string<p>Succombez au charme irr&eacute;sistible de notre robe Adeline, une cr&eacute;ation aussi audacieuse que s&eacute;duisante. Sa coupe patineuse met en valeur votre silhouette, tandis que sa fermeture &eacute;clair int&eacute;grale &agrave; l'avant promet des moments de s&eacute;duction intense. Avec ses empi&egrave;cements en dentelle transparente et ses jarreti&egrave;res d&eacute;tachables, cette robe incarne l'alliance parfaite entre &eacute;l&eacute;gance et sensualit&eacute; provocante.</p>
title
stringRobe Adeline Désir - Sensualité audacieuse et jeu de séduction
usageinstructions
string<p>Pour un ajustement optimal, commencez par fermer compl&egrave;tement la fermeture &eacute;clair avant d'enfiler la robe, puis attachez la bride derri&egrave;re la nuque en ajustant selon votre pr&eacute;f&eacute;rence pour un d&eacute;collet&eacute; plus ou moins prononc&eacute;.</p> <p>Les jarreti&egrave;res sont con&ccedil;ues pour &ecirc;tre facilement r&eacute;glables - fixez-les &agrave; vos bas avant de les attacher sous la jupe pour plus de facilit&eacute;. Pour cr&eacute;er un jeu de s&eacute;duction captivant, laissez votre partenaire d&eacute;couvrir progressivement la fermeture &eacute;clair et son fonctionnement.</p> <p>La robe est con&ccedil;ue pour &ecirc;tre port&eacute;e avec ou sans sous-v&ecirc;tements selon votre pr&eacute;f&eacute;rence, la doublure int&eacute;rieure assurant un confort optimal dans tous les cas.</p>
it
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringAbito Adeline<br /><br />Taglio skater, zip frontale per giocare con i nervi del partner.<br /><br />Regolabile dietro il collo.<br /><br />Giarrettiere staccabili sotto la gonna per una facile regolazione e rimozione.
guid
stringhttps://dev.divasboudoir.com/it/abito-adeline-taglia-grande-nero-ou-rosso/sfba4638.htm
highlights
string<ul> <li>Zip frontale completa per un gioco di seduzione progressivo e accattivante</li> <li>Taglio skater lusinghiero che esalta la figura con eleganza e movimento</li> <li>Gli inserti in pizzo trasparente sui lati creano un contrasto sensuale con l'ecopelle</li> <li>Giarrettiere staccabili e regolabili nascoste sotto la gonna per un tocco di seduzione in più</li> <li>Regolazione dietro il collo per un sostegno e una scollatura perfetti</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringScoprite l'abito Adeline da Diva's Boudoir, lo specialista della lingerie sexy per taglie grandi. Consegna rapida e gratuita. Negozio francese.
keywords
string
title
stringAbito Adeline taglia grande - Spedizione veloce e gratuita
seotitle
stringAbito Adeline taglia grande
seouri
stringabito-adeline-taglia-grande-nero-ou-rosso
specifications
string<ul> <li>Composizione: Ecopelle di alta qualità e pizzo trasparente</li> <li>Stile: abito skater con zip frontale completa</li> <li>Scollatura: regolabile con laccetto dietro il collo</li> <li>Caratteristiche distintive: inserti in pizzo trasparente, cerniera decorativa, giarrettiere staccabili</li> <li>Lunghezza: metà coscia con gonna svasata</li> <li>Colore: nero intenso con effetto lucido</li> <li>Accessori inclusi: giarrettiere staccabili e regolabili</li> </ul>
stylingtips
string<p>Per una serata fuori, abbinate questo abito a calze a rete e a décolleté con tacco alto per un look decisamente sensuale. Gioielli minimalisti in argento completeranno perfettamente l'aspetto lucido dell'ecopelle. Per un tocco di audacia in più, optate per calze con cuciture posteriori per attirare l'attenzione sulle gambe e sulle giarrettiere. Per quanto riguarda l'acconciatura, i capelli leggermente mossi che cadono sulle spalle o uno chignon non strutturato metteranno in risalto la cravatta sulla nuca. Un rossetto rosso intenso darà il tocco finale a questo look accattivante, creando un contrasto sorprendente con il nero intenso dell'abito.</p>
summary
stringUn bel mix di ecopelle elasticizzata e rete floreale.
title
stringAbito Adeline
usageinstructions
string<p>Per una vestibilità ottimale, chiudere l'abito con la cerniera fino in fondo prima di indossarlo, quindi allacciare il cinturino dietro il collo, regolando per una maggiore o minore scollatura.</p> <p>Le giarrettiere sono state progettate per essere facilmente regolabili: fissatele alle calze prima di allacciarle sotto la gonna. Per creare un accattivante gioco di seduzione, lasciate che il vostro partner scopra gradualmente la cerniera e il suo funzionamento.</p> <p>L'abito è progettato per essere indossato con o senza biancheria intima, a seconda delle preferenze, e la fodera interna garantisce un comfort ottimale in entrambi i casi.</p>
nl
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringAdeline jurk<br /><br />Skater model, rits aan de voorkant om met de zenuwen van je partner te spelen.<br /><br />Verstelbaar achter de hals.<br /><br />Afneembare kousenbanden onder de rok voor eenvoudig verstellen en verwijderen.
guid
stringhttps://dev.divasboudoir.com/nl/adeline-jurk-grote-maat-zwart-ou-rood/sfba4638.htm
highlights
string<ul> <li>Volledige ritssluiting aan de voorkant voor een progressief en meeslepend verleidingsspel</li> <li>Flatterende skater snit die je figuur met elegantie en beweging verbetert</li> <li>Sheer kanten inzetstukken aan de zijkanten creëren een sensueel contrast met het kunstleer</li> <li>Afneembare en verstelbare kousenbanden verborgen onder de rok voor een extra verleidelijke touch</li> <li>Achter-de-hals aanpassing voor perfecte ondersteuning en decolleté</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringOntdek de Adeline jurk van Diva's Boudoir, de specialist in sexy lingerie voor grote maten. Gratis snelle levering. Franse winkel.
keywords
string
title
stringAdeline jurk grote maat - Gratis snelle verzending
seotitle
stringAdeline jurk grote maat
seouri
stringadeline-jurk-grote-maat-zwart-ou-rood
specifications
string<ul> <li>Samenstelling: Hoogwaardig imitatieleer en transparante kant</li> <li>Stijl: Skaterjurk met volledige ritssluiting aan de voorkant</li> <li>Halslijn: Verstelbaar met striksluiting achter in de nek</li> <li>Bijzondere kenmerken: inzetstukken van transparante kant, decoratieve ritssluiting, afneembare kousenbanden</li> <li>Lengte: halverwege de dij met uitlopende rok</li> <li>Kleur: diepzwart met glanzend effect</li> <li>Inbegrepen accessoires: afneembare en verstelbare kousenbanden</li> </ul>
stylingtips
string<p>Voor een avondje uit combineer je deze jurk met netkousen en pumps met hoge hakken voor een uitgesproken sensuele look. Minimalistische zilveren sieraden vullen de glanzende look van het kunstleer perfect aan. Voor een extra vleugje durf kies je voor kousen met naden aan de achterkant om de aandacht te vestigen op je benen en kousenbanden. Wat je kapsel betreft, licht golvend haar dat op je schouders valt of een ongestructureerd knotje zal de das achter in je nek benadrukken. Een dieprode lippenstift maakt deze fascinerende look helemaal af en zorgt voor een opvallend contrast met het intense zwart van de jurk.</p>
summary
stringMooie mix van stretch imitatieleer en gebloemd visnet.
title
stringAdeline jurk
usageinstructions
string<p>Voor de beste pasvorm rits je de jurk helemaal dicht voordat je hem aantrekt en maak je het bandje achter de hals vast, waarbij je het verstelt voor meer of minder decolleté.</p> <p>De kousenbanden zijn zo ontworpen dat ze gemakkelijk verstelbaar zijn - maak ze vast aan je kousen voordat je ze onder de rok vastmaakt voor meer gemak. Voor een boeiend verleidingsspel laat je je partner geleidelijk de ritssluiting ontdekken en hoe die werkt.</p> <p>De jurk is ontworpen om met of zonder ondergoed gedragen te worden, afhankelijk van je voorkeur, waarbij de binnenvoering zorgt voor optimaal comfort.</p>
pt
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringVestido Adeline<br /><br />Corte skater, fecho à frente para brincar com os nervos do seu parceiro.<br /><br />Ajustável atrás do pescoço.<br /><br />Ligas amovíveis por baixo da saia para ajustar e retirar facilmente.
guid
stringhttps://dev.divasboudoir.com/pt/vestido-adeline-plus-size-preto-ou-vermelho/sfba4638.htm
highlights
string<ul> <li>Fecho frontal completo para um jogo de sedução progressivo e cativante</li> <li>Corte de skater lisonjeiro que realça a sua figura com elegância e movimento</li> <li>As inserções de renda transparente nos lados criam um contraste sensual com a pele sintética</li> <li>Ligas amovíveis e ajustáveis escondidas sob a saia para um toque extra sedutor</li> <li>Ajuste atrás do pescoço para um apoio e decote perfeitos</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringDescubra o vestido Adeline da Diva's Boudoir, a especialista em lingerie sexy plus size. Entrega rápida e gratuita. Loja francesa.
keywords
string
title
stringVestido Adeline plus size - Envio rápido e gratuito
seotitle
stringVestido Adeline plus size
seouri
stringvestido-adeline-plus-size-preto-ou-vermelho
specifications
string<ul> <li>Composição: Pele sintética de alta qualidade e renda pura</li> <li>Estilo: Vestido skater com fecho de correr à frente</li> <li>Decote: Ajustável com laço na parte de trás do pescoço</li> <li>Caraterísticas distintivas: Inserções de renda transparente, fecho de correr decorativo, ligas amovíveis</li> <li>Comprimento: A meio da coxa com saia larga</li> <li>Cor: preto profundo com efeito brilhante</li> <li>Acessórios incluídos: Ligas amovíveis e ajustáveis</li> </ul>
stylingtips
string<p>Para uma saída à noite, combine este vestido com meias de rede e sapatos de salto alto para um visual resolutamente sensual. As jóias prateadas minimalistas complementarão na perfeição o aspeto brilhante da pele sintética. Para um toque extra de ousadia, opte por meias com costuras atrás para chamar a atenção para as suas pernas e ligas. Quanto ao seu penteado, um cabelo ligeiramente ondulado que caia até aos ombros ou um carrapito desestruturado irá realçar a gravata na parte de trás do seu pescoço. Um batom vermelho intenso dará o toque final a este look cativante, criando um contraste marcante com o preto intenso do vestido.</p>
summary
stringUma mistura encantadora de pele sintética elástica e rede floral.
title
stringVestido Adeline
usageinstructions
string<p>Para um melhor ajuste, feche o vestido até cima antes de o vestir e, em seguida, aperte a alça atrás do pescoço, ajustando para mais ou menos decote.</p> <p>As ligas foram concebidas para serem facilmente ajustáveis - prenda-as às suas meias antes de as apertar por baixo da saia para maior facilidade. Para criar um jogo de sedução cativante, deixe o seu parceiro descobrir gradualmente o fecho e o seu funcionamento.</p> <p>O vestido foi concebido para ser usado com ou sem roupa interior, dependendo da sua preferência, com o forro interior a garantir um conforto ótimo em qualquer dos casos.</p>
fetishboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz-ou-rot
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-ou-kokkino
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-ou-red
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-ou-rojo
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-ou-rouge
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-ou-rosso
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-ou-rood
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-ou-vermelho
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-ou-rot
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-ou-kokkino
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-ou-red
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-ou-rojo
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-ou-rouge
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-ou-rosso
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-ou-rood
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-ou-vermelho
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-ou-rot
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-ou-kokkino
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-ou-red
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-ou-rojo
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-ou-rouge
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-ou-rosso
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-ou-rood
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-ou-vermelho
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-ou-rot
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-ou-kokkino
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-ou-red
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-ou-rojo
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-ou-rouge
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-ou-rosso
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-ou-rood
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-ou-vermelho
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
smboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringKleid Adeline aus Kunstleder und Netzgewebe.<br /><br />Skater-Schnitt, Reißverschluss an der Vorderseite, um mit den Nerven Ihres Partners zu spielen.<br /><br />Anpassung hinter dem Nacken.<br /><br />Abnehmbare Strumpfbänder unter dem Rock platziert, die Sie leicht verstellen oder entfernen können.
highlights
string<ul> <li>Durchgehender Frontreißverschluss für volle Kontrolle über das Tempo Ihrer Dominanzspiele</li> <li>Schmeichelnder Skater-Schnitt, der Ihre Silhouette betont und gleichzeitig wesentliche Bewegungsfreiheit ermöglicht</li> <li>Transparente Spitzeneinsätze an den Seiten schaffen einen visuellen Fetisch-Kontrast zum glänzenden Kunstleder</li> <li>Abnehmbare und verstellbare Strumpfbänder, die unter dem Rock verborgen sind, um das Anbringen von Zwangszubehör zu erleichtern</li> <li>Verstellbare Nackenpartie, die auch bei intensiven Sessions für perfekten Halt sorgt</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringEntdecken Sie das Kleid Adeline von The BDSM Boudoir, dem Spezialisten für sexy Lingerie in großen Größen. Schneller und kostenloser Versand. Französische Boutique.
keywords
string
title
stringKleid Adeline in großen Größen - The BDSM Boudoir
seotitle
stringKleid in Übergröße aus Kunstleder Adeline
seouri
stringkleid-in-ubergrosse-aus-kunstleder-adeline-schwarz-ou-rot
specifications
string<ul> <li>Zusammensetzung: Hochwertiges Kunstleder und strapazierfähige, transparente Spitze</li> <li>Stil: BDSM-Patinenkleid mit durchgehendem Frontreißverschluss</li> <li>Ausschnitt: Verstellbarer Ausschnitt mit verstärkter Befestigung hinter dem Nacken</li> <li>Unterscheidende Details: Einsätze aus transparenter Spitze, robuster Reißverschluss, abnehmbare Strumpfbänder</li> <li>Länge: Mittlerer Oberschenkel mit ausgestelltem Rock, der Bewegungsfreiheit ermöglicht</li> <li>Farbe: Tiefschwarz mit glänzendem Fetish-Effekt</li> <li>Inklusive Zubehör: Abnehmbare und verstellbare Strumpfbänder, die mit verschiedenen Accessoires kompatibel sind</li> </ul>
stylingtips
string<p>Für eine Dominanz-Session kombinieren Sie dieses Kleid mit Vinyl-Stiefeln und passenden langen Handschuhen für einen unwiderstehlichen autoritären Look. Ergänzen Sie es mit einer Peitsche oder Gerte aus unserer Kollektion, um Ihre dominante Position zu unterstreichen. Für einen eleganten Unterwerfungslook wählen Sie eine Halskette mit Leine und Netzstrümpfe, die die Strumpfbänder hervorheben. Metallische Accessoires wie leichte Ketten oder dekorative Klammern fügen eine zusätzliche visuelle Dimension hinzu, die die Atmosphäre Ihrer Rollenspiele intensivieren wird. Denken Sie daran, dass die Haltung genauso wichtig ist wie das Outfit - tragen Sie dieses Kleid mit dem Selbstbewusstsein, das es ausstrahlt, ob Sie nun in einer dominanten oder unterwürfigen Rolle sind.</p>
summary
stringHübsche Mischung aus elastischem Kunstleder und Netzgewebe, abnehmbare Strumpfbänder.
title
stringKleid Adeline aus Kunstleder
usageinstructions
string<p>Für eine optimale Passform schließen Sie zunächst den Reißverschluss vollständig, bevor Sie das Kleid anziehen, und befestigen Sie dann den Riemen fest hinter dem Nacken. Die Strumpfbänder sind so konzipiert, dass sie verschiedene Accessoires tragen können - befestigen Sie sie je nach Szenario an Ihren Strümpfen oder an leichten Zwangsfesseln.</p> <p>Der Frontreißverschluss kann als zentrales Element eines Machtspiels eingesetzt werden, bei dem der Dominante das Tempo der Enthüllung bestimmt.</p> <p>Um das Erlebnis zu intensivieren, kombinieren Sie es mit anderen BDSM-Accessoires aus unserer Kollektion wie Handschellen oder einem passenden Halsband.</p> <p>Wie bei jeder BDSM-Praxis sollten Sie immer ein Sicherheitswort festlegen und sich vor jeder Sitzung der gegenseitigen Zustimmung versichern.</p>
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringΦόρεμα Adeline από ψεύτικο δέρμα και δίχτυ.<br /><br />Κούρεμα skater, μπροστινό φερμουάρ για να παίζετε με τα νεύρα του συντρόφου σας.<br /><br />Ρυθμιζόμενο πίσω από το λαιμό.<br /><br />Αποσπώμενες καλτσοδέτες κάτω από τη φούστα για εύκολη ρύθμιση και αφαίρεση.
highlights
string<ul> <li>Πλήρες φερμουάρ μπροστά για απόλυτο έλεγχο του ρυθμού των παιχνιδιών κυριαρχίας σας</li> <li>Κολακευτικό κόψιμο skater που ενισχύει τη σιλουέτα σας, ενώ επιτρέπει την ουσιαστική ελευθερία κινήσεων</li> <li>Διαφανή ένθετα από δαντέλα στα πλαϊνά δημιουργούν μια φετιχιστική οπτική αντίθεση με το γυαλιστερό faux leather</li> <li>Αποσπώμενες και ρυθμιζόμενες καλτσοδέτες κρυμμένες κάτω από τη φούστα για εύκολη τοποθέτηση αξεσουάρ περιορισμού</li> <li>Ρύθμιση πίσω από το λαιμό για τέλεια στήριξη ακόμη και κατά τη διάρκεια έντονων συνεδριών</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringΑνακαλύψτε το φόρεμα Adeline από το The Bdsm Boudoir, τον ειδικό στα σέξι εσώρουχα plus size. Δωρεάν γρήγορη παράδοση. Γαλλικό κατάστημα.
keywords
string
title
stringAdeline plus size φόρεμα - The Bdsm Boudoir
seotitle
stringAdeline φόρεμα μεγάλου μεγέθους από faux δέρμα
seouri
stringadeline-forema-megaloy-megethoys-apo-faux-derma-mayro-ou-kokkino
specifications
string<ul> <li>Σύνθεση: Υψηλής ποιότητας ψεύτικο δέρμα και ανθεκτική διάφανη δαντέλα</li> <li>Στυλ: BDSM φόρεμα skater με φερμουάρ μπροστά</li> <li>Λαιμόκοψη: Ρυθμιζόμενη με ενισχυμένο δέσιμο στο πίσω μέρος του λαιμού</li> <li>Διακριτικά χαρακτηριστικά: Διαφανή δαντελένια ένθετα, φερμουάρ βαρέως τύπου, αποσπώμενες καλτσοδέτες</li> <li>Μήκος: Μέσο του μηρού με φουσκωτή φούστα για ελευθερία κινήσεων</li> <li>Χρώμα: Έντονο μαύρο με φετίχ γυαλιστερό εφέ</li> <li>Περιλαμβάνονται αξεσουάρ: Αποσπώμενες και ρυθμιζόμενες καλτσοδέτες συμβατές με διάφορα αξεσουάρ</li> </ul>
stylingtips
string<p>Για μια συνεδρία κυριαρχίας, συνδυάστε αυτό το φόρεμα με βινυλικές μπότες μέχρι το ύψος των μηρών και ασορτί μακριά γάντια για μια ακαταμάχητη εμφάνιση εξουσίας. Συμπληρώστε το με ένα μαστίγιο ή ένα μαστίγιο ιππασίας από τη συλλογή μας για να επιβεβαιώσετε την κυρίαρχη θέση σας. Για μια κομψή υποτακτική εμφάνιση, επιλέξτε ένα κολιέ με λουρί και διχτυωτές κάλτσες για να αναδείξετε τις καλτσοδέτες σας. Τα μεταλλικά αξεσουάρ, όπως οι ελαφριές αλυσίδες ή τα διακοσμητικά κλιπ, θα προσθέσουν μια επιπλέον οπτική διάσταση που θα εντείνει την ατμόσφαιρα του παιχνιδιού ρόλων σας. Να θυμάστε ότι η συμπεριφορά είναι εξίσου σημαντική με το ντύσιμο - φορέστε αυτό το φόρεμα με την αυτοπεποίθηση που σας εμπνέει, είτε είστε σε κυρίαρχο είτε σε υποτακτικό ρόλο.</p>
summary
stringΌμορφο μείγμα από ελαστικό faux δέρμα και δίχτυ, αποσπώμενες καλτσοδέτες.
title
stringΦόρεμα Adeline από faux δέρμα
usageinstructions
string<p>Για καλύτερη εφαρμογή, κλείστε το φερμουάρ πλήρως πριν φορέσετε το φόρεμα και, στη συνέχεια, στερεώστε καλά τον ιμάντα πίσω από το λαιμό. Οι καλτσοδέτες έχουν σχεδιαστεί για να υποστηρίζουν διάφορα αξεσουάρ - συνδέστε τις με τις κάλτσες σας ή με ελαφριά δεσμά συγκράτησης ανάλογα με το σενάριό σας.</p> <p>Το μπροστινό φερμουάρ μπορεί να χρησιμοποιηθεί ως το επίκεντρο ενός παιχνιδιού εξουσίας, όπου ο κυρίαρχος παίκτης ελέγχει το ρυθμό της αποκάλυψης.</p> <p>Για να εντείνετε την εμπειρία, συνδυάστε το με άλλα αξεσουάρ BDSM από τη συλλογή μας, όπως χειροπέδες ή ένα ταιριαστό κολιέ.</p> <p>Όπως συμβαίνει με όλες τις πρακτικές BDSM, καθιερώστε πάντα μια ασφαλή λέξη και εξασφαλίστε την αμοιβαία συναίνεση πριν από κάθε συνεδρία.</p>
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringAdeline dress in faux leather and fishnet.<br /><br />Skater cut, front zipper to play with your partner's nerves.<br /><br />Behind-the-neck adjustment.<br /><br />Detachable garters under the skirt for easy adjustment and removal.
highlights
string<ul> <li>Full front zipper for total control over the rhythm of your domination games</li> <li>Flattering skater cut that enhances your silhouette while allowing essential freedom of movement</li> <li>Sheer lace inserts on the sides create a fetish-like visual contrast with shiny faux leather</li> <li>Detachable, adjustable garters concealed under the skirt for easy attachment of restraint accessories</li> <li>Behind-the-neck adjustment for perfect support even during intense sessions</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringDiscover the Adeline dress from The BDSM Boudoir, the specialist in sexy plus size lingerie. Fast, free shipping. French boutique.
keywords
string
title
stringPlus size dress Adeline - The Bdsm Boudoir
seotitle
stringAdeline plus size dress in leatherette
seouri
stringadeline-plus-size-dress-in-leatherette-black-ou-red
specifications
string<ul> <li>Composition: High-quality imitation leather and resistant transparent lace</li> <li>Style: BDSM skater dress with full front zipper</li> <li>Neckline: Adjustable with reinforced tie at back of neck</li> <li>Distinctive details: Sheer lace inserts, heavy-duty zipper, detachable garters</li> <li>Length: Mid-thigh with flared skirt for freedom of movement</li> <li>Color: Intense black with fetish gloss effect</li> <li>Accessories included: Detachable, adjustable garters compatible with various accessories</li> </ul>
stylingtips
string<p>For a dominance session, pair this dress with vinyl thigh-high boots and matching long gloves for an irresistible authoritative look. Complete with a whip or riding crop from our collection to assert your dominant position. For an elegantly submissive look, opt for a leash necklace and fishnet stockings to highlight the garters. Metallic accessories such as light chains or decorative clips will add an extra visual dimension that will intensify the atmosphere of your role-playing. Remember that attitude is as important as outfit - wear this dress with the confidence it inspires, whether you're in a dominant or submissive role.</p>
summary
stringLovely mix of elastic faux leather and fishnet, detachable garters.
title
stringAdeline dress in imitation leather
usageinstructions
string<p>For optimum fit, first zip up completely before putting on the dress, then securely fasten the strap behind the neck. The garters are designed to support a variety of accessories - attach them to your stockings or to lightweight restraint ties depending on your scenario.</p> <p>The front zipper can be used as the centerpiece of a power play, where the dominant controls the pace of the unveiling.</p> <p>To intensify the experience, combine with other BDSM accessories from our collection, such as handcuffs or a matching necklace.</p> <p>As with any BDSM practice, always establish a safe word and ensure mutual consent before each session.</p>
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringVestido Adeline de piel sintética y rejilla.<br /><br />Corte skater, cremallera delantera para jugar con los nervios de tu pareja.<br /><br />Ajustable detrás del cuello.<br /><br />Ligueros desmontables bajo la falda para ajustar y quitar fácilmente.
highlights
string<ul> <li>Cremallera frontal completa para un control total sobre el ritmo de tus juegos de dominación</li> <li>Favorecedor corte skater que realza tu figura a la vez que permite una libertad de movimientos esencial</li> <li>Inserciones de encaje transparente en los laterales que crean un contraste visual fetichista con la piel sintética brillante</li> <li>Ligueros desmontables y ajustables ocultos bajo la falda para facilitar la colocación de accesorios de sujeción</li> <li>Ajuste detrás del cuello para una sujeción perfecta incluso durante sesiones intensas</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringDescubre el vestido Adeline de The BDSM Boudoir, especialista en lencería sexy de talla grande. Entrega rápida y gratuita. Tienda francesa.
keywords
string
title
stringAdeline talla grande vestido - The BDSM Boudoir
seotitle
stringVestido Adeline talla grande en polipiel
seouri
stringvestido-adeline-talla-grande-en-polipiel-negro-ou-rojo
specifications
string<ul> <li>Composición: Piel sintética de alta calidad y encaje transparente resistente</li> <li>Estilo: Vestido skater BDSM con cremallera frontal completa</li> <li>Escote: Ajustable con lazo reforzado en la nuca</li> <li>Características distintivas: Inserciones de encaje transparente, cremallera resistente, ligueros desmontables</li> <li>Largo: A medio muslo con falda acampanada para mayor libertad de movimiento</li> <li>Color: Negro intenso con efecto fetiche brillante</li> <li>Accesorios incluidos: Ligas desmontables y ajustables compatibles con varios accesorios</li> </ul>
stylingtips
string<p>Para una sesión de dominación, combina este vestido con botas de vinilo hasta el muslo y guantes largos a juego para una irresistible imagen de autoridad. Compleméntalo con un látigo o una fusta de nuestra colección para reafirmar tu posición dominante. Para un look elegantemente sumiso, opta por un collar de correa y unas medias de rejilla para lucir tus ligueros. Los accesorios metálicos, como las cadenas de luces o los clips decorativos, añadirán una dimensión visual adicional que intensificará la atmósfera de tu juego de rol. Recuerda que la actitud es tan importante como la vestimenta: lleva este vestido con la confianza que inspira, tanto si estás en un papel dominante como sumiso.</p>
summary
stringPreciosa mezcla de piel sintética elástica y rejilla, con ligueros desmontables.
title
stringVestido Adeline de piel sintética
usageinstructions
string<p>Para un ajuste óptimo, suba completamente la cremallera antes de ponerse el vestido y, a continuación, sujete firmemente el tirante por detrás del cuello. Los ligueros están diseñados para sujetar diversos accesorios: sujétalos a las medias o a ligeros lazos de sujeción, según el escenario.</p> <p>La cremallera frontal puede utilizarse como pieza central de un juego de poder, en el que la jugadora dominante controla el ritmo del destape.</p> <p>Para intensificar la experiencia, combínalo con otros accesorios BDSM de nuestra colección, como unas esposas o un collar a juego.</p> <p>Como en todas las prácticas BDSM, establece siempre una palabra de seguridad y asegúrate del consentimiento mutuo antes de cada sesión.</p>
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>La robe <strong>Adeline incarne l'&eacute;quilibre parfait entre esth&eacute;tique BDSM et fonctionnalit&eacute; pratique</strong>. Sa silhouette patineuse soigneusement &eacute;tudi&eacute;e met en valeur vos courbes avec autorit&eacute;, tandis que la jupe &eacute;vas&eacute;e offre une libert&eacute; de mouvement essentielle pour exercer votre domination ou appr&eacute;cier votre soumission avec gr&acirc;ce et confort.<br>L'&eacute;l&eacute;ment signature de cette cr&eacute;ation est sans conteste sa fermeture &eacute;clair int&eacute;grale &agrave; l'avant. Ce d&eacute;tail aussi fonctionnel que symbolique vous permet, ou &agrave; votre partenaire, de contr&ocirc;ler pr&eacute;cis&eacute;ment le rythme du d&eacute;voilement. Un v&eacute;ritable instrument de pouvoir qui transforme <strong>l'habillage et le d&eacute;shabillage en un rituel de domination ou de soumission &agrave; part enti&egrave;re</strong>.<br>Les empi&egrave;cements en dentelle transparente positionn&eacute;s strat&eacute;giquement sur les c&ocirc;t&eacute;s cr&eacute;ent un contraste saisissant avec le similicuir brillant. Cette <strong>dualit&eacute; entre opacit&eacute; et transparence</strong> ajoute une dimension visuelle fetish &agrave; l'ensemble, tout en laissant entrevoir subtilement votre peau pour un effet r&eacute;solument provocant qui intensifiera chaque sc&egrave;ne.<br>L'attache derri&egrave;re la nuque assure un ajustement personnalis&eacute; et un maintien optimal du d&eacute;collet&eacute;, vous permettant de vous sentir parfaitement s&eacute;curis&eacute;e m&ecirc;me lors de sessions intenses. Ce syst&egrave;me d'attache soigneusement con&ccedil;u garantit que la robe reste en place quelles que soient vos activit&eacute;s.<br>Pour compl&eacute;ter cette cr&eacute;ation d&eacute;j&agrave; remarquable, des jarreti&egrave;res d&eacute;tachables sont discr&egrave;tement int&eacute;gr&eacute;es sous la jupe. Enti&egrave;rement r&eacute;glables, elles vous permettent non seulement d'accessoiriser votre tenue avec des bas, mais aussi d'attacher facilement divers accessoires de contrainte pour enrichir vos sc&eacute;narios BDSM selon vos envies et limites convenues.</p>
highlights
string<ul> <li>Fermeture &eacute;clair int&eacute;grale &agrave; l'avant pour un contr&ocirc;le total sur le rythme de vos jeux de domination</li> <li>Coupe patineuse flatteuse qui sublime votre silhouette tout en permettant une libert&eacute; de mouvement essentielle</li> <li>Empi&egrave;cements en dentelle transparente sur les c&ocirc;t&eacute;s cr&eacute;ant un contraste visuel fetish avec le similicuir brillant</li> <li>Jarreti&egrave;res d&eacute;tachables et r&eacute;glables dissimul&eacute;es sous la jupe pour attacher facilement des accessoires de contrainte</li> <li>Ajustement derri&egrave;re la nuque offrant un maintien parfait m&ecirc;me lors de sessions intenses</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringDécouvrez notre robe BDSM grande taille Adeline avec zip intégral, empiècements transparents et jarretières détachables. Livraison discrète et rapide !
keywords
string
title
stringRobe Grande Taille BDSM Zip Intégral Jarretières | The BDSM Boudoir
seotitle
stringRobe grande taille BDSM similicuir zip intégral jarretières
seouri
stringgrande-taille-robe-bdsm-similicuir-zip-integral-jarretieres
specifications
string<ul> <li>Composition : Similicuir haute qualit&eacute; et dentelle transparente r&eacute;sistante</li> <li>Style : Robe patineuse BDSM avec fermeture &eacute;clair frontale int&eacute;grale</li> <li>Encolure : Ajustable avec attache renforc&eacute;e derri&egrave;re la nuque</li> <li>D&eacute;tails distinctifs : Empi&egrave;cements en dentelle transparente, fermeture &eacute;clair robuste, jarreti&egrave;res d&eacute;tachables</li> <li>Longueur : Mi-cuisse avec jupe &eacute;vas&eacute;e permettant une libert&eacute; de mouvement</li> <li>Couleur : noir intense avec effet brillant fetish</li> <li>Accessoires inclus : Jarreti&egrave;res d&eacute;tachables et r&eacute;glables compatibles avec divers accessoires</li> </ul>
stylingtips
string<p>Pour une session de domination, associez cette robe avec des cuissardes en vinyle et des gants longs assortis pour une allure autoritaire irr&eacute;sistible. Compl&eacute;tez avec un fouet ou une cravache de notre collection pour affirmer votre position dominante. Pour un look de soumission &eacute;l&eacute;gante, optez pour un collier avec laisse et des bas r&eacute;sille qui mettront en valeur les jarreti&egrave;res. Les accessoires m&eacute;talliques comme des cha&icirc;nes l&eacute;g&egrave;res ou des pinces d&eacute;coratives ajouteront une dimension visuelle suppl&eacute;mentaire qui intensifiera l'atmosph&egrave;re de vos jeux de r&ocirc;le. N'oubliez pas que l'attitude est aussi importante que la tenue - portez cette robe avec la confiance qu'elle inspire, que vous soyez dans un r&ocirc;le dominant ou soumis.</p>
summary
string<p>Ma&icirc;trisez l'art de la s&eacute;duction avec notre robe Adeline, une cr&eacute;ation BDSM aussi audacieuse que dominante. Sa coupe patineuse met en valeur votre silhouette, tandis que sa fermeture &eacute;clair int&eacute;grale &agrave; l'avant offre un contr&ocirc;le total sur le rythme du jeu.</p> <p>Avec ses empi&egrave;cements en dentelle transparente et ses jarreti&egrave;res d&eacute;tachables, cette robe incarne l'alliance parfaite entre esth&eacute;tique fetish et fonctionnalit&eacute; pour vos sc&eacute;narios les plus intenses.</p>
title
stringRobe Adeline Domination - Sensualité provocante et contrôle absolu
usageinstructions
string<p>Pour un ajustement optimal, commencez par fermer compl&egrave;tement la fermeture &eacute;clair avant d'enfiler la robe, puis attachez solidement la bride derri&egrave;re la nuque. Les jarreti&egrave;res sont con&ccedil;ues pour supporter divers accessoires - fixez-les &agrave; vos bas ou &agrave; des liens de contrainte l&eacute;gers selon votre sc&eacute;nario.</p> <p>La fermeture &eacute;clair frontale peut &ecirc;tre utilis&eacute;e comme &eacute;l&eacute;ment central d'un jeu de pouvoir, o&ugrave; le dominant contr&ocirc;le le rythme du d&eacute;voilement.</p> <p>Pour intensifier l'exp&eacute;rience, combinez avec d'autres accessoires BDSM de notre collection comme des menottes ou un collier assorti.</p> <p>Comme pour toute pratique BDSM, &eacute;tablissez toujours un mot de s&eacute;curit&eacute; et assurez-vous du consentement mutuel avant chaque session.</p>
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringAbito Adeline in ecopelle e rete.<br /><br />Taglio skater, zip frontale per giocare con i nervi del partner.<br /><br />Regolabile dietro il collo.<br /><br />Giarrettiere staccabili sotto la gonna per una facile regolazione e rimozione.
highlights
string<ul> <li>Zip frontale completa per un controllo totale sul ritmo dei tuoi giochi di dominazione</li> <li>Taglio skater lusinghiero che esalta la figura e consente un'essenziale libertà di movimento</li> <li>Gli inserti in pizzo trasparente sui lati creano un contrasto visivo fetish con l'ecopelle lucida</li> <li>Giarrettiere staccabili e regolabili nascoste sotto la gonna per un facile fissaggio degli accessori di contenzione</li> <li>Regolazione dietro il collo per un sostegno perfetto anche durante le sessioni più intense</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringScoprite l'abito Adeline da The BDSM Boudoir, lo specialista della lingerie sexy per taglie grandi. Consegna rapida e gratuita. Negozio francese.
keywords
string
title
stringAbito Adeline taglia grande - The BDSM Boudoir
seotitle
stringAbito Adeline di taglia grande in ecopelle
seouri
stringabito-adeline-di-taglia-grande-in-ecopelle-nero-ou-rosso
specifications
string<ul> <li>Composizione: ecopelle di alta qualità e resistente pizzo trasparente</li> <li>Stile: abito skater BDSM con zip frontale completa</li> <li>Scollatura: regolabile con laccetto rinforzato dietro il collo</li> <li>Caratteristiche distintive: inserti in pizzo trasparente, zip resistente, giarrettiere staccabili</li> <li>Lunghezza: metà coscia con gonna svasata per libertà di movimento</li> <li>Colore: nero intenso con effetto lucido fetish</li> <li>Accessori inclusi: giarrettiere staccabili e regolabili compatibili con vari accessori</li> </ul>
stylingtips
string<p>Per una sessione di dominazione, abbinate questo abito a stivali alti in vinile e guanti lunghi coordinati per un irresistibile look di autorità. Completate il tutto con una frusta o un frustino della nostra collezione per affermare la vostra posizione dominante. Per un look elegantemente sottomesso, optate per una collana con guinzaglio e calze a rete per mostrare il reggicalze. Accessori metallici come catene luminose o clip decorative aggiungeranno una dimensione visiva extra che intensificherà l'atmosfera del vostro gioco di ruolo. Ricordate che l'atteggiamento è importante quanto l'abito: indossate questo vestito con la fiducia che ispira, sia che siate in un ruolo dominante o sottomesso.</p>
summary
stringBellissimo mix di ecopelle elasticizzata e rete, giarrettiere staccabili.
title
stringAbito Adeline in ecopelle
usageinstructions
string<p>Per una vestibilità ottimale, chiudere completamente la cerniera prima di indossare l'abito, quindi allacciare saldamente il cinturino dietro il collo. Le giarrettiere sono progettate per supportare una varietà di accessori: attaccatele alle calze o a lacci di contenzione leggeri, a seconda dello scenario.</p> <p>La cerniera anteriore può essere utilizzata come fulcro di un gioco di potere, in cui il giocatore dominante controlla il ritmo dello svelamento.</p> <p>Per intensificare l'esperienza, abbinatela ad altri accessori BDSM della nostra collezione, come le manette o una collana coordinata.</p> <p>Come per tutte le pratiche BDSM, stabilire sempre una parola di sicurezza e assicurarsi del consenso reciproco prima di ogni sessione.</p>
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringAdeline jurk van imitatieleer en visnet.<br /><br />Skater model, rits aan de voorkant om met de zenuwen van je partner te spelen.<br /><br />Verstelbaar achter de hals.<br /><br />Afneembare kousenbanden onder de rok voor eenvoudig aanpassen en verwijderen.
highlights
string<ul> <li>Volledige ritssluiting aan de voorkant voor totale controle over het tempo van je dominantie spelletjes</li> <li>Flatterende skater snit die je figuur verbetert terwijl het essentiële bewegingsvrijheid biedt</li> <li>Sheer kanten inzetstukken aan de zijkanten creëren een fetisj visueel contrast met het glanzende kunstleer</li> <li>Afneembare en verstelbare kousenbanden verborgen onder de rok voor eenvoudige bevestiging van boeien accessoires</li> <li>Achter-de-hals aanpassing voor perfecte ondersteuning, zelfs tijdens intense sessies</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringOntdek het Adeline jurkje van The BDSM Boudoir, de specialist in sexy lingerie voor grote maten. Gratis snelle levering. Franse winkel.
keywords
string
title
stringAdeline jurk grote maat - The BDSM Boudoir
seotitle
stringAdeline grote maat jurk van imitatieleer
seouri
stringadeline-grote-maat-jurk-van-imitatieleer-zwart-ou-rood
specifications
string<ul> <li>Samenstelling: Hoogwaardig kunstleer en bestendig transparant kant</li> <li>Stijl: BDSM skaterjurk met volledige ritssluiting aan de voorkant</li> <li>Halslijn: Verstelbaar met verstevigde band achter in de nek</li> <li>Bijzondere kenmerken: Sheer kanten inzetstukken, stevige ritssluiting, afneembare kousenbanden</li> <li>Lengte: Midden bovenbeen met uitlopende rok voor bewegingsvrijheid</li> <li>Kleur: Intens zwart met fetish glanseffect</li> <li>Meegeleverde accessoires: afneembare en verstelbare kousenbanden die compatibel zijn met diverse accessoires</li> </ul>
stylingtips
string<p>Voor een sessie van dominantie combineer je deze jurk met vinyl dijhoge laarzen en bijpassende lange handschoenen voor een onweerstaanbare uitstraling van autoriteit. Maak het af met een zweep of zweepzweep uit onze collectie om je dominante positie te laten gelden. Voor een elegante onderdanige look kies je voor een halsketting met leiband en netkousen om je kousenbanden te showen. Metallic accessoires zoals lichtgevende kettingen of decoratieve clips zullen een extra visuele dimensie toevoegen die de sfeer van je rollenspel zal versterken. Onthoud dat houding net zo belangrijk is als kleding - draag deze jurk met het zelfvertrouwen dat hij je geeft, of je nu een dominante of onderdanige rol speelt.</p>
summary
stringMooie mix van stretch kunstleer en visnet, afneembare kousenbanden.
title
stringAdeline jurk van kunstleer
usageinstructions
string<p>Voor de beste pasvorm rits je de jurk helemaal dicht voordat je hem aantrekt en maak je het bandje achter de nek goed vast. De kousenbanden zijn ontworpen om een verscheidenheid aan accessoires te ondersteunen - maak ze vast aan je kousen of lichtgewicht bindbandjes, afhankelijk van je scenario.</p> <p>De ritssluiting aan de voorkant kan worden gebruikt als middelpunt van een machtsspel, waarbij de dominante speler het tempo van de onthulling bepaalt.</p> <p>Om de ervaring te intensiveren kun je hem combineren met andere BDSM-accessoires uit onze collectie, zoals handboeien of een bijpassende ketting.</p> <p>Zoals met alle BDSM-praktijken, moet je altijd een veilig woord spreken en zorgen voor wederzijdse toestemming voor elke sessie.</p>
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringVestido Adeline em pele sintética e rede.<br /><br />Corte skater, fecho frontal para brincar com os nervos do seu parceiro.<br /><br />Ajustável atrás do pescoço.<br /><br />Ligas amovíveis por baixo da saia para ajustar e retirar facilmente.
highlights
string<ul> <li>Fecho frontal completo para controlo total do ritmo dos seus jogos de dominação</li> <li>Corte de skater lisonjeiro que realça a sua figura enquanto permite a liberdade de movimentos essencial</li> <li>As inserções de renda transparente nos lados criam um contraste visual fetichista com a pele sintética brilhante</li> <li>Ligas amovíveis e ajustáveis escondidas sob a saia para facilitar a fixação de acessórios de restrição</li> <li>Ajuste atrás do pescoço para um apoio perfeito mesmo durante sessões intensas</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringDescubra o vestido Adeline da The Bdsm Boudoir, especialista em lingerie sexy plus size. Entrega rápida e gratuita. Loja francesa.
keywords
string
title
stringVestido Adeline plus size - The Bdsm Boudoir
seotitle
stringVestido Adeline tamanho grande em pele sintética
seouri
stringvestido-adeline-tamanho-grande-em-pele-sintetica-preto-ou-vermelho
specifications
string<ul> <li>Composição: Pele sintética de alta qualidade e renda transparente resistente</li> <li>Estilo: Vestido skater BDSM com fecho de correr à frente</li> <li>Decote: ajustável com laço reforçado na parte de trás do pescoço</li> <li>Caraterísticas distintivas: inserções de renda transparente, fecho de correr resistente, ligas amovíveis</li> <li>Comprimento: A meio da coxa com saia larga para liberdade de movimentos</li> <li>Cor: Preto intenso com efeito de brilho fetichista</li> <li>Acessórios incluídos: Ligas amovíveis e ajustáveis compatíveis com vários acessórios</li> </ul>
stylingtips
string<p>Para uma sessão de dominação, combine este vestido com botas de vinil até à coxa e luvas compridas a condizer para um irresistível ar de autoridade. Complete-o com um chicote ou um chicote da nossa coleção para afirmar a sua posição dominante. Para um visual elegantemente submisso, opte por um colar de trela e meias de rede para mostrar as ligas. Acessórios metálicos, como correntes leves ou clipes decorativos, darão uma dimensão visual extra que intensificará a atmosfera do seu jogo de papéis. Lembre-se de que a atitude é tão importante quanto a roupa - use este vestido com a confiança que ele inspira, quer esteja num papel dominante ou submisso.</p>
summary
stringBela mistura de pele sintética elástica e rede, ligas amovíveis.
title
stringVestido Adeline em pele sintética
usageinstructions
string<p>Para um melhor ajuste, feche o fecho completamente antes de vestir o vestido e, em seguida, aperte firmemente a correia atrás do pescoço. As ligas são concebidas para suportar uma variedade de acessórios - prenda-as às suas meias ou a laços de retenção leves, dependendo do seu cenário.</p> <p>O fecho frontal pode ser utilizado como peça central de um jogo de poder, em que o jogador dominante controla o ritmo da revelação.</p> <p>Para intensificar a experiência, combine com outros acessórios BDSM da nossa coleção, como algemas ou um colar a condizer.</p> <p>Como em todas as práticas de BDSM, estabeleça sempre uma palavra de segurança e garanta o consentimento mútuo antes de cada sessão.</p>
name
stringR82347-1
netweight
string
nextshipment
stringtomorrow
ordered
number15
orderidx
number0
origin
string
originalsize
string
packaging
string
productshipment
stringauto
productuid
stringC74B0521-2498-4C95-ADF7D85A1754DA3E
promountil
string
rating
stringnone
recorduid
stringC74B0521-2498-4C95-ADF7D85A1754DA3E
reference
stringSFBA4638
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: 1.39 ms
Record Count: 6
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_sizes.id_size as recorduid, if(intlsize <> '',intlsize,eusize) as size, if(intlsize <> '','intlsize','eusize') as sizetype,
product_variations.color,
if(product_sizes.sizegroup = 'bra',
if(intlsize <> '', cast(intlsize as SIGNED ), cast(eusize as SIGNED ))
,
SUBSTRING_INDEX(intlsize,'-',1)
) as param1,
if(product_sizes.sizegroup = 'bra',
if(intlsize <> '',
MID(intlsize,length(cast(intlsize as SIGNED ))+1,length(intlsize)),
MID(eusize,length(cast(eusize as SIGNED ))+1,length(eusize))
)
,
SUBSTRING_INDEX(intlsize,'-',-1)
) as param2,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as available,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
999999,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as groupavailable,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
product_sizes.gender, product_sizes.sizerange, product_sizes.sizegroup, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize,
product_sizes.bust, product_sizes.waist, product_sizes.hip, product_sizes.underbust, product_sizes.cup, product_sizes.thigh, product_sizes.legheight, product_sizes.bodyheight, product_sizes.bodyweight
from product_sizes
left outer join product_variations on product_sizes.suppliersize = product_variations.size and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
where FIND_IN_SET(product_sizes.id_size,'1093,1137,1136,1888') > 0
and product_variations.productuid = 'C74B0521-2498-4C95-ADF7D85A1754DA3E'
and intlsize <> 'na'
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_sizes.id_size, product_variations.color
order by FIELD(product_sizes.gender,'w','m'), product_sizes.sizegroup, FIELD(intlsize,'XS','S','S/M','S-M','M','M/L','M-L','L','L-XL','L/XL','XL','0X','0XL','lXL','1X','1X-2X','1X/2X','XL/2XL','XL-2XL','1XL-2XL','2XL','2X','XXL','2X-3X','2X/3X','2XL-3XL','2XL/3XL','XXXL','3XL','3X','3X-4X','3X/4X','3XL-4XL','3XL/4XL','4XL','5XL','5X','5X-6X','5X/6X','5XL-6XL','5XL/6XL','6XL','6X','7XL','7X','8XL','8X'), cast(intlsize as SIGNED ), groupavailable desc, stock desc
recorduidsizesizetypecolorparam1param2availablegroupavailablestockgendersizerangesizegroupsuppliersizeintlsizeincheseusizeussizeuksizefrsizeessizedesizeitsizeptsizeelsizebustwaisthipunderbustcupthighlegheightbodyheightbodyweight
1109338-40intlsizeblack3840-19999990wpluslingerieM-L38-4038-408-1012-1440-4240-4238-4044-4640-4238-4092-10074-8298-106
2109338-40intlsizered3840-19999990wpluslingerieM-L38-4038-408-1012-1440-4240-4238-4044-4640-4238-4092-10074-8298-106
3113744-46intlsizeblack4446-19999991wpluslingerieXL-2XL44-4644-4614-1618-2246-4846-4844-4650-5246-4844-46102-10886-92108-114
4113744-46intlsizered4446-19999990wpluslingerieXL-2XL44-4644-4614-1618-2246-4846-4844-4650-5246-4844-46102-10886-92108-114
5113648-50intlsizered4850-19999990wpluslingerie3XL-4XL48-5048-5018-2022-2450-5250-5248-5054-5650-5248-50110-11696-102116-122
6113648-50intlsizeblack4850-19999990wpluslingerie3XL-4XL48-5048-5018-2022-2450-5250-5248-5054-5650-5248-50110-11696-102116-122
sizeranges
stringplus,standard
sizes
string1093,1137,1136,1888
sizetype
stringauto
specifications
Struct
Entries: 23
belly
string
bones
string
bra
string
breasts
string
bust
string
closing
string
crochtless
string
cups
string
cut
string
garter
string
halter
string
lacing
string
lining
string
modestypanel
string
panty
string
sheathing
string
sleeves
string
stocking
string
straps
string
stretch
string
suspenders
string
transparency
string
underwires
string
stock
number0
stocks
Query
Template: /system/api/product/stocks.cfc:25
Execution Time: 5.05 ms
Record Count: 6
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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E'
and product_variations.isactive = 1
and product_sizes.id_size = 1093
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = 'C74B0521-2498-4C95-ADF7D85A1754DA3E'
and product_variations.isactive = 1
and product_sizes.id_size = 1137
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = 'C74B0521-2498-4C95-ADF7D85A1754DA3E'
and product_variations.isactive = 1
and product_sizes.id_size = 1136
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = 'C74B0521-2498-4C95-ADF7D85A1754DA3E'
and product_variations.isactive = 1
and product_sizes.id_size = 1888
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
) tbl
group by productuid, variationuid, stockuid
order by stockuid, FIELD(gender,'w','m'), sizegroup, FIELD(intlsize,'XS','S','S/M','S-M','M','M/L','M-L','L','L-XL','L/XL','XL','0X','0XL','lXL','1X','1X-2X','1X/2X','XL/2XL','XL-2XL','1XL-2XL','2XL','2X','XXL','2X-3X','2X/3X','2XL-3XL','2XL/3XL','XXXL','3XL','3X','3X-4X','3X/4X','3XL-4XL','3XL/4XL','4XL','5XL','5X','5X-6X','5X/6X','5XL-6XL','5XL/6XL','6XL','6X','7XL','7X','8XL','8X'), cast(intlsize as SIGNED ), color
productuidvariationuidrecorduidcolorhexvaluesuppliersizeintlsizeincheseusizeussizeuksizefrsizeessizedesizeitsizeptsizeelsizegendersizegroupcupsizesizetypeitempriceitempromopromoUntilstockuidwarehouseontourpackagingsupplierreservedorderedreturneddefectmanufacturerreferenceeanavailablestockdisplaycomments
1C74B0521-2498-4C95-ADF7D85A1754DA3E126517FD-3C64-4F99-8E319287F9D15F921093black#000000M-L38-4038-408-1012-1440-4240-4238-4044-4640-4238-40wlingerie38-40intlsize33.29170STOCK01000-10100R82347-10115-10all
2C74B0521-2498-4C95-ADF7D85A1754DA3E14633B55-8DD1-4042-BF9DA122A97B94061093red#F50000M-L38-4038-408-1012-1440-4240-4238-4044-4640-4238-40wlingerie38-40intlsize33.29170STOCK01000-10000-10all
3C74B0521-2498-4C95-ADF7D85A1754DA3EE077181A-5311-4107-8671F125AF6312061137black#000000XL-2XL44-4644-4614-1618-2246-4846-4844-4650-5246-4844-46wlingerie44-46intlsize33.29170STOCK01100-10600R82347-1R82347-1011611all
4C74B0521-2498-4C95-ADF7D85A1754DA3E0160240C-8791-42CF-872D21A0170784481137red#F50000XL-2XL44-4644-4614-1618-2246-4846-4844-4650-5246-4844-46wlingerie44-46intlsize33.29170STOCK01000-10000-10all
5C74B0521-2498-4C95-ADF7D85A1754DA3EED8CBE4C-E87C-4610-A77E0D55A94A7BE91136black#0000003XL-4XL48-5048-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie48-50intlsize33.29170STOCK01000-10800R82347-1R82347-10117-10all
6C74B0521-2498-4C95-ADF7D85A1754DA3E8F749448-DC7C-44C6-929E27B3C2D780091136red#F500003XL-4XL48-5048-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie48-50intlsize33.29170STOCK01000-11100-10all
subcategory
stringall
supplier
number-1
supplierreference
stringR82347-1
tags
string
themes
stringdark
totalvariations
string
type
stringdefault
unitprice
number33.2917
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 9.14 ms
Record Count: 6
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' 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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' 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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' 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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' 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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' 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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' 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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E'
and product_variations.isactive = 1
and product_sizes.id_size = 1093
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' 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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' 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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' 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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' 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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' 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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' 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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E'
and product_variations.isactive = 1
and product_sizes.id_size = 1137
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' 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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' 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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' 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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' 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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' 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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' 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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E'
and product_variations.isactive = 1
and product_sizes.id_size = 1136
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' 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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' 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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' 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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' 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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' 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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' 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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E'
and product_variations.isactive = 1
and product_sizes.id_size = 1888
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
order by FIELD(gender,'w','m'), sizegroup, FIELD(intlsize,'XS','S','S/M','S-M','M','M/L','M-L','L','L-XL','L/XL','XL','0X','0XL','lXL','1X','1X-2X','1X/2X','XL/2XL','XL-2XL','1XL-2XL','2XL','2X','XXL','2X-3X','2X/3X','2XL-3XL','2XL/3XL','XXXL','3XL','3X','3X-4X','3X/4X','3XL-4XL','3XL/4XL','4XL','5XL','5X','5X-6X','5X/6X','5XL-6XL','5XL/6XL','6XL','6X','7XL','7X','8XL','8X'), cast(intlsize as SIGNED ), color
variationuidrecorduidcolorhexvaluesuppliersizeintlsizeincheseusizeussizeuksizefrsizeessizedesizeitsizeptsizeelsizegendersizegroupcupsizesizetypeitempriceitempromopromoUntilstockuidwarehouseontourpackagingsupplierreservedorderedreturneddefectmanufacturerreferenceeanavailablestockavailablepersizestockpersizeavailablepercolorstockpercolorhaspromounitpricedisplaycomments
1126517FD-3C64-4F99-8E319287F9D15F921093black#000000M-L38-4038-408-1012-1440-4240-4238-4044-4640-4238-40wlingerie38-40intlsize33.29170STOCK01000-10100R82347-10115-10-10-11033.2917all
214633B55-8DD1-4042-BF9DA122A97B94061093red#F50000M-L38-4038-408-1012-1440-4240-4238-4044-4640-4238-40wlingerie38-40intlsize33.29170STOCK01000-10000-10-10-10033.2917all
3E077181A-5311-4107-8671F125AF6312061137black#000000XL-2XL44-4644-4614-1618-2246-4846-4844-4650-5246-4844-46wlingerie44-46intlsize33.29170STOCK01100-10600R82347-1R82347-1011611-11-11033.2917all
40160240C-8791-42CF-872D21A0170784481137red#F50000XL-2XL44-4644-4614-1618-2246-4846-4844-4650-5246-4844-46wlingerie44-46intlsize33.29170STOCK01000-10000-10-11-10033.2917all
5ED8CBE4C-E87C-4610-A77E0D55A94A7BE91136black#0000003XL-4XL48-5048-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie48-50intlsize33.29170STOCK01000-10800R82347-1R82347-10117-10-10-11033.2917all
68F749448-DC7C-44C6-929E27B3C2D780091136red#F500003XL-4XL48-5048-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie48-50intlsize33.29170STOCK01000-11100-10-10-10033.2917all
vatrate
number20
warehouse
string