- LEFT OUTER JOIN archive_backup on archive_backup.backup_id = backups.id
- LEFT OUTER JOIN archive_burned on archive_burned.archive_id = archive_backup.archive_id
+ LEFT OUTER JOIN archive_backup_parts on backup_id = backups.id
+ LEFT OUTER JOIN archive_burned on archive_burned.archive_id = archive_id
my $retHTML .= qq|
<form id="forma" method="POST" action="$MyURL?action=burn">
<script type="text/javascript">
var media_size = $max_archive_size ;
my $retHTML .= qq|
<form id="forma" method="POST" action="$MyURL?action=burn">
<script type="text/javascript">
var media_size = $max_archive_size ;
count(archive_burned.copy) as copies
from archive
inner join archive_burned on archive_burned.archive_id = archive.id
count(archive_burned.copy) as copies
from archive
inner join archive_burned on archive_burned.archive_id = archive.id
- inner join archive_backup on archive.id = archive_backup.archive_id
- inner join backups on backups.id = archive_backup.backup_id
+ inner join archive_backup_parts on archive.id = archive_backup_parts.archive_id
+ inner join backups on backups.id = archive_backup_parts.backup_id
inner join hosts on hosts.id = backups.hostid
inner join shares on shares.id = backups.shareid
where hosts.name = ? and shares.name = ? and backups.num = ?
inner join hosts on hosts.id = backups.hostid
inner join shares on shares.id = backups.shareid
where hosts.name = ? and shares.name = ? and backups.num = ?