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

(-)a/C4/Acquisition.pm (-3 / +3 lines)
Lines 714-721 sub GetPendingOrders { Link Here
714
    my $dbh = C4::Context->dbh;
714
    my $dbh = C4::Context->dbh;
715
    my $strsth = "
715
    my $strsth = "
716
        SELECT    ".($grouped?"count(*),":"")."aqbasket.basketno,
716
        SELECT    ".($grouped?"count(*),":"")."aqbasket.basketno,
717
                    surname,firstname,aqorders.*,biblio.*,biblioitems.isbn,
717
                    surname,firstname,biblio.*,biblioitems.isbn,
718
                    aqbasket.closedate, aqbasket.creationdate, aqbasket.basketname
718
                    aqbasket.closedate, aqbasket.creationdate, aqbasket.basketname,
719
                    aqorders.*
719
        FROM      aqorders
720
        FROM      aqorders
720
        LEFT JOIN aqbasket ON aqbasket.basketno=aqorders.basketno
721
        LEFT JOIN aqbasket ON aqbasket.basketno=aqorders.basketno
721
        LEFT JOIN borrowers ON aqbasket.authorisedby=borrowers.borrowernumber
722
        LEFT JOIN borrowers ON aqbasket.authorisedby=borrowers.borrowernumber
722
- 

Return to bug 7166