SELECT b.title, b.author, b.publisher, b.classno, b.bookno, b.accno, b.date, b.isbn, b.year, b.pages, b.location, b.reference, t.id AS trans_id FROM tbltransaction t INNER JOIN books b ON t.accno = b.accno WHERE b.subject1 NOT LIKE '%textbooks%' ORDER BY t.id DESC LIMIT 50;

These books are back in the stack and available for borrowing