I tested this query in SQL and it worked perfectly for returning all of the posts and if they are liked by member:
SELECT blogposts.*, bloglikes.* FROM blogposts LEFT JOIN bloglikes ON blogposts.postId = bloglikes.postId AND blog_likes.memberId = 5
I tried refracting it for use with PHQL:
SELECT Posts.* , Likes.* FROM Posts LEFT JOIN Likes ON Posts.postId = Likes.postId AND Likes.memberId = 5
I have created the relationships already inside the models, but for some reason it won't return anything. Using the query below will actually work by returning if it is liked or not but it won't return the post.
SELECT Posts.*, Likes.likeId, Likes.memberId FROM Posts LEFT JOIN Likes ON Posts.postId = Likes.postId AND Likes.memberId = 5
The above statement returns likeId and memberId but no post information like title, body, etc. Have any assumptions to why this isn't working?