Page 2 - Count

very nice diagram

try this --
Code:

select T.title
, T.message
, ( select count(title_id)
from forum_subject
where title_id = T.title_id ) as Topics
, ( select count(title_id)
from forum_message
where title_id = T.title_id ) as Posts
, P.by_id as Last_post_by
, P.message_sdate as Last_post_date
from forum_title as T
left outer
join forum_message as P
on P.title_id = T.title_id
and P.message_sdate =
( select max(message_sdate)
from forum_message
where title_id = T.title_id )