Navigation
Error displaying the error page: Could not connect to MySQL.: SQL=SELECT job.id AS jobid,job.params,job.title,job.created,CONCAT(job.alias,'-',job.id) AS jobaliasid,job.noofjobs,job.isgoldjob,job.isfeaturedjob,job.jobapplylink,job.joblink,
cat.cat_title,company.id AS companyid,company.name AS companyname,company.logofilename, CONCAT(company.alias,'-',company.id) AS companyaliasid,
rstart.rangestart,rend.rangeend,srtype.title AS rangetype, job.hits, jobtype.title AS jobtypetitle,currency.symbol
FROM `#__js_job_jobs` AS job
JOIN `#__js_job_companies` AS company ON company.id = job.companyid
LEFT JOIN `#__js_job_categories` AS cat ON cat.id = job.jobcategory
LEFT JOIN `#__js_job_salaryrange` AS rstart ON rstart.id = job.salaryrangefrom
LEFT JOIN `#__js_job_salaryrange` AS rend ON rend.id = job.salaryrangeto
LEFT JOIN `#__js_job_salaryrangetypes` AS srtype ON srtype.id = job.salaryrangetype
LEFT JOIN `#__js_job_jobtypes` AS jobtype ON jobtype.id = job.jobtype
LEFT JOIN `#__js_job_currencies` AS currency ON currency.id = job.currencyid
LEFT JOIN `#__js_job_jobcities` AS jobcity ON jobcity.jobid = job.id
LEFT JOIN `#__js_job_cities` AS city ON city.id = jobcity.cityid AND jobcity.jobid = job.id
WHERE DATE(job.startpublishing) <= '2024-03-29' AND DATE(job.stoppublishing) >= '2024-03-29'
AND job.status = 1 AND ( job.city LIKE '%54836%' ) ORDER BY job.created DESC LIMIT 0, 20