Mijn mand

❌
Totaal aantal items
Winkelmand bekijken
Menu
Maten bekijken
Open Panty Nude Tint
Dubbelklikken om te vergroten
SKU: SLTI4933
Open Panty Nude Tint
GEMAAKT IN
Voorraad:

Bevrijd je sensualiteit met deze grote maat panty met gedurfde opening. Een accessoire van vrijheid dat uitzonderlijk comfort combineert met natuurlijke elegantie.

Sterke punten

  • Plezier opening functioneel en stijlvol
  • Make-up kleur nude en elegant
  • Extra breed in taille en dijen
  • Zijdezachte matte transparantie 20 Denier
  • Versterkte teen voor optimale duurzaamheid
Maat:

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

Kleur:
Hoeveelheid:
29.95 €
Snelle verzending
voor de ongeduldigen...
Goed advies
via chat, facebook of e-mail
Gratis retourneren
binnen 15 dagen *

Open Panty Grote Maat - Transparant Zijdezacht Mat Make-up Kleur

Productomschrijving

Een panty die comfort en vrijheid herdefineert, ontworpen om zich aan te passen aan alle lichaamstypes. De zijdezachte transparantie in make-up kleur omhult je vormen natuurlijk, terwijl de ruime opening een gevoel van totale vrijheid biedt.

Technische details

  • Materiaal : 20 Denier / 22 DTEX
  • Kleur : Make-up nude tint
  • Afwerking : Zijdezacht mat transparant
  • Pasvorm : Extra breed in taille en dijen
  • Bijzonderheid : Plezier opening, versterkte teen

Beschikbaar maten

Beschikbaar van 38-40 tot 56-58

Beschikbaar kleur

Beige

Samenstelling

Polyamide 86 %
Elastaan 14 %

Onderhoudstips

  • Handwas in koud water
  • Niet wringen
  • Plat drogen in de schaduw
  • Voorzichtige behandeling aanbevolen

Gebruikstips

Deze panty's combineren de vrijheid van kousen met het comfort van een panty. De perfecte pasvorm en extra brede snit garanderen een gevoel van welzijn en vertrouwen gedurende de hele dag.

Stijltips

Combineer deze panty's met een lichte jurk of een zijden ensemble voor een sensuele en verfijnde look. Perfect voor een intieme avond of een gedurfde dagelijkse stijl.

