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

select concat(p.pname,p.fname,’ ‘,p.lname)as name,t.full_name,c.hn,c.screen_date,c.vn,concat(p.chwpart,p.amppart,p.tmbpart)as tbb,c.*
from clinicmember_cormobidity_screen c
left join clinicmember_cormobidity_eye_screen c2 on c2.clinicmember_cormobidity_screen_id=c.clinicmember_cormobidity_screen_id
left join patient p on p.hn=c.hn
left join thaiaddress t on t.chwpart=p.chwpart and t.amppart=p.amppart and t.tmbpart=p.tmbpart
where (c.screen_date between ‘2013-10-01’ and ‘2014-05-31′) and (c.do_eye_screen=’Y’)
group by c.hn
order by c.screen_date,full_name

select concat(p.pname,p.fname,’ ‘,p.lname)as name,t.full_name,c.hn,c.screen_date,c.vn,concat(p.chwpart,p.amppart,p.tmbpart)as tbb,c2.*
from clinicmember_cormobidity_screen c
left join clinicmember_cormobidity_foot_screen c2 on c2.clinicmember_cormobidity_screen_id=c.clinicmember_cormobidity_screen_id
left join patient p on p.hn=c.hn
left join thaiaddress t on t.chwpart=p.chwpart and t.amppart=p.amppart and t.tmbpart=p.tmbpart
where (c.screen_date between ‘2013-10-01’ and ‘2014-05-31′) and (p.chwpart=’32’ and p.amppart=’04’ and p.tmbpart=’01’)
group by c.hn
order by c.screen_date

select c.*
from clinicmember_cormobidity_screen c
join patient p on p.hn=c.hn
join pttype t on t.pttype=p.pttype
join vn_stat s on s.vn=c.vn

where (c.screen_date between ‘2013-10-01’ and ‘2014-06-30′)
and (c.do_foot_screen =’Y’)
and (t.hipdata_code=’UCS’)
group by c.hn

select c.*
from clinicmember_cormobidity_screen c
join patient p on p.hn=c.hn
join pttype t on t.pttype=p.pttype
join vn_stat s on s.vn=c.vn

where (c.screen_date between ‘2013-10-01’ and ‘2014-06-30′)
and (c.do_eye_screen =’Y’)
and (t.hipdata_code=’UCS’)
group by c.hn

select concat(p.pname,p.fname,’ ‘,p.lname)as name,t.pcode,o.vn,o.icd10,o.hn,o.vstdate,o.vsttime,o.diagtype
from clinicmember c
left join ovstdiag o on o.hn=c.hn
left join person p on p.patient_hn=c.hn
left join pttype t on t.pttype=p.pttype

where (o.icd10 between ‘e110’ and ‘e118′) and (t.pcode=’uc’) and (o.vstdate between ‘2013-10-01’ and ‘2014-05-31’)

group by o.hn
order by o.vstdate