Query: select users.positive_votes as positive_votes, users.negative_votes as negative_votes, users.reserve_usd as reserve_usd, users.id as user_id, users.cat as cat, from_currencies.id as from_currency, to_currencies.id as to_currency, deals_public.register as register, deals_public.change_from as change_from, deals_public.change_to as change_to, users.site as link, users.username as user_name, users.email as email, users.active as active, from_currencies.name as from_name, from_currencies.ext as from_sign, from_currencies.active as from_active, to_currencies.active as to_active, to_currencies.name as to_name, to_currencies.ext as to_sign from `deals_public` left outer join `users` on `users`.`id` = `deals_public`.`user_id` inner join `currencies` as `from_currencies` on `from_currencies`.`id` = `deals_public`.`from_currency` and `from_currencies`.`active` = 1 inner join `currencies` as `to_currencies` on `to_currencies`.`id` = `deals_public`.`to_currency` and `to_currencies`.`active` = 1 where `users`.`active` = 1 and from_currency = 50 and to_currency = 121 group by deals_public.user_id order by change_to DESC, change_from ASC limit 20 Error description: Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mychange_site.deals_public.register' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
