O meu cesto

❌
Total de itens
Ver cesto
Menu
Ver tamanhos
Estimulador e lubrificante para a próstata
Clique duplo para aumentar
SKU: SLPS9836
Estimulador e lubrificante para a próstata
Stock:

Este estimulador ergonómico vai direto ao assunto e fá-la-á gritar de prazer.
Inclui um pequeno lubrificante.

Cor:
Quantidade:
16.95 €
Envio rápido
para os impacientes...
Ajuda e aconselhamento
por chat, facebook ou correio eletrónico
Devoluções gratuitas
no prazo de 15 dias *

Estimulador e lubrificante para a próstata

Descrição do produto

Estimulador de próstata Ultra P

A sua forma curva adapta-se perfeitamente ao seu corpo para uma estimulação mais eficaz. A ponta tem uma protuberância que estimulará as suas partes mais sensíveis com elegância!
Pode segurá-lo pela pega para o rodar e ter uma experiência de estimulação única! A protuberância na extremidade do ultra massajador permite-lhe estimular o períneo ao mesmo tempo que a próstata para um prazer dez vezes maior.
Pode atingir o orgasmo máximo sozinha ou deixar que o seu parceiro o faça por si. A escolha é sua!
É feito sem ftalatos, vem num saco selado e é flexível e totalmente à prova de água.

Comprimento total: 12cm
Comprimento inserível: 11,5cm
Diâmetro: 2,8cm

Pormenores técnicos

Cor disponível

Preto

