select ipt.*,concat(spclty.name,' - ',w.name) as sname,iptadm.bedno,iptadm.bedtype,roomno.name as roomname,
iptadm.roomno,iptdiag.icd10,concat(iptdiag.icd10,' - ',i1.name) as icdname,
concat(patient.pname,patient.fname,' ',patient.lname) as pname,aa.income as income,
ptt.pcode as rtcode,ptt.name as rtname,dt.name as admdoctor_name ,
ft.name as finance_status_name,aa.admdate,aa.age_y,aa.age_m,aa.age_d,aa.paid_money ,
aa.rcpt_money,fs.finance_status  , dc1.name as dchtype_name,dc2.name as dchstts_name,
aa.paid_money-aa.rcpt_money as wait_paid_money,aa.rcpt_money as ipt_rcpt_money,di.name as incharge_doctor_name ,
if(ipt.dw_hhc_list_id>0,'Y','N') as hhc_send_status
 from ipt  left outer join spclty on spclty.spclty=ipt.spclty
 left outer join iptadm on iptadm.an=ipt.an
 left outer join patient on patient.hn=ipt.hn
 left outer join doctor dt on dt.code = ipt.admdoctor
 left outer join roomno on roomno.roomno=iptadm.roomno
 left outer join iptdiag on iptdiag.an=ipt.an and iptdiag.diagtype='1'
 left outer join icd101 i1 on i1.code=substring(iptdiag.icd10,1,3)
 left outer join an_stat aa on aa.an=ipt.an
 left outer join ward w on w.ward = ipt.ward
 left outer join dchtype dc1 on dc1.dchtype = ipt.dchtype
 left outer join dchstts dc2 on dc2.dchstts = ipt.dchstts
 left outer join ipt_finance_status fs on fs.an = ipt.an
 left outer join finance_status ft on ft.finance_status = fs.finance_status
 left outer join doctor di on di.code = ipt.incharge_doctor
 left outer join pttype ptt on ptt.pttype=ipt.pttype
 where  ipt.ward = '01'   and ipt.dchstts is null order by ipt.regdate,ipt.regtime