Mein Warenkorb

❌
Gesamtartikel
Zum Warenkorb
Menü
Siehe Größen
Giftige Verführung im Schlangeneffekt
Doppelklicken Sie zum Vergrößern
SKU: CDBU4936
Giftige Verführung im Schlangeneffekt
Lager:

Das Kleid Vyper verkörpert mit seinem hypnotisierenden Schlangenhauteffekt und dem gewagten Halfterkragen die fatale Verführung. Diese provokante Kreation enthüllt Ihre wilde Seite mit einer beunruhigenden Eleganz, die alle Blicke auf sich zieht.

Highlights / Vorteile

  • Schlangenhaut-Effekt für einen geheimnisvollen und fesselnden Look
  • Raffinierter Halfterkragen, der die Schultern kühn enthüllt
  • Metallische Details am Dekolleté für einen hypnotisierenden Effekt
  • Eng anliegender Schnitt, der sich sinnlich an jede Kurve schmiegt
  • Elastischer Stoff für optimalen Tragekomfort und absolute Freiheit
Größe:

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

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

Sexy Kleid in Übergröße Schlangeneffekt Halfterkragen schwarz

Produktbeschreibung

Das Vyper-Kleid verwandelt jeden Auftritt in einen Moment der absoluten Verführung. Der metallisch schimmernde Schlangenhauteffekt umschmeichelt die Haut, während er Ihre üppigen Kurven mit wilder Sinnlichkeit betont. Der Halfterkragen schafft ein raffiniertes Dekolleté und enthüllt gerade so viel, wie nötig ist, um die Gemüter zu verwirren.

Diese Kreation passt sich dank des dehnbaren Stoffes, der sich perfekt an Ihre Formen anpasst, ohne jemals einzuengen, jeder Körperform an. Die Metalldetails am Ausschnitt verleihen dem Ganzen eine hypnotische Dimension und erzeugen ein Lichtspiel, das die Blicke unwiderstehlich anzieht. Der kurze, eng anliegende Schnitt enthüllt Ihre Silhouette mit selbstbewusster Kühnheit und ist perfekt für Ihre betörendsten Abende.

Technische Details

  • Material: Elastisches Gewebe mit Schlangeneffekt (92% Polyester, 8% Elasthan)
  • Farbe: Tiefschwarz mit metallischem Schimmer
  • Schnitt: Eng anliegend mit Halfterkragen
  • Details: Metallringe am Ausschnitt.
  • Länge: Mini, über dem Knie

Verfügbare Größen

Erhältlich von 4X bis 3X

Verfügbare Farbe

Schwarz

Größenanleitung

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

International
  • Brust
  • Größe
  • Hüften
4X
  • 128-134
  • 107-112
  • 133-140
XL
  • 100-107
  • 79-86
  • 105-112
1X
  • 107-114
  • 86-93
  • 112-119
2XL
  • 114-121
  • 93-100
  • 119-126
3X
  • 121-128
  • 100-107
  • 126-133

Pflegehinweise

  • Handwäsche mit lauwarmem Wasser und einer milden Seife
  • vermeiden Sie aggressive Reinigungsmittel, die den Schlangeneffekt beeinträchtigen könnten
  • Flach trocknen, vor direkter Hitze schützen
  • Vorsichtig aufbewahren, um die Metalldetails zu erhalten
  • vermeiden Sie den Kontakt mit spitzen oder rauen Gegenständen

Anwendungstipps

Für optimalen Tragekomfort den ganzen Abend über ziehen Sie das Vyper-Kleid sanft an, damit der Schlangeneffekt und die Metalldetails erhalten bleiben.

Der Halfterkragen passt sich perfekt um den Hals an und sorgt für einen sicheren Halt. Der dehnbare Stoff schmiegt sich ganz natürlich an Ihre Formen an und ermöglicht absolute Bewegungsfreiheit, sodass Sie ganz entspannt tanzen und verführen können. Für einen noch betörenderen Effekt tragen Sie es mit unsichtbarer Unterwäsche, die Ihre wilden Kurven erahnen lässt.

Styling-Tipps

Das Vyper-Kleid lässt sich mit schwarzen Lackpumps für einen fatalen Total Look oder mit Stiefeletten mit Absätzen für einen unwiderstehlichen Rock-Chic-Stil veredeln.

Fügen Sie gold- oder silberfarbenen Schmuck hinzu, der die metallischen Details widerspiegelt. Für Ihre gewagtesten Abende kombinieren Sie sie mit unseren Netzstrümpfen oder blickdichten Str umpfhosen für einen raubtierhaften Look. Vervollständigen Sie es mit einem satinierten Kimono für ein progressives Spiel der Enthüllung, das alle Blicke hypnotisieren wird.

