Mein Warenkorb

❌
Gesamtartikel
Zum Warenkorb
Menü
Siehe Größen
Überraschungstasche Plaisir Anal
Doppelklicken Sie zum Vergrößern
SKU: PSBA8015
Überraschungstasche Plaisir Anal
Lager:

Möchten Sie anale Lust ausprobieren?

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

Überraschungstüte Plaisir Anal

Produktbeschreibung

Unser Überraschungspaket für anale Freuden enthält alles, was Sie brauchen, um sich selbst oder Ihren Partner in verbotene Freuden einzuführen.

Hier ist eine kleine Liste, die keinen Anspruch auf Vollständigkeit erhebt:

-einen speziellen Fingerhut für anale Stimulation, den Sie auf Ihren Finger stecken können, um das Spiel sanft zu beginnen
-ein Analplug aus Silikon
-eine Portion Analgleitmittel, um das Eindringen zu erleichtern
-eine Analkette, um noch einen Schritt weiter zu gehen
-ein Black Hole Dosette für eine einfache Dehnung
Und noch ein paar Kleinigkeiten, die Sie begeistern werden.

Pflegehinweise

  • Vor und nach jedem Gebrauch gründlich mit antibakterieller Seife speziell für Sextoys reinigen
  • Reichlich mit lauwarmem Wasser abspülen, ohne elektronische Teile einzutauchen
  • Vor der Lagerung vollständig mit einem sauberen, fusselfreien Tuch trocknen
  • An einem trockenen Ort, fern von Hitze und direktem Licht aufbewahren
  • Spielzeuge aus verschiedenen Materialien getrennt aufbewahren, um chemische Wechselwirkungen zu vermeiden
  • Batteriebetriebene Spielzeuge regelmäßig aufladen, auch bei längerer Nichtbenutzung
  • Regelmäßig den allgemeinen Zustand überprüfen, um eine sichere und hygienische Verwendung zu gewährleisten
