Mon panier

❌
Total articles
Voir le panier
Menu
Voir les tailles
Collant gainant All Day
Double-cliquez pour agrandir
SKU: CGCC7514
Collant gainant All Day
Stock:

Portez-les toute la journée avec confort et élégance, ils accompagneront toutes vos tenues.

Taille:

Vous ne savez pas quelle taille choisir? Consultez notre guide des tailles

Couleur:
Quantité:
14.95 €
Conseils avisés
par chat, facebook ou par e-mail
Retours gratuits
sous 15 jours *

Collant grande taille gainant All Day

Description du produit

Des collants transparents gainants All Day d'une légèreté remarquable

Ces collants en nylon fin et aéré vous accompagneront avec aisance tout au long de la journée. Leur matière souple et extensible épouse parfaitement les contours de vos jambes pour un confort absolu.

Une silhouette lisse et affinée

La bande de maintien Control Top au niveau du ventre lisse avec délicatesse toute imperfection, offrant un soutien discret et efficace aux zones les plus sujettes aux rondeurs.

Votre silhouette se retrouve ainsi joliment redessinée et affinée, pour une allure élégante et galbée. Une seconde peau douce et élastique

La texture du nylon est d'une douceur incomparable, caressant agréablement votre peau.

Grâce à l'élasticité naturelle du tissu, ces collants épousent parfaitement vos formes et suivent chacun de vos mouvements sans jamais vous entraver.

Détails techniques

Tailles disponibles

Disponible du 5-6 au 13-14

Couleurs disponibles

Noir et Marron

Guide de taille

Vérifiez la taille qui vous convient

International
  • Taille (hauteur)
  • Poids
5-6
  • 150-170
  • 77-107
7-8
  • 168-178
  • 77-100
9-10
  • 168-183
  • 91-118
11-12
  • 168-183
  • 104-132
13-14
  • 168-183
  • 118-150
