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

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

SKU: SBBO0072

Σώμα Evangeline

Νέα

Απόθεμα:

Υπέροχα χρώματα και φλοράλ δαντέλα για αυτό το όμορφο κορμάκι που διατίθεται σε όμορφα μεγάλα μεγέθη.

Κύρια σημεία

Αδιαφανές μπούστο από μικροΐνες που αναδεικνύει τέλεια όλα τα στήθη
Δίχρωμη φλοράλ δαντέλα στο μπούστο και στο κάτω μέρος του σώματος
Λεπτό μαύρο και μοβ κέντημα κοσμεί αισθησιακά τους γλουτούς
Άνοιγμα με πρέσα στον καβάλο για άτακτη πρόσβαση
Άψογη ποιότητα ειδικά σχεδιασμένη για τις καμπύλες σας

Μέγεθος:

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

Χρώμα:

Ποσότητα:

49.95 €

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

μέσω chat, facebook ή e-mail

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

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

Evangeline plus size κορμάκι

Name: Evangeline plus size κορμάκι - -1
Brand: Μπουντουάρ της Ντίβας
SKU: SBBO0072
Price: 49.95 EUR
Availability: InStock

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

Evangeline

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

Ειδικά σχεδιασμένο για τις καμπύλες μας, κοσμεί τους γλουτούς με λεπτεπίλεπτα κεντήματα σε μαύρο και μοβ χρώμα.

Άψογη ποιότητα, άνοιγμα με πιεστικά στο καβάλο.

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

Υλικό μπούστου: Υψηλής ποιότητας αδιαφανής μικροΐνα
Διακοσμητικό υλικό: Δίχρωμη δαντέλα με λουλούδια
Κέντημα: Λεπτά μοτίβα σε μαύρο και μοβ χρώμα στους γλουτούς
Μεγέθη: Διατίθεται στην πλήρη σειρά plus size
Κλείσιμο: Άνοιγμα με πρέσα στον καβάλο
Σχεδιασμός: Ειδικά προσαρμοσμένο στις γενναιόδωρες καμπύλες

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

Διαθέσιμο από XL+ έως 4XL

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

Μαύρο και μοβ

Σύνθεση

Πολυαμίδιο	45 %
Spandex	10 %
Πολυεστέρας	45 %

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

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

Διεθνές	Στήθος Μέγεθος Γοφοί
XL+	113-118 96-102 117-121
2XL+	125-130 109-114 127-132
3XL+	137-142 122-128 138-144
4XL+	149-154 135-140 151-156
L	103-106 86-90 109-112
XL	107-112 91-95 113-116
2XL	119-124 103-108 122-126
3XL	131-136 115-121 133-138
4XL	143-148 129-134 145-150

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

Πλένετε στο χέρι με χλιαρό νερό (30°C το πολύ)
Χρησιμοποιήστε ήπιο απορρυπαντικό για να διατηρήσετε τη δαντέλα των λουλουδιών
Χειριστείτε τα μαύρα και μωβ κεντήματα με προσοχή
Στεγνώνετε σε επίπεδη επιφάνεια, μακριά από το άμεσο φως
Μην σιδερώνετε απευθείας τα ευαίσθητα κεντήματα

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

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

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

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

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

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

To Top

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

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

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

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

Συνέχεια

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

Χώρα Γλώσσα

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

Ακυρώστε το

Struct
Entries: 108

actions

Array

available

number

-1

brand

string

cottelli

brandcode

string

cwhd

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

Cottelli

breasts

string

careinstructions

string

category

subcategory

linkuid

string

materials

string

mediadatas

Struct

alt

Struct

height

string

1590

isprivate

string

rating

string

all

src

string

/photobank/products/cwhd/sbbo0072/body_evangeline.jpg

type

string

img

width

string

1100

back

Struct

height

string

1631

isprivate

string

rating

string

all

src

string

/photobank/products/cwhd/sbbo0072/body_evangeline_dos_grande_taille_dos.jpg

type

string

img

width

string

1128

default

Struct

height

string

1843

isprivate

string

rating

string

all

src

string

/photobank/products/cwhd/sbbo0072/body_evangeline_dos_grande_taille_avant.jpg

type

string

img

width

string

1275

variations

Struct

colors

Struct

blackpurple

Struct

height

string

900

isprivate

string

rating

string

all

src

string

/photobank/products/cwhd/sbbo0072/body-sexy-grande-taille1.jpg

type

string

img

width

string

622

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-und-lila

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-kai-mov

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-and-purple

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-y-lila

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-et-mauve

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-e-malva

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-en-mauve

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-e-lilas

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

divasboudoir

Struct

Struct
Entries: 15

abstract

string

careinstructions

string

<ul> <li>Handwäsche in lauwarmem Wasser (maximal 30°C)</li> <li>Verwenden Sie ein mildes Waschmittel, um die Blumenspitze zu schonen</li> <li>Behutsame Handhabung der schwarzen und lilafarbenen Stickereien</li> <li>Flach trocknen, vor direktem Licht schützen</li> <li>Nicht direkt über die zarten Stickereien bügeln</li> </ul>

description

string

Evangeline Dieser Body besteht aus blickdichter Mikrofaser für das Mieder und aus wunderschöner zweifarbiger floraler Spitze für die Brust und den Unterkörper. Speziell für unsere Rundungen entworfen, schmückt er das Gesäß mit zarten schwarzen und lilafarbenen Stickereien. Einwandfreie Qualität, im Schritt mit Druckknöpfen zu öffnen.

guid

string

https://dev.divasboudoir.com/de/body-in-grossen-grossen-evangeline-schwarz-und-lila/sbbo0072.htm

highlights

string

<ul> <li>Blickdichte Miedermikrofaser, die jede Brust perfekt sublimiert</li> <li>Zweifarbige Blumenspitze auf der Brust und am Unterkörper</li> <li>Zarte schwarze und lilafarbene Stickereien, die sinnlich das Gesäß zieren</li> <li>Druckknopf-Öffnung im Schritt für einen verruchten Zugang</li> <li>Makellose Qualität speziell für Ihre Rundungen</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Wunderschöne Farben und florale Spitze für diesen hübschen Body, den es auch in schönen großen Größen gibt.

keywords

string

title

string

Body in großen Größen Evangeline

seotitle

