[TECK]

i try it.. it didn't work well on wooolF's live board, but it did ok on my local one.
so you recommend me to keep the query like this?

$forums=$DB_site->query('SELECT forum.*, thread.title AS threadtitle FROM forum LEFT JOIN thread ON (thread.forumid=forum.forumid AND thread.lastpost=(forum.lastpost-forum.daysprune)) WHERE displayorder<>0 AND active=1 ORDER BY parentid,displayorder');

let me know please.

satan, it doesnt provide a link to the thread because it would add extra queries, wich is not recommended on a large board. i think the link to the latest post will do just fine. the title of the post is more informative, for the users to see what is going on in that forum.
let us know what you think.