Need Query: all forums last post descending

[Hendrizius]

Which query do I have to use to show the posts in all forums sorted descending by last post?

Thanks.

[Jake Bunce]

Run these queries:



UPDATE forum
SET defaultsortorder = 'desc'




UPDATE forum
SET defaultsortfield = 'lastpost'


Then you will need to update your forum info:

Admin CP -> Maintenance -> Update Counters