Mein Warenkorb

❌
Gesamtartikel
Zum Warenkorb
Menü
Siehe Größen
Diskrete, formende Strumpfhose Control Top
Doppelklicken Sie zum Vergrößern
SKU: CGCC2492
Diskrete, formende Strumpfhose Control Top
Lager:

Formen Sie Ihre Rundungen und fühlen Sie sich in aller Leichtigkeit wohl.

Größe:

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

Farbe:
Menge:
15.95 €
Schneller Versand
für die Ungeduldigen unter Ihnen
Fundierte Ratschläge
per Chat, Facebook oder E-Mail
Kostenlose Rücksendungen
innerhalb von 15 Tagen *

Control Top von Legs Boudoir - raffende Strumpfhose

Produktbeschreibung

Für einen fast unsichtbaren Look, aber mit festem Halt, einer wohlgeformten Silhouette und einem weichen Tragegefühl sind unsere ultratransparenten Control Top Strumpfhosen die perfekte Lösung.

Diese Strümpfe werden aus einem bequemen, dehnbaren Nylon hergestellt und sind unübertroffen leicht, um Ihren Beinen eine subtile Sublimation zu verleihen.

Das Control Top-Stützband glättet harmonisch die widerspenstigsten Stellen, sodass Sie gut aussehen und sich wunderbar wohl in Ihrer Haut fühlen.

Technische Details

Verfügbare Größen

Erhältlich von 5-6 bis 13-14

Verfügbare Farben

Schwarz und Creme

Größenanleitung

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

