Ver tallas

Doble clic para ampliar

SKU: SLST3677

Café color hold ups

Stock:

Sublime sus piernas con nuestras glamurosas medias de nailon en un inusual color café.

Talla:

¿No sabe qué talla elegir? Consulte nuestra guía de tallas

Color:

Cantidad:

19.95 €

Envío rápido

para los impacientes...

Ayuda y consejos

por chat, facebook o correo electrónico

Devoluciones gratuitas

en un plazo de 15 días *

Medias autoadherentes talla grande café

Descripción
Especificaciones

Descripción del producto

Descubra el glamour de nuestras medias de nailon Couleur Café.

Medias de silicona bajo el encaje, y un color precioso, original y sensual.

Detalles técnicos

Tallas disponibles

Disponible de 2-4 a 5-6

Color disponible

Marrón

Composición

Nilón	85 %
Spandex	15 %

To Top

Te sitúas en:
Estados Unidos

Su idioma es: español

Ver los precios en: EUR (€)

Guardar mis preferencias

Continuar

Cambiar mi configuración

País Idioma

Guardar mis preferencias

Cancelar

Struct
Entries: 108

actions

Array

available

number

brand

string

dreamgirl

brandcode

string

ddru

branding

string

divasboudoir,legsboudoir

brandmedias

string

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

brandmetas

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

brandname

string

Dreamgirl

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.694 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,'brown') > 0 and product_variations.productuid = '971D85BF-B51B-4AF7-91FE3F90ACBB0B39' 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	brown	color	brow	brown	brown	#783D00	-1	1

colorrange

string

brown

colors

string

brown

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 '2023-10-17 18:36:34'}

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

true

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

number

isactive

number

iscustommade

number

isdivasize

number

isfirstprice

number

isfixedprice

number

ishot

number

isnew

number

isonline

number

isoutletprice

number

itemprice

number

16.625

itempromo

string

key

string

dg0005xesp

language

string

all

lastupdated

Date Time (Europe/Paris)

{ts '2025-10-01 17:53:44'}

linkedactions

Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.63 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','es')
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('971d85bf-b51b-4af7-91fe3f90acbb0b39',lcase(cart_actions.linkedproducts)) > 0 and cart_actions.linkedproducts is not null
)

id_action

branding

language

name

code

type

minimumOrder

maximumOrder

minimumItems

maximumItems

maximumUse

allowedItems

quotas

usedCount

linkedproducts

linkedthemes

linkedbrands

linkeditem

params

activeFrom

activeTo

isActive

linkedproducts

Query
Template: /system/api/products.cfc:1305
Execution Time: 1.41 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','es')
and product_categories.language in ('all','es')
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 <> 'SLST3677'
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

category

subcategory

linkuid

string

materials

string

mediadatas

Struct

alt

Struct

height

string

1500

isprivate

string

rating

string

all

src

string

/photobank/products/ddru/slst3677/35966.jpg

type

string

img

width

string

1000

back

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

default

Struct

height

string

1500

isprivate

string

rating

string

all

src

string

/photobank/products/ddru/slst3677/35965.jpg

type

string

img

width

string

1000

variations

Struct

colors

Struct

brown

Struct

height

string

1500

isprivate

string

rating

string

all

src

string

/photobank/products/ddru/slst3677/35965.jpg

type

string

img

width

string

1000

video

Struct

embedsrc

string

height

string

isprivate

string

rating

string

src

string

thumb

Struct

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

high

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

maxres

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

medium

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

standard

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

type

string

width

string

mediagallery

string

metadatas

Struct

darkboudoir

Struct

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-braun

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

-kafe

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

-borwn

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

-marron

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

-marron

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

-marrone

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

-bruin

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

-castanho

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

divasboudoir

Struct

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Entdecken Sie den Glamour unserer Couleur Café Nylonstrümpfe. Selbstfixierendes Strumpfband aus Silikon unter der Spitze und wunderschöne, originelle und sinnliche Farbe.

guid

string

https://dev.divasboudoir.com/de/selbstfixierende-strumpfe-grosse-grosse-cafe-braun/slst3677.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Entscheiden Sie sich für Qualität und Stil mit unseren selbstfixierenden Strümpfen in großen Größen in der Farbe Kaffee. Ihr einzigartiges Design sorgt für einen eleganten Look in jeder Situation.

keywords

string

title

string

Selbstfixierende Strümpfe in großen Größen, ultra glamourös in der Farbe Kaffee.

seotitle

string

Selbstfixierende Strümpfe große Größe Kaffee

seouri

string

selbstfixierende-strumpfe-grosse-grosse-cafe-braun

