New Arrivals - Newarrivals

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, COUNT(i.accno) AS issued_count FROM books b LEFT JOIN tblissue i ON b.accno = i.accno WHERE b.subject1 NOT LIKE '%textbooks%' GROUP BY b.accno ORDER BY b.slid DESC LIMIT 50