Database query failed Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'sparkbpl_job.jobberland_job2category.job_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Last Query run : SELECT count(category_id) maxnum, category_id, job_id, cat.var_name FROM jobberland_job AS job, jobberland_job2category, jobberland_category AS cat WHERE DATE_ADD( created_at, INTERVAL 120 DAY ) > NOW() AND job.id = job_id AND job.is_active = 'Y' AND job_status = 'approved' AND cat.var_name <> '0' AND cat.id = category_id GROUP BY category_id ORDER BY maxnum DESC LIMIT 0, 10