id_, way_type_, subject_id_, name_, type_, time_length_, total_score_, pass_score, total_person_, memo_, is_dele_, create_by_, create_org_id_, create_time_, update_by_, update_time_ SELECT b.*,s.status_,s.time_length_,s.plan_start_time_,s.pass_score_,s.plan_end_time_,s.train_model_,r.name_ as roomName FROM exam_paper_base b LEFT JOIN exam_paper_setting s on b.id_ = s.paper_id_ LEFT JOIN exam_room_info r on r.id_ = s.room_id_ ${ew.customSqlSegment} SELECT id_ as userId,account_ as account,fullname_ as userName FROM uc_user WHERE is_dele_ = '0' AND USER_TYPE_ = '2' SELECT count(b.*) FROM exam_paper_base b WHERE b.is_dele_ = '0' AND b.paper_type_ = '2' AND b.create_time_ > date_trunc( 'year', now() ) AND date_trunc( 'year', now() ) + INTERVAL '1 year' > b.create_time_ and b.subject_id_ = #{vo.subjectId} and b.end_status_ = '1' and id_ != #{vo.id}