<select id="getQuestionsByIds" resultMap="get-questions-inids">
select q.que_id,
q.lib_id,
q.que_code,
q.type_code,
q.base_code,
q.diff_code,
q.knowledge_id,
q.ability_code,
q.create_user,
q.create_time,
q.is_big_text,
q.secret,
q.parent_id,
q.que_version,
q.casual,
q.choise,
q.answer,
q.clob_casual,
q.clob_choise,
q.clob_answer,
q.score,
q.answer_time,
q.source_code,
q.source_code sourceName,
q.use_count,
q.is_approved,
q.is_avail,
q.start_time,
q.end_time,
q.byinfor,
q.update_time,
q.update_user,
ql.lib_name lib_name,
qt.type_name type_name,
pack_exam.get_qk_name(q.que_id) qk_name,
qd.diff_name diff_name,
qa.ability_name ability_name,
cb.name exam_wh_id_str
from questions q left join question_library ql on ql.lib_id = q.lib_id left join question_type qt on qt.type_code = q.type_code left join question_difficulty qd
on qd.diff_code = q.diff_code left join question_ability qa on qa.ability_code = q.ability_code left join course_bank cb on cb.id = q.exam_wh_id
where que_id in
<iterate conjunction="," open="(" close=")">
#[]#
</iterate>
</select>
select q.que_id,
q.lib_id,
q.que_code,
q.type_code,
q.base_code,
q.diff_code,
q.knowledge_id,
q.ability_code,
q.create_user,
q.create_time,
q.is_big_text,
q.secret,
q.parent_id,
q.que_version,
q.casual,
q.choise,
q.answer,
q.clob_casual,
q.clob_choise,
q.clob_answer,
q.score,
q.answer_time,
q.source_code,
q.source_code sourceName,
q.use_count,
q.is_approved,
q.is_avail,
q.start_time,
q.end_time,
q.byinfor,
q.update_time,
q.update_user,
ql.lib_name lib_name,
qt.type_name type_name,
pack_exam.get_qk_name(q.que_id) qk_name,
qd.diff_name diff_name,
qa.ability_name ability_name,
cb.name exam_wh_id_str
from questions q left join question_library ql on ql.lib_id = q.lib_id left join question_type qt on qt.type_code = q.type_code left join question_difficulty qd
on qd.diff_code = q.diff_code left join question_ability qa on qa.ability_code = q.ability_code left join course_bank cb on cb.id = q.exam_wh_id
where que_id in
<iterate conjunction="," open="(" close=")">
#[]#
</iterate>
</select>