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

(-)a/C4/Acquisition.pm (-5 / +4 lines)
Lines 1804-1813 sub GetHistory { Link Here
1804
    my $dbh   = C4::Context->dbh;
1804
    my $dbh   = C4::Context->dbh;
1805
    my $query ="
1805
    my $query ="
1806
        SELECT
1806
        SELECT
1807
            IFNULL(biblio.title,     deletedbiblio.title)     AS title,
1807
            COALESCE(biblio.title,     deletedbiblio.title)     AS title,
1808
            IFNULL(biblio.author,    deletedbiblio.author)    AS author,
1808
            COALESCE(biblio.author,    deletedbiblio.author)    AS author,
1809
            IFNULL(biblioitems.isbn, deletedbiblioitems.isbn) AS isbn,
1809
            COALESCE(biblioitems.isbn, deletedbiblioitems.isbn) AS isbn,
1810
            IFNULL(biblioitems.ean,  deletedbiblioitems.ean)  AS ean,
1810
            COALESCE(biblioitems.ean,  deletedbiblioitems.ean)  AS ean,
1811
            aqorders.basketno,
1811
            aqorders.basketno,
1812
            aqbasket.basketname,
1812
            aqbasket.basketname,
1813
            aqbasket.basketgroupid,
1813
            aqbasket.basketgroupid,
1814
- 

Return to bug 5336