string

Body in großen Größen Evangeline

seouri

string

body-in-grossen-grossen-evangeline-schwarz-und-lila

specifications

string

<ul> <li>Miedermaterial: Hochwertige, blickdichte Mikrofaser</li> <li>Dekoratives Material: Zweifarbige Blumenspitze</li> <li>Stickereien: Zarte schwarze und lilafarbene Motive auf dem Gesäß</li> <li>Größen: Erhältlich in der gesamten Palette für große Größen</li> <li>Verschluss: Im Schritt mit Druckknöpfen zu öffnen</li> <li>Design: Speziell für üppige Rundungen geeignet</li> </ul>

stylingtips

string

Der Evangeline-Body genügt sich selbst, um einen ultra-sinnlichen Look zu kreieren. Die zweifarbige Blumenspitze und die zarten Stickereien sorgen bereits für einen atemberaubenden visuellen Effekt, der Ihre heißeste Seite offenbart. Um den verruchten Effekt noch zu intensivieren, kombinieren Sie es mit Accessoires, die die Schwarz- und Lilatöne der Stickereien aufgreifen. Dieses speziell für Ihre Rundungen entworfene Stück passt perfekt zu sinnlichen und raffinierten Tönen. Für einen noch erotischeren Ansatz spielen Sie mit der Öffnung durch Druckknöpfe, um verschiedene Überraschungseffekte zu erzeugen. Vervollständigen Sie Ihren Look mit aufreizend <a href="https://www.divasboudoir.com/de/offener-body-in-grossen-grossen/">offenen Bodies</a>, die für Abwechslung sorgen, kombinieren Sie sie mit ultra-sinnlichen <a href="https://www.divasboudoir.com/de/neglige-in-grosse-grossen/">Negligés</a> oder betonen Sie Ihre Beine mit unseren raffinierten <a href="https://www.divasboudoir.com/de/strumpfe-in-grossen-grossen/">Strümpfen</a> und verruchten <a href="https://www.divasboudoir.com/de/offene-strumpfhose-grosse-grosse/">Strumpfhosen</a>.

summary

string

Wunderschöne Farben und florale Spitze für diesen hübschen Body, den es auch in schönen großen Größen gibt.

title

string

Body Evangeline

usageinstructions

string

Der Evangeline-Body wurde entworfen, um Ihre Sinnlichkeit auf raffinierte Weise zu enthüllen. Die Druckknopf-Öffnung im Schritt ist leicht zu handhaben und ermöglicht Ihnen einen frechen Zugang, ganz nach Ihren momentanen Wünschen. Die blickdichte Mikrofaser bietet optimalen Halt für die Brust und sorgt gleichzeitig für einen ultra-sexy Look. Die zarten Stickereien auf dem Gesäß sorgen für einen provokanten Effekt, der alle Blicke auf sich zieht. Perfekt für sinnliche intime Momente oder um sich unter Ihrer Kleidung unwiderstehlich sexy zu fühlen. Diese Dessous schmiegen sich perfekt an Ihre Rundungen an und sorgen für einen optimalen Tragekomfort, der den ganzen Tag anhält.

Struct
Entries: 15

abstract

string

careinstructions

string

<ul> <li>Πλένετε στο χέρι με χλιαρό νερό (30°C το πολύ)</li> <li>Χρησιμοποιήστε ήπιο απορρυπαντικό για να διατηρήσετε τη δαντέλα των λουλουδιών</li> <li>Χειριστείτε τα μαύρα και μωβ κεντήματα με προσοχή</li> <li>Στεγνώνετε σε επίπεδη επιφάνεια, μακριά από το άμεσο φως</li> <li>Μην σιδερώνετε απευθείας τα ευαίσθητα κεντήματα</li> </ul>

description

string

Evangeline Αυτό το κορμάκι είναι κατασκευασμένο από αδιαφανή μικροΐνα για το μπούστο και υπέροχη δίχρωμη φλοράλ δαντέλα για το μπούστο και το κάτω μέρο&sigmaf; του σώματο&sigmaf;. Ειδικά σχεδιασμένο για τι&sigmaf; καμπύλε&sigmaf; μα&sigmaf;, κοσμεί του&sigmaf; γλουτού&sigmaf; με λεπτεπίλεπτα κεντήματα σε μαύρο και μοβ χρώμα. Άψογη ποιότητα, άνοιγμα με πιεστικά στο καβάλο.

guid

string

https://dev.divasboudoir.com/el/evangeline-plus-size-kormaki-mayro-kai-mov/sbbo0072.htm

highlights

string

<ul> <li>Αδιαφανές μπούστο από μικροΐνες που αναδεικνύει τέλεια όλα τα στήθη</li> <li>Δίχρωμη φλοράλ δαντέλα στο μπούστο και στο κάτω μέρος του σώματος</li> <li>Λεπτό μαύρο και μοβ κέντημα κοσμεί αισθησιακά τους γλουτούς</li> <li>Άνοιγμα με πρέσα στον καβάλο για άτακτη πρόσβαση</li> <li>Άψογη ποιότητα ειδικά σχεδιασμένη για τις καμπύλες σας</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Υπέροχα χρώματα και φλοράλ δαντέλα για αυτό το όμορφο κορμάκι που διατίθεται σε όμορφα μεγάλα μεγέθη.

keywords

string

title

string

Evangeline plus size κορμάκι

seotitle

string

Evangeline plus size κορμάκι

seouri

string

evangeline-plus-size-kormaki-mayro-kai-mov

specifications

string

<ul> <li>Υλικό μπούστου: Υψηλής ποιότητας αδιαφανής μικροΐνα</li> <li>Διακοσμητικό υλικό: Δίχρωμη δαντέλα με λουλούδια</li> <li>Κέντημα: Λεπτά μοτίβα σε μαύρο και μοβ χρώμα στους γλουτούς</li> <li>Μεγέθη: Διατίθεται στην πλήρη σειρά plus size</li> <li>Κλείσιμο: Άνοιγμα με πρέσα στον καβάλο</li> <li>Σχεδιασμός: Ειδικά προσαρμοσμένο στις γενναιόδωρες καμπύλες</li> </ul>

stylingtips

string

