Refactor this complex ActiveRecord query to use "joins" instead of multiple "where" clauses to improve efficiency. Explain the difference between "includes", "joins", and "eager_load" in this specific scenario.