Maten bekijken

Bijou G-string: provocatie en sensuele kristallen

Dubbelklikken om te vergroten

SKU: SBGA4825

Bijou G-string: provocatie en sensuele kristallen

Nieuw

Voorraad:

Ontdek de ultra sexy juwelenstring die van elk moment een uitnodiging tot verleiding maakt.

delicaat borduurwerk, kettingen van kristallen en kleine glittertjes voor een string die niemand onverschillig laat.

Sterke punten

Kettingen versierd met ultra-provocerendekristallen
Delicaat borduurwerk bovenaan het schaambeen
Kleine fonkelingen die het licht vangen
Verstelbare string voor optimaal comfort
Drie kleuren: zwart, rood, wit
Minimalistisch maar sexyontwerp

Maat:

Weet je niet zeker welke maat je moet kiezen? Raadpleeg onze maattabel

Kleur:

Hoeveelheid:

16.95 €

Goed advies

via chat, facebook of e-mail

Gratis retourneren

binnen 15 dagen *

Grote maat juwelenstring met kettingen en kristallen

Name: Grote maat juwelenstring met kettingen en kristallen - -1
Brand: Diva's Boudoir
SKU: SBGA4825
Price: 16.95 EUR
Availability: InStock

Productomschrijving

De juwelenstring barst van de sensualiteit, de kristallen kettingen dansen met elke beweging. Het delicate borduursel op de bovenkant van het schaambeen onthult een subtiele provocatie, terwijl de kleine glittertjes elke blik in een uitnodiging veranderen.

Een string die je lichaam niet alleen aankleedt, maar het sublimeert met rauwe, zelfverzekerde sensualiteit.

Elk detail is ontworpen om een moment van pure verleiding te creëren: glijdende kettingen, fonkelende kristallen, een ontwerp dat durf schreeuwt.

Technische details

Materiaal: Kant en kristallen kettingen
Kleuren: Zwart, Rood, Wit
Stijl : Ultra sexy juwelen string
Details : Kettingen, kristallen, borduursel
Pasvorm : Verstelbare bandjes

Beschikbaar maten

Beschikbaar van L tot 3XL

Beschikbare kleuren

Zwart , Rood en Wit

Maattabel

Controleer de juiste maat voor jou

Internationale	Heupen
L	102-107
XL	107-112
2XL	112-117
3XL	117-123

Onderhoudstips

Zacht met de hand wassen
Warm water (maximaal 30°C)
Mild wasmiddel
Plat drogen
Kettingen voorzichtig behandelen

Gebruikstips

Deze juwelenstring is gemaakt voor die momenten waarop je je sensualiteit wilt laten exploderen. De kristallen kettingen creëren een hypnotiserende beweging die niemand sprakeloos zal laten.

Stijltips

Durf je helemaal uit te sloven! Maak je look compleet met onze sexy jurkjes of negligés voor onbeperkte verleiding.

To Top

Uw locatie is:
Verenigde Staten van Amerika

Je taal is: Nederlands

Prijzen zijn in: EUR (€)

Mijn voorkeuren opslaan

Verder

Mijn instellingen wijzigen

Land Taal

Mijn voorkeuren opslaan

Annuleren

Struct
Entries: 108

actions

Array

available

number

-1

brand

string

parishollywood

brandcode

string

puun

branding

string

divasboudoir,legsboudoir

brandmedias

string

{"default":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"editorial":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"logo":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""}}

brandmetas

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

brandname

string

Paris Hollywood

breasts

string

careinstructions

string

category

subcategory

linkuid

string

materials

string

mediadatas

Struct

alt

Struct

height

string

1723

isprivate

string

rating

string

all

src

string

/photobank/products/puun/sbga4825/string_grande_taille_bijou_blanc.jpg

type

string

img

width

string

1186

back

Struct

height

string

1989

isprivate

string

rating

string

all

src

string

/photobank/products/puun/sbga4825/string_grande_taille_bijou.jpg

type

string

img

width

string

1456

default

Struct

height

string

1897

isprivate

string

rating

string

all

src

string

/photobank/products/puun/sbga4825/string_grande_taille_bijoub_blanc.jpg

type

string

img

width

string

1312

variations

Struct

colors

Struct

black

Struct

height

string

1989

isprivate

string

rating

string

all

src

string

/photobank/products/puun/sbga4825/string_grande_taille_bijou.jpg

type

string

img

width

string

1456

red

Struct

height

string

1976

isprivate

string

rating

string

all

src

string

/photobank/products/puun/sbga4825/string_grande_taille_bijou_rouge.jpg

type

string

img

width

string

1456

white

Struct

height

string

1897

isprivate

string

rating

string

all

src

string

/photobank/products/puun/sbga4825/string_grande_taille_bijoub_blanc.jpg

type

string

img

width

string

1312

video

Struct

embedsrc

string

height

string

isprivate

string

rating

string

src

string

thumb

Struct

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

high

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

maxres

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

medium

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

standard

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

type

string

width

string

mediagallery

string

metadatas

Struct

darkboudoir

Struct

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-schwarz-rot-ou-weiss

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-mayro-kokkino-ou-leyko

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-black-red-ou-white

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-negro-rojo-ou-blanco

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-noir-rouge-ou-blanc

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-nero-rosso-ou-bianco

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-zwart-rood-ou-wit

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-preto-vermelho-ou-branco

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

divasboudoir

Struct

Struct
Entries: 15

abstract

string

careinstructions

string

<ul> <li>Feinwäsche mit der Hand</li> <li>Lauwarmes Wasser (maximal 30°C)</li> <li>Feinwaschmittel</li> <li>Flach trocknen</li> <li>Vorsichtig mit den Kettchen umgehen</li> </ul>

description

string

Der Juwelen-String explodiert vor Sinnlichkeit mit seinen Kristallketten, die bei jeder Ihrer Bewegungen tanzen. Seine zarten Stickereien auf dem oberen Schambereich offenbaren eine subtile Provokation, während die kleinen Brillanten jeden Blick in eine Einladung verwandeln. Ein String, der Ihren Körper nicht nur kleidet, sondern ihn mit einer rohen, selbstbewussten Sinnlichkeit sublimiert. Jedes Detail wurde durchdacht, um einen Moment purer Verführung zu schaffen: die gleitenden Ketten, die funkelnden Kristalle, ein Design, das Ihre Kühnheit schreit.

guid

string

https://dev.divasboudoir.com/de/string-grosse-grosse-joyas-verstellbar-schwarz-rot-ou-weiss/sbga4825.htm

highlights

string

<ul> <li>Ultraprovokante, mit Kristallen verzierte Ketten</li> <li>Zarte Stickereien auf dem oberen Schambereich</li> <li>Kleine Glitzersteine, die das Licht fangen</li> <li>Verstellbarer String für optimalen Tragekomfort</li> <li>Drei Farben: Schwarz, Rot, Weiß</li> <li>Minimalistisches Design, aber furchtbar sexy</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Großer Schmuckstring mit Kristallkettchen. Zarte Stickereien in drei Farben. Ultra sexy, provokant. Schnelle Lieferung. Diva's Boudoir.

keywords

string

title

string

Sexy Schmuckstring Große Größe | Diva's Boudoir

seotitle

string

String große Größe Juwel mit Ketten und Kristallen

seouri

string

string-grosse-grosse-joyas-verstellbar-schwarz-rot-ou-weiss

specifications

string

<ul> <li>Material: Spitze und Kristallketten</li> <li>Farben: Schwarz, Rot, Weiß</li> <li>Stil: Ultra-sexy Juwelen-String</li> <li>Details: Ketten, Kristalle, Stickereien</li> <li>Passform: Verstellbare Träger</li> </ul>

stylingtips

string

Wagen Sie die totale Provokation! Vervollständigen Sie Ihren Look mit unseren <a href="https://www.divasboudoir.com/de/sexy-kleider-in-grossen-grossen/">Sexy Kleidern</a> oder <a href="https://www.divasboudoir.com/de/neglige-in-grosse-grossen/">Negligés</a> für eine grenzenlose Verführung.

summary

string

Entdecken Sie den ultra-sexy Schmuck-String, der jeden Moment in eine Einladung zur Verführung verwandelt. zarte Stickereien, Kristallketten und kleine Brillanten sorgen für einen String, der niemanden gleichgültig lässt.

title

string

Juwelen-String: Provokation und sinnliche Kristalle

usageinstructions

string

Dieser Juwelen-String ist für Momente gemacht, in denen Sie Ihre Sinnlichkeit explodieren lassen wollen . Seine Kristallketten sorgen für eine hypnotische Bewegung, die niemanden kalt lassen wird.

Struct
Entries: 15

abstract

string

careinstructions

string

<ul> <li>Απαλό πλύσιμο στο χέρι</li> <li>Ζεστό νερό (30°C το πολύ)</li> <li>Ήπιο απορρυπαντικό</li> <li>Στεγνώστε σε επίπεδη επιφάνεια</li> <li>Να χειρίζεστε τι&sigmaf; αλυσίδε&sigmaf; με προσοχή</li> </ul>

description

string

