public function getPostsWithVotes($postId = false)
{
$sql = 'SELECT p.*, pr.usersId as editorId,
(SELECT SUM(v.positive) FROM vote v WHERE p.id = v.objectId AND v.object = ?) AS positive,
(SELECT SUM(v.negative) FROM vote v WHERE p.id = v.objectId AND v.object = ?) AS negative
FROM postsReply p
LEFT JOIN postsReplyHistory pr ON p.id = pr.postsReplyId
WHERE p.postsId= ? AND p.deleted = 0
GROUP BY p.id
ORDER BY p.id DESC';
$postsReply = new PostsReply();
$params = [Vote::OBJECT_POSTS_REPLY, Vote::OBJECT_POSTS_REPLY, $postId ? $postId : $this->getId()];
$pdoResult = $postsReply->getReadConnection()->query($sql, $params);
return (new Resultset(null, $postsReply, $pdoResult))->toArray();
}
