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

select h2.service_date, h2.hn, h1.health_med_operation_item_id, h1.health_med_provider_id, h1.service_price,
h3.icode,concat(vn.pdx,” “,vn.dx0,” “,vn.dx1,” “,vn.dx2,” “,vn.dx3,” “,vn.dx4,” “,vn.dx5)as diage,
pt.pttype,pt.pname,pt.fname,pt.lname,vn.age_y,h3.health_med_operation_item_name,op.cc,
concat(h5.health_med_provider_pname,h5.health_med_provider_fname,” “,h5.health_med_provider_lname) as dname
from health_med_service_operation h1
left outer join health_med_service h2 on h2.health_med_service_id=h1.health_med_service_id
left outer join vn_stat vn on vn.vn=h2.vn
left outer join patient pt on pt.hn=h2.hn
left outer join opdscreen op on op.vn=h2.vn
left outer join health_med_operation_item h3 on h3.health_med_operation_item_id=h1.health_med_operation_item_id
left outer join health_med_service_operation h4 on h4.health_med_service_id=h2.health_med_service_id
left outer join health_med_provider h5 on h5.health_med_provider_id=h4.health_med_provider_id
where h2.service_date between ‘2013-06-01’ and ‘2013-06-30′ and h4.health_med_provider_id not in(5)
and (h3.health_med_operation_item_code in (’11’,’13’,’00’,’20’))
group by h2.vn order by h5.health_med_provider_id

select h2.service_date, h2.hn, h1.health_med_operation_item_id, h1.health_med_provider_id, h1.service_price,
h3.icode,concat(vn.pdx,” “,vn.dx0,” “,vn.dx1,” “,vn.dx2,” “,vn.dx3,” “,vn.dx4,” “,vn.dx5)as diage,
pt.pttype,pt.pname,pt.fname,pt.lname,vn.age_y,h3.health_med_operation_item_name,op.cc,
concat(h5.health_med_provider_pname,h5.health_med_provider_fname,” “,h5.health_med_provider_lname) as dname
from health_med_service_operation h1
left outer join health_med_service h2 on h2.health_med_service_id=h1.health_med_service_id
left outer join vn_stat vn on vn.vn=h2.vn
left outer join patient pt on pt.hn=h2.hn
left outer join opdscreen op on op.vn=h2.vn
left outer join health_med_operation_item h3 on h3.health_med_operation_item_id=h1.health_med_operation_item_id
left outer join health_med_service_operation h4 on h4.health_med_service_id=h2.health_med_service_id
left outer join health_med_provider h5 on h5.health_med_provider_id=h4.health_med_provider_id
where h2.service_date between ‘2013-06-01’ and ‘2013-06-30′ and h4.health_med_provider_id not in(5)
and (h3.health_med_operation_item_code in (’12’))
group by h2.vn order by h5.health_med_provider_id

select o.hn,v.cid,p.pname,p.fname,p.lname,p.birthday,concat(v.age_y,’.’,v.age_m)as age,v.vstdate,o.egfr

from opdscreen o
left join vn_stat v on v.hn=o.hn
left join patient p on p.hn=v.hn
where o.egfr is not null and o.hn in (‘ xxxx’,’xxxx’)
group by o.hn