SELECT *, `a`.`uid` as `uid`, `a`.`code` as `code`, `b`.`uid` as `did`, `c`.`uid` as `pid`, `d`.`uid` as `sid`, `a`.`cl_type` as `cl_type`, `a`.`th` as `th`, `a`.`name` as `name`, `a`.`signdate` as `signdate`, `a`.`updatetime` as `updatetime`, `d`.`sort` as `sort4`, `e`.`code` as `cmt_code`, `e`.`name` as `cmt_name` FROM `jy_member` as `a` LEFT JOIN `jy_district` as `b` ON `a`.`cl_type` = `b`.`cl_type` and `a`.`th` = `b`.`th` and `a`.`district_code` = `b`.`district_code` LEFT JOIN `jy_party` as `c` ON `a`.`party_code` = `c`.`party_code` LEFT JOIN `jy_position` as `d` ON `a`.`cl_type` = `d`.`cl_type` and `a`.`th` = `d`.`th` and `a`.`code` = `d`.`mem_code` LEFT JOIN `jy_committee` as `e` ON `a`.`cl_type` = `e`.`cl_type` and `a`.`th` = `e`.`th` and `d`.`cmt_code` = `e`.`code` WHERE `a`.`cl_type` = 'BO' AND `a`.`th` = '8' AND `a`.`code` = '0702' ORDER BY `a`.`name` asc