Δείτε τα μεγέθη

Δηλητηριώδης αποπλάνηση με επίδραση φιδιού

Διπλό κλικ για μεγέθυνση

SKU: CDBU4936

Δηλητηριώδης αποπλάνηση με επίδραση φιδιού

Απόθεμα:

Το φόρεμα Vyper είναι η επιτομή της μοιραίας αποπλάνησης, με το υπνωτιστικό εφέ φιδίσιας επιδερμίδας και το τολμηρό λαιμόκοψη. Αυτή η προκλητική δημιουργία αποκαλύπτει την άγρια πλευρά σας με μια ανησυχητική κομψότητα που μαγνητίζει όλα τα βλέμματα.

Κύρια σημεία

Φιδίσιο εφέ για μια μυστηριώδη και γοητευτική εμφάνιση
Εκλεπτυσμένη λαιμόκοψη που αποκαλύπτει τολμηρά τους ώμους
Μεταλλικές λεπτομέρειες στη λαιμόκοψη για ένα μαγευτικό αποτέλεσμα
Κούρεμα που αγκαλιάζει το σώμα και αγκαλιάζει αισθησιακά κάθε καμπύλη
Ελαστικό ύφασμα για βέλτιστη άνεση και απόλυτη ελευθερία

Μέγεθος:

Δεν είστε σίγουροι για το μέγεθος που πρέπει να επιλέξετε Συμβουλευτείτε τον οδηγό μεγεθών μας

Χρώμα:

Ποσότητα:

39.95 €

Βοήθεια και συμβουλές

μέσω chat, facebook ή e-mail

Δωρεάν επιστροφές

εντός 15 ημερών *

Σέξι μεγάλο μέγεθος μαύρο φόρεμα με λαιμόκοψη από φίδι

Name: Σέξι μεγάλο μέγεθος μαύρο φόρεμα με λαιμόκοψη από φίδι - -1
Brand: Μπουντουάρ της Ντίβας
SKU: CDBU4936
Price: 39.95 EUR
Availability: InStock

Περιγραφή του προϊόντος

Το φόρεμα Vyper μετατρέπει κάθε εμφάνιση σε μια στιγμή απόλυτης αποπλάνησης. Το φιδίσιο εφέ του με μεταλλική λάμψη χαϊδεύει το δέρμα, ενώ αναδεικνύει τις πλούσιες καμπύλες σας με άγριο αισθησιασμό. Ο λαιμός με λαιμόκοψη δημιουργεί ένα εκλεπτυσμένο ντεκολτέ, αποκαλύπτοντας όσο χρειάζεται για να αναστατώσει τις αισθήσεις.

Αυτή η δημιουργία προσαρμόζεται σε όλα τα σχήματα του σώματος χάρη στο ελαστικό του ύφασμα, το οποίο αγκαλιάζει τις καμπύλες σας χωρίς να τις περιορίζει. Οι μεταλλικές λεπτομέρειες στο ντεκολτέ προσθέτουν μια υπνωτιστική διάσταση, δημιουργώντας ένα παιχνίδι φωτός που τραβάει ακαταμάχητα τα βλέμματα. Το κοντό, εφαρμοστό κόψιμό του αποκαλύπτει τη σιλουέτα σας με μια υποτιθέμενη τόλμη, ιδανική για τις πιο μαγευτικές βραδινές σας εξόδους.

Τεχνικές λεπτομέρειες

Υλικό: ελαστικό ύφασμα με εφέ φιδιού (92% πολυεστέρας, 8% ελαστάν)
Χρώμα: βαθύ μαύρο με μεταλλικές ανταύγειες
Κοπή: Φόρμα με λαιμόκοψη
Λεπτομέρειες: Μεταλλικοί κρίκοι στη λαιμόκοψη
Μήκος: Μίνι, πάνω από το γόνατο

Διαθέσιμα μεγέθη

Διαθέσιμο από 4X έως 3X

Διαθέσιμο χρώμα

Μαύρο

Οδηγός διαστασιολόγησης

Ελέγξτε το σωστό μέγεθος για εσάς

Διεθνές	Στήθος Μέγεθος Γοφοί
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

Οδηγίες φροντίδας

Πλύνετε στο χέρι με χλιαρό νερό και ήπιο σαπούνι
αποφύγετε επιθετικά προϊόντα που θα μπορούσαν να αλλοιώσουν το αποτέλεσμα του φιδιού
Στεγνώστε σε επίπεδη επιφάνεια, μακριά από άμεση θερμότητα
Αποθηκεύστε απαλά για να διατηρήσετε τις μεταλλικές λεπτομέρειες
αποφύγετε την επαφή με αιχμηρά ή τραχιά αντικείμενα

Συμβουλές χρήσης

Για βέλτιστη άνεση καθ' όλη τη διάρκεια της βραδιάς, φορέστε το φόρεμα Vyper απαλά για να διατηρήσετε το εφέ φιδιού και τις μεταλλικές λεπτομέρειες.

