SELECT
substr(house.villcode,7,2) as moo,
house.hno,
person.pid,
person.idcard,
ctitle.titlename,
person.fname,
person.lname,
cid.`อายุ`
FROM
person
LEFT JOIN cid ON person.idcard = cid.cid2
INNER JOIN house ON person.pcucodeperson = house.pcucode AND person.hcode = house.hcode
LEFT JOIN ctitle ON ctitle.titlecode = person.prename
WHERE
cid.cid2 IS NOT NULL AND
LENGTH(cid.cid2) = 13 AND
cid.`ตำบล` = 'หนองหัวช้าง' AND
cid.`หมู่` IN ('1','2','5','8','9','12')
ORDER BY
house.villcode ASC
