-- display all files (increments) on one DVD
select
	hosts.name,
	shares.name,
	backups.num,
	backups.date::abstime,
	backups.type,
	backups.size,
	backups.parts,
	backups.inc_size,
	backups.inc_deleted
from archive_backup
join archive on archive_id = archive.id
join backups on backup_id = backups.id
join shares on shareid = shares.id
join hosts on backups.hostid = hosts.id
where dvd_nr = 14 ;
