Maten bekijken

Dubbelklikken om te vergroten

SKU: AFBM0001

Zwart kunstlederen masker

Voorraad:

Verken de opwindende wereld van bdsm met elegantie en verfijning dankzij ons zwarte veganistisch lederen verduisteringsmasker.

Kleur:

Hoeveelheid:

12.95 €

Goed advies

via chat, facebook of e-mail

Gratis retourneren

binnen 15 dagen *

Zwart kunstlederen masker

Beschrijving
Specificaties

Productomschrijving

Ontdek het zwarte masker van veganistisch leer, een onmisbaar accessoire voor je spelletjes van onderwerping en dominantie. Volledig verduisterend.

Gemaakt van eersteklas veganistisch leer, behoudt dit masker niet alleen de esthetiek van traditioneel leer, maar respecteert het ook het leven van dieren en het milieu.

Het ergonomische ontwerp is ontworpen met jouw comfort in gedachten. Het past zich zachtjes aan de rondingen van je gezicht aan, blokkeert het licht effectief en biedt een zacht, omhullend gevoel.

Dankzij de verstelbare elastische band past hij zich aan verschillende hoofdmaten aan zonder ongemak of overmatige druk. Een zachte aanraking die je omhult in een cocon van sensueel plezier en mysterie.

Of je nu een bdsm-expert bent of gewoon je avonden wat pittiger wilt maken, dit bondage masker is het accessoire dat je nodig hebt om een vleugje opwinding en intrige toe te voegen aan je intieme momenten.

Technische details

Beschikbaar kleur

Zwart

Overige technische specificaties

Materiaal	Synthetisch leer

To Top

Uw locatie is:
Verenigde Staten van Amerika

Je taal is: Nederlands

Prijzen zijn in: EUR (€)

Mijn voorkeuren opslaan

Verder

Mijn instellingen wijzigen

Land Taal

Mijn voorkeuren opslaan

Annuleren

Struct
Entries: 108

actions

Array

available

number

-1

brand

string

dreamlove

brandcode

string

dhyr

branding

string

divasboudoir,smboudoir

brandmedias

string

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

brandmetas

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

Struct

currentseouri

string

description

string

metas

Struct

description

string

keywords

string

title

string

name

string

seotitle

string

seouri

string

subtitle

string

summary

string

brandname

string

Dreamlove

breasts

string

careinstructions

string

category

string

secret

categorygender

string

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

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.986 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 = 'DE5A6EC7-64EF-424B-AB03A1A52DFDC62C' 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 '2023-09-19 11:45:17'}

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

true

hasotherspecifications

boolean

false

haspromo

number

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

instockvariations

number

isactive

number

iscustommade

number

isdivasize

number

isfirstprice

number

isfixedprice

number

ishot

number

isnew

number

isonline

number

isoutletprice

number

itemprice

number

10.7917

itempromo

string

key

string

d-236012

language

string

all

lastupdated

Date Time (Europe/Paris)

{ts '2024-05-13 16:15:45'}