Το κορμάκι Evangeline είναι ό,τι χρειάζεστε για να δημιουργήσετε μια άκρως αισθησιακή εμφάνιση. Η δίχρωμη φλοράλ δαντέλα και τα λεπτά κεντήματα δημιουργούν ήδη ένα εντυπωσιακό οπτικό αποτέλεσμα που αποκαλύπτει την πιο σέξι πλευρά σας. Για να εντείνετε το άτακτο αποτέλεσμα, συνδυάστε το με αξεσουάρ που απηχούν τους μαύρους και μοβ τόνους του κεντήματος. Αυτό το κομμάτι, ειδικά σχεδιασμένο για τις καμπύλες σας, ταιριάζει απόλυτα με αισθησιακούς, εκλεπτυσμένους τόνους. Για μια ακόμα πιο ερωτική προσέγγιση, παίξτε με το άνοιγμα με κουμπώματα για να δημιουργήσετε διαφορετικά εφέ έκπληξης. Ολοκληρώστε την εμφάνισή σας με προκλητικά <a href="https://www.divasboudoir.com/el/megalo-anoichto-kormaki/">ανοιχτά κορμάκια</a> για ποικιλία, συνδυάστε τα με εξαιρετικά αισθησιακά <a href="https://www.divasboudoir.com/el/negklize-megaloy-megethoys/">νεγκλιζέ</a>, ή αναδείξτε τα πόδια σας με τις εκλεπτυσμένες <a href="https://www.divasboudoir.com/el/kaltses-megaloy-megethoys/">κάλτσες</a> και τα άτακτα <a href="https://www.divasboudoir.com/el/anoichto-kalson-megalo/">καλσόν</a> μας.

summary

string

Υπέροχα χρώματα και φλοράλ δαντέλα για αυτό το όμορφο κορμάκι που διατίθεται σε όμορφα μεγάλα μεγέθη.

title

string

Σώμα Evangeline

usageinstructions

string

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

Struct
Entries: 15

abstract

string

careinstructions

string

<ul> <li>Hand wash in lukewarm water (30°C maximum)</li> <li>Use a mild detergent to preserve floral lace</li> <li>Handle black and mauve embroidery with care</li> <li>Dry flat, away from direct light</li> <li>Do not iron directly on delicate embroideries</li> </ul>

description

string

Evangeline This bodysuit is made from opaque microfiber for the bodice and gorgeous two-tone floral lace for the bust and lower body. Specially designed for our curves, it adorns the buttocks with delicate black and purple embroidery. Impeccable quality, snap opening at crotch.

guid

string

https://dev.divasboudoir.com/en/evangeline-plus-size-bodysuit-black-and-purple/sbbo0072.htm

highlights

string

<ul> <li>Opaque microfibre bodice perfectly enhances all breasts</li> <li>Two-tone floral lace on bust and lower body</li> <li>Delicate black and purple embroidery sensually adorns the buttocks</li> <li>Snaps at crotch for naughty access</li> <li>Impeccable quality specially designed for your curves</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Superb colors and floral lace for this pretty bodysuit, available in beautiful plus sizes.

keywords

string

title

string

Evangeline plus size bodysuit

seotitle

string

Evangeline plus size bodysuit

seouri

string

evangeline-plus-size-bodysuit-black-and-purple

specifications

string

<ul> <li>Bodice material: High-quality opaque microfibre</li> <li>Decorative material: Two-tone floral lace</li> <li>Embroidery: Delicate black and mauve motifs on buttocks</li> <li>Sizes: Available in all plus size ranges</li> <li>Closure: Press stud opening at crotch</li> <li>Design: Specially adapted to generous curves</li> </ul>

stylingtips

string

The Evangeline bodysuit is all you need to create an ultra-sensual look. The two-tone floral lace and delicate embroidery already create a striking visual effect that reveals your sexiest side. To intensify the naughty effect, pair it with accessories that echo the black and mauve tones of the embroidery. This piece, specially designed for your curves, goes perfectly with sensual, sophisticated tones. For an even more erotic approach, play with the snap opening to create different surprise effects. Complete your look with provocative <a href="https://www.divasboudoir.com/en/open-bodysuit-plus-size/">open bodysuits</a> for variety, pair with ultra-sensual <a href="https://www.divasboudoir.com/en/plus-size-robes/">negligees</a>, or sublimate your legs with our sophisticated <a href="https://www.divasboudoir.com/en/socks-large-size/">stockings</a> and naughty <a href="https://www.divasboudoir.com/en/open-tights-plus-size/">tights</a>.

summary

string

Superb colors and floral lace for this pretty bodysuit, available in beautiful plus sizes.

title

string

Body Evangeline

usageinstructions

string

The Evangeline bodysuit is designed to reveal your sensuality with sophistication. The snap opening at the crotch is easy to manipulate for naughty access according to your mood. The opaque microfiber provides optimum support for the bust while maintaining an ultra-sexy look. Delicate embroidery on the buttocks creates a provocative, eye-catching effect. Perfect for sensual intimate moments or for feeling irresistibly sexy under your clothes. This lingerie hugs your curves for optimum comfort that lasts all day.

Struct
Entries: 15

abstract

string

careinstructions

string

<ul> <li>Lavar a mano con agua tibia (30°C máximo)</li> <li>Utilice un detergente suave para conservar el encaje floral</li> <li>Manipular con cuidado los bordados negros y malvas</li> <li>Séquelo en plano, lejos de la luz directa</li> <li>No planchar directamente sobre bordados delicados</li> </ul>

description

string

Evangeline Este body está confeccionado en microfibra opaca para el corpiño y magnífico encaje floral bicolor para el busto y la parte inferior del cuerpo. Especialmente diseñado para nuestras curvas, adorna las nalgas con delicados bordados negros y morados. Calidad impecable, abertura con botones a presión en la entrepierna.

guid

string

https://dev.divasboudoir.com/es/body-talla-grande-evangeline-negro-y-lila/sbbo0072.htm

highlights

string

<ul> <li>Corpiño de microfibra opaca que realza perfectamente todos los pechos</li> <li>Encaje floral bicolor en el busto y la parte inferior del cuerpo</li> <li>Delicado bordado negro y morado que adorna sensualmente las nalgas</li> <li>Abertura con botones a presión en la entrepierna para un acceso travieso</li> <li>Calidad impecable especialmente diseñada para tus curvas</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Magníficos colores y encaje floral para este bonito body que se presenta en preciosas tallas grandes.