To Top
Zum Warenkorb
Artikel
Gesamtartikel
Struct
Entries: 108
actions
Array
available
number-1
brand
stringdivastoys
brandcode
stringdmxd
branding
stringdivasboudoir,smboudoir
brandmedias
string{"default":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"editorial":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"logo":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""}}
brandmetas
Struct
de
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
el
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
en
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
es
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
fr
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
it
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
nl
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
pt
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
brandname
stringDiva's Toys
breasts
stringna
careinstructions
stringsextoys
categories
stringdivasboudoir.wellbeing.packs.pleasure
category
stringpacks
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
Execution Time: 0 ms
Record Count: 0
Cached: No
Lazy: No
none
colorrange
string
colors
stringna
colortype
string
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 '2025-01-23 18:13:32'}
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
booleantrue
hascolorinfos
booleanfalse
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
number20.7917
itempromo
string
key
stringpochette-anal
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-11-04 15:52:59'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.709 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('c296709b-8a33-4944-b1b24cc2aaeca30e',lcase(cart_actions.linkedproducts)) > 0 and cart_actions.linkedproducts is not null
)
id_actionbrandinglanguagenamecodetypeminimumOrdermaximumOrderminimumItemsmaximumItemsmaximumUseallowedItemsquotasusedCountlinkedproductslinkedthemeslinkedbrandslinkeditemparamsactiveFromactiveToisActive
linkedproducts
Query
Template: /system/api/products.cfc:1305
Execution Time: 4.71 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 <> 'PSBA8015'
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
string5555
isprivate
string0
rating
stringall
src
string/photobank/products/dmxd/psba8015/santa-claus-carrying-sack-gifts-portrait-closeup.jpg
type
stringimg
width
string3844
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string2054
isprivate
string0
rating
stringall
src
string/photobank/products/dmxd/psba8015/bel005blkosx.jpg
type
stringimg
width
string1421
variations
Struct
colors
Struct
na
Struct
height
string2054
isprivate
string0
rating
stringall
src
string/photobank/products/dmxd/psba8015/bel005blkosx.jpg
type
stringimg
width
string1421
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
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
divasboudoir
Struct
de
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringUnser Überraschungspaket für anale Freuden enthält alles, was Sie brauchen, um sich selbst oder Ihren Partner in verbotene Freuden einzuführen.<br /><br />Hier ist eine kleine Liste, die keinen Anspruch auf Vollständigkeit erhebt:<br /><br />-einen speziellen Fingerhut für anale Stimulation, den Sie auf Ihren Finger stecken können, um das Spiel sanft zu beginnen<br />-ein Analplug aus Silikon<br />-eine Portion Analgleitmittel, um das Eindringen zu erleichtern<br />-eine Analkette, um noch einen Schritt weiter zu gehen<br />-ein Black Hole Dosette für eine einfache Dehnung<br />Und noch ein paar Kleinigkeiten, die Sie begeistern werden.
guid
stringhttps://dev.divasboudoir.com/de/uberraschungstute-plaisir-anal/psba8015.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringMöchten Sie verbotene Freuden ausprobieren? Mit diesem preisgünstigen Anal-Stimulationsset können Sie sanft, aber bestimmt beginnen. Diskreter Versand.
keywords
string
title
stringAnales Stimulationsset - Beginnen Sie sanft.
seotitle
stringÜberraschungstüte Plaisir Anal
seouri
stringuberraschungstute-plaisir-anal
specifications
string
stylingtips
string
summary
stringMöchten Sie anale Lust ausprobieren?
title
stringÜberraschungstasche Plaisir Anal
usageinstructions
string
el
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringΤο ειδικό πακέτο έκπληξη για την πρωκτική απόλαυση περιέχει όλα όσα χρειάζεστε για να εισαγάγετε τον εαυτό σας ή τον σύντροφό σας στις απαγορευμένες απολαύσεις.<br /><br />Ακολουθεί ένας σύντομος, αλλά όχι εξαντλητικός, κατάλογος των περιεχομένων του:<br /><br />-μια ειδική πρωκτική δαχτυλήθρα για να την τοποθετήσετε στο δάχτυλό σας για να ξεκινήσετε το παιχνίδι απαλά<br />-ένα πρωκτικό βύσμα σιλικόνης<br />-ένα δοχείο πρωκτικού λιπαντικού για να διευκολύνετε τη διείσδυση<br />-μια πρωκτική αλυσίδα για να προχωρήσουν τα πράγματα λίγο παραπέρα<br />-μια κάψουλα μαύρης τρύπας για εύκολη διαστολή<br />Και μερικά άλλα πράγματα που θα σας ενθουσιάσουν.
guid
stringhttps://dev.divasboudoir.com/el/paketo-ekplhxh-prwktikhs-eycharisthshs/psba8015.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringΘέλετε να δοκιμάσετε μερικές απαγορευμένες απολαύσεις Αυτό το σετ πρωκτικής διέγερσης χαμηλού κόστους θα σας κάνει να ξεκινήσετε απαλά αλλά σταθερά. Διακριτική παράδοση.
keywords
string
title
stringΣετ πρωκτικής διέγερσης - Ξεκινήστε απαλά.
seotitle
stringΠακέτο έκπληξη πρωκτικής ευχαρίστησης
seouri
stringpaketo-ekplhxh-prwktikhs-eycharisthshs
specifications
string
stylingtips
string
summary
stringΘέλετε να δοκιμάσετε την πρωκτική απόλαυση
title
stringΣακουλάκι έκπληξη πρωκτικής ευχαρίστησης
usageinstructions
string
en
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringOur anal pleasure surprise pack includes everything you need to introduce yourself or your partner to forbidden pleasures.<br /><br />Here's a short, non-exhaustive list of what's inside:<br /><br />-a special anal thimble to place on your finger for a gentle start to the game<br />-a silicone anal plug<br />-a pod of anal lubricant to facilitate penetration<br />-an anal chain to take things a little further<br />-a black hole pod for easy dilation<br />And a few more things to delight you.
guid
stringhttps://dev.divasboudoir.com/en/plaisir-anal-surprise-pack/psba8015.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringFancy trying out some forbidden pleasures? This low-cost anal stimulation kit will get you started gently but firmly. Discreet delivery.
keywords
string
title
stringAnal stimulation kit - Start gently.
seotitle
stringPlaisir Anal surprise pack
seouri
stringplaisir-anal-surprise-pack
specifications
string
stylingtips
string
summary
stringWant to try anal pleasure?
title
stringAnal Pleasure Surprise Pouch
usageinstructions
string
es
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringNuestro paquete sorpresa especial para el placer anal contiene todo lo que necesita para iniciarse o iniciar a su pareja en los placeres prohibidos.<br /><br />He aquí una lista breve, pero no exhaustiva, de lo que contiene:<br /><br />-un dedal anal especial para colocar en el dedo e iniciar el juego suavemente<br />-un plug anal de silicona<br />-una bolsita de lubricante anal para facilitar la penetración<br />-una cadena anal para ir un poco más lejos<br />-una vaina de agujero negro para facilitar la dilatación<br />Y algunas cosas más que te encantarán.
guid
stringhttps://dev.divasboudoir.com/es/pack-sorpresa-placer-anal/psba8015.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string¿Te apetece probar algunos placeres prohibidos? Este kit de estimulación anal de bajo coste te permitirá iniciarte con suavidad pero con firmeza. Entrega discreta.
keywords
string
title
stringKit de estimulación anal - Empieza suavemente.
seotitle
stringPack sorpresa Placer anal
seouri
stringpack-sorpresa-placer-anal
specifications
string
stylingtips
string
summary
string¿Quieres probar el placer anal?
title
stringBolsa Sorpresa Placer Anal
usageinstructions
string
fr
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>Notre pochette surprise sp&eacute;cial plaisir anal comprend tout ce dont vous avez besoin pour vous initier, ou initier votre partenaire, aux plaisirs interdits.</p>
guid
stringhttps://dev.divasboudoir.com/fr/pochette-surprise-plaisir-anal/psba8015.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringEnvie d'essayer les plaisirs interdits? Ce kit de stimulation anale à petit prix saura vous faire débuter tout en douceur mais avec fermeté. Envoi discret.
keywords
string
title
stringKit de stimulation anale - Commencez en douceur.
seotitle
stringPochette surprise Plaisir Anal
seouri
stringpochette-surprise-plaisir-anal
specifications
string
stylingtips
string
summary
string<p>Envie d'essayer le plaisir anal?</p>
title
stringPochette Surprise Plaisir Anal
usageinstructions
string
it
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringIl nostro speciale pacchetto sorpresa del piacere anale contiene tutto il necessario per introdurre voi stessi o il vostro partner ai piaceri proibiti.<br /><br />Ecco un breve, ma non esaustivo, elenco di ciò che contiene:<br /><br />-uno speciale ditale anale da posizionare sul dito per iniziare il gioco con delicatezza<br />-un plug anale in silicone<br />-una capsula di lubrificante anale per facilitare la penetrazione<br />-una catena anale per andare un po' oltre<br />-una capsula per il buco nero per facilitare la dilatazione<br />E alcune altre cose che vi delizieranno.
guid
stringhttps://dev.divasboudoir.com/it/pacchetto-sorpresa-piacere-anale/psba8015.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringVolete provare qualche piacere proibito? Questo kit di stimolazione anale a basso costo vi farà iniziare in modo delicato ma deciso. Consegna discreta.
keywords
string
title
stringKit per la stimolazione anale - Iniziare delicatamente.
seotitle
stringPacchetto sorpresa Piacere Anale
seouri
stringpacchetto-sorpresa-piacere-anale
specifications
string
stylingtips
string
summary
stringVolete provare il piacere anale?
title
stringSacchetto a sorpresa per il piacere anale
usageinstructions
string
nl
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringOns speciale anaal plezier verrassingspakket bevat alles wat je nodig hebt om jezelf of je partner kennis te laten maken met verboden pleziertjes.<br /><br />Hier is een korte, maar niet volledige lijst van wat het bevat:<br /><br />-een speciale anale vingerhoed om op je vinger te leggen om het spel zachtjes te beginnen<br />-een siliconen anaalplug<br />-een pod met anaal glijmiddel om de penetratie te vergemakkelijken<br />-een anaalketting om nog iets verder te gaan<br />-een black hole pod voor gemakkelijke verwijding<br />En nog een paar andere dingen die je zullen plezieren.
guid
stringhttps://dev.divasboudoir.com/nl/anaal-pleasure-verrassingspakket/psba8015.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringZin om wat verboden pleziertjes uit te proberen? Deze voordelige set voor anale stimulatie helpt je zachtjes maar vastberaden op weg. Discrete levering.
keywords
string
title
stringKit voor anale stimulatie - Begin voorzichtig.
seotitle
stringAnaal Pleasure verrassingspakket
seouri
stringanaal-pleasure-verrassingspakket
specifications
string
stylingtips
string
summary
stringWil je anaal plezier proberen?
title
stringVerrassingszakje voor anaal plezier
usageinstructions
string
pt
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringO nosso pacote surpresa especial de prazer anal contém tudo o que precisa para se apresentar a si ou ao seu parceiro aos prazeres proibidos.<br /><br />Aqui está uma lista curta, mas não exaustiva, do que contém:<br /><br />-um dedal anal especial para colocar no seu dedo e começar o jogo suavemente<br />-um plug anal de silicone<br />-uma cápsula de lubrificante anal para facilitar a penetração<br />-uma corrente anal para levar as coisas um pouco mais longe<br />-uma cápsula de buraco negro para facilitar a dilatação<br />E algumas outras coisas que te vão deliciar.
guid
stringhttps://dev.divasboudoir.com/pt/pacote-surpresa-anal-pleasure/psba8015.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringApetece-lhe experimentar alguns prazeres proibidos? Este kit de estimulação anal de baixo custo vai ajudá-lo a começar de forma suave mas firme. Entrega discreta.
keywords
string
title
stringKit de estimulação anal - Comece suavemente.
seotitle
stringPacote surpresa Anal Pleasure
seouri
stringpacote-surpresa-anal-pleasure
specifications
string
stylingtips
string
summary
stringQuer experimentar o prazer anal?
title
stringBolsa Surpresa Anal Pleasure
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
stringUnser Überraschungspaket für anale Freuden enthält alles, was Sie brauchen, um sich selbst oder Ihren Partner in verbotene Freuden einzuführen.<br /><br />Hier ist eine kleine Liste, die keinen Anspruch auf Vollständigkeit erhebt:<br /><br />-einen speziellen Fingerhut für anale Stimulation, den Sie auf Ihren Finger stecken können, um das Spiel sanft zu beginnen<br />-ein Analplug aus Silikon<br />-eine Portion Analgleitmittel, um das Eindringen zu erleichtern<br />-eine Analkette, um noch einen Schritt weiter zu gehen<br />-ein Black Hole Dosette für eine einfache Dehnung<br />Und noch ein paar Kleinigkeiten, die Sie begeistern werden.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringMöchten Sie verbotene Freuden ausprobieren? Mit diesem preisgünstigen Anal-Stimulationsset können Sie sanft, aber bestimmt beginnen. The BDSM Boudoir.
keywords
string
title
stringAnales Stimulationsset - The BDSM Boudoir
seotitle
stringAnales Vergnügen - The BDSM Boudoir
seouri
stringuberraschungstute-plaisir-anal
specifications
string
stylingtips
string
summary
stringMöchten Sie anale Lust ausprobieren?
title
stringÜberraschungstasche Plaisir Anal
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringΤο ειδικό πακέτο έκπληξη για την πρωκτική απόλαυση περιέχει όλα όσα χρειάζεστε για να εισαγάγετε τον εαυτό σας ή τον σύντροφό σας στις απαγορευμένες απολαύσεις.<br /><br />Ακολουθεί ένας σύντομος, αλλά όχι εξαντλητικός, κατάλογος των περιεχομένων του:<br /><br />-μια ειδική πρωκτική δαχτυλήθρα για να την τοποθετήσετε στο δάχτυλό σας για να ξεκινήσετε το παιχνίδι απαλά<br />-ένα πρωκτικό βύσμα σιλικόνης<br />-ένα δοχείο πρωκτικού λιπαντικού για να διευκολύνετε τη διείσδυση<br />-μια πρωκτική αλυσίδα για να προχωρήσουν τα πράγματα λίγο παραπέρα<br />-μια κάψουλα μαύρης τρύπας για εύκολη διαστολή<br />Και μερικά άλλα πράγματα που θα σας ενθουσιάσουν.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringΘέλετε να δοκιμάσετε μερικές απαγορευμένες απολαύσεις Αυτό το σετ πρωκτικής διέγερσης χαμηλού κόστους θα σας κάνει να ξεκινήσετε απαλά αλλά σταθερά. Το Bdsm Boudoir.
keywords
string
title
stringΣετ πρωκτικής διέγερσης - The Bdsm Boudoir
seotitle
stringΠακέτο έκπληξη Plaisir Anal - Το Bdsm Μπουντουάρ
seouri
stringpaketo-ekplhxh-prwktikhs-eycharisthshs
specifications
string
stylingtips
string
summary
stringΘέλετε να δοκιμάσετε την πρωκτική απόλαυση
title
stringΣακουλάκι έκπληξη πρωκτικής ευχαρίστησης
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringOur anal pleasure surprise pack includes everything you need to introduce yourself or your partner to forbidden pleasures.<br /><br />Here's a short, non-exhaustive list of what's inside:<br /><br />-a special anal thimble to place on your finger for a gentle start to the game<br />-a silicone anal plug<br />-a pod of anal lubricant to facilitate penetration<br />-an anal chain to take things a little further<br />-a black hole pod for easy dilation<br />And a few more things to delight you.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringFancy trying out some forbidden pleasures? This low-priced anal stimulation kit will get you started, gently but firmly. The BDSM Boudoir.
keywords
string
title
stringAnal stimulation kit - The BDSM Boudoir
seotitle
stringPlaisir Anal surprise pack - The BDSM Boudoir
seouri
stringplaisir-anal-surprise-pack
specifications
string
stylingtips
string
summary
stringWant to try anal pleasure?
title
stringAnal Pleasure Surprise Pouch
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringNuestro paquete sorpresa especial para el placer anal contiene todo lo que necesita para iniciarse o iniciar a su pareja en los placeres prohibidos.<br /><br />He aquí una lista breve, pero no exhaustiva, de lo que contiene:<br /><br />-un dedal anal especial para colocar en el dedo e iniciar el juego suavemente<br />-un plug anal de silicona<br />-una bolsita de lubricante anal para facilitar la penetración<br />-una cadena anal para ir un poco más lejos<br />-una vaina de agujero negro para facilitar la dilatación<br />Y algunas cosas más que te encantarán.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string¿Te apetece probar algunos placeres prohibidos? Este kit de estimulación anal de bajo coste te hará empezar con suavidad pero con firmeza. The BDSM Boudoir.
keywords
string
title
stringKit de estimulación anal - The BDSM Boudoir
seotitle
stringPlaisir Anal pack sorpresa - The BDSM Boudoir
seouri
stringpack-sorpresa-placer-anal
specifications
string
stylingtips
string
summary
string¿Quieres probar el placer anal?
title
stringBolsa Sorpresa Placer Anal
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Notre pochette surprise sp&eacute;cial plaisir anal comprend tout ce dont vous avez besoin pour vous initier, ou initier votre partenaire, aux plaisirs interdits.</p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringEnvie d'essayer les plaisirs interdits? Ce kit de stimulation anale à petit prix saura vous faire débuter tout en douceur mais avec fermeté. The Bdsm Boudoir.
keywords
string
title
stringKit de stimulation anale - The Bdsm Boudoir
seotitle
stringPochette surprise Plaisir Anal - The Bdsm Boudoir
seouri
stringpochette-surprise-plaisir-anal
specifications
string
stylingtips
string
summary
string<p>Envie d'essayer le plaisir anal?</p>
title
stringPochette Surprise Plaisir Anal
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringIl nostro speciale pacchetto sorpresa del piacere anale contiene tutto il necessario per introdurre voi stessi o il vostro partner ai piaceri proibiti.<br /><br />Ecco un breve, ma non esaustivo, elenco di ciò che contiene:<br /><br />-uno speciale ditale anale da posizionare sul dito per iniziare il gioco con delicatezza<br />-un plug anale in silicone<br />-una capsula di lubrificante anale per facilitare la penetrazione<br />-una catena anale per andare un po' oltre<br />-una capsula per il buco nero per facilitare la dilatazione<br />E alcune altre cose che vi delizieranno.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringVolete provare qualche piacere proibito? Questo kit di stimolazione anale a basso costo vi farà iniziare in modo delicato ma deciso. The BDSM Boudoir.
keywords
string
title
stringKit di stimolazione anale - The BDSM Boudoir
seotitle
stringPacchetto sorpresa Plaisir Anal - The BDSM Boudoir
seouri
stringpacchetto-sorpresa-piacere-anale
specifications
string
stylingtips
string
summary
stringVolete provare il piacere anale?
title
stringSacchetto a sorpresa per il piacere anale
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Ons speciale anaal plezier verrassingspakket bevat alles wat je nodig hebt om jezelf of je partner kennis te laten maken met verboden pleziertjes.<br><br>Hier is een korte, maar niet volledige lijst van wat het bevat:<br><br>-een speciale anale vingerhoed om op je vinger te leggen om het spel zachtjes te beginnen<br>-een siliconen anaalplug<br>-een pod met anaal glijmiddel om de penetratie te vergemakkelijken<br>-een anaalketting om nog iets verder te gaan<br>-een black hole pod voor gemakkelijke verwijding<br>En nog een paar andere dingen die je zullen plezieren.</p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringZin om wat verboden pleziertjes uit te proberen? Met deze voordelige anale stimulatieset kun je voorzichtig maar vastberaden aan de slag. The BDSM Boudoir.
keywords
string
title
stringKit voor anale stimulatie - The BDSM Boudoir
seotitle
stringPlaisir Anaal verrassingspakket - The BDSM Boudoir
seouri
stringanaal-pleasure-verrassingspakket
specifications
string
stylingtips
string
summary
string<p>Wil je anaal plezier proberen?</p>
title
stringVerrassingszakje voor anaal plezier
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringO nosso pacote surpresa especial de prazer anal contém tudo o que precisa para se apresentar a si ou ao seu parceiro aos prazeres proibidos.<br /><br />Aqui está uma lista curta, mas não exaustiva, do que contém:<br /><br />-um dedal anal especial para colocar no seu dedo e começar o jogo suavemente<br />-um plug anal de silicone<br />-uma cápsula de lubrificante anal para facilitar a penetração<br />-uma corrente anal para levar as coisas um pouco mais longe<br />-uma cápsula de buraco negro para facilitar a dilatação<br />E algumas outras coisas que te vão deliciar.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringApetece-lhe experimentar alguns prazeres proibidos? Este kit de estimulação anal de baixo custo vai ajudá-lo a começar de forma suave mas firme. O Boudoir Bdsm.
keywords
string
title
stringKit de estimulação anal - The Bdsm Boudoir
seotitle
stringPacote surpresa Plaisir Anal - The Bdsm Boudoir
seouri
stringpacote-surpresa-anal-pleasure
specifications
string
stylingtips
string
summary
stringQuer experimentar o prazer anal?
title
stringBolsa Surpresa Anal Pleasure
usageinstructions
string
name
stringpochette anal
netweight
string
nextshipment
stringtoday
ordered
number19
orderidx
number0
origin
string
originalsize
string
packaging
number0
productshipment
stringauto
productuid
stringC296709B-8A33-4944-B1B24CC2AAECA30E
promountil
string
rating
stringnone
recorduid
stringC296709B-8A33-4944-B1B24CC2AAECA30E
reference
stringPSBA8015
related
string
reserved
number0
returned
number0
returnsallowed
number1
section
stringwellbeing
shipment
string1to2days
showbrand
number0
sizeinfos
Query
Template: /system/api/product/sizes.cfc:20
Execution Time: 2.14 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 = 'C296709B-8A33-4944-B1B24CC2AAECA30E'
and intlsize <> 'na'
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_sizes.id_size, product_variations.color
order by FIELD(product_sizes.gender,'w','m'), product_sizes.sizegroup, FIELD(intlsize,'XS','S','S/M','S-M','M','M/L','M-L','L','L-XL','L/XL','XL','0X','0XL','lXL','1X','1X-2X','1X/2X','XL/2XL','XL-2XL','1XL-2XL','2XL','2X','XXL','2X-3X','2X/3X','2XL-3XL','2XL/3XL','XXXL','3XL','3X','3X-4X','3X/4X','3XL-4XL','3XL/4XL','4XL','5XL','5X','5X-6X','5X/6X','5XL-6XL','5XL/6XL','6XL','6X','7XL','7X','8XL','8X'), cast(intlsize as SIGNED ), groupavailable desc, stock desc
recorduidsizesizetypecolorparam1param2availablegroupavailablestockgendersizerangesizegroupsuppliersizeintlsizeincheseusizeussizeuksizefrsizeessizedesizeitsizeptsizeelsizebustwaisthipunderbustcupthighlegheightbodyheightbodyweight
sizeranges
stringplus
sizes
string471
sizetype
stringauto
specifications
Struct
Entries: 23
belly
string
bones
string
bra
string
breasts
string
bust
string
closing
string
crochtless
string
cups
string
cut
string
garter
string
halter
string
lacing
string
lining
string
modestypanel
string
panty
string
sheathing
string
sleeves
string
stocking
string
straps
string
stretch
string
suspenders
string
transparency
string
underwires
string
stock
number0
stocks
Query
Template: /system/api/product/stocks.cfc:25
Execution Time: 2.07 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 = 'C296709B-8A33-4944-B1B24CC2AAECA30E'
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
1C296709B-8A33-4944-B1B24CC2AAECA30E1EAB3355-D899-4C75-8D69F69F1FEB788A471nanananananadefaultnaintlsize20.79170STOCK01000-101900-10all
subcategory
stringpleasure
supplier
number-1
supplierreference
string
tags
string
themes
stringreadyforvalentine
totalvariations
number1
type
stringdefault
unitprice
number20.7917
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 8.27 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 = 'C296709B-8A33-4944-B1B24CC2AAECA30E' 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 = 'C296709B-8A33-4944-B1B24CC2AAECA30E' 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 = 'C296709B-8A33-4944-B1B24CC2AAECA30E' 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 = 'C296709B-8A33-4944-B1B24CC2AAECA30E' 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 = 'C296709B-8A33-4944-B1B24CC2AAECA30E' 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 = 'C296709B-8A33-4944-B1B24CC2AAECA30E' 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 = 'C296709B-8A33-4944-B1B24CC2AAECA30E'
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
11EAB3355-D899-4C75-8D69F69F1FEB788A471nanananananadefaultnaintlsize20.79170STOCK01000-101900-10-10-10020.7917all
vatrate
number20
warehouse
number0