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

Ασύμμετρο μαύρο φόρεμα με σκίσιμο - Κοκτέιλ κομψότητα και αισθησιασμός

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

SKU: CDBU1722

Ασύμμετρο μαύρο φόρεμα με σκίσιμο - Κοκτέιλ κομψότητα και αισθησιασμός

Απόθεμα:

Αυτό το μαύρο φόρεμα αναδεικνύει την κομψότητά σας με το εφαρμοστό κόψιμο και το πλαϊνό σκίσιμο.

Η διακοσμημένη με δαντέλα λαιμόκοψη και το ασύμμετρο τελείωμα δημιουργούν μια εκλεπτυσμένη κοκτέιλ εμφάνιση.

Οι ρυθμιζόμενες τιράντες και ο αχλαδινός λαιμός προσθέτουν μια αισθησιακή πινελιά που αναδεικνύει τη σιλουέτα σας.

Κύρια σημεία

Κολακευτική, μοντέρνα εφαρμογή
Το πλαϊνό σκίσιμο αποκαλύπτει το πόδι με στυλ
Ντεκολτέ με δαντέλα για εκλεπτυσμένη θηλυκότητα
Ασύμμετρο στρίφωμα με εκλεπτυσμένο φινίρισμα voile
Λεπτές ρυθμιζόμενες τιράντες για βέλτιστη στήριξη
Λαιμόκοψη με κομψές τιράντες σταυρωτές
Ευέλικτο μήκος midi για κοκτέιλ και βραδιές
Ιδανική εφαρμογή για όλα τα σχήματα σώματος

Μέγεθος:

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

Χρώμα:

Ποσότητα:

34.95 €

Γρήγορη ναυτιλία

για τους ανυπόμονους...

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

μέσω chat, facebook ή e-mail

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

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

Μαύρο φόρεμα με μεγάλο ασύμμετρο σκίσιμο - Cocktail Elegance

Name: Μαύρο φόρεμα με μεγάλο ασύμμετρο σκίσιμο - Cocktail Elegance - 1
Brand: Μπουντουάρ της Ντίβας
SKU: CDBU1722
Price: 34.95 EUR
Availability: LimitedAvailability

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

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

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

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

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

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

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

Στυλ : Μοντέρνο ασύμμετρο κοκτέιλ φόρεμα με σκίσιμο
Κομμένο : Κολακευτικό και εφαρμοστό κοντά στο σώμα
Λαιμόκοψη : Στολισμένο με εκλεπτυσμένη θηλυκή δαντέλα
Κοπή : Αποκαλύπτει το πόδι στο πλάι με στυλ
Hem : Ασύμμετρο με εκλεπτυσμένο φινίρισμα voile
Ιμάντες: Λεπτοί ρυθμιζόμενοι ιμάντες για βέλτιστη στήριξη
Πλάτη: Γυμνή με κομψές τιράντες σταυρωτές
Μήκος: Ευέλικτο μίντι κοκτέιλ βραδινό

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

Διαθέσιμο από 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

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

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

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

Φορέστε αυτό το φόρεμα, προσαρμόζοντας τις τιράντες στο σχήμα του σώματός σας για τέλεια στήριξη.

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

Αυτό το φόρεμα αποκαλύπτει τη φινέτσα σας με έναν σύγχρονο αισθησιασμό που μετατρέπει κάθε σας εμφάνιση σε μια αξέχαστη στιγμή.

To Top

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

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

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

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

Συνέχεια

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

Χώρα Γλώσσα

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

Ακυρώστε το

Struct
Entries: 108

actions

Array

available

number

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

1003

isprivate

string

rating

string

all

src

string

/photobank/products/dvqc/cdbu1722/robe-sexy-grande-taille.jpg

type

string

img

width

string

694

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

1012

isprivate

string

rating

string

all

src

string

/photobank/products/dvqc/cdbu1722/robe-sexy-grande-taille1.jpg

type

string

img

width

string

700

variations

Struct

colors

Struct

black

Struct

height

string

1012

isprivate

string

rating

string

all

src

string

/photobank/products/dvqc/cdbu1722/robe-sexy-grande-taille1.jpg

type

string

img

width

string

700

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

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 kaltem Wasser, um das Gewebe zu schonen</li> <li>Verwenden Sie ein mildes Waschmittel ohne Bleichmittel</li> <li>Trocknen Sie das Kleidungsstück liegend und vor direktem Licht geschützt</li> <li>vermeiden Sie Schleudern, um die Form zu erhalten</li> <li>Bei niedriger Temperatur bügeln, wenn nötig</li> <li>Auf Bügel hängen, um Falten zu vermeiden</li> </ul>

description

string

