A Database Error Occurred

Error Number: 1055

Expression #10 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`.`userid`, `a`.`id`, `a`.`title`, `a`.`writer`, `a`.`description`, `a`.`images`, `a`.`thumb`, `a`.`files`, `a`.`date`, `r`.`Rating`, `r`.`Review` FROM (`eatl_books` a) LEFT JOIN `books_customer_review` r ON `r`.`A_id` = `a`.`id` WHERE `a`.`status` = 1 GROUP BY `a`.`id` ORDER BY `a`.`id` desc LIMIT 50

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

Line Number: 1320