โรงพยาบาลจอมพระ

select p.cid,pt.hn,concat(p.pname,p.fname,’ ‘,p.lname)as name,p.age_m,p.age_y,p.death,pt.chwpart,pt.amppart,pt.tmbpart,p.house_regist_type_id
from person p
left join patient pt on pt.hn=p.patient_hn
where ((age_m in(‘1′,’2′,’3′,’4′,’5′,’6′,’7′,’8′,’9′,’10’,’11’,’12’) and age_y =(‘2’))or (age_m in(‘6′,’7′,’8′,’9′,’10’,’11’,’12’) and age_y =(‘1’)) ) and
( p.house_regist_type_id in (‘1′,’3′) and p.death=’N’) and ((pt.chwpart=’32’) and (amppart=’04’))

select p.cid,pt.hn,concat(p.pname,p.fname,’ ‘,p.lname)as name,p.age_y,p.death,pt.chwpart,pt.amppart,pt.tmbpart,p.house_regist_type_id
from person p
left join patient pt on pt.hn=p.patient_hn
where (p.age_y >64 and p.house_regist_type_id in (‘1′,’3′) and p.death=’N’) and ((pt.chwpart=’32’) and (amppart=’04’))

select concat(p.pname,p.fname,’ ‘,p.lname)as name,p.chwpart,p.amppart,p.tmbpart,p.type_area,ov.*
from ovstdiag ov
left join patient p on p.hn=ov.hn

where ((ov.icd10 between ‘j42’ and ‘j459’) or (ov.icd10 between ‘I05’ and ‘I099’) or (ov.icd10 between ‘I20’ and ‘I289’) or (ov.icd10 between ‘I30’ and ‘I529’) or
(ov.icd10 between ‘I60’ and ‘I699’) or (ov.icd10 between ‘N17’ and ‘N199’) or (ov.icd10 between ‘E11’ and ‘E149’) or (ov.icd10 between ‘d50’ and ‘d649’) or
(ov.icd10 between ‘c00’ and ‘d489′) )and ((p.chwpart=’32’)and (p.amppart=’04’)) and ((p.type_area in (‘1′,’3′)))

group by ov.hn

select ov.hn,p.cid,concat(p.pname,p.fname,’ ‘,p.lname)as name,ov.vstdate,p2.age_y,p.sex,p2.village_id,concat(p.addrpart,’ ËÁÙè ‘,p.moopart,’ ‘,t.full_name)as address,ov.icd10,
i.name,i.tname
from ovstdiag ov
left join clinicmember on
left join patient p on p.hn=ov.hn
left join person p2 on p2.patient_hn=ov.hn
left join thaiaddress t on t.chwpart=p.chwpart and t.amppart=p.amppart and t.tmbpart=p.tmbpart
left join icd101 i on i.code=ov.icd10

where (ov.vstdate between ‘2013-10-01’ and ‘2014-09-31’)and ((ov.icd10 between ‘j42’ and ‘j459’) or (ov.icd10 between ‘I05’ and ‘I099’) or (ov.icd10 between ‘I20’ and ‘I289’) or (ov.icd10 between ‘I30’ and ‘I529’) or
(ov.icd10 between ‘I60’ and ‘I699’) or (ov.icd10 between ‘N17’ and ‘N199’) or (ov.icd10 between ‘E11’ and ‘E149’) or (ov.icd10 between ‘d50’ and ‘d649’) or
(ov.icd10 between ‘c00’ and ‘d489′) )and ((p.chwpart=’32’)and (p.amppart=’04’)) and ((p2.house_regist_type_id in (‘1′,’3’)))

group by ov.hn
order by p2.village_id,p.moopart