INSERT INTO `shipzonecountry` (`id`, `code`, `country_code`) VALUES
(1, 'domestic', 'CH'),
(2, 'domestic', 'LI'),
(508, 'plfcz1', 'FR'),
(4, 'all', 'AD'),
(5, 'all', 'AE'),
(6, 'all', 'AF'),
(7, 'all', 'AG'),
(8, 'all', 'AI'),
(9, 'all', 'AL'),
(10, 'all', 'AM'),
(11, 'all', 'AN'),
(12, 'all', 'AO'),
(13, 'all', 'AP'),
(14, 'all', 'AQ'),
(15, 'all', 'AR'),
(16, 'all', 'AS'),
(17, 'all', 'AT'),
(18, 'all', 'AU'),
(19, 'all', 'AW'),
(20, 'all', 'AZ'),
(21, 'all', 'BA'),
(22, 'all', 'BB'),
(23, 'all', 'BD'),
(24, 'all', 'BE'),
(25, 'all', 'BF'),
(26, 'all', 'BG'),
(27, 'all', 'BH'),
(28, 'all', 'BI'),
(29, 'all', 'BJ'),
(30, 'all', 'BM'),
(31, 'all', 'BN'),
(32, 'all', 'BO'),
(33, 'all', 'BR'),
(34, 'all', 'BS'),
(35, 'all', 'BT'),
(36, 'all', 'BV'),
(37, 'all', 'BW'),
(38, 'all', 'BY'),
(39, 'all', 'BZ'),
(40, 'all', 'CA'),
(41, 'all', 'CC'),
(42, 'all', 'CD'),
(43, 'all', 'CF'),
(44, 'all', 'CG'),
(45, 'all', 'CH'),
(46, 'all', 'CI'),
(47, 'all', 'CK'),
(48, 'all', 'CL'),
(49, 'all', 'CM'),
(50, 'all', 'CN'),
(51, 'all', 'CO'),
(52, 'all', 'CR'),
(53, 'all', 'CU'),
(54, 'all', 'CV'),
(55, 'all', 'CX'),
(56, 'all', 'CY'),
(57, 'all', 'CZ'),
(58, 'all', 'DE'),
(59, 'all', 'DJ'),
(60, 'all', 'DK'),
(61, 'all', 'DM'),
(62, 'all', 'DO'),
(63, 'all', 'DZ'),
(64, 'all', 'EC'),
(65, 'all', 'EE'),
(66, 'all', 'EG'),
(67, 'all', 'EH'),
(68, 'all', 'EI'),
(69, 'all', 'ER'),
(70, 'all', 'ES'),
(71, 'all', 'ET'),
(72, 'all', 'FI'),
(73, 'all', 'FJ'),
(74, 'all', 'FK'),
(75, 'all', 'FM'),
(76, 'all', 'FO'),
(77, 'all', 'FR'),
(78, 'all', 'FX'),
(79, 'all', 'GA'),
(80, 'all', 'GB'),
(81, 'all', 'GD'),
(82, 'all', 'GE'),
(83, 'all', 'GF'),
(84, 'all', 'GH'),
(85, 'all', 'GI'),
(86, 'all', 'GL'),
(87, 'all', 'GM'),
(88, 'all', 'GN'),
(89, 'all', 'GP'),
(90, 'all', 'GQ'),
(91, 'all', 'GR'),
(92, 'all', 'GS'),
(93, 'all', 'GT'),
(94, 'all', 'GU'),
(95, 'all', 'GW'),
(96, 'all', 'GY'),
(97, 'all', 'HK'),
(98, 'all', 'HM'),
(99, 'all', 'HN'),
(100, 'all', 'HR'),
(101, 'all', 'HT'),
(102, 'all', 'HU'),
(103, 'all', 'ID'),
(104, 'all', 'IE'),
(105, 'all', 'IL'),
(106, 'all', 'IN'),
(107, 'all', 'IO'),
(108, 'all', 'IQ'),
(109, 'all', 'IR'),
(110, 'all', 'IS'),
(111, 'all', 'IT'),
(112, 'all', 'JM'),
(113, 'all', 'JO'),
(114, 'all', 'JP'),
(115, 'all', 'KE'),
(116, 'all', 'KG'),
(117, 'all', 'KH'),
(118, 'all', 'KI'),
(119, 'all', 'KM'),
(120, 'all', 'KN'),
(121, 'all', 'KP'),
(122, 'all', 'KR'),
(123, 'all', 'KW'),
(124, 'all', 'KY'),
(125, 'all', 'KZ'),
(126, 'all', 'LA'),
(127, 'all', 'LB'),
(128, 'all', 'LC'),
(129, 'all', 'LI'),
(130, 'all', 'LK'),
(131, 'all', 'LR'),
(132, 'all', 'LS'),
(133, 'all', 'LT'),
(134, 'all', 'LU'),
(135, 'all', 'LV'),
(136, 'all', 'LY'),
(137, 'all', 'MA'),
(138, 'all', 'MC'),
(139, 'all', 'MD'),
(140, 'all', 'ME'),
(141, 'all', 'MG'),
(142, 'all', 'MH'),
(143, 'all', 'MK'),
(144, 'all', 'ML'),
(145, 'all', 'MM'),
(146, 'all', 'MN'),
(147, 'all', 'MO'),
(148, 'all', 'MP'),
(149, 'all', 'MQ'),
(150, 'all', 'MR'),
(151, 'all', 'MS'),
(152, 'all', 'MT'),
(153, 'all', 'MU'),
(154, 'all', 'MV'),
(155, 'all', 'MW'),
(156, 'all', 'MX'),
(157, 'all', 'MY'),
(158, 'all', 'MZ'),
(159, 'all', 'NA'),
(160, 'all', 'NC'),
(161, 'all', 'NE'),
(162, 'all', 'NF'),
(163, 'all', 'NG'),
(164, 'all', 'NI'),
(165, 'all', 'NL'),
(166, 'all', 'NO'),
(167, 'all', 'NP'),
(168, 'all', 'NR'),
(169, 'all', 'NU'),
(170, 'all', 'NV'),
(171, 'all', 'NZ'),
(172, 'all', 'OM'),
(173, 'all', 'PA'),
(174, 'all', 'PE'),
(175, 'all', 'PF'),
(176, 'all', 'PG'),
(177, 'all', 'PH'),
(178, 'all', 'PK'),
(179, 'all', 'PL'),
(180, 'all', 'PM'),
(181, 'all', 'PN'),
(182, 'all', 'PR'),
(183, 'all', 'PS'),
(184, 'all', 'PT'),
(185, 'all', 'PW'),
(186, 'all', 'PY'),
(187, 'all', 'QA'),
(188, 'all', 'RE'),
(189, 'all', 'RO'),
(190, 'all', 'RU'),
(191, 'all', 'RW'),
(192, 'all', 'SA'),
(193, 'all', 'SB'),
(194, 'all', 'SC'),
(195, 'all', 'SD'),
(196, 'all', 'SE'),
(197, 'all', 'SG'),
(198, 'all', 'SH'),
(199, 'all', 'SI'),
(200, 'all', 'SJ'),
(201, 'all', 'SK'),
(202, 'all', 'SL'),
(203, 'all', 'SM'),
(204, 'all', 'SN'),
(205, 'all', 'SO'),
(206, 'all', 'SR'),
(207, 'all', 'ST'),
(208, 'all', 'SV'),
(209, 'all', 'SY'),
(210, 'all', 'SZ'),
(211, 'all', 'TA'),
(212, 'all', 'TC'),
(213, 'all', 'TD'),
(214, 'all', 'TF'),
(215, 'all', 'TG'),
(216, 'all', 'TH'),
(217, 'all', 'TJ'),
(218, 'all', 'TK'),
(219, 'all', 'TM'),
(220, 'all', 'TN'),
(221, 'all', 'TO'),
(222, 'all', 'TP'),
(223, 'all', 'TR'),
(224, 'all', 'TT'),
(225, 'all', 'TV'),
(226, 'all', 'TW'),
(227, 'all', 'TZ'),
(228, 'all', 'UA'),
(229, 'all', 'UG'),
(230, 'all', 'UM'),
(231, 'all', 'US'),
(232, 'all', 'UY'),
(233, 'all', 'UZ'),
(234, 'all', 'VA'),
(235, 'all', 'VC'),
(236, 'all', 'VE'),
(237, 'all', 'VG'),
(238, 'all', 'VI'),
(239, 'all', 'VN'),
(240, 'all', 'VU'),
(241, 'all', 'WF'),
(242, 'all', 'WS'),
(507, 'plfcz1', 'FI'),
(244, 'all', 'XE'),
(245, 'all', 'XS'),
(246, 'all', 'XU'),
(505, 'plfcz1', 'XE'),
(248, 'all', 'YE'),
(249, 'all', 'YT'),
(250, 'all', 'YU'),
(251, 'all', 'ZA'),
(252, 'all', 'ZM'),
(253, 'all', 'ZR'),
(254, 'all', 'ZW'),
(255, 'foreign', 'AD'),
(256, 'foreign', 'AE'),
(257, 'foreign', 'AF'),
(258, 'foreign', 'AG'),
(259, 'foreign', 'AI'),
(260, 'foreign', 'AL'),
(261, 'foreign', 'AM'),
(262, 'foreign', 'AN'),
(263, 'foreign', 'AO'),
(264, 'foreign', 'AP'),
(265, 'foreign', 'AQ'),
(266, 'foreign', 'AR'),
(267, 'foreign', 'AS'),
(268, 'foreign', 'AT'),
(269, 'foreign', 'AU'),
(270, 'foreign', 'AW'),
(271, 'foreign', 'AZ'),
(272, 'foreign', 'BA'),
(273, 'foreign', 'BB'),
(274, 'foreign', 'BD'),
(275, 'foreign', 'BE'),
(276, 'foreign', 'BF'),
(277, 'foreign', 'BG'),
(278, 'foreign', 'BH'),
(279, 'foreign', 'BI'),
(280, 'foreign', 'BJ'),
(281, 'foreign', 'BM'),
(282, 'foreign', 'BN'),
(283, 'foreign', 'BO'),
(284, 'foreign', 'BR'),
(285, 'foreign', 'BS'),
(286, 'foreign', 'BT'),
(287, 'foreign', 'BV'),
(288, 'foreign', 'BW'),
(289, 'foreign', 'BY'),
(290, 'foreign', 'BZ'),
(291, 'foreign', 'CA'),
(292, 'foreign', 'CC'),
(293, 'foreign', 'CD'),
(294, 'foreign', 'CF'),
(295, 'foreign', 'CG'),
(296, 'foreign', 'CI'),
(297, 'foreign', 'CK'),
(298, 'foreign', 'CL'),
(299, 'foreign', 'CM'),
(300, 'foreign', 'CN'),
(301, 'foreign', 'CO'),
(302, 'foreign', 'CR'),
(303, 'foreign', 'CU'),
(304, 'foreign', 'CV'),
(305, 'foreign', 'CX'),
(306, 'foreign', 'CY'),
(307, 'foreign', 'CZ'),
(308, 'foreign', 'DE'),
(309, 'foreign', 'DJ'),
(310, 'foreign', 'DK'),
(311, 'foreign', 'DM'),
(312, 'foreign', 'DO'),
(313, 'foreign', 'DZ'),
(314, 'foreign', 'EC'),
(315, 'foreign', 'EE'),
(316, 'foreign', 'EG'),
(317, 'foreign', 'EH'),
(318, 'foreign', 'EI'),
(319, 'foreign', 'ER'),
(320, 'foreign', 'ES'),
(321, 'foreign', 'ET'),
(322, 'foreign', 'FI'),
(323, 'foreign', 'FJ'),
(324, 'foreign', 'FK'),
(325, 'foreign', 'FM'),
(326, 'foreign', 'FO'),
(327, 'foreign', 'FR'),
(328, 'foreign', 'FX'),
(329, 'foreign', 'GA'),
(330, 'foreign', 'GB'),
(331, 'foreign', 'GD'),
(332, 'foreign', 'GE'),
(333, 'foreign', 'GF'),
(334, 'foreign', 'GH'),
(335, 'foreign', 'GI'),
(336, 'foreign', 'GL'),
(337, 'foreign', 'GM'),
(338, 'foreign', 'GN'),
(339, 'foreign', 'GP'),
(340, 'foreign', 'GQ'),
(341, 'foreign', 'GR'),
(342, 'foreign', 'GS'),
(343, 'foreign', 'GT'),
(344, 'foreign', 'GU'),
(345, 'foreign', 'GW'),
(346, 'foreign', 'GY'),
(347, 'foreign', 'HK'),
(348, 'foreign', 'HM'),
(349, 'foreign', 'HN'),
(350, 'foreign', 'HR'),
(351, 'foreign', 'HT'),
(352, 'foreign', 'HU'),
(353, 'foreign', 'ID'),
(354, 'foreign', 'IE'),
(355, 'foreign', 'IL'),
(356, 'foreign', 'IN'),
(357, 'foreign', 'IO'),
(358, 'foreign', 'IQ'),
(359, 'foreign', 'IR'),
(360, 'foreign', 'IS'),
(361, 'foreign', 'IT'),
(362, 'foreign', 'JM'),
(363, 'foreign', 'JO'),
(364, 'foreign', 'JP'),
(365, 'foreign', 'KE'),
(366, 'foreign', 'KG'),
(367, 'foreign', 'KH'),
(368, 'foreign', 'KI'),
(369, 'foreign', 'KM'),
(370, 'foreign', 'KN'),
(371, 'foreign', 'KP'),
(372, 'foreign', 'KR'),
(373, 'foreign', 'KW'),
(374, 'foreign', 'KY'),
(375, 'foreign', 'KZ'),
(376, 'foreign', 'LA'),
(377, 'foreign', 'LB'),
(378, 'foreign', 'LC'),
(379, 'foreign', 'LK'),
(380, 'foreign', 'LR'),
(381, 'foreign', 'LS'),
(382, 'foreign', 'LT'),
(383, 'foreign', 'LU'),
(384, 'foreign', 'LV'),
(385, 'foreign', 'LY'),
(386, 'foreign', 'MA'),
(387, 'foreign', 'MC'),
(388, 'foreign', 'MD'),
(389, 'foreign', 'ME'),
(390, 'foreign', 'MG'),
(391, 'foreign', 'MH'),
(392, 'foreign', 'MK'),
(393, 'foreign', 'ML'),
(394, 'foreign', 'MM'),
(395, 'foreign', 'MN'),
(396, 'foreign', 'MO'),
(397, 'foreign', 'MP'),
(398, 'foreign', 'MQ'),
(399, 'foreign', 'MR'),
(400, 'foreign', 'MS'),
(401, 'foreign', 'MT'),
(402, 'foreign', 'MU'),
(403, 'foreign', 'MV'),
(404, 'foreign', 'MW'),
(405, 'foreign', 'MX'),
(406, 'foreign', 'MY'),
(407, 'foreign', 'MZ'),
(408, 'foreign', 'NA'),
(409, 'foreign', 'NC'),
(410, 'foreign', 'NE'),
(411, 'foreign', 'NF'),
(412, 'foreign', 'NG'),
(413, 'foreign', 'NI'),
(414, 'foreign', 'NL'),
(415, 'foreign', 'NO'),
(416, 'foreign', 'NP'),
(417, 'foreign', 'NR'),
(418, 'foreign', 'NU'),
(419, 'foreign', 'NV'),
(420, 'foreign', 'NZ'),
(421, 'foreign', 'OM'),
(422, 'foreign', 'PA'),
(423, 'foreign', 'PE'),
(424, 'foreign', 'PF'),
(425, 'foreign', 'PG'),
(426, 'foreign', 'PH'),
(427, 'foreign', 'PK'),
(428, 'foreign', 'PL'),
(429, 'foreign', 'PM'),
(430, 'foreign', 'PN'),
(431, 'foreign', 'PR'),
(432, 'foreign', 'PS'),
(433, 'foreign', 'PT'),
(434, 'foreign', 'PW'),
(435, 'foreign', 'PY'),
(436, 'foreign', 'QA'),
(437, 'foreign', 'RE'),
(438, 'foreign', 'RO'),
(439, 'foreign', 'RU'),
(440, 'foreign', 'RW'),
(441, 'foreign', 'SA'),
(442, 'foreign', 'SB'),
(443, 'foreign', 'SC'),
(444, 'foreign', 'SD'),
(445, 'foreign', 'SE'),
(446, 'foreign', 'SG'),
(447, 'foreign', 'SH'),
(448, 'foreign', 'SI'),
(449, 'foreign', 'SJ'),
(450, 'foreign', 'SK'),
(451, 'foreign', 'SL'),
(452, 'foreign', 'SM'),
(453, 'foreign', 'SN'),
(454, 'foreign', 'SO'),
(455, 'foreign', 'SR'),
(456, 'foreign', 'ST'),
(457, 'foreign', 'SV'),
(458, 'foreign', 'SY'),
(459, 'foreign', 'SZ'),
(460, 'foreign', 'TA'),
(461, 'foreign', 'TC'),
(462, 'foreign', 'TD'),
(463, 'foreign', 'TF'),
(464, 'foreign', 'TG'),
(465, 'foreign', 'TH'),
(466, 'foreign', 'TJ'),
(467, 'foreign', 'TK'),
(468, 'foreign', 'TM'),
(469, 'foreign', 'TN'),
(470, 'foreign', 'TO'),
(471, 'foreign', 'TP'),
(472, 'foreign', 'TR'),
(473, 'foreign', 'TT'),
(474, 'foreign', 'TV'),
(475, 'foreign', 'TW'),
(476, 'foreign', 'TZ'),
(477, 'foreign', 'UA'),
(478, 'foreign', 'UG'),
(479, 'foreign', 'UM'),
(480, 'foreign', 'US'),
(481, 'foreign', 'UY'),
(482, 'foreign', 'UZ'),
(483, 'foreign', 'VA'),
(484, 'foreign', 'VC'),
(485, 'foreign', 'VE'),
(486, 'foreign', 'VG'),
(487, 'foreign', 'VI'),
(488, 'foreign', 'VN'),
(489, 'foreign', 'VU'),
(490, 'foreign', 'WF'),
(491, 'foreign', 'WS'),
(506, 'plfcz1', 'DK'),
(493, 'foreign', 'XE'),
(494, 'foreign', 'XS'),
(495, 'foreign', 'XU'),
(504, 'plfcz1', 'BE'),
(497, 'foreign', 'YE'),
(498, 'foreign', 'YT'),
(499, 'foreign', 'YU'),
(500, 'foreign', 'ZA'),
(501, 'foreign', 'ZM'),
(502, 'foreign', 'ZR'),
(503, 'foreign', 'ZW'),
(509, 'plfcz1', 'DE'),
(510, 'plfcz1', 'GI'),
(511, 'plfcz1', 'GR'),
(512, 'plfcz1', 'IS'),
(513, 'plfcz1', 'EI'),
(514, 'plfcz1', 'IT'),
(515, 'plfcz1', 'LU'),
(516, 'plfcz1', 'NL'),
(517, 'plfcz1', 'NO'),
(518, 'plfcz1', 'ES'),
(519, 'plfcz1', 'SE'),
(520, 'plfcz1', 'AL'),
(521, 'plfcz1', 'AD'),
(522, 'plfcz1', 'BY'),
(523, 'plfcz1', 'BA'),
(524, 'plfcz1', 'BG'),
(525, 'plfcz1', 'EE'),
(526, 'plfcz1', 'FO'),
(527, 'plfcz1', 'GL'),
(528, 'plfcz1', 'GB'),
(529, 'plfcz1', 'HR'),
(530, 'plfcz1', 'LV'),
(531, 'plfcz1', 'LT'),
(532, 'plfcz1', 'MT'),
(533, 'plfcz1', 'MK'),
(534, 'plfcz1', 'MD'),
(535, 'plfcz1', 'MC'),
(536, 'plfcz1', 'AT'),
(537, 'plfcz1', 'PL'),
(538, 'plfcz1', 'PT'),
(539, 'plfcz1', 'RO'),
(540, 'plfcz1', 'RU'),
(541, 'plfcz1', 'SM'),
(542, 'plfcz1', 'XS'),
(543, 'plfcz1', 'SK'),
(544, 'plfcz1', 'SI'),
(545, 'plfcz1', 'CZ'),
(546, 'plfcz1', 'TR'),
(547, 'plfcz1', 'UA'),
(548, 'plfcz1', 'HU'),
(549, 'plfcz1', 'VA'),
(550, 'plfcz1', 'CY'),
(551, 'plfcz2', 'AF'),
(552, 'plfcz2', 'DZ'),
(553, 'plfcz2', 'AS'),
(554, 'plfcz2', 'AO'),
(555, 'plfcz2', 'AI'),
(556, 'plfcz2', 'AQ'),
(557, 'plfcz2', 'AG'),
(558, 'plfcz2', 'AR'),
(559, 'plfcz2', 'AM'),
(560, 'plfcz2', 'AW'),
(561, 'plfcz2', 'AU'),
(562, 'plfcz2', 'AZ'),
(563, 'plfcz2', 'AP'),
(564, 'plfcz2', 'BS'),
(565, 'plfcz2', 'BH'),
(566, 'plfcz2', 'BD'),
(567, 'plfcz2', 'BB'),
(568, 'plfcz2', 'BZ'),
(569, 'plfcz2', 'BJ'),
(570, 'plfcz2', 'BM'),
(571, 'plfcz2', 'BT'),
(572, 'plfcz2', 'BO'),
(573, 'plfcz2', 'BW'),
(574, 'plfcz2', 'BV'),
(575, 'plfcz2', 'BR'),
(576, 'plfcz2', 'IO'),
(577, 'plfcz2', 'VG'),
(578, 'plfcz2', 'BN'),
(579, 'plfcz2', 'BF'),
(580, 'plfcz2', 'BI'),
(581, 'plfcz2', 'KH'),
(582, 'plfcz2', 'CM'),
(583, 'plfcz2', 'CA'),
(584, 'plfcz2', 'CV'),
(585, 'plfcz2', 'KY'),
(586, 'plfcz2', 'CF'),
(587, 'plfcz2', 'TD'),
(588, 'plfcz2', 'CL'),
(589, 'plfcz2', 'CN'),
(590, 'plfcz2', 'CX'),
(591, 'plfcz2', 'CC'),
(592, 'plfcz2', 'CO'),
(593, 'plfcz2', 'KM'),
(594, 'plfcz2', 'CG'),
(595, 'plfcz2', 'CD'),
(596, 'plfcz2', 'CK'),
(597, 'plfcz2', 'CR'),
(598, 'plfcz2', 'CI'),
(599, 'plfcz2', 'CU'),
(600, 'plfcz2', 'DJ'),
(601, 'plfcz2', 'DM'),
(602, 'plfcz2', 'DO'),
(603, 'plfcz2', 'TP'),
(604, 'plfcz2', 'EC'),
(605, 'plfcz2', 'EG'),
(606, 'plfcz2', 'SV'),
(607, 'plfcz2', 'GQ'),
(608, 'plfcz2', 'ER'),
(609, 'plfcz2', 'ET'),
(610, 'plfcz2', 'FK'),
(611, 'plfcz2', 'FJ'),
(612, 'plfcz2', 'FX'),
(613, 'plfcz2', 'GF'),
(614, 'plfcz2', 'PF'),
(615, 'plfcz2', 'TA'),
(616, 'plfcz2', 'TF'),
(617, 'plfcz2', 'GA'),
(618, 'plfcz2', 'GM'),
(619, 'plfcz2', 'GE'),
(620, 'plfcz2', 'GH'),
(621, 'plfcz2', 'GD'),
(622, 'plfcz2', 'GP'),
(623, 'plfcz2', 'GU'),
(624, 'plfcz2', 'GT'),
(625, 'plfcz2', 'GN'),
(626, 'plfcz2', 'GW'),
(627, 'plfcz2', 'GY'),
(628, 'plfcz2', 'HT'),
(629, 'plfcz2', 'HM'),
(630, 'plfcz2', 'HN'),
(631, 'plfcz2', 'HK'),
(632, 'plfcz2', 'IN'),
(633, 'plfcz2', 'ID'),
(634, 'plfcz2', 'IR'),
(635, 'plfcz2', 'IQ'),
(636, 'plfcz2', 'IE'),
(637, 'plfcz2', 'IL'),
(638, 'plfcz2', 'JM'),
(639, 'plfcz2', 'JP'),
(640, 'plfcz2', 'JO'),
(641, 'plfcz2', 'KZ'),
(642, 'plfcz2', 'KE'),
(643, 'plfcz2', 'KI'),
(644, 'plfcz2', 'KP'),
(645, 'plfcz2', 'KW'),
(646, 'plfcz2', 'KG'),
(647, 'plfcz2', 'LA'),
(648, 'plfcz2', 'LB'),
(649, 'plfcz2', 'LS'),
(650, 'plfcz2', 'LR'),
(651, 'plfcz2', 'LY'),
(652, 'plfcz2', 'MO'),
(653, 'plfcz2', 'MG'),
(654, 'plfcz2', 'ME'),
(655, 'plfcz2', 'MW'),
(656, 'plfcz2', 'MY'),
(657, 'plfcz2', 'MV'),
(658, 'plfcz2', 'ML'),
(659, 'plfcz2', 'MH'),
(660, 'plfcz2', 'MQ'),
(661, 'plfcz2', 'MR'),
(662, 'plfcz2', 'MU'),
(663, 'plfcz2', 'YT'),
(664, 'plfcz2', 'MX'),
(665, 'plfcz2', 'FM'),
(666, 'plfcz2', 'MN'),
(667, 'plfcz2', 'MS'),
(668, 'plfcz2', 'MA'),
(669, 'plfcz2', 'MZ'),
(670, 'plfcz2', 'MM'),
(671, 'plfcz2', 'NA'),
(672, 'plfcz2', 'NR'),
(673, 'plfcz2', 'NP'),
(674, 'plfcz2', 'AN'),
(675, 'plfcz2', 'NC'),
(676, 'plfcz2', 'NZ'),
(677, 'plfcz2', 'NI'),
(678, 'plfcz2', 'NE'),
(679, 'plfcz2', 'NG'),
(680, 'plfcz2', 'NU'),
(681, 'plfcz2', 'NF'),
(682, 'plfcz2', 'MP'),
(683, 'plfcz2', 'OM'),
(684, 'plfcz2', 'PK'),
(685, 'plfcz2', 'PW'),
(686, 'plfcz2', 'PS'),
(687, 'plfcz2', 'PA'),
(688, 'plfcz2', 'PG'),
(689, 'plfcz2', 'PY'),
(690, 'plfcz2', 'PE'),
(691, 'plfcz2', 'PH'),
(692, 'plfcz2', 'PN'),
(693, 'plfcz2', 'PR'),
(694, 'plfcz2', 'QA'),
(695, 'plfcz2', 'RE'),
(696, 'plfcz2', 'RW'),
(697, 'plfcz2', 'KN'),
(698, 'plfcz2', 'ST'),
(699, 'plfcz2', 'SA'),
(700, 'plfcz2', 'SN'),
(701, 'plfcz2', 'SC'),
(702, 'plfcz2', 'SL'),
(703, 'plfcz2', 'SG'),
(704, 'plfcz2', 'SB'),
(705, 'plfcz2', 'SO'),
(706, 'plfcz2', 'ZA'),
(707, 'plfcz2', 'GS'),
(708, 'plfcz2', 'KR'),
(709, 'plfcz2', 'LK'),
(710, 'plfcz2', 'NV'),
(711, 'plfcz2', 'SH'),
(712, 'plfcz2', 'LC'),
(713, 'plfcz2', 'PM'),
(714, 'plfcz2', 'VC'),
(715, 'plfcz2', 'SD'),
(716, 'plfcz2', 'SR'),
(717, 'plfcz2', 'SJ'),
(718, 'plfcz2', 'SZ'),
(719, 'plfcz2', 'SY'),
(720, 'plfcz2', 'TW'),
(721, 'plfcz2', 'TJ'),
(722, 'plfcz2', 'TZ'),
(723, 'plfcz2', 'TH'),
(724, 'plfcz2', 'TG'),
(725, 'plfcz2', 'TK'),
(726, 'plfcz2', 'TO'),
(727, 'plfcz2', 'TT'),
(728, 'plfcz2', 'XU'),
(729, 'plfcz2', 'TN'),
(730, 'plfcz2', 'TM'),
(731, 'plfcz2', 'TC'),
(732, 'plfcz2', 'TV'),
(733, 'plfcz2', 'UG'),
(734, 'plfcz2', 'AE'),
(735, 'plfcz2', 'US'),
(736, 'plfcz2', 'UM'),
(737, 'plfcz2', 'UY'),
(738, 'plfcz2', 'UZ'),
(739, 'plfcz2', 'VU'),
(740, 'plfcz2', 'VE'),
(741, 'plfcz2', 'VN'),
(742, 'plfcz2', 'VI'),
(743, 'plfcz2', 'WF'),
(744, 'plfcz2', 'EH'),
(745, 'plfcz2', 'WS'),
(746, 'plfcz2', 'YE'),
(747, 'plfcz2', 'YU'),
(748, 'plfcz2', 'ZR'),
(749, 'plfcz2', 'ZM'),
(750, 'plfcz2', 'ZW'),
(751, 'ppfcz1', 'AT'),
(752, 'ppfcz1', 'BE'),
(753, 'ppfcz1', 'DE'),
(754, 'ppfcz1', 'FR'),
(755, 'ppfcz1', 'FX'),
(756, 'ppfcz1', 'IT'),
(757, 'ppfcz1', 'LU'),
(758, 'ppfcz1', 'MC'),
(759, 'ppfcz1', 'NL'),
(760, 'ppfcz1', 'SM'),
(761, 'ppfcz1', 'VA'),
(762, 'ppfcz1', 'XE'),
(763, 'ppfcz2', 'AD'),
(764, 'ppfcz2', 'AL'),
(765, 'ppfcz2', 'BA'),
(766, 'ppfcz2', 'BG'),
(767, 'ppfcz2', 'BY'),
(768, 'ppfcz2', 'CY'),
(769, 'ppfcz2', 'CZ'),
(770, 'ppfcz2', 'DK'),
(771, 'ppfcz2', 'EE'),
(772, 'ppfcz2', 'EI'),
(773, 'ppfcz2', 'ES'),
(774, 'ppfcz2', 'FI'),
(775, 'ppfcz2', 'FO'),
(776, 'ppfcz2', 'GB'),
(777, 'ppfcz2', 'GI'),
(778, 'ppfcz2', 'GL'),
(779, 'ppfcz2', 'GR'),
(780, 'ppfcz2', 'HR'),
(781, 'ppfcz2', 'HU'),
(782, 'ppfcz2', 'IE'),
(783, 'ppfcz2', 'IS'),
(784, 'ppfcz2', 'LT'),
(785, 'ppfcz2', 'LV'),
(786, 'ppfcz2', 'MD'),
(787, 'ppfcz2', 'MK'),
(788, 'ppfcz2', 'MT'),
(789, 'ppfcz2', 'NO'),
(790, 'ppfcz2', 'PL'),
(791, 'ppfcz2', 'PT'),
(792, 'ppfcz2', 'RO'),
(793, 'ppfcz2', 'RU'),
(794, 'ppfcz2', 'SE'),
(795, 'ppfcz2', 'SI'),
(796, 'ppfcz2', 'SK'),
(797, 'ppfcz2', 'TR'),
(798, 'ppfcz2', 'UA'),
(799, 'ppfcz2', 'XS'),
(800, 'ppfcz2', 'YU'),
(801, 'ppfcz3', 'CA'),
(802, 'ppfcz3', 'DZ'),
(803, 'ppfcz3', 'EG'),
(804, 'ppfcz3', 'IL'),
(805, 'ppfcz3', 'JO'),
(806, 'ppfcz3', 'LB'),
(807, 'ppfcz3', 'LY'),
(808, 'ppfcz3', 'MA'),
(809, 'ppfcz3', 'MX'),
(810, 'ppfcz3', 'PM'),
(811, 'ppfcz3', 'SY'),
(812, 'ppfcz3', 'TN'),
(813, 'ppfcz3', 'US'),
(814, 'ppfcz4', 'AE'),
(815, 'ppfcz4', 'AF'),
(816, 'ppfcz4', 'AM'),
(817, 'ppfcz4', 'AO'),
(818, 'ppfcz4', 'AZ'),
(819, 'ppfcz4', 'BD'),
(820, 'ppfcz4', 'BF'),
(821, 'ppfcz4', 'BH'),
(822, 'ppfcz4', 'BI'),
(823, 'ppfcz4', 'BJ'),
(824, 'ppfcz4', 'BT'),
(825, 'ppfcz4', 'BV'),
(826, 'ppfcz4', 'BW'),
(827, 'ppfcz4', 'CF'),
(828, 'ppfcz4', 'CG'),
(829, 'ppfcz4', 'CI'),
(830, 'ppfcz4', 'CM'),
(831, 'ppfcz4', 'CN'),
(832, 'ppfcz4', 'DJ'),
(833, 'ppfcz4', 'DO'),
(834, 'ppfcz4', 'ER'),
(835, 'ppfcz4', 'ET'),
(836, 'ppfcz4', 'GA'),
(837, 'ppfcz4', 'GE'),
(838, 'ppfcz4', 'GH'),
(839, 'ppfcz4', 'GM'),
(840, 'ppfcz4', 'GN'),
(841, 'ppfcz4', 'GQ'),
(842, 'ppfcz4', 'GW'),
(843, 'ppfcz4', 'HK'),
(844, 'ppfcz4', 'IN'),
(845, 'ppfcz4', 'IQ'),
(846, 'ppfcz4', 'IR'),
(847, 'ppfcz4', 'JP'),
(848, 'ppfcz4', 'KE'),
(849, 'ppfcz4', 'KG'),
(850, 'ppfcz4', 'KH'),
(851, 'ppfcz4', 'KP'),
(852, 'ppfcz4', 'KW'),
(853, 'ppfcz4', 'KZ'),
(854, 'ppfcz4', 'LA'),
(855, 'ppfcz4', 'LK'),
(856, 'ppfcz4', 'LR'),
(857, 'ppfcz4', 'LS'),
(858, 'ppfcz4', 'MG'),
(859, 'ppfcz4', 'ML'),
(860, 'ppfcz4', 'MM'),
(861, 'ppfcz4', 'MN'),
(862, 'ppfcz4', 'MO'),
(863, 'ppfcz4', 'MR'),
(864, 'ppfcz4', 'MU'),
(865, 'ppfcz4', 'MV'),
(866, 'ppfcz4', 'MW'),
(867, 'ppfcz4', 'MY'),
(868, 'ppfcz4', 'MZ'),
(869, 'ppfcz4', 'NA'),
(870, 'ppfcz4', 'NE'),
(871, 'ppfcz4', 'NG'),
(872, 'ppfcz4', 'NP'),
(873, 'ppfcz4', 'OM'),
(874, 'ppfcz4', 'PK'),
(875, 'ppfcz4', 'QA'),
(876, 'ppfcz4', 'RE'),
(877, 'ppfcz4', 'RW'),
(878, 'ppfcz4', 'SA'),
(879, 'ppfcz4', 'SC'),
(880, 'ppfcz4', 'SD'),
(881, 'ppfcz4', 'SG'),
(882, 'ppfcz4', 'SH'),
(883, 'ppfcz4', 'SL'),
(884, 'ppfcz4', 'SN'),
(885, 'ppfcz4', 'SO'),
(886, 'ppfcz4', 'SZ'),
(887, 'ppfcz4', 'TD'),
(888, 'ppfcz4', 'TG'),
(889, 'ppfcz4', 'TH'),
(890, 'ppfcz4', 'TJ'),
(891, 'ppfcz4', 'TM'),
(892, 'ppfcz4', 'TW'),
(893, 'ppfcz4', 'TZ'),
(894, 'ppfcz4', 'UG'),
(895, 'ppfcz4', 'UZ'),
(896, 'ppfcz4', 'VN'),
(897, 'ppfcz4', 'XU'),
(898, 'ppfcz4', 'YT'),
(899, 'ppfcz4', 'ZA'),
(900, 'ppfcz4', 'ZW'),
(901, 'ppfcz5', 'AG'),
(902, 'ppfcz5', 'AI'),
(903, 'ppfcz5', 'AN'),
(904, 'ppfcz5', 'AP'),
(905, 'ppfcz5', 'AQ'),
(906, 'ppfcz5', 'AR'),
(907, 'ppfcz5', 'AS'),
(908, 'ppfcz5', 'AU'),
(909, 'ppfcz5', 'AW'),
(910, 'ppfcz5', 'BB'),
(911, 'ppfcz5', 'BM'),
(912, 'ppfcz5', 'BN'),
(913, 'ppfcz5', 'BO'),
(914, 'ppfcz5', 'BR'),
(915, 'ppfcz5', 'BS'),
(916, 'ppfcz5', 'BZ'),
(917, 'ppfcz5', 'CC'),
(918, 'ppfcz5', 'CD'),
(919, 'ppfcz5', 'CK'),
(920, 'ppfcz5', 'CL'),
(921, 'ppfcz5', 'CO'),
(922, 'ppfcz5', 'CR'),
(923, 'ppfcz5', 'CU'),
(924, 'ppfcz5', 'CV'),
(925, 'ppfcz5', 'CX'),
(926, 'ppfcz5', 'DM'),
(927, 'ppfcz5', 'EC'),
(928, 'ppfcz5', 'EH'),
(929, 'ppfcz5', 'FJ'),
(930, 'ppfcz5', 'FK'),
(931, 'ppfcz5', 'FM'),
(932, 'ppfcz5', 'GD'),
(933, 'ppfcz5', 'GF'),
(934, 'ppfcz5', 'GP'),
(935, 'ppfcz5', 'GS'),
(936, 'ppfcz5', 'GT'),
(937, 'ppfcz5', 'GU'),
(938, 'ppfcz5', 'GY'),
(939, 'ppfcz5', 'HM'),
(940, 'ppfcz5', 'HN'),
(941, 'ppfcz5', 'HT'),
(942, 'ppfcz5', 'ID'),
(943, 'ppfcz5', 'IO'),
(944, 'ppfcz5', 'JM'),
(945, 'ppfcz5', 'KI'),
(946, 'ppfcz5', 'KM'),
(947, 'ppfcz5', 'KN'),
(948, 'ppfcz5', 'KR'),
(949, 'ppfcz5', 'KY'),
(950, 'ppfcz5', 'LC'),
(951, 'ppfcz5', 'ME'),
(952, 'ppfcz5', 'MH'),
(953, 'ppfcz5', 'MP'),
(954, 'ppfcz5', 'MQ'),
(955, 'ppfcz5', 'MS'),
(956, 'ppfcz5', 'NC'),
(957, 'ppfcz5', 'NF'),
(958, 'ppfcz5', 'NI'),
(959, 'ppfcz5', 'NR'),
(960, 'ppfcz5', 'NU'),
(961, 'ppfcz5', 'NZ'),
(962, 'ppfcz5', 'PA'),
(963, 'ppfcz5', 'PE'),
(964, 'ppfcz5', 'PF'),
(965, 'ppfcz5', 'PG'),
(966, 'ppfcz5', 'PH'),
(967, 'ppfcz5', 'PN'),
(968, 'ppfcz5', 'PR'),
(969, 'ppfcz5', 'PS'),
(970, 'ppfcz5', 'PW'),
(971, 'ppfcz5', 'PY'),
(972, 'ppfcz5', 'SB'),
(973, 'ppfcz5', 'SJ'),
(974, 'ppfcz5', 'SR'),
(975, 'ppfcz5', 'ST'),
(976, 'ppfcz5', 'SV'),
(977, 'ppfcz5', 'TA'),
(978, 'ppfcz5', 'TC'),
(979, 'ppfcz5', 'TF'),
(980, 'ppfcz5', 'TK'),
(981, 'ppfcz5', 'TO'),
(982, 'ppfcz5', 'TP'),
(983, 'ppfcz5', 'TT'),
(984, 'ppfcz5', 'TV'),
(985, 'ppfcz5', 'UM'),
(986, 'ppfcz5', 'UY'),
(987, 'ppfcz5', 'VC'),
(988, 'ppfcz5', 'VE'),
(989, 'ppfcz5', 'VG'),
(990, 'ppfcz5', 'VI'),
(991, 'ppfcz5', 'VU'),
(992, 'ppfcz5', 'WF'),
(993, 'ppfcz5', 'WS'),
(994, 'ppfcz5', 'YE'),
(995, 'ppfcz5', 'ZM'),
(996, 'ppfcz5', 'ZR');


