Error!

MySQL Error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'rodpub_beta.address_countries.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL Statement: SELECT address_countries.* , count(DISTINCT contents.id) as count FROM contents JOIN content_taxonomy on content_taxonomy.content_id = contents.id JOIN content_locations on content_locations.content_id=contents.id JOIN locations on content_locations.location_id=locations.id JOIN address_countries on address_countries.iso_code=locations.country JOIN asset_packages on asset_packages.resource_id = contents.id WHERE contents.content_type_id = '2543' AND address_countries.iso_code!='' and contents.publish_date <= '2022-01-23 23:00:00' and contents.published=1 and contents.magazine_id=7 and asset_packages.published = 1 and asset_packages.resource = contents.resource_id and asset_packages.expire_at>= '2022-01-23 23:00:00' AND contents.id IN (select content_taxonomy.content_id from content_taxonomy where taxonomy_id IN(9760)) group by address_countries.name ORDER BY address_countries.name asc