SELECT SLS_GROUP , SLS_GROUP_TYPE , DESCRIPTION , DATE_ENABLED , DATE_DISABLED , DATE_REMOVED , DATE_SECURITY_APPLIED FROM IGI_SLS_GROUPS_AUDIT AU WHERE AU.DATE_REMOVED IS NOT NULL AND AU.DATE_REMOVED = (SELECT MAX(A1.DATE_REMOVED) FROM IGI_SLS_GROUPS_AUDIT A1 WHERE A1.DATE_REMOVED IS NOT NULL AND A1.SLS_GROUP = AU.SLS_GROUP AND A1.SLS_GROUP_TYPE = AU.SLS_GROUP_TYPE) AND NOT EXISTS (SELECT 'X' FROM IGI_SLS_GROUPS G WHERE G.SLS_GROUP = AU.SLS_GROUP)