INSERT IGNORE INTO `#__sellacious_locations` (`id`, `title`, `iso_code`, `parent_id`, `type`, `state`, `continent_id`, `country_id`, `state_id`, `district_id`, `area_id`, `zip_id`, `new_id`, `continent_title`, `country_title`, `state_title`, `district_title`, `area_title`, `zip_title`) VALUES
(479, 'Rayong', '', 116, 'state', 1, 4, 116, 0, 0, 0, 0, 0, 'Asia', 'Thailand', NULL, NULL, NULL, NULL),
(480, 'Roi Et', '', 116, 'state', 1, 4, 116, 0, 0, 0, 0, 0, 'Asia', 'Thailand', NULL, NULL, NULL, NULL),
(481, 'Sa Kaeo', '', 116, 'state', 1, 4, 116, 0, 0, 0, 0, 0, 'Asia', 'Thailand', NULL, NULL, NULL, NULL),
(482, 'Sakon Nakhon', '', 116, 'state', 1, 4, 116, 0, 0, 0, 0, 0, 'Asia', 'Thailand', NULL, NULL, NULL, NULL),
(483, 'Samut Prakan', '', 116, 'state', 1, 4, 116, 0, 0, 0, 0, 0, 'Asia', 'Thailand', NULL, NULL, NULL, NULL),
(484, 'Samut Sakhon', '', 116, 'state', 1, 4, 116, 0, 0, 0, 0, 0, 'Asia', 'Thailand', NULL, NULL, NULL, NULL),
(485, 'Samut Songkhram', '', 116, 'state', 1, 4, 116, 0, 0, 0, 0, 0, 'Asia', 'Thailand', NULL, NULL, NULL, NULL),
(486, 'Saraburi', '', 116, 'state', 1, 4, 116, 0, 0, 0, 0, 0, 'Asia', 'Thailand', NULL, NULL, NULL, NULL),
(487, 'Satun', '', 116, 'state', 1, 4, 116, 0, 0, 0, 0, 0, 'Asia', 'Thailand', NULL, NULL, NULL, NULL),
(488, 'Singburi', '', 116, 'state', 1, 4, 116, 0, 0, 0, 0, 0, 'Asia', 'Thailand', NULL, NULL, NULL, NULL),
(489, 'Sisaket', '', 116, 'state', 1, 4, 116, 0, 0, 0, 0, 0, 'Asia', 'Thailand', NULL, NULL, NULL, NULL),
(490, 'Songkhla', '', 116, 'state', 1, 4, 116, 0, 0, 0, 0, 0, 'Asia', 'Thailand', NULL, NULL, NULL, NULL),
(491, 'Sukhothai', '', 116, 'state', 1, 4, 116, 0, 0, 0, 0, 0, 'Asia', 'Thailand', NULL, NULL, NULL, NULL),
(492, 'Suphanburi', '', 116, 'state', 1, 4, 116, 0, 0, 0, 0, 0, 'Asia', 'Thailand', NULL, NULL, NULL, NULL),
(493, 'Surat Thani', '', 116, 'state', 1, 4, 116, 0, 0, 0, 0, 0, 'Asia', 'Thailand', NULL, NULL, NULL, NULL),
(494, 'Tak', '', 116, 'state', 1, 4, 116, 0, 0, 0, 0, 0, 'Asia', 'Thailand', NULL, NULL, NULL, NULL),
(495, 'Trang', '', 116, 'state', 1, 4, 116, 0, 0, 0, 0, 0, 'Asia', 'Thailand', NULL, NULL, NULL, NULL),
(496, 'Trat', '', 116, 'state', 1, 4, 116, 0, 0, 0, 0, 0, 'Asia', 'Thailand', NULL, NULL, NULL, NULL),
(497, 'Ubon Ratchathani', '', 116, 'state', 1, 4, 116, 0, 0, 0, 0, 0, 'Asia', 'Thailand', NULL, NULL, NULL, NULL),
(498, 'Udon Thani', '', 116, 'state', 1, 4, 116, 0, 0, 0, 0, 0, 'Asia', 'Thailand', NULL, NULL, NULL, NULL),
(499, 'Uthai Thani', '', 116, 'state', 1, 4, 116, 0, 0, 0, 0, 0, 'Asia', 'Thailand', NULL, NULL, NULL, NULL),
(500, 'Uttaradit', '', 116, 'state', 1, 4, 116, 0, 0, 0, 0, 0, 'Asia', 'Thailand', NULL, NULL, NULL, NULL),
(501, 'Yala', '', 116, 'state', 1, 4, 116, 0, 0, 0, 0, 0, 'Asia', 'Thailand', NULL, NULL, NULL, NULL),
(502, 'Yasothon', '', 116, 'state', 1, 4, 116, 0, 0, 0, 0, 0, 'Asia', 'Thailand', NULL, NULL, NULL, NULL),
(503, 'Adana', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(504, 'Adiyaman', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(505, 'Afyonkarahisar', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(506, 'Ağri', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(507, 'Aksaray', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(508, 'Amasya', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(509, 'Ankara', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(510, 'Antalya', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(511, 'Ardahan', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(512, 'Artvin', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(513, 'Aydin', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(514, 'Balikesir', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(515, 'Bartin', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(516, 'Batman', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(517, 'Bayburt', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(518, 'Bilecik', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(519, 'Bingöl', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(520, 'Bitlis', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(521, 'Bolu', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(522, 'Burdur', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(523, 'Bursa', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(524, 'Çanakkale', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(525, 'Çankiri', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(526, 'Çorum', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(527, 'Denizli', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(528, 'Diyarbakir', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(529, 'Düzce', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(530, 'Edirne', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(531, 'Elaziğ', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(532, 'Erzincan', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(533, 'Erzurum', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(534, 'Eskişehir', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(535, 'Gaziantep', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(536, 'Giresun', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(537, 'Gümüşhane', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(538, 'Hakkari', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(539, 'Hatay', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(540, 'Iğdir', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(541, 'Isparta', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(542, 'İstanbul', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(543, 'İzmir', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(544, 'Kahramanmaraş', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(545, 'Karabük', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(546, 'Karaman', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(547, 'Kars', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(548, 'Kastamonu', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(549, 'Kayseri', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(550, 'Kilis', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(551, 'Kirikkale', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(552, 'Kirklareli', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(553, 'Kirşehir', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(554, 'Kktc', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(555, 'Kocaeli', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(556, 'Konya', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(557, 'Kütahya', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(558, 'Malatya', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(559, 'Manisa', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(560, 'Mardin', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(561, 'Mersin(İçel)', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(562, 'Muğla', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(563, 'Muş', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(564, 'Nevşehir', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(565, 'Niğde', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(566, 'Ordu', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(567, 'Osmaniye', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(568, 'Rize', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(569, 'Sakarya', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(570, 'Samsun', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(571, 'Şanliurfa', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(572, 'Siirt', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(573, 'Sinop', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(574, 'Şirnak', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(575, 'Sivas', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(576, 'Tekirdağ', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(577, 'Tokat', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(578, 'Trabzon', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(579, 'Tunceli', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(580, 'Uşak', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(581, 'Van', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(582, 'Yalova', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(583, 'Yozgat', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(584, 'Zonguldak', '', 119, 'state', 1, 4, 119, 0, 0, 0, 0, 0, 'Asia', 'Turkey', NULL, NULL, NULL, NULL),
(585, 'Burgenland', '', 126, 'state', 1, 5, 126, 0, 0, 0, 0, 0, 'Europe', 'Austria', NULL, NULL, NULL, NULL),
(586, 'Kärnten', '', 126, 'state', 1, 5, 126, 0, 0, 0, 0, 0, 'Europe', 'Austria', NULL, NULL, NULL, NULL),
(587, 'Niederösterreich', '', 126, 'state', 1, 5, 126, 0, 0, 0, 0, 0, 'Europe', 'Austria', NULL, NULL, NULL, NULL),
(588, 'Oberösterreich', '', 126, 'state', 1, 5, 126, 0, 0, 0, 0, 0, 'Europe', 'Austria', NULL, NULL, NULL, NULL),
(589, 'Salzburg', '', 126, 'state', 1, 5, 126, 0, 0, 0, 0, 0, 'Europe', 'Austria', NULL, NULL, NULL, NULL),
(590, 'Steiermark', '', 126, 'state', 1, 5, 126, 0, 0, 0, 0, 0, 'Europe', 'Austria', NULL, NULL, NULL, NULL),
(591, 'Tirol', '', 126, 'state', 1, 5, 126, 0, 0, 0, 0, 0, 'Europe', 'Austria', NULL, NULL, NULL, NULL),
(592, 'Vorarlberg', '', 126, 'state', 1, 5, 126, 0, 0, 0, 0, 0, 'Europe', 'Austria', NULL, NULL, NULL, NULL),
(593, 'Wien', '', 126, 'state', 1, 5, 126, 0, 0, 0, 0, 0, 'Europe', 'Austria', NULL, NULL, NULL, NULL),
(594, 'Ålands landsbygd', '', 127, 'state', 1, 5, 127, 0, 0, 0, 0, 0, 'Europe', 'Aland Islands', NULL, NULL, NULL, NULL),
(595, 'Ålands skärgård', '', 127, 'state', 1, 5, 127, 0, 0, 0, 0, 0, 'Europe', 'Aland Islands', NULL, NULL, NULL, NULL),
(596, 'Mariehamns stad', '', 127, 'state', 1, 5, 127, 0, 0, 0, 0, 0, 'Europe', 'Aland Islands', NULL, NULL, NULL, NULL),
(597, 'Bruxelles-Capitale', '', 129, 'state', 1, 5, 129, 0, 0, 0, 0, 0, 'Europe', 'Belgium', NULL, NULL, NULL, NULL),
(598, 'Vlaanderen', '', 129, 'state', 1, 5, 129, 0, 0, 0, 0, 0, 'Europe', 'Belgium', NULL, NULL, NULL, NULL),
(599, 'Wallonie', '', 129, 'state', 1, 5, 129, 0, 0, 0, 0, 0, 'Europe', 'Belgium', NULL, NULL, NULL, NULL),
(600, 'Благоевград / Blagoevgrad', '', 130, 'state', 1, 5, 130, 0, 0, 0, 0, 0, 'Europe', 'Bulgaria', NULL, NULL, NULL, NULL),
(601, 'Бургас / Burgas', '', 130, 'state', 1, 5, 130, 0, 0, 0, 0, 0, 'Europe', 'Bulgaria', NULL, NULL, NULL, NULL),
(602, 'Варна / Varna', '', 130, 'state', 1, 5, 130, 0, 0, 0, 0, 0, 'Europe', 'Bulgaria', NULL, NULL, NULL, NULL),
(603, 'Велико Търново / Veliko Turnovo', '', 130, 'state', 1, 5, 130, 0, 0, 0, 0, 0, 'Europe', 'Bulgaria', NULL, NULL, NULL, NULL),
(604, 'Видин / Vidin', '', 130, 'state', 1, 5, 130, 0, 0, 0, 0, 0, 'Europe', 'Bulgaria', NULL, NULL, NULL, NULL),
(605, 'Враца / Vraca', '', 130, 'state', 1, 5, 130, 0, 0, 0, 0, 0, 'Europe', 'Bulgaria', NULL, NULL, NULL, NULL),
(606, 'Габрово / Gabrovo', '', 130, 'state', 1, 5, 130, 0, 0, 0, 0, 0, 'Europe', 'Bulgaria', NULL, NULL, NULL, NULL),
(607, 'Добрич / Dobrich', '', 130, 'state', 1, 5, 130, 0, 0, 0, 0, 0, 'Europe', 'Bulgaria', NULL, NULL, NULL, NULL),
(608, 'Кърджали / Kurdzhali', '', 130, 'state', 1, 5, 130, 0, 0, 0, 0, 0, 'Europe', 'Bulgaria', NULL, NULL, NULL, NULL),
(609, 'Кюстендил / Kjustendil', '', 130, 'state', 1, 5, 130, 0, 0, 0, 0, 0, 'Europe', 'Bulgaria', NULL, NULL, NULL, NULL),
(610, 'Ловеч / Lovech', '', 130, 'state', 1, 5, 130, 0, 0, 0, 0, 0, 'Europe', 'Bulgaria', NULL, NULL, NULL, NULL),
(611, 'Монтана / Montana', '', 130, 'state', 1, 5, 130, 0, 0, 0, 0, 0, 'Europe', 'Bulgaria', NULL, NULL, NULL, NULL),
(612, 'Пазарджик / Pazardzhik', '', 130, 'state', 1, 5, 130, 0, 0, 0, 0, 0, 'Europe', 'Bulgaria', NULL, NULL, NULL, NULL),
(613, 'Перник / Pernik', '', 130, 'state', 1, 5, 130, 0, 0, 0, 0, 0, 'Europe', 'Bulgaria', NULL, NULL, NULL, NULL),
(614, 'Плевен / Pleven', '', 130, 'state', 1, 5, 130, 0, 0, 0, 0, 0, 'Europe', 'Bulgaria', NULL, NULL, NULL, NULL),
(615, 'Пловдив / Plovdiv', '', 130, 'state', 1, 5, 130, 0, 0, 0, 0, 0, 'Europe', 'Bulgaria', NULL, NULL, NULL, NULL),
(616, 'Разград / Razgrad', '', 130, 'state', 1, 5, 130, 0, 0, 0, 0, 0, 'Europe', 'Bulgaria', NULL, NULL, NULL, NULL),
(617, 'Русе / Ruse', '', 130, 'state', 1, 5, 130, 0, 0, 0, 0, 0, 'Europe', 'Bulgaria', NULL, NULL, NULL, NULL),
(618, 'Силистра / Silistra', '', 130, 'state', 1, 5, 130, 0, 0, 0, 0, 0, 'Europe', 'Bulgaria', NULL, NULL, NULL, NULL),
(619, 'Сливен / Sliven', '', 130, 'state', 1, 5, 130, 0, 0, 0, 0, 0, 'Europe', 'Bulgaria', NULL, NULL, NULL, NULL),
(620, 'Смолян / Smoljan', '', 130, 'state', 1, 5, 130, 0, 0, 0, 0, 0, 'Europe', 'Bulgaria', NULL, NULL, NULL, NULL),
(621, 'София (столица) / Sofija (stolica)', '', 130, 'state', 1, 5, 130, 0, 0, 0, 0, 0, 'Europe', 'Bulgaria', NULL, NULL, NULL, NULL),
(622, 'София / Sofija', '', 130, 'state', 1, 5, 130, 0, 0, 0, 0, 0, 'Europe', 'Bulgaria', NULL, NULL, NULL, NULL),
(623, 'Стара Загора / Stara Zagora', '', 130, 'state', 1, 5, 130, 0, 0, 0, 0, 0, 'Europe', 'Bulgaria', NULL, NULL, NULL, NULL),
(624, 'Търговище / Turgovishhe', '', 130, 'state', 1, 5, 130, 0, 0, 0, 0, 0, 'Europe', 'Bulgaria', NULL, NULL, NULL, NULL),
(625, 'Хасково / Khaskovo', '', 130, 'state', 1, 5, 130, 0, 0, 0, 0, 0, 'Europe', 'Bulgaria', NULL, NULL, NULL, NULL),
(626, 'Шумен / Shumen', '', 130, 'state', 1, 5, 130, 0, 0, 0, 0, 0, 'Europe', 'Bulgaria', NULL, NULL, NULL, NULL),
(627, 'Ямбол / Jambol', '', 130, 'state', 1, 5, 130, 0, 0, 0, 0, 0, 'Europe', 'Bulgaria', NULL, NULL, NULL, NULL),
(628, 'Canton de Fribourg', '', 132, 'state', 1, 5, 132, 0, 0, 0, 0, 0, 'Europe', 'Switzerland', NULL, NULL, NULL, NULL),
(629, 'Canton de Genève', '', 132, 'state', 1, 5, 132, 0, 0, 0, 0, 0, 'Europe', 'Switzerland', NULL, NULL, NULL, NULL),
(630, 'Canton de Neuchâtel', '', 132, 'state', 1, 5, 132, 0, 0, 0, 0, 0, 'Europe', 'Switzerland', NULL, NULL, NULL, NULL),
(631, 'Canton de Vaud', '', 132, 'state', 1, 5, 132, 0, 0, 0, 0, 0, 'Europe', 'Switzerland', NULL, NULL, NULL, NULL),
(632, 'Canton du Jura', '', 132, 'state', 1, 5, 132, 0, 0, 0, 0, 0, 'Europe', 'Switzerland', NULL, NULL, NULL, NULL),
(633, 'Canton du Valais', '', 132, 'state', 1, 5, 132, 0, 0, 0, 0, 0, 'Europe', 'Switzerland', NULL, NULL, NULL, NULL),
(634, 'Cantone Ticino', '', 132, 'state', 1, 5, 132, 0, 0, 0, 0, 0, 'Europe', 'Switzerland', NULL, NULL, NULL, NULL),
(635, 'Kanton Aargau', '', 132, 'state', 1, 5, 132, 0, 0, 0, 0, 0, 'Europe', 'Switzerland', NULL, NULL, NULL, NULL),
(636, 'Kanton Appenzell Ausserrhoden', '', 132, 'state', 1, 5, 132, 0, 0, 0, 0, 0, 'Europe', 'Switzerland', NULL, NULL, NULL, NULL),
(637, 'Kanton Appenzell Innerrhoden', '', 132, 'state', 1, 5, 132, 0, 0, 0, 0, 0, 'Europe', 'Switzerland', NULL, NULL, NULL, NULL),
(638, 'Kanton Basel-Landschaft', '', 132, 'state', 1, 5, 132, 0, 0, 0, 0, 0, 'Europe', 'Switzerland', NULL, NULL, NULL, NULL),
(639, 'Kanton Basel-Stadt', '', 132, 'state', 1, 5, 132, 0, 0, 0, 0, 0, 'Europe', 'Switzerland', NULL, NULL, NULL, NULL),
(640, 'Kanton Bern', '', 132, 'state', 1, 5, 132, 0, 0, 0, 0, 0, 'Europe', 'Switzerland', NULL, NULL, NULL, NULL),
(641, 'Kanton Glarus', '', 132, 'state', 1, 5, 132, 0, 0, 0, 0, 0, 'Europe', 'Switzerland', NULL, NULL, NULL, NULL),
(642, 'Kanton Graubünden', '', 132, 'state', 1, 5, 132, 0, 0, 0, 0, 0, 'Europe', 'Switzerland', NULL, NULL, NULL, NULL),
(643, 'Kanton Luzern', '', 132, 'state', 1, 5, 132, 0, 0, 0, 0, 0, 'Europe', 'Switzerland', NULL, NULL, NULL, NULL),
(644, 'Kanton Nidwalden', '', 132, 'state', 1, 5, 132, 0, 0, 0, 0, 0, 'Europe', 'Switzerland', NULL, NULL, NULL, NULL),
(645, 'Kanton Obwalden', '', 132, 'state', 1, 5, 132, 0, 0, 0, 0, 0, 'Europe', 'Switzerland', NULL, NULL, NULL, NULL),
(646, 'Kanton Schaffhausen', '', 132, 'state', 1, 5, 132, 0, 0, 0, 0, 0, 'Europe', 'Switzerland', NULL, NULL, NULL, NULL),
(647, 'Kanton Schwyz', '', 132, 'state', 1, 5, 132, 0, 0, 0, 0, 0, 'Europe', 'Switzerland', NULL, NULL, NULL, NULL),
(648, 'Kanton Solothurn', '', 132, 'state', 1, 5, 132, 0, 0, 0, 0, 0, 'Europe', 'Switzerland', NULL, NULL, NULL, NULL),
(649, 'Kanton St. Gallen', '', 132, 'state', 1, 5, 132, 0, 0, 0, 0, 0, 'Europe', 'Switzerland', NULL, NULL, NULL, NULL),
(650, 'Kanton Thurgau', '', 132, 'state', 1, 5, 132, 0, 0, 0, 0, 0, 'Europe', 'Switzerland', NULL, NULL, NULL, NULL),
(651, 'Kanton Uri', '', 132, 'state', 1, 5, 132, 0, 0, 0, 0, 0, 'Europe', 'Switzerland', NULL, NULL, NULL, NULL),
(652, 'Kanton Zug', '', 132, 'state', 1, 5, 132, 0, 0, 0, 0, 0, 'Europe', 'Switzerland', NULL, NULL, NULL, NULL),
(653, 'Kanton Zürich', '', 132, 'state', 1, 5, 132, 0, 0, 0, 0, 0, 'Europe', 'Switzerland', NULL, NULL, NULL, NULL),
(654, 'Baden-Württemberg', '', 136, 'state', 1, 5, 136, 0, 0, 0, 0, 0, 'Europe', 'Germany', NULL, NULL, NULL, NULL),
(655, 'Bayern', '', 136, 'state', 1, 5, 136, 0, 0, 0, 0, 0, 'Europe', 'Germany', NULL, NULL, NULL, NULL),
(656, 'Berlin', '', 136, 'state', 1, 5, 136, 0, 0, 0, 0, 0, 'Europe', 'Germany', NULL, NULL, NULL, NULL),
(657, 'Brandenburg', '', 136, 'state', 1, 5, 136, 0, 0, 0, 0, 0, 'Europe', 'Germany', NULL, NULL, NULL, NULL),
(658, 'Bremen', '', 136, 'state', 1, 5, 136, 0, 0, 0, 0, 0, 'Europe', 'Germany', NULL, NULL, NULL, NULL),
(659, 'Hamburg', '', 136, 'state', 1, 5, 136, 0, 0, 0, 0, 0, 'Europe', 'Germany', NULL, NULL, NULL, NULL),
(660, 'Hessen', '', 136, 'state', 1, 5, 136, 0, 0, 0, 0, 0, 'Europe', 'Germany', NULL, NULL, NULL, NULL),
(661, 'Mecklenburg-Vorpommern', '', 136, 'state', 1, 5, 136, 0, 0, 0, 0, 0, 'Europe', 'Germany', NULL, NULL, NULL, NULL),
(662, 'Niedersachsen', '', 136, 'state', 1, 5, 136, 0, 0, 0, 0, 0, 'Europe', 'Germany', NULL, NULL, NULL, NULL),
(663, 'Nordrhein-Westfalen', '', 136, 'state', 1, 5, 136, 0, 0, 0, 0, 0, 'Europe', 'Germany', NULL, NULL, NULL, NULL),
(664, 'Rheinland-Pfalz', '', 136, 'state', 1, 5, 136, 0, 0, 0, 0, 0, 'Europe', 'Germany', NULL, NULL, NULL, NULL),
(665, 'Saarland', '', 136, 'state', 1, 5, 136, 0, 0, 0, 0, 0, 'Europe', 'Germany', NULL, NULL, NULL, NULL),
(666, 'Sachsen', '', 136, 'state', 1, 5, 136, 0, 0, 0, 0, 0, 'Europe', 'Germany', NULL, NULL, NULL, NULL),
(667, 'Sachsen-Anhalt', '', 136, 'state', 1, 5, 136, 0, 0, 0, 0, 0, 'Europe', 'Germany', NULL, NULL, NULL, NULL),
(668, 'Schleswig-Holstein', '', 136, 'state', 1, 5, 136, 0, 0, 0, 0, 0, 'Europe', 'Germany', NULL, NULL, NULL, NULL),
(669, 'Thüringen', '', 136, 'state', 1, 5, 136, 0, 0, 0, 0, 0, 'Europe', 'Germany', NULL, NULL, NULL, NULL),
(670, 'Region Hovedstaden', '', 137, 'state', 1, 5, 137, 0, 0, 0, 0, 0, 'Europe', 'Denmark', NULL, NULL, NULL, NULL),
(671, 'Region Midtjylland', '', 137, 'state', 1, 5, 137, 0, 0, 0, 0, 0, 'Europe', 'Denmark', NULL, NULL, NULL, NULL),
(672, 'Region Nordjylland', '', 137, 'state', 1, 5, 137, 0, 0, 0, 0, 0, 'Europe', 'Denmark', NULL, NULL, NULL, NULL),
(673, 'Region Sjælland', '', 137, 'state', 1, 5, 137, 0, 0, 0, 0, 0, 'Europe', 'Denmark', NULL, NULL, NULL, NULL),
(674, 'Region Syddanmark', '', 137, 'state', 1, 5, 137, 0, 0, 0, 0, 0, 'Europe', 'Denmark', NULL, NULL, NULL, NULL),
(675, 'Andalucia', '', 139, 'state', 1, 5, 139, 0, 0, 0, 0, 0, 'Europe', 'Spain', NULL, NULL, NULL, NULL),
(676, 'Aragon', '', 139, 'state', 1, 5, 139, 0, 0, 0, 0, 0, 'Europe', 'Spain', NULL, NULL, NULL, NULL),
(677, 'Asturias', '', 139, 'state', 1, 5, 139, 0, 0, 0, 0, 0, 'Europe', 'Spain', NULL, NULL, NULL, NULL),
(678, 'Baleares', '', 139, 'state', 1, 5, 139, 0, 0, 0, 0, 0, 'Europe', 'Spain', NULL, NULL, NULL, NULL),
(679, 'Canarias', '', 139, 'state', 1, 5, 139, 0, 0, 0, 0, 0, 'Europe', 'Spain', NULL, NULL, NULL, NULL),
(680, 'Cantabria', '', 139, 'state', 1, 5, 139, 0, 0, 0, 0, 0, 'Europe', 'Spain', NULL, NULL, NULL, NULL),
(681, 'Castilla - La Mancha', '', 139, 'state', 1, 5, 139, 0, 0, 0, 0, 0, 'Europe', 'Spain', NULL, NULL, NULL, NULL),
(682, 'Castilla - Leon', '', 139, 'state', 1, 5, 139, 0, 0, 0, 0, 0, 'Europe', 'Spain', NULL, NULL, NULL, NULL),
(683, 'Cataluna', '', 139, 'state', 1, 5, 139, 0, 0, 0, 0, 0, 'Europe', 'Spain', NULL, NULL, NULL, NULL),
(684, 'Ceuta', '', 139, 'state', 1, 5, 139, 0, 0, 0, 0, 0, 'Europe', 'Spain', NULL, NULL, NULL, NULL),
(685, 'Comunidad Valenciana', '', 139, 'state', 1, 5, 139, 0, 0, 0, 0, 0, 'Europe', 'Spain', NULL, NULL, NULL, NULL),
(686, 'Extremadura', '', 139, 'state', 1, 5, 139, 0, 0, 0, 0, 0, 'Europe', 'Spain', NULL, NULL, NULL, NULL),
(687, 'Galicia', '', 139, 'state', 1, 5, 139, 0, 0, 0, 0, 0, 'Europe', 'Spain', NULL, NULL, NULL, NULL),
(688, 'La Rioja', '', 139, 'state', 1, 5, 139, 0, 0, 0, 0, 0, 'Europe', 'Spain', NULL, NULL, NULL, NULL),
(689, 'Madrid', '', 139, 'state', 1, 5, 139, 0, 0, 0, 0, 0, 'Europe', 'Spain', NULL, NULL, NULL, NULL),
(690, 'Melilla', '', 139, 'state', 1, 5, 139, 0, 0, 0, 0, 0, 'Europe', 'Spain', NULL, NULL, NULL, NULL),
(691, 'Murcia', '', 139, 'state', 1, 5, 139, 0, 0, 0, 0, 0, 'Europe', 'Spain', NULL, NULL, NULL, NULL),
(692, 'Navarra', '', 139, 'state', 1, 5, 139, 0, 0, 0, 0, 0, 'Europe', 'Spain', NULL, NULL, NULL, NULL),
(693, 'Pais Vasco', '', 139, 'state', 1, 5, 139, 0, 0, 0, 0, 0, 'Europe', 'Spain', NULL, NULL, NULL, NULL),
(694, 'Etelä-Karjala', '', 140, 'state', 1, 5, 140, 0, 0, 0, 0, 0, 'Europe', 'Finland', NULL, NULL, NULL, NULL),
(695, 'Etelä-Pohjanmaa', '', 140, 'state', 1, 5, 140, 0, 0, 0, 0, 0, 'Europe', 'Finland', NULL, NULL, NULL, NULL),
(696, 'Etelä-Savo', '', 140, 'state', 1, 5, 140, 0, 0, 0, 0, 0, 'Europe', 'Finland', NULL, NULL, NULL, NULL),
(697, 'Kainuu', '', 140, 'state', 1, 5, 140, 0, 0, 0, 0, 0, 'Europe', 'Finland', NULL, NULL, NULL, NULL),
(698, 'Kanta-Häme', '', 140, 'state', 1, 5, 140, 0, 0, 0, 0, 0, 'Europe', 'Finland', NULL, NULL, NULL, NULL),
(699, 'Keski-Pohjanmaa', '', 140, 'state', 1, 5, 140, 0, 0, 0, 0, 0, 'Europe', 'Finland', NULL, NULL, NULL, NULL),
(700, 'Keski-Suomi', '', 140, 'state', 1, 5, 140, 0, 0, 0, 0, 0, 'Europe', 'Finland', NULL, NULL, NULL, NULL),
(701, 'Kymenlaakso', '', 140, 'state', 1, 5, 140, 0, 0, 0, 0, 0, 'Europe', 'Finland', NULL, NULL, NULL, NULL),
(702, 'Lappi', '', 140, 'state', 1, 5, 140, 0, 0, 0, 0, 0, 'Europe', 'Finland', NULL, NULL, NULL, NULL),
(703, 'Päijät-Häme', '', 140, 'state', 1, 5, 140, 0, 0, 0, 0, 0, 'Europe', 'Finland', NULL, NULL, NULL, NULL),
(704, 'Pirkanmaa', '', 140, 'state', 1, 5, 140, 0, 0, 0, 0, 0, 'Europe', 'Finland', NULL, NULL, NULL, NULL),
(705, 'Pohjanmaa', '', 140, 'state', 1, 5, 140, 0, 0, 0, 0, 0, 'Europe', 'Finland', NULL, NULL, NULL, NULL),
(706, 'Pohjois-Karjala', '', 140, 'state', 1, 5, 140, 0, 0, 0, 0, 0, 'Europe', 'Finland', NULL, NULL, NULL, NULL),
(707, 'Pohjois-Pohjanmaa', '', 140, 'state', 1, 5, 140, 0, 0, 0, 0, 0, 'Europe', 'Finland', NULL, NULL, NULL, NULL),
(708, 'Pohjois-Savo', '', 140, 'state', 1, 5, 140, 0, 0, 0, 0, 0, 'Europe', 'Finland', NULL, NULL, NULL, NULL),
(709, 'Satakunta', '', 140, 'state', 1, 5, 140, 0, 0, 0, 0, 0, 'Europe', 'Finland', NULL, NULL, NULL, NULL),
(710, 'Uusimaa', '', 140, 'state', 1, 5, 140, 0, 0, 0, 0, 0, 'Europe', 'Finland', NULL, NULL, NULL, NULL),
(711, 'Varsinais-Suomi', '', 140, 'state', 1, 5, 140, 0, 0, 0, 0, 0, 'Europe', 'Finland', NULL, NULL, NULL, NULL),
(712, 'Alsace-Champagne-Ardenne-Lorraine', '', 142, 'state', 1, 5, 142, 0, 0, 0, 0, 0, 'Europe', 'France', NULL, NULL, NULL, NULL),
(713, 'Aquitaine-Limousin-Poitou-Charentes', '', 142, 'state', 1, 5, 142, 0, 0, 0, 0, 0, 'Europe', 'France', NULL, NULL, NULL, NULL),
(714, 'Auvergne-Rhône-Alpes', '', 142, 'state', 1, 5, 142, 0, 0, 0, 0, 0, 'Europe', 'France', NULL, NULL, NULL, NULL),
(715, 'Bourgogne-Franche-Comté', '', 142, 'state', 1, 5, 142, 0, 0, 0, 0, 0, 'Europe', 'France', NULL, NULL, NULL, NULL),
(716, 'Bretagne', '', 142, 'state', 1, 5, 142, 0, 0, 0, 0, 0, 'Europe', 'France', NULL, NULL, NULL, NULL),
(717, 'Centre', '', 142, 'state', 1, 5, 142, 0, 0, 0, 0, 0, 'Europe', 'France', NULL, NULL, NULL, NULL),
(718, 'Corse', '', 142, 'state', 1, 5, 142, 0, 0, 0, 0, 0, 'Europe', 'France', NULL, NULL, NULL, NULL),
(719, 'Île-de-France', '', 142, 'state', 1, 5, 142, 0, 0, 0, 0, 0, 'Europe', 'France', NULL, NULL, NULL, NULL),
(720, 'Languedoc-Roussillon-Midi-Pyrénées', '', 142, 'state', 1, 5, 142, 0, 0, 0, 0, 0, 'Europe', 'France', NULL, NULL, NULL, NULL),
(721, 'Nord-Pas-de-Calais-Picardie', '', 142, 'state', 1, 5, 142, 0, 0, 0, 0, 0, 'Europe', 'France', NULL, NULL, NULL, NULL),
(722, 'Normandy', '', 142, 'state', 1, 5, 142, 0, 0, 0, 0, 0, 'Europe', 'France', NULL, NULL, NULL, NULL),
(723, 'Pays de la Loire', '', 142, 'state', 1, 5, 142, 0, 0, 0, 0, 0, 'Europe', 'France', NULL, NULL, NULL, NULL),
(724, 'Provence-Alpes-Côte d''Azur', '', 142, 'state', 1, 5, 142, 0, 0, 0, 0, 0, 'Europe', 'France', NULL, NULL, NULL, NULL),
(725, 'England', '', 143, 'state', 1, 5, 143, 0, 0, 0, 0, 0, 'Europe', 'United Kingdom', NULL, NULL, NULL, NULL),
(726, 'Northern Ireland', '', 143, 'state', 1, 5, 143, 0, 0, 0, 0, 0, 'Europe', 'United Kingdom', NULL, NULL, NULL, NULL),
(727, 'Scotland', '', 143, 'state', 1, 5, 143, 0, 0, 0, 0, 0, 'Europe', 'United Kingdom', NULL, NULL, NULL, NULL),
(728, 'Wales', '', 143, 'state', 1, 5, 143, 0, 0, 0, 0, 0, 'Europe', 'United Kingdom', NULL, NULL, NULL, NULL),
(729, 'Bjelovarsko-Bilogorska', '', 147, 'state', 1, 5, 147, 0, 0, 0, 0, 0, 'Europe', 'Croatia', NULL, NULL, NULL, NULL),
(730, 'Brodsko-Posavska', '', 147, 'state', 1, 5, 147, 0, 0, 0, 0, 0, 'Europe', 'Croatia', NULL, NULL, NULL, NULL),
(731, 'Dubrovačko-Neretvanska', '', 147, 'state', 1, 5, 147, 0, 0, 0, 0, 0, 'Europe', 'Croatia', NULL, NULL, NULL, NULL),
(732, 'Istarska', '', 147, 'state', 1, 5, 147, 0, 0, 0, 0, 0, 'Europe', 'Croatia', NULL, NULL, NULL, NULL),
(733, 'Karlovačka', '', 147, 'state', 1, 5, 147, 0, 0, 0, 0, 0, 'Europe', 'Croatia', NULL, NULL, NULL, NULL),
(734, 'Koprivničko-Križevačka', '', 147, 'state', 1, 5, 147, 0, 0, 0, 0, 0, 'Europe', 'Croatia', NULL, NULL, NULL, NULL),
(735, 'Krapinsko-Zagorska', '', 147, 'state', 1, 5, 147, 0, 0, 0, 0, 0, 'Europe', 'Croatia', NULL, NULL, NULL, NULL),
(736, 'Ličko-Senjska', '', 147, 'state', 1, 5, 147, 0, 0, 0, 0, 0, 'Europe', 'Croatia', NULL, NULL, NULL, NULL),
(737, 'Međimurska', '', 147, 'state', 1, 5, 147, 0, 0, 0, 0, 0, 'Europe', 'Croatia', NULL, NULL, NULL, NULL),
(738, 'Osječko-Baranjska', '', 147, 'state', 1, 5, 147, 0, 0, 0, 0, 0, 'Europe', 'Croatia', NULL, NULL, NULL, NULL),
(739, 'Požeško-Slavonska', '', 147, 'state', 1, 5, 147, 0, 0, 0, 0, 0, 'Europe', 'Croatia', NULL, NULL, NULL, NULL),
(740, 'Primorsko-Goranska', '', 147, 'state', 1, 5, 147, 0, 0, 0, 0, 0, 'Europe', 'Croatia', NULL, NULL, NULL, NULL),
(741, 'Šibensko-Kninska', '', 147, 'state', 1, 5, 147, 0, 0, 0, 0, 0, 'Europe', 'Croatia', NULL, NULL, NULL, NULL),
(742, 'Sisačko-Moslavačka', '', 147, 'state', 1, 5, 147, 0, 0, 0, 0, 0, 'Europe', 'Croatia', NULL, NULL, NULL, NULL),
(743, 'Splitsko-Dalmatinska', '', 147, 'state', 1, 5, 147, 0, 0, 0, 0, 0, 'Europe', 'Croatia', NULL, NULL, NULL, NULL),
(744, 'Varaždinska', '', 147, 'state', 1, 5, 147, 0, 0, 0, 0, 0, 'Europe', 'Croatia', NULL, NULL, NULL, NULL),
(745, 'Virovitičko-Podravska', '', 147, 'state', 1, 5, 147, 0, 0, 0, 0, 0, 'Europe', 'Croatia', NULL, NULL, NULL, NULL),
(746, 'Vukovarsko-Srijemska', '', 147, 'state', 1, 5, 147, 0, 0, 0, 0, 0, 'Europe', 'Croatia', NULL, NULL, NULL, NULL),
(747, 'Zadarska', '', 147, 'state', 1, 5, 147, 0, 0, 0, 0, 0, 'Europe', 'Croatia', NULL, NULL, NULL, NULL),
(748, 'Zagrebačka', '', 147, 'state', 1, 5, 147, 0, 0, 0, 0, 0, 'Europe', 'Croatia', NULL, NULL, NULL, NULL),
(749, 'Bács-Kiskun', '', 148, 'state', 1, 5, 148, 0, 0, 0, 0, 0, 'Europe', 'Hungary', NULL, NULL, NULL, NULL),
(750, 'Baranya', '', 148, 'state', 1, 5, 148, 0, 0, 0, 0, 0, 'Europe', 'Hungary', NULL, NULL, NULL, NULL),
(751, 'Békés', '', 148, 'state', 1, 5, 148, 0, 0, 0, 0, 0, 'Europe', 'Hungary', NULL, NULL, NULL, NULL),
(752, 'Borsod-Abaúj-Zemplén', '', 148, 'state', 1, 5, 148, 0, 0, 0, 0, 0, 'Europe', 'Hungary', NULL, NULL, NULL, NULL),
(753, 'Budapest', '', 148, 'state', 1, 5, 148, 0, 0, 0, 0, 0, 'Europe', 'Hungary', NULL, NULL, NULL, NULL),
(754, 'Csongrád', '', 148, 'state', 1, 5, 148, 0, 0, 0, 0, 0, 'Europe', 'Hungary', NULL, NULL, NULL, NULL),
(755, 'Fejér', '', 148, 'state', 1, 5, 148, 0, 0, 0, 0, 0, 'Europe', 'Hungary', NULL, NULL, NULL, NULL),
(756, 'Győr-Moson-Sopron', '', 148, 'state', 1, 5, 148, 0, 0, 0, 0, 0, 'Europe', 'Hungary', NULL, NULL, NULL, NULL),
(757, 'Hajdú-Bihar', '', 148, 'state', 1, 5, 148, 0, 0, 0, 0, 0, 'Europe', 'Hungary', NULL, NULL, NULL, NULL),
(758, 'Heves', '', 148, 'state', 1, 5, 148, 0, 0, 0, 0, 0, 'Europe', 'Hungary', NULL, NULL, NULL, NULL),
(759, 'Jász-Nagykun-Szolnok', '', 148, 'state', 1, 5, 148, 0, 0, 0, 0, 0, 'Europe', 'Hungary', NULL, NULL, NULL, NULL),
(760, 'Komárom-Esztergom', '', 148, 'state', 1, 5, 148, 0, 0, 0, 0, 0, 'Europe', 'Hungary', NULL, NULL, NULL, NULL),
(761, 'Nógrád', '', 148, 'state', 1, 5, 148, 0, 0, 0, 0, 0, 'Europe', 'Hungary', NULL, NULL, NULL, NULL),
(762, 'Pest', '', 148, 'state', 1, 5, 148, 0, 0, 0, 0, 0, 'Europe', 'Hungary', NULL, NULL, NULL, NULL),
(763, 'Somogy', '', 148, 'state', 1, 5, 148, 0, 0, 0, 0, 0, 'Europe', 'Hungary', NULL, NULL, NULL, NULL),
(764, 'Szabolcs-Szatmár-Bereg', '', 148, 'state', 1, 5, 148, 0, 0, 0, 0, 0, 'Europe', 'Hungary', NULL, NULL, NULL, NULL),
(765, 'Tolna', '', 148, 'state', 1, 5, 148, 0, 0, 0, 0, 0, 'Europe', 'Hungary', NULL, NULL, NULL, NULL),
(766, 'Vas', '', 148, 'state', 1, 5, 148, 0, 0, 0, 0, 0, 'Europe', 'Hungary', NULL, NULL, NULL, NULL),
(767, 'Veszprém', '', 148, 'state', 1, 5, 148, 0, 0, 0, 0, 0, 'Europe', 'Hungary', NULL, NULL, NULL, NULL),
(768, 'Zala', '', 148, 'state', 1, 5, 148, 0, 0, 0, 0, 0, 'Europe', 'Hungary', NULL, NULL, NULL, NULL),
(769, 'Abruzzi', '', 152, 'state', 1, 5, 152, 0, 0, 0, 0, 0, 'Europe', 'Italy', NULL, NULL, NULL, NULL),
(770, 'Basilicata', '', 152, 'state', 1, 5, 152, 0, 0, 0, 0, 0, 'Europe', 'Italy', NULL, NULL, NULL, NULL),
(771, 'Calabria', '', 152, 'state', 1, 5, 152, 0, 0, 0, 0, 0, 'Europe', 'Italy', NULL, NULL, NULL, NULL),
(772, 'Campania', '', 152, 'state', 1, 5, 152, 0, 0, 0, 0, 0, 'Europe', 'Italy', NULL, NULL, NULL, NULL),
(773, 'Emilia-Romagna', '', 152, 'state', 1, 5, 152, 0, 0, 0, 0, 0, 'Europe', 'Italy', NULL, NULL, NULL, NULL),
(774, 'Friuli-Venezia Giulia', '', 152, 'state', 1, 5, 152, 0, 0, 0, 0, 0, 'Europe', 'Italy', NULL, NULL, NULL, NULL),
(775, 'Lazio', '', 152, 'state', 1, 5, 152, 0, 0, 0, 0, 0, 'Europe', 'Italy', NULL, NULL, NULL, NULL),
(776, 'Liguria', '', 152, 'state', 1, 5, 152, 0, 0, 0, 0, 0, 'Europe', 'Italy', NULL, NULL, NULL, NULL),
(777, 'Lombardia', '', 152, 'state', 1, 5, 152, 0, 0, 0, 0, 0, 'Europe', 'Italy', NULL, NULL, NULL, NULL),
(778, 'Marche', '', 152, 'state', 1, 5, 152, 0, 0, 0, 0, 0, 'Europe', 'Italy', NULL, NULL, NULL, NULL),
(779, 'Molise', '', 152, 'state', 1, 5, 152, 0, 0, 0, 0, 0, 'Europe', 'Italy', NULL, NULL, NULL, NULL),
(780, 'Piemonte', '', 152, 'state', 1, 5, 152, 0, 0, 0, 0, 0, 'Europe', 'Italy', NULL, NULL, NULL, NULL),
(781, 'Puglia', '', 152, 'state', 1, 5, 152, 0, 0, 0, 0, 0, 'Europe', 'Italy', NULL, NULL, NULL, NULL),
(782, 'Sardegna', '', 152, 'state', 1, 5, 152, 0, 0, 0, 0, 0, 'Europe', 'Italy', NULL, NULL, NULL, NULL),
(783, 'Sicilia', '', 152, 'state', 1, 5, 152, 0, 0, 0, 0, 0, 'Europe', 'Italy', NULL, NULL, NULL, NULL),
(784, 'Toscana', '', 152, 'state', 1, 5, 152, 0, 0, 0, 0, 0, 'Europe', 'Italy', NULL, NULL, NULL, NULL),
(785, 'Trentino-Alto Adige', '', 152, 'state', 1, 5, 152, 0, 0, 0, 0, 0, 'Europe', 'Italy', NULL, NULL, NULL, NULL),
(786, 'Umbria', '', 152, 'state', 1, 5, 152, 0, 0, 0, 0, 0, 'Europe', 'Italy', NULL, NULL, NULL, NULL),
(787, 'Valle D''Aosta', '', 152, 'state', 1, 5, 152, 0, 0, 0, 0, 0, 'Europe', 'Italy', NULL, NULL, NULL, NULL),
(788, 'Veneto', '', 152, 'state', 1, 5, 152, 0, 0, 0, 0, 0, 'Europe', 'Italy', NULL, NULL, NULL, NULL),
(789, 'Balzers', '', 154, 'state', 1, 5, 154, 0, 0, 0, 0, 0, 'Europe', 'Liechtenstein', NULL, NULL, NULL, NULL),
(790, 'Eschen', '', 154, 'state', 1, 5, 154, 0, 0, 0, 0, 0, 'Europe', 'Liechtenstein', NULL, NULL, NULL, NULL),
(791, 'Gamprin', '', 154, 'state', 1, 5, 154, 0, 0, 0, 0, 0, 'Europe', 'Liechtenstein', NULL, NULL, NULL, NULL),
(792, 'Mauren', '', 154, 'state', 1, 5, 154, 0, 0, 0, 0, 0, 'Europe', 'Liechtenstein', NULL, NULL, NULL, NULL),
(793, 'Planken', '', 154, 'state', 1, 5, 154, 0, 0, 0, 0, 0, 'Europe', 'Liechtenstein', NULL, NULL, NULL, NULL),
(794, 'Ruggell', '', 154, 'state', 1, 5, 154, 0, 0, 0, 0, 0, 'Europe', 'Liechtenstein', NULL, NULL, NULL, NULL),
(795, 'Schaan', '', 154, 'state', 1, 5, 154, 0, 0, 0, 0, 0, 'Europe', 'Liechtenstein', NULL, NULL, NULL, NULL),
(796, 'Schellenberg', '', 154, 'state', 1, 5, 154, 0, 0, 0, 0, 0, 'Europe', 'Liechtenstein', NULL, NULL, NULL, NULL),
(797, 'Triesen', '', 154, 'state', 1, 5, 154, 0, 0, 0, 0, 0, 'Europe', 'Liechtenstein', NULL, NULL, NULL, NULL),
(798, 'Triesenberg', '', 154, 'state', 1, 5, 154, 0, 0, 0, 0, 0, 'Europe', 'Liechtenstein', NULL, NULL, NULL, NULL),
(799, 'Vaduz', '', 154, 'state', 1, 5, 154, 0, 0, 0, 0, 0, 'Europe', 'Liechtenstein', NULL, NULL, NULL, NULL),
(800, 'Monaco', '', 158, 'state', 1, 5, 158, 0, 0, 0, 0, 0, 'Europe', 'Monaco', NULL, NULL, NULL, NULL),
(801, 'Anenii Noi', '', 159, 'state', 1, 5, 159, 0, 0, 0, 0, 0, 'Europe', 'Moldova', NULL, NULL, NULL, NULL),
(802, 'Balti', '', 159, 'state', 1, 5, 159, 0, 0, 0, 0, 0, 'Europe', 'Moldova', NULL, NULL, NULL, NULL),
(803, 'Bender Tr.', '', 159, 'state', 1, 5, 159, 0, 0, 0, 0, 0, 'Europe', 'Moldova', NULL, NULL, NULL, NULL),
(804, 'Briceni', '', 159, 'state', 1, 5, 159, 0, 0, 0, 0, 0, 'Europe', 'Moldova', NULL, NULL, NULL, NULL),
(805, 'Cahul', '', 159, 'state', 1, 5, 159, 0, 0, 0, 0, 0, 'Europe', 'Moldova', NULL, NULL, NULL, NULL),
(806, 'Calarasi', '', 159, 'state', 1, 5, 159, 0, 0, 0, 0, 0, 'Europe', 'Moldova', NULL, NULL, NULL, NULL),
(807, 'Camenca Tr.', '', 159, 'state', 1, 5, 159, 0, 0, 0, 0, 0, 'Europe', 'Moldova', NULL, NULL, NULL, NULL),
(808, 'Cantemir', '', 159, 'state', 1, 5, 159, 0, 0, 0, 0, 0, 'Europe', 'Moldova', NULL, NULL, NULL, NULL),
(809, 'Cantrmir', '', 159, 'state', 1, 5, 159, 0, 0, 0, 0, 0, 'Europe', 'Moldova', NULL, NULL, NULL, NULL),
(810, 'Canul', '', 159, 'state', 1, 5, 159, 0, 0, 0, 0, 0, 'Europe', 'Moldova', NULL, NULL, NULL, NULL),
(811, 'Causeni', '', 159, 'state', 1, 5, 159, 0, 0, 0, 0, 0, 'Europe', 'Moldova', NULL, NULL, NULL, NULL),
(812, 'Cimislia', '', 159, 'state', 1, 5, 159, 0, 0, 0, 0, 0, 'Europe', 'Moldova', NULL, NULL, NULL, NULL),
(813, 'Comrat', '', 159, 'state', 1, 5, 159, 0, 0, 0, 0, 0, 'Europe', 'Moldova', NULL, NULL, NULL, NULL),
(814, 'Criuleni', '', 159, 'state', 1, 5, 159, 0, 0, 0, 0, 0, 'Europe', 'Moldova', NULL, NULL, NULL, NULL),
(815, 'Criuleni- Dub.', '', 159, 'state', 1, 5, 159, 0, 0, 0, 0, 0, 'Europe', 'Moldova', NULL, NULL, NULL, NULL),
(816, 'Criuleni-Dub.', '', 159, 'state', 1, 5, 159, 0, 0, 0, 0, 0, 'Europe', 'Moldova', NULL, NULL, NULL, NULL),
(817, 'Criulenii-Dub.', '', 159, 'state', 1, 5, 159, 0, 0, 0, 0, 0, 'Europe', 'Moldova', NULL, NULL, NULL, NULL),
(818, 'Donduseni', '', 159, 'state', 1, 5, 159, 0, 0, 0, 0, 0, 'Europe', 'Moldova', NULL, NULL, NULL, NULL),
(819, 'Drochia', '', 159, 'state', 1, 5, 159, 0, 0, 0, 0, 0, 'Europe', 'Moldova', NULL, NULL, NULL, NULL),
(820, 'Dubasari Cr.', '', 159, 'state', 1, 5, 159, 0, 0, 0, 0, 0, 'Europe', 'Moldova', NULL, NULL, NULL, NULL),
(821, 'Dubasari Tr.', '', 159, 'state', 1, 5, 159, 0, 0, 0, 0, 0, 'Europe', 'Moldova', NULL, NULL, NULL, NULL),
(822, 'Edinet', '', 159, 'state', 1, 5, 159, 0, 0, 0, 0, 0, 'Europe', 'Moldova', NULL, NULL, NULL, NULL),
(823, 'Falesti', '', 159, 'state', 1, 5, 159, 0, 0, 0, 0, 0, 'Europe', 'Moldova', NULL, NULL, NULL, NULL),
(824, 'Floresti', '', 159, 'state', 1, 5, 159, 0, 0, 0, 0, 0, 'Europe', 'Moldova', NULL, NULL, NULL, NULL),
(825, 'Glodeni', '', 159, 'state', 1, 5, 159, 0, 0, 0, 0, 0, 'Europe', 'Moldova', NULL, NULL, NULL, NULL),
(826, 'Grigoriopol Tr.', '', 159, 'state', 1, 5, 159, 0, 0, 0, 0, 0, 'Europe', 'Moldova', NULL, NULL, NULL, NULL),
(827, 'Hincesti', '', 159, 'state', 1, 5, 159, 0, 0, 0, 0, 0, 'Europe', 'Moldova', NULL, NULL, NULL, NULL),
(828, 'Ialoveni', '', 159, 'state', 1, 5, 159, 0, 0, 0, 0, 0, 'Europe', 'Moldova', NULL, NULL, NULL, NULL),
(829, 'Lazo', '', 159, 'state', 1, 5, 159, 0, 0, 0, 0, 0, 'Europe', 'Moldova', NULL, NULL, NULL, NULL),
(830, 'Leova', '', 159, 'state', 1, 5, 159, 0, 0, 0, 0, 0, 'Europe', 'Moldova', NULL, NULL, NULL, NULL),
(831, 'Mun.Balti', '', 159, 'state', 1, 5, 159, 0, 0, 0, 0, 0, 'Europe', 'Moldova', NULL, NULL, NULL, NULL),
(832, 'Mun.Chisinau', '', 159, 'state', 1, 5, 159, 0, 0, 0, 0, 0, 'Europe', 'Moldova', NULL, NULL, NULL, NULL),
(833, 'Nisporeni', '', 159, 'state', 1, 5, 159, 0, 0, 0, 0, 0, 'Europe', 'Moldova', NULL, NULL, NULL, NULL),
(834, 'Ocnita', '', 159, 'state', 1, 5, 159, 0, 0, 0, 0, 0, 'Europe', 'Moldova', NULL, NULL, NULL, NULL),
(835, 'Orhei', '', 159, 'state', 1, 5, 159, 0, 0, 0, 0, 0, 'Europe', 'Moldova', NULL, NULL, NULL, NULL),
(836, 'Rezina', '', 159, 'state', 1, 5, 159, 0, 0, 0, 0, 0, 'Europe', 'Moldova', NULL, NULL, NULL, NULL),
(837, 'Ribnita Tr.', '', 159, 'state', 1, 5, 159, 0, 0, 0, 0, 0, 'Europe', 'Moldova', NULL, NULL, NULL, NULL),
(838, 'Riscani', '', 159, 'state', 1, 5, 159, 0, 0, 0, 0, 0, 'Europe', 'Moldova', NULL, NULL, NULL, NULL),
(839, 'Singerei', '', 159, 'state', 1, 5, 159, 0, 0, 0, 0, 0, 'Europe', 'Moldova', NULL, NULL, NULL, NULL),
(840, 'Slobozia Tr.', '', 159, 'state', 1, 5, 159, 0, 0, 0, 0, 0, 'Europe', 'Moldova', NULL, NULL, NULL, NULL),
(841, 'Soldanesti', '', 159, 'state', 1, 5, 159, 0, 0, 0, 0, 0, 'Europe', 'Moldova', NULL, NULL, NULL, NULL),
(842, 'Soroca', '', 159, 'state', 1, 5, 159, 0, 0, 0, 0, 0, 'Europe', 'Moldova', NULL, NULL, NULL, NULL),
(843, 'Stefan-Voda', '', 159, 'state', 1, 5, 159, 0, 0, 0, 0, 0, 'Europe', 'Moldova', NULL, NULL, NULL, NULL),
(844, 'Straseni', '', 159, 'state', 1, 5, 159, 0, 0, 0, 0, 0, 'Europe', 'Moldova', NULL, NULL, NULL, NULL),
(845, 'Taraclia', '', 159, 'state', 1, 5, 159, 0, 0, 0, 0, 0, 'Europe', 'Moldova', NULL, NULL, NULL, NULL),
(846, 'Telenesti', '', 159, 'state', 1, 5, 159, 0, 0, 0, 0, 0, 'Europe', 'Moldova', NULL, NULL, NULL, NULL),
(847, 'Tiraspol Tr.', '', 159, 'state', 1, 5, 159, 0, 0, 0, 0, 0, 'Europe', 'Moldova', NULL, NULL, NULL, NULL),
(848, 'Uhnheni', '', 159, 'state', 1, 5, 159, 0, 0, 0, 0, 0, 'Europe', 'Moldova', NULL, NULL, NULL, NULL),
(849, 'Ungheni', '', 159, 'state', 1, 5, 159, 0, 0, 0, 0, 0, 'Europe', 'Moldova', NULL, NULL, NULL, NULL),
(850, 'Attard', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(851, 'Balzan', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(852, 'Birkirkara', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(853, 'Birżebbuġa', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(854, 'Bormla', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(855, 'Dingli', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(856, 'Għajnsielem', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(857, 'Ħal Għargħur', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(858, 'Ħal Għaxaq', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(859, 'Ħaż-Żabbar', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(860, 'Ħaż-Żebbuġ', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(861, 'Il-Belt Valletta', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(862, 'Il-Birgu', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(863, 'Il-Fgura', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(864, 'Il-Fontana', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(865, 'Il-Furjana', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(866, 'Il-Gudja', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(867, 'Il-Gżira', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(868, 'Il-Ħamrun', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(869, 'Il-Kalkara', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(870, 'Il-Marsa', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(871, 'Il-Mellieħa', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(872, 'Il-Mosta', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(873, 'Il-Munxar', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(874, 'Il-Qala', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(875, 'Il-Qrendi', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(876, 'In-Nadur', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(877, 'In-Naxxar', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(878, 'Ir-Rabat', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(879, 'Is-Siġġiewi', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(880, 'Is-Swieqi', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(881, 'Ix-Xagħra', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(882, 'Ix-Xewkija', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(883, 'Ix-Xgħajra', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(884, 'Iż-Żebbuġ', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(885, 'Iż-Żejtun', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(886, 'Iż-Żurrieq', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(887, 'Kirkop', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(888, 'L-Għarb', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(889, 'L-Għasri', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(890, 'L-Iklin', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(891, 'L-Imdina', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(892, 'L-Imġarr', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(893, 'L-Imqabba', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(894, 'L-Imsida', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(895, 'L-Imtarfa', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(896, 'L-Isla', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(897, 'Lija', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(898, 'Luqa', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(899, 'Marsaskala', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(900, 'Marsaxlokk', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(901, 'Paola', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(902, 'Pembroke', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(903, 'Qormi', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(904, 'Safi', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(905, 'Saint John', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(906, 'Saint Julian''s', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(907, 'Saint Lawrence', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(908, 'Saint Lucia', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(909, 'Saint Paul’s Bay', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(910, 'Saint Venera', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(911, 'Sannat', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(912, 'Ta’ Kerċem', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(913, 'Ta’ Xbiex', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(914, 'Tal-Pietà', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(915, 'Tarxien', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(916, 'Tas-Sliema', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(917, 'Victoria', '', 162, 'state', 1, 5, 162, 0, 0, 0, 0, 0, 'Europe', 'Malta', NULL, NULL, NULL, NULL),
(918, 'Provincie Drenthe', '', 163, 'state', 1, 5, 163, 0, 0, 0, 0, 0, 'Europe', 'Netherlands', NULL, NULL, NULL, NULL),
(919, 'Provincie Flevoland', '', 163, 'state', 1, 5, 163, 0, 0, 0, 0, 0, 'Europe', 'Netherlands', NULL, NULL, NULL, NULL),
(920, 'Provincie Friesland', '', 163, 'state', 1, 5, 163, 0, 0, 0, 0, 0, 'Europe', 'Netherlands', NULL, NULL, NULL, NULL),
(921, 'Provincie Gelderland', '', 163, 'state', 1, 5, 163, 0, 0, 0, 0, 0, 'Europe', 'Netherlands', NULL, NULL, NULL, NULL),
(922, 'Provincie Groningen', '', 163, 'state', 1, 5, 163, 0, 0, 0, 0, 0, 'Europe', 'Netherlands', NULL, NULL, NULL, NULL),
(923, 'Provincie Limburg', '', 163, 'state', 1, 5, 163, 0, 0, 0, 0, 0, 'Europe', 'Netherlands', NULL, NULL, NULL, NULL),
(924, 'Provincie Noord-Brabant', '', 163, 'state', 1, 5, 163, 0, 0, 0, 0, 0, 'Europe', 'Netherlands', NULL, NULL, NULL, NULL),
(925, 'Provincie Noord-Holland', '', 163, 'state', 1, 5, 163, 0, 0, 0, 0, 0, 'Europe', 'Netherlands', NULL, NULL, NULL, NULL),
(926, 'Provincie Overijssel', '', 163, 'state', 1, 5, 163, 0, 0, 0, 0, 0, 'Europe', 'Netherlands', NULL, NULL, NULL, NULL),
(927, 'Provincie Utrecht', '', 163, 'state', 1, 5, 163, 0, 0, 0, 0, 0, 'Europe', 'Netherlands', NULL, NULL, NULL, NULL),
(928, 'Provincie Zeeland', '', 163, 'state', 1, 5, 163, 0, 0, 0, 0, 0, 'Europe', 'Netherlands', NULL, NULL, NULL, NULL),
(929, 'Provincie Zuid-Holland', '', 163, 'state', 1, 5, 163, 0, 0, 0, 0, 0, 'Europe', 'Netherlands', NULL, NULL, NULL, NULL),
(930, 'Akershus', '', 164, 'state', 1, 5, 164, 0, 0, 0, 0, 0, 'Europe', 'Norway', NULL, NULL, NULL, NULL),
(931, 'Aust-Agder', '', 164, 'state', 1, 5, 164, 0, 0, 0, 0, 0, 'Europe', 'Norway', NULL, NULL, NULL, NULL),
(932, 'Buskerud', '', 164, 'state', 1, 5, 164, 0, 0, 0, 0, 0, 'Europe', 'Norway', NULL, NULL, NULL, NULL),
(933, 'Finnmark', '', 164, 'state', 1, 5, 164, 0, 0, 0, 0, 0, 'Europe', 'Norway', NULL, NULL, NULL, NULL),
(934, 'Hedmark', '', 164, 'state', 1, 5, 164, 0, 0, 0, 0, 0, 'Europe', 'Norway', NULL, NULL, NULL, NULL),
(935, 'Hordaland', '', 164, 'state', 1, 5, 164, 0, 0, 0, 0, 0, 'Europe', 'Norway', NULL, NULL, NULL, NULL),
(936, 'More og Romdal', '', 164, 'state', 1, 5, 164, 0, 0, 0, 0, 0, 'Europe', 'Norway', NULL, NULL, NULL, NULL),
(937, 'Nord-Trondelag', '', 164, 'state', 1, 5, 164, 0, 0, 0, 0, 0, 'Europe', 'Norway', NULL, NULL, NULL, NULL);
INSERT IGNORE INTO `#__sellacious_locations` (`id`, `title`, `iso_code`, `parent_id`, `type`, `state`, `continent_id`, `country_id`, `state_id`, `district_id`, `area_id`, `zip_id`, `new_id`, `continent_title`, `country_title`, `state_title`, `district_title`, `area_title`, `zip_title`) VALUES
(938, 'Nordland', '', 164, 'state', 1, 5, 164, 0, 0, 0, 0, 0, 'Europe', 'Norway', NULL, NULL, NULL, NULL),
(939, 'Oppland', '', 164, 'state', 1, 5, 164, 0, 0, 0, 0, 0, 'Europe', 'Norway', NULL, NULL, NULL, NULL),
(940, 'Oslo', '', 164, 'state', 1, 5, 164, 0, 0, 0, 0, 0, 'Europe', 'Norway', NULL, NULL, NULL, NULL),
(941, 'Ostfold', '', 164, 'state', 1, 5, 164, 0, 0, 0, 0, 0, 'Europe', 'Norway', NULL, NULL, NULL, NULL),
(942, 'Rogaland', '', 164, 'state', 1, 5, 164, 0, 0, 0, 0, 0, 'Europe', 'Norway', NULL, NULL, NULL, NULL),
(943, 'Sogn og Fjordane', '', 164, 'state', 1, 5, 164, 0, 0, 0, 0, 0, 'Europe', 'Norway', NULL, NULL, NULL, NULL),
(944, 'Sor-Trondelag', '', 164, 'state', 1, 5, 164, 0, 0, 0, 0, 0, 'Europe', 'Norway', NULL, NULL, NULL, NULL),
(945, 'Telemark', '', 164, 'state', 1, 5, 164, 0, 0, 0, 0, 0, 'Europe', 'Norway', NULL, NULL, NULL, NULL),
(946, 'Troms', '', 164, 'state', 1, 5, 164, 0, 0, 0, 0, 0, 'Europe', 'Norway', NULL, NULL, NULL, NULL),
(947, 'Vest-Agder', '', 164, 'state', 1, 5, 164, 0, 0, 0, 0, 0, 'Europe', 'Norway', NULL, NULL, NULL, NULL),
(948, 'Vestfold', '', 164, 'state', 1, 5, 164, 0, 0, 0, 0, 0, 'Europe', 'Norway', NULL, NULL, NULL, NULL),
(949, 'Dolnośląskie', '', 165, 'state', 1, 5, 165, 0, 0, 0, 0, 0, 'Europe', 'Poland', NULL, NULL, NULL, NULL),
(950, 'Kujawsko-Pomorskie', '', 165, 'state', 1, 5, 165, 0, 0, 0, 0, 0, 'Europe', 'Poland', NULL, NULL, NULL, NULL),
(951, 'Lubelskie', '', 165, 'state', 1, 5, 165, 0, 0, 0, 0, 0, 'Europe', 'Poland', NULL, NULL, NULL, NULL),
(952, 'Lubuskie', '', 165, 'state', 1, 5, 165, 0, 0, 0, 0, 0, 'Europe', 'Poland', NULL, NULL, NULL, NULL),
(953, 'Łódzkie', '', 165, 'state', 1, 5, 165, 0, 0, 0, 0, 0, 'Europe', 'Poland', NULL, NULL, NULL, NULL),
(954, 'Małopolskie', '', 165, 'state', 1, 5, 165, 0, 0, 0, 0, 0, 'Europe', 'Poland', NULL, NULL, NULL, NULL),
(955, 'Mazowieckie', '', 165, 'state', 1, 5, 165, 0, 0, 0, 0, 0, 'Europe', 'Poland', NULL, NULL, NULL, NULL),
(956, 'Opolskie', '', 165, 'state', 1, 5, 165, 0, 0, 0, 0, 0, 'Europe', 'Poland', NULL, NULL, NULL, NULL),
(957, 'Podkarpackie', '', 165, 'state', 1, 5, 165, 0, 0, 0, 0, 0, 'Europe', 'Poland', NULL, NULL, NULL, NULL),
(958, 'Podlaskie', '', 165, 'state', 1, 5, 165, 0, 0, 0, 0, 0, 'Europe', 'Poland', NULL, NULL, NULL, NULL),
(959, 'Pomorskie', '', 165, 'state', 1, 5, 165, 0, 0, 0, 0, 0, 'Europe', 'Poland', NULL, NULL, NULL, NULL),
(960, 'Śląskie', '', 165, 'state', 1, 5, 165, 0, 0, 0, 0, 0, 'Europe', 'Poland', NULL, NULL, NULL, NULL),
(961, 'Świętokrzyskie', '', 165, 'state', 1, 5, 165, 0, 0, 0, 0, 0, 'Europe', 'Poland', NULL, NULL, NULL, NULL),
(962, 'Warmińsko-Mazurskie', '', 165, 'state', 1, 5, 165, 0, 0, 0, 0, 0, 'Europe', 'Poland', NULL, NULL, NULL, NULL),
(963, 'Wielkopolskie', '', 165, 'state', 1, 5, 165, 0, 0, 0, 0, 0, 'Europe', 'Poland', NULL, NULL, NULL, NULL),
(964, 'Zachodniopomorskie', '', 165, 'state', 1, 5, 165, 0, 0, 0, 0, 0, 'Europe', 'Poland', NULL, NULL, NULL, NULL),
(965, 'Aveiro', '', 166, 'state', 1, 5, 166, 0, 0, 0, 0, 0, 'Europe', 'Portugal', NULL, NULL, NULL, NULL),
(966, 'Beja', '', 166, 'state', 1, 5, 166, 0, 0, 0, 0, 0, 'Europe', 'Portugal', NULL, NULL, NULL, NULL),
(967, 'Braga', '', 166, 'state', 1, 5, 166, 0, 0, 0, 0, 0, 'Europe', 'Portugal', NULL, NULL, NULL, NULL),
(968, 'Bragança', '', 166, 'state', 1, 5, 166, 0, 0, 0, 0, 0, 'Europe', 'Portugal', NULL, NULL, NULL, NULL),
(969, 'Castelo Branco', '', 166, 'state', 1, 5, 166, 0, 0, 0, 0, 0, 'Europe', 'Portugal', NULL, NULL, NULL, NULL),
(970, 'Coimbra', '', 166, 'state', 1, 5, 166, 0, 0, 0, 0, 0, 'Europe', 'Portugal', NULL, NULL, NULL, NULL),
(971, 'Évora', '', 166, 'state', 1, 5, 166, 0, 0, 0, 0, 0, 'Europe', 'Portugal', NULL, NULL, NULL, NULL),
(972, 'Faro', '', 166, 'state', 1, 5, 166, 0, 0, 0, 0, 0, 'Europe', 'Portugal', NULL, NULL, NULL, NULL),
(973, 'Guarda', '', 166, 'state', 1, 5, 166, 0, 0, 0, 0, 0, 'Europe', 'Portugal', NULL, NULL, NULL, NULL),
(974, 'Ilha da Graciosa', '', 166, 'state', 1, 5, 166, 0, 0, 0, 0, 0, 'Europe', 'Portugal', NULL, NULL, NULL, NULL),
(975, 'Ilha da Madeira', '', 166, 'state', 1, 5, 166, 0, 0, 0, 0, 0, 'Europe', 'Portugal', NULL, NULL, NULL, NULL),
(976, 'Ilha das Flores', '', 166, 'state', 1, 5, 166, 0, 0, 0, 0, 0, 'Europe', 'Portugal', NULL, NULL, NULL, NULL),
(977, 'Ilha de Porto Santo', '', 166, 'state', 1, 5, 166, 0, 0, 0, 0, 0, 'Europe', 'Portugal', NULL, NULL, NULL, NULL),
(978, 'Ilha de Santa Maria', '', 166, 'state', 1, 5, 166, 0, 0, 0, 0, 0, 'Europe', 'Portugal', NULL, NULL, NULL, NULL),
(979, 'Ilha de São Jorge', '', 166, 'state', 1, 5, 166, 0, 0, 0, 0, 0, 'Europe', 'Portugal', NULL, NULL, NULL, NULL),
(980, 'Ilha de São Miguel', '', 166, 'state', 1, 5, 166, 0, 0, 0, 0, 0, 'Europe', 'Portugal', NULL, NULL, NULL, NULL),
(981, 'Ilha do Corvo', '', 166, 'state', 1, 5, 166, 0, 0, 0, 0, 0, 'Europe', 'Portugal', NULL, NULL, NULL, NULL),
(982, 'Ilha do Faial', '', 166, 'state', 1, 5, 166, 0, 0, 0, 0, 0, 'Europe', 'Portugal', NULL, NULL, NULL, NULL),
(983, 'Ilha do Pico', '', 166, 'state', 1, 5, 166, 0, 0, 0, 0, 0, 'Europe', 'Portugal', NULL, NULL, NULL, NULL),
(984, 'Ilha Terceira', '', 166, 'state', 1, 5, 166, 0, 0, 0, 0, 0, 'Europe', 'Portugal', NULL, NULL, NULL, NULL),
(985, 'Leiria', '', 166, 'state', 1, 5, 166, 0, 0, 0, 0, 0, 'Europe', 'Portugal', NULL, NULL, NULL, NULL),
(986, 'Lisboa', '', 166, 'state', 1, 5, 166, 0, 0, 0, 0, 0, 'Europe', 'Portugal', NULL, NULL, NULL, NULL),
(987, 'Portalegre', '', 166, 'state', 1, 5, 166, 0, 0, 0, 0, 0, 'Europe', 'Portugal', NULL, NULL, NULL, NULL),
(988, 'Porto', '', 166, 'state', 1, 5, 166, 0, 0, 0, 0, 0, 'Europe', 'Portugal', NULL, NULL, NULL, NULL),
(989, 'Santarém', '', 166, 'state', 1, 5, 166, 0, 0, 0, 0, 0, 'Europe', 'Portugal', NULL, NULL, NULL, NULL),
(990, 'Setúbal', '', 166, 'state', 1, 5, 166, 0, 0, 0, 0, 0, 'Europe', 'Portugal', NULL, NULL, NULL, NULL),
(991, 'Viana do Castelo', '', 166, 'state', 1, 5, 166, 0, 0, 0, 0, 0, 'Europe', 'Portugal', NULL, NULL, NULL, NULL),
(992, 'Vila Real', '', 166, 'state', 1, 5, 166, 0, 0, 0, 0, 0, 'Europe', 'Portugal', NULL, NULL, NULL, NULL),
(993, 'Viseu', '', 166, 'state', 1, 5, 166, 0, 0, 0, 0, 0, 'Europe', 'Portugal', NULL, NULL, NULL, NULL),
(994, 'Arad', '', 167, 'state', 1, 5, 167, 0, 0, 0, 0, 0, 'Europe', 'Romania', NULL, NULL, NULL, NULL),
(995, 'Bihor', '', 167, 'state', 1, 5, 167, 0, 0, 0, 0, 0, 'Europe', 'Romania', NULL, NULL, NULL, NULL),
(996, 'Covasna', '', 167, 'state', 1, 5, 167, 0, 0, 0, 0, 0, 'Europe', 'Romania', NULL, NULL, NULL, NULL),
(997, 'Dolj', '', 167, 'state', 1, 5, 167, 0, 0, 0, 0, 0, 'Europe', 'Romania', NULL, NULL, NULL, NULL),
(998, 'Giurgiu', '', 167, 'state', 1, 5, 167, 0, 0, 0, 0, 0, 'Europe', 'Romania', NULL, NULL, NULL, NULL),
(999, 'Gorj', '', 167, 'state', 1, 5, 167, 0, 0, 0, 0, 0, 'Europe', 'Romania', NULL, NULL, NULL, NULL),
(1000, 'Harghita', '', 167, 'state', 1, 5, 167, 0, 0, 0, 0, 0, 'Europe', 'Romania', NULL, NULL, NULL, NULL),
(1001, 'Hunedoara', '', 167, 'state', 1, 5, 167, 0, 0, 0, 0, 0, 'Europe', 'Romania', NULL, NULL, NULL, NULL),
(1002, 'Ilfov', '', 167, 'state', 1, 5, 167, 0, 0, 0, 0, 0, 'Europe', 'Romania', NULL, NULL, NULL, NULL),
(1003, 'Judeţul Alba', '', 167, 'state', 1, 5, 167, 0, 0, 0, 0, 0, 'Europe', 'Romania', NULL, NULL, NULL, NULL),
(1004, 'Judeţul Argeş', '', 167, 'state', 1, 5, 167, 0, 0, 0, 0, 0, 'Europe', 'Romania', NULL, NULL, NULL, NULL),
(1005, 'Judeţul Bacău', '', 167, 'state', 1, 5, 167, 0, 0, 0, 0, 0, 'Europe', 'Romania', NULL, NULL, NULL, NULL),
(1006, 'Judeţul Bistriţa-Năsăud', '', 167, 'state', 1, 5, 167, 0, 0, 0, 0, 0, 'Europe', 'Romania', NULL, NULL, NULL, NULL),
(1007, 'Judeţul Botoşani', '', 167, 'state', 1, 5, 167, 0, 0, 0, 0, 0, 'Europe', 'Romania', NULL, NULL, NULL, NULL),
(1008, 'Judeţul Brăila', '', 167, 'state', 1, 5, 167, 0, 0, 0, 0, 0, 'Europe', 'Romania', NULL, NULL, NULL, NULL),
(1009, 'Judeţul Braşov', '', 167, 'state', 1, 5, 167, 0, 0, 0, 0, 0, 'Europe', 'Romania', NULL, NULL, NULL, NULL),
(1010, 'Judeţul Buzău', '', 167, 'state', 1, 5, 167, 0, 0, 0, 0, 0, 'Europe', 'Romania', NULL, NULL, NULL, NULL),
(1011, 'Judeţul Călăraşi', '', 167, 'state', 1, 5, 167, 0, 0, 0, 0, 0, 'Europe', 'Romania', NULL, NULL, NULL, NULL),
(1012, 'Judeţul Caraş-Severin', '', 167, 'state', 1, 5, 167, 0, 0, 0, 0, 0, 'Europe', 'Romania', NULL, NULL, NULL, NULL),
(1013, 'Judeţul Cluj', '', 167, 'state', 1, 5, 167, 0, 0, 0, 0, 0, 'Europe', 'Romania', NULL, NULL, NULL, NULL),
(1014, 'Judeţul Constanţa', '', 167, 'state', 1, 5, 167, 0, 0, 0, 0, 0, 'Europe', 'Romania', NULL, NULL, NULL, NULL),
(1015, 'Judeţul Dâmboviţa', '', 167, 'state', 1, 5, 167, 0, 0, 0, 0, 0, 'Europe', 'Romania', NULL, NULL, NULL, NULL),
(1016, 'Judeţul Galaţi', '', 167, 'state', 1, 5, 167, 0, 0, 0, 0, 0, 'Europe', 'Romania', NULL, NULL, NULL, NULL),
(1017, 'Judeţul Ialomiţa', '', 167, 'state', 1, 5, 167, 0, 0, 0, 0, 0, 'Europe', 'Romania', NULL, NULL, NULL, NULL),
(1018, 'Judeţul Iaşi', '', 167, 'state', 1, 5, 167, 0, 0, 0, 0, 0, 'Europe', 'Romania', NULL, NULL, NULL, NULL),
(1019, 'Judeţul Maramureş', '', 167, 'state', 1, 5, 167, 0, 0, 0, 0, 0, 'Europe', 'Romania', NULL, NULL, NULL, NULL),
(1020, 'Judeţul Mehedinţi', '', 167, 'state', 1, 5, 167, 0, 0, 0, 0, 0, 'Europe', 'Romania', NULL, NULL, NULL, NULL),
(1021, 'Judeţul Mureş', '', 167, 'state', 1, 5, 167, 0, 0, 0, 0, 0, 'Europe', 'Romania', NULL, NULL, NULL, NULL),
(1022, 'Judeţul Neamţ', '', 167, 'state', 1, 5, 167, 0, 0, 0, 0, 0, 'Europe', 'Romania', NULL, NULL, NULL, NULL),
(1023, 'Judeţul Sălaj', '', 167, 'state', 1, 5, 167, 0, 0, 0, 0, 0, 'Europe', 'Romania', NULL, NULL, NULL, NULL),
(1024, 'Judeţul Sibiu', '', 167, 'state', 1, 5, 167, 0, 0, 0, 0, 0, 'Europe', 'Romania', NULL, NULL, NULL, NULL),
(1025, 'Judeţul Timiş', '', 167, 'state', 1, 5, 167, 0, 0, 0, 0, 0, 'Europe', 'Romania', NULL, NULL, NULL, NULL),
(1026, 'Judeţul Vâlcea', '', 167, 'state', 1, 5, 167, 0, 0, 0, 0, 0, 'Europe', 'Romania', NULL, NULL, NULL, NULL),
(1027, 'Olt', '', 167, 'state', 1, 5, 167, 0, 0, 0, 0, 0, 'Europe', 'Romania', NULL, NULL, NULL, NULL),
(1028, 'Prahova', '', 167, 'state', 1, 5, 167, 0, 0, 0, 0, 0, 'Europe', 'Romania', NULL, NULL, NULL, NULL),
(1029, 'Satu Mare', '', 167, 'state', 1, 5, 167, 0, 0, 0, 0, 0, 'Europe', 'Romania', NULL, NULL, NULL, NULL),
(1030, 'Suceava', '', 167, 'state', 1, 5, 167, 0, 0, 0, 0, 0, 'Europe', 'Romania', NULL, NULL, NULL, NULL),
(1031, 'Teleorman', '', 167, 'state', 1, 5, 167, 0, 0, 0, 0, 0, 'Europe', 'Romania', NULL, NULL, NULL, NULL),
(1032, 'Tulcea', '', 167, 'state', 1, 5, 167, 0, 0, 0, 0, 0, 'Europe', 'Romania', NULL, NULL, NULL, NULL),
(1033, 'Vaslui', '', 167, 'state', 1, 5, 167, 0, 0, 0, 0, 0, 'Europe', 'Romania', NULL, NULL, NULL, NULL),
(1034, 'Vrancea', '', 167, 'state', 1, 5, 167, 0, 0, 0, 0, 0, 'Europe', 'Romania', NULL, NULL, NULL, NULL),
(1035, 'Адыгея Республика', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1036, 'Алтай Республика', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1037, 'Алтайский Край', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1038, 'Амурская Область', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1039, 'Архангельская Область', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1040, 'Астраханская Область', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1041, 'Байконур', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1042, 'Башкортостан Республика', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1043, 'Белгородская Область', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1044, 'Брянская Область', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1045, 'Бурятия Республика', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1046, 'Владимирская Область', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1047, 'Волгоградская Область', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1048, 'Вологодская Область', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1049, 'Воронежская Область', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1050, 'Дагестан Республика', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1051, 'Ивановская Область', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1052, 'Ингушетия Республика', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1053, 'Иркутская Область', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1054, 'Кабардино-Балкарская Республика', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1055, 'Калининградская Область', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1056, 'Калмыкия Республика', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1057, 'Калужская Область', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1058, 'Камчатская Область', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1059, 'Карачаево-Черкесская Республика', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1060, 'Карелия Республика', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1061, 'Кемеровская Область', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1062, 'Кировская Область', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1063, 'Коми Республика', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1064, 'Костромская Область', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1065, 'Краснодарский Край', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1066, 'Красноярский Край', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1067, 'Курганская Область', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1068, 'Курская Область', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1069, 'Ленинградская Область', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1070, 'Липецкая Область', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1071, 'Магаданская Область', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1072, 'Марий Эл Республика', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1073, 'Мордовия Республика', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1074, 'Москва', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1075, 'Московская Область', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1076, 'Мурманская Область', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1077, 'Нижегородская Область', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1078, 'Новгородская Область', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1079, 'Новосибирская Область', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1080, 'Омская Область', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1081, 'Оренбургская Область', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1082, 'Орловская Область', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1083, 'Пензенская Область', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1084, 'Пермский Край', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1085, 'Приморский Край', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1086, 'Псковская Область', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1087, 'Ростовская Область', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1088, 'Рязанская Область', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1089, 'Самарская Область', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1090, 'Санкт-Петербург', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1091, 'Саратовская Область', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1092, 'Саха (Якутия) Республика', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1093, 'Сахалинская Область', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1094, 'Свердловская Область', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1095, 'Северная Осетия-Алания Республика', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1096, 'Смоленская Область', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1097, 'Ставропольский Край', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1098, 'Тамбовская Область', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1099, 'Татарстан Республика', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1100, 'Тверская Область', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1101, 'Томская Область', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1102, 'Тульская Область', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1103, 'Тыва Республика', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1104, 'Тюменская Область', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1105, 'Удмуртская Республика', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1106, 'Ульяновская Область', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1107, 'Хабаровский Край', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1108, 'Хакасия Республика', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1109, 'Челябинская Область', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1110, 'Чеченская Республика', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1111, 'Читинская Область', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1112, 'Чувашская Республика', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1113, 'Ярославская Область', '', 169, 'state', 1, 5, 169, 0, 0, 0, 0, 0, 'Europe', 'Russia', NULL, NULL, NULL, NULL),
(1114, 'Blekinge', '', 170, 'state', 1, 5, 170, 0, 0, 0, 0, 0, 'Europe', 'Sweden', NULL, NULL, NULL, NULL),
(1115, 'Dalarna', '', 170, 'state', 1, 5, 170, 0, 0, 0, 0, 0, 'Europe', 'Sweden', NULL, NULL, NULL, NULL),
(1116, 'Gävleborg', '', 170, 'state', 1, 5, 170, 0, 0, 0, 0, 0, 'Europe', 'Sweden', NULL, NULL, NULL, NULL),
(1117, 'Gotland', '', 170, 'state', 1, 5, 170, 0, 0, 0, 0, 0, 'Europe', 'Sweden', NULL, NULL, NULL, NULL),
(1118, 'Halland', '', 170, 'state', 1, 5, 170, 0, 0, 0, 0, 0, 'Europe', 'Sweden', NULL, NULL, NULL, NULL),
(1119, 'Jämtland', '', 170, 'state', 1, 5, 170, 0, 0, 0, 0, 0, 'Europe', 'Sweden', NULL, NULL, NULL, NULL),
(1120, 'Jönköping', '', 170, 'state', 1, 5, 170, 0, 0, 0, 0, 0, 'Europe', 'Sweden', NULL, NULL, NULL, NULL),
(1121, 'Kalmar', '', 170, 'state', 1, 5, 170, 0, 0, 0, 0, 0, 'Europe', 'Sweden', NULL, NULL, NULL, NULL),
(1122, 'Kronoberg', '', 170, 'state', 1, 5, 170, 0, 0, 0, 0, 0, 'Europe', 'Sweden', NULL, NULL, NULL, NULL),
(1123, 'Norrbotten', '', 170, 'state', 1, 5, 170, 0, 0, 0, 0, 0, 'Europe', 'Sweden', NULL, NULL, NULL, NULL),
(1124, 'Örebro', '', 170, 'state', 1, 5, 170, 0, 0, 0, 0, 0, 'Europe', 'Sweden', NULL, NULL, NULL, NULL),
(1125, 'Östergötland', '', 170, 'state', 1, 5, 170, 0, 0, 0, 0, 0, 'Europe', 'Sweden', NULL, NULL, NULL, NULL),
(1126, 'Skåne', '', 170, 'state', 1, 5, 170, 0, 0, 0, 0, 0, 'Europe', 'Sweden', NULL, NULL, NULL, NULL),
(1127, 'Södermanland', '', 170, 'state', 1, 5, 170, 0, 0, 0, 0, 0, 'Europe', 'Sweden', NULL, NULL, NULL, NULL),
(1128, 'Stockholm', '', 170, 'state', 1, 5, 170, 0, 0, 0, 0, 0, 'Europe', 'Sweden', NULL, NULL, NULL, NULL),
(1129, 'Uppsala', '', 170, 'state', 1, 5, 170, 0, 0, 0, 0, 0, 'Europe', 'Sweden', NULL, NULL, NULL, NULL),
(1130, 'Värmland', '', 170, 'state', 1, 5, 170, 0, 0, 0, 0, 0, 'Europe', 'Sweden', NULL, NULL, NULL, NULL),
(1131, 'Västerbotten', '', 170, 'state', 1, 5, 170, 0, 0, 0, 0, 0, 'Europe', 'Sweden', NULL, NULL, NULL, NULL),
(1132, 'Västernorrland', '', 170, 'state', 1, 5, 170, 0, 0, 0, 0, 0, 'Europe', 'Sweden', NULL, NULL, NULL, NULL),
(1133, 'Västmanland', '', 170, 'state', 1, 5, 170, 0, 0, 0, 0, 0, 'Europe', 'Sweden', NULL, NULL, NULL, NULL),
(1134, 'Västra Götaland', '', 170, 'state', 1, 5, 170, 0, 0, 0, 0, 0, 'Europe', 'Sweden', NULL, NULL, NULL, NULL),
(1135, 'Jan Mayen', '', 172, 'state', 1, 5, 172, 0, 0, 0, 0, 0, 'Europe', 'Svalbard and Jan Mayen', NULL, NULL, NULL, NULL),
(1136, 'Svalbard', '', 172, 'state', 1, 5, 172, 0, 0, 0, 0, 0, 'Europe', 'Svalbard and Jan Mayen', NULL, NULL, NULL, NULL),
(1137, 'Alberta', 'AB', 188, 'state', 1, 6, 188, 0, 0, 0, 0, 0, 'North america', 'Canada', NULL, NULL, NULL, NULL),
(1138, 'British Columbia', 'BC', 188, 'state', 1, 6, 188, 0, 0, 0, 0, 0, 'North america', 'Canada', NULL, NULL, NULL, NULL),
(1139, 'Manitoba', 'MB', 188, 'state', 1, 6, 188, 0, 0, 0, 0, 0, 'North america', 'Canada', NULL, NULL, NULL, NULL),
(1140, 'New Brunswick', 'NB', 188, 'state', 1, 6, 188, 0, 0, 0, 0, 0, 'North america', 'Canada', NULL, NULL, NULL, NULL),
(1141, 'Newfoundland and Labrador', 'NL', 188, 'state', 1, 6, 188, 0, 0, 0, 0, 0, 'North america', 'Canada', NULL, NULL, NULL, NULL),
(1142, 'Northwest Territory', 'NT', 188, 'state', 1, 6, 188, 0, 0, 0, 0, 0, 'North america', 'Canada', NULL, NULL, NULL, NULL),
(1143, 'Nova Scotia', 'NS', 188, 'state', 1, 6, 188, 0, 0, 0, 0, 0, 'North america', 'Canada', NULL, NULL, NULL, NULL),
(1144, 'Nunavut Territory', 'NU', 188, 'state', 1, 6, 188, 0, 0, 0, 0, 0, 'North america', 'Canada', NULL, NULL, NULL, NULL),
(1145, 'Ontario', 'ON', 188, 'state', 1, 6, 188, 0, 0, 0, 0, 0, 'North america', 'Canada', NULL, NULL, NULL, NULL),
(1146, 'Prince Edward Island', 'PE', 188, 'state', 1, 6, 188, 0, 0, 0, 0, 0, 'North america', 'Canada', NULL, NULL, NULL, NULL),
(1147, 'Quebec', 'QC', 188, 'state', 1, 6, 188, 0, 0, 0, 0, 0, 'North america', 'Canada', NULL, NULL, NULL, NULL),
(1148, 'Saskatchewan', 'SK', 188, 'state', 1, 6, 188, 0, 0, 0, 0, 0, 'North america', 'Canada', NULL, NULL, NULL, NULL),
(1149, 'Yukon', 'YT', 188, 'state', 1, 6, 188, 0, 0, 0, 0, 0, 'North america', 'Canada', NULL, NULL, NULL, NULL),
(1150, 'Guadeloupe', '', 196, 'state', 1, 6, 196, 0, 0, 0, 0, 0, 'North america', 'Guadeloupe', NULL, NULL, NULL, NULL),
(1151, 'Ciudad de Guatemala', '', 197, 'state', 1, 6, 197, 0, 0, 0, 0, 0, 'North america', 'Guatemala', NULL, NULL, NULL, NULL),
(1152, 'DEPTO DE ALTA VERAPAZ', '', 197, 'state', 1, 6, 197, 0, 0, 0, 0, 0, 'North america', 'Guatemala', NULL, NULL, NULL, NULL),
(1153, 'DEPTO DE BAJA VERAPAZ', '', 197, 'state', 1, 6, 197, 0, 0, 0, 0, 0, 'North america', 'Guatemala', NULL, NULL, NULL, NULL),
(1154, 'DEPTO DE CHIMALTENANGO', '', 197, 'state', 1, 6, 197, 0, 0, 0, 0, 0, 'North america', 'Guatemala', NULL, NULL, NULL, NULL),
(1155, 'DEPTO DE CHIQUIMULA', '', 197, 'state', 1, 6, 197, 0, 0, 0, 0, 0, 'North america', 'Guatemala', NULL, NULL, NULL, NULL),
(1156, 'DEPTO DE EL PROGRESO', '', 197, 'state', 1, 6, 197, 0, 0, 0, 0, 0, 'North america', 'Guatemala', NULL, NULL, NULL, NULL),
(1157, 'DEPTO DE ESCUINTLA', '', 197, 'state', 1, 6, 197, 0, 0, 0, 0, 0, 'North america', 'Guatemala', NULL, NULL, NULL, NULL),
(1158, 'DEPTO DE GUATEMALA', '', 197, 'state', 1, 6, 197, 0, 0, 0, 0, 0, 'North america', 'Guatemala', NULL, NULL, NULL, NULL),
(1159, 'DEPTO DE HUEHUETENANGO', '', 197, 'state', 1, 6, 197, 0, 0, 0, 0, 0, 'North america', 'Guatemala', NULL, NULL, NULL, NULL),
(1160, 'DEPTO DE IZABAL', '', 197, 'state', 1, 6, 197, 0, 0, 0, 0, 0, 'North america', 'Guatemala', NULL, NULL, NULL, NULL),
(1161, 'DEPTO DE JALAPA', '', 197, 'state', 1, 6, 197, 0, 0, 0, 0, 0, 'North america', 'Guatemala', NULL, NULL, NULL, NULL),
(1162, 'DEPTO DE JUTIAPA', '', 197, 'state', 1, 6, 197, 0, 0, 0, 0, 0, 'North america', 'Guatemala', NULL, NULL, NULL, NULL),
(1163, 'DEPTO DE PETEN', '', 197, 'state', 1, 6, 197, 0, 0, 0, 0, 0, 'North america', 'Guatemala', NULL, NULL, NULL, NULL),
(1164, 'DEPTO DE QUETZALTENANGO', '', 197, 'state', 1, 6, 197, 0, 0, 0, 0, 0, 'North america', 'Guatemala', NULL, NULL, NULL, NULL),
(1165, 'DEPTO DE RETALHULEU', '', 197, 'state', 1, 6, 197, 0, 0, 0, 0, 0, 'North america', 'Guatemala', NULL, NULL, NULL, NULL),
(1166, 'DEPTO DE SACATEPEQUEZ', '', 197, 'state', 1, 6, 197, 0, 0, 0, 0, 0, 'North america', 'Guatemala', NULL, NULL, NULL, NULL),
(1167, 'DEPTO DE SAN MARCOS', '', 197, 'state', 1, 6, 197, 0, 0, 0, 0, 0, 'North america', 'Guatemala', NULL, NULL, NULL, NULL),
(1168, 'DEPTO DE SANTA ROSA', '', 197, 'state', 1, 6, 197, 0, 0, 0, 0, 0, 'North america', 'Guatemala', NULL, NULL, NULL, NULL),
(1169, 'DEPTO DE SOLOLA', '', 197, 'state', 1, 6, 197, 0, 0, 0, 0, 0, 'North america', 'Guatemala', NULL, NULL, NULL, NULL),
(1170, 'DEPTO DE SUCHITEPEQUEZ', '', 197, 'state', 1, 6, 197, 0, 0, 0, 0, 0, 'North america', 'Guatemala', NULL, NULL, NULL, NULL),
(1171, 'DEPTO DE TOTONICAPAN', '', 197, 'state', 1, 6, 197, 0, 0, 0, 0, 0, 'North america', 'Guatemala', NULL, NULL, NULL, NULL),
(1172, 'DEPTO DE ZACAPA', '', 197, 'state', 1, 6, 197, 0, 0, 0, 0, 0, 'North america', 'Guatemala', NULL, NULL, NULL, NULL),
(1173, 'DEPTO DEL QUICHE', '', 197, 'state', 1, 6, 197, 0, 0, 0, 0, 0, 'North america', 'Guatemala', NULL, NULL, NULL, NULL),
(1174, 'Martinique', '', 205, 'state', 1, 6, 205, 0, 0, 0, 0, 0, 'North america', 'Martinique', NULL, NULL, NULL, NULL),
(1175, 'Aguascalientes', '', 207, 'state', 1, 6, 207, 0, 0, 0, 0, 0, 'North america', 'Mexico', NULL, NULL, NULL, NULL),
(1176, 'Baja California', '', 207, 'state', 1, 6, 207, 0, 0, 0, 0, 0, 'North america', 'Mexico', NULL, NULL, NULL, NULL),
(1177, 'Baja California Sur', '', 207, 'state', 1, 6, 207, 0, 0, 0, 0, 0, 'North america', 'Mexico', NULL, NULL, NULL, NULL),
(1178, 'Campeche', '', 207, 'state', 1, 6, 207, 0, 0, 0, 0, 0, 'North america', 'Mexico', NULL, NULL, NULL, NULL),
(1179, 'Chiapas', '', 207, 'state', 1, 6, 207, 0, 0, 0, 0, 0, 'North america', 'Mexico', NULL, NULL, NULL, NULL),
(1180, 'Chihuahua', '', 207, 'state', 1, 6, 207, 0, 0, 0, 0, 0, 'North america', 'Mexico', NULL, NULL, NULL, NULL),
(1181, 'Coahuila de Zaragoza', '', 207, 'state', 1, 6, 207, 0, 0, 0, 0, 0, 'North america', 'Mexico', NULL, NULL, NULL, NULL),
(1182, 'Colima', '', 207, 'state', 1, 6, 207, 0, 0, 0, 0, 0, 'North america', 'Mexico', NULL, NULL, NULL, NULL),
(1183, 'Distrito Federal', '', 207, 'state', 1, 6, 207, 0, 0, 0, 0, 0, 'North america', 'Mexico', NULL, NULL, NULL, NULL),
(1184, 'Durango', '', 207, 'state', 1, 6, 207, 0, 0, 0, 0, 0, 'North america', 'Mexico', NULL, NULL, NULL, NULL),
(1185, 'Guanajuato', '', 207, 'state', 1, 6, 207, 0, 0, 0, 0, 0, 'North america', 'Mexico', NULL, NULL, NULL, NULL),
(1186, 'Guerrero', '', 207, 'state', 1, 6, 207, 0, 0, 0, 0, 0, 'North america', 'Mexico', NULL, NULL, NULL, NULL),
(1187, 'Hidalgo', '', 207, 'state', 1, 6, 207, 0, 0, 0, 0, 0, 'North america', 'Mexico', NULL, NULL, NULL, NULL),
(1188, 'Jalisco', '', 207, 'state', 1, 6, 207, 0, 0, 0, 0, 0, 'North america', 'Mexico', NULL, NULL, NULL, NULL),
(1189, 'México', '', 207, 'state', 1, 6, 207, 0, 0, 0, 0, 0, 'North america', 'Mexico', NULL, NULL, NULL, NULL),
(1190, 'Michoacán de Ocampo', '', 207, 'state', 1, 6, 207, 0, 0, 0, 0, 0, 'North america', 'Mexico', NULL, NULL, NULL, NULL),
(1191, 'Morelos', '', 207, 'state', 1, 6, 207, 0, 0, 0, 0, 0, 'North america', 'Mexico', NULL, NULL, NULL, NULL),
(1192, 'Nayarit', '', 207, 'state', 1, 6, 207, 0, 0, 0, 0, 0, 'North america', 'Mexico', NULL, NULL, NULL, NULL),
(1193, 'Nuevo León', '', 207, 'state', 1, 6, 207, 0, 0, 0, 0, 0, 'North america', 'Mexico', NULL, NULL, NULL, NULL),
(1194, 'Oaxaca', '', 207, 'state', 1, 6, 207, 0, 0, 0, 0, 0, 'North america', 'Mexico', NULL, NULL, NULL, NULL),
(1195, 'Puebla', '', 207, 'state', 1, 6, 207, 0, 0, 0, 0, 0, 'North america', 'Mexico', NULL, NULL, NULL, NULL),
(1196, 'Querétaro', '', 207, 'state', 1, 6, 207, 0, 0, 0, 0, 0, 'North america', 'Mexico', NULL, NULL, NULL, NULL),
(1197, 'Quintana Roo', '', 207, 'state', 1, 6, 207, 0, 0, 0, 0, 0, 'North america', 'Mexico', NULL, NULL, NULL, NULL),
(1198, 'San Luis Potosí', '', 207, 'state', 1, 6, 207, 0, 0, 0, 0, 0, 'North america', 'Mexico', NULL, NULL, NULL, NULL),
(1199, 'Sinaloa', '', 207, 'state', 1, 6, 207, 0, 0, 0, 0, 0, 'North america', 'Mexico', NULL, NULL, NULL, NULL),
(1200, 'Sonora', '', 207, 'state', 1, 6, 207, 0, 0, 0, 0, 0, 'North america', 'Mexico', NULL, NULL, NULL, NULL),
(1201, 'Tabasco', '', 207, 'state', 1, 6, 207, 0, 0, 0, 0, 0, 'North america', 'Mexico', NULL, NULL, NULL, NULL),
(1202, 'Tamaulipas', '', 207, 'state', 1, 6, 207, 0, 0, 0, 0, 0, 'North america', 'Mexico', NULL, NULL, NULL, NULL),
(1203, 'Tlaxcala', '', 207, 'state', 1, 6, 207, 0, 0, 0, 0, 0, 'North america', 'Mexico', NULL, NULL, NULL, NULL),
(1204, 'Veracruz de Ignacio de la Llave', '', 207, 'state', 1, 6, 207, 0, 0, 0, 0, 0, 'North america', 'Mexico', NULL, NULL, NULL, NULL),
(1205, 'Yucatán', '', 207, 'state', 1, 6, 207, 0, 0, 0, 0, 0, 'North america', 'Mexico', NULL, NULL, NULL, NULL),
(1206, 'Zacatecas', '', 207, 'state', 1, 6, 207, 0, 0, 0, 0, 0, 'North america', 'Mexico', NULL, NULL, NULL, NULL),
(1207, 'Miquelon-Langlade', '', 210, 'state', 1, 6, 210, 0, 0, 0, 0, 0, 'North america', 'Saint Pierre and Miquelon', NULL, NULL, NULL, NULL),
(1208, 'Saint-Pierre', '', 210, 'state', 1, 6, 210, 0, 0, 0, 0, 0, 'North america', 'Saint Pierre and Miquelon', NULL, NULL, NULL, NULL),
(1209, 'Adjuntas', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1210, 'Aguada', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1211, 'Aguadilla', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1212, 'Aguas Buenas', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1213, 'Aibonito', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1214, 'Anasco', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1215, 'Arecibo', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1216, 'Arroyo', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1217, 'Barceloneta', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1218, 'Barranquitas', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1219, 'Bayamon', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1220, 'Cabo Rojo', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1221, 'Caguas', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1222, 'Camuy', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1223, 'Canovanas', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1224, 'Carolina', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1225, 'Catano', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1226, 'Cayey', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1227, 'Ceiba', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1228, 'Ciales', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1229, 'Cidra', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1230, 'Coamo', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1231, 'Comerio', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1232, 'Corozal', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1233, 'Culebra', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1234, 'Dorado', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1235, 'Fajardo', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1236, 'Florida', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1237, 'Guanica', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1238, 'Guayama', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1239, 'Guayanilla', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1240, 'Guaynabo', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1241, 'Gurabo', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1242, 'Hatillo', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1243, 'Hormigueros', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1244, 'Humacao', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1245, 'Isabela', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1246, 'Jayuya', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1247, 'Juana Diaz', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1248, 'Juncos', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1249, 'Lajas', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1250, 'Lares', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1251, 'Las Marias', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1252, 'Las Piedras', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1253, 'Loiza', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1254, 'Luquillo', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1255, 'Manati', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1256, 'Maricao', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1257, 'Maunabo', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1258, 'Mayaguez', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1259, 'Moca', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1260, 'Morovis', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1261, 'Naguabo', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1262, 'Naranjito', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1263, 'Orocovis', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1264, 'Patillas', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1265, 'Penuelas', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1266, 'Ponce', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1267, 'Quebradillas', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1268, 'Rincon', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1269, 'Rio Grande', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1270, 'Sabana Grande', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1271, 'Salinas', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1272, 'San German', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1273, 'San Juan', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1274, 'San Lorenzo', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1275, 'San Sebastian', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1276, 'Santa Isabel', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1277, 'Toa Alta', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1278, 'Toa Baja', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1279, 'Trujillo Alto', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1280, 'Utuado', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1281, 'Vega Alta', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1282, 'Vega Baja', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1283, 'Vieques', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1284, 'Villalba', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1285, 'Yabucoa', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1286, 'Yauco', '', 211, 'state', 1, 6, 211, 0, 0, 0, 0, 0, 'North america', 'Puerto Rico', NULL, NULL, NULL, NULL),
(1287, 'Alabama', 'AL', 216, 'state', 1, 6, 216, 0, 0, 0, 0, 0, 'North america', 'United States', NULL, NULL, NULL, NULL),
(1288, 'Alaska', 'AK', 216, 'state', 1, 6, 216, 0, 0, 0, 0, 0, 'North america', 'United States', NULL, NULL, NULL, NULL),
(1289, 'Arizona', 'AZ', 216, 'state', 1, 6, 216, 0, 0, 0, 0, 0, 'North america', 'United States', NULL, NULL, NULL, NULL),
(1290, 'Arkansas', 'AR', 216, 'state', 1, 6, 216, 0, 0, 0, 0, 0, 'North america', 'United States', NULL, NULL, NULL, NULL),
(1291, 'California', 'CA', 216, 'state', 1, 6, 216, 0, 0, 0, 0, 0, 'North america', 'United States', NULL, NULL, NULL, NULL),
(1292, 'Colorado', 'CO', 216, 'state', 1, 6, 216, 0, 0, 0, 0, 0, 'North america', 'United States', NULL, NULL, NULL, NULL),
(1293, 'Connecticut', 'CT', 216, 'state', 1, 6, 216, 0, 0, 0, 0, 0, 'North america', 'United States', NULL, NULL, NULL, NULL),
(1294, 'Delaware', 'DE', 216, 'state', 1, 6, 216, 0, 0, 0, 0, 0, 'North america', 'United States', NULL, NULL, NULL, NULL),
(1295, 'District of Columbia', 'DC', 216, 'state', 1, 6, 216, 0, 0, 0, 0, 0, 'North america', 'United States', NULL, NULL, NULL, NULL),
(1296, 'Florida', 'FL', 216, 'state', 1, 6, 216, 0, 0, 0, 0, 0, 'North america', 'United States', NULL, NULL, NULL, NULL),
(1297, 'Georgia', 'GA', 216, 'state', 1, 6, 216, 0, 0, 0, 0, 0, 'North america', 'United States', NULL, NULL, NULL, NULL),
(1298, 'Hawaii', 'HI', 216, 'state', 1, 6, 216, 0, 0, 0, 0, 0, 'North america', 'United States', NULL, NULL, NULL, NULL),
(1299, 'Idaho', 'ID', 216, 'state', 1, 6, 216, 0, 0, 0, 0, 0, 'North america', 'United States', NULL, NULL, NULL, NULL),
(1300, 'Illinois', 'IL', 216, 'state', 1, 6, 216, 0, 0, 0, 0, 0, 'North america', 'United States', NULL, NULL, NULL, NULL),
(1301, 'Indiana', 'IN', 216, 'state', 1, 6, 216, 0, 0, 0, 0, 0, 'North america', 'United States', NULL, NULL, NULL, NULL),
(1302, 'Iowa', 'IA', 216, 'state', 1, 6, 216, 0, 0, 0, 0, 0, 'North america', 'United States', NULL, NULL, NULL, NULL),
(1303, 'Kansas', 'KS', 216, 'state', 1, 6, 216, 0, 0, 0, 0, 0, 'North america', 'United States', NULL, NULL, NULL, NULL),
(1304, 'Kentucky', 'KY', 216, 'state', 1, 6, 216, 0, 0, 0, 0, 0, 'North america', 'United States', NULL, NULL, NULL, NULL),
(1305, 'Louisiana', 'LA', 216, 'state', 1, 6, 216, 0, 0, 0, 0, 0, 'North america', 'United States', NULL, NULL, NULL, NULL),
(1306, 'Maine', 'ME', 216, 'state', 1, 6, 216, 0, 0, 0, 0, 0, 'North america', 'United States', NULL, NULL, NULL, NULL),
(1307, 'Maryland', 'MD', 216, 'state', 1, 6, 216, 0, 0, 0, 0, 0, 'North america', 'United States', NULL, NULL, NULL, NULL),
(1308, 'Massachusetts', 'MA', 216, 'state', 1, 6, 216, 0, 0, 0, 0, 0, 'North america', 'United States', NULL, NULL, NULL, NULL),
(1309, 'Michigan', 'MI', 216, 'state', 1, 6, 216, 0, 0, 0, 0, 0, 'North america', 'United States', NULL, NULL, NULL, NULL),
(1310, 'Minnesota', 'MN', 216, 'state', 1, 6, 216, 0, 0, 0, 0, 0, 'North america', 'United States', NULL, NULL, NULL, NULL),
(1311, 'Mississippi', 'MS', 216, 'state', 1, 6, 216, 0, 0, 0, 0, 0, 'North america', 'United States', NULL, NULL, NULL, NULL),
(1312, 'Missouri', 'MO', 216, 'state', 1, 6, 216, 0, 0, 0, 0, 0, 'North america', 'United States', NULL, NULL, NULL, NULL),
(1313, 'Montana', 'MT', 216, 'state', 1, 6, 216, 0, 0, 0, 0, 0, 'North america', 'United States', NULL, NULL, NULL, NULL),
(1314, 'Nebraska', 'NE', 216, 'state', 1, 6, 216, 0, 0, 0, 0, 0, 'North america', 'United States', NULL, NULL, NULL, NULL),
(1315, 'Nevada', 'NV', 216, 'state', 1, 6, 216, 0, 0, 0, 0, 0, 'North america', 'United States', NULL, NULL, NULL, NULL),
(1316, 'New Hampshire', 'NH', 216, 'state', 1, 6, 216, 0, 0, 0, 0, 0, 'North america', 'United States', NULL, NULL, NULL, NULL),
(1317, 'New Jersey', 'NJ', 216, 'state', 1, 6, 216, 0, 0, 0, 0, 0, 'North america', 'United States', NULL, NULL, NULL, NULL),
(1318, 'New Mexico', 'NM', 216, 'state', 1, 6, 216, 0, 0, 0, 0, 0, 'North america', 'United States', NULL, NULL, NULL, NULL),
(1319, 'New York', 'NY', 216, 'state', 1, 6, 216, 0, 0, 0, 0, 0, 'North america', 'United States', NULL, NULL, NULL, NULL),
(1320, 'North Carolina', 'NC', 216, 'state', 1, 6, 216, 0, 0, 0, 0, 0, 'North america', 'United States', NULL, NULL, NULL, NULL),
(1321, 'North Dakota', 'ND', 216, 'state', 1, 6, 216, 0, 0, 0, 0, 0, 'North america', 'United States', NULL, NULL, NULL, NULL),
(1322, 'Ohio', 'OH', 216, 'state', 1, 6, 216, 0, 0, 0, 0, 0, 'North america', 'United States', NULL, NULL, NULL, NULL),
(1323, 'Oklahoma', 'OK', 216, 'state', 1, 6, 216, 0, 0, 0, 0, 0, 'North america', 'United States', NULL, NULL, NULL, NULL),
(1324, 'Oregon', 'OR', 216, 'state', 1, 6, 216, 0, 0, 0, 0, 0, 'North america', 'United States', NULL, NULL, NULL, NULL),
(1325, 'Pennsylvania', 'PA', 216, 'state', 1, 6, 216, 0, 0, 0, 0, 0, 'North america', 'United States', NULL, NULL, NULL, NULL),
(1326, 'Rhode Island', 'RI', 216, 'state', 1, 6, 216, 0, 0, 0, 0, 0, 'North america', 'United States', NULL, NULL, NULL, NULL),
(1327, 'South Carolina', 'SC', 216, 'state', 1, 6, 216, 0, 0, 0, 0, 0, 'North america', 'United States', NULL, NULL, NULL, NULL),
(1328, 'South Dakota', 'SD', 216, 'state', 1, 6, 216, 0, 0, 0, 0, 0, 'North america', 'United States', NULL, NULL, NULL, NULL),
(1329, 'Tennessee', 'TN', 216, 'state', 1, 6, 216, 0, 0, 0, 0, 0, 'North america', 'United States', NULL, NULL, NULL, NULL),
(1330, 'Texas', 'TX', 216, 'state', 1, 6, 216, 0, 0, 0, 0, 0, 'North america', 'United States', NULL, NULL, NULL, NULL),
(1331, 'Utah', 'UT', 216, 'state', 1, 6, 216, 0, 0, 0, 0, 0, 'North america', 'United States', NULL, NULL, NULL, NULL),
(1332, 'Vermont', 'VT', 216, 'state', 1, 6, 216, 0, 0, 0, 0, 0, 'North america', 'United States', NULL, NULL, NULL, NULL),
(1333, 'Virginia', 'VA', 216, 'state', 1, 6, 216, 0, 0, 0, 0, 0, 'North america', 'United States', NULL, NULL, NULL, NULL),
(1334, 'Washington', 'WA', 216, 'state', 1, 6, 216, 0, 0, 0, 0, 0, 'North america', 'United States', NULL, NULL, NULL, NULL),
(1335, 'West Virginia', 'WV', 216, 'state', 1, 6, 216, 0, 0, 0, 0, 0, 'North america', 'United States', NULL, NULL, NULL, NULL),
(1336, 'Wisconsin', 'WI', 216, 'state', 1, 6, 216, 0, 0, 0, 0, 0, 'North america', 'United States', NULL, NULL, NULL, NULL),
(1337, 'Wyoming', 'WY', 216, 'state', 1, 6, 216, 0, 0, 0, 0, 0, 'North america', 'United States', NULL, NULL, NULL, NULL),
(1338, 'Vi', '', 219, 'state', 1, 6, 219, 0, 0, 0, 0, 0, 'North america', 'U.S. Virgin Islands', NULL, NULL, NULL, NULL),
(1339, 'As', '', 220, 'state', 1, 7, 220, 0, 0, 0, 0, 0, 'Oceania', 'American Samoa', NULL, NULL, NULL, NULL),
(1340, 'Australian Capital Territory', '', 221, 'state', 1, 7, 221, 0, 0, 0, 0, 0, 'Oceania', 'Australia', NULL, NULL, NULL, NULL),
(1341, 'New South Wales', '', 221, 'state', 1, 7, 221, 0, 0, 0, 0, 0, 'Oceania', 'Australia', NULL, NULL, NULL, NULL),
(1342, 'Northern Territory', '', 221, 'state', 1, 7, 221, 0, 0, 0, 0, 0, 'Oceania', 'Australia', NULL, NULL, NULL, NULL),
(1343, 'Queensland', '', 221, 'state', 1, 7, 221, 0, 0, 0, 0, 0, 'Oceania', 'Australia', NULL, NULL, NULL, NULL),
(1344, 'South Australia', '', 221, 'state', 1, 7, 221, 0, 0, 0, 0, 0, 'Oceania', 'Australia', NULL, NULL, NULL, NULL),
(1345, 'Tasmania', '', 221, 'state', 1, 7, 221, 0, 0, 0, 0, 0, 'Oceania', 'Australia', NULL, NULL, NULL, NULL),
(1346, 'Victoria', '', 221, 'state', 1, 7, 221, 0, 0, 0, 0, 0, 'Oceania', 'Australia', NULL, NULL, NULL, NULL),
(1347, 'Western Australia', '', 221, 'state', 1, 7, 221, 0, 0, 0, 0, 0, 'Oceania', 'Australia', NULL, NULL, NULL, NULL),
(1348, 'Gu', '', 225, 'state', 1, 7, 225, 0, 0, 0, 0, 0, 'Oceania', 'Guam', NULL, NULL, NULL, NULL),
(1349, 'Guam ', '', 225, 'state', 1, 7, 225, 0, 0, 0, 0, 0, 'Oceania', 'Guam', NULL, NULL, NULL, NULL),
(1350, 'Mh', '', 227, 'state', 1, 7, 227, 0, 0, 0, 0, 0, 'Oceania', 'Marshall Islands', NULL, NULL, NULL, NULL),
(1351, 'Mp', '', 228, 'state', 1, 7, 228, 0, 0, 0, 0, 0, 'Oceania', 'Northern Mariana Islands', NULL, NULL, NULL, NULL),
(1352, 'Northern Mariana Islands ', '', 228, 'state', 1, 7, 228, 0, 0, 0, 0, 0, 'Oceania', 'Northern Mariana Islands', NULL, NULL, NULL, NULL),
(1353, 'BUENOS AIRES', '', 247, 'state', 1, 8, 247, 0, 0, 0, 0, 0, 'South america', 'Argentina', NULL, NULL, NULL, NULL),
(1354, 'CATAMARCA', '', 247, 'state', 1, 8, 247, 0, 0, 0, 0, 0, 'South america', 'Argentina', NULL, NULL, NULL, NULL),
(1355, 'CHACO', '', 247, 'state', 1, 8, 247, 0, 0, 0, 0, 0, 'South america', 'Argentina', NULL, NULL, NULL, NULL),
(1356, 'CHUBUT', '', 247, 'state', 1, 8, 247, 0, 0, 0, 0, 0, 'South america', 'Argentina', NULL, NULL, NULL, NULL),
(1357, 'CORDOBA', '', 247, 'state', 1, 8, 247, 0, 0, 0, 0, 0, 'South america', 'Argentina', NULL, NULL, NULL, NULL),
(1358, 'CORRIENTES', '', 247, 'state', 1, 8, 247, 0, 0, 0, 0, 0, 'South america', 'Argentina', NULL, NULL, NULL, NULL),
(1359, 'ENTRE RIOS', '', 247, 'state', 1, 8, 247, 0, 0, 0, 0, 0, 'South america', 'Argentina', NULL, NULL, NULL, NULL),
(1360, 'FORMOSA', '', 247, 'state', 1, 8, 247, 0, 0, 0, 0, 0, 'South america', 'Argentina', NULL, NULL, NULL, NULL),
(1361, 'JUJUY', '', 247, 'state', 1, 8, 247, 0, 0, 0, 0, 0, 'South america', 'Argentina', NULL, NULL, NULL, NULL),
(1362, 'LA PAMPA', '', 247, 'state', 1, 8, 247, 0, 0, 0, 0, 0, 'South america', 'Argentina', NULL, NULL, NULL, NULL),
(1363, 'LA RIOJA', '', 247, 'state', 1, 8, 247, 0, 0, 0, 0, 0, 'South america', 'Argentina', NULL, NULL, NULL, NULL),
(1364, 'MENDOZA', '', 247, 'state', 1, 8, 247, 0, 0, 0, 0, 0, 'South america', 'Argentina', NULL, NULL, NULL, NULL),
(1365, 'MISIONES', '', 247, 'state', 1, 8, 247, 0, 0, 0, 0, 0, 'South america', 'Argentina', NULL, NULL, NULL, NULL),
(1366, 'NEUQUEN', '', 247, 'state', 1, 8, 247, 0, 0, 0, 0, 0, 'South america', 'Argentina', NULL, NULL, NULL, NULL);
INSERT IGNORE INTO `#__sellacious_locations` (`id`, `title`, `iso_code`, `parent_id`, `type`, `state`, `continent_id`, `country_id`, `state_id`, `district_id`, `area_id`, `zip_id`, `new_id`, `continent_title`, `country_title`, `state_title`, `district_title`, `area_title`, `zip_title`) VALUES
(1367, 'RIO NEGRO', '', 247, 'state', 1, 8, 247, 0, 0, 0, 0, 0, 'South america', 'Argentina', NULL, NULL, NULL, NULL),
(1368, 'SALTA', '', 247, 'state', 1, 8, 247, 0, 0, 0, 0, 0, 'South america', 'Argentina', NULL, NULL, NULL, NULL),
(1369, 'SAN JUAN', '', 247, 'state', 1, 8, 247, 0, 0, 0, 0, 0, 'South america', 'Argentina', NULL, NULL, NULL, NULL),
(1370, 'SAN LUIS', '', 247, 'state', 1, 8, 247, 0, 0, 0, 0, 0, 'South america', 'Argentina', NULL, NULL, NULL, NULL),
(1371, 'SANTA CRUZ', '', 247, 'state', 1, 8, 247, 0, 0, 0, 0, 0, 'South america', 'Argentina', NULL, NULL, NULL, NULL),
(1372, 'SANTA FE', '', 247, 'state', 1, 8, 247, 0, 0, 0, 0, 0, 'South america', 'Argentina', NULL, NULL, NULL, NULL),
(1373, 'SANTIAGO DEL ESTERO', '', 247, 'state', 1, 8, 247, 0, 0, 0, 0, 0, 'South america', 'Argentina', NULL, NULL, NULL, NULL),
(1374, 'TIERRA DEL FUEGO', '', 247, 'state', 1, 8, 247, 0, 0, 0, 0, 0, 'South america', 'Argentina', NULL, NULL, NULL, NULL),
(1375, 'TUCUMAN', '', 247, 'state', 1, 8, 247, 0, 0, 0, 0, 0, 'South america', 'Argentina', NULL, NULL, NULL, NULL),
(1376, 'Acre', '', 249, 'state', 1, 8, 249, 0, 0, 0, 0, 0, 'South america', 'Brazil', NULL, NULL, NULL, NULL),
(1377, 'Alagoas ', '', 249, 'state', 1, 8, 249, 0, 0, 0, 0, 0, 'South america', 'Brazil', NULL, NULL, NULL, NULL),
(1378, 'Amapa', '', 249, 'state', 1, 8, 249, 0, 0, 0, 0, 0, 'South america', 'Brazil', NULL, NULL, NULL, NULL),
(1379, 'Amazonas ', '', 249, 'state', 1, 8, 249, 0, 0, 0, 0, 0, 'South america', 'Brazil', NULL, NULL, NULL, NULL),
(1380, 'Bahia', '', 249, 'state', 1, 8, 249, 0, 0, 0, 0, 0, 'South america', 'Brazil', NULL, NULL, NULL, NULL),
(1381, 'Ceara', '', 249, 'state', 1, 8, 249, 0, 0, 0, 0, 0, 'South america', 'Brazil', NULL, NULL, NULL, NULL),
(1382, 'Distrito Federal', '', 249, 'state', 1, 8, 249, 0, 0, 0, 0, 0, 'South america', 'Brazil', NULL, NULL, NULL, NULL),
(1383, 'Espirito Santo', '', 249, 'state', 1, 8, 249, 0, 0, 0, 0, 0, 'South america', 'Brazil', NULL, NULL, NULL, NULL),
(1384, 'Goias', '', 249, 'state', 1, 8, 249, 0, 0, 0, 0, 0, 'South america', 'Brazil', NULL, NULL, NULL, NULL),
(1385, 'Maranhao ', '', 249, 'state', 1, 8, 249, 0, 0, 0, 0, 0, 'South america', 'Brazil', NULL, NULL, NULL, NULL),
(1386, 'Mato Grosso ', '', 249, 'state', 1, 8, 249, 0, 0, 0, 0, 0, 'South america', 'Brazil', NULL, NULL, NULL, NULL),
(1387, 'Mato Grosso do Sul', '', 249, 'state', 1, 8, 249, 0, 0, 0, 0, 0, 'South america', 'Brazil', NULL, NULL, NULL, NULL),
(1388, 'Minas Gerais', '', 249, 'state', 1, 8, 249, 0, 0, 0, 0, 0, 'South america', 'Brazil', NULL, NULL, NULL, NULL),
(1389, 'Para', '', 249, 'state', 1, 8, 249, 0, 0, 0, 0, 0, 'South america', 'Brazil', NULL, NULL, NULL, NULL),
(1390, 'Paraiba', '', 249, 'state', 1, 8, 249, 0, 0, 0, 0, 0, 'South america', 'Brazil', NULL, NULL, NULL, NULL),
(1391, 'Parana', '', 249, 'state', 1, 8, 249, 0, 0, 0, 0, 0, 'South america', 'Brazil', NULL, NULL, NULL, NULL),
(1392, 'Pernambuco ', '', 249, 'state', 1, 8, 249, 0, 0, 0, 0, 0, 'South america', 'Brazil', NULL, NULL, NULL, NULL),
(1393, 'Piaui', '', 249, 'state', 1, 8, 249, 0, 0, 0, 0, 0, 'South america', 'Brazil', NULL, NULL, NULL, NULL),
(1394, 'Rio de Janeiro ', '', 249, 'state', 1, 8, 249, 0, 0, 0, 0, 0, 'South america', 'Brazil', NULL, NULL, NULL, NULL),
(1395, 'Rio Grande do Norte ', '', 249, 'state', 1, 8, 249, 0, 0, 0, 0, 0, 'South america', 'Brazil', NULL, NULL, NULL, NULL),
(1396, 'Rio Grande do Sul', '', 249, 'state', 1, 8, 249, 0, 0, 0, 0, 0, 'South america', 'Brazil', NULL, NULL, NULL, NULL),
(1397, 'Rondonia', '', 249, 'state', 1, 8, 249, 0, 0, 0, 0, 0, 'South america', 'Brazil', NULL, NULL, NULL, NULL),
(1398, 'Roraima', '', 249, 'state', 1, 8, 249, 0, 0, 0, 0, 0, 'South america', 'Brazil', NULL, NULL, NULL, NULL),
(1399, 'Santa Catarina ', '', 249, 'state', 1, 8, 249, 0, 0, 0, 0, 0, 'South america', 'Brazil', NULL, NULL, NULL, NULL),
(1400, 'Sao Paulo', '', 249, 'state', 1, 8, 249, 0, 0, 0, 0, 0, 'South america', 'Brazil', NULL, NULL, NULL, NULL),
(1401, 'Sergipe', '', 249, 'state', 1, 8, 249, 0, 0, 0, 0, 0, 'South america', 'Brazil', NULL, NULL, NULL, NULL),
(1402, 'Tocantins', '', 249, 'state', 1, 8, 249, 0, 0, 0, 0, 0, 'South america', 'Brazil', NULL, NULL, NULL, NULL),
(1403, 'Guyane', '', 254, 'state', 1, 8, 254, 0, 0, 0, 0, 0, 'South america', 'French Guiana', NULL, NULL, NULL, NULL),
(1404, 'Los Angeles', '', 1291, 'district', 1, 6, 216, 1291, 0, 0, 0, 0, 'North america', 'United States', 'California', NULL, NULL, NULL),
(1405, '90001', '', 1404, 'zip', 1, 6, 216, 1291, 1404, 0, 0, 0, 'North america', 'United States', 'California', 'Los Angeles', NULL, NULL);

INSERT IGNORE INTO `#__sellacious_messages` (`id`, `parent_id`, `sender`, `recipient`, `is_read`, `title`, `alias`, `path`, `body`, `context`, `ref_id`, `date_sent`, `state`, `lft`, `rgt`, `level`, `remote_ip`, `params`) VALUES
(1, 0, 0, 0, 0, 'Root', 'root', '', '', '', 0, '0000-00-00 00:00:00', 1, 0, 1, 0, '', '');

INSERT IGNORE INTO `#__sellacious_mimes` (`id`, `extension`, `mime`, `category`, `note`, `state`) VALUES
(2, '.x3d', 'application/vnd.hzn-3d-crossword', '', '3D Crossword Plugin', 1),
(3, '.3gp', 'video/3gpp', 'video', '3GP', 1),
(4, '.3g2', 'video/3gpp2', 'video', '3GP2', 1),
(5, '.mseq', 'application/vnd.mseq', '', '3GPP MSEQ File', 1),
(6, '.pwn', 'application/vnd.3m.post-it-notes', '', '3M Post It Notes', 1),
(7, '.plb', 'application/vnd.3gpp.pic-bw-large', '', '3rd Generation Partnership Project - Pic Large', 1),
(8, '.psb', 'application/vnd.3gpp.pic-bw-small', '', '3rd Generation Partnership Project - Pic Small', 1),
(9, '.pvb', 'application/vnd.3gpp.pic-bw-var', '', '3rd Generation Partnership Project - Pic Var', 1),
(10, '.tcap', 'application/vnd.3gpp2.tcap', '', '3rd Generation Partnership Project - Transaction Capabilities Application Part', 1),
(11, '.7z', 'application/x-7z-compressed', 'archive', '7-Zip', 1),
(12, '.abw', 'application/x-abiword', '', 'AbiWord', 1),
(13, '.ace', 'application/x-ace-compressed', '', 'Ace Archive', 1),
(14, '.acc', 'application/vnd.americandynamics.acc', 'archive', 'Active Content Compression', 1),
(15, '.acu', 'application/vnd.acucobol', '', 'ACU Cobol', 1),
(16, '.atc', 'application/vnd.acucorp', '', 'ACU Cobol', 1),
(17, '.adp', 'audio/adpcm', '', 'Adaptive differential pulse-code modulation', 1),
(18, '.aab', 'application/x-authorware-bin', '', 'Adobe (Macropedia) Authorware - Binary File', 1),
(19, '.aam', 'application/x-authorware-map', '', 'Adobe (Macropedia) Authorware - Map', 1),
(20, '.aas', 'application/x-authorware-seg', '', 'Adobe (Macropedia) Authorware - Segment File', 1),
(21, '.air', 'application/vnd.adobe.air-application-installer-package+zip', 'binary', 'Adobe AIR Application', 1),
(22, '.swf', 'application/x-shockwave-flash', 'video', 'Adobe Flash', 1),
(23, '.fxp', 'application/vnd.adobe.fxp', '', 'Adobe Flex Project', 1),
(24, '.pdf', 'application/pdf', 'document', 'Adobe Portable Document Format', 1),
(25, '.ppd', 'application/vnd.cups-ppd', '', 'Adobe PostScript Printer Description File Format', 1),
(26, '.dir', 'application/x-director', '', 'Adobe Shockwave Player', 1),
(27, '.xdp', 'application/vnd.adobe.xdp+xml', '', 'Adobe XML Data Package', 1),
(28, '.xfdf', 'application/vnd.adobe.xfdf', 'audio', 'Adobe XML Forms Data Format', 1),
(29, '.aac', 'audio/x-aac', '', 'Advanced Audio Coding (AAC)', 1),
(30, '.ahead', 'application/vnd.ahead.space', '', 'Ahead AIR Application', 1),
(31, '.azf', 'application/vnd.airzip.filesecure.azf', '', 'AirZip FileSECURE', 1),
(32, '.azs', 'application/vnd.airzip.filesecure.azs', '', 'AirZip FileSECURE', 1),
(33, '.azw', 'application/vnd.amazon.ebook', '', 'Amazon Kindle eBook format', 1),
(34, '.ami', 'application/vnd.amiga.ami', '', 'AmigaDE', 1),
(35, 'N/A', 'application/andrew-inset', '', 'Andrew Toolkit', 1),
(36, '.apk', 'application/vnd.android.package-archive', 'binary', 'Android Package Archive', 1),
(37, '.cii', 'application/vnd.anser-web-certificate-issue-initiation', '', 'ANSER-WEB Terminal Client - Certificate Issue', 1),
(38, '.fti', 'application/vnd.anser-web-funds-transfer-initiation', '', 'ANSER-WEB Terminal Client - Web Funds Transfer', 1),
(39, '.atx', 'application/vnd.antix.game-component', '', 'Antix Game Player', 1),
(40, '.mpkg', 'application/vnd.apple.installer+xml', '', 'Apple Installer Package', 1),
(41, '.aw', 'application/applixware', '', 'Applixware', 1),
(42, '.les', 'application/vnd.hhe.lesson-player', '', 'Archipelago Lesson Player', 1),
(43, '.swi', 'application/vnd.aristanetworks.swi', '', 'Arista Networks Software Image', 1),
(44, '.s', 'text/x-asm', '', 'Assembler Source File', 1),
(45, '.atomcat', 'application/atomcat+xml', '', 'Atom Publishing Protocol', 1),
(46, '.atomsvc', 'application/atomsvc+xml', '', 'Atom Publishing Protocol Service Document', 1),
(47, '.atom, .xml', 'application/atom+xml', '', 'Atom Syndication Format', 1),
(48, '.ac', 'application/pkix-attr-cert', '', 'Attribute Certificate', 1),
(49, '.aif', 'audio/x-aiff', '', 'Audio Interchange File Format', 1),
(50, '.avi', 'video/x-msvideo', 'video', 'Audio Video Interleave (AVI)', 1),
(51, '.aep', 'application/vnd.audiograph', '', 'Audiograph', 1),
(52, '.dxf', 'image/vnd.dxf', '', 'AutoCAD DXF', 1),
(53, '.dwf', 'model/vnd.dwf', '', 'Autodesk Design Web Format (DWF)', 1),
(54, '.par', 'text/plain-bas', '', 'BAS Partitur Format', 1),
(55, '.bcpio', 'application/x-bcpio', '', 'Binary CPIO Archive', 1),
(56, '.bin', 'application/octet-stream', 'binary', 'Binary Data', 1),
(57, '.bmp', 'image/bmp', 'image', 'Bitmap Image File', 1),
(58, '.torrent', 'application/x-bittorrent', '', 'BitTorrent', 1),
(59, '.cod', 'application/vnd.rim.cod', '', 'Blackberry COD File', 1),
(60, '.mpm', 'application/vnd.blueice.multipass', '', 'Blueice Research Multipass', 1),
(61, '.bmi', 'application/vnd.bmi', '', 'BMI Drawing Data Interchange', 1),
(62, '.sh', 'application/x-sh', '', 'Bourne Shell Script', 1),
(63, '.btif', 'image/prs.btif', '', 'BTIF', 1),
(64, '.rep', 'application/vnd.businessobjects', '', 'BusinessObjects', 1),
(65, '.bz', 'application/x-bzip', '', 'Bzip Archive', 1),
(66, '.bz2', 'application/x-bzip2', '', 'Bzip2 Archive', 1),
(67, '.csh', 'application/x-csh', 'script', 'C Shell Script', 1),
(68, '.c', 'text/x-c', 'script', 'C Source File', 1),
(69, '.cdxml', 'application/vnd.chemdraw+xml', 'script', 'CambridgeSoft Chem Draw', 1),
(70, '.css', 'text/css', 'script', 'Cascading Style Sheets (CSS)', 1),
(71, '.cdx', 'chemical/x-cdx', '', 'ChemDraw eXchange file', 1),
(72, '.cml', 'chemical/x-cml', 'script', 'Chemical Markup Language', 1),
(73, '.csml', 'chemical/x-csml', 'script', 'Chemical Style Markup Language', 1),
(74, '.cdbcmsg', 'application/vnd.contact.cmsg', '', 'CIM Database', 1),
(75, '.cla', 'application/vnd.claymore', '', 'Claymore Data Files', 1),
(76, '.c4g', 'application/vnd.clonk.c4group', '', 'Clonk Game', 1),
(77, '.sub', 'image/vnd.dvb.subtitle', '', 'Close Captioning - Subtitle', 1),
(78, '.cdmia', 'application/cdmi-capability', '', 'Cloud Data Management Interface (CDMI) - Capability', 1),
(79, '.cdmic', 'application/cdmi-container', '', 'Cloud Data Management Interface (CDMI) - Contaimer', 1),
(80, '.cdmid', 'application/cdmi-domain', '', 'Cloud Data Management Interface (CDMI) - Domain', 1),
(81, '.cdmio', 'application/cdmi-object', '', 'Cloud Data Management Interface (CDMI) - Object', 1),
(82, '.cdmiq', 'application/cdmi-queue', '', 'Cloud Data Management Interface (CDMI) - Queue', 1),
(83, '.c11amc', 'application/vnd.cluetrust.cartomobile-config', '', 'ClueTrust CartoMobile - Config', 1),
(84, '.c11amz', 'application/vnd.cluetrust.cartomobile-config-pkg', '', 'ClueTrust CartoMobile - Config Package', 1),
(85, '.ras', 'image/x-cmu-raster', '', 'CMU Image', 1),
(86, '.dae', 'model/vnd.collada+xml', '', 'COLLADA', 1),
(87, '.csv', 'text/csv', 'database', 'Comma-Seperated Values', 1),
(88, '.cpt', 'application/mac-compactpro', '', 'Compact Pro', 1),
(89, '.wmlc', 'application/vnd.wap.wmlc', '', 'Compiled Wireless Markup Language (WMLC)', 1),
(90, '.cgm', 'image/cgm', '', 'Computer Graphics Metafile', 1),
(91, '.ice', 'x-conference/x-cooltalk', '', 'CoolTalk', 1),
(92, '.cmx', 'image/x-cmx', '', 'Corel Metafile Exchange (CMX)', 1),
(93, '.xar', 'application/vnd.xara', '', 'CorelXARA', 1),
(94, '.cmc', 'application/vnd.cosmocaller', '', 'CosmoCaller', 1),
(95, '.cpio', 'application/x-cpio', '', 'CPIO Archive', 1),
(96, '.clkx', 'application/vnd.crick.clicker', '', 'CrickSoftware - Clicker', 1),
(97, '.clkk', 'application/vnd.crick.clicker.keyboard', '', 'CrickSoftware - Clicker - Keyboard', 1),
(98, '.clkp', 'application/vnd.crick.clicker.palette', '', 'CrickSoftware - Clicker - Palette', 1),
(99, '.clkt', 'application/vnd.crick.clicker.template', '', 'CrickSoftware - Clicker - Template', 1),
(100, '.clkw', 'application/vnd.crick.clicker.wordbank', '', 'CrickSoftware - Clicker - Wordbank', 1),
(101, '.wbs', 'application/vnd.criticaltools.wbs+xml', '', 'Critical Tools - PERT Chart EXPERT', 1),
(102, '.cryptonote', 'application/vnd.rig.cryptonote', '', 'CryptoNote', 1),
(103, '.cif', 'chemical/x-cif', '', 'Crystallographic Interchange Format', 1),
(104, '.cmdf', 'chemical/x-cmdf', '', 'CrystalMaker Data Format', 1),
(105, '.cu', 'application/cu-seeme', '', 'CU-SeeMe', 1),
(106, '.cww', 'application/prs.cww', '', 'CU-Writer', 1),
(107, '.curl', 'text/vnd.curl', 'script', 'Curl - Applet', 1),
(108, '.dcurl', 'text/vnd.curl.dcurl', '', 'Curl - Detached Applet', 1),
(109, '.mcurl', 'text/vnd.curl.mcurl', '', 'Curl - Manifest File', 1),
(110, '.scurl', 'text/vnd.curl.scurl', '', 'Curl - Source Code', 1),
(111, '.car', 'application/vnd.curl.car', '', 'CURL Applet', 1),
(112, '.pcurl', 'application/vnd.curl.pcurl', '', 'CURL Applet', 1),
(113, '.cmp', 'application/vnd.yellowriver-custom-menu', '', 'CustomMenu', 1),
(114, '.dssc', 'application/dssc+der', '', 'Data Structure for the Security Suitability of Cryptographic Algorithms', 1),
(115, '.xdssc', 'application/dssc+xml', '', 'Data Structure for the Security Suitability of Cryptographic Algorithms', 1),
(116, '.deb', 'application/x-debian-package', '', 'Debian Package', 1),
(117, '.uva', 'audio/vnd.dece.audio', 'audio', 'DECE Audio', 1),
(118, '.uvi', 'image/vnd.dece.graphic', 'image', 'DECE Graphic', 1),
(119, '.uvh', 'video/vnd.dece.hd', 'video', 'DECE High Definition Video', 1),
(120, '.uvm', 'video/vnd.dece.mobile', 'video', 'DECE Mobile Video', 1),
(121, '.uvu', 'video/vnd.uvvu.mp4', 'video', 'DECE MP4', 1),
(122, '.uvp', 'video/vnd.dece.pd', 'video', 'DECE PD Video', 1),
(123, '.uvs', 'video/vnd.dece.sd', 'video', 'DECE SD Video', 1),
(124, '.uvv', 'video/vnd.dece.video', 'video', 'DECE Video', 1),
(125, '.dvi', 'application/x-dvi', 'binary', 'Device Independent File Format (DVI)', 1),
(126, '.seed', 'application/vnd.fdsn.seed', '', 'Digital Siesmograph Networks - SEED Datafiles', 1),
(127, '.dtb', 'application/x-dtbook+xml', '', 'Digital Talking Book', 1),
(128, '.res', 'application/x-dtbresource+xml', '', 'Digital Talking Book - Resource File', 1),
(129, '.ait', 'application/vnd.dvb.ait', '', 'Digital Video Broadcasting', 1),
(130, '.svc', 'application/vnd.dvb.service', '', 'Digital Video Broadcasting', 1),
(131, '.eol', 'audio/vnd.digital-winds', '', 'Digital Winds Music', 1),
(132, '.djvu', 'image/vnd.djvu', '', 'DjVu', 1),
(133, '.dtd', 'application/xml-dtd', '', 'Document Type Definition', 1),
(134, '.mlp', 'application/vnd.dolby.mlp', 'video', 'Dolby Meridian Lossless Packing', 1),
(135, '.wad', 'application/x-doom', '', 'Doom Video Game', 1),
(136, '.dpg', 'application/vnd.dpgraph', '', 'DPGraph', 1),
(137, '.dra', 'audio/vnd.dra', '', 'DRA Audio', 1),
(138, '.dfac', 'application/vnd.dreamfactory', '', 'DreamFactory', 1),
(139, '.dts', 'audio/vnd.dts', '', 'DTS Audio', 1),
(140, '.dtshd', 'audio/vnd.dts.hd', '', 'DTS High Definition Audio', 1),
(141, '.dwg', 'image/vnd.dwg', '', 'DWG Drawing', 1),
(142, '.geo', 'application/vnd.dynageo', '', 'DynaGeo', 1),
(143, '.es', 'application/ecmascript', '', 'ECMAScript', 1),
(144, '.mag', 'application/vnd.ecowin.chart', '', 'EcoWin Chart', 1),
(145, '.mmr', 'image/vnd.fujixerox.edmics-mmr', '', 'EDMICS 2000', 1),
(146, '.rlc', 'image/vnd.fujixerox.edmics-rlc', '', 'EDMICS 2000', 1),
(147, '.exi', 'application/exi', 'script', 'Efficient XML Interchange', 1),
(148, '.mgz', 'application/vnd.proteus.magazine', '', 'EFI Proteus', 1),
(149, '.epub', 'application/epub+zip', '', 'Electronic Publication', 1),
(150, '.eml', 'message/rfc822', '', 'Email Message', 1),
(151, '.nml', 'application/vnd.enliven', '', 'Enliven Viewer', 1),
(152, '.xpr', 'application/vnd.is-xpr', '', 'Express by Infoseek', 1),
(153, '.xif', 'image/vnd.xiff', 'image', 'eXtended Image File Format (XIFF)', 1),
(154, '.xfdl', 'application/vnd.xfdl', '', 'Extensible Forms Description Language', 1),
(155, '.emma', 'application/emma+xml', '', 'Extensible MultiModal Annotation', 1),
(156, '.ez2', 'application/vnd.ezpix-album', '', 'EZPix Secure Photo Album', 1),
(157, '.ez3', 'application/vnd.ezpix-package', '', 'EZPix Secure Photo Album', 1),
(158, '.fst', 'image/vnd.fst', '', 'FAST Search & Transfer ASA', 1),
(159, '.fvt', 'video/vnd.fvt', '', 'FAST Search & Transfer ASA', 1),
(160, '.fbs', 'image/vnd.fastbidsheet', '', 'FastBid Sheet', 1),
(161, '.fe_launch', 'application/vnd.denovo.fcselayout-link', '', 'FCS Express Layout Link', 1),
(162, '.f4v', 'video/x-f4v', '', 'Flash Video', 1),
(163, '.flv', 'video/x-flv', '', 'Flash Video', 1),
(164, '.fpx', 'image/vnd.fpx', '', 'FlashPix', 1),
(165, '.npx', 'image/vnd.net-fpx', '', 'FlashPix', 1),
(166, '.flx', 'text/vnd.fmi.flexstor', '', 'FLEXSTOR', 1),
(167, '.fli', 'video/x-fli', '', 'FLI/FLC Animation Format', 1),
(168, '.ftc', 'application/vnd.fluxtime.clip', '', 'FluxTime Clip', 1),
(169, '.fdf', 'application/vnd.fdf', '', 'Forms Data Format', 1),
(170, '.f', 'text/x-fortran', '', 'Fortran Source File', 1),
(171, '.mif', 'application/vnd.mif', '', 'FrameMaker Interchange Format', 1),
(172, '.fm', 'application/vnd.framemaker', '', 'FrameMaker Normal Format', 1),
(173, '.fh', 'image/x-freehand', '', 'FreeHand MX', 1),
(174, '.fsc', 'application/vnd.fsc.weblaunch', '', 'Friendly Software Corporation', 1),
(175, '.fnc', 'application/vnd.frogans.fnc', '', 'Frogans Player', 1),
(176, '.ltf', 'application/vnd.frogans.ltf', '', 'Frogans Player', 1),
(177, '.ddd', 'application/vnd.fujixerox.ddd', '', 'Fujitsu - Xerox 2D CAD Data', 1),
(178, '.xdw', 'application/vnd.fujixerox.docuworks', '', 'Fujitsu - Xerox DocuWorks', 1),
(179, '.xbd', 'application/vnd.fujixerox.docuworks.binder', '', 'Fujitsu - Xerox DocuWorks Binder', 1),
(180, '.oas', 'application/vnd.fujitsu.oasys', '', 'Fujitsu Oasys', 1),
(181, '.oa2', 'application/vnd.fujitsu.oasys2', '', 'Fujitsu Oasys', 1),
(182, '.oa3', 'application/vnd.fujitsu.oasys3', '', 'Fujitsu Oasys', 1),
(183, '.fg5', 'application/vnd.fujitsu.oasysgp', '', 'Fujitsu Oasys', 1),
(184, '.bh2', 'application/vnd.fujitsu.oasysprs', '', 'Fujitsu Oasys', 1),
(185, '.spl', 'application/x-futuresplash', '', 'FutureSplash Animator', 1),
(186, '.fzs', 'application/vnd.fuzzysheet', '', 'FuzzySheet', 1),
(187, '.g3', 'image/g3fax', '', 'G3 Fax Image', 1),
(188, '.gmx', 'application/vnd.gmx', '', 'GameMaker ActiveX', 1),
(189, '.gtw', 'model/vnd.gtw', '', 'Gen-Trix Studio', 1),
(190, '.txd', 'application/vnd.genomatix.tuxedo', '', 'Genomatix Tuxedo Framework', 1),
(191, '.ggb', 'application/vnd.geogebra.file', '', 'GeoGebra', 1),
(192, '.ggt', 'application/vnd.geogebra.tool', '', 'GeoGebra', 1),
(193, '.gdl', 'model/vnd.gdl', '', 'Geometric Description Language (GDL)', 1),
(194, '.gex', 'application/vnd.geometry-explorer', '', 'GeoMetry Explorer', 1),
(195, '.gxt', 'application/vnd.geonext', '', 'GEONExT and JSXGraph', 1),
(196, '.g2w', 'application/vnd.geoplan', '', 'GeoplanW', 1),
(197, '.g3w', 'application/vnd.geospace', '', 'GeospacW', 1),
(198, '.gsf', 'application/x-font-ghostscript', '', 'Ghostscript Font', 1),
(199, '.bdf', 'application/x-font-bdf', '', 'Glyph Bitmap Distribution Format', 1),
(200, '.gtar', 'application/x-gtar', '', 'GNU Tar Files', 1),
(201, '.texinfo', 'application/x-texinfo', '', 'GNU Texinfo Document', 1),
(202, '.gnumeric', 'application/x-gnumeric', '', 'Gnumeric', 1),
(203, '.kml', 'application/vnd.google-earth.kml+xml', '', 'Google Earth - KML', 1),
(204, '.kmz', 'application/vnd.google-earth.kmz', '', 'Google Earth - Zipped KML', 1),
(205, '.gqf', 'application/vnd.grafeq', '', 'GrafEq', 1),
(206, '.gif', 'image/gif', 'image', 'Graphics Interchange Format', 1),
(207, '.gv', 'text/vnd.graphviz', '', 'Graphviz', 1),
(208, '.gac', 'application/vnd.groove-account', '', 'Groove - Account', 1),
(209, '.ghf', 'application/vnd.groove-help', '', 'Groove - Help', 1),
(210, '.gim', 'application/vnd.groove-identity-message', '', 'Groove - Identity Message', 1),
(211, '.grv', 'application/vnd.groove-injector', '', 'Groove - Injector', 1),
(212, '.gtm', 'application/vnd.groove-tool-message', '', 'Groove - Tool Message', 1),
(213, '.tpl', 'application/vnd.groove-tool-template', 'script', 'Groove - Tool Template', 1),
(214, '.vcg', 'application/vnd.groove-vcard', '', 'Groove - Vcard', 1),
(215, '.h261', 'video/h261', '', 'H.261', 1),
(216, '.h263', 'video/h263', '', 'H.263', 1),
(217, '.h264', 'video/h264', '', 'H.264', 1),
(218, '.hpid', 'application/vnd.hp-hpid', '', 'Hewlett Packard Instant Delivery', 1),
(219, '.hps', 'application/vnd.hp-hps', '', 'Hewlett-Packard''s WebPrintSmart', 1),
(220, '.hdf', 'application/x-hdf', '', 'Hierarchical Data Format', 1),
(221, '.rip', 'audio/vnd.rip', '', 'Hit''n''Mix', 1),
(222, '.hbci', 'application/vnd.hbci', '', 'Homebanking Computer Interface (HBCI)', 1),
(223, '.jlt', 'application/vnd.hp-jlyt', '', 'HP Indigo Digital Press - Job Layout Languate', 1),
(224, '.pcl', 'application/vnd.hp-pcl', '', 'HP Printer Command Language', 1),
(225, '.hpgl', 'application/vnd.hp-hpgl', '', 'HP-GL/2 and HP RTL', 1),
(226, '.hvs', 'application/vnd.yamaha.hv-script', '', 'HV Script', 1),
(227, '.hvd', 'application/vnd.yamaha.hv-dic', '', 'HV Voice Dictionary', 1),
(228, '.hvp', 'application/vnd.yamaha.hv-voice', '', 'HV Voice Parameter', 1),
(229, '.sfd-hdstx', 'application/vnd.hydrostatix.sof-data', '', 'Hydrostatix Master Suite', 1),
(230, '.stk', 'application/hyperstudio', '', 'Hyperstudio', 1),
(231, '.hal', 'application/vnd.hal+xml', 'script', 'Hypertext Application Language', 1),
(232, '.html', 'text/html', 'script', 'HyperText Markup Language (HTML)', 1),
(233, '.irm', 'application/vnd.ibm.rights-management', '', 'IBM DB2 Rights Manager', 1),
(234, '.sc', 'application/vnd.ibm.secure-container', '', 'IBM Electronic Media Management System - Secure Container', 1),
(235, '.ics', 'text/calendar', '', 'iCalendar', 1),
(236, '.icc', 'application/vnd.iccprofile', '', 'ICC profile', 1),
(237, '.ico', 'image/x-icon', '', 'Icon Image', 1),
(238, '.igl', 'application/vnd.igloader', '', 'igLoader', 1),
(239, '.ief', 'image/ief', '', 'Image Exchange Format', 1),
(240, '.ivp', 'application/vnd.immervision-ivp', '', 'ImmerVision PURE Players', 1),
(241, '.ivu', 'application/vnd.immervision-ivu', '', 'ImmerVision PURE Players', 1),
(242, '.rif', 'application/reginfo+xml', '', 'IMS Networks', 1),
(243, '.3dml', 'text/vnd.in3d.3dml', '', 'In3D - 3DML', 1),
(244, '.spot', 'text/vnd.in3d.spot', '', 'In3D - 3DML', 1),
(245, '.igs', 'model/iges', '', 'Initial Graphics Exchange Specification (IGES)', 1),
(246, '.i2g', 'application/vnd.intergeo', '', 'Interactive Geometry Software', 1),
(247, '.cdy', 'application/vnd.cinderella', '', 'Interactive Geometry Software Cinderella', 1),
(248, '.xpw', 'application/vnd.intercon.formnet', '', 'Intercon FormNet', 1),
(249, '.fcs', 'application/vnd.isac.fcs', '', 'International Society for Advancement of Cytometry', 1),
(250, '.ipfix', 'application/ipfix', '', 'Internet Protocol Flow Information Export', 1),
(251, '.cer', 'application/pkix-cert', '', 'Internet Public Key Infrastructure - Certificate', 1),
(252, '.pki', 'application/pkixcmp', '', 'Internet Public Key Infrastructure - Certificate Management Protocole', 1),
(253, '.crl', 'application/pkix-crl', '', 'Internet Public Key Infrastructure - Certificate Revocation Lists', 1),
(254, '.pkipath', 'application/pkix-pkipath', '', 'Internet Public Key Infrastructure - Certification Path', 1),
(255, '.igm', 'application/vnd.insors.igm', '', 'IOCOM Visimeet', 1),
(256, '.rcprofile', 'application/vnd.ipunplugged.rcprofile', '', 'IP Unplugged Roaming Client', 1),
(257, '.irp', 'application/vnd.irepository.package+xml', '', 'iRepository / Lucidoc Editor', 1),
(258, '.jad', 'text/vnd.sun.j2me.app-descriptor', '', 'J2ME App Descriptor', 1),
(259, '.jar', 'application/java-archive', 'archive', 'Java Archive', 1),
(260, '.class', 'application/java-vm', '', 'Java Bytecode File', 1),
(261, '.jnlp', 'application/x-java-jnlp-file', '', 'Java Network Launching Protocol', 1),
(262, '.ser', 'application/java-serialized-object', '', 'Java Serialized Object', 1),
(263, '.java', 'text/x-java-source,java', 'script', 'Java Source File', 1),
(264, '.js', 'application/javascript', 'script', 'JavaScript', 1),
(265, '.json', 'application/json', 'script', 'JavaScript Object Notation (JSON)', 1),
(266, '.joda', 'application/vnd.joost.joda-archive', '', 'Joda Archive', 1),
(267, '.jpm', 'video/jpm', 'image', 'JPEG 2000 Compound Image File Format', 1),
(268, '.jpg', 'image/jpeg', 'image', 'JPEG Image', 1),
(269, '.jpgv', 'video/jpeg', 'video', 'JPGVideo', 1),
(270, '.ktz', 'application/vnd.kahootz', '', 'Kahootz', 1),
(271, '.mmd', 'application/vnd.chipnuts.karaoke-mmd', '', 'Karaoke on Chipnuts Chipsets', 1),
(272, '.karbon', 'application/vnd.kde.karbon', '', 'KDE KOffice Office Suite - Karbon', 1),
(273, '.chrt', 'application/vnd.kde.kchart', '', 'KDE KOffice Office Suite - KChart', 1),
(274, '.kfo', 'application/vnd.kde.kformula', '', 'KDE KOffice Office Suite - Kformula', 1),
(275, '.flw', 'application/vnd.kde.kivio', '', 'KDE KOffice Office Suite - Kivio', 1),
(276, '.kon', 'application/vnd.kde.kontour', '', 'KDE KOffice Office Suite - Kontour', 1),
(277, '.kpr', 'application/vnd.kde.kpresenter', '', 'KDE KOffice Office Suite - Kpresenter', 1),
(278, '.ksp', 'application/vnd.kde.kspread', '', 'KDE KOffice Office Suite - Kspread', 1),
(279, '.kwd', 'application/vnd.kde.kword', '', 'KDE KOffice Office Suite - Kword', 1),
(280, '.htke', 'application/vnd.kenameaapp', '', 'Kenamea App', 1),
(281, '.kia', 'application/vnd.kidspiration', '', 'Kidspiration', 1),
(282, '.kne', 'application/vnd.kinar', '', 'Kinar Applications', 1),
(283, '.sse', 'application/vnd.kodak-descriptor', '', 'Kodak Storyshare', 1),
(284, '.lasxml', 'application/vnd.las.las+xml', '', 'Laser App Enterprise', 1),
(285, '.latex', 'application/x-latex', '', 'LaTeX', 1),
(286, '.lbd', 'application/vnd.llamagraphics.life-balance.desktop', '', 'Life Balance - Desktop Edition', 1),
(287, '.lbe', 'application/vnd.llamagraphics.life-balance.exchange+xml', '', 'Life Balance - Exchange Format', 1),
(288, '.jam', 'application/vnd.jam', '', 'Lightspeed Audio Lab', 1),
(289, '0.123', 'application/vnd.lotus-1-2-3', '', 'Lotus 1-2-3', 1),
(290, '.apr', 'application/vnd.lotus-approach', '', 'Lotus Approach', 1),
(291, '.pre', 'application/vnd.lotus-freelance', '', 'Lotus Freelance', 1),
(292, '.nsf', 'application/vnd.lotus-notes', '', 'Lotus Notes', 1),
(293, '.org', 'application/vnd.lotus-organizer', '', 'Lotus Organizer', 1),
(294, '.scm', 'application/vnd.lotus-screencam', '', 'Lotus Screencam', 1),
(295, '.lwp', 'application/vnd.lotus-wordpro', '', 'Lotus Wordpro', 1),
(296, '.lvp', 'audio/vnd.lucent.voice', '', 'Lucent Voice', 1),
(297, '.m3u', 'audio/x-mpegurl', '', 'M3U (Multimedia Playlist)', 1),
(298, '.m4v', 'video/x-m4v', '', 'M4v', 1),
(299, '.hqx', 'application/mac-binhex40', '', 'Macintosh BinHex 4.0', 1),
(300, '.portpkg', 'application/vnd.macports.portpkg', '', 'MacPorts Port System', 1),
(301, '.mgp', 'application/vnd.osgeo.mapguide.package', '', 'MapGuide DBXML', 1),
(302, '.mrc', 'application/marc', '', 'MARC Formats', 1),
(303, '.mrcx', 'application/marcxml+xml', '', 'MARC21 XML Schema', 1),
(304, '.mxf', 'application/mxf', '', 'Material Exchange Format', 1),
(305, '.nbp', 'application/vnd.wolfram.player', '', 'Mathematica Notebook Player', 1),
(306, '.ma', 'application/mathematica', '', 'Mathematica Notebooks', 1),
(307, '.mathml', 'application/mathml+xml', '', 'Mathematical Markup Language', 1),
(308, '.mbox', 'application/mbox', '', 'Mbox database files', 1),
(309, '.mc1', 'application/vnd.medcalcdata', '', 'MedCalc', 1),
(310, '.mscml', 'application/mediaservercontrol+xml', '', 'Media Server Control Markup Language', 1),
(311, '.cdkey', 'application/vnd.mediastation.cdkey', '', 'MediaRemote', 1),
(312, '.mwf', 'application/vnd.mfer', '', 'Medical Waveform Encoding Format', 1),
(313, '.mfm', 'application/vnd.mfmp', '', 'Melody Format for Mobile Platform', 1),
(314, '.msh', 'model/mesh', '', 'Mesh Data Type', 1),
(315, '.mads', 'application/mads+xml', '', 'Metadata Authority Description Schema', 1),
(316, '.mets', 'application/mets+xml', '', 'Metadata Encoding and Transmission Standard', 1),
(317, '.mods', 'application/mods+xml', '', 'Metadata Object Description Schema', 1),
(318, '.meta4', 'application/metalink4+xml', '', 'Metalink', 1),
(319, '.potm', 'application/vnd.ms-powerpoint.template.macroenabled.12', '', 'Micosoft PowerPoint - Macro-Enabled Template File', 1),
(320, '.docm', 'application/vnd.ms-word.document.macroenabled.12', '', 'Micosoft Word - Macro-Enabled Document', 1),
(321, '.dotm', 'application/vnd.ms-word.template.macroenabled.12', '', 'Micosoft Word - Macro-Enabled Template', 1),
(322, '.mcd', 'application/vnd.mcd', '', 'Micro CADAM Helix D&D', 1),
(323, '.flo', 'application/vnd.micrografx.flo', '', 'Micrografx', 1),
(324, '.igx', 'application/vnd.micrografx.igx', '', 'Micrografx iGrafx Professional', 1),
(325, '.es3', 'application/vnd.eszigno3+xml', '', 'MICROSEC e-Szign?', 1),
(326, '.mdb', 'application/x-msaccess', '', 'Microsoft Access', 1),
(327, '.asf', 'video/x-ms-asf', '', 'Microsoft Advanced Systems Format (ASF)', 1),
(328, '.exe', 'application/x-msdownload', '', 'Microsoft Application', 1),
(329, '.cil', 'application/vnd.ms-artgalry', 'binary', 'Microsoft Artgalry', 1),
(330, '.cab', 'application/vnd.ms-cab-compressed', '', 'Microsoft Cabinet File', 1),
(331, '.ims', 'application/vnd.ms-ims', '', 'Microsoft Class Server', 1),
(332, '.application', 'application/x-ms-application', 'binary', 'Microsoft ClickOnce', 1),
(333, '.clp', 'application/x-msclip', '', 'Microsoft Clipboard Clip', 1),
(334, '.mdi', 'image/vnd.ms-modi', 'image', 'Microsoft Document Imaging Format', 1),
(335, '.eot', 'application/vnd.ms-fontobject', '', 'Microsoft Embedded OpenType', 1),
(336, '.xls', 'application/vnd.ms-excel', 'database', 'Microsoft Excel', 1),
(337, '.xlam', 'application/vnd.ms-excel.addin.macroenabled.12', '', 'Microsoft Excel - Add-In File', 1),
(338, '.xlsb', 'application/vnd.ms-excel.sheet.binary.macroenabled.12', '', 'Microsoft Excel - Binary Workbook', 1),
(339, '.xltm', 'application/vnd.ms-excel.template.macroenabled.12', '', 'Microsoft Excel - Macro-Enabled Template File', 1),
(340, '.xlsm', 'application/vnd.ms-excel.sheet.macroenabled.12', '', 'Microsoft Excel - Macro-Enabled Workbook', 1),
(341, '.chm', 'application/vnd.ms-htmlhelp', '', 'Microsoft Html Help File', 1),
(342, '.crd', 'application/x-mscardfile', '', 'Microsoft Information Card', 1),
(343, '.lrm', 'application/vnd.ms-lrm', '', 'Microsoft Learning Resource Module', 1),
(344, '.mvb', 'application/x-msmediaview', '', 'Microsoft MediaView', 1),
(345, '.mny', 'application/x-msmoney', '', 'Microsoft Money', 1),
(346, '.pptx', 'application/vnd.openxmlformats-officedocument.presentationml.presentation', 'document', 'Microsoft Office - OOXML - Presentation', 1),
(347, '.sldx', 'application/vnd.openxmlformats-officedocument.presentationml.slide', '', 'Microsoft Office - OOXML - Presentation (Slide)', 1),
(348, '.ppsx', 'application/vnd.openxmlformats-officedocument.presentationml.slideshow', '', 'Microsoft Office - OOXML - Presentation (Slideshow)', 1),
(349, '.potx', 'application/vnd.openxmlformats-officedocument.presentationml.template', '', 'Microsoft Office - OOXML - Presentation Template', 1),
(350, '.xlsx', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', 'database', 'Microsoft Office - OOXML - Spreadsheet', 1),
(351, '.xltx', 'application/vnd.openxmlformats-officedocument.spreadsheetml.template', '', 'Microsoft Office - OOXML - Spreadsheet Teplate', 1),
(352, '.docx', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document', 'document', 'Microsoft Office - OOXML - Word Document', 1),
(353, '.dotx', 'application/vnd.openxmlformats-officedocument.wordprocessingml.template', 'script', 'Microsoft Office - OOXML - Word Document Template', 1),
(354, '.obd', 'application/x-msbinder', '', 'Microsoft Office Binder', 1),
(355, '.thmx', 'application/vnd.ms-officetheme', '', 'Microsoft Office System Release Theme', 1),
(356, '.onetoc', 'application/onenote', '', 'Microsoft OneNote', 1),
(357, '.pya', 'audio/vnd.ms-playready.media.pya', '', 'Microsoft PlayReady Ecosystem', 1),
(358, '.pyv', 'video/vnd.ms-playready.media.pyv', '', 'Microsoft PlayReady Ecosystem Video', 1),
(359, '.ppt', 'application/vnd.ms-powerpoint', 'document', 'Microsoft PowerPoint', 1),
(360, '.ppam', 'application/vnd.ms-powerpoint.addin.macroenabled.12', '', 'Microsoft PowerPoint - Add-in file', 1),
(361, '.sldm', 'application/vnd.ms-powerpoint.slide.macroenabled.12', '', 'Microsoft PowerPoint - Macro-Enabled Open XML Slide', 1),
(362, '.pptm', 'application/vnd.ms-powerpoint.presentation.macroenabled.12', '', 'Microsoft PowerPoint - Macro-Enabled Presentation File', 1),
(363, '.ppsm', 'application/vnd.ms-powerpoint.slideshow.macroenabled.12', '', 'Microsoft PowerPoint - Macro-Enabled Slide Show File', 1),
(364, '.mpp', 'application/vnd.ms-project', '', 'Microsoft Project', 1),
(365, '.pub', 'application/x-mspublisher', '', 'Microsoft Publisher', 1),
(366, '.scd', 'application/x-msschedule', '', 'Microsoft Schedule+', 1),
(367, '.xap', 'application/x-silverlight-app', '', 'Microsoft Silverlight', 1),
(368, '.stl', 'application/vnd.ms-pki.stl', '', 'Microsoft Trust UI Provider - Certificate Trust Link', 1),
(369, '.cat', 'application/vnd.ms-pki.seccat', '', 'Microsoft Trust UI Provider - Security Catalog', 1),
(370, '.vsd', 'application/vnd.visio', '', 'Microsoft Visio', 1),
(371, '.wm', 'video/x-ms-wm', '', 'Microsoft Windows Media', 1),
(372, '.wma', 'audio/x-ms-wma', 'audio', 'Microsoft Windows Media Audio', 1),
(373, '.wax', 'audio/x-ms-wax', '', 'Microsoft Windows Media Audio Redirector', 1),
(374, '.wmx', 'video/x-ms-wmx', '', 'Microsoft Windows Media Audio/Video Playlist', 1),
(375, '.wmd', 'application/x-ms-wmd', '', 'Microsoft Windows Media Player Download Package', 1),
(376, '.wpl', 'application/vnd.ms-wpl', '', 'Microsoft Windows Media Player Playlist', 1),
(377, '.wmz', 'application/x-ms-wmz', '', 'Microsoft Windows Media Player Skin Package', 1),
(378, '.wmv', 'video/x-ms-wmv', 'video', 'Microsoft Windows Media Video', 1),
(379, '.wvx', 'video/x-ms-wvx', '', 'Microsoft Windows Media Video Playlist', 1),
(380, '.wmf', 'application/x-msmetafile', '', 'Microsoft Windows Metafile', 1),
(381, '.trm', 'application/x-msterminal', '', 'Microsoft Windows Terminal Services', 1),
(382, '.doc', 'application/msword', '', 'Microsoft Word', 1),
(383, '.wri', 'application/x-mswrite', '', 'Microsoft Wordpad', 1),
(384, '.wps', 'application/vnd.ms-works', '', 'Microsoft Works', 1),
(385, '.xbap', 'application/x-ms-xbap', '', 'Microsoft XAML Browser Application', 1),
(386, '.xps', 'application/vnd.ms-xpsdocument', 'document', 'Microsoft XML Paper Specification', 1),
(387, '.mid', 'audio/midi', 'audio', 'MIDI - Musical Instrument Digital Interface', 1),
(388, '.mpy', 'application/vnd.ibm.minipay', '', 'MiniPay', 1),
(389, '.afp', 'application/vnd.ibm.modcap', '', 'MO:DCA-P', 1),
(390, '.rms', 'application/vnd.jcp.javame.midlet-rms', '', 'Mobile Information Device Profile', 1),
(391, '.tmo', 'application/vnd.tmobile-livetv', '', 'MobileTV', 1),
(392, '.prc', 'application/x-mobipocket-ebook', '', 'Mobipocket', 1),
(393, '.mbk', 'application/vnd.mobius.mbk', '', 'Mobius Management Systems - Basket file', 1),
(394, '.dis', 'application/vnd.mobius.dis', '', 'Mobius Management Systems - Distribution Database', 1),
(395, '.plc', 'application/vnd.mobius.plc', '', 'Mobius Management Systems - Policy Definition Language File', 1),
(396, '.mqy', 'application/vnd.mobius.mqy', '', 'Mobius Management Systems - Query File', 1),
(397, '.msl', 'application/vnd.mobius.msl', '', 'Mobius Management Systems - Script Language', 1),
(398, '.txf', 'application/vnd.mobius.txf', '', 'Mobius Management Systems - Topic Index File', 1),
(399, '.daf', 'application/vnd.mobius.daf', '', 'Mobius Management Systems - UniversalArchive', 1),
(400, '.fly', 'text/vnd.fly', '', 'mod_fly / fly.cgi', 1),
(401, '.mpc', 'application/vnd.mophun.certificate', '', 'Mophun Certificate', 1),
(402, '.mpn', 'application/vnd.mophun.application', '', 'Mophun VM', 1),
(403, '.mj2', 'video/mj2', '', 'Motion JPEG 2000', 1),
(404, '.mpga', 'audio/mpeg', '', 'MPEG Audio', 1),
(405, '.mxu', 'video/vnd.mpegurl', '', 'MPEG Url', 1),
(406, '.mpeg', 'video/mpeg', '', 'MPEG Video', 1),
(407, '.m21', 'application/mp21', '', 'MPEG-21', 1),
(408, '.mp4a', 'audio/mp4', '', 'MPEG-4 Audio', 1),
(409, '.mp4', 'video/mp4', 'video', 'MPEG-4 Video', 1),
(410, '.mp4', 'application/mp4', 'video', 'MPEG4', 1),
(411, '.m3u8', 'application/vnd.apple.mpegurl', '', 'Multimedia Playlist Unicode', 1),
(412, '.mus', 'application/vnd.musician', '', 'MUsical Score Interpreted Code Invented for the ASCII designation of Notation', 1),
(413, '.msty', 'application/vnd.muvee.style', '', 'Muvee Automatic Video Editing', 1),
(414, '.mxml', 'application/xv+xml', '', 'MXML', 1),
(415, '.ngdat', 'application/vnd.nokia.n-gage.data', '', 'N-Gage Game Data', 1),
(416, '.n-gage', 'application/vnd.nokia.n-gage.symbian.install', '', 'N-Gage Game Installer', 1),
(417, '.ncx', 'application/x-dtbncx+xml', '', 'Navigation Control file for XML (for ePub)', 1),
(418, '.nc', 'application/x-netcdf', '', 'Network Common Data Form (NetCDF)', 1),
(419, '.nlu', 'application/vnd.neurolanguage.nlu', '', 'neuroLanguage', 1),
(420, '.dna', 'application/vnd.dna', '', 'New Moon Liftoff/DNA', 1),
(421, '.nnd', 'application/vnd.noblenet-directory', '', 'NobleNet Directory', 1),
(422, '.nns', 'application/vnd.noblenet-sealer', '', 'NobleNet Sealer', 1),
(423, '.nnw', 'application/vnd.noblenet-web', '', 'NobleNet Web', 1),
(424, '.rpst', 'application/vnd.nokia.radio-preset', '', 'Nokia Radio Application - Preset', 1),
(425, '.rpss', 'application/vnd.nokia.radio-presets', '', 'Nokia Radio Application - Preset', 1),
(426, '.n3', 'text/n3', '', 'Notation3', 1),
(427, '.edm', 'application/vnd.novadigm.edm', '', 'Novadigm''s RADIA and EDM products', 1),
(428, '.edx', 'application/vnd.novadigm.edx', '', 'Novadigm''s RADIA and EDM products', 1),
(429, '.ext', 'application/vnd.novadigm.ext', '', 'Novadigm''s RADIA and EDM products', 1),
(430, '.gph', 'application/vnd.flographit', '', 'NpGraphIt', 1),
(431, '.ecelp4800', 'audio/vnd.nuera.ecelp4800', '', 'Nuera ECELP 4800', 1),
(432, '.ecelp7470', 'audio/vnd.nuera.ecelp7470', '', 'Nuera ECELP 7470', 1),
(433, '.ecelp9600', 'audio/vnd.nuera.ecelp9600', '', 'Nuera ECELP 9600', 1),
(434, '.oda', 'application/oda', 'document', 'Office Document Architecture', 1),
(435, '.ogx', 'application/ogg', 'document', 'Ogg', 1),
(436, '.oga', 'audio/ogg', 'audio', 'Ogg Audio', 1),
(437, '.ogv', 'video/ogg', 'video', 'Ogg Video', 1),
(438, '.dd2', 'application/vnd.oma.dd2+xml', '', 'OMA Download Agents', 1),
(439, '.oth', 'application/vnd.oasis.opendocument.text-web', '', 'Open Document Text Web', 1),
(440, '.opf', 'application/oebps-package+xml', '', 'Open eBook Publication Structure', 1),
(441, '.qbo', 'application/vnd.intu.qbo', '', 'Open Financial Exchange', 1),
(442, '.oxt', 'application/vnd.openofficeorg.extension', '', 'Open Office Extension', 1),
(443, '.osf', 'application/vnd.yamaha.openscoreformat', '', 'Open Score Format', 1),
(444, '.weba', 'audio/webm', 'audio', 'Open Web Media Project - Audio', 1),
(445, '.webm', 'video/webm', 'video', 'Open Web Media Project - Video', 1),
(446, '.odc', 'application/vnd.oasis.opendocument.chart', '', 'OpenDocument Chart', 1),
(447, '.otc', 'application/vnd.oasis.opendocument.chart-template', '', 'OpenDocument Chart Template', 1),
(448, '.odb', 'application/vnd.oasis.opendocument.database', 'database', 'OpenDocument Database', 1),
(449, '.odf', 'application/vnd.oasis.opendocument.formula', '', 'OpenDocument Formula', 1),
(450, '.odft', 'application/vnd.oasis.opendocument.formula-template', '', 'OpenDocument Formula Template', 1),
(451, '.odg', 'application/vnd.oasis.opendocument.graphics', 'image', 'OpenDocument Graphics', 1),
(452, '.otg', 'application/vnd.oasis.opendocument.graphics-template', '', 'OpenDocument Graphics Template', 1),
(453, '.odi', 'application/vnd.oasis.opendocument.image', 'image', 'OpenDocument Image', 1),
(454, '.oti', 'application/vnd.oasis.opendocument.image-template', '', 'OpenDocument Image Template', 1),
(455, '.odp', 'application/vnd.oasis.opendocument.presentation', 'document', 'OpenDocument Presentation', 1),
(456, '.otp', 'application/vnd.oasis.opendocument.presentation-template', '', 'OpenDocument Presentation Template', 1),
(457, '.ods', 'application/vnd.oasis.opendocument.spreadsheet', 'database', 'OpenDocument Spreadsheet', 1),
(458, '.ots', 'application/vnd.oasis.opendocument.spreadsheet-template', '', 'OpenDocument Spreadsheet Template', 1),
(459, '.odt', 'application/vnd.oasis.opendocument.text', '', 'OpenDocument Text', 1),
(460, '.odm', 'application/vnd.oasis.opendocument.text-master', '', 'OpenDocument Text Master', 1),
(461, '.ott', 'application/vnd.oasis.opendocument.text-template', '', 'OpenDocument Text Template', 1),
(462, '.ktx', 'image/ktx', '', 'OpenGL Textures (KTX)', 1),
(463, '.sxc', 'application/vnd.sun.xml.calc', 'database', 'OpenOffice - Calc (Spreadsheet)', 1),
(464, '.stc', 'application/vnd.sun.xml.calc.template', '', 'OpenOffice - Calc Template (Spreadsheet)', 1),
(465, '.sxd', 'application/vnd.sun.xml.draw', '', 'OpenOffice - Draw (Graphics)', 1),
(466, '.std', 'application/vnd.sun.xml.draw.template', '', 'OpenOffice - Draw Template (Graphics)', 1),
(467, '.sxi', 'application/vnd.sun.xml.impress', '', 'OpenOffice - Impress (Presentation)', 1),
(468, '.sti', 'application/vnd.sun.xml.impress.template', '', 'OpenOffice - Impress Template (Presentation)', 1),
(469, '.sxm', 'application/vnd.sun.xml.math', '', 'OpenOffice - Math (Formula)', 1),
(470, '.sxw', 'application/vnd.sun.xml.writer', '', 'OpenOffice - Writer (Text - HTML)', 1),
(471, '.sxg', 'application/vnd.sun.xml.writer.global', '', 'OpenOffice - Writer (Text - HTML)', 1),
(472, '.stw', 'application/vnd.sun.xml.writer.template', '', 'OpenOffice - Writer Template (Text - HTML)', 1),
(473, '.otf', 'application/x-font-otf', '', 'OpenType Font File', 1),
(474, '.osfpvg', 'application/vnd.yamaha.openscoreformat.osfpvg+xml', '', 'OSFPVG', 1),
(475, '.dp', 'application/vnd.osgi.dp', '', 'OSGi Deployment Package', 1),
(476, '.pdb', 'application/vnd.palm', '', 'PalmOS Data', 1),
(477, '.p', 'text/x-pascal', '', 'Pascal Source File', 1),
(478, '.paw', 'application/vnd.pawaafile', '', 'PawaaFILE', 1),
(479, '.pclxl', 'application/vnd.hp-pclxl', '', 'PCL 6 Enhanced (Formely PCL XL)', 1),
(480, '.efif', 'application/vnd.picsel', '', 'Pcsel eFIF File', 1),
(481, '.pcx', 'image/x-pcx', '', 'PCX Image', 1),
(482, '.psd', 'image/vnd.adobe.photoshop', 'image', 'Photoshop Document', 1),
(483, '.prf', 'application/pics-rules', '', 'PICSRules', 1),
(484, '.pic', 'image/x-pict', 'image', 'PICT Image', 1),
(485, '.chat', 'application/x-chat', '', 'pIRCh', 1),
(486, '.p10', 'application/pkcs10', '', 'PKCS #10 - Certification Request Standard', 1),
(487, '.p12', 'application/x-pkcs12', '', 'PKCS #12 - Personal Information Exchange Syntax Standard', 1),
(488, '.p7m', 'application/pkcs7-mime', '', 'PKCS #7 - Cryptographic Message Syntax Standard', 1),
(489, '.p7s', 'application/pkcs7-signature', '', 'PKCS #7 - Cryptographic Message Syntax Standard', 1),
(490, '.p7r', 'application/x-pkcs7-certreqresp', '', 'PKCS #7 - Cryptographic Message Syntax Standard (Certificate Request Response)', 1),
(491, '.p7b', 'application/x-pkcs7-certificates', '', 'PKCS #7 - Cryptographic Message Syntax Standard (Certificates)', 1),
(492, '.p8', 'application/pkcs8', '', 'PKCS #8 - Private-Key Information Syntax Standard', 1),
(493, '.plf', 'application/vnd.pocketlearn', '', 'PocketLearn Viewers', 1),
(494, '.pnm', 'image/x-portable-anymap', '', 'Portable Anymap Image', 1),
(495, '.pbm', 'image/x-portable-bitmap', '', 'Portable Bitmap Format', 1),
(496, '.pcf', 'application/x-font-pcf', '', 'Portable Compiled Format', 1),
(497, '.pfr', 'application/font-tdpfr', '', 'Portable Font Resource', 1),
(498, '.pgn', 'application/x-chess-pgn', '', 'Portable Game Notation (Chess Games)', 1),
(499, '.pgm', 'image/x-portable-graymap', '', 'Portable Graymap Format', 1),
(500, '.png', 'image/png', 'image', 'Portable Network Graphics (PNG)', 1),
(501, '.ppm', 'image/x-portable-pixmap', '', 'Portable Pixmap Format', 1),
(502, '.pskcxml', 'application/pskc+xml', '', 'Portable Symmetric Key Container', 1),
(503, '.pml', 'application/vnd.ctc-posml', '', 'PosML', 1),
(504, '.ai', 'application/postscript', '', 'PostScript', 1),
(505, '.pfa', 'application/x-font-type1', '', 'PostScript Fonts', 1),
(506, '.pbd', 'application/vnd.powerbuilder6', '', 'PowerBuilder', 1),
(507, '', 'application/pgp-encrypted', '', 'Pretty Good Privacy', 1),
(508, '.pgp', 'application/pgp-signature', '', 'Pretty Good Privacy - Signature', 1),
(509, '.box', 'application/vnd.previewsystems.box', '', 'Preview Systems ZipLock/VBox', 1),
(510, '.ptid', 'application/vnd.pvi.ptid1', '', 'Princeton Video Image', 1),
(511, '.pls', 'application/pls+xml', '', 'Pronunciation Lexicon Specification', 1),
(512, '.str', 'application/vnd.pg.format', '', 'Proprietary P&G Standard Reporting System', 1),
(513, '.ei6', 'application/vnd.pg.osasli', '', 'Proprietary P&G Standard Reporting System', 1),
(514, '.dsc', 'text/prs.lines.tag', '', 'PRS Lines Tag', 1),
(515, '.psf', 'application/x-font-linux-psf', '', 'PSF Fonts', 1),
(516, '.qps', 'application/vnd.publishare-delta-tree', '', 'PubliShare Objects', 1),
(517, '.wg', 'application/vnd.pmi.widget', '', 'Qualcomm''s Plaza Mobile Internet', 1),
(518, '.qxd', 'application/vnd.quark.quarkxpress', '', 'QuarkXpress', 1),
(519, '.esf', 'application/vnd.epson.esf', '', 'QUASS Stream Player', 1),
(520, '.msf', 'application/vnd.epson.msf', '', 'QUASS Stream Player', 1),
(521, '.ssf', 'application/vnd.epson.ssf', '', 'QUASS Stream Player', 1),
(522, '.qam', 'application/vnd.epson.quickanime', '', 'QuickAnime Player', 1),
(523, '.qfx', 'application/vnd.intu.qfx', '', 'Quicken', 1),
(524, '.qt', 'video/quicktime', '', 'Quicktime Video', 1),
(525, '.rar', 'application/x-rar-compressed', 'archive', 'RAR Archive', 1),
(526, '.ram', 'audio/x-pn-realaudio', '', 'Real Audio Sound', 1),
(527, '.rmp', 'audio/x-pn-realaudio-plugin', '', 'Real Audio Sound', 1),
(528, '.rsd', 'application/rsd+xml', '', 'Really Simple Discovery', 1),
(529, '.rm', 'application/vnd.rn-realmedia', '', 'RealMedia', 1),
(530, '.bed', 'application/vnd.realvnc.bed', '', 'RealVNC', 1),
(531, '.mxl', 'application/vnd.recordare.musicxml', '', 'Recordare Applications', 1),
(532, '.musicxml', 'application/vnd.recordare.musicxml+xml', '', 'Recordare Applications', 1),
(533, '.rnc', 'application/relax-ng-compact-syntax', '', 'Relax NG Compact Syntax', 1),
(534, '.rdz', 'application/vnd.data-vision.rdz', '', 'RemoteDocs R-Viewer', 1),
(535, '.rdf', 'application/rdf+xml', '', 'Resource Description Framework', 1),
(536, '.rp9', 'application/vnd.cloanto.rp9', '', 'RetroPlatform Player', 1),
(537, '.jisp', 'application/vnd.jisp', '', 'RhymBox', 1),
(538, '.rtf', 'application/rtf', 'document', 'Rich Text Format', 1),
(539, '.rtx', 'text/richtext', 'document', 'Rich Text Format (RTF)', 1),
(540, '.link66', 'application/vnd.route66.link66+xml', '', 'ROUTE 66 Location Based Services', 1),
(541, '.rss, .xml', 'application/rss+xml', 'script', 'RSS - Really Simple Syndication', 1),
(542, '.shf', 'application/shf+xml', '', 'S Hexdump Format', 1),
(543, '.st', 'application/vnd.sailingtracker.track', '', 'SailingTracker', 1),
(544, '.svg', 'image/svg+xml', '', 'Scalable Vector Graphics (SVG)', 1),
(545, '.sus', 'application/vnd.sus-calendar', '', 'ScheduleUs', 1),
(546, '.sru', 'application/sru+xml', '', 'Search/Retrieve via URL Response Format', 1),
(547, '.setpay', 'application/set-payment-initiation', '', 'Secure Electronic Transaction - Payment', 1),
(548, '.setreg', 'application/set-registration-initiation', '', 'Secure Electronic Transaction - Registration', 1),
(549, '.sema', 'application/vnd.sema', '', 'Secured eMail', 1),
(550, '.semd', 'application/vnd.semd', '', 'Secured eMail', 1),
(551, '.semf', 'application/vnd.semf', '', 'Secured eMail', 1),
(552, '.see', 'application/vnd.seemail', '', 'SeeMail', 1),
(553, '.snf', 'application/x-font-snf', '', 'Server Normal Format', 1),
(554, '.spq', 'application/scvp-vp-request', '', 'Server-Based Certificate Validation Protocol - Validation Policies - Request', 1),
(555, '.spp', 'application/scvp-vp-response', '', 'Server-Based Certificate Validation Protocol - Validation Policies - Response', 1),
(556, '.scq', 'application/scvp-cv-request', '', 'Server-Based Certificate Validation Protocol - Validation Request', 1),
(557, '.scs', 'application/scvp-cv-response', '', 'Server-Based Certificate Validation Protocol - Validation Response', 1),
(558, '.sdp', 'application/sdp', '', 'Session Description Protocol', 1),
(559, '.etx', 'text/x-setext', '', 'Setext', 1),
(560, '.movie', 'video/x-sgi-movie', 'video', 'SGI Movie', 1),
(561, '.ifm', 'application/vnd.shana.informed.formdata', '', 'Shana Informed Filler', 1),
(562, '.itp', 'application/vnd.shana.informed.formtemplate', '', 'Shana Informed Filler', 1),
(563, '.iif', 'application/vnd.shana.informed.interchange', '', 'Shana Informed Filler', 1),
(564, '.ipk', 'application/vnd.shana.informed.package', 'archive', 'Shana Informed Filler', 1),
(565, '.tfi', 'application/thraud+xml', '', 'Sharing Transaction Fraud Data', 1),
(566, '.shar', 'application/x-shar', '', 'Shell Archive', 1),
(567, '.rgb', 'image/x-rgb', '', 'Silicon Graphics RGB Bitmap', 1),
(568, '.slt', 'application/vnd.epson.salt', '', 'SimpleAnimeLite Player', 1),
(569, '.aso', 'application/vnd.accpac.simply.aso', '', 'Simply Accounting', 1),
(570, '.imp', 'application/vnd.accpac.simply.imp', '', 'Simply Accounting - Data Import', 1),
(571, '.twd', 'application/vnd.simtech-mindmapper', '', 'SimTech MindMapper', 1),
(572, '.csp', 'application/vnd.commonspace', '', 'Sixth Floor Media - CommonSpace', 1),
(573, '.saf', 'application/vnd.yamaha.smaf-audio', '', 'SMAF Audio', 1),
(574, '.mmf', 'application/vnd.smaf', '', 'SMAF File', 1),
(575, '.spf', 'application/vnd.yamaha.smaf-phrase', '', 'SMAF Phrase', 1),
(576, '.teacher', 'application/vnd.smart.teacher', '', 'SMART Technologies Apps', 1),
(577, '.svd', 'application/vnd.svd', '', 'SourceView Document', 1),
(578, '.rq', 'application/sparql-query', '', 'SPARQL - Query', 1),
(579, '.srx', 'application/sparql-results+xml', '', 'SPARQL - Results', 1),
(580, '.gram', 'application/srgs', '', 'Speech Recognition Grammar Specification', 1),
(581, '.grxml', 'application/srgs+xml', '', 'Speech Recognition Grammar Specification - XML', 1),
(582, '.ssml', 'application/ssml+xml', '', 'Speech Synthesis Markup Language', 1),
(583, '.skp', 'application/vnd.koan', '', 'SSEYO Koan Play File', 1),
(584, '.sgml', 'text/sgml', '', 'Standard Generalized Markup Language (SGML)', 1),
(585, '.sdc', 'application/vnd.stardivision.calc', '', 'StarOffice - Calc', 1),
(586, '.sda', 'application/vnd.stardivision.draw', '', 'StarOffice - Draw', 1),
(587, '.sdd', 'application/vnd.stardivision.impress', '', 'StarOffice - Impress', 1),
(588, '.smf', 'application/vnd.stardivision.math', '', 'StarOffice - Math', 1),
(589, '.sdw', 'application/vnd.stardivision.writer', '', 'StarOffice - Writer', 1),
(590, '.sgl', 'application/vnd.stardivision.writer-global', '', 'StarOffice - Writer (Global)', 1),
(591, '.sm', 'application/vnd.stepmania.stepchart', '', 'StepMania', 1),
(592, '.sit', 'application/x-stuffit', '', 'Stuffit Archive', 1),
(593, '.sitx', 'application/x-stuffitx', '', 'Stuffit Archive', 1),
(594, '.sdkm', 'application/vnd.solent.sdkm+xml', '', 'SudokuMagic', 1),
(595, '.xo', 'application/vnd.olpc-sugar', '', 'Sugar Linux Application Bundle', 1),
(596, '.au', 'audio/basic', '', 'Sun Audio - Au file format', 1),
(597, '.wqd', 'application/vnd.wqd', '', 'SundaHus WQ', 1),
(598, '.sis', 'application/vnd.symbian.install', '', 'Symbian Install Package', 1),
(599, '.smi', 'application/smil+xml', '', 'Synchronized Multimedia Integration Language', 1),
(600, '.xsm', 'application/vnd.syncml+xml', '', 'SyncML', 1),
(601, '.bdm', 'application/vnd.syncml.dm+wbxml', '', 'SyncML - Device Management', 1),
(602, '.xdm', 'application/vnd.syncml.dm+xml', '', 'SyncML - Device Management', 1),
(603, '.sv4cpio', 'application/x-sv4cpio', '', 'System V Release 4 CPIO Archive', 1),
(604, '.sv4crc', 'application/x-sv4crc', '', 'System V Release 4 CPIO Checksum Data', 1),
(605, '.sbml', 'application/sbml+xml', '', 'Systems Biology Markup Language', 1),
(606, '.tsv', 'text/tab-separated-values', '', 'Tab Seperated Values', 1),
(607, '.tiff', 'image/tiff', 'image', 'Tagged Image File Format', 1),
(608, '.tao', 'application/vnd.tao.intent-module-archive', '', 'Tao Intent', 1),
(609, '.tar', 'application/x-tar', '', 'Tar File (Tape Archive)', 1),
(610, '.tcl', 'application/x-tcl', '', 'Tcl Script', 1),
(611, '.tex', 'application/x-tex', '', 'TeX', 1),
(612, '.tfm', 'application/x-tex-tfm', '', 'TeX Font Metric', 1),
(613, '.tei', 'application/tei+xml', '', 'Text Encoding and Interchange', 1),
(614, '.txt', 'text/plain', 'document', 'Text File', 1),
(615, '.dxp', 'application/vnd.spotfire.dxp', '', 'TIBCO Spotfire', 1),
(616, '.sfs', 'application/vnd.spotfire.sfs', '', 'TIBCO Spotfire', 1),
(617, '.tsd', 'application/timestamped-data', '', 'Time Stamped Data Envelope', 1),
(618, '.tpt', 'application/vnd.trid.tpt', '', 'TRI Systems Config', 1),
(619, '.mxs', 'application/vnd.triscape.mxs', '', 'Triscape Map Explorer', 1),
(620, '.t', 'text/troff', '', 'troff', 1),
(621, '.tra', 'application/vnd.trueapp', '', 'True BASIC', 1),
(622, '.ttf', 'application/x-font-ttf', '', 'TrueType Font', 1),
(623, '.ttl', 'text/turtle', '', 'Turtle (Terse RDF Triple Language)', 1),
(624, '.umj', 'application/vnd.umajin', '', 'UMAJIN', 1),
(625, '.uoml', 'application/vnd.uoml+xml', '', 'Unique Object Markup Language', 1),
(626, '.unityweb', 'application/vnd.unity', '', 'Unity 3d', 1),
(627, '.ufd', 'application/vnd.ufdl', '', 'Universal Forms Description Language', 1),
(628, '.uri', 'text/uri-list', '', 'URI Resolution Services', 1),
(629, '.utz', 'application/vnd.uiq.theme', '', 'User Interface Quartz - Theme (Symbian)', 1),
(630, '.ustar', 'application/x-ustar', '', 'Ustar (Uniform Standard Tape Archive)', 1),
(631, '.uu', 'text/x-uuencode', '', 'UUEncode', 1),
(632, '.vcs', 'text/x-vcalendar', '', 'vCalendar', 1),
(633, '.vcf', 'text/x-vcard', '', 'vCard', 1),
(634, '.vcd', 'application/x-cdlink', 'video', 'Video CD', 1),
(635, '.vsf', 'application/vnd.vsf', '', 'Viewport+', 1),
(636, '.wrl', 'model/vrml', '', 'Virtual Reality Modeling Language', 1),
(637, '.vcx', 'application/vnd.vcx', '', 'VirtualCatalog', 1),
(638, '.mts', 'model/vnd.mts', '', 'Virtue MTS', 1),
(639, '.vtu', 'model/vnd.vtu', '', 'Virtue VTU', 1),
(640, '.vis', 'application/vnd.visionary', '', 'Visionary', 1),
(641, '.viv', 'video/vnd.vivo', '', 'Vivo', 1);
INSERT IGNORE INTO `#__sellacious_mimes` (`id`, `extension`, `mime`, `category`, `note`, `state`) VALUES
(642, '.ccxml', 'application/ccxml+xml,', '', 'Voice Browser Call Control', 1),
(643, '.vxml', 'application/voicexml+xml', '', 'VoiceXML', 1),
(644, '.src', 'application/x-wais-source', '', 'WAIS Source', 1),
(645, '.wbxml', 'application/vnd.wap.wbxml', '', 'WAP Binary XML (WBXML)', 1),
(646, '.wbmp', 'image/vnd.wap.wbmp', '', 'WAP Bitamp (WBMP)', 1),
(647, '.wav', 'audio/x-wav', 'audio', 'Waveform Audio File Format (WAV)', 1),
(648, '.davmount', 'application/davmount+xml', '', 'Web Distributed Authoring and Versioning', 1),
(649, '.woff', 'application/x-font-woff', '', 'Web Open Font Format', 1),
(650, '.wspolicy', 'application/wspolicy+xml', '', 'Web Services Policy', 1),
(651, '.webp', 'image/webp', '', 'WebP Image', 1),
(652, '.wtb', 'application/vnd.webturbo', '', 'WebTurbo', 1),
(653, '.wgt', 'application/widget', '', 'Widget Packaging and XML Configuration', 1),
(654, '.hlp', 'application/winhlp', '', 'WinHelp', 1),
(655, '.wml', 'text/vnd.wap.wml', 'script', 'Wireless Markup Language (WML)', 1),
(656, '.wmls', 'text/vnd.wap.wmlscript', 'script', 'Wireless Markup Language Script (WMLScript)', 1),
(657, '.wmlsc', 'application/vnd.wap.wmlscriptc', 'script', 'WMLScript', 1),
(658, '.wpd', 'application/vnd.wordperfect', '', 'Wordperfect', 1),
(659, '.stf', 'application/vnd.wt.stf', '', 'Worldtalk', 1),
(660, '.wsdl', 'application/wsdl+xml', '', 'WSDL - Web Services Description Language', 1),
(661, '.xbm', 'image/x-xbitmap', '', 'X BitMap', 1),
(662, '.xpm', 'image/x-xpixmap', '', 'X PixMap', 1),
(663, '.xwd', 'image/x-xwindowdump', '', 'X Window Dump', 1),
(664, '.der', 'application/x-x509-ca-cert', '', 'X.509 Certificate', 1),
(665, '.fig', 'application/x-xfig', '', 'Xfig', 1),
(666, '.xhtml', 'application/xhtml+xml', 'script', 'XHTML - The Extensible HyperText Markup Language', 1),
(667, '.xml', 'application/xml', 'script', 'XML - Extensible Markup Language', 1),
(668, '.xdf', 'application/xcap-diff+xml', '', 'XML Configuration Access Protocol - XCAP Diff', 1),
(669, '.xenc', 'application/xenc+xml', '', 'XML Encryption Syntax and Processing', 1),
(670, '.xer', 'application/patch-ops-error+xml', '', 'XML Patch Framework', 1),
(671, '.rl', 'application/resource-lists+xml', '', 'XML Resource Lists', 1),
(672, '.rs', 'application/rls-services+xml', '', 'XML Resource Lists', 1),
(673, '.rld', 'application/resource-lists-diff+xml', '', 'XML Resource Lists Diff', 1),
(674, '.xslt', 'application/xslt+xml', '', 'XML Transformations', 1),
(675, '.xop', 'application/xop+xml', '', 'XML-Binary Optimized Packaging', 1),
(676, '.xpi', 'application/x-xpinstall', '', 'XPInstall - Mozilla', 1),
(677, '.xspf', 'application/xspf+xml', '', 'XSPF - XML Shareable Playlist Format', 1),
(678, '.xul', 'application/vnd.mozilla.xul+xml', '', 'XUL - XML User Interface Language', 1),
(679, '.xyz', 'chemical/x-xyz', '', 'XYZ File Format', 1),
(680, '.yaml', 'text/yaml', '', 'YAML Ain''t Markup Language / Yet Another Markup Language', 1),
(681, '.yang', 'application/yang', '', 'YANG Data Modeling Language', 1),
(682, '.yin', 'application/yin+xml', '', 'YIN (YANG - XML)', 1),
(683, '.zir', 'application/vnd.zul', '', 'Z.U.L. Geometry', 1),
(684, '.zip', 'application/zip', 'archive', 'Zip Archive', 1),
(685, '.zmm', 'application/vnd.handheld-entertainment+xml', '', 'ZVUE Media Manager', 1),
(686, '.zaz', 'application/vnd.zzazz.deck+xml', '', 'Zzazz Deck', 1),
(687, '.jpeg', 'image/jpeg', 'image', 'JPEG Image', 1),
(688, '.mp3', 'audio/mp3', 'audio', 'MPEG Audio Stream, Layer III', 1);

INSERT IGNORE INTO `#__sellacious_paymentmethods` (`id`, `title`, `description`, `handler`, `success_status`, `percent_fee`, `flat_fee`, `contexts`, `allow_guest`, `state`, `ordering`, `params`) VALUES
(1, 'Cheque', 'Pay by sending us a Cheque valid for 3 month at least. DD should be drawn in favor of Bhartiy Web Technologies payable at Aligarh, Uttar Pradesh.', 'custom', 0, '1.8000', '0.1500', '["cart","addfund"]', 1, 1, 7, ''),
(2, 'E-Wallet Payment System', 'Pay using your sellacious e-wallet', 'ewallet', 0, '0.0000', '0.0000', '["cart"]', 1, 1, 13, ''),
(3, 'Cash On Delivery', 'Pay in Cash when the item is delivered to you', 'cod', 0, '0.0000', '0.0000', '["cart"]', 1, 1, 14, ''),
(4, 'PayPal Standard', 'Pay via PayPal', 'paypalstandard', 1, '3.0000', '1.0000', '["cart","addfund"]', 1, 1, 4, '{"save_form_data":"0","api_mode":"sandbox","sandbox_paypal_email":"dummy@paypal.sellacious.com","live_paypal_email":""}');

INSERT IGNORE INTO `#__sellacious_shoprules` (`id`, `title`, `alias`, `parent_id`, `level`, `path`, `type`, `seller_uid`, `ledger_id`, `amount`, `sum_method`, `state`, `lft`, `rgt`, `publish_up`, `publish_down`, `params`) VALUES
(1, 'ROOT', 'root', 0, 0, '', '', 0, 0, '0', '', 1, 0, 29, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '');

INSERT IGNORE INTO `#__sellacious_splcategories` (`id`, `title`, `alias`, `description`, `recurrence`, `fee_amount`, `images`, `parent_id`, `level`, `path`, `state`, `lft`, `rgt`, `is_core`, `params`, `access`) VALUES
(1, 'ROOT', 'root', '0', 0, '0', '', 0, 0, '', 1, 0, 9, 0, '', 0),
(2, 'Highlighted', 'highlighted', '<p>Will show the product in a highlighted background in the listing.</p>', 10, '3', '', 1, 1, 'highlighted', 1, 1, 4, 1, '{"border-width":"1px","border-style":"solid","border-color":"#ff1003","background-color":"#fffede"}', 5),
(3, 'Bordered', 'bordered', '<p>Will show the product in a bordered box in the listing page</p>', 7, '1', '', 1, 1, 'bordered', 1, 5, 6, 1, '{"border-width":"1px","border-style":"solid","border-color":"#030303","background-color":""}', 5),
(4, 'Featured', 'featured', '<p>Will show the product at the Top in the listing page</p>', 7, '5', '', 1, 1, 'featured', 1, 7, 8, 1, '{"border-width":"1px","border-style":"solid","border-color":"#6b6b6b","background-color":"#fcffcc"}', 5);

INSERT IGNORE INTO `#__sellacious_statuses` (`id`, `title`, `type`, `context`, `stock`, `is_stable`, `notes_required`, `allow_change_to`, `alert`, `usergroups`, `color_code`, `state`, `ordering`, `is_core`) VALUES
(1, 'Order Placed', 'order_placed', 'order', '', 1, 0, '["2","3","65"]', '', '["3"]', '', 1, 1, 1),
(2, 'Payment Pending Approval', 'paid', 'order', '', 1, 1, '["3","65"]', '', '["13"]', '', 1, 2, 1),
(3, 'Payment Approved', 'approved', 'order', '', 1, 1, '["5","67","68","69","70"]', '', '["13"]', '', 1, 3, 1),
(4, 'Cancelled', 'cancellation', 'order', '', 1, 1, '', '', '["12"]', '', 1, 4, 0),
(5, 'Completed', 'completed', 'order', '', 1, 1, '', '', '["12","17"]', '', 1, 5, 0),
(6, 'Payment Approved', 'approved', 'order.physical', 'R', 1, 0, '["7","8","9"]', '', '["12","19","17"]', '#8a0202', 1, 6, 1),
(7, 'Packaged', 'packaged', 'order.physical', '', 0, 0, '["8","9"]', 'This is irreversible process.', '["12","13"]', '', 1, 7, 0),
(8, 'Waiting for Pickup', 'waiting_pickup', 'order.physical', '', 0, 0, '["9"]', '', '["12","13"]', '', 1, 8, 0),
(9, 'Shipped', 'shipped', 'order.physical', 'O', 0, 0, '["10","11"]', '', '["12","13"]', '', 1, 9, 0),
(10, 'Undelivered', 'undelivered', 'order.physical', '', 0, 1, '[9]', '', '', '', 1, 10, 0),
(11, 'Delivered', 'delivered', 'order.physical', 'A', 1, 0, '["15","18"]', '', '["12","13"]', '', 1, 11, 0),
(12, 'Refund Placed', 'refund_placed', 'order.physical', '', 0, 0, '["13","14"]', '', '', '', 1, 12, 1),
(13, 'Refund Approved', 'refunded', 'order.physical', '', 1, 0, '', '', '', '', 1, 13, 0),
(14, 'Refund Declined', 'refund_cancelled', 'order.physical', '', 1, 0, '', '', '', '', 1, 14, 0),
(15, 'Return Placed', 'return_placed', 'order.physical', '', 0, 0, '["16","17"]', '', '["6"]', '', 1, 15, 1),
(16, 'Return Approved', 'returned', 'order.physical', '', 1, 0, '', '', '', '', 1, 16, 0),
(17, 'Return Declined', 'return_cancelled', 'order.physical', '', 1, 1, '', 'This is not reversible', '', '', 1, 17, 0),
(18, 'Exchange Placed', 'exchange_placed', 'order.physical', '', 0, 0, '["19","20"]', '', '', '', 1, 18, 1),
(19, 'Exchange Approved', 'exchanged', 'order.physical', '', 1, 0, '', 'This is not reversible', '', '', 1, 19, 0),
(20, 'Exchange Declined', 'exchange_cancelled', 'order.physical', '', 1, 0, '', '', '', '', 1, 20, 0),
(38, 'Order Placed', 'order_placed', 'order.physical', '', 1, 0, '["6","39","63"]', '', '["12","13"]', '', 1, 23, 1),
(39, 'Payment Pending Approval', 'paid', 'order.physical', '', 1, 1, '["6","63"]', '', '["12","13"]', '', 1, 24, 1),
(41, 'Order Placed', 'order_placed', 'order.electronic', '', 1, 0, '["42","43","64"]', '', '', '', 1, 28, 1),
(42, 'Payment Pending Approval', 'paid', 'order.electronic', '', 1, 1, '["43","64"]', '', '', '', 1, 27, 1),
(43, 'Payment Approved', 'approved', 'order.electronic', 'R', 1, 0, '["44"]', '', '', '#8a0202', 1, 26, 1),
(44, 'Delivered', 'delivered', 'order.electronic', 'O', 0, 0, '', '', '', '', 1, 29, 1),
(45, 'Payment Approved', 'approved', 'order.package', 'R', 1, 0, '["46","47","48"]', '', '["12","19","17"]', '#8a0202', 1, 6, 1),
(46, 'Packaged', 'packaged', 'order.package', '', 0, 0, '["47","48"]', 'This is irretrievable process.', '["12","13"]', '', 1, 7, 0),
(47, 'Waiting for Pickup', 'waiting_pickup', 'order.package', '', 0, 0, '["48"]', '', '["12","13"]', '', 1, 8, 0),
(48, 'Shipped', 'shipped', 'order.package', 'O', 0, 0, '["49","50"]', '', '["12","13"]', '', 1, 9, 0),
(49, 'Undelivered', 'undelivered', 'order.package', '', 0, 1, '["48"]', '', '', '', 1, 10, 0),
(50, 'Delivered', 'delivered', 'order.package', 'O', 1, 0, '["54","57"]', '', '["12","13"]', '', 1, 11, 0),
(51, 'Refund Placed', 'refund_placed', 'order.package', '', 0, 0, '["52","55"]', '', '', '', 1, 12, 1),
(52, 'Refund Approved', 'refunded', 'order.package', '', 1, 0, '', '', '', '', 1, 13, 0),
(53, 'Refund Declined', 'refund_cancelled', 'order.package', '', 1, 0, '', '', '', '', 1, 14, 0),
(54, 'Return Placed', 'return_placed', 'order.package', '', 0, 0, '["55","56"]', '', '', '', 1, 15, 1),
(55, 'Return Approved', 'returned', 'order.package', '', 1, 0, '', '', '', '', 1, 16, 0),
(56, 'Return Declined', 'return_cancelled', 'order.package', '', 1, 1, '', 'This is not reversible', '', '', 1, 17, 0),
(57, 'Exchange Placed', 'exchange_placed', 'order.package', '', 0, 0, '["58","59"]', '', '', '', 1, 18, 1),
(58, 'Exchange Approved', 'exchanged', 'order.package', '', 1, 0, '', 'This is not reversible', '', '', 1, 19, 0),
(59, 'Exchange Declined', 'exchange_cancelled', 'order.package', '', 1, 0, '', '', '', '', 1, 20, 0),
(60, 'Order Placed', 'order_placed', 'order.package', '', 1, 0, '["61","62"]', '', '["12","13"]', '', 1, 23, 1),
(61, 'Payment Pending Approval', 'paid', 'order.package', '', 1, 1, '["45","66"]', '', '["12","13"]', '', 1, 24, 1),
(63, 'Payment Failed', 'payment_failed', 'order.physical', '', 1, 0, '', '', '', '', 1, 30, 0),
(64, 'Payment Failed', 'payment_failed', 'order.electronic', '', 1, 0, '', '', '', '', 1, 31, 0),
(65, 'Payment Failed', 'payment_failed', 'order', '', 1, 0, '', '', '', '', 1, 32, 0),
(66, 'Payment Failed', 'payment_failed', 'order.package', '', 1, 0, '', '', '', '', 1, 33, 0),
(67, 'Delivered', 'delivered', 'order', '', 0, 0, '["71","73"]', '', '', '', 1, 34, 0),
(68, 'Shipped', 'shipped', 'order', '', 0, 0, '["67"]', '', '', '', 1, 35, 0),
(69, 'Packaged', 'packaged', 'order', '', 0, 0, '["70"]', '', '', '', 1, 36, 0),
(70, 'Waiting for pick up', 'waiting_pickup', 'order', '', 0, 0, '["68"]', '', '', '', 1, 37, 0),
(71, 'Return placed ', 'return_placed', 'order', '', 0, 0, '["74","75"]', '', '', '', 1, 38, 0),
(72, 'Delivered', 'delivered', 'order.electronic', 'O', 0, 0, '', '', '', '', 1, 39, 0),
(73, 'Exchange Placed', 'exchange_placed', 'order', '', 0, 0, '["77","78"]', '', '', '', 1, 40, 0),
(74, 'Return Approved ', 'returned', 'order', '', 0, 0, '["76"]', '', '', '', 1, 41, 0),
(75, 'Return Decline', 'return_cancelled', 'order', '', 0, 0, '', '', '', '', 1, 42, 0),
(76, 'Returned', 'returned', 'order', '', 0, 0, '', '', '', '', 1, 43, 0),
(77, 'Exchange Approved', 'exchanged', 'order', '', 0, 1, '', '', '', '', 1, 44, 0),
(78, 'Exchange Declined', 'exchange_cancelled', 'order', '', 0, 1, '', '', '', '', 1, 45, 0);

INSERT IGNORE INTO `#__sellacious_units` (`id`, `title`, `alias`, `symbol`, `unit_group`, `decimal_places`, `state`, `ordering`) VALUES
(1, 'Centimeter', 'centimeter', 'cm', 'Length', 2, 1, 1),
(2, 'Meter', 'meter', 'm', 'Length', 2, 1, 2),
(4, 'Pound', 'lb', 'lb', 'Weight', 3, 1, 4),
(5, 'KiloGram', 'kilogram', 'Kg', 'Weight', 3, 1, 5),
(6, 'Litre', 'litre', 'ltr', 'Volume', 2, 1, 6),
(7, 'Mili-Litre', 'mili-litre', 'ml', 'Volume', 3, 1, 7),
(8, 'Inch', 'inch', 'in', 'Length', 2, 1, 8),
(9, 'Milimeter', 'milimeter', 'mm', 'Length', 2, 1, 9),
(10, 'Foot', 'foot', 'ft', 'Length', 2, 1, 10),
(11, 'Yard', 'yard', 'yd', 'Length', 2, 1, 11),
(12, 'US Gallon', 'gallon', 'gal', 'Volume', 2, 1, 12),
(13, 'US fluid ounce', 'us-fluid-ounce', 'fl oz', 'Volume', 2, 1, 13),
(14, 'Cubic meter', 'cubic-meter', 'cm', 'Volume', 2, 1, 14),
(16, 'Miligram', 'miligram', 'mg', 'Weight', 2, 1, 16),
(17, 'Gram', 'gram', 'g', 'Weight', 2, 1, 17),
(18, 'US Ton', 'us-ton', 'ton', 'Weight', 2, 1, 18),
(19, 'Ounce', 'ounce', 'oz', 'Weight', 2, 1, 19);

INSERT IGNORE INTO `#__sellacious_unitconversions` (`id`, `from`, `to`, `rate`, `state`, `ordering`) VALUES
(1, 2, 11, 1.09361, 1, 1),
(2, 1, 11, 0.0109361, 1, 2),
(3, 3, 2, 1000, 1, 3),
(4, 5, 19, 35.274, 1, 4),
(5, 7, 14, 0.000001, 1, 5),
(6, 6, 14, 0.001, 1, 6),
(7, 8, 11, 0.0277778, 1, 7),
(8, 9, 11, 0.00109361, 1, 8),
(9, 10, 11, 0.333333, 1, 9),
(10, 11, 10, 3, 1, 10),
(11, 10, 9, 304.8, 1, 11),
(12, 11, 9, 914.4, 1, 12),
(13, 10, 8, 12, 1, 13),
(14, 9, 10, 0.00328084, 1, 14),
(15, 8, 10, 0.08333, 1, 15),
(16, 9, 8, 0.00005, 1, 16),
(17, 10, 2, 0, 1, 17),
(18, 11, 8, 36, 1, 18),
(19, 12, 14, 0.00378541, 1, 19),
(20, 13, 14, 0.000029574, 1, 20),
(21, 14, 13, 33813.5, 1, 21),
(22, 12, 13, 127.99803, 1, 22),
(23, 13, 7, 29.574, 1, 23),
(24, 14, 12, 264.17218, 1, 24),
(25, 15, 5, 0, 1, 25),
(26, 16, 19, 0.000035274, 1, 26),
(27, 17, 19, 0.035274, 1, 27),
(28, 18, 19, 32000, 1, 28),
(29, 19, 18, 0.00003125, 1, 29),
(30, 4, 19, 16, 1, 30),
(31, 18, 17, 907185, 1, 31),
(32, 16, 5, 0.000001, 1, 32),
(33, 17, 15, 0.001, 1, 33),
(34, 18, 15, 907.185, 1, 34),
(35, 19, 17, 28.34949, 1, 35),
(36, 1, 10, 0.03281, 1, 36),
(37, 2, 10, 0, 1, 37),
(38, 1, 9, 10, 1, 38),
(39, 8, 9, 18655, 1, 39),
(40, 8, 2, 0, 1, 40),
(41, 20, 1, 0, 1, 41),
(42, 20, 2, 0, 1, 42),
(43, 20, 8, 0, 1, 43),
(44, 20, 9, 0, 1, 44),
(45, 20, 10, 0, 1, 45),
(46, 20, 11, 0, 1, 46),
(47, 1, 2, 0, 1, 47),
(48, 1, 8, 0, 1, 48),
(49, 1, 20, 0, 1, 49);

INSERT IGNORE INTO `#__sellacious_media` (`id`, `table_name`, `record_id`, `context`, `path`, `original_name`, `type`, `size`, `doc_type`, `doc_reference`, `protected`, `state`, `ordering`, `params`) VALUES
(1, 'config', 1, 'shop_logo', 'images/com_sellacious/config/shop_logo/1/b6872a36384d4a06c957a6797892a617b8488a08-794.png', 'sellacious-logo-main.png', 'image/png', 8594, '', '', 0, 1, 1, ''),
(2, 'config', 2, 'purchase_return_icon', 'images/com_sellacious/config/purchase_return_icon/2/a8fe1a3055f1f0ffd108d97904f54088f77b147b-794.png', '7-return.png', 'image/png', 30821, '', '7', 0, 1, 2, ''),
(3, 'config', 2, 'purchase_return_icon', 'images/com_sellacious/config/purchase_return_icon/2/fb73614e80c4712d6158cb1df5c8bff9fce0428e-794.png', '10-return.png', 'image/png', 32405, '', '10', 0, 1, 3, ''),
(4, 'config', 2, 'purchase_return_icon', 'images/com_sellacious/config/purchase_return_icon/2/470d26154a8d38d00fa771d7ca2e4193a5070c15-794.png', '15-return.png', 'image/png', 32426, '', '15', 0, 1, 4, ''),
(5, 'config', 2, 'purchase_return_icon', 'images/com_sellacious/config/purchase_return_icon/2/5bcfbb86d248dab78a9e2e5b1cd4b12d835b68d5-794.png', '30-return.png', 'image/png', 33476, '', '30', 0, 1, 5, ''),
(6, 'config', 2, 'purchase_exchange_icon', 'images/com_sellacious/config/purchase_exchange_icon/2/486b9a5d9afea12d03917b7519532beaa9673e90-794.png', '7-exchange.png', 'image/png', 31655, '', '7', 0, 1, 6, ''),
(7, 'config', 2, 'purchase_exchange_icon', 'images/com_sellacious/config/purchase_exchange_icon/2/95f8597de777d9c0015250dee6794ad7ca9acd6e-794.png', '10-exchange.png', 'image/png', 33240, '', '10', 0, 1, 7, ''),
(8, 'config', 2, 'purchase_exchange_icon', 'images/com_sellacious/config/purchase_exchange_icon/2/1c58c02c1179a564523a9a2d8b78acfd8d3e874b-794.png', '15-exchange.png', 'image/png', 33258, '', '15', 0, 1, 8, ''),
(9, 'config', 2, 'purchase_exchange_icon', 'images/com_sellacious/config/purchase_exchange_icon/2/8a2b899c1666b9d1c0855dd758191830e4ff5296-794.png', '30-exchange.png', 'image/png', 34311, '', '30', 0, 1, 9, '');

-- We will include language strings table here itself for quick fix.
-- This should be supported by its component installer itself
CREATE TABLE IF NOT EXISTS `#__languages_strings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lang_constant` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `orig_text` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `client` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `extension` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `filename` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
