See sizes

Double-click to enlarge

SKU: LBBD8076

Dark Heart handcuffs

Stock:

Ready for a terribly exciting bondage session with her black leatherette handcuffs.

Color:

Quantity:

19.95 €

Help and advice

by chat, facebook or e-mail

Free returns

within 15 days *

Dark Heart handcuffs

Description
Specifications

Product description

Dark Heart handcuffs are made of black imitation leather with bright red stitching and detailing.

They have a practical buckle closure and a 15cm carabiner chain that you can easily detach.

Materials:
Polyurethane, metal

Wrist circumference adjustable from 17 to 27 cm.

Technical details

Available color

Black

To Top

Your location is:
United States of America

Your language is: English

Prices are in: EUR (€)

Save my preferences

Continue

Change my settings

Country Language

Save my preferences

Cancel

Struct
Entries: 108

actions

Array

available

number

-1

brand

string

badkitty

brandcode

string

bdxa

branding

string

divasboudoir,smboudoir

brandmedias

string

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

brandmetas

Struct

de

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

el

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

en

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

es

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

fr

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

it

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

nl

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

pt

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

Bad Kitty

breasts

string

na

careinstructions

string

category

string

secret

categorygender

string

m

categorymediadatas

Struct

adult

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

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

id

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

id

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

id

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

id

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

id

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

id

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

id

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

id

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

id

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

id

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

id

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

id

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

id

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

id

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

id

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

0

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

id

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

id

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

id

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.984 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 = '1466A058-2B2F-4339-834E5323C48FF3C9' group by product_colors.range,product_colors.color order by product_colors.range,product_colors.color
	recorduid	type	code	color	range	hexvalue	available	stock
1	black	color	blak	black	black	#000000	-1	0

colorrange

string

black

colors

string

black

colortype

string

color

comments

string

compositions

Struct
Entries: 13

coton

string

elastane

string

free

string

leather

string

lycra

string

metal

string

nylon

string

polyamide

string

polyester

string

polyurethane

string

silk

string

spandex

string

viscose

string

datecreated

Date Time (Europe/Paris)

{ts '2020-09-09 09:22:12'}

defect

number

0

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

cm

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

0

hasshortdescription

boolean

true

hassizeinfos

boolean

false

hasspecifications

boolean

false

hasstockinfos

boolean

false

hasstylingtips

boolean

false

hasusageinstructions

boolean

false

hasvariations

boolean

true

import

string

inpromo

number

0

instockvariations

number

0

isactive

number

1

iscustommade

number

0

isdivasize

number

0

isfirstprice

number

0

isfixedprice

number

0

ishot

number

0

isnew

number

0

isonline

number

0

isoutletprice

number

0

itemprice

number

16.625

itempromo

string

key

string

handfesseln-24920241001

language

string

all

lastupdated

Date Time (Europe/Paris)

{ts '2023-08-31 10:06:30'}

