produk double setelah bayar

SELECT rmp.id_kunjungan,
rmp.id,
rmp.id_rekam_medis,
rmp.tanggal_catat, pd.id AS id_produk,
pd.kode AS kode_produk, pd.nama AS nama_produk,
pd.static_code AS static_code, rmp.jumlah,
shp.id AS id_setting_harga_produk,
shp.total AS harga,
NULL AS id_setting_paket_produk,
'Non Paket' AS nama_paket,
NULL AS id_setting_paket_produk_detail,
tpp.total_harga AS total_include,
rmp.id_setting_promo
FROM rekam_medis_tindakan rmp,
rekam_medis rm, kunjungan kj,
 master_produk pd,
 setting_harga_produk shp,
  transaksi_pasien tp,
  transaksi_pasien_produk tpp
WHERE rm.id = rmp.id_rekam_medis
AND kj.id = rmp.id_kunjungan
AND pd.id = rmp.id_produk
AND shp.id_produk = rmp.id_produk
AND tp.id_kunjungan = rmp.id_kunjungan
AND tpp.id_transaksi_pasien = tp.id
AND tpp.id_produk = rmp.id_produk
AND rmp.id_setting_paket_produk = 0
AND rmp.id_setting_promo = 0
AND tpp.status_bayar = 'BELUM_BAYAR'
AND rmp.id_kunjungan = 2
GROUP BY rmp.id