Ver tamanhos
Meias cor-de-rosa fluorescente
Clique duplo para aumentar
SKU: SLST6393
Meias cor-de-rosa fluorescente
Stock:

Atreva-se a ser colorido e surpreenda os seus amigos e familiares com estas meias cor-de-rosa brilhantes.

Tamanho:

Não sabe qual o tamanho a escolher? Consultar o nosso guia de tamanhos

Cor:
Quantidade:
16.95 €
Ajuda e aconselhamento
por chat, facebook ou correio eletrónico
Devoluções gratuitas
no prazo de 15 dias *

Pegas cor-de-rosa fluorescente, tamanho grande

Descrição do produto

Meias em rosa fluorescente.

Cor intensa, banda de silicone por baixo da renda para uma boa sustentação.

Pormenores técnicos

Tamanhos disponíveis

Disponível de 2-4 a 5-6

Cor disponível

Rosa néon

Composição

Nylon 85 %
Elastano 15 %

Instruções de cuidados

  • Recomenda-se lavagem à mão com sabão suave ou na máquina a 30°C máximo num saco de proteção
  • Evite amaciadores que enfraquecem a elasticidade das fibras
  • Secar ao ar livre na horizontal, nunca na máquina de secar
  • Manuseie com mãos limpas e sem joias para evitar rasgões
  • Para tamanhos standard e plus (até 64), vista delicadamente enrolando a meia/collant e evitando puxar
  • Guarde separadamente de peças com fechos ou ganchos que as possam danificar
  • Para modelos de fantasia, rede ou com padrões, lave do avesso para preservar os detalhes

Dicas de utilização

  • Certifique-se de que a sua pele está limpa, seca e sem creme/óleo antes de as calçar
  • Calce suavemente enrolando a meia desde o pé até à coxa
  • Posicione a banda adesiva logo acima do joelho, na parte mais fina da coxa
  • Pressione ligeiramente a banda de silicone para garantir a aderência à pele
  • Para tamanhos standard a 64, evite puxar excessivamente o tecido para preservar a elasticidade
  • Se as meias escorregarem, verifique se a banda de silicone está limpa e sem resíduos
  • Para uma fixação ideal, evite aplicar loções ou cremes nas coxas antes de as usar