Ο λαιμός με λαιμόκοψη εφαρμόζει άνετα γύρω από το λαιμό σας για ασφαλή εφαρμογή. Το ελαστικό ύφασμα αγκαλιάζει φυσικά το σχήμα σας, χαρίζοντάς σας απόλυτη ελευθερία κινήσεων, ώστε να μπορείτε να χορεύετε και να αποπλανείτε με απόλυτη άνεση. Για ακόμα πιο μαγευτικό αποτέλεσμα, φορέστε το με αόρατο εσώρουχο που αφήνει να φανούν οι άγριες καμπύλες σας.

Συμβουλές στυλ

Το φόρεμα Vyper ταιριάζει τέλεια με μαύρες λουστρίνι γόβες για μια απόλυτα φονική εμφάνιση ή με μποτάκια με τακούνι για ένα ακαταμάχητο ροκ-σικ στυλ.

Προσθέστε χρυσά ή ασημένια κοσμήματα για να αναδείξετε τις μεταλλικές λεπτομέρειες. Για τις πιο τολμηρές βραδινές σας εξόδους, συνδυάστε το με τις διχτυωτές κάλτσες μας ή το αδιαφανές καλσόν μας για μια αρπακτική εμφάνιση. Συμπληρώστε το με ένα σατέν κιμονό για ένα προοδευτικό αποκαλυπτικό αποτέλεσμα που θα μαγνητίσει όλα τα βλέμματα.

To Top

Η τοποθεσία σας είναι:
Ηνωμένες Πολιτείες Αμερικής

Η γλώσσα σας είναι: Ελληνικά

Οι τιμές είναι σε: EUR (€)

Αποθήκευση των προτιμήσεών μου

Συνέχεια

Να αλλάξω τις ρυθμίσεις μου

Χώρα Γλώσσα

Αποθήκευση των προτιμήσεών μου

Ακυρώστε το

Struct
Entries: 108

actions

Array

available

number

-1

brand

string

divasfashion

brandcode

string

dvqc

branding

string

divasboudoir

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

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

brandname

string

Diva's Fashion

breasts

string

careinstructions

string

category

subcategory

linkuid

string

materials

string

mediadatas

Struct

alt

Struct

height

string

1736

isprivate

string

rating

string

all

src

string

/photobank/products/dvqc/cdbu4936/robe_grande_taille_serpent_dos.jpg

type

string

img

width

string

1201

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

1976

isprivate

string

rating

string

all

src

string

/photobank/products/dvqc/cdbu4936/robe_grande_taille_serpent.jpg

type

string

img

width

string

1367

variations

Struct

colors

Struct

black

Struct

height

string

1976

isprivate

string

rating

string

all

src

string

/photobank/products/dvqc/cdbu4936/robe_grande_taille_serpent.jpg

type

string

img

width

string

1367

video

Struct

embedsrc

string

height

string

isprivate

string

rating

string

src

string

thumb

Struct

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

high

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

maxres

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

medium

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

standard

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

type

string

width

string

mediagallery

string

products.divasfashion.cdbu4936

metadatas

Struct

darkboudoir

Struct

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

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

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

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

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

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

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

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

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

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.

guid

string

https://dev.divasboudoir.com/de/sexy-kleider-schwarz/cdbu4936.htm

highlights

string

<ul> <li>Schlangenhaut-Effekt für einen geheimnisvollen und fesselnden Look</li> <li>Raffinierter Halfterkragen, der die Schultern kühn enthüllt</li> <li>Metallische Details am Dekolleté für einen hypnotisierenden Effekt</li> <li>Eng anliegender Schnitt, der sich sinnlich an jede Kurve schmiegt</li> <li>Elastischer Stoff für optimalen Tragekomfort und absolute Freiheit</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Vyper-Kleid mit Schlangeneffekt in Übergröße: sexy Einhalskragen, Metalldetails, eng anliegender Schnitt, elastischer Stoff. Giftige Verführung garantiert. Diva's Boudoir.

keywords

string

title

string

Vyper Kleid mit Schlangenleder-Effekt Große Größe mit Kragen und Halfter | Diva's Boudoir

seotitle

string

Sexy Kleid in Übergröße Schlangeneffekt Halfterkragen schwarz

seouri

string

sexy-kleider-schwarz

specifications

string

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

stylingtips

string

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 <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.

summary

string

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.

title

string

Giftige Verführung im Schlangeneffekt

usageinstructions

string

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.

Struct
Entries: 15

abstract

string

careinstructions

string

<ul> <li>Πλύνετε στο χέρι με χλιαρό νερό και ήπιο σαπούνι</li> <li>αποφύγετε επιθετικά προϊόντα που θα μπορούσαν να αλλοιώσουν το αποτέλεσμα του φιδιού</li> <li>Στεγνώστε σε επίπεδη επιφάνεια, μακριά από άμεση θερμότητα</li> <li>Αποθηκεύστε απαλά για να διατηρήσετε τις μεταλλικές λεπτομέρειες</li> <li>αποφύγετε την επαφή με αιχμηρά ή τραχιά αντικείμενα</li> </ul>

