SELECT accounts_group.id AS accounts_group_id, accounts_group.name AS accounts_group_name, accounts_group.description AS accounts_group_description, accounts_group.is_managed AS accounts_group_is_managed, accounts_group.privacy_policy AS accounts_group_privacy_policy, accounts_group.subscription_policy AS accounts_group_subscription_policy, accounts_group.created AS accounts_group_created, accounts_group.modified AS accounts_group_modified
FROM accounts_group
WHERE accounts_group.id IN (SELECT anon_1.accounts_group_id AS anon_1_accounts_group_id
FROM (SELECT accounts_group.id AS accounts_group_id, accounts_group.name AS accounts_group_name, accounts_group.description AS accounts_group_description, accounts_group.is_managed AS accounts_group_is_managed, accounts_group.privacy_policy AS accounts_group_privacy_policy, accounts_group.subscription_policy AS accounts_group_subscription_policy, accounts_group.created AS accounts_group_created, accounts_group.modified AS accounts_group_modified
FROM accounts_group JOIN accounts_group_members ON accounts_group.id = accounts_group_members.group_id
WHERE accounts_group_members.user_id IS NULL AND accounts_group_members.state = %(state_1)s UNION SELECT accounts_group.id AS accounts_group_id, accounts_group.name AS accounts_group_name, accounts_group.description AS accounts_group_description, accounts_group.is_managed AS accounts_group_is_managed, accounts_group.privacy_policy AS accounts_group_privacy_policy, accounts_group.subscription_policy AS accounts_group_subscription_policy, accounts_group.created AS accounts_group_created, accounts_group.modified AS accounts_group_modified
FROM accounts_group JOIN accounts_group_admin ON accounts_group.id = accounts_group_admin.group_id
WHERE accounts_group_admin.admin_id IS NULL AND accounts_group_admin.admin_type = %(admin_type_1)s) AS anon_1)
Empty set