select ov.*,substring(concat(oost.name,' [',sp.department,']'),1,150) as ovstname, odx.icd10 as icdcode, vk.vn as lock_vn,pt.birthtime, substring(icd1.name,1,100) as icdname, concat(odx.icd10,' ',ix.name) as pdxname ,pt.birthday, pty.pcode, st.name as ovstist_name, concat(pt.pname,' ',pt.fname,' ',pt.lname) as ptname, oapp.nextdate as ndate,vt.age_y,vt.age_m,vt.age_d , vt.cid,c.complete,vt.pttype_in_region,vt.inc_drug,vt.count_in_day+1 as count_in_day , od.rw ,ovq.pttype_check,ovq.promote_visit,rc.bill_amount