Voir les tailles
Slip Homme ασβέστης Brillant - Matière Lurex Scintillante
Double-cliquez pour agrandir
SKU: LHBA1399
Slip Homme ασβέστης Brillant - Matière Lurex Scintillante
Nouveau
Stock:

Ce slip masculin argenté scintillant révolutionne la lingerie homme avec son tissu lurex aux reflets métalliques. Sa matière extensible et soyeuse procure un confort exceptionnel tout en créant un effet visuel spectaculaire. Parfait pour les hommes qui osent sortir de l'ordinaire avec style et assurance.

Points forts

  • Tissu lurex scintillant aux reflets argentés changeants
  • Transparence subtile pour un effet mystérieux
  • Composition premium 90% polyester, 10% élasthanne
  • Toucher soyeux qui épouse parfaitement les formes
  • Brillance irisée qui subciruela sous tous les éclairages
  • Coupe masculine valorisante qui met en valeur
  • S'adapte à toutes les morphologies grâce à son extensibilité
  • Finitions soignées pour un usage durable
Taille:

Vous ne savez pas quelle taille choisir? Consultez notre guide des tailles

Couleur:
Quantité:
29.95 €
Conseils avisés
par chat, facebook ou par e-mail
Retours gratuits
sous 15 jours *

Slip homme cherry grande taille lurex brillant confort

Description du produit

Ce slip masculin en lurex argenté transforme l'univers de la lingerie homme avec son approche résolument moderne. Le tissu lurex génère des reflets métalliques fascinants qui évoluent selon les mouvements et la lumière, créant un spectacle visuel captivant.

Sa composition technique 90% polyester et 10% élasthanne offre une souplesse remarquable qui s'ajuste naturellement aux contours masculins. Cette alliance de matières procure une sensation de seconde peau tout en conservant sa brillance et sa forme originelle lavage après lavage.

La coupe étudiée respecte l'anatomie masculine en offrant un maintien discret sans compression. Les reflets argentés du lurex créent un jeu de lumière sophistiqué qui transforme ce sous-vêtement en véritable pièce de caractère.

Idéal pour les hommes audacieux qui recherchent l'originalité sans compromis sur le confort, ce slip allie praticité quotidienne et esthétique avant-gardiste. Une pièce qui révèle la personnalité de celui qui la porte avec élégance et modernité.

Détails techniques

  • Matière : 90% Polyester, 10% Élasthanne
  • Finition : Argenté métallique scintillant
  • Transparence : Légère pour un effet subtil
  • Coupe : Slip masculin ajusté
  • Sensation : Douce et extensible
  • Durabilité : Résistant aux lavages répétés

Tailles disponibles

Disponible du S/M au 3XL/4XL

Couleur disponible

Noir

Guide de taille

Vérifiez la taille qui vous convient

International
  • Poitrine
  • Taille
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

Conseils d'entretien

  • Privilégier le lavage à la main ou programme délicat 30°C
  • Choisir une lessive douce pour préserver l'éclat du lurex
  • Éviter l'essorage trop vigoureux qui pourrait altérer les fibres
  • Faire sécher à l'ombre pour maintenir la brillance
  • Proscrire le repassage direct sur la matière lurex
  • Éviter les produits adoucissants qui peuvent ternir
  • Conserver à l'écart des matières rugueuses

Conseils de style

Ce slip lurex s'accorde harmonieusement avec notre sélection de lingerie masculine innovante. Explorez notre lingerie coquine pour homme pour créer des associations audacieuses et cohérentes.

 Les matières scintillantes et les finitions argentées créent une harmonie visuelle saisissante.

Découvrez également nos autres créations pour homme pour diversifier votre collection et exprimer votre personnalité unique. Nos secrets de boudoir complèteront parfaitement vos moments de bien-être personnel.

