Siehe Größen

Doppelklicken Sie zum Vergrößern

SKU: SLST7862

Katzenstrumpf

Lager:

Betonen Sie Ihre katzenhafte Seite mit diesen wunderschönen Strümpfen für Strapsgürtel.

Größe:

Sie wissen nicht, welche Größe Sie wählen sollen? Sehen Sie sich unseren Größenratgeber an

Farbe:

Menge:

19.95 €

Schneller Versand

für die Ungeduldigen unter Ihnen

Fundierte Ratschläge

per Chat, Facebook oder E-Mail

Kostenlose Rücksendungen

innerhalb von 15 Tagen *

Katzenstrumpf groß

Beschreibung
Spezifikationen

Produktbeschreibung

Feline Strümpfe aus Netzstoff mit Leopardenmuster.

Oberschenkel mit einfarbigem Band.

Technische Details

Verfügbare Größen

Erhältlich von 2-4 bis 5-6

Verfügbare Farbe

Schwarz

To Top

Ihr Standort ist:
vereinigte Staaten von Amerika

Deine Sprache ist: Deutsch

Die Preise sind in: EUR (€)

Meine Einstellungen speichern

Weiter

Meine Einstellungen ändern

Land Sprache

Meine Einstellungen speichern

Abbrechen

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.619 ms Record Count: 1 Cached: No Datasource: divasboudoir_sitedatas Lazy: No SQL: select product_colors.color as recorduid, product_colors.type, product_colors.code, product_colors.color, product_colors.range, product_colors.hexvalue, (if( (select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0, -1, if( sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0, sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved), 0 ) )) as available, IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock from product_colors left outer join product_variations on product_colors.color = product_variations.color and product_variations.isactive = 1 left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01' where FIND_IN_SET(product_colors.color,'black') > 0 and product_variations.productuid = 'F5AAF312-7C7B-42FA-81E5CF7FF4B4EE0C' group by product_colors.range,product_colors.color order by product_colors.range,product_colors.color
	recorduid	type	code	color	range	hexvalue	available	stock
1	black	color	blak	black	black	#000000	-1	1

colorrange

string

black

colors

string

black

colortype

string

color

comments

string

compositions

Struct
Entries: 13

coton

string

elastane

string

free

string

leather

string

lycra

string

metal

string

nylon

string

polyamide

string

polyester

string

polyurethane

string

silk

string

spandex

string

viscose

string

datecreated

Date Time (Europe/Paris)

{ts '2024-01-19 14:29:12'}

defect

number

dimensions

Struct
Entries: 14

acrylicbones

string

backsideheight

string

diameter

string

flatsteelbones

string

frontsideheight

string

fullheight

string

length

string

modestysize

string

panels

string

sides

string

spiralsteelbones

string

totallength

string

unit

string

wiresize

string

display

string

all

displayfrom

string

displayto

string

grossweight

string

hasbrandinfos

boolean

false

hascareinstructions

boolean

false

hascolorinfos

boolean

true

hascompositions

boolean

false

hasdescription

boolean

true

hasdimensions

boolean

false

hasmaterials

boolean

false

hasotherspecifications

boolean

false

haspromo

number

hasshortdescription

boolean

true

hassizeinfos

boolean

true

hasspecifications

boolean

false

hasstockinfos

boolean

false

hasstylingtips

boolean

false

hasusageinstructions

boolean

false

hasvariations

boolean

true

import

string

inpromo

number

instockvariations

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

bas-grande-taille-noir-en-resille-avec-motif-leopard---dg0347xblk

language

string

all

lastupdated

Date Time (Europe/Paris)

{ts '2025-10-10 11:38:51'}

