Vedere le dimensioni
Calze 60 Den Opache
Doppio clic per ingrandire
SKU: SLST0376
Calze 60 Den Opache
Stock:

Un pezzo raro, soprattutto in dimensioni così belle, che amerete per tutta la stagione.

Punti di forza

  • Materiali di alta qualità per una raffinatezza duratura
  • tessutoopaco da 60 denari per una morbidezza e un calore ottimali
  • La texture setosa accarezza delicatamente le gambe
  • La perfetta vestibilità esalta le vostre forme naturali
  • Ideale per tutte le stagioni con una protezione invernale extra
  • Calze ottimale per curve generose
  • Comfort imbattibile per un guardaroba femminile raffinato
  • Indispensabile per essere sempre chic e alla moda
Taglia:

Non siete sicuri della taglia da scegliere? Consultare la nostra guida alle taglie

Colore:
Quantità:
24.95 €
Aiuto e consulenza
via chat, facebook o e-mail
Restituzione gratuita
entro 15 giorni *

Calze coprenti di grande taglia

Descrizione del prodotto

Realizzate con materiali di alta qualità, queste calze coprenti 60 Den offrono un comfort ineguagliabile e un sostegno ottimale, accentuando con eleganza le vostre curve naturali.

eleganti in ogni stagione, sono particolarmente adatte ai rigori dell'inverno.

La loro consistenza setosa e la vestibilità slim vi renderanno chic e alla moda, proteggendovi al tempo stesso dal freddo.

Abbinateli a un reggicalze per un look ancora più sofisticato che valorizzerà ancora di più le vostre gambe.

Dettagli tecnici

  • Stile: calze coprenti per una raffinatezza invernale
  • Denari: 60 denari per un calore e una protezione ottimali
  • Materiali : Alta qualità per una durata superiore
  • Texture : setosa per una morbidezza incomparabile
  • Vestibilità : Perfetta per le curve generose: Perfetta per le curve generose
  • Stagioni : Ideale per tutte le stagioni, soprattutto per l'inverno
  • Calze : Ottimale per un comfort insuperabile
  • Cura : Si consiglia un lavaggio delicato

Dimensioni disponibili

Disponibile da 4 a 10

Colore disponibile

Nero

Guida alle taglie

Controllare la taglia giusta per voi

Internazionale
  • Coscia
4
  • 49-55
5
  • 56-62
6
  • 62-69
7
  • 69-76
8
  • 76-83
9
  • 83-89
10
  • 89-96

Istruzioni per la cura

  • Lavaggio a mano consigliato con sapone delicato o in lavatrice a massimo 30°C in un sacchetto protettivo
  • Evitare ammorbidenti che indeboliscono l'elasticità delle fibre
  • Asciugare all'aria in piano, mai in asciugatrice
  • Maneggiare con mani pulite e senza gioielli per evitare strappi
  • Per taglie standard e plus (fino a 64), indossare delicatamente arrotolando la calza/collant ed evitando di tirare
  • Conservare separatamente da indumenti con chiusure o ganci che potrebbero danneggiarli
  • Per modelli fantasia, a rete o con motivi, lavare al rovescio per preservare i dettagli

Consigli per l'uso

  • Indossate prima il reggicalze e regolatelo comodamente alla vostra taglia
  • Raccogliete delicatamente la calza arrotolandola dalle dita fino al tallone
  • Posizionate il piede e srotolate gradualmente la calza lungo la gamba senza tirare
  • Per taglie 42-64, sedetevi per maggiore comfort durante l'indossamento
  • Consiglio pratico: fissate prima il gancetto anteriore, poi quello posteriore e terminate con i gancetti laterali
  • Regolate la tensione delle giarrettiere per un supporto equilibrato (né troppo stretto, né troppo lento)
  • Assicuratevi che la cucitura, se presente, sia dritta sul retro della gamba

Consigli di stile

Queste calze coprenti sono l'abbinamento perfetto per tutti i vostri look invernali, grazie alla loro raffinatezza senza tempo. La loro consistenza setosa si abbina elegantemente agli stivali alti per creare una silhouette chic, o alle décolleté per rivelare la loro bellezza opaca. Ideali sotto abiti o gonne corte, offrono una protezione termica e mettono in risalto le vostre curve naturali.

La loro perfetta vestibilità li rende un must-have del vostro guardaroba femminile, per essere sempre alla moda anche nelle stagioni più fredde, rivelando la vostra capacità di combinare il comfort termico con la raffinatezza moderna.

