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 = 'misc' AND verified = 'yes' AND available_quantity >=1 ORDER by book_title LIMIT 0 , 3010 returned

10 items found in misc

Grid View Detail View