SELECT distinct IFNULL(user.user_id,0) user_id, bookforsale.book_id,bookforsale.book_city,bookforsale.college_id,bookforsale.book_condition,shipping_cost, available_quantity, book_title,authors,publisher,binding,PublicationDate,no_of_pages,isbn10,isbn13,course_number, course_title,edition, bookforsale.state,available_date,seller_email,price,comments,nick,college.name, book.LargeImage from bookforsale INNER JOIN book on bookforsale.isbn = book.isbn10 LEFT JOIN college ON bookforsale.college_id = college.college_id LEFT JOIN course on bookforsale.course_id = course.course_id
LEFT JOIN user ON seller_email = user.email where book.slug ='student-solutions-manual-to-accompany-technical-mathematics-6th-edition-and-technical-mathematics-with-calculus-047053494X' and bookforsale.verified = 'yes' and available_quantity > 0 Book: Student Solutions Manual to accompany Technical Mathematics 6th Edition and Technical Mathematics with Calculus By Paul A. Calter : TheTextbooks.org
