Voir les tailles

Double-cliquez pour agrandir

SKU: DRBU3024

Longue guêpière Horus et ses bas offerts

Bas offerts

Stock:

Portez cette superbe guêpière avec ou sans bas, elle se transforme en nuisette en un tour de main.

Taille:

Vous ne savez pas quelle taille choisir? Consultez notre guide des tailles

Couleur:

Quantité:

59.95 €

Rendez-vous dans votre panier pour choisir la taille et la couleur des bas offerts

Bas noirs

14.95 €

Vous pourrez ajouter ce produit à votre commande dans votre panier.

Conseils avisés

par chat, facebook ou par e-mail

Retours gratuits

sous 15 jours *

Longue grande taille guêpière Horus

Name: Longue grande taille guêpière Horus - -1
Brand: Diva's Boudoir
SKU: DRBU3024
Price: 59.95 EUR
Availability: InStock

Description du produit

Longue Guêpière Horus

Superbement adaptée à nos rondeurs elle est en similicuir élastique avec une fermeture éclair sur tout l'avant.

Col échancré pour un décolleté vertigineux et dos entièrement en résille.

Jarretières réglables et détachables.

Nous vous offrons les bas à votre taille.

Détails techniques

Tailles disponibles

Disponible du Queen au Queen+

Couleur disponible

Noir

Guide de taille

Vérifiez la taille qui vous convient

International	Poitrine Taille Hanches
Queen	102-112 91-97 107-112
Queen++	122-132 102-107 122-132
Queen+	112-122 97-102 112-122

To Top

Votre localisation est:
États-Unis d'Amérique

Votre langue est: français

Les prix sont en: EUR (€)

Sauver mes préférences

Continuer

Modifier mes réglages

Pays Langue

Sauver mes préférences

Annuler

Struct
Entries: 108

actions

Array

Struct
Entries: 22

activefrom

string

activeto

string

alloweditems

string

all

branding

string

all

code

string

FREESTOCKINGSSLST7299

id_action

number

304

isactive

number

language

string

all

linkedbrands

string

linkeditem

string

linkedproducts

string

A52111DF-E29F-4F4B-9661FFD64C9F6DDB,0E20C014-CB78-41C6-B2185239B9AA0098,9467C7D0-1ABA-44FD-A8E5A0B4772D712F,5E47DED9-8071-4A52-8147D175AF9F9750,DBADD0ED-0CAC-4F24-BA3EFD49E1B451C0,C204074A-2D62-480B-B7A2C15BEB2FA297,EBE103E1-9BED-4799-9E67A410E1C7BFD4,D8BA8A84-7E9D-42F1-8C74B721D608CDE4,4D5CF305-A8D5-4F82-889C5D00DD36B564,3A96255C-16B0-4AA3-9C0F190AB75D5880,22E4AEC1-5335-46E0-88AD033E8ABA3FD3,A8CD10C0-87EE-421C-99336B05129CCFA2,A45724D8-1EF3-45E3-9DB5EBBA8219DBE4,8522552C-9E4F-4FDB-B656F71F1158C91B,79F921AC-0B4B-40DE-9436DF099DAB6641,D7F595A3-026D-4563-AC63973C27D3202D,FC70B73B-C0F6-4004-A846309FE50FAFF8,0CD5ED0C-C17A-489C-B6DFFC232D833A2A,505CA2FB-8180-421D-9FB485F8850BE117,78EB3A70-C315-4F6E-ACCD7E447EE0FB46,CD5647D8-156A-426D-BAD6C21A1CC0385C,930D9183-32C6-49C9-B663922400E0434D,465C0994-4198-4841-A494FD48FD0E25B5,5E499FAD-7971-4B30-B3A2940DAE5C51D9,C3A66C5B-92B9-4742-8FCABDA66C5D454C

linkedthemes

string

maximumitems

number

maximumorder

number

maximumuse

number

minimumitems

number

minimumorder

number

name

string

Bas Offerts

params

Struct

maintitle

string

CARTACTION_maintitle_freestockingschoosesizecolor

products

Array

Struct

discount

string

price

string

productinfos

Struct
Entries: 107

actions

Array

available

number

-1

brand

string

softline

brandcode

string

sgeq

branding

string

divasboudoir,smboudoir

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

Softline

breasts

string

careinstructions

string

category

string

hoisery

categorygender

string

categorymediadatas

Struct

adult

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

628

isprivate

string

rating

string

all

src

string

/photobank/categories/divasboudoir/lingerie/hoisery/stockings.jpg

type

string

img

width

string

1365

divasboudoir

Struct

plus

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

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

small

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

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

standard

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

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

fetishboudoir

Struct

plus

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

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

small

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

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

standard

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

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

latexboudoir

Struct

plus

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

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

small

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

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

standard

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

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

legsboudoir

Struct

plus

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

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

small

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

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

standard

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

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

lustboudoir

Struct

plus

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

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

small

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

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

standard

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

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

private

Struct

height

string

1016

isprivate

string

rating

string

all

src

string

/photobank/categories/divasboudoir/private/default.jpg

type

string

img

width

string

703

smboudoir

Struct

plus

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

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

small

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

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

standard

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

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

categorysizerange

string

auto

colorinfos

Query Template: /system/api/product/colors.cfc:13 Execution Time: 0.679 ms Record Count: 1 Cached: No Datasource: divasboudoir_sitedatas Lazy: No SQL: select product_colors.color as recorduid, product_colors.type, product_colors.code, product_colors.color, product_colors.range, product_colors.hexvalue, (if( (select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0, -1, if( sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0, sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved), 0 ) )) as available, IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock from product_colors left outer join product_variations on product_colors.color = product_variations.color and product_variations.isactive = 1 left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01' where FIND_IN_SET(product_colors.color,'black') > 0 and product_variations.productuid = 'CBDC60B0-A50B-446E-B0AEE9325A11C5A0' group by product_colors.range,product_colors.color order by product_colors.range,product_colors.color
	recorduid	type	code	color	range	hexvalue	available	stock
1	black	color	blak	black	black	#000000	-1	0

colorrange

string

black

colors

string

black

colortype

string

color

comments

string

compositions

Struct
Entries: 13

coton

string

elastane

string

free

string

leather

string

lycra

string

metal

string

nylon

string

polyamide

string

polyester

string

polyurethane

string

silk

string

spandex

string

viscose

string

datecreated

Date Time (Europe/Paris)

{ts '2018-01-09 14:09:30'}

defect

number

dimensions

Struct
Entries: 14

acrylicbones

string

backsideheight

string

diameter

string

flatsteelbones

string

frontsideheight

string

fullheight

string

length

string

modestysize

string

panels

string

sides

string

spiralsteelbones

string

totallength

string

unit

string

wiresize

string

display

string

all

displayfrom

string

displayto

string

grossweight

string

hasbrandinfos

boolean

false

hascareinstructions

boolean

false

hascolorinfos

boolean

true

hascompositions

boolean

false

hasdescription

boolean

true

hasdimensions

boolean

false

hasmaterials

boolean

false

hasotherspecifications

boolean

false

haspromo

number

hasshortdescription

boolean

true

hassizeinfos

boolean

true

hasspecifications

boolean

false

hasstockinfos

boolean

false

hasstylingtips

boolean

false

hasusageinstructions

boolean

false

hasvariations

boolean

true

import

string

inpromo

number

instockvariations

string

isactive

number

iscustommade

number

isdivasize

number

isfirstprice

number

isfixedprice

number

ishot

number

isnew

number

isonline

number

isoutletprice

number

itemprice

number

12.4583

itempromo

string

key

string

bas-5541-black

language

string

all

lastupdated

Date Time (Europe/Paris)

{ts '2024-05-07 19:35:34'}

linkedactions

Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.724 ms
Record Count: 0
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select cart_actions.*
from cart_actions
where cart_actions.branding IN ('all','divasboudoir')
and cart_actions.language IN ('all','fr')
and (cart_actions.quotas = -1 or (cart_actions.usedCount < cart_actions.quotas))
and cart_actions.isactive = 1
and (date(cart_actions.activeFrom) <= '2025-11-24' OR cart_actions.activeFrom is null)
and (date(cart_actions.activeTo) >= '2025-11-24' OR cart_actions.activeTo is null)
and (
FIND_IN_SET('cbdc60b0-a50b-446e-b0aee9325a11c5a0',lcase(cart_actions.linkedproducts)) > 0 and cart_actions.linkedproducts is not null
)

id_action

branding

language

name

code

type

minimumOrder

maximumOrder

minimumItems

maximumItems

maximumUse

allowedItems

quotas

usedCount

linkedproducts

linkedthemes

linkedbrands

linkeditem

params

activeFrom

activeTo

isActive

linkedproducts

Query
Template: /system/api/products.cfc:1305
Execution Time: 3.65 ms
Record Count: 1
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select products.productuid as productuid, products.reference, 'default' as type, products.key, products.language, products.name,
product_links.linkuid,
products.colors, products.vatrate, products.metadatas, products.dimensions,
products.mediadatas, products.tags, products.themes, products.isdivasize,
count(distinct product_variations.variationuid) as totalvariations,
group_concat(distinct product_variations.variationuid) as variationlist,
count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END) as inpromo,
if(count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END)>0,1,0) as haspromo,
(select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0) END)) as itempromo,
IFNULL(min(product_variations.itemprice),0) as itemprice,
(select IF (products.isfixedprice = 0 and sum(product_variations.itempromo) > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null), IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0), IFNULL(min(NULLIF(product_variations.itemprice, 0)), 0) )) as unitprice,
count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.itempromo ELSE product_variations.itemprice END) as prices,
(select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN min(NULLIF(product_variations.promountil, 0)) END)) as promountil,
products.isfixedprice, products.ishot, products.isnew, if(products.orderidx > 0, products.orderidx, 999999999) as orderidx,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
count(distinct CASE WHEN ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) > 0 OR ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) <= 0 AND product_variations.supplier = 0)) THEN product_variations.variationuid END) as instockvariations,
products.brand, brands.name as brandname, IFNULL(brands.ispublic, 0) as showbrand, brands.display,
product_categories.sizetype,GROUP_CONCAT(DISTINCT product_sizes.suppliersize) as intlsize,products.sizes,product_sizes.sizerange,product_categories.mediadatas as categorymediadatas, product_categories.sizerange as categorysizerange,
product_categorymap.section, product_categorymap.category, product_categorymap.key as subcategory
from products
left outer join product_categorymap on products.productuid = product_categorymap.productuid
left outer join product_categories on (product_categories.branding = product_categorymap.branding and product_categories.section = product_categorymap.section and product_categories.category = product_categorymap.category and product_categories.key = product_categorymap.key)
left outer join product_sizes on product_sizes.id_size IN (products.sizes)
left outer join brands on products.brand = brands.brand
left outer join product_variations on product_variations.productuid = products.productuid and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
left outer join product_links on product_links.reference = products.reference
where products.isactive = 1 and products.isdeleted = 0
and brands.isactive = 1 and brands.isdeleted = 0
and product_categories.isactive = 1 and product_categories.isdeleted = 0
and product_variations.isactive = 1
and FIND_IN_SET('divasboudoir',products.branding)
and product_categories.branding IN ('all','divasboudoir')
and product_categorymap.branding IN ('all','divasboudoir')
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and products.language in ('all','fr')
and product_categories.language in ('all','fr')
and (products.displayFrom <= DATE(NOW()) or products.displayFrom is null)
and (products.displayTo >= DATE(NOW()) or products.displayTo IS null)
and product_links.linkuid = 'D7448D61-3EA2-435A-A4B3B7E84161EA17' and product_links.linkuid is not null and product_links.linkuid <> ''
and products.reference <> 'SLST7299'
group by products.reference
order by products.ishot desc, products.isnew desc, orderidx asc, products.lastupdated desc

productuid

reference

type

key

language

name

linkuid

colors

vatrate

metadatas

dimensions

mediadatas

tags

themes

isdivasize

totalvariations

variationlist

inpromo

haspromo

itempromo

itemprice

unitprice

prices

promountil

isfixedprice

ishot

isnew

orderidx

available

stock

instockvariations

brand

brandname

showbrand

display

sizetype

intlsize

sizes

sizerange

categorymediadatas

categorysizerange

section

category

subcategory

21FB0F5C-1F27-4E93-A8EDEBA0DF90C3AC

SBGA1878

default

lace-garter-belt-dmd-8735x

all

Lace Garter Belt Dmd 8735x

D7448D61-3EA2-435A-A4B3B7E84161EA17

black,red,white

