p.hn, concat(p.prename,p.name,' ',p.surname) as 'ชื่อ-สกุล'
,TRUNCATE((SELECT DATEDIFF(CONCAT((DATE_FORMAT(v.datedsc,"%Y")-543),"-",DATE_FORMAT(v.datedsc,"%m-%d")), STR_TO_DATE(p.birthdate, '%Y-%m-%d'))/365),0) as 'อายุ ณ วันวินิจฉัย'
,p.address as 'บ้านเลขที่',p.moo as 'หมู่ที่',ad.name as 'ตำบล', SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(ad.full_name,' ',2),' ',-1), '.', -1) as 'amphur',SUBSTRING_INDEX(SUBSTRING_INDEX(ad.full_name,' ',-1),'.',-1) as 'province'
..
INNER JOIN hos_pt p ON v.hn = p.hn
LEFT JOIN hos_code_thaiaddress ad on concat(p.province,p.amphur,p.tambon) =
ad.addressid