SELECT vr.role_id, r.name, s.str_value
FROM vo_role vr, ROLE r, vehicle_owner vo, str s
WHERE vr.vehicle_owner_id=vo.vehicle_owner_id
AND vr.role_id=r.role_id
AND vo.vehicle_owner_id = 100658
AND r.name_str_id=s.str_id
AND s.LANGUAGE = (SELECT LANGUAGE FROM gui_users WHERE GUI_USER_ID = 101787);