trunk/sql/xx_backups_without_backup_parts.sql

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 ;

1	select
2	hosts.name,
3	shares.name,
4	backups.num,
5	date::abstime
6	from backups
7	join hosts on hosts.id = hostid
8	join shares on shares.id = shareid
9	where backups.id not in (select backup_id from backup_parts) and inc_size != -1
10	order by hosts.name, shares.name ;
11