Exception detected
toolbox\dbExceptionMessage: Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mmv_v2.a.latitude' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [select b.`continent_name`, b.`country_iso_code`, c.*,
                    b.`city_name`, b.`subdivision_1_name`, b.`country_name` from (
                    SELECT  sum(`total_hits`) AS `non_unique_visits`,
                    sum(`unique_hits`) AS `unique_visits`,  `latitude`, `longitude`, `geoname_id`,
                    `day`, MAX(`last_hit_id`) AS `max_hit_id`
                    FROM hits_aggregated_indexed `a`
                    WHERE `day` <= DATE(FROM_UNIXTIME("1798675200"))
                    AND `day` >= DATE(FROM_UNIXTIME("1767225600"))
                    AND `domain_id` = 2233597
                    GROUP BY `geoname_id`
                ) c
                left outer join `geoip2-city-locations-en` b using (`geoname_id`)
                ORDER BY `non_unique_visits` DESC]