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 ='experiments-in-electric-circuits-0135097282' and bookforsale.verified = 'yes' and available_quantity > 0
Book: Experiments in Electric Circuits By Thomas L. Floyd : TheTextbooks.org