บ้านหนองโน ไม่เป็น DM,HT 15-59ปี

SELECT
    CONCAT(p.prename,p.`name`,' ',p.surname) AS 'ชื่อ-สกุล',
    p.address AS 'บ้านเลขที่',
    p.moo AS 'หมู่ที่',
    CASE
        WHEN p.sex = '1' THEN 'ชาย'
        WHEN p.sex = '2' THEN 'หญิง'
        ELSE 'ไม่ระบุ'
    END AS 'เพศ',
    DATE_FORMAT(FROM_DAYS(DATEDIFF(NOW(), p.birthdate)), '%Y') + 0 AS 'อายุ',
    p.birthdate AS 'วันเกิด',
    pttype.`name` AS 'สิทธิการรักษา'
FROM hos_pt p
LEFT JOIN hos_code_religion r ON p.religion = r.`code`
INNER JOIN hos_code_marry m ON p.marry = m.`code`
LEFT JOIN hos_code_thaiaddress ad ON CONCAT(p.province, p.amphur, p.tambon) = ad.addressid
LEFT JOIN hos_code_pttype pttype ON p.pttype = pttype.`code`
WHERE CONCAT(p.province, p.amphur, p.tambon, p.moo) = '40070111'
AND p.typearea IN ('1', '3')
AND TIMESTAMPDIFF(YEAR, p.birthdate, CURDATE()) BETWEEN 15 AND 59
AND p.cid NOT IN (
 
SELECT DISTINCT p.cid
FROM f43_chronic c
INNER JOIN hos_pt p ON c.PID = p.hn
WHERE c.TYPEDISCH = '03'
AND p.cid IS NOT null
GROUP BY p.cid
HAVING
    SUM(CASE WHEN c.CHRONIC LIKE 'E%' THEN 1 ELSE 0 END) > 0
    OR SUM(CASE WHEN c.CHRONIC LIKE 'I%' THEN 1 ELSE 0 END) > 0
)
ORDER BY p.address