| LastSQL | select book.id,book.name,book.star,book_extend.main_class_id,book_extend.pic2,book_extend.pic3,book_extend.volume_num,book_extend.isdn,book_extend.book_writer AS writer_id,book_extend.price,book_extend.old_price,book_extend.introduce,book_extend.remark1,book_extend.publish_date,book_writer.name AS writer_name,book_publisher.name AS publisher_name from book,book_extend,book_writer,book_publisher,book_book_class where book.status=1 and book_book_class.class_id in (679) and book.id = book_book_class.book_id and book.id = book_extend.book_id and book_writer.id=book_extend.book_writer AND book_publisher.id= book_extend.book_publisher AND book_extend.drumbeating=0 group by book.id order by book_extend.publish_date desc |