Dieses schwarze Kleid verkörpert moderne Eleganz mit seinem körpernahen Schnitt, der die üppigen Kurven betont. Der Seitenschlitz enthüllt Ihr Bein auf subtile Weise und sorgt für den raffinierten Look, der ein gelungenes Cocktail-Outfit auszeichnet. Das mit Spitze verzierte Dekolleté verleiht diesem Kleid den femininen Touch, der es von herkömmlichen Modellen unterscheidet. Diese Verarbeitung offenbart Ihre Vorliebe für raffinierte Details und bewahrt gleichzeitig diese zeitlose Eleganz. Der asymmetrische Saum mit Voile-Finish schafft diese moderne Dimension, die Ihre Silhouette verwandelt. Das durchdachte Design sorgt für eine anmutige Bewegung, die Ihre Persönlichkeit mit dieser zeitgemäßen Raffinesse zum Ausdruck bringt. Die schmalen, verstellbaren Träger sorgen für einen optimalen Halt, der sich perfekt an Ihre Formen anpasst. Der Neckholder mit gekreuzten Trägern enthüllt Ihren Rücken mit dieser selbstbewussten Sinnlichkeit, die Ihren persönlichen Stil kennzeichnet. Die Midi-Länge bietet diese perfekte Vielseitigkeit zwischen schickem Cocktail und glamourösem Abend. Die dehnbaren Stoffe passen sich harmonisch an jede Körperform an und garantieren diesen Komfort, der Sie während Ihrer privilegierten Veranstaltungen begleitet.

guid

string

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

highlights

string

<ul> <li>Schmeichelnder, moderner, körpernaher Schnitt</li> <li>Seitenschlitz enthüllt stilvoll das Bein</li> <li>Mit Spitze verziertes Dekolleté für raffinierte Weiblichkeit</li> <li>Asymmetrischer Saum mit raffiniertem Voile-Finish</li> <li>Schmale, verstellbare Träger für optimalen Halt</li> <li>Neckholder mit eleganten, überkreuzten Trägern</li> <li>Vielseitige Midi-Länge Cocktail und Abendveranstaltung</li> <li>Perfekte Passform passt sich jeder Körperform an</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Schwarzes Kleid in Übergröße mit asymmetrischem Schlitz, Spitzenausschnitt, Neckholder, gekreuzten Trägern und Schleiersaum. Schmeichelnde Passform Eleganter Cocktail. Diva's Boudoir.

keywords

string

title

string

Schwarzes Kleid Große Größe Asymmetrischer Schlitz | Elegante Cocktailkleider | Diva's Boudoir

seotitle

string

Schwarzes Kleid Grosse Grösse Asymmetrischer Schlitz - Eleganz Cocktail

seouri

string

sexy-kleider-schwarz

specifications

string

<ul> <li>Stil: Modernes Cocktailkleid mit asymmetrischem Schlitz</li> <li>Schnitt: Schmeichelnder, eng anliegender Körpernaher Schnitt</li> <li>Ausschnitt: Mit Spitze verziert Raffinierte Weiblichkeit</li> <li>Schlitz : Seitlich enthüllt Bein mit Stil</li> <li>Saum: Asymmetrischer Saum mit raffiniertem Voile-Finish</li> <li>Träger: Dünne, verstellbare Träger mit optimalem Halt</li> <li>Rücken: Nackt mit eleganten Kreuzträgern</li> <li>Länge: Midi Vielseitig Cocktail Abend</li> </ul>

stylingtips

string

summary

string

Dieses schwarze Kleid enthüllt Ihre Eleganz mit seinem körpernahen Schnitt und dem Seitenschlitz. Das mit Spitze verzierte Dekolleté und der asymmetrische Saum sorgen für einen raffinierten Cocktail-Look. Die verstellbaren Träger und der Neckholder sorgen für den sinnlichen Touch, der Ihre Silhouette betont.

title

string

Schwarzes Kleid Asymmetrischer Schlitz - Cocktail-Eleganz und Sinnlichkeit

usageinstructions

string

Ziehen Sie dieses Kleid an und stellen Sie die Träger entsprechend Ihrer Körperform ein, um einen perfekten Sitz zu gewährleisten. Der körpernahe Schnitt passt sich auf natürliche Weise Ihren Formen an und schafft so diese elegante Silhouette. Dieses Kleid enthüllt Ihre Raffinesse mit dieser modernen Sinnlichkeit, die jeden Auftritt zu einem unvergesslichen Moment macht.

Struct
Entries: 15

abstract

string

careinstructions

string

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

description

string

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

guid

string

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

highlights

string

<ul> <li>Κολακευτική, μοντέρνα εφαρμογή</li> <li>Το πλαϊνό σκίσιμο αποκαλύπτει το πόδι με στυλ</li> <li>Ντεκολτέ με δαντέλα για εκλεπτυσμένη θηλυκότητα</li> <li>Ασύμμετρο στρίφωμα με εκλεπτυσμένο φινίρισμα voile</li> <li>Λεπτές ρυθμιζόμενες τιράντες για βέλτιστη στήριξη</li> <li>Λαιμόκοψη με κομψές τιράντες σταυρωτές</li> <li>Ευέλικτο μήκος midi για κοκτέιλ και βραδιές</li> <li>Ιδανική εφαρμογή για όλα τα σχήματα σώματος</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Μαύρο φόρεμα μεγάλου μεγέθους με ασύμμετρο σκίσιμο, δαντελένιο ντεκολτέ, λαιμόκοψη, διασταυρωμένες τιράντες και στρίφωμα από voile. Κολακευτική εφαρμογή για ένα κομψό κοκτέιλ. Μπουντουάρ της Ντίβας.

