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 ='the-unofficial-guide-walt-disney-world-2010-unofficial-guides-0470460261' and bookforsale.verified = 'yes' and available_quantity > 0
Book: The Unofficial Guide Walt Disney World 2010 (Unofficial Guides) By Bob Sehlinger : TheTextbooks.org