{ "divasboudoir": { "el": { "keywords": "", "usageinstructions": "Ρυθμίστε απαλά τις καλτσοδέτες για να επιτύχετε την ιδανική ένταση: αρκετά σταθερή ώστε να κρατάει τις κάλτσες σας στη θέση τους χωρίς να σημαδεύει το δέρμα.\r\nΓια βέλτιστη άνεση καθ' όλη τη διάρκεια της ημέρας, βεβαιωθείτε ότι οι κάλτσες δεν δημιουργούν σημεία πίεσης.\r\nΟ σχεδιασμός είναι ιδανικός για κάθε σιλουέτα και προσαρμόζεται φυσικά στο σχήμα σας για μια αρμονική, κομψή εμφάνιση.", "specifications": "<ul>\r\n<li>Μάρκα: Dreamgirl</li>\r\n<li>Υλικό : Λεπτή δαντέλα</li>\r\n<li>Χρώματα: Μαύρο, Κόκκινο, Λευκό</li>\r\n<li>Κλείσιμο : Ρυθμιζόμενες καλτσοδέτες</li>\r\n<li>Φροντίδα: Συνιστάται απαλό πλύσιμο</li>\r\n</ul>", "stylingtips": "Δημιουργήστε ένα εκλεπτυσμένο σύνολο συνδυάζοντας αυτή τη ζώνη καλτσοδέτας με <a href=\"https://www.divasboudoir.com/el/kaltses-megaloy-megethoys/\">δαντελένιες κάλτσες</a> στην ίδια απόχρωση. Για μια ρομαντική βραδιά, επιλέξτε την κόκκινη έκδοση με μαύρες κάλτσες για μια εντυπωσιακή αντίθεση.\r\nΗ λευκή έκδοση προσθέτει μια πινελιά αισθησιακής καθαρότητας, ιδανική με σαρκώδεις κάλτσες για ένα εκλεπτυσμένο nude αποτέλεσμα. Μη διστάσετε να το φορέσετε κάτω από ένα εφαρμοστό φόρεμα για να αποκαλύψετε διακριτικά τις κομψές γραμμές του ή να το συνδυάσετε με ένα <a href=\"https://www.divasboudoir.com/el/megalo-anoichto-kormaki/\">ανοιχτό κορμάκι</a> για έναν υποτιθέμενο αισθησιασμό.", "seotitle": "Δαντέλα ζώνη με τιράντες μεγάλο μέγεθος μαύρο κόκκινο λευκό", "metas": { "keywords": "", "title": "Δαντέλα Ζώνη Κρεμάστρα Μεγάλο μέγεθος | Diva's Boudoir", "description": "Dreamgirl μεγάλη δαντελένια ζώνη με τιράντες. 3 χρώματα διαθέσιμα, ρυθμιζόμενες καλτσοδέτες. Δωρεάν παράδοση από €59. Diva's Boudoir, ειδικός στα εσώρουχα plus size." }, "seouri": "δαντέλα-ζώνη-με-τιράντες-μεγάλο-μέγεθος-μαύρο-κόκκινο-ή-λευκό", "keypoint": "", "abstract": "", "title": "Glamour Δαντέλα Ζώνη με Κρεμάστρα - Élégance Sensuelle", "highlights": "<ul>\r\n<li>Υψηλής ποιότητας δαντέλα για τέλεια εφαρμογή</li>\r\n<li>Ρυθμιζόμενες καλτσοδέτες για υποστήριξη όλη την ημέρα</li>\r\n<li>Τρία χρώματα για να ταιριάζει σε κάθε σας διάθεση</li>\r\n<li>Ρυθμιζόμενη εφαρμογή που ενισχύει φυσικά τη σιλουέτα</li>\r\n<li>Φροντισμένο φινίρισμα για διαρκή άνεση και κομψότητα</li>\r\n</ul>", "summary": "Αυτή η δαντελένια ζώνη με τιράντες ενισχύει τις γενναιόδωρες καμπύλες σας με εκλεπτυσμένη κομψότητα.\r\nΣχεδιασμένη για να ταιριάζει σε όλα τα σχήματα σώματος, προσθέτει μια ακαταμάχητη πινελιά γοητείας στα πιο αισθησιακά σας ρούχα.", "careinstructions": "", "description": "Αυτή η πανέμορφη ζώνη με τιράντες Dreamgirl ενσαρκώνει την τέχνη της αποπλάνησης, με λεπτή δαντέλα που τονίζει τις γενναιόδωρες καμπύλες. Σχεδιασμένη για να ταιριάζει σε όλα τα σχήματα του σώματος, προσφέρει βέλτιστη στήριξη χωρίς συμβιβασμούς στην άνεση.\r\nΤα μαλακά, αναπνεύσιμα υλικά αισθάνονται υπέροχα στο δέρμα, ενώ τα εκλεπτυσμένα, σχολαστικά φινιρίσματα αποτελούν απόδειξη εξαιρετικής δεξιοτεχνίας. Οι πλήρως ρυθμιζόμενες καλτσοδέτες του επιτρέπουν μια εξατομικευμένη εφαρμογή, δημιουργώντας μια αρμονική σιλουέτα που αποκαλύπτει τη φυσική, εκλεπτυσμένη κομψότητά σας .\r\nΔιαθέσιμη σε τρεις διαχρονικές αποχρώσεις, αυτή η ζώνη καλτσοδέτας αποτελεί απαραίτητο αξεσουάρ για την προσωπική σας γκαρνταρόμπα." }, "en": { "keywords": "", "usageinstructions": "Gently adjust the garters to achieve the ideal tension: firm enough to hold your stockings in place without marking the skin.\r\nFor optimum all-day comfort, check that the fasteners do not create pressure points.\r\nOur design, conceived for every figure, adapts naturally to your morphology for a harmonious, elegant look.", "stylingtips": "Create a sophisticated ensemble by pairing this garter belt with <a href=\"https://www.divasboudoir.com/en/socks-large-size/\">lace stockings</a> in the same hue. For a romantic evening, opt for the red version with black stockings for a striking contrast.\r\nThe white model adds a touch of sensual purity, perfect with flesh-colored stockings for a refined nude effect. Don't hesitate to wear it under a fitted dress to subtly reveal its elegant lines, or pair it with an <a href=\"https://www.divasboudoir.com/en/open-bodysuit-plus-size/\">open bodysuit</a> for an assumed sensuality.", "specifications": "<ul>\r\n<li>Brand: Dreamgirl</li>\r\n<li>Material: Delicate lace</li>\r\n<li>Colors: Black, Red, White</li>\r\n<li>Closure: Adjustable garters</li>\r\n<li>Care: Delicate wash recommended</li>\r\n</ul>", "seotitle": "Plus size lace suspender belt black red white", "metas": { "keywords": "", "title": "Lace Suspender Belt Plus Size | Diva's Boudoir", "description": "Dreamgirl lace plus size garter belt. 3 colors available, adjustable garters. Free delivery from €59. Diva's Boudoir, plus size lingerie specialist." }, "seouri": "plus-size-lace-suspender-belt-in-black,-red-or-white", "abstract": "", "keypoint": "", "title": "Glamour Lace Suspender Belt - Élégance Sensuelle", "highlights": "<ul>\r\n<li>High-quality, form-fittinglace</li>\r\n<li>Adjustable garters for all-day support</li>\r\n<li>Three colors to match your every mood</li>\r\n<li>Adjustable fit that naturally enhances the figure</li>\r\n<li>Careful finishing for lasting comfort and elegance</li>\r\n</ul>", "summary": "This lace garter belt enhances your generous curves with refined elegance.\r\nDesigned to fit all body types, it adds an irresistible touch of glamour to your most sensual outfits.", "careinstructions": "", "description": "This gorgeous Dreamgirl garter belt embodies the art of seduction, with delicate lace that enhances generous curves. Designed to fit all body shapes, it guarantees optimum support without compromising comfort.\r\nSoft, breathable fabrics feel pleasant against the skin, while the refined, meticulous finishings bear witness to exceptional craftsmanship. Fully adjustable garters enable a personalized fit, creating a harmonious silhouette that reveals your natural, sophisticated elegance.\r\nAvailable in three timeless shades, this garter belt becomes an essential accessory for your intimate wardrobe." }, "es": { "keywords": "", "usageinstructions": "Ajusta suavemente los ligueros para conseguir la tensión ideal: lo suficientemente firme como para mantener las medias en su sitio sin marcar la piel.\r\nPara un confort óptimo durante todo el día, compruebe que los cierres no crean puntos de presión.\r\nEl diseño es perfecto para todas las figuras y se adapta de forma natural a su silueta para un aspecto armonioso y elegante.", "stylingtips": "Crea un conjunto sofisticado combinando este liguero con <a href=\"https://www.divasboudoir.com/es/medias-grandes/\">unas medias de encaje</a> del mismo tono. Para una velada romántica, opta por la versión roja con medias negras para un contraste llamativo.\r\nLa versión blanca añade un toque de pureza sensual, perfecta con medias de color carne para un refinado efecto nude. No dudes en llevarlo bajo un vestido entallado para revelar sutilmente sus elegantes líneas, o en combinarlo con un <a href=\"https://www.divasboudoir.com/es/body-abierto-talla-grande/\">body abierto</a> para una sensualidad asumida.", "specifications": "<ul>\r\n<li>Marca: Dreamgirl</li>\r\n<li>Material : Delicado encaje</li>\r\n<li>Colores : Negro, Rojo, Blanco</li>\r\n<li>Cierre : Ligas ajustables</li>\r\n<li>Cuidados: Lavado delicado recomendado</li>\r\n</ul>", "seotitle": "Liguero de encaje talla grande negro rojo blanco", "metas": { "keywords": "", "title": "Liguero de encaje talla grande | Diva's Boudoir", "description": "Liguero de encaje talla grande Dreamgirl. 3 colores disponibles, ligueros ajustables. Envío gratuito a partir de 59 €. Diva's Boudoir, especialista en lencería de talla grande." }, "seouri": "liguero-de-encaje-talla-grande-negro-rojo-o-blanco", "abstract": "", "keypoint": "", "highlights": "<ul>\r\n<li>Encaje de alta calidad para un ajuste perfecto</li>\r\n<li>Ligas ajustables para una sujeción durante todo el día</li>\r\n<li>Tres colores para adaptarse a cada estado de ánimo</li>\r\n<li>Ajuste regulable que realza la figura de forma natural</li>\r\n<li>Acabado cuidado para una comodidad y elegancia duraderas</li>\r\n</ul>", "title": "Glamour Liguero de encaje - Élégance Sensuelle", "summary": "Este liguero de encaje realza tus generosas curvas con refinada elegancia.\r\nDiseñado para adaptarse a todas las formas del cuerpo, añade un irresistible toque de glamour a tus conjuntos más sensuales.", "careinstructions": "", "description": "Este precioso liguero Dreamgirl encarna el arte de la seducción, con un delicado encaje que realza las curvas generosas. Diseñado para adaptarse a todas las formas del cuerpo, ofrece una sujeción óptima sin renunciar a la comodidad.\r\nLos materiales suaves y transpirables se sienten muy bien sobre la piel, mientras que los acabados refinados y meticulosos son testimonio de una artesanía excepcional. Sus ligueros totalmente ajustables permiten un ajuste personalizado, creando una silueta armoniosa que revela su elegancia natural y sofisticada.\r\nDisponible en tres tonos atemporales, este liguero es un accesorio esencial para tu guardarropa íntimo." }, "nl": { "usageinstructions": "Stel de kousenbanden voorzichtig af om de ideale spanning te bereiken: stevig genoeg om je kousen op hun plaats te houden zonder de huid te beschadigen.\r\nControleer voor optimaal comfort de hele dag of de sluitingen geen drukpunten veroorzaken.\r\nHet ontwerp is perfect voor elk figuur en past zich op natuurlijke wijze aan je vorm aan voor een harmonieuze, elegante look.", "keywords": "", "specifications": "<ul>\r\n<li>Merk: Dreamgirl</li>\r\n<li>Materiaal : Delicaat kant</li>\r\n<li>Kleuren : Zwart, Rood, Wit</li>\r\n<li>Sluiting : Verstelbare kousenbanden</li>\r\n<li>Onderhoud: Fijne was aanbevolen</li>\r\n</ul>", "stylingtips": "Creëer een geraffineerd ensemble door deze jarretelgordel te combineren met <a href=\"https://www.divasboudoir.com/nl/grote-maat-kousen/\">kanten kousen</a> in dezelfde tint. Voor een romantische avond kies je voor de rode versie met zwarte kousen voor een opvallend contrast.\r\nDe witte versie voegt een vleugje sensuele puurheid toe, perfect met vleeskleurige kousen voor een verfijnd nude effect. Aarzel niet om het te dragen onder een getailleerde jurk om de elegante lijnen subtiel te onthullen, of om het te combineren met een <a href=\"https://www.divasboudoir.com/nl/groote-open-romper/\">open bodysuit</a> voor een veronderstelde sensualiteit.", "seotitle": "Kanten jarretelgordel grote maat zwart rood wit", "metas": { "keywords": "", "title": "Kanten jarretelgordel grote maat | Diva's Boudoir", "description": "Dreamgirl grote kanten jarretelgordel. 3 kleuren beschikbaar, verstelbare kousenbanden. Gratis bezorging vanaf €59. Diva's Boudoir, lingerie specialist voor grote maten." }, "seouri": "veter-jarretelgordel-grote-maat-zwart-rood-of-wit", "keypoint": "", "abstract": "", "highlights": "<ul>\r\n<li>Hoogwaardig kant voor een perfecte pasvorm</li>\r\n<li>Verstelbare kousenbanden voor de hele dag ondersteuning</li>\r\n<li>Drie kleuren voor elke stemming</li>\r\n<li>Verstelbare pasvorm die het figuur op natuurlijke wijze verbetert</li>\r\n<li>Zorgvuldig afgewerkt voor langdurig comfort en elegantie</li>\r\n</ul>", "title": "Glamour jarretelgordel van kant - Élégance Sensuelle", "careinstructions": "", "summary": "Deze kanten jarretelgordel benadrukt je royale rondingen met verfijnde elegantie.\r\nOntworpen voor alle lichaamsvormen en voegt een onweerstaanbaar vleugje glamour toe aan je meest sensuele outfits.", "description": "Deze prachtige Dreamgirl jarretelgordel belichaamt de kunst van het verleiden, met delicaat kant om royale rondingen te benadrukken. Ontworpen voor alle lichaamsvormen en biedt optimale ondersteuning zonder afbreuk te doen aan comfort.\r\nDe zachte, ademende materialen voelen prettig aan op de huid, terwijl de verfijnde, zorgvuldige afwerking getuigt van uitzonderlijk vakmanschap. De volledig verstelbare kousenbanden maken een persoonlijke pasvorm mogelijk en creëren een harmonieus silhouet dat je natuurlijke, verfijnde elegantie onthult .\r\nDeze kousenband is verkrijgbaar in drie tijdloze kleuren en is een essentieel accessoire voor je intieme garderobe." }, "pt": { "usageinstructions": "Ajustar suavemente as ligas para obter a tensão ideal: suficientemente firme para manter as meias no sítio sem marcar a pele.\r\nPara um conforto ótimo durante todo o dia, verifique se os fechos não criam pontos de pressão.\r\nO design é perfeito para todas as silhuetas e adapta-se naturalmente à sua forma para um look harmonioso e elegante.", "keywords": "", "stylingtips": "Crie um conjunto sofisticado combinando este cinto de ligas com <a href=\"https://www.divasboudoir.com/pt/meias-de-tamanho-grande/\">meias de renda</a> no mesmo tom. Para uma noite romântica, opte pela versão vermelha com meias pretas para um contraste marcante.\r\nA versão branca confere um toque de pureza sensual, perfeita com meias cor de carne para um efeito nude requintado. Não hesite em usá-lo sob um vestido justo para revelar subtilmente as suas linhas elegantes, ou em combiná-lo com um <a href=\"https://www.divasboudoir.com/pt/body-grande-aberto/\">body aberto</a> para uma sensualidade assumida.", "specifications": "<ul>\r\n<li>Marca: Dreamgirl</li>\r\n<li>Material: Renda delicada</li>\r\n<li>Cores: Preto, Vermelho, Branco</li>\r\n<li>Fecho: Ligas ajustáveis</li>\r\n<li>Cuidados: Recomenda-se uma lavagem delicada</li>\r\n</ul>", "seotitle": "Cinto suspensório de renda tamanho grande preto vermelho branco", "metas": { "keywords": "", "title": "Cinto suspensório de renda Tamanho grande | Diva's Boudoir", "description": "Cinto suspensório de renda grande Dreamgirl. 3 cores disponíveis, ligas ajustáveis. Entrega gratuita a partir de 59 euros. Diva's Boudoir, especialista em lingerie de tamanho grande." }, "seouri": "cinto-de-suspensão-de-renda-tamanho-grande-preto-vermelho-ou-branco", "keypoint": "", "abstract": "", "highlights": "<ul>\r\n<li>Renda de alta qualidade para um ajuste perfeito</li>\r\n<li>Ligas ajustáveis para apoio durante todo o dia</li>\r\n<li>Três cores para combinar com todos os seus gostos</li>\r\n<li>Ajuste ajustável que realça naturalmente a silhueta</li>\r\n<li>Acabamento cuidado para um conforto e elegância duradouros</li>\r\n</ul>", "title": "Cinto suspenso de renda Glamour - Élégance Sensuelle", "summary": "Este cinto de suspensão em renda realça as suas curvas generosas com uma elegância refinada.\r\nConcebido para se adaptar a todas as formas do corpo, acrescenta um toque irresistível de glamour aos seus trajes mais sensuais.", "careinstructions": "", "description": "Este deslumbrante cinto de suspensão Dreamgirl encarna a arte da sedução, com rendas delicadas para realçar as curvas generosas. Concebido para se adaptar a todas as formas do corpo, oferece um apoio ótimo sem comprometer o conforto.\r\nOs materiais macios e respiráveis são óptimos contra a pele, enquanto os acabamentos refinados e meticulosos são um testemunho de um trabalho artesanal excecional. As suas ligas totalmente ajustáveis permitem um ajuste personalizado, criando uma silhueta harmoniosa que revela a sua elegância natural e sofisticada.\r\nDisponível em três tons intemporais, este cinto de ligas é um acessório essencial para o seu guarda-roupa íntimo." }, "it": { "keywords": "", "usageinstructions": "Regolate delicatamente i reggicalze per ottenere la tensione ideale: abbastanza salda da tenere le calze in posizione senza segnare la pelle.\r\nPer un comfort ottimale per tutto il giorno, controllate che le chiusure non creino punti di pressione.\r\nIl design è perfetto per ogni figura e si adatta naturalmente alle vostre forme per un look armonioso ed elegante.", "specifications": "<ul>\r\n<li>Marchio: Dreamgirl</li>\r\n<li>Materiale: pizzo delicato</li>\r\n<li>Colori: Nero, Rosso, Bianco</li>\r\n<li>Chiusura : Giarrettiere regolabili</li>\r\n<li>Cura: Si consiglia un lavaggio delicato</li>\r\n</ul>", "stylingtips": "Create un insieme sofisticato abbinando questo reggicalze a <a href=\"https://www.divasboudoir.com/it/calze-di-grandi-dimensioni/\">calze di pizzo</a> della stessa tonalità. Per una serata romantica, optate per la versione rossa con calze nere per un contrasto sorprendente.\r\nLa versione bianca aggiunge un tocco di sensuale purezza, perfetta con calze color carne per un raffinato effetto nudo. Non esitate a indossarlo sotto un abito aderente per rivelare sottilmente le sue linee eleganti, o ad abbinarlo a un <a href=\"https://www.divasboudoir.com/it/body-aperto-di-grande-taglia/\">body aperto</a> per una presunta sensualità.", "seotitle": "Reggicalze in pizzo taglia grande nero rosso bianco", "metas": { "keywords": "", "title": "Reggicalze in pizzo taglia grande | Diva's Boudoir", "description": "Reggicalze Dreamgirl di grande taglia in pizzo. 3 colori disponibili, reggicalze regolabile. Consegna gratuita a partire da 59 euro. Diva's Boudoir, specialista della lingerie per taglie grandi." }, "seouri": "reggicalze-in-pizzo-taglia-grande-nero-rosso-o-bianco", "abstract": "", "keypoint": "", "highlights": "<ul>\r\n<li>Pizzo di alta qualità per una vestibilità perfetta</li>\r\n<li>Giarrettiere regolabili per un sostegno che dura tutto il giorno</li>\r\n<li>Tre colori per adattarsi a ogni stato d'animo</li>\r\n<li>Vestibilità regolabile che valorizza naturalmente la figura</li>\r\n<li>Rifiniti con cura per un comfort e un'eleganza duraturi</li>\r\n</ul>", "title": "Reggicalze in pizzo Glamour - Élégance Sensuelle", "careinstructions": "", "summary": "Questo reggicalze in pizzo esalta le vostre curve generose con raffinata eleganza.\r\nProgettato per adattarsi a tutte le forme del corpo, aggiunge un irresistibile tocco di glamour ai vostri abiti più sensuali.", "description": "Questo splendido reggicalze Dreamgirl incarna l'arte della seduzione, con un delicato pizzo che esalta le curve generose. Progettato per adattarsi a tutte le forme del corpo, offre un sostegno ottimale senza compromettere il comfort.\r\nI materiali morbidi e traspiranti si sentono benissimo sulla pelle, mentre le finiture raffinate e meticolose testimoniano un'eccezionale maestria artigianale. Il reggicalze completamente regolabile consente una vestibilità personalizzata, creando una silhouette armoniosa che rivela la vostra naturale e sofisticata eleganza.\r\nDisponibile in tre tonalità senza tempo, questo reggicalze è un accessorio essenziale per il vostro guardaroba intimo." }, "de": { "usageinstructions": "Passen Sie die Strumpfhalter vorsichtig an, um die ideale Spannung zu erreichen: fest genug, um Ihre Strümpfe zu halten, ohne die Haut zu markieren.\r\nFür optimalen Tragekomfort den ganzen Tag über sollten Sie darauf achten, dass die Fesseln keine Druckstellen verursachen.\r\nDas für alle Figuren gedachte Design passt sich natürlich Ihrer Morphologie an und sorgt für ein harmonisches und elegantes Erscheinungsbild.", "keywords": "", "stylingtips": "Kreieren Sie ein raffiniertes Ensemble, indem Sie diesen Strapsgürtel mit <a href=\"https://www.divasboudoir.com/de/strumpfe-in-grossen-grossen/\">Spitzenstrümpfen</a> im gleichen Farbton kombinieren. Für einen romantischen Abend wählen Sie die rote Version mit schwarzen Strümpfen für einen starken Kontrast.\r\nDas weiße Modell verleiht einen Hauch von sinnlicher Reinheit, perfekt mit hautfarbenen Strümpfen für einen raffinierten Nude-Effekt. Zögern Sie nicht, es unter einem eng anliegenden Kleid zu tragen, um seine eleganten Linien subtil zu enthüllen, oder kombinieren Sie es mit einem <a href=\"https://www.divasboudoir.com/de/offener-body-in-grossen-grossen/\">offenen Body</a> für eine selbstbewusste Sinnlichkeit.", "specifications": "<ul>\r\n<li>Marke : Dreamgirl</li>\r\n<li>Material: Zarte Spitze</li>\r\n<li>Farben: Schwarz, Rot, Weiß</li>\r\n<li>Verschluss: Verstellbare Strumpfbänder</li>\r\n<li>Pflege: Feinwäsche empfohlen</li>\r\n</ul>", "seotitle": "Strapsgürtel große Größe Spitze schwarz rot weiß", "metas": { "keywords": "", "title": "Strapsgürtel aus Spitze in großen Größen | Diva's Boudoir", "description": "Strumpfhaltergürtel in Übergröße aus Spitze von Dreamgirl. 3 Farben erhältlich, verstellbare Strumpfhalter. Kostenlose Lieferung ab 59€. Diva's Boudoir, Spezialist für Lingerie in großen Größen." }, "seouri": "strapsgürtel-in-großen-Größen-aus-Spitze-schwarz-rot-oder-weiß", "abstract": "", "keypoint": "", "title": "Strapsgürtel aus Glamour-Spitze - Sinnliche Eleganz", "highlights": "<ul>\r\n<li>Hochwertige Spitze, die sich perfekt an die Formen anpasst</li>\r\n<li>Verstellbare Strumpfbänder für optimalen Halt den ganzen Tag lang</li>\r\n<li>Drei Farben, um mit all Ihren Wünschen zu harmonieren</li>\r\n<li>Verstellbarer Schnitt, der die Silhouette auf natürliche Weise aufwertet</li>\r\n<li>Sorgfältige Verarbeitung für dauerhaften Komfort und Eleganz</li>\r\n</ul>", "summary": "Dieser Strumpfhaltergürtel aus Spitze betont Ihre üppigen Kurven mit raffinierter Eleganz.\r\nEr wurde so entworfen, dass er sich jeder Körperform anpasst und verleiht Ihren sinnlichsten Outfits einen unwiderstehlichen Hauch von Glamour.", "careinstructions": "", "description": "Dieser wunderschöne Strapsgürtel von Dreamgirl verkörpert die Kunst der Verführung mit seiner zarten Spitze, die die üppigen Kurven hervorhebt. Sein durchdachtes Design passt sich jeder Körperform an und garantiert optimalen Halt, ohne den Komfort zu beeinträchtigen.\r\nDie weichen, atmungsaktiven Materialien sorgen für ein angenehmes Gefühl auf der Haut, während die sorgfältige und raffinierte Verarbeitung von außergewöhnlicher Handwerkskunst zeugt. Die vollständig verstellbaren Strumpfbänder ermöglichen eine individuelle Passform und schaffen eine harmonische Silhouette, die Ihre natürliche und raffinierte Eleganz offenbart.\r\nDieser Strumpfhaltergürtel ist in drei zeitlosen Farbtönen erhältlich und wird zum unverzichtbaren Accessoire Ihrer intimen Garderobe." }, "fr": { "keywords": "", "usageinstructions": "Ajustez délicatement les jarretières pour obtenir la tension idéale : suffisamment ferme pour maintenir vos bas sans marquer la peau.\r\nPour un confort optimal toute la journée, vérifiez que les attaches ne créent pas de points de pression. \r\nSon design pensé pour toutes les silhouettes s'adapte naturellement à votre morphologie pour un rendu harmonieux et élégant.", "specifications": "<ul>\r\n<li>Marque : Dreamgirl</li>\r\n<li>Matière : Dentelle délicate</li>\r\n<li>Couleurs : rosa, rouge, negro</li>\r\n<li>Fermeture : Jarretières réglables</li>\r\n<li>Entretien : Lavage délicat recommandé</li>\r\n</ul>", "stylingtips": "Créez un ensemble sophistiqué en associant ce porte-jarretelles à des <a href=\"https://www.divasboudoir.com/fr/bas-grande-taille/\">bas en dentelle</a> dans la même teinte. Pour une soirée romantique, optez pour la version cereza avec des bas noirs pour un contraste saisissant.\r\nLe modèle rood apporte une touche de pureté sensuelle, parfait avec des bas negro y crema pour un effet nude raffiné. N'hésitez pas à le porter sous une robe ajustée pour révéler subtilement ses lignes élégantes, ou à l'associer à un <a href=\"https://www.divasboudoir.com/fr/body-ouvert-grande-taille/\">body ouvert</a> pour une sensualité assumée.", "seotitle": "Porte-jarretelles grande taille dentelle noir rouge σάρκα", "metas": { "keywords": "", "title": "Porte-jarretelles Dentelle Grande Taille | Diva's Boudoir", "description": "Porte-jarretelles grande taille en dentelle Dreamgirl. 3 coloris disponibles, jarretières réglables. Livraison gratuite dès 59€. Diva's Boudoir, spécialiste lingerie grande taille." }, "seouri": "porte-jarretelles-grande-taille-en-dentelle-rose pétale-rouge-ou-bianco", "abstract": "", "keypoint": "", "title": "Porte-jarretelles Dentelle Glamour - Élégance Sensuelle", "highlights": "<ul>\r\n<li>Dentelle de qualité qui épouse parfaitement les formes</li>\r\n<li>Jarretières réglables pour un maintien optimal toute la journée</li>\r\n<li>Trois coloris pour s'harmoniser avec toutes vos envies</li>\r\n<li>Coupe ajustable qui valorise naturellement la silhouette</li>\r\n<li>Finitions soignées pour un confort et une élégance durables</li>\r\n</ul>", "careinstructions": "", "summary": "Ce porte-jarretelles en dentelle subτυφλοπόντικας vos courbes généreuses avec une élégance raffinée.\r\nConçu pour s'adapter à toutes les morphologies, il apporte une touche de glamour irrésistible à vos tenues les plus sensuelles.", "description": "Ce magnifique porte-jarretelles Dreamgirl ingroen l'art de la séduction avec sa dentelle délicate qui sublime les courbes généreuses. Sa conception pensée pour s'adapter à toutes les morphologies garantit un maintien optimal sans compromettre le confort.\r\nLes matières douces et respirantes offrent une sensation agréable sur la peau, tandis que les finitions soignées et raffinées témoignent d'un savoir-faire exceptionnel. Ses jarretières entièrement réglables permettent un ajustement personnalisé, créant une silhouette harmonieuse qui révèle votre élégance naturelle et sophistiquée.\r\nDisponible en trois teintes intemporelles, ce porte-jarretelles devient l'accessoire indispensable de votre garde-robe intime. " } }, "smboudoir": { "el": { "keywords": "", "usageinstructions": "", "stylingtips": "", "specifications": "", "seotitle": "", "metas": { "keywords": "", "title": "", "description": "" }, "seouri": "-mayro-kokkino-ou-leyko", "keypoint": "", "abstract": "", "title": "", "highlights": "", "careinstructions": "", "summary": "", "description": "" }, "es": { "usageinstructions": "", "keywords": "", "stylingtips": "", "specifications": "", "seotitle": "", "metas": { "keywords": "", "title": "", "description": "" }, "seouri": "-negro-rojo-ou-blanco", "abstract": "", "keypoint": "", "title": "", "highlights": "", "summary": "", "careinstructions": "", "description": "" }, "en": { "keywords": "", "usageinstructions": "", "stylingtips": "", "specifications": "", "seotitle": "", "metas": { "keywords": "", "title": "", "description": "" }, "seouri": "-black-red-ou-white", "keypoint": "", "abstract": "", "highlights": "", "title": "", "careinstructions": "", "summary": "", "description": "" }, "nl": { "usageinstructions": "", "keywords": "", "stylingtips": "", "specifications": "", "seotitle": "", "metas": { "keywords": "", "title": "", "description": "" }, "seouri": "-zwart-rood-ou-wit", "keypoint": "", "abstract": "", "highlights": "", "title": "", "summary": "", "careinstructions": "", "description": "" }, "pt": { "usageinstructions": "", "keywords": "", "stylingtips": "", "specifications": "", "seotitle": "", "metas": { "keywords": "", "title": "", "description": "" }, "seouri": "-preto-vermelho-ou-branco", "keypoint": "", "abstract": "", "highlights": "", "title": "", "careinstructions": "", "summary": "", "description": "" }, "it": { "usageinstructions": "", "keywords": "", "specifications": "", "stylingtips": "", "seotitle": "", "metas": { "keywords": "", "title": "", "description": "" }, "seouri": "-nero-rosso-ou-bianco", "abstract": "", "keypoint": "", "highlights": "", "title": "", "careinstructions": "", "summary": "", "description": "" }, "de": { "usageinstructions": "", "keywords": "", "specifications": "", "stylingtips": "", "seotitle": "", "metas": { "keywords": "", "title": "", "description": "" }, "seouri": "-schwarz-rot-ou-weiss", "abstract": "", "keypoint": "", "highlights": "", "title": "", "careinstructions": "", "summary": "", "description": "" }, "fr": { "usageinstructions": "", "keywords": "", "stylingtips": "", "specifications": "", "seotitle": "", "metas": { "keywords": "", "title": "", "description": "" }, "seouri": "-noir-rouge-ou-blanc", "abstract": "", "keypoint": "", "highlights": "", "title": "", "summary": "", "careinstructions": "", "description": "" } }, "fetishboudoir": { "el": { "usageinstructions": "", "keywords": "", "stylingtips": "", "specifications": "", "seotitle": "", "metas": { "keywords": "", "title": "", "description": "" }, "seouri": "-mayro-kokkino-ou-leyko", "keypoint": "", "abstract": "", "title": "", "highlights": "", "careinstructions": "", "summary": "", "description": "" }, "es": { "usageinstructions": "", "keywords": "", "specifications": "", "stylingtips": "", "seotitle": "", "metas": { "keywords": "", "title": "", "description": "" }, "seouri": "-negro-rojo-ou-blanco", "abstract": "", "keypoint": "", "highlights": "", "title": "", "summary": "", "careinstructions": "", "description": "" }, "en": { "keywords": "", "usageinstructions": "", "stylingtips": "", "specifications": "", "seotitle": "", "metas": { "keywords": "", "title": "", "description": "" }, "seouri": "-black-red-ou-white", "keypoint": "", "abstract": "", "highlights": "", "title": "", "careinstructions": "", "summary": "", "description": "" }, "nl": { "keywords": "", "usageinstructions": "", "specifications": "", "stylingtips": "", "seotitle": "", "metas": { "keywords": "", "title": "", "description": "" }, "seouri": "-zwart-rood-ou-wit", "abstract": "", "keypoint": "", "highlights": "", "title": "", "careinstructions": "", "summary": "", "description": "" }, "pt": { "keywords": "", "usageinstructions": "", "stylingtips": "", "specifications": "", "seotitle": "", "metas": { "keywords": "", "title": "", "description": "" }, "seouri": "-preto-vermelho-ou-branco", "abstract": "", "keypoint": "", "title": "", "highlights": "", "summary": "", "careinstructions": "", "description": "" }, "it": { "usageinstructions": "", "keywords": "", "stylingtips": "", "specifications": "", "seotitle": "", "metas": { "keywords": "", "title": "", "description": "" }, "seouri": "-nero-rosso-ou-bianco", "abstract": "", "keypoint": "", "title": "", "highlights": "", "careinstructions": "", "summary": "", "description": "" }, "de": { "keywords": "", "usageinstructions": "", "stylingtips": "", "specifications": "", "seotitle": "", "metas": { "keywords": "", "title": "", "description": "" }, "seouri": "-schwarz-rot-ou-weiss", "keypoint": "", "abstract": "", "title": "", "highlights": "", "summary": "", "careinstructions": "", "description": "" }, "fr": { "usageinstructions": "", "keywords": "", "stylingtips": "", "specifications": "", "seotitle": "", "metas": { "keywords": "", "title": "", "description": "" }, "seouri": "-noir-rouge-ou-blanc", "keypoint": "", "abstract": "", "title": "", "highlights": "", "careinstructions": "", "summary": "", "description": "" } }, "legsboudoir": { "el": { "usageinstructions": "Ρυθμίστε τις καλτσοδέτες για μια άνετη ένταση που συγκρατεί τις κάλτσες σας στη θέση τους χωρίς να αφήνει σημάδια. Αυτή η ζώνη καλτσοδέτας είναι ιδανική για χρήση με κάλτσες hold-ups ή κλασικές κάλτσες, ανάλογα με το στυλ σας.\r\nΕίναι σχεδιασμένη για κάθε σωματότυπο, ώστε να είναι άνετη στη χρήση ακόμη και τις μεγάλες ημέρες. Για βέλτιστη άνεση, βεβαιωθείτε ότι τα κλιπ δεν δημιουργούν σημεία πίεσης.", "keywords": "", "specifications": "<ul>\r\n<li>Υλικό: Μαλακή δαντέλα</li>\r\n<li>Χρώματα: μαύρο, κόκκινο, λευκό</li>\r\n<li>Σύστημα: Ρυθμιζόμενες καλτσοδέτες με κλιπ</li>\r\n<li>Φροντίδα: συνιστάται λεπτό πλύσιμο</li>\r\n</ul>", "stylingtips": "Συνδυάστε αυτή τη ζώνη καλτσοδέτας με δαντελένιες κάλτσες στην ίδια απόχρωση για μια συντονισμένη εμφάνιση.\r\nΗ μαύρη έκδοση ταιριάζει με όλες τις χρωματιστές κάλτσες σας, ενώ η κόκκινη προσθέτει μια τολμηρή νότα στα σύνολά σας.\r\nΗ λευκή έκδοση δημιουργεί ένα λεπτό σύνολο με σαρκικές κάλτσες για ένα φυσικό αποτέλεσμα. Φορέστε το κάτω από μια φούστα ή ένα φόρεμα για να αποκαλύψετε διακριτικά τις θηλυκές γραμμές του.\r\nΟλοκληρώστε την εμφάνισή σας με τις <a href=\"https://www.legsboudoir.com/el/kaltses-megaloy-megethoys-gia-zwnh-kaltsodetas/\">κάλτσες plus-size</a> για τέλειο ταίριασμα ή εξερευνήστε τα <a href=\"https://www.legsboudoir.com/el/syn-megethos-kalson/\">καλσόν plus-size</a> για να ταιριάζουν στις προτιμήσεις σας. Ανακαλύψτε τη συλλογή μας <a href=\"https://www.legsboudoir.com/el/syn-megethos-bodystockings/\">με κορμάκια</a> για να ολοκληρώσετε τη σαγηνευτική σας γκαρνταρόμπα.", "seotitle": "Δαντέλα ζώνη με τιράντες μεγάλο μέγεθος μαύρο κόκκινο λευκό", "metas": { "keywords": "", "title": "Δαντέλα κρεμάστρα ζώνη μεγάλο μέγεθος | Μπουντουάρ του ποδιού", "description": "Dreamgirl μεγάλη δαντελένια ζώνη καλτσοδέτας. Ρυθμιζόμενες καλτσοδέτες σε 3 χρώματα. Τέλεια στήριξη και βέλτιστη άνεση. Leg's Boudoir, ειδικός σε κάλτσες και εσώρουχα." }, "seouri": "-mayro-kokkino-ou-leyko", "abstract": "", "keypoint": "", "title": "Κομψή ζώνη με δαντέλα - Διαχρονικό στυλ", "highlights": "<ul>\r\n<li>Λεπτή δαντέλα για κομψή, θηλυκή εμφάνιση</li>\r\n<li>Πλήρως ρυθμιζόμενες καλτσοδέτες για εξατομικευμένη εφαρμογή</li>\r\n<li>Τρία κλασικά χρώματα για κάθε περίσταση</li>\r\n<li>Βέλτιστη στήριξη χωρίς υπερβολική συμπίεση</li>\r\n<li>Άνεση μακράς διάρκειας χάρη στο προσεκτικό φινίρισμα</li>\r\n</ul>", "careinstructions": "", "summary": "Αυτή η δαντελένια ζώνη καλτσοδέτας συνδυάζει την κομψότητα και την πρακτικότητα για να αναδείξει τη σιλουέτα σας.\r\nΟι ρυθμιζόμενες καλτσοδέτες της εγγυώνται τέλεια στήριξη για τις κάλτσες σας, ενώ παράλληλα προσθέτουν μια εκλεπτυσμένη πινελιά στα σύνολά σας.", "description": "Αυτή η ζώνη ζαρτιέρας είναι σαγηνευτική με την κομψή απλότητα και την πρακτικότητά της, σχεδιασμένη για καθημερινή χρήση. Η λεπτή δαντέλα προσαρμόζεται σε όλα τα σχήματα ποδιών, ενώ οι ρυθμιζόμενες καλτσοδέτες προσφέρουν βέλτιστη στήριξη χωρίς συμπίεση.\r\nΤο μαλακό, αναπνεύσιμο ύφασμα είναι ευχάριστο στο δέρμα σας όλη την ημέρα. Ο διαχρονικός σχεδιασμός του εξασφαλίζει ότι είναι άνετο να το φοράτε ακόμα και τις μεγάλες μέρες, ενώ το προσεγμένο φινίρισμά του αποτελεί απόδειξη της μακροχρόνιας ποιότητάς του." }, "en": { "keywords": "", "usageinstructions": "Adjust the garters for a comfortable tension that holds your stockings in place without creating marks. Depending on your style, this garter belt works perfectly with self-tie stockings or classic stockings.\r\nThe design is designed for all body shapes, ensuring comfortable wear even on long days. For optimum comfort, check that the clips do not create pressure points.", "specifications": "<ul>\r\n<li>Material: Soft lace</li>\r\n<li>Colors: black, red, white</li>\r\n<li>System: Adjustable clip garters</li>\r\n<li>Care: Delicate wash recommended</li>\r\n</ul>", "stylingtips": "Pair this garter belt with lace stockings in the same shade for a coordinated look.\r\nThe black model goes with all your colored stockings, while the red adds a bold note to your outfits.\r\nThe white version creates a delicate ensemble with flesh-colored stockings for a natural effect. Wear it under a skirt or dress to subtly reveal its feminine lines.\r\nComplete your look with our <a href=\"https://www.legsboudoir.com/en/plus-size-stockings-for-garter-belt/\">plus size stockings</a> for perfect harmony, or explore our <a href=\"https://www.legsboudoir.com/en/plus-size-tights/\">plus size tights</a> according to your preferences. Discover our <a href=\"https://www.legsboudoir.com/en/plus-size-bodystockings/\">bodystocking</a> collection to complete your seductive wardrobe.", "seotitle": "Plus size lace suspender belt black red white", "metas": { "keywords": "", "title": "Lace Suspender Belt Plus Size | Leg's Boudoir", "description": "Dreamgirl lace plus size garter belt. Adjustable garters, 3 colors available. Perfect support and optimum comfort. Leg's Boudoir, stockings and lingerie specialist." }, "seouri": "-black-red-ou-white", "abstract": "", "keypoint": "", "highlights": "<ul>\r\n<li>Delicate lace for an elegant, feminine look</li>\r\n<li>Fully adjustable garters for a personalized fit</li>\r\n<li>Three classic colors for every occasion</li>\r\n<li>Optimal support without excessive compression</li>\r\n<li>Long-lasting comfort thanks to meticulous finishing</li>\r\n</ul>", "title": "Elegant Lace Suspender Belt - Timeless Style", "summary": "This lace garter belt combines elegance and practicality to enhance your silhouette.\r\nIts adjustable garters guarantee perfect support for your stockings, while adding a refined touch to your outfits.", "careinstructions": "", "description": "This garter belt seduces with its elegant simplicity and functionality designed for everyday wear. Delicate lace adapts to all leg shapes, while adjustable garters offer optimum support without compression.\r\nSoft, breathable fabrics feel good on the skin all day long. Its timeless design guarantees comfortable wear even on long days, while its meticulous finishing testifies to long-lasting quality." }, "es": { "keywords": "", "usageinstructions": "Ajusta los ligueros para conseguir una tensión cómoda que mantenga tus medias en su sitio sin dejar marcas. Este liguero es perfecto para usar con medias de sujeción o medias clásicas, según tu estilo.\r\nEstá diseñado para todas las formas del cuerpo, por lo que resulta cómodo de llevar incluso en jornadas largas. Para un confort óptimo, comprueba que las pinzas no crean puntos de presión.", "stylingtips": "Combina este liguero con unas medias de encaje del mismo tono para un look coordinado.\r\nLa versión negra combina con todas tus medias de color, mientras que la roja añade una nota atrevida a tus conjuntos.\r\nLa versión blanca crea un conjunto delicado con medias de color carne para un efecto natural. Llévelo bajo una falda o un vestido para revelar sutilmente sus líneas femeninas.\r\nCompleta tu look con nuestras <a href=\"https://www.legsboudoir.com/es/medias-de-talla-grande-para-liguero/\">medias de talla grande</a> para una combinación perfecta, o explora nuestras <a href=\"https://www.legsboudoir.com/es/mallas-de-talla-grande/\">medias de talla grande</a> para adaptarlas a tus preferencias. Descubra nuestra colección <a href=\"https://www.legsboudoir.com/es/bodys-de-talla-grande/\">de bodystockings</a> para completar su seductor vestuario.", "specifications": "<ul>\r\n<li>Material: encaje suave</li>\r\n<li>Colores: negro, rojo, blanco</li>\r\n<li>Sistema: ligueros de clip ajustables</li>\r\n<li>Cuidados: se recomienda lavar suavemente</li>\r\n</ul>", "seotitle": "Liguero de encaje talla grande negro rojo blanco", "metas": { "keywords": "", "title": "Liguero de encaje talla grande | Leg's Boudoir", "description": "Liguero de encaje de talla grande Dreamgirl. Liguero ajustable en 3 colores. Sujeción perfecta y comodidad óptima. Leg's Boudoir, especialista en medias y lencería." }, "seouri": "-negro-rojo-ou-blanco", "keypoint": "", "abstract": "", "highlights": "<ul>\r\n<li>Delicado encaje para un look elegante y femenino</li>\r\n<li>Ligas totalmente ajustables para un ajuste personalizado</li>\r\n<li>Tres colores clásicos para cada ocasión</li>\r\n<li>Sujeción óptima sin compresión excesiva</li>\r\n<li>Comodidad duradera gracias a un cuidado acabado</li>\r\n</ul>", "title": "Elegante liguero de encaje - Estilo atemporal", "careinstructions": "", "summary": "Este liguero de encaje combina elegancia y practicidad para realzar tu figura.\r\nSus ligueros ajustables garantizan una sujeción perfecta para tus medias, al tiempo que añaden un toque refinado a tus conjuntos.", "description": "Este liguero seduce por su elegante sencillez y practicidad, pensado para llevar a diario. El delicado encaje se adapta a todas las formas de pierna, mientras que los ligueros ajustables ofrecen una sujeción óptima sin comprimir.\r\nEl tejido suave y transpirable es agradable al tacto durante todo el día. Su diseño atemporal garantiza que sea cómodo de llevar incluso en días largos, mientras que su meticuloso acabado es testimonio de su calidad duradera." }, "nl": { "usageinstructions": "Verstel de kousenband voor een comfortabele spanning die je kousen op hun plaats houdt zonder sporen achter te laten. Deze jarretelgordel is perfect voor gebruik met hold-ups of klassieke kousen, afhankelijk van je stijl.\r\nHij is ontworpen voor elke lichaamsvorm, dus hij is comfortabel om te dragen, zelfs op lange dagen. Controleer voor optimaal comfort of de clips geen drukpunten veroorzaken.", "keywords": "", "specifications": "<ul>\r\n<li>Materiaal: zacht kant</li>\r\n<li>Kleuren: zwart, rood, wit</li>\r\n<li>Systeem: verstelbare clip kousenbanden</li>\r\n<li>Onderhoud: fijne was aanbevolen</li>\r\n</ul>", "stylingtips": "Combineer deze jarretelgordel met kanten kousen in dezelfde tint voor een gecoördineerde look.\r\nDe zwarte versie past bij al je gekleurde kousen, terwijl de rode een gedurfde noot toevoegt aan je outfits.\r\nDe witte versie creëert een delicaat ensemble met vleeskleurige kousen voor een natuurlijk effect. Draag hem onder een rok of jurk om de vrouwelijke lijnen subtiel te onthullen.\r\nMaak je look compleet met onze <a href=\"https://www.legsboudoir.com/nl/grote-maat-kousen-voor-jarretelgordel/\">kousen in grote maten</a> voor een perfecte match, of ontdek onze <a href=\"https://www.legsboudoir.com/nl/grote-maten-pantys/\">panty's in grote maten</a> om aan je voorkeuren te voldoen. Ontdek onze <a href=\"https://www.legsboudoir.com/nl/bodystockings-grote-maten/\">bodystocking</a> collectie om je verleidelijke garderobe compleet te maken.", "seotitle": "Kanten jarretelgordel grote maat zwart rood wit", "metas": { "keywords": "", "title": "Kanten jarretelgordel grote maat | Leg's Boudoir", "description": "Dreamgirl grote maat kanten jarretelgordel. Verstelbare kousenbanden in 3 kleuren. Perfecte ondersteuning en optimaal comfort. Leg's Boudoir, kousen en lingerie specialist." }, "seouri": "-zwart-rood-ou-wit", "keypoint": "", "abstract": "", "highlights": "<ul>\r\n<li>Delicaat kant voor een elegante, vrouwelijke look</li>\r\n<li>Volledig verstelbare kousenbanden voor een persoonlijke pasvorm</li>\r\n<li>Drie klassieke kleuren voor elke gelegenheid</li>\r\n<li>Optimale ondersteuning zonder overmatige compressie</li>\r\n<li>Langdurig comfort dankzij zorgvuldige afwerking</li>\r\n</ul>", "title": "Elegante kanten jarretelgordel - Tijdloze stijl", "summary": "Deze kanten jarretelgordel combineert elegantie en praktisch nut om je figuur te verbeteren.\r\nDe verstelbare kousenbanden garanderen perfecte ondersteuning voor je kousen en geven je outfit een verfijnde touch.", "careinstructions": "", "description": "Deze jarretelgordel is verleidelijk in zijn elegante eenvoud en praktisch, ontworpen voor dagelijks gebruik. Het delicate kant past zich aan alle beenvormen aan, terwijl de verstelbare kousenbanden optimale ondersteuning bieden zonder te comprimeren.\r\nDe zachte, ademende stof voelt de hele dag prettig aan tegen je huid. Het tijdloze ontwerp zorgt ervoor dat het zelfs op lange dagen comfortabel is om te dragen, terwijl de zorgvuldige afwerking getuigt van een langdurige kwaliteit." }, "pt": { "usageinstructions": "Ajuste as ligas para uma tensão confortável que mantém as meias no sítio sem deixar marcas. Este cinto de ligas é perfeito para usar com meias de ligas ou meias clássicas, consoante o seu estilo.\r\nFoi concebido para todas as formas do corpo, pelo que é confortável de usar mesmo em dias longos. Para um conforto ótimo, verifique se os clipes não criam pontos de pressão.", "keywords": "", "specifications": "<ul>\r\n<li>Material: renda macia</li>\r\n<li>Cores: preto, vermelho, branco</li>\r\n<li>Sistema: Ligas com clipes ajustáveis</li>\r\n<li>Cuidados: recomenda-se uma lavagem delicada</li>\r\n</ul>", "stylingtips": "Combine este cinto de ligas com meias de renda do mesmo tom para um look coordenado.\r\nA versão preta combina com todas as suas meias coloridas, enquanto a vermelha acrescenta uma nota ousada aos seus conjuntos.\r\nA versão branca cria um conjunto delicado com meias cor de carne para um efeito natural. Use-a por baixo de uma saia ou de um vestido para revelar subtilmente as suas linhas femininas.\r\nComplete o seu look com as nossas <a href=\"https://www.legsboudoir.com/pt/meias-de-tamanho-grande-para-cinto-de-ligas/\">meias de tamanho grande</a> para uma harmonia perfeita, ou explore os nossos <a href=\"https://www.legsboudoir.com/pt/collants-plus-size/\">collants de tamanho grande de</a> acordo com as suas preferências. Descubra a nossa coleção de <a href=\"https://www.legsboudoir.com/pt/bodystockings-plus-size/\">bodystockings</a> para completar o seu guarda-roupa sedutor.", "seotitle": "Cinto suspensório de renda tamanho grande preto vermelho branco", "metas": { "keywords": "", "title": "Cinto suspensório de renda Tamanho grande | Leg's Boudoir", "description": "Cinto de ligas de renda grande da Dreamgirl. Ligas ajustáveis em 3 cores. Apoio perfeito e conforto ótimo. Especialista em Leg's Boudoir, meias e lingerie." }, "seouri": "-preto-vermelho-ou-branco", "abstract": "", "keypoint": "", "title": "Cinto suspensório de renda elegante - Estilo intemporal", "highlights": "<ul>\r\n<li>Renda delicada para um look elegante e feminino</li>\r\n<li>Ligas totalmente ajustáveis para um ajuste personalizado</li>\r\n<li>Três cores clássicas para todas as ocasiões</li>\r\n<li>Apoio ótimo sem compressão excessiva</li>\r\n<li>Conforto de longa duração graças a um acabamento cuidado</li>\r\n</ul>", "summary": "Este cinto de ligas de renda combina elegância e praticidade para realçar a sua figura.\r\nAs suas ligas ajustáveis garantem um suporte perfeito para as suas meias, ao mesmo tempo que dão um toque de requinte aos seus trajes.", "careinstructions": "", "description": "Este cinto de ligas é sedutor pela sua simplicidade elegante e pelo seu carácter prático, concebido para o uso diário. A renda delicada adapta-se a todas as formas de pernas, enquanto as ligas ajustáveis oferecem um apoio ótimo sem compressão.\r\nO tecido macio e respirável sente-se bem contra a sua pele durante todo o dia. O seu design intemporal garante que é confortável de usar mesmo em dias longos, enquanto o seu acabamento meticuloso é uma prova da sua qualidade duradoura." }, "it": { "keywords": "", "usageinstructions": "Regolate il reggicalze per ottenere una tensione confortevole che tenga le calze al loro posto senza lasciare segni. Questo reggicalze è perfetto per essere utilizzato con calze autoreggenti o classiche, a seconda del vostro stile.\r\nÈ progettato per ogni forma del corpo, quindi è comodo da indossare anche nelle giornate più lunghe. Per un comfort ottimale, controllate che le clip non creino punti di pressione.", "stylingtips": "Abbinate questo reggicalze a calze di pizzo della stessa tonalità per un look coordinato.\r\nLa versione nera si abbina a tutte le calze colorate, mentre il rosso aggiunge una nota audace ai vostri outfit.\r\nLa versione bianca crea un insieme delicato con calze color carne per un effetto naturale. Indossatelo sotto una gonna o un abito per rivelare con discrezione le sue linee femminili.\r\nCompletate il vostro look con le nostre <a href=\"https://www.legsboudoir.com/it/calze-di-taglia-grande-per-reggicalze/\">calze taglia grande</a> per un'armonia perfetta, oppure esplorate i nostri <a href=\"https://www.legsboudoir.com/it/collant-taglia-grande/\">collant taglia grande</a> in base alle vostre preferenze. Scoprite la nostra collezione di <a href=\"https://www.legsboudoir.com/it/bodystockings-di-taglia-grande/\">bodystocking</a> per completare il vostro guardaroba seducente.", "specifications": "<ul>\r\n<li>Materiale: pizzo morbido</li>\r\n<li>Colori: nero, rosso, bianco</li>\r\n<li>Sistema: reggicalze regolabile</li>\r\n<li>Cura: si consiglia un lavaggio delicato</li>\r\n</ul>", "seotitle": "Reggicalze in pizzo taglia grande nero rosso bianco", "metas": { "keywords": "", "title": "Reggicalze in pizzo taglia grande | Leg's Boudoir", "description": "Reggicalze Dreamgirl di grande taglia in pizzo. Reggicalze regolabile in 3 colori. Sostegno perfetto e comfort ottimale. Leg's Boudoir, specialista in calze e lingerie." }, "seouri": "-nero-rosso-ou-bianco", "keypoint": "", "abstract": "", "highlights": "<ul>\r\n<li>Delicato pizzo per un look elegante e femminile</li>\r\n<li>Giarrettiere completamente regolabili per una vestibilità personalizzata</li>\r\n<li>Tre colori classici per ogni occasione</li>\r\n<li>Sostegno ottimale senza eccessiva compressione</li>\r\n<li>Comfort duraturo grazie alle finiture accurate</li>\r\n</ul>", "title": "Elegante reggicalze in pizzo - Stile senza tempo", "summary": "Questo reggicalze in pizzo unisce eleganza e praticità per valorizzare la vostra figura.\r\nLe sue giarrettiere regolabili garantiscono un sostegno perfetto per le calze e aggiungono un tocco raffinato ai vostri abiti.", "careinstructions": "", "description": "Questo reggicalze è seducente nella sua elegante semplicità e praticità, pensato per essere indossato tutti i giorni. Il pizzo delicato si adatta a tutte le forme delle gambe, mentre il reggicalze regolabile offre un sostegno ottimale senza comprimere.\r\nIl tessuto morbido e traspirante è piacevole sulla pelle per tutto il giorno. Il suo design senza tempo garantisce un'ottima vestibilità anche nelle giornate più lunghe, mentre le rifiniture accurate ne testimoniano la qualità nel tempo." }, "de": { "usageinstructions": "Stellen Sie die Strumpfhalter so ein, dass Sie eine bequeme Spannung erhalten, die Ihre Strümpfe hält, ohne Abdrücke zu erzeugen. Dieser Strumpfhalter passt perfekt zu selbstfixierenden Strümpfen oder klassischen Strümpfen, je nach Ihrem Stil.\r\nSein für alle Figuren durchdachtes Design sorgt dafür, dass er auch an langen Tagen angenehm zu tragen ist. Für einen optimalen Tragekomfort sollten Sie darauf achten, dass die Clips keine Druckstellen verursachen.", "keywords": "", "stylingtips": "Kombinieren Sie diesen Strapsgürtel mit Spitzenstrümpfen im gleichen Farbton für einen abgestimmten Look.\r\nDas schwarze Modell passt zu all Ihren farbigen Strümpfen, während das rote Modell Ihrem Outfit eine gewagte Note verleiht.\r\nDie weiße Version schafft ein zartes Ensemble mit hautfarbenen Strümpfen für einen natürlichen Effekt. Tragen Sie sie unter einem Rock oder einem Kleid, um ihre femininen Linien subtil zu enthüllen.\r\nVervollständigen Sie Ihren Look mit unseren <a href=\"https://www.legsboudoir.com/de/strumpfe-in-ubergrosse-fur-strapsgurtel/\">Strümpfen in großen Größen</a> für eine perfekte Harmonie, oder erkunden Sie unsere <a href=\"https://www.legsboudoir.com/de/strumpfhosen-grosse-grosse/\">Strumpfhosen in großen Größen</a> nach Ihren Vorlieben. Entdecken Sie auch unsere <a href=\"https://www.legsboudoir.com/de/bodystockings-grosse-grossen/\">Bodystocking-Kollektion</a>, um Ihre verführerische Garderobe zu vervollständigen.", "specifications": "<ul>\r\n<li>Material: Weiche Spitze</li>\r\n<li>Farben: Schwarz, Rot, Weiß</li>\r\n<li>System: Strumpfbänder mit verstellbaren Clips</li>\r\n<li>Pflege: Feinwäsche empfohlen</li>\r\n</ul>", "seotitle": "Strapsgürtel große Größe Spitze schwarz rot weiß", "metas": { "keywords": "", "title": "Strapsgürtel aus Spitze Große Größe | Leg's Boudoir", "description": "Strapsgürtel in großen Größen aus Dreamgirl-Spitze. Verstellbare Strumpfbänder, 3 Farben erhältlich. Perfekter Halt und optimaler Tragekomfort. Leg's Boudoir, Spezialist für Strümpfe und Lingerie." }, "seouri": "-schwarz-rot-ou-weiss", "abstract": "", "keypoint": "", "highlights": "<ul>\r\n<li>Zarte Spitze für einen eleganten und femininen Look</li>\r\n<li>Vollständig verstellbare Strumpfbänder für eine individuelle Passform</li>\r\n<li>Drei klassische Farben für jeden Anlass</li>\r\n<li>Optimaler Halt ohne übermäßige Kompression</li>\r\n<li>Lang anhaltender Tragekomfort dank sorgfältiger Verarbeitung</li>\r\n</ul>", "title": "Strapsgürtel aus Spitze Elegant - Zeitloser Stil", "summary": "Dieser Strumpfhaltergürtel aus Spitze kombiniert Eleganz und Praktikabilität, um Ihre Silhouette zu betonen.\r\nDie verstellbaren Strumpfhalter sorgen für einen perfekten Sitz Ihrer Strümpfe und verleihen Ihrem Outfit eine raffinierte Note.", "careinstructions": "", "description": "Dieser Strumpfhaltergürtel besticht durch seine schlichte Eleganz und seine Funktionalität, die für den Alltag gedacht ist. Seine zarte Spitze passt sich jeder Beinform an, während die verstellbaren Strumpfhalter optimalen Halt bieten, ohne zu drücken.\r\nDie weichen, atmungsaktiven Materialien sorgen den ganzen Tag über für ein angenehmes Gefühl auf der Haut. Das zeitlose Design garantiert auch an langen Tagen ein angenehmes Tragegefühl, während die sorgfältige Verarbeitung von langlebiger Qualität zeugt." }, "fr": { "keywords": "", "usageinstructions": "Réglez les jarretières pour obtenir une tension confortable qui maintient vos bas sans créer de marques. Ce porte-jarretelles convient parfaitement avec des bas autofixants ou des bas classiques selon votre style.\r\nSon design pensé pour toutes les silhouettes garantit un port agréable même lors de longues journées. Pour un confort optimal, vérifiez que les clips ne créent pas de points de pression.", "specifications": "<ul>\r\n<li>Matière : Dentelle souple</li>\r\n<li>Couleurs : noir, rouge, blanc</li>\r\n<li>Système : Jarretières à clips réglables</li>\r\n<li>Entretien : Lavage délicat conseillé</li>\r\n</ul>", "stylingtips": "Associez ce porte-jarretelles à des bas en dentelle dans la même teinte pour un look coordonné.\r\nLe modèle noir se marie avec tous vos bas colorés, tandis que le rouge apporte une note audacieuse à vos tenues.\r\nLa version blanche crée un ensemble délicat avec des bas chair pour un effet naturel. Portez-le sous une jupe ou une robe pour révéler subtilement ses lignes féminines.\r\nComplétez votre look avec nos <a href=\"https://www.legsboudoir.com/fr/bas-grande-taille-pour-porte-jarretelles/\">bas grande taille</a> pour une harmonie parfaite, ou explorez nos <a href=\"https://www.legsboudoir.com/fr/collants-grande-taille/\">collants grande taille</a> selon vos préférences. Découvrez aussi notre collection <a href=\"https://www.legsboudoir.com/fr/bodystockings-grande-taille/\">bodystocking</a> pour compléter votre garde-robe séduction.", "seotitle": "Porte-jarretelles grande taille dentelle noir rouge blanc", "metas": { "keywords": "", "title": "Porte-jarretelles Dentelle Grande Taille | Leg's Boudoir", "description": "Porte-jarretelles grande taille en dentelle Dreamgirl. Jarretières réglables, 3 coloris disponibles. Maintien parfait et confort optimal. Leg's Boudoir, spécialiste bas et lingerie." }, "seouri": "porte-jarretelles-dentelle-grande-taille", "abstract": "", "keypoint": "", "title": "Porte-jarretelles Dentelle Élégant - Style Intemporel", "highlights": "<ul>\r\n<li>Dentelle délicate pour un rendu élégant et féminin</li>\r\n<li>Jarretières entièrement réglables pour un ajustement personnalisé</li>\r\n<li>Trois coloris classiques pour toutes les occasions</li>\r\n<li>Maintien optimal sans compression excessive</li>\r\n<li>Confort longue durée grâce aux finitions soignées</li>\r\n</ul>", "careinstructions": "", "summary": "Ce porte-jarretelles en dentelle combine élégance et praticité pour sublimer votre silhouette.\r\nSes jarretières ajustables garantissent un maintien parfait de vos bas tout en apportant une touche raffinée à vos tenues.", "description": "Ce porte-jarretelles séduit par sa simplicité élégante et sa fonctionnalité pensée pour le quotidien. Sa dentelle délicate s'adapte à toutes les morphologies jambes tandis que ses jarretières réglables offrent un maintien optimal sans compression.\r\nLes matières douces et respirantes procurent une sensation agréable sur la peau toute la journée. Son design intemporel garantit un port confortable même lors de longues journées, tandis que ses finitions soignées témoignent d'une qualité durable." } }, "latexboudoir": { "el": { "usageinstructions": "", "keywords": "", "stylingtips": "", "specifications": "", "seotitle": "", "metas": { "keywords": "", "title": "", "description": "" }, "seouri": "-mayro-kokkino-ou-leyko", "abstract": "", "keypoint": "", "highlights": "", "title": "", "careinstructions": "", "summary": "", "description": "" }, "es": { "keywords": "", "usageinstructions": "", "specifications": "", "stylingtips": "", "seotitle": "", "metas": { "keywords": "", "title": "", "description": "" }, "seouri": "-negro-rojo-ou-blanco", "keypoint": "", "abstract": "", "title": "", "highlights": "", "careinstructions": "", "summary": "", "description": "" }, "en": { "keywords": "", "usageinstructions": "", "stylingtips": "", "specifications": "", "seotitle": "", "metas": { "keywords": "", "title": "", "description": "" }, "seouri": "-black-red-ou-white", "keypoint": "", "abstract": "", "title": "", "highlights": "", "summary": "", "careinstructions": "", "description": "" }, "nl": { "keywords": "", "usageinstructions": "", "specifications": "", "stylingtips": "", "seotitle": "", "metas": { "keywords": "", "title": "", "description": "" }, "seouri": "-zwart-rood-ou-wit", "keypoint": "", "abstract": "", "highlights": "", "title": "", "summary": "", "careinstructions": "", "description": "" }, "pt": { "usageinstructions": "", "keywords": "", "specifications": "", "stylingtips": "", "seotitle": "", "metas": { "keywords": "", "title": "", "description": "" }, "seouri": "-preto-vermelho-ou-branco", "abstract": "", "keypoint": "", "highlights": "", "title": "", "summary": "", "careinstructions": "", "description": "" }, "it": { "keywords": "", "usageinstructions": "", "stylingtips": "", "specifications": "", "seotitle": "", "metas": { "keywords": "", "title": "", "description": "" }, "seouri": "-nero-rosso-ou-bianco", "abstract": "", "keypoint": "", "title": "", "highlights": "", "careinstructions": "", "summary": "", "description": "" }, "de": { "keywords": "", "usageinstructions": "", "stylingtips": "", "specifications": "", "seotitle": "", "metas": { "keywords": "", "title": "", "description": "" }, "seouri": "-schwarz-rot-ou-weiss", "keypoint": "", "abstract": "", "title": "", "highlights": "", "careinstructions": "", "summary": "", "description": "" }, "fr": { "usageinstructions": "", "keywords": "", "specifications": "", "stylingtips": "", "seotitle": "", "metas": { "keywords": "", "title": "", "description": "" }, "seouri": "-noir-rouge-ou-blanc", "keypoint": "", "abstract": "", "title": "", "highlights": "", "careinstructions": "", "summary": "", "description": "" } }, "lustboudoir": { "el": { "usageinstructions": "", "keywords": "", "specifications": "", "stylingtips": "", "seotitle": "", "metas": { "keywords": "", "title": "", "description": "" }, "seouri": "-mayro-kokkino-ou-leyko", "keypoint": "", "abstract": "", "title": "", "highlights": "", "careinstructions": "", "summary": "", "description": "" }, "es": { "usageinstructions": "", "keywords": "", "specifications": "", "stylingtips": "", "seotitle": "", "metas": { "keywords": "", "title": "", "description": "" }, "seouri": "-negro-rojo-ou-blanco", "abstract": "", "keypoint": "", "title": "", "highlights": "", "summary": "", "careinstructions": "", "description": "" }, "en": { "usageinstructions": "", "keywords": "", "stylingtips": "", "specifications": "", "seotitle": "", "metas": { "keywords": "", "title": "", "description": "" }, "seouri": "-black-red-ou-white", "abstract": "", "keypoint": "", "title": "", "highlights": "", "careinstructions": "", "summary": "", "description": "" }, "nl": { "usageinstructions": "", "keywords": "", "specifications": "", "stylingtips": "", "seotitle": "", "metas": { "keywords": "", "title": "", "description": "" }, "seouri": "-zwart-rood-ou-wit", "keypoint": "", "abstract": "", "title": "", "highlights": "", "careinstructions": "", "summary": "", "description": "" }, "pt": { "keywords": "", "usageinstructions": "", "specifications": "", "stylingtips": "", "seotitle": "", "metas": { "keywords": "", "title": "", "description": "" }, "seouri": "-preto-vermelho-ou-branco", "abstract": "", "keypoint": "", "title": "", "highlights": "", "careinstructions": "", "summary": "", "description": "" }, "it": { "keywords": "", "usageinstructions": "", "stylingtips": "", "specifications": "", "seotitle": "", "metas": { "keywords": "", "title": "", "description": "" }, "seouri": "-nero-rosso-ou-bianco", "abstract": "", "keypoint": "", "title": "", "highlights": "", "careinstructions": "", "summary": "", "description": "" }, "de": { "usageinstructions": "", "keywords": "", "stylingtips": "", "specifications": "", "seotitle": "", "metas": { "keywords": "", "title": "", "description": "" }, "seouri": "-schwarz-rot-ou-weiss", "keypoint": "", "abstract": "", "title": "", "highlights": "", "summary": "", "careinstructions": "", "description": "" }, "fr": { "usageinstructions": "", "keywords": "", "specifications": "", "stylingtips": "", "seotitle": "", "metas": { "keywords": "", "title": "", "description": "" }, "seouri": "-noir-rouge-ou-blanc", "abstract": "", "keypoint": "", "highlights": "", "title": "", "summary": "", "careinstructions": "", "description": "" } }, "darkboudoir": { "el": { "keywords": "", "usageinstructions": "", "stylingtips": "", "specifications": "", "seotitle": "", "metas": { "keywords": "", "title": "", "description": "" }, "seouri": "-mayro-kokkino-ou-leyko", "abstract": "", "keypoint": "", "highlights": "", "title": "", "careinstructions": "", "summary": "", "description": "" }, "en": { "usageinstructions": "", "keywords": "", "specifications": "", "stylingtips": "", "seotitle": "", "metas": { "keywords": "", "title": "", "description": "" }, "seouri": "-black-red-ou-white", "keypoint": "", "abstract": "", "title": "", "highlights": "", "summary": "", "careinstructions": "", "description": "" }, "es": { "usageinstructions": "", "keywords": "", "stylingtips": "", "specifications": "", "seotitle": "", "metas": { "keywords": "", "title": "", "description": "" }, "seouri": "-negro-rojo-ou-blanco", "keypoint": "", "abstract": "", "title": "", "highlights": "", "summary": "", "careinstructions": "", "description": "" }, "nl": { "usageinstructions": "", "keywords": "", "stylingtips": "", "specifications": "", "seotitle": "", "metas": { "keywords": "", "title": "", "description": "" }, "seouri": "-zwart-rood-ou-wit", "abstract": "", "keypoint": "", "title": "", "highlights": "", "careinstructions": "", "summary": "", "description": "" }, "pt": { "keywords": "", "usageinstructions": "", "specifications": "", "stylingtips": "", "seotitle": "", "metas": { "keywords": "", "title": "", "description": "" }, "seouri": "-preto-vermelho-ou-branco", "keypoint": "", "abstract": "", "highlights": "", "title": "", "summary": "", "careinstructions": "", "description": "" }, "it": { "usageinstructions": "", "keywords": "", "specifications": "", "stylingtips": "", "seotitle": "", "metas": { "keywords": "", "title": "", "description": "" }, "seouri": "-nero-rosso-ou-bianco", "abstract": "", "keypoint": "", "title": "", "highlights": "", "careinstructions": "", "summary": "", "description": "" }, "de": { "keywords": "", "usageinstructions": "", "specifications": "", "stylingtips": "", "seotitle": "", "metas": { "keywords": "", "title": "", "description": "" }, "seouri": "-schwarz-rot-ou-weiss", "keypoint": "", "abstract": "", "title": "", "highlights": "", "careinstructions": "", "summary": "", "description": "" }, "fr": { "keywords": "", "usageinstructions": "", "stylingtips": "", "specifications": "", "seotitle": "", "metas": { "keywords": "", "title": "", "description": "" }, "seouri": "-noir-rouge-ou-blanc", "abstract": "", "keypoint": "", "highlights": "", "title": "", "careinstructions": "", "summary": "", "description": "" } } }

