{PHP_FILE: input: all.php.t; output: all.php;}

	$r = uq('SELECT
			t.views, t.tdescr, t.moved_to, t.thread_opt, t.root_msg_id, r.last_view,
			m.subject, m.length, m.reply_to, m.poll_id, m.attach_cnt, m.icon, m.poster_id, m.post_stamp, m.thread_id, m.id,
			u.alias
//		FROM {SQL_TABLE_PREFIX}tv_'.$frm->id.' tv

		FROM {SQL_TABLE_PREFIX}tv_*  tv

		INNER JOIN {SQL_TABLE_PREFIX}thread t ON tv.thread_id=t.id
		INNER JOIN {SQL_TABLE_PREFIX}msg m ON t.id=m.thread_id AND m.apr=1
		LEFT JOIN {SQL_TABLE_PREFIX}users u ON m.poster_id=u.id
		LEFT JOIN {SQL_TABLE_PREFIX}read r ON t.id=r.thread_id AND r.user_id='._uid.'
		WHERE tv.seq BETWEEN '.($lwi - ($cur_frm_page * $THREADS_PER_PAGE) + 1).' AND '.($lwi - (($cur_frm_page - 1) * $THREADS_PER_PAGE)).'
		ORDER BY tv.seq DESC, m.id');

...forum/index.php?t=all&frm_id=*&S=680c6a4dc9fb6e3dccd92731b25e441e