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	dpavlin	366	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