keywords

string

title

string

Body talla grande Evangeline

seotitle

string

Body talla grande Evangeline

seouri

string

body-talla-grande-evangeline-negro-y-lila

specifications

string

<ul> <li>Material del corpiño: microfibra opaca de alta calidad</li> <li>Material decorativo: Encaje floral bicolor</li> <li>Bordado: Delicados motivos negros y morados en las nalgas</li> <li>Tallas: Disponible en toda la gama de tallas grandes</li> <li>Cierre: Abertura con botones a presión en la entrepierna</li> <li>Diseño: Especialmente adaptado a las curvas generosas</li> </ul>

stylingtips

string

El body Evangeline es todo lo que necesitas para crear un look ultrasensual. El encaje floral bicolor y los delicados bordados ya crean un efecto visual impactante que revela tu lado más sexy. Para intensificar el efecto travieso, combínalo con accesorios que hagan eco de los tonos negros y morados del bordado. Esta pieza, especialmente diseñada para tus curvas, combina a la perfección con tonos sensuales y sofisticados. Para un enfoque aún más erótico, juega con la abertura a presión para crear diferentes efectos sorpresa. Completa tu look con provocativos <a href="https://www.divasboudoir.com/es/body-abierto-talla-grande/">bodys</a> abiertos para variar, combínalos con <a href="https://www.divasboudoir.com/es/picardias-talla-grande/">picardías</a> ultrasensuales o sublima tus piernas con nuestras sofisticadas <a href="https://www.divasboudoir.com/es/medias-grandes/">medias</a> y traviesos <a href="https://www.divasboudoir.com/es/medias-abiertas-talla-grande/">pantys</a>.

summary

string

Magníficos colores y encaje floral para este bonito body que se presenta en preciosas tallas grandes.

title

string

Body Evangeline

usageinstructions

string

El body Evangeline está diseñado para revelar tu sensualidad con sofisticación. La abertura a presión de la entrepierna es fácil de manipular para un acceso travieso según tu estado de ánimo. La microfibra opaca proporciona una sujeción óptima al busto, al tiempo que mantiene un aspecto ultra sexy. Los delicados bordados de las nalgas crean un efecto provocativo que atraerá todas las miradas. Perfecto para momentos íntimos sensuales o para sentirse irresistiblemente sexy bajo la ropa. Esta lencería abraza tus curvas para ofrecerte un confort óptimo que dura todo el día.

Struct
Entries: 15

abstract

string

careinstructions

string

<ul> <li>Lavage à la main à l'eau tiède (30°C maximum)</li> <li>Utiliser une lessive douce pour préserver la dentelle florale</li> <li>Manipuler délicatement les broderies noires et mauves</li> <li>Séchage à plat, à l'abri de la lumière directe</li> <li>Ne pas repasser directement sur les broderies délicates</li> </ul>

description

string

Le body Evangeline incarne la sensualité raffinée avec sa combinaison audacieuse de microfibre opaque et dentelle florale bicolore. Cette lingerie ultra sexy sublime vos courbes généreuses grâce à sa conception spécialement pensée pour vos rondeurs. Le corsage en microfibre opaque épouse parfaitement toutes les morphologies, tandis que la dentelle florale bicolore sur la poitrine et le bas du corps crée un effet visuel irrésistiblement coquin. Les broderies délicates noires et mauves qui ornent les fesses ajoutent une touche érotique sophistiquée. L'ouverture par pressions à l'entrejambe offre un accès sensuel tout en conservant l'élégance de la pièce. Cette création s'adapte parfaitement à toutes les morphologies grâce à ses matières extensibles et sa qualité impeccable qui garantit un confort optimal toute la journée.

guid

string

https://dev.divasboudoir.com/fr/body-microfibre-dentelle-florale-grande-taille/sbbo0072.htm

highlights

string

<ul> <li>Microfibre opaque corsage qui sublime parfaitement toutes les poitrines</li> <li>Dentelle florale bicolore sur la poitrine et le bas du corps</li> <li>Broderies délicates noires et mauves qui ornent sensuellement les fesses</li> <li>Ouverture par pressions à l'entrejambe pour un accès coquin</li> <li>Qualité impeccable spécialement conçue pour vos rondeurs</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Body Evangeline ultra sexy grande taille : microfibre opaque, dentelle florale bicolore, broderies délicates fesses, ouverture pressions. Sensualité raffinée | Diva's Boudoir

keywords

string

title

string

Body Evangeline microfibre dentelle grande taille | Diva's Boudoir

seotitle

string

Body grande taille microfibre et dentelle florale avec ouverture

seouri

string

body-microfibre-dentelle-florale-grande-taille

specifications

string

<ul> <li>Matière corsage : Microfibre opaque de qualité supérieure</li> <li>Matière décorative : Dentelle florale bicolore</li> <li>Broderies : Motifs délicats noires et mauves sur les fesses</li> <li>Tailles : Disponible dans toute la gamme grande taille</li> <li>Fermeture : Ouverture par pressions à l'entrejambe</li> <li>Conception : Spécialement adaptée aux rondeurs généreuses</li> </ul>

stylingtips

string

Le body Evangeline se suffit à lui-même pour créer un look ultra sensuel. La dentelle florale bicolore et les broderies délicates créent déjà un effet visuel saisissant qui révèle votre côté le plus sexy. Pour intensifier l'effet coquin, associez-le à des accessoires qui rappellent les tons noirs et mauves des broderies. Cette pièce spécialement conçue pour vos rondeurs s'accorde parfaitement avec des tons sensuels et sophistiqués. Pour une approche encore plus érotique, jouez avec l'ouverture par pressions pour créer différents effets de surprise. Complétez votre look avec des <a href="https://www.divasboudoir.com/fr/body-ouvert-grande-taille/">bodys ouverts</a> provocants pour varier les plaisirs, associez à des <a href="https://www.divasboudoir.com/fr/deshabille-grande-taille/">déshabillés</a> ultra sensuels, ou sublimez vos jambes avec nos <a href="https://www.divasboudoir.com/fr/bas-grande-taille/">bas</a> sophistiqués et nos <a href="https://www.divasboudoir.com/fr/collant-ouvert-grande-taille/">collants</a> coquins. Envie de superbes bas autofixants à votre taille, retrouvez la sélection de <a href="https://www.legsboudoir.com/fr/bas-autofixants-grande-taille/">Legs Boudoir</a>, jusqu'à la taille 64!

