id_, type_, code_, name_, parent_id_, full_id_, full_name_, has_children_, sn_, memo_, is_dele_, create_by_, create_org_id_, create_time_, update_by_, update_time_, version_, last_time_ SELECT s.id_, s.name_, s.user_type_id AS parentId FROM exam_equipment_sys s WHERE s.is_dele_ = '0' UNION ALL SELECT t.id_, t.name_, '0' AS parent_id_ FROM uc_org_job t WHERE t.is_dele_ = '0' SELECT distinct s.* FROM exam_equipment_sys s LEFT JOIN exam_pos_sys ps ON ps.sys_id_ = s.id_ WHERE s.name_ =#{name} AND ps.org_id_=#{orgId} SELECT s.* FROM exam_subject_info s LEFT JOIN exam_subject_sys ss ON ss.subject_id_ = s.id_ WHERE s.is_dele_ = '0' AND ss.major_id_ IN #{id}