select
	hosts.name,
	shares.name,
	backups.num,
	date::abstime
from backups
	join hosts on hosts.id = hostid
	join shares on shares.id = shareid
where backups.id not in (select backup_id from backup_parts) and inc_size != -1
order by hosts.name, shares.name ;

