Шу ой

AAAASELECT tt.*, t1.name, (SELECT SUM(-1*qty) FROM stc_clientmove tt WHERE year_num=YEAR(CURDATE()) AND month_num=1 AND client_id=0 AND type_id IN (2,4) AND product_id=t1.id) as fact FROM dic_products t1 LEFT JOIN (SELECT np_id, (SELECT name FROM dic_np WHERE id=np_id) as np_name, SUM(qty_01) as qty FROM doc_nclient WHERE year_id=YEAR(CURDATE()) AND client_id=0 AND IFNULL(qty_01,0)<>0 GROUP BY np_id HAVING qty<>0) tt ON (t1.id=tt.np_id)

Тов2ар	План	Факт	Колдик
MOIISANITE FINE
MOISSANITE SUBQ
MOISSANITE DEEP
DJOLIS WHITE ( 5 VIVAL ) 4 ML
DJOLIS V-LINE PREMIUM ( 5 VIVAL ) 10 ML
DJOLIS INTENSIVE SUPER SOLUTION ( 5 VIVAL ) 3 ML
CO2 GEL FACE MASK
CO2 FACE MASK
DJOLIS UP 10 PCS
DJOLIS EXOSOME
MOISSANITE AQUA WHITE
MOISSANITE AQUA RED
MOISSANITE SUPER
MOISSANITE LIFT
MOISSANITE SNOW
DJOLIS PERFECT SUN MILK SPF50+PA+++
DJOLIS AQUALASTING COVER CREAM
DJOLIS DELPORE SILKY PRIMER
DJOLIS NATURAL SKIN CC CREAM SPF50+++
DJOLIS PERFECT SUN MILK SPF50 (SAMPLE )
DJOLIS DELPORE SILKY PRIMER ( SAMPLE )
DJOLIS AQUA LASTING COVER CREAM (SAMPLE )
DJOLIS NATURAL SKIN SS KREM ( SAMPLE 3 ML )
DJOLIS BIO CELL SUN MILK SPF50+/PA+++
DJOLIS WHITENING MILKY CREAM
DJOLIS HYDRO WATERDROP NATURAL CREAM
DJOLIS REVITALIZING SNAIL MULTI CREAM
DJOLIS STEM CELL CREAM ( SAMPLE 3 ML )
DJOLIS REVITALIZING SNAIL CREAM ( SAMPLE 3 ML )
DJOLIS WHITENING CREAM ( SAMPLE 3 ML )
DJOLIS HYDRO WATERDROP CREAM ( SAMPLE )3 ML
DJOLIS STEM CELL CREAM
EXSOSOME CREAM 100 ML
DJOLIS ANTI-ACNY CREAM
DJOLIS STEM CELL CREAM
DJOLIS MULTI-C VITALIZING CREAM
DJOLIS ENERGIZING COLLAGEN CREAM
DJOLIS HYDRO WATERDROP NATURAL CREAM
DJOLIS MEDICLEAR ESSENTIAL FOAM CLEANSING
DJOLIS MEDICLEAR ESSENTIAL FOAM CLEANSING
DJOLIS BUBBLE O2 CLEANSING MASK
DJOLIS ENZYME POWDER
DJOLIS MEDICLEAR PERFECT PEELING GEL
DJOLIS MILD PURE FOAMING FEMININE WASH
DJOLIS MEDICLEAR MAKE-UP REMOVER
DJOLIS MEDICLEAR PERFECT PEELING GEL
DJOLIS MEDITREATMENT ALOE GEL
DJOLIS AZULEN SOOTHING GEL
DJOLIS AZULEN SOOTHING GEL (SAMPLE 3 ML )
DJOLIS MEDITREATMENT ALOE GEL ( SAMPLE 3 ML )
DJOLIS AQUA SMOOTH-E
DJOLIS AQUA SMOTH-E
DJOLIS MEDITREATMENT ALOE GEL
DJOLIS AZULEN SOOTHING GEL
DJOLIS GOAT MILK NUTRITION LOTION
DR.QUEEN ( LED )
DERMA PEN
DJOLIS COLLAGEN 300 SHOT
DJOLIS COLLAGEN 300 SHOT SAMPLE
DJOLIS MEDITREATMENT NEUROPEPTIDE SERUM
DJOLIS MEDITREATMENT HYALURONIC MULTI SERUM
DJOLIS REAL 90% COLLAGEN AMPOULE
DJOLIS INNERA
DJOLIS DR.STEM CELL SERUM
DJOLIS MEDITREATMENT BIO TRIPLE C-SERUM
DJOLIS 24 K GOLD LUXURY AMPOULE
DJOLIS MEDITREATMENT ACNY SERUM
DJOLIS EXOSOME EYE CREAM
DJOLIS EXOSOME SKIN TONER 300 ML
DJOLIS EXOSOME SKIN TONER
DJOLIS HUALURONIC SKIN TONER
DJOLIS HUALURONIC SKIN TONER
DJOLIS LAVENDER AROMA SOLUTION
DJOLIS PEPTIDE SKIN TONER
DJOLIS STEM CELL SKIN TONER
DJOLIS SKIN PORE PUPA MASK
DJOLIS WHITE CLAY MASK
DJOLIS CROCO EXOERT LUX MASSAJE CREAM
DJOLIS VITA-C MASSACE CREAM
DJOLIS COLASTIN HIGH FREUQUENCY CREAM
DJOLIS JOJOBA OIL 30%
DJOLIS COCONUT OIL
noviy

