Mijn mand

❌
Totaal aantal items
Winkelmand bekijken
Menu
Maten bekijken
Bella open onderbroek
Dubbelklikken om te vergroten
SKU: SBGA5500
Bella open onderbroek
Promo
Voorraad:

Met de sensualiteit van kant en de erotiek van een open ontwerp heeft deze groote maat slip alles om jou te behagen.

Maat:

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

Kleur:
Hoeveelheid:
24.95 € 19.95 €
Snelle verzending
voor de ongeduldigen...
Goed advies
via chat, facebook of e-mail
Gratis retourneren
binnen 15 dagen *

Bella groote maat open onderbroek

Productomschrijving

Bella slip

Elastisch kant, hoog getailleerd, met een prachtig sieraad aan de voorkant en een vetersluiting aan de achterkant.

Open bij het kruis.

Technische details

Beschikbaar maten

Beschikbaar van 1X/2X- tot 3X/4X

Beschikbare kleuren

Zwart , Donkerroze , Bladroos , Roze , Bordeaux en Rood

Maattabel

Controleer de juiste maat voor jou

Internationale
  • Borst
  • Maat
  • Heupen
1X/2X-
  • 104-110
  • 86-91
  • 112-120
3X/4X+
  • 128-132
  • 102-108
  • 132-138
XL
  • 99-104
  • 81-86
  • 107-112
1X/2X
  • 112-118
  • 92-96
  • 122-128
3X/4X
  • 120-128
  • 98-102
  • 128-132
