Il mio cestino

❌
Totale articoli
Visualizza il carrello
Menu
Vedere le dimensioni
Bustier lungo incrociato
Doppio clic per ingrandire
SKU: SBBU4290
Bustier lungo incrociato
Stock:

Il suo aspetto sensuale e raffinato la rende un'innegabile risorsa di seduzione. Che la indossiate per sentirvi belle e sicure di voi stesse o per sorprendere il vostro partner, questa guêpière è di sicuro effetto.

Taglia:

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

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

Guêpière lunga a croce di taglia grande

Descrizione del prodotto

Il nostro bustier lungo e incrociato è realizzato in rete di alta qualità e offre comfort e sensualità.

Con le sue fasce incrociate, mette in risalto le curve del corpo e crea un effetto visivo altamente seducente.

La scollatura aggiunge un tocco di audacia e raffinatezza, scoprendo sottilmente la pelle e rivelando la vostra sensualità.

Che sia per una serata romantica o per sorprendere il vostro partner, questa guêpière è la scelta perfetta per farvi sentire belle e desiderabili.

Dettagli tecnici

Dimensioni disponibili

Disponibile da 38-40 a 48-50

Colore disponibile

Nero

Guida alle taglie

Controllare la taglia giusta per voi

Internazionale
  • Petto
  • Dimensione
  • Fianchi
38-40
  • 92-100
  • 74-82
  • 98-106
44-46
  • 102-108
  • 86-92
  • 108-114
48-50
  • 110-116
  • 96-102
  • 116-122
