How to simplify query rails

admin.rb

class Admin < ActiveRecord::Base
  has_many :admin_domains
  has_many :domains, through: :admin_domains

end

#id, name, email

admin_domains.rb

class AdminDomain < ActiveRecord::Base
  belongs_to :domain
  belongs_to :admin
end
#id, domain_id, admin_id

domain.rb

class Domain < ActiveRecord::Base

  has_many :admin_domains
  
end

#id, name, formation

test.rb

# Need get domain.id with formation = true of email: "[email protected]"
|domains|
|id|name|formation|
|1| a | false|
|2| b | true|
|3| c | false|
  
|admin|
|id|name|email|
|1| miname | [email protected] |
|2| test| [email protected]|
|3| dev | [email protected]|
  

|admin_domains|
|id|domain_id|admin_id|
|1| 1 | 1|    # a | miname
|2| 2 | 1|    # b | miname
|3| 2 | 2|    # b | test
|4| 3 | 3|    # c | dev


Admin
.includes(:domains)
.where(email: "[email protected]")
.map { |admin| admin.domains.select{|domain| domain.formation == true} }

#result
[[#<Domain id: 2,  name: "b", formation: true>]]
  

Admin.where(email: "[email protected]").domains.where(formation: true) ??

or
Admin.where(email: "[email protected]").first.domains.where(formation: true)

Or maybe approach it from the domain end of things, something like Domain.includes(admin_domains: :admin).references(:admins).where(formation: true).where("admins.email = ?", "[email protected]")

Thinking more, this might be nicer since the join is for filtering: Domain.joins(admin_domains: :admin).where(formation: true).where("admins.email = ?", "[email protected]")

thanks you @tommotorefi works perfect ;)