I'm trying to figure out, how I can limit my leftJoin match by 1, but keep getting the other rows from the table.
This is my code:
$comments = $this->modelsManager->createBuilder() ->columns(array('PostsComments.comment', 'PostsCommentsAnswers.comment as answer')) ->from('PostsComments') ->leftJoin('PostsCommentsAnswers', 'PostsCommentsAnswers.commentid = PostsComments.id') ->orderBy('PostsComments.id') ->limit(4) ->getQuery() ->execute();
How do i do, it will only get the first like this: "commentid = PostsComment.id limit 1" so that all others will be ignored ? :-)