user warning: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'tmp.dest_city' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
query:
SELECT tmp.dest_city,
c.city_name, c.region,
cn.country_name, cn.flag_icon,
COUNT(dest_id) AS visits FROM
(SELECT d.dest_id,
COALESCE(dl.dest_city, d.dest_city) AS dest_city
FROM jdfnet_dest d
LEFT JOIN jdfnet_dest_leg dl ON dl.dest_id = d.dest_id
WHERE (d.aborted <> 1) AND (dl.in_transit<> 1)) AS tmp
INNER JOIN jdfnet_cities c ON c.city_id = tmp.dest_city
LEFT JOIN jdfnet_countries cn ON cn.cntry_id = c.cntry_id
WHERE country_name <> "USA"
GROUP BY city_name
ORDER BY visits DESC, city_name ASC
LIMIT 5
in /home/vps1/public_html/d6jdfnet/includes/common.inc(1743) : eval()'d code on line 35.
user warning: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 't1.dest_city' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
query:
SELECT t2.* FROM
(SELECT t1.dest_city,
c.city_name, c.region,
cn.country_name, cn.flag_icon,
COUNT(dest_id) AS visits FROM
(SELECT d.dest_id,
COALESCE(dl.dest_city, d.dest_city) AS dest_city
FROM jdfnet_dest d
LEFT JOIN jdfnet_dest_leg dl ON dl.dest_id = d.dest_id
WHERE (d.aborted <> 1) AND (dl.in_transit<> 1)) as t1
INNER JOIN jdfnet_cities c ON c.city_id = t1.dest_city
LEFT JOIN jdfnet_countries cn ON cn.cntry_id = c.cntry_id
WHERE (country_name <> "USA")
GROUP BY city_name) AS t2
WHERE visits > 1
ORDER BY country_name ASC, visits DESC, city_name ASC
in /home/vps1/public_html/d6jdfnet/includes/common.inc(1743) : eval()'d code on line 94.
warning: Division by zero in /home/vps1/public_html/d6jdfnet/includes/common.inc(1743) : eval()'d code on line 98.