Το καλάθι μου

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

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

Μέγεθος:

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

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

Φόρεμα από ψεύτικο δέρμα και δαντέλα συν μέγεθος

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

Κάντε μια δήλωση στυλ με το φόρεμα Urania, ένα κομψό και αισθησιακό κομμάτι σχεδιασμένο για να υποκαφέ και να αναδεικνύει κάθε σιλουέτα.

Κατασκευασμένο από ποιοτικό ελαστικό faux leather και διακοσμημένο με λεπτή φλοράλ δαντέλα, αυτό το φόρεμα προσφέρει εξαιρετική άνεση και μια εκλεπτυσμένη εμφάνιση για όλες τις ειδικές περιστάσεις σας. Είναι επιδέξια κομμένο για να αναδεικνύει τις καμπύλες σας, ενώ το ελαστικό faux leather αγκαλιάζει τη σιλουέτα σας χωρίς να τη στενεύει. Η φλοράλ δαντέλα στην πλάτη και τα μανίκια προσθέτουν μια πινελιά θηλυκότητας και ρομαντισμού.

Κλείνει πλήρως με φερμουάρ στην πλάτη για εύκολο πέρασμα και τέλεια στήριξη.

Λέξεις κλειδιά : Φόρεμα Similicuir, Φόρεμα με δαντέλα, Βραδινό φόρεμα, Κομψό φόρεμα, Αισθησιακό φόρεμα, Φόρεμα Cherry, Γυναικείο φόρεμα, Γυναικεία μόδα, Κοκτέιλ φόρεμα, Φλοράλ δαντέλα, Similicuir, Τάση μόδας, Βραδινό, Κομψό, Urania.

Γιατί να επιλέξετε αυτό το φόρεμα:

  • Το κόψιμο έχει σχεδιαστεί για να υποσκελίζει τις καμπύλες σας
  • Ελαστικό ψεύτικο δέρμα και απαλή δαντέλα για βέλτιστη άνεση
  • Μοναδικό και διεκδικητικό στυλ
  • Κατάλληλο για όλες τις περιστάσεις
  • Νιώστε όμορφα, κομψά και με αυτοπεποίθηση σε αυτό το εξαιρετικό φόρεμα

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

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

Διαθέσιμο από 38-40 έως 48-50

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

Μαύρο

Άλλες τεχνικές προδιαγραφές

Υλικά Ελαστική δαντέλα και Wetlook

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

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

Διεθνές
  • Στήθος
  • Μέγεθος
  • Γοφοί
38-40
  • 92-100
  • 74-82
  • 98-106
44-46
  • 102-108
  • 86-92
  • 108-114
48-50
  • 110-116
  • 96-102
  • 116-122
