Antworten pro Thread:[sql]SELECT thread_id,count(thread_id) FROM table WHERE forum_id = 3 ORDER BY thread_id ORDER BY thread_id DESC LIMIT 0, 30 ;[/sql]