id_, report_id_, subject_code_, subject_name_, subject_name_en_, sn_ SELECT rs.sn_,si.* FROM qf_subject_info si LEFT JOIN qf_report_subject rs ON rs.subject_code_ = si.code_ WHERE rs.report_id_ = #{reportId} ORDER BY rs.sn_ asc SELECT sr.*,si.type_ FROM qf_subject_relation sr LEFT JOIN qf_report_subject rs ON rs.subject_code_ = sr.sub_code_ LEFT JOIN qf_subject_info si on si.code_ = sr.sub_code_ WHERE rs.report_id_= #{reportId}