specifications

string

stylingtips

string

summary

string

Veredeln Sie Ihre Beine mit unseren glamourösen Nylonstrümpfen in einer außergewöhnlichen Kaffeefarbe.

title

string

Selbstfixierende Strümpfe Couleur Café

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Ανακαλύψτε τη γοητεία των νάιλον καλτσών Couleur Café. Σιλικόνη που συγκρατεί κάτω από τη δαντέλα και ένα όμορφο, πρωτότυπο και αισθησιακό χρώμα.

guid

string

https://dev.divasboudoir.com/el/aytokollhtes-kaltses-megaloy-megethoys-kafe-kafe/slst3677.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Επιλέξτε την ποιότητα και το στυλ με τα καφετιά μας hold-ups. Ο μοναδικός σχεδιασμός τους σημαίνει ότι θα δείχνετε κομψοί σε κάθε περίσταση.

keywords

string

title

string

Εξαιρετικά λαμπερές ληστείες στο χρώμα του καφέ.

seotitle

string

Αυτοκόλλητες κάλτσες μεγάλου καφέ

seouri

string

aytokollhtes-kaltses-megaloy-megethoys-kafe-kafe

specifications

string

stylingtips

string

summary

string

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

title

string

Καφέ χρώμα hold ups

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Discover the glamour of our Couleur Café nylon stockings. Silicone hold-ups under lace, and beautiful, original, sensual color.

guid

string

https://dev.divasboudoir.com/en/plus-size-hold-ups-cafe-brown/slst3677.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Opt for quality and style with our coffee-colored plus size hold-ups. Their unique design ensures an elegant look in all circumstances.

keywords

string

title

string

Ultra-glamorous coffee-colored plus size hold-ups.

seotitle

string

Stay-up stockings plus size coffee

seouri

string

plus-size-hold-ups-cafe-brown

specifications

string

stylingtips

string

summary

string

Enhance your gams with our glamorous coffee-colored nylon stockings.

title

string

Couleur Café hold ups

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Descubra el glamour de nuestras medias de nailon Couleur Café. Medias de silicona bajo el encaje, y un color precioso, original y sensual.

guid

string

https://dev.divasboudoir.com/es/medias-autoadherentes-talla-grande-cafe-marron/slst3677.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Apueste por la calidad y el estilo con nuestras medias de color café. Su diseño exclusivo te permitirá lucir elegante en cualquier situación.

keywords

string

title

string

Tallas grandes de color café.

seotitle

string

Medias autoadherentes talla grande café

seouri

string

medias-autoadherentes-talla-grande-cafe-marron

specifications

string

stylingtips

string

summary

string

Sublime sus piernas con nuestras glamurosas medias de nailon en un inusual color café.

title

string

Café color hold ups

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Découvrez le glamour de nos bas nylon Couleur Café. Jarretière autofixante en silicone sous la dentelle, et magnifique couleur originale et sensuelle.

guid

string

https://dev.divasboudoir.com/fr/bas-autofixants-grande-taille-cafe-marron/slst3677.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Optez pour la qualité et le style avec nos bas autofixants grande taille couleur café. Leur design unique vous assure une allure élégante en toute circonstance.

keywords

string

title

string

Bas autofixants grande taille ultra glamour couleur café.

seotitle

string

Bas autofixants grande taille café

seouri

string

bas-autofixants-grande-taille-cafe-marron

specifications

string

stylingtips

string

summary

string

Sublimez vos gambettes avec nos bas nylon glamour d'une couleur café hors du comun.

title

string

Bas autofixants Couleur Café

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Scoprite il fascino delle nostre calze di nylon Couleur Café. Il pizzo è rivestito di silicone e il colore è bello, originale e sensuale.

guid

string

https://dev.divasboudoir.com/it/calze-autofissanti-taglia-grande-cafe-marrone/slst3677.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Scegliete la qualità e lo stile con le nostre autoreggenti color caffè. Il loro design unico vi permetterà di essere eleganti in qualsiasi situazione.

keywords

string

title

string

Autoreggenti di grande taglia color caffè.

seotitle

string

Calze autoreggenti taglia grande caffè

seouri

string

calze-autofissanti-taglia-grande-cafe-marrone

specifications

string

stylingtips

string

summary

string

Sublimate le vostre gambe con le nostre calze di nylon glamour in un insolito color caffè.

title

string

Colore del caffè

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Ontdek de glamour van onze Couleur Café nylonkousen. Siliconen hold-ups onder het kant en een mooie, originele en sensuele kleur.

guid

string