To Top
Visualizza il carrello
Articoli
Totale articoli
Struct
Entries: 108
actions
Array
available
number-1
brand
stringparishollywood
brandcode
stringpuun
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
stringParis Hollywood
breasts
stringna
careinstructions
string
categories
stringdivasboudoir.lingerie.sexylingerie.bustier
category
stringsexylingerie
categorygender
stringf
categorymediadatas
Struct
adult
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string276
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/lingerie/sexylingerie/bustier.jpg
type
stringimg
width
string600
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: 1.01 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 = '9FCCACC0-721C-45FB-8ED5ACC3403B735E'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1blackcolorblakblackblack#000000-10
colorrange
stringblack
colors
stringblack
colortype
stringcolor
comments
string
compositions
Struct
Entries: 13
coton
string
elastane
string
free
string
leather
string
lycra
string
metal
string
nylon
string
polyamide
string
polyester
string
polyurethane
string
silk
string
spandex
string
viscose
string
datecreated
Date Time (Europe/Paris)
{ts '2023-07-20 14:12:00'}
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
booleanfalse
hasdescription
booleantrue
hasdimensions
booleanfalse
hasmaterials
booleanfalse
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
number29.125
itempromo
string
key
stringblack-halter-neck-mesh-bondage-sexy-garter-lingerie-r81175p
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-08-02 12:32:36'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 1.02 ms
Record Count: 0
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select cart_actions.*
from cart_actions
where cart_actions.branding IN ('all','divasboudoir')
and cart_actions.language IN ('all','it')
and (cart_actions.quotas = -1 or (cart_actions.usedCount < cart_actions.quotas))
and cart_actions.isactive = 1
and (date(cart_actions.activeFrom) <= '2025-11-24' OR cart_actions.activeFrom is null)
and (date(cart_actions.activeTo) >= '2025-11-24' OR cart_actions.activeTo is null)
and (
FIND_IN_SET('9fccacc0-721c-45fb-8ed5acc3403b735e',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.74 ms
Record Count: 0
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select products.productuid as productuid, products.reference, 'default' as type, products.key, products.language, products.name,
product_links.linkuid,
products.colors, products.vatrate, products.metadatas, products.dimensions,
products.mediadatas, products.tags, products.themes, products.isdivasize,
count(distinct product_variations.variationuid) as totalvariations,
group_concat(distinct product_variations.variationuid) as variationlist,
count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END) as inpromo,
if(count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END)>0,1,0) as haspromo,
(select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0) END)) as itempromo,
IFNULL(min(product_variations.itemprice),0) as itemprice,
(select IF (products.isfixedprice = 0 and sum(product_variations.itempromo) > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null), IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0), IFNULL(min(NULLIF(product_variations.itemprice, 0)), 0) )) as unitprice,
count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.itempromo ELSE product_variations.itemprice END) as prices,
(select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN min(NULLIF(product_variations.promountil, 0)) END)) as promountil,
products.isfixedprice, products.ishot, products.isnew, if(products.orderidx > 0, products.orderidx, 999999999) as orderidx,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
count(distinct CASE WHEN ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) > 0 OR ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) <= 0 AND product_variations.supplier = 0)) THEN product_variations.variationuid END) as instockvariations,
products.brand, brands.name as brandname, IFNULL(brands.ispublic, 0) as showbrand, brands.display,
product_categories.sizetype,GROUP_CONCAT(DISTINCT product_sizes.suppliersize) as intlsize,products.sizes,product_sizes.sizerange,product_categories.mediadatas as categorymediadatas, product_categories.sizerange as categorysizerange,
product_categorymap.section, product_categorymap.category, product_categorymap.key as subcategory
from products
left outer join product_categorymap on products.productuid = product_categorymap.productuid
left outer join product_categories on (product_categories.branding = product_categorymap.branding and product_categories.section = product_categorymap.section and product_categories.category = product_categorymap.category and product_categories.key = product_categorymap.key)
left outer join product_sizes on product_sizes.id_size IN (products.sizes)
left outer join brands on products.brand = brands.brand
left outer join product_variations on product_variations.productuid = products.productuid and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
left outer join product_links on product_links.reference = products.reference
where products.isactive = 1 and products.isdeleted = 0
and brands.isactive = 1 and brands.isdeleted = 0
and product_categories.isactive = 1 and product_categories.isdeleted = 0
and product_variations.isactive = 1
and FIND_IN_SET('divasboudoir',products.branding)
and product_categories.branding IN ('all','divasboudoir')
and product_categorymap.branding IN ('all','divasboudoir')
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and products.language in ('all','it')
and product_categories.language in ('all','it')
and (products.displayFrom <= DATE(NOW()) or products.displayFrom is null)
and (products.displayTo >= DATE(NOW()) or products.displayTo IS null)
and product_links.linkuid = '' and product_links.linkuid is not null and product_links.linkuid <> ''
and products.reference <> 'SBBU4290'
group by products.reference
order by products.ishot desc, products.isnew desc, orderidx asc, products.lastupdated desc
productuidreferencetypekeylanguagenamelinkuidcolorsvatratemetadatasdimensionsmediadatastagsthemesisdivasizetotalvariationsvariationlistinpromohaspromoitempromoitempriceunitpricepricespromountilisfixedpriceishotisneworderidxavailablestockinstockvariationsbrandbrandnameshowbranddisplaysizetypeintlsizesizessizerangecategorymediadatascategorysizerangesectioncategorysubcategory
linkuid
string
materials
string
mediadatas
Struct
alt
Struct
height
string1300
isprivate
string0
rating
stringall
src
string/photobank/products/puun/sbbu4290/20230706163182938293.jpg
type
stringimg
width
string1000
back
Struct
height
string1300
isprivate
string0
rating
stringall
src
string/photobank/products/puun/sbbu4290/2023070616310221221.jpg
type
stringimg
width
string1000
default
Struct
height
string1300
isprivate
string0
rating
stringall
src
string/photobank/products/puun/sbbu4290/20230706163162726272.jpg
type
stringimg
width
string1000
variations
Struct
colors
Struct
black
Struct
height
string1300
isprivate
string0
rating
stringall
src
string/photobank/products/puun/sbbu4290/20230706163162726272.jpg
type
stringimg
width
string1000
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<span style="box-sizing: border-box;">Unser langes, gekreuztes Mieder ist aus hochwertigem Netzgewebe gefertigt und bietet Komfort und Sinnlichkeit zugleich.</span><br style="box-sizing: border-box;" /><br style="box-sizing: border-box;" /><span style="box-sizing: border-box;">Mit seinen gekreuzten Bändern betont es die Kurven Ihres Körpers und sorgt für einen äußerst verführerischen visuellen Effekt.</span><br style="box-sizing: border-box;" /><br style="box-sizing: border-box;" /><span style="box-sizing: border-box;">Der Neckholder dieses Mieders verleiht einen Hauch von Kühnheit und Raffinesse. </span><span style="box-sizing: border-box;">Er enthüllt subtil Ihre Haut und lässt Ihre Sinnlichkeit durchblicken</span>.<br style="box-sizing: border-box;" /><br style="box-sizing: border-box;" /><span style="box-sizing: border-box;">Ob für einen romantischen Abend oder um Ihren Partner zu überraschen, dieses Mieder ist die perfekte Wahl, um sich schön und begehrenswert zu fühlen.</span>
guid
stringhttps://dev.divasboudoir.com/de/lange-grosse-taille-gekreuztes-guepiere-schwarz/sbbu4290.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringSeine sinnliche und raffinierte Ausstrahlung macht es zu einem unbestreitbaren Verführungsmerkmal. Ob Sie es tragen, um sich schön und selbstbewusst zu fühlen, oder um Ihren Partner zu überraschen, dieses Mieder wird seine Wirkung nicht verfehlen.
keywords
string
title
stringLange große Taille gekreuztes Guêpière
seotitle
stringLange große Taille gekreuztes Guêpière
seouri
stringlange-grosse-taille-gekreuztes-guepiere-schwarz
specifications
string
stylingtips
string
summary
stringSeine sinnliche und raffinierte Ausstrahlung macht es zu einem unbestreitbaren Verführungsmerkmal. Ob Sie es tragen, um sich schön und selbstbewusst zu fühlen, oder um Ihren Partner zu überraschen, dieses Mieder wird seine Wirkung nicht verfehlen.
title
stringLanges gekreuztes Mieder
usageinstructions
string
el
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<span style="box-sizing: border-box;">Το μακρύ, σταυρωτό μπουστάκι μας είναι κατασκευασμένο από υψηλής ποιότητας δίχτυ, προσφέροντας άνεση και αισθησιασμό.</span><br style="box-sizing: border-box;" /><br style="box-sizing: border-box;" /><span style="box-sizing: border-box;">Με τις σταυρωτές ζώνες του, αναδεικνύει τις καμπύλες του σώματός σας και δημιουργεί ένα άκρως σαγηνευτικό οπτικό αποτέλεσμα.</span><br style="box-sizing: border-box;" /><br style="box-sizing: border-box;" /><span style="box-sizing: border-box;">Η λαιμόκοψη προσθέτει μια πινελιά τόλμης και εκλέπτυνσης, </span><span style="box-sizing: border-box;">αποκαλύπτοντας διακριτικά το δέρμα σας και αποκαλύπτοντας τον αισθησιασμό σας</span>.<br style="box-sizing: border-box;" /><br style="box-sizing: border-box;" /><span style="box-sizing: border-box;">Είτε πρόκειται για μια ρομαντική βραδιά είτε για να εκπλήξετε τον σύντροφό σας, αυτή η gu&ecirc;pi&egrave;re είναι η τέλεια επιλογή για να σας κάνει να νιώσετε όμορφη και επιθυμητή.</span>
guid
stringhttps://dev.divasboudoir.com/el/makry-megalo-megethos-stayroeidhs-gkiepia-mayro/sbbu4290.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringΗ αισθησιακή, εκλεπτυσμένη εμφάνισή του το καθιστά ένα αδιαμφισβήτητο σαγηνευτικό πλεονέκτημα. Είτε το φορέσετε για να νιώσετε όμορφη και σίγουρη, είτε για να εκπλήξετε τον σύντροφό σας, αυτό το guêpière είναι σίγουρο ότι θα προκαλέσει εντύπωση.
keywords
string
title
stringΜακρύ μεγάλο μέγεθος σταυροειδής γκιέπια
seotitle
stringΜακρύ μεγάλο μέγεθος σταυροειδής γκιέπια
seouri
stringmakry-megalo-megethos-stayroeidhs-gkiepia-mayro
specifications
string
stylingtips
string
summary
stringΗ αισθησιακή, εκλεπτυσμένη εμφάνισή του το καθιστά ένα αδιαμφισβήτητο σαγηνευτικό πλεονέκτημα. Είτε το φορέσετε για να νιώσετε όμορφη και σίγουρη, είτε για να εκπλήξετε τον σύντροφό σας, αυτό το gu&ecirc;pi&egrave;re είναι σίγουρο ότι θα προκαλέσει εντύπωση.
title
stringΜακρύ μπουστάκι με σταυρό
usageinstructions
string
en
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<span style="box-sizing: border-box;">Our long cross-body garter is made from high-quality fishnet, offering both comfort and sensuality.</span><br style="box-sizing: border-box;" /><br style="box-sizing: border-box;" /><span style="box-sizing: border-box;">With its criss-cross bands, it highlights the curves of your body and creates a most seductive visual effect.</span><br style="box-sizing: border-box;" /><br style="box-sizing: border-box;" /><span style="box-sizing: border-box;">The halterneck adds a touch of daring and sophistication, </span><span style="box-sizing: border-box;">subtly revealing your skin and revealing your sensuality</span>.<br style="box-sizing: border-box;" /><br style="box-sizing: border-box;" /><span style="box-sizing: border-box;">Whether for a romantic evening or to surprise your partner, this gu&ecirc;pi&egrave;re is the perfect choice to make you feel beautiful and desirable.</span>
guid
stringhttps://dev.divasboudoir.com/en/long-plus-size-crossover-bustier-black/sbbu4290.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringIts sensual, refined allure makes it an undeniable seductive asset. Whether you wear it to feel beautiful and confident, or to surprise your partner, this guêpière is sure to make an impact.
keywords
string
title
stringLong plus size crossover bustier
seotitle
stringLong plus size crossover bustier
seouri
stringlong-plus-size-crossover-bustier-black
specifications
string
stylingtips
string
summary
stringIts sensual, refined allure makes it an undeniable seductive asset. Whether you wear it to feel beautiful and confident, or to surprise your partner, this gu&ecirc;pi&egrave;re is sure to make an impact.
title
stringLong criss-cross guêpière
usageinstructions
string
es
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<span style="box-sizing: border-box;">Nuestro corpiño largo y entrecruzado está confeccionado en rejilla de alta calidad, que ofrece tanto comodidad como sensualidad.</span><br style="box-sizing: border-box;" /><br style="box-sizing: border-box;" /><span style="box-sizing: border-box;">Con sus bandas entrecruzadas, realza las curvas de tu cuerpo y crea un efecto visual muy seductor.</span><br style="box-sizing: border-box;" /><br style="box-sizing: border-box;" /><span style="box-sizing: border-box;">El escote halterneck añade un toque de atrevimiento y sofisticación, </span><span style="box-sizing: border-box;">mostrando sutilmente tu piel y revelando tu sensualidad</span>.<br style="box-sizing: border-box;" /><br style="box-sizing: border-box;" /><span style="box-sizing: border-box;">Ya sea para una velada romántica o para sorprender a su pareja, esta gu&ecirc;pi&egrave;re es la elección perfecta para hacerle sentir bella y deseable.</span>
guid
stringhttps://dev.divasboudoir.com/es/guepiere-larga-de-talla-grande-entrecruzada-negro/sbbu4290.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringSu aspecto sensual y refinado la convierte en un innegable activo seductor. Ya sea para sentirse guapa y segura de sí misma o para sorprender a su pareja, esta guêpière causará sensación.
keywords
string
title
stringGuêpière larga de talla grande entrecruzada
seotitle
stringGuêpière larga de talla grande entrecruzada
seouri
stringguepiere-larga-de-talla-grande-entrecruzada-negro
specifications
string
stylingtips
string
summary
stringSu aspecto sensual y refinado la convierte en un innegable activo seductor. Ya sea para sentirse guapa y segura de sí misma o para sorprender a su pareja, esta gu&ecirc;pi&egrave;re causará sensación.
title
stringCorpiño largo cruzado
usageinstructions
string
fr
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<span style="box-sizing: border-box;">Notre longue gu&ecirc;pi&egrave;re crois&eacute;e est&nbsp;fabriqu&eacute;e en r&eacute;sille de haute qualit&eacute;, elle offre &agrave; la fois confort et sensualit&eacute;.</span><br style="box-sizing: border-box;" /><br style="box-sizing: border-box;" /><span style="box-sizing: border-box;">Avec ses bandes crois&eacute;es, elle met en valeur les courbes de votre corps et cr&eacute;e un effet visuel des plus s&eacute;duisants.</span><br style="box-sizing: border-box;" /><br style="box-sizing: border-box;" /><span style="box-sizing: border-box;">Le dos nu de cette gu&ecirc;pi&egrave;re ajoute une touche d'audace et de sophistication.&nbsp;</span><span style="box-sizing: border-box;">Il d&eacute;voile subtilement votre peau et laisse entrevoir votre sensualit&eacute;.</span><br style="box-sizing: border-box;" /><br style="box-sizing: border-box;" /><span style="box-sizing: border-box;">Que ce soit pour une soir&eacute;e romantique ou pour surprendre votre partenaire, cette gu&ecirc;pi&egrave;re est le choix parfait pour vous sentir belle et d&eacute;sirable.</span>
guid
stringhttps://dev.divasboudoir.com/fr/longue-grande-taille-guepiere-croisee-noir/sbbu4290.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringSon allure sensuelle et raffinée en fait un atout de séduction indéniable. Que vous la portiez pour vous sentir belle et confiante, ou pour surprendre votre partenaire, cette guêpière ne manquera pas de faire son effet.
keywords
string
title
stringLongue grande taille guêpière croisée
seotitle
stringLongue grande taille guêpière croisée
seouri
stringlongue-grande-taille-guepiere-croisee-noir
specifications
string
stylingtips
string
summary
stringSon allure sensuelle et raffin&eacute;e en fait un atout de s&eacute;duction ind&eacute;niable. Que vous la portiez pour vous sentir belle et confiante, ou pour surprendre votre partenaire, cette gu&ecirc;pi&egrave;re ne manquera pas de faire son effet.
title
stringLongue guêpière croisée
usageinstructions
string
it
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<span style="box-sizing: border-box;">Il nostro bustier lungo e incrociato è realizzato in rete di alta qualità e offre comfort e sensualità.</span><br style="box-sizing: border-box;" /><br style="box-sizing: border-box;" /><span style="box-sizing: border-box;">Con le sue fasce incrociate, mette in risalto le curve del corpo e crea un effetto visivo altamente seducente.</span><br style="box-sizing: border-box;" /><br style="box-sizing: border-box;" />La <span style="box-sizing: border-box;">scollatura aggiunge un tocco di audacia e raffinatezza, </span><span style="box-sizing: border-box;">scoprendo sottilmente la pelle e rivelando la vostra sensualità</span>.<br style="box-sizing: border-box;" /><br style="box-sizing: border-box;" /><span style="box-sizing: border-box;">Che sia per una serata romantica o per sorprendere il vostro partner, questa gu&ecirc;pi&egrave;re &egrave; la scelta perfetta per farvi sentire belle e desiderabili.</span>
guid
stringhttps://dev.divasboudoir.com/it/guepiere-lunga-a-croce-di-taglia-grande-nero/sbbu4290.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringIl suo aspetto sensuale e raffinato la rende un'innegabile risorsa di seduzione. Che la indossiate per sentirvi belle e sicure di voi stesse o per sorprendere il vostro partner, questa guêpière è di sicuro effetto.
keywords
string
title
stringGuêpière lunga a croce di taglia grande
seotitle
stringGuêpière lunga a croce di taglia grande
seouri
stringguepiere-lunga-a-croce-di-taglia-grande-nero
specifications
string
stylingtips
string
summary
stringIl suo aspetto sensuale e raffinato la rende un'innegabile risorsa di seduzione. Che la indossiate per sentirvi belle e sicure di voi stesse o per sorprendere il vostro partner, questa gu&ecirc;pi&egrave;re &egrave; di sicuro effetto.
title
stringBustier lungo incrociato
usageinstructions
string
nl
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<span style="box-sizing: border-box;">Onze lange bustier is gemaakt van hoogwaardig visnet en biedt zowel comfort als sensualiteit.</span><br style="box-sizing: border-box;" /><br style="box-sizing: border-box;" /><span style="box-sizing: border-box;">Met zijn kriskrasbanden accentueert het de rondingen van je lichaam en creëert het een zeer verleidelijk visueel effect.</span><br style="box-sizing: border-box;" /><br style="box-sizing: border-box;" /><span style="box-sizing: border-box;">De halternek voegt een vleugje durf en verfijning toe, </span> waarbij<span style="box-sizing: border-box;">je huid subtiel wordt onthuld en je sensualiteit wordt onthuld</span>.<br style="box-sizing: border-box;" /><br style="box-sizing: border-box;" /><span style="box-sizing: border-box;">Of het nu voor een romantische avond is of om je partner te verrassen, deze gu&ecirc;pi&egrave;re is de perfecte keuze om je mooi en begeerlijk te voelen.</span>
guid
stringhttps://dev.divasboudoir.com/nl/lange-grote-maat-kriskras-guepiere-zwart/sbbu4290.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringDe sensuele, verfijnde look maakt het een onmiskenbare verleidelijke aanwinst. Of je hem nu draagt om je mooi en zelfverzekerd te voelen of om je partner te verrassen, deze guêpière maakt zeker indruk.
keywords
string
title
stringLange grote maat kriskras guêpière
seotitle
stringLange grote maat kriskras guêpière
seouri
stringlange-grote-maat-kriskras-guepiere-zwart
specifications
string
stylingtips
string
summary
stringDe sensuele, verfijnde look maakt het een onmiskenbare verleidelijke aanwinst. Of je hem nu draagt om je mooi en zelfverzekerd te voelen of om je partner te verrassen, deze gu&ecirc;pi&egrave;re maakt zeker indruk.
title
stringLange bustier met kriskras
usageinstructions
string
pt
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<span style="box-sizing: border-box;">O nosso corpete comprido e cruzado é feito de rede de peixe de alta qualidade, oferecendo conforto e sensualidade.</span><br style="box-sizing: border-box;" /><br style="box-sizing: border-box;" /><span style="box-sizing: border-box;">Com as suas tiras cruzadas, realça as curvas do seu corpo e cria um efeito visual muito sedutor.</span><br style="box-sizing: border-box;" /><br style="box-sizing: border-box;" /><span style="box-sizing: border-box;">O decote haltere dá um toque de ousadia e sofisticação, </span> revelando<span style="box-sizing: border-box;">subtilmente a sua pele e a sua sensualidade</span>.<br style="box-sizing: border-box;" /><br style="box-sizing: border-box;" /><span style="box-sizing: border-box;">Quer seja para uma noite romântica ou para surpreender o seu parceiro, este gu&ecirc;pi&egrave;re é a escolha perfeita para a fazer sentir-se bela e desejável.</span>
guid
stringhttps://dev.divasboudoir.com/pt/guepiere-comprida-cruzada-de-tamanho-grande-preto/sbbu4290.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringO seu aspeto sensual e requintado torna-o um trunfo de sedução inegável. Quer o use para se sentir bonita e confiante, quer para surpreender o seu parceiro, este guêpière vai certamente causar impacto.
keywords
string
title
stringGuêpière comprida cruzada de tamanho grande
seotitle
stringGuêpière comprida cruzada de tamanho grande
seouri
stringguepiere-comprida-cruzada-de-tamanho-grande-preto
specifications
string
stylingtips
string
summary
stringO seu aspeto sensual e requintado torna-o um trunfo de sedução inegável. Quer o use para se sentir bonita e confiante, quer para surpreender o seu parceiro, este gu&ecirc;pi&egrave;re vai certamente causar impacto.
title
stringCorpete comprido cruzado
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<span style="box-sizing: border-box;">Unser langes, gekreuztes Mieder aus Netzgewebe bietet Komfort und Sinnlichkeit zugleich.</span><br style="box-sizing: border-box;" /><br style="box-sizing: border-box;" /><span style="box-sizing: border-box;">Mit seinen gekreuzten Bändern betont es die Kurven Ihres Körpers und sorgt für einen äußerst verführerischen visuellen Effekt.</span><br style="box-sizing: border-box;" /><br style="box-sizing: border-box;" /><span style="box-sizing: border-box;">Der freie Rücken dieses Mieders verleiht einen Hauch von Kühnheit und Raffinesse. </span><span style="box-sizing: border-box;">Er enthüllt subtil Ihre Haut und lässt Ihre Sinnlichkeit durchblicken</span>.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringSeine sinnliche und raffinierte Ausstrahlung macht es zu einem unbestreitbaren Verführungsmerkmal. Tragen Sie es, um Ihren Partner zu überraschen, denn dieses Mieder wird seine Wirkung nicht verfehlen.
keywords
string
title
stringGekreuztes Guêpière aus Netzstoff
seotitle
stringGekreuztes Guêpière aus Netzstoff
seouri
stringgekreuztes-guepiere-aus-netzstoff-schwarz
specifications
string
stylingtips
string
summary
stringSeine sinnliche und raffinierte Ausstrahlung macht es zu einem unbestreitbaren Verführungsmerkmal. Tragen Sie es, um Ihren Partner zu überraschen, denn dieses Mieder wird seine Wirkung nicht verfehlen.
title
stringGekreuztes Guêpière aus Netzstoff
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<span style="box-sizing: border-box;">Το μακρύ διχτυωτό σουτιέν μας προσφέρει άνεση και αισθησιασμό.</span><br style="box-sizing: border-box;" /><br style="box-sizing: border-box;" /><span style="box-sizing: border-box;">Με τις σταυρωτές ζώνες του, αναδεικνύει τις καμπύλες του σώματός σας και δημιουργεί ένα άκρως σαγηνευτικό οπτικό αποτέλεσμα.</span><br style="box-sizing: border-box;" /><br style="box-sizing: border-box;" /><span style="box-sizing: border-box;">Η λαιμόκοψη προσθέτει μια πινελιά τόλμης και εκλέπτυνσης, </span><span style="box-sizing: border-box;">αποκαλύπτοντας διακριτικά το δέρμα σας και αποκαλύπτοντας τον αισθησιασμό σας</span>.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringΗ αισθησιακή, εκλεπτυσμένη εμφάνισή του το καθιστά ένα αδιαμφισβήτητο σαγηνευτικό πλεονέκτημα. Φορέστε το για να εκπλήξετε το σύντροφό σας, αυτό το guêpière είναι βέβαιο ότι θα προκαλέσει αντίκτυπο.
keywords
string
title
stringΔίχτυ crossover μπουστάκι
seotitle
stringΔίχτυ crossover μπουστάκι
seouri
stringdichty-crossover-mpoystaki-mayro
specifications
string
stylingtips
string
summary
stringΗ αισθησιακή, εκλεπτυσμένη εμφάνισή του το καθιστά ένα αδιαμφισβήτητο σαγηνευτικό πλεονέκτημα. Φορέστε το για να εκπλήξετε το σύντροφό σας, αυτό το gu&ecirc;pi&egrave;re είναι βέβαιο ότι θα προκαλέσει αντίκτυπο.
title
stringΔίχτυ crossover μπουστάκι
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<span style="box-sizing: border-box;">Our long fishnet crossover garter offers both comfort and sensuality.</span><br style="box-sizing: border-box;" /><br style="box-sizing: border-box;" /><span style="box-sizing: border-box;">With its criss-cross bands, it highlights the curves of your body and creates a most seductive visual effect.</span><br style="box-sizing: border-box;" /><br style="box-sizing: border-box;" /><span style="box-sizing: border-box;">The bare back adds a touch of daring and sophistication, </span><span style="box-sizing: border-box;">subtly revealing your skin and revealing your sensuality</span>.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringIts sensual, refined allure makes it an undeniable seductive asset. Wear it to surprise your partner, this guêpière is sure to make an impact.
keywords
string
title
stringFishnet crossover bustier
seotitle
stringFishnet crossover bustier
seouri
stringfishnet-crossover-bustier-black
specifications
string
stylingtips
string
summary
stringIts sensual, refined allure makes it an undeniable seductive asset. Wear it to surprise your partner, this gu&ecirc;pi&egrave;re is sure to make an impact.
title
stringFishnet crossover bustier
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<span style="box-sizing: border-box;">Nuestro sujetador largo de rejilla entrecruzada ofrece a la vez comodidad y sensualidad.</span><br style="box-sizing: border-box;" /><br style="box-sizing: border-box;" /><span style="box-sizing: border-box;">Con sus bandas entrecruzadas, realza las curvas de tu cuerpo y crea un efecto visual muy seductor.</span><br style="box-sizing: border-box;" /><br style="box-sizing: border-box;" /><span style="box-sizing: border-box;">El escote halterneck añade un toque de atrevimiento y sofisticación, </span><span style="box-sizing: border-box;">mostrando sutilmente tu piel y revelando tu sensualidad</span>.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringSu aspecto sensual y refinado la convierte en una innegable baza de seducción. Llévelo para sorprender a su pareja, esta guêpière le impactará.
keywords
string
title
stringCorpiño cruzado de rejilla
seotitle
stringCorpiño cruzado de rejilla
seouri
stringcorpino-cruzado-de-rejilla-negro
specifications
string
stylingtips
string
summary
stringSu aspecto sensual y refinado la convierte en una innegable baza de seducción. Llévelo para sorprender a su pareja, esta gu&ecirc;pi&egrave;re le impactará.
title
stringCorpiño cruzado de rejilla
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span style="box-sizing: border-box;">Notre longue gu&ecirc;pi&egrave;re crois&eacute;e en r&eacute;sille offre &agrave; la fois confort et sensualit&eacute;.</span><br style="box-sizing: border-box;"><br style="box-sizing: border-box;"><span style="box-sizing: border-box;">Avec ses bandes crois&eacute;es, elle met en valeur les courbes de votre corps et cr&eacute;e un effet visuel des plus s&eacute;duisants.</span><br style="box-sizing: border-box;"><br style="box-sizing: border-box;"><span style="box-sizing: border-box;">Le dos nu de cette gu&ecirc;pi&egrave;re ajoute une touche d'audace et de sophistication.&nbsp;</span><span style="box-sizing: border-box;">Il d&eacute;voile subtilement votre peau et laisse entrevoir votre sensualit&eacute;.</span></p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringSon allure sensuelle et raffinée en fait un atout de séduction indéniable. Portez-la pour surprendre votre partenaire, cette guêpière ne manquera pas de faire son effet.
keywords
string
title
stringGuêpière croisée en résille
seotitle
stringGuêpière croisée en résille
seouri
stringguepiere-croisee-en-resille-noir
specifications
string
stylingtips
string
summary
string<p>Son allure sensuelle et raffin&eacute;e en fait un atout de s&eacute;duction ind&eacute;niable. Portez-la pour surprendre votre partenaire, cette gu&ecirc;pi&egrave;re ne manquera pas de faire son effet.</p>
title
stringGuêpière croisée en résille
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<span style="box-sizing: border-box;">Il nostro reggiseno lungo a rete criss-cross offre comfort e sensualità.</span><br style="box-sizing: border-box;" /><br style="box-sizing: border-box;" /><span style="box-sizing: border-box;">Con le sue fasce incrociate, mette in risalto le curve del corpo e crea un effetto visivo altamente seducente.</span><br style="box-sizing: border-box;" /><br style="box-sizing: border-box;" />La <span style="box-sizing: border-box;">scollatura aggiunge un tocco di audacia e raffinatezza, </span><span style="box-sizing: border-box;">scoprendo sottilmente la pelle e rivelando la vostra sensualità</span>.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringIl suo aspetto sensuale e raffinato la rende un'innegabile risorsa di seduzione. Indossata per sorprendere il vostro partner, questa guêpière è di sicuro effetto.
keywords
string
title
stringBustier a rete incrociata
seotitle
stringBustier a rete incrociata
seouri
stringbustier-a-rete-incrociata-nero
specifications
string
stylingtips
string
summary
stringIl suo aspetto sensuale e raffinato la rende un'innegabile risorsa di seduzione. Indossata per sorprendere il vostro partner, questa gu&ecirc;pi&egrave;re &egrave; di sicuro effetto.
title
stringBustier a rete incrociata
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<span style="box-sizing: border-box;">Onze lange visnet kruisbeha biedt zowel comfort als sensualiteit.</span><br style="box-sizing: border-box;" /><br style="box-sizing: border-box;" /><span style="box-sizing: border-box;">Met zijn kriskrasbanden accentueert hij de rondingen van je lichaam en creëert hij een zeer verleidelijk visueel effect.</span><br style="box-sizing: border-box;" /><br style="box-sizing: border-box;" /><span style="box-sizing: border-box;">De halternek voegt een vleugje durf en verfijning toe, </span> waarbij<span style="box-sizing: border-box;">je huid subtiel wordt onthuld en je sensualiteit wordt onthuld</span>.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringDe sensuele, verfijnde look maakt het een onmiskenbare verleidelijke aanwinst. Draag hem om je partner te verrassen, deze guêpière zal zeker indruk maken.
keywords
string
title
stringVisnet kruisbustier
seotitle
stringVisnet kruisbustier
seouri
stringvisnet-kruisbustier-zwart
specifications
string
stylingtips
string
summary
stringDe sensuele, verfijnde look maakt het een onmiskenbare verleidelijke aanwinst. Draag hem om je partner te verrassen, deze gu&ecirc;pi&egrave;re zal zeker indruk maken.
title
stringVisnet kruisbustier
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<span style="box-sizing: border-box;">O nosso soutien longo de rede cruzada oferece conforto e sensualidade.</span><br style="box-sizing: border-box;" /><br style="box-sizing: border-box;" /><span style="box-sizing: border-box;">Com as suas tiras cruzadas, realça as curvas do seu corpo e cria um efeito visual muito sedutor.</span><br style="box-sizing: border-box;" /><br style="box-sizing: border-box;" /><span style="box-sizing: border-box;">O decote haltere dá um toque de ousadia e sofisticação, </span> revelando<span style="box-sizing: border-box;">subtilmente a sua pele e a sua sensualidade</span>.
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringO seu aspeto sensual e requintado torna-o um trunfo de sedução inegável. Use-o para surpreender o seu parceiro, este guêpière não deixará de causar impacto.
keywords
string
title
stringCorpete de rede cruzada
seotitle
stringCorpete de rede cruzada
seouri
stringcorpete-de-rede-cruzada-preto
specifications
string
stylingtips
string
summary
stringO seu aspeto sensual e requintado torna-o um trunfo de sedução inegável. Use-o para surpreender o seu parceiro, este gu&ecirc;pi&egrave;re não deixará de causar impacto.
title
stringCorpete de rede cruzada
usageinstructions
string
name
stringBlack Halter Neck Mesh Bondage Sexy Garter Lingerie R81175P
netweight
string
nextshipment
stringtoday
ordered
number1
orderidx
number0
origin
string
originalsize
string
packaging
string
productshipment
stringauto
productuid
string9FCCACC0-721C-45FB-8ED5ACC3403B735E
promountil
string
rating
stringnone
recorduid
string9FCCACC0-721C-45FB-8ED5ACC3403B735E
reference
stringSBBU4290
related
string
reserved
string
returned
number0
returnsallowed
number1
section
stringlingerie
shipment
string5to7days
showbrand
number0
sizeinfos
Query
Template: /system/api/product/sizes.cfc:20
Execution Time: 1.96 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,'1093,1137,1136,1888') > 0
and product_variations.productuid = '9FCCACC0-721C-45FB-8ED5ACC3403B735E'
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
1109338-40intlsizeblack3840-19999990wpluslingerieM-L38-4038-408-1012-1440-4240-4238-4044-4640-4238-4092-10074-8298-106
2113744-46intlsizeblack4446-19999990wpluslingerieXL-2XL44-4644-4614-1618-2246-4846-4844-4650-5246-4844-46102-10886-92108-114
3113648-50intlsizeblack4850-19999990wpluslingerie3XL-4XL48-5048-5018-2022-2450-5250-5248-5054-5650-5248-50110-11696-102116-122
sizeranges
stringplus,standard
sizes
string1093,1137,1136,1888
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: 7.65 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 = '9FCCACC0-721C-45FB-8ED5ACC3403B735E'
and product_variations.isactive = 1
and product_sizes.id_size = 1093
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 = '9FCCACC0-721C-45FB-8ED5ACC3403B735E'
and product_variations.isactive = 1
and product_sizes.id_size = 1137
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 = '9FCCACC0-721C-45FB-8ED5ACC3403B735E'
and product_variations.isactive = 1
and product_sizes.id_size = 1136
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 = '9FCCACC0-721C-45FB-8ED5ACC3403B735E'
and product_variations.isactive = 1
and product_sizes.id_size = 1888
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
19FCCACC0-721C-45FB-8ED5ACC3403B735EA9A4B47D-D439-48BA-AFBD7C9CCB1BB09E1093black#000000M-L38-4038-408-1012-1440-4240-4238-4044-4640-4238-40wlingerie38-40intlsize29.1250STOCK01000-10100R81175R811750115-10all
29FCCACC0-721C-45FB-8ED5ACC3403B735E4B736E49-CBFC-4FB6-BF799B4B2B27E4B61137black#000000XL-2XL44-4644-4614-1618-2246-4846-4844-4650-5246-4844-46wlingerie44-46intlsize29.1250STOCK01000-10100R811750117-10all
39FCCACC0-721C-45FB-8ED5ACC3403B735E5C1D8310-3AF9-4E70-8E9AAFE99EE5E1681136black#0000003XL-4XL48-5048-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie48-50intlsize29.1250STOCK01000-10100R81175R811750119-10all
subcategory
stringbustier
supplier
number-1
supplierreference
stringR81175P
tags
string
themes
string
totalvariations
string
type
stringdefault
unitprice
number29.125
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 13.2 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 = '9FCCACC0-721C-45FB-8ED5ACC3403B735E' 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 = '9FCCACC0-721C-45FB-8ED5ACC3403B735E' 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 = '9FCCACC0-721C-45FB-8ED5ACC3403B735E' 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 = '9FCCACC0-721C-45FB-8ED5ACC3403B735E' 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 = '9FCCACC0-721C-45FB-8ED5ACC3403B735E' 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 = '9FCCACC0-721C-45FB-8ED5ACC3403B735E' 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 = '9FCCACC0-721C-45FB-8ED5ACC3403B735E'
and product_variations.isactive = 1
and product_sizes.id_size = 1093
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 = '9FCCACC0-721C-45FB-8ED5ACC3403B735E' 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 = '9FCCACC0-721C-45FB-8ED5ACC3403B735E' 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 = '9FCCACC0-721C-45FB-8ED5ACC3403B735E' 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 = '9FCCACC0-721C-45FB-8ED5ACC3403B735E' 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 = '9FCCACC0-721C-45FB-8ED5ACC3403B735E' 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 = '9FCCACC0-721C-45FB-8ED5ACC3403B735E' 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 = '9FCCACC0-721C-45FB-8ED5ACC3403B735E'
and product_variations.isactive = 1
and product_sizes.id_size = 1137
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 = '9FCCACC0-721C-45FB-8ED5ACC3403B735E' 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 = '9FCCACC0-721C-45FB-8ED5ACC3403B735E' 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 = '9FCCACC0-721C-45FB-8ED5ACC3403B735E' 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 = '9FCCACC0-721C-45FB-8ED5ACC3403B735E' 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 = '9FCCACC0-721C-45FB-8ED5ACC3403B735E' 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 = '9FCCACC0-721C-45FB-8ED5ACC3403B735E' 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 = '9FCCACC0-721C-45FB-8ED5ACC3403B735E'
and product_variations.isactive = 1
and product_sizes.id_size = 1136
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 = '9FCCACC0-721C-45FB-8ED5ACC3403B735E' 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 = '9FCCACC0-721C-45FB-8ED5ACC3403B735E' 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 = '9FCCACC0-721C-45FB-8ED5ACC3403B735E' 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 = '9FCCACC0-721C-45FB-8ED5ACC3403B735E' 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 = '9FCCACC0-721C-45FB-8ED5ACC3403B735E' 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 = '9FCCACC0-721C-45FB-8ED5ACC3403B735E' 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 = '9FCCACC0-721C-45FB-8ED5ACC3403B735E'
and product_variations.isactive = 1
and product_sizes.id_size = 1888
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
1A9A4B47D-D439-48BA-AFBD7C9CCB1BB09E1093black#000000M-L38-4038-408-1012-1440-4240-4238-4044-4640-4238-40wlingerie38-40intlsize29.1250STOCK01000-10100R81175R811750115-10-10-10029.125all
24B736E49-CBFC-4FB6-BF799B4B2B27E4B61137black#000000XL-2XL44-4644-4614-1618-2246-4846-4844-4650-5246-4844-46wlingerie44-46intlsize29.1250STOCK01000-10100R811750117-10-10-10029.125all
35C1D8310-3AF9-4E70-8E9AAFE99EE5E1681136black#0000003XL-4XL48-5048-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie48-50intlsize29.1250STOCK01000-10100R81175R811750119-10-10-10029.125all
vatrate
number20
warehouse
string