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

select pr.health_med_provider_id,pr.health_med_provider_full_name,concat(p.pname,p.fname,’ ‘,p.lname)as name,a.labor_date,
count(pr.health_med_provider_id and s.service_date>’5′)as nummm,s.hn,s.vn,s.service_date,
s.in_hospcode_service,d.icd10,i.health_med_operation_item_name,h.*
from health_med_service_operation h
left join health_med_service s on s.health_med_service_id=h.health_med_service_id
left join health_med_service_diagnosis d on d.health_med_service_id=h.health_med_service_id
left join person p on p.patient_hn=s.hn
left join person_anc a on a.person_id=p.person_id
left join health_med_provider pr on pr.health_med_provider_id=h.health_med_provider_id
left join health_med_operation_item i on i.health_med_operation_item_id=h.health_med_operation_item_id

where h.health_med_operation_item_id in (’33’) and s.service_date >’2014-03-08′
group by pr.health_med_provider_id,s.service_date
order by nummm desc