Το καλάθι μου

❌
Σύνολο αντικειμένων
Προβολή καλαθιού
Μενού
Δείτε τα μεγέθη
Φόρεμα Muse
Διπλό κλικ για μεγέθυνση
SKU: CDBU9122
Φόρεμα Muse
MADE IN
Απόθεμα:

Ένα φόρεμα που θα γοητεύσει τους φίλους και την οικογένειά σας, είτε σε ιδιωτική είτε σε εξωτερική εκδήλωση, χάρη στον αποκλειστικό σχεδιασμό και την πρωτοτυπία του.

Μέγεθος:

Δεν είστε σίγουροι για το μέγεθος που πρέπει να επιλέξετε Συμβουλευτείτε τον οδηγό μεγεθών μας

Χρώμα:
Ποσότητα:
119.95 €
Βοήθεια και συμβουλές
μέσω chat, facebook ή e-mail
Δωρεάν επιστροφές
εντός 15 ημερών *

Φόρεμα Muse plus size

Περιγραφή του προϊόντος

Φόρεμα Muse

Λεπτό διχτυωτό μπούστο κεντημένο με φυτικά μοτίβα, μικρά μαζεμένα μανίκια για μια ρομαντική πινελιά.

Φαρδιά ζώνη για να σηματοδοτεί τη μέση σας και να τονίζει τις καμπύλες σας.

Ασύμμετρη φούστα, γεμάτη και όμορφα κομμένη.

Πλήρως φερμουάρ μπροστά.

Τεχνικές λεπτομέρειες

Διαθέσιμα μεγέθη

Διαθέσιμο από 3XL έως 6XL

Διαθέσιμο χρώμα

Μαύρο

Σύνθεση

Πολυεστέρας 76 %
Ελαστάν 24 %

Οδηγός διαστασιολόγησης

Ελέγξτε το σωστό μέγεθος για εσάς

Διεθνές
  • Στήθος
  • Μέγεθος
  • Γοφοί
3XL
  • 106-109
  • 85-88
  • 112-115
4XL
  • 110-113
  • 86-89
  • 116-119
5XL
  • 114-117
  • 90-93
  • 120-123
6XL
  • 118-121
  • 94-97
  • 124-127
