EXPLAIN ANALYZE SELECT ss.service_id FROM service.service AS ss JOIN account.account AS a ON (ss.account_id = a.parent_account_id) WHERE NOT EXISTS (SELECT subservice_id FROM service.combination JOIN service.service using (service_id) WHERE account_id = a.account_id AND subservice_id = ss.service_id) AND (account_id_exposed_to IS NULL OR account_id_exposed_to = a.account_id) AND a.account_id = 8219;