keywords

string

title

string

Μαύρο φόρεμα Μεγάλο μέγεθος Ασύμμετρη σχισμή | Κομψό κοκτέιλ | Diva's Boudoir

seotitle

string

Μαύρο φόρεμα με μεγάλο ασύμμετρο σκίσιμο - Cocktail Elegance

seouri

string

sexi-foremata-mayro

specifications

string

<ul> <li>Στυλ : Μοντέρνο ασύμμετρο κοκτέιλ φόρεμα με σκίσιμο</li> <li>Κομμένο : Κολακευτικό και εφαρμοστό κοντά στο σώμα</li> <li>Λαιμόκοψη : Στολισμένο με εκλεπτυσμένη θηλυκή δαντέλα</li> <li>Κοπή : Αποκαλύπτει το πόδι στο πλάι με στυλ</li> <li>Hem : Ασύμμετρο με εκλεπτυσμένο φινίρισμα voile</li> <li>Ιμάντες: Λεπτοί ρυθμιζόμενοι ιμάντες για βέλτιστη στήριξη</li> <li>Πλάτη: Γυμνή με κομψές τιράντες σταυρωτές</li> <li>Μήκος: Ευέλικτο μίντι κοκτέιλ βραδινό</li> </ul>

stylingtips

string

summary

string

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

title

string

Ασύμμετρο μαύρο φόρεμα με σκίσιμο - Κοκτέιλ κομψότητα και αισθησιασμός

usageinstructions

string

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

Struct
Entries: 15

abstract

string

careinstructions

string

<ul> <li>Hand wash in cold water to preserve fabrics</li> <li>Use a mild detergent without bleaching agents</li> <li>Dry flat away from direct light</li> <li>avoid spin-drying to maintain shape</li> <li>Iron at low temperature if necessary</li> <li>Hang on a hanger to avoid wrinkles</li> </ul>

description

string

This black dress is the epitome of modern elegance, with a close-fitting cut that enhances generous curves. The side slit subtly reveals your leg, creating the sophisticated allure that characterizes successful cocktail outfits. The lace embellished neckline adds that touch of femininity that sets this dress apart from conventional models. This finish reveals your taste for refined details while retaining that timeless elegance. The asymmetrical hem with its voile finish creates that modern dimension that transforms your silhouette. This studied design brings that graceful movement that reveals your personality with contemporary sophistication. The slim, adjustable straps ensure optimum support that perfectly hugs your shape. The halterneck with crossed straps reveals your back with the sensuality that characterizes your personal style. This midi length offers the perfect versatility between cocktail chic and evening glamour. Stretch fabrics harmoniously embrace all body shapes, guaranteeing the comfort that accompanies you throughout your special events.

guid

string

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

highlights

string

<ul> <li>Flattering, modern fit</li> <li>Side slit reveals leg in style</li> <li>Décolleté adorned with lace for refined femininity</li> <li>Asymmetrical hem with sophisticated voile finish</li> <li>Slim, adjustable straps for optimum support</li> <li>Bare back with elegant criss-cross straps</li> <li>Versatile midi length for cocktails and evenings</li> <li>Perfect fit for all body types</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Plus-size black dress with asymmetrical slit, lace décolleté, bare back, crossed straps, voile hem. Flattering cocktail cut. Diva's Boudoir.

keywords

string

title

string

Black Dress Plus Size Asymmetric Slit | Elegant Cocktail | Diva's Boudoir

seotitle

string

Plus Size Asymmetric Slit Black Dress - Cocktail Elegance

seouri

string

sexy-dresses-black

specifications

string

<ul> <li>Style: Modern asymmetrical cocktail dress</li> <li>Cut: Flattering and fitted close to the body</li> <li>Décolleté: Embellished with refined feminine lace</li> <li>Slit : Side slit reveals leg with style</li> <li>Hem: Asymmetrical, sophisticated voile finish</li> <li>Straps: Thin adjustable straps for optimum support</li> <li>Back: Nude with elegant crossed straps</li> <li>Length: Versatile midi cocktail evening</li> </ul>

stylingtips

string

summary

string

This black dress reveals your elegance with its close-fitting cut and side slit. The lace embellished neckline and asymmetrical hemline create a sophisticated cocktail look. Adjustable straps and a bare back add a sensual touch that enhances your silhouette.

title

string

Black dress with asymmetrical slit - Cocktail elegance and sensuality

usageinstructions

string

Slip on this dress, adjusting the straps to your body shape for perfect support. The body-hugging cut naturally adapts to your shape to create this elegant silhouette. This dress reveals your sophistication with the modern sensuality that turns every appearance into a memorable moment.

Struct
Entries: 15

abstract

string

careinstructions

string

<ul> <li>Lavar a mano en agua fría para preservar los tejidos</li> <li>Utilizar un detergente suave sin blanqueantes</li> <li>Secar en plano y lejos de la luz directa</li> <li>evite el centrifugado para mantener la forma</li> <li>Planchar a baja temperatura si es necesario</li> <li>Colgar en una percha para evitar arrugas</li> </ul>

description

string