To Top
Προβολή καλαθιού
Άρθρα
Σύνολο αντικειμένων
Struct
Entries: 108
actions
Array
available
number-1
brand
stringparishollywood
brandcode
stringpuun
branding
stringdivasboudoir,smboudoir
brandmedias
string{"default":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"editorial":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"logo":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""}}
brandmetas
Struct
de
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
el
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
en
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
es
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
fr
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
it
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
nl
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
pt
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
brandname
stringParis Hollywood
breasts
stringna
careinstructions
string
categories
stringdivasboudoir.cabaret.dresses.all
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.675 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 = 'E795E7CF-CFA4-4DD1-8E07CA6C86DDA7C3'
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
string
free
string
leather
string
lycra
string
metal
string
nylon
string
polyamide
string
polyester
string
polyurethane
string
silk
string
spandex
string
viscose
string
datecreated
Date Time (Europe/Paris)
{ts '2025-03-06 16:18:50'}
defect
number0
dimensions
Struct
Entries: 14
acrylicbones
string
backsideheight
string
diameter
string
flatsteelbones
string
frontsideheight
string
fullheight
string
length
string
modestysize
string
panels
string
sides
string
spiralsteelbones
string
totallength
string
unit
stringcm
wiresize
string
display
stringall
displayfrom
string
displayto
string
grossweight
string
hasbrandinfos
booleanfalse
hascareinstructions
booleanfalse
hascolorinfos
booleantrue
hascompositions
booleanfalse
hasdescription
booleantrue
hasdimensions
booleanfalse
hasmaterials
booleantrue
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
number33.2917
itempromo
string
key
stringr81362
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-08-01 18:58:04'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.604 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('e795e7cf-cfa4-4dd1-8e07ca6c86dda7c3',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.27 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 <> 'CDBU5414'
group by products.reference
order by products.ishot desc, products.isnew desc, orderidx asc, products.lastupdated desc
productuidreferencetypekeylanguagenamelinkuidcolorsvatratemetadatasdimensionsmediadatastagsthemesisdivasizetotalvariationsvariationlistinpromohaspromoitempromoitempriceunitpricepricespromountilisfixedpriceishotisneworderidxavailablestockinstockvariationsbrandbrandnameshowbranddisplaysizetypeintlsizesizessizerangecategorymediadatascategorysizerangesectioncategorysubcategory
linkuid
string
materials
stringstretchlace,wetlook
mediadatas
Struct
alt
Struct
height
string733
isprivate
string0
rating
stringall
src
string/photobank/products/puun/cdbu5414/32020046.jpg
type
stringimg
width
string507
back
Struct
height
string1169
isprivate
string0
rating
stringall
src
string/photobank/products/puun/cdbu5414/32020062.jpg
type
stringimg
width
string808
default
Struct
height
string1269
isprivate
string0
rating
stringall
src
string/photobank/products/puun/cdbu5414/32020045.jpg
type
stringimg
width
string878
variations
Struct
colors
Struct
black
Struct
height
string1269
isprivate
string0
rating
stringall
src
string/photobank/products/puun/cdbu5414/32020045.jpg
type
stringimg
width
string878
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
mediagallery
string
metadatas
Struct
darkboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
divasboudoir
Struct
de
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Unterstreichen Sie Ihren Stil mit dem Urania-Kleid, einem eleganten und sinnlichen Kleid, das für jede Figur geeignet ist.</p> <p class="text-base">Dieses Kleid aus hochwertigem, elastischem Kunstleder mit zarter floraler Spitze bietet Ihnen einen außergewöhnlichen Tragekomfort und einen raffinierten Look für alle besonderen Anlässe. Der durchdachte Schnitt betont Ihre Kurven, während sich das elastische Kunstleder Ihren Formen anpasst, ohne sie einzuengen. Der Rücken und die Ärmel aus floraler Spitze sorgen für einen femininen und romantischen Touch.</p> <p class="text-base">Im Rücken komplett mit Reißverschluss versehen, um das Anziehen zu erleichtern und einen perfekten Sitz zu gewährleisten.</p> <p class="text-base">Tags<strong>:</strong> Kunstlederkleid, Spitzenkleid, Abendkleid, Elegantes Kleid, Sinnliches Kleid, Kirschblütenkleid, Damenkleid, Damenmode, Cocktailkleid, Blumenspitze, Kunstleder, Modetrend, Abend, Elegant, Urania.</p> <p class="text-base"><strong>Warum Sie dieses Kleid wählen sollten:</strong></p> <ul> <li>Der Schnitt ist darauf ausgelegt, Ihre Kurven zu subκαφέrieren</li> <li>Elastisches Kunstleder und weiche Spitze für optimalen Tragekomfort</li> <li>Einzigartiger und selbstbewusster Stil</li> <li>Für jeden Anlass geeignet</li> <li>Fühlen Sie sich in diesem außergewöhnlichen Kleid schön, elegant und selbstbewusst</li> </ul> </div>
guid
stringhttps://dev.divasboudoir.com/de/kleid-in-ubergrosse-aus-kunstleder-und-spitze-schwarz/cdbu5414.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringSubsarcellverdez Ihre Kurven mit unserem Kleid in Übergröße Urania. Es wird all Ihre Vorzüge mit Eleganz und einem Hauch von Provokation zur Geltung bringen. Kostenloser Versand.
keywords
string
title
stringUrania Kleid in Übergröße - Spitze und Leder - BDSM-Look
seotitle
stringKleid in Übergröße aus Kunstleder und Spitze
seouri
stringkleid-in-ubergrosse-aus-kunstleder-und-spitze-schwarz
specifications
string
stylingtips
string
summary
stringTragen Sie es zu allen Anlässen, denn es wird Ihre Rundungen in den Vordergrund stellen.
title
stringKleid Urania
usageinstructions
string
el
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Κάντε μια δήλωση στυλ με το φόρεμα Urania, ένα κομψό και αισθησιακό κομμάτι σχεδιασμένο για να υποκαφέ και να αναδεικνύει κάθε σιλουέτα.</p> <p class="text-base">Κατασκευασμένο από ποιοτικό ελαστικό faux leather και διακοσμημένο με λεπτή φλοράλ δαντέλα, αυτό το φόρεμα προσφέρει εξαιρετική άνεση και μια εκλεπτυσμένη εμφάνιση για όλες τις ειδικές περιστάσεις σας. Είναι επιδέξια κομμένο για να αναδεικνύει τις καμπύλες σας, ενώ το ελαστικό faux leather αγκαλιάζει τη σιλουέτα σας χωρίς να τη στενεύει. Η φλοράλ δαντέλα στην πλάτη και τα μανίκια προσθέτουν μια πινελιά θηλυκότητας και ρομαντισμού.</p> <p class="text-base">Κλείνει πλήρως με φερμουάρ στην πλάτη για εύκολο πέρασμα και τέλεια στήριξη.</p> <p class="text-base"><strong>Λέξεις κλειδιά :</strong> Φόρεμα Similicuir, Φόρεμα με δαντέλα, Βραδινό φόρεμα, Κομψό φόρεμα, Αισθησιακό φόρεμα, Φόρεμα Cherry, Γυναικείο φόρεμα, Γυναικεία μόδα, Κοκτέιλ φόρεμα, Φλοράλ δαντέλα, Similicuir, Τάση μόδας, Βραδινό, Κομψό, Urania.</p> <p class="text-base"><strong>Γιατί να επιλέξετε αυτό το φόρεμα:</strong></p> <ul> <li>Το κόψιμο έχει σχεδιαστεί για να υποσκελίζει τις καμπύλες σας</li> <li>Ελαστικό ψεύτικο δέρμα και απαλή δαντέλα για βέλτιστη άνεση</li> <li>Μοναδικό και διεκδικητικό στυλ</li> <li>Κατάλληλο για όλες τις περιστάσεις</li> <li>Νιώστε όμορφα, κομψά και με αυτοπεποίθηση σε αυτό το εξαιρετικό φόρεμα</li> </ul> </div>
guid
stringhttps://dev.divasboudoir.com/el/forema-apo-pseytiko-derma-kai-dantela-syn-megethos-mayro/cdbu5414.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringΑναδείξτε τις καμπύλες σας με το φόρεμα Urania plus size, που θα αναδείξει όλα τα προσόντα σας με κομψότητα και μια πινελιά πρόκλησης. Δωρεάν παράδοση.
keywords
string
title
stringUrania plus size φόρεμα - Δαντέλα και δέρμα - BDSM look
seotitle
stringΦόρεμα από ψεύτικο δέρμα και δαντέλα συν μέγεθος
seouri
stringforema-apo-pseytiko-derma-kai-dantela-syn-megethos-mayro
specifications
string
stylingtips
string
summary
stringΦορέστε το για κάθε περίσταση και θα αναδείξει τις καμπύλες σας με τον καλύτερο τρόπο.
title
stringΦόρεμα Urania
usageinstructions
string
en
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Make a style statement with the Urania dress, an elegant and sensual piece designed to sublimate any figure.</p> <p class="text-base">Crafted in quality stretch faux leather and adorned with delicate floral lace, this dress offers exceptional comfort and sophisticated allure for all your special occasions. Its studied cut highlights your curves, while the elastic faux leather hugs your forms without constricting them. The floral lace back and sleeves add a touch of femininity and romance.</p> <p class="text-base">Full-zip back for easy slip-on and perfect fit.</p> <p class="text-base"><strong>Keywords:</strong> Similicuir Dress, Lace Dress, Evening Dress, Elegant Dress, Sensual Dress, Black Dress, Women's Dress, Women's Fashion, Cocktail Dress, Floral Lace, Similicuir, Fashion Trend, Evening, Elegant, Urania.</p> <p class="text-base"><strong>Why choose this dress:</strong></p> <ul> <li>Cut to enhance your curves</li> <li>Elastic faux leather and soft lace for optimum comfort</li> <li>Unique, assertive style</li> <li>Suitable for all occasions</li> <li>Feel beautiful, elegant and confident in this exceptional dress</li> </ul> </div>
guid
stringhttps://dev.divasboudoir.com/en/imitation-leather-and-lace-plus-size-dress-black/cdbu5414.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringSublimate your curves with our Urania plus size dress, which will show off all your assets with elegance and a touch of provocation. Free shipping.
keywords
string
title
stringPlus size dress Urania - Lace and leather - BDSM look
seotitle
stringImitation leather and lace plus size dress
seouri
stringimitation-leather-and-lace-plus-size-dress-black
specifications
string
stylingtips
string
summary
stringWear it for any occasion, it's sure to show off your curves.
title
stringUrania dress
usageinstructions
string
es
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Haz una declaración de estilo con el vestido Urania, una pieza elegante y sensual diseñada para realzar todas las figuras.</p> <p class="text-base">Confeccionado en piel sintética elástica de alta calidad y adornado con un delicado encaje floral, este vestido ofrece una comodidad excepcional y un look sofisticado para todas tus ocasiones especiales. El corte es perfecto para realzar tus curvas, mientras que la piel sintética elástica se adapta a tu silueta sin ceñirla. La espalda y las mangas de encaje floral añaden un toque de feminidad y romanticismo.</p> <p class="text-base">Se abrocha con cremallera en la espalda para facilitar su colocación y ofrecer una sujeción perfecta.</p> <p class="text-base"><strong>Palabras clave :</strong> Vestido Similicuir, Vestido de Encaje, Vestido de Noche, Vestido Elegante, Vestido Sensual, σάρκαe Vestido, Vestido de Mujer, Moda Femenina, Vestido de Cóctel, Encaje Floral, Similicuir, Tendencia de Moda, Noche, Elegante, Urania.</p> <p class="text-base"><strong>¿Por qué elegir este vestido?</strong></p> <ul> <li>Corte que realza tus curvas</li> <li>Piel sintética elástica y suave encaje para un confort óptimo</li> <li>Estilo único y asertivo</li> <li>Adecuado para todas las ocasiones</li> <li>Siéntete guapa, elegante y segura de ti misma con este vestido excepcional</li> </ul> </div>
guid
stringhttps://dev.divasboudoir.com/es/vestido-talla-grande-de-piel-sintetica-y-encaje-negro/cdbu5414.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringSubsarcellblauz sus curvas con nuestro vestido de talla grande Urania, mostrará todos sus activos con elegancia y un toque de provocación. Entrega gratuita.
keywords
string
title
stringVestido talla grande Urania - Encaje y cuero - Look BDSM
seotitle
stringVestido talla grande de piel sintética y encaje
seouri
stringvestido-talla-grande-de-piel-sintetica-y-encaje-negro
specifications
string
stylingtips
string
summary
stringPóntelo para cualquier ocasión y luce tus curvas al máximo.
title
stringVestido Urania
usageinstructions
string
fr
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Affirmez votre style avec la robe Urania, une pi&egrave;ce &eacute;l&eacute;gante et sensuelle con&ccedil;ue pour subδιαφανές et ροζ oscuro e amarelolo en amarillo und cachir toutes les silhouettes.</p> <p class="text-base">Confectionn&eacute;e en similicuir &eacute;lastique de qualit&eacute; et orn&eacute;e de dentelle florale d&eacute;licate, cette robe vous offre un confort exceptionnel et une allure sophistiqu&eacute;e pour toutes vos occasions sp&eacute;ciales. Sa coupe &eacute;tudi&eacute;e met en valeur vos courbes, tandis que le similicuir &eacute;lastique &eacute;pouse vos formes sans les contraindre. Le dos et les manches en dentelle florale apportent une touche de f&eacute;minit&eacute; et de romantisme.</p> <p class="text-base">Enti&egrave;rement zipp&eacute;e dans le dos pour un enfilage facile et un maintien parfait.</p> <p class="text-base"><strong>Mots Cl&eacute;s :</strong> Robe Similicuir, Robe Dentelle, Robe Soir&eacute;e, Robe &Eacute;l&eacute;gante, Robe Sensuelle, Robe pink claro y blau und schwarz und weiß y πολύχρωμο and γκρι und schwarze, Robe Femme, Mode Femme, Robe Cocktail, Dentelle Florale, Similicuir, Tendance Mode, Soir&eacute;e, &Eacute;l&eacute;gant, Urania.</p> <p class="text-base"><strong>Pourquoi choisir cette robe :</strong></p> <ul> <li>Coupe &eacute;tudi&eacute;e pour subkhaki claror vos courbes</li> <li>Similicuir &eacute;lastique et dentelle douce pour un confort optimal</li> <li>Style unique et affirm&eacute;</li> <li>Adapt&eacute;e &agrave; toutes les occasions</li> <li>Sentez-vous belle, &eacute;l&eacute;gante et s&ucirc;re de vous dans cette robe exceptionnelle</li> </ul> </div>
guid
stringhttps://dev.divasboudoir.com/fr/robe-grande-taille-en-similicuir-et-dentelle-noir/cdbu5414.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringSubsarcellασημένιο en pretoz vos rondeurs avec notre robe grande taille Urania, elle mettra tout vos atouts à l'honneur avec élégance et une touche de provocation. Envoi gratuit.
keywords
string
title
stringRobe grande taille Urania - Dentelle et cuir - Look BDSM
seotitle
stringRobe grande taille en similicuir et dentelle
seouri
stringrobe-grande-taille-en-similicuir-et-dentelle-noir
specifications
string
stylingtips
string
summary
stringPortez-la en toutes circonstances, elle saura mettre vos rondeurs &agrave; l'honneur.
title
stringRobe Urania
usageinstructions
string
it
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Fate una dichiarazione di stile con l'abito Urania, un capo elegante e sensuale progettato per valorizzare ogni figura.</p> <p class="text-base">Realizzato in ecopelle elasticizzata di alta qualità e impreziosito da un delicato pizzo floreale, questo abito offre un comfort eccezionale e un look sofisticato per tutte le occasioni speciali. Il taglio è sapientemente studiato per esaltare le vostre curve, mentre l'ecopelle elasticizzata abbraccia le vostre forme senza costringerle. La schiena e le maniche in pizzo floreale aggiungono un tocco di femminilità e romanticismo.</p> <p class="text-base">Completamente chiusa da una cerniera sul retro per una facile vestibilità e un sostegno perfetto.</p> <p class="text-base"><strong>Parole chiave :</strong> Abito Similicuir, Abito in pizzo, Abito da sera, Abito elegante, Abito sensuale, Abito Cherry, Abito da donna, Moda donna, Abito da cocktail, Pizzo floreale, Similicuir, Tendenza moda, Sera, Elegante, Urania.</p> <p class="text-base"><strong>Perché scegliere questo abito?</strong></p> <ul> <li>Taglio che esalta le vostre curve</li> <li>Ecopelle elastica e morbido pizzo per un comfort ottimale</li> <li>Stile unico e deciso</li> <li>Adatto a tutte le occasioni</li> <li>Sentitevi belle, eleganti e sicure di voi stesse con questo abito eccezionale</li> </ul> </div>
guid
stringhttps://dev.divasboudoir.com/it/abito-in-ecopelle-e-pizzo-taglia-grande-nero/cdbu5414.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringSommergete le vostre curve con il nostro abito Urania taglia grande, che metterà in mostra tutte le vostre caratteristiche con eleganza e un tocco di provocazione. Consegna gratuita.
keywords
string
title
stringAbito Urania taglia grande - Pizzo e pelle - Look BDSM
seotitle
stringAbito in ecopelle e pizzo taglia grande
seouri
stringabito-in-ecopelle-e-pizzo-taglia-grande-nero
specifications
string
stylingtips
string
summary
stringIndossato in ogni occasione, metterà in risalto le vostre curve al meglio.
title
stringAbito Urania
usageinstructions
string
nl
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Maak een stijlstatement met de Urania jurk, een elegant en sensueel stuk dat ontworpen is om elk figuur te verbeteren.</p> <p class="text-base">Gemaakt van hoogwaardig stretch imitatieleer en versierd met delicaat bloemenkant, biedt deze jurk uitzonderlijk comfort en een geraffineerde look voor al je speciale gelegenheden. De jurk is vakkundig gesneden om je rondingen te benadrukken, terwijl het stretch imitatieleer je vorm omhelst zonder te knellen. De gebloemde kanten achterkant en mouwen voegen een vleugje vrouwelijkheid en romantiek toe.</p> <p class="text-base">Volledig met rits aan de achterkant voor gemakkelijk aantrekken en perfecte ondersteuning.</p> <p class="text-base"><strong>Trefwoorden :</strong> Similicuir jurk, Kanten jurk, Avondjurk, Elegante jurk, Sensuele jurk, Zwarte jurk, Jurk voor dames, Damesmode, Cocktailjurk, Bloemenkant, Similicuir, Modetrend, Avond, Elegant, Urania.</p> <p class="text-base"><strong>Waarom kiezen voor deze jurk?</strong></p> <ul> <li>Gesneden om je rondingen te verbeteren</li> <li>Elastisch imitatieleer en zacht kant voor optimaal comfort</li> <li>Unieke, assertieve stijl</li> <li>Geschikt voor alle gelegenheden</li> <li>Voel je mooi, elegant en zelfverzekerd in deze uitzonderlijke jurk</li> </ul> </div>
guid
stringhttps://dev.divasboudoir.com/nl/jurk-van-imitatieleer-en-kant-plus-size-zwart/cdbu5414.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringSublimeer je rondingen met onze Urania jurk van grote maat, die al je pluspunten zal laten zien met elegantie en een vleugje provocatie. Gratis bezorging.
keywords
string
title
stringUrania jurk grote maat - Kant en leer - BDSM-look
seotitle
stringJurk van imitatieleer en kant plus size
seouri
stringjurk-van-imitatieleer-en-kant-plus-size-zwart
specifications
string
stylingtips
string
summary
stringDraag het voor elke gelegenheid en je rondingen komen er goed in uit.
title
stringUrania jurk
usageinstructions
string
pt
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Faça uma declaração de estilo com o vestido Urania, uma peça elegante e sensual concebida para realçar qualquer figura.</p> <p class="text-base">Feito de pele sintética elástica de alta qualidade e adornado com delicadas rendas florais, este vestido oferece um conforto excecional e um visual sofisticado para todas as suas ocasiões especiais. É habilmente cortado para realçar as suas curvas, enquanto a pele sintética elástica abraça a sua forma sem a constranger. As costas e as mangas em renda floral dão um toque de feminilidade e romance.</p> <p class="text-base">Com fecho de correr na parte de trás para um calçar fácil e um apoio perfeito.</p> <p class="text-base"><strong>Palavras-chave :</strong> Vestido Similicuir, Vestido de Renda, Vestido de Noite, Vestido Elegante, Vestido Sensual, Vestido σάρκαe, Vestido Feminino, Moda Feminina, Vestido de Cocktail, Renda Floral, Similicuir, Tendência de Moda, Noite, Elegante, Urania.</p> <p class="text-base"><strong>Porquê escolher este vestido?</strong></p> <ul> <li>Corte para realçar as suas curvas</li> <li>Pele sintética elástica e renda suave para um conforto ótimo</li> <li>Estilo único e assertivo</li> <li>Adequado para todas as ocasiões</li> <li>Sinta-se bonita, elegante e confiante com este vestido excecional</li> </ul> </div>
guid
stringhttps://dev.divasboudoir.com/pt/vestido-plus-size-em-pele-sintetica-e-renda-preto/cdbu5414.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringSublinhe as suas curvas com o nosso vestido Urania plus size, que irá mostrar todos os seus atributos com elegância e um toque de provocação. Entrega gratuita.
keywords
string
title
stringVestido Urania plus size - Renda e pele - look BDSM
seotitle
stringVestido plus size em pele sintética e renda
seouri
stringvestido-plus-size-em-pele-sintetica-e-renda-preto
specifications
string
stylingtips
string
summary
stringUse-o em qualquer ocasião e exibirá as suas curvas da melhor forma possível.
title
stringVestido Urania
usageinstructions
string
fetishboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
latexboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
legsboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
lustboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
smboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringDas Kleid Urania ist aus hochwertigem, elastischem Kunstleder und floraler Spitze gefertigt.<br /><br />Im Rücken ist es mit einem Reißverschluss versehen.<br /><br />Mieder aus Kunstleder.<br /><br />Rücken und Ärmel aus elastischer Spitze.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringSubnaranja Machen Sie Ihre Kurven mit unserem sexy Urania-Kleid deutlich. Es wird all Ihre Vorzüge mit Eleganz und einem Hauch von Provokation zur Geltung bringen. Kostenloser Versand.
keywords
string
title
stringSexy Kleid Urania - Spitze und Leder - BDSM-Look
seotitle
stringSexy Kleid aus Kunstleder und Spitze
seouri
stringsexy-kleid-aus-kunstleder-und-spitze-schwarz
specifications
string
stylingtips
string
summary
stringTragen Sie es zu allen Anlässen, denn es wird Ihre Rundungen in den Vordergrund stellen.
title
stringKleid Urania
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringΤο φόρεμα Urania είναι κατασκευασμένο από υψηλής ποιότητας ελαστικό faux leather και φλοράλ δαντέλα.<br /><br />Διαθέτει φερμουάρ στην πλάτη.<br /><br />Μπουφάν από δερματίνη.<br /><br />Ελαστική δαντέλα στην πλάτη και στα μανίκια.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringSubnaranja ξεκαθαρίστε τις καμπύλες σας με το σέξι φόρεμά μας Urania, θα αναδείξει όλα τα προσόντα σας με κομψότητα και μια πινελιά πρόκλησης. Δωρεάν παράδοση.
keywords
string
title
stringΣέξι φόρεμα Urania - Δαντέλα και δέρμα - BDSM look
seotitle
stringΣέξι φόρεμα από ψεύτικο δέρμα και δαντέλα
seouri
stringsexi-forema-apo-pseytiko-derma-kai-dantela-mayro
specifications
string
stylingtips
string
summary
stringΦορέστε το για κάθε περίσταση και θα αναδείξει τις καμπύλες σας με τον καλύτερο τρόπο.
title
stringΦόρεμα Urania
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringThe Urania dress is made of high-quality elastic faux leather and floral lace.<br /><br />It is fully zipped at the back.<br /><br />Leatherette bodice.<br /><br />Elastic lace back and sleeves.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringEnhance your curves with our sexy Urania dress, which will show off all your assets with elegance and a touch of provocation. Free shipping.
keywords
string
title
stringUrania sexy dress - Lace and leather - BDSM look
seotitle
stringSexy dress in imitation leather and lace
seouri
stringsexy-dress-in-imitation-leather-and-lace-black
specifications
string
stylingtips
string
summary
stringWear it for any occasion, it's sure to show off your curves.
title
stringUrania dress
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringEl vestido Urania está confeccionado en piel sintética elástica de alta calidad y encaje floral.<br /><br />Se cierra con cremallera en la espalda.<br /><br />Cuerpo de polipiel.<br /><br />Espalda y mangas de encaje elástico.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringRealza tus curvas con nuestro sexy vestido Urania, que mostrará todos tus activos con elegancia y un toque de provocación. Entrega gratuita.
keywords
string
title
stringVestido sexy Urania - Encaje y cuero - Look BDSM
seotitle
stringVestido sexy de piel sintética y encaje
seouri
stringvestido-sexy-de-piel-sintetica-y-encaje-negro
specifications
string
stylingtips
string
summary
stringPóntelo para cualquier ocasión y luce tus curvas al máximo.
title
stringVestido Urania
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>La robe Urania est confectionn&eacute;e en similicuir &eacute;lastique de qualit&eacute; et dentelle florale.<br><br>Elle est enti&egrave;rement zip&eacute;e dans dos.<br><br>Corsage en similicuir.<br><br>Dos et manches en dentelle &eacute;lastique.</p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringSubnaranja clairz vos rondeurs avec notre robe sexy Urania, elle mettra tout vos atouts à l'honneur avec élégance et une touche de provocation. Envoi gratuit.
keywords
string
title
stringRobe sexy Urania - Dentelle et cuir - Look BDSM
seotitle
stringRobe sexy en similicuir et dentelle
seouri
stringrobe-sexy-en-similicuir-et-dentelle-noir
specifications
string
stylingtips
string
summary
string<p>Portez-la en toutes circonstances, elle saura mettre vos rondeurs &agrave; l'honneur.</p>
title
stringRobe Urania
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringL'abito Urania è realizzato in ecopelle elasticizzata di alta qualità e pizzo floreale.<br /><br />È completamente chiuso da una zip sul retro.<br /><br />Corpetto in similpelle.<br /><br />Schiena e maniche in pizzo elastico.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringSublimate le vostre curve con il nostro abito sexy Urania, che metterà in mostra tutte le vostre caratteristiche con eleganza e un tocco di provocazione. Consegna gratuita.
keywords
string
title
stringAbito sexy Urania - Pizzo e pelle - Look BDSM
seotitle
stringAbito sexy in ecopelle e pizzo
seouri
stringabito-sexy-in-ecopelle-e-pizzo-nero
specifications
string
stylingtips
string
summary
stringIndossato in ogni occasione, metterà in risalto le vostre curve al meglio.
title
stringAbito Urania
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringDe Urania jurk is gemaakt van hoogwaardig stretch imitatieleer en gebloemd kant.<br /><br />De jurk heeft een volledige ritssluiting aan de achterkant.<br /><br />Lijfje van kunstleer.<br /><br />Elastisch kanten rugpand en mouwen.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringVerbeter je rondingen met onze sexy Urania jurk, die al je pluspunten elegant en met een vleugje provocatie laat zien. Gratis bezorging.
keywords
string
title
stringSexy jurkje Urania - Kant en leer - BDSM-look
seotitle
stringSexy jurkje van imitatieleer en kant
seouri
stringsexy-jurkje-van-imitatieleer-en-kant-zwart
specifications
string
stylingtips
string
summary
stringDraag het voor elke gelegenheid en je rondingen komen er goed in uit.
title
stringUrania jurk
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
stringO vestido Urania é confeccionado em pele sintética elástica de alta qualidade e renda floral.<br /><br />Possui um fecho de correr completo na parte de trás.<br /><br />Corpete em pele sintética.<br /><br />Costas e mangas em renda elástica.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringSublime as suas curvas com o nosso vestido sexy Urania, que mostrará todos os seus atributos com elegância e um toque de provocação. Entrega gratuita.
keywords
string
title
stringVestido sexy Urania - Renda e cabedal - look BDSM
seotitle
stringVestido sexy em pele sintética e renda
seouri
stringvestido-sexy-em-pele-sintetica-e-renda-preto
specifications
string
stylingtips
string
summary
stringUse-o em qualquer ocasião e exibirá as suas curvas da melhor forma possível.
title
stringVestido Urania
usageinstructions
string
name
stringR81362
netweight
string
nextshipment
stringtomorrow
ordered
number3
orderidx
number0
origin
string
originalsize
string
packaging
string
productshipment
stringauto
productuid
stringE795E7CF-CFA4-4DD1-8E07CA6C86DDA7C3
promountil
string
rating
stringnone
recorduid
stringE795E7CF-CFA4-4DD1-8E07CA6C86DDA7C3
reference
stringCDBU5414
related
string
reserved
string
returned
number0
returnsallowed
number1
section
stringcabaret
shipment
string5to7days
showbrand
number0
sizeinfos
Query
Template: /system/api/product/sizes.cfc:20
Execution Time: 11.3 ms
Record Count: 3
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,'1093,1137,1136,1888') > 0
and product_variations.productuid = 'E795E7CF-CFA4-4DD1-8E07CA6C86DDA7C3'
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
1109338-40intlsizeblack3840-19999990wpluslingerieM-L38-4038-408-1012-1440-4240-4238-4044-4640-4238-4092-10074-8298-106
2113744-46intlsizeblack4446-19999990wpluslingerieXL-2XL44-4644-4614-1618-2246-4846-4844-4650-5246-4844-46102-10886-92108-114
3113648-50intlsizeblack4850000wpluslingerie3XL-4XL48-5048-5018-2022-2450-5250-5248-5054-5650-5248-50110-11696-102116-122
sizeranges
stringplus,standard
sizes
string1093,1137,1136,1888
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: 14.5 ms
Record Count: 3
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 = 'E795E7CF-CFA4-4DD1-8E07CA6C86DDA7C3'
and product_variations.isactive = 1
and product_sizes.id_size = 1093
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 = 'E795E7CF-CFA4-4DD1-8E07CA6C86DDA7C3'
and product_variations.isactive = 1
and product_sizes.id_size = 1137
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 = 'E795E7CF-CFA4-4DD1-8E07CA6C86DDA7C3'
and product_variations.isactive = 1
and product_sizes.id_size = 1136
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 = 'E795E7CF-CFA4-4DD1-8E07CA6C86DDA7C3'
and product_variations.isactive = 1
and product_sizes.id_size = 1888
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
1E795E7CF-CFA4-4DD1-8E07CA6C86DDA7C394443133-35A4-4CA7-9EF995FE897208A31093black#000000M-L38-4038-408-1012-1440-4240-4238-4044-4640-4238-40wlingerie38-40intlsize33.29170STOCK01000-10000-10all
2E795E7CF-CFA4-4DD1-8E07CA6C86DDA7C31E1DFCDF-2AB5-4D99-B74EB93365E0258D1137black#000000XL-2XL44-4644-4614-1618-2246-4846-4844-4650-5246-4844-46wlingerie44-46intlsize33.29170STOCK01000-10200R81362R813620116-10all
3E795E7CF-CFA4-4DD1-8E07CA6C86DDA7C34689F320-4E7C-42FF-AB79285CA4DA9FA41136black#0000003XL-4XL48-5048-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie48-50intlsize33.29170STOCK0100000100R81362011700all
subcategory
stringall
supplier
number-1
supplierreference
stringR81362
tags
stringnoirdesir
themes
stringdark
totalvariations
string
type
stringdefault
unitprice
number33.2917
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 8.73 ms
Record Count: 3
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 = 'E795E7CF-CFA4-4DD1-8E07CA6C86DDA7C3' 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 = 'E795E7CF-CFA4-4DD1-8E07CA6C86DDA7C3' 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 = 'E795E7CF-CFA4-4DD1-8E07CA6C86DDA7C3' 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 = 'E795E7CF-CFA4-4DD1-8E07CA6C86DDA7C3' 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 = 'E795E7CF-CFA4-4DD1-8E07CA6C86DDA7C3' 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 = 'E795E7CF-CFA4-4DD1-8E07CA6C86DDA7C3' 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 = 'E795E7CF-CFA4-4DD1-8E07CA6C86DDA7C3'
and product_variations.isactive = 1
and product_sizes.id_size = 1093
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 = 'E795E7CF-CFA4-4DD1-8E07CA6C86DDA7C3' 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 = 'E795E7CF-CFA4-4DD1-8E07CA6C86DDA7C3' 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 = 'E795E7CF-CFA4-4DD1-8E07CA6C86DDA7C3' 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 = 'E795E7CF-CFA4-4DD1-8E07CA6C86DDA7C3' 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 = 'E795E7CF-CFA4-4DD1-8E07CA6C86DDA7C3' 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 = 'E795E7CF-CFA4-4DD1-8E07CA6C86DDA7C3' 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 = 'E795E7CF-CFA4-4DD1-8E07CA6C86DDA7C3'
and product_variations.isactive = 1
and product_sizes.id_size = 1137
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 = 'E795E7CF-CFA4-4DD1-8E07CA6C86DDA7C3' 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 = 'E795E7CF-CFA4-4DD1-8E07CA6C86DDA7C3' 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 = 'E795E7CF-CFA4-4DD1-8E07CA6C86DDA7C3' 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 = 'E795E7CF-CFA4-4DD1-8E07CA6C86DDA7C3' 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 = 'E795E7CF-CFA4-4DD1-8E07CA6C86DDA7C3' 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 = 'E795E7CF-CFA4-4DD1-8E07CA6C86DDA7C3' 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 = 'E795E7CF-CFA4-4DD1-8E07CA6C86DDA7C3'
and product_variations.isactive = 1
and product_sizes.id_size = 1136
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 = 'E795E7CF-CFA4-4DD1-8E07CA6C86DDA7C3' 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 = 'E795E7CF-CFA4-4DD1-8E07CA6C86DDA7C3' 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 = 'E795E7CF-CFA4-4DD1-8E07CA6C86DDA7C3' 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 = 'E795E7CF-CFA4-4DD1-8E07CA6C86DDA7C3' 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 = 'E795E7CF-CFA4-4DD1-8E07CA6C86DDA7C3' 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 = 'E795E7CF-CFA4-4DD1-8E07CA6C86DDA7C3' 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 = 'E795E7CF-CFA4-4DD1-8E07CA6C86DDA7C3'
and product_variations.isactive = 1
and product_sizes.id_size = 1888
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
194443133-35A4-4CA7-9EF995FE897208A31093black#000000M-L38-4038-408-1012-1440-4240-4238-4044-4640-4238-40wlingerie38-40intlsize33.29170STOCK01000-10000-10-10-10033.2917all
21E1DFCDF-2AB5-4D99-B74EB93365E0258D1137black#000000XL-2XL44-4644-4614-1618-2246-4846-4844-4650-5246-4844-46wlingerie44-46intlsize33.29170STOCK01000-10200R81362R813620116-10-10-10033.2917all
34689F320-4E7C-42FF-AB79285CA4DA9FA41136black#0000003XL-4XL48-5048-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie48-50intlsize33.29170STOCK0100000100R8136201170000-10033.2917all
vatrate
number20
warehouse
string