https://dev.divasboudoir.com/nl/zelfsluitende-kousen-grote-maat-cafe-bruin/slst3677.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Kies voor kwaliteit en stijl met onze koffiekleurige hold-ups. Met hun unieke ontwerp zie je er in elke situatie elegant uit.

keywords

string

title

string

Grote maten koffiekleurige hold-ups.

seotitle

string

Zelfsluitende kousen grote maat koffie

seouri

string

zelfsluitende-kousen-grote-maat-cafe-bruin

specifications

string

stylingtips

string

summary

string

Sublimeer je benen met onze glamoureuze nylonkousen in een ongebruikelijke koffiekleur.

title

string

Café kleur hold ups

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Descubra o glamour das nossas meias de nylon Couleur Café. Meias de silicone por baixo da renda e uma cor bonita, original e sensual.

guid

string

https://dev.divasboudoir.com/pt/meias-auto-fixantes-tamanho-grande-cafe-castanho/slst3677.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Opte pela qualidade e pelo estilo com as nossas pegas cor de café. O seu design único significa que ficará elegante em qualquer situação.

keywords

string

title

string

Assaltos ultra-glamorosos cor de café.

seotitle

string

Meias auto-fixantes café grandes

seouri

string

meias-auto-fixantes-tamanho-grande-cafe-castanho

specifications

string

stylingtips

string

summary

string

Sublime as suas pernas com as nossas glamorosas meias de nylon numa invulgar cor de café.

title

string

Fixação da cor do café

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

-braun

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

-kafe

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

-borwn

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

-marron

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

-marron

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

-marrone

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

-bruin

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

-castanho

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

-braun

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

-kafe

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

-borwn

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

-marron

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

-marron

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

-marrone

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

-bruin

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

-castanho

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

legsboudoir

Struct

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Diese kaffeefarbenen Nylonstrümpfe verkörpern Raffinesse und Originalität. Die einzigartige kaffeebraune Farbe verleiht den Strümpfen eine natürliche Raffinesse, die sich von herkömmlichen Farben abhebt und einen sinnlichen und eleganten Look kreiert. Das selbstfixierende Strumpfband aus Silikon, das diskret unter der Spitze platziert ist, sorgt für perfekten Halt, ohne die Haut einzuengen. Diese innovative Technologie ermöglicht absolute Bewegungsfreiheit und stellt gleichzeitig sicher, dass Ihre Strümpfe makellos an ihrem Platz bleiben. Hochwertiges Nylon bietet eine seidige Textur, die sich sanft an die Kurven schmiegt und für außergewöhnlichen Tragekomfort bei langen Tragezeiten sorgt. Dieses edle Material garantiert optimale Festigkeit und lang anhaltende Eleganz. Diese Strümpfe wurden entwickelt, um Ihre Beine zu betonen, und sorgen für eine schlanke Silhouette und einen besonders schmeichelhaften optischen Effekt. Ihre sinnliche Kaffeefarbe unterstreicht auf natürliche Weise die Schönheit jeder Körperform mit einem unvergleichlichen Glamour.

highlights

string

<ul> <li>AußergewöhnlicheOriginal-Kaffeefarbe</li> <li>Hochwertiges Nylon für ein seidiges Gefühl</li> <li>Selbstfixierendes Strumpfband aus Silikon unter der Spitze</li> <li>Sinnlicher Farb ton, der den Teint verschönert</li> <li>Optimaler Halt den ganzen Tag lang</li> <li>Glamouröser Stil für jeden Körperbau</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Kaffeefarbene Nylonstrümpfe in großen Größen mit Silikonstrumpfband. Origineller und sinnlicher Farbton für einen glamourösen Stil bei Leg's Boudoir. Schneller Versand.

keywords

string

title

string

Nylonstrümpfe Farbe Kaffee Große Größe Glamour | Leg's Boudoir

seotitle

string

Nylonstrümpfe Farbe Kaffee Große Größe

seouri

string

kaffeefarbene-nylonstrumpfe-in-grossen-grossen

specifications

string

<ul> <li>Material: Hochwertiges Nylon</li> <li>Farbe: Kaffee</li> <li>Typ: Autofixants mit Silikonstrumpfband</li> <li>Ausführung: Spitze mit Silikonband</li> <li>Stil: Glamourös</li> <li>Größen: In verschiedenen Größen erhältlich</li> </ul>

stylingtips

string