Este vestido negro es el epítome de la elegancia moderna, con un corte ceñido que realza las curvas generosas. La abertura lateral revela sutilmente la pierna, creando el look sofisticado que caracteriza a los conjuntos de cóctel de éxito. El escote adornado con encaje añade ese toque de feminidad que diferencia a este vestido de los estilos convencionales. Este acabado revela tu gusto por los detalles refinados, conservando al mismo tiempo esa elegancia atemporal. El dobladillo asimétrico con acabado de gasa crea esa dimensión moderna que transforma su silueta. Este estudiado diseño proporciona ese movimiento grácil que revela su personalidad con sofisticación contemporánea. Los tirantes finos y ajustables proporcionan una sujeción óptima que se adapta perfectamente a su silueta. El escote halterneck con tirantes entrecruzados revela tu espalda con la sensualidad que caracteriza tu estilo personal. Este largo midi ofrece la versatilidad perfecta entre un cóctel chic y una salida nocturna glamurosa. Los tejidos elásticos se adaptan armoniosamente a todas las formas del cuerpo, garantizando la comodidad durante todos sus eventos especiales.

guid

string

https://dev.divasboudoir.com/es/vestido-sexy-negro/cdbu1722.htm

highlights

string

<ul> <li>Corte moderno y favorecedor</li> <li>Abertura lateral que deja ver la pierna con estilo</li> <li>Escote adornado con encaje para una feminidad refinada</li> <li>Dobladillo asimétrico con sofisticado acabado de gasa</li> <li>Tirantes finos ajustables para una sujeción óptima</li> <li>Cuello halterneck con elegantes tirantes entrecruzados</li> <li>Largo midi versátil para cócteles y noches</li> <li>Ajuste perfecto para todas las formas</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Vestido negro de talla grande con abertura asimétrica, escote de encaje, cuello halterneck, tirantes cruzados y bajo de gasa. Corte favorecedor para un cóctel elegante. Diva's Boudoir.

keywords

string

title

string

Vestido negro talla grande asimétrico | Cocktail elegante | Diva's Boudoir

seotitle

string

Vestido negro talla grande asimétrico - Cocktail Elegance

seouri

string

vestido-sexy-negro

specifications

string

<ul> <li>Estilo : Moderno vestido de cóctel con abertura asimétrica</li> <li>Corte : Favorecedor y ceñido al cuerpo</li> <li>Escote : Adornado con refinado encaje femenino</li> <li>Abertura : Pierna al descubierto con estilo</li> <li>Dobladillo: Asimétrico con sofisticado acabado de gasa</li> <li>Tirantes: Finos tirantes ajustables para una sujeción óptima</li> <li>Espalda: Nude con elegantes tirantes entrecruzados</li> <li>Largo: Midi de cóctel versátil</li> </ul>

stylingtips

string

summary

string

Este vestido negro muestra tu elegancia con su corte ceñido y abertura lateral. El escote adornado con encaje y el bajo asimétrico crean un sofisticado look de cóctel. Los tirantes ajustables y el escote halterneck añaden un toque sensual que realza tu figura.

title

string

Vestido negro con abertura asimétrica - Elegancia y sensualidad de cóctel

usageinstructions

string

Ponte este vestido ajustando los tirantes a la forma de tu cuerpo para una sujeción perfecta. El corte ceñido al cuerpo se adapta de forma natural a tu figura para crear esta elegante silueta. Este vestido revela tu sofisticación con una sensualidad moderna que convierte cada aparición en un momento memorable.

Struct
Entries: 15

abstract

string

careinstructions

string

<ul> <li>Lavage à la main à l'eau froide pour préserver les tissus</li> <li>Utiliser une lessive douce sans agents blanchissants</li> <li>Séchage à plat à l'abri de la lumière directe</li> <li>Éviter l'essorage pour maintenir la forme</li> <li>Repasser à basse température si nécessaire</li> <li>Suspendre sur cintre pour éviter les plis</li> </ul>

description

string

Cette robe noire incarne l'élégance moderne avec sa coupe près du corps qui sublime courbes généreuses. La fente latérale révèle votre jambe avec subtilité, créant cette allure sophistiquée qui caractérise les tenues cocktail réussies. Le décolleté orné de dentelle apporte cette touche de féminité qui distingue cette robe des modèles conventionnels. Cette finition révèle votre goût pour les détails raffinés tout en conservant cette élégance intemporelle. L'ourlet asymétrique avec sa finition voile crée cette dimension moderne qui transforme votre silhouette. Cette conception étudiée apporte ce mouvement gracieux qui révèle votre personnalité avec cette sophistication contemporaine. Les bretelles fines ajustables assurent un maintien optimal qui épouse parfaitement vos formes. Le dos nu avec bretelles croisées révèle votre dos avec cette sensualité assumée qui caractérise votre style personnel. Cette longueur midi offre cette polyvalence parfaite entre cocktail chic et soirée glamour. Les tissus extensibles épousent harmonieusement toutes les morphologies, garantissant ce confort qui vous accompagne tout au long de vos événements privilégiés.

guid

string

https://dev.divasboudoir.com/fr/robe-noire-grande-taille-fente-asymetrique-elegance-cocktail/cdbu1722.htm

highlights

string