To Top
Winkelmand bekijken
Artikelen
Totaal aantal items
Struct
Entries: 108
actions
Array
available
number5
brand
stringglamory
brandcode
stringgjjm
branding
stringdivasboudoir
brandmedias
string{"default":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"editorial":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"logo":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""}}
brandmetas
Struct
de
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
el
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
en
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
es
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
fr
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
it
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
nl
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
pt
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
brandname
stringGlamory
breasts
stringna
careinstructions
string
categories
stringdivasboudoir.lingerie.hoisery.crotchless
category
stringhoisery
categorygender
stringm
categorymediadatas
Struct
adult
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string414
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/lingerie/hoisery/collants-ouverts-grande-taille.jpg
type
stringimg
width
string900
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.902 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,'beige') > 0
and product_variations.productuid = 'DA965EA3-D9BC-4638-B434B4A19EFC62F6'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1beigecolorbeigbeigebrown#F6DBAC-10
colorrange
stringbrown
colors
stringbeige
colortype
stringcolor
comments
string
compositions
Struct
Entries: 13
coton
string
elastane
string14
free
string
leather
string
lycra
string
metal
string
nylon
string
polyamide
string86
polyester
string
polyurethane
string
silk
string
spandex
string
viscose
string
datecreated
Date Time (Europe/Paris)
{ts '2019-10-09 09:37:31'}
defect
number0
dimensions
Struct
Entries: 14
acrylicbones
string
backsideheight
string
diameter
string
flatsteelbones
string
frontsideheight
string
fullheight
string
length
string
modestysize
string
panels
string
sides
string
spiralsteelbones
string
totallength
string
unit
stringcm
wiresize
string
display
stringall
displayfrom
string
displayto
string
grossweight
string
hasbrandinfos
booleanfalse
hascareinstructions
booleantrue
hascolorinfos
booleantrue
hascompositions
booleantrue
hasdescription
booleantrue
hasdimensions
booleanfalse
hasmaterials
booleanfalse
hasotherspecifications
booleanfalse
haspromo
number0
hasshortdescription
booleantrue
hassizeinfos
booleantrue
hasspecifications
booleantrue
hasstockinfos
booleanfalse
hasstylingtips
booleantrue
hasusageinstructions
booleantrue
hasvariations
booleantrue
import
string
inpromo
number0
instockvariations
number3
isactive
number1
iscustommade
number0
isdivasize
number1
isfirstprice
number0
isfixedprice
number0
ishot
number0
isnew
number0
isonline
number0
isoutletprice
number0
itemprice
number24.9583
itempromo
string
key
stringplaisir-ouvert-50121
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-10-05 13:09:31'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.684 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('da965ea3-d9bc-4638-b434b4a19efc62f6',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.44 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 <> 'SLTI4933'
group by products.reference
order by products.ishot desc, products.isnew desc, orderidx asc, products.lastupdated desc
productuidreferencetypekeylanguagenamelinkuidcolorsvatratemetadatasdimensionsmediadatastagsthemesisdivasizetotalvariationsvariationlistinpromohaspromoitempromoitempriceunitpricepricespromountilisfixedpriceishotisneworderidxavailablestockinstockvariationsbrandbrandnameshowbranddisplaysizetypeintlsizesizessizerangecategorymediadatascategorysizerangesectioncategorysubcategory
linkuid
string
materials
string
mediadatas
Struct
alt
Struct
height
string
isprivate
string0
rating
stringall
src
string/photobank/products/gjjm/slti4933/50121-plaisir-ouvert-20-make-up-plus-size_crop.jpg
type
stringimg
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string1761
isprivate
string0
rating
stringall
src
string/photobank/products/gjjm/slti4933/50121-plaisir-ouvert-20-make-up-plus-size.jpg
type
stringimg
width
string1371
variations
Struct
colors
Struct
beige
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
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-beige
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-mpez
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-beige
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-beige
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-beige
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-beige
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-beige
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-bege
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
divasboudoir
Struct
de
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Handw&auml;sche in kaltem Wasser</li> <li>Nicht auswringen</li> <li>Flach im Schatten trocknen</li> <li>Vorsichtige Behandlung empfohlen</li> </ul>
description
string<p><strong>Eine Strumpfhose, die Komfort und Freiheit neu definiert</strong>, entwickelt, um sich allen K&ouml;rpertypen anzupassen. Die seidig matte Make-up-Transparenz schmeichelt Ihren Kurven nat&uuml;rlich, w&auml;hrend die gro&szlig;z&uuml;gige &Ouml;ffnung ein Gef&uuml;hl vollkommener Freiheit bietet.</p>
guid
stringhttps://dev.divasboudoir.com/de/offene-strumpfhose-uebergroesse-transparent-seidig-make-up/slti4933.htm
highlights
string<ul> <li><strong>Genuss-&Ouml;ffnung</strong> funktional und stilvoll</li> <li><strong>Make-up Farbe</strong> nude und elegant</li> <li><strong>Extra breit</strong> in Taille und Oberschenkeln</li> <li><strong>Seidig matte</strong> Transparenz 20 Denier</li> <li><strong>Verst&auml;rkte Spitze</strong> f&uuml;r optimale Haltbarkeit</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringOffene Strumpfhose in Übergröße, transparent seidig in Make-up Farbe. Außergewöhnlicher Komfort, extra breiter Schnitt. Freiheit und Eleganz garantiert.
keywords
string
title
stringOffene Strumpfhose in Übergröße Make-up Farbe | Leg's Boudoir
seotitle
stringOffene Strumpfhose in Übergröße - Transparent Seidig Matt Make-up Farbe
seouri
stringoffene-strumpfhose-uebergroesse-transparent-seidig-make-up
specifications
string<ul> <li><strong>Material :</strong> 20 Denier / 22 DTEX</li> <li><strong>Farbe :</strong> Nude Make-up Ton</li> <li><strong>Finish :</strong> Seidig matt transparent</li> <li><strong>Schnitt :</strong> Extra breit in Taille und Oberschenkeln</li> <li><strong>Besonderheit :</strong> Genuss-&Ouml;ffnung, verst&auml;rkte Spitze</li> </ul>
stylingtips
string<p>Kombinieren Sie diese Strumpfhose mit einem <strong>leichten Kleid</strong> oder einem <strong>Seiden-Ensemble</strong> f&uuml;r einen sinnlichen und sophistizierten Look. Perfekt f&uuml;r einen intimen Abend oder einen gewagten Alltagsstil.</p>
summary
string<p><strong>Befreien Sie Ihre Sinnlichkeit</strong> mit dieser &Uuml;bergr&ouml;&szlig;e-Strumpfhose mit gewagter &Ouml;ffnung. Ein <u>Accessoire der Freiheit</u>, das au&szlig;ergew&ouml;hnlichen Komfort mit nat&uuml;rlicher Eleganz verbindet.</p>
title
stringOffene Strumpfhose Nude Ton
usageinstructions
string<p>Diese Strumpfhose vereint die Freiheit von Str&uuml;mpfen mit dem Komfort einer Strumpfhose. Der perfekte Sitz und der extra breite Schnitt garantieren ein Gef&uuml;hl von Wohlbefinden und Selbstvertrauen den ganzen Tag &uuml;ber.</p>
el
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>&Pi;&lambda;ύ&sigma;&iota;&mu;&omicron; &sigma;&tau;&omicron; &chi;έ&rho;&iota; &mu;&epsilon; &kappa;&rho;ύ&omicron; &nu;&epsilon;&rho;ό</li> <li>&Mu;&eta;&nu; &sigma;&tau;&rho;ί&beta;&epsilon;&tau;&epsilon;</li> <li>&Sigma;&tau;&epsilon;&gamma;&nu;ώ&sigma;&tau;&epsilon; &epsilon;&pi;ί&pi;&epsilon;&delta;&alpha; &sigma;&tau;&eta; &sigma;&kappa;&iota;ά</li> <li>&Sigma;&upsilon;&nu;&iota;&sigma;&tau;ά&tau;&alpha;&iota; &pi;&rho;&omicron;&sigma;&epsilon;&kappa;&tau;&iota;&kappa;ό&sigmaf; &chi;&epsilon;&iota;&rho;&iota;&sigma;&mu;ό&sigmaf;</li> </ul>
description
string<p><strong>&Mu;&iota;&alpha; &kappa;&alpha;&lambda;&sigma;ό&nu; &pi;&omicron;&upsilon; &epsilon;&pi;&alpha;&nu;&alpha;&pi;&rho;&omicron;&sigma;&delta;&iota;&omicron;&rho;ί&zeta;&epsilon;&iota; &tau;&eta;&nu; ά&nu;&epsilon;&sigma;&eta; &kappa;&alpha;&iota; &tau;&eta;&nu; &epsilon;&lambda;&epsilon;&upsilon;&theta;&epsilon;&rho;ί&alpha;</strong>, &sigma;&chi;&epsilon;&delta;&iota;&alpha;&sigma;&mu;έ&nu;&eta; &nu;&alpha; &pi;&rho;&omicron;&sigma;&alpha;&rho;&mu;ό&zeta;&epsilon;&tau;&alpha;&iota; &sigma;&epsilon; ό&lambda;&omicron;&upsilon;&sigmaf; &tau;&omicron;&upsilon;&sigmaf; &tau;ύ&pi;&omicron;&upsilon;&sigmaf; &sigma;ώ&mu;&alpha;&tau;&omicron;&sigmaf;. &Eta; &mu;&epsilon;&tau;&alpha;&xi;έ&nu;&iota;&alpha; &delta;&iota;&alpha;&phi;ά&nu;&epsilon;&iota;&alpha; &sigma;&tau;&eta;&nu; &alpha;&pi;ό&chi;&rho;&omega;&sigma;&eta; make-up &alpha;&gamma;&kappa;&alpha;&lambda;&iota;ά&zeta;&epsilon;&iota; &phi;&upsilon;&sigma;&iota;&kappa;ά &tau;&iota;&sigmaf; &kappa;&alpha;&mu;&pi;ύ&lambda;&epsilon;&sigmaf; &sigma;&alpha;&sigmaf;, &epsilon;&nu;ώ &tau;&omicron; &gamma;&epsilon;&nu;&nu;&alpha;&iota;ό&delta;&omega;&rho;&omicron; ά&nu;&omicron;&iota;&gamma;&mu;&alpha; &pi;&rho;&omicron;&sigma;&phi;έ&rho;&epsilon;&iota; &mu;&iota;&alpha; &alpha;ί&sigma;&theta;&eta;&sigma;&eta; &pi;&lambda;ή&rho;&omicron;&upsilon;&sigmaf; &epsilon;&lambda;&epsilon;&upsilon;&theta;&epsilon;&rho;ί&alpha;&sigmaf;.</p>
guid
stringhttps://dev.divasboudoir.com/el/anoichti-kalson-megalou-megethous-diafani-metaxenia-make-up/slti4933.htm
highlights
string<ul> <li><strong>Ά&nu;&omicron;&iota;&gamma;&mu;&alpha; &alpha;&pi;ό&lambda;&alpha;&upsilon;&sigma;&eta;&sigmaf;</strong> &lambda;&epsilon;&iota;&tau;&omicron;&upsilon;&rho;&gamma;&iota;&kappa;ό &kappa;&alpha;&iota; &kappa;&omicron;&mu;&psi;ό</li> <li><strong>&Chi;&rho;ώ&mu;&alpha; make-up</strong> nude &kappa;&alpha;&iota; &kappa;&omicron;&mu;&psi;ό</li> <li><strong>&Epsilon;&xi;&alpha;&iota;&rho;&epsilon;&tau;&iota;&kappa;ά &phi;&alpha;&rho;&delta;&iota;ά</strong> &sigma;&tau;&eta; &mu;έ&sigma;&eta; &kappa;&alpha;&iota; &sigma;&tau;&omicron;&upsilon;&sigmaf; &mu;&eta;&rho;&omicron;ύ&sigmaf;</li> <li><strong>&Mu;&epsilon;&tau;&alpha;&xi;έ&nu;&iota;&alpha; &delta;&iota;&alpha;&phi;ά&nu;&epsilon;&iota;&alpha;</strong> &mu;&alpha;&tau; 20 Denier</li> <li><strong>&Epsilon;&nu;&iota;&sigma;&chi;&upsilon;&mu;έ&nu;&eta; &mu;ύ&tau;&eta;</strong> &gamma;&iota;&alpha; &beta;έ&lambda;&tau;&iota;&sigma;&tau;&eta; &alpha;&nu;&theta;&epsilon;&kappa;&tau;&iota;&kappa;ό&tau;&eta;&tau;&alpha;</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringΑνοιχτή καλσόν μεγάλου μεγέθους, διάφανη μεταξένια σε χρώμα make-up. Εξαιρετική άνεση, εξαιρετικά φαρδιά κοπή. Ελευθερία και κομψότητα εγγυημένες.
keywords
string
title
stringΑνοιχτή Καλσόν Μεγάλου Μεγέθους Χρώμα Make-up | Leg's Boudoir
seotitle
stringΑνοιχτή Καλσόν Μεγάλου Μεγέθους - Διάφανη Μεταξένια Ματ Χρώμα Make-up
seouri
stringanoichti-kalson-megalou-megethous-diafani-metaxenia-make-up
specifications
string<ul> <li><strong>&Upsilon;&lambda;&iota;&kappa;ό :</strong> 20 Denier / 22 DTEX</li> <li><strong>&Chi;&rho;ώ&mu;&alpha; :</strong> &Alpha;&pi;ό&chi;&rho;&omega;&sigma;&eta; nude make-up</li> <li><strong>&Phi;&iota;&nu;ί&rho;&iota;&sigma;&mu;&alpha; :</strong> &Delta;&iota;ά&phi;&alpha;&nu;&omicron; &mu;&epsilon;&tau;&alpha;&xi;έ&nu;&iota;&omicron; &mu;&alpha;&tau;</li> <li><strong>&Kappa;&omicron;&pi;ή :</strong> &Epsilon;&xi;&alpha;&iota;&rho;&epsilon;&tau;&iota;&kappa;ά &phi;&alpha;&rho;&delta;&iota;ά &sigma;&tau;&eta; &mu;έ&sigma;&eta; &kappa;&alpha;&iota; &sigma;&tau;&omicron;&upsilon;&sigmaf; &mu;&eta;&rho;&omicron;ύ&sigmaf;</li> <li><strong>&Epsilon;&iota;&delta;&iota;&kappa;ό &chi;&alpha;&rho;&alpha;&kappa;&tau;&eta;&rho;&iota;&sigma;&tau;&iota;&kappa;ό :</strong> Ά&nu;&omicron;&iota;&gamma;&mu;&alpha; &alpha;&pi;ό&lambda;&alpha;&upsilon;&sigma;&eta;&sigmaf;, &epsilon;&nu;&iota;&sigma;&chi;&upsilon;&mu;έ&nu;&eta; &mu;ύ&tau;&eta;</li> </ul>
stylingtips
string<p>&Sigma;&upsilon;&nu;&delta;&upsilon;ά&sigma;&tau;&epsilon; &tau;&eta;&nu; &kappa;&alpha;&lambda;&sigma;ό&nu; &mu;&epsilon; έ&nu;&alpha; <strong>&epsilon;&lambda;&alpha;&phi;&rho;ύ &phi;ό&rho;&epsilon;&mu;&alpha;</strong> ή έ&nu;&alpha; <strong>&sigma;ύ&nu;&omicron;&lambda;&omicron; &alpha;&pi;ό &mu;&epsilon;&tau;ά&xi;&iota;</strong> &gamma;&iota;&alpha; έ&nu;&alpha; &alpha;&iota;&sigma;&theta;&eta;&sigma;&iota;&alpha;&kappa;ό &kappa;&alpha;&iota; &epsilon;&kappa;&lambda;&epsilon;&pi;&tau;&upsilon;&sigma;&mu;έ&nu;&omicron; look. &Iota;&delta;&alpha;&nu;&iota;&kappa;ή &gamma;&iota;&alpha; έ&nu;&alpha; &omicron;&iota;&kappa;&epsilon;ί&omicron; &beta;&rho;ά&delta;&upsilon; ή έ&nu;&alpha; &tau;&omicron;&lambda;&mu;&eta;&rho;ό &kappa;&alpha;&theta;&eta;&mu;&epsilon;&rho;&iota;&nu;ό &sigma;&tau;&upsilon;&lambda;.</p>
summary
string<p><strong>&Alpha;&pi;&epsilon;&lambda;&epsilon;&upsilon;&theta;&epsilon;&rho;ώ&sigma;&tau;&epsilon; &tau;&eta;&nu; &alpha;&iota;&sigma;&theta;&eta;&sigma;&iota;&alpha;&kappa;ό&tau;&eta;&tau;ά &sigma;&alpha;&sigmaf;</strong> &mu;&epsilon; &alpha;&upsilon;&tau;ή &tau;&eta;&nu; &kappa;&alpha;&lambda;&sigma;ό&nu; &mu;&epsilon;&gamma;ά&lambda;&omicron;&upsilon; &mu;&epsilon;&gamma;έ&theta;&omicron;&upsilon;&sigmaf; &mu;&epsilon; &tau;&omicron;&lambda;&mu;&eta;&rho;ό ά&nu;&omicron;&iota;&gamma;&mu;&alpha;. Έ&nu;&alpha; <u>&alpha;&xi;&epsilon;&sigma;&omicron;&upsilon;ά&rho; &epsilon;&lambda;&epsilon;&upsilon;&theta;&epsilon;&rho;ί&alpha;&sigmaf;</u> &pi;&omicron;&upsilon; &sigma;&upsilon;&nu;&delta;&upsilon;ά&zeta;&epsilon;&iota; &epsilon;&xi;&alpha;&iota;&rho;&epsilon;&tau;&iota;&kappa;ή ά&nu;&epsilon;&sigma;&eta; &mu;&epsilon; &phi;&upsilon;&sigma;&iota;&kappa;ή &kappa;&omicron;&mu;&psi;ό&tau;&eta;&tau;&alpha;.</p>
title
stringΔιάφανες Καλσόν Ανοιχτές Απόχρωση Nude
usageinstructions
string<p>&Alpha;&upsilon;&tau;ή &eta; &kappa;&alpha;&lambda;&sigma;ό&nu; &sigma;&upsilon;&nu;&delta;&upsilon;ά&zeta;&epsilon;&iota; &tau;&eta;&nu; &epsilon;&lambda;&epsilon;&upsilon;&theta;&epsilon;&rho;ί&alpha; &tau;&omega;&nu; &kappa;&alpha;&lambda;&tau;&sigma;ώ&nu; &mu;&epsilon; &tau;&eta;&nu; ά&nu;&epsilon;&sigma;&eta; &mu;&iota;&alpha;&sigmaf; &kappa;&alpha;&lambda;&sigma;ό&nu;. &Eta; &tau;έ&lambda;&epsilon;&iota;&alpha; &epsilon;&phi;&alpha;&rho;&mu;&omicron;&gamma;ή &kappa;&alpha;&iota; &eta; &epsilon;&xi;&alpha;&iota;&rho;&epsilon;&tau;&iota;&kappa;ά &phi;&alpha;&rho;&delta;&iota;ά &kappa;&omicron;&pi;ή &epsilon;&gamma;&gamma;&upsilon;ώ&nu;&tau;&alpha;&iota; &mu;&iota;&alpha; &alpha;ί&sigma;&theta;&eta;&sigma;&eta; &epsilon;&upsilon;&epsilon;&xi;ί&alpha;&sigmaf; &kappa;&alpha;&iota; &alpha;&upsilon;&tau;&omicron;&pi;&epsilon;&pi;&omicron;ί&theta;&eta;&sigma;&eta;&sigmaf; &kappa;&alpha;&theta;' ό&lambda;&eta; &tau;&eta; &delta;&iota;ά&rho;&kappa;&epsilon;&iota;&alpha; &tau;&eta;&sigmaf; &eta;&mu;έ&rho;&alpha;&sigmaf;.</p>
en
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Hand wash in cold water</li> <li>Do not wring</li> <li>Dry flat in the shade</li> <li>Delicate handling recommended</li> </ul>
description
string<p><strong>Tights that redefine comfort and freedom</strong>, designed to adapt to all body types. The silky transparent make-up shade embraces your curves naturally, while the generous opening offers a feeling of total freedom.</p>
guid
stringhttps://dev.divasboudoir.com/en/open-tights-plus-size-transparent-silky-make-up/slti4933.htm
highlights
string<ul> <li><strong>Pleasure opening</strong> functional and stylish</li> <li><strong>Make-up color</strong> nude and elegant</li> <li><strong>Extra wide</strong> waist and thighs</li> <li><strong>Silky matte</strong> transparency 20 Denier</li> <li><strong>Reinforced toe</strong> for optimal durability</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringOpen tights plus size, transparent silky in make-up color. Exceptional comfort, extra wide fit. Freedom and elegance guaranteed. Legs Boudoir.
keywords
string
title
stringOpen Tights Plus Size Make-up Color | Leg's Boudoir
seotitle
stringOpen Tights Plus Size - Transparent Silky Matte Make-up Color
seouri
stringopen-tights-plus-size-transparent-silky-make-up
specifications
string<ul> <li><strong>Material :</strong> 20 Denier / 22 DTEX</li> <li><strong>Color :</strong> Make-up nude shade</li> <li><strong>Finish :</strong> Silky matte transparent</li> <li><strong>Fit :</strong> Extra wide waist and thighs</li> <li><strong>Special feature :</strong> Pleasure opening, reinforced toe</li> </ul>
stylingtips
string<p>Pair these tights with a <strong>light dress</strong> or a <strong>silk ensemble</strong> for a sensual and sophisticated look. Perfect for an intimate evening or a daring everyday style.</p>
summary
string<p><strong>Free your sensuality</strong> with these plus size tights featuring a daring opening. A <u>freedom accessory</u> that combines exceptional comfort with natural elegance.</p>
title
stringOpen Tights Nude Shade
usageinstructions
string<p>These tights combine the freedom of stockings with the comfort of tights. The perfect fit and extra wide cut guarantee a feeling of well-being and confidence throughout the day.</p>
es
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavado a mano en agua fr&iacute;a</li> <li>No retorcer</li> <li>Secar extendido a la sombra</li> <li>Manipulaci&oacute;n delicada recomendada</li> </ul>
description
string<p><strong>Unas medias que redefinen el confort y la libertad</strong>, dise&ntilde;adas para adaptarse a todos los tipos de cuerpo. La transparencia sedosa en tono make-up abraza tus curvas naturalmente, mientras la generosa abertura ofrece una sensaci&oacute;n de libertad total.</p>
guid
stringhttps://dev.divasboudoir.com/es/medias-abiertas-talla-grande-transparentes-sedosas-make-up/slti4933.htm
highlights
string<ul> <li><strong>Abertura de placer</strong> funcional y elegante</li> <li><strong>Color make-up</strong> nude y sofisticado</li> <li><strong>Extra anchas</strong> en cintura y muslos</li> <li><strong>Transparencia sedosa</strong> mate 20 Denier</li> <li><strong>Puntera reforzada</strong> para durabilidad &oacute;ptima</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringMedias abiertas talla grande, transparentes sedosas en color make-up. Confort excepcional, corte extra ancho. Libertad y elegancia garantizadas.
keywords
string
title
stringMedias Abiertas Talla Grande Color Make-up | Leg's Boudoir
seotitle
stringMedias Abiertas Talla Grande - Transparentes Sedosas Mate Color Make-up
seouri
stringmedias-abiertas-talla-grande-transparentes-sedosas-make-up
specifications
string<ul> <li><strong>Material :</strong> 20 Denier / 22 DTEX</li> <li><strong>Color :</strong> Tono nude make-up</li> <li><strong>Acabado :</strong> Transparente sedoso mate</li> <li><strong>Corte :</strong> Extra ancho en cintura y muslos</li> <li><strong>Caracter&iacute;stica especial :</strong> Abertura de placer, puntera reforzada</li> </ul>
stylingtips
string<p>Combina estas medias con un <strong>vestido ligero</strong> o un <strong>conjunto de seda</strong> para un look sensual y sofisticado. Perfectas para una velada &iacute;ntima o un estilo audaz para el d&iacute;a a d&iacute;a.</p>
summary
string<p><strong>Libera tu sensualidad</strong> con estas medias de talla grande con una abertura audaz. Un <u>accesorio de libertad</u> que combina un confort excepcional con elegancia natural.</p>
title
stringMedias Abiertas Tono Nude
usageinstructions
string<p>Estas medias combinan la libertad de las medias con el confort de un pantal&oacute;n. El ajuste perfecto y el corte extra ancho garantizan una sensaci&oacute;n de bienestar y confianza durante todo el d&iacute;a.</p>
fr
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavage &agrave; la main en eau froide</li> <li>Ne pas tordre</li> <li>S&eacute;chage &agrave; plat &agrave; l'ombre</li> <li>Manipulation d&eacute;licate recommand&eacute;e</li> </ul>
description
string<p><strong>Un collant qui red&eacute;finit le confort et la libert&eacute;</strong>, pens&eacute; pour s'adapter &agrave; toutes les morphologies. La transparence soyeuse couleur make-up &eacute;pouse vos courbes naturellement, tandis que l'ouverture g&eacute;n&eacute;reuse offre une sensation de libert&eacute; totale.</p>
guid
stringhttps://dev.divasboudoir.com/fr/collants-ouverts-grande-taille-transparents-soyeux-make-up/slti4933.htm
highlights
string<ul> <li><strong>Ouverture plaisir</strong> design et fonctionnelle</li> <li><strong>Couleur make-up</strong> nude et &eacute;l&eacute;gante</li> <li><strong>Extra large</strong> taille et cuisses</li> <li><strong>Transparence</strong> soyeuse mate 20 Denier</li> <li><strong>Pointe renforc&eacute;e</strong> pour une durabilit&eacute; optimale</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringCollants grande taille ouverts, transparents soyeux couleur make-up. Confort exceptionnel, coupe extra large. Liberté et élégance garanties.
keywords
string
title
stringCollants Ouverts Grande Taille Couleur Make-up | Leg's Boudoir
seotitle
stringCollants Ouverts Grande Taille - Transparents Soyeux Mat Couleur Make-up
seouri
stringcollants-ouverts-grande-taille-transparents-soyeux-make-up
specifications
string<ul> <li><strong>Mati&egrave;re :</strong> 20 Denier / 22 DTEX</li> <li><strong>Couleur :</strong> Teinte make-up nude</li> <li><strong>Finition :</strong> Soyeux mat transparent</li> <li><strong>Coupe :</strong> Extra large taille et cuisses</li> <li><strong>Particularit&eacute; :</strong> Ouverture plaisir, pointe renforc&eacute;e</li> </ul>
stylingtips
string<p>Associez ces collants avec une <strong>robe l&eacute;g&egrave;re</strong> ou un <strong>ensemble en soie</strong> pour un look sensuel et sophistiqu&eacute;. Parfaits pour une soir&eacute;e intime ou un style audacieux au quotidien.</p> <ul> <li><a href="https://www.legsboudoir.com/fr/collants-grande-taille/">D&eacute;couvrez notre collection de collants</a></li> <li><a href="https://www.divasboudoir.com/fr/lingerie-grande-taille/">Explorez nos lingeries sur notre site partenaire Diva's Boudoir</a></li> </ul>
summary
string<p><strong>Lib&eacute;rez votre sensualit&eacute;</strong> avec ces collants grande taille &agrave; l'ouverture audacieuse. Un <u>accessoire de libert&eacute;</u> qui allie confort exceptionnel et &eacute;l&eacute;gance naturelle.</p>
title
stringCollants Plaisir Ouvert Teinte Nude
usageinstructions
string<p>Ces collants combinent la libert&eacute; des bas avec le confort d'un collant. L'ajustement parfait et la coupe extra large garantissent une sensation de bien-&ecirc;tre et de confiance tout au long de la journ&eacute;e.</p>
it
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavaggio a mano in acqua fredda</li> <li>Non strizzare</li> <li>Asciugare steso all'ombra</li> <li>Manipolazione delicata consigliata</li> </ul>
description
string<p><strong>Un collant che ridefinisce comfort e libert&agrave;</strong>, progettato per adattarsi a tutti i tipi di corpo. La trasparenza setosa in tonalit&agrave; make-up abbraccia naturalmente le tue curve, mentre l'ampia apertura offre una sensazione di libert&agrave; totale.</p>
guid
stringhttps://dev.divasboudoir.com/it/collant-aperti-taglie-forti-trasparenti-setosi-make-up/slti4933.htm
highlights
string<ul> <li><strong>Apertura di piacere</strong> funzionale ed elegante</li> <li><strong>Colore make-up</strong> nude e sofisticato</li> <li><strong>Extra large</strong> in vita e cosce</li> <li><strong>Trasparenza setosa</strong> opaca 20 Denier</li> <li><strong>Punta rinforzata</strong> per durabilit&agrave; ottimale</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringCollant aperti taglie forti, trasparenti setosi in colore make-up. Comfort eccezionale, taglio extra large. Libertà ed eleganza garantite.
keywords
string
title
stringCollant Aperti Taglie Forti Colore Make-up | Leg's Boudoir
seotitle
stringCollant Aperti Taglie Forti - Trasparenti Setosi Opachi Colore Make-up
seouri
stringcollant-aperti-taglie-forti-trasparenti-setosi-make-up
specifications
string<ul> <li><strong>Materiale :</strong> 20 Denier / 22 DTEX</li> <li><strong>Colore :</strong> Tonalit&agrave; nude make-up</li> <li><strong>Finitura :</strong> Trasparente setoso opaco</li> <li><strong>Taglio :</strong> Extra large in vita e cosce</li> <li><strong>Caratteristica speciale :</strong> Apertura di piacere, punta rinforzata</li> </ul>
stylingtips
string<p>Abbina questi collant con un <strong>vestito leggero</strong> o un <strong>ensemble in seta</strong> per un look sensuale e sofisticato. Perfetti per una serata intima o uno stile audace per il giorno.</p>
summary
string<p><strong>Libera la tua sensualit&agrave;</strong> con questi collant taglie forti dall'apertura audace. Un <u>accessorio di libert&agrave;</u> che unisce comfort eccezionale ed eleganza naturale.</p>
title
stringCollant Aperti Tonalità Nude
usageinstructions
string<p>Questi collant combinano la libert&agrave; delle calze con il comfort di un pantacollant. Il fit perfetto e il taglio extra large garantiscono una sensazione di benessere e confidenza durante l'intera giornata.</p>
nl
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Handwas in koud water</li> <li>Niet wringen</li> <li>Plat drogen in de schaduw</li> <li>Voorzichtige behandeling aanbevolen</li> </ul>
description
string<p><strong>Een panty die comfort en vrijheid herdefineert</strong>, ontworpen om zich aan te passen aan alle lichaamstypes. De zijdezachte transparantie in make-up kleur omhult je vormen natuurlijk, terwijl de ruime opening een gevoel van totale vrijheid biedt.</p>
guid
stringhttps://dev.divasboudoir.com/nl/open-panty-grote-maat-transparant-zijdezacht-make-up/slti4933.htm
highlights
string<ul> <li><strong>Plezier opening</strong> functioneel en stijlvol</li> <li><strong>Make-up kleur</strong> nude en elegant</li> <li><strong>Extra breed</strong> in taille en dijen</li> <li><strong>Zijdezachte</strong> matte transparantie 20 Denier</li> <li><strong>Versterkte teen</strong> voor optimale duurzaamheid</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringOpen panty grote maat, transparant zijdezacht in make-up kleur. Uitzonderlijk comfort, extra brede pasvorm. Vrijheid en elegantie gegarandeerd.
keywords
string
title
stringOpen Panty Grote Maat Make-up Kleur | Leg's Boudoir
seotitle
stringOpen Panty Grote Maat - Transparant Zijdezacht Mat Make-up Kleur
seouri
stringopen-panty-grote-maat-transparant-zijdezacht-make-up
specifications
string<ul> <li><strong>Materiaal :</strong> 20 Denier / 22 DTEX</li> <li><strong>Kleur :</strong> Make-up nude tint</li> <li><strong>Afwerking :</strong> Zijdezacht mat transparant</li> <li><strong>Pasvorm :</strong> Extra breed in taille en dijen</li> <li><strong>Bijzonderheid :</strong> Plezier opening, versterkte teen</li> </ul>
stylingtips
string<p>Combineer deze panty's met een <strong>lichte jurk</strong> of een <strong>zijden ensemble</strong> voor een sensuele en verfijnde look. Perfect voor een intieme avond of een gedurfde dagelijkse stijl.</p>
summary
string<p><strong>Bevrijd je sensualiteit</strong> met deze grote maat panty met gedurfde opening. Een <u>accessoire van vrijheid</u> dat uitzonderlijk comfort combineert met natuurlijke elegantie.</p>
title
stringOpen Panty Nude Tint
usageinstructions
string<p>Deze panty's combineren de vrijheid van kousen met het comfort van een panty. De perfecte pasvorm en extra brede snit garanderen een gevoel van welzijn en vertrouwen gedurende de hele dag.</p>
pt
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavar &agrave; m&atilde;o em &aacute;gua fria</li> <li>N&atilde;o torcer</li> <li>Secar deitada &agrave; sombra</li> <li>Manuseio delicado recomendado</li> </ul>
description
string<p><strong>Uma meia-cal&ccedil;a que redefine o conforto e a liberdade</strong>, projetada para se adaptar a todos os tipos de corpo. A transpar&ecirc;ncia sedosa na cor make-up abra&ccedil;a suas curvas naturalmente, enquanto a abertura generosa oferece uma sensa&ccedil;&atilde;o de liberdade total.</p>
guid
stringhttps://dev.divasboudoir.com/pt/meia-calca-aberta-plus-size-transparente-sedosa-make-up/slti4933.htm
highlights
string<ul> <li><strong>Abertura de prazer</strong> funcional e estilosa</li> <li><strong>Cor make-up</strong> nude e elegante</li> <li><strong>Extra larga</strong> na cintura e coxas</li> <li><strong>Transpar&ecirc;ncia sedosa</strong> fosca 20 Denier</li> <li><strong>Ponta refor&ccedil;ada</strong> para durabilidade &oacute;tima</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringMeia-calça aberta plus size, transparente sedosa em cor make-up. Conforto excepcional, corte extra largo. Liberdade e elegância garantidas.
keywords
string
title
stringMeia-Calça Aberta Plus Size Cor Make-up | Leg's Boudoir
seotitle
stringMeia-Calça Aberta Plus Size - Transparente Sedosa Mate Cor Make-up
seouri
stringmeia-calca-aberta-plus-size-transparente-sedosa-make-up
specifications
string<ul> <li><strong>Material :</strong> 20 Denier / 22 DTEX</li> <li><strong>Cor :</strong> Tom nude make-up</li> <li><strong>Acabamento :</strong> Transparente sedoso fosco</li> <li><strong>Corte :</strong> Extra largo na cintura e coxas</li> <li><strong>Caracter&iacute;stica especial :</strong> Abertura de prazer, ponta refor&ccedil;ada</li> </ul>
stylingtips
string<p>Combine estas meias-cal&ccedil;a com um <strong>vestido leve</strong> ou um <strong>conjunto de seda</strong> para um visual sensual e sofisticado. Perfeitas para uma noite &iacute;ntima ou um estilo ousado no dia a dia.</p>
summary
string<p><strong>Liberte sua sensualidade</strong> com esta meia-cal&ccedil;a plus size com abertura ousada. Um <u>acess&oacute;rio de liberdade</u> que combina conforto excepcional com eleg&acirc;ncia natural.</p>
title
stringMeia-Calça Aberta Tom Nude
usageinstructions
string<p>Estas meias-cal&ccedil;a combinam a liberdade das meias com o conforto de uma meia-cal&ccedil;a. O ajuste perfeito e o corte extra largo garantem uma sensa&ccedil;&atilde;o de bem-estar e confian&ccedil;a durante todo o dia.</p>
fetishboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-beige
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-mpez
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-beige
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-beige
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-beige
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-beige
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-beige
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-bege
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-beige
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-mpez
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-beige
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-beige
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-beige
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-beige
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-beige
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-bege
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-beige
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-mpez
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-beige
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-beige
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-beige
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-beige
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-beige
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-bege
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-beige
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-mpez
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-beige
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-beige
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-beige
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-beige
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-beige
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-bege
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
smboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-beige
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-mpez
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-beige
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-beige
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-beige
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-beige
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-beige
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-bege
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
name
stringplaisir ouvert 50121
netweight
string
nextshipment
stringtomorrow
ordered
number0
orderidx
number0
origin
stringeu
originalsize
string
packaging
number0
productshipment
stringauto
productuid
stringDA965EA3-D9BC-4638-B434B4A19EFC62F6
promountil
string
rating
stringnone
recorduid
stringDA965EA3-D9BC-4638-B434B4A19EFC62F6
reference
stringSLTI4933
related
string
reserved
number0
returned
number0
returnsallowed
number1
section
stringlingerie
shipment
string4to6days
showbrand
number0
sizeinfos
Query
Template: /system/api/product/sizes.cfc:20
Execution Time: 1.74 ms
Record Count: 6
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,'2130,1046,1047,1048,1049,1050') > 0
and product_variations.productuid = 'DA965EA3-D9BC-4638-B434B4A19EFC62F6'
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
1213038-40intlsizebeige3840-19999990wpluslingerieM38-4038-408-1012-1440-4240-4238-4044-4640-4238-40
2104642-44intlsizebeige4244-19999990wpluslingerieL42-4442-4412-1416-1844-4644-4642-4448-5042-4442-44
3104746-48intlsizebeige4648-19999990wpluslingerieXL46-4846-4816-1820-2248-5048-5046-4852-5448-5046-48
4104850-52intlsizebeige5052-19999990wpluslingerie2XL50-5250-5220-2224-2652-5452-5450-5256-5852-5450-52
5104954-56intlsizebeige5456-19999990wpluslingerie3XL54-5654-5624-2628-3056-5856-5854-5660-6256-5854-56
6105056-58intlsizebeige5658-19999990wpluslingerie4XL56-5856-5826-2830-3258-6058-6056-5862-6458-6056-58
sizeranges
stringplus
sizes
string2130,1046,1047,1048,1049,1050
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
number5
stocks
Query
Template: /system/api/product/stocks.cfc:25
Execution Time: 20.1 ms
Record Count: 6
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select * from (
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = 'DA965EA3-D9BC-4638-B434B4A19EFC62F6'
and product_variations.isactive = 1
and product_sizes.id_size = 2130
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 = 'DA965EA3-D9BC-4638-B434B4A19EFC62F6'
and product_variations.isactive = 1
and product_sizes.id_size = 1046
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 = 'DA965EA3-D9BC-4638-B434B4A19EFC62F6'
and product_variations.isactive = 1
and product_sizes.id_size = 1047
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 = 'DA965EA3-D9BC-4638-B434B4A19EFC62F6'
and product_variations.isactive = 1
and product_sizes.id_size = 1048
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 = 'DA965EA3-D9BC-4638-B434B4A19EFC62F6'
and product_variations.isactive = 1
and product_sizes.id_size = 1049
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 = 'DA965EA3-D9BC-4638-B434B4A19EFC62F6'
and product_variations.isactive = 1
and product_sizes.id_size = 1050
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
1DA965EA3-D9BC-4638-B434B4A19EFC62F646D64A80-133B-45DC-99ECEF9F9EF146FF2130beige#F6DBACM38-4038-408-1012-1440-4240-4238-4044-4640-4238-40wlingerie38-40intlsize24.95830STOCK01000-10000-10all
2DA965EA3-D9BC-4638-B434B4A19EFC62F60854D8AB-4239-42F9-B5410A3B6030C2AB1046beige#F6DBACL42-4442-4412-1416-1844-4644-4642-4448-5042-4442-44wlingerie42-44intlsize24.95830STOCK01000-10000-10all
3DA965EA3-D9BC-4638-B434B4A19EFC62F698C703FD-0E0D-42F4-B5E09A9FB86BA1A21047beige#F6DBACXL46-4846-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie46-48intlsize24.95830STOCK01000-10000-10all
4DA965EA3-D9BC-4638-B434B4A19EFC62F635950EAC-44DF-467C-932CF682E4A9D3F31048beige#F6DBAC2XL50-5250-5220-2224-2652-5452-5450-5256-5852-5450-52wlingerie50-52intlsize24.95830STOCK01000-10000-10all
5DA965EA3-D9BC-4638-B434B4A19EFC62F65ADD52F7-7FB4-4C1E-8BB9DD7F121738661049beige#F6DBAC3XL54-5654-5624-2628-3056-5856-5854-5660-6256-5854-56wlingerie54-56intlsize24.95830STOCK01000-10000-10all
6DA965EA3-D9BC-4638-B434B4A19EFC62F6BA51BA43-FCA3-4939-854DA7043AFF746B1050beige#F6DBAC4XL56-5856-5826-2830-3258-6058-6056-5862-6458-6056-58wlingerie56-58intlsize24.95830STOCK01000-10000-10all
subcategory
stringcrotchless
supplier
number-1
supplierreference
string50121
tags
string
themes
stringhot
totalvariations
number12
type
stringdefault
unitprice
number24.9583
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 12.7 ms
Record Count: 6
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 = 'DA965EA3-D9BC-4638-B434B4A19EFC62F6' 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 = 'DA965EA3-D9BC-4638-B434B4A19EFC62F6' 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 = 'DA965EA3-D9BC-4638-B434B4A19EFC62F6' 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 = 'DA965EA3-D9BC-4638-B434B4A19EFC62F6' 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 = 'DA965EA3-D9BC-4638-B434B4A19EFC62F6' 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 = 'DA965EA3-D9BC-4638-B434B4A19EFC62F6' 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 = 'DA965EA3-D9BC-4638-B434B4A19EFC62F6'
and product_variations.isactive = 1
and product_sizes.id_size = 2130
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 = 'DA965EA3-D9BC-4638-B434B4A19EFC62F6' 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 = 'DA965EA3-D9BC-4638-B434B4A19EFC62F6' 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 = 'DA965EA3-D9BC-4638-B434B4A19EFC62F6' 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 = 'DA965EA3-D9BC-4638-B434B4A19EFC62F6' 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 = 'DA965EA3-D9BC-4638-B434B4A19EFC62F6' 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 = 'DA965EA3-D9BC-4638-B434B4A19EFC62F6' 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 = 'DA965EA3-D9BC-4638-B434B4A19EFC62F6'
and product_variations.isactive = 1
and product_sizes.id_size = 1046
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 = 'DA965EA3-D9BC-4638-B434B4A19EFC62F6' 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 = 'DA965EA3-D9BC-4638-B434B4A19EFC62F6' 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 = 'DA965EA3-D9BC-4638-B434B4A19EFC62F6' 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 = 'DA965EA3-D9BC-4638-B434B4A19EFC62F6' 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 = 'DA965EA3-D9BC-4638-B434B4A19EFC62F6' 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 = 'DA965EA3-D9BC-4638-B434B4A19EFC62F6' 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 = 'DA965EA3-D9BC-4638-B434B4A19EFC62F6'
and product_variations.isactive = 1
and product_sizes.id_size = 1047
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 = 'DA965EA3-D9BC-4638-B434B4A19EFC62F6' 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 = 'DA965EA3-D9BC-4638-B434B4A19EFC62F6' 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 = 'DA965EA3-D9BC-4638-B434B4A19EFC62F6' 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 = 'DA965EA3-D9BC-4638-B434B4A19EFC62F6' 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 = 'DA965EA3-D9BC-4638-B434B4A19EFC62F6' 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 = 'DA965EA3-D9BC-4638-B434B4A19EFC62F6' 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 = 'DA965EA3-D9BC-4638-B434B4A19EFC62F6'
and product_variations.isactive = 1
and product_sizes.id_size = 1048
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 = 'DA965EA3-D9BC-4638-B434B4A19EFC62F6' 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 = 'DA965EA3-D9BC-4638-B434B4A19EFC62F6' 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 = 'DA965EA3-D9BC-4638-B434B4A19EFC62F6' 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 = 'DA965EA3-D9BC-4638-B434B4A19EFC62F6' 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 = 'DA965EA3-D9BC-4638-B434B4A19EFC62F6' 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 = 'DA965EA3-D9BC-4638-B434B4A19EFC62F6' 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 = 'DA965EA3-D9BC-4638-B434B4A19EFC62F6'
and product_variations.isactive = 1
and product_sizes.id_size = 1049
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 = 'DA965EA3-D9BC-4638-B434B4A19EFC62F6' 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 = 'DA965EA3-D9BC-4638-B434B4A19EFC62F6' 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 = 'DA965EA3-D9BC-4638-B434B4A19EFC62F6' 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 = 'DA965EA3-D9BC-4638-B434B4A19EFC62F6' 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 = 'DA965EA3-D9BC-4638-B434B4A19EFC62F6' 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 = 'DA965EA3-D9BC-4638-B434B4A19EFC62F6' 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 = 'DA965EA3-D9BC-4638-B434B4A19EFC62F6'
and product_variations.isactive = 1
and product_sizes.id_size = 1050
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
146D64A80-133B-45DC-99ECEF9F9EF146FF2130beige#F6DBACM38-4038-408-1012-1440-4240-4238-4044-4640-4238-40wlingerie38-40intlsize24.95830STOCK01000-10000-10-10-10024.9583all
20854D8AB-4239-42F9-B5410A3B6030C2AB1046beige#F6DBACL42-4442-4412-1416-1844-4644-4642-4448-5042-4442-44wlingerie42-44intlsize24.95830STOCK01000-10000-10-10-10024.9583all
398C703FD-0E0D-42F4-B5E09A9FB86BA1A21047beige#F6DBACXL46-4846-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie46-48intlsize24.95830STOCK01000-10000-10-10-10024.9583all
435950EAC-44DF-467C-932CF682E4A9D3F31048beige#F6DBAC2XL50-5250-5220-2224-2652-5452-5450-5256-5852-5450-52wlingerie50-52intlsize24.95830STOCK01000-10000-10-10-10024.9583all
55ADD52F7-7FB4-4C1E-8BB9DD7F121738661049beige#F6DBAC3XL54-5654-5624-2628-3056-5856-5854-5660-6256-5854-56wlingerie54-56intlsize24.95830STOCK01000-10000-10-10-10024.9583all
6BA51BA43-FCA3-4939-854DA7043AFF746B1050beige#F6DBAC4XL56-5856-5826-2830-3258-6058-6056-5862-6458-6056-58wlingerie56-58intlsize24.95830STOCK01000-10000-10-10-10024.9583all
vatrate
number20
warehouse
number5