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 ='-net-test-automation-recipes-a-problem-solution-approach-expert-is-voice-in-net-1590596633' and bookforsale.verified = 'yes' and available_quantity > 0
Book: .NET Test Automation Recipes: A Problem-Solution Approach (Expert's Voice in .NET) By Dr. James McCaffrey : TheTextbooks.org