<ul> <li>Coupe près du corps flatteuse et moderne</li> <li>Fente latérale révélant la jambe avec style</li> <li>Décolleté orné de dentelle pour une féminité raffinée</li> <li>Ourlet asymétrique avec finition voile sophistiquée</li> <li>Bretelles fines ajustables pour un maintien optimal</li> <li>Dos nu avec bretelles croisées élégantes</li> <li>Longueur midi polyvalente cocktail et soirée</li> <li>S'adapte parfaitement épousant toutes les morphologies</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Robe noire grande taille fente asymétrique, décolleté dentelle, dos nu bretelles croisées, ourlet voile. Coupe flatteuse cocktail élégant. Diva's Boudoir.

keywords

string

title

string

Robe noire Grande Taille Fente Asymétrique | Cocktail Élégant | Diva's Boudoir

seotitle

string

Robe noire Grande Taille Fente Asymétrique - Élégance Cocktail

seouri

string

robe-noire-grande-taille-fente-asymetrique-elegance-cocktail

specifications

string

<ul> <li>Style : Robe cocktail fente asymétrique moderne</li> <li>Coupe : Près du corps flatteuse et ajustée</li> <li>Décolleté : Orné dentelle féminité raffinée</li> <li>Fente : Latérale révélant jambe avec style</li> <li>Ourlet : Asymétrique finition voile sophistiquée</li> <li>Bretelles : Fines ajustables maintien optimal</li> <li>Dos : Nu avec bretelles croisées élégantes</li> <li>Longueur : Midi polyvalente cocktail soirée</li> </ul>

stylingtips

string

summary

string

Cette robe noire révèle votre élégance avec sa coupe près du corps et sa fente latérale. Le décolleté orné de dentelle et l'ourlet asymétrique créent un look cocktail sophistiqué. Les bretelles ajustables et le dos nu apportent cette touche sensuelle qui sublime votre silhouette.

title

string

Robe noire Fente Asymétrique - Élégance Cocktail et Sensualité

usageinstructions

string

Enfilez cette robe en ajustant les bretelles selon votre morphologie pour un maintien parfait. La coupe près du corps s'adapte naturellement à vos formes pour créer cette silhouette élégante. Cette robe révèle votre sophistication avec cette sensualité moderne qui transforme chaque apparition en moment mémorable.

Struct
Entries: 15

abstract

string

careinstructions

string

<ul> <li>Lavare a mano in acqua fredda per preservare i tessuti</li> <li>Utilizzare un detersivo delicato senza agenti sbiancanti</li> <li>Asciugare in piano lontano dalla luce diretta</li> <li>evitare la centrifuga per mantenere la forma</li> <li>Stirare a bassa temperatura se necessario</li> <li>Appendere su una gruccia per evitare le pieghe</li> </ul>

description

string

Questo abito nero è l'epitome dell'eleganza moderna, con un taglio aderente che esalta le curve generose. Lo spacco laterale scopre sottilmente la gamba, creando quel look sofisticato che caratterizza gli outfit da cocktail di successo. La scollatura impreziosita dal pizzo aggiunge quel tocco di femminilità che distingue questo abito dai modelli convenzionali. Questa finitura rivela il vostro gusto per i dettagli raffinati, pur mantenendo un'eleganza senza tempo. L'orlo asimmetrico con finitura in voile crea una dimensione moderna che trasforma la silhouette. Questo design studiato offre quel movimento aggraziato che rivela la vostra personalità con raffinatezza contemporanea. Le spalline sottili e regolabili offrono un sostegno ottimale che abbraccia perfettamente le vostre forme. Il collo alto con spalline incrociate rivela la schiena con la sensualità che caratterizza il vostro stile personale. La lunghezza midi offre la perfetta versatilità tra un cocktail party chic e una serata glamour. I tessuti elasticizzati si adattano armoniosamente a ogni corporatura, garantendo il comfort durante i vostri eventi speciali.

guid

string

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

highlights

string

<ul> <li>Vestibilità moderna e lusinghiera</li> <li>Lo spacco laterale scopre la gamba con stile</li> <li>Scollatura impreziosita da pizzo per una femminilità raffinata</li> <li>Orlo asimmetrico con sofisticata finitura in voile</li> <li>Spalline sottili regolabili per un sostegno ottimale</li> <li>Scollo a mezzaluna con eleganti spalline incrociate</li> <li>Versatile lunghezza midi per aperitivi e serate</li> <li>Vestibilità perfetta per tutte le forme del corpo</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Abito nero di taglia grande con spacco asimmetrico, scollatura in pizzo, collo alto, spalline incrociate e orlo in voile. Vestibilità comoda per un cocktail elegante. Boudoir della Diva.

keywords

string

title

string

Abito nero Taglia grande Spacco asimmetrico | Cocktail elegante | Diva's Boudoir

seotitle

string

Abito nero Grande spacco asimmetrico - Cocktail Elegance

seouri

string

abiti-sexy-nero

specifications

string

