query ดูค่าสัญญาณชีพ (vital sign) ในคนไข้ความดัน

  1. Overview
  2. HosXP
  3. Query
  4. query ดูค่าสัญญาณชีพ (vital sign) ในคนไข้ความดัน

ดูจากตาราง opdscreen

SELECT
    a.hn,
    a.vn,
    pt.pname,
    pt.fname,
    pt.lname,
    a.bps,a.bpd,
    IFNULL(pt.addrpart, '') AS 'บ้านเลขที่',
    IFNULL(pt.moopart, '') AS 'หมู่ที่',
    IFNULL(t3.name, '') AS 'ตำบล',
    IFNULL(t2.name, '') AS 'อำเภอ',
    IFNULL(t1.name, '') AS 'จังหวัด'
FROM
    opdscreen a
INNER JOIN ovstdiag dx ON dx.vn = a.vn
INNER JOIN patient pt ON pt.hn = a.hn
LEFT JOIN thaiaddress t1 ON t1.chwpart = pt.chwpart AND t1.amppart = '00' AND t1.tmbpart = '00'
LEFT JOIN thaiaddress t2 ON t2.chwpart = pt.chwpart AND t2.amppart = pt.amppart AND t2.tmbpart = '00'
LEFT JOIN thaiaddress t3 ON t3.chwpart = pt.chwpart AND t3.amppart = pt.amppart AND t3.tmbpart = pt.tmbpart
WHERE
    a.vstdate BETWEEN '2024-10-01' AND '2025-09-30'
    AND (a.bps >= 160 OR a.bpd >= 110)
    AND dx.icd10 BETWEEN 'I10' AND 'I15'
    AND a.bps < 180
    AND a.bpd < 110
 
ORDER BY t1.name, t2.name, t3.name