REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_name_native, s_slug, s_phone_code, s_currency) VALUES 
('GQ', 'Equatorial Guinea', 'Guinea Ecuatorial', 'equatorial-guinea', '240', 'XAF');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(5310307, 'GQ', 'Annobon', 1, 'annobon'),
(5566978, 'GQ', 'Bioko Norte', 1, 'bioko-norte'),
(5566979, 'GQ', 'Bioko Sur', 1, 'bioko-sur'),
(5566980, 'GQ', 'Centro Sur', 1, 'centro-sur'),
(5566981, 'GQ', 'Kié-Ntem', 1, 'kie-ntem'),
(5566982, 'GQ', 'Litoral', 1, 'litoral'),
(5566983, 'GQ', 'Wele-Nzas', 1, 'wele-nzas'),
(15168385, 'GQ', 'Djibloho', 1, 'djibloho');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug, d_coord_lat, d_coord_long) VALUES 
(5306468, 5566978, 'GQ', 'Zaragoza', 1, 'zaragoza', 3.71814, 8.74762),
(5306722, 5566978, 'GQ', 'Santiago de Baney', 1, 'santiago-de-baney', 3.6992, 8.9084),
(5306737, 5310307, 'GQ', 'Aual', 1, 'aual', -1.44556, 5.62722),
(5306774, 5310307, 'GQ', 'San Antonio de Palé', 1, 'san-antonio-de-pale', -1.4068, 5.63178),
(5306776, 5310307, 'GQ', 'Mábana', 1, 'mabana', -1.45833, 5.63667),
(5306819, 5566982, 'GQ', 'Río Campo', 1, 'rio-campo', 2.33812, 9.82212),
(5306824, 5566978, 'GQ', 'Rebola', 1, 'rebola', 3.71667, 8.83333),
(5306898, 5566983, 'GQ', 'Oyala', 1, 'oyala', 1.62162, 10.83391),
(5307145, 5566983, 'GQ', 'Nsok', 1, 'nsok', 1.12985, 11.26603),
(5307148, 5566981, 'GQ', 'Nsogoboot', 1, 'nsogoboot', 2.15692, 10.80053),
(5307197, 5566981, 'GQ', 'Nsang', 1, 'nsang', 2.02475, 10.94599),
(5307330, 5566982, 'GQ', 'Ngonemanga', 1, 'ngonemanga', 2.15152, 9.7936),
(5307502, 5566981, 'GQ', 'Ncue', 1, 'ncue', 2.01643, 10.47066),
(5307795, 5566983, 'GQ', 'Mongomo', 1, 'mongomo', 1.62742, 11.31346),
(5307871, 5566981, 'GQ', 'Mocoa', 1, 'mocoa', 2.1217, 11.0533),
(5307872, 5566982, 'GQ', 'Mocoa', 1, 'mocoa', 1.858, 9.8428),
(5307875, 5566979, 'GQ', 'Moca', 1, 'moca', 3.33333, 8.66667),
(5307913, 5566981, 'GQ', 'Misáa', 1, 'misaa', 2.1574, 11.25886),
(5307970, 5566981, 'GQ', 'Mikomeseng', 1, 'mikomeseng', 2.13609, 10.61322),
(5308278, 5566982, 'GQ', 'Mbini', 1, 'mbini', 1.58267, 9.61478),
(5308562, 5566979, 'GQ', 'Malabo', 1, 'malabo', 3.34834, 8.66026),
(5308626, 5566982, 'GQ', 'Machinda', 1, 'machinda', 1.88262, 9.95133),
(5308994, 5566980, 'GQ', 'Evinayong', 1, 'evinayong', 1.43677, 10.55124),
(5309332, 5566981, 'GQ', 'Ebebiyin', 1, 'ebebiyin', 2.15106, 11.33528),
(5309443, 5566978, 'GQ', 'Cupapa', 1, 'cupapa', 3.66693, 8.91571),
(5309516, 5566982, 'GQ', 'Cogo', 1, 'cogo', 1.08425, 9.693),
(5309526, 5566979, 'GQ', 'Ciudad de Riaba', 1, 'ciudad-de-riaba', 3.38288, 8.76209),
(5309527, 5566978, 'GQ', 'Malabo', 1, 'malabo', 3.75578, 8.78166),
(5309528, 5566979, 'GQ', 'Luba', 1, 'luba', 3.45683, 8.55465),
(5309529, 5566978, 'GQ', 'Ciudad de Ela Nguema', 1, 'ciudad-de-ela-nguema', 3.75, 8.78333),
(5309744, 5566982, 'GQ', 'Bitica', 1, 'bitica', 1.4261, 9.62316),
(5309842, 5566981, 'GQ', 'Bilon', 1, 'bilon', 2.14389, 10.22575),
(5309890, 5566980, 'GQ', 'Bicurga', 1, 'bicurga', 1.58113, 10.46716),
(5309989, 5566983, 'GQ', 'Mengomeyén', 1, 'mengomeyen', 1.69671, 11.01862),
(5310046, 5566982, 'GQ', 'Bata', 1, 'bata', 1.86391, 9.76582),
(5310134, 5566983, 'GQ', 'Ayene', 1, 'ayene', 1.85592, 10.68994),
(5310168, 5566982, 'GQ', 'Ayaantang', 1, 'ayaantang', 1.73542, 9.68128),
(5310309, 5566983, 'GQ', 'Añisoc', 1, 'anisoc', 1.8658, 10.76892),
(5310533, 5566980, 'GQ', 'Acurenam', 1, 'acurenam', 1.03225, 10.64882),
(5310547, 5566983, 'GQ', 'Aconibe', 1, 'aconibe', 1.29683, 10.93691),
(5310628, 5566981, 'GQ', 'Acam', 1, 'acam', 2.13377, 11.0492),
(5566027, 5310307, 'GQ', 'Anganchi', 1, 'anganchi', -1.43056, 5.65194);