ประชากรเขตศูนย์เวชฯ น้ำหนักมากกว่า 100 กก.

SELECT
 
DISTINCT p.cid
,vt.bw
 
FROM hos_pt_visit v
INNER JOIN hos_pt p ON v.hn = p.hn
INNER JOIN hos_pt_visit_vitalsign vt ON v.visit_code = vt.visit_code
INNER JOIN hos_code_thaiaddress t ON CONCAT(
    p.province,
    p.amphur,
    p.tambon
) = t.addressid
WHERE v.date_visit_sql BETWEEN '20231001' AND '20240930'
AND t.addressid = '400701'
AND p.moo IN (1,3,4,5,6,7,8,9,10,11,12,14,15,16,17)
AND vt.bw between 100 and 200

SELECT
 
DISTINCT p.cid,p.hn
,d.icd10
,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.birthdate,p.tel
,p.address as 'บ้านเลขที่',p.moo as 'หมู่ที่',t.name as 'ตำบล', SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(t.full_name,' ',2),' ',-1), '.', -1) as 'amphur',SUBSTRING_INDEX(SUBSTRING_INDEX(t.full_name,' ',-1),'.',-1) as 'province'
 
FROM hos_pt_visit v
INNER JOIN hos_pt p ON v.hn = p.hn
INNER JOIN hos_doctor_diagnosis d ON v.visit_code = d.visit_code
INNER JOIN hos_code_thaiaddress t ON CONCAT(
    p.province,
    p.amphur,
    p.tambon
) = t.addressid
WHERE v.date_visit_sql BETWEEN '20231001' AND '20240930'
AND t.addressid = '400701'
AND p.moo IN (1,3,4,5,6,7,8,9,10,11,12,14,15,16,17)
AND d.icd10 BETWEEN 'J440' and 'J449'
AND d.dxtype = '1'