To Top
Articles
Total articles
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.755 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 = '49EE231C-A42A-4777-BBBA4FD7A8CFB6C1'
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-08-06 12:22: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
booleantrue
hascolorinfos
booleantrue
hascompositions
booleanfalse
hasdescription
booleantrue
hasdimensions
booleanfalse
hasmaterials
booleanfalse
hasotherspecifications
booleanfalse
haspromo
number0
hasshortdescription
booleantrue
hassizeinfos
booleantrue
hasspecifications
booleantrue
hasstockinfos
booleanfalse
hasstylingtips
booleantrue
hasusageinstructions
booleanfalse
hasvariations
booleantrue
import
string
inpromo
number0
instockvariations
string
isactive
number1
iscustommade
number0
isdivasize
number0
isfirstprice
number0
isfixedprice
number0
ishot
number0
isnew
number1
isonline
number0
isoutletprice
number0
itemprice
number24.9583
itempromo
string
key
string21334901741-semi-transparents
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-10-22 18:41:45'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.711 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','fr')
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('49ee231c-a42a-4777-bbba4fd7a8cfb6c1',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.7 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','fr')
and product_categories.language in ('all','fr')
and (products.displayFrom <= DATE(NOW()) or products.displayFrom is null)
and (products.displayTo >= DATE(NOW()) or products.displayTo IS null)
and product_links.linkuid = '49F9CF1F-DB69-4FC1-825FFD4E908DCB2B' and product_links.linkuid is not null and product_links.linkuid <> ''
and products.reference <> 'LHBA1399'
group by products.reference
order by products.ishot desc, products.isnew desc, orderidx asc, products.lastupdated desc
productuidreferencetypekeylanguagenamelinkuidcolorsvatratemetadatasdimensionsmediadatastagsthemesisdivasizetotalvariationsvariationlistinpromohaspromoitempromoitempriceunitpricepricespromountilisfixedpriceishotisneworderidxavailablestockinstockvariationsbrandbrandnameshowbranddisplaysizetypeintlsizesizessizerangecategorymediadatascategorysizerangesectioncategorysubcategory
linkuid
string49F9CF1F-DB69-4FC1-825FFD4E908DCB2B
materials
string
mediadatas
Struct
alt
Struct
height
string788
isprivate
string0
rating
stringall
src
string/photobank/products/sewe/lhba1399/boxer-grande-taille-metallique2.jpg
type
stringimg
width
string1000
back
Struct
height
string1000
isprivate
string0
rating
stringall
src
string/photobank/products/sewe/lhba1399/boxer-grande-taille-metallique.jpg
type
stringimg
width
string966
default
Struct
height
string1000
isprivate
string0
rating
stringall
src
string/photobank/products/sewe/lhba1399/boxer-grande-taille-metallique1.jpg
type
stringimg
width
string946
variations
Struct
colors
Struct
black
Struct
height
string1000
isprivate
string0
rating
stringall
src
string/photobank/products/sewe/lhba1399/boxer-grande-taille-metallique1.jpg
type
stringimg
width
string946
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
stringproducts.svenjoyment.lhba1399
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<ul> <li>Bevorzugen Sie Handwäsche oder ein Schonprogramm bei 30&deg;C</li> <li>Wählen Sie ein Feinwaschmittel, um den Glanz des Lurex zu erhalten</li> <li>vermeiden Sie ein zu starkes Schleudern, da dies die Fasern angreifen kann</li> <li>Im Schatten trocknen lassen, um den Glanz zu erhalten</li> <li>Vermeiden Sie direktes Bügeln auf dem Lurexmaterial</li> <li>vermeiden Sie Weichspüler, da diese das Material trüben können</li> <li>Von rauen Materialien fernhalten</li> </ul>
description
string<p>Dieser <strong>maskuline Slip aus silberfarbenem Lurex</strong> verändert die Welt der Herrenunterwäsche mit seinem ausgesprochen modernen Ansatz. Das Lurexgewebe erzeugt <strong>faszinierende Metallreflexe</strong>, die sich je nach Bewegung und Licht verändern und ein fesselndes visuelles Schauspiel erzeugen.</p> <p>Die <strong>technische Zusammensetzung aus 90% Polyester und 10% Elasthan</strong> sorgt für eine bemerkenswerte Geschmeidigkeit, die sich auf natürliche Weise den männlichen Konturen anpasst. Diese Materialkombination fühlt sich wie eine zweite Haut an und behält auch nach häufigem Waschen ihren Glanz und ihre ursprüngliche Form.</p> <p>Der <strong>durchdachte Schnitt</strong> respektiert die männliche Anatomie und bietet einen diskreten Halt, ohne zu drücken. Der silberne Schimmer des Lurex erzeugt ein raffiniertes Lichtspiel, das diese Unterwäsche in ein echtes Charakterstück verwandelt.</p> <p>Dieser Slip ist ideal für mutige Männer, die Originalität suchen, ohne Kompromisse beim Komfort einzugehen, und vereint <strong>Alltagstauglichkeit mit avantgardistischer Ästhetik</strong>. Ein Stück, das die Persönlichkeit seines Trägers auf elegante und moderne Weise offenbart.</p>
guid
stringhttps://dev.divasboudoir.com/de/-schwarz/lhba1399.htm
highlights
string<ul> <li><strong>Glitzernder Lurex-Stoff</strong> mit wechselnden Silberreflexen</li> <li><strong>Subtile Transparenz</strong> für einen geheimnisvollen Effekt</li> <li><strong>Premium-Zusammensetzung</strong> 90% Polyester, 10% Elasthan</li> <li><strong>Seidiger Griff</strong>, der sich perfekt an die Formen anpasst</li> <li>Schillernder<strong>Glanz</strong>, der in jedem Licht toll aussieht</li> <li><strong>Maskuliner, aufwertender Schnitt</strong>, der die Figur betont</li> <li>Passt sich dank seiner Dehnbarkeit<strong>jeder Körperform an</strong> </li> <li><strong>Sorgfältige Verarbeitung</strong> für eine lange Lebensdauer</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringSilberfarbener, glitzernder Lurex-Slip für Männer in großen Größen. Dehnbares Material, subtile Transparenz, optimaler Tragekomfort. Originelle Herrenunterwäsche bei Diva's Boudoir.
keywords
string
title
stringHerren Slip Silber Lurex Große Größe Brillant | Diva's Boudoir
seotitle
stringSlip für Männer silber große Größe glänzendes Lurex Komfort
seouri
string-schwarz
specifications
string<ul> <li><strong>Material:</strong> 90% Polyester, 10% Elasthan</li> <li><strong>Ausführung:</strong> Metallisch schimmerndes Silber</li> <li><strong>Transparenz:</strong> Leicht für einen subtilen Effekt</li> <li><strong>Schnitt:</strong> Eng anliegender, maskuliner Slip</li> <li><strong>Gefühl:</strong> Weich und dehnbar</li> <li><strong>Haltbarkeit:</strong> Beständig gegen wiederholtes Waschen</li> </ul>
stylingtips
string<p>Dieser Lurex-Slip passt harmonisch zu unserer Auswahl an <strong>innovativer Herrenunterwäsche</strong>. Erkunden Sie unsere <a href="https://www.thebdsmboudoir.com/de/sm-dessous-fur-manner/">frechen Dessous für Männer,</a> um gewagte und stimmige Kombinationen zu schaffen.</p> <p>die <strong>glitzernden Materialien und die silberfarbenen Abschlüsse</strong> sorgen für eine atemberaubende visuelle Harmonie.</p> <p>Entdecken Sie auch unsere anderen <a href="https://www.divasboudoir.com/de/freche-herrenunterwasche/">Kreationen für Männer,</a> um Ihre Kollektion zu diversifizieren und Ihre einzigartige Persönlichkeit zum Ausdruck zu bringen. Unsere <a href="https://www.divasboudoir.com/de/loveshop/">Boudoir-Geheimnisse</a> werden Ihre persönlichen Wohlfühlmomente perfekt ergänzen.</p>
summary
string<p>Dieser <strong>silberne, glitzernde Herr</strong> enslip revolutioniert die Herrenunterwäsche mit seinem metallisch schimmernden Lurexgewebe. Das <strong>dehnbare, seidige Material</strong> sorgt für einen außergewöhnlichen Tragekomfort und erzeugt gleichzeitig einen spektakulären optischen Effekt. Perfekt für Männer, die es wagen, mit Stil und Selbstbewusstsein aus der Masse herauszustechen.</p>
title
stringHerren-Slip Silber Glänzend - Glitzerndes Lurex-Material
usageinstructions
string
el
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Πλύνετε στο χέρι ή σε ευαίσθητο πρόγραμμα 30&deg;C</li> <li>Επιλέξτε ένα ήπιο απορρυπαντικό για να διατηρήσετε τη λάμψη του lurex</li> <li>αποφύγετε το πολύ έντονο στύψιμο, που μπορεί να καταστρέψει τις ίνες</li> <li>Στεγνώστε στη σκιά για να διατηρήσετε τη λάμψη</li> <li>Αποφύγετε το σιδέρωμα απευθείας πάνω στο υλικό lurex</li> <li>αποφύγετε τα μαλακτικά υφασμάτων, τα οποία μπορούν να θαμπώσουν το ύφασμα</li> <li>Μακριά από τραχιά υλικά</li> </ul>
description
string<p>Αυτά τα <strong>ανδρικά σλιπ από ασημί lurex</strong> μεταμορφώνουν τον κόσμο των ανδρικών εσωρούχων με την αποφασιστικά μοντέρνα προσέγγισή τους. Το ύφασμα lurex δημιουργεί <strong>συναρπαστικές μεταλλικές αντανακλάσεις</strong> που αλλάζουν με την κίνηση και το φως, δημιουργώντας ένα μαγευτικό οπτικό θέαμα.</p> <p>Η <strong>τεχνική</strong> του <strong>σύνθεση από 90% πολυεστέρα και 10% ελαστάνη</strong> προσφέρει αξιοσημείωτη ελαστικότητα που προσαρμόζεται φυσικά στα ανδρικά περιγράμματα. Αυτός ο συνδυασμός υλικών μοιάζει με δεύτερο δέρμα, ενώ διατηρεί την αρχική του λάμψη και το σχήμα του από πλύση σε πλύση.</p> <p>Το <strong>μελετημένο κόψιμο</strong> σέβεται την ανδρική ανατομία, προσφέροντας διακριτική στήριξη χωρίς συμπίεση. Η ασημένια λάμψη του lurex δημιουργεί ένα εκλεπτυσμένο παιχνίδι του φωτός που μετατρέπει αυτό το εσώρουχο σε ένα πραγματικό statement κομμάτι.</p> <p>Ιδανικά για τολμηρούς άνδρες που αναζητούν την πρωτοτυπία χωρίς συμβιβασμούς στην άνεση, αυτά τα εσώρουχα συνδυάζουν <strong>την καθημερινή πρακτικότητα με την πρωτοποριακή αισθητική</strong>. Ένα κομμάτι που αποκαλύπτει την προσωπικότητα του χρήστη με κομψότητα και νεωτερικότητα.</p>
guid
stringhttps://dev.divasboudoir.com/el/-mayro/lhba1399.htm
highlights
string<ul> <li><strong>Αστραφτερό ύφασμα lurex</strong> με μεταβαλλόμενες ασημένιες ανταύγειες</li> <li><strong>Λεπτή διαφάνεια</strong> για μυστηριώδες αποτέλεσμα</li> <li><strong>Σύνθεση υψηλής ποιότητας</strong>: 90% πολυεστέρας, 10% ελαστάν</li> <li><strong>Μεταξένια αίσθηση</strong> αγκαλιάζει κάθε σχήμα</li> <li><strong>Ιριδίζουσα λάμψη</strong> που φαίνεται υπέροχα σε κάθε φως</li> <li><strong>Αρρενωπό κόψιμο</strong> που αναδεικνύει τη σιλουέτα</li> <li>Stretch για να<strong>ταιριάζει σε όλα τα σχήματα σώματος</strong> </li> <li><strong>Φροντισμένο φινίρισμα</strong> για μακροχρόνια φθορά</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringΑσημί lurex glitter ανδρικό σλιπ μεγάλο μέγεθος. Ελαστικό ύφασμα, διακριτική διαφάνεια, βέλτιστη άνεση. Πρωτότυπα ανδρικά εσώρουχα από το Diva's Boudoir.
keywords
string
title
stringΑσημί ανδρικά σλιπ Lurex Μεγάλο μέγεθος Shiny | Μπουντουάρ της Ντίβας
seotitle
stringΑσημένια ανδρικά σλιπ μεγάλου μεγέθους γυαλιστερό lurex άνεση
seouri
string-mayro
specifications
string<ul> <li><strong>Υλικό:</strong> 90% πολυεστέρας, 10% ελαστάν</li> <li><strong>Φινίρισμα :</strong> Αστραφτερό μεταλλικό ασημί</li> <li><strong>Διαφάνεια:</strong> Ελαφρύ για διακριτικό αποτέλεσμα</li> <li><strong>Κοπή :</strong> Εφαρμοσμένο ανδρικό σλιπ</li> <li><strong>Αίσθηση:</strong> Μαλακό και ελαστικό</li> <li><strong>Ανθεκτικότητα:</strong> Ανθεκτικό σε επανειλημμένες πλύσεις</li> </ul>
stylingtips
string<p>Αυτά τα σλιπ από lurex ταιριάζουν απόλυτα με την επιλογή μας από <strong>καινοτόμα ανδρικά εσώρουχα</strong>. Εξερευνήστε τα <a href="https://www.thebdsmboudoir.com/el/sexi-eswroycha-gia-andres/">άτακτα ανδρικά εσώρουχα</a> μας για να δημιουργήσετε τολμηρούς, συνεκτικούς συνδυασμούς.</p> <p><strong>τα αστραφτερά υλικά και τα ασημένια φινιρίσματα</strong> δημιουργούν μια εντυπωσιακή οπτική αρμονία.</p> <p>Ανακαλύψτε επίσης τις άλλες <a href="https://www.divasboudoir.com/el/atakta-andrika-eswroycha/">δημιουργίες</a> μας <a href="https://www.divasboudoir.com/el/atakta-andrika-eswroycha/">για άνδρες</a> για να διαφοροποιήσετε τη συλλογή σας και να εκφράσετε τη μοναδική σας προσωπικότητα. Τα <a href="https://www.divasboudoir.com/el/loveshop/">μυστικά του μπουντουάρ</a> μας αποτελούν το τέλειο συμπλήρωμα για τις στιγμές προσωπικής σας ευεξίας.</p>
summary
string<p>Αυτά τα <strong>ασημένια ανδρικά σλιπ που αστράφτουν</strong> φέρνουν επανάσταση στα ανδρικά εσώρουχα με το μεταλλικό ύφασμα lurex. Το <strong>μεταξένιο ελαστικό ύφασμα</strong> παρέχει εξαιρετική άνεση, ενώ παράλληλα δημιουργεί ένα εντυπωσιακό οπτικό αποτέλεσμα. Ιδανικό για άνδρες που τολμούν να βγουν από τα συνηθισμένα με στυλ και αυτοπεποίθηση.</p>
title
stringΑνδρικά γυαλιστερά ασημένια σλιπ - ύφασμα Lurex Sparkle
usageinstructions
string
en
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Prefer hand-wash or delicate 30&deg;C program</li> <li>Choose a mild detergent to preserve lurex lustre</li> <li>avoid spin-drying too vigorously, which could damage the fibers</li> <li>Dry in the shade to maintain shine</li> <li>Avoid direct ironing on lurex fabrics</li> <li>avoid fabric softeners, which can cause dulling</li> <li>Keep away from rough materials</li> </ul>
description
string<p>These <strong>men's briefs in silver lurex</strong> are transforming the world of men's lingerie with their resolutely modern approach. The lurex fabric generates <strong>fascinating metallic reflections</strong> that evolve with movement and light, creating a captivating visual spectacle.</p> <p>Its <strong>technical composition of 90% polyester and 10% elastane</strong> offers a remarkable suppleness that adjusts naturally to men's contours. This combination of materials feels like a second skin, while retaining its original shine and shape wash after wash.</p> <p>The <strong>studied cut</strong> respects the male anatomy, offering discreet support without compression. The silvery sheen of the lurex creates a sophisticated play of light that transforms this underwear into a true statement piece.</p> <p>Ideal for daring men seeking originality without compromising comfort, these briefs combine <strong>everyday practicality with avant-garde aesthetics</strong>. A piece that reveals the wearer's personality with elegance and modernity.</p>
guid
stringhttps://dev.divasboudoir.com/en/-black/lhba1399.htm
highlights
string<ul> <li><strong>Sparkling lurex fabric</strong> with changing silver highlights</li> <li><strong>Subtle transparency</strong> for a mysterious effect</li> <li><strong>Premium composition</strong>: 90% polyester, 10% elastane</li> <li><strong>Silky feel</strong> hugs every shape</li> <li><strong>Iridescent sheen</strong> that glows in every light</li> <li><strong>Enhancing, masculine cut</strong> that stands out from the crowd</li> <li>Stretch fabric<strong>adapts to all body shapes</strong> </li> <li><strong>Carefully finished</strong> for long-lasting wear</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringSilver lurex glitter men's briefs plus size. Stretch fabric, subtle transparency, optimal comfort. Original men's lingerie from Diva's Boudoir.
keywords
string
title
stringSilver men's briefs Lurex Plus Size Shiny | Diva's Boudoir
seotitle
stringSilver men's briefs plus size lurex shiny comfort
seouri
string-black
specifications
string<ul> <li><strong>Material:</strong> 90% Polyester, 10% Elastane</li> <li><strong>Finish:</strong> Sparkling metallic silver</li> <li><strong>Transparency:</strong> Light for a subtle effect</li> <li><strong>Cut:</strong> Fitted men's briefs</li> <li><strong>Feel:</strong> Soft and stretchy</li> <li><strong>Durability:</strong> Resistant to repeated washing</li> </ul>
stylingtips
string<p>These lurex briefs match our selection of <strong>innovative men's lingerie</strong>. Explore our <a href="https://www.thebdsmboudoir.com/en/bondage-lingerie-for-men/">naughty men's lingerie</a> to create bold, cohesive pairings.</p> <p><strong>sparkling materials and silver finishes</strong> create a striking visual harmony.</p> <p>Discover also our other <a href="https://www.divasboudoir.com/en/naughty-mens-lingerie/">creations for men</a> to diversify your collection and express your unique personality. Our <a href="https://www.divasboudoir.com/en/loveshop/">boudoir secrets</a> will perfectly complement your moments of personal well-being.</p>
summary
string<p>These <strong>shimmering silver men's briefs</strong> revolutionize men's lingerie with their metallic lurex fabric. The <strong>silky stretch fabric</strong> provides exceptional comfort while creating a spectacular visual effect. Perfect for men who dare to step out of the ordinary with style and confidence.</p>
title
stringMen's shiny silver briefs - Sparkling Lurex fabric
usageinstructions
string
es
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavar a mano o con un programa delicado a 30 &deg;C</li> <li>Elige un detergente suave para conservar el brillo del lúrex</li> <li>evita centrifugar con demasiada fuerza, ya que podría dañar las fibras</li> <li>Secar a la sombra para mantener el brillo</li> <li>Evite planchar directamente sobre el material de lúrex</li> <li>evite los suavizantes, que pueden deslustrar el tejido</li> <li>Manténgase alejado de materiales ásperos</li> </ul>
description
string<p>Este <strong>slip masculino de lúrex plateado</strong> está transformando el mundo de la lencería masculina con su enfoque decididamente moderno. El tejido de lúrex genera <strong>fascinantes reflejos metálicos</strong> que cambian con el movimiento y la luz, creando un espectáculo visual cautivador.</p> <p>Su <strong>composición técnica de 90% poliéster y 10% elastán</strong> ofrece una flexibilidad notable que se ajusta con naturalidad a los contornos del hombre. Esta combinación de materiales se siente como una segunda piel, conservando su brillo y forma originales lavado tras lavado.</p> <p>El <strong>corte estudiado</strong> respeta la anatomía masculina, ofreciendo una sujeción discreta sin compresión. El brillo plateado del lúrex crea un sofisticado juego de luces que convierte a esta prenda interior en un auténtico objeto de deseo.</p> <p>Ideal para hombres atrevidos que buscan originalidad sin renunciar a la comodidad, este slip combina <strong>la practicidad cotidiana con la estética vanguardista</strong>. Una prenda que revela la personalidad de quien la lleva con elegancia y modernidad.</p>
guid
stringhttps://dev.divasboudoir.com/es/-negro/lhba1399.htm
highlights
string<ul> <li><strong>Tejido de lúrex brillante</strong> con reflejos plateados cambiantes</li> <li><strong>Sutil transparencia</strong> para un efecto misterioso</li> <li><strong>Composición superior</strong>: 90% poliéster, 10% elastano</li> <li><strong>Tacto sedoso</strong> que abraza todas las formas</li> <li><strong>Brillo iridiscente</strong> que luce con cualquier luz</li> <li><strong>Corte masculino</strong> que realza la figura</li> <li>Elástico para<strong>adaptarse a todas las formas del cuerpo</strong> </li> <li><strong>Acabado cuidado</strong> para un uso duradero</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringCalzoncillos de hombre talla grande de lúrex plateado. Tejido elástico, sutil transparencia, comodidad óptima. Lencería masculina original de Diva's Boudoir.
keywords
string
title
stringCalzoncillos plateados para hombre Lurex talla grande Brillante | Boudoir de Diva
seotitle
stringCalzoncillos plateados para hombre talla grande lurex brillante confort
seouri
string-negro
specifications
string<ul> <li><strong>Material:</strong> 90% poliéster, 10% elastán</li> <li><strong>Acabado</strong>: Plata metálica brillante</li> <li><strong>Transparencia</strong>: Ligera para un efecto sutil</li> <li><strong>Corte :</strong> Calzoncillos ajustados para hombre</li> <li><strong>Tacto</strong>: Suave y elástico</li> <li><strong>Durabilidad</strong>: Resistente a lavados repetidos</li> </ul>
stylingtips
string<p>Estas braguitas de lúrex combinan a la perfección con nuestra selección de <strong>lencería masculina innovadora</strong>. Explora nuestra <a href="https://www.thebdsmboudoir.com/es/lenceria-bdsm-para-hombres/">traviesa lencería</a> masculina para crear combinaciones atrevidas y cohesionadas.</p> <p><strong>los materiales brillantes y los acabados plateados</strong> crean una sorprendente armonía visual.</p> <p>Descubre también nuestras otras <a href="https://www.divasboudoir.com/es/lenceria-masculina-atrevida/">creaciones para hombre</a> para diversificar tu colección y expresar tu personalidad única. Nuestros <a href="https://www.divasboudoir.com/es/loveshop/">secretos de tocador</a> son el complemento perfecto para sus momentos de bienestar personal.</p>
summary
string<p>Estos <strong>calzoncillos plateados para hombre</strong> están revolucionando la lencería masculina con su tejido de lúrex metalizado. El <strong>sedoso tejido elástico</strong> proporciona una comodidad excepcional al tiempo que crea un efecto visual espectacular. Perfectos para los hombres que se atreven a salir de lo común con estilo y confianza.</p>
title
stringCalzoncillos plateados brillantes para hombre - Tejido Lurex Sparkle
usageinstructions
string
fr
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Privil&eacute;gier le lavage &agrave; la main ou programme d&eacute;licat 30&deg;C</li> <li>Choisir une lessive douce pour pr&eacute;server l'&eacute;clat du lurex</li> <li>&Eacute;viter l'essorage trop vigoureux qui pourrait alt&eacute;rer les fibres</li> <li>Faire s&eacute;cher &agrave; l'ombre pour maintenir la brillance</li> <li>Proscrire le repassage direct sur la mati&egrave;re lurex</li> <li>&Eacute;viter les produits adoucissants qui peuvent ternir</li> <li>Conserver &agrave; l'&eacute;cart des mati&egrave;res rugueuses</li> </ul>
description
string<p>Ce <strong>slip masculin en lurex argent&eacute;</strong> transforme l'univers de la lingerie homme avec son approche r&eacute;solument moderne. Le tissu lurex g&eacute;n&egrave;re des <strong>reflets m&eacute;talliques fascinants</strong> qui &eacute;voluent selon les mouvements et la lumi&egrave;re, cr&eacute;ant un spectacle visuel captivant.</p> <p>Sa <strong>composition technique 90% polyester et 10% &eacute;lasthanne</strong> offre une souplesse remarquable qui s'ajuste naturellement aux contours masculins. Cette alliance de mati&egrave;res procure une sensation de seconde peau tout en conservant sa brillance et sa forme originelle lavage apr&egrave;s lavage.</p> <p>La <strong>coupe &eacute;tudi&eacute;e</strong> respecte l'anatomie masculine en offrant un maintien discret sans compression. Les reflets argent&eacute;s du lurex cr&eacute;ent un jeu de lumi&egrave;re sophistiqu&eacute; qui transforme ce sous-v&ecirc;tement en v&eacute;ritable pi&egrave;ce de caract&egrave;re.</p> <p>Id&eacute;al pour les hommes audacieux qui recherchent l'originalit&eacute; sans compromis sur le confort, ce slip allie <strong>praticit&eacute; quotidienne et esth&eacute;tique avant-gardiste</strong>. Une pi&egrave;ce qui r&eacute;v&egrave;le la personnalit&eacute; de celui qui la porte avec &eacute;l&eacute;gance et modernit&eacute;.</p>
guid
stringhttps://dev.divasboudoir.com/fr/slip-homme-argente-grande-taille-lurex-brillant/lhba1399.htm
highlights
string<ul> <li><strong>Tissu lurex scintillant</strong> aux reflets argent&eacute;s changeants</li> <li><strong>Transparence subtile</strong> pour un effet myst&eacute;rieux</li> <li><strong>Composition premium</strong> 90% polyester, 10% &eacute;lasthanne</li> <li><strong>Toucher soyeux</strong> qui &eacute;pouse parfaitement les formes</li> <li><strong>Brillance iris&eacute;e</strong> qui subciruela sous tous les &eacute;clairages</li> <li><strong>Coupe masculine valorisante</strong> qui met en valeur</li> <li><strong>S'adapte &agrave; toutes les morphologies</strong> gr&acirc;ce &agrave; son extensibilit&eacute;</li> <li><strong>Finitions soign&eacute;es</strong> pour un usage durable</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringSlip homme petalo di lila lurex scintillant grande taille. Matière extensible, transparence subtile, confort optimal. Lingerie masculine originale chez Diva's Boudoir.
keywords
string
title
stringSlip Homme geele Lurex Grande Taille Brillant | Diva's Boudoir
seotitle
stringSlip homme cherry grande taille lurex brillant confort
seouri
stringslip-homme-argente-grande-taille-lurex-brillant
specifications
string<ul> <li><strong>Mati&egrave;re :</strong> 90% Polyester, 10% &Eacute;lasthanne</li> <li><strong>Finition :</strong> Argent&eacute; m&eacute;tallique scintillant</li> <li><strong>Transparence :</strong> L&eacute;g&egrave;re pour un effet subtil</li> <li><strong>Coupe :</strong> Slip masculin ajust&eacute;</li> <li><strong>Sensation :</strong> Douce et extensible</li> <li><strong>Durabilit&eacute; :</strong> R&eacute;sistant aux lavages r&eacute;p&eacute;t&eacute;s</li> </ul>
stylingtips
string<p>Ce slip lurex s'accorde harmonieusement avec notre s&eacute;lection de <strong>lingerie masculine innovante</strong>. Explorez notre <a href="https://www.thebdsmboudoir.com/fr/lingerie-sexy-pour-homme/">lingerie coquine pour homme</a> pour cr&eacute;er des associations audacieuses et coh&eacute;rentes.</p> <p>&nbsp;Les <strong>mati&egrave;res scintillantes et les finitions argent&eacute;es</strong> cr&eacute;ent une harmonie visuelle saisissante.</p> <p>D&eacute;couvrez &eacute;galement nos autres <a href="https://www.divasboudoir.com/fr/lingerie-homme-coquine/">cr&eacute;ations pour homme</a> pour diversifier votre collection et exprimer votre personnalit&eacute; unique. Nos <a href="https://www.divasboudoir.com/fr/loveshop/">secrets de boudoir</a> compl&egrave;teront parfaitement vos moments de bien-&ecirc;tre personnel.</p>
summary
string<p>Ce <strong>slip masculin argent&eacute; scintillant</strong> r&eacute;volutionne la lingerie homme avec son tissu lurex aux reflets m&eacute;talliques. Sa <strong>mati&egrave;re extensible et soyeuse</strong> procure un confort exceptionnel tout en cr&eacute;ant un effet visuel spectaculaire. Parfait pour les hommes qui osent sortir de l'ordinaire avec style et assurance.</p>
title
stringSlip Homme ασβέστης Brillant - Matière Lurex Scintillante
usageinstructions
string
it
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavare a mano o con un programma delicato a 30&deg;C</li> <li>Scegliere un detersivo delicato per preservare la lucentezza del lurex</li> <li>evitare la centrifuga troppo energica, che potrebbe danneggiare le fibre</li> <li>Asciugare all'ombra per mantenere la lucentezza</li> <li>Evitare di stirare direttamente sul materiale lurex</li> <li>evitare gli ammorbidenti, che possono opacizzare il tessuto</li> <li>Tenere lontano da materiali ruvidi</li> </ul>
description
string<p>Questi <strong>slip da uomo in lurex argento</strong> stanno trasformando il mondo della lingerie maschile con il loro approccio decisamente moderno. Il tessuto lurex genera <strong>affascinanti riflessi metallici</strong> che cambiano con il movimento e la luce, creando uno spettacolo visivo accattivante.</p> <p>La sua <strong>composizione tecnica di 90% poliestere e 10% elastan</strong> offre una notevole morbidezza che si adatta naturalmente ai contorni dell'uomo. Questa combinazione di materiali è come una seconda pelle e mantiene la sua lucentezza e la sua forma originale lavaggio dopo lavaggio.</p> <p>Il <strong>taglio studiato</strong> rispetta l'anatomia maschile, offrendo un sostegno discreto senza comprimere. La lucentezza argentea del lurex crea un sofisticato gioco di luci che trasforma questo capo intimo in un vero e proprio pezzo forte.</p> <p>Ideali per gli uomini audaci che cercano l'originalità senza compromettere il comfort, questi slip combinano la <strong>praticità quotidiana con un'estetica d'avanguardia</strong>. Un capo che rivela la personalità di chi lo indossa con eleganza e modernità.</p>
guid
stringhttps://dev.divasboudoir.com/it/-nero/lhba1399.htm
highlights
string<ul> <li><strong>Tessuto lurex scintillante</strong> con riflessi argento cangianti</li> <li><strong>Sottile trasparenza</strong> per un effetto misterioso</li> <li><strong>Composizione premium</strong>: 90% poliestere, 10% elastan</li> <li><strong>La sensazione di setosità</strong> abbraccia ogni forma</li> <li><strong>Lucentezza iridescente</strong> che risalta in qualsiasi luce</li> <li><strong>Taglio maschile</strong> che valorizza la figura</li> <li>Stretch per<strong>adattarsi a tutte le forme del corpo</strong> </li> <li><strong>Rifinito con cura</strong> per un'usura duratura</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringSlip da uomo in lurex argento taglia grande. Tessuto elasticizzato, sottile trasparenza, comfort ottimale. Lingerie maschile originale di Diva's Boudoir.
keywords
string
title
stringSlip uomo argento Lurex taglia grande Shiny | Diva's Boudoir
seotitle
stringSlip uomo argento taglia grande lurex lucido comfort
seouri
string-nero
specifications
string<ul> <li><strong>Materiale:</strong> 90% poliestere, 10% elastan</li> <li><strong>Finitura:</strong> argento metallizzato scintillante</li> <li><strong>Trasparenza:</strong> Leggera per un effetto discreto</li> <li><strong>Taglio:</strong> Slip aderente da uomo</li> <li><strong>Sensazione:</strong> Morbido ed elastico</li> <li><strong>Durata:</strong> Resistente ai lavaggi ripetuti</li> </ul>
stylingtips
string<p>Questi slip in lurex si abbinano perfettamente alla nostra selezione di <strong>lingerie maschile innovativa</strong>. Esplorate la nostra <a href="https://www.thebdsmboudoir.com/it/lingerie-sexy-per-uomo/">lingerie maschile per</a> creare combinazioni audaci e coese.</p> <p><strong>materiali scintillanti e finiture argentate</strong> creano un'armonia visiva sorprendente.</p> <p>Scoprite anche le altre <a href="https://www.divasboudoir.com/it/lingerie-da-uomo-birichina/">creazioni per uomo</a> per diversificare la vostra collezione ed esprimere la vostra personalità unica. I nostri <a href="https://www.divasboudoir.com/it/negozio-damore/">segreti del boudoir</a> sono il complemento perfetto per i vostri momenti di benessere personale.</p>
summary
string<p>Questi <strong>scintillanti slip da uomo argentati</strong> rivoluzionano la lingerie maschile grazie al loro tessuto lurex metallizzato. Il <strong>tessuto elasticizzato e setoso</strong> offre un comfort eccezionale e crea un effetto visivo spettacolare. Perfetti per gli uomini che osano uscire dall'ordinario con stile e sicurezza.</p>
title
stringSlip uomo argento lucido - Tessuto Lurex Sparkle
usageinstructions
string
nl
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Was met de hand of op een fijnwasprogramma van 30&deg;C</li> <li>Kies een mild wasmiddel om de glans van de lurex te behouden</li> <li>vermijd te hard centrifugeren, dit kan de vezels beschadigen</li> <li>Droog in de schaduw om de glans te behouden</li> <li>Vermijd strijken direct op het lurexmateriaal</li> <li>vermijd wasverzachters, die kunnen de stof dof maken</li> <li>Blijf uit de buurt van ruwe materialen</li> </ul>
description
string<p>Deze <strong>herenslip in zilverkleurige lurex</strong> verandert de wereld van de herenlingerie met zijn resoluut moderne benadering. De lurex stof genereert <strong>fascinerende metallic reflecties</strong> die veranderen bij beweging en licht, waardoor een boeiend visueel spektakel ontstaat.</p> <p>De <strong>technische samenstelling van 90% polyester en 10% elastaan</strong> biedt een opmerkelijke soepelheid die zich op natuurlijke wijze aanpast aan de contouren van de man. Deze combinatie van materialen voelt aan als een tweede huid en behoudt was na was zijn oorspronkelijke glans en vorm.</p> <p>De <strong>bestudeerde snit</strong> respecteert de mannelijke anatomie en biedt discrete ondersteuning zonder compressie. De zilverachtige glans van lurex creëert een geraffineerd lichtspel dat dit ondergoed tot een echt statement maakt.</p> <p>Deze slip is ideaal voor mannen die op zoek zijn naar originaliteit zonder afbreuk te doen aan comfort en combineert <strong>alledaags gemak met avant-gardistische esthetiek</strong>. Een stuk dat de persoonlijkheid van de drager onthult met elegantie en moderniteit.</p>
guid
stringhttps://dev.divasboudoir.com/nl/-zwart/lhba1399.htm
highlights
string<ul> <li><strong>Fonkelende lurex stof</strong> met veranderende zilveren accenten</li> <li><strong>Subtiele transparantie</strong> voor een mysterieus effect</li> <li><strong>Hoogwaardige samenstelling</strong>: 90% polyester, 10% elastaan</li> <li><strong>Zijdeachtig gevoel</strong> omhelst elke vorm</li> <li><strong>Iriserende glans</strong> die er geweldig uitziet in elk licht</li> <li><strong>Een mannelijke snit</strong> die het figuur benadrukt</li> <li>Stretch om<strong>bij alle lichaamsvormen te passen</strong> </li> <li><strong>Zorgvuldig afgewerkt</strong> voor langdurig dragen</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringZilveren lurex glitter herenslip grote maat. Stretchstof, subtiele transparantie, optimaal comfort. Originele herenlingerie van Diva's Boudoir.
keywords
string
title
stringZilveren herenslip Lurex Grote Maat Glimmend | Diva's Boudoir
seotitle
stringZilveren herenslip grote maat glanzend lurex comfort
seouri
string-zwart
specifications
string<ul> <li><strong>Materiaal:</strong> 90% polyester, 10% elastaan</li> <li><strong>Afwerking:</strong> Sprankelend metallic zilver</li> <li><strong>Transparantie:</strong> Licht voor een subtiel effect</li> <li><strong>Snit:</strong> Aansluitende herenslip</li> <li><strong>Voelt:</strong> Zacht en rekbaar</li> <li><strong>Duurzaamheid:</strong> Bestand tegen herhaaldelijk wassen</li> </ul>
stylingtips
string<p>Deze lurex slip past perfect bij onze selectie <strong>innovatieve mannenlingerie</strong>. Ontdek onze <a href="https://www.thebdsmboudoir.com/nl/bondage-lingerie-voor-mannen/">ondeugende mannenlingerie</a> om gedurfde, samenhangende combinaties te maken.</p> <p><strong>sprankelende materialen en zilveren afwerkingen</strong> creëren een opvallende visuele harmonie.</p> <p>Ontdek ook onze andere <a href="https://www.divasboudoir.com/nl/ondeugende-mannenlingerie/">creaties voor mannen</a> om je collectie te diversifiëren en je unieke persoonlijkheid uit te drukken. Onze <a href="https://www.divasboudoir.com/nl/loveshop/">boudoirgeheimen</a> zijn de perfecte aanvulling op je momenten van persoonlijk welzijn.</p>
summary
string<p>Deze <strong>glinsterende zilveren herenslip</strong> is met zijn metallic lurex stof een revolutie in de herenlingerie. De <strong>zijdeachtige stretchstof</strong> biedt uitzonderlijk comfort en creëert tegelijkertijd een spectaculair visueel effect. Perfect voor mannen die stijlvol en zelfverzekerd uit het gewone durven stappen.</p>
title
stringGlanzende zilveren herenslip - Lurex fonkelende stof
usageinstructions
string
pt
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavar à mão ou num programa delicado a 30&deg;C</li> <li>Escolher um detergente suave para preservar o brilho do lurex</li> <li>evitar secar à centrifugação demasiado vigorosa, o que poderia danificar as fibras</li> <li>Secar à sombra para manter o brilho</li> <li>Evitar passar a ferro diretamente sobre o material de lurex</li> <li>evitar amaciadores de roupa, que podem embotar o tecido</li> <li>Manter afastado de materiais ásperos</li> </ul>
description
string<p>Estas <strong>cuecas para homem em lurex prateado</strong> estão a transformar o mundo da lingerie masculina com a sua abordagem decididamente moderna. O tecido lurex gera <strong>reflexos metálicos fascinantes</strong> que mudam com o movimento e a luz, criando um espetáculo visual cativante.</p> <p>A sua <strong>composição técnica de 90% poliéster e 10% elastano</strong> oferece uma flexibilidade notável que se ajusta naturalmente aos contornos do homem. Esta combinação de materiais dá a sensação de uma segunda pele, mantendo o seu brilho e forma originais lavagem após lavagem.</p> <p>O <strong>corte estudado</strong> respeita a anatomia masculina, oferecendo um apoio discreto sem compressão. O brilho prateado do lurex cria um jogo de luz sofisticado que transforma esta roupa interior numa verdadeira peça de referência.</p> <p>Ideal para homens ousados que procuram originalidade sem comprometer o conforto, estas cuecas combinam <strong>a praticidade do dia a dia com uma estética vanguardista</strong>. Uma peça que revela a personalidade de quem a usa com elegância e modernidade.</p>
guid
stringhttps://dev.divasboudoir.com/pt/-preto/lhba1399.htm
highlights
string<ul> <li><strong>Tecido de lurex cintilante</strong> com reflexos prateados variáveis</li> <li><strong>Transparência subtil</strong> para um efeito misterioso</li> <li><strong>Composição premium</strong>: 90% poliéster, 10% elastano</li> <li><strong>O toque sedoso</strong> adapta-se a todas as formas</li> <li><strong>Brilho iridescente</strong> que fica bem em qualquer luz</li> <li><strong>Um corte masculino</strong> que realça a silhueta</li> <li>Alongamento para<strong>se adaptar a todas as formas do corpo</strong> </li> <li><strong>Acabamento cuidadoso</strong> para uma utilização duradoura</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringCuecas de homem grandes em lurex glitter prateado. Tecido elástico, transparência subtil, conforto ideal. Lingerie para homem original da Diva's Boudoir.
keywords
string
title
stringCuecas de homem prateadas Lurex Tamanho grande Brilhante | Diva's Boudoir
seotitle
stringCuecas prateadas para homem tamanho grande lurex brilhante conforto
seouri
string-preto
specifications
string<ul> <li><strong>Material:</strong> 90% poliéster, 10% elastano</li> <li><strong>Acabamento:</strong> Prata metalizado cintilante</li> <li><strong>Transparência:</strong> Ligeira para um efeito subtil</li> <li><strong>Corte:</strong> Cuecas de homem ajustadas</li> <li><strong>Sensação:</strong> Suave e elástica</li> <li><strong>Durabilidade:</strong> Resistente a lavagens repetidas</li> </ul>
stylingtips
string<p>Estas cuecas de lurex combinam perfeitamente com a nossa seleção de <strong>lingerie masculina inovadora</strong>. Explore a nossa <a href="https://www.thebdsmboudoir.com/pt/lingerie-bdsm-para-homem/">lingerie masculina atrevida</a> para criar combinações ousadas e coesas.</p> <p><strong>materiais cintilantes e acabamentos prateados</strong> criam uma harmonia visual impressionante.</p> <p>Descubra também as nossas outras <a href="https://www.divasboudoir.com/pt/lingerie-masculina-atrevida/">criações para homem</a> para diversificar a sua coleção e expressar a sua personalidade única. Os nossos <a href="https://www.divasboudoir.com/pt/loja-de-amor/">segredos de boudoir</a> são o complemento perfeito para os seus momentos de bem-estar pessoal.</p>
summary
string<p>Estas <strong>cuecas prateadas cintilantes para homem</strong> estão a revolucionar a lingerie masculina com o seu tecido de lurex metálico. O <strong>tecido elástico sedoso</strong> proporciona um conforto excecional ao mesmo tempo que cria um efeito visual espetacular. Perfeitas para homens que se atrevem a sair do comum com estilo e confiança.</p>
title
stringCuecas prateadas brilhantes para homem - tecido Lurex Sparkle
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<ul> <li>Von Hand oder in der Waschmaschine bei maximal 30&deg;C waschen</li> <li>Verwenden Sie ein Feinwaschprogramm, um das Lurex zu schonen</li> <li>vermeiden Sie intensives Schleudern, das die Fasern beschädigen könnte</li> <li>Flach liegend ohne direkte Sonneneinstrahlung trocknen</li> <li>Nicht direkt über das Lurex bügeln</li> <li>vermeiden Sie Weichspüler, der den Glanz trüben könnte</li> <li>Getrennt aufbewahren, um ein Verhaken zu vermeiden</li> </ul>
description
string<p>Dieser <strong>maskuline Slip aus silberfarbenem Lurex</strong> definiert mit seinem gewagten und raffinierten Ansatz die Codes der Herrenunterwäsche neu. Das Lurexgewebe erzeugt einen <strong>glitzernden Metalleffekt</strong>, der sofort ins Auge fällt, während die leichte Transparenz eine geheimnisvolle und verführerische Dimension hinzufügt.</p> <p>Die <strong>Zusammensetzung aus 90% Polyester und 10% Elasthan</strong> garantiert eine perfekte Dehnbarkeit, die sich auf natürliche Weise der männlichen Morphologie anpasst. Dieses technische Material fühlt sich seidig weich auf der Haut an und behält auch nach häufigem Waschen seine Form und seinen Glanz.</p> <p>Die <strong>eng anliegende Passform</strong> schmiegt sich perfekt an, ohne einzuengen, und schafft so eine schmeichelhafte, maskuline Silhouette. Der Glanzeffekt des Lurex erzeugt je nach Lichteinfall wechselnde Reflexe und verwandelt diese Unterwäsche in ein echtes verführerisches Accessoire.</p> <p>Dieser Slip ist perfekt für Männer, die sich trauen, über den Tellerrand hinauszuschauen, und vereint <strong>alltäglichen Komfort mit ästhetischer Kühnheit</strong>. Er eignet sich sowohl für das tägliche Tragen als auch für besondere Anlässe, bei denen Sie Ihre einzigartige Persönlichkeit unterstreichen möchten.</p>
highlights
string<ul> <li><strong>Glänzendes Silberlurex</strong> für einen einzigartigen Metallic-Effekt</li> <li><strong>Leicht transparent</strong> für einen geheimnisvollen Touch</li> <li><strong>Weiches, dehnbares Material</strong> 90% Polyester, 10% Elastan</li> <li><strong>Optimaler Tragekomfort</strong> durch eng anliegende Passform</li> <li><strong>Schillernder Effekt</strong>, der das Licht einfängt</li> <li><strong>Schmeichelnde maskuline Passform</strong>, die betont</li> <li><strong>Erhältlich in großen Größen</strong> für alle Körperformen</li> <li><strong>Premium-Qualität</strong> für regelmäßigen Gebrauch</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringHerren-Slip aus transparentem, silbernem Lurex mit glänzendem Metalleffekt. Weiches, dehnbares Material, optimaler Tragekomfort, in großen Größen erhältlich. Gewagte Unterwäsche für Männer. The BDSM Boudoir.
keywords
string
title
stringSlip Herren Lurex silber transparent Große Größe | The BDSM Boudoir
seotitle
stringSlip Mann Lurex silber transparent große Größe BDSM
seouri
stringboxer-schwarz
specifications
string<ul> <li><strong>Zusammensetzung:</strong> 90% Polyester, 10% Elasthan</li> <li><strong>Farbe:</strong> Silbermetallic</li> <li><strong>Effekt :</strong> Glänzendes Lurex, leicht transparent</li> <li><strong>Stil:</strong> Klassisch geschnittener Herrenslip</li> <li><strong>Tragekomfort:</strong> Weiches, dehnbares Material<strong></strong> </li> <li><strong>Pflege:</strong> Feinwäsche empfohlen.</li> <li><strong>Größen:</strong> In großen Größen erhältlich</li> </ul>
stylingtips
string<p>Dieser Lurex-Slip passt perfekt zu unserem Sortiment an <strong>gewagter Herrenunterwäsche</strong>. Die <strong>metallisch glänzenden Materialien</strong> passen perfekt zur Fetisch-Ästhetik.</p> <p>Vervollständigen Sie Ihre Kollektion mit unseren anderen <a href="https://www.thebdsmboudoir.com/fr/bodys-combinaisons-homme-grande-taille/">Teilen der Herrenunterwäsche</a>, um für Abwechslung zu sorgen und Ihre einzigartige Persönlichkeit zu unterstreichen.</p>
summary
string<p>Dieser <strong>Herrenslip aus silberfarbenem Lurex</strong> mit leicht transparentem Finish bietet einen auffallenden Metallic-Effekt. Er ist aus einem <strong>weichen, dehnbaren</strong> Material gefertigt und bietet optimalen Tragekomfort, während er gleichzeitig einen gewagten, raffinierten Look kreiert.</p> <p>Sein <strong>schillernder Glanz</strong> macht ihn zum perfekten Kleidungsstück, um seine Männlichkeit auf elegante und originelle Weise zu betonen.</p>
title
stringHerren Slip aus transparentem, silbernem Lurex - Glänzender Metalleffekt
usageinstructions
string<p>Dieser Lurex-Slip lässt sich wie herkömmliche Unterwäsche tragen, verleiht ihr aber eine <strong>einzigartige ästhetische Dimension</strong>. Sein dehnbares Material passt sich bequem an Ihre Körperform an, ohne sichtbare Abdrücke unter der Kleidung zu erzeugen.</p> <p>Ideal für <strong>besondere Abende, intime Momente</strong> oder einfach nur, um sich im Alltag einzigartig zu fühlen. Der metallische Effekt von Lurex erzeugt ein besonderes Gefühl, wenn es mit der Haut in Berührung kommt, und verleiht dem Erlebnis eine sinnliche Dimension.</p> <p>Für Männer, die originelle Herrenunterwäsche schätzen, kann dieser Slip Teil eines <strong>Ensembles</strong> sein, das mit anderen Lurex- oder Metallteilen <strong>abgestimmt</strong> ist. Sein leicht transparentes Aussehen macht ihn außerdem zu einer gewagten Wahl für verführerische Spiele.</p>
el
Struct
Entries: 14
abstract
string
careinstructions
string<ul> <li>Πλύσιμο στο χέρι ή στο πλυντήριο στους 30&deg;C το πολύ</li> <li>Χρησιμοποιήστε ένα ευαίσθητο πρόγραμμα για να διατηρήσετε το lurex</li> <li>αποφύγετε το έντονο στύψιμο, το οποίο μπορεί να βλάψει τις ίνες</li> <li>Στεγνώστε σε επίπεδη επιφάνεια μακριά από το άμεσο φως</li> <li>Μην σιδερώνετε απευθείας πάνω στο lurex</li> <li>αποφύγετε τα μαλακτικά υφασμάτων, τα οποία μπορούν να αμβλύνουν τη λάμψη</li> <li>Αποθηκεύστε χωριστά για να αποφύγετε τις αγκυλώσεις</li> </ul>
description
string<p>Αυτά τα <strong>ανδρικά σλιπ από ασημί lurex</strong> επαναπροσδιορίζουν τους κώδικες των ανδρικών εσωρούχων με την τολμηρή, εκλεπτυσμένη προσέγγισή τους. Το ύφασμα lurex δημιουργεί ένα <strong>λαμπερό μεταλλικό εφέ</strong> που τραβάει αμέσως το βλέμμα, ενώ η ελαφριά διαφάνεια του προσθέτει μια μυστηριώδη και σαγηνευτική διάσταση.</p> <p>Η <strong>σύνθεση από 90% πολυεστέρα και 10% ελαστάνη</strong> εγγυάται τέλειο τέντωμα που προσαρμόζεται φυσικά στο ανδρικό σώμα. Αυτό το τεχνικό ύφασμα έχει μεταξένια αίσθηση στο δέρμα, ενώ διατηρεί το σχήμα και τη λάμψη του μετά από επανειλημμένες πλύσεις.</p> <p>Η <strong>λεπτή γραμμή</strong> αγκαλιάζει το σώμα χωρίς να συμπιέζει, δημιουργώντας μια κολακευτική, αρρενωπή σιλουέτα. Το λαμπερό εφέ του lurex δημιουργεί μεταβαλλόμενες αντανακλάσεις σε διαφορετικούς φωτισμούς, μετατρέποντας αυτό το εσώρουχο σε ένα πραγματικό αξεσουάρ αποπλάνησης.</p> <p>Ιδανικό για άνδρες που τολμούν να σκεφτούν έξω από το κουτί, αυτό το σλιπ συνδυάζει <strong>την καθημερινή άνεση με μια τολμηρή αισθητική</strong>. Κατάλληλο για καθημερινή χρήση καθώς και για ειδικές περιστάσεις που θέλετε να κάνετε μια δήλωση.</p>
highlights
string<ul> <li><strong>Λαμπερό ασημένιο lurex</strong> για ένα μοναδικό μεταλλικό αποτέλεσμα</li> <li><strong>Ελαφρώς διαφανές</strong> για μια μυστηριώδη πινελιά</li> <li><strong>Μαλακό, ελαστικό ύφασμα</strong> - 90% πολυεστέρας, 10% ελαστάν</li> <li><strong>Βέλτιστη άνεση</strong> χάρη στην άνετη εφαρμογή</li> <li><strong>Το ιριδίζον εφέ</strong> πιάνει το φως</li> <li><strong>Κολακευτικό, αρρενωπό κόψιμο</strong> που αναδεικνύει το σώμα σας με τον καλύτερο τρόπο</li> <li><strong>Διατίθεται σε μεγάλα μεγέθη</strong> για όλα τα σχήματα σώματος</li> <li><strong>Ποιότητα υψηλής ποιότητας</strong> για τακτική χρήση</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringΔιαφανές ασημί ανδρικό σλιπ από lurex, με λαμπερό μεταλλικό εφέ. Μαλακό ελαστικό ύφασμα, βέλτιστη άνεση, διαθέσιμο σε μεγάλα μεγέθη. Τολμηρά ανδρικά εσώρουχα. Το BDSM Μπουντουάρ.
keywords
string
title
stringΑνδρικά διαφανή ασημένια σλιπ Lurex Large | Το BDSM Μπουντουάρ
seotitle
stringΔιαφανές ασημένιο lurex σλιπ μεγάλου μεγέθους BDSM
seouri
stringmpoxer-sorts-mayro
specifications
string<ul> <li><strong>Σύνθεση:</strong> 90% πολυεστέρας, 10% ελαστάν</li> <li><strong>Χρώμα:</strong> Μεταλλικό ασημί</li> <li><strong>Επίδραση:</strong> Λούρεξ: Λαμπερό, ελαφρώς διαφανές lurex</li> <li><strong>Στυλ :</strong> Κλασικό ανδρικό σλιπ</li> <li><strong>Άνεση :</strong> Μαλακό και ελαστικό ύφασμα</li> <li><strong>Φροντίδα</strong>: Συνιστάται απαλό πλύσιμο</li> <li><strong>Μεγέθη</strong>: Διατίθεται σε large</li> </ul>
stylingtips
string<p>Αυτά τα σλιπ από λουρεξ ταιριάζουν απόλυτα με τη σειρά μας από <strong>τολμηρά ανδρικά εσώρουχα</strong>. Τα <strong>μεταλλικά και γυαλιστερά υλικά</strong> συνδυάζονται τέλεια με την αισθητική φετίχ.</p> <p>Συμπληρώστε τη συλλογή σας με τα υπόλοιπα <a href="https://www.thebdsmboudoir.com/fr/bodys-combinaisons-homme-grande-taille/">ανδρικά εσώρουχα που</a> διαθέτουμε για να διαφοροποιήσετε τις απολαύσεις και να επιβεβαιώσετε τη μοναδική σας προσωπικότητα.</p>
summary
string<p>Αυτά τα <strong>ανδρικά σλιπ από ασημί lurex</strong> με ελαφρώς διαφανές φινίρισμα προσφέρουν ένα εντυπωσιακό μεταλλικό εφέ. Κατασκευασμένα από <strong>μαλακό, ελαστικό</strong> ύφασμα, εγγυώνται βέλτιστη άνεση, ενώ παράλληλα δημιουργούν μια τολμηρή, εκλεπτυσμένη εμφάνιση.</p> <p>Η <strong>ιριδίζουσα λάμψη</strong> του το καθιστά το τέλειο κομμάτι για να επιβεβαιώσετε την αρρενωπότητα σας με κομψότητα και πρωτοτυπία.</p>
title
stringΔιαφανές ασημί ανδρικό σλιπ Lurex - Shiny Metallic Effect
usageinstructions
string<p>Αυτά τα σλιπ από lurex μπορούν να φορεθούν όπως τα παραδοσιακά εσώρουχα, προσθέτοντας παράλληλα μια <strong>μοναδική αισθητική διάσταση</strong>. Το ελαστικό ύφασμα προσαρμόζεται άνετα στο σχήμα σας χωρίς να δημιουργεί ορατά σημάδια κάτω από τα ρούχα σας.</p> <p>Ιδανικό για <strong>ξεχωριστές βραδιές, προσωπικές στιγμές</strong> ή απλά για να νιώθετε μοναδικά στην καθημερινότητά σας. Το μεταλλικό εφέ του lurex δημιουργεί μια ιδιαίτερη αίσθηση όταν έρχεται σε επαφή με το δέρμα, προσθέτοντας μια αισθητηριακή διάσταση στην εμπειρία.</p> <p>Για τους άνδρες που εκτιμούν τα πρωτότυπα ανδρικά εσώρουχα, αυτά τα σλιπ μπορούν να αποτελέσουν μέρος ενός <strong>συντονισμένου συνόλου</strong> με άλλα κομμάτια από lurex ή μεταλλικά. Η ελαφρώς διαφανής εμφάνισή του το καθιστά επίσης μια τολμηρή επιλογή για παιχνίδια αποπλάνησης.</p>
en
Struct
Entries: 14
abstract
string
careinstructions
string<ul> <li>Hand or machine wash at 30&deg;C maximum</li> <li>Use a delicate program to preserve the lurex</li> <li>avoid intensive spinning, which can damage fibers</li> <li>Dry flat away from direct light</li> <li>Do not iron directly on lurex</li> <li>avoid fabric softeners, which can dull the luster</li> <li>Store separately to avoid snags</li> </ul>
description
string<p>These <strong>men's briefs in silver lurex</strong> redefine the codes of men's lingerie with their bold, refined approach. The lurex fabric creates a <strong>shimmering metallic effect</strong> that immediately catches the eye, while its slight transparency adds a mysterious, seductive dimension.</p> <p>The <strong>composition of 90% polyester and 10% elastane</strong> guarantees perfect stretch that adapts naturally to the male morphology. This technical fabric offers a silky touch against the skin while maintaining its shape and shine after many washes.</p> <p>The <strong>form-fitting cut</strong> hugs the body without compressing, creating a flattering, masculine silhouette. The lustrous effect of lurex creates changing reflections in different lighting, transforming this underwear into a true accessory of seduction.</p> <p>Perfect for men who dare to think outside the box, these briefs combine <strong>everyday comfort with bold aesthetics</strong>. Suitable for everyday wear as well as special occasions when you want to assert your unique personality.</p>
highlights
string<ul> <li><strong>Shiny silver lurex</strong> for a unique metallic effect</li> <li><strong>Slightly transparent</strong> for a mysterious touch</li> <li><strong>Soft, stretch fabric</strong>: 90% polyester, 10% elastane</li> <li><strong>Optimal comfort</strong> thanks to snug fit</li> <li>Light-catching<strong>iridescent effect</strong> </li> <li><strong>Flattering, masculine cut</strong> that shows off your body to its best advantage</li> <li><strong>Available in plus size</strong> for all body types</li> <li><strong>Premium quality</strong> for regular wear</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringTransparent silver lurex men's briefs, shiny metallic effect. Soft stretch fabric, optimal comfort, available in plus size. Bold men's lingerie. The BDSM Boudoir.
keywords
string
title
stringSlip Homme Lurex argenté transparent Plus Size | The BDSM Boudoir
seotitle
stringTransparent silver lurex men's briefs plus size BDSM
seouri
stringboxer-shorts-black
specifications
string<ul> <li><strong>Composition:</strong> 90% polyester, 10% elastane</li> <li><strong>Color:</strong> Metallic silver</li> <li><strong>Effect:</strong> Shiny, slightly transparent Lurex</li> <li><strong>Style:</strong> Classic men's briefs</li> <li><strong>Comfort:</strong> Soft, stretchy fabric</li> <li><strong>Care :</strong> Delicate wash recommended</li> <li><strong>Sizes :</strong> Available in plus size</li> </ul>
stylingtips
string<p>These lurex briefs are a perfect match for our range of <strong>daring men's underwear</strong>. <strong>Metallic and shiny materials</strong> blend perfectly with the fetish aesthetic.</p> <p>Complete your collection with our other <a href="https://www.thebdsmboudoir.com/fr/bodys-combinaisons-homme-grande-taille/">men's lingerie pieces</a> to vary the pleasures and assert your unique personality.</p>
summary
string<p>These <strong>silver lurex men's briefs</strong> with a slightly transparent finish offer a striking metallic effect. Made from a <strong>soft, stretchy</strong> fabric, they guarantee optimum comfort while creating a bold, sophisticated look.</p> <p>Its <strong>iridescent shine</strong> makes it the perfect piece to assert your masculinity with elegance and originality.</p>
title
stringTransparent silver Lurex men's briefs - Brilliant Metallic Effect
usageinstructions
string<p>These lurex briefs can be worn like traditional underwear, while adding a <strong>unique aesthetic dimension</strong>. The stretch fabric adapts comfortably to your body shape without creating visible marks under your clothes.</p> <p>Ideal for <strong>special evenings, intimate moments</strong> or simply to feel unique in everyday life. The metallic effect of lurex creates a special sensation on contact with the skin, adding a sensory dimension to the experience.</p> <p>For men who appreciate original men's lingerie, these briefs can be part of a <strong>coordinated ensemble</strong> with other lurex or metallic pieces. Its slightly transparent appearance also makes it a daring choice for seductive games.</p>
es
Struct
Entries: 14
abstract
string
careinstructions
string<ul> <li>Lavar a mano o a máquina a 30&deg;C como máximo</li> <li>Utiliza un programa delicado para preservar el lúrex</li> <li>evitar el centrifugado intensivo, que puede dañar las fibras</li> <li>Secar en plano lejos de la luz directa</li> <li>No planchar directamente sobre el lúrex</li> <li>evite el uso de suavizantes, ya que pueden opacar el brillo</li> <li>Guardar por separado para evitar enganches</li> </ul>
description
string<p>Este <strong>slip masculino de lúrex plateado</strong> redefine los códigos de la lencería masculina con su enfoque audaz y refinado. El tejido de lúrex crea un <strong>efecto metálico brillante</strong> que llama inmediatamente la atención, mientras que su ligera transparencia añade una dimensión misteriosa y seductora.</p> <p>La <strong>composición de 90% poliéster y 10% elastano</strong> garantiza una elasticidad perfecta que se adapta naturalmente al cuerpo masculino. Este tejido técnico tiene un tacto sedoso sobre la piel y mantiene su forma y brillo tras varios lavados.</p> <p>El <strong>corte entallado</strong> abraza el cuerpo sin comprimirlo, creando una silueta masculina y favorecedora. El efecto brillante del lúrex crea reflejos cambiantes con distintas iluminaciones, convirtiendo esta ropa interior en un auténtico accesorio de seducción.</p> <p>Perfectos para los hombres que se atreven a pensar con originalidad, estos calzoncillos combinan <strong>la comodidad cotidiana con una estética atrevida</strong>. Adecuados tanto para el día a día como para las ocasiones especiales en las que se desea causar sensación.</p>
highlights
string<ul> <li><strong>Lúrex plateado brillante</strong> para un efecto metálico único</li> <li><strong>Ligeramente transparente</strong> para un toque misterioso</li> <li><strong>Tejido suave y elástico</strong> - 90% poliéster, 10% elastán</li> <li><strong>Comodidad óptima</strong> gracias a su ajuste ceñido</li> <li><strong>Efecto iridiscente</strong> que capta la luz</li> <li><strong>Corte masculino y favorecedor</strong> que realza el cuerpo</li> <li><strong>Disponible en talla grande</strong> para todos los físicos</li> <li><strong>Calidad superior</strong> para un uso regular</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringBraguita masculina de lúrex plateado transparente, efecto metálico brillante. Tejido elástico suave, comodidad óptima, disponible en tallas grandes. Lencería masculina atrevida. The BDSM Boudoir.
keywords
string
title
stringCalzoncillos de lurex plateado transparente para hombre talla grande | The BDSM Boudoir
seotitle
stringCalzoncillos de lurex plateado transparente talla grande BDSM
seouri
stringcalzoncillos-boxer-negro
specifications
string<ul> <li><strong>Composición:</strong> 90% poliéster, 10% elastán</li> <li><strong>Color:</strong> plata metalizado</li> <li><strong>Efecto</strong> Lúrex brillante y ligeramente transparente</li> <li><strong>Estilo :</strong> Calzoncillo clásico de hombre</li> <li><strong>Comodidad :</strong> Tejido suave y elástico</li> <li><strong>Cuidado :</strong> Se recomienda un lavado delicado</li> <li><strong>Tallas</strong>: Disponible en talla grande</li> </ul>
stylingtips
string<p>Estas braguitas de lúrex combinan a la perfección con nuestra gama de <strong>ropa interior masculina atrevida</strong>. Los <strong>materiales metálicos y brillantes</strong> combinan a la perfección con la estética fetichista.</p> <p>Completa tu colección con nuestras otras <a href="https://www.thebdsmboudoir.com/fr/bodys-combinaisons-homme-grande-taille/">piezas de lencería mascul</a> ina para variar los placeres y afirmar tu personalidad única.</p>
summary
string<p>Estos <strong>calzoncillos para hombre de lúrex plateado</strong> con un acabado ligeramente transparente ofrecen un llamativo efecto metálico. Confeccionados en un tejido <strong>suave y elástico</strong>, garantizan un confort óptimo al tiempo que crean un look atrevido y sofisticado.</p> <p>Su <strong>brillo iridiscente</strong> lo convierte en la pieza perfecta para afirmar tu masculinidad con elegancia y originalidad.</p>
title
stringCalzoncillos de hombre Lurex plata transparente - Efecto metálico brillante
usageinstructions
string<p>Estas braguitas de lúrex pueden llevarse como la ropa interior tradicional, al tiempo que añaden una <strong>dimensión estética única</strong>. El tejido elástico se adapta cómodamente a tu figura sin crear marcas visibles bajo la ropa.</p> <p>Ideal para <strong>veladas especiales, momentos íntimos</strong> o simplemente para sentirse única en su día a día. El efecto metálico del lúrex crea una sensación especial al entrar en contacto con la piel, añadiendo una dimensión sensorial a la experiencia.</p> <p>Para los hombres que aprecian la lencería masculina original, estas braguitas pueden formar parte de un <strong>conjunto coordinado</strong> con otras piezas de lúrex o metalizadas. Su aspecto ligeramente transparente también lo convierte en una opción atrevida para los juegos de seducción.</p>
fr
Struct
Entries: 14
abstract
string
careinstructions
string<ul> <li>Laver &agrave; la main ou en machine &agrave; 30&deg;C maximum</li> <li>Utiliser un programme d&eacute;licat pour pr&eacute;server le lurex</li> <li>&Eacute;viter l'essorage intensif qui pourrait endommager les fibres</li> <li>S&eacute;cher &agrave; plat &agrave; l'abri de la lumi&egrave;re directe</li> <li>Ne pas repasser directement sur le lurex</li> <li>&Eacute;viter les adoucissants qui pourraient ternir l'&eacute;clat</li> <li>Ranger s&eacute;par&eacute;ment pour &eacute;viter les accrocs</li> </ul>
description
string<p>Ce <strong>slip masculin en lurex argent&eacute;</strong> red&eacute;finit les codes de la lingerie homme avec son approche audacieuse et raffin&eacute;e. Le tissu lurex cr&eacute;e un <strong>effet m&eacute;tallique scintillant</strong> qui attire imm&eacute;diatement le regard, tandis que sa l&eacute;g&egrave;re transparence ajoute une dimension myst&eacute;rieuse et s&eacute;duisante.</p> <p>La <strong>composition 90% polyester et 10% &eacute;lasthanne</strong> garantit une extensibilit&eacute; parfaite qui s'adapte naturellement &agrave; la morphologie masculine. Cette mati&egrave;re technique offre un toucher soyeux contre la peau tout en maintenant sa forme et son &eacute;clat apr&egrave;s de nombreux lavages.</p> <p>La <strong>coupe ajust&eacute;e</strong> &eacute;pouse parfaitement les formes sans comprimer, cr&eacute;ant une silhouette flatteuse et masculine. L'effet brillant du lurex cr&eacute;e des reflets changeants selon l'&eacute;clairage, transformant ce sous-v&ecirc;tement en v&eacute;ritable accessoire de s&eacute;duction.</p> <p>Parfait pour les hommes qui osent sortir des sentiers battus, ce slip allie <strong>confort quotidien et audace esth&eacute;tique</strong>. Il convient aussi bien au port quotidien qu'aux occasions sp&eacute;ciales o&ugrave; vous souhaitez affirmer votre personnalit&eacute; unique.</p>
highlights
string<ul> <li><strong>Lurex argent&eacute; brillant</strong> pour un effet m&eacute;tallique unique</li> <li><strong>L&eacute;g&egrave;rement transparent</strong> pour un c&ocirc;t&eacute; myst&eacute;rieux</li> <li><strong>Mati&egrave;re douce et extensible</strong> 90% polyester, 10% &eacute;lasthanne</li> <li><strong>Confort optimal</strong> gr&acirc;ce &agrave; la coupe ajust&eacute;e</li> <li><strong>Effet iridescent</strong> qui capte la lumi&egrave;re</li> <li><strong>Coupe masculine flatteuse</strong> qui met en valeur</li> <li><strong>Disponible en grande taille</strong> pour toutes les morphologies</li> <li><strong>Qualit&eacute; premium</strong> pour un usage r&eacute;gulier</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringSlip homme lurex argenté transparent, effet métallique brillant. Matière douce extensible, confort optimal, disponible grande taille. Lingerie masculine audacieuse. The BDSM Boudoir.
keywords
string
title
stringSlip Homme Lurex argenté transparent Grande Taille | The BDSM Boudoir
seotitle
stringSlip homme lurex argenté transparent grande taille BDSM
seouri
stringslip-homme-lurex-argente-transparent-grande-taille
specifications
string<ul> <li><strong>Composition :</strong> 90% Polyester, 10% &Eacute;lasthanne</li> <li><strong>Couleur :</strong> Argent&eacute; m&eacute;tallique</li> <li><strong>Effet :</strong> Lurex brillant, l&eacute;g&egrave;rement transparent</li> <li><strong>Style :</strong> Slip homme coupe classique</li> <li><strong>Confort :</strong> Mati&egrave;re douce et extensible</li> <li><strong>Entretien :</strong> Lavage d&eacute;licat recommand&eacute;</li> <li><strong>Tailles :</strong> Disponible en grande taille</li> </ul>
stylingtips
string<p>Ce slip lurex s'harmonise parfaitement avec notre gamme de <strong>sous-v&ecirc;tements masculins audacieux</strong>. Les <strong>mati&egrave;res m&eacute;talliques et brillantes</strong> se marient parfaitement avec l'esth&eacute;tique f&eacute;tichiste.</p> <p>Compl&eacute;tez votre collection avec nos autres <a href="https://www.thebdsmboudoir.com/fr/bodys-combinaisons-homme-grande-taille/">pi&egrave;ces de lingerie masculine</a> pour varier les plaisirs et affirmer votre personnalit&eacute; unique.&nbsp;</p>
summary
string<p>Ce <strong>slip homme en lurex argent&eacute;</strong> au fini l&eacute;g&egrave;rement transparent offre un effet m&eacute;tallique saisissant. Confectionn&eacute; dans une mati&egrave;re <strong>douce et extensible</strong>, il garantit un confort optimal tout en cr&eacute;ant un look audacieux et sophistiqu&eacute;.</p> <p>Son&nbsp;<strong>aspect brillant iridescent</strong> en fait la pi&egrave;ce parfaite pour affirmer sa masculinit&eacute; avec &eacute;l&eacute;gance et originalit&eacute;.</p>
title
stringSlip Homme Lurex argenté transparent - Effet Métallique Brillant
usageinstructions
string<p>Ce slip lurex se porte comme un sous-v&ecirc;tement traditionnel tout en apportant une <strong>dimension esth&eacute;tique unique</strong>. Sa mati&egrave;re extensible s'adapte confortablement &agrave; votre morphologie sans cr&eacute;er de marques visibles sous les v&ecirc;tements.</p> <p>Id&eacute;al pour les <strong>soir&eacute;es sp&eacute;ciales, les moments intimes</strong> ou simplement pour se sentir unique au quotidien. L'effet m&eacute;tallique du lurex cr&eacute;e une sensation particuli&egrave;re au contact de la peau, ajoutant une dimension sensorielle &agrave; l'exp&eacute;rience.</p> <p>Pour les hommes qui appr&eacute;cient la lingerie masculine originale, ce slip peut faire partie d'un <strong>ensemble coordonn&eacute;</strong> avec d'autres pi&egrave;ces lurex ou m&eacute;talliques. Son aspect l&eacute;g&egrave;rement transparent en fait &eacute;galement un choix audacieux pour les jeux de s&eacute;duction.</p>
it
Struct
Entries: 14
abstract
string
careinstructions
string<ul> <li>Lavare a mano o in lavatrice a 30&deg;C al massimo</li> <li>Usare un programma delicato per preservare il lurex</li> <li>evitare la centrifuga intensiva, che può danneggiare le fibre</li> <li>Asciugare in piano lontano dalla luce diretta</li> <li>Non stirare direttamente sul lurex</li> <li>evitare gli ammorbidenti, che possono opacizzare la lucentezza</li> <li>Conservare separatamente per evitare strappi</li> </ul>
description
string<p>Questi <strong>slip da uomo in lurex argento</strong> ridefiniscono i codici della lingerie maschile con il loro approccio audace e raffinato. Il tessuto lurex crea un <strong>effetto metallico scintillante</strong> che cattura immediatamente lo sguardo, mentre la sua leggera trasparenza aggiunge una dimensione misteriosa e seducente.</p> <p>La <strong>composizione di 90% poliestere e 10% elastan</strong> garantisce una perfetta elasticità che si adatta naturalmente al corpo maschile. Questo tessuto tecnico è setoso sulla pelle e mantiene la sua forma e la sua lucentezza anche dopo ripetuti lavaggi.</p> <p>La <strong>vestibilità slim</strong> abbraccia il corpo senza comprimere, creando una silhouette maschile e lusinghiera. L'effetto lucido del lurex crea riflessi mutevoli a seconda della luce, trasformando questa biancheria intima in un vero e proprio accessorio di seduzione.</p> <p>Perfetti per gli uomini che osano pensare fuori dagli schemi, questi slip combinano il <strong>comfort quotidiano con un'estetica audace</strong>. Adatti per l'abbigliamento quotidiano e per le occasioni speciali in cui si vuole fare una dichiarazione.</p>
highlights
string<ul> <li><strong>Lurex argento lucido</strong> per un effetto metallico unico</li> <li><strong>Leggermente trasparente</strong> per un tocco misterioso</li> <li><strong>Tessuto morbido ed elastico</strong> - 90% poliestere, 10% elastan</li> <li><strong>Comfort ottimale</strong> grazie alla vestibilità aderente</li> <li><strong>Effetto cangiante</strong> che cattura la luce</li> <li><strong>Taglio maschile e lusinghiero</strong> che mette in risalto il vostro corpo</li> <li><strong>Disponibile in taglia grande</strong> per tutte le forme del corpo</li> <li><strong>Qualità premium</strong> per un uso regolare</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringSlip da uomo in lurex argento trasparente, effetto metallizzato lucido. Morbido tessuto elasticizzato, comfort ottimale, disponibile in taglie forti. Lingerie maschile audace. The BDSM Boudoir.
keywords
string
title
stringSlip da uomo in lurex trasparente argento taglia grande | The BDSM Boudoir
seotitle
stringSlip in lurex argento trasparente taglia grande BDSM
seouri
stringboxer-nero
specifications
string<ul> <li><strong>Composizione:</strong> 90% poliestere, 10% elastan</li> <li><strong>Colore:</strong> Argento metallizzato</li> <li><strong>Effetto:</strong> Lurex lucido e leggermente trasparente</li> <li><strong>Stile :</strong> Slip classico da uomo</li> <li><strong>Comfort :</strong> Tessuto morbido ed elastico</li> <li><strong>Cura :</strong> Si consiglia un lavaggio delicato</li> <li><strong>Taglie</strong>: Disponibile in taglia grande</li> </ul>
stylingtips
string<p>Questi slip in lurex si abbinano perfettamente alla nostra gamma di <strong>biancheria intima maschile audace</strong>. I <strong>materiali metallici e lucenti</strong> si fondono perfettamente con l'estetica fetish.</p> <p>Completate la vostra collezione con altri <a href="https://www.thebdsmboudoir.com/fr/bodys-combinaisons-homme-grande-taille/">capi di lingerie maschile</a> per variare i piaceri e affermare la vostra personalità unica.</p>
summary
string<p>Questi <strong>slip da uomo in lurex argento</strong> con finitura leggermente trasparente offrono un sorprendente effetto metallico. Realizzati in un tessuto <strong>morbido ed elasticizzato</strong>, garantiscono un comfort ottimale e creano un look audace e sofisticato.</p> <p>La sua <strong>lucentezza iridescente</strong> lo rende un capo perfetto per affermare la propria mascolinità con eleganza e originalità.</p>
title
stringSlip da uomo in Lurex argento trasparente - Effetto metallizzato lucido
usageinstructions
string<p>Questi slip in lurex possono essere indossati come la biancheria intima tradizionale e aggiungono una <strong>dimensione estetica unica</strong>. Il tessuto elasticizzato si adatta comodamente alle vostre forme senza creare segni visibili sotto i vestiti.</p> <p>Ideale per <strong>serate speciali, momenti intimi</strong> o semplicemente per sentirsi unici nella vita di tutti i giorni. L'effetto metallico del lurex crea una sensazione speciale a contatto con la pelle, aggiungendo una dimensione sensoriale all'esperienza.</p> <p>Per gli uomini che apprezzano la lingerie maschile originale, questi slip possono far parte di un <strong>insieme coordinato</strong> con altri capi in lurex o metallizzati. Il suo aspetto leggermente trasparente lo rende anche una scelta audace per i giochi di seduzione.</p>
nl
Struct
Entries: 14
abstract
string
careinstructions
string<ul> <li>Handwas of machinewas op maximaal 30&deg;C</li> <li>Gebruik een fijnwasprogramma om de lurex te behouden</li> <li>vermijd intensief centrifugeren, dat kan de vezels beschadigen</li> <li>Plat drogen uit de buurt van direct licht</li> <li>Niet rechtstreeks op de lurex strijken</li> <li>vermijd wasverzachters, die kunnen de glans dof maken</li> <li>Apart bewaren om scheuren te voorkomen</li> </ul>
description
string<p>Deze <strong>herenslip in zilverlurex</strong> herdefinieert de codes van herenlingerie met zijn gedurfde, verfijnde aanpak. De lurex stof creëert een <strong>glinsterend metallic effect</strong> dat onmiddellijk in het oog springt, terwijl de lichte transparantie een mysterieuze en verleidelijke dimensie toevoegt.</p> <p>De <strong>samenstelling van 90% polyester en 10% elastaan</strong> garandeert een perfecte stretch die zich op natuurlijke wijze aanpast aan het mannelijk lichaam. Deze technische stof voelt zijdezacht aan tegen de huid en behoudt zijn vorm en glans na herhaaldelijk wassen.</p> <p>De <strong>slanke pasvorm</strong> omhelst het lichaam zonder het samen te drukken, waardoor een flatterend, mannelijk silhouet ontstaat. Het glanzende effect van de lurex zorgt voor veranderende reflecties in verschillende belichtingen, waardoor dit ondergoed een echt verleidingsaccessoire wordt.</p> <p>Perfect voor mannen die buiten de gebaande paden durven te denken, combineert deze slip <strong>alledaags comfort met een gedurfde esthetiek</strong>. Geschikt voor dagelijks gebruik en voor speciale gelegenheden waarbij je een statement wilt maken.</p>
highlights
string<ul> <li><strong>Glanzend zilveren lurex</strong> voor een uniek metallic effect</li> <li><strong>Licht transparant</strong> voor een mysterieuze touch</li> <li><strong>Zachte, rekbare stof</strong> - 90% polyester, 10% elastaan</li> <li><strong>Optimaal comfort</strong> dankzij de goede pasvorm</li> <li><strong>Het iriserende effect</strong> vangt het licht</li> <li><strong>Flatterende, mannelijke snit</strong> die je lichaam optimaal tot zijn recht laat komen</li> <li><strong>Verkrijgbaar in grote maten</strong> voor alle lichaamsvormen</li> <li><strong>Topkwaliteit</strong> voor regelmatig dragen</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringTransparante zilveren lurex herenslip, glanzend metallic effect. Zachte stretchstof, optimaal comfort, verkrijgbaar in grote maten. Gedurfde mannenlingerie. The BDSM Boudoir.
keywords
string
title
stringMannen Transparant Zilveren Lurex Slip Grote Maat | The BDSM Boudoir
seotitle
stringTransparante zilveren lurex slip grote maat BDSM
seouri
stringboxershorts-zwart
specifications
string<ul> <li><strong>Samenstelling:</strong> 90% polyester, 10% elastaan</li> <li><strong>Kleur:</strong> Zilver metallic</li> <li><strong>Effect:</strong> Glanzende, licht transparante lurex</li> <li><strong>Stijl :</strong> Klassieke herenslip</li> <li><strong>Comfort :</strong> Zachte en rekbare stof</li> <li><strong>Onderhoud :</strong> Fijne was aanbevolen</li> <li><strong>Maten</strong>: Verkrijgbaar in grote maten</li> </ul>
stylingtips
string<p>Deze lurex slip past perfect bij ons assortiment <strong>gewaagd mannenondergoed</strong>. De <strong>metallic en glanzende materialen</strong> passen perfect bij de fetisj-esthetiek.</p> <p>Maak je collectie compleet met onze andere <a href="https://www.thebdsmboudoir.com/fr/bodys-combinaisons-homme-grande-taille/">lingerie voor heren</a> om te variëren met plezier en je unieke persoonlijkheid te laten gelden.</p>
summary
string<p>Deze <strong>herenslip in zilverkleurig lurex</strong> met een licht transparante afwerking biedt een opvallend metallic effect. Hij is gemaakt van een <strong>zachte, rekbare</strong> stof en garandeert optimaal comfort terwijl hij een gedurfde, geraffineerde look creëert.</p> <p>Dankzij de <strong>iriserende glans</strong> is dit het perfecte stuk om je mannelijkheid te laten gelden met elegantie en originaliteit.</p>
title
stringTransparant zilveren Lurex herenslip - Glanzend Metallic Effect
usageinstructions
string<p>Deze lurex slip kan gedragen worden als traditioneel ondergoed en voegt tegelijkertijd een <strong>unieke esthetische dimensie</strong> toe. De stretchstof past zich comfortabel aan je vorm aan zonder zichtbare vlekken onder je kleding te maken.</p> <p>Ideaal voor <strong>speciale avonden, intieme momenten</strong> of gewoon om je uniek te voelen in je dagelijks leven. Het metallic effect van lurex creëert een speciale sensatie wanneer het in contact komt met de huid en voegt een zintuiglijke dimensie toe aan de ervaring.</p> <p>Voor mannen die van originele mannenlingerie houden, kan deze slip deel uitmaken van een <strong>gecoördineerd ensemble</strong> met andere lurex of metallic stukken. Het licht transparante uiterlijk maakt het ook een gewaagde keuze voor verleidingsspelletjes.</p>
pt
Struct
Entries: 14
abstract
string
careinstructions
string<ul> <li>Lavar à mão ou na máquina a 30&deg;C no máximo</li> <li>Utilizar um programa delicado para preservar o lurex</li> <li>evitar a centrifugação intensiva, que pode danificar as fibras</li> <li>Secar ao ar livre, longe da luz direta</li> <li>Não passar a ferro diretamente sobre o lurex</li> <li>evitar amaciadores de roupa, que podem esbater o brilho</li> <li>Armazenar separadamente para evitar que o lurex fique preso</li> </ul>
description
string<p>Estas <strong>cuecas para homem em lurex prateado</strong> redefinem os códigos da lingerie masculina com a sua abordagem ousada e refinada. O tecido lurex cria um <strong>efeito metálico cintilante</strong> que chama imediatamente a atenção, enquanto a sua ligeira transparência acrescenta uma dimensão misteriosa e sedutora.</p> <p>A <strong>composição de 90% poliéster e 10% elastano</strong> garante uma elasticidade perfeita que se adapta naturalmente ao corpo masculino. Este tecido técnico é sedoso contra a pele, mantendo a sua forma e brilho após repetidas lavagens.</p> <p>O <strong>corte justo</strong> abraça o corpo sem comprimir, criando uma silhueta lisonjeira e masculina. O efeito brilhante do lurex cria reflexos variáveis em diferentes tipos de iluminação, transformando esta roupa interior num verdadeiro acessório de sedução.</p> <p>Perfeitas para os homens que se atrevem a pensar fora da caixa, estas cuecas combinam <strong>o conforto quotidiano com uma estética arrojada</strong>. Adequado para o uso quotidiano, bem como para ocasiões especiais em que se quer fazer uma declaração.</p>
highlights
string<ul> <li><strong>Lurex prateado brilhante</strong> para um efeito metálico único</li> <li><strong>Ligeiramente transparente</strong> para um toque misterioso</li> <li><strong>Tecido macio e elástico</strong> - 90% poliéster, 10% elastano</li> <li><strong>Conforto ótimo</strong> graças ao ajuste confortável</li> <li><strong>Efeito iridescente</strong> que capta a luz</li> <li><strong>Corte lisonjeiro e masculino</strong> que mostra o seu corpo da melhor forma</li> <li><strong>Disponível em tamanhos grandes</strong> para todas as formas corporais</li> <li><strong>Qualidade superior</strong> para uma utilização regular</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringCuecas de homem em lurex prateado transparente, efeito metálico brilhante. Tecido elástico macio, ótimo conforto, disponível em tamanhos grandes. Lingerie ousada para homem. O Boudoir BDSM.
keywords
string
title
stringCuecas de Lurex Prateado Transparente para Homem Grande | The BDSM Boudoir
seotitle
stringCuecas de lurex prateadas transparentes tamanho grande BDSM
seouri
stringcalcoes-boxer-preto
specifications
string<ul> <li><strong>Composição:</strong> 90% poliéster, 10% elastano</li> <li><strong>Cor:</strong> Prata metalizado</li> <li><strong>Efeito:</strong> Lurex brilhante e ligeiramente transparente</li> <li><strong>Estilo :</strong> Cueca clássica para homem</li> <li><strong>Conforto :</strong> Tecido macio e elástico</li> <li><strong>Cuidados :</strong> Recomenda-se uma lavagem delicada</li> <li><strong>Tamanhos</strong>: Disponível em tamanho grande</li> </ul>
stylingtips
string<p>Estas cuecas de lurex combinam na perfeição com a nossa gama de <strong>roupa interior masculina ousada</strong>. <strong>Os materiais metálicos e brilhantes</strong> combinam na perfeição com a estética fetichista.</p> <p>Complete a sua coleção com as nossas outras <a href="https://www.thebdsmboudoir.com/fr/bodys-combinaisons-homme-grande-taille/">peças de lingerie</a> para <a href="https://www.thebdsmboudoir.com/fr/bodys-combinaisons-homme-grande-taille/">homem</a> para variar os prazeres e afirmar a sua personalidade única.</p>
summary
string<p>Estas <strong>cuecas para homem em lurex prateado</strong> com um acabamento ligeiramente transparente oferecem um efeito metálico impressionante. Confeccionadas num tecido <strong>macio e elástico</strong>, garantem um conforto ótimo, criando um visual arrojado e sofisticado.</p> <p>O seu <strong>brilho iridescente</strong> torna-a a peça perfeita para afirmar a sua masculinidade com elegância e originalidade.</p>
title
stringCuecas de homem em Lurex prateado transparente - Efeito metálico brilhante
usageinstructions
string<p>Estas cuecas de lurex podem ser usadas como roupa interior tradicional, acrescentando uma <strong>dimensão estética única</strong>. O tecido elástico adapta-se confortavelmente à sua forma sem criar marcas visíveis sob a roupa.</p> <p>Ideal para <strong>noites especiais, momentos íntimos</strong> ou simplesmente para se sentir única no seu dia a dia. O efeito metálico do lurex cria uma sensação especial quando entra em contacto com a pele, acrescentando uma dimensão sensorial à experiência.</p> <p>Para os homens que apreciam uma lingerie masculina original, estas cuecas podem fazer parte de um <strong>conjunto coordenado</strong> com outras peças em lurex ou metalizadas. O seu aspeto ligeiramente transparente torna-a também uma escolha ousada para os jogos de sedução.</p>
name
string21334901741 semi transparents
netweight
string
nextshipment
stringtoday
ordered
number0
orderidx
number0
origin
string
originalsize
string
packaging
string
productshipment
stringauto
productuid
string49EE231C-A42A-4777-BBBA4FD7A8CFB6C1
promountil
string
rating
stringnone
recorduid
string49EE231C-A42A-4777-BBBA4FD7A8CFB6C1
reference
stringLHBA1399
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.61 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 = '49EE231C-A42A-4777-BBBA4FD7A8CFB6C1'
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: 25.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 = '49EE231C-A42A-4777-BBBA4FD7A8CFB6C1'
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 = '49EE231C-A42A-4777-BBBA4FD7A8CFB6C1'
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 = '49EE231C-A42A-4777-BBBA4FD7A8CFB6C1'
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 = '49EE231C-A42A-4777-BBBA4FD7A8CFB6C1'
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 = '49EE231C-A42A-4777-BBBA4FD7A8CFB6C1'
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
149EE231C-A42A-4777-BBBA4FD7A8CFB6C1FBCB7FF5-5818-4980-9FF6AC251CFDA9831357black#000000SS/M42-4416-1820-2244-4644-4642-4448-5044-4642-44mlingerieS/Mintlsize24.95830STOCK01000-10000-10all
249EE231C-A42A-4777-BBBA4FD7A8CFB6C1BF5E03C2-1FEE-4F2E-A8E6618FE66FFFF91358black#000000MM/L44-4614-1618-2246-4846-4844-4650-5246-4844-46mlingerieM/Lintlsize24.95830STOCK01000-10000-10all
349EE231C-A42A-4777-BBBA4FD7A8CFB6C13FA5A1D5-0D64-4D18-A95935D96BCF032E1359black#000000LL/XL46-4816-1820-2248-5048-5046-4852-5448-5046-48mlingerieL/XLintlsize24.95830STOCK01000-10000-10all
449EE231C-A42A-4777-BBBA4FD7A8CFB6C13C199DD3-F650-4CF5-8D354A713EF89C7F1360black#000000XLXL/2XL48-5018-2022-2450-5250-5248-5054-5650-5248-50mlingerieXL/2XLintlsize24.95830STOCK01000-11000-10all
549EE231C-A42A-4777-BBBA4FD7A8CFB6C1409D8012-BB24-4735-89844AC98968468B1361black#0000002XL3XL/4XL50-5220-2224-2852-5452-5450-5256-5852-5450-52mlingerie3XL/4XLintlsize24.95830STOCK01000-10000-10all
subcategory
stringall
supplier
number-1
supplierreference
string21334901741
tags
string
themes
string
totalvariations
string
type
stringdefault
unitprice
number24.9583
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 9.32 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 = '49EE231C-A42A-4777-BBBA4FD7A8CFB6C1' 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 = '49EE231C-A42A-4777-BBBA4FD7A8CFB6C1' 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 = '49EE231C-A42A-4777-BBBA4FD7A8CFB6C1' 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 = '49EE231C-A42A-4777-BBBA4FD7A8CFB6C1' 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 = '49EE231C-A42A-4777-BBBA4FD7A8CFB6C1' 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 = '49EE231C-A42A-4777-BBBA4FD7A8CFB6C1' 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 = '49EE231C-A42A-4777-BBBA4FD7A8CFB6C1'
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 = '49EE231C-A42A-4777-BBBA4FD7A8CFB6C1' 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 = '49EE231C-A42A-4777-BBBA4FD7A8CFB6C1' 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 = '49EE231C-A42A-4777-BBBA4FD7A8CFB6C1' 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 = '49EE231C-A42A-4777-BBBA4FD7A8CFB6C1' 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 = '49EE231C-A42A-4777-BBBA4FD7A8CFB6C1' 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 = '49EE231C-A42A-4777-BBBA4FD7A8CFB6C1' 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 = '49EE231C-A42A-4777-BBBA4FD7A8CFB6C1'
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 = '49EE231C-A42A-4777-BBBA4FD7A8CFB6C1' 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 = '49EE231C-A42A-4777-BBBA4FD7A8CFB6C1' 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 = '49EE231C-A42A-4777-BBBA4FD7A8CFB6C1' 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 = '49EE231C-A42A-4777-BBBA4FD7A8CFB6C1' 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 = '49EE231C-A42A-4777-BBBA4FD7A8CFB6C1' 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 = '49EE231C-A42A-4777-BBBA4FD7A8CFB6C1' 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 = '49EE231C-A42A-4777-BBBA4FD7A8CFB6C1'
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 = '49EE231C-A42A-4777-BBBA4FD7A8CFB6C1' 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 = '49EE231C-A42A-4777-BBBA4FD7A8CFB6C1' 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 = '49EE231C-A42A-4777-BBBA4FD7A8CFB6C1' 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 = '49EE231C-A42A-4777-BBBA4FD7A8CFB6C1' 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 = '49EE231C-A42A-4777-BBBA4FD7A8CFB6C1' 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 = '49EE231C-A42A-4777-BBBA4FD7A8CFB6C1' 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 = '49EE231C-A42A-4777-BBBA4FD7A8CFB6C1'
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 = '49EE231C-A42A-4777-BBBA4FD7A8CFB6C1' 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 = '49EE231C-A42A-4777-BBBA4FD7A8CFB6C1' 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 = '49EE231C-A42A-4777-BBBA4FD7A8CFB6C1' 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 = '49EE231C-A42A-4777-BBBA4FD7A8CFB6C1' 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 = '49EE231C-A42A-4777-BBBA4FD7A8CFB6C1' 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 = '49EE231C-A42A-4777-BBBA4FD7A8CFB6C1' 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 = '49EE231C-A42A-4777-BBBA4FD7A8CFB6C1'
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
1FBCB7FF5-5818-4980-9FF6AC251CFDA9831357black#000000SS/M42-4416-1820-2244-4644-4642-4448-5044-4642-44mlingerieS/Mintlsize24.95830STOCK01000-10000-10-10-10024.9583all
2BF5E03C2-1FEE-4F2E-A8E6618FE66FFFF91358black#000000MM/L44-4614-1618-2246-4846-4844-4650-5246-4844-46mlingerieM/Lintlsize24.95830STOCK01000-10000-10-10-10024.9583all
33FA5A1D5-0D64-4D18-A95935D96BCF032E1359black#000000LL/XL46-4816-1820-2248-5048-5046-4852-5448-5046-48mlingerieL/XLintlsize24.95830STOCK01000-10000-10-10-10024.9583all
43C199DD3-F650-4CF5-8D354A713EF89C7F1360black#000000XLXL/2XL48-5018-2022-2450-5250-5248-5054-5650-5248-50mlingerieXL/2XLintlsize24.95830STOCK01000-11000-10-10-10024.9583all
5409D8012-BB24-4735-89844AC98968468B1361black#0000002XL3XL/4XL50-5220-2224-2852-5452-5450-5256-5852-5450-52mlingerie3XL/4XLintlsize24.95830STOCK01000-10000-10-10-10024.9583all
vatrate
number20
warehouse
string