Vedere le dimensioni
Calze arabescate
Doppio clic per ingrandire
SKU: SLST1609
Calze arabescate
FATTO IN
Stock:

Superbe calze arabescate, lusso ed eleganza con un tocco sexy.

Punti di forza

  • Arabeschi con scintille scintillanti
  • Bellissimo pizzo nero sulla parte superiore
  • Cucitura posteriore per un look sexy
  • Prodotto in Europa per garantire la qualità
  • Morbido e resistente allo stesso tempo
  • Si mantiene bene senza scivolare
  • Rivela la vostra bellezza naturale
  • Stile sexy ed elegante
Taglia:

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

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

Calze grandi arabescate

Descrizione del prodotto

Calze arabescate

Indossate con o senza reggicalze, completeranno qualsiasi abbigliamento.

Dettagli tecnici

  • Stile: Rivolis arabescato lucido
  • Modelli : Arabeschi con piccoli scintillii
  • Pizzo : Bellissimo top in pizzo nero
  • Cuciture : Dietro per un look sexy e vintage
  • Produzione : Europea per la qualità
  • Materiali : Morbidi e resistenti
  • Indossare: antiscivolo auto-leganti
  • Uso: Tutti i giorni e occasioni speciali

Dimensioni disponibili

Disponibile da 5-6 a 6-7

Colore disponibile

Nero

Guida alle taglie

Controllare la taglia giusta per voi

Internazionale
  • Coscia
  • Altezza
5-6
  • 60-67
  • 150-165
6-7
  • 67-75
  • 165-175

Istruzioni per la cura

  • Lavare a mano in acqua fredda per mantenere la lucentezza
  • Lavaggio delicato senza candeggina
  • Asciugare in piano lontano dalla luce diretta del sole
  • Non centrifugare per mantenere la forma
  • Maneggiare delicatamente per preservare gli arabeschi
  • Non stirare per mantenere l'effetto lucido

Consigli per l'uso

Infilate delicatamente queste calze, appoggiando il pizzo sulle cosce.

Si reggono da sole e abbracciano perfettamente le vostre forme. Queste calze rivelano la vostra bellezza con uno stile europeo che trasforma ogni abito in un'espressione della vostra femminilità.

Consigli di stile

Queste calze Rivolis sono perfette con i loro arabeschi lucidi che rivelano il vostro lato sexy.

Indossatele quando volete essere belle e sensuali. Gli arabeschi e le cuciture dietro di essi creano un fascino pazzesco che rivela la vostra bellezza naturale. Perfetti con la vostra lingerie preferita, con un abito sexy o per un look glamour.

L'accessorio perfetto per mostrare la vostra femminilità con eleganza e celebrare le vostre curve in tutta la loro bellezza.

To Top
Articoli
Totale articoli
Struct
Entries: 108
actions
Array
available
number-1
brand
stringballerina
brandcode
stringbaye
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
stringBallerina
breasts
stringna
careinstructions
string
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.686 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 = 'BCA82ABB-58B7-47DD-BFD40C8D7C734527'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1blackcolorblakblackblack#000000-10
colorrange
stringblack
colors
stringblack
colortype
stringcolor
comments
string
compositions
Struct
Entries: 13
coton
string
elastane
string
free
string
leather
string
lycra
string
metal
string
nylon
string
polyamide
string
polyester
string
polyurethane
string
silk
string
spandex
string
viscose
string
datecreated
Date Time (Europe/Paris)
{ts '2024-01-19 15:24:42'}
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
number0
isactive
number1
iscustommade
number0
isdivasize
number0
isfirstprice
number0
isfixedprice
number0
ishot
number0
isnew
number0
isonline
number0
isoutletprice
number0
itemprice
number24.9583
itempromo
string
key
string598
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-06-04 18:41:37'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.619 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('bca82abb-58b7-47dd-bfd40c8d7c734527',lcase(cart_actions.linkedproducts)) > 0 and cart_actions.linkedproducts is not null
)
id_actionbrandinglanguagenamecodetypeminimumOrdermaximumOrderminimumItemsmaximumItemsmaximumUseallowedItemsquotasusedCountlinkedproductslinkedthemeslinkedbrandslinkeditemparamsactiveFromactiveToisActive
linkedproducts
Query
Template: /system/api/products.cfc:1305
Execution Time: 1.3 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 = '' and product_links.linkuid is not null and product_links.linkuid <> ''
and products.reference <> 'SLST1609'
group by products.reference
order by products.ishot desc, products.isnew desc, orderidx asc, products.lastupdated desc
productuidreferencetypekeylanguagenamelinkuidcolorsvatratemetadatasdimensionsmediadatastagsthemesisdivasizetotalvariationsvariationlistinpromohaspromoitempromoitempriceunitpricepricespromountilisfixedpriceishotisneworderidxavailablestockinstockvariationsbrandbrandnameshowbranddisplaysizetypeintlsizesizessizerangecategorymediadatascategorysizerangesectioncategorysubcategory
linkuid
string
materials
string
mediadatas
Struct
alt
Struct
height
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
string917
isprivate
string0
rating
stringall
src
string/photobank/products/baye/slst1609/bas-grande-taille-rivolis.jpg
type
stringimg
width
string634
variations
Struct
colors
Struct
black
Struct
height
string917
isprivate
string0
rating
stringall
src
string/photobank/products/baye/slst1609/bas-grande-taille-rivolis.jpg
type
stringimg
width
string634
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<ul> <li>Handwäsche mit kaltem Wasser, um den Glanz zu erhalten</li> <li>Feines Waschmittel ohne bleichende Mittel</li> <li>Liegend aus der Sonne trocknen</li> <li>Nicht schleudern, um die Form zu erhalten</li> <li>Sanft behandeln, um die Arabesken zu erhalten</li> <li>Nicht bügeln, um den Glanzeffekt zu erhalten</li> </ul>
description
stringArabeske Strümpfe<br /><br />Tragen Sie sie mit oder ohne Strapsgürtel, sie werden jedes Outfit unterstreichen.
guid
stringhttps://dev.divasboudoir.com/de/strumpfe-grosse-taille-arabeske-schwarz/slst1609.htm
highlights
string<ul> <li>Arabesken mit kleinen glitzernden Brillanten</li> <li>Schöne schwarze Spitze an der Oberseite</li> <li>Rückwärtige Naht für einen sexy Look</li> <li>Hergestellt in Europa für Qualität</li> <li>Weich und stabil zugleich</li> <li>Halten gut, ohne zu verrutschen</li> <li>Bringen Ihre natürliche Schönheit zum Vorschein</li> <li>Sexy und eleganter Stil</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringStrümpfe in großen Größen von Arabesque. Tragen Sie sie mit oder ohne Strapsgürtel, sie werden jedes Outfit unterstreichen. Luxus und Sinnlichkeit sind garantiert.
keywords
string
title
stringStrümpfe mit großem Bund Arabeske - Luxus und Sinnlichkeit
seotitle
stringStrümpfe große Taille Arabeske
seouri
stringstrumpfe-grosse-taille-arabeske-schwarz
specifications
string<ul> <li>Stil: Selbstfixierende Rivolis-Strümpfe mit glänzenden Arabesken</li> <li>Muster: Arabesken mit kleinen Brillanten</li> <li>Spitze: Schöne schwarze Spitze im oberen Bereich</li> <li>Naht: Hinten für sexy Vintage-Look</li> <li>Herstellung: Europäisch für Qualität</li> <li>Material: Weich und fest</li> <li>Passform: Autofixants, die nicht verrutschen</li> <li>Verwendung: Täglich und besondere Momente</li> </ul>
stylingtips
string<p>Diese Rivolis-Strümpfe sind perfekt mit ihren glänzenden Arabesken, die Ihre sexy Seite offenbaren.</p> <p>Tragen Sie sie, wenn Sie schön und sinnlich sein wollen. Die Arabesken und die Naht dahinter erzeugen einen wilden Charme, der Ihre natürliche Schönheit offenbart. Perfekt mit Ihrer Lieblingsunterwäsche, einem sexy Kleid oder für einen glamourösen Look.</p> <p>Das perfekte Accessoire, um Ihre Weiblichkeit auf elegante Weise zu zeigen und Ihre Formen in all ihrer Schönheit zu feiern.</p>
summary
stringWunderschöne Arabesque-Strümpfe, Luxus und Eleganz mit einem Hauch von Sexyness.
title
stringArabeskenstrumpf
usageinstructions
string<p>Ziehen Sie diese Strümpfe langsam an und platzieren Sie die Spitze gut an Ihren Oberschenkeln.</p> <p>Sie halten wie von selbst und passen sich perfekt an Ihre Formen an. Diese Strümpfe enthüllen Ihre Schönheit mit einem europäischen Stil, der jedes Outfit in einen Ausdruck Ihrer Weiblichkeit verwandelt.</p>
el
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Πλένετε στο χέρι με κρύο νερό για να διατηρήσετε τη λάμψη</li> <li>Απαλό πλύσιμο χωρίς χλωρίνη</li> <li>Στεγνώστε σε επίπεδη επιφάνεια μακριά από το άμεσο ηλιακό φως</li> <li>Μη στύβετε για να διατηρήσετε το σχήμα σας</li> <li>Χειριστείτε απαλά για να διατηρήσετε τα αραβουργήματα</li> <li>Μην σιδερώνετε για να διατηρήσετε το λαμπερό αποτέλεσμα</li> </ul>
description
stringΑραβικές κάλτσες<br /><br />Φορέστε τις με ή χωρίς ζαρτιέρα, θα συμπληρώσουν κάθε ντύσιμο.
guid
stringhttps://dev.divasboudoir.com/el/megales-aravikes-kaltses-mayro/slst1609.htm
highlights
string<ul> <li>Αραβουργήματα με αστραφτερές λάμψεις</li> <li>Όμορφη μαύρη δαντέλα στην κορυφή</li> <li>Ραφή στην πλάτη για σέξι εμφάνιση</li> <li>Κατασκευασμένο στην Ευρώπη για ποιότητα</li> <li>Μαλακό και δυνατό ταυτόχρονα</li> <li>Κρατάει καλά χωρίς να γλιστράει</li> <li>Αποκαλύψτε τη φυσική σας ομορφιά</li> <li>Σέξι και κομψό στυλ</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringΚάλτσες μεγάλου μεγέθους Arabesque. Φορέστε τις με ή χωρίς ζαρτιέρα, θα συμπληρώσουν κάθε ντύσιμο. Πολυτελείς και αισθησιακές.
keywords
string
title
stringΜεγάλες αραβικές κάλτσες - Luxe et volupté
seotitle
stringΜεγάλες αραβικές κάλτσες
seouri
stringmegales-aravikes-kaltses-mayro
specifications
string<ul> <li>Στυλ : Λαμπερό αραβικό Rivolis hold ups</li> <li>Μοτίβα : Αραβουργήματα με μικρές λάμψεις</li> <li>Δαντέλα : Όμορφη μαύρη δαντέλα</li> <li>Ραφή : Πίσω για ένα σέξι vintage look</li> <li>Κατασκευή : Ευρωπαϊκή για ποιότητα</li> <li>Υλικά: Μαλακά και ανθεκτικά</li> <li>Φορέστε: Αντιολισθητικά αυτοκόλλητα</li> <li>Χρήση: Καθημερινές και ειδικές περιστάσεις</li> </ul>
stylingtips
string<p>Αυτές οι κάλτσες Rivolis είναι τέλειες με τα λαμπερά αραβουργήματα που αποκαλύπτουν τη σέξι πλευρά σας.</p> <p>Φορέστε τις όταν θέλετε να είστε όμορφη και αισθησιακή. Τα αραβουργήματα και οι ραφές πίσω από αυτά δημιουργούν μια τρελή γοητεία που αποκαλύπτει τη φυσική σας ομορφιά. Ιδανικά με τα αγαπημένα σας εσώρουχα, ένα σέξι φόρεμα ή για μια λαμπερή εμφάνιση.</p> <p>Το τέλειο αξεσουάρ για να αναδείξετε τη θηλυκότητά σας με κομψότητα και να γιορτάσετε τις καμπύλες σας σε όλη τους την ομορφιά.</p>
summary
stringΥπέροχες κάλτσες Arabesque, πολυτέλεια και κομψότητα με μια πινελιά σέξι.
title
stringΑραβικές κάλτσες
usageinstructions
string<p>Φορέστε απαλά αυτές τις κάλτσες, τοποθετώντας τη δαντέλα σταθερά στους μηρούς σας.</p> <p>Στέκονται από μόνες τους και αγκαλιάζουν τέλεια το σχήμα σας. Αυτές οι κάλτσες αποκαλύπτουν την ομορφιά σας με ένα ευρωπαϊκό στυλ που μεταμορφώνει κάθε ντύσιμο σε έκφραση της θηλυκότητάς σας.</p>
en
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Hand wash in cold water to preserve shine</li> <li>Gentle detergent without bleaching agents</li> <li>Dry flat away from direct sunlight</li> <li>Do not spin to maintain shape</li> <li>Handle gently to preserve arabesques</li> <li>Do not iron to maintain shiny effect</li> </ul>
description
stringArabesque stockings<br /><br />Wear them with or without a garter belt, they'll complement any outfit.
guid
stringhttps://dev.divasboudoir.com/en/plus-size-arabesque-stockings-black/slst1609.htm
highlights
string<ul> <li>Arabesques with glittering sparkles</li> <li>Beautiful black lace on top</li> <li>Back seam for a sexy look</li> <li>Made in Europe for quality</li> <li>Soft and solid at the same time</li> <li>Hold well without slipping</li> <li>Reveal your natural beauty</li> <li>Sexy, elegant styling</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringArabesque plus size stockings. Wear them with or without a garter belt, they'll complement any outfit. Luxurious and voluptuous.
keywords
string
title
stringPlus size arabesque stockings - Luxury and sensuality
seotitle
stringPlus size arabesque stockings
seouri
stringplus-size-arabesque-stockings-black
specifications
string<ul> <li>Style: Rivolis hold-ups with shiny arabesques</li> <li>Patterns : Arabesques with small sparkles</li> <li>Lace : Beautiful black lace top</li> <li>Seam: Behind for a sexy vintage look</li> <li>Manufacturing : European for quality</li> <li>Materials: Soft and strong</li> <li>Wear: Non-slip self-ties</li> <li>Usage: Everyday and special occasions</li> </ul>
stylingtips
string<p>These Rivolis stockings are perfect with their shiny arabesques that reveal your sexy side.</p> <p>Wear them when you want to be beautiful and sensual. The arabesques and stitching behind create a crazy charm that reveals your natural beauty. Perfect with your favorite lingerie, a sexy dress or for a glamorous look.</p> <p>The perfect accessory to show off your femininity with elegance and celebrate your curves in all their beauty.</p>
summary
stringSuperb Arabesque stockings, luxury and elegance with a touch of sexy.
title
stringBas Arabesque
usageinstructions
string<p>Gently slip these stockings on, placing the lace firmly on your thighs.</p> <p>They stand on their own and hug your shape perfectly. These stockings reveal your beauty with a European style that transforms every outfit into an expression of your femininity.</p>
es
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavar a mano en agua fría para conservar el brillo</li> <li>Lavado suave sin lejía</li> <li>Secar en plano lejos de la luz solar directa</li> <li>No escurrir para conservar la forma</li> <li>Manipular con cuidado para conservar los arabescos</li> <li>No planchar para conservar el efecto brillante</li> </ul>
description
stringMedias arabescas<br /><br />Llévalas con o sin liguero, complementarán cualquier atuendo.
guid
stringhttps://dev.divasboudoir.com/es/medias-arabescas-talla-grande-negro/slst1609.htm
highlights
string<ul> <li>Arabescos con destellos brillantes</li> <li>Precioso encaje negro en la parte superior</li> <li>Costura trasera para un look sexy</li> <li>Fabricado en Europa para garantizar la calidad</li> <li>Suave y resistente al mismo tiempo</li> <li>Se sujeta bien sin resbalar</li> <li>Revela tu belleza natural</li> <li>Estilo sexy y elegante</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringMedias Arabesque de talla grande. Llévalas con o sin liguero, complementarán cualquier atuendo. Lujosas y voluptuosas.
keywords
string
title
stringMedias arabescas talla grande - Luxe et volupté
seotitle
stringMedias arabescas talla grande
seouri
stringmedias-arabescas-talla-grande-negro
specifications
string<ul> <li>Estilo : Brillante arabesco Rivolis medias</li> <li>Motivos : Arabescos con pequeños destellos</li> <li>Encaje : Bonito top de encaje negro</li> <li>Costura : Detrás para un look sexy vintage</li> <li>Fabricación : Europea de calidad</li> <li>Materiales : Suave y resistente</li> <li>Desgaste: Auto-ataduras antideslizantes</li> <li>Uso: Diario y ocasiones especiales</li> </ul>
stylingtips
string<p>Estas medias Rivolis son perfectas con sus arabescos brillantes que revelan tu lado más sexy.</p> <p>Póntelas cuando quieras estar guapa y sensual. Los arabescos y las costuras detrás de ellos crean un encanto loco que revela tu belleza natural. Perfectos con tu lencería favorita, un vestido sexy o para un look glamuroso.</p> <p>El accesorio perfecto para mostrar tu feminidad con elegancia y celebrar tus curvas en toda su belleza.</p>
summary
stringMagníficas medias arabescas, lujo y elegancia con un toque sexy.
title
stringMedias arabescas
usageinstructions
string<p>Deslice suavemente estas medias, colocando el encaje firmemente sobre sus muslos.</p> <p>Se sostienen por sí solas y se adaptan perfectamente a su silueta. Estas medias revelan tu belleza con un estilo europeo que transforma cada conjunto en una expresión de tu feminidad.</p>
fr
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavage &agrave; la main &agrave; l'eau froide pour garder les brillants</li> <li>Lessive douce sans produits qui d&eacute;colorent</li> <li>S&eacute;chage &agrave; plat loin du soleil</li> <li>Ne pas essorer pour garder la forme</li> <li>Manipuler doucement pour pr&eacute;server les arabesques</li> <li>Ne pas repasser pour garder l'effet brillant</li> </ul>
description
string<p>Ces bas Rivolis autofixants <strong>ont un style europ&eacute;en qui r&eacute;v&egrave;le votre c&ocirc;t&eacute; sexy.</strong> Les arabesques avec leurs petits brillants cr&eacute;ent un effet magnifique sur vos jambes et attirent tous les regards.<br><br>La belle dentelle noire en haut tient parfaitement bien et donne un look tr&egrave;s &eacute;l&eacute;gant. Cette dentelle r&eacute;v&egrave;le votre go&ucirc;t pour les belles choses tout en restant confortable sur vos cuisses.<br><br>La couture derri&egrave;re apporte ce petit d&eacute;tail vintage qui fait toute la diff&eacute;rence. Ce d&eacute;tail montre votre style unique et donne un charme fou &agrave; vos jambes.<br><br>Fabriqu&eacute;s en Europe, ces bas sont &agrave; la fois doux sur votre peau et tr&egrave;s solides. Les mati&egrave;res de qualit&eacute; vous font du bien et durent longtemps.<br>Le syst&egrave;me qui tient tout seul est parfait et suit tous vos mouvements. Ces bas &eacute;pousent bien vos formes pour un look parfait toute la journ&eacute;e.</p> <p>Ils c&eacute;l&egrave;brent votre sensualit&eacute; avec &eacute;l&eacute;gance et transforment chaque moment en expression de votre f&eacute;minit&eacute;.</p>
guid
stringhttps://dev.divasboudoir.com/fr/bas-rivolis-autofixants-arabesques-brillantes-grande-taille-style-europeen/slst1609.htm
highlights
string<ul> <li>Arabesques avec petits brillants qui scintillent</li> <li>Belle dentelle noire sur la partie sup&eacute;rieure</li> <li>Couture arri&egrave;re pour un look sexy</li> <li>Fabriqu&eacute;s en Europe pour la qualit&eacute;</li> <li>Doux et solides &agrave; la fois</li> <li>Tiennent bien sans glisser</li> <li>R&eacute;v&egrave;lent votre beaut&eacute; naturelle</li> <li>Style sexy et &eacute;l&eacute;gant</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringBas Rivolis autofixants arabesques brillantes grande taille, dentelle noire, fabriqués en Europe. Style sexy élégant. Diva's Boudoir.
keywords
string
title
stringBas Rivolis Autofixants Arabesques Brillantes Grande Taille | Diva's Boudoir
seotitle
stringBas Rivolis Autofixants Arabesques Brillantes Grande Taille - Style Européen
seouri
stringbas-rivolis-autofixants-arabesques-brillantes-grande-taille-style-europeen
specifications
string<ul> <li>Style : Bas Rivolis autofixants arabesques brillantes</li> <li>Motifs : Arabesques avec petits brillants</li> <li>Dentelle : Belle dentelle noire en haut</li> <li>Couture : Derri&egrave;re pour look vintage sexy</li> <li>Fabrication : Europ&eacute;enne pour la qualit&eacute;</li> <li>Mati&egrave;res : Douces et solides</li> <li>Tenue : Autofixants qui ne glissent pas</li> <li>Usage : Tous les jours et moments sp&eacute;ciaux</li> </ul>
stylingtips
string<p>Ces bas Rivolis sont parfaits avec leurs arabesques brillantes qui r&eacute;v&egrave;lent votre c&ocirc;t&eacute; sexy.</p> <p>Portez-les quand vous voulez &ecirc;tre belle et sensuelle. Les arabesques et la couture derri&egrave;re cr&eacute;ent un charme fou qui r&eacute;v&egrave;le votre beaut&eacute; naturelle. Parfaits avec votre lingerie pr&eacute;f&eacute;r&eacute;e, une robe sexy ou pour un look glamour.</p> <p>L'accessoire id&eacute;al pour montrer votre f&eacute;minit&eacute; avec &eacute;l&eacute;gance et c&eacute;l&eacute;brer vos formes dans toute leur beaut&eacute;.</p>
summary
string<p>Ces bas Rivolis autofixants r&eacute;v&egrave;lent un style europ&eacute;en avec leurs arabesques orn&eacute;es de petits brillants et leur belle dentelle noire.</p> <p><strong>Fabriqu&eacute;s en Europe,</strong> ils sont doux et solides pour r&eacute;v&eacute;ler votre beaut&eacute; avec &eacute;l&eacute;gance.</p>
title
stringBas Rivolis Autofixants Arabesques Brillantes - Style Européen
usageinstructions
string<p>Enfilez doucement ces bas en pla&ccedil;ant bien la dentelle sur vos cuisses.</p> <p>Ils tiennent tout seuls et &eacute;pousent parfaitement vos formes. Ces bas r&eacute;v&egrave;lent votre beaut&eacute; avec un style europ&eacute;en qui transforme chaque tenue en expression de votre f&eacute;minit&eacute;.</p>
it
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavare a mano in acqua fredda per mantenere la lucentezza</li> <li>Lavaggio delicato senza candeggina</li> <li>Asciugare in piano lontano dalla luce diretta del sole</li> <li>Non centrifugare per mantenere la forma</li> <li>Maneggiare delicatamente per preservare gli arabeschi</li> <li>Non stirare per mantenere l'effetto lucido</li> </ul>
description
stringCalze arabescate<br /><br />Indossate con o senza reggicalze, completeranno qualsiasi abbigliamento.
guid
stringhttps://dev.divasboudoir.com/it/calze-grandi-arabescate-nero/slst1609.htm
highlights
string<ul> <li>Arabeschi con scintille scintillanti</li> <li>Bellissimo pizzo nero sulla parte superiore</li> <li>Cucitura posteriore per un look sexy</li> <li>Prodotto in Europa per garantire la qualità</li> <li>Morbido e resistente allo stesso tempo</li> <li>Si mantiene bene senza scivolare</li> <li>Rivela la vostra bellezza naturale</li> <li>Stile sexy ed elegante</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringCalze Arabesque di grande taglia. Indossate con o senza reggicalze, completeranno qualsiasi abbigliamento. Lussuose e voluttuose.
keywords
string
title
stringCalze grandi arabescate - Luxe et volupté
seotitle
stringCalze grandi arabescate
seouri
stringcalze-grandi-arabescate-nero
specifications
string<ul> <li>Stile: Rivolis arabescato lucido</li> <li>Modelli : Arabeschi con piccoli scintillii</li> <li>Pizzo : Bellissimo top in pizzo nero</li> <li>Cuciture : Dietro per un look sexy e vintage</li> <li>Produzione : Europea per la qualità</li> <li>Materiali : Morbidi e resistenti</li> <li>Indossare: antiscivolo auto-leganti</li> <li>Uso: Tutti i giorni e occasioni speciali</li> </ul>
stylingtips
string<p>Queste calze Rivolis sono perfette con i loro arabeschi lucidi che rivelano il vostro lato sexy.</p> <p>Indossatele quando volete essere belle e sensuali. Gli arabeschi e le cuciture dietro di essi creano un fascino pazzesco che rivela la vostra bellezza naturale. Perfetti con la vostra lingerie preferita, con un abito sexy o per un look glamour.</p> <p>L'accessorio perfetto per mostrare la vostra femminilità con eleganza e celebrare le vostre curve in tutta la loro bellezza.</p>
summary
stringSuperbe calze arabescate, lusso ed eleganza con un tocco sexy.
title
stringCalze arabescate
usageinstructions
string<p>Infilate delicatamente queste calze, appoggiando il pizzo sulle cosce.</p> <p>Si reggono da sole e abbracciano perfettamente le vostre forme. Queste calze rivelano la vostra bellezza con uno stile europeo che trasforma ogni abito in un'espressione della vostra femminilità.</p>
nl
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Handwas in koud water om glans te behouden</li> <li>Zacht wassen zonder bleekmiddel</li> <li>Plat drogen uit de buurt van direct zonlicht</li> <li>Niet centrifugeren om de vorm te behouden</li> <li>Voorzichtig behandelen om de arabesken te behouden</li> <li>Niet strijken om het glanzende effect te behouden</li> </ul>
description
stringArabeske kousen<br /><br />Draag ze met of zonder jarretelgordel, ze passen bij elke outfit.
guid
stringhttps://dev.divasboudoir.com/nl/grote-maten-arabeskousen-zwart/slst1609.htm
highlights
string<ul> <li>Arabesken met glinsterende glittertjes</li> <li>Prachtig zwart kant aan de bovenkant</li> <li>Rugnaad voor een sexy look</li> <li>Gemaakt in Europa voor kwaliteit</li> <li>Zacht en sterk tegelijk</li> <li>Houdt goed vast zonder af te glijden</li> <li>Onthul je natuurlijke schoonheid</li> <li>Sexy en elegante stijl</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringArabeske kousen in grote maat. Draag ze met of zonder jarretelgordel, ze passen bij elke outfit. Luxueus en voluptueus.
keywords
string
title
stringGrote maat arabesk kousen - Luxe et volupté
seotitle
stringGrote maten arabeskousen
seouri
stringgrote-maten-arabeskousen-zwart
specifications
string<ul> <li>Stijl: glanzende arabesk Rivolis hold-ups</li> <li>Patronen : Arabesken met kleine glittertjes</li> <li>Kant : Mooie zwarte kanten top</li> <li>Naad : Achter voor een sexy vintage look</li> <li>Productie : Europees voor kwaliteit</li> <li>Materialen: Zacht en sterk</li> <li>Slijtage: Anti-slip zelfbinder</li> <li>Gebruik: Dagelijks en speciale gelegenheden</li> </ul>
stylingtips
string<p>Deze Rivolis kousen zijn perfect met hun glanzende arabesken die je sexy kant laten zien.</p> <p>Draag ze als je mooi en sensueel wilt zijn. De arabesken en het stiksel erachter zorgen voor een te gekke charme die je natuurlijke schoonheid onthult. Perfect bij je favoriete lingerie, een sexy jurkje of voor een glamoureuze look.</p> <p>Het perfecte accessoire om elegant met je vrouwelijkheid te pronken en je rondingen in al hun schoonheid te vieren.</p>
summary
stringSchitterende Arabische kousen, luxe en elegantie met een vleugje sexy.
title
stringArabeske kousen
usageinstructions
string<p>Trek deze kousen zachtjes aan en leg het kant stevig op je dijen.</p> <p>Ze staan op zichzelf en omhelzen je vorm perfect. Deze kousen onthullen je schoonheid met een Europese stijl die elke outfit verandert in een expressie van je vrouwelijkheid.</p>
pt
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavar à mão em água fria para manter o brilho</li> <li>Lavagem suave sem lixívia</li> <li>Secar ao ar livre, longe da luz solar direta</li> <li>Não torcer para manter a forma</li> <li>Manusear com cuidado para preservar os arabescos</li> <li>Não passar a ferro para manter o efeito brilhante</li> </ul>
description
stringMeias de ligas arabescas<br /><br />Usadas com ou sem cinto de ligas, complementam qualquer conjunto.
guid
stringhttps://dev.divasboudoir.com/pt/meias-grandes-em-arabesco-preto/slst1609.htm
highlights
string<ul> <li>Arabescos com brilhantes cintilantes</li> <li>Bonita renda preta na parte superior</li> <li>Costura nas costas para um look sexy</li> <li>Fabricado na Europa para garantir a qualidade</li> <li>Suave e forte ao mesmo tempo</li> <li>Segura bem sem escorregar</li> <li>Revela a sua beleza natural</li> <li>Estilo sexy e elegante</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringMeias Arabesque de tamanho grande. Usadas com ou sem cinto de ligas, complementam qualquer conjunto. Luxuosas e voluptuosas.
keywords
string
title
stringMeias grandes arabesco - Luxe et volupté
seotitle
stringMeias grandes em arabesco
seouri
stringmeias-grandes-em-arabesco-preto
specifications
string<ul> <li>Estilo : Prendedores brilhantes de Rivolis em arabesco</li> <li>Padrões : Arabescos com pequenos brilhos</li> <li>Renda : Linda camisola de renda preta</li> <li>Costura : Atrás para um look vintage sexy</li> <li>Fabrico : Europeu para a qualidade</li> <li>Materiais: Suave e resistente</li> <li>Utilização: Autocolantes antiderrapantes</li> <li>Utilização: Todos os dias e ocasiões especiais</li> </ul>
stylingtips
string<p>Estas meias Rivolis são perfeitas com os seus arabescos brilhantes que revelam o seu lado sexy.</p> <p>Use-as quando quiser ser bonita e sensual. Os arabescos e a costura por trás deles criam um encanto louco que revela a sua beleza natural. Perfeito com a sua lingerie favorita, um vestido sexy ou para um look glamoroso.</p> <p>O acessório perfeito para mostrar a sua feminilidade com elegância e celebrar as suas curvas em toda a sua beleza.</p>
summary
stringMeias de ligas arabescas soberbas, luxo e elegância com um toque de sensualidade.
title
stringMeias de ligas arabescas
usageinstructions
string<p>Calce suavemente estas meias, colocando a renda firmemente nas suas coxas.</p> <p>São autónomas e abraçam perfeitamente a sua forma. Estas meias revelam a sua beleza com um estilo europeu que transforma qualquer roupa numa expressão da sua feminilidade.</p>
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<ul> <li>Handwäsche mit kaltem Wasser, um den Glanz zu erhalten</li> <li>Verwenden Sie ein mildes Waschmittel ohne Bleichmittel</li> <li>Trocknen Sie das Kleidungsstück liegend und vor direktem Licht geschützt</li> <li>vermeiden Sie Schleudern, um die selbstbindenden Bänder zu erhalten</li> <li>Vorsichtig behandeln, um verzierte Arabesken zu erhalten</li> <li>Nicht bügeln, um den Glanzeffekt zu erhalten</li> </ul>
description
stringRivoli Strümpfe<br /><br />Tragen Sie sie mit oder ohne Strapsgürtel, sie werden jedes Outfit unterstreichen.
highlights
string<ul> <li>Luxuriöse Arabesken mit kleinen Brillanten verziert</li> <li>Breites Band aus raffinierter schwarzer Spitze</li> <li>Rückwärtige Naht für einen eleganten Vintage-Strumpf-Effekt</li> <li>Europäische Herstellung garantiert Premium-Qualität</li> <li><strong>Weich und fest</strong> für Komfort und Haltbarkeit</li> <li>Zuverlässiges selbstfixierendes System, das sich perfekt anpasst</li> <li>Nur in großen Größen erhältlich</li> <li><strong>Europäischer Luxus</strong> für natürliche Schönheit</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringStrümpfe in großen Größen Rivoli. Tragen Sie sie mit oder ohne Strapsgürtel, sie werden jedes Outfit unterstreichen. Luxus und Sinnlichkeit sind garantiert.
keywords
string
title
stringStrümpfe in großen Größen Rivoli - Luxus und Sinnlichkeit
seotitle
stringStrümpfe in großen Größen Rivoli
seouri
stringstrumpfe-in-grossen-grossen-rivoli-schwarz
specifications
string<ul> <li>Stil: Selbstfixierende Rivolis-Strümpfe mit glänzenden Arabesken</li> <li>Arabesken: Mit kleinen Glitzersteinen verziert, mit luxuriösem Effekt</li> <li>Spitze: Breiter, raffinierter schwarzer Streifen</li> <li>Naht: Rückseite mit elegantem Vintage-Effekt</li> <li>Herstellung: Europäische Premium-Qualität</li> <li>Material: Weich und fest Komfort Haltbarkeit</li> <li>Größen: Nur spezialisierte große Größen</li> <li>Halt: Zuverlässiges selbstbindendes System Morphologie</li> </ul>
stylingtips
string<p>Diese Rivolis-Strümpfe stehen für sich selbst mit ihren glänzenden Arabesken, die Ihre luxuriöse Persönlichkeit offenbaren. Tragen Sie sie zu all Ihren Anlässen, bei denen Sie europäische Raffinesse mit Komfort kombinieren möchten.</p> <p>Die verzierten Arabesken und die Rückennaht sorgen für einen fesselnden Look, der Ihre natürliche Schönheit unterstreicht. Perfekt zu einem Kleid, einem Rock oder für einen glamourösen Look, bringen sie diesen europäischen Luxus mit sich, der Ihre Vorliebe für raffinierte glänzende Details offenbart.</p> <p>Das perfekte Accessoire, um Ihre Weiblichkeit mit europäischer Eleganz zum Ausdruck zu bringen, die Ihren Stil in seiner ganzen Pracht feiert.</p>
summary
stringWunderschöne Rivoli-Strümpfe, Luxus und Eleganz mit einem Hauch von Sexyness.
title
stringBas Rivoli
usageinstructions
string<p>Ziehen Sie diese Strümpfe vorsichtig an, indem Sie den breiten Spitzenstreifen sorgfältig an Ihren Oberschenkeln positionieren. Das selbstfixierende System passt sich perfekt an Ihre Morphologie an und sorgt für optimalen Halt.</p> <p>Diese Strümpfe offenbaren Ihre Eleganz mit europäischem Luxus, der jedes Outfit in einen Ausdruck Ihrer selbstbewussten Raffinesse verwandelt.</p>
el
Struct
Entries: 14
abstract
string
careinstructions
string<ul> <li>Πλύνετε στο χέρι με κρύο νερό για να διατηρήσετε τη λάμψη</li> <li>Χρησιμοποιήστε ήπιο απορρυπαντικό χωρίς λευκαντικούς παράγοντες</li> <li>Στεγνώστε σε επίπεδη επιφάνεια μακριά από το άμεσο φως</li> <li>αποφύγετε το στύψιμο για να διατηρήσετε τα αυτοκόλλητα</li> <li>Χειριστείτε απαλά για να διατηρήσετε τα περίτεχνα αραβουργήματα</li> <li>Μην σιδερώνετε για να διατηρήσετε το λαμπερό αποτέλεσμα</li> </ul>
description
stringΚάλτσες Rivoli<br /><br />Φορέστε τις με ή χωρίς ζώνη καλτσοδέτας, θα συμπληρώσουν κάθε ντύσιμο.
highlights
string<ul> <li>Πολυτελή αραβουργήματα διακοσμημένα με μικρά διαμάντια</li> <li>Ευρεία ζώνη από εκλεπτυσμένη μαύρη δαντέλα</li> <li>Ραφή στην πλάτη για κομψό αποτέλεσμα vintage κάλτσας</li> <li>Κατασκευάζεται στην Ευρώπη για να εγγυάται κορυφαία ποιότητα</li> <li><strong>Μαλακό και ανθεκτικό</strong> για άνεση και αντοχή</li> <li>Αξιόπιστο σύστημα αυτοκόλλησης για τέλεια εφαρμογή</li> <li>Διατίθεται μόνο σε μεγάλα μεγέθη</li> <li><strong>Ευρωπαϊκή πολυτέλεια</strong> για φυσική ομορφιά</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringΚάλτσες Rivoli μεγάλου μεγέθους. Φορέστε τις με ή χωρίς ζαρτιέρα, θα συμπληρώσουν κάθε ντύσιμο. Πολυτελείς και αισθησιακές.
keywords
string
title
stringΚάλτσες μεγάλου μεγέθους Rivoli - Πολυτέλεια και αισθησιασμός
seotitle
stringΚάλτσες μεγάλου μεγέθους Rivoli
seouri
stringkaltses-megaloy-megethoys-rivoli-mayro
specifications
string<ul> <li>Στυλ : Λαμπερό αραβικό Rivolis hold ups</li> <li>Αραβουργήματα : Διακοσμημένα με μικρές λάμψεις για ένα πολυτελές αποτέλεσμα</li> <li>Δαντέλα: Ευρεία εκλεπτυσμένη μαύρη ζώνη</li> <li>Ραφή : Κομψό vintage εφέ στην πλάτη</li> <li>Κατασκευή : Ευρωπαϊκή premium ποιότητα</li> <li>Υλικά: Μαλακή και ισχυρή άνεση ανθεκτικότητα</li> <li>Μεγέθη: Μόνο εξειδικευμένα μεγάλα μεγέθη</li> <li>Υποστήριξη : Αξιόπιστη μορφολογία συστήματος αυτοσυγκράτησης</li> </ul>
stylingtips
string<p>Αυτές οι κάλτσες Rivolis μιλούν από μόνες τους, με τα λαμπερά αραβουργήματα που αποκαλύπτουν την πολυτελή προσωπικότητά σας. Φορέστε τις για κάθε περίσταση όταν θέλετε να συνδυάσετε την ευρωπαϊκή φινέτσα με την άνεση.</p> <p>Τα περίτεχνα αραβουργήματα και η πίσω ραφή δημιουργούν μια σαγηνευτική εμφάνιση που αναδεικνύει τη φυσική σας ομορφιά. Ιδανικά με ένα φόρεμα, μια φούστα ή για μια λαμπερή εμφάνιση, φέρνουν αυτή την ευρωπαϊκή πολυτέλεια που αποκαλύπτει το γούστο σας για εκλεπτυσμένες γυαλιστερές λεπτομέρειες.</p> <p>Το ιδανικό αξεσουάρ για να εκφράσετε τη θηλυκότητά σας με ευρωπαϊκή κομψότητα που εξυμνεί το στυλ σας σε όλο του το μεγαλείο.</p>
summary
stringΥπέροχες κάλτσες Rivoli, πολυτέλεια και κομψότητα με μια πινελιά σέξι.
title
stringBas Rivoli
usageinstructions
string<p>Φορέστε απαλά αυτές τις κάλτσες, τοποθετώντας προσεκτικά τη φαρδιά δαντελένια ζώνη στους μηρούς σας. Το σύστημα αυτοκόλλησης προσαρμόζεται τέλεια στο σχήμα σας για βέλτιστη στήριξη.</p> <p>Αυτές οι κάλτσες αποκαλύπτουν την κομψότητά σας με μια ευρωπαϊκή πολυτέλεια που μετατρέπει κάθε ντύσιμο σε έκφραση της υποτιθέμενης φινέτσας σας.</p>
en
Struct
Entries: 14
abstract
string
careinstructions
string<ul> <li>Hand wash in cold water to preserve shine</li> <li>Use a mild detergent without bleaching agents</li> <li>Dry flat away from direct light</li> <li>avoid spin-drying to maintain self-ties</li> <li>Handle delicately to preserve ornate arabesques</li> <li>Do not iron to preserve shiny effect</li> </ul>
description
stringRivoli stockings<br /><br />Wear them with or without a garter belt, they'll complement any outfit.
highlights
string<ul> <li>Luxurious arabesques adorned with small diamonds</li> <li>Wide band of sophisticated black lace</li> <li>Back seam for elegant vintage stocking effect</li> <li>European manufacturing guarantees premium quality</li> <li><strong>Soft and strong</strong> for comfort and durability</li> <li>Reliable self-tie system for perfect fit</li> <li>Only available in plus size</li> <li><strong>European luxury</strong> revealing natural beauty</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringRivoli plus size stockings. Wear them with or without a garter belt, they'll complement any outfit. Luxurious and voluptuous.
keywords
string
title
stringPlus size stockings Rivoli - Luxury and sensuality
seotitle
stringRivoli plus size stockings
seouri
stringrivoli-plus-size-stockings-black
specifications
string<ul> <li>Style : Rivolis hold ups with shiny arabesques</li> <li>Arabesques: Embellished with small diamonds for a luxurious effect</li> <li>Lace : Wide sophisticated black band</li> <li>Seam: Elegant vintage-effect back</li> <li>Manufacturing : European premium quality</li> <li>Materials: Soft and strong comfort durability</li> <li>Sizes: Only plus size specialized</li> <li>Support: Reliable self-fastening system morphology</li> </ul>
stylingtips
string<p>These Rivolis stockings stand on their own thanks to their shiny arabesques that reveal your luxurious personality. Wear them for any occasion when you want to combine European sophistication with comfort.</p> <p>The ornate arabesques and back seam create a captivating look that enhances your natural beauty. Perfect with a dress, a skirt or for a glamorous look, they bring that European luxury that reveals your taste for refined shiny details.</p> <p>The ideal accessory for expressing your femininity with a European elegance that celebrates your style in all its splendor.</p>
summary
stringSuperb Rivoli stockings, luxury and elegance with a touch of sexy.
title
stringBas Rivoli
usageinstructions
string<p>Gently slip these stockings on, carefully positioning the wide lace band on your thighs. The self-fastening system adapts perfectly to your morphology for optimum support.</p> <p>These stockings reveal your elegance with a European luxury that transforms every outfit into an expression of your assumed sophistication.</p>
es
Struct
Entries: 14
abstract
string
careinstructions
string<ul> <li>Lavar a mano en agua fría para conservar el brillo</li> <li>Utilizar un detergente suave sin blanqueantes</li> <li>Séquela en plano lejos de la luz directa</li> <li>evite el centrifugado para mantener los lazos</li> <li>Manipular con cuidado para conservar los arabescos ornamentales</li> <li>No planchar para conservar el efecto brillante</li> </ul>
description
stringMedias Rivoli<br /><br />Llévalas con o sin liguero, complementarán cualquier conjunto.
highlights
string<ul> <li>Lujosos arabescos adornados con pequeños diamantes</li> <li>Banda ancha de sofisticado encaje negro</li> <li>Costura trasera para un elegante efecto de media vintage</li> <li>Fabricadas en Europa para garantizar la máxima calidad</li> <li><strong>Suaves y resistentes</strong> para mayor comodidad y durabilidad</li> <li>Fiable sistema de auto-atado para un ajuste perfecto</li> <li>Sólo disponible en talla grande</li> <li><strong>Lujo europeo</strong> para una belleza natural</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringMedias Rivoli de talla grande. Llévalas con o sin liguero, complementarán cualquier conjunto. Lujosas y voluptuosas.
keywords
string
title
stringMedias de talla grande Rivoli - Lujo y sensualidad
seotitle
stringMedias de talla grande Rivoli
seouri
stringmedias-de-talla-grande-rivoli-negro
specifications
string<ul> <li>Estilo : Fijaciones Rivolis arabescos brillantes</li> <li>Arabescos : Adornados con pequeños destellos para un efecto lujoso</li> <li>Encaje: Ancha y sofisticada banda negra</li> <li>Costura : Elegante espalda efecto vintage</li> <li>Fabricación : Europea de primera calidad</li> <li>Materiales: Suave y resistente confort durabilidad</li> <li>Tallas: Sólo tallas grandes especializadas</li> <li>Sujeción : Morfología fiable del sistema de autofijación</li> </ul>
stylingtips
string<p>Estas medias Rivolis hablan por sí solas, con sus brillantes arabescos que revelan tu lujosa personalidad. Llévelas en cualquier ocasión en la que desee combinar la sofisticación europea con la comodidad.</p> <p>Los arabescos ornamentados y la costura trasera crean un aspecto cautivador que realza su belleza natural. Perfectos con un vestido, una falda o para un look glamuroso, aportan ese lujo europeo que revela tu gusto por los detalles brillantes y refinados.</p> <p>El accesorio perfecto para expresar tu feminidad con la elegancia europea que celebra tu estilo en todo su esplendor.</p>
summary
stringMagníficas medias Rivoli, lujo y elegancia con un toque sexy.
title
stringBas Rivoli
usageinstructions
string<p>Deslice suavemente estas medias, colocando con cuidado la banda ancha de encaje sobre sus muslos. El sistema de auto-atado se adapta perfectamente a su forma para un soporte óptimo.</p> <p>Estas medias revelan tu elegancia con un lujo europeo que transforma cada atuendo en una expresión de tu sofisticación asumida.</p>
fr
Struct
Entries: 14
abstract
string
careinstructions
string<ul> <li>Lavage &agrave; la main &agrave; l'eau froide pour pr&eacute;server brillants</li> <li>Utiliser une lessive douce sans agents blanchissants</li> <li>S&eacute;chage &agrave; plat &agrave; l'abri de la lumi&egrave;re directe</li> <li>&Eacute;viter l'essorage pour maintenir bandes autofixantes</li> <li>Manipuler d&eacute;licatement pour pr&eacute;server arabesques orn&eacute;es</li> <li>Ne pas repasser pour conserver effet brillant</li> </ul>
description
string<p>Ces bas Rivolis autofixants incarnent l'excellence europ&eacute;enne avec leur <strong>design luxueux</strong> qui r&eacute;v&egrave;le votre go&ucirc;t pour les d&eacute;tails raffin&eacute;s. Les arabesques orn&eacute;es de petits brillants cr&eacute;ent un effet captivant qui sublime vos jambes avec une sophistication remarquable.<br><br><strong>La large bande de dentelle noire</strong> constitue l'&eacute;l&eacute;ment signature qui assure un <strong>maintien parfait </strong>tout en apportant une esth&eacute;tique luxueuse. La dentelle r&eacute;v&egrave;le votre pr&eacute;f&eacute;rence pour les finitions nobles tout en garantissant un confort optimal qui &eacute;pouse harmonieusement vos formes.<br><br>La couture arri&egrave;re apporte une dimension vintage &eacute;l&eacute;gante qui distingue ces bas des mod&egrave;les conventionnels. Le d&eacute;tail r&eacute;v&egrave;le votre go&ucirc;t pour les r&eacute;f&eacute;rences classiques tout en conservant une modernit&eacute; qui caract&eacute;rise votre style personnel.<br><br>La fabrication europ&eacute;enne garantit une qualit&eacute; premium qui allie douceur et solidit&eacute;. Les mati&egrave;res nobles respectent votre peau tout en offrant une r&eacute;sistance exceptionnelle qui prolonge la dur&eacute;e de vie de ces bas luxueux.<br><br>Le syst&egrave;me autofixant sp&eacute;cialement con&ccedil;u assure un maintien fiable qui accompagne chacun de vos mouvements. La conception &eacute;tudi&eacute;e s'adapte parfaitement &agrave; votre morphologie pour une tenue impeccable toute la journ&eacute;e.<br><br>Uniquement disponibles en grande taille, ces bas Rivolis r&eacute;pondent sp&eacute;cifiquement aux besoins des femmes qui recherchent un luxe europ&eacute;en accessible. L'approche r&eacute;v&egrave;le la beaut&eacute; naturelle avec une &eacute;l&eacute;gance qui c&eacute;l&egrave;bre toutes les morphologies.</p>
highlights
string<ul> <li>Arabesques luxueuses orn&eacute;es de petits brillants</li> <li>Large bande de dentelle noire sophistiqu&eacute;e</li> <li>Couture arri&egrave;re pour effet bas vintage &eacute;l&eacute;gant</li> <li>Fabrication europ&eacute;enne garantissant qualit&eacute; premium</li> <li><strong>Doux et solides</strong> pour confort et durabilit&eacute;</li> <li>Syst&egrave;me autofixant fiable s'adaptant parfaitement</li> <li>Uniquement disponibles en grande taille</li> <li><strong>Luxe europ&eacute;en</strong> r&eacute;v&eacute;lant beaut&eacute; naturelle</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringBas Rivolis autofixants arabesques brillants, dentelle noire, fabrication européenne, grande taille uniquement. Luxe européen. Leg's Boudoir.
keywords
string
title
stringBas Rivolis Autofixants Arabesques Brillants | Luxe Européen | Leg's Boudoir
seotitle
stringBas Rivolis Autofixants Arabesques Brillants Grande Taille - Luxe Européen
seouri
stringbas-rivolis-autofixants-arabesques-brillants-luxe-europeen
specifications
string<ul> <li>Style : Bas Rivolis autofixants arabesques brillants</li> <li>Arabesques : Orn&eacute;es petits brillants effet luxueux</li> <li>Dentelle : Large bande noire sophistiqu&eacute;e</li> <li>Couture : Arri&egrave;re effet vintage &eacute;l&eacute;gant</li> <li>Fabrication : Europ&eacute;enne qualit&eacute; premium</li> <li>Mati&egrave;res : Douces et solides confort durabilit&eacute;</li> <li>Tailles : Uniquement grande taille sp&eacute;cialis&eacute;es</li> <li>Maintien : Syst&egrave;me autofixant fiable morphologie</li> </ul>
stylingtips
string<p>Ces bas Rivolis se suffisent &agrave; eux-m&ecirc;mes gr&acirc;ce &agrave; leurs arabesques brillantes qui r&eacute;v&egrave;lent votre personnalit&eacute; luxueuse. Portez-les pour toutes vos occasions o&ugrave; vous voulez allier sophistication europ&eacute;enne et confort.</p> <p>Les arabesques orn&eacute;es et la couture arri&egrave;re cr&eacute;ent une allure captivante qui sublime votre beaut&eacute; naturelle. Parfaits avec une robe, une jupe ou pour un look glamour, ils apportent ce luxe europ&eacute;en qui r&eacute;v&egrave;le votre go&ucirc;t pour les d&eacute;tails brillants raffin&eacute;s.</p> <p>L'accessoire id&eacute;al pour exprimer votre f&eacute;minit&eacute; avec une &eacute;l&eacute;gance europ&eacute;enne qui c&eacute;l&egrave;bre votre style dans toute sa splendeur.</p>
summary
string<p>Ces bas Rivolis autofixants incarnent le luxe europ&eacute;en avec leurs arabesques orn&eacute;es de petits brillants et leur large bande de dentelle noire.</p> <p><strong>Fabriqu&eacute;s en Europe,</strong> ils allient douceur et solidit&eacute; pour offrir un confort exceptionnel aux femmes avec une &eacute;l&eacute;gance raffin&eacute;e.</p>
title
stringBas Rivolis Autofixants Arabesques Brillants - Luxe Européen
usageinstructions
string<p>Enfilez d&eacute;licatement ces bas en positionnant soigneusement la large bande de dentelle sur vos cuisses. Le syst&egrave;me autofixant s'adapte parfaitement &agrave; votre morphologie pour un maintien optimal.</p> <p>Ces bas r&eacute;v&egrave;lent votre &eacute;l&eacute;gance avec un luxe europ&eacute;en qui transforme chaque tenue en expression de votre sophistication assum&eacute;e.</p>
it
Struct
Entries: 14
abstract
string
careinstructions
string<ul> <li>Lavare a mano in acqua fredda per preservare la brillantezza</li> <li>Utilizzare un detergente delicato senza agenti sbiancanti</li> <li>Asciugare in piano lontano dalla luce diretta</li> <li>evitare l'asciugatura in centrifuga per mantenere i legami tra le parti</li> <li>Maneggiare delicatamente per preservare gli arabeschi ornamentali</li> <li>Non stirare per preservare l'effetto lucido</li> </ul>
description
stringCalze Rivoli<br /><br />Indossate con o senza reggicalze, completeranno qualsiasi abbigliamento.
highlights
string<ul> <li>Lussuosi arabeschi ornati da piccoli diamanti</li> <li>Ampia fascia di sofisticato pizzo nero</li> <li>Cucitura posteriore per un elegante effetto calza vintage</li> <li>Prodotto in Europa per garantire la massima qualità</li> <li><strong>Morbido e resistente</strong> per comfort e durata</li> <li>Affidabile sistema di autoallacciatura per una perfetta vestibilità</li> <li>Disponibile solo in taglia grande</li> <li><strong>Lusso europeo</strong> per una bellezza naturale</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringCalze Rivoli di grande taglia. Indossate con o senza reggicalze, completeranno qualsiasi abbigliamento. Lussuose e voluttuose.
keywords
string
title
stringCalze di taglia grande Rivoli - Lusso e sensualità
seotitle
stringCalze di taglia grande Rivoli
seouri
stringcalze-di-taglia-grande-rivoli-nero
specifications
string<ul> <li>Stile : Rivolis hold up con arabeschi lucidi</li> <li>Arabeschi : Impreziositi da piccoli brillantini per un effetto lussuoso</li> <li>Pizzo: Ampia e sofisticata fascia nera</li> <li>Cucitura : Elegante retro effetto vintage</li> <li>Fabbricazione : Qualità europea di alto livello</li> <li>Materiali: Morbidi e resistenti per un comfort duraturo</li> <li>Taglie : Solo taglie grandi specializzate</li> <li>Sostegno : Affidabile sistema di auto-fissaggio morfologico</li> </ul>
stylingtips
string<p>Queste calze Rivolis parlano da sole, con i loro arabeschi lucidi che rivelano la vostra personalità lussuosa. Indossatele in qualsiasi occasione in cui vogliate combinare la raffinatezza europea con il comfort.</p> <p>Gli arabeschi decorati e la cucitura posteriore creano un look accattivante che esalta la vostra bellezza naturale. Perfetti con un abito, una gonna o per un look glamour, portano quel lusso europeo che rivela il vostro gusto per i dettagli raffinati e brillanti.</p> <p>L'accessorio ideale per esprimere la vostra femminilità con un'eleganza europea che celebra il vostro stile in tutto il suo splendore.</p>
summary
stringSuperbe calze Rivoli, lusso ed eleganza con un tocco sexy.
title
stringBas Rivoli
usageinstructions
string<p>Infilate delicatamente queste calze, posizionando con cura l'ampia fascia di pizzo sulle cosce. Il sistema di autoallacciatura si adatta perfettamente alle vostre forme per un sostegno ottimale.</p> <p>Queste calze rivelano la vostra eleganza con un lusso europeo che trasforma ogni abito in un'espressione della vostra presunta raffinatezza.</p>
nl
Struct
Entries: 14
abstract
string
careinstructions
string<ul> <li>Handwas in koud water om glans te behouden</li> <li>Gebruik een mild wasmiddel zonder bleekmiddelen</li> <li>Plat drogen uit de buurt van direct licht</li> <li>vermijd centrifugeren om zelfbinding te behouden</li> <li>Voorzichtig behandelen om de sierlijke arabesken te behouden</li> <li>Niet strijken om het glanzende effect te behouden</li> </ul>
description
stringRivoli kousen<br /><br />Draag ze met of zonder jarretelgordel, ze passen bij elke outfit.
highlights
string<ul> <li>Luxueuze arabesken versierd met kleine diamanten</li> <li>Brede band van verfijnd zwart kant</li> <li>Rugnaad voor elegant vintage kouseffect</li> <li>Gemaakt in Europa om premium kwaliteit te garanderen</li> <li><strong>Zacht en sterk</strong> voor comfort en duurzaamheid</li> <li>Betrouwbaar zelfknoopsysteem voor perfecte pasvorm</li> <li>Alleen verkrijgbaar in grote maten</li> <li><strong>Europese luxe</strong> voor natuurlijke schoonheid</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringRivoli kousen in grote maat. Draag ze met of zonder jarretelgordel, ze passen bij elke outfit. Luxueus en voluptueus.
keywords
string
title
stringRivoli kousen in grote maten - Luxe en sensualiteit
seotitle
stringGrote maten arabeskousen
seouri
stringgrote-maten-arabeskousen-zwart
specifications
string<ul> <li>Stijl : Glimmende arabesque Rivolis hold-ups</li> <li>Arabesken : Versierd met kleine glittertjes voor een luxueus effect</li> <li>Kant: Brede verfijnde zwarte band</li> <li>Naad : Elegante vintage effect achterkant</li> <li>Fabricage : Europese topkwaliteit</li> <li>Materialen: Zacht en sterk comfort duurzaamheid</li> <li>Maten: Alleen gespecialiseerde grote maten</li> <li>Ondersteuning : Betrouwbaar zelfbevestigend systeem morfologie</li> </ul>
stylingtips
string<p>Deze Rivolis kousen spreken voor zich, met hun glanzende arabesken die jouw luxueuze persoonlijkheid onthullen. Draag ze voor elke gelegenheid wanneer je Europese verfijning wilt combineren met comfort.</p> <p>De sierlijke arabesken en de naad aan de achterkant zorgen voor een fascinerende look die je natuurlijke schoonheid benadrukt. Perfect bij een jurk, een rok of voor een glamoureuze look, ze brengen die Europese luxe die je smaak voor verfijnde glanzende details onthult.</p> <p>Het ideale accessoire om je vrouwelijkheid uit te drukken met Europese elegantie die je stijl in al zijn pracht viert.</p>
summary
stringSchitterende Rivoli kousen, luxe en elegantie met een vleugje sexy.
title
stringArabeske kousen
usageinstructions
string<p>Trek deze kousen zachtjes aan en plaats de brede kanten band zorgvuldig op je dijen. Het zelfknoopsysteem past zich perfect aan je vorm aan voor optimale ondersteuning.</p> <p>Deze kousen onthullen je elegantie met een Europese luxe die elke outfit verandert in een uitdrukking van je veronderstelde verfijning.</p>
pt
Struct
Entries: 14
abstract
string
careinstructions
string<ul> <li>Lavar à mão em água fria para preservar o brilho</li> <li>Utilizar um detergente suave sem agentes branqueadores</li> <li>Secar ao abrigo da luz direta</li> <li>evitar secar à centrifugação para manter a auto-fixação</li> <li>Manusear com cuidado para preservar os arabescos ornamentados</li> <li>Não passar a ferro para preservar o efeito brilhante</li> </ul>
description
stringMeias de ligas Rivoli<br /><br />Usadas com ou sem cinto de ligas, complementam qualquer conjunto.
highlights
string<ul> <li>Luxuosos arabescos adornados com pequenos diamantes</li> <li>Faixa larga de renda preta sofisticada</li> <li>Costura traseira para um elegante efeito de meia vintage</li> <li>Fabricadas na Europa para garantir uma qualidade superior</li> <li><strong>Suave e resistente</strong> para conforto e durabilidade</li> <li>Sistema fiável de auto-amarração para um ajuste perfeito</li> <li>Disponível apenas em tamanhos grandes</li> <li><strong>Luxo europeu</strong> para uma beleza natural</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringMeias Rivoli de tamanho grande. Usadas com ou sem cinto de ligas, complementam qualquer conjunto. Luxuosas e voluptuosas.
keywords
string
title
stringMeias de tamanho grande Rivoli - Luxo e sensualidade
seotitle
stringMeias de tamanho grande Rivoli
seouri
stringmeias-de-tamanho-grande-rivoli-preto
specifications
string<ul> <li>Estilo : Meias Rivolis com arabescos brilhantes</li> <li>Arabescos: Enriquecidos com pequenos brilhantes para um efeito luxuoso</li> <li>Renda: Faixa preta larga e sofisticada</li> <li>Costura : Elegante efeito vintage nas costas</li> <li>Fabrico: Qualidade premium europeia</li> <li>Materiais: Suave e resistente, conforto e durabilidade</li> <li>Tamanhos: Apenas tamanhos grandes especializados</li> <li>Suporte : Morfologia fiável do sistema de auto-fixação</li> </ul>
stylingtips
string<p>Estas meias Rivolis falam por si, com os seus arabescos brilhantes que revelam a sua personalidade luxuosa. Use-as em qualquer ocasião em que queira combinar a sofisticação europeia com o conforto.</p> <p>Os arabescos ornamentados e a costura posterior criam um visual cativante que realça a sua beleza natural. Perfeitas para combinar com um vestido, uma saia ou para um look glamoroso, trazem aquele luxo europeu que revela o seu gosto por pormenores brilhantes e refinados.</p> <p>O acessório ideal para exprimir a sua feminilidade com uma elegância europeia que celebra o seu estilo em todo o seu esplendor.</p>
summary
stringMeias Rivoli soberbas, luxo e elegância com um toque de sensualidade.
title
stringBas Rivoli
usageinstructions
string<p>Calce suavemente estas meias, posicionando cuidadosamente a faixa larga de renda nas suas coxas. O sistema de auto-amarração adapta-se perfeitamente à sua forma para um apoio ótimo.</p> <p>Estas meias revelam a sua elegância com um luxo europeu que transforma qualquer roupa numa expressão da sua sofisticação assumida.</p>
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
string598
netweight
string
nextshipment
stringtomorrow
ordered
number9
orderidx
number0
origin
stringeu
originalsize
string
packaging
number0
productshipment
stringauto
productuid
stringBCA82ABB-58B7-47DD-BFD40C8D7C734527
promountil
string
rating
stringnone
recorduid
stringBCA82ABB-58B7-47DD-BFD40C8D7C734527
reference
stringSLST1609
related
string
reserved
number0
returned
number0
returnsallowed
number1
section
stringlingerie
shipment
string5to7days
showbrand
number0
sizeinfos
Query
Template: /system/api/product/sizes.cfc:20
Execution Time: 1.2 ms
Record Count: 2
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_sizes.id_size as recorduid, if(intlsize <> '',intlsize,eusize) as size, if(intlsize <> '','intlsize','eusize') as sizetype,
product_variations.color,
if(product_sizes.sizegroup = 'bra',
if(intlsize <> '', cast(intlsize as SIGNED ), cast(eusize as SIGNED ))
,
SUBSTRING_INDEX(intlsize,'-',1)
) as param1,
if(product_sizes.sizegroup = 'bra',
if(intlsize <> '',
MID(intlsize,length(cast(intlsize as SIGNED ))+1,length(intlsize)),
MID(eusize,length(cast(eusize as SIGNED ))+1,length(eusize))
)
,
SUBSTRING_INDEX(intlsize,'-',-1)
) as param2,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as available,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
999999,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as groupavailable,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
product_sizes.gender, product_sizes.sizerange, product_sizes.sizegroup, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize,
product_sizes.bust, product_sizes.waist, product_sizes.hip, product_sizes.underbust, product_sizes.cup, product_sizes.thigh, product_sizes.legheight, product_sizes.bodyheight, product_sizes.bodyweight
from product_sizes
left outer join product_variations on product_sizes.suppliersize = product_variations.size and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
where FIND_IN_SET(product_sizes.id_size,'567,568') > 0
and product_variations.productuid = 'BCA82ABB-58B7-47DD-BFD40C8D7C734527'
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
15675-6intlsizeblack56-19999990wplusstockingXL+5-642-4612-1616-2044-4844-4842-4648-5244-4842-4660-67150-165
25686-7intlsizeblack67-19999990wplusstockingXXL+6-746-4816-1820-2248-5048-5046-4852-5448-5046-4867-75165-175
sizeranges
stringplus
sizes
string567,568
sizetype
stringintlsize
specifications
Struct
Entries: 23
belly
string
bones
string
bra
string
breasts
string
bust
string
closing
string
crochtless
string
cups
string
cut
string
garter
string
halter
string
lacing
string
lining
string
modestypanel
string
panty
string
sheathing
string
sleeves
string
stocking
string
straps
string
stretch
string
suspenders
string
transparency
string
underwires
string
stock
number0
stocks
Query
Template: /system/api/product/stocks.cfc:25
Execution Time: 3.25 ms
Record Count: 2
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select * from (
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = 'BCA82ABB-58B7-47DD-BFD40C8D7C734527'
and product_variations.isactive = 1
and product_sizes.id_size = 567
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 = 'BCA82ABB-58B7-47DD-BFD40C8D7C734527'
and product_variations.isactive = 1
and product_sizes.id_size = 568
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
1BCA82ABB-58B7-47DD-BFD40C8D7C7345276EA8988A-88E8-406E-87D5A37528752968567black#000000XL+5-642-4612-1616-2044-4844-4842-4648-5244-4842-46wstocking5-6intlsize24.95830STOCK01000-104005985901986218586-10all
2BCA82ABB-58B7-47DD-BFD40C8D7C734527C8D03A85-49DA-4C23-958861D823D892DB568black#000000XXL+6-746-4816-1820-2248-5048-5046-4852-5448-5046-48wstocking6-7intlsize24.95830STOCK01000-105005985901986218593-10all
subcategory
stringstocking
supplier
number-1
supplierreference
string598
tags
string
themes
stringluxe
totalvariations
number2
type
stringdefault
unitprice
number24.9583
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 3.95 ms
Record Count: 2
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = 'BCA82ABB-58B7-47DD-BFD40C8D7C734527' 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 = 'BCA82ABB-58B7-47DD-BFD40C8D7C734527' 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 = 'BCA82ABB-58B7-47DD-BFD40C8D7C734527' 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 = 'BCA82ABB-58B7-47DD-BFD40C8D7C734527' 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 = 'BCA82ABB-58B7-47DD-BFD40C8D7C734527' 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 = 'BCA82ABB-58B7-47DD-BFD40C8D7C734527' 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 = 'BCA82ABB-58B7-47DD-BFD40C8D7C734527'
and product_variations.isactive = 1
and product_sizes.id_size = 567
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 = 'BCA82ABB-58B7-47DD-BFD40C8D7C734527' 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 = 'BCA82ABB-58B7-47DD-BFD40C8D7C734527' 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 = 'BCA82ABB-58B7-47DD-BFD40C8D7C734527' 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 = 'BCA82ABB-58B7-47DD-BFD40C8D7C734527' 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 = 'BCA82ABB-58B7-47DD-BFD40C8D7C734527' 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 = 'BCA82ABB-58B7-47DD-BFD40C8D7C734527' 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 = 'BCA82ABB-58B7-47DD-BFD40C8D7C734527'
and product_variations.isactive = 1
and product_sizes.id_size = 568
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
16EA8988A-88E8-406E-87D5A37528752968567black#000000XL+5-642-4612-1616-2044-4844-4842-4648-5244-4842-46wstocking5-6intlsize24.95830STOCK01000-104005985901986218586-10-10-10024.9583all
2C8D03A85-49DA-4C23-958861D823D892DB568black#000000XXL+6-746-4816-1820-2248-5048-5046-4852-5448-5046-48wstocking6-7intlsize24.95830STOCK01000-105005985901986218593-10-10-10024.9583all
vatrate
number20
warehouse
number0