恐らく、下記のようなSQL文でご希望のデータを取得することはできるかと思います。「`courseid` = 5」の部分はコースによって値を変えてください (例 `courseid` = 10)。
SELECT cs.shortname AS 'Course Shortname',cs.fullname AS 'Course Fullname',usr.username AS 'UserName',usr.lastname AS 'LastName',usr.firstname AS 'FirstName',bk.name AS 'Book TItle',bc.title AS 'Capter',from_unixtime(lsl.timecreated) AS 'Time Read'
FROM `mdl_logstore_standard_log` AS lsl
LEFT OUTER JOIN mdl_course cs ON (lsl.courseid = cs.id)
LEFT OUTER JOIN mdl_user usr ON (lsl.userid = usr.id)
LEFT OUTER JOIN mdl_book_chapters bc ON (lsl.objectid = bc.id)
LEFT OUTER JOIN mdl_book bk ON (bc.bookid = bk.id)
WHERE `objecttable` = 'book_chapters' AND `action` = 'viewed' AND `courseid` = 5
GROUP BY courseid,userid,objectid
ORDER BY courseid,userid,objectid ASC;