select x.* ,y.priority_name,concat(p.pname,p.fname,' ',p.lname) as ptname,t.name as pttype_name
from xray_head x
left outer join patient p on p.hn = x.hn
left outer join pttype t on t.pttype = x.pttype
left outer join xray_priority y on y.xray_priority_id = x.xray_priority_id
where (x.order_date_time between '2007-09-03 00:00:00'  and '2007-09-03 23:59:59' ) and x.age_y between "0" and "12"
and (x.confirm_all='N')  order by x.order_date_time