X-Git-Url: http://koha-dev.rot13.org:8081/gitweb/?a=blobdiff_plain;f=C4%2FAcquisition.pm;h=59cc2a59a2be98aa8e208b5cd3d7d7f5176dd238;hb=7315f1fa54a0d70172dc4fe3660748b8ff9b6db4;hp=8bd9965afb521b018e0be7d22fb0e984f33affb2;hpb=e62ffd49b05ad0e214e361150269b2a83794b0c4;p=koha_fer

diff --git a/C4/Acquisition.pm b/C4/Acquisition.pm
index 8bd9965afb..59cc2a59a2 100644
--- a/C4/Acquisition.pm
+++ b/C4/Acquisition.pm
@@ -655,12 +655,13 @@ sub GetPendingOrders {
     my $dbh = C4::Context->dbh;
     my $strsth = "
         SELECT    ".($grouped?"count(*),":"")."aqbasket.basketno,
-                    surname,firstname,aqorders.*,biblio.*,
+                    surname,firstname,aqorders.*,biblio.*,biblioitems.isbn,
                     aqbasket.closedate, aqbasket.creationdate, aqbasket.basketname
         FROM      aqorders
         LEFT JOIN aqbasket ON aqbasket.basketno=aqorders.basketno
         LEFT JOIN borrowers ON aqbasket.authorisedby=borrowers.borrowernumber
         LEFT JOIN biblio ON biblio.biblionumber=aqorders.biblionumber
+        LEFT JOIN biblioitems ON biblioitems.biblionumber=biblio.biblionumber
         WHERE booksellerid=?
             AND (quantity > quantityreceived OR quantityreceived is NULL)
             AND datecancellationprinted IS NULL