[thelist] Selecting most active n blogs [php/mysql]

[Martin Kuplens-Ewart]

So...
...help needed [for feasability - yes/no answer for client]

Is there another way of doing what I'll describe below

[summarised as selecting 5 most commented-on blogs from a table]

Select all blogs
For each, grab number of comments [from separate table]
Then evaluate number of comments, rejigging position in results, until 5
with most comments have been found.

Is there a faster way of doing this?

Thanks
-m