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 = 'medical'
AND verified = 'yes'
AND available_quantity >=1
ORDER by book_id desc
LIMIT 0 , 300 returned