X-Git-Url: http://koha-dev.rot13.org:8081/gitweb/?a=blobdiff_plain;f=circ%2Fpendingreserves.pl;h=f601659383a58963fa897c5b372d58d50a81a844;hb=3732e8dcb2899ff446aa9ec4e427dde544b79edb;hp=e9cee0c2298dca4a9f02f8c4b012a95103e7b046;hpb=27a4149625252e4c28dc97df998d82fd6f2652b8;p=koha-ffzg.git

diff --git a/circ/pendingreserves.pl b/circ/pendingreserves.pl
index e9cee0c229..f601659383 100755
--- a/circ/pendingreserves.pl
+++ b/circ/pendingreserves.pl
@@ -122,12 +122,14 @@ if ( $run_report ) {
             biblio.title,
             biblio.author,
             count(DISTINCT items.itemnumber) as icount,
-            count(DISTINCT reserves.borrowernumber) as rcount
+            count(DISTINCT reserves.borrowernumber) as rcount,
+            CONCAT_WS(' ', borrowers.firstname, borrowers.surname) as l_patron
     FROM  reserves
         LEFT JOIN items ON items.biblionumber=reserves.biblionumber 
         LEFT JOIN biblio ON reserves.biblionumber=biblio.biblionumber
         LEFT JOIN branchtransfers ON items.itemnumber=branchtransfers.itemnumber
         LEFT JOIN issues ON items.itemnumber=issues.itemnumber
+        LEFT JOIN borrowers ON reserves.borrowernumber=borrowers.borrowernumber
     WHERE
     reserves.found IS NULL
     $sqldatewhere