Йил бошидан

Товар	План	Факт	Колдик
MOIISANITE FINE
MOISSANITE SUBQ
MOISSANITE DEEP
DJOLIS WHITE ( 5 VIVAL ) 4 ML
DJOLIS V-LINE PREMIUM ( 5 VIVAL ) 10 ML
DJOLIS INTENSIVE SUPER SOLUTION ( 5 VIVAL ) 3 ML
CO2 GEL FACE MASK
CO2 FACE MASK
DJOLIS UP 10 PCS
DJOLIS EXOSOME
MOISSANITE AQUA WHITE
MOISSANITE AQUA RED
MOISSANITE SUPER
MOISSANITE LIFT
MOISSANITE SNOW
DJOLIS PERFECT SUN MILK SPF50+PA+++
DJOLIS AQUALASTING COVER CREAM
DJOLIS DELPORE SILKY PRIMER
DJOLIS NATURAL SKIN CC CREAM SPF50+++
DJOLIS PERFECT SUN MILK SPF50 (SAMPLE )
DJOLIS DELPORE SILKY PRIMER ( SAMPLE )
DJOLIS AQUA LASTING COVER CREAM (SAMPLE )
DJOLIS NATURAL SKIN SS KREM ( SAMPLE 3 ML )
DJOLIS BIO CELL SUN MILK SPF50+/PA+++
DJOLIS WHITENING MILKY CREAM
DJOLIS HYDRO WATERDROP NATURAL CREAM
DJOLIS REVITALIZING SNAIL MULTI CREAM
DJOLIS STEM CELL CREAM ( SAMPLE 3 ML )
DJOLIS REVITALIZING SNAIL CREAM ( SAMPLE 3 ML )
DJOLIS WHITENING CREAM ( SAMPLE 3 ML )
DJOLIS HYDRO WATERDROP CREAM ( SAMPLE )3 ML
DJOLIS STEM CELL CREAM
EXSOSOME CREAM 100 ML
DJOLIS ANTI-ACNY CREAM
DJOLIS STEM CELL CREAM
DJOLIS MULTI-C VITALIZING CREAM
DJOLIS ENERGIZING COLLAGEN CREAM
DJOLIS HYDRO WATERDROP NATURAL CREAM
DJOLIS MEDICLEAR ESSENTIAL FOAM CLEANSING
DJOLIS MEDICLEAR ESSENTIAL FOAM CLEANSING
DJOLIS BUBBLE O2 CLEANSING MASK
DJOLIS ENZYME POWDER
DJOLIS MEDICLEAR PERFECT PEELING GEL
DJOLIS MILD PURE FOAMING FEMININE WASH
DJOLIS MEDICLEAR MAKE-UP REMOVER
DJOLIS MEDICLEAR PERFECT PEELING GEL
DJOLIS MEDITREATMENT ALOE GEL
DJOLIS AZULEN SOOTHING GEL
DJOLIS AZULEN SOOTHING GEL (SAMPLE 3 ML )
DJOLIS MEDITREATMENT ALOE GEL ( SAMPLE 3 ML )
DJOLIS AQUA SMOOTH-E
DJOLIS AQUA SMOTH-E
DJOLIS MEDITREATMENT ALOE GEL
DJOLIS AZULEN SOOTHING GEL
DJOLIS GOAT MILK NUTRITION LOTION
DR.QUEEN ( LED )
DERMA PEN
DJOLIS COLLAGEN 300 SHOT
DJOLIS COLLAGEN 300 SHOT SAMPLE
DJOLIS MEDITREATMENT NEUROPEPTIDE SERUM
DJOLIS MEDITREATMENT HYALURONIC MULTI SERUM
DJOLIS REAL 90% COLLAGEN AMPOULE
DJOLIS INNERA
DJOLIS DR.STEM CELL SERUM
DJOLIS MEDITREATMENT BIO TRIPLE C-SERUM
DJOLIS 24 K GOLD LUXURY AMPOULE
DJOLIS MEDITREATMENT ACNY SERUM
DJOLIS EXOSOME EYE CREAM
DJOLIS EXOSOME SKIN TONER 300 ML
DJOLIS EXOSOME SKIN TONER
DJOLIS HUALURONIC SKIN TONER
DJOLIS HUALURONIC SKIN TONER
DJOLIS LAVENDER AROMA SOLUTION
DJOLIS PEPTIDE SKIN TONER
DJOLIS STEM CELL SKIN TONER
DJOLIS SKIN PORE PUPA MASK
DJOLIS WHITE CLAY MASK
DJOLIS CROCO EXOERT LUX MASSAJE CREAM
DJOLIS VITA-C MASSACE CREAM
DJOLIS COLASTIN HIGH FREUQUENCY CREAM
DJOLIS JOJOBA OIL 30%
DJOLIS COCONUT OIL
noviy