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

select v.village_moo,v.village_name,concat(p.pname,p.fname,’ ‘,p.lname) as name,if (p.sex=1,’ªÒÂ’,’Ë­Ô§’)as sex,p.cid,p.patient_hn,p.birthdate,p.club_list,p.age_y,p.age_m,p.age_d,p.death_date,pt.clinic
from person p
left outer join village v on v.village_id=p.village_id
left outer join religion r on r.religion = p.religion
left outer join patient pt on pt.cid=p.cid
where p.age_y > 59 and p.village_id not in (‘1’) and p.death_date is null
order by v.village_name