To Top
Zum Warenkorb
Artikel
Gesamtartikel
Struct
Entries: 108
actions
Array
available
number-1
brand
stringdivasfashion
brandcode
stringdvqc
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
stringDiva's Fashion
breasts
stringna
careinstructions
string
categories
stringdivasboudoir.cabaret.dresses.all
category
stringdresses
categorygender
stringf
categorymediadatas
Struct
adult
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string615
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/cabaret/dresses1.jpg
type
stringimg
width
string1336
divasboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
fetishboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
latexboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
legsboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
lustboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
private
Struct
height
string1016
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/private/default.jpg
type
stringimg
width
string703
smboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
categorysizerange
stringauto
colorinfos
Query
Template: /system/api/product/colors.cfc:13
Execution Time: 0.763 ms
Record Count: 1
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_colors.color as recorduid, product_colors.type, product_colors.code, product_colors.color, product_colors.range, product_colors.hexvalue,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock
from product_colors
left outer join product_variations on product_colors.color = product_variations.color and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
where FIND_IN_SET(product_colors.color,'black') > 0
and product_variations.productuid = '88B10665-B344-4EA7-B256938AF5AC37BA'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1blackcolorblakblackblack#000000-10
colorrange
stringblack
colors
stringblack
colortype
stringcolor
comments
string
compositions
Struct
Entries: 13
coton
string
elastane
string
free
string
leather
string
lycra
string
metal
string
nylon
string
polyamide
string
polyester
string
polyurethane
string
silk
string
spandex
string
viscose
string
datecreated
Date Time (Europe/Paris)
{ts '2025-08-15 13:48:11'}
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
number0
isactive
number1
iscustommade
number0
isdivasize
number0
isfirstprice
number0
isfixedprice
number0
ishot
number0
isnew
number0
isonline
number0
isoutletprice
number0
itemprice
number33.2917
itempromo
string
key
stringsz2406242523627232
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-10-31 11:36:49'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.642 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('88b10665-b344-4ea7-b256938af5ac37ba',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.38 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 <> 'CDBU4936'
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
string1736
isprivate
string0
rating
stringall
src
string/photobank/products/dvqc/cdbu4936/robe_grande_taille_serpent_dos.jpg
type
stringimg
width
string1201
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string1976
isprivate
string0
rating
stringall
src
string/photobank/products/dvqc/cdbu4936/robe_grande_taille_serpent.jpg
type
stringimg
width
string1367
variations
Struct
colors
Struct
black
Struct
height
string1976
isprivate
string0
rating
stringall
src
string/photobank/products/dvqc/cdbu4936/robe_grande_taille_serpent.jpg
type
stringimg
width
string1367
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
mediagallery
stringproducts.divasfashion.cdbu4936
metadatas
Struct
darkboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
divasboudoir
Struct
de
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Handwäsche mit lauwarmem Wasser und einer milden Seife</li> <li>vermeiden Sie aggressive Reinigungsmittel, die den Schlangeneffekt beeinträchtigen könnten</li> <li>Flach trocknen, vor direkter Hitze schützen</li> <li>Vorsichtig aufbewahren, um die Metalldetails zu erhalten</li> <li>vermeiden Sie den Kontakt mit spitzen oder rauen Gegenständen</li> </ul>
description
string<p>Das Vyper-Kleid verwandelt jeden Auftritt in einen Moment der <strong>absoluten Verführung</strong>. Der metallisch schimmernde Schlangenhauteffekt umschmeichelt die Haut, während <strong>er Ihre üppigen Kurven</strong> mit wilder Sinnlichkeit betont. Der Halfterkragen schafft ein raffiniertes Dekollet&eacute; und enthüllt gerade so viel, wie nötig ist, um die Gemüter zu verwirren.</p> <p>Diese Kreation <strong>passt sich</strong> dank des dehnbaren Stoffes, der sich perfekt an Ihre Formen <strong>anpasst</strong>, ohne jemals einzuengen, jeder Körperform an. Die Metalldetails am Ausschnitt verleihen dem Ganzen eine hypnotische Dimension und erzeugen ein Lichtspiel, das die Blicke unwiderstehlich anzieht. Der kurze, eng anliegende Schnitt enthüllt Ihre Silhouette mit selbstbewusster Kühnheit und ist perfekt für Ihre betörendsten Abende.</p>
guid
stringhttps://dev.divasboudoir.com/de/sexy-kleider-schwarz/cdbu4936.htm
highlights
string<ul> <li><strong>Schlangenhaut-Effekt</strong> für einen geheimnisvollen und fesselnden Look</li> <li><strong>Raffinierter Halfterkragen</strong>, der die Schultern kühn enthüllt</li> <li><strong>Metallische Details</strong> am Dekollet&eacute; für einen hypnotisierenden Effekt</li> <li><strong>Eng anliegender Schnitt</strong>, der sich sinnlich an jede Kurve schmiegt</li> <li><strong>Elastischer Stoff</strong> für optimalen Tragekomfort und absolute Freiheit</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringVyper-Kleid mit Schlangeneffekt in Übergröße: sexy Einhalskragen, Metalldetails, eng anliegender Schnitt, elastischer Stoff. Giftige Verführung garantiert. Diva's Boudoir.
keywords
string
title
stringVyper Kleid mit Schlangenleder-Effekt Große Größe mit Kragen und Halfter | Diva's Boudoir
seotitle
stringSexy Kleid in Übergröße Schlangeneffekt Halfterkragen schwarz
seouri
stringsexy-kleider-schwarz
specifications
string<ul> <li><strong>Material:</strong> Elastisches Gewebe mit Schlangeneffekt (92% Polyester, 8% Elasthan)</li> <li><strong>Farbe:</strong> Tiefschwarz mit metallischem Schimmer</li> <li><strong>Schnitt:</strong> Eng anliegend mit Halfterkragen</li> <li><strong>Details:</strong> Metallringe am Ausschnitt.</li> <li><strong>Länge:</strong> Mini, über dem Knie</li> </ul>
stylingtips
string<p>Das Vyper-Kleid lässt sich mit <strong>schwarzen Lackpumps</strong> für einen fatalen Total Look oder mit Stiefeletten mit Absätzen für einen unwiderstehlichen Rock-Chic-Stil veredeln.</p> <p>Fügen Sie gold- oder silberfarbenen Schmuck hinzu, der die metallischen Details widerspiegelt. Für Ihre gewagtesten Abende kombinieren Sie sie mit unseren <a href="/bas-grande-taille">Netzstrümpfen</a> oder <a href="/collants-grande-taille">blickdichten Str</a> <a href="/bas-grande-taille">umpfhosen</a> für einen raubtierhaften Look. Vervollständigen Sie es mit einem <a href="/kimonos-grande-taille">satinierten Kimono</a> für ein progressives Spiel der Enthüllung, das alle Blicke hypnotisieren wird.</p>
summary
string<p>Das Kleid Vyper verkörpert mit seinem hypnotisierenden Schlangenhauteffekt und dem gewagten Halfterkragen die fatale Verführung. Diese provokante Kreation enthüllt Ihre wilde Seite mit einer beunruhigenden Eleganz, die alle Blicke auf sich zieht.</p>
title
stringGiftige Verführung im Schlangeneffekt
usageinstructions
string<p>Für <strong>optimalen Tragekomfort den ganzen Abend</strong> über ziehen Sie das Vyper-Kleid sanft an, damit der Schlangeneffekt und die Metalldetails erhalten bleiben.</p> <p>Der Halfterkragen passt sich perfekt um den Hals an und sorgt für einen sicheren Halt. Der dehnbare Stoff <strong> schmiegt sich ganz natürlich an Ihre Formen an</strong> und ermöglicht absolute Bewegungsfreiheit, sodass Sie ganz entspannt tanzen und verführen können. Für einen noch betörenderen Effekt tragen Sie es mit unsichtbarer Unterwäsche, die Ihre wilden Kurven erahnen lässt.</p>
el
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Πλύνετε στο χέρι με χλιαρό νερό και ήπιο σαπούνι</li> <li>αποφύγετε επιθετικά προϊόντα που θα μπορούσαν να αλλοιώσουν το αποτέλεσμα του φιδιού</li> <li>Στεγνώστε σε επίπεδη επιφάνεια, μακριά από άμεση θερμότητα</li> <li>Αποθηκεύστε απαλά για να διατηρήσετε τις μεταλλικές λεπτομέρειες</li> <li>αποφύγετε την επαφή με αιχμηρά ή τραχιά αντικείμενα</li> </ul>
description
string<p>Το φόρεμα Vyper μετατρέπει κάθε εμφάνιση σε μια στιγμή <strong>απόλυτης αποπλάνησης</strong>. Το φιδίσιο εφέ του με μεταλλική λάμψη χαϊδεύει το δέρμα, ενώ <strong>αναδεικνύει τις πλούσιες καμπύλες σας</strong> με άγριο αισθησιασμό. Ο λαιμός με λαιμόκοψη δημιουργεί ένα εκλεπτυσμένο ντεκολτέ, αποκαλύπτοντας όσο χρειάζεται για να αναστατώσει τις αισθήσεις.</p> <p>Αυτή η δημιουργία <strong>προσαρμόζεται σε όλα τα σχήματα του σώματος</strong> χάρη στο ελαστικό του ύφασμα, το οποίο αγκαλιάζει τις καμπύλες σας χωρίς να τις περιορίζει. Οι μεταλλικές λεπτομέρειες στο ντεκολτέ προσθέτουν μια υπνωτιστική διάσταση, δημιουργώντας ένα παιχνίδι φωτός που τραβάει ακαταμάχητα τα βλέμματα. Το κοντό, εφαρμοστό κόψιμό του αποκαλύπτει τη σιλουέτα σας με μια υποτιθέμενη τόλμη, ιδανική για τις πιο μαγευτικές βραδινές σας εξόδους.</p>
guid
stringhttps://dev.divasboudoir.com/el/sexi-foremata-mayro/cdbu4936.htm
highlights
string<ul> <li><strong>Φιδίσιο εφέ</strong> για μια μυστηριώδη και γοητευτική εμφάνιση</li> <li><strong>Εκλεπτυσμένη λαιμόκοψη</strong> που αποκαλύπτει τολμηρά τους ώμους</li> <li><strong>Μεταλλικές λεπτομέρειες</strong> στη λαιμόκοψη για ένα μαγευτικό αποτέλεσμα</li> <li><strong>Κούρεμα που αγκαλιάζει το σώμα</strong> και αγκαλιάζει αισθησιακά κάθε καμπύλη</li> <li><strong>Ελαστικό ύφασμα</strong> για βέλτιστη άνεση και απόλυτη ελευθερία</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringΦόρεμα Vyper με εφέ φιδιού σε plus size: σέξι λαιμόκοψη halter, μεταλλικές λεπτομέρειες, στενή γραμμή, ελαστικό ύφασμα. Εγγυημένη δηλητηριώδης αποπλάνηση. Μπουντουάρ της Ντίβας.
keywords
string
title
stringVyper φόρεμα με φιδίσιο εφέ Μεγάλο μέγεθος Halter Neck | Diva's Boudoir
seotitle
stringΣέξι μεγάλο μέγεθος μαύρο φόρεμα με λαιμόκοψη από φίδι
seouri
stringsexi-foremata-mayro
specifications
string<ul> <li><strong>Υλικό:</strong> ελαστικό ύφασμα με εφέ φιδιού (92% πολυεστέρας, 8% ελαστάν)</li> <li><strong>Χρώμα:</strong> βαθύ μαύρο με μεταλλικές ανταύγειες</li> <li><strong>Κοπή:</strong> Φόρμα με λαιμόκοψη</li> <li><strong>Λεπτομέρειες:</strong> Μεταλλικοί κρίκοι στη λαιμόκοψη</li> <li><strong>Μήκος:</strong> Μίνι, πάνω από το γόνατο</li> </ul>
stylingtips
string<p>Το φόρεμα Vyper ταιριάζει τέλεια με <strong>μαύρες λουστρίνι γόβες</strong> για μια απόλυτα φονική εμφάνιση ή με μποτάκια με τακούνι για ένα ακαταμάχητο ροκ-σικ στυλ.</p> <p>Προσθέστε χρυσά ή ασημένια κοσμήματα για να αναδείξετε τις μεταλλικές λεπτομέρειες. Για τις πιο τολμηρές βραδινές σας εξόδους, συνδυάστε το με τις <a href="/bas-grande-taille">διχτυωτές κάλτσες</a> μας ή το <a href="/collants-grande-taille">αδιαφανές καλσόν</a> μας για μια αρπακτική εμφάνιση. Συμπληρώστε το με ένα <a href="/kimonos-grande-taille">σατέν κιμονό</a> για ένα προοδευτικό αποκαλυπτικό αποτέλεσμα που θα μαγνητίσει όλα τα βλέμματα.</p>
summary
string<p>Το φόρεμα Vyper είναι η επιτομή της μοιραίας αποπλάνησης, με το υπνωτιστικό εφέ φιδίσιας επιδερμίδας και το τολμηρό λαιμόκοψη. Αυτή η προκλητική δημιουργία αποκαλύπτει την άγρια πλευρά σας με μια ανησυχητική κομψότητα που μαγνητίζει όλα τα βλέμματα.</p>
title
stringΔηλητηριώδης αποπλάνηση με επίδραση φιδιού
usageinstructions
string<p>Για <strong>βέλτιστη άνεση καθ' όλη τη διάρκεια της βραδιάς,</strong> φορέστε το φόρεμα Vyper απαλά για να διατηρήσετε το εφέ φιδιού και τις μεταλλικές λεπτομέρειες.</p> <p>Ο λαιμός με λαιμόκοψη εφαρμόζει άνετα γύρω από το λαιμό σας για ασφαλή εφαρμογή. Το ελαστικό ύφασμα <strong> αγκαλιάζει φυσικά το σχήμα σας</strong>, χαρίζοντάς σας απόλυτη ελευθερία κινήσεων, ώστε να μπορείτε να χορεύετε και να αποπλανείτε με απόλυτη άνεση. Για ακόμα πιο μαγευτικό αποτέλεσμα, φορέστε το με αόρατο εσώρουχο που αφήνει να φανούν οι άγριες καμπύλες σας.</p>
en
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Hand wash in lukewarm water with mild soap</li> <li>avoid aggressive products that could alter the snake effect</li> <li>Dry flat, away from direct heat</li> <li>Store gently to preserve metal details</li> <li>avoid contact with sharp or rough objects</li> </ul>
description
string<p>The Vyper dress transforms every appearance into a moment of <strong>absolute seduction</strong>. Its snakeskin effect with metallic sheen caresses the skin while <strong>sublimating your generous curves</strong> with wild sensuality. The halter neck creates a sophisticated d&eacute;collet&eacute;, revealing just enough to unsettle the spirits.</p> <p>This creation <strong>adapts to all body types</strong>, thanks to its stretch fabric that perfectly hugs your curves without ever constricting. Metallic details on the d&eacute;collet&eacute; add a hypnotic dimension, creating a play of light that is irresistibly eye-catching. Its short, form-fitting cut reveals your silhouette with an assumed audacity, perfect for your most bewitching evenings.</p>
guid
stringhttps://dev.divasboudoir.com/en/sexy-dresses-black/cdbu4936.htm
highlights
string<ul> <li><strong>Snakeskin effect</strong> for a mysterious, captivating look</li> <li><strong>Sophisticated halter neck</strong> that boldly reveals the shoulders</li> <li><strong>Metallic details</strong> on the d&eacute;collet&eacute; for a hypnotic effect</li> <li><strong>Body-hugging cut</strong> that sensually hugs every curve</li> <li><strong>Elastic fabric</strong> for optimum comfort and total freedom</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringPlus-size snake-effect Vyper dress: sexy halter neck, metallic details, slim fit, elastic fabric. Venomous seduction guaranteed. Diva's Boudoir.
keywords
string
title
stringDress Vyper Snake Effect Plus Size Halter Neck | Diva's Boudoir
seotitle
stringSexy plus size black halter neck snake effect dress
seouri
stringsexy-dresses-black
specifications
string<ul> <li><strong>Material:</strong> Snake-effect stretch fabric (92% polyester, 8% elastane)</li> <li><strong>Color:</strong> deep black with metallic highlights</li> <li><strong>Cut:</strong> Form-fitting with halter neck</li> <li><strong>Details:</strong> Metallic rings on neckline</li> <li><strong>Length:</strong> Mini, above the knee</li> </ul>
stylingtips
string<p>The Vyper dress is best paired with <strong>black patent pumps</strong> for a total lethal look, or heeled ankle boots for an irresistible rock-chic style.</p> <p>Add gold or silver jewelry to echo the metallic details. For your most daring evenings out, pair with our <a href="/bas-grande-taille">fishnet stockings</a> or <a href="/collants-grande-taille">opaque tights</a> for a predatory look. Top it off with a <a href="/kimonos-grande-taille">satin kimono</a> for a progressive play of revealing that will hypnotize all eyes.</p>
summary
string<p>The Vyper dress embodies fatal seduction with its mesmerizing snakeskin effect and daring halter neck. This provocative creation reveals your wild side with an unsettling elegance that captivates all eyes.</p>
title
stringVenomous Seduction with Snake Effect
usageinstructions
string<p>For <strong>optimum comfort all evening long,</strong> slip on the Vyper dress gently to preserve the snake effect and metallic details.</p> <p>The halter neck fits perfectly around the neck for a secure fit. The stretch fabric <strong> naturally hugs your curves</strong>, allowing total freedom of movement for dancing and seduction in total ease. For an even more bewitching effect, wear it with invisible underwear that lets your wild curves show through.</p>
es
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavar a mano en agua tibia con jabón suave</li> <li>evitar productos agresivos que puedan alterar el efecto serpiente</li> <li>Secar en plano, lejos del calor directo</li> <li>Guardar con cuidado para conservar los detalles metálicos</li> <li>evitar el contacto con objetos afilados o rugosos</li> </ul>
description
string<p>El vestido Vyper convierte cada aparición en un momento de <strong>seducción absoluta</strong>. Su efecto de piel de serpiente con brillo metálico acaricia la piel al tiempo que <strong>realza tus generosas curvas</strong> con salvaje sensualidad. El cuello halter crea un escote sofisticado, revelando lo justo para inquietar los sentidos.</p> <p>Esta creación <strong>se adapta a todas las formas del cuerpo</strong> gracias a su tejido elástico, que abraza tus curvas sin constreñirlas. Los detalles metálicos del escote añaden una dimensión hipnótica, creando un juego de luces irresistiblemente llamativo. Su corte corto y ceñido revela tu silueta con una audacia asumida, perfecta para tus salidas nocturnas más hechizantes.</p>
guid
stringhttps://dev.divasboudoir.com/es/vestidos-sexys-negro/cdbu4936.htm
highlights
string<ul> <li><strong>Efecto piel de serpiente</strong> para un look misterioso y cautivador</li> <li><strong>Sofisticado escote halter</strong> que deja los hombros al descubierto</li> <li><strong>Detalles metálicos</strong> en el escote para un efecto hipnótico</li> <li><strong>Corte ceñido</strong> al cuerpo que abraza sensualmente todas las curvas</li> <li><strong>Tejido elástico</strong> para un confort óptimo y una libertad total</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringVestido Vyper efecto serpiente en talla grande: sexy cuello halter, detalles metálicos, corte entallado, tejido elástico. Seducción venenosa garantizada. Diva's Boudoir.
keywords
string
title
stringVyper Vestido Efecto Serpiente Talla grande Cuello Halter | Diva's Boudoir
seotitle
stringSexy talla grande vestido negro efecto serpiente cuello halter
seouri
stringvestidos-sexys-negro
specifications
string<ul> <li><strong>Material:</strong> tejido elástico efecto serpiente (92% poliéster, 8% elastán)</li> <li><strong>Color:</strong> negro intenso con reflejos metálicos</li> <li><strong>Corte:</strong> ceñido con cuello halter</li> <li><strong>Detalles:</strong> Anillos metálicos en el escote</li> <li><strong>Largo:</strong> Mini, por encima de la rodilla</li> </ul>
stylingtips
string<p>El vestido Vyper es perfecto con <strong>zapatos de tacón negros de charol</strong> para un look total killer, o con botines de tacón para un estilo rock-chic irresistible.</p> <p>Añade joyas doradas o plateadas para realzar los detalles metálicos. Para tus noches más atrevidas, combínalo con nuestras <a href="/bas-grande-taille">medias de rejilla</a> o <a href="/collants-grande-taille">medias opacas</a> para un look depredador. Remátalo con un <a href="/kimonos-grande-taille">kimono de satén</a> para conseguir un efecto revelador progresivo que cautivará todas las miradas.</p>
summary
string<p>El vestido Vyper es el epítome de la seducción fatal, con su hipnótico efecto de piel de serpiente y su atrevido cuello halter. Esta provocativa creación revela tu lado salvaje con una elegancia inquietante que cautiva todas las miradas.</p>
title
stringSeducción venenosa con efecto serpiente
usageinstructions
string<p>Para <strong>un confort óptimo durante toda la velada,</strong> ponte el vestido Vyper con suavidad para conservar el efecto serpiente y los detalles metálicos.</p> <p>El escote halter se ciñe al cuello para un ajuste seguro. El tejido elástico <strong> se adapta de forma natural a tus formas</strong>, proporcionándote una total libertad de movimientos para que bailes y seduzcas con total facilidad. Para un efecto aún más hechizante, llévalo con ropa interior invisible que deje entrever tus curvas salvajes.</p>
fr
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavage &agrave; la main &agrave; l'eau ti&egrave;de avec un savon doux</li> <li>&Eacute;viter les produits agressifs qui pourraient alt&eacute;rer l'effet serpent</li> <li>S&eacute;chage &agrave; plat, &agrave; l'abri de la chaleur directe</li> <li>Ranger d&eacute;licatement pour pr&eacute;server les d&eacute;tails m&eacute;talliques</li> <li>&Eacute;viter le contact avec des objets pointus ou rugueux</li> </ul>
description
string<p>La robe Vyper transforme chaque apparition en moment de <strong>s&eacute;duction absolue</strong>. Son effet peau de serpent aux reflets m&eacute;talliques caresse la peau tout en <strong>sublimant vos courbes g&eacute;n&eacute;reuses</strong> avec une sensualit&eacute; sauvage. Le col licou cr&eacute;e un d&eacute;collet&eacute; sophistiqu&eacute;, r&eacute;v&eacute;lant juste ce qu'il faut pour troubler les esprits.</p> <p>Cette cr&eacute;ation <strong>s'adapte &agrave; toutes les morphologies</strong> gr&acirc;ce &agrave; son tissu extensible qui &eacute;pouse parfaitement vos formes sans jamais contraindre. Les d&eacute;tails m&eacute;talliques sur le d&eacute;collet&eacute; ajoutent une dimension hypnotique, cr&eacute;ant un jeu de lumi&egrave;re qui attire irr&eacute;sistiblement les regards. Sa coupe courte et moulante r&eacute;v&egrave;le votre silhouette avec une audace assum&eacute;e, parfaite pour vos soir&eacute;es les plus envo&ucirc;tantes.</p>
guid
stringhttps://dev.divasboudoir.com/fr/robe-vyper-effet-serpent-grande-taille/cdbu4936.htm
highlights
string<ul> <li><strong>Effet peau de serpent</strong> pour un look myst&eacute;rieux et captivant</li> <li><strong>Col licou sophistiqu&eacute;</strong> qui d&eacute;voile les &eacute;paules avec audace</li> <li><strong>D&eacute;tails m&eacute;talliques</strong> sur le d&eacute;collet&eacute; pour un effet hypnotisant</li> <li><strong>Coupe moulante</strong> qui &eacute;pouse sensuellement toutes les courbes</li> <li><strong>Tissu &eacute;lastique</strong> pour un confort optimal et une libert&eacute; totale</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringRobe Vyper effet serpent grande taille : col licou sexy, détails métalliques, coupe moulante, tissu élastique. Séduction venimeuse garantie. Diva's Boudoir.
keywords
string
title
stringRobe Vyper Effet Serpent Grande Taille Col Licou | Diva's Boudoir
seotitle
stringRobe sexy grande taille effet serpent col licou noire
seouri
stringrobe-vyper-effet-serpent-grande-taille
specifications
string<ul> <li><strong>Mati&egrave;re :</strong> Tissu &eacute;lastique effet serpent (92% polyester, 8% &eacute;lasthanne)</li> <li><strong>Couleur :</strong> noir intense avec reflets m&eacute;talliques</li> <li><strong>Coupe :</strong> Moulante avec col licou</li> <li><strong>D&eacute;tails :</strong> Anneaux m&eacute;talliques sur le d&eacute;collet&eacute;</li> <li><strong>Longueur :</strong> Mini, au-dessus du genou</li> </ul>
stylingtips
string<p>La robe Vyper se sublime avec des <strong>escarpins noirs vernis</strong> pour un total look fatal, ou des bottines &agrave; talons pour un style rock-chic irr&eacute;sistible.</p> <p>Ajoutez des bijoux dor&eacute;s ou argent&eacute;s qui font &eacute;cho aux d&eacute;tails m&eacute;talliques. Pour vos soir&eacute;es les plus audacieuses, associez-la &agrave; nos&nbsp;<a href="/bas-grande-taille">bas r&eacute;sille</a> ou nos <a href="/collants-grande-taille">collants opaques</a> pour un look de pr&eacute;datrice. Compl&eacute;tez avec un <a href="/kimonos-grande-taille">kimono satin&eacute;</a> pour un jeu de d&eacute;voilement progressif qui hypnotisera tous les regards.</p>
summary
string<p>La robe Vyper incarne la s&eacute;duction fatale avec son effet peau de serpent hypnotisant et son col licou audacieux. Cette cr&eacute;ation provocante r&eacute;v&egrave;le votre c&ocirc;t&eacute; sauvage avec une &eacute;l&eacute;gance troublante qui captive tous les regards.</p>
title
stringRobe Vyper: Séduction Venimeuse
usageinstructions
string<p>Pour un <strong>confort optimal toute la soir&eacute;e</strong>, enfilez la robe Vyper en douceur pour pr&eacute;server l'effet serpent et les d&eacute;tails m&eacute;talliques.</p> <p>Le col licou s'ajuste parfaitement autour du cou pour un maintien s&eacute;curis&eacute;. Le tissu extensible&nbsp;<strong>&eacute;pouse naturellement vos formes</strong> et permet une libert&eacute; de mouvement totale pour danser et s&eacute;duire en toute aisance. Pour un effet encore plus envo&ucirc;tant, portez-la avec des sous-v&ecirc;tements invisibles qui laissent deviner vos courbes sauvages.</p>
it
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavare a mano in acqua tiepida con sapone neutro</li> <li>evitare prodotti aggressivi che potrebbero alterare l'effetto serpente</li> <li>Asciugare in piano, lontano da fonti di calore dirette</li> <li>Conservare delicatamente per preservare i dettagli metallici</li> <li>evitare il contatto con oggetti appuntiti o ruvidi</li> </ul>
description
string<p>L'abito Vyper trasforma ogni apparizione in un momento di <strong>assoluta seduzione</strong>. L'effetto pelle di serpente dalla lucentezza metallica accarezza la pelle ed <strong>esalta le vostre curve generose</strong> con selvaggia sensualità. Il collo a farfalla crea un d&eacute;collet&eacute; sofisticato, rivelando quel tanto che basta per sconvolgere i sensi.</p> <p>Questa creazione <strong>si adatta a tutte le forme del corpo</strong> grazie al tessuto elasticizzato, che abbraccia le vostre curve senza costringerle. I dettagli metallici sulla scollatura aggiungono una dimensione ipnotica, creando un gioco di luci irresistibilmente accattivante. Il taglio corto e aderente rivela la silhouette con un atteggiamento audace, perfetto per le serate più ammalianti.</p>
guid
stringhttps://dev.divasboudoir.com/it/abiti-sexy-nero/cdbu4936.htm
highlights
string<ul> <li><strong>Effetto pelle di serpente</strong> per un look misterioso e accattivante</li> <li><strong>Sofisticato collo halter</strong> che scopre audacemente le spalle</li> <li><strong>Dettagli metallici</strong> sulla scollatura per un effetto ipnotico</li> <li><strong>Taglio aderente al corpo</strong> che abbraccia sensualmente ogni curva</li> <li><strong>Tessuto elastico</strong> per un comfort ottimale e una libertà totale</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringAbito Vyper effetto serpente in taglia grande: sexy collo a farfalla, dettagli metallici, vestibilità slim, tessuto elasticizzato. Seduzione velenosa garantita. Diva's Boudoir.
keywords
string
title
stringAbito effetto serpente Vyper Taglia grande Collo Halter | Diva's Boudoir
seotitle
stringSexy abito nero effetto serpente di taglia grande con collo a cavezza
seouri
stringabiti-sexy-nero
specifications
string<ul> <li><strong>Materiale:</strong> tessuto elasticizzato effetto serpente (92% poliestere, 8% elastan)</li> <li><strong>Colore:</strong> nero intenso con riflessi metallici</li> <li><strong>Taglio:</strong> aderente con collo a farfalla</li> <li><strong>Dettagli:</strong> anelli metallici sulla scollatura</li> <li><strong>Lunghezza:</strong> mini, sopra il ginocchio</li> </ul>
stylingtips
string<p>L'abito Vyper è perfetto da abbinare a <strong>décolleté in vernice nera</strong> per un look da urlo, o a stivaletti con tacco per un irresistibile stile rock-chic.</p> <p>Aggiungete gioielli d'oro o d'argento per far risaltare i dettagli metallici. Per le serate più audaci, abbinatelo alle nostre <a href="/bas-grande-taille">calze a rete</a> o ai <a href="/collants-grande-taille">collant coprenti</a> per un look da predatore. Completate il tutto con un <a href="/kimonos-grande-taille">kimono in raso</a> per un effetto di svelamento progressivo che ipnotizzerà tutti gli sguardi.</p>
summary
string<p>L'abito Vyper è l'epitome della seduzione fatale, con il suo ipnotico effetto pelle di serpente e l'audace collo halter. Questa creazione provocante rivela il vostro lato selvaggio con un'eleganza inquietante che cattura tutti gli sguardi.</p>
title
stringSeduzione velenosa con effetto serpente
usageinstructions
string<p>Per un <strong>comfort ottimale durante tutta la serata, indossate</strong> l'abito Vyper con delicatezza per preservare l'effetto serpente e i dettagli metallici.</p> <p>La scollatura si adatta al collo per una vestibilità sicura. Il tessuto elasticizzato <strong> aderisce naturalmente alle vostre forme</strong>, offrendovi una totale libertà di movimento per ballare e sedurre in tutta tranquillità. Per un effetto ancora più ammaliante, indossatelo con un intimo invisibile che lasci trasparire le vostre curve selvagge.</p>
nl
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Handwas in lauw water met milde zeep</li> <li>vermijd agressieve producten die het effect van de slang kunnen veranderen</li> <li>Plat drogen, niet blootstellen aan directe warmte</li> <li>Voorzichtig bewaren om metalen details te behouden</li> <li>vermijd contact met scherpe of ruwe voorwerpen</li> </ul>
description
string<p>De Vyper-jurk maakt van elke verschijning een moment van <strong>absolute verleiding</strong>. Het slangenleren effect met een metallic glans streelt de huid terwijl <strong>het je royale rondingen</strong> met wilde sensualiteit <strong>benadrukt</strong>. De halternek cre&euml;ert een geraffineerd decollet&eacute; dat net genoeg onthult om de zintuigen te prikkelen.</p> <p>Deze creatie <strong>past zich aan alle lichaamsvormen</strong> aan dankzij de stretchstof, die je rondingen omhelst zonder ze te beperken. De metallic details op de halslijn voegen een hypnotiserende dimensie toe en cre&euml;ren een lichtspel dat onweerstaanbaar in het oog springt. Het korte, nauwsluitende model onthult je silhouet met een veronderstelde brutaliteit, perfect voor je meest betoverende avondjes uit.</p>
guid
stringhttps://dev.divasboudoir.com/nl/sexy-jurken-zwart/cdbu4936.htm
highlights
string<ul> <li><strong>Slangenleereffect</strong> voor een mysterieuze en fascinerende look</li> <li><strong>Geraffineerde halternek</strong> die de schouders blootgeeft</li> <li><strong>Metallic details</strong> op de halslijn voor een betoverend effect</li> <li><strong>Aansluitend model</strong> dat elke ronding sensueel omsluit</li> <li><strong>Elastische stof</strong> voor optimaal comfort en totale vrijheid</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringVyper jurk met slangeneffect in grote maten: sexy halternek, metallic details, slanke pasvorm, stretchstof. Gifverleiding gegarandeerd. Diva's Boudoir.
keywords
string
title
stringVyper Slangeneffect Jurk Grote Maat Halter Hals | Diva's Boudoir
seotitle
stringSexy grote maat zwart halterjurkje met slangeneffect
seouri
stringsexy-jurken-zwart
specifications
string<ul> <li><strong>Materiaal:</strong> stretchstof met slangeneffect (92% polyester, 8% elastaan)</li> <li><strong>Kleur:</strong> diepzwart met metallic accenten</li> <li><strong>Snit:</strong> nauwsluitend met halternek</li> <li><strong>Details:</strong> Metallic ringen aan halslijn</li> <li><strong>Lengte:</strong> Mini, boven de knie</li> </ul>
stylingtips
string<p>De Vyper jurk is perfect met <strong>zwarte lakpumps</strong> voor een killer look, of enkellaarsjes met hak voor een onweerstaanbare rock-chic stijl.</p> <p>Voeg gouden of zilveren sieraden toe om de metallic details te benadrukken. Voor je meest gedurfde avondjes uit combineer je het met onze <a href="/bas-grande-taille">visnetkousen</a> of <a href="/collants-grande-taille">ondoorzichtige panty's</a> voor een roofdierlook. Maak het af met een <a href="/kimonos-grande-taille">satijnen kimono</a> voor een progressief onthullend effect dat alle ogen zal betoveren.</p>
summary
string<p>De Vyper-jurk belichaamt fatale verleiding met zijn hypnotiserende slangenleereffect en gedurfde halternek. Deze provocerende creatie onthult je wilde kant met een verontrustende elegantie die alle ogen in vervoering brengt.</p>
title
stringGiftige verleiding met slangeneffect
usageinstructions
string<p>Voor <strong>optimaal comfort de hele avond lang</strong> trek je de Vyper-jurk voorzichtig aan om het slangeneffect en de metallic details te behouden.</p> <p>De halternek sluit mooi aan rond je nek voor een stevige pasvorm. De stretchstof <strong> omsluit je vorm op natuurlijke wijze</strong> en geeft je totale bewegingsvrijheid zodat je op je gemak kunt dansen en verleiden. Voor een nog betoverender effect draag je het met onzichtbaar ondergoed dat je wilde rondingen laat zien.</p>
pt
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavar à mão em água tépida com sabão neutro</li> <li>evitar produtos agressivos que possam alterar o efeito de serpente</li> <li>Secar na horizontal, longe do calor direto</li> <li>Guardar com cuidado para preservar os pormenores metálicos</li> <li>evitar o contacto com objectos afiados ou ásperos</li> </ul>
description
string<p>O vestido Vyper transforma cada aparição num momento de <strong>absoluta sedução</strong>. O seu efeito pele de cobra com um brilho metálico acaricia a pele enquanto <strong>realça as suas curvas generosas</strong> com uma sensualidade selvagem. O decote halter cria um decote sofisticado, revelando apenas o suficiente para perturbar os sentidos.</p> <p>Esta criação <strong>adapta-se a todas as formas do corpo</strong> graças ao seu tecido elástico, que abraça as suas curvas sem as constranger. Os pormenores metálicos no decote acrescentam uma dimensão hipnótica, criando um jogo de luz irresistivelmente atraente. O seu corte curto e justo revela a sua silhueta com uma atitude ousada, perfeita para as suas noites mais encantadoras.</p>
guid
stringhttps://dev.divasboudoir.com/pt/vestidos-sensuais-preto/cdbu4936.htm
highlights
string<ul> <li><strong>Efeito pele de cobra</strong> para um look misterioso e cativante</li> <li><strong>Sofisticado decote haltere</strong> que revela corajosamente os ombros</li> <li><strong>Detalhes metálicos</strong> no decote para um efeito hipnotizante</li> <li><strong>Corte justo ao corpo</strong> que abraça sensualmente todas as curvas</li> <li><strong>Tecido elástico</strong> para um conforto ótimo e uma liberdade total</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringVestido Vyper com efeito cobra em tamanho grande: decote halter sexy, detalhes metálicos, corte justo, tecido elástico. Sedução venenosa garantida. Boudoir de Diva.
keywords
string
title
stringVestido efeito cobra Vyper Tamanho grande com decote haltere | Diva's Boudoir
seotitle
stringVestido sexy com decote haltere e efeito cobra preto de tamanho grande
seouri
stringvestidos-sensuais-preto
specifications
string<ul> <li><strong>Material:</strong> tecido elástico com efeito de cobra (92% poliéster, 8% elastano)</li> <li><strong>Cor:</strong> preto profundo com reflexos metálicos</li> <li><strong>Corte:</strong> justo com decote haltere</li> <li><strong>Pormenores:</strong> Anéis metálicos no decote</li> <li><strong>Comprimento:</strong> Mini, acima do joelho</li> </ul>
stylingtips
string<p>O vestido Vyper é perfeito com <strong>sapatos de verniz pretos</strong> para um look de arrasar, ou botins de salto alto para um estilo rock-chic irresistível.</p> <p>Adicione jóias douradas ou prateadas para fazer eco dos detalhes metálicos. Para as suas saídas nocturnas mais ousadas, combine-o com as nossas <a href="/bas-grande-taille">meias de rede</a> ou <a href="/collants-grande-taille">collants opacos</a> para um look predador. Complete-o com um <a href="/kimonos-grande-taille">quimono de cetim</a> para um efeito revelador progressivo que irá hipnotizar todos os olhares.</p>
summary
string<p>O vestido Vyper é o epítome da sedução fatal, com o seu efeito hipnótico de pele de cobra e o seu ousado decote halter. Esta criação provocante revela o seu lado selvagem com uma elegância inquietante que cativa todos os olhares.</p>
title
stringSedução venenosa com efeito de serpente
usageinstructions
string<p>Para um <strong>conforto ótimo durante toda a noite,</strong> calce o vestido Vyper com cuidado para preservar o efeito de cobra e os detalhes metálicos.</p> <p>O decote halter ajusta-se confortavelmente ao pescoço para um ajuste seguro. O tecido elástico <strong> abraça naturalmente a sua forma</strong>, dando-lhe total liberdade de movimentos para que possa dançar e seduzir com total facilidade. Para um efeito ainda mais fascinante, use-o com roupa interior invisível que deixa transparecer as suas curvas selvagens.</p>
fetishboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
latexboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
legsboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
lustboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
smboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
name
stringsz2406242523627232
netweight
string
nextshipment
stringtomorrow
ordered
number10
orderidx
number0
origin
string
originalsize
string
packaging
number0
productshipment
stringauto
productuid
string88B10665-B344-4EA7-B256938AF5AC37BA
promountil
string
rating
stringnone
recorduid
string88B10665-B344-4EA7-B256938AF5AC37BA
reference
stringCDBU4936
related
string
reserved
number0
returned
number0
returnsallowed
number1
section
stringcabaret
shipment
string5to7days
showbrand
number0
sizeinfos
Query
Template: /system/api/product/sizes.cfc:20
Execution Time: 1.49 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,'2351,2352,2353,2354,2355') > 0
and product_variations.productuid = '88B10665-B344-4EA7-B256938AF5AC37BA'
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
123554Xintlsizeblack4X4X-19999990wplusdress4XL4X50-5220-2224-2652-5452-5450-5256-5852-5450-52128-134107-112133-140
22351XLintlsizeblackXLXL-19999990wplusdress0XLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42100-10779-86105-112
323521Xintlsizeblack1X1X-19999990wplusdress1XL1X44-4614-1618-2046-4846-4844-4650-5246-4844-46107-11486-93112-119
423532XLintlsizeblack2XL2XL-19999990wplusdress2XL2XL46-4816-1820-2248-5048-5046-4852-5448-5046-48114-12193-100119-126
523543Xintlsizeblack3X3X-19999990wplusdress3XL3X48-5018-2022-2450-5250-5248-5054-5650-5248-50121-128100-107126-133
sizeranges
stringplus
sizes
string2351,2352,2353,2354,2355
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: 22.9 ms
Record Count: 5
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 = '88B10665-B344-4EA7-B256938AF5AC37BA'
and product_variations.isactive = 1
and product_sizes.id_size = 2351
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 = '88B10665-B344-4EA7-B256938AF5AC37BA'
and product_variations.isactive = 1
and product_sizes.id_size = 2352
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 = '88B10665-B344-4EA7-B256938AF5AC37BA'
and product_variations.isactive = 1
and product_sizes.id_size = 2353
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 = '88B10665-B344-4EA7-B256938AF5AC37BA'
and product_variations.isactive = 1
and product_sizes.id_size = 2354
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 = '88B10665-B344-4EA7-B256938AF5AC37BA'
and product_variations.isactive = 1
and product_sizes.id_size = 2355
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
188B10665-B344-4EA7-B256938AF5AC37BAC07B52E9-1362-42ED-BCF6DA8B2182CF5A2355black#0000004XL4X50-5220-2224-2652-5452-5450-5256-5852-5450-52wdress4Xintlsize33.291724.9583{ts '2025-11-03 00:00:00'}STOCK01000-10400S3419-12HMRYV50396380857-10all
288B10665-B344-4EA7-B256938AF5AC37BAE946346F-78CC-4F86-B4DCD916ED101F202351black#0000000XLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42wdressXLintlsize33.291724.9583{ts '2025-11-03 00:00:00'}STOCK01000-10100S3419-12GVXI3Z0396380832-10all
388B10665-B344-4EA7-B256938AF5AC37BA734D5C1D-460C-410A-8396663288A142422352black#0000001XL1X44-4614-1618-2046-4846-4844-4650-5246-4844-46wdress1Xintlsize33.291724.9583{ts '2025-11-03 00:00:00'}STOCK01000-10200S3419-1-10all
488B10665-B344-4EA7-B256938AF5AC37BA2354C967-AC02-4E69-96F0039083A1E0392353black#0000002XL2XL46-4816-1820-2248-5048-5046-4852-5448-5046-48wdress2XLintlsize33.291724.9583{ts '2025-11-03 00:00:00'}STOCK01000-10300S3419-12GOYL560396380842-10all
588B10665-B344-4EA7-B256938AF5AC37BAFD386466-FCFA-4F42-B8C9F2E2B6ADED1B2354black#0000003XL3X48-5018-2022-2450-5250-5248-5054-5650-5248-50wdress3Xintlsize33.291724.9583{ts '2025-11-03 00:00:00'}STOCK01000-10200S3419-12HMRYV50396380852-10all
subcategory
stringall
supplier
number-1
supplierreference
stringSZ2406242523627232
tags
string
themes
string
totalvariations
number5
type
stringdefault
unitprice
number33.2917
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 9.81 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 = '88B10665-B344-4EA7-B256938AF5AC37BA' 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 = '88B10665-B344-4EA7-B256938AF5AC37BA' 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 = '88B10665-B344-4EA7-B256938AF5AC37BA' 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 = '88B10665-B344-4EA7-B256938AF5AC37BA' 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 = '88B10665-B344-4EA7-B256938AF5AC37BA' 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 = '88B10665-B344-4EA7-B256938AF5AC37BA' 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 = '88B10665-B344-4EA7-B256938AF5AC37BA'
and product_variations.isactive = 1
and product_sizes.id_size = 2351
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 = '88B10665-B344-4EA7-B256938AF5AC37BA' 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 = '88B10665-B344-4EA7-B256938AF5AC37BA' 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 = '88B10665-B344-4EA7-B256938AF5AC37BA' 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 = '88B10665-B344-4EA7-B256938AF5AC37BA' 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 = '88B10665-B344-4EA7-B256938AF5AC37BA' 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 = '88B10665-B344-4EA7-B256938AF5AC37BA' 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 = '88B10665-B344-4EA7-B256938AF5AC37BA'
and product_variations.isactive = 1
and product_sizes.id_size = 2352
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 = '88B10665-B344-4EA7-B256938AF5AC37BA' 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 = '88B10665-B344-4EA7-B256938AF5AC37BA' 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 = '88B10665-B344-4EA7-B256938AF5AC37BA' 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 = '88B10665-B344-4EA7-B256938AF5AC37BA' 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 = '88B10665-B344-4EA7-B256938AF5AC37BA' 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 = '88B10665-B344-4EA7-B256938AF5AC37BA' 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 = '88B10665-B344-4EA7-B256938AF5AC37BA'
and product_variations.isactive = 1
and product_sizes.id_size = 2353
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 = '88B10665-B344-4EA7-B256938AF5AC37BA' 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 = '88B10665-B344-4EA7-B256938AF5AC37BA' 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 = '88B10665-B344-4EA7-B256938AF5AC37BA' 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 = '88B10665-B344-4EA7-B256938AF5AC37BA' 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 = '88B10665-B344-4EA7-B256938AF5AC37BA' 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 = '88B10665-B344-4EA7-B256938AF5AC37BA' 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 = '88B10665-B344-4EA7-B256938AF5AC37BA'
and product_variations.isactive = 1
and product_sizes.id_size = 2354
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 = '88B10665-B344-4EA7-B256938AF5AC37BA' 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 = '88B10665-B344-4EA7-B256938AF5AC37BA' 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 = '88B10665-B344-4EA7-B256938AF5AC37BA' 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 = '88B10665-B344-4EA7-B256938AF5AC37BA' 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 = '88B10665-B344-4EA7-B256938AF5AC37BA' 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 = '88B10665-B344-4EA7-B256938AF5AC37BA' 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 = '88B10665-B344-4EA7-B256938AF5AC37BA'
and product_variations.isactive = 1
and product_sizes.id_size = 2355
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
1C07B52E9-1362-42ED-BCF6DA8B2182CF5A2355black#0000004XL4X50-5220-2224-2652-5452-5450-5256-5852-5450-52wdress4Xintlsize33.291724.9583{ts '2025-11-03 00:00:00'}STOCK01000-10400S3419-12HMRYV50396380857-10-10-10033.2917all
2E946346F-78CC-4F86-B4DCD916ED101F202351black#0000000XLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42wdressXLintlsize33.291724.9583{ts '2025-11-03 00:00:00'}STOCK01000-10100S3419-12GVXI3Z0396380832-10-10-10033.2917all
3734D5C1D-460C-410A-8396663288A142422352black#0000001XL1X44-4614-1618-2046-4846-4844-4650-5246-4844-46wdress1Xintlsize33.291724.9583{ts '2025-11-03 00:00:00'}STOCK01000-10200S3419-1-10-10-10033.2917all
42354C967-AC02-4E69-96F0039083A1E0392353black#0000002XL2XL46-4816-1820-2248-5048-5046-4852-5448-5046-48wdress2XLintlsize33.291724.9583{ts '2025-11-03 00:00:00'}STOCK01000-10300S3419-12GOYL560396380842-10-10-10033.2917all
5FD386466-FCFA-4F42-B8C9F2E2B6ADED1B2354black#0000003XL3X48-5018-2022-2450-5250-5248-5054-5650-5248-50wdress3Xintlsize33.291724.9583{ts '2025-11-03 00:00:00'}STOCK01000-10200S3419-12HMRYV50396380852-10-10-10033.2917all
vatrate
number20
warehouse
number0