See sizes
Satisfyer Plaisir sans Fin and its accessories
Double-click to enlarge
SKU: PSBA6743
Satisfyer Plaisir sans Fin and its accessories
Stock:

This sensual, must-have, gender-neutral device instantly gives free rein to creativity, especially for couples who want to get creative.
We include a lubricant and a sex toy cleaner.

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

Satisfyer Plaisir sans Fin and its accessories

Product description

The Satisfyer Plaisir sans fin offers you over 33 possible uses: whether solo or for two, this little jewel is truly capable of anything.
Three powerful motors installed in its curved section produce vibrations that will take your body to searing ecstasy.
The first motor is located at the lower end of the voluminous handle, which can be inserted wherever you like, and the two small moving arms of this condensed pleasure are also each fitted with a motor.
You can choose between 10 levels of breathtaking vibration, which can be set independently in each arm.
The result is over a hundred different vibration combinations, opening up an unprecedented range of possibilities for your lovemaking. What's more, the head of the Satisfyer Endless Fun can be rotated through 180°, allowing it to adapt to every possible position.
With over 33 possible uses, this versatile sensual device can, for example, embrace the nipple, clitoris or labia, stimulating them non-stop to help you achieve intense orgasms.
Its velvety-soft handle fits snugly into the vagina thanks to its curved shape, perfectly stimulating women's G-spots and vulvas.
For men, it triggers intense waves of pleasure at the glans and base of the penis thanks to its powerful vibrations. It can also be used in a variety of love positions, such as doggy-style or missionary.

Includes lubricant and sex toy cleaner .

180-degree rotating head
Fun for singles and couples alike
100 vibration combinations
3 powerful motors
Over 29 possible applications
USB magnetic charging cable included
iPX7 waterproof
In biocompatible silicone
Easy to clean
Rechargeable lithium-ion battery
15-year warranty

Technical details

Available colors

Black and Deep blue

