SELECT
IFNULL(SUM(AMOUNT),0) AS SUMAMOUNT,
IFNULL(SUM(AMOUNT*PRICEDOLLAR),0) AS SUMPRICEDOLLAR,
IFNULL(SUM(IF(MOTION = 'C',AMOUNT,0)),0) AS SUMSELLAMOUNT,
IFNULL(SUM(IF(MOTION = 'G',AMOUNT,0)),0) AS SUMSTOCK
FROM 
CURRENT
WHERE PRODUCTSPK IN (
SELECT PK from PRODUCTS
WHERE CATEGORYPK = 2
)