Mein Warenkorb

❌
Gesamtartikel
Zum Warenkorb
Menü
Siehe Größen
Ensemble Nova Blacklight - Zart, Göttlich und Gefährlich
Doppelklicken Sie zum Vergrößern
SKU: SBBU9331
Ensemble Nova Blacklight - Zart, Göttlich und Gefährlich
Lager:

Verkörpern Sie zarte, göttliche und gefährliche Perfektion mit dem Nova Blacklight Set!

diese revolutionäre Kreation aus fluoreszierender, bestickter Spitze und dehnbarer Maschenware schmiegt sich an Ihre natürlichen Kurven und bringt sie zum Strahlen.

Mit einem BH mit durchsichtigen Cups, einem Rock mit offenem Rücken und einem passenden String verwandelt dieses Set jeden Auftritt in eine leuchtende Show.

Highlights / Vorteile

  • Exklusive fluoreszierende Spitze, die unter UV-Licht leuchtet
  • Transparente, bewehrte Cups mit gewagten Riemenausschnitten
  • Zerbrechlicher Frontverschluss für verspielte Verführungsspiele
  • Hochtaillierter Rock mit spektakulärem Open-Back-Detail
  • Passender Mesh-String für ein perfekt abgestimmtes Ensemble
  • Verstellbare Träger, die sich an Ihre Körperform anpassen
  • Dehnbare Maschenware, die sich an Ihre natürlichen Kurven anschmiegt und sie betont
  • Einzigartiger Blacklight-Effekt, der Sie in eine leuchtende Göttin verwandelt
Größe:

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

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

Anzug Nova Blacklight in Übergröße mit fluoreszierendem Effekt

Produktbeschreibung

Das Nova Blacklight Set revolutioniert die Kunst der Verführung mit seiner exklusiven fluoreszierenden bestickten Spitze, die Sie unter UV-Licht in eine leuchtende Göttin verwandelt. Die technische Innovation schafft ein atemberaubendes visuelles Spektakel, das alle Blicke auf sich zieht.

Die transparenten, bewehrten Cups mit Riemenausschnitten formen ein perfektes Dekolleté, während sie Ihre Haut mit raffinierter Kühnheit enthüllen.

Das technische Design passt sich natürlich jeder Körperform an und sorgt für einen optimalen Push-up-Effekt, der Ihre Vorzüge elegant hervorhebt.

Der Frontverschluss fügt eine spielerische Dimension hinzu, die Momente der schrittweisen Enthüllung ermöglicht. Sie steuern den Grad der Verführung mit absoluter Raffinesse.

Der hochgeschnittene Rock mit Open-Back-Detail revolutioniert die Codes, indem er eine spektakuläre moderne Silhouette kreiert. Das Design enthüllt die sinnliche Kurve Ihres Rückens und modelliert gleichzeitig Ihre Hüften mit Präzision.

Die dehnbare Maschenware schmiegt sich sanft an Ihre natürlichen Kurven wie eine perfekte zweite Haut. Das technische Material passt sich perfekt an jede Körperform an und garantiert den ganzen Abend lang höchsten Tragekomfort.

Der passende String aus Maschenware rundet das außergewöhnliche Ensemble harmonisch ab. Die perfekte Abstimmung offenbart Ihre Liebe zum Detail und verwandelt jeden Auftritt in einen Moment purer Faszination. Wenn Sie das Nova Blacklight Set tragen, werden Sie zart, göttlich und gefährlich - ein faszinierendes Wesen, das mit seinem geheimnisvollen Leuchten und seiner unwiderstehlichen magnetischen Aura hypnotisiert.

Technische Details

  • Set: Dreiteilig (BH, Rock, String)
  • Spezialeffekt: Spitze fluoreszierend blacklight UV
  • BH: Transparente, armierte Körbchen mit Riemen
  • Rock: Hohe Taille mit spektakulär offenem Rücken
  • String: Koordinierte, passende Maschenware
  • Träger: Verstellbar für individuellen Komfort.
  • Verschlüsse: Frontseitig zerbrechlich für verspielte Spiele
  • Material: Bestickte Spitze und dehnbare Maschenware

Verfügbare Größen

Erhältlich von 1X/2X- bis 3X/4X

Verfügbare Farbe

Neonpink

Größenanleitung

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

International
  • Brust
  • Größe
  • Hüften
1X/2X-
  • 104-110
  • 86-91
  • 112-120
3X/4X+
  • 128-132
  • 102-108
  • 132-138
XL
  • 99-104
  • 81-86
  • 107-112
1X/2X
  • 112-118
  • 92-96
  • 122-128
3X/4X
  • 120-128
  • 98-102
  • 128-132

Pflegehinweise

  • Handwäsche mit kaltem Wasser, um den fluoreszierenden Effekt zu erhalten
  • Verwenden Sie ein mildes Waschmittel ohne Bleichmittel
  • Liegend trocknen, um die Form der Bügel zu erhalten
  • Niemals direkt über die fluoreszierende Spitze bügeln
  • Vorsichtig mit dem zerbrechlichen Verschluss umgehen
  • Vor direktem Licht geschützt aufbewahren, um den Glanz zu erhalten

Anwendungstipps

Ziehen Sie dieses Set sanft an und achten Sie dabei auf die fluoreszierende Spitze, die unter UV-Licht ihre Magie entfaltet. Die verstellbaren Träger lassen sich so positionieren, dass sie Ihren Brüsten den optimalen Halt geben.

Der zerbrechliche Verschluss lässt sich sanft bedienen, um Momente der allmählichen Enthüllung zu schaffen. Der hochgeschnittene Rock schmiegt sich natürlich an Ihre Hüften, während der offene Rücken Ihre Sinnlichkeit enthüllt. Dank der dehnbaren Maschenware und der vielfältigen Anpassungsmöglichkeiten passt sich dieses Set jeder Körperform an.

Lassen Sie Ihre geheimnisvolle Seite zum Ausdruck kommen mit dieser Kreation, die jeden Abend in ein leuchtendes Spektakel verwandelt.

Styling-Tipps

Veredeln Sie Ihr Nova Blacklight-Outfit mit unseren fluoreszierenden Strümpfen in Über größe für einen kompletten Look, oder fügen Sie einen transparenten Kimono in Übergröße für kontrastreiche Eleganz hinzu. Erkunden Sie unsere Sex-Outfits in großen Größen, um leuchtende Überlagerungen zu kreieren, oder entdecken Sie unsere Bodys in großen Größen aus der gleichen Kollektion, um die Effekte zu variieren. Diese einzigartige Kreation enthüllt Ihre geheimnisvolle Seite mit leuchtender Raffinesse.