description

string

Το φόρεμα Vyper μετατρέπει κάθε εμφάνιση σε μια στιγμή απόλυτης αποπλάνησης. Το φιδίσιο εφέ του με μεταλλική λάμψη χαϊδεύει το δέρμα, ενώ αναδεικνύει τις πλούσιες καμπύλες σας με άγριο αισθησιασμό. Ο λαιμός με λαιμόκοψη δημιουργεί ένα εκλεπτυσμένο ντεκολτέ, αποκαλύπτοντας όσο χρειάζεται για να αναστατώσει τις αισθήσεις. Αυτή η δημιουργία προσαρμόζεται σε όλα τα σχήματα του σώματος χάρη στο ελαστικό του ύφασμα, το οποίο αγκαλιάζει τις καμπύλες σας χωρίς να τις περιορίζει. Οι μεταλλικές λεπτομέρειες στο ντεκολτέ προσθέτουν μια υπνωτιστική διάσταση, δημιουργώντας ένα παιχνίδι φωτός που τραβάει ακαταμάχητα τα βλέμματα. Το κοντό, εφαρμοστό κόψιμό του αποκαλύπτει τη σιλουέτα σας με μια υποτιθέμενη τόλμη, ιδανική για τις πιο μαγευτικές βραδινές σας εξόδους.

guid

string

https://dev.divasboudoir.com/el/sexi-foremata-mayro/cdbu4936.htm

highlights

string

<ul> <li>Φιδίσιο εφέ για μια μυστηριώδη και γοητευτική εμφάνιση</li> <li>Εκλεπτυσμένη λαιμόκοψη που αποκαλύπτει τολμηρά τους ώμους</li> <li>Μεταλλικές λεπτομέρειες στη λαιμόκοψη για ένα μαγευτικό αποτέλεσμα</li> <li>Κούρεμα που αγκαλιάζει το σώμα και αγκαλιάζει αισθησιακά κάθε καμπύλη</li> <li>Ελαστικό ύφασμα για βέλτιστη άνεση και απόλυτη ελευθερία</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Φόρεμα Vyper με εφέ φιδιού σε plus size: σέξι λαιμόκοψη halter, μεταλλικές λεπτομέρειες, στενή γραμμή, ελαστικό ύφασμα. Εγγυημένη δηλητηριώδης αποπλάνηση. Μπουντουάρ της Ντίβας.

keywords

string

title

string

Vyper φόρεμα με φιδίσιο εφέ Μεγάλο μέγεθος Halter Neck | Diva's Boudoir

seotitle

string

Σέξι μεγάλο μέγεθος μαύρο φόρεμα με λαιμόκοψη από φίδι

seouri

string

sexi-foremata-mayro

specifications

string

<ul> <li>Υλικό: ελαστικό ύφασμα με εφέ φιδιού (92% πολυεστέρας, 8% ελαστάν)</li> <li>Χρώμα: βαθύ μαύρο με μεταλλικές ανταύγειες</li> <li>Κοπή: Φόρμα με λαιμόκοψη</li> <li>Λεπτομέρειες: Μεταλλικοί κρίκοι στη λαιμόκοψη</li> <li>Μήκος: Μίνι, πάνω από το γόνατο</li> </ul>

stylingtips

string

Το φόρεμα Vyper ταιριάζει τέλεια με μαύρες λουστρίνι γόβες για μια απόλυτα φονική εμφάνιση ή με μποτάκια με τακούνι για ένα ακαταμάχητο ροκ-σικ στυλ. Προσθέστε χρυσά ή ασημένια κοσμήματα για να αναδείξετε τις μεταλλικές λεπτομέρειες. Για τις πιο τολμηρές βραδινές σας εξόδους, συνδυάστε το με τις <a href="/bas-grande-taille">διχτυωτές κάλτσες</a> μας ή το <a href="/collants-grande-taille">αδιαφανές καλσόν</a> μας για μια αρπακτική εμφάνιση. Συμπληρώστε το με ένα <a href="/kimonos-grande-taille">σατέν κιμονό</a> για ένα προοδευτικό αποκαλυπτικό αποτέλεσμα που θα μαγνητίσει όλα τα βλέμματα.

summary

string

Το φόρεμα Vyper είναι η επιτομή της μοιραίας αποπλάνησης, με το υπνωτιστικό εφέ φιδίσιας επιδερμίδας και το τολμηρό λαιμόκοψη. Αυτή η προκλητική δημιουργία αποκαλύπτει την άγρια πλευρά σας με μια ανησυχητική κομψότητα που μαγνητίζει όλα τα βλέμματα.

title

string

Δηλητηριώδης αποπλάνηση με επίδραση φιδιού

