O meu cesto

❌
Total de itens
Ver cesto
Menu
Siehe Größen
Kleid Eline mit Schnürung
Doppelklicken Sie zum Vergrößern
SKU: LFNU8067
Vestido Eline com laço
Lager:

Lassen Sie sich die Gelegenheit nicht entgehen, dieses außergewöhnliche Kleid zu erwerben und bei jedem Anlass für Aufsehen zu sorgen. Lassen Sie sich von seinem einzigartigen Look und seiner tadellosen Qualität verführen.

Größe:

Sie wissen nicht, welche Größe Sie wählen sollen? Sehen Sie sich unseren Größenratgeber an

Farbe:
Menge:
64.95 €
Fundierte Ratschläge
per Chat, Facebook oder E-Mail
Kostenlose Rücksendungen
innerhalb von 15 Tagen *

Kleid in großen Größen aus Vinyl mit Schnürung

Produktbeschreibung

Das Eline-Kleid mit Schnürung ist ein Fetisch-Outfit, das schnell zu einem unverzichtbaren Stück in Ihrem Boudoir werden wird.

Das Design dieses Kleides ist elegant und sexy zugleich. Der Reißverschluss am Rücken verleiht ihm einen Hauch von Raffinesse. Durch die Korsettschnürung vorne wird Ihre Silhouette betont und ein Wespentaillen-Effekt erzeugt.

Dieses Kleid ist aus hochwertigen Materialien gefertigt, bietet optimalen Tragekomfort und ist gleichzeitig strapazierfähig. Sein Vinylstoff verleiht ihm einen einzigartigen, trendigen Look - ideal für Frauen, die sich gerne von der Masse abheben.

Ob für einen Abend mit Freunden, einen romantischen Ausflug oder eine Party, das Eline-Kleid mit Schnürung wird Ihr Verbündeter sein, um alle Blicke auf sich zu ziehen. Sein gewagter und moderner Stil macht es zur perfekten Wahl für Frauen, die ihre Persönlichkeit und ihren Stil unterstreichen möchten.


Technische Details

Verfügbare Größen

Erhältlich von XL bis 3XL

Verfügbare Farbe

Schwarz

Zusammensetzung

Polyurethan 55 %
Polyester 45 %

Weitere technische Daten

Material Vinyl

Größenanleitung

Uberprüfen Sie die für Sie passende Größe

International
  • Brust
  • Größe
  • Hüften
XL
  • 104-108
  • 80-86
  • 106-110
2XL
  • 108-112
  • 86-92
  • 110-114
3XL
  • 112-114
  • 92-98
  • 114-118
