select
    id,
    `position`,
    name,
    file_url,
    current_position,
    core_skills,
    education_level,
    education_background,
    education_experience,
    gender_and_age,
    occupational_history,
    other,
    work_experience,
    work_location,
    label,
    evaluate,
    matched_degree,
    member_id,
    is_deleted,
    CREATOR,
    CREATED_TIME,
    MODIFIER,
    MODIFIED_TIME,
    SYS_VERSION
from
    biz_human_resource_resume
where is_deleted = 'N'
<< and id in (:ids) >>
<< and member_id = :memberId >>
<< and `position` = :positionId >>
order by created_time desc