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

select c.hn,concat(p.pname,p.fname,’ ‘,p.lname)as name,v.village_name,concat(pt.addrpart,’ ËÁÙè·Õè ‘,pt.moopart,’ ‘,t.full_name)as address,p.cid,
p.age_y,p.house_regist_type_id,c.clinic,n.name,c.regdate
from clinicmember c
left join person p on p.patient_hn=c.hn
left join patient pt on pt.hn=c.hn
left join village v on v.village_id=p.village_id
left join thaiaddress t on t.chwpart=pt.chwpart and t.amppart=pt.amppart and t.tmbpart=pt.tmbpart
left join clinic n on n.clinic=c.clinic
where c.regdate > ‘2013-10-01’ and (p.village_id not in (‘1’))
order by v.village_id

select concat(p.pname,p.fname,’ ‘,p.lname)as name,p.cid,p.patient_hn,p.house_regist_type_id,p.village_id,v.village_moo,v.village_name,p.last_update,p.death,p.age_y,
if(p.sex=’1′,’ชาย’,’หญิง’)as sex

from person p
left join village v on v.village_id=p.village_id
where p.house_regist_type_id in (‘4’) and p.village_id not in (‘1’)
order by v.village_moo