Plain Query

SELECT
spk.nama_customer, spk.no_hp, spk.plat_nomor, spk.jenis_mobil, produk.nama_produk, spk_detail.produk_id, spk_detail.harga, spk.tgl_masuk, spk.nota_spk,
pelunasan.no_nota_pelunasan, spk_detail.spk_valid_until as validUntil, spk_detail.spk_maintenance_notes as maintenance_notes
FROM spk
INNER JOIN spk_detail ON spk.id_spk = spk_detail.spk_id
INNER JOIN produk ON spk_detail.produk_id = produk.id_produk
INNER JOIN pelunasan ON spk.id_spk = pelunasan.pelunasan_nota_spk
WHERE spk_detail.spk_valid_until IS NOT NULL
UNION ALL
SELECT
spk.nama_customer, spk.no_hp, spk.plat_nomor, spk.jenis_mobil, produk.nama_produk, pelunasan_detail.produk_id, pelunasan_detail.harga, spk.tgl_masuk, spk.nota_spk,
pelunasan.no_nota_pelunasan, pelunasan_detail.pelunasan_valid_until as validUntil, pelunasan_detail.pelunasan_maintenance_notes as maintenance_notes
FROM pelunasan
INNER JOIN pelunasan_detail ON pelunasan.id_pelunasan = pelunasan_detail.pelunasan_id
INNER JOIN produk ON pelunasan_detail.produk_id = produk.id_produk
INNER JOIN spk ON pelunasan.pelunasan_nota_spk = spk.id_spk
WHERE pelunasan_detail.pelunasan_valid_until IS NOT NULL
ORDER BY nama_customer ASC