Error: select * from tbl_posted_jobs where expiry_date>='2018-07-16' and job_posting_id in (select ts_job_id from mv_ts_cs_it where find_in_set (831,category_value_ids) ) order by posted_date desc limit 0,25

Unknown column 'category_value_ids' in 'where clause'