select distinct wr_parent from g5_write_career where 1 = 1 and ( store_city_code = '1-6-527' or store_city_code like '1-6-527-%' or store_city_code like '1-6-527|%' or store_city_code like '%|1-6-527' or store_city_code like '%|1-6-527-%' or store_city_code like '%|1-6-527|%' ) and ( store_cate like '%피부관리%' or ebiz_search_text like '%피부관리%' ) and ( job_career >= 5 and job_career <= 10) and goods_status_admin = 1 and goods_status = 1 and (wr_num between -4537 and (-4537 + 1000000)) order by CASE WHEN goods_date > now() THEN 0 else 1 end asc, result_date desc limit 0, 30