CODE EXAMPLE FOR SQL

select list is not in group by clause and contains nonaggregated column codeigniter

$this->db->query("SET sql_mode=(SELECT REPLACE(@@sql_mode, 'ONLY_FULL_GROUP_BY', ''));");