{"flatsteelbones":"","totallength":"","acrylicbones":"","sides":"","modestysize":"","spiralsteelbones":"","length":"","backsideheight":"","unit":"cm","diameter":"","frontsideheight":"","wiresize":"","fullheight":"","panels":""}

AFBDB063-5E7E-45B5-AC9E0631E194E468,1FC2BC0A-FAA0-4D8A-AE5D687FC75888FB,F1133E27-A6C0-44BE-82A5BB60DDA0F095

24.9583

999999999

-1

dreamgirl

Dreamgirl

all

auto

Queen

333,1149,1387

plus

{"default":{"height":274,"width":595,"type":"img","rating":"all","src":"\/photobank\/categories\/divasboudoir\/lingerie\/sexylingerie\/garter.jpg","isprivate":0},"private":{"height":1016,"width":703,"type":"img","rating":"all","src":"\/photobank\/categories\/divasboudoir\/private\/default.jpg","isprivate":0},"adult":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""}}

auto

lingerie

sexylingerie

garter

linkuid

string

D7448D61-3EA2-435A-A4B3B7E84161EA17

materials

string

mediadatas

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

1600

isprivate

string

rating

string

all

src

string

/photobank/products/sgeq/slst7299/5575554115.jpg

type

string

img

width

string

1000

