Bug 6801: checkoverdues returns unnecessary fields, causing slowness

[koha.git] / C4 / Members.pm

diff --git a/C4/Members.pm b/C4/Members.pm
index a8fec65..f009590 100644 (file)
--- a/C4/Members.pm
+++ b/C4/Members.pm
@@ -1043,7 +1043,7 @@ sub GetPendingIssues {
     # Borrowers part of the query
     my $bquery = '';
     for (my $i = 0; $i < @borrowernumbers; $i++) {
-        $bquery .= ' borrowernumber = ?';
+        $bquery .= ' issues.borrowernumber = ?';
         if ($i < $#borrowernumbers ) {
             $bquery .= ' OR';
         }
@@ -1070,6 +1070,9 @@ sub GetPendingIssues {
            biblioitems.volumedesc,
            biblioitems.lccn,
            biblioitems.url,
+           borrowers.firstname,
+           borrowers.surname,
+           borrowers.cardnumber,
            issues.timestamp AS timestamp,
            issues.renewals  AS renewals,
            issues.borrowernumber AS borrowernumber,
@@ -1078,6 +1081,7 @@ sub GetPendingIssues {
     LEFT JOIN items       ON items.itemnumber       =      issues.itemnumber
     LEFT JOIN biblio      ON items.biblionumber     =      biblio.biblionumber
     LEFT JOIN biblioitems ON items.biblioitemnumber = biblioitems.biblioitemnumber
+    LEFT JOIN borrowers ON issues.borrowernumber = borrowers.borrowernumber
     WHERE
       $bquery
     ORDER BY issues.issuedate"