Notice: Error: Unknown column 'c.ContractSalary' in 'order clause'
Error No: 1054
SELECT ja.JobAdID , ja.JobID , ja.StartDate , ja.EndDate , ja.CompanyNM , ja.IndustryNM , ja.CompanyDescription , ja.JobTitle , ja.CareerLevelNM , ja.JobSummary , ja.FunctionNM , ja.PersonSpecification , ja.ContactInformation , ja.UpdatedBy , ja.UpdatedDate , ja.Salary , ja.notified_email , j.FunctionID , j.LocationID , l.LocationNM , jp.CareerLevelID , j.IsHot FROM job_ad ja LEFT JOIN job j ON (j.JobID = ja.JobID) LEFT JOIN location l ON (l.LocationID = j.LocationID) LEFT JOIN job_person_specification jp ON (jp.JobID = ja.JobID) WHERE ja.StartDate <= STR_TO_DATE('2024-09-11 23:59:59', '%Y-%m-%d %H:%i:%s') AND ja.EndDate >= STR_TO_DATE('2024-09-11 00:00:01', '%Y-%m-%d %H:%i:%s') ORDER BY c.ContractSalary DESC LIMIT 0,15 in /home/tiroc743/public_html/system/database/mysql.php on line 49