Το στρινγκ με κοσμήματα εκρήγνυται με αισθησιασμό, με τι&sigmaf; κρυστάλλινε&sigmaf; αλυσίδε&sigmaf; του να χορεύουν με κάθε σα&sigmaf; κίνηση. Το λεπτεπίλεπτο κέντημά του στην κορυφή του εφηβαίου αποκαλύπτει μια διακριτική πρόκληση, ενώ οι μικρέ&sigmaf; λάμψει&sigmaf; μετατρέπουν κάθε ματιά σε πρόσκληση. Ένα στρινγκ που δεν ντύνει απλώ&sigmaf; το σώμα σα&sigmaf;, αλλά το υποβόσκει με ωμό, γεμάτο αυτοπεποίθηση αισθησιασμό. Κάθε λεπτομέρεια έχει σχεδιαστεί για να δημιουργήσει μια στιγμή καθαρή&sigmaf; αποπλάνηση&sigmaf;: συρόμενε&sigmaf; αλυσίδε&sigmaf;, αστραφτερά κρύσταλλα, ένα σχέδιο που φωνάζει τόλμη.

guid

string

https://dev.divasboudoir.com/el/joyas-megalo-rythmizomeno-stringk-mayro-kokkino-ou-leyko/sbga4825.htm

highlights

string

<ul> <li>Αλυσίδε&sigmaf; στολισμένε&sigmaf; με εξαιρετικά προκλητικάκρύσταλλα</li> <li>Λεπτό κέντημα στην κορυφή του εφηβαίου</li> <li>Μικρέ&sigmaf; λάμψει&sigmaf; που πιάνουν το φω&sigmaf;</li> <li>Ρυθμιζόμενο στρινγκ για βέλτιστη άνεση</li> <li>Τρία χρώματα: μαύρο, κόκκινο, λευκό</li> <li>Μινιμαλιστικό&sigmaf; αλλά σέξισχεδιασμό&sigmaf;</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Μεγάλο κορδόνι με κοσμήματα και κρυστάλλινες αλυσίδες. Λεπτό κέντημα σε τρία χρώματα. Εξαιρετικά σέξι, προκλητικό. Γρήγορη παράδοση. Μπουντουάρ της Ντίβας.

keywords

string

title

string

Στρινγκ Bijou Grande Taille Sexy | Diva's Boudoir

seotitle

string

Μεγάλο στρινγκ με κοσμήματα, αλυσίδες και κρύσταλλα

seouri

string

joyas-megalo-rythmizomeno-stringk-mayro-kokkino-ou-leyko

specifications

string

<ul> <li>Υλικό: Δαντέλα και κρυστάλλινε&sigmaf; αλυσίδε&sigmaf;</li> <li>Χρώματα: Μαύρο, Κόκκινο, Λευκό</li> <li>Στυλ : Πολύ σέξι στρινγκ με κοσμήματα</li> <li>Λεπτομέρειε&sigmaf;: Αλυσίδε&sigmaf;, κρύσταλλα, κεντήματα</li> <li>Εφαρμογή : Ρυθμιζόμενε&sigmaf; τιράντε&sigmaf;</li> </ul>

stylingtips

string

Τολμήστε να είστε εντελώ&sigmaf; προκλητικοί! Ολοκληρώστε την εμφάνισή σα&sigmaf; με τα <a href="https://www.divasboudoir.com/el/sexi-foremata-syn-megethos/">σέξι φορέματα</a> ή <a href="https://www.divasboudoir.com/el/negklize-megaloy-megethoys/">τα νεγκλιζέ</a> μα&sigmaf; για απεριόριστη αποπλάνηση.

summary

string

Ανακαλύψτε το εξαιρετικά σέξι στρινγκ με κοσμήματα που μετατρέπει κάθε στιγμή σε πρόσκληση για αποπλάνηση. λεπτά κεντήματα, αλυσίδε&sigmaf; από κρύσταλλα και μικρέ&sigmaf; λάμψει&sigmaf; για ένα στρινγκ που δεν αφήνει κανέναν αδιάφορο.

title

string

Bijou G-string: Πρόκληση και αισθησιακοί κρύσταλλοι

usageinstructions

string

Αυτό το στρινγκ με κοσμήματα είναι φτιαγμένο για εκείνε&sigmaf; τι&sigmaf; στιγμέ&sigmaf; που θέλετε να αφήσετε τον αισθησιασμό σα&sigmaf; να εκραγεί. Οι κρυστάλλινε&sigmaf; αλυσίδε&sigmaf; του δημιουργούν μια υπνωτική κίνηση που δεν θα αφήσει κανέναν άφωνο.

Struct
Entries: 15

abstract

string

careinstructions

string

<ul> <li>Delicate hand wash</li> <li>Warm water (30°C maximum)</li> <li>Mild detergent</li> <li>Dry flat</li> <li>Handle chains with care</li> </ul>

description

string

The jewel thong explodes with sensuality, its crystal chains dancing with your every move. Its delicate embroidery on the top of the pubis reveals a subtle provocation, while the tiny sparkles turn every glance into an invitation. A thong that doesn't just dress your body, but sublimates it with raw, assumed sensuality. Every detail has been designed to create a moment of pure seduction: sliding chains, sparkling crystals, a design that screams boldness.

guid

string

https://dev.divasboudoir.com/en/string-jewel-plus-size-chains-crystals/sbga4825.htm

highlights

string

<ul> <li>Chains adorned with ultra-provocativecrystals</li> <li>Delicate embroidery on the top of the pubis</li> <li>Light-catching sparkles</li> <li>Adjustable thong for optimum comfort</li> <li>Three colors: black, red, white</li> <li>Minimalist yet terribly sexydesign</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Plus size jewel thong with crystal chains. Delicate embroidery in three colors. Ultra sexy, provocative. Fast delivery. Diva's Boudoir.

keywords

string

title

string

Thong Bijou Plus Size Sexy | Diva's Boudoir

seotitle

string

Jewel thong plus size with chains and crystals

seouri

string

string-jewel-plus-size-chains-crystals

specifications

string

<ul> <li>Material: Lace and crystal chains</li> <li>Colors: Black, Red, White</li> <li>Style: Ultra sexy jewel thong</li> <li>Details: Chains, crystals, embroidery</li> <li>Fitting : Adjustable straps</li> </ul>

stylingtips

string

Dare to be totally provocative! Complete your look with our <a href="https://www.divasboudoir.com/en/sexys-plus-size-dresses/">sexy dresses</a> or <a href="https://www.divasboudoir.com/en/plus-size-robes/">negligees</a> for unlimited seduction.

summary

string

Discover the ultra-sexy jewel thong that transforms every moment into an invitation to seduction. delicate embroidery, crystal chains and tiny sparkles for a thong that leaves no one indifferent.

title

string

Bijou G-string: Provocation and Sensual Crystals

usageinstructions

string

This jewel thong is made for those moments when you want to explode your sensuality. Its crystal chains create a hypnotic movement that will leave no one speechless.

Struct
Entries: 15

abstract

string

careinstructions

string

<ul> <li>Lavado suave a mano</li> <li>Agua tibia (30°C máximo)</li> <li>Detergente suave</li> <li>Secar en plano</li> <li>Manipular las cadenas con cuidado</li> </ul>

description

string

El tanga joya explota de sensualidad, sus cadenas de cristal bailan con cada uno de tus movimientos. Su delicado bordado en la parte superior del pubis revela una sutil provocación, mientras que los pequeños destellos convierten cada mirada en una invitación. Un tanga que no sólo viste tu cuerpo, sino que lo sublima con una sensualidad cruda y segura. Cada detalle ha sido diseñado para crear un momento de pura seducción: cadenas deslizantes, cristales brillantes, un diseño que grita audacia.

guid

string

https://dev.divasboudoir.com/es/tanga-joya-talla-grande-cadenas-cristales/sbga4825.htm

highlights

string

<ul> <li>Cadenas adornadas con cristales ultraprovocadores</li> <li>Delicados bordados en la parte superior del pubis</li> <li>Pequeños destellos que captan la luz</li> <li>Tanga ajustable para un confort óptimo</li> <li>Tres colores: negro, rojo y blanco</li> <li>Diseño minimalista pero sexy</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Tanga joya grande con cadenas de cristal. Delicado bordado en tres colores. Ultra sexy y provocativo. Entrega rápida. Diva's Boudoir.

keywords

string

title

string

Tanga Bijou Talla grande Sexy | Diva's Boudoir

seotitle

string

Tanga joya grande con cadenas y cristales

seouri

string

tanga-joya-talla-grande-cadenas-cristales

specifications

string

<ul> <li>Material: Encaje y cadenas de cristal</li> <li>Colores: negro, rojo y blanco</li> <li>Estilo : Tanga joya ultra sexy</li> <li>Detalles : Cadenas, cristales, bordados</li> <li>Ajuste : Tirantes ajustables</li> </ul>

stylingtips

string

¡Atrévete a ser totalmente provocativa! Completa tu look con nuestros <a href="https://www.divasboudoir.com/es/sexys-vestidos-talla-grande/">vestidos sexys</a> o <a href="https://www.divasboudoir.com/es/picardias-talla-grande/">picardías</a> para una seducción sin límites.

summary

string

Descubre el tanga joya ultra sexy que convierte cada momento en una invitación a la seducción. delicados bordados, cadenas de cristales y pequeños destellos para un tanga que no deja indiferente a nadie.

title

string

Tanga Bijou: provocación y cristales sensuales

usageinstructions

string

Este tanga joya está hecho para esos momentos en los que quieres dejar que explote tu sensualidad. Sus cadenas de cristal crean un movimiento hipnótico que no dejará a nadie boquiabierto.

Struct
Entries: 15

abstract

string

careinstructions

string

