select 
 rating.id as id,
 rating.years as years,
 rating.bonus as bonus,
 rating.projectWage as projectWage,
 rating.mark as mark,
 rating.description as description,
 prj.jianguan_leader as jianguanLeader,
 prj.xianchang_leader as xianchangLeader,
 prj.code as projectCode,
 prj.id as projectId,
 prj.name as projectName,
 prj.jianguan_weight as jianguanWeight,
 IF(rating.mark is null,"否","是") as isSet
 
 from t_b_project prj
 
 left join t_bus_project_rating rating on rating.projectId=prj.id
 <#if (years )?? && years ?length gt 0>
    /* years */
	and rating.years = :years
</#if>
 where 1=1 
 
order by CONVERT(prj.name USING gbk)
 