[PieAndChips]

after a bit of fiddling about i got it working

SELECT
thread.threadid,
thread.title,
thread.lastposter,
COUNT(post.postid) AS numposts
FROM thread
INNER JOIN post ON thread.threadid = post.threadid
WHERE (UNIX_TIMESTAMP()-post.dateline) < 86400
GROUP BY thread.threadid
ORDER BY numposts DESC LIMIT 10

btw, this will give the 10 most active threads during the past 24 hours. :banana: