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

(-)a/C4/Items.pm (-2 / +2 lines)
Lines 908-914 sub GetLostItems { Link Here
908
    my $dbh     = C4::Context->dbh;
908
    my $dbh     = C4::Context->dbh;
909
909
910
    my $query   = "
910
    my $query   = "
911
        SELECT *
911
        SELECT title, author, lib, itemlost, authorised_value, barcode, datelastseen, price, replacementprice, homebranch,
912
               itype, itemtype, holdingbranch, location, itemnotes, items.biblionumber as biblionumber
912
        FROM   items
913
        FROM   items
913
            LEFT JOIN biblio ON (items.biblionumber = biblio.biblionumber)
914
            LEFT JOIN biblio ON (items.biblionumber = biblio.biblionumber)
914
            LEFT JOIN biblioitems ON (items.biblionumber = biblioitems.biblionumber)
915
            LEFT JOIN biblioitems ON (items.biblionumber = biblioitems.biblionumber)
915
- 

Return to bug 8329