<ul> <li>Stile : moderno abito da cocktail con spacco asimmetrico</li> <li>Taglio: Lusinghiero e aderente al corpo</li> <li>Scollatura : Impreziosita da un raffinato pizzo femminile</li> <li>Spacco: Gamba scoperta lateralmente con stile</li> <li>Orlo: asimmetrico con sofisticata finitura in voile</li> <li>Spalline: spalline sottili regolabili per un sostegno ottimale</li> <li>Schiena: nuda con eleganti spalline incrociate</li> <li>Lunghezza: Versatile cocktail midi da sera</li> </ul>

stylingtips

string

summary

string

Questo abito nero mette in mostra la vostra eleganza grazie al taglio aderente e allo spacco laterale. La scollatura impreziosita da pizzo e l'orlo asimmetrico creano un sofisticato look da cocktail. Le spalline regolabili e il collo alto aggiungono un tocco sensuale che esalta la vostra figura.

title

string

Abito nero con spacco asimmetrico - Eleganza e sensualità da cocktail

usageinstructions

string

Indossate questo abito, regolando le spalline in base alla forma del corpo per un sostegno perfetto. Il taglio aderente al corpo si adatta naturalmente alle vostre forme per creare una silhouette elegante. Questo abito rivela la vostra raffinatezza con una sensualità moderna che trasforma ogni apparizione in un momento memorabile.

Struct
Entries: 15

abstract

string

careinstructions

string

<ul> <li>Handwas in koud water om de stoffen te sparen</li> <li>Gebruik een mild wasmiddel zonder bleekmiddelen</li> <li>Plat drogen uit de buurt van direct licht</li> <li>vermijd centrifugeren om de vorm te behouden</li> <li>Indien nodig op lage temperatuur strijken</li> <li>Op een kleerhanger hangen om kreuken te voorkomen</li> </ul>

description

string

Deze zwarte jurk is het toppunt van moderne elegantie, met een nauwsluitende snit die royale rondingen benadrukt. De split aan de zijkant onthult subtiel je been en creëert de geraffineerde look die kenmerkend is voor geslaagde cocktailoutfits. De met kant versierde halslijn voegt dat vleugje vrouwelijkheid toe dat deze jurk onderscheidt van conventionele stijlen. Deze afwerking onthult je smaak voor verfijnde details met behoud van die tijdloze elegantie. De asymmetrische zoom met voile afwerking creëert die moderne dimensie die je silhouet transformeert. Dit bestudeerde ontwerp zorgt voor die sierlijke beweging die je persoonlijkheid onthult met hedendaagse verfijning. De smalle, verstelbare bandjes bieden optimale ondersteuning die je vorm perfect omhelst. De halternek met kriskrasbandjes onthult je rug met de sensualiteit die jouw persoonlijke stijl kenmerkt. Deze midilengte biedt de perfecte veelzijdigheid tussen een chique cocktailparty en een glamoureuze avond uit. De stretchstoffen passen harmonieus bij alle lichaamsvormen en garanderen comfort tijdens al je speciale evenementen.

guid

string

https://dev.divasboudoir.com/nl/sexy-outfit-zwart/cdbu1722.htm

highlights

string

<ul> <li>Flatterende, moderne pasvorm</li> <li>Split aan de zijkant onthult het been in stijl</li> <li>Met kant versierde halslijn voor verfijnde vrouwelijkheid</li> <li>Asymmetrische zoom met geraffineerde voile afwerking</li> <li>Dunne verstelbare bandjes voor optimale ondersteuning</li> <li>Halternek met elegante kriskrasbandjes</li> <li>Veelzijdige midilengte voor cocktails en avonden</li> <li>Perfecte pasvorm voor alle lichaamsvormen</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Zwart jurkje van grote maat met asymmetrische split, kanten halslijn, halternek, gekruiste bandjes en voile zoom. Flatterende pasvorm voor een elegante cocktail. Diva's Boudoir.

keywords

string

title

string

Zwarte jurk grote maat met asymmetrische split | Elegante Cocktail | Diva's Boudoir

seotitle

string

Zwarte jurk grote maat met asymmetrische split - Cocktail Elegance

seouri

string

sexy-outfit-zwart

specifications

string

<ul> <li>Stijl : Moderne asymmetrische cocktailjurk met split</li> <li>Snit : Flatterend en nauwsluitend</li> <li>Halslijn : Versierd met verfijnd vrouwelijk kant</li> <li>Split : Stijlvolle beenopening aan de zijkant</li> <li>Zoom: Asymmetrisch met geraffineerde voile afwerking</li> <li>Bandjes: Fijne verstelbare bandjes voor optimale ondersteuning</li> <li>Rug: Nude met elegante kriskras bandjes</li> <li>Lengte: Veelzijdige midi cocktail avond</li> </ul>

stylingtips

string

summary

string

Deze zwarte jurk laat je elegantie zien met zijn nauwsluitende snit en split aan de zijkant. De met kant versierde halslijn en asymmetrische zoomlijn creëren een geraffineerde cocktaillook. De verstelbare bandjes en halternek geven je figuur een sensuele touch.

title

string

Zwarte jurk met asymmetrische split - elegante en sensuele cocktailjurk

usageinstructions

string

Trek deze jurk aan en pas de bandjes aan je lichaamsvorm aan voor perfecte ondersteuning. De nauwsluitende snit past zich op natuurlijke wijze aan je vorm aan om dit elegante silhouet te creëren. Deze jurk onthult je verfijning met een moderne sensualiteit die van elke verschijning een gedenkwaardig moment maakt.

