SELECT count(A.job_id) AS jid from job_mst AS A inner join company_mast B on A.job_companyid=B.company_id where A.onoffline_mode='1' and A.job_exiredate>=CURDATE() AND A.job_locationid IN (saudi-arabia) Database error : 1054 -Please Contact your Software Support