Το καλάθι μου

❌
Σύνολο αντικειμένων
Προβολή καλαθιού
Μενού
Δείτε τα μεγέθη
Σορτς μπόξερ με φερμουάρ από μικροΐνες και δίχτυ
Διπλό κλικ για μεγέθυνση
SKU: LHBA0247
Σορτς μπόξερ με φερμουάρ από μικροΐνες και δίχτυ
Promo
Απόθεμα:
Μέγεθος:

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

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

Ανδρικά σορτς μπόξερ από μικροΐνες και δίχτυ: άνεση και διακριτικό στυλ

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

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

Η μαλακή, αναπνέουσα μικροΐνα εξασφαλίζει τέλεια στήριξη όλη μέρα. Τα διχτυωτά ένθετα, διακριτικά τοποθετημένα στα πλαϊνά, προσθέτουν μια νότα νεωτερισμού και αισθησιασμού. Το διακριτικό και πρακτικό μπροστινό φερμουάρ προσθέτει μια πρωτότυπη πινελιά σε αυτό το κομψό παντελόνι.

Χαρακτηριστικά :

  • Μαύρο μποξεράκι από μικροΐνες
  • Εισαγωγές από δίχτυ
  • Μπροστινό φερμουάρ
  • Μαλακό ύφασμα που αναπνέει
  • Άνετη εφαρμογή

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

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

Διαθέσιμο από S/M έως 3XL/4XL

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

Μαύρο

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

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

Διεθνές
  • Στήθος
  • Μέγεθος
S/M
  • 86-93
  • 74-81
M/L
  • 94-101
  • 82-89
L/XL
  • 102-109
  • 90-99
XL/2XL
  • 110-117
  • 100-109
3XL/4XL
  • 118-125
  • 110-119