To Top
Zum Warenkorb
Artikel
Gesamtartikel
Struct
Entries: 108
actions
Array
available
number-1
brand
stringhouseofdesire
brandcode
stringhecs
branding
stringdivasboudoir
brandmedias
string{"default":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"editorial":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"logo":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""}}
brandmetas
Struct
de
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
el
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
en
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
es
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
fr
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
it
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
nl
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
pt
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
brandname
stringHouse of Desire
breasts
stringna
careinstructions
string
categories
stringdivasboudoir.lingerie.sexylingerie.bustier,divasboudoir.lingerie.sexylingerie.set
category
stringsexylingerie
categorygender
stringf
categorymediadatas
Struct
adult
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string276
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/lingerie/sexylingerie/bustier.jpg
type
stringimg
width
string600
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.89 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,'fluorose') > 0
and product_variations.productuid = '95C76FC0-32E6-4E48-BAA06C790E720594'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1fluorosecolorfpinfluorosepink#FA22A0-10
colorrange
stringpink
colors
stringfluorose
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-07-21 19:14:04'}
defect
number0
dimensions
Struct
Entries: 14
acrylicbones
string
backsideheight
string
diameter
string
flatsteelbones
string
frontsideheight
string
fullheight
string
length
string
modestysize
string
panels
string
sides
string
spiralsteelbones
string
totallength
string
unit
stringcm
wiresize
string
display
stringall
displayfrom
string
displayto
string
grossweight
string
hasbrandinfos
booleanfalse
hascareinstructions
booleantrue
hascolorinfos
booleantrue
hascompositions
booleanfalse
hasdescription
booleantrue
hasdimensions
booleanfalse
hasmaterials
booleanfalse
hasotherspecifications
booleanfalse
haspromo
number0
hasshortdescription
booleantrue
hassizeinfos
booleantrue
hasspecifications
booleantrue
hasstockinfos
booleanfalse
hasstylingtips
booleantrue
hasusageinstructions
booleantrue
hasvariations
booleantrue
import
string
inpromo
number0
instockvariations
string
isactive
number1
iscustommade
number0
isdivasize
number0
isfirstprice
number0
isfixedprice
number0
ishot
number0
isnew
number0
isonline
number0
isoutletprice
number0
itemprice
number63.2917
itempromo
string
key
stringensemble-nova-rose
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-08-07 11:59:32'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.833 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('95c76fc0-32e6-4e48-baa06c790e720594',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.59 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 <> 'SBBU9331'
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
string1560
isprivate
string0
rating
stringall
src
string/photobank/products/hecs/sbbu9331/ensemble-grande-taille-fluorescent1.jpg
type
stringimg
width
string1079
back
Struct
height
string834
isprivate
string0
rating
stringall
src
string/photobank/products/hecs/sbbu9331/ensemble-grande-taille-fluorescent.jpg
type
stringimg
width
string577
default
Struct
height
string837
isprivate
string0
rating
stringall
src
string/photobank/products/hecs/sbbu9331/ensemble-grande-taille-fluorescent3.jpg
type
stringimg
width
string579
variations
Struct
colors
Struct
fluorose
Struct
height
string834
isprivate
string0
rating
stringall
src
string/photobank/products/hecs/sbbu9331/ensemble-grande-taille-fluorescent.jpg
type
stringimg
width
string577
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
mediagallery
string
metadatas
Struct
darkboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-neonpink
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-roz-neon
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-fluo-rose
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-rosa-neon
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-rose-fluo
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-rosa-neon
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-neonroze
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-rosa-neon
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
divasboudoir
Struct
de
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Handwäsche mit kaltem Wasser, um den fluoreszierenden Effekt zu erhalten</li> <li>Verwenden Sie ein mildes Waschmittel ohne Bleichmittel</li> <li>Liegend trocknen, um die Form der Bügel zu erhalten</li> <li>Niemals direkt über die fluoreszierende Spitze bügeln</li> <li>Vorsichtig mit dem zerbrechlichen Verschluss umgehen</li> <li>Vor direktem Licht geschützt aufbewahren, um den Glanz zu erhalten</li> </ul>
description
string<p>Das Nova Blacklight Set revolutioniert die Kunst der Verführung mit seiner <strong>exklusiven fluoreszierenden bestickten Spitze</strong>, die Sie unter UV-Licht in eine leuchtende Göttin verwandelt. Die technische Innovation schafft ein atemberaubendes visuelles Spektakel, das alle Blicke auf sich zieht.</p> <p>Die <strong>transparenten, bewehrten Cups mit Riemenausschnitten</strong> formen ein perfektes Dekollet&eacute;, während sie Ihre Haut mit raffinierter Kühnheit enthüllen.</p> <p>Das technische Design <strong>passt sich natürlich jeder Körperform an</strong> und sorgt für einen optimalen Push-up-Effekt, der Ihre Vorzüge elegant hervorhebt.</p> <p>Der <strong>Frontverschluss</strong> fügt eine spielerische Dimension hinzu, die Momente der schrittweisen Enthüllung ermöglicht. Sie steuern den Grad der Verführung mit absoluter Raffinesse.</p> <p>Der <strong>hochgeschnittene Rock mit Open-Back-Detail</strong> revolutioniert die Codes, indem er eine spektakuläre moderne Silhouette kreiert. Das Design enthüllt die sinnliche Kurve Ihres Rückens und modelliert gleichzeitig Ihre Hüften mit Präzision.</p> <p>Die <strong>dehnbare Maschenware</strong> schmiegt sich sanft an Ihre natürlichen Kurven wie eine perfekte zweite Haut. Das technische Material <strong>passt sich perfekt an jede Körperform</strong> an und garantiert den ganzen Abend lang höchsten Tragekomfort.</p> <p>Der <strong>passende String aus Maschenware</strong> rundet das außergewöhnliche Ensemble harmonisch ab. Die perfekte Abstimmung offenbart Ihre Liebe zum Detail und verwandelt jeden Auftritt in einen Moment purer Faszination. Wenn Sie das Nova Blacklight Set tragen, werden Sie zart, göttlich und gefährlich - ein faszinierendes Wesen, das mit seinem geheimnisvollen Leuchten und seiner unwiderstehlichen magnetischen Aura hypnotisiert.</p>
guid
stringhttps://dev.divasboudoir.com/de/set-in-großen-Größen-nova-blacklight-fluoreszierende-Spitze/sbbu9331.htm
highlights
string<ul> <li><strong>Exklusive fluoreszierende Spitze</strong>, die unter UV-Licht leuchtet</li> <li><strong>Transparente, bewehrte Cups</strong> mit gewagten Riemenausschnitten</li> <li><strong>Zerbrechlicher Frontverschluss</strong> für verspielte Verführungsspiele</li> <li><strong>Hochtaillierter Rock</strong> mit spektakulärem Open-Back-Detail</li> <li><strong>Passender Mesh-String</strong> für ein perfekt abgestimmtes Ensemble</li> <li><strong>Verstellbare Träger</strong>, die sich an Ihre Körperform anpassen</li> <li><strong>Dehnbare Maschenware</strong>, die sich an Ihre natürlichen Kurven anschmiegt und sie betont</li> <li><strong>Einzigartiger Blacklight-Effekt</strong>, der Sie in eine leuchtende Göttin verwandelt</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringNova Blacklight-Set in großen Größen: UV-fluoreszierende Spitze, Bügel-BH, Rock mit offenem Rücken, passender String. Zart, göttlich, gefährlich | Diva's Boudoir
keywords
string
title
stringNova Blacklight Set in großen Größen fluoreszierend | Diva's Boudoir
seotitle
stringAnzug Nova Blacklight in Übergröße mit fluoreszierendem Effekt
seouri
stringset-in-großen-Größen-nova-blacklight-fluoreszierende-Spitze
specifications
string<ul> <li><strong>Set:</strong> Dreiteilig (BH, Rock, String)</li> <li><strong>Spezialeffekt:</strong> Spitze fluoreszierend blacklight UV</li> <li><strong>BH:</strong> Transparente, armierte Körbchen mit Riemen</li> <li><strong>Rock:</strong> Hohe Taille mit spektakulär offenem Rücken</li> <li><strong>String:</strong> Koordinierte, passende Maschenware</li> <li><strong>Träger:</strong> Verstellbar für individuellen Komfort.</li> <li><strong>Verschlüsse:</strong> Frontseitig zerbrechlich für verspielte Spiele</li> <li><strong>Material:</strong> Bestickte Spitze und dehnbare Maschenware</li> </ul>
stylingtips
string<p>Veredeln Sie Ihr Nova Blacklight-Outfit mit unseren fluoreszierenden <a href="https://www.divasboudoir.com/de/strumpfe-in-grossen-grossen/">Strümpfen in Über</a> größe für einen kompletten Look, oder fügen Sie einen transparenten <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">Kimono in Übergröße</a> für kontrastreiche Eleganz hinzu. Erkunden Sie unsere <a href="https://www.divasboudoir.com/fr/tenues-sexy-grande-taille/">Sex-Outfits in großen Größen,</a> um leuchtende Überlagerungen zu kreieren, oder entdecken Sie unsere <a href="https://www.divasboudoir.com/de/body-in-ubergrosse/">Bodys in großen Größen</a> aus der gleichen Kollektion, um die Effekte zu variieren. Diese einzigartige Kreation enthüllt Ihre geheimnisvolle Seite mit leuchtender Raffinesse.</p>
summary
string<p>Verkörpern Sie zarte, göttliche und gefährliche Perfektion mit dem Nova Blacklight Set!</p> <p>diese revolutionäre Kreation aus fluoreszierender, bestickter Spitze und dehnbarer Maschenware schmiegt sich an Ihre natürlichen Kurven und bringt sie zum Strahlen.</p> <p>Mit einem BH mit durchsichtigen Cups, einem Rock mit offenem Rücken und einem passenden String verwandelt dieses Set jeden Auftritt in eine leuchtende Show.</p>
title
stringEnsemble Nova Blacklight - Zart, Göttlich und Gefährlich
usageinstructions
string<p>Ziehen Sie dieses Set sanft an und achten Sie dabei auf die fluoreszierende Spitze, die unter UV-Licht ihre Magie entfaltet. Die verstellbaren Träger lassen sich so positionieren, dass sie Ihren Brüsten den optimalen Halt geben.</p> <p>Der <strong>zerbrechliche Verschluss lässt sich sanft bedienen,</strong> um Momente der allmählichen Enthüllung zu schaffen. Der hochgeschnittene Rock schmiegt sich natürlich an Ihre Hüften, während der offene Rücken Ihre Sinnlichkeit enthüllt. Dank der dehnbaren Maschenware und der vielfältigen Anpassungsmöglichkeiten <strong>passt sich</strong> dieses Set <strong>jeder Körperform</strong> an.</p> <p>Lassen Sie Ihre geheimnisvolle Seite zum Ausdruck kommen mit dieser Kreation, die jeden Abend in ein leuchtendes Spektakel verwandelt.</p>
el
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Πλύνετε στο χέρι με κρύο νερό για να διατηρήσετε το φθορίζον αποτέλεσμα</li> <li>Χρησιμοποιήστε ήπιο απορρυπαντικό χωρίς λευκαντικούς παράγοντες</li> <li>Στεγνώστε σε επίπεδη επιφάνεια για να διατηρήσετε το σχήμα των κορδονιών</li> <li>Ποτέ μην σιδερώνετε απευθείας πάνω σε φθορίζουσες δαντέλες</li> <li>Να χειρίζεστε το εύθραυστο κούμπωμα με προσοχή</li> <li>Αποθηκεύστε μακριά από το άμεσο φως για να διατηρήσετε τη λάμψη</li> </ul>
description
string<p>Το σετ Nova Blacklight φέρνει την επανάσταση στην τέχνη της αποπλάνησης με την <strong>αποκλειστική φθορίζουσα κεντημένη δαντέλα</strong> που σας μεταμορφώνει σε μια φωτεινή θεά κάτω από το υπεριώδες φως. Η τεχνική καινοτομία δημιουργεί ένα εντυπωσιακό οπτικό θέαμα που αιχμαλωτίζει το μάτι.</p> <p>Τα <strong>διαφανή σουτιέν με μπανέλα και κοψίματα από λουράκια</strong> σμιλεύουν ένα τέλειο ντεκολτέ, ενώ αποκαλύπτουν το δέρμα σας με εκλεπτυσμένη τόλμη.</p> <p>Ο τεχνικός σχεδιασμός <strong>ενισχύει φυσικά όλα τα σχήματα σώματος</strong>, δημιουργώντας ένα βέλτιστο push-up αποτέλεσμα που αναδεικνύει κομψά τα προτερήματά σας.</p> <p>Το <strong>μπροστινό κούμπωμα</strong> προσθέτει μια παιχνιδιάρικη διάσταση για στιγμές προοδευτικής αποκάλυψης. Ελέγχετε το επίπεδο αποπλάνησης με απόλυτη εκλέπτυνση.</p> <p>Η <strong>ψηλόμεση φούστα με ανοιχτή λεπτομέρεια στην πλάτη</strong> φέρνει επανάσταση στους κώδικες δημιουργώντας μια εντυπωσιακή μοντέρνα σιλουέτα. Ο σχεδιασμός αποκαλύπτει την αισθησιακή καμπύλη της πλάτης σας, ενώ σμιλεύει τους γοφούς σας με ακρίβεια.</p> <p>Η <strong>ελαστική πλέξη</strong> αγκαλιάζει απαλά τις φυσικές σας καμπύλες σαν ένα τέλειο δεύτερο δέρμα. Το τεχνικό υλικό <strong>προσαρμόζεται τέλεια σε όλα τα σχήματα του σώματος</strong>, εξασφαλίζοντας βέλτιστη άνεση όλο το βράδυ.</p> <p>Το <strong>ασορτί διχτυωτό στρινγκ</strong> ολοκληρώνει αυτό το εξαιρετικό σύνολο. Ο τέλειος συντονισμός αποκαλύπτει την προσοχή σας στη λεπτομέρεια και μετατρέπει κάθε σας εμφάνιση σε μια στιγμή απόλυτης γοητείας. Όταν φοράτε το σετ Nova Blacklight, γίνεστε ντελικάτη, θεϊκή και επικίνδυνη - ένα συναρπαστικό πλάσμα που μαγνητίζει με τη μυστηριώδη λάμψη και την ακαταμάχητη μαγνητική του αύρα.</p>
guid
stringhttps://dev.divasboudoir.com/el/nova-blacklight-megalo-megethos-fthorIzon-set-dantelas-fthorIsmoy/sbbu9331.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> <li><strong>Stretch πλέγμα</strong> που αγκαλιάζει και αναδεικνύει τις φυσικές σας καμπύλες</li> <li><strong>Μοναδικό εφέ μαύρου φωτός</strong> που σας μεταμορφώνει σε μια φωτεινή θεά</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringNova Blacklight plus size σετ: φθορίζουσα UV δαντέλα, σουτιέν με μπανέλα, φούστα με ανοιχτή πλάτη, ασορτί στρινγκ. Ντελικάτο, θεϊκό, επικίνδυνο | Diva's Boudoir
keywords
string
title
stringNova Blacklight μεγάλο σετ φθορισμού | Diva's Boudoir
seotitle
stringNova Blacklight μεγάλο σετ φθορισμού
seouri
stringnova-blacklight-μεγάλο-μέγεθος-φθορίζον-σετ-δαντέλας-φθορισμού
specifications
string<ul> <li><strong>Σετ:</strong> Τριμερές (σουτιέν, φούστα, στρινγκ)</li> <li><strong>Ειδικό εφέ:</strong> UV φθορίζουσα δαντέλα με μαύρο φως</li> <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>
stylingtips
string<p>Ενισχύστε το σετ Nova Blacklight με τα φθορίζοντα <a href="https://www.divasboudoir.com/el/kaltses-megaloy-megethoys/">σλιπ</a> μας <a href="https://www.divasboudoir.com/el/kaltses-megaloy-megethoys/">για</a> ένα ολοκληρωμένο λουκ ή προσθέστε ένα διάφανο <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">κιμονό</a> για κομψότητα σε αντίθεση. Εξερευνήστε τα <a href="https://www.divasboudoir.com/fr/tenues-sexy-grande-taille/">σέξι plus size σύνολά</a> μας για να δημιουργήσετε φωτεινές επικαλύψεις ή ανακαλύψτε τα <a href="https://www.divasboudoir.com/el/kormaki-syn-megethos/">plus size κορμάκια</a> μας από την ίδια συλλογή για να διαφοροποιήσετε το αποτέλεσμα. Αυτή η μοναδική δημιουργία αποκαλύπτει τη μυστηριώδη πλευρά σας με φωτεινή εκλέπτυνση.</p>
summary
string<p>Ενσαρκώστε τη λεπτή, θεϊκή και επικίνδυνη τελειότητα με το σετ Nova Blacklight!</p> <p>αυτή η επαναστατική δημιουργία από φθορίζουσα κεντημένη δαντέλα και ελαστικό πλέγμα αγκαλιάζει και αναδεικνύει τις φυσικές σας καμπύλες.</p> <p>Με το σουτιέν με διάφανο cup, τη φούστα με ανοιχτή πλάτη και το ασορτί στρινγκ, αυτό το σετ μετατρέπει κάθε σας εμφάνιση σε ένα light show.</p>
title
stringEnsemble Nova Blacklight - Ντελικάτο, Θεϊκό και Επικίνδυνο
usageinstructions
string<p>Φορέστε απαλά αυτό το σετ, προσέχοντας τη φθορίζουσα δαντέλα που αποκαλύπτει τη μαγεία της κάτω από το υπεριώδες φως. Οι ρυθμιζόμενες τιράντες τοποθετούνται έτσι ώστε να δημιουργούν τη βέλτιστη στήριξη για το μπούστο σας.</p> <p>Το <strong>αποσπώμενο κούμπωμα μπορεί να χειριστεί απαλά</strong> για να δημιουργήσει εκείνες τις στιγμές σταδιακής αποκάλυψης. Η ψηλόμεση φούστα αγκαλιάζει φυσικά τους γοφούς σας, ενώ η ανοιχτή πλάτη αποκαλύπτει τον αισθησιασμό σας. Αυτό το σετ <strong>προσαρμόζεται σε όλα τα σχήματα του σώματος</strong> χάρη στην ελαστική πλέξη και τις πολλαπλές επιλογές ρύθμισης.</p> <p>Αφήστε τη μυστηριώδη πλευρά σας να λάμψει με αυτή τη δημιουργία που μετατρέπει κάθε βράδυ σε ένα σόου φωτός.</p>
en
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Hand wash in cold water to preserve fluorescent effect</li> <li>Use a mild detergent without bleaching agents</li> <li>Dry flat to maintain the shape of the underwires</li> <li>Never iron directly on fluorescent lace</li> <li>Handle breakable clasp with care</li> <li>Store away from direct light to preserve radiance</li> </ul>
description
string<p>The Nova Blacklight set revolutionizes the art of seduction with <strong>exclusive fluorescent embroidered lace</strong> that transforms you into a luminous goddess under UV light. Technical innovation creates an eye-catching visual spectacle.</p> <p><strong>Transparent underwired cups with strap cut-outs</strong> sculpt a perfect d&eacute;collet&eacute; while revealing your skin with sophisticated audacity.</p> <p>The technical design <strong>naturally enhances all body types</strong>, creating an optimal push-up effect that elegantly highlights your assets.</p> <p>The <strong>front clasp</strong> adds a playful dimension for moments of progressive revelation. You control the level of seduction with absolute sophistication.</p> <p>The <strong>high-waisted skirt with open back detail</strong> revolutionizes codes by creating a spectacular modern silhouette. The design reveals the sensual curve of your back while sculpting your hips with precision.</p> <p>The <strong>stretch knit</strong> delicately hugs your natural curves like a perfect second skin. The technical material <strong>adapts perfectly to all morphologies</strong>, guaranteeing optimal comfort all evening long.</p> <p>The <strong>matching mesh thong</strong> harmoniously completes this exceptional ensemble. The perfect coordination reveals your attention to detail and turns every appearance into a moment of pure fascination. When you wear the Nova Blacklight set, you become delicate, divine and dangerous - a fascinating creature that hypnotizes with its mysterious luminescence and irresistible magnetic aura.</p>
guid
stringhttps://dev.divasboudoir.com/en/plus-size-set-nova-blacklight-fluorescent-lace/sbbu9331.htm
highlights
string<ul> <li><strong>Exclusive fluorescent lace</strong> glows under UV light</li> <li><strong>Transparent underwired cups</strong> with bold strap cut-outs</li> <li><strong>Front snap clasp</strong> for playful seduction games</li> <li><strong>High-waisted skirt</strong> with spectacular open back detail</li> <li><strong>Matching mesh thong</strong> for a perfectly coordinated ensemble</li> <li><strong>Adjustable straps</strong> to suit your body shape</li> <li><strong>Stretch mesh</strong> hugs and enhances your natural curves</li> <li><strong>Unique blacklight effect</strong> transforms you into a luminous goddess</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringNova Blacklight plus size set: fluorescent UV lace, underwired bra, open back skirt, matching thong. Delicate, divine, dangerous | Diva's Boudoir
keywords
string
title
stringNova Blacklight plus size fluorescent set | Diva's Boudoir
seotitle
stringNova Blacklight fluorescent effect plus size set
seouri
stringplus-size-set-nova-blacklight-fluorescent-lace
specifications
string<ul> <li><strong>Set:</strong> Three-piece (bra, skirt, thong)</li> <li><strong>Special effect:</strong> Blacklight UV fluorescent lace</li> <li><strong>Bra:</strong> Transparent underwired cups with straps</li> <li><strong>Skirt:</strong> High waist with spectacular open back</li> <li><strong>G-string</strong>: Matching mesh</li> <li><strong>Straps</strong>: Adjustable for personalized comfort</li> <li><strong>Clasp :</strong> Breakable front for playful games</li> <li><strong>Material:</strong> Embroidered lace and stretch mesh</li> </ul>
stylingtips
string<p>Enhance your Nova Blacklight set with our fluorescent <a href="https://www.divasboudoir.com/en/socks-large-size/">plus-size stockings</a> for a complete look, or add a sheer <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">plus-size kimono</a> for contrasting elegance. Explore our <a href="https://www.divasboudoir.com/fr/tenues-sexy-grande-taille/">sexy plus size outfits</a> to create luminous overlays, or discover our <a href="https://www.divasboudoir.com/en/plus-size-body/">plus size bodysuits</a> from the same collection to vary the effects. This unique creation reveals your mysterious side with luminous sophistication.</p>
summary
string<p>Embody delicate, divine and dangerous perfection with the Nova Blacklight set!</p> <p>this revolutionary creation in fluorescent embroidered lace and stretch mesh embraces and sublimates your natural curves.</p> <p>With its transparent-cup bra, open-back skirt and matching thong, this set transforms every appearance into a luminous spectacle.</p>
title
stringEnsemble Nova Blacklight - Delicate, Divine and Dangerous
usageinstructions
string<p>Gently slip on this set, taking care of the fluorescent lace that reveals its magic under UV light. Adjustable straps position to create optimal support for your breasts.</p> <p>The <strong>breakaway clasp is gently manipulated</strong> to create those moments of progressive revelation. The high-waisted skirt naturally hugs your hips, while the open back reveals your sensuality. This set <strong>adapts to all body types</strong> thanks to its stretch mesh and multiple adjustment possibilities.</p> <p>Let your mysterious side shine through with this creation that transforms every evening into a luminous spectacle.</p>
es
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavar a mano en agua fría para conservar el efecto fluorescente</li> <li>Utilizar un detergente suave sin blanqueantes</li> <li>Secar en plano para mantener la forma de los aros</li> <li>Nunca planchar directamente sobre el encaje fluorescente</li> <li>Manipule con cuidado el broche rompible</li> <li>Guárdelo lejos de la luz directa para conservar el brillo</li> </ul>
description
string<p>El conjunto Nova Blacklight revoluciona el arte de la seducción con su <strong>exclusivo encaje bordado fluorescente</strong> que te transforma en una diosa luminosa bajo la luz ultravioleta. La innovación técnica crea un impactante espectáculo visual que cautiva la mirada.</p> <p><strong>Las copas transparentes con aros y recortes para los tirantes</strong> esculpen un escote perfecto al tiempo que revelan su piel con sofisticada audacia.</p> <p>El diseño técnico <strong>realza de forma natural todas las formas del cuerpo</strong>, creando un efecto push-up óptimo que resalta con elegancia sus activos.</p> <p>El <strong>cierre frontal</strong> añade una dimensión lúdica para los momentos de revelación progresiva. Controla el nivel de seducción con absoluta sofisticación.</p> <p>La <strong>falda de talle alto con detalle de espalda abierta</strong> revoluciona los códigos creando una silueta moderna y espectacular. El diseño revela la sensual curva de tu espalda a la vez que esculpe tus caderas con precisión.</p> <p>El <strong>punto elástico</strong> abraza suavemente tus curvas naturales como una segunda piel perfecta. El material técnico <strong>se adapta perfectamente a todas las formas del cuerpo</strong>, garantizando una comodidad óptima durante toda la noche.</p> <p>El <strong>tanga de malla a juego</strong> completa este conjunto excepcional. La perfecta coordinación revela tu atención al detalle y convierte cada aparición en un momento de pura fascinación. Cuando llevas el conjunto Nova Blacklight, te conviertes en delicada, divina y peligrosa: una criatura fascinante que hipnotiza con su misteriosa luminiscencia y su irresistible aura magnética.</p>
guid
stringhttps://dev.divasboudoir.com/es/nova-blacklight-talla-grande-juego-de-encaje-fluorescente/sbbu9331.htm
highlights
string<ul> <li><strong>Exclusivo encaje fluorescente</strong> que brilla bajo la luz ultravioleta</li> <li><strong>Copas transparentes con aros</strong> y atrevidos cortes en los tirantes</li> <li><strong>Broche de presión frontal</strong> para jugar a la seducción</li> <li><strong>Falda de talle alto</strong> con espectacular detalle de espalda abierta</li> <li><strong>Tanga de malla a juego</strong> para un conjunto perfectamente coordinado</li> <li><strong>Tirantes ajustables</strong> para adaptarse a tu figura</li> <li><strong>Malla elástica</strong> que abraza y realza tus curvas naturales</li> <li><strong>Exclusivo efecto de luz negra</strong> que te transforma en una diosa luminosa</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringConjunto de talla grande Nova Blacklight: encaje fluorescente UV, sujetador con aros, falda con espalda abierta, tanga a juego. Delicado, divino, peligroso | Diva's Boudoir
keywords
string
title
stringJuego fluorescente de talla grande Nova Blacklight | Diva's Boudoir
seotitle
stringJuego de efectos fluorescentes Nova Blacklight de talla grande
seouri
stringnova-blacklight-talla-grande-juego-de-encaje-fluorescente
specifications
string<ul> <li><strong>Conjunto:</strong> Tres piezas (sujetador, falda, tanga)</li> <li><strong>Efecto especial:</strong> Encaje fluorescente Blacklight UV</li> <li><strong>Sujetador:</strong> copas transparentes con aros y tirantes</li> <li><strong>Falda:</strong> Cintura alta con espectacular espalda abierta</li> <li><strong>Tanga</strong>: Malla a juego</li> <li><strong>Tirantes:</strong> Ajustables para mayor comodidad</li> <li><strong>Cierre :</strong> Frontal rompible para divertidos juegos</li> <li><strong>Material:</strong> Encaje bordado y malla elástica</li> </ul>
stylingtips
string<p>Mejora tu conjunto Nova Blacklight con nuestras <a href="https://www.divasboudoir.com/es/medias-grandes/">braguitas</a> fluorescentes <a href="https://www.divasboudoir.com/es/medias-grandes/">de talla grande</a> para completar el look, o añade un <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">kimono</a> transparente <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">de talla grande</a> para contrastar la elegancia. Explora nuestros <a href="https://www.divasboudoir.com/fr/tenues-sexy-grande-taille/">sexys conjuntos talla grande</a> para crear superposiciones luminosas, o descubre nuestros <a href="https://www.divasboudoir.com/es/body-tallas-grandes/">bodys talla</a> grande de la misma colección para variar el efecto. Esta creación única revela tu lado misterioso con una sofisticación luminosa.</p>
summary
string<p>¡Encarna la perfección delicada, divina y peligrosa con el conjunto Nova Blacklight!</p> <p>esta revolucionaria creación de encaje bordado fluorescente y malla elástica abraza y realza tus curvas naturales.</p> <p>Con su sujetador de copa transparente, falda con espalda abierta y tanga a juego, este conjunto convierte cada aparición en un espectáculo de luz.</p>
title
stringEnsemble Nova Blacklight - Delicado, divino y peligroso
usageinstructions
string<p>Deslice suavemente este conjunto, teniendo cuidado con el encaje fluorescente que revela su magia bajo la luz ultravioleta. Los tirantes ajustables se posicionan para crear el soporte óptimo para tu busto.</p> <p>El <strong>cierre se puede manipular suavemente</strong> para crear esos momentos de revelación gradual. La falda de talle alto ciñe las caderas con naturalidad, mientras que la espalda abierta revela su sensualidad. Este conjunto <strong>se adapta a todas las formas del cuerpo</strong> gracias a su punto elástico y a sus múltiples opciones de ajuste.</p> <p>Deja que brille tu lado misterioso con esta creación que convierte cada velada en un espectáculo de luces.</p>
fr
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavage &agrave; la main &agrave; l'eau froide pour pr&eacute;server l'effet fluorescent</li> <li>Utiliser une lessive douce sans agents blanchissants</li> <li>S&eacute;chage &agrave; plat pour maintenir la forme des armatures</li> <li>Ne jamais repasser directement sur la dentelle fluorescente</li> <li>Manipuler d&eacute;licatement le fermoir cassable</li> <li>Ranger &agrave; l'abri de la lumi&egrave;re directe pour pr&eacute;server l'&eacute;clat</li> </ul>
description
string<p>L'ensemble Nova Blacklight r&eacute;volutionne l'art de la s&eacute;duction avec sa <strong>dentelle brod&eacute;e fluorescente exclusive</strong> qui vous transforme en d&eacute;esse lumineuse sous les lumi&egrave;res UV. L'innovation technique cr&eacute;e un spectacle visuel saisissant qui captive tous les regards.</p> <p>Les&nbsp;<strong>bonnets transparents armatur&eacute;s avec d&eacute;coupes sangles</strong> sculptent un d&eacute;collet&eacute; parfait tout en r&eacute;v&eacute;lant votre peau avec audace sophistiqu&eacute;e.</p> <p>La conception technique&nbsp;<strong>sublime naturellement toutes les morphologies</strong>, cr&eacute;ant un effet push-up optimal qui met en valeur vos atouts avec &eacute;l&eacute;gance.</p> <p>Le&nbsp;<strong>fermoir frontal</strong> ajoute une dimension ludique qui permet des moments de r&eacute;v&eacute;lation progressive. Vous contr&ocirc;lez le niveau de s&eacute;duction avec une sophistication absolue.</p> <p>La&nbsp;<strong>jupe taille haute avec d&eacute;tail dos ouvert</strong> r&eacute;volutionne les codes en cr&eacute;ant une silhouette moderne spectaculaire. Le design r&eacute;v&egrave;le la courbe sensuelle de votre dos tout en sculptant vos hanches avec pr&eacute;cision.</p> <p>La&nbsp;<strong>maille extensible</strong> &eacute;pouse d&eacute;licatement vos courbes naturelles comme une seconde peau parfaite. Le mat&eacute;riau technique <strong>s'adapte parfaitement &agrave; toutes les morphologies</strong>, garantissant un confort optimal toute la soir&eacute;e.</p> <p>Le&nbsp;<strong>string maille assorti</strong> compl&egrave;te harmonieusement l'ensemble d'exception. La coordination parfaite r&eacute;v&egrave;le votre attention aux d&eacute;tails et transforme chaque apparition en moment de pure fascination. Quand vous portez l'ensemble Nova Blacklight, vous devenez d&eacute;licate, divine et dangereuse - une cr&eacute;ature fascinante qui hypnotise avec sa luminescence myst&eacute;rieuse et son aura magn&eacute;tique irr&eacute;sistible.</p>
guid
stringhttps://dev.divasboudoir.com/fr/ensemble-grande-taille-nova-blacklight-dentelle-fluorescente/sbbu9331.htm
highlights
string<ul> <li><strong>Dentelle fluorescente exclusive</strong> qui brille sous les lumi&egrave;res UV</li> <li><strong>Bonnets transparents armatur&eacute;s</strong> avec d&eacute;coupes sangles audacieuses</li> <li><strong>Fermoir cassable frontal</strong> pour des jeux de s&eacute;duction ludiques</li> <li><strong>Jupe taille haute</strong> avec d&eacute;tail dos ouvert spectaculaire</li> <li><strong>String maille assorti</strong> pour un ensemble parfaitement coordonn&eacute;</li> <li><strong>Bretelles ajustables</strong> qui s'adaptent &agrave; votre morphologie</li> <li><strong>Maille extensible</strong> qui &eacute;pouse et sublime vos courbes naturelles</li> <li><strong>Effet blacklight unique</strong> qui vous transforme en d&eacute;esse lumineuse</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringEnsemble Nova Blacklight grande taille : dentelle fluorescente UV, soutien-gorge armaturé, jupe dos ouvert, string assorti. Délicate, divine, dangereuse | Diva's Boudoir
keywords
string
title
stringEnsemble Nova Blacklight grande taille fluorescent | Diva's Boudoir
seotitle
stringEnsemble grande taille Nova Blacklight effet fluorescent
seouri
stringensemble-grande-taille-nova-blacklight-dentelle-fluorescente
specifications
string<ul> <li><strong>Ensemble :</strong> Trois pi&egrave;ces (soutien-gorge, jupe, string)</li> <li><strong>Effet sp&eacute;cial :</strong> Dentelle fluorescente blacklight UV</li> <li><strong>Soutien-gorge :</strong> Bonnets transparents armatur&eacute;s avec sangles</li> <li><strong>Jupe :</strong> Taille haute avec dos ouvert spectaculaire</li> <li><strong>String :</strong> Maille assortie coordonn&eacute;e</li> <li><strong>Bretelles :</strong> Ajustables pour confort personnalis&eacute;</li> <li><strong>Fermoir :</strong> Cassable frontal pour jeux ludiques</li> <li><strong>Mati&egrave;re :</strong> Dentelle brod&eacute;e et maille extensible</li> </ul>
stylingtips
string<p>Sublimez votre ensemble Nova Blacklight avec nos <a href="https://www.divasboudoir.com/fr/bas-grande-taille/">bas grande taille</a> fluorescents pour un look complet, ou ajoutez un <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">kimono grande taille</a> transparent pour une &eacute;l&eacute;gance contrast&eacute;e. Explorez nos <a href="https://www.divasboudoir.com/fr/tenues-sexy-grande-taille/">tenues sexys grande taille</a> pour cr&eacute;er des superpositions lumineuses, ou d&eacute;couvrez nos <a href="https://www.divasboudoir.com/fr/body-grande-taille/">bodys grande taille</a> de la m&ecirc;me collection pour varier les effets. Cette cr&eacute;ation unique r&eacute;v&egrave;le votre c&ocirc;t&eacute; myst&eacute;rieux avec une sophistication lumineuse.</p>
summary
string<p>Incarnez la perfection d&eacute;licate, divine et dangereuse avec l'ensemble Nova Blacklight !</p> <p>&nbsp;Cette cr&eacute;ation r&eacute;volutionnaire en dentelle brod&eacute;e fluorescente et maille extensible &eacute;pouse et sublime vos courbes naturelles.</p> <p>Avec son soutien-gorge &agrave; bonnets transparents, sa jupe dos ouvert et son string assorti, cet ensemble transforme chaque apparition en spectacle lumineux.</p>
title
stringEnsemble Nova Blacklight - Délicate, Divine et Dangereuse
usageinstructions
string<p>Enfilez d&eacute;licatement cet ensemble en prenant soin de la dentelle fluorescente qui r&eacute;v&egrave;le sa magie sous les lumi&egrave;res UV. Les bretelles ajustables se positionnent pour cr&eacute;er le maintien optimal de votre poitrine.</p> <p>Le&nbsp;<strong>fermoir cassable se manipule en douceur</strong> pour cr&eacute;er ces moments de r&eacute;v&eacute;lation progressive. La jupe taille haute &eacute;pouse naturellement vos hanches tandis que le dos ouvert r&eacute;v&egrave;le votre sensualit&eacute;. Cet ensemble <strong>s'adapte &agrave; toutes les morphologies</strong> gr&acirc;ce &agrave; sa maille extensible et ses multiples possibilit&eacute;s d'ajustement.</p> <p>Laissez votre c&ocirc;t&eacute; myst&eacute;rieux s'exprimer avec cette cr&eacute;ation qui transforme chaque soir&eacute;e en spectacle lumineux.</p>
it
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavare a mano in acqua fredda per preservare l'effetto fluorescente</li> <li>Utilizzare un detergente delicato senza agenti sbiancanti</li> <li>Asciugare in piano per mantenere la forma dei ferretti</li> <li>Non stirare mai direttamente sul pizzo fluorescente</li> <li>Maneggiare con cura il fermaglio che si rompe</li> <li>Conservare al riparo dalla luce diretta per preservare la brillantezza</li> </ul>
description
string<p>Il set Nova Blacklight rivoluziona l'arte della seduzione con il suo <strong>esclusivo pizzo ricamato fluorescente</strong> che vi trasforma in una dea luminosa sotto la luce UV. L'innovazione tecnica crea uno spettacolo visivo di grande impatto che cattura lo sguardo.</p> <p>Le <strong>coppe trasparenti con ferretto e spalline scol</strong> piscono un d&eacute;collet&eacute; perfetto, rivelando la pelle con sofisticata audacia.</p> <p>Il design tecnico <strong>valorizza in modo naturale tutte le forme del corpo</strong>, creando un effetto push-up ottimale che mette elegantemente in risalto il vostro patrimonio.</p> <p>La <strong>chiusura frontale</strong> aggiunge una dimensione giocosa per momenti di progressiva rivelazione. Controllate il livello di seduzione con assoluta raffinatezza.</p> <p>La <strong>gonna a vita alta con dettaglio posteriore aperto</strong> rivoluziona i codici creando una spettacolare silhouette moderna. Il design rivela la curva sensuale della schiena e scolpisce i fianchi con precisione.</p> <p>La <strong>maglia elasticizzata</strong> abbraccia delicatamente le vostre curve naturali come una perfetta seconda pelle. Il materiale tecnico <strong>si adatta perfettamente a tutte le forme del corpo</strong>, garantendo un comfort ottimale per tutta la serata.</p> <p>Il <strong>perizoma in rete abbinato</strong> completa questo insieme eccezionale. Il perfetto coordinamento rivela la vostra attenzione ai dettagli e trasforma ogni apparizione in un momento di puro fascino. Quando indossate il set Nova Blacklight, diventate delicate, divine e pericolose: una creatura affascinante che ipnotizza con la sua misteriosa luminescenza e l'irresistibile aura magnetica.</p>
guid
stringhttps://dev.divasboudoir.com/it/set-di-lacci-fluorescenti-nova-blacklight-taglia-grande/sbbu9331.htm
highlights
string<ul> <li><strong>Esclusivo pizzo fluorescente</strong> che si illumina ai raggi UV</li> <li><strong>Coppe trasparenti con ferretto</strong> e audaci aperture per le spalline</li> <li><strong>Chiusura frontale con bottoni a pressione</strong> per giocosi giochi di seduzione</li> <li><strong>Gonna a vita alta</strong> con spettacolare dettaglio aperto sulla schiena</li> <li><strong>Perizoma in rete abbinato</strong> per un insieme perfettamente coordinato</li> <li><strong>Spalline regolabili</strong> per adattarsi alle vostre forme</li> <li><strong>Rete elastica</strong> che abbraccia ed esalta le vostre curve naturali</li> <li><strong>L'esclusivo effetto luce nera</strong> vi trasforma in una dea luminosa</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringSet Nova Blacklight taglia grande: pizzo UV fluorescente, reggiseno con ferretto, gonna aperta sulla schiena, perizoma coordinato. Delicato, divino, pericoloso | Diva's Boudoir
keywords
string
title
stringNova Blacklight grande set fluorescente | Diva's Boudoir
seotitle
stringNova Blacklight, set di effetti fluorescenti di grande taglia
seouri
stringset-di-lacci-fluorescenti-nova-blacklight-taglia-grande
specifications
string<ul> <li><strong>Set:</strong> Tre pezzi (reggiseno, gonna, perizoma)</li> <li><strong>Effetto speciale:</strong> pizzo fluorescente Blacklight UV</li> <li><strong>Reggiseno:</strong> coppe trasparenti con ferretto e spalline</li> <li><strong>Gonna:</strong> vita alta con spettacolare schiena aperta</li> <li><strong>Perizoma</strong>: in rete coordinata</li> <li><strong>Spalline:</strong> Regolabili per un comfort personalizzato</li> <li><strong>Chiusura:</strong> Rompibile sul davanti per giochi divertenti</li> <li><strong>Materiale:</strong> pizzo ricamato e rete elastica</li> </ul>
stylingtips
string<p>Arricchite il vostro set Nova Blacklight con i nostri <a href="https://www.divasboudoir.com/it/calze-di-grandi-dimensioni/">slip</a> fluo <a href="https://www.divasboudoir.com/it/calze-di-grandi-dimensioni/">taglia grande</a> per un look completo, oppure aggiungete un <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">kimono</a> velato <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">taglia grande</a> per un'eleganza a contrasto. Esplorate i nostri <a href="https://www.divasboudoir.com/fr/tenues-sexy-grande-taille/">sexy completi plus size</a> per creare sovrapposizioni luminose, oppure scoprite i nostri <a href="https://www.divasboudoir.com/it/body-taglia-grande/">body taglia grande</a> della stessa collezione per variare l'effetto. Questa creazione unica rivela il vostro lato misterioso con luminosa raffinatezza.</p>
summary
string<p>Incarnate la perfezione delicata, divina e pericolosa con il set Nova Blacklight!</p> <p>questa rivoluzionaria creazione in pizzo ricamato fluorescente e rete elastica abbraccia ed esalta le vostre curve naturali.</p> <p>Con il reggiseno a coppa trasparente, la gonna aperta sulla schiena e il perizoma coordinato, questo set trasforma ogni apparizione in uno spettacolo di luci.</p>
title
stringEnsemble Nova Blacklight - Delicato, divino e pericoloso
usageinstructions
string<p>Infilate delicatamente questo set, facendo attenzione al pizzo fluorescente che rivela la sua magia sotto la luce UV. Le spalline regolabili si posizionano in modo da creare il sostegno ottimale per il vostro seno.</p> <p>La <strong>chiusura a strappo può essere manipolata delicatamente</strong> per creare quei momenti di rivelazione graduale. La gonna a vita alta abbraccia i fianchi in modo naturale, mentre la schiena aperta rivela la vostra sensualità. Questo set <strong>si adatta a tutte le forme del corpo</strong> grazie alla maglia elasticizzata e alle molteplici possibilità di regolazione.</p> <p>Lasciate trasparire il vostro lato misterioso con questa creazione che trasforma ogni serata in uno spettacolo di luci.</p>
nl
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Handwas in koud water om het fluorescerende effect te behouden</li> <li>Gebruik een mild wasmiddel zonder bleekmiddelen</li> <li>Plat drogen om de vorm van de beugels te behouden</li> <li>Strijk nooit rechtstreeks op fluorescerend kant</li> <li>Behandel de breekbare sluiting voorzichtig</li> <li>Niet in direct licht bewaren om de schittering te behouden</li> </ul>
description
string<p>De Nova Blacklight set zorgt voor een revolutie in de kunst van het verleiden met zijn <strong>exclusieve fluorescerende geborduurde kant</strong> die je onder UV-licht verandert in een lichtgevende godin. Technische innovatie cre&euml;ert een opvallend visueel spektakel dat de aandacht trekt.</p> <p>De <strong>transparante beugelcups met banduitsnijdingen</strong> vormen een perfect decollet&eacute; en onthullen je huid met geraffineerde durf.</p> <p>Het technische ontwerp <strong>accentueert op natuurlijke wijze alle lichaamsvormen</strong> en cre&euml;ert een optimaal push-up effect dat je pluspunten op elegante wijze benadrukt.</p> <p>De <strong>sluiting aan de voorkant</strong> voegt een speelse dimensie toe voor momenten van progressieve onthulling. Jij bepaalt het niveau van verleiding met absolute verfijning.</p> <p>De <strong>hoog getailleerde rok met open rug detail</strong> revolutioneert codes door het cre&euml;ren van een spectaculair modern silhouet. Het ontwerp onthult de sensuele ronding van je rug terwijl je heupen met precisie worden gebeeldhouwd.</p> <p>Het <strong>stretch breisel</strong> omhelst je natuurlijke rondingen als een perfecte tweede huid. Het technische materiaal <strong>past zich perfect aan alle lichaamsvormen</strong> aan en garandeert de hele avond optimaal comfort.</p> <p>De <strong>bijpassende mesh string</strong> maakt dit uitzonderlijke ensemble compleet. De perfecte co&ouml;rdinatie onthult je aandacht voor detail en maakt van elke verschijning een moment van pure fascinatie. Als je de Nova Blacklight set draagt, word je delicaat, goddelijk en gevaarlijk - een fascinerend wezen dat betovert met zijn mysterieuze lichtgevendheid en onweerstaanbare magnetische uitstraling.</p>
guid
stringhttps://dev.divasboudoir.com/nl/nova-blacklight-grote-maat-fluorescerende-kantenset/sbbu9331.htm
highlights
string<ul> <li><strong>Exclusief fluorescerend kant</strong> dat oplicht onder UV-licht</li> <li><strong>Transparante beugelcups met</strong> opvallende banduitsnijdingen</li> <li><strong>Drukknoopsluiting aan de voorkant</strong> voor speelse verleidingsspelletjes</li> <li><strong>Rok met hoge taille</strong> en spectaculair open rugdetail</li> <li><strong>Bijpassende mesh string</strong> voor een perfect geco&ouml;rdineerd ensemble</li> <li><strong>Verstelbare bandjes</strong> voor jouw vorm</li> <li><strong>Stretch mesh</strong> dat je natuurlijke rondingen omhelst en verbetert</li> <li><strong>Uniek blacklight effect</strong> transformeert je in een stralende godin</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringNova Blacklight grote maten set: fluorescerend UV-kant, beugel bh, rok met open rug, bijpassende string. Delicaat, goddelijk, gevaarlijk | Diva's Boudoir
keywords
string
title
stringNova Blacklight grote fluorescerende set | Diva's Boudoir
seotitle
stringNova Blacklight grote maat fluorescerende effectset
seouri
stringnova-blacklight-grote-maat-fluorescerende-kantenset
specifications
string<ul> <li><strong>Set:</strong> Driedelig (bh, rok, string)</li> <li><strong>Speciaal effect:</strong> UV-fluorescerend kant in blacklight</li> <li><strong>Bh:</strong> Sheer beugelcups met bandjes</li> <li><strong>Rok:</strong> Hoge taille met spectaculaire open rug</li> <li><strong>G-string</strong>: Co&ouml;rdinerende mesh</li> <li><strong>Bandjes:</strong> Verstelbaar voor draagcomfort op maat</li> <li><strong>Sluiting :</strong> Breekbare voorkant voor leuke spelletjes</li> <li><strong>Materiaal:</strong> Geborduurd kant en stretch mesh</li> </ul>
stylingtips
string<p>Verfraai je Nova Blacklight set met onze fluorescerende <a href="https://www.divasboudoir.com/nl/grote-maat-kousen/">plus size broekjes</a> voor een complete look, of voeg een doorschijnende <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">plus size kimono</a> toe voor contrasterende elegantie. Ontdek onze <a href="https://www.divasboudoir.com/fr/tenues-sexy-grande-taille/">sexy outfits van grote maten</a> om lichtgevende overlays te cre&euml;ren, of ontdek onze <a href="https://www.divasboudoir.com/nl/bodysuits-grote-maten/">bodysuits</a> van <a href="https://www.divasboudoir.com/nl/bodysuits-grote-maten/">grote maten</a> uit dezelfde collectie om het effect te vari&euml;ren. Deze unieke creatie onthult je mysterieuze kant met stralende verfijning.</p>
summary
string<p>Belichaam delicate, goddelijke en gevaarlijke perfectie met de Nova Blacklight set!</p> <p>deze revolutionaire creatie van fluorescerend geborduurd kant en stretch mesh omarmt en verbetert je natuurlijke rondingen.</p> <p>Met zijn bh met doorschijnende cups, rok met open rug en bijpassende string maakt dit setje van elke verschijning een lichtshow.</p>
title
stringEnsemble Nova Blacklight - Delicaat, goddelijk en gevaarlijk
usageinstructions
string<p>Trek dit setje voorzichtig aan en let op het fluorescerende kant dat zijn magie onthult onder UV-licht. De verstelbare bandjes positioneren zichzelf om de optimale ondersteuning voor je buste te cre&euml;ren.</p> <p>De <strong>breekbare sluiting kan voorzichtig worden gemanipuleerd</strong> om die momenten van geleidelijke onthulling te cre&euml;ren. De rok met hoge taille omhelst je heupen op natuurlijke wijze, terwijl de open rug je sensualiteit onthult. Deze set <strong>past zich aan alle lichaamsvormen</strong> aan dankzij het stretchbreisel en de vele verstelmogelijkheden.</p> <p>Laat je mysterieuze kant doorschijnen met deze creatie die van elke avond een lichtshow maakt.</p>
pt
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavar à mão em água fria para preservar o efeito fluorescente</li> <li>Utilizar um detergente suave sem agentes branqueadores</li> <li>Secar na horizontal para manter a forma dos fios</li> <li>Nunca passar a ferro diretamente sobre a renda fluorescente</li> <li>Manusear o fecho quebrável com cuidado</li> <li>Guardar ao abrigo da luz direta para preservar o brilho</li> </ul>
description
string<p>O conjunto Nova Blacklight revoluciona a arte da sedução com a sua <strong>exclusiva renda bordada fluorescente</strong> que a transforma numa deusa luminosa sob a luz UV. A inovação técnica cria um espetáculo visual impressionante que cativa o olhar.</p> <p>As <strong>copas transparentes com aros e recortes nas alças</strong> esculpem um decote perfeito, revelando a sua pele com uma audácia sofisticada.</p> <p>O design técnico <strong>valoriza naturalmente todas as formas do corpo</strong>, criando um efeito push-up ideal que realça elegantemente os seus atributos.</p> <p>O <strong>fecho frontal</strong> acrescenta uma dimensão lúdica para momentos de revelação progressiva. Controla o nível de sedução com uma sofisticação absoluta.</p> <p>A <strong>saia de cintura alta com detalhe de costas abertas</strong> revoluciona os códigos ao criar uma silhueta moderna e espetacular. O design revela a curva sensual das suas costas enquanto esculpe as suas ancas com precisão.</p> <p>A <strong>malha elástica</strong> abraça suavemente as suas curvas naturais como uma segunda pele perfeita. O material técnico <strong>adapta-se perfeitamente a todas as formas do corpo</strong>, garantindo um conforto ótimo durante toda a noite.</p> <p>A <strong>tanga de malha a condizer</strong> completa este conjunto excecional. A coordenação perfeita revela a sua atenção aos detalhes e transforma cada aparição num momento de puro fascínio. Quando usa o conjunto Nova Blacklight, torna-se delicada, divina e perigosa - uma criatura fascinante que hipnotiza com a sua luminescência misteriosa e a sua aura magnética irresistível.</p>
guid
stringhttps://dev.divasboudoir.com/pt/conjunto-de-renda-fluorescente-nova-blacklight-tamanho-grande/sbbu9331.htm
highlights
string<ul> <li><strong>Renda fluorescente exclusiva</strong> que brilha à luz UV</li> <li><strong>Copas transparentes</strong> com aros e recortes ousados nas alças</li> <li><strong>Fecho de pressão à frente</strong> para jogos de sedução divertidos</li> <li><strong>Saia de cintura alta</strong> com espetacular detalhe de costas abertas</li> <li><strong>Tanga de malha a condizer</strong> para um conjunto perfeitamente coordenado</li> <li><strong>Alças ajustáveis</strong> para se adaptarem à sua forma</li> <li><strong>A malha elástica</strong> abraça e realça as suas curvas naturais</li> <li><strong>O efeito único de luz negra</strong> transforma-a numa deusa luminosa</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringConjunto Nova Blacklight plus size: renda UV fluorescente, sutiã com armação, saia aberta nas costas, tanga a condizer. Delicado, divino, perigoso | Diva's Boudoir
keywords
string
title
stringConjunto fluorescente grande Nova Blacklight | Diva's Boudoir
seotitle
stringConjunto de efeitos fluorescentes de grandes dimensões Nova Blacklight
seouri
stringconjunto-de-renda-fluorescente-nova-blacklight-tamanho-grande
specifications
string<ul> <li><strong>Conjunto:</strong> Três peças (sutiã, saia, tanga)</li> <li><strong>Efeito especial:</strong> Renda fluorescente UV com luz negra</li> <li>Soutien<strong>:</strong> copas com aros transparentes e alças</li> <li><strong>Saia:</strong> cintura alta com costas abertas espectaculares</li> <li><strong>Tanga</strong>: Malha a condizer</li> <li><strong>Alças:</strong> Ajustáveis para um conforto personalizado</li> <li><strong>Fecho :</strong> Frente quebrável para jogos divertidos</li> <li><strong>Material:</strong> Renda bordada e malha elástica</li> </ul>
stylingtips
string<p>Melhore o seu conjunto Nova Blacklight com as nossas <a href="https://www.divasboudoir.com/pt/meias-de-tamanho-grande/">calças</a> fluorescentes <a href="https://www.divasboudoir.com/pt/meias-de-tamanho-grande/">plus size</a> para um look completo, ou adicione um <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">quimono plus size</a> transparente para uma elegância contrastante. Explore os nossos <a href="https://www.divasboudoir.com/fr/tenues-sexy-grande-taille/">conjuntos sensuais plus size</a> para criar sobreposições luminosas, ou descubra os nossos <a href="https://www.divasboudoir.com/pt/body-plus-size/">body plus size</a> da mesma coleção para variar o efeito. Esta criação única revela o seu lado misterioso com uma sofisticação luminosa.</p>
summary
string<p>Encarne a perfeição delicada, divina e perigosa com o conjunto Nova Blacklight!</p> <p>esta criação revolucionária em renda bordada fluorescente e malha elástica abraça e realça as suas curvas naturais.</p> <p>Com o sutiã de copa transparente, a saia de costas abertas e a tanga a condizer, este conjunto transforma cada aparição num espetáculo de luz.</p>
title
stringEnsemble Nova Blacklight - Delicado, Divino e Perigoso
usageinstructions
string<p>Vista suavemente este conjunto, tendo cuidado com a renda fluorescente que revela a sua magia à luz UV. As alças ajustáveis posicionam-se para criar o suporte ideal para o seu busto.</p> <p>O <strong>fecho de correr pode ser suavemente manipulado</strong> para criar aqueles momentos de revelação gradual. A saia de cintura alta abraça naturalmente as ancas, enquanto as costas abertas revelam a sua sensualidade. Este conjunto <strong>adapta-se a todas as formas do corpo</strong> graças à sua malha elástica e às múltiplas opções de ajuste.</p> <p>Deixe o seu lado misterioso brilhar com esta criação que transforma cada noite num espetáculo de luzes.</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-neonpink
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-roz-neon
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-fluo-rose
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-rosa-neon
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-rose-fluo
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-rosa-neon
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-neonroze
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-rosa-neon
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-neonpink
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-roz-neon
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-fluo-rose
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-rosa-neon
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-rose-fluo
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-rosa-neon
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-neonroze
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-rosa-neon
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-neonpink
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-roz-neon
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-fluo-rose
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-rosa-neon
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-rose-fluo
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-rosa-neon
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-neonroze
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-rosa-neon
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-neonpink
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-roz-neon
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-fluo-rose
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-rosa-neon
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-rose-fluo
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-rosa-neon
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-neonroze
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-rosa-neon
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-neonpink
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-roz-neon
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-fluo-rose
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-rosa-neon
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-rose-fluo
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-rosa-neon
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-neonroze
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-rosa-neon
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
name
stringensemble nova rose
netweight
string
nextshipment
stringtoday
ordered
number1
orderidx
number0
origin
string
originalsize
string
packaging
string
productshipment
stringauto
productuid
string95C76FC0-32E6-4E48-BAA06C790E720594
promountil
string
rating
stringnone
recorduid
string95C76FC0-32E6-4E48-BAA06C790E720594
reference
stringSBBU9331
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.74 ms
Record Count: 5
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_sizes.id_size as recorduid, if(intlsize <> '',intlsize,eusize) as size, if(intlsize <> '','intlsize','eusize') as sizetype,
product_variations.color,
if(product_sizes.sizegroup = 'bra',
if(intlsize <> '', cast(intlsize as SIGNED ), cast(eusize as SIGNED ))
,
SUBSTRING_INDEX(intlsize,'-',1)
) as param1,
if(product_sizes.sizegroup = 'bra',
if(intlsize <> '',
MID(intlsize,length(cast(intlsize as SIGNED ))+1,length(intlsize)),
MID(eusize,length(cast(eusize as SIGNED ))+1,length(eusize))
)
,
SUBSTRING_INDEX(intlsize,'-',-1)
) as param2,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as available,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
999999,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as groupavailable,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
product_sizes.gender, product_sizes.sizerange, product_sizes.sizegroup, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize,
product_sizes.bust, product_sizes.waist, product_sizes.hip, product_sizes.underbust, product_sizes.cup, product_sizes.thigh, product_sizes.legheight, product_sizes.bodyheight, product_sizes.bodyweight
from product_sizes
left outer join product_variations on product_sizes.suppliersize = product_variations.size and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
where FIND_IN_SET(product_sizes.id_size,'2069,2074,2067,2073,2075') > 0
and product_variations.productuid = '95C76FC0-32E6-4E48-BAA06C790E720594'
and intlsize <> 'na'
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_sizes.id_size, product_variations.color
order by FIELD(product_sizes.gender,'w','m'), product_sizes.sizegroup, FIELD(intlsize,'XS','S','S/M','S-M','M','M/L','M-L','L','L-XL','L/XL','XL','0X','0XL','lXL','1X','1X-2X','1X/2X','XL/2XL','XL-2XL','1XL-2XL','2XL','2X','XXL','2X-3X','2X/3X','2XL-3XL','2XL/3XL','XXXL','3XL','3X','3X-4X','3X/4X','3XL-4XL','3XL/4XL','4XL','5XL','5X','5X-6X','5X/6X','5XL-6XL','5XL/6XL','6XL','6X','7XL','7X','8XL','8X'), cast(intlsize as SIGNED ), groupavailable desc, stock desc
recorduidsizesizetypecolorparam1param2availablegroupavailablestockgendersizerangesizegroupsuppliersizeintlsizeincheseusizeussizeuksizefrsizeessizedesizeitsizeptsizeelsizebustwaisthipunderbustcupthighlegheightbodyheightbodyweight
120741X/2X-intlsizefluorose1X/2X-19999990wpluslingerie1X/2X1X/2X-42-4412-1416-1844-4644-4642-4446-4844-4642-44104-11086-91112-120
220753X/4X+intlsizefluorose3X/4X+3X/4X+-19999990wpluslingerie3X/4X3X/4X+50-5220-2224-2852-5452-5450-5256-5852-5450-52128-132102-108132-138
32069XLintlsizefluoroseXLXL-19999990wpluslingerieXLXL40-4210-1214-1642-4442-4440-4246-4842-4440-4299-10481-86107-112
420671X/2Xintlsizefluorose1X/2X1X/2X-19999990wpluslingerie1X/2X1X/2X46-4816-1820-2248-5048-5046-4852-5448-5046-48112-11892-96122-128
520733X/4Xintlsizefluorose3X/4X3X/4X-19999990wpluslingerie3X/4X3X/4X48-5018-2022-2450-5250-5248-5054-5650-5248-50120-12898-102128-132
sizeranges
stringplus
sizes
string2069,2074,2067,2073,2075
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: 8.59 ms
Record Count: 3
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select * from (
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '95C76FC0-32E6-4E48-BAA06C790E720594'
and product_variations.isactive = 1
and product_sizes.id_size = 2069
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 = '95C76FC0-32E6-4E48-BAA06C790E720594'
and product_variations.isactive = 1
and product_sizes.id_size = 2074
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '95C76FC0-32E6-4E48-BAA06C790E720594'
and product_variations.isactive = 1
and product_sizes.id_size = 2067
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '95C76FC0-32E6-4E48-BAA06C790E720594'
and product_variations.isactive = 1
and product_sizes.id_size = 2073
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
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 = '95C76FC0-32E6-4E48-BAA06C790E720594'
and product_variations.isactive = 1
and product_sizes.id_size = 2075
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
195C76FC0-32E6-4E48-BAA06C790E720594D6FA7A27-9AA3-4A7B-8151338479F073A52074fluorose#FA22A01X/2X1X/2X-42-4412-1416-1844-4644-4642-4446-4844-4642-44wlingerie1X/2X-intlsize63.29170STOCK01000-11100HD04302A-PNKD840312835507-10all
295C76FC0-32E6-4E48-BAA06C790E720594896E5E0F-E6EF-4F5D-9C761CE95C3499E12069fluorose#FA22A0XLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42wlingerieXLintlsize63.29170STOCK01000-10000HD04302A-PNKD-10all
395C76FC0-32E6-4E48-BAA06C790E72059420A62A53-5FB6-4F42-B64478EE4FA6DA9B2073fluorose#FA22A03X/4X3X/4X48-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie3X/4Xintlsize63.29170STOCK01000-10000HD04302A-PNKD-10all
subcategory
stringbustier
supplier
number-1
supplierreference
stringNOVA
tags
stringglowinthedark
themes
string
totalvariations
string
type
stringdefault
unitprice
number63.2917
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 12.2 ms
Record Count: 5
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '95C76FC0-32E6-4E48-BAA06C790E720594' 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 = '95C76FC0-32E6-4E48-BAA06C790E720594' 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 = '95C76FC0-32E6-4E48-BAA06C790E720594' 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 = '95C76FC0-32E6-4E48-BAA06C790E720594' 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 = '95C76FC0-32E6-4E48-BAA06C790E720594' 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 = '95C76FC0-32E6-4E48-BAA06C790E720594' 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 = '95C76FC0-32E6-4E48-BAA06C790E720594'
and product_variations.isactive = 1
and product_sizes.id_size = 2069
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 = '95C76FC0-32E6-4E48-BAA06C790E720594' 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 = '95C76FC0-32E6-4E48-BAA06C790E720594' 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 = '95C76FC0-32E6-4E48-BAA06C790E720594' 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 = '95C76FC0-32E6-4E48-BAA06C790E720594' 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 = '95C76FC0-32E6-4E48-BAA06C790E720594' 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 = '95C76FC0-32E6-4E48-BAA06C790E720594' 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 = '95C76FC0-32E6-4E48-BAA06C790E720594'
and product_variations.isactive = 1
and product_sizes.id_size = 2074
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '95C76FC0-32E6-4E48-BAA06C790E720594' 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 = '95C76FC0-32E6-4E48-BAA06C790E720594' 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 = '95C76FC0-32E6-4E48-BAA06C790E720594' 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 = '95C76FC0-32E6-4E48-BAA06C790E720594' 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 = '95C76FC0-32E6-4E48-BAA06C790E720594' 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 = '95C76FC0-32E6-4E48-BAA06C790E720594' 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 = '95C76FC0-32E6-4E48-BAA06C790E720594'
and product_variations.isactive = 1
and product_sizes.id_size = 2067
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '95C76FC0-32E6-4E48-BAA06C790E720594' 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 = '95C76FC0-32E6-4E48-BAA06C790E720594' 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 = '95C76FC0-32E6-4E48-BAA06C790E720594' 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 = '95C76FC0-32E6-4E48-BAA06C790E720594' 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 = '95C76FC0-32E6-4E48-BAA06C790E720594' 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 = '95C76FC0-32E6-4E48-BAA06C790E720594' 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 = '95C76FC0-32E6-4E48-BAA06C790E720594'
and product_variations.isactive = 1
and product_sizes.id_size = 2073
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
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 = '95C76FC0-32E6-4E48-BAA06C790E720594' 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 = '95C76FC0-32E6-4E48-BAA06C790E720594' 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 = '95C76FC0-32E6-4E48-BAA06C790E720594' 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 = '95C76FC0-32E6-4E48-BAA06C790E720594' 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 = '95C76FC0-32E6-4E48-BAA06C790E720594' 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 = '95C76FC0-32E6-4E48-BAA06C790E720594' 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 = '95C76FC0-32E6-4E48-BAA06C790E720594'
and product_variations.isactive = 1
and product_sizes.id_size = 2075
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
1D6FA7A27-9AA3-4A7B-8151338479F073A52074fluorose#FA22A01X/2X1X/2X-42-4412-1416-1844-4644-4642-4446-4844-4642-44wlingerie1X/2X-intlsize63.29170STOCK01000-11100HD04302A-PNKD840312835507-10-10-10063.2917all
220A62A53-5FB6-4F42-B64478EE4FA6DA9B2075fluorose#FA22A03X/4X3X/4X+50-5220-2224-2852-5452-5450-5256-5852-5450-52wlingerie3X/4X+intlsize63.29170STOCK01000-10000HD04302A-PNKD-10-10-10063.2917all
3896E5E0F-E6EF-4F5D-9C761CE95C3499E12069fluorose#FA22A0XLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42wlingerieXLintlsize63.29170STOCK01000-10000HD04302A-PNKD-10-10-10063.2917all
4D6FA7A27-9AA3-4A7B-8151338479F073A52067fluorose#FA22A01X/2X1X/2X46-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie1X/2Xintlsize63.29170STOCK01000-11100HD04302A-PNKD840312835507-10-10-10063.2917all
520A62A53-5FB6-4F42-B64478EE4FA6DA9B2073fluorose#FA22A03X/4X3X/4X48-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie3X/4Xintlsize63.29170STOCK01000-10000HD04302A-PNKD-10-10-10063.2917all
vatrate
number20
warehouse
string