select video_id,round((100*complete+5*il+3*ci+2*ir)/(clear+1),0) hot_index from (select t1.video_id, AVG(TIMESTAMPDIFF(second, start_time, end_time) >= duration) complete, datediff(date((select max(end_time) from tb_user_video_log)),max(date(end_time))) clear, sum(if_like) il, COUNT(comment_id) ci, sum(if_retweet) ir from tb_user_video_log t1 join tb_video_info t2 on t1.video_id=t2.video_id where datediff(date((select max(end_time) from tb_user_video_log)),date(end_time))<=29 group by t1.video_id ) t4 order by hot_index desc limit 3感觉已经写得一模一样了，可就是报错，最后会多筛出2002号视频