Vedere le dimensioni
Hipster Delilah Brodé - Eleganza e audacia senza limiti
Doppio clic per ingrandire
SKU: SBGA7932
Hipster Delilah Brodé - Eleganza e audacia senza limiti
Stock:

L'hipster ricamato Delilah rivoluziona la seduzione con il suo pizzo trasparente finemente ricamato e l'audace design a più cinturini.

Senza cavallo e senza schienale, questo pezzo eccezionale rompe tutti i codici con un'eleganza sofisticata.

Punti di forza

  • Pizzo ricamato trasparente per un'eleganza raffinata
  • Design multistrato con cursori regolabili
  • Senza cavallo e senza schienale per la massima seduzione
  • Laschiena incrociata rivela le curve in modo discreto
  • La struttura delicata esalta la silhouette
  • Cinghie regolabili per un comfort personalizzato
Taglia:

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

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

Hipster taglia grande in pizzo ricamato multi-bra crotchless

Descrizione del prodotto

L'hipster ricamato Delilah incarna perfettamente l'arte di infrangere le regole mantenendo un'eleganza sofisticata. Il pizzo velato finemente ricamato crea un calcolato gioco di trasparenze che rivela con delicatezza.

Il design multi-strap con cursori regolabili si adatta perfettamente a tutte le forme del corpo, offrendo una vestibilità personalizzata e un comfort ottimale. La costruzione crotchless e senza schienale trasforma questo capo in un'opera d'arte seducente, mentre la schiena incrociata aggiunge una dimensione visiva sorprendente che esalta le curve generose.

L'hipster Delilah ridefinisce i codici della lingerie sexy con un approccio moderno e sofisticato.