To Top
Artigos
Total de itens
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.634 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 = '48D69B15-6FF6-4EA2-B5241E6595879204'
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
string15
free
string
leather
string
lycra
string
metal
string
nylon
string85
polyamide
string
polyester
string
polyurethane
string
silk
string
spandex
string
viscose
string
datecreated
Date Time (Europe/Paris)
{ts '2023-10-17 18:49:34'}
defect
number0
dimensions
Struct
Entries: 14
acrylicbones
string
backsideheight
string
diameter
string
flatsteelbones
string
frontsideheight
string
fullheight
string
length
string
modestysize
string
panels
string
sides
string
spiralsteelbones
string
totallength
string
unit
stringcm
wiresize
string
display
stringall
displayfrom
string
displayto
string
grossweight
string
hasbrandinfos
booleanfalse
hascareinstructions
booleantrue
hascolorinfos
booleantrue
hascompositions
booleantrue
hasdescription
booleantrue
hasdimensions
booleanfalse
hasmaterials
booleanfalse
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.125
itempromo
string
key
stringdg0005nxpnk
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-10-22 18:45:34'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.6 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','pt')
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('48d69b15-6ff6-4ea2-b5241e6595879204',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.28 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','pt')
and product_categories.language in ('all','pt')
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 <> 'SLST6393'
group by products.reference
order by products.ishot desc, products.isnew desc, orderidx asc, products.lastupdated desc
productuidreferencetypekeylanguagenamelinkuidcolorsvatratemetadatasdimensionsmediadatastagsthemesisdivasizetotalvariationsvariationlistinpromohaspromoitempromoitempriceunitpricepricespromountilisfixedpriceishotisneworderidxavailablestockinstockvariationsbrandbrandnameshowbranddisplaysizetypeintlsizesizessizerangecategorymediadatascategorysizerangesectioncategorysubcategory
linkuid
string
materials
string
mediadatas
Struct
alt
Struct
height
string865
isprivate
string0
rating
stringall
src
string/photobank/products/ddru/slst6393/bas_autofixants_rose_fluo_grande_taille_dos1.jpg
type
stringimg
width
string598
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string2224
isprivate
string0
rating
stringall
src
string/photobank/products/ddru/slst6393/bas_autofixants_rose_fluo_grande_taille.jpg
type
stringimg
width
string1539
variations
Struct
colors
Struct
fluorose
Struct
height
string2224
isprivate
string0
rating
stringall
src
string/photobank/products/ddru/slst6393/bas_autofixants_rose_fluo_grande_taille.jpg
type
stringimg
width
string1539
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
stringUnfixierte Strümpfe in Neonpink.<br /><br />Intensive Farbe, Silikonband unter der Spitze für einen guten Halt.
guid
stringhttps://dev.divasboudoir.com/de/selbstfixierende-strumpfe-grosse-grosse-neonpink-neonpink/slst6393.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringBekennen Sie Farbe mit unseren Strümpfen in Übergröße in Neonpink. Entdecken Sie unsere große Auswahl an Strümpfen in Übergröße für jeden Anlass. Schneller und diskreter Versand
keywords
string
title
stringSelbstfixierende Strümpfe in großen Größen in Neonpink. Schneller Versand
seotitle
stringSelbstfixierende Strümpfe große Größe neonpink
seouri
stringselbstfixierende-strumpfe-grosse-grosse-neonpink-neonpink
specifications
string
stylingtips
string
summary
stringWagen Sie es, Farbe zu bekennen und überraschen Sie Ihre Mitmenschen mit diesen Strümpfen in strahlendem Pink.
title
stringUnfixierte Strümpfe in Neonpink
usageinstructions
string
el
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringΦθορίζοντα ροζ hold-ups.<br /><br />Έντονο χρώμα, ζώνη σιλικόνης κάτω από τη δαντέλα για καλή στήριξη.
guid
stringhttps://dev.divasboudoir.com/el/fthorizonta-roz-hold-ups,-megalo-megethos-roz-neon/slst6393.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringΤολμήστε να γίνετε πολύχρωμοι με τις φθορίζουσες ροζ κάλτσες plus size. Ελάτε να ανακαλύψετε τη μεγάλη γκάμα μας σε κάλτσες plus size για όλες τις περιστάσεις. Γρήγορη, διακριτική παράδοση
keywords
string
title
stringΦθορίζοντα ροζ hold ups, μεγάλο μέγεθος
seotitle
stringΦθορίζοντα ροζ hold ups, μεγάλο μέγεθος
seouri
stringfthorizonta-roz-hold-ups,-megalo-megethos-roz-neon
specifications
string
stylingtips
string
summary
stringΤολμήστε να είστε πολύχρωμοι και εκπλήξτε τους φίλους και την οικογένειά σας με αυτές τις φωτεινές ροζ κάλτσες.
title
stringΦθορίζοντα ροζ hold-ups
usageinstructions
string
en
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringFluorescent pink hold-ups.<br /><br />Intense color, silicone band under the lace for good support.
guid
stringhttps://dev.divasboudoir.com/en/fluorescent-pink-hold-ups,-large-size-fluo-rose/slst6393.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringDare to be colorful with our fluorescent pink plus size stockings. Come and discover our wide choice of plus size stockings for all occasions. Fast, discreet shipping
keywords
string
title
stringFluorescent pink hold-ups, large size. Fast shipping
seotitle
stringFluorescent pink hold-ups, large size
seouri
stringfluorescent-pink-hold-ups,-large-size-fluo-rose
specifications
string
stylingtips
string
summary
stringDare to be colorful and surprise your friends and family with these bright pink stockings.
title
stringFluorescent pink pantyhose
usageinstructions
string
es
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringMedias de color rosa fluorescente.<br /><br />Color intenso, banda de silicona bajo el encaje para una buena sujeción.
guid
stringhttps://dev.divasboudoir.com/es/medias-rosa-fluorescente,-talla-grande-rosa-neon/slst6393.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringAtrévete con el colorido de nuestras medias de talla grande rosa fluorescente. Ven y descubre nuestra amplia gama de medias de talla grande para todas las ocasiones. Entrega rápida y discreta
keywords
string
title
stringMedias rosa fluorescente, talla grande. Envío rápido
seotitle
stringMedias rosa fluorescente, talla grande
seouri
stringmedias-rosa-fluorescente,-talla-grande-rosa-neon
specifications
string
stylingtips
string
summary
stringAtrévete con los colores y sorprende a tus amigos y familiares con estas medias de color rosa brillante.
title
stringMedias rosa fluorescente
usageinstructions
string
fr
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>Bas aufofixants rose fluo.<br><br>Couleur intense, bande de silicone sous la dentelle pour un bon maintien.</p>
guid
stringhttps://dev.divasboudoir.com/fr/bas-autofixants-grande-taille-rose-fluo-rose-fluo/slst6393.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringOsez la couleur avec nos bas grande taille rose fluo. Venez découvrir notre large choix de bas grande taille pour toutes les occasions. Envoi rapide et discret
keywords
string
title
stringBas autofixants grande taille rose fluo. Envoi rapide
seotitle
stringBas autofixants grande taille rose fluo
seouri
stringbas-autofixants-grande-taille-rose-fluo-rose-fluo
specifications
string
stylingtips
string
summary
string<p>Osez la couleur et surprenez votre entourage avec ces bas d'un rose &eacute;clantant.</p>
title
stringBas aufofixants rose fluo
usageinstructions
string
it
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringAutoreggenti rosa fluorescenti.<br /><br />Colore intenso, fascia in silicone sotto il pizzo per un buon sostegno.
guid
stringhttps://dev.divasboudoir.com/it/autoreggenti-rosa-fluorescenti,-taglia-grande-rosa-neon/slst6393.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringOsate essere colorati con le nostre calze rosa fluo taglia grande. Venite a scoprire la nostra ampia gamma di calze taglia grande per tutte le occasioni. Consegna rapida e discreta
keywords
string
title
stringAutoreggenti rosa fluorescenti, taglia grande
seotitle
stringAutoreggenti rosa fluorescenti, taglia grande
seouri
stringautoreggenti-rosa-fluorescenti,-taglia-grande-rosa-neon
specifications
string
stylingtips
string
summary
stringOsate essere colorati e sorprendete i vostri amici e familiari con queste calze rosa acceso.
title
stringAutoreggenti rosa fluorescenti
usageinstructions
string
nl
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringFluorescerend roze hold-ups.<br /><br />Intense kleur, siliconen band onder de veter voor goede ondersteuning.
guid
stringhttps://dev.divasboudoir.com/nl/fluorescerend-roze-hold-ups,-groote-maat-neonroze/slst6393.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringDurf kleurrijk te zijn met onze fluorescerend roze kousen voor groote maten. Kom en ontdek ons brede assortiment groote maten kousen voor alle gelegenheden. Snelle, discrete levering
keywords
string
title
stringFluorescerend roze hold-ups, groote maat
seotitle
stringFluorescerend roze hold-ups, groote maat
seouri
stringfluorescerend-roze-hold-ups,-groote-maat-neonroze
specifications
string
stylingtips
string
summary
stringDurf kleurrijk te zijn en verras je vrienden en familie met deze felroze kousen.
title
stringFluorescerend roze hold-ups
usageinstructions
string
pt
Struct
Entries: 15
abstract
string
careinstructions
string
description
stringMeias em rosa fluorescente.<br /><br />Cor intensa, banda de silicone por baixo da renda para uma boa sustentação.
guid
stringhttps://dev.divasboudoir.com/pt/pegas-cor-de-rosa-fluorescente,-tamanho-grande-rosa-neon/slst6393.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringAtreva-se a ser colorida com as nossas meias de tamanho grande cor-de-rosa fluorescente. Venha descobrir a nossa vasta gama de meias plus size para todas as ocasiões. Entrega rápida e discreta
keywords
string
title
stringPegas cor-de-rosa fluorescente, tamanho grande
seotitle
stringPegas cor-de-rosa fluorescente, tamanho grande
seouri
stringpegas-cor-de-rosa-fluorescente,-tamanho-grande-rosa-neon
specifications
string
stylingtips
string
summary
stringAtreva-se a ser colorido e surpreenda os seus amigos e familiares com estas meias cor-de-rosa brilhantes.
title
stringMeias cor-de-rosa fluorescente
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 Strümpfe in Neonpink</strong> verkörpern Kühnheit und moderne Weiblichkeit. Ihre <strong>strahlende rosa Farbe</strong> verleiht Ihrer Garderobe einen auffallend originellen Touch, während das <strong>leicht blickdichte Finish</strong> eine natürliche Bedeckung bietet, die die Haut sublimiert.</p> <p>Die <strong>Zusammensetzung aus 85% Nylon und 15% Elasthan</strong> garantiert eine <strong>perfekte Dehnbarkeit</strong>, die sich harmonisch an die Kurven jeder Körperform anpasst. Diese Kombination edler Materialien sorgt für einen <strong>außergewöhnlichen Tragekomfort</strong> und eine optimale Widerstandsfähigkeit bei langem Tragen.</p> <p>Das <strong>unter der Spitze angebrachte Silikonband</strong> sorgt <strong>den ganzen Tag über</strong> für <strong>perfekten Halt</strong>, ohne zu drücken oder die Haut zu markieren. Diese Technologie ermöglicht <strong>absolute Bewegungsfreiheit</strong> und stellt gleichzeitig sicher, dass Ihre Strümpfe perfekt an ihrem Platz bleiben.</p> <p>Die <strong>hübschen, passenden rosafarbenen Strumpfbänder</strong> sind das Detail, das den Unterschied ausmacht. Diese sorgfältige Verarbeitung verwandelt einen einfachen Strumpf in ein echtes Modeaccessoire, das eine <strong>schlanke Silhouette</strong> und eine <strong>prächtige Rund</strong> ung schafft, die die Schönheit jeder Figur auf natürliche Weise hervorhebt.</p>
highlights
string<ul> <li><strong>Leuchtendes Neonpink</strong> für einen gewagten Stil</li> <li><strong>Hochwertiges, dünnes Nylon</strong> für ein seidiges Gefühl</li> <li><strong>Silikonband unter der Spitze</strong> für optimalen Halt</li> <li><strong>Leicht blickdicht</strong> für einen eleganten, natürlichen Effekt</li> <li><strong>Passende rosafarbene Strumpfbänder</strong> für ein raffiniertes Finish</li> <li><strong>Perfekte Kur</strong> venform, die die Silhouette aufwertet</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringSelbstfixierende Strümpfe in Neonpink in großen Größen mit Silikonband und passenden Strumpfhaltern. Knallige Farbe und üppige Kurven bei Leg's Boudoir.
keywords
string
title
stringSelbstfixierende Strümpfe Fluo Pink Große Größe | Leg's Boudoir
seotitle
stringSelbstfixierende Strümpfe Fluo-Pink Große Größe
seouri
stringselbstfixierende-strumpfe-in-neonpink,-grosse-grosse
specifications
string<ul> <li><strong>Material:</strong> 85% Nylon, 15% Elasthan</li> <li><strong>Farbe:</strong> Neonpink</li> <li><strong>Opazität:</strong> Leicht undurchsichtig</li> <li><strong>Art :</strong> Selbstfixierend mit Silikonband</li> <li>Veredelung<strong>:</strong> Passende rosa Strumpfbänder</li> <li><strong>Größen:</strong> Standard und mehrere Größen erhältlich</li> </ul>
stylingtips
string<p>Das <strong>leuchtende Neonpink</strong> dieser Strümpfe macht sie zu perfekten Statement-Pieces, mit denen Sie überraschen und gewagte Looks kreieren können. Kombinieren Sie sie mit schwarzen oder weißen Kleidungsstücken, um ihre leuchtende Farbe zu betonen, oder wagen Sie einen farbenfrohen Total-Look für einen selbstbewussten Stil. Die <strong>passenden Strumpfbänder</strong> sorgen für einen femininen Touch, der sich perfekt mit ausgefallenen oder raffinierten Outfits kombinieren lässt.</p> <p>Vervollständigen Sie Ihren Look mit unseren <a href="https://www.legsboudoir.com/de/bodystocking-und-catsuits/">Bodystockings</a> und entdecken Sie unsere Auswahl an <a href="https://www.legsboudoir.com/de/bodystockings-grosse-grossen/">Bodystockings in großen Größen,</a> um perfekt aufeinander abgestimmte Outfits zu kreieren.</p>
summary
string<p>Bekennen Sie<strong>Farbe mit unseren selbstfixierenden Strümpfen in Neonpink</strong>, die Sie mit ihrer <strong>leuchtenden Farbe</strong> überraschen werden.</p> <p>Diese feinen Nylonstrümpfe bieten eine <strong>prächtige Form</strong> und <strong>perfekten Halt</strong> dank des Silikonbandes unter der Spitze.</p>
title
stringSelbstfixierende Strümpfe in Neonpink - Intensive Farbe und üppige Kurven
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Αυτά τα <strong>neon ροζ hold-ups</strong> είναι η επιτομή της τολμηρής, μοντέρνας θηλυκότητας. Το <strong>έντονο ροζ χρώμα</strong> τους προσθέτει μια εντυπωσιακή πινελιά πρωτοτυπίας στην γκαρνταρόμπα σας, ενώ το <strong>ελαφρώς αδιαφανές φινίρισμα</strong> προσφέρει φυσική κάλυψη που αναδεικνύει το δέρμα.</p> <p>Η <strong>σύνθεση από 85% νάιλον και 15% ελαστάν</strong> εγγυάται <strong>τέλειο τέντωμα</strong> που προσαρμόζεται αρμονικά στις καμπύλες κάθε σωματότυπου. Αυτός ο συνδυασμός ευγενών υλικών παρέχει <strong>εξαιρετική άνεση</strong> και βέλτιστη αντοχή για παρατεταμένη χρήση.</p> <p>Η <strong>ζώνη σιλικόνης κάτω από τη δαντέλα</strong> εξασφαλίζει <strong>τέλεια στήριξη όλη την ημέρα</strong> χωρίς να συμπιέζει ή να σημαδεύει το δέρμα. Αυτή η τεχνολογία επιτρέπει την <strong>απόλυτη ελευθερία κινήσεων</strong>, ενώ παράλληλα διασφαλίζει ότι οι κάλτσες σας παραμένουν τέλεια στη θέση τους.</p> <p>Οι <strong>όμορφες ταιριαστές ροζ καλτσοδέτες</strong> είναι η λεπτομέρεια που κάνει όλη τη διαφορά. Αυτό το σχολαστικό φινίρισμα μετατρέπει μια απλή κάλτσα σε πραγματικό αξεσουάρ μόδας, δημιουργώντας μια <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Φθορίζον ροζ καλσόν μεγάλο | Μπουντουάρ του ποδιού
seotitle
stringΦθορίζον ροζ hold ups Large
seouri
stringfthorizon-roz-hold-ups-megalo-megethos
specifications
string<ul> <li><strong>Υλικό:</strong> 85% νάιλον, 15% ελαστάν</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> χρώμα αυτών των καλτσών τις καθιστά τα τέλεια statement κομμάτια για να εκπλήξετε και να δημιουργήσετε τολμηρές εμφανίσεις. Συνδυάστε τες με μαύρα ή λευκά κομμάτια για να αναδείξετε το έντονο χρώμα τους ή επιλέξτε μια εντελώς χρωματική εμφάνιση για μια τολμηρή δήλωση στυλ. <strong>Οι ασορτί καλτσοδέτες</strong> προσθέτουν μια θηλυκή πινελιά που ταιριάζει απόλυτα με εκκεντρικά ή εκλεπτυσμένα σύνολα.</p> <p>Ολοκληρώστε την εμφάνισή σας με τις <a href="https://www.legsboudoir.com/el/bodystocking-kai-catsuits/">κορδόνια</a> μας και ανακαλύψτε την επιλογή μας σε <a href="https://www.legsboudoir.com/el/syn-megethos-bodystockings/">κορδόνια plus-size</a> για να δημιουργήσετε τέλεια συντονισμένα σύνολα.</p>
summary
string<p><strong>Τολμήστε να γίνετε πολύχρωμοι με τα neon ροζ hold-ups μας</strong>, σχεδιασμένα για να εκπλήσσουν τους πάντες γύρω σας με την <strong>έντονη απόχρωσή</strong> τους.</p> <p>Αυτές οι λεπτές νάιλον κάλτσες προσφέρουν μια <strong>πλούσια καμπύλη</strong> και <strong>τέλεια στήριξη</strong> χάρη στη ζώνη σιλικόνης κάτω από το κορδόνι τους.</p>
title
stringΦθορίζον ροζ hold ups - Έντονο χρώμα και πλούσια καμπύλη
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>These <strong>neon pink hold-ups</strong> are the epitome of bold, modern femininity. Their <strong>bright pink color</strong> adds a striking touch of originality to your wardrobe, while the <strong>slightly opaque finish</strong> offers natural coverage that sublimates the skin.</p> <p>The <strong>85% nylon and 15% elastane composition</strong> guarantees <strong>perfect stretch</strong> that adapts harmoniously to the curves of every morphology. This alliance of noble materials provides <strong>exceptional comfort</strong> and optimum resistance for prolonged wear.</p> <p>The <strong>silicone band under the lace</strong> ensures <strong>perfect support all day long</strong>, without compressing or marking the skin. This technology allows <strong>total freedom of movement</strong> while ensuring that your stockings stay perfectly in place.</p> <p><strong>Matching pink garters</strong> are the detail that makes all the difference. This meticulous finish transforms a simple stocking into a true fashion accessory, creating a <strong>slender silhouette</strong> and a <strong>sumptuous curve</strong> that naturally enhances the beauty of every figure.</p>
highlights
string<ul> <li><strong>Bright neon pink</strong> for bold style</li> <li><strong>High-quality fine nylon</strong> for a silky feel</li> <li><strong>Silicone band under lace</strong> for optimal support</li> <li><strong>Slightly opaque</strong> for a natural, elegant effect</li> <li><strong>Matching pink garters</strong> for a refined finish</li> <li><strong>Perfect curve</strong> to enhance the silhouette</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringFluorescent pink plus size hold-ups with silicone band and matching garters. Vibrant color and sumptuous curves at Leg's Boudoir.
keywords
string
title
stringFluorescent Pink Hosiery Plus Size | Leg's Boudoir
seotitle
stringFluorescent Pink Hosiery Plus Size
seouri
stringfluorescent-pink-hold-ups-plus-size
specifications
string<ul> <li><strong>Material:</strong> 85% Nylon, 15% Elastane</li> <li><strong>Color:</strong> Fluorescent pink</li> <li><strong>Opacity:</strong> Slightly opaque</li> <li><strong>Type :</strong> Garters with silicone band</li> <li><strong>Finish:</strong> Matching pink garters</li> <li><strong>Sizes</strong>: Standard and several sizes available</li> </ul>
stylingtips
string<p>The <strong>bright fluorescent pink</strong> of these stockings makes them the perfect statement pieces to surprise and create bold looks. Pair them with black or white pieces to bring out their vibrant color, or dare the colorful total look for an assertive style. <strong>Matching garters</strong> add a feminine touch that goes perfectly with offbeat or sophisticated outfits.</p> <p>Complete your look with our <a href="https://www.legsboudoir.com/en/bodystocking-and-catsuits/">bodystockings</a> and discover our selection of <a href="https://www.legsboudoir.com/en/plus-size-bodystockings/">plus size bodystockings</a> to create perfectly coordinated outfits.</p>
summary
string<p><strong>Dare to be colorful with our neon pink hold-ups</strong>, designed to surprise those around you with their <strong>dazzling hue</strong>.</p> <p>These fine nylon stockings offer <strong>sumptuous curves</strong> and <strong>perfect support</strong> thanks to their silicone band under lace.</p>
title
stringFluorescent pink hold ups - Intense color and sumptuous curve
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><strong>Estos medias rosa neón</strong> son el epítome de la feminidad atrevida y moderna. Su <strong>brillante color rosa</strong> añade un llamativo toque de originalidad a tu vestuario, mientras que el <strong>acabado ligeramente opaco</strong> ofrece una cobertura natural que realza la piel.</p> <p>La <strong>composición de 85% de nailon y 15% de elastano</strong> garantiza <strong>una elasticidad perfecta</strong> que se adapta armoniosamente a las curvas de cada tipo de cuerpo. Esta combinación de materiales nobles proporciona <strong>un confort excepcional</strong> y una resistencia óptima para un uso prolongado.</p> <p>La <strong>banda de silicona situada bajo el encaje</strong> garantiza <strong>una sujeción perfecta durante todo el día</strong> sin comprimir ni marcar la piel. 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>Los <strong>bonitos ligueros rosas a juego</strong> son el detalle que marca la diferencia. Este minucioso acabado transforma una simple media en un verdadero accesorio de moda, creando una <strong>silueta esbelta</strong> y una <strong>suntuosa curva</strong> que realza naturalmente la belleza de cada figura.</p>
highlights
string<ul> <li><strong>Brillante rosa neón</strong> para un estilo atrevido</li> <li><strong>Nylon fino de alta calidad</strong> para un tacto sedoso</li> <li><strong>Banda de silicona bajo el encaje</strong> para una sujeción óptima</li> <li><strong>Ligeramente opaco</strong> para un elegante efecto natural</li> <li><strong>Liguero rosa a juego</strong> para un acabado refinado</li> <li><strong>Forma perfecta</strong> para realzar la silueta</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringMedias rosa fluorescente con banda de silicona y ligueros a juego. Color vibrante y curvas suntuosas en Leg's Boudoir.
keywords
string
title
stringMedias rosa fluorescente talla grande | Leg's Boudoir
seotitle
stringMedias rosa fluorescente Talla grande
seouri
stringmedias-rosa-fluorescente-talla-grande
specifications
string<ul> <li><strong>Material:</strong> 85% nailon, 15% elastán</li> <li><strong>Color:</strong> rosa fluorescente</li> <li><strong>Opacidad</strong>: Ligeramente opaco</li> <li><strong>Tipo :</strong> Autocierre con banda de silicona</li> <li><strong>Acabado</strong>: Liguero rosa a juego</li> <li><strong>Tallas</strong>: Estándar y varias disponibles</li> </ul>
stylingtips
string<p>El <strong>rosa neón brillante</strong> de estas medias las convierte en las piezas perfectas para sorprender y crear looks atrevidos. 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. <strong>Los ligueros a juego</strong> añaden un toque femenino que combina a la perfección con conjuntos desenfadados o sofisticados.</p> <p>Completa tu look con nuestros <a href="https://www.legsboudoir.com/es/bodystockings-y-catsuits/">bodystockings</a> y descubre nuestra selección de <a href="https://www.legsboudoir.com/es/bodys-de-talla-grande/">bodystockings de talla grande</a> para crear conjuntos perfectamente coordinados.</p>
summary
string<p><strong>Atrévete con nuestras medias de color rosa neón</strong>, diseñadas para sorprender a todos los que te rodean con su <strong>brillante tonalidad</strong>.</p> <p>Estas finas medias de nailon ofrecen una <strong>suntuosa curva</strong> y <strong>una sujeción perfecta</strong> gracias a su banda de silicona bajo encaje.</p>
title
stringMedias rosa fluorescente - Color intenso y curva suntuosa
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Ces <strong>bas autofixants rose fluo</strong> incarnent l'audace et la f&eacute;minit&eacute; moderne. Leur <strong>couleur rose &eacute;clatante</strong> apporte une touche d'originalit&eacute; saisissante &agrave; votre garde-robe, tandis que la <strong>finition l&eacute;g&egrave;rement opaque</strong> offre une couverture naturelle qui sublime la peau.</p> <p>La <strong>composition 85% nylon et 15% &eacute;lasthanne</strong> garantit une <strong>extensibilit&eacute; parfaite</strong> qui s'adapte harmonieusement aux courbes de chaque morphologie. Cette alliance de mati&egrave;res nobles procure un <strong>confort exceptionnel</strong> et une r&eacute;sistance optimale pour un port prolong&eacute;.</p> <p>La <strong>bande de silicone plac&eacute;e sous la dentelle</strong> assure un <strong>maintien parfait toute la journ&eacute;e</strong> sans comprimer ni marquer la peau. Cette technologie permet une <strong>libert&eacute; de mouvement totale</strong> tout en garantissant que vos bas restent parfaitement en place.</p> <p>Les <strong>jolies jarreti&egrave;res roses assorties</strong> constituent le d&eacute;tail qui fait toute la diff&eacute;rence. Cette finition soign&eacute;e transforme un simple bas en v&eacute;ritable accessoire de mode, cr&eacute;ant une <strong>silhouette &eacute;lanc&eacute;e</strong> et un <strong>galbe somptueux</strong> qui valorise naturellement la beaut&eacute; de chaque silhouette.</p>
highlights
string<ul> <li><strong>Rose fluo &eacute;clatant</strong> pour un style audacieux</li> <li><strong>Nylon fin haute qualit&eacute;</strong> pour un toucher soyeux</li> <li><strong>Bande de silicone sous dentelle</strong> pour un maintien optimal</li> <li><strong>L&eacute;g&egrave;rement opaque</strong> pour un effet naturel &eacute;l&eacute;gant</li> <li><strong>Jarreti&egrave;res roses assorties</strong> pour une finition raffin&eacute;e</li> <li><strong>Galbe parfait</strong> qui valorise la silhouette</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringBas autofixants rose fluo grande taille avec bande silicone et jarretières assorties. Couleur éclatante et galbe somptueux chez Leg's Boudoir.
keywords
string
title
stringBas Autofixants Rose Fluo Grande Taille | Leg's Boudoir
seotitle
stringBas Autofixants Rose Fluo Grande Taille
seouri
stringbas-autofixants-rose-fluo-grande-taille
specifications
string<ul> <li><strong>Mati&egrave;re :</strong> 85% Nylon, 15% &Eacute;lasthanne</li> <li><strong>Couleur :</strong> Rose fluo</li> <li><strong>Opacit&eacute; :</strong> L&eacute;g&egrave;rement opaque</li> <li><strong>Type :</strong> Autofixants avec bande silicone</li> <li><strong>Finition :</strong> Jarreti&egrave;res roses assorties</li> <li><strong>Tailles :</strong> Standard et plusieurs tailles disponibles</li> </ul>
stylingtips
string<p>Le <strong>rose fluo &eacute;clatant</strong> de ces bas en fait des pi&egrave;ces statement parfaites pour surprendre et cr&eacute;er des looks audacieux. 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;. Les <strong>jarreti&egrave;res assorties</strong> apportent une touche de f&eacute;minit&eacute; qui se marie parfaitement avec des tenues d&eacute;cal&eacute;es ou sophistiqu&eacute;es.</p> <p>Compl&eacute;tez votre look avec nos <a href="https://www.legsboudoir.com/fr/bodystocking-et-catsuits/">bodystockings</a> et d&eacute;couvrez notre s&eacute;lection de <a href="https://www.legsboudoir.com/fr/bodystockings-grande-taille/">bodystockings grande taille</a> pour cr&eacute;er des tenues parfaitement coordonn&eacute;es.</p>
summary
string<p><strong>Osez la couleur avec nos bas autofixants rose fluo</strong>, con&ccedil;us pour surprendre votre entourage avec leur <strong>teinte &eacute;clatante</strong>.</p> <p>Ces bas fins nylon offrent un&nbsp;<strong>galbe somptueux</strong> et un <strong>maintien parfait</strong> gr&acirc;ce &agrave; leur bande de silicone sous dentelle.</p>
title
stringBas Autofixants Rose Fluo - Couleur Intense et Galbe Somptueux
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Queste <strong>autoreggenti rosa neon</strong> sono l'emblema di una femminilità audace e moderna. Il loro <strong>colore rosa acceso</strong> aggiunge un tocco di originalità al vostro guardaroba, mentre la <strong>finitura leggermente opaca</strong> offre una copertura naturale che valorizza la pelle.</p> <p>La <strong>composizione di 85% nylon e 15% elastan</strong> garantisce una <strong>perfetta elasticità</strong> che si adatta armoniosamente alle curve di ogni tipo di corpo. Questa combinazione di materiali nobili offre un <strong>comfort eccezionale</strong> e una resistenza ottimale per un uso prolungato.</p> <p>La <strong>fascia in silicone sotto il pizzo</strong> assicura un <strong>sostegno perfetto per tutto il giorno</strong> senza comprimere o segnare la pelle. Questa tecnologia consente <strong>una totale libertà di movimento</strong> e garantisce che le calze rimangano perfettamente al loro posto.</p> <p>Il <strong>grazioso reggicalze rosa coordinato</strong> è il dettaglio che fa la differenza. Questa finitura meticolosa trasforma una semplice calza in un vero e proprio accessorio di moda, creando una <strong>silhouette sottile</strong> e una <strong>curva sontuosa</strong> che esalta naturalmente la bellezza di ogni figura.</p>
highlights
string<ul> <li><strong>Rosa neon brillante</strong> per uno stile deciso</li> <li><strong>Nylon pregiato di alta qualità</strong> per una sensazione setosa al tatto</li> <li><strong>Fascia in silicone sotto il pizzo</strong> per un sostegno ottimale</li> <li><strong>Leggermente opaco</strong> per un elegante effetto naturale</li> <li><strong>Giarrettiere rosa abbinate</strong> per una finitura raffinata</li> <li><strong>Forma perfetta</strong> per esaltare la silhouette</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringAutoreggenti rosa fluo con fascia in silicone e reggicalze coordinati. Colori vivaci e curve sontuose da Leg's Boudoir.
keywords
string
title
stringCalze rosa fluorescenti di taglia grande | Leg's Boudoir
seotitle
stringRosa fluorescente Taglia grande
seouri
stringhold-up-rosa-fluorescente-taglia-grande
specifications
string<ul> <li><strong>Materiale:</strong> 85% nylon, 15% elastan</li> <li><strong>Colore:</strong> rosa fluorescente</li> <li><strong>Opacità:</strong> Leggermente coprente</li> <li><strong>Tipo :</strong> Autoaderente con fascia in silicone</li> <li><strong>Finitura :</strong> Giarrettiere rosa abbinate</li> <li><strong>Taglie</strong>: Standard e diverse taglie disponibili</li> </ul>
stylingtips
string<p>Il <strong>rosa neon brillante</strong> di queste calze le rende perfette per sorprendere e creare look audaci. 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. <strong>I reggicalze abbinati</strong> aggiungono un tocco femminile che si abbina perfettamente ad outfit anticonformisti o sofisticati.</p> <p>Completate il vostro look con i nostri <a href="https://www.legsboudoir.com/it/bodystocking-e-tute/">bodystockings</a> e scoprite la nostra selezione di <a href="https://www.legsboudoir.com/it/bodystockings-di-taglia-grande/">bodystockings taglia grande</a> per creare outfit perfettamente coordinati.</p>
summary
string<p><strong>Osate essere colorate con le nostre calze autoreggenti rosa neon</strong>, progettate per sorprendere tutti coloro che vi circondano con la loro <strong>tonalità brillante</strong>.</p> <p>Queste calze in nylon pregiato offrono una <strong>curva sontuosa</strong> e un <strong>sostegno perfetto</strong> grazie alla fascia in silicone sotto il pizzo.</p>
title
stringRosa fluorescente - Colore intenso e curva sontuosa
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Deze <strong>neonroze hold-ups</strong> zijn het toppunt van gedurfde, moderne vrouwelijkheid. Hun <strong>felroze kleur</strong> voegt een opvallend vleugje originaliteit toe aan je garderobe, terwijl de <strong>licht ondoorzichtige afwerking</strong> een natuurlijke dekking biedt die de huid mooier maakt.</p> <p>De <strong>samenstelling van 85% nylon en 15% elastaan</strong> garandeert een <strong>perfecte stretch</strong> die zich harmonieus aanpast aan de rondingen van elk lichaamstype. Deze combinatie van edele materialen biedt <strong>uitzonderlijk comfort</strong> en optimale weerstand voor langdurig dragen.</p> <p>De <strong>siliconenband onder de veter</strong> zorgt <strong>de hele dag</strong> voor <strong>een perfecte ondersteuning</strong> zonder de huid samen te drukken of te beschadigen. Deze technologie zorgt voor <strong>totale bewegingsvrijheid</strong> terwijl je kousen perfect op hun plaats blijven zitten.</p> <p>De <strong>mooie bijpassende roze kousenbanden</strong> zijn het detail dat het verschil maakt. Deze zorgvuldige afwerking verandert een eenvoudige kous in een echt mode-accessoire en cre&euml;ert een <strong>slank silhouet</strong> en een <strong>weelderige ronding</strong> die de schoonheid van elk figuur op natuurlijke wijze benadrukt.</p>
highlights
string<ul> <li><strong>Helder neonroze</strong> voor een gedurfde stijl</li> <li><strong>Hoogwaardig fijn nylon</strong> voor een zijdezacht gevoel</li> <li><strong>Siliconen band onder kant</strong> voor optimale ondersteuning</li> <li><strong>Licht ondoorschijnend</strong> voor een elegant natuurlijk effect</li> <li><strong>Bijpassende roze kousenband</strong> voor een verfijnde afwerking</li> <li><strong>Perfecte vorm</strong> om het silhouet te verbeteren</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringFluorescerend roze hold-ups met siliconen band en bijpassende kousenbanden. Levendige kleuren en weelderige rondingen bij Leg's Boudoir.
keywords
string
title
stringFluorescerend Roze Kousen Grote Maat | Leg's Boudoir
seotitle
stringFluorescerend roze hold ups Grote maat
seouri
stringfluorescerend-roze-hold-ups-grote-maat
specifications
string<ul> <li><strong>Materiaal:</strong> 85% nylon, 15% elastaan</li> <li><strong>Kleur:</strong> Fluorescerend roze</li> <li><strong>Opaciteit:</strong> Licht ondoorschijnend</li> <li><strong>Type :</strong> Zelfsluitend met siliconenband</li> <li><strong>Afwerking :</strong> Bijpassende roze kousenband</li> <li><strong>Maten</strong>: Standaard en verschillende maten beschikbaar</li> </ul>
stylingtips
string<p>Het <strong>felle neonroze</strong> van deze kousen maakt ze tot de perfecte statement pieces om te verrassen en gewaagde looks te cre&euml;ren. Combineer ze met zwarte of witte stukken om hun levendige kleur naar voren te laten komen, of ga voor een totale kleurenlook voor een gedurfd stijlstatement. <strong>Bijpassende kousenbanden</strong> voegen een vrouwelijke touch toe die perfect past bij onconventionele of geraffineerde outfits.</p> <p>Maak je look compleet met onze <a href="https://www.legsboudoir.com/nl/bodystocking-en-catsuits/">bodystockings</a> en ontdek onze selectie <a href="https://www.legsboudoir.com/nl/bodystockings-grote-maten/">bodystockings in grote maten</a> om perfect geco&ouml;rdineerde outfits te cre&euml;ren.</p>
summary
string<p><strong>Durf kleurrijk te zijn met onze neonroze hold-ups</strong>, ontworpen om iedereen om je heen te verrassen met hun <strong>felle tint</strong>.</p> <p>Deze fijne nylonkousen bieden een <strong>weelderige ronding</strong> en <strong>perfecte ondersteuning</strong> dankzij de siliconen band onder het kant.</p>
title
stringFluorescerend roze hold-ups - Intense kleur en weelderige curve
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Estas <strong>cuecas rosa néon</strong> são o epítome da feminilidade arrojada e moderna. A sua <strong>cor rosa vivo</strong> confere um toque de originalidade marcante ao seu guarda-roupa, enquanto o <strong>acabamento ligeiramente opaco</strong> oferece uma cobertura natural que realça a pele.</p> <p>A <strong>composição de 85% de nylon e 15% de elastano</strong> garante <strong>uma elasticidade perfeita</strong> que se adapta harmoniosamente às curvas de cada tipo de corpo. Esta combinação de materiais nobres proporciona <strong>um conforto excecional</strong> e uma resistência óptima para uma utilização prolongada.</p> <p>A <strong>banda de silicone sob a renda</strong> garante <strong>um suporte perfeito durante todo o dia</strong>, sem comprimir nem marcar a pele. 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>As <strong>bonitas ligas cor-de-rosa a condizer</strong> são o pormenor que faz toda a diferença. Este acabamento minucioso transforma uma simples meia num verdadeiro acessório de moda, criando uma <strong>silhueta esguia</strong> e uma <strong>curva sumptuosa</strong> que realça naturalmente a beleza de cada figura.</p>
highlights
string<ul> <li><strong>Rosa néon brilhante</strong> para um estilo arrojado</li> <li><strong>Nylon fino de alta qualidade</strong> para um toque sedoso</li> <li><strong>Faixa de silicone sob a renda</strong> para um suporte ótimo</li> <li><strong>Ligeiramente opaco</strong> para um elegante efeito natural</li> <li><strong>Ligeiras ligas cor-de-rosa a condizer</strong> para um acabamento requintado</li> <li><strong>Forma perfeita</strong> para realçar a silhueta</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringSutiãs rosa fluorescente com banda de silicone e ligas a condizer. Cores vibrantes e curvas sumptuosas na Leg's Boudoir.
keywords
string
title
stringMeias-calças cor-de-rosa fluorescente Grande | Leg's Boudoir
seotitle
stringMeias cor-de-rosa fluorescente Grande
seouri
stringmeias-rosa-fluorescente-tamanho-grande
specifications
string<ul> <li><strong>Material:</strong> 85% nylon, 15% elastano</li> <li><strong>Cor:</strong> Rosa fluorescente</li> <li><strong>Opacidade:</strong> Ligeiramente opaco</li> <li><strong>Tipo :</strong> Auto-fixação com banda de silicone</li> <li><strong>Acabamento:</strong> Ligas cor-de-rosa a condizer</li> <li><strong>Tamanhos</strong>: Normal e vários tamanhos disponíveis</li> </ul>
stylingtips
string<p>O <strong>rosa néon brilhante</strong> destas meias torna-as nas peças de afirmação perfeitas para surpreender e criar looks ousados. 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. <strong>As ligas a condizer</strong> acrescentam um toque feminino que combina na perfeição com conjuntos fora do comum ou sofisticados.</p> <p>Complete o seu look com os nossos <a href="https://www.legsboudoir.com/pt/bodystocking-e-catsuits/">bodystockings</a> e descubra a nossa seleção de <a href="https://www.legsboudoir.com/pt/bodystockings-plus-size/">bodystockings plus size</a> para criar conjuntos perfeitamente coordenados.</p>
summary
string<p>Atreva-se<strong>a ser colorida com as nossas meias de ligas rosa néon</strong>, concebidas para surpreender todos à sua volta com a sua <strong>tonalidade brilhante</strong>.</p> <p>Estas meias de nylon fino oferecem uma <strong>curva sumptuosa</strong> e um <strong>suporte perfeito</strong> graças à sua banda de silicone sob o laço.</p>
title
stringMeias rosa fluorescente - Cor intensa e curva sumptuosa
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
stringDG0005NXPNK
netweight
string
nextshipment
stringtomorrow
ordered
number3
orderidx
number0
origin
string
originalsize
string
packaging
number0
productshipment
stringauto
productuid
string48D69B15-6FF6-4EA2-B5241E6595879204
promountil
string
rating
stringnone
recorduid
string48D69B15-6FF6-4EA2-B5241E6595879204
reference
stringSLST6393
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.23 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 = '48D69B15-6FF6-4EA2-B5241E6595879204'
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,standard
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.35 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 = '48D69B15-6FF6-4EA2-B5241E6595879204'
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 = '48D69B15-6FF6-4EA2-B5241E6595879204'
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
148D69B15-6FF6-4EA2-B5241E65958792046680DBE2-D54C-4AA5-9C3684B3048EBA041816fluorose#FA22A0One2-434-404-108-1236-4236-4234-4040-4636-4234-40wstocking2-4intlsize14.1250STOCK01000-10000-10all
248D69B15-6FF6-4EA2-B5241E65958792049129796D-BC77-4EC4-91D8CF47BAD2CCE91112fluorose#FA22A0Queen5-642-4812-1816-2244-5044-5042-4848-5244-5042-48wstocking5-6intlsize14.1250STOCK01000-10300888368050819-10all
subcategory
stringstocking
supplier
number-1
supplierreference
stringDG0005
tags
string
themes
stringlollipop,readyforvalentine
totalvariations
number2
type
stringdefault
unitprice
number14.125
usageinstructions
stringholdups
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 4.15 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 = '48D69B15-6FF6-4EA2-B5241E6595879204' 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 = '48D69B15-6FF6-4EA2-B5241E6595879204' 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 = '48D69B15-6FF6-4EA2-B5241E6595879204' 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 = '48D69B15-6FF6-4EA2-B5241E6595879204' 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 = '48D69B15-6FF6-4EA2-B5241E6595879204' 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 = '48D69B15-6FF6-4EA2-B5241E6595879204' 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 = '48D69B15-6FF6-4EA2-B5241E6595879204'
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 = '48D69B15-6FF6-4EA2-B5241E6595879204' 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 = '48D69B15-6FF6-4EA2-B5241E6595879204' 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 = '48D69B15-6FF6-4EA2-B5241E6595879204' 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 = '48D69B15-6FF6-4EA2-B5241E6595879204' 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 = '48D69B15-6FF6-4EA2-B5241E6595879204' 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 = '48D69B15-6FF6-4EA2-B5241E6595879204' 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 = '48D69B15-6FF6-4EA2-B5241E6595879204'
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
16680DBE2-D54C-4AA5-9C3684B3048EBA041816fluorose#FA22A0One2-434-404-108-1236-4236-4234-4040-4636-4234-40wstocking2-4intlsize14.1250STOCK01000-10000-10-10-10014.125all
29129796D-BC77-4EC4-91D8CF47BAD2CCE91112fluorose#FA22A0Queen5-642-4812-1816-2244-5044-5042-4848-5244-5042-48wstocking5-6intlsize14.1250STOCK01000-10300888368050819-10-10-10014.125all
vatrate
number20
warehouse
number0