Django AND query

query.py

User.objects.filter(
    Q(internal_groups__id=1) &
    ~Q(
        enrollments__event__id=15,
        enrollments__pre_status=ENROLLMENT_PRE_STATUS.going,
    )
)

query.sql

SELECT *
FROM   "users_user"
       INNER JOIN "internalgroups_internalgroupuser"
               ON ( "users_user"."id" =
"internalgroups_internalgroupuser"."user_id" )
WHERE  ( "internalgroups_internalgroupuser"."internal_group_id" = 1
         AND NOT ( "users_user"."id" IN (SELECT U1."user_id"
                                         FROM   "events_enrollment" U1
                                         WHERE  U1."event_id" = 15)
                   AND "users_user"."id" IN (SELECT U1."user_id"
                                             FROM   "events_enrollment" U1
                                             WHERE  U1."pre_status" = going) ) )  

subquery.py

enrollments = Subquery(Enrollment.objects.filter(
  event__id=15, pre_status=ENROLLMENT_PRE_STATUS.going
).only('id'))

User.objects.filter(
    Q(internal_groups__id=1) &
    ~Q(enrollments__in=enrollments)
)

subquery.sql

SELECT *
FROM   "users_user"
       INNER JOIN "internalgroups_internalgroupuser"
               ON ( "users_user"."id" =
"internalgroups_internalgroupuser"."user_id" )
WHERE  ( "internalgroups_internalgroupuser"."internal_group_id" = 1
         AND NOT ( "users_user"."id" IN (
            SELECT V1."user_id"
            FROM   "events_enrollment" V1
            WHERE V1."id" IN (
                SELECT U0."id"
                FROM   "events_enrollment" U0
                WHERE  (  
                    U0."event_id" = 15
                    AND
                    U0."pre_status" = going
                ),
             ) ) ) )