SELECT concat(p.pname,p.fname,' ',p.lname) AS ptname,vn.age_y,p.hn,i.an,
i.prediag,an.pdx,an.dx0,an.dx1,an.dx2,
an.dx3,an.dx4,an.dx5,icd.name,ic.name,
i1.name,i2.name,i3.name,i4.name,i5.name ,i.dchdate
FROM ipt i
LEFT OUTER JOIN patient p ON p.hn=i.hn
LEFT OUTER JOIN an_stat an ON an.an=i.an
LEFT OUTER JOIN vn_stat vn ON vn.vn=i.vn
LEFT OUTER JOIN opdscreen op ON op.vn=vn.vn
LEFT OUTER JOIN icd101 icd ON icd.code=an.pdx
LEFT OUTER JOIN icd101 ic ON ic.code = an.dx0
LEFT OUTER JOIN icd101 i1 ON i1.code= an.dx1
LEFT OUTER JOIN icd101 i2 ON i2.code= an.dx2
LEFT OUTER JOIN icd101 i3 ON i3.code= an.dx3
LEFT OUTER JOIN icd101 i4 ON i4.code= an.dx4
LEFT OUTER JOIN icd101 i5 ON i5.code= an.dx5
WHERE i.an='520001700'
LIMIT 1