获取 不在当前设置录入状态，但是曾经设定过的测量指标 的最后测量日期

  select c.name, a.measure_item_code, max(measure_time) from measure_rec a left join measure_item c on a.measure_item_code = c.measure_item_code
   where a.measure_item_code in 
(
select measure_item_code  from measure_plan where end_time is not null and  patient_id=1  and measure_item_code not in  
    ( select measure_item_code from measure_plan where end_time is  null and  patient_id=1)
   
    group by measure_item_code
)
and a.patient_id=1

group by measure_item_code
    --patient_id 为传入参数