ตำบลน้ำพอง vital sign ค่าน้ำตาล

SET @startdate = '20231001';
SET @enddate = '20240931';
 
SELECT
    p.address AS 'บ้านเลขที่',
    p.moo AS 'หมู่ที่',
    ad.name AS 'ตำบล',
    SUBSTRING_INDEX(
        SUBSTRING_INDEX(
            SUBSTRING_INDEX(ad.full_name, ' ', 2),
            ' ', -1
        ),
        '.', -1
    ) AS 'อำเภอ',
    SUBSTRING_INDEX(
        SUBSTRING_INDEX(ad.full_name, ' ', -1),
        '.', -1
    ) AS 'จังหวัด',
    p.pid AS 'pid',
    p.prename AS 'คำนำหน้า',
    p.`name` AS 'ชื่อ',
    p.surname AS 'นามสกุล',
    v.begindate AS 'วันเกิด',
    v.age_yyy_mm_dd AS 'อายุ',
    z.bw AS 'น้ำหนัก',
    z.ht AS 'ส่วนสูง',
    z.waist_inch AS 'รอบเอว',
    z.sys_bp AS 'ความดันโลหิต (SYS)',
    z.dia_bp AS 'ความดันโลหิต (DIA)',
    (
        SELECT
            r.lab_result
        FROM
            hos_lab l
        INNER JOIN hos_lab_result r ON r.labnumber = l.labnumber
        WHERE
            l.hn = v.hn
        AND r.lab_code IN ('0005600')
        AND r.type_use = 'Y'
    ORDER BY r.id DESC LIMIT 1
    ) AS 'Glucose'
FROM
    hos_pt_visit v
INNER JOIN hos_pt p ON p.hn = v.hn
INNER JOIN hos_pt_visit_vitalsign z ON z.visit_code = v.visit_code
LEFT JOIN hos_code_thaiaddress ad ON CONCAT(
    p.province,
    p.amphur,
    p.tambon
) = ad.addressid
WHERE
    v.date_visit_sql BETWEEN @startdate AND @enddate
    AND TRUNCATE(
        DATEDIFF(
            CURDATE(),
            STR_TO_DATE(p.birthdate, '%Y-%m-%d')
        ) / 365,
        0
    ) >= 35
    AND ad.name = 'น้ำพอง'
    AND p.typearea IN ('1','3')
    GROUP BY p.hn