select u1.video_id from uploader_video_record u1 join ( select uploader_id,avg(video_duration) avg_duration from uploader_video_record u2 group by uploader_id having avg(video_duration)>300 ) u3 on u1.uploader_id=u3.uploader_id order by avg_duration desc,u1.video_id asc limit 2,4;