select
    id,
    examination_id,
    member_id,
    title,
    question_type,
    total_score,
    n,
    `level`,
    `language`,
    positions,
    examination_detail,
    is_deleted,
    CREATOR,
    CREATED_TIME,
    MODIFIER,
    MODIFIED_TIME,
    SYS_VERSION
from
    biz_examination
where is_deleted = 'N'
<< and member_id = :memberId>>
<< and LOCATE(:query,title) >>
<< and examination_id in (:examinationIds) >>
order by MODIFIED_TIME desc

