1$this->db->query('SET SESSION sql_mode = ""');
2
3// ONLY_FULL_GROUP_BY
4$this->db->query('SET SESSION sql_mode =
5 REPLACE(REPLACE(REPLACE(
6 @@sql_mode,
7 "ONLY_FULL_GROUP_BY,", ""),
8 ",ONLY_FULL_GROUP_BY", ""),
9 "ONLY_FULL_GROUP_BY", "")');
10