select year(lh.order_date),month(lh.order_date),lh.doctor_code ,lo.lab_items_code,l.lab_items_name,d.name,count(distinct lh.vn) as cc from lab_head lh
left outer join lab_order lo on lo.lab_order_number=lh.lab_order_number
left outer join lab_items l on l.lab_items_code=lo.lab_items_code
left outer join doctor d on d.code=lh.doctor_code
where lh.order_date between"2013-10-01" and "2014-09-31" and lo.lab_items_code in ("210","265") and d.position_id="1"
group by year(lh.order_date),month(lh.order_date),lh.doctor_code,lo.lab_items_code
order by year(lh.order_date) desc