Select *, (select main_cate_name from contents_main_category, contents_category_keph01 where contents_main_category.main_cate_id = contents_category_keph01.main_cate_id AND contents_category_keph01.content_sort = contents_main_category.content_sort and contents_category_keph01.goods_id = contents_mast_keph01.goods_id and contents_category_keph01.main_cate_id='A5') as main_cate_name, (SELECT long_description FROM contents_abstract_keph01 WHERE contents_abstract_keph01.goods_id = contents_mast_keph01.goods_id) AS short_description, (select comname from ex_company where comcode = contents_mast_keph01.comcode) as comname, (SELECT COUNT(*) FROM contents_reserve_keph01 WHERE contents_reserve_keph01.goods_id = contents_mast_keph01.goods_id and state = '0') as use_reserve_cnt from contents_mast_keph01 where use_yn = 'Y' AND contents_mast_keph01.goods_id in (select goods_id from contents_category_keph01 where contents_category_keph01.main_cate_id='A5') order by lending_cnt desc, reserve_cnt desc, content_title ASC, reg_ymd desc LIMIT 0, 9