SELECT
        PartID,
        IdMesin,
        SUM(IF (IdShift = '1' AND HasilProduksi = 'Reject', QtyProduksi,'')) AS Shift1ng,
        SUM(IF (IdShift = '2' AND HasilProduksi = 'Reject',QtyProduksi,'')) AS Shift2ng,
        SUM(IF (IdShift = '3'AND HasilProduksi = 'Reject',QtyProduksi,'')) AS Shift3ng
FROM
        trans_lhpdthp
    WHERE
        DivisiId = 'IJ001' AND Tanggal = '2018-08-20' AND LineID LIKE '%%' AND IdMesin LIKE '%%' AND IdLocation LIKE '%3%' AND PartID LIKE '%%'
   AND TypeProduct LIKE '%%' AND IdShift LIKE '%%' GROUP BY IdMesin, PartID