|
||||||||||||
|
|
| 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 |