Maten bekijken
Bridgerton Babydoll: Romantische elegantie voor elk figuur
Dubbelklikken om te vergroten
SKU: SFBA5769
Bridgerton Babydoll: Elegancia romántica para todas las figuras
Nieuw
IMPORT
Voorraad:

Dompel jezelf onder in de romantische wereld van Bridgerton met deze uitzonderlijke chemise die elegantie en sensualiteit combineert.

De nauwsluitende snit met kleine plooitjes geeft je silhouet delicaat vorm, houdt je buik discreet en accentueert je billen.

Het weelderig geborduurde lijfje en de beugelcups bieden perfecte ondersteuning tot een G-cup.

Sterke punten

  • Aansluitend model met sculpturale plooien om het silhouet te verfijnen
  • Weelderig geborduurd lijfje met verfijnde details
  • Beugelcups voor uitzonderlijke ondersteuning (D tot G)
  • Brede, verstelbare bandjes voor optimaal comfort
  • Technische aanpassingen voor verschillende maten: diepere cups en aangepaste lengte
  • Bridgerton inspiratie voor verfijnde romantiek
  • Plat buikeffect dankzij strategisch geplaatste plooien
  • De bestudeerde snit accentueert de billen
Maat:

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

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

Bridgerton Babydoll Grote Maat - Romantiek en Verfijning

Productomschrijving

Ontdek de Bridgerton chemise, een uitzonderlijke creatie die deromantische essentie van het Regency-tijdperk weergeeft en tegelijkertijd onvergelijkbaar modern comfort biedt. Dit geraffineerde stuk zal elk figuur verbeteren dankzij de zorgvuldig bestudeerde nauwsluitende snit.

Het weelderig geborduurde lijfje onthult uitzonderlijk vakmanschap, terwijl strategisch geplaatste plooien een opmerkelijk sculpturerend effect creëren. Deze technische details houden je buik discreet terwijl ze je billen prachtig accentueren voor een harmonieus, vrouwelijk silhouet.

De beugelcups bieden uitzonderlijke ondersteuning en zijn perfect geschikt voor royale borsten, van D- tot G-cups. Deze chemise onthult de technische expertise van Diva's Boudoir: afhankelijk van je maat zijn de bandjes breder, de cups dieper en de lengte iets aangepast om een perfecte pasvorm te garanderen, aangepast aan jouw morfologie.

Je voelt de inspiratie van Bridgerton in elk detail: delicaat borduurwerk, verfijnde afwerkingen en een romantische geest die je meevoeren naar de verfijnde wereld van de Londense high society. Deze chemise maakt van elk intiem moment een uitzonderlijke ervaring.

Technische details

  • Beschikbare maten: 42 tot 64
  • Cups: D tot G met geïntegreerde beugel
  • Bandjes: Breed en verstelbaar volgens maat
  • Snit: Nauwsluitend met modellerende plooien
  • Stijl: Romantische Bridgerton inspiratie
  • Technische aanpassingen: Diepere cups en verstelbare lengte volgens maat
  • Sluiting: Optimale pasvorm
  • Onderhoud: Fijne was aanbevolen

Beschikbaar maten

Beschikbaar van XL/2XL+ tot 3XL/4XL

Beschikbaar kleur

Zwart en roze

Maattabel

Controleer de juiste maat voor jou

Internationale
  • Borst
  • Maat
  • Heupen
XL/2XL+
  • 118-122
  • 95-102
  • 122-127
3XL/4XL+
  • 127-132
  • 109-114
  • 135-140
XL
  • 102-112
  • 81-91
  • 107-117
XL/2XL
  • 112-117
  • 91-95
  • 117-122
3XL/4XL
  • 122-127
  • 102-109
  • 127-135

Onderhoudstips

  • Handwas in lauw water (maximaal 30°C)
  • Gebruik een fijnwasmiddel zonder bleekmiddelen
  • Niet centrifugeren, voorzichtig in een handdoek drukken
  • Plat drogen in de schaduw, uit de buurt van warmtebronnen
  • Niet rechtstreeks op het borduurwerk strijken
  • Ophangen om de vorm van de cups te behouden
  • Bescherm beugels tijdens het wassen en opbergen

Gebruikstips

Voor de perfecte pasvorm van je Bridgerton babydoll pas je eerst de bandjes aan je lichaamsvorm aan - ze zijn speciaal breder ontworpen in grote maten voor optimaal comfort. Plaats de beugelcups zo dat ze perfect bij je buste passen, van D- tot G-cup.

de kleine plooitjes moeten goed verdeeld zijn om het gewenste sculpturerende effect te creëren dat je buikje discreet houdt. Deze chemise is ideaal voor romantische intimiteit of als geraffineerde nachtkleding waarmee je je een echte Bridgerton-heldin voelt.

Stijltips

De Bridgerton babydoll combineert perfect met een satijnen badjas om een compleet nachtelijk ensemble te creëren dat de mooiste romantische heldinnen waardig is. Voor een speciale avond combineer je het met delicate hold-ups en pumps voor een authentieke Bridgerton-look. Het geraffineerde borduursel op het lijfje maakt het ook perfect om te dragen onder een off-the-shoulder jurk voor een vleugje verfijnde sensualiteit. Aarzel niet om deze uitzonderlijke creatie te verfraaien met delicate juwelen om de Regency-sfeer compleet te maken.

