Hibernate:
    /* select
        generatedAlias0
    from
        User as generatedAlias0
    left join
        generatedAlias0.friends as generatedAlias1
    left join
        generatedAlias0.friendRequests as generatedAlias2
    where
        (
            (
                generatedAlias1 not in (
                    :param0
                )
            )
            and (
                generatedAlias2 not in (
                    :param1
                )
            )
        )
        and (
            generatedAlias0.id<>:param2
        ) */ SELECT
            user0_.id AS id1_0_,
            user0_.created_by_id AS created14_0_,
            user0_.created_date AS created_2_0_,
            user0_.last_modified_by_id AS last_mo15_0_,
            user0_.last_modified_date AS last_mod3_0_,
            user0_.version AS version4_0_,
            user0_.credentials_updated_millis AS credenti5_0_,
            user0_.email AS email6_0_,
            user0_.new_email AS new_emai7_0_,
            user0_.password AS password8_0_,
            user0_.birthday AS birthday9_0_,
            user0_.city_id AS city_id16_0_,
            user0_.gender AS gender10_0_,
            user0_.name AS name11_0_,
            user0_.profile_filled AS profile12_0_,
            user0_.skill AS skill13_0_
        FROM
            app_user user0_
        LEFT OUTER JOIN
            user_friends friends1_
                ON user0_.id=friends1_.user_id
        LEFT OUTER JOIN
            app_user user2_
                ON friends1_.friend_id=user2_.id
        LEFT OUTER JOIN
            user_invites friendrequ3_
                ON user0_.id=friendrequ3_.user_id
        LEFT OUTER JOIN
            app_user user4_
                ON friendrequ3_.invite_id=user4_.id
        WHERE
            (
                user2_.id NOT IN  (
                    ?
                )
            )
            AND (
                user4_.id NOT IN  (
                    ?
                )
            )
            AND user0_.id<>?