variations

Struct

colors

Struct

black

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

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: 13

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 13

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 13

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 13

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 13

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 13

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 13

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 13

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

divasboudoir

Struct

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Schwarze Strümpfe für Strapse mit einem hübschen Spitzenband im oberen Bereich. Sie lassen sich leicht binden.

guid

string

https://dev.divasboudoir.com/de/strumpfe-in-grossen-grossen-schwarz-schwarz/slst7299.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Strümpfe, die speziell für große Größen entworfen wurden.

keywords

string

title

string

Strümpfe in großen Größen schwarz

seotitle

string

Strümpfe in großen Größen schwarz

seouri

string

specifications

string

stylingtips

string

summary

string

Strümpfe, die speziell dafür entworfen wurden, unsere Beine in den Vordergrund zu stellen.

title

string

Schwarze Strümpfe

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Μαύρε&sigmaf; κάλτσε&sigmaf; με τιράντε&sigmaf; με όμορφη δαντέλα στο πάνω μέρο&sigmaf;. Κλείνουν εύκολα.

guid

string

https://dev.divasboudoir.com/el/mayres-kaltses-megaloy-megethoys-mayro/slst7299.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Κάλτσες ειδικά σχεδιασμένες για μεγαλύτερα μεγέθη.

keywords

string

title

