/*BDATE วันคลอด / วันสิ้นสุดการตั้งครรภ์   ผิดปกติ*/

SELECT

pa.edc,s.labor_status_name,'ไม่บันทึก'AS labor_date,p.pname,CONCAT(p.fname,SPACE(1),p.lname)AS 'MOTHER_NAME'

FROM

person_anc AS pa

INNER JOIN person AS p ON p.person_id = pa.person_id

INNER JOIN labor_status as s on s.labor_status_id = pa.labor_status_id

WHERE pa.labor_date is null and pa.labor_status_id in('2','3')

#==============

/*PPCARE วันที่ดูแลแม่ผิดปกติ */

SELECT

p.pname,concat(          p.fname,           space(1),p.lname)as 'person_name',

pa.labor_date AS 'วันสิ้นสุดการตั้งครรภ์',

pa.post_labor_service1_date AS 'ตรวจหลังคลอด1',

pa.post_labor_service2_date AS 'ตรวจหลังคลอด2',

pa.post_labor_service3_date AS 'ตรวจหลังคลอด3'

FROM

person_anc AS pa

INNER JOIN person AS p ON p.person_id = pa.person_id

INNER JOIN house AS h ON h.house_id = p.house_id

INNER JOIN village AS v ON v.village_id = h.village_id

WHERE

pa.labor_date IS NOT NULL

AND pa.post_labor_service1_date IS NULL

OR pa.post_labor_service2_date IS NULL

OR pa.post_labor_service3_date IS NULL

#==============