A Database Error Occurred

Error Number: 1055

Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'smcrealty_com.a.city_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

SELECT count(a.project_id) as total, `city_name`, `a`.`city_id`, `a`.`country` FROM `projects` `a` RIGHT JOIN `site_setting` `c` ON `c`.`project_id` = `a`.`project_id` RIGHT JOIN `city_master` `b` ON `b`.`city_id` = `a`.`city_id` WHERE `pstatus` = 'Active' GROUP BY `city_name` ORDER BY `total` DESC, `city_name` DESC

Filename: models/Welcome_model.php

Line Number: 89