items,
filename
FROM archive_backup_parts
- WHERE archive.dvd_nr = ?
+ WHERE dvd_nr = ?
ORDER BY backup_id, part_nr
});
$sth->finish;
$sth_archive_backup_parts->finish;
$sth_archive_burned->finish;
-$sth_archive_backup_check->finish;
$sth_archive_burned->finish;
$dbh->disconnect;
select
filename,
part_nr,
- TIMESTAMP 'epoch' + a.date * INTERVAL '1 second' as date,
+ TIMESTAMP 'epoch' + date * INTERVAL '1 second' as date,
size
- from archive_backup_parts a
- join archive on archive_id = archive.id
+ from archive_backup_parts
where dvd_nr = ?
order by backup_part_id
});