SELECT r.validation_status_id
FROM gui_users gu,
  person_role pr,
  vo_role vr,
  role r
WHERE gu.profiled_person_id = pr.person_id
AND pr.vo_role_id           = vr.vo_role_id
AND vr.role_id              = r.role_id
AND gui_user_id             = 101001;