QUERY select `ms`.`series_id`, `ms`.`series_code`, `ms`.`name`, `ms`.`genres`, `ms`.`author`, `ms`.`rank`, `mc`.`no`, `ms`.`last_updated` from `manga_series` as `ms` left join `manga_chapters` as `mc` on `ms`.`last_chapter_id` = `mc`.`chapter_id` where `ms`.`is_online` = ? and `mc`.`is_online` = ? and `ms`.`author` like ? order by `ms`.`views` desc limit 20 offset 0 BINDINGS 1|1|%Lu Ye Qian He% TIME 541.57