Places Visited

  • 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.

World Cities Visited

Top Five

Cities Visited More Than Once