SELECT jobs.*, accounts.location_city, accounts.name AS account_name, CONCAT(jobs.name, '-', jobs.seo_id) AS slug FROM jobs, accounts WHERE jobs.account_id = accounts.id AND (jobs.deleted = '0' AND (jobs.job_status = 'on_live' AND jobs.deadline >= '2020-10-21') OR ((jobs.job_status = 'on_live' OR jobs.job_status = 'expired') AND jobs.deadline BETWEEN DATE_SUB('2020-10-21', INTERVAL 180 DAY) AND '2020-10-21'))  AND ((jobs.name LIKE '%tuyển dụng nhân sự%' OR jobs.description LIKE '%tuyển dụng nhân sự%' OR jobs.required_experience LIKE '%tuyển dụng nhân sự%' OR jobs.page_title LIKE '%tuyển dụng nhân sự%' OR jobs.meta_keywords LIKE '%tuyển dụng nhân sự%' OR jobs.meta_description LIKE '%tuyển dụng nhân sự%')) ORDER BY jobs.order_date DESC, jobs.date_entered DESC

ALL JOBS

SEARCH YOUR DREAM JOB

We found 1 jobs

My job alert

Keyword *
Your e-mail *
Job category *
Location *
Language requirement
Salary
How often do you want to receive suitable jobs? *
Cancel
Keyword *
Your e-mail *
Job category *
Location *
How often do you want to receive suitable jobs? *

CONTACT US

Contact us if you need
more further help.