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