Contact us
Login
ALL JOBS
- Home Recruitment Search result
We found 0 jobs
- HOME
-
JOB-SEEKER
-
CLIENTS
-
ABOUT VIECLAMBANK
Language:
JOB-SEEKER
CLIENTS
ABOUT VIECLAMBANK
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 >= '2021-10-29') OR ((jobs.job_status = 'on_live' OR jobs.job_status = 'expired') AND jobs.deadline BETWEEN DATE_SUB('2021-10-29', INTERVAL 180 DAY) AND '2021-10-29')) AND ((jobs.assigned_user_id = 'c42dd7cf-0241-b771-0aa2-59253c1ddfa8')) ORDER BY jobs.order_date DESC, jobs.date_entered DESC
We found 0 jobs
Contact us if you need
more further help.