[ SELECT failed in SQL: SELECT bc.`checkout_id`, bc.`add_dt`, COUNT(bc.`pid`) as `pos_cnt`, SUM(bc.`cnt`) as `cnt_summ`, SUM(bc.`price` / r.`rate` * bc.`cnt`) as `price_summ` FROM `basket_checkouts` bc INNER JOIN `exchange_rates` r ON bc.`currency` = r.`to` AND DATE(FROM_UNIXTIME(bc.`add_dt`)) = DATE(FROM_UNIXTIME(r.`dt`)) WHERE bc.`sid`="b2aa3d29e9d705e711e58757764db083" GROUP BY bc.`checkout_id` ORDER BY `add_dt` DESC ] ( 1055 : Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'oemwolf_data.bc.add_dt' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by )