<ul> <li>Lavage délicat à la main</li> <li>Eau tiède (30°C maximum)</li> <li>Lessive douce</li> <li>Séchage à plat</li> <li>Manipuler avec précaution les chaînettes</li> </ul>

description

string

Le string bijou explose de sensualité avec ses chaînettes de cristaux qui dansent à chacun de vos mouvements. Ses broderies délicates sur le haut du pubis révèlent une provocation subtile, tandis que les petits brillants transforment chaque regard en invitation. Un string qui ne se contente pas d'habiller votre corps, mais qui le sublime avec une sensualité crue et assumée. Chaque détail a été pensé pour créer un moment de pure séduction : les chaînettes qui glissent, les cristaux qui scintillent, un design qui crie votre audace.

guid

string

https://dev.divasboudoir.com/fr/string-bijou-grande-taille-chaines-cristaux/sbga4825.htm

highlights

string

<ul> <li>Chaînettes ornées de cristaux ultra provocantes</li> <li>Broderies délicates sur le haut du pubis</li> <li>Petits brillants qui accrochent la lumière</li> <li>String ajustable pour un confort optimal</li> <li>Trois couleurs : noir, rouge, blanc</li> <li>Design minimal mais terriblement sexy</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

String bijou grande taille avec chaînettes de cristaux. Broderies délicates, trois couleurs. Ultra sexy, provocant. Livraison rapide. Diva's Boudoir.

keywords

string

title

string

String Bijou Grande Taille Sexy | Diva's Boudoir

seotitle

string

String grande taille bijou avec chaînettes et cristaux

seouri

string

string-bijou-grande-taille-chaines-cristaux

specifications

string

<ul> <li>Matière : Dentelle et chaînettes de cristaux</li> <li>Couleurs : Noir, Rouge, Blanc</li> <li>Style : String bijou ultra sexy</li> <li>Détails : Chaînettes, cristaux, broderies</li> <li>Ajustement : Bretelles réglables</li> </ul>

stylingtips

string

Osez la provocation totale ! Complétez votre look avec nos <a href="https://www.divasboudoir.com/fr/robes-sexys-grande-taille/">Robes Sexys</a> ou nos <a href="https://www.divasboudoir.com/fr/deshabille-grande-taille/">déshabillés</a> pour une séduction sans limite.

summary

string

Découvrez le string bijou ultra sexy qui transforme chaque moment en invitation à la séduction.  Broderies délicates, chaînettes de cristaux et petits brillants pour un string qui ne laisse personne indifférent.

title

string

String Bijou : Provocation et Cristaux Sensuels

usageinstructions

string

Ce string bijou est fait pour les moments où vous voulez faire exploser votre sensualité. Ses chaînettes de cristaux créent un mouvement hypnotique qui ne laissera personne de marbre.

Struct
Entries: 15

abstract

string

careinstructions

string

<ul> <li>Lavaggio a mano delicato</li> <li>Acqua calda (massimo 30°C)</li> <li>Detersivo delicato</li> <li>Asciugare in piano</li> <li>Maneggiare le catene con cura</li> </ul>

description

string

Il perizoma gioiello esplode di sensualità, con le sue catene di cristalli che danzano ad ogni vostro movimento. Il suo delicato ricamo sulla parte superiore del pube rivela una sottile provocazione, mentre i piccoli scintillii trasformano ogni sguardo in un invito. Un perizoma che non si limita a vestire il corpo, ma lo sublima con una sensualità cruda e sicura. Ogni dettaglio è stato studiato per creare un momento di pura seduzione: catene scorrevoli, cristalli scintillanti, un design che grida audacia.

guid

string

https://dev.divasboudoir.com/it/perizoma-gioiello-taglia-grande-catene-cristalli/sbga4825.htm

highlights

string

<ul> <li>Catene ornate di cristalli ultra-provocanti</li> <li>Delicati ricami sulla parte superiore del pube</li> <li>Piccoli scintillii che catturano la luce</li> <li>Perizoma regolabile per un comfort ottimale</li> <li>Tre colori: nero, rosso, bianco</li> <li>Design minimalista ma sexy</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Un tanga di taglia grande delicatamente ricamato e ornato di gioielli.

keywords

string

title

string

Perizoma Joyas di taglia grande e regolabile

seotitle

string

Perizoma gioiello di taglia grande con catene e cristalli

seouri

string

perizoma-gioiello-taglia-grande-catene-cristalli

specifications

string

<ul> <li>Materiale: pizzo e catene di cristallo</li> <li>Colori: Nero, Rosso, Bianco</li> <li>Stile : Perizoma gioiello ultra sexy</li> <li>Dettagli : Catene, cristalli, ricamo</li> <li>Vestibilità : Spalline regolabili</li> </ul>

stylingtips

string

Osate essere totalmente provocanti! Completate il vostro look con i nostri <a href="https://www.divasboudoir.com/it/abiti-sexys-taglia-grande/">abiti</a> o <a href="https://www.divasboudoir.com/it/vestaglia-taglia-grande/">vestaglie</a> <a href="https://www.divasboudoir.com/it/abiti-sexys-taglia-grande/">sexy</a> per una seduzione senza limiti.

summary

string

Scoprite il perizoma gioiello ultra sexy che trasforma ogni momento in un invito alla seduzione. ricami delicati, catene di cristalli e piccoli scintillii per un tanga che non lascia indifferenti.

title

string

Bijou perizoma: provocazione e cristalli sensuali

usageinstructions

string

Questo perizoma gioiello è fatto per quei momenti in cui volete far esplodere la vostra sensualità. Le sue catene di cristalli creano un movimento ipnotico che non lascerà nessuno a bocca aperta.

Struct
Entries: 15

abstract

string

careinstructions

string

<ul> <li>Zacht met de hand wassen</li> <li>Warm water (maximaal 30°C)</li> <li>Mild wasmiddel</li> <li>Plat drogen</li> <li>Kettingen voorzichtig behandelen</li> </ul>

description

string

De juwelenstring barst van de sensualiteit, de kristallen kettingen dansen met elke beweging. Het delicate borduursel op de bovenkant van het schaambeen onthult een subtiele provocatie, terwijl de kleine glittertjes elke blik in een uitnodiging veranderen. Een string die je lichaam niet alleen aankleedt, maar het sublimeert met rauwe, zelfverzekerde sensualiteit. Elk detail is ontworpen om een moment van pure verleiding te creëren: glijdende kettingen, fonkelende kristallen, een ontwerp dat durf schreeuwt.

guid

string

https://dev.divasboudoir.com/nl/string-sieraad-grote-maat-kettingen-kristallen/sbga4825.htm

highlights

string

<ul> <li>Kettingen versierd met ultra-provocerendekristallen</li> <li>Delicaat borduurwerk bovenaan het schaambeen</li> <li>Kleine fonkelingen die het licht vangen</li> <li>Verstelbare string voor optimaal comfort</li> <li>Drie kleuren: zwart, rood, wit</li> <li>Minimalistisch maar sexyontwerp</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Grote maat juwelenstring met kristallen kettingen. Delicaat borduurwerk in drie kleuren. Ultrasexy, uitdagend. Snelle levering. Diva's Boudoir.

keywords

string

title

string

String Bijou Grote Maat Sexy | Diva's Boudoir

seotitle

string

Grote maat juwelenstring met kettingen en kristallen

seouri

string

string-sieraad-grote-maat-kettingen-kristallen

specifications

string

<ul> <li>Materiaal: Kant en kristallen kettingen</li> <li>Kleuren: Zwart, Rood, Wit</li> <li>Stijl : Ultra sexy juwelen string</li> <li>Details : Kettingen, kristallen, borduursel</li> <li>Pasvorm : Verstelbare bandjes</li> </ul>

stylingtips

string

Durf je helemaal uit te sloven! Maak je look compleet met onze <a href="https://www.divasboudoir.com/nl/sexys-jurken-grote-maat/">sexy jurkjes</a> of <a href="https://www.divasboudoir.com/nl/grote-maat-neglige/">negligés</a> voor onbeperkte verleiding.

summary

string

Ontdek de ultra sexy juwelenstring die van elk moment een uitnodiging tot verleiding maakt. delicaat borduurwerk, kettingen van kristallen en kleine glittertjes voor een string die niemand onverschillig laat.

title

string

Bijou G-string: provocatie en sensuele kristallen

usageinstructions

string

Deze juwelenstring is gemaakt voor die momenten waarop je je sensualiteit wilt laten exploderen. De kristallen kettingen creëren een hypnotiserende beweging die niemand sprakeloos zal laten.

Struct
Entries: 15

abstract

string

careinstructions

string

<ul> <li>Lavagem suave à mão</li> <li>Água morna (30°C no máximo)</li> <li>Detergente suave</li> <li>Secar na horizontal</li> <li>Manusear as correntes com cuidado</li> </ul>

description

string

A tanga jewel explode de sensualidade, as suas correntes de cristal dançam com todos os seus movimentos. O seu delicado bordado na parte superior do púbis revela uma subtil provocação, enquanto os pequenos brilhos transformam cada olhar num convite. Uma tanga que não se limita a vestir o seu corpo, mas que o sublima com uma sensualidade crua e confiante. Cada pormenor foi concebido para criar um momento de pura sedução: correntes deslizantes, cristais cintilantes, um design que grita ousadia.

guid

string

https://dev.divasboudoir.com/pt/fio-dental-joia-tamanho-grande-correntes-cristais/sbga4825.htm

highlights

string