To Top
Προβολή καλαθιού
Άρθρα
Σύνολο αντικειμένων
Struct
Entries: 108
actions
Array
available
number-1
brand
stringnoirhandmade
brandcode
stringnpzn
branding
stringdivasboudoir,smboudoir
brandmedias
string{"default":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"editorial":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"logo":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""}}
brandmetas
Struct
de
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
el
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
en
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
es
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
fr
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
it
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
nl
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
pt
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
brandname
stringNoir Handmade
breasts
stringna
careinstructions
string
categories
stringdivasboudoir.cabaret.dresses.all,divasboudoir.lingerie.sexylingerie.babydoll
category
stringdresses
categorygender
stringf
categorymediadatas
Struct
adult
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string615
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/cabaret/dresses1.jpg
type
stringimg
width
string1336
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.693 ms
Record Count: 1
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_colors.color as recorduid, product_colors.type, product_colors.code, product_colors.color, product_colors.range, product_colors.hexvalue,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock
from product_colors
left outer join product_variations on product_colors.color = product_variations.color and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
where FIND_IN_SET(product_colors.color,'black') > 0
and product_variations.productuid = '56CF35CE-213E-4A9C-A692CE4AF1C36C1A'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1blackcolorblakblackblack#000000-10
colorrange
stringblack
colors
stringblack
colortype
stringcolor
comments
string
compositions
Struct
Entries: 13
coton
string
elastane
string24
free
string
leather
string
lycra
string
metal
string
nylon
string
polyamide
string
polyester
string76
polyurethane
string
silk
string
spandex
string
viscose
string
datecreated
Date Time (Europe/Paris)
{ts '2022-06-01 13:20:03'}
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
booleantrue
hasdescription
booleantrue
hasdimensions
booleanfalse
hasmaterials
booleanfalse
hasotherspecifications
booleanfalse
haspromo
number0
hasshortdescription
booleantrue
hassizeinfos
booleantrue
hasspecifications
booleanfalse
hasstockinfos
booleanfalse
hasstylingtips
booleanfalse
hasusageinstructions
booleanfalse
hasvariations
booleantrue
import
string
inpromo
number0
instockvariations
string
isactive
number1
iscustommade
number0
isdivasize
number0
isfirstprice
number0
isfixedprice
number0
ishot
number0
isnew
number0
isonline
number0
isoutletprice
number0
itemprice
number99.9583
itempromo
string
key
stringf267
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-08-02 18:04:46'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.629 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','el')
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('56cf35ce-213e-4a9c-a692ce4af1c36c1a',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','el')
and product_categories.language in ('all','el')
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 <> 'CDBU9122'
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
string2048
isprivate
string0
rating
stringall
src
string/photobank/products/npzn/cdbu9122/21575924-3-1.jpg
type
stringimg
width
string1417
back
Struct
height
string1945
isprivate
string0
rating
stringall
src
string/photobank/products/npzn/cdbu9122/21575893-6-1.jpg
type
stringimg
width
string1345
default
Struct
height
string1210
isprivate
string0
rating
stringall
src
string/photobank/products/npzn/cdbu9122/21575911-1-1.jpg
type
stringimg
width
string837
variations
Struct
colors
Struct
black
Struct
height
string1210
isprivate
string0
rating
stringall
src
string/photobank/products/npzn/cdbu9122/21575911-1-1.jpg
type
stringimg
width
string837
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-noir-handmade-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-handmade-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-handmade-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-handmade-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-handmade-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-handmade-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-handmade-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-handmade-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
divasboudoir
Struct
de
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringKleid Muse<br /><br />Corsage aus feinem Netzstoff, zart bestickt mit Pflanzenmotiven, kleine geraffte &Auml;rmel f&uuml;r den romantischen Touch.<br /><br />Breiter G&uuml;rtel, der Ihre Taille betont und Ihre Kurven hervorhebt.<br /><br />Asymmetrischer, weit geschnittener Unterrock.<br /><br />Vorne mit Rei&szlig;verschluss.
guid
stringhttps://dev.divasboudoir.com/de/kleid-in-grossen-grossen-muse-noir-handmade-schwarz/cdbu9122.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringEin Kleid, das Ihre Umgebung privat oder beim Ausgehen dank seines exklusiven Designs und seiner Orginalität überwältigen wird.
keywords
string
title
stringKleid in großen Größen Muse
seotitle
stringKleid in großen Größen Muse
seouri
stringkleid-in-grossen-grossen-muse-noir-handmade-schwarz
specifications
string
stylingtips
string
summary
stringEin Kleid, das Ihre Umgebung privat oder beim Ausgehen dank seines exklusiven Designs und seiner Orginalit&auml;t &uuml;berw&auml;ltigen wird.
title
stringKleid Muse
usageinstructions
string
el
Struct
Entries: 15
abstract
string
careinstructions
string
description
string&Phi;ό&rho;&epsilon;&mu;&alpha; Muse<br /><br />&Lambda;&epsilon;&pi;&tau;ό &delta;&iota;&chi;&tau;&upsilon;&omega;&tau;ό &mu;&pi;&omicron;ύ&sigma;&tau;&omicron; &kappa;&epsilon;&nu;&tau;&eta;&mu;έ&nu;&omicron; &mu;&epsilon; &phi;&upsilon;&tau;&iota;&kappa;ά &mu;&omicron;&tau;ί&beta;&alpha;, &mu;&iota;&kappa;&rho;ά &mu;&alpha;&zeta;&epsilon;&mu;έ&nu;&alpha; &mu;&alpha;&nu;ί&kappa;&iota;&alpha; &gamma;&iota;&alpha; &mu;&iota;&alpha; &rho;&omicron;&mu;&alpha;&nu;&tau;&iota;&kappa;ή &pi;&iota;&nu;&epsilon;&lambda;&iota;ά.<br /><br />&Phi;&alpha;&rho;&delta;&iota;ά &zeta;ώ&nu;&eta; &gamma;&iota;&alpha; &nu;&alpha; &sigma;&eta;&mu;&alpha;&tau;&omicron;&delta;&omicron;&tau;&epsilon;ί &tau;&eta; &mu;έ&sigma;&eta; &sigma;&alpha;&sigmaf; &kappa;&alpha;&iota; &nu;&alpha; &tau;&omicron;&nu;ί&zeta;&epsilon;&iota; &tau;&iota;&sigmaf; &kappa;&alpha;&mu;&pi;ύ&lambda;&epsilon;&sigmaf; &sigma;&alpha;&sigmaf;.<br /><br />&Alpha;&sigma;ύ&mu;&mu;&epsilon;&tau;&rho;&eta; &phi;&omicron;ύ&sigma;&tau;&alpha;, &gamma;&epsilon;&mu;ά&tau;&eta; &kappa;&alpha;&iota; ό&mu;&omicron;&rho;&phi;&alpha; &kappa;&omicron;&mu;&mu;έ&nu;&eta;.<br /><br />&Pi;&lambda;ή&rho;&omega;&sigmaf; &phi;&epsilon;&rho;&mu;&omicron;&upsilon;ά&rho; &mu;&pi;&rho;&omicron;&sigma;&tau;ά.
guid
stringhttps://dev.divasboudoir.com/el/forema-muse-plus-size-noir-handmade-mayro/cdbu9122.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringΈνα φόρεμα που θα γοητεύσει τους φίλους και την οικογένειά σας, είτε σε ιδιωτική είτε σε εξωτερική εκδήλωση, χάρη στον αποκλειστικό σχεδιασμό και την πρωτοτυπία του.
keywords
string
title
stringΦόρεμα Muse plus size
seotitle
stringΦόρεμα Muse plus size
seouri
stringforema-muse-plus-size-noir-handmade-mayro
specifications
string
stylingtips
string
summary
stringΈ&nu;&alpha; &phi;ό&rho;&epsilon;&mu;&alpha; &pi;&omicron;&upsilon; &theta;&alpha; &gamma;&omicron;&eta;&tau;&epsilon;ύ&sigma;&epsilon;&iota; &tau;&omicron;&upsilon;&sigmaf; &phi;ί&lambda;&omicron;&upsilon;&sigmaf; &kappa;&alpha;&iota; &tau;&eta;&nu; &omicron;&iota;&kappa;&omicron;&gamma;έ&nu;&epsilon;&iota;ά &sigma;&alpha;&sigmaf;, &epsilon;ί&tau;&epsilon; &sigma;&epsilon; &iota;&delta;&iota;&omega;&tau;&iota;&kappa;ή &epsilon;ί&tau;&epsilon; &sigma;&epsilon; &epsilon;&xi;&omega;&tau;&epsilon;&rho;&iota;&kappa;ή &epsilon;&kappa;&delta;ή&lambda;&omega;&sigma;&eta;, &chi;ά&rho;&eta; &sigma;&tau;&omicron;&nu; &alpha;&pi;&omicron;&kappa;&lambda;&epsilon;&iota;&sigma;&tau;&iota;&kappa;ό &sigma;&chi;&epsilon;&delta;&iota;&alpha;&sigma;&mu;ό &kappa;&alpha;&iota; &tau;&eta;&nu; &pi;&rho;&omega;&tau;&omicron;&tau;&upsilon;&pi;ί&alpha; &tau;&omicron;&upsilon;.
title
stringΦόρεμα Muse
usageinstructions
string
en
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringMuse dress<br /><br />Fine fishnet bodice delicately embroidered with plant motifs, small gathered sleeves for a romantic touch.<br /><br />Wide belt marks your waist and enhances your curves.<br /><br />Asymmetrical skirt, full and beautifully cut.<br /><br />Fully-zipped front.
guid
stringhttps://dev.divasboudoir.com/en/muse-plus-size-dress-noir-handmade-black/cdbu9122.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringA dress that will captivate those around you, in private or out, thanks to its exclusive design and originality.
keywords
string
title
stringMuse plus size dress
seotitle
stringMuse plus size dress
seouri
stringmuse-plus-size-dress-noir-handmade-black
specifications
string
stylingtips
string
summary
stringA dress that will captivate those around you, in private or out, thanks to its exclusive design and originality.
title
stringMuse dress
usageinstructions
string
es
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringVestido Muse<br /><br />Fino corpi&ntilde;o de rejilla delicadamente bordado con motivos vegetales, peque&ntilde;as mangas fruncidas para un toque rom&aacute;ntico.<br /><br />Cintur&oacute;n ancho para marcar la cintura y realzar las curvas.<br /><br />Falda asim&eacute;trica, con volumen y de bonito corte.<br /><br />Cierre delantero con cremallera.
guid
stringhttps://dev.divasboudoir.com/es/vestido-talla-grande-muse-noir-handmade-negro/cdbu9122.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringUn vestido que cautivará a quienes te rodeen, ya sea en privado o fuera de él, gracias a su diseño exclusivo y a su originalidad.
keywords
string
title
stringVestido talla grande Muse
seotitle
stringVestido talla grande Muse
seouri
stringvestido-talla-grande-muse-noir-handmade-negro
specifications
string
stylingtips
string
summary
stringUn vestido que cautivar&aacute; a quienes te rodeen, ya sea en privado o fuera de &eacute;l, gracias a su dise&ntilde;o exclusivo y a su originalidad.
title
stringVestido Muse
usageinstructions
string
fr
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringRobe Muse<br /><br />Corsage en fine r&eacute;sille d&eacute;licatement brod&eacute;e de motifs v&eacute;g&eacute;taux, petites manches fronc&eacute;es pour le cot&eacute; romantique.<br /><br />Large ceinture qui marquera votre taille et sublimera vos rondeurs.<br /><br />Jupette asym&eacute;trique ample et joliment d&eacute;coup&eacute;e.<br /><br />Enti&egrave;rement zip&eacute;e &agrave; l'avant.
guid
stringhttps://dev.divasboudoir.com/fr/robe-grande-taille-muse-noir-handmade-noir/cdbu9122.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringUne robe qui subjuguera votre entourage, en privé ou en sortie grâce à son design exclusif et son orginalité.
keywords
string
title
stringRobe grande taille Muse - Fétichisme élégant
seotitle
stringRobe grande taille Muse
seouri
stringrobe-grande-taille-muse-noir-handmade-noir
specifications
string
stylingtips
string
summary
stringUne robe qui subjuguera votre entourage, en priv&eacute; ou en sortie gr&acirc;ce &agrave; son design exclusif et son orginalit&eacute;.
title
stringRobe Muse
usageinstructions
string
it
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringAbito Muse<br /><br />Corpetto a rete fine delicatamente ricamato con motivi vegetali, piccole maniche arricciate per un tocco romantico.<br /><br />Ampia cintura per segnare il punto vita e valorizzare le curve.<br /><br />Gonna asimmetrica, piena e dal taglio raffinato.<br /><br />Chiusura frontale con cerniera.
guid
stringhttps://dev.divasboudoir.com/it/abito-muse-taglia-grande-noir-handmade-nero/cdbu9122.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringUn abito che conquisterà chi vi circonda, sia in privato che fuori, grazie al suo design esclusivo e alla sua originalità.
keywords
string
title
stringAbito Muse taglia grande
seotitle
stringAbito Muse taglia grande
seouri
stringabito-muse-taglia-grande-noir-handmade-nero
specifications
string
stylingtips
string
summary
stringUn abito che conquister&agrave; chi vi circonda, sia in privato che fuori, grazie al suo design esclusivo e alla sua originalit&agrave;.
title
stringAbito Muse
usageinstructions
string
nl
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringJurk Muse<br /><br />Fijn lijfje van visnet, subtiel geborduurd met plantenmotieven, kleine mouwen met rimpels voor een romantische touch.<br /><br />Brede ceintuur om je taille te markeren en je rondingen te accentueren.<br /><br />Asymmetrische rok, vol en mooi gesneden.<br /><br />Voorkant met volledige rits.
guid
stringhttps://dev.divasboudoir.com/nl/muse-jurk-groote-maat-noir-handmade-zwart/cdbu9122.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringEen jurk die iedereen om je heen zal betoveren, of je nu privé bent of buiten, dankzij het exclusieve ontwerp en de originaliteit.
keywords
string
title
stringMuse jurk groote maat
seotitle
stringMuse jurk groote maat
seouri
stringmuse-jurk-groote-maat-noir-handmade-zwart
specifications
string
stylingtips
string
summary
stringEen jurk die iedereen om je heen zal betoveren, of je nu priv&eacute; bent of buiten, dankzij het exclusieve ontwerp en de originaliteit.
title
stringJurk Muse
usageinstructions
string
pt
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringVestido Muse<br /><br />Corpete em rede fina delicadamente bordado com motivos vegetais, pequenas mangas franzidas para um toque rom&acirc;ntico.<br /><br />Cinto largo para marcar a cintura e real&ccedil;ar as suas curvas.<br /><br />Saia assim&eacute;trica, cheia e com um corte bonito.<br /><br />Fecho de correr &agrave; frente.
guid
stringhttps://dev.divasboudoir.com/pt/vestido-muse-plus-size-noir-handmade-preto/cdbu9122.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringUm vestido que irá cativar todos os que a rodeiam, seja em privado ou fora dele, graças ao seu design exclusivo e originalidade.
keywords
string
title
stringVestido Muse plus size
seotitle
stringVestido Muse plus size
seouri
stringvestido-muse-plus-size-noir-handmade-preto
specifications
string
stylingtips
string
summary
stringUm vestido que ir&aacute; cativar todos os que a rodeiam, seja em privado ou fora dele, gra&ccedil;as ao seu design exclusivo e originalidade.
title
stringVestido Muse
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-noir-handmade-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-handmade-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-handmade-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-handmade-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-handmade-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-handmade-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-handmade-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-handmade-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
latexboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-handmade-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-handmade-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-handmade-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-handmade-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-handmade-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-handmade-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-handmade-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-handmade-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
legsboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-handmade-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-handmade-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-handmade-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-handmade-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-handmade-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-handmade-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-handmade-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-handmade-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
lustboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-handmade-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-handmade-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-handmade-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-handmade-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-handmade-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-handmade-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-handmade-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-handmade-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
smboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringKleid Muse<br /><br />Corsage aus feinem Netzstoff, zart bestickt mit Pflanzenmotiven, kleine geraffte &Auml;rmel f&uuml;r den romantischen Touch.<br /><br />Breiter G&uuml;rtel, der Ihre Taille betont und Ihre Kurven hervorhebt.<br /><br />Asymmetrischer, weit geschnittener Unterrock.<br /><br />Vorne mit Rei&szlig;verschluss.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringEin Kleid, das Ihre Umgebung privat oder beim Ausgehen dank seines exklusiven Designs und seiner Orginalität überwältigen wird.
keywords
string
title
stringKleid in großen Größen Muse
seotitle
stringKleid in großen Größen Muse
seouri
stringkleid-in-grossen-grossen-muse-noir-handmade-schwarz
specifications
string
stylingtips
string
summary
stringEin Kleid, das Ihre Umgebung privat oder beim Ausgehen dank seines exklusiven Designs und seiner Orginalit&auml;t &uuml;berw&auml;ltigen wird.
title
stringKleid Muse
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string&Phi;ό&rho;&epsilon;&mu;&alpha; Muse<br /><br />&Lambda;&epsilon;&pi;&tau;ό &delta;&iota;&chi;&tau;&upsilon;&omega;&tau;ό &mu;&pi;&omicron;ύ&sigma;&tau;&omicron; &kappa;&epsilon;&nu;&tau;&eta;&mu;έ&nu;&omicron; &mu;&epsilon; &phi;&upsilon;&tau;&iota;&kappa;ά &mu;&omicron;&tau;ί&beta;&alpha;, &mu;&iota;&kappa;&rho;ά &mu;&alpha;&zeta;&epsilon;&mu;έ&nu;&alpha; &mu;&alpha;&nu;ί&kappa;&iota;&alpha; &gamma;&iota;&alpha; &mu;&iota;&alpha; &rho;&omicron;&mu;&alpha;&nu;&tau;&iota;&kappa;ή &pi;&iota;&nu;&epsilon;&lambda;&iota;ά.<br /><br />&Phi;&alpha;&rho;&delta;&iota;ά &zeta;ώ&nu;&eta; &gamma;&iota;&alpha; &nu;&alpha; &sigma;&eta;&mu;&alpha;&tau;&omicron;&delta;&omicron;&tau;&epsilon;ί &tau;&eta; &mu;έ&sigma;&eta; &sigma;&alpha;&sigmaf; &kappa;&alpha;&iota; &nu;&alpha; &tau;&omicron;&nu;ί&zeta;&epsilon;&iota; &tau;&iota;&sigmaf; &kappa;&alpha;&mu;&pi;ύ&lambda;&epsilon;&sigmaf; &sigma;&alpha;&sigmaf;.<br /><br />&Alpha;&sigma;ύ&mu;&mu;&epsilon;&tau;&rho;&eta; &phi;&omicron;ύ&sigma;&tau;&alpha;, &gamma;&epsilon;&mu;ά&tau;&eta; &kappa;&alpha;&iota; ό&mu;&omicron;&rho;&phi;&alpha; &kappa;&omicron;&mu;&mu;έ&nu;&eta;.<br /><br />&Pi;&lambda;ή&rho;&omega;&sigmaf; &phi;&epsilon;&rho;&mu;&omicron;&upsilon;ά&rho; &mu;&pi;&rho;&omicron;&sigma;&tau;ά.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringΈνα φόρεμα που θα γοητεύσει τους φίλους και την οικογένειά σας, είτε σε ιδιωτική είτε σε εξωτερική εκδήλωση, χάρη στον αποκλειστικό σχεδιασμό και την πρωτοτυπία του.
keywords
string
title
stringΦόρεμα Muse plus size
seotitle
stringΦόρεμα Muse plus size
seouri
stringforema-muse-plus-size-noir-handmade-mayro
specifications
string
stylingtips
string
summary
stringΈ&nu;&alpha; &phi;ό&rho;&epsilon;&mu;&alpha; &pi;&omicron;&upsilon; &theta;&alpha; &gamma;&omicron;&eta;&tau;&epsilon;ύ&sigma;&epsilon;&iota; &tau;&omicron;&upsilon;&sigmaf; &phi;ί&lambda;&omicron;&upsilon;&sigmaf; &kappa;&alpha;&iota; &tau;&eta;&nu; &omicron;&iota;&kappa;&omicron;&gamma;έ&nu;&epsilon;&iota;ά &sigma;&alpha;&sigmaf;, &epsilon;ί&tau;&epsilon; &sigma;&epsilon; &iota;&delta;&iota;&omega;&tau;&iota;&kappa;ή &epsilon;ί&tau;&epsilon; &sigma;&epsilon; &epsilon;&xi;&omega;&tau;&epsilon;&rho;&iota;&kappa;ή &epsilon;&kappa;&delta;ή&lambda;&omega;&sigma;&eta;, &chi;ά&rho;&eta; &sigma;&tau;&omicron;&nu; &alpha;&pi;&omicron;&kappa;&lambda;&epsilon;&iota;&sigma;&tau;&iota;&kappa;ό &sigma;&chi;&epsilon;&delta;&iota;&alpha;&sigma;&mu;ό &kappa;&alpha;&iota; &tau;&eta;&nu; &pi;&rho;&omega;&tau;&omicron;&tau;&upsilon;&pi;ί&alpha; &tau;&omicron;&upsilon;.
title
stringΦόρεμα Muse
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringMuse dress<br /><br />Fine fishnet bodice delicately embroidered with plant motifs, small gathered sleeves for a romantic touch.<br /><br />Wide belt marks your waist and enhances your curves.<br /><br />Asymmetrical skirt, full and beautifully cut.<br /><br />Fully-zipped front.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringA dress that will captivate those around you, in private or out, thanks to its exclusive design and originality.
keywords
string
title
stringMuse plus size dress
seotitle
stringMuse plus size dress
seouri
stringmuse-plus-size-dress-noir-handmade-black
specifications
string
stylingtips
string
summary
stringA dress that will captivate those around you, in private or out, thanks to its exclusive design and originality.
title
stringMuse dress
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringVestido Muse<br /><br />Fino corpi&ntilde;o de rejilla delicadamente bordado con motivos vegetales, peque&ntilde;as mangas fruncidas para un toque rom&aacute;ntico.<br /><br />Cintur&oacute;n ancho para marcar la cintura y realzar las curvas.<br /><br />Falda asim&eacute;trica, con volumen y de bonito corte.<br /><br />Cierre delantero con cremallera.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringUn vestido que cautivará a quienes te rodeen, ya sea en privado o fuera de él, gracias a su diseño exclusivo y a su originalidad.
keywords
string
title
stringVestido talla grande Muse
seotitle
stringVestido talla grande Muse
seouri
stringvestido-talla-grande-muse-noir-handmade-negro
specifications
string
stylingtips
string
summary
stringUn vestido que cautivar&aacute; a quienes te rodeen, ya sea en privado o fuera de &eacute;l, gracias a su dise&ntilde;o exclusivo y a su originalidad.
title
stringVestido Muse
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Robe Muse<br><br>Corsage en fine r&eacute;sille d&eacute;licatement brod&eacute;e de motifs v&eacute;g&eacute;taux, petites manches fronc&eacute;es pour le cot&eacute; romantique.<br><br>Large ceinture qui marquera votre taille et sublimera vos rondeurs.<br><br>Jupette asym&eacute;trique ample et joliment d&eacute;coup&eacute;e.<br><br>Enti&egrave;rement zip&eacute;e &agrave; l'avant.</p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringUne robe qui subjuguera votre entourage, en privé ou en sortie grâce à son design exclusif et son orginalité.
keywords
string
title
stringRobe grande taille Muse - Fétichiste et Elegante
seotitle
stringRobe grande taille Muse
seouri
stringrobe-grande-taille-muse-noir-handmade-noir
specifications
string
stylingtips
string
summary
string<p>Une robe qui subjuguera votre entourage, en priv&eacute; ou en sortie gr&acirc;ce &agrave; son design exclusif et son orginalit&eacute;.</p>
title
stringRobe Muse
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringAbito Muse<br /><br />Corpetto a rete fine delicatamente ricamato con motivi vegetali, piccole maniche arricciate per un tocco romantico.<br /><br />Ampia cintura per segnare il punto vita e valorizzare le curve.<br /><br />Gonna asimmetrica, piena e dal taglio raffinato.<br /><br />Chiusura frontale con cerniera.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringUn abito che conquisterà chi vi circonda, sia in privato che fuori, grazie al suo design esclusivo e alla sua originalità.
keywords
string
title
stringAbito Muse taglia grande
seotitle
stringAbito Muse taglia grande
seouri
stringabito-muse-taglia-grande-noir-handmade-nero
specifications
string
stylingtips
string
summary
stringUn abito che conquister&agrave; chi vi circonda, sia in privato che fuori, grazie al suo design esclusivo e alla sua originalit&agrave;.
title
stringAbito Muse
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringJurk Muse<br /><br />Fijn lijfje van visnet, subtiel geborduurd met plantenmotieven, kleine mouwen met rimpels voor een romantische touch.<br /><br />Brede ceintuur om je taille te markeren en je rondingen te accentueren.<br /><br />Asymmetrische rok, vol en mooi gesneden.<br /><br />Voorkant met volledige rits.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringEen jurk die iedereen om je heen zal betoveren, of je nu privé bent of buiten, dankzij het exclusieve ontwerp en de originaliteit.
keywords
string
title
stringMuse jurk groote maat
seotitle
stringMuse jurk groote maat
seouri
stringmuse-jurk-groote-maat-noir-handmade-zwart
specifications
string
stylingtips
string
summary
stringEen jurk die iedereen om je heen zal betoveren, of je nu priv&eacute; bent of buiten, dankzij het exclusieve ontwerp en de originaliteit.
title
stringJurk Muse
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringVestido Muse<br /><br />Corpete em rede fina delicadamente bordado com motivos vegetais, pequenas mangas franzidas para um toque rom&acirc;ntico.<br /><br />Cinto largo para marcar a cintura e real&ccedil;ar as suas curvas.<br /><br />Saia assim&eacute;trica, cheia e com um corte bonito.<br /><br />Fecho de correr &agrave; frente.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringUm vestido que irá cativar todos os que a rodeiam, seja em privado ou fora dele, graças ao seu design exclusivo e originalidade.
keywords
string
title
stringVestido Muse plus size
seotitle
stringVestido Muse plus size
seouri
stringvestido-muse-plus-size-noir-handmade-preto
specifications
string
stylingtips
string
summary
stringUm vestido que ir&aacute; cativar todos os que a rodeiam, seja em privado ou fora dele, gra&ccedil;as ao seu design exclusivo e originalidade.
title
stringVestido Muse
usageinstructions
string
name
stringF267
netweight
string
nextshipment
stringtomorrow
ordered
number16
orderidx
number0
origin
stringeu
originalsize
string
packaging
string
productshipment
stringauto
productuid
string56CF35CE-213E-4A9C-A692CE4AF1C36C1A
promountil
string
rating
stringnone
recorduid
string56CF35CE-213E-4A9C-A692CE4AF1C36C1A
reference
stringCDBU9122
related
string
reserved
string
returned
number0
returnsallowed
number1
section
stringcabaret
shipment
string3to5days
showbrand
number1
sizeinfos
Query
Template: /system/api/product/sizes.cfc:20
Execution Time: 1.38 ms
Record Count: 4
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,'311,511,313,314') > 0
and product_variations.productuid = '56CF35CE-213E-4A9C-A692CE4AF1C36C1A'
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
13113XLintlsizeblack3XL3XL-19999990wpluslingerie3XL3XL44-4614-1618-2046-4846-4844-4650-5246-4844-46106-10985-88112-115
25114XLintlsizeblack4XL4XL-19999990wpluslingerie4XL4XL46-4816-1820-2248-5048-5046-4852-5448-5046-48110-11386-89116-119
33135XLintlsizeblack5XL5XL-19999990wpluslingerie5XL5XL48-5018-2022-2450-5250-5248-5054-5650-5248-50114-11790-93120-123
43146XLintlsizeblack6XL6XL-19999990wpluslingerie6XL6XL50-5220-2224-2852-5452-5450-5256-5852-5450-52118-12194-97124-127
sizeranges
stringplus
sizes
string311,511,313,314
sizetype
stringauto
specifications
Struct
Entries: 23
belly
string
bones
string
bra
string
breasts
string
bust
string
closing
string
crochtless
string
cups
string
cut
string
garter
string
halter
string
lacing
string
lining
string
modestypanel
string
panty
string
sheathing
string
sleeves
string
stocking
string
straps
string
stretch
string
suspenders
string
transparency
string
underwires
string
stock
number0
stocks
Query
Template: /system/api/product/stocks.cfc:25
Execution Time: 5.27 ms
Record Count: 4
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 = '56CF35CE-213E-4A9C-A692CE4AF1C36C1A'
and product_variations.isactive = 1
and product_sizes.id_size = 311
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 = '56CF35CE-213E-4A9C-A692CE4AF1C36C1A'
and product_variations.isactive = 1
and product_sizes.id_size = 511
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 = '56CF35CE-213E-4A9C-A692CE4AF1C36C1A'
and product_variations.isactive = 1
and product_sizes.id_size = 313
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 = '56CF35CE-213E-4A9C-A692CE4AF1C36C1A'
and product_variations.isactive = 1
and product_sizes.id_size = 314
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
156CF35CE-213E-4A9C-A692CE4AF1C36C1A9A1E8FE0-12DB-4F91-856C0E8A3FFC668C311black#0000003XL3XL44-4614-1618-2046-4846-4844-4650-5246-4844-46wlingerie3XLintlsize99.95830STOCK01000-10000271821910715903050109776-10all
256CF35CE-213E-4A9C-A692CE4AF1C36C1A3C7DC61A-F37B-4C0D-AA9719184254D630511black#0000004XL4XL46-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie4XLintlsize99.95830STOCK01000-10900271821910815903050109783-10all
356CF35CE-213E-4A9C-A692CE4AF1C36C1A75761FF7-A1E6-4150-A746EF946D91A1C9313black#0000005XL5XL48-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie5XLintlsize99.95830STOCK01000-10100271821913615903050109790-10all
456CF35CE-213E-4A9C-A692CE4AF1C36C1A483E6470-D516-47A9-9D763F0E203F7410314black#0000006XL6XL50-5220-2224-2852-5452-5450-5256-5852-5450-52wlingerie6XLintlsize99.95830STOCK01000-10600271821913715903050109806-10all
subcategory
stringall
supplier
number-1
supplierreference
string27182191081
tags
string
themes
stringdark,luxe
totalvariations
string
type
stringdefault
unitprice
number99.9583
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 7.3 ms
Record Count: 4
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 = '56CF35CE-213E-4A9C-A692CE4AF1C36C1A' 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 = '56CF35CE-213E-4A9C-A692CE4AF1C36C1A' 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 = '56CF35CE-213E-4A9C-A692CE4AF1C36C1A' 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 = '56CF35CE-213E-4A9C-A692CE4AF1C36C1A' 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 = '56CF35CE-213E-4A9C-A692CE4AF1C36C1A' 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 = '56CF35CE-213E-4A9C-A692CE4AF1C36C1A' 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 = '56CF35CE-213E-4A9C-A692CE4AF1C36C1A'
and product_variations.isactive = 1
and product_sizes.id_size = 311
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 = '56CF35CE-213E-4A9C-A692CE4AF1C36C1A' 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 = '56CF35CE-213E-4A9C-A692CE4AF1C36C1A' 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 = '56CF35CE-213E-4A9C-A692CE4AF1C36C1A' 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 = '56CF35CE-213E-4A9C-A692CE4AF1C36C1A' 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 = '56CF35CE-213E-4A9C-A692CE4AF1C36C1A' 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 = '56CF35CE-213E-4A9C-A692CE4AF1C36C1A' 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 = '56CF35CE-213E-4A9C-A692CE4AF1C36C1A'
and product_variations.isactive = 1
and product_sizes.id_size = 511
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 = '56CF35CE-213E-4A9C-A692CE4AF1C36C1A' 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 = '56CF35CE-213E-4A9C-A692CE4AF1C36C1A' 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 = '56CF35CE-213E-4A9C-A692CE4AF1C36C1A' 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 = '56CF35CE-213E-4A9C-A692CE4AF1C36C1A' 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 = '56CF35CE-213E-4A9C-A692CE4AF1C36C1A' 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 = '56CF35CE-213E-4A9C-A692CE4AF1C36C1A' 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 = '56CF35CE-213E-4A9C-A692CE4AF1C36C1A'
and product_variations.isactive = 1
and product_sizes.id_size = 313
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 = '56CF35CE-213E-4A9C-A692CE4AF1C36C1A' 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 = '56CF35CE-213E-4A9C-A692CE4AF1C36C1A' 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 = '56CF35CE-213E-4A9C-A692CE4AF1C36C1A' 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 = '56CF35CE-213E-4A9C-A692CE4AF1C36C1A' 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 = '56CF35CE-213E-4A9C-A692CE4AF1C36C1A' 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 = '56CF35CE-213E-4A9C-A692CE4AF1C36C1A' 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 = '56CF35CE-213E-4A9C-A692CE4AF1C36C1A'
and product_variations.isactive = 1
and product_sizes.id_size = 314
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
19A1E8FE0-12DB-4F91-856C0E8A3FFC668C311black#0000003XL3XL44-4614-1618-2046-4846-4844-4650-5246-4844-46wlingerie3XLintlsize99.95830STOCK01000-10000271821910715903050109776-10-10-10099.9583all
23C7DC61A-F37B-4C0D-AA9719184254D630511black#0000004XL4XL46-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie4XLintlsize99.95830STOCK01000-10900271821910815903050109783-10-10-10099.9583all
375761FF7-A1E6-4150-A746EF946D91A1C9313black#0000005XL5XL48-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie5XLintlsize99.95830STOCK01000-10100271821913615903050109790-10-10-10099.9583all
4483E6470-D516-47A9-9D763F0E203F7410314black#0000006XL6XL50-5220-2224-2852-5452-5450-5256-5852-5450-52wlingerie6XLintlsize99.95830STOCK01000-10600271821913715903050109806-10-10-10099.9583all
vatrate
number20
warehouse
string