jepp, sollte eigentlich GROUP BY heißen...
[sql]SELECT thread_id,count(thread_id) FROM table WHERE forum_id = 3 GROUP BY thread_id ORDER BY thread_id DESC LIMIT 0, 30 ;[/sql]