SELECT i.Code AS Code, i.Name AS Name, IFNULL(SUM(gri.UnitQty), 0) TotalReceived, i.Unit,
IFNULL(
(
SELECT SUM(soi.UnitQty)
FROM SalesOrderItemRow soi
INNER JOIN SalesOrder so on soi.masterId = so.internalId
WHERE soi.ArtCode = i.Code
AND so.TransDate BETWEEN  '1020-01-01' AND '2020-01-01'
AND so.Status = 1
)
,0) TotalSales
FROM Item i
LEFT JOIN GoodsReceiptItemRow gri on gri.ArtCode = i.Code
LEFT JOIN GoodsReceipt gr on gri.masterId = gr.internalId

WHERE gr.TransDate BETWEEN  '1020-01-01' AND '2020-01-01'
AND gr.Status = 1 AND gr.Invalid = 0


GROUP BY i.Code
HAVING TotalSales=0