/** * Find private message topics * * @static * @param Model_User $user * @param integer $offset * @param integer $limit * @return Model_Forum_Private_Topic[] */ public static function find_topics(Model_User $user, $offset = 0, $limit = 10) { $topic = new Model_Forum_Private_Topic(); return $topic->load(DB::select_array($topic->fields())->join('forum_private_recipients')->on('forum_private_topics.id', '=', 'forum_private_recipients.forum_topic_id')->where('user_id', '=', $user->id)->order_by('last_post_id', 'DESC')->offset($offset), $limit); }