usageinstructions

string

Για βέλτιστη άνεση καθ' όλη τη διάρκεια της βραδιάς, φορέστε το φόρεμα Vyper απαλά για να διατηρήσετε το εφέ φιδιού και τις μεταλλικές λεπτομέρειες. Ο λαιμός με λαιμόκοψη εφαρμόζει άνετα γύρω από το λαιμό σας για ασφαλή εφαρμογή. Το ελαστικό ύφασμα αγκαλιάζει φυσικά το σχήμα σας, χαρίζοντάς σας απόλυτη ελευθερία κινήσεων, ώστε να μπορείτε να χορεύετε και να αποπλανείτε με απόλυτη άνεση. Για ακόμα πιο μαγευτικό αποτέλεσμα, φορέστε το με αόρατο εσώρουχο που αφήνει να φανούν οι άγριες καμπύλες σας.

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

The Vyper dress transforms every appearance into a moment of absolute seduction. Its snakeskin effect with metallic sheen caresses the skin while sublimating your generous curves with wild sensuality. The halter neck creates a sophisticated décolleté, revealing just enough to unsettle the spirits. This creation adapts to all body types, thanks to its stretch fabric that perfectly hugs your curves without ever constricting. Metallic details on the décolleté 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.

guid

string

https://dev.divasboudoir.com/en/sexy-dresses-black/cdbu4936.htm

highlights

string

<ul> <li>Snakeskin effect for a mysterious, captivating look</li> <li>Sophisticated halter neck that boldly reveals the shoulders</li> <li>Metallic details on the décolleté for a hypnotic effect</li> <li>Body-hugging cut that sensually hugs every curve</li> <li>Elastic fabric for optimum comfort and total freedom</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Plus-size snake-effect Vyper dress: sexy halter neck, metallic details, slim fit, elastic fabric. Venomous seduction guaranteed. Diva's Boudoir.

keywords

string

title

string

Dress Vyper Snake Effect Plus Size Halter Neck | Diva's Boudoir

seotitle

string

Sexy plus size black halter neck snake effect dress

seouri

string

sexy-dresses-black

specifications

string

<ul> <li>Material: Snake-effect stretch fabric (92% polyester, 8% elastane)</li> <li>Color: deep black with metallic highlights</li> <li>Cut: Form-fitting with halter neck</li> <li>Details: Metallic rings on neckline</li> <li>Length: Mini, above the knee</li> </ul>

stylingtips

string

The Vyper dress is best paired with black patent pumps for a total lethal look, or heeled ankle boots for an irresistible rock-chic style. 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.

summary

string

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.

title

string

Venomous Seduction with Snake Effect

usageinstructions

string

For optimum comfort all evening long, slip on the Vyper dress gently to preserve the snake effect and metallic details. The halter neck fits perfectly around the neck for a secure fit. The stretch fabric naturally hugs your curves, 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.

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

El vestido Vyper convierte cada aparición en un momento de seducción absoluta. Su efecto de piel de serpiente con brillo metálico acaricia la piel al tiempo que realza tus generosas curvas con salvaje sensualidad. El cuello halter crea un escote sofisticado, revelando lo justo para inquietar los sentidos. Esta creación se adapta a todas las formas del cuerpo 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.

guid

string

https://dev.divasboudoir.com/es/vestidos-sexys-negro/cdbu4936.htm

highlights

string

<ul> <li>Efecto piel de serpiente para un look misterioso y cautivador</li> <li>Sofisticado escote halter que deja los hombros al descubierto</li> <li>Detalles metálicos en el escote para un efecto hipnótico</li> <li>Corte ceñido al cuerpo que abraza sensualmente todas las curvas</li> <li>Tejido elástico para un confort óptimo y una libertad total</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Vestido 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

string

Vyper Vestido Efecto Serpiente Talla grande Cuello Halter | Diva's Boudoir

seotitle

string

Sexy talla grande vestido negro efecto serpiente cuello halter

seouri

string

vestidos-sexys-negro

specifications

string

<ul> <li>Material: tejido elástico efecto serpiente (92% poliéster, 8% elastán)</li> <li>Color: negro intenso con reflejos metálicos</li> <li>Corte: ceñido con cuello halter</li> <li>Detalles: Anillos metálicos en el escote</li> <li>Largo: Mini, por encima de la rodilla</li> </ul>

stylingtips

string

El vestido Vyper es perfecto con zapatos de tacón negros de charol para un look total killer, o con botines de tacón para un estilo rock-chic irresistible. 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.

summary

string

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.

title

string

Seducción venenosa con efecto serpiente

usageinstructions

string

Para un confort óptimo durante toda la velada, ponte el vestido Vyper con suavidad para conservar el efecto serpiente y los detalles metálicos. El escote halter se ciñe al cuello para un ajuste seguro. El tejido elástico se adapta de forma natural a tus formas, 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.

Struct
Entries: 15

