Siehe Größen
Passion Slip: Rotes Netz und freche Öffnungen
Doppelklicken Sie zum Vergrößern
SKU: SBGA1591
Passion Slip: Rotes Netz und freche Öffnungen
Promo
Lager:

Entdecken Sie den Passion Slip, eine hyperfreche Kreation aus rotem Netzstoff, die Ihre kühnste Seite offenbart.

Die strategischen Öffnungen und das halbtransparente Material sorgen für einen unwiderstehlichen Effekt und sorgen für Momente der puren Lust.

Highlights / Vorteile

  • Ultra-sinnliches, halbtransparentesrotes Netzgewebe
  • Öffnung im Schritt für einen direkten, verruchten Zugang
  • Große hintere Öffnung, die Ihren Po enthüllt
  • Sehr sexygeometrisches Rautenmuster
  • Bequemerelastischer Bund, der sich perfekt anpasst
  • Rote Abschlüsse an allen Rändern für einen perfekten Look
Größe:

Sie wissen nicht, welche Größe Sie wählen sollen? Sehen Sie sich unseren Größenratgeber an

Farbe:
Menge:
17.95 € 12.95 €
Fundierte Ratschläge
per Chat, Facebook oder E-Mail
Kostenlose Rücksendungen
innerhalb von 15 Tagen *

Slip, offen, große Größen Passion Netzstoff rot

Produktbeschreibung

Der Passion Slip verkörpert die kühnste Verführung mit seinem roten Netzstoff, der mit Transparenz spielt, um Ihre Haut subtil zu enthüllen.

Diese überaus verruchte Kreation verwandelt dank ihrer strategischen Öffnungen jeden intimen Moment in ein Erlebnis puren Vergnügens. DieÖffnung im Schritt bietet einen direkten Zugang, der die Temperatur ansteigen lässt, während die große Öffnung auf der Rückseite Ihren Po auf furchtbar erregende Weise enthüllt.

das Netzgewebe mit geometrischem Rautenmuster schmiegt sich perfekt an Ihre üppigen Kurven an und sorgt für einen fesselnden visuellen Effekt. Der elastische Bund passt sich natürlich jeder Körperform an und sorgt so für optimalen Tragekomfort, selbst bei Ihren intensivsten Momenten.

Die roten Abschlüsse an allen Rändern sorgen für den letzten Schliff, der Passion zu einem wirklich unwiderstehlichen Slip macht.

Diese rote Passion-Kreation wurde entwickelt, um Ihre authentische Sinnlichkeit zu enthüllen und jeden Moment in einen Moment der puren Verführung zu verwandeln.

Technische Details

  • Material: Rotes Netz (90% Polyamid, 10% Elasthan)
  • Farbe: Passionsrot
  • Größen: 42 bis 52
  • Stil: Offener Slip mit geometrischem Netz
  • Öffnungen: Im Schritt und hinten für vollen Zugriff
  • Pflege: Schonende Handwäsche empfohlen

Verfügbare Größen

Erhältlich von 42-44 bis 46-48

Verfügbare Farbe

Rot

Größenanleitung

Uberprüfen Sie die für Sie passende Größe

International
  • Brust
  • Größe
  • Hüften
42-44
  • 92-100
  • 74-82
  • 98-106
46-48
  • 110-116
  • 96-102
  • 116-122

Pflegehinweise

  • Handwäsche mit milder Seife oder Schonwaschgang in der Maschine (max. 30°C) in einem Wäschenetz empfohlen
  • Flach im Schatten trocknen, niemals im Trockner
  • Bügeln nicht empfohlen oder bei sehr niedriger Temperatur, falls nötig
  • Flach an einem trockenen Ort aufbewahren
  • Um die Elastizität und den Halt Ihrer Teile zu bewahren (Größen 42-64), wechseln Sie deren Gebrauch ab
  •  

Anwendungstipps

Der Passion Slip wurde für Ihre frechsten und gewagtesten Momente entworfen. Seine strategischen Öffnungen - im Schritt und auf der Rückseite - bieten einen vollständigen Zugang, der jeden intimen Moment in ein Erlebnis purer Lust verwandelt.

Tragen Sie ihn selbstbewusst, um Ihre sexieste und provokanteste Seite zu enthüllen. Das halbtransparente rote Netzgewebe enthüllt subtil Ihre Haut und bewahrt gleichzeitig das Geheimnis, das bei jedem Blick die Temperatur steigen lässt.

Styling-Tipps

Der Passion Slip aus rotem Netzstoff ist schon für sich allein genommen ein sexy Look. Um den verführerischen Effekt zu verstärken, kombinieren Sie es mit Teilen, die seine freche Präsenz subtil offenbaren. Diese leidenschaftsrote Kreation offenbart Ihre selbstbewusste Kühnheit und Ihre ungezügelte Sinnlichkeit.

Vervollständigen Sie Ihren Look mit unseren selbstfixierenden Strümpfen, um die sinnliche Wirkung auf Ihre Beine zu verlängern, oder fügen Sie ein Negligé hinzu für eine schrittweise Verführung, die mit der Entdeckung dieses schrecklich aufregenden Slips ihren Höhepunkt erreicht.

