1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'demo1ski_skilldemo.j.job_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

SELECT j.job_id, j.job_title, j.job_salary, j.job_location,j.job_short_description,j.inserted, r.recruiter_company_name,job_country_id,r.recruiter_logo,j.recruiter_id FROM jobs as j inner join recruiter_login rl on j.recruiter_id=rl.recruiter_id inner join recruiter r on rl.recruiter_id=r.recruiter_id WHERE rl.recruiter_status='Yes'and j.expired >='2020-02-19 14:08:54' and j.re_adv <='2020-02-19 14:08:54' and j.job_status='Yes' and ( j.deleted is NULL or j.deleted='0000-00-00 00:00:00') group by j.recruiter_id ORDER BY job_id DESC