linkedactions

Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.965 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','nl')
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('de5a6ec7-64ef-424b-ab03a1a52dfdc62c',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.74 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','nl')
and product_categories.language in ('all','nl')
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 <> 'AFBM0001'
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

fauxleather

mediadatas

Struct

alt

Struct

height

string

800

isprivate

string

rating

string

all

src

string

/photobank/products/dhyr/afbm0001/img_151529_fcd88a9c937879cbaa8075d1b36e2760_1.png

type

string

img

width

string

800

back

Struct

height

string

800

isprivate

string

rating

string

all

src

string

/photobank/products/dhyr/afbm0001/img_151511_b3ff4deee6d407c9989805d34ef09c54_1.png

type

string

img

width

string

800

default

Struct

height

string

800

isprivate

string

rating

string

all

src

string

/photobank/products/dhyr/afbm0001/img_151510_5e7ab960f157e148778bd844ff4216a2_1.png

type

string

img

width

string

800

variations

Struct

colors

Struct

black

Struct

height

string

800

isprivate

string

rating

string

all

src

string

/photobank/products/dhyr/afbm0001/img_151529_fcd88a9c937879cbaa8075d1b36e2760_1.png

type

string

img

width

string

800

video

Struct

embedsrc

string

height

string

isprivate

string

rating

string

src

string

thumb

Struct

default

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

high

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

maxres

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

medium

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

standard

Struct

height

string

isprivate

string

rating

string

src

string

type

string

width

string

type

string

width

string

mediagallery

string

metadatas

Struct

darkboudoir

Struct

Struct
Entries: 13

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 13

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 13

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 13

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 13

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 13

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 13

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 13

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

divasboudoir

Struct

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Entdecken Sie die schwarze vegane Ledermaske, ein unverzichtbares Accessoire für Ihre Unterwerfungs- und Dominanzspiele. Sie ist vollständig verdeckend. Hergestellt aus veganem Premium-Leder, bewahrt diese Maske nicht nur die Ästhetik traditionellen Leders, sondern respektiert auch das Leben der Tiere und die Umwelt. Ihr ergonomisches Design wurde für Ihren Komfort entwickelt. Sie passt sich sanft an die Wölbung Ihres Gesichts an, blockt das Licht effektiv ab und fühlt sich gleichzeitig weich und umhüllend an. Mit seinem verstellbaren Gummiband passt er sich einer Vielzahl von Kopfgrößen an, ohne Unbehagen oder unnötigen Druck zu verursachen. Ein weiches Gefühl, das Sie in einen Kokon aus sinnlichem Vergnügen und Geheimnis einhüllt. Ob Sie nun ein Bdsm-Experte sind oder einfach nur Ihre Partys aufpeppen möchten, diese Bondage-Maske ist das richtige Accessoire, um Ihren intimen Momenten einen Hauch von Aufregung und Intrige zu verleihen.

guid

string

https://dev.divasboudoir.com/de/schwarze-kunstledermaske-schwarz/afbm0001.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Erkunden Sie die aufregende Welt des bdsm mit Eleganz und Raffinesse mit unserer schwarzen Verdunkelungsmaske aus veganem Leder.

keywords

string

title

string

Schwarze Kunstledermaske

seotitle

string

Schwarze Kunstledermaske

seouri

string

specifications

string

stylingtips

string

summary

string

Erkunden Sie die aufregende Welt des bdsm mit Eleganz und Raffinesse mit unserer schwarzen Verdunkelungsmaske aus veganem Leder.

title

string

Schwarze Kunstledermaske

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Ανακαλύψτε τη μαύρη μάσκα από vegan δέρμα, ένα απαραίτητο αξεσουάρ για τα παιχνίδια υποταγή&sigmaf; και κυριαρχία&sigmaf; σα&sigmaf;. Πλήρη&sigmaf; συσκότιση. Κατασκευασμένη από κορυφαίο vegan δέρμα, αυτή η μάσκα όχι μόνο διατηρεί την αισθητική του παραδοσιακού δέρματο&sigmaf;, αλλά και σέβεται τη ζωή των ζώων και το περιβάλλον. Ο εργονομικό&sigmaf; τη&sigmaf; σχεδιασμό&sigmaf; έχει μελετηθεί με γνώμονα την άνεσή σα&sigmaf;. Προσαρμόζεται απαλά στην καμπύλη του προσώπου σα&sigmaf;, αποκλείοντα&sigmaf; αποτελεσματικά το φω&sigmaf;, ενώ παράλληλα προσφέρει μια απαλή, περιβάλλουσα αίσθηση. Χάρη στη ρυθμιζόμενη ελαστική ζώνη του, προσαρμόζεται σε ένα ευρύ φάσμα μεγεθών κεφαλή&sigmaf; χωρί&sigmaf; να προκαλεί δυσφορία ή αδικαιολόγητη πίεση. Ένα απαλό άγγιγμα που θα σα&sigmaf; τυλίξει σε ένα κουκούλι αισθησιακή&sigmaf; απόλαυση&sigmaf; και μυστηρίου. Είτε είστε ειδικό&sigmaf; στο bdsm είτε απλά θέλετε να κάνετε τα βράδια σα&sigmaf; πιο πικάντικα, αυτή η μάσκα bondage είναι το αξεσουάρ που χρειάζεστε για να προσθέσετε μια πινελιά ενθουσιασμού και ίντριγκα&sigmaf; στι&sigmaf; προσωπικέ&sigmaf; σα&sigmaf; στιγμέ&sigmaf;.

guid

string

https://dev.divasboudoir.com/el/mayrh-maska-apo-dermatinh-mayro/afbm0001.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Εξερευνήστε τον συναρπαστικό κόσμο του bdsm με κομψότητα και εκλέπτυνση χάρη στη μαύρη μάσκα blackout από δέρμα vegan.

keywords

string

title

string

Μαύρη μάσκα από δερματίνη

seotitle

string

Μαύρη μάσκα από δερματίνη

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

Μαύρη μάσκα από δερματίνη

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Discover the black vegan leather mask, an essential accessory for your games of submission and domination. Fully blackout. Made from premium vegan leather, this mask not only preserves the aesthetics of traditional leather, but also respects animal life and the environment. Its ergonomic design has been thought out with your comfort in mind. It gently conforms to the curvature of your face, effectively blocking light while offering a soft, enveloping feel. Thanks to its adjustable elastic band, it adapts to a wide range of head sizes without causing discomfort or undue pressure. A soft touch that envelops you in a cocoon of sensual pleasure and mystery. Whether you're a bdsm expert or just want to spice up your evenings, this bondage mask is just the accessory you need to add a touch of excitement and intrigue to your intimate moments.

guid

string

https://dev.divasboudoir.com/en/black-leatherette-mask-black/afbm0001.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Explore the exciting world of bdsm with elegance and sophistication thanks to our black vegan leather blackout mask.

keywords

string

title

string

Black leatherette mask

seotitle

string

Black leatherette mask

seouri

string

specifications

string

stylingtips

string

summary

string

Explore the exciting world of bdsm with elegance and sophistication thanks to our black vegan leather blackout mask.

title

string

Black leatherette mask

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Descubre el antifaz negro de cuero vegano, un accesorio indispensable para tus juegos de sumisión y dominación. Completamente opaca. Fabricada en cuero vegano de primera calidad, esta máscara no sólo conserva la estética del cuero tradicional, sino que también respeta la vida animal y el medio ambiente. Su diseño ergonómico ha sido pensado pensando en tu comodidad. Se adapta suavemente a la curvatura de su cara, bloqueando eficazmente la luz al tiempo que proporciona una sensación suave y envolvente. Gracias a su banda elástica ajustable, se adapta a una amplia gama de tamaños de cabeza sin causar molestias ni presiones indebidas. Un tacto suave que te envolverá en un capullo de sensual placer y misterio. Tanto si eres una experta en bdsm como si sólo quieres darle un toque picante a tus veladas, esta máscara bondage es el accesorio que necesitas para añadir un toque de excitación e intriga a tus momentos íntimos.

guid

string

https://dev.divasboudoir.com/es/mascara-de-polipiel-negra-negro/afbm0001.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Explora el apasionante mundo del bdsm con elegancia y sofisticación gracias a nuestro antifaz de cuero vegano negro.

keywords

string

title

string

Máscara de polipiel negra

seotitle

string

Máscara de polipiel negra

seouri

string

specifications

string

stylingtips

string

summary

string

Explora el apasionante mundo del bdsm con elegancia y sofisticación gracias a nuestro antifaz de cuero vegano negro.

title

string

Máscara de polipiel negra

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Découvrez le masque en cuir végan noir, un accessoire indispensable pour vos jeux de soumission et de domination. Entièrement occultant.  Fabriqué à partir d'un cuir végan premium, ce masque non seulement préserve l'esthétique du cuir traditionnel, mais aussi respecte la vie animale et l'environnement. Sa conception ergonomique a été pensée pour votre confort. Il épouse délicatement la courbure de votre visage, bloquant efficacement la lumière tout en offrant une sensation douce et enveloppante. Grâce à sa bande élastique ajustable, il s'adapte à une large gamme de tailles de tête sans causer d'inconfort ou de pression indue. Un toucher doux qui vous enveloppera dans un cocon de plaisir sensuel et de mystère. Que vous soyez un expert du bdsm ou que vous souhaitiez simplement pimenter vos soirées, ce masque de bondage est l'accessoire qu'il vous faut pour ajouter une touche d'excitation et d'intrigue à vos moments intimes.

guid

string

https://dev.divasboudoir.com/fr/masque-en-similicuir-noir-noir/afbm0001.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Explorez le monde passionnant du bdsm avec élégance et sophistication grâce à notre masque occultant en cuir végan noir.

keywords

string

title

string

Masque en similicuir noir

seotitle

string

Masque en similicuir noir

seouri

string

specifications

string

stylingtips

string

summary

string

Explorez le monde passionnant du bdsm avec élégance et sophistication grâce à notre masque occultant en cuir végan noir.

title

string

Masque en similicuir noir

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Scoprite la maschera in pelle vegana nera, un accessorio indispensabile per i vostri giochi di sottomissione e dominazione. Completamente oscurante. Realizzata in pelle vegana di prima qualità, questa maschera non solo conserva l'estetica della pelle tradizionale, ma rispetta anche gli animali e l'ambiente. Il suo design ergonomico è stato pensato per il vostro comfort. Si adatta delicatamente alle curve del viso, bloccando efficacemente la luce e offrendo una sensazione morbida e avvolgente. Grazie alla sua fascia elastica regolabile, si adatta a un'ampia gamma di dimensioni della testa, senza causare disagi o pressioni eccessive. Un tocco morbido che vi avvolgerà in un bozzolo di piacere sensuale e mistero. Che siate esperte di bdsm o che vogliate semplicemente rendere più piccanti le vostre serate, questa maschera bondage è l'accessorio di cui avete bisogno per aggiungere un tocco di eccitazione e intrigo ai vostri momenti di intimità.

guid

string

https://dev.divasboudoir.com/it/maschera-in-similpelle-nera-nero/afbm0001.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Esplorate l'eccitante mondo del bdsm con eleganza e raffinatezza grazie alla nostra maschera oscurante in pelle vegana nera.

keywords

string

title

string

Maschera in similpelle nera

seotitle

string

Maschera in similpelle nera

seouri

string

specifications

string

stylingtips

string

summary

string

Esplorate l'eccitante mondo del bdsm con eleganza e raffinatezza grazie alla nostra maschera oscurante in pelle vegana nera.

title

string

Maschera in similpelle nera

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Ontdek het zwarte masker van veganistisch leer, een onmisbaar accessoire voor je spelletjes van onderwerping en dominantie. Volledig verduisterend. Gemaakt van eersteklas veganistisch leer, behoudt dit masker niet alleen de esthetiek van traditioneel leer, maar respecteert het ook het leven van dieren en het milieu. Het ergonomische ontwerp is ontworpen met jouw comfort in gedachten. Het past zich zachtjes aan de rondingen van je gezicht aan, blokkeert het licht effectief en biedt een zacht, omhullend gevoel. Dankzij de verstelbare elastische band past hij zich aan verschillende hoofdmaten aan zonder ongemak of overmatige druk. Een zachte aanraking die je omhult in een cocon van sensueel plezier en mysterie. Of je nu een bdsm-expert bent of gewoon je avonden wat pittiger wilt maken, dit bondage masker is het accessoire dat je nodig hebt om een vleugje opwinding en intrige toe te voegen aan je intieme momenten.

guid

string

https://dev.divasboudoir.com/nl/zwart-kunstlederen-masker-zwart/afbm0001.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Verken de opwindende wereld van bdsm met elegantie en verfijning dankzij ons zwarte veganistisch lederen verduisteringsmasker.

keywords

string

title

string

Zwart kunstlederen masker

seotitle

string

Zwart kunstlederen masker

seouri

string

specifications

string

stylingtips

string

summary

string

Verken de opwindende wereld van bdsm met elegantie en verfijning dankzij ons zwarte veganistisch lederen verduisteringsmasker.

title

string

Zwart kunstlederen masker

usageinstructions

string

Struct
Entries: 15

abstract

string

careinstructions

string

description

string

Descubra a máscara preta em pele vegan, um acessório indispensável para os seus jogos de submissão e dominação. Totalmente negra. Fabricada em couro vegan de primeira qualidade, esta máscara não só preserva a estética do couro tradicional, como também respeita a vida animal e o ambiente. O seu design ergonómico foi pensado a pensar no seu conforto. Adapta-se suavemente à curva do seu rosto, bloqueando eficazmente a luz e proporcionando um toque suave e envolvente. Graças à sua banda elástica ajustável, adapta-se a uma vasta gama de tamanhos de cabeça sem causar desconforto ou pressão indevida. Um toque suave que o envolverá num casulo de prazer sensual e de mistério. Quer seja um especialista em bdsm ou apenas queira apimentar as suas noites, esta máscara bondage é o acessório de que necessita para dar um toque de excitação e intriga aos seus momentos íntimos.

guid

string

https://dev.divasboudoir.com/pt/mascara-de-couro-sintetico-preto-preto/afbm0001.htm

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Explore o excitante mundo do bdsm com elegância e sofisticação graças à nossa máscara blackout em pele vegan preta.

keywords

string

title

string

Máscara de couro sintético preto

seotitle

string

Máscara de couro sintético preto

seouri

string

specifications

string

stylingtips

string

summary

string

Explore o excitante mundo do bdsm com elegância e sofisticação graças à nossa máscara blackout em pele vegan preta.

title

string

Máscara de couro sintético preto

usageinstructions

string

fetishboudoir

Struct

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

latexboudoir

Struct

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

legsboudoir

Struct

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

lustboudoir

Struct

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

keywords

string

title

string

seotitle

string

seouri

string

specifications

string

stylingtips

string

summary

string

title

string

usageinstructions

string

smboudoir

Struct

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Entdecken Sie die schwarze vegane Ledermaske, ein unverzichtbares Accessoire für Ihre Unterwerfungs- und Dominanzspiele. Hergestellt aus veganem Premium-Leder, bewahrt diese Maske nicht nur die Ästhetik traditionellen Leders, sondern respektiert auch das Leben der Tiere und die Umwelt. Ihr ergonomisches Design wurde für Ihren Komfort entwickelt. Sie passt sich sanft an die Wölbung Ihres Gesichts an, blockt das Licht effektiv ab und fühlt sich gleichzeitig weich und umhüllend an. Mit seinem verstellbaren Gummiband passt er sich einer Vielzahl von Kopfgrößen an, ohne Unbehagen oder unnötigen Druck zu verursachen. Ein weiches Gefühl, das Sie in einen Kokon aus sinnlichem Vergnügen und Geheimnis einhüllt. Ob Sie nun ein Bdsm-Experte sind oder einfach nur Ihre Partys aufpeppen möchten, diese Bondage-Maske ist das richtige Accessoire, um Ihren intimen Momenten einen Hauch von Aufregung und Intrige zu verleihen.

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Erkunden Sie die aufregende Welt des bdsm mit Eleganz und Raffinesse mit unserer schwarzen Maske aus veganem Leder.

keywords

string

title

string

SM-Maske aus schwarzem Kunstleder

seotitle

string

SM-Maske aus schwarzem Kunstleder

seouri

string

specifications

string

stylingtips

string

summary

string

Erkunden Sie die aufregende Welt des bdsm mit Eleganz und Raffinesse mit unserer schwarzen Maske aus veganem Leder.

title

string

SM-Maske aus schwarzem Kunstleder

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Ανακαλύψτε τη μαύρη μάσκα από vegan δέρμα, ένα απαραίτητο αξεσουάρ για τα παιχνίδια υποταγή&sigmaf; και κυριαρχία&sigmaf; σα&sigmaf;. Κατασκευασμένη από κορυφαίο vegan δέρμα, αυτή η μάσκα όχι μόνο διατηρεί την αισθητική του παραδοσιακού δέρματο&sigmaf;, αλλά και σέβεται τη ζωή των ζώων και το περιβάλλον. Ο εργονομικό&sigmaf; τη&sigmaf; σχεδιασμό&sigmaf; έχει μελετηθεί με γνώμονα την άνεσή σα&sigmaf;. Προσαρμόζεται απαλά στην καμπύλη του προσώπου σα&sigmaf;, αποκλείοντα&sigmaf; αποτελεσματικά το φω&sigmaf;, ενώ παράλληλα προσφέρει μια απαλή, περιβάλλουσα αίσθηση. Χάρη στη ρυθμιζόμενη ελαστική ζώνη του, προσαρμόζεται σε ένα ευρύ φάσμα μεγεθών κεφαλή&sigmaf; χωρί&sigmaf; να προκαλεί δυσφορία ή αδικαιολόγητη πίεση. Ένα απαλό άγγιγμα που θα σα&sigmaf; τυλίξει σε ένα κουκούλι αισθησιακή&sigmaf; απόλαυση&sigmaf; και μυστηρίου. Είτε είστε ειδικό&sigmaf; στο bdsm είτε απλά θέλετε να κάνετε τα βράδια σα&sigmaf; πιο πικάντικα, αυτή η μάσκα bondage είναι το αξεσουάρ που χρειάζεστε για να προσθέσετε μια πινελιά ενθουσιασμού και ίντριγκα&sigmaf; στι&sigmaf; προσωπικέ&sigmaf; σα&sigmaf; στιγμέ&sigmaf;.

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Εξερευνήστε τον συναρπαστικό κόσμο του bdsm με κομψότητα και εκλέπτυνση χάρη στη μαύρη μάσκα από vegan δέρμα.

keywords

string

title

string

Μαύρη μάσκα SM από δερματίνη

seotitle

string

Μαύρη μάσκα SM από δερματίνη

seouri

string

specifications

string

stylingtips

string

summary

string

Εξερευνήστε τον συναρπαστικό κόσμο του bdsm με κομψότητα και εκλέπτυνση χάρη στη μαύρη μάσκα από vegan δέρμα.

title

string

Μαύρη μάσκα SM από δερματίνη

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Discover the black vegan leather mask, an essential accessory for your games of submission and domination. Made from premium vegan leather, this mask not only preserves the aesthetics of traditional leather, but also respects animal life and the environment. Its ergonomic design has been thought out with your comfort in mind. It gently conforms to the curvature of your face, effectively blocking light while offering a soft, enveloping feel. Thanks to its adjustable elastic band, it adapts to a wide range of head sizes without causing discomfort or undue pressure. A soft touch that envelops you in a cocoon of sensual pleasure and mystery. Whether you're a bdsm expert or just want to spice up your evenings, this bondage mask is just the accessory you need to add a touch of excitement and intrigue to your intimate moments.

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Explore the exciting world of bdsm with elegance and sophistication thanks to our black vegan leather mask.

keywords

string

title

string

Black leatherette SM mask

seotitle

string

Black leatherette SM mask

seouri

string

specifications

string

stylingtips

string

summary

string

Explore the exciting world of bdsm with elegance and sophistication thanks to our black vegan leather mask.

title

string

Black leatherette SM mask

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Descubre la máscara negra de cuero vegano, un accesorio esencial para tus juegos de sumisión y dominación. Fabricada en cuero vegano de primera calidad, esta máscara no sólo conserva la estética del cuero tradicional, sino que también respeta la vida animal y el medio ambiente. Su diseño ergonómico ha sido pensado pensando en tu comodidad. Se adapta suavemente a la curvatura de su cara, bloqueando eficazmente la luz al tiempo que proporciona una sensación suave y envolvente. Gracias a su banda elástica ajustable, se adapta a una amplia gama de tamaños de cabeza sin causar molestias ni presiones indebidas. Un tacto suave que te envolverá en un capullo de sensual placer y misterio. Tanto si eres una experta en bdsm como si sólo quieres darle un toque picante a tus veladas, esta máscara bondage es el accesorio que necesitas para añadir un toque de excitación e intriga a tus momentos íntimos.

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Explora el apasionante mundo del bdsm con elegancia y sofisticación gracias a nuestra máscara de cuero vegano negro.

keywords

string

title

string

Máscara SM de polipiel negra

seotitle

string

Máscara SM de polipiel negra

seouri

string

specifications

string

stylingtips

string

summary

string

Explora el apasionante mundo del bdsm con elegancia y sofisticación gracias a nuestra máscara de cuero vegano negro.

title

string

Máscara SM de polipiel negra

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Découvrez le masque en cuir végan noir, un accessoire indispensable pour vos jeux de soumission et de domination. Fabriqué à partir d'un cuir végan premium, ce masque non seulement préserve l'esthétique du cuir traditionnel, mais aussi respecte la vie animale et l'environnement. Sa conception ergonomique a été pensée pour votre confort. Il épouse délicatement la courbure de votre visage, bloquant efficacement la lumière tout en offrant une sensation douce et enveloppante. Grâce à sa bande élastique ajustable, il s'adapte à une large gamme de tailles de tête sans causer d'inconfort ou de pression indue. Un toucher doux qui vous enveloppera dans un cocon de plaisir sensuel et de mystère. Que vous soyez un expert du bdsm ou que vous souhaitiez simplement pimenter vos soirées, ce masque de bondage est l'accessoire qu'il vous faut pour ajouter une touche d'excitation et d'intrigue à vos moments intimes.

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Explorez le monde passionnant du bdsm avec élégance et sophistication grâce à notre masque en cuir végan noir.

keywords

string

title

string

Masque SM en similicuir noir

seotitle

string

Masque SM en similicuir noir

seouri

string

specifications

string

stylingtips

string

summary

string

Explorez le monde passionnant du bdsm avec élégance et sophistication grâce à notre masque en cuir végan noir.

title

string

Masque SM en similicuir noir

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Scoprite la maschera nera in pelle vegana, un accessorio essenziale per i vostri giochi di sottomissione e dominazione. Realizzata in pelle vegana di prima qualità, questa maschera non solo conserva l'estetica della pelle tradizionale, ma rispetta anche gli animali e l'ambiente. Il suo design ergonomico è stato pensato per il vostro comfort. Si adatta delicatamente alle curve del viso, bloccando efficacemente la luce e offrendo una sensazione morbida e avvolgente. Grazie alla sua fascia elastica regolabile, si adatta a un'ampia gamma di dimensioni della testa, senza causare disagi o pressioni eccessive. Un tocco morbido che vi avvolgerà in un bozzolo di piacere sensuale e mistero. Che siate esperte di bdsm o che vogliate semplicemente rendere più piccanti le vostre serate, questa maschera bondage è l'accessorio di cui avete bisogno per aggiungere un tocco di eccitazione e intrigo ai vostri momenti di intimità.

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Esplorate l'eccitante mondo del bdsm con eleganza e raffinatezza grazie alla nostra maschera in pelle vegana nera.

keywords

string

title

string

Maschera SM in similpelle nera

seotitle

string

Maschera SM in similpelle nera

seouri

string

specifications

string

stylingtips

string

summary

string

Esplorate l'eccitante mondo del bdsm con eleganza e raffinatezza grazie alla nostra maschera in pelle vegana nera.

title

string

Maschera SM in similpelle nera

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Ontdek het zwarte veganistische leren masker, een essentieel accessoire voor je spelletjes van onderwerping en dominantie. Dit masker is gemaakt van eersteklas veganistisch leer en behoudt niet alleen de esthetiek van traditioneel leer, maar respecteert ook het leven van dieren en het milieu. Het ergonomische ontwerp is ontworpen met jouw comfort in gedachten. Het past zich zachtjes aan de rondingen van je gezicht aan, blokkeert het licht effectief en biedt een zacht, omhullend gevoel. Dankzij de verstelbare elastische band past hij zich aan verschillende hoofdmaten aan zonder ongemak of overmatige druk. Een zachte aanraking die je omhult in een cocon van sensueel plezier en mysterie. Of je nu een bdsm-expert bent of gewoon je avonden wat pittiger wilt maken, dit bondage masker is het accessoire dat je nodig hebt om een vleugje opwinding en intrige toe te voegen aan je intieme momenten.

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Verken de spannende wereld van bdsm met elegantie en raffinement dankzij ons zwarte masker van veganistisch leer.

keywords

string

title

string

Zwart kunstleren SM masker

seotitle

string

Zwart kunstleren SM masker

seouri

string

specifications

string

stylingtips

string

summary

string

Verken de spannende wereld van bdsm met elegantie en raffinement dankzij ons zwarte masker van veganistisch leer.

title

string

Zwart kunstleren SM masker

usageinstructions

string

Struct
Entries: 14

abstract

string

careinstructions

string

description

string

Descubra a máscara de couro vegan preta, um acessório indispensável para os seus jogos de submissão e dominação. Fabricada em couro vegan de primeira qualidade, esta máscara não só preserva a estética do couro tradicional, como também respeita a vida animal e o ambiente. O seu design ergonómico foi pensado a pensar no seu conforto. Adapta-se suavemente à curva do seu rosto, bloqueando eficazmente a luz e proporcionando um toque suave e envolvente. Graças à sua banda elástica ajustável, adapta-se a uma vasta gama de tamanhos de cabeça sem causar desconforto ou pressão indevida. Um toque suave que o envolverá num casulo de prazer sensual e de mistério. Quer seja um especialista em bdsm ou apenas queira apimentar as suas noites, esta máscara bondage é o acessório de que necessita para dar um toque de excitação e intriga aos seus momentos íntimos.

highlights

string

keypoint

string

keywords

string

metas

Struct

description

string

Explore o excitante mundo do bdsm com elegância e sofisticação graças à nossa máscara de couro vegan preto.

keywords

string

title

string

Máscara SM em couro sintético preto

seotitle

string

Máscara SM em couro sintético preto

seouri

string

specifications

string

stylingtips

string

summary

string

Explore o excitante mundo do bdsm com elegância e sofisticação graças à nossa máscara de couro vegan preto.

title

string

Máscara SM em couro sintético preto

usageinstructions

string

name

string

D-236012

netweight

string

nextshipment

string

today

ordered

number

orderidx

number

origin

string

originalsize

string

packaging

number

productshipment

string

auto

productuid

string

DE5A6EC7-64EF-424B-AB03A1A52DFDC62C

promountil

string

rating

string

none

recorduid

string

DE5A6EC7-64EF-424B-AB03A1A52DFDC62C

reference

string

AFBM0001

string

reserved

number

returned

number

returnsallowed

number

section

string

wellbeing

shipment

string

2to3days

showbrand

number

sizeinfos

Query
Template: /system/api/product/sizes.cfc:20
Execution Time: 1.53 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 = 'DE5A6EC7-64EF-424B-AB03A1A52DFDC62C'
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

stocks

Query
Template: /system/api/product/stocks.cfc:25
Execution Time: 2.69 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 = 'DE5A6EC7-64EF-424B-AB03A1A52DFDC62C'
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

DE5A6EC7-64EF-424B-AB03A1A52DFDC62C

AC6D50F2-526D-401C-946F6809662AC7D1

471

black

#000000

default

intlsize

10.7917

STOCK01

-1

8435566041402

-1

all

subcategory

string

attach

supplier

number

-1

supplierreference

string

D-236012

Zwart kunstlederen masker

Productomschrijving

Technische details

Beschikbaar kleur

Overige technische specificaties

INFORMATIE

LEDENRUIMTE

DIENSTEN

CONTACT MET ONS OPNEMEN

Zwart kunstlederen masker

Productomschrijving

Technische details

Beschikbaar kleur

Overige technische specificaties

Newsletter

Mijn instellingen wijzigen

Mijn voorkeuren opslaan