A Database Error Occurred
Error Number: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND hrss_jobs.job_id !=190 AND hrss_jobs.job_status = 'A' AND hrss_jobs.job_clos' at line 7
SELECT `hrss_jobs`.`job_id`, `hrss_jobs`.`job_code`, `hrss_jobs`.`recruiter_id`, `hrss_jobs`.`job_title`, `hrss_jobs`.`job_vacancies`, `hrss_jobs`.`category_id`, `hrss_jobs`.`qualification_id`, `hrss_jobs`.`job_qualification`, `hrss_jobs`.`job_minexp`, `hrss_jobs`.`job_maxexp`, `hrss_jobs`.`job_location`, `hrss_jobs`.`country_id`, DATE_FORMAT(hrss_jobs.job_closingdate, ("%d %b %y")) AS job_closingdate, `hrss_jobs`.`job_description`, `hrss_jobs`.`job_status`, DATE_FORMAT(hrss_jobs.added_date, ("%d %b %y"))AS added_date, `hrss_jobs`.`updated_date`, `hrss_country`.`country_name`, `hrss_recruiter`.`recruiter_companyname`, `hrss_recruiter`.`recruiter_address`, `hrss_recruiter`.`recruiter_city`, `hc`.`country_name` as recruitercountry, `hrss_recruiter`.`recruiter_phone`, `hrss_recruiter`.`recruiter_mobile`, `hrss_user`.`user_email`, `hrss_recruiter`.`recruiter_code`, `hrss_jobs`.`job_process`, `hrss_jobs`.`job_type`, `job_package` FROM (`hrss_jobs`) JOIN `hrss_recruiter` ON `hrss_jobs`.`recruiter_id` = `hrss_recruiter`.`recruiter_id` JOIN `hrss_country` ON `hrss_jobs`.`country_id` = `hrss_country`.`country_id` JOIN `hrss_country` as hc ON `hc`.`country_id` = `hrss_recruiter`.`country_id` JOIN `hrss_user` ON `hrss_user`.`user_id` = `hrss_recruiter`.`recruiter_id` WHERE `hrss_jobs`.`recruiter_id` = AND hrss_jobs.job_id !=190 AND hrss_jobs.job_status = 'A' AND hrss_jobs.job_closingdate >= NOW() GROUP BY `hrss_jobs`.`job_id` ORDER BY `hrss_jobs`.`added_date` DESC