SELECT ttf_forum.*, COUNT( * ) - COUNT( ttf_thread_new.last_view ) AS freshies ".
FROM ttf_forum
LEFT JOIN ttf_thread USING ( forum_id )
LEFT JOIN ttf_thread_new ON ( ttf_thread.thread_id = ttf_thread_new.thread_id
&& ttf_thread_new.user_id = '{$ttf["uid"]}'
&& ttf_thread.date <= ttf_thread_new.last_view )
GROUP BY ttf_forum.forum_idDaniel: dp against the lies
vote no on mark all read 2007