Die originelle Kaffeefarbe dieser Strümpfe macht sie zu raffinierten Stücken, die sich perfekt für die Kreation raffinierter Looks eignen. Dieser Farbton lässt sich harmonisch mit Gold-, Beige- oder Schokoladentönen kombinieren, wodurch eine warme Farbpalette entsteht. Kombinieren Sie sie mit herbstlichen Outfits oder Vintage-Looks für einen außergewöhnlichen Glamour-Stil, der garantiert für Aufsehen sorgen wird. Erkunden Sie unsere Kategorie <a href="https://www.legsboudoir.com/de/bodystocking-und-catsuits/">Bodystockings</a>, um Ihre gesamte Silhouette zu betonen.

summary

string

Entdecken Sie den Glamour unserer kaffeebraunen Nylonstrümpfe, ein origineller und sinnlicher Farbton, der Ihre Beine mit Eleganz umschmeichelt. Diese selbstfixierenden Strümpfe bieten perfekten Halt dank ihres Silikonstrumpfbandes mit Spitze.

title

string

Kaffeefarbene Nylonstrümpfe - Origineller Glamour und Sinnlichkeit

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

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

highlights

string

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

keypoint

string

keywords

string

metas

Struct

description

string

Μεγάλες νάιλον κάλτσες χρώματος καφέ με ζαρτιέρα σιλικόνης. Πρωτότυπη και αισθησιακή απόχρωση για ένα λαμπερό στυλ στο Leg's Boudoir. Γρήγορη αποστολή.

keywords

string

title

string

Κάλτσες από νάιλον καφέ μεγάλο μέγεθος Glamour | Boudoir του ποδιού

seotitle

string

Κάλτσες νάιλον Χρώμα καφέ Μεγάλο μέγεθος

seouri

string

kafe-nailon-kaltses-megalo-megethos

specifications

string

<ul> <li>Υλικό: Νάιλον υψηλής ποιότητας</li> <li>Χρώμα : Καφές</li> <li>Τύπος : Hold ups με καλτσοδέτα σιλικόνης</li> <li>Φινίρισμα : Δαντέλα με ζώνη σιλικόνης</li> <li>Στυλ : Glamour</li> <li>Μεγέθη : Διατίθεται σε διάφορα μεγέθη</li> </ul>

stylingtips

string

Το πρωτότυπο καφέ χρώμα αυτών των καλτσών τις καθιστά εκλεπτυσμένα κομμάτια ιδανικά για τη δημιουργία εκλεπτυσμένων εμφανίσεων. Αυτή η απόχρωση συνδυάζεται αρμονικά με χρυσές, μπεζ ή σοκολατί αποχρώσεις για μια ζεστή χρωματική παλέτα. Συνδυάστε με φθινοπωρινές ή vintage εμφανίσεις για ένα λαμπερό στυλ που σίγουρα θα κάνει αίσθηση. Εξερευνήστε την κατηγορία μας <a href="https://www.legsboudoir.com/el/bodystocking-kai-catsuits/">Bodystockings</a>για να αναδείξετε ολόκληρη τη σιλουέτα σας.

summary

string

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

title

string

Café Nylon Κάλτσες - Λάμψη και αυθεντικός αισθησιασμός

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

These coffee-colored nylon stockings are the epitome of refinement and originality. Their unique coffee hue brings a natural sophistication that stands out from classic colors, creating a look that's both sensual and distinguished. The self-fixing silicone garter discreetly placed under the lace ensures perfect support without compressing the skin. This innovative technology allows total freedom of movement while ensuring that your stockings stay impeccably in place. High-quality nylon offers a silky texture that gently hugs curves, providing exceptional comfort for extended wear. This noble material guarantees optimum resistance and long-lasting elegance. Designed to enhance your legs, these stockings create a slender silhouette and a particularly flattering visual effect. Their sensual coffee color naturally enhances the beauty of every body type with incomparable glamour.

highlights

string

<ul> <li>Outstanding original coffee color</li> <li>High-quality nylon for a silky feel</li> <li>Self-fastening silicone garter under the lace</li> <li>Sensual hue enhances the complexion</li> <li>Optimal support all day long</li> <li>Glamorous style for all body types</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Plus size coffee-colored nylon stockings with silicone garter. Original, sensual hue for glamorous style at Leg's Boudoir. Envoir Rapide.

keywords

string

title

string

Nylon Stockings Coffee Color Plus Size Glamour | Leg's Boudoir

seotitle

string

Nylon Stockings Color Coffee Plus Size

seouri

string

cafe-nylon-stockings-plus-size

specifications

string

<ul> <li>Material: High-quality nylon</li> <li>Color: Coffee</li> <li>Type : Garters with silicone garter</li> <li>Finish : Lace with silicone band</li> <li>Style : Glamour</li> <li>Sizes : Available in several sizes</li> </ul>

