SELECT name, COUNT(user_id) FROM books b LEFT JOIN books_users u ON u.book_id = b.id GROUP BY 1 ORDER BY 2 ASC. You actually get some books with 0 values, ...
確定! 回上一頁