$sql = 'SELECT t.id, t.poster, t.subject, t.posted, t.last_post, t.last_post_id, t.last_poster, t.num_views, t.num_replies, t.closed, t.sticky, t.moved_to,g.color as last_poster_color FROM '.$db->prefix.'topics as t INNER JOIN '.$db->prefix.'users AS u ON u.username=t.last_poster LEFT JOIN '.$db->prefix.'groups AS g ON u.group_id=g.g_id WHERE forum_id='.$id.' ORDER BY sticky DESC, '.(($cur_forum['sort_by'] == '1') ? 'posted' : 'last_post').' DESC LIMIT '.$start_from.', '.$pun_user['disp_topics'];