<ul> <li>Correntes adornadas com cristais ultra-provocantes</li> <li>Bordado delicado na parte superior do púbis</li> <li>Pequenos brilhos que captam a luz</li> <li>Tanga ajustável para um conforto ótimo</li> <li>Três cores: preto, vermelho, branco</li> <li>Design minimalista mas sexy</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Tanga grande com jóias e correntes de cristal. Bordados delicados em três cores. Ultra sexy, provocante. Entrega rápida. Diva's Boudoir.

keywords

string

title

string

Tanga Bijou Grande Taille Sexy | Diva's Boudoir

seotitle

string

Tanga grande com jóias, correntes e cristais

seouri

string

fio-dental-joia-tamanho-grande-correntes-cristais

specifications

string

<ul> <li>Material: Renda e correntes de cristal</li> <li>Cores: Preto, Vermelho, Branco</li> <li>Estilo : Tanga ultra sexy com jóias</li> <li>Detalhes : Correntes, cristais, bordados</li> <li>Ajuste : Alças ajustáveis</li> </ul>

stylingtips

string

Atreva-se a ser totalmente provocante! Completa o teu look com os nossos <a href="https://www.divasboudoir.com/pt/vestidos-sexys-plus-size/">vestidos sensuais</a> ou com os nossos <a href="https://www.divasboudoir.com/pt/batotas-plus-size/">negligees</a> para uma sedução sem limites.

summary

string

Descubra a tanga joia ultra sexy que transforma cada momento num convite à sedução. bordados delicados, correntes de cristais e pequenos brilhos para uma tanga que não deixa ninguém indiferente.

title

string

Bijou G-string: Provocação e cristais sensuais

usageinstructions

string

Esta tanga de jóias é feita para aqueles momentos em que quer deixar a sua sensualidade explodir. As suas correntes de cristal criam um movimento hipnótico que não deixará ninguém sem palavras.

fetishboudoir

Struct

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-schwarz-rot-ou-weiss

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-mayro-kokkino-ou-leyko

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-black-red-ou-white

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-negro-rojo-ou-blanco

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-noir-rouge-ou-blanc

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-nero-rosso-ou-bianco

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-zwart-rood-ou-wit

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-preto-vermelho-ou-branco

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

latexboudoir

Struct

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-schwarz-rot-ou-weiss

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-mayro-kokkino-ou-leyko

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-black-red-ou-white

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-negro-rojo-ou-blanco

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-noir-rouge-ou-blanc

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-nero-rosso-ou-bianco

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-zwart-rood-ou-wit

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-preto-vermelho-ou-branco

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

legsboudoir

Struct

Struct
Entries: 14

abstract

string

careinstructions

string

<ul> <li>Feinwäsche per Hand in lauwarmem Wasser (maximal 30°C), um die Kristalle zu erhalten</li> <li>Verwenden Sie ein mildes Waschmittel speziell für feine Dessous</li> <li>Gehen Sie vorsichtig mit den Kettchen und Kristallen um</li> <li>Flach liegend vor direktem Licht geschützt trocknen</li> <li>Sorgfältig aufbewahren, um die Schmuckdetails zu erhalten</li> </ul>

description

string

Der Juwelen-String verkörpert die Kunst der raffinierten Lingerie mit seinen zarten Stickereien, die den oberen Teil des Schambereichs harmonisch verzieren. Die Kristallketten erzeugen eine anmutige Bewegung, die Ihre Bewegungen natürlich begleitet, während die kleinen eingearbeiteten Brillanten dieses Stück in ein wahres Dessous-Schmuckstück verwandeln. Diese Kreation ist eine perfekte Kombination aus Komfort und Ästhetik, da sich das verstellbare Design sanft an jede Körperform anpasst. Die sorgfältige Verarbeitung verrät die Aufmerksamkeit, die jedem Detail gewidmet wurde, und schafft ein Stück, das Sie elegant begleitet. Erhältlich in drei zeitlosen Farben - geheimnisvolles Schwarz, leidenschaftliches Rot und reines Weiß - offenbart jede Version eine andere Facette Ihrer Persönlichkeit. Dieses einzigartige Stück verwandelt jeden Moment in eine Gelegenheit, bei der Sie sich natürlich selbstbewusst und raffiniert fühlen.

highlights

string

<ul> <li>Zarte Stickereien auf dem oberen Schambereich mit raffinierten Mustern</li> <li>Mit Kristallen verzierte Ketten, die das Licht sanft auffangen</li> <li>Eingearbeitetekleine Brillanten für einen raffinierten Schmuckeffekt.</li> <li>Verstellbarer String, der sich an jede Körperform anpasst</li> <li>Drei Farben: Schwarz, Rot, Weiß</li> <li>Sorgfältige Verarbeitung wie bei einem Dessous-Schmuckstück</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Schmuckstring in großen Größen mit zarten Stickereien und Kristallketten. Drei raffinierte Farben, sorgfältige Verarbeitung. Eleganz und Komfort bei Leg's Boudoir.

keywords

string

title

string

Juwelen-String Große Größe Kristalle | Leg's Boudoir

seotitle

string

String große Größe Juwelen Stickerei Ketten Kristalle

seouri

string

juwelen-string-grosse-grosse-stickerei-kristalle

specifications

string

<ul> <li>Material: Zarte Stickereien und Kristallketten (92% Viskose, 8% Elasthan)</li> <li>Farben: Schwarz, Rot, Weiß</li> <li>Stil: Schmuck-String mit Stickereien und Kristallsteinen</li> <li>Details: Bewegliche Ketten, kleine eingearbeitete Brillanten</li> <li>Passform: Verstellbare Träger für optimalen Tragekomfort</li> <li>Verarbeitung: Sorgfältig mit Liebe zum Detail</li> </ul>

stylingtips

string

Der Schmuckstring zeichnet sich durch seine kristallklaren Details aus, die einen raffinierten Stil kreieren. Für eine perfekte Harmonie kombinieren Sie ihn mit Teilen, die seine Eleganz verlängern. Vervollständigen Sie Ihren Look mit unseren <a href="https://www.legsboudoir.com/de/selbstfixierende-strumpfe-grosse-grosse/">selbstfixierenden Strümpfen</a> in <a href="https://www.legsboudoir.com/de/selbstfixierende-strumpfe-grosse-grosse/">großen Größen</a> für absolute Raffinesse, oder entdecken Sie unsere <a href="https://www.legsboudoir.com/de/selbstbindende-strumpfe/">selbstfixierenden Strümpfe</a> in allen Größen, um Ihre Beine mit der gleichen Liebe zum Detail zu betonen.

summary

string

Entdecken Sie den Schmuckstring, bei dem zarte Stickereien auf Kristallketten treffen, um ein Stück von außergewöhnlicher Eleganz zu schaffen. Eine Kreation, die Ihre Silhouette auf natürliche Weise raffiniert hervorhebt.

title

string

Juwelen-String: Eleganz und kristalline Raffinesse

usageinstructions

string

Der Juwelen-String wurde für Momente entworfen, in denen Sie Komfort und Raffinesse miteinander verbinden möchten. Seine Kristallketten erzeugen eine zarte Bewegung, die Ihre Bewegungen natürlich begleitet. Passen Sie die Träger an Ihre Körperform an, um einen optimalen Tragekomfort zu gewährleisten. Die zarten Stickereien und kleinen Brillanten erzeugen einen subtilen Effekt, der Ihre Vorliebe für raffinierte Details offenbart.

Struct
Entries: 14

abstract

string

careinstructions

string

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

description

string

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

highlights

string

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

keypoint

string

keywords

string

metas

Struct

description

string

Μεγάλο στρινγκ με κοσμήματα, λεπτό κέντημα και κρυστάλλινες αλυσίδες. Τρία εκλεπτυσμένα χρώματα, με προσεγμένο φινίρισμα. Κομψότητα και άνεση στο Leg's Boudoir.

keywords

string

title

string

Στρινγκ κόσμημα μεγάλο μέγεθος κρύσταλλα | Μπουντουάρ του ποδιού

seotitle

string

G-string μεγάλο μέγεθος κοσμήματα κέντημα αλυσίδες κρύσταλλα

seouri

string

megalo-megethos-stringk-me-kosmhmata-kai-krystallina-kenthmata

specifications

string

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

stylingtips

string

Το στρινγκ με κοσμήματα διακρίνεται για τις κρυστάλλινες λεπτομέρειες που δημιουργούν ένα εκλεπτυσμένο στυλ. Για τέλεια αρμονία, συνδυάστε το με κομμάτια που επεκτείνουν την κομψότητά του. Ολοκληρώστε την εμφάνισή σας με <a href="https://www.legsboudoir.com/el/hold-ups-large/">τα μεγάλα μεγέθη</a> μας για απόλυτη εκλέπτυνση ή ανακαλύψτε <a href="https://www.legsboudoir.com/el/kaltses-stay-up/">τα μαγιό</a> μας σε όλα τα μεγέθη για να αναδείξετε τα πόδια σας με την ίδια προσοχή στη λεπτομέρεια.

summary

string

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

title

string

String Bijou : Κομψότητα και κρυστάλλινη φινέτσα

usageinstructions

string

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

Struct
Entries: 14

abstract

string

careinstructions

string

<ul> <li>Hand-wash gently in lukewarm water (30°C maximum) to preserve crystals</li> <li>Use a mild detergent for fine lingerie</li> <li>Handle chains and crystals with care</li> <li>Dry flat away from direct light</li> <li>Store with care to preserve jewelry details</li> </ul>