abstract

string

careinstructions

string

<ul> <li>Lavage à la main à l'eau tiède avec un savon doux</li> <li>Éviter les produits agressifs qui pourraient altérer l'effet serpent</li> <li>Séchage à plat, à l'abri de la chaleur directe</li> <li>Ranger délicatement pour préserver les détails métalliques</li> <li>Éviter le contact avec des objets pointus ou rugueux</li> </ul>

description

string

La robe Vyper transforme chaque apparition en moment de séduction absolue. Son effet peau de serpent aux reflets métalliques caresse la peau tout en sublimant vos courbes généreuses avec une sensualité sauvage. Le col licou crée un décolleté sophistiqué, révélant juste ce qu'il faut pour troubler les esprits. Cette création s'adapte à toutes les morphologies grâce à son tissu extensible qui épouse parfaitement vos formes sans jamais contraindre. Les détails métalliques sur le décolleté ajoutent une dimension hypnotique, créant un jeu de lumière qui attire irrésistiblement les regards. Sa coupe courte et moulante révèle votre silhouette avec une audace assumée, parfaite pour vos soirées les plus envoûtantes.

guid

string

https://dev.divasboudoir.com/fr/robe-vyper-effet-serpent-grande-taille/cdbu4936.htm

highlights

string

<ul> <li>Effet peau de serpent pour un look mystérieux et captivant</li> <li>Col licou sophistiqué qui dévoile les épaules avec audace</li> <li>Détails métalliques sur le décolleté pour un effet hypnotisant</li> <li>Coupe moulante qui épouse sensuellement toutes les courbes</li> <li>Tissu élastique pour un confort optimal et une liberté totale</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Robe 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

string

Robe Vyper Effet Serpent Grande Taille Col Licou | Diva's Boudoir

seotitle

string

Robe sexy grande taille effet serpent col licou noire

seouri

string

robe-vyper-effet-serpent-grande-taille

specifications

string

<ul> <li>Matière : Tissu élastique effet serpent (92% polyester, 8% élasthanne)</li> <li>Couleur : noir intense avec reflets métalliques</li> <li>Coupe : Moulante avec col licou</li> <li>Détails : Anneaux métalliques sur le décolleté</li> <li>Longueur : Mini, au-dessus du genou</li> </ul>

stylingtips

string

La robe Vyper se sublime avec des escarpins noirs vernis pour un total look fatal, ou des bottines à talons pour un style rock-chic irrésistible. Ajoutez des bijoux dorés ou argentés qui font écho aux détails métalliques. Pour vos soirées les plus audacieuses, associez-la à nos <a href="/bas-grande-taille">bas résille</a> ou nos <a href="/collants-grande-taille">collants opaques</a> pour un look de prédatrice. Complétez avec un <a href="/kimonos-grande-taille">kimono satiné</a> pour un jeu de dévoilement progressif qui hypnotisera tous les regards.

summary

string

La robe Vyper incarne la séduction fatale avec son effet peau de serpent hypnotisant et son col licou audacieux. Cette création provocante révèle votre côté sauvage avec une élégance troublante qui captive tous les regards.

title

string

Robe Vyper: Séduction Venimeuse

usageinstructions

string

Pour un confort optimal toute la soirée, enfilez la robe Vyper en douceur pour préserver l'effet serpent et les détails métalliques. Le col licou s'ajuste parfaitement autour du cou pour un maintien sécurisé. Le tissu extensible épouse naturellement vos formes et permet une liberté de mouvement totale pour danser et séduire en toute aisance. Pour un effet encore plus envoûtant, portez-la avec des sous-vêtements invisibles qui laissent deviner vos courbes sauvages.

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

L'abito Vyper trasforma ogni apparizione in un momento di assoluta seduzione. L'effetto pelle di serpente dalla lucentezza metallica accarezza la pelle ed esalta le vostre curve generose con selvaggia sensualità. Il collo a farfalla crea un décolleté sofisticato, rivelando quel tanto che basta per sconvolgere i sensi. Questa creazione si adatta a tutte le forme del corpo 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.

guid

string

https://dev.divasboudoir.com/it/abiti-sexy-nero/cdbu4936.htm

highlights

string

<ul> <li>Effetto pelle di serpente per un look misterioso e accattivante</li> <li>Sofisticato collo halter che scopre audacemente le spalle</li> <li>Dettagli metallici sulla scollatura per un effetto ipnotico</li> <li>Taglio aderente al corpo che abbraccia sensualmente ogni curva</li> <li>Tessuto elastico per un comfort ottimale e una libertà totale</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Abito 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

string

Abito effetto serpente Vyper Taglia grande Collo Halter | Diva's Boudoir

seotitle

string

Sexy abito nero effetto serpente di taglia grande con collo a cavezza

seouri

string

abiti-sexy-nero

specifications

string

