SELECT B.unit_name, C.origin_name, D.destination_name, A.shift, COUNT(A.detactivity_id) total_slab,
SUM(E.weight) total_tonnage
FROM tdetactivity A
LEFT JOIN tmunit B ON
	B.unit_id = A.unit
LEFT JOIN tmorigin C ON
	C.origin_id = A.origin
LEFT JOIN tmdestination D ON
	D.destination_id = A.destination
LEFT JOIN tdisyorder E on
	E.disyorder_id = A.material_no
WHERE A.material_no != 'Empty'
GROUP BY A.unit, A.origin, A.destination, A.shift