Location
location — Allows to specify a location of event described in a topic
Homepage: devall.ru
0.1.3.1 Alex Yelizarov

# сам запрос конвертации

INSERT INTO prefix_content_values(target_id,target_type,field_id,field_type,value_type,value,value_varchar,value_source)
SELECT prefix_location.topic_id,'topic',1,'map','string',CONCAT('a:2:{i:0;s:7:"',LEFT(prefix_location.location_latlng, 7),'";i:1;s:7:"',LEFT(RIGHT(prefix_location.location_latlng,LENGTH(prefix_location.location_latlng)-INSTR(prefix_location.location_latlng,',')),7),'";}'),NULL,CONCAT('a:2:{i:0;s:7:"',LEFT(prefix_location.location_latlng, 7),'";i:1;s:7:"',LEFT(RIGHT(prefix_location.location_latlng,LENGTH(prefix_location.location_latlng)-INSTR(prefix_location.location_latlng,',')),7),'";}')
FROM prefix_location





# ----------------------------------
# это я вначале почистил таблицу prefix_location от мусора, 
# который остался после спам-аттак и всяких глюков
# может и не понадобится
SELECT *
FROM prefix_location
WHERE location_latlng = 0
LIMIT 0 , 1000;


DELETE FROM prefix_location 
WHERE prefix_location.location_latlng = 0;


SELECT *
FROM prefix_location
WHERE location_latlng = "54.19667800,37.61782"
LIMIT 0 , 1000;


DELETE FROM prefix_location 
WHERE location_latlng = "54.19667800,37.61782";