Struct
Entries: 108 |
| actions | |
| available | |
| brand | |
| brandcode | |
| branding | |
| brandmedias | | string | {"default":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"editorial":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"logo":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""}} |
|
| brandmetas | | Struct | | de | | Struct | | currentseouri | | | description | | string | <div class="brand-description">
<h2>Secret Shapes by Diva's Boudoir: Die Revolution der Formenden Wäsche in Größen</h2>
<h3>Eine komplette Kollektion für alle Körpertypen</h3>
<p><strong>Secret Shapes by Diva's Boudoir</strong> erfindet formende Wäsche neu, indem wir eine Kollektion anbieten, die ausschließlich entwickelt wurde, um <strong>Ihre Kurven in den Mittelpunkt zu stellen</strong>. Jedes Stück unserer Linie kombiniert <strong>fortschrittliche Körperformungs-Technologie</strong> und <strong>sinnliches Design</strong>, um Ihnen eine definierte und verfeinerte Silhouette vom Morgen bis zum Abend zu bieten.</p>
<p>Unsere Philosophie? <strong>Kleine Makel sanft ausgleichen</strong>, während wir Ihre natürliche Schönheit feiern. Mit Secret Shapes erhalten Sie <strong>Formungs-Lösungen, die auf jede Gelegenheit zugeschnitten sind</strong>: nahtlose Bodies für einen unsichtbaren Effekt unter Ihrer Kleidung, modellierende Kleider für Ihre Abende, formierende Slips für den Alltag und post-operative Kompressionswäsche für optimale Unterstützung.</p>
<h3>Bahnbrechende Technologien für unvergleichlichen Komfort</h3>
<p>Die Secret Shapes Produkte integrieren <strong>Textil-Innovationen der neuesten Generation</strong>:</p>
<ul>
<li><strong>Gezielte Multi-Zonen-Kompression</strong>: Kontrolle von Taille und Bauch, Brustunterstützung, Gesäßanhebung</li>
<li><strong>Ultra-atmungsaktive nahtlose Stoffe</strong>: Weiche Materialien, die Ihre Silhouette umschmeicheln, ohne übermäßig zu markieren oder zu komprimieren</li>
<li><strong>Verstellbare Haken- und Verschlusssysteme</strong>: Für eine auf Ihre Bedürfnisse zugeschnittene Unterstützung</li>
<li><strong>Zertifizierte hypoallergene Materialien</strong>: Premium-Qualität Nylon, Spandex und Latex für Hautverträglichkeit</li>
<li><strong>Ergonomisches Design</strong>: Offener Rücken, integrierte Cups, Druckpunkt im Schritt für maximalen Komfort</li>
</ul>
<h3>Formungs-Lösungen für jede Anforderung</h3>
<p><strong>Formende Bodies und Kombinationen</strong>: Unsere nahtlosen Bodies bieten einen <strong>sofortigen glättenden Effekt von Brust bis Oberschenkel</strong>. Erhältlich mit oder ohne integrierte Cups, <strong>sie modellieren Ihre Silhouette</strong> und bleiben unsichtbar unter Ihren Outfits. Modelle mit offenem oder Druck-Schritt erleichtern Ihre täglichen Bewegungen.</p>
<p><strong>Modellierende Kleider</strong>: Perfekt für Ihre Veranstaltungen, unsere formenden Kleider kombinieren <strong>Eleganz und Formungseffekt</strong>. Der elastische Stoff umschmeichelt Ihre Kurven und <strong>verfeinert die Taille sowie glättet die Hüften</strong> und schafft eine harmonische Silhouette unter jedem Outfit.</p>
<p><strong>Formierende Slips und Shorts</strong>: Von leichter Kontrolle bis fester Unterstützung, unsere formenden Slips <strong>straffen den Bauch und heben das Gesäß</strong> mit Diskretion. Modelle bis zum mittleren Oberschenkel verhindernReibung und <strong>modellieren die Oberschenkel</strong>.</p>
<p><strong>Formierende BHs</strong>: Unsere BHs ohne Bügel mit verstellbaren Trägern bieten <strong>optimale Brustunterstützung</strong> und <strong>glätten Rücken und Hüftspeck</strong>. Perfekt unter Ihren eng anliegenden Tops oder Ausschnitten.</p>
<p><strong>Sport-Formwäsche</strong>: Modellierende Jumpsuits und Leggings für Ihre Trainings- oder Saunaeinheiten. Der technische Stoff <strong>fördert die Transpiration</strong> und <strong>unterstützt Ihre Silhouette</strong> während der Anstrengung.</p>
<p><strong>Post-operative Wäsche</strong>: Unsere Faja-Linie bietet <strong>medizinische post-operative Unterstützung</strong> mit fester Kompression und vollständiger Abdeckung für eine optimale Erholung nach Ihren ästhetischen Eingriffen.</p>
<h3>Warum Secret Shapes by Diva's Boudoir wählen?</h3>
<ul>
<li><strong>Spezialist für Formwäsche</strong>: Über 15 Jahre Erfahrung in Körperformungs-Lösungen</li>
<li><strong>Zertifizierte Qualität</strong>: Getestete und zertifizierte Produkte (CE, ROHS, ISO) für Ihre Sicherheit</li>
<li><strong>Ständiger Vorrat</strong>: Über 400.000 Stücke monatlich verfügbar</li>
<li><strong>Schneller 48-Stunden-Versand</strong>: Ihre Bestellungen werden innerhalb von 48 Stunden bearbeitet und versendet</li>
<li><strong>Komplettes Sortiment</strong>: Von leichter Kontrolle bis fester Unterstützung, für alle Anlässe</li>
<li><strong>Unsichtbares Design</strong>: Nahtlose Wäsche, die unter Ihrer Kleidung diskret bleibt</li>
<li><strong>Ganztägiger Komfort</strong>: Atmungsaktive Materialien, die sich <strong>Ihren Bewegungen anpassen</strong></li>
</ul>
<h3>Die Kunst, Ihre Silhouette natürlich zu formen</h3>
<p>Secret Shapes by Diva's Boudoir glättet nicht nur <strong>kleine Makel</strong>: Unsere Formwäsche <strong>offenbart Ihr natürliches Selbstvertrauen</strong>. Jedes Stück ist so konzipiert, dass Sie sich <strong>sexy, kraftvoll und wohl</strong> in Ihrer Haut fühlen, unabhängig von der Gelegenheit.</p>
<p>Unsere Kundinnen schätzen besonders:</p>
<ul>
<li>Den <strong>sofortigen Formungseffekt</strong> ohne Unbehagen</li>
<li>Die <strong>Vielseitigkeit der Stücke</strong>: Tragbar allein oder unter Kleidung</li>
<li>Die <strong>Haltbarkeit der Materialien</strong>: Wäsche, die nach jedem Waschgang ihre Elastizität behält</li>
<li>Das <strong>sinnliche Design</strong>: Spitze, Leopardenmuster, Trendfarben (Schokoladenmousse, Nude, Schwarz)</li>
<li>Die <strong>Personalisierungsoptionen</strong>: Verstellbare Träger, mehrere Haken, Kompressionsstufen</li>
</ul>
<h3>Gebrauchs- und Pflegeanleitung</h3>
<p><strong>Für optimale Wirkung</strong> wählen Sie Ihre Kompressionsstufe je nach Anlass: leichte Kontrolle für den Alltag, mittlere Kompression für Veranstaltungen, feste Unterstützung für besondere Anlässe. Tragen Sie Ihre Formwäsche direkt auf der Haut für maximalen Glättungseffekt.</p>
<p><strong>Pflege</strong>: Waschen Sie Ihre Secret Shapes Stücke von Hand oder in der Maschine (Feinwaschgang) mit kaltem Wasser. Vermeiden Sie den Trockner und bevorzugen Sie das Trocknen in Waagerechte, um die Elastizität der Fasern zu erhalten. Verwenden Sie ein mildes Waschmittel ohne Bleichmittel.</p>
<h3>Secret Shapes: Ihr täglicher Vertrauensverbündeter</h3>
<p>Ob Sie sich auf einen besonderen Anlass vorbereiten, post-operative Unterstützung suchen oder einfach <strong>Ihre Silhouette täglich verfeinern</strong> möchten, Secret Shapes by Diva's Boudoir bietet Formwäsche-Lösungen, die sich <strong>Ihrem Leben anpassen</strong>. Unser Versprechen: Sie sich <strong>unwiderstehlich und selbstbewusst</strong> fühlen zu lassen, jeden Tag.</p>
<p>Entdecken Sie jetzt unsere komplette Kollektion und finden Sie die Formwäsche, die <strong>die beste Version Ihrer selbst offenbart</strong>.</p>
</div> |
| | metas | | Struct | | description | | | keywords | | | title | |
| | name | | string | Secret Shapes by Diva's Boudoir |
| | seotitle | | | seouri | | | subtitle | | | summary | | string | <div class="brand-intro">
<h2>Secret Shapes by Diva's Boudoir: Formende Wäsche in Größen</h2>
<p><strong>Secret Shapes by Diva's Boudoir</strong> revolutioniert die formende Wäsche mit einer kompletten Kollektion, speziell entwickelt, um <strong>Ihre atemberaubenden Kurven zu feiern</strong> und gleichzeitig <strong>absoluten Komfort im Alltag</strong> zu bieten. Von figurformenden Bodies bis hin zu modellierenden Kleidern – jedes Stück <strong>passt sich allen Körpertypen an</strong>, um Ihre natürliche Silhouette zu unterstreichen.</p>
<p>Unsere Linie kombiniert <strong>gezielte Kompressionstechnologien</strong> und <strong>atmungsaktive nahtlose Stoffe</strong> für einen sofortigen glättenden Effekt. Ob Sie eine <strong>leichte Kontrolle für den Alltag</strong> oder eine <strong>feste Kompression für besondere Anlässe</strong> benötigen, Secret Shapes bietet Körperformungs-Lösungen, die <strong>Ihre Taille modellieren, den Bauch straffen und Ihre Kurven anheben</strong>, ohne Ihre Bewegungsfreiheit einzuschränken.</p>
<p><strong>Schneller Versand</strong> und <strong>zertifizierte Qualität</strong>: Entdecken Sie formende Wäsche, die Ihre Silhouette transformiert und Ihr natürliches Selbstvertrauen offenbart.</p>
</div> |
|
| | el | | Struct | | currentseouri | | | description | | string | <div class="brand-description">
<h2>Secret Shapes by Diva's Boudoir: Η Επανάσταση των Διαμορφωτικών Εσωρούχων Μεγάλα Μεγέθη</h2>
<h3>Μια Ολοκληρωμένη Συλλογή για Όλους τους Τύπους Σώματος</h3>
<p><strong>Secret Shapes by Diva's Boudoir</strong> επανεφευρίσκει τα διαμορφωτικά εσώρουχα προσφέροντας μια συλλογή αποκλειστικά σχεδιασμένη για να <strong>φέρει τις καμπύλες σας στο προσκήνιο</strong>. Κάθε κομμάτι της σειράς μας συνδυάζει <strong>προηγμένη τεχνολογία διαμόρφωσης σώματος</strong> και <strong>αισθησιακό σχεδιασμό</strong> για να σας προσφέρει μια καθορισμένη και εκλεπτυσμένη σιλουέτα, από το πρωί μέχρι το βράδυ.</p>
<p>Η φιλοσοφία μας; <strong>Να εξομαλύνουμε μικρές ατέλειες</strong> ενώ γιορτάζουμε την φυσική σας ομορφιά. Με τα Secret Shapes, λαμβάνετε <strong>λύσεις διαμόρφωσης προσαρμοσμένες σε κάθε περίσταση</strong>: κορμάκια χωρίς ραφές για ένα αόρατο αποτέλεσμα κάτω από τα ρούχα σας, φορέματα διαμόρφωσης για τις βραδινές σας εξόδους, σλιπ διαμόρφωσης για καθημερινή χρήση και μετεγχειρητικά συμπιεστικά ενδύματα για βέλτιστη υποστήριξη.</p>
<h3>Πρωτοποριακές Τεχνολογίες για Ασυναγώνιστη Άνεση</h3>
<p>Τα προϊόντα Secret Shapes ενσωματώνουν <strong>υφασματικές καινοτομίες της τελευταίας γενιάς</strong>:</p>
<ul>
<li><strong>Στοχευμένη συμπίεση πολλαπλών ζωνών</strong>: έλεγχος μέσης και κοιλιάς, υποστήριξη στήθους, ανύψωση οπίσθιων</li>
<li><strong>Υπερ-αναπνέοντα υφάσματα χωρίς ραφές</strong>: απαλά υλικά που αγκαλιάζουν τη σιλουέτα σας χωρίς υπερβολική σήμανση ή συμπίεση</li>
<li><strong>Συστήματα ρυθμιζόμενων γάντζων και κλεισιμάτων</strong>: για εξατομικευμένη υποστήριξη σύμφωνα με τις ανάγκες σας</li>
<li><strong>Πιστοποιημένα υποαλλεργικά υλικά</strong>: νάιλον, σπαντέξ και λάτεξ premium ποιότητας για σεβασμό στο δέρμα</li>
<li><strong>Εργονομικός σχεδιασμός</strong>: ανοιχτή πλάτη, ενσωματωμένα καπ, σημείο πίεσης στο βρακί για μέγιστη άνεση</li>
</ul>
<h3>Λύσεις Διαμόρφωσης για Κάθε Ανάγκη</h3>
<p><strong>Κορμάκια και Συνδυασμοί Διαμόρφωσης</strong>: Τα κορμάκια μας χωρίς ραφές προσφέρουν <strong>άμεσο λειαντικό αποτέλεσμα από το στήθος μέχρι τους μηρούς</strong>. Διαθέσιμα με ή χωρίς ενσωματωμένα καπ, <strong>διαμορφώνουν τη σιλουέτα σας</strong> παραμένοντας αόρατα κάτω από τα ρούχα σας. Μοντέλα με ανοιχτό ή με σημείο πίεσης βρακί διευκολύνουν τις καθημερινές σας κινήσεις.</p>
<p><strong>Φορέματα Διαμόρφωσης</strong>: Τέλεια για τις εκδηλώσεις σας, τα φορέματα διαμόρφωσης συνδυάζουν <strong>κομψότητα και αποτέλεσμα διαμόρφωσης</strong>. Το ελαστικό ύφασμα αγκαλιάζει τις καμπύλες σας <strong>λεπταίνοντας τη μέση και εξομαλύνοντας τους γοφούς</strong>, δημιουργώντας μια αρμονική σιλουέτα κάτω από οποιοδήποτε ρούχο.</p>
<p><strong>Σλιπ και Σορτς Διαμόρφωσης</strong>: Από ελαφρύ έλεγχο έως σταθερή υποστήριξη, τα σλιπ διαμόρφωσης <strong>ισιώνουν την κοιλιά και ανασηκώνουν τα οπίσθια</strong> με διακριτικότητα. Μοντέλα μέχρι τη μέση του μηρού προλαμβάνουν το τρίψιμο ενώ <strong>διαμορφώνουν τους μηρούς</strong>.</p>
<p><strong>Στηθόδεσμοι Διαμόρφωσης</strong>: Οι στηθόδεσμοι μας χωρίς μπανέλα με ρυθμιζόμενες τιράντες παρέχουν <strong>βέλτιστη υποστήριξη στήθους</strong> ενώ <strong>λειαίνουν την πλάτη και εξαφανίζουν τα παχάκια</strong>. Τέλειοι κάτω από τα στενά ή ντεκολτέ τοπ σας.</p>
<p><strong>Αθλητικά Διαμορφωτικά Ενδύματα</strong>: Ολόσωμες φόρμες και κολάν που διαμορφώνουν για τις προπονήσεις ή τις συνεδρίες σάουνας. Το τεχνικό ύφασμα <strong>προωθεί την εφίδρωση</strong> ενώ <strong>υποστηρίζει τη σιλουέτα σας</strong> κατά την προσπάθεια.</p>
<p><strong>Μετεγχειρητική Εσωρουχοποιία</strong>: Η σειρά μας fajas προσφέρει <strong>ιατρική μετεγχειρητική υποστήριξη</strong> με σταθερή συμπίεση και πλήρη κάλυψη, για βέλτιστη ανάρρωση μετά τις αισθητικές σας επεμβάσεις.</p>
<h3>Γιατί να Επιλέξετε το Secret Shapes by Diva's Boudoir;</h3>
<ul>
<li><strong>Ειδικοί στα Διαμορφωτικά Εσώρουχα</strong>: Πάνω από 15 χρόνια εμπειρίας σε λύσεις διαμόρφωσης σώματος</li>
<li><strong>Πιστοποιημένη Ποιότητα</strong>: Προϊόντα δοκιμασμένα και πιστοποιημένα (CE, ROHS, ISO) για την ασφάλειά σας</li>
<li><strong>Μόνιμο Απόθεμα</strong>: Πάνω από 400.000 κομμάτια διαθέσιμα κάθε μήνα</li>
<li><strong>Γρήγορη Αποστολή σε 48 Ώρες</strong>: Οι παραγγελίες σας επεξεργάζονται και αποστέλλονται σε 48 ώρες</li>
<li><strong>Πλήρης Σειρά</strong>: Από ελαφρύ έλεγχο έως σταθερή υποστήριξη, για κάθε περίσταση</li>
<li><strong>Αόρατος Σχεδιασμός</strong>: Εσώρουχα χωρίς ραφές που παραμένουν διακριτικά κάτω από τα ρούχα σας</li>
<li><strong>Άνεση Όλη Μέρα</strong>: Αναπνέοντα υλικά που <strong>προσαρμόζονται στις κινήσεις σας</strong></li>
</ul>
<h3>Η Τέχνη της Φυσικής Διαμόρφωσης της Σιλουέτας σας</h3>
<p>Το Secret Shapes by Diva's Boudoir δεν απλώς <strong>εξομαλύνει ατέλειες</strong>: τα διαμορφωτικά μας εσώρουχα <strong>αποκαλύπτουν την φυσική σας αυτοπεποίθηση</strong>. Κάθε κομμάτι είναι σχεδιασμένο έτσι ώστε να νιώθετε <strong>σέξυ, δυνατή και άνετα</strong> στο δέρμα σας, ανεξάρτητα από την περίσταση.</p>
<p>Οι πελάτισσές μας εκτιμούν ιδιαίτερα:</p>
<ul>
<li>Το <strong>άμεσο αποτέλεσμα διαμόρφωσης</strong> χωρίς δυσφορία</li>
<li>Την <strong>πολυλ </strong></li>
</ul>
</div> |
| | metas | | Struct | | description | | | keywords | | | title | |
| | name | | string | Secret Shapes by Diva's Boudoir |
| | seotitle | | | seouri | | | subtitle | | | summary | | string | <div class="brand-intro">
<h2>Secret Shapes by Diva's Boudoir: Διαμορφωτικά Εσώρουχα Μεγάλα Μεγέθη</h2>
<p><strong>Secret Shapes by Diva's Boudoir</strong> επαναπροσδιορίζει τα διαμορφωτικά εσώρουχα με μια ολοκληρωμένη συλλογή, ειδικά σχεδιασμένη για να <strong>γιορτάζει τις εκπληκτικές σας καμπύλες</strong> προσφέροντας <strong>απόλυτη άνεση στην καθημερινότητα</strong>. Από κορμάκια που διαμορφώνουν έως φορέματα που προσαρμόζουν, κάθε κομμάτι <strong>προσαρμόζεται σε όλους τους τύπους σώματος</strong> για να αναδείξει τη φυσική σας σιλουέτα.</p>
<p>Η σειρά μας συνδυάζει <strong>στοχευμένες τεχνολογίες συμπίεσης</strong> και <strong>αναπνέοντα υφάσματα χωρίς ραφές</strong> για άμεσο λειαντικό αποτέλεσμα. Είτε χρειάζεστε <strong>ελαφριά υποστήριξη για καθημερινή χρήση</strong> ή <strong>σταθερή συμπίεση για ειδικές περιστάσεις</strong>, τα Secret Shapes προσφέρουν λύσεις διαμόρφωσης σώματος που <strong>γλύφουν τη μέση, ισιώνουν την κοιλιά και ανασηκώνουν τις καμπύλες σας</strong> χωρίς να περιορίζουν την ελευθερία κίνησής σας.</p>
<p><strong>Γρήγορη αποστολή</strong> και <strong>πιστοποιημένη ποιότητα</strong>: Ανακαλύψτε διαμορφωτικά εσώρουχα που μεταμορφώνουν τη σιλουέτα σας αποκαλύπτοντας την φυσική σας αυτοπεποίθηση.</p>
</div> |
|
| | en | | Struct | | currentseouri | | | description | | string | <div class="brand-description">
<h2>Secret Shapes by Diva's Boudoir: The Revolution of Plus Size Shapewear Lingerie</h2>
<h3>A Complete Collection for Every Body Type</h3>
<p><strong>Secret Shapes by Diva's Boudoir</strong> reinvents shapewear by offering a collection exclusively designed to <strong>put your curves in the spotlight</strong>. Each piece in our line combines <strong>advanced body-sculpting technology</strong> and <strong>sensual design</strong> to provide you with a streamlined and refined silhouette, from morning to night.</p>
<p>Our philosophy? <strong>Smooth out small imperfections</strong> while celebrating your natural beauty. With Secret Shapes, you get <strong>shapewear solutions tailored to every occasion</strong>: seamless bodysuits for an invisible effect under your clothes, contouring dresses for your evenings, shaping briefs for daily wear, and post-surgical compression garments for optimal support.</p>
<h3>Cutting-Edge Technologies for Unparalleled Comfort</h3>
<p>Secret Shapes products integrate <strong>textile innovations of the latest generation</strong>:</p>
<ul>
<li><strong>Targeted multi-zone compression</strong>: control of waist and abdomen, breast support, buttocks lifting</li>
<li><strong>Ultra-breathable seamless fabrics</strong>: soft materials that hug your silhouette without excessive marking or compression</li>
<li><strong>Adjustable hook and closure systems</strong>: for personalized support according to your needs</li>
<li><strong>Certified hypoallergenic materials</strong>: premium quality nylon, spandex, and latex for skin respect</li>
<li><strong>Ergonomic design</strong>: open back, integrated cups, pressure-point crotch for optimal comfort</li>
</ul>
<h3>Shapewear Solutions for Every Need</h3>
<p><strong>Shapewear Bodysuits and Combinations</strong>: Our seamless bodysuits offer an <strong>instant smoothing effect from chest to thighs</strong>. Available with or without integrated cups, they <strong>sculpt your silhouette</strong> while remaining invisible under your outfits. Models with open or pressure-point crotch facilitate your daily movements.</p>
<p><strong>Contouring Dresses</strong>: Perfect for your events, our shapewear dresses combine <strong>elegance and sculpting effect</strong>. The stretch fabric embraces your curves while <strong>refining the waist and smoothing the hips</strong>, creating a harmonious silhouette under any outfit.</p>
<p><strong>Shaping Briefs and Shorts</strong>: From light control to firm support, our shaping briefs <strong>flatten the tummy and lift the buttocks</strong> with discretion. Mid-thigh models prevent chafing while <strong>sculpting the thighs</strong>.</p>
<p><strong>Shaping Bras</strong>: Our wire-free bras with adjustable straps provide <strong>optimal breast support</strong> while <strong>smoothing the back and eliminating love handles</strong>. Perfect under your fitted tops or low-cut necklines.</p>
<p><strong>Sports Shapewear</strong>: Sculpting jumpsuits and leggings for your workout or sauna sessions. The technical fabric <strong>promotes perspiration</strong> while <strong>supporting your silhouette</strong> during effort.</p>
<p><strong>Post-Surgical Lingerie</strong>: Our fajas range offers <strong>medical post-surgical support</strong> with firm compression and full coverage, for optimal recovery after your aesthetic procedures.</p>
<h3>Why Choose Secret Shapes by Diva's Boudoir?</h3>
<ul>
<li><strong>Shapewear Specialist</strong>: Over 15 years of expertise in body-shaping solutions</li>
<li><strong>Certified Quality</strong>: Tested and certified products (CE, ROHS, ISO) for your safety</li>
<li><strong>Permanent Stock</strong>: Over 400,000 pieces available each month</li>
<li><strong>Fast 48-Hour Shipping</strong>: Your orders processed and shipped within 48 hours</li>
<li><strong>Complete Range</strong>: From light control to firm support, for all occasions</li>
<li><strong>Invisible Design</strong>: Seamless lingerie that remains discreet under your clothing</li>
<li><strong>All-Day Comfort</strong>: Breathable materials that <strong>adapt to your movements</strong></li>
</ul>
<h3>The Art of Naturally Sculpting Your Silhouette</h3>
<p>Secret Shapes by Diva's Boudoir doesn't just <strong>smooth out imperfections</strong>: our shapewear <strong>reveals your natural confidence</strong>. Each piece is designed so you feel <strong>sexy, powerful, and comfortable</strong> in your skin, regardless of the occasion.</p>
<p>Our customers particularly appreciate:</p>
<ul>
<li>The <strong>immediate sculpting effect</strong> without discomfort</li>
<li>The <strong>versatility of the pieces</strong>: wearable alone or under your clothing</li>
<li>The <strong>durability of materials</strong>: lingerie that maintains its elasticity wash after wash</li>
<li>The <strong>sensual design</strong>: lace, leopard prints, trendy colors (mocha mousse, nude, black)</li>
<li>The <strong>personalization options</strong>: adjustable straps, multiple hooks, compression levels</li>
</ul>
<h3>Usage and Care Instructions</h3>
<p><strong>For optimal effect</strong>, choose your compression level according to the occasion: light control for daily wear, medium compression for events, firm support for special occasions. Wear your shapewear directly on the skin for maximum smoothing effect.</p>
<p><strong>Care</strong>: Wash your Secret Shapes pieces by hand or in the machine (delicate cycle) in cold water. Avoid the dryer and prefer flat drying to preserve fiber elasticity. Use a mild detergent without bleaching agents.</p>
<h3>Secret Shapes: Your Daily Confidence Ally</h3>
<p>Whether you're preparing a special event, seeking post-surgical support, or simply wanting to <strong>refine your silhouette daily</strong>, Secret Shapes by Diva's Boudoir offers shapewear solutions that <strong>adapt to your life</strong>. Our commitment? Making you feel <strong>irresistible and confident</strong>, every day.</p>
<p>Discover our complete collection now and find the shapewear that <strong>reveals the best version of yourself</strong>.</p>
</div> |
| | metas | | Struct | | description | | | keywords | | | title | |
| | name | | string | Secret Shapes by Diva's Boudoir |
| | seotitle | | | seouri | | | subtitle | | | summary | | string | <div class="brand-intro">
<h2>Secret Shapes by Diva's Boudoir: Plus Size Shapewear Lingerie</h2>
<p><strong>Secret Shapes by Diva's Boudoir</strong> revolutionizes shapewear with a complete collection specially designed to <strong>celebrate your gorgeous curves</strong> while delivering <strong>absolute everyday comfort</strong>. From sculpting bodysuits to contouring dresses, each piece <strong>adapts to every body type</strong> to enhance your natural silhouette.</p>
<p>Our range combines <strong>targeted compression technologies</strong> and <strong>breathable seamless fabrics</strong> for an instant smoothing effect. Whether you need <strong>light control for daily wear</strong> or <strong>firm compression for special occasions</strong>, Secret Shapes offers body-shaping solutions that <strong>sculpt your waist, flatten your tummy, and lift your curves</strong> without compromising your freedom of movement.</p>
<p><strong>Fast shipping</strong> and <strong>certified quality</strong>: Discover shapewear that transforms your silhouette by revealing your natural confidence.</p>
</div> |
|
| | es | | Struct | | currentseouri | | | description | | string | <div class="brand-description">
<h2>Secret Shapes by Diva's Boudoir: La Revolución de la Ropa Moldeadora para Tallas Grandes</h2>
<h3>Una Colección Completa para Todos los Tipos de Cuerpo</h3>
<p><strong>Secret Shapes by Diva's Boudoir</strong> reinventa la ropa moldeadora ofreciendo una colección diseñada exclusivamente para <strong>poner tus curvas en el centro de atención</strong>. Cada prenda de nuestra línea combina <strong>tecnología avanzada de esculpido corporal</strong> y <strong>diseño sensual</strong> para proporcionarte una silueta definida y refinada, desde la mañana hasta la noche.</p>
<p>Nuestra filosofía? <strong>Suavizar pequeñas imperfecciones</strong> mientras celebramos tu belleza natural. Con Secret Shapes, obtienes <strong>soluciones de moldeo corporal adaptadas a cada ocasión</strong>: bodys sin costuras para un efecto invisible bajo tu ropa, vestidos moldeadores para tus veladas, braguitas modeladoras para uso diario, y prendas de compresión post-quirúrgicas para un soporte óptimo.</p>
<h3>Tecnologías de Vanguardia para un Confort Incomparable</h3>
<p>Los productos Secret Shapes integran <strong>innovaciones textiles de última generación</strong>:</p>
<ul>
<li><strong>Compresión multi-zona dirigida</strong>: control de cintura y abdomen, soporte de busto, elevación de glúteos</li>
<li><strong>Tejidos ultra-transpirables sin costuras</strong>: materiales suaves que abrazan tu silueta sin marcar o comprimir excesivamente</li>
<li><strong>Sistemas de ganchos y cierres ajustables</strong>: para soporte personalizado según tus necesidades</li>
<li><strong>Materiales hipoalergénicos certificados</strong>: nylon, spandex y látex de calidad premium para el respeto de la piel</li>
<li><strong>Diseño ergonómico</strong>: espalda abierta, copas integradas, entrepierna con punto de presión para máximo confort</li>
</ul>
<h3>Soluciones de Moldeo Corporal para Cada Necesidad</h3>
<p><strong>Bodys y Combinaciones Moldeadoras</strong>: Nuestros bodys sin costuras ofrecen un <strong>efecto alisador instantáneo desde el pecho hasta los muslos</strong>. Disponibles con o sin copas integradas, <strong>esculpen tu silueta</strong> mientras permanecen invisibles bajo tus atuendos. Modelos con entrepierna abierta o con punto de presión facilitan tus movimientos diarios.</p>
<p><strong>Vestidos Moldeadores</strong>: Perfectos para tus eventos, nuestros vestidos de ropa moldeadora combinan <strong>elegancia y efecto esculpidor</strong>. El tejido elástico abraza tus curvas mientras <strong>afina la cintura y suaviza las caderas</strong>, creando una silueta armoniosa bajo cualquier outfit.</p>
<p><strong>Braguitas y Shorts Moldeadores</strong>: Desde control ligero hasta soporte firme, nuestras braguitas moldeadoras <strong>aplanan el abdomen y levantan los glúteos</strong> con discreción. Modelos hasta medio muslo previenen rozaduras mientras <strong>esculpen los muslos</strong>.</p>
<p><strong>Sujetadores Moldeadores</strong>: Nuestros sujetadores sin aro con tirantes ajustables proporcionan <strong>soporte óptimo del busto</strong> mientras <strong>alisan la espalda y eliminan los michelines</strong>. Perfectos bajo tus tops ajustados o escotes.</p>
<p><strong>Ropa Deportiva Moldeadora</strong>: Monos y leggings que esculpen para tus sesiones de entrenamiento o sauna. El tejido técnico <strong>promueve la transpiración</strong> mientras <strong>sostiene tu silueta</strong> durante el esfuerzo.</p>
<p><strong>Lencería Post-Quirúrgica</strong>: Nuestra línea de fajas ofrece <strong>soporte médico post-quirúrgico</strong> con compresión firme y cobertura completa, para una recuperación óptima después de tus procedimientos estéticos.</p>
<h3>¿Por qué Elegir Secret Shapes by Diva's Boudoir?</h3>
<ul>
<li><strong>Especialistas en Ropa Moldeadora</strong>: Más de 15 años de experiencia en soluciones de esculpido corporal</li>
<li><strong>Calidad Certificada</strong>: Productos probados y certificados (CE, ROHS, ISO) para tu seguridad</li>
<li><strong>Stock Permanente</strong>: Más de 400.000 piezas disponibles cada mes</li>
<li><strong>Envío Rápido en 48 Horas</strong>: Tus pedidos procesados y enviados en 48 horas</li>
<li><strong>Gama Completa</strong>: Desde control ligero hasta soporte firme, para todas las ocasiones</li>
<li><strong>Diseño Invisible</strong>: Lencería sin costuras que permanece discreta bajo tu ropa</li>
<li><strong>Comodidad Todo el Día</strong>: Materiales transpirables que <strong>se adaptan a tus movimientos</strong></li>
</ul>
<h3>El Arte de Esculpir tu Silueta Naturalmente</h3>
<p>Secret Shapes by Diva's Boudoir no solo <strong>suaviza imperfecciones</strong>: nuestra ropa moldeadora <strong>revela tu confianza natural</strong>. Cada prenda está diseñada para que te sientas <strong>sexy, poderosa y cómoda</strong> en tu piel, sin importar la ocasión.</p>
<p>Nuestras clientas aprecian especialmente:</p>
<ul>
<li>El <strong>efecto de esculpido inmediato</strong> sin incomodidad</li>
<li>La <strong>versatilidad de las prendas</strong>: utilizables solas o bajo tu ropa</li>
<li>La <strong>durabilidad de los materiales</strong>: lencería que mantiene su elasticidad lavado tras lavado</li>
<li>El <strong>diseño sensual</strong>: encaje, estampados de leopardo, colores de tendencia (mousse de chocolate, nude, negro)</li>
<li>Las <strong>opciones de personalización</strong>: tirantes ajustables, múltiples ganchos, niveles de compresión</li>
</ul>
<h3>Instrucciones de Uso y Cuidado</h3>
<p><strong>Para un efecto óptimo</strong>, elige tu nivel de compresión según la ocasión: control ligero para uso diario, compresión media para eventos, soporte firme para ocasiones especiales. Usa tu ropa moldeadora directamente sobre la piel para un efecto alisador máximo.</p>
<p><strong>Cuidado</strong>: Lava tus prendas Secret Shapes a mano o en máquina (ciclo delicado) con agua fría. Evita la secadora y prefiere el secado horizontal para preservar la elasticidad de las fibras. Usa un detergente suave sin agentes blanqueadores.</p>
<h3>Secret Shapes: Tu Aliado de Confianza Diario</h3>
<p>Ya sea que estés preparando un evento especial, buscando soporte post-quirúrgico o simplemente queriendo <strong>refinar tu silueta diariamente</strong>, Secret Shapes by Diva's Boudoir ofrece soluciones de ropa moldeadora que <strong>se adaptan a tu vida</strong>. Nuestro compromiso: hacerte sentir <strong>irresistible y segura</strong>, cada día.</p>
<p>Descubre ahora nuestra colección completa y encuentra la ropa moldeadora que <strong>revela la mejor versión de ti misma</strong>.</p>
</div> |
| | metas | | Struct | | description | | | keywords | | | title | |
| | name | | string | Secret Shapes by Diva's Boudoir |
| | seotitle | | | seouri | | | subtitle | | | summary | | string | <div class="brand-intro">
<h2>Secret Shapes by Diva's Boudoir: Ropa Moldeadora para Tallas Grandes</h2>
<p><strong>Secret Shapes by Diva's Boudoir</strong> revoluciona la ropa moldeadora con una colección completa diseñada especialmente para <strong>celebrar tus curvas espectaculares</strong> mientras ofrece <strong>comodidad absoluta en el día a día</strong>. Desde bodys que esculpen hasta vestidos que moldean, cada prenda <strong>se adapta a todos los tipos de cuerpo</strong> para realzar tu silueta natural.</p>
<p>Nuestra línea combina <strong>tecnologías de compresión dirigida</strong> y <strong>tejidos sin costuras transpirables</strong> para un efecto alisador instantáneo. Ya sea que necesites <strong>control ligero para uso diario</strong> o <strong>compresión firme para ocasiones especiales</strong>, Secret Shapes ofrece soluciones de moldeo corporal que <strong>esculpen tu cintura, aplanan el abdomen y levantan tus curvas</strong> sin comprometer tu libertad de movimiento.</p>
<p><strong>Envío rápido</strong> y <strong>calidad certificada</strong>: Descubre ropa moldeadora que transforma tu silueta revelando tu confianza natural.</p>
</div> |
|
| | fr | | Struct | | currentseouri | | | description | | string | <div class="brand-description">
<h2>Secret Shapes by Diva's Boudoir : La Révolution de la Lingerie Gainante Grande Taille</h2>
<h3>Une Collection Complète pour Toutes les Morphologies</h3>
<p><strong>Secret Shapes by Diva's Boudoir</strong> réinvente la lingerie gainante en proposant une gamme pensée exclusivement pour <strong>mettre vos courbes à l'honneur</strong>. Chaque pièce de notre collection combine <strong>technologie de sculptage avancée</strong> et <strong>design sensuel</strong> pour vous offrir une silhouette lissée et sublimée, du matin au soir.</p>
<p>Notre philosophie ? <strong>Gommer les petites imperfections</strong> tout en célébrant votre beauté naturelle. Avec Secret Shapes, vous bénéficiez de <strong>solutions gainantes adaptées à toutes les occasions</strong> : bodys sans couture pour un effet invisible sous vos vêtements, robes gainantes pour vos soirées, culottes sculptantes pour le quotidien, et combinaisons post-opératoires pour un soutien optimal.</p>
<h3>Technologies de Pointe pour un Confort Inégalé</h3>
<p>Les produits Secret Shapes intègrent des <strong>innovations textiles de dernière génération</strong> :</p>
<ul>
<li><strong>Compression ciblée multi-zones</strong> : contrôle de la taille et du ventre, soutien de la poitrine, rehaussement des fesses</li>
<li><strong>Tissus sans couture ultra-respirants</strong> : matières douces qui épousent votre silhouette sans marquer ni comprimer excessivement</li>
<li><strong>Systèmes d'agrafes et fermetures ajustables</strong> : pour un maintien personnalisé selon vos besoins</li>
<li><strong>Matériaux hypoallergéniques certifiés</strong> : nylon, spandex et latex de qualité premium pour une peau respectée</li>
<li><strong>Design ergonomique</strong> : dos ouvert, bonnets intégrés, entrejambe à pression pour un confort optimal</li>
</ul>
<h3>Des Solutions Gainantes pour Chaque Besoin</h3>
<p><strong>Bodys et Combinaisons Sculptants</strong> : Nos bodys sans couture offrent un <strong>effet lissant instantané de la poitrine aux cuisses</strong>. Disponibles avec ou sans bonnets intégrés, ils <strong>sculptent la silhouette</strong> tout en restant invisibles sous vos tenues. Les modèles à entrejambe ouvert ou avec pression facilitent vos déplacements quotidiens.</p>
<p><strong>Robes Gainantes</strong> : Parfaites pour vos événements, nos robes gainantes combinent <strong>élégance et effet sculptant</strong>. Le tissu stretch épouse vos formes en <strong>affinant la taille et en lissant les hanches</strong>, pour une silhouette harmonieuse sous n'importe quelle tenue.</p>
<p><strong>Culottes et Shorts Sculptants</strong> : Du contrôle léger au maintien ferme, nos culottes gainantes <strong>aplatissent le ventre et rehaussent les fesses</strong> avec discrétion. Les modèles mi-cuisse préviennent les frottements tout en <strong>sculptant les cuisses</strong>.</p>
<p><strong>Soutiens-gorge Gainants</strong> : Nos bras sans armatures avec bretelles ajustables offrent un <strong>soutien optimal de la poitrine</strong> tout en <strong>lissant le dos et les bourrelets</strong>. Parfaits sous vos hauts moulants ou décolletés.</p>
<p><strong>Vêtements de Sport Gainants</strong> : Jumpsuits et leggings sculptants pour vos séances de sport ou sauna. Le tissu technique <strong>favorise la transpiration</strong> tout en <strong>maintenant votre silhouette</strong> pendant l'effort.</p>
<p><strong>Lingerie Post-Opératoire</strong> : Notre gamme fajas offre un <strong>soutien médical post-chirurgical</strong> avec compression ferme et couverture complète, pour une récupération optimale après vos interventions esthétiques.</p>
<h3>Pourquoi Choisir Secret Shapes by Diva's Boudoir ?</h3>
<ul>
<li><strong>Spécialiste de la lingerie gainante</strong> : Plus de 15 ans d'expertise dans le shapewear</li>
<li><strong>Qualité certifiée</strong> : Produits testés et certifiés (CE, ROHS, ISO) pour votre sécurité</li>
<li><strong>Stock permanent</strong> : Plus de 400 000 pièces disponibles chaque mois</li>
<li><strong>Expédition rapide en 48h</strong> : Vos commandes traitées et expédiées sous 48 heures</li>
<li><strong>Gamme complète</strong> : Du contrôle léger au maintien ferme, pour toutes les occasions</li>
<li><strong>Design invisible</strong> : Lingerie sans couture qui reste discrète sous vos vêtements</li>
<li><strong>Confort toute la journée</strong> : Matières respirantes qui <strong>s'adaptent à vos mouvements</strong></li>
</ul>
<h3>L'Art de Sculpter Votre Silhouette Naturellement</h3>
<p>Secret Shapes by Diva's Boudoir ne se contente pas de <strong>gommer les imperfections</strong> : notre lingerie gainante <strong>révèle votre confiance naturelle</strong>. Chaque pièce est conçue pour que vous vous sentiez <strong>sexy, puissante et à l'aise</strong> dans votre peau, quelle que soit l'occasion.</p>
<p>Nos clientes apprécient particulièrement :</p>
<ul>
<li>L'<strong>effet sculptant immédiat</strong> sans sensation d'inconfort</li>
<li>La <strong>polyvalence des pièces</strong> : portables seules ou sous vos vêtements</li>
<li>La <strong>durabilité des matériaux</strong> : lingerie qui conserve son élasticité lavage après lavage</li>
<li>Le <strong>design sensuel</strong> : dentelle, imprimés léopard, couleurs tendance (mocha mousse, nude, noir)</li>
<li>Les <strong>options de personnalisation</strong> : bretelles ajustables, agrafes multiples, niveaux de compression</li>
</ul>
<h3>Conseils d'Utilisation et d'Entretien</h3>
<p><strong>Pour un effet optimal</strong>, choisissez votre niveau de compression selon l'occasion : contrôle léger pour le quotidien, compression moyenne pour les événements,</p>
</div> |
| | metas | | Struct | | description | | | keywords | | | title | |
| | name | | string | Secret Shapes by Diva's Boudoir |
| | seotitle | | | seouri | | | subtitle | | | summary | | string | <div class="brand-intro">
<h2>Secret Shapes by Diva's Boudoir : Lingerie Gainante Grande Taille</h2>
<p><strong>Secret Shapes by Diva's Boudoir</strong> révolutionne la lingerie gainante avec une collection complète pensée pour <strong>sublimer vos courbes généreuses</strong> tout en offrant un <strong>confort absolu au quotidien</strong>. Des bodys sculptants aux robes gainantes, chaque pièce <strong>s'adapte à toutes les morphologies</strong> pour mettre en valeur votre silhouette naturelle.</p>
<p>Notre gamme combine <strong>technologies de compression ciblée</strong> et <strong>tissus respirants sans couture</strong> pour un effet lissant immédiat. Que vous recherchiez un <strong>contrôle léger pour le quotidien</strong> ou une <strong>compression ferme pour les occasions spéciales</strong>, Secret Shapes vous offre des solutions gainantes qui <strong>sculptent la taille, aplatissent le ventre et rehaussent les fesses</strong> sans compromettre votre liberté de mouvement.</p>
<p><strong>Expédition rapide</strong> et <strong>qualité certifiée</strong> : découvrez la lingerie gainante qui transforme votre silhouette en révélant votre confiance naturelle.</p>
</div> |
|
| | it | | Struct | | currentseouri | | | description | | string | <div class="brand-description">
<h2>Secret Shapes by Diva's Boudoir: La Rivoluzione dell'Intimo Modellante Taglie Comode</h2>
<h3>Una Collezione Completa per Tutti i Tipi di Corpo</h3>
<p><strong>Secret Shapes by Diva's Boudoir</strong> reinventa l'intimo modellante offrendo una collezione progettata esclusivamente per <strong>mettere in risalto le tue curve</strong>. Ogni capo della nostra linea combina <strong>tecnologia avanzata di modellazione corporea</strong> e <strong>design sensuale</strong> per offrirti una silhouette definita e raffinata, dal mattino alla sera.</p>
<p>La nostra filosofia? <strong>Levigare piccole imperfezioni</strong> mentre celebriamo la tua bellezza naturale. Con Secret Shapes, ottieni <strong>soluzioni di modellazione adatte a ogni occasione</strong>: body senza cuciture per un effetto invisibile sotto i tuoi vestiti, abiti modellanti per le tue serate, slip contenitivi per l'uso quotidiano e capi di compressione post-chirurgica per un supporto ottimale.</p>
<h3>Tecnologie all'Avanguardia per un Comfort Incomparabile</h3>
<p>I prodotti Secret Shapes integrano <strong>innovazioni tessili dell'ultima generazione</strong>:</p>
<ul>
<li><strong>Compressione multi-zona mirata</strong>: controllo di vita e addome, supporto del seno, sollevamento dei glutei</li>
<li><strong>Tessuti ultra-traspiranti senza cuciture</strong>: materiali morbidi che abbracciano la tua silhouette senza marcare o comprimere eccessivamente</li>
<li><strong>Sistemi di ganci e chiusure regolabili</strong>: per un supporto personalizzato secondo le tue esigenze</li>
<li><strong>Materiali ipoallergenici certificati</strong>: nylon, spandex e lattice di qualità premium per il rispetto della pelle</li>
<li><strong>Design ergonomico</strong>: schiena aperta, coppe integrate, punto di pressione nell'entrejambe per massimo comfort</li>
</ul>
<h3>Soluzioni di Modellazione per Ogni Esigenza</h3>
<p><strong>Body e Combinazioni Modellanti</strong>: I nostri body senza cuciture offrono un <strong>effetto levigante istantaneo dal seno alle cosce</strong>. Disponibili con o senza coppe integrate, <strong>scolpiscono la tua silhouette</strong> rimanendo invisibili sotto i tuoi outfit. Modelli con entrejambe aperta o con punto di pressione facilitano i tuoi movimenti quotidiani.</p>
<p><strong>Abiti Modellanti</strong>: Perfetti per i tuoi eventi, i nostri abiti di intimo modellante combinano <strong>eleganza ed effetto modellante</strong>. Il tessuto elastico abbraccia le tue curve <strong>assottigliando la vita e levigando i fianchi</strong>, creando una silhouette armoniosa sotto qualsiasi outfit.</p>
<p><strong>Slip e Pantaloncini Modellanti</strong>: Da controllo leggero a supporto deciso, i nostri slip modellanti <strong>appiattiscono l'addome e sollevano i glutei</strong> con discrezione. Modelli fino a metà coscia prevengono lo sfregamento mentre <strong>modellano le cosce</strong>.</p>
<p><strong>Reggiseni Modellanti</strong>: I nostri reggiseni senza ferretto con spalline regolabili offrono <strong>supporto ottimale del seno</strong> mentre <strong>levigano la schiena ed eliminano i rotolini</strong>. Perfetti sotto i tuoi top aderenti o scollati.</p>
<p><strong>Intimo Sportivo Modellante</strong>: Tute e leggings che modellano per le tue sessioni di allenamento o sauna. Il tessuto tecnico <strong>promuove la traspirazione</strong> mentre <strong>sostiene la tua silhouette</strong> durante lo sforzo.</p>
<p><strong>Lingerie Post-Chirurgica</strong>: La nostra linea di fajas offre <strong>supporto medico post-chirurgico</strong> con compressione decisa e copertura completa, per un recupero ottimale dopo i tuoi interventi estetici.</p>
<h3>Perché Scegliere Secret Shapes by Diva's Boudoir?</h3>
<ul>
<li><strong>Specialisti in Intimo Modellante</strong>: Oltre 15 anni di esperienza in soluzioni di modellazione corporea</li>
<li><strong>Qualità Certificata</strong>: Prodotti testati e certificati (CE, ROHS, ISO) per la tua sicurezza</li>
<li><strong>Scorte Permanenti</strong>: Oltre 400.000 pezzi disponibili ogni mese</li>
<li><strong>Spedizione Rapida in 48 Ore</strong>: I tuoi ordini elaborati e spediti in 48 ore</li>
<li><strong>Gamma Completa</strong>: Dal controllo leggero al supporto deciso, per ogni occasione</li>
<li><strong>Design Invisibile</strong>: Lingerie senza cuciture che rimane discreta sotto i tuoi vestiti</li>
<li><strong>Comfort Tutto il Giorno</strong>: Materiali traspiranti che <strong>si adattano ai tuoi movimenti</strong></li>
</ul>
<h3>L'Arte di Modellare la Tua Silhouette Naturalmente</h3>
<p>Secret Shapes by Diva's Boudoir non solo <strong>leviga imperfezioni</strong>: il nostro intimo modellante <strong>rivela la tua fiducia naturale</strong>. Ogni capo è progettato perché tu ti senta <strong>sexy, potente e a tuo agio</strong> nella tua pelle, indipendentemente dall'occasione.</p>
<p>Le nostre clienti apprezzano particolarmente:</p>
<ul>
<li>L'<strong>effetto modellante immediato</strong> senza disagio</li>
<li>La <strong>versatilità dei capi</strong>: utilizzabili da soli o sotto i vestiti</li>
<li>La <strong>durabilità dei materiali</strong>: lingerie che mantiene l'elasticità lavaggio dopo lavaggio</li>
<li>Il</li>
</ul>
</div> |
| | metas | | Struct | | description | | | keywords | | | title | |
| | name | | string | Secret Shapes by Diva's Boudoir |
| | seotitle | | | seouri | | | subtitle | | | summary | | string | <div class="brand-intro">
<h2>Secret Shapes by Diva's Boudoir: Intimo Modellante Taglie Comode</h2>
<p><strong>Secret Shapes by Diva's Boudoir</strong> rivoluziona l'intimo modellante con una collezione completa appositamente progettata per <strong>celebrare le tue curve spettacolari</strong> offrendo <strong>comfort assoluto nel quotidiano</strong>. Da body che modellano la silhouette a vestiti contenitivi, ogni capo <strong>si adatta a tutti i tipi di corpo</strong> per esaltare la tua silhouette naturale.</p>
<p>La nostra linea combina <strong>tecnologie di compressione mirata</strong> e <strong>tessuti senza cuciture traspiranti</strong> per un effetto levigante istantaneo. Che tu abbia bisogno di <strong>controllo leggero per l'uso quotidiano</strong> o di <strong>compressione decisa per occasioni speciali</strong>, Secret Shapes offre soluzioni di modellazione corporea che <strong>scolpiscono la vita, appiattiscono l'addome e sollevano le tue curve</strong> senza compromettere la libertà di movimento.</p>
<p><strong>Spedizione rapida</strong> e <strong>qualità certificata</strong>: Scopri l'intimo modellante che trasforma la tua silhouette rivelando la tua fiducia naturale.</p>
</div> |
|
| | nl | | Struct | | currentseouri | | | description | | string | <div class="brand-description">
<h2>Secret Shapes by Diva's Boudoir: De Revolutie van Corrigerende Lingerie Grote Maten</h2>
<h3>Een Complete Collectie voor Alle Lichaamstypes</h3>
<p><strong>Secret Shapes by Diva's Boudoir</strong> vindt corrigerende lingerie opnieuw uit door een assortiment aan te bieden dat exclusief is ontworpen om <strong>uw rondingen in de schijnwerpers te zetten</strong>. Elk stuk uit onze collectie combineert <strong>geavanceerde shapewear technologie</strong> en <strong>sensueel design</strong> om u een gestroomlijnd en verfijnd silhouet te bieden, van 's ochtends tot 's avonds.</p>
<p>Onze filosofie? <strong>Kleine onvolkomenheden wegwerken</strong> terwijl we uw natuurlijke schoonheid vieren. Met Secret Shapes profiteert u van <strong>shapewear oplossingen aangepast aan alle gelegenheden</strong>: naadloze body's voor een onzichtbaar effect onder uw kleding, corrigerende jurken voor uw avonden, shapewear slips voor dagelijks gebruik, en postoperatieve combinaties voor optimale ondersteuning.</p>
<h3>Geavanceerde Technologieën voor Ongeëvenaard Comfort</h3>
<p>Secret Shapes producten integreren <strong>textielinnovaties van de laatste generatie</strong>:</p>
<ul>
<li><strong>Gerichte multi-zone compressie</strong>: controle van taille en buik, ondersteuning van de borsten, lifting van de billen</li>
<li><strong>Ultra-ademende naadloze stoffen</strong>: zachte materialen die uw silhouet omhullen zonder overmatig te markeren of samen te drukken</li>
<li><strong>Verstelbare haaksystemen en sluitingen</strong>: voor gepersonaliseerde ondersteuning volgens uw behoeften</li>
<li><strong>Gecertificeerde hypoallergene materialen</strong>: premium kwaliteit nylon, spandex en latex voor een gerespecteerde huid</li>
<li><strong>Ergonomisch design</strong>: open rug, geïntegreerde cups, drukknoop kruis voor optimaal comfort</li>
</ul>
<h3>Shapewear Oplossingen voor Elke Behoefte</h3>
<p><strong>Shapewear Body's en Combinaties</strong>: Onze naadloze body's bieden een <strong>onmiddellijk gladmakend effect van borst tot dijen</strong>. Verkrijgbaar met of zonder geïntegreerde cups, ze <strong>vormen het silhouet</strong> terwijl ze onzichtbaar blijven onder uw outfits. Modellen met open of drukknoop kruis vergemakkelijken uw dagelijkse verplaatsingen.</p>
<p><strong>Corrigerende Jurken</strong>: Perfect voor uw evenementen, onze shapewear jurken combineren <strong>elegantie en vormgevend effect</strong>. De stretch stof omhult uw vormen terwijl <strong>de taille wordt verfijnd en de heupen worden gladgestreken</strong>, voor een harmonieus silhouet onder elke outfit.</p>
<p><strong>Shapewear Slips en Shorts</strong>: Van lichte controle tot stevige ondersteuning, onze corrigerende slips <strong>maken de buik plat en liften de billen</strong> met discretie. De mid-dij modellen voorkomen schuren terwijl ze <strong>de </strong></p>
</div> |
| | metas | | Struct | | description | | | keywords | | | title | |
| | name | | string | Secret Shapes by Diva's Boudoir |
| | seotitle | | | seouri | | | subtitle | | | summary | | string | <div class="brand-intro">
<h2>Secret Shapes by Diva's Boudoir: Plus Size Shapewear Lingerie</h2>
<p><strong>Secret Shapes by Diva's Boudoir</strong> revolutionizes shapewear with a complete collection specially designed to <strong>celebrate your gorgeous curves</strong> while delivering <strong>absolute everyday comfort</strong>. From sculpting bodysuits to contouring dresses, each piece <strong>adapts to every body type</strong> to enhance your natural silhouette.</p>
<p>Our range combines <strong>targeted compression technologies</strong> and <strong>breathable seamless fabrics</strong> for an instant smoothing effect. Whether you need <strong>light control for daily wear</strong> or <strong>firm compression for special occasions</strong>, Secret Shapes offers body-shaping solutions that <strong>sculpt your waist, flatten your tummy, and lift your curves</strong> without compromising your freedom of movement.</p>
<p><strong>Fast shipping</strong> and <strong>certified quality</strong>: Discover shapewear that transforms your silhouette by revealing your natural confidence.</p>
</div> |
|
| | pt | | Struct | | currentseouri | | | description | | string | <div class="brand-description">
<h2>Secret Shapes by Diva's Boudoir: A Revolução da Moda Modeladora Plus Size</h2>
<h3>Uma Coleção Completa para Todos os Tipos de Corpo</h3>
<p><strong>Secret Shapes by Diva's Boudoir</strong> reinventa a moda modeladora oferecendo uma coleção projetada exclusivamente para <strong>colocar suas curvas em destaque</strong>. Cada peça da nossa linha combina <strong>tecnologia avançada de modelagem corporal</strong> e <strong>design sensual</strong> para proporcionar uma silhueta definida e refinada, da manhã à noite.</p>
<p>Nossa filosofia? <strong>Suavizar pequenas imperfeições</strong> enquanto celebramos sua beleza natural. Com Secret Shapes, você obtém <strong>soluções de modelagem adaptadas a cada ocasião</strong>: bodys sem costura para um efeito invisível sob suas roupas, vestidos modeladores para suas noites, calcinhas modeladoras para uso diário e peças de compressão pós-cirúrgica para suporte ideal.</p>
<h3>Tecnologias de Ponta para um Conforto Incomparável</h3>
<p>Os produtos Secret Shapes integram <strong>inovações têxteis de última geração</strong>:</p>
<ul>
<li><strong>Compressão multi-zona direcionada</strong>: controle de cintura e abdômen, suporte dos seios, elevação dos glúteos</li>
<li><strong>Tecidos ultra-respiráveis sem costura</strong>: materiais macios que abraçam sua silhueta sem marcar ou comprimir excessivamente</li>
<li><strong>Sistemas de fechos e ganchos ajustáveis</strong>: para suporte personalizado de acordo com suas necessidades</li>
<li><strong>Materiais hipoalergênicos certificados</strong>: nylon, spandex e látex de qualidade premium para respeito à pele</li>
<li><strong>Design ergonômico</strong>: costas abertas, copas integradas, entrepernas com ponto de pressão para máximo conforto</li>
</ul>
<h3>Soluções de Modelagem para Cada Necessidade</h3>
<p><strong>Bodys e Combinações Modeladoras</strong>: Nossos bodys sem costura oferecem um <strong>efeito suavizante instantâneo do peito às coxas</strong>. Disponíveis com ou sem copas integradas, <strong>esculpem sua silhueta</strong> permanecendo invisíveis sob seus looks. Modelos com entrepernas aberta ou com ponto de pressão facilitam seus movimentos diários.</p>
<p><strong>Vestidos Modeladores</strong>: Perfeitos para seus eventos, nossos vestidos de moda modeladora combinam <strong>elegância e efeito esculpidor</strong>. O tecido elástico abraça suas curvas <strong>afinando a cintura e suavizando os quadris</strong>, criando uma silhueta harm</p>
</div> |
| | metas | | Struct | | description | | | keywords | | | title | |
| | name | | string | Secret Shapes by Diva's Boudoir |
| | seotitle | | | seouri | | | subtitle | | | summary | | string | <div class="brand-intro">
<h2>Secret Shapes by Diva's Boudoir: Moda Modeladora Plus Size</h2>
<p><strong>Secret Shapes by Diva's Boudoir</strong> revoluciona a moda modeladora com uma coleção completa especialmente projetada para <strong>celebrar suas curvas deslumbrantes</strong> enquanto oferece <strong>conforto absoluto no dia a dia</strong>. De bodys que esculpem a silhueta até vestidos modeladores, cada peça <strong>se adapta a todos os tipos de corpo</strong> para realçar sua silhueta natural.</p>
<p>Nossa linha combina <strong>tecnologias de compressão direcionada</strong> e <strong>tecidos sem costura respiráveis</strong> para um efeito suavizante instantâneo. Seja para <strong>controle leve para uso diário</strong> ou <strong>compressão firme para ocasiões especiais</strong>, Secret Shapes oferece soluções de modelagem corporal que <strong>esculpem sua cintura, afinem o abdômen e elevem suas curvas</strong> sem comprometer sua liberdade de movimento.</p>
<p><strong>Envio rápido</strong> e <strong>qualidade certificada</strong>: Descubra moda modeladora que transforma sua silhueta revelando sua confiança natural.</p>
</div> |
|
|
|
| brandname | |
| breasts | |
| careinstructions | |
| categories | | string | divasboudoir.lingerie.essentials.shapewear |
|
| category | |
| categorygender | |
| categorymediadatas | | Struct | | adult | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/categories/divasboudoir/lingerie/essentials/shapewear.jpg |
| | type | | | width | |
| | divasboudoir | | Struct | | plus | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
| | small | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
| | standard | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
|
| | fetishboudoir | | Struct | | plus | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
| | small | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
| | standard | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
|
| | latexboudoir | | Struct | | plus | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
| | small | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
| | standard | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
|
| | legsboudoir | | Struct | | plus | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
| | small | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
| | standard | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
|
| | lustboudoir | | Struct | | plus | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
| | small | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
| | standard | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
|
| | private | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/categories/divasboudoir/private/default.jpg |
| | type | | | width | |
| | smboudoir | | Struct | | plus | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
| | small | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
| | standard | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
|
|
|
| categorysizerange | |
| colorinfos | Query
Template: /system/api/product/colors.cfc:13
Execution Time: 0.698 ms
Record Count: 1
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_colors.color as recorduid, product_colors.type, product_colors.code, product_colors.color, product_colors.range, product_colors.hexvalue,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock
from product_colors
left outer join product_variations on product_colors.color = product_variations.color and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
where FIND_IN_SET(product_colors.color,'black') > 0
and product_variations.productuid = '36E04CC6-DB40-49B2-AE4F210A36314451'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
| | recorduid | type | code | color | range | hexvalue | available | stock | | 1 | black | color | blak | black | black | #000000 | -1 | 0 |
|
| colorrange | |
| colors | |
| colortype | |
| comments | |
| compositions | Struct
Entries: 13 | | coton | | | elastane | | | free | | | leather | | | lycra | | | metal | | | nylon | | | polyamide | | | polyester | | | polyurethane | | | silk | | | spandex | | | viscose | |
|
| datecreated | | Date Time (Europe/Paris) | | {ts '2021-04-29 11:14:31'} |
|
| defect | |
| dimensions | Struct
Entries: 14 | | acrylicbones | | | backsideheight | | | diameter | | | flatsteelbones | | | frontsideheight | | | fullheight | | | length | | | modestysize | | | panels | | | sides | | | spiralsteelbones | | | totallength | | | unit | | | wiresize | |
|
| display | |
| displayfrom | |
| displayto | |
| grossweight | |
| hasbrandinfos | |
| hascareinstructions | |
| hascolorinfos | |
| hascompositions | |
| hasdescription | |
| hasdimensions | |
| hasmaterials | |
| hasotherspecifications | |
| haspromo | |
| hasshortdescription | |
| hassizeinfos | |
| hasspecifications | |
| hasstockinfos | |
| hasstylingtips | |
| hasusageinstructions | |
| hasvariations | |
| import | |
| inpromo | |
| instockvariations | |
| isactive | |
| iscustommade | |
| isdivasize | |
| isfirstprice | |
| isfixedprice | |
| ishot | |
| isnew | |
| isonline | |
| isoutletprice | |
| itemprice | |
| itempromo | |
| key | | string | what-waist-corrective-bodysuit |
|
| language | |
| lastupdated | | Date Time (Europe/Paris) | | {ts '2025-10-11 19:09:35'} |
|
| linkedactions | Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.682 ms
Record Count: 0
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select cart_actions.*
from cart_actions
where cart_actions.branding IN ('all','divasboudoir')
and cart_actions.language IN ('all','fr')
and (cart_actions.quotas = -1 or (cart_actions.usedCount < cart_actions.quotas))
and cart_actions.isactive = 1
and (date(cart_actions.activeFrom) <= '2025-11-24' OR cart_actions.activeFrom is null)
and (date(cart_actions.activeTo) >= '2025-11-24' OR cart_actions.activeTo is null)
and (
FIND_IN_SET('36e04cc6-db40-49b2-ae4f210a36314451',lcase(cart_actions.linkedproducts)) > 0 and cart_actions.linkedproducts is not null
)
| | id_action | branding | language | name | code | type | minimumOrder | maximumOrder | minimumItems | maximumItems | maximumUse | allowedItems | quotas | usedCount | linkedproducts | linkedthemes | linkedbrands | linkeditem | params | activeFrom | activeTo | isActive |
|
| linkedproducts | Query
Template: /system/api/products.cfc:1305
Execution Time: 1.35 ms
Record Count: 0
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select products.productuid as productuid, products.reference, 'default' as type, products.key, products.language, products.name,
product_links.linkuid,
products.colors, products.vatrate, products.metadatas, products.dimensions,
products.mediadatas, products.tags, products.themes, products.isdivasize,
count(distinct product_variations.variationuid) as totalvariations,
group_concat(distinct product_variations.variationuid) as variationlist,
count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END) as inpromo,
if(count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END)>0,1,0) as haspromo,
(select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0) END)) as itempromo,
IFNULL(min(product_variations.itemprice),0) as itemprice,
(select IF (products.isfixedprice = 0 and sum(product_variations.itempromo) > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null), IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0), IFNULL(min(NULLIF(product_variations.itemprice, 0)), 0) )) as unitprice,
count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.itempromo ELSE product_variations.itemprice END) as prices,
(select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN min(NULLIF(product_variations.promountil, 0)) END)) as promountil,
products.isfixedprice, products.ishot, products.isnew, if(products.orderidx > 0, products.orderidx, 999999999) as orderidx,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
count(distinct CASE WHEN ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) > 0 OR ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) <= 0 AND product_variations.supplier = 0)) THEN product_variations.variationuid END) as instockvariations,
products.brand, brands.name as brandname, IFNULL(brands.ispublic, 0) as showbrand, brands.display,
product_categories.sizetype,GROUP_CONCAT(DISTINCT product_sizes.suppliersize) as intlsize,products.sizes,product_sizes.sizerange,product_categories.mediadatas as categorymediadatas, product_categories.sizerange as categorysizerange,
product_categorymap.section, product_categorymap.category, product_categorymap.key as subcategory
from products
left outer join product_categorymap on products.productuid = product_categorymap.productuid
left outer join product_categories on (product_categories.branding = product_categorymap.branding and product_categories.section = product_categorymap.section and product_categories.category = product_categorymap.category and product_categories.key = product_categorymap.key)
left outer join product_sizes on product_sizes.id_size IN (products.sizes)
left outer join brands on products.brand = brands.brand
left outer join product_variations on product_variations.productuid = products.productuid and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
left outer join product_links on product_links.reference = products.reference
where products.isactive = 1 and products.isdeleted = 0
and brands.isactive = 1 and brands.isdeleted = 0
and product_categories.isactive = 1 and product_categories.isdeleted = 0
and product_variations.isactive = 1
and FIND_IN_SET('divasboudoir',products.branding)
and product_categories.branding IN ('all','divasboudoir')
and product_categorymap.branding IN ('all','divasboudoir')
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and products.language in ('all','fr')
and product_categories.language in ('all','fr')
and (products.displayFrom <= DATE(NOW()) or products.displayFrom is null)
and (products.displayTo >= DATE(NOW()) or products.displayTo IS null)
and product_links.linkuid = '' and product_links.linkuid is not null and product_links.linkuid <> ''
and products.reference <> 'ESSH4486'
group by products.reference
order by products.ishot desc, products.isnew desc, orderidx asc, products.lastupdated desc
| | productuid | reference | type | key | language | name | linkuid | colors | vatrate | metadatas | dimensions | mediadatas | tags | themes | isdivasize | totalvariations | variationlist | inpromo | haspromo | itempromo | itemprice | unitprice | prices | promountil | isfixedprice | ishot | isnew | orderidx | available | stock | instockvariations | brand | brandname | showbrand | display | sizetype | intlsize | sizes | sizerange | categorymediadatas | categorysizerange | section | category | subcategory |
|
| linkuid | |
| materials | |
| mediadatas | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/bdbr/essh4486/image_5.jpg |
| | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/bdbr/essh4486/image_6.jpg |
| | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/bdbr/essh4486/image_4.jpg |
| | type | | | width | |
| | variations | | Struct | | colors | | Struct | | black | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/bdbr/essh4486/image_5.jpg |
| | type | | | width | |
|
|
| | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
|
| mediagallery | |
| metadatas | | Struct | | darkboudoir | | Struct | | de | Struct
Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | el | Struct
Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | en | Struct
Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | es | Struct
Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | fr | Struct
Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | it | Struct
Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | nl | Struct
Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | pt | Struct
Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
|
| | divasboudoir | | Struct | | de | Struct
Entries: 15 | | abstract | | | careinstructions | | | description | | string | Dieser schwarze Shapewear-Body besteht aus weichem, elastischem Material, das dank seiner revolutionären Webtechnik den Bauch einfängt, die Taille formt, den Po anhebt und die Brust formt.<br /><br />Seine besondere Stärke:<br />Er zeichnet sich nicht an den Hüften ab und schneidet nicht in die Oberschenkel ein.<br />Er macht die Taille schlanker und lässt den Bauch und die Schürze unauffällig erscheinen.<br /><br />Im Schritt mit Klammern zu öffnen.<br /><br />Atmungsaktiv und antibakteriell. |
| | guid | | string | https://dev.divasboudoir.com/de/der-schwarze-figurformende-body-in-ubergrosse,-der-die-brust-halt-schwarz/essh4486.htm |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Ein figurformender schwarzer Body in Übergröße, der Ihre Rundungen mit Eleganz und Komfort zähmen wird. |
| | keywords | | | title | | string | Der schwarze figurformende Body in Übergröße, der die Brust hält |
|
| | seotitle | | string | Der schwarze figurformende Body in Übergröße, der die Brust hält |
| | seouri | | string | der-schwarze-figurformende-body-in-ubergrosse,-der-die-brust-halt-schwarz |
| | specifications | | | stylingtips | | | summary | | string | Ein figurformender schwarzer Body in Übergröße, der Ihre Rundungen mit Eleganz und Komfort zähmen wird. |
| | title | | string | Der schwarze figurformende Body, der die Brust zusammenhält |
| | usageinstructions | |
| | el | Struct
Entries: 15 | | abstract | | | careinstructions | | | description | | string | Αυτό το μαύρο κορμάκι γλυπτικής είναι κατασκευασμένο από μαλακό ελαστικό ύφασμα, αλλά χάρη στην επαναστατική τεχνική ύφανσης, συγκρατεί την κοιλιά, σμιλεύει τη μέση, ανασηκώνει τους γλουτούς και στηρίζει το μπούστο.<br /><br />Το δυνατό του σημείο:<br />Δεν σημαδεύει τους γοφούς ούτε κάνει κοψίματα στο πάνω μέρος των μηρών.<br />Λεπταίνει τη μέση και κάνει διακριτική την κοιλιά και την ποδιά.<br /><br />Ανοίγει με κούμπωμα στον καβάλο.<br /><br />Αναπνέει και είναι αντιβακτηριδιακή. |
| | guid | | string | https://dev.divasboudoir.com/el/o-mayros-glypthras-swmatos-plus-size-poy-yposthrizei-to-mpoysto-mayro/essh4486.htm |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Ένα γλυπτικό μαύρο plus-size κορμάκι που θα τιθασεύσει τις καμπύλες σας με κομψότητα και άνεση. |
| | keywords | | | title | | string | Ο μαύρος γλυπτήρας σώματος plus size που υποστηρίζει το μπούστο |
|
| | seotitle | | string | Ο μαύρος γλυπτήρας σώματος plus size που υποστηρίζει το μπούστο |
| | seouri | | string | o-mayros-glypthras-swmatos-plus-size-poy-yposthrizei-to-mpoysto-mayro |
| | specifications | | | stylingtips | | | summary | | string | Ένα γλυπτικό μαύρο plus-size κορμάκι που θα τιθασεύσει τις καμπύλες σας με κομψότητα και άνεση. |
| | title | | string | Το μαύρο κορμάκι γλυπτικής που στηρίζει το μπούστο |
| | usageinstructions | |
| | en | Struct
Entries: 15 | | abstract | | | careinstructions | | | description | | string | This black sculpting bodysuit is made of soft elastic fabric, but thanks to its revolutionary weaving technique, contains the tummy, sculpts the waist, lifts the buttocks and maintains the bust.<br /><br />Its strong point:<br />It doesn't mark the hips or cut into the upper thighs.<br />It refines the waist and makes the stomach and "apron" discreet.<br /><br />Clasp opening at crotch.<br /><br />Breathable and antibacterial. |
| | guid | | string | https://dev.divasboudoir.com/en/the-plus-size-black-sculpting-bodysuit-that-supports-the-bust-black/essh4486.htm |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | A sculpting black plus size bodysuit that will tame your curves with elegance and comfort. |
| | keywords | | | title | | string | The plus size black sculpting bodysuit that supports the bust |
|
| | seotitle | | string | The plus size black sculpting bodysuit that supports the bust |
| | seouri | | string | the-plus-size-black-sculpting-bodysuit-that-supports-the-bust-black |
| | specifications | | | stylingtips | | | summary | | string | A sculpting black plus size bodysuit that will tame your curves with elegance and comfort. |
| | title | | string | The black sculpting bodysuit that supports the bust |
| | usageinstructions | |
| | es | Struct
Entries: 15 | | abstract | | | careinstructions | | | description | | string | Este body escultor negro está confeccionado en suave tejido elástico, pero gracias a su revolucionaria técnica de tejido, contiene el vientre, esculpe la cintura, levanta los glúteos y sujeta el busto.<br /><br />Su punto fuerte:<br />No marca las caderas ni hace cortes en la parte superior de los muslos.<br />Afina la cintura y hace que el vientre y el delantal sean discretos.<br /><br />Abertura con corchetes en la entrepierna.<br /><br />Transpirable y antibacteriano. |
| | guid | | string | https://dev.divasboudoir.com/es/el-escultor-corporal-negro-de-talla-grande-que-sostiene-el-busto-negro/essh4486.htm |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Un escultural body negro de talla grande que domará tus curvas con elegancia y comodidad. |
| | keywords | | | title | | string | El escultor corporal negro de talla grande que sostiene el busto |
|
| | seotitle | | string | El escultor corporal negro de talla grande que sostiene el busto |
| | seouri | | string | el-escultor-corporal-negro-de-talla-grande-que-sostiene-el-busto-negro |
| | specifications | | | stylingtips | | | summary | | string | Un escultural body negro de talla grande que domará tus curvas con elegancia y comodidad. |
| | title | | string | El body negro que sujeta el busto |
| | usageinstructions | |
| | fr | Struct
Entries: 15 | | abstract | | | careinstructions | | | description | | string | <p>Ce body sculptant noir est en tissu élastique tout doux, mais qui, grâce à sa technique révolutionnaire de tissage, contient le ventre, sculpte la taille, remonte les fesses et mantient la poitrine.<br><br>Son point fort: <br>Il ne marque pas le hanches et ne fait pas de coupures en haut des cuisses.<br>Il affine la taille et rend l'estomac et le "tablier" discret. <br><br>Ouverture par agraffes à l'entrejambe.<br><br>Respirable et antibactérien.</p> |
| | guid | | string | https://dev.divasboudoir.com/fr/body-sculptant-grande-taille-noir-qui-maintient-la-poitrine-noir/essh4486.htm |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Un body grande taille noir sculptant qui saura dompter vos rondeurs avec élégance et confort. |
| | keywords | | | title | | string | Le grande taille body sculptant noir qui maintient la poitrine |
|
| | seotitle | | string | Body sculptant grande taille noir qui maintient la poitrine |
| | seouri | | string | body-sculptant-grande-taille-noir-qui-maintient-la-poitrine-noir |
| | specifications | | | stylingtips | | | summary | | string | <p>Un body grande taille noir sculptant qui saura dompter vos rondeurs avec élégance et confort.</p> |
| | title | | string | Le body sculptant noir qui maintient la poitrine |
| | usageinstructions | |
| | it | Struct
Entries: 15 | | abstract | | | careinstructions | | | description | | string | Questo body nero modellante è realizzato in morbido tessuto elastico, ma grazie alla sua rivoluzionaria tecnica di tessitura, contiene la pancia, scolpisce la vita, solleva i glutei e sostiene il seno.<br /><br />Il suo punto di forza:<br />Non segna i fianchi e non fa tagli nella parte superiore delle cosce.<br />Snellisce la vita e rende discreta la pancia e il grembiule.<br /><br />Apertura a fibbia sul cavallo.<br /><br />Traspirante e antibatterico. |
| | guid | | string | https://dev.divasboudoir.com/it/il-body-sculptor-nero-taglia-grande-che-sostiene-il-busto-nero/essh4486.htm |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Un body nero scolpente di taglia grande che doma le vostre curve con eleganza e comfort. |
| | keywords | | | title | | string | Il body sculptor nero taglia grande che sostiene il busto |
|
| | seotitle | | string | Il body sculptor nero taglia grande che sostiene il busto |
| | seouri | | string | il-body-sculptor-nero-taglia-grande-che-sostiene-il-busto-nero |
| | specifications | | | stylingtips | | | summary | | string | Un body nero scolpente di taglia grande che doma le vostre curve con eleganza e comfort. |
| | title | | string | Il body modellante nero che sostiene il busto |
| | usageinstructions | |
| | nl | Struct
Entries: 15 | | abstract | | | careinstructions | | | description | | string | Deze zwarte sculpting bodysuit is gemaakt van zachte elastische stof, maar dankzij de revolutionaire weeftechniek omsluit het de buik, vormt het de taille, lift het de billen en ondersteunt het de buste.<br /><br />Zijn sterke punt:<br />Het tekent de heupen niet af en maakt geen insnijdingen aan de bovenkant van de dijen.<br />Het maakt de taille slanker en maakt de buik en het schort discreet.<br /><br />Opening met gesp in kruis.<br /><br />Ademend en antibacterieel. |
| | guid | | string | https://dev.divasboudoir.com/nl/de-groote-maat-zwarte-body-sculptor-die-de-buste-ondersteunt-zwart/essh4486.htm |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Een modellerende zwarte body van groote maten die je rondingen elegant en comfortabel zal temmen. |
| | keywords | | | title | | string | De groote maat zwarte body sculptor die de buste ondersteunt |
|
| | seotitle | | string | De groote maat zwarte body sculptor die de buste ondersteunt |
| | seouri | | string | de-groote-maat-zwarte-body-sculptor-die-de-buste-ondersteunt-zwart |
| | specifications | | | stylingtips | | | summary | | string | Een modellerende zwarte body van groote maten die je rondingen elegant en comfortabel zal temmen. |
| | title | | string | De zwarte modelleerbody die de buste ondersteunt |
| | usageinstructions | |
| | pt | Struct
Entries: 15 | | abstract | | | careinstructions | | | description | | string | Este body preto esculpido é feito de tecido elástico macio, mas graças à sua técnica de tecelagem revolucionária, contém a barriga, esculpe a cintura, levanta as nádegas e sustenta o busto.<br /><br />O seu ponto forte:<br />Não marca as ancas nem faz cortes na parte superior das coxas.<br />Emagrece a cintura e torna a barriga e o avental discretos.<br /><br />Abertura com fecho na virilha.<br /><br />Respirável e antibacteriano. |
| | guid | | string | https://dev.divasboudoir.com/pt/o-esculpidor-de-corpo-preto-plus-size-que-sustenta-o-busto-preto/essh4486.htm |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Um body preto esculpido de tamanho grande que irá domar as suas curvas com elegância e conforto. |
| | keywords | | | title | | string | O esculpidor de corpo preto plus size que sustenta o busto |
|
| | seotitle | | string | O esculpidor de corpo preto plus size que sustenta o busto |
| | seouri | | string | o-esculpidor-de-corpo-preto-plus-size-que-sustenta-o-busto-preto |
| | specifications | | | stylingtips | | | summary | | string | Um body preto esculpido de tamanho grande que irá domar as suas curvas com elegância e conforto. |
| | title | | string | O body preto esculpido que sustenta o busto |
| | usageinstructions | |
|
| | fetishboudoir | | Struct | | de | Struct
Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | el | Struct
Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | en | Struct
Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | es | Struct
Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | fr | Struct
Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | it | Struct
Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | nl | Struct
Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | pt | Struct
Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
|
| | latexboudoir | | Struct | | de | Struct
Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | el | Struct
Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | en | Struct
Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | es | Struct
Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | fr | Struct
Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | it | Struct
Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | nl | Struct
Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | pt | Struct
Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
|
| | legsboudoir | | Struct | | de | Struct
Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | el | Struct
Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | en | Struct
Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | es | Struct
Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | fr | Struct
Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | it | Struct
Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | nl | Struct
Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | pt | Struct
Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
|
| | lustboudoir | | Struct | | de | Struct
Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | el | Struct
Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | en | Struct
Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | es | Struct
Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | fr | Struct
Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | it | Struct
Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | nl | Struct
Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | pt | Struct
Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
|
| | smboudoir | | Struct | | de | Struct
Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | el | Struct
Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | en | Struct
Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | es | Struct
Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | fr | Struct
Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | it | Struct
Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | nl | Struct
Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | pt | Struct
Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
|
|
|
| name | | string | What Waist Corrective Bodysuit |
|
| netweight | |
| nextshipment | |
| ordered | |
| orderidx | |
| origin | |
| originalsize | |
| packaging | |
| productshipment | |
| productuid | | string | 36E04CC6-DB40-49B2-AE4F210A36314451 |
|
| promountil | |
| rating | |
| recorduid | | string | 36E04CC6-DB40-49B2-AE4F210A36314451 |
|
| reference | |
| related | |
| reserved | |
| returned | |
| returnsallowed | |
| section | |
| shipment | |
| showbrand | |
| sizeinfos | Query
Template: /system/api/product/sizes.cfc:20
Execution Time: 1.33 ms
Record Count: 4
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,'2174,2168,2169,2170') > 0
and product_variations.productuid = '36E04CC6-DB40-49B2-AE4F210A36314451'
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 | 2169 | XL/2XL+ | intlsize | black | XL/2XL+ | XL/2XL+ | -1 | 999999 | 0 | w | plus | lingerie | XL/XXL | XL/2XL+ | | 44-46 | 14-16 | 18-20 | 46-48 | 46-48 | 44-46 | 50-52 | 46-48 | 44-46 | 110-118 | 98-108 | 116-126 | | | | | | | | 2 | 2174 | M/L | intlsize | black | M/L | M/L | -1 | 999999 | 0 | w | plus | lingerie | M/L | M/L | | 38-40 | 8-10 | 10-12 | 40-42 | 40-42 | 38-40 | 44-46 | 40-42 | 38-40 | 90-96 | 80-88 | 100-106 | | | | | | | | 3 | 2168 | XL/2XL | intlsize | black | XL/2XL | XL/2XL | -1 | 999999 | 0 | w | plus | lingerie | XL/XXL | XL/2XL | | 42-44 | 10-12 | 14-16 | 44-46 | 44-46 | 42-44 | 48-50 | 44-46 | 42-44 | 96-110 | 88-98 | 106-116 | | | | | | | | 4 | 2170 | 3XL/4XL | intlsize | black | 3XL/4XL | 3XL/4XL | -1 | 999999 | 0 | w | plus | lingerie | 3XL/4XL | 3XL/4XL | | 48-50 | 18-20 | 22-24 | 50-52 | 50-52 | 48-50 | 54-56 | 50-52 | 48-50 | 118-126 | 108-116 | 126-136 | | | | | | |
|
| sizeranges | |
| sizes | | string | 2174,2168,2169,2170 |
|
| sizetype | |
| specifications | Struct
Entries: 23 | | belly | | | bones | | | bra | | | breasts | | | bust | | | closing | | | crochtless | | | cups | | | cut | | | garter | | | halter | | | lacing | | | lining | | | modestypanel | | | panty | | | sheathing | | | sleeves | | | stocking | | | straps | | | stretch | | | suspenders | | | transparency | | | underwires | |
|
| stock | |
| stocks | Query
Template: /system/api/product/stocks.cfc:25
Execution Time: 5.37 ms
Record Count: 3
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select * from (
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '36E04CC6-DB40-49B2-AE4F210A36314451'
and product_variations.isactive = 1
and product_sizes.id_size = 2174
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 = '36E04CC6-DB40-49B2-AE4F210A36314451'
and product_variations.isactive = 1
and product_sizes.id_size = 2168
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 = '36E04CC6-DB40-49B2-AE4F210A36314451'
and product_variations.isactive = 1
and product_sizes.id_size = 2169
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 = '36E04CC6-DB40-49B2-AE4F210A36314451'
and product_variations.isactive = 1
and product_sizes.id_size = 2170
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 | 36E04CC6-DB40-49B2-AE4F210A36314451 | A0C380A9-0E66-46D0-83FBEED8B1F9ACF4 | 2174 | black | #000000 | M/L | M/L | | 38-40 | 8-10 | 10-12 | 40-42 | 40-42 | 38-40 | 44-46 | 40-42 | 38-40 | w | lingerie | | M/L | intlsize | 33.2917 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | | | -1 | 0 | all | | | 2 | 36E04CC6-DB40-49B2-AE4F210A36314451 | 9CD04799-FC5B-4B87-A2246E847FBAAA99 | 2168 | black | #000000 | XL/XXL | XL/2XL | | 42-44 | 10-12 | 14-16 | 44-46 | 44-46 | 42-44 | 48-50 | 44-46 | 42-44 | w | lingerie | | XL/2XL | intlsize | 33.2917 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | | | -1 | 0 | all | | | 3 | 36E04CC6-DB40-49B2-AE4F210A36314451 | 7F65D197-D2D8-4CB9-98740782FE2B27FB | 2170 | black | #000000 | 3XL/4XL | 3XL/4XL | | 48-50 | 18-20 | 22-24 | 50-52 | 50-52 | 48-50 | 54-56 | 50-52 | 48-50 | w | lingerie | | 3XL/4XL | intlsize | 33.2917 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | | | -1 | 0 | all | |
|
| subcategory | |
| supplier | |
| supplierreference | |
| tags | |
| themes | |
| totalvariations | |
| type | |
| unitprice | |
| usageinstructions | |
| variations | Query
Template: /system/api/product/variations.cfc:171
Execution Time: 7.41 ms
Record Count: 4
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 = '36E04CC6-DB40-49B2-AE4F210A36314451' 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 = '36E04CC6-DB40-49B2-AE4F210A36314451' 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 = '36E04CC6-DB40-49B2-AE4F210A36314451' 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 = '36E04CC6-DB40-49B2-AE4F210A36314451' 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 = '36E04CC6-DB40-49B2-AE4F210A36314451' 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 = '36E04CC6-DB40-49B2-AE4F210A36314451' 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 = '36E04CC6-DB40-49B2-AE4F210A36314451'
and product_variations.isactive = 1
and product_sizes.id_size = 2174
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 = '36E04CC6-DB40-49B2-AE4F210A36314451' 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 = '36E04CC6-DB40-49B2-AE4F210A36314451' 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 = '36E04CC6-DB40-49B2-AE4F210A36314451' 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 = '36E04CC6-DB40-49B2-AE4F210A36314451' 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 = '36E04CC6-DB40-49B2-AE4F210A36314451' 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 = '36E04CC6-DB40-49B2-AE4F210A36314451' 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 = '36E04CC6-DB40-49B2-AE4F210A36314451'
and product_variations.isactive = 1
and product_sizes.id_size = 2168
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 = '36E04CC6-DB40-49B2-AE4F210A36314451' 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 = '36E04CC6-DB40-49B2-AE4F210A36314451' 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 = '36E04CC6-DB40-49B2-AE4F210A36314451' 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 = '36E04CC6-DB40-49B2-AE4F210A36314451' 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 = '36E04CC6-DB40-49B2-AE4F210A36314451' 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 = '36E04CC6-DB40-49B2-AE4F210A36314451' 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 = '36E04CC6-DB40-49B2-AE4F210A36314451'
and product_variations.isactive = 1
and product_sizes.id_size = 2169
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 = '36E04CC6-DB40-49B2-AE4F210A36314451' 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 = '36E04CC6-DB40-49B2-AE4F210A36314451' 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 = '36E04CC6-DB40-49B2-AE4F210A36314451' 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 = '36E04CC6-DB40-49B2-AE4F210A36314451' 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 = '36E04CC6-DB40-49B2-AE4F210A36314451' 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 = '36E04CC6-DB40-49B2-AE4F210A36314451' 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 = '36E04CC6-DB40-49B2-AE4F210A36314451'
and product_variations.isactive = 1
and product_sizes.id_size = 2170
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 | 9CD04799-FC5B-4B87-A2246E847FBAAA99 | 2169 | black | #000000 | XL/XXL | XL/2XL+ | | 44-46 | 14-16 | 18-20 | 46-48 | 46-48 | 44-46 | 50-52 | 46-48 | 44-46 | w | lingerie | | XL/2XL+ | intlsize | 33.2917 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | | | -1 | 0 | -1 | 0 | -1 | 0 | 0 | 33.2917 | all | | | 2 | A0C380A9-0E66-46D0-83FBEED8B1F9ACF4 | 2174 | black | #000000 | M/L | M/L | | 38-40 | 8-10 | 10-12 | 40-42 | 40-42 | 38-40 | 44-46 | 40-42 | 38-40 | w | lingerie | | M/L | intlsize | 33.2917 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | | | -1 | 0 | -1 | 0 | -1 | 0 | 0 | 33.2917 | all | | | 3 | 9CD04799-FC5B-4B87-A2246E847FBAAA99 | 2168 | black | #000000 | XL/XXL | XL/2XL | | 42-44 | 10-12 | 14-16 | 44-46 | 44-46 | 42-44 | 48-50 | 44-46 | 42-44 | w | lingerie | | XL/2XL | intlsize | 33.2917 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | | | -1 | 0 | -1 | 0 | -1 | 0 | 0 | 33.2917 | all | | | 4 | 7F65D197-D2D8-4CB9-98740782FE2B27FB | 2170 | black | #000000 | 3XL/4XL | 3XL/4XL | | 48-50 | 18-20 | 22-24 | 50-52 | 50-52 | 48-50 | 54-56 | 50-52 | 48-50 | w | lingerie | | 3XL/4XL | intlsize | 33.2917 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | | | -1 | 0 | -1 | 0 | -1 | 0 | 0 | 33.2917 | all | |
|
| vatrate | |
| warehouse | |
Nederlands
English
Español
Português
Italiano
Deutsch
Ελληνικά
