id_, way_, type_, question_, right_option_, parsing_, basis_, memo_, sn_, is_dele_, create_by_, create_org_id_, create_time_, update_by_, update_time_ SELECT q.* FROM exam_paper_question pq LEFT JOIN exam_questions_info q ON q.id_ = pq.question_id_ WHERE pq.paper_id_=#{paperId} SELECT q.* FROM exam_questions_info q WHERE q.type_ = #{questionType} and q.topic_id_ = #{topicId} and q.subject_id_ in #{subjectId} and q.is_dele_ ='0' ORDER BY RAND() LIMIT #{number} SELECT * FROM ( SELECT DISTINCT q.*, s.name_ AS subjectName FROM exam_questions_info q LEFT JOIN exam_subject_info s ON s.id_ = q.subject_id_ ) s ${ew.customSqlSegment} SELECT y.*, s.id_, s.name_ AS NAME FROM exam_freshman_subject s INNER JOIN ( SELECT q.subject_id_, q.type_, min( q.score_ ) AS score, count(*) AS count FROM exam_questions_info q WHERE q.subject_id_ IN #{subjectId} AND q.is_dele_ = '0' GROUP BY q.type_, q.subject_id_ ORDER BY q.type_ DESC ) y ON y.subject_id_ = s.id_ UNION ALL SELECT y.*, s.id_, s.name_ AS name FROM exam_subject_info s inner JOIN ( SELECT q.subject_id_, q.type_, min(q.score_) as score, count(*) AS count FROM exam_questions_info q WHERE q.subject_id_ IN #{subjectId} and q.is_dele_ ='0' GROUP BY q.type_, q.subject_id_ ORDER BY q.type_ desc ) y ON y.subject_id_ = s.id_ SELECT y.*, s.id_, s.topic_name_ as name FROM biz_special_topic s inner JOIN ( SELECT q.topic_id_, q.type_, min(q.score_) as score, count(*) AS count FROM exam_questions_info q WHERE q.topic_id_ = #{topicId} and q.is_dele_ ='0' and q.questionBank_type_='1' GROUP BY q.type_, q.topic_id_ ORDER BY q.type_ desc ) y ON y.topic_id_ = s.id_ SELECT y.* FROM exam_freshman_subject s INNER JOIN ( SELECT q.subject_id_ as id, q.type_, sum( q.score_ ) AS totalScore, count(*) AS count FROM exam_questions_info q WHERE q.subject_id_ IN ( SELECT s.id_ FROM exam_freshman_subject s INNER JOIN exam_subject_pos sp ON sp.subject_id_ = s.id_ WHERE sp.org_id_ = #{orgId} AND ISNULL( sp.position_id_ ) AND sp.type_ = '2' ) AND q.is_dele_ = '0' GROUP BY q.type_, q.subject_id_ ORDER BY count DESC ) y ON y.id = s.id_;