Struct
Entries: 15

abstract

string

careinstructions

string

<ul> <li>Lavar à mão em água fria para preservar os tecidos</li> <li>Utilizar um detergente suave sem agentes branqueadores</li> <li>Secar em local plano e afastado da luz direta</li> <li>evitar a secagem por centrifugação para manter a forma</li> <li>Se necessário, passar a ferro a baixa temperatura</li> <li>Pendurar num cabide para evitar vincos</li> </ul>

description

string

Este vestido preto é o epítome da elegância moderna, com um corte justo que realça as curvas generosas. A fenda lateral revela subtilmente a sua perna, criando o visual sofisticado que caracteriza os conjuntos de cocktail de sucesso. O decote com renda embelezada acrescenta aquele toque de feminilidade que distingue este vestido dos estilos convencionais. Este acabamento revela o seu gosto por detalhes refinados, mantendo uma elegância intemporal. A bainha assimétrica com acabamento em voile cria essa dimensão moderna que transforma a sua silhueta. Este design estudado proporciona aquele movimento gracioso que revela a sua personalidade com sofisticação contemporânea. As alças finas e ajustáveis proporcionam um apoio ótimo que abraça perfeitamente a sua forma. O decote haltere com alças cruzadas revela as suas costas com a sensualidade que caracteriza o seu estilo pessoal. Este comprimento midi oferece a versatilidade perfeita entre um cocktail chique e uma saída à noite glamorosa. Os tecidos elásticos adaptam-se harmoniosamente a todas as formas do corpo, garantindo conforto durante os seus eventos especiais.

guid

string

https://dev.divasboudoir.com/pt/vestido-sexy-preto/cdbu1722.htm

highlights

string

<ul> <li>Ajuste moderno e lisonjeiro</li> <li>A fenda lateral revela a perna com estilo</li> <li>Decote com renda embelezada para uma feminilidade refinada</li> <li>Bainha assimétrica com acabamento em voile sofisticado</li> <li>Alças finas e ajustáveis para um apoio ótimo</li> <li>Halterneck com elegantes alças cruzadas</li> <li>Comprimento midi versátil para cocktails e noites</li> <li>Ajuste perfeito para todas as formas do corpo</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Vestido preto de tamanho grande com fenda assimétrica, decote em renda, haltere, alças cruzadas e bainha em voile. Um vestido lisonjeiro para um cocktail elegante. Diva's Boudoir.

keywords

string

title

string

Vestido preto Tamanho grande Fenda assimétrica | Cocktail elegante | Diva's Boudoir

seotitle

string

Vestido preto com fenda assimétrica grande - Cocktail Elegance

seouri

string

vestido-sexy-preto

specifications

string

<ul> <li>Estilo : Vestido de cocktail moderno com fenda assimétrica</li> <li>Corte : Lisonjeador e justo junto ao corpo</li> <li>Decote : Enriquecido com renda feminina refinada</li> <li>Fenda : Perna lateral reveladora com estilo</li> <li>Bainha: Assimétrica com sofisticado acabamento em voile</li> <li>Alças: Alças finas e ajustáveis para um apoio ótimo</li> <li>Costas: Nude com elegantes alças cruzadas</li> <li>Comprimento: Versátil midi cocktail noite</li> </ul>

stylingtips

string

summary

string

Este vestido preto mostra a sua elegância com o seu corte justo e a sua fenda lateral. O decote com adornos de renda e a bainha assimétrica criam um sofisticado look de cocktail. As alças ajustáveis e o decote haltere dão um toque sensual que realça a sua figura.

title

string

Vestido preto com fenda assimétrica - Cocktail Elegância e Sensualidade

usageinstructions

string

Vista este vestido, ajustando as alças à forma do seu corpo para um apoio perfeito. O corte justo ao corpo adapta-se naturalmente à sua forma para criar esta silhueta elegante. Este vestido revela a sua sofisticação com uma sensualidade moderna que transforma cada aparição num momento memorável.

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

sz2412057319121359

netweight

string

nextshipment

string

tomorrow

ordered

number

orderidx

number

origin

string

originalsize

string

packaging

number

productshipment

string

auto

productuid

string

1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3

promountil

string

rating

string

none

recorduid

string

1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3

reference

string

CDBU1722

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,'2334,2335,2336,2337,2338') > 0 and product_variations.productuid = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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	2338	4X	intlsize	black	4X	4X	0	0	0	w	plus	dress	4XL	4X		50	20	24	52	52	50	56	52	50	128-134	107-112	133-140
2	2334	XL	intlsize	black	XL	XL	1	1	1	w	plus	dress	0XL	XL		42	12	16	44	44	42	48	44	42	100-107	79-86	105-112
3	2335	1X	intlsize	black	1X	1X	0	0	0	w	plus	dress	1XL	1X		44	14	18	46	46	44	50	46	44	107-114	86-93	112-119
4	2336	2XL	intlsize	black	2XL	2XL	0	0	0	w	plus	dress	2XL	2XL		46	16	20	48	48	46	52	48	46	114-121	93-100	119-126
5	2337	3X	intlsize	black	3X	3X	0	0	0	w	plus	dress	3XL	3X		48	18	22	50	50	48	54	50	48	121-128	100-107	126-133

