SELECT DISTINCT view_data.raw_contact_id FROM view_data
WHERE view_data.raw_contact_id NOT IN (SELECT DISTINCT
view_v1_group_membership.person FROM
view_v1_group_membership) AND (view_data.account_name IS NULL AND view_data.account_type IS NULL) GROUP BY
view_data.raw_contact_id