구인정보

select distinct wr_parent from g5_write_job where 1 = 1 and goods_status_admin = 1 and goods_status = 1 and goods_date >= '2025-07-07 17:14:03' and ( store_city_code = '296-308-475' or store_city_code like '296-308-475-%' or store_city_code like '296-308-475|%' or store_city_code like '%|296-308-475' or store_city_code like '%|296-308-475-%' or store_city_code like '%|296-308-475|%' ) and ( store_cate like '%카운터실장%' or ebiz_search_text like '%카운터실장%' ) and ( job_career >= 10 and job_career <= 1000) and (wr_num between -3984 and (-3984 + 100000)) order by result_date desc limit 0, 20