sizeranges

string

plus

sizes

string

2334,2335,2336,2337,2338

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: 6.33 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' and product_variations.isactive = 1 and product_sizes.id_size = 2334 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' and product_variations.isactive = 1 and product_sizes.id_size = 2335 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' and product_variations.isactive = 1 and product_sizes.id_size = 2336 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' and product_variations.isactive = 1 and product_sizes.id_size = 2337 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' and product_variations.isactive = 1 and product_sizes.id_size = 2338 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	1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3	0B94B201-D16A-4099-9A73C8C71FBF8807	2338	black	#000000	4XL	4X		50	20	24	52	52	50	56	52	50	w	dress		4X	intlsize	29.125	0		STOCK01	0	0	0	0	0	1	0	0	20508916	2E255HN0648021432	0	0	all
2	1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3	F7B4CF44-CBFD-48E2-883D7F84D8A1996F	2334	black	#000000	0XL	XL		42	12	16	44	44	42	48	44	42	w	dress		XL	intlsize	29.125	0		STOCK01	1	0	0	0	0	0	0	0	20506916		1	1	all
3	1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3	3FB14C8F-E1F0-46C0-BE11A68BEBDCFDE1	2335	black	#000000	1XL	1X		44	14	18	46	46	44	50	46	44	w	dress		1X	intlsize	29.125	0		STOCK01	0	0	0	0	0	0	0	0	20506916		0	0	all
4	1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3	6377C138-F86C-4832-B76AFE5239445E6A	2336	black	#000000	2XL	2XL		46	16	20	48	48	46	52	48	46	w	dress		2XL	intlsize	29.125	0		STOCK01	0	0	0	0	0	1	0	0	20506916	2E255HN0648021442	0	0	all
5	1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3	B3CAD1D3-0606-4261-899A55CC01B4089E	2337	black	#000000	3XL	3X		48	18	22	50	50	48	54	50	48	w	dress		3X	intlsize	29.125	0		STOCK01	0	0	0	0	0	1	0	0	20506916		0	0	all

subcategory

string

all

supplier

number

supplierreference

string

SZ2412057319121359

tags

string

themes

string

totalvariations

number

type

string

default

unitprice

number

29.125

usageinstructions

string

variations

Query Template: /system/api/product/variations.cfc:171 Execution Time: 10.7 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' and product_variations.isactive = 1 and product_sizes.id_size = 2334 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' and product_variations.isactive = 1 and product_sizes.id_size = 2335 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' and product_variations.isactive = 1 and product_sizes.id_size = 2336 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' and product_variations.isactive = 1 and product_sizes.id_size = 2337 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' 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 = '1DDCEA9C-946A-48E2-9AA3CC02E3ED81A3' and product_variations.isactive = 1 and product_sizes.id_size = 2338 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	0B94B201-D16A-4099-9A73C8C71FBF8807	2338	black	#000000	4XL	4X		50	20	24	52	52	50	56	52	50	w	dress		4X	intlsize	29.125	0		STOCK01	0	0	0	0	0	1	0	0	20508916	2E255HN0648021432	0	0	0	0	1	1	0	29.125	all
2	F7B4CF44-CBFD-48E2-883D7F84D8A1996F	2334	black	#000000	0XL	XL		42	12	16	44	44	42	48	44	42	w	dress		XL	intlsize	29.125	0		STOCK01	1	0	0	0	0	0	0	0	20506916		1	1	1	1	1	1	0	29.125	all
3	3FB14C8F-E1F0-46C0-BE11A68BEBDCFDE1	2335	black	#000000	1XL	1X		44	14	18	46	46	44	50	46	44	w	dress		1X	intlsize	29.125	0		STOCK01	0	0	0	0	0	0	0	0	20506916		0	0	0	0	1	1	0	29.125	all
4	6377C138-F86C-4832-B76AFE5239445E6A	2336	black	#000000	2XL	2XL		46	16	20	48	48	46	52	48	46	w	dress		2XL	intlsize	29.125	0		STOCK01	0	0	0	0	0	1	0	0	20506916	2E255HN0648021442	0	0	0	0	1	1	0	29.125	all
5	B3CAD1D3-0606-4261-899A55CC01B4089E	2337	black	#000000	3XL	3X		48	18	22	50	50	48	54	50	48	w	dress		3X	intlsize	29.125	0		STOCK01	0	0	0	0	0	1	0	0	20506916		0	0	0	0	1	1	0	29.125	all

vatrate

number

warehouse

number

Κύρια σημεία

Μαύρο φόρεμα με μεγάλο ασύμμετρο σκίσιμο - Cocktail Elegance

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

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

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

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

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

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

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

ΠΛΗΡΟΦΟΡΊΕΣ

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

ΥΠΗΡΕΣΊΕΣ

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

Κύρια σημεία

Μαύρο φόρεμα με μεγάλο ασύμμετρο σκίσιμο - Cocktail Elegance

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

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

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

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

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

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

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

Newsletter

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

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