SELECT ri.ID,riDet.itemID,ri.locationID,
IF(ri.purchaseOrderID = '-1',ri.formNo,CONCAT(ri.formNo,"[",lpad(ri.serialNo,8,"0"),"]")) formNo,
ri.deliveryDate transDate,um.desc,
`quantityReceived` qtyIn,"0" qtyOut,
"Transfer In" transType  

FROM `comp_receive_item_detail` riDet
LEFT JOIN comp_receive_item ri on ri.ID = riDet.`receiveID`
LEFT JOIN item i on i.ID = riDet.itemID
LEFT JOIN _sys_um um on um.fldid = riDet.umID
ORDER BY ri.deliveryDate DESC