select a.* , d.mb_experience_year,d.mb_name, d.mb_bz_placetitle,d.mb_bz_title,d.mb_type, e.mb_experience_year as sitter_mb_experience_year, (select icon_name from image_links where link_num=a.num order by link_serial asc limit 1) as imgicon, (select AVG(rate_val) from review_list where target_mb_no=a.mb_no and rate_val > 0 ) as review_avg, (select count(num) from review_list where target_mb_no=a.mb_no) as review_cnt from mb_pro_service as a left join rate_record_list as b on b.mb_no=a.mb_no left join g5_member_pro as d on d.mb_no=a.mb_no left join g5_member_pro as e on e.mb_no=a.mb_no where a.show_onlist=1 and show_on_myset=1 and ( service_type='요양보호/간병' and service_type_sub='병원동행' ) order by admin_point desc, d.panalty asc, rate_sell_point desc,rate_review_point desc,rate_review_sumpoint desc,rate_login_point desc,a.num desc