summary

string

Découvrez le body Evangeline, une création ultra sensuelle qui marie microfibre opaque et dentelle florale bicolore. Spécialement conçu pour sublimer vos rondeurs avec des broderies délicates et une ouverture coquine à l'entrejambe.

title

string

Body Evangeline : Microfibre Opaque et Dentelle Florale Bicolore Ultra Sexy

usageinstructions

string

Le body Evangeline est conçu pour révéler votre sensualité avec sophistication. L'ouverture par pressions à l'entrejambe se manipule facilement pour un accès coquin selon vos envies du moment. La microfibre opaque offre un maintien optimal de la poitrine tout en conservant un look ultra sexy. Les broderies délicates sur les fesses créent un effet provocant qui attire tous les regards. Parfait pour les moments intimes sensuels ou pour vous sentir irrésistiblement sexy sous vos vêtements. Cette lingerie épouse parfaitement vos rondeurs pour un confort optimal qui dure toute la journée.

Struct
Entries: 15

abstract

string

careinstructions

string

<ul> <li>Lavare a mano in acqua tiepida (massimo 30°C)</li> <li>Utilizzare un detergente delicato per preservare il pizzo floreale</li> <li>Maneggiare con cura i ricami neri e malva</li> <li>Asciugare in piano, al riparo dalla luce diretta</li> <li>Non stirare direttamente i ricami delicati</li> </ul>

description

string

Evangeline Questo body è realizzato in microfibra opaca per il corpetto e in superbo pizzo floreale bicolore per il busto e la parte inferiore del corpo. Appositamente studiato per le nostre curve, adorna i glutei con delicati ricami neri e viola. Qualità impeccabile, apertura con bottoni a pressione sul cavallo.

guid

string

https://dev.divasboudoir.com/it/body-evangeline-taglia-grande-nero-e-malva/sbbo0072.htm

highlights

string

<ul> <li>Corpetto in microfibra opaca che valorizza perfettamente tutti i seni</li> <li>Pizzo floreale bicolore sul busto e sulla parte inferiore del corpo</li> <li>Delicati ricami neri e viola adornano sensualmente i glutei</li> <li>Apertura con bottoni a pressione sul cavallo per un accesso più malizioso</li> <li>Qualità impeccabile, appositamente studiata per le vostre curve</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Colori superbi e pizzo floreale per questo grazioso body disponibile in una bella taglia grande.

keywords

string

title

string

Body Evangeline taglia grande

seotitle

string

Body Evangeline taglia grande

seouri

string

body-evangeline-taglia-grande-nero-e-malva

specifications

string

Entdecken Sie die "Hot"-Kollektion offener Lingerie in großen Größen bei Diva's Boudoir. Wagen Sie Sinnlichkeit mit gewagten Schnitten und verführerischen Materialien. Zeigen Sie sich von Ihrer heißesten Seite!

stylingtips

string

Il body Evangeline è tutto ciò che vi serve per creare un look ultra-sensuale. Il pizzo floreale bicolore e i delicati ricami creano già un effetto visivo sorprendente che rivela il vostro lato più sexy. Per intensificare l'effetto malizioso, abbinatelo ad accessori che riprendano i toni neri e viola dei ricami. Questo capo, studiato appositamente per le vostre curve, si abbina perfettamente a toni sensuali e sofisticati. Per un approccio ancora più erotico, giocate con l'apertura a scatto per creare diversi effetti sorpresa. Completate il vostro look con provocanti <a href="https://www.divasboudoir.com/it/body-aperto-di-grande-taglia/">body aperti</a> per variare, abbinateli a <a href="https://www.divasboudoir.com/it/vestaglia-taglia-grande/">vestaglie</a> ultra-sensuali o sublimate le vostre gambe con le nostre sofisticate <a href="https://www.divasboudoir.com/it/calze-di-grandi-dimensioni/">calze</a> e <a href="https://www.divasboudoir.com/it/collant-aperti-di-taglia-grande/">collant</a> maliziosi.

summary

string

Colori superbi e pizzo floreale per questo grazioso body disponibile in una bella taglia grande.

title

string

Body Evangeline

usageinstructions

string

Il body Evangeline è progettato per rivelare la vostra sensualità con raffinatezza. L'apertura con bottoni a pressione sul cavallo è facile da manipolare per un accesso malizioso a seconda del vostro umore. La microfibra opaca offre un sostegno ottimale al seno, mantenendo un look ultra-sexy. I delicati ricami sui glutei creano un effetto provocante che attirerà sicuramente l'attenzione di tutti. Perfetto per i momenti di intimità sensuale o per sentirsi irresistibilmente sexy sotto i vestiti. Questa lingerie abbraccia le vostre curve per un comfort ottimale che dura tutto il giorno.

Struct
Entries: 15

abstract

string

careinstructions

string

<ul> <li>Handwas in lauw water (maximaal 30°C)</li> <li>Gebruik een mild wasmiddel om het bloemenkant te behouden</li> <li>Ga voorzichtig om met zwart en mauve borduurwerk</li> <li>Plat drogen, niet in direct licht</li> <li>Niet rechtstreeks strijken op delicaat borduurwerk</li> </ul>

description

string

Evangeline Deze bodysuit is gemaakt van ondoorzichtig microvezel voor het lijfje en prachtig tweekleurig bloemenkant voor de buste en het onderlichaam. Speciaal ontworpen voor onze rondingen, versiert het de billen met delicaat zwart en paars borduurwerk. Onberispelijke kwaliteit, opening met drukknoop in het kruis.

guid

string

https://dev.divasboudoir.com/nl/rompertje-evangeline-groote-maat-zwart-en-mauve/sbbo0072.htm

highlights

string

<ul> <li>Ondoorzichtig lijfje van microvezel dat alle borsten perfect laat uitkomen</li> <li>Tweekleurig bloemenkant op buste en onderlichaam</li> <li>Delicaat zwart en paars borduurwerk siert sensueel de billen</li> <li>Drukknoopopenopening in het kruis voor ondeugende toegang</li> <li>Onberispelijke kwaliteit, speciaal ontworpen voor jouw rondingen</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Schitterende kleuren en bloemenkant voor dit mooie rompertje dat verkrijgbaar is in mooie groote maten.

