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

select p.patient_hn,p.cid,concat(p.pname,p.fname,’ ‘,p.lname)as name,p.age_y,concat(h.address,’ M.’,vl.village_moo,’ B. ‘,vl.village_name)as address,
vs.school_name,sc.village_school_class_name,(case when sv.student_vaccine_id in (‘5’) then vsv.vaccine_date else ‘NULL’ end)as dTs4,
v.*
from village_student v
left join village_school vs on vs.village_school_id=v.village_school_id
left join village_school_class sc on sc.village_school_class_id=v.village_school_class_id
left join person p on p.person_id=v.person_id
left join house h on h.house_id=p.house_id
left join village vl on vl.village_id=p.village_id
left join village_student_vaccine vsv on vsv.village_student_id=v.village_student_id
left join village_student_vaccine_list vsvl on vsvl.village_student_vaccine_id=vsv.village_student_vaccine_id
left join student_vaccine sv on sv.student_vaccine_id=vsvl.student_vaccine_id
where sc.village_school_class_id in (‘9’)
order by vs.school_name

select vs.school_name,sc.village_school_class_name,v.*
from village_student v
left join village_school vs on vs.village_school_id=v.village_school_id
left join village_school_class sc on sc.village_school_class_id=v.village_school_class_id
where sc.village_school_class_id in (‘9’)