linkedactions

Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 1.16 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','en')
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('1466a058-2b2f-4339-834e5323c48ff3c9',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.86 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','en')
and product_categories.language in ('all','en')
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 <> 'LBBD8076'
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

670

isprivate

string

0

rating

string

all

src

string

/photobank/products/bdxa/lbbd8076/24920241001_nor_a.jpg

type

string

img

width

string

1000

back

Struct

height

string

828

isprivate

string

0

rating

string

all

src

string

/photobank/products/bdxa/lbbd8076/24920241001_nor_b.jpg

type

string

img

width

string

1000

default

Struct

height

string

1000

isprivate

string

0

rating

string

all

src

string

/photobank/products/bdxa/lbbd8076/24920241001_nor_d.jpg

type

string

img

width

string

776

variations

Struct

colors

Struct

black

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

video

Struct

embedsrc

string

height

string

id

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

products.bdxa.lbbd8076,products.bdxa.lbbd8076,products.bdxa.lbbd8076

metadatas

Struct

darkboudoir

Struct

de

Struct
Entries: 13

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

el

Struct
Entries: 13

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

en

Struct
Entries: 13

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

es

Struct
Entries: 13

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

fr

Struct
Entries: 13

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

it

Struct
Entries: 13

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

nl

Struct
Entries: 13

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

pt

Struct
Entries: 13

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

divasboudoir

Struct

de

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Die Dark Heart Handschellen bestehen aus schwarzem Kunstleder mit leuchtend roten Nähten und Details. Sie haben einen praktischen Schnallenverschluss und eine 15 cm lange Kette mit Karabinerhaken, die Sie leicht abnehmen können. Die Materialien: Polyurethan, Metall Handgelenkumfang verstellbar von 17 bis 27 cm.

guid

string

https://dev.divasboudoir.com/de/handschellen-dark-heart-schwarz/lbbd8076.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Bereit für eine furchtbar aufregende Bondage-Sitzung mit ihren schwarzen Kunstlederhandschellen.

keywords

string

title

string

Handschellen Dark Heart

seotitle

string

Handschellen Dark Heart

seouri

string

specifications

string

stylingtips

string

summary

string

Bereit für eine furchtbar aufregende Bondage-Sitzung mit ihren schwarzen Kunstlederhandschellen.

title

string

Handschellen Dark Heart

usageinstructions

string

el

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Οι χειροπέδες Dark Heart είναι κατασκευασμένες από μαύρο απομιμητικό δέρμα με έντονες κόκκινες ραφές και λεπτομέρειες. Διαθέτουν μια πρακτική αγκράφα και μια αλυσίδα 15 εκατοστών με αγκίστρι που μπορείτε εύκολα να αποσυνδέσετε. Υλικά: Πολυουρεθάνη, μέταλλο Μέγεθος καρπού ρυθμιζόμενο από 17 έως 27 cm.

guid

string

https://dev.divasboudoir.com/el/cheiropedes-dark-heart-mayro/lbbd8076.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Έτοιμη για μια τρομερά συναρπαστική συνεδρία δουλείας με τις μαύρες απομιμητικές δερμάτινες χειροπέδες της.

keywords

string

title

string

Χειροπέδες Dark Heart

seotitle

string

Χειροπέδες Dark Heart

seouri

string

specifications

string

stylingtips

string

summary

string

Έτοιμη για μια τρομερά συναρπαστική συνεδρία δουλείας με τις μαύρες απομιμητικές δερμάτινες χειροπέδες της.

title

string

Χειροπέδες Dark Heart

usageinstructions

string

en

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Dark Heart handcuffs are made of black imitation leather with bright red stitching and detailing. They have a practical buckle closure and a 15cm carabiner chain that you can easily detach. Materials: Polyurethane, metal Wrist circumference adjustable from 17 to 27 cm.

guid

string

https://dev.divasboudoir.com/en/dark-heart-handcuffs-black/lbbd8076.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Ready for a terribly exciting bondage session with her black leatherette handcuffs.

keywords

string

title

string

Dark Heart handcuffs

seotitle

string

Dark Heart handcuffs

seouri

string

specifications

string

stylingtips

string

summary

string

Ready for a terribly exciting bondage session with her black leatherette handcuffs.

title

string

Dark Heart handcuffs

usageinstructions

string

es

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Las esposas Dark Heart están fabricadas en polipiel negra con costuras y detalles en rojo brillante. Tienen un práctico cierre de hebilla y una cadena de 15 cm con mosquetón que puedes quitar fácilmente. Materiales: Poliuretano, metal Tamaño de muñeca ajustable de 17 a 27 cm.

guid

string

https://dev.divasboudoir.com/es/esposas-corazon-oscuro-negro/lbbd8076.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Lista para una sesión de bondage terriblemente excitante con sus esposas negras de imitación de cuero.

keywords

string

title

string

Esposas Corazón Oscuro

seotitle

string

Esposas Corazón Oscuro

seouri

string

specifications

string

stylingtips

string

summary

string

Lista para una sesión de bondage terriblemente excitante con sus esposas negras de imitación de cuero.

title

string

Esposas Corazón Oscuro

usageinstructions

string

fr

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Les menottes Dark Heart son en similicuir noir orné de coutures et de détails rouge vif.  Elles ont une fermeture à boucle pratique et une chaine de 15cm à mousqueton que vous pourrez détacher facilement. Matériaux:  Polyuréthane, métal  Tour de poignet réglable de 17 à 27 cm.

guid

string

https://dev.divasboudoir.com/fr/menottes-dark-heart-noir/lbbd8076.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Prête pour une séance de bondage terriblement excitante avec ses menottes en similicuir noires.

keywords

string

title

string

Menottes Dark Heart

seotitle

string

Menottes Dark Heart

seouri

string

specifications

string

stylingtips

string

summary

string

Prête pour une séance de bondage terriblement excitante avec ses menottes en similicuir noires.

title

string

Menottes Dark Heart

usageinstructions

string

it

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Le manette Dark Heart sono realizzate in similpelle nera con cuciture e dettagli in rosso brillante. Hanno una pratica chiusura a fibbia e una catena di 15 cm con moschettone che si può staccare facilmente. Materiali: Poliuretano, metallo Misura del polso regolabile da 17 a 27 cm.

guid

string

https://dev.divasboudoir.com/it/manette-dark-heart-nero/lbbd8076.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Pronta per una sessione di bondage terribilmente eccitante con le sue manette nere in finta pelle.

keywords

string

title

string

Manette Dark Heart

seotitle

string

Manette Dark Heart

seouri

string

specifications

string

stylingtips

string

summary

string

Pronta per una sessione di bondage terribilmente eccitante con le sue manette nere in finta pelle.

title

string

Manette Dark Heart

usageinstructions

string

nl

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

De Dark Heart handboeien zijn gemaakt van zwart imitatieleer met felrode stiksels en details. Ze hebben een praktische gespsluiting en een 15 cm lange ketting met karabijnhaak die je gemakkelijk kunt losmaken. Materiaal: Polyurethaan, metaal Polsmaat verstelbaar van 17 tot 27 cm.

guid

string

https://dev.divasboudoir.com/nl/handboeien-dark-heart-zwart/lbbd8076.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Klaar voor een vreselijk spannende bondagesessie met haar zwarte imitatieleren handboeien.

keywords

string

title

string

Handboeien Dark Heart

seotitle

string

Handboeien Dark Heart

seouri

string

specifications

string

stylingtips

string

summary

string

Klaar voor een vreselijk spannende bondagesessie met haar zwarte imitatieleren handboeien.

title

string

Handboeien Dark Heart

usageinstructions

string

pt

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

As algemas Dark Heart são feitas de imitação de pele preta com costuras e pormenores em vermelho vivo. Têm um prático fecho de fivela e uma corrente de 15 cm com um gancho de pressão que pode ser facilmente retirado. Materiais: Poliuretano, metal Tamanho do pulso ajustável de 17 a 27 cm.

guid

string

https://dev.divasboudoir.com/pt/algemas-dark-heart-preto/lbbd8076.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Pronta para uma sessão de bondage terrivelmente excitante com as suas algemas pretas de imitação de pele.

keywords

string

title

string

Algemas Dark Heart

seotitle

string

Algemas Dark Heart

seouri

string

specifications

string

stylingtips

string

summary

string

Pronta para uma sessão de bondage terrivelmente excitante com as suas algemas pretas de imitação de pele.

title

string

Algemas Dark Heart

usageinstructions

string

fetishboudoir

Struct

de

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

el

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

en

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

es

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

fr

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

it

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

nl

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

pt

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

latexboudoir

Struct

de

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

el

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

en

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

es

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

fr

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

it

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

nl

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

pt

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

legsboudoir

Struct

de

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

el

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

en

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

es

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

fr

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

it

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

nl

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

pt

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

lustboudoir

Struct

de

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

el

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

en

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

es

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

fr

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

it

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

nl

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

pt

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

smboudoir

Struct

de

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Die Heart-Handschellen sind aus schwarzem Kunstleder mit leuchtend roten Nähten und Details. Sie haben einen praktischen Schnallenverschluss und eine 15 cm lange Kette mit Karabinerhaken, die Sie leicht abnehmen können. Die Materialien: Polyurethan, Metall Handgelenkumfang verstellbar von 17 bis 27 cm.

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Bereit für eine furchtbar aufregende Bondage-Sitzung mit ihren schwarz-roten Kunstlederhandschellen.

keywords

string

title

string

Handschellen Heart

seotitle

string

Handschellen Heart

seouri

string

specifications

string

stylingtips

string

summary

string

Bereit für eine furchtbar aufregende Bondage-Sitzung mit ihren schwarz-roten Kunstlederhandschellen.

title

string

Handschellen Heart

usageinstructions

string

el

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Οι χειροπέδες Heart είναι κατασκευασμένες από μαύρο απομιμητικό δέρμα με έντονες κόκκινες ραφές και λεπτομέρειες. Διαθέτουν μια πρακτική αγκράφα και μια αλυσίδα 15 εκατοστών με αγκίστρι που μπορείτε εύκολα να αποσυνδέσετε. Υλικά: Πολυουρεθάνη, μέταλλο Μέγεθος καρπού ρυθμιζόμενο από 17 έως 27 cm.

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Είναι έτοιμη για μια συναρπαστική συνεδρία δουλείας με τις μαύρες και κόκκινες χειροπέδες από δερματίνη.

keywords

string

title

string

Χειροπέδες καρδιάς

seotitle

string

Χειροπέδες καρδιάς

seouri

string

specifications

string

stylingtips

string

summary

string

Είναι έτοιμη για μια συναρπαστική συνεδρία δουλείας με τις μαύρες και κόκκινες χειροπέδες από δερματίνη.

title

string

Χειροπέδες καρδιάς

usageinstructions

string

en

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Heart handcuffs are made of black imitation leather with bright red stitching and detailing. They have a practical buckle closure and a 15cm chain with snap hook that you can easily detach. Materials: Polyurethane, metal Wrist circumference adjustable from 17 to 27 cm.

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Ready for a terribly exciting bondage session with her black and red leatherette handcuffs.

keywords

string

title

string

Heart handcuffs

seotitle

string

Heart handcuffs

seouri

string

specifications

string

stylingtips

string

summary

string

Ready for a terribly exciting bondage session with her black and red leatherette handcuffs.

title

string

Heart handcuffs

usageinstructions

string

es

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Las esposas Heart están fabricadas en polipiel negra con costuras y detalles en rojo brillante. Tienen un práctico cierre de hebilla y una cadena de 15 cm con mosquetón que puedes quitar fácilmente. Materiales: Poliuretano, metal Tamaño de muñeca ajustable de 17 a 27 cm.

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Está lista para una excitante sesión de bondage con sus esposas de polipiel negra y roja.

keywords

string

title

string

Esposas de corazón

seotitle

string

Esposas de corazón

seouri

string

specifications

string

stylingtips

string

summary

string

Está lista para una excitante sesión de bondage con sus esposas de polipiel negra y roja.

title

string

Esposas de corazón

usageinstructions

string

fr

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Les menottes  Heart son en similicuir noir orné de coutures et de détails rouge vif.  Elles ont une fermeture à boucle pratique et une chaine de 15cm à mousqueton que vous pourrez détacher facilement. Matériaux:  Polyuréthane, métal  Tour de poignet réglable de 17 à 27 cm.

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Prête pour une séance de bondage terriblement excitante avec ses menottes en similicuir noires et rouge.

keywords

string

title

string

Menottes Heart

seotitle

string

Menottes Heart

seouri

string

specifications

string

stylingtips

string

summary

string

Prête pour une séance de bondage terriblement excitante avec ses menottes en similicuir noires et rouge.

title

string

Menottes Heart

usageinstructions

string

it

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Le manette Heart sono realizzate in similpelle nera con cuciture e dettagli in rosso brillante. Hanno una pratica chiusura a fibbia e una catena di 15 cm con moschettone che si può staccare facilmente. Materiali: Poliuretano, metallo Misura del polso regolabile da 17 a 27 cm.

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

È pronta per un'eccitante sessione di bondage con le sue manette in similpelle nera e rossa.

keywords

string

title

string

Manette a cuore

seotitle

string

Manette a cuore

seouri

string

specifications

string

stylingtips

string

summary

string

È pronta per un'eccitante sessione di bondage con le sue manette in similpelle nera e rossa.

title

string

Manette a cuore

usageinstructions

string

nl

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

De Heart handboeien zijn gemaakt van zwart imitatieleer met felrode stiksels en details. Ze hebben een praktische gespsluiting en een 15 cm lange ketting met karabijnhaak die je gemakkelijk kunt losmaken. Materiaal: Polyurethaan, metaal Polsmaat verstelbaar van 17 tot 27 cm.

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Ze is klaar voor een spannende bondagesessie met haar zwarte en rode kunstlederen handboeien.

keywords

string

title

string

Hart handboeien

seotitle

string

Hart handboeien

seouri

string

specifications

string

stylingtips

string

summary

string

Ze is klaar voor een spannende bondagesessie met haar zwarte en rode kunstlederen handboeien.

title

string

Hart handboeien

usageinstructions

string

pt

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

As algemas Heart são fabricadas em imitação de pele preta com costuras e pormenores em vermelho vivo. Têm um prático fecho de fivela e uma corrente de 15 cm com um gancho de pressão que pode ser facilmente retirado. Materiais: Poliuretano, metal Tamanho do pulso ajustável de 17 a 27 cm.

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Ela está pronta para uma excitante sessão de bondage com as suas algemas em pele preta e vermelha.

keywords

string

title

string

Algemas para o coração

seotitle

string

Algemas para o coração

seouri

string

specifications

string

stylingtips

string

summary

string

Ela está pronta para uma excitante sessão de bondage com as suas algemas em pele preta e vermelha.

title

string

Algemas para o coração

usageinstructions

string

name

string

Handfesseln 24920241001

netweight

string

nextshipment

string

today

ordered

number

13

orderidx

number

0

origin

string

originalsize

string

packaging

number

0

productshipment

string

auto

productuid

string

1466A058-2B2F-4339-834E5323C48FF3C9

promountil

string

rating

string

none

recorduid

string

1466A058-2B2F-4339-834E5323C48FF3C9

reference

string

LBBD8076

reserved

number

0

returned

number

0

returnsallowed

number

1

section

string

wellbeing

shipment

string

4to6days

showbrand

number

0

sizeinfos

Query
Template: /system/api/product/sizes.cfc:20
Execution Time: 1.7 ms
Record Count: 0
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,'471') > 0
and product_variations.productuid = '1466A058-2B2F-4339-834E5323C48FF3C9'
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

