optimized list queries

This addon is aimed at large forum with tens of thousands to hundreds of thousands or more threads in a single forum. Smaller forum do not gain much benefit from this add-on. Forum/conversation lists: MySQL implements 'early row lookup', when combined with LIMIT & OFFSET with a large offset...