SELECT nb napen_name as author_name countdistinct ncid as chapterCount sumncword_count as totalWords MAXnccreate_time as lastUpdateTime FROM novel_books nb LEFT JOIN novel_author na ON n

SELECT nb.*, na.pen_name AS author_name, COUNT(DISTINCT nc.id) AS chapterCount, SUM(nc.word_count) AS totalWords, MAX(nc.create_time) AS lastUpdateTime FROM novel_books nb LEFT JOIN novel_author na ON nb.author_id = na.id LEFT JOIN novel_chapter nc ON nb.id = nc.book_id;