sizeranges

string

plus

sizes

string

471

sizetype

string

auto

specifications

Struct
Entries: 23

belly

string

bones

string

bra

string

breasts

string

bust

string

closing

string

crochtless

string

cups

string

cut

string

garter

string

halter

string

lacing

string

lining

string

modestypanel

string

panty

string

sheathing

string

sleeves

string

stocking

string

straps

string

stretch

string

suspenders

string

transparency

string

underwires

string

stock

number

0

stocks

Query
Template: /system/api/product/stocks.cfc:25
Execution Time: 2.94 ms
Record Count: 1
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select * from (
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '1466A058-2B2F-4339-834E5323C48FF3C9'
and product_variations.isactive = 1
and product_sizes.id_size = 471
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

1466A058-2B2F-4339-834E5323C48FF3C9

6009915E-F515-453F-823488DDC3AC973C

471

black

#000000

na

default

na

intlsize

16.625

0

STOCK01

0

-1

0

13

0

24920241001

4024144324712

-1

0

all

subcategory

string

attach

supplier

number

-1

supplierreference

string

24920241001

Dark Heart handcuffs

Product description

Technical details

Available color

INFORMATION

MEMBER AREA

SERVICES

CONTACT US

Dark Heart handcuffs

Product description

Technical details

Available color

Newsletter

Change my settings

Save my preferences