Executed Query -> select u.id,u.image,u.name,r.review,u.review as rating,u.numreviews,(select name from tbl_users where id = r.reviewer_id) as reviewername from tbl_users as u inner join tbl_reviews as r on (u.id = r.provider_id) where flag_status = "0" group by u.id order by u.review desc ,r.created_date desc limit 4

ERROR:"SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'favo_db.r.review' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by: 367"