sub CheckReserves { my ( $item, $barcode ) = @_; my $dbh = C4::Context->dbh; my $sth; my $select = " SELECT items.biblionumber, items.biblioitemnumber, itemtypes.notforloan, items.notforloan AS itemnotforloan, items.itemnumber FROM items LEFT JOIN biblioitems ON items.biblioitemnumber = biblioitems.biblioitemnumber "; #ejb2011 - logic is wrong here - if itemlevel itypes should join on itype not biblio item.type if (C4::Context->preference('item-level_itypes')) { $select .= " LEFT JOIN itemtypes ON items.itype = itemtypes.itemtype"; } else { $select .= " LEFT JOIN itemtypes ON biblioitems.itemtype = itemtypes.itemtype"; } }