INSERT INTO `shipprice` (`id`, `shipzonecountry_code`, `shipmode_id`, `maxweight`, `price`) VALUES
(1, 'domestic', 26, 0.25, 4.7),
(2, 'domestic', 27, 0.25, 6),
(3, 'domestic', 19, 2, 6.3),
(4, 'domestic', 19, 5, 7.77),
(5, 'domestic', 19, 10, 10.3),
(6, 'domestic', 19, 20, 14.83),
(7, 'domestic', 19, 30, 20.88),
(8, 'domestic', 20, 2, 7.3),
(9, 'domestic', 20, 5, 8.77),
(10, 'domestic', 20, 10, 11.3),
(11, 'domestic', 20, 20, 15.83),
(12, 'domestic', 20, 30, 21.88),
(13, 'domestic', 23, 2, 18.8),
(14, 'domestic', 23, 5, 20.8),
(15, 'domestic', 23, 10, 24.8),
(16, 'domestic', 23, 20, 27.8),
(17, 'domestic', 23, 30, 30.8),
(18, 'domestic', 24, 2, 21.1405),
(19, 'domestic', 24, 5, 22.3705),
(20, 'domestic', 24, 10, 25.0905),
(21, 'domestic', 24, 20, 29.7705),
(22, 'domestic', 24, 30, 35.9605),
(23, 'domestic', 17, 2, 7.2),
(24, 'domestic', 17, 5, 8.43),
(25, 'domestic', 17, 10, 11.15),
(26, 'domestic', 17, 20, 15.83),
(27, 'domestic', 17, 30, 22.02),
(28, 'domestic', 18, 2, 8.2),
(29, 'domestic', 18, 5, 9.43),
(30, 'domestic', 18, 10, 12.15),
(31, 'domestic', 18, 20, 16.83),
(32, 'domestic', 18, 30, 23.02),
(33, 'domestic', 28, 2, 17),
(34, 'domestic', 28, 5, 19),
(35, 'domestic', 28, 10, 22),
(36, 'domestic', 28, 20, 28),
(37, 'domestic', 28, 30, 35),
(38, 'domestic', 29, 30, 29.5),
(39, 'foreign', 25, 200, 0),
(40, 'domestic', 3, 100, 59),
(41, 'foreign', 10, 30, 0),
(42, 'foreign', 22, 0, 0),
(43, 'foreign', 11, 30, 0),
(44, 'foreign', 12, 30, 0),
(45, 'all', 1, 10000, 0),
(46, 'all', 2, 10000, 0),
(47, 'domestic', 9, 10000, 0),
(48, 'domestic', 4, 500, 0),
(49, 'domestic', 5, 500, 0),
(50, 'domestic', 6, 500, 0),
(51, 'domestic', 7, 500, 0),
(52, 'domestic', 8, 500, 0),
(53, 'domestic', 21, 3.9, 10.8),
(54, 'domestic', 21, 4.9, 12.2),
(55, 'domestic', 21, 9.9, 15.3),
(56, 'domestic', 21, 19.9, 20.6),
(57, 'domestic', 21, 30, 28.1),
(58, 'plfcz1', 16, 0.5, 19),
(59, 'plfcz2', 16, 0.5, 25),
(133, 'ppfcz2', 15, 16, 76.5),
(132, 'ppfcz2', 15, 15, 75.5),
(131, 'ppfcz2', 15, 14, 73.5),
(130, 'ppfcz2', 15, 13, 71.5),
(129, 'ppfcz2', 15, 12, 69.5),
(128, 'ppfcz2', 15, 11, 67.5),
(127, 'ppfcz2', 15, 10, 65.5),
(126, 'ppfcz2', 15, 9, 62.5),
(125, 'ppfcz2', 15, 8, 59.5),
(124, 'ppfcz2', 15, 7, 56.5),
(123, 'ppfcz2', 15, 6, 53.5),
(122, 'ppfcz2', 15, 5, 50.5),
(121, 'ppfcz2', 15, 4, 46.5),
(120, 'ppfcz2', 15, 3, 42.5),
(119, 'ppfcz2', 15, 2, 38.5),
(90, 'ppfcz1', 15, 2, 33.5),
(91, 'ppfcz1', 15, 3, 36.5),
(92, 'ppfcz1', 15, 4, 39.5),
(93, 'ppfcz1', 15, 5, 41.5),
(94, 'ppfcz1', 15, 6, 42.5),
(95, 'ppfcz1', 15, 7, 43.5),
(96, 'ppfcz1', 15, 8, 44.5),
(97, 'ppfcz1', 15, 9, 45.5),
(98, 'ppfcz1', 15, 10, 46.5),
(99, 'ppfcz1', 15, 11, 47.5),
(100, 'ppfcz1', 15, 12, 48.5),
(101, 'ppfcz1', 15, 13, 49.5),
(102, 'ppfcz1', 15, 14, 50.5),
(103, 'ppfcz1', 15, 15, 51.5),
(104, 'ppfcz1', 15, 16, 52.5),
(105, 'ppfcz1', 15, 17, 53.5),
(106, 'ppfcz1', 15, 18, 54.5),
(107, 'ppfcz1', 15, 19, 55.5),
(108, 'ppfcz1', 15, 20, 56.5),
(109, 'ppfcz1', 15, 21, 57.5),
(110, 'ppfcz1', 15, 22, 58.5),
(111, 'ppfcz1', 15, 23, 59.5),
(112, 'ppfcz1', 15, 24, 60.5),
(113, 'ppfcz1', 15, 25, 61.5),
(114, 'ppfcz1', 15, 26, 62.5),
(115, 'ppfcz1', 15, 27, 63.5),
(116, 'ppfcz1', 15, 28, 64.5),
(117, 'ppfcz1', 15, 29, 65.5),
(118, 'ppfcz1', 15, 30, 66.5),
(134, 'ppfcz2', 15, 17, 77.5),
(135, 'ppfcz2', 15, 18, 78.5),
(136, 'ppfcz2', 15, 19, 79.5),
(137, 'ppfcz2', 15, 20, 80.5),
(138, 'ppfcz2', 15, 21, 81.5),
(139, 'ppfcz2', 15, 22, 82.5),
(140, 'ppfcz2', 15, 23, 83.5),
(141, 'ppfcz2', 15, 24, 84.5),
(142, 'ppfcz2', 15, 25, 85.5),
(143, 'ppfcz2', 15, 26, 86.5),
(144, 'ppfcz2', 15, 27, 87.5),
(145, 'ppfcz2', 15, 28, 88.5),
(146, 'ppfcz2', 15, 29, 89.5),
(147, 'ppfcz2', 15, 30, 90.5),
(148, 'ppfcz3', 15, 2, 39.5),
(149, 'ppfcz3', 15, 3, 45.5),
(150, 'ppfcz3', 15, 4, 51.5),
(151, 'ppfcz3', 15, 5, 57.5),
(152, 'ppfcz3', 15, 6, 63.5),
(153, 'ppfcz3', 15, 7, 69.5),
(154, 'ppfcz3', 15, 8, 75.5),
(155, 'ppfcz3', 15, 9, 81.5),
(156, 'ppfcz3', 15, 10, 87.5),
(157, 'ppfcz3', 15, 11, 93.5),
(158, 'ppfcz3', 15, 12, 99.5),
(159, 'ppfcz3', 15, 13, 105.5),
(160, 'ppfcz3', 15, 14, 111.5),
(161, 'ppfcz3', 15, 15, 117.5),
(162, 'ppfcz3', 15, 16, 122.5),
(163, 'ppfcz3', 15, 17, 127.5),
(164, 'ppfcz3', 15, 18, 132.5),
(165, 'ppfcz3', 15, 19, 137.5),
(166, 'ppfcz3', 15, 20, 142.5),
(167, 'ppfcz3', 15, 21, 146.5),
(168, 'ppfcz3', 15, 22, 150.5),
(169, 'ppfcz3', 15, 23, 154.5),
(170, 'ppfcz3', 15, 24, 158.5),
(171, 'ppfcz3', 15, 25, 162.5),
(172, 'ppfcz3', 15, 26, 166.5),
(173, 'ppfcz3', 15, 27, 170.5),
(174, 'ppfcz3', 15, 28, 174.5),
(175, 'ppfcz3', 15, 29, 178.5),
(176, 'ppfcz3', 15, 30, 182.5),
(177, 'ppfcz4', 15, 2, 44.5),
(178, 'ppfcz4', 15, 3, 51.5),
(179, 'ppfcz4', 15, 4, 58.5),
(180, 'ppfcz4', 15, 5, 65.5),
(181, 'ppfcz4', 15, 6, 72.5),
(182, 'ppfcz4', 15, 7, 79.5),
(183, 'ppfcz4', 15, 8, 86.5),
(184, 'ppfcz4', 15, 9, 93.5),
(185, 'ppfcz4', 15, 10, 100.5),
(186, 'ppfcz4', 15, 11, 105.5),
(187, 'ppfcz4', 15, 12, 110.5),
(188, 'ppfcz4', 15, 13, 115.5),
(189, 'ppfcz4', 15, 14, 120.5),
(190, 'ppfcz4', 15, 15, 125.5),
(191, 'ppfcz4', 15, 16, 130.5),
(192, 'ppfcz4', 15, 17, 135.5),
(193, 'ppfcz4', 15, 18, 140.5),
(194, 'ppfcz4', 15, 19, 145.5),
(195, 'ppfcz4', 15, 20, 150.5),
(196, 'ppfcz4', 15, 21, 154.5),
(197, 'ppfcz4', 15, 22, 158.5),
(198, 'ppfcz4', 15, 23, 162.5),
(199, 'ppfcz4', 15, 24, 166.5),
(200, 'ppfcz4', 15, 25, 170.5),
(201, 'ppfcz4', 15, 26, 174.5),
(202, 'ppfcz4', 15, 27, 178.5),
(203, 'ppfcz4', 15, 28, 182.5),
(204, 'ppfcz4', 15, 29, 186.5),
(205, 'ppfcz4', 15, 30, 190.5),
(206, 'ppfcz5', 15, 2, 48.5),
(207, 'ppfcz5', 15, 3, 56.5),
(208, 'ppfcz5', 15, 4, 64.5),
(209, 'ppfcz5', 15, 5, 72.5),
(210, 'ppfcz5', 15, 6, 80.5),
(211, 'ppfcz5', 15, 7, 88.5),
(212, 'ppfcz5', 15, 8, 96.5),
(213, 'ppfcz5', 15, 9, 104.5),
(214, 'ppfcz5', 15, 10, 112.5),
(215, 'ppfcz5', 15, 11, 119.5),
(216, 'ppfcz5', 15, 12, 126.5),
(217, 'ppfcz5', 15, 13, 133.5),
(218, 'ppfcz5', 15, 14, 140.5),
(219, 'ppfcz5', 15, 15, 147.5),
(220, 'ppfcz5', 15, 16, 153.5),
(221, 'ppfcz5', 15, 17, 161.5),
(222, 'ppfcz5', 15, 18, 167.5),
(223, 'ppfcz5', 15, 19, 173.5),
(224, 'ppfcz5', 15, 20, 179.5),
(225, 'ppfcz5', 15, 21, 185.5),
(226, 'ppfcz5', 15, 22, 191.5),
(227, 'ppfcz5', 15, 23, 197.5),
(228, 'ppfcz5', 15, 24, 203.5),
(229, 'ppfcz5', 15, 25, 207.5),
(230, 'ppfcz5', 15, 26, 212.5),
(231, 'ppfcz5', 15, 27, 217.5),
(232, 'ppfcz5', 15, 28, 222.5),
(233, 'ppfcz5', 15, 29, 227.5),
(234, 'ppfcz5', 15, 30, 232.5),
(235, 'ppfcz1', 14, 2, 37.5),
(236, 'ppfcz1', 14, 3, 41.5),
(237, 'ppfcz1', 14, 4, 45.5),
(238, 'ppfcz1', 14, 5, 48.5),
(239, 'ppfcz1', 14, 6, 52.5),
(240, 'ppfcz1', 14, 7, 55.5),
(241, 'ppfcz1', 14, 8, 57.5),
(242, 'ppfcz1', 14, 9, 59.5),
(243, 'ppfcz1', 14, 10, 61.5),
(244, 'ppfcz1', 14, 11, 62.5),
(245, 'ppfcz1', 14, 12, 63.5),
(246, 'ppfcz1', 14, 13, 64.5),
(247, 'ppfcz1', 14, 14, 65.5),
(248, 'ppfcz1', 14, 15, 66.5),
(249, 'ppfcz1', 14, 16, 67.5),
(250, 'ppfcz1', 14, 17, 68.5),
(251, 'ppfcz1', 14, 18, 69.5),
(252, 'ppfcz1', 14, 19, 70.5),
(253, 'ppfcz1', 14, 20, 71.5),
(254, 'ppfcz1', 14, 21, 72.5),
(255, 'ppfcz1', 14, 22, 73.5),
(256, 'ppfcz1', 14, 23, 74.5),
(257, 'ppfcz1', 14, 24, 75.5),
(258, 'ppfcz1', 14, 25, 76.5),
(259, 'ppfcz1', 14, 26, 77.5),
(260, 'ppfcz1', 14, 27, 78.5),
(261, 'ppfcz1', 14, 28, 79.5),
(262, 'ppfcz1', 14, 29, 80.5),
(263, 'ppfcz1', 14, 30, 81.5),
(264, 'ppfcz2', 14, 2, 43.5),
(265, 'ppfcz2', 14, 3, 48.5),
(266, 'ppfcz2', 14, 4, 53.5),
(267, 'ppfcz2', 14, 5, 57.5),
(268, 'ppfcz2', 14, 6, 61.5),
(269, 'ppfcz2', 14, 7, 65.5),
(270, 'ppfcz2', 14, 8, 69.5),
(271, 'ppfcz2', 14, 9, 73.5),
(272, 'ppfcz2', 14, 10, 77.5),
(273, 'ppfcz2', 14, 11, 80.5),
(274, 'ppfcz2', 14, 12, 83.5),
(275, 'ppfcz2', 14, 13, 86.5),
(276, 'ppfcz2', 14, 14, 89.5),
(277, 'ppfcz2', 14, 15, 92.5),
(278, 'ppfcz2', 14, 16, 94.5),
(279, 'ppfcz2', 14, 17, 96.5),
(280, 'ppfcz2', 14, 18, 98.5),
(281, 'ppfcz2', 14, 19, 99.5),
(282, 'ppfcz2', 14, 20, 100.5),
(283, 'ppfcz2', 14, 21, 101.5),
(284, 'ppfcz2', 14, 22, 102.5),
(285, 'ppfcz2', 14, 23, 103.5),
(286, 'ppfcz2', 14, 24, 104.5),
(287, 'ppfcz2', 14, 25, 105.5),
(288, 'ppfcz2', 14, 26, 106.5),
(289, 'ppfcz2', 14, 27, 107.5),
(290, 'ppfcz2', 14, 28, 108.5),
(291, 'ppfcz2', 14, 29, 109.5),
(292, 'ppfcz2', 14, 30, 110.5),
(293, 'ppfcz3', 14, 2, 47.5),
(294, 'ppfcz3', 14, 3, 56.5),
(295, 'ppfcz3', 14, 4, 67.5),
(296, 'ppfcz3', 14, 5, 78.5),
(297, 'ppfcz3', 14, 6, 87.5),
(298, 'ppfcz3', 14, 7, 96.5),
(299, 'ppfcz3', 14, 8, 105.5),
(300, 'ppfcz3', 14, 9, 114.5),
(301, 'ppfcz3', 14, 10, 123.5),
(302, 'ppfcz3', 14, 11, 131.5),
(303, 'ppfcz3', 14, 12, 139.5),
(304, 'ppfcz3', 14, 13, 147.5),
(305, 'ppfcz3', 14, 14, 155.5),
(306, 'ppfcz3', 14, 15, 163.5),
(307, 'ppfcz3', 14, 16, 171.5),
(308, 'ppfcz3', 14, 17, 179.5),
(309, 'ppfcz3', 14, 18, 187.5),
(310, 'ppfcz3', 14, 19, 195.5),
(311, 'ppfcz3', 14, 20, 203.5),
(312, 'ppfcz3', 14, 21, 210.5),
(313, 'ppfcz3', 14, 22, 217.5),
(314, 'ppfcz3', 14, 23, 224.5),
(315, 'ppfcz3', 14, 24, 231.5),
(316, 'ppfcz3', 14, 25, 238.5),
(317, 'ppfcz3', 14, 26, 245.5),
(318, 'ppfcz3', 14, 27, 252.5),
(319, 'ppfcz3', 14, 28, 259.5),
(320, 'ppfcz3', 14, 29, 266.5),
(321, 'ppfcz3', 14, 30, 273.5),
(322, 'ppfcz4', 14, 2, 54.5),
(323, 'ppfcz4', 14, 3, 68.5),
(324, 'ppfcz4', 14, 4, 81.5),
(325, 'ppfcz4', 14, 5, 95.5),
(326, 'ppfcz4', 14, 6, 108.5),
(327, 'ppfcz4', 14, 7, 121.5),
(328, 'ppfcz4', 14, 8, 134.5),
(329, 'ppfcz4', 14, 9, 147.5),
(330, 'ppfcz4', 14, 10, 160.5),
(331, 'ppfcz4', 14, 11, 168.5),
(332, 'ppfcz4', 14, 12, 178.5),
(333, 'ppfcz4', 14, 13, 188.5),
(334, 'ppfcz4', 14, 14, 198.5),
(335, 'ppfcz4', 14, 15, 208.5),
(336, 'ppfcz4', 14, 16, 216.5),
(337, 'ppfcz4', 14, 17, 224.5),
(338, 'ppfcz4', 14, 18, 232.5),
(339, 'ppfcz4', 14, 19, 240.5),
(340, 'ppfcz4', 14, 20, 248.5),
(341, 'ppfcz4', 14, 21, 256.5),
(342, 'ppfcz4', 14, 22, 264.5),
(343, 'ppfcz4', 14, 23, 272.5),
(344, 'ppfcz4', 14, 24, 280.5),
(345, 'ppfcz4', 14, 25, 288.5),
(346, 'ppfcz4', 14, 26, 296.5),
(347, 'ppfcz4', 14, 27, 304.5),
(348, 'ppfcz4', 14, 28, 312.5),
(349, 'ppfcz4', 14, 29, 320.5),
(350, 'ppfcz4', 14, 30, 328.5),
(351, 'ppfcz5', 14, 2, 66.5),
(352, 'ppfcz5', 14, 3, 84.5),
(353, 'ppfcz5', 14, 4, 102.5),
(354, 'ppfcz5', 14, 5, 120.5),
(355, 'ppfcz5', 14, 6, 137.5),
(356, 'ppfcz5', 14, 7, 154.5),
(357, 'ppfcz5', 14, 8, 171.5),
(358, 'ppfcz5', 14, 9, 188.5),
(359, 'ppfcz5', 14, 10, 205.5),
(360, 'ppfcz5', 14, 11, 220.5),
(361, 'ppfcz5', 14, 12, 235.5),
(362, 'ppfcz5', 14, 13, 250.5),
(363, 'ppfcz5', 14, 14, 265.5),
(364, 'ppfcz5', 14, 15, 280.5),
(365, 'ppfcz5', 14, 16, 295.5),
(366, 'ppfcz5', 14, 17, 310.5),
(367, 'ppfcz5', 14, 18, 325.5),
(368, 'ppfcz5', 14, 19, 340.5),
(369, 'ppfcz5', 14, 20, 355.5),
(370, 'ppfcz5', 14, 21, 368.5),
(371, 'ppfcz5', 14, 22, 381.5),
(372, 'ppfcz5', 14, 23, 394.5),
(373, 'ppfcz5', 14, 24, 407.5),
(374, 'ppfcz5', 14, 25, 420.5),
(375, 'ppfcz5', 14, 26, 433.5),
(376, 'ppfcz5', 14, 27, 446.5),
(377, 'ppfcz5', 14, 28, 459.5),
(378, 'ppfcz5', 14, 29, 472.5),
(379, 'ppfcz5', 14, 30, 485.5),
(380, 'ppfcz1', 30, 0.5, 56.5),
(381, 'ppfcz1', 30, 1, 63.5),
(382, 'ppfcz1', 30, 1.5, 69.5),
(383, 'ppfcz1', 30, 2, 75.5),
(384, 'ppfcz1', 30, 2.5, 80.5),
(385, 'ppfcz1', 30, 3, 86.5),
(386, 'ppfcz1', 30, 3.5, 92.5),
(387, 'ppfcz1', 30, 4, 99.5),
(388, 'ppfcz1', 30, 4.5, 105.5),
(389, 'ppfcz1', 30, 5, 111.5),
(390, 'ppfcz1', 30, 6, 118.5),
(391, 'ppfcz1', 30, 7, 126.5),
(392, 'ppfcz1', 30, 8, 133.5),
(393, 'ppfcz1', 30, 9, 141.5),
(394, 'ppfcz1', 30, 10, 148.5),
(395, 'ppfcz1', 30, 11, 156.5),
(396, 'ppfcz1', 30, 12, 163.5),
(397, 'ppfcz1', 30, 13, 171.5),
(398, 'ppfcz1', 30, 14, 178.5),
(399, 'ppfcz1', 30, 15, 186.5),
(400, 'ppfcz1', 30, 16, 193.5),
(401, 'ppfcz1', 30, 17, 201.5),
(402, 'ppfcz1', 30, 18, 209.5),
(403, 'ppfcz1', 30, 19, 216.5),
(404, 'ppfcz1', 30, 20, 224.5),
(405, 'ppfcz1', 30, 21, 231.5),
(406, 'ppfcz1', 30, 22, 239.5),
(407, 'ppfcz1', 30, 23, 246.5),
(408, 'ppfcz1', 30, 24, 254.5),
(409, 'ppfcz1', 30, 25, 261.5),
(410, 'ppfcz1', 30, 26, 269.5),
(411, 'ppfcz1', 30, 27, 276.5),
(412, 'ppfcz1', 30, 28, 284.5),
(413, 'ppfcz1', 30, 29, 291.5),
(414, 'ppfcz1', 30, 30, 299.5),
(415, 'ppfcz2', 30, 0.5, 61.5),
(416, 'ppfcz2', 30, 1, 65.5),
(417, 'ppfcz2', 30, 1.5, 75.5),
(418, 'ppfcz2', 30, 2, 80.5),
(419, 'ppfcz2', 30, 2.5, 86.5),
(420, 'ppfcz2', 30, 3, 99.5),
(421, 'ppfcz2', 30, 3.5, 109.5),
(422, 'ppfcz2', 30, 4, 113.5),
(423, 'ppfcz2', 30, 4.5, 121.5),
(424, 'ppfcz2', 30, 5, 129.5),
(425, 'ppfcz2', 30, 6, 139.5),
(426, 'ppfcz2', 30, 7, 149.5),
(427, 'ppfcz2', 30, 8, 159.5),
(428, 'ppfcz2', 30, 9, 169.5),
(429, 'ppfcz2', 30, 10, 180.5),
(430, 'ppfcz2', 30, 11, 189.5),
(431, 'ppfcz2', 30, 12, 199.5),
(432, 'ppfcz2', 30, 13, 210.5),
(433, 'ppfcz2', 30, 14, 219.5),
(434, 'ppfcz2', 30, 15, 229.5),
(435, 'ppfcz2', 30, 16, 240.5),
(436, 'ppfcz2', 30, 17, 249.5),
(437, 'ppfcz2', 30, 18, 259.5),
(438, 'ppfcz2', 30, 19, 270.5),
(439, 'ppfcz2', 30, 20, 280.5),
(440, 'ppfcz2', 30, 21, 289.5),
(441, 'ppfcz2', 30, 22, 300.5),
(442, 'ppfcz2', 30, 23, 310.5),
(443, 'ppfcz2', 30, 24, 320.5),
(444, 'ppfcz2', 30, 25, 330.5),
(445, 'ppfcz2', 30, 26, 340.5),
(446, 'ppfcz2', 30, 27, 350.5),
(447, 'ppfcz2', 30, 28, 360.5),
(448, 'ppfcz2', 30, 29, 370.5),
(449, 'ppfcz2', 30, 30, 381.5),
(450, 'ppfcz3', 30, 0.5, 74.5),
(451, 'ppfcz3', 30, 1, 83.5),
(452, 'ppfcz3', 30, 1.5, 90.5),
(453, 'ppfcz3', 30, 2, 99.5),
(454, 'ppfcz3', 30, 2.5, 107.5),
(455, 'ppfcz3', 30, 3, 114.5),
(456, 'ppfcz3', 30, 3.5, 122.5),
(457, 'ppfcz3', 30, 4, 130.5),
(458, 'ppfcz3', 30, 4.5, 140.5),
(459, 'ppfcz3', 30, 5, 147.5),
(460, 'ppfcz3', 30, 6, 162.5),
(461, 'ppfcz3', 30, 7, 174.5),
(462, 'ppfcz3', 30, 8, 188.5),
(463, 'ppfcz3', 30, 9, 201.5),
(464, 'ppfcz3', 30, 10, 213.5),
(465, 'ppfcz3', 30, 11, 227.5),
(466, 'ppfcz3', 30, 12, 240.5),
(467, 'ppfcz3', 30, 13, 252.5),
(468, 'ppfcz3', 30, 14, 266.5),
(469, 'ppfcz3', 30, 15, 278.5),
(470, 'ppfcz3', 30, 16, 290.5),
(471, 'ppfcz3', 30, 17, 304.5),
(472, 'ppfcz3', 30, 18, 317.5),
(473, 'ppfcz3', 30, 19, 330.5),
(474, 'ppfcz3', 30, 20, 343.5),
(475, 'ppfcz3', 30, 21, 354.5),
(476, 'ppfcz3', 30, 22, 363.5),
(477, 'ppfcz3', 30, 23, 375.5),
(478, 'ppfcz3', 30, 24, 385.5),
(479, 'ppfcz3', 30, 25, 396.5),
(480, 'ppfcz3', 30, 26, 405.5),
(481, 'ppfcz3', 30, 27, 417.5),
(482, 'ppfcz3', 30, 28, 428.5),
(483, 'ppfcz3', 30, 29, 438.5),
(484, 'ppfcz3', 30, 30, 448.5),
(485, 'ppfcz4', 30, 0.5, 90.5),
(486, 'ppfcz4', 30, 1, 104.5),
(487, 'ppfcz4', 30, 1.5, 118.5),
(488, 'ppfcz4', 30, 2, 134.5),
(489, 'ppfcz4', 30, 2.5, 146.5),
(490, 'ppfcz4', 30, 3, 163.5),
(491, 'ppfcz4', 30, 3.5, 179.5),
(492, 'ppfcz4', 30, 4, 195.5),
(493, 'ppfcz4', 30, 4.5, 211.5),
(494, 'ppfcz4', 30, 5, 232.5),
(495, 'ppfcz4', 30, 6, 257.5),
(496, 'ppfcz4', 30, 7, 278.5),
(497, 'ppfcz4', 30, 8, 300.5),
(498, 'ppfcz4', 30, 9, 321.5),
(499, 'ppfcz4', 30, 10, 343.5),
(500, 'ppfcz4', 30, 11, 364.5),
(501, 'ppfcz4', 30, 12, 386.5),
(502, 'ppfcz4', 30, 13, 407.5),
(503, 'ppfcz4', 30, 14, 429.5),
(504, 'ppfcz4', 30, 15, 450.5),
(505, 'ppfcz4', 30, 16, 472.5),
(506, 'ppfcz4', 30, 17, 493.5),
(507, 'ppfcz4', 30, 18, 515.5),
(508, 'ppfcz4', 30, 19, 536.5),
(509, 'ppfcz4', 30, 20, 558.5),
(510, 'ppfcz4', 30, 21, 579.5),
(511, 'ppfcz4', 30, 22, 601.5),
(512, 'ppfcz4', 30, 23, 622.5),
(513, 'ppfcz4', 30, 24, 644.5),
(514, 'ppfcz4', 30, 25, 665.5),
(515, 'ppfcz4', 30, 26, 687.5),
(516, 'ppfcz4', 30, 27, 708.5),
(517, 'ppfcz4', 30, 28, 730.5),
(518, 'ppfcz4', 30, 29, 751.5),
(519, 'ppfcz4', 30, 30, 773.5),
(520, 'ppfcz5', 30, 0.5, 97.5),
(521, 'ppfcz5', 30, 1, 114.5),
(522, 'ppfcz5', 30, 1.5, 131.5),
(523, 'ppfcz5', 30, 2, 148.5),
(524, 'ppfcz5', 30, 2.5, 165.5),
(525, 'ppfcz5', 30, 3, 183.5),
(526, 'ppfcz5', 30, 3.5, 200.5),
(527, 'ppfcz5', 30, 4, 221.5),
(528, 'ppfcz5', 30, 4.5, 243.5),
(529, 'ppfcz5', 30, 5, 264.5),
(530, 'ppfcz5', 30, 6, 289.5),
(531, 'ppfcz5', 30, 7, 313.5),
(532, 'ppfcz5', 30, 8, 336.5),
(533, 'ppfcz5', 30, 9, 360.5),
(534, 'ppfcz5', 30, 10, 384.5),
(535, 'ppfcz5', 30, 11, 407.5),
(536, 'ppfcz5', 30, 12, 431.5),
(537, 'ppfcz5', 30, 13, 455.5),
(538, 'ppfcz5', 30, 14, 478.5),
(539, 'ppfcz5', 30, 15, 502.5),
(540, 'ppfcz5', 30, 16, 526.5),
(541, 'ppfcz5', 30, 17, 549.5),
(542, 'ppfcz5', 30, 18, 573.5),
(543, 'ppfcz5', 30, 19, 597.5),
(544, 'ppfcz5', 30, 20, 620.5),
(545, 'ppfcz5', 30, 21, 644.5),
(546, 'ppfcz5', 30, 22, 668.5),
(547, 'ppfcz5', 30, 23, 691.5),
(548, 'ppfcz5', 30, 24, 715.5),
(549, 'ppfcz5', 30, 25, 738.5),
(550, 'ppfcz5', 30, 26, 762.5),
(551, 'ppfcz5', 30, 27, 786.5),
(552, 'ppfcz5', 30, 28, 809.5),
(553, 'ppfcz5', 30, 29, 833.5),
(554, 'ppfcz5', 30, 30, 857.5),
(555, 'foreign', 13, 30, 0),
(556, 'all', 32, 10000, 23.2342007434944);