concat(ctitle.titlename,person.fname ,' ',person.lname) AS pname,

DATE_FORMAT(DATE_ADD(person.birth, INTERVAL 543 YEAR),'%d-%m-%Y') as birth,

getAgeYearNum(person.birth,NOW()) age,

person.hnomoi,SUBSTR(house.villcode ,7,2) moo,

DATE_FORMAT(DATE_ADD(v.dateserv, INTERVAL 543 YEAR),'%d-%m-%Y')'Datechk',v.ppspecial

FROM

person LEFT JOIN f43specialpp v on person.pid = v.pid and v.ppspecial in ('1B0046') and v.dateserv BETWEEN '20201001' and '20250930'

INNER JOIN ctitle on person.prename = ctitle.titlecode

INNER JOIN house ON person.hcode = house.hcode

WHERE

person.typelive in ('1','3') AND getAgeYearNum(person.birth,NOW()) BETWEEN 30 and 60

and person.dischargetype = '9' and person.sex ='2'

GROUP BY person.idcard

ORDER BY house.villcode,person.hnomoi