Back

SQL Details

Executed SQL
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)
Original query duration
1.1618 ms

Empty set