select b.saved_time,a.point_type,b.value,a.point_name,a.point_namec from "public"."clean_config" a left join "public"."raw_data_5minute" b on a.point_name=b.opc_idwhere b.saved_time>='${start}'::date and b.saved_time<'${DATEDELTA(end,1)}' and a.building='${comboBox1C}'and a.floor='${comboBox2C}'and a.area='${comboBox3C}'and a.point_type='${comboBox4C}'and a.point_name in ('${comboBox5C}') and b.value!=0and a.ver='ph1'order by a.point_namec ,a.point_namec,b.saved_time