Voir les tailles
Bas Autofixants Résille rose fluo
Double-cliquez pour agrandir
SKU: SLST3195
Bas Autofixants Résille rose fluo
Stock:

Osez les bas résille oui... mais rose fluo! Sexy et exotiques à souhait.

Taille:

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

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

Bas Résille Autofixants Rose Fluo - Audace et Glamour en Grande Taille

Description du produit

Nous vous présentons nos bas résille autofixants les plus audacieux, ils sont rose fluo! 

Bande de silicone sous la dentelle pour le maintien et ligne glamour sur tout l'arrière.

Détails techniques

Tailles disponibles

Disponible du 2-4 au 5-6

Couleur disponible

Rose fluo

Composition

Nylon 80 %
Elasthanne 20 %

Autres caractéristiques techniques

Matière Résille

Conseils d'entretien

  • Lavage à la main recommandé avec un savon doux ou en machine à 30°C maximum dans un filet de protection
  • Évitez les adoucissants qui fragilisent l'élasticité des fibres
  • Séchage à l'air libre à plat, jamais au sèche-linge
  • Manipulez avec des mains propres et sans bijoux pour éviter les accrocs
  • Pour les tailles standard et plus (jusqu'à 64), enfilez délicatement en roulant le bas/collant et en évitant de tirer
  • Rangez séparément des vêtements à fermetures ou crochets qui pourraient les endommager
  • Pour les modèles fantaisie, résilles ou avec motifs, lavez à l'envers pour préserver les détails

Conseils d'utilisation

  • Assurez-vous que votre peau est propre, sèche et sans crème/huile avant l'enfilage
  • Enfilez délicatement en roulant le bas depuis le pied jusqu'à la cuisse
  • Positionnez la bande adhésive juste au-dessus du genou, sur la partie la plus fine de la cuisse
  • Appuyez légèrement sur la bande siliconée pour assurer l'adhérence à la peau
  • Pour les tailles standard à 64, évitez de tirer excessivement sur le tissu pour préserver l'élasticité
  • Si les bas glissent, vérifiez que la bande siliconée est propre et sans résidus
  • Pour un maintien optimal, évitez l'application de lotions ou crèmes sur les cuisses avant le port
To Top
Articles
Total articles
Struct
Entries: 108
actions
Array
available
number-1
brand
stringdreamgirl
brandcode
stringddru
branding
stringdivasboudoir,legsboudoir
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
stringDreamgirl
breasts
stringna
careinstructions
stringstockings
categories
stringdivasboudoir.lingerie.hoisery.stocking
category
stringhoisery
categorygender
stringf
categorymediadatas
Struct
adult
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string628
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/lingerie/hoisery/stockings.jpg
type
stringimg
width
string1365
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.696 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,'fluorose') > 0
and product_variations.productuid = 'A77D0E2F-3E82-4132-8AE38F405B8C4286'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1fluorosecolorfpinfluorosepink#FA22A0-10
colorrange
stringpink
colors
stringfluorose
colortype
stringcolor
comments
string
compositions
Struct
Entries: 13
coton
string
elastane
string20
free
string
leather
string
lycra
string
metal
string
nylon
string80
polyamide
string
polyester
string
polyurethane
string
silk
string
spandex
string
viscose
string
datecreated
Date Time (Europe/Paris)
{ts '2023-10-17 19:03:58'}
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
booleantrue
hasdescription
booleantrue
hasdimensions
booleanfalse
hasmaterials
booleantrue
hasotherspecifications
booleanfalse
haspromo
number0
hasshortdescription
booleantrue
hassizeinfos
booleantrue
hasspecifications
booleanfalse
hasstockinfos
booleanfalse
hasstylingtips
booleanfalse
hasusageinstructions
booleantrue
hasvariations
booleantrue
import
string
inpromo
number0
instockvariations
number0
isactive
number1
iscustommade
number0
isdivasize
number0
isfirstprice
number0
isfixedprice
number0
ishot
number0
isnew
number0
isonline
number0
isoutletprice
number0
itemprice
number14.9583
itempromo
string
key
stringdg0001nxhpkosq
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-10-22 18:45:29'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.668 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('a77d0e2f-3e82-4132-8ae38f405b8c4286',lcase(cart_actions.linkedproducts)) > 0 and cart_actions.linkedproducts is not null
)
id_actionbrandinglanguagenamecodetypeminimumOrdermaximumOrderminimumItemsmaximumItemsmaximumUseallowedItemsquotasusedCountlinkedproductslinkedthemeslinkedbrandslinkeditemparamsactiveFromactiveToisActive
linkedproducts
Query
Template: /system/api/products.cfc:1305
Execution Time: 1.34 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 = '' and product_links.linkuid is not null and product_links.linkuid <> ''
and products.reference <> 'SLST3195'
group by products.reference
order by products.ishot desc, products.isnew desc, orderidx asc, products.lastupdated desc
productuidreferencetypekeylanguagenamelinkuidcolorsvatratemetadatasdimensionsmediadatastagsthemesisdivasizetotalvariationsvariationlistinpromohaspromoitempromoitempriceunitpricepricespromountilisfixedpriceishotisneworderidxavailablestockinstockvariationsbrandbrandnameshowbranddisplaysizetypeintlsizesizessizerangecategorymediadatascategorysizerangesectioncategorysubcategory
linkuid
string
materials
stringmesh
mediadatas
Struct
alt
Struct
height
string2160
isprivate
string0
rating
stringall
src
string/photobank/products/ddru/slst3195/bas_grande_taille_autofixants_rose_flue.jpg
type
stringimg
width
string1494
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string1093
isprivate
string0
rating
stringall
src
string/photobank/products/ddru/slst3195/bas_grande_taille_autofixants_rose_fluo_dos.jpg
type
stringimg
width
string756
variations
Struct
colors
Struct
fluorose
Struct
height
string1093
isprivate
string0
rating
stringall
src
string/photobank/products/ddru/slst3195/bas_grande_taille_autofixants_rose_fluo_dos.jpg
type
stringimg
width
string756
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
mediagallery
string
metadatas
Struct
darkboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-neonpink
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-roz-neon
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-fluo-rose
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-rosa-neon
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-rose-fluo
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-rosa-neon
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-neonroze
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-rosa-neon
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
divasboudoir
Struct
de
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringWir präsentieren Ihnen unsere gewagtesten selbstfixierenden Netzstrümpfe in Neonpink!<br /><br />Silikonstreifen unter der Spitze für Halt und eine glamouröse Linie auf der gesamten Rückseite.
guid
stringhttps://dev.divasboudoir.com/de/niedrig-neonpink/slst3195.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringWagen Sie es, die neonpinkfarbene Farbe unserer selbstfixierenden Netzstrümpfe in Übergröße zu tragen. Originalität, Kühnheit und Sex-Appeal mit einem Hauch von Exotik. Schneller Versand.
keywords
string
title
stringGroße, halterlose Strümpfe in Neonpink. Gewagt und sexy
seotitle
string
seouri
stringniedrig-neonpink
specifications
string
stylingtips
string
summary
stringTrauen Sie sich, Netzstrümpfe zu tragen, aber in Neonpink! Sexy und exotisch.
title
stringSelbstfixierende Netzstrümpfe in Neonpink
usageinstructions
string
el
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringΣας παρουσιάζουμε τις πιο τολμηρές αυτοκόλλητες δικτυωτές κάλτσες μας, σε νέον ροζ χρώμα!<br /><br />Ζώνη σιλικόνης κάτω από τη δαντέλα για στήριξη και λαμπερή γραμμή στο πίσω μέρος.
guid
stringhttps://dev.divasboudoir.com/el/katw-roz-neon/slst3195.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringΤολμήστε να φορέσετε το νέον ροζ των διχτυωτών hold-ups μας σε μεγάλο μέγεθος. Πρωτοτυπία, τόλμη και σεξαπίλ, με μια πινελιά εξωτισμού. Γρήγορη παράδοση.
keywords
string
title
stringΜεγάλα φθορίζοντα ροζ hold-ups. Τολμηρά και σέξι
seotitle
string
seouri
stringkatw-roz-neon
specifications
string
stylingtips
string
summary
stringΤολμήστε να φορέσετε διχτυωτές κάλτσες... αλλά σε νέον ροζ! Σέξι και εξωτικό όσο δεν πάει.
title
stringΚαυτά ροζ fishnet hold ups
usageinstructions
string
en
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringWe present our most daring self-tie fishnet stockings, in neon pink!<br /><br />Silicone band under the lace for support and a glamorous line down the back.
guid
stringhttps://dev.divasboudoir.com/en/bottom-fluo-rose/slst3195.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringDare to wear the neon pink of our plus size fishnet hold-ups. Originality, boldness and sex appeal, with a touch of the exotic. Fast delivery.
keywords
string
title
stringFluorescent pink hold-ups plus size. Bold and sexy
seotitle
string
seouri
stringbottom-fluo-rose
specifications
string
stylingtips
string
summary
stringDare to wear fishnet stockings... but in neon pink! Sexy and exotic.
title
stringHot pink fishnet hold-ups
usageinstructions
string
es
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringPresentamos nuestras medias de rejilla autoadherentes más atrevidas, ¡en rosa neón!<br /><br />Banda de silicona bajo el encaje para mayor sujeción y una glamurosa línea en la espalda.
guid
stringhttps://dev.divasboudoir.com/es/fondo-rosa-neon/slst3195.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringAtrévete con el rosa neón de nuestras medias de rejilla de talla grande. Originalidad, atrevimiento y sex appeal, con un toque exótico. Entrega rápida.
keywords
string
title
stringTallas grandes de color rosa fluorescente. Atrevidas y sexys
seotitle
string
seouri
stringfondo-rosa-neon
specifications
string
stylingtips
string
summary
stringAtrévete con las medias de rejilla... ¡pero en rosa neón! Sexy y exótica a más no poder.
title
stringMedias de rejilla rosa
usageinstructions
string
fr
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>Nous vous pr&eacute;sentons nos bas r&eacute;sille autofixants les plus audacieux, ils sont rose fluo!&nbsp;<br><br>Bande de silicone sous la dentelle pour le maintien et ligne glamour sur tout l'arri&egrave;re.</p>
guid
stringhttps://dev.divasboudoir.com/fr/bas-rose-fluo/slst3195.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringOsez le rose fluo de nos bas résille autofixants grande taille. Originalité, audace et sex-appeal, avec une touche d'exotisme. Envoi rapide.
keywords
string
title
stringBas aufixants grande taille rose fluo. Audacieux et sexys
seotitle
stringBas Résille Autofixants Rose Fluo - Audace et Glamour en Grande Taille
seouri
stringbas-rose-fluo
specifications
string
stylingtips
string
summary
string<p>Osez les bas r&eacute;sille oui... mais rose fluo! Sexy et exotiques &agrave; souhait.</p>
title
stringBas Autofixants Résille rose fluo
usageinstructions
string
it
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringVi presentiamo le nostre calze a rete autoallaccianti più audaci, in rosa neon!<br /><br />Fascia in silicone sotto il pizzo per un sostegno e una linea glamour lungo la schiena.
guid
stringhttps://dev.divasboudoir.com/it/fondo-rosa-neon/slst3195.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringOsate il rosa fluorescente delle nostre autoreggenti a rete di taglia grande. Originalità, audacia e sex appeal, con un tocco esotico. Consegna rapida.
keywords
string
title
stringGrandi autoreggenti rosa fluorescenti. Audace e sexy
seotitle
string
seouri
stringfondo-rosa-neon
specifications
string
stylingtips
string
summary
stringOsate indossare calze a rete... ma in rosa neon! Sexy ed esotiche al punto giusto.
title
stringAutoreggenti a rete rosa caldo
usageinstructions
string
nl
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringWe presenteren onze meest gewaagde zelfbinder visnet kousen, in neon roze!<br /><br />Siliconen band onder het kant voor ondersteuning en een glamoureuze lijn langs de achterkant.
guid
stringhttps://dev.divasboudoir.com/nl/bodem-neonroze/slst3195.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringDurf het neonroze van onze groote maten visnet hold-ups te dragen. Originaliteit, durf en sexappeal, met een vleugje exotisch. Snelle levering.
keywords
string
title
stringGroote fluorescerende roze hold-ups. Gedurfd en sexy
seotitle
string
seouri
stringbodem-neonroze
specifications
string
stylingtips
string
summary
stringDurf visnetkousen te dragen... maar dan in neonroze! Sexy en exotisch als het maar kan.
title
stringWarmroze netkousen
usageinstructions
string
pt
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringApresentamos as nossas meias de rede mais ousadas, em rosa néon!<br /><br />Faixa de silicone por baixo da renda para apoio e uma linha glamorosa nas costas.
guid
stringhttps://dev.divasboudoir.com/pt/fundo-rosa-neon/slst3195.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringAtreva-se a usar o rosa fluorescente das nossas meias de rede de tamanho grande. Originalidade, ousadia e sex appeal, com um toque de exotismo. Entrega rápida.
keywords
string
title
stringGrandes meias cor-de-rosa fluorescente. Arrojadas e sensuais
seotitle
string
seouri
stringfundo-rosa-neon
specifications
string
stylingtips
string
summary
stringAtreva-se a usar meias de rede... mas em rosa néon! Sexy e exótica ao máximo.
title
stringCalças de rede cor-de-rosa
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-neonpink
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-roz-neon
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-fluo-rose
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-rosa-neon
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-rose-fluo
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-rosa-neon
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-neonroze
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-rosa-neon
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-neonpink
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-roz-neon
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-fluo-rose
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-rosa-neon
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-rose-fluo
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-rosa-neon
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-neonroze
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-rosa-neon
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
legsboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Diese <strong>selbstfixierenden Netzstrümpfe in Neonpink</strong> verkörpern Kühnheit und moderne Weiblichkeit.</p> <p>Ihre <strong>vibrierende neonpinkfarbene Farbe</strong> verleiht Ihrer intimen Garderobe einen Hauch von Originalität, während das <strong>zarte Netzmaterial</strong> ein besonders verführerisches Spiel mit der Transparenz erzeugt.</p> <p>Das <strong>selbstfixierende System mit einem Silikonband</strong>, das diskret unter der Spitze platziert ist, sorgt <strong>den ganzen Tag lang für perfekten Halt</strong>, ohne zu drücken oder auf der Haut zu zeichnen.</p> <p>Diese Technologie ermöglicht <strong>absolute Bewegungsfreiheit</strong> und garantiert gleichzeitig, dass Ihre Strümpfe perfekt an ihrem Platz bleiben.</p> <p>Die <strong>glamouröse Linie, die auf der Rückseite des Beins verläuft</strong>, fügt eine raffinierte ästhetische Dimension hinzu und schafft eine <strong>schlanke Silhouette</strong> und einen besonders schmeichelhaften visuellen Effekt.</p> <p>Diese sorgfältige Verarbeitung verwandelt einen einfachen Strumpf in ein echtes Modeaccessoire.</p> <p>Diese Strümpfe sind so konzipiert, dass sie sich <strong>jeder Körperform</strong> anpassen. Sie bieten einen <strong>außergewöhnlichen Tragekomfort</strong> dank ihres durchdachten Schnitts und des weichen Materials, das sich natürlich an die Formen anpasst, ohne zu spannen.</p>
highlights
string<ul> <li><strong>Gewagte neonpinkfarbene Farbe</strong> für einen einzigartigen Stil</li> <li><strong>Silikonband unter der Spitze</strong> für optimalen Halt</li> <li><strong>Glamouröse Linie auf der Rückseite</strong> für einen raffinierten Effekt</li> <li><strong>Bequemes Netzmaterial</strong>, das sich perfekt an die Kurven anpasst</li> <li><strong>Praktische Autofixierung</strong> ohne Strumpfhalter</li> <li><strong>Erhältlich für alle Körperformen</strong></li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringSelbstfixierende Netzstrümpfe in Neonpink mit Silikonband in großen Größen. Perfekter Halt und gewagter Stil für alle Körperformen bei Leg's Boudoir.
keywords
string
title
stringNetzstrümpfe Fluo Pink Große Größe | Leg's Boudoir
seotitle
stringSelbstfixierende Netzstrümpfe in Neonpink Große Größe
seouri
stringselbstfixierende-netzstrumpfe-in-neonpink,-grosse-grosse
specifications
string<ul> <li><strong>Material</strong>: Hochwertiges elastisches Netz</li> <li><strong>Farbe</strong>: Neonpink</li> <li><strong>Typ</strong>: Autofixants mit Silikonband</li> <li><strong>Verarbeitung</strong>: Glamouröse Rückenlinie</li> <li><strong>Größen</strong>: In verschiedenen Größen erhältlich</li> <li><strong>Halt</strong>: Silikonband unter Spitze</li> </ul>
stylingtips
string<p>Das <strong>Neonpink</strong> dieser Strümpfe macht sie zu einem perfekten Statement-Accessoire für <strong>schräge und moderne</strong> Looks.</p> <p>Kombinieren Sie sie mit schwarzen oder weißen Teilen, um ihre vibrierende Farbe hervorzuheben, oder wagen Sie einen farbenfrohen Total Look für einen selbstbewussten Stil.</p> <p>Die <strong>glamouröse hintere Linie</strong> kommt besonders gut zur Geltung, wenn Sie hochhackige Schuhe und kurze Röcke oder Shorts dazu tragen.</p>
summary
string<p><strong>Wagen Sie etwas Neues mit unseren selbstfixierenden Netzstrümpfen in Neonpink</strong>, die mit ihrem <strong>Silikonband unter der Spitze</strong> und der <strong>glamourösen Rückenlinie</strong> für jeden Körperbau geeignet sind.</p> <p>Diese Strümpfe vereinen <strong>perfekten Halt</strong> und <strong>exotischen Stil</strong> für einen Look, der nicht unbemerkt bleibt.</p>
title
stringSelbstfixierende Netzstrümpfe in Neonpink - Kühnheit und Glamour in großen Größen
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Αυτά τα <strong>neon ροζ διχτυωτά hold-ups</strong> είναι η επιτομή της τολμηρής και μοντέρνας θηλυκότητας.</p> <p>Το <strong>έντονο νέον ροζ χρώμα</strong> τους προσθέτει μια πινελιά πρωτοτυπίας στην προσωπική σας γκαρνταρόμπα, ενώ το <strong>λεπτό δίχτυ</strong> δημιουργεί ένα ιδιαίτερα σαγηνευτικό παιχνίδι διαφάνειας.</p> <p>Το <strong>σύστημα αυτοσυγκράτησης με μια ζώνη σιλικόνης</strong> που τοποθετείται διακριτικά κάτω από τη δαντέλα εξασφαλίζει <strong>τέλεια στήριξη όλη την ημέρα</strong> χωρίς να συμπιέζει ή να σημαδεύει το δέρμα.</p> <p>Αυτή η τεχνολογία επιτρέπει την <strong>απόλυτη ελευθερία κινήσεων</strong>, ενώ παράλληλα διασφαλίζει ότι οι κάλτσες σας παραμένουν τέλεια στη θέση τους.</p> <p>Η <strong>λαμπερή γραμμή που διατρέχει το πίσω μέρος του ποδιού</strong> προσθέτει μια εκλεπτυσμένη αισθητική διάσταση, δημιουργώντας μια <strong>λεπτή σιλουέτα</strong> και ένα ιδιαίτερα κολακευτικό οπτικό αποτέλεσμα.</p> <p>Αυτό το επιμελημένο φινίρισμα μετατρέπει μια απλή κάλτσα σε πραγματικό αξεσουάρ μόδας.</p> <p>Σχεδιασμένες για να ταιριάζουν <strong>σε όλα τα σχήματα σώματος</strong>, αυτές οι κάλτσες προσφέρουν <strong>εξαιρετική άνεση</strong> χάρη στο μελετημένο κόψιμο και το εύπλαστο ύφασμα, το οποίο προσαρμόζεται φυσικά στο σχήμα χωρίς να δημιουργεί ένταση.</p>
highlights
string<ul> <li><strong>Έντονο ροζ χρώμα νέον</strong> για μοναδικό στυλ</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Φωσφορίζον ροζ διχτυωτά hold ups με ζώνη σιλικόνης. Τέλεια στήριξη και τολμηρό στυλ για όλα τα σχήματα σώματος στο Leg's Boudoir.
keywords
string
title
stringΦωσφορίζον ροζ Fishnet κάλτσες Large | Leg's Boudoir
seotitle
stringΦωσφορίζον ροζ διχτυωτά hold ups Large
seouri
stringneon-roz-aytokollhtes-dichtywtes-kaltses-megales
specifications
string<ul> <li><strong>Υλικό</strong>: Υψηλής ποιότητας ελαστικό πλέγμα</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>Το <strong>ροζ νέον</strong> χρώμα αυτών των καλτσών τις καθιστά το τέλειο αξεσουάρ για τη δημιουργία <strong>ιδιόρρυθμων, μοντέρνων</strong> εμφανίσεων.</p> <p>Συνδυάστε τες με μαύρα ή λευκά κομμάτια για να αναδείξετε το έντονο χρώμα τους ή επιλέξτε μια εντελώς χρωματική εμφάνιση για μια τολμηρή δήλωση στυλ.</p> <p>Η <strong>λαμπερή πίσω γραμμή</strong> ενισχύεται ιδιαίτερα με τακούνια και κοντές φούστες ή σορτς.</p>
summary
string<p><strong>Τολμήστε να είστε τολμηρές με τα neon ροζ διχτυωτά μας hold-ups</strong>, σχεδιασμένα για να αναδεικνύουν κάθε σωματότυπο με τη <strong>ζώνη σιλικόνης κάτω από τη δαντέλα</strong> και <strong>τη γοητευτική πίσω γραμμή.</strong></p> <p>Αυτές οι κάλτσες συνδυάζουν <strong>τέλεια στήριξη</strong> και <strong>εξωτικό στυλ</strong> για μια εμφάνιση που δεν θα περάσει απαρατήρητη.</p>
title
stringΦθορίζον ροζ καλσόν με δίχτυ ψαριού - Audacity and Glamour μεγάλο μέγεθος
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>These <strong>neon pink self-tie fishnet stockings</strong> embody boldness and modern femininity.</p> <p>Their <strong>vibrant neon pink color</strong> adds a touch of originality to your intimate wardrobe, while the <strong>delicate fishnet</strong> creates a particularly seductive play of transparency.</p> <p>The <strong>self-fixing system with silicone band</strong> discreetly placed under the lace ensures <strong>perfect support all day long</strong> without compressing or marking the skin.</p> <p>This technology allows <strong>total freedom of movement</strong> while ensuring that your stockings stay perfectly in place.</p> <p>The <strong>glamorous line running down the back of the leg</strong> adds a refined aesthetic dimension, creating a <strong>sleek silhouette</strong> and a particularly flattering visual effect.</p> <p>This meticulous finish transforms a simple stocking into a true fashion accessory.</p> <p>Designed to fit <strong>all body shapes</strong>, these stockings offer <strong>exceptional comfort</strong> thanks to their studied cut and supple fabric that naturally conforms to the shape without creating tension.</p>
highlights
string<ul> <li><strong>Bold neon pink color</strong> for unique style</li> <li><strong>Silicone band under lace</strong> for optimal support</li> <li><strong>Glamorous line on the back</strong> for a sophisticated effect</li> <li><strong>Comfortable fishnet</strong> hugs every curve</li> <li><strong>Practical self-ties</strong> without garter belt</li> <li><strong>Available for all body shapes</strong></li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringFluorescent pink fishnet hold-ups plus size with silicone band. Perfect support and bold style for all body types at Leg's Boudoir.
keywords
string
title
stringFluorescent Pink Fishnet Stockings Plus Size | Leg's Boudoir
seotitle
stringFluorescent pink fishnet hold ups Plus Size
seouri
stringneon-pink-self-fixing-fishnet-stockings-plus-size
specifications
string<ul> <li><strong>Material</strong>: High-quality elastic mesh</li> <li><strong>Color</strong>: Fluorescent pink</li> <li><strong>Type</strong>: Self-fixing with silicone band</li> <li><strong>Finish</strong>: Glamorous back line</li> <li><strong>Sizes</strong>: Available in several sizes</li> <li><strong>Support</strong>: Silicone band under lace</li> </ul>
stylingtips
string<p>The <strong>neon pink</strong> of these stockings makes them the perfect statement accessory for creating <strong>quirky, modern</strong> looks.</p> <p>Pair them with black or white pieces to bring out their vibrant color, or dare the colorful total look for an assertive style.</p> <p>The <strong>glamorous back line</strong> is particularly enhanced with heels and short skirts or shorts.</p>
summary
string<p><strong>Dare to be daring with our neon-pink fishnet hold-ups</strong>, designed to sublimate all body types with their <strong>silicone band under lace</strong> and <strong>glamorous back line.</strong></p> <p>These stockings combine <strong>perfect support</strong> and <strong>exotic style</strong> for a look that won't go unnoticed.</p>
title
stringFluorescent pink fishnet hold ups - Audacious and Glamorous Plus Size
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><strong>Estas medias de rejilla rosa neón</strong> son el epítome de la feminidad atrevida y moderna.</p> <p>Su <strong>vibrante color rosa neón</strong> aporta un toque de originalidad a tu vestuario íntimo, mientras que la <strong>delicada red de re</strong> jilla crea un juego de transparencias especialmente seductor.</p> <p>El <strong>sistema de autofijación con una banda de silicona</strong> discretamente colocada bajo el encaje garantiza <strong>una sujeción perfecta durante todo el día</strong>, sin comprimir ni marcar la piel.</p> <p>Esta tecnología permite <strong>una total libertad de movimientos</strong> al tiempo que garantiza que las medias permanezcan perfectamente en su sitio.</p> <p>La <strong>glamurosa línea que recorre la parte posterior de la pierna</strong> añade una refinada dimensión estética, creando una <strong>silueta estilizada</strong> y un efecto visual especialmente favorecedor.</p> <p>Este minucioso acabado transforma una simple media en un auténtico accesorio de moda.</p> <p>Diseñadas para adaptarse a <strong>todas las formas del cuerpo</strong>, estas medias ofrecen <strong>una comodidad excepcional</strong> gracias a su corte estudiado y a su tejido flexible, que se amolda naturalmente a la figura sin crear tensiones.</p>
highlights
string<ul> <li><strong>Atrevido color rosa neón</strong> para un estilo único</li> <li><strong>Banda de silicona bajo el encaje</strong> para una sujeción óptima</li> <li><strong>Línea glamurosa en la espalda</strong> para un efecto sofisticado</li> <li><strong>Cómoda malla</strong> que abraza todas las curvas</li> <li><strong>Prácticos tirantes</strong> sin liguero</li> <li><strong>Disponible para todas las formas</strong></li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringMedias de rejilla rosa fluorescente con banda de silicona. Sujeción perfecta y estilo atrevido para todas las formas del cuerpo en Leg's Boudoir.
keywords
string
title
stringMedias de rejilla rosa fluorescente talla grande | Leg's Boudoir
seotitle
stringTallas grandes de rejilla rosa fluorescente
seouri
stringmedias-de-rejilla-autoadherentes-rosa-neon-talla-grande
specifications
string<ul> <li><strong>Material</strong>: Malla elástica de alta calidad</li> <li><strong>Color</strong>: Rosa fluorescente</li> <li><strong>Tipo</strong>: Autofijación con banda de silicona</li> <li><strong>Acabado</strong>: Glamour en la espalda</li> <li><strong>Tallas</strong>: Disponible en varias tallas</li> <li><strong>Sujeción</strong>: Banda de silicona bajo encaje</li> </ul>
stylingtips
string<p>El <strong>rosa neón</strong> de estas medias las convierte en el accesorio perfecto para crear looks <strong>modernos y extravagantes</strong>.</p> <p>Combínalas con prendas blancas o negras para resaltar su vibrante color, o apuesta por un look total color para una declaración de estilo atrevida.</p> <p>La <strong>glamurosa línea de la espalda</strong> queda especialmente realzada con tacones y faldas cortas o shorts.</p>
summary
string<p>Atrévete<strong>a ser atrevida con nuestras medias de rejilla rosa neón</strong>, diseñadas para realzar todo tipo de cuerpos con su <strong>banda de silicona bajo encaje</strong> y su <strong>glamurosa línea trasera.</strong></p> <p>Estas medias combinan <strong>una sujeción perfecta</strong> y un <strong>estilo exótico</strong> para un look que no pasará desapercibido.</p>
title
stringMedias de rejilla rosa fluorescente - Audacia y Glamour Talla grande
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Ces <strong>bas r&eacute;sille autofixants rose fluo</strong> incarnent l'audace et la f&eacute;minit&eacute; moderne.</p> <p>Leur&nbsp;<strong>couleur rose fluo vibrante</strong> apporte une touche d'originalit&eacute; &agrave; votre garde-robe intime, tandis que la <strong>r&eacute;sille d&eacute;licate</strong> cr&eacute;e un jeu de transparence particuli&egrave;rement s&eacute;duisant.</p> <p>Le <strong>syst&egrave;me autofixant avec bande de silicone</strong> plac&eacute;e discr&egrave;tement sous la dentelle assure un <strong>maintien parfait toute la journ&eacute;e</strong> sans comprimer ni marquer la peau.</p> <p>Cette technologie permet une&nbsp;<strong>libert&eacute; de mouvement totale</strong> tout en garantissant que vos bas restent parfaitement en place.</p> <p>La <strong>ligne glamour qui court sur l'arri&egrave;re de la jambe</strong> ajoute une dimension esth&eacute;tique raffin&eacute;e, cr&eacute;ant une <strong>silhouette &eacute;lanc&eacute;e</strong> et un effet visuel particuli&egrave;rement flatteur.</p> <p>Cette finition soign&eacute;e transforme un simple bas en v&eacute;ritable accessoire de mode.</p> <p>Con&ccedil;us pour s'adapter &agrave; <strong>toutes les morphologies</strong>, ces bas offrent un <strong>confort exceptionnel</strong> gr&acirc;ce &agrave; leur coupe &eacute;tudi&eacute;e et leur mati&egrave;re souple qui &eacute;pouse naturellement les formes sans cr&eacute;er de tensions.</p>
highlights
string<ul> <li><strong>Couleur rose fluo audacieuse</strong> pour un style unique</li> <li><strong>Bande de silicone sous dentelle</strong> pour un maintien optimal</li> <li><strong>Ligne glamour sur l'arri&egrave;re</strong> pour un effet sophistiqu&eacute;</li> <li><strong>R&eacute;sille confortable</strong> qui &eacute;pouse parfaitement les courbes</li> <li><strong>Autofixants pratiques</strong> sans porte-jarretelles</li> <li><strong>Disponibles pour toutes les morphologies</strong></li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringBas résille autofixants rose fluo grande taille avec bande silicone. Maintien parfait et style audacieux pour toutes les morphologies chez Leg's Boudoir.
keywords
string
title
stringBas Résille Rose Fluo Grande Taille | Leg's Boudoir
seotitle
stringBas Résille Autofixants Rose Fluo Grande Taille
seouri
stringbas-resille-autofixants-rose-fluo-grande-taille
specifications
string<ul> <li><strong>Mati&egrave;re</strong> : R&eacute;sille &eacute;lastique haute qualit&eacute;</li> <li><strong>Couleur</strong> : Rose fluo</li> <li><strong>Type</strong> : Autofixants avec bande silicone</li> <li><strong>Finition</strong> : Ligne glamour arri&egrave;re</li> <li><strong>Tailles</strong> : Disponibles en plusieurs tailles</li> <li><strong>Maintien</strong> : Bande de silicone sous dentelle</li> </ul>
stylingtips
string<p>Le <strong>rose fluo</strong> de ces bas en fait un accessoire statement parfait pour cr&eacute;er des looks <strong>d&eacute;cal&eacute;s et modernes</strong>.</p> <p>Associez-les &agrave; des pi&egrave;ces noires ou blanches pour faire ressortir leur couleur vibrante, ou osez le total look color&eacute; pour un style assum&eacute;.&nbsp;</p> <p>La&nbsp;<strong>ligne glamour arri&egrave;re</strong> est particuli&egrave;rement mise en valeur avec des chaussures &agrave; talons et des jupes courtes ou des shorts.</p>
summary
string<p><strong>Osez l'audace avec nos bas r&eacute;sille autofixants rose fluo</strong>, con&ccedil;us pour sublimer toutes les morphologies avec leur <strong>bande de silicone sous dentelle</strong> et leur <strong>ligne glamour arri&egrave;re</strong>.</p> <p>Ces bas allient&nbsp;<strong>maintien parfait</strong> et <strong>style exotique</strong> pour un look qui ne passe pas inaper&ccedil;u.</p>
title
stringBas Résille Autofixants Rose Fluo - Audace et Glamour
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Queste <strong>autoreggenti a rete rosa neon</strong> sono l'emblema di una femminilità audace e moderna.</p> <p>Il loro <strong>vibrante colore rosa neon</strong> aggiunge un tocco di originalità al vostro guardaroba intimo, mentre la <strong>delicata rete a rete</strong> crea un gioco di trasparenze particolarmente seducente.</p> <p>Il <strong>sistema di autofissaggio con una fascia in silicone</strong> posizionata discretamente sotto il pizzo assicura un <strong>sostegno perfetto per tutto il giorno</strong> senza comprimere o segnare la pelle.</p> <p>Questa tecnologia consente <strong>una totale libertà di movimento</strong>, assicurando al contempo che le calze rimangano perfettamente al loro posto.</p> <p>La <strong>linea glamour che corre lungo la parte posteriore della gamba</strong> aggiunge una dimensione estetica raffinata, creando una <strong>silhouette sottile</strong> e un effetto visivo particolarmente lusinghiero.</p> <p>Questa finitura meticolosa trasforma una semplice calza in un vero e proprio accessorio di moda.</p> <p>Progettate per adattarsi a <strong>tutte le forme del corpo</strong>, queste calze offrono un <strong>comfort eccezionale</strong> grazie al taglio studiato e al tessuto morbido, che si modella naturalmente alle forme senza creare tensioni.</p>
highlights
string<ul> <li><strong>Audace colore rosa neon</strong> per uno stile unico</li> <li><strong>Fascia in silicone sotto il pizzo</strong> per un sostegno ottimale</li> <li><strong>Linea glamour sulla schiena</strong> per un effetto sofisticato</li> <li><strong>La rete confortevole</strong> abbraccia ogni curva</li> <li><strong>Pratici lacci</strong> senza reggicalze</li> <li><strong>Disponibile per tutte le forme del corpo</strong></li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringAutoreggenti a rete rosa fluo con fascia in silicone. Sostegno perfetto e stile audace per tutte le forme del corpo da Leg's Boudoir.
keywords
string
title
stringCalze a rete rosa fluo taglia grande | Leg's Boudoir
seotitle
stringAutoreggenti a rete rosa fluorescente Taglia grande
seouri
stringcalze-a-rete-autoaderenti-rosa-neon-taglia-grande
specifications
string<ul> <li><strong>Materiale</strong>: rete elastica di alta qualità</li> <li><strong>Colore</strong>: rosa fluorescente</li> <li><strong>Tipo</strong>: Autofissante con fascia in silicone</li> <li><strong>Finitura</strong>: Linea posteriore glamour</li> <li><strong>Taglie</strong>: Disponibile in diverse taglie</li> <li><strong>Sostegno</strong>: Fascia in silicone sotto il pizzo</li> </ul>
stylingtips
string<p>Il <strong>rosa neon</strong> di queste calze le rende un accessorio perfetto per creare look <strong>moderni ed eccentrici</strong>.</p> <p>Abbinatele a capi bianchi o neri per far risaltare il loro colore vibrante, oppure optate per un look total color per una dichiarazione di stile audace.</p> <p>La <strong>linea posteriore glamour</strong> è particolarmente valorizzata da tacchi e gonne corte o shorts.</p>
summary
string<p><strong>Osate con le nostre calze autoreggenti a rete rosa neon</strong>, progettate per valorizzare ogni tipo di corpo grazie alla <strong>fascia in silicone sotto il pizzo</strong> e alla <strong>linea posteriore glamour.</strong></p> <p>Queste calze combinano un <strong>sostegno perfetto</strong> e uno <strong>stile esotico</strong> per un look che non passerà inosservato.</p>
title
stringCalze a rete rosa fluorescente - Audacia e glamour taglia grande
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Deze <strong>neonroze visnet hold-ups</strong> zijn het toppunt van gedurfde en moderne vrouwelijkheid.</p> <p>Hun <strong>levendige neonroze kleur</strong> voegt een vleugje originaliteit toe aan je intieme garderobe, terwijl het <strong>delicate visnet</strong> een bijzonder verleidelijk spel van transparantie cre&euml;ert.</p> <p>Het <strong>zelfbevestigende systeem met een siliconen band</strong> die discreet onder het kant is geplaatst, zorgt <strong>de hele dag</strong> voor <strong>perfecte ondersteuning</strong> zonder de huid samen te drukken of te beschadigen.</p> <p>Deze technologie zorgt voor <strong>totale bewegingsvrijheid</strong> terwijl je kousen perfect op hun plaats blijven zitten.</p> <p>De <strong>glamoureuze lijn die langs de achterkant van het been loopt</strong>, voegt een verfijnde esthetische dimensie toe en cre&euml;ert een <strong>slank silhouet</strong> en een bijzonder flatterend visueel effect.</p> <p>Deze zorgvuldige afwerking verandert een eenvoudige kous in een echt modeaccessoire.</p> <p>Deze kousen zijn geschikt voor <strong>alle lichaamsvormen</strong> en bieden <strong>uitzonderlijk comfort</strong> dankzij de bestudeerde snit en de soepele stof, die zich op natuurlijke wijze naar de vorm vormt zonder spanning te cre&euml;ren.</p>
highlights
string<ul> <li><strong>Gewaagde neonroze kleur</strong> voor een unieke stijl</li> <li><strong>Siliconen band onder kant</strong> voor optimale ondersteuning</li> <li><strong>Glamoureuze lijn op de rug</strong> voor een geraffineerd effect</li> <li><strong>Comfortabel visnet</strong> omhelst elke ronding</li> <li><strong>Praktische zelfbinder</strong> zonder jarretelgordel</li> <li><strong>Beschikbaar voor alle lichaamsvormen</strong></li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringFluorescerend roze visnet hold-ups met siliconen band. Perfecte ondersteuning en gedurfde stijl voor alle lichaamsvormen bij Leg's Boudoir.
keywords
string
title
stringFluorescerend Roze Visnet Kousen Grote Maat | Leg's Boudoir
seotitle
stringFluorescerend roze visnet hold ups Grote maat
seouri
stringneonroze-zelfsluitende-visnet-kousen-grote-maat
specifications
string<ul> <li><strong>Materiaal</strong>: Hoogwaardig elastisch gaas</li> <li><strong>Kleur</strong>: Fluorescerend roze</li> <li><strong>Type</strong>: Zelfbevestigend met siliconenband</li> <li><strong>Afwerking</strong>: Glamour ruglijn</li> <li><strong>Maten</strong>: Verkrijgbaar in verschillende maten</li> <li><strong>Ondersteuning</strong>: Siliconenband onder kant</li> </ul>
stylingtips
string<p>Het <strong>neonroze</strong> van deze kousen maakt ze het perfecte statement accessoire voor het cre&euml;ren van <strong>eigenzinnige, moderne</strong> looks.</p> <p>Combineer ze met zwarte of witte stukken om de levendige kleur naar voren te laten komen, of ga voor een totale kleurenlook voor een gedurfd stijlstatement.</p> <p>De <strong>glamoureuze ruglijn</strong> komt vooral tot zijn recht bij hakken en korte rokjes of shorts.</p>
summary
string<p><strong>Durf te zijn met onze neonroze visnet hold-ups</strong>, ontworpen om elk lichaamstype te verbeteren met hun <strong>siliconen band onder kant</strong> en <strong>glamoureuze ruglijn.</strong></p> <p>Deze kousen combineren <strong>perfecte ondersteuning</strong> en <strong>exotische stijl</strong> voor een look die niet onopgemerkt zal blijven.</p>
title
stringFluorescerend roze visnet kousen - Audacity and Glamour grote maat
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Estas <strong>cuecas em rede rosa néon</strong> são o epítome da feminilidade ousada e moderna.</p> <p>A sua <strong>cor rosa néon vibrante</strong> acrescenta um toque de originalidade ao seu guarda-roupa íntimo, enquanto a <strong>delicada rede de pesca</strong> cria um jogo de transparência particularmente sedutor.</p> <p>O <strong>sistema de auto-fixação com uma banda de silicone</strong> discretamente colocada sob a renda garante <strong>um suporte perfeito durante todo o dia</strong> sem comprimir nem marcar a pele.</p> <p>Esta tecnologia permite <strong>uma total liberdade de movimentos</strong>, garantindo ao mesmo tempo que as meias se mantêm perfeitamente no sítio.</p> <p>A <strong>linha glamorosa que percorre a parte de trás da perna</strong> acrescenta uma dimensão estética refinada, criando uma <strong>silhueta esbelta</strong> e um efeito visual particularmente lisonjeiro.</p> <p>Este acabamento meticuloso transforma uma simples meia num verdadeiro acessório de moda.</p> <p>Concebidas para se adaptarem a <strong>todas as formas do corpo</strong>, estas meias oferecem <strong>um conforto excecional</strong> graças ao seu corte estudado e ao tecido flexível, que se molda naturalmente à forma sem criar tensão.</p>
highlights
string<ul> <li><strong>Cor rosa néon arrojada</strong> para um estilo único</li> <li><strong>Faixa de silicone sob a renda</strong> para um suporte ótimo</li> <li><strong>Linha glamorosa nas costas</strong> para um efeito sofisticado</li> <li><strong>Rede de peixe confortável</strong> que abraça todas as curvas</li> <li><strong>Prático fecho</strong> sem cinto de ligas</li> <li><strong>Disponível para todas as formas do corpo</strong></li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringSutiãs de rede rosa fluorescente com banda de silicone. Suporte perfeito e estilo arrojado para todas as formas do corpo na Leg's Boudoir.
keywords
string
title
stringMeias de rede cor-de-rosa fluorescente Grandes | Leg's Boudoir
seotitle
stringCalças de rede cor-de-rosa fluorescente Grande
seouri
stringneon-pink-self-fastening-fishnet-stockings-large
specifications
string<ul> <li><strong>Material</strong>: Malha elástica de alta qualidade</li> <li><strong>Cor</strong>: Rosa fluorescente</li> <li><strong>Tipo</strong>: Auto-fixação com banda de silicone</li> <li><strong>Acabamento</strong>: Costas glamourosas</li> <li><strong>Tamanhos</strong>: Disponível em vários tamanhos</li> <li><strong>Suporte</strong>: Banda de silicone sob a renda</li> </ul>
stylingtips
string<p>O <strong>rosa néon</strong> destas meias torna-as no acessório de afirmação perfeito para criar looks <strong>modernos e peculiares</strong>.</p> <p>Combine-as com peças pretas ou brancas para realçar a sua cor vibrante, ou opte por um look totalmente colorido para uma afirmação de estilo arrojada.</p> <p>A <strong>linha das costas glamorosa</strong> é particularmente realçada com saltos altos e saias curtas ou calções.</p>
summary
string<p><strong>Atreva-se a ser ousada com as nossas meias de ligas de rede cor-de-rosa néon</strong>, concebidas para realçar todos os tipos de corpo com a sua <strong>banda de silicone sob a renda</strong> e a <strong>glamorosa linha traseira.</strong></p> <p>Estas meias combinam <strong>um suporte perfeito</strong> e <strong>um estilo exótico</strong> para um visual que não passará despercebido.</p>
title
stringMeias de rede cor-de-rosa fluorescente - Audacity and Glamour Tamanho grande
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-neonpink
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-roz-neon
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-fluo-rose
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-rosa-neon
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-rose-fluo
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-rosa-neon
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-neonroze
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-rosa-neon
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
smboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-neonpink
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-roz-neon
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-fluo-rose
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-rosa-neon
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-rose-fluo
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-rosa-neon
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-neonroze
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-rosa-neon
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
name
stringDG0001NXHPKOSQ
netweight
string
nextshipment
stringtomorrow
ordered
number3
orderidx
number0
origin
string
originalsize
string
packaging
number0
productshipment
stringauto
productuid
stringA77D0E2F-3E82-4132-8AE38F405B8C4286
promountil
string
rating
stringnone
recorduid
stringA77D0E2F-3E82-4132-8AE38F405B8C4286
reference
stringSLST3195
related
string
reserved
number0
returned
number0
returnsallowed
number1
section
stringlingerie
shipment
string3to5days
showbrand
number0
sizeinfos
Query
Template: /system/api/product/sizes.cfc:20
Execution Time: 1.28 ms
Record Count: 2
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,'1816,1112') > 0
and product_variations.productuid = 'A77D0E2F-3E82-4132-8AE38F405B8C4286'
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
118162-4intlsizefluorose24-19999990wplusstockingOne2-434-404-108-1236-4236-4234-4040-4636-4234-40
211125-6intlsizefluorose56-19999990wplusstockingQueen5-642-4812-1816-2244-5044-5042-4848-5244-5042-48
sizeranges
stringplus
sizes
string1816,1112
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: 3.37 ms
Record Count: 2
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 = 'A77D0E2F-3E82-4132-8AE38F405B8C4286'
and product_variations.isactive = 1
and product_sizes.id_size = 1816
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 = 'A77D0E2F-3E82-4132-8AE38F405B8C4286'
and product_variations.isactive = 1
and product_sizes.id_size = 1112
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
1A77D0E2F-3E82-4132-8AE38F405B8C428606287B2E-A612-4460-A2FA01962B98B4591816fluorose#FA22A0One2-434-404-108-1236-4236-4234-4040-4636-4234-40wstocking2-4intlsize14.95830STOCK01000-10000-10all
2A77D0E2F-3E82-4132-8AE38F405B8C428639DF4CFC-6EF1-4978-A56B6271A9E2425D1112fluorose#FA22A0Queen5-642-4812-1816-2244-5044-5042-4848-5244-5042-48wstocking5-6intlsize14.95830STOCK01000-103000001NX888368000043-10all
subcategory
stringstocking
supplier
number-1
supplierreference
stringDG0001NXHPK
tags
string
themes
stringlollipop,readyforvalentine
totalvariations
number2
type
stringdefault
unitprice
number14.9583
usageinstructions
stringholdups
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 4.03 ms
Record Count: 2
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 = 'A77D0E2F-3E82-4132-8AE38F405B8C4286' 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 = 'A77D0E2F-3E82-4132-8AE38F405B8C4286' 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 = 'A77D0E2F-3E82-4132-8AE38F405B8C4286' 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 = 'A77D0E2F-3E82-4132-8AE38F405B8C4286' 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 = 'A77D0E2F-3E82-4132-8AE38F405B8C4286' 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 = 'A77D0E2F-3E82-4132-8AE38F405B8C4286' 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 = 'A77D0E2F-3E82-4132-8AE38F405B8C4286'
and product_variations.isactive = 1
and product_sizes.id_size = 1816
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 = 'A77D0E2F-3E82-4132-8AE38F405B8C4286' 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 = 'A77D0E2F-3E82-4132-8AE38F405B8C4286' 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 = 'A77D0E2F-3E82-4132-8AE38F405B8C4286' 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 = 'A77D0E2F-3E82-4132-8AE38F405B8C4286' 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 = 'A77D0E2F-3E82-4132-8AE38F405B8C4286' 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 = 'A77D0E2F-3E82-4132-8AE38F405B8C4286' 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 = 'A77D0E2F-3E82-4132-8AE38F405B8C4286'
and product_variations.isactive = 1
and product_sizes.id_size = 1112
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
106287B2E-A612-4460-A2FA01962B98B4591816fluorose#FA22A0One2-434-404-108-1236-4236-4234-4040-4636-4234-40wstocking2-4intlsize14.95830STOCK01000-10000-10-10-10014.9583all
239DF4CFC-6EF1-4978-A56B6271A9E2425D1112fluorose#FA22A0Queen5-642-4812-1816-2244-5044-5042-4848-5244-5042-48wstocking5-6intlsize14.95830STOCK01000-103000001NX888368000043-10-10-10014.9583all
vatrate
number20
warehouse
number0