구인정보

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:22:48' and ( store_city_code = '296-300-390' or store_city_code like '296-300-390-%' or store_city_code like '296-300-390|%' or store_city_code like '%|296-300-390' or store_city_code like '%|296-300-390-%' or store_city_code like '%|296-300-390|%' ) and ( store_cate like '%카운터%' or ebiz_search_text like '%카운터%' ) and ( job_career >= 1 and job_career <= 3) and (wr_num between -3984 and (-3984 + 100000)) order by result_date desc limit 0, 20