description

string

The jewel thong embodies the art of refined lingerie, with its delicate embroidery harmoniously adorning the top of the pubis. Crystal chains create a graceful movement that naturally accompanies your gestures, while integrated sparkles transform this piece into a veritable jewel of lingerie. This creation perfectly combines comfort and aesthetics, thanks to its adjustable design that gently adapts to all morphologies. The meticulous finishing reveals the attention paid to every detail, creating a piece that accompanies you with elegance. Available in three timeless colors - mysterious black, passionate red and pure white - each version reveals a different facet of your personality. This unique piece transforms every moment into an opportunity to feel naturally confident and refined.

highlights

string

<ul> <li>Delicate embroidery on the top of the pubis with sophisticated motifs</li> <li>Chains adorned with crystals that delicately catch the light</li> <li>Integratedsparkles for a refined jewel effect</li> <li>Adjustable thong to suit all body shapes</li> <li>Three colors: black, red, white</li> <li>Finishes worthy of a lingerie jewel</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Plus size jewel thong with delicate embroidery and crystal chains. Three refined colors, meticulously finished. Elegance and comfort at Leg's Boudoir.

keywords

string

title

string

Thong Jewel Plus Size Crystals | Leg's Boudoir

seotitle

string

G-string plus size jewel embroidery chains crystals

seouri

string

jewel-thong-plus-size-crystal-embroidery

specifications

string

<ul> <li>Material: Delicate embroidery and crystal chains (92% viscose, 8% elastane)</li> <li>Colors: Black, Red, White</li> <li>Style: Jewel thong with embroidery and crystals</li> <li>Details: Movable chains, small integrated sparkles</li> <li>Fit : Adjustable straps for optimum comfort</li> <li>Finishes: Careful attention to detail</li> </ul>

stylingtips

string

Jewel thongs feature crystalline details that create a sophisticated look. For perfect harmony, pair it with pieces that will extend its elegance. Complete your look with our <a href="https://www.legsboudoir.com/en/hold-ups-plus-size/">plus size hold-ups</a> for total sophistication, or discover our <a href="https://www.legsboudoir.com/en/stay-up-stockings/">hold-ups</a> in all sizes to sublimate your legs with the same attention to detail.

summary

string

Discover the jewel thong, where delicate embroidery meets crystal chains to create a piece of exceptional elegance. A creation that naturally enhances your silhouette with refinement.

title

string

String Bijou: Crystal elegance and refinement

usageinstructions

string

The jewel thong is designed for those moments when you want to combine comfort and refinement. Its crystal chains create a delicate movement that naturally accompanies your movements. Adjust the straps to your body shape for optimum comfort. Delicate embroidery and small sparkles create a subtle effect that reveals your taste for refined details.

Struct
Entries: 14

abstract

string

careinstructions

string

<ul> <li>Lavar a mano suavemente en agua tibia (30°C como máximo) para preservar los cristales</li> <li>Utilice un detergente suave para lencería fina</li> <li>Manipule las cadenas y los cristales con cuidado</li> <li>Secar en plano, lejos de la luz directa</li> <li>Guardar con cuidado para conservar los detalles de las joyas</li> </ul>

description

string

El tanga joya encarna el arte de la lencería refinada, con delicados bordados que adornan armoniosamente la parte superior del pubis. Las cadenas de cristal crean un movimiento grácil que acompaña con naturalidad tus movimientos, mientras que los destellos integrados convierten esta pieza en una auténtica joya de la lencería. Esta creación combina a la perfección comodidad y estética, gracias a su diseño ajustable que se adapta suavemente a todas las formas del cuerpo. El meticuloso acabado revela la atención prestada a cada detalle, creando una pieza que te acompaña con elegancia. Disponible en tres colores atemporales -negro misterioso, rojo pasión y blanco puro-, cada versión revela una faceta diferente de tu personalidad. Esta pieza única transforma cada momento en una oportunidad para sentirse naturalmente segura y refinada.

highlights

string

<ul> <li>Delicado bordado en la parte superior del pubis con sofisticados motivos</li> <li>Cadenas adornadas con cristales que captan suavemente la luz</li> <li>Destellos integrados para un refinado efecto joya</li> <li>Tanga ajustable para adaptarse a todas las formas del cuerpo</li> <li>Tres colores: negro, rojo y blanco</li> <li>Acabado con el esmero de una joya de lencería</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Tanga joya de talla grande con delicados bordados y cadenas de cristal. Tres refinados colores, meticulosamente acabados. Elegancia y comodidad en Leg's Boudoir.

keywords

string

title

string

Tanga Joya Talla grande Cristales | Leg's Boudoir

seotitle

string

Tanga talla grande joya bordado cadenas cristales

seouri

string

tanga-joya-talla-grande-con-bordado-de-cristales

specifications

string

<ul> <li>Material: Delicados bordados y cadenas de cristal (92% viscosa, 8% elastán)</li> <li>Colores: negro, rojo y blanco</li> <li>Estilo: Tanga joya con bordados y cristales</li> <li>Detalles: Cadenas móviles, brillos integrados</li> <li>Ajuste : Tirantes ajustables para un confort óptimo</li> <li>Acabados: Cuidada atención al detalle</li> </ul>

stylingtips

string

El tanga joya presenta detalles cristalinos que crean un estilo sofisticado. Para una armonía perfecta, combínalo con piezas que amplíen su elegancia. Completa tu look con nuestras <a href="https://www.legsboudoir.com/es/medias-autoportantes/">medias</a> <a href="https://www.legsboudoir.com/es/medias-talla-grande/">de talla grande</a> para una sofisticación total, o descubre nuestras <a href="https://www.legsboudoir.com/es/medias-autoportantes/">medias</a> de todas las tallas para realzar tus piernas con la misma atención al detalle.

summary

string

Descubra el tanga joya, donde el delicado bordado se une a las cadenas de cristal para crear una pieza de elegancia excepcional. Una creación que realza naturalmente tu figura con refinamiento.

title

string

String Bijou : Elegancia y refinamiento cristalino

usageinstructions

string

El tanga joya está pensado para esos momentos en los que desea combinar comodidad y refinamiento. Sus cadenas de cristal crean un delicado movimiento que acompaña con naturalidad tus movimientos. Ajusta los tirantes a la forma de tu cuerpo para un confort óptimo. El delicado bordado y los diminutos destellos crean un sutil efecto que revela su gusto por los detalles refinados.

Struct
Entries: 14

abstract

string

careinstructions

string

<ul> <li>Lavage délicat à la main à l'eau tiède (30°C maximum) pour préserver les cristaux</li> <li>Utiliser une lessive douce spéciale lingerie fine</li> <li>Manipuler avec précaution les chaînettes et cristaux</li> <li>Séchage à plat à l'abri de la lumière directe</li> <li>Ranger avec soin pour préserver les détails bijoux</li> </ul>

description

string

Le string bijou incarne l'art de la lingerie raffinée avec ses broderies délicates qui ornent harmonieusement le haut du pubis. Les chaînettes de cristaux créent un mouvement gracieux qui accompagne naturellement vos gestes, tandis que les petits brillants intégrés transforment cette pièce en véritable bijou de lingerie. Cette création allie parfaitement confort et esthétisme grâce à sa conception ajustable qui s'adapte délicatement à toutes les morphologies. Les finitions soignées révèlent l'attention portée à chaque détail, créant une pièce qui vous accompagne avec élégance. Disponible en trois coloris intemporels - noir mystérieux, rouge passion et blanc pur - chaque version révèle une facette différente de votre personnalité. Cette pièce unique transforme chaque moment en occasion de vous sentir naturellement confiante et raffinée.

highlights

string

<ul> <li>Broderies délicates sur le haut du pubis avec motifs sophistiqués</li> <li>Chaînettes ornées de cristaux qui accrochent délicatement la lumière</li> <li>Petits brillants intégrés pour un effet bijou raffiné</li> <li>String ajustable qui s'adapte à toutes les morphologies</li> <li>Trois coloris : noir, rouge, blanc</li> <li>Finitions soignées dignes d'un bijou de lingerie</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

String bijou grande taille avec broderies délicates et chaînettes de cristaux. Trois coloris raffinés, finitions soignées. Élégance et confort chez Leg's Boudoir.

keywords

string

title

string

String Bijou Grande Taille Cristaux | Leg's Boudoir

seotitle

string

String grande taille bijou broderies chaînettes cristaux

seouri

string

string-bijou-grande-taille-broderies-cristaux

specifications

string

<ul> <li>Matière : Broderies délicates et chaînettes de cristaux (92% viscose, 8% élasthanne)</li> <li>Couleurs : Noir, Rouge, Blanc</li> <li>Style : String bijou avec broderies et cristaux</li> <li>Détails : Chaînettes mobiles, petits brillants intégrés</li> <li>Ajustement : Bretelles réglables pour un confort optimal</li> <li>Finitions : Soignées avec attention aux détails</li> </ul>

stylingtips

string

Le string bijou se distingue par ses détails cristallins qui créent un style sophistiqué. Pour une harmonie parfaite, associez-le à des pièces qui prolongeront son élégance. Complétez votre look avec nos <a href="https://www.legsboudoir.com/fr/bas-autofixants-grande-taille/">bas autofixants grande taille</a> pour une sophistication totale, ou découvrez nos <a href="https://www.legsboudoir.com/fr/bas-autofixants/">bas autofixants</a> dans toutes les tailles pour sublimer vos jambes avec la même attention aux détails.