<ul> <li>Materiale: tessuto elasticizzato effetto serpente (92% poliestere, 8% elastan)</li> <li>Colore: nero intenso con riflessi metallici</li> <li>Taglio: aderente con collo a farfalla</li> <li>Dettagli: anelli metallici sulla scollatura</li> <li>Lunghezza: mini, sopra il ginocchio</li> </ul>

stylingtips

string

L'abito Vyper è perfetto da abbinare a décolleté in vernice nera per un look da urlo, o a stivaletti con tacco per un irresistibile stile rock-chic. 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.

summary

string

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.

title

string

Seduzione velenosa con effetto serpente

usageinstructions

string

Per un comfort ottimale durante tutta la serata, indossate l'abito Vyper con delicatezza per preservare l'effetto serpente e i dettagli metallici. La scollatura si adatta al collo per una vestibilità sicura. Il tessuto elasticizzato aderisce naturalmente alle vostre forme, 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.

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

De Vyper-jurk maakt van elke verschijning een moment van absolute verleiding. Het slangenleren effect met een metallic glans streelt de huid terwijl het je royale rondingen met wilde sensualiteit benadrukt. De halternek creëert een geraffineerd decolleté dat net genoeg onthult om de zintuigen te prikkelen. Deze creatie past zich aan alle lichaamsvormen 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ë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.

guid

string

https://dev.divasboudoir.com/nl/sexy-jurken-zwart/cdbu4936.htm

highlights

string

<ul> <li>Slangenleereffect voor een mysterieuze en fascinerende look</li> <li>Geraffineerde halternek die de schouders blootgeeft</li> <li>Metallic details op de halslijn voor een betoverend effect</li> <li>Aansluitend model dat elke ronding sensueel omsluit</li> <li>Elastische stof voor optimaal comfort en totale vrijheid</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Vyper jurk met slangeneffect in grote maten: sexy halternek, metallic details, slanke pasvorm, stretchstof. Gifverleiding gegarandeerd. Diva's Boudoir.

keywords

string

title

string

Vyper Slangeneffect Jurk Grote Maat Halter Hals | Diva's Boudoir

seotitle

string

Sexy grote maat zwart halterjurkje met slangeneffect

seouri

string

sexy-jurken-zwart

specifications

string

<ul> <li>Materiaal: stretchstof met slangeneffect (92% polyester, 8% elastaan)</li> <li>Kleur: diepzwart met metallic accenten</li> <li>Snit: nauwsluitend met halternek</li> <li>Details: Metallic ringen aan halslijn</li> <li>Lengte: Mini, boven de knie</li> </ul>

stylingtips

string

De Vyper jurk is perfect met zwarte lakpumps voor een killer look, of enkellaarsjes met hak voor een onweerstaanbare rock-chic stijl. 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.

summary

string

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.

title

string

Giftige verleiding met slangeneffect

usageinstructions

string

Voor optimaal comfort de hele avond lang trek je de Vyper-jurk voorzichtig aan om het slangeneffect en de metallic details te behouden. De halternek sluit mooi aan rond je nek voor een stevige pasvorm. De stretchstof omsluit je vorm op natuurlijke wijze 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.

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

O vestido Vyper transforma cada aparição num momento de absoluta sedução. O seu efeito pele de cobra com um brilho metálico acaricia a pele enquanto realça as suas curvas generosas com uma sensualidade selvagem. O decote halter cria um decote sofisticado, revelando apenas o suficiente para perturbar os sentidos. Esta criação adapta-se a todas as formas do corpo 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.

guid

string

https://dev.divasboudoir.com/pt/vestidos-sensuais-preto/cdbu4936.htm

highlights

string

<ul> <li>Efeito pele de cobra para um look misterioso e cativante</li> <li>Sofisticado decote haltere que revela corajosamente os ombros</li> <li>Detalhes metálicos no decote para um efeito hipnotizante</li> <li>Corte justo ao corpo que abraça sensualmente todas as curvas</li> <li>Tecido elástico para um conforto ótimo e uma liberdade total</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Vestido 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

string

Vestido efeito cobra Vyper Tamanho grande com decote haltere | Diva's Boudoir

seotitle

string

Vestido sexy com decote haltere e efeito cobra preto de tamanho grande

seouri

string

vestidos-sensuais-preto

specifications

string

<ul> <li>Material: tecido elástico com efeito de cobra (92% poliéster, 8% elastano)</li> <li>Cor: preto profundo com reflexos metálicos</li> <li>Corte: justo com decote haltere</li> <li>Pormenores: Anéis metálicos no decote</li> <li>Comprimento: Mini, acima do joelho</li> </ul>

stylingtips

string

O vestido Vyper é perfeito com sapatos de verniz pretos para um look de arrasar, ou botins de salto alto para um estilo rock-chic irresistível. 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.

summary

string

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.

title

string

Sedução venenosa com efeito de serpente

usageinstructions

string