To Top
Winkelmand bekijken
Artikelen
Totaal aantal items
Struct
Entries: 108
actions
Array
available
number12
brand
stringhouseofdesire
brandcode
stringhecs
branding
stringdivasboudoir
brandmedias
string{"default":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"editorial":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"logo":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""}}
brandmetas
Struct
de
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
el
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
en
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
es
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
fr
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
it
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
nl
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
pt
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
brandname
stringHouse of Desire
breasts
stringna
careinstructions
string
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: 0.99 ms
Record Count: 6
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,pink,deeprose,petalrose,red,burgundy') > 0
and product_variations.productuid = 'BD5DF547-6A36-4CFB-92EE358C24E0769E'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1blackcolorblakblackblack#00000022
2deeprosecolordrosdeeprosepink#880E4F33
3petalrosecolorprospetalrosepink#E2C4C400
4pinkcolorpinkpinkpink#FE70BD33
5burgundycolorburgburgundyred#80002011
6redcolorredredred#F5000033
colorrange
stringpink
colors
stringblack,pink,deeprose,petalrose,red,burgundy
colortype
stringcolor
comments
string
compositions
Struct
Entries: 13
coton
string
elastane
string
free
string
leather
string
lycra
string
metal
string
nylon
string
polyamide
string
polyester
string
polyurethane
string
silk
string
spandex
string
viscose
string
datecreated
Date Time (Europe/Paris)
{ts '2023-10-06 10:46:44'}
defect
number0
dimensions
Struct
Entries: 14
acrylicbones
string
backsideheight
string
diameter
string
flatsteelbones
string
frontsideheight
string
fullheight
string
length
string
modestysize
string
panels
string
sides
string
spiralsteelbones
string
totallength
string
unit
stringcm
wiresize
string
display
stringall
displayfrom
string
displayto
string
grossweight
string
hasbrandinfos
booleanfalse
hascareinstructions
booleanfalse
hascolorinfos
booleantrue
hascompositions
booleanfalse
hasdescription
booleantrue
hasdimensions
booleanfalse
hasmaterials
booleanfalse
hasotherspecifications
booleanfalse
haspromo
number1
hasshortdescription
booleantrue
hassizeinfos
booleantrue
hasspecifications
booleanfalse
hasstockinfos
booleanfalse
hasstylingtips
booleanfalse
hasusageinstructions
booleanfalse
hasvariations
booleantrue
import
string
inpromo
number18
instockvariations
number18
isactive
number1
iscustommade
number0
isdivasize
number0
isfirstprice
number0
isfixedprice
number0
ishot
number0
isnew
number0
isonline
number0
isoutletprice
number0
itemprice
number20.7917
itempromo
number16.625
key
stringculotte-bella
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-11-03 16:54:12'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.614 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('bd5df547-6a36-4cfb-92ee358c24e0769e',lcase(cart_actions.linkedproducts)) > 0 and cart_actions.linkedproducts is not null
)
id_actionbrandinglanguagenamecodetypeminimumOrdermaximumOrderminimumItemsmaximumItemsmaximumUseallowedItemsquotasusedCountlinkedproductslinkedthemeslinkedbrandslinkeditemparamsactiveFromactiveToisActive
linkedproducts
Query
Template: /system/api/products.cfc:1305
Execution Time: 1.33 ms
Record Count: 0
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select products.productuid as productuid, products.reference, 'default' as type, products.key, products.language, products.name,
product_links.linkuid,
products.colors, products.vatrate, products.metadatas, products.dimensions,
products.mediadatas, products.tags, products.themes, products.isdivasize,
count(distinct product_variations.variationuid) as totalvariations,
group_concat(distinct product_variations.variationuid) as variationlist,
count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END) as inpromo,
if(count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END)>0,1,0) as haspromo,
(select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0) END)) as itempromo,
IFNULL(min(product_variations.itemprice),0) as itemprice,
(select IF (products.isfixedprice = 0 and sum(product_variations.itempromo) > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null), IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0), IFNULL(min(NULLIF(product_variations.itemprice, 0)), 0) )) as unitprice,
count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.itempromo ELSE product_variations.itemprice END) as prices,
(select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN min(NULLIF(product_variations.promountil, 0)) END)) as promountil,
products.isfixedprice, products.ishot, products.isnew, if(products.orderidx > 0, products.orderidx, 999999999) as orderidx,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
count(distinct CASE WHEN ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) > 0 OR ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) <= 0 AND product_variations.supplier = 0)) THEN product_variations.variationuid END) as instockvariations,
products.brand, brands.name as brandname, IFNULL(brands.ispublic, 0) as showbrand, brands.display,
product_categories.sizetype,GROUP_CONCAT(DISTINCT product_sizes.suppliersize) as intlsize,products.sizes,product_sizes.sizerange,product_categories.mediadatas as categorymediadatas, product_categories.sizerange as categorysizerange,
product_categorymap.section, product_categorymap.category, product_categorymap.key as subcategory
from products
left outer join product_categorymap on products.productuid = product_categorymap.productuid
left outer join product_categories on (product_categories.branding = product_categorymap.branding and product_categories.section = product_categorymap.section and product_categories.category = product_categorymap.category and product_categories.key = product_categorymap.key)
left outer join product_sizes on product_sizes.id_size IN (products.sizes)
left outer join brands on products.brand = brands.brand
left outer join product_variations on product_variations.productuid = products.productuid and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
left outer join product_links on product_links.reference = products.reference
where products.isactive = 1 and products.isdeleted = 0
and brands.isactive = 1 and brands.isdeleted = 0
and product_categories.isactive = 1 and product_categories.isdeleted = 0
and product_variations.isactive = 1
and FIND_IN_SET('divasboudoir',products.branding)
and product_categories.branding IN ('all','divasboudoir')
and product_categorymap.branding IN ('all','divasboudoir')
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and products.language in ('all','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 <> 'SBGA5500'
group by products.reference
order by products.ishot desc, products.isnew desc, orderidx asc, products.lastupdated desc
productuidreferencetypekeylanguagenamelinkuidcolorsvatratemetadatasdimensionsmediadatastagsthemesisdivasizetotalvariationsvariationlistinpromohaspromoitempromoitempriceunitpricepricespromountilisfixedpriceishotisneworderidxavailablestockinstockvariationsbrandbrandnameshowbranddisplaysizetypeintlsizesizessizerangecategorymediadatascategorysizerangesectioncategorysubcategory
linkuid
string
materials
string
mediadatas
Struct
alt
Struct
height
string856
isprivate
string0
rating
stringall
src
string/photobank/products/hecs/sbga5500/fde023b07fa6664417b274104b8d9cda.jpg
type
stringimg
width
string642
back
Struct
height
string856
isprivate
string0
rating
stringall
src
string/photobank/products/hecs/sbga5500/d35df7424f8fb90e4dc16aa3d62f02ac.jpg
type
stringimg
width
string642
default
Struct
height
string3947
isprivate
string0
rating
stringall
src
string/photobank/products/hecs/sbga5500/hd02209b-blak-xb.jpg
type
stringimg
width
string2731
variations
Struct
colors
Struct
black
Struct
height
string4189
isprivate
string0
rating
stringall
src
string/photobank/products/hecs/sbga5500/hd02209b-blak-xf.jpg
type
stringimg
width
string2898
burgundy
Struct
height
string1952
isprivate
string0
rating
stringall
src
string/photobank/products/hecs/sbga5500/30292820-1-1.png
type
stringimg
width
string1344
deeprose
Struct
height
string856
isprivate
string0
rating
stringall
src
string/photobank/products/hecs/sbga5500/3e79e8aa9728f12785e6ee3ed4c73103dd.jpg
type
stringimg
width
string642
petalrose
Struct
height
string542
isprivate
string0
rating
stringall
src
string/photobank/products/hecs/sbga5500/b89992830756d76a3cd7bd2f72ef606d.jpg
type
stringimg
width
string375
pink
Struct
height
string856
isprivate
string0
rating
stringall
src
string/photobank/products/hecs/sbga5500/fde023b07fa6664417b274104b8d9cda.jpg
type
stringimg
width
string642
red
Struct
height
string4338
isprivate
string0
rating
stringall
src
string/photobank/products/hecs/sbga5500/hd02209b-sred-xb.jpg
type
stringimg
width
string3001
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-rosa-dunkelrosa-petalrose-rot-ou-bordeaux
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-roz-skoyro-roz-petalo-triantafyllo-kokkino-ou-mpornto
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-pink-deep-rose-petal-rose-red-ou-burgundy
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-rosa-rosa-oscuro-rosa-petalo-rojo-ou-burdeos
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-rose-rose-fonce-rose-petale-rouge-ou-bordeaux
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-rosa-rosa-scuro-petalo-di-rosa-rosso-ou-bordeaux
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-roze-donkerroze-bladroos-rood-ou-bordeaux
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-cor-de-rosa-rosa-escuro-rosa-petala-vermelho-ou-bordeaux
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
divasboudoir
Struct
de
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringBella Slip<br /><br />Aus elastischer Spitze, hochtailliert geschnitten und mit einem wundersch&ouml;nen Schmuckst&uuml;ck auf der Vorderseite und einer Schn&uuml;rung auf der R&uuml;ckseite verziert.<br /><br />Im Schritt offen.
guid
stringhttps://dev.divasboudoir.com/de/bella-offener-slip,-grosse-grosse-schwarz-rosa-dunkelrosa-petalrose-rot-ou-bordeaux/sbga5500.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringDie ganze Sinnlichkeit der Spitze und die ganze Erotik eines offenen Designs - dieser Slip in Übergröße hat alles, um Ihnen zu gefallen.
keywords
string
title
stringBella Offener Slip, große Größe
seotitle
stringBella Offener Slip, große Größe
seouri
stringbella-offener-slip,-grosse-grosse-schwarz-rosa-dunkelrosa-petalrose-rot-ou-bordeaux
specifications
string
stylingtips
string
summary
stringDie ganze Sinnlichkeit der Spitze und die ganze Erotik eines offenen Designs - dieser Slip in &Uuml;bergr&ouml;&szlig;e hat alles, um Ihnen zu gefallen.
title
stringBella Offener Slip
usageinstructions
string
el
Struct
Entries: 15
abstract
string
careinstructions
string
description
string&Epsilon;&sigma;ώ&rho;&omicron;&upsilon;&chi;&alpha; Bella<br /><br />&Epsilon;&lambda;&alpha;&sigma;&tau;&iota;&kappa;ή &delta;&alpha;&nu;&tau;έ&lambda;&alpha;, &psi;&eta;&lambda;ό&mu;&epsilon;&sigma;&eta;, &mu;&epsilon; &upsilon;&pi;έ&rho;&omicron;&chi;&omicron; &kappa;ό&sigma;&mu;&eta;&mu;&alpha; &sigma;&tau;&omicron; &mu;&pi;&rho;&omicron;&sigma;&tau;&iota;&nu;ό &mu;έ&rho;&omicron;&sigmaf; &kappa;&alpha;&iota; &kappa;&omicron;&rho;&delta;ό&nu;&iota;&alpha; &sigma;&tau;&omicron; &pi;ί&sigma;&omega; &mu;έ&rho;&omicron;&sigmaf;.<br /><br />&Alpha;&nu;&omicron;&iota;&chi;&tau;ό &sigma;&tau;&omicron;&nu; &kappa;&alpha;&beta;ά&lambda;&omicron;.
guid
stringhttps://dev.divasboudoir.com/el/bella-megalo-anoichto-vraki-mayro-roz-skoyro-roz-petalo-triantafyllo-kokkino-ou-mpornto/sbga5500.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringΜε όλο τον αισθησιασμό της δαντέλας και τον ερωτισμό του ανοιχτού σχεδίου, αυτά τα εσώρουχα plus-size έχουν τα πάντα για να σας ικανοποιήσουν.
keywords
string
title
stringBella μεγάλο ανοιχτό βρακί
seotitle
stringBella μεγάλο ανοιχτό βρακί
seouri
stringbella-megalo-anoichto-vraki-mayro-roz-skoyro-roz-petalo-triantafyllo-kokkino-ou-mpornto
specifications
string
stylingtips
string
summary
string&Mu;&epsilon; ό&lambda;&omicron; &tau;&omicron;&nu; &alpha;&iota;&sigma;&theta;&eta;&sigma;&iota;&alpha;&sigma;&mu;ό &tau;&eta;&sigmaf; &delta;&alpha;&nu;&tau;έ&lambda;&alpha;&sigmaf; &kappa;&alpha;&iota; &tau;&omicron;&nu; &epsilon;&rho;&omega;&tau;&iota;&sigma;&mu;ό &tau;&omicron;&upsilon; &alpha;&nu;&omicron;&iota;&chi;&tau;&omicron;ύ &sigma;&chi;&epsilon;&delta;ί&omicron;&upsilon;, &alpha;&upsilon;&tau;ά &tau;&alpha; &epsilon;&sigma;ώ&rho;&omicron;&upsilon;&chi;&alpha; plus-size έ&chi;&omicron;&upsilon;&nu; &tau;&alpha; &pi;ά&nu;&tau;&alpha; &gamma;&iota;&alpha; &nu;&alpha; &sigma;&alpha;&sigmaf; &iota;&kappa;&alpha;&nu;&omicron;&pi;&omicron;&iota;ή&sigma;&omicron;&upsilon;&nu;.
title
stringBella ανοιχτό βρακί
usageinstructions
string
en
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringBella panties<br /><br />Elastic lace, high-waisted, with a beautiful jewel at the front and lacing at the back.<br /><br />Open at crotch.
guid
stringhttps://dev.divasboudoir.com/en/bella-open-plus-size-panties-black-pink-deep-rose-petal-rose-red-ou-burgundy/sbga5500.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringAll the sensuality of lace and all the eroticism of an open design, these plus size panties have it all.
keywords
string
title
stringBella open plus size panties
seotitle
stringBella open plus size panties
seouri
stringbella-open-plus-size-panties-black-pink-deep-rose-petal-rose-red-ou-burgundy
specifications
string
stylingtips
string
summary
stringAll the sensuality of lace and all the eroticism of an open design, these plus size panties have it all.
title
stringBella Open Panties
usageinstructions
string
es
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringBraguita Bella<br /><br />De encaje el&aacute;stico, de talle alto, con una magn&iacute;fica joya delante y lazada detr&aacute;s.<br /><br />Abierta en la entrepierna.
guid
stringhttps://dev.divasboudoir.com/es/bragas-abiertas-talla-grande-bella-negro-rosa-rosa-oscuro-rosa-petalo-rojo-ou-burdeos/sbga5500.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringCon toda la sensualidad del encaje y el erotismo de un diseño abierto, estas braguitas de talla grande lo tienen todo para complacerte.
keywords
string
title
stringBragas abiertas talla grande Bella
seotitle
stringBragas abiertas talla grande Bella
seouri
stringbragas-abiertas-talla-grande-bella-negro-rosa-rosa-oscuro-rosa-petalo-rojo-ou-burdeos
specifications
string
stylingtips
string
summary
stringCon toda la sensualidad del encaje y el erotismo de un dise&ntilde;o abierto, estas braguitas de talla grande lo tienen todo para complacerte.
title
stringBella bragas abiertas
usageinstructions
string
fr
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>Culotte Bella&nbsp;<br><br>En dentelle &eacute;lastique, elle a une coupe taille haute et s'orne d'un superbe bijou &agrave; l'avant et d'un la&ccedil;age &agrave; l'arri&egrave;re.<br><br>Ouverte &agrave; l'entrejambe.</p>
guid
stringhttps://dev.divasboudoir.com/fr/culotte-grande-taille-ouverte-bella-noir-rose-rose-fonce-rose-petale-rouge-ou-bordeaux/sbga5500.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringToute la sensualité de la dentelle et tout l'érotisme d'un design ouvert, cette culotte grande taille a tout pour vous plaire.
keywords
string
title
stringCulotte grande taille Ouverte Bella
seotitle
stringCulotte grande taille Ouverte Bella
seouri
stringculotte-grande-taille-ouverte-bella-noir-rose-rose-fonce-rose-petale-rouge-ou-bordeaux
specifications
string
stylingtips
string
summary
string<p>Toute la sensualit&eacute; de la dentelle et tout l'&eacute;rotisme d'un design ouvert, cette culotte grande taille a tout pour vous plaire.</p>
title
stringCulotte Ouverte Bella 2
usageinstructions
string
it
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringMutandine Bella<br /><br />In pizzo elastico, a vita alta, con un superbo gioiello sul davanti e allacciatura sul retro.<br /><br />Aperto sul cavallo.
guid
stringhttps://dev.divasboudoir.com/it/bella-mutandine-aperte-di-taglia-grande-nero-rosa-rosa-scuro-petalo-di-rosa-rosso-ou-bordeaux/sbga5500.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringCon tutta la sensualità del pizzo e l'erotismo di un design aperto, queste mutandine per taglie grandi hanno tutto per soddisfarvi.
keywords
string
title
stringBella mutandine aperte di taglia grande
seotitle
stringBella mutandine aperte di taglia grande
seouri
stringbella-mutandine-aperte-di-taglia-grande-nero-rosa-rosa-scuro-petalo-di-rosa-rosso-ou-bordeaux
specifications
string
stylingtips
string
summary
stringCon tutta la sensualit&agrave; del pizzo e l'erotismo di un design aperto, queste mutandine per taglie grandi hanno tutto per soddisfarvi.
title
stringBella mutandine aperte
usageinstructions
string
nl
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringBella slip<br /><br />Elastisch kant, hoog getailleerd, met een prachtig sieraad aan de voorkant en een vetersluiting aan de achterkant.<br /><br />Open bij het kruis.
guid
stringhttps://dev.divasboudoir.com/nl/bella-groote-maat-open-onderbroek-zwart-roze-donkerroze-bladroos-rood-ou-bordeaux/sbga5500.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringMet de sensualiteit van kant en de erotiek van een open ontwerp heeft deze groote maat slip alles om jou te behagen.
keywords
string
title
stringBella groote maat open onderbroek
seotitle
stringBella groote maat open onderbroek
seouri
stringbella-groote-maat-open-onderbroek-zwart-roze-donkerroze-bladroos-rood-ou-bordeaux
specifications
string
stylingtips
string
summary
stringMet de sensualiteit van kant en de erotiek van een open ontwerp heeft deze groote maat slip alles om jou te behagen.
title
stringBella open onderbroek
usageinstructions
string
pt
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringCuecas Bella<br /><br />Renda el&aacute;stica, cintura alta, com uma joia soberba &agrave; frente e la&ccedil;o atr&aacute;s.<br /><br />Aberta na virilha.
guid
stringhttps://dev.divasboudoir.com/pt/calcinhas-grandes-abertas-bella-preto-cor-de-rosa-rosa-escuro-rosa-petala-vermelho-ou-bordeaux/sbga5500.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringCom toda a sensualidade da renda e o erotismo de um design aberto, estas cuecas plus size têm tudo para a agradar.
keywords
string
title
stringCalcinhas grandes abertas Bella
seotitle
stringCalcinhas grandes abertas Bella
seouri
stringcalcinhas-grandes-abertas-bella-preto-cor-de-rosa-rosa-escuro-rosa-petala-vermelho-ou-bordeaux
specifications
string
stylingtips
string
summary
stringCom toda a sensualidade da renda e o erotismo de um design aberto, estas cuecas plus size t&ecirc;m tudo para a agradar.
title
stringCuecas abertas Bella
usageinstructions
string
fetishboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz-rosa-dunkelrosa-petalrose-rot-ou-bordeaux
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-roz-skoyro-roz-petalo-triantafyllo-kokkino-ou-mpornto
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-pink-deep-rose-petal-rose-red-ou-burgundy
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-rosa-rosa-oscuro-rosa-petalo-rojo-ou-burdeos
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-rose-rose-fonce-rose-petale-rouge-ou-bordeaux
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-rosa-rosa-scuro-petalo-di-rosa-rosso-ou-bordeaux
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-roze-donkerroze-bladroos-rood-ou-bordeaux
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-cor-de-rosa-rosa-escuro-rosa-petala-vermelho-ou-bordeaux
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-rosa-dunkelrosa-petalrose-rot-ou-bordeaux
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-roz-skoyro-roz-petalo-triantafyllo-kokkino-ou-mpornto
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-pink-deep-rose-petal-rose-red-ou-burgundy
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-rosa-rosa-oscuro-rosa-petalo-rojo-ou-burdeos
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-rose-rose-fonce-rose-petale-rouge-ou-bordeaux
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-rosa-rosa-scuro-petalo-di-rosa-rosso-ou-bordeaux
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-roze-donkerroze-bladroos-rood-ou-bordeaux
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-cor-de-rosa-rosa-escuro-rosa-petala-vermelho-ou-bordeaux
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-rosa-dunkelrosa-petalrose-rot-ou-bordeaux
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-roz-skoyro-roz-petalo-triantafyllo-kokkino-ou-mpornto
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-pink-deep-rose-petal-rose-red-ou-burgundy
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-rosa-rosa-oscuro-rosa-petalo-rojo-ou-burdeos
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-rose-rose-fonce-rose-petale-rouge-ou-bordeaux
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-rosa-rosa-scuro-petalo-di-rosa-rosso-ou-bordeaux
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-roze-donkerroze-bladroos-rood-ou-bordeaux
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-cor-de-rosa-rosa-escuro-rosa-petala-vermelho-ou-bordeaux
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-rosa-dunkelrosa-petalrose-rot-ou-bordeaux
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-roz-skoyro-roz-petalo-triantafyllo-kokkino-ou-mpornto
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-pink-deep-rose-petal-rose-red-ou-burgundy
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-rosa-rosa-oscuro-rosa-petalo-rojo-ou-burdeos
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-rose-rose-fonce-rose-petale-rouge-ou-bordeaux
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-rosa-rosa-scuro-petalo-di-rosa-rosso-ou-bordeaux
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-roze-donkerroze-bladroos-rood-ou-bordeaux
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-cor-de-rosa-rosa-escuro-rosa-petala-vermelho-ou-bordeaux
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
smboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz-rosa-dunkelrosa-petalrose-rot-ou-bordeaux
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-roz-skoyro-roz-petalo-triantafyllo-kokkino-ou-mpornto
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-pink-deep-rose-petal-rose-red-ou-burgundy
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-rosa-rosa-oscuro-rosa-petalo-rojo-ou-burdeos
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-rose-rose-fonce-rose-petale-rouge-ou-bordeaux
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-rosa-rosa-scuro-petalo-di-rosa-rosso-ou-bordeaux
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-roze-donkerroze-bladroos-rood-ou-bordeaux
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-cor-de-rosa-rosa-escuro-rosa-petala-vermelho-ou-bordeaux
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
name
stringCulotte BELLA
netweight
string
nextshipment
stringtoday
ordered
number64
orderidx
number0
origin
string
originalsize
string
packaging
number0
productshipment
stringauto
productuid
stringBD5DF547-6A36-4CFB-92EE358C24E0769E
promountil
string
rating
stringnone
recorduid
stringBD5DF547-6A36-4CFB-92EE358C24E0769E
reference
stringSBGA5500
related
string
reserved
number1
returned
number0
returnsallowed
number1
section
stringlingerie
shipment
string5to7days
showbrand
number0
sizeinfos
Query
Template: /system/api/product/sizes.cfc:20
Execution Time: 2.25 ms
Record Count: 30
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,'2069,2074,2067,2073,2075') > 0
and product_variations.productuid = 'BD5DF547-6A36-4CFB-92EE358C24E0769E'
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
120741X/2X-intlsizered1X/2X222wpluslingerie1X/2X1X/2X-42-4412-1416-1844-4644-4642-4446-4844-4642-44104-11086-91112-120
220741X/2X-intlsizeblack1X/2X111wpluslingerie1X/2X1X/2X-42-4412-1416-1844-4644-4642-4446-4844-4642-44104-11086-91112-120
320741X/2X-intlsizedeeprose1X/2X111wpluslingerie1X/2X1X/2X-42-4412-1416-1844-4644-4642-4446-4844-4642-44104-11086-91112-120
420741X/2X-intlsizepink1X/2X111wpluslingerie1X/2X1X/2X-42-4412-1416-1844-4644-4642-4446-4844-4642-44104-11086-91112-120
520741X/2X-intlsizepetalrose1X/2X000wpluslingerie1X/2X1X/2X-42-4412-1416-1844-4644-4642-4446-4844-4642-44104-11086-91112-120
620741X/2X-intlsizeburgundy1X/2X000wpluslingerie1X/2X1X/2X-42-4412-1416-1844-4644-4642-4446-4844-4642-44104-11086-91112-120
720753X/4X+intlsizeblack3X/4X+3X/4X+111wpluslingerie3X/4X3X/4X+50-5220-2224-2852-5452-5450-5256-5852-5450-52128-132102-108132-138
820753X/4X+intlsizedeeprose3X/4X+3X/4X+111wpluslingerie3X/4X3X/4X+50-5220-2224-2852-5452-5450-5256-5852-5450-52128-132102-108132-138
920753X/4X+intlsizepink3X/4X+3X/4X+111wpluslingerie3X/4X3X/4X+50-5220-2224-2852-5452-5450-5256-5852-5450-52128-132102-108132-138
1020753X/4X+intlsizeburgundy3X/4X+3X/4X+111wpluslingerie3X/4X3X/4X+50-5220-2224-2852-5452-5450-5256-5852-5450-52128-132102-108132-138
1120753X/4X+intlsizered3X/4X+3X/4X+000wpluslingerie3X/4X3X/4X+50-5220-2224-2852-5452-5450-5256-5852-5450-52128-132102-108132-138
1220753X/4X+intlsizepetalrose3X/4X+3X/4X+000wpluslingerie3X/4X3X/4X+50-5220-2224-2852-5452-5450-5256-5852-5450-52128-132102-108132-138
132069XLintlsizedeeproseXLXL111wpluslingerieXLXL40-4210-1214-1642-4442-4440-4246-4842-4440-4299-10481-86107-112
142069XLintlsizepinkXLXL111wpluslingerieXLXL40-4210-1214-1642-4442-4440-4246-4842-4440-4299-10481-86107-112
152069XLintlsizeredXLXL111wpluslingerieXLXL40-4210-1214-1642-4442-4440-4246-4842-4440-4299-10481-86107-112
162069XLintlsizeburgundyXLXL000wpluslingerieXLXL40-4210-1214-1642-4442-4440-4246-4842-4440-4299-10481-86107-112
172069XLintlsizepetalroseXLXL000wpluslingerieXLXL40-4210-1214-1642-4442-4440-4246-4842-4440-4299-10481-86107-112
182069XLintlsizeblackXLXL000wpluslingerieXLXL40-4210-1214-1642-4442-4440-4246-4842-4440-4299-10481-86107-112
1920671X/2Xintlsizered1X/2X1X/2X222wpluslingerie1X/2X1X/2X46-4816-1820-2248-5048-5046-4852-5448-5046-48112-11892-96122-128
2020671X/2Xintlsizeblack1X/2X1X/2X111wpluslingerie1X/2X1X/2X46-4816-1820-2248-5048-5046-4852-5448-5046-48112-11892-96122-128
2120671X/2Xintlsizedeeprose1X/2X1X/2X111wpluslingerie1X/2X1X/2X46-4816-1820-2248-5048-5046-4852-5448-5046-48112-11892-96122-128
2220671X/2Xintlsizepink1X/2X1X/2X111wpluslingerie1X/2X1X/2X46-4816-1820-2248-5048-5046-4852-5448-5046-48112-11892-96122-128
2320671X/2Xintlsizeburgundy1X/2X1X/2X000wpluslingerie1X/2X1X/2X46-4816-1820-2248-5048-5046-4852-5448-5046-48112-11892-96122-128
2420671X/2Xintlsizepetalrose1X/2X1X/2X000wpluslingerie1X/2X1X/2X46-4816-1820-2248-5048-5046-4852-5448-5046-48112-11892-96122-128
2520733X/4Xintlsizepink3X/4X3X/4X111wpluslingerie3X/4X3X/4X48-5018-2022-2450-5250-5248-5054-5650-5248-50120-12898-102128-132
2620733X/4Xintlsizeburgundy3X/4X3X/4X111wpluslingerie3X/4X3X/4X48-5018-2022-2450-5250-5248-5054-5650-5248-50120-12898-102128-132
2720733X/4Xintlsizeblack3X/4X3X/4X111wpluslingerie3X/4X3X/4X48-5018-2022-2450-5250-5248-5054-5650-5248-50120-12898-102128-132
2820733X/4Xintlsizedeeprose3X/4X3X/4X111wpluslingerie3X/4X3X/4X48-5018-2022-2450-5250-5248-5054-5650-5248-50120-12898-102128-132
2920733X/4Xintlsizepetalrose3X/4X3X/4X000wpluslingerie3X/4X3X/4X48-5018-2022-2450-5250-5248-5054-5650-5248-50120-12898-102128-132
3020733X/4Xintlsizered3X/4X3X/4X000wpluslingerie3X/4X3X/4X48-5018-2022-2450-5250-5248-5054-5650-5248-50120-12898-102128-132
sizeranges
stringplus
sizes
string2069,2074,2067,2073,2075
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
number12
stocks
Query
Template: /system/api/product/stocks.cfc:25
Execution Time: 58.7 ms
Record Count: 18
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 = 'BD5DF547-6A36-4CFB-92EE358C24E0769E'
and product_variations.isactive = 1
and product_sizes.id_size = 2069
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 = 'BD5DF547-6A36-4CFB-92EE358C24E0769E'
and product_variations.isactive = 1
and product_sizes.id_size = 2074
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 = 'BD5DF547-6A36-4CFB-92EE358C24E0769E'
and product_variations.isactive = 1
and product_sizes.id_size = 2067
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 = 'BD5DF547-6A36-4CFB-92EE358C24E0769E'
and product_variations.isactive = 1
and product_sizes.id_size = 2073
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 = 'BD5DF547-6A36-4CFB-92EE358C24E0769E'
and product_variations.isactive = 1
and product_sizes.id_size = 2075
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
1BD5DF547-6A36-4CFB-92EE358C24E0769EF7E36532-5B44-4F0D-BBC285111A6AE36B2074black#0000001X/2X1X/2X-42-4412-1416-1844-4644-4642-4446-4844-4642-44wlingerie1X/2X-intlsize20.791716.625STOCK01100002100HD02209B-BLAK84031285028911all
2BD5DF547-6A36-4CFB-92EE358C24E0769E78D29901-00D4-49DA-B40C971CAC5923EB2074burgundy#8000201X/2X1X/2X-42-4412-1416-1844-4644-4642-4446-4844-4642-44wlingerie1X/2X-intlsize20.791716.625STOCK0100000200HD02209B-RDDN84031284755500all
3BD5DF547-6A36-4CFB-92EE358C24E0769EC58D0652-471E-4352-8ADD627C3ECE30302074deeprose#880E4F1X/2X1X/2X-42-4412-1416-1844-4644-4642-4446-4844-4642-44wlingerie1X/2X-intlsize20.791716.625STOCK0110000000HD02209B-PNKD84031289525911all
4BD5DF547-6A36-4CFB-92EE358C24E0769ED06076DF-8CBB-464B-B706E4AD3D8299042074petalrose#E2C4C41X/2X1X/2X-42-4412-1416-1844-4644-4642-4446-4844-4642-44wlingerie1X/2X-intlsize20.791716.625STOCK0100000000HD02209B00all
5BD5DF547-6A36-4CFB-92EE358C24E0769E02DC8EF8-9367-4229-BAB09819D543397B2074pink#FE70BD1X/2X1X/2X-42-4412-1416-1844-4644-4642-4446-4844-4642-44wlingerie1X/2X-intlsize20.791716.625STOCK0110000200HD02209B-FPNK84031289954711all
6BD5DF547-6A36-4CFB-92EE358C24E0769E9B41963B-D5E7-4E9B-BFA5923CB19D4D8B2074red#F500001X/2X1X/2X-42-4412-1416-1844-4644-4642-4446-4844-4642-44wlingerie1X/2X-intlsize20.791716.625STOCK01200001000HD02209B-CRRD84031281507322all
7BD5DF547-6A36-4CFB-92EE358C24E0769E46F42419-3D18-4607-99BA01783958F3E52069black#000000XLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42wlingerieXLintlsize20.791716.625STOCK0110001400HD02209B-BLAK84031285027200all
8BD5DF547-6A36-4CFB-92EE358C24E0769E13482A85-6B0D-4608-9CC18ABB4A24BF882069burgundy#800020XLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42wlingerieXLintlsize20.791716.625STOCK0100000100HD02209B-RDDN84031284754800all
9BD5DF547-6A36-4CFB-92EE358C24E0769EBA1CDC2E-2949-4224-9EA52300957F1AC62069deeprose#880E4FXLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42wlingerieXLintlsize20.791716.625STOCK0110000000HD02209B-PNKD84031289524211all
10BD5DF547-6A36-4CFB-92EE358C24E0769E9FFF5D3A-E50B-4F42-8B8526A4A959045E2069petalrose#E2C4C4XLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42wlingerieXLintlsize20.791716.625STOCK0100000000HD02209B00all
11BD5DF547-6A36-4CFB-92EE358C24E0769E125ACBDA-59C4-4AC1-B893C4F892BCBB162069pink#FE70BDXLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42wlingerieXLintlsize20.791716.625STOCK0110000100HD02209B-FPNK84031289953011all
12BD5DF547-6A36-4CFB-92EE358C24E0769E488A8FC1-53B2-467C-B1475F9BC3CFCC812069red#F50000XLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42wlingerieXLintlsize20.791716.625STOCK0110000100HD02209B-CRRD84031289959211all
13BD5DF547-6A36-4CFB-92EE358C24E0769E20865A3A-0661-49F4-9678CB3B13BCE8582073black#0000003X/4X3X/4X48-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie3X/4Xintlsize20.791716.625STOCK01100001500HD02209B-BLAK84031285029611all
14BD5DF547-6A36-4CFB-92EE358C24E0769E330CA46B-CDDA-4E5A-89509AA370CDABD82073burgundy#8000203X/4X3X/4X48-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie3X/4Xintlsize20.791716.625STOCK0110000000HD02209B-RDDN84031284756211all
15BD5DF547-6A36-4CFB-92EE358C24E0769E40DE1E53-5EFF-42EB-8F1DBC7D7080800E2073deeprose#880E4F3X/4X3X/4X48-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie3X/4Xintlsize20.791716.625STOCK0110000000HD02209B-PNKD84031289526611all
16BD5DF547-6A36-4CFB-92EE358C24E0769E5CF1032A-36DA-4CE0-AB5C21AFE03333D82073petalrose#E2C4C43X/4X3X/4X48-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie3X/4Xintlsize20.791716.625STOCK0100000000HD02209B00all
17BD5DF547-6A36-4CFB-92EE358C24E0769E32449DD1-9C1B-45C0-8C4BAEADAE5A7B3E2073pink#FE70BD3X/4X3X/4X48-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie3X/4Xintlsize20.791716.625STOCK0110000000HD02209B-FPNK84031289955411all
18BD5DF547-6A36-4CFB-92EE358C24E0769E563181E3-38B5-4354-B060FB233413D6032073red#F500003X/4X3X/4X48-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie3X/4Xintlsize20.791716.625STOCK01000001100HD02209B-CRRD84031289961500all
subcategory
stringopenpanty
supplier
number0
supplierreference
stringHD02209B
tags
string
themes
stringsexystrings
totalvariations
number18
type
stringdefault
unitprice
number16.625
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 13.7 ms
Record Count: 30
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 = 'BD5DF547-6A36-4CFB-92EE358C24E0769E' 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 = 'BD5DF547-6A36-4CFB-92EE358C24E0769E' 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 = 'BD5DF547-6A36-4CFB-92EE358C24E0769E' 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 = 'BD5DF547-6A36-4CFB-92EE358C24E0769E' 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 = 'BD5DF547-6A36-4CFB-92EE358C24E0769E' 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 = 'BD5DF547-6A36-4CFB-92EE358C24E0769E' 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 = 'BD5DF547-6A36-4CFB-92EE358C24E0769E'
and product_variations.isactive = 1
and product_sizes.id_size = 2069
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 = 'BD5DF547-6A36-4CFB-92EE358C24E0769E' 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 = 'BD5DF547-6A36-4CFB-92EE358C24E0769E' 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 = 'BD5DF547-6A36-4CFB-92EE358C24E0769E' 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 = 'BD5DF547-6A36-4CFB-92EE358C24E0769E' 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 = 'BD5DF547-6A36-4CFB-92EE358C24E0769E' 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 = 'BD5DF547-6A36-4CFB-92EE358C24E0769E' 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 = 'BD5DF547-6A36-4CFB-92EE358C24E0769E'
and product_variations.isactive = 1
and product_sizes.id_size = 2074
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 = 'BD5DF547-6A36-4CFB-92EE358C24E0769E' 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 = 'BD5DF547-6A36-4CFB-92EE358C24E0769E' 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 = 'BD5DF547-6A36-4CFB-92EE358C24E0769E' 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 = 'BD5DF547-6A36-4CFB-92EE358C24E0769E' 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 = 'BD5DF547-6A36-4CFB-92EE358C24E0769E' 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 = 'BD5DF547-6A36-4CFB-92EE358C24E0769E' 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 = 'BD5DF547-6A36-4CFB-92EE358C24E0769E'
and product_variations.isactive = 1
and product_sizes.id_size = 2067
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 = 'BD5DF547-6A36-4CFB-92EE358C24E0769E' 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 = 'BD5DF547-6A36-4CFB-92EE358C24E0769E' 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 = 'BD5DF547-6A36-4CFB-92EE358C24E0769E' 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 = 'BD5DF547-6A36-4CFB-92EE358C24E0769E' 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 = 'BD5DF547-6A36-4CFB-92EE358C24E0769E' 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 = 'BD5DF547-6A36-4CFB-92EE358C24E0769E' 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 = 'BD5DF547-6A36-4CFB-92EE358C24E0769E'
and product_variations.isactive = 1
and product_sizes.id_size = 2073
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 = 'BD5DF547-6A36-4CFB-92EE358C24E0769E' 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 = 'BD5DF547-6A36-4CFB-92EE358C24E0769E' 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 = 'BD5DF547-6A36-4CFB-92EE358C24E0769E' 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 = 'BD5DF547-6A36-4CFB-92EE358C24E0769E' 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 = 'BD5DF547-6A36-4CFB-92EE358C24E0769E' 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 = 'BD5DF547-6A36-4CFB-92EE358C24E0769E' 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 = 'BD5DF547-6A36-4CFB-92EE358C24E0769E'
and product_variations.isactive = 1
and product_sizes.id_size = 2075
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
1F7E36532-5B44-4F0D-BBC285111A6AE36B2074black#0000001X/2X1X/2X-42-4412-1416-1844-4644-4642-4446-4844-4642-44wlingerie1X/2X-intlsize20.791716.625STOCK01100002100HD02209B-BLAK840312850289115522116.625all
278D29901-00D4-49DA-B40C971CAC5923EB2074burgundy#8000201X/2X1X/2X-42-4412-1416-1844-4644-4642-4446-4844-4642-44wlingerie1X/2X-intlsize20.791716.625STOCK0100000200HD02209B-RDDN840312847555005511116.625all
3C58D0652-471E-4352-8ADD627C3ECE30302074deeprose#880E4F1X/2X1X/2X-42-4412-1416-1844-4644-4642-4446-4844-4642-44wlingerie1X/2X-intlsize20.791716.625STOCK0110000000HD02209B-PNKD840312895259115533116.625all
4D06076DF-8CBB-464B-B706E4AD3D8299042074petalrose#E2C4C41X/2X1X/2X-42-4412-1416-1844-4644-4642-4446-4844-4642-44wlingerie1X/2X-intlsize20.791716.625STOCK0100000000HD02209B005500116.625all
502DC8EF8-9367-4229-BAB09819D543397B2074pink#FE70BD1X/2X1X/2X-42-4412-1416-1844-4644-4642-4446-4844-4642-44wlingerie1X/2X-intlsize20.791716.625STOCK0110000200HD02209B-FPNK840312899547115533116.625all
69B41963B-D5E7-4E9B-BFA5923CB19D4D8B2074red#F500001X/2X1X/2X-42-4412-1416-1844-4644-4642-4446-4844-4642-44wlingerie1X/2X-intlsize20.791716.625STOCK01200001000HD02209B-CRRD840312815073225533116.625all
720865A3A-0661-49F4-9678CB3B13BCE8582075black#0000003X/4X3X/4X+50-5220-2224-2852-5452-5450-5256-5852-5450-52wlingerie3X/4X+intlsize20.791716.625STOCK01100001500HD02209B-BLAK840312850296114422116.625all
8330CA46B-CDDA-4E5A-89509AA370CDABD82075burgundy#8000203X/4X3X/4X+50-5220-2224-2852-5452-5450-5256-5852-5450-52wlingerie3X/4X+intlsize20.791716.625STOCK0110000000HD02209B-RDDN840312847562114411116.625all
940DE1E53-5EFF-42EB-8F1DBC7D7080800E2075deeprose#880E4F3X/4X3X/4X+50-5220-2224-2852-5452-5450-5256-5852-5450-52wlingerie3X/4X+intlsize20.791716.625STOCK0110000000HD02209B-PNKD840312895266114433116.625all
105CF1032A-36DA-4CE0-AB5C21AFE03333D82075petalrose#E2C4C43X/4X3X/4X+50-5220-2224-2852-5452-5450-5256-5852-5450-52wlingerie3X/4X+intlsize20.791716.625STOCK0100000000HD02209B004400116.625all
1132449DD1-9C1B-45C0-8C4BAEADAE5A7B3E2075pink#FE70BD3X/4X3X/4X+50-5220-2224-2852-5452-5450-5256-5852-5450-52wlingerie3X/4X+intlsize20.791716.625STOCK0110000000HD02209B-FPNK840312899554114433116.625all
12563181E3-38B5-4354-B060FB233413D6032075red#F500003X/4X3X/4X+50-5220-2224-2852-5452-5450-5256-5852-5450-52wlingerie3X/4X+intlsize20.791716.625STOCK01000001100HD02209B-CRRD840312899615004433116.625all
1346F42419-3D18-4607-99BA01783958F3E52069black#000000XLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42wlingerieXLintlsize20.791716.625STOCK0110001400HD02209B-BLAK840312850272003322116.625all
1413482A85-6B0D-4608-9CC18ABB4A24BF882069burgundy#800020XLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42wlingerieXLintlsize20.791716.625STOCK0100000100HD02209B-RDDN840312847548003311116.625all
15BA1CDC2E-2949-4224-9EA52300957F1AC62069deeprose#880E4FXLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42wlingerieXLintlsize20.791716.625STOCK0110000000HD02209B-PNKD840312895242113333116.625all
169FFF5D3A-E50B-4F42-8B8526A4A959045E2069petalrose#E2C4C4XLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42wlingerieXLintlsize20.791716.625STOCK0100000000HD02209B003300116.625all
17125ACBDA-59C4-4AC1-B893C4F892BCBB162069pink#FE70BDXLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42wlingerieXLintlsize20.791716.625STOCK0110000100HD02209B-FPNK840312899530113333116.625all
18488A8FC1-53B2-467C-B1475F9BC3CFCC812069red#F50000XLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42wlingerieXLintlsize20.791716.625STOCK0110000100HD02209B-CRRD840312899592113333116.625all
19F7E36532-5B44-4F0D-BBC285111A6AE36B2067black#0000001X/2X1X/2X46-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie1X/2Xintlsize20.791716.625STOCK01100002100HD02209B-BLAK840312850289115522116.625all
2078D29901-00D4-49DA-B40C971CAC5923EB2067burgundy#8000201X/2X1X/2X46-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie1X/2Xintlsize20.791716.625STOCK0100000200HD02209B-RDDN840312847555005511116.625all
21C58D0652-471E-4352-8ADD627C3ECE30302067deeprose#880E4F1X/2X1X/2X46-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie1X/2Xintlsize20.791716.625STOCK0110000000HD02209B-PNKD840312895259115533116.625all
22D06076DF-8CBB-464B-B706E4AD3D8299042067petalrose#E2C4C41X/2X1X/2X46-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie1X/2Xintlsize20.791716.625STOCK0100000000HD02209B005500116.625all
2302DC8EF8-9367-4229-BAB09819D543397B2067pink#FE70BD1X/2X1X/2X46-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie1X/2Xintlsize20.791716.625STOCK0110000200HD02209B-FPNK840312899547115533116.625all
249B41963B-D5E7-4E9B-BFA5923CB19D4D8B2067red#F500001X/2X1X/2X46-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie1X/2Xintlsize20.791716.625STOCK01200001000HD02209B-CRRD840312815073225533116.625all
2520865A3A-0661-49F4-9678CB3B13BCE8582073black#0000003X/4X3X/4X48-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie3X/4Xintlsize20.791716.625STOCK01100001500HD02209B-BLAK840312850296114422116.625all
26330CA46B-CDDA-4E5A-89509AA370CDABD82073burgundy#8000203X/4X3X/4X48-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie3X/4Xintlsize20.791716.625STOCK0110000000HD02209B-RDDN840312847562114411116.625all
2740DE1E53-5EFF-42EB-8F1DBC7D7080800E2073deeprose#880E4F3X/4X3X/4X48-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie3X/4Xintlsize20.791716.625STOCK0110000000HD02209B-PNKD840312895266114433116.625all
285CF1032A-36DA-4CE0-AB5C21AFE03333D82073petalrose#E2C4C43X/4X3X/4X48-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie3X/4Xintlsize20.791716.625STOCK0100000000HD02209B004400116.625all
2932449DD1-9C1B-45C0-8C4BAEADAE5A7B3E2073pink#FE70BD3X/4X3X/4X48-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie3X/4Xintlsize20.791716.625STOCK0110000000HD02209B-FPNK840312899554114433116.625all
30563181E3-38B5-4354-B060FB233413D6032073red#F500003X/4X3X/4X48-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie3X/4Xintlsize20.791716.625STOCK01000001100HD02209B-CRRD840312899615004433116.625all
vatrate
number20
warehouse
number13