id_, paper_id_, user_id_, user_name_, ip_, start_time_, end_time_, answer_time_, sys_score_, user_score_, total_score_, mark_user_, mark_time_, status_, create_by_, create_org_id_, create_time_, update_by_, update_time_ SELECT q.*,d.* FROM exam_user_record_detail d LEFT JOIN exam_questions_info q on q.id_ = d.question_id_ WHERE d.record_id_ = #{vo.recordId} order by rand() SELECT user_id_,user_name_,position_id_,account_ FROM exam_user_record where paper_id_ = #{paperId} SELECT b.time_length_, b.exam_type_, b.push_result_, b.pass_socre_ as passSocre, s.*, b.total_score_ as totalScore, b.name_ AS paperName, b.total_number_, b.start_date_ as startDate, b.end_date_ AS endDate, b.reveal_status_ as revealStatus FROM exam_user_record s LEFT JOIN exam_paper_base b ON b.id_ = s.paper_id_ LEFT JOIN uc_org_user ou on ou.user_id_ = s.user_id_ ${ew.customSqlSegment} GROUP BY s.id_ SELECT * FROM ( SELECT avg(r.user_score_) as userScore, r.paper_id_, b.total_score_, b.pass_socre_, b.name_ AS paperName, ou.org_id_, o.name_ AS orgName FROM exam_user_record r LEFT JOIN exam_paper_base b ON b.id_ = r.paper_id_ LEFT JOIN uc_org_user ou ON ou.user_id_ = r.user_id_ LEFT JOIN uc_org o ON o.id_ = ou.org_id_ GROUP BY ou.org_id_, r.paper_id_ ORDER BY userScore ) s ${ew.customSqlSegment} SELECT IFNULL(count(*), 0) AS passPaperCount FROM exam_user_record r LEFT JOIN exam_paper_base b ON b.id_ = r.paper_id_ WHERE r.user_score_ >= b.pass_socre_ AND r.user_id_ = #{userId} SELECT s.user_id_ AS userId FROM exam_user_record s LEFT JOIN exam_paper_base b ON b.id_ = s.paper_id_ WHERE b.subject_type_ = '1' AND b.IS_DELE_ = '0' AND s.user_id_ IN #{userId} GROUP BY s.user_id_