Шу ой

AAAASELECT tt.*, t1.name, (SELECT SUM(-1*qty) FROM stc_clientmove tt WHERE year_num=YEAR(CURDATE()) AND month_num=7 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_07) as qty FROM doc_nclient WHERE year_id=YEAR(CURDATE()) AND client_id=0 AND IFNULL(qty_07,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 MEDICLEAR ESSENTIAL FOAM CLEANSING
DJOLIS MEDICLEAR ESSENTIAL FOAM CLEANSING
DJOLIS BUBBLE O2 CLEANSING MASK
DJOLIS ENZYME POWDER
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
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 EXOSOME EYE CREAM
DJOLIS EXOSOME SKIN TONER 300 ML
DJOLIS EXOSOME SKIN TONER
DJOLIS SKIN PORE PUPA MASK

Йил бошидан

Товар	План	Факт	Колдик
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 MEDICLEAR ESSENTIAL FOAM CLEANSING
DJOLIS MEDICLEAR ESSENTIAL FOAM CLEANSING
DJOLIS BUBBLE O2 CLEANSING MASK
DJOLIS ENZYME POWDER
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
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 EXOSOME EYE CREAM
DJOLIS EXOSOME SKIN TONER 300 ML
DJOLIS EXOSOME SKIN TONER
DJOLIS SKIN PORE PUPA MASK