Mijn mand

❌
Totaal aantal items
Winkelmand bekijken
Menu
Maten bekijken
Pinky Girl borstopenende jurk
Dubbelklikken om te vergroten
SKU: CDBU9410
Pinky Girl borstopenende jurk
Voorraad:

Maak je klaar om de show te stelen en hoofden te laten omdraaien met deze sensationele jurk. Wees brutaal, wees mooi, wees Pinky Girl.

Maat:

Weet je niet zeker welke maat je moet kiezen? Raadpleeg onze maattabel

Kleur:
Hoeveelheid:
69.95 €
Goed advies
via chat, facebook of e-mail
Gratis retourneren
binnen 15 dagen *

Hete roze jurk groote maat

Productomschrijving

De Pinky Girl jurk is een gedurfd en sexy meesterwerk.

Deze roze jurk is gemaakt van een rekbaar imitatieleren materiaal en voelt luxueus aan. De flatterende pasvorm laat je rondingen goed uitkomen.

Maar wat deze jurk echt uniek maakt is het gedurfde detail op de bh. Deze is gemaakt van zwarte tule en kan onder of boven de buste worden geplaatst, afhankelijk van je stemming en je lef. Je kunt ervoor kiezen om je voluptueuze decolleté door de transparante tule te laten schijnen, of je kunt kiezen voor een mysterieuzere look door de stof te laten zakken. Wat je ook kiest, je zult zeker bewonderende blikken trekken.

Bovendien kun je met de verstelbare bandjes de snit personaliseren en voor een perfecte pasvorm zorgen.


En laten we de zoom aan de onderkant niet vergeten, gemaakt met zwarte tule ruches. Deze elegante, vrouwelijke afwerking voegt een extra vleugje glamour toe aan een toch al fantastische jurk.

Technische details

Beschikbaar maten

Beschikbaar van 38-40 tot 54-56

Beschikbaar kleur

Roze

Maattabel

Controleer de juiste maat voor jou

Internationale
  • Borst
  • Maat
  • Heupen
38-40
  • 92-96
  • 70-78
  • 97-104
42-44
  • 97-104
  • 79-87
  • 105-112
46-48
  • 105-113
  • 88-98
  • 113-121
50-52
  • 114-127
  • 99-112
  • 122-132
54-56
  • 128-134
  • 113-121
  • 133-144
