获取 不在当前设置录入状态,但是曾经设定过的测量指标 的最后测量日期
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 为传入参数