SELECT B.unit_name, C.origin_name, C.alias AS alias_origin, D.destination_name, D.alias AS alias_destination,
(SELECT COUNT(A.material_no) FROM tdetactivity A
WHERE A.material_no != 'Empty' AND A.shift='1') AS slab_shift1,
(SELECT SUM(B.weight) FROM tdetactivity A
LEFT JOIN tdisyorder B ON
	B.disyorder_id = A.material_no
WHERE A.material_no != 'Empty' AND A.shift='1') AS tonnage_shift1,
(SELECT COUNT(A.material_no) FROM tdetactivity A
WHERE A.material_no != 'Empty' AND A.shift='2') AS slab_shift2,
(SELECT SUM(B.weight) FROM tdetactivity A
LEFT JOIN tdisyorder B ON
	B.disyorder_id = A.material_no
WHERE A.material_no != 'Empty' AND A.shift='2') AS tonnage_shift2,
(SELECT COUNT(A.material_no) FROM tdetactivity A
WHERE A.material_no != 'Empty' AND A.shift='3') AS slab_shift3,
(SELECT SUM(B.weight) FROM tdetactivity A
LEFT JOIN tdisyorder B on
	B.disyorder_id = A.material_no
WHERE A.material_no != 'Empty' AND A.shift='3') as tonnage_shift3
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
WHERE A.material_no != 'Empty'
GROUP BY A.unit, A.origin, A.destination