ภาวะโภชนาการของเด็กอายุ 0 - 5 ปี ดัชนีน้ำหนักตามเกณฑ์อายุ

คำสั่ง ภาวะโภชนาการของเด็กอายุ 0 - 5 ปี ดัชนีน้ำหนักตามเกณฑ์อายุ

SELECT p.*, Max(n.nutrition_date) nutrition_date,TimestampDiff(year, p.birthdate, n.nutrition_date) age_y,n.body_weight,n.height,n.nutri_level,n.nutrition_level
FROM (SELECT p.person_id,p.patient_hn,Concat(p.pname, p.fname, ' ', p.lname) fname,p.birthdate,p.cid,v.village_id,v.village_moo,v.village_name,Concat(h.address, ' หมู่ ',
v.village_moo, ' ', v.village_name) addr,
p.father_name,p.mother_name
FROM person p
LEFT JOIN house h ON p.house_id = h.house_id LEFT JOIN village v ON h.village_id = v.village_id
WHERE TimestampDiff(year, p.birthdate, '2025-10-01') BETWEEN 0 AND 5 AND p.house_regist_type_id IN (1, 3) AND p.nationality = 99 AND
p.person_discharge_id = 9) p
LEFT JOIN (SELECT w.person_id,n.nutrition_date,n.vn,n.body_weight,n.height,nl.nutrition_level,nl.name nutri_level
FROM person_wbc_nutrition n
INNER JOIN person_wbc w ON n.person_wbc_id = w.person_wbc_id
LEFT JOIN nutrition_level nl ON n.nutrition_level = nl.nutrition_level
WHERE n.nutrition_date BETWEEN '2025-10-01' AND '2026-12-31'
UNION
SELECT w.person_id,n.nutrition_date,n.vn,n.body_weight,n.height,nl.nutrition_level,nl.name nutri_level
FROM person_epi_nutrition n
INNER JOIN person_epi w ON n.person_epi_id = w.person_epi_id
LEFT JOIN nutrition_level nl ON n.nutrition_level = nl.nutrition_level
WHERE n.nutrition_date BETWEEN '2025-10-01' AND '2026-12-31') n ON p.person_id = n.person_id
GROUP BY p.person_id
ORDER BY p.village_id