SELECT * FROM PostEntity

JOIN ProfileEntity ON PostEntity.authorId = ProfileEntity.profileId
LEFT JOIN PostEntity AS Quote ON PostEntity.quoteId = Quote.postId
LEFT JOIN ProfileEntity AS QuoteProfile ON Quote.authorId = QuoteProfile.profileId
LEFT JOIN PostEntity AS BoostedPost ON PostEntity.boostedPostId = BoostedPost.postId
LEFT JOIN ProfileEntity AS BoostedPostProfile ON BoostedPost.authorId = BoostedPostProfile.profileId

WHERE PostEntity.authorId = :authorId || BoostedPost.authorId = :authorId
ORDER BY PostEntity.createdAt DESC;