$result = dbquery("SELECT tt.*, tf.*, tu.*

      FROM ".DB_THREADS." tt

      INNER JOIN ".DB_FORUMS." tf ON tf.forum_id=tt.forum_id

      INNER JOIN ".DB_USERS." tu ON tu.user_id = tf.forum_lastuser

      WHERE ".groupaccess('forum_access')." GROUP BY tt.thread_id ORDER BY thread_lastpost DESC LIMIT 10");

$data2 = dbarray(dbquery("SELECT post_message FROM ".DB_POSTS." WHERE thread_id='".$data['thread_id']."' ORDER BY post_datestamp DESC LIMIT 1"));