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

select r.hn,concat(p.pname,p.fname,’ ‘,p.lname) as ptname, r.*,
o.vstdate,o.vsttime,t.name as pttype_name
from rcpt_arrear r
left outer join ovst o on o.vn=r.vn
left outer join patient p on p.hn=r.hn
left outer join pttype t on t.pttype = o.pttype
where r.arrear_date between ‘2015-09-01’ and ‘2015-09-30’
and r.paid in (‘Y’,’N’)
order by r.arrear_id

select count(*),o.icode,d.name
from opitemrece o
left join drugitems d on d.icode=o.icode
where o.vstdate between ‘2014-10-01’ and ‘2015-09-30’ and (o.icode not like ‘30%’)
group by o.icode
order by count(*) desc
limit 10

ผู้ป่วยนอก————————————————————————————————–

select count(*),v.pdx,tname,name
from vn_stat v
left join icd101 i on i.code=v.pdx
where v.vstdate between ‘2014-10-01’ and ‘2015-09-30’
group by v.pdx
order by count(*) desc
limit 10

ผู้ป่วยใน—————————————————————————————————-

select count(*),v.pdx,tname,name
from an_stat v
left join icd101 i on i.code=v.pdx
where v.dchdate between ‘2014-10-01’ and ‘2015-09-30’ and (v.pdx is not null or v.pdx<>”)
group by v.pdx
order by count(*) desc
limit 11