mysql/core_cities_merge.sql

[Pman.Core] / mysql / core_cities_merge.sql

diff --git a/mysql/core_cities_merge.sql b/mysql/core_cities_merge.sql
index 042d61b..7864c7a 100644 (file)
--- a/mysql/core_cities_merge.sql
+++ b/mysql/core_cities_merge.sql
@@ -503,7 +503,7 @@ CREATE FUNCTION core_city_blocks()  RETURNS INT DETERMINISTIC
             SET v_subdivision_name = '';
             SET v_city_name = '';
 
-            SELECT country_iso_code,subdivision_iso_name,city_name INTO v_country_iso_code, v_subdivision_name, v_city_name FROM city_locations WHERE geoname_id = v_geoname_id;
+            SELECT country_iso_code,subdivision_name,city_name INTO v_country_iso_code, v_subdivision_name, v_city_name FROM city_locations WHERE geoname_id = v_geoname_id;
 
             IF v_country_iso_code != '' THEN
                 SELECT id INTO v_country_id FROM core_geoip_country WHERE code = v_country_iso_code;