query = """
    select from_user_id, to_user_id from account_relationships ar
    where from_user_id in $1
    and to_user_id in $2
    and state in('avoid','block')
    """

    results = Ecto.Adapters.SQL.query!(Repo, query, [player_ids, player_ids])

    select from_user_id, to_user_id from account_relationships ar
    where from_user_id = ANY($1)
    and to_user_id = ANY($2)
    and state in('avoid','block')

player_ids = [1, 2]
from(ar in "account_relationships",
  select: [:from_user_id, :to_user_id],
  where:
    ar.from_user_id in ^player_ids and ar.to_user_id in ^player_ids and
      ar.state in ^[:avoid, :block]
)
|> Repo.all()