$user = $this->user;
$notices = array();
- $notice = DB_DataObject::factory('notice');
+ $notice = new Notice();
- # FIXME: bad performance
+ # XXX: bad performance
- $notice->whereAdd('EXISTS (SELECT user.id from user where user.id = notice.profile_id)');
+ $notice->is_local = 1;
- $notice->orderBy('created DESC');
+ $notice->orderBy('created DESC, notice.id DESC');
if ($limit != 0) {
$notice->limit(0, $limit);