SELECT `a`.`cmt_code`, `a`.`pos_code`, `b`.`name`
FROM `jy_position` as `a`
LEFT JOIN `jy_committee` as `b` ON `a`.`cmt_code` = `b`.`code`
WHERE `a`.`th` = `b`.`th`
AND `a`.`mem_code` = '09001'
AND `a`.`half` = 'F'
AND `a`.`th` = '12'
ORDER BY `a`.`pos_code` desc, `a`.`cmt_code` asc