|
 |
|
|
|
SELECT b.id, b.dmid, b.title, b.author, b.cover_img_url, b.description, p.tc_name as publisher FROM (book b JOIN book_category bc ON b.id=bc.book_id) JOIN publisher p ON b.publisher_id=p.id WHERE status='enable' AND bc.category_id=1 ORDER BY RAND() LIMIT 10 Got error 28 from storage engine |