select video.videoadi, hits.hit from video inner join hits on (hits.video_id=video.id) order by desc limit 10