Lines 404-411
foreach my $branchcode (@branches) {
Link Here
|
404 |
|
404 |
|
405 |
$verbose and warn sprintf "branchcode : '%s' using %s\n", $branchcode, $admin_email_address; |
405 |
$verbose and warn sprintf "branchcode : '%s' using %s\n", $branchcode, $admin_email_address; |
406 |
|
406 |
|
407 |
my $sth2 = $dbh->prepare( <<"END_SQL" ); |
407 |
my $sth2 = $dbh->prepare( <<'END_SQL' ); |
408 |
SELECT biblio.*, items.*, issues.*, biblioitems.itemtype, TO_DAYS($date)-TO_DAYS(date_due) AS days_overdue |
408 |
SELECT biblio.title as "biblio.title", biblio.*, items.*, issues.*, biblioitems.itemtype, TO_DAYS($date)-TO_DAYS(date_due) AS days_overdue |
409 |
FROM issues,items,biblio, biblioitems |
409 |
FROM issues,items,biblio, biblioitems |
410 |
WHERE items.itemnumber=issues.itemnumber |
410 |
WHERE items.itemnumber=issues.itemnumber |
411 |
AND biblio.biblionumber = items.biblionumber |
411 |
AND biblio.biblionumber = items.biblionumber |
412 |
- |
|
|