select
	hosts.name as host,
	shares.name,
	backups.num as share,
	inc_size,
	inc_deleted,
	parts
from archive_backup
	join backups on backups.id = backup_id
	join shares on shares.id = shareid
	join hosts on hosts.id = shares.hostid
where archive_id = 21 order by hosts.name, shares.name, backups.num ;

