transaksi pasien

[SELECT tp.id, tpp.id AS id_tpp, tpp.id_transaksi_pasien, tpp.id_setting_paket_produk,tpp.id_setting_promo,tp.id_pasien,  tp.no_transaksi,  pd.nama AS nama_produk,  pd.id AS id_produk, pd.static_code,  shpd.id AS id_setting_harga_produk,  shpd.harga AS harga_produk,  kbp.id AS id_komponen_biaya_produk, kb.id AS id_komponen_biaya, shp.total AS harga,  tpp.jumlah,  tpp.jenis_produk,  tpp.diskon,  tpp.total_harga,  tpp.status_bayar  FROM tmp_transaksi_pasien_produk  tpp  JOIN transaksi_pasien  tp ON tp.id = tpp.id_transaksi_pasien  JOIN setting_harga_produk  shp ON shp.id = tpp.id_setting_harga_produk  JOIN setting_harga_produk_detail  shpd ON shpd.id_setting_harga_produk = shp.id  JOIN  master_komponen_biaya_produk  kbp ON kbp.id = shpd.id_komponen_biaya_produk JOIN  master_komponen_biaya  kb ON kb.id = kbp.id_komponen_biaya JOIN master_produk  pd ON pd.id = shp.id_produk  WHERE tpp.id_setting_paket_produk != 0  AND tpp.id_setting_promo = 0 AND tp.id_pasien = ? AND tpp.status_bayar = ? AND tpp.jenis_produk = ? GROUP BY tpp.id]