Viewing all posts (not topics) in a forum.

[Axe]

Okies, I figured out the first bit...

select post.threadid, post.postid, post.title, post.dateline as postdate, thread.dateline as threaddate from post, thread where post.threadid=thread.threadid && thread.forumid="40" order by threaddate desc, postdate asc;

Which gives me all the posts in a particular forum area.

The results are first sorted by the date of the thread (most recent first), then by the date of the posts (oldest first).

Now, how can I limit this to threads that were started within the last 30 days? (bear in mind, that there could be a post in the last 30 days which is on a 2 year old thread, and I don't want that to show).