if ($feed_type == "topics") {
$order = "TOPIC_CREATED_TIME desc";
$t1clause .= " and t1.USER_ID = t3.USER_ID";
} else {
$order = "TOPIC_LAST_REPLY_TIME desc";
$t1clause .= " and t2.USER_ID = t3.USER_ID";
} if (!$feed_include_body) {
$query = "
select t1.TOPIC_ID,t1.TOPIC_SUBJECT,t1.TOPIC_CREATED_TIME,t1.TOPIC_LAST_REPLY_TIME,t1.TOPIC_LAST_POST_ID,t1.TOPIC_LAST_POSTER_ID,t1.TOPIC_LAST_POSTER_NAME,t3.USER_DISPLAY_NAME
from {$config['TABLE_PREFIX']}TOPICS as t1,
{$config['TABLE_PREFIX']}POSTS as t2,
{$config['TABLE_PREFIX']}USERS as t3
where TOPIC_IS_APPROVED = '1'
$t1clause
ORDER BY t1.$order
limit $feed_items
";
} else {
$query = "
select t1.TOPIC_ID,t1.TOPIC_SUBJECT,t1.TOPIC_CREATED_TIME,t1.TOPIC_LAST_REPLY_TIME,t1.TOPIC_LAST_POST_ID,t1.TOPIC_LAST_POSTER_ID,t1.TOPIC_LAST_POSTER_NAME,t2.POST_DEFAULT_BODY,t3.USER_DISPLAY_NAME
from {$config['TABLE_PREFIX']}TOPICS as t1,
{$config['TABLE_PREFIX']}POSTS as t2,
{$config['TABLE_PREFIX']}USERS as t3
where t1.TOPIC_LAST_POST_ID = t2.POST_ID
$t1clause
and t2.POST_IS_APPROVED = '1'
ORDER BY t1.$order
limit $feed_items
";
}