string

Μαύρες κάλτσες μεγάλου μεγέθους

seotitle

string

Μαύρες κάλτσες μεγάλου μεγέθους

seouri

string

specifications

string

stylingtips

string

summary

string

Κάλτσε&sigmaf; ειδικά σχεδιασμένε&sigmaf; για να βάζουν τα πόδια μα&sigmaf; στο προσκήνιο.

title

string

Μαύρες κάλτσες

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Black garter belt stockings with pretty elastic lace band.

guid

string

https://dev.divasboudoir.com/en/black-plus-size-stockings-black/slst7299.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Stockings specially designed for plus sizes.

keywords

string

title

string

Black plus size stockings

seotitle

string

Black plus size stockings

seouri

string

specifications

string

stylingtips

string

summary

string

Stockings specially designed for plus sizes.

title

string

Black stockings

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Medias de tirantes negras con una bonita banda de encaje en la parte superior. Fáciles de abrochar.

guid

string

https://dev.divasboudoir.com/es/medias-negras-de-talla-grande-negro/slst7299.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Medias especialmente diseñadas para tallas grandes.

keywords

string

title

string

Medias negras de talla grande

seotitle

string

Medias negras de talla grande

seouri

string

specifications

string

stylingtips

string

summary

string

Medias especialmente diseñadas para que nuestras piernas sean el centro de atención.

