Unknown column 'job_title' in 'order clause':select *, concat( city, ', ', state ) as location, ID as id from jobs where 1 and concat( city, ', ', state ) like '%CA%' order by job_title