An inner join quietly drops kian and arash because they have no posts. Often those missing rows are the whole point: inactive users, posts nobody liked, players who never scored.