async def METHOD_NAME(
    connection: Connection, email: str
) -> List[AccountDB]:
    """
    Since email are stored in different tables :
        (manager / professional / orientation_manager)
    And since there is no unicity constraint across multiple table we could have
    multiple results given a single email (ex: one for pro and one for
    orientation_manager)
    """
    return await get_accounts_with_query(
        connection,
        """
        LEFT JOIN admin_cdb ON admin_cdb.id = account.admin_id
        LEFT JOIN manager ON manager.id = account.manager_id
        LEFT JOIN professional ON professional.id = account.professional_id
        LEFT JOIN admin_structure ON admin_structure.id = account.admin_structure_id
        LEFT JOIN orientation_manager ON orientation_manager.id = account.orientation_manager_id
        LEFT JOIN beneficiary ON beneficiary.id = account.beneficiary_id
        WHERE manager.email like $1
        OR beneficiary.email like $1
        OR professional.email like $1
        OR admin_structure.email like $1
        OR orientation_manager.email like $1
        OR admin_cdb.email like $1
        """,  # noqa: E501
        email,
    )