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

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

Return to bug 23916