stylingtips

string

The original coffee color of these stockings makes them sophisticated pieces perfect for creating refined looks. This hue blends harmoniously with gold, beige or chocolate tones for a warm chromatic palette. Pair them with autumn or vintage looks for a glamorous, out-of-the-ordinary style that's sure to make a splash. Explore our <a href="https://www.legsboudoir.com/en/bodystocking-and-catsuits/">Bodystockings</a>category to enhance your entire figure.

summary

string

Discover the glamour of our coffee-colored nylon stockings, an original, sensual shade that enhances your legs with elegance. These hold-ups offer perfect support thanks to their silicone garter under lace.

title

string

Nylon Stockings Coffee Color - Glamour and Original Sensuality

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Estas medias de nailon de color café son el epítome del refinamiento y la originalidad. Su tonalidad café única aporta una sofisticación natural que se distingue de los colores clásicos, creando un look a la vez sensual y distinguido. El liguero de silicona autoadherente, discretamente colocado bajo el encaje, garantiza una sujeción perfecta sin comprimir la piel. Esta innovadora tecnología permite una total libertad de movimientos al tiempo que garantiza que las medias permanezcan impecablemente en su sitio. El nailon de alta calidad ofrece una textura sedosa que abraza suavemente las curvas, proporcionando un confort excepcional durante un uso prolongado. Este noble material garantiza una resistencia óptima y una elegancia duradera. Diseñadas para realzar sus piernas, estas medias crean una silueta esbelta y un efecto visual particularmente favorecedor. Su sensual color café realza de forma natural la belleza de cada silueta con un glamour incomparable.

highlights

string

<ul> <li>Extraordinario color café original</li> <li>Nylon de alta calidad para un tacto sedoso</li> <li>Liguero de silicona autoadherente bajo el encaje</li> <li>Tono sensual para realzar la tez</li> <li>Sujeción óptima durante todo el día</li> <li>Estilo glamuroso para todas las formas</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Medias grandes de nailon color café con liguero de silicona. Tono original y sensual para un estilo glamuroso en Leg's Boudoir. Envío rápido.

keywords

string

title

string

Café Medias de nylon talla grande Glamour | Leg's Boudoir

seotitle

string

Medias de Nylon Color Café Talla grande

seouri

string

cafe-medias-de-nylon-talla-grande

specifications

string

<ul> <li>Material: Nylon de alta calidad</li> <li>Color : Café</li> <li>Tipo : Medias con liga de silicona</li> <li>Acabado : Encaje con banda de silicona</li> <li>Estilo : Glamour</li> <li>Tallas : Disponible en varias tallas</li> </ul>

stylingtips

string

El original color café de estas medias las convierte en piezas sofisticadas perfectas para crear looks refinados. Este tono combina armoniosamente con tonos dorados, beige o chocolate para conseguir una paleta de colores cálida. Combínelas con looks otoñales o vintage para conseguir un estilo glamuroso que no pasará desapercibido. Explore nuestra categoría <a href="https://www.legsboudoir.com/es/bodystockings-y-catsuits/">Bodystockings</a>para realzar toda su figura.

summary

string

Descubra el glamour de nuestras medias de nailon color café, un tono original y sensual que realza sus piernas con elegancia. Estas medias de sujeción ofrecen una sujeción perfecta gracias a su liguero de silicona bajo encaje.

title

string

Medias de Nylon Color Café - Glamour y Sensualidad Original

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Ces bas nylon couleur café incarnent le raffinement et l'originalité. Leur teinte café unique apporte une sophistication naturelle qui se démarque des coloris classiques, créant un look à la fois sensuel et distingué. La jarretière autofixante en silicone placée discrètement sous la dentelle assure un maintien parfait sans comprimer la peau. Cette technologie innovante permet une liberté de mouvement totale tout en garantissant que vos bas restent impeccablement en place. Le nylon haute qualité offre une texture soyeuse qui épouse délicatement les courbes, procurant un confort exceptionnel pour un port prolongé. Cette matière noble garantit une résistance optimale et une élégance durable. Conçus pour sublimer vos jambes, ces bas créent une silhouette élancée et un effet visuel particulièrement flatteur. Leur couleur café sensuelle valorise naturellement la beauté de chaque morphologie avec un glamour incomparable.

highlights

string

<ul> <li>Couleur café originale hors du commun</li> <li>Nylon haute qualité pour un toucher soyeux</li> <li>Jarretière autofixante en silicone sous la dentelle</li> <li>Teinte sensuelle qui sublime le teint</li> <li>Maintien optimal toute la journée</li> <li>Style glamour pour toutes les morphologies</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Bas nylon couleur café grande taille avec jarretière silicone. Teinte originale et sensuelle pour un style glamour chez Leg's Boudoir. Envoir Rapide.

