function getNoticeIds($offset, $limit, $since_id, $max_id)
{
$reply = new Reply();
- $reply->profile_id = $this->userId;
- Notice::addWhereSinceId($reply, $since_id, 'notice_id', 'modified');
- Notice::addWhereMaxId($reply, $max_id, 'notice_id', 'modified');
+ $reply->selectAdd();
+ $reply->selectAdd('notice_id');
+
+ $reply->whereAdd(sprintf('reply.profile_id = %u', $this->userId));
+
+ Notice::addWhereSinceId($reply, $since_id, 'notice_id', 'reply.modified');
+ Notice::addWhereMaxId($reply, $max_id, 'notice_id', 'reply.modified');
if (!empty($this->selectVerbs)) {
$reply->joinAdd(array('notice_id', 'notice:id'));
$reply->whereAddIn('notice.verb', $this->selectVerbs, 'string');
}
- $reply->orderBy('modified DESC, notice_id DESC');
+ $reply->orderBy('reply.modified DESC, reply.notice_id DESC');
if (!is_null($offset)) {
$reply->limit($offset, $limit);