SELECT `tblEmployer_Jobpost`.`Organisation_Name`, `tblEmployer_Jobpost`.`Job_Title`, `tblEmployer_Jobpost`.`Designation`, `tblEmployer_Jobpost`.`Experience_Min`, `tblEmployer_Jobpost`.`Experience_Max`, `tblEmployer_Jobpost`.`Salary_Min`, `tblEmployer_Jobpost`.`Salary_Max`, `tblEmployer_Jobpost`.`Job_Location`, `tblEmployer_Jobpost`.`Skills`, `tblEmployer_Jobpost`.`Job_Posted_By`, `tblEmployer_Jobpost`.`Job_Posted_On`, `tblEmployer_Jobpost`.`Employer_IdFK`, fn_GetJobTypes(tblEmployer_Jobpost.Job_Type) as Job_Type, `tblEmployers`.`Emp_idPK`, `tblEmployers`.`Organisation_Name`, `tblEmployers`.`Organisation_Logo`, `tblEmployer_Jobpost`.`tblJobPost_IdPK` FROM `tblEmployer_Jobpost` JOIN `tblEmployers` ON `tblEmployer_Jobpost`.`Employer_IdFK`= `tblEmployers`.`Emp_idPK` WHERE `expaired_jobs` =0 AND `Delete_Active` = 1 AND `Job_Post_Status` = 1 AND ( `tblEmployer_Jobpost`.`Job_Title` LIKE '%college%' ESCAPE '!' OR `tblEmployer_Jobpost`.`Organisation_Name` LIKE '%college%' ESCAPE '!' OR `tblEmployer_Jobpost`.`Designation` LIKE '%college%' ESCAPE '!' OR `tblEmployer_Jobpost`.`Skills` LIKE '%college%' ESCAPE '!' ) ORDER BY `tblJobPost_IdPK` DESC LIMIT 500