To Top
Voir le panier
Articles
Total articles
Struct
Entries: 108
actions
Array
available
number-1
brand
stringmemoi
brandcode
stringmzpm
branding
stringdivasboudoir,legsboudoir
brandmedias
string{"default":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"editorial":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"logo":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""}}
brandmetas
Struct
de
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
el
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
en
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
es
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
fr
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
it
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
nl
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
pt
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
brandname
stringMeMoi
breasts
stringna
careinstructions
string
categories
stringdivasboudoir.lingerie.hoisery.tights
category
stringhoisery
categorygender
stringm
categorymediadatas
Struct
adult
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string410
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/lingerie/hoisery/tights.jpg
type
stringimg
width
string891
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.819 ms
Record Count: 2
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_colors.color as recorduid, product_colors.type, product_colors.code, product_colors.color, product_colors.range, product_colors.hexvalue,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock
from product_colors
left outer join product_variations on product_colors.color = product_variations.color and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
where FIND_IN_SET(product_colors.color,'black,brown') > 0
and product_variations.productuid = 'A9F523B2-3F61-473C-959FB1621D76AF4E'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1blackcolorblakblackblack#000000-11
2browncolorbrowbrownbrown#783D00-10
colorrange
stringblack
colors
stringblack,brown
colortype
stringcolor
comments
string
compositions
Struct
Entries: 13
coton
string
elastane
string
free
string
leather
string
lycra
string
metal
string
nylon
string
polyamide
string
polyester
string
polyurethane
string
silk
string
spandex
string
viscose
string
datecreated
Date Time (Europe/Paris)
{ts '2024-09-25 14:38:08'}
defect
number0
dimensions
Struct
Entries: 14
acrylicbones
string
backsideheight
string
diameter
string
flatsteelbones
string
frontsideheight
string
fullheight
string
length
string
modestysize
string
panels
string
sides
string
spiralsteelbones
string
totallength
string
unit
stringcm
wiresize
string
display
stringall
displayfrom
string
displayto
string
grossweight
string
hasbrandinfos
booleanfalse
hascareinstructions
booleanfalse
hascolorinfos
booleantrue
hascompositions
booleanfalse
hasdescription
booleantrue
hasdimensions
booleanfalse
hasmaterials
booleanfalse
hasotherspecifications
booleanfalse
haspromo
number0
hasshortdescription
booleantrue
hassizeinfos
booleantrue
hasspecifications
booleanfalse
hasstockinfos
booleanfalse
hasstylingtips
booleanfalse
hasusageinstructions
booleanfalse
hasvariations
booleantrue
import
string
inpromo
number0
instockvariations
string
isactive
number1
iscustommade
number0
isdivasize
number1
isfirstprice
number0
isfixedprice
number0
ishot
number0
isnew
number0
isonline
number0
isoutletprice
number0
itemprice
number12.4583
itempromo
string
key
stringmm-2207-20006--all-day
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-10-22 18:42:10'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.675 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','fr')
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('a9f523b2-3f61-473c-959fb1621d76af4e',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.34 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','fr')
and product_categories.language in ('all','fr')
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 <> 'CGCC7514'
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
string856
isprivate
string0
rating
stringall
src
string/photobank/products/mzpm/cgcc7514/09430d8b2d2d565d181889fe62cb66e9.jpg
type
stringimg
width
string592
back
Struct
height
string856
isprivate
string0
rating
stringall
src
string/photobank/products/mzpm/cgcc7514/1f2c1806eb5b1aad09b3210d6feecda2.jpg
type
stringimg
width
string592
default
Struct
height
string856
isprivate
string0
rating
stringall
src
string/photobank/products/mzpm/cgcc7514/07c58455cebdff72ae1b0e3db5941909.jpg
type
stringimg
width
string592
variations
Struct
colors
Struct
black
Struct
height
string856
isprivate
string0
rating
stringall
src
string/photobank/products/mzpm/cgcc7514/07c58455cebdff72ae1b0e3db5941909.jpg
type
stringimg
width
string592
brown
Struct
height
string856
isprivate
string0
rating
stringall
src
string/photobank/products/mzpm/cgcc7514/e055a7bb9f7fc8b1a9ac4849830548de.jpg
type
stringimg
width
string592
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
mediagallery
string
metadatas
Struct
darkboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz-ou-braun
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro-ou-kafe
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black-ou-borwn
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro-ou-marron
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-ou-marron
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero-ou-marrone
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart-ou-bruin
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto-ou-castanho
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
divasboudoir
Struct
de
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p><span>Eine transparente, formende All Day-Strumpfhose mit bemerkenswerter Leichtigkeit</span></p> <p><span>Diese Strumpfhosen aus dünnem, luftigem Nylon begleiten Sie mit Leichtigkeit durch den Tag. Ihr weiches, dehnbares Material passt sich perfekt den Konturen Ihrer Beine an und sorgt für absoluten Komfort.<br /><br />Eine glatte, schlanke Silhouette </span></p> <p><span>Das Control Top-Band im Bauchbereich glättet sanft jede Unebenheit und bietet diskreten, aber effektiven BH-Stütz für die Zonen, die am meisten zu Rundungen neigen. </span></p> <p><span>Ihre Silhouette wird auf schöne Weise neu geformt und verfeinert, was zu einem eleganten und wohlgeformten Aussehen führt. Eine weiche, elastische zweite Haut </span></p> <p><span>Die Textur von Nylon ist unvergleichlich weich und umschmeichelt Ihre Haut auf angenehme Weise. </span></p> <p><span>Dank der natürlichen Elastizität des Stoffes schmiegt sich diese Strumpfhose perfekt an Ihre Formen an und folgt jeder Ihrer Bewegungen, ohne Sie jemals einzuschränken.</span></p>
guid
stringhttps://dev.divasboudoir.com/de/all-day--straffende-strumpfhose-in-grossen-grossen-schwarz-ou-braun/cgcc7514.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringIhre Silhouette wird auf diese Weise schön neu geformt und verfeinert, für einen eleganten, wohlgeformten Look. Eine weiche, elastische, umhüllende zweite Haut.
keywords
string
title
stringAll Day Strumpfhose in großen Größen - Mit Control Top-Band
seotitle
stringAll Day - Straffende Strumpfhose in großen Größen
seouri
stringall-day--straffende-strumpfhose-in-grossen-grossen-schwarz-ou-braun
specifications
string
stylingtips
string
summary
stringTragen Sie sie den ganzen Tag lang mit Komfort und Eleganz, sie passen zu jedem Outfit.
title
stringAll Day formende Strumpfhose
usageinstructions
string
el
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p><span>Διαφανές, διάφανο καλσόν All Day με αξιοσημείωτη ελαφρότητα</span></p> <p><span>Αυτό το λεπτό, αναπνεύσιμο νάιλον καλσόν θα σας κρατήσει άνετες όλη την ημέρα.<br /><br />Το μαλακό, ελαστικό τους ύφασμα αγκαλιάζει το περίγραμμα των ποδιών σας για απόλυτη άνεση. Μια απαλή, πιο λεπτή σιλουέτα</span></p> <p><span>Η ζώνη στήριξης Control Top γύρω από την κοιλιά εξομαλύνει απαλά τυχόν ατέλειες, παρέχοντας διακριτική, αποτελεσματική στήριξη στις περιοχές που είναι πιο επιρρεπείς σε εξογκώματα. </span></p> <p><span>Η σιλουέτα σας επανασχεδιάζεται και εξευγενίζεται όμορφα, για μια κομψή, καλλίγραμμη εμφάνιση. Ένα μαλακό, ελαστικό δεύτερο δέρμα </span></p> <p><span>Η υφή του νάιλον είναι ασύγκριτα απαλή, χαϊδεύοντας ευχάριστα το δέρμα σας. </span></p> <p><span>Χάρη στη φυσική ελαστικότητα του υφάσματος, αυτό το καλσόν αγκαλιάζει τέλεια το σχήμα σας και ακολουθεί κάθε σας κίνηση χωρίς ποτέ να σας εμποδίζει.</span></p>
guid
stringhttps://dev.divasboudoir.com/el/all-day-syn-megethos-kalson-mayro-ou-kafe/cgcc7514.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringΗ σιλουέτα σας επανασχεδιάζεται όμορφα και αδυνατίζει, για μια κομψή, καλλίγραμμη εμφάνιση. Ένα μαλακό, ελαστικό, περιτυλιγμένο δεύτερο δέρμα.
keywords
string
title
stringAll Day καλσόν plus size - Με ζώνη Control Top
seotitle
stringAll Day συν μέγεθος καλσόν
seouri
stringall-day-syn-megethos-kalson-mayro-ou-kafe
specifications
string
stylingtips
string
summary
stringΦορέστε τα άνετα και κομψά όλη την ημέρα για να συμπληρώνουν κάθε ντύσιμο.
title
stringΚαλσόν διαμόρφωσης All Day
usageinstructions
string
en
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p><span>All Day sheer sheer tights with remarkable lightness</span></p> <p><span>These sheer, breathable nylon tights are perfect for all-day wear. Their soft, stretchy fabric hugs the contours of your legs for absolute comfort.<br /><br />A smooth, refined silhouette </span></p> <p><span>The Control Top support band at tummy level gently smoothes out any imperfections, offering discreet, effective bra support for those areas most prone to curves. </span></p> <p><span>Your silhouette is beautifully reshaped and refined, for an elegant, shapely look. A soft, elastic second skin </span></p> <p><span>The texture of nylon is incomparably soft, pleasantly caressing your skin. </span></p> <p><span>Thanks to the fabric's natural elasticity, these tights hug your shape perfectly, following your every move without ever getting in your way.</span></p>
guid
stringhttps://dev.divasboudoir.com/en/plus-size-pantyhose-all-day-black-ou-borwn/cgcc7514.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringYour silhouette is beautifully reshaped and refined, for an elegant, shapely look. A soft, elastic, sheathing second skin.
keywords
string
title
stringPlus size All Day tights - With Control Top band
seotitle
stringPlus size pantyhose All Day
seouri
stringplus-size-pantyhose-all-day-black-ou-borwn
specifications
string
stylingtips
string
summary
stringWear them all day long with comfort and elegance, they will accompany all your outfits.
title
stringAll Day pantyhose
usageinstructions
string
es
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p><span>Mallas transparentes All Day con una ligereza extraordinaria</span></p> <p><span>Estas medias de nailon fino y transpirable te mantendrán cómoda durante todo el día.<br /><br />Su tejido suave y elástico se adapta al contorno de las piernas para ofrecerte una comodidad absoluta. Una silueta suave y estilizada</span></p> <p><span>La banda de sujeción Control Top alrededor del vientre alisa suavemente cualquier imperfección, proporcionando un sujetador discreto y eficaz para las zonas más propensas a las protuberancias. </span></p> <p><span>Su silueta se rediseña y afina, para un aspecto elegante y torneado. Una segunda piel suave y elástica </span></p> <p><span>La textura del nailon es incomparablemente suave y acaricia agradablemente la piel. </span></p> <p><span>Gracias a la elasticidad natural del tejido, estas mallas se adaptan perfectamente a tu silueta y siguen todos tus movimientos sin estorbarte.</span></p>
guid
stringhttps://dev.divasboudoir.com/es/pantimedias-talla-grande-all-day-negro-ou-marron/cgcc7514.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringSu silueta se rediseña y estiliza, para un aspecto elegante y torneado. Una segunda piel suave, elástica y envolvente.
keywords
string
title
stringPantys talla grande All Day - Con banda Control Top
seotitle
stringPantimedias talla grande All Day
seouri
stringpantimedias-talla-grande-all-day-negro-ou-marron
specifications
string
stylingtips
string
summary
stringLlévalos con comodidad y elegancia durante todo el día para complementar cualquier atuendo.
title
stringMallas moldeadoras All Day
usageinstructions
string
fr
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p><span>Des collants transparents gainants All Day d'une l&eacute;g&egrave;ret&eacute; remarquable</span></p> <p><span>Ces collants en nylon fin et a&eacute;r&eacute; vous accompagneront avec aisance tout au long de la journ&eacute;e. Leur mati&egrave;re souple et extensible &eacute;pouse parfaitement les contours de vos jambes pour un confort absolu.<br /><br />Une silhouette lisse et affin&eacute;e </span></p> <p><span>La bande de maintien Control Top au niveau du ventre lisse avec d&eacute;licatesse toute imperfection, offrant un soutien discret et efficace aux zones les plus sujettes aux rondeurs. </span></p> <p><span>Votre silhouette se retrouve ainsi joliment redessin&eacute;e et affin&eacute;e, pour une allure &eacute;l&eacute;gante et galb&eacute;e. Une seconde peau douce et &eacute;lastique </span></p> <p><span>La texture du nylon est d'une douceur incomparable, caressant agr&eacute;ablement votre peau. </span></p> <p><span>Gr&acirc;ce &agrave; l'&eacute;lasticit&eacute; naturelle du tissu, ces collants &eacute;pousent parfaitement vos formes et suivent chacun de vos mouvements sans jamais vous entraver.</span></p>
guid
stringhttps://dev.divasboudoir.com/fr/collant-grande-taille-gainant-all-day-noir-ou-marron/cgcc7514.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringVotre silhouette se retrouve ainsi joliment redessinée et affinée, pour une allure élégante et galbée. Une seconde peau douce et élastique gainante.
keywords
string
title
stringCollants grande taille All Day - Avec bande Control Top
seotitle
stringCollant grande taille gainant All Day
seouri
stringcollant-grande-taille-gainant-all-day-noir-ou-marron
specifications
string
stylingtips
string
summary
stringPortez-les toute la journ&eacute;e avec confort et &eacute;l&eacute;gance, ils accompagneront toutes vos tenues.
title
stringCollant gainant All Day
usageinstructions
string
it
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p><span>Collant All Day velati e trasparenti con una notevole leggerezza</span></p> <p><span>Questi collant in nylon, sottili e traspiranti, vi terranno a vostro agio per tutto il giorno.<br /><br />Il loro tessuto morbido ed elastico si adatta ai contorni delle gambe per un comfort assoluto. Una silhouette liscia e più snella</span></p> <p><span>La fascia di sostegno Control Top intorno alla pancia attenua delicatamente le imperfezioni, offrendo un calze discreto ed efficace per le zone più soggette a rigonfiamenti. </span></p> <p><span>La figura è splendidamente ridisegnata e affinata, per un look elegante e formoso. Una seconda pelle morbida ed elastica </span></p> <p><span>La texture del nylon è incomparabilmente morbida e accarezza piacevolmente la pelle. </span></p> <p><span>Grazie alla naturale elasticità del tessuto, questo collant abbraccia perfettamente le vostre forme e segue ogni vostro movimento senza mai intralciarvi.</span></p>
guid
stringhttps://dev.divasboudoir.com/it/collant-all-day-taglia-grande-nero-ou-marrone/cgcc7514.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringLa vostra figura è splendidamente ridisegnata e snellita, per un look elegante e formoso. Una seconda pelle morbida, elastica e avvolgente.
keywords
string
title
stringCollant All Day taglia grande - Con fascia Control Top
seotitle
stringCollant All Day taglia grande
seouri
stringcollant-all-day-taglia-grande-nero-ou-marrone
specifications
string
stylingtips
string
summary
stringIndossateli in modo comodo ed elegante per tutto il giorno, per completare qualsiasi outfit.
title
stringCollant modellanti All Day
usageinstructions
string
nl
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p><span>Sheer, transparante All Day panty met opmerkelijke lichtheid</span></p> <p><span>Deze fijne, ademende nylon panty houdt je de hele dag comfortabel.<br /><br />De zachte, rekbare stof omhelst de contouren van je benen voor absoluut comfort. Een glad, slanker silhouet</span></p> <p><span>De Control Top-steunband rond de buik strijkt zachtjes alle onvolkomenheden glad en biedt discrete, effectieve bh voor de zones die het meest vatbaar zijn voor bobbels. </span></p> <p><span>Je figuur wordt prachtig hertekend en verfijnd, voor een elegante, welgevormde look. Een zachte, elastische tweede huid </span></p> <p><span>De textuur van nylon is onvergelijkbaar zacht en streelt je huid op een aangename manier. </span></p> <p><span>Dankzij de natuurlijke elasticiteit van de stof omhelst deze panty je vorm perfect en volgt hij elke beweging zonder ooit in de weg te zitten.</span></p>
guid
stringhttps://dev.divasboudoir.com/nl/de-hele-dag-grote-maten-pantys-zwart-ou-bruin/cgcc7514.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringJe figuur wordt prachtig hertekend en slanker, voor een elegante, welgevormde look. Een zachte, elastische, omhullende tweede huid.
keywords
string
title
stringAll Day panty van grote maat - Met Control Top band
seotitle
stringDe hele dag grote maten panty's
seouri
stringde-hele-dag-grote-maten-pantys-zwart-ou-bruin
specifications
string
stylingtips
string
summary
stringDraag ze de hele dag comfortabel en elegant als aanvulling op elke outfit.
title
stringShaping panty voor de hele dag
usageinstructions
string
pt
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p><span>Meias-calças All Day transparentes e transparentes com uma leveza notável</span></p> <p><span>Estes collants de nylon fino e respirável mantêm-na confortável durante todo o dia.<br /><br />O seu tecido macio e elástico adapta-se aos contornos das suas pernas para um conforto absoluto. Uma silhueta suave e mais fina</span></p> <p><span>A faixa de suporte Control Top à volta da barriga alisa suavemente quaisquer imperfeições, proporcionando um suporte discreto e eficaz para as áreas mais propensas a protuberâncias. </span></p> <p><span>A sua silhueta é redesenhada e refinada, para um aspeto elegante e bem torneado. Uma segunda pele macia e elástica </span></p> <p><span>A textura do nylon é incomparavelmente suave, acariciando agradavelmente a sua pele. </span></p> <p><span>Graças à elasticidade natural do tecido, estas meias-calças abraçam perfeitamente a sua forma e acompanham todos os seus movimentos sem nunca a atrapalhar.</span></p>
guid
stringhttps://dev.divasboudoir.com/pt/meia-calca-plus-size-all-day-preto-ou-castanho/cgcc7514.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringA sua silhueta é redesenhada e emagrecida, para um aspeto elegante e bem torneado. Uma segunda pele suave, elástica e envolvente.
keywords
string
title
stringCollants All Day plus size - Com faixa Control Top
seotitle
stringMeia-calça plus size All Day
seouri
stringmeia-calca-plus-size-all-day-preto-ou-castanho
specifications
string
stylingtips
string
summary
stringUse-as com conforto e elegância durante todo o dia para complementar qualquer roupa.
title
stringCollants modeladores All Day
usageinstructions
string
fetishboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz-ou-braun
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro-ou-kafe
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black-ou-borwn
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro-ou-marron
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-ou-marron
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero-ou-marrone
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart-ou-bruin
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto-ou-castanho
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
latexboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz-ou-braun
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro-ou-kafe
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black-ou-borwn
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro-ou-marron
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-ou-marron
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero-ou-marrone
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart-ou-bruin
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto-ou-castanho
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
legsboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>Eine transparente, formende Strumpfhose mit bemerkenswerter Leichtigkeit </span></p> <p><span>Diese Strumpfhosen aus dünnem, luftigem Nylon begleiten Sie mit Leichtigkeit durch den Tag. Ihr weiches, dehnbares Material passt sich perfekt den Konturen Ihrer Beine an und sorgt für absoluten Komfort.<br /><br />Eine glatte, schlanke Silhouette </span></p> <p><span>Das Control Top-Band im Bauchbereich glättet sanft jede Unebenheit und bietet diskreten, aber effektiven BH-Stütz für die Zonen, die am meisten zu Rundungen neigen. </span></p> <p><span>Ihre Silhouette wird auf schöne Weise neu geformt und verfeinert, was zu einem eleganten und wohlgeformten Aussehen führt. Eine weiche, elastische zweite Haut </span></p> <p><span>Die Textur von Nylon ist unvergleichlich weich und umschmeichelt Ihre Haut auf angenehme Weise. </span></p> <p><span>Dank der natürlichen Elastizität des Stoffes schmiegt sich diese Strumpfhose perfekt an Ihre Formen an und folgt jeder Ihrer Bewegungen, ohne Sie jemals einzuschränken.</span></p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringIhre Silhouette wird auf diese Weise schön neu geformt und verfeinert, für einen eleganten, wohlgeformten Look. Eine weiche, elastische, umhüllende zweite Haut.
keywords
string
title
stringAll Day Strumpfhose in großen Größen - Mit Control Top-Band
seotitle
stringAll Day Hüftstrumpfhose mit festem Sitz
seouri
stringall-day-huftstrumpfhose-mit-festem-sitz-schwarz-ou-braun
specifications
string
stylingtips
string
summary
stringTragen Sie sie den ganzen Tag über, sie passen zu jedem Outfit.
title
stringAll Day Hüftstrumpfhose mit festem Sitz
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>Διάφανο διαφανές καλσόν με αξιοσημείωτη ελαφρότητα </span></p> <p><span>Αυτό το λεπτό, διαπνέον νάιλον καλσόν θα σας κρατήσει άνετες όλη την ημέρα.<br /><br />Το μαλακό, ελαστικό τους ύφασμα αγκαλιάζει το περίγραμμα των ποδιών σας για απόλυτη άνεση. Μια λεία, πιο λεπτή σιλουέτα</span></p> <p><span>Η ζώνη στήριξης Control Top γύρω από την κοιλιά εξομαλύνει απαλά τυχόν ατέλειες, παρέχοντας διακριτική, αποτελεσματική στήριξη στις περιοχές που είναι πιο επιρρεπείς σε εξογκώματα. </span></p> <p><span>Η σιλουέτα σας επανασχεδιάζεται και εξευγενίζεται όμορφα, για μια κομψή, καλλίγραμμη εμφάνιση. Ένα μαλακό, ελαστικό δεύτερο δέρμα </span></p> <p><span>Η υφή του νάιλον είναι ασύγκριτα απαλή, χαϊδεύοντας ευχάριστα το δέρμα σας. </span></p> <p><span>Χάρη στη φυσική ελαστικότητα του υφάσματος, αυτό το καλσόν αγκαλιάζει τέλεια το σχήμα σας και ακολουθεί κάθε σας κίνηση χωρίς ποτέ να σας εμποδίζει.</span></p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringΗ σιλουέτα σας επανασχεδιάζεται όμορφα και αδυνατίζει, για μια κομψή, καλλίγραμμη εμφάνιση. Ένα μαλακό, ελαστικό, περιτυλιγμένο δεύτερο δέρμα.
keywords
string
title
stringAll Day καλσόν plus size - Με ζώνη Control Top
seotitle
stringAll Day συν μέγεθος καλσόν
seouri
stringall-day-syn-megethos-kalson-mayro-ou-kafe
specifications
string
stylingtips
string
summary
stringΦορέστε τα όλη την ημέρα για να συμπληρώσουν κάθε ντύσιμο.
title
stringAll Day συν μέγεθος καλσόν
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>Sheer sheer tights with remarkable lightness </span></p> <p><span>These sheer, breathable nylon tights will keep you comfortable all day long. Their soft, stretchy fabric hugs the contours of your legs for absolute comfort.<br /><br />A smooth, refined silhouette </span></p> <p><span>The Control Top support band at tummy level gently smoothes out any imperfections, offering discreet, effective bra support for those areas most prone to curves. </span></p> <p><span>Your silhouette is beautifully reshaped and refined, for an elegant, shapely look. A soft, elastic second skin </span></p> <p><span>The texture of nylon is incomparably soft, pleasantly caressing your skin. </span></p> <p><span>Thanks to the fabric's natural elasticity, these tights hug your shape perfectly, following your every move without ever getting in your way.</span></p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringYour silhouette is beautifully reshaped and refined, for an elegant, shapely look. A soft, elastic, sheathing second skin.
keywords
string
title
stringPlus size All Day tights - With Control Top band
seotitle
stringPlus size pantyhose with All Day sheathing
seouri
stringplus-size-pantyhose-with-all-day-sheathing-black-ou-borwn
specifications
string
stylingtips
string
summary
stringWear them all day long to complement any outfit.
title
stringPlus size pantyhose with All Day sheathing
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>Mallas transparentes con una ligereza extraordinaria </span></p> <p><span>Estas medias de nailon fino y transpirable te mantendrán cómoda durante todo el día.<br /><br />Su tejido suave y elástico se adapta al contorno de las piernas para ofrecerte una comodidad absoluta. Una silueta suave y estilizada</span></p> <p><span>La banda de sujeción Control Top alrededor del vientre alisa suavemente cualquier imperfección, proporcionando un sujetador discreto y eficaz para las zonas más propensas a las protuberancias. </span></p> <p><span>Su silueta se rediseña y afina, para un aspecto elegante y torneado. Una segunda piel suave y elástica </span></p> <p><span>La textura del nailon es incomparablemente suave y acaricia agradablemente la piel. </span></p> <p><span>Gracias a la elasticidad natural del tejido, estas mallas se adaptan perfectamente a tu silueta y siguen todos tus movimientos sin estorbarte.</span></p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringSu silueta se rediseña y estiliza, para un aspecto elegante y torneado. Una segunda piel suave, elástica y envolvente.
keywords
string
title
stringPantys talla grande All Day - Con banda Control Top
seotitle
stringPantimedias talla grande All Day
seouri
stringpantimedias-talla-grande-all-day-negro-ou-marron
specifications
string
stylingtips
string
summary
stringLlévalos todo el día para complementar cualquier atuendo.
title
stringPantimedias talla grande All Day
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>Des collants transparents gainants d'une l&eacute;g&egrave;ret&eacute; remarquable </span></p> <p><span>Ces collants en nylon fin et a&eacute;r&eacute; vous accompagneront avec aisance tout au long de la journ&eacute;e. Leur mati&egrave;re souple et extensible &eacute;pouse parfaitement les contours de vos jambes pour un confort absolu.<br><br>Une silhouette lisse et affin&eacute;e </span></p> <p><span>La bande de maintien Control Top au niveau du ventre lisse avec d&eacute;licatesse toute imperfection, offrant un soutien discret et efficace aux zones les plus sujettes aux rondeurs. </span></p> <p><span>Votre silhouette se retrouve ainsi joliment redessin&eacute;e et affin&eacute;e, pour une allure &eacute;l&eacute;gante et galb&eacute;e. Une seconde peau douce et &eacute;lastique </span></p> <p><span>La texture du nylon est d'une douceur incomparable, caressant agr&eacute;ablement votre peau. </span></p> <p><span>Gr&acirc;ce &agrave; l'&eacute;lasticit&eacute; naturelle du tissu, ces collants &eacute;pousent parfaitement vos formes et suivent chacun de vos mouvements sans jamais vous entraver.</span></p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringVotre silhouette se retrouve ainsi joliment redessinée et affinée, pour une allure élégante et galbée. Une seconde peau douce et élastique gainante.
keywords
string
title
stringCollants grande taille All Day - Avec bande Control Top
seotitle
stringCollants grande taille gainants All Day
seouri
stringcollants-grande-taille-gainants-all-day-noir-ou-marron
specifications
string
stylingtips
string
summary
string<p>Portez-les toute la journ&eacute;e, ils accompagneront toutes vos tenues.</p>
title
stringCollants grande taille gainants All Day
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>Collant velato con una notevole leggerezza </span></p> <p><span>Questi collant in nylon, sottili e traspiranti, vi terranno a vostro agio per tutto il giorno.<br /><br />Il loro tessuto morbido ed elasticizzato si adatta ai contorni delle gambe per un comfort assoluto. Una silhouette liscia e più snella</span></p> <p><span>La fascia di sostegno Control Top intorno alla pancia attenua delicatamente le imperfezioni, offrendo un calze discreto ed efficace per le zone più soggette a rigonfiamenti. </span></p> <p><span>La figura è splendidamente ridisegnata e affinata, per un look elegante e formoso. Una seconda pelle morbida ed elastica </span></p> <p><span>La texture del nylon è incomparabilmente morbida e accarezza piacevolmente la pelle. </span></p> <p><span>Grazie alla naturale elasticità del tessuto, questo collant abbraccia perfettamente le vostre forme e segue ogni vostro movimento senza mai intralciarvi.</span></p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringLa vostra figura è splendidamente ridisegnata e snellita, per un look elegante e formoso. Una seconda pelle morbida, elastica e avvolgente.
keywords
string
title
stringCollant All Day taglia grande - Con fascia Control Top
seotitle
stringCollant All Day taglia grande
seouri
stringcollant-all-day-taglia-grande-nero-ou-marrone
specifications
string
stylingtips
string
summary
stringIndossateli tutto il giorno per completare qualsiasi outfit.
title
stringCollant All Day taglia grande
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>Transparante panty met opmerkelijke lichtheid </span></p> <p><span>Deze fijne, ademende nylon panty houdt je de hele dag comfortabel.<br /><br />De zachte, rekbare stof omhelst de contouren van je benen voor absoluut comfort. Een glad, slanker silhouet</span></p> <p><span>De Control Top-steunband rond de buik strijkt zachtjes alle onvolkomenheden glad en biedt discrete, effectieve bh voor de zones die het meest vatbaar zijn voor bobbels. </span></p> <p><span>Je figuur wordt prachtig hertekend en verfijnd, voor een elegante, welgevormde look. Een zachte, elastische tweede huid </span></p> <p><span>De textuur van nylon is onvergelijkbaar zacht en streelt je huid op een aangename manier. </span></p> <p><span>Dankzij de natuurlijke elasticiteit van de stof omhelst deze panty je vorm perfect en volgt hij elke beweging zonder ooit in de weg te zitten.</span></p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringJe figuur wordt prachtig hertekend en slanker, voor een elegante, welgevormde look. Een zachte, elastische, omhullende tweede huid.
keywords
string
title
stringAll Day panty van grote maat - Met Control Top band
seotitle
stringDe hele dag grote maten panty's
seouri
stringde-hele-dag-grote-maten-pantys-zwart-ou-bruin
specifications
string
stylingtips
string
summary
stringDraag ze de hele dag door als aanvulling op elke outfit.
title
stringDe hele dag grote maten panty's
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>Collants transparentes com uma leveza notável </span></p> <p><span>Estes collants de nylon finos e respiráveis vão mantê-la confortável durante todo o dia.<br /><br />O seu tecido macio e elástico adapta-se aos contornos das suas pernas para um conforto absoluto. Uma silhueta suave e mais fina</span></p> <p><span>A faixa de suporte Control Top à volta da barriga alisa suavemente quaisquer imperfeições, proporcionando um suporte discreto e eficaz para as áreas mais propensas a protuberâncias. </span></p> <p><span>A sua silhueta é redesenhada e refinada, para um aspeto elegante e bem torneado. Uma segunda pele macia e elástica </span></p> <p><span>A textura do nylon é incomparavelmente suave, acariciando agradavelmente a sua pele. </span></p> <p><span>Graças à elasticidade natural do tecido, estas meias-calças abraçam perfeitamente a sua forma e acompanham todos os seus movimentos sem nunca a atrapalhar.</span></p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringA sua silhueta é redesenhada e emagrecida, para um aspeto elegante e bem torneado. Uma segunda pele suave, elástica e envolvente.
keywords
string
title
stringCollants All Day plus size - Com faixa Control Top
seotitle
stringMeia-calça plus size All Day
seouri
stringmeia-calca-plus-size-all-day-preto-ou-castanho
specifications
string
stylingtips
string
summary
stringUse-os durante todo o dia para complementar qualquer roupa.
title
stringMeia-calça plus size All Day
usageinstructions
string
lustboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz-ou-braun
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro-ou-kafe
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black-ou-borwn
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro-ou-marron
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-ou-marron
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero-ou-marrone
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart-ou-bruin
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto-ou-castanho
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
smboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz-ou-braun
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro-ou-kafe
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black-ou-borwn
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro-ou-marron
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir-ou-marron
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero-ou-marrone
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart-ou-bruin
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto-ou-castanho
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
name
stringMM-2207-20006 All Day
netweight
string
nextshipment
stringtomorrow
ordered
number2
orderidx
number0
origin
string
originalsize
string
packaging
string
productshipment
stringauto
productuid
stringA9F523B2-3F61-473C-959FB1621D76AF4E
promountil
string
rating
stringnone
recorduid
stringA9F523B2-3F61-473C-959FB1621D76AF4E
reference
stringCGCC7514
related
string
reserved
string
returned
number0
returnsallowed
number1
section
stringlingerie
shipment
string5to7days
showbrand
number0
sizeinfos
Query
Template: /system/api/product/sizes.cfc:20
Execution Time: 1.59 ms
Record Count: 10
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,'2267,2268,2269,2270,2271') > 0
and product_variations.productuid = 'A9F523B2-3F61-473C-959FB1621D76AF4E'
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
122675-6intlsizebrown56-19999990wplusstockingQ Petite5-644-4614-1618-2046-4846-4844-4650-5246-4844-46150-17077-107
222675-6intlsizeblack56-19999990wplusstockingQ Petite5-644-4614-1618-2046-4846-4844-4650-5246-4844-46150-17077-107
322687-8intlsizeblack78-19999991wplusstocking1X-2X7-848-5018-2022-2450-5250-5248-5054-5650-5248-50168-17877-100
422687-8intlsizebrown78-19999990wplusstocking1X-2X7-848-5018-2022-2450-5250-5248-5054-5650-5248-50168-17877-100
522699-10intlsizeblack910-19999990wplusstocking3X-4X9-1052-5422-2426-2854-5654-5652-5458-6054-5652-54168-18391-118
622699-10intlsizebrown910-19999990wplusstocking3X-4X9-1052-5422-2426-2854-5654-5652-5458-6054-5652-54168-18391-118
7227011-12intlsizebrown1112-19999990wplusstocking5X-6X11-1256-5826-2830-3258-6058-6056-5862-6458-6056-58168-183104-132
8227011-12intlsizeblack1112-19999990wplusstocking5X-6X11-1256-5826-2830-3258-6058-6056-5862-6458-6056-58168-183104-132
9227113-14intlsizebrown1314-19999990wplusstocking7X13-1460-6230-3234-3662-6462-6460-6266-6862-6460-62168-183118-150
10227113-14intlsizeblack1314-19999990wplusstocking7X13-1460-6230-3234-3662-6462-6460-6266-6862-6460-62168-183118-150
sizeranges
stringplus
sizes
string2267,2268,2269,2270,2271
sizetype
stringauto
specifications
Struct
Entries: 23
belly
string
bones
string
bra
string
breasts
string
bust
string
closing
string
crochtless
string
cups
string
cut
string
garter
string
halter
string
lacing
string
lining
string
modestypanel
string
panty
string
sheathing
string
sleeves
string
stocking
string
straps
string
stretch
string
suspenders
string
transparency
string
underwires
string
stock
number0
stocks
Query
Template: /system/api/product/stocks.cfc:25
Execution Time: 24.2 ms
Record Count: 10
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 = 'A9F523B2-3F61-473C-959FB1621D76AF4E'
and product_variations.isactive = 1
and product_sizes.id_size = 2267
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 = 'A9F523B2-3F61-473C-959FB1621D76AF4E'
and product_variations.isactive = 1
and product_sizes.id_size = 2268
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 = 'A9F523B2-3F61-473C-959FB1621D76AF4E'
and product_variations.isactive = 1
and product_sizes.id_size = 2269
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 = 'A9F523B2-3F61-473C-959FB1621D76AF4E'
and product_variations.isactive = 1
and product_sizes.id_size = 2270
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 = 'A9F523B2-3F61-473C-959FB1621D76AF4E'
and product_variations.isactive = 1
and product_sizes.id_size = 2271
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
1A9F523B2-3F61-473C-959FB1621D76AF4E48861026-4DC8-48BF-8AE6BC5175856F652267black#000000Q Petite5-644-4614-1618-2046-4846-4844-4650-5246-4844-46wstocking5-6intlsize12.45830STOCK01000-10000MM-2207-10all
2A9F523B2-3F61-473C-959FB1621D76AF4E28791F0F-CB7D-47E5-B2BB403188085A212267brown#783D00Q Petite5-644-4614-1618-2046-4846-4844-4650-5246-4844-46wstocking5-6intlsize12.45830STOCK01000-10000MM-2207-10all
3A9F523B2-3F61-473C-959FB1621D76AF4ECA1489EE-995B-4E92-8A1AD7A48939B5CB2268black#0000001X-2X7-848-5018-2022-2450-5250-5248-5054-5650-5248-50wstocking7-8intlsize12.45830STOCK01100-10200MM-220780202521534211all
4A9F523B2-3F61-473C-959FB1621D76AF4E2753ED7B-5183-4DC5-A671AE028191CE302268brown#783D001X-2X7-848-5018-2022-2450-5250-5248-5054-5650-5248-50wstocking7-8intlsize12.45830STOCK01000-10000MM-2207-10all
5A9F523B2-3F61-473C-959FB1621D76AF4E64CBB10E-B10B-4F00-A1AC0999264A6A622269black#0000003X-4X9-1052-5422-2426-2854-5654-5652-5458-6054-5652-54wstocking9-10intlsize12.45830STOCK01000-10000MM-2207-10all
6A9F523B2-3F61-473C-959FB1621D76AF4E371453AA-4F95-4D82-9977026EB383E0142269brown#783D003X-4X9-1052-5422-2426-2854-5654-5652-5458-6054-5652-54wstocking9-10intlsize12.45830STOCK01000-10000MM-2207-10all
7A9F523B2-3F61-473C-959FB1621D76AF4EB178819C-22BA-4C0C-8AE0566D4487FB4D2270black#0000005X-6X11-1256-5826-2830-3258-6058-6056-5862-6458-6056-58wstocking11-12intlsize12.45830STOCK01000-10200MM-2207802025215366-10all
8A9F523B2-3F61-473C-959FB1621D76AF4E2EBC1C9C-1526-4394-8580416947719E2C2270brown#783D005X-6X11-1256-5826-2830-3258-6058-6056-5862-6458-6056-58wstocking11-12intlsize12.45830STOCK01000-10000MM-2207-10all
9A9F523B2-3F61-473C-959FB1621D76AF4ED0DF4798-8CDF-44C9-B2C71803AF285C012271black#0000007X13-1460-6230-3234-3662-6462-6460-6266-6862-6460-62wstocking13-14intlsize12.45830STOCK01000-10200MM-2207802025215373-10all
10A9F523B2-3F61-473C-959FB1621D76AF4EA5B9E2B2-20BA-4815-8F264DEC943846F22271brown#783D007X13-1460-6230-3234-3662-6462-6460-6266-6862-6460-62wstocking13-14intlsize12.45830STOCK01000-10000MM-2207-10all
subcategory
stringtights
supplier
number-1
supplierreference
stringMM-2207-20006
tags
string
themes
string
totalvariations
string
type
stringdefault
unitprice
number12.4583
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 10.6 ms
Record Count: 10
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 = 'A9F523B2-3F61-473C-959FB1621D76AF4E' 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 = 'A9F523B2-3F61-473C-959FB1621D76AF4E' 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 = 'A9F523B2-3F61-473C-959FB1621D76AF4E' 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 = 'A9F523B2-3F61-473C-959FB1621D76AF4E' 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 = 'A9F523B2-3F61-473C-959FB1621D76AF4E' 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 = 'A9F523B2-3F61-473C-959FB1621D76AF4E' 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 = 'A9F523B2-3F61-473C-959FB1621D76AF4E'
and product_variations.isactive = 1
and product_sizes.id_size = 2267
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 = 'A9F523B2-3F61-473C-959FB1621D76AF4E' 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 = 'A9F523B2-3F61-473C-959FB1621D76AF4E' 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 = 'A9F523B2-3F61-473C-959FB1621D76AF4E' 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 = 'A9F523B2-3F61-473C-959FB1621D76AF4E' 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 = 'A9F523B2-3F61-473C-959FB1621D76AF4E' 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 = 'A9F523B2-3F61-473C-959FB1621D76AF4E' 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 = 'A9F523B2-3F61-473C-959FB1621D76AF4E'
and product_variations.isactive = 1
and product_sizes.id_size = 2268
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 = 'A9F523B2-3F61-473C-959FB1621D76AF4E' 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 = 'A9F523B2-3F61-473C-959FB1621D76AF4E' 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 = 'A9F523B2-3F61-473C-959FB1621D76AF4E' 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 = 'A9F523B2-3F61-473C-959FB1621D76AF4E' 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 = 'A9F523B2-3F61-473C-959FB1621D76AF4E' 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 = 'A9F523B2-3F61-473C-959FB1621D76AF4E' 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 = 'A9F523B2-3F61-473C-959FB1621D76AF4E'
and product_variations.isactive = 1
and product_sizes.id_size = 2269
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 = 'A9F523B2-3F61-473C-959FB1621D76AF4E' 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 = 'A9F523B2-3F61-473C-959FB1621D76AF4E' 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 = 'A9F523B2-3F61-473C-959FB1621D76AF4E' 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 = 'A9F523B2-3F61-473C-959FB1621D76AF4E' 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 = 'A9F523B2-3F61-473C-959FB1621D76AF4E' 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 = 'A9F523B2-3F61-473C-959FB1621D76AF4E' 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 = 'A9F523B2-3F61-473C-959FB1621D76AF4E'
and product_variations.isactive = 1
and product_sizes.id_size = 2270
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 = 'A9F523B2-3F61-473C-959FB1621D76AF4E' 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 = 'A9F523B2-3F61-473C-959FB1621D76AF4E' 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 = 'A9F523B2-3F61-473C-959FB1621D76AF4E' 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 = 'A9F523B2-3F61-473C-959FB1621D76AF4E' 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 = 'A9F523B2-3F61-473C-959FB1621D76AF4E' 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 = 'A9F523B2-3F61-473C-959FB1621D76AF4E' 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 = 'A9F523B2-3F61-473C-959FB1621D76AF4E'
and product_variations.isactive = 1
and product_sizes.id_size = 2271
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
148861026-4DC8-48BF-8AE6BC5175856F652267black#000000Q Petite5-644-4614-1618-2046-4846-4844-4650-5246-4844-46wstocking5-6intlsize12.45830STOCK01000-10000MM-2207-10-10-11012.4583all
228791F0F-CB7D-47E5-B2BB403188085A212267brown#783D00Q Petite5-644-4614-1618-2046-4846-4844-4650-5246-4844-46wstocking5-6intlsize12.45830STOCK01000-10000MM-2207-10-10-10012.4583all
3CA1489EE-995B-4E92-8A1AD7A48939B5CB2268black#0000001X-2X7-848-5018-2022-2450-5250-5248-5054-5650-5248-50wstocking7-8intlsize12.45830STOCK01100-10200MM-220780202521534211-11-11012.4583all
42753ED7B-5183-4DC5-A671AE028191CE302268brown#783D001X-2X7-848-5018-2022-2450-5250-5248-5054-5650-5248-50wstocking7-8intlsize12.45830STOCK01000-10000MM-2207-10-11-10012.4583all
564CBB10E-B10B-4F00-A1AC0999264A6A622269black#0000003X-4X9-1052-5422-2426-2854-5654-5652-5458-6054-5652-54wstocking9-10intlsize12.45830STOCK01000-10000MM-2207-10-10-11012.4583all
6371453AA-4F95-4D82-9977026EB383E0142269brown#783D003X-4X9-1052-5422-2426-2854-5654-5652-5458-6054-5652-54wstocking9-10intlsize12.45830STOCK01000-10000MM-2207-10-10-10012.4583all
7B178819C-22BA-4C0C-8AE0566D4487FB4D2270black#0000005X-6X11-1256-5826-2830-3258-6058-6056-5862-6458-6056-58wstocking11-12intlsize12.45830STOCK01000-10200MM-2207802025215366-10-10-11012.4583all
82EBC1C9C-1526-4394-8580416947719E2C2270brown#783D005X-6X11-1256-5826-2830-3258-6058-6056-5862-6458-6056-58wstocking11-12intlsize12.45830STOCK01000-10000MM-2207-10-10-10012.4583all
9D0DF4798-8CDF-44C9-B2C71803AF285C012271black#0000007X13-1460-6230-3234-3662-6462-6460-6266-6862-6460-62wstocking13-14intlsize12.45830STOCK01000-10200MM-2207802025215373-10-10-11012.4583all
10A5B9E2B2-20BA-4815-8F264DEC943846F22271brown#783D007X13-1460-6230-3234-3662-6462-6460-6266-6862-6460-62wstocking13-14intlsize12.45830STOCK01000-10000MM-2207-10-10-10012.4583all
vatrate
number20
warehouse
string