linkedactions

Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.596 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','de')
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('f5aaf312-7c7b-42fa-81e5cf7ff4b4ee0c',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.33 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','de')
and product_categories.language in ('all','de')
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 <> 'SLST7862'
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

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

1500

isprivate

string

rating

string

all

src

string

/photobank/products/ddru/slst7862/23177.jpg

type

string

img

width

string

1000

variations

Struct

colors

Struct

black

Struct

height

string

1500

isprivate

string

rating

string

all

src

string

/photobank/products/ddru/slst7862/23177.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

-schwarz

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-mayro

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-black

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-negro

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-noir

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-nero

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-zwart

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-preto

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

divasboudoir

Struct

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Feline Strümpfe aus Netzstoff mit Leopardenmuster. Oberschenkel mit einfarbigem Band.

guid

string

https://dev.divasboudoir.com/de/katzenstrumpf-gross-schwarz/slst7862.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Veredeln Sie Ihre Beine und stellen Sie Ihre katzenhafte Seite in den Vordergrund mit unseren speziellen Strümpfen für Strapsgürtel in großen Größen. Schneller Versand.

keywords

string

title

string

Katzenstrümpfe in Übergröße - Spezialist für Strümpfe in Übergröße

seotitle

string

Katzenstrumpf groß

seouri

string

katzenstrumpf-gross-schwarz

specifications

string

stylingtips

string

summary

string

Betonen Sie Ihre katzenhafte Seite mit diesen wunderschönen Strümpfen für Strapsgürtel.

title

string

Katzenstrumpf

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Αιλουροειδές διχτυωτό σλιπ με λεοπάρ μοτίβο. Μέχρι τον μηρό με μονόχρωμη ζώνη.

guid

string

https://dev.divasboudoir.com/el/feline-megales-kaltses-mayro/slst7862.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

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

keywords

string

title

string

Feline plus size stockings - Ειδικός σε κάλτσες plus size

seotitle

string

Feline μεγάλες κάλτσες

seouri

string

feline-megales-kaltses-mayro

specifications

string

stylingtips

string

summary

string

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

title

string

Κάλτσες αιλουροειδών

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Feline fishnet bottom with leopard print. Thigh-high with plain band.

guid

string

https://dev.divasboudoir.com/en/feline-plus-size-stocking-black/slst7862.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Enhance your legs and show off your feline side with our special garter belt stockings in plus size. Fast delivery.

keywords

string

title

string

Feline plus size hosiery - Plus size hosiery specialist

seotitle

string

Feline plus size stocking

seouri

string

feline-plus-size-stocking-black

specifications

string

stylingtips

string

summary

string

Show off your feline side with these pretty garter belt stockings.

title

string

Feline stockings

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Parte inferior de rejilla felina con estampado de leopardo. Hasta el muslo con banda lisa.

guid

string

https://dev.divasboudoir.com/es/medias-felinas-de-talla-grande-negro/slst7862.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Realza tus piernas y muestra tu lado felino con nuestras medias con liguero especiales en talla grande. Entrega rápida.

keywords

string

title

string

Medias felinas de talla grande - Especialista en medias de talla grande

seotitle

string

Medias felinas de talla grande

seouri

string

medias-felinas-de-talla-grande-negro

specifications

string

stylingtips

string

summary

string

Muestra tu lado felino con estas bonitas medias con liguero.

title

string

Medias felinas

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Bas féline en résille avec motif léopard. Haut de cuisse avec une bande unie.

guid

string

https://dev.divasboudoir.com/fr/bas-grande-taille-feline-noir/slst7862.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Sublimez vos jambes et mettez votre coté féline à l'honneur avec nos bas spécial porte-jarretelles en grande taille. Envoi rapide.

keywords

string

title

string

Bas grande taille féline - Spécialiste du bas grande taille

seotitle

string

Bas grande taille féline

seouri

string

bas-grande-taille-feline-noir

specifications

string

stylingtips

string

summary

string

Mettez en avant votre coté féline avec ces très jolis bas pour porte-jarretelles.

title

string

Bas féline

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Fondo a rete felina con stampa leopardata. Altezza coscia con fascia liscia.

guid

string

https://dev.divasboudoir.com/it/calze-feline-di-taglia-grande-nero/slst7862.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Valorizzate le vostre gambe e mostrate il vostro lato felino con le nostre speciali calze con reggicalze in taglia grande. Consegna rapida.

keywords

string

title

string

Calze feline plus size - Specialista in calze plus size

seotitle

string

Calze feline di taglia grande

seouri

string

calze-feline-di-taglia-grande-nero

specifications

string

stylingtips

string

summary

string

Sfoggiate il vostro lato felino con queste graziose calze con reggicalze.

title

string

Calze feline

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Feline visnet broekje met luipaardprint. Dijhoog met effen band.

guid

string

https://dev.divasboudoir.com/nl/katachtige-grote-maten-kousen-zwart/slst7862.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Verfraai je benen en laat je van je katachtige kant zien met onze speciale jarretelgordelkousen in grote maten. Snelle levering.

keywords

string

title

string

Feline grote maten kousen - Specialist in grote maten kousen

seotitle

string

Katachtige grote maten kousen

seouri

string

katachtige-grote-maten-kousen-zwart

specifications

string

stylingtips

string

summary

string

Laat je van je katachtige kant zien met deze mooie jarretel kousen.

title

string

Katachtige kousen

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Parte inferior em rede felina com estampado de leopardo. Até à altura da coxa com faixa lisa.

guid

string

https://dev.divasboudoir.com/pt/meias-grandes-para-felinos-preto/slst7862.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Realce as suas pernas e mostre o seu lado felino com as nossas meias especiais com cinto de ligas em tamanhos grandes. Entrega rápida.

keywords

string

title

string

Meias plus size Feline - Especialista em meias plus size

seotitle

string

Meias grandes para felinos

seouri

string

meias-grandes-para-felinos-preto

specifications

string

stylingtips

string

summary

string

Mostre o seu lado felino com estas bonitas meias com cinto de ligas.

title

string

Meias para felinos

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

-schwarz

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-mayro

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-black

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-negro

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-noir

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-nero

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-zwart

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-preto

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

latexboudoir

Struct

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-schwarz

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-mayro

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-black

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-negro

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-noir

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-nero

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-zwart

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-preto

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

legsboudoir

Struct

Struct
Entries: 14

abstract

string

careinstructions

string

Handwäsche empfohlen. Kaltes Wasser. Nicht im Trockner. Vorsichtige Behandlung des Netzes.

description

string

Strümpfe, die Ihre wilde Seite entfesseln. Das Leopardenmuster auf dem Netz schafft einen feline und kühnen Look. Der breite glatte Bund am Oberschenkel sorgt für bequeme Unterstützung und ermöglicht eine einfache Befestigung des Strumpfhalters. Das elegante Netz betont Ihre Beine, während das Leopardenmuster eine wilde und raffinierte Note hinzufügt. Ein Accessoire, das Ihre Persönlichkeit mit Stil und Selbstvertrauen unterstreicht. Perfekt für diejenigen, die sich trauen, hervorzustechen.

highlights

string

<ul> <li>Leopardenmuster wild</li> <li>Elegantes Netz</li> <li>Breiter glatter Bund am Oberschenkel</li> <li>Kompatibel mit Strumpfhaltern</li> <li>Wilder und sophistischer Stil</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Übergröße Netzstrümpfe mit Leopardenmuster. Breiter Bund, wilder Stil. Legs Boudoir: Kühnheit und Raffinesse garantiert.

keywords

string

title

string

Leoparden Netzstrümpfe - Wild | Legs Boudoir

seotitle

string

Übergröße Leoparden Netzstrümpfe

seouri

string

uebergroesse-leoparden-netzstruempfe

specifications

string

<ul> <li>Farbe : Leopardenmuster</li> <li>Typ : Netz mit Muster</li> <li>Zusammensetzung : 90% Nylon, 10% Elastan</li> <li>Oberer Abschluss : Breiter glatter Bund</li> <li>Kompatibel mit : Strumpfhaltern</li> <li>Hinweis : String nicht enthalten</li> <li>Verfügbarkeit : Standard- und Übergröße</li> </ul>

stylingtips

string

Perfekt für : <ul> <li>Gewagte Abendveranstaltungen</li> <li>Wilde feminine Looks</li> <li>Bühnenoutfits</li> <li>Rockig-schicker Stil</li> </ul> Vervollständigen Sie Ihren Look : <ul> <li><a href="https://www.legsboudoir.com/de/sexy-dessous/">Entdecken Sie unsere passenden Strapsgürtel</a></li> </ul>

summary

string

Strümpfe, die mit Stil brüllen. Netz mit Leopardenmuster für einen wilden und mutigen Look.

title

string

Leoparden Netzstrümpfe - Wild und Kühn

usageinstructions

string

Diese Strümpfe werden mit Strumpfhaltern getragen. Der breite Bund am Oberschenkel erleichtert die Befestigung und gewährleistet bequeme Unterstützung. Das Netz passt sich natürlich Ihren Beinen an.

Struct
Entries: 14

abstract

string

careinstructions

string

Συνιστάται πλύσιμο στο χέρι. Κρύο νερό. Όχι στεγνωτήριο. Προσεκτικό&sigmaf; χειρισμό&sigmaf; του διχτυού.

description

string

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

highlights

string

<ul> <li>Σχέδιο λεοπάρ άγριο</li> <li>Κομψό δίχτυ</li> <li>Φαρδιά λεία ζώνη στο πάνω μέρο&sigmaf; του μηρού</li> <li>Συμβατό με ζαρτιέρε&sigmaf;</li> <li>Άγριο και εκλεπτυσμένο στιλ</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Καλσόν μεγάλου μεγέθους με σχέδιο λεοπάρ. Φαρδιά ζώνη, άγριο στιλ. Legs Boudoir: τόλμη και εκλέπτυνση εγγυημένα.

keywords

string

title

string

Καλσόν Λεοπάρ - Άγριο | Legs Boudoir

seotitle

string

Καλσόν Μεγάλου Μεγέθους Λεοπάρ

seouri

string

kalson-megalou-megethous-leopar

specifications

string

<ul> <li>Χρώμα : Σχέδιο λεοπάρ</li> <li>Τύπο&sigmaf; : Δίχτυ με σχέδιο</li> <li>Σύνθεση : 90% Νάιλον, 10% Σπαντέξ</li> <li>Πάνω μέρο&sigmaf; : Φαρδιά λεία ζώνη</li> <li>Συμβατό με : Ζαρτιέρε&sigmaf;</li> <li>Σημείωση : Στρινγκ δεν περιλαμβάνεται</li> <li>Διαθεσιμότητα : Κανονικό και μεγάλο μέγεθο&sigmaf;</li> </ul>

stylingtips

string

Ιδανικό για: <ul> <li>Τολμηρά πάρτι</li> <li>Άγριες θηλυκές εμφανίσεις</li> <li>Σκηνικά ρούχα</li> <li>Ροκ σικ</li> </ul> Ολοκληρώστε την εμφάνισή σας: <ul> <li><a href="https://www.legsboudoir.com/el/σέξι-εσώρουχα/">Ανακαλύψτε τις ασορτί ζαρτιέρες μας</a></li> </ul>

summary

string

Καλσόν που βρυχάται με στιλ. Δίχτυ με σχέδιο λεοπάρ για ένα άγριο και τολμηρό look.

title

string

Καλσόν Δίχτυ Λεοπάρ - Άγριο και Τολμηρό

usageinstructions

string

Αυτό το καλσόν φοριέται με ζαρτιέρε&sigmaf;. Η φαρδιά ζώνη στο πάνω μέρο&sigmaf; του μηρού διευκολύνει την προσαρμογή και εξασφαλίζει άνετη στήριξη. Το δίχτυ προσαρμόζεται φυσικά στα πόδια σα&sigmaf;.

Struct
Entries: 14

abstract

string

careinstructions

string

Hand wash recommended. Cold water. No tumble dry. Delicate mesh handling.

description

string

Stockings that unleash your wild side. The leopard print on mesh creates a feline and bold look. The wide solid band at the top of the thigh ensures comfortable support and easily attaches to your garter belt or suspenders. The elegant mesh highlights your legs while the leopard print adds a wild and sophisticated touch. An accessory that affirms your personality with style and confidence. Perfect for those who dare to stand out.

highlights

string

<ul> <li>Leopard print wild</li> <li>Elegant mesh</li> <li>Wide solid band on thigh top</li> <li>Compatible with garter belts</li> <li>Wild and sophisticated style</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Plus size leopard print mesh stockings. Wide band, wild style. Legs Boudoir: bold sophistication guaranteed.

keywords

string

title

string

Leopard Mesh Stockings - Wild | Legs Boudoir

seotitle

string

Plus Size Leopard Print Mesh Stockings

seouri

string

plus-size-leopard-print-mesh-stockings

specifications

string

<ul> <li>Color : Leopard print</li> <li>Type : Mesh with print</li> <li>Composition : 90% Nylon, 10% Elastane</li> <li>Top : Wide solid band</li> <li>Compatible with : Garter belts and suspenders</li> <li>Note : Thong not included</li> <li>Availability : Standard and plus size</li> </ul>

stylingtips

string

Perfect for : <ul> <li>Bold evenings</li> <li>Wild feminine looks</li> <li>Stage outfits</li> <li>Rock-chic style</li> </ul> Complete your look: <ul> <li><a href="https://www.legsboudoir.com/en/sexy-lingerie/">Discover our matching garter belts</a></li> </ul>

summary

string

Stockings that roar with style. Mesh with leopard print for a wild and daring look.

title

string

Leopard Mesh Stockings - Wild and Bold

usageinstructions

string

These stockings are worn with garter belts or suspenders. The wide band at the top of the thigh facilitates attachment and ensures comfortable support. The mesh naturally adapts to your legs.

Struct
Entries: 14

abstract

string

careinstructions

string

Lavado a mano recomendado. Agua fría. No secar en secadora. Manipulación delicada de la red.

description

string

Medias que liberan tu lado salvaje. El estampado de leopardo sobre la red crea un look felino y audaz. La banda ancha lisa en la parte superior del muslo asegura un soporte cómodo y permite fijar fácilmente tu liguero. La red elegante realza tus piernas mientras el estampado de leopardo añade un toque salvaje y sofisticado. Un accesorio que afirma tu personalidad con estilo y confianza. Perfecto para quienes se atreven a destacar.

highlights

string

<ul> <li>Estampado leopardo salvaje</li> <li>Red elegante</li> <li>Banda ancha lisa en la parte superior del muslo</li> <li>Compatible con ligueros</li> <li>Estilo salvaje y sofisticado</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Medias talla grande con estampado de leopardo. Banda ancha, estilo salvaje. Legs Boudoir: audacia y sofisticación garantizadas.

keywords

string

title

string

Medias Leopardo - Salvaje | Legs Boudoir

seotitle

string

Medias Talla Grande Estampado Leopardo

seouri

string

medias-talla-grande-estampado-leopardo

specifications

string

<ul> <li>Color : Estampado leopardo</li> <li>Tipo : Red con estampado</li> <li>Composición : 90% Nylon, 10% Elastano</li> <li>Parte superior : Banda ancha lisa</li> <li>Compatible con : Ligueros</li> <li>Nota : Tanga no incluida</li> <li>Disponibilidad : Talla estándar y talla grande</li> </ul>

stylingtips

string

Perfecto para : <ul> <li>Fiestas atrevidas</li> <li>Looks salvajes y femeninos</li> <li>Trajes de escena</li> <li>Rock chic</li> </ul> Completa tu look: <ul> <li><a href="https://www.legsboudoir.com/es/lenceria-sexy-mujer/">Descubre nuestros liguero a juego</a></li> </ul>

summary

string

Medias que rugen con estilo. Red con estampado de leopardo para un look salvaje y atrevido.

title

string

Medias de Red Leopardo - Salvaje y Audaz

usageinstructions

string

Estas medias se usan con ligueros. La banda ancha en la parte superior del muslo facilita la sujeción y asegura un soporte cómodo. La red se adapta naturalmente a tus piernas.

Struct
Entries: 14

abstract

string

careinstructions

string

Lavage à la main recommandé. Eau froide. Pas de sèche-linge. Manipulation délicate de la résille.

description

string

Des bas qui libèrent votre côté sauvage. Le motif léopard sur résille crée un look félin et audacieux. La bande unie large au haut de cuisse assure un maintien confortable et permet d'attacher facilement votre porte-jarretelles ou guêpière. La résille élégante met en valeur vos jambes tandis que le motif léopard ajoute une touche sauvage et sophistiquée. Un accessoire qui affirme votre personnalité avec style et confiance. Parfait pour celles qui osent sortir des sentiers battus.

highlights

string

<ul> <li>Motif léopard félin</li> <li>Résille élégante</li> <li>Bande unie large au haut de cuisse</li> <li>Compatible jarretelles</li> <li>Style sauvage et sophistiqué</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Bas grande taille en résille motif léopard. Bande large, style félin. Legs Boudoir : audace et sophistication garanties.

keywords

string

title

string

Bas Résille Léopard - Félin | Legs Boudoir

seotitle

string

Bas Grande Taille Résille Motif Léopard

seouri

string

bas-grande-taille-resille-motif-leopard

specifications

string

<ul> <li>Couleur : Motif léopard</li> <li>Type : Résille avec motif</li> <li>Composition : 90% Nylon, 10% Élasthanne</li> <li>Haut : Bande unie large</li> <li>Compatible : Porte-jarretelles et guêpière</li> <li>Note : String non inclus</li> <li>Disponibilité : Taille standard et grande taille</li> </ul>

stylingtips

string

Parfaits pour : <ul> <li>Soirées audacieuses</li> <li>Looks féminins sauvages</li> <li>Tenues de scène</li> <li>Style rock-chic</li> </ul> Complétez votre look : <ul> <li><a href="https://www.legsboudoir.com/fr/lingerie-sexy/">Découvrez nos porte-jarretelles assortis</a></li> </ul>

summary

string

Des bas qui rugissent de style. Résille avec motif léopard félin pour un look sauvage et audacieux.

title

string

Bas Résille Léopard - Félin et Audacieux

usageinstructions

string

Ces bas se portent avec un porte-jarretelles ou une guêpière. La bande large au haut de cuisse facilite l'attache et assure un maintien confortable. La résille s'adapte naturellement à vos jambes.

Struct
Entries: 14

abstract

string

careinstructions

string

Lavaggio a mano consigliato. Acqua fredda. Non asciugare in asciugatrice. Manipolazione delicata della rete.

description

string

Calze che liberano il tuo lato selvaggio. La stampa leopardata sulla rete crea un look felino e audace. La fascia larga liscia sulla parte superiore della coscia assicura un supporto confortevole e permette di fissare facilmente il reggicalze. La rete elegante valorizza le vostre gambe mentre la stampa leopardata aggiunge un tocco selvaggio e sofisticato. Un accessorio che afferma la vostra personalità con stile e sicurezza. Perfetto per chi osa distinguersi.

highlights

string

<ul> <li>Stampa leopardata selvaggia</li> <li>Rete elegante</li> <li>Fascia larga liscia sulla parte superiore della coscia</li> <li>Compatibile con reggicalze</li> <li>Stile selvaggio e sofisticato</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Calze taglie forti con stampa leopardata. Fascia larga, stile selvaggio. Legs Boudoir: audacia e sofisticazione garantite.

keywords

string

title

string

Calze Leopardate - Selvagge | Legs Boudoir

seotitle

string

Calze Taglie Forti Stampa Leopardata

seouri

string

calze-taglie-forti-stampa-leopardata

specifications

string

<ul> <li>Colore : Stampa leopardata</li> <li>Tipo : Rete con stampa</li> <li>Composizione : 90% Nylon, 10% Elastan</li> <li>Parte superiore : Fascia larga liscia</li> <li>Compatibile con : Reggicalze</li> <li>Nota : Perizoma non incluso</li> <li>Disponibilità : Taglia standard e taglie forti</li> </ul>

stylingtips

string

Perfetto per : <ul> <li>Feste audaci</li> <li>Look femminili e selvaggi</li> <li>Abiti da palcoscenico</li> <li>Rock chic</li> </ul> Completa il tuo look: <ul> <li><a href="https://www.legsboudoir.com/it/lingerie-sexy/">Scoprite i nostri reggicalze coordinati</a></li> </ul>

summary

string

Calze che ruggono con stile. Rete con stampa leopardata per un look selvaggio e audace.

title

string

Calze Rete Leopardate - Selvagge e Audaci

usageinstructions

string

Queste calze si indossano con i reggicalze. La fascia larga sulla parte superiore della coscia facilita il fissaggio e assicura un supporto confortevole. La rete si adatta naturalmente alle vostre gambe.

Struct
Entries: 14

abstract

string

careinstructions

string

Handwas aanbevolen. Koud water. Niet in de droger. Voorzichtige behandeling van het net.

description

string

Panty's die je wilde kant bevrijden. Het luipaard motief op het net creëert een wilde en gedurfde look. De brede effen band bovenaan de dij zorgt voor comfortabele steun en maakt het gemakkelijk om jarretels of een jarretelgordel te bevestigen. Het elegante net benadrukt je benen terwijl het luipaard motief een wilde en verfijnde toets toevoegt. Een accessoire dat je persoonlijkheid met stijl en zelfvertrouwen bevestigt. Perfect voor wie durft af te wijken van het gewone.

highlights

string

<ul> <li>Luipaard motief wild</li> <li>Elegant net</li> <li>Brede effen band bovenaan dij</li> <li>Geschikt voor jarretels</li> <li>Wilde en verfijnde stijl</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Grote maat netpanty met luipaard motief. Brede band, wilde stijl. Legs Boudoir: gedurfde verfijning gegarandeerd.

keywords

string

title

string

Luipaard Netpanty - Wild | Legs Boudoir

seotitle

string

Grote Maat Netpanty met Luipaard Motief

seouri

string

grote-maat-netpanty-luipaard-motief

specifications

string

<ul> <li>Kleur : Luipaard motief</li> <li>Type : Net met motief</li> <li>Samenstelling : 90% Nylon, 10% Elastaan</li> <li>Bovenkant : Brede effen band</li> <li>Geschikt voor : Jarretels en jarretelgordel</li> <li>Opmerking : String niet inbegrepen</li> <li>Beschikbaarheid : Standaard en grote maat</li> </ul>

stylingtips

string

Perfect voor : <ul> <li>Gedurfde feestjes</li> <li>Wilde vrouwelijke looks</li> <li>Podium outfits</li> <li>Rock chic</li> </ul> Maak je look compleet: <ul> <li><a href="https://www.legsboudoir.com/nl/sexy-lingerie/">Ontdek onze bijpassende jarretelgordels</a></li> </ul>

summary

string

Panty's die brullen van stijl. Net met luipaard motief voor een wilde en gedurfde look.

title

string

Luipaard Netpanty - Wild en Gedurfd

usageinstructions

string

Deze panty's worden gedragen met jarretels of een jarretelgordel. De brede band bovenaan de dij vergemakkelijkt de bevestiging en zorgt voor comfortabele steun. Het net past zich natuurlijk aan aan je benen.

Struct
Entries: 14

abstract

string

careinstructions

string

Lavagem à mão recomendada. Água fria. Não usar secadora. Manipulação delicada da rede.

description

string

Meia-calça que libera seu lado selvagem. A estampa de leopardo sobre a rede cria um look felino e ousado. A faixa larga lisa na parte superior da coxa garante suporte confortável e permite fixar facilmente sua liga-liga. A rede elegante realça suas pernas enquanto a estampa de leopardo adiciona um toque selvagem e sofisticado. Um acessório que afirma sua personalidade com estilo e confiança. Perfeito para quem ousa se destacar.

highlights

string

<ul> <li>Estampa de leopardo selvagem</li> <li>Rede elegante</li> <li>Faixa larga lisa na parte superior da coxa</li> <li>Compatível com liga-liga</li> <li>Estilo selvagem e sofisticado</li> </ul>

keypoint

string

keywords

string

metas

Struct

description

string

Meia-calça plus size com estampa de leopardo. Faixa larga, estilo selvagem. Legs Boudoir: ousadia e sofisticação garantidas.

keywords

string

title

string

Meia-Calça Leopardo - Selvagem | Legs Boudoir

seotitle

string

Meia-Calça Plus Size Estampa Leopardo

seouri

string

meia-calca-plus-size-estampa-leopardo

specifications

string

<ul> <li>Cor : Estampa de leopardo</li> <li>Tipo : Rede com estampa</li> <li>Composição : 90% Nylon, 10% Elastano</li> <li>Parte superior : Faixa larga lisa</li> <li>Compatível com : Liga-liga</li> <li>Nota : Tanga não incluída</li> <li>Disponibilidade : Tamanho padrão e plus size</li> </ul>

stylingtips

string

Ideal para : <ul> <li>Festas ousadas</li> <li>Looks femininos selvagens</li> <li>Roupas de palco</li> <li>Rock chic</li> </ul> Complete o seu look: <ul> <li><a href="https://www.legsboudoir.com/pt/lingerie-sexy/">Descubra os nossos cintos de ligas a condizer</a></li> </ul>

summary

string

Meia-calça que ruge com estilo. Rede com estampa de leopardo para um look selvagem e ousado.

title

string

Meia-Calça Rede Leopardo - Selvagem e Ousada

usageinstructions

string

Estas meias-calças são usadas com liga-liga. A faixa larga na parte superior da coxa facilita a fixação e garante suporte confortável. A rede se adapta naturalmente às suas pernas.

lustboudoir

Struct

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-schwarz

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-mayro

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-black

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-negro

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-noir

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-nero

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-zwart

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-preto

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

smboudoir

Struct

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-schwarz

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-mayro

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-black

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-negro

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-noir

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-nero

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-zwart

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

-preto

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

name

string

Bas grande taille noir en résille avec motif léopard. - DG0347XBLK

netweight

string

nextshipment

string

tomorrow

ordered

number

orderidx

number

origin

string

originalsize

string

packaging

number

productshipment

string

2to3days

productuid

string

F5AAF312-7C7B-42FA-81E5CF7FF4B4EE0C

promountil

string

rating

string

none

recorduid

string

F5AAF312-7C7B-42FA-81E5CF7FF4B4EE0C

reference

string

SLST7862

string

reserved

number

returned

number

returnsallowed

number

section

string

lingerie

shipment

string

2to3days

showbrand

number

sizeinfos

Query Template: /system/api/product/sizes.cfc:20 Execution Time: 1.31 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 = 'F5AAF312-7C7B-42FA-81E5CF7FF4B4EE0C' 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	black	2	4	0	0	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	black	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

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.66 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 = 'F5AAF312-7C7B-42FA-81E5CF7FF4B4EE0C' 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 = 'F5AAF312-7C7B-42FA-81E5CF7FF4B4EE0C' 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	F5AAF312-7C7B-42FA-81E5CF7FF4B4EE0C	58DD12ED-6EB9-420F-955F4BFAD1B992EF	1816	black	#000000	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	0	0	0	0	0			0	0	all
2	F5AAF312-7C7B-42FA-81E5CF7FF4B4EE0C	CBF46C66-F260-4EDA-B484A9822742C598	1112	black	#000000	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	5	0	0	0347X	888368295418	1	1	all

subcategory

string

stocking

supplier

number

-1

supplierreference

string

DG0347XBLKOSQ

Katzenstrumpf groß

Produktbeschreibung

Technische Details

Verfügbare Größen

Verfügbare Farbe

INFORMATIONEN

MITGLIEDERBEREICH

DIENSTE

KONTAKTIEREN SIE UNS

Katzenstrumpf groß

Produktbeschreibung

Technische Details

Verfügbare Größen

Verfügbare Farbe

Newsletter

Meine Einstellungen ändern

Meine Einstellungen speichern