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

(-)a/C4/Biblio.pm (-3 / +3 lines)
Lines 899-908 sub GetBiblioFromItemNumber { Link Here
899
    my $sth;
899
    my $sth;
900
    if ($itemnumber) {
900
    if ($itemnumber) {
901
        $sth = $dbh->prepare(
901
        $sth = $dbh->prepare(
902
            "SELECT * FROM items 
902
            "SELECT items.*, biblio.*, biblioitems.*, itemtypes.notforloan as notforloan_per_itemtype FROM items
903
            LEFT JOIN biblio ON biblio.biblionumber = items.biblionumber
903
            LEFT JOIN biblio ON biblio.biblionumber = items.biblionumber
904
            LEFT JOIN biblioitems ON biblioitems.biblioitemnumber = items.biblioitemnumber
904
            LEFT JOIN biblioitems ON biblioitems.biblioitemnumber = items.biblioitemnumber
905
             WHERE items.itemnumber = ?"
905
            LEFT JOIN itemtypes ON itemtypes.itemtype = " . C4::Context->preference('item-level_itypes') ? 'items.itype' : 'biblioitems.itemtype' . "
906
            WHERE items.itemnumber = ?"
906
        );
907
        );
907
        $sth->execute($itemnumber);
908
        $sth->execute($itemnumber);
908
    } else {
909
    } else {
909
- 

Return to bug 12302