ปี พ.ศ. 2561 | ปี พ.ศ. 2562 | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
อำเภอ | B | A | ร้อยละ | ต.ค. | พ.ย. | ธ.ค. | ม.ค. | ก.พ. | มี.ค. | เม.ย. | พ.ค. | มิ.ย. | ก.ค. | ส.ค. | ก.ย. |
ไม่พบผลลัพธ์ |
Template :: HDC
B หมายถึง จำนวนเด็กที่คลอดในช่วงเวลาที่กำหนดและมีมารดาอายุ (1 - 19ปี)
A หมายถึง จำนวนเด็กแรกเกิดน้ำหนักน้อยกว่า 2500 กรัม ในช่วงเวลาที่กำหนดและมีมารดาอายุ (1 - 19ปี)
วันที่ประมวลผล :: 29/3/2567
SELECT ap.ampurcodefull as areacode,ap.ampurname as areaname,p.check_hosp,p.check_vhid
,DATE_FORMAT(now(),'%Y%m%d%H%i') as d_com
,COUNT(DISTINCT p.cid) as target
,COUNT(DISTINCT IF(n.bweight >0 AND n.bweight < 2500,p.cid,null)) as result
,COUNT(DISTINCT IF(n.bweight >0 AND n.bweight < 2500,p.cid,null))/COUNT(DISTINCT p.cid)*100 as percent
,COUNT(DISTINCT IF(DATE_FORMAT(p.birth,'%m') IN(10),p.cid,NULL)) as target10
,COUNT(DISTINCT IF(DATE_FORMAT(p.birth,'%m') IN(10) AND n.bweight >0 AND n.bweight < 2500,p.cid,null)) as result10
,COUNT(DISTINCT IF(DATE_FORMAT(p.birth,'%m') IN(11),p.cid,NULL)) as target11
,COUNT(DISTINCT IF(DATE_FORMAT(p.birth,'%m') IN(11) AND n.bweight >0 AND n.bweight < 2500,p.cid,null)) as result11
,COUNT(DISTINCT IF(DATE_FORMAT(p.birth,'%m') IN(12),p.cid,NULL)) as target12
,COUNT(DISTINCT IF(DATE_FORMAT(p.birth,'%m') IN(12) AND n.bweight >0 AND n.bweight < 2500,p.cid,null)) as result12
,COUNT(DISTINCT IF(DATE_FORMAT(p.birth,'%m') IN(1),p.cid,NULL)) as target1
,COUNT(DISTINCT IF(DATE_FORMAT(p.birth,'%m') IN(1) AND n.bweight >0 AND n.bweight < 2500,p.cid,null)) as result1
,COUNT(DISTINCT IF(DATE_FORMAT(p.birth,'%m') IN(2),p.cid,NULL)) as target2
,COUNT(DISTINCT IF(DATE_FORMAT(p.birth,'%m') IN(2) AND n.bweight >0 AND n.bweight < 2500,p.cid,null)) as result2
,COUNT(DISTINCT IF(DATE_FORMAT(p.birth,'%m') IN(3),p.cid,NULL)) as target3
,COUNT(DISTINCT IF(DATE_FORMAT(p.birth,'%m') IN(3) AND n.bweight >0 AND n.bweight < 2500,p.cid,null)) as result3
,COUNT(DISTINCT IF(DATE_FORMAT(p.birth,'%m') IN(4),p.cid,NULL)) as target4
,COUNT(DISTINCT IF(DATE_FORMAT(p.birth,'%m') IN(4) AND n.bweight >0 AND n.bweight < 2500,p.cid,null)) as result4
,COUNT(DISTINCT IF(DATE_FORMAT(p.birth,'%m') IN(5),p.cid,NULL)) as target5
,COUNT(DISTINCT IF(DATE_FORMAT(p.birth,'%m') IN(5) AND n.bweight >0 AND n.bweight < 2500,p.cid,null)) as result5
,COUNT(DISTINCT IF(DATE_FORMAT(p.birth,'%m') IN(6),p.cid,NULL)) as target6
,COUNT(DISTINCT IF(DATE_FORMAT(p.birth,'%m') IN(6) AND n.bweight >0 AND n.bweight < 2500,p.cid,null)) as result6
,COUNT(DISTINCT IF(DATE_FORMAT(p.birth,'%m') IN(7),p.cid,NULL)) as target7
,COUNT(DISTINCT IF(DATE_FORMAT(p.birth,'%m') IN(7) AND n.bweight >0 AND n.bweight < 2500,p.cid,null)) as result7
,COUNT(DISTINCT IF(DATE_FORMAT(p.birth,'%m') IN(8),p.cid,NULL)) as target8
,COUNT(DISTINCT IF(DATE_FORMAT(p.birth,'%m') IN(8) AND n.bweight >0 AND n.bweight < 2500,p.cid,null)) as result8
,COUNT(DISTINCT IF(DATE_FORMAT(p.birth,'%m') IN(9),p.cid,NULL)) as target9
,COUNT(DISTINCT IF(DATE_FORMAT(p.birth,'%m') IN(9) AND n.bweight >0 AND n.bweight < 2500,p.cid,null)) as result9
FROM
tmp_newborn n
INNER JOIN t_person_cid p ON n.cid=p.cid
LEFT JOIN chospital h ON p.check_hosp=h.hoscode
LEFT JOIN campur ap on ap.ampurcodefull=left(p.check_vhid,4)
LEFT JOIN t_person_cid pm ON pm.HOSPCODE=n.HOSPCODE AND pm.PID=n.MPID
WHERE p.check_typearea IN(1,3) AND p.DISCHARGE in(9) AND p.NATION IN(99)
AND p.birth BETWEEN :start_d AND :end_d
AND h.provcode=:changwatcode
AND pm.age_y BETWEEN :min AND :max
GROUP BY areacode
WITH ROLLUP
ค่าตัวแปร :: 2018-10-01, 2019-09-30, 83, 1, 19