To Top
Ver cesto
Artigos
Total de itens
Struct
Entries: 108
actions
Array
available
number1
brand
stringohmama
brandcode
stringoexu
branding
stringdivasboudoir,smboudoir
brandmedias
string{"default":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"editorial":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"logo":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""}}
brandmetas
Struct
de
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
el
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
en
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
es
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
fr
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
it
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
nl
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
pt
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
brandname
stringOh Mama
breasts
stringna
careinstructions
string
categories
stringdivasboudoir.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: 1.08 ms
Record Count: 1
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_colors.color as recorduid, product_colors.type, product_colors.code, product_colors.color, product_colors.range, product_colors.hexvalue,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock
from product_colors
left outer join product_variations on product_colors.color = product_variations.color and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
where FIND_IN_SET(product_colors.color,'black') > 0
and product_variations.productuid = '253EC979-6299-45C8-BE585F1593F74ED9'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1blackcolorblakblackblack#000000-11
colorrange
stringblack
colors
stringblack
colortype
stringcolor
comments
string
compositions
Struct
Entries: 13
coton
string
elastane
string
free
string
leather
string
lycra
string
metal
string
nylon
string
polyamide
string
polyester
string
polyurethane
string
silk
string
spandex
string
viscose
string
datecreated
Date Time (Europe/Paris)
{ts '2022-06-08 13:46:58'}
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
number14.125
itempromo
string
key
stringohmama-plug-anal-con-anilla-115-cm
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-08-22 12:11:59'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 1.06 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','pt')
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('253ec979-6299-45c8-be585f1593f74ed9',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.87 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','pt')
and product_categories.language in ('all','pt')
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 <> 'SLPS9836'
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
string800
isprivate
string0
rating
stringall
src
string/photobank/products/oexu/slps9836/plug-point-p2.png
type
stringimg
width
string800
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string800
isprivate
string0
rating
stringall
src
string/photobank/products/oexu/slps9836/plug-point-p.png
type
stringimg
width
string800
variations
Struct
colors
Struct
black
Struct
height
string800
isprivate
string0
rating
stringall
src
string/photobank/products/oexu/slps9836/plug-point-p.png
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: 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-schwarz
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-mayro
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-black
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-negro
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-noir
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-nero
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-zwart
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-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
divasboudoir
Struct
de
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<div>Ultra P Prostata Stimulator<br /><br />Seine gebogene Form passt sich perfekt an Ihren Körper an und sorgt für eine bessere Stimulation. Die Spitze hat einen Vorsprung, der Ihre empfindlichsten Stellen mit Bravour stimulieren wird!</div> <div></div> <div></div> <div>Sie können ihn am Griff festhalten, um ihn zu drehen und so eine ganz neue Art der Stimulation zu erleben! Der Vorsprung an der Spitze des Ultra-Massagegeräts ermöglicht die gleichzeitige Stimulation des Damms und der Prostata und sorgt so für ein zehnfaches Vergnügen.</div> <div></div> <div></div> <div></div> <div>Sie können sich alleine zum ultimativen Orgasmus bringen oder Ihren Partner das für Sie tun lassen. Die Wahl liegt bei Ihnen!</div> <div></div> <div></div> <div>Er ist ohne Phthalate hergestellt, in einem versiegelten Beutel verpackt, flexibel und absolut wasserdicht.<br /><br />Gesamtlänge: 12cm<br />Einführbare Länge: 11.5cm<br />Durchmesser: 2.8cm</div> <div></div> <div></div>
guid
stringhttps://dev.divasboudoir.com/de/prostatastimulator-und-sein-gleitmittel-schwarz/slps9836.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringEin sehr ergonomischer Stimulator, der direkt auf den Punkt kommt, um Sie vor Lust schreien zu lassen. Mit seinem kleinen Gleitmittel.
keywords
string
title
stringProstatastimulator und sein Gleitmittel
seotitle
stringProstatastimulator und sein Gleitmittel
seouri
stringprostatastimulator-und-sein-gleitmittel-schwarz
specifications
string
stylingtips
string
summary
stringEin sehr ergonomischer Stimulator, der direkt auf den Punkt kommt, um Sie vor Lust schreien zu lassen.<br />Mit seinem kleinen Gleitmittel.
title
stringProstatastimulator und sein Gleitmittel
usageinstructions
string
el
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<div>Διεγέρτης προστάτη Ultra P<br /><br />Το καμπυλωτό σχήμα του προσαρμόζεται τέλεια στο σώμα σας για πιο αποτελεσματική διέγερση. Το άκρο του έχει μια προεξοχή που θα διεγείρει τα πιο ευαίσθητα σημεία σας με πανηγυρικό τρόπο!</div> <div></div> <div></div> <div>Μπορείτε να το κρατήσετε από τη λαβή για να το περιστρέψετε για μια μοναδική εμπειρία διέγερσης! Η προεξοχή στο άκρο του υπερμασάζ σας επιτρέπει να διεγείρετε το περίνεο ταυτόχρονα με τον προστάτη για δεκαπλάσια απόλαυση.</div> <div></div> <div></div> <div></div> <div>Μπορείτε να κάνετε τον εαυτό σας να φτάσει στον απόλυτο οργασμό μόνος του ή να αφήσετε τον σύντροφό σας να το κάνει για εσάς. Η επιλογή είναι δική σας!</div> <div></div> <div></div> <div>Είναι κατασκευασμένο χωρίς φθαλικές ενώσεις, έρχεται σε σφραγισμένη σακούλα και είναι εύκαμπτο και απόλυτα αδιάβροχο.<br /><br />Συνολικό μήκος: 12cm<br />Εισαγόμενο μήκος: 11,5 cm<br />Διάμετρος: 2.8cm</div> <div></div> <div></div>
guid
stringhttps://dev.divasboudoir.com/el/diegertiko-kai-lipantiko-toy-prostath-mayro/slps9836.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringΑυτός ο εργονομικός διεγέρτης θα φτάσει κατευθείαν στο σημείο και θα σας κάνει να ουρλιάξετε από ευχαρίστηση. Περιλαμβάνει ένα μικρό λιπαντικό.
keywords
string
title
stringΔιεγερτικό και λιπαντικό του προστάτη
seotitle
stringΔιεγερτικό και λιπαντικό του προστάτη
seouri
stringdiegertiko-kai-lipantiko-toy-prostath-mayro
specifications
string
stylingtips
string
summary
stringΑυτός ο εργονομικός διεγέρτης θα φτάσει κατευθείαν στο σημείο και θα σας κάνει να ουρλιάξετε από ευχαρίστηση.<br />Περιλαμβάνει ένα μικρό λιπαντικό.
title
stringΔιεγερτικό και λιπαντικό του προστάτη
usageinstructions
string
en
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<div>Ultra P prostate stimulator<br /><br />Its curved shape adapts perfectly to your body for more effective stimulation. The tip has a protuberance that will stimulate your most sensitive parts with brio!</div> <div></div> <div></div> <div>You can hold it by the handle to rotate it for unprecedented stimulation! The protuberance at the end of the ultra massager lets you stimulate the perineum at the same time as the prostate, for tenfold pleasure.</div> <div></div> <div></div> <div></div> <div>You can make yourself reach the ultimate orgasm alone, or let your partner do it for you. The choice is yours!</div> <div></div> <div></div> <div>It's made without phthalates, comes in a sealed bag, is flexible and totally waterproof.<br /><br />Total length: 12cm<br />Insertable length: 11.5cm<br />Diameter: 2.8cm</div> <div></div> <div></div>
guid
stringhttps://dev.divasboudoir.com/en/prostate-stimulator-and-lubricant-black/slps9836.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringA highly ergonomic stimulator that goes straight to the point and makes you howl with pleasure. Includes a small lubricant.
keywords
string
title
stringProstate stimulator and lubricant
seotitle
stringProstate stimulator and lubricant
seouri
stringprostate-stimulator-and-lubricant-black
specifications
string
stylingtips
string
summary
stringA highly ergonomic stimulator that goes straight to the point and makes you howl with pleasure.<br />Includes a small lubricant.
title
stringProstate stimulator and lubricant
usageinstructions
string
es
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<div>Estimulador de próstata Ultra P<br /><br />Su forma curvada se adapta perfectamente a tu cuerpo para una estimulación más eficaz. La punta tiene una protuberancia que estimulará tus partes más sensibles con garbo</div> <div></div> <div></div> <div>Puedes sujetarlo por el mango para girarlo y disfrutar de una experiencia de estimulación única La protuberancia del extremo del ultra masajeador te permite estimular el perineo al mismo tiempo que la próstata para un placer multiplicado por diez.</div> <div></div> <div></div> <div></div> <div>Podrás alcanzar el orgasmo definitivo tú sola o dejar que tu pareja lo haga por ti. ¡Tú eliges!</div> <div></div> <div></div> <div>Está fabricado sin ftalatos, viene en una bolsa sellada y es flexible y totalmente impermeable.<br /><br />Longitud total: 12 cm<br />Longitud insertable: 11,5 cm<br />Diámetro: 2,8 cm</div> <div></div> <div></div>
guid
stringhttps://dev.divasboudoir.com/es/estimulador-y-lubricante-de-prostata-negro/slps9836.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringEste estimulador ergonómico irá directo al grano y te hará gritar de placer. Incluye un pequeño lubricante.
keywords
string
title
stringEstimulador y lubricante de próstata
seotitle
stringEstimulador y lubricante de próstata
seouri
stringestimulador-y-lubricante-de-prostata-negro
specifications
string
stylingtips
string
summary
stringEste estimulador ergonómico irá directo al grano y te hará gritar de placer.<br />Incluye un pequeño lubricante.
title
stringEstimulador y lubricante de próstata
usageinstructions
string
fr
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<div>Stimulateur de prostate Ultra P<br /><br />Sa forme incurv&eacute;e s'adapte parfaitement a votre corps pour une stimulation plus performante. Le bout de ce dernier poss&egrave;de une protub&eacute;rance qui stimulera vos parties les plus sensibles avec brio !</div> <div>&nbsp;</div> <div>&nbsp;</div> <div>Vous pourrez le tenir par sa poign&eacute;e pour le faire pivoter et ainsi provoquer une stimulation in&eacute;dite ! La protub&eacute;rance a l'extr&eacute;mit&eacute; de l'ultra massager vous permet une stimulation du p&eacute;rin&eacute;e en m&ecirc;me temps que la stimulation prostatique pour un plaisir d&eacute;cupl&eacute;.</div> <div>&nbsp;</div> <div>&nbsp;</div> <div>&nbsp;</div> <div>Vous pourrez vous faire atteindre l'orgasme ultime seul ou bien laissez votre partenaire le faire pour vous. C'est &agrave; vous de choisir !</div> <div>&nbsp;</div> <div>&nbsp;</div> <div>Il est fabriqu&eacute; sans phtalates, pr&eacute;sent&eacute; dans un sachet scell&eacute;, il est flexible et totalement &eacute;tanche.<br /><br />Longueur totale: 12cm<br />Longueur ins&eacute;rable: 11.5cm<br />Diam&egrave;tre: 2.8cm</div> <div>&nbsp;</div> <div>&nbsp;</div>
guid
stringhttps://dev.divasboudoir.com/fr/stimulateur-de-prostate-et-son-lubrifiant-noir/slps9836.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringUn stimulateur très ergonomique, qui ira droit au but pour vous faire hurler de plaisir. Avec son petit lubrifiant.
keywords
string
title
stringStimulateur de prostate et son lubrifiant
seotitle
stringStimulateur de prostate et son lubrifiant
seouri
stringstimulateur-de-prostate-et-son-lubrifiant-noir
specifications
string
stylingtips
string
summary
stringUn stimulateur tr&egrave;s ergonomique, qui ira droit au but pour vous faire hurler de plaisir.<br />Avec son petit lubrifiant.
title
stringStimulateur de prostate et son lubrifiant
usageinstructions
string
it
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<div>Stimolatore della prostata Ultra P<br /><br />La sua forma curva si adatta perfettamente al vostro corpo per una stimolazione più efficace. La punta ha una protuberanza che stimolerà le vostre parti più sensibili con brio!</div> <div></div> <div></div> <div>Potete tenerlo per l'impugnatura e ruotarlo per un'esperienza di stimolazione unica! La protuberanza all'estremità dell'ultra massaggiatore consente di stimolare il perineo contemporaneamente alla prostata per un piacere decuplicato.</div> <div></div> <div></div> <div></div> <div>Potete raggiungere l'orgasmo finale da soli o lasciare che il vostro partner lo faccia per voi. La scelta è vostra!</div> <div></div> <div></div> <div>È realizzato senza ftalati, viene fornito in un sacchetto sigillato ed è flessibile e totalmente impermeabile.<br /><br />Lunghezza totale: 12 cm<br />Lunghezza inseribile: 11,5 cm<br />Diametro: 2,8 cm</div> <div></div> <div></div>
guid
stringhttps://dev.divasboudoir.com/it/stimolatore-e-lubrificante-per-la-prostata-nero/slps9836.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringQuesto stimolatore ergonomico andrà dritto al punto e vi farà urlare di piacere. Include un piccolo lubrificante.
keywords
string
title
stringStimolatore e lubrificante per la prostata
seotitle
stringStimolatore e lubrificante per la prostata
seouri
stringstimolatore-e-lubrificante-per-la-prostata-nero
specifications
string
stylingtips
string
summary
stringQuesto stimolatore ergonomico andrà dritto al punto e vi farà urlare di piacere.<br />Include un piccolo lubrificante.
title
stringStimolatore e lubrificante per la prostata
usageinstructions
string
nl
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<div>Ultra P prostaatstimulator<br /><br />De gebogen vorm past zich perfect aan je lichaam aan voor een effectievere stimulatie. De punt heeft een uitsteeksel dat je meest gevoelige delen met zwier stimuleert!</div> <div></div> <div></div> <div>Je kunt hem bij het handvat vasthouden om hem te draaien voor een unieke stimulatie-ervaring! Door het uitsteeksel aan het uiteinde van de ultra stimulator kun je het perineum tegelijkertijd met de prostaat stimuleren voor tienvoudig genot.</div> <div></div> <div></div> <div></div> <div>Je kunt jezelf alleen tot het ultieme orgasme brengen of het je partner laten doen. De keuze is aan jou!</div> <div></div> <div></div> <div>Het is gemaakt zonder ftalaten, wordt geleverd in een verzegeld zakje en is flexibel en volledig waterdicht.<br /><br />Totale lengte: 12cm<br />Inbrengbare lengte: 11.5cm<br />Diameter: 2.8cm</div> <div></div> <div></div>
guid
stringhttps://dev.divasboudoir.com/nl/prostaatstimulator-en-glijmiddel-zwart/slps9836.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringDeze ergonomische stimulator komt meteen ter zake en laat je gillen van genot. Inclusief een klein glijmiddel.
keywords
string
title
stringProstaatstimulator en glijmiddel
seotitle
stringProstaatstimulator en glijmiddel
seouri
stringprostaatstimulator-en-glijmiddel-zwart
specifications
string
stylingtips
string
summary
stringDeze ergonomische stimulator komt meteen ter zake en laat je gillen van genot.<br />Inclusief een klein glijmiddel.
title
stringProstaatstimulator en glijmiddel
usageinstructions
string
pt
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<div>Estimulador de próstata Ultra P<br /><br />A sua forma curva adapta-se perfeitamente ao seu corpo para uma estimulação mais eficaz. A ponta tem uma protuberância que estimulará as suas partes mais sensíveis com elegância!</div> <div></div> <div></div> <div>Pode segurá-lo pela pega para o rodar e ter uma experiência de estimulação única! A protuberância na extremidade do ultra massajador permite-lhe estimular o períneo ao mesmo tempo que a próstata para um prazer dez vezes maior.</div> <div></div> <div></div> <div></div> <div>Pode atingir o orgasmo máximo sozinha ou deixar que o seu parceiro o faça por si. A escolha é sua!</div> <div></div> <div></div> <div>É feito sem ftalatos, vem num saco selado e é flexível e totalmente à prova de água.<br /><br />Comprimento total: 12cm<br />Comprimento inserível: 11,5cm<br />Diâmetro: 2,8cm</div> <div></div> <div></div>
guid
stringhttps://dev.divasboudoir.com/pt/estimulador-e-lubrificante-para-a-prostata-preto/slps9836.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringEste estimulador ergonómico vai direto ao assunto e fá-la-á gritar de prazer. Inclui um pequeno lubrificante.
keywords
string
title
stringEstimulador e lubrificante para a próstata
seotitle
stringEstimulador e lubrificante para a próstata
seouri
stringestimulador-e-lubrificante-para-a-prostata-preto
specifications
string
stylingtips
string
summary
stringEste estimulador ergonómico vai direto ao assunto e fá-la-á gritar de prazer.<br />Inclui um pequeno lubrificante.
title
stringEstimulador e lubrificante para a próstata
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-schwarz
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-mayro
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-black
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-negro
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-noir
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-nero
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-zwart
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-preto
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-schwarz
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-mayro
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-black
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-negro
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-noir
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-nero
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-zwart
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-preto
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-schwarz
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-mayro
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-black
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-negro
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-noir
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-nero
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-zwart
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-preto
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-schwarz
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-mayro
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-black
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-negro
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-noir
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-nero
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-zwart
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-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
smboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<div>Ultra P Stimulator<br /><br />Seine gebogene Form passt sich perfekt an Ihren Körper an und sorgt für eine bessere Stimulation. Die Spitze des Stimulators hat einen Vorsprung, der Ihre empfindlichsten Stellen mit Bravour stimulieren wird!</div> <div></div> <div></div> <div>Sie können ihn am Griff festhalten, um ihn zu drehen und so eine ganz neue Art der Stimulation zu erleben! Der Vorsprung an der Spitze des Ultra-Massagegeräts ermöglicht die gleichzeitige Stimulation des Damms und der Prostata und sorgt so für ein zehnfaches Vergnügen.</div> <div></div> <div></div> <div></div> <div>Sie können sich alleine zum ultimativen Orgasmus bringen oder Ihren Partner das für Sie tun lassen. Die Wahl liegt bei Ihnen!</div> <div></div> <div></div> <div>Er ist ohne Phthalate hergestellt, in einem versiegelten Beutel verpackt, flexibel und absolut wasserdicht.<br /><br />Gesamtlänge: 12cm<br />Einführbare Länge: 11.5cm<br />Durchmesser: 2.8cm</div> <div></div> <div></div>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringEin sehr ergonomischer Stimulator, der direkt auf den Punkt kommt, um Sie vor Lust schreien zu lassen. Wir fügen noch ein Gleitmittel hinzu.
keywords
string
title
stringUltra P Stimulator und sein Gleitmittel
seotitle
stringUltra P Stimulator und sein Gleitmittel
seouri
stringultra-p-stimulator-und-sein-gleitmittel-schwarz
specifications
string
stylingtips
string
summary
stringEin sehr ergonomischer Stimulator, der direkt auf den Punkt kommt, um Sie vor Lust schreien zu lassen.<br />Wir fügen noch ein Gleitmittel hinzu.
title
stringUltra P Stimulator und sein Gleitmittel
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<div>Διεγέρτης Ultra P<br /><br />Το καμπυλωτό σχήμα του προσαρμόζεται τέλεια στο σώμα σας για πιο αποτελεσματική διέγερση. Η άκρη του έχει μια προεξοχή που θα διεγείρει τα πιο ευαίσθητα σημεία σας με πανηγυρικό τρόπο!</div> <div></div> <div></div> <div>Μπορείτε να το κρατήσετε από τη λαβή για να το περιστρέψετε για μια μοναδική εμπειρία διέγερσης! Η προεξοχή στο άκρο του υπερμασάζ σας επιτρέπει να διεγείρετε το περίνεο ταυτόχρονα με τον προστάτη για δεκαπλάσια απόλαυση.</div> <div></div> <div></div> <div></div> <div>Μπορείτε να κάνετε τον εαυτό σας να φτάσει στον απόλυτο οργασμό μόνος του ή να αφήσετε τον σύντροφό σας να το κάνει για εσάς. Η επιλογή είναι δική σας!</div> <div></div> <div></div> <div>Είναι κατασκευασμένο χωρίς φθαλικές ενώσεις, έρχεται σε σφραγισμένη σακούλα και είναι εύκαμπτο και απόλυτα αδιάβροχο.<br /><br />Συνολικό μήκος: 12cm<br />Εισαγόμενο μήκος: 11,5 cm<br />Διάμετρος: 2.8cm</div> <div></div> <div></div>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringΈνας εξαιρετικά εργονομικός διεγέρτης που θα φτάσει κατευθείαν στο σημείο και θα σας κάνει να ουρλιάξετε από ευχαρίστηση. Προσθέτουμε επίσης λιπαντικό.
keywords
string
title
stringΔιεγέρτης και λιπαντικό Ultra P
seotitle
stringΔιεγέρτης και λιπαντικό Ultra P
seouri
stringdiegerths-kai-lipantiko-ultra-p-mayro
specifications
string
stylingtips
string
summary
stringΈνας εξαιρετικά εργονομικός διεγέρτης που θα φτάσει κατευθείαν στο σημείο και θα σας κάνει να ουρλιάξετε από ευχαρίστηση.<br />Προσθέτουμε επίσης λιπαντικό.
title
stringΔιεγέρτης και λιπαντικό Ultra P
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<div>Ultra P Stimulator<br /><br />Its curved shape adapts perfectly to your body for more effective stimulation. The tip has a protuberance that will stimulate your most sensitive parts with brio!</div> <div></div> <div></div> <div>You can hold it by the handle to rotate it for unprecedented stimulation! The protuberance at the end of the ultra massager lets you stimulate the perineum at the same time as the prostate, for tenfold pleasure.</div> <div></div> <div></div> <div></div> <div>You can make yourself reach the ultimate orgasm alone, or let your partner do it for you. The choice is yours!</div> <div></div> <div></div> <div>It's made without phthalates, comes in a sealed bag, is flexible and totally waterproof.<br /><br />Total length: 12cm<br />Insertable length: 11.5cm<br />Diameter: 2.8cm</div> <div></div> <div></div>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringA highly ergonomic stimulator that goes straight to the point and makes you howl with pleasure. We add lubricant.
keywords
string
title
stringUltra P Stimulator and lubricant
seotitle
stringUltra P Stimulator and lubricant
seouri
stringultra-p-stimulator-and-lubricant-black
specifications
string
stylingtips
string
summary
stringA highly ergonomic stimulator that goes straight to the point and makes you howl with pleasure.<br />We add lubricant.
title
stringUltra P Stimulator and lubricant
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<div>Estimulador Ultra P<br /><br />Su forma curvada se adapta perfectamente a tu cuerpo para una estimulación más eficaz. ¡La punta tiene una protuberancia que estimulará tus partes más sensibles con garbo!</div> <div></div> <div></div> <div>Puedes sujetarlo por el mango para girarlo y disfrutar de una experiencia de estimulación única La protuberancia del extremo del ultra masajeador te permite estimular el perineo al mismo tiempo que la próstata para un placer multiplicado por diez.</div> <div></div> <div></div> <div></div> <div>Podrás alcanzar el orgasmo definitivo tú sola o dejar que tu pareja lo haga por ti. ¡Tú eliges!</div> <div></div> <div></div> <div>Está fabricado sin ftalatos, viene en una bolsa sellada y es flexible y totalmente impermeable.<br /><br />Longitud total: 12 cm<br />Longitud insertable: 11,5 cm<br />Diámetro: 2,8 cm</div> <div></div> <div></div>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringUn estimulador muy ergonómico que irá directo al grano y te hará aullar de placer. También añadimos lubricante.
keywords
string
title
stringUltra P Estimulador y lubricante
seotitle
stringUltra P Estimulador y lubricante
seouri
stringultra-p-estimulador-y-lubricante-negro
specifications
string
stylingtips
string
summary
stringUn estimulador muy ergonómico que irá directo al grano y te hará aullar de placer.<br />También añadimos lubricante.
title
stringUltra P Estimulador y lubricante
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<div>Stimulateur Ultra P<br><br>Sa forme incurv&eacute;e s'adapte parfaitement a votre corps pour une stimulation plus performante. Le bout de ce dernier poss&egrave;de une protub&eacute;rance qui stimulera vos parties les plus sensibles avec brio !</div> <div>&nbsp;</div> <div>&nbsp;</div> <div>Vous pourrez le tenir par sa poign&eacute;e pour le faire pivoter et ainsi provoquer une stimulation in&eacute;dite ! La protub&eacute;rance a l'extr&eacute;mit&eacute; de l'ultra massager vous permet une stimulation du p&eacute;rin&eacute;e en m&ecirc;me temps que la stimulation prostatique pour un plaisir d&eacute;cupl&eacute;.</div> <div>&nbsp;</div> <div>&nbsp;</div> <div>&nbsp;</div> <div>Vous pourrez vous faire atteindre l'orgasme ultime seul ou bien laissez votre partenaire le faire pour vous. C'est &agrave; vous de choisir !</div> <div>&nbsp;</div> <div>&nbsp;</div> <div>Il est fabriqu&eacute; sans phtalates, pr&eacute;sent&eacute; dans un sachet scell&eacute;, il est flexible et totalement &eacute;tanche.<br><br>Longueur totale: 12cm<br>Longueur ins&eacute;rable: 11.5cm<br>Diam&egrave;tre: 2.8cm</div> <div>&nbsp;</div> <div>&nbsp;</div>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringUn stimulateur très ergonomique, qui ira droit au but pour vous faire hurler de plaisir. Nous y rajoutons on lubrifiant.
keywords
string
title
stringStimulateur Ultra P et son lubrifiant
seotitle
stringStimulateur Ultra P et son lubrifiant
seouri
stringstimulateur-ultra-p-et-son-lubrifiant-noir
specifications
string
stylingtips
string
summary
string<p>Un stimulateur tr&egrave;s ergonomique, qui ira droit au but pour vous faire hurler de plaisir.<br>Nous y rajoutons on lubrifiant.</p>
title
stringStimulateur Ultra P et son lubrifiant
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<div>Stimolatore Ultra P<br /><br />La sua forma curva si adatta perfettamente al vostro corpo per una stimolazione più efficace. La punta ha una protuberanza che stimolerà le vostre parti più sensibili con brio!</div> <div></div> <div></div> <div>Potete tenerlo per l'impugnatura e ruotarlo per un'esperienza di stimolazione unica! La protuberanza all'estremità dell'ultra massaggiatore consente di stimolare il perineo contemporaneamente alla prostata per un piacere decuplicato.</div> <div></div> <div></div> <div></div> <div>Potete raggiungere l'orgasmo finale da soli o lasciare che il vostro partner lo faccia per voi. La scelta è vostra!</div> <div></div> <div></div> <div>È realizzato senza ftalati, viene fornito in un sacchetto sigillato ed è flessibile e totalmente impermeabile.<br /><br />Lunghezza totale: 12 cm<br />Lunghezza inseribile: 11,5 cm<br />Diametro: 2,8 cm</div> <div></div> <div></div>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringUno stimolatore altamente ergonomico che andrà dritto al punto e vi farà ululare di piacere. Aggiungiamo anche del lubrificante.
keywords
string
title
stringStimolatore e lubrificante Ultra P
seotitle
stringStimolatore e lubrificante Ultra P
seouri
stringstimolatore-e-lubrificante-ultra-p-nero
specifications
string
stylingtips
string
summary
stringUno stimolatore altamente ergonomico che andrà dritto al punto e vi farà ululare di piacere.<br />Aggiungiamo anche del lubrificante.
title
stringStimolatore e lubrificante Ultra P
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<div>Ultra P Stimulator<br /><br />De gebogen vorm past zich perfect aan je lichaam aan voor effectievere stimulatie. Het uiteinde heeft een uitsteeksel dat je meest gevoelige delen met zwier stimuleert!</div> <div></div> <div></div> <div>Je kunt hem bij het handvat vasthouden om hem te draaien voor een unieke stimulatie-ervaring! Met het uitsteeksel aan het uiteinde van de ultra stimulator kun je tegelijkertijd het perineum en de prostaat stimuleren voor tienvoudig genot.</div> <div></div> <div></div> <div></div> <div>Je kunt jezelf alleen tot het ultieme orgasme brengen of het je partner laten doen. De keuze is aan jou!</div> <div></div> <div></div> <div>Het is gemaakt zonder ftalaten, wordt geleverd in een verzegeld zakje en is flexibel en volledig waterdicht.<br /><br />Totale lengte: 12cm<br />Inbrengbare lengte: 11.5cm<br />Diameter: 2.8cm</div> <div></div> <div></div>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringEen zeer ergonomische stimulator die meteen ter zake komt en je laat huilen van genot. We voegen ook glijmiddel toe.
keywords
string
title
stringUltra P Stimulator en glijmiddel
seotitle
stringUltra P Stimulator en glijmiddel
seouri
stringultra-p-stimulator-en-glijmiddel-zwart
specifications
string
stylingtips
string
summary
stringEen zeer ergonomische stimulator die meteen ter zake komt en je laat gillen van genot.<br />We voegen ook glijmiddel toe.
title
stringUltra P Stimulator en glijmiddel
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<div>Estimulador Ultra P<br /><br />A sua forma curva adapta-se perfeitamente ao seu corpo para uma estimulação mais eficaz. A ponta tem uma protuberância que estimulará as suas partes mais sensíveis com elegância!</div> <div></div> <div></div> <div>Pode segurá-lo pela pega para o rodar e ter uma experiência de estimulação única! A protuberância na extremidade do ultra massajador permite-lhe estimular o períneo ao mesmo tempo que a próstata para um prazer dez vezes maior.</div> <div></div> <div></div> <div></div> <div>Pode atingir o orgasmo máximo sozinha ou deixar que o seu parceiro o faça por si. A escolha é sua!</div> <div></div> <div></div> <div>É feito sem ftalatos, vem num saco selado e é flexível e totalmente à prova de água.<br /><br />Comprimento total: 12cm<br />Comprimento inserível: 11,5cm<br />Diâmetro: 2,8cm</div> <div></div> <div></div>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringUm estimulador altamente ergonómico que vai direto ao assunto e a fará uivar de prazer. Também adicionamos lubrificante.
keywords
string
title
stringEstimulador e lubrificante Ultra P
seotitle
stringEstimulador e lubrificante Ultra P
seouri
stringestimulador-e-lubrificante-ultra-p-preto
specifications
string
stylingtips
string
summary
stringUm estimulador altamente ergonómico que vai direto ao assunto e a fará uivar de prazer.<br />Também adicionamos lubrificante.
title
stringEstimulador e lubrificante Ultra P
usageinstructions
string
name
stringOHMAMA PLUG ANAL CON ANILLA 11.5 CM
netweight
string
nextshipment
stringtoday
ordered
number4
orderidx
number0
origin
string
originalsize
string
packaging
number0
productshipment
stringauto
productuid
string253EC979-6299-45C8-BE585F1593F74ED9
promountil
string
rating
stringnone
recorduid
string253EC979-6299-45C8-BE585F1593F74ED9
reference
stringSLPS9836
related
string
reserved
number0
returned
number0
returnsallowed
number1
section
stringwellbeing
shipment
string2to3days
showbrand
number0
sizeinfos
Query
Template: /system/api/product/sizes.cfc:20
Execution Time: 1.72 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 = '253EC979-6299-45C8-BE585F1593F74ED9'
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
number1
stocks
Query
Template: /system/api/product/stocks.cfc:25
Execution Time: 3.69 ms
Record Count: 1
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select * from (
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '253EC979-6299-45C8-BE585F1593F74ED9'
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
1253EC979-6299-45C8-BE585F1593F74ED9A5E2B237-2C45-4835-AEB2506506CBD7E0471black#000000nananananadefaultnaintlsize14.1250STOCK01100-10400843556593262611all
subcategory
stringpenetrate
supplier
number-1
supplierreference
stringD-229792
tags
string
themes
stringbadgirl
totalvariations
number1
type
stringdefault
unitprice
number14.125
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 3.81 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 = '253EC979-6299-45C8-BE585F1593F74ED9' 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 = '253EC979-6299-45C8-BE585F1593F74ED9' 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 = '253EC979-6299-45C8-BE585F1593F74ED9' 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 = '253EC979-6299-45C8-BE585F1593F74ED9' 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 = '253EC979-6299-45C8-BE585F1593F74ED9' 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 = '253EC979-6299-45C8-BE585F1593F74ED9' 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 = '253EC979-6299-45C8-BE585F1593F74ED9'
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
1A5E2B237-2C45-4835-AEB2506506CBD7E0471black#000000nananananadefaultnaintlsize14.1250STOCK01100-10400843556593262611-11-11014.125all
vatrate
number20
warehouse
number1