View | Details | Raw Unified | Return to bug 6030
Collapse All | Expand All

(-)a/misc/cronjobs/overdue_notices.pl (-2 / +1 lines)
Lines 392-398 foreach my $branchcode (@branches) { Link Here
392
    $verbose and warn sprintf "branchcode : '%s' using %s\n", $branchcode, $admin_email_address;
392
    $verbose and warn sprintf "branchcode : '%s' using %s\n", $branchcode, $admin_email_address;
393
393
394
    my $sth2 = $dbh->prepare( <<'END_SQL' );
394
    my $sth2 = $dbh->prepare( <<'END_SQL' );
395
SELECT biblio.*, items.*, issues.*, biblioitems.itemtype, TO_DAYS(NOW())-TO_DAYS(date_due) AS days_overdue
395
SELECT biblio.title as "biblio.title", biblio.*, items.*, issues.*, biblioitems.itemtype, TO_DAYS(NOW())-TO_DAYS(date_due) AS days_overdue
396
  FROM issues,items,biblio, biblioitems
396
  FROM issues,items,biblio, biblioitems
397
  WHERE items.itemnumber=issues.itemnumber
397
  WHERE items.itemnumber=issues.itemnumber
398
    AND biblio.biblionumber   = items.biblionumber
398
    AND biblio.biblionumber   = items.biblionumber
399
- 

Return to bug 6030