To Top
Articoli
Totale articoli
Struct
Entries: 108
actions
Array
available
number-1
brand
stringglamory
brandcode
stringgjjm
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
stringGlamory
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.946 ms
Record Count: 1
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_colors.color as recorduid, product_colors.type, product_colors.code, product_colors.color, product_colors.range, product_colors.hexvalue,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock
from product_colors
left outer join product_variations on product_colors.color = product_variations.color and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
where FIND_IN_SET(product_colors.color,'black') > 0
and product_variations.productuid = '6BCF32BA-0872-461A-B189CD544CB925A7'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1blackcolorblakblackblack#000000-12
colorrange
stringblack
colors
stringblack
colortype
stringcolor
comments
string
compositions
Struct
Entries: 13
coton
string
elastane
string
free
string
leather
string
lycra
string
metal
string
nylon
string
polyamide
string
polyester
string
polyurethane
string
silk
string
spandex
string
viscose
string
datecreated
Date Time (Europe/Paris)
{ts '2024-10-07 10:04:01'}
defect
number0
dimensions
Struct
Entries: 14
acrylicbones
string
backsideheight
string
diameter
string
flatsteelbones
string
frontsideheight
string
fullheight
string
length
string
modestysize
string
panels
string
sides
string
spiralsteelbones
string
totallength
string
unit
stringcm
wiresize
string
display
stringall
displayfrom
string
displayto
string
grossweight
string
hasbrandinfos
booleanfalse
hascareinstructions
booleantrue
hascolorinfos
booleantrue
hascompositions
booleanfalse
hasdescription
booleantrue
hasdimensions
booleanfalse
hasmaterials
booleanfalse
hasotherspecifications
booleanfalse
haspromo
number0
hasshortdescription
booleantrue
hassizeinfos
booleantrue
hasspecifications
booleantrue
hasstockinfos
booleanfalse
hasstylingtips
booleantrue
hasusageinstructions
booleantrue
hasvariations
booleantrue
import
string
inpromo
number0
instockvariations
string
isactive
number1
iscustommade
number0
isdivasize
number0
isfirstprice
number0
isfixedprice
number0
ishot
number0
isnew
number0
isonline
number0
isoutletprice
number0
itemprice
number20.7917
itempromo
string
key
string50136-noir60
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-05-30 12:30:14'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.795 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','it')
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('6bcf32ba-0872-461a-b189cd544cb925a7',lcase(cart_actions.linkedproducts)) > 0 and cart_actions.linkedproducts is not null
)
id_actionbrandinglanguagenamecodetypeminimumOrdermaximumOrderminimumItemsmaximumItemsmaximumUseallowedItemsquotasusedCountlinkedproductslinkedthemeslinkedbrandslinkeditemparamsactiveFromactiveToisActive
linkedproducts
Query
Template: /system/api/products.cfc:1305
Execution Time: 3.24 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','it')
and product_categories.language in ('all','it')
and (products.displayFrom <= DATE(NOW()) or products.displayFrom is null)
and (products.displayTo >= DATE(NOW()) or products.displayTo IS null)
and product_links.linkuid = '299E11FF-F497-4405-8B82AAC73469E15C' and product_links.linkuid is not null and product_links.linkuid <> ''
and products.reference <> 'SLST0376'
group by products.reference
order by products.ishot desc, products.isnew desc, orderidx asc, products.lastupdated desc
productuidreferencetypekeylanguagenamelinkuidcolorsvatratemetadatasdimensionsmediadatastagsthemesisdivasizetotalvariationsvariationlistinpromohaspromoitempromoitempriceunitpricepricespromountilisfixedpriceishotisneworderidxavailablestockinstockvariationsbrandbrandnameshowbranddisplaysizetypeintlsizesizessizerangecategorymediadatascategorysizerangesectioncategorysubcategory
linkuid
string299E11FF-F497-4405-8B82AAC73469E15C
materials
string
mediadatas
Struct
alt
Struct
height
string2373
isprivate
string0
rating
stringall
src
string/photobank/products/gjjm/slst0376/50136_noir60_bk01-scaled.jpg
type
stringimg
width
string1642
back
Struct
height
string2560
isprivate
string0
rating
stringall
src
string/photobank/products/gjjm/slst0376/50136_noir60_bk_left_01-scaled.jpg
type
stringimg
width
string1458
default
Struct
height
string2560
isprivate
string0
rating
stringall
src
string/photobank/products/gjjm/slst0376/50136_noir60_bk_right_02-scaled_1.jpg
type
stringimg
width
string1632
variations
Struct
colors
Struct
black
Struct
height
string2560
isprivate
string0
rating
stringall
src
string/photobank/products/gjjm/slst0376/50136_noir60_bk_left_02-scaled.jpg
type
stringimg
width
string1632
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
mediagallery
string
metadatas
Struct
darkboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
divasboudoir
Struct
de
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p><span>Diese blickdichten Strümpfe 60 Den aus hochwertigen Materialien bieten unvergleichlichen Komfort und optimalen Halt, während sie Ihre natürlichen Kurven elegant betonen. </span></p> <p><span>sie sind zu jeder Jahreszeit elegant und eignen sich besonders gut für den Winter. </span></p> <p><span>Dank der seidigen Textur und der engen Passform sehen Sie schick und modisch aus und sind gleichzeitig vor Kälte geschützt. </span></p> <p><span>Kombinieren Sie sie mit einem Strapsgürtel, um einen noch raffinierteren Look zu erzielen und Ihre Beine noch mehr zu betonen. </span></p>
guid
stringhttps://dev.divasboudoir.com/de/blickdichte-strumpfe-in-grossen-grossen-schwarz/slst0376.htm
highlights
string<ul> <li>Hochwertige Materialien für dauerhafte Raffinesse</li> <li><strong>blickdichte 60 Denier</strong> für optimale Weichheit und Wärme</li> <li>Seidige Textur umschmeichelt sanft Ihre Beine</li> <li>Perfekte Passform, die natürliche Formen betont</li> <li>Ideal für alle Jahreszeiten mit erhöhtem Winterschutz</li> <li>Optimaler BH, der sich an die <strong>Kurven</strong> anschmiegt</li> <li>Unübertroffener Komfort für anspruchsvolle Damengarderobe</li> <li>Unverzichtbar, um schick und trendy zu bleiben</li> </ul>
keypoint
string
keywords
stringblickdichte Strümpfe, 60 Denier, elegant, Komfort, thermisch, Winter, seidig, Unterstützung, Diva's Boudoir, Dessous, Weiblichkeit, große Größe
metas
Struct
description
stringEntdecken Sie unsere schwarzen60 Strümpfe aus blickdichter Mikrofaser mit Stretchanteil. Erschwinglicher Luxus für große und kurvige Frauen. Schick das ganze Jahr über, perfekt für den Winter. Strapsgürtel erforderlich.
keywords
stringblickdichte Strümpfe, 60 Denier, elegant, Komfort, thermisch, Winter, seidig, Unterstützung, Diva's Boudoir, Dessous, Weiblichkeit, große Größe
title
stringDiva's Boudoir: Luxuriöse schwarze Strümpfe60 für runde Frauen
seotitle
stringBlickdichte Strümpfe in großen Größen
seouri
stringblickdichte-strumpfe-in-grossen-grossen-schwarz
specifications
string<ul> <li>Stil: Blickdichte Strümpfe winterliche Raffinesse</li> <li>Denier: 60 Denier optimale Wärme und Schutz</li> <li>Material: Hohe Qualität für Premium-Haltbarkeit</li> <li>Textur: Seidig für unvergleichliche Weichheit</li> <li>Passform: Perfekt für großzügige Kurven</li> <li>Jahreszeiten: Ideal für alle Jahreszeiten, besonders für den Winter</li> <li>BH: Optimal für unvergleichlichen Komfort</li> <li>Pflege: Feinwäsche empfohlen</li> </ul>
stylingtips
string<p>Diese <strong>blickdichten Strümpfe</strong> passen dank ihrer zeitlosen Raffinesse perfekt zu all Ihren Winterlooks. Ihre seidige Textur lässt sich elegant mit hohen Stiefeln kombinieren, um eine schicke Silhouette zu kreieren, oder mit Pumps, um ihre blickdichte Schönheit zu enthüllen. Ideal unter kurzen Kleidern oder Röcken, bieten sie diesen Wärmeschutz und betonen gleichzeitig Ihre natürlichen Formen.</p> <p>Ihre perfekte Passform macht sie zu einem unverzichtbaren Bestandteil Ihrer Damengarderobe, mit dem Sie auch bei kaltem Wetter modisch aussehen können und der Ihre Fähigkeit offenbart, Wärmekomfort und moderne Raffinesse mit selbstbewusster Kultiviertheit zu verbinden.</p>
summary
stringEin seltenes Stück, vor allem in so schönen Größen, das Sie die ganze Saison über lieben werden.
title
stringStrümpfe 60 Den Opake
usageinstructions
string
el
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p><span>Κατασκευασμένες από υλικά υψηλής ποιότητας, αυτές οι αδιαφανείς κάλτσες 60 Den προσφέρουν απαράμιλλη άνεση και βέλτιστη στήριξη, ενώ παράλληλα τονίζουν κομψά τις φυσικές σας καμπύλες. </span></p> <p><span>κομψές σε κάθε εποχή, είναι ιδιαίτερα κατάλληλες για τις κακουχίες του χειμώνα. </span></p> <p><span>Η μεταξένια υφή τους και η λεπτή τους εφαρμογή θα σας κρατήσουν κομψή και μοντέρνα, ενώ παράλληλα θα σας προστατεύουν από το κρύο. </span></p> <p><span>Συνδυάστε τα με μια ζώνη καλτσοδέτας για μια ακόμη πιο εκλεπτυσμένη εμφάνιση που θα αναδείξει ακόμη περισσότερο τα πόδια σας. </span></p>
guid
stringhttps://dev.divasboudoir.com/el/kaltses-megaloy-megethoys-adiafaneis-mayro/slst0376.htm
highlights
string<ul> <li>Υλικά υψηλής ποιότητας για διαρκή εκλέπτυνση</li> <li><strong>αδιαφανές</strong> ύφασμα<strong>60 denier</strong> για βέλτιστη απαλότητα και ζεστασιά</li> <li>Η μεταξένια υφή χαϊδεύει απαλά τα πόδια σας</li> <li>Η τέλεια εφαρμογή ενισχύει το φυσικό σας σχήμα</li> <li>Ιδανικό για όλες τις εποχές με επιπλέον προστασία το χειμώνα</li> <li>Βέλτιστη στήριξη για <strong>γενναιόδωρες καμπύλες</strong></li> <li>Ασυναγώνιστη άνεση για εκλεπτυσμένες γυναικείες γκαρνταρόμπες</li> <li>Απαραίτητη για να παραμείνετε κομψοί και μοντέρνοι</li> </ul>
keypoint
string
keywords
stringαδιαφανείς κάλτσες, 60 denier, κομψές, άνεση, θερμικές, χειμώνα, μεταξένιες, υποστήριξη, Diva's Boudoir, εσώρουχα, θηλυκότητα, μεγάλο μέγεθος
metas
Struct
description
stringΑνακαλύψτε τις κάλτσες μας black60 από αδιαφανή, ελαστική μικροΐνα. Προσιτή πολυτέλεια για ψηλές, καμπυλωτές γυναίκες. Κομψές όλο το χρόνο, ιδανικές για το χειμώνα. Απαιτείται ζώνη καλτσοδέτας.
keywords
stringαδιαφανείς κάλτσες, 60 denier, κομψές, άνεση, θερμικές, χειμώνα, μεταξένιες, υποστήριξη, Diva's Boudoir, εσώρουχα, θηλυκότητα, μεγάλο μέγεθος
title
stringΜπουντουάρ της Ντίβας : Luxurious60 Μαύρες κάλτσες για στρογγυλές γυναίκες
seotitle
stringΚάλτσες μεγάλου μεγέθους αδιαφανείς
seouri
stringkaltses-megaloy-megethoys-adiafaneis-mayro
specifications
string<ul> <li>Στυλ : Αδιαφανείς κάλτσες για χειμερινή φινέτσα</li> <li>Denier: 60 denier για βέλτιστη ζεστασιά και προστασία</li> <li>Υλικά : Υψηλής ποιότητας για κορυφαία ανθεκτικότητα</li> <li>Υφή : Μεταξένια για απαράμιλλη απαλότητα</li> <li>Εφαρμογή : Ιδανική για γενναιόδωρες καμπύλες</li> <li>Εποχές : Ιδανικό για όλες τις εποχές, ειδικά το χειμώνα</li> <li>Στήριξη: Βέλτιστη για αξεπέραστη άνεση</li> <li>Φροντίδα : Συνιστάται απαλό πλύσιμο</li> </ul>
stylingtips
string<p>Αυτές οι <strong>αδιαφανείς κάλτσες</strong> ταιριάζουν απόλυτα με όλες τις χειμερινές σας εμφανίσεις, χάρη στη διαχρονική τους φινέτσα. Η μεταξένια υφή τους συνδυάζεται κομψά με ψηλές μπότες για να δημιουργήσει μια κομψή σιλουέτα, ή με γόβες για να αποκαλύψει την αδιαφανή ομορφιά τους. Ιδανικά κάτω από φορέματα ή κοντές φούστες, παρέχουν αυτή τη θερμική προστασία, ενώ παράλληλα αναδεικνύουν τις φυσικές σας καμπύλες.</p> <p>Η τέλεια εφαρμογή τους τα καθιστά απαραίτητα για τη γυναικεία σας γκαρνταρόμπα, διατηρώντας σας στην τάση ακόμη και στις πιο κρύες καιρικές συνθήκες, αποκαλύπτοντας την ικανότητά σας να συνδυάζετε τη θερμική άνεση με τη σύγχρονη εκλέπτυνση.</p>
summary
stringΈνα σπάνιο κομμάτι, ειδικά σε τόσο όμορφα μεγέθη, που θα αγαπήσετε όλη τη σεζόν.
title
stringΚάλτσες 60 Den Opaques
usageinstructions
string
en
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p><span>Made from high-quality materials, these opaque 60 Den stockings offer unrivalled comfort and optimum support, while elegantly accentuating your natural curves. </span></p> <p><span>elegant in any season, they're particularly well-suited to the rigors of winter. </span></p> <p><span>Their silky texture and slim fit will keep you chic and on-trend, while protecting you from the cold. </span></p> <p><span>Pair them with a garter belt for an even more sophisticated look that enhances your legs. </span></p>
guid
stringhttps://dev.divasboudoir.com/en/opaque-plus-size-stockings-black/slst0376.htm
highlights
string<ul> <li>High-quality materials for lasting sophistication</li> <li><strong>60-denier opaque</strong> fabric for optimum softness and warmth</li> <li>Silky texture gently caresses your legs</li> <li>Perfect fit enhances natural shape</li> <li>Ideal for all seasons with reinforced winter protection</li> <li>Optimal bra for <strong>generous curves</strong></li> <li>Unbeatable comfort for refined feminine wardrobes</li> <li>Indispensable for staying chic and trendy</li> </ul>
keypoint
string
keywords
stringopaque stockings, 60 denier, elegant, comfort, thermal, winter, silky, bra, Diva's Boudoir, lingerie, femininity, plus size
metas
Struct
description
stringDiscover our black60 stockings in opaque, stretch microfiber. Affordable luxury for tall, curvy women. Year-round chic, perfect for winter. Garter belt required.
keywords
stringopaque stockings, 60 denier, elegant, comfort, thermal, winter, silky, bra, Diva's Boudoir, lingerie, femininity, plus size
title
stringDiva's Boudoir : Luxurious60 Black Stockings for Round Women
seotitle
stringOpaque plus size stockings
seouri
stringopaque-plus-size-stockings-black
specifications
string<ul> <li>Style: Opaque stockings for winter sophistication</li> <li>Denier: 60 denier for optimum warmth and protection</li> <li>Materials: High quality for premium durability</li> <li>Texture: Silky for incomparable softness</li> <li>Fit : Perfect for generous curves</li> <li>Seasons: Ideal for all seasons, especially winter</li> <li>Bra: Optimal bra for unsurpassed comfort</li> <li>Care: Delicate wash recommended</li> </ul>
stylingtips
string<p>These <strong>opaque stockings</strong> are the perfect match for all your winter looks, thanks to their timeless sophistication. Their silky texture pairs elegantly with tall boots to create a chic silhouette, or with pumps to reveal their opaque beauty. Ideal under dresses or short skirts, they provide that thermal protection while enhancing your natural curves.</p> <p>Their perfect fit makes them a must-have in your women's wardrobe, keeping you on trend even in cold weather, revealing your ability to combine thermal comfort and modern refinement with assumed sophistication.</p>
summary
stringA rare piece, especially in such beautiful sizes, that you'll love all season long.
title
stringStockings 60 Den Opaques
usageinstructions
string
es
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p><span>Fabricadas con materiales de alta calidad, estas medias opacas 60 Den ofrecen un confort inigualable y una sujeción óptima, al tiempo que acentúan con elegancia sus curvas naturales. </span></p> <p><span>elegantes en cualquier estación, son especialmente adecuadas para los rigores del invierno. </span></p> <p><span>Su textura sedosa y su corte entallado te mantendrán elegante y a la moda, al tiempo que te protegen del frío. </span></p> <p><span>Combínalos con un liguero para un look aún más sofisticado que realzará aún más tus piernas. </span></p>
guid
stringhttps://dev.divasboudoir.com/es/medias-opacas-de-talla-grande-negro/slst0376.htm
highlights
string<ul> <li>Materiales de alta calidad para una sofisticación duradera</li> <li>tejido<strong>opaco de 60 deniers</strong> para una suavidad y calidez óptimas</li> <li>Textura sedosa que acaricia suavemente las piernas</li> <li>El ajuste perfecto realza su forma natural</li> <li>Ideal para todas las estaciones con protección extra para el invierno</li> <li>Sujeción óptima para <strong>curvas generosas</strong></li> <li>Comodidad insuperable para un vestuario femenino refinado</li> <li>Indispensable para ir a la moda y a la moda</li> </ul>
keypoint
string
keywords
stringmedias opacas, 60 deniers, elegantes, comodidad, térmicas, invierno, sedosas, sujetador, Diva's Boudoir, lencería, feminidad, talla grande
metas
Struct
description
stringDescubra nuestras medias negras60 de microfibra opaca y elástica. Lujo asequible para mujeres altas y con curvas. Elegantes todo el año, perfectas para el invierno. Requiere liguero.
keywords
stringmedias opacas, 60 deniers, elegantes, comodidad, térmicas, invierno, sedosas, sujetador, Diva's Boudoir, lencería, feminidad, talla grande
title
stringDiva's Boudoir : Lujosas60 Medias Negras para Mujeres Redondas
seotitle
stringMedias opacas de talla grande
seouri
stringmedias-opacas-de-talla-grande-negro
specifications
string<ul> <li>Estilo : Medias opacas para la sofisticación invernal</li> <li>Denier: 60 deniers para una calidez y protección óptimas</li> <li>Materiales : Alta calidad para una durabilidad superior</li> <li>Textura : Sedosa para una suavidad incomparable</li> <li>Ajuste : Perfecto para curvas generosas</li> <li>Temporadas : Ideal para todas las estaciones, especialmente el invierno</li> <li>Sujeción : Óptima para un confort insuperable</li> <li>Cuidados : Se recomienda un lavado delicado</li> </ul>
stylingtips
string<p>Estas <strong>medias opacas</strong> son el complemento perfecto para todos tus looks de invierno, gracias a su sofisticación atemporal. Su textura sedosa combina con elegancia con botas altas para crear una silueta chic, o con zapatos de salón para revelar su belleza opaca. Ideales bajo vestidos o faldas cortas, proporcionan protección térmica y realzan tus curvas naturales.</p> <p>Su ajuste perfecto los convierte en un imprescindible de su armario femenino, manteniéndole a la moda incluso en las épocas más frías, revelando su capacidad para combinar el confort térmico con la sofisticación moderna.</p>
summary
stringUna pieza rara, especialmente en tallas tan bonitas, que te encantará durante toda la temporada.
title
stringMedias 60 Den Opacas
usageinstructions
string
fr
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p class="text-base">Ces bas opaques <strong>60 deniers</strong> incarnent l'art de la sophistication hivernale moderne. Confectionn&eacute;s avec des mat&eacute;riaux de haute qualit&eacute;, ils r&eacute;pondent parfaitement aux attentes de douceur et d'&eacute;l&eacute;gance pour r&eacute;v&eacute;ler votre allure raffin&eacute;e tout en vous prot&eacute;geant des rigueurs du froid.<br><br><strong>Les mat&eacute;riaux de haute qualit&eacute;</strong> constituent l'innovation technique majeure de ces bas, cr&eacute;ant cette sensation de douceur incomparable qui caresse d&eacute;licatement vos jambes. Cette conception premium garantit une durabilit&eacute; exceptionnelle qui vous accompagne avec sophistication dans toutes vos activit&eacute;s.<br><br>La densit&eacute; <strong>60 deniers</strong> offre cette opacit&eacute; parfaite qui procure chaleur et protection tout en r&eacute;v&eacute;lant l'&eacute;l&eacute;gance de vos jambes. Cette &eacute;paisseur id&eacute;alement &eacute;tudi&eacute;e cr&eacute;e un &eacute;quilibre harmonieux entre confort thermique et esth&eacute;tique raffin&eacute;e, sublimant naturellement vos courbes g&eacute;n&eacute;reuses.<br><br>La texture soyeuse r&eacute;volutionne l'exp&eacute;rience tactile en apportant cette douceur luxueuse qui transforme chaque mouvement en moment de bien-&ecirc;tre. Cette finition d&eacute;licate &eacute;pouse parfaitement les formes, cr&eacute;ant cette harmonie entre confort et sophistication qui vous d&eacute;finit.<br><br>L'ajustement parfait t&eacute;moigne de l'attention port&eacute;e aux <strong>morphologies g&eacute;n&eacute;reuses</strong>. Ces bas mettent en valeur vos formes naturelles avec &eacute;l&eacute;gance, r&eacute;v&eacute;lant la beaut&eacute; unique de vos courbes avec une sophistication moderne qui transcende les saisons.<br><br><strong>Id&eacute;aux pour toutes les saisons,</strong> ils sont particuli&egrave;rement adapt&eacute;s pour affronter les rigueurs de l'hiver. Cette polyvalence saisonni&egrave;re vous permet de maintenir votre style raffin&eacute; tout au long de l'ann&eacute;e, en apportant cette protection thermique suppl&eacute;mentaire lors des p&eacute;riodes froides.<br><br>Le soutien optimal qu'ils procurent &eacute;pouse d&eacute;licatement vos courbes g&eacute;n&eacute;reuses, offrant ce confort in&eacute;galable qui vous accompagne du matin au soir. Cette technologie de maintien r&eacute;v&egrave;le votre beaut&eacute; naturelle sans contrainte, cr&eacute;ant cette confiance en soi incomparable.<br><br>Un indispensable pour une garde-robe f&eacute;minine et raffin&eacute;e qui vous permet de rester chic et tendance en toutes circonstances, r&eacute;v&eacute;lant votre go&ucirc;t pour la qualit&eacute; authentique et votre capacit&eacute; &agrave; allier confort et sophistication moderne.</p>
guid
stringhttps://dev.divasboudoir.com/fr/bas-opaques-grande-taille-60-deniers-hiver-materiaux-haute-qualite/slst0376.htm
highlights
string<ul> <li>Mat&eacute;riaux de haute qualit&eacute; pour sophistication durable</li> <li><strong>60 deniers opaques</strong> procurant douceur et chaleur optimales</li> <li>Texture soyeuse caressant d&eacute;licatement vos jambes</li> <li>Ajustement parfait mettant en valeur formes naturelles</li> <li>Id&eacute;aux toutes saisons avec protection hivernale renforc&eacute;e</li> <li>Soutien optimal &eacute;pousant <strong>courbes g&eacute;n&eacute;reuses</strong></li> <li>Confort in&eacute;galable pour garde-robe f&eacute;minine raffin&eacute;e</li> <li>Indispensable pour rester chic et tendance</li> </ul>
keypoint
string
keywords
stringbas opaques, 60 deniers, élégant, confort, thermique, hiver, soyeux, soutien, Diva's Boudoir, lingerie, féminité, grande taille
metas
Struct
description
stringBas opaques grande taille 60 deniers, matériaux haute qualité, texture soyeuse, ajustement parfait courbes généreuses. Protection hiver chic. Diva's Boudoir.
keywords
stringbas opaques, 60 deniers, élégant, confort, thermique, hiver, soyeux, soutien, Diva's Boudoir, lingerie, féminité, grande taille
title
stringBas Opaques Grande Taille 60 Deniers | Douceur Soyeuse | Diva's Boudoir
seotitle
stringBas Opaques Grande Taille 60 Deniers Hiver - Matériaux Haute Qualité
seouri
stringbas-opaques-grande-taille-60-deniers-hiver-materiaux-haute-qualite
specifications
string<ul> <li>Style : Bas opaques sophistication hivernale</li> <li>Deniers : 60 deniers chaleur et protection optimales</li> <li>Mat&eacute;riaux : Haute qualit&eacute; pour durabilit&eacute; premium</li> <li>Texture : Soyeuse pour douceur incomparable</li> <li>Ajustement : Parfait pour courbes g&eacute;n&eacute;reuses</li> <li>Saisons : Id&eacute;aux toutes saisons, sp&eacute;cialement hiver</li> <li>Soutien : Optimal pour confort in&eacute;galable</li> <li>Entretien : Lavage d&eacute;licat recommand&eacute;</li> </ul>
stylingtips
string<p>Ces <strong>bas opaques</strong> s'harmonisent parfaitement avec tous vos looks hivernaux gr&acirc;ce &agrave; leur sophistication intemporelle. Leur texture soyeuse se marie &eacute;l&eacute;gamment avec des bottes hautes pour cr&eacute;er une silhouette chic, ou avec des escarpins pour r&eacute;v&eacute;ler leur beaut&eacute; opaque. Id&eacute;aux sous des robes ou jupes courtes, ils apportent cette protection thermique tout en mettant en valeur vos formes naturelles.</p> <p>Leur ajustement parfait en fait l'indispensable de votre garde-robe f&eacute;minine, vous permettant de rester tendance m&ecirc;me par temps froid, r&eacute;v&eacute;lant votre capacit&eacute; &agrave; allier confort thermique et raffinement moderne avec sophistication assum&eacute;e.</p>
summary
string<p>Rehaussez votre allure avec ces bas opaques <strong>60 deniers</strong> confectionn&eacute;s avec des mat&eacute;riaux de haute qualit&eacute; qui procurent sensation de douceur et chaleur.</p> <p>Leur texture soyeuse et <strong>ajustement parfait</strong> mettent en valeur vos formes naturelles avec sophistication, id&eacute;aux pour toutes saisons et particuli&egrave;rement adapt&eacute;s aux rigueurs hivernales.</p>
title
stringBas Opaques 60 Deniers Hiver - Douceur Soyeuse et Chaleur Sophistiquée
usageinstructions
string
it
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p><span>Realizzate con materiali di alta qualità, queste calze coprenti 60 Den offrono un comfort ineguagliabile e un sostegno ottimale, accentuando con eleganza le vostre curve naturali. </span></p> <p><span>eleganti in ogni stagione, sono particolarmente adatte ai rigori dell'inverno. </span></p> <p><span>La loro consistenza setosa e la vestibilità slim vi renderanno chic e alla moda, proteggendovi al tempo stesso dal freddo. </span></p> <p><span>Abbinateli a un reggicalze per un look ancora più sofisticato che valorizzerà ancora di più le vostre gambe. </span></p>
guid
stringhttps://dev.divasboudoir.com/it/calze-coprenti-di-grande-taglia-nero/slst0376.htm
highlights
string<ul> <li>Materiali di alta qualità per una raffinatezza duratura</li> <li>tessuto<strong>opaco da 60 denari</strong> per una morbidezza e un calore ottimali</li> <li>La texture setosa accarezza delicatamente le gambe</li> <li>La perfetta vestibilità esalta le vostre forme naturali</li> <li>Ideale per tutte le stagioni con una protezione invernale extra</li> <li>Calze ottimale per <strong>curve generose</strong></li> <li>Comfort imbattibile per un guardaroba femminile raffinato</li> <li>Indispensabile per essere sempre chic e alla moda</li> </ul>
keypoint
string
keywords
stringcalze coprenti, 60 denari, eleganti, comfort, termiche, invernali, setose, calze, Diva's Boudoir, lingerie, femminilità, taglia grande
metas
Struct
description
stringScoprite le nostre calze Black60 in microfibra opaca ed elasticizzata. Un lusso accessibile per donne alte e formose. Chic tutto l'anno, perfette per l'inverno. È richiesto il reggicalze.
keywords
stringcalze coprenti, 60 denari, eleganti, comfort, termiche, invernali, setose, calze, Diva's Boudoir, lingerie, femminilità, taglia grande
title
stringDiva's Boudoir : Calze nere Luxurious60 per donne rotonde
seotitle
stringCalze coprenti di grande taglia
seouri
stringcalze-coprenti-di-grande-taglia-nero
specifications
string<ul> <li>Stile: calze coprenti per una raffinatezza invernale</li> <li>Denari: 60 denari per un calore e una protezione ottimali</li> <li>Materiali : Alta qualità per una durata superiore</li> <li>Texture : setosa per una morbidezza incomparabile</li> <li>Vestibilità : Perfetta per le curve generose: Perfetta per le curve generose</li> <li>Stagioni : Ideale per tutte le stagioni, soprattutto per l'inverno</li> <li>Calze : Ottimale per un comfort insuperabile</li> <li>Cura : Si consiglia un lavaggio delicato</li> </ul>
stylingtips
string<p>Queste <strong>calze coprenti</strong> sono l'abbinamento perfetto per tutti i vostri look invernali, grazie alla loro raffinatezza senza tempo. La loro consistenza setosa si abbina elegantemente agli stivali alti per creare una silhouette chic, o alle décolleté per rivelare la loro bellezza opaca. Ideali sotto abiti o gonne corte, offrono una protezione termica e mettono in risalto le vostre curve naturali.</p> <p>La loro perfetta vestibilità li rende un must-have del vostro guardaroba femminile, per essere sempre alla moda anche nelle stagioni più fredde, rivelando la vostra capacità di combinare il comfort termico con la raffinatezza moderna.</p>
summary
stringUn pezzo raro, soprattutto in dimensioni così belle, che amerete per tutta la stagione.
title
stringCalze 60 Den Opache
usageinstructions
string
nl
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p><span>Deze ondoorzichtige 60 Den kousen zijn gemaakt van hoogwaardige materialen en bieden ongeëvenaard comfort en optimale ondersteuning, terwijl ze je natuurlijke rondingen elegant accentueren. </span></p> <p><span>ze zijn elegant in elk seizoen en bijzonder geschikt voor de strenge winter. </span></p> <p><span>De zijdeachtige textuur en slanke pasvorm houden je chic en trendy, terwijl ze je beschermen tegen de kou. </span></p> <p><span>Combineer ze met een jarretelgordel voor een nog geraffineerdere look die je benen nog meer tot hun recht laat komen. </span></p>
guid
stringhttps://dev.divasboudoir.com/nl/grote-maat-ondoorzichtige-kousen-zwart/slst0376.htm
highlights
string<ul> <li>Hoogwaardige materialen voor blijvend raffinement</li> <li><strong>60 denier ondoorzichtige</strong> stof voor optimale zachtheid en warmte</li> <li>Zijdeachtige textuur streelt zachtjes je benen</li> <li>Perfecte pasvorm verbetert je natuurlijke vorm</li> <li>Ideaal voor alle seizoenen met extra winterbescherming</li> <li>Optimale <strong>bh</strong> voor <strong>royale rondingen</strong></li> <li>Onovertroffen comfort voor verfijnde damesgarderobes</li> <li>Onmisbaar om chic en trendy te blijven</li> </ul>
keypoint
string
keywords
stringondoorzichtige kousen, 60 denier, elegant, comfort, thermisch, winter, zijdeachtig, bh, Diva's Boudoir, lingerie, vrouwelijkheid, grote maat
metas
Struct
description
stringOntdek onze black60 kousen van ondoorzichtige, elastische microvezel. Betaalbare luxe voor lange, ronde vrouwen. Chic het hele jaar door, perfect voor de winter. Jarretelgordel vereist.
keywords
stringondoorzichtige kousen, 60 denier, elegant, comfort, thermisch, winter, zijdeachtig, bh, Diva's Boudoir, lingerie, vrouwelijkheid, grote maat
title
stringDiva's Boudoir : Luxe60 zwarte kousen voor ronde vrouwen
seotitle
stringGrote maat ondoorzichtige kousen
seouri
stringgrote-maat-ondoorzichtige-kousen-zwart
specifications
string<ul> <li>Stijl: Ondoorzichtige kousen voor winterse verfijning</li> <li>Denier: 60 denier voor optimale warmte en bescherming</li> <li>Materialen : Hoge kwaliteit voor duurzaamheid</li> <li>Textuur : Zijdeachtig voor onvergelijkbare zachtheid</li> <li>Pasvorm : Perfect voor royale rondingen</li> <li>Seizoenen : Ideaal voor alle seizoenen, vooral de winter</li> <li>Bh: Optimaal voor onovertroffen comfort</li> <li>Onderhoud: Fijne was aanbevolen</li> </ul>
stylingtips
string<p>Deze <strong>ondoorzichtige kousen</strong> passen perfect bij al je winterse looks dankzij hun tijdloze verfijning. Hun zijdeachtige textuur combineert elegant met hoge laarzen om een chique silhouet te creëren, of met pumps om hun ondoorzichtige schoonheid te onthullen. Ze zijn ideaal voor onder jurken of korte rokjes en bieden die thermische bescherming terwijl ze je natuurlijke rondingen accentueren.</p> <p>Door hun perfecte pasvorm zijn ze een must-have voor je damesgarderobe. Ze houden je zelfs bij het koudste weer trendy en laten zien dat je thermisch comfort kunt combineren met moderne verfijning.</p>
summary
stringEen zeldzaam stuk, vooral in zulke mooie maten, waar je het hele seizoen van zult houden.
title
stringKousen 60 Den Opaak
usageinstructions
string
pt
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p><span>Fabricadas com materiais de alta qualidade, estas meias opacas 60 Den oferecem um conforto inigualável e um apoio ótimo, acentuando elegantemente as suas curvas naturais. </span></p> <p><span>elegantes em qualquer estação, são particularmente adequadas para o rigor do inverno. </span></p> <p><span>A sua textura sedosa e o seu ajuste fino vão mantê-la chique e na moda, enquanto a protegem do frio. </span></p> <p><span>Combine-as com um cinto de ligas para um look ainda mais sofisticado que irá realçar ainda mais as suas pernas. </span></p>
guid
stringhttps://dev.divasboudoir.com/pt/meias-opacas-de-tamanho-grande-preto/slst0376.htm
highlights
string<ul> <li>Materiais de alta qualidade para uma sofisticação duradoura</li> <li>tecido<strong>opaco de 60 deniers</strong> para uma suavidade e um calor óptimos</li> <li>A textura sedosa acaricia suavemente as suas pernas</li> <li>O ajuste perfeito realça a sua forma natural</li> <li>Ideal para todas as estações com proteção extra no inverno</li> <li>Apoio ótimo para <strong>curvas generosas</strong></li> <li>Conforto imbatível para um guarda-roupa de mulher requintado</li> <li>Indispensável para se manter chique e na moda</li> </ul>
keypoint
string
keywords
stringmeias opacas, 60 denier, elegante, conforto, térmicas, inverno, sedosas, suporte, Diva's Boudoir, lingerie, feminilidade, tamanho grande
metas
Struct
description
stringDescubra as nossas meias black60 em microfibra opaca e elástica. Um luxo económico para as mulheres altas e com curvas. Chiques durante todo o ano, perfeitas para o inverno. Necessário cinto de ligas.
keywords
stringmeias opacas, 60 denier, elegante, conforto, térmicas, inverno, sedosas, suporte, Diva's Boudoir, lingerie, feminilidade, tamanho grande
title
stringBoudoir de Diva : Meias de ligas pretas Luxurious60 para mulheres redondas
seotitle
stringMeias opacas de tamanho grande
seouri
stringmeias-opacas-de-tamanho-grande-preto
specifications
string<ul> <li>Estilo : Meias opacas para uma sofisticação invernal</li> <li>Denier: 60 denier para um calor e uma proteção óptimos</li> <li>Materiais : De alta qualidade para uma durabilidade de primeira qualidade</li> <li>Textura : Sedosa para uma suavidade incomparável</li> <li>Ajuste : Perfeito para curvas generosas: Perfeito para curvas generosas</li> <li>Estações : Ideal para todas as estações, especialmente o inverno</li> <li>Apoio: Ótimo para um conforto inigualável</li> <li>Cuidados : Recomenda-se uma lavagem delicada</li> </ul>
stylingtips
string<p>Estas <strong>meias opacas</strong> são a combinação perfeita para todos os seus looks de inverno, graças à sua sofisticação intemporal. A sua textura sedosa combina elegantemente com botas altas para criar uma silhueta chique, ou com sapatos de salto alto para revelar a sua beleza opaca. Ideais por baixo de vestidos ou saias curtas, proporcionam essa proteção térmica ao mesmo tempo que realçam as suas curvas naturais.</p> <p>O seu ajuste perfeito torna-as imprescindíveis no seu guarda-roupa de mulher, mantendo-a na moda mesmo no tempo mais frio, revelando a sua capacidade de combinar conforto térmico com sofisticação moderna.</p>
summary
stringUma peça rara, especialmente em tamanhos tão bonitos, que vai adorar durante toda a estação.
title
stringMeias 60 Den Opaques
usageinstructions
string
fetishboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
latexboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
legsboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Diese blickdichten 60 Den Strümpfe sind aus hochwertigen Materialien gefertigt und bieten außergewöhnlichen Tragekomfort und optimalen BH, während sie Ihre natürlichen Formen elegant betonen.</p> <p>Sie sind das ganze Jahr über elegant und besonders geeignet, um den harten Winter zu überstehen.</p> <p>Ihre seidige Textur und die perfekte Passform sorgen dafür, dass Sie schick und modisch aussehen und sich gleichzeitig vor der Kälte schützen.</p>
highlights
string<ul> <li>eleganz und optimaler Komfort für das tägliche Wohlbefinden</li> <li><strong>Hochwertige Materialien</strong> garantieren außergewöhnliche Haltbarkeit</li> <li>blickdichte<strong>60 Denier</strong> für Schutz und zeitlosen Stil</li> <li>Unvergleichliches Wohlgefühl den ganzen Tag lang</li> <li>Seidige Textur umschmeichelt sanft Ihre Beine</li> <li>Perfekte Passform, die <strong>natürliche Formen</strong> hervorhebt</li> <li>Perfekt für alle Jahreszeiten mit erhöhtem Winterschutz</li> <li>Optimaler BH für jede Körperform</li> </ul>
keypoint
string
keywords
stringblickdichte Strümpfe, große Größe, 60 Denier, Komfort, Winter, Unterstützung, elegant, seidig, Leg's Boudoir, geformte Beine, alle Größen
metas
Struct
description
stringEntdecken Sie unsere blickdichten Strümpfe 60 Den: außergewöhnlicher Komfort und zeitlose Eleganz. Hochwertige Materialien für optimalen BH. Perfekt im Winter und im Sommer. Chic garantiert!
keywords
stringblickdichte Strümpfe, große Größe, 60 Denier, Komfort, Winter, Unterstützung, elegant, seidig, Leg's Boudoir, geformte Beine, alle Größen
title
stringOpake Strümpfe 60 Den - Kostenlose Express-Lieferung
seotitle
stringStrümpfe große Größe blickdicht 60 Den
seouri
stringstrumpfe-grosse-grosse-blickdicht-60-den-schwarz
specifications
string<div style="text-align: justify;"></div>
stylingtips
string<p>Diese blickdichten Strümpfe passen dank ihrer <strong> zeitlosen Eleganz</strong> perfekt zu all Ihren Looks. Ihre seidige Textur lässt sich elegant mit hohen Stiefeln kombinieren, um eine schicke Silhouette zu kreieren, oder mit Pumps, um ihre blickdichte Schönheit zu enthüllen.</p> <p><strong>Ideal unter Kleidern oder Röcken</strong>, bieten sie diesen Wärmeschutz und betonen gleichzeitig Ihre natürlichen Formen auf stilvolle Weise. Ihre perfekte Passform macht sie zu einem unverzichtbaren Bestandteil Ihrer Garderobe, mit dem Sie auch bei kaltem Wetter modisch aussehen und Ihre Fähigkeit unter Beweis stellen, Wärmekomfort und moderne Raffinesse mit Eleganz zu verbinden, die für alle Körperformen zugänglich ist.</p>
summary
stringEin seltenes Stück, vor allem in so schönen Größen, das Sie gerne zu all Ihren Outfits tragen werden.
title
stringOpake Strümpfe 60 Denier
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Αυτές οι αδιαφανείς κάλτσες 60 Den είναι κατασκευασμένες από υλικά υψηλής ποιότητας, προσφέροντας εξαιρετική άνεση και βέλτιστη στήριξη, ενώ παράλληλα ενισχύουν κομψά το φυσικό σας σχήμα.</p> <p>Φαίνονται υπέροχες όλο το χρόνο και είναι ιδιαίτερα κατάλληλες για τις δύσκολες συνθήκες του χειμώνα.</p> <p>Η μεταξένια υφή τους και η τέλεια εφαρμογή τους θα σας διατηρήσουν κομψή και μοντέρνα, ενώ παράλληλα θα σας προστατεύουν από το κρύο.</p>
highlights
string<ul> <li>κομψότητα και βέλτιστη άνεση για καθημερινή ευεξία</li> <li><strong>Υλικά υψηλής ποιότητας</strong> για εξαιρετική ανθεκτικότητα</li> <li>αδιαφανή<strong>60 denier</strong> για προστασία και διαχρονικό στυλ</li> <li>Ασυναγώνιστη αίσθηση ευεξίας όλη την ημέρα</li> <li>Μεταξένια υφή που χαϊδεύει απαλά τα πόδια σας</li> <li>Η τέλεια εφαρμογή ενισχύει <strong>το φυσικό σας σχήμα</strong></li> <li>Ιδανικό για όλες τις εποχές με επιπλέον προστασία το χειμώνα</li> <li>Βέλτιστη στήριξη για όλα τα σχήματα σώματος</li> </ul>
keypoint
string
keywords
stringαδιαφανείς κάλτσες, μεγάλες, 60 denier, άνεση, χειμώνας, υποστήριξη, κομψές, μεταξένιες, Leg's Boudoir, καλλίγραμμα πόδια, όλα τα μεγέθη
metas
Struct
description
stringΑνακαλύψτε τις αδιαφανείς κάλτσες 60 Den: εξαιρετική άνεση και διαχρονική κομψότητα. Υλικά υψηλής ποιότητας για βέλτιστη στήριξη. Ιδανικές για χειμώνα και καλοκαίρι. Εγγυημένη κομψότητα!
keywords
stringαδιαφανείς κάλτσες, μεγάλες, 60 denier, άνεση, χειμώνας, υποστήριξη, κομψές, μεταξένιες, Leg's Boudoir, καλλίγραμμα πόδια, όλα τα μεγέθη
title
string60 Den αδιαφανείς κάλτσες - Δωρεάν υπηρεσία express delivery
seotitle
stringΜεγάλο μέγεθος αδιαφανείς κάλτσες 60 Den
seouri
stringmegalo-megethos-adiafaneis-kaltses-60-den-mayro
specifications
string<div style="text-align: justify;"></div>
stylingtips
string<p>Αυτές οι αδιαφανείς κάλτσες είναι μια <strong> διαχρονικά κομψή</strong> προσθήκη σε κάθε εμφάνιση. Η μεταξένια υφή τους συνδυάζεται κομψά με ψηλές μπότες για να δημιουργήσει μια κομψή σιλουέτα ή με γόβες για να αποκαλύψει την αδιαφανή ομορφιά τους.</p> <p><strong>Ιδανικές κάτω από φορέματα ή φούστες</strong>, παρέχουν θερμική προστασία ενώ αναδεικνύουν τις φυσικές σας καμπύλες με στυλ. Η τέλεια εφαρμογή τους τα καθιστά απαραίτητα για την γκαρνταρόμπα σας, επιτρέποντάς σας να παραμείνετε στην τάση ακόμη και με κρύο καιρό, αποκαλύπτοντας την ικανότητά σας να συνδυάζετε τη θερμική άνεση και τη σύγχρονη φινέτσα με κομψότητα προσιτή σε όλους τους σωματότυπους.</p>
summary
stringΈνα σπάνιο κομμάτι, ειδικά σε τόσο όμορφα μεγέθη, που θα σας αρέσει να φοράτε με όλα σας τα ρούχα.
title
string60 Denier αδιαφανείς κάλτσες
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>These 60 Den opaque stockings are made from high-quality materials, offering exceptional comfort and optimum bra, while elegantly enhancing your natural curves.</p> <p>They're elegant all year round, especially suited to face the rigors of winter.</p> <p>Their silky texture and perfect fit will keep you chic and fashionable, while protecting you from the cold.</p>
highlights
string<ul> <li>elegance and optimum comfort for everyday well-being</li> <li><strong>High-quality materials</strong> for exceptional durability</li> <li><strong>60 denier</strong> opaques for protection and timeless style</li> <li>Unbeatable feeling of well-being all day long</li> <li>Silky texture gently caresses your legs</li> <li>Perfect fit enhances <strong>your natural shape</strong></li> <li>All-season perfection with reinforced winter protection</li> <li>Optimum bra for every body type</li> </ul>
keypoint
string
keywords
stringopaque stockings, plus size, 60 denier, comfort, winter, bra, elegant, silky, Leg's Boudoir, shapely legs, all sizes
metas
Struct
description
stringDiscover our 60 Den opaque stockings: exceptional comfort and timeless elegance. High-quality materials for optimum bra. Perfect for winter and summer. Chic guaranteed!
keywords
stringopaque stockings, plus size, 60 denier, comfort, winter, bra, elegant, silky, Leg's Boudoir, shapely legs, all sizes
title
string60 Den opaque stockings - Free express delivery
seotitle
stringOpaque plus size stockings 60 Den
seouri
stringopaque-plus-size-stockings-60-den-black
specifications
string<div style="text-align: justify;"></div>
stylingtips
string<p>These opaque stockings blend perfectly with all your looks thanks to their <strong> timeless elegance</strong>. Their silky texture pairs elegantly with tall boots to create a chic silhouette, or with pumps to reveal their opaque beauty.</p> <p><strong>Ideal under dresses or skirts</strong>, they provide that thermal protection while enhancing your natural curves with style. Their perfect fit makes them a wardrobe essential, allowing you to stay on trend even in cold weather, revealing your ability to combine thermal comfort and modern refinement with elegance accessible to all body types.</p>
summary
stringA rare piece, especially in such beautiful sizes, that you'll love wearing with all your outfits.
title
string60 Denier Opaque Stockings
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Estas medias opacas 60 Den están confeccionadas con materiales de alta calidad y ofrecen una comodidad excepcional y un sujetador óptimo, al tiempo que realzan con elegancia su silueta natural.</p> <p>Perfectas para todo el año, son especialmente adecuadas para los rigores del invierno.</p> <p>Su textura sedosa y su ajuste perfecto le permitirán estar a la moda y protegida del frío.</p>
highlights
string<ul> <li>elegancia y comodidad óptimas para el bienestar diario</li> <li><strong>Materiales de alta calidad</strong> para una durabilidad excepcional</li> <li>opacos<strong>de 60 deniers</strong> para una protección y un estilo atemporales</li> <li>Inmejorable sensación de bienestar durante todo el día</li> <li>Textura sedosa que acaricia suavemente las piernas</li> <li>El ajuste perfecto realza <strong>su forma natural</strong></li> <li>Perfecto para todas las estaciones con protección extra en invierno</li> <li>Sujeción óptima para todas las formas del cuerpo</li> </ul>
keypoint
string
keywords
stringmedias opacas, talla grande, 60 deniers, comodidad, invierno, sujetador, elegante, sedoso, Leg's Boudoir, piernas torneadas, todas las tallas
metas
Struct
description
stringDescubra nuestras medias opacas 60 Den: comodidad excepcional y elegancia atemporal. Materiales de alta calidad para un sujetador óptimo. Perfectas tanto en invierno como en verano. ¡Chic garantizado!
keywords
stringmedias opacas, talla grande, 60 deniers, comodidad, invierno, sujetador, elegante, sedoso, Leg's Boudoir, piernas torneadas, todas las tallas
title
string60 Den medias opacas - Envío exprés gratuito
seotitle
stringMedias opacas de talla grande 60 Den
seouri
stringmedias-opacas-de-talla-grande-60-den-negro
specifications
string<div style="text-align: justify;"></div>
stylingtips
string<p>Estas medias opacas son un complemento <strong> elegante y atemporal</strong> para cualquier look. Su textura sedosa combina con elegancia con botas altas para crear una silueta chic, o con zapatos de salón para revelar su belleza opaca.</p> <p><strong>Ideales para llevar debajo de vestidos o faldas</strong>, ofrecen protección térmica y permiten lucir con estilo las curvas naturales. Su ajuste perfecto las convierte en un básico de vestuario, que le permitirá seguir a la moda incluso cuando haga frío, revelando su capacidad para combinar el confort térmico y el refinamiento moderno con una elegancia accesible a todos los tipos de cuerpo.</p>
summary
stringUna pieza rara, sobre todo en tallas tan bonitas, que te encantará llevar con todos tus conjuntos.
title
stringMedias opacas de 60 deniers
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p class="text-base">Ces <strong>bas opaques 60 deniers</strong> incarnent l'art de l'&eacute;l&eacute;gance moderne alli&eacute;e au confort optimal. Fabriqu&eacute;s avec des mat&eacute;riaux de haute qualit&eacute;, ils r&eacute;pondent parfaitement aux attentes de style et de bien-&ecirc;tre pour r&eacute;v&eacute;ler votre beaut&eacute; naturelle tout en vous prot&eacute;geant efficacement du froid.<br><br>L'&eacute;l&eacute;gance et le confort constituent l'essence m&ecirc;me de ces bas, cr&eacute;ant cette harmonie parfaite entre esth&eacute;tique raffin&eacute;e et sensation de bien-&ecirc;tre in&eacute;galable. Cette philosophie du style accessible vous accompagne avec sophistication dans toutes vos activit&eacute;s quotidiennes.<br><br>Les <strong>mat&eacute;riaux de haute qualit&eacute;</strong> t&eacute;moignent de l'engagement pour l'excellence technique. Cette conception premium garantit une durabilit&eacute; exceptionnelle qui r&eacute;siste aux lavages r&eacute;p&eacute;t&eacute;s tout en conservant cette douceur incomparable qui caract&eacute;rise le v&eacute;ritable confort.<br><br>La <strong>densit&eacute; 60 deniers</strong> offre cette opacit&eacute; parfaite qui procure protection thermique et style intemporel. Cette &eacute;paisseur id&eacute;alement &eacute;tudi&eacute;e cr&eacute;e un &eacute;quilibre harmonieux entre confort hivernal et esth&eacute;tique raffin&eacute;e, sublimant naturellement la beaut&eacute; de vos jambes.<br><br>La texture soyeuse r&eacute;volutionne l'exp&eacute;rience tactile en apportant cette douceur luxueuse qui transforme chaque mouvement en moment de bien-&ecirc;tre. Cette finition d&eacute;licate &eacute;pouse parfaitement toutes les morphologies, cr&eacute;ant cette sensation agr&eacute;able qui vous accompagne du matin au soir.<br><br>L'ajustement parfait t&eacute;moigne de l'attention port&eacute;e &agrave; la <strong>diversit&eacute; des silhouettes</strong>. Ces bas mettent en valeur vos <strong>formes naturelles</strong> avec style, r&eacute;v&eacute;lant la beaut&eacute; unique de chaque morphologie avec une &eacute;l&eacute;gance moderne qui transcende les standards.<br><br><strong>Parfaits pour toutes les saisons</strong>, ils sont particuli&egrave;rement adapt&eacute;s pour affronter les rigueurs de l'hiver. Cette polyvalence saisonni&egrave;re vous permet de maintenir votre style chic et tendance tout au long de l'ann&eacute;e, en apportant cette protection thermique suppl&eacute;mentaire lors des p&eacute;riodes froides.<br><br>Con&ccedil;us pour un confort optimal, ils offrent ce soutien tout au long de la journ&eacute;e qui s'adapte harmonieusement &agrave; toutes les morphologies. Cette technologie de maintien r&eacute;v&egrave;le votre confiance naturelle sans contrainte, cr&eacute;ant cette assurance qui vous d&eacute;finit.<br><br>Sp&eacute;cialement pens&eacute;s pour s'adapter &agrave; toutes les silhouettes, ils subliment vos jambes et vous font sentir belle et confiante, r&eacute;v&eacute;lant votre go&ucirc;t pour la qualit&eacute; authentique et votre capacit&eacute; &agrave; allier confort et &eacute;l&eacute;gance moderne.</p>
highlights
string<ul> <li>&Eacute;l&eacute;gance et confort optimal pour bien-&ecirc;tre quotidien</li> <li><strong>Mat&eacute;riaux de haute qualit&eacute;</strong> garantissant durabilit&eacute; exceptionnelle</li> <li><strong>60 deniers</strong> opaques pour protection et style intemporel</li> <li>Sensation de bien-&ecirc;tre in&eacute;galable tout au long de la journ&eacute;e</li> <li>Texture soyeuse caressant d&eacute;licatement vos jambes</li> <li>Ajustement parfait mettant en valeur <strong>formes naturelles</strong></li> <li>Parfaits toutes saisons avec protection hivernale renforc&eacute;e</li> <li>Soutien optimal s'adaptant &agrave; toutes les morphologies</li> </ul>
keypoint
string
keywords
stringbas opaques, grande taille, 60 deniers, confort, hiver, soutien, élégant, soyeux, Leg's Boudoir, jambes galbées, toutes tailles
metas
Struct
description
stringBas opaques 60 deniers élégance, matériaux haute qualité, texture soyeuse, ajustement parfait toutes morphologies. Confort optimal hiver. Leg's Boudoir.
keywords
stringbas opaques, grande taille, 60 deniers, confort, hiver, soutien, élégant, soyeux, Leg's Boudoir, jambes galbées, toutes tailles
title
stringBas Opaques 60 Deniers Élégance | Confort Optimal Hiver | Leg's Boudoir
seotitle
stringBas Opaques 60 Deniers Élégance Hiver - Matériaux Haute Qualité Confort
seouri
stringbas-opaques-60-deniers-elegance-hiver-materiaux-haute-qualite-confort
specifications
string<div style="text-align: justify;"> <ul> <li>Style : Bas opaques &eacute;l&eacute;gance intemporelle</li> <li>Deniers : 60 deniers protection et confort optimal</li> <li>Mat&eacute;riaux : Haute qualit&eacute; pour durabilit&eacute; premium</li> <li>Texture : Soyeuse pour bien-&ecirc;tre in&eacute;galable</li> <li>Ajustement : Parfait pour toutes les morphologies</li> <li>Saisons : Id&eacute;aux toutes saisons, sp&eacute;cialement hiver</li> <li>Soutien : Optimal pour confort quotidien</li> <li>Entretien : Lavage d&eacute;licat recommand&eacute;</li> </ul> </div>
stylingtips
string<p>Ces bas opaques s'harmonisent parfaitement avec tous vos looks gr&acirc;ce &agrave; leur <strong>&eacute;l&eacute;gance intemporelle</strong>. Leur texture soyeuse se marie &eacute;l&eacute;gamment avec des bottes hautes pour cr&eacute;er une silhouette chic, ou avec des escarpins pour r&eacute;v&eacute;ler leur beaut&eacute; opaque.</p> <p><strong>Id&eacute;aux sous des robes ou jupes</strong>, ils apportent cette protection thermique tout en mettant en valeur vos formes naturelles avec style. Leur ajustement parfait en fait l'indispensable de votre garde-robe, vous permettant de rester tendance m&ecirc;me par temps froid, r&eacute;v&eacute;lant votre capacit&eacute; &agrave; allier confort thermique et raffinement moderne avec &eacute;l&eacute;gance accessible &agrave; toutes les morphologies.</p>
summary
string<p>Optez pour l'&eacute;l&eacute;gance et le confort avec ces bas opaques <strong>60 deniers </strong>fabriqu&eacute;s avec des mat&eacute;riaux de haute qualit&eacute;.</p> <p>Ils offrent une sensation de bien-&ecirc;tre in&eacute;galable tout en <strong>mettant en valeur vos formes naturelles avec style.</strong></p> <p>Parfaits pour toutes saisons et sp&eacute;cialement adapt&eacute;s aux rigueurs hivernales, leur texture soyeuse et ajustement parfait vous permettent de rester chic et tendance.</p>
title
stringBas Opaques 60 Deniers Élégance - Confort Optimal et Style Intemporel
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Queste calze coprenti 60 Den sono realizzate con materiali di alta qualità e offrono un comfort eccezionale e un calze ottimale, valorizzando con eleganza la vostra forma naturale.</p> <p>Sono belle tutto l'anno e particolarmente adatte ai rigori dell'inverno.</p> <p>La loro consistenza setosa e la perfetta vestibilità vi renderanno chic e alla moda, proteggendovi al tempo stesso dal freddo.</p>
highlights
string<ul> <li>eleganza e comfort ottimale per il benessere quotidiano</li> <li><strong>Materiali di alta qualità</strong> per una durata eccezionale</li> <li>opachi<strong>da 60 denari</strong> per una protezione e uno stile senza tempo</li> <li>Sensazione di benessere imbattibile per tutto il giorno</li> <li>La texture setosa accarezza delicatamente le gambe</li> <li>La perfetta vestibilità esalta <strong>le vostre forme naturali</strong></li> <li>Perfetti per tutte le stagioni con una protezione invernale extra</li> <li>Calze ottimale per tutte le forme del corpo</li> </ul>
keypoint
string
keywords
stringcalze coprenti, taglia grande, 60 denari, comfort, inverno, calze, eleganti, setose, Leg's Boudoir, gambe formose, tutte le taglie
metas
Struct
description
stringScoprite le nostre calze coprenti 60 Den: comfort eccezionale ed eleganza senza tempo. Materiali di alta qualità per un calze ottimale. Perfette in inverno e in estate. Chic garantito!
keywords
stringcalze coprenti, taglia grande, 60 denari, comfort, inverno, calze, eleganti, setose, Leg's Boudoir, gambe formose, tutte le taglie
title
string60 Den calze coprenti - Consegna rapida gratuita
seotitle
stringCalze coprenti di grande taglia 60 Den
seouri
stringcalze-coprenti-di-grande-taglia-60-den-nero
specifications
string<div style="text-align: justify;"></div>
stylingtips
string<p>Queste calze coprenti sono un'aggiunta <strong> elegante e senza tempo</strong> a qualsiasi look. La loro consistenza setosa si abbina elegantemente agli stivali alti per creare una silhouette chic, o alle décolleté per rivelare la loro bellezza opaca.</p> <p><strong>Ideali sotto abiti o gonne</strong>, offrono protezione termica e al tempo stesso mettono in mostra le vostre curve naturali con stile. La loro perfetta vestibilità li rende un capo essenziale del guardaroba, che vi permette di essere sempre alla moda anche nella stagione fredda, rivelando la vostra capacità di combinare comfort termico e raffinatezza moderna con un'eleganza accessibile a tutti i tipi di corpo.</p>
summary
stringUn pezzo raro, soprattutto in dimensioni così belle, che vi piacerà indossare con tutti i vostri outfit.
title
stringCalze coprenti 60 denari
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Deze 60 Den ondoorzichtige kousen zijn gemaakt van hoogwaardige materialen en bieden uitzonderlijk comfort en optimale bh, terwijl ze je natuurlijke vorm elegant accentueren.</p> <p>Ze zien er het hele jaar door geweldig uit en zijn bijzonder geschikt voor de strenge winter.</p> <p>De zijdeachtige textuur en perfecte pasvorm houden je chic en modieus, terwijl ze je beschermen tegen de kou.</p>
highlights
string<ul> <li>elegantie en optimaal comfort voor dagelijks welzijn</li> <li><strong>Hoogwaardige materialen</strong> voor uitzonderlijke duurzaamheid</li> <li><strong>60 denier</strong> opaak voor bescherming en tijdloze stijl</li> <li>De hele dag door een onovertroffen gevoel van welzijn</li> <li>Zijdezachte textuur streelt zacht je benen</li> <li>Perfecte pasvorm verbetert <strong>je natuurlijke vorm</strong></li> <li>Perfect voor alle seizoenen met extra winterbescherming</li> <li>Optimale bh voor alle lichaamsvormen</li> </ul>
keypoint
string
keywords
stringondoorzichtige kousen, grote maat, 60 denier, comfort, winter, bh, elegant, zijdeachtig, Leg's Boudoir, mooie benen, alle maten
metas
Struct
description
stringOntdek onze 60 Den ondoorzichtige kousen: uitzonderlijk comfort en tijdloze elegantie. Hoogwaardige materialen voor optimale bh. Perfect in winter en zomer. Chic gegarandeerd!
keywords
stringondoorzichtige kousen, grote maat, 60 denier, comfort, winter, bh, elegant, zijdeachtig, Leg's Boudoir, mooie benen, alle maten
title
string60 Den ondoorzichtige kousen - Gratis expreslevering
seotitle
stringGrote maat ondoorzichtige kousen 60 Den
seouri
stringgrote-maat-ondoorzichtige-kousen-60-den-zwart
specifications
string<div style="text-align: justify;"></div>
stylingtips
string<p>Deze ondoorzichtige kousen zijn een <strong> tijdloos elegante</strong> toevoeging aan elke look. Hun zijdeachtige textuur combineert elegant met hoge laarzen om een chique silhouet te creëren, of met pumps om hun ondoorzichtige schoonheid te onthullen.</p> <p>Ze zijn<strong>ideaal voor onder jurken of rokken</strong> en bieden thermische bescherming terwijl ze je natuurlijke rondingen in stijl laten zien. Door hun perfecte pasvorm zijn ze onmisbaar in je garderobe, zodat je zelfs bij koud weer trendy blijft en je thermisch comfort en moderne verfijning kunt combineren met elegantie die voor elk lichaamstype toegankelijk is.</p>
summary
stringEen zeldzaam stuk, vooral in zulke mooie maten, dat je graag bij al je outfits zult dragen.
title
string60 Denier Opaque Kousen
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>Estas meias opacas 60 Den são fabricadas com materiais de alta qualidade, oferecendo um conforto excecional e um apoio ótimo, ao mesmo tempo que realçam elegantemente a sua forma natural.</p> <p>São óptimas durante todo o ano e particularmente adaptadas aos rigores do inverno.</p> <p>A sua textura sedosa e o seu ajuste perfeito vão mantê-la chique e na moda, ao mesmo tempo que a protegem do frio.</p>
highlights
string<ul> <li>elegância e conforto ideal para o bem-estar quotidiano</li> <li><strong>Materiais de alta qualidade</strong> para uma durabilidade excecional</li> <li>opacos<strong>de 60 denier</strong> para uma proteção e um estilo intemporal</li> <li>Sensação imbatível de bem-estar durante todo o dia</li> <li>A textura sedosa acaricia suavemente as suas pernas</li> <li>O ajuste perfeito realça <strong>a sua forma natural</strong></li> <li>Perfeita para todas as estações com proteção extra no inverno</li> <li>Suporte ótimo para todas as formas do corpo</li> </ul>
keypoint
string
keywords
stringmeias opacas, grandes, 60 denier, conforto, inverno, suporte, elegantes, sedosas, Leg's Boudoir, pernas torneadas, todos os tamanhos
metas
Struct
description
stringDescubra as nossas meias opacas 60 Den: conforto excecional e elegância intemporal. Materiais de alta qualidade para um apoio ótimo. Perfeitas no inverno e no verão. Chique garantido!
keywords
stringmeias opacas, grandes, 60 denier, conforto, inverno, suporte, elegantes, sedosas, Leg's Boudoir, pernas torneadas, todos os tamanhos
title
string60 meias opacas Den - Entrega expressa gratuita
seotitle
stringMeias opacas de tamanho grande 60 Den
seouri
stringmeias-opacas-de-tamanho-grande-60-den-preto
specifications
string<div style="text-align: justify;"></div>
stylingtips
string<p>Estas meias opacas são uma adição <strong> elegante e intemporal</strong> a qualquer visual. A sua textura sedosa combina elegantemente com botas altas para criar uma silhueta chique, ou com sapatos de salto alto para revelar a sua beleza opaca.</p> <p><strong>Ideais para usar por baixo de vestidos ou saias</strong>, proporcionam proteção térmica enquanto mostram as suas curvas naturais com estilo. O seu ajuste perfeito torna-as essenciais no guarda-roupa, permitindo-lhe manter-se na moda mesmo com tempo frio, revelando a sua capacidade de combinar o conforto térmico e o requinte moderno com uma elegância acessível a todos os tipos de corpo.</p>
summary
stringUma peça rara, sobretudo em tamanhos tão bonitos, que vai adorar usar com todos os seus conjuntos.
title
stringMeias opacas de 60 denier
usageinstructions
string
lustboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
smboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
name
string50136 Noir60
netweight
string
nextshipment
stringtomorrow
ordered
number5
orderidx
number0
origin
string
originalsize
string
packaging
string
productshipment
stringauto
productuid
string6BCF32BA-0872-461A-B189CD544CB925A7
promountil
string
rating
stringnone
recorduid
string6BCF32BA-0872-461A-B189CD544CB925A7
reference
stringSLST0376
related
string
reserved
string
returned
number0
returnsallowed
number1
section
stringlingerie
shipment
string4to6days
showbrand
number0
sizeinfos
Query
Template: /system/api/product/sizes.cfc:20
Execution Time: 1.83 ms
Record Count: 7
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,'1039,1040,1041,1042,1043,1044,1150') > 0
and product_variations.productuid = '6BCF32BA-0872-461A-B189CD544CB925A7'
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
110394intlsizeblack44-19999990wplusstocking4-M440-4210-1214-1642-4442-4440-4246-4842-4440-4249-55
210405intlsizeblack55-19999991wplusstocking5-L542-4412-1416-1844-4644-4642-4448-5044-4642-4456-62
310416intlsizeblack66-19999991wplusstocking6-XL646-4816-1820-2248-5048-5046-4852-5448-5046-4862-69
410427intlsizeblack77-19999991wplusstocking7-2XL748-5018-2022-2450-5250-5248-5054-5650-5248-5069-76
510438intlsizeblack88-19999990wplusstocking8-3XL850-5220-2224-2652-5452-5450-5256-5852-5450-5276-83
610449intlsizeblack99-19999990wplusstocking9-4XL952-5422-2426-2854-5654-5652-5458-6054-5652-5483-89
7115010intlsizeblack1010-19999990wplusstocking9-4XL1054-5624-2628-3056-5856-5854-5660-6254-5854-5689-96
sizeranges
stringplus
sizes
string1039,1040,1041,1042,1043,1044,1150
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: 10.5 ms
Record Count: 6
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 = '6BCF32BA-0872-461A-B189CD544CB925A7'
and product_variations.isactive = 1
and product_sizes.id_size = 1039
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 = '6BCF32BA-0872-461A-B189CD544CB925A7'
and product_variations.isactive = 1
and product_sizes.id_size = 1040
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 = '6BCF32BA-0872-461A-B189CD544CB925A7'
and product_variations.isactive = 1
and product_sizes.id_size = 1041
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 = '6BCF32BA-0872-461A-B189CD544CB925A7'
and product_variations.isactive = 1
and product_sizes.id_size = 1042
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 = '6BCF32BA-0872-461A-B189CD544CB925A7'
and product_variations.isactive = 1
and product_sizes.id_size = 1043
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 = '6BCF32BA-0872-461A-B189CD544CB925A7'
and product_variations.isactive = 1
and product_sizes.id_size = 1044
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 = '6BCF32BA-0872-461A-B189CD544CB925A7'
and product_variations.isactive = 1
and product_sizes.id_size = 1150
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
16BCF32BA-0872-461A-B189CD544CB925A7F870AB31-A083-476E-AB033C19B41A34B51039black#0000004-M440-4210-1214-1642-4442-4440-4246-4842-4440-42wstocking4intlsize20.79170STOCK01000-1000050136-10all
26BCF32BA-0872-461A-B189CD544CB925A788E1C271-C3D9-4C42-8BB20E2F47FFD3931040black#0000005-L542-4412-1416-1844-4644-4642-4448-5044-4642-44wstocking5intlsize20.79170STOCK01100-1020050136426027713290311all
36BCF32BA-0872-461A-B189CD544CB925A788D65C8C-9ED5-4BA5-AD63DC60C73557631041black#0000006-XL646-4816-1820-2248-5048-5046-4852-5448-5046-48wstocking6intlsize20.79170STOCK01100-1020050136426027713291011all
46BCF32BA-0872-461A-B189CD544CB925A7202E5B87-D3BF-4A40-9AC01785188214161042black#0000007-2XL748-5018-2022-2450-5250-5248-5054-5650-5248-50wstocking7intlsize20.79170STOCK01100-1020050136426027713292711all
56BCF32BA-0872-461A-B189CD544CB925A780731322-8F41-4DAD-85D0949DFF18DFDA1043black#0000008-3XL850-5220-2224-2652-5452-5450-5256-5852-5450-52wstocking8intlsize20.79170STOCK01000-10200501364260277134709-10all
66BCF32BA-0872-461A-B189CD544CB925A778BA2246-8C15-4D3E-93C8DDF873909E891044black#0000009-4XL952-5422-2426-2854-5654-5652-5458-6054-5652-54wstocking9intlsize20.79170STOCK01000-11300501364260277134716-10all
subcategory
stringstocking
supplier
number-1
supplierreference
string50136
tags
string
themes
string
totalvariations
string
type
stringdefault
unitprice
number20.7917
usageinstructions
stringstockings
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 22.4 ms
Record Count: 7
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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7'
and product_variations.isactive = 1
and product_sizes.id_size = 1039
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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7'
and product_variations.isactive = 1
and product_sizes.id_size = 1040
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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7'
and product_variations.isactive = 1
and product_sizes.id_size = 1041
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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7'
and product_variations.isactive = 1
and product_sizes.id_size = 1042
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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7'
and product_variations.isactive = 1
and product_sizes.id_size = 1043
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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7'
and product_variations.isactive = 1
and product_sizes.id_size = 1044
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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7'
and product_variations.isactive = 1
and product_sizes.id_size = 1150
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
1F870AB31-A083-476E-AB033C19B41A34B51039black#0000004-M440-4210-1214-1642-4442-4440-4246-4842-4440-42wstocking4intlsize20.79170STOCK01000-1000050136-10-10-12020.7917all
288E1C271-C3D9-4C42-8BB20E2F47FFD3931040black#0000005-L542-4412-1416-1844-4644-4642-4448-5044-4642-44wstocking5intlsize20.79170STOCK01100-1020050136426027713290311-11-12020.7917all
388D65C8C-9ED5-4BA5-AD63DC60C73557631041black#0000006-XL646-4816-1820-2248-5048-5046-4852-5448-5046-48wstocking6intlsize20.79170STOCK01100-1020050136426027713291011-11-12020.7917all
4202E5B87-D3BF-4A40-9AC01785188214161042black#0000007-2XL748-5018-2022-2450-5250-5248-5054-5650-5248-50wstocking7intlsize20.79170STOCK01100-1020050136426027713292711-11-12020.7917all
580731322-8F41-4DAD-85D0949DFF18DFDA1043black#0000008-3XL850-5220-2224-2652-5452-5450-5256-5852-5450-52wstocking8intlsize20.79170STOCK01000-10200501364260277134709-10-10-12020.7917all
678BA2246-8C15-4D3E-93C8DDF873909E891044black#0000009-4XL952-5422-2426-2854-5654-5652-5458-6054-5652-54wstocking9intlsize20.79170STOCK01000-11300501364260277134716-10-10-12020.7917all
778BA2246-8C15-4D3E-93C8DDF873909E891150black#0000009-4XL1054-5624-2628-3056-5856-5854-5660-6254-5854-56wstocking10intlsize20.79170STOCK01000-11300501364260277134716-10-10-12020.7917all
vatrate
number20
warehouse
string