@@ -, +, @@ --- C4/Biblio.pm | 5 +++-- 1 files changed, 3 insertions(+), 2 deletions(-) --- a/C4/Biblio.pm +++ a/C4/Biblio.pm @@ -899,10 +899,11 @@ sub GetBiblioFromItemNumber { my $sth; if ($itemnumber) { $sth = $dbh->prepare( - "SELECT * FROM items + "SELECT items.*, biblio.*, biblioitems.*, itemtypes.notforloan as notforloan_per_itemtype FROM items LEFT JOIN biblio ON biblio.biblionumber = items.biblionumber LEFT JOIN biblioitems ON biblioitems.biblioitemnumber = items.biblioitemnumber - WHERE items.itemnumber = ?" + LEFT JOIN itemtypes ON itemtypes.itemtype = " . C4::Context->preference('item-level_itypes') ? 'items.itype' : 'biblioitems.itemtype' . " + WHERE items.itemnumber = ?" ); $sth->execute($itemnumber); } else { --