Most Viewed Posts

I'm looking for a script that creates a list of the most viewed posts across all blogs on my site. I know this has been asked for many times before, but there still seems to be no good solution to what seems to be an easy problem to solve for someone with a good knowledge of php (not me!).

Given that the Post Indexer script has a table for post_hits can someone write a simple script that pulls the data from the site_posts table and order it by post_hits?

If this has already been done I apologise - I have used the search function but found nothing relevant.