Dettagli tecnici

  • Materiale: 100% poliestere (esclusi i bordi e l'elastico)
  • Stile: Hipster crotchless multi-strap
  • Dettagli: pizzo ricamato trasparente, design incrociato sulla schiena
  • Spalline: regolabili con cursori
  • Costruzione: senza cavallo, senza schienale
  • Finiture : Ricamo delicato, dettagli criss-cross

Dimensioni disponibili

Disponibile da 1X/2X- a 3X/4X

Colore disponibile

Nero

Guida alle taglie

Controllare la taglia giusta per voi

Internazionale
  • Petto
  • Dimensione
  • Fianchi
1X/2X-
  • 104-110
  • 86-91
  • 112-120
1X/2X
  • 112-118
  • 92-96
  • 122-128
3X/4X
  • 120-128
  • 98-102
  • 128-132

Istruzioni per la cura

  • Lavare a mano in acqua fredda per preservare il pizzo ricamato
  • Utilizzare un detersivo delicato senza agenti sbiancanti
  • Candeggiare senza cloro solo se necessario
  • Asciugare su una gruccia per mantenere la forma
  • Non stirare per evitare di danneggiare i ricami
  • Maneggiare delicatamente le bretelle durante il lavaggio

Consigli per l'uso

Per indossare il vostro Delilah hipster, regolate prima le spalline in base alla vostra forma del corpo utilizzando i cursori regolabili. Il design a più spalline consente una vestibilità personalizzata che garantisce un sostegno perfetto. La costruzione crotchless offre una libertà totale, mentre la schiena criss-cross crea un effetto visivo spettacolare.

Questo pezzo è ideale per quei momenti di intimità speciali in cui si vuole creare una sorpresa eclatante. Le delicate spalline devono essere trattate con delicatezza per preservarne la bellezza.

Consigli di stile

L'hipster Delilah è perfetto con le calze a rete per un look più audace, o con le spalline del reggiseno abbinate per creare un insieme sofisticato.

Per una serata speciale, abbinatelo a lingerie maschile maliziosa per giochi di coppia indimenticabili. Questo capo può essere indossato anche sotto un abito attillato per creare un effetto sorpresa quando ci si spoglia. Per i più audaci, completate il look con dei gioielli per il corpo che mettano in risalto i dettagli ricamati. L'hipster Delilah trasforma ogni momento di intimità in un sensuale spettacolo di alta moda.

To Top
Articoli
Totale articoli
Struct
Entries: 108
actions
Array
available
number0
brand
stringhouseofdesire
brandcode
stringhecs
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
stringHouse of Desire
breasts
stringna
careinstructions
string
categories
stringdivasboudoir.lingerie.briefs.openpanty
category
stringbriefs
categorygender
stringf
categorymediadatas
Struct
adult
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string287
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/lingerie/sexylingerie/openpanty.jpg
type
stringimg
width
string623
divasboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
fetishboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
latexboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
legsboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
lustboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
private
Struct
height
string1016
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/private/default.jpg
type
stringimg
width
string703
smboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
categorysizerange
stringauto
colorinfos
Query
Template: /system/api/product/colors.cfc:13
Execution Time: 0.701 ms
Record Count: 1
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_colors.color as recorduid, product_colors.type, product_colors.code, product_colors.color, product_colors.range, product_colors.hexvalue,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock
from product_colors
left outer join product_variations on product_colors.color = product_variations.color and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
where FIND_IN_SET(product_colors.color,'black') > 0
and product_variations.productuid = '7D140D94-3A6F-4DAE-A8BFAC87D635B499'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1blackcolorblakblackblack#00000022
colorrange
stringblack
colors
stringblack
colortype
stringcolor
comments
string
compositions
Struct
Entries: 13
coton
string
elastane
string
free
string
leather
string
lycra
string
metal
string
nylon
string
polyamide
string
polyester
string
polyurethane
string
silk
string
spandex
string
viscose
string
datecreated
Date Time (Europe/Paris)
{ts '2025-08-21 18:20:01'}
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
string
inpromo
number0
instockvariations
string
isactive
number1
iscustommade
number0
isdivasize
number0
isfirstprice
number0
isfixedprice
number0
ishot
number0
isnew
number0
isonline
number0
isoutletprice
number0
itemprice
number33.2917
itempromo
string
key
stringdelilah-string
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-09-12 16:16:19'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.653 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','it')
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('7d140d94-3a6f-4dae-a8bfac87d635b499',lcase(cart_actions.linkedproducts)) > 0 and cart_actions.linkedproducts is not null
)
id_actionbrandinglanguagenamecodetypeminimumOrdermaximumOrderminimumItemsmaximumItemsmaximumUseallowedItemsquotasusedCountlinkedproductslinkedthemeslinkedbrandslinkeditemparamsactiveFromactiveToisActive
linkedproducts
Query
Template: /system/api/products.cfc:1305
Execution Time: 1.36 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','it')
and product_categories.language in ('all','it')
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 <> 'SBGA7932'
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
string960
isprivate
string0
rating
stringall
src
string/photobank/products/hecs/sbga7932/culotte_ouverte_garnde_taille_dalilah_2.jpg
type
stringimg
width
string664
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string960
isprivate
string0
rating
stringall
src
string/photobank/products/hecs/sbga7932/culotte_ouverte_garnde_taille_dalilah.jpg
type
stringimg
width
string664
variations
Struct
colors
Struct
black
Struct
height
string960
isprivate
string0
rating
stringall
src
string/photobank/products/hecs/sbga7932/culotte_ouverte_garnde_taille_dalilah.jpg
type
stringimg
width
string664
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
mediagallery
stringproducts.houseofdesire.sbga7932
metadatas
Struct
darkboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
divasboudoir
Struct
de
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Handwäsche mit kaltem Wasser, um die bestickte Spitze zu erhalten</li> <li>Verwenden Sie ein mildes Waschmittel ohne Bleichmittel</li> <li>Chlorfreie Bleiche nur wenn nötig</li> <li>Trocknen auf dem Bügel, um die Form zu erhalten</li> <li>Nicht bügeln, um Schäden an der Stickerei zu vermeiden</li> <li>Träger beim Waschen vorsichtig handhaben</li> </ul>
description
string<p>Der bestickte Hipster Delilah verkörpert perfekt die Kunst, die Regeln zu brechen und gleichzeitig eine raffinierte Eleganz zu bewahren. Seine <strong>transparente, fein bestickte Spitze</strong> erzeugt ein kalkuliertes Spiel der Transparenz, das subtil enthüllt.</p> <p>Das Mehrträgerdesign mit verstellbaren Schiebern <strong>passt sich perfekt an jede Körperform</strong> an und bietet eine individuelle Passform und optimalen Tragekomfort. Die Konstruktion ohne Schritt und Rücken verwandelt dieses Stück in ein wahres Kunstwerk der Verführung, während das gekreuzte Rückenteil eine auffallende visuelle Dimension hinzufügt, die <strong>großzügige Kurven</strong> hervorhebt.</p> <p>Der Hipster Delilah definiert die Codes für sexy Dessous mit einem modernen und anspruchsvollen Ansatz neu.</p>
guid
stringhttps://dev.divasboudoir.com/de/offenes-hoschen-schwarz/sbga7932.htm
highlights
string<ul> <li><strong>Transparente, bestickte Spitze</strong> für raffinierte Eleganz</li> <li><strong>Mehrträger-Design</strong> mit verstellbaren Schiebern</li> <li><strong>Ohne Schritt und Rücken</strong> für ultimative Verführung</li> <li>Gekreuzter<strong>Rücken</strong>, der die Kurven subtil enthüllt</li> <li><strong>Zarte Konstruktion</strong>, die die Silhouette sublimiert</li> <li><strong>Verstellbare Träger</strong> für individuellen Komfort</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringHipster Delilah große Taille transparente bestickte Spitze, mehrträgerig ohne Schritt. Gewagtes überkreuztes Rückendesign. Kostenlose Lieferung ab 59€ bei Diva's Boudoir.
keywords
string
title
stringHipster Delilah Bestickt Multi-Träger Große Größen | Diva's Boudoir
seotitle
stringHipster große Taille bestickte Spitze Multiträger ohne Schritt
seouri
stringoffenes-hoschen-schwarz
specifications
string<ul> <li><strong>Material:</strong> 100% Polyester (exklusive Besätze und Gummibänder)</li> <li><strong>Stil:</strong> Mehrträger-Hipster ohne Zwickel</li> <li><strong>Details:</strong> Transparente, bestickte Spitze, gekreuztes Rückendesign</li> <li><strong>Träger:</strong> Verstellbar mit Schiebereglern<strong></strong> </li> <li><strong>Konstruktion:</strong> Ohne Schritt, ohne Rücken</li> <li><strong>Abschlüsse:</strong> Zarte Stickereien, gekreuzte Details</li> </ul>
stylingtips
string<p>Der Hipster Delilah lässt sich perfekt mit <a href="https://www.divasboudoir.com/de/strumpfe-in-grossen-grossen/"><strong>Netzstrümpfen</strong></a> kombinieren, um die verwegene Seite zu betonen, oder mit passenden <strong>Bruststraffern</strong>, um ein raffiniertes Ensemble zu schaffen.</p> <p>Für einen besonderen Abend kombinieren Sie es mit frecher <a href="https://www.divasboudoir.com/de/freche-herrenunterwasche/"><strong>Herrenunterwäsche</strong></a> für unvergessliche Paarspiele. Dieses Stück kann auch unter einem engen Kleid getragen werden, um beim Ausziehen für einen Überraschungseffekt zu sorgen. Für die Mutigsten: Ergänzen Sie es mit etwas Körperschmuck, der die bestickten Details unterstreicht. Hipster Delilah verwandelt jeden intimen Moment in ein sinnliches Haute-Couture-Spektakel.</p>
summary
string<p>Der bestickte Hipster Delilah revolutioniert die Verführung mit seiner transparenten, fein bestickten Spitze und dem gewagten Mehrträger-Design.</p> <p>Ohne Schritt und Rücken bricht dieses außergewöhnliche Stück mit raffinierter Eleganz alle Codes.</p>
title
stringHipster Delilah Bestickt - Grenzenlose Eleganz und Kühnheit
usageinstructions
string<p>Um Ihren Hipster Delilah anzuziehen, stellen Sie zunächst die Träger mit den verstellbaren Schiebern auf Ihre Körperform ein. Das <strong>Multiträger-Design</strong> ermöglicht eine individuelle Anpassung, die einen perfekten Sitz garantiert. Die zwickelfreie Konstruktion bietet absolute Freiheit, während das Kreuzband im Rücken einen spektakulären visuellen Effekt erzeugt.</p> <p>Dieses Stück lässt sich ideal für besondere intime Momente tragen, in denen Sie für eine atemberaubende Überraschung sorgen möchten. Die <strong>zarten Träger</strong> erfordern eine sanfte Handhabung, um ihre Schönheit zu bewahren.</p>
el
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Πλύνετε στο χέρι με κρύο νερό για να διατηρήσετε την κεντημένη δαντέλα</li> <li>Χρησιμοποιήστε ήπιο απορρυπαντικό χωρίς λευκαντικούς παράγοντες</li> <li>Μη χλωριούχο λευκαντικό μόνο εάν είναι απαραίτητο</li> <li>Στεγνώστε σε κρεμάστρα για να διατηρήσετε το σχήμα σας</li> <li>Μην σιδερώνετε για να μην καταστραφεί το κέντημα</li> <li>Να χειρίζεστε απαλά τις τιράντες κατά το πλύσιμο</li> </ul>
description
string<p>Το κεντημένο hipster Delilah ενσαρκώνει τέλεια την τέχνη του να παραβιάζεις τους κανόνες, διατηρώντας ταυτόχρονα μια εκλεπτυσμένη κομψότητα. Η <strong>λεπτότατα κεντημένη διάφανη δαντέλα</strong> του δημιουργεί ένα υπολογισμένο παιχνίδι διαφάνειας που αποκαλύπτει με λεπτότητα.</p> <p>Ο σχεδιασμός με τις πολλαπλές ζώνες με ρυθμιζόμενα ρυθμιστικά <strong>προσαρμόζεται τέλεια σε όλα τα σχήματα σώματος</strong>, προσφέροντας εξατομικευμένη εφαρμογή και βέλτιστη άνεση. Η κατασκευή χωρίς καβάλο, χωρίς πλάτη, μετατρέπει αυτό το κομμάτι σε ένα έργο σαγηνευτικής τέχνης, ενώ η σταυρωτή πλάτη προσθέτει μια εντυπωσιακή οπτική διάσταση που <strong>αναδεικνύει τις γενναιόδωρες καμπύλες</strong>.</p> <p>Το hipster Delilah επαναπροσδιορίζει τους κώδικες των σέξι εσωρούχων με μια μοντέρνα, εκλεπτυσμένη προσέγγιση.</p>
guid
stringhttps://dev.divasboudoir.com/el/anoichta-eswroycha-mayro/sbga7932.htm
highlights
string<ul> <li><strong>Διαφανής κεντημένη δαντέλα</strong> για εκλεπτυσμένη κομψότητα</li> <li><strong>Σχεδιασμός πολλαπλών λουριών</strong> με ρυθμιζόμενα ρυθμιστικά</li> <li><strong>Χωρίς καβάλο και χωρίς πλάτη</strong> για απόλυτη αποπλάνηση</li> <li><strong>Η σταυρωτή πλάτη</strong> αποκαλύπτει διακριτικά τις καμπύλες</li> <li><strong>Η λεπτή κατασκευή</strong> ενισχύει τη σιλουέτα</li> <li><strong>Ρυθμιζόμενοι ιμάντες</strong> για εξατομικευμένη άνεση</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringHipster Delilah μεγάλο μέγεθος με κεντημένη δαντέλα, πολλαπλών ιμάντων χωρίς καβάλο. Τολμηρό σχέδιο με σταυρό στην πλάτη. Δωρεάν παράδοση από €59 στο Diva's Boudoir.
keywords
string
title
stringHipster Delilah Κεντημένο Multi-Straps Large | Diva's Boudoir
seotitle
stringHipster μεγάλη κεντημένη δαντέλα multi-bra crotchless
seouri
stringanoichta-eswroycha-mayro
specifications
string<ul> <li><strong>Υλικό:</strong> 100% πολυεστέρας (με αποκλειστική επένδυση και λάστιχο)</li> <li><strong>Στυλ:</strong> Χιπστερ χωρίς καβάλο με πολλαπλούς ιμάντες</li> <li><strong>Λεπτομέρειες</strong>: Διαφανής κεντημένη δαντέλα, σχέδιο με σταυρό στην πλάτη</li> <li><strong>Λουράκια :</strong> Ρυθμιζόμενα με ρυθμιστές</li> <li><strong>Κατασκευή:</strong> Χωρίς καβάλο, χωρίς πλάτη</li> <li><strong>Τελειώματα: :</strong> Λεπτό κέντημα, λεπτομέρειες με σταυρό χιαστί</li> </ul>
stylingtips
string<p>Το hipster Delilah ταιριάζει τέλεια με <a href="https://www.divasboudoir.com/el/kaltses-megaloy-megethoys/"><strong>διχτυωτές κάλτσες</strong></a> για να τονίσει την τολμηρή πλευρά του, ή με ασορτί <strong>τιράντες σουτιέν</strong> για να δημιουργήσει ένα εκλεπτυσμένο σύνολο.</p> <p>Για μια ξεχωριστή βραδινή έξοδο, συνδυάστε το με άτακτα <a href="https://www.divasboudoir.com/el/atakta-andrika-eswroycha/"><strong>ανδρικά εσώρουχα</strong></a> για αξέχαστα παιχνίδια ζευγαριού. Αυτό το κομμάτι μπορεί επίσης να φορεθεί κάτω από ένα στενό φόρεμα για να δημιουργήσει ένα εφέ έκπληξης κατά το γδύσιμο. Για τις πιο τολμηρές, ολοκληρώστε την εμφάνιση με μερικά κοσμήματα σώματος για να αναδείξετε τις κεντημένες λεπτομέρειες. Το hipster Delilah μετατρέπει κάθε προσωπική στιγμή σε μια αισθησιακή επίδειξη υψηλής ραπτικής.</p>
summary
string<p>Το κεντημένο hipster Delilah φέρνει επανάσταση στην αποπλάνηση με τη λεπτότατα κεντημένη διαφανή δαντέλα και το τολμηρό σχέδιο με τις πολλαπλές λουρίδες.</p> <p>Χωρίς καβάλο και χωρίς πλάτη, αυτό το εξαιρετικό κομμάτι σπάει όλους τους κώδικες με εκλεπτυσμένη κομψότητα.</p>
title
stringHipster Delilah Brodé - Απεριόριστη κομψότητα και τόλμη
usageinstructions
string<p>Για να φορέσετε το Delilah hipster σας, προσαρμόστε πρώτα τους ιμάντες στο σχήμα του σώματός σας χρησιμοποιώντας τα ρυθμιζόμενα ρυθμιστικά. Ο <strong>σχεδιασμός με πολλαπλούς ιμάντες</strong> επιτρέπει μια εξατομικευμένη εφαρμογή που εγγυάται τέλεια στήριξη. Η κατασκευή χωρίς καβάλο προσφέρει απόλυτη ελευθερία, ενώ η σταυρωτή πλάτη δημιουργεί ένα εντυπωσιακό οπτικό αποτέλεσμα.</p> <p>Αυτό το κομμάτι είναι ιδανικό για τις ιδιαίτερες προσωπικές στιγμές που θέλετε να δημιουργήσετε μια εντυπωσιακή έκπληξη. Οι <strong>ευαίσθητοι ιμάντες</strong> απαιτούν απαλό χειρισμό για να διατηρήσουν την ομορφιά τους.</p>
en
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Hand wash in cold water to preserve embroidered lace</li> <li>Use a mild detergent without bleaching agents</li> <li>Non-chlorine bleach only if necessary</li> <li>Dry on a hanger to maintain shape</li> <li>Do not iron to avoid damaging embroidery</li> <li>Handle straps with care when washing</li> </ul>
description
string<p>The embroidered Delilah hipster perfectly embodies the art of breaking the rules while maintaining sophisticated elegance. Its <strong>finely embroidered transparent lace</strong> creates a calculated play of transparency that reveals with subtlety.</p> <p>The multi-strap design with adjustable sliders <strong>adapts perfectly to all morphologies</strong>, offering a personalized fit and optimal comfort. The crotchless, backless construction transforms this piece into a true work of seductive art, while the cross-back adds a striking visual dimension that <strong>sublimates generous curves</strong>.</p> <p>The hipster Delilah redefines the codes of sexy lingerie with a modern, sophisticated approach.</p>
guid
stringhttps://dev.divasboudoir.com/en/open-panties-black/sbga7932.htm
highlights
string<ul> <li><strong>Sheer embroidered lace</strong> for refined elegance</li> <li><strong>Multi-strap design</strong> with adjustable sliders</li> <li><strong>Crotchless and backless</strong> for ultimate seduction</li> <li><strong>Cross-over back</strong> subtly reveals curves</li> <li><strong>Delicate construction</strong> enhances the silhouette</li> <li><strong>Adjustable straps</strong> for personalized comfort</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringHipster Delilah plus size sheer embroidered lace, multi-strap crotchless. Bold cross-back design. Free delivery from 59€ at Diva's Boudoir.
keywords
string
title
stringHipster Delilah Embroidered Multi-Straps Plus Size | Diva's Boudoir
seotitle
stringHipster plus size lace embroidered multi-strap crotchless
seouri
stringopen-panties-black
specifications
string<ul> <li><strong>Material:</strong> 100% Polyester (exclusive trim and elastic)</li> <li><strong>Style:</strong> Crotchless multi-strap hipster</li> <li><strong>Details:</strong> Sheer embroidered lace, cross-back design</li> <li><strong>Straps:</strong> Adjustable with sliders</li> <li><strong>Construction:</strong> Crotchless, backless</li> <li><strong>Finishes:</strong> Delicate embroidery, criss-cross details</li> </ul>
stylingtips
string<p>The Delilah hipster pairs perfectly with <a href="https://www.divasboudoir.com/en/socks-large-size/"><strong>fishnet stockings</strong></a> to accentuate the daring side, or with matching <strong>bra straps</strong> to create a sophisticated ensemble.</p> <p>For a special evening, pair it with naughty <a href="https://www.divasboudoir.com/en/naughty-mens-lingerie/"><strong>men's lingerie</strong></a> for unforgettable couple's games. This piece can also be worn under a tight dress to create a surprise effect when undressing. For the more daring, complete the look with some body jewelry to highlight the embroidered details. The hipster Delilah transforms every intimate moment into a sensual haute couture spectacle.</p>
summary
string<p>The embroidered Delilah hipster revolutionizes seduction with its finely embroidered sheer lace and bold multi-strap design.</p> <p>Crotchless and backless, this exceptional piece breaks all codes with sophisticated elegance.</p>
title
stringHipster Delilah Brodé - Boundless elegance and boldness
usageinstructions
string<p>To put on your Delilah hipster, first adjust the straps to your body shape with the adjustable sliders. The <strong>multi-strap design</strong> enables a personalized fit that guarantees perfect support. The crotchless construction offers total freedom, while the cross-back creates a spectacular visual effect.</p> <p>This piece is ideal for those special intimate moments when you want to create a striking surprise. The <strong>delicate straps</strong> require gentle handling to preserve their beauty.</p>
es
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavar a mano en agua fría para preservar el encaje bordado</li> <li>Utilice un detergente suave sin blanqueantes</li> <li>Blanqueador sin cloro sólo si es necesario</li> <li>Secar en una percha para mantener la forma</li> <li>No planchar para no dañar el bordado</li> <li>Manipule los tirantes con cuidado al lavarlos</li> </ul>
description
string<p>El hipster Delilah bordado encarna a la perfección el arte de romper las reglas conservando una sofisticada elegancia. Su <strong>fino encaje bordado</strong> crea un calculado juego de transparencias que revela con sutileza.</p> <p>El diseño de tirantes múltiples con deslizadores ajustables <strong>se adapta perfectamente a todas las formas del cuerpo</strong>, ofreciendo un ajuste personalizado y una comodidad óptima. La construcción sin entrepierna y sin espalda convierte esta pieza en una obra de arte seductora, mientras que la espalda entrecruzada añade una llamativa dimensión visual que <strong>realza las curvas generosas</strong>.</p> <p>El hipster Delilah redefine los códigos de la lencería sexy con un enfoque moderno y sofisticado.</p>
guid
stringhttps://dev.divasboudoir.com/es/bragas-abiertas-negro/sbga7932.htm
highlights
string<ul> <li><strong>Encaje bordado transparente</strong> para una elegancia refinada</li> <li><strong>Diseño de tirantes múltiples</strong> con deslizadores ajustables</li> <li><strong>Sin entrepierna ni espalda</strong> para la máxima seducción</li> <li><strong>La espalda entrecruzada</strong> revela sutilmente las curvas</li> <li><strong>Su delicada confección</strong> realza la silueta</li> <li><strong>Tirantes ajustables</strong> para un confort personalizado</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringHipster Delilah talla grande de encaje bordado transparente, sin entrepierna con múltiples tiras. Atrevido diseño cruzado en la espalda. Envío gratuito a partir de 59 € en Diva's Boudoir.
keywords
string
title
stringHipster Delilah bordado talla grande | Diva's Boudoir
seotitle
stringHipster talla grande multibra de encaje bordado sin entrepierna
seouri
stringbragas-abiertas-negro
specifications
string<ul> <li><strong>Material:</strong> 100% poliéster (ribete y elástico exclusivos)</li> <li><strong>Estilo:</strong> Hipster de tirantes múltiples sin entrepierna</li> <li><strong>Detalles:</strong> Encaje bordado transparente, diseño cruzado en la espalda</li> <li><strong>Tirantes:</strong> Ajustables con deslizadores</li> <li><strong>Construcción:</strong> Sin entrepierna, sin espalda</li> <li><strong>Acabados :</strong> Delicados bordados, detalles entrecruzados</li> </ul>
stylingtips
string<p>El hipster Delilah es perfecto con <a href="https://www.divasboudoir.com/es/medias-grandes/"><strong>medias de rejilla</strong></a> para un look más atrevido, o con <strong>tirantes de sujetador</strong> a juego para crear un conjunto sofisticado.</p> <p>Para una salida nocturna especial, combínalo con <a href="https://www.divasboudoir.com/es/lenceria-masculina-atrevida/"><strong>lencería masculina</strong></a> traviesa para unos juegos de pareja inolvidables. Esta pieza también puede llevarse bajo un vestido ajustado para crear un efecto sorpresa al desvestirse. Para las más atrevidas, completa el look con alguna joya corporal para resaltar los detalles bordados. El hipster Delilah transforma cada momento íntimo en un sensual espectáculo de alta costura.</p>
summary
string<p>El hipster Delilah bordado revoluciona la seducción con su encaje transparente finamente bordado y su atrevido diseño multitiras.</p> <p>Sin entrepierna y sin espalda, esta pieza excepcional rompe todos los códigos con una elegancia sofisticada.</p>
title
stringHipster Delilah Brodé - Elegancia y atrevimiento sin límites
usageinstructions
string<p>Para ponerte la braguita Delilah, primero ajusta los tirantes a la forma de tu cuerpo utilizando los deslizadores ajustables. El <strong>diseño de tirantes múltiples</strong> permite un ajuste personalizado que garantiza una sujeción perfecta. La construcción sin entrepierna ofrece una libertad total, mientras que la espalda entrecruzada crea un efecto visual espectacular.</p> <p>Esta pieza es ideal para esos momentos íntimos especiales en los que desea crear una impactante sorpresa. <strong>Los delicados tirantes</strong> requieren una manipulación suave para preservar su belleza.</p>
fr
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavage &agrave; la main &agrave; l'eau froide pour pr&eacute;server la dentelle brod&eacute;e</li> <li>Utiliser une lessive douce sans agents blanchissants</li> <li>Javel non chlor&eacute;e uniquement si n&eacute;cessaire</li> <li>S&eacute;chage sur cintre pour maintenir la forme</li> <li>Ne pas repasser pour &eacute;viter d'endommager les broderies</li> <li>Manipuler d&eacute;licatement les bretelles lors du lavage</li> </ul>
description
string<p>L'hipster Delilah brod&eacute; incarne parfaitement l'art de briser les r&egrave;gles tout en conservant une &eacute;l&eacute;gance sophistiqu&eacute;e. Sa <strong>dentelle transparente finement brod&eacute;e</strong> cr&eacute;e un jeu de transparence calcul&eacute; qui r&eacute;v&egrave;le avec subtilit&eacute;.</p> <p>Le design multi-bretelles avec curseurs r&eacute;glables&nbsp;<strong>s'adapte parfaitement &agrave; toutes les morphologies</strong>, offrant un ajustement personnalis&eacute; et un confort optimal. La construction sans entrejambe et sans dos transforme cette pi&egrave;ce en v&eacute;ritable &oelig;uvre d'art de la s&eacute;duction, tandis que le crois&eacute; dans le dos ajoute une dimension visuelle saisissante qui <strong>sublime les courbes g&eacute;n&eacute;reuses</strong>.&nbsp;</p> <p>Le hipster Delilah red&eacute;finit les codes de la lingerie sexy avec une approche moderne et sophistiqu&eacute;e.</p>
guid
stringhttps://dev.divasboudoir.com/fr/hipster-dentelle-brodee-multi-bretelles-grande-taille/sbga7932.htm
highlights
string<ul> <li><strong>Dentelle brod&eacute;e transparente</strong> pour une &eacute;l&eacute;gance raffin&eacute;e</li> <li><strong>Design multi-bretelles</strong> avec curseurs r&eacute;glables</li> <li><strong>Sans entrejambe et sans dos</strong> pour une s&eacute;duction ultime</li> <li><strong>Crois&eacute; dans le dos</strong> qui r&eacute;v&egrave;le subtilement les courbes</li> <li><strong>Construction d&eacute;licate</strong> qui sublime la silhouette</li> <li><strong>Bretelles ajustables</strong> pour un confort personnalis&eacute;</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringHipster Delilah grande taille dentelle brodée transparente, multi-bretelles sans entrejambe. Design croisé dos audacieux. Livraison gratuite dès 59€ chez Diva's Boudoir.
keywords
string
title
stringHipster Delilah Brodé Multi-Bretelles Grande Taille | Diva's Boudoir
seotitle
stringHipster grande taille dentelle brodée multi-bretelles sans entrejambe
seouri
stringhipster-dentelle-brodee-multi-bretelles-grande-taille
specifications
string<ul> <li><strong>Mati&egrave;re :</strong> 100% Polyester (exclusif des garnitures et &eacute;lastiques)</li> <li><strong>Style :</strong> Hipster multi-bretelles sans entrejambe</li> <li><strong>D&eacute;tails :</strong> Dentelle brod&eacute;e transparente, design crois&eacute; dos</li> <li><strong>Bretelles :</strong> R&eacute;glables avec curseurs</li> <li><strong>Construction :</strong> Sans entrejambe, sans dos</li> <li><strong>Finitions :</strong> Broderies d&eacute;licates, d&eacute;tails crois&eacute;s</li> </ul>
stylingtips
string<p>L'hipster Delilah se marie parfaitement avec des <a href="https://www.divasboudoir.com/fr/bas-grande-taille/"><strong>bas r&eacute;sille</strong></a> pour accentuer le c&ocirc;t&eacute; audacieux, ou avec des <strong>redresse-seins</strong> assortis pour cr&eacute;er un ensemble sophistiqu&eacute;.</p> <p>Pour une soir&eacute;e sp&eacute;ciale, associez-le &agrave; une&nbsp;<a href="https://www.divasboudoir.com/fr/lingerie-homme-coquine/"><strong>lingerie pour homme</strong></a> coquine pour des jeux de couple inoubliables. Cette pi&egrave;ce peut aussi se porter sous une robe moulante pour cr&eacute;er un effet de surprise lors du d&eacute;shabillage. Pour les plus audacieuses, compl&eacute;tez avec quelques bijoux de corps qui souligneront les d&eacute;tails brod&eacute;s. L'hipster Delilah transforme chaque moment intime en spectacle de haute couture sensuelle.</p>
summary
string<p>L'hipster Delilah brod&eacute; r&eacute;volutionne la s&eacute;duction avec sa dentelle transparente finement brod&eacute;e et son design multi-bretelles audacieux.</p> <p>Sans entrejambe et sans dos, cette pi&egrave;ce d'exception brise tous les codes avec une &eacute;l&eacute;gance sophistiqu&eacute;e.</p>
title
stringHipster Delilah Brodé - Élégance et audace sans limites
usageinstructions
string<p>Pour enfiler votre hipster Delilah, ajustez d'abord les bretelles selon votre morphologie gr&acirc;ce aux curseurs r&eacute;glables. Le <strong>design multi-bretelles</strong> permet un ajustement personnalis&eacute; qui garantit un maintien parfait. La construction sans entrejambe offre une libert&eacute; totale, tandis que le crois&eacute; dans le dos cr&eacute;e un effet visuel spectaculaire.</p> <p>Cette pi&egrave;ce se porte id&eacute;alement pour des moments intimes sp&eacute;ciaux o&ugrave; vous souhaitez cr&eacute;er une surprise saisissante. Les&nbsp;<strong>bretelles d&eacute;licates</strong> n&eacute;cessitent une manipulation douce pour pr&eacute;server leur beaut&eacute;.</p>
it
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavare a mano in acqua fredda per preservare il pizzo ricamato</li> <li>Utilizzare un detersivo delicato senza agenti sbiancanti</li> <li>Candeggiare senza cloro solo se necessario</li> <li>Asciugare su una gruccia per mantenere la forma</li> <li>Non stirare per evitare di danneggiare i ricami</li> <li>Maneggiare delicatamente le bretelle durante il lavaggio</li> </ul>
description
string<p>L'hipster ricamato Delilah incarna perfettamente l'arte di infrangere le regole mantenendo un'eleganza sofisticata. Il <strong>pizzo velato finemente ricamato</strong> crea un calcolato gioco di trasparenze che rivela con delicatezza.</p> <p>Il design multi-strap con cursori regolabili <strong>si adatta perfettamente a tutte le forme del corpo</strong>, offrendo una vestibilità personalizzata e un comfort ottimale. La costruzione crotchless e senza schienale trasforma questo capo in un'opera d'arte seducente, mentre la schiena incrociata aggiunge una dimensione visiva sorprendente che <strong>esalta le curve generose</strong>.</p> <p>L'hipster Delilah ridefinisce i codici della lingerie sexy con un approccio moderno e sofisticato.</p>
guid
stringhttps://dev.divasboudoir.com/it/mutandine-aperte-nero/sbga7932.htm
highlights
string<ul> <li><strong>Pizzo ricamato trasparente</strong> per un'eleganza raffinata</li> <li><strong>Design multistrato</strong> con cursori regolabili</li> <li><strong>Senza cavallo e senza schienale</strong> per la massima seduzione</li> <li>La<strong>schiena incrociata</strong> rivela le curve in modo discreto</li> <li><strong>La struttura delicata</strong> esalta la silhouette</li> <li><strong>Cinghie regolabili</strong> per un comfort personalizzato</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringHipster Delilah di grande taglia in pizzo velato ricamato, multi strap crotchless. Audace design incrociato sulla schiena. Consegna gratuita a partire da 59 € su Diva's Boudoir.
keywords
string
title
stringHipster Delilah ricamato Taglia grande | Diva's Boudoir
seotitle
stringHipster taglia grande in pizzo ricamato multi-bra crotchless
seouri
stringmutandine-aperte-nero
specifications
string<ul> <li><strong>Materiale:</strong> 100% poliestere (esclusi i bordi e l'elastico)</li> <li><strong>Stile:</strong> Hipster crotchless multi-strap</li> <li><strong>Dettagli:</strong> pizzo ricamato trasparente, design incrociato sulla schiena</li> <li><strong>Spalline:</strong> regolabili con cursori</li> <li><strong>Costruzione:</strong> senza cavallo, senza schienale</li> <li><strong>Finiture :</strong> Ricamo delicato, dettagli criss-cross</li> </ul>
stylingtips
string<p>L'hipster Delilah è perfetto con le <a href="https://www.divasboudoir.com/it/calze-di-grandi-dimensioni/"><strong>calze a rete</strong></a> per un look più audace, o con le <strong>spalline</strong> del <strong>reggiseno</strong> abbinate per creare un insieme sofisticato.</p> <p>Per una serata speciale, abbinatelo a <a href="https://www.divasboudoir.com/it/lingerie-da-uomo-birichina/"><strong>lingerie maschile</strong></a> maliziosa per giochi di coppia indimenticabili. Questo capo può essere indossato anche sotto un abito attillato per creare un effetto sorpresa quando ci si spoglia. Per i più audaci, completate il look con dei gioielli per il corpo che mettano in risalto i dettagli ricamati. L'hipster Delilah trasforma ogni momento di intimità in un sensuale spettacolo di alta moda.</p>
summary
string<p>L'hipster ricamato Delilah rivoluziona la seduzione con il suo pizzo trasparente finemente ricamato e l'audace design a più cinturini.</p> <p>Senza cavallo e senza schienale, questo pezzo eccezionale rompe tutti i codici con un'eleganza sofisticata.</p>
title
stringHipster Delilah Brodé - Eleganza e audacia senza limiti
usageinstructions
string<p>Per indossare il vostro Delilah hipster, regolate prima le spalline in base alla vostra forma del corpo utilizzando i cursori regolabili. Il <strong>design a più spalline</strong> consente una vestibilità personalizzata che garantisce un sostegno perfetto. La costruzione crotchless offre una libertà totale, mentre la schiena criss-cross crea un effetto visivo spettacolare.</p> <p>Questo pezzo è ideale per quei momenti di intimità speciali in cui si vuole creare una sorpresa eclatante. Le <strong>delicate spalline</strong> devono essere trattate con delicatezza per preservarne la bellezza.</p>
nl
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Handwas in koud water om het geborduurde kant te behouden</li> <li>Gebruik een mild wasmiddel zonder bleekmiddelen</li> <li>Niet-chloorbleekmiddel alleen indien nodig</li> <li>Drogen op een kleerhanger om de vorm te behouden</li> <li>Niet strijken om beschadiging van het borduurwerk te voorkomen</li> <li>Beugels voorzichtig behandelen tijdens het wassen</li> </ul>
description
string<p>De geborduurde Delilah hipster belichaamt perfect de kunst om de regels te breken en toch een verfijnde elegantie te behouden. Het <strong>fijn geborduurde transparante kant</strong> creëert een berekend spel van transparantie dat subtiel onthult.</p> <p>Het ontwerp met meerdere bandjes en verstelbare schuifjes <strong>past zich perfect aan alle lichaamsvormen</strong> aan en biedt een persoonlijke pasvorm en optimaal comfort. De kruisloze, rugloze constructie maakt van dit stuk een verleidelijk kunstwerk, terwijl de gekruiste achterkant een opvallende visuele dimensie toevoegt die <strong>royale rondingen benadrukt</strong>.</p> <p>De Delilah hipster herdefinieert de codes van sexy lingerie met een moderne, geraffineerde benadering.</p>
guid
stringhttps://dev.divasboudoir.com/nl/open-slipjes-zwart/sbga7932.htm
highlights
string<ul> <li><strong>Geborduurd kant</strong> voor verfijnde elegantie</li> <li><strong>Ontwerp met meerdere bandjes</strong> en verstelbare schuivers</li> <li><strong>Kruisloos en rugloos</strong> voor ultieme verleiding</li> <li><strong>De kriskras rug</strong> onthult subtiel rondingen</li> <li><strong>Delicate constructie</strong> verbetert het silhouet</li> <li><strong>Verstelbare bandjes</strong> voor persoonlijk comfort</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringHipster Delilah grote maat van geborduurd kant, kruisloos met meerdere bandjes. Gedurfd kriskras rugontwerp. Gratis bezorging vanaf €59 bij Diva's Boudoir.
keywords
string
title
stringHipster Delilah Geborduurde Grote Maat | Diva's Boudoir
seotitle
stringHipster grote maat geborduurde kanten multibh kruisloos
seouri
stringopen-slipjes-zwart
specifications
string<ul> <li><strong>Materiaal:</strong> 100% Polyester (exclusief bies en elastiek)</li> <li><strong>Stijl:</strong> Kruisloze hipster met meerdere bandjes</li> <li><strong>Details :</strong> geborduurd kant, kriskras rugontwerp</li> <li><strong>Bandjes :</strong> Verstelbaar met schuifjes</li> <li><strong>Constructie:</strong> kruisloos, rugloos</li> <li><strong>Afwerkingen :</strong> Delicaat borduurwerk, kriskras details</li> </ul>
stylingtips
string<p>De Delilah hipster is perfect met <a href="https://www.divasboudoir.com/nl/grote-maat-kousen/"><strong>netkousen</strong></a> voor een gewaagdere look, of met bijpassende <strong>bh-bandjes</strong> voor een geraffineerd ensemble.</p> <p>Voor een speciaal avondje uit combineer je het met ondeugende <a href="https://www.divasboudoir.com/nl/ondeugende-mannenlingerie/"><strong>mannenlingerie</strong></a> voor onvergetelijke stoeipartijtjes. Dit stuk kan ook onder een strakke jurk gedragen worden voor een verrassingseffect bij het uitkleden. Als je meer lef hebt, maak je de look af met wat lichaamssieraden om de geborduurde details te benadrukken. De hipster Delilah verandert elk intiem moment in een sensuele show van haute couture.</p>
summary
string<p>De geborduurde Delilah hipster zorgt voor een revolutie in de verleiding met zijn fijn geborduurde transparante kant en gedurfde ontwerp met meerdere bandjes.</p> <p>Zonder kruis en zonder rug breekt dit uitzonderlijke stuk alle codes met geraffineerde elegantie.</p>
title
stringHipster Delilah Brodé - Onbeperkte elegantie en brutaliteit
usageinstructions
string<p>Om je Delilah hipster aan te trekken, pas je eerst de bandjes aan je lichaamsvorm aan met de verstelbare schuifjes. Het <strong>ontwerp met meerdere bandjes</strong> zorgt voor een persoonlijke pasvorm die perfecte ondersteuning garandeert. De kruisloze constructie biedt totale vrijheid, terwijl de kriskras achterkant een spectaculair visueel effect creëert.</p> <p>Dit stuk is ideaal voor die speciale intieme momenten wanneer je voor een opvallende verrassing wilt zorgen. De <strong>delicate bandjes</strong> moeten voorzichtig worden behandeld om hun schoonheid te behouden.</p>
pt
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavar à mão em água fria para preservar a renda bordada</li> <li>Utilizar um detergente suave sem agentes branqueadores</li> <li>Lixívia sem cloro apenas se necessário</li> <li>Secar num cabide para manter a forma</li> <li>Não passar a ferro para não danificar o bordado</li> <li>Manusear os suspensórios com cuidado durante a lavagem</li> </ul>
description
string<p>O hipster Delilah bordado encarna na perfeição a arte de quebrar as regras, mantendo uma elegância sofisticada. A sua <strong>renda pura finamente bordada</strong> cria um jogo calculado de transparência que revela com subtileza.</p> <p>O design de várias tiras com corrediças ajustáveis <strong>adapta-se perfeitamente a todas as formas do corpo</strong>, oferecendo um ajuste personalizado e um conforto ótimo. A construção sem virilhas e sem costas transforma esta peça numa obra de arte sedutora, enquanto as costas cruzadas acrescentam uma dimensão visual marcante que <strong>realça as curvas generosas</strong>.</p> <p>O hipster Delilah redefine os códigos da lingerie sexy com uma abordagem moderna e sofisticada.</p>
guid
stringhttps://dev.divasboudoir.com/pt/calcinhas-abertas-preto/sbga7932.htm
highlights
string<ul> <li><strong>Renda bordada transparente</strong> para uma elegância requintada</li> <li><strong>Design</strong> com<strong>várias tiras</strong> e corrediças ajustáveis</li> <li><strong>Sem entrepernas e sem costas</strong> para a máxima sedução</li> <li><strong>As costas cruzadas</strong> revelam subtilmente as curvas</li> <li><strong>A construção delicada</strong> realça a silhueta</li> <li><strong>Alças ajustáveis</strong> para um conforto personalizado</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringHipster Delilah tamanho grande em renda bordada, com várias alças e sem pernas. Design ousado e cruzado nas costas. Entrega gratuita a partir de 59 € na Diva's Boudoir.
keywords
string
title
stringHipster Delilah Bordado Multi-Straps Grande | Diva's Boudoir
seotitle
stringHipster grande de renda bordada multi-sutiã sem alças
seouri
stringcalcinhas-abertas-preto
specifications
string<ul> <li><strong>Material:</strong> 100% poliéster (exclusivamente guarnição e elástico)</li> <li><strong>Estilo:</strong> Crotchless multi-strap hipster</li> <li><strong>Detalhes :</strong> Renda bordada transparente, design cruzado nas costas</li> <li><strong>Alças:</strong> Ajustáveis com corrediças</li> <li><strong>Construção:</strong> Sem entrepernas, sem costas</li> <li><strong>Acabamentos :</strong> Bordados delicados, pormenores cruzados</li> </ul>
stylingtips
string<p>O hipster Delilah combina perfeitamente com <a href="https://www.divasboudoir.com/pt/meias-de-tamanho-grande/"><strong>meias de rede</strong></a> para acentuar o lado ousado, ou com <strong>alças de sutiã</strong> a condizer para criar um conjunto sofisticado.</p> <p>Para uma saída nocturna especial, combine-o com <a href="https://www.divasboudoir.com/pt/lingerie-masculina-atrevida/"><strong>lingerie masculina</strong></a> atrevida para jogos de casal inesquecíveis. Esta peça também pode ser usada por baixo de um vestido justo para criar um efeito surpresa ao despir-se. Para as mais ousadas, completar o look com algumas jóias de corpo para realçar os detalhes bordados. A Delilah hipster transforma cada momento íntimo num espetáculo sensual de alta costura.</p>
summary
string<p>O hipster Delilah bordado revoluciona a sedução com a sua renda transparente finamente bordada e o seu design ousado com várias alças.</p> <p>Sem entrepernas e sem costas, esta peça excecional quebra todos os códigos com uma elegância sofisticada.</p>
title
stringHipster Delilah Brodé - Elegância e ousadia sem limites
usageinstructions
string<p>Para vestir o seu hipster Delilah, comece por ajustar as alças à forma do seu corpo utilizando as corrediças ajustáveis. O <strong>design com várias alças</strong> permite um ajuste personalizado que garante um apoio perfeito. A construção sem entrepernas oferece total liberdade, enquanto as costas cruzadas criam um efeito visual espetacular.</p> <p>Esta peça é ideal para aqueles momentos íntimos especiais em que se pretende criar uma surpresa marcante. As <strong>alças delicadas</strong> requerem um manuseamento suave para preservar a sua beleza.</p>
fetishboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
latexboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
legsboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
lustboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
smboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
name
stringdelilah string
netweight
string
nextshipment
stringtoday
ordered
number0
orderidx
number0
origin
string
originalsize
string
packaging
string
productshipment
stringauto
productuid
string7D140D94-3A6F-4DAE-A8BFAC87D635B499
promountil
string
rating
stringnone
recorduid
string7D140D94-3A6F-4DAE-A8BFAC87D635B499
reference
stringSBGA7932
related
string
reserved
string
returned
number0
returnsallowed
number1
section
stringlingerie
shipment
string5to7days
showbrand
number0
sizeinfos
Query
Template: /system/api/product/sizes.cfc:20
Execution Time: 1.38 ms
Record Count: 3
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_sizes.id_size as recorduid, if(intlsize <> '',intlsize,eusize) as size, if(intlsize <> '','intlsize','eusize') as sizetype,
product_variations.color,
if(product_sizes.sizegroup = 'bra',
if(intlsize <> '', cast(intlsize as SIGNED ), cast(eusize as SIGNED ))
,
SUBSTRING_INDEX(intlsize,'-',1)
) as param1,
if(product_sizes.sizegroup = 'bra',
if(intlsize <> '',
MID(intlsize,length(cast(intlsize as SIGNED ))+1,length(intlsize)),
MID(eusize,length(cast(eusize as SIGNED ))+1,length(eusize))
)
,
SUBSTRING_INDEX(intlsize,'-',-1)
) as param2,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as available,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
999999,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as groupavailable,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
product_sizes.gender, product_sizes.sizerange, product_sizes.sizegroup, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize,
product_sizes.bust, product_sizes.waist, product_sizes.hip, product_sizes.underbust, product_sizes.cup, product_sizes.thigh, product_sizes.legheight, product_sizes.bodyheight, product_sizes.bodyweight
from product_sizes
left outer join product_variations on product_sizes.suppliersize = product_variations.size and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
where FIND_IN_SET(product_sizes.id_size,'2074,2067,2073') > 0
and product_variations.productuid = '7D140D94-3A6F-4DAE-A8BFAC87D635B499'
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
120741X/2X-intlsizeblack1X/2X111wpluslingerie1X/2X1X/2X-42-4412-1416-1844-4644-4642-4446-4844-4642-44104-11086-91112-120
220671X/2Xintlsizeblack1X/2X1X/2X111wpluslingerie1X/2X1X/2X46-4816-1820-2248-5048-5046-4852-5448-5046-48112-11892-96122-128
320733X/4Xintlsizeblack3X/4X3X/4X111wpluslingerie3X/4X3X/4X48-5018-2022-2450-5250-5248-5054-5650-5248-50120-12898-102128-132
sizeranges
stringplus
sizes
string2074,2067,2073
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: 4.32 ms
Record Count: 2
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 = '7D140D94-3A6F-4DAE-A8BFAC87D635B499'
and product_variations.isactive = 1
and product_sizes.id_size = 2074
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 = '7D140D94-3A6F-4DAE-A8BFAC87D635B499'
and product_variations.isactive = 1
and product_sizes.id_size = 2067
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 = '7D140D94-3A6F-4DAE-A8BFAC87D635B499'
and product_variations.isactive = 1
and product_sizes.id_size = 2073
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
17D140D94-3A6F-4DAE-A8BFAC87D635B499B6282B0E-1EB3-4EC5-802A907FDD0C4EA02074black#0000001X/2X1X/2X-42-4412-1416-1844-4644-4642-4446-4844-4642-44wlingerie1X/2X-intlsize33.29170STOCK011000000084031289507511all
27D140D94-3A6F-4DAE-A8BFAC87D635B499AFA66653-9E2E-430A-BF6D48BDF9F6E2AE2073black#0000003X/4X3X/4X48-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie3X/4Xintlsize33.29170STOCK011000000084031289508211all
subcategory
stringopenpanty
supplier
number0
supplierreference
stringDELILAH
tags
string
themes
string
totalvariations
string
type
stringdefault
unitprice
number33.2917
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 5.87 ms
Record Count: 3
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '7D140D94-3A6F-4DAE-A8BFAC87D635B499' 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 = '7D140D94-3A6F-4DAE-A8BFAC87D635B499' 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 = '7D140D94-3A6F-4DAE-A8BFAC87D635B499' 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 = '7D140D94-3A6F-4DAE-A8BFAC87D635B499' 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 = '7D140D94-3A6F-4DAE-A8BFAC87D635B499' 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 = '7D140D94-3A6F-4DAE-A8BFAC87D635B499' 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 = '7D140D94-3A6F-4DAE-A8BFAC87D635B499'
and product_variations.isactive = 1
and product_sizes.id_size = 2074
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 = '7D140D94-3A6F-4DAE-A8BFAC87D635B499' 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 = '7D140D94-3A6F-4DAE-A8BFAC87D635B499' 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 = '7D140D94-3A6F-4DAE-A8BFAC87D635B499' 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 = '7D140D94-3A6F-4DAE-A8BFAC87D635B499' 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 = '7D140D94-3A6F-4DAE-A8BFAC87D635B499' 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 = '7D140D94-3A6F-4DAE-A8BFAC87D635B499' 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 = '7D140D94-3A6F-4DAE-A8BFAC87D635B499'
and product_variations.isactive = 1
and product_sizes.id_size = 2067
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 = '7D140D94-3A6F-4DAE-A8BFAC87D635B499' 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 = '7D140D94-3A6F-4DAE-A8BFAC87D635B499' 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 = '7D140D94-3A6F-4DAE-A8BFAC87D635B499' 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 = '7D140D94-3A6F-4DAE-A8BFAC87D635B499' 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 = '7D140D94-3A6F-4DAE-A8BFAC87D635B499' 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 = '7D140D94-3A6F-4DAE-A8BFAC87D635B499' 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 = '7D140D94-3A6F-4DAE-A8BFAC87D635B499'
and product_variations.isactive = 1
and product_sizes.id_size = 2073
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
1B6282B0E-1EB3-4EC5-802A907FDD0C4EA02074black#0000001X/2X1X/2X-42-4412-1416-1844-4644-4642-4446-4844-4642-44wlingerie1X/2X-intlsize33.29170STOCK0110000000840312895075111122033.2917all
2B6282B0E-1EB3-4EC5-802A907FDD0C4EA02067black#0000001X/2X1X/2X46-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie1X/2Xintlsize33.29170STOCK0110000000840312895075111122033.2917all
3AFA66653-9E2E-430A-BF6D48BDF9F6E2AE2073black#0000003X/4X3X/4X48-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie3X/4Xintlsize33.29170STOCK0110000000840312895082111122033.2917all
vatrate
number20
warehouse
string