Mijn mand

❌
Totaal aantal items
Winkelmand bekijken
Menu
Maten bekijken
Oops slipje: Schandalig sexy kant en vetersluiting
Dubbelklikken om te vergroten
SKU: SBBU4732
Oops slipje: Schandalig sexy kant en vetersluiting
Promo
Voorraad:

Ontdek de Oups slip, een schandalig open creatie van zwart kant die je van je meest gewaagde kant laat zien.

De prachtige vetersluiting op de rug en de opening in het kruis creëren een onweerstaanbaar effect voor momenten van pure verleiding.

Sterke punten

  • Ultra-sensueelall-over zwart kant
  • Schandalig ondeugendekruisopening
  • Schitterende opvallende vetersluiting achter
  • Verstelbare pasvorm om royale rondingen te verbeteren
  • Afgewerkt met verfijnde kanten details
  • Provocerende stijl die pronkt met je gedurfde houding
Maat:

Weet je niet zeker welke maat je moet kiezen? Raadpleeg onze maattabel

Kleur:
Hoeveelheid:
19.95 € 13.95 €
Goed advies
via chat, facebook of e-mail
Gratis retourneren
binnen 15 dagen *

Oups grote open kanten slip met vetersluiting op de rug

Productomschrijving

De Oups slip belichaamt de meest gedurfde verleiding, met volledig zwart kant dat speelt met transparantie om je huid subtiel te onthullen.

Deze schandalig open creatie verandert elk intiem moment in een ervaring van puur genot. Deopening in het kruis biedt directe toegang die de temperatuur doet stijgen, terwijl de prachtige vetersluiting aan de achterkant een absoluut boeiend visueel spel van verleiding creëert. Dit unieke detail is een natuurlijke blikvanger die je billen op een opwindende manier onthult.

Het kant met fijne patronen omhelst je royale rondingen perfect en past zich aan alle lichaamsvormen aan voor optimaal comfort, zelfs tijdens je meest intense momenten. De zorgvuldige afwerking maakt van Oops een echt onweerstaanbaar broekje.

Deze zwarte creatie is ontworpen om je meest authentieke sensualiteit te onthullen en van elk moment een moment van pure provocatie te maken.

Technische details

  • Materiaal: Kant (92% polyamide, 8% elastaan)
  • Stijl: Open slip met vetersluiting op de rug
  • Openingen: Kruis voor directe toegang
  • Onderhoud: Fijne handwas aanbevolen

Beschikbaar maten

Beschikbaar van L tot 3XL

Beschikbare kleuren

Zwart , Mauve en Wit

Samenstelling

Nylon 88 %
Spandex 12 %

Overige technische specificaties

Materiaal Elastische kant

Maattabel

Controleer de juiste maat voor jou

Internationale
  • Heupen
L
  • 102-107
XL
  • 107-112
2XL
  • 112-117
3XL
  • 117-123

Onderhoudstips

  • Handwas aanbevolen met milde zeep of delicate machinecyclus (max. 30°C) in een beschermend waszakje
  • Plat laten drogen in de schaduw, nooit in de droger
  • Strijken niet aanbevolen of op zeer lage temperatuur indien nodig
  • Plat bewaren op een droge plaats
  • Om de elasticiteit en ondersteuning van uw items te behouden (maten 42-64), wissel het dragen ervan af
  •  

Gebruikstips

Oups slips zijn ontworpen voor je meest ondeugende en uitdagende momenten. De opening in het kruis biedt directe toegang die elk intiem moment verandert in een ongehoord opwindende ervaring van puur genot.

De prachtige vetersluiting aan de achterkant zorgt voor een persoonlijke pasvorm en een opvallend visueel effect. Draag het met vertrouwen om je meest gewaagde kant te onthullen en zet de hitte aan met elke blik.

Stijltips

De Oups slips, met hun vetersluiting aan de achterkant, zijn alles wat je nodig hebt om een waanzinnig sexy look te creëren. Combineer ze met stukken die op subtiele wijze hun provocerende aanwezigheid onthullen voor extra verleiding. Deze zwarte creatie onthult je brutaliteit en ongebreidelde sensualiteit.

Maak je look compleet met onze open bodysuits voor totale verleiding, of voeg een negligé toe voor een geleidelijke aanpak die culmineert in de ontdekking van deze vreselijk opwindende slip.

