Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'adcoordinates_jbyron.amp_ads_urls.region' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by<br><br>select sum(i) as i,sum(c) as c,country,region from amp_ads_urls where m = '1' AND y = '2022'  and country != '' and region != '' group by country order by i desc limit 100