To Top
Winkelmand bekijken
Artikelen
Totaal aantal items
Struct
Entries: 108
actions
Array
available
number-1
brand
stringandalea
brandcode
stringaxpx
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
stringAndalea
breasts
stringna
careinstructions
string
categories
stringdivasboudoir.cabaret.dresses.all,divasboudoir.lingerie.sexylingerie.babydoll
category
stringdresses
categorygender
stringf
categorymediadatas
Struct
adult
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string615
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/cabaret/dresses1.jpg
type
stringimg
width
string1336
divasboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
fetishboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
latexboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
legsboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
lustboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
private
Struct
height
string1016
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/private/default.jpg
type
stringimg
width
string703
smboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
categorysizerange
stringauto
colorinfos
Query
Template: /system/api/product/colors.cfc:13
Execution Time: 0.758 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,'pink') > 0
and product_variations.productuid = 'D6C491B3-CF93-4FB6-A1B308C97651AD9F'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1pinkcolorpinkpinkpink#FE70BD-10
colorrange
stringpink
colors
stringpink
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-10-24 17:13:37'}
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
number58.2917
itempromo
string
key
stringpink-wetlook-chemise-z5014
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-08-01 19:21:48'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.642 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','nl')
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('d6c491b3-cf93-4fb6-a1b308c97651ad9f',lcase(cart_actions.linkedproducts)) > 0 and cart_actions.linkedproducts is not null
)
id_actionbrandinglanguagenamecodetypeminimumOrdermaximumOrderminimumItemsmaximumItemsmaximumUseallowedItemsquotasusedCountlinkedproductslinkedthemeslinkedbrandslinkeditemparamsactiveFromactiveToisActive
linkedproducts
Query
Template: /system/api/products.cfc:1305
Execution Time: 1.31 ms
Record Count: 0
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select products.productuid as productuid, products.reference, 'default' as type, products.key, products.language, products.name,
product_links.linkuid,
products.colors, products.vatrate, products.metadatas, products.dimensions,
products.mediadatas, products.tags, products.themes, products.isdivasize,
count(distinct product_variations.variationuid) as totalvariations,
group_concat(distinct product_variations.variationuid) as variationlist,
count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END) as inpromo,
if(count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END)>0,1,0) as haspromo,
(select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0) END)) as itempromo,
IFNULL(min(product_variations.itemprice),0) as itemprice,
(select IF (products.isfixedprice = 0 and sum(product_variations.itempromo) > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null), IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0), IFNULL(min(NULLIF(product_variations.itemprice, 0)), 0) )) as unitprice,
count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.itempromo ELSE product_variations.itemprice END) as prices,
(select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN min(NULLIF(product_variations.promountil, 0)) END)) as promountil,
products.isfixedprice, products.ishot, products.isnew, if(products.orderidx > 0, products.orderidx, 999999999) as orderidx,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
count(distinct CASE WHEN ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) > 0 OR ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) <= 0 AND product_variations.supplier = 0)) THEN product_variations.variationuid END) as instockvariations,
products.brand, brands.name as brandname, IFNULL(brands.ispublic, 0) as showbrand, brands.display,
product_categories.sizetype,GROUP_CONCAT(DISTINCT product_sizes.suppliersize) as intlsize,products.sizes,product_sizes.sizerange,product_categories.mediadatas as categorymediadatas, product_categories.sizerange as categorysizerange,
product_categorymap.section, product_categorymap.category, product_categorymap.key as subcategory
from products
left outer join product_categorymap on products.productuid = product_categorymap.productuid
left outer join product_categories on (product_categories.branding = product_categorymap.branding and product_categories.section = product_categorymap.section and product_categories.category = product_categorymap.category and product_categories.key = product_categorymap.key)
left outer join product_sizes on product_sizes.id_size IN (products.sizes)
left outer join brands on products.brand = brands.brand
left outer join product_variations on product_variations.productuid = products.productuid and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
left outer join product_links on product_links.reference = products.reference
where products.isactive = 1 and products.isdeleted = 0
and brands.isactive = 1 and brands.isdeleted = 0
and product_categories.isactive = 1 and product_categories.isdeleted = 0
and product_variations.isactive = 1
and FIND_IN_SET('divasboudoir',products.branding)
and product_categories.branding IN ('all','divasboudoir')
and product_categorymap.branding IN ('all','divasboudoir')
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and products.language in ('all','nl')
and product_categories.language in ('all','nl')
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 <> 'CDBU9410'
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
string733
isprivate
string0
rating
stringall
src
string/photobank/products/axpx/cdbu9410/25123778.jpg
type
stringimg
width
string507
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string741
isprivate
string0
rating
stringall
src
string/photobank/products/axpx/cdbu9410/25123820.jpg
type
stringimg
width
string512
variations
Struct
colors
Struct
pink
Struct
height
string733
isprivate
string0
rating
stringall
src
string/photobank/products/axpx/cdbu9410/25123778.jpg
type
stringimg
width
string507
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-rosa
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-roz
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-pink
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-rosa
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-rose
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-rosa
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-roze
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-cor-de-rosa
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
divasboudoir
Struct
de
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p><span>Das Kleid Pinky Girl ist ein gewagtes und sexy Meisterwerk.</span></p> <p><span> Hergestellt aus einem dehnbaren Kunstledermaterial, bietet dieses pinkfarbene Kleid ein luxuriöses Tragegefühl und einen schmeichelhaften Schnitt, der Ihre Kurven betont.</span><br /><br /><span>Was dieses Kleid jedoch wirklich einzigartig macht, ist das gewagte Detail am BH. Er ist aus schwarzem Tüll gefertigt und kann je nach Stimmung und Kühnheit über oder unter der Brust verschoben werden. Sie können sich dafür entscheiden, Ihr üppiges Dekollet&eacute; durch den transparenten Tüll schimmern zu lassen, oder Sie entscheiden sich für einen geheimnisvolleren Look, indem Sie den Stoff nach unten ziehen. Wie auch immer Sie sich entscheiden, bewundernde Blicke sind Ihnen auf jeden Fall sicher.</span><br /><br /><span>Außerdem können Sie mit den verstellbaren Trägern den Schnitt individuell anpassen und sich eine perfekte Passform sichern. </span></p> <p><br /><span>Und vergessen wir nicht den unteren Saum, der aus schwarzen Tüll-Rüschen besteht. Diese elegante und feminine Verarbeitung verleiht diesem ohnehin schon fabelhaften Kleid einen zusätzlichen Hauch von Glamour.</span></p>
guid
stringhttps://dev.divasboudoir.com/de/kleid-in-ubergrosse-in-leuchtendem-pink-rosa/cdbu9410.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringVerführen Sie mit dem Pinki Girl Kleid in Übergröße aus leuchtend rosafarbenem Kunstleder. Ein extravaganter und hypersexy Look für einen Abend oder die ganze Nacht. Aufmachbare Cups
keywords
string
title
stringKleid Große Größe Pinky Girl - Look Girly
seotitle
stringKleid in Übergröße in leuchtendem Pink
seouri
stringkleid-in-ubergrosse-in-leuchtendem-pink-rosa
specifications
string
stylingtips
string
summary
string<p><span>Bereiten Sie sich mit diesem sensationellen Kleid darauf vor, die Show zu stehlen und Köpfe zu verdrehen. Seien Sie mutig, seien Sie schön, seien Sie Pinky Girl.</span></p>
title
stringKleid, das sich über den Brüsten öffnen lässt Pinky Girl
usageinstructions
string
el
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p><span>Το φόρεμα Pinky Girl είναι ένα τολμηρό και σέξι αριστούργημα.</span></p> <p><span> Κατασκευασμένο από ελαστικό υλικό από ψεύτικο δέρμα, αυτό το ροζ φόρεμα έχει πολυτελή αίσθηση και κολακευτική εφαρμογή που θα αναδείξει τις καμπύλες σας.</span><br /><br /><span>Αλλά αυτό που πραγματικά κάνει αυτό το φόρεμα μοναδικό είναι η τολμηρή λεπτομέρεια στο σουτιέν. Κατασκευασμένο από μαύρο τούλι, μπορεί να μετακινηθεί πάνω ή κάτω από το μπούστο, ανάλογα με τη διάθεση και την τόλμη σας. Μπορείτε να επιλέξετε να αφήσετε το πλούσιο ντεκολτέ σας να λάμψει μέσα από το διάφανο τούλι ή μπορείτε να επιλέξετε μια πιο μυστηριώδη εμφάνιση κατεβάζοντας το ύφασμα. Ό,τι κι αν αποφασίσετε, είναι βέβαιο ότι θα προσελκύσετε τα βλέμματα θαυμασμού.</span><br /><br /><span>Επιπλέον, οι ρυθμιζόμενοι ιμάντες σας επιτρέπουν να προσαρμόσετε το κόψιμο και να εξασφαλίσετε τέλεια εφαρμογή. </span></p> <p><br /><span>Και ας μην ξεχνάμε το κάτω μέρος του στρίφωματος, φτιαγμένο με μαύρα τούλινα βολάν. Αυτό το κομψό, θηλυκό φινίρισμα προσθέτει μια έξτρα πινελιά γοητείας σε ένα ήδη υπέροχο φόρεμα.</span></p>
guid
stringhttps://dev.divasboudoir.com/el/zesto-roz-syn-megethos-forema-roz/cdbu9410.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringΓίνετε σαγηνευτική με το φόρεμα Pinki Girl plus-size σε έντονο ροζ χρώμα από faux leather. Μια εξωφρενική, εξαιρετικά σέξι εμφάνιση για μια βραδινή έξοδο ή για όλη τη νύχτα. Άνοιγμα φλιτζανιών
keywords
string
title
stringΖεστό ροζ συν μέγεθος φόρεμα
seotitle
stringΖεστό ροζ συν μέγεθος φόρεμα
seouri
stringzesto-roz-syn-megethos-forema-roz
specifications
string
stylingtips
string
summary
string<p><span>Ετοιμαστείτε να κλέψετε την παράσταση και να τραβήξετε τα βλέμματα με αυτό το εντυπωσιακό φόρεμα. Να είστε τολμηρή, να είστε όμορφη, να είστε το Pinky Girl.</span></p>
title
stringPinky Girl φόρεμα που ανοίγει το στήθος
usageinstructions
string
en
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p><span>The Pinky Girl dress is a bold and sexy masterpiece.</span></p> <p><span> Made from stretchy simlic leather material, this pink dress offers a luxurious feel and flattering fit that will show off your curves.</span><br /><br /><span>But what really makes this dress unique is the bold detail on the bra. Made from black tulle, it can be moved above or below the bust, depending on your mood and boldness. You can choose to let your voluptuous cleavage shine through the sheer tulle, or you can opt for a more mysterious look by lowering the fabric. Whichever you decide, you're sure to attract admiring glances.</span><br /><br /><span>What's more, the adjustable straps let you customize the cut and ensure a perfect fit. </span></p> <p><br /><span>And let's not forget the bottom hem, made with black tulle ruffles. This elegant, feminine finish adds an extra touch of glamour to this already fabulous dress.</span></p>
guid
stringhttps://dev.divasboudoir.com/en/hot-pink-plus-size-dress-pink/cdbu9410.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringSeduce with the Pinki Girl plus size dress in hot pink faux leather. An extravagantly sexy look for an evening out or all night long. Opening cups
keywords
string
title
stringPlus size dress Pinky Girl - Look Girly
seotitle
stringHot pink plus size dress
seouri
stringhot-pink-plus-size-dress-pink
specifications
string
stylingtips
string
summary
string<p><span>Get ready to steal the show and turn heads with this sensational dress. Be bold, be beautiful, be Pinky Girl.</span></p>
title
stringPinky Girl breast-opening dress
usageinstructions
string
es
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p><span>El vestido Pinky Girl es una obra maestra atrevida y sexy.</span></p> <p><span> Confeccionado en un material elástico de piel sintética, este vestido rosa tiene un tacto lujoso y un corte favorecedor que lucirá tus curvas.</span><br /><br /><span>Pero lo que realmente hace único a este vestido es el atrevido detalle del sujetador. Fabricado en tul negro, se puede mover por encima o por debajo del pecho, según tu estado de ánimo y atrevimiento. Puedes optar por dejar que tu voluptuoso escote brille a través del tul transparente, u optar por un look más misterioso bajando la tela. Decidas lo que decidas, seguro que atraerás miradas de admiración.</span><br /><br /><span>Además, los tirantes ajustables te permiten personalizar el corte y garantizar un ajuste perfecto. </span></p> <p><br /><span>Y no olvidemos el dobladillo inferior, confeccionado con volantes de tul negro. Este acabado elegante y femenino añade un toque de glamour a un vestido ya de por sí fabuloso.</span></p>
guid
stringhttps://dev.divasboudoir.com/es/vestido-talla-grande-rosa-picante-rosa/cdbu9410.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringSé seductora con el vestido de talla grande Pinki Girl en piel sintética rosa brillante. Un look extravagante y ultra sexy para salir por la noche o para toda la noche. Copas de apertura
keywords
string
title
stringVestido talla grande Pinky Girl - Look Girly
seotitle
stringVestido talla grande rosa picante
seouri
stringvestido-talla-grande-rosa-picante-rosa
specifications
string
stylingtips
string
summary
string<p><span>Prepárate para acaparar todas las miradas con este sensacional vestido. Sé atrevida, sé guapa, sé Pinky Girl.</span></p>
title
stringVestido con abertura de pecho Pinky Girl
usageinstructions
string
fr
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p><span>La robe pinky Girl est un chef-d'&oelig;uvre audacieux et sexy.</span></p> <p><span> Fabriqu&eacute;e &agrave; partir d'un mat&eacute;riau simlicuir extensible, cette robe rose offre une sensation luxueuse et une coupe flatteuse qui mettra en valeur vos courbes.</span><br /><br /><span>Mais ce qui rend vraiment cette robe unique, c'est le d&eacute;tail audacieux sur le soutien-gorge. Fabriqu&eacute; en tulle noir, il peut &ecirc;tre d&eacute;plac&eacute; au-dessus ou en dessous de la poitrine, selon votre humeur et votre audace. Vous pouvez choisir de laisser votre d&eacute;collet&eacute; voluptueux briller &agrave; travers le tulle transparent, ou vous pouvez opter pour un look plus myst&eacute;rieux en abaissant le tissu. Quelle que soit votre d&eacute;cision, vous &ecirc;tes s&ucirc;r d'attirer tous les regards admiratifs.</span><br /><br /><span>De plus, les bretelles r&eacute;glables vous permettent de personnaliser la coupe et de vous assurer un ajustement parfait.&nbsp;&nbsp;</span></p> <p><br /><span>Et n'oublions pas l'ourlet inf&eacute;rieur, fait de volants en tulle noir. Cette finition &eacute;l&eacute;gante et f&eacute;minine apporte une touche de glamour suppl&eacute;mentaire &agrave; cette robe d&eacute;j&agrave; fabuleuse.</span></p>
guid
stringhttps://dev.divasboudoir.com/fr/robe-grande-taille-rose-vif-rose/cdbu9410.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringSéduisez avec la robe grande taille pinki Girl en similicuir rose vif. Un look extravagant et hyper sexy pour une soirée ou pour toute la nuit. Bonnets ouvrables
keywords
string
title
stringRobe Grande Taille pinky Girl - Look Girly
seotitle
stringRobe grande taille rose vif
seouri
stringrobe-grande-taille-rose-vif-rose
specifications
string
stylingtips
string
summary
string<p><span>Pr&eacute;parez-vous &agrave; voler la vedette et &agrave; faire tourner les t&ecirc;tes avec cette robe sensationnelle. Soyez audacieuse, soyez belle, soyez pinky Girl.</span></p>
title
stringRobe ouvrable sur les seins pinky Girl
usageinstructions
string
it
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p><span>L'abito Pinky Girl è un capolavoro audace e sexy.</span></p> <p><span> Realizzato in ecopelle elasticizzata, questo abito rosa è lussuoso al tatto e ha una vestibilità comoda che mette in risalto le vostre curve.</span><br /><br /><span>Ma ciò che rende questo abito davvero unico è il dettaglio audace del reggiseno. Realizzato in tulle nero, può essere spostato sopra o sotto il seno, a seconda del vostro umore e della vostra audacia. Potete scegliere di lasciare che il vostro voluttuoso décolleté risplenda attraverso il tulle trasparente, oppure potete optare per un look più misterioso abbassando il tessuto. Qualunque sia la vostra scelta, attirerete sicuramente sguardi ammirati.</span><br /><br /><span>Inoltre, le spalline regolabili consentono di personalizzare il taglio e di garantire una vestibilità perfetta. </span></p> <p><br /><span>E non dimentichiamo l'orlo inferiore, realizzato con rouches di tulle nero. Questa finitura elegante e femminile aggiunge un tocco di glamour in più a un abito già favoloso.</span></p>
guid
stringhttps://dev.divasboudoir.com/it/abito-rosa-caldo-taglia-grande-rosa/cdbu9410.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringSiate seducenti con l'abito Pinki Girl di taglia grande in ecopelle rosa acceso. Un look stravagante e ultra-sexy per una serata fuori o per tutta la notte. Apertura coppe
keywords
string
title
stringAbito Pinky Girl taglia grande - Look Girly
seotitle
stringAbito rosa caldo taglia grande
seouri
stringabito-rosa-caldo-taglia-grande-rosa
specifications
string
stylingtips
string
summary
string<p><span>Preparatevi a rubare la scena e a far girare la testa con questo abito sensazionale. Siate audaci, siate belle, siate Pinky Girl.</span></p>
title
stringAbito Pinky Girl che apre il seno
usageinstructions
string
nl
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p><span>De Pinky Girl jurk is een gedurfd en sexy meesterwerk.</span></p> <p><span> Deze roze jurk is gemaakt van een rekbaar imitatieleren materiaal en voelt luxueus aan. De flatterende pasvorm laat je rondingen goed uitkomen.</span><br /><br /><span>Maar wat deze jurk echt uniek maakt is het gedurfde detail op de bh. Deze is gemaakt van zwarte tule en kan onder of boven de buste worden geplaatst, afhankelijk van je stemming en je lef. Je kunt ervoor kiezen om je voluptueuze decolleté door de transparante tule te laten schijnen, of je kunt kiezen voor een mysterieuzere look door de stof te laten zakken. Wat je ook kiest, je zult zeker bewonderende blikken trekken.</span><br /><br /><span>Bovendien kun je met de verstelbare bandjes de snit personaliseren en voor een perfecte pasvorm zorgen. </span></p> <p><br /><span>En laten we de zoom aan de onderkant niet vergeten, gemaakt met zwarte tule ruches. Deze elegante, vrouwelijke afwerking voegt een extra vleugje glamour toe aan een toch al fantastische jurk.</span></p>
guid
stringhttps://dev.divasboudoir.com/nl/hete-roze-jurk-groote-maat-roze/cdbu9410.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringWees verleidelijk met de Pinki Girl jurk van groote maat in felroze imitatieleer. Een extravagante, ultra-sexy look voor een avondje uit of de hele nacht lang. Openende cups
keywords
string
title
stringPinky Girl jurkje groote maat - Look Girly
seotitle
stringHete roze jurk groote maat
seouri
stringhete-roze-jurk-groote-maat-roze
specifications
string
stylingtips
string
summary
string<p><span>Maak je klaar om de show te stelen en hoofden te laten omdraaien met deze sensationele jurk. Wees brutaal, wees mooi, wees Pinky Girl.</span></p>
title
stringPinky Girl borstopenende jurk
usageinstructions
string
pt
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p><span>O vestido Pinky Girl é uma obra-prima ousada e sexy.</span></p> <p><span> Feito de um material elástico de pele sintética, este vestido cor-de-rosa tem um toque luxuoso e um ajuste lisonjeiro que irá mostrar as suas curvas.</span><br /><br /><span>Mas o que realmente torna este vestido único é o pormenor ousado no sutiã. Feito de tule preto, pode ser movido acima ou abaixo do busto, dependendo da sua disposição e ousadia. Pode optar por deixar o seu voluptuoso decote brilhar através do tule transparente, ou pode optar por um look mais misterioso baixando o tecido. Seja qual for a sua decisão, irá certamente atrair olhares de admiração.</span><br /><br /><span>Além disso, as alças ajustáveis permitem-lhe personalizar o corte e garantir um ajuste perfeito. </span></p> <p><br /><span>E não esqueçamos a bainha inferior, feita com folhos de tule preto. Este acabamento elegante e feminino confere um toque extra de glamour a um vestido já de si fabuloso.</span></p>
guid
stringhttps://dev.divasboudoir.com/pt/vestido-rosa-choque-plus-size-cor-de-rosa/cdbu9410.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringSeja sedutora com o vestido plus size Pinki Girl em pele sintética cor-de-rosa brilhante. Um look extravagante e ultra-sexy para uma saída à noite ou para toda a noite. Abertura das copas
keywords
string
title
stringVestido plus size Pinky Girl - Look Girly
seotitle
stringVestido rosa choque plus size
seouri
stringvestido-rosa-choque-plus-size-cor-de-rosa
specifications
string
stylingtips
string
summary
string<p><span>Prepare-se para roubar o espetáculo e virar cabeças com este vestido sensacional. Seja ousada, seja bonita, seja a Pinky Girl.</span></p>
title
stringVestido com abertura para o peito Pinky Girl
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-rosa
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-roz
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-pink
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-rosa
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-rose
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-rosa
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-roze
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-cor-de-rosa
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-rosa
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-roz
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-pink
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-rosa
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-rose
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-rosa
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-roze
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-cor-de-rosa
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-rosa
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-roz
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-pink
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-rosa
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-rose
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-rosa
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-roze
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-cor-de-rosa
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-rosa
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-roz
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-pink
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-rosa
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-rose
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-rosa
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-roze
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-cor-de-rosa
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
smboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>Das Kleid pinky Girl ist ein gewagtes und sexy Meisterwerk.</span></p> <p><span> Hergestellt aus einem dehnbaren Kunstledermaterial, bietet dieses pinkfarbene Kleid ein luxuriöses Tragegefühl und einen schmeichelhaften Schnitt, der Ihre Kurven betont.</span><br /><br /><span>Was dieses Kleid jedoch wirklich einzigartig macht, ist das gewagte Detail am BH. Er ist aus schwarzem Tüll gefertigt und kann je nach Lust und Laune und Mut über oder unter der Brust bewegt werden. Sie können sich dafür entscheiden, Ihr üppiges Dekollet&eacute; durch den transparenten Tüll schimmern zu lassen, oder Sie entscheiden sich für einen geheimnisvolleren Look, indem Sie den Stoff nach unten ziehen. Wie auch immer Sie sich entscheiden, bewundernde Blicke sind Ihnen auf jeden Fall sicher.</span><br /><br /><span>Außerdem können Sie mit den verstellbaren Trägern den Schnitt individuell anpassen und sich eine perfekte Passform sichern. </span></p> <p><br /><span>Und vergessen wir nicht den unteren Saum, der aus schwarzen Tüll-Rüschen besteht. Diese elegante und feminine Verarbeitung verleiht diesem ohnehin schon fabelhaften Kleid einen zusätzlichen Hauch von Glamour.</span></p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringVerführen Sie mit dem pinki Girl Kleid in Übergröße aus leuchtend rosafarbenem Kunstleder. Ein extravaganter und hypersexy Look für einen Abend oder die ganze Nacht. Aufmachbare Cups
keywords
string
title
stringKleid Große Größe pinky Girl - Look Girly
seotitle
stringKleid in Übergröße, offen, hellrosa
seouri
stringkleid-in-ubergrosse,-offen,-hellrosa-rosa
specifications
string
stylingtips
string
summary
string<p><span>Bereiten Sie sich mit diesem sensationellen Kleid darauf vor, die Show zu stehlen und Köpfe zu verdrehen. Seien Sie mutig, seien Sie schön, seien Sie pinky Girl.</span></p>
title
stringOffenes Kleid pinky Girl
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>Το φόρεμα Pinky Girl είναι ένα τολμηρό και σέξι αριστούργημα.</span></p> <p><span> Κατασκευασμένο από ελαστικό υλικό από ψεύτικο δέρμα, αυτό το ροζ φόρεμα έχει πολυτελή αίσθηση και κολακευτική εφαρμογή που θα αναδείξει τις καμπύλες σας.</span><br /><br /><span>Αλλά αυτό που πραγματικά κάνει αυτό το φόρεμα μοναδικό είναι η τολμηρή λεπτομέρεια στο σουτιέν. Κατασκευασμένο από μαύρο τούλι, μπορεί να μετακινηθεί πάνω ή κάτω από το μπούστο, ανάλογα με τη διάθεση και την τόλμη σας. Μπορείτε να επιλέξετε να αφήσετε το πλούσιο ντεκολτέ σας να λάμψει μέσα από το διάφανο τούλι ή μπορείτε να επιλέξετε μια πιο μυστηριώδη εμφάνιση κατεβάζοντας το ύφασμα. Ό,τι κι αν αποφασίσετε, είναι βέβαιο ότι θα προσελκύσετε τα βλέμματα θαυμασμού.</span><br /><br /><span>Επιπλέον, οι ρυθμιζόμενοι ιμάντες σας επιτρέπουν να προσαρμόσετε το κόψιμο και να εξασφαλίσετε τέλεια εφαρμογή. </span></p> <p><br /><span>Και ας μην ξεχνάμε το κάτω μέρος του στρίφωματος, φτιαγμένο με μαύρα τούλινα βολάν. Αυτό το κομψό, θηλυκό φινίρισμα προσθέτει μια έξτρα πινελιά γοητείας σε ένα ήδη υπέροχο φόρεμα.</span></p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringΓίνετε σαγηνευτική με το φόρεμα pinki Girl plus-size σε έντονο ροζ χρώμα από faux leather. Μια εξωφρενική, σέξι εμφάνιση για μια βραδινή έξοδο ή για όλη τη νύχτα. Ανοιγόμενα φλιτζάνια
keywords
string
title
stringGrande Taille ροζ φόρεμα για κορίτσια - Look Girly
seotitle
stringΜεγάλο ανοιχτό φόρεμα σε έντονο ροζ
seouri
stringmegalo-anoichto-forema-se-entono-roz-roz
specifications
string
stylingtips
string
summary
string<p><span>Ετοιμαστείτε να κλέψετε την παράσταση και να τραβήξετε τα βλέμματα με αυτό το εντυπωσιακό φόρεμα. Γίνε τολμηρή, όμορφη, ροζ κοπέλα.</span></p>
title
stringPinky Girl ανοιχτό φόρεμα
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>The pinky Girl dress is a bold and sexy masterpiece.</span></p> <p><span> Made from stretchy simlic leather material, this pink dress offers a luxurious feel and flattering fit that will show off your curves.</span><br /><br /><span>But what really makes this dress unique is the bold detail on the bra. Made from black tulle, it can be moved above or below the bust, depending on your mood and boldness. You can choose to let your voluptuous cleavage shine through the sheer tulle, or you can opt for a more mysterious look by lowering the fabric. Whichever you decide, you're sure to attract admiring glances.</span><br /><br /><span>What's more, the adjustable straps let you customize the cut and ensure a perfect fit. </span></p> <p><br /><span>And let's not forget the bottom hem, made with black tulle ruffles. This elegant, feminine finish adds an extra touch of glamour to this already fabulous dress.</span></p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringSeduce with the pinki Girl plus size dress in hot pink faux leather. An extravagantly sexy look for an evening out or all night long. Opening cups
keywords
string
title
stringPlus size pinky Girl dress - Look Girly
seotitle
stringBright pink open plus size dress
seouri
stringbright-pink-open-plus-size-dress-pink
specifications
string
stylingtips
string
summary
string<p><span>Get ready to steal the show and turn heads with this sensational dress. Be bold, be beautiful, be pinky Girl.</span></p>
title
stringPinky Girl open dress
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>El vestido Pinky Girl es una obra maestra atrevida y sexy.</span></p> <p><span> Confeccionado en un material elástico de piel sintética, este vestido rosa tiene un tacto lujoso y un ajuste favorecedor que lucirá tus curvas.</span><br /><br /><span>Pero lo que realmente hace único a este vestido es el atrevido detalle del sujetador. Fabricado en tul negro, se puede mover por encima o por debajo del pecho, según tu estado de ánimo y atrevimiento. Puedes optar por dejar que tu voluptuoso escote brille a través del tul transparente, u optar por un look más misterioso bajando la tela. Decidas lo que decidas, seguro que atraerás miradas de admiración.</span><br /><br /><span>Además, los tirantes ajustables te permiten personalizar el corte y garantizar un ajuste perfecto. </span></p> <p><br /><span>Y no hay que olvidar el dobladillo inferior, confeccionado con volantes de tul negro. Este acabado elegante y femenino añade un toque de glamour a un vestido ya de por sí fabuloso.</span></p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringSeduce con el vestido de talla grande Pinki Girl en piel sintética rosa brillante. Un look extravagante y ultra sexy para salir por la noche o para toda la noche. Copas de abertura
keywords
string
title
stringVestido talla grande pinky Girl - Look Girly
seotitle
stringVestido talla grande abierto en rosa brillante
seouri
stringvestido-talla-grande-abierto-en-rosa-brillante-rosa
specifications
string
stylingtips
string
summary
string<p><span>Prepárate para acaparar todas las miradas con este sensacional vestido. Sé atrevida, sé guapa, sé pinky girl.</span></p>
title
stringVestido abierto Pinky Girl
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>La robe pinky Girl est un chef-d'&oelig;uvre audacieux et sexy.</span></p> <p><span> Fabriqu&eacute;e &agrave; partir d'un mat&eacute;riau simlicuir extensible, cette robe rose offre une sensation luxueuse et une coupe flatteuse qui mettra en valeur vos courbes.</span><br><br><span>Mais ce qui rend vraiment cette robe unique, c'est le d&eacute;tail audacieux sur le soutien-gorge. Fabriqu&eacute; en tulle noir, il peut &ecirc;tre d&eacute;plac&eacute; au-dessus ou en dessous de la poitrine, selon votre humeur et votre audace. Vous pouvez choisir de laisser votre d&eacute;collet&eacute; voluptueux briller &agrave; travers le tulle transparent, ou vous pouvez opter pour un look plus myst&eacute;rieux en abaissant le tissu. Quelle que soit votre d&eacute;cision, vous &ecirc;tes s&ucirc;r d'attirer tous les regards admiratifs.</span><br><br><span>De plus, les bretelles r&eacute;glables vous permettent de personnaliser la coupe et de vous assurer un ajustement parfait.&nbsp;&nbsp;</span></p> <p><br><span>Et n'oublions pas l'ourlet inf&eacute;rieur, fait de volants en tulle noir. Cette finition &eacute;l&eacute;gante et f&eacute;minine apporte une touche de glamour suppl&eacute;mentaire &agrave; cette robe d&eacute;j&agrave; fabuleuse.</span></p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringSéduisez avec la robe grande taille pinki Girl en similicuir rose vif. Un look extravagant et hyper sexy pour une soirée ou pour toute la nuit. Bonnets ouvrables
keywords
string
title
stringRobe Grande Taille pinky Girl - Look Girly
seotitle
stringRobe grande taille ouverte rose vif
seouri
stringrobe-grande-taille-ouverte-rose-vif-rose
specifications
string
stylingtips
string
summary
string<p><span>Pr&eacute;parez-vous &agrave; voler la vedette et &agrave; faire tourner les t&ecirc;tes avec cette robe sensationnelle. Soyez audacieuse, soyez belle, soyez pinky Girl.</span></p>
title
stringRobe ouverte pinky Girl
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>L'abito Pinky Girl è un capolavoro audace e sexy.</span></p> <p><span> Realizzato in ecopelle elasticizzata, questo abito rosa è lussuoso al tatto e ha una vestibilità comoda che mette in risalto le vostre curve.</span><br /><br /><span>Ma ciò che rende questo abito davvero unico è il dettaglio audace sul reggiseno. Realizzato in tulle nero, può essere spostato sopra o sotto il seno, a seconda del vostro umore e della vostra audacia. Potete scegliere di lasciare che il vostro voluttuoso décolleté risplenda attraverso il tulle trasparente, oppure potete optare per un look più misterioso abbassando il tessuto. Qualunque sia la vostra scelta, attirerete sicuramente sguardi ammirati.</span><br /><br /><span>Inoltre, le spalline regolabili consentono di personalizzare il taglio e di garantire una vestibilità perfetta. </span></p> <p><br /><span>E non dimentichiamo l'orlo inferiore, realizzato con rouches di tulle nero. Questa finitura elegante e femminile aggiunge un tocco di glamour in più a un abito già favoloso.</span></p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringSiate seducenti con l'abito pinki Girl di taglia grande in ecopelle rosa acceso. Un look stravagante e sexy per una serata fuori o per tutta la notte. Apertura coppe
keywords
string
title
stringAbito da ragazza a taglia grande - Look Girly
seotitle
stringGrande abito aperto in rosa acceso
seouri
stringgrande-abito-aperto-in-rosa-acceso-rosa
specifications
string
stylingtips
string
summary
string<p><span>Preparatevi a rubare la scena e a far girare la testa con questo abito sensazionale. Siate audaci, bellissime, pinky girl.</span></p>
title
stringAbito aperto Pinky Girl
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>De pinky Girl jurk is een gedurfd en sexy meesterwerk.</span></p> <p><span> Deze roze jurk is gemaakt van een rekbaar imitatieleren materiaal en voelt luxe aan. De flatterende pasvorm laat je rondingen goed uitkomen.</span><br /><br /><span>Maar wat deze jurk echt uniek maakt is het gedurfde detail op de bh. Deze is gemaakt van zwarte tule en kan onder of boven de buste worden geplaatst, afhankelijk van je stemming en je lef. Je kunt ervoor kiezen om je voluptueuze decolleté door de transparante tule te laten schijnen, of je kunt kiezen voor een mysterieuzere look door de stof te laten zakken. Wat je ook kiest, je zult zeker bewonderende blikken trekken.</span><br /><br /><span>Bovendien kun je met de verstelbare bandjes de snit personaliseren en voor een perfecte pasvorm zorgen. </span></p> <p><br /><span>En laten we de zoom aan de onderkant niet vergeten, gemaakt met zwarte tule ruches. Deze elegante, vrouwelijke afwerking voegt een extra vleugje glamour toe aan een toch al fantastische jurk.</span></p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringWees verleidelijk met de pinki Girl grote maat jurk in felroze kunstleer. Een extravagante, super sexy look voor een avondje uit of de hele nacht door. Openende cups
keywords
string
title
stringGrote maat roze meisjesjurk - Look Girly
seotitle
stringHete roze jurk groote maat
seouri
stringhete-roze-jurk-groote-maat-roze
specifications
string
stylingtips
string
summary
string<p><span>Maak je klaar om de show te stelen en hoofden te laten omdraaien met deze sensationele jurk. Wees brutaal, wees mooi, wees een roze meisje.</span></p>
title
stringPinky Girl borstopenende jurk
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>O vestido Pinky Girl é uma obra-prima ousada e sexy.</span></p> <p><span> Feito de um material elástico de pele sintética, este vestido cor-de-rosa tem um toque luxuoso e um ajuste lisonjeiro que irá mostrar as suas curvas.</span><br /><br /><span>Mas o que realmente torna este vestido único é o pormenor ousado no sutiã. Feito de tule preto, pode ser movido acima ou abaixo do busto, dependendo da sua disposição e ousadia. Pode optar por deixar o seu voluptuoso decote brilhar através do tule transparente, ou pode optar por um look mais misterioso baixando o tecido. Seja qual for a sua decisão, irá certamente atrair olhares de admiração.</span><br /><br /><span>Além disso, as alças ajustáveis permitem-lhe personalizar o corte e garantir um ajuste perfeito. </span></p> <p><br /><span>E não esqueçamos a bainha inferior, feita com folhos de tule preto. Este acabamento elegante e feminino confere um toque extra de glamour a um vestido já de si fabuloso.</span></p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringSeja sedutora com o vestido plus size Pinki Girl em pele sintética cor-de-rosa brilhante. Um look extravagante e sexy para uma saída à noite ou para toda a noite. Abertura das copas
keywords
string
title
stringVestido Grande Taille pinky Girl - Look Girly
seotitle
stringVestido grande aberto em rosa vivo
seouri
stringvestido-grande-aberto-em-rosa-vivo-cor-de-rosa
specifications
string
stylingtips
string
summary
string<p><span>Prepare-se para roubar o espetáculo e virar cabeças com este vestido sensacional. Seja ousada, seja bonita, seja uma rapariga cor-de-rosa.</span></p>
title
stringVestido aberto Pinky Girl
usageinstructions
string
name
stringPINK WETLOOK CHEMISE Z/5014
netweight
string
nextshipment
stringtomorrow
ordered
number4
orderidx
number0
origin
string
originalsize
string
packaging
string
productshipment
stringauto
productuid
stringD6C491B3-CF93-4FB6-A1B308C97651AD9F
promountil
string
rating
stringnone
recorduid
stringD6C491B3-CF93-4FB6-A1B308C97651AD9F
reference
stringCDBU9410
related
string
reserved
string
returned
number0
returnsallowed
number1
section
stringcabaret
shipment
string4to6days
showbrand
number0
sizeinfos
Query
Template: /system/api/product/sizes.cfc:20
Execution Time: 1.43 ms
Record Count: 5
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,'2132,256,257,258,259') > 0
and product_variations.productuid = 'D6C491B3-CF93-4FB6-A1B308C97651AD9F'
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
1213238-40intlsizepink3840-19999990wpluslingerie38-4038-4038-408-1012-1440-4240-4238-4044-4640-4238-4092-9670-7897-104
225642-44intlsizepink4244-19999990wpluslingerie42-4442-4442-4412-1416-1844-4644-4642-4448-5044-4642-4497-10479-87105-112
325746-48intlsizepink4648-19999990wpluslingerie46-4846-4846-4816-1820-2248-5048-5046-4852-5448-5046-48105-11388-98113-121
425850-52intlsizepink5052-19999990wpluslingerie50-5250-5250-5220-2224-2852-5452-5450-5256-6252-5450-52114-12799-112122-132
525954-56intlsizepink5456-19999990wpluslingerie54-5654-5654-5624-2628-3256-5856-5854-5662-6456-5854-56128-134113-121133-144
sizeranges
stringplus
sizes
string2132,256,257,258,259
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: 44.4 ms
Record Count: 5
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 = 'D6C491B3-CF93-4FB6-A1B308C97651AD9F'
and product_variations.isactive = 1
and product_sizes.id_size = 2132
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 = 'D6C491B3-CF93-4FB6-A1B308C97651AD9F'
and product_variations.isactive = 1
and product_sizes.id_size = 256
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 = 'D6C491B3-CF93-4FB6-A1B308C97651AD9F'
and product_variations.isactive = 1
and product_sizes.id_size = 257
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 = 'D6C491B3-CF93-4FB6-A1B308C97651AD9F'
and product_variations.isactive = 1
and product_sizes.id_size = 258
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 = 'D6C491B3-CF93-4FB6-A1B308C97651AD9F'
and product_variations.isactive = 1
and product_sizes.id_size = 259
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
1D6C491B3-CF93-4FB6-A1B308C97651AD9F91940E45-EFEC-47A6-9F716E448ABA1DCC2132pink#FE70BD38-4038-4038-408-1012-1440-4240-4238-4044-4640-4238-40wlingerie38-40intlsize58.29170STOCK01000-10000Z/5014-10all
2D6C491B3-CF93-4FB6-A1B308C97651AD9FD2821DAF-86EB-403C-8F3C95FC419CA226256pink#FE70BD42-4442-4442-4412-1416-1844-4644-4642-4448-5044-4642-44wlingerie42-44intlsize58.29170STOCK01000-10100Z/50145901885319254-10all
3D6C491B3-CF93-4FB6-A1B308C97651AD9FCFB3A9C6-FA42-45C4-8B25480046C9FD0B257pink#FE70BD46-4846-4846-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie46-48intlsize58.29170STOCK01000-10100Z/50145901885319261-10all
4D6C491B3-CF93-4FB6-A1B308C97651AD9FEF714986-953A-4449-9A0086B38C7E9842258pink#FE70BD50-5250-5250-5220-2224-2852-5452-5450-5256-6252-5450-52wlingerie50-52intlsize58.29170STOCK01000-10300Z/50145901885319278-10all
5D6C491B3-CF93-4FB6-A1B308C97651AD9F2792BADA-951F-428A-9F1204523D95BA16259pink#FE70BD54-5654-5654-5624-2628-3256-5856-5854-5662-6456-5854-56wlingerie54-56intlsize58.29170STOCK01000-10100Z/50145901885319285-10all
subcategory
stringall
supplier
number-1
supplierreference
stringAN531924-
tags
string
themes
stringdark,hot
totalvariations
string
type
stringdefault
unitprice
number58.2917
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 8.96 ms
Record Count: 5
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 = 'D6C491B3-CF93-4FB6-A1B308C97651AD9F' 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 = 'D6C491B3-CF93-4FB6-A1B308C97651AD9F' 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 = 'D6C491B3-CF93-4FB6-A1B308C97651AD9F' 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 = 'D6C491B3-CF93-4FB6-A1B308C97651AD9F' 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 = 'D6C491B3-CF93-4FB6-A1B308C97651AD9F' 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 = 'D6C491B3-CF93-4FB6-A1B308C97651AD9F' 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 = 'D6C491B3-CF93-4FB6-A1B308C97651AD9F'
and product_variations.isactive = 1
and product_sizes.id_size = 2132
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 = 'D6C491B3-CF93-4FB6-A1B308C97651AD9F' 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 = 'D6C491B3-CF93-4FB6-A1B308C97651AD9F' 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 = 'D6C491B3-CF93-4FB6-A1B308C97651AD9F' 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 = 'D6C491B3-CF93-4FB6-A1B308C97651AD9F' 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 = 'D6C491B3-CF93-4FB6-A1B308C97651AD9F' 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 = 'D6C491B3-CF93-4FB6-A1B308C97651AD9F' 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 = 'D6C491B3-CF93-4FB6-A1B308C97651AD9F'
and product_variations.isactive = 1
and product_sizes.id_size = 256
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 = 'D6C491B3-CF93-4FB6-A1B308C97651AD9F' 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 = 'D6C491B3-CF93-4FB6-A1B308C97651AD9F' 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 = 'D6C491B3-CF93-4FB6-A1B308C97651AD9F' 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 = 'D6C491B3-CF93-4FB6-A1B308C97651AD9F' 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 = 'D6C491B3-CF93-4FB6-A1B308C97651AD9F' 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 = 'D6C491B3-CF93-4FB6-A1B308C97651AD9F' 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 = 'D6C491B3-CF93-4FB6-A1B308C97651AD9F'
and product_variations.isactive = 1
and product_sizes.id_size = 257
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 = 'D6C491B3-CF93-4FB6-A1B308C97651AD9F' 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 = 'D6C491B3-CF93-4FB6-A1B308C97651AD9F' 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 = 'D6C491B3-CF93-4FB6-A1B308C97651AD9F' 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 = 'D6C491B3-CF93-4FB6-A1B308C97651AD9F' 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 = 'D6C491B3-CF93-4FB6-A1B308C97651AD9F' 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 = 'D6C491B3-CF93-4FB6-A1B308C97651AD9F' 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 = 'D6C491B3-CF93-4FB6-A1B308C97651AD9F'
and product_variations.isactive = 1
and product_sizes.id_size = 258
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 = 'D6C491B3-CF93-4FB6-A1B308C97651AD9F' 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 = 'D6C491B3-CF93-4FB6-A1B308C97651AD9F' 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 = 'D6C491B3-CF93-4FB6-A1B308C97651AD9F' 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 = 'D6C491B3-CF93-4FB6-A1B308C97651AD9F' 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 = 'D6C491B3-CF93-4FB6-A1B308C97651AD9F' 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 = 'D6C491B3-CF93-4FB6-A1B308C97651AD9F' 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 = 'D6C491B3-CF93-4FB6-A1B308C97651AD9F'
and product_variations.isactive = 1
and product_sizes.id_size = 259
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
191940E45-EFEC-47A6-9F716E448ABA1DCC2132pink#FE70BD38-4038-4038-408-1012-1440-4240-4238-4044-4640-4238-40wlingerie38-40intlsize58.29170STOCK01000-10000Z/5014-10-10-10058.2917all
2D2821DAF-86EB-403C-8F3C95FC419CA226256pink#FE70BD42-4442-4442-4412-1416-1844-4644-4642-4448-5044-4642-44wlingerie42-44intlsize58.29170STOCK01000-10100Z/50145901885319254-10-10-10058.2917all
3CFB3A9C6-FA42-45C4-8B25480046C9FD0B257pink#FE70BD46-4846-4846-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie46-48intlsize58.29170STOCK01000-10100Z/50145901885319261-10-10-10058.2917all
4EF714986-953A-4449-9A0086B38C7E9842258pink#FE70BD50-5250-5250-5220-2224-2852-5452-5450-5256-6252-5450-52wlingerie50-52intlsize58.29170STOCK01000-10300Z/50145901885319278-10-10-10058.2917all
52792BADA-951F-428A-9F1204523D95BA16259pink#FE70BD54-5654-5654-5624-2628-3256-5856-5854-5662-6456-5854-56wlingerie54-56intlsize58.29170STOCK01000-10100Z/50145901885319285-10-10-10058.2917all
vatrate
number20
warehouse
string