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(); }