Para um conforto ótimo durante toda a noite, calce o vestido Vyper com cuidado para preservar o efeito de cobra e os detalhes metálicos. O decote halter ajusta-se confortavelmente ao pescoço para um ajuste seguro. O tecido elástico abraça naturalmente a sua forma, 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.

fetishboudoir

Struct

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

string

sz2406242523627232

netweight

string

nextshipment

string

tomorrow

ordered

number

orderidx

number

origin

string

originalsize

string

packaging

number

productshipment

string

auto

productuid

string

88B10665-B344-4EA7-B256938AF5AC37BA

promountil

string

rating

string

none

recorduid

string

88B10665-B344-4EA7-B256938AF5AC37BA

reference

string

CDBU4936

string

reserved

number

returned

number

returnsallowed

number

section

string

cabaret

shipment

string

5to7days

showbrand

number

sizeinfos

Query Template: /system/api/product/sizes.cfc:20 Execution Time: 1.39 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
	recorduid	size	sizetype	color	param1	param2	available	groupavailable	stock	gender	sizerange	sizegroup	suppliersize	intlsize	inches	eusize	ussize	uksize	frsize	essize	desize	itsize	ptsize	elsize	bust	waist	hip	underbust	cup	thigh	legheight	bodyheight	bodyweight
1	2355	4X	intlsize	black	4X	4X	-1	999999	0	w	plus	dress	4XL	4X		50-52	20-22	24-26	52-54	52-54	50-52	56-58	52-54	50-52	128-134	107-112	133-140
2	2351	XL	intlsize	black	XL	XL	-1	999999	0	w	plus	dress	0XL	XL		40-42	10-12	14-16	42-44	42-44	40-42	46-48	42-44	40-42	100-107	79-86	105-112
3	2352	1X	intlsize	black	1X	1X	-1	999999	0	w	plus	dress	1XL	1X		44-46	14-16	18-20	46-48	46-48	44-46	50-52	46-48	44-46	107-114	86-93	112-119
4	2353	2XL	intlsize	black	2XL	2XL	-1	999999	0	w	plus	dress	2XL	2XL		46-48	16-18	20-22	48-50	48-50	46-48	52-54	48-50	46-48	114-121	93-100	119-126
5	2354	3X	intlsize	black	3X	3X	-1	999999	0	w	plus	dress	3XL	3X		48-50	18-20	22-24	50-52	50-52	48-50	54-56	50-52	48-50	121-128	100-107	126-133

sizeranges

string

plus

sizes

string

2351,2352,2353,2354,2355

sizetype

string

auto

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

number

stocks

Query Template: /system/api/product/stocks.cfc:25 Execution Time: 22.2 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
	productuid	variationuid	recorduid	color	hexvalue	suppliersize	intlsize	inches	eusize	ussize	uksize	frsize	essize	desize	itsize	ptsize	elsize	gender	sizegroup	cup	size	sizetype	itemprice	itempromo	promoUntil	stockuid	warehouse	ontour	packaging	supplier	reserved	ordered	returned	defect	manufacturerreference	ean	available	stock	display	comments
1	88B10665-B344-4EA7-B256938AF5AC37BA	C07B52E9-1362-42ED-BCF6DA8B2182CF5A	2355	black	#000000	4XL	4X		50-52	20-22	24-26	52-54	52-54	50-52	56-58	52-54	50-52	w	dress		4X	intlsize	33.2917	24.9583	{ts '2025-11-03 00:00:00'}	STOCK01	0	0	0	-1	0	4	0	0	S3419-1	2HMRYV50396380857	-1	0	all
2	88B10665-B344-4EA7-B256938AF5AC37BA	E946346F-78CC-4F86-B4DCD916ED101F20	2351	black	#000000	0XL	XL		40-42	10-12	14-16	42-44	42-44	40-42	46-48	42-44	40-42	w	dress		XL	intlsize	33.2917	24.9583	{ts '2025-11-03 00:00:00'}	STOCK01	0	0	0	-1	0	1	0	0	S3419-1	2GVXI3Z0396380832	-1	0	all
3	88B10665-B344-4EA7-B256938AF5AC37BA	734D5C1D-460C-410A-8396663288A14242	2352	black	#000000	1XL	1X		44-46	14-16	18-20	46-48	46-48	44-46	50-52	46-48	44-46	w	dress		1X	intlsize	33.2917	24.9583	{ts '2025-11-03 00:00:00'}	STOCK01	0	0	0	-1	0	2	0	0	S3419-1		-1	0	all
4	88B10665-B344-4EA7-B256938AF5AC37BA	2354C967-AC02-4E69-96F0039083A1E039	2353	black	#000000	2XL	2XL		46-48	16-18	20-22	48-50	48-50	46-48	52-54	48-50	46-48	w	dress		2XL	intlsize	33.2917	24.9583	{ts '2025-11-03 00:00:00'}	STOCK01	0	0	0	-1	0	3	0	0	S3419-1	2GOYL560396380842	-1	0	all
5	88B10665-B344-4EA7-B256938AF5AC37BA	FD386466-FCFA-4F42-B8C9F2E2B6ADED1B	2354	black	#000000	3XL	3X		48-50	18-20	22-24	50-52	50-52	48-50	54-56	50-52	48-50	w	dress		3X	intlsize	33.2917	24.9583	{ts '2025-11-03 00:00:00'}	STOCK01	0	0	0	-1	0	2	0	0	S3419-1	2HMRYV50396380852	-1	0	all