To Top
Προβολή καλαθιού
Άρθρα
Σύνολο αντικειμένων
Struct
Entries: 108
actions
Array
available
number-1
brand
stringsvenjoyment
brandcode
stringsewe
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
stringSvenjoyment
breasts
stringna
careinstructions
string
categories
stringdivasboudoir.men.lingerie.all
category
stringlingerie
categorygender
stringf
categorymediadatas
Struct
adult
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string230
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/men/lingerie.jpg
type
stringimg
width
string500
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.706 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 = '8015D65C-0168-4BD3-AE98F6190AE144D7'
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-21 13:38:34'}
defect
number0
dimensions
Struct
Entries: 14
acrylicbones
string
backsideheight
string
diameter
string
flatsteelbones
string
frontsideheight
string
fullheight
string
length
string
modestysize
string
panels
string
sides
string
spiralsteelbones
string
totallength
string
unit
stringcm
wiresize
string
display
stringall
displayfrom
string
displayto
string
grossweight
string
hasbrandinfos
booleanfalse
hascareinstructions
booleanfalse
hascolorinfos
booleantrue
hascompositions
booleanfalse
hasdescription
booleantrue
hasdimensions
booleanfalse
hasmaterials
booleanfalse
hasotherspecifications
booleanfalse
haspromo
number1
hasshortdescription
booleanfalse
hassizeinfos
booleantrue
hasspecifications
booleanfalse
hasstockinfos
booleanfalse
hasstylingtips
booleanfalse
hasusageinstructions
booleanfalse
hasvariations
booleantrue
import
string
inpromo
number5
instockvariations
string
isactive
number1
iscustommade
number0
isdivasize
number0
isfirstprice
number0
isfixedprice
number0
ishot
number0
isnew
number0
isonline
number0
isoutletprice
number0
itemprice
number29.125
itempromo
number22.4583
key
string21333931701
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-10-22 18:44:57'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.61 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('8015d65c-0168-4bd3-ae98f6190ae144d7',lcase(cart_actions.linkedproducts)) > 0 and cart_actions.linkedproducts is not null
)
id_actionbrandinglanguagenamecodetypeminimumOrdermaximumOrderminimumItemsmaximumItemsmaximumUseallowedItemsquotasusedCountlinkedproductslinkedthemeslinkedbrandslinkeditemparamsactiveFromactiveToisActive
linkedproducts
Query
Template: /system/api/products.cfc:1305
Execution Time: 2.59 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 = '58A6724D-0838-4850-ABCDD50BE773DE60' and product_links.linkuid is not null and product_links.linkuid <> ''
and products.reference <> 'LHBA0247'
group by products.reference
order by products.ishot desc, products.isnew desc, orderidx asc, products.lastupdated desc
productuidreferencetypekeylanguagenamelinkuidcolorsvatratemetadatasdimensionsmediadatastagsthemesisdivasizetotalvariationsvariationlistinpromohaspromoitempromoitempriceunitpricepricespromountilisfixedpriceishotisneworderidxavailablestockinstockvariationsbrandbrandnameshowbranddisplaysizetypeintlsizesizessizerangecategorymediadatascategorysizerangesectioncategorysubcategory
linkuid
string58A6724D-0838-4850-ABCDD50BE773DE60
materials
string
mediadatas
Struct
alt
Struct
height
string1000
isprivate
string0
rating
stringall
src
string/photobank/products/sewe/lhba0247/21333931701_det_b.jpg
type
stringimg
width
string1000
back
Struct
height
string972
isprivate
string0
rating
stringall
src
string/photobank/products/sewe/lhba0247/21333931701_rs.jpg
type
stringimg
width
string1000
default
Struct
height
string870
isprivate
string0
rating
stringall
src
string/photobank/products/sewe/lhba0247/boxer_resille_grande_taille.jpg
type
stringimg
width
string602
variations
Struct
colors
Struct
black
Struct
height
string1000
isprivate
string0
rating
stringall
src
string/photobank/products/sewe/lhba0247/21333931701_nor_a.jpg
type
stringimg
width
string989
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">Verleihen Sie Ihrer Herrengarderobe einen Hauch von Raffinesse mit diesen Boxershorts aus schwarzer Mikrofaser, die durch Netzdetails und einen dezenten Frontreißverschluss aufgewertet werden. Diese Pants wurden so entworfen, dass sie optimalen Tragekomfort bieten und gleichzeitig Ihre Figur betonen. Sie sind ideal für Männer, die Wert auf Stil und Wohlbefinden legen.</p> <p class="text-base">Die weiche, atmungsaktive Mikrofaser sorgt den ganzen Tag lang für einen perfekten Sitz. Die subtil platzierten Netzeinsätze an den Seiten verleihen der Hose einen modernen, sinnlichen Touch. Der diskrete und praktische Frontreißverschluss verleiht dieser eleganten Pants eine originelle Note.</p> <p class="text-base"><strong>Merkmale :</strong></p> <ul> <li>Boxershorts aus schwarzer Mikrofaser</li> <li>Einsätze aus Netzgewebe</li> <li>Frontaler Reißverschluss</li> <li>Weiches, atmungsaktives Material</li> <li>Bequemer Schnitt</li> </ul> </div>
guid
stringhttps://dev.divasboudoir.com/de/boxershorts-aus-mikrofaser-und-netz-fur-manner-komfort-und-subtiler-stil-schwarz/lhba0247.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringSchwarze Mikrofaser-Boxershorts mit stilvollem Netz und Frontreißverschluss. Komfort, Halt und trendiger Look. Entdecken Sie die Männerkollektion!
keywords
string
title
stringBoxer aus Mikrofaser und Netzstoff für Männer | Diva's Boudoir
seotitle
stringBoxershorts aus Mikrofaser und Netz für Männer: Komfort und subtiler Stil
seouri
stringboxershorts-aus-mikrofaser-und-netz-fur-manner-komfort-und-subtiler-stil-schwarz
specifications
string
stylingtips
string
summary
string
title
stringBoxer mit Reißverschluss aus Mikrofaser und Netzstoff
usageinstructions
string
el
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Προσθέστε μια πινελιά εκλέπτυνσης στην ανδρική σας γκαρνταρόμπα με αυτά τα μαύρα μποξεράκια από μικροΐνες, με λεπτομέρειες από δίχτυ και διακριτικό φερμουάρ μπροστά. Σχεδιασμένο για να προσφέρει βέλτιστη άνεση, τονίζοντας παράλληλα τη σιλουέτα σας, αυτό το παντελόνι είναι ιδανικό για άνδρες που εκτιμούν το στυλ και την ευεξία.</p> <p class="text-base">Η μαλακή, αναπνέουσα μικροΐνα εξασφαλίζει τέλεια στήριξη όλη μέρα. Τα διχτυωτά ένθετα, διακριτικά τοποθετημένα στα πλαϊνά, προσθέτουν μια νότα νεωτερισμού και αισθησιασμού. Το διακριτικό και πρακτικό μπροστινό φερμουάρ προσθέτει μια πρωτότυπη πινελιά σε αυτό το κομψό παντελόνι.</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/andrika-sorts-mpoxer-apo-mikroΐnes-kai-dichty-anesh-kai-diakritiko-styl-mayro/lhba0247.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringΜαύρο μποξεράκι από μικροΐνες με κομψό δίχτυ και φερμουάρ μπροστά. Άνεση, στήριξη και μοντέρνα εμφάνιση. Ανακαλύψτε την ανδρική συλλογή!
keywords
string
title
stringΑνδρικό μποξεράκι από μικροΐνες και δίχτυ | Diva's Boudoir
seotitle
stringΑνδρικά σορτς μπόξερ από μικροΐνες και δίχτυ: άνεση και διακριτικό στυλ
seouri
stringandrika-sorts-mpoxer-apo-mikroΐnes-kai-dichty-anesh-kai-diakritiko-styl-mayro
specifications
string
stylingtips
string
summary
string
title
stringΣορτς μπόξερ με φερμουάρ από μικροΐνες και δίχτυ
usageinstructions
string
en
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Add a touch of sophistication to your men's wardrobe with these black microfiber boxer briefs, enhanced by fishnet details and a discreet front zip. Designed to offer optimum comfort while highlighting your silhouette, these pants are ideal for men who appreciate style and well-being.</p> <p class="text-base">Soft, breathable microfiber ensures perfect support all day long. Subtly placed fishnet inserts on the sides add a touch of modernity and sensuality. The front zip, discreet and practical, adds an original note to these elegant pants.</p> <p class="text-base"><strong>Features :</strong></p> <ul> <li>Black microfiber boxer shorts</li> <li>Fishnet inserts</li> <li>Front zip</li> <li>Soft, breathable fabric</li> <li>Comfortable fit</li> </ul> </div>
guid
stringhttps://dev.divasboudoir.com/en/mens-microfiber-and-fishnet-boxer-comfort-and-subtle-style-black/lhba0247.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringBlack microfiber boxer shorts, stylish fishnet and front zip. Comfort, support and a trendy look. Discover the men's collection!
keywords
string
title
stringMen's Microfiber & Fishnet Boxer | Diva's Boudoir
seotitle
stringMen's Microfiber and Fishnet Boxer: Comfort and Subtle Style
seouri
stringmens-microfiber-and-fishnet-boxer-comfort-and-subtle-style-black
specifications
string
stylingtips
string
summary
string
title
stringZipped boxer shorts in microfibre and fishnet
usageinstructions
string
es
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Añade un toque de sofisticación a tu armario masculino con estos calzoncillos bóxer negros de microfibra, con detalles de rejilla y una discreta cremallera frontal. Diseñados para ofrecer un confort óptimo a la vez que acentúan su silueta, estos calzoncillos son ideales para los hombres que aprecian el estilo y el bienestar.</p> <p class="text-base">La microfibra suave y transpirable garantiza una sujeción perfecta durante todo el día. Las inserciones de rejilla, sutilmente colocadas en los laterales, aportan un toque de modernidad y sensualidad. La discreta y práctica cremallera frontal añade un toque original a estos elegantes pantalones.</p> <p class="text-base"><strong>Características :</strong></p> <ul> <li>Calzoncillos negros de microfibra</li> <li>Inserciones de rejilla</li> <li>Cremallera frontal</li> <li>Tejido suave y transpirable</li> <li>Ajuste cómodo</li> </ul> </div>
guid
stringhttps://dev.divasboudoir.com/es/calzoncillos-boxer-masculinos-de-microfibra-y-rejilla-comodidad-y-estilo-sutil-negro/lhba0247.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringCalzoncillos negros de microfibra con elegante rejilla y cremallera frontal. Comodidad, sujeción y un look a la última. ¡Descubre la colección para hombre!
keywords
string
title
stringBoxer de Microfibra y Red para Hombre | Diva's Boudoir
seotitle
stringCalzoncillos bóxer masculinos de microfibra y rejilla: comodidad y estilo sutil
seouri
stringcalzoncillos-boxer-masculinos-de-microfibra-y-rejilla-comodidad-y-estilo-sutil-negro
specifications
string
stylingtips
string
summary
string
title
stringCalzoncillos con cremallera de microfibra y rejilla
usageinstructions
string
fr
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Ajoutez une touche de sophistication &agrave; votre garde-robe masculine avec ce boxer en microfibre noire, rehauss&eacute; de d&eacute;tails en r&eacute;sille et d'un zip frontal discret. Con&ccedil;u pour offrir un confort optimal tout en soulignant votre silhouette, ce pants est id&eacute;al pour les hommes qui appr&eacute;cient le style et le bien-&ecirc;tre.</p> <p class="text-base">La microfibre douce et respirante assure un maintien parfait tout au long de la journ&eacute;e. Les empi&egrave;cements en r&eacute;sille, subtilement plac&eacute;s sur les c&ocirc;t&eacute;s, apportent une touche de modernit&eacute; et de sensualit&eacute;. Le zip frontal, discret et pratique, ajoute une note originale &agrave; ce pants &eacute;l&eacute;gant.</p> <p class="text-base"><strong>Caract&eacute;ristiques :</strong></p> <ul> <li>Boxer en microfibre noire</li> <li>Empi&egrave;cements en r&eacute;sille</li> <li>Zip frontal</li> <li>Mati&egrave;re douce et respirante</li> <li>Coupe confortable</li> </ul> </div>
guid
stringhttps://dev.divasboudoir.com/fr/boxer-microfibre-et-resille-homme-confort-et-style-subtil-noir/lhba0247.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringBoxer microfibre noir, résille stylée et zip frontal. Confort, maintien et look tendance. Découvrez la collection masculine !
keywords
string
title
stringBoxer Microfibre & Résille Homme | Diva's Boudoir
seotitle
stringBoxer Microfibre et Résille Homme : Confort et Style Subtil
seouri
stringboxer-microfibre-et-resille-homme-confort-et-style-subtil-noir
specifications
string
stylingtips
string
summary
string
title
stringBoxer zippé en microfibre et résille
usageinstructions
string
it
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Aggiungete un tocco di raffinatezza al vostro guardaroba maschile con questi boxer in microfibra nera, caratterizzati da dettagli a rete e da una discreta zip frontale. Progettati per offrire un comfort ottimale accentuando la silhouette, questi pantaloni sono ideali per gli uomini che apprezzano lo stile e il benessere.</p> <p class="text-base">La microfibra morbida e traspirante assicura un sostegno perfetto per tutto il giorno. Gli inserti a rete, sottilmente posizionati sui lati, aggiungono un tocco di modernità e sensualità. La pratica e discreta zip frontale aggiunge un tocco originale a questi pantaloni eleganti.</p> <p class="text-base"><strong>Caratteristiche :</strong></p> <ul> <li>Boxer in microfibra nera</li> <li>Inserti a rete</li> <li>Zip frontale</li> <li>Tessuto morbido e traspirante</li> <li>Vestibilità comoda</li> </ul> </div>
guid
stringhttps://dev.divasboudoir.com/it/boxer-da-uomo-in-microfibra-e-rete-comfort-e-stile-sottile-nero/lhba0247.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringBoxer in microfibra nera con elegante rete e zip frontale. Comfort, sostegno e look di tendenza. Scoprite la collezione uomo!
keywords
string
title
stringBoxer uomo in microfibra e rete | Diva's Boudoir
seotitle
stringBoxer da uomo in microfibra e rete: comfort e stile sottile
seouri
stringboxer-da-uomo-in-microfibra-e-rete-comfort-e-stile-sottile-nero
specifications
string
stylingtips
string
summary
string
title
stringBoxer con cerniera in microfibra e rete
usageinstructions
string
nl
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Voeg een vleugje verfijning toe aan je mannengarderobe met deze zwarte microvezel boxerslip, met visnet details en een discrete rits aan de voorkant. Ontworpen om optimaal comfort te bieden en tegelijkertijd je silhouet te accentueren, is deze broek ideaal voor mannen die van stijl en welzijn houden.</p> <p class="text-base">De zachte, ademende microvezel zorgt de hele dag voor perfecte ondersteuning. De visnet inzetstukken, subtiel geplaatst aan de zijkanten, voegen een vleugje moderniteit en sensualiteit toe. De discrete en praktische ritssluiting aan de voorkant geeft deze elegante broek een originele touch.</p> <p class="text-base"><strong>Eigenschappen :</strong></p> <ul> <li>Zwarte boxershort in microvezel</li> <li>Visnet inzetstukken</li> <li>Ritssluiting aan de voorkant</li> <li>Zachte, ademende stof</li> <li>Comfortabele pasvorm</li> </ul> </div>
guid
stringhttps://dev.divasboudoir.com/nl/herenboxershort-van-microvezel-en-visnet-comfort-en-subtiele-stijl-zwart/lhba0247.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringZwarte boxershort van microvezel met stijlvol visnet en ritssluiting aan de voorkant. Comfort, ondersteuning en een trendy look. Ontdek de mannencollectie!
keywords
string
title
stringHerenboxer van microvezel en visnet | Diva's Boudoir
seotitle
stringHerenboxershort van microvezel en visnet: comfort en subtiele stijl
seouri
stringherenboxershort-van-microvezel-en-visnet-comfort-en-subtiele-stijl-zwart
specifications
string
stylingtips
string
summary
string
title
stringBoxershorts met rits van microvezel en visnet
usageinstructions
string
pt
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Dê um toque de sofisticação ao seu guarda-roupa de homem com estas cuecas boxer em microfibra preta, com detalhes em rede e um fecho de correr discreto à frente. Concebidas para oferecer um conforto ótimo ao mesmo tempo que acentuam a sua silhueta, estas cuecas são ideais para homens que apreciam o estilo e o bem-estar.</p> <p class="text-base">A microfibra macia e respirável garante um apoio perfeito durante todo o dia. As inserções em rede, subtilmente colocadas nos lados, dão um toque de modernidade e sensualidade. O fecho de correr discreto e prático à frente dá um toque original a estas calças elegantes.</p> <p class="text-base"><strong>Caraterísticas :</strong></p> <ul> <li>Calções boxer em microfibra preta</li> <li>Inserções de rede de peixe</li> <li>Fecho de correr à frente</li> <li>Tecido macio e respirável</li> <li>Ajuste confortável</li> </ul> </div>
guid
stringhttps://dev.divasboudoir.com/pt/calcoes-boxer-de-microfibra-e-rede-para-homem-conforto-e-estilo-subtil-preto/lhba0247.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringCalções boxer em microfibra preta com rede elegante e fecho de correr à frente. Conforto, apoio e um visual moderno. Descubra a coleção para homem!
keywords
string
title
stringBoxer de microfibra e rede para homem | Diva's Boudoir
seotitle
stringCalções boxer de microfibra e rede para homem: conforto e estilo subtil
seouri
stringcalcoes-boxer-de-microfibra-e-rede-para-homem-conforto-e-estilo-subtil-preto
specifications
string
stylingtips
string
summary
string
title
stringCalções boxer com fecho em microfibra e rede
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
string<div> <p class="text-base">Entfesseln Sie Ihre dunkle, verwegene Seite mit diesen Boxershorts aus schwarzer Mikrofaser, die durch Netzdetails und einen suggestiven Frontreißverschluss aufgewertet wird. Diese Pants wurden für Männer entworfen, die gerne mit den Codes des BDSM spielen. Sie bieten Ihnen einen außergewöhnlichen Tragekomfort und regen gleichzeitig Ihre Fantasie an.</p> <p class="text-base">Die weiche, dehnbare Mikrofaser passt sich perfekt an Ihre Körperformen an, während die Netzeinsätze subtil Ihre Haut enthüllen. Mit dem praktischen und zugleich provokativen Frontreißverschluss können Sie den Grad der Enthüllung steuern.</p> <p class="text-base"><strong>Merkmale :</strong></p> <ul> <li>Pants aus schwarzer Mikrofaser</li> <li>Einsätze aus Netzgewebe</li> <li>Frontaler Reißverschluss</li> <li>Weiches, dehnbares Material</li> <li>Körpernaher Schnitt</li> </ul> </div>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringWagen Sie die Provokation mit diesen Boxershorts aus Mikrofaser mit Reißverschluss, einer exklusiven Kreation von The BDSM Boudoir, mit der Sie sich kraftvoll, verführerisch und unwiderstehlich fühlen werden.
keywords
string
title
stringBoxershorts Mikrofaser Zip Mann | The BDSM Boudoir
seotitle
stringHerren-Boxershorts aus Mikrofaser mit Reißverschluss: Provokation und Kontrolle
seouri
stringherren-boxershorts-aus-mikrofaser-mit-reissverschluss-provokation-und-kontrolle-schwarz
specifications
string
stylingtips
string
summary
string<p>Wagen Sie die Provokation mit diesen Mikrofaser-Boxershorts mit Reißverschluss, mit denen Sie sich kraftvoll, verführerisch und unwiderstehlich fühlen werden.</p>
title
stringBoxershorts aus Mikrofaser mit Reißverschluss
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Απελευθερώστε τη σκοτεινή και τολμηρή πλευρά σας με αυτά τα μαύρα μποξεράκια από μικροΐνες, ενισχυμένα με λεπτομέρειες από δίχτυ και ένα υποβλητικό μπροστινό φερμουάρ. Σχεδιασμένο για άντρες που τους αρέσει να παίζουν με τους κώδικες του BDSM, αυτό το παντελόνι προσφέρει εξαιρετική άνεση ενώ διεγείρει τη φαντασία.</p> <p class="text-base">Η μαλακή, ελαστική μικροΐνα προσαρμόζεται τέλεια στο σχήμα του σώματός σας, ενώ τα διχτυωτά ένθετα αποκαλύπτουν διακριτικά το δέρμα σας. Το μπροστινό φερμουάρ είναι τόσο πρακτικό όσο και προκλητικό, επιτρέποντάς σας να ελέγχετε το επίπεδο αποκάλυψης.</p> <p class="text-base"><strong>Χαρακτηριστικά:</strong></p> <ul> <li>Μαύρο παντελόνι από μικροΐνες</li> <li>Ένθετα από δίχτυ</li> <li>Μπροστινό φερμουάρ</li> <li>Μαλακό, ελαστικό ύφασμα</li> <li>Κοντή εφαρμογή</li> </ul> </div>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringΤολμήστε να είστε προκλητικοί με αυτά τα σορτς μπόξερ από μικροΐνες με φερμουάρ, μια αποκλειστική δημιουργία της The Bdsm Boudoir που θα σας κάνει να νιώσετε δυνατοί, σαγηνευτικοί και ακαταμάχητοι.
keywords
string
title
stringΑνδρικό μποξεράκι με φερμουάρ μικροϊνών | The Bdsm Boudoir
seotitle
stringΑνδρικό μποξεράκι με φερμουάρ μικροϊνών: Πρόκληση και έλεγχος
seouri
stringandriko-mpoxeraki-me-fermoyar-mikroinwn-proklhsh-kai-elegchos-mayro
specifications
string
stylingtips
string
summary
string<p>Τολμήστε να γίνετε προκλητικοί με αυτά τα σορτς μπόξερ από μικροΐνες με φερμουάρ που θα σας κάνουν να νιώσετε δυνατοί, σαγηνευτικοί και ακαταμάχητοι.</p>
title
stringΜπόξερ σορτς με φερμουάρ από μικροΐνες
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Unleash your dark and daring side with these black microfiber boxer briefs, enhanced by fishnet details and a suggestive front zip. Designed for men who like to play with BDSM codes, these pants offer exceptional comfort while stimulating the imagination.</p> <p class="text-base">Soft, stretchy microfiber hugs your body perfectly, while fishnet inserts subtly reveal your skin. The front zip, both practical and provocative, lets you control the level of revelation.</p> <p class="text-base"><strong>Features:</strong></p> <ul> <li>Black microfiber pants</li> <li>Fishnet inserts</li> <li>Front zip</li> <li>Soft, stretch fabric</li> <li>Close-fitting cut</li> </ul> </div>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringDare to be provocative with these microfiber zip boxer briefs, an exclusive The BDSM Boudoir creation that will make you feel powerful, seductive and irresistible.
keywords
string
title
stringMen's Microfiber Zip Boxer | The Bdsm Boudoir
seotitle
stringMen's Microfiber Zip Boxer: Provocation and Control
seouri
stringmens-microfiber-zip-boxer-provocation-and-control-black
specifications
string
stylingtips
string
summary
string<p>Dare to be provocative with these microfiber zip boxer shorts that will make you feel powerful, seductive and irresistible.</p>
title
stringMicrofiber zipped boxer shorts
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Da rienda suelta a tu lado oscuro y atrevido con estos calzoncillos bóxer negros de microfibra, realzados con detalles de rejilla y una sugerente cremallera frontal. Diseñados para los hombres a los que les gusta jugar con los códigos del BDSM, estos calzoncillos ofrecen una comodidad excepcional a la vez que estimulan la imaginación.</p> <p class="text-base">La microfibra suave y elástica se amolda perfectamente a la forma de su cuerpo, mientras que las inserciones de rejilla revelan sutilmente su piel. La cremallera frontal es tan práctica como provocativa, ya que te permite controlar el nivel de revelación.</p> <p class="text-base"><strong>Características:</strong></p> <ul> <li>Pantalón negro de microfibra</li> <li>Inserciones de rejilla</li> <li>Cremallera frontal</li> <li>Tejido suave y elástico</li> <li>Corte ajustado</li> </ul> </div>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringAtrévete a ser provocativa con estos calzoncillos con cremallera de microfibra, una creación exclusiva de The BDSM Boudoir que te hará sentir poderosa, seductora e irresistible.
keywords
string
title
stringBoxer con cremallera de microfibra para hombre | The BDSM Boudoir
seotitle
stringBoxer con cremallera de microfibra para hombre: provocación y control
seouri
stringboxer-con-cremallera-de-microfibra-para-hombre-provocacion-y-control-negro
specifications
string
stylingtips
string
summary
string<p>Atrévete a ser provocativo con estos calzoncillos con cremallera de microfibra que te harán sentir poderoso, seductor e irresistible.</p>
title
stringCalzoncillos con cremallera de microfibra
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Lib&eacute;rez votre c&ocirc;t&eacute; sombre et audacieux avec ce boxer en microfibre noire, rehauss&eacute; de d&eacute;tails en r&eacute;sille et d'un zip frontal suggestif. Con&ccedil;u pour les hommes qui aiment jouer avec les codes du BDSM, ce pants vous offre un confort exceptionnel tout en stimulant l'imagination.</p> <p class="text-base">La microfibre douce et extensible &eacute;pouse parfaitement les formes de votre corps, tandis que les empi&egrave;cements en r&eacute;sille d&eacute;voilent subtilement votre peau. Le zip frontal, &agrave; la fois pratique et provocateur, vous permet de contr&ocirc;ler le niveau de r&eacute;v&eacute;lation.</p> <p class="text-base"><strong>Caract&eacute;ristiques :</strong></p> <ul> <li>Pants en microfibre noire</li> <li>Empi&egrave;cements en r&eacute;sille</li> <li>Zip frontal</li> <li>Mati&egrave;re douce et extensible</li> <li>Coupe pr&egrave;s du corps</li> </ul> </div>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringOsez la provocation avec ce boxer microfibre zip, une création exclusive The Bdsm Boudoir qui vous fera sentir puissant, séduisant et irrésistible.
keywords
string
title
stringBoxer Microfibre Zip Homme | The Bdsm Boudoir
seotitle
stringBoxer en Microfibre Zip Homme : Provocation et Contrôle
seouri
stringboxer-en-microfibre-zip-homme-provocation-et-controle-noir
specifications
string
stylingtips
string
summary
string<p>Osez la provocation avec ce boxer microfibre zip qui vous fera sentir puissant, s&eacute;duisant et irr&eacute;sistible.</p>
title
stringBoxer en Microfibre zippé
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Liberate il vostro lato oscuro e audace con questi boxer in microfibra nera, impreziositi da dettagli a rete e da una suggestiva zip frontale. Pensati per gli uomini che amano giocare con i codici del BDSM, questi pantaloni offrono un comfort eccezionale e stimolano l'immaginazione.</p> <p class="text-base">La microfibra morbida ed elastica si modella perfettamente alle forme del corpo, mentre gli inserti a rete rivelano sottilmente la pelle. La cerniera anteriore è pratica e provocante al tempo stesso, in quanto consente di controllare il livello di rivelazione.</p> <p class="text-base"><strong>Caratteristiche:</strong></p> <ul> <li>Pantaloni in microfibra nera</li> <li>Inserti a rete</li> <li>Zip frontale</li> <li>Tessuto morbido ed elastico</li> <li>Vestibilità aderente</li> </ul> </div>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringOsate essere provocanti con questi boxer con zip in microfibra, un'esclusiva creazione The BDSM Boudoir che vi farà sentire potenti, seducenti e irresistibili.
keywords
string
title
stringBoxer con zip in microfibra da uomo The BDSM Boudoir
seotitle
stringBoxer da uomo con zip in microfibra: provocazione e controllo
seouri
stringboxer-da-uomo-con-zip-in-microfibra-provocazione-e-controllo-nero
specifications
string
stylingtips
string
summary
string<p>Osate essere provocanti con questi boxer con zip in microfibra che vi faranno sentire potenti, seducenti e irresistibili.</p>
title
stringBoxer con zip in microfibra
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Laat je duistere en gedurfde kant zien met deze zwarte microvezel boxerslip, verfraaid met visnet details en een suggestieve rits aan de voorkant. Ontworpen voor mannen die graag spelen met de codes van BDSM, biedt deze broek uitzonderlijk comfort en stimuleert tegelijkertijd de verbeelding.</p> <p class="text-base">De zachte, rekbare microvezel vormt zich perfect naar de vorm van je lichaam, terwijl de visnet inzetstukken je huid subtiel onthullen. De rits aan de voorkant is zowel praktisch als provocerend, zodat je de mate van onthulling zelf kunt bepalen.</p> <p class="text-base"><strong>Eigenschappen:</strong></p> <ul> <li>Zwart broekje van microvezel</li> <li>Visnet inzetstukken</li> <li>Ritssluiting aan de voorkant</li> <li>Zachte, rekbare stof</li> <li>Nauwsluitende pasvorm</li> </ul> </div>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringDurf uitdagend te zijn met deze microvezel boxershort met rits, een exclusieve creatie van The BDSM Boudoir die je krachtig, verleidelijk en onweerstaanbaar laat voelen.
keywords
string
title
stringHerenboxer met Microvezel Ritssluiting | The BDSM Boudoir
seotitle
stringHerenboxer met Microvezel Ritssluiting: Provocatie en Controle
seouri
stringherenboxer-met-microvezel-ritssluiting-provocatie-en-controle-zwart
specifications
string
stylingtips
string
summary
string<p>Durf uitdagend te zijn met deze microvezel boxershort met ritssluiting die je krachtig, verleidelijk en onweerstaanbaar laat voelen.</p>
title
stringMicrovezel boxershorts met rits
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<div> <p class="text-base">Liberte o seu lado obscuro e ousado com estas cuecas boxer em microfibra preta, realçadas por detalhes em rede e um sugestivo fecho de correr à frente. Concebidas para os homens que gostam de brincar com os códigos BDSM, estas cuecas oferecem um conforto excecional enquanto estimulam a imaginação.</p> <p class="text-base">A microfibra macia e elástica molda-se perfeitamente à forma do seu corpo, enquanto as inserções em rede revelam subtilmente a sua pele. O fecho de correr à frente é simultaneamente prático e provocante, permitindo-lhe controlar o nível de revelação.</p> <p class="text-base"><strong>Caraterísticas:</strong></p> <ul> <li>Calças de microfibra preta</li> <li>Inserções em rede</li> <li>Fecho frontal</li> <li>Tecido macio e elástico</li> <li>Ajuste justo</li> </ul> </div>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringAtreva-se a ser provocante com estes boxers com fecho em microfibra, uma criação exclusiva The Bdsm Boudoir que a fará sentir-se poderosa, sedutora e irresistível.
keywords
string
title
stringBoxer de microfibra com fecho para homem | The Bdsm Boudoir
seotitle
stringBoxer de microfibra com fecho para homem: provocação e controlo
seouri
stringboxer-de-microfibra-com-fecho-para-homem-provocacao-e-controlo-preto
specifications
string
stylingtips
string
summary
string<p>Atreva-se a ser provocador com estes boxers com fecho de correr em microfibra que o farão sentir-se poderoso, sedutor e irresistível.</p>
title
stringCalções boxer com fecho em microfibra
usageinstructions
string
name
string21333931701
netweight
string
nextshipment
stringtoday
ordered
number1
orderidx
number0
origin
string
originalsize
string
packaging
string
productshipment
stringauto
productuid
string8015D65C-0168-4BD3-AE98F6190AE144D7
promountil
string
rating
stringnone
recorduid
string8015D65C-0168-4BD3-AE98F6190AE144D7
reference
stringLHBA0247
related
string
reserved
string
returned
number0
returnsallowed
number1
section
stringmen
shipment
string4to6days
showbrand
number0
sizeinfos
Query
Template: /system/api/product/sizes.cfc:20
Execution Time: 1.41 ms
Record Count: 5
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,'1357,1358,1359,1360,1361') > 0
and product_variations.productuid = '8015D65C-0168-4BD3-AE98F6190AE144D7'
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
11357S/MintlsizeblackS/MS/M-19999990mpluslingerieSS/M42-4416-1820-2244-4644-4642-4448-5044-4642-4486-9374-81
21358M/LintlsizeblackM/LM/L-19999990mpluslingerieMM/L44-4614-1618-2246-4846-4844-4650-5246-4844-4694-10182-89
31359L/XLintlsizeblackL/XLL/XL-19999990mpluslingerieLL/XL46-4816-1820-2248-5048-5046-4852-5448-5046-48102-10990-99
41360XL/2XLintlsizeblackXL/2XLXL/2XL-19999990mpluslingerieXLXL/2XL48-5018-2022-2450-5250-5248-5054-5650-5248-50110-117100-109
513613XL/4XLintlsizeblack3XL/4XL3XL/4XL-19999990mpluslingerie2XL3XL/4XL50-5220-2224-2852-5452-5450-5256-5852-5450-52118-125110-119
sizeranges
stringplus
sizes
string1357,1358,1359,1360,1361
sizetype
stringintlsize
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: 54.8 ms
Record Count: 5
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 = '8015D65C-0168-4BD3-AE98F6190AE144D7'
and product_variations.isactive = 1
and product_sizes.id_size = 1357
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 = '8015D65C-0168-4BD3-AE98F6190AE144D7'
and product_variations.isactive = 1
and product_sizes.id_size = 1358
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 = '8015D65C-0168-4BD3-AE98F6190AE144D7'
and product_variations.isactive = 1
and product_sizes.id_size = 1359
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 = '8015D65C-0168-4BD3-AE98F6190AE144D7'
and product_variations.isactive = 1
and product_sizes.id_size = 1360
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 = '8015D65C-0168-4BD3-AE98F6190AE144D7'
and product_variations.isactive = 1
and product_sizes.id_size = 1361
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
18015D65C-0168-4BD3-AE98F6190AE144D7414ED81D-16EB-4662-8B5494670025FA8E1357black#000000SS/M42-4416-1820-2244-4644-4642-4448-5044-4642-44mlingerieS/Mintlsize29.12522.4583STOCK01000-10000213339317014024144474387-10all
28015D65C-0168-4BD3-AE98F6190AE144D74A701F7D-718F-4445-AB258DBCE39F29B21358black#000000MM/L44-4614-1618-2246-4846-4844-4650-5246-4844-46mlingerieM/Lintlsize29.12522.4583STOCK01000-10000213339317114024144474394-10all
38015D65C-0168-4BD3-AE98F6190AE144D7C6985C08-BDA3-4C68-962A2B93F75DF8991359black#000000LL/XL46-4816-1820-2248-5048-5046-4852-5448-5046-48mlingerieL/XLintlsize29.12522.4583STOCK01000-10100213339317214024144474400-10all
48015D65C-0168-4BD3-AE98F6190AE144D73B94E860-DEB5-4CE8-9C702413B1057E801360black#000000XLXL/2XL48-5018-2022-2450-5250-5248-5054-5650-5248-50mlingerieXL/2XLintlsize29.12522.4583STOCK01000-10100213339317314024144474417-10all
58015D65C-0168-4BD3-AE98F6190AE144D774D3CCF9-E668-4341-B5643D059B17F9AE1361black#0000002XL3XL/4XL50-5220-2224-2852-5452-5450-5256-5852-5450-52mlingerie3XL/4XLintlsize29.12522.4583STOCK01000-10100213339317414024144474424-10all
subcategory
stringall
supplier
number-1
supplierreference
string21333931731
tags
string
themes
string
totalvariations
string
type
stringdefault
unitprice
number22.4583
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 8.98 ms
Record Count: 5
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 = '8015D65C-0168-4BD3-AE98F6190AE144D7' 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 = '8015D65C-0168-4BD3-AE98F6190AE144D7' 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 = '8015D65C-0168-4BD3-AE98F6190AE144D7' 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 = '8015D65C-0168-4BD3-AE98F6190AE144D7' 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 = '8015D65C-0168-4BD3-AE98F6190AE144D7' 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 = '8015D65C-0168-4BD3-AE98F6190AE144D7' 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 = '8015D65C-0168-4BD3-AE98F6190AE144D7'
and product_variations.isactive = 1
and product_sizes.id_size = 1357
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 = '8015D65C-0168-4BD3-AE98F6190AE144D7' 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 = '8015D65C-0168-4BD3-AE98F6190AE144D7' 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 = '8015D65C-0168-4BD3-AE98F6190AE144D7' 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 = '8015D65C-0168-4BD3-AE98F6190AE144D7' 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 = '8015D65C-0168-4BD3-AE98F6190AE144D7' 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 = '8015D65C-0168-4BD3-AE98F6190AE144D7' 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 = '8015D65C-0168-4BD3-AE98F6190AE144D7'
and product_variations.isactive = 1
and product_sizes.id_size = 1358
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 = '8015D65C-0168-4BD3-AE98F6190AE144D7' 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 = '8015D65C-0168-4BD3-AE98F6190AE144D7' 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 = '8015D65C-0168-4BD3-AE98F6190AE144D7' 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 = '8015D65C-0168-4BD3-AE98F6190AE144D7' 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 = '8015D65C-0168-4BD3-AE98F6190AE144D7' 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 = '8015D65C-0168-4BD3-AE98F6190AE144D7' 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 = '8015D65C-0168-4BD3-AE98F6190AE144D7'
and product_variations.isactive = 1
and product_sizes.id_size = 1359
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 = '8015D65C-0168-4BD3-AE98F6190AE144D7' 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 = '8015D65C-0168-4BD3-AE98F6190AE144D7' 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 = '8015D65C-0168-4BD3-AE98F6190AE144D7' 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 = '8015D65C-0168-4BD3-AE98F6190AE144D7' 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 = '8015D65C-0168-4BD3-AE98F6190AE144D7' 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 = '8015D65C-0168-4BD3-AE98F6190AE144D7' 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 = '8015D65C-0168-4BD3-AE98F6190AE144D7'
and product_variations.isactive = 1
and product_sizes.id_size = 1360
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 = '8015D65C-0168-4BD3-AE98F6190AE144D7' 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 = '8015D65C-0168-4BD3-AE98F6190AE144D7' 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 = '8015D65C-0168-4BD3-AE98F6190AE144D7' 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 = '8015D65C-0168-4BD3-AE98F6190AE144D7' 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 = '8015D65C-0168-4BD3-AE98F6190AE144D7' 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 = '8015D65C-0168-4BD3-AE98F6190AE144D7' 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 = '8015D65C-0168-4BD3-AE98F6190AE144D7'
and product_variations.isactive = 1
and product_sizes.id_size = 1361
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
1414ED81D-16EB-4662-8B5494670025FA8E1357black#000000SS/M42-4416-1820-2244-4644-4642-4448-5044-4642-44mlingerieS/Mintlsize29.12522.4583STOCK01000-10000213339317014024144474387-10-10-10122.4583all
24A701F7D-718F-4445-AB258DBCE39F29B21358black#000000MM/L44-4614-1618-2246-4846-4844-4650-5246-4844-46mlingerieM/Lintlsize29.12522.4583STOCK01000-10000213339317114024144474394-10-10-10122.4583all
3C6985C08-BDA3-4C68-962A2B93F75DF8991359black#000000LL/XL46-4816-1820-2248-5048-5046-4852-5448-5046-48mlingerieL/XLintlsize29.12522.4583STOCK01000-10100213339317214024144474400-10-10-10122.4583all
43B94E860-DEB5-4CE8-9C702413B1057E801360black#000000XLXL/2XL48-5018-2022-2450-5250-5248-5054-5650-5248-50mlingerieXL/2XLintlsize29.12522.4583STOCK01000-10100213339317314024144474417-10-10-10122.4583all
574D3CCF9-E668-4341-B5643D059B17F9AE1361black#0000002XL3XL/4XL50-5220-2224-2852-5452-5450-5256-5852-5450-52mlingerie3XL/4XLintlsize29.12522.4583STOCK01000-10100213339317414024144474424-10-10-10122.4583all
vatrate
number20
warehouse
string