select ccs.*,cces.* from vn_stat v left outer join clinicmember_cormobidity_screen ccs on ccs.vn=v.vn left outer join clinicmember_cormobidity_eye_screen cces on cces.clinicmember_cormobidity_screen_id=ccs.clinicmember_cormobidity_screen_id LEFT OUTER JOIN clinicmember_cormobidity_foot_screen ccfs ON ccfs.clinicmember_cormobidity_screen_id=ccs.clinicmember_cormobidity_screen_id where ccs.screen_date between "2013-04-01" and "2014-03-31" and (ccs.do_eye_screen="Y" OR ccs.do_foot_screen="Y") and cces.dmht_eye_screen_type_id="1" group by ccs.clinicmember_cormobidity_screen_id limit 1000