[FFMG]

Originally Posted by Xenon

the fastest way is to get for example the last 3 times xx post, and then while running through the results, store the threadids in an array and if a new result is there, which has a threadid already cached throw it away...

Sorry, I have been away for a while.

Wouldn't GROUP BY work in this case?

SELECT *
FROM post
INNER JOIN thread
USING ( threadid )
GROUP BY (
post.threadid
)
ORDER BY post.dateline DESC
LIMIT xx

FFMG