keywords

string

title

string

Rompertje Evangeline groote maat

seotitle

string

Rompertje Evangeline groote maat

seouri

string

rompertje-evangeline-groote-maat-zwart-en-mauve

specifications

string

<ul> <li>Materiaal lijfje: Hoogwaardige ondoorzichtige microvezel</li> <li>Decoratiemateriaal: Tweekleurig bloemenkant</li> <li>Borduursel: Delicate zwarte en paarse motieven op billen</li> <li>Maten: Verkrijgbaar in de grote maten</li> <li>Sluiting: Drukknoopsluiting in kruis</li> <li>Ontwerp: Speciaal aangepast aan royale rondingen</li> </ul>

stylingtips

string

De Evangeline bodysuit is alles wat je nodig hebt om een ultra-sensuele look te creëren. Het tweekleurige bloemenkant en het delicate borduursel creëren al een opvallend visueel effect dat je van je meest sexy kant laat zien. Om het ondeugende effect te versterken, combineer je het met accessoires die de zwarte en paarse tinten van het borduursel weerspiegelen. Dit stuk, speciaal ontworpen voor je rondingen, past perfect bij sensuele, geraffineerde tinten. Voor een nog erotischere aanpak kun je spelen met de drukknoopopen om verschillende verrassingseffecten te creëren. Maak je look compleet met provocerende <a href="https://www.divasboudoir.com/nl/groote-open-romper/">open bodysuits</a> voor afwisseling, combineer met ultra-sensuele <a href="https://www.divasboudoir.com/nl/grote-maat-neglige/">negligés</a>, of sublimeer je benen met onze geraffineerde <a href="https://www.divasboudoir.com/nl/grote-maat-kousen/">kousen</a> en ondeugende <a href="https://www.divasboudoir.com/nl/open-panty-groote-maat/">panty's</a>.

summary

string

Schitterende kleuren en bloemenkant voor dit mooie rompertje dat verkrijgbaar is in mooie groote maten.

title

string

Bodysuit Evangeline

usageinstructions

string

De Evangeline bodysuit is ontworpen om je sensualiteit geraffineerd te onthullen. De drukknoopsluiting in het kruis is gemakkelijk te manipuleren voor ondeugende toegang, afhankelijk van je stemming. De ondoorzichtige microvezel biedt optimale ondersteuning voor de buste terwijl het een ultra-sexy look behoudt. Delicaat borduurwerk op de billen creëert een provocerend effect dat zeker ieders aandacht zal trekken. Perfect voor sensuele intieme momenten of om je onweerstaanbaar sexy te voelen onder je kleding. Deze lingerie omhelst je rondingen voor optimaal comfort dat de hele dag aanhoudt.

Struct
Entries: 15

abstract

string

careinstructions

string

<ul> <li>Lavar à mão em água tépida (30°C no máximo)</li> <li>Utilizar um detergente suave para preservar a renda floral</li> <li>Manusear os bordados pretos e malva com cuidado</li> <li>Secar em local plano, longe da luz direta</li> <li>Não passar a ferro diretamente sobre bordados delicados</li> </ul>

description

string

Evangelina Este body é confeccionado em microfibra opaca para o corpete e em magnífica renda floral bicolor para o busto e a parte inferior do corpo. Especialmente concebido para as nossas curvas, adorna as nádegas com delicados bordados pretos e roxos. Qualidade impecável, abertura com botões de pressão na virilha.

guid

string

https://dev.divasboudoir.com/pt/evangeline-body-plus-size-preto-e-lilas/sbbo0072.htm

highlights

string

<ul> <li>Corpete em microfibra opaca que realça perfeitamente todos os seios</li> <li>Renda floral em dois tons no busto e na parte inferior do corpo</li> <li>Delicados bordados pretos e roxos adornam sensualmente as nádegas</li> <li>Abertura com botões de pressão nas virilhas para um acesso atrevido</li> <li>Qualidade impecável especialmente concebida para as suas curvas</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Cores magníficas e rendas florais para este bonito body, disponível em belos tamanhos grandes.

keywords

string

title

string

Evangeline body plus size

seotitle

string

Evangeline body plus size

seouri

string

evangeline-body-plus-size-preto-e-lilas

specifications

string

<ul> <li>Material do corpete: microfibra opaca de alta qualidade</li> <li>Material decorativo: Renda floral em dois tons</li> <li>Bordado: Delicados motivos pretos e roxos nas nádegas</li> <li>Tamanhos: Disponível em toda a gama plus size</li> <li>Fecho: Abertura com botões de pressão nas virilhas</li> <li>Design: Especialmente adaptado a curvas generosas</li> </ul>

stylingtips

string

O body Evangeline é tudo o que precisa para criar um look ultra-sensual. A renda floral de dois tons e o bordado delicado já criam um efeito visual marcante que revela o seu lado mais sexy. Para intensificar o efeito atrevido, combine-o com acessórios que façam eco dos tons preto e roxo do bordado. Esta peça, especialmente concebida para as suas curvas, combina na perfeição com tons sensuais e sofisticados. Para uma abordagem ainda mais erótica, brinque com a abertura de encaixe para criar diferentes efeitos surpresa. Complete o seu look com os provocantes <a href="https://www.divasboudoir.com/pt/body-grande-aberto/">bodys abertos</a> para variar, combine-os com <a href="https://www.divasboudoir.com/pt/batotas-plus-size/">negligés</a> ultra-sensuais ou sublimar as suas pernas com as nossas sofisticadas <a href="https://www.divasboudoir.com/pt/meias-de-tamanho-grande/">meias</a> de ligas e <a href="https://www.divasboudoir.com/pt/meias-abertas-tamanho-grande/">collants</a> atrevidos.

summary

string

Cores magníficas e rendas florais para este bonito body, disponível em belos tamanhos grandes.

title

string

Body Evangelina

usageinstructions

string