summary

string

Découvrez le string bijou, où les broderies délicates rencontrent des chaînettes de cristaux pour créer une pièce d'une élégance exceptionnelle. Une création qui sublime naturellement votre silhouette avec raffinement.

title

string

String Bijou : Élégance et Raffinement Cristallin

usageinstructions

string

Le string bijou est conçu pour les moments où vous souhaitez allier confort et raffinement. Ses chaînettes de cristaux créent un mouvement délicat qui accompagne naturellement vos gestes. Ajustez les bretelles selon votre morphologie pour un confort optimal. Les broderies délicates et les petits brillants créent un effet subtil qui révèle votre goût pour les détails raffinés.

Struct
Entries: 14

abstract

string

careinstructions

string

<ul> <li>Lavare delicatamente a mano in acqua tiepida (massimo 30°C) per preservare i cristalli</li> <li>Utilizzare un detersivo delicato per la lingerie fine</li> <li>Maneggiare con cura catene e cristalli</li> <li>Asciugare in piano lontano dalla luce diretta</li> <li>Conservare con cura per preservare i dettagli dei gioielli</li> </ul>

description

string

Il perizoma gioiello incarna l'arte della lingerie raffinata, con un delicato ricamo che adorna armoniosamente la parte superiore del pube. Le catene di cristallo creano un movimento aggraziato che accompagna naturalmente i vostri movimenti, mentre i brillantini integrati trasformano questo pezzo in un vero e proprio gioiello di lingerie. Questa creazione combina perfettamente comfort ed estetica, grazie al suo design regolabile che si adatta delicatamente a tutte le forme del corpo. La finitura meticolosa rivela l'attenzione prestata a ogni dettaglio, creando un capo che vi accompagna con eleganza. Disponibile in tre colori senza tempo - nero misterioso, rosso passionale e bianco puro - ogni versione rivela una sfaccettatura diversa della vostra personalità. Questo pezzo unico trasforma ogni momento in un'occasione per sentirsi naturalmente sicuri e raffinati.

highlights

string

<ul> <li>Delicato ricamo sulla parte superiore del pube con motivi sofisticati</li> <li>Catene ornate di cristalli che catturano delicatamente la luce</li> <li>Scintille integrate per un raffinato effetto gioiello</li> <li>Perizoma regolabile per adattarsi a tutte le forme del corpo</li> <li>Tre colori: nero, rosso, bianco</li> <li>Rifinito con la cura di un gioiello di lingerie</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Perizoma gioiello di grande taglia con delicati ricami e catene di cristalli. Tre colori raffinati, minuziosamente rifiniti. Eleganza e comfort da Leg's Boudoir.

keywords

string

title

string

Perizoma Gioiello Taglia Grande Cristalli | Gamba Boudoir

seotitle

string

Perizoma di taglia grande ricamo gioiello catene cristalli

seouri

string

perizoma-gioiello-di-taglia-grande-con-ricamo-in-cristallo

specifications

string

<ul> <li>Materiale: Delicati ricami e catene di cristalli (92% viscosa, 8% elastan)</li> <li>Colori: nero, rosso, bianco</li> <li>Stile: Perizoma gioiello con ricami e cristalli</li> <li>Dettagli: Catene mobili, scintille integrate</li> <li>Vestibilità : Spalline regolabili per un comfort ottimale</li> <li>Finiture: Cura dei dettagli</li> </ul>

stylingtips

string

Il tanga gioiello si distingue per i suoi dettagli cristallini che creano uno stile sofisticato. Per un'armonia perfetta, abbinatelo a capi che ne esaltino l'eleganza. Completate il vostro look con le nostre <a href="https://www.legsboudoir.com/it/Calze autoreggenti di taglia grande/">autoreggenti di taglia grande</a> per una raffinatezza totale, oppure scoprite le nostre <a href="https://www.legsboudoir.com/it/calze-autoreggenti/">autoreggenti</a> di tutte le taglie per valorizzare le vostre gambe con la stessa attenzione ai dettagli.

summary

string

Scoprite il perizoma gioiello, dove i ricami delicati incontrano le catene di cristalli per creare un pezzo di eccezionale eleganza. Una creazione che valorizza naturalmente la vostra figura con raffinatezza.

title

string

String Bijou: eleganza e raffinatezza dei cristalli

usageinstructions

string

Il perizoma gioiello è pensato per i momenti in cui si desidera combinare comfort e raffinatezza. Le sue catene di cristalli creano un movimento delicato che accompagna naturalmente i vostri movimenti. Regolate le spalline in base alla forma del vostro corpo per un comfort ottimale. I ricami delicati e i piccoli scintillii creano un effetto discreto che rivela il vostro gusto per i dettagli raffinati.

Struct
Entries: 14

abstract

string

careinstructions

string

<ul> <li>Voorzichtig met de hand wassen in lauwwarm water (maximaal 30°C) om de kristallen te behouden</li> <li>Gebruik een mild wasmiddel voor fijne lingerie</li> <li>Wees voorzichtig met kettingen en kristallen</li> <li>Droog plat en uit de buurt van direct licht</li> <li>Voorzichtig opbergen om de details van de sieraden te behouden</li> </ul>

description

string

De juwelenstring belichaamt de kunst van verfijnde lingerie, met delicaat borduurwerk dat harmonieus de bovenkant van het schaambeen siert. De kristallen kettingen creëren een sierlijke beweging die je bewegingen op natuurlijke wijze begeleidt, terwijl de geïntegreerde glitters van dit stuk een echt lingeriejuweel maken. Deze creatie combineert perfect comfort en esthetiek, dankzij het verstelbare ontwerp dat zich zachtjes aanpast aan alle lichaamsvormen. De zorgvuldige afwerking onthult de aandacht die is besteed aan elk detail, waardoor een stuk is ontstaan dat je elegant begeleidt. Verkrijgbaar in drie tijdloze kleuren - mysterieus zwart, gepassioneerd rood en puur wit - onthult elke versie een ander facet van je persoonlijkheid. Dit unieke stuk verandert elk moment in een kans om je natuurlijk zelfverzekerd en verfijnd te voelen.

highlights

string

<ul> <li>Delicaat borduurwerk op de bovenkant van het schaambeen met verfijnde motieven</li> <li>Kettingen versierd met kristallen die zachtjes het licht vangen</li> <li>Geïntegreerdeglitters voor een verfijnd juweleneffect</li> <li>Verstelbare string voor alle lichaamsvormen</li> <li>Drie kleuren: zwart, rood, wit</li> <li>Afgewerkt met de zorg van een lingeriejuweel</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Grote maat juwelenstring met delicaat borduurwerk en kristallen kettingen. Drie verfijnde kleuren, zorgvuldig afgewerkt. Elegantie en comfort bij Leg's Boudoir.

keywords

string

title

string

String Jewel Grote Maat Kristallen | Leg's Boudoir

seotitle

string

G-string grote maat juweel borduurwerk kettingen kristallen

seouri

string

grote-maat-juwelenstring-met-kristallen-borduursel

specifications

string

<ul> <li>Materiaal: Delicaat borduurwerk en kristallen kettingen (92% viscose, 8% elastaan)</li> <li>Kleuren: Zwart, Rood, Wit</li> <li>Stijl: Juwelenstring met borduursel en kristallen</li> <li>Details: beweegbare kettingen, geïntegreerde glitters</li> <li>Pasvorm : Verstelbare bandjes voor optimaal comfort</li> <li>Afwerking: Zorgvuldige aandacht voor detail</li> </ul>

stylingtips

string

De juwelenstring valt op door de kristallen details die een verfijnde stijl creëren. Voor een perfecte harmonie combineer je hem met stukken die zijn elegantie verlengen. Maak je look compleet met onze <a href="https://www.legsboudoir.com/nl/hold-ups-grote-maten/">grote hold ups</a> voor totale verfijning, of ontdek onze <a href="https://www.legsboudoir.com/nl/ophoudende-kousen/">hold ups</a> in alle maten om je benen te verbeteren met dezelfde aandacht voor detail.

summary

string

Ontdek de juwelenstring, waar delicaat borduurwerk samenkomt met kristallen kettingen om een stuk van uitzonderlijke elegantie te creëren. Een creatie die je figuur op natuurlijke en geraffineerde wijze benadrukt.

title

string

String Bijou : Elegantie en kristalverfijning

usageinstructions

string

De juwelenstring is ontworpen voor momenten waarop je comfort en verfijning wilt combineren. De kristallen kettingen creëren een delicate beweging die je bewegingen op natuurlijke wijze begeleidt. Pas de bandjes aan je lichaamsvorm aan voor optimaal comfort. Het delicate borduursel en de kleine glittertjes creëren een subtiel effect dat je smaak voor verfijnde details onthult.

Struct
Entries: 14

abstract

string

careinstructions

string

<ul> <li>Lavar suavemente à mão em água morna (30°C no máximo) para preservar os cristais</li> <li>Utilizar um detergente suave para lingerie fina</li> <li>Manusear as correntes e os cristais com cuidado</li> <li>Secar ao abrigo da luz direta</li> <li>Guardar cuidadosamente para preservar os pormenores das jóias</li> </ul>

description

string