subcategory

string

all

supplier

number

-1

supplierreference

string

SZ2406242523627232

tags

string

themes

string

totalvariations

number

type

string

default

unitprice

number

33.2917

usageinstructions

string

variations

Query Template: /system/api/product/variations.cfc:171 Execution Time: 9.01 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
	variationuid	recorduid	color	hexvalue	suppliersize	intlsize	inches	eusize	ussize	uksize	frsize	essize	desize	itsize	ptsize	elsize	gender	sizegroup	cup	size	sizetype	itemprice	itempromo	promoUntil	stockuid	warehouse	ontour	packaging	supplier	reserved	ordered	returned	defect	manufacturerreference	ean	available	stock	availablepersize	stockpersize	availablepercolor	stockpercolor	haspromo	unitprice	display	comments
1	C07B52E9-1362-42ED-BCF6DA8B2182CF5A	2355	black	#000000	4XL	4X		50-52	20-22	24-26	52-54	52-54	50-52	56-58	52-54	50-52	w	dress		4X	intlsize	33.2917	24.9583	{ts '2025-11-03 00:00:00'}	STOCK01	0	0	0	-1	0	4	0	0	S3419-1	2HMRYV50396380857	-1	0	-1	0	-1	0	0	33.2917	all
2	E946346F-78CC-4F86-B4DCD916ED101F20	2351	black	#000000	0XL	XL		40-42	10-12	14-16	42-44	42-44	40-42	46-48	42-44	40-42	w	dress		XL	intlsize	33.2917	24.9583	{ts '2025-11-03 00:00:00'}	STOCK01	0	0	0	-1	0	1	0	0	S3419-1	2GVXI3Z0396380832	-1	0	-1	0	-1	0	0	33.2917	all
3	734D5C1D-460C-410A-8396663288A14242	2352	black	#000000	1XL	1X		44-46	14-16	18-20	46-48	46-48	44-46	50-52	46-48	44-46	w	dress		1X	intlsize	33.2917	24.9583	{ts '2025-11-03 00:00:00'}	STOCK01	0	0	0	-1	0	2	0	0	S3419-1		-1	0	-1	0	-1	0	0	33.2917	all
4	2354C967-AC02-4E69-96F0039083A1E039	2353	black	#000000	2XL	2XL		46-48	16-18	20-22	48-50	48-50	46-48	52-54	48-50	46-48	w	dress		2XL	intlsize	33.2917	24.9583	{ts '2025-11-03 00:00:00'}	STOCK01	0	0	0	-1	0	3	0	0	S3419-1	2GOYL560396380842	-1	0	-1	0	-1	0	0	33.2917	all
5	FD386466-FCFA-4F42-B8C9F2E2B6ADED1B	2354	black	#000000	3XL	3X		48-50	18-20	22-24	50-52	50-52	48-50	54-56	50-52	48-50	w	dress		3X	intlsize	33.2917	24.9583	{ts '2025-11-03 00:00:00'}	STOCK01	0	0	0	-1	0	2	0	0	S3419-1	2HMRYV50396380852	-1	0	-1	0	-1	0	0	33.2917	all

vatrate

number

warehouse

number

Κύρια σημεία

Σέξι μεγάλο μέγεθος μαύρο φόρεμα με λαιμόκοψη από φίδι

Περιγραφή του προϊόντος

Τεχνικές λεπτομέρειες

Διαθέσιμα μεγέθη

Διαθέσιμο χρώμα

Οδηγός διαστασιολόγησης

Οδηγίες φροντίδας

Συμβουλές χρήσης

Συμβουλές στυλ

ΠΛΗΡΟΦΟΡΊΕΣ

ΠΕΡΙΟΧΉ ΜΕΛΏΝ

ΥΠΗΡΕΣΊΕΣ

ΕΠΙΚΟΙΝΩΝΉΣΤΕ ΜΑΖΊ ΜΑΣ

Κύρια σημεία

Σέξι μεγάλο μέγεθος μαύρο φόρεμα με λαιμόκοψη από φίδι

Περιγραφή του προϊόντος

Τεχνικές λεπτομέρειες

Διαθέσιμα μεγέθη

Διαθέσιμο χρώμα

Οδηγός διαστασιολόγησης

Οδηγίες φροντίδας

Συμβουλές χρήσης

Συμβουλές στυλ

Newsletter

Να αλλάξω τις ρυθμίσεις μου

Αποθήκευση των προτιμήσεών μου