SELECT
		m.attach_cnt, m.poll_id, m.subject, m.icon, m.post_stamp,
		u.alias, u.id,
		u2.id, u2.alias,
		m2.id, m2.post_stamp,
		f.id, f.name,
		t.id, t.moved_to, t.root_msg_id, t.replies, t.rating, t.thread_opt, t.views,
		r.last_view
		FROM phpgw_fud_thread_view tv
			INNER JOIN phpgw_fud_thread	t	ON tv.thread_id=t.id
			INNER JOIN phpgw_fud_msg	m	ON t.root_msg_id=m.id
			INNER JOIN phpgw_fud_msg	m2	ON m2.id=t.last_post_id
			LEFT JOIN phpgw_fud_users	u	ON u.id=m.poster_id
			LEFT JOIN phpgw_fud_users	u2	ON u2.id=m2.poster_id
			LEFT JOIN phpgw_fud_forum	f	ON f.id=t.moved_to
			LEFT JOIN phpgw_fud_read 	r	ON t.id=r.thread_id AND r.user_id=2
			WHERE tv.forum_id=2 AND tv.page=1 ORDER BY tv.pos ASC