p.hn, concat(p.prename,p.name,' ',p.surname) as 'ชื่อ-สกุล'
,TRUNCATE ((SELECT DATEDIFF(v.date_visit, 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