[wp-hackers] Order posts by time of their last comment

[Christian Foster]

Hi,

I have a requirement to list posts by the time of their last comment.
I am trying to keep it simple, the current page which lists by other
factors like post type uses a slightly modified pagination function
with a pre_get_posts filter to set the required query parameters, we
have tens of thousands of posts of different types so the pagination
is very important.

Can anyone think of a good way to sort a large number of posts by the
date of their last comment? Is it then possible to use the same
pagination function and posts_per_page/paged query variables?

Cheers,

Chris.