SELECT j.id,jobtitle,jobdesc,area,salarypkg,featured,
currency,views,if(clogo,photo,logo) AS logo,cname
FROM #__recmgr_jobs AS j
LEFT JOIN #__recmgr_consultants AS c ON c.id = j.consultant
WHERE published = 1
ORDER BY featured desc,j.id desc LIMIT 0,10SELECT j.id,jobtitle,jobdesc,area,salarypkg,featured,
currency,views,if(clogo,photo,logo) AS logo,cname
FROM #__recmgr_jobs AS j
LEFT JOIN #__recmgr_consultants AS c ON c.id = j.consultant
WHERE published = 1
ORDER BY featured desc,j.id desc
We found 34 jobs matching your criteria
Click on the
Details/Apply button next to each job to see the full posting.