To Top
Artikel
Gesamtartikel
Struct
Entries: 108
actions
Array
available
number-1
brand
stringparishollywood
brandcode
stringpuun
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
stringParis Hollywood
breasts
stringna
careinstructions
stringlace
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.645 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,'red') > 0
and product_variations.productuid = '7E8FB423-5E88-4D19-B5342DB1AB0126FD'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1redcolorredredred#F50000-10
colorrange
stringred
colors
stringred
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-09-06 17:37:34'}
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
number1
hasshortdescription
booleantrue
hassizeinfos
booleantrue
hasspecifications
booleantrue
hasstockinfos
booleanfalse
hasstylingtips
booleantrue
hasusageinstructions
booleantrue
hasvariations
booleantrue
import
string
inpromo
number2
instockvariations
string
isactive
number1
iscustommade
number0
isdivasize
number0
isfirstprice
number0
isfixedprice
number0
ishot
number0
isnew
number0
isonline
number0
isoutletprice
number0
itemprice
number14.9583
itempromo
number10.7917
key
stringp5091-culotte-ouverte
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-10-22 18:41:25'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.61 ms
Record Count: 0
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select cart_actions.*
from cart_actions
where cart_actions.branding IN ('all','divasboudoir')
and cart_actions.language IN ('all','de')
and (cart_actions.quotas = -1 or (cart_actions.usedCount < cart_actions.quotas))
and cart_actions.isactive = 1
and (date(cart_actions.activeFrom) <= '2025-11-24' OR cart_actions.activeFrom is null)
and (date(cart_actions.activeTo) >= '2025-11-24' OR cart_actions.activeTo is null)
and (
FIND_IN_SET('7e8fb423-5e88-4d19-b5342db1ab0126fd',lcase(cart_actions.linkedproducts)) > 0 and cart_actions.linkedproducts is not null
)
id_actionbrandinglanguagenamecodetypeminimumOrdermaximumOrderminimumItemsmaximumItemsmaximumUseallowedItemsquotasusedCountlinkedproductslinkedthemeslinkedbrandslinkeditemparamsactiveFromactiveToisActive
linkedproducts
Query
Template: /system/api/products.cfc:1305
Execution Time: 1.29 ms
Record Count: 0
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select products.productuid as productuid, products.reference, 'default' as type, products.key, products.language, products.name,
product_links.linkuid,
products.colors, products.vatrate, products.metadatas, products.dimensions,
products.mediadatas, products.tags, products.themes, products.isdivasize,
count(distinct product_variations.variationuid) as totalvariations,
group_concat(distinct product_variations.variationuid) as variationlist,
count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END) as inpromo,
if(count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END)>0,1,0) as haspromo,
(select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0) END)) as itempromo,
IFNULL(min(product_variations.itemprice),0) as itemprice,
(select IF (products.isfixedprice = 0 and sum(product_variations.itempromo) > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null), IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0), IFNULL(min(NULLIF(product_variations.itemprice, 0)), 0) )) as unitprice,
count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.itempromo ELSE product_variations.itemprice END) as prices,
(select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN min(NULLIF(product_variations.promountil, 0)) END)) as promountil,
products.isfixedprice, products.ishot, products.isnew, if(products.orderidx > 0, products.orderidx, 999999999) as orderidx,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
count(distinct CASE WHEN ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) > 0 OR ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) <= 0 AND product_variations.supplier = 0)) THEN product_variations.variationuid END) as instockvariations,
products.brand, brands.name as brandname, IFNULL(brands.ispublic, 0) as showbrand, brands.display,
product_categories.sizetype,GROUP_CONCAT(DISTINCT product_sizes.suppliersize) as intlsize,products.sizes,product_sizes.sizerange,product_categories.mediadatas as categorymediadatas, product_categories.sizerange as categorysizerange,
product_categorymap.section, product_categorymap.category, product_categorymap.key as subcategory
from products
left outer join product_categorymap on products.productuid = product_categorymap.productuid
left outer join product_categories on (product_categories.branding = product_categorymap.branding and product_categories.section = product_categorymap.section and product_categories.category = product_categorymap.category and product_categories.key = product_categorymap.key)
left outer join product_sizes on product_sizes.id_size IN (products.sizes)
left outer join brands on products.brand = brands.brand
left outer join product_variations on product_variations.productuid = products.productuid and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
left outer join product_links on product_links.reference = products.reference
where products.isactive = 1 and products.isdeleted = 0
and brands.isactive = 1 and brands.isdeleted = 0
and product_categories.isactive = 1 and product_categories.isdeleted = 0
and product_variations.isactive = 1
and FIND_IN_SET('divasboudoir',products.branding)
and product_categories.branding IN ('all','divasboudoir')
and product_categorymap.branding IN ('all','divasboudoir')
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and products.language in ('all','de')
and product_categories.language in ('all','de')
and (products.displayFrom <= DATE(NOW()) or products.displayFrom is null)
and (products.displayTo >= DATE(NOW()) or products.displayTo IS null)
and product_links.linkuid = '' and product_links.linkuid is not null and product_links.linkuid <> ''
and products.reference <> 'SBGA1591'
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
string1445
isprivate
string0
rating
stringall
src
string/photobank/products/puun/sbga1591/culotte_ouverte_rouge_dos.jpg
type
stringimg
width
string999
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string1445
isprivate
string0
rating
stringall
src
string/photobank/products/puun/sbga1591/culotte_ouverte_rouge.jpg
type
stringimg
width
string999
variations
Struct
colors
Struct
red
Struct
height
string1445
isprivate
string0
rating
stringall
src
string/photobank/products/puun/sbga1591/culotte_ouverte_rouge.jpg
type
stringimg
width
string999
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.parishollywood.sbga1591
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-rot
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kokkino
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-red
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-rojo
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-rouge
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-rosso
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-rood
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-vermelho
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
divasboudoir
Struct
de
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>Der Passion Slip verkörpert die <strong>kühnste</strong> Verführung mit seinem roten Netzstoff, der mit Transparenz spielt, um Ihre Haut subtil zu enthüllen.</p> <p>Diese überaus <strong>verruchte</strong> Kreation verwandelt dank ihrer strategischen Öffnungen jeden intimen Moment in ein Erlebnis puren Vergnügens. Die<strong>Öffnung im Schritt</strong> bietet einen direkten Zugang, der die Temperatur ansteigen lässt, während die <strong>große Öffnung auf der Rückseite</strong> Ihren Po auf furchtbar erregende Weise enthüllt.</p> <p>das Netzgewebe mit <strong>geometrischem Rautenmuster</strong> schmiegt sich perfekt an Ihre üppigen Kurven an und sorgt für einen fesselnden visuellen Effekt. Der <strong>elastische Bund</strong> passt sich natürlich jeder Körperform an und sorgt so für optimalen Tragekomfort, selbst bei Ihren intensivsten Momenten.</p> <p>Die <strong>roten Abschlüsse</strong> an allen Rändern sorgen für den letzten Schliff, der Passion zu einem wirklich unwiderstehlichen Slip macht.</p> <p>Diese rote Passion-Kreation wurde entwickelt, um Ihre <strong>authentische</strong> Sinnlichkeit zu enthüllen und jeden Moment in einen Moment der puren Verführung zu verwandeln.</p>
guid
stringhttps://dev.divasboudoir.com/de/hoschen-leidenschaft-grosse-grosse-netz-rot/sbga1591.htm
highlights
string<ul> <li>Ultra-sinnliches, halbtransparentes<strong>rotes Netzgewebe</strong> </li> <li><strong>Öffnung im Schritt</strong> für einen direkten, verruchten Zugang</li> <li><strong>Große hintere Öffnung</strong>, die Ihren Po enthüllt</li> <li>Sehr sexy<strong>geometrisches Rautenmuster</strong> </li> <li>Bequemer<strong>elastischer Bund</strong>, der sich perfekt anpasst</li> <li><strong>Rote Abschlüsse</strong> an allen Rändern für einen perfekten Look</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringPassion Slip in großen Größen aus rotem Netzstoff mit frechen Öffnungen. Schritt und Rücken offen. Hypersexy und gewagt. Schnelle Lieferung.
keywords
string
title
stringSlip Passion große Größe aus rotem Netz | Diva's Boudoir
seotitle
stringSlip, offen, große Größen Passion Netzstoff rot
seouri
stringhoschen-leidenschaft-grosse-grosse-netz-rot
specifications
string<ul> <li><strong>Material:</strong> Rotes Netz (90% Polyamid, 10% Elasthan)</li> <li><strong>Farbe:</strong> Passionsrot</li> <li><strong>Größen:</strong> 42 bis 52</li> <li><strong>Stil:</strong> Offener Slip mit geometrischem Netz</li> <li><strong>Öffnungen:</strong> Im Schritt und hinten für vollen Zugriff</li> <li><strong>Pflege:</strong> Schonende Handwäsche empfohlen</li> </ul>
stylingtips
string<p>Der Passion Slip aus rotem Netzstoff ist schon für sich allein genommen ein <strong>sexy</strong> Look. Um den verführerischen Effekt zu verstärken, kombinieren Sie es mit Teilen, die seine freche Präsenz subtil offenbaren. Diese leidenschaftsrote Kreation offenbart Ihre selbstbewusste Kühnheit und Ihre ungezügelte Sinnlichkeit.</p> <p>Vervollständigen Sie Ihren Look mit unseren <strong><a href="https://www.divasboudoir.com/de/strumpfe-in-grossen-grossen/">selbstfixierenden Strümpfen</a></strong>, um die sinnliche Wirkung auf Ihre Beine zu verlängern, oder fügen Sie ein <a href="https://www.divasboudoir.com/de/neglige-in-grosse-grossen/"><strong>Neglig&eacute;</strong></a> hinzu für eine schrittweise Verführung, die mit der Entdeckung dieses schrecklich aufregenden Slips ihren Höhepunkt erreicht.</p>
summary
string<p>Entdecken Sie den Passion Slip, eine <strong>hyperfreche</strong> Kreation aus rotem Netzstoff, die Ihre <strong>kühnste</strong> Seite offenbart.</p> <p>Die <strong>strategischen Öffnungen</strong> und das halbtransparente Material sorgen für einen unwiderstehlichen Effekt und sorgen für Momente der puren Lust.</p>
title
stringPassion Slip: Rotes Netz und freche Öffnungen
usageinstructions
string<p>Der Passion Slip wurde für Ihre <strong>frechsten</strong> und gewagtesten Momente entworfen. Seine <strong>strategischen Öffnungen</strong> - im Schritt und auf der Rückseite - bieten einen vollständigen Zugang, der jeden intimen Moment in ein Erlebnis purer Lust verwandelt.</p> <p>Tragen Sie ihn selbstbewusst, um Ihre <strong>sexieste</strong> und provokanteste Seite zu enthüllen. Das halbtransparente rote Netzgewebe enthüllt subtil Ihre Haut und bewahrt gleichzeitig das Geheimnis, das bei jedem Blick die Temperatur steigen lässt.</p>
el
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>Το εσώρουχο Passion ενσαρκώνει την πιο <strong>τολμηρή</strong> αποπλάνηση με το κόκκινο δίχτυ που παίζει με τη διαφάνεια και αποκαλύπτει διακριτικά το δέρμα σας.</p> <p>Αυτή η <strong>σούπερ άτακτη</strong> δημιουργία μετατρέπει κάθε προσωπική στιγμή σε μια εμπειρία καθαρής απόλαυσης χάρη στα στρατηγικά ανοίγματά της. Το<strong>άνοιγμα στον καβάλο</strong> προσφέρει άμεση πρόσβαση που ανεβάζει τη θερμοκρασία, ενώ το <strong>μεγάλο πίσω άνοιγμα</strong> αποκαλύπτει τα οπίσθιά σας με τρομερά συναρπαστικό τρόπο.</p> <p>το δίχτυ με το <strong>γεωμετρικό μοτίβο</strong> διαμαντιών αγκαλιάζει τέλεια τις γενναιόδωρες καμπύλες σας, δημιουργώντας ένα σαγηνευτικό οπτικό αποτέλεσμα. Η <strong>ελαστική ζώνη στη μέση</strong> προσαρμόζεται φυσικά σε όλα τα σχήματα του σώματος για βέλτιστη άνεση, ακόμη και στις πιο έντονες στιγμές σας.</p> <p>Το <strong>κόκκινο τελείωμα</strong> σε όλες τις άκρες προσθέτει την τελική πινελιά που κάνει το Passion ένα πραγματικά ακαταμάχητο εσώρουχο.</p> <p>Αυτή η δημιουργία σε κόκκινο χρώμα του πάθους έχει σχεδιαστεί για να αποκαλύψει τον πιο <strong>αυθεντικό</strong> σας αισθησιασμό και να μετατρέψει κάθε στιγμή σε μια στιγμή καθαρής αποπλάνησης.</p>
guid
stringhttps://dev.divasboudoir.com/el/passion-panties-megalo-megethos-resille-kokkino/sbga1591.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
stringPassion plus size εσώρουχο σε κόκκινο δίχτυ με άτακτα ανοίγματα. Ανοιχτό καβάλο και πλάτη. Σούπερ σέξι και τολμηρό. Γρήγορη παράδοση.
keywords
string
title
stringΕσώρουχα πάθους μεγάλο μέγεθος κόκκινο διχτυωτό | Diva's Boudoir
seotitle
stringΠάθος διχτυωτό κόκκινο μεγάλο ανοιχτό βρακί
seouri
stringpassion-panties-megalo-megethos-resille-kokkino
specifications
string<ul> <li><strong>Υλικό:</strong> Κόκκινο διχτυωτό ύφασμα (90% πολυαμίδιο, 10% ελαστάν)</li> <li><strong>Χρώμα:</strong> Κόκκινο του πάθους</li> <li><strong>Μεγέθη:</strong> 42 έως 52</li> <li><strong>Στυλ:</strong> Ανοιχτό εσώρουχο με γεωμετρικό δίχτυ</li> <li><strong>Ανοίγματα:</strong> καβάλο και πλάτη για απόλυτη πρόσβαση</li> <li><strong>Φροντίδα:</strong> Συνιστάται απαλό πλύσιμο στο χέρι</li> </ul>
stylingtips
string<p>Το κόκκινο διχτυωτό εσώρουχο Passion στέκεται μόνο του για να δημιουργήσει μια <strong>σούπερ σέξι</strong> εμφάνιση. Για μια πρόσθετη πινελιά αποπλάνησης, συνδυάστε τα με κομμάτια που αποκαλύπτουν διακριτικά την άτακτη παρουσία τους. Αυτή η κόκκινη δημιουργία του πάθους αποκαλύπτει την τόλμη και τον αχαλίνωτο αισθησιασμό σας.</p> <p>Ολοκληρώστε την εμφάνισή σας με τις <strong><a href="https://www.divasboudoir.com/el/kaltses-megaloy-megethoys/">αυτοκόλλητες κάλτσες</a></strong> μας για να παρατείνετε το αισθησιακό αποτέλεσμα στα πόδια σας ή προσθέστε ένα <a href="https://www.divasboudoir.com/el/negklize-megaloy-megethoys/"><strong>νεγκλιζέ</strong></a> για μια σταδιακή αποπλάνηση που θα κορυφωθεί με την ανακάλυψη αυτών των τρομερά συναρπαστικών εσώρουχων.</p>
summary
string<p>Ανακαλύψτε το εσώρουχο Passion, μια <strong>σούπερ άτακτη</strong> δημιουργία από κόκκινο διχτυωτό ύφασμα που αποκαλύπτει την πιο <strong>τολμηρή</strong> πλευρά σας.</p> <p>Τα <strong>στρατηγικά</strong> του <strong>ανοίγματα</strong> και το ημιδιαφανές ύφασμα δημιουργούν ένα ακαταμάχητο αποτέλεσμα για στιγμές καθαρής απόλαυσης.</p>
title
stringΕσώρουχα πάθους: Κόκκινο δίχτυ και άτακτα ανοίγματα
usageinstructions
string<p>Τα εσώρουχα Passion είναι σχεδιασμένα για τις πιο τολμηρές και <strong>άτακτες</strong> στιγμές σας. Τα <strong>στρατηγικά</strong> του <strong>ανοίγματα</strong> - στον καβάλο και στην πλάτη - προσφέρουν απόλυτη πρόσβαση, μετατρέποντας κάθε προσωπική στιγμή σε μια εμπειρία απόλυτης απόλαυσης.</p> <p>Φορέστε το με αυτοπεποίθηση για να αποκαλύψετε την <strong>πιο σέξι</strong>, προκλητική πλευρά σας. Το ημιδιαφανές κόκκινο δίχτυ αποκαλύπτει διακριτικά το δέρμα σας, διατηρώντας παράλληλα το μυστήριο που ανεβάζει τη θερμοκρασία με κάθε ματιά.</p>
en
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>Passion panties embody the most <strong>daring</strong> seduction with their red fishnet that plays with transparency to subtly reveal your skin.</p> <p>This <strong>super-naughty</strong> creation transforms every intimate moment into an experience of pure pleasure, thanks to its strategic openings. The<strong>crotch opening</strong> offers direct access that raises the temperature, while the <strong>large rear opening</strong> reveals your buttocks in a terribly exciting way.</p> <p>the fishnet with its <strong>geometric</strong> diamond <strong>pattern</strong> perfectly hugs your generous curves, creating a captivating visual effect. The <strong>elastic waistband</strong> naturally adapts to all body shapes for optimum comfort, even during your most intense moments.</p> <p><strong>Red trim on</strong> all edges adds that finishing touch that makes Passion a truly irresistible panty.</p> <p>This passion red creation is designed to reveal your most <strong>authentic</strong> sensuality and turn every moment into a moment of pure seduction.</p>
guid
stringhttps://dev.divasboudoir.com/en/passion-panties-plus-size-resille-red/sbga1591.htm
highlights
string<ul> <li>Ultra-sensual, semi-transparent<strong>red fishnet</strong> </li> <li><strong>Crotch opening</strong> for direct, naughty access</li> <li><strong>Large rear opening</strong> reveals your buttocks</li> <li>Sexy<strong>geometric</strong> diamond<strong>pattern</strong> </li> <li>Comfortable<strong>elastic waistband</strong> for a perfect fit</li> <li><strong>Red trim on</strong> all edges for a perfect look</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringPlus size Passion panties in red fishnet with naughty openings. Open crotch and back. Super sexy and daring. Fast delivery.
keywords
string
title
stringPassion panties plus size red fishnet | Diva's Boudoir
seotitle
stringOpen panties plus size Passion fishnet red
seouri
stringpassion-panties-plus-size-resille-red
specifications
string<ul> <li><strong>Material:</strong> Red fishnet (90% polyamide, 10% elastane)</li> <li><strong>Color:</strong> Passion red</li> <li><strong>Sizes:</strong> 42 to 52</li> <li><strong>Style:</strong> Open panty with geometric fishnet</li> <li><strong>Openings:</strong> crotch and back for total access</li> <li><strong>Care:</strong> Delicate hand wash recommended</li> </ul>
stylingtips
string<p>Passion's red fishnet panties stand on their own to create a <strong>super-sexy</strong> look. To amplify the seductive effect, pair them with pieces that subtly reveal their naughty presence. This passion red creation reveals your boldness and unbridled sensuality.</p> <p>Complete your look with our <strong><a href="https://www.divasboudoir.com/en/socks-large-size/">self-fastening stockings</a></strong> to prolong the sensual effect on your legs, or add a <a href="https://www.divasboudoir.com/en/plus-size-robes/"><strong>negligee</strong></a> for a gradual seduction that culminates in the discovery of these terribly exciting panties.</p>
summary
string<p>Discover Passion panties, a <strong>super-naughty</strong> creation in red fishnet that reveals your most <strong>daring</strong> side.</p> <p>Their <strong>strategic openings</strong> and semi-transparent fabric create an irresistible effect for moments of pure pleasure.</p>
title
stringPassion panties: Red fishnet with naughty openings
usageinstructions
string<p>Passion panties are designed for your most daring and <strong>naughty</strong> moments. Its <strong>strategic openings</strong> - crotch and back - offer total access that transforms every intimate moment into an experience of pure pleasure.</p> <p>Wear it with confidence to reveal your <strong>sexiest</strong>, most provocative side. The semi-transparent red fishnet subtly reveals your skin while preserving that mystery that raises the temperature with every glance.</p>
es
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>Las braguitas Passion encarnan la seducción más <strong>atrevida</strong> con su rejilla roja que juega con la transparencia para revelar sutilmente tu piel.</p> <p>Esta creación <strong>súper traviesa</strong> convierte cada momento íntimo en una experiencia de puro placer gracias a sus estratégicas aberturas. La<strong>abertura de la entrepierna</strong> ofrece un acceso directo que eleva la temperatura, mientras que la <strong>gran abertura</strong> trasera revela tus nalgas de una forma terriblemente excitante.</p> <p>la malla de rejilla, con su <strong>estampado geométrico</strong> de rombos, abraza perfectamente tus generosas curvas, creando un efecto visual cautivador. La <strong>cintura elástica</strong> se adapta con naturalidad a todas las formas del cuerpo para un confort óptimo, incluso en tus momentos más intensos.</p> <p>El <strong>ribete rojo</strong> en todos los bordes añade ese toque final que hace de Passion una braguita verdaderamente irresistible.</p> <p>Esta creación en rojo pasión está diseñada para revelar tu sensualidad más <strong>auténtica</strong> y convertir cada momento en un instante de pura seducción.</p>
guid
stringhttps://dev.divasboudoir.com/es/bragas-passion-talla-grande-resille-rojo/sbga1591.htm
highlights
string<ul> <li><strong>Red roja</strong> semitransparente ultrasensual</li> <li>Abertura en<strong>la entrepierna</strong> para un acceso directo y travieso</li> <li><strong>Gran abertura trasera</strong> que deja al descubierto las nalgas</li> <li><strong>Estampado geométrico</strong> de rombos muy sexy</li> <li><strong>Cómoda cintura elástica</strong> que se ajusta perfectamente</li> <li><strong>Ribete rojo en</strong> todos los bordes para un look perfecto</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringBragas talla grande Passion de rejilla roja con traviesas aberturas. Entrepierna y espalda abiertas. Super sexy y atrevida. Entrega rápida.
keywords
string
title
stringBragas Passion talla grande red fishnet | Diva's Boudoir
seotitle
stringPassion bragas abiertas talla grande rojas de rejilla
seouri
stringbragas-passion-talla-grande-resille-rojo
specifications
string<ul> <li><strong>Material:</strong> Red roja (90% poliamida, 10% elastán)</li> <li><strong>Color:</strong> rojo pasión</li> <li><strong>Tallas</strong>: de la 42 a la 52</li> <li><strong>Estilo:</strong> Braguita abierta con rejilla geométrica</li> <li><strong>Aberturas:</strong> entrepierna y espalda para un acceso total</li> <li><strong>Cuidados:</strong> Se recomienda un lavado a mano delicado</li> </ul>
stylingtips
string<p>Las braguitas rojas de rejilla Passion se mantienen solas para crear un look <strong>súper sexy</strong>. Combínalas con piezas que revelen sutilmente su traviesa presencia para añadir un toque de seducción. Esta creación rojo pasión revela tu atrevimiento y sensualidad desenfrenada.</p> <p>Completa tu look con nuestras <strong><a href="https://www.divasboudoir.com/es/medias-grandes/">medias que se atan solas</a></strong> para prolongar el efecto sensual en tus piernas, o añade un <a href="https://www.divasboudoir.com/es/picardias-talla-grande/"><strong>picardías</strong></a> para una seducción gradual que culminará con el descubrimiento de estas bragas terriblemente excitantes.</p>
summary
string<p>Descubre las braguitas Passion, una creación <strong>súper traviesa</strong> de rejilla roja que revela tu lado más <strong>atrevido</strong>.</p> <p>Sus <strong>aberturas estratégicas</strong> y su tejido semitransparente crean un efecto irresistible para momentos de puro placer.</p>
title
stringBragas Passion: Red de rejilla roja y aberturas traviesas
usageinstructions
string<p>Las braguitas Passion están diseñadas para tus momentos más atrevidos y <strong>traviesos</strong>. Sus <strong>estratégicas aberturas</strong> -entrepierna y espalda- ofrecen un acceso total, convirtiendo cada momento íntimo en una experiencia de puro placer.</p> <p>Llévalo con confianza para revelar tu lado <strong>más sexy</strong> y provocativo. La rejilla roja semitransparente revela sutilmente tu piel al tiempo que preserva el misterio que sube la temperatura con cada mirada.</p>
fr
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>La culotte Passion incarne la s&eacute;duction la plus <strong>audacieuse</strong> avec sa r&eacute;sille rouge qui joue avec la transparence pour r&eacute;v&eacute;ler subtilement votre peau.</p> <p>Cette cr&eacute;ation&nbsp;<strong>hyper coquine</strong> transforme chaque moment intime en exp&eacute;rience de pur plaisir gr&acirc;ce &agrave; ses ouvertures strat&eacute;giques. L'<strong>ouverture &agrave; l'entrejambe</strong> offre un acc&egrave;s direct qui fait monter la temp&eacute;rature, tandis que la <strong>grande ouverture arri&egrave;re</strong> r&eacute;v&egrave;le vos fesses de fa&ccedil;on terriblement excitante.</p> <p>&nbsp;La r&eacute;sille aux <strong>motifs g&eacute;om&eacute;triques</strong> en losanges &eacute;pouse parfaitement vos courbes g&eacute;n&eacute;reuses, cr&eacute;ant un effet visuel captivant. Sa <strong>taille &eacute;lastique</strong> s'adapte naturellement &agrave; toutes les morphologies pour un confort optimal, m&ecirc;me lors de vos moments les plus intenses.</p> <p>Les&nbsp;<strong>finitions rouges</strong> sur tous les bords apportent cette touche finale qui fait de Passion une culotte vraiment irr&eacute;sistible.</p> <p>Cette cr&eacute;ation rouge passion est con&ccedil;ue pour r&eacute;v&eacute;ler votre sensualit&eacute; la plus&nbsp;<strong>authentique</strong> et transformer chaque instant en moment de pure s&eacute;duction.</p>
guid
stringhttps://dev.divasboudoir.com/fr/culotte-passion-grande-taille-resille-rouge/sbga1591.htm
highlights
string<ul> <li><strong>R&eacute;sille rouge</strong> semi-transparente ultra sensuelle</li> <li><strong>Ouverture entrejambe</strong> pour un acc&egrave;s direct et coquin</li> <li><strong>Grande ouverture arri&egrave;re</strong> qui r&eacute;v&egrave;le vos fesses</li> <li><strong>Motifs g&eacute;om&eacute;triques</strong> en losanges tr&egrave;s sexy</li> <li><strong>Taille &eacute;lastique</strong> confortable qui s'adapte parfaitement</li> <li><strong>Finitions rouges</strong> sur tous les bords pour un look parfait</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringCulotte Passion grande taille en résille rouge avec ouvertures coquines. Entrejambe et dos ouverts. Hyper sexy et audacieuse. Livraison rapide.
keywords
string
title
stringCulotte Passion grande taille résille rouge | Diva's Boudoir
seotitle
stringCulotte ouverte grande taille Passion résille rouge
seouri
stringculotte-passion-grande-taille-resille-rouge
specifications
string<ul> <li><strong>Mati&egrave;re :</strong> R&eacute;sille rouge (90% polyamide, 10% &eacute;lasthanne)</li> <li><strong>Couleur :</strong> Rouge passion</li> <li><strong>Tailles :</strong> 42 &agrave; 52</li> <li><strong>Style :</strong> Culotte ouverte avec r&eacute;sille g&eacute;om&eacute;trique</li> <li><strong>Ouvertures :</strong> Entrejambe et arri&egrave;re pour un acc&egrave;s total</li> <li><strong>Entretien :</strong> Lavage d&eacute;licat &agrave; la main recommand&eacute;</li> </ul>
stylingtips
string<p>La culotte Passion en r&eacute;sille rouge se suffit &agrave; elle-m&ecirc;me pour cr&eacute;er un look <strong>hyper sexy</strong>. Pour amplifier l'effet de s&eacute;duction, associez-la &agrave; des pi&egrave;ces qui r&eacute;v&egrave;lent subtilement sa pr&eacute;sence coquine. Cette cr&eacute;ation rouge passion r&eacute;v&egrave;le votre audace assum&eacute;e et votre sensualit&eacute; d&eacute;brid&eacute;e.</p> <p>Compl&eacute;tez votre look avec nos&nbsp;<strong><a href="https://www.divasboudoir.com/fr/bas-grande-taille/">bas autofixants</a></strong> pour prolonger l'effet sensuel sur vos jambes, ou ajoutez un <a href="https://www.divasboudoir.com/fr/deshabille-grande-taille/"><strong>d&eacute;shabill&eacute;</strong></a>&nbsp; pour une s&eacute;duction progressive qui culminera avec la d&eacute;couverte de cette culotte terriblement excitante.</p>
summary
string<p>D&eacute;couvrez la culotte Passion, une cr&eacute;ation <strong>hyper coquine</strong> en r&eacute;sille rouge qui r&eacute;v&egrave;le votre c&ocirc;t&eacute; le plus <strong>audacieux</strong>.</p> <p>Ses&nbsp;<strong>ouvertures strat&eacute;giques</strong> et sa mati&egrave;re semi-transparente cr&eacute;ent un effet irr&eacute;sistible pour des moments de pur plaisir.</p>
title
stringCulotte Passion : Résille Rouge et Ouvertures Coquines
usageinstructions
string<p>La culotte Passion est con&ccedil;ue pour vos moments les plus <strong>coquins</strong> et audacieux. Ses <strong>ouvertures strat&eacute;giques</strong> - entrejambe et arri&egrave;re - offrent un acc&egrave;s total qui transforme chaque instant intime en exp&eacute;rience de pur plaisir.</p> <p>Portez-la avec assurance pour r&eacute;v&eacute;ler votre c&ocirc;t&eacute; le plus&nbsp;<strong>sexy</strong> et provocant. La r&eacute;sille rouge semi-transparente r&eacute;v&egrave;le subtilement votre peau tout en conservant ce myst&egrave;re qui fait monter la temp&eacute;rature &agrave; chaque regard.</p>
it
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>Le mutandine Passion incarnano la seduzione più <strong>audace</strong> con la loro rete rossa che gioca con le trasparenze per rivelare sottilmente la pelle.</p> <p>Questa creazione <strong>super birichina</strong> trasforma ogni momento intimo in un'esperienza di puro piacere grazie alle sue aperture strategiche. L'<strong>apertura inguinale</strong> offre un accesso diretto che aumenta la temperatura, mentre l'<strong>ampia apertura posteriore</strong> rivela i vostri glutei in modo terribilmente eccitante.</p> <p>la rete a rombi <strong>geometrici</strong> abbraccia perfettamente le vostre curve generose, creando un effetto visivo accattivante. L'<strong>elastico in vita</strong> si adatta naturalmente a tutte le forme del corpo per un comfort ottimale, anche nei momenti più intensi.</p> <p>Le <strong>finiture rosse</strong> su tutti i bordi aggiungono quel tocco finale che rende Passion un panty davvero irresistibile.</p> <p>Questa creazione rosso passione è pensata per rivelare la vostra sensualità più <strong>autentica</strong> e trasformare ogni momento in un momento di pura seduzione.</p>
guid
stringhttps://dev.divasboudoir.com/it/mutandine-passionali-taglia-grande-resille-rosso/sbga1591.htm
highlights
string<ul> <li><strong>Rete rossa</strong> semitrasparente e ultra-sensuale</li> <li><strong>Apertura all'inguine</strong> per un accesso diretto e malizioso</li> <li><strong>L'ampia apertura posteriore</strong> rivela i vostri glutei</li> <li><strong>Motivo geometrico</strong> a rombi molto sexy</li> <li>Confortevole<strong>fascia elastica in vita</strong> che si adatta perfettamente</li> <li><strong>Rifiniture rosse su</strong> tutti i bordi per un look perfetto</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringMutandine Passion taglia grande in rete rossa con aperture maliziose. Inguine e schiena aperti. Super sexy e audaci. Consegna rapida.
keywords
string
title
stringMutandine Passion taglia grande a rete rossa | Diva's Boudoir
seotitle
stringPassione mutandine a rete rosse di grande taglia aperte
seouri
stringmutandine-passionali-taglia-grande-resille-rosso
specifications
string<ul> <li><strong>Materiale:</strong> rete rossa (90% poliammide, 10% elastan)</li> <li><strong>Colore:</strong> Rosso passione</li> <li><strong>Taglie:</strong> dalla 42 alla 52</li> <li><strong>Stile:</strong> mutandine aperte con rete geometrica</li> <li><strong>Aperture:</strong> cavallo e schiena per un accesso totale</li> <li><strong>Cura:</strong> si consiglia un lavaggio delicato a mano</li> </ul>
stylingtips
string<p>Le mutandine a rete rosse di Passion sono perfette da sole per creare un look <strong>super sexy</strong>. Abbinatele a capi che rivelano sottilmente la loro presenza maliziosa per un ulteriore tocco di seduzione. Questa creazione rosso passione rivela la vostra audacia e sensualità sfrenata.</p> <p>Completate il vostro look con le nostre <strong><a href="https://www.divasboudoir.com/it/calze-di-grandi-dimensioni/">calze autoreggenti</a></strong> per prolungare l'effetto sensuale sulle vostre gambe, oppure aggiungete una <a href="https://www.divasboudoir.com/it/vestaglia-taglia-grande/"><strong>vestaglia per</strong></a> una seduzione graduale che culminerà con la scoperta di queste mutandine terribilmente eccitanti.</p>
summary
string<p>Scoprite le mutandine Passion, una creazione <strong>super-naughty</strong> in rete rossa che rivela il vostro lato più <strong>audace</strong>.</p> <p>Le sue <strong>aperture strategiche</strong> e il tessuto semitrasparente creano un effetto irresistibile per momenti di puro piacere.</p>
title
stringMutandine passionali: rete rossa e aperture birichine
usageinstructions
string<p>Le mutandine Passion sono pensate per i vostri momenti più audaci e <strong>maliziosi</strong>. Le sue <strong>aperture strategiche</strong> - inguine e schiena - offrono un accesso totale, trasformando ogni momento di intimità in un'esperienza di puro piacere.</p> <p>Indossatela con fiducia per rivelare il vostro lato <strong>più sexy</strong> e provocante. La rete rossa semitrasparente rivela sottilmente la vostra pelle, mantenendo il mistero che aumenta la temperatura ad ogni sguardo.</p>
nl
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>Passion slips belichamen de meest <strong>gedurfde</strong> verleiding met hun rode visnet dat speelt met transparantie om je huid subtiel te onthullen.</p> <p>Deze <strong>superdeugende</strong> creatie verandert elk intiem moment in een ervaring van puur genot dankzij de strategische openingen. De<strong>opening in het kruis</strong> biedt directe toegang die de temperatuur doet stijgen, terwijl de <strong>grote opening aan de achterkant</strong> je billen op een vreselijk opwindende manier onthult.</p> <p>het visnet met <strong>geometrisch ruitpatroon</strong> omhelst perfect je royale rondingen en cre&euml;ert een fascinerend visueel effect. De <strong>elastische tailleband</strong> past zich op natuurlijke wijze aan alle lichaamsvormen aan voor optimaal comfort, zelfs tijdens je meest intense momenten.</p> <p>De <strong>rode boorden</strong> rond alle randen zorgen voor de finishing touch die van Passion een onweerstaanbare panty maakt.</p> <p>Deze passierode creatie is ontworpen om je meest <strong>authentieke</strong> sensualiteit te onthullen en van elk moment een moment van pure verleiding te maken.</p>
guid
stringhttps://dev.divasboudoir.com/nl/passieslip-grote-maat-resille-rood/sbga1591.htm
highlights
string<ul> <li>Ultra-sensueel, semi-transparant<strong>rood visnet</strong></li> <li><strong>Kruisopening</strong> voor directe, ondeugende toegang</li> <li><strong>Grote opening aan de achterkant</strong> onthult je billen</li> <li>Zeer sexy<strong>geometrisch ruitpatroon</strong></li> <li>Comfortabele<strong>elastische tailleband</strong> die perfect past</li> <li><strong>Rode rand aan</strong> alle randen voor een perfecte look</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringPassion grote maten slip in rood visnet met ondeugende openingen. Open kruis en rug. Super sexy en gedurfd. Snelle levering.
keywords
string
title
stringPassieslip grote maat rood visnet | Diva's Boudoir
seotitle
stringPassie visnet rood grote maat onderbroek
seouri
stringpassieslip-grote-maat-resille-rood
specifications
string<ul> <li><strong>Materiaal:</strong> Rood visnet (90% polyamide, 10% elastaan)</li> <li><strong>Kleur:</strong> Passierood</li> <li><strong>Maten:</strong> 42 tot 52</li> <li><strong>Stijl:</strong> Open slip met geometrisch visnet</li> <li><strong>Openingen:</strong> kruis en rug voor volledige toegang</li> <li><strong>Onderhoud:</strong> Fijne handwas aanbevolen</li> </ul>
stylingtips
string<p>De rode visnet slipjes van Passion staan op zichzelf en cre&euml;ren een <strong>super sexy</strong> look. Voor een extra vleugje verleiding combineer je ze met stukken die subtiel hun ondeugende aanwezigheid onthullen. Deze passionele rode creatie onthult je brutaliteit en ongebreidelde sensualiteit.</p> <p>Maak je look compleet met onze <strong><a href="https://www.divasboudoir.com/nl/grote-maat-kousen/">zelfbinderkousen</a></strong> om het sensuele effect op je benen te verlengen, of voeg een <a href="https://www.divasboudoir.com/nl/grote-maat-neglige/"><strong>neglig&eacute;</strong></a> toe voor een geleidelijke verleiding die zal culmineren in de ontdekking van deze vreselijk opwindende slip.</p>
summary
string<p>Ontdek de Passion slip, een <strong>superdeugende</strong> creatie van rood visnet die je van je meest <strong>gewaagde</strong> kant laat zien.</p> <p>De <strong>strategische openingen</strong> en semi-transparante stof cre&euml;ren een onweerstaanbaar effect voor momenten van puur plezier.</p>
title
stringPassieslipjes: Rood visnet en ondeugende openingen
usageinstructions
string<p>Passion slips zijn ontworpen voor je meest gewaagde en <strong>ondeugende</strong> momenten. De <strong>strategische openingen</strong> - kruis en rug - bieden volledige toegang, waardoor elk intiem moment een ervaring van puur plezier wordt.</p> <p>Draag het met vertrouwen om je <strong>meest sexy</strong> en uitdagende kant te onthullen. Het semi-transparante rode visnet onthult subtiel je huid terwijl het mysterie behouden blijft dat de temperatuur doet stijgen met elke blik.</p>
pt
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>As cuecas Passion encarnam a sedução mais <strong>ousada</strong> com a sua rede vermelha que joga com a transparência para revelar subtilmente a sua pele.</p> <p>Esta criação <strong>super atrevida</strong> transforma cada momento íntimo numa experiência de puro prazer graças às suas aberturas estratégicas. A<strong>abertura na virilha</strong> oferece um acesso direto que aumenta a temperatura, enquanto a <strong>grande abertura traseira</strong> revela as suas nádegas de uma forma terrivelmente excitante.</p> <p>a rede de pesca com o seu <strong>padrão geométrico</strong> de diamantes envolve perfeitamente as suas curvas generosas, criando um efeito visual cativante. A <strong>cintura elástica</strong> adapta-se naturalmente a todas as formas do corpo para um conforto ótimo, mesmo durante os seus momentos mais intensos.</p> <p>O <strong>acabamento vermelho</strong> em todas as extremidades dá o toque final que faz de Passion uma cueca verdadeiramente irresistível.</p> <p>Esta criação em vermelho paixão foi concebida para revelar a sua sensualidade mais <strong>autêntica</strong> e transformar cada momento num momento de pura sedução.</p>
guid
stringhttps://dev.divasboudoir.com/pt/cuecas-passion-tamanho-grande-resille-vermelho/sbga1591.htm
highlights
string<ul> <li><strong>Rede vermelha</strong> ultra-sensual e semi-transparente</li> <li><strong>Abertura nas virilhas</strong> para um acesso direto e atrevido</li> <li><strong>Grande abertura nas costas</strong> que revela as suas nádegas</li> <li><strong>Padrão geométrico</strong> de diamantes muito sexy</li> <li><strong>Cintura elástica</strong> confortável que se ajusta perfeitamente</li> <li><strong>Acabamento vermelho em</strong> todos os bordos para um look perfeito</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringCuecas Passion plus size em rede vermelha com aberturas atrevidas. Entrepernas e costas abertas. Super sexy e ousada. Entrega rápida.
keywords
string
title
stringCuecas Passion tamanho grande rede vermelha | Diva's Boudoir
seotitle
stringCalcinhas de rede vermelhas grandes abertas Passion
seouri
stringcuecas-passion-tamanho-grande-resille-vermelho
specifications
string<ul> <li><strong>Material:</strong> Rede vermelha (90% poliamida, 10% elastano)</li> <li><strong>Cor:</strong> Vermelho paixão</li> <li><strong>Tamanhos:</strong> 42 a 52</li> <li><strong>Estilo:</strong> Cuecas abertas com rede geométrica</li> <li><strong>Aberturas:</strong> entrepernas e atrás para acesso total</li> <li><strong>Cuidados:</strong> Recomenda-se uma lavagem delicada à mão</li> </ul>
stylingtips
string<p>As cuecas de rede vermelhas da Passion criam um visual <strong>super sexy</strong>. Combine-as com peças que revelem subtilmente a sua presença atrevida para um toque adicional de sedução. Esta criação vermelha da Passion revela a sua ousadia e sensualidade desenfreada.</p> <p>Complete o seu look com as nossas <strong><a href="https://www.divasboudoir.com/pt/meias-de-tamanho-grande/">meias</a></strong> de <strong><a href="https://www.divasboudoir.com/pt/meias-de-tamanho-grande/">ligas</a></strong> para prolongar o efeito sensual nas suas pernas, ou adicione um <a href="https://www.divasboudoir.com/pt/batotas-plus-size/"><strong>negligee</strong></a> para uma sedução gradual que culminará na descoberta destas cuecas terrivelmente excitantes.</p>
summary
string<p>Descubra as cuecas Passion, uma criação <strong>super atrevida</strong> em rede vermelha que revela o seu lado mais <strong>atrevido</strong>.</p> <p>As suas <strong>aberturas estratégicas</strong> e o tecido semi-transparente criam um efeito irresistível para momentos de puro prazer.</p>
title
stringCalcinhas Passion: rede vermelha e aberturas atrevidas
usageinstructions
string<p>As cuecas Passion foram concebidas para os seus momentos mais ousados e <strong>atrevidos</strong>. As suas <strong>aberturas estratégicas</strong> - entrepernas e costas - oferecem um acesso total, transformando cada momento íntimo numa experiência de puro prazer.</p> <p>Use-as com confiança para revelar o seu lado <strong>mais sexy</strong> e provocante. A rede vermelha semi-transparente revela subtilmente a sua pele, preservando o mistério que faz subir a temperatura a cada olhar.</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-rot
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kokkino
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-red
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-rojo
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-rouge
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-rosso
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-rood
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-vermelho
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
latexboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-rot
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kokkino
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-red
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-rojo
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-rouge
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-rosso
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-rood
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-vermelho
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
legsboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-rot
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kokkino
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-red
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-rojo
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-rouge
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-rosso
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-rood
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-vermelho
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
lustboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-rot
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kokkino
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-red
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-rojo
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-rouge
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-rosso
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-rood
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-vermelho
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-rot
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-kokkino
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-red
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-rojo
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-rouge
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-rosso
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-rood
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-vermelho
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
name
stringP5091 culotte ouverte
netweight
string
nextshipment
stringtoday
ordered
number3
orderidx
number0
origin
string
originalsize
string
packaging
string
productshipment
stringauto
productuid
string7E8FB423-5E88-4D19-B5342DB1AB0126FD
promountil
string
rating
stringnone
recorduid
string7E8FB423-5E88-4D19-B5342DB1AB0126FD
reference
stringSBGA1591
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.2 ms
Record Count: 2
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,'1245,1244') > 0
and product_variations.productuid = '7E8FB423-5E88-4D19-B5342DB1AB0126FD'
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
1124542-44intlsizered4244-19999990wpluslingerieXL-2XL42-4442-4416-1820-2244-4644-4642-4448-5044-4642-4492-10074-8298-106
2124446-48intlsizered4648-19999990wpluslingerie3XL-4XL46-4846-4816-1820-2248-5048-5046-4852-5448-5046-48110-11696-102116-122
sizeranges
stringplus
sizes
string1245,1244
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: 3.29 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 = '7E8FB423-5E88-4D19-B5342DB1AB0126FD'
and product_variations.isactive = 1
and product_sizes.id_size = 1245
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 = '7E8FB423-5E88-4D19-B5342DB1AB0126FD'
and product_variations.isactive = 1
and product_sizes.id_size = 1244
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
17E8FB423-5E88-4D19-B5342DB1AB0126FD244B7131-4EFC-420C-AB2A78D166624AC51245red#F50000XL-2XL42-4442-4416-1820-2244-4644-4642-4448-5044-4642-44wlingerie42-44intlsize14.958310.7917STOCK01000-10200P5091-2P5091-2P1117-10all
27E8FB423-5E88-4D19-B5342DB1AB0126FDCC95EC3A-058E-46BE-86E566557D76A5BA1244red#F500003XL-4XL46-4846-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie46-48intlsize14.958310.7917STOCK01000-11100P5091-2P5091-2P1119-10all
subcategory
stringopenpanty
supplier
number-1
supplierreference
stringP5091
tags
string
themes
stringhot,sexystrings
totalvariations
string
type
stringdefault
unitprice
number10.7917
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 4.03 ms
Record Count: 2
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 = '7E8FB423-5E88-4D19-B5342DB1AB0126FD' 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 = '7E8FB423-5E88-4D19-B5342DB1AB0126FD' 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 = '7E8FB423-5E88-4D19-B5342DB1AB0126FD' 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 = '7E8FB423-5E88-4D19-B5342DB1AB0126FD' 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 = '7E8FB423-5E88-4D19-B5342DB1AB0126FD' 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 = '7E8FB423-5E88-4D19-B5342DB1AB0126FD' 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 = '7E8FB423-5E88-4D19-B5342DB1AB0126FD'
and product_variations.isactive = 1
and product_sizes.id_size = 1245
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 = '7E8FB423-5E88-4D19-B5342DB1AB0126FD' 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 = '7E8FB423-5E88-4D19-B5342DB1AB0126FD' 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 = '7E8FB423-5E88-4D19-B5342DB1AB0126FD' 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 = '7E8FB423-5E88-4D19-B5342DB1AB0126FD' 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 = '7E8FB423-5E88-4D19-B5342DB1AB0126FD' 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 = '7E8FB423-5E88-4D19-B5342DB1AB0126FD' 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 = '7E8FB423-5E88-4D19-B5342DB1AB0126FD'
and product_variations.isactive = 1
and product_sizes.id_size = 1244
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
1244B7131-4EFC-420C-AB2A78D166624AC51245red#F50000XL-2XL42-4442-4416-1820-2244-4644-4642-4448-5044-4642-44wlingerie42-44intlsize14.958310.7917STOCK01000-10200P5091-2P5091-2P1117-10-10-10110.7917all
2CC95EC3A-058E-46BE-86E566557D76A5BA1244red#F500003XL-4XL46-4846-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie46-48intlsize14.958310.7917STOCK01000-11100P5091-2P5091-2P1119-10-10-10110.7917all
vatrate
number20
warehouse
string