SELECT DISTINCT STATUS FROM DM.CT_TRAIN_PLAN p left join (select FID,MAX(TO_CHAR(CREATETIME,'yyyy-mm')) as TSDATE FROM CT_PLAN_TSRECORD GROUP BY FID) d on d.FID = p.FID where 1=1 ${if(len(pv1) = 0,"",if(pv12=="培训时间","and p.FYEAR||'-'||p.FMONTH >='" + pv1 + "'","and d.TSDATE >='" + pv1 + "'")} ${if(len(pv1) = 0,"",if(pv12=="培训时间","and p.FYEAR||'-'||p.FMONTH <='" + pv8 + "'","and d.TSDATE <='" + pv8 + "'")}