Pulling a specific number of threads from each forum.. can it be done in one query?

[djnoz]

What I need to do, is write a query that pulls the latest 4 threadids out of a specified list of forumids individually.

So basically, if I was specifying forumids 1 and 2, the query would display two lists of the four latest threadids from those forums.

The output at the mysql console would look something like this

Forumid	|Threadid
1	|12
1	|11
1	|9
1	|7

2	|13
2	|10
2	|8
2	|6

Is this possible, or must I run multiple queries?

Thanks