Siehe Größen
Magic Max und sein Zubehör
Doppelklicken Sie zum Vergrößern
SKU: ESBI6976
Magic Max und sein Zubehör
Lager:

Dieser Vibrator kombiniert intensive innere Stimulation mit der Air-Pulse-Technologie und wird Sie zu unvorstellbaren doppelten Orgasmen führen...
Wir legen ein Gleitmittel und einen Sexspielzeugreiniger bei.

Farbe:
Menge:
69.95 €
Fundierte Ratschläge
per Chat, Facebook oder E-Mail
Kostenlose Rücksendungen
innerhalb von 15 Tagen *

Magic Max und sein Zubehör

Produktbeschreibung

Dieser Magic Max Vibrator vereint alle Vorteile eines Klitorisstimulators und eines ergonomischen Vibrators. Er findet Ihren G-Punkt im Handumdrehen, bevor er ihn von innen mit atemberaubenden Vibrationen verwöhnt.

Von außen umschließt die weiche Silikonkappe Ihre Klitoris, um ihr dank der "Air Pulse"-Technologie intensive Lustwellen einzuhauchen, und lässt Sie dank der doppelten Stimulation vor Lust zittern, bis Sie unvorstellbare Höhen erreichen.

Selbstverständlich verfügt dieses Gerät über alle Eigenschaften, für die die Marke Satisfyer bekannt und beliebt ist.

Es ist außerdem wasserdicht und kann Sie beim Baden oder Duschen genauso begleiten wie zwischen zwei weichen Kissen.

In diesem kleinen Schmuckstück hat jede Funktion ihren eigenen Motor (einer für die Druckwellen, der andere für die Vibrationen), der separat und geräuschlos gesteuert werden kann.

So können Sie einzigartige Wellen der Lust genießen, ohne befürchten zu müssen, dass Sie erwischt werden.

Mit den 10 Vibrationsprogrammen und 11 Intensitätsstufen der Druckwellen finden Sie ganz leicht die Stimulation, die am besten zu Ihrer Tagesform und Lust passt.

Der Lithium-Ionen-Akku lässt sich ganz einfach mit dem magnetischen USB-Ladekabel aufladen und ist schnell wieder einsatzbereit, um Ihnen unzählige Stunden Vergnügen zu bieten.

15 Jahre Garantie

Biokompatibles Silikon

Einführbare Länge: 12cm

Dicke: 4.3cm

Gleitmittel und Sexspielzeugreiniger sind im Lieferumfang enthalten.

Technische Details

Verfügbare Farbe

Weiß

