Test: books_by_categoryquery:SELECT distinct verified, available_quantity, book_title, longtitle, authors, publisher, edition, isbn10, SmallImage, MediumImage, Price, Shipping_cost,comments,book.slug FROM book
JOIN bookforsale ON book.isbn10 = bookforsale.isbn
WHERE book.category = 'nonfiction'
AND verified = 'yes'
AND available_quantity >=1
ORDER by book_title
LIMIT 0 , 301 returned