$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');