Error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'zkizcom78f.stock_list.dirchinese' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by SELECT * FROM stock_list a, ( SELECT * FROM ( SELECT `direnglish` , `dirchinese` , COUNT( * ) AS a FROM `stock_list` WHERE `code` IN (SELECT id FROM stock_fj) GROUP BY direnglish )tbla WHERE a >1 ORDER BY `tbla`.`a` DESC ) b WHERE code = 1 AND a.direnglish = b.direnglish .#0/home/wwwroot/lib/functions.php:556->dbErr(Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'zkizcom78f.stock_list.dirchinese' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by,SELECT * FROM stock_list a, ( SELECT * FROM ( SELECT `direnglish` , `dirchinese` , COUNT( * ) AS a FROM `stock_list` WHERE `code` IN (SELECT id FROM stock_fj) GROUP BY direnglish )tbla WHERE a >1 ORDER BY `tbla`.`a` DESC ) b WHERE code = 1 AND a.direnglish = b.direnglish) #1/home/wwwroot/stock.zkiz.com/test.php:24->dbAr(SELECT * FROM stock_list a, ( SELECT * FROM ( SELECT `direnglish` , `dirchinese` , COUNT( * ) AS a FROM `stock_list` WHERE `code` IN (SELECT id FROM stock_fj) GROUP BY direnglish )tbla WHERE a >1 ORDER BY `tbla`.`a` DESC ) b WHERE code = 1 AND a.direnglish = b.direnglish)