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

(-)a/C4/Members.pm (-3 / +2 lines)
Lines 273-279 sub GetAllIssues { Link Here
273
273
274
    my $dbh = C4::Context->dbh;
274
    my $dbh = C4::Context->dbh;
275
    my $query =
275
    my $query =
276
'SELECT *, issues.timestamp as issuestimestamp, issues.renewals AS renewals,items.renewals AS totalrenewals,items.timestamp AS itemstimestamp
276
'SELECT issues.*, items.*, biblio.*, biblioitems.*, issues.timestamp as issuestimestamp, issues.renewals AS renewals,items.renewals AS totalrenewals,items.timestamp AS itemstimestamp,borrowers.firstname,borrowers.surname
277
  FROM issues
277
  FROM issues
278
  LEFT JOIN items on items.itemnumber=issues.itemnumber
278
  LEFT JOIN items on items.itemnumber=issues.itemnumber
279
  LEFT JOIN borrowers on borrowers.borrowernumber=issues.issuer
279
  LEFT JOIN borrowers on borrowers.borrowernumber=issues.issuer
Lines 281-287 sub GetAllIssues { Link Here
281
  LEFT JOIN biblioitems ON items.biblioitemnumber=biblioitems.biblioitemnumber
281
  LEFT JOIN biblioitems ON items.biblioitemnumber=biblioitems.biblioitemnumber
282
  WHERE issues.borrowernumber=?
282
  WHERE issues.borrowernumber=?
283
  UNION ALL
283
  UNION ALL
284
  SELECT *, old_issues.timestamp as issuestimestamp, old_issues.renewals AS renewals,items.renewals AS totalrenewals,items.timestamp AS itemstimestamp
284
  SELECT old_issues.*, items.*, biblio.*, biblioitems.*, old_issues.timestamp as issuestimestamp, old_issues.renewals AS renewals,items.renewals AS totalrenewals,items.timestamp AS itemstimestamp,borrowers.firstname,borrowers.surname
285
  FROM old_issues
285
  FROM old_issues
286
  LEFT JOIN items on items.itemnumber=old_issues.itemnumber
286
  LEFT JOIN items on items.itemnumber=old_issues.itemnumber
287
  LEFT JOIN borrowers on borrowers.borrowernumber=old_issues.issuer
287
  LEFT JOIN borrowers on borrowers.borrowernumber=old_issues.issuer
288
- 

Return to bug 23916