title

string

Medias negras

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Bas noirs pour porte-jarretelles avec un jolie bande de dentelle dans le haut. Ils s'attachent facilement.

guid

string

https://dev.divasboudoir.com/fr/bas-grande-taille-noirs-noir/slst7299.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Bas spécialement conçus pour les grandes tailles.

keywords

string

title

string

Bas grande taille noirs

seotitle

string

Bas grande taille noirs

seouri

string

specifications

string

stylingtips

string

summary

string

Bas spécialement conçus pour mettres nos gambettes à l'honneur.

title

string

Bas noirs

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Calze nere con reggicalze e una graziosa fascia di pizzo nella parte superiore. Facile da allacciare.

guid

string

https://dev.divasboudoir.com/it/calze-nere-di-taglia-grande-nero/slst7299.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Calze appositamente studiate per le taglie grandi.

keywords

string

title

string

Calze nere di taglia grande

seotitle

string

Calze nere di taglia grande

seouri

string

specifications

string

stylingtips

string

summary

string

Calze appositamente studiate per mettere le nostre gambe sotto i riflettori.

title

string

Calze nere

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Zwarte jarretelkousen met een mooie kanten band bovenaan. Gemakkelijk vast te maken.

guid

string

https://dev.divasboudoir.com/nl/groote-maat-zwarte-kousen-zwart/slst7299.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Kousen speciaal ontworpen voor groote maten.

keywords

string

title

string

Groote maat zwarte kousen

seotitle

string

Groote maat zwarte kousen

seouri

string

specifications

string

stylingtips

string

summary

string

Kousen die speciaal ontworpen zijn om onze benen in de schijnwerpers te zetten.

title

string

Zwarte kousen

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Meias de ligas pretas com uma bonita faixa de renda na parte superior. Fácil de apertar.

guid

string

https://dev.divasboudoir.com/pt/meias-pretas-de-tamanho-grande-preto/slst7299.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Meias especialmente concebidas para tamanhos maiores.

keywords

string

title

string

Meias pretas de tamanho grande

seotitle

string

Meias pretas de tamanho grande

seouri

string

specifications

string

stylingtips

string

summary

string

Meias especialmente concebidas para dar destaque às nossas pernas.

title

string

Meias pretas

usageinstructions

string

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

legsboudoir

Struct

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

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

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

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

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

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

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

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

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

lustboudoir

Struct

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

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

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

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

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

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

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

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

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

smboudoir

Struct

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Schwarze Strümpfe für Strapsgürtel mit einem hübschen elastischen Spitzenband.

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Strümpfe für Strapsgürtel, die speziell für große Größen entwickelt wurden.

keywords

string

title

string

Schwarze Strümpfe für Strapse

seotitle

string

Schwarze Strümpfe für Strapse

seouri

string

specifications

string

stylingtips

string

summary

string

Strümpfe für Strapsgürtel, weich und angenehm zu tragen.

title

string

Schwarze Strümpfe für Strapse

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Μαύρε&sigmaf; κάλτσε&sigmaf; με τιράντε&sigmaf; και όμορφη ελαστική δαντέλα.

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Κάλτσες για καλτσοδέτες ειδικά σχεδιασμένες για μεγαλύτερα μεγέθη.

keywords

string

title

string

Μαύρες κάλτσες για ζώνη καλτσοδέτας

seotitle

string

Μαύρες κάλτσες για ζώνη καλτσοδέτας

seouri

string

specifications

string

stylingtips

string

summary

string

Μαλακά, άνετα στηρίγματα για καλτσοδέτε&sigmaf;.

title

string

Μαύρες κάλτσες για ζώνη καλτσοδέτας

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Black garter belt stockings with pretty elastic lace band.

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Stockings specially designed for plus sizes.

keywords

string

title

string

Black plus size stockings

seotitle

string

Black plus size stockings

seouri

string

specifications

string

stylingtips

string

summary

string

Stockings specially designed for plus sizes.

title

string

Black stockings

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Medias negras de liguero con una bonita banda elástica de encaje.

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Medias para liguero especialmente diseñadas para tallas grandes.

keywords

string

title

string

Medias negras para liguero

seotitle

string

Medias negras para liguero

seouri

string

specifications

string

stylingtips

string

summary

string

Sujetadores suaves y cómodos para liguero.

title

string

Medias negras para liguero

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Bas noirs pour porte-jarretelles avec un jolie bande de dentelle élastique.

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Bas pour porte-jarretelles spécialement conçus pour les grandes tailles.

keywords

string

title

string

Bas grande taille noirs

seotitle

string

Bas noirs

seouri

string

specifications

string

stylingtips

string

summary

string

Bas pour porte-jarretelles, doux et agréables à porter.

title

string

Bas noirs pour porte-jarretelles

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Calze nere da reggicalze con una bella fascia elastica in pizzo.

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Calze per reggicalze appositamente studiate per le taglie grandi.

keywords

string

title

string

Calze nere per reggicalze

seotitle

string

Calze nere per reggicalze

seouri

string

specifications

string

stylingtips

string

summary

string

Autoreggenti morbide e confortevoli per reggicalze.

title

string

Calze nere per reggicalze

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Zwarte jarretellegordelkousen met een mooie elastische kanten band.

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Kousen voor jarretelgordels speciaal ontworpen voor groote maten.

keywords

string

title

string

Zwarte kousen voor jarretelgordel

seotitle

string

Zwarte kousen voor jarretelgordel

seouri

string

specifications

string

stylingtips

string

summary

string

Zachte, comfortabele hold-ups voor jarretelgordels.

title

string

Zwarte kousen voor jarretelgordel

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Meias de cinto suspensório pretas com uma bonita faixa de renda elástica.

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Meias para cintos de ligas especialmente concebidas para tamanhos maiores.

keywords

string

title

string

Meias pretas para cinto de ligas

seotitle

string

Meias pretas para cinto de ligas

seouri

string

specifications

string

stylingtips

string

summary

string

Suave e confortável para cintos de ligas.

title

string

Meias pretas para cinto de ligas

usageinstructions

string

name

string

bas 5541 black

netweight

string

ordered

number

240

orderidx

number

origin

string

originalsize

string

packaging

string

productshipment

string

7to9days

productuid

string

CBDC60B0-A50B-446E-B0AEE9325A11C5A0

promountil

string

rating

string

none

recorduid

string

CBDC60B0-A50B-446E-B0AEE9325A11C5A0

reference

string

SLST7299

string

reserved

string

returned

number

returnsallowed

number

section

string

lingerie

shipment

string

7to9days

showbrand

number

sizeinfos

Query Template: /system/api/product/sizes.cfc:20 Execution Time: 1.3 ms Record Count: 3 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,'248,249,250,2154,2153,2152') > 0 and product_variations.productuid = 'CBDC60B0-A50B-446E-B0AEE9325A11C5A0' 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	248	4	intlsize	black	4	4	-1	999999	1	w	plus	stocking	4	4		42-44	12-14	16-18	44-46	44-46	42-44	48-50	44-46	42-44						55-60
2	249	5-6	intlsize	black	5	6	-1	999999	0	w	plus	stocking	5	5-6		46-48	16-18	20-22	48-50	48-50	46-48	52-54	48-50	46-48						62-72
3	250	6-7	intlsize	black	6	7	-1	999999	0	w	plus	stocking	6	6-7		48-50	18-20	22-24	50-52	50-52	48-50	54-56	50-52	48-50						72-82

sizeranges

string

plus,standard

sizes

string

248,249,250,2154,2153,2152

sizetype

string

intlsize

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: 5.77 ms Record Count: 3 Cached: No Datasource: divasboudoir_sitedatas Lazy: No SQL: select * from ( select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid, product_variations.color, product_colors.hexvalue, product_sizes.suppliersize, product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup, if(intlsize <> '',intlsize,product_sizes.intlsize) as size, if(intlsize <> '','intlsize','intlsize') as sizetype, product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil, product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect, product_variations.reference as manufacturerreference, product_variations.ean, (if( (sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0, (sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)), if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0, -1, if( sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0, sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved), 0 )) )) as available, IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock, 'all' as display, product_variations.comments from product_stocks left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid left outer join product_sizes on product_variations.size = product_sizes.suppliersize left outer join product_colors on product_variations.color = product_colors.color where product_stocks.productuid = 'CBDC60B0-A50B-446E-B0AEE9325A11C5A0' and product_variations.isactive = 1 and product_sizes.id_size = 248 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 = 'CBDC60B0-A50B-446E-B0AEE9325A11C5A0' and product_variations.isactive = 1 and product_sizes.id_size = 249 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 = 'CBDC60B0-A50B-446E-B0AEE9325A11C5A0' and product_variations.isactive = 1 and product_sizes.id_size = 250 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 = 'CBDC60B0-A50B-446E-B0AEE9325A11C5A0' and product_variations.isactive = 1 and product_sizes.id_size = 2154 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 = 'CBDC60B0-A50B-446E-B0AEE9325A11C5A0' and product_variations.isactive = 1 and product_sizes.id_size = 2153 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 = 'CBDC60B0-A50B-446E-B0AEE9325A11C5A0' and product_variations.isactive = 1 and product_sizes.id_size = 2152 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	CBDC60B0-A50B-446E-B0AEE9325A11C5A0	FB05CA74-0570-482A-ACCB3BD5C6FF35C1	248	black	#000000	4	4		42-44	12-14	16-18	44-46	44-46	42-44	48-50	44-46	42-44	w	stocking		4	intlsize	12.4583	0		STOCK01	1	0	0	-1	0	37	0	0	5590554114	5906340736508	1	1	all
2	CBDC60B0-A50B-446E-B0AEE9325A11C5A0	18DF68C5-6E19-4B74-86F0CD405E7DE3EE	249	black	#000000	5	5-6		46-48	16-18	20-22	48-50	48-50	46-48	52-54	48-50	46-48	w	stocking		5-6	intlsize	12.4583	0		STOCK01	0	0	0	-1	0	95	0	0	5590554115	5906340730438	-1	0	all
3	CBDC60B0-A50B-446E-B0AEE9325A11C5A0	9E9FF787-F84B-4D76-BC4FD16850203045	250	black	#000000	6	6-7		48-50	18-20	22-24	50-52	50-52	48-50	54-56	50-52	48-50	w	stocking		6-7	intlsize	12.4583	0		STOCK01	0	0	0	-1	1	108	0	1	5590554116	5906340730445	-1	0	all

subcategory

string

stocking

supplier

number

-1

supplierreference

string

5541

tags

string

prixminis

themes

string

totalvariations

string

type

string

default

unitprice

number

12.4583

usageinstructions

string

variations

