基于mybatis一对多查询内层排序的问题

      select     zdt.id as title_id,zdt.title_name,     zdk.id as kpi_id,zdk.kpi_name,zdk.kpi_type,zdk.calculate_method,zdk.is_add_description,zdk.description_remind,zdk.kpi_description,     zdkd.id as kpi_dimension_id, zdkd.dimension_name,zdd.dimension_value,     zdkpd.input_description     from zhmd_diagnosis_title zdt     left join zhmd_diagnosis_kpi zdk on zdk.diagnosis_title_id = zdt.id     left join zhmd_diagnosis_kpi_dimension zdkd on zdkd.diagnosis_kpi_id = zdk.id     left join zhmd_dimension_diagnosis zdd on  zdd.dimension_id = zdkd.id and zdd.diagnosis_id = #{diagnosisId}     left join zhmd_diagnosis_kpi_problem_desc zdkpd on zdkpd.kpi_id = zdk.id and zdkpd.diagnosis_id =#{diagnosisId}     where zdt.diagnosis_model_id = #{modelId}     order by zdt.create_date desc,zdk.create_date desc,zdkd.dimension_sort asc 

ORDER BY contract.contractCount DESC, reward.rewardTotal DESC, new_job.newJobCount DESC