To Top
Artikel
Gesamtartikel
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.penetrate,divasboudoir.wellbeing.secret.satisfy
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.613 ms
Record Count: 1
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_colors.color as recorduid, product_colors.type, product_colors.code, product_colors.color, product_colors.range, product_colors.hexvalue,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock
from product_colors
left outer join product_variations on product_colors.color = product_variations.color and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
where FIND_IN_SET(product_colors.color,'white') > 0
and product_variations.productuid = '127844E4-0AC8-4247-AD7D1AD4FC0D0199'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1whitecolorwhitwhitewhite#FFFFFF-10
colorrange
stringwhite
colors
stringwhite
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 '2022-01-10 13:41:28'}
defect
number0
dimensions
Struct
Entries: 14
acrylicbones
string
backsideheight
string
diameter
string
flatsteelbones
string
frontsideheight
string
fullheight
string
length
string
modestysize
string
panels
string
sides
string
spiralsteelbones
string
totallength
string
unit
stringcm
wiresize
string
display
stringall
displayfrom
string
displayto
string
grossweight
string
hasbrandinfos
booleanfalse
hascareinstructions
booleanfalse
hascolorinfos
booleantrue
hascompositions
booleanfalse
hasdescription
booleantrue
hasdimensions
booleanfalse
hasmaterials
booleanfalse
hasotherspecifications
booleanfalse
haspromo
number0
hasshortdescription
booleantrue
hassizeinfos
booleanfalse
hasspecifications
booleanfalse
hasstockinfos
booleanfalse
hasstylingtips
booleanfalse
hasusageinstructions
booleanfalse
hasvariations
booleantrue
import
string
inpromo
number0
instockvariations
number0
isactive
number1
iscustommade
number0
isdivasize
number0
isfirstprice
number0
isfixedprice
number0
ishot
number0
isnew
number0
isonline
number0
isoutletprice
number0
itemprice
number58.2917
itempromo
string
key
stringsatisfyer-pro-g-spot-rabbit-rechargeable-clitoral-stimulator
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2024-09-04 15:32:59'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.636 ms
Record Count: 0
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select cart_actions.*
from cart_actions
where cart_actions.branding IN ('all','divasboudoir')
and cart_actions.language IN ('all','de')
and (cart_actions.quotas = -1 or (cart_actions.usedCount < cart_actions.quotas))
and cart_actions.isactive = 1
and (date(cart_actions.activeFrom) <= '2025-11-24' OR cart_actions.activeFrom is null)
and (date(cart_actions.activeTo) >= '2025-11-24' OR cart_actions.activeTo is null)
and (
FIND_IN_SET('127844e4-0ac8-4247-ad7d1ad4fc0d0199',lcase(cart_actions.linkedproducts)) > 0 and cart_actions.linkedproducts is not null
)
id_actionbrandinglanguagenamecodetypeminimumOrdermaximumOrderminimumItemsmaximumItemsmaximumUseallowedItemsquotasusedCountlinkedproductslinkedthemeslinkedbrandslinkeditemparamsactiveFromactiveToisActive
linkedproducts
Query
Template: /system/api/products.cfc:1305
Execution Time: 10.6 ms
Record Count: 0
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select products.productuid as productuid, products.reference, 'default' as type, products.key, products.language, products.name,
product_links.linkuid,
products.colors, products.vatrate, products.metadatas, products.dimensions,
products.mediadatas, products.tags, products.themes, products.isdivasize,
count(distinct product_variations.variationuid) as totalvariations,
group_concat(distinct product_variations.variationuid) as variationlist,
count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END) as inpromo,
if(count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END)>0,1,0) as haspromo,
(select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0) END)) as itempromo,
IFNULL(min(product_variations.itemprice),0) as itemprice,
(select IF (products.isfixedprice = 0 and sum(product_variations.itempromo) > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null), IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0), IFNULL(min(NULLIF(product_variations.itemprice, 0)), 0) )) as unitprice,
count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.itempromo ELSE product_variations.itemprice END) as prices,
(select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN min(NULLIF(product_variations.promountil, 0)) END)) as promountil,
products.isfixedprice, products.ishot, products.isnew, if(products.orderidx > 0, products.orderidx, 999999999) as orderidx,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
count(distinct CASE WHEN ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) > 0 OR ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) <= 0 AND product_variations.supplier = 0)) THEN product_variations.variationuid END) as instockvariations,
products.brand, brands.name as brandname, IFNULL(brands.ispublic, 0) as showbrand, brands.display,
product_categories.sizetype,GROUP_CONCAT(DISTINCT product_sizes.suppliersize) as intlsize,products.sizes,product_sizes.sizerange,product_categories.mediadatas as categorymediadatas, product_categories.sizerange as categorysizerange,
product_categorymap.section, product_categorymap.category, product_categorymap.key as subcategory
from products
left outer join product_categorymap on products.productuid = product_categorymap.productuid
left outer join product_categories on (product_categories.branding = product_categorymap.branding and product_categories.section = product_categorymap.section and product_categories.category = product_categorymap.category and product_categories.key = product_categorymap.key)
left outer join product_sizes on product_sizes.id_size IN (products.sizes)
left outer join brands on products.brand = brands.brand
left outer join product_variations on product_variations.productuid = products.productuid and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
left outer join product_links on product_links.reference = products.reference
where products.isactive = 1 and products.isdeleted = 0
and brands.isactive = 1 and brands.isdeleted = 0
and product_categories.isactive = 1 and product_categories.isdeleted = 0
and product_variations.isactive = 1
and FIND_IN_SET('divasboudoir',products.branding)
and product_categories.branding IN ('all','divasboudoir')
and product_categorymap.branding IN ('all','divasboudoir')
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and products.language in ('all','de')
and product_categories.language in ('all','de')
and (products.displayFrom <= DATE(NOW()) or products.displayFrom is null)
and (products.displayTo >= DATE(NOW()) or products.displayTo IS null)
and product_links.linkuid = '' and product_links.linkuid is not null and product_links.linkuid <> ''
and products.reference <> 'ESBI6976'
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
string880
isprivate
string0
rating
stringall
src
string/photobank/products/sgse/esbi6976/satisfyer-pro-plus-g-spot-airpulse-vibrator-detailhewwazt3qz8ik.png
type
stringimg
width
string880
back
Struct
height
string728
isprivate
string0
rating
stringall
src
string/photobank/products/sgse/esbi6976/img_52846_5c2e0eacf7316b89bafef510a361f165_1.jpg
type
stringimg
width
string728
default
Struct
height
string1125
isprivate
string0
rating
stringall
src
string/photobank/products/sgse/esbi6976/naked-curve-sex-toy-satisfyer-pr.jpg
type
stringimg
width
string778
variations
Struct
colors
Struct
white
Struct
height
string500
isprivate
string0
rating
stringall
src
string/photobank/products/sgse/esbi6976/31094.jpg
type
stringimg
width
string500
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
stringproducts.sgse.esbi6976,products.sgse.esbi6976,products.sgse.esbi6976,products.sgse.esbi6976,products.sgse.esbi6976,products.sgse.esbi6976
metadatas
Struct
darkboudoir
Struct
de
Struct
Entries: 13
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 13
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 13
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 13
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 13
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 13
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 13
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 13
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
divasboudoir
Struct
de
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p><span>Dieser Magic Max Vibrator vereint alle Vorteile eines Klitorisstimulators und eines ergonomischen Vibrators. Er findet Ihren G-Punkt im Handumdrehen, bevor er ihn von innen mit atemberaubenden Vibrationen verwöhnt. </span></p> <p><span>Von außen umschließt die weiche Silikonkappe Ihre Klitoris, um ihr dank der "Air Pulse"-Technologie intensive Lustwellen einzuhauchen, und lässt Sie dank der doppelten Stimulation vor Lust zittern, bis Sie unvorstellbare Höhen erreichen.</span></p> <p><span>Selbstverständlich verfügt dieses Gerät über alle Eigenschaften, für die die Marke Satisfyer bekannt und beliebt ist. </span></p> <p><span>Es ist außerdem wasserdicht und kann Sie beim Baden oder Duschen genauso begleiten wie zwischen zwei weichen Kissen. </span></p> <p><span>In diesem kleinen Schmuckstück hat jede Funktion ihren eigenen Motor (einer für die Druckwellen, der andere für die Vibrationen), der separat und geräuschlos gesteuert werden kann. </span></p> <p><span>So können Sie einzigartige Wellen der Lust genießen, ohne befürchten zu müssen, dass Sie erwischt werden.</span></p> <p><span> Mit den 10 Vibrationsprogrammen und 11 Intensitätsstufen der Druckwellen finden Sie ganz leicht die Stimulation, die am besten zu Ihrer Tagesform und Lust passt. </span></p> <p><span>Der Lithium-Ionen-Akku lässt sich ganz einfach mit dem magnetischen USB-Ladekabel aufladen und ist schnell wieder einsatzbereit, um Ihnen unzählige Stunden Vergnügen zu bieten.</span></p> <p><span>15 Jahre Garantie</span></p> <p><span>Biokompatibles Silikon</span></p> <p><span>Einführbare Länge: 12cm</span></p> <p><span>Dicke: 4.3cm<br /><br /></span>Gleitmittel und Sexspielzeugreiniger sind im Lieferumfang enthalten.<span><br /><br /></span></p>
guid
stringhttps://dev.divasboudoir.com/de/magic-max-und-sein-zubehor-satisfyer-weiss/esbi6976.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringDieser Vibrator kombiniert intensive innere Stimulation mit der Air-Pulse-Technologie und wird Sie zu unvorstellbaren doppelten Orgasmen führen... Wir legen ein Gleitmittel und einen Sexspielzeugreiniger bei.
keywords
string
title
stringMagic Max und sein Zubehör
seotitle
stringMagic Max und sein Zubehör
seouri
string
specifications
string
stylingtips
string
summary
stringDieser Vibrator kombiniert intensive innere Stimulation mit der Air-Pulse-Technologie und wird Sie zu unvorstellbaren doppelten Orgasmen führen...<br />Wir legen ein Gleitmittel und einen Sexspielzeugreiniger bei.
title
stringMagic Max und sein Zubehör
usageinstructions
string
el
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p><span>Αυτός ο δονητής Magic Max συνδυάζει όλα τα οφέλη ενός διεγέρτη κλειτορίδας και ενός εργονομικού δονητή που βρίσκει το σημείο G στο λεπτό πριν το περιποιηθεί από μέσα με δονήσεις που κόβουν την ανάσα. </span></p> <p><span>Από την εξωτερική πλευρά, το μαλακό καπάκι σιλικόνης αγκαλιάζει την κλειτορίδα σας για να την εμποτίσει με κύματα έντονης απόλαυσης χάρη στην τεχνολογία "Air Pulse" και στέλνει την απόλαυσή σας σε αφάνταστα ύψη χάρη στη διπλή διέγερση.</span></p> <p><span>Φυσικά, αυτή η συσκευή διαθέτει όλα τα χαρακτηριστικά για τα οποία είναι γνωστή και αγαπητή η μάρκα Satisfyer. </span></p> <p><span>Είναι επίσης αδιάβροχη, ώστε να μπορείτε να την απολαμβάνετε στο μπάνιο ή στο ντους ή ανάμεσα σε δύο μαλακά μαξιλάρια. </span></p> <p><span>Σε αυτό το μικρό διαμάντι, κάθε λειτουργία έχει το δικό της μοτέρ (το ένα για τα κύματα πίεσης, το άλλο για τις δονήσεις), το οποίο μπορεί να ελέγχεται ξεχωριστά και αθόρυβα. </span></p> <p><span>Έτσι, μπορείτε να απολαμβάνετε μοναδικά κύματα απόλαυσης χωρίς να φοβάστε ότι θα αποκαλυφθείτε.</span></p> <p><span> Με 10 προγράμματα δόνησης και 11 επίπεδα έντασης κυμάτων πίεσης, είναι εύκολο να βρείτε τη διέγερση που ταιριάζει καλύτερα στο σχήμα και τη διάθεση της ημέρας σας. </span></p> <p><span>Η μπαταρία ιόντων λιθίου φορτίζεται εύκολα με το μαγνητικό καλώδιο φόρτισης USB και είναι γρήγορα έτοιμη να σας προσφέρει αμέτρητες ώρες απόλαυσης.</span></p> <p><span>εγγύηση 15 ετών</span></p> <p><span>Βιοσυμβατή σιλικόνη</span></p> <p><span>Μήκος εισαγωγής: 12 cm</span></p> <p><span>Πάχος 4,3cm<br /><br /></span>Περιλαμβάνονται λιπαντικό και καθαριστικό για σεξουαλικά παιχνίδια.<span><br /><br /></span></p>
guid
stringhttps://dev.divasboudoir.com/el/magic-max-kai-ta-axesoyar-toy-satisfyer-leyko/esbi6976.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringΑυτός ο δονητής συνδυάζει την έντονη εσωτερική διέγερση με την τεχνολογία παλλόμενου αέρα και θα σας οδηγήσει σε ασύλληπτους διπλούς οργασμούς... Περιλαμβάνουμε ένα λιπαντικό και ένα καθαριστικό για σεξουαλικά παιχνίδια.
keywords
string
title
stringMagic Max και τα αξεσουάρ του
seotitle
stringMagic Max και τα αξεσουάρ του
seouri
string
specifications
string
stylingtips
string
summary
stringΑυτός ο δονητής συνδυάζει την έντονη εσωτερική διέγερση με την τεχνολογία παλλόμενου αέρα και θα σας οδηγήσει σε ασύλληπτους διπλούς οργασμούς...<br />Περιλαμβάνουμε ένα λιπαντικό και ένα καθαριστικό για σεξουαλικά παιχνίδια.
title
stringMagic Max και τα αξεσουάρ του
usageinstructions
string
en
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p><span>This Magic Max vibrator combines all the benefits of a clitoral stimulator and an ergonomic vibrator that finds your G-spot in the blink of an eye before pampering it from the inside with breathtaking vibrations. </span></p> <p><span>From the outside, the soft silicone cap embraces your clitoris to infuse it with waves of intense pleasure thanks to "Air Pulse" technology, and thrills you to unimaginable heights thanks to dual stimulation.</span></p> <p><span>Of course, this device has all the features for which the Satisfyer brand is known and appreciated. </span></p> <p><span>It's also waterproof and can accompany you in the bath or shower as well as between two soft pillows. </span></p> <p><span>In this little gem, each feature has its own motor (one for pressure waves, the other for vibrations) which can be controlled separately and silently. </span></p> <p><span>So you can enjoy unique waves of pleasure without fear of being unmasked.</span></p> <p><span> With 10 vibration programs and 11 pressure wave intensity levels, you'll easily find the stimulation that best suits your shape and mood of the day. </span></p> <p><span>The lithium-ion battery recharges easily with its magnetic USB charging cable, and is quickly ready to give you countless hours of pleasure.</span></p> <p><span>15-year warranty</span></p> <p><span>Biocompatible silicone</span></p> <p><span>Insertion length: 12cm</span></p> <p><span>Thickness 4.3cm<br /><br /></span>Lubricant and sex toy cleaner included.<span><br /><br /></span></p>
guid
stringhttps://dev.divasboudoir.com/en/magic-max-and-its-accessories-satisfyer-white/esbi6976.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringThis vibrator combines intense internal stimulation with pulsating air technology and will lead you to unimaginable double orgasms... Includes lubricant and sex toy cleaner.
keywords
string
title
stringMagic Max and its accessories
seotitle
stringMagic Max and its accessories
seouri
string
specifications
string
stylingtips
string
summary
stringThis vibrator combines intense internal stimulation with pulsating air technology and will lead you to unimaginable double orgasms...<br />Includes lubricant and sex toy cleaner.
title
stringMagic Max and its accessories
usageinstructions
string
es
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p><span>Este vibrador Magic Max combina todas las ventajas de un estimulador de clítoris y de un vibrador ergonómico que encuentra tu punto G en un abrir y cerrar de ojos antes de mimarlo desde el interior con vibraciones impresionantes. </span></p> <p><span>Desde el exterior, el suave capuchón de silicona abraza tu clítoris para infundirle intensas oleadas de placer gracias a la tecnología "Air Pulse", y lleva tu placer a cotas inimaginables gracias a la doble estimulación.</span></p> <p><span>Naturalmente, este dispositivo tiene todas las características por las que la marca Satisfyer es conocida y adorada. </span></p> <p><span>Además, es resistente al agua, por lo que podrás disfrutarlo en la bañera o en la ducha, o entre dos suaves almohadas. </span></p> <p><span>En esta pequeña joya, cada función tiene su propio motor (uno para las ondas de presión y otro para las vibraciones) que se pueden controlar por separado y en silencio. </span></p> <p><span>Así podrá disfrutar de olas únicas de placer sin temor a ser desenmascarada.</span></p> <p><span> Con 10 programas de vibración y 11 niveles de intensidad de ondas de presión, es fácil encontrar la estimulación que mejor se adapte a tu forma y estado de ánimo del día. </span></p> <p><span>La batería de iones de litio se recarga fácilmente con su cable de carga USB magnético y está rápidamente lista para proporcionarte incontables horas de placer.</span></p> <p><span>15 años de garantía</span></p> <p><span>Silicona biocompatible</span></p> <p><span>Longitud de inserción: 12cm</span></p> <p><span>Grosor 4,</span>3cm <span><br /><br /> Lubricante y limpiador de juguetes sexuales incluidos.</span><span><br /><br /></span></p>
guid
stringhttps://dev.divasboudoir.com/es/magic-max-y-sus-accesorios-satisfyer-blanco/esbi6976.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringEste vibrador combina una intensa estimulación interna con tecnología de aire pulsante y te llevará a inimaginables orgasmos dobles... Incluimos un lubricante y un limpiador de juguetes eróticos.
keywords
string
title
stringMagic Max y sus accesorios
seotitle
stringMagic Max y sus accesorios
seouri
string
specifications
string
stylingtips
string
summary
stringEste vibrador combina una intensa estimulación interna con tecnología de aire pulsante y te llevará a inimaginables orgasmos dobles...<br />Incluimos un lubricante y un limpiador de juguetes eróticos.
title
stringMagic Max y sus accesorios
usageinstructions
string
fr
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p><span>Ce vibromasseur Magic Max combine tous les avantages d'un stimulateur clitoridien et d&rsquo;un vibromasseur ergonomique qui trouve votre point G en un clin d&rsquo;&oelig;il avant de le chouchouter de l&rsquo;int&eacute;rieur avec des vibrations &agrave; couper le souffle. </span></p> <p><span>De l&rsquo;ext&eacute;rieur, le doux capuchon en silicone embrasse votre clitoris pour lui insuffler des ondes de plaisir intense gr&acirc;ce &agrave; la technologie&nbsp; &laquo;&nbsp;Air Pulse&nbsp;&raquo; et vous fait fr&eacute;mir de plaisir jusqu&rsquo;&agrave; atteindre des sommets inimaginables gr&acirc;ce &agrave; la double stimulation.</span></p> <p><span>Bien entendu, cet appareil poss&egrave;de toutes les caract&eacute;ristiques pour lesquelles la marque Satisfyer est connue et appr&eacute;ci&eacute;e. </span></p> <p><span>Il est &eacute;galement &eacute;tanche et peut vous accompagner dans votre bain ou sous la douche tout comme entre deux oreillers moelleux. </span></p> <p><span>Dans ce petit bijou, chaque fonctionnalit&eacute; poss&egrave;de son propre moteur (l&rsquo;un pour les ondes de pression, l&rsquo;autre pour les vibrations) qui peut &ecirc;tre command&eacute; s&eacute;par&eacute;ment et de mani&egrave;re silencieuse. </span></p> <p><span>Vous pouvez donc profiter de vagues de plaisir uniques sans craindre d&rsquo;&ecirc;tre d&eacute;masqu&eacute;e.</span></p> <p><span> Avec ses 10 programmes de vibration et ses 11 niveaux d&rsquo;intensit&eacute; d&rsquo;ondes de pression, vous trouverez facilement la stimulation qui convient le mieux &agrave; votre forme et &agrave; votre envie du jour. </span></p> <p><span>La batterie lithium-ion se recharge en toute simplicit&eacute; avec son c&acirc;ble de recharge magn&eacute;tique USB et est rapidement pr&ecirc;te &agrave; vous offrir d&rsquo;innombrables heures de plaisir.</span></p> <p><span>15ans de garantie</span></p> <p><span>Silicone biocompatible</span></p> <p><span>Longueur ins&eacute;rable: 12cm</span></p> <p><span>Epaisseur 4.3cm<br /><br /></span>Nous y incluons un lubrifiant et un nettoyant sex toy.&nbsp;<span><br /><br /></span></p>
guid
stringhttps://dev.divasboudoir.com/fr/magic-max-et-ses-accessoirse-satisfyer-blanc/esbi6976.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringCe vibromasseur combine une stimulation interne intense avec la technologie à air pulsé et vous mènera à des doubles orgasmes inimaginables... Nous y incluons un lubrifiant et un nettoyant sex toy.
keywords
string
title
stringMagic Max et ses accessoirse
seotitle
stringMagic Max et ses accessoirse
seouri
string
specifications
string
stylingtips
string
summary
stringCe vibromasseur combine une stimulation interne intense avec la technologie &agrave; air puls&eacute; et vous m&egrave;nera &agrave; des doubles orgasmes inimaginables...<br />Nous y incluons un lubrifiant et un nettoyant sex toy.
title
stringMagic Max et ses accessoirse
usageinstructions
string
it
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p><span>Questo vibratore Magic Max combina tutti i vantaggi di uno stimolatore clitorideo e di un vibratore ergonomico che trova il vostro punto G in un batter d'occhio prima di coccolarlo dall'interno con vibrazioni mozzafiato. </span></p> <p><span>Dall'esterno, il morbido cappuccio in silicone abbraccia il clitoride per infondere ondate di intenso piacere grazie alla tecnologia "Air Pulse", e fa salire il piacere a livelli inimmaginabili grazie alla doppia stimolazione.</span></p> <p><span>Naturalmente, questo dispositivo possiede tutte le caratteristiche per cui il marchio Satisfyer è conosciuto e amato. </span></p> <p><span>È anche impermeabile, quindi potete godervelo nella vasca da bagno o nella doccia, o tra due morbidi cuscini. </span></p> <p><span>In questo piccolo gioiello, ogni funzione ha un proprio motore (uno per le onde di pressione, l'altro per le vibrazioni) che può essere controllato separatamente e silenziosamente. </span></p> <p><span>Così potrete godervi onde di piacere uniche senza temere di essere smascherate.</span></p> <p><span> Con 10 programmi di vibrazione e 11 livelli di intensità delle onde di pressione, è facile trovare la stimolazione più adatta alle vostre forme e all'umore della giornata. </span></p> <p><span>La batteria agli ioni di litio si ricarica facilmente con il cavo di ricarica USB magnetico ed è subito pronta a regalarvi innumerevoli ore di piacere.</span></p> <p><span>15 anni di garanzia</span></p> <p><span>Silicone biocompatibile</span></p> <p><span>Lunghezza di inserimento: 12 cm</span></p> <p><span>Spessore 4,3 cm<br /><br /></span>Lubrificante e detergente per giocattoli sessuali inclusi.<span><br /><br /></span></p>
guid
stringhttps://dev.divasboudoir.com/it/magic-max-e-i-suoi-accessori-satisfyer-bianco/esbi6976.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringQuesto vibratore combina un'intensa stimolazione interna con la tecnologia ad aria pulsante e vi condurrà a doppi orgasmi inimmaginabili... Sono inclusi un lubrificante e un detergente per sex toy.
keywords
string
title
stringMagic Max e i suoi accessori
seotitle
stringMagic Max e i suoi accessori
seouri
string
specifications
string
stylingtips
string
summary
stringQuesto vibratore combina un'intensa stimolazione interna con la tecnologia ad aria pulsante e vi condurrà a doppi orgasmi inimmaginabili...<br />Sono inclusi un lubrificante e un detergente per sex toy.
title
stringMagic Max e i suoi accessori
usageinstructions
string
nl
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p><span>Deze Magic Max vibrator combineert alle voordelen van een clitorisstimulator en een ergonomische vibrator die je G-spot in een oogwenk vindt en van binnenuit verwent met adembenemende vibraties. </span></p> <p><span>Aan de buitenkant omarmt de zachte siliconen kap je clitoris om deze te doordrenken met golven van intens genot dankzij de "Air Pulse" technologie, en stuurt je genot tintelend naar onvoorstelbare hoogten dankzij de dubbele stimulatie.</span></p> <p><span>Natuurlijk heeft dit apparaat alle functies waarvoor het merk Satisfyer bekend en geliefd is. </span></p> <p><span>Het is ook waterdicht, dus je kunt ervan genieten in bad of onder de douche, of tussen twee zachte kussens. </span></p> <p><span>In dit juweeltje heeft elke functie zijn eigen motor (één voor drukgolven, de andere voor vibraties) die apart en geruisloos bediend kan worden. </span></p> <p><span>Je kunt dus genieten van unieke golven van genot zonder bang te zijn ontmaskerd te worden.</span></p> <p><span> Met 10 vibratieprogramma's en 11 intensiteitsniveaus voor drukgolven is het eenvoudig om de stimulatie te vinden die het beste bij jouw vorm en stemming van de dag past. </span></p> <p><span>De lithium-ion batterij is eenvoudig op te laden met de magnetische USB-oplaadkabel en is snel klaar om je talloze uren plezier te geven.</span></p> <p><span>15 jaar garantie</span></p> <p><span>Biocompatibel silicone</span></p> <p><span>Inbrenglengte: 12cm</span></p> <p><span>Dikte 4.3cm<br /><br /></span>Glijmiddel en seksspeeltjesreiniger inbegrepen.<span><br /><br /></span></p>
guid
stringhttps://dev.divasboudoir.com/nl/magic-max-en-zijn-accessoires-satisfyer-wit/esbi6976.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringDeze vibrator combineert intense inwendige stimulatie met pulserende luchttechnologie en zal je naar onvoorstelbare dubbele orgasmes leiden... We voegen een glijmiddel en een seksspeeltjesreiniger toe.
keywords
string
title
stringMagic Max en zijn accessoires
seotitle
stringMagic Max en zijn accessoires
seouri
string
specifications
string
stylingtips
string
summary
stringDeze vibrator combineert intense inwendige stimulatie met pulserende luchttechnologie en zal je naar onvoorstelbare dubbele orgasmes leiden...<br />We voegen een glijmiddel en een seksspeeltjesreiniger toe.
title
stringMagic Max en zijn accessoires
usageinstructions
string
pt
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p><span>Este vibrador Magic Max combina todos os benef&iacute;cios de um estimulador de clit&oacute;ris e de um vibrador ergon&oacute;mico que encontra o seu ponto G num piscar de olhos antes de o mimar por dentro com vibra&ccedil;&otilde;es de cortar a respira&ccedil;&atilde;o. </span></p> <p><span>Do lado de fora, a capa de silicone macio abra&ccedil;a o seu clit&oacute;ris para lhe infundir ondas de prazer intenso gra&ccedil;as &agrave; tecnologia "Air Pulse", e eleva o seu prazer a alturas inimagin&aacute;veis gra&ccedil;as &agrave; dupla estimula&ccedil;&atilde;o.</span></p> <p><span>Naturalmente, este dispositivo tem todas as caracter&iacute;sticas pelas quais a marca Satisfyer &eacute; conhecida e adorada. </span></p> <p><span>Al&eacute;m disso, &eacute; imperme&aacute;vel, pelo que poder&aacute; desfrutar dele na banheira ou no duche, ou entre duas almofadas macias. </span></p> <p><span>Nesta pequena joia, cada fun&ccedil;&atilde;o tem o seu pr&oacute;prio motor (um para as ondas de press&atilde;o, outro para as vibra&ccedil;&otilde;es) que pode ser controlado separadamente e de forma silenciosa. </span></p> <p><span>Assim, pode desfrutar de ondas de prazer &uacute;nicas sem medo de ser desmascarado.</span></p> <p><span> Com 10 programas de vibra&ccedil;&atilde;o e 11 n&iacute;veis de intensidade de ondas de press&atilde;o, &eacute; f&aacute;cil encontrar a estimula&ccedil;&atilde;o que melhor se adapta &agrave; sua forma e disposi&ccedil;&atilde;o do dia. </span></p> <p><span>A bateria de i&otilde;es de l&iacute;tio &eacute; f&aacute;cil de recarregar com o seu cabo magn&eacute;tico de carregamento USB e est&aacute; rapidamente pronta para lhe proporcionar in&uacute;meras horas de prazer.</span></p> <p><span>15 anos de garantia</span></p> <p><span>Silicone biocompat&iacute;vel</span></p> <p><span>Comprimento de inser&ccedil;&atilde;o: 12cm</span></p> <p><span>Espessura 4,3cm<br /><br /></span>Lubrificante e limpador de brinquedos sexuais inclu&iacute;dos.<span><br /><br /></span></p>
guid
stringhttps://dev.divasboudoir.com/pt/magic-max-e-os-seus-acessorios-satisfyer-branco/esbi6976.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringEste vibrador combina a estimulação interna intensa com a tecnologia de ar pulsante e vai levá-la a orgasmos duplos inimagináveis... Incluímos um lubrificante e um limpador de brinquedos sexuais.
keywords
string
title
stringMagic Max e os seus acessórios
seotitle
stringMagic Max e os seus acessórios
seouri
string
specifications
string
stylingtips
string
summary
stringEste vibrador combina a estimula&ccedil;&atilde;o interna intensa com a tecnologia de ar pulsante e vai lev&aacute;-la a orgasmos duplos inimagin&aacute;veis...<br />Inclu&iacute;mos um lubrificante e um limpador de brinquedos sexuais.
title
stringMagic Max 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 PRO G-SPOT RABBIT RECHARGEABLE CLITORAL STIMULATOR
netweight
string
nextshipment
stringtoday
ordered
number9
orderidx
number0
origin
string
originalsize
string
packaging
number0
productshipment
stringauto
productuid
string127844E4-0AC8-4247-AD7D1AD4FC0D0199
promountil
string
rating
stringnone
recorduid
string127844E4-0AC8-4247-AD7D1AD4FC0D0199
reference
stringESBI6976
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.13 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 = '127844E4-0AC8-4247-AD7D1AD4FC0D0199'
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.73 ms
Record Count: 1
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select * from (
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '127844E4-0AC8-4247-AD7D1AD4FC0D0199'
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
1127844E4-0AC8-4247-AD7D1AD4FC0D019929D45F24-7C13-4BED-9C12C81A433162BC471white#FFFFFFnananananadefaultnaintlsize58.29170STOCK01000-119004049369015504-10all
subcategory
stringpenetrate
supplier
number-1
supplierreference
stringEX14192
tags
string
themes
stringreadyforvalentine
totalvariations
number1
type
stringdefault
unitprice
number58.2917
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 2.46 ms
Record Count: 1
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '127844E4-0AC8-4247-AD7D1AD4FC0D0199' 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 = '127844E4-0AC8-4247-AD7D1AD4FC0D0199' 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 = '127844E4-0AC8-4247-AD7D1AD4FC0D0199' 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 = '127844E4-0AC8-4247-AD7D1AD4FC0D0199' 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 = '127844E4-0AC8-4247-AD7D1AD4FC0D0199' 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 = '127844E4-0AC8-4247-AD7D1AD4FC0D0199' 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 = '127844E4-0AC8-4247-AD7D1AD4FC0D0199'
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
129D45F24-7C13-4BED-9C12C81A433162BC471white#FFFFFFnananananadefaultnaintlsize58.29170STOCK01000-119004049369015504-10-10-10058.2917all
vatrate
number20
warehouse
number0