Find Job

Home Job Search
can not select tbl_userExpression #9 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'sitycare_db.om.Payment_Type' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SELECT j.Job_Post_Id,j.Job_Title,j.User_Id,j.Job_Description,j.Where_Do_Uou_Need_Care,j.Pay_Rate_Min,j.Pay_Rate_Max,j.Job_Time,om.Payment_Type ,tuc.First_Name,tuc.User_Id,tuc.Last_Name FROM tbl_careseeker_job_post AS j LEFT JOIN tbl_user AS tuc ON tuc.User_Id = j.User_Id LEFT JOIN tbl_order_master as om on om.User_Id = j.User_Id WHERE (tuc.User_Type = '2' OR tuc.User_Type = '3') AND DATE_FORMAT(j.End_Job_Date,'%Y-%m-%d %H:%i' ) >= '2021-10-18 11:43' AND j.Job_Post_Id NOT IN (SELECT Job_Id FROM tbl_apply_job WHERE Status IN (3,5)) GROUP BY j.Job_Post_Id ORDER BY j.Job_Post_Id DESC LIMIT 0,20