To Top
Artikelen
Totaal aantal items
Struct
Entries: 108
actions
Array
available
number0
brand
stringcoquette
brandcode
stringcdug
branding
stringdivasboudoir
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
stringCoquette
breasts
stringna
careinstructions
string
categories
stringdivasboudoir.cabaret.dresses.all,divasboudoir.lingerie.sexylingerie.babydoll
category
stringdresses
categorygender
stringf
categorymediadatas
Struct
adult
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string615
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/cabaret/dresses1.jpg
type
stringimg
width
string1336
divasboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
fetishboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
latexboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
legsboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
lustboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
private
Struct
height
string1016
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/private/default.jpg
type
stringimg
width
string703
smboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
categorysizerange
stringauto
colorinfos
Query
Template: /system/api/product/colors.cfc:13
Execution Time: 1.09 ms
Record Count: 1
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_colors.color as recorduid, product_colors.type, product_colors.code, product_colors.color, product_colors.range, product_colors.hexvalue,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock
from product_colors
left outer join product_variations on product_colors.color = product_variations.color and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
where FIND_IN_SET(product_colors.color,'blackpink') > 0
and product_variations.productuid = 'B71C293E-D21B-4C3E-B61FB74690D289B6'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1blackpinkcolorbpinblackpinkpinklinear-gradient(90deg, #000000 50%, #FE70BD 50%)66
colorrange
stringpink
colors
stringblackpink
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-03-26 14:01:42'}
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
booleanfalse
hasotherspecifications
booleanfalse
haspromo
number0
hasshortdescription
booleantrue
hassizeinfos
booleantrue
hasspecifications
booleantrue
hasstockinfos
booleanfalse
hasstylingtips
booleantrue
hasusageinstructions
booleantrue
hasvariations
booleantrue
import
stringus
inpromo
number0
instockvariations
string
isactive
number1
iscustommade
number0
isdivasize
number1
isfirstprice
number0
isfixedprice
number0
ishot
number0
isnew
number1
isonline
number0
isoutletprice
number0
itemprice
number74.9583
itempromo
string
key
string21125x
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-11-07 12:08:25'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 1.03 ms
Record Count: 0
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select cart_actions.*
from cart_actions
where cart_actions.branding IN ('all','divasboudoir')
and cart_actions.language IN ('all','es')
and (cart_actions.quotas = -1 or (cart_actions.usedCount < cart_actions.quotas))
and cart_actions.isactive = 1
and (date(cart_actions.activeFrom) <= '2025-11-24' OR cart_actions.activeFrom is null)
and (date(cart_actions.activeTo) >= '2025-11-24' OR cart_actions.activeTo is null)
and (
FIND_IN_SET('b71c293e-d21b-4c3e-b61fb74690d289b6',lcase(cart_actions.linkedproducts)) > 0 and cart_actions.linkedproducts is not null
)
id_actionbrandinglanguagenamecodetypeminimumOrdermaximumOrderminimumItemsmaximumItemsmaximumUseallowedItemsquotasusedCountlinkedproductslinkedthemeslinkedbrandslinkeditemparamsactiveFromactiveToisActive
linkedproducts
Query
Template: /system/api/products.cfc:1305
Execution Time: 2.23 ms
Record Count: 0
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select products.productuid as productuid, products.reference, 'default' as type, products.key, products.language, products.name,
product_links.linkuid,
products.colors, products.vatrate, products.metadatas, products.dimensions,
products.mediadatas, products.tags, products.themes, products.isdivasize,
count(distinct product_variations.variationuid) as totalvariations,
group_concat(distinct product_variations.variationuid) as variationlist,
count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END) as inpromo,
if(count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END)>0,1,0) as haspromo,
(select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0) END)) as itempromo,
IFNULL(min(product_variations.itemprice),0) as itemprice,
(select IF (products.isfixedprice = 0 and sum(product_variations.itempromo) > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null), IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0), IFNULL(min(NULLIF(product_variations.itemprice, 0)), 0) )) as unitprice,
count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.itempromo ELSE product_variations.itemprice END) as prices,
(select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN min(NULLIF(product_variations.promountil, 0)) END)) as promountil,
products.isfixedprice, products.ishot, products.isnew, if(products.orderidx > 0, products.orderidx, 999999999) as orderidx,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
count(distinct CASE WHEN ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) > 0 OR ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) <= 0 AND product_variations.supplier = 0)) THEN product_variations.variationuid END) as instockvariations,
products.brand, brands.name as brandname, IFNULL(brands.ispublic, 0) as showbrand, brands.display,
product_categories.sizetype,GROUP_CONCAT(DISTINCT product_sizes.suppliersize) as intlsize,products.sizes,product_sizes.sizerange,product_categories.mediadatas as categorymediadatas, product_categories.sizerange as categorysizerange,
product_categorymap.section, product_categorymap.category, product_categorymap.key as subcategory
from products
left outer join product_categorymap on products.productuid = product_categorymap.productuid
left outer join product_categories on (product_categories.branding = product_categorymap.branding and product_categories.section = product_categorymap.section and product_categories.category = product_categorymap.category and product_categories.key = product_categorymap.key)
left outer join product_sizes on product_sizes.id_size IN (products.sizes)
left outer join brands on products.brand = brands.brand
left outer join product_variations on product_variations.productuid = products.productuid and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
left outer join product_links on product_links.reference = products.reference
where products.isactive = 1 and products.isdeleted = 0
and brands.isactive = 1 and brands.isdeleted = 0
and product_categories.isactive = 1 and product_categories.isdeleted = 0
and product_variations.isactive = 1
and FIND_IN_SET('divasboudoir',products.branding)
and product_categories.branding IN ('all','divasboudoir')
and product_categorymap.branding IN ('all','divasboudoir')
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and products.language in ('all','es')
and product_categories.language in ('all','es')
and (products.displayFrom <= DATE(NOW()) or products.displayFrom is null)
and (products.displayTo >= DATE(NOW()) or products.displayTo IS null)
and product_links.linkuid = '' and product_links.linkuid is not null and product_links.linkuid <> ''
and products.reference <> 'SFBA5769'
group by products.reference
order by products.ishot desc, products.isnew desc, orderidx asc, products.lastupdated desc
productuidreferencetypekeylanguagenamelinkuidcolorsvatratemetadatasdimensionsmediadatastagsthemesisdivasizetotalvariationsvariationlistinpromohaspromoitempromoitempriceunitpricepricespromountilisfixedpriceishotisneworderidxavailablestockinstockvariationsbrandbrandnameshowbranddisplaysizetypeintlsizesizessizerangecategorymediadatascategorysizerangesectioncategorysubcategory
linkuid
string
materials
string
mediadatas
Struct
alt
Struct
height
string1917
isprivate
string0
rating
stringall
src
string/photobank/products/cdug/sfba5769/22807480-3-1.jpg
type
stringimg
width
string1326
back
Struct
height
string1964
isprivate
string0
rating
stringall
src
string/photobank/products/cdug/sfba5769/22807474-4-1.jpg
type
stringimg
width
string1359
default
Struct
height
string1871
isprivate
string0
rating
stringall
src
string/photobank/products/cdug/sfba5769/22807493-1-1.jpg
type
stringimg
width
string1294
variations
Struct
colors
Struct
blackpink
Struct
height
string1871
isprivate
string0
rating
stringall
src
string/photobank/products/cdug/sfba5769/22807493-1-1.jpg
type
stringimg
width
string1294
video
Struct
embedsrc
stringhttps://www.youtube.com/watch?v=MrmZAL6jHjE
height
string
id
stringMrmZAL6jHjE
isprivate
string0
rating
stringall
src
stringhttps://youtube.com/shorts/MrmZAL6jHjE?feature=share
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
stringhttps://img.youtube.com/vi/MrmZAL6jHjE/0.jpg
type
stringimg
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
stringyoutube
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-coquette-schwarz-und-rosa
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-coquette-mayro-kai-roz
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-coquette-black-and-pink
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-coquette-negro-y-rosa
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-coquette-noir-et-rose
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-coquette-nero-e-rosa
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-coquette-zwart-en-roze
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-coquette-preto-e-cor-de-rosa
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
divasboudoir
Struct
de
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Handw&auml;sche in lauwarmem Wasser (maximal 30&deg;C)</li> <li>Feinwaschmittel ohne Bleichmittel verwenden</li> <li>Nicht schleudern, sanft in einem Handtuch ausdr&uuml;cken</li> <li>Liegend im Schatten trocknen, nicht in der N&auml;he von W&auml;rmequellen</li> <li>Nicht direkt &uuml;ber Stickereien b&uuml;geln</li> <li>H&auml;ngend aufbewahren, um die Form der K&ouml;rbchen zu erhalten</li> <li>B&uuml;gel beim Waschen und Verstauen sch&uuml;tzen</li> </ul>
description
string<p>Entdecken Sie das Bridgerton Babydoll, eine au&szlig;ergew&ouml;hnliche Kreation, die das<strong>romantische Wesen der Regency-Epoche</strong> einf&auml;ngt und gleichzeitig einen unvergleichlichen modernen Komfort bietet. Dieses raffinierte Kleidungsst&uuml;ck wird dank seines akribisch durchdachten, k&ouml;rpernahen Schnitts jede Silhouette betonen.<br><br>Das pr&auml;chtig bestickte Mieder offenbart eine au&szlig;ergew&ouml;hnliche handwerkliche Fertigkeit, w&auml;hrend die strategisch platzierten kleinen Raffungen einen bemerkenswerten formenden Effekt erzeugen. Diese technischen Details lassen Ihren Bauch unauff&auml;llig erscheinen, w&auml;hrend Ihr Ges&auml;&szlig; wundersch&ouml;n betont wird, um eine harmonische und feminine Silhouette zu schaffen.</p> <p>Die B&uuml;gel-Cups bieten einen au&szlig;ergew&ouml;hnlichen Halt und passen sich perfekt an gro&szlig;e Br&uuml;ste von Cup D bis G an. In diesem Babydoll zeigt sich die<strong> technische Expertise von Diva's Boudoir</strong>: Je nach Ihrer Gr&ouml;&szlig;e sind die Tr&auml;ger breiter, die Cups tiefer und die L&auml;nge leicht angepasst, um eine perfekte, auf Ihre K&ouml;rperform abgestimmte Passform zu gew&auml;hrleisten.<br><br>Die Inspiration von Bridgerton ist in jedem Detail sp&uuml;rbar: <strong>zarte Stickereien, raffinierte Verarbeitung und romantischer Geist,</strong> die Sie in die anspruchsvolle Welt der Londoner High Society entf&uuml;hren. Dieses Babydoll macht jeden intimen Moment zu einem au&szlig;ergew&ouml;hnlichen Erlebnis.</p>
guid
stringhttps://dev.divasboudoir.com/de/negligé-große-größe-bridgerton-romantisch-sophistisch/sfba5769.htm
highlights
string<ul> <li>K&ouml;rpernaher Schnitt mit figurformenden Raffungen, die die Silhouette schlanker wirken lassen</li> <li>Pr&auml;chtig bestickte Corsage mit raffinierten Details</li> <li>B&uuml;gel-Cups f&uuml;r einen au&szlig;ergew&ouml;hnlich guten Halt (D bis L)</li> <li>Breite, verstellbare Tr&auml;ger f&uuml;r optimalen Tragekomfort</li> <li>Technische Anpassungen je nach Gr&ouml;&szlig;e: tiefere Cups und angepasste L&auml;nge</li> <li>Bridgerton-Inspiration f&uuml;r raffinierte Romantik</li> <li>Flacher Bauch-Effekt durch strategisch platzierte Raffungen</li> <li>Hervorhebung des Ges&auml;&szlig;es durch den durchdachten Schnitt</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringBridgerton Babydoll in großen Größen von Diva's Boudoir: besticktes Mieder, Cups mit D-G-Bügeln und formenden Raffungen. Romantisch und raffiniert Größen 42-64. Kostenlose Lieferung ab 59€.
keywords
string
title
stringBridgerton Negligé in Übergröße - Romantisch und anspruchsvoll | Diva's Boudoir
seotitle
stringBridgerton Negligé in Übergröße - Romantik und Sophistication
seouri
stringnegligé-große-größe-bridgerton-romantisch-sophistisch
specifications
string<ul> <li>Erh&auml;ltliche Gr&ouml;&szlig;en: 42 bis 64</li> <li>Cups: D bis G mit integrierten B&uuml;geln</li> <li>Tr&auml;ger: Breit und je nach Gr&ouml;&szlig;e verstellbar</li> <li>Schnitt: K&ouml;rpernah mit formenden Raffungen</li> <li>Stil: Romantische Bridgerton-Inspiration</li> <li>Technische Anpassungen: Tiefere Cups und angepasste L&auml;nge je nach Gr&ouml;&szlig;e</li> <li>Verschluss: Optimales Anpassungssystem</li> <li>Pflege: Feinw&auml;sche empfohlen</li> </ul>
stylingtips
string<p>Das Bridgerton Babydoll l&auml;sst sich perfekt mit einem Satinbademantel kombinieren, um ein komplettes Nachthemd-Set zu kreieren, das den sch&ouml;nsten romantischen Heldinnen w&uuml;rdig ist. F&uuml;r einen besonderen Abend kombinieren Sie es mit zarten, selbstbindenden Str&uuml;mpfen und Pumps f&uuml;r einen authentischen Bridgerton-Look. Die raffinierten Stickereien auf der Korsage machen es auch zu einem perfekten St&uuml;ck, das unter einem tief ausgeschnittenen Kleid getragen werden kann, um einen Hauch von raffinierter Sinnlichkeit zu verleihen. Z&ouml;gern Sie nicht, mit zartem Schmuck zu accessorisieren, um den Regency-Spirit dieser au&szlig;ergew&ouml;hnlichen Kreation zu vervollst&auml;ndigen.</p>
summary
string<p>Tauchen Sie mit diesem au&szlig;ergew&ouml;hnlichen Babydoll, das Eleganz und Sinnlichkeit vereint, in die romantische Welt von Bridgerton ein.</p> <p>Der k&ouml;rpernahe Schnitt mit kleinen Raffungen formt sanft Ihre Silhouette, indem er Ihren Bauch dezent erscheinen l&auml;sst und gleichzeitig Ihren Po betont.</p> <p>Die &uuml;ppig bestickte Korsage und die B&uuml;gel-Cups bieten perfekten Halt bis zum G-Cup.</p>
title
stringBridgerton Babydoll: Romantische Eleganz, die jede Figur umwerfend aussehen lässt
usageinstructions
string<p>Um Ihr Bridgerton Nachthemd perfekt anzupassen, stellen Sie zun&auml;chst die Tr&auml;ger auf Ihre K&ouml;rperform ein - sie sind in gro&szlig;en Gr&ouml;&szlig;en speziell breiter gestaltet, um einen optimalen Tragekomfort zu gew&auml;hrleisten. Positionieren Sie die B&uuml;gel-Cups so, dass sie sich von Cup D bis G perfekt an Ihre Brust anschmiegen.</p> <p>die kleinen Raffungen sollten gleichm&auml;&szlig;ig verteilt sein, um den gew&uuml;nschten formenden Effekt zu erzielen, der Ihren Bauch unauff&auml;llig erscheinen l&auml;sst. Dieses Babydoll ist ideal f&uuml;r romantische intime Momente oder als anspruchsvolles Nachtst&uuml;ck, in dem Sie sich wie eine echte Bridgerton-Heldin f&uuml;hlen werden.</p>
el
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>&Pi;&lambda;έ&nu;&epsilon;&tau;&epsilon; &sigma;&tau;&omicron; &chi;έ&rho;&iota; &mu;&epsilon; &chi;&lambda;&iota;&alpha;&rho;ό &nu;&epsilon;&rho;ό (30&deg;C &tau;&omicron; &pi;&omicron;&lambda;ύ)</li> <li>&Chi;&rho;&eta;&sigma;&iota;&mu;&omicron;&pi;&omicron;&iota;ή&sigma;&tau;&epsilon; &epsilon;&upsilon;&alpha;ί&sigma;&theta;&eta;&tau;&omicron; &alpha;&pi;&omicron;&rho;&rho;&upsilon;&pi;&alpha;&nu;&tau;&iota;&kappa;ό &chi;&omega;&rho;ί&sigmaf; &lambda;&epsilon;&upsilon;&kappa;&alpha;&nu;&tau;&iota;&kappa;&omicron;ύ&sigmaf; &pi;&alpha;&rho;ά&gamma;&omicron;&nu;&tau;&epsilon;&sigmaf;</li> <li>&Mu;&eta; &sigma;&kappa;&omicron;&upsilon;&pi;ί&zeta;&epsilon;&tau;&epsilon; &mu;&epsilon; &sigma;&tau;ύ&psi;&iota;&mu;&omicron;, &pi;&iota;έ&sigma;&tau;&epsilon; &alpha;&pi;&alpha;&lambda;ά &sigma;&epsilon; &mu;&iota;&alpha; &pi;&epsilon;&tau;&sigma;έ&tau;&alpha;</li> <li>&Sigma;&tau;&epsilon;&gamma;&nu;ώ&nu;&epsilon;&tau;&epsilon; &epsilon;&pi;ί&pi;&epsilon;&delta;&alpha; &sigma;&tau;&eta; &sigma;&kappa;&iota;ά, &mu;&alpha;&kappa;&rho;&iota;ά &alpha;&pi;ό &pi;&eta;&gamma;έ&sigmaf; &theta;&epsilon;&rho;&mu;ό&tau;&eta;&tau;&alpha;&sigmaf;</li> <li>&Mu;&eta;&nu; &sigma;&iota;&delta;&epsilon;&rho;ώ&nu;&epsilon;&tau;&epsilon; &alpha;&pi;&epsilon;&upsilon;&theta;&epsilon;ί&alpha;&sigmaf; &pi;ά&nu;&omega; &sigma;&tau;&omicron; &kappa;έ&nu;&tau;&eta;&mu;&alpha;</li> <li>&Kappa;&rho;&epsilon;&mu;ά&sigma;&tau;&epsilon; &gamma;&iota;&alpha; &nu;&alpha; &delta;&iota;&alpha;&tau;&eta;&rho;&eta;&theta;&epsilon;ί &tau;&omicron; &sigma;&chi;ή&mu;&alpha; &tau;&omega;&nu; &phi;&lambda;&iota;&tau;&zeta;&alpha;&nu;&iota;ώ&nu;</li> <li>&Pi;&rho;&omicron;&sigma;&tau;&alpha;&tau;&epsilon;ύ&epsilon;&tau;&epsilon; &tau;&alpha; &upsilon;&pi;&omicron;&sigma;&tau;&upsilon;&lambda;ώ&mu;&alpha;&tau;&alpha; &kappa;&alpha;&tau;ά &tau;&omicron; &pi;&lambda;ύ&sigma;&iota;&mu;&omicron; &kappa;&alpha;&iota; &tau;&eta;&nu; &alpha;&pi;&omicron;&theta;ή&kappa;&epsilon;&upsilon;&sigma;&eta;</li> </ul>
description
string<p>&Alpha;&nu;&alpha;&kappa;&alpha;&lambda;ύ&psi;&tau;&epsilon; &tau;&omicron; &sigma;&epsilon;&mu;&iota;&nu;ά&rho;&iota;&omicron; Bridgerton, &mu;&iota;&alpha; &epsilon;&xi;&alpha;&iota;&rho;&epsilon;&tau;&iota;&kappa;ή &delta;&eta;&mu;&iota;&omicron;&upsilon;&rho;&gamma;ί&alpha; &pi;&omicron;&upsilon; &alpha;&pi;&omicron;&tau;&upsilon;&pi;ώ&nu;&epsilon;&iota; &tau;&eta;<strong>&rho;&omicron;&mu;&alpha;&nu;&tau;&iota;&kappa;ή &omicron;&upsilon;&sigma;ί&alpha; &tau;&eta;&sigmaf; &epsilon;&pi;&omicron;&chi;ή&sigmaf; Regency</strong>, &pi;&rho;&omicron;&sigma;&phi;έ&rho;&omicron;&nu;&tau;&alpha;&sigmaf; &pi;&alpha;&rho;ά&lambda;&lambda;&eta;&lambda;&alpha; &alpha;&sigma;ύ&gamma;&kappa;&rho;&iota;&tau;&eta; &sigma;ύ&gamma;&chi;&rho;&omicron;&nu;&eta; ά&nu;&epsilon;&sigma;&eta;. &Alpha;&upsilon;&tau;ό &tau;&omicron; &epsilon;&kappa;&lambda;&epsilon;&pi;&tau;&upsilon;&sigma;&mu;έ&nu;&omicron; &kappa;&omicron;&mu;&mu;ά&tau;&iota; &theta;&alpha; &alpha;&nu;&alpha;&delta;&epsilon;ί&xi;&epsilon;&iota; &kappa;ά&theta;&epsilon; &sigma;&iota;&lambda;&omicron;&upsilon;έ&tau;&alpha; &chi;ά&rho;&eta; &sigma;&tau;&omicron; &sigma;&chi;&omicron;&lambda;&alpha;&sigma;&tau;&iota;&kappa;ά &mu;&epsilon;&lambda;&epsilon;&tau;&eta;&mu;έ&nu;&omicron; &kappa;ό&psi;&iota;&mu;ό &tau;&omicron;&upsilon; &sigma;&epsilon; &sigma;&tau;&epsilon;&nu;ή &epsilon;&phi;&alpha;&rho;&mu;&omicron;&gamma;ή.<br><br>&Tau;&omicron; &pi;&lambda;&omicron;ύ&sigma;&iota;&alpha; &kappa;&epsilon;&nu;&tau;&eta;&mu;έ&nu;&omicron; &mu;&pi;&omicron;ύ&sigma;&tau;&omicron; &alpha;&pi;&omicron;&kappa;&alpha;&lambda;ύ&pi;&tau;&epsilon;&iota; &epsilon;&xi;&alpha;&iota;&rho;&epsilon;&tau;&iota;&kappa;ή &delta;&epsilon;&xi;&iota;&omicron;&tau;&epsilon;&chi;&nu;ί&alpha;, &epsilon;&nu;ώ &tau;&alpha; &sigma;&tau;&rho;&alpha;&tau;&eta;&gamma;&iota;&kappa;ά &tau;&omicron;&pi;&omicron;&theta;&epsilon;&tau;&eta;&mu;έ&nu;&alpha; &phi;&omicron;&upsilon;&rho;&kappa;έ&tau;&alpha; &delta;&eta;&mu;&iota;&omicron;&upsilon;&rho;&gamma;&omicron;ύ&nu; έ&nu;&alpha; &alpha;&xi;&iota;&omicron;&sigma;&eta;&mu;&epsilon;ί&omega;&tau;&omicron; &alpha;&pi;&omicron;&tau;έ&lambda;&epsilon;&sigma;&mu;&alpha; &gamma;&lambda;&upsilon;&pi;&tau;&iota;&kappa;ή&sigmaf;. &Alpha;&upsilon;&tau;έ&sigmaf; &omicron;&iota; &tau;&epsilon;&chi;&nu;&iota;&kappa;έ&sigmaf; &lambda;&epsilon;&pi;&tau;&omicron;&mu;έ&rho;&epsilon;&iota;&epsilon;&sigmaf; &kappa;&rho;&alpha;&tau;&omicron;ύ&nu; &tau;&eta;&nu; &kappa;&omicron;&iota;&lambda;&iota;ά &sigma;&alpha;&sigmaf; &delta;&iota;&alpha;&kappa;&rho;&iota;&tau;&iota;&kappa;ή, &epsilon;&nu;ώ &pi;&alpha;&rho;ά&lambda;&lambda;&eta;&lambda;&alpha; &alpha;&nu;&alpha;&delta;&epsilon;&iota;&kappa;&nu;ύ&omicron;&upsilon;&nu; &upsilon;&pi;έ&rho;&omicron;&chi;&alpha; &tau;&omicron;&upsilon;&sigmaf; &gamma;&lambda;&omicron;&upsilon;&tau;&omicron;ύ&sigmaf; &sigma;&alpha;&sigmaf; &gamma;&iota;&alpha; &mu;&iota;&alpha; &alpha;&rho;&mu;&omicron;&nu;&iota;&kappa;ή, &theta;&eta;&lambda;&upsilon;&kappa;ή &sigma;&iota;&lambda;&omicron;&upsilon;έ&tau;&alpha;.</p> <p>&Tau;&alpha; &epsilon;&nu;&iota;&sigma;&chi;&upsilon;&mu;έ&nu;&alpha; &kappa;&upsilon;&pi;&epsilon;&lambda;ά&kappa;&iota;&alpha; &pi;&rho;&omicron;&sigma;&phi;έ&rho;&omicron;&upsilon;&nu; &epsilon;&xi;&alpha;&iota;&rho;&epsilon;&tau;&iota;&kappa;ή &sigma;&tau;ή&rho;&iota;&xi;&eta; &kappa;&alpha;&iota; &tau;&alpha;&iota;&rho;&iota;ά&zeta;&omicron;&upsilon;&nu; &alpha;&pi;ό&lambda;&upsilon;&tau;&alpha; &sigma;&epsilon; &gamma;&epsilon;&nu;&nu;&alpha;&iota;ό&delta;&omega;&rho;&alpha; &sigma;&tau;ή&theta;&eta;, &alpha;&pi;ό D έ&omega;&sigmaf; G cup. &Alpha;&upsilon;&tau;ό &tau;&omicron; &sigma;&epsilon;&mu;&iota;&nu;ά&rho;&iota;&omicron; &alpha;&pi;&omicron;&kappa;&alpha;&lambda;ύ&pi;&tau;&epsilon;&iota; &tau;&eta;&nu;<strong> &tau;&epsilon;&chi;&nu;&iota;&kappa;ή &epsilon;&mu;&pi;&epsilon;&iota;&rho;ί&alpha; &tau;&eta;&sigmaf; Diva's Boudoir</strong>: &alpha;&nu;ά&lambda;&omicron;&gamma;&alpha; &mu;&epsilon; &tau;&omicron; &mu;έ&gamma;&epsilon;&theta;ό&sigmaf; &sigma;&alpha;&sigmaf;, &omicron;&iota; &iota;&mu;ά&nu;&tau;&epsilon;&sigmaf; &epsilon;ί&nu;&alpha;&iota; &phi;&alpha;&rho;&delta;ύ&tau;&epsilon;&rho;&omicron;&iota;, &tau;&alpha; &kappa;ύ&pi;&epsilon;&lambda;&lambda;&alpha; &beta;&alpha;&theta;ύ&tau;&epsilon;&rho;&alpha; &kappa;&alpha;&iota; &tau;&omicron; &mu;ή&kappa;&omicron;&sigmaf; &epsilon;&lambda;&alpha;&phi;&rho;ώ&sigmaf; &pi;&rho;&omicron;&sigma;&alpha;&rho;&mu;&omicron;&sigma;&mu;έ&nu;&omicron; &gamma;&iota;&alpha; &nu;&alpha; &epsilon;&gamma;&gamma;&upsilon;&eta;&theta;&epsilon;ί &mu;&iota;&alpha; &tau;έ&lambda;&epsilon;&iota;&alpha; &epsilon;&phi;&alpha;&rho;&mu;&omicron;&gamma;ή &pi;&rho;&omicron;&sigma;&alpha;&rho;&mu;&omicron;&sigma;&mu;έ&nu;&eta; &sigma;&tau;&eta; &mu;&omicron;&rho;&phi;&omicron;&lambda;&omicron;&gamma;ί&alpha; &sigma;&alpha;&sigmaf;.<br><br>&Theta;&alpha; &nu;&iota;ώ&sigma;&epsilon;&tau;&epsilon; &tau;&eta;&nu; έ&mu;&pi;&nu;&epsilon;&upsilon;&sigma;&eta; &tau;&omicron;&upsilon; Bridgerton &sigma;&epsilon; &kappa;ά&theta;&epsilon; &lambda;&epsilon;&pi;&tau;&omicron;&mu;έ&rho;&epsilon;&iota;&alpha;: <strong>&lambda;&epsilon;&pi;&tau;&epsilon;&pi;ί&lambda;&epsilon;&pi;&tau;&alpha; &kappa;&epsilon;&nu;&tau;ή&mu;&alpha;&tau;&alpha;, &epsilon;&kappa;&lambda;&epsilon;&pi;&tau;&upsilon;&sigma;&mu;έ&nu;&alpha; &phi;&iota;&nu;&iota;&rho;ί&sigma;&mu;&alpha;&tau;&alpha; &kappa;&alpha;&iota; &rho;&omicron;&mu;&alpha;&nu;&tau;&iota;&kappa;ό &pi;&nu;&epsilon;ύ&mu;&alpha;</strong> &pi;&omicron;&upsilon; &sigma;&alpha;&sigmaf; &mu;&epsilon;&tau;&alpha;&phi;έ&rho;&omicron;&upsilon;&nu; &sigma;&tau;&omicron;&nu; &epsilon;&kappa;&lambda;&epsilon;&pi;&tau;&upsilon;&sigma;&mu;έ&nu;&omicron; &kappa;ό&sigma;&mu;&omicron; &tau;&eta;&sigmaf; &upsilon;&psi;&eta;&lambda;ή&sigmaf; &kappa;&omicron;&iota;&nu;&omega;&nu;ί&alpha;&sigmaf; &tau;&omicron;&upsilon; &Lambda;&omicron;&nu;&delta;ί&nu;&omicron;&upsilon;. &Alpha;&upsilon;&tau;ό &tau;&omicron; &sigma;&epsilon;&mu;&iota;&nu;ά&rho;&iota;&omicron; &mu;&epsilon;&tau;&alpha;&tau;&rho;έ&pi;&epsilon;&iota; &kappa;ά&theta;&epsilon; &pi;&rho;&omicron;&sigma;&omega;&pi;&iota;&kappa;ή &sigma;&tau;&iota;&gamma;&mu;ή &sigma;&epsilon; &mu;&iota;&alpha; &epsilon;&xi;&alpha;&iota;&rho;&epsilon;&tau;&iota;&kappa;ή &epsilon;&mu;&pi;&epsilon;&iota;&rho;ί&alpha;.</p>
guid
stringhttps://dev.divasboudoir.com/el/babydoll-large-size-bridgerton-romantic-sophistic/sfba5769.htm
highlights
string<ul> <li>&Kappa;&omicron;ύ&rho;&epsilon;&mu;&alpha; &pi;&omicron;&upsilon; &alpha;&gamma;&kappa;&alpha;&lambda;&iota;ά&zeta;&epsilon;&iota; &tau;&omicron; &sigma;ώ&mu;&alpha; &mu;&epsilon; &sigma;&mu;ί&lambda;&epsilon;&upsilon;&sigma;&eta; &gamma;&iota;&alpha; &nu;&alpha; &beta;&epsilon;&lambda;&tau;&iota;ώ&sigma;&epsilon;&iota; &tau;&eta; &sigma;&iota;&lambda;&omicron;&upsilon;έ&tau;&alpha;</li> <li>&Pi;&lambda;&omicron;ύ&sigma;&iota;&omicron; &kappa;&epsilon;&nu;&tau;&eta;&mu;έ&nu;&omicron; &mu;&pi;&omicron;ύ&sigma;&tau;&omicron; &mu;&epsilon; &epsilon;&kappa;&lambda;&epsilon;&pi;&tau;&upsilon;&sigma;&mu;έ&nu;&epsilon;&sigmaf; &lambda;&epsilon;&pi;&tau;&omicron;&mu;έ&rho;&epsilon;&iota;&epsilon;&sigmaf;</li> <li>&Theta;&eta;&kappa;ά&rho;&iota;&alpha; &mu;&epsilon; &mu;&pi;&alpha;&nu;έ&lambda;&alpha; &gamma;&iota;&alpha; &epsilon;&xi;&alpha;&iota;&rho;&epsilon;&tau;&iota;&kappa;ή &sigma;&tau;ή&rho;&iota;&xi;&eta; (D έ&omega;&sigmaf; G)</li> <li>&Epsilon;&upsilon;&rho;&epsilon;ί&epsilon;&sigmaf;, &rho;&upsilon;&theta;&mu;&iota;&zeta;ό&mu;&epsilon;&nu;&epsilon;&sigmaf; &tau;&iota;&rho;ά&nu;&tau;&epsilon;&sigmaf; &gamma;&iota;&alpha; &beta;έ&lambda;&tau;&iota;&sigma;&tau;&eta; ά&nu;&epsilon;&sigma;&eta;</li> <li>&Tau;&epsilon;&chi;&nu;&iota;&kappa;έ&sigmaf; &pi;&rho;&omicron;&sigma;&alpha;&rho;&mu;&omicron;&gamma;έ&sigmaf; &gamma;&iota;&alpha; &delta;&iota;&alpha;&phi;&omicron;&rho;&epsilon;&tau;&iota;&kappa;ά &mu;&epsilon;&gamma;έ&theta;&eta;: &beta;&alpha;&theta;ύ&tau;&epsilon;&rho;&alpha; &phi;&lambda;&iota;&tau;&zeta;ά&nu;&iota;&alpha; &kappa;&alpha;&iota; &pi;&rho;&omicron;&sigma;&alpha;&rho;&mu;&omicron;&sigma;&mu;έ&nu;&omicron; &mu;ή&kappa;&omicron;&sigmaf;</li> <li>Έ&mu;&pi;&nu;&epsilon;&upsilon;&sigma;&eta; Bridgerton &gamma;&iota;&alpha; &epsilon;&kappa;&lambda;&epsilon;&pi;&tau;&upsilon;&sigma;&mu;έ&nu;&omicron; &rho;&omicron;&mu;&alpha;&nu;&tau;&iota;&sigma;&mu;ό</li> <li>&Epsilon;&pi;ί&pi;&epsilon;&delta;&eta; &kappa;&omicron;&iota;&lambda;&iota;ά &chi;ά&rho;&eta; &sigma;&tau;&iota;&sigmaf; &sigma;&tau;&rho;&alpha;&tau;&eta;&gamma;&iota;&kappa;ά &tau;&omicron;&pi;&omicron;&theta;&epsilon;&tau;&eta;&mu;έ&nu;&epsilon;&sigmaf; &phi;&omicron;&upsilon;&rho;&kappa;έ&tau;&epsilon;&sigmaf;</li> <li>&Tau;&omicron; &mu;&epsilon;&lambda;&epsilon;&tau;&eta;&mu;έ&nu;&omicron; &kappa;ό&psi;&iota;&mu;&omicron; &alpha;&nu;&alpha;&delta;&epsilon;&iota;&kappa;&nu;ύ&epsilon;&iota; &tau;&omicron;&upsilon;&sigmaf; &gamma;&lambda;&omicron;&upsilon;&tau;&omicron;ύ&sigmaf;</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringBridgerton μεγάλο μέγεθος babydoll Diva's Boudoir: κεντημένο μπούστο, D-G underwired cup, γλυπτικά φιογκάκια. Ρομαντισμός και εκλέπτυνση στα μεγέθη 42-64. Δωρεάν παράδοση από 59 ευρώ.
keywords
string
title
stringBridgerton Babydoll μεγάλο μέγεθος - Ρομαντικό και εκλεπτυσμένο | Diva's Boudoir
seotitle
stringBridgerton Plus Size Babydoll - Ρομαντισμός και εκλέπτυνση
seouri
stringbabydoll-large-size-bridgerton-romantic-sophistic
specifications
string<ul> <li>&Delta;&iota;&alpha;&theta;έ&sigma;&iota;&mu;&alpha; &mu;&epsilon;&gamma;έ&theta;&eta;: 42 έ&omega;&sigmaf; 64</li> <li>&Kappa;ύ&pi;&epsilon;&lambda;&lambda;&alpha;: D έ&omega;&sigmaf; G &mu;&epsilon; &epsilon;&nu;&sigma;&omega;&mu;&alpha;&tau;&omega;&mu;έ&nu;&omicron; &sigma;&tau;ή&rho;&iota;&gamma;&mu;&alpha;</li> <li>&Lambda;&omicron;&upsilon;&rho;ά&kappa;&iota;&alpha;: &phi;&alpha;&rho;&delta;&iota;ά &kappa;&alpha;&iota; &rho;&upsilon;&theta;&mu;&iota;&zeta;ό&mu;&epsilon;&nu;&alpha; &alpha;&nu;ά&lambda;&omicron;&gamma;&alpha; &mu;&epsilon; &tau;&omicron; &mu;έ&gamma;&epsilon;&theta;&omicron;&sigmaf;</li> <li>&Kappa;&omicron;&pi;ή: &Sigma;&tau;&epsilon;&nu;ή &epsilon;&phi;&alpha;&rho;&mu;&omicron;&gamma;ή &mu;&epsilon; &pi;&tau;&upsilon;&chi;ώ&sigma;&epsilon;&iota;&sigmaf; &pi;&omicron;&upsilon; &sigma;&mu;&iota;&lambda;&epsilon;ύ&omicron;&upsilon;&nu; &tau;&omicron; &sigma;ώ&mu;&alpha;</li> <li>&Sigma;&tau;&upsilon;&lambda; : &Rho;&omicron;&mu;&alpha;&nu;&tau;&iota;&kappa;ή έ&mu;&pi;&nu;&epsilon;&upsilon;&sigma;&eta; Bridgerton</li> <li>&Tau;&epsilon;&chi;&nu;&iota;&kappa;έ&sigmaf; &pi;&rho;&omicron;&sigma;&alpha;&rho;&mu;&omicron;&gamma;έ&sigmaf;: &Beta;&alpha;&theta;ύ&tau;&epsilon;&rho;&alpha; &kappa;ύ&pi;&epsilon;&lambda;&lambda;&alpha; &kappa;&alpha;&iota; &rho;&upsilon;&theta;&mu;&iota;&zeta;ό&mu;&epsilon;&nu;&omicron; &mu;ή&kappa;&omicron;&sigmaf; &alpha;&nu;ά&lambda;&omicron;&gamma;&alpha; &mu;&epsilon; &tau;&omicron; &mu;έ&gamma;&epsilon;&theta;&omicron;&sigmaf;</li> <li>&Kappa;&lambda;&epsilon;ί&sigma;&iota;&mu;&omicron;: &Sigma;ύ&sigma;&tau;&eta;&mu;&alpha; &beta;έ&lambda;&tau;&iota;&sigma;&tau;&eta;&sigmaf; &epsilon;&phi;&alpha;&rho;&mu;&omicron;&gamma;ή&sigmaf;</li> <li>&Phi;&rho;&omicron;&nu;&tau;ί&delta;&alpha;: &Sigma;&upsilon;&nu;&iota;&sigma;&tau;ά&tau;&alpha;&iota; &alpha;&pi;&alpha;&lambda;ό &pi;&lambda;ύ&sigma;&iota;&mu;&omicron;</li> </ul>
stylingtips
string<p>&Tau;&omicron; Bridgerton babydoll &sigma;&upsilon;&nu;&delta;&upsilon;ά&zeta;&epsilon;&tau;&alpha;&iota; &tau;έ&lambda;&epsilon;&iota;&alpha; &mu;&epsilon; έ&nu;&alpha; &sigma;&alpha;&tau;έ&nu; &mu;&pi;&omicron;&upsilon;&rho;&nu;&omicron;ύ&zeta;&iota; &gamma;&iota;&alpha; &nu;&alpha; &delta;&eta;&mu;&iota;&omicron;&upsilon;&rho;&gamma;ή&sigma;&epsilon;&iota; έ&nu;&alpha; &pi;&lambda;ή&rho;&epsilon;&sigmaf; &nu;&upsilon;&chi;&tau;&epsilon;&rho;&iota;&nu;ό &sigma;ύ&nu;&omicron;&lambda;&omicron; &alpha;&nu;&tau;ά&xi;&iota;&omicron; &tau;&omega;&nu; &pi;&iota;&omicron; ό&mu;&omicron;&rho;&phi;&omega;&nu; &rho;&omicron;&mu;&alpha;&nu;&tau;&iota;&kappa;ώ&nu; &eta;&rho;&omega;ί&delta;&omega;&nu;. &Gamma;&iota;&alpha; &mu;&iota;&alpha; &xi;&epsilon;&chi;&omega;&rho;&iota;&sigma;&tau;ή &beta;&rho;&alpha;&delta;&iota;ά, &sigma;&upsilon;&nu;&delta;&upsilon;ά&sigma;&tau;&epsilon; &tau;&omicron; &mu;&epsilon; &nu;&tau;&epsilon;&lambda;&iota;&kappa;ά&tau;&alpha; hold-ups &kappa;&alpha;&iota; &gamma;ό&beta;&epsilon;&sigmaf; &gamma;&iota;&alpha; &mu;&iota;&alpha; &alpha;&upsilon;&theta;&epsilon;&nu;&tau;&iota;&kappa;ή &epsilon;&mu;&phi;ά&nu;&iota;&sigma;&eta; Bridgerton. &Tau;&alpha; &epsilon;&kappa;&lambda;&epsilon;&pi;&tau;&upsilon;&sigma;&mu;έ&nu;&alpha; &kappa;&epsilon;&nu;&tau;ή&mu;&alpha;&tau;&alpha; &sigma;&tau;&omicron; &mu;&pi;&omicron;ύ&sigma;&tau;&omicron; &tau;&omicron; &kappa;&alpha;&theta;&iota;&sigma;&tau;&omicron;ύ&nu; &epsilon;&pi;ί&sigma;&eta;&sigmaf; &iota;&delta;&alpha;&nu;&iota;&kappa;ό &gamma;&iota;&alpha; &nu;&alpha; &tau;&omicron; &phi;&omicron;&rho;έ&sigma;&epsilon;&tau;&epsilon; &kappa;ά&tau;&omega; &alpha;&pi;ό έ&nu;&alpha; &phi;ό&rho;&epsilon;&mu;&alpha; &chi;&omega;&rho;ί&sigmaf; ώ&mu;&omicron;&upsilon;&sigmaf; &gamma;&iota;&alpha; &mu;&iota;&alpha; &pi;&iota;&nu;&epsilon;&lambda;&iota;ά &epsilon;&kappa;&lambda;&epsilon;&pi;&tau;&upsilon;&sigma;&mu;έ&nu;&omicron;&upsilon; &alpha;&iota;&sigma;&theta;&eta;&sigma;&iota;&alpha;&sigma;&mu;&omicron;ύ. &Mu;&eta; &delta;&iota;&sigma;&tau;ά&sigma;&epsilon;&tau;&epsilon; &nu;&alpha; &tau;&omicron; &sigma;&upsilon;&nu;&delta;&upsilon;ά&sigma;&epsilon;&tau;&epsilon; &mu;&epsilon; &lambda;&epsilon;&pi;&tau;&epsilon;&pi;ί&lambda;&epsilon;&pi;&tau;&alpha; &kappa;&omicron;&sigma;&mu;ή&mu;&alpha;&tau;&alpha; &gamma;&iota;&alpha; &nu;&alpha; &omicron;&lambda;&omicron;&kappa;&lambda;&eta;&rho;ώ&sigma;&epsilon;&tau;&epsilon; &tau;&omicron; Regency &pi;&nu;&epsilon;ύ&mu;&alpha; &alpha;&upsilon;&tau;ή&sigmaf; &tau;&eta;&sigmaf; &epsilon;&xi;&alpha;&iota;&rho;&epsilon;&tau;&iota;&kappa;ή&sigmaf; &delta;&eta;&mu;&iota;&omicron;&upsilon;&rho;&gamma;ί&alpha;&sigmaf;.</p>
summary
string<p>&Beta;&upsilon;&theta;&iota;&sigma;&tau;&epsilon;ί&tau;&epsilon; &sigma;&tau;&omicron;&nu; &rho;&omicron;&mu;&alpha;&nu;&tau;&iota;&kappa;ό &kappa;ό&sigma;&mu;&omicron; &tau;&eta;&sigmaf; Bridgerton &mu;&epsilon; &alpha;&upsilon;&tau;ό &tau;&omicron; &epsilon;&xi;&alpha;&iota;&rho;&epsilon;&tau;&iota;&kappa;ό &sigma;&epsilon;&mu;&iota;&nu;ά&rho;&iota;&omicron; &pi;&omicron;&upsilon; &sigma;&upsilon;&nu;&delta;&upsilon;ά&zeta;&epsilon;&iota; &kappa;&omicron;&mu;&psi;ό&tau;&eta;&tau;&alpha; &kappa;&alpha;&iota; &alpha;&iota;&sigma;&theta;&eta;&sigma;&iota;&alpha;&sigma;&mu;ό.</p> <p>&Tau;&omicron; &kappa;ό&psi;&iota;&mu;ό &tau;&omicron;&upsilon; &pi;&omicron;&upsilon; &alpha;&gamma;&kappa;&alpha;&lambda;&iota;ά&zeta;&epsilon;&iota; &tau;&omicron; &sigma;ώ&mu;&alpha; &sigma;&alpha;&sigmaf; &mu;&epsilon; &mu;&iota;&kappa;&rho;έ&sigmaf; &phi;&omicron;&upsilon;&rho;&kappa;έ&tau;&epsilon;&sigmaf; &sigma;&mu;&iota;&lambda;&epsilon;ύ&epsilon;&iota; &alpha;&pi;&alpha;&lambda;ά &tau;&eta; &sigma;&iota;&lambda;&omicron;&upsilon;έ&tau;&alpha; &sigma;&alpha;&sigmaf;, &delta;&iota;&alpha;&tau;&eta;&rho;ώ&nu;&tau;&alpha;&sigmaf; &delta;&iota;&alpha;&kappa;&rho;&iota;&tau;&iota;&kappa;ή &tau;&eta;&nu; &kappa;&omicron;&iota;&lambda;&iota;ά &sigma;&alpha;&sigmaf;, &epsilon;&nu;ώ &pi;&alpha;&rho;ά&lambda;&lambda;&eta;&lambda;&alpha; &alpha;&nu;&alpha;&delta;&epsilon;&iota;&kappa;&nu;ύ&epsilon;&iota; &tau;&omicron;&nu; &pi;&iota;&sigma;&iota;&nu;ό &sigma;&alpha;&sigmaf;.</p> <p>&Tau;&omicron; &pi;&lambda;&omicron;ύ&sigma;&iota;&alpha; &kappa;&epsilon;&nu;&tau;&eta;&mu;έ&nu;&omicron; &mu;&pi;&omicron;ύ&sigma;&tau;&omicron; &kappa;&alpha;&iota; &tau;&alpha; &epsilon;&nu;&iota;&sigma;&chi;&upsilon;&mu;έ&nu;&alpha; &kappa;&upsilon;&pi;&epsilon;&lambda;ά&kappa;&iota;&alpha; &pi;&rho;&omicron;&sigma;&phi;έ&rho;&omicron;&upsilon;&nu; &tau;έ&lambda;&epsilon;&iota;&alpha; &sigma;&tau;ή&rho;&iota;&xi;&eta; &mu;έ&chi;&rho;&iota; &tau;&omicron; cup G.</p>
title
stringBridgerton Babydoll: Ρομαντική κομψότητα για κάθε φιγούρα
usageinstructions
string<p>&Gamma;&iota;&alpha; &nu;&alpha; &alpha;&pi;&omicron;&kappa;&tau;ή&sigma;&epsilon;&tau;&epsilon; &tau;&eta;&nu; &tau;έ&lambda;&epsilon;&iota;&alpha; &epsilon;&phi;&alpha;&rho;&mu;&omicron;&gamma;ή &gamma;&iota;&alpha; &tau;&omicron; Bridgerton babydoll &sigma;&alpha;&sigmaf;, &pi;&rho;&omicron;&sigma;&alpha;&rho;&mu;ό&sigma;&tau;&epsilon; &pi;&rho;ώ&tau;&alpha; &tau;&omicron;&upsilon;&sigmaf; &iota;&mu;ά&nu;&tau;&epsilon;&sigmaf; &sigma;&tau;&omicron; &sigma;&chi;ή&mu;&alpha; &tau;&omicron;&upsilon; &sigma;ώ&mu;&alpha;&tau;ό&sigmaf; &sigma;&alpha;&sigmaf; - &epsilon;ί&nu;&alpha;&iota; &epsilon;&iota;&delta;&iota;&kappa;ά &sigma;&chi;&epsilon;&delta;&iota;&alpha;&sigma;&mu;έ&nu;&omicron;&iota; &pi;&iota;&omicron; &phi;&alpha;&rho;&delta;&iota;ά &sigma;&tau;&alpha; &mu;&epsilon;&gamma;&alpha;&lambda;ύ&tau;&epsilon;&rho;&alpha; &mu;&epsilon;&gamma;έ&theta;&eta; &gamma;&iota;&alpha; &beta;έ&lambda;&tau;&iota;&sigma;&tau;&eta; ά&nu;&epsilon;&sigma;&eta;. &Tau;&omicron;&pi;&omicron;&theta;&epsilon;&tau;ή&sigma;&tau;&epsilon; &tau;&alpha; &epsilon;&nu;&iota;&sigma;&chi;&upsilon;&mu;έ&nu;&alpha; &kappa;ύ&pi;&epsilon;&lambda;&lambda;&alpha; έ&tau;&sigma;&iota; ώ&sigma;&tau;&epsilon; &nu;&alpha; &epsilon;&phi;&alpha;&rho;&mu;ό&zeta;&omicron;&upsilon;&nu; &tau;έ&lambda;&epsilon;&iota;&alpha; &sigma;&tau;&omicron; &mu;&pi;&omicron;ύ&sigma;&tau;&omicron; &sigma;&alpha;&sigmaf;, &alpha;&pi;ό D έ&omega;&sigmaf; G cup.</p> <p>&tau;&alpha; &mu;&iota;&kappa;&rho;ά &rho;&alpha;&phi;&tau;ά&kappa;&iota;&alpha; &pi;&rho;έ&pi;&epsilon;&iota; &nu;&alpha; &epsilon;ί&nu;&alpha;&iota; &kappa;&alpha;&lambda;ά &kappa;&alpha;&tau;&alpha;&nu;&epsilon;&mu;&eta;&mu;έ&nu;&alpha; &gamma;&iota;&alpha; &nu;&alpha; &delta;&eta;&mu;&iota;&omicron;&upsilon;&rho;&gamma;ή&sigma;&omicron;&upsilon;&nu; &tau;&omicron; &epsilon;&pi;&iota;&theta;&upsilon;&mu;&eta;&tau;ό &alpha;&pi;&omicron;&tau;έ&lambda;&epsilon;&sigma;&mu;&alpha; &gamma;&lambda;&upsilon;&pi;&tau;&iota;&kappa;ή&sigmaf; &pi;&omicron;&upsilon; &kappa;&rho;&alpha;&tau;ά&epsilon;&iota; &delta;&iota;&alpha;&kappa;&rho;&iota;&tau;&iota;&kappa;ή &tau;&eta;&nu; &kappa;&omicron;&iota;&lambda;&iota;ά &sigma;&alpha;&sigmaf;. &Alpha;&upsilon;&tau;ό &tau;&omicron; &sigma;&epsilon;&mu;&iota;&nu;ά&rho;&iota;&omicron; &epsilon;ί&nu;&alpha;&iota; &iota;&delta;&alpha;&nu;&iota;&kappa;ό &gamma;&iota;&alpha; &rho;&omicron;&mu;&alpha;&nu;&tau;&iota;&kappa;ή &omicron;&iota;&kappa;&epsilon;&iota;ό&tau;&eta;&tau;&alpha; ή &omega;&sigmaf; &epsilon;&kappa;&lambda;&epsilon;&pi;&tau;&upsilon;&sigma;&mu;έ&nu;&omicron; &nu;&upsilon;&chi;&tau;&iota;&kappa;ό &pi;&omicron;&upsilon; &theta;&alpha; &sigma;&alpha;&sigmaf; &kappa;ά&nu;&epsilon;&iota; &nu;&alpha; &nu;&iota;ώ&sigma;&epsilon;&tau;&epsilon; &sigma;&alpha;&nu; &mu;&iota;&alpha; &pi;&rho;&alpha;&gamma;&mu;&alpha;&tau;&iota;&kappa;ή &eta;&rho;&omega;ί&delta;&alpha; &tau;&eta;&sigmaf; Bridgerton.</p>
en
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Hand wash in lukewarm water (30&deg;C maximum)</li> <li>Use a delicate detergent without bleaching agents</li> <li>Do not wring out; press gently into a towel</li> <li>Dry flat in the shade, away from heat sources</li> <li>Do not iron directly on embroidery</li> <li>Store hanging to preserve cup shape</li> <li>Protect underwires during washing and storage</li> </ul>
description
string<p>Discover the Bridgerton chemise, an exceptional creation that captures the<strong>romantic essence of the Regency era</strong> while offering incomparable modern comfort. This sophisticated piece will sublimate any figure thanks to its meticulously studied close-fitting cut.<br><br>The sumptuously embroidered bodice reveals exceptional craftsmanship, while strategically placed gathers create a remarkable sculpting effect. These technical details keep your tummy discreet while beautifully enhancing your buttocks for a harmonious, feminine silhouette.</p> <p>Underwired cups offer exceptional support and are perfectly suited to generous breasts, from D to G cups. This chemise reveals the<strong> technical expertise of Diva's Boudoir</strong>: depending on your size, the straps are wider, the cups deeper and the length slightly adjusted to guarantee a perfect fit adapted to your morphology.<br><br>Bridgerton inspiration is in every detail: <strong>delicate embroidery, refined finishing and a romantic spirit</strong> that transports you to the sophisticated world of London high society. This chemise transforms every intimate moment into an exceptional experience.</p>
guid
stringhttps://dev.divasboudoir.com/en/babydoll-large-size-bridgerton-romantic-sophisticated/sfba5769.htm
highlights
string<ul> <li>Body-hugging cut with sculpting gathers that refine the silhouette</li> <li>Sumptuously embroidered bodice with refined details</li> <li>Underwired cups for exceptional support (D to G)</li> <li>Wide, adjustable straps for optimum comfort</li> <li>Technical adaptations according to size: deeper cups and adjusted length</li> <li>Bridgerton inspiration for sophisticated romance</li> <li>Flat tummy effect thanks to strategically placed gathers</li> <li>Contoured cut enhances buttocks</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringDiva's Boudoir plus size Bridgerton babydoll: embroidered bodice, D-G underwire cups, sculpting gathers. Romanticism and sophistication, sizes 42-64. Free delivery from €59.
keywords
string
title
stringBridgerton Plus Size Babydoll - Romantic and Sophisticated | Diva's Boudoir
seotitle
stringBridgerton Plus Size Babydoll - Romanticism and Sophistication
seouri
stringbabydoll-large-size-bridgerton-romantic-sophisticated
specifications
string<ul> <li>Sizes available: 42 to 64</li> <li>Cups: D to G with integrated underwire</li> <li>Straps: Wide and adjustable according to size</li> <li>Cut: Close-fitting with sculpting gathers</li> <li>Style: Romantic Bridgerton inspiration</li> <li>Technical adaptations: Deeper cups and adjusted length according to size</li> <li>Closure: Optimal fit system</li> <li>Care: Delicate wash recommended</li> </ul>
stylingtips
string<p>The Bridgerton babydoll pairs perfectly with a satin bathrobe to create a complete nighttime ensemble worthy of the most beautiful romantic heroines. For a special evening, team it with delicate hold-ups and pumps for an authentic Bridgerton look. The bodice's sophisticated embroidery also makes it a perfect piece to wear under an off-the-shoulder dress to add a touch of refined sensuality. Don't hesitate to accessorize with delicate jewelry to complete the Regency spirit of this exceptional creation.</p>
summary
string<p>Immerse yourself in the romantic world of Bridgerton with this exceptional chemise that combines elegance and sensuality.</p> <p>Its body-hugging cut with small gathers delicately sculpts your silhouette, making your tummy discreet while highlighting your buttocks.</p> <p>The sumptuously embroidered bodice and underwired cups offer perfect support up to a G cup.</p>
title
stringBridgerton Babydoll: Romantic elegance for every figure
usageinstructions
string<p>For the perfect fit of your Bridgerton babydoll, first adjust the straps to your body type - they're specially designed wider in plus sizes for optimum comfort. Position the underwired cups so that they fit your bust perfectly, from D to G cup.</p> <p>the small gathers should be well distributed to create the desired sculpting effect that makes your tummy discreet. This chemise is ideal for romantic intimate moments or as a sophisticated nightwear piece that will make you feel like a true Bridgerton heroine.</p>
es
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavar a mano con agua tibia (30&deg;C m&aacute;ximo)</li> <li>Utilizar un detergente delicado sin agentes blanqueadores</li> <li>No centrifugar, planchar suavemente en una toalla</li> <li>Secar en plano a la sombra, lejos de fuentes de calor</li> <li>No planchar directamente sobre el bordado</li> <li>Colgar para conservar la forma de las copas</li> <li>Proteger los aros durante el lavado y el almacenamiento</li> </ul>
description
string<p>Descubra la chemise Bridgerton, una creaci&oacute;n excepcional que captura la<strong>esencia rom&aacute;ntica de la &eacute;poca de la Regencia</strong> a la vez que ofrece un confort moderno incomparable. Esta sofisticada pieza realzar&aacute; cualquier figura gracias a su corte ce&ntilde;ido meticulosamente estudiado.<br><br>El corpi&ntilde;o suntuosamente bordado revela una artesan&iacute;a excepcional, mientras que los fruncidos estrat&eacute;gicamente colocados crean un notable efecto esculpido. Estos detalles t&eacute;cnicos disimulan el vientre y realzan magn&iacute;ficamente los gl&uacute;teos para una silueta armoniosa y femenina.</p> <p>Las copas con aros ofrecen una sujeci&oacute;n excepcional y se adaptan perfectamente a pechos generosos, de copa D a G. Este picard&iacute;as revela la<strong> pericia t&eacute;cnica de Diva's Boudoir</strong>: en funci&oacute;n de su talla, los tirantes son m&aacute;s anchos, las copas m&aacute;s profundas y la longitud ligeramente ajustada para garantizar un ajuste perfecto adaptado a su morfolog&iacute;a.<br><br>Sentir&aacute;s la inspiraci&oacute;n Bridgerton en cada detalle: <strong>bordados delicados, acabados refinados y un esp&iacute;ritu rom&aacute;ntico</strong> que te transportan al sofisticado mundo de la alta sociedad londinense. Esta chemise transforma cada momento &iacute;ntimo en una experiencia excepcional.</p>
guid
stringhttps://dev.divasboudoir.com/es/sofisticado-y-romántico-picardías-talla-grande-Bridgerton/sfba5769.htm
highlights
string<ul> <li>Corte ce&ntilde;ido al cuerpo con fruncidos que estilizan la silueta</li> <li>Corpi&ntilde;o suntuosamente bordado con refinados detalles</li> <li>Copas con aros para una sujeci&oacute;n excepcional (D a G)</li> <li>Tirantes anchos y ajustables para un confort &oacute;ptimo</li> <li>Adaptaciones t&eacute;cnicas para diferentes tallas: copas m&aacute;s profundas y longitud ajustada</li> <li>Inspiraci&oacute;n Bridgerton para un romanticismo sofisticado</li> <li>Efecto vientre plano gracias a los fruncidos estrat&eacute;gicamente situados</li> <li>El estudiado corte realza los gl&uacute;teos</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringPicardías Bridgerton talla grande Diva's Boudoir: corpiño bordado, copas con aros D-G, fruncidos esculturales. Romanticismo y sofisticación en las tallas 42-64. Envío gratuito a partir de 59 euros.
keywords
string
title
stringBridgerton Babydoll Talla grande - Romántico y Sofisticado | Diva's Boudoir
seotitle
stringPicardías talla grande Bridgerton - Romanticismo y sofisticación
seouri
stringsofisticado-y-romántico-picardías-talla-grande-Bridgerton
specifications
string<ul> <li>Tallas disponibles: de la 42 a la 64</li> <li>Copas: de la D a la G con aros integrados</li> <li>Tirantes: Anchos y ajustables seg&uacute;n talla</li> <li>Corte: ce&ntilde;ido con fruncidos que esculpen el cuerpo</li> <li>Estilo: Rom&aacute;ntico de inspiraci&oacute;n Bridgerton</li> <li>Adaptaciones t&eacute;cnicas: Copas m&aacute;s profundas y longitud ajustable seg&uacute;n talla</li> <li>Cierre: Sistema de ajuste &oacute;ptimo</li> <li>Cuidados: Se recomienda un lavado delicado</li> </ul>
stylingtips
string<p>El picard&iacute;as Bridgerton combina a la perfecci&oacute;n con un albornoz de sat&eacute;n para crear un conjunto de noche digno de las m&aacute;s bellas hero&iacute;nas rom&aacute;nticas. Para una velada especial, comb&iacute;nalo con unas delicadas medias y unos zapatos de sal&oacute;n para conseguir un aut&eacute;ntico look Bridgerton. El sofisticado bordado del corpi&ntilde;o tambi&eacute;n lo hace perfecto para llevarlo debajo de un vestido sin hombros y darle un toque de refinada sensualidad. No dudes en adornarlo con delicadas joyas para completar el esp&iacute;ritu Regency de esta creaci&oacute;n excepcional.</p>
summary
string<p>Sum&eacute;rgete en el rom&aacute;ntico mundo de Bridgerton con esta excepcional camisa que combina elegancia y sensualidad.</p> <p>Su corte ce&ntilde;ido al cuerpo con peque&ntilde;os fruncidos esculpe delicadamente tu silueta, manteniendo tu vientre discreto a la vez que resalta tus nalgas.</p> <p>El suntuoso corpi&ntilde;o bordado y las copas con aros ofrecen una sujeci&oacute;n perfecta hasta una copa G.</p>
title
stringBridgerton Babydoll: Elegancia romántica para todas las figuras
usageinstructions
string<p>Para conseguir el ajuste perfecto de tu picard&iacute;as Bridgerton, primero ajusta los tirantes a la forma de tu cuerpo: est&aacute;n especialmente dise&ntilde;ados m&aacute;s anchos en las tallas grandes para una comodidad &oacute;ptima. Coloca las copas con aros de forma que se ajusten perfectamente a tu busto, desde la copa D hasta la G.</p> <p>los peque&ntilde;os fruncidos deben estar bien distribuidos para crear el efecto esculpido deseado que mantenga tu vientre discreto. Esta chemise es ideal para la intimidad rom&aacute;ntica o como sofisticada prenda de noche que te har&aacute; sentir como una aut&eacute;ntica hero&iacute;na Bridgerton.</p>
fr
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavage &agrave; la main &agrave; l'eau ti&egrave;de (30&deg;C maximum)</li> <li>Utiliser une lessive d&eacute;licate sans agents blanchissants</li> <li>Ne pas essorer, presser d&eacute;licatement dans une serviette</li> <li>S&eacute;chage &agrave; plat &agrave; l'ombre, loin des sources de chaleur</li> <li>Ne pas repasser directement sur les broderies</li> <li>Ranger suspendu pour pr&eacute;server la forme des bonnets</li> <li>Prot&eacute;ger les armatures lors du lavage et du rangement</li> </ul>
description
string<p>D&eacute;couvrez la nuisette Bridgerton, une cr&eacute;ation d'exception qui capture l'<strong>essence romantique de l'&eacute;poque R&eacute;gence</strong> tout en offrant un confort moderne incomparable. Cette pi&egrave;ce sophistiqu&eacute;e saura sublimer toutes les silhouettes gr&acirc;ce &agrave; sa coupe pr&egrave;s du corps m&eacute;ticuleusement &eacute;tudi&eacute;e.<br><br>Le corsage somptueusement brod&eacute; r&eacute;v&egrave;le un savoir-faire artisanal exceptionnel, tandis que les petites fronces strat&eacute;giquement plac&eacute;es cr&eacute;ent un effet sculptant remarquable. Ces d&eacute;tails techniques rendent votre ventre discret tout en mettant magnifiquement vos fesses en valeur pour une silhouette harmonieuse et f&eacute;minine.</p> <p>Les bonnets &agrave; armatures offrent un maintien exceptionnel et s'adaptent parfaitement aux poitrines g&eacute;n&eacute;reuses, du bonnet D au bonnet G. Cette nuisette r&eacute;v&egrave;le l<strong>'expertise technique de Diva's Boudoir</strong> : selon votre taille, les bretelles sont plus larges, les bonnets plus profonds et la longueur l&eacute;g&egrave;rement ajust&eacute;e pour garantir un ajustement parfait adapt&eacute; &agrave; votre morphologie.<br><br>L'inspiration Bridgerton se ressent dans chaque d&eacute;tail : <strong>broderies d&eacute;licates, finitions raffin&eacute;es et esprit romantique</strong> qui vous transportent dans l'univers sophistiqu&eacute; de la haute soci&eacute;t&eacute; londonienne. Cette nuisette transforme chaque moment intime en une exp&eacute;rience d'exception.</p>
guid
stringhttps://dev.divasboudoir.com/fr/nuisette-grande-taille-bridgerton-romantique-sophistiquee/sfba5769.htm
highlights
string<ul> <li>Coupe pr&egrave;s du corps avec fronces sculptantes qui affinent la silhouette</li> <li>Corsage somptueusement brod&eacute; aux d&eacute;tails raffin&eacute;s</li> <li>Bonnets &agrave; armatures pour un maintien exceptionnel (D &agrave; G)</li> <li>Bretelles larges ajustables pour un confort optimal</li> <li>Adaptations techniques selon les tailles : bonnets plus profonds et longueur ajust&eacute;e</li> <li>Inspiration Bridgerton pour un romantisme sophistiqu&eacute;</li> <li>Effet ventre plat gr&acirc;ce aux fronces strat&eacute;giquement plac&eacute;es</li> <li>Mise en valeur des fesses par la coupe &eacute;tudi&eacute;e</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringNuisette Bridgerton grande taille Diva's Boudoir : corsage brodé, bonnets armatures D-G, fronces sculptantes. Romantisme et sophistication tailles 42-64. Livraison gratuite dès 59€.
keywords
string
title
stringNuisette Bridgerton Grande Taille - Romantique et Sophistiquée | Diva's Boudoir
seotitle
stringNuisette Grande Taille Bridgerton - Romantisme et Sophistication
seouri
stringnuisette-grande-taille-bridgerton-romantique-sophistiquee
specifications
string<ul> <li>Tailles disponibles : 42 &agrave; 64</li> <li>Bonnets : D &agrave; G avec armatures int&eacute;gr&eacute;es</li> <li>Bretelles : Larges et ajustables selon les tailles</li> <li>Coupe : Pr&egrave;s du corps avec fronces sculptantes</li> <li>Style : Inspiration Bridgerton romantique</li> <li>Adaptations techniques : Bonnets plus profonds et longueur ajust&eacute;e selon les tailles</li> <li>Fermeture : Syst&egrave;me d'ajustement optimal</li> <li>Entretien : Lavage d&eacute;licat recommand&eacute;</li> </ul>
stylingtips
string<p>La nuisette Bridgerton se marie parfaitement avec un peignoir en satin pour cr&eacute;er un ensemble de nuit complet digne des plus belles h&eacute;ro&iuml;nes romantiques. Pour une soir&eacute;e sp&eacute;ciale, associez-la &agrave; des bas autofixants d&eacute;licats et des escarpins pour un look Bridgerton authentique. Les broderies sophistiqu&eacute;es du corsage en font &eacute;galement une pi&egrave;ce parfaite &agrave; porter sous une robe d&eacute;collet&eacute;e pour ajouter une touche de sensualit&eacute; raffin&eacute;e. N'h&eacute;sitez pas &agrave; accessoiriser avec des bijoux d&eacute;licats pour compl&eacute;ter l'esprit R&eacute;gence de cette cr&eacute;ation d'exception.</p>
summary
string<p>Plongez dans l'univers romantique de Bridgerton avec cette nuisette d'exception qui allie &eacute;l&eacute;gance et sensualit&eacute;.</p> <p>Sa coupe pr&egrave;s du corps avec petites fronces sculpte d&eacute;licatement votre silhouette en rendant votre ventre discret tout en mettant vos fesses en valeur.</p> <p>Le corsage somptueusement brod&eacute; et les bonnets &agrave; armatures offrent un maintien parfait jusqu'au bonnet G.</p>
title
stringNuisette Bridgerton : L'élégance romantique qui sublime toutes les silhouettes
usageinstructions
string<p>Pour un ajustement parfait de votre nuisette Bridgerton, ajustez d'abord les bretelles selon votre morphologie - elles sont sp&eacute;cialement con&ccedil;ues plus larges dans les grandes tailles pour un confort optimal. Positionnez les bonnets &agrave; armatures de mani&egrave;re &agrave; ce qu'ils &eacute;pousent parfaitement votre poitrine, du bonnet D au G.</p> <p>&nbsp;Les petites fronces doivent &ecirc;tre bien r&eacute;parties pour cr&eacute;er l'effet sculptant d&eacute;sir&eacute; qui rend votre ventre discret. Cette nuisette est id&eacute;ale pour les moments intimes romantiques ou comme pi&egrave;ce de nuit sophistiqu&eacute;e qui vous fera vous sentir comme une v&eacute;ritable h&eacute;ro&iuml;ne de Bridgerton.</p>
it
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavare a mano in acqua tiepida (massimo 30&deg;C)</li> <li>Utilizzare un detersivo delicato senza agenti sbiancanti</li> <li>Non centrifugare, ma stirare delicatamente in un asciugamano</li> <li>Asciugare in piano all'ombra, lontano da fonti di calore</li> <li>Non stirare direttamente sul ricamo</li> <li>Appendere per preservare la forma delle coppe</li> <li>Proteggere i ferretti durante il lavaggio e la conservazione</li> </ul>
description
string<p>Scoprite la chemise Bridgerton, una creazione eccezionale che cattura l'<strong>essenza romantica dell'epoca Regency</strong>, offrendo al contempo un comfort moderno incomparabile. Questo capo sofisticato valorizzer&agrave; qualsiasi figura grazie al suo taglio aderente meticolosamente studiato.<br><br>Il corpetto sontuosamente ricamato rivela un'eccezionale maestria, mentre le arricciature strategicamente posizionate creano un notevole effetto scultura. Questi dettagli tecnici mantengono discreta la pancia e valorizzano magnificamente i glutei per una silhouette armoniosa e femminile.</p> <p>Le coppe con ferretto offrono un sostegno eccezionale e si adattano perfettamente ai seni generosi, dalla D alla G. Questa chemise rivela l'<strong>esperienza tecnica di Diva's Boudoir</strong>: a seconda della taglia, le spalline sono pi&ugrave; larghe, le coppe pi&ugrave; profonde e la lunghezza leggermente regolata per garantire una vestibilit&agrave; perfetta e adatta alla vostra morfologia.<br><br>Sentirete l'ispirazione Bridgerton in ogni dettaglio: <strong>ricami delicati, finiture raffinate e uno spirito romantico</strong> che vi trasporter&agrave; nel mondo sofisticato dell'alta societ&agrave; londinese. Questa chemise trasforma ogni momento intimo in un'esperienza eccezionale.</p>
guid
stringhttps://dev.divasboudoir.com/it/sofisticato-e-romantico-bridgerton-babydoll-taglia-grande/sfba5769.htm
highlights
string<ul> <li>Taglio aderente al corpo con arricciature modellanti per affinare la silhouette</li> <li>Corpetto sontuosamente ricamato con dettagli raffinati</li> <li>Coppe con ferretto per un sostegno eccezionale (da D a G)</li> <li>Spalline larghe e regolabili per un comfort ottimale</li> <li>Adattamenti tecnici per le diverse taglie: coppe pi&ugrave; profonde e lunghezza regolata</li> <li>Ispirazione Bridgerton per un romanticismo sofisticato</li> <li>Effetto pancia piatta grazie alle arricciature strategicamente posizionate</li> <li>Il taglio studiato valorizza i glutei</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringBabydoll Bridgerton taglia grande Diva's Boudoir: corpetto ricamato, coppe D-G con ferretto, arricciature modellanti. Romanticismo e raffinatezza nelle taglie 42-64. Consegna gratuita a partire da 59 euro.
keywords
string
title
stringBridgerton Babydoll taglia grande - Romantico e sofisticato | Boudoir da diva
seotitle
stringBabydoll Bridgerton taglia grande - Romanticismo e raffinatezza
seouri
stringsofisticato-e-romantico-bridgerton-babydoll-taglia-grande
specifications
string<ul> <li>Taglie disponibili: dalla 42 alla 64</li> <li>Coppe: da D a G con ferretto integrato</li> <li>Spalline: larghe e regolabili in base alla taglia</li> <li>Taglio: aderente con arricciature modellanti</li> <li>Stile: ispirazione romantica Bridgerton</li> <li>Adattamenti tecnici: Coppe pi&ugrave; profonde e lunghezza regolabile in base alla taglia</li> <li>Chiusura: Sistema di vestibilit&agrave; ottimale</li> <li>Cura: Si consiglia un lavaggio delicato</li> </ul>
stylingtips
string<p>Il babydoll Bridgerton si abbina perfettamente a un accappatoio di raso per creare un completo da notte degno delle pi&ugrave; belle eroine romantiche. Per una serata speciale, abbinatelo a delicate autoreggenti e d&eacute;collet&eacute; per un autentico look Bridgerton. Il sofisticato ricamo sul corpetto lo rende perfetto anche da indossare sotto un abito off-the-shoulder per un tocco di raffinata sensualit&agrave;. Non esitate ad abbinarlo a gioielli delicati per completare lo spirito Regency di questa creazione eccezionale.</p>
summary
string<p>Immergetevi nel romantico mondo di Bridgerton con questa eccezionale chemise che unisce eleganza e sensualit&agrave;.</p> <p>Il suo taglio aderente al corpo con piccole arricciature scolpisce delicatamente la silhouette, mantenendo la pancia discreta e mettendo in risalto il sedere.</p> <p>Il corpetto sontuosamente ricamato e le coppe con ferretto offrono un sostegno perfetto fino alla coppa G.</p>
title
stringBridgerton Babydoll: eleganza romantica per ogni figura
usageinstructions
string<p>Per ottenere la vestibilit&agrave; perfetta del vostro babydoll Bridgerton, regolate innanzitutto le spalline in base alla forma del vostro corpo: sono state appositamente progettate pi&ugrave; larghe nelle taglie grandi per garantire un comfort ottimale. Posizionate le coppe con ferretto in modo che si adattino perfettamente al vostro seno, dalla D alla G.</p> <p>le piccole arricciature devono essere ben distribuite per creare l'effetto scultura desiderato e mantenere la pancia discreta. Questa chemise &egrave; ideale per un'intimit&agrave; romantica o come sofisticato abbigliamento da notte che vi far&agrave; sentire come una vera eroina Bridgerton.</p>
nl
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Handwas in lauw water (maximaal 30&deg;C)</li> <li>Gebruik een fijnwasmiddel zonder bleekmiddelen</li> <li>Niet centrifugeren, voorzichtig in een handdoek drukken</li> <li>Plat drogen in de schaduw, uit de buurt van warmtebronnen</li> <li>Niet rechtstreeks op het borduurwerk strijken</li> <li>Ophangen om de vorm van de cups te behouden</li> <li>Bescherm beugels tijdens het wassen en opbergen</li> </ul>
description
string<p>Ontdek de Bridgerton chemise, een uitzonderlijke creatie die de<strong>romantische essentie van het Regency-tijdperk</strong> weergeeft en tegelijkertijd onvergelijkbaar modern comfort biedt. Dit geraffineerde stuk zal elk figuur verbeteren dankzij de zorgvuldig bestudeerde nauwsluitende snit.<br><br>Het weelderig geborduurde lijfje onthult uitzonderlijk vakmanschap, terwijl strategisch geplaatste plooien een opmerkelijk sculpturerend effect cre&euml;ren. Deze technische details houden je buik discreet terwijl ze je billen prachtig accentueren voor een harmonieus, vrouwelijk silhouet.</p> <p>De beugelcups bieden uitzonderlijke ondersteuning en zijn perfect geschikt voor royale borsten, van D- tot G-cups. Deze chemise onthult de<strong> technische expertise van Diva's Boudoir</strong>: afhankelijk van je maat zijn de bandjes breder, de cups dieper en de lengte iets aangepast om een perfecte pasvorm te garanderen, aangepast aan jouw morfologie.<br><br>Je voelt de inspiratie van Bridgerton in elk detail: <strong>delicaat borduurwerk, verfijnde afwerkingen en een romantische geest</strong> die je meevoeren naar de verfijnde wereld van de Londense high society. Deze chemise maakt van elk intiem moment een uitzonderlijke ervaring.</p>
guid
stringhttps://dev.divasboudoir.com/nl/geraffineerde-romantische-bridgerton-babydoll-grote-maat/sfba5769.htm
highlights
string<ul> <li>Aansluitend model met sculpturale plooien om het silhouet te verfijnen</li> <li>Weelderig geborduurd lijfje met verfijnde details</li> <li>Beugelcups voor uitzonderlijke ondersteuning (D tot G)</li> <li>Brede, verstelbare bandjes voor optimaal comfort</li> <li>Technische aanpassingen voor verschillende maten: diepere cups en aangepaste lengte</li> <li>Bridgerton inspiratie voor verfijnde romantiek</li> <li>Plat buikeffect dankzij strategisch geplaatste plooien</li> <li>De bestudeerde snit accentueert de billen</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringBridgerton grote maat babydoll Diva's Boudoir: geborduurd lijfje, D-G beugelcups, modellerende plooien. Romantiek en verfijning in de maten 42-64. Gratis bezorging vanaf €59.
keywords
string
title
stringBridgerton Babydoll Grote Maat - Romantisch en Verfijnd | Diva's Boudoir
seotitle
stringBridgerton Babydoll Grote Maat - Romantiek en Verfijning
seouri
stringgeraffineerde-romantische-bridgerton-babydoll-grote-maat
specifications
string<ul> <li>Beschikbare maten: 42 tot 64</li> <li>Cups: D tot G met ge&iuml;ntegreerde beugel</li> <li>Bandjes: Breed en verstelbaar volgens maat</li> <li>Snit: Nauwsluitend met modellerende plooien</li> <li>Stijl: Romantische Bridgerton inspiratie</li> <li>Technische aanpassingen: Diepere cups en verstelbare lengte volgens maat</li> <li>Sluiting: Optimale pasvorm</li> <li>Onderhoud: Fijne was aanbevolen</li> </ul>
stylingtips
string<p>De Bridgerton babydoll combineert perfect met een satijnen badjas om een compleet nachtelijk ensemble te cre&euml;ren dat de mooiste romantische heldinnen waardig is. Voor een speciale avond combineer je het met delicate hold-ups en pumps voor een authentieke Bridgerton-look. Het geraffineerde borduursel op het lijfje maakt het ook perfect om te dragen onder een off-the-shoulder jurk voor een vleugje verfijnde sensualiteit. Aarzel niet om deze uitzonderlijke creatie te verfraaien met delicate juwelen om de Regency-sfeer compleet te maken.</p>
summary
string<p>Dompel jezelf onder in de romantische wereld van Bridgerton met deze uitzonderlijke chemise die elegantie en sensualiteit combineert.</p> <p>De nauwsluitende snit met kleine plooitjes geeft je silhouet delicaat vorm, houdt je buik discreet en accentueert je billen.</p> <p>Het weelderig geborduurde lijfje en de beugelcups bieden perfecte ondersteuning tot een G-cup.</p>
title
stringBridgerton Babydoll: Romantische elegantie voor elk figuur
usageinstructions
string<p>Voor de perfecte pasvorm van je Bridgerton babydoll pas je eerst de bandjes aan je lichaamsvorm aan - ze zijn speciaal breder ontworpen in grote maten voor optimaal comfort. Plaats de beugelcups zo dat ze perfect bij je buste passen, van D- tot G-cup.</p> <p>de kleine plooitjes moeten goed verdeeld zijn om het gewenste sculpturerende effect te cre&euml;ren dat je buikje discreet houdt. Deze chemise is ideaal voor romantische intimiteit of als geraffineerde nachtkleding waarmee je je een echte Bridgerton-heldin voelt.</p>
pt
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavar &agrave; m&atilde;o em &aacute;gua t&eacute;pida (30&deg;C no m&aacute;ximo)</li> <li>Utilizar um detergente delicado sem agentes branqueadores</li> <li>N&atilde;o secar &agrave; centrifuga&ccedil;&atilde;o, pressionar suavemente numa toalha</li> <li>Secar &agrave; sombra, longe de fontes de calor</li> <li>N&atilde;o passar a ferro diretamente sobre o bordado</li> <li>Pendurar para preservar a forma das ch&aacute;venas</li> <li>Proteger as arma&ccedil;&otilde;es durante a lavagem e a conserva&ccedil;&atilde;o</li> </ul>
description
string<p>Descubra a camisa de noite Bridgerton, uma cria&ccedil;&atilde;o excecional que capta a<strong>ess&ecirc;ncia rom&acirc;ntica da &eacute;poca da Reg&ecirc;ncia</strong> e oferece um conforto moderno incompar&aacute;vel. Esta pe&ccedil;a sofisticada real&ccedil;a qualquer figura gra&ccedil;as ao seu corte justo meticulosamente estudado.<br><br>O corpete sumptuosamente bordado revela um trabalho artesanal excecional, enquanto as pregas estrategicamente colocadas criam um efeito de escultura not&aacute;vel. Estes detalhes t&eacute;cnicos mant&ecirc;m a sua barriga discreta enquanto real&ccedil;am magnificamente as suas n&aacute;degas para uma silhueta harmoniosa e feminina.</p> <p>As copas com aros oferecem um apoio excecional e adaptam-se perfeitamente a seios generosos, de copas D a G. Esta camisa de noite revela a<strong> per&iacute;cia t&eacute;cnica da Diva's Boudoir</strong>: consoante o seu tamanho, as al&ccedil;as s&atilde;o mais largas, as copas mais profundas e o comprimento ligeiramente ajustado para garantir um ajuste perfeito adaptado &agrave; sua morfologia.<br><br>Sentir&aacute; a inspira&ccedil;&atilde;o Bridgerton em cada pormenor: <strong>bordados delicados, acabamentos requintados e um esp&iacute;rito rom&acirc;ntico</strong> que a transportam para o mundo sofisticado da alta sociedade londrina. Esta camisa de noite transforma cada momento &iacute;ntimo numa experi&ecirc;ncia excecional.</p>
guid
stringhttps://dev.divasboudoir.com/pt/babydoll-grande-bridgerton-romântico-sofisticado/sfba5769.htm
highlights
string<ul> <li>Corte justo ao corpo com franzidos esculturais para afinar a silhueta</li> <li>Corpete sumptuosamente bordado com pormenores refinados</li> <li>Copas com aros para um apoio excecional (D a G)</li> <li>Al&ccedil;as largas e ajust&aacute;veis para um conforto &oacute;timo</li> <li>Adapta&ccedil;&otilde;es t&eacute;cnicas para tamanhos diferentes: copas mais profundas e comprimento ajustado</li> <li>Inspira&ccedil;&atilde;o Bridgerton para um romance sofisticado</li> <li>Efeito barriga lisa gra&ccedil;as &agrave;s pregas estrategicamente colocadas</li> <li>O corte estudado valoriza as n&aacute;degas</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringBabydoll Bridgerton tamanho grande Diva's Boudoir: corpete bordado, copas D-G com aros, franzidos esculturais. Romantismo e sofisticação nos tamanhos 42-64. Entrega gratuita a partir de 59 euros.
keywords
string
title
stringBabydoll Bridgerton Tamanho grande - Romântico e sofisticado | Diva's Boudoir
seotitle
stringBabydoll Bridgerton Plus Size - Romantismo e Sofisticação
seouri
stringbabydoll-grande-bridgerton-romântico-sofisticado
specifications
string<ul> <li>Tamanhos dispon&iacute;veis: 42 a 64</li> <li>Copas: D a G com arma&ccedil;&atilde;o integrada</li> <li>Al&ccedil;as: largas e ajust&aacute;veis consoante o tamanho</li> <li>Corte: justo com franzidos esculturais</li> <li>Estilo: Rom&acirc;ntico de inspira&ccedil;&atilde;o Bridgerton</li> <li>Adapta&ccedil;&otilde;es t&eacute;cnicas: Copas mais profundas e comprimento regul&aacute;vel segundo o tamanho</li> <li>Fecho: Sistema de ajuste &oacute;timo</li> <li>Cuidados: Recomenda-se uma lavagem delicada</li> </ul>
stylingtips
string<p>O babydoll Bridgerton combina perfeitamente com um roup&atilde;o de banho de cetim para criar um conjunto noturno completo digno das mais belas hero&iacute;nas rom&acirc;nticas. Para uma noite especial, combine-o com delicadas presilhas e sapatos de salto alto para um aut&ecirc;ntico look Bridgerton. O sofisticado bordado no corpete tamb&eacute;m o torna perfeito para usar por baixo de um vestido sem ombros para um toque de sensualidade refinada. N&atilde;o hesite em usar acess&oacute;rios com j&oacute;ias delicadas para completar o esp&iacute;rito Regency desta cria&ccedil;&atilde;o excecional.</p>
summary
string<p>Mergulhe no mundo rom&acirc;ntico de Bridgerton com esta camisa de noite excecional que combina eleg&acirc;ncia e sensualidade.</p> <p>O seu corte justo ao corpo com pequenas pregas esculpe delicadamente a sua silhueta, mantendo a sua barriga discreta enquanto real&ccedil;a as suas n&aacute;degas.</p> <p>O corpete sumptuosamente bordado e as copas com arame oferecem um suporte perfeito at&eacute; uma copa G.</p>
title
stringBabydoll Bridgerton: elegância romântica para todas as silhuetas
usageinstructions
string<p>Para obter o ajuste perfeito do seu babydoll Bridgerton, comece por ajustar as al&ccedil;as &agrave; forma do seu corpo - s&atilde;o especialmente concebidas mais largas nos tamanhos maiores para um conforto &oacute;timo. Posicione as copas com aros de modo a ajustarem-se perfeitamente ao seu busto, de copa D a copa G.</p> <p>as pequenas pregas devem ser bem distribu&iacute;das para criar o efeito de escultura desejado que mant&eacute;m a sua barriga discreta. Esta camisa de noite &eacute; ideal para a intimidade rom&acirc;ntica ou como uma roupa de noite sofisticada que a far&aacute; sentir-se como uma verdadeira hero&iacute;na de Bridgerton.</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-coquette-schwarz-und-rosa
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-coquette-mayro-kai-roz
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-coquette-black-and-pink
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-coquette-negro-y-rosa
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-coquette-noir-et-rose
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-coquette-nero-e-rosa
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-coquette-zwart-en-roze
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-coquette-preto-e-cor-de-rosa
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-coquette-schwarz-und-rosa
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-coquette-mayro-kai-roz
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-coquette-black-and-pink
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-coquette-negro-y-rosa
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-coquette-noir-et-rose
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-coquette-nero-e-rosa
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-coquette-zwart-en-roze
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-coquette-preto-e-cor-de-rosa
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-coquette-schwarz-und-rosa
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-coquette-mayro-kai-roz
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-coquette-black-and-pink
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-coquette-negro-y-rosa
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-coquette-noir-et-rose
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-coquette-nero-e-rosa
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-coquette-zwart-en-roze
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-coquette-preto-e-cor-de-rosa
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-coquette-schwarz-und-rosa
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-coquette-mayro-kai-roz
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-coquette-black-and-pink
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-coquette-negro-y-rosa
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-coquette-noir-et-rose
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-coquette-nero-e-rosa
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-coquette-zwart-en-roze
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-coquette-preto-e-cor-de-rosa
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
smboudoir
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-coquette-schwarz-und-rosa
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-coquette-mayro-kai-roz
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-coquette-black-and-pink
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-coquette-negro-y-rosa
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-coquette-noir-et-rose
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-coquette-nero-e-rosa
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-coquette-zwart-en-roze
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-coquette-preto-e-cor-de-rosa
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
name
string21125X
netweight
string
nextshipment
stringtoday
ordered
number9
orderidx
number0
origin
string
originalsize
string
packaging
string
productshipment
stringauto
productuid
stringB71C293E-D21B-4C3E-B61FB74690D289B6
promountil
string
rating
stringnone
recorduid
stringB71C293E-D21B-4C3E-B61FB74690D289B6
reference
stringSFBA5769
related
string
reserved
string
returned
number0
returnsallowed
number1
section
stringcabaret
shipment
string8to10days
showbrand
number1
sizeinfos
Query
Template: /system/api/product/sizes.cfc:20
Execution Time: 2.23 ms
Record Count: 5
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,'227,229,1275,230,510') > 0
and product_variations.productuid = 'B71C293E-D21B-4C3E-B61FB74690D289B6'
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
11275XL/2XL+intlsizeblackpinkXL/2XL+XL/2XL+222wpluslingerie1XL-2XLXL/2XL+48-5018-2022-2450-5250-5248-5054-5650-5248-50118-12295-102122-127
25103XL/4XL+intlsizeblackpink3XL/4XL+3XL/4XL+222wpluslingerie3XL-4XL3XL/4XL+54-5624-2628-3056-5856-5854-5660-6256-5854-56127-132109-114135-140
3227XLintlsizeblackpinkXLXL222wpluslingerieXLXL42-4412-1416-1844-4644-4642-4448-5044-4642-44102-11281-91107-117
4229XL/2XLintlsizeblackpinkXL/2XLXL/2XL222wpluslingerie1XL-2XLXL/2XL46-4816-1820-2248-5048-5046-4852-5448-5046-48112-11791-95117-122
52303XL/4XLintlsizeblackpink3XL/4XL3XL/4XL222wpluslingerie3XL-4XL3XL/4XL50-5220-2224-2852-5452-5450-5256-5852-5450-52122-127102-109127-135
sizeranges
stringplus
sizes
string227,229,1275,230,510
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: 46.7 ms
Record Count: 3
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select * from (
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = 'B71C293E-D21B-4C3E-B61FB74690D289B6'
and product_variations.isactive = 1
and product_sizes.id_size = 227
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 = 'B71C293E-D21B-4C3E-B61FB74690D289B6'
and product_variations.isactive = 1
and product_sizes.id_size = 229
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 = 'B71C293E-D21B-4C3E-B61FB74690D289B6'
and product_variations.isactive = 1
and product_sizes.id_size = 1275
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 = 'B71C293E-D21B-4C3E-B61FB74690D289B6'
and product_variations.isactive = 1
and product_sizes.id_size = 230
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 = 'B71C293E-D21B-4C3E-B61FB74690D289B6'
and product_variations.isactive = 1
and product_sizes.id_size = 510
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
1B71C293E-D21B-4C3E-B61FB74690D289B6384B5DE7-67D3-49D6-9CB61F6D5F28F69D227blackpinklinear-gradient(90deg, #000000 50%, #FE70BD 50%)XLXL42-4412-1416-1844-4644-4642-4448-5044-4642-44wlingerieXLintlsize74.95830STOCK01200000002112588312417649922all
2B71C293E-D21B-4C3E-B61FB74690D289B6F2178FDD-C354-4310-A8F576190BBA053A229blackpinklinear-gradient(90deg, #000000 50%, #FE70BD 50%)1XL-2XLXL/2XL46-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerieXL/2XLintlsize74.95830STOCK01200005002112588312417650522all
3B71C293E-D21B-4C3E-B61FB74690D289B6F355C714-2945-4C0B-AF3F47996AD7E2B7230blackpinklinear-gradient(90deg, #000000 50%, #FE70BD 50%)3XL-4XL3XL/4XL50-5220-2224-2852-5452-5450-5256-5852-5450-52wlingerie3XL/4XLintlsize74.95830STOCK01200004002112588312417651222all
subcategory
stringall
supplier
number0
supplierreference
string21125X
tags
string
themes
stringluxe
totalvariations
string
type
stringdefault
unitprice
number74.9583
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 11.2 ms
Record Count: 5
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 = 'B71C293E-D21B-4C3E-B61FB74690D289B6' 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 = 'B71C293E-D21B-4C3E-B61FB74690D289B6' 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 = 'B71C293E-D21B-4C3E-B61FB74690D289B6' 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 = 'B71C293E-D21B-4C3E-B61FB74690D289B6' 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 = 'B71C293E-D21B-4C3E-B61FB74690D289B6' 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 = 'B71C293E-D21B-4C3E-B61FB74690D289B6' 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 = 'B71C293E-D21B-4C3E-B61FB74690D289B6'
and product_variations.isactive = 1
and product_sizes.id_size = 227
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 = 'B71C293E-D21B-4C3E-B61FB74690D289B6' 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 = 'B71C293E-D21B-4C3E-B61FB74690D289B6' 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 = 'B71C293E-D21B-4C3E-B61FB74690D289B6' 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 = 'B71C293E-D21B-4C3E-B61FB74690D289B6' 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 = 'B71C293E-D21B-4C3E-B61FB74690D289B6' 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 = 'B71C293E-D21B-4C3E-B61FB74690D289B6' 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 = 'B71C293E-D21B-4C3E-B61FB74690D289B6'
and product_variations.isactive = 1
and product_sizes.id_size = 229
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 = 'B71C293E-D21B-4C3E-B61FB74690D289B6' 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 = 'B71C293E-D21B-4C3E-B61FB74690D289B6' 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 = 'B71C293E-D21B-4C3E-B61FB74690D289B6' 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 = 'B71C293E-D21B-4C3E-B61FB74690D289B6' 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 = 'B71C293E-D21B-4C3E-B61FB74690D289B6' 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 = 'B71C293E-D21B-4C3E-B61FB74690D289B6' 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 = 'B71C293E-D21B-4C3E-B61FB74690D289B6'
and product_variations.isactive = 1
and product_sizes.id_size = 1275
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 = 'B71C293E-D21B-4C3E-B61FB74690D289B6' 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 = 'B71C293E-D21B-4C3E-B61FB74690D289B6' 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 = 'B71C293E-D21B-4C3E-B61FB74690D289B6' 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 = 'B71C293E-D21B-4C3E-B61FB74690D289B6' 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 = 'B71C293E-D21B-4C3E-B61FB74690D289B6' 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 = 'B71C293E-D21B-4C3E-B61FB74690D289B6' 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 = 'B71C293E-D21B-4C3E-B61FB74690D289B6'
and product_variations.isactive = 1
and product_sizes.id_size = 230
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 = 'B71C293E-D21B-4C3E-B61FB74690D289B6' 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 = 'B71C293E-D21B-4C3E-B61FB74690D289B6' 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 = 'B71C293E-D21B-4C3E-B61FB74690D289B6' 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 = 'B71C293E-D21B-4C3E-B61FB74690D289B6' 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 = 'B71C293E-D21B-4C3E-B61FB74690D289B6' 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 = 'B71C293E-D21B-4C3E-B61FB74690D289B6' 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 = 'B71C293E-D21B-4C3E-B61FB74690D289B6'
and product_variations.isactive = 1
and product_sizes.id_size = 510
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
1F2178FDD-C354-4310-A8F576190BBA053A1275blackpinklinear-gradient(90deg, #000000 50%, #FE70BD 50%)1XL-2XLXL/2XL+48-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerieXL/2XL+intlsize74.95830STOCK012000050021125883124176505222266074.9583all
2F355C714-2945-4C0B-AF3F47996AD7E2B7510blackpinklinear-gradient(90deg, #000000 50%, #FE70BD 50%)3XL-4XL3XL/4XL+54-5624-2628-3056-5856-5854-5660-6256-5854-56wlingerie3XL/4XL+intlsize74.95830STOCK012000040021125883124176512222266074.9583all
3384B5DE7-67D3-49D6-9CB61F6D5F28F69D227blackpinklinear-gradient(90deg, #000000 50%, #FE70BD 50%)XLXL42-4412-1416-1844-4644-4642-4448-5044-4642-44wlingerieXLintlsize74.95830STOCK012000000021125883124176499222266074.9583all
4F2178FDD-C354-4310-A8F576190BBA053A229blackpinklinear-gradient(90deg, #000000 50%, #FE70BD 50%)1XL-2XLXL/2XL46-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerieXL/2XLintlsize74.95830STOCK012000050021125883124176505222266074.9583all
5F355C714-2945-4C0B-AF3F47996AD7E2B7230blackpinklinear-gradient(90deg, #000000 50%, #FE70BD 50%)3XL-4XL3XL/4XL50-5220-2224-2852-5452-5450-5256-5852-5450-52wlingerie3XL/4XLintlsize74.95830STOCK012000040021125883124176512222266074.9583all
vatrate
number20
warehouse
string