My cart

❌
Total items
View basket
Menu
See sizes
Bed Constraint Kit
Double-click to enlarge
SKU: ATKI7165
Bed Constraint Kit
Stock:

For an evening of thrills and spills, invite your partner totieher to the bed for a sensual, thrilling experience .

Color:
Quantity:
29.95 €
Help and advice
by chat, facebook or e-mail
Free returns
within 15 days *

Bed Constraint Kit

Product description

Bed restraints for ankles and wrists, adjustable with Velcro straps

This restraint kit consists of a bed restraint strap, which is made of several adjustable straps.
The main strap is positioned under the bed.
2 pairs of adjustable wrist and anklecuffs with Velcro fasteners are attached to the ends of the straps.

The person is then immobilized witharms and legs spread.

Materials: PP, polyester, ABS and metal

Technical details

Available color

Black

To Top
View basket
Items
Total items
Struct
Entries: 108
actions
Array
available
number-1
brand
stringdivastoys
brandcode
stringdmxd
branding
stringdivasboudoir,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
stringDiva's Toys
breasts
stringna
careinstructions
string
categories
stringdivasboudoir.wellbeing.secret.attach,divasboudoir.wellbeing.secret.duo
category
stringsecret
categorygender
stringm
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
string1016
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/private/default.jpg
type
stringimg
width
string703
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
stringauto
colorinfos
Query
Template: /system/api/product/colors.cfc:13
Execution Time: 0.975 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 = '9A7ADA18-383A-4FB7-A764A3B6BE3EEC0F'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1blackcolorblakblackblack#000000-10
colorrange
stringblack
colors
stringblack
colortype
stringcolor
comments
string
compositions
Struct
Entries: 13
coton
string
elastane
string
free
string
leather
string
lycra
string
metal
string
nylon
string
polyamide
string
polyester
string
polyurethane
string
silk
string
spandex
string
viscose
string
datecreated
Date Time (Europe/Paris)
{ts '2024-01-17 17:00:52'}
defect
number0
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
stringcm
wiresize
string
display
stringall
displayfrom
string
displayto
string
grossweight
string
hasbrandinfos
booleanfalse
hascareinstructions
booleanfalse
hascolorinfos
booleantrue
hascompositions
booleanfalse
hasdescription
booleantrue
hasdimensions
booleanfalse
hasmaterials
booleanfalse
hasotherspecifications
booleanfalse
haspromo
number0
hasshortdescription
booleantrue
hassizeinfos
booleanfalse
hasspecifications
booleanfalse
hasstockinfos
booleanfalse
hasstylingtips
booleanfalse
hasusageinstructions
booleanfalse
hasvariations
booleantrue
import
string
inpromo
number0
instockvariations
number0
isactive
number1
iscustommade
number0
isdivasize
number0
isfirstprice
number0
isfixedprice
number0
ishot
number0
isnew
number0
isonline
number0
isoutletprice
number0
itemprice
number24.9583
itempromo
string
key
stringmenottes-de-lit-dreamy-fetish---352401002
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2024-02-28 14:04:45'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 1.05 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('9a7ada18-383a-4fb7-a764a3b6be3eec0f',lcase(cart_actions.linkedproducts)) > 0 and cart_actions.linkedproducts is not null
)
id_actionbrandinglanguagenamecodetypeminimumOrdermaximumOrderminimumItemsmaximumItemsmaximumUseallowedItemsquotasusedCountlinkedproductslinkedthemeslinkedbrandslinkeditemparamsactiveFromactiveToisActive
linkedproducts
Query
Template: /system/api/products.cfc:1305
Execution Time: 1.88 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 <> 'ATKI7165'
group by products.reference
order by products.ishot desc, products.isnew desc, orderidx asc, products.lastupdated desc
productuidreferencetypekeylanguagenamelinkuidcolorsvatratemetadatasdimensionsmediadatastagsthemesisdivasizetotalvariationsvariationlistinpromohaspromoitempromoitempriceunitpricepricespromountilisfixedpriceishotisneworderidxavailablestockinstockvariationsbrandbrandnameshowbranddisplaysizetypeintlsizesizessizerangecategorymediadatascategorysizerangesectioncategorysubcategory
linkuid
string
materials
string
mediadatas
Struct
alt
Struct
height
string1095
isprivate
string0
rating
stringall
src
string/photobank/products/dmxd/atki7165/26267.jpg
type
stringimg
width
string1096
back
Struct
height
string1000
isprivate
string0
rating
stringall
src
string/photobank/products/dmxd/atki7165/26268.jpg
type
stringimg
width
string1000
default
Struct
height
string1000
isprivate
string0
rating
stringall
src
string/photobank/products/dmxd/atki7165/26266.jpg
type
stringimg
width
string1000
variations
Struct
colors
Struct
black
Struct
height
string1000
isprivate
string0
rating
stringall
src
string/photobank/products/dmxd/atki7165/26266.jpg
type
stringimg
width
string1000
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
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<p>Bettfesseln für Fuß- und Handgelenke, die mit <span> Klettbändern </span> verstellbar sind.</p> <p><span>Dieses Fesselset besteht aus einer Bettfessel, die aus mehreren verstellbaren Riemen gefertigt ist. <br />Der Hauptgurt wird unter dem Bett positioniert.</span><br /><strong>zwei Paar</strong> Hand-<span> und Fußfesseln, die verstellbar sind und mit Klettverschlüssen versehen sind, werden an den Enden der Gurte</span> befestigt.<span><br /></span><br /><span>Die Person wird dann </span> mit<strong>gespreizten Armen und Beinen</strong><span>fixiert </span><span>.</span><br /><br /></p> <p>Materialien: PP, Polyester, ABS und Metall</p>
guid
stringhttps://dev.divasboudoir.com/de/constraint-kit-fur-das-bett-schwarz/atki7165.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringSensationsabend, schlagen Sie Ihrem Partner vor, ihn auf das Bett zu fesseln, um sinnliche und kribbelnde Erfahrungen zu machen.
keywords
string
title
stringBett-Zwangsset - The BDSM Boudoir
seotitle
stringConstraint Kit für das Bett
seouri
string
specifications
string
stylingtips
string
summary
string<p><span>Sensationsabend, schlagen Sie Ihrem Partner vor, ihn</span><span> <strong>auf das Bett</strong> </span> zu<strong>fesseln</strong>,<span> um sinnliche und kribbelnde Erfahrungen </span> zu machen.</p>
title
stringConstraint Kit für das Bett
usageinstructions
string
el
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>Περιορισμοί κρεβατιού για αστραγάλους και καρπούς, ρυθμιζόμενοι με ιμάντες<span> Velcro </span></p> <p><span>Αυτό το σετ συγκράτησης αποτελείται από έναν ιμάντα συγκράτησης κρεβατιού, ο οποίος αποτελείται από διάφορους ρυθμιζόμενους ιμάντες. <br />Ο κύριος ιμάντας τοποθετείται κάτω από το κρεβάτι.</span><br />στα<span> άκρα των ιμάντων προσαρτώνται</span><strong>2 ζεύγη</strong><span> ρυθμιζόμενων</span><strong>χειροπέδων</strong><span> Velcro για τους καρπούς και τους αστραγάλους</span>.<span><br /></span><br /><span>Ο ασθενής μπορεί στη συνέχεια να ακινητοποιηθεί </span> με τα<strong>χέρια και τα πόδια ανοιχ</strong>τά<span>.</span><br /><br /></p> <p>Υλικά: PP, πολυεστέρας, ABS και μέταλλο</p>
guid
stringhttps://dev.divasboudoir.com/el/kit-periorismoy-krevatioy-mayro/atki7165.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringΓια μια βραδιά γεμάτη συγκινήσεις και διαρροές, προσκαλέστε τον σύντροφό σας να την δέσει στο κρεβάτι για μια αισθησιακή και συναρπαστική εμπειρία.
keywords
string
title
stringΚιτ συγκράτησης κρεβατιού - The BDSM Boudoir
seotitle
stringΚιτ περιορισμού κρεβατιού
seouri
string
specifications
string
stylingtips
string
summary
string<p><span>Για μια βραδιά γεμάτη συγκινήσεις και διαρροές, προσκαλέστε τον σύντροφό σας να την</span><strong>δέσει</strong> στο<span> <strong>κρεβάτι</strong> για μια αισθησιακή και συναρπαστική εμπειρία </span>.</p>
title
stringΚιτ περιορισμού κρεβατιού
usageinstructions
string
en
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>Bed restraints for ankles and wrists, adjustable with<span> Velcro </span> straps</p> <p><span>This restraint kit consists of a bed restraint strap, which is made of several adjustable straps. <br />The main strap is positioned under the bed.</span><br /><strong>2 pairs</strong> of<span> adjustable wrist and ankle</span><strong>cuffs</strong><span> with Velcro fasteners are attached to the ends of the straps</span>.<span><br /></span><br /><span>The person is then immobilized </span> with<strong>arms and legs spread</strong><span>.</span><br /><br /></p> <p>Materials: PP, polyester, ABS and metal</p>
guid
stringhttps://dev.divasboudoir.com/en/bed-constraint-kit-black/atki7165.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringFor an evening of thrills and spills, invite your partner to tie her to the bed for a sensual, thrilling experience.
keywords
string
title
stringBed restraint kit - The BDSM Boudoir
seotitle
stringBed Constraint Kit
seouri
string
specifications
string
stylingtips
string
summary
string<p><span>For an evening of thrills and spills, invite your partner to</span><strong>tie</strong><span>her</span> to<span> <strong>the bed</strong> for a sensual, thrilling experience </span>.</p>
title
stringBed Constraint Kit
usageinstructions
string
es
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>Sujeciones de cama para tobillos y muñecas, ajustables con correas de<span> velcro </span></p> <p><span>Este kit de inmovilización consta de una correa de inmovilización para la cama, que se compone de varias correas ajustables. <br />La correa principal se coloca debajo de la cama.</span><br /><span> en los extremos de las correas se fijan</span><strong>2 pares</strong> de<span> muñequeras y tobilleras ajustables con vel</span>cro.<span><br /></span><br />De <span>este modo, se puede inmovilizar al paciente </span> con<strong>los brazos y las piernas separados</strong><span>.</span><br /><br /></p> <p>Materiales: PP, poliéster, ABS y metal</p>
guid
stringhttps://dev.divasboudoir.com/es/kit-de-restriccion-de-camas-negro/atki7165.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringPara una noche de emociones fuertes, invite a su pareja a atarla a la cama para vivir una experiencia sensual y excitante.
keywords
string
title
stringKit de sujeción para la cama - The BDSM Boudoir
seotitle
stringKit de restricción de camas
seouri
string
specifications
string
stylingtips
string
summary
string<p><span>Para una noche de emociones fuertes, invite a su pareja a</span><strong>atarla</strong> a<span> <strong>la</strong> </span> cama<span> para vivir una experiencia sensual y excitante </span>.</p>
title
stringKit de restricción de camas
usageinstructions
string
fr
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>Menottes de lit pour chevilles et poignets ajustables par bandes scratch<span>&nbsp;&nbsp;</span></p> <p><span>Ce kit de contraintes est compos&eacute; d'une&nbsp;sangle d'attache de lit, qui est fait de plusieurs sangles r&eacute;glables. <br />La sangle principale se positionne sous le lit.</span><br /><strong>2 paires de menottes</strong><span>&nbsp;pour chevilles et les poignets, r&eacute;glables et &agrave; fermetures velcro viendront s'accrocher aux extr&eacute;mit&eacute;s des sangles.<br /></span><br /><span>La personne sera alors immobilis&eacute;e&nbsp;</span><strong>bras et jambes &eacute;cart&eacute;s</strong><span>.</span><br /><br /></p> <p>Mati&egrave;res : PP, polyester, ABS et M&eacute;tal</p>
guid
stringhttps://dev.divasboudoir.com/fr/kit-de-contraintes-pour-le-lit-noir/atki7165.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringSoirée Sensations fortes, proposez à votre partenaire de l'attacher sur le lit pour vivre des expériences sensuelles et frissonnantes.
keywords
string
title
stringKit de contraintes pour le lit - The BDSM Boudoir
seotitle
stringKit de Contraintes pour le Lit
seouri
string
specifications
string
stylingtips
string
summary
string<p><span>Soir&eacute;e Sensations fortes, proposez &agrave; votre partenaire de l'</span><strong>attacher</strong><span>&nbsp;<strong>sur le lit</strong>&nbsp;pour vivre des exp&eacute;riences sensuelles et frissonnantes.&nbsp;</span></p>
title
stringKit de Contraintes pour le Lit
usageinstructions
string
it
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>Cinture di contenzione da letto per caviglie e polsi, regolabili con cinghie<span> in velcro </span></p> <p><span>Questo kit di contenzione è costituito da una cinghia di contenimento del letto, composta da diverse cinghie regolabili. <br />La cinghia principale è posizionata sotto il letto.</span><br /><strong>2 coppie</strong> di<span> polsiere e cavigliere regolabili in velcro sono fissate alle estremità delle cinghie</span>.<span><br /></span><br />Il <span>paziente può essere immobilizzato </span> con<strong>braccia e gambe divaricate</strong><span>.</span><br /><br /></p> <p>Materiali: PP, poliestere, ABS e metallo</p>
guid
stringhttps://dev.divasboudoir.com/it/kit-di-vincoli-per-il-letto-nero/atki7165.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringPer una serata all'insegna del brivido, invitate il vostro partner a legarla al letto per un'esperienza sensuale ed eccitante.
keywords
string
title
stringKit di immobilizzazione del letto - The BDSM Boudoir
seotitle
stringKit di vincoli per il letto
seouri
string
specifications
string
stylingtips
string
summary
string<p><span>Per una serata all'insegna del brivido, invitate il vostro partner a</span><strong>legarla</strong> al<span> <strong>letto</strong> </span> per<span> un'esperienza sensuale ed eccitante </span>.</p>
title
stringKit di vincoli per il letto
usageinstructions
string
nl
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>Bedbeugels voor enkels en polsen, verstelbaar met<span> klittenband </span></p> <p><span>Deze bevestigingsset bestaat uit een bedbeveiligingsband, die uit meerdere verstelbare banden bestaat. <br />De hoofdband wordt onder het bed geplaatst.</span><br /><span> aan de uiteinden van de banden</span> worden <strong>2 paar</strong><span> verstelbare pols- en enkelboeien met klittenband bevestigd</span>.<span><br /></span><br /><span>De patiënt kan dan worden geïmmobiliseerd </span> met<strong>gespreide armen en benen</strong><span>.</span><br /><br /></p> <p>Materialen: PP, polyester, ABS en metaal</p>
guid
stringhttps://dev.divasboudoir.com/nl/bedbegrenzingsset-zwart/atki7165.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringVoor een avond vol spanning en sensatie nodig je je partner uit om haar aan het bed vast te binden voor een sensuele en opwindende ervaring.
keywords
string
title
stringBedbeveiligingsset - The BDSM Boudoir
seotitle
stringBedbegrenzingsset
seouri
string
specifications
string
stylingtips
string
summary
string<p><span>Voor een avond vol spanning en sensatie nodig je je partner uit om haar</span> aan<span> <strong>het bed</strong> </span><strong>vast te binden</strong><span> voor een sensuele en opwindende ervaring </span>.</p>
title
stringBedbegrenzingsset
usageinstructions
string
pt
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>Imobilizadores de cama para tornozelos e pulsos, ajustáveis com tiras<span> de velcro </span></p> <p><span>Este kit de retenção é constituído por uma faixa de retenção na cama, composta por várias tiras ajustáveis. <br />A precinta principal é colocada debaixo da cama.</span><br /><strong>2 pares</strong> de <strong>algemas</strong><span> ajustáveis de velcro para os pulsos e tornozelos são fixados nas extremidades das correias</span>.<span><br /></span><br /><span>O doente pode então ser imobilizado </span> com<strong>os braços e as pernas afastados</strong><span>.</span><br /><br /></p> <p>Materiais: PP, poliéster, ABS e metal</p>
guid
stringhttps://dev.divasboudoir.com/pt/kit-de-restricao-de-cama-preto/atki7165.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringPara uma noite de emoções fortes, convide o seu parceiro a amarrá-la à cama para uma experiência sensual e emocionante.
keywords
string
title
stringKit de imobilização na cama - The BDSM Boudoir
seotitle
stringKit de restrição de cama
seouri
string
specifications
string
stylingtips
string
summary
string<p><span>Para uma noite de emoções fortes, convide o seu parceiro a</span><strong>amarrá-la</strong> à<span> <strong>cama</strong> para uma experiência sensual e emocionante </span>.</p>
title
stringKit de restrição de cama
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<p>Bettfesseln für Fuß- und Handgelenke, die mit <span> Klettbändern </span> verstellbar sind.</p> <p><span>Dieses Fesselset besteht aus einer Bettfessel, die aus mehreren verstellbaren Riemen gefertigt ist. <br />Der Hauptgurt wird unter dem Bett positioniert.</span><br /><strong>zwei Paar</strong> Hand-<span> und Fußfesseln, die verstellbar sind und mit Klettverschlüssen versehen sind, werden an den Enden der Gurte</span> befestigt.<span><br /></span><br /><span>Die Person wird dann </span> mit<strong>gespreizten Armen und Beinen</strong><span>fixiert </span><span>.</span><br /><br /></p> <p>Materialien: PP, Polyester, ABS und Metall</p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringSensationsabend, schlagen Sie Ihrem Partner vor, ihn auf das Bett zu fesseln, um sinnliche und kribbelnde Erfahrungen zu machen.
keywords
string
title
stringBett-Zwangsset - The BDSM Boudoir
seotitle
stringConstraint Kit für das Bett
seouri
string
specifications
string
stylingtips
string
summary
string<p><span>Sensationsabend, schlagen Sie Ihrem Partner vor, ihn</span><span> <strong>auf das Bett</strong> </span> zu<strong>fesseln</strong>,<span> um sinnliche und kribbelnde Erfahrungen </span> zu machen.</p>
title
stringConstraint Kit für das Bett
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Περιορισμοί κρεβατιού για αστραγάλους και καρπούς, ρυθμιζόμενοι με ιμάντες<span> Velcro </span></p> <p><span>Αυτό το σετ συγκράτησης αποτελείται από έναν ιμάντα συγκράτησης κρεβατιού, ο οποίος αποτελείται από διάφορους ρυθμιζόμενους ιμάντες. <br />Ο κύριος ιμάντας τοποθετείται κάτω από το κρεβάτι.</span><br />στα<span> άκρα των ιμάντων προσαρτώνται</span><strong>2 ζεύγη</strong><span> ρυθμιζόμενων</span><strong>χειροπέδων</strong><span> Velcro για τους καρπούς και τους αστραγάλους</span>.<span><br /></span><br /><span>Ο ασθενής μπορεί στη συνέχεια να ακινητοποιηθεί </span> με τα<strong>χέρια και τα πόδια ανοιχ</strong>τά<span>.</span><br /><br /></p> <p>Υλικά: PP, πολυεστέρας, ABS και μέταλλο</p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringΓια μια βραδιά γεμάτη συγκινήσεις και διαρροές, προσκαλέστε τον σύντροφό σας να την δέσει στο κρεβάτι για μια αισθησιακή και συναρπαστική εμπειρία.
keywords
string
title
stringΚιτ συγκράτησης κρεβατιού - The BDSM Boudoir
seotitle
stringΚιτ περιορισμού κρεβατιού
seouri
string
specifications
string
stylingtips
string
summary
string<p><span>Για μια βραδιά γεμάτη συγκινήσεις και διαρροές, προσκαλέστε τον σύντροφό σας να την</span><strong>δέσει</strong> στο<span> <strong>κρεβάτι</strong> για μια αισθησιακή και συναρπαστική εμπειρία </span>.</p>
title
stringΚιτ περιορισμού κρεβατιού
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Bed restraints for ankles and wrists, adjustable with<span> Velcro </span> straps</p> <p><span>This restraint kit consists of a bed restraint strap, which is made of several adjustable straps. <br />The main strap is positioned under the bed.</span><br /><strong>2 pairs</strong> of<span> adjustable wrist and ankle</span><strong>cuffs</strong><span> with Velcro fasteners are attached to the ends of the straps</span>.<span><br /></span><br /><span>The person is then immobilized </span> with<strong>arms and legs spread</strong><span>.</span><br /><br /></p> <p>Materials: PP, polyester, ABS and metal</p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringFor an evening of thrills and spills, invite your partner to tie her to the bed for a sensual, thrilling experience.
keywords
string
title
stringBed restraint kit - The BDSM Boudoir
seotitle
stringBed Constraint Kit
seouri
string
specifications
string
stylingtips
string
summary
string<p><span>For an evening of thrills and spills, invite your partner to</span><strong>tie</strong><span>her</span> to<span> <strong>the bed</strong> for a sensual, thrilling experience </span>.</p>
title
stringBed Constraint Kit
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Sujeciones de cama para tobillos y muñecas, ajustables con correas de<span> velcro </span></p> <p><span>Este kit de inmovilización consta de una correa de inmovilización para la cama, que se compone de varias correas ajustables. <br />La correa principal se coloca debajo de la cama.</span><br /><span> en los extremos de las correas se fijan</span><strong>2 pares</strong> de<span> muñequeras y tobilleras ajustables con vel</span>cro.<span><br /></span><br />De <span>este modo, se puede inmovilizar al paciente </span> con<strong>los brazos y las piernas separados</strong><span>.</span><br /><br /></p> <p>Materiales: PP, poliéster, ABS y metal</p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringPara una noche de emociones fuertes, invite a su pareja a atarla a la cama para vivir una experiencia sensual y excitante.
keywords
string
title
stringKit de sujeción para la cama - The BDSM Boudoir
seotitle
stringKit de restricción de camas
seouri
string
specifications
string
stylingtips
string
summary
string<p><span>Para una noche de emociones fuertes, invite a su pareja a</span><strong>atarla</strong> a<span> <strong>la</strong> </span> cama<span> para vivir una experiencia sensual y excitante </span>.</p>
title
stringKit de restricción de camas
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Menottes de lit pour chevilles et poignets ajustables par bandes scratch<span>&nbsp;&nbsp;</span></p> <p><span>Ce kit de contraintes est compos&eacute; d'une&nbsp;sangle d'attache de lit, qui est fait de plusieurs sangles r&eacute;glables. <br />La sangle principale se positionne sous le lit.</span><br /><strong>2 paires de menottes</strong><span>&nbsp;pour chevilles et les poignets, r&eacute;glables et &agrave; fermetures velcro viendront s'accrocher aux extr&eacute;mit&eacute;s des sangles.<br /></span><br /><span>La personne sera alors immobilis&eacute;e&nbsp;</span><strong>bras et jambes &eacute;cart&eacute;s</strong><span>.</span><br /><br /></p> <p>Mati&egrave;res : PP, polyester, ABS et M&eacute;tal</p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringSoirée Sensations fortes, proposez à votre partenaire de l'attacher sur le lit pour vivre des expériences sensuelles et frissonnantes.
keywords
string
title
stringKit de contraintes pour le lit - The BDSM Boudoir
seotitle
stringKit de Contraintes pour le Lit
seouri
string
specifications
string
stylingtips
string
summary
string<p><span>Soir&eacute;e Sensations fortes, proposez &agrave; votre partenaire de l'</span><strong>attacher</strong><span>&nbsp;<strong>sur le lit</strong>&nbsp;pour vivre des exp&eacute;riences sensuelles et frissonnantes.&nbsp;</span></p>
title
stringKit de Contraintes pour le Lit
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Cinture di contenzione da letto per caviglie e polsi, regolabili con cinghie<span> in velcro </span></p> <p><span>Questo kit di contenzione è costituito da una cinghia di contenimento del letto, composta da diverse cinghie regolabili. <br />La cinghia principale è posizionata sotto il letto.</span><br /><strong>2 coppie</strong> di<span> polsiere e cavigliere regolabili in velcro sono fissate alle estremità delle cinghie</span>.<span><br /></span><br />Il <span>paziente può essere immobilizzato </span> con<strong>braccia e gambe divaricate</strong><span>.</span><br /><br /></p> <p>Materiali: PP, poliestere, ABS e metallo</p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringPer una serata all'insegna del brivido, invitate il vostro partner a legarla al letto per un'esperienza sensuale ed eccitante.
keywords
string
title
stringKit di immobilizzazione del letto - The BDSM Boudoir
seotitle
stringKit di vincoli per il letto
seouri
string
specifications
string
stylingtips
string
summary
string<p><span>Per una serata all'insegna del brivido, invitate il vostro partner a</span><strong>legarla</strong> al<span> <strong>letto</strong> </span> per<span> un'esperienza sensuale ed eccitante </span>.</p>
title
stringKit di vincoli per il letto
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Bedbeugels voor enkels en polsen, verstelbaar met<span> klittenband </span></p> <p><span>Deze bevestigingsset bestaat uit een bedbeveiligingsband, die uit meerdere verstelbare banden bestaat. <br />De hoofdband wordt onder het bed geplaatst.</span><br /><span> aan de uiteinden van de banden</span> worden <strong>2 paar</strong><span> verstelbare pols- en enkelboeien met klittenband bevestigd</span>.<span><br /></span><br /><span>De patiënt kan dan worden geïmmobiliseerd </span> met<strong>gespreide armen en benen</strong><span>.</span><br /><br /></p> <p>Materialen: PP, polyester, ABS en metaal</p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringVoor een avond vol spanning en sensatie nodig je je partner uit om haar aan het bed vast te binden voor een sensuele en opwindende ervaring.
keywords
string
title
stringBedbeveiligingsset - The BDSM Boudoir
seotitle
stringBedbegrenzingsset
seouri
string
specifications
string
stylingtips
string
summary
string<p><span>Voor een avond vol spanning en sensatie nodig je je partner uit om haar</span> aan<span> <strong>het bed</strong> </span><strong>vast te binden</strong><span> voor een sensuele en opwindende ervaring </span>.</p>
title
stringBedbegrenzingsset
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Imobilizadores de cama para tornozelos e pulsos, ajustáveis com tiras<span> de velcro </span></p> <p><span>Este kit de retenção é constituído por uma faixa de retenção na cama, composta por várias tiras ajustáveis. <br />A precinta principal é colocada debaixo da cama.</span><br /><strong>2 pares</strong> de <strong>algemas</strong><span> ajustáveis de velcro para os pulsos e tornozelos são fixados nas extremidades das correias</span>.<span><br /></span><br /><span>O doente pode então ser imobilizado </span> com<strong>os braços e as pernas afastados</strong><span>.</span><br /><br /></p> <p>Materiais: PP, poliéster, ABS e metal</p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringPara uma noite de emoções fortes, convide o seu parceiro a amarrá-la à cama para uma experiência sensual e emocionante.
keywords
string
title
stringKit de imobilização na cama - The BDSM Boudoir
seotitle
stringKit de restrição de cama
seouri
string
specifications
string
stylingtips
string
summary
string<p><span>Para uma noite de emoções fortes, convide o seu parceiro a</span><strong>amarrá-la</strong> à<span> <strong>cama</strong> para uma experiência sensual e emocionante </span>.</p>
title
stringKit de restrição de cama
usageinstructions
string
name
stringMenottes de lit Dreamy Fetish - 352401002
netweight
string
nextshipment
stringtoday
ordered
number6
orderidx
number0
origin
string
originalsize
string
packaging
number0
productshipment
stringauto
productuid
string9A7ADA18-383A-4FB7-A764A3B6BE3EEC0F
promountil
string
rating
stringnone
recorduid
string9A7ADA18-383A-4FB7-A764A3B6BE3EEC0F
reference
stringATKI7165
related
string
reserved
number0
returned
number0
returnsallowed
number1
section
stringwellbeing
shipment
string1to2days
showbrand
number0
sizeinfos
Query
Template: /system/api/product/sizes.cfc:20
Execution Time: 1.68 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 = '9A7ADA18-383A-4FB7-A764A3B6BE3EEC0F'
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
recorduidsizesizetypecolorparam1param2availablegroupavailablestockgendersizerangesizegroupsuppliersizeintlsizeincheseusizeussizeuksizefrsizeessizedesizeitsizeptsizeelsizebustwaisthipunderbustcupthighlegheightbodyheightbodyweight
sizeranges
stringplus
sizes
string471
sizetype
stringauto
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
number0
stocks
Query
Template: /system/api/product/stocks.cfc:25
Execution Time: 2.92 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 = '9A7ADA18-383A-4FB7-A764A3B6BE3EEC0F'
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
productuidvariationuidrecorduidcolorhexvaluesuppliersizeintlsizeincheseusizeussizeuksizefrsizeessizedesizeitsizeptsizeelsizegendersizegroupcupsizesizetypeitempriceitempromopromoUntilstockuidwarehouseontourpackagingsupplierreservedorderedreturneddefectmanufacturerreferenceeanavailablestockdisplaycomments
19A7ADA18-383A-4FB7-A764A3B6BE3EEC0F180F48DA-2858-4555-B2213B393759E999471black#000000nananananadefaultnaintlsize24.95830STOCK01000-106003524010023700992737041-10all
subcategory
stringattach
supplier
number-1
supplierreference
string352401002
tags
string
themes
stringreadyforvalentine
totalvariations
number1
type
stringdefault
unitprice
number24.9583
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 4.21 ms
Record Count: 1
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '9A7ADA18-383A-4FB7-A764A3B6BE3EEC0F' and b.size = product_variations.size and b.supplier < 0) > 0,
-1,
(select
sum(distinct if(b.supplier >= 0,b.supplier,0)) +
if((sum(bb.warehouse)+sum(bb.packaging)-sum(bb.reserved))>=0,sum(bb.warehouse)+sum(bb.packaging)-sum(bb.reserved),0)
from product_variations b left outer join product_stocks bb on bb.productuid = b.productuid and bb.variationuid = b.variationuid and bb.stockuid = 'STOCK01'
where b.isactive = 1 and b.productuid = '9A7ADA18-383A-4FB7-A764A3B6BE3EEC0F' and b.size = product_variations.size)
)) as availablepersize,
(
select if((sum(cc.warehouse)+sum(cc.packaging)-sum(cc.reserved))>=0,sum(cc.warehouse)+sum(cc.packaging)-sum(cc.reserved),0)
from product_variations c left outer join product_stocks cc on cc.productuid = c.productuid and cc.variationuid = c.variationuid and cc.stockuid = 'STOCK01'
where c.isactive = 1 and c.productuid = '9A7ADA18-383A-4FB7-A764A3B6BE3EEC0F' and c.size = product_variations.size
) as stockpersize,
(if(
(select count(distinct d.variationuid) from product_variations d where d.isactive = 1 and d.productuid = '9A7ADA18-383A-4FB7-A764A3B6BE3EEC0F' and d.color = product_variations.color and d.supplier < 0) > 0,
-1,
(select sum(distinct if(d.supplier >= 0,d.supplier,0)) +
if((sum(dd.warehouse)+sum(dd.packaging)-sum(dd.reserved))>=0,sum(dd.warehouse)+sum(dd.packaging)-sum(dd.reserved),0)
from product_variations d left outer join product_stocks dd on dd.productuid = d.productuid and dd.variationuid = d.variationuid and dd.stockuid = 'STOCK01'
where d.isactive = 1 and d.productuid = '9A7ADA18-383A-4FB7-A764A3B6BE3EEC0F' and d.color = product_variations.color)
)) as availablepercolor,
(
select if((sum(ee.warehouse)+sum(ee.packaging)-sum(ee.reserved))>=0,sum(ee.warehouse)+sum(ee.packaging)-sum(ee.reserved),0)
from product_variations e left outer join product_stocks ee on ee.productuid = e.productuid and ee.variationuid = e.variationuid and ee.stockuid = 'STOCK01'
where e.isactive = 1 and e.productuid = '9A7ADA18-383A-4FB7-A764A3B6BE3EEC0F' and e.color = product_variations.color
) as stockpercolor,
if((product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null)),1,0) as haspromo,
if((product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null)),product_variations.itempromo,product_variations.itemprice) as unitprice,
'all' as display,
product_variations.comments
from product_variations
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_variations.productuid = '9A7ADA18-383A-4FB7-A764A3B6BE3EEC0F'
and product_variations.isactive = 1
and product_sizes.id_size = 471
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
order by FIELD(gender,'w','m'), sizegroup, FIELD(intlsize,'XS','S','S/M','S-M','M','M/L','M-L','L','L-XL','L/XL','XL','0X','0XL','lXL','1X','1X-2X','1X/2X','XL/2XL','XL-2XL','1XL-2XL','2XL','2X','XXL','2X-3X','2X/3X','2XL-3XL','2XL/3XL','XXXL','3XL','3X','3X-4X','3X/4X','3XL-4XL','3XL/4XL','4XL','5XL','5X','5X-6X','5X/6X','5XL-6XL','5XL/6XL','6XL','6X','7XL','7X','8XL','8X'), cast(intlsize as SIGNED ), color
variationuidrecorduidcolorhexvaluesuppliersizeintlsizeincheseusizeussizeuksizefrsizeessizedesizeitsizeptsizeelsizegendersizegroupcupsizesizetypeitempriceitempromopromoUntilstockuidwarehouseontourpackagingsupplierreservedorderedreturneddefectmanufacturerreferenceeanavailablestockavailablepersizestockpersizeavailablepercolorstockpercolorhaspromounitpricedisplaycomments
1180F48DA-2858-4555-B2213B393759E999471black#000000nananananadefaultnaintlsize24.95830STOCK01000-106003524010023700992737041-10-10-10024.9583all
vatrate
number20
warehouse
number0