SELECT
  profile.LAST_MODIFIED_DATE,
  profile.name,
  country.name AS CountryName,
  etc...
 
FROM
  Administrator.PROFILE profile
  LEFT OUTER JOIN Administrator.PROFILE_STATE profileState ON profile.STATE_ID = PROFILE_STATE.LIST_ID
  LEFT OUTER JOIN Administrator.GENDER gender ON profile.GENDER_ID = gender.LIST_ID
  LEFT OUTER JOIN Administrator.COUNTRY_LIST country ON profile.COUNTRY_ID = country.LIST_ID

WHERE
  profile.LAST_MODIFIED_DATE > :LastModifiedDate -- '2017-01-03 20:12:14.395000000'
  AND (
    profile.STATE_ID =1
    OR profile.STATE_ID BETWEEN 4 AND 13
  )