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

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 พี่แหม่ม