To Top
Winkelmand bekijken
Artikelen
Totaal aantal items
Struct
Entries: 108
actions
Array
available
number-1
brand
stringparishollywood
brandcode
stringpuun
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
stringParis Hollywood
breasts
stringna
careinstructions
stringlace
categories
stringdivasboudoir.lingerie.briefs.openpanty
category
stringbriefs
categorygender
stringf
categorymediadatas
Struct
adult
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string287
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/lingerie/sexylingerie/openpanty.jpg
type
stringimg
width
string623
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 ms
Record Count: 3
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,purple,white') > 0
and product_variations.productuid = 'A03AC848-44CF-457E-95AD8E65FEFF3AF1'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1blackcolorblakblackblack#000000-117
2purplecolorpurppurplepurple#9400D4-12
3whitecolorwhitwhitewhite#FFFFFF-12
colorrange
stringblack
colors
stringblack,purple,white
colortype
stringcolor
comments
string
compositions
Struct
Entries: 13
coton
string
elastane
string
free
string
leather
string
lycra
string
metal
string
nylon
string88
polyamide
string
polyester
string
polyurethane
string
silk
string
spandex
string12
viscose
string
datecreated
Date Time (Europe/Paris)
{ts '2020-01-17 10:45:08'}
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
booleantrue
hascompositions
booleantrue
hasdescription
booleantrue
hasdimensions
booleanfalse
hasmaterials
booleantrue
hasotherspecifications
booleanfalse
haspromo
number1
hasshortdescription
booleantrue
hassizeinfos
booleantrue
hasspecifications
booleantrue
hasstockinfos
booleanfalse
hasstylingtips
booleantrue
hasusageinstructions
booleantrue
hasvariations
booleantrue
import
string
inpromo
number18
instockvariations
string
isactive
number1
iscustommade
number0
isdivasize
number0
isfirstprice
number0
isfixedprice
number0
ishot
number0
isnew
number0
isonline
number0
isoutletprice
number0
itemprice
number16.625
itempromo
number11.625
key
stringblack-p5179-1p-plus-size-open-crotch-floral-lace-panty-black
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-09-22 18:30:36'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.637 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','nl')
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('a03ac848-44cf-457e-95ad8e65feff3af1',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.3 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','nl')
and product_categories.language in ('all','nl')
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 <> 'SBBU4732'
group by products.reference
order by products.ishot desc, products.isnew desc, orderidx asc, products.lastupdated desc
productuidreferencetypekeylanguagenamelinkuidcolorsvatratemetadatasdimensionsmediadatastagsthemesisdivasizetotalvariationsvariationlistinpromohaspromoitempromoitempriceunitpricepricespromountilisfixedpriceishotisneworderidxavailablestockinstockvariationsbrandbrandnameshowbranddisplaysizetypeintlsizesizessizerangecategorymediadatascategorysizerangesectioncategorysubcategory
linkuid
string
materials
stringstretchlace
mediadatas
Struct
alt
Struct
height
string1150
isprivate
string0
rating
stringall
src
string/photobank/products/puun/sbbu4732/culotte_grande_taille_oups_mauve.jpg
type
stringimg
width
string795
back
Struct
height
string1320
isprivate
string0
rating
stringall
src
string/photobank/products/puun/sbbu4732/culotte_grande_taille_oups_blanche.jpg
type
stringimg
width
string913
default
Struct
height
string1897
isprivate
string0
rating
stringall
src
string/photobank/products/puun/sbbu4732/culotte_oups_noire_derriere.jpg
type
stringimg
width
string1312
variations
Struct
colors
Struct
black
Struct
height
string1897
isprivate
string0
rating
stringall
src
string/photobank/products/puun/sbbu4732/culotte_grande_taille_oups_noir.jpg
type
stringimg
width
string1312
purple
Struct
height
string1150
isprivate
string0
rating
stringall
src
string/photobank/products/puun/sbbu4732/culotte_grande_taille_oups_mauve.jpg
type
stringimg
width
string795
white
Struct
height
string1320
isprivate
string0
rating
stringall
src
string/photobank/products/puun/sbbu4732/culotte_grande_taille_oups_blanche.jpg
type
stringimg
width
string913
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<p>Der Oups-Slip verkörpert die <strong>kühnste</strong> Verführung mit seiner durchgehenden schwarzen Spitze, die mit Transparenz spielt, um Ihre Haut subtil zu enthüllen.</p> <p>Diese <strong>skandalös offene</strong> Kreation verwandelt jeden intimen Moment in ein Erlebnis puren Vergnügens. Die<strong>Öffnung im Schritt</strong> bietet einen direkten Zugang, der die Temperatur ansteigen lässt, während die <strong>wunderschöne hintere Schnürung</strong> ein absolut fesselndes Spiel der visuellen Verführung schafft. Dieses einzigartige Detail zieht natürlich die Blicke auf sich und enthüllt Ihren Po auf furchtbar erregende Weise.</p> <p>Die <strong>zart gemusterte Spitze</strong> schmiegt sich perfekt an Ihre üppigen Kurven an und passt sich jeder Körperform an, sodass Sie sich auch in den intensivsten Momenten wohlfühlen. Die <strong>sorgfältige Verarbeitung</strong> sorgt für den letzten Schliff, der Oups zu einem wirklich unwiderstehlichen Slip macht.</p> <p>Diese schwarze Kreation wurde entworfen, um Ihre <strong>authentische</strong> Sinnlichkeit zu enthüllen und jeden Moment in einen Moment der reinen, selbstbewussten Provokation zu verwandeln.</p>
guid
stringhttps://dev.divasboudoir.com/de/oups-slip-grosse-grosse-offen-schwarz-schwarz/sbbu4732.htm
highlights
string<ul> <li>Ultra-sinnliche<strong>schwarze integrale Spitze</strong> </li> <li>Skandalös freche<strong>Öffnung im Schritt</strong> </li> <li><strong>Wunderschöne Rückenschnürung</strong>, die alle Blicke auf sich zieht</li> <li><strong>Verstellbare Passform</strong>, die großzügige Kurven betont</li> <li><strong>Sorgfältige Verarbeitung</strong> mit raffinierten Spitzendetails</li> <li><strong>Provokanter Stil</strong>, der Ihre selbstbewusste Kühnheit offenbart</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringOups-Slip in großen Größen aus schwarzer Spitze mit rückseitiger Schnürung. Skandalös sexy Öffnung im Schritt. Gewagte, selbstbewusste Art. Diva's Boudoir.
keywords
string
title
stringOups-Slip große Größe hintere Schnürung | Diva's Boudoir
seotitle
stringOffenes Höschen große Größen Oups Spitze mit Schnürung hinten
seouri
stringoups-slip-grosse-grosse-offen-schwarz-schwarz
specifications
string<ul> <li><strong>Material:</strong> Spitze (92% Polyamid, 8% Elasthan)</li> <li><strong>Stil:</strong> Offenes Höschen mit rückseitiger Schnürung</li> <li><strong>Öffnungen:</strong> Im Schritt für direkten Zugang</li> <li><strong>Pflege:</strong> Schonende Handwäsche empfohlen</li> </ul>
stylingtips
string<p>Der Oups-Slip mit seiner <strong>rückwärtigen Schnürung</strong> ist selbsterklärend, um einen <strong>skandalös sexy</strong> Look zu kreieren. Um den verführerischen Effekt zu verstärken, kombinieren Sie ihn mit Teilen, die seine provokative Präsenz subtil offenbaren. Diese schwarze Kreation offenbart Ihre selbstbewusste Kühnheit und ungezügelte Sinnlichkeit.</p> <p>Vervollständigen Sie Ihren Look mit unseren <a href="https://www.divasboudoir.com/de/offener-body-in-grossen-grossen/"><strong>offenen Bodies</strong></a> für die totale Verführung, oder fügen Sie ein <a href="https://www.divasboudoir.com/de/neglige-in-grosse-grossen/"><strong>Neglig&eacute;</strong></a> hinzu für eine schrittweise Annäherung, die in der Entdeckung dieses furchtbar aufregenden Slips gipfelt.</p>
summary
string<p>Entdecken Sie den Oups-Slip, eine <strong>skandalös offene</strong> Kreation aus schwarzer Spitze, die Ihre <strong>kühnste</strong> Seite offenbart.</p> <p>Die <strong>wunderschöne hintere Schnürung</strong> und die <strong>Öffnung im Schritt</strong> erzeugen einen unwiderstehlichen Effekt für Momente der puren Verführung.</p>
title
stringOups-Slip: Spitze und Schnürung Skandalös Sexy
usageinstructions
string<p>Der Oups-Slip wurde für Ihre <strong>frechsten</strong> und provokantesten Momente entworfen. Seine <strong>Öffnung im Schritt</strong> bietet einen direkten Zugang, der jeden intimen Moment in ein skandalös aufregendes Erlebnis purer Lust verwandelt.</p> <p>Die <strong>atemberaubende hintere Schnürung</strong> ermöglicht eine individuelle Passform und sorgt gleichzeitig für einen atemberaubenden visuellen Effekt. Tragen Sie ihn selbstbewusst, um Ihre <strong>kühnste</strong> Seite zu enthüllen und die Temperatur mit jedem Blick zu erhöhen.</p>
el
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>Το εσώρουχο Oups ενσαρκώνει την πιο <strong>τολμηρή</strong> αποπλάνηση, με πλήρη μαύρη δαντέλα που παίζει με τη διαφάνεια για να αποκαλύψει διακριτικά το δέρμα σας.</p> <p>Αυτή η <strong>σκανδαλωδώς ανοιχτή</strong> δημιουργία μετατρέπει κάθε προσωπική στιγμή σε μια εμπειρία καθαρής απόλαυσης. Το<strong>άνοιγμα στον καβάλο</strong> προσφέρει άμεση πρόσβαση που ανεβάζει τη θερμοκρασία, ενώ τα <strong>υπέροχα κορδόνια στην πλάτη</strong> δημιουργούν ένα απόλυτα σαγηνευτικό οπτικό παιχνίδι αποπλάνησης. Αυτή η μοναδική λεπτομέρεια τραβάει φυσικά τα βλέμματα, αποκαλύπτοντας το οπίσθιό σας με συναρπαστικό τρόπο.</p> <p>Η <strong>λεπτοδουλεμένη δαντέλα</strong> του αγκαλιάζει τέλεια τις γενναιόδωρες καμπύλες σας, προσαρμοζόμενη σε όλα τα σχήματα του σώματος για βέλτιστη άνεση ακόμα και κατά τη διάρκεια των πιο έντονων στιγμών σας. Οι <strong>σχολαστικές τελευταίες</strong> πινελιές καθιστούν το Oops ένα πραγματικά ακαταμάχητο εσώρουχο.</p> <p>Αυτή η μαύρη δημιουργία έχει σχεδιαστεί για να αποκαλύψει τον πιο <strong>αυθεντικό</strong> σας αισθησιασμό και να μετατρέψει κάθε στιγμή σε μια στιγμή καθαρής πρόκλησης.</p>
guid
stringhttps://dev.divasboudoir.com/el/oups-mayro-megalo-anoichto-eswroycho-mayro/sbbu4732.htm
highlights
string<ul> <li>Εξαιρετικά αισθησιακή<strong>μαύρη δαντέλα all-over</strong> </li> <li>Εξωφρενικά άτακτο<strong>άνοιγμα καβάλου</strong> </li> <li><strong>Υπέροχο εντυπωσιακό κορδόνι στην πλάτη</strong> </li> <li><strong>Ρυθμιζόμενη εφαρμογή</strong> για να ενισχύσει τις γενναιόδωρες καμπύλες</li> <li><strong>Τελειωμένη</strong> με εκλεπτυσμένες λεπτομέρειες από δαντέλα</li> <li><strong>Προκλητικό στυλ</strong> που αναδεικνύει την τολμηρή σας συμπεριφορά</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringΜεγάλο μαύρο δαντελένιο εσώρουχο Oops με κορδόνια στην πλάτη. Εξωφρενικά σέξι άνοιγμα καβάλου. Μια τολμηρή δήλωση. Μπουντουάρ της Ντίβας.
keywords
string
title
stringΕσώρουχα Oops μεγάλου μεγέθους με κορδόνια στην πλάτη | Diva's Boudoir
seotitle
stringOups μεγάλο ανοιχτό δαντελένιο εσώρουχο με κορδόνια στην πλάτη
seouri
stringoups-mayro-megalo-anoichto-eswroycho-mayro
specifications
string<ul> <li><strong>Υλικό:</strong> Δαντέλα (92% πολυαμίδιο, 8% ελαστάν)</li> <li><strong>Στυλ:</strong> Ανοιχτό εσώρουχο με κορδόνια στην πλάτη</li> <li><strong>Ανοίγματα:</strong> Καβάλο για άμεση πρόσβαση</li> <li><strong>Φροντίδα:</strong> Συνιστάται απαλό πλύσιμο στο χέρι</li> </ul>
stylingtips
string<p>Το εσώρουχο Oups, με τα <strong>κορδόνια στην πλάτη</strong>, είναι ό,τι χρειάζεστε για να δημιουργήσετε μια <strong>εξωφρενικά σέξι</strong> εμφάνιση. Συνδυάστε τα με κομμάτια που αποκαλύπτουν διακριτικά την προκλητική τους παρουσία για πρόσθετη αποπλάνηση. Αυτή η μαύρη δημιουργία αποκαλύπτει την τόλμη και τον αχαλίνωτο αισθησιασμό σας.</p> <p>Ολοκληρώστε την εμφάνισή σας με τα <a href="https://www.divasboudoir.com/el/megalo-anoichto-kormaki/"><strong>ανοιχτά</strong></a> μας <a href="https://www.divasboudoir.com/el/megalo-anoichto-kormaki/"><strong>κορμάκια</strong></a> για απόλυτη αποπλάνηση ή προσθέστε ένα <a href="https://www.divasboudoir.com/el/negklize-megaloy-megethoys/"><strong>νεγκλιζέ</strong></a> για μια σταδιακή προσέγγιση που κορυφώνεται με την ανακάλυψη αυτών των τρομερά συναρπαστικών εσώρουχων.</p>
summary
string<p>Ανακαλύψτε το εσώρουχο Oups, μια <strong>σκανδαλωδώς ανοιχτή</strong> δημιουργία από μαύρη δαντέλα που αποκαλύπτει την πιο <strong>τολμηρή</strong> πλευρά σας.</p> <p>Τα <strong>υπέροχα κορδόνια στην πλάτη</strong> και το <strong>άνοιγμα του καβάλου</strong> δημιουργούν ένα ακαταμάχητο αποτέλεσμα για στιγμές καθαρής αποπλάνησης.</p>
title
stringΕσώρουχα Oops: Σκανδαλωδώς σέξι δαντέλα και κορδόνια
usageinstructions
string<p>Τα εσώρουχα Oups είναι σχεδιασμένα για τις πιο <strong>άτακτες</strong> και προκλητικές σας στιγμές. Το <strong>άνοιγμα στον καβάλο</strong> του προσφέρει άμεση πρόσβαση που μετατρέπει κάθε προσωπική στιγμή σε μια εξωφρενικά συναρπαστική εμπειρία καθαρής απόλαυσης.</p> <p>Το <strong>εξαιρετικό κορδόνι στο πίσω μέρος</strong> επιτρέπει την εξατομικευμένη εφαρμογή, ενώ παράλληλα δημιουργεί ένα εντυπωσιακό οπτικό αποτέλεσμα. Φορέστε το με αυτοπεποίθηση για να αποκαλύψετε την πιο <strong>τολμηρή</strong> πλευρά σας και να ανεβάσετε τη θερμοκρασία με κάθε σας ματιά.</p>
en
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>Oups panties embody the most <strong>daring</strong> seduction, with full black lace that plays with transparency to subtly reveal your skin.</p> <p>This <strong>scandalously open</strong> creation transforms every intimate moment into an experience of pure pleasure. The<strong>crotch opening</strong> offers direct access that raises the temperature, while the <strong>superb rear lacing</strong> creates an absolutely captivating play of visual seduction. This unique detail is a natural eye-catcher, revealing your buttocks in a terribly exciting way.</p> <p>Its <strong>delicately patterned lace</strong> perfectly hugs your generous curves, adapting to all morphologies for optimum comfort even during your most intense moments. The <strong>meticulous finishing</strong> touches make Oups a truly irresistible panty.</p> <p>This black creation is designed to reveal your most <strong>authentic</strong> sensuality and turn every moment into a moment of pure provocation.</p>
guid
stringhttps://dev.divasboudoir.com/en/oups-open-plus-size-panties-black-black/sbbu4732.htm
highlights
string<ul> <li>Ultra-sensual<strong>all-over black lace</strong> </li> <li>Outrageously naughty<strong>crotch opening</strong> </li> <li><strong>Superb</strong>, eye-catching<strong>back lacing</strong> </li> <li><strong>Adjustable fit</strong> to enhance generous curves</li> <li><strong>Finished</strong> with refined lace details</li> <li><strong>Provocative styling</strong> reveals your confident audacity</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringOups plus size black lace panties with back lacing. Outrageously sexy crotch opening. Audacity assumed. Diva's Boudoir.
keywords
string
title
stringOups plus size back lacing panties | Diva's Boudoir
seotitle
stringOups lace open panties plus size with back lacing
seouri
stringoups-open-plus-size-panties-black-black
specifications
string<ul> <li><strong>Material:</strong> Lace (92% polyamide, 8% elastane)</li> <li><strong>Style:</strong> Open panty with back lacing</li> <li><strong>Openings:</strong> Crotch for direct access</li> <li><strong>Care:</strong> Delicate hand wash recommended</li> </ul>
stylingtips
string<p>The Oups panty with its <strong>back lacing</strong> stands alone to create an <strong>outrageously sexy</strong> look. To amplify the seductive effect, pair them with pieces that subtly reveal their provocative presence. This black creation reveals your boldness and unbridled sensuality.</p> <p>Complete your look with our <a href="https://www.divasboudoir.com/en/open-bodysuit-plus-size/"><strong>open bodysuits</strong></a> for total seduction, or add a <a href="https://www.divasboudoir.com/en/plus-size-robes/"><strong>negligee</strong></a> for a gradual approach culminating in the discovery of these terribly exciting panties.</p>
summary
string<p>Discover Oups panties, a <strong>scandalously open</strong> creation in black lace that reveals your most <strong>daring</strong> side.</p> <p>Its <strong>superb back lacing</strong> and <strong>crotch opening</strong> create an irresistible effect for moments of pure seduction.</p>
title
stringOops panties: Scandalously sexy lace and lacing
usageinstructions
string<p>Oups panties are designed for your most <strong>naughty</strong> and provocative moments. Its <strong>crotch opening</strong> offers direct access that transforms every intimate moment into an outrageously exciting experience of pure pleasure.</p> <p>The <strong>superb back lacing</strong> allows a personalized fit while creating a striking visual effect. Wear it with confidence to reveal your most <strong>daring</strong> side and raise the temperature with every glance.</p>
es
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>Las braguitas Oups encarnan la seducción más <strong>atrevida</strong>, con encaje negro integral que juega con la transparencia para revelar sutilmente tu piel.</p> <p>Esta creación <strong>escandalosamente abierta</strong> transforma cada momento íntimo en una experiencia de puro placer. La<strong>abertura de la entrepierna</strong> ofrece un acceso directo que eleva la temperatura, mientras que la <strong>magnífica lazada trasera</strong> crea un juego visual de seducción absolutamente cautivador. Este detalle único atrae todas las miradas y deja al descubierto el trasero de forma excitante.</p> <p>Su <strong>encaje delicadamente estampado</strong> abraza perfectamente tus generosas curvas, adaptándose a todas las formas del cuerpo para un confort óptimo incluso en tus momentos más intensos. Los <strong>meticulosos acabados</strong> hacen de Oops una braguita verdaderamente irresistible.</p> <p>Esta creación negra está diseñada para revelar tu sensualidad más <strong>auténtica</strong> y convertir cada instante en un momento de pura provocación.</p>
guid
stringhttps://dev.divasboudoir.com/es/oups-braguitas-negras-talla-grande-abiertas-negro/sbbu4732.htm
highlights
string<ul> <li><strong>Encaje negro integral</strong> ultrasensual</li> <li><strong>Abertura en la entrepierna</strong> escandalosamente atrevida</li> <li><strong>Magnífico y llamativo cordón trasero</strong> </li> <li><strong>Ajuste regulable</strong> para realzar las curvas generosas</li> <li><strong>Acabado</strong> con refinados detalles de encaje</li> <li><strong>Estilo provocativo</strong> que muestra tu actitud atrevida</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringBragas Oops de encaje negro de talla grande con lazada trasera. Abertura en la entrepierna escandalosamente sexy. Una declaración audaz. Diva's Boudoir.
keywords
string
title
stringOops bragas talla grande con lazada trasera | Diva's Boudoir
seotitle
stringOups bragas talla grande de encaje con lazada trasera
seouri
stringoups-braguitas-negras-talla-grande-abiertas-negro
specifications
string<ul> <li><strong>Material:</strong> Encaje (92% poliamida, 8% elastano)</li> <li><strong>Estilo:</strong> Braguita abierta con lazada trasera</li> <li><strong>Aberturas:</strong> Entrepierna para acceso directo</li> <li><strong>Cuidados:</strong> Se recomienda un lavado a mano delicado</li> </ul>
stylingtips
string<p>Las braguitas Oups, con su <strong>lazada trasera</strong>, son todo lo que necesitas para crear un look <strong>escandalosamente sexy</strong>. Combínalas con piezas que revelen sutilmente su provocativa presencia para una mayor seducción. Esta creación negra revela tu atrevimiento y sensualidad desenfrenada.</p> <p>Completa tu look con nuestros <a href="https://www.divasboudoir.com/es/body-abierto-talla-grande/"><strong>bodys abiertos</strong></a> para una seducción total, o añade un <a href="https://www.divasboudoir.com/es/picardias-talla-grande/"><strong>picardías</strong></a> para un acercamiento gradual que culmine con el descubrimiento de estas bragas terriblemente excitantes.</p>
summary
string<p>Descubre las braguitas Oups, una creación <strong>escandalosamente abierta</strong> en encaje negro que revela tu lado más <strong>atrevido</strong>.</p> <p>Su <strong>magnífica lazada trasera</strong> y su <strong>abertura en la entrepierna</strong> crean un efecto irresistible para momentos de pura seducción.</p>
title
stringBraguitas Oops: Encaje y lazada escandalosamente sexy
usageinstructions
string<p>Las braguitas Oups están diseñadas para tus momentos más <strong>traviesos</strong> y provocativos. Su <strong>abertura en la entrepierna</strong> ofrece un acceso directo que convierte cada momento íntimo en una experiencia escandalosamente excitante de puro placer.</p> <p>El <strong>magnífico cordón trasero</strong> permite un ajuste personalizado a la vez que crea un llamativo efecto visual. Llévalo con confianza para revelar tu lado más <strong>atrevido</strong> y subir la temperatura con cada mirada.</p>
fr
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>La culotte Oups incarne la s&eacute;duction la plus <strong>audacieuse</strong> avec sa dentelle noire int&eacute;grale qui joue avec la transparence pour r&eacute;v&eacute;ler subtilement votre peau.</p> <p>Cette cr&eacute;ation&nbsp;<strong>scandaleusement ouverte</strong> transforme chaque moment intime en exp&eacute;rience de pur plaisir. L'<strong>ouverture &agrave; l'entrejambe</strong> offre un acc&egrave;s direct qui fait monter la temp&eacute;rature, tandis que le <strong>superbe la&ccedil;age arri&egrave;re</strong> cr&eacute;e un jeu de s&eacute;duction visuel absolument captivant. Ce d&eacute;tail unique attire naturellement le regard et r&eacute;v&egrave;le vos fesses de fa&ccedil;on terriblement excitante.</p> <p>Sa&nbsp;<strong>dentelle aux motifs d&eacute;licats</strong> &eacute;pouse parfaitement vos courbes g&eacute;n&eacute;reuses, s'adaptant &agrave; toutes les morphologies pour un confort optimal m&ecirc;me lors de vos moments les plus intenses. Les <strong>finitions soign&eacute;es</strong> apportent cette touche finale qui fait de Oups une culotte vraiment irr&eacute;sistible.</p> <p>Cette cr&eacute;ation noire est con&ccedil;ue pour r&eacute;v&eacute;ler votre sensualit&eacute; la plus&nbsp;<strong>authentique</strong> et transformer chaque instant en moment de pure provocation assum&eacute;e.</p>
guid
stringhttps://dev.divasboudoir.com/fr/culotte-grande-taille-ouverte-oups-noire-noir/sbbu4732.htm
highlights
string<ul> <li><strong>Dentelle int&eacute;grale noire</strong> ultra sensuelle</li> <li><strong>Ouverture entrejambe</strong> scandaleusement coquine</li> <li><strong>Superbe la&ccedil;age arri&egrave;re</strong> qui attire tous les regards</li> <li><strong>Coupe ajustable</strong> qui sublime les courbes g&eacute;n&eacute;reuses</li> <li><strong>Finitions soign&eacute;es</strong> avec d&eacute;tails dentelle raffin&eacute;s</li> <li><strong>Style provocant</strong> qui r&eacute;v&egrave;le votre audace assum&eacute;e</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringCulotte Oups grande taille en dentelle noire avec laçage arrière. Ouverture entrejambe scandaleusement sexy. Audace assumée. Diva's Boudoir.
keywords
string
title
stringCulotte Oups grande taille laçage arrière | Diva's Boudoir
seotitle
stringCulotte ouverte grande taille Oups dentelle avec laçage arrière
seouri
stringculotte-grande-taille-ouverte-oups-noire-noir
specifications
string<ul> <li><strong>Mati&egrave;re :</strong> Dentelle (92% polyamide, 8% &eacute;lasthanne)</li> <li><strong>Style :</strong> Culotte ouverte avec la&ccedil;age arri&egrave;re</li> <li><strong>Ouvertures :</strong> Entrejambe pour un acc&egrave;s direct</li> <li><strong>Entretien :</strong> Lavage d&eacute;licat &agrave; la main recommand&eacute;</li> </ul>
stylingtips
string<p>La culotte Oups avec son <strong>la&ccedil;age arri&egrave;re</strong> se suffit &agrave; elle-m&ecirc;me pour cr&eacute;er un look <strong>scandaleusement sexy</strong>. Pour amplifier l'effet de s&eacute;duction, associez-la &agrave; des pi&egrave;ces qui r&eacute;v&egrave;lent subtilement sa pr&eacute;sence provocante. Cette cr&eacute;ation noire r&eacute;v&egrave;le votre audace assum&eacute;e et votre sensualit&eacute; d&eacute;brid&eacute;e.</p> <p>Compl&eacute;tez votre look avec nos&nbsp;<a href="https://www.divasboudoir.com/fr/body-ouvert-grande-taille/"><strong>bodys ouverts</strong></a>&nbsp;pour une s&eacute;duction totale, ou ajoutez un <a href="https://www.divasboudoir.com/fr/deshabille-grande-taille/"><strong>d&eacute;shabill&eacute;</strong></a>&nbsp; pour une approche progressive qui culminera avec la d&eacute;couverte de cette culotte terriblement excitante.</p>
summary
string<p>D&eacute;couvrez la culotte Oups, une cr&eacute;ation <strong>scandaleusement ouverte</strong> en dentelle noire qui r&eacute;v&egrave;le votre c&ocirc;t&eacute; le plus <strong>audacieux</strong>.</p> <p>Son&nbsp;<strong>superbe la&ccedil;age arri&egrave;re</strong> et son <strong>ouverture entrejambe</strong> cr&eacute;ent un effet irr&eacute;sistible pour des moments de pure s&eacute;duction.</p>
title
stringCulotte Oups : Dentelle et Laçage Scandaleusement Sexy
usageinstructions
string<p>La culotte Oups est con&ccedil;ue pour vos moments les plus <strong>coquins</strong> et provocants. Son <strong>ouverture entrejambe</strong> offre un acc&egrave;s direct qui transforme chaque instant intime en exp&eacute;rience de pur plaisir scandaleusement excitante.</p> <p>Le&nbsp;<strong>superbe la&ccedil;age arri&egrave;re</strong> permet un ajustement personnalis&eacute; tout en cr&eacute;ant un effet visuel saisissant. Portez-la avec assurance pour r&eacute;v&eacute;ler votre c&ocirc;t&eacute; le plus <strong>audacieux</strong> et faire monter la temp&eacute;rature &agrave; chaque regard.</p>
it
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>Le mutandine Oups incarnano la seduzione pi&ugrave; <strong>audace</strong>, con un pizzo nero pieno che gioca con le trasparenze per rivelare sottilmente la pelle.</p> <p>Questa creazione <strong>scandalosamente aperta</strong> trasforma ogni momento intimo in un'esperienza di puro piacere. L'<strong>apertura inguinale</strong> offre un accesso diretto che aumenta la temperatura, mentre la <strong>superba allacciatura posteriore</strong> crea un gioco di seduzione visiva assolutamente accattivante. Questo dettaglio unico attira naturalmente l'attenzione, rivelando il sedere in modo eccitante.</p> <p>Il <strong>pizzo delicatamente modellato</strong> abbraccia perfettamente le vostre curve generose, adattandosi a tutte le forme del corpo per un comfort ottimale anche nei momenti pi&ugrave; intensi. Le <strong>minuziose rifiniture</strong> fanno di Oops un panty davvero irresistibile.</p> <p>Questa creazione nera &egrave; pensata per rivelare la vostra sensualit&agrave; pi&ugrave; <strong>autentica</strong> e trasformare ogni momento in un momento di pura provocazione.</p>
guid
stringhttps://dev.divasboudoir.com/it/oups,-mutandine-nere-di-grande-taglia-aperte-nero/sbbu4732.htm
highlights
string<ul> <li>Ultra-sensuale<strong>pizzo nero all-over</strong></li> <li><strong>Apertura inguinale</strong> oltraggiosamente maliziosa</li> <li><strong>Allacciatura posteriore superba e accattivante</strong></li> <li><strong>Vestibilit&agrave; regolabile</strong> per esaltare le curve generose</li> <li><strong>Rifinito</strong> con raffinati dettagli in pizzo</li> <li><strong>Stile provocante</strong> che mette in mostra il vostro atteggiamento audace</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringGrande mutandina Oops in pizzo nero con allacciatura posteriore. Apertura inguinale scandalosamente sexy. Una dichiarazione audace. Boudoir da diva.
keywords
string
title
stringMutandine Oops di taglia grande con allacciatura posteriore | Diva's Boudoir
seotitle
stringMutandine di pizzo aperte di Oups di taglia grande con allacciatura posteriore
seouri
stringoups,-mutandine-nere-di-grande-taglia-aperte-nero
specifications
string<ul> <li><strong>Materiale:</strong> pizzo (92% poliammide, 8% elastan)</li> <li><strong>Stile:</strong> mutandina aperta con allacciatura posteriore</li> <li><strong>Aperture:</strong> cavallo per accesso diretto</li> <li><strong>Cura:</strong> Si consiglia un lavaggio delicato a mano</li> </ul>
stylingtips
string<p>Le mutandine Oups, con la loro <strong>allacciatura posteriore</strong>, sono tutto ci&ograve; che serve per creare un look <strong>scandalosamente sexy</strong>. Abbinatele a capi che rivelino sottilmente la loro presenza provocante per una maggiore seduzione. Questa creazione nera rivela la vostra audacia e sensualit&agrave; sfrenata.</p> <p>Completate il vostro look con i nostri <a href="https://www.divasboudoir.com/it/body-aperto-di-grande-taglia/"><strong>body aperti</strong></a> per una seduzione totale, oppure aggiungete una <a href="https://www.divasboudoir.com/it/vestaglia-taglia-grande/"><strong>vestaglia per</strong></a> un approccio graduale che culmina con la scoperta di queste mutandine terribilmente eccitanti.</p>
summary
string<p>Scoprite le mutandine Oups, una creazione <strong>scandalosamente aperta</strong> in pizzo nero che rivela il vostro lato pi&ugrave; <strong>audace</strong>.</p> <p>La <strong>superba allacciatura posteriore</strong> e l'<strong>apertura inguinale</strong> creano un effetto irresistibile per momenti di pura seduzione.</p>
title
stringMutandine Ops: pizzo e allacciatura scandalosamente sexy
usageinstructions
string<p>Le mutandine Oups sono pensate per i vostri momenti pi&ugrave; <strong>maliziosi</strong> e provocanti. L'<strong>apertura inguinale</strong> offre un accesso diretto che trasforma ogni momento di intimit&agrave; in un'esperienza di puro piacere.</p> <p>La <strong>superba allacciatura posteriore</strong> consente una vestibilit&agrave; personalizzata e crea un effetto visivo di grande impatto. Indossatelo con fiducia per rivelare il vostro lato pi&ugrave; <strong>audace</strong> e aumentare il calore ad ogni sguardo.</p>
nl
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>De Oups slip belichaamt de meest <strong>gedurfde</strong> verleiding, met volledig zwart kant dat speelt met transparantie om je huid subtiel te onthullen.</p> <p>Deze <strong>schandalig open</strong> creatie verandert elk intiem moment in een ervaring van puur genot. De<strong>opening in het kruis</strong> biedt directe toegang die de temperatuur doet stijgen, terwijl <strong>de prachtige vetersluiting aan de achterkant</strong> een absoluut boeiend visueel spel van verleiding cre&euml;ert. Dit unieke detail is een natuurlijke blikvanger die je billen op een opwindende manier onthult.</p> <p>Het <strong>kant met fijne patronen</strong> omhelst je royale rondingen perfect en past zich aan alle lichaamsvormen aan voor optimaal comfort, zelfs tijdens je meest intense momenten. De <strong>zorgvuldige afwerking</strong> maakt van Oops een echt onweerstaanbaar broekje.</p> <p>Deze zwarte creatie is ontworpen om je meest <strong>authentieke</strong> sensualiteit te onthullen en van elk moment een moment van pure provocatie te maken.</p>
guid
stringhttps://dev.divasboudoir.com/nl/oups-zwarte-groote-maat-onderbroek-zwart/sbbu4732.htm
highlights
string<ul> <li>Ultra-sensueel<strong>all-over zwart kant</strong></li> <li>Schandalig ondeugende<strong>kruisopening</strong></li> <li><strong>Schitterende opvallende vetersluiting achter</strong></li> <li><strong>Verstelbare pasvorm</strong> om royale rondingen te verbeteren</li> <li><strong>Afgewerkt</strong> met verfijnde kanten details</li> <li><strong>Provocerende stijl</strong> die pronkt met je gedurfde houding</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringGrote zwarte kanten Oops slip met vetersluiting aan de achterkant. Schandalig sexy kruisopening. Een gedurfd statement. Diva's Boudoir.
keywords
string
title
stringOops grote maat slip met vetersluiting | Diva's Boudoir
seotitle
stringOups grote open kanten slip met vetersluiting op de rug
seouri
stringoups-zwarte-groote-maat-onderbroek-zwart
specifications
string<ul> <li><strong>Materiaal:</strong> Kant (92% polyamide, 8% elastaan)</li> <li><strong>Stijl:</strong> Open slip met vetersluiting op de rug</li> <li><strong>Openingen:</strong> Kruis voor directe toegang</li> <li><strong>Onderhoud:</strong> Fijne handwas aanbevolen</li> </ul>
stylingtips
string<p>De Oups slips, <strong>met</strong> hun <strong>vetersluiting aan de achterkant</strong>, zijn alles wat je nodig hebt om een <strong>waanzinnig sexy</strong> look te cre&euml;ren. Combineer ze met stukken die op subtiele wijze hun provocerende aanwezigheid onthullen voor extra verleiding. Deze zwarte creatie onthult je brutaliteit en ongebreidelde sensualiteit.</p> <p>Maak je look compleet met onze <a href="https://www.divasboudoir.com/nl/groote-open-romper/"><strong>open bodysuits</strong></a> voor totale verleiding, of voeg een <a href="https://www.divasboudoir.com/nl/grote-maat-neglige/"><strong>neglig&eacute;</strong></a> toe voor een geleidelijke aanpak die culmineert in de ontdekking van deze vreselijk opwindende slip.</p>
summary
string<p>Ontdek de Oups slip, een <strong>schandalig open</strong> creatie van zwart kant die je van je meest <strong>gewaagde</strong> kant laat zien.</p> <p>De <strong>prachtige vetersluiting op de rug</strong> en <strong>de opening in het kruis</strong> cre&euml;ren een onweerstaanbaar effect voor momenten van pure verleiding.</p>
title
stringOops slipje: Schandalig sexy kant en vetersluiting
usageinstructions
string<p>Oups slips zijn ontworpen voor je meest <strong>ondeugende</strong> en uitdagende momenten. De <strong>opening in het kruis</strong> biedt directe toegang die elk intiem moment verandert in een ongehoord opwindende ervaring van puur genot.</p> <p>De <strong>prachtige vetersluiting aan de achterkant</strong> zorgt voor een persoonlijke pasvorm en een opvallend visueel effect. Draag het met vertrouwen om je meest <strong>gewaagde</strong> kant te onthullen en zet de hitte aan met elke blik.</p>
pt
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>As cuecas Oups encarnam a sedução mais <strong>ousada</strong>, com renda preta completa que joga com a transparência para revelar subtilmente a sua pele.</p> <p>Esta criação <strong>escandalosamente aberta</strong> transforma cada momento íntimo numa experiência de puro prazer. A<strong>abertura na virilha</strong> oferece um acesso direto que faz subir a temperatura, enquanto o <strong>soberbo laço nas costas</strong> cria um jogo visual de sedução absolutamente cativante. Este detalhe único é um chamariz natural, revelando o seu traseiro de uma forma excitante.</p> <p>A <strong>renda com um padrão delicado</strong> abraça perfeitamente as suas curvas generosas, adaptando-se a todas as formas do corpo para um conforto ótimo, mesmo durante os momentos mais intensos. Os <strong>acabamentos meticulosos</strong> fazem de Oops uma cueca verdadeiramente irresistível.</p> <p>Esta criação preta foi concebida para revelar a sua sensualidade mais <strong>autêntica</strong> e transformar cada momento num momento de pura provocação.</p>
guid
stringhttps://dev.divasboudoir.com/pt/oups-cuecas-grandes-abertas-pretas-preto/sbbu4732.htm
highlights
string<ul> <li><strong>Renda preta</strong> ultra-sensual<strong>em todo o corpo</strong> </li> <li><strong>Abertura na virilha</strong> escandalosamente atrevida</li> <li><strong>Excelente laço nas costas que chama a atenção</strong> </li> <li><strong>Ajuste ajustável</strong> para realçar as curvas generosas</li> <li><strong>Acabamento</strong> com pormenores de renda refinados</li> <li><strong>Estilo provocante</strong> que mostra a sua atitude ousada</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringCuecas Oops grandes em renda preta com laço nas costas. Abertura na virilha escandalosamente sexy. Uma afirmação ousada. Boudoir de Diva.
keywords
string
title
stringCalcinhas Oops tamanho grande com laço nas costas | Diva's Boudoir
seotitle
stringCalcinhas de renda grandes e abertas Oups com laço nas costas
seouri
stringoups-cuecas-grandes-abertas-pretas-preto
specifications
string<ul> <li><strong>Material:</strong> Renda (92% poliamida, 8% elastano)</li> <li><strong>Estilo:</strong> Calcinha aberta com laço nas costas</li> <li><strong>Aberturas:</strong> Entrepernas para acesso direto</li> <li><strong>Cuidados:</strong> Recomenda-se uma lavagem delicada à mão</li> </ul>
stylingtips
string<p>As cuecas Oups, com o seu <strong>laço nas costas</strong>, são tudo o que precisa para criar um look <strong>escandalosamente sexy</strong>. Combine-as com peças que revelem subtilmente a sua presença provocante para uma maior sedução. Esta criação preta revela a sua ousadia e sensualidade desenfreada.</p> <p>Complete o seu look com os nossos <a href="https://www.divasboudoir.com/pt/body-grande-aberto/"><strong>body abertos</strong></a> para uma sedução total, ou adicione um <a href="https://www.divasboudoir.com/pt/batotas-plus-size/"><strong>negligee</strong></a> para uma abordagem gradual que culmina na descoberta destas cuecas terrivelmente excitantes.</p>
summary
string<p>Descubra as cuecas Oups, uma criação <strong>escandalosamente aberta</strong> em renda preta que revela o seu lado mais <strong>ousado</strong>.</p> <p>O <strong>soberbo laço nas costas</strong> e a <strong>abertura na virilha</strong> criam um efeito irresistível para momentos de pura sedução.</p>
title
stringCalcinhas Oops: rendas e laços escandalosamente sensuais
usageinstructions
string<p>As cuecas Oups foram concebidas para os seus momentos mais <strong>atrevidos</strong> e provocantes. A sua <strong>abertura na virilha</strong> oferece um acesso direto que transforma cada momento íntimo numa experiência escandalosamente excitante de puro prazer.</p> <p>O <strong>soberbo laço nas costas</strong> permite um ajuste personalizado, criando um efeito visual impressionante. Use-o com confiança para revelar o seu lado mais <strong>ousado</strong> e aumentar o calor com cada olhar.</p>
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
stringSchwarzer Oups-Slip ganz aus Spitze.<br /><br />Im Schritt offen, Schn&uuml;rung auf der R&uuml;ckseite.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringOffenes schwarzes Höschen in Übergröße mit Schnürung.
keywords
string
title
stringOups Slip große Größe offen schwarz
seotitle
stringOups Slip große Größe offen schwarz
seouri
stringoups-slip-grosse-grosse-offen-schwarz-schwarz
specifications
string
stylingtips
string
summary
stringOffenes schwarzes H&ouml;schen in &Uuml;bergr&ouml;&szlig;e mit Schn&uuml;rung.
title
stringOups offener Slip schwarz
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string&Mu;&alpha;ύ&rho;&omicron; &delta;&alpha;&nu;&tau;&epsilon;&lambda;έ&nu;&iota;&omicron; &epsilon;&sigma;ώ&rho;&omicron;&upsilon;&chi;&omicron; Oops.<br /><br />&Alpha;&nu;&omicron;&iota;&chi;&tau;ό &sigma;&tau;&omicron; &kappa;&alpha;&beta;ά&lambda;&omicron;, &mu;&epsilon; &kappa;&omicron;&rho;&delta;ό&nu;&iota;&alpha; &sigma;&tau;&omicron; &pi;ί&sigma;&omega; &mu;έ&rho;&omicron;&sigmaf;.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringΜαύρο ανοιχτό εσώρουχο μεγάλου μεγέθους με κορδόνια.
keywords
string
title
stringOups μαύρο μεγάλο ανοιχτό εσώρουχο
seotitle
stringOups μαύρο μεγάλο ανοιχτό εσώρουχο
seouri
stringoups-mayro-megalo-anoichto-eswroycho-mayro
specifications
string
stylingtips
string
summary
string&Mu;&alpha;ύ&rho;&omicron; &alpha;&nu;&omicron;&iota;&chi;&tau;ό &epsilon;&sigma;ώ&rho;&omicron;&upsilon;&chi;&omicron; &mu;&epsilon;&gamma;ά&lambda;&omicron;&upsilon; &mu;&epsilon;&gamma;έ&theta;&omicron;&upsilon;&sigmaf; &mu;&epsilon; &kappa;&omicron;&rho;&delta;ό&nu;&iota;&alpha;.
title
stringOups μαύρο βρακί
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringBlack lace Oups panties.<br /><br />Open at crotch, lacing at back.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringBlack plus size panties with lace-up front.
keywords
string
title
stringOups open plus size panties black
seotitle
stringOups open plus size panties black
seouri
stringoups-open-plus-size-panties-black-black
specifications
string
stylingtips
string
summary
stringBlack plus size panties with lace-up front.
title
stringOups black open panties
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringBraguita Oops de encaje negro.<br /><br />Abiertas en la entrepierna, con cord&oacute;n en la parte trasera.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringBraguita negra de talla grande abierta con cordón.
keywords
string
title
stringOups braguitas negras talla grande abiertas
seotitle
stringOups braguitas negras talla grande abiertas
seouri
stringoups-braguitas-negras-talla-grande-abiertas-negro
specifications
string
stylingtips
string
summary
stringBraguita negra de talla grande abierta con cord&oacute;n.
title
stringOups bragas negras
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Culotte Oups tout en dentelle.&nbsp;<br><br>Scandaleusement ouverte &agrave; l'entrejambe, superbe la&ccedil;age &agrave; l'arri&egrave;re.</p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringCulotte grande taille noire ouverte à laçage.
keywords
string
title
stringCulotte grande taille ouverte Oups noire
seotitle
stringCulotte ouverte Oups noire
seouri
stringculotte-ouverte-oups-noire-noir
specifications
string
stylingtips
string
summary
string<p>Culotte &eacute;rotiquement ind&eacute;cente &agrave; la&ccedil;age, ouverte &agrave; l'entrejambe.</p>
title
stringCulotte ouverte Oups
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringMutandine Oops in pizzo nero.<br /><br />Aperta sul cavallo, allacciatura sul retro.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringMutandine aperte nere di taglia grande con allacciatura.
keywords
string
title
stringOups, mutandine nere di grande taglia aperte
seotitle
stringOups, mutandine nere di grande taglia aperte
seouri
stringoups,-mutandine-nere-di-grande-taglia-aperte-nero
specifications
string
stylingtips
string
summary
stringMutandine aperte nere di taglia grande con allacciatura.
title
stringMutande nere Oups
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringZwart kanten Oops slipje.<br /><br />Open bij het kruis, vetersluiting aan de achterkant.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringZwarte open onderbroek in groote maat met vetersluiting.
keywords
string
title
stringOups zwarte groote maat onderbroek
seotitle
stringOups zwarte groote maat onderbroek
seouri
stringoups-zwarte-groote-maat-onderbroek-zwart
specifications
string
stylingtips
string
summary
stringZwarte open onderbroek in groote maat met vetersluiting.
title
stringOups zwarte onderbroek
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringCuecas Oops em renda preta.<br /><br />Abertas na virilha, com la&ccedil;o na parte de tr&aacute;s.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringCalcinhas pretas de tamanho grande abertas com laço.
keywords
string
title
stringOups cuecas grandes abertas pretas
seotitle
stringOups cuecas grandes abertas pretas
seouri
stringoups-cuecas-grandes-abertas-pretas-preto
specifications
string
stylingtips
string
summary
stringCalcinhas pretas de tamanho grande abertas com la&ccedil;o.
title
stringCalcinhas pretas Oups
usageinstructions
string
name
stringBlack P5179-1P Plus Size Open Crotch Floral Lace Panty Black
netweight
string
nextshipment
stringtoday
ordered
number3
orderidx
number0
origin
string
originalsize
string
packaging
string
productshipment
stringauto
productuid
stringA03AC848-44CF-457E-95AD8E65FEFF3AF1
promountil
string
rating
stringnone
recorduid
stringA03AC848-44CF-457E-95AD8E65FEFF3AF1
reference
stringSBBU4732
related
string
reserved
string
returned
number0
returnsallowed
number1
section
stringlingerie
shipment
string5to7days
showbrand
number0
sizeinfos
Query
Template: /system/api/product/sizes.cfc:20
Execution Time: 2.09 ms
Record Count: 12
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,'2382,2383,2384,2385,2380,2381') > 0
and product_variations.productuid = 'A03AC848-44CF-457E-95AD8E65FEFF3AF1'
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
12382LintlsizeblackLL-19999998wpluslingerieLL40-4210-1214-1642-4442-4440-4246-4842-4440-42102-107
22382LintlsizepurpleLL-19999991wpluslingerieLL40-4210-1214-1642-4442-4440-4246-4842-4440-42102-107
32382LintlsizewhiteLL-19999990wpluslingerieLL40-4210-1214-1642-4442-4440-4246-4842-4440-42102-107
42383XLintlsizepurpleXLXL-19999990wpluslingerieXLXL42-4412-1416-1844-4644-4642-4448-5044-4642-44107-112
52383XLintlsizeblackXLXL-19999990wpluslingerieXLXL42-4412-1416-1844-4644-4642-4448-5044-4642-44107-112
62383XLintlsizewhiteXLXL-19999990wpluslingerieXLXL42-4412-1416-1844-4644-4642-4448-5044-4642-44107-112
723842XLintlsizepurple2XL2XL-19999992wpluslingerie2XL2XL44-4614-1618-2046-4846-4844-4650-5246-4844-46112-117
823842XLintlsizeblack2XL2XL-19999990wpluslingerie2XL2XL44-4614-1618-2046-4846-4844-4650-5246-4844-46112-117
923842XLintlsizewhite2XL2XL-19999990wpluslingerie2XL2XL44-4614-1618-2046-4846-4844-4650-5246-4844-46112-117
1023853XLintlsizewhite3XL3XL-19999992wpluslingerie3XL3XL46-4816-1820-2248-5048-5046-4852-5448-5046-48117-123
1123853XLintlsizeblack3XL3XL-19999990wpluslingerie3XL3XL46-4816-1820-2248-5048-5046-4852-5448-5046-48117-123
1223853XLintlsizepurple3XL3XL-19999990wpluslingerie3XL3XL46-4816-1820-2248-5048-5046-4852-5448-5046-48117-123
sizeranges
stringplus,standard
sizes
string2382,2383,2384,2385,2380,2381
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: 9.01 ms
Record Count: 12
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 = 'A03AC848-44CF-457E-95AD8E65FEFF3AF1'
and product_variations.isactive = 1
and product_sizes.id_size = 2382
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
UNION
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 = 'A03AC848-44CF-457E-95AD8E65FEFF3AF1'
and product_variations.isactive = 1
and product_sizes.id_size = 2383
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
UNION
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 = 'A03AC848-44CF-457E-95AD8E65FEFF3AF1'
and product_variations.isactive = 1
and product_sizes.id_size = 2384
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
UNION
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 = 'A03AC848-44CF-457E-95AD8E65FEFF3AF1'
and product_variations.isactive = 1
and product_sizes.id_size = 2385
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
UNION
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 = 'A03AC848-44CF-457E-95AD8E65FEFF3AF1'
and product_variations.isactive = 1
and product_sizes.id_size = 2380
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
UNION
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 = 'A03AC848-44CF-457E-95AD8E65FEFF3AF1'
and product_variations.isactive = 1
and product_sizes.id_size = 2381
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
1A03AC848-44CF-457E-95AD8E65FEFF3AF18D6D54AA-11B9-4212-AF09C908DBCB37DF2382black#000000LL40-4210-1214-1642-4442-4440-4246-4842-4440-42wlingerieLintlsize16.62511.625STOCK01900-11100P5179-1PP5179-1P111588all
2A03AC848-44CF-457E-95AD8E65FEFF3AF1D305A2FB-693E-442D-A1B675E744F17F0C2382purple#9400D4LL40-4210-1214-1642-4442-4440-4246-4842-4440-42wlingerieLintlsize16.62511.625STOCK01100-1000011all
3A03AC848-44CF-457E-95AD8E65FEFF3AF185A5B233-7056-4224-BCF5F9A1F8C965C42382white#FFFFFFLL40-4210-1214-1642-4442-4440-4246-4842-4440-42wlingerieLintlsize16.62511.625STOCK01000-10000-10all
4A03AC848-44CF-457E-95AD8E65FEFF3AF12B4504E0-8E2B-46EA-982D2734091824702383black#000000XLXL42-4412-1416-1844-4644-4642-4448-5044-4642-44wlingerieXLintlsize16.62511.625STOCK01000-10100P5179-1PP5179-1P1117-10all
5A03AC848-44CF-457E-95AD8E65FEFF3AF146FCBE75-FB68-427E-911F76CC580F1E662383purple#9400D4XLXL42-4412-1416-1844-4644-4642-4448-5044-4642-44wlingerieXLintlsize16.62511.625STOCK01000-10000-10all
6A03AC848-44CF-457E-95AD8E65FEFF3AF121CE2D12-8223-4F27-94F3710EBC61451A2383white#FFFFFFXLXL42-4412-1416-1844-4644-4642-4448-5044-4642-44wlingerieXLintlsize16.62511.625STOCK01000-10000-10all
7A03AC848-44CF-457E-95AD8E65FEFF3AF12E6EA839-2EE7-4574-A537D4A865041BD02384black#0000002XL2XL44-4614-1618-2046-4846-4844-4650-5246-4844-46wlingerie2XLintlsize16.62511.625STOCK01000-10100P5179-1P-10all
8A03AC848-44CF-457E-95AD8E65FEFF3AF1FFA8C323-ADFA-4969-B05F081D4E534BB42384purple#9400D42XL2XL44-4614-1618-2046-4846-4844-4650-5246-4844-46wlingerie2XLintlsize16.62511.625STOCK01200-1000022all
9A03AC848-44CF-457E-95AD8E65FEFF3AF1587299F4-54B1-4949-B8CEA4BD481F008C2384white#FFFFFF2XL2XL44-4614-1618-2046-4846-4844-4650-5246-4844-46wlingerie2XLintlsize16.62511.625STOCK01000-10000-10all
10A03AC848-44CF-457E-95AD8E65FEFF3AF1A6C75CCC-642C-4481-AA73A8EAF3098F462385black#0000003XL3XL46-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie3XLintlsize16.62511.625STOCK01000-10200P5179-1P-10all
11A03AC848-44CF-457E-95AD8E65FEFF3AF1C5D954BF-9B56-4B42-AB41812EA4339B3D2385purple#9400D43XL3XL46-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie3XLintlsize16.62511.625STOCK01000-11000-10all
12A03AC848-44CF-457E-95AD8E65FEFF3AF16B65EE9C-C327-4CB7-A7A98EEA3384644A2385white#FFFFFF3XL3XL46-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie3XLintlsize16.62511.625STOCK01200-1000022all
subcategory
stringopenpanty
supplier
number-1
supplierreference
stringP5179-1P
tags
string
themes
stringhot,sexystrings
totalvariations
string
type
stringdefault
unitprice
number11.625
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 12.6 ms
Record Count: 12
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 = 'A03AC848-44CF-457E-95AD8E65FEFF3AF1' 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 = 'A03AC848-44CF-457E-95AD8E65FEFF3AF1' 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 = 'A03AC848-44CF-457E-95AD8E65FEFF3AF1' 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 = 'A03AC848-44CF-457E-95AD8E65FEFF3AF1' 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 = 'A03AC848-44CF-457E-95AD8E65FEFF3AF1' 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 = 'A03AC848-44CF-457E-95AD8E65FEFF3AF1' 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 = 'A03AC848-44CF-457E-95AD8E65FEFF3AF1'
and product_variations.isactive = 1
and product_sizes.id_size = 2382
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
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 = 'A03AC848-44CF-457E-95AD8E65FEFF3AF1' 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 = 'A03AC848-44CF-457E-95AD8E65FEFF3AF1' 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 = 'A03AC848-44CF-457E-95AD8E65FEFF3AF1' 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 = 'A03AC848-44CF-457E-95AD8E65FEFF3AF1' 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 = 'A03AC848-44CF-457E-95AD8E65FEFF3AF1' 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 = 'A03AC848-44CF-457E-95AD8E65FEFF3AF1' 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 = 'A03AC848-44CF-457E-95AD8E65FEFF3AF1'
and product_variations.isactive = 1
and product_sizes.id_size = 2383
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
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 = 'A03AC848-44CF-457E-95AD8E65FEFF3AF1' 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 = 'A03AC848-44CF-457E-95AD8E65FEFF3AF1' 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 = 'A03AC848-44CF-457E-95AD8E65FEFF3AF1' 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 = 'A03AC848-44CF-457E-95AD8E65FEFF3AF1' 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 = 'A03AC848-44CF-457E-95AD8E65FEFF3AF1' 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 = 'A03AC848-44CF-457E-95AD8E65FEFF3AF1' 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 = 'A03AC848-44CF-457E-95AD8E65FEFF3AF1'
and product_variations.isactive = 1
and product_sizes.id_size = 2384
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
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 = 'A03AC848-44CF-457E-95AD8E65FEFF3AF1' 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 = 'A03AC848-44CF-457E-95AD8E65FEFF3AF1' 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 = 'A03AC848-44CF-457E-95AD8E65FEFF3AF1' 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 = 'A03AC848-44CF-457E-95AD8E65FEFF3AF1' 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 = 'A03AC848-44CF-457E-95AD8E65FEFF3AF1' 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 = 'A03AC848-44CF-457E-95AD8E65FEFF3AF1' 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 = 'A03AC848-44CF-457E-95AD8E65FEFF3AF1'
and product_variations.isactive = 1
and product_sizes.id_size = 2385
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
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 = 'A03AC848-44CF-457E-95AD8E65FEFF3AF1' 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 = 'A03AC848-44CF-457E-95AD8E65FEFF3AF1' 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 = 'A03AC848-44CF-457E-95AD8E65FEFF3AF1' 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 = 'A03AC848-44CF-457E-95AD8E65FEFF3AF1' 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 = 'A03AC848-44CF-457E-95AD8E65FEFF3AF1' 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 = 'A03AC848-44CF-457E-95AD8E65FEFF3AF1' 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 = 'A03AC848-44CF-457E-95AD8E65FEFF3AF1'
and product_variations.isactive = 1
and product_sizes.id_size = 2380
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
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 = 'A03AC848-44CF-457E-95AD8E65FEFF3AF1' 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 = 'A03AC848-44CF-457E-95AD8E65FEFF3AF1' 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 = 'A03AC848-44CF-457E-95AD8E65FEFF3AF1' 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 = 'A03AC848-44CF-457E-95AD8E65FEFF3AF1' 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 = 'A03AC848-44CF-457E-95AD8E65FEFF3AF1' 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 = 'A03AC848-44CF-457E-95AD8E65FEFF3AF1' 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 = 'A03AC848-44CF-457E-95AD8E65FEFF3AF1'
and product_variations.isactive = 1
and product_sizes.id_size = 2381
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
18D6D54AA-11B9-4212-AF09C908DBCB37DF2382black#000000LL40-4210-1214-1642-4442-4440-4246-4842-4440-42wlingerieLintlsize16.62511.625STOCK01900-11100P5179-1PP5179-1P111588-19-117111.625all
2D305A2FB-693E-442D-A1B675E744F17F0C2382purple#9400D4LL40-4210-1214-1642-4442-4440-4246-4842-4440-42wlingerieLintlsize16.62511.625STOCK01100-1000011-19-12111.625all
385A5B233-7056-4224-BCF5F9A1F8C965C42382white#FFFFFFLL40-4210-1214-1642-4442-4440-4246-4842-4440-42wlingerieLintlsize16.62511.625STOCK01000-10000-10-19-12111.625all
42B4504E0-8E2B-46EA-982D2734091824702383black#000000XLXL42-4412-1416-1844-4644-4642-4448-5044-4642-44wlingerieXLintlsize16.62511.625STOCK01000-10100P5179-1PP5179-1P1117-10-10-117111.625all
546FCBE75-FB68-427E-911F76CC580F1E662383purple#9400D4XLXL42-4412-1416-1844-4644-4642-4448-5044-4642-44wlingerieXLintlsize16.62511.625STOCK01000-10000-10-10-12111.625all
621CE2D12-8223-4F27-94F3710EBC61451A2383white#FFFFFFXLXL42-4412-1416-1844-4644-4642-4448-5044-4642-44wlingerieXLintlsize16.62511.625STOCK01000-10000-10-10-12111.625all
72E6EA839-2EE7-4574-A537D4A865041BD02384black#0000002XL2XL44-4614-1618-2046-4846-4844-4650-5246-4844-46wlingerie2XLintlsize16.62511.625STOCK01000-10100P5179-1P-10-12-117111.625all
8FFA8C323-ADFA-4969-B05F081D4E534BB42384purple#9400D42XL2XL44-4614-1618-2046-4846-4844-4650-5246-4844-46wlingerie2XLintlsize16.62511.625STOCK01200-1000022-12-12111.625all
9587299F4-54B1-4949-B8CEA4BD481F008C2384white#FFFFFF2XL2XL44-4614-1618-2046-4846-4844-4650-5246-4844-46wlingerie2XLintlsize16.62511.625STOCK01000-10000-10-12-12111.625all
10A6C75CCC-642C-4481-AA73A8EAF3098F462385black#0000003XL3XL46-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie3XLintlsize16.62511.625STOCK01000-10200P5179-1P-10-11-117111.625all
11C5D954BF-9B56-4B42-AB41812EA4339B3D2385purple#9400D43XL3XL46-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie3XLintlsize16.62511.625STOCK01000-11000-10-11-12111.625all
126B65EE9C-C327-4CB7-A7A98EEA3384644A2385white#FFFFFF3XL3XL46-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie3XLintlsize16.62511.625STOCK01200-1000022-11-12111.625all
vatrate
number20
warehouse
string