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_id
Daniel: dp against the lies
vote no on mark all read 2007