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

select r.vn,r.refer_date,r.refer_cause,r.refer_number,r.doctor,d.name,r.refer_point,r.department,r.refer_time,r.hn,r.pdx,r.depcode,r.spclty
from referout r
left join doctor d on d.code=r.doctor
where r.refer_date between ‘2014-10-01’ and ‘2014-10-31’ and ( r.refer_cause is null or r.refer_cause=” )

select s.name,v.vn,v.hn,v.vstdate,v.spclty,k.department,k1.department as fromDepart,o.*
from vn_stat v
left join spclty s on s.spclty=v.spclty
left join opd_regist_sendlist o on o.vn=v.vn
left join kskdepartment k on k.depcode=o.send_to_depcode
left join kskdepartment k1 on k1.depcode=o.send_from_depcode
where v.vstdate between ‘2014-10-01’ and ‘2014-10-31’ and (v.pdx is null or pdx=”)
order by opd_regist_sendlist_id desc

select concat(p.pname,p.fname,’ ‘,p.lname)as name,s.vn,s.hn,s.vstdate,s.vsttime,s.service3,s.service4,s.service11,s.service5,s.service12,s.service6,s.service7 ,
sec_to_time(time_to_sec(s.service6)-time_to_sec(s.vsttime)) as total_time

from service_time s
left outer join opitemrece o on o.hn=s.hn and o.vstdate=s.vstdate
left join person p on p.patient_hn=s.hn
where (o.icode in (‘1550241′,’1550476’)) and (s.vstdate between ‘2012-02-01’ and ‘2015-03-31′)
and s.service3 is not null and s.service6 is not null
and s.service3 >= ’08:00:00′ and s.service3 <= ’16:00:00’
and s.service6 > s.service3
and s.service6 > s.service5
order by s.vn desc

งาน Tb พี่แหม่ม

สูบบุหรี่

select o.smoking_type_id,o.hn,c.clinic,cc.name,p.house_regist_type_id,o.*
from opdscreen o
left join clinicmember c on c.hn=o.hn
left join clinic cc on cc.clinic=c.clinic
left join person p on p.patient_hn=o.hn
where o.smoking_type_id in (‘2’) and c.clinic<>” and p.house_regist_type_id in (‘1′,’3’)
group by hn

ดื่มสุรา

select o.smoking_type_id,o.hn,c.clinic,cc.name,p.house_regist_type_id,o.*
from opdscreen o
left join clinicmember c on c.hn=o.hn
left join clinic cc on cc.clinic=c.clinic
left join person p on p.patient_hn=o.hn
where o.drinking_type_id in (‘2’) and c.clinic<>” and p.house_regist_type_id in (‘1′,’3’)
group by hn