keywords

string

title

string

Bas Nylon Couleur Café Grande Taille Glamour | Leg's Boudoir

seotitle

string

Bas Nylon Couleur Café Grande Taille

seouri

string

bas-nylon-couleur-cafe-grande-taille

specifications

string

<ul> <li>Matière : Nylon haute qualité</li> <li>Couleur : Café</li> <li>Type : Autofixants avec jarretière silicone</li> <li>Finition : Dentelle avec bande silicone</li> <li>Style : Glamour</li> <li>Tailles : Disponibles en plusieurs tailles</li> </ul>

stylingtips

string

La couleur café originale de ces bas en fait des pièces sophistiquées parfaites pour créer des looks raffinés. Cette teinte se marie harmonieusement avec des tons dorés, beiges ou chocolat pour une palette chromatique chaleureuse.  Associez-les à des tenues automnales ou des looks vintage pour un style glamour hors du commun qui ne manquera pas de faire sensation. Explorez notre catégorie <a href="https://www.legsboudoir.com/fr/bodystocking-et-catsuits/">Bodystocking</a>s pour sublimer toute votre silhouette.

summary

string

Découvrez le glamour de nos bas nylon couleur café, une teinte originale et sensuelle qui sublime vos jambes avec élégance. Ces bas autofixants offrent un maintien parfait grâce à leur jarretière en silicone sous dentelle.

title

string

Bas Nylon Couleur Café - Glamour et Sensualité Originale

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Queste calze di nylon color caffè sono l'epitome della raffinatezza e dell'originalità. La loro esclusiva tonalità caffè conferisce una naturale raffinatezza che si distingue dai colori classici, creando un look sensuale e distinto. La giarrettiera in silicone autofissante, posizionata discretamente sotto il pizzo, assicura un sostegno perfetto senza comprimere la pelle. Questa tecnologia innovativa consente una totale libertà di movimento e garantisce che le calze rimangano impeccabilmente al loro posto. Il nylon di alta qualità offre una texture setosa che abbraccia delicatamente le curve, offrendo un comfort eccezionale per un uso prolungato. Questo materiale nobile garantisce una resistenza ottimale e un'eleganza duratura. Progettate per valorizzare le gambe, queste calze creano una silhouette snella e un effetto visivo particolarmente lusinghiero. Il loro sensuale color caffè esalta naturalmente la bellezza di ogni forma del corpo con un glamour incomparabile.

highlights

string

<ul> <li>Eccezionale colore caffè originale</li> <li>Nylon di alta qualità per una sensazione setosa</li> <li>Giarrettiera in silicone autofissante sotto il pizzo</li> <li>Tonalità sensuale per esaltare la carnagione</li> <li>Sostegno ottimale per tutto il giorno</li> <li>Stile glamour per tutte le forme del corpo</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Calze grandi in nylon color caffè con giarrettiera in silicone. Tonalità originale e sensuale per uno stile glamour da Leg's Boudoir. Spedizione veloce.

keywords

string

title

string

Calze di nylon caffè Taglia grande Glamour | Leg's Boudoir

seotitle

string

Calze di nylon colore caffè taglia grande

seouri

string

calze-di-nylon-cafe-taglia-grande

specifications

string

<ul> <li>Materiale: nylon di alta qualità</li> <li>Colore : Caffè</li> <li>Tipo : Autoreggenti con giarrettiera in silicone</li> <li>Finitura : Pizzo con fascia in silicone</li> <li>Stile : Glamour</li> <li>Taglie : Disponibile in diverse misure</li> </ul>

stylingtips

string

L'originale color caffè di queste calze le rende pezzi sofisticati, perfetti per creare look raffinati. Questa tonalità si abbina armoniosamente ai toni dell'oro, del beige o del cioccolato per una palette di colori caldi. Abbinatele a look autunnali o vintage per uno stile glamour che non passa inosservato. Esplorate la nostra categoria <a href="https://www.legsboudoir.com/it/bodystocking-e-tute/">Bodystockings</a>per valorizzare tutta la vostra figura.

summary

string

Scoprite il fascino delle nostre calze di nylon color caffè, una tonalità originale e sensuale che esalta le vostre gambe con eleganza. Queste calze autoreggenti offrono un sostegno perfetto grazie alla giarrettiera in silicone sotto il laccio.

title

string

