A Database Error Occurred

Error Number: 1055

Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'eatlapps_newdb.r.Rating' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

SELECT DISTINCT `a`.`Code`, `a`.`Name`, `a`.`developerID`, `a`.`Price`, `a`.`ShortDescription`, `a`.`directory`, `a`.`logo`, `r`.`Rating`, `r`.`Review` FROM (`application` a) LEFT JOIN `platform` ON `platform`.`P_id` = `a`.`P_id` LEFT JOIN `customer_review` r ON `r`.`A_id` = `a`.`code` WHERE `a`.`P_id` = '2' AND `ncid` = '5' AND `a`.`status` = 1 AND `a`.`Price` = 0 GROUP BY `a`.`Code` ORDER BY `r`.`Rating` desc

Filename: /home/eatlappscp/public_html/models/apps_new_model.php

Line Number: 1601