Query Template: /system/api/product/variations.cfc:171 Execution Time: 27.9 ms Record Count: 3 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 = 'CBDC60B0-A50B-446E-B0AEE9325A11C5A0' 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 = 'CBDC60B0-A50B-446E-B0AEE9325A11C5A0' 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 = 'CBDC60B0-A50B-446E-B0AEE9325A11C5A0' 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 = 'CBDC60B0-A50B-446E-B0AEE9325A11C5A0' 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 = 'CBDC60B0-A50B-446E-B0AEE9325A11C5A0' 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 = 'CBDC60B0-A50B-446E-B0AEE9325A11C5A0' 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 = 'CBDC60B0-A50B-446E-B0AEE9325A11C5A0' and product_variations.isactive = 1 and product_sizes.id_size = 248 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 = 'CBDC60B0-A50B-446E-B0AEE9325A11C5A0' 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 = 'CBDC60B0-A50B-446E-B0AEE9325A11C5A0' 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 = 'CBDC60B0-A50B-446E-B0AEE9325A11C5A0' 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 = 'CBDC60B0-A50B-446E-B0AEE9325A11C5A0' 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 = 'CBDC60B0-A50B-446E-B0AEE9325A11C5A0' 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 = 'CBDC60B0-A50B-446E-B0AEE9325A11C5A0' 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 = 'CBDC60B0-A50B-446E-B0AEE9325A11C5A0' and product_variations.isactive = 1 and product_sizes.id_size = 249 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 = 'CBDC60B0-A50B-446E-B0AEE9325A11C5A0' 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 = 'CBDC60B0-A50B-446E-B0AEE9325A11C5A0' 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 = 'CBDC60B0-A50B-446E-B0AEE9325A11C5A0' 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 = 'CBDC60B0-A50B-446E-B0AEE9325A11C5A0' 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 = 'CBDC60B0-A50B-446E-B0AEE9325A11C5A0' 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 = 'CBDC60B0-A50B-446E-B0AEE9325A11C5A0' 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 = 'CBDC60B0-A50B-446E-B0AEE9325A11C5A0' and product_variations.isactive = 1 and product_sizes.id_size = 250 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 = 'CBDC60B0-A50B-446E-B0AEE9325A11C5A0' 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 = 'CBDC60B0-A50B-446E-B0AEE9325A11C5A0' 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 = 'CBDC60B0-A50B-446E-B0AEE9325A11C5A0' 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 = 'CBDC60B0-A50B-446E-B0AEE9325A11C5A0' 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 = 'CBDC60B0-A50B-446E-B0AEE9325A11C5A0' 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 = 'CBDC60B0-A50B-446E-B0AEE9325A11C5A0' 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 = 'CBDC60B0-A50B-446E-B0AEE9325A11C5A0' and product_variations.isactive = 1 and product_sizes.id_size = 2154 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 = 'CBDC60B0-A50B-446E-B0AEE9325A11C5A0' 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 = 'CBDC60B0-A50B-446E-B0AEE9325A11C5A0' 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 = 'CBDC60B0-A50B-446E-B0AEE9325A11C5A0' 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 = 'CBDC60B0-A50B-446E-B0AEE9325A11C5A0' 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 = 'CBDC60B0-A50B-446E-B0AEE9325A11C5A0' 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 = 'CBDC60B0-A50B-446E-B0AEE9325A11C5A0' 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 = 'CBDC60B0-A50B-446E-B0AEE9325A11C5A0' and product_variations.isactive = 1 and product_sizes.id_size = 2153 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 = 'CBDC60B0-A50B-446E-B0AEE9325A11C5A0' 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 = 'CBDC60B0-A50B-446E-B0AEE9325A11C5A0' 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 = 'CBDC60B0-A50B-446E-B0AEE9325A11C5A0' 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 = 'CBDC60B0-A50B-446E-B0AEE9325A11C5A0' 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 = 'CBDC60B0-A50B-446E-B0AEE9325A11C5A0' 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 = 'CBDC60B0-A50B-446E-B0AEE9325A11C5A0' 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 = 'CBDC60B0-A50B-446E-B0AEE9325A11C5A0' and product_variations.isactive = 1 and product_sizes.id_size = 2152 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	FB05CA74-0570-482A-ACCB3BD5C6FF35C1	248	black	#000000	4	4		42-44	12-14	16-18	44-46	44-46	42-44	48-50	44-46	42-44	w	stocking		4	intlsize	12.4583	0		STOCK01	1	0	0	-1	0	37	0	0	5590554114	5906340736508	1	1	-1	1	-1	0	0	12.4583	all
2	18DF68C5-6E19-4B74-86F0CD405E7DE3EE	249	black	#000000	5	5-6		46-48	16-18	20-22	48-50	48-50	46-48	52-54	48-50	46-48	w	stocking		5-6	intlsize	12.4583	0		STOCK01	0	0	0	-1	0	95	0	0	5590554115	5906340730438	-1	0	-1	0	-1	0	0	12.4583	all
3	9E9FF787-F84B-4D76-BC4FD16850203045	250	black	#000000	6	6-7		48-50	18-20	22-24	50-52	50-52	48-50	54-56	50-52	48-50	w	stocking		6-7	intlsize	12.4583	0		STOCK01	0	0	0	-1	1	108	0	1	5590554116	5906340730445	-1	0	-1	0	-1	0	0	12.4583	all

vatrate

number

warehouse

string

productuid

string

CBDC60B0-A50B-446E-B0AEE9325A11C5A0

quantity

string

type

string

gift

teasertitle

string

CARTACTION_teasertitle_freestockingschoosesizecolor

quotas

number

-1

type

string

choice

usedcount

number

available

number

-1

brand

string

dreamgirl

brandcode

string

ddru

branding

string

divasboudoir

brandmedias

string

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

Dreamgirl

breasts

string

careinstructions

string

category

string

sexylingerie

categorygender

string

categorymediadatas

Struct

adult

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

276

isprivate

string

rating

string

all

src

string

/photobank/categories/divasboudoir/lingerie/sexylingerie/bustier.jpg

type

string

img

width

string

600

divasboudoir

Struct

plus

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

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

small

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

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

standard

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

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

fetishboudoir

Struct

plus

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

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

small

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

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

standard

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

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

latexboudoir

Struct

plus

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

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

small

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

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

standard

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

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

legsboudoir

Struct

plus

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

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

small

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

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

standard

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

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

lustboudoir

Struct

plus

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

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

small

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

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

standard

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

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

private

Struct

height

string

1016

isprivate

string

rating

string

all

src

string

/photobank/categories/divasboudoir/private/default.jpg

type

string

img

width

string

703

smboudoir

Struct

plus

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

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

small

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

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

standard

Struct

alt

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

variations

Struct

colors

Struct

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

categorysizerange

string

auto

colorinfos

Query Template: /system/api/product/colors.cfc:13 Execution Time: 0.646 ms Record Count: 1 Cached: No Datasource: divasboudoir_sitedatas Lazy: No SQL: select product_colors.color as recorduid, product_colors.type, product_colors.code, product_colors.color, product_colors.range, product_colors.hexvalue, (if( (select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0, -1, if( sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0, sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved), 0 ) )) as available, IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock from product_colors left outer join product_variations on product_colors.color = product_variations.color and product_variations.isactive = 1 left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01' where FIND_IN_SET(product_colors.color,'black') > 0 and product_variations.productuid = '930D9183-32C6-49C9-B663922400E0434D' group by product_colors.range,product_colors.color order by product_colors.range,product_colors.color
	recorduid	type	code	color	range	hexvalue	available	stock
1	black	color	blak	black	black	#000000	-1	0

colorrange

string

black

colors

string

black

colortype

string

color

comments

string

compositions

Struct
Entries: 13

coton

string

elastane

string

free

string

leather

string

lycra

string

metal

string

nylon

string

polyamide

string

polyester

string

polyurethane

string

silk

string

spandex

string

viscose

string

datecreated

Date Time (Europe/Paris)

{ts '2022-03-28 10:55:50'}

defect

number

dimensions

Struct
Entries: 14

acrylicbones

string

backsideheight

string

diameter

string

flatsteelbones

string

frontsideheight

string

fullheight

string

length

string

modestysize

string

panels

string

sides

string

spiralsteelbones

string

totallength

string

unit

string

wiresize

string

display

string

all

displayfrom

string

displayto

string

grossweight

string

hasbrandinfos

boolean

false

hascareinstructions

boolean

false

hascolorinfos

boolean

true

hascompositions

boolean

false

hasdescription

boolean

true

hasdimensions

boolean

false

hasmaterials

boolean

false

hasotherspecifications

boolean

false

haspromo

number

hasshortdescription

boolean

true

hassizeinfos

boolean

true

hasspecifications

boolean

false

hasstockinfos

boolean

false

hasstylingtips

boolean

false

hasusageinstructions

boolean

false

hasvariations

boolean

true

import

string

inpromo

number

instockvariations

string

isactive

number

iscustommade

number

isdivasize

number

isfirstprice

number

isfixedprice

number

ishot

number

isnew

number

isonline

number

isoutletprice

number

itemprice

number

49.9583

itempromo

string

key

string

guepiere-grande-taille-en-simili-cuir-et-fine-resille-noir-avec-jarretelles---dg12447xblk

language

string

all

lastupdated

Date Time (Europe/Paris)

{ts '2025-03-31 22:47:42'}

linkedactions

Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.686 ms
Record Count: 1
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select cart_actions.*
from cart_actions
where cart_actions.branding IN ('all','divasboudoir')
and cart_actions.language IN ('all','fr')
and (cart_actions.quotas = -1 or (cart_actions.usedCount < cart_actions.quotas))
and cart_actions.isactive = 1
and (date(cart_actions.activeFrom) <= '2025-11-24' OR cart_actions.activeFrom is null)
and (date(cart_actions.activeTo) >= '2025-11-24' OR cart_actions.activeTo is null)
and (
FIND_IN_SET('930d9183-32c6-49c9-b663922400e0434d',lcase(cart_actions.linkedproducts)) > 0 and cart_actions.linkedproducts is not null
)

id_action

branding

language

name

code

type

minimumOrder

maximumOrder

minimumItems

maximumItems

maximumUse

allowedItems

quotas

usedCount

linkedproducts

linkedthemes

linkedbrands

linkeditem

params

activeFrom

activeTo

isActive

304

all

Bas Offerts

FREESTOCKINGSSLST7299

choice

all

-1

{ "products": [ { "productuid": "CBDC60B0-A50B-446E-B0AEE9325A11C5A0", "price": 0, "type":"gift", "discount": 0, "quantity":1 } ], "maintitle":"CARTACTION_maintitle_freestockingschoosesizecolor", "teasertitle":"CARTACTION_teasertitle_freestockingschoosesizecolor" }

linkedproducts

Query
Template: /system/api/products.cfc:1305
Execution Time: 1.31 ms
Record Count: 0
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select products.productuid as productuid, products.reference, 'default' as type, products.key, products.language, products.name,
product_links.linkuid,
products.colors, products.vatrate, products.metadatas, products.dimensions,
products.mediadatas, products.tags, products.themes, products.isdivasize,
count(distinct product_variations.variationuid) as totalvariations,
group_concat(distinct product_variations.variationuid) as variationlist,
count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END) as inpromo,
if(count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END)>0,1,0) as haspromo,
(select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0) END)) as itempromo,
IFNULL(min(product_variations.itemprice),0) as itemprice,
(select IF (products.isfixedprice = 0 and sum(product_variations.itempromo) > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null), IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0), IFNULL(min(NULLIF(product_variations.itemprice, 0)), 0) )) as unitprice,
count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.itempromo ELSE product_variations.itemprice END) as prices,
(select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN min(NULLIF(product_variations.promountil, 0)) END)) as promountil,
products.isfixedprice, products.ishot, products.isnew, if(products.orderidx > 0, products.orderidx, 999999999) as orderidx,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
count(distinct CASE WHEN ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) > 0 OR ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) <= 0 AND product_variations.supplier = 0)) THEN product_variations.variationuid END) as instockvariations,
products.brand, brands.name as brandname, IFNULL(brands.ispublic, 0) as showbrand, brands.display,
product_categories.sizetype,GROUP_CONCAT(DISTINCT product_sizes.suppliersize) as intlsize,products.sizes,product_sizes.sizerange,product_categories.mediadatas as categorymediadatas, product_categories.sizerange as categorysizerange,
product_categorymap.section, product_categorymap.category, product_categorymap.key as subcategory
from products
left outer join product_categorymap on products.productuid = product_categorymap.productuid
left outer join product_categories on (product_categories.branding = product_categorymap.branding and product_categories.section = product_categorymap.section and product_categories.category = product_categorymap.category and product_categories.key = product_categorymap.key)
left outer join product_sizes on product_sizes.id_size IN (products.sizes)
left outer join brands on products.brand = brands.brand
left outer join product_variations on product_variations.productuid = products.productuid and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
left outer join product_links on product_links.reference = products.reference
where products.isactive = 1 and products.isdeleted = 0
and brands.isactive = 1 and brands.isdeleted = 0
and product_categories.isactive = 1 and product_categories.isdeleted = 0
and product_variations.isactive = 1
and FIND_IN_SET('divasboudoir',products.branding)
and product_categories.branding IN ('all','divasboudoir')
and product_categorymap.branding IN ('all','divasboudoir')
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and products.language in ('all','fr')
and product_categories.language in ('all','fr')
and (products.displayFrom <= DATE(NOW()) or products.displayFrom is null)
and (products.displayTo >= DATE(NOW()) or products.displayTo IS null)
and product_links.linkuid = '' and product_links.linkuid is not null and product_links.linkuid <> ''
and products.reference <> 'DRBU3024'
group by products.reference
order by products.ishot desc, products.isnew desc, orderidx asc, products.lastupdated desc

productuid

reference

type

key

language

name

linkuid

colors

vatrate

metadatas

dimensions

mediadatas

tags

themes

isdivasize

totalvariations

variationlist

inpromo

haspromo

itempromo

itemprice

unitprice

prices

promountil

isfixedprice

ishot

isnew

orderidx

available

stock

instockvariations

brand

brandname

showbrand

display

sizetype

intlsize

sizes

sizerange

categorymediadatas

categorysizerange

section

category

subcategory

linkuid

string

materials

string

mediadatas

Struct

alt

Struct

height

string

653

isprivate

string

rating

string

all

src

string

/photobank/products/ddru/drbu3024/guepiere-en-simili-cuir-et-fine-resille-noir-avec-jarretelles-dg12447blk_1.jpg

type

string

img

width

string

492

back

Struct

height

string

992

isprivate

string

rating

string

all

src

string

/photobank/products/ddru/drbu3024/12447x_black_back-crop.jpg

type

string

img

width

string

797

default

Struct

height

string

774

isprivate

string

rating

string

all

src

string

/photobank/products/ddru/drbu3024/12447x_black_front-crop.jpg

type

string

img

width

string

622

variations

Struct

colors

Struct

black

Struct

height

string

774

isprivate

string

rating

string

all

src

string

/photobank/products/ddru/drbu3024/12447x_black_front-crop.jpg

type

string

img

width

string

622

video

Struct

embedsrc

string

height

string

isprivate

string

rating

string

src

string

thumb

Struct

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

high

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

maxres

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

medium

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

standard

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

type

string

width

string

mediagallery

string

metadatas

Struct

darkboudoir

Struct

Struct
Entries: 13

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 13

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 13

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 13

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 13

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 13

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 13

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 13

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

divasboudoir

Struct

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Langes Horus Guêpière Wunderschön an unsere Rundungen angepasst ist sie aus elastischem Kunstleder mit einem Reißverschluss über die gesamte Vorderseite. Ein ausgeschnittener Kragen sorgt für ein schwindelerregendes Dekolleté und der Rücken ist komplett aus Netzstoff. Verstellbare und abnehmbare Strumpfbänder.

guid

string

https://dev.divasboudoir.com/de/langes-grosses-taillenband-horus-guepiere-schwarz/drbu3024.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Entdecken Sie unser langes Mieder in Übergröße Horus. Tragen Sie dieses wunderschöne Mieder mit oder ohne Strümpfe, es lässt sich im Handumdrehen in ein Nachthemd verwandeln.

keywords

string

title

string

Langes großes Taillenband Horus Guêpière

seotitle

string

Langes großes Taillenband Horus Guêpière

seouri

string

specifications

string

stylingtips

string

summary

string

Tragen Sie dieses wunderschöne Mieder mit oder ohne Strümpfe, es lässt sich im Handumdrehen in ein Babydoll verwandeln.

title

string

Langes Mieder Horus

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Horus μακριά μπασκέτα Υπέροχα προσαρμοσμένο στι&sigmaf; καμπύλε&sigmaf; μα&sigmaf;, αυτό το ελαστικό σουτιέν από ψεύτικο δέρμα διαθέτει πλήρε&sigmaf; φερμουάρ μπροστά. Λαιμόκοψη με κοψίματα για ένα ιλιγγιώδε&sigmaf; ντεκολτέ και πλήρη διχτυωτή πλάτη. Ρυθμιζόμενε&sigmaf;, αποσπώμενε&sigmaf; καλτσοδέτε&sigmaf;.

guid

string

https://dev.divasboudoir.com/el/makria-zartiera-megaloy-megethoys-horus-mayro/drbu3024.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

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

keywords

string

title

string

Μακριά ζαρτιέρα μεγάλου μεγέθους Horus

seotitle

string

Μακριά ζαρτιέρα μεγάλου μεγέθους Horus

seouri

string

specifications

string

stylingtips

string

summary

string

Φορέστε αυτό το υπέροχο μπουστάκι με ή χωρί&sigmaf; κάλτσε&sigmaf;, και μεταμορφώνεται σε babydoll σε χρόνο μηδέν.

title

string

Horus μακρύ μπουστάκι

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Horus long basque Superbly adapted to our curves, this elastic faux-leather bra features a full-front zipper. Scalloped neckline for a vertiginous décolleté and full fishnet back. Adjustable, detachable garters.

guid

string

https://dev.divasboudoir.com/en/long-plus-size-garepiere-horus-black/drbu3024.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Wear this superb guêpière with or without stockings, it transforms into a babydoll in no time at all.

keywords

string

title

string

Long plus size garêpière Horus

seotitle

string

Long plus size garêpière Horus

seouri

string

specifications

string

stylingtips

string

summary

string

Wear this superb guêpière with or without stockings, it transforms into a babydoll in no time at all.

title

string

Horus long bustier

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Sujetador largo Horus Magníficamente adaptado a nuestras curvas, este sujetador elástico de piel sintética tiene una cremallera frontal completa. Escote abierto para un escote de vértigo y espalda de rejilla. Ligas ajustables y desmontables.

guid

string

https://dev.divasboudoir.com/es/horus-liguero-largo-de-talla-grande-negro/drbu3024.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Descubra nuestro corpiño Horus largo y de talla grande. Lleva este magnífico corpiño con o sin medias, se transforma en un babydoll en un abrir y cerrar de ojos.

keywords

string

title

string

Horus liguero largo de talla grande

seotitle