Calze di nylon Café - Glamour e sensualità originale

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Deze koffiekleurige nylonkousen zijn het toppunt van verfijning en originaliteit. Hun unieke koffiekleur zorgt voor een natuurlijke verfijning die zich onderscheidt van klassieke kleuren en creëert een look die zowel sensueel als gedistingeerd is. De zelfbevestigende siliconen kousenband, discreet geplaatst onder het kant, zorgt voor perfecte ondersteuning zonder de huid samen te drukken. Deze innovatieve technologie zorgt voor totale bewegingsvrijheid terwijl je kousen onberispelijk op hun plaats blijven zitten. Hoogwaardig nylon biedt een zijdeachtige textuur die de rondingen zachtjes omsluit en uitzonderlijk comfort biedt voor langdurig dragen. Dit edele materiaal garandeert optimale weerstand en langdurige elegantie. Deze kousen zijn ontworpen om je benen te verbeteren en creëren een slank silhouet en een bijzonder flatterend visueel effect. Hun sensuele koffiekleur benadrukt op natuurlijke wijze de schoonheid van elke lichaamsvorm met een onvergelijkbare glamour.

highlights

string

<ul> <li>Uitstekende originele koffiekleur</li> <li>Hoogwaardig nylon voor een zijdezacht gevoel</li> <li>Zelfsluitende siliconen kousenband onder het kant</li> <li>Sensuele tint om de teint te verbeteren</li> <li>Optimale ondersteuning de hele dag lang</li> <li>Glamoureuze stijl voor alle lichaamsvormen</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Grote koffiekleurige nylonkousen met siliconen kousenband. Originele en sensuele tint voor een glamoureuze stijl bij Leg's Boudoir. Snelle verzending.

keywords

string

title

string

Coffee Nylon Kousen Grote Maat Glamour Been's Boudoir

seotitle

string

Nylon Kousen Kleur Koffie Grote Maat

seouri

string

cafe-nylonkousen-grote-maat

specifications

string

<ul> <li>Materiaal: Nylon van hoge kwaliteit</li> <li>Kleur : Koffie</li> <li>Type : Hold ups met siliconen kousenband</li> <li>Afwerking: Kant met siliconenband</li> <li>Stijl : Glamour</li> <li>Maten : Verkrijgbaar in verschillende maten</li> </ul>

stylingtips

string

De originele koffiekleur van deze kousen maakt ze tot geraffineerde stukken die perfect zijn voor het creëren van verfijnde looks. Deze tint combineert harmonieus met goud-, beige- of chocoladetinten voor een warm kleurenpalet. Combineer met herfstachtige of vintage looks voor een glamoureuze stijl waarmee je zeker een statement maakt. Verken onze <a href="https://www.legsboudoir.com/nl/bodystocking-en-catsuits/">Bodystockings</a>categorie om je hele figuur te verbeteren.

summary

string

Ontdek de glamour van onze koffiekleurige nylonkousen, een originele, sensuele tint die je benen elegant accentueert. Deze hold-ups bieden perfecte ondersteuning dankzij hun siliconen kousenband onder kant.

title

string

Nylon Kousen Kleur - Glamour en Original Sensuality

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Estas meias de nylon cor de café são o epítome do requinte e da originalidade. A sua tonalidade única de café confere uma sofisticação natural que se destaca das cores clássicas, criando um visual simultaneamente sensual e distinto. A liga de silicone auto-fixante, colocada discretamente sob a renda, garante um apoio perfeito sem comprimir a pele. Esta tecnologia inovadora permite uma total liberdade de movimentos, assegurando ao mesmo tempo que as meias se mantêm impecavelmente no sítio. O nylon de alta qualidade oferece uma textura sedosa que abraça suavemente as curvas, proporcionando um conforto excecional para uma utilização prolongada. Este material nobre garante uma resistência óptima e uma elegância duradoura. Concebidas para realçar as suas pernas, estas meias criam uma silhueta esguia e um efeito visual particularmente lisonjeiro. A sua cor café sensual realça naturalmente a beleza de cada forma de corpo com um glamour incomparável.

highlights

string

<ul> <li>Cor de café original e excecional</li> <li>Nylon de alta qualidade para um toque sedoso</li> <li>Liga de silicone auto-ajustável por baixo da renda</li> <li>Tonalidade sensual para realçar a tez</li> <li>Apoio ótimo durante todo o dia</li> <li>Estilo glamoroso para todas as formas do corpo</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Meias grandes de nylon cor de café com liga de silicone. Tonalidade original e sensual para um estilo glamoroso em Leg's Boudoir. Envio rápido.

keywords

string

title

string

Meias de nylon café Tamanho grande Glamour | Leg's Boudoir

