column "posts.postid" must appear in the GROUP BY clause or be used in an aggregate function code example
Example: postgresql must appear in the group by clause or be used in an aggregate function
Try using "DISTINCT" instead of "GROUP BY"
Try using "DISTINCT" instead of "GROUP BY"