some sql statements to fill a parking lot database
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
DROP TABLE IF EXISTS `hersteller`;
CREATE TABLE IF NOT EXISTS `hersteller` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`bezei` varchar(64) COLLATE ascii_bin NOT NULL,
`sitz` text COLLATE ascii_bin NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=ascii COLLATE=ascii_bin AUTO_INCREMENT=10 ;
INSERT INTO `hersteller` (`id`, `bezei`, `sitz`) VALUES
(1, 'mercedes', 'stuttgart'),
(2, 'porsche', 'stuttgart'),
(3, 'vw', 'wolfsburg'),
(4, 'opel', 'grand gerau'),
(5, 'bmw', 'm?nchen'),
(6, 'audi', 'ingolfstadt'),
(7, 'maker07', 'town07'),
(8, 'maker08', 'town08'),
(9, 'maker09', 'town09');
DROP TABLE IF EXISTS `art`;
CREATE TABLE IF NOT EXISTS `art` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`art` text COLLATE ascii_bin NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=ascii COLLATE=ascii_bin AUTO_INCREMENT=1 ;
insert into art values
(1,'suv'),
(2,'offroader'),
(3,'supersportwagen'),
(4,'limosine'),
(5,'cabirio'),
(6,'kombi'),
(7,'roadster'),
(8,'frauenauto'),
(9,'oeko-kutsche');
DROP TABLE IF EXISTS `auto`;
CREATE TABLE IF NOT EXISTS `auto` (
`id` int(11) NOT NULL,
`modell` varchar(20) COLLATE ascii_bin NOT NULL,
`herstellerID` int(11) NOT NULL,
`artID` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=ascii COLLATE=ascii_bin;
INSERT INTO `auto` (`id`, `modell`, `herstellerID`, `artID`) VALUES
(5, 'model385', 5, 7),
(6, 'model825', 2, 5),
(7, 'model779', 8, 5),
(8, 'model523', 6, 5),
(9, 'model976', 9, 8),
(10, 'model692', 7, 5),
(11, 'model222', 2, 2),
(12, 'model661', 7, 3),
(13, 'model612', 4, 8),
(14, 'model449', 6, 2),
(15, 'model780', 8, 7),
(16, 'model591', 7, 8),
(17, 'model140', 5, 6),
(18, 'model551', 8, 3),
(19, 'model950', 8, 3),
(20, 'model793', 5, 9),
(21, 'model395', 7, 2),
(22, 'model549', 4, 8),
(23, 'model775', 8, 3),
(24, 'model697', 3, 8),
(25, 'model842', 1, 7),
(26, 'model566', 6, 4),
(27, 'model422', 6, 8),
(28, 'model131', 2, 7),
(29, 'model410', 2, 6),
(30, 'model654', 8, 3),
(31, 'model633', 2, 8),
(32, 'model763', 6, 3),
(33, 'model632', 4, 2),
(34, 'model874', 2, 4),
(35, 'model725', 8, 4),
(36, 'model470', 5, 9),
(37, 'model835', 7, 6),
(38, 'model703', 8, 7),
(39, 'model497', 2, 8),
(40, 'model193', 7, 6),
(41, 'model387', 4, 8),
(42, 'model301', 2, 5),
(43, 'model497', 7, 8),
(44, 'model590', 6, 1),
(45, 'model929', 3, 9),
(46, 'model398', 7, 4),
(47, 'model387', 5, 2),
(48, 'model937', 2, 1),
(49, 'model703', 6, 3),
(50, 'model535', 5, 7),
(51, 'model755', 1, 7),
(52, 'model988', 4, 8),
(53, 'model228', 8, 4),
(54, 'model144', 4, 6),
(55, 'model440', 7, 5),
(56, 'model978', 4, 8),
(57, 'model345', 6, 4),
(58, 'model556', 5, 2),
(59, 'model537', 9, 3),
(60, 'model744', 5, 8),
(61, 'model306', 4, 5),
(62, 'model479', 6, 6),
(63, 'model336', 9, 6),
(64, 'model830', 6, 5),
(65, 'model505', 6, 8),
(66, 'model267', 9, 6),
(67, 'model181', 8, 5),
(68, 'model457', 4, 8),
(69, 'model566', 4, 8),
(70, 'model803', 5, 4),
(71, 'model802', 5, 4),
(72, 'model854', 2, 3),
(73, 'model363', 5, 9),
(74, 'model965', 3, 6),
(75, 'model793', 4, 6),
(76, 'model527', 2, 5),
(77, 'model977', 7, 5),
(78, 'model497', 3, 8),
(79, 'model189', 7, 9),
(80, 'model251', 2, 2),
(81, 'model933', 7, 6),
(82, 'model845', 7, 7),
(83, 'model242', 5, 8),
(84, 'model163', 6, 1),
(85, 'model890', 2, 4),
(86, 'model583', 4, 5),
(87, 'model143', 2, 8),
(88, 'model237', 7, 7),
(89, 'model141', 8, 6),
(90, 'model581', 2, 2),
(91, 'model882', 3, 6),
(92, 'model348', 3, 2),
(93, 'model961', 6, 7),
(94, 'model220', 3, 3),
(95, 'model179', 8, 5),
(96, 'model468', 3, 6),
(97, 'model389', 3, 8),
(98, 'model262', 7, 1),
(99, 'model826', 7, 5),
(100, 'model856', 6, 7),
(101, 'model966', 3, 4),
(102, 'model630', 3, 9),
(103, 'model712', 6, 9),
(104, 'model330', 7, 3),
(105, 'model597', 5, 6),
(106, 'model507', 1, 6),
(107, 'model758', 8, 8),
(108, 'model576', 2, 2),
(109, 'model905', 3, 4),
(110, 'model849', 6, 7),
(111, 'model728', 4, 3),
(112, 'model840', 1, 2),
(113, 'model696', 3, 5),
(114, 'model871', 8, 3),
(115, 'model904', 7, 2),
(116, 'model588', 4, 8),
(117, 'model456', 3, 6),
(118, 'model949', 7, 9),
(119, 'model727', 3, 6),
(120, 'model498', 1, 3),
(121, 'model532', 8, 2),
(122, 'model611', 5, 3),
(123, 'model747', 3, 4),
(124, 'model495', 5, 8),
(125, 'model733', 7, 5),
(126, 'model827', 2, 9),
(127, 'model864', 8, 5),
(128, 'model123', 8, 3),
(129, 'model990', 9, 9),
(130, 'model691', 5, 1),
(131, 'model881', 5, 1),
(132, 'model957', 3, 4),
(133, 'model323', 7, 9),
(134, 'model595', 2, 9),
(135, 'model290', 2, 6),
(136, 'model821', 3, 6),
(137, 'model104', 2, 6),
(138, 'model949', 9, 5),
(139, 'model399', 4, 7),
(140, 'model910', 4, 1),
(141, 'model800', 5, 3),
(142, 'model129', 7, 9),
(143, 'model752', 5, 2),
(144, 'model498', 8, 7),
(145, 'model901', 6, 2),
(146, 'model658', 3, 3),
(147, 'model988', 3, 5),
(148, 'model359', 7, 8),
(149, 'model609', 1, 3),
(150, 'model717', 4, 2),
(151, 'model758', 7, 2),
(152, 'model143', 8, 4),
(153, 'model330', 8, 4),
(154, 'model507', 2, 5),
(155, 'model539', 5, 3),
(156, 'model963', 6, 7),
(157, 'model336', 3, 5),
(158, 'model404', 3, 7),
(159, 'model988', 5, 2),
(160, 'model327', 3, 5),
(161, 'model997', 8, 7),
(162, 'model870', 9, 2),
(163, 'model286', 5, 8),
(164, 'model322', 5, 7),
(165, 'model467', 2, 2),
(166, 'model477', 6, 5),
(167, 'model145', 7, 3),
(168, 'model472', 3, 7),
(169, 'model428', 6, 9),
(170, 'model444', 2, 9),
(171, 'model384', 6, 7),
(172, 'model230', 2, 3),
(173, 'model474', 8, 9),
(174, 'model137', 2, 8),
(175, 'model629', 9, 8),
(176, 'model378', 4, 2),
(177, 'model697', 4, 1),
(178, 'model619', 3, 5),
(179, 'model638', 3, 1),
(180, 'model308', 4, 3),
(181, 'model338', 6, 6),
(182, 'model398', 9, 2),
(183, 'model351', 4, 5),
(184, 'model568', 5, 9),
(185, 'model806', 2, 7),
(186, 'model791', 7, 7),
(187, 'model534', 2, 7),
(188, 'model144', 4, 3),
(189, 'model197', 2, 5),
(190, 'model523', 6, 8),
(191, 'model372', 6, 7),
(192, 'model196', 8, 2),
(193, 'model395', 5, 9),
(194, 'model560', 2, 6),
(195, 'model419', 5, 8),
(196, 'model764', 6, 2),
(197, 'model938', 7, 2),
(198, 'model465', 3, 2),
(199, 'model237', 8, 8),
(200, 'model368', 4, 1),
(201, 'model810', 4, 2),
(202, 'model522', 5, 5),
(203, 'model499', 5, 3),
(204, 'model286', 3, 2),
(205, 'model560', 6, 4),
(206, 'model130', 4, 2),
(207, 'model565', 6, 3),
(208, 'model259', 1, 4),
(209, 'model650', 6, 6),
(210, 'model205', 8, 3),
(211, 'model468', 4, 6),
(212, 'model889', 3, 3),
(213, 'model504', 8, 5),
(214, 'model720', 7, 3),
(215, 'model460', 7, 3),
(216, 'model313', 8, 2),
(217, 'model513', 5, 9),
(218, 'model894', 7, 9),
(219, 'model357', 3, 4),
(220, 'model612', 6, 4),
(221, 'model419', 4, 8),
(222, 'model630', 7, 2),
(223, 'model709', 5, 6),
(224, 'model716', 8, 8),
(225, 'model192', 8, 7),
(226, 'model130', 9, 5),
(227, 'model481', 5, 9),
(228, 'model132', 6, 8),
(229, 'model495', 3, 6),
(230, 'model620', 4, 7),
(231, 'model400', 9, 8),
(232, 'model307', 6, 7),
(233, 'model144', 8, 4),
(234, 'model800', 5, 2),
(235, 'model495', 7, 8),
(236, 'model605', 5, 7),
(237, 'model831', 8, 3),
(238, 'model961', 5, 2),
(239, 'model765', 5, 2),
(240, 'model484', 5, 8),
(241, 'model168', 3, 4),
(242, 'model235', 9, 7),
(243, 'model375', 6, 1),
(244, 'model573', 2, 8),
(245, 'model856', 7, 9),
(246, 'model736', 4, 3),
(247, 'model787', 9, 1),
(248, 'model371', 3, 9),
(249, 'model632', 2, 3),
(250, 'model146', 3, 5),
(251, 'model884', 8, 4),
(252, 'model952', 6, 1),
(253, 'model678', 9, 6),
(254, 'model595', 4, 9),
(255, 'model670', 5, 8),
(256, 'model771', 8, 4),
(257, 'model625', 4, 4),
(258, 'model153', 1, 7),
(259, 'model803', 5, 2),
(260, 'model122', 6, 9),
(261, 'model674', 4, 5),
(262, 'model205', 5, 1),
(263, 'model330', 3, 7),
(264, 'model719', 4, 8),
(265, 'model906', 9, 2),
(266, 'model726', 1, 5),
(267, 'model326', 8, 5),
(268, 'model740', 8, 4),
(269, 'model688', 5, 6),
(270, 'model992', 4, 6),
(271, 'model226', 3, 3),
(272, 'model757', 7, 1),
(273, 'model229', 4, 4),
(274, 'model502', 8, 3),
(275, 'model332', 8, 8),
(276, 'model986', 2, 4),
(277, 'model239', 4, 5),
(278, 'model121', 7, 9),
(279, 'model360', 4, 4),
(280, 'model772', 5, 7),
(281, 'model168', 9, 4),
(282, 'model246', 3, 7),
(283, 'model726', 2, 7),
(284, 'model747', 9, 1),
(285, 'model741', 7, 6),
(286, 'model398', 5, 6),
(287, 'model519', 8, 4),
(288, 'model368', 2, 2),
(289, 'model453', 6, 4),
(290, 'model324', 4, 5),
(291, 'model391', 7, 2),
(292, 'model129', 1, 8),
(293, 'model431', 8, 6),
(294, 'model623', 9, 7),
(295, 'model749', 4, 7),
(296, 'model339', 8, 7),
(297, 'model350', 9, 4),
(298, 'model975', 3, 4),
(299, 'model980', 6, 1),
(300, 'model940', 4, 9),
(301, 'model969', 6, 1),
(302, 'model208', 9, 3),
(303, 'model699', 2, 1),
(304, 'model200', 9, 5),
(305, 'model610', 8, 5),
(306, 'model932', 9, 9),
(307, 'model189', 2, 8),
(308, 'model751', 3, 9),
(309, 'model955', 7, 8),
(310, 'model449', 4, 3),
(311, 'model525', 7, 7),
(312, 'model125', 7, 3),
(313, 'model596', 7, 8),
(314, 'model253', 7, 5),
(315, 'model773', 7, 4),
(316, 'model339', 4, 6),
(317, 'model552', 4, 1),
(318, 'model294', 5, 6),
(319, 'model608', 5, 6),
(320, 'model906', 8, 4),
(321, 'model519', 8, 3),
(322, 'model900', 4, 7),
(323, 'model936', 8, 4),
(324, 'model851', 7, 7),
(325, 'model525', 3, 5),
(326, 'model686', 3, 2),
(327, 'model192', 6, 5),
(328, 'model776', 3, 8),
(329, 'model664', 5, 5),
(330, 'model174', 3, 5),
(331, 'model718', 7, 8),
(332, 'model635', 2, 5),
(333, 'model283', 3, 7),
(334, 'model419', 8, 8),
(335, 'model736', 1, 9),
(336, 'model794', 2, 3),
(337, 'model353', 8, 8),
(338, 'model826', 2, 8),
(339, 'model547', 3, 3),
(340, 'model310', 6, 7),
(341, 'model277', 5, 1),
(342, 'model973', 9, 9),
(343, 'model336', 4, 1),
(344, 'model774', 3, 8),
(345, 'model228', 7, 4),
(346, 'model110', 2, 4),
(347, 'model115', 6, 5),
(348, 'model681', 1, 5),
(349, 'model305', 6, 1),
(350, 'model624', 3, 2),
(351, 'model589', 9, 8),
(352, 'model726', 5, 3),
(353, 'model527', 5, 8),
(354, 'model526', 8, 2),
(355, 'model579', 4, 1),
(356, 'model953', 8, 4),
(357, 'model214', 2, 4),
(358, 'model672', 8, 5),
(359, 'model731', 2, 3),
(360, 'model779', 6, 8),
(361, 'model747', 3, 2),
(362, 'model451', 8, 2),
(363, 'model416', 6, 4),
(364, 'model931', 4, 8),
(365, 'model770', 7, 1),
(366, 'model155', 7, 4),
(367, 'model728', 5, 2),
(368, 'model126', 5, 8),
(369, 'model882', 7, 2),
(370, 'model277', 8, 4),
(371, 'model336', 2, 6),
(372, 'model161', 4, 2),
(373, 'model252', 7, 4),
(374, 'model573', 5, 6),
(375, 'model836', 6, 2),
(376, 'model380', 5, 7),
(377, 'model584', 6, 9),
(378, 'model852', 3, 6),
(379, 'model962', 6, 2),
(380, 'model790', 3, 9),
(381, 'model478', 5, 7),
(382, 'model553', 5, 1),
(383, 'model518', 8, 3),
(384, 'model906', 9, 6),
(385, 'model980', 4, 3),
(386, 'model998', 2, 3),
(387, 'model861', 8, 1),
(388, 'model197', 6, 5),
(389, 'model672', 2, 8),
(390, 'model594', 9, 4),
(391, 'model877', 3, 4),
(392, 'model421', 4, 8),
(393, 'model946', 8, 5),
(394, 'model295', 8, 6),
(395, 'model354', 7, 7),
(396, 'model718', 5, 6),
(397, 'model350', 6, 1),
(398, 'model983', 3, 8),
(399, 'model745', 2, 4),
(400, 'model234', 4, 2),
(401, 'model261', 2, 3),
(402, 'model982', 3, 9),
(403, 'model296', 6, 4),
(404, 'model414', 8, 5),
(405, 'model557', 7, 6),
(406, 'model134', 3, 5),
(407, 'model695', 4, 3),
(408, 'model143', 5, 5),
(409, 'model887', 5, 1),
(410, 'model660', 1, 5),
(411, 'model835', 7, 5),
(412, 'model367', 8, 7),
(413, 'model215', 6, 5),
(414, 'model355', 6, 7),
(415, 'model276', 8, 4),
(416, 'model197', 1, 7),
(417, 'model354', 7, 1),
(418, 'model139', 7, 5),
(419, 'model295', 6, 3),
(420, 'model927', 8, 8),
(421, 'model633', 7, 8),
(422, 'model173', 7, 5),
(423, 'model350', 2, 7),
(424, 'model581', 5, 4),
(425, 'model369', 6, 3),
(426, 'model605', 8, 5),
(427, 'model301', 2, 8),
(428, 'model621', 3, 3),
(429, 'model589', 3, 3),
(430, 'model947', 2, 4),
(431, 'model756', 6, 4),
(432, 'model752', 3, 5),
(433, 'model931', 4, 4),
(434, 'model952', 3, 7),
(435, 'model168', 2, 1),
(436, 'model490', 3, 8),
(437, 'model987', 5, 3),
(438, 'model764', 6, 3),
(439, 'model534', 6, 5),
(440, 'model876', 9, 3),
(441, 'model426', 6, 7),
(442, 'model371', 4, 9),
(443, 'model245', 8, 1),
(444, 'model541', 2, 3),
(445, 'model626', 9, 7),
(446, 'model422', 7, 5),
(447, 'model639', 3, 9),
(448, 'model882', 7, 7),
(449, 'model461', 6, 8),
(450, 'model835', 7, 2),
(451, 'model810', 6, 5),
(452, 'model996', 3, 7),
(453, 'model909', 6, 7),
(454, 'model162', 7, 3),
(455, 'model579', 8, 2),
(456, 'model280', 3, 8),
(457, 'model668', 7, 7),
(458, 'model781', 8, 2),
(459, 'model802', 4, 2),
(460, 'model259', 8, 1),
(461, 'model729', 2, 4),
(462, 'model560', 9, 5),
(463, 'model912', 3, 5),
(464, 'model662', 5, 7),
(465, 'model514', 3, 3),
(466, 'model980', 4, 5),
(467, 'model154', 7, 7),
(468, 'model503', 7, 4),
(469, 'model746', 8, 7),
(470, 'model589', 4, 2),
(471, 'model381', 7, 6),
(472, 'model174', 5, 6),
(473, 'model861', 8, 2),
(474, 'model527', 6, 7),
(475, 'model616', 7, 8),
(476, 'model489', 7, 8),
(477, 'model850', 5, 2),
(478, 'model257', 8, 7),
(479, 'model372', 6, 5),
(480, 'model313', 1, 2),
(481, 'model993', 6, 9),
(482, 'model185', 3, 2),
(483, 'model310', 3, 8),
(484, 'model904', 3, 6),
(485, 'model248', 1, 4),
(486, 'model790', 2, 9),
(487, 'model187', 5, 5),
(488, 'model817', 7, 2),
(489, 'model573', 2, 2),
(490, 'model890', 8, 6),
(491, 'model977', 6, 2),
(492, 'model304', 2, 5),
(493, 'model452', 8, 2),
(494, 'model891', 8, 6),
(495, 'model867', 7, 3),
(496, 'model867', 2, 4),
(497, 'model873', 3, 2),
(498, 'model922', 5, 9),
(499, 'model372', 8, 8),
(500, 'model621', 2, 8),
(501, 'model513', 8, 2),
(502, 'model653', 6, 5),
(503, 'model696', 6, 5),
(504, 'model376', 7, 3),
(505, 'model182', 3, 3),
(506, 'model314', 4, 3),
(507, 'model765', 5, 2),
(508, 'model933', 6, 4),
(509, 'model472', 3, 2),
(510, 'model140', 2, 6),
(511, 'model248', 6, 4),
(512, 'model467', 8, 1),
(513, 'model226', 3, 7),
(514, 'model459', 9, 3),
(515, 'model374', 2, 6),
(516, 'model374', 3, 2),
(517, 'model251', 2, 3),
(518, 'model462', 5, 3),
(519, 'model193', 1, 2),
(520, 'model725', 3, 4),
(521, 'model354', 4, 8),
(522, 'model172', 7, 3),
(523, 'model930', 4, 8),
(524, 'model706', 3, 1),
(525, 'model964', 5, 8),
(526, 'model799', 2, 2),
(527, 'model575', 4, 4),
(528, 'model838', 7, 8),
(529, 'model723', 6, 2),
(530, 'model848', 3, 3),
(531, 'model461', 8, 7),
(532, 'model238', 5, 3),
(533, 'model503', 8, 7),
(534, 'model159', 5, 3),
(535, 'model515', 3, 5),
(536, 'model586', 2, 8),
(537, 'model374', 8, 6),
(538, 'model283', 7, 6),
(539, 'model521', 8, 3),
(540, 'model747', 1, 6),
(541, 'model323', 8, 3),
(542, 'model670', 5, 6),
(543, 'model216', 8, 7),
(544, 'model450', 2, 9),
(545, 'model132', 5, 8),
(546, 'model491', 1, 4),
(547, 'model725', 5, 1),
(548, 'model284', 6, 2),
(549, 'model853', 5, 6),
(550, 'model820', 5, 3),
(551, 'model910', 8, 5),
(552, 'model209', 9, 4),
(553, 'model893', 3, 5),
(554, 'model842', 3, 4),
(555, 'model816', 3, 5),
(556, 'model858', 7, 3),
(557, 'model643', 4, 5),
(558, 'model393', 6, 8),
(559, 'model699', 5, 3),
(560, 'model368', 8, 6),
(561, 'model243', 9, 2),
(562, 'model162', 4, 9),
(563, 'model507', 5, 8),
(564, 'model647', 8, 7),
(565, 'model222', 8, 3),
(566, 'model924', 6, 5),
(567, 'model235', 9, 6),
(568, 'model497', 6, 8),
(569, 'model208', 4, 2),
(570, 'model658', 7, 8),
(571, 'model245', 7, 5),
(572, 'model433', 3, 4),
(573, 'model330', 4, 5),
(574, 'model363', 6, 3),
(575, 'model784', 5, 3),
(576, 'model362', 7, 5),
(577, 'model755', 6, 6),
(578, 'model511', 9, 4),
(579, 'model547', 4, 6),
(580, 'model610', 2, 2),
(581, 'model332', 5, 5),
(582, 'model459', 3, 2),
(583, 'model720', 2, 6),
(584, 'model227', 6, 1),
(585, 'model303', 5, 5),
(586, 'model538', 4, 1),
(587, 'model987', 4, 4),
(588, 'model847', 7, 1),
(589, 'model832', 2, 8),
(590, 'model687', 8, 5),
(591, 'model217', 7, 6),
(592, 'model976', 1, 8),
(593, 'model750', 2, 5),
(594, 'model625', 2, 6),
(595, 'model625', 8, 7),
(596, 'model873', 1, 7),
(597, 'model551', 8, 1),
(598, 'model761', 8, 4),
(599, 'model372', 6, 6),
(600, 'model660', 3, 2),
(601, 'model421', 6, 3),
(602, 'model518', 4, 2),
(603, 'model993', 6, 4),
(604, 'model651', 1, 7),
(605, 'model782', 9, 4),
(606, 'model779', 2, 7),
(607, 'model915', 7, 3),
(608, 'model538', 6, 8),
(609, 'model292', 1, 1),
(610, 'model464', 3, 8),
(611, 'model150', 7, 1),
(612, 'model525', 5, 6),
(613, 'model824', 5, 2),
(614, 'model771', 8, 6),
(615, 'model654', 2, 6),
(616, 'model129', 9, 6),
(617, 'model312', 3, 6),
(618, 'model642', 5, 8),
(619, 'model877', 7, 6),
(620, 'model146', 4, 5),
(621, 'model331', 4, 5),
(622, 'model994', 5, 4),
(623, 'model124', 4, 4),
(624, 'model983', 5, 9),
(625, 'model621', 6, 9),
(626, 'model650', 3, 2),
(627, 'model858', 5, 7),
(628, 'model174', 5, 9),
(629, 'model413', 2, 5),
(630, 'model232', 3, 3),
(631, 'model735', 8, 2),
(632, 'model735', 8, 7),
(633, 'model651', 6, 4),
(634, 'model730', 4, 5),
(635, 'model388', 8, 5),
(636, 'model435', 5, 7),
(637, 'model511', 5, 3),
(638, 'model305', 6, 7),
(639, 'model874', 2, 6),
(640, 'model704', 5, 3),
(641, 'model670', 8, 7),
(642, 'model925', 8, 6),
(643, 'model232', 9, 8),
(644, 'model497', 4, 7),
(645, 'model699', 7, 3),
(646, 'model786', 2, 5),
(647, 'model527', 4, 5),
(648, 'model912', 2, 8),
(649, 'model430', 6, 4),
(650, 'model406', 2, 2),
(651, 'model959', 4, 4),
(652, 'model663', 9, 8),
(653, 'model402', 6, 5),
(654, 'model984', 8, 7),
(655, 'model647', 5, 7),
(656, 'model925', 3, 4),
(657, 'model637', 2, 8),
(658, 'model507', 2, 5),
(659, 'model100', 7, 4),
(660, 'model951', 3, 4),
(661, 'model640', 3, 7),
(662, 'model736', 6, 5),
(663, 'model688', 2, 1),
(664, 'model292', 8, 3),
(665, 'model468', 1, 9),
(666, 'model977', 8, 6),
(667, 'model628', 4, 8),
(668, 'model881', 5, 2),
(669, 'model284', 6, 4),
(670, 'model504', 5, 5),
(671, 'model587', 2, 4),
(672, 'model856', 5, 2),
(673, 'model431', 4, 3),
(674, 'model720', 2, 3),
(675, 'model355', 8, 8),
(676, 'model132', 2, 5),
(677, 'model508', 3, 7),
(678, 'model783', 2, 4),
(679, 'model945', 3, 4),
(680, 'model839', 8, 2),
(681, 'model190', 3, 5),
(682, 'model906', 6, 8),
(683, 'model504', 8, 8),
(684, 'model494', 8, 8),
(685, 'model892', 5, 6),
(686, 'model153', 4, 6),
(687, 'model420', 2, 4),
(688, 'model531', 6, 5),
(689, 'model561', 4, 2),
(690, 'model422', 8, 7),
(691, 'model484', 8, 8),
(692, 'model203', 7, 8),
(693, 'model160', 6, 2),
(694, 'model174', 9, 9),
(695, 'model396', 6, 2),
(696, 'model529', 6, 2),
(697, 'model153', 8, 5),
(698, 'model925', 9, 1),
(699, 'model412', 2, 3),
(700, 'model339', 5, 8),
(701, 'model431', 5, 6),
(702, 'model900', 3, 7),
(703, 'model196', 8, 9),
(704, 'model764', 8, 8),
(705, 'model621', 3, 9),
(706, 'model452', 7, 8),
(707, 'model797', 2, 4),
(708, 'model131', 5, 7),
(709, 'model237', 8, 3),
(710, 'model744', 4, 7),
(711, 'model871', 3, 7),
(712, 'model328', 2, 6),
(713, 'model652', 1, 6),
(714, 'model377', 2, 7),
(715, 'model723', 1, 6),
(716, 'model547', 5, 3),
(717, 'model431', 5, 4),
(718, 'model145', 2, 8),
(719, 'model979', 2, 7),
(720, 'model893', 8, 5),
(721, 'model467', 1, 6),
(722, 'model465', 1, 7),
(723, 'model997', 6, 5),
(724, 'model528', 6, 7),
(725, 'model540', 9, 6),
(726, 'model395', 2, 5),
(727, 'model958', 3, 9),
(728, 'model594', 8, 2),
(729, 'model322', 2, 6),
(730, 'model372', 4, 3),
(731, 'model833', 4, 1),
(732, 'model655', 6, 2),
(733, 'model274', 6, 9),
(734, 'model931', 3, 1),
(735, 'model421', 5, 9),
(736, 'model797', 8, 9),
(737, 'model385', 1, 8),
(738, 'model220', 6, 4),
(739, 'model829', 4, 7),
(740, 'model523', 9, 2),
(741, 'model865', 9, 2),
(742, 'model702', 7, 5),
(743, 'model752', 2, 8),
(744, 'model519', 9, 7),
(745, 'model980', 8, 3),
(746, 'model476', 2, 4),
(747, 'model967', 5, 9),
(748, 'model412', 3, 6),
(749, 'model522', 3, 4),
(750, 'model948', 6, 7),
(751, 'model307', 3, 2),
(752, 'model890', 3, 9),
(753, 'model414', 6, 5),
(754, 'model306', 7, 6),
(755, 'model421', 8, 7),
(756, 'model855', 6, 2),
(757, 'model602', 9, 2),
(758, 'model381', 2, 7),
(759, 'model451', 5, 3),
(760, 'model825', 2, 7),
(761, 'model654', 5, 1),
(762, 'model286', 8, 4),
(763, 'model482', 7, 8),
(764, 'model830', 2, 9),
(765, 'model219', 2, 4),
(766, 'model804', 4, 8),
(767, 'model628', 2, 9),
(768, 'model505', 2, 3),
(769, 'model925', 9, 3),
(770, 'model459', 5, 6),
(771, 'model928', 2, 4),
(772, 'model792', 9, 4),
(773, 'model163', 2, 2),
(774, 'model682', 3, 3),
(775, 'model314', 8, 1),
(776, 'model145', 9, 4),
(777, 'model160', 4, 7),
(778, 'model283', 4, 1),
(779, 'model458', 3, 9),
(780, 'model583', 6, 1),
(781, 'model232', 1, 7),
(782, 'model666', 5, 2),
(783, 'model476', 8, 1),
(784, 'model547', 6, 3),
(785, 'model873', 3, 6),
(786, 'model797', 7, 8),
(787, 'model404', 3, 4),
(788, 'model476', 3, 7),
(789, 'model180', 8, 6),
(790, 'model756', 7, 7),
(791, 'model304', 4, 5),
(792, 'model736', 5, 6),
(793, 'model943', 6, 1),
(794, 'model687', 3, 5),
(795, 'model567', 6, 6),
(796, 'model164', 7, 4),
(797, 'model493', 5, 4),
(798, 'model198', 7, 6),
(799, 'model570', 8, 7),
(800, 'model420', 5, 6),
(801, 'model558', 2, 3),
(802, 'model500', 9, 2),
(803, 'model214', 5, 8),
(804, 'model622', 4, 4),
(805, 'model184', 2, 4),
(806, 'model428', 4, 9),
(807, 'model668', 4, 7),
(808, 'model246', 5, 2),
(809, 'model612', 8, 1),
(810, 'model127', 6, 7),
(811, 'model730', 1, 2),
(812, 'model745', 8, 7),
(813, 'model694', 2, 7),
(814, 'model208', 8, 2),
(815, 'model294', 6, 2),
(816, 'model569', 4, 5),
(817, 'model906', 7, 1),
(818, 'model599', 8, 5),
(819, 'model946', 6, 3),
(820, 'model987', 6, 6),
(821, 'model357', 6, 3),
(822, 'model252', 2, 7),
(823, 'model725', 2, 2),
(824, 'model302', 3, 3),
(825, 'model840', 3, 3),
(826, 'model294', 7, 7),
(827, 'model367', 9, 6),
(828, 'model335', 8, 6),
(829, 'model393', 5, 4),
(830, 'model838', 7, 4),
(831, 'model655', 4, 3),
(832, 'model852', 6, 6),
(833, 'model340', 7, 5),
(834, 'model770', 8, 2),
(835, 'model476', 9, 9),
(836, 'model425', 8, 9),
(837, 'model200', 3, 2),
(838, 'model146', 3, 7),
(839, 'model572', 4, 1),
(840, 'model713', 2, 2),
(841, 'model174', 8, 4),
(842, 'model304', 5, 2),
(843, 'model460', 1, 8),
(844, 'model769', 9, 3),
(845, 'model413', 4, 4),
(846, 'model655', 6, 1),
(847, 'model340', 4, 7),
(848, 'model321', 2, 4),
(849, 'model257', 5, 5),
(850, 'model288', 1, 9),
(851, 'model311', 7, 8),
(852, 'model515', 2, 7),
(853, 'model442', 2, 7),
(854, 'model937', 8, 2),
(855, 'model718', 4, 9),
(856, 'model283', 4, 1),
(857, 'model233', 6, 8),
(858, 'model986', 4, 6),
(859, 'model519', 3, 6),
(860, 'model527', 2, 3),
(861, 'model825', 2, 2),
(862, 'model176', 6, 8),
(863, 'model381', 7, 7),
(864, 'model167', 8, 6),
(865, 'model847', 5, 9),
(866, 'model758', 7, 7),
(867, 'model493', 7, 5),
(868, 'model949', 8, 1),
(869, 'model805', 9, 5),
(870, 'model967', 3, 6),
(871, 'model664', 9, 2),
(872, 'model880', 8, 8),
(873, 'model273', 6, 7),
(874, 'model126', 1, 2),
(875, 'model651', 8, 2),
(876, 'model587', 1, 2),
(877, 'model683', 6, 2),
(878, 'model892', 3, 8),
(879, 'model809', 2, 4),
(880, 'model840', 2, 6),
(881, 'model182', 3, 7),
(882, 'model122', 8, 4),
(883, 'model357', 3, 4),
(884, 'model525', 5, 6),
(885, 'model959', 7, 5),
(886, 'model976', 6, 4),
(887, 'model709', 8, 6),
(888, 'model195', 4, 4),
(889, 'model964', 9, 1),
(890, 'model230', 2, 3),
(891, 'model623', 5, 6),
(892, 'model791', 2, 2),
(893, 'model308', 7, 1),
(894, 'model905', 3, 4),
(895, 'model859', 1, 7),
(896, 'model157', 3, 9),
(897, 'model665', 1, 2),
(898, 'model354', 8, 3),
(899, 'model107', 2, 1),
(900, 'model472', 1, 6),
(901, 'model323', 1, 8),
(902, 'model672', 2, 2),
(903, 'model353', 8, 5),
(904, 'model497', 7, 6),
(905, 'model699', 2, 3),
(906, 'model905', 7, 6),
(907, 'model984', 7, 6),
(908, 'model384', 7, 4),
(909, 'model799', 9, 5),
(910, 'model795', 7, 2),
(911, 'model226', 8, 8),
(912, 'model882', 3, 4),
(913, 'model818', 6, 5),
(914, 'model484', 3, 3),
(915, 'model409', 7, 8),
(916, 'model780', 4, 8),
(917, 'model462', 8, 6),
(918, 'model120', 6, 5),
(919, 'model875', 7, 3),
(920, 'model428', 8, 6),
(921, 'model251', 7, 7),
(922, 'model500', 4, 8),
(923, 'model221', 1, 6),
(924, 'model460', 5, 7),
(925, 'model407', 6, 3),
(926, 'model981', 1, 4),
(927, 'model518', 8, 7),
(928, 'model973', 6, 4),
(929, 'model337', 8, 6),
(930, 'model526', 9, 7),
(931, 'model447', 6, 1),
(932, 'model561', 9, 5),
(933, 'model200', 2, 8),
(934, 'model701', 6, 6),
(935, 'model959', 6, 1),
(936, 'model801', 3, 2),
(937, 'model608', 4, 3),
(938, 'model945', 4, 6),
(939, 'model187', 9, 4),
(940, 'model408', 4, 7),
(941, 'model743', 2, 7),
(942, 'model314', 8, 4),
(943, 'model292', 6, 2),
(944, 'model563', 8, 3),
(945, 'model699', 2, 6),
(946, 'model602', 4, 1),
(947, 'model344', 3, 2),
(948, 'model164', 1, 2),
(949, 'model623', 9, 5),
(950, 'model221', 1, 5),
(951, 'model493', 8, 7),
(952, 'model776', 7, 3),
(953, 'model622', 4, 4),
(954, 'model615', 8, 4),
(955, 'model238', 3, 9),
(956, 'model930', 1, 6),
(957, 'model597', 8, 7),
(958, 'model657', 2, 6),
(959, 'model905', 7, 2),
(960, 'model836', 8, 4),
(961, 'model185', 2, 4),
(962, 'model354', 4, 2),
(963, 'model399', 7, 8),
(964, 'model286', 2, 3),
(965, 'model956', 9, 6),
(966, 'model360', 5, 8),
(967, 'model988', 4, 4),
(968, 'model565', 3, 9),
(969, 'model307', 8, 5),
(970, 'model176', 4, 7),
(971, 'model875', 6, 7),
(972, 'model950', 1, 3),
(973, 'model391', 3, 2),
(974, 'model169', 3, 8),
(975, 'model515', 8, 5),
(976, 'model992', 4, 7),
(977, 'model672', 6, 8),
(978, 'model760', 2, 6),
(979, 'model157', 4, 8),
(980, 'model298', 5, 4),
(981, 'model883', 2, 2),
(982, 'model551', 3, 6),
(983, 'model975', 3, 6),
(984, 'model507', 5, 5),
(985, 'model168', 2, 1),
(986, 'model215', 5, 6),
(987, 'model439', 6, 2),
(988, 'model666', 2, 7),
(989, 'model772', 6, 3),
(990, 'model347', 3, 3),
(991, 'model504', 8, 2),
(992, 'model858', 6, 6),
(993, 'model602', 6, 4),
(994, 'model804', 7, 9),
(995, 'model146', 7, 8),
(996, 'model559', 6, 1),
(997, 'model165', 3, 8),
(998, 'model135', 2, 3),
(999, 'model127', 8, 9),
(1000, 'model373', 1, 4),
(1001, 'model212', 5, 1),
(1002, 'model902', 5, 6),
(1003, 'model325', 1, 6),
(1004, 'model505', 8, 2),
(1005, 'model972', 7, 5),
(1006, 'model741', 8, 2),
(1007, 'model498', 3, 8),
(1008, 'model647', 4, 4),
(1009, 'model504', 9, 7),
(1010, 'model557', 6, 7),
(1011, 'model845', 9, 7),
(1012, 'model388', 2, 9),
(1013, 'model110', 9, 4),
(1014, 'model822', 2, 4),
(1015, 'model797', 7, 5),
(1016, 'model179', 2, 4),
(1017, 'model938', 6, 8),
(1018, 'model238', 3, 6),
(1019, 'model746', 3, 3),
(1020, 'model712', 3, 2),
(1021, 'model486', 6, 8),
(1022, 'model252', 2, 4),
(1023, 'model571', 8, 7),
(1024, 'model988', 3, 2),
(1025, 'model957', 8, 4),
(1026, 'model618', 6, 6),
(1027, 'model550', 8, 2),
(1028, 'model124', 2, 2),
(1029, 'model654', 8, 8),
(1030, 'model577', 7, 2),
(1031, 'model398', 2, 5),
(1032, 'model768', 4, 8),
(1033, 'model482', 4, 7),
(1034, 'model624', 3, 2),
(1035, 'model274', 3, 2),
(1036, 'model456', 2, 3),
(1037, 'model368', 2, 3),
(1038, 'model674', 5, 8),
(1039, 'model104', 6, 6),
(1040, 'model772', 2, 1),
(1041, 'model232', 2, 6),
(1042, 'model851', 5, 3),
(1043, 'model163', 3, 9),
(1044, 'model243', 2, 1),
(1045, 'model675', 7, 6),
(1046, 'model860', 8, 4),
(1047, 'model323', 3, 4),
(1048, 'model615', 4, 6),
(1049, 'model100', 3, 9),
(1050, 'model970', 5, 6),
(1051, 'model328', 6, 7),
(1052, 'model487', 8, 8),
(1053, 'model225', 6, 9),
(1054, 'model801', 5, 6),
(1055, 'model477', 2, 9),
(1056, 'model183', 5, 4),
(1057, 'model421', 2, 3),
(1058, 'model928', 9, 2),
(1059, 'model208', 6, 5),
(1060, 'model976', 1, 2),
(1061, 'model507', 7, 2),
(1062, 'model507', 7, 9),
(1063, 'model746', 4, 2),
(1064, 'model890', 2, 8),
(1065, 'model134', 8, 1),
(1066, 'model921', 6, 2),
(1067, 'model348', 3, 2),
(1068, 'model402', 1, 3),
(1069, 'model597', 2, 2),
(1070, 'model353', 8, 7),
(1071, 'model176', 2, 3),
(1072, 'model730', 3, 7),
(1073, 'model206', 4, 1),
(1074, 'model240', 4, 2),
(1075, 'model874', 4, 7),
(1076, 'model782', 2, 7),
(1077, 'model102', 3, 6),
(1078, 'model199', 6, 3),
(1079, 'model398', 4, 3),
(1080, 'model103', 5, 6),
(1081, 'model172', 1, 8),
(1082, 'model628', 1, 1),
(1083, 'model491', 3, 4),
(1084, 'model297', 6, 7),
(1085, 'model430', 5, 6),
(1086, 'model869', 4, 4),
(1087, 'model382', 2, 2),
(1088, 'model752', 6, 8),
(1089, 'model799', 4, 5),
(1090, 'model491', 7, 6),
(1091, 'model730', 7, 9),
(1092, 'model308', 2, 6),
(1093, 'model900', 4, 5),
(1094, 'model478', 2, 2),
(1095, 'model200', 3, 5),
(1096, 'model934', 4, 5),
(1097, 'model401', 7, 3),
(1098, 'model449', 6, 7),
(1099, 'model339', 4, 7),
(1100, 'model899', 7, 3),
(1101, 'model703', 4, 5),
(1102, 'model416', 4, 1),
(1103, 'model631', 1, 1),
(1104, 'model810', 7, 5),
(1105, 'model557', 7, 3),
(1106, 'model507', 4, 7),
(1107, 'model593', 8, 3),
(1108, 'model560', 9, 7),
(1109, 'model607', 8, 9),
(1110, 'model893', 3, 5),
(1111, 'model564', 5, 4),
(1112, 'model680', 9, 7),
(1113, 'model523', 4, 5),
(1114, 'model955', 7, 7),
(1115, 'model878', 6, 6),
(1116, 'model854', 8, 2),
(1117, 'model827', 2, 2),
(1118, 'model262', 7, 7),
(1119, 'model608', 5, 8),
(1120, 'model628', 5, 6),
(1121, 'model655', 4, 3),
(1122, 'model340', 3, 8),
(1123, 'model837', 6, 3),
(1124, 'model557', 8, 7),
(1125, 'model719', 3, 9),
(1126, 'model938', 9, 7),
(1127, 'model493', 2, 4),
(1128, 'model122', 1, 3),
(1129, 'model389', 5, 5),
(1130, 'model733', 5, 2),
(1131, 'model922', 7, 5),
(1132, 'model993', 9, 9),
(1133, 'model151', 8, 2),
(1134, 'model555', 7, 5),
(1135, 'model804', 7, 5),
(1136, 'model609', 6, 4),
(1137, 'model962', 2, 4),
(1138, 'model400', 6, 6),
(1139, 'model170', 6, 2),
(1140, 'model571', 1, 4),
(1141, 'model295', 8, 2),
(1142, 'model635', 2, 5),
(1143, 'model253', 9, 2),
(1144, 'model718', 3, 6),
(1145, 'model593', 8, 3),
(1146, 'model134', 6, 7),
(1147, 'model574', 1, 6),
(1148, 'model421', 1, 4),
(1149, 'model297', 3, 4),
(1150, 'model184', 5, 6),
(1151, 'model950', 6, 1),
(1152, 'model853', 7, 7),
(1153, 'model426', 7, 5),
(1154, 'model789', 3, 3),
(1155, 'model412', 5, 5),
(1156, 'model147', 1, 5),
(1157, 'model729', 3, 1),
(1158, 'model806', 7, 8),
(1159, 'model170', 2, 6),
(1160, 'model120', 7, 5),
(1161, 'model541', 3, 8),
(1162, 'model993', 8, 2),
(1163, 'model114', 6, 5),
(1164, 'model593', 2, 1),
(1165, 'model550', 6, 6),
(1166, 'model819', 4, 8),
(1167, 'model204', 7, 4),
(1168, 'model514', 7, 9),
(1169, 'model221', 9, 5),
(1170, 'model275', 4, 5),
(1171, 'model986', 8, 3),
(1172, 'model417', 8, 6),
(1173, 'model811', 5, 1),
(1174, 'model242', 8, 4),
(1175, 'model137', 2, 3),
(1176, 'model406', 4, 4),
(1177, 'model277', 4, 2),
(1178, 'model612', 2, 8),
(1179, 'model728', 4, 7),
(1180, 'model475', 7, 6),
(1181, 'model697', 7, 5),
(1182, 'model680', 9, 7),
(1183, 'model330', 4, 3),
(1184, 'model125', 5, 9),
(1185, 'model470', 3, 1),
(1186, 'model643', 9, 7),
(1187, 'model172', 5, 4),
(1188, 'model201', 4, 1),
(1189, 'model451', 7, 6),
(1190, 'model243', 6, 1),
(1191, 'model221', 2, 5),
(1192, 'model893', 8, 5),
(1193, 'model239', 4, 2),
(1194, 'model237', 7, 1),
(1195, 'model488', 1, 6),
(1196, 'model689', 2, 8),
(1197, 'model957', 2, 8),
(1198, 'model592', 7, 9),
(1199, 'model205', 8, 7),
(1200, 'model180', 2, 5),
(1201, 'model768', 3, 5),
(1202, 'model193', 7, 2),
(1203, 'model498', 1, 2),
(1204, 'model581', 6, 6),
(1205, 'model336', 5, 5),
(1206, 'model535', 2, 4),
(1207, 'model888', 1, 8),
(1208, 'model514', 9, 6),
(1209, 'model149', 3, 4),
(1210, 'model618', 5, 7),
(1211, 'model890', 6, 3),
(1212, 'model747', 9, 8),
(1213, 'model300', 4, 5),
(1214, 'model222', 2, 5),
(1215, 'model773', 4, 7),
(1216, 'model671', 6, 5),
(1217, 'model767', 2, 3),
(1218, 'model846', 8, 3),
(1219, 'model773', 2, 6),
(1220, 'model220', 7, 8),
(1221, 'model991', 5, 3),
(1222, 'model895', 3, 2),
(1223, 'model115', 7, 4),
(1224, 'model231', 9, 5),
(1225, 'model134', 1, 2),
(1226, 'model504', 7, 9),
(1227, 'model821', 1, 3),
(1228, 'model991', 2, 1),
(1229, 'model997', 6, 9),
(1230, 'model927', 8, 2),
(1231, 'model173', 4, 5),
(1232, 'model768', 7, 5),
(1233, 'model122', 6, 3),
(1234, 'model572', 4, 6),
(1235, 'model351', 5, 1),
(1236, 'model360', 2, 7),
(1237, 'model109', 5, 2),
(1238, 'model241', 5, 9),
(1239, 'model775', 2, 4),
(1240, 'model159', 7, 4),
(1241, 'model760', 9, 7),
(1242, 'model667', 7, 6),
(1243, 'model807', 7, 3),
(1244, 'model961', 4, 3),
(1245, 'model790', 8, 3),
(1246, 'model582', 2, 1),
(1247, 'model634', 1, 7),
(1248, 'model559', 9, 5),
(1249, 'model430', 1, 3),
(1250, 'model408', 2, 4),
(1251, 'model679', 7, 4),
(1252, 'model423', 5, 6),
(1253, 'model305', 4, 5),
(1254, 'model695', 5, 7),
(1255, 'model555', 5, 1),
(1256, 'model340', 4, 6),
(1257, 'model201', 3, 7),
(1258, 'model378', 5, 4),
(1259, 'model333', 5, 6),
(1260, 'model200', 7, 7),
(1261, 'model307', 4, 5),
(1262, 'model407', 8, 2),
(1263, 'model869', 6, 2),
(1264, 'model330', 1, 6),
(1265, 'model880', 3, 8),
(1266, 'model222', 1, 3),
(1267, 'model591', 2, 4),
(1268, 'model890', 6, 8),
(1269, 'model364', 5, 2),
(1270, 'model368', 3, 7),
(1271, 'model950', 4, 4),
(1272, 'model126', 5, 8),
(1273, 'model935', 1, 5),
(1274, 'model760', 2, 6),
(1275, 'model988', 8, 2),
(1276, 'model728', 8, 6),
(1277, 'model343', 3, 6),
(1278, 'model623', 8, 8),
(1279, 'model288', 8, 2),
(1280, 'model674', 3, 8),
(1281, 'model933', 1, 2),
(1282, 'model869', 6, 5),
(1283, 'model998', 7, 5),
(1284, 'model240', 4, 6),
(1285, 'model566', 2, 4),
(1286, 'model555', 3, 5),
(1287, 'model481', 7, 2),
(1288, 'model668', 4, 2),
(1289, 'model833', 7, 8),
(1290, 'model715', 3, 8),
(1291, 'model769', 2, 7),
(1292, 'model142', 3, 4),
(1293, 'model124', 2, 9),
(1294, 'model639', 7, 8),
(1295, 'model374', 3, 9),
(1296, 'model905', 4, 8),
(1297, 'model762', 7, 2),
(1298, 'model866', 5, 4),
(1299, 'model798', 1, 7),
(1300, 'model128', 3, 3),
(1301, 'model235', 7, 3),
(1302, 'model750', 4, 2),
(1303, 'model155', 7, 2),
(1304, 'model173', 7, 6),
(1305, 'model512', 5, 6),
(1306, 'model145', 6, 3),
(1307, 'model801', 7, 3),
(1308, 'model756', 7, 3),
(1309, 'model669', 5, 1),
(1310, 'model991', 6, 5),
(1311, 'model433', 9, 2),
(1312, 'model604', 5, 2),
(1313, 'model861', 3, 1),
(1314, 'model432', 7, 6),
(1315, 'model745', 7, 7),
(1316, 'model429', 4, 4),
(1317, 'model888', 1, 2),
(1318, 'model227', 5, 9),
(1319, 'model998', 6, 5),
(1320, 'model723', 8, 9),
(1321, 'model843', 8, 7),
(1322, 'model769', 7, 3),
(1323, 'model766', 1, 3),
(1324, 'model868', 9, 7),
(1325, 'model410', 5, 2),
(1326, 'model142', 3, 3),
(1327, 'model776', 3, 6),
(1328, 'model174', 3, 3),
(1329, 'model909', 7, 6),
(1330, 'model575', 4, 4),
(1331, 'model203', 5, 6),
(1332, 'model146', 5, 8),
(1333, 'model328', 7, 4),
(1334, 'model259', 3, 7),
(1335, 'model219', 3, 5),
(1336, 'model740', 3, 2),
(1337, 'model305', 7, 9),
(1338, 'model922', 1, 8),
(1339, 'model499', 1, 4),
(1340, 'model875', 3, 1),
(1341, 'model914', 6, 3),
(1342, 'model832', 9, 5),
(1343, 'model481', 6, 2),
(1344, 'model777', 8, 3),
(1345, 'model266', 7, 2),
(1346, 'model227', 5, 9),
(1347, 'model208', 3, 6),
(1348, 'model156', 7, 3),
(1349, 'model356', 1, 8),
(1350, 'model208', 8, 2),
(1351, 'model781', 6, 3),
(1352, 'model201', 8, 6),
(1353, 'model878', 7, 4),
(1354, 'model549', 6, 5),
(1355, 'model970', 8, 4),
(1356, 'model290', 3, 5),
(1357, 'model592', 8, 8),
(1358, 'model748', 2, 1),
(1359, 'model365', 5, 7),
(1360, 'model502', 6, 5),
(1361, 'model325', 5, 4),
(1362, 'model469', 8, 4),
(1363, 'model549', 2, 4),
(1364, 'model554', 3, 7),
(1365, 'model629', 2, 2),
(1366, 'model670', 5, 8),
(1367, 'model296', 5, 8),
(1368, 'model835', 8, 2),
(1369, 'model593', 5, 7),
(1370, 'model696', 5, 2),
(1371, 'model711', 2, 2),
(1372, 'model510', 2, 1),
(1373, 'model530', 5, 6),
(1374, 'model194', 8, 3),
(1375, 'model289', 9, 4),
(1376, 'model697', 3, 7),
(1377, 'model322', 4, 3),
(1378, 'model398', 2, 9),
(1379, 'model754', 1, 1),
(1380, 'model579', 4, 2),
(1381, 'model508', 2, 2),
(1382, 'model537', 6, 3),
(1383, 'model680', 3, 7),
(1384, 'model388', 8, 5),
(1385, 'model987', 3, 8),
(1386, 'model652', 1, 3),
(1387, 'model579', 1, 9),
(1388, 'model581', 2, 7),
(1389, 'model402', 2, 3),
(1390, 'model845', 5, 7),
(1391, 'model985', 8, 3),
(1392, 'model628', 6, 6),
(1393, 'model317', 4, 2),
(1394, 'model536', 1, 6),
(1395, 'model184', 8, 4),
(1396, 'model847', 5, 4),
(1397, 'model207', 5, 5),
(1398, 'model381', 4, 3),
(1399, 'model684', 5, 4),
(1400, 'model702', 8, 3),
(1401, 'model977', 8, 4),
(1402, 'model397', 6, 5),
(1403, 'model213', 9, 3),
(1404, 'model509', 5, 2),
(1405, 'model492', 5, 7),
(1406, 'model403', 8, 6),
(1407, 'model208', 7, 8),
(1408, 'model715', 8, 1),
(1409, 'model703', 2, 6),
(1410, 'model863', 7, 8),
(1411, 'model296', 2, 2),
(1412, 'model212', 3, 7),
(1413, 'model403', 4, 3),
(1414, 'model877', 4, 8),
(1415, 'model501', 1, 2),
(1416, 'model392', 7, 2),
(1417, 'model532', 5, 2),
(1418, 'model981', 2, 2),
(1419, 'model874', 8, 8),
(1420, 'model834', 6, 4),
(1421, 'model829', 5, 9),
(1422, 'model860', 7, 2),
(1423, 'model464', 3, 9),
(1424, 'model148', 9, 2),
(1425, 'model398', 7, 7),
(1426, 'model549', 2, 4),
(1427, 'model896', 5, 5),
(1428, 'model507', 3, 3),
(1429, 'model830', 5, 5),
(1430, 'model582', 9, 8),
(1431, 'model210', 2, 5),
(1432, 'model810', 4, 9),
(1433, 'model880', 6, 4),
(1434, 'model325', 2, 8),
(1435, 'model320', 8, 1),
(1436, 'model374', 2, 2),
(1437, 'model629', 1, 5),
(1438, 'model429', 6, 8),
(1439, 'model990', 8, 2),
(1440, 'model334', 2, 1),
(1441, 'model295', 5, 8),
(1442, 'model289', 2, 3),
(1443, 'model447', 4, 7),
(1444, 'model598', 8, 2),
(1445, 'model168', 5, 3),
(1446, 'model850', 4, 8),
(1447, 'model891', 6, 3),
(1448, 'model600', 9, 4),
(1449, 'model833', 5, 2),
(1450, 'model767', 5, 1),
(1451, 'model437', 6, 7),
(1452, 'model664', 1, 1),
(1453, 'model629', 2, 2),
(1454, 'model802', 7, 7),
(1455, 'model712', 9, 2),
(1456, 'model929', 8, 8),
(1457, 'model352', 8, 1),
(1458, 'model610', 5, 6),
(1459, 'model437', 2, 2),
(1460, 'model185', 4, 6),
(1461, 'model194', 4, 5),
(1462, 'model549', 3, 6),
(1463, 'model895', 7, 5),
(1464, 'model974', 1, 8),
(1465, 'model774', 4, 5),
(1466, 'model218', 6, 5),
(1467, 'model350', 2, 9),
(1468, 'model406', 4, 8),
(1469, 'model548', 4, 5),
(1470, 'model343', 1, 2),
(1471, 'model640', 5, 9),
(1472, 'model744', 7, 3),
(1473, 'model532', 2, 5),
(1474, 'model989', 8, 7),
(1475, 'model345', 6, 4),
(1476, 'model601', 6, 6),
(1477, 'model840', 4, 6),
(1478, 'model238', 3, 5),
(1479, 'model204', 6, 2),
(1480, 'model675', 7, 7),
(1481, 'model906', 6, 6),
(1482, 'model541', 2, 8),
(1483, 'model341', 8, 7),
(1484, 'model537', 8, 6),
(1485, 'model345', 9, 5),
(1486, 'model954', 7, 9),
(1487, 'model467', 7, 5),
(1488, 'model599', 8, 6),
(1489, 'model566', 3, 6),
(1490, 'model806', 8, 5),
(1491, 'model684', 3, 3),
(1492, 'model661', 6, 2),
(1493, 'model356', 2, 2),
(1494, 'model582', 2, 7),
(1495, 'model637', 7, 8),
(1496, 'model133', 5, 6),
(1497, 'model701', 7, 3),
(1498, 'model889', 8, 8),
(1499, 'model439', 8, 6),
(1500, 'model251', 2, 7),
(1501, 'model234', 8, 2),
(1502, 'model981', 5, 5),
(1503, 'model896', 8, 1),
(1504, 'model667', 2, 5),
(1505, 'model971', 4, 3),
(1506, 'model243', 5, 4),
(1507, 'model270', 7, 3),
(1508, 'model813', 7, 8),
(1509, 'model381', 7, 9),
(1510, 'model375', 4, 3),
(1511, 'model490', 5, 7),
(1512, 'model289', 4, 5),
(1513, 'model818', 5, 2),
(1514, 'model732', 3, 5),
(1515, 'model727', 3, 2),
(1516, 'model165', 5, 6),
(1517, 'model688', 2, 5),
(1518, 'model197', 9, 6),
(1519, 'model665', 4, 3),
(1520, 'model256', 4, 1),
(1521, 'model903', 8, 3),
(1522, 'model351', 7, 4),
(1523, 'model817', 1, 2),
(1524, 'model262', 9, 4),
(1525, 'model834', 7, 2),
(1526, 'model457', 7, 1),
(1527, 'model295', 5, 1),
(1528, 'model536', 6, 4),
(1529, 'model347', 6, 8),
(1530, 'model636', 4, 6),
(1531, 'model688', 6, 2),
(1532, 'model482', 5, 9),
(1533, 'model618', 8, 2),
(1534, 'model586', 5, 3),
(1535, 'model151', 6, 5),
(1536, 'model591', 3, 4),
(1537, 'model730', 1, 6),
(1538, 'model322', 4, 7),
(1539, 'model406', 8, 4),
(1540, 'model113', 7, 5),
(1541, 'model598', 7, 9),
(1542, 'model797', 4, 1),
(1543, 'model304', 2, 2),
(1544, 'model418', 3, 2),
(1545, 'model531', 7, 5),
(1546, 'model932', 3, 3),
(1547, 'model484', 7, 7),
(1548, 'model221', 7, 9),
(1549, 'model130', 3, 8),
(1550, 'model151', 3, 8),
(1551, 'model377', 2, 1),
(1552, 'model935', 1, 2),
(1553, 'model403', 9, 4),
(1554, 'model197', 2, 2),
(1555, 'model198', 1, 5),
(1556, 'model239', 7, 5),
(1557, 'model554', 8, 2),
(1558, 'model395', 5, 5),
(1559, 'model676', 4, 8),
(1560, 'model802', 5, 1),
(1561, 'model931', 8, 2),
(1562, 'model366', 9, 2),
(1563, 'model286', 1, 1),
(1564, 'model551', 7, 3),
(1565, 'model853', 5, 4),
(1566, 'model338', 6, 5),
(1567, 'model144', 8, 7),
(1568, 'model585', 5, 9),
(1569, 'model561', 9, 3),
(1570, 'model452', 8, 2),
(1571, 'model600', 3, 5),
(1572, 'model161', 6, 3),
(1573, 'model251', 3, 2),
(1574, 'model804', 4, 6),
(1575, 'model480', 8, 4),
(1576, 'model683', 9, 6),
(1577, 'model738', 6, 8),
(1578, 'model865', 7, 1),
(1579, 'model804', 7, 6),
(1580, 'model769', 8, 7),
(1581, 'model917', 8, 9),
(1582, 'model184', 8, 6),
(1583, 'model706', 8, 8),
(1584, 'model321', 8, 4),
(1585, 'model281', 1, 7),
(1586, 'model805', 8, 4),
(1587, 'model461', 6, 8),
(1588, 'model737', 8, 8),
(1589, 'model201', 4, 8),
(1590, 'model139', 8, 7),
(1591, 'model541', 4, 8),
(1592, 'model134', 3, 1),
(1593, 'model406', 8, 8),
(1594, 'model728', 4, 8),
(1595, 'model587', 1, 4),
(1596, 'model261', 4, 2),
(1597, 'model966', 9, 4),
(1598, 'model632', 8, 1),
(1599, 'model747', 8, 2),
(1600, 'model529', 8, 7),
(1601, 'model984', 7, 2),
(1602, 'model349', 2, 6),
(1603, 'model591', 6, 8),
(1604, 'model237', 9, 3),
(1605, 'model155', 5, 3),
(1606, 'model972', 5, 3),
(1607, 'model821', 8, 8),
(1608, 'model794', 1, 1),
(1609, 'model839', 3, 3),
(1610, 'model627', 6, 5),
(1611, 'model565', 8, 7),
(1612, 'model757', 2, 3),
(1613, 'model712', 5, 2),
(1614, 'model273', 7, 5),
(1615, 'model980', 9, 6),
(1616, 'model894', 5, 8),
(1617, 'model979', 6, 8),
(1618, 'model443', 6, 4),
(1619, 'model633', 4, 7),
(1620, 'model182', 2, 7),
(1621, 'model482', 5, 2),
(1622, 'model176', 7, 6),
(1623, 'model217', 4, 7),
(1624, 'model789', 4, 1),
(1625, 'model804', 2, 5),
(1626, 'model705', 4, 2),
(1627, 'model951', 7, 3),
(1628, 'model773', 2, 8),
(1629, 'model339', 3, 2),
(1630, 'model701', 6, 4),
(1631, 'model304', 9, 6),
(1632, 'model325', 1, 3),
(1633, 'model951', 7, 9),
(1634, 'model796', 6, 5),
(1635, 'model463', 1, 5),
(1636, 'model108', 2, 3),
(1637, 'model770', 2, 7),
(1638, 'model286', 9, 4),
(1639, 'model803', 3, 3),
(1640, 'model611', 4, 2),
(1641, 'model815', 6, 9),
(1642, 'model370', 2, 9),
(1643, 'model371', 5, 4),
(1644, 'model528', 2, 2),
(1645, 'model544', 8, 5),
(1646, 'model352', 5, 9),
(1647, 'model425', 7, 9),
(1648, 'model524', 6, 4),
(1649, 'model696', 1, 4),
(1650, 'model958', 2, 6),
(1651, 'model607', 6, 2),
(1652, 'model180', 5, 6),
(1653, 'model136', 8, 3),
(1654, 'model725', 1, 8),
(1655, 'model870', 8, 6),
(1656, 'model841', 9, 7),
(1657, 'model432', 4, 1),
(1658, 'model824', 6, 8),
(1659, 'model616', 1, 6),
(1660, 'model672', 7, 3),
(1661, 'model526', 3, 3),
(1662, 'model821', 1, 3),
(1663, 'model899', 7, 5),
(1664, 'model479', 9, 2),
(1665, 'model619', 6, 7),
(1666, 'model364', 8, 1),
(1667, 'model489', 2, 4),
(1668, 'model391', 8, 5),
(1669, 'model551', 7, 5),
(1670, 'model294', 4, 6),
(1671, 'model903', 2, 6),
(1672, 'model368', 4, 5),
(1673, 'model565', 5, 5),
(1674, 'model276', 7, 9),
(1675, 'model797', 6, 5),
(1676, 'model111', 4, 2),
(1677, 'model529', 2, 9),
(1678, 'model224', 3, 5),
(1679, 'model536', 9, 5),
(1680, 'model227', 3, 4),
(1681, 'model184', 5, 2),
(1682, 'model145', 6, 6),
(1683, 'model308', 7, 1),
(1684, 'model221', 4, 4),
(1685, 'model771', 6, 5),
(1686, 'model180', 6, 6),
(1687, 'model963', 4, 1),
(1688, 'model206', 2, 6),
(1689, 'model905', 3, 5),
(1690, 'model581', 4, 6),
(1691, 'model779', 7, 7),
(1692, 'model433', 6, 7),
(1693, 'model403', 5, 8),
(1694, 'model680', 6, 4),
(1695, 'model814', 6, 8),
(1696, 'model923', 2, 5),
(1697, 'model945', 4, 4),
(1698, 'model304', 7, 3),
(1699, 'model317', 9, 1),
(1700, 'model498', 3, 8),
(1701, 'model499', 2, 8),
(1702, 'model222', 2, 6),
(1703, 'model767', 6, 4),
(1704, 'model965', 6, 4),
(1705, 'model399', 8, 6),
(1706, 'model566', 2, 8),
(1707, 'model976', 9, 5),
(1708, 'model829', 9, 6),
(1709, 'model691', 5, 4),
(1710, 'model514', 8, 8),
(1711, 'model957', 3, 9),
(1712, 'model776', 8, 4),
(1713, 'model560', 5, 5),
(1714, 'model267', 9, 9),
(1715, 'model897', 3, 7),
(1716, 'model333', 2, 1),
(1717, 'model349', 6, 6),
(1718, 'model862', 6, 7),
(1719, 'model440', 3, 6),
(1720, 'model256', 9, 2),
(1721, 'model445', 9, 4),
(1722, 'model221', 1, 5),
(1723, 'model590', 5, 7),
(1724, 'model749', 4, 3),
(1725, 'model802', 6, 7),
(1726, 'model406', 2, 6),
(1727, 'model675', 5, 7),
(1728, 'model749', 1, 2),
(1729, 'model611', 8, 8),
(1730, 'model892', 5, 8),
(1731, 'model249', 3, 1),
(1732, 'model113', 9, 7),
(1733, 'model116', 6, 5),
(1734, 'model917', 8, 4),
(1735, 'model978', 5, 2),
(1736, 'model416', 4, 2),
(1737, 'model485', 9, 2),
(1738, 'model957', 5, 6),
(1739, 'model247', 4, 7),
(1740, 'model178', 5, 5),
(1741, 'model473', 4, 5),
(1742, 'model207', 6, 7),
(1743, 'model854', 4, 8),
(1744, 'model934', 9, 9),
(1745, 'model375', 6, 7),
(1746, 'model754', 6, 7),
(1747, 'model269', 2, 1),
(1748, 'model625', 3, 4),
(1749, 'model618', 3, 5),
(1750, 'model610', 4, 7),
(1751, 'model781', 3, 5),
(1752, 'model963', 3, 8),
(1753, 'model733', 4, 2),
(1754, 'model374', 7, 3),
(1755, 'model714', 6, 2),
(1756, 'model537', 9, 8),
(1757, 'model681', 8, 9),
(1758, 'model391', 3, 9),
(1759, 'model288', 1, 1),
(1760, 'model294', 7, 8),
(1761, 'model285', 7, 7),
(1762, 'model438', 3, 2),
(1763, 'model308', 6, 6),
(1764, 'model302', 4, 3),
(1765, 'model356', 1, 4),
(1766, 'model288', 2, 7),
(1767, 'model620', 7, 4),
(1768, 'model742', 1, 6),
(1769, 'model247', 7, 4),
(1770, 'model768', 3, 2),
(1771, 'model821', 5, 1),
(1772, 'model620', 2, 8),
(1773, 'model875', 8, 7),
(1774, 'model677', 8, 9),
(1775, 'model556', 2, 7),
(1776, 'model252', 5, 5),
(1777, 'model433', 5, 6),
(1778, 'model726', 2, 8),
(1779, 'model778', 7, 8),
(1780, 'model952', 7, 2),
(1781, 'model339', 5, 6),
(1782, 'model561', 9, 4),
(1783, 'model917', 1, 2),
(1784, 'model972', 8, 7),
(1785, 'model836', 7, 6),
(1786, 'model633', 6, 3),
(1787, 'model511', 8, 6),
(1788, 'model519', 6, 6),
(1789, 'model925', 8, 2),
(1790, 'model700', 8, 6),
(1791, 'model714', 3, 5),
(1792, 'model213', 6, 9),
(1793, 'model140', 2, 7),
(1794, 'model922', 8, 2),
(1795, 'model416', 9, 3),
(1796, 'model397', 2, 2),
(1797, 'model212', 2, 8),
(1798, 'model937', 7, 6),
(1799, 'model142', 2, 7),
(1800, 'model360', 7, 3),
(1801, 'model707', 8, 6),
(1802, 'model863', 6, 7),
(1803, 'model881', 8, 1),
(1804, 'model584', 7, 5),
(1805, 'model542', 5, 7),
(1806, 'model439', 9, 7),
(1807, 'model737', 3, 9),
(1808, 'model876', 1, 4),
(1809, 'model168', 2, 6),
(1810, 'model517', 8, 8),
(1811, 'model830', 8, 6),
(1812, 'model407', 6, 3),
(1813, 'model980', 8, 2),
(1814, 'model749', 8, 6),
(1815, 'model382', 5, 9),
(1816, 'model817', 6, 7),
(1817, 'model384', 5, 8),
(1818, 'model794', 4, 6),
(1819, 'model338', 2, 4),
(1820, 'model311', 4, 2),
(1821, 'model496', 3, 3),
(1822, 'model953', 4, 7),
(1823, 'model425', 1, 1),
(1824, 'model537', 3, 9),
(1825, 'model877', 3, 8),
(1826, 'model742', 9, 3),
(1827, 'model836', 4, 2),
(1828, 'model991', 4, 7),
(1829, 'model680', 7, 8),
(1830, 'model878', 5, 8),
(1831, 'model353', 2, 8),
(1832, 'model389', 6, 6),
(1833, 'model744', 2, 6),
(1834, 'model236', 2, 8),
(1835, 'model874', 4, 1),
(1836, 'model288', 6, 4),
(1837, 'model577', 2, 7),
(1838, 'model613', 6, 1),
(1839, 'model166', 7, 7),
(1840, 'model645', 3, 4),
(1841, 'model132', 5, 8),
(1842, 'model896', 6, 4),
(1843, 'model954', 9, 6),
(1844, 'model114', 4, 1),
(1845, 'model647', 4, 1),
(1846, 'model337', 5, 6),
(1847, 'model832', 9, 8),
(1848, 'model932', 9, 8),
(1849, 'model133', 8, 2),
(1850, 'model173', 2, 2),
(1851, 'model245', 4, 1),
(1852, 'model530', 2, 4),
(1853, 'model127', 5, 9),
(1854, 'model571', 4, 2),
(1855, 'model969', 5, 4),
(1856, 'model906', 8, 7),
(1857, 'model315', 4, 4),
(1858, 'model807', 8, 5),
(1859, 'model899', 3, 5),
(1860, 'model896', 2, 3),
(1861, 'model687', 4, 4),
(1862, 'model254', 4, 4),
(1863, 'model287', 7, 7),
(1864, 'model433', 5, 8),
(1865, 'model391', 5, 4),
(1866, 'model163', 2, 8),
(1867, 'model621', 2, 3),
(1868, 'model869', 6, 1),
(1869, 'model678', 7, 8),
(1870, 'model688', 8, 9),
(1871, 'model516', 8, 5),
(1872, 'model711', 3, 7),
(1873, 'model586', 5, 3),
(1874, 'model472', 7, 2),
(1875, 'model726', 7, 8),
(1876, 'model235', 8, 4),
(1877, 'model710', 3, 6),
(1878, 'model560', 7, 7),
(1879, 'model169', 8, 3),
(1880, 'model744', 2, 8),
(1881, 'model634', 8, 8),
(1882, 'model315', 3, 3),
(1883, 'model277', 3, 3),
(1884, 'model662', 4, 7),
(1885, 'model787', 6, 4),
(1886, 'model247', 7, 6),
(1887, 'model570', 3, 6),
(1888, 'model104', 2, 7),
(1889, 'model955', 6, 2),
(1890, 'model471', 5, 2),
(1891, 'model901', 3, 8),
(1892, 'model644', 9, 5),
(1893, 'model626', 8, 5),
(1894, 'model190', 8, 7),
(1895, 'model978', 5, 4),
(1896, 'model918', 4, 8),
(1897, 'model254', 2, 6),
(1898, 'model601', 7, 6),
(1899, 'model789', 9, 8),
(1900, 'model833', 8, 5),
(1901, 'model291', 6, 6),
(1902, 'model308', 7, 4),
(1903, 'model546', 2, 4),
(1904, 'model778', 1, 8),
(1905, 'model681', 5, 4),
(1906, 'model274', 8, 2),
(1907, 'model915', 9, 3),
(1908, 'model393', 7, 2),
(1909, 'model735', 5, 8),
(1910, 'model985', 7, 4),
(1911, 'model139', 8, 8),
(1912, 'model371', 4, 7),
(1913, 'model302', 1, 7),
(1914, 'model316', 2, 2),
(1915, 'model935', 8, 5),
(1916, 'model989', 7, 1),
(1917, 'model465', 8, 7),
(1918, 'model507', 2, 2),
(1919, 'model994', 7, 7),
(1920, 'model422', 5, 9),
(1921, 'model879', 6, 3),
(1922, 'model897', 9, 6),
(1923, 'model967', 5, 4),
(1924, 'model507', 5, 7),
(1925, 'model988', 8, 4),
(1926, 'model947', 9, 7),
(1927, 'model427', 8, 6),
(1928, 'model244', 9, 9),
(1929, 'model550', 6, 4),
(1930, 'model218', 7, 5),
(1931, 'model978', 8, 5),
(1932, 'model742', 3, 9),
(1933, 'model427', 5, 8),
(1934, 'model526', 9, 8),
(1935, 'model522', 3, 8),
(1936, 'model109', 2, 4),
(1937, 'model701', 8, 9),
(1938, 'model439', 3, 2),
(1939, 'model403', 8, 4),
(1940, 'model438', 4, 8),
(1941, 'model426', 1, 5),
(1942, 'model442', 7, 4),
(1943, 'model710', 7, 6),
(1944, 'model628', 2, 3),
(1945, 'model660', 9, 5),
(1946, 'model646', 6, 2),
(1947, 'model620', 7, 3),
(1948, 'model126', 8, 4),
(1949, 'model155', 7, 3),
(1950, 'model616', 6, 8),
(1951, 'model449', 4, 3),
(1952, 'model935', 3, 4),
(1953, 'model515', 5, 6),
(1954, 'model419', 8, 7),
(1955, 'model444', 7, 2),
(1956, 'model505', 5, 9),
(1957, 'model367', 7, 5),
(1958, 'model772', 6, 7),
(1959, 'model650', 5, 9),
(1960, 'model818', 5, 9),
(1961, 'model891', 4, 4),
(1962, 'model630', 3, 5),
(1963, 'model562', 7, 8),
(1964, 'model320', 9, 3),
(1965, 'model158', 3, 3),
(1966, 'model986', 1, 7),
(1967, 'model330', 1, 5),
(1968, 'model759', 2, 3),
(1969, 'model427', 3, 8),
(1970, 'model633', 8, 9),
(1971, 'model199', 5, 2),
(1972, 'model754', 4, 4),
(1973, 'model977', 6, 4),
(1974, 'model810', 3, 7),
(1975, 'model384', 4, 5),
(1976, 'model639', 6, 8),
(1977, 'model458', 8, 7),
(1978, 'model904', 3, 7),
(1979, 'model666', 4, 3),
(1980, 'model515', 6, 9),
(1981, 'model499', 2, 2),
(1982, 'model474', 3, 1),
(1983, 'model706', 7, 7),
(1984, 'model882', 4, 4),
(1985, 'model359', 5, 2),
(1986, 'model321', 7, 2),
(1987, 'model125', 7, 5),
(1988, 'model454', 2, 4),
(1989, 'model413', 7, 7),
(1990, 'model893', 1, 2),
(1991, 'model516', 5, 2),
(1992, 'model623', 8, 5),
(1993, 'model627', 5, 2),
(1994, 'model352', 4, 5),
(1995, 'model654', 7, 9),
(1996, 'model718', 9, 7),
(1997, 'model815', 9, 5),
(1998, 'model394', 4, 6),
(1999, 'model767', 7, 5),
(2000, 'model516', 6, 5),
(2001, 'model586', 2, 9),
(2002, 'model733', 6, 8),
(2003, 'model234', 3, 4);
==========================
abfragen
==========================
SELECT *
FROM auto
WHERE herstellerID =1
SELECT *
FROM `auto` , `hersteller`,`art`
where auto.herstellerID=hersteller.ID
and auto.artID=art.id
SELECT *
FROM `auto` , `hersteller`,`art`
where auto.herstellerID=hersteller.ID
and auto.artID=art.id
and art.art='cabirio'
and hersteller.bezei='mercedes'
SELECT count(auto.model) AS anzahlMeinerMercedesse
FROM `auto` , `hersteller`,`art`
where auto.herstellerID=hersteller.ID
and auto.artID=art.id
and hersteller.bezei='mercedes'
SELECT * FROM `auto` , `hersteller`,`art`
where auto.herstellerID=hersteller.ID
and auto.artID=art.id
and art.art='frauenauto'