International
  • Größe (Höhe)
  • Gewicht
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
Zum Warenkorb
Artikel
Gesamtartikel
Struct
Entries: 108
actions
Array
available
number26
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.773 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,cream') > 0
and product_variations.productuid = '77EB9E16-F397-4CDE-8A788B8C67B07489'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1blackcolorblakblackblack#000000-113
2creamcolorcreacreambrown#F8DEBF-113
colorrange
stringblack
colors
stringblack,cream
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:48:03'}
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
number15
isactive
number1
iscustommade
number0
isdivasize
number1
isfirstprice
number0
isfixedprice
number0
ishot
number0
isnew
number0
isonline
number0
isoutletprice
number0
itemprice
number13.2917
itempromo
string
key
stringmm-2205-26005
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-10-22 18:42:09'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.598 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','de')
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('77eb9e16-f397-4cde-8a788b8c67b07489',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.29 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','de')
and product_categories.language in ('all','de')
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 <> 'CGCC2492'
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
string852
isprivate
string0
rating
stringall
src
string/photobank/products/mzpm/cgcc2492/fc1fd681431d3328d76a2ec52eb86d28.jpg
type
stringimg
width
string589
back
Struct
height
string838
isprivate
string0
rating
stringall
src
string/photobank/products/mzpm/cgcc2492/1490b34b27b21c0e3bcd8aadcefdc5e5.jpg
type
stringimg
width
string579
default
Struct
height
string840
isprivate
string0
rating
stringall
src
string/photobank/products/mzpm/cgcc2492/a34988291d6d1bf5aaa7ce2eb538f0b8.jpg
type
stringimg
width
string581
variations
Struct
colors
Struct
black
Struct
height
string840
isprivate
string0
rating
stringall
src
string/photobank/products/mzpm/cgcc2492/a34988291d6d1bf5aaa7ce2eb538f0b8.jpg
type
stringimg
width
string581
cream
Struct
height
string852
isprivate
string0
rating
stringall
src
string/photobank/products/mzpm/cgcc2492/fc1fd681431d3328d76a2ec52eb86d28.jpg
type
stringimg
width
string589
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-creme
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-krema
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-cream
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-crema
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-creme
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-crema
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-creme
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-creme
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
divasboudoir
Struct
de
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p><span>Für einen fast unsichtbaren Look, aber mit festem Halt, einer wohlgeformten Silhouette und einem weichen Tragegefühl sind unsere ultratransparenten Control Top Strumpfhosen die perfekte Lösung. </span></p> <p><span>Diese Strümpfe werden aus einem bequemen, dehnbaren Nylon hergestellt und sind unübertroffen leicht, um Ihren Beinen eine subtile Sublimation zu verleihen. </span></p> <p><span>Das Control Top-Stützband glättet harmonisch die widerspenstigsten Stellen, sodass Sie gut aussehen und sich wunderbar wohl in Ihrer Haut fühlen.</span></p>
guid
stringhttps://dev.divasboudoir.com/de/control-top-von-legs-boudoir--raffende-strumpfhose-schwarz-ou-creme/cgcc2492.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringFür einen fast unsichtbaren Look, aber mit festem Halt, einer wohlgeformten Silhouette und einem weichen Tragegefühl sind unsere ultratransparenten Control Top Strumpfhosen die perfekte Lösung.
keywords
string
title
stringHüftstrumpfhosen in großen Größen - Fachgeschäft
seotitle
stringControl Top von Legs Boudoir - raffende Strumpfhose
seouri
stringcontrol-top-von-legs-boudoir--raffende-strumpfhose-schwarz-ou-creme
specifications
string
stylingtips
string
summary
stringFormen Sie Ihre Rundungen und fühlen Sie sich in aller Leichtigkeit wohl.
title
stringDiskrete, formende Strumpfhose Control Top
usageinstructions
string
el
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p><span>Για μια σχεδόν αόρατη εμφάνιση, αλλά με σταθερή στήριξη, σμιλευμένη σιλουέτα και απαλή αίσθηση, το εξαιρετικά διαφανές καλσόν Control Top είναι η τέλεια λύση. </span></p> <p><span>Κατασκευασμένες από άνετο ελαστικό νάιλον, αυτές οι κάλτσες είναι ασυναγώνιστα ελαφριές, χαρίζοντας στα πόδια σας μια διακριτική ανύψωση. </span></p> <p><span>Η ζώνη στήριξης Control Top εξομαλύνει ακόμα και τις πιο επίμονες περιοχές, ώστε να δείχνετε και να αισθάνεστε υπέροχα.</span></p>
guid
stringhttps://dev.divasboudoir.com/el/kolan-control-top-apo-to-legs-boudoir-mayro-ou-krema/cgcc2492.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringΓια μια σχεδόν αόρατη εμφάνιση, αλλά με σταθερή στήριξη, σμιλευμένη σιλουέτα και απαλή αίσθηση, το εξαιρετικά διαφανές καλσόν Control Top είναι η τέλεια λύση.
keywords
string
title
stringΚαλσόν για μεγάλα μεγέθη - Ειδικό κατάστημα
seotitle
stringΚολάν Control Top από το Legs Boudoir
seouri
stringkolan-control-top-apo-to-legs-boudoir-mayro-ou-krema
specifications
string
stylingtips
string
summary
stringΔιαμορφώστε τις καμπύλες σας και νιώστε ελαφριά και άνετα.
title
stringΔιακριτικό καλσόν Control Top
usageinstructions
string
en
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p><span>For an almost invisible look but with firm support, a sculpted silhouette and a soft feel, our ultra-transparent Control Top tights are the perfect solution. </span></p> <p><span>Crafted from comfortable stretch nylon, these stockings are unrivalled in their lightness, bringing a subtle sublimation to your legs. </span></p> <p><span>The Control Top support band harmoniously smoothes even the most stubborn areas, leaving you looking and feeling fabulous.</span></p>
guid
stringhttps://dev.divasboudoir.com/en/control-top-pantyhose-from-legs-boudoir-black-ou-cream/cgcc2492.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringFor an almost invisible look but with firm support, a sculpted silhouette and a soft feel, our ultra-transparent Control Top tights are the perfect solution.
keywords
string
title
stringPlus size pantyhose - Specialist store
seotitle
stringControl Top pantyhose from Legs Boudoir
seouri
stringcontrol-top-pantyhose-from-legs-boudoir-black-ou-cream
specifications
string
stylingtips
string
summary
stringShape your curves and feel light and comfortable.
title
stringControl Top discreet pantyhose
usageinstructions
string
es
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p><span>Para un aspecto casi invisible pero con una sujeción firme, una silueta esculpida y un tacto suave, nuestras medias Control Top ultratransparentes son la solución perfecta. </span></p> <p><span>Confeccionadas en cómodo nailon elástico, estas medias no tienen rival por su ligereza, lo que proporciona a tus piernas una sutil elevación. </span></p> <p><span>La banda de sujeción Control Top alisa incluso las zonas más rebeldes, para que puedas verte y sentirte fabulosa.</span></p>
guid
stringhttps://dev.divasboudoir.com/es/pantimedias-control-top-de-legs-boudoir-negro-ou-crema/cgcc2492.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringPara un aspecto casi invisible pero con una sujeción firme, una silueta esculpida y un tacto suave, nuestras mallas Control Top ultratransparentes son la solución perfecta.
keywords
string
title
stringPantys talla grande - Tienda especializada
seotitle
stringPantimedias Control Top de Legs Boudoir
seouri
stringpantimedias-control-top-de-legs-boudoir-negro-ou-crema
specifications
string
stylingtips
string
summary
stringMoldea tus curvas y siéntete ligera y cómoda.
title
stringBraga discreta Control Top
usageinstructions
string
fr
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p><span>Pour une apparence presque invisible mais avec un maintien ferme au niveau du ventre, une silhouette sculpt&eacute;e et une sensation de douceur, nos collants Control Top ultra-transparents sont la solution parfaite.&nbsp;</span></p> <p><span>Confectionn&eacute;s dans un nylon extensible et confortable, ces bas sont d'une l&eacute;g&egrave;ret&eacute; in&eacute;gal&eacute;e pour apporter une sublimation subtile &agrave; vos jambes. </span></p> <p><span>La bande de maintien Control Top lisse harmonieusement les zones les plus rebelles, vous permettant ainsi d'avoir fi&egrave;re allure et de vous sentir merveilleusement bien dans votre peau.</span></p>
guid
stringhttps://dev.divasboudoir.com/fr/collants-gainants-control-top-de-legs-boudoir-noir-ou-creme/cgcc2492.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringPour une apparence presque invisible mais avec un maintien ferme, une silhouette sculptée et une sensation de douceur, nos collants Control Top ultra-transparents sont la solution parfaite.
keywords
string
title
stringCollants gainants grande taille - Boutique spécialisée
seotitle
stringCollants gainants Control Top de Legs Boudoir
seouri
stringcollants-gainants-control-top-de-legs-boudoir-noir-ou-creme
specifications
string
stylingtips
string
summary
string<p>Galbez vos rondeurs et sentez-vous &agrave; l'aise en toute l&eacute;g&egrave;ret&eacute;. Ils sont tr&egrave;s fins, presque invisibles sur la jambe.</p>
title
stringCollants gainants discrets Control Top
usageinstructions
string
it
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p><span>Per un aspetto quasi invisibile ma con un sostegno deciso, una silhouette scolpita e una sensazione di morbidezza, i nostri collant Control Top ultra-trasparenti sono la soluzione perfetta. </span></p> <p><span>Realizzate in comodo nylon elasticizzato, queste calze sono impareggiabili per la loro leggerezza e donano alle gambe un sottile effetto lifting. </span></p> <p><span>La fascia di sostegno Control Top leviga anche le zone più ostinate, per farvi apparire e sentire favolose.</span></p>
guid
stringhttps://dev.divasboudoir.com/it/collant-control-top-di-legs-boudoir-nero-ou-crema/cgcc2492.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringPer un aspetto quasi invisibile ma con un sostegno deciso, una silhouette scolpita e una sensazione di morbidezza, i nostri collant Control Top ultra-trasparenti sono la soluzione perfetta.
keywords
string
title
stringCollant taglia grande - Negozio specializzato
seotitle
stringCollant Control Top di Legs Boudoir
seouri
stringcollant-control-top-di-legs-boudoir-nero-ou-crema
specifications
string
stylingtips
string
summary
stringModellate le vostre curve e sentitevi leggeri e comodi.
title
stringCollant discreti Control Top
usageinstructions
string
nl
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p><span>Voor een bijna onzichtbare look, maar met stevige ondersteuning, een gebeeldhouwd silhouet en een zacht gevoel, is onze ultra-transparante Control Top panty de perfecte oplossing. </span></p> <p><span>Deze kousen van comfortabel stretchnylon zijn ongeëvenaard licht en geven je benen een subtiele lift. </span></p> <p><span>De Control Top steunband strijkt zelfs de meest hardnekkige zones glad, zodat je er fantastisch uitziet en je ook zo voelt.</span></p>
guid
stringhttps://dev.divasboudoir.com/nl/control-top-panty-van-legs-boudoir-zwart-ou-creme/cgcc2492.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringVoor een bijna onzichtbare look, maar met stevige ondersteuning, een gebeeldhouwd silhouet en een zacht gevoel, is onze ultra-transparante Control Top panty de perfecte oplossing.
keywords
string
title
stringGrote maten panty's - speciaalzaak
seotitle
stringControl Top panty van Legs Boudoir
seouri
stringcontrol-top-panty-van-legs-boudoir-zwart-ou-creme
specifications
string
stylingtips
string
summary
stringGeef je rondingen vorm en voel je licht en comfortabel.
title
stringControl Top discrete panty
usageinstructions
string
pt
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p><span>Para um aspeto quase invisível, mas com um apoio firme, uma silhueta esculpida e um toque suave, as nossas meias-calças Control Top ultra-transparentes são a solução perfeita. </span></p> <p><span>Feitas de nylon elástico confortável, estas meias são inigualáveis na sua leveza, dando às suas pernas uma subtil elevação. </span></p> <p><span>A banda de suporte Control Top alisa até as zonas mais difíceis, para que possa ter um aspeto e sentir-se fabulosa.</span></p>
guid
stringhttps://dev.divasboudoir.com/pt/meia-calca-control-top-da-legs-boudoir-preto-ou-creme/cgcc2492.htm
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringPara um aspeto quase invisível, mas com um apoio firme, uma silhueta esculpida e um toque suave, os nossos collants Control Top ultra-transparentes são a solução perfeita.
keywords
string
title
stringMeias-calças plus size - Loja especializada
seotitle
stringMeia-calça Control Top da Legs Boudoir
seouri
stringmeia-calca-control-top-da-legs-boudoir-preto-ou-creme
specifications
string
stylingtips
string
summary
stringModele as suas curvas e sinta-se leve e confortável.
title
stringMeias-calças discretas Control Top
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-creme
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-krema
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-cream
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-crema
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-creme
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-crema
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-creme
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-creme
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-creme
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-krema
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-cream
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-crema
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-creme
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-crema
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-creme
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-creme
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
legsboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>Für einen fast unsichtbaren Look, aber mit festem Halt, einer wohlgeformten Silhouette und einem weichen Tragegefühl sind unsere ultratransparenten Control Top Strumpfhosen die perfekte Lösung. </span></p> <p><span>Diese Strümpfe werden aus einem bequemen, dehnbaren Nylon hergestellt und sind unübertroffen leicht, um Ihren Beinen eine subtile Sublimation zu verleihen. </span></p> <p><span>Das Control Top-Stützband glättet harmonisch die widerspenstigsten Stellen, sodass Sie gut aussehen und sich wunderbar wohl in Ihrer Haut fühlen.</span></p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringFür einen fast unsichtbaren Look, aber mit festem Halt, einer wohlgeformten Silhouette und einem weichen Tragegefühl sind unsere ultratransparenten Control Top Strumpfhosen die perfekte Lösung.
keywords
string
title
stringHüftstrumpfhosen in großen Größen - Fachgeschäft
seotitle
stringControl Top gaining strumpfhosen große Größe von Legs Boudoir
seouri
stringcontrol-top-gaining-strumpfhosen-grosse-grosse-von-legs-boudoir-schwarz-ou-creme
specifications
string
stylingtips
string
summary
stringFormen Sie Ihre Rundungen und fühlen Sie sich in aller Leichtigkeit wohl.
title
stringDiskrete, formende Strumpfhosen in großen Größen Control Top
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>Για μια σχεδόν αόρατη εμφάνιση, αλλά με σταθερή στήριξη, σμιλευμένη σιλουέτα και απαλή αίσθηση, το εξαιρετικά διαφανές καλσόν Control Top είναι η τέλεια λύση. </span></p> <p><span>Κατασκευασμένα από άνετο ελαστικό νάιλον, αυτά τα καλσόν είναι ασυναγώνιστα ελαφριά, χαρίζοντας στα πόδια σας μια διακριτική ανύψωση. </span></p> <p><span>Η ζώνη στήριξης Control Top εξομαλύνει ακόμα και τις πιο επίμονες περιοχές, ώστε να δείχνετε και να αισθάνεστε υπέροχα.</span></p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringΓια μια σχεδόν αόρατη εμφάνιση, αλλά με σταθερή στήριξη, σμιλευμένη σιλουέτα και απαλή αίσθηση, το εξαιρετικά διαφανές καλσόν Control Top είναι η τέλεια λύση.
keywords
string
title
stringΚαλσόν για μεγάλα μεγέθη - Ειδικό κατάστημα
seotitle
stringControl Top καλσόν μεγάλου μεγέθους από το Legs Boudoir
seouri
stringcontrol-top-kalson-megaloy-megethoys-apo-to-legs-boudoir-mayro-ou-krema
specifications
string
stylingtips
string
summary
stringΔιαμορφώστε τις καμπύλες σας και νιώστε ελαφριά και άνετα.
title
stringΔιακριτικό διάφανο καλσόν μεγάλου μεγέθους Control Top
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>For an almost invisible look but with firm support, a sculpted silhouette and a soft feel, our ultra-transparent Control Top tights are the perfect solution. </span></p> <p><span>Crafted from comfortable stretch nylon, these stockings are unrivalled in their lightness to bring subtle sublimation to your legs. </span></p> <p><span>The Control Top support band harmoniously smoothes even the most stubborn areas, leaving you looking and feeling fabulous.</span></p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringFor an almost invisible look but with firm support, a sculpted silhouette and a soft feel, our ultra-transparent Control Top tights are the perfect solution.
keywords
string
title
stringPlus size pantyhose - Specialist store
seotitle
stringControl Top plus size pantyhose from Legs Boudoir
seouri
stringcontrol-top-plus-size-pantyhose-from-legs-boudoir-black-ou-cream
specifications
string
stylingtips
string
summary
stringShape your curves and feel light and comfortable.
title
stringDiscreet pantyhose plus size Control Top
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>Para un aspecto casi invisible pero con una sujeción firme, una silueta esculpida y un tacto suave, nuestras medias Control Top ultratransparentes son la solución perfecta. </span></p> <p><span>Confeccionadas en cómodo nailon elástico, estas medias no tienen rival por su ligereza, lo que proporciona a tus piernas una sutil elevación. </span></p> <p><span>La banda de sujeción Control Top alisa incluso las zonas más rebeldes, para que puedas verte y sentirte fabulosa.</span></p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringPara un aspecto casi invisible pero con una sujeción firme, una silueta esculpida y un tacto suave, nuestras mallas Control Top ultratransparentes son la solución perfecta.
keywords
string
title
stringPantys talla grande - Tienda especializada
seotitle
stringBraga de talla grande Control Top de Legs Boudoir
seouri
stringbraga-de-talla-grande-control-top-de-legs-boudoir-negro-ou-crema
specifications
string
stylingtips
string
summary
stringMoldea tus curvas y siéntete ligera y cómoda.
title
stringMedias transparentes discretas talla grande Control Top
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>Pour une apparence presque invisible sur la jambe, mais avec un maintien ferme au ventre, une silhouette sculpt&eacute;e et une sensation de douceur, nos collants Control Top ultra-transparents sont la solution parfaite.&nbsp;</span></p> <p><span>Confectionn&eacute;s dans un nylon extensible et confortable, ces bas sont d'une l&eacute;g&egrave;ret&eacute; in&eacute;gal&eacute;e pour apporter une sublimation subtile &agrave; vos jambes. </span></p> <p><span>La bande de maintien Control Top lisse harmonieusement les zones les plus rebelles, vous permettant ainsi d'avoir fi&egrave;re allure et de vous sentir merveilleusement bien dans votre peau.</span></p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringPour une apparence presque invisible mais avec un maintien ferme, une silhouette sculptée et une sensation de douceur, nos collants Control Top ultra-transparents sont la solution parfaite.
keywords
string
title
stringCollants gainants grande taille - Boutique spécialisée
seotitle
stringCollants gainants Control Top grande taille de Legs Boudoir
seouri
stringcollants-gainants-control-top-grande-taille-de-legs-boudoir-noir-ou-creme
specifications
string
stylingtips
string
summary
string<p>Galbez vos rondeurs et sentez-vous &agrave; l'aise en toute l&eacute;g&egrave;ret&eacute;. Attention, nylon tr&egrave;s tr&egrave;s fin, presque invisible.</p>
title
stringCollants gainants discrets grande taille Control Top
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>Per un aspetto quasi invisibile ma con un sostegno deciso, una silhouette scolpita e una sensazione di morbidezza, i nostri collant Control Top ultra-trasparenti sono la soluzione perfetta. </span></p> <p><span>Realizzate in comodo nylon elasticizzato, queste calze sono impareggiabili per la loro leggerezza e donano alle gambe un sottile effetto lifting. </span></p> <p><span>La fascia di sostegno Control Top leviga anche le zone più ostinate, per farvi apparire e sentire favolose.</span></p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringPer un aspetto quasi invisibile ma con un sostegno deciso, una silhouette scolpita e una sensazione di morbidezza, i nostri collant Control Top ultra-trasparenti sono la soluzione perfetta.
keywords
string
title
stringCollant taglia grande - Negozio specializzato
seotitle
stringCollant Control Top taglia grande di Legs Boudoir
seouri
stringcollant-control-top-taglia-grande-di-legs-boudoir-nero-ou-crema
specifications
string
stylingtips
string
summary
stringModellate le vostre curve e sentitevi leggeri e comodi.
title
stringCollant velati discreti taglia grande Control Top
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>Voor een bijna onzichtbare look, maar met stevige ondersteuning, een gebeeldhouwd silhouet en een zacht gevoel, is onze ultra-transparante Control Top panty de perfecte oplossing. </span></p> <p><span>Deze kousen van comfortabel stretchnylon zijn ongeëvenaard licht en geven je benen een subtiele lift. </span></p> <p><span>De Control Top steunband strijkt zelfs de meest hardnekkige zones glad, zodat je er fantastisch uitziet en je ook zo voelt.</span></p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringVoor een bijna onzichtbare look, maar met stevige ondersteuning, een gebeeldhouwd silhouet en een zacht gevoel, is onze ultra-transparante Control Top panty de perfecte oplossing.
keywords
string
title
stringGrote maten panty's - speciaalzaak
seotitle
stringControl Top grote maat panty van Legs Boudoir
seouri
stringcontrol-top-grote-maat-panty-van-legs-boudoir-zwart-ou-creme
specifications
string
stylingtips
string
summary
stringGeef je rondingen vorm en voel je licht en comfortabel.
title
stringDiscrete panty grote maat Control Top
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p><span>Para um aspeto quase invisível, mas com um apoio firme, uma silhueta esculpida e um toque suave, as nossas meias-calças Control Top ultra-transparentes são a solução perfeita. </span></p> <p><span>Feitas de nylon elástico confortável, estas meias são inigualáveis na sua leveza, dando às suas pernas uma subtil elevação. </span></p> <p><span>A banda de suporte Control Top alisa até as zonas mais difíceis, para que possa ter um aspeto e sentir-se fabulosa.</span></p>
highlights
string
keypoint
string
keywords
string
metas
Struct
description
stringPara um aspeto quase invisível, mas com um apoio firme, uma silhueta esculpida e um toque suave, os nossos collants Control Top ultra-transparentes são a solução perfeita.
keywords
string
title
stringMeias-calças plus size - Loja especializada
seotitle
stringMeias-calças de tamanho grande Control Top da Legs Boudoir
seouri
stringmeias-calcas-de-tamanho-grande-control-top-da-legs-boudoir-preto-ou-creme
specifications
string
stylingtips
string
summary
stringModele as suas curvas e sinta-se leve e confortável.
title
stringCollants transparentes discretos tamanho grande Control Top
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-creme
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-krema
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-cream
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-crema
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-creme
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-crema
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-creme
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-creme
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-creme
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-krema
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-cream
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-crema
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-creme
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-crema
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-creme
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-creme
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
name
stringMM-2205-26005
netweight
string
nextshipment
stringtomorrow
ordered
number3
orderidx
number0
origin
string
originalsize
string
packaging
number0
productshipment
stringauto
productuid
string77EB9E16-F397-4CDE-8A788B8C67B07489
promountil
string
rating
stringnone
recorduid
string77EB9E16-F397-4CDE-8A788B8C67B07489
reference
stringCGCC2492
related
string
reserved
number0
returned
number0
returnsallowed
number1
section
stringlingerie
shipment
string5to7days
showbrand
number0
sizeinfos
Query
Template: /system/api/product/sizes.cfc:20
Execution Time: 1.52 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 = '77EB9E16-F397-4CDE-8A788B8C67B07489'
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-6intlsizeblack56-19999992wplusstockingQ Petite5-644-4614-1618-2046-4846-4844-4650-5246-4844-46150-17077-107
222675-6intlsizecream56-19999992wplusstockingQ Petite5-644-4614-1618-2046-4846-4844-4650-5246-4844-46150-17077-107
322687-8intlsizecream78-19999993wplusstocking1X-2X7-848-5018-2022-2450-5250-5248-5054-5650-5248-50168-17877-100
422687-8intlsizeblack78-19999992wplusstocking1X-2X7-848-5018-2022-2450-5250-5248-5054-5650-5248-50168-17877-100
522699-10intlsizeblack910-19999993wplusstocking3X-4X9-1052-5422-2426-2854-5654-5652-5458-6054-5652-54168-18391-118
622699-10intlsizecream910-19999992wplusstocking3X-4X9-1052-5422-2426-2854-5654-5652-5458-6054-5652-54168-18391-118
7227011-12intlsizeblack1112-19999994wplusstocking5X-6X11-1256-5826-2830-3258-6058-6056-5862-6458-6056-58168-183104-132
8227011-12intlsizecream1112-19999993wplusstocking5X-6X11-1256-5826-2830-3258-6058-6056-5862-6458-6056-58168-183104-132
9227113-14intlsizecream1314-19999993wplusstocking7X13-1460-6230-3234-3662-6462-6460-6266-6862-6460-62168-183118-150
10227113-14intlsizeblack1314-19999992wplusstocking7X13-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
number26
stocks
Query
Template: /system/api/product/stocks.cfc:25
Execution Time: 31.8 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 = '77EB9E16-F397-4CDE-8A788B8C67B07489'
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 = '77EB9E16-F397-4CDE-8A788B8C67B07489'
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 = '77EB9E16-F397-4CDE-8A788B8C67B07489'
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 = '77EB9E16-F397-4CDE-8A788B8C67B07489'
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 = '77EB9E16-F397-4CDE-8A788B8C67B07489'
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
177EB9E16-F397-4CDE-8A788B8C67B074894E31A80D-887B-4F3E-8944DCA33FFD7F562267black#000000Q Petite5-644-4614-1618-2046-4846-4844-4650-5246-4844-46wstocking5-6intlsize13.29170STOCK01200-10100MM-220580202521558822all
277EB9E16-F397-4CDE-8A788B8C67B074898566BC1F-CD3A-4262-86C8EEB92EB458BE2267cream#F8DEBFQ Petite5-644-4614-1618-2046-4846-4844-4650-5246-4844-46wstocking5-6intlsize13.29170STOCK01200-10100MM-220580202521573122all
377EB9E16-F397-4CDE-8A788B8C67B0748909F700EE-607F-4CBD-B89E5A483060CC912268black#0000001X-2X7-848-5018-2022-2450-5250-5248-5054-5650-5248-50wstocking7-8intlsize13.29170STOCK01200-10100MM-220580202521559522all
477EB9E16-F397-4CDE-8A788B8C67B07489DDD40D7A-B9A0-4DB2-B5272A78211D2AD72268cream#F8DEBF1X-2X7-848-5018-2022-2450-5250-5248-5054-5650-5248-50wstocking7-8intlsize13.29170STOCK01300-10000MM-220580202521569433all
577EB9E16-F397-4CDE-8A788B8C67B07489C6317417-6FEC-4DEA-AA94D6A6362C668B2269black#0000003X-4X9-1052-5422-2426-2854-5654-5652-5458-6054-5652-54wstocking9-10intlsize13.29170STOCK01300-10000MM-220580202521555733all
677EB9E16-F397-4CDE-8A788B8C67B074893C43AD00-BCBE-41A7-AB0C869DC6FA7A0D2269cream#F8DEBF3X-4X9-1052-5422-2426-2854-5654-5652-5458-6054-5652-54wstocking9-10intlsize13.29170STOCK01200-10100MM-220580202521570022all
777EB9E16-F397-4CDE-8A788B8C67B0748928CACDA9-3BA6-4D37-B3D40C047E9AAC2E2270black#0000005X-6X11-1256-5826-2830-3258-6058-6056-5862-6458-6056-58wstocking11-12intlsize13.29170STOCK01400-10000MM-220580202521556444all
877EB9E16-F397-4CDE-8A788B8C67B0748986B6C4A9-6AFE-43B5-8939A6C169959AED2270cream#F8DEBF5X-6X11-1256-5826-2830-3258-6058-6056-5862-6458-6056-58wstocking11-12intlsize13.29170STOCK01300-10000MM-220580202521571733all
977EB9E16-F397-4CDE-8A788B8C67B07489D228E85E-3136-4A00-9B6E5388C64BAF102271black#0000007X13-1460-6230-3234-3662-6462-6460-6266-6862-6460-62wstocking13-14intlsize13.29170STOCK01200-10200MM-220580202521562522all
1077EB9E16-F397-4CDE-8A788B8C67B07489F10FD3F0-23B3-4870-86523957B8070CD02271cream#F8DEBF7X13-1460-6230-3234-3662-6462-6460-6266-6862-6460-62wstocking13-14intlsize13.29170STOCK01300-10000MM-220580202521572433all
subcategory
stringtights
supplier
number-1
supplierreference
stringMM-2205-26005
tags
string
themes
string
totalvariations
number15
type
stringdefault
unitprice
number13.2917
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 11.1 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 = '77EB9E16-F397-4CDE-8A788B8C67B07489' 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 = '77EB9E16-F397-4CDE-8A788B8C67B07489' 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 = '77EB9E16-F397-4CDE-8A788B8C67B07489' 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 = '77EB9E16-F397-4CDE-8A788B8C67B07489' 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 = '77EB9E16-F397-4CDE-8A788B8C67B07489' 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 = '77EB9E16-F397-4CDE-8A788B8C67B07489' 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 = '77EB9E16-F397-4CDE-8A788B8C67B07489'
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 = '77EB9E16-F397-4CDE-8A788B8C67B07489' 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 = '77EB9E16-F397-4CDE-8A788B8C67B07489' 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 = '77EB9E16-F397-4CDE-8A788B8C67B07489' 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 = '77EB9E16-F397-4CDE-8A788B8C67B07489' 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 = '77EB9E16-F397-4CDE-8A788B8C67B07489' 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 = '77EB9E16-F397-4CDE-8A788B8C67B07489' 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 = '77EB9E16-F397-4CDE-8A788B8C67B07489'
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 = '77EB9E16-F397-4CDE-8A788B8C67B07489' 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 = '77EB9E16-F397-4CDE-8A788B8C67B07489' 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 = '77EB9E16-F397-4CDE-8A788B8C67B07489' 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 = '77EB9E16-F397-4CDE-8A788B8C67B07489' 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 = '77EB9E16-F397-4CDE-8A788B8C67B07489' 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 = '77EB9E16-F397-4CDE-8A788B8C67B07489' 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 = '77EB9E16-F397-4CDE-8A788B8C67B07489'
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 = '77EB9E16-F397-4CDE-8A788B8C67B07489' 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 = '77EB9E16-F397-4CDE-8A788B8C67B07489' 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 = '77EB9E16-F397-4CDE-8A788B8C67B07489' 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 = '77EB9E16-F397-4CDE-8A788B8C67B07489' 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 = '77EB9E16-F397-4CDE-8A788B8C67B07489' 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 = '77EB9E16-F397-4CDE-8A788B8C67B07489' 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 = '77EB9E16-F397-4CDE-8A788B8C67B07489'
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 = '77EB9E16-F397-4CDE-8A788B8C67B07489' 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 = '77EB9E16-F397-4CDE-8A788B8C67B07489' 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 = '77EB9E16-F397-4CDE-8A788B8C67B07489' 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 = '77EB9E16-F397-4CDE-8A788B8C67B07489' 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 = '77EB9E16-F397-4CDE-8A788B8C67B07489' 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 = '77EB9E16-F397-4CDE-8A788B8C67B07489' 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 = '77EB9E16-F397-4CDE-8A788B8C67B07489'
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
14E31A80D-887B-4F3E-8944DCA33FFD7F562267black#000000Q Petite5-644-4614-1618-2046-4846-4844-4650-5246-4844-46wstocking5-6intlsize13.29170STOCK01200-10100MM-220580202521558822-14-113013.2917all
28566BC1F-CD3A-4262-86C8EEB92EB458BE2267cream#F8DEBFQ Petite5-644-4614-1618-2046-4846-4844-4650-5246-4844-46wstocking5-6intlsize13.29170STOCK01200-10100MM-220580202521573122-14-113013.2917all
309F700EE-607F-4CBD-B89E5A483060CC912268black#0000001X-2X7-848-5018-2022-2450-5250-5248-5054-5650-5248-50wstocking7-8intlsize13.29170STOCK01200-10100MM-220580202521559522-15-113013.2917all
4DDD40D7A-B9A0-4DB2-B5272A78211D2AD72268cream#F8DEBF1X-2X7-848-5018-2022-2450-5250-5248-5054-5650-5248-50wstocking7-8intlsize13.29170STOCK01300-10000MM-220580202521569433-15-113013.2917all
5C6317417-6FEC-4DEA-AA94D6A6362C668B2269black#0000003X-4X9-1052-5422-2426-2854-5654-5652-5458-6054-5652-54wstocking9-10intlsize13.29170STOCK01300-10000MM-220580202521555733-15-113013.2917all
63C43AD00-BCBE-41A7-AB0C869DC6FA7A0D2269cream#F8DEBF3X-4X9-1052-5422-2426-2854-5654-5652-5458-6054-5652-54wstocking9-10intlsize13.29170STOCK01200-10100MM-220580202521570022-15-113013.2917all
728CACDA9-3BA6-4D37-B3D40C047E9AAC2E2270black#0000005X-6X11-1256-5826-2830-3258-6058-6056-5862-6458-6056-58wstocking11-12intlsize13.29170STOCK01400-10000MM-220580202521556444-17-113013.2917all
886B6C4A9-6AFE-43B5-8939A6C169959AED2270cream#F8DEBF5X-6X11-1256-5826-2830-3258-6058-6056-5862-6458-6056-58wstocking11-12intlsize13.29170STOCK01300-10000MM-220580202521571733-17-113013.2917all
9D228E85E-3136-4A00-9B6E5388C64BAF102271black#0000007X13-1460-6230-3234-3662-6462-6460-6266-6862-6460-62wstocking13-14intlsize13.29170STOCK01200-10200MM-220580202521562522-15-113013.2917all
10F10FD3F0-23B3-4870-86523957B8070CD02271cream#F8DEBF7X13-1460-6230-3234-3662-6462-6460-6266-6862-6460-62wstocking13-14intlsize13.29170STOCK01300-10000MM-220580202521572433-15-113013.2917all
vatrate
number20
warehouse
number26