How to make a :includes query via a belongs_to relation with conditions on each table?

Question

Ruby on Rails

There is a certain user Ivan.
You need to download all of Ivan's undeleted and unblocked comments that are left for unblocked and undeleted posts.

User
has_many :posts
has_many: comments

Post
belongs_to :user
has_many :comments
scope :active, -> { where(deleted: false, blocked: false) }

Comment
belongs_to :user
belongs_to :post
scope :active, -> { where(deleted: false, blocked: false) }

Answer 1

Comment.includes(:user, :post)
.where(posts: { deleted: false, blocked: false })
.where(comments: { deleted: false, blocked: false })
.where(users: { name: 'Ivan' })