SELECT m.id, m.name, m.residential_address1, m.residential_address2, m.residential_address3, m.residential_address4, m.professional_address, m.email_address, m.Image, d.Designation, m.mobile_number FROM t_01_branch_member AS bm INNER JOIN add_branch AS b ON b.id = bm.Branch_ID INNER JOIN t_01_designation as d ON bm.Designation_ID = d.Designation_ID INNER JOIN members AS m ON m.id = bm.Member_ID WHERE(b.id='29') AND(bm.flag='0') ORDER BY bm.SequenceNo members found