To Top
Items
Total items
Struct
Entries: 108
actions
Array
available
number-1
brand
stringsatisfyer
brandcode
stringsgse
branding
stringdivasboudoir
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
stringSatisfyer
breasts
stringna
careinstructions
string
categories
stringdivasboudoir.wellbeing.secret.duo,divasboudoir.wellbeing.secret.penetrate
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.664 ms
Record Count: 2
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,deepblue') > 0
and product_variations.productuid = 'F31BFB24-80E5-428B-BFB2CDCBD87039F7'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1blackcolorblakblackblack#000000-10
2deepbluecolordbludeepblueblue#23315300
colorrange
stringblack
colors
stringblack,deepblue
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 '2021-05-03 13:43:13'}
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
number1
isactive
number1
iscustommade
number0
isdivasize
number0
isfirstprice
number0
isfixedprice
number0
ishot
number0
isnew
number0
isonline
number0
isoutletprice
number0
itemprice
number58.2917
itempromo
string
key
stringsatisfyer-partner-multifun-3-negro
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-04-11 10:55:35'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.627 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('f31bfb24-80e5-428b-bfb2cdcbd87039f7',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.33 ms
Record Count: 0
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select products.productuid as productuid, products.reference, 'default' as type, products.key, products.language, products.name,
product_links.linkuid,
products.colors, products.vatrate, products.metadatas, products.dimensions,
products.mediadatas, products.tags, products.themes, products.isdivasize,
count(distinct product_variations.variationuid) as totalvariations,
group_concat(distinct product_variations.variationuid) as variationlist,
count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END) as inpromo,
if(count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END)>0,1,0) as haspromo,
(select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0) END)) as itempromo,
IFNULL(min(product_variations.itemprice),0) as itemprice,
(select IF (products.isfixedprice = 0 and sum(product_variations.itempromo) > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null), IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0), IFNULL(min(NULLIF(product_variations.itemprice, 0)), 0) )) as unitprice,
count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.itempromo ELSE product_variations.itemprice END) as prices,
(select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN min(NULLIF(product_variations.promountil, 0)) END)) as promountil,
products.isfixedprice, products.ishot, products.isnew, if(products.orderidx > 0, products.orderidx, 999999999) as orderidx,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
count(distinct CASE WHEN ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) > 0 OR ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) <= 0 AND product_variations.supplier = 0)) THEN product_variations.variationuid END) as instockvariations,
products.brand, brands.name as brandname, IFNULL(brands.ispublic, 0) as showbrand, brands.display,
product_categories.sizetype,GROUP_CONCAT(DISTINCT product_sizes.suppliersize) as intlsize,products.sizes,product_sizes.sizerange,product_categories.mediadatas as categorymediadatas, product_categories.sizerange as categorysizerange,
product_categorymap.section, product_categorymap.category, product_categorymap.key as subcategory
from products
left outer join product_categorymap on products.productuid = product_categorymap.productuid
left outer join product_categories on (product_categories.branding = product_categorymap.branding and product_categories.section = product_categorymap.section and product_categories.category = product_categorymap.category and product_categories.key = product_categorymap.key)
left outer join product_sizes on product_sizes.id_size IN (products.sizes)
left outer join brands on products.brand = brands.brand
left outer join product_variations on product_variations.productuid = products.productuid and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
left outer join product_links on product_links.reference = products.reference
where products.isactive = 1 and products.isdeleted = 0
and brands.isactive = 1 and brands.isdeleted = 0
and product_categories.isactive = 1 and product_categories.isdeleted = 0
and product_variations.isactive = 1
and FIND_IN_SET('divasboudoir',products.branding)
and product_categories.branding IN ('all','divasboudoir')
and product_categorymap.branding IN ('all','divasboudoir')
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and products.language in ('all','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 <> 'PSBA6743'
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
string1280
isprivate
string0
rating
stringall
src
string/photobank/products/sgse/psba6743/79824319640550.jpg
type
stringimg
width
string885
back
Struct
height
string1280
isprivate
string0
rating
stringall
src
string/photobank/products/sgse/psba6743/33145983564971.jpg
type
stringimg
width
string885
default
Struct
height
string1280
isprivate
string0
rating
stringall
src
string/photobank/products/sgse/psba6743/91172454277801.jpg
type
stringimg
width
string885
variations
Struct
colors
Struct
black
Struct
height
string1280
isprivate
string0
rating
stringall
src
string/photobank/products/sgse/psba6743/69339297099294.jpg
type
stringimg
width
string885
deepblue
Struct
height
string1016
isprivate
string0
rating
stringall
src
string/photobank/products/sgse/psba6743/satisfyer-partner-multifun-3_2.jpg
type
stringimg
width
string800
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
stringDer Satisfyer Unendliches Vergnügen bietet dir mehr als 33 Anwendungsmöglichkeiten: Ob allein oder zu zweit, dieses kleine Wunderwerk ist wirklich zu allem fähig. <br />Drei kraftvolle Motoren im gebogenen Teil des Satisfiers erzeugen Vibrationen, die deinen Körper in einen Rausch versetzen. <br />Der erste Motor befindet sich am unteren Ende des voluminösen Griffs, der an jeder beliebigen Stelle eingesetzt werden kann, und auch die beiden kleinen beweglichen Arme dieses Freudenspenders sind mit je einem Motor ausgestattet. <br />Du kannst zwischen 10 atemberaubenden Vibrationsstufen wählen, die in jedem Arm unabhängig voneinander eingestellt werden können. <br />Dadurch ergeben sich über hundert verschiedene Vibrationskombinationen, die bei deinem Liebesspiel ein nie dagewesenes Feld an Möglichkeiten eröffnen. Darüber hinaus lässt sich der Kopf des Satisfyer Endless Fun um 180 &deg; drehen, wodurch er sich an alle möglichen Positionen anpassen kann.<br /><span style="font-family: Galano, sans-serif;">Mit über 33 Anwendungsmöglichkeiten kann dieses vielseitige Sinnesgerät zum Beispiel die Brustwarze, die Klitoris oder die Schamlippen umarmen und sie ununterbrochen stimulieren, um dich zu intensiven Orgasmen zu bringen. </span><br /><span style="font-family: Galano, sans-serif;">Sein samtweicher Schaft lässt sich dank seiner gebogenen Form angenehm in die Vagina einführen und stimuliert so perfekt den G-Punkt und die Vulva der Frau. </span><br /><span style="font-family: Galano, sans-serif;">Bei Männern löst er durch seine starken Vibrationen intensive Lustwellen an der Eichel und der Peniswurzel aus. Er kann auch in verschiedenen Liebespositionen wie Doggy Style oder Missionary verwendet werden.<br /><br /><span style="font-family: Verdana, Arial, Helvetica, sans-serif;">Wir legen ein Gleitmittel und einen Sexspielzeugreiniger </span> bei.<br /></span><br /> <div><span style="font-family: Galano, sans-serif;">Kopf um 180 Grad drehbar<br />Spaß für Singles und Paare</span></div> <div><span style="font-family: Galano, sans-serif;">100 Vibrationskombinationen<br />3 starke Motoren</span></div> <div><span style="font-family: Galano, sans-serif;">Über 29 mögliche Anwendungen<br />Inklusive magnetischem USB-Ladekabel</span></div> <div><span style="font-family: Galano, sans-serif;">wasserdicht IPX7<br />Aus biokompatiblem Silikon</span></div> <div><span style="font-family: Galano, sans-serif;">Leicht zu reinigen<br />Wiederaufladbarer Lithium-Ionen-Akku</span></div> <div><span style="font-family: Galano, sans-serif;">15 Jahre Garantie</span></div>
guid
stringhttps://dev.divasboudoir.com/de/satisfyer-endloses-vergnugen-und-zubehor-satisfyer-schwarz-or-dunkelblau/psba6743.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringDieses sinnliche, unverzichtbare und geschlechtsneutrale Gerät lässt der Kreativität sofort freien Lauf, vor allem für Paare, die ihre Fantasie spielen lassen wollen. Wir legen ein Gleitmittel und einen Sexspielzeugreiniger bei.
keywords
string
title
stringSatisfyer Endloses Vergnügen und Zubehör
seotitle
stringSatisfyer Endloses Vergnügen und Zubehör
seouri
string
specifications
string
stylingtips
string
summary
stringDieses sinnliche, unverzichtbare und geschlechtsneutrale Gerät lässt der Kreativität sofort freien Lauf, vor allem für Paare, die ihre Fantasie spielen lassen wollen.<br />Wir legen ein Gleitmittel und einen Sexspielzeugreiniger bei.
title
stringSatisfyer Endloses Vergnügen und Zubehör
usageinstructions
string
el
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringΤο Satisfyer Plaisir sans fin σας προσφέρει πάνω από 33 πιθανές χρήσεις: είτε σόλο είτε για δύο, αυτό το μικρό κόσμημα είναι πραγματικά ικανό για τα πάντα. <br />Τρεις ισχυροί κινητήρες που είναι εγκατεστημένοι στο καμπύλο τμήμα του παράγουν δονήσεις που θα οδηγήσουν το σώμα σας σε εκθαμβωτική έκσταση. <br />Το πρώτο μοτέρ βρίσκεται στο κάτω άκρο της ογκώδους λαβής, η οποία μπορεί να εισαχθεί όπου θέλετε, και τα δύο μικρά κινούμενα μπράτσα αυτής της δέσμης απόλαυσης διαθέτουν επίσης από ένα μοτέρ το καθένα. <br />Μπορείτε να επιλέξετε ανάμεσα σε 10 επίπεδα δόνησης που κόβουν την ανάσα, τα οποία μπορούν να ρυθμιστούν ανεξάρτητα σε κάθε βραχίονα. <br />Το αποτέλεσμα είναι πάνω από εκατό διαφορετικοί συνδυασμοί δόνησης, ανοίγοντας ένα άνευ προηγουμένου φάσμα δυνατοτήτων για τον έρωτά σας. Επιπλέον, η κεφαλή του Satisfyer Endless Fun περιστρέφεται κατά 180&deg;, ώστε να μπορεί να προσαρμοστεί σε κάθε πιθανή θέση.<br /><span style="font-family: Galano, sans-serif;">Με περισσότερες από 33 πιθανές χρήσεις, αυτή η ευέλικτη αισθησιακή συσκευή μπορεί, για παράδειγμα, να αγκαλιάσει τη θηλή, την κλειτορίδα ή τα χείλη, διεγείροντάς τα ασταμάτητα για να σας βοηθήσει να επιτύχετε έντονους οργασμούς. </span><br /><span style="font-family: Galano, sans-serif;">Η βελούδινη μαλακή λαβή της εφαρμόζει άνετα στον κόλπο χάρη στο καμπυλωτό της σχήμα, παρέχοντας τέλεια διέγερση για τα σημεία G και το αιδοίο των γυναικών. </span><br /><span style="font-family: Galano, sans-serif;">Για τους άνδρες, προκαλεί έντονα κύματα ηδονής στη βάλανο και τη βάση του πέους χάρη στις ισχυρές δονήσεις του. Μπορεί επίσης να χρησιμοποιηθεί σε διάφορες ερωτικές στάσεις, όπως το doggy-style ή το ιεραποστολικό.<br /><br /><span style="font-family: Verdana, Arial, Helvetica, sans-serif;">Περιλαμβάνει λιπαντικό και καθαριστικό για σεξουαλικά παιχνίδια </span>.<br /></span><br /> <div><span style="font-family: Galano, sans-serif;">Περιστρεφόμενη κατά 180 μοίρες κεφαλή<br />Διασκέδαση τόσο για εργένηδες όσο και για ζευγάρια</span></div> <div><span style="font-family: Galano, sans-serif;">100 συνδυασμοί δόνησης<br />3 ισχυροί κινητήρες</span></div> <div><span style="font-family: Galano, sans-serif;">Πάνω από 29 πιθανές εφαρμογές<br />Μαγνητικό καλώδιο επαναφόρτισης USB περιλαμβάνεται</span></div> <div><span style="font-family: Galano, sans-serif;">αδιάβροχο IPX7<br />Κατασκευασμένο από βιοσυμβατή σιλικόνη</span></div> <div><span style="font-family: Galano, sans-serif;">Καθαρίζεται εύκολα<br />Επαναφορτιζόμενη μπαταρία ιόντων λιθίου</span></div> <div><span style="font-family: Galano, sans-serif;">εγγύηση 15 ετών</span></div>
guid
stringhttps://dev.divasboudoir.com/el/satisfyer-plaisir-sans-fin-kai-ta-axesoyar-toy-satisfyer-mayro-or-skoyro-mple/psba6743.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringΑυτή η αισθησιακή, απαραίτητη, ουδέτερη ως προς το φύλο συσκευή δίνει αμέσως ελεύθερο πεδίο στη δημιουργικότητα, ειδικά για τα ζευγάρια που θέλουν να γίνουν δημιουργικά. Περιλαμβάνουμε ένα λιπαντικό και ένα καθαριστικό για σεξουαλικά παιχνίδια.
keywords
string
title
stringSatisfyer Plaisir sans Fin και τα αξεσουάρ του
seotitle
stringSatisfyer Plaisir sans Fin και τα αξεσουάρ του
seouri
string
specifications
string
stylingtips
string
summary
stringΑυτή η αισθησιακή, απαραίτητη, ουδέτερη ως προς το φύλο συσκευή δίνει αμέσως ελεύθερο πεδίο στη δημιουργικότητα, ειδικά για τα ζευγάρια που θέλουν να γίνουν δημιουργικά.<br />Περιλαμβάνουμε ένα λιπαντικό και ένα καθαριστικό για σεξουαλικά παιχνίδια.
title
stringSatisfyer Plaisir sans Fin και τα αξεσουάρ του
usageinstructions
string
en
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringThe Satisfyer Plaisir sans fin offers you over 33 possible uses: whether solo or for two, this little jewel is truly capable of anything. <br />Three powerful motors installed in its curved section produce vibrations that will take your body to searing ecstasy. <br />The first motor is located at the lower end of the voluminous handle, which can be inserted wherever you like, and the two small moving arms of this condensed pleasure are also each fitted with a motor. <br />You can choose between 10 levels of breathtaking vibration, which can be set independently in each arm. <br />The result is over a hundred different vibration combinations, opening up an unprecedented range of possibilities for your lovemaking. What's more, the head of the Satisfyer Endless Fun can be rotated through 180&deg;, allowing it to adapt to every possible position.<br /><span style="font-family: Galano, sans-serif;">With over 33 possible uses, this versatile sensual device can, for example, embrace the nipple, clitoris or labia, stimulating them non-stop to help you achieve intense orgasms. </span><br /><span style="font-family: Galano, sans-serif;">Its velvety-soft handle fits snugly into the vagina thanks to its curved shape, perfectly stimulating women's G-spots and vulvas. </span><br /><span style="font-family: Galano, sans-serif;">For men, it triggers intense waves of pleasure at the glans and base of the penis thanks to its powerful vibrations. It can also be used in a variety of love positions, such as doggy-style or missionary.<br /><br /><span style="font-family: Verdana, Arial, Helvetica, sans-serif;">Includes lubricant and sex toy cleaner </span>.<br /></span><br /> <div><span style="font-family: Galano, sans-serif;">180-degree rotating head<br />Fun for singles and couples alike</span></div> <div><span style="font-family: Galano, sans-serif;">100 vibration combinations<br />3 powerful motors</span></div> <div><span style="font-family: Galano, sans-serif;">Over 29 possible applications<br />USB magnetic charging cable included</span></div> <div><span style="font-family: Galano, sans-serif;">iPX7 waterproof<br />In biocompatible silicone</span></div> <div><span style="font-family: Galano, sans-serif;">Easy to clean<br />Rechargeable lithium-ion battery</span></div> <div><span style="font-family: Galano, sans-serif;">15-year warranty</span></div>
guid
stringhttps://dev.divasboudoir.com/en/satisfyer-plaisir-sans-fin-and-its-accessories-satisfyer-black-or-deep-blue/psba6743.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringThis sensual, must-have, gender-neutral device instantly gives free rein to creativity, especially for couples who want to get creative. We include a lubricant and a sex toy cleaner.
keywords
string
title
stringSatisfyer Plaisir sans Fin and its accessories
seotitle
stringSatisfyer Plaisir sans Fin and its accessories
seouri
string
specifications
string
stylingtips
string
summary
stringThis sensual, must-have, gender-neutral device instantly gives free rein to creativity, especially for couples who want to get creative.<br />We include a lubricant and a sex toy cleaner.
title
stringSatisfyer Plaisir sans Fin and its accessories
usageinstructions
string
es
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringEl Satisfyer Plaisir sans fin te ofrece más de 33 usos posibles: en solitario o en pareja, esta pequeña joya es capaz de todo. <br />Tres potentes motores instalados en su sección curva producen vibraciones que llevarán tu cuerpo a un éxtasis deslumbrante. <br />El primer motor está situado en el extremo inferior del voluminoso mango, que puede insertarse donde quieras, y los dos pequeños brazos móviles de este manojo de placer también tienen un motor cada uno. <br />Puedes elegir entre 10 niveles de vibración que te dejarán sin aliento, ajustables de forma independiente en cada brazo. <br />El resultado son más de cien combinaciones de vibración diferentes, que abren un abanico de posibilidades sin precedentes para tus relaciones sexuales. Además, el cabezal del Satisfyer Endless Fun gira 180&deg;, por lo que puede adaptarse a todas las posiciones posibles.<br /><span style="font-family: Galano, sans-serif;">Con más de 33 usos posibles, este versátil dispositivo sensual puede, por ejemplo, abrazar el pezón, el clítoris o los labios, estimulándolos sin parar para ayudarte a alcanzar orgasmos intensos. </span><br /><span style="font-family: Galano, sans-serif;">Su mango aterciopelado se adapta perfectamente a la vagina gracias a su forma curvada, proporcionando una estimulación perfecta para los puntos G y las vulvas de las mujeres. </span><br /><span style="font-family: Galano, sans-serif;">Para los hombres, desencadena intensas oleadas de placer en el glande y la base del pene gracias a sus potentes vibraciones. También puede utilizarse en distintas posturas, como el perrito o el misionero.<br /><br /><span style="font-family: Verdana, Arial, Helvetica, sans-serif;">Incluye lubricante y limpiador de juguetes eróticos </span>.<br /></span><br /> <div><span style="font-family: Galano, sans-serif;">Cabezal giratorio de 180 grados<br />Diversión tanto para solteros como para parejas</span></div> <div><span style="font-family: Galano, sans-serif;">100 combinaciones de vibración<br />3 potentes motores</span></div> <div><span style="font-family: Galano, sans-serif;">Más de 29 aplicaciones posibles<br />Cable de recarga magnética USB incluido</span></div> <div><span style="font-family: Galano, sans-serif;">iPX7 impermeable<br />Fabricado en silicona biocompatible</span></div> <div><span style="font-family: Galano, sans-serif;">Fácil de limpiar<br />Batería recargable de iones de litio</span></div> <div><span style="font-family: Galano, sans-serif;">15 años de garantía</span></div>
guid
stringhttps://dev.divasboudoir.com/es/satisfyer-plaisir-sans-fin-y-sus-accesorios-satisfyer-negro-or-azul-oscuro/psba6743.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringEste dispositivo sensual, imprescindible y de género neutro da rienda suelta a la creatividad al instante, especialmente para las parejas que quieren ponerse creativas. Incluimos un lubricante y un limpiador de juguetes sexuales.
keywords
string
title
stringSatisfyer Plaisir sans Fin y sus accesorios
seotitle
stringSatisfyer Plaisir sans Fin y sus accesorios
seouri
string
specifications
string
stylingtips
string
summary
stringEste dispositivo sensual, imprescindible y de género neutro da rienda suelta a la creatividad al instante, especialmente para las parejas que quieren ponerse creativas.<br />Incluimos un lubricante y un limpiador de juguetes sexuales.
title
stringSatisfyer Plaisir sans Fin y sus accesorios
usageinstructions
string
fr
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringLe Satisfyer Plaisir sans fin t&rsquo;offre plus de 33 possibilit&eacute;s d&rsquo;utilisation: que ce soit en solo ou &agrave; deux, ce petit bijou est v&eacute;ritablement capable de tout. <br />Trois moteurs puissants install&eacute;s dans sa partie incurv&eacute;e produisent des vibrations qui emm&egrave;neront ton corps jusqu&rsquo;&agrave; une extase fulgurante. <br />Le premier moteur se trouve &agrave; l&rsquo;extr&eacute;mit&eacute; inf&eacute;rieure du manche volumineux, qui peut s&rsquo;ins&eacute;rer &agrave; l'endroit de ton choix, et les deux petits bras mobiles de ce condens&eacute; de plaisir sont &eacute;galement pourvus d&rsquo;un moteur chacun. <br />Tu peux faire ton choix entre 10 niveaux de vibrations &eacute;poustouflantes, qu&rsquo;il est possible de r&eacute;gler ind&eacute;pendamment dans chaque bras. <br />On obtient ainsi plus d&rsquo;une centaine de combinaisons de vibrations diff&eacute;rentes, qui ouvriront un champ des possibles sans pr&eacute;c&eacute;dent lors de tes jeux amoureux. De plus, la t&ecirc;te du Satisfyer Endless Fun se tourne &agrave; 180 &deg;, ce qui lui permet de s&rsquo;adapter &agrave; toutes les positions possibles.<br /><span style="font-family: Galano, sans-serif;">Avec plus de 33 possibilit&eacute;s d&rsquo;utilisation, cet appareil sensuel polyvalent peut par exemple &eacute;treindre le t&eacute;ton, le clitoris ou les l&egrave;vres, et les stimuler sans discontinuer pour te faire atteindre des orgasmes intenses. </span><br /><span style="font-family: Galano, sans-serif;">Son manche doux comme du velours s&rsquo;ins&egrave;re agr&eacute;ablement dans le vagin gr&acirc;ce sa forme incurv&eacute;e et stimule ainsi parfaitement le point G et la vulve de la femme. </span><br /><span style="font-family: Galano, sans-serif;">Chez l&rsquo;homme, il d&eacute;clenche d&rsquo;intenses vagues de plaisir au niveau du gland et de la base du p&eacute;nis gr&acirc;ce &agrave; ses vibrations puissantes. Il est &eacute;galement possible de l&rsquo;utiliser dans diverses positions amoureuses, telles que la levrette ou le missionnaire.<br /><br /><span style="font-family: Verdana, Arial, Helvetica, sans-serif;">Nous y incluons un lubrifiant et un nettoyant sex toy.&nbsp;</span><br /></span><br /> <div><span style="font-family: Galano, sans-serif;">T&ecirc;te rotative sur 180 degr&eacute;s<br />Du plaisir pour les c&eacute;libataires et les couples</span></div> <div><span style="font-family: Galano, sans-serif;">100 combinaisons de vibrations<br />3 moteurs puissants</span></div> <div><span style="font-family: Galano, sans-serif;">Plus de 29 applications possibles<br />C&acirc;ble de recharge magn&eacute;tique USB inclus</span></div> <div><span style="font-family: Galano, sans-serif;">&Eacute;tanche IPX7<br />En silicone biocompatible</span></div> <div><span style="font-family: Galano, sans-serif;">Nettoyage facile<br />Batterie lithium-ion rechargable</span></div> <div><span style="font-family: Galano, sans-serif;">15 ans de garantie</span></div>
guid
stringhttps://dev.divasboudoir.com/fr/satisfyer-plaisir-sans-fin-et-ses-accessoires-satisfyer-noir-or-bleu-fonce/psba6743.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringCet appareil sensuel, incontournable et non genré laisse instantannément libre cours à la créativité, en particulier pour les couples qui souhaitent faire preuve d'imagination. Nous y incluons un lubrifiant et un nettoyant sex toy.
keywords
string
title
stringSatisfyer Plaisir sans Fin et ses accessoires
seotitle
stringSatisfyer Plaisir sans Fin et ses accessoires
seouri
string
specifications
string
stylingtips
string
summary
stringCet appareil sensuel, incontournable et non genr&eacute; laisse instantann&eacute;ment libre cours &agrave; la cr&eacute;ativit&eacute;, en particulier pour les couples qui souhaitent faire preuve d'imagination.<br />Nous y incluons un lubrifiant et un nettoyant sex toy.
title
stringSatisfyer Plaisir sans Fin et ses accessoires
usageinstructions
string
it
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringIl Satisfyer Plaisir sans fin vi offre oltre 33 possibilità di utilizzo: da soli o in due, questo piccolo gioiello è davvero capace di tutto. <br />Tre potenti motori installati nella sua sezione curva producono vibrazioni che porteranno il vostro corpo ad un'estasi abbagliante. <br />Il primo motore si trova all'estremità inferiore dell'ingombrante impugnatura, che può essere inserita ovunque si desideri, e anche i due piccoli bracci mobili di questo fascio di piacere sono dotati di un motore ciascuno. <br />È possibile scegliere tra 10 livelli di vibrazione mozzafiato, regolabili in modo indipendente su ciascun braccio. <br />Il risultato è un centinaio di combinazioni di vibrazioni diverse, che aprono una gamma di possibilità senza precedenti per il vostro rapporto d'amore. Inoltre, la testa del Satisfyer Endless Fun ruota di 180&deg;, per adattarsi a tutte le posizioni possibili.<br /><span style="font-family: Galano, sans-serif;">Con oltre 33 possibilità di utilizzo, questo versatile dispositivo sensuale può, ad esempio, abbracciare il capezzolo, il clitoride o le labbra, stimolandoli senza sosta per aiutarvi a raggiungere orgasmi intensi. </span><br /><span style="font-family: Galano, sans-serif;">La sua impugnatura morbida e vellutata si adatta perfettamente alla vagina grazie alla sua forma curva, stimolando perfettamente i punti G e la vulva delle donne. </span><br /><span style="font-family: Galano, sans-serif;">Per gli uomini, scatena intense ondate di piacere sul glande e alla base del pene grazie alle sue potenti vibrazioni. Può essere utilizzato anche in diverse posizioni d'amore, come la pecorina o il missionario.<br /><br /><span style="font-family: Verdana, Arial, Helvetica, sans-serif;">Include lubrificante e detergente per sex toy </span>.<br /></span><br /> <div><span style="font-family: Galano, sans-serif;">Testa rotante a 180 gradi<br />Divertimento per single e coppie</span></div> <div><span style="font-family: Galano, sans-serif;">100 combinazioni di vibrazioni<br />3 potenti motori</span></div> <div><span style="font-family: Galano, sans-serif;">Oltre 29 applicazioni possibili<br />Cavo di ricarica magnetica USB incluso</span></div> <div><span style="font-family: Galano, sans-serif;">impermeabile IPX7<br />Realizzato in silicone biocompatibile</span></div> <div><span style="font-family: Galano, sans-serif;">Facile da pulire<br />Batteria ricaricabile agli ioni di litio</span></div> <div><span style="font-family: Galano, sans-serif;">garanzia di 15 anni</span></div>
guid
stringhttps://dev.divasboudoir.com/it/satisfyer-plaisir-sans-fin-e-i-suoi-accessori-satisfyer-nero-or-blu-scuro/psba6743.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringQuesto dispositivo sensuale, irrinunciabile e di genere neutro dà immediatamente libero sfogo alla creatività, soprattutto per le coppie che vogliono essere creative. Sono inclusi un lubrificante e un detergente per sex toy.
keywords
string
title
stringSatisfyer Plaisir sans Fin e i suoi accessori
seotitle
stringSatisfyer Plaisir sans Fin e i suoi accessori
seouri
string
specifications
string
stylingtips
string
summary
stringQuesto dispositivo sensuale, irrinunciabile e di genere neutro dà immediatamente libero sfogo alla creatività, soprattutto per le coppie che vogliono essere creative.<br />Sono inclusi un lubrificante e un detergente per sex toy.
title
stringSatisfyer Plaisir sans Fin e i suoi accessori
usageinstructions
string
nl
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringDe Satisfyer Plaisir sans fin biedt je meer dan 33 gebruiksmogelijkheden: solo of met z'n tweeën, dit juweeltje is werkelijk tot alles in staat. <br />Drie krachtige motoren in het gebogen gedeelte produceren vibraties die je lichaam in verblindende extase brengen. <br />De eerste motor zit aan de onderkant van het volumineuze handvat, dat je overal kunt insteken waar je maar wilt, en de twee kleine bewegende armen van deze bundel plezier hebben ook elk een motor. <br />Je kunt kiezen uit 10 niveaus van adembenemende vibraties, die in elke arm afzonderlijk kunnen worden ingesteld. <br />Het resultaat zijn meer dan honderd verschillende vibratiecombinaties, die een ongekend scala aan mogelijkheden bieden voor je vrijpartij. Bovendien draait de kop van de Satisfyer Endless Fun 180&deg;, zodat hij aan elke mogelijke positie kan worden aangepast.<br /><span style="font-family: Galano, sans-serif;">Met meer dan 33 gebruiksmogelijkheden kan dit veelzijdige sensuele apparaat bijvoorbeeld de tepel, clitoris of schaamlippen omarmen en ze non-stop stimuleren om je te helpen een intens orgasme te bereiken. </span><br /><span style="font-family: Galano, sans-serif;">Het fluweelzachte handvat past dankzij de gebogen vorm precies in de vagina en biedt perfecte stimulatie voor de G-spots en vulva's van vrouwen. </span><br /><span style="font-family: Galano, sans-serif;">Voor mannen veroorzaakt hij intense golven van genot bij de eikel en de basis van de penis dankzij de krachtige vibraties. Hij kan ook gebruikt worden in verschillende posities, zoals doggy-style of missionaris.<br /><br /><span style="font-family: Verdana, Arial, Helvetica, sans-serif;">Inclusief glijmiddel en seksspeeltjesreiniger </span>.<br /></span><br /> <div><span style="font-family: Galano, sans-serif;">180 graden roterende kop<br />Plezier voor zowel singles als koppels</span></div> <div><span style="font-family: Galano, sans-serif;">100 vibratiecombinaties<br />3 krachtige motoren</span></div> <div><span style="font-family: Galano, sans-serif;">Meer dan 29 mogelijke toepassingen<br />USB magnetische oplaadkabel inbegrepen</span></div> <div><span style="font-family: Galano, sans-serif;">iPX7 waterdicht<br />Gemaakt van biocompatibel silicone</span></div> <div><span style="font-family: Galano, sans-serif;">Gemakkelijk schoon te maken<br />Oplaadbare lithium-ion batterij</span></div> <div><span style="font-family: Galano, sans-serif;">15 jaar garantie</span></div>
guid
stringhttps://dev.divasboudoir.com/nl/satisfyer-plaisir-sans-fin-en-zijn-accessoires-satisfyer-zwart-or-donkerblauw/psba6743.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringDit sensuele, must-have, genderneutrale apparaat geeft direct de vrije loop aan creativiteit, vooral voor stellen die creatief aan de slag willen. We voegen een glijmiddel en een seksspeeltjesreiniger toe.
keywords
string
title
stringSatisfyer Plaisir sans Fin en zijn accessoires
seotitle
stringSatisfyer Plaisir sans Fin en zijn accessoires
seouri
string
specifications
string
stylingtips
string
summary
stringDit sensuele, must-have, genderneutrale apparaat geeft direct de vrije loop aan creativiteit, vooral voor stellen die creatief aan de slag willen.<br />We voegen een glijmiddel en een seksspeeltjesreiniger toe.
title
stringSatisfyer Plaisir sans Fin en zijn accessoires
usageinstructions
string
pt
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringO Satisfyer Plaisir sans fin oferece-lhe mais de 33 utilizações possíveis: a solo ou a dois, esta pequena joia é capaz de tudo. <br />Três potentes motores instalados na sua secção curva produzem vibrações que levarão o seu corpo a um êxtase deslumbrante. <br />O primeiro motor está situado na extremidade inferior da pega volumosa, que pode ser inserida onde quiser, e os dois pequenos braços móveis deste feixe de prazer também têm um motor cada. <br />Pode escolher entre 10 níveis de vibração de tirar o fôlego, que podem ser ajustados independentemente em cada braço. <br />O resultado é mais de uma centena de combinações de vibrações diferentes, abrindo um leque de possibilidades sem precedentes para o seu ato sexual. Além disso, a cabeça do Satisfyer Endless Fun gira 180º, pelo que se adapta a todas as posições possíveis.<br /><span style="font-family: Galano, sans-serif;">Com mais de 33 utilizações possíveis, este versátil aparelho sensual pode, por exemplo, abraçar o mamilo, o clitóris ou os lábios, estimulando-os sem parar para a ajudar a atingir orgasmos intensos. </span><br /><span style="font-family: Galano, sans-serif;">A sua pega aveludada e macia adapta-se perfeitamente à vagina graças à sua forma curva, proporcionando uma estimulação perfeita para os pontos G e vulvas das mulheres. </span><br /><span style="font-family: Galano, sans-serif;">Para os homens, desencadeia intensas ondas de prazer na glande e na base do pénis graças às suas potentes vibrações. Também pode ser utilizado em várias posições amorosas, como o estilo cãozinho ou missionário.<br /><br /><span style="font-family: Verdana, Arial, Helvetica, sans-serif;">Inclui lubrificante e limpador de brinquedos sexuais </span>.<br /></span><br /> <div><span style="font-family: Galano, sans-serif;">Cabeça rotativa de 180 graus<br />Diversão para solteiros e casais</span></div> <div><span style="font-family: Galano, sans-serif;">100 combinações de vibração<br />3 motores potentes</span></div> <div><span style="font-family: Galano, sans-serif;">Mais de 29 aplicações possíveis<br />Cabo de recarga magnética USB incluído</span></div> <div><span style="font-family: Galano, sans-serif;">iPX7 à prova de água<br />Fabricado em silicone biocompatível</span></div> <div><span style="font-family: Galano, sans-serif;">Fácil de limpar<br />Bateria de iões de lítio recarregável</span></div> <div><span style="font-family: Galano, sans-serif;">15 anos de garantia</span></div>
guid
stringhttps://dev.divasboudoir.com/pt/satisfyer-plaisir-sans-fin-e-os-seus-acessorios-satisfyer-preto-or-azul-escuro/psba6743.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringEste dispositivo sensual, imprescindível e neutro em termos de género dá imediatamente rédea solta à criatividade, especialmente para os casais que querem ser criativos. Incluímos um lubrificante e um limpador de brinquedos sexuais.
keywords
string
title
stringSatisfyer Plaisir sans Fin e os seus acessórios
seotitle
stringSatisfyer Plaisir sans Fin e os seus acessórios
seouri
string
specifications
string
stylingtips
string
summary
stringEste dispositivo sensual, imprescindível e neutro em termos de género dá imediatamente rédea solta à criatividade, especialmente para os casais que querem ser criativos.<br />Incluímos um lubrificante e um limpador de brinquedos sexuais.
title
stringSatisfyer Plaisir sans Fin e os seus acessórios
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
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
name
stringSATISFYER PARTNER MULTIFUN 3 NEGRO
netweight
string
nextshipment
stringtoday
ordered
number39
orderidx
number0
origin
string
originalsize
string
packaging
number0
productshipment
stringauto
productuid
stringF31BFB24-80E5-428B-BFB2CDCBD87039F7
promountil
string
rating
stringnone
recorduid
stringF31BFB24-80E5-428B-BFB2CDCBD87039F7
reference
stringPSBA6743
related
string
reserved
number1
returned
number0
returnsallowed
number1
section
stringwellbeing
shipment
string2to3days
showbrand
number1
sizeinfos
Query
Template: /system/api/product/sizes.cfc:20
Execution Time: 1.11 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 = 'F31BFB24-80E5-428B-BFB2CDCBD87039F7'
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: 1.84 ms
Record Count: 2
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select * from (
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = 'F31BFB24-80E5-428B-BFB2CDCBD87039F7'
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
1F31BFB24-80E5-428B-BFB2CDCBD87039F744E6F530-B521-40B4-B5B6E60B3AEDE226471black#000000nananananadefaultnaintlsize58.29170STOCK01000-1138004061504001029-10all
2F31BFB24-80E5-428B-BFB2CDCBD87039F7B6A5EC2D-C5C1-429C-8B769E27668A6517471deepblue#233153nananananadefaultnaintlsize58.29170STOCK0100000100406150400103600all
subcategory
stringduo
supplier
number-1
supplierreference
stringD-223875
tags
string
themes
stringreadyforvalentine
totalvariations
number2
type
stringdefault
unitprice
number58.2917
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 2.6 ms
Record Count: 2
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 = 'F31BFB24-80E5-428B-BFB2CDCBD87039F7' 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 = 'F31BFB24-80E5-428B-BFB2CDCBD87039F7' 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 = 'F31BFB24-80E5-428B-BFB2CDCBD87039F7' 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 = 'F31BFB24-80E5-428B-BFB2CDCBD87039F7' 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 = 'F31BFB24-80E5-428B-BFB2CDCBD87039F7' 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 = 'F31BFB24-80E5-428B-BFB2CDCBD87039F7' 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 = 'F31BFB24-80E5-428B-BFB2CDCBD87039F7'
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
144E6F530-B521-40B4-B5B6E60B3AEDE226471black#000000nananananadefaultnaintlsize58.29170STOCK01000-1138004061504001029-10-10-10058.2917all
2B6A5EC2D-C5C1-429C-8B769E27668A6517471deepblue#233153nananananadefaultnaintlsize58.29170STOCK0100000100406150400103600-1000058.2917all
vatrate
number20
warehouse
number0