พระสงฆ์
select GROUP_CONCAT(DISTINCT d.DIAGCODE)as dxx,d.DIAGTYPE,p.TYPEAREA,p.PRENAME,p.`NAME`,p.LNAME,s.*
from service s
left join person p on (s.pid=p.pid) and (p.HOSPCODE=’10917′)
left join diagnosis_opd d on s.pid=d.pid and (d.HOSPCODE=’10917′) and (d.DIAGCODE BETWEEN ‘z00’ and ‘z108′)
where s.HOSPCODE=’10917’ and (CHIEFCOMP like ‘%ภาพพระ%’) /* and (p.TYPEAREA in (‘1′,’3’)) */
group by s.PID
order by p.PRENAME
ข้อมูลคนไข้ใน ต.จอมพระ อายุ 60ปีขึ้นไป type 1,3
SELECT p.CID,CONCAT(p.`NAME`,’ ‘,p.LNAME)as name,if(sex=1,’ชาย’,’หญิง’)as sex,
p.birth,TIMESTAMPDIFF(year,p.birth,now())as age_y,
k.a as mootee,k.ban,k.tmb,
concat(h.CHANGWAT,h.AMPUR,h.TAMBON,h.VILLAGE)as 8code,p.hospcode
from person p
left join home h on p.HOSPCODE=h.HOSPCODE and p.HID=h.HID
left join kvillage k on concat(h.CHANGWAT,h.AMPUR,h.TAMBON,h.VILLAGE)=k.`code`
where p.TYPEAREA in (1,3) and TIMESTAMPDIFF(year,p.birth,now())>=60
order by p.hospcode,k.a,h.house
ความเห็นล่าสุด