General Help & Suggestions

KPI Percentage Of Target Production MTD Billing MTD Billing YTD Activity Percentage
0% 0%
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:Tuesday, May 28, 2024 at 2:38:29 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/ at line 503
/home/recruit/domains/ at line 465
/home/recruit/domains/ at line 447