string

Horus liguero largo de talla grande

seouri

string

specifications

string

stylingtips

string

summary

string

Lleva este magnífico corpiño con o sin medias, y se transforma en un babydoll en un abrir y cerrar de ojos.

title

string

Bustier largo Horus

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Longue Guêpière Horus Superbement adaptée à nos rondeurs elle est en similicuir élastique avec une fermeture éclair sur tout l'avant.  Col échancré pour un décolleté vertigineux et dos entièrement en résille.  Jarretières réglables et détachables.

guid

string

https://dev.divasboudoir.com/fr/longue-grande-taille-guepiere-horus-noir/drbu3024.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Découvrez notre longue guêpière grande taille Horus. Portez cette superbe guêpière avec ou sans bas, elle se transforme en nuisette en un tour de main.

keywords

string

title

string

Guêpière grande taille Horus en similicuir et résille

seotitle

string

Longue grande taille guêpière Horus

seouri

string

specifications

string

stylingtips

string

summary

string

Portez cette superbe guêpière avec ou sans bas, elle se transforme en nuisette en un tour de main.

title

string

Longue guêpière Horus

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Basco lungo Horus Adattato in modo eccellente alle nostre curve, questo reggiseno elasticizzato in ecopelle è dotato di una zip integrale sul davanti. Scollatura a taglio per un décolleté vertiginoso e schiena a rete. Giarrettiere regolabili e staccabili.

guid

string

https://dev.divasboudoir.com/it/giarrettiera-lunga-di-taglia-grande-horus-nero/drbu3024.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Scoprite il nostro basco lungo Horus di taglia grande. Indossate questo superbo bustier con o senza calze, si trasforma in un babydoll in un attimo.

keywords

string

title

string

Giarrettiera lunga di taglia grande Horus

seotitle

string

Giarrettiera lunga di taglia grande Horus

seouri

string

specifications

string

stylingtips

string

summary

string

Indossato con o senza calze, questo superbo bustier si trasforma in un babydoll in un attimo.

title

string

Bustier lungo Horus

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Horus lange basque Deze elastische bh van imitatieleer is perfect aangepast aan onze rondingen en heeft een volledige ritssluiting aan de voorkant. Uitgesneden halslijn voor een duizelingwekkend decolleté en volledige visnetrug. Verstelbare, afneembare kousenbanden.

guid

string

https://dev.divasboudoir.com/nl/lange-kousenband-horus-groote-maat-zwart/drbu3024.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Ontdek onze lange Horus basque in groote maat. Draag deze prachtige bustier met of zonder kousen, hij verandert in een handomdraai in een babydoll.

keywords

string

title

string

Lange kousenband Horus, groote maat

seotitle

string

Lange kousenband Horus, groote maat

seouri

string

specifications

string

stylingtips

string

summary

string

Draag deze prachtige bustier met of zonder kousen en hij verandert in een handomdraai in een babydoll.

title

string

Horus lange bustier

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Basquetebol comprido Horus Soberbamente adaptado às nossas curvas, este soutien elástico em pele sintética tem um fecho de correr frontal completo. Decote recortado para um decote vertiginoso e costas em rede. Ligas ajustáveis e amovíveis.

guid

string

https://dev.divasboudoir.com/pt/horus-de-liga-comprida-de-tamanho-grande-preto/drbu3024.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Descubra o nosso basco Horus comprido e de tamanho grande. Usado com ou sem meias, este corpete soberbo transforma-se num babydoll num instante.

keywords

string

title

string

Hórus de liga comprida de tamanho grande

seotitle

string

Hórus de liga comprida de tamanho grande

seouri

string

specifications

string

stylingtips

string

summary

string

Este corpete soberbo pode ser usado com ou sem meias e transforma-se num babydoll num instante.

title

string

Corpete comprido Horus

usageinstructions

string

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

legsboudoir

Struct

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

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

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

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

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

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

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

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

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

lustboudoir

Struct

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

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

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

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

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

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

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

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

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

smboudoir

Struct

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Horus Guêpière Wunderschön an alle Körperformen angepasst ist sie aus elastischem Kunstleder mit einem Reißverschluss über die gesamte Vorderseite. Ein ausgeschnittener Kragen sorgt für ein schwindelerregendes Dekolleté und der Rücken ist komplett aus Netzstoff. Verstellbare und abnehmbare Strumpfbänder.

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Entdecken Sie unser Mieder aus Kunstleder und tragen Sie es mit oder ohne Strümpfe, es lässt sich im Handumdrehen in ein Babydoll verwandeln. BDSM Boutique. Große Größen.

keywords

string

title

string

Horus Guêpière

seotitle

string

Horus Guêpière

seouri

string

specifications

string

stylingtips

string

summary

string

Tragen Sie dieses unglaubliche Mieder mit oder ohne Strümpfe, es lässt sich im Handumdrehen in ein Babydoll verwandeln.

title

string

Horus Guêpière

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Horus μπουστάκι Εξαιρετικά προσαρμοσμένο σε όλα τα σχήματα σώματο&sigmaf;, αυτό το ελαστικό σουτιέν από ψεύτικο δέρμα διαθέτει πλήρε&sigmaf; φερμουάρ μπροστά. Χαμηλή λαιμόκοψη για ένα ιλιγγιώδε&sigmaf; ντεκολτέ και πλήρη διχτυωτή πλάτη. Ρυθμιζόμενε&sigmaf;, αποσπώμενε&sigmaf; καλτσοδέτε&sigmaf;.

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Φορέστε το με ή χωρίς κάλτσες, μεταμορφώνεται σε babydoll σε χρόνο μηδέν. BDSM Boutique. Μεγάλα μεγέθη.

keywords

string

title

string

Horus μπουστάκι

seotitle

string

Horus μπουστάκι

seouri

string

specifications

string

stylingtips

string

summary

string

Φορέστε αυτό το απίστευτο μπουστάκι με ή χωρί&sigmaf; κάλτσε&sigmaf;, μεταμορφώνεται σε babydoll σε χρόνο μηδέν.

title

string

Horus μπουστάκι

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Wear this superb guêpière with or without stockings, it transforms into a babydoll in no time at all.

keywords

string

title

string

Long plus size garêpière Horus

seotitle

string

Long plus size garêpière Horus

seouri

string

specifications

string

stylingtips

string

summary

string

Wear this superb guêpière with or without stockings, it transforms into a babydoll in no time at all.

title

string

Horus long bustier

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Sujetador Horus Magníficamente adaptado a todas las formas del cuerpo, este corpiño de piel sintética elástica tiene una cremallera frontal completa. Escote pronunciado para un escote de vértigo y espalda de rejilla. Ligas ajustables y desmontables.

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Llévalo con o sin medias, se transforma en un babydoll en un santiamén. Boutique BDSM. Tallas grandes.

keywords

string

title

string

Bustier Horus

seotitle

string

Bustier Horus

seouri

string

specifications

string

stylingtips

string

summary

string

Lleva este increíble corpiño con o sin medias, se transforma en un babydoll en un abrir y cerrar de ojos.

title

string

Bustier Horus

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Guêpière Horus Superbement adaptée à toutes les morphologies elle est en similicuir élastique avec une fermeture éclair sur tout l'avant.  Col échancré pour un décolleté vertigineux et dos entièrement en résille.  Jarretières réglables et détachables.

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Découvrez notre guêpière en similicuir et portez-la avec ou sans bas, elle se transforme en nuisette en un tour de main. BDSM Boutique. Grandes Tailles.

keywords

string

title

string

Guêpière en similicuir et résille Horus

seotitle

string

Longue grande taille guêpière Horus

seouri

string

specifications

string

stylingtips

string

summary

string

Portez cette incroyable guêpière avec ou sans bas, elle se transforme en nuisette en un tour de main.

title

string

Guêpière Horus

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Reggiseno Horus Adatto a tutte le forme del corpo, questo reggiseno elasticizzato in ecopelle è dotato di una zip frontale completa. Scollo basso per un décolleté vertiginoso e schiena a rete. Giarrettiere regolabili e staccabili.

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Indossato con o senza calze, si trasforma in un babydoll in un attimo. Boutique BDSM. Taglia grande.

keywords

string

title

string

Bustier Horus

seotitle

string

Bustier Horus

seouri

string

specifications

string

stylingtips

string

summary

string

Indossate questo incredibile bustier con o senza calze, si trasforma in un babydoll in un attimo.

title

string

Bustier Horus

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Horus bustier Deze bh van elastisch imitatieleer past perfect bij alle lichaamsvormen en heeft een volledige ritssluiting aan de voorkant. Laag uitgesneden halslijn voor een duizelingwekkend decolleté en volledige visnet rug. Verstelbare, afneembare kousenbanden.

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Draag hem met of zonder kousen, hij verandert in een handomdraai in een babydoll. BDSM-boetiek. Groote maten.

keywords

string

title

string

Horus bustier

seotitle

string

Horus bustier

seouri

string

specifications

string

stylingtips

string

summary

string

Draag deze ongelofelijke bustier met of zonder kousen, hij verandert in een handomdraai in een babydoll.

title

string

Horus bustier

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Corpete Horus Adequado para todas as formas do corpo, este soutien elástico em pele sintética tem um fecho de correr frontal completo. Decote baixo para um decote vertiginoso e costas em rede. Ligas ajustáveis e amovíveis.

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Usado com ou sem meias, transforma-se num babydoll num instante. Boutique BDSM. Tamanhos grandes.

keywords

string

title

string

Corpete Horus

seotitle

string

Corpete Horus

seouri

string

specifications

string

stylingtips

string

summary

string

Usado com ou sem meias, este corpete incrível transforma-se num babydoll num instante.

title

string

Corpete Horus

usageinstructions

string

name

string

Guêpière grande taille en simili cuir et fine résille noir avec jarretelles - DG12447XBLK

netweight

string

nextshipment

string

today

ordered

number

orderidx

number

origin

string

originalsize

string

packaging

string

productshipment

string

auto

productuid

string

930D9183-32C6-49C9-B663922400E0434D

promountil

string

rating

string

none

recorduid

string

930D9183-32C6-49C9-B663922400E0434D

reference

string

DRBU3024

string

reserved

string

returned

number

returnsallowed

number

section

string

lingerie

shipment

string

3to5days

showbrand

number

sizeinfos

Query Template: /system/api/product/sizes.cfc:20 Execution Time: 1.33 ms Record Count: 3 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,'333,1149,1387,1813,1815') > 0 and product_variations.productuid = '930D9183-32C6-49C9-B663922400E0434D' 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	333	Queen	intlsize	black	Queen	Queen	-1	999999	0	w	plus	lingerie	Queen	Queen		42-44	12-14	16-18	44-46	44-46	42-44	48-50	44-46	42-44	102-112	91-97	107-112
2	1387	Queen++	intlsize	black	Queen++	Queen++	-1	999999	0	w	plus	lingerie	Queen	Queen++		50-52	20-22	24-26	52-54	52-54	50-52	56-58	52-54	50-52	122-132	102-107	122-132
3	1149	Queen+	intlsize	black	Queen+	Queen+	-1	999999	0	w	plus	lingerie	Queen	Queen+		46-48	16-18	20-22	48-50	48-50	46-48	52-54	48-50	46-48	112-122	97-102	112-122

sizeranges

string

plus,standard

sizes

string

333,1149,1387,1813,1815

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: 4.22 ms
Record Count: 1
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 = '930D9183-32C6-49C9-B663922400E0434D'
and product_variations.isactive = 1
and product_sizes.id_size = 333
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 = '930D9183-32C6-49C9-B663922400E0434D'
and product_variations.isactive = 1
and product_sizes.id_size = 1149
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 = '930D9183-32C6-49C9-B663922400E0434D'
and product_variations.isactive = 1
and product_sizes.id_size = 1387
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 = '930D9183-32C6-49C9-B663922400E0434D'
and product_variations.isactive = 1
and product_sizes.id_size = 1813
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 = '930D9183-32C6-49C9-B663922400E0434D'
and product_variations.isactive = 1
and product_sizes.id_size = 1815
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

930D9183-32C6-49C9-B663922400E0434D

2F607041-7348-48CC-BCFE4C5F9D56658B

333

black

#000000

Queen

42-44

12-14

16-18

44-46

42-44

48-50

44-46

42-44

lingerie

Queen

intlsize

49.9583

STOCK01

-1

12447X

888368317158

-1

all

subcategory

string

bustier

supplier

number

-1

supplierreference

string

DG12447

tags

string

freestockings

themes

string

dark

totalvariations

string

type

string

default

unitprice

number

49.9583

usageinstructions

string

variations

Query Template: /system/api/product/variations.cfc:171 Execution Time: 7.83 ms Record Count: 3 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 = '930D9183-32C6-49C9-B663922400E0434D' 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 = '930D9183-32C6-49C9-B663922400E0434D' 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 = '930D9183-32C6-49C9-B663922400E0434D' 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 = '930D9183-32C6-49C9-B663922400E0434D' 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 = '930D9183-32C6-49C9-B663922400E0434D' 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 = '930D9183-32C6-49C9-B663922400E0434D' 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 = '930D9183-32C6-49C9-B663922400E0434D' and product_variations.isactive = 1 and product_sizes.id_size = 333 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 = '930D9183-32C6-49C9-B663922400E0434D' 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 = '930D9183-32C6-49C9-B663922400E0434D' 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 = '930D9183-32C6-49C9-B663922400E0434D' 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 = '930D9183-32C6-49C9-B663922400E0434D' 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 = '930D9183-32C6-49C9-B663922400E0434D' 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 = '930D9183-32C6-49C9-B663922400E0434D' 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 = '930D9183-32C6-49C9-B663922400E0434D' and product_variations.isactive = 1 and product_sizes.id_size = 1149 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 = '930D9183-32C6-49C9-B663922400E0434D' 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 = '930D9183-32C6-49C9-B663922400E0434D' 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 = '930D9183-32C6-49C9-B663922400E0434D' 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 = '930D9183-32C6-49C9-B663922400E0434D' 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 = '930D9183-32C6-49C9-B663922400E0434D' 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 = '930D9183-32C6-49C9-B663922400E0434D' 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 = '930D9183-32C6-49C9-B663922400E0434D' and product_variations.isactive = 1 and product_sizes.id_size = 1387 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 = '930D9183-32C6-49C9-B663922400E0434D' 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 = '930D9183-32C6-49C9-B663922400E0434D' 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 = '930D9183-32C6-49C9-B663922400E0434D' 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 = '930D9183-32C6-49C9-B663922400E0434D' 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 = '930D9183-32C6-49C9-B663922400E0434D' 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 = '930D9183-32C6-49C9-B663922400E0434D' 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 = '930D9183-32C6-49C9-B663922400E0434D' and product_variations.isactive = 1 and product_sizes.id_size = 1813 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 = '930D9183-32C6-49C9-B663922400E0434D' 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 = '930D9183-32C6-49C9-B663922400E0434D' 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 = '930D9183-32C6-49C9-B663922400E0434D' 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 = '930D9183-32C6-49C9-B663922400E0434D' 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 = '930D9183-32C6-49C9-B663922400E0434D' 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 = '930D9183-32C6-49C9-B663922400E0434D' 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 = '930D9183-32C6-49C9-B663922400E0434D' and product_variations.isactive = 1 and product_sizes.id_size = 1815 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	2F607041-7348-48CC-BCFE4C5F9D56658B	333	black	#000000	Queen	Queen		42-44	12-14	16-18	44-46	44-46	42-44	48-50	44-46	42-44	w	lingerie		Queen	intlsize	49.9583	0		STOCK01	0	0	0	-1	0	12	0	0	12447X	888368317158	-1	0	-1	0	-1	0	0	49.9583	all
2	2F607041-7348-48CC-BCFE4C5F9D56658B	1149	black	#000000	Queen	Queen+		46-48	16-18	20-22	48-50	48-50	46-48	52-54	48-50	46-48	w	lingerie		Queen+	intlsize	49.9583	0		STOCK01	0	0	0	-1	0	12	0	0	12447X	888368317158	-1	0	-1	0	-1	0	0	49.9583	all
3	2F607041-7348-48CC-BCFE4C5F9D56658B	1387	black	#000000	Queen	Queen++		50-52	20-22	24-26	52-54	52-54	50-52	56-58	52-54	50-52	w	lingerie		Queen++	intlsize	49.9583	0		STOCK01	0	0	0	-1	0	12	0	0	12447X	888368317158	-1	0	-1	0	-1	0	0	49.9583	all

vatrate

number

warehouse

string

Bas noirs

Longue grande taille guêpière Horus

Description du produit

Détails techniques

Tailles disponibles

Couleur disponible

Guide de taille

INFORMATIONS

ESPACE MEMBRE

SERVICES

CONTACTEZ-NOUS

Bas noirs

Longue grande taille guêpière Horus

Description du produit

Détails techniques

Tailles disponibles

Couleur disponible

Guide de taille

Newsletter

Modifier mes réglages

Sauver mes préférences