[nakna]

Fick till det själv, men det känns väldigt omständigt

select threads.timestamp as last_comment, threads.thread_id, count(posts.thread_id)-1 as svar, (SELECT subject FROM posts WHERE posts.thread_id = threads.thread_id order by posts.post_id Limit 1) as subject, (SELECT userid FROM posts WHERE posts.thread_id = threads.thread_id order by posts.post_id Limit 1) as u_id from threads , posts 
where threads.thread_id = posts.thread_id and forum_id = '2' 
group by threads.thread_id order by threads.timestamp desc;

Om någon ser något som går att optimera så hojta gärna till!