A tanga jewel encarna a arte da lingerie requintada, com bordados delicados que adornam harmoniosamente a parte superior do púbis. As correntes de cristal criam um movimento gracioso que acompanha naturalmente os seus movimentos, enquanto os brilhos integrados transformam esta peça numa verdadeira joia de lingerie. Esta criação combina perfeitamente conforto e estética, graças ao seu design ajustável que se adapta suavemente a todas as formas do corpo. O acabamento meticuloso revela a atenção dada a cada detalhe, criando uma peça que a acompanha com elegância. Disponível em três cores intemporais - preto misterioso, vermelho apaixonado e branco puro - cada versão revela uma faceta diferente da sua personalidade. Esta peça única transforma cada momento numa oportunidade para se sentir naturalmente confiante e refinada.

highlights

string

<ul> <li>Bordado delicado na parte superior do púbis com motivos sofisticados</li> <li>Correntes adornadas com cristais que captam suavemente a luz</li> <li>Brilhos integrados para um efeito de joalharia requintada</li> <li>Tanga ajustável para se adaptar a todas as formas do corpo</li> <li>Três cores: preto, vermelho e branco</li> <li>Acabamento com o cuidado de uma joia de lingerie</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Tanga grande com jóias, bordados delicados e correntes de cristais. Três cores refinadas, meticulosamente acabadas. Elegância e conforto em Leg's Boudoir.

keywords

string

title

string

Tanga Joia Tamanho Grande Cristais | Leg's Boudoir

seotitle

string

Tanga de tamanho grande com bordados de jóias e correntes de cristais

seouri

string

tanga-de-joias-de-tamanho-grande-com-bordado-de-cristais

specifications

string

<ul> <li>Material: Bordados delicados e correntes de cristais (92% viscose, 8% elastano)</li> <li>Cores: Preto, Vermelho, Branco</li> <li>Estilo: Tanga de jóias com bordados e cristais</li> <li>Detalhes: Correntes móveis, brilhantes integrados</li> <li>Ajuste : Alças ajustáveis para um conforto ótimo</li> <li>Acabamentos: Atenção cuidada aos pormenores</li> </ul>

stylingtips

string

A tanga jewel distingue-se pelos seus detalhes cristalinos que criam um estilo sofisticado. Para uma harmonia perfeita, combine-a com peças que aumentem a sua elegância. Complete o seu look com as nossas cuecas <a href="https://www.legsboudoir.com/pt/Meias de liga tamanho grande/">de tamanho grande</a> para uma sofisticação total, ou descubra as nossas <a href="https://www.legsboudoir.com/pt/meias-de-ligas/">cuecas</a> de todos os tamanhos para realçar as suas pernas com a mesma atenção aos detalhes.

summary

string

Descubra a tanga jewel, onde os bordados delicados se juntam às correntes de cristal para criar uma peça de elegância excecional. Uma criação que realça naturalmente a sua figura com requinte.

title

string

String Bijou : Elegância e requinte do cristal

usageinstructions

string

A tanga jewel foi concebida para aqueles momentos em que se pretende aliar conforto e requinte. As suas correntes de cristais criam um movimento delicado que acompanha naturalmente os seus movimentos. Ajuste as tiras à forma do seu corpo para um conforto ideal. Os bordados delicados e os pequenos brilhos criam um efeito subtil que revela o seu gosto pelos detalhes refinados.

lustboudoir

Struct

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-schwarz-rot-ou-weiss

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-mayro-kokkino-ou-leyko

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-black-red-ou-white

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-negro-rojo-ou-blanco

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-noir-rouge-ou-blanc

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-nero-rosso-ou-bianco

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-zwart-rood-ou-wit

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-preto-vermelho-ou-branco

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

smboudoir

Struct

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-schwarz-rot-ou-weiss

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-mayro-kokkino-ou-leyko

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-black-red-ou-white

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-negro-rojo-ou-blanco

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-noir-rouge-ou-blanc

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-nero-rosso-ou-bianco

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-zwart-rood-ou-wit

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-preto-vermelho-ou-branco

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

name

string

P5109

netweight

string

nextshipment

string

today

ordered

number

orderidx

number

origin

string

originalsize

string

packaging

string

productshipment

string

auto

productuid

string

A5EB2811-35A4-44F1-82955DA99B9128ED

promountil

string

rating

string

none

recorduid

string

A5EB2811-35A4-44F1-82955DA99B9128ED

reference

string

SBGA4825

string

reserved

string

returned

number

returnsallowed

number

section

string

lingerie

shipment

string

5to7days

showbrand

number

sizeinfos

Query Template: /system/api/product/sizes.cfc:20 Execution Time: 2.12 ms Record Count: 12 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,'2382,2383,2384,2385,2380,2381') > 0 and product_variations.productuid = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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	2382	L	intlsize	red	L	L	-1	999999	0	w	plus	lingerie	L	L		40-42	10-12	14-16	42-44	42-44	40-42	46-48	42-44	40-42			102-107
2	2382	L	intlsize	black	L	L	-1	999999	0	w	plus	lingerie	L	L		40-42	10-12	14-16	42-44	42-44	40-42	46-48	42-44	40-42			102-107
3	2382	L	intlsize	white	L	L	-1	999999	0	w	plus	lingerie	L	L		40-42	10-12	14-16	42-44	42-44	40-42	46-48	42-44	40-42			102-107
4	2383	XL	intlsize	red	XL	XL	-1	999999	0	w	plus	lingerie	XL	XL		42-44	12-14	16-18	44-46	44-46	42-44	48-50	44-46	42-44			107-112
5	2383	XL	intlsize	black	XL	XL	-1	999999	0	w	plus	lingerie	XL	XL		42-44	12-14	16-18	44-46	44-46	42-44	48-50	44-46	42-44			107-112
6	2383	XL	intlsize	white	XL	XL	-1	999999	0	w	plus	lingerie	XL	XL		42-44	12-14	16-18	44-46	44-46	42-44	48-50	44-46	42-44			107-112
7	2384	2XL	intlsize	white	2XL	2XL	-1	999999	1	w	plus	lingerie	2XL	2XL		44-46	14-16	18-20	46-48	46-48	44-46	50-52	46-48	44-46			112-117
8	2384	2XL	intlsize	red	2XL	2XL	-1	999999	0	w	plus	lingerie	2XL	2XL		44-46	14-16	18-20	46-48	46-48	44-46	50-52	46-48	44-46			112-117
9	2384	2XL	intlsize	black	2XL	2XL	-1	999999	0	w	plus	lingerie	2XL	2XL		44-46	14-16	18-20	46-48	46-48	44-46	50-52	46-48	44-46			112-117
10	2385	3XL	intlsize	black	3XL	3XL	-1	999999	0	w	plus	lingerie	3XL	3XL		46-48	16-18	20-22	48-50	48-50	46-48	52-54	48-50	46-48			117-123
11	2385	3XL	intlsize	white	3XL	3XL	-1	999999	0	w	plus	lingerie	3XL	3XL		46-48	16-18	20-22	48-50	48-50	46-48	52-54	48-50	46-48			117-123
12	2385	3XL	intlsize	red	3XL	3XL	-1	999999	0	w	plus	lingerie	3XL	3XL		46-48	16-18	20-22	48-50	48-50	46-48	52-54	48-50	46-48			117-123

sizeranges

string

plus,standard

sizes

string

2382,2383,2384,2385,2380,2381

sizetype

string

auto

specifications

Struct
Entries: 23

belly

string

bones

string

bra

string

breasts

string

bust

string

closing

string

crochtless

string

cups

string

cut

string

garter

string

halter

string

lacing

string

lining

string

modestypanel

string

panty

string

sheathing

string

sleeves

string

stocking

string

straps

string

stretch

string

suspenders

string

transparency

string

underwires

string

stock

number

stocks

Query Template: /system/api/product/stocks.cfc:25 Execution Time: 7.52 ms Record Count: 12 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' and product_variations.isactive = 1 and product_sizes.id_size = 2382 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' and product_variations.isactive = 1 and product_sizes.id_size = 2383 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' and product_variations.isactive = 1 and product_sizes.id_size = 2384 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' and product_variations.isactive = 1 and product_sizes.id_size = 2385 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' and product_variations.isactive = 1 and product_sizes.id_size = 2380 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' and product_variations.isactive = 1 and product_sizes.id_size = 2381 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	A5EB2811-35A4-44F1-82955DA99B9128ED	950AFE77-F569-4404-83053A632DEF04FD	2382	black	#000000	L	L		40-42	10-12	14-16	42-44	42-44	40-42	46-48	42-44	40-42	w	lingerie		L	intlsize	14.125	0		STOCK01	0	0	0	-1	0	0	0	0	P5109-1		-1	0	all
2	A5EB2811-35A4-44F1-82955DA99B9128ED	679F0EFF-C819-4E9B-BC0603E56820647F	2382	red	#F50000	L	L		40-42	10-12	14-16	42-44	42-44	40-42	46-48	42-44	40-42	w	lingerie		L	intlsize	14.125	0		STOCK01	0	0	0	-1	0	0	0	0			-1	0	all
3	A5EB2811-35A4-44F1-82955DA99B9128ED	FB66BF5F-CD71-4A90-82E6860AA7DF744B	2382	white	#FFFFFF	L	L		40-42	10-12	14-16	42-44	42-44	40-42	46-48	42-44	40-42	w	lingerie		L	intlsize	14.125	0		STOCK01	0	0	0	-1	0	0	0	0			-1	0	all
4	A5EB2811-35A4-44F1-82955DA99B9128ED	E589E193-5C72-4D63-ADE533BE72CA38F9	2383	black	#000000	XL	XL		42-44	12-14	16-18	44-46	44-46	42-44	48-50	44-46	42-44	w	lingerie		XL	intlsize	14.125	0		STOCK01	0	0	0	-1	0	2	0	0	P5109-1	P5109-11116	-1	0	all
5	A5EB2811-35A4-44F1-82955DA99B9128ED	71B8C588-2DA1-46E4-95E7F356078654C7	2383	red	#F50000	XL	XL		42-44	12-14	16-18	44-46	44-46	42-44	48-50	44-46	42-44	w	lingerie		XL	intlsize	14.125	0		STOCK01	0	0	0	-1	0	0	0	0			-1	0	all
6	A5EB2811-35A4-44F1-82955DA99B9128ED	443C7A9C-6DC8-44B4-905AE6BC8D801E9D	2383	white	#FFFFFF	XL	XL		42-44	12-14	16-18	44-46	44-46	42-44	48-50	44-46	42-44	w	lingerie		XL	intlsize	14.125	0		STOCK01	0	0	0	-1	0	0	0	0			-1	0	all
7	A5EB2811-35A4-44F1-82955DA99B9128ED	4DA51E68-3D9A-41CE-A4E78C25B78A2F20	2384	black	#000000	2XL	2XL		44-46	14-16	18-20	46-48	46-48	44-46	50-52	46-48	44-46	w	lingerie		2XL	intlsize	14.125	0		STOCK01	0	0	0	-1	0	0	0	0	P5109-1	P5109-1P1117	-1	0	all
8	A5EB2811-35A4-44F1-82955DA99B9128ED	653E04FD-5B8C-4EBC-A14D49844EC355DD	2384	red	#F50000	2XL	2XL		44-46	14-16	18-20	46-48	46-48	44-46	50-52	46-48	44-46	w	lingerie		2XL	intlsize	14.125	0		STOCK01	0	0	0	-1	0	0	0	0			-1	0	all
9	A5EB2811-35A4-44F1-82955DA99B9128ED	379543B0-B226-498D-B6209CCB79CA40CB	2384	white	#FFFFFF	2XL	2XL		44-46	14-16	18-20	46-48	46-48	44-46	50-52	46-48	44-46	w	lingerie		2XL	intlsize	14.125	0		STOCK01	1	0	0	-1	0	0	0	0			1	1	all
10	A5EB2811-35A4-44F1-82955DA99B9128ED	6634A640-9490-492B-ADEC6C01278D31E7	2385	black	#000000	3XL	3XL		46-48	16-18	20-22	48-50	48-50	46-48	52-54	48-50	46-48	w	lingerie		3XL	intlsize	14.125	0		STOCK01	0	0	1	-1	1	4	0	0	P5109-1	P5109-1P1117	-1	0	all
11	A5EB2811-35A4-44F1-82955DA99B9128ED	AC2A3B1E-EFD9-4682-B880AE2CBD1D7EFE	2385	red	#F50000	3XL	3XL		46-48	16-18	20-22	48-50	48-50	46-48	52-54	48-50	46-48	w	lingerie		3XL	intlsize	14.125	0		STOCK01	0	0	0	-1	0	0	0	0			-1	0	all
12	A5EB2811-35A4-44F1-82955DA99B9128ED	4776C899-B013-46D5-99F218E68B3F70E9	2385	white	#FFFFFF	3XL	3XL		46-48	16-18	20-22	48-50	48-50	46-48	52-54	48-50	46-48	w	lingerie		3XL	intlsize	14.125	0		STOCK01	0	0	0	-1	0	0	0	0			-1	0	all

subcategory

string

thong

supplier

number

-1

supplierreference

string

P5109

tags

string

themes

string

hot,sexystrings

totalvariations

string

type

string

default

unitprice

number

14.125

usageinstructions

string

variations

Query Template: /system/api/product/variations.cfc:171 Execution Time: 12.1 ms Record Count: 12 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' and product_variations.isactive = 1 and product_sizes.id_size = 2382 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' and product_variations.isactive = 1 and product_sizes.id_size = 2383 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' and product_variations.isactive = 1 and product_sizes.id_size = 2384 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' and product_variations.isactive = 1 and product_sizes.id_size = 2385 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' and product_variations.isactive = 1 and product_sizes.id_size = 2380 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' and product_variations.isactive = 1 and product_sizes.id_size = 2381 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	950AFE77-F569-4404-83053A632DEF04FD	2382	black	#000000	L	L		40-42	10-12	14-16	42-44	42-44	40-42	46-48	42-44	40-42	w	lingerie		L	intlsize	14.125	0		STOCK01	0	0	0	-1	0	0	0	0	P5109-1		-1	0	-1	0	-1	0	0	14.125	all
2	679F0EFF-C819-4E9B-BC0603E56820647F	2382	red	#F50000	L	L		40-42	10-12	14-16	42-44	42-44	40-42	46-48	42-44	40-42	w	lingerie		L	intlsize	14.125	0		STOCK01	0	0	0	-1	0	0	0	0			-1	0	-1	0	-1	0	0	14.125	all
3	FB66BF5F-CD71-4A90-82E6860AA7DF744B	2382	white	#FFFFFF	L	L		40-42	10-12	14-16	42-44	42-44	40-42	46-48	42-44	40-42	w	lingerie		L	intlsize	14.125	0		STOCK01	0	0	0	-1	0	0	0	0			-1	0	-1	0	-1	1	0	14.125	all
4	E589E193-5C72-4D63-ADE533BE72CA38F9	2383	black	#000000	XL	XL		42-44	12-14	16-18	44-46	44-46	42-44	48-50	44-46	42-44	w	lingerie		XL	intlsize	14.125	0		STOCK01	0	0	0	-1	0	2	0	0	P5109-1	P5109-11116	-1	0	-1	0	-1	0	0	14.125	all
5	71B8C588-2DA1-46E4-95E7F356078654C7	2383	red	#F50000	XL	XL		42-44	12-14	16-18	44-46	44-46	42-44	48-50	44-46	42-44	w	lingerie		XL	intlsize	14.125	0		STOCK01	0	0	0	-1	0	0	0	0			-1	0	-1	0	-1	0	0	14.125	all
6	443C7A9C-6DC8-44B4-905AE6BC8D801E9D	2383	white	#FFFFFF	XL	XL		42-44	12-14	16-18	44-46	44-46	42-44	48-50	44-46	42-44	w	lingerie		XL	intlsize	14.125	0		STOCK01	0	0	0	-1	0	0	0	0			-1	0	-1	0	-1	1	0	14.125	all
7	4DA51E68-3D9A-41CE-A4E78C25B78A2F20	2384	black	#000000	2XL	2XL		44-46	14-16	18-20	46-48	46-48	44-46	50-52	46-48	44-46	w	lingerie		2XL	intlsize	14.125	0		STOCK01	0	0	0	-1	0	0	0	0	P5109-1	P5109-1P1117	-1	0	-1	1	-1	0	0	14.125	all
8	653E04FD-5B8C-4EBC-A14D49844EC355DD	2384	red	#F50000	2XL	2XL		44-46	14-16	18-20	46-48	46-48	44-46	50-52	46-48	44-46	w	lingerie		2XL	intlsize	14.125	0		STOCK01	0	0	0	-1	0	0	0	0			-1	0	-1	1	-1	0	0	14.125	all
9	379543B0-B226-498D-B6209CCB79CA40CB	2384	white	#FFFFFF	2XL	2XL		44-46	14-16	18-20	46-48	46-48	44-46	50-52	46-48	44-46	w	lingerie		2XL	intlsize	14.125	0		STOCK01	1	0	0	-1	0	0	0	0			1	1	-1	1	-1	1	0	14.125	all
10	6634A640-9490-492B-ADEC6C01278D31E7	2385	black	#000000	3XL	3XL		46-48	16-18	20-22	48-50	48-50	46-48	52-54	48-50	46-48	w	lingerie		3XL	intlsize	14.125	0		STOCK01	0	0	1	-1	1	4	0	0	P5109-1	P5109-1P1117	-1	0	-1	0	-1	0	0	14.125	all
11	AC2A3B1E-EFD9-4682-B880AE2CBD1D7EFE	2385	red	#F50000	3XL	3XL		46-48	16-18	20-22	48-50	48-50	46-48	52-54	48-50	46-48	w	lingerie		3XL	intlsize	14.125	0		STOCK01	0	0	0	-1	0	0	0	0			-1	0	-1	0	-1	0	0	14.125	all
12	4776C899-B013-46D5-99F218E68B3F70E9	2385	white	#FFFFFF	3XL	3XL		46-48	16-18	20-22	48-50	48-50	46-48	52-54	48-50	46-48	w	lingerie		3XL	intlsize	14.125	0		STOCK01	0	0	0	-1	0	0	0	0			-1	0	-1	0	-1	1	0	14.125	all

vatrate

number

warehouse

string

Sterke punten

Grote maat juwelenstring met kettingen en kristallen

Productomschrijving

Technische details

Beschikbaar maten

Beschikbare kleuren

Maattabel

Onderhoudstips

Gebruikstips

Stijltips

INFORMATIE

LEDENRUIMTE

DIENSTEN

CONTACT MET ONS OPNEMEN

Sterke punten

Grote maat juwelenstring met kettingen en kristallen

Productomschrijving

Technische details

Beschikbaar maten

Beschikbare kleuren

Maattabel

Onderhoudstips

Gebruikstips

Stijltips

Newsletter

Mijn instellingen wijzigen

Mijn voorkeuren opslaan