seotitle

string

Meias de nylon Colour Coffee Tamanho grande

seouri

string

meias-de-nylon-cafe-tamanho-grande

specifications

string

<ul> <li>Material: Nylon de alta qualidade</li> <li>Cor : Café</li> <li>Tipo : Suspensórios com liga de silicone</li> <li>Acabamento : Renda com banda de silicone</li> <li>Estilo : Glamour</li> <li>Tamanhos : Disponível em vários tamanhos</li> </ul>

stylingtips

string

A cor café original destas meias torna-as peças sofisticadas, perfeitas para criar looks requintados. Esta tonalidade combina harmoniosamente com tons de dourado, bege ou chocolate para uma paleta de cores quentes. Combine-as com looks outonais ou vintage para um estilo glamoroso que não deixará de marcar a diferença. Explore a nossa categoria de <a href="https://www.legsboudoir.com/pt/bodystocking-e-catsuits/">Bodystockings</a>para realçar toda a sua figura.

summary

string

Descubra o glamour das nossas meias de nylon cor de café, um tom original e sensual que realça as suas pernas com elegância. Estas meias de ligas oferecem um apoio perfeito graças à sua liga de silicone sob o laço.

title

string

Meias de nylon Colour Coffee - Glamour e Sensualidade Original

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

-braun

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

-kafe

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

-borwn

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

-marron

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

-marron

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

-marrone

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

-bruin

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

-castanho

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

smboudoir

Struct

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-braun

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

-kafe

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

-borwn

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

-marron

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

-marron

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

-marrone

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

-bruin

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

-castanho

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

name

string

DG0005XESP

netweight

string

nextshipment

string

tomorrow

ordered

number

orderidx

number

origin

string

originalsize

string

packaging

number

productshipment

string

1to2days

productuid

string

971D85BF-B51B-4AF7-91FE3F90ACBB0B39

promountil

string

rating

string

none

recorduid

string

971D85BF-B51B-4AF7-91FE3F90ACBB0B39

reference

string

SLST3677

string

reserved

number

returned

number

returnsallowed

number

section

string

lingerie

shipment

string

1to2days

showbrand

number

sizeinfos

Query Template: /system/api/product/sizes.cfc:20 Execution Time: 1.24 ms Record Count: 2 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,'1816,1112') > 0 and product_variations.productuid = '971D85BF-B51B-4AF7-91FE3F90ACBB0B39' 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	1816	2-4	intlsize	brown	2	4	-1	999999	0	w	plus	stocking	One	2-4		34-40	4-10	8-12	36-42	36-42	34-40	40-46	36-42	34-40
2	1112	5-6	intlsize	brown	5	6	-1	999999	1	w	plus	stocking	Queen	5-6		42-48	12-18	16-22	44-50	44-50	42-48	48-52	44-50	42-48

sizeranges

string

plus,standard

sizes

string

1816,1112

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: 3.47 ms Record Count: 2 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 = '971D85BF-B51B-4AF7-91FE3F90ACBB0B39' and product_variations.isactive = 1 and product_sizes.id_size = 1816 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 = '971D85BF-B51B-4AF7-91FE3F90ACBB0B39' and product_variations.isactive = 1 and product_sizes.id_size = 1112 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	971D85BF-B51B-4AF7-91FE3F90ACBB0B39	A0F3EB7F-954F-4D05-B8FEB212C92CAFC4	1816	brown	#783D00	One	2-4		34-40	4-10	8-12	36-42	36-42	34-40	40-46	36-42	34-40	w	stocking		2-4	intlsize	16.625	0		STOCK01	0	0	0	-1	0	0	0	0			-1	0	all
2	971D85BF-B51B-4AF7-91FE3F90ACBB0B39	C8753003-0A5B-4504-82980D58559AE671	1112	brown	#783D00	Queen	5-6		42-48	12-18	16-22	44-50	44-50	42-48	48-52	44-50	42-48	w	stocking		5-6	intlsize	16.625	0		STOCK01	1	0	0	-1	0	9	0	0	0005X	888368333196	1	1	all

subcategory

string

stocking

supplier

number

-1

supplierreference

string

DG0005X

Medias autoadherentes talla grande café

Descripción del producto

Detalles técnicos

Tallas disponibles

Color disponible

Composición

INFORMACIÓN

AREA DE MIEMBROS

SERVICIOS

CONTACTO

Medias autoadherentes talla grande café

Descripción del producto

Detalles técnicos

Tallas disponibles

Color disponible

Composición

Newsletter

Cambiar mi configuración

Guardar mis preferencias