SELECT a.posting_code,a.link_map,a.description,a.is_new,a.is_rush, a.time_limited, a.id,a.name,a.alias,a.image,a.city_id,a.date_use_start,a.date_use_end,a.user_id, a.is_hot,a.is_bold_color,a.is_search,a.is_auto_refresh_4,a.is_auto_refresh,a.is_new_post ,a.is_best ,a.created_time ,a.list_suicide_id,a.latitude,a.longitude,a.address , a.salaries,b.avatar as com_image,b.company_name,job.name as name_job , job_organize.name as name_organize,deg.name as name_deg,a.hits as hits,city.name as city_name, sal.name as salary_name FROM fs_products AS a LEFT JOIN fs_members_employer as b ON a.user_id = b.id LEFT JOIN fs_job_experience as job on a.experience = job.id LEFT JOIN fs_job_organize as job_organize ON a.organize = job_organize.id LEFT JOIN fs_job_degree as deg ON deg.id = a.degree_id LEFT JOIN fs_cities as city ON city.id = a.city_id LEFT JOIN fs_job_salaries as sal ON sal.id = a.salaries WHERE a.published = 1 AND a.not_search = 0 AND ( a.category_id_wrapper LIKE "%,47,%" OR a.category_id_wrapper LIKE "%,,%" OR a.category_id_wrapper LIKE "%,366,%" OR a.category_id_wrapper LIKE "%,366,%" OR a.category_id_wrapper LIKE "%,366,%" OR a.category_id_wrapper LIKE "%,366,%" OR a.category_id_wrapper LIKE "%,366,%" OR a.category_id_wrapper LIKE "%,366,%" OR a.category_id_wrapper LIKE "%,366,%" ) AND ( a.city_id = 7 ) AND ( a.wards_id = 1257 ) AND ( a.degree_id = 5 ) AND ( a.salaries = 21 ) AND (a.is_status = 5 OR a.is_status = 4 OR a.is_forever = 1) ORDER BY a.edited_time DESC,a.ordering DESC,a.id DESC

  1. Trang chủ
  2. Việc làm

Đã tìm thấy 0 công việc trong mục này

Bộ lọc

Xóa lọc
Địa điểm
Ngành nghề