|
|
Database Error | |
---|---|
Message: | MySQL Error has occured |
MySQL Error: | You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'by job.rowid ORDER BY job.job_spec_title ASC LIMIT 0, 200' at line 1 |
Date: | Saturday, December 21, 2024 at 5:12:42 PM |
Query: | SELECT job.*,cons.AgencyID,cons.ConsultantID, short.ClientsID FROM Jobspecs job LEFT JOIN trcandidate_shortlist short ON job.rowid = short.jobSpecID LEFT JOIN trconsultant cons ON job.job_spec_consultant= cons.ConsultantID OR job.job_spec_consultant2 = cons.ConsultantID where short.jobSpecID is not null AND job.rowid > 0 AND job.share_jobs = 1group by job.rowid ORDER BY job.job_spec_title ASC LIMIT 0, 200 |
Trace: | /home/recruit/domains/careervault.co.za/public_html/Consultant_cms.php at line 503 /home/recruit/domains/careervault.co.za/public_html/developer/class.database.php at line 465 /home/recruit/domains/careervault.co.za/public_html/developer/class.database.php at line 447 |