An Error Was Encountered

Error Number: 1052

Column 'es' in field list is ambiguous

SELECT world_weather.foreca_id, IFNULL(es, name) foreca_city, longitude, latitude, symbol, ROUND(temp_avg, 0) AS temperature, ROUND(temp_max, 0) AS temp_max, ROUND(temp_min, 0) AS temp_min, UNIX_TIMESTAMP(date) AS timestamp, UNIX_TIMESTAMP(date) AS local_timestamp, DATE_FORMAT(DATE(date), '%d-%m-%Y') AS date, TIME(date) AS time, SUBSTRING(symbol FROM 1) AS weather, wind_dir, ROUND((wind_dir / 22.5) - 0.5) AS wind_card, wind_avg AS wind_speed, ROUND(POWER((wind_avg / 0.8365), (2 / 3))) AS beaufort, 0 AS is_foreca, country_codes.urlized AS urlized_country FROM eltiempo.world_cities JOIN eltiempo.world_weather USING (foreca_id) JOIN eltiempo.country_codes ON world_cities.country = country_codes.cc WHERE world_cities.urlized = 'acayucan' AND country_codes.urlized = 'mexico' AND date between CURRENT_DATE and CURRENT_DATE + INTERVAL 6 DAY ORDER BY date ASC