O body Evangeline foi concebido para revelar a sua sensualidade com sofisticação. A abertura com botões de pressão na virilha é fácil de manipular para um acesso atrevido de acordo com a sua disposição. A microfibra opaca proporciona um suporte ótimo para o busto, mantendo um aspeto ultra-sexy. Os delicados bordados nas nádegas criam um efeito provocante que certamente chamará a atenção de todos. Perfeita para momentos íntimos sensuais ou para se sentir irresistivelmente sexy debaixo da roupa. Esta lingerie abraça as suas curvas para um conforto ótimo que dura todo o dia.

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-und-lila

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-kai-mov

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-and-purple

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-y-lila

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-et-mauve

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-e-malva

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-en-mauve

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-e-lilas

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-und-lila

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-kai-mov

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-and-purple

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-y-lila

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-et-mauve

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-e-malva

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-en-mauve

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-e-lilas

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-und-lila

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-kai-mov

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-and-purple

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-y-lila

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-et-mauve

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-e-malva

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-en-mauve

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-e-lilas

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-und-lila

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-kai-mov

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-and-purple

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-y-lila

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-et-mauve

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-e-malva

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-en-mauve

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-e-lilas

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-und-lila

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-kai-mov

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-and-purple

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-y-lila

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-et-mauve

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-e-malva

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-en-mauve

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-e-lilas

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

name

string

Body

netweight

string

nextshipment

string

today

ordered

number

orderidx

number

origin

string

originalsize

string

packaging

number

productshipment

string

auto

productuid

string

0D33AF60-78D4-489B-AE88E9EBAC8B09B7

promountil

string

rating

string

none

recorduid

string

0D33AF60-78D4-489B-AE88E9EBAC8B09B7

reference

string

SBBO0072

string

reserved

number

returned

number

returnsallowed

number

section

string

lingerie

shipment

string

4to6days

showbrand

number

sizeinfos

Query Template: /system/api/product/sizes.cfc:20 Execution Time: 1.59 ms Record Count: 9 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,'1408,736,737,738,739,740,741,742,743') > 0 and product_variations.productuid = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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	737	XL+	intlsize	blackpurple	XL+	XL+	-1	999999	0	w	plus	lingerie	XL	XL+		48-50	18-20	22-24	50-52	50-52	48-50	54-56	50-52	48-50	113-118	96-102	117-121
2	739	2XL+	intlsize	blackpurple	2XL+	2XL+	-1	999999	0	w	plus	lingerie	2XL	2XL+		52-54	22-24	26-28	54-56	54-56	52-54	58-60	54-56	52-54	125-130	109-114	127-132
3	741	3XL+	intlsize	blackpurple	3XL+	3XL+	-1	999999	1	w	plus	lingerie	3XL	3XL+		56-58	26-28	30-32	58-60	58-60	56-58	62-64	58-60	56-58	137-142	122-128	138-144
4	743	4XL+	intlsize	blackpurple	4XL+	4XL+	-1	999999	0	w	plus	lingerie	4XL	4XL+		60-62	30-32	34-38	62-64	62-64	60-62	66-68	62-64	60-62	149-154	135-140	151-156
5	1408	L	intlsize	blackpurple	L	L	-1	999999	0	w	plus	lingerie	XL	L		44-46	14-16	18-20	46-48	46-48	44-46	50-52	46-48	44-46	103-106	86-90	109-112
6	736	XL	intlsize	blackpurple	XL	XL	-1	999999	0	w	plus	lingerie	XL	XL		46-48	16-18	20-22	48-50	48-50	46-48	52-54	48-50	46-48	107-112	91-95	113-116
7	738	2XL	intlsize	blackpurple	2XL	2XL	-1	999999	0	w	plus	lingerie	2XL	2XL		50-52	20-24	24-28	52-54	52-54	50-52	56-58	52-54	50-52	119-124	103-108	122-126
8	740	3XL	intlsize	blackpurple	3XL	3XL	-1	999999	1	w	plus	lingerie	3XL	3XL		54-56	24-26	28-30	56-58	56-58	54-56	60-62	56-58	54-56	131-136	115-121	133-138
9	742	4XL	intlsize	blackpurple	4XL	4XL	-1	999999	0	w	plus	lingerie	4XL	4XL		58-60	28-30	32-34	60-62	60-62	58-60	64-68	60-62	58-60	143-148	129-134	145-150

sizeranges

string

plus

sizes

string

1408,736,737,738,739,740,741,742,743

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: 9.47 ms Record Count: 4 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' and product_variations.isactive = 1 and product_sizes.id_size = 1408 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' and product_variations.isactive = 1 and product_sizes.id_size = 736 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' and product_variations.isactive = 1 and product_sizes.id_size = 737 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' and product_variations.isactive = 1 and product_sizes.id_size = 738 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' and product_variations.isactive = 1 and product_sizes.id_size = 739 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' and product_variations.isactive = 1 and product_sizes.id_size = 740 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' and product_variations.isactive = 1 and product_sizes.id_size = 741 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' and product_variations.isactive = 1 and product_sizes.id_size = 742 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' and product_variations.isactive = 1 and product_sizes.id_size = 743 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	0D33AF60-78D4-489B-AE88E9EBAC8B09B7	B92C18A0-956D-4474-AB1599317F123D3F	1408	blackpurple	linear-gradient(90deg, #000000 50%, #9400D4 50%)	XL	L		44-46	14-16	18-20	46-48	46-48	44-46	50-52	46-48	44-46	w	lingerie		L	intlsize	41.625	0		STOCK01	0	0	0	-1	0	12	0	0	26429481051	4024144122172	-1	0	all
2	0D33AF60-78D4-489B-AE88E9EBAC8B09B7	0EF110CC-DD9F-40B8-81D96288720637EF	738	blackpurple	linear-gradient(90deg, #000000 50%, #9400D4 50%)	2XL	2XL		50-52	20-24	24-28	52-54	52-54	50-52	56-58	52-54	50-52	w	lingerie		2XL	intlsize	41.625	0		STOCK01	0	0	0	-1	1	5	0	0	26429481061	4024144122189	-1	0	all
3	0D33AF60-78D4-489B-AE88E9EBAC8B09B7	8A34A41F-D177-46E7-B9B53AE1E6F31E2D	740	blackpurple	linear-gradient(90deg, #000000 50%, #9400D4 50%)	3XL	3XL		54-56	24-26	28-30	56-58	56-58	54-56	60-62	56-58	54-56	w	lingerie		3XL	intlsize	41.625	0		STOCK01	1	0	0	-1	0	2	0	0	26429481071	4024144122196	1	1	all
4	0D33AF60-78D4-489B-AE88E9EBAC8B09B7	70AFAD13-C9D0-4EAE-AA18E923F9318A1A	742	blackpurple	linear-gradient(90deg, #000000 50%, #9400D4 50%)	4XL	4XL		58-60	28-30	32-34	60-62	60-62	58-60	64-68	60-62	58-60	w	lingerie		4XL	intlsize	41.625	0		STOCK01	0	0	0	-1	0	3	0	0	26429481081	4024144122202	-1	0	all

subcategory

string

body

supplier

number

-1

supplierreference

string

26429481051

tags

string

themes

string

totalvariations

number

type

string

default

unitprice

number

41.625

usageinstructions

string

variations

Query Template: /system/api/product/variations.cfc:171 Execution Time: 29.9 ms Record Count: 9 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' and product_variations.isactive = 1 and product_sizes.id_size = 1408 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' and product_variations.isactive = 1 and product_sizes.id_size = 736 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' and product_variations.isactive = 1 and product_sizes.id_size = 737 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' and product_variations.isactive = 1 and product_sizes.id_size = 738 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' and product_variations.isactive = 1 and product_sizes.id_size = 739 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' and product_variations.isactive = 1 and product_sizes.id_size = 740 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' and product_variations.isactive = 1 and product_sizes.id_size = 741 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' and product_variations.isactive = 1 and product_sizes.id_size = 742 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' 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 = '0D33AF60-78D4-489B-AE88E9EBAC8B09B7' and product_variations.isactive = 1 and product_sizes.id_size = 743 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	B92C18A0-956D-4474-AB1599317F123D3F	737	blackpurple	linear-gradient(90deg, #000000 50%, #9400D4 50%)	XL	XL+		48-50	18-20	22-24	50-52	50-52	48-50	54-56	50-52	48-50	w	lingerie		XL+	intlsize	41.625	0		STOCK01	0	0	0	-1	0	12	0	0	26429481051	4024144122172	-1	0	-1	0	-1	0	0	41.625	all
2	0EF110CC-DD9F-40B8-81D96288720637EF	739	blackpurple	linear-gradient(90deg, #000000 50%, #9400D4 50%)	2XL	2XL+		52-54	22-24	26-28	54-56	54-56	52-54	58-60	54-56	52-54	w	lingerie		2XL+	intlsize	41.625	0		STOCK01	0	0	0	-1	1	5	0	0	26429481061	4024144122189	-1	0	-1	0	-1	0	0	41.625	all
3	8A34A41F-D177-46E7-B9B53AE1E6F31E2D	741	blackpurple	linear-gradient(90deg, #000000 50%, #9400D4 50%)	3XL	3XL+		56-58	26-28	30-32	58-60	58-60	56-58	62-64	58-60	56-58	w	lingerie		3XL+	intlsize	41.625	0		STOCK01	1	0	0	-1	0	2	0	0	26429481071	4024144122196	1	1	-1	1	-1	0	0	41.625	all
4	70AFAD13-C9D0-4EAE-AA18E923F9318A1A	743	blackpurple	linear-gradient(90deg, #000000 50%, #9400D4 50%)	4XL	4XL+		60-62	30-32	34-38	62-64	62-64	60-62	66-68	62-64	60-62	w	lingerie		4XL+	intlsize	41.625	0		STOCK01	0	0	0	-1	0	3	0	0	26429481081	4024144122202	-1	0	-1	0	-1	0	0	41.625	all
5	B92C18A0-956D-4474-AB1599317F123D3F	1408	blackpurple	linear-gradient(90deg, #000000 50%, #9400D4 50%)	XL	L		44-46	14-16	18-20	46-48	46-48	44-46	50-52	46-48	44-46	w	lingerie		L	intlsize	41.625	0		STOCK01	0	0	0	-1	0	12	0	0	26429481051	4024144122172	-1	0	-1	0	-1	0	0	41.625	all
6	B92C18A0-956D-4474-AB1599317F123D3F	736	blackpurple	linear-gradient(90deg, #000000 50%, #9400D4 50%)	XL	XL		46-48	16-18	20-22	48-50	48-50	46-48	52-54	48-50	46-48	w	lingerie		XL	intlsize	41.625	0		STOCK01	0	0	0	-1	0	12	0	0	26429481051	4024144122172	-1	0	-1	0	-1	0	0	41.625	all
7	0EF110CC-DD9F-40B8-81D96288720637EF	738	blackpurple	linear-gradient(90deg, #000000 50%, #9400D4 50%)	2XL	2XL		50-52	20-24	24-28	52-54	52-54	50-52	56-58	52-54	50-52	w	lingerie		2XL	intlsize	41.625	0		STOCK01	0	0	0	-1	1	5	0	0	26429481061	4024144122189	-1	0	-1	0	-1	0	0	41.625	all
8	8A34A41F-D177-46E7-B9B53AE1E6F31E2D	740	blackpurple	linear-gradient(90deg, #000000 50%, #9400D4 50%)	3XL	3XL		54-56	24-26	28-30	56-58	56-58	54-56	60-62	56-58	54-56	w	lingerie		3XL	intlsize	41.625	0		STOCK01	1	0	0	-1	0	2	0	0	26429481071	4024144122196	1	1	-1	1	-1	0	0	41.625	all
9	70AFAD13-C9D0-4EAE-AA18E923F9318A1A	742	blackpurple	linear-gradient(90deg, #000000 50%, #9400D4 50%)	4XL	4XL		58-60	28-30	32-34	60-62	60-62	58-60	64-68	60-62	58-60	w	lingerie		4XL	intlsize	41.625	0		STOCK01	0	0	0	-1	0	3	0	0	26429481081	4024144122202	-1	0	-1	0	-1	0	0	41.625	all

vatrate

number

warehouse

number

Κύρια σημεία

Evangeline plus size κορμάκι

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

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

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

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

Σύνθεση

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

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

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

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

ΠΛΗΡΟΦΟΡΊΕΣ

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

ΥΠΗΡΕΣΊΕΣ

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

Κύρια σημεία

Evangeline plus size κορμάκι

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

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

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

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

Σύνθεση

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

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

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

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

Newsletter

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

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