To Top
Zum Warenkorb
Artikel
Gesamtartikel
Struct
Entries: 108
actions
Array
available
number-1
brand
stringsoisbelle
brandcode
stringswta
branding
stringdivasboudoir,smboudoir
brandmedias
string{"default":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"editorial":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"logo":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""}}
brandmetas
Struct
de
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
el
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
en
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
es
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
fr
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
it
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
nl
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
pt
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
brandname
stringSois Belle
breasts
stringna
careinstructions
string
categories
stringdivasboudoir.cabaret.dresses.all
category
stringdresses
categorygender
stringf
categorymediadatas
Struct
adult
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string615
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/cabaret/dresses1.jpg
type
stringimg
width
string1336
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.695 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 = 'EF4B9A13-17D4-481D-A53544EC37F8E9A9'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1blackcolorblakblackblack#000000-12
colorrange
stringblack
colors
stringblack
colortype
stringcolor
comments
string
compositions
Struct
Entries: 13
coton
string
elastane
string
free
string
leather
string
lycra
string
metal
string
nylon
string
polyamide
string
polyester
string45
polyurethane
string55
silk
string
spandex
string
viscose
string
datecreated
Date Time (Europe/Paris)
{ts '2023-10-23 16:31:52'}
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
booleanfalse
hascolorinfos
booleantrue
hascompositions
booleantrue
hasdescription
booleantrue
hasdimensions
booleanfalse
hasmaterials
booleantrue
hasotherspecifications
booleanfalse
haspromo
number0
hasshortdescription
booleantrue
hassizeinfos
booleantrue
hasspecifications
booleanfalse
hasstockinfos
booleanfalse
hasstylingtips
booleanfalse
hasusageinstructions
booleanfalse
hasvariations
booleantrue
import
string
inpromo
number0
instockvariations
string
isactive
number1
iscustommade
number0
isdivasize
number0
isfirstprice
number0
isfixedprice
number0
ishot
number0
isnew
number0
isonline
number0
isoutletprice
number0
itemprice
number54.125
itempromo
string
key
string9521-bk-robe-vinyle-laage-corset-devant
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-09-12 16:18:50'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.601 ms
Record Count: 0
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select cart_actions.*
from cart_actions
where cart_actions.branding IN ('all','divasboudoir')
and cart_actions.language IN ('all','pt')
and (cart_actions.quotas = -1 or (cart_actions.usedCount < cart_actions.quotas))
and cart_actions.isactive = 1
and (date(cart_actions.activeFrom) <= '2025-11-24' OR cart_actions.activeFrom is null)
and (date(cart_actions.activeTo) >= '2025-11-24' OR cart_actions.activeTo is null)
and (
FIND_IN_SET('ef4b9a13-17d4-481d-a53544ec37f8e9a9',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.31 ms
Record Count: 0
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select products.productuid as productuid, products.reference, 'default' as type, products.key, products.language, products.name,
product_links.linkuid,
products.colors, products.vatrate, products.metadatas, products.dimensions,
products.mediadatas, products.tags, products.themes, products.isdivasize,
count(distinct product_variations.variationuid) as totalvariations,
group_concat(distinct product_variations.variationuid) as variationlist,
count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END) as inpromo,
if(count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END)>0,1,0) as haspromo,
(select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0) END)) as itempromo,
IFNULL(min(product_variations.itemprice),0) as itemprice,
(select IF (products.isfixedprice = 0 and sum(product_variations.itempromo) > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null), IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0), IFNULL(min(NULLIF(product_variations.itemprice, 0)), 0) )) as unitprice,
count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.itempromo ELSE product_variations.itemprice END) as prices,
(select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN min(NULLIF(product_variations.promountil, 0)) END)) as promountil,
products.isfixedprice, products.ishot, products.isnew, if(products.orderidx > 0, products.orderidx, 999999999) as orderidx,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
count(distinct CASE WHEN ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) > 0 OR ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) <= 0 AND product_variations.supplier = 0)) THEN product_variations.variationuid END) as instockvariations,
products.brand, brands.name as brandname, IFNULL(brands.ispublic, 0) as showbrand, brands.display,
product_categories.sizetype,GROUP_CONCAT(DISTINCT product_sizes.suppliersize) as intlsize,products.sizes,product_sizes.sizerange,product_categories.mediadatas as categorymediadatas, product_categories.sizerange as categorysizerange,
product_categorymap.section, product_categorymap.category, product_categorymap.key as subcategory
from products
left outer join product_categorymap on products.productuid = product_categorymap.productuid
left outer join product_categories on (product_categories.branding = product_categorymap.branding and product_categories.section = product_categorymap.section and product_categories.category = product_categorymap.category and product_categories.key = product_categorymap.key)
left outer join product_sizes on product_sizes.id_size IN (products.sizes)
left outer join brands on products.brand = brands.brand
left outer join product_variations on product_variations.productuid = products.productuid and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
left outer join product_links on product_links.reference = products.reference
where products.isactive = 1 and products.isdeleted = 0
and brands.isactive = 1 and brands.isdeleted = 0
and product_categories.isactive = 1 and product_categories.isdeleted = 0
and product_variations.isactive = 1
and FIND_IN_SET('divasboudoir',products.branding)
and product_categories.branding IN ('all','divasboudoir')
and product_categorymap.branding IN ('all','divasboudoir')
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and products.language in ('all','pt')
and product_categories.language in ('all','pt')
and (products.displayFrom <= DATE(NOW()) or products.displayFrom is null)
and (products.displayTo >= DATE(NOW()) or products.displayTo IS null)
and product_links.linkuid = '' and product_links.linkuid is not null and product_links.linkuid <> ''
and products.reference <> 'LFNU8067'
group by products.reference
order by products.ishot desc, products.isnew desc, orderidx asc, products.lastupdated desc
productuidreferencetypekeylanguagenamelinkuidcolorsvatratemetadatasdimensionsmediadatastagsthemesisdivasizetotalvariationsvariationlistinpromohaspromoitempromoitempriceunitpricepricespromountilisfixedpriceishotisneworderidxavailablestockinstockvariationsbrandbrandnameshowbranddisplaysizetypeintlsizesizessizerangecategorymediadatascategorysizerangesectioncategorysubcategory
linkuid
string
materials
stringvinyl
mediadatas
Struct
alt
Struct
height
string2891
isprivate
string0
rating
stringall
src
string/photobank/products/swta/lfnu8067/side.jpg
type
stringimg
width
string2000
back
Struct
height
string2890
isprivate
string0
rating
stringall
src
string/photobank/products/swta/lfnu8067/back.jpg
type
stringimg
width
string2000
default
Struct
height
string1768
isprivate
string0
rating
stringall
src
string/photobank/products/swta/lfnu8067/24844329.jpg
type
stringimg
width
string1223
variations
Struct
colors
Struct
black
Struct
height
string1768
isprivate
string0
rating
stringall
src
string/photobank/products/swta/lfnu8067/24844329.jpg
type
stringimg
width
string1223
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
mediagallery
string
metadatas
Struct
darkboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
divasboudoir
Struct
de
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p><span>Das Eline-Kleid mit Schn&uuml;rung ist ein Fetisch-Outfit, das schnell zu einem unverzichtbaren St&uuml;ck in Ihrem Boudoir werden wird. </span><br /><br /><span>Das Design dieses Kleides ist elegant und sexy zugleich. Der Rei&szlig;verschluss am R&uuml;cken verleiht ihm einen Hauch von Raffinesse. Durch die Korsettschn&uuml;rung vorne wird Ihre Silhouette betont und ein Wespentaillen-Effekt erzeugt.</span><br /><br /><span>Dieses Kleid ist aus hochwertigen Materialien gefertigt, bietet optimalen Tragekomfort und ist gleichzeitig strapazierf&auml;hig. Sein Vinylstoff verleiht ihm einen einzigartigen, trendigen Look - ideal f&uuml;r Frauen, die sich gerne von der Masse abheben.</span><br /><br /><span>Ob f&uuml;r einen Abend mit Freunden, einen romantischen Ausflug oder eine Party, das Eline-Kleid mit Schn&uuml;rung wird Ihr Verb&uuml;ndeter sein, um alle Blicke auf sich zu ziehen. Sein gewagter und moderner Stil macht es zur perfekten Wahl f&uuml;r Frauen, die ihre Pers&ouml;nlichkeit und ihren Stil unterstreichen m&ouml;chten.</span><br /><br /><br /></p>
guid
stringhttps://dev.divasboudoir.com/de/kleid-in-grossen-grossen-aus-vinyl-mit-schnurung-schwarz/lfnu8067.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringEntdecken Sie unser unglaubliches Eline-Kleid in Übergröße mit Vinyl-Schnürung, ein sexy, figurformendes Fetisch-Outfit, das Ihre Figur perfekt zur Geltung bringt. Bestellen Sie jetzt und profitieren Sie von einer schnellen und diskreten Lieferung
keywords
string
title
stringEline Fetischkleid in Übergröße - Sexy und figurformend
seotitle
stringKleid in großen Größen aus Vinyl mit Schnürung
seouri
stringkleid-in-grossen-grossen-aus-vinyl-mit-schnurung-schwarz
specifications
string
stylingtips
string
summary
string<p><span>Lassen Sie sich die Gelegenheit nicht entgehen, dieses au&szlig;ergew&ouml;hnliche Kleid zu erwerben und bei jedem Anlass f&uuml;r Aufsehen zu sorgen. Lassen Sie sich von seinem einzigartigen Look und seiner tadellosen Qualit&auml;t verf&uuml;hren.</span></p>
title
stringKleid Eline mit Schnürung
usageinstructions
string
el
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p><span>&Tau;&omicron; &phi;ό&rho;&epsilon;&mu;&alpha; &mu;&epsilon; &kappa;&omicron;&rho;&delta;ό&nu;&iota;&alpha; Eline &epsilon;ί&nu;&alpha;&iota; έ&nu;&alpha; &phi;ό&rho;&epsilon;&mu;&alpha; &phi;&epsilon;&tau;ί&chi; &pi;&omicron;&upsilon; &gamma;&rho;ή&gamma;&omicron;&rho;&alpha; &theta;&alpha; &gamma;ί&nu;&epsilon;&iota; must-have &sigma;&tau;&omicron; &mu;&pi;&omicron;&upsilon;&nu;&tau;&omicron;&upsilon;ά&rho; &sigma;&alpha;&sigmaf;. </span><br /><br /><span>&Omicron; &sigma;&chi;&epsilon;&delta;&iota;&alpha;&sigma;&mu;ό&sigmaf; &alpha;&upsilon;&tau;&omicron;ύ &tau;&omicron;&upsilon; &phi;&omicron;&rho;έ&mu;&alpha;&tau;&omicron;&sigmaf; &epsilon;ί&nu;&alpha;&iota; &tau;&alpha;&upsilon;&tau;ό&chi;&rho;&omicron;&nu;&alpha; &kappa;&omicron;&mu;&psi;ό&sigmaf; &kappa;&alpha;&iota; &sigma;έ&xi;&iota;, &mu;&epsilon; έ&nu;&alpha; &phi;&epsilon;&rho;&mu;&omicron;&upsilon;ά&rho; &sigma;&tau;&eta;&nu; &pi;&lambda;ά&tau;&eta; &pi;&omicron;&upsilon; &pi;&rho;&omicron;&sigma;&theta;έ&tau;&epsilon;&iota; &mu;&iota;&alpha; &pi;&iota;&nu;&epsilon;&lambda;&iota;ά &epsilon;&kappa;&lambda;έ&pi;&tau;&upsilon;&nu;&sigma;&eta;&sigmaf;. &Tau;&omicron; &kappa;&omicron;&rho;&sigma;έ &mu;&epsilon; &kappa;&omicron;&rho;&delta;ό&nu;&iota;&alpha; &sigma;&tau;&omicron; &mu;&pi;&rho;&omicron;&sigma;&tau;&iota;&nu;ό &mu;έ&rho;&omicron;&sigmaf; &epsilon;&nu;&iota;&sigma;&chi;ύ&epsilon;&iota; &tau;&eta; &sigma;&iota;&lambda;&omicron;&upsilon;έ&tau;&alpha; &sigma;&alpha;&sigmaf; &kappa;&alpha;&iota; &delta;&eta;&mu;&iota;&omicron;&upsilon;&rho;&gamma;&epsilon;ί έ&nu;&alpha; &epsilon;&phi;έ &sigma;&phi;ή&kappa;&alpha;&sigmaf; &sigma;&tau;&eta; &mu;έ&sigma;&eta;.</span><br /><br /><span>&Kappa;&alpha;&tau;&alpha;&sigma;&kappa;&epsilon;&upsilon;&alpha;&sigma;&mu;έ&nu;&omicron; &alpha;&pi;ό &upsilon;&lambda;&iota;&kappa;ά &upsilon;&psi;&eta;&lambda;ή&sigmaf; &pi;&omicron;&iota;ό&tau;&eta;&tau;&alpha;&sigmaf;, &alpha;&upsilon;&tau;ό &tau;&omicron; &phi;ό&rho;&epsilon;&mu;&alpha; &pi;&rho;&omicron;&sigma;&phi;έ&rho;&epsilon;&iota; &beta;έ&lambda;&tau;&iota;&sigma;&tau;&eta; ά&nu;&epsilon;&sigma;&eta; &epsilon;&nu;ώ &epsilon;ί&nu;&alpha;&iota; &alpha;&nu;&theta;&epsilon;&kappa;&tau;&iota;&kappa;ό. &Tau;&omicron; &beta;&iota;&nu;&upsilon;&lambda;&lambda;&iota;&kappa;ό &tau;&omicron;&upsilon; ύ&phi;&alpha;&sigma;&mu;&alpha; &tau;&omicron;&upsilon; &pi;&rho;&omicron;&sigma;&delta;ί&delta;&epsilon;&iota; &mu;&iota;&alpha; &mu;&omicron;&nu;&alpha;&delta;&iota;&kappa;ή, &mu;&omicron;&nu;&tau;έ&rho;&nu;&alpha; &epsilon;&mu;&phi;ά&nu;&iota;&sigma;&eta;, &iota;&delta;&alpha;&nu;&iota;&kappa;ή &gamma;&iota;&alpha; &gamma;&upsilon;&nu;&alpha;ί&kappa;&epsilon;&sigmaf; &pi;&omicron;&upsilon; &theta;έ&lambda;&omicron;&upsilon;&nu; &nu;&alpha; &xi;&epsilon;&chi;&omega;&rho;ί&zeta;&omicron;&upsilon;&nu; &alpha;&pi;ό &tau;&omicron; &pi;&lambda;ή&theta;&omicron;&sigmaf;.</span><br /><br /><span>&Epsilon;ί&tau;&epsilon; &pi;&rho;ό&kappa;&epsilon;&iota;&tau;&alpha;&iota; &gamma;&iota;&alpha; &mu;&iota;&alpha; &beta;&rho;&alpha;&delta;&iota;&nu;ή έ&xi;&omicron;&delta;&omicron; &mu;&epsilon; &phi;ί&lambda;&omicron;&upsilon;&sigmaf;, &epsilon;ί&tau;&epsilon; &gamma;&iota;&alpha; έ&nu;&alpha; &rho;&alpha;&nu;&tau;&epsilon;&beta;&omicron;ύ ή έ&nu;&alpha; &pi;ά&rho;&tau;&iota;, &tau;&omicron; &phi;ό&rho;&epsilon;&mu;&alpha; Eline &mu;&epsilon; &lambda;&epsilon;&pi;&tau;&omicron;&mu;έ&rho;&epsilon;&iota;&alpha; &alpha;&pi;ό &kappa;&omicron;&rho;&delta;ό&nu;&iota;&alpha; &theta;&alpha; &tau;&rho;&alpha;&beta;ή&xi;&epsilon;&iota; &sigma;ί&gamma;&omicron;&upsilon;&rho;&alpha; &tau;&alpha; &beta;&lambda;έ&mu;&mu;&alpha;&tau;&alpha; ό&lambda;&omega;&nu;. &Tau;&omicron; &tau;&omicron;&lambda;&mu;&eta;&rho;ό, &mu;&omicron;&nu;&tau;έ&rho;&nu;&omicron; &sigma;&tau;&upsilon;&lambda; &tau;&omicron;&upsilon; &tau;&omicron; &kappa;&alpha;&theta;&iota;&sigma;&tau;ά &tau;&eta;&nu; &iota;&delta;&alpha;&nu;&iota;&kappa;ή &epsilon;&pi;&iota;&lambda;&omicron;&gamma;ή &gamma;&iota;&alpha; &tau;&iota;&sigmaf; &gamma;&upsilon;&nu;&alpha;ί&kappa;&epsilon;&sigmaf; &pi;&omicron;&upsilon; &theta;έ&lambda;&omicron;&upsilon;&nu; &nu;&alpha; &epsilon;&pi;&iota;&beta;&epsilon;&beta;&alpha;&iota;ώ&sigma;&omicron;&upsilon;&nu; &tau;&eta;&nu; &pi;&rho;&omicron;&sigma;&omega;&pi;&iota;&kappa;ό&tau;&eta;&tau;&alpha; &kappa;&alpha;&iota; &tau;&omicron; &sigma;&tau;&upsilon;&lambda; &tau;&omicron;&upsilon;&sigmaf;.</span><br /><br /><br /></p>
guid
stringhttps://dev.divasboudoir.com/el/forema-megaloy-megethoys-apo-vinylio-me-kordonia-mayro/lfnu8067.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringΑνακαλύψτε το απίστευτο φόρεμα Eline plus size με κορδόνια βινυλίου, ένα σέξι, καλλίγραμμο και φετίχ φόρεμα που θα αναδείξει τη σιλουέτα σας. Παραγγείλετε τώρα και απολαύστε γρήγορη, διακριτική παράδοση
keywords
string
title
stringΦόρεμα μεγάλου μεγέθους από βινύλιο με κορδόνια
seotitle
stringΦόρεμα μεγάλου μεγέθους από βινύλιο με κορδόνια
seouri
stringforema-megaloy-megethoys-apo-vinylio-me-kordonia-mayro
specifications
string
stylingtips
string
summary
string<p><span>&Mu;&eta;&nu; &chi;ά&sigma;&epsilon;&tau;&epsilon; &tau;&eta;&nu; &epsilon;&upsilon;&kappa;&alpha;&iota;&rho;ί&alpha; &nu;&alpha; &alpha;&gamma;&omicron;&rho;ά&sigma;&epsilon;&tau;&epsilon; &alpha;&upsilon;&tau;ό &tau;&omicron; &epsilon;&xi;&alpha;&iota;&rho;&epsilon;&tau;&iota;&kappa;ό &phi;ό&rho;&epsilon;&mu;&alpha; &kappa;&alpha;&iota; &nu;&alpha; &kappa;ά&nu;&epsilon;&tau;&epsilon; &alpha;ί&sigma;&theta;&eta;&sigma;&eta; &sigma;&epsilon; &kappa;ά&theta;&epsilon; &pi;&epsilon;&rho;ί&sigma;&tau;&alpha;&sigma;&eta;. &Alpha;&phi;ή&sigma;&tau;&epsilon; &tau;&omicron;&nu; &epsilon;&alpha;&upsilon;&tau;ό &sigma;&alpha;&sigmaf; &nu;&alpha; &pi;&alpha;&rho;&alpha;&sigma;&upsilon;&rho;&theta;&epsilon;ί &alpha;&pi;ό &tau;&eta; &mu;&omicron;&nu;&alpha;&delta;&iota;&kappa;ή &gamma;&omicron;&eta;&tau;&epsilon;ί&alpha; &kappa;&alpha;&iota; &tau;&eta;&nu; ά&psi;&omicron;&gamma;&eta; &pi;&omicron;&iota;ό&tau;&eta;&tau;ά &tau;&omicron;&upsilon;.</span></p>
title
stringΦόρεμα Eline με κορδόνια
usageinstructions
string
en
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p><span>The Eline lace-up dress is a fetish outfit that will quickly become a staple in your boudoir. </span><br /><br /><span>The design of this dress is both elegant and sexy, with a back zip that adds a touch of sophistication. The corset lacing fit in front enhances your silhouette and creates a wasp-waist effect.</span><br /><br /><span>Made from high-quality materials, this dress offers optimal comfort while being durable. Its vinyl fabric gives it a unique, on-trend look, ideal for women who like to stand out from the crowd.</span><br /><br /><span>Whether it's for a night out with friends, a romantic date or a party, the Eline dress with lacing will be your eye-catching ally. Its bold, modern style makes it the perfect choice for those who want to assert their personality and style.</span><br /><br /><br /></p>
guid
stringhttps://dev.divasboudoir.com/en/plus-size-dress-in-lace-up-vinyl-black/lfnu8067.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringDiscover our incredible Eline plus size dress with vinyl laces, a sexy, shapely, fetish outfit that will enhance your figure. Order now for fast, discreet delivery
keywords
string
title
stringPlus size fetish dress Eline - Sexy and shapely
seotitle
stringPlus size dress in lace-up vinyl
seouri
stringplus-size-dress-in-lace-up-vinyl-black
specifications
string
stylingtips
string
summary
string<p><span>Don't miss the chance to buy this exceptional dress and make a splash on every occasion. Let yourself be seduced by its unique allure and impeccable quality.</span></p>
title
stringEline dress with lacing
usageinstructions
string
es
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p><span>El vestido con cordones Eline es un conjunto fetichista que se convertir&aacute; r&aacute;pidamente en imprescindible en su tocador. </span><br /><br /><span>El dise&ntilde;o de este vestido es a la vez elegante y sexy, con una cremallera en la espalda que a&ntilde;ade un toque de sofisticaci&oacute;n. El cord&oacute;n cors&eacute; de la parte delantera realza la silueta y crea un efecto de cintura de avispa.</span><br /><br /><span>Fabricado con materiales de alta calidad, este vestido ofrece un confort &oacute;ptimo a la vez que es resistente. Su tejido de vinilo le confiere un aspecto &uacute;nico y de tendencia, ideal para las mujeres a las que les gusta destacar entre la multitud.</span><br /><br /><span>Ya sea para una noche entre amigos, una cita o una fiesta, el vestido Eline con detalle de cordones atraer&aacute; todas las miradas. Su estilo atrevido y moderno lo convierte en la elecci&oacute;n perfecta para las mujeres que desean afirmar su personalidad y estilo.</span><br /><br /><br /></p>
guid
stringhttps://dev.divasboudoir.com/es/vestido-talla-grande-en-vinilo-con-lazada-negro/lfnu8067.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringDescubre nuestro increíble vestido de talla grande Eline con encajes de vinilo, un conjunto sexy, torneado y fetichista que realzará tu figura. Haz tu pedido ahora y disfruta de una entrega rápida y discreta
keywords
string
title
stringVestido fetiche talla grande Eline - Sexy y bien formada
seotitle
stringVestido talla grande en vinilo con lazada
seouri
stringvestido-talla-grande-en-vinilo-con-lazada-negro
specifications
string
stylingtips
string
summary
string<p><span>No pierdas la oportunidad de comprar este vestido excepcional y causar sensaci&oacute;n en cualquier ocasi&oacute;n. D&eacute;jate seducir por su encanto &uacute;nico y su calidad impecable.</span></p>
title
stringVestido Eline con lazada
usageinstructions
string
fr
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p><span>La robe Eline &agrave; la&ccedil;age est une tenue f&eacute;tichiste qui deviendra vite une pi&egrave;ce incontournable de votre boudoir.&nbsp;</span><br><br><span>Le design de cette robe est &agrave; la fois &eacute;l&eacute;gant et sexy, avec un zip dans le dos qui ajoute une touche de sophistication. L'ajustement la&ccedil;age corset devant permet de mettre en valeur votre silhouette et de cr&eacute;er un effet de taille de gu&ecirc;pe.</span><br><br><span>Fabriqu&eacute;e avec des mat&eacute;riaux de haute qualit&eacute;, cette robe offre un confort optimal tout en &eacute;tant r&eacute;sistante. Son tissu en vinyle lui conf&egrave;re une allure unique et tendance, id&eacute;ale pour les femmes qui aiment se d&eacute;marquer.</span><br><br><span>Que ce soit pour une soir&eacute;e entre amis, une sortie en amoureux ou une f&ecirc;te, la robe Eline &agrave; la&ccedil;age sera votre alli&eacute;e pour attirer tous les regards. Son style audacieux et moderne en fait un choix parfait pour celles qui souhaitent affirmer leur personnalit&eacute; et leur style.</span><br><br><br></p>
guid
stringhttps://dev.divasboudoir.com/fr/robe-grande-taille-en-vinyle-a-lacages-noir/lfnu8067.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringDécouvrez notre incroyable robe grande taille Eline à lacets en vinyle, une tenue sexy, galbante et fétichiste qui mettra en valeur votre silhouette.
keywords
string
title
stringRobe Fétichiste grande taille Eline - Sexy et galbante
seotitle
stringRobe grande taille en vinyle à laçages
seouri
stringrobe-grande-taille-en-vinyle-a-lacages-noir
specifications
string
stylingtips
string
summary
string<p><span>Ne manquez pas l'occasion de vous procurer cette robe exceptionnelle et de faire sensation &agrave; chaque occasion. Laissez-vous s&eacute;duire par son allure unique et sa qualit&eacute; irr&eacute;prochable.</span></p>
title
stringRobe Eline à laçage
usageinstructions
string
it
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p><span>L'abito con lacci Eline &egrave; un abito fetish che diventer&agrave; rapidamente un must del vostro boudoir. </span><br /><br /><span>Il design di questo abito &egrave; elegante e sexy al tempo stesso, con una zip sul retro che aggiunge un tocco di raffinatezza. L'allacciatura a corsetto sul davanti esalta la vostra silhouette e crea un effetto wasp-waist.</span><br /><br /><span>Realizzato con materiali di alta qualit&agrave;, questo abito offre un comfort ottimale e allo stesso tempo &egrave; resistente. Il tessuto vinilico gli conferisce un look unico e di tendenza, ideale per le donne che amano distinguersi dalla massa.</span><br /><br /><span>Che si tratti di una serata con gli amici, di un appuntamento o di una festa, l'abito Eline con dettagli in pizzo attirer&agrave; sicuramente l'attenzione di tutti. Il suo stile audace e moderno lo rende la scelta perfetta per le donne che vogliono affermare la propria personalit&agrave; e il proprio stile.</span><br /><br /><br /></p>
guid
stringhttps://dev.divasboudoir.com/it/abito-di-taglia-grande-in-vinile-con-allacciatura-nero/lfnu8067.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringScoprite il nostro incredibile abito Eline taglia grande con lacci in vinile, un vestito sexy, formoso e fetish che valorizzerà la vostra figura. Ordinate subito e godetevi una consegna rapida e discreta
keywords
string
title
stringAbito fetish Eline taglia grande - Sexy e formoso
seotitle
stringAbito di taglia grande in vinile con allacciatura
seouri
stringabito-di-taglia-grande-in-vinile-con-allacciatura-nero
specifications
string
stylingtips
string
summary
string<p><span>Non perdete l'occasione di acquistare questo abito eccezionale e di fare colpo in ogni occasione. Lasciatevi sedurre dal suo fascino unico e dalla sua qualit&agrave; impeccabile.</span></p>
title
stringAbito Eline con allacciatura
usageinstructions
string
nl
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p><span>De Eline jurk met kant is een fetish outfit die snel een must-have in je boudoir zal worden. </span><br /><br /><span>Het ontwerp van deze jurk is zowel elegant als sexy, met een rits aan de achterkant die een vleugje verfijning toevoegt. De korsetveter aan de voorkant verbetert je silhouet en cre&euml;ert een wespentaille-effect.</span><br /><br /><span>Deze jurk is gemaakt van hoogwaardige materialen en biedt optimaal comfort terwijl hij toch slijtvast is. De vinyl stof geeft het een unieke, on-trend look, ideaal voor vrouwen die zich graag onderscheiden van de massa.</span><br /><br /><span>Of het nu voor een avondje uit met vrienden, een date of een feestje is, de Eline jurk met veterdetail zal zeker bij iedereen in het oog springen. De gedurfde, moderne stijl maakt het de perfecte keuze voor vrouwen die hun persoonlijkheid en stijl willen laten gelden.</span><br /><br /><br /></p>
guid
stringhttps://dev.divasboudoir.com/nl/groote-maat-jurk-van-vinyl-met-vetersluiting-zwart/lfnu8067.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringOntdek onze ongelooflijke Eline jurk met veters van vinyl voor groote maten, een sexy, welgevormde en fetisjistische outfit die je figuur zal verbeteren. Bestel nu en geniet van een snelle, discrete levering
keywords
string
title
stringEline fetisj jurkje van groote maat - Sexy en welgevormd
seotitle
stringGroote maat jurk van vinyl met vetersluiting
seouri
stringgroote-maat-jurk-van-vinyl-met-vetersluiting-zwart
specifications
string
stylingtips
string
summary
string<p><span>Mis de kans niet om deze uitzonderlijke jurk te kopen en bij elke gelegenheid op te vallen. Laat je verleiden door zijn unieke allure en onberispelijke kwaliteit.</span></p>
title
stringEline jurk met vetersluiting
usageinstructions
string
pt
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p><span>O vestido com renda Eline &eacute; um traje fetiche que rapidamente se tornar&aacute; um must-have no seu boudoir. </span><br /><br /><span>O design deste vestido &eacute; ao mesmo tempo elegante e sexy, com um fecho de correr nas costas a dar um toque de sofistica&ccedil;&atilde;o. O la&ccedil;o do espartilho &agrave; frente real&ccedil;a a sua silhueta e cria um efeito de cintura de vespa.</span><br /><br /><span>Fabricado com materiais de alta qualidade, este vestido oferece um conforto &oacute;timo e &eacute; resistente. O seu tecido de vinil confere-lhe um aspeto &uacute;nico e atual, ideal para as mulheres que gostam de se destacar da multid&atilde;o.</span><br /><br /><span>Quer seja para uma sa&iacute;da &agrave; noite com os amigos, um encontro ou uma festa, o vestido Eline com pormenor de renda chamar&aacute; a aten&ccedil;&atilde;o de todos. O seu estilo arrojado e moderno torna-o a escolha perfeita para as mulheres que querem afirmar a sua personalidade e estilo.</span><br /><br /><br /></p>
guid
stringhttps://dev.divasboudoir.com/pt/vestido-de-tamanho-grande-em-vinil-com-laco-preto/lfnu8067.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringDescubra o nosso incrível vestido plus size Eline com atacadores de vinil, um conjunto sexy, torneado e fetichista que irá realçar a sua figura. Encomende agora e desfrute de uma entrega rápida e discreta
keywords
string
title
stringVestido fetiche Eline plus size - Sexy e bem torneado
seotitle
stringVestido de tamanho grande em vinil com laço
seouri
stringvestido-de-tamanho-grande-em-vinil-com-laco-preto
specifications
string
stylingtips
string
summary
string<p><span>N&atilde;o perca a oportunidade de comprar este vestido excecional e de fazer furor em todas as ocasi&otilde;es. Deixe-se seduzir pelo seu encanto &uacute;nico e pela sua qualidade impec&aacute;vel.</span></p>
title
stringVestido Eline com laço
usageinstructions
string
fetishboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
latexboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
legsboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
lustboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
smboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>Das Eline-Kleid mit Schn&uuml;rung ist ein Fetisch-Outfit, das schnell zu einem unverzichtbaren St&uuml;ck in Ihrem Boudoir werden wird. </span><br /><br /><span>Das Design dieses Kleides ist elegant und sexy zugleich. Der Rei&szlig;verschluss am R&uuml;cken verleiht ihm einen Hauch von Raffinesse. Durch die Korsettschn&uuml;rung vorne wird Ihre Silhouette betont und ein Wespentaillen-Effekt erzeugt.</span><br /><br /><span>Dieses Kleid ist aus hochwertigen Materialien gefertigt, bietet optimalen Tragekomfort und ist gleichzeitig strapazierf&auml;hig. Sein Vinylstoff verleiht ihm einen einzigartigen, trendigen Look - ideal f&uuml;r Frauen, die sich gerne von der Masse abheben.</span><br /><br /><span>Ob f&uuml;r einen Abend mit Freunden, einen romantischen Ausflug oder eine Party, das Eline-Kleid mit Schn&uuml;rung wird Ihr Verb&uuml;ndeter sein, um alle Blicke auf sich zu ziehen. Sein gewagter und moderner Stil macht es zur perfekten Wahl f&uuml;r Frauen, die ihre Pers&ouml;nlichkeit und ihren Stil unterstreichen m&ouml;chten.</span><br /><br /><br /></p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringEntdecken Sie unser unglaubliches Eline-Kleid mit Vinyl-Schnürung, ein sexy, figurformendes und fetischistisches Outfit, das Ihre Figur betonen wird. Bestellen Sie jetzt und profitieren Sie von einer schnellen und diskreten Lieferung
keywords
string
title
stringKleid Eline mit Vinyl-Schnürung - Sexy, figurformend und fetischistisch
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string<p><span>Lassen Sie sich die Gelegenheit nicht entgehen, dieses au&szlig;ergew&ouml;hnliche Kleid zu erwerben und bei jedem Anlass f&uuml;r Aufsehen zu sorgen. Lassen Sie sich von seinem einzigartigen Look und seiner tadellosen Qualit&auml;t verf&uuml;hren.</span></p>
title
stringKleid Eline mit Schnürung
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>&Tau;&omicron; &phi;ό&rho;&epsilon;&mu;&alpha; &mu;&epsilon; &kappa;&omicron;&rho;&delta;ό&nu;&iota;&alpha; Eline &epsilon;ί&nu;&alpha;&iota; έ&nu;&alpha; &phi;ό&rho;&epsilon;&mu;&alpha; &phi;&epsilon;&tau;ί&chi; &pi;&omicron;&upsilon; &gamma;&rho;ή&gamma;&omicron;&rho;&alpha; &theta;&alpha; &gamma;ί&nu;&epsilon;&iota; must-have &sigma;&tau;&omicron; &mu;&pi;&omicron;&upsilon;&nu;&tau;&omicron;&upsilon;ά&rho; &sigma;&alpha;&sigmaf;. </span><br /><br /><span>&Omicron; &sigma;&chi;&epsilon;&delta;&iota;&alpha;&sigma;&mu;ό&sigmaf; &alpha;&upsilon;&tau;&omicron;ύ &tau;&omicron;&upsilon; &phi;&omicron;&rho;έ&mu;&alpha;&tau;&omicron;&sigmaf; &epsilon;ί&nu;&alpha;&iota; &tau;&alpha;&upsilon;&tau;ό&chi;&rho;&omicron;&nu;&alpha; &kappa;&omicron;&mu;&psi;ό&sigmaf; &kappa;&alpha;&iota; &sigma;έ&xi;&iota;, &mu;&epsilon; έ&nu;&alpha; &phi;&epsilon;&rho;&mu;&omicron;&upsilon;ά&rho; &sigma;&tau;&eta;&nu; &pi;&lambda;ά&tau;&eta; &pi;&omicron;&upsilon; &pi;&rho;&omicron;&sigma;&theta;έ&tau;&epsilon;&iota; &mu;&iota;&alpha; &pi;&iota;&nu;&epsilon;&lambda;&iota;ά &epsilon;&kappa;&lambda;έ&pi;&tau;&upsilon;&nu;&sigma;&eta;&sigmaf;. &Tau;&omicron; &kappa;&omicron;&rho;&sigma;έ &mu;&epsilon; &kappa;&omicron;&rho;&delta;ό&nu;&iota;&alpha; &sigma;&tau;&omicron; &mu;&pi;&rho;&omicron;&sigma;&tau;&iota;&nu;ό &mu;έ&rho;&omicron;&sigmaf; &epsilon;&nu;&iota;&sigma;&chi;ύ&epsilon;&iota; &tau;&eta; &sigma;&iota;&lambda;&omicron;&upsilon;έ&tau;&alpha; &sigma;&alpha;&sigmaf; &kappa;&alpha;&iota; &delta;&eta;&mu;&iota;&omicron;&upsilon;&rho;&gamma;&epsilon;ί έ&nu;&alpha; &epsilon;&phi;έ &sigma;&phi;ή&kappa;&alpha;&sigmaf; &sigma;&tau;&eta; &mu;έ&sigma;&eta;.</span><br /><br /><span>&Kappa;&alpha;&tau;&alpha;&sigma;&kappa;&epsilon;&upsilon;&alpha;&sigma;&mu;έ&nu;&omicron; &alpha;&pi;ό &upsilon;&lambda;&iota;&kappa;ά &upsilon;&psi;&eta;&lambda;ή&sigmaf; &pi;&omicron;&iota;ό&tau;&eta;&tau;&alpha;&sigmaf;, &alpha;&upsilon;&tau;ό &tau;&omicron; &phi;ό&rho;&epsilon;&mu;&alpha; &pi;&rho;&omicron;&sigma;&phi;έ&rho;&epsilon;&iota; &beta;έ&lambda;&tau;&iota;&sigma;&tau;&eta; ά&nu;&epsilon;&sigma;&eta; &epsilon;&nu;ώ &epsilon;ί&nu;&alpha;&iota; &alpha;&nu;&theta;&epsilon;&kappa;&tau;&iota;&kappa;ό. &Tau;&omicron; &beta;&iota;&nu;&upsilon;&lambda;&lambda;&iota;&kappa;ό &tau;&omicron;&upsilon; ύ&phi;&alpha;&sigma;&mu;&alpha; &tau;&omicron;&upsilon; &pi;&rho;&omicron;&sigma;&delta;ί&delta;&epsilon;&iota; &mu;&iota;&alpha; &mu;&omicron;&nu;&alpha;&delta;&iota;&kappa;ή, &mu;&omicron;&nu;&tau;έ&rho;&nu;&alpha; &epsilon;&mu;&phi;ά&nu;&iota;&sigma;&eta;, &iota;&delta;&alpha;&nu;&iota;&kappa;ή &gamma;&iota;&alpha; &gamma;&upsilon;&nu;&alpha;ί&kappa;&epsilon;&sigmaf; &pi;&omicron;&upsilon; &theta;έ&lambda;&omicron;&upsilon;&nu; &nu;&alpha; &xi;&epsilon;&chi;&omega;&rho;ί&zeta;&omicron;&upsilon;&nu; &alpha;&pi;ό &tau;&omicron; &pi;&lambda;ή&theta;&omicron;&sigmaf;.</span><br /><br /><span>&Epsilon;ί&tau;&epsilon; &pi;&rho;ό&kappa;&epsilon;&iota;&tau;&alpha;&iota; &gamma;&iota;&alpha; &mu;&iota;&alpha; &beta;&rho;&alpha;&delta;&iota;&nu;ή έ&xi;&omicron;&delta;&omicron; &mu;&epsilon; &phi;ί&lambda;&omicron;&upsilon;&sigmaf;, &epsilon;ί&tau;&epsilon; &gamma;&iota;&alpha; έ&nu;&alpha; &rho;&alpha;&nu;&tau;&epsilon;&beta;&omicron;ύ ή έ&nu;&alpha; &pi;ά&rho;&tau;&iota;, &tau;&omicron; &phi;ό&rho;&epsilon;&mu;&alpha; Eline &mu;&epsilon; &lambda;&epsilon;&pi;&tau;&omicron;&mu;έ&rho;&epsilon;&iota;&alpha; &alpha;&pi;ό &kappa;&omicron;&rho;&delta;ό&nu;&iota;&alpha; &theta;&alpha; &tau;&rho;&alpha;&beta;ή&xi;&epsilon;&iota; &sigma;ί&gamma;&omicron;&upsilon;&rho;&alpha; &tau;&alpha; &beta;&lambda;έ&mu;&mu;&alpha;&tau;&alpha; ό&lambda;&omega;&nu;. &Tau;&omicron; &tau;&omicron;&lambda;&mu;&eta;&rho;ό, &mu;&omicron;&nu;&tau;έ&rho;&nu;&omicron; &sigma;&tau;&upsilon;&lambda; &tau;&omicron;&upsilon; &tau;&omicron; &kappa;&alpha;&theta;&iota;&sigma;&tau;ά &tau;&eta;&nu; &iota;&delta;&alpha;&nu;&iota;&kappa;ή &epsilon;&pi;&iota;&lambda;&omicron;&gamma;ή &gamma;&iota;&alpha; &tau;&iota;&sigmaf; &gamma;&upsilon;&nu;&alpha;ί&kappa;&epsilon;&sigmaf; &pi;&omicron;&upsilon; &theta;έ&lambda;&omicron;&upsilon;&nu; &nu;&alpha; &epsilon;&pi;&iota;&beta;&epsilon;&beta;&alpha;&iota;ώ&sigma;&omicron;&upsilon;&nu; &tau;&eta;&nu; &pi;&rho;&omicron;&sigma;&omega;&pi;&iota;&kappa;ό&tau;&eta;&tau;&alpha; &kappa;&alpha;&iota; &tau;&omicron; &sigma;&tau;&upsilon;&lambda; &tau;&omicron;&upsilon;&sigmaf;.</span><br /><br /><br /></p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringΑνακαλύψτε το απίστευτο φόρεμά μας Eline με κορδόνια βινυλίου, ένα σέξι, καλλίγραμμο, φετίχ φόρεμα που θα αναδείξει τη σιλουέτα σας. Παραγγείλετε τώρα και απολαύστε γρήγορη, διακριτική παράδοση
keywords
string
title
stringΦόρεμα Eline με κορδόνια
seotitle
stringΦόρεμα Eline με κορδόνια
seouri
stringforema-eline-me-kordonia-mayro
specifications
string
stylingtips
string
summary
string<p><span>&Mu;&eta;&nu; &chi;ά&sigma;&epsilon;&tau;&epsilon; &tau;&eta;&nu; &epsilon;&upsilon;&kappa;&alpha;&iota;&rho;ί&alpha; &nu;&alpha; &alpha;&gamma;&omicron;&rho;ά&sigma;&epsilon;&tau;&epsilon; &alpha;&upsilon;&tau;ό &tau;&omicron; &epsilon;&xi;&alpha;&iota;&rho;&epsilon;&tau;&iota;&kappa;ό &phi;ό&rho;&epsilon;&mu;&alpha; &kappa;&alpha;&iota; &nu;&alpha; &kappa;ά&nu;&epsilon;&tau;&epsilon; &alpha;ί&sigma;&theta;&eta;&sigma;&eta; &sigma;&epsilon; &kappa;ά&theta;&epsilon; &pi;&epsilon;&rho;ί&sigma;&tau;&alpha;&sigma;&eta;. &Alpha;&phi;ή&sigma;&tau;&epsilon; &tau;&omicron;&nu; &epsilon;&alpha;&upsilon;&tau;ό &sigma;&alpha;&sigmaf; &nu;&alpha; &pi;&alpha;&rho;&alpha;&sigma;&upsilon;&rho;&theta;&epsilon;ί &alpha;&pi;ό &tau;&eta; &mu;&omicron;&nu;&alpha;&delta;&iota;&kappa;ή &gamma;&omicron;&eta;&tau;&epsilon;ί&alpha; &kappa;&alpha;&iota; &tau;&eta;&nu; ά&psi;&omicron;&gamma;&eta; &pi;&omicron;&iota;ό&tau;&eta;&tau;ά &tau;&omicron;&upsilon;.</span></p>
title
stringΦόρεμα Eline με κορδόνια
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>The Eline lace-up dress is a fetish outfit that will quickly become a staple in your boudoir. </span><br /><br /><span>The design of this dress is both elegant and sexy, with a back zip that adds a touch of sophistication. The corset lacing fit in front enhances your silhouette and creates a wasp-waist effect.</span><br /><br /><span>Made from high-quality materials, this dress offers optimal comfort while being durable. Its vinyl fabric gives it a unique, on-trend look, ideal for women who like to stand out from the crowd.</span><br /><br /><span>Whether it's for a night out with friends, a romantic date or a party, the Eline dress with lacing will be your eye-catching ally. Its bold, modern style makes it the perfect choice for those who want to assert their personality and style.</span><br /><br /><br /></p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringDiscover our incredible Eline lace-up vinyl dress, a sexy, shapely, fetish outfit that will enhance your figure. Order now and enjoy fast, discreet delivery
keywords
string
title
stringEline dress with vinyl laces - Sexy, shapely and fetishistic
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string<p><span>Don't miss the chance to buy this exceptional dress and make a splash on every occasion. Let yourself be seduced by its unique allure and impeccable quality.</span></p>
title
stringEline dress with lacing
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>El vestido con cordones Eline es un conjunto fetichista que se convertir&aacute; r&aacute;pidamente en imprescindible en su tocador. </span><br /><br /><span>El dise&ntilde;o de este vestido es a la vez elegante y sexy, con una cremallera en la espalda que a&ntilde;ade un toque de sofisticaci&oacute;n. El cord&oacute;n cors&eacute; de la parte delantera realza la silueta y crea un efecto de cintura de avispa.</span><br /><br /><span>Fabricado con materiales de alta calidad, este vestido ofrece un confort &oacute;ptimo a la vez que es resistente. Su tejido de vinilo le confiere un aspecto &uacute;nico y de tendencia, ideal para las mujeres a las que les gusta destacar entre la multitud.</span><br /><br /><span>Ya sea para una noche entre amigos, una cita o una fiesta, el vestido Eline con detalle de cordones atraer&aacute; todas las miradas. Su estilo atrevido y moderno lo convierte en la elecci&oacute;n perfecta para las mujeres que desean afirmar su personalidad y estilo.</span><br /><br /><br /></p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringDescubre nuestro increíble vestido Eline con encajes de vinilo, un conjunto fetichista, sexy y torneado que realzará tu figura. Haz tu pedido ahora y disfruta de una entrega rápida y discreta
keywords
string
title
stringVestido Eline con cordones de vinilo - Sexy, torneado y fetichista
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string<p><span>No pierdas la oportunidad de comprar este vestido excepcional y causar sensaci&oacute;n en cualquier ocasi&oacute;n. D&eacute;jate seducir por su encanto &uacute;nico y su calidad impecable.</span></p>
title
stringVestido Eline con lazada
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>La robe Eline &agrave; la&ccedil;age est une tenue f&eacute;tichiste qui deviendra vite une pi&egrave;ce incontournable de votre boudoir.&nbsp;</span><br><br><span>Le design de cette robe est &agrave; la fois &eacute;l&eacute;gant et sexy, avec un zip dans le dos qui ajoute une touche de sophistication. L'ajustement la&ccedil;age corset devant permet de mettre en valeur votre silhouette et de cr&eacute;er un effet de taille de gu&ecirc;pe.</span><br><br><span>Fabriqu&eacute;e avec des mat&eacute;riaux de haute qualit&eacute;, cette robe offre un confort optimal tout en &eacute;tant r&eacute;sistante. Son tissu en vinyle lui conf&egrave;re une allure unique et tendance, id&eacute;ale pour les femmes qui aiment se d&eacute;marquer.</span><br><br><span>Que ce soit pour une soir&eacute;e entre amis, une sortie en amoureux ou une f&ecirc;te, la robe Eline &agrave; la&ccedil;age sera votre alli&eacute;e pour attirer tous les regards. Son style audacieux et moderne en fait un choix parfait pour celles qui souhaitent affirmer leur personnalit&eacute; et leur style.</span><br><br><br></p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringDécouvrez notre incroyable robe Eline à lacets en vinyle, une tenue sexy, galbante et fétichiste qui mettra en valeur votre silhouette. Commandez dès maintenant et profitez d'une livraison rapide et discrète
keywords
string
title
stringRobe Eline à lacets en vinyle - Sexy, galbante et fétichiste
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string<p><span>Ne manquez pas l'occasion de vous procurer cette robe exceptionnelle et de faire sensation &agrave; chaque occasion. Laissez-vous s&eacute;duire par son allure unique et sa qualit&eacute; irr&eacute;prochable.</span></p>
title
stringRobe Eline à laçage
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>L'abito con lacci Eline &egrave; un abito fetish che diventer&agrave; rapidamente un must del vostro boudoir. </span><br /><br /><span>Il design di questo abito &egrave; elegante e sexy al tempo stesso, con una zip sul retro che aggiunge un tocco di raffinatezza. L'allacciatura a corsetto sul davanti esalta la vostra silhouette e crea un effetto wasp-waist.</span><br /><br /><span>Realizzato con materiali di alta qualit&agrave;, questo abito offre un comfort ottimale e allo stesso tempo &egrave; resistente. Il tessuto vinilico gli conferisce un look unico e di tendenza, ideale per le donne che amano distinguersi dalla massa.</span><br /><br /><span>Che si tratti di una serata con gli amici, di un appuntamento o di una festa, l'abito Eline con dettagli in pizzo attirer&agrave; sicuramente l'attenzione di tutti. Il suo stile audace e moderno lo rende la scelta perfetta per le donne che vogliono affermare la propria personalit&agrave; e il proprio stile.</span><br /><br /><br /></p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringScoprite il nostro incredibile vestito Eline con lacci in vinile, un abito fetish sexy e formoso che esalterà la vostra figura. Ordinate ora e godetevi una consegna rapida e discreta
keywords
string
title
stringAbito Eline con lacci in vinile - Sexy, formoso e feticista
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string<p><span>Non perdete l'occasione di acquistare questo abito eccezionale e di fare colpo in ogni occasione. Lasciatevi sedurre dal suo fascino unico e dalla sua qualit&agrave; impeccabile.</span></p>
title
stringAbito Eline con allacciatura
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>De Eline jurk met kant is een fetish outfit die snel een must-have in je boudoir zal worden. </span><br /><br /><span>Het ontwerp van deze jurk is zowel elegant als sexy, met een rits aan de achterkant die een vleugje verfijning toevoegt. De korsetveter aan de voorkant verbetert je silhouet en cre&euml;ert een wespentaille-effect.</span><br /><br /><span>Deze jurk is gemaakt van hoogwaardige materialen en biedt optimaal comfort terwijl hij toch slijtvast is. De vinyl stof geeft het een unieke, on-trend look, ideaal voor vrouwen die zich graag onderscheiden van de massa.</span><br /><br /><span>Of het nu gaat om een avondje uit met vrienden, een romantisch afspraakje of een feestje, de Eline jurk met veterdetail zal zeker in het oog springen. De gedurfde, moderne stijl maakt het de perfecte keuze voor vrouwen die hun persoonlijkheid en stijl willen laten gelden.</span><br /><br /><br /></p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringOntdek onze ongelooflijke Eline jurk met vinyl veters, een sexy, welgevormde, fetish outfit die je figuur zal verbeteren. Bestel nu en geniet van een snelle, discrete levering
keywords
string
title
stringEline jurk met vinyl veters - Sexy, welgevormd en fetisjistisch
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string<p><span>Mis de kans niet om deze uitzonderlijke jurk te kopen en bij elke gelegenheid op te vallen. Laat je verleiden door zijn unieke allure en onberispelijke kwaliteit.</span></p>
title
stringEline jurk met vetersluiting
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>O vestido com renda Eline &eacute; um traje fetiche que rapidamente se tornar&aacute; um must-have no seu boudoir. </span><br /><br /><span>O design deste vestido &eacute; ao mesmo tempo elegante e sexy, com um fecho de correr nas costas a dar um toque de sofistica&ccedil;&atilde;o. O la&ccedil;o do espartilho &agrave; frente real&ccedil;a a sua silhueta e cria um efeito de cintura de vespa.</span><br /><br /><span>Fabricado com materiais de alta qualidade, este vestido oferece um conforto &oacute;timo e &eacute; resistente. O seu tecido de vinil confere-lhe um aspeto &uacute;nico e atual, ideal para as mulheres que gostam de se destacar da multid&atilde;o.</span><br /><br /><span>Quer seja para uma sa&iacute;da &agrave; noite com os amigos, um encontro ou uma festa, o vestido Eline com pormenor de renda chamar&aacute; a aten&ccedil;&atilde;o de todos. O seu estilo arrojado e moderno torna-o a escolha perfeita para as mulheres que querem afirmar a sua personalidade e estilo.</span><br /><br /><br /></p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringDescubra o nosso incrível vestido Eline com atacadores de vinil, um traje fetiche sexy e cheio de formas que vai realçar a sua figura. Encomende agora e beneficie de uma entrega rápida e discreta
keywords
string
title
stringVestido Eline com atacadores de vinil - Sexy, elegante e fetichista
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string<p><span>N&atilde;o perca a oportunidade de comprar este vestido excecional e de fazer furor em todas as ocasi&otilde;es. Deixe-se seduzir pelo seu encanto &uacute;nico e pela sua qualidade impec&aacute;vel.</span></p>
title
stringVestido Eline com laço
usageinstructions
string
name
string9521-BK Robe Vinyle laçage corset devant
netweight
string
nextshipment
stringtomorrow
ordered
number5
orderidx
number0
origin
string
originalsize
string
packaging
string
productshipment
stringauto
productuid
stringEF4B9A13-17D4-481D-A53544EC37F8E9A9
promountil
string
rating
stringnone
recorduid
stringEF4B9A13-17D4-481D-A53544EC37F8E9A9
reference
stringLFNU8067
related
string
reserved
string
returned
number0
returnsallowed
number1
section
stringcabaret
shipment
string5to7days
showbrand
number0
sizeinfos
Query
Template: /system/api/product/sizes.cfc:20
Execution Time: 1.48 ms
Record Count: 3
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,'2087,2086,2085,2084,2083,2082') > 0
and product_variations.productuid = 'EF4B9A13-17D4-481D-A53544EC37F8E9A9'
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
12087XLintlsizeblackXLXL-19999990wplusdressXLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42104-10880-86106-110
220862XLintlsizeblack2XL2XL-19999991wplusdress2XL2XL44-4614-1618-2046-4846-4844-4650-5246-4844-46108-11286-92110-114
320853XLintlsizeblack3XL3XL-19999991wplusdress3XL3XL48-5018-2022-2650-5250-5248-5052-5450-5248-50112-11492-98114-118
sizeranges
stringstandard,plus
sizes
string2087,2086,2085,2084,2083,2082
sizetype
stringauto
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: 5.69 ms
Record Count: 3
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 = 'EF4B9A13-17D4-481D-A53544EC37F8E9A9'
and product_variations.isactive = 1
and product_sizes.id_size = 2087
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 = 'EF4B9A13-17D4-481D-A53544EC37F8E9A9'
and product_variations.isactive = 1
and product_sizes.id_size = 2086
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 = 'EF4B9A13-17D4-481D-A53544EC37F8E9A9'
and product_variations.isactive = 1
and product_sizes.id_size = 2085
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 = 'EF4B9A13-17D4-481D-A53544EC37F8E9A9'
and product_variations.isactive = 1
and product_sizes.id_size = 2084
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 = 'EF4B9A13-17D4-481D-A53544EC37F8E9A9'
and product_variations.isactive = 1
and product_sizes.id_size = 2083
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 = 'EF4B9A13-17D4-481D-A53544EC37F8E9A9'
and product_variations.isactive = 1
and product_sizes.id_size = 2082
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
1EF4B9A13-17D4-481D-A53544EC37F8E9A9046ECBD5-FC4A-4B36-AFA2420D721CBBEE2087black#000000XLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42wdressXLintlsize54.12537.4583{ts '2025-09-09 12:08:00'}STOCK01000-100009521-10all
2EF4B9A13-17D4-481D-A53544EC37F8E9A99272E6C6-A877-42D6-84BACBFF32CA40AE2086black#0000002XL2XL44-4614-1618-2046-4846-4844-4650-5246-4844-46wdress2XLintlsize54.12537.4583{ts '2025-09-09 12:08:00'}STOCK01100-102009521366408609635611all
3EF4B9A13-17D4-481D-A53544EC37F8E9A919C291A3-6E5C-47A0-867C87480123CDBA2085black#0000003XL3XL48-5018-2022-2650-5250-5248-5052-5450-5248-50wdress3XLintlsize54.12537.4583{ts '2025-09-09 12:08:00'}STOCK01100-103009521366408609636311all
subcategory
stringall
supplier
number-1
supplierreference
string9521000SDRT-44BK
tags
stringnoirdesir
themes
stringdark
totalvariations
string
type
stringdefault
unitprice
number54.125
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 9.84 ms
Record Count: 3
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 = 'EF4B9A13-17D4-481D-A53544EC37F8E9A9' 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 = 'EF4B9A13-17D4-481D-A53544EC37F8E9A9' 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 = 'EF4B9A13-17D4-481D-A53544EC37F8E9A9' 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 = 'EF4B9A13-17D4-481D-A53544EC37F8E9A9' 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 = 'EF4B9A13-17D4-481D-A53544EC37F8E9A9' 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 = 'EF4B9A13-17D4-481D-A53544EC37F8E9A9' 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 = 'EF4B9A13-17D4-481D-A53544EC37F8E9A9'
and product_variations.isactive = 1
and product_sizes.id_size = 2087
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 = 'EF4B9A13-17D4-481D-A53544EC37F8E9A9' 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 = 'EF4B9A13-17D4-481D-A53544EC37F8E9A9' 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 = 'EF4B9A13-17D4-481D-A53544EC37F8E9A9' 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 = 'EF4B9A13-17D4-481D-A53544EC37F8E9A9' 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 = 'EF4B9A13-17D4-481D-A53544EC37F8E9A9' 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 = 'EF4B9A13-17D4-481D-A53544EC37F8E9A9' 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 = 'EF4B9A13-17D4-481D-A53544EC37F8E9A9'
and product_variations.isactive = 1
and product_sizes.id_size = 2086
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 = 'EF4B9A13-17D4-481D-A53544EC37F8E9A9' 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 = 'EF4B9A13-17D4-481D-A53544EC37F8E9A9' 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 = 'EF4B9A13-17D4-481D-A53544EC37F8E9A9' 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 = 'EF4B9A13-17D4-481D-A53544EC37F8E9A9' 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 = 'EF4B9A13-17D4-481D-A53544EC37F8E9A9' 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 = 'EF4B9A13-17D4-481D-A53544EC37F8E9A9' 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 = 'EF4B9A13-17D4-481D-A53544EC37F8E9A9'
and product_variations.isactive = 1
and product_sizes.id_size = 2085
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 = 'EF4B9A13-17D4-481D-A53544EC37F8E9A9' 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 = 'EF4B9A13-17D4-481D-A53544EC37F8E9A9' 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 = 'EF4B9A13-17D4-481D-A53544EC37F8E9A9' 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 = 'EF4B9A13-17D4-481D-A53544EC37F8E9A9' 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 = 'EF4B9A13-17D4-481D-A53544EC37F8E9A9' 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 = 'EF4B9A13-17D4-481D-A53544EC37F8E9A9' 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 = 'EF4B9A13-17D4-481D-A53544EC37F8E9A9'
and product_variations.isactive = 1
and product_sizes.id_size = 2084
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 = 'EF4B9A13-17D4-481D-A53544EC37F8E9A9' 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 = 'EF4B9A13-17D4-481D-A53544EC37F8E9A9' 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 = 'EF4B9A13-17D4-481D-A53544EC37F8E9A9' 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 = 'EF4B9A13-17D4-481D-A53544EC37F8E9A9' 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 = 'EF4B9A13-17D4-481D-A53544EC37F8E9A9' 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 = 'EF4B9A13-17D4-481D-A53544EC37F8E9A9' 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 = 'EF4B9A13-17D4-481D-A53544EC37F8E9A9'
and product_variations.isactive = 1
and product_sizes.id_size = 2083
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 = 'EF4B9A13-17D4-481D-A53544EC37F8E9A9' 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 = 'EF4B9A13-17D4-481D-A53544EC37F8E9A9' 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 = 'EF4B9A13-17D4-481D-A53544EC37F8E9A9' 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 = 'EF4B9A13-17D4-481D-A53544EC37F8E9A9' 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 = 'EF4B9A13-17D4-481D-A53544EC37F8E9A9' 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 = 'EF4B9A13-17D4-481D-A53544EC37F8E9A9' 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 = 'EF4B9A13-17D4-481D-A53544EC37F8E9A9'
and product_variations.isactive = 1
and product_sizes.id_size = 2082
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
1046ECBD5-FC4A-4B36-AFA2420D721CBBEE2087black#000000XLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42wdressXLintlsize54.12537.4583{ts '2025-09-09 12:08:00'}STOCK01000-100009521-10-10-12054.125all
29272E6C6-A877-42D6-84BACBFF32CA40AE2086black#0000002XL2XL44-4614-1618-2046-4846-4844-4650-5246-4844-46wdress2XLintlsize54.12537.4583{ts '2025-09-09 12:08:00'}STOCK01100-102009521366408609635611-11-12054.125all
319C291A3-6E5C-47A0-867C87480123CDBA2085black#0000003XL3XL48-5018-2022-2650-5250-5248-5052-5450-5248-50wdress3XLintlsize54.12537.4583{ts '2025-09-09 12:08:00'}STOCK01100-103009521366408609636311-11-12054.125all
vatrate
number20
warehouse
string