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

DELETE FROM phpgw_fud_thread_view WHERE forum_id=2
		     17 Query       INSERT INTO phpgw_fud_thread_view (thread_id,forum_id,page,tmp) SELECT phpgw_fud_thread.id, phpgw_fud_thread.forum_id, 2147483645, CASE WHEN thread_opt>=2 AND (phpgw_fud_msg.post_stamp+phpgw_fud_thread.orderexpiry>1141905447 OR phpgw_fud_thread.orderexpiry=0) THEN 4294967294 ELSE phpgw_fud_thread.last_post_date END AS sort_order_fld  FROM phpgw_fud_thread INNER JOIN phpgw_fud_msg ON phpgw_fud_thread.root_msg_id=phpgw_fud_msg.id WHERE forum_id=2 AND phpgw_fud_msg.apr=1 ORDER BY sort_order_fld DESC, phpgw_fud_thread.last_post_id DESC
		     17 Query       UPDATE phpgw_fud_thread_view SET page=CEILING(pos/40), pos=pos-(CEILING(pos/40)-1)*40 WHERE forum_id=2
		     17 Query       UPDATE phpgw_fud_forum SET post_count=post_count+1, thread_count=thread_count+1, last_post_id=31 WHERE id=2