Ошибка Expression of SELECT list is not in GROUP BY clause and contains nonaggregated column

У меня есть такой код:

"SELECT *  
FROM  orders 
LEFT JOIN shops ON orders.id  = shops.shop_id
WHERE shops.user_id  = '".$this->session->userdata("user_id")."'
GROUP BY orders.id ");

Получаю сообщение об ошибке:

Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cod_db.shops.inc_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by