Sumber :

https://gitlab.com/hendrowicaksono/slims-progresses-query-sample/-/blob/master/dosh-01-koleksi-tanpa-data-eksemplar.md

SELECT b.biblio_id, b.title AS judul, 
GROUP_CONCAT(DISTINCT ma.author_name ORDER BY ma.author_name ASC SEPARATOR '; ') AS pengarang, 
mpu.publisher_name as penerbit, mp.place_name AS tempat_terbit, b.publish_year AS tahun_terbit,
b.edition AS edisi
FROM  biblio b
LEFT JOIN biblio_author AS ba ON b.biblio_id=ba.biblio_id 
LEFT JOIN mst_author AS ma ON ba.author_id=ma.author_id
LEFT JOIN mst_place AS mp ON b.publish_place_id=mp.place_id 
LEFT JOIN mst_publisher AS mpu ON b.publisher_id=mpu.publisher_id 
WHERE
    b.biblio_id NOT IN (
        SELECT DISTINCT(b2.biblio_id) 
        FROM item i
        INNER JOIN biblio b2 ON b2.biblio_id=i.biblio_id
    )
GROUP BY b.biblio_id
;

Semoga Bermanfaat.
Salam, Erwan Setyo Budi.