connect 'jdbc:derby:testdb;create=false';

DROP TABLE car_car5;

CREATE TABLE car_car5 (
  id int,
  sMarke varchar(255),
  sModell varchar(255),
  sTyp varchar(255),
  iInverkehrsetzung int,
  iGetriebeart varchar(255),
  iTreibstoffart varchar(255),
  iAufbau varchar(255),
  iAussenfarbe varchar(255),
  iAussenfarbeMetallic smallint,
  iKilometer int,
  iPreisVerkauf int,
  iLeistungPS int,
  iSitzplaetze int,
  iTueren int,
  iHubraum int,
  iZylinder int,
  iEurotax_Neupreis int,
  iPreisTotal int,
  iRawOptionHatAirbag smallint,
  iRawOptionHatABS smallint,
  iRawOptionHatAlarm smallint,
  iRawOptionHatCD smallint,
  iRawOptionHatElektrischeFenster smallint,
  iRawOptionHatElektrischeSitze smallint,
  iRawOptionHatLeder smallint,
  iRawOptionHatNavigationssystem smallint,
  iRawOptionHatKlimaanlage smallint,
  iRawOptionHatNebellampen smallint,
  iRawOptionHatRadioKassette smallint,
  iRawOptionHatServolenkung smallint,
  iRawOptionHatSonnendach smallint,
  iRawOptionHatSitzheizung smallint,
  iRawOptionHatSportfahrwerk smallint,
  iRawOptionHatTraktionskontrolle smallint,
  iRawOptionHatTempomat smallint,
  iRawOptionHatWegfahrsperre smallint,
  iRawOptionHatXenonlicher smallint,
  iRawOptionHatZentralverriegelung smallint,
  iRawOptionHatMetallicfarbe smallint,
  PRIMARY KEY  (id)
);

INSERT INTO car_car5 VALUES (2073204,'CITROEN','Xantia 2.0','Xantia 2.0i 16V Harmonie',199702,'manual','gasoline','Sedan','green',0,96300,6900,132,5,5,1998,4,31850,31850,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(2073206,'CITROEN','Xantia 2.0','Xantia 2.0 HDi Exclusiv',199901,'manual','diesel','Sedan','blue',0,115000,9500,109,5,5,1997,4,38050,38050,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(3947520,'VOLVO','S80 2.4','S80 2.4 20V',200001,'manual','gasoline','Limousine','blue',0,113000,15900,170,5,4,2435,5,49100,54130,1,1,0,1,1,0,0,0,1,0,1,1,0,0,1,0,0,1,0,1,1),(3952735,'SEAT','Alhambra 2.0','Alhambra 2.0 Luxus',199805,'manual','gasoline','Sedan','silver',0,125000,12900,116,5,5,1984,4,36690,36690,1,1,1,0,1,0,0,0,1,1,0,1,0,0,0,0,1,1,0,1,1),(3953092,'CHRYSLER','Voyager 3.3','Voyager 3.3 LE',199903,'automatic','gasoline','Sedan','bordeaux',0,50000,18900,158,7,5,3301,6,48750,49250,1,1,1,0,1,1,0,0,1,1,1,1,0,0,0,0,1,1,0,1,1),(3953447,'MITSUBISHI','Colt 1.3','Colt 1.3 16V Spirit',200105,'manual','gasoline','Limousine','black',0,22300,11900,82,5,3,1299,4,16990,17370,1,0,0,1,1,0,0,0,1,0,1,1,0,0,0,0,0,1,0,1,1),(3953471,'MITSUBISHI','Pajero 3.5','Pajero 3.5 Edition',200202,'automatic','gasoline','Sedan','silver',0,43000,34900,203,5,3,3497,6,70700,71300,1,1,0,1,1,0,1,0,1,1,1,1,1,1,0,0,1,1,0,1,0),(3953716,'FORD','Mondeo 2.5','Mondeo 2.5i V6 RS',199901,'manual','gasoline','Sedan','green',1,97100,7900,170,5,5,2544,6,34500,37750,1,1,0,0,1,0,0,0,1,1,1,1,0,0,0,1,0,1,0,1,0),(3954685,'VOLVO','C70 2.4','C70 2.4T',200004,'automatic','gasoline','Coupe','silver',1,85000,22900,193,4,2,2435,5,56900,64650,1,1,0,1,1,0,1,0,1,1,0,1,0,0,0,1,0,1,0,1,1),(3954709,'VOLVO','S80 2.9','S80 2.9',199907,'manual','gasoline','Limousine','dark blue',0,69636,23800,200,5,4,2922,6,55650,65480,1,1,0,1,1,1,1,0,1,1,1,1,0,1,1,0,1,1,0,1,1),(3955219,'OPEL','Corsa 1.4','Corsa 1.4 16V Groove',200111,'manual','gasoline','Limousine','silver',0,51400,13765,90,5,3,1389,4,20900,22550,1,1,0,1,1,0,0,0,1,1,1,1,0,0,1,0,0,1,0,1,1),(3957850,'JEEP','Grand Cherokee 4.7','Gr.Cherokee 4.7 Ltd',200003,'automatic','gasoline','Sedan','grey',0,97000,18900,223,5,5,4701,8,71100,71600,1,1,0,1,1,1,1,0,1,0,1,1,0,1,0,0,1,1,0,1,0),(3957971,'PONTIAC','Grand-AM 3.1','Grand-AM 3.1 SE',199412,'automatic','gasoline','Limousine','silver',0,116000,3800,150,5,4,3134,6,42100,42100,0,1,0,0,1,1,0,0,1,0,0,1,0,0,0,0,0,0,0,0,1),(3958843,'BMW','523','523i Touring',199910,'manual','gasoline','Sedan','silver',1,60000,23900,170,5,5,2494,6,58400,58400,1,1,0,1,1,0,1,1,1,1,1,1,0,1,0,1,0,1,0,1,1),(3958930,'BMW','318','318i Touring',200306,'manual','gasoline','Sedan','silver',1,86000,24900,143,5,5,1995,4,43900,43900,1,1,1,1,1,0,0,0,1,1,1,1,0,0,0,1,0,1,0,1,1),(3959059,'BMW','325','325Ci',200206,'manual','gasoline','Cabrio','silver',1,14000,48900,192,4,2,2494,6,53500,53500,1,1,1,1,1,1,1,0,1,1,1,1,0,1,1,1,0,1,1,1,1),(3960674,'RENAULT','Clio 1.4','Clio 1.4 16V Extrême',200501,'manual','gasoline','Limousine','black',0,15700,15900,98,5,5,1390,4,21290,21780,1,1,0,1,1,0,0,0,1,1,1,1,0,0,0,0,1,1,0,1,1),(3960760,'RENAULT','Laguna 2.0','Laguna 2.0 T Auditorium',200408,'manual','gasoline','Limousine','grey',0,50,33900,163,5,5,1998,4,44100,47300,1,1,0,1,1,0,1,1,1,1,1,1,0,0,0,1,1,1,1,1,1),(3960795,'RENAULT','Clio 1.2','Clio 1.2 Be Bop',199501,'manual','gasoline','Limousine','blue',0,78000,5400,58,5,5,1171,4,14950,15570,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(3961036,'RENAULT','Mégane 1.9','Mégane 1.9dCi Dynamique',200408,'manual','diesel','Sedan','silver',0,25900,23900,120,5,5,1870,4,33900,34460,1,1,0,1,1,0,0,0,1,1,1,1,0,0,0,1,0,1,0,1,1),(3961124,'SUBARU','Impreza 2.0','Impreza 2.0 Celebration',200004,'manual','gasoline','Limousine','blue',0,75000,14500,125,5,4,1994,4,30650,30650,1,1,0,0,1,0,0,0,1,0,1,1,1,0,0,0,0,1,0,1,1),(3961304,'PEUGEOT','206 1.6','206 CC 1.6',200307,'manual','gasoline','Cabrio','grey',0,38000,17300,109,4,2,1587,4,25950,27980,1,1,0,1,1,0,0,1,1,1,1,1,1,0,0,0,0,1,0,1,1),(3962197,'VW','Golf 1.8','Golf 1.8 T GTI',199807,'manual','gasoline','Limousine','black',0,112000,13600,150,5,3,1781,4,38410,39000,1,1,1,0,1,0,0,0,1,1,0,1,0,1,1,0,0,1,0,1,1),(3962432,'VW','Sharan 1.8','Sharan 1.8 T Trendline',200001,'automatic','gasoline','Sedan','blue',0,125000,18300,150,5,5,1781,4,44980,48540,1,1,1,0,1,0,0,0,1,1,0,1,0,0,0,0,1,1,0,1,0),(3963024,'TOYOTA','LandCruiser 3.0','LandCruiser 3.0TD L.Sol',200503,'automatic','diesel','Sedan','silver',1,13900,65500,166,5,5,2982,4,68800,72975,1,1,0,1,1,1,0,0,1,1,1,1,0,1,0,1,1,1,0,1,1),(3964920,'FERRARI','575','575M',200404,'automatic','gasoline','Coupe','anthracite',0,11950,199000,517,2,2,5748,12,278000,290000,1,1,1,1,1,1,1,0,1,1,1,1,0,0,0,1,0,1,0,1,1),(3967203,'MAZDA','323 1.6','323 1.6i 4WD (Formula 4)',198912,'manual','gasoline','Sedan','red',0,113000,950,86,5,5,1597,4,23350,23350,0,0,0,0,0,0,0,0,1,0,0,1,0,0,0,0,0,0,0,0,0),(3967598,'MAZDA','Demio 1.5','Demio 1.5i-16 High ABS',200007,'automatic','gasoline','Sedan','silver',0,26500,14500,75,5,5,1498,4,20880,22830,1,1,0,0,1,0,0,0,1,1,1,1,0,0,0,0,0,1,0,1,1),(3968241,'MERCEDES-BENZ','S 500','S 500',200107,'automatic','gasoline','Limousine','grey',0,54600,64900,306,5,4,4966,8,135650,152511,1,1,0,1,1,1,1,1,1,1,1,1,0,1,0,1,1,1,1,1,1),(3968435,'CITROEN','Saxo 1.4','Saxo 1.4i SX A',199912,'automatic','gasoline','Limousine','silver',0,19500,10700,75,5,5,1360,4,17000,17400,1,0,0,0,1,0,0,0,1,0,1,1,0,0,0,0,0,1,0,1,1),(3968484,'CITROEN','Xsara 1.8','Xsara Picasso 1.8i 16V SX',200007,'manual','gasoline','Sedan','white',0,99500,11900,116,5,5,1749,4,29500,29500,1,1,0,1,1,0,0,0,1,1,1,1,0,0,0,0,0,1,0,1,0),(3968488,'CITROEN','Xantia 3.0','Xantia 3.0i V6 Activa',199712,'manual','gasoline','Limousine','blue',0,75000,11900,190,5,5,2946,6,39800,40250,1,1,0,0,1,1,1,0,1,1,1,1,0,0,0,0,0,1,0,1,1),(3968506,'CITROEN','Xsara 1.8','Xsara Picasso 1.8i 16V SX',200102,'manual','gasoline','Sedan','silver',1,84800,11950,116,5,5,1749,4,29500,30190,1,1,0,1,1,0,0,0,1,1,1,1,0,0,0,0,0,1,0,1,1),(3971529,'MERCEDES-BENZ','A 160','A 160 L Avantgarde',200407,'automatic','gasoline','Limousine','silver',0,10900,26800,102,5,5,1598,4,34240,37485,1,1,0,0,1,0,0,0,1,1,0,1,0,0,0,0,0,1,0,1,1),(3971565,'MERCEDES-BENZ','SLK 230','SLK 230 Kompressor',199809,'manual','gasoline','Cabrio','black',0,71000,26900,193,2,2,2295,4,57350,60317,1,1,0,1,1,0,1,0,1,1,1,1,1,0,1,1,0,1,0,1,0),(3971584,'MERCEDES-BENZ','C 240','C 240 Elégance',199912,'automatic','gasoline','Limousine','silver',1,56000,27400,170,5,4,2398,6,53485,60162,1,1,0,1,1,0,0,0,0,1,1,1,0,0,0,1,0,1,0,1,1),(3971589,'MERCEDES-BENZ','SL 320','SL 320',199604,'automatic','gasoline','Cabrio','dark blue',1,82000,27500,231,2,2,3199,6,125500,138397,1,1,1,1,1,1,1,0,1,1,0,1,0,1,1,1,1,1,0,1,1),(3971682,'MERCEDES-BENZ','C 240','C 240 Elégance',200111,'automatic','gasoline','Limousine','silver',0,82500,28800,170,5,4,2597,6,58005,70209,1,1,0,0,1,1,1,0,1,1,1,1,1,1,0,1,1,1,0,1,1),(3971688,'MERCEDES-BENZ','E 320','E 320 Elégance 4-Matic',200009,'automatic','gasoline','Limousine','black',0,122600,28900,224,5,4,3199,6,75426,87586,1,1,1,1,1,0,1,1,1,1,1,1,1,1,0,0,1,1,0,1,0),(3972233,'ALFA ROMEO','145 1.6','145 1.6 TS 16V L',199802,'manual','gasoline','Limousine','grey',0,68900,11550,120,5,3,1598,4,24500,27380,1,1,0,0,1,0,0,0,1,1,0,1,0,0,0,0,0,1,0,1,1),(3972267,'ALFA ROMEO','Spider 2.0','Spider 2.0 TS 16V',199704,'manual','gasoline','Cabrio','grey',0,73000,12600,150,2,2,1970,4,39800,39800,1,1,0,0,1,0,1,0,0,1,0,1,0,0,0,0,0,1,0,1,1),(3972337,'ALFA ROMEO','156 2.0','156 2.0 JTS Distinctive',200208,'manual','gasoline','Sedan','silver',0,27000,28900,166,5,5,1970,4,38800,39570,1,1,0,1,1,0,0,0,1,1,1,1,0,0,0,0,1,1,0,1,0),(3972338,'ALFA ROMEO','156 2.0','156 2.0 JTS Distinctive',200312,'manual','gasoline','Sedan','silver',0,28000,28900,166,5,5,1970,4,39800,43410,1,1,0,1,1,0,1,0,1,1,1,1,0,0,0,1,1,1,0,1,1),(3972383,'KIA','Picanto 1.1','Picanto 1.1 EX',200411,'manual','gasoline','Limousine','blue',0,19000,13500,65,5,5,1086,4,15950,15950,1,1,0,1,1,0,0,0,1,1,1,1,0,0,0,0,0,0,0,1,1),(3973323,'RENAULT','Vel Satis 3.0','Vel Satis 3.0dCi Initiale',200203,'automatic','diesel','Limousine','silver',0,82000,33500,177,5,5,2958,6,71100,72450,1,1,0,1,1,1,1,1,1,1,1,1,0,1,0,1,1,1,1,1,1),(3973436,'RENAULT','GrScénic 1.9','GrScénic 1.9dCi Dynamique',200502,'manual','diesel','Sedan','black',0,21000,27500,120,7,5,1870,4,37450,39510,1,1,0,1,1,0,0,1,1,1,0,1,0,0,0,0,1,1,0,1,1),(3973486,'SUBARU','Legacy 2.0','Legacy 2.0 Swiss',200003,'manual','gasoline','Sedan','red',0,61880,14400,125,5,5,1994,4,32950,33450,1,1,0,0,1,0,0,0,0,0,1,1,0,0,0,0,0,1,0,1,0),(3974271,'OPEL','Zafira 2.2','Zafira 2.2i 16V Elegance',200103,'automatic','gasoline','Sedan','silver',0,78400,17500,147,7,5,2198,4,34300,36420,1,1,0,1,1,0,0,0,1,1,1,1,0,1,0,1,1,1,0,1,1),(3974327,'OPEL','Vectra 2.2','Vectra 2.2 DTi Sport',200404,'manual','diesel','Sedan','silver',0,33700,29500,125,5,5,2172,4,40250,44050,1,1,0,1,1,0,0,1,1,1,1,1,0,0,1,1,0,1,0,1,1),(3976138,'BMW','318','318 ti Compact',200204,'manual','gasoline','Limousine','silver',1,45000,26900,143,5,3,1995,4,36900,36900,1,1,1,1,1,0,0,0,1,1,1,1,0,0,1,1,0,1,0,1,1),(3981464,'LAND ROVER','Range Rover 4.6','Range Rover 4.6 HSE',199506,'automatic','gasoline','Sedan','green',0,75600,16500,226,5,5,4554,8,93800,93800,1,1,1,1,1,1,1,0,1,1,1,1,1,1,0,1,1,1,0,1,1),(3984250,'MERCEDES-BENZ','S 500','S 500 L',200009,'automatic','gasoline','Limousine','black',0,99000,49800,306,5,4,4966,8,142050,164087,1,1,0,1,1,1,1,1,1,1,1,1,1,1,0,1,1,1,1,1,1),(3984929,'OPEL','Omega 2.5','Omega 2.5 TD Business',199805,'manual','diesel','Limousine','silver',0,135000,8900,131,5,4,2497,6,43800,47100,1,1,0,1,1,0,0,0,1,0,1,1,0,0,0,0,1,1,0,1,1),(3986328,'VW','Passat 2000','Passat 2000 Swiss Star',199605,'automatic','gasoline','Sedan','green',0,125000,10900,116,5,5,1984,4,33000,36380,1,1,0,0,1,0,0,0,1,1,0,1,0,0,0,0,0,1,0,1,1),(3986411,'VW','Passat 2000','Passat 2000 Swiss Star',199701,'automatic','gasoline','Sedan','white',0,120960,11600,116,5,5,1984,4,34820,38495,1,1,0,0,1,0,0,0,1,1,0,1,0,0,0,0,1,1,0,1,0),(3987487,'SUZUKI','Swift 1.0','Swift 1.0 GL',199509,'manual','gasoline','Limousine','blue',0,76000,4300,53,5,5,993,3,11990,12340,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1),(3987594,'SUZUKI','Jimny 1.3','Jimny 1.3 16V JLX',200002,'manual','gasoline','Cabrio','blue',0,54000,10800,80,4,3,1298,4,21990,21990,1,0,0,0,1,0,0,0,0,0,1,1,0,0,0,0,0,1,0,1,0),(3993688,'BMW','320','320i',199907,'manual','gasoline','Limousine','black',0,65200,21900,150,5,4,1991,6,45300,49820,1,1,1,1,1,0,0,0,1,1,1,1,0,0,0,1,0,1,0,1,0),(3993850,'BMW','328','328Ci',199905,'manual','gasoline','Coupe','black',1,78000,23500,193,5,2,2793,6,54700,54700,1,1,1,0,1,1,0,0,1,1,1,1,0,0,1,1,0,1,0,1,1),(3993874,'BMW','535','535i',200004,'manual','gasoline','Limousine','blue',1,72000,23600,245,5,4,3498,8,73100,73100,1,1,1,0,1,0,0,0,1,1,1,1,0,0,0,1,1,1,1,1,1),(3993876,'BMW','Z3','Z3 1.9i Roadster',199907,'manual','gasoline','Cabrio','silver',1,33000,23700,118,2,2,1895,4,40800,40800,1,1,0,0,1,1,1,0,1,0,0,1,0,0,0,1,0,1,0,1,1),(3993942,'BMW','528','528i',200009,'automatic','gasoline','Limousine','red',1,67000,24000,193,5,4,2793,6,59900,65790,1,1,0,0,1,0,0,0,1,1,1,1,0,0,0,1,0,1,0,1,1),(3994611,'OPEL','Corsa 1.2','Corsa 1.2 TP L.Fresca',200412,'manual','gasoline','Limousine','silver',0,8000,16500,80,5,5,1229,4,18300,19450,1,1,0,1,1,0,0,0,1,0,1,1,0,0,0,0,0,1,0,1,1),(3997541,'VOLVO','V70 2.4','V70 2.4T',200110,'manual','gasoline','Sedan','silver',0,87518,30950,200,5,5,2435,5,52700,60580,1,1,0,1,1,0,0,0,1,1,1,1,0,1,1,1,1,1,0,1,1),(3999608,'CITROEN','XM 3.0','XM 3.0 V6 Exclusive A',199306,'automatic','gasoline','Sedan','grey',0,168900,4800,167,5,5,2961,6,60250,64080,0,1,0,0,1,1,1,0,1,1,1,1,1,1,0,0,0,1,0,1,1),(3999725,'OPEL','Zafira 2.2','Zafira 2.2i 16V Elegance',200109,'manual','gasoline','Sedan','silver',0,40000,21250,147,7,5,2198,4,34300,34880,1,1,0,1,1,0,0,0,1,1,1,1,0,0,0,1,1,1,0,1,1),(4009785,'VW','Beetle 1.8','Beetle 1.8 T',200011,'manual','gasoline','Limousine','red',0,53000,12800,150,4,3,1781,4,31440,33180,1,1,1,0,1,0,0,0,1,1,1,1,1,1,0,1,1,1,0,1,0),(4011464,'DAIHATSU','Sirion 1.3','Sirion 1.3 S',200508,'manual','gasoline','Limousine','silver',1,2500,17500,87,5,5,1298,4,18990,18990,1,1,0,1,1,0,0,0,1,1,1,1,0,0,0,0,0,1,0,1,1),(4012858,'JEEP','Grand Cherokee 4.7','Gr.Cherokee 4.7 Ltd',200001,'automatic','gasoline','Sedan','grey',1,106000,19900,223,5,5,4701,8,71100,71100,1,1,0,1,1,1,1,0,1,0,1,1,0,1,0,0,1,1,0,1,0),(4014577,'VW','Golf 1800','Golf 1800 Swiss Line ABS',199810,'manual','gasoline','Sedan','blue',0,73500,10800,90,5,5,1780,4,22990,25000,1,1,1,0,1,0,0,0,1,0,0,1,0,0,0,0,0,1,0,1,0),(4014650,'VW','Golf 1800','Golf 1800 Swiss Line ABS',199709,'manual','gasoline','Limousine','bordeaux',0,72000,11000,90,5,5,1780,4,22590,24290,1,1,1,0,1,0,0,0,1,0,0,1,0,0,0,0,0,1,0,1,0),(4014716,'VW','Sharan 2.8','Sharan 2.8 VR6 GL syncro',199701,'automatic','gasoline','Sedan','light blue',1,185346,11800,174,5,5,2792,6,47450,50650,1,1,1,0,1,0,0,0,1,1,0,1,0,1,0,0,0,1,0,1,1),(4014725,'VW','Golf 2000','Golf 2000 GTI 20 Years',199610,'manual','gasoline','Limousine','black',0,124400,11900,116,5,5,1984,4,30650,30650,1,1,1,0,1,0,0,0,1,1,0,1,0,0,1,0,0,1,0,1,0),(4014897,'VW','Golf 2.0','Golf 2.0 TDI Sport',200411,'manual','diesel','Limousine','silver',1,61092,22500,140,5,5,1968,4,35410,37450,1,1,0,1,1,0,0,0,1,1,1,1,0,0,1,1,0,1,0,1,1),(4015556,'SEAT','Altea 2.0','Altea 2.0 TDI Stylance',200507,'manual','diesel','Sedan','black',0,600,32900,140,5,5,1968,4,32550,34260,1,1,1,1,1,0,0,0,1,1,1,1,0,0,0,1,1,1,0,1,0),(4020835,'NISSAN','Primera 2.2','Primera 2.2 Di visia',200204,'manual','diesel','Sedan','silver',0,55000,23900,126,5,5,2184,4,35300,35950,1,1,0,1,1,0,0,0,1,0,1,1,0,0,0,0,0,1,0,1,1),(4022713,'OPEL','Astra 1.6','Astra 1.6i 16V Favorit',200108,'manual','gasoline','Sedan','white',0,73000,12500,101,5,5,1598,4,25750,25750,1,1,0,0,1,0,0,0,1,0,1,1,0,0,0,0,0,1,0,1,0),(4022876,'OPEL','Frontera 3.2','Frontera 3.2i V6 Limited',200103,'automatic','gasoline','Sedan','dark blue',0,74800,16800,205,5,5,3165,6,48600,56230,1,1,1,1,1,0,0,0,1,1,1,1,1,1,0,0,1,1,0,1,1),(4022898,'OPEL','Corsa 1.0','Corsa 1.0 12V Young',200111,'manual','gasoline','Limousine','blue',0,42000,9990,58,5,3,973,3,15800,16270,1,0,0,1,0,0,0,0,0,0,1,1,0,0,0,0,0,1,0,1,1),(4023053,'FORD','Escort 1.4','Escort 1.4i Bravo',199406,'manual','gasoline','Sedan','red',0,56800,5800,73,5,5,1390,4,19150,20930,1,1,0,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,1,0),(4023251,'PEUGEOT','406 1.8','406 SR 1.8 16V',199804,'manual','gasoline','Limousine','red',1,141000,6500,110,5,4,1761,4,28150,28600,1,1,0,0,1,0,0,0,1,0,0,1,0,0,0,0,0,1,0,1,1),(4023588,'BMW','330','330xi',200101,'automatic','gasoline','Limousine','silver',1,32000,41800,231,5,4,2979,6,59700,59700,1,1,1,0,1,1,1,1,1,1,1,1,0,1,0,1,0,1,1,1,1),(4023589,'BMW','325','325xi Touring',200301,'automatic','gasoline','Sedan','silver',1,73000,40900,192,5,5,2494,6,57000,57000,1,1,1,1,1,0,0,0,1,1,1,1,0,0,0,1,0,1,0,1,1),(4025658,'OPEL','Corsa 1.3','Corsa 1.3 CDTi L.Fresca',200501,'automatic','diesel','Limousine','grey',0,23000,19500,69,5,5,1248,4,19500,21200,1,1,0,1,1,0,0,0,1,0,1,1,0,0,0,0,0,1,0,1,1),(4027158,'RENAULT','Scénic 1.6','Scénic 1.6 16V Auth.Conf.',200312,'manual','gasoline','Sedan','black',0,62000,18300,113,5,5,1598,4,29650,30210,1,1,0,1,1,0,0,0,1,1,1,1,0,0,0,0,0,1,0,1,1),(4027167,'RENAULT','Scénic 2.0','Scénic 2.0 16V Dynamique',200301,'manual','gasoline','Sedan','dark blue',0,43000,22594,135,5,5,1998,4,34300,34300,1,1,0,1,1,0,0,1,1,1,1,1,0,0,0,1,1,1,0,0,1),(4028824,'AUDI','A4 1.8','A4 1.8',199506,'manual','gasoline','Limousine','blue',0,143500,7800,125,5,4,1781,4,36000,38110,1,1,1,0,1,0,0,0,1,0,0,1,1,0,0,0,0,1,0,1,1),(4029390,'BMW','328','328i A Coupé Exclusiv',199804,'automatic','gasoline','Coupe','black',0,20810,19900,193,5,2,2793,6,60950,66470,1,1,0,1,1,0,1,0,1,1,1,1,1,1,0,1,0,1,0,1,1),(4031095,'CHRYSLER','Grand Voyager 3.8','Grand Voyager 3.8 LE AWD',199812,'automatic','gasoline','Sedan','blue',0,110266,14850,178,7,5,3778,6,60900,63300,1,1,1,0,1,1,1,0,1,1,1,1,0,0,0,0,1,1,0,1,1),(4031748,'RENAULT','Laguna 2.2','Laguna 2.2dCi Expression',200305,'manual','diesel','Limousine','grey',0,21500,33500,150,5,5,2188,4,39200,42450,1,1,0,1,1,0,0,0,1,1,1,1,0,0,0,1,0,1,0,1,1),(4031792,'RENAULT','Clio 2.0','Clio 2.0 16V Sport',200011,'manual','gasoline','Limousine','blue',0,131000,10440,169,5,3,1998,4,28150,28150,1,1,0,1,1,0,1,0,1,1,1,1,0,0,0,0,0,1,0,1,1),(4031809,'RENAULT','Clio 1.4','Clio 1.4 16V Extrême',200402,'manual','gasoline','Limousine','blue',0,17300,14900,98,5,5,1390,4,21290,22480,1,1,0,1,1,0,0,0,1,1,1,1,0,0,0,0,0,1,0,1,1),(4032122,'NISSAN','Micra 1.4','Micra 1.4 Luxury',200107,'automatic','gasoline','Limousine','black',0,42100,12900,82,5,5,1348,4,16850,19000,1,0,0,1,1,0,0,0,1,0,1,1,0,0,0,0,0,1,0,1,1),(4036011,'MERCEDES-BENZ','SLK 32','SLK 320',200312,'manual','gasoline','Cabrio','black',0,20500,46500,218,2,2,3199,6,65050,75100,1,1,0,1,1,0,1,1,1,1,1,1,1,1,0,0,1,1,0,1,1),(4036054,'MERCEDES-BENZ','CLK 320','CLK 320 Elégance',200002,'automatic','gasoline','Cabrio','dark blue',1,44000,47900,218,4,2,3199,6,80050,90637,1,1,1,1,1,1,1,0,1,1,1,1,0,0,0,1,1,1,1,1,1),(4039132,'MAZDA','Demio 1.5','Demio 1.5i-16 High ABS',200007,'automatic','gasoline','Sedan','silver',0,26500,14500,75,5,5,1498,4,20880,22830,1,1,0,0,1,0,0,0,1,1,1,1,0,0,0,0,0,1,0,1,1),(4040409,'OPEL','Corsa 1.2','Corsa 1.2 Eco',199612,'manual','gasoline','Limousine','light green',0,126500,3950,45,5,3,1195,4,14975,15285,1,0,0,0,0,0,0,0,1,0,1,0,0,0,0,0,0,0,0,0,0),(4040419,'OPEL','Corsa 1.4','Corsa 1.4 TP Enjoy',200402,'manual','gasoline','Limousine','silver',0,28000,15500,90,5,5,1364,4,17700,21560,1,1,0,1,1,0,0,0,1,1,1,1,0,0,0,0,0,1,0,1,1),(4041048,'VW','Bora 1.9','Bora 1.9 TDI PD',200503,'manual','diesel','Limousine','silver',0,27750,25750,131,5,4,1896,4,30590,31760,1,1,0,1,1,0,0,0,1,0,1,1,0,0,0,1,0,1,0,1,1),(4041277,'VW','Fox 1.4','Fox 1.4',200505,'manual','gasoline','Limousine','silver',0,6360,17900,75,4,3,1390,4,15510,19180,1,1,0,1,1,0,0,0,1,1,1,1,0,0,0,0,0,1,0,1,1),(4042062,'CHRYSLER','PT Cruiser 2.4','PT Cruiser 2.4 GT Turbo',200406,'manual','gasoline','Sedan','silver',0,27500,26900,223,5,5,2429,4,41600,44900,1,1,1,1,1,0,1,1,1,1,1,1,0,1,1,1,1,1,0,1,1),(4042326,'MITSUBISHI','Tredia 1600','Tredia 1600 GLS',198410,'manual','gasoline','Limousine','silver',0,50200,4800,75,5,4,1597,4,16500,16500,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(4043364,'OPEL','Astra 1.4','Astra 1.4i 16V Favorit',200205,'manual','gasoline','Sedan','blue',0,97500,10500,90,5,5,1389,4,24750,26610,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,1),(4043449,'OPEL','Vectra 2.0','Vectra 2.0i 16V Elegance',199904,'automatic','gasoline','Sedan','grey',0,122000,10900,136,5,5,1998,4,38200,40460,1,1,0,1,1,0,0,0,1,1,1,1,0,1,0,1,1,1,0,1,1),(4043509,'OPEL','Vectra 2.0','Vectra 2.0i 16V Comfort',199911,'manual','gasoline','Limousine','white',0,75000,11200,136,5,5,1998,4,34950,34950,1,1,0,1,1,0,0,0,1,1,1,1,0,0,0,1,0,1,0,1,0),(4045597,'OPEL','Meriva 1.6','Meriva 1.6i 16V L.Fresca',200505,'manual','gasoline','Sedan','silver',0,5800,19980,101,5,5,1598,4,23150,23680,1,1,1,1,1,0,0,0,1,0,1,1,0,0,0,0,0,1,0,1,1),(4046797,'AUDI','A3 3.2','A3 3.2 Ambition quattro',200501,'manual','gasoline','Limousine','black',0,6250,44900,250,5,3,3189,6,52620,58765,1,1,0,1,1,0,0,0,1,1,1,1,0,0,1,1,1,1,1,1,1),(4048260,'BMW','318','318i',200310,'automatic','gasoline','Limousine','silver',1,11000,34900,143,5,4,1995,4,40900,40900,1,1,1,1,1,0,1,0,1,1,1,1,0,1,0,1,0,1,0,1,1),(4049464,'OPEL','Zafira 2.2','Zafira 2.2 DTi Njoy',200401,'manual','diesel','Sedan','silver',0,25000,27600,125,7,5,2172,4,32550,35520,1,1,0,1,1,0,0,0,1,1,1,1,0,0,0,1,1,1,0,1,1),(4049474,'OPEL','Omega 3.2','Omega 3.2i V6 Executive',200304,'automatic','gasoline','Sedan','silver',0,74580,27700,218,5,5,3175,6,65800,67550,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,1,1,1,1,1,0),(4051167,'VOLVO','V40 1.8','V40 1.8 Limited Sports Ed',200306,'manual','gasoline','Sedan','black',1,45400,26900,122,5,5,1783,4,37550,39850,1,1,0,1,1,0,1,0,1,1,1,1,0,1,1,0,1,1,1,1,1),(4051227,'VOLVO','S60 2.5','S60 2.5T',200404,'automatic','gasoline','Limousine','blue',0,36000,38900,209,5,4,2521,5,43650,55386,1,1,0,1,1,0,1,1,1,1,1,1,0,1,1,1,1,1,1,1,1),(4051459,'CITROEN','C5 2.2','C5 2.2 HDi Exclusive A',200411,'automatic','diesel','Limousine','silver',0,12000,35900,133,5,5,2179,4,48240,52640,1,1,1,1,1,1,1,1,1,0,1,1,0,1,0,1,1,1,1,1,1),(4051908,'BMW','X3 3.0','X3 3.0d',200510,'automatic','diesel','Sedan','silver',1,0,77400,218,5,5,2993,6,64700,64700,1,1,0,1,1,0,1,1,1,1,1,1,0,1,0,1,0,1,1,1,1),(4052220,'OPEL','Tigra 1.6','Tigra 1.6 16V',199906,'manual','gasoline','Coupe','black',0,55700,10400,106,4,3,1598,4,26100,27075,1,1,1,0,1,0,0,0,1,1,1,1,0,0,1,0,0,1,0,1,0),(4052342,'OPEL','Astra 2.0','Astra 2.0i 16V Sport STec',199612,'manual','gasoline','Sedan','white',0,64000,10900,136,5,5,1998,4,29075,30050,1,1,0,1,1,0,0,0,1,1,1,1,0,0,0,0,0,1,0,1,0),(4052992,'FORD','Escort 1.8','Escort 1.8i 16V Newport',199605,'manual','gasoline','Sedan','red',0,113000,5500,105,5,5,1795,4,24650,24650,1,1,0,0,1,0,0,0,1,0,1,1,0,0,0,0,0,0,0,1,0),(4053073,'FORD','Escort 1.8','Escort 1.8i 16V Style',199710,'manual','gasoline','Sedan','bordeaux',0,131900,5900,116,5,5,1796,4,21350,22050,1,1,0,0,1,0,0,0,0,1,1,1,0,0,0,0,0,1,0,1,0),(4053125,'FORD','Fiesta 1.3','Fiesta 1.3 Ambiente',199902,'manual','gasoline','Limousine','blue',0,90000,6500,60,5,5,1299,4,15850,15850,1,1,0,0,0,0,0,0,0,0,0,1,0,0,0,1,0,1,0,0,0),(4053171,'FORD','Escort 1.8','Escort 1.8i 16V Newport',199602,'manual','gasoline','Limousine','dark blue',0,59400,6800,105,5,5,1795,4,24650,26170,1,1,0,0,1,0,0,0,1,0,1,1,0,0,0,0,0,0,0,1,1),(4054607,'MITSUBISHI','Colt 1.3','Colt 1.3 16V Spirit',200105,'manual','gasoline','Limousine','black',0,22300,11900,82,5,3,1299,4,16990,17370,1,0,0,1,1,0,0,0,1,0,1,1,0,0,0,0,0,1,0,1,1),(4054630,'MITSUBISHI','Carisma 1.8','Carisma 1.8 GDI Comfort',200005,'manual','gasoline','Limousine','silver',0,55000,12900,122,5,5,1834,4,31190,31190,1,1,0,0,1,0,0,0,1,0,0,1,0,0,0,0,0,1,0,1,0),(4054662,'MITSUBISHI','Space Runner 2.4','Space R 2.4 GDI Edition',200003,'manual','gasoline','Sedan','black',0,101000,13790,147,5,4,2351,4,39690,44400,1,1,1,0,1,0,0,1,1,1,1,1,0,0,0,0,0,1,0,1,1),(4056728,'FIAT','Brava 1.6','Brava 1.6 16V SX',199706,'manual','gasoline','Limousine','blue',0,128000,4400,103,5,5,1581,4,21500,22200,1,0,0,0,1,0,0,0,0,0,1,1,0,0,0,0,0,1,0,1,1),(4056936,'MAZDA','2 1.4','2 1.4i 16V Exclusive',200405,'manual','gasoline','Limousine','black',0,16700,17800,80,5,5,1388,4,21390,21890,1,1,0,1,1,0,0,0,1,1,0,1,0,1,0,0,0,1,0,1,1),(4056954,'MAZDA','323 1.5','323 P 1.5i-16V GLX',200007,'manual','gasoline','Limousine','silver',1,54300,10900,88,5,3,1489,4,20120,20720,1,0,0,1,1,0,0,0,1,0,1,1,0,0,0,0,0,1,0,1,1),(4059231,'BMW','520','520i',199704,'manual','gasoline','Limousine','black',1,76650,16970,150,5,4,1991,6,47600,54370,1,1,1,1,1,0,1,0,1,1,1,1,0,1,0,1,0,1,0,1,1),(4059729,'AUDI','A4 1.9','A4 Avant 1.9 TDI quattro',200206,'manual','diesel','Sedan','silver',0,56000,30800,131,5,5,1896,4,50020,55125,1,1,1,0,1,0,0,0,1,1,1,1,0,1,0,1,1,1,0,1,1),(4059821,'AUDI','TT Coupé','TT Coupé 1.8 T quattro',200104,'manual','gasoline','Coupe','black',0,39000,31900,224,4,3,1781,4,53150,58855,1,1,1,1,1,0,1,0,1,1,1,1,0,1,1,0,1,1,1,1,1),(4059912,'AUDI','A4 2.0','A4 2.0',200308,'automatic','gasoline','Limousine','blue',1,10199,33500,131,5,4,1984,4,40200,40200,1,1,1,0,1,0,0,0,1,1,0,1,0,0,0,0,0,1,0,1,0),(4060098,'NISSAN','X-Trail 2.2','X-Trail 2.2 DCI Sport',200402,'manual','diesel','Sedan','dark red',0,30000,28500,136,5,5,2184,4,39800,40450,1,1,0,1,1,0,0,0,1,1,1,1,0,0,0,0,0,1,0,1,1),(4061573,'BMW','328','328i Touring',199604,'manual','gasoline','Sedan','grey',1,130700,13500,193,5,5,2793,6,54300,60110,1,1,1,0,1,0,0,0,0,1,0,1,0,0,0,1,0,1,0,1,1),(4074200,'FORD','Galaxy 1.9','Galaxy 1.9 TDi Ambiente',200111,'manual','diesel','Sedan','black',0,96900,16800,116,5,5,1896,4,40650,43950,1,1,0,1,1,0,0,0,1,1,1,1,0,0,1,0,0,1,0,1,0),(4075014,'SUZUKI','Jimny 1.5','Jimny 1.5 TD (JLX) GL Top',200411,'manual','diesel','Sedan','blue',0,10200,19900,65,4,3,1461,4,24990,25440,1,1,0,1,1,0,0,0,1,0,1,1,0,0,0,0,0,1,0,1,1),(4075492,'BMW','330','330i',200509,'automatic','gasoline','Limousine','silver',1,20000,60900,258,5,4,2996,6,57500,57500,1,1,1,1,1,0,1,1,1,1,1,1,0,1,0,1,0,1,0,1,1),(4075577,'BMW','325','325i Touring',200511,'automatic','gasoline','Sedan','silver',1,0,63690,218,5,5,2497,6,53200,53200,1,1,1,1,1,0,1,0,1,1,1,1,0,1,0,1,0,1,1,1,1),(4075651,'BMW','530','530i',200312,'automatic','gasoline','Limousine','blue',1,10000,65500,231,5,4,2979,6,63600,63600,1,1,1,1,1,1,1,1,1,1,0,1,0,1,0,1,1,1,1,1,1),(4075945,'TOYOTA','Avensis 2.0','Avensis 2.0 Linea Sol',199806,'automatic','gasoline','Sedan','white',0,190000,8700,128,5,5,1998,4,33350,35050,1,1,0,1,1,0,0,0,1,1,1,1,0,0,0,0,0,1,0,1,0),(4078365,'SUBARU','Forester 2.0','Forester 2.0 T.NightBlue',200002,'manual','gasoline','Sedan','black',0,69000,18900,170,5,5,1994,4,40700,40700,1,1,0,0,1,0,1,0,1,0,1,1,1,1,0,0,0,1,0,1,1),(4078998,'LANCIA','Kappa 2.4','Kappa 2.4 LS',199707,'manual','gasoline','Limousine','blue',0,155800,2900,175,5,4,2446,5,44550,45350,1,1,0,0,1,0,0,0,1,1,0,1,0,0,0,0,0,1,0,1,1),(4079072,'DAEWOO','Matiz','Matiz 800 Safety',200412,'manual','gasoline','Limousine','black',1,4000,9200,52,5,5,796,3,11490,11880,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,1),(4079576,'FIAT','Punto 1.8','Punto 1.8 16V HGT',200104,'manual','gasoline','Limousine','grey',0,69000,10380,131,5,3,1747,4,23700,24160,1,1,0,1,1,0,0,1,1,1,1,1,0,0,0,1,0,1,0,1,1),(4079652,'FIAT','Seicento','Seicento Sporting',200212,'manual','gasoline','Limousine','yellow',0,42000,8200,54,5,3,1108,4,14390,14390,1,1,0,1,1,0,0,0,1,1,1,1,0,0,1,0,0,1,0,1,0),(4080115,'HONDA','Civic 1.6','Civic 1.6i LS',199502,'manual','gasoline','Limousine','green',1,125000,6500,113,5,5,1590,4,28900,29300,1,1,0,1,1,0,0,0,0,0,1,1,1,0,0,0,0,0,0,1,1),(4080599,'JEEP','Wrangler 2.5','Wrangler 2.5 Sahara',198911,'manual','gasoline','Cabrio','brown',0,53000,7500,103,4,3,2463,4,32400,32800,0,0,0,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,1),(4080608,'JEEP','Cherokee 4.0','Cherokee 4.0 Limited',199201,'automatic','gasoline','Sedan','grey',0,118000,7950,185,5,5,3958,6,54990,55390,0,1,1,0,1,1,1,0,1,0,1,1,0,0,0,0,1,0,0,1,1),(4081066,'OPEL','Signum 3.2','Signum 3.2 Cosmo',200309,'automatic','gasoline','Limousine','blue',0,37500,25890,211,5,5,3175,6,47600,51060,1,1,0,1,1,1,1,0,1,1,1,1,0,1,0,1,1,1,0,1,1),(4081198,'VW','Golf 2.3','Golf 2.3 Highline 4Motion',200307,'manual','gasoline','Limousine','silver',0,26000,26500,170,5,5,2324,5,40280,41510,1,1,1,0,1,0,0,0,1,1,1,1,0,0,0,0,0,1,0,1,1),(4081467,'SUZUKI','Swift 1.3','Swift 1.3 GLS',200207,'automatic','gasoline','Limousine','silver',1,3600,9400,86,5,3,1298,4,14990,16680,1,0,0,0,1,0,0,0,1,0,0,1,0,0,0,0,0,1,0,1,1),(4081863,'BMW','X3 2.0','X3 2.0i',200512,'manual','gasoline','Sedan','black',0,0,53165,150,5,5,1995,4,50900,50900,1,1,0,1,1,0,0,0,1,1,1,1,0,0,0,1,0,1,0,1,0),(4082185,'TOYOTA','Corolla 1.6','Corolla 1.6 Linea Terra',199806,'manual','gasoline','Sedan','blue',0,52000,10800,110,5,5,1587,4,23900,25870,1,1,0,0,1,0,0,0,1,0,1,1,0,0,0,0,0,0,0,1,1),(4082738,'RENAULT','Espace 2.2','Espace 2.2 Alizé Quadra',199505,'manual','gasoline','Sedan','brown',0,130000,5900,107,5,5,2164,4,41200,41970,1,0,0,0,1,0,0,0,1,0,1,1,0,0,0,0,0,0,0,1,1),(4087899,'SKODA','Octavia 1.9','Octavia 1.9 TDI Eleg. 4x4',200106,'manual','diesel','Sedan','silver',1,84500,19900,101,5,5,1896,4,35240,36530,1,1,1,0,1,0,0,0,1,1,0,1,0,1,0,1,0,1,0,1,1),(4088037,'VOLVO','S40 2.0','S40 2.0T',200009,'manual','gasoline','Limousine','white',0,95000,13900,163,5,4,1948,4,35700,35700,1,1,0,0,1,0,1,0,1,0,0,1,0,1,0,0,0,1,0,1,0),(4088580,'FORD','Mondeo 2.5','Mondeo 2.5i V6 Carving',200406,'automatic','gasoline','Sedan','silver',0,43632,29500,170,5,5,2495,6,39800,44790,1,1,0,1,1,0,0,0,1,1,1,1,0,1,0,0,1,1,0,1,1),(4089537,'CHRYSLER','Neon 2.0','Neon 2.0 LX',199704,'manual','gasoline','Limousine','silver',0,86000,6400,148,5,4,1996,4,25500,25900,1,1,1,0,1,0,0,0,1,0,1,1,0,0,0,0,0,0,0,1,1),(4089551,'CHRYSLER','Le Baron 2.2','Le Baron 2.2 Turbo',198809,'automatic','gasoline','Cabrio','red',0,79000,6800,148,4,2,2212,4,30600,33300,0,0,0,0,1,1,1,0,1,0,0,1,0,0,0,0,1,0,0,1,0),(4089558,'CHRYSLER','Voyager 3.3','Voyager 3.3 LX',199606,'automatic','gasoline','Sedan','black',0,202000,6900,158,7,5,3301,6,58200,58600,1,1,1,1,1,1,1,0,1,1,1,1,0,0,0,0,1,1,0,1,1),(4092966,'VW','Touareg 3.2','Touareg 3.2 V6',200412,'automatic','gasoline','Sedan','black',0,8500,65450,241,5,5,3189,6,68730,79340,1,1,1,1,1,1,1,1,1,1,1,1,0,1,0,1,1,1,0,1,1),(4095373,'MERCEDES-BENZ','SLK 230','SLK 230 Kompressor',199905,'automatic','gasoline','Cabrio','black',0,57700,28900,193,2,2,2295,4,57350,68403,1,1,0,1,1,0,1,0,1,1,0,1,1,1,1,1,1,1,0,1,0),(4096400,'OPEL','Vectra 2.0','Vectra 2.0 T Design Ed.',200505,'manual','gasoline','Limousine','silver',0,14000,29850,175,5,4,1998,4,37950,42110,1,1,0,1,1,0,0,0,1,1,1,1,0,0,0,1,1,1,1,1,1),(4097322,'BMW','525','525iX 24V',199203,'manual','gasoline','Limousine','green',0,191000,3800,192,5,4,2493,6,56900,56900,0,1,0,0,1,0,0,0,0,1,0,1,0,0,0,0,0,0,0,1,0),(4097456,'BMW','325','325i Cabrio',198707,'manual','gasoline','Cabrio','red',0,197000,7800,170,4,2,2494,6,52100,54370,0,1,0,0,1,0,1,0,0,1,0,0,0,0,0,0,0,0,0,0,0),(4097641,'BMW','320','320i',200010,'manual','gasoline','Limousine','blue',0,62000,22700,170,5,4,2171,6,47700,49330,1,1,1,0,1,0,0,0,1,1,1,1,0,0,0,1,0,1,0,1,1),(4097661,'BMW','316','316 ti Compact',200206,'automatic','gasoline','Limousine','silver',1,35000,25800,116,5,3,1796,4,33700,33700,1,1,1,1,1,0,0,0,1,0,1,1,0,1,1,1,0,1,0,1,1),(4097996,'BMW','730','730d',200505,'automatic','diesel','Limousine','blue',0,7000,96800,231,5,4,2993,6,94800,94800,1,1,1,1,1,1,1,1,1,1,1,1,0,1,0,1,1,1,1,1,1),(4102840,'VW','Passat 2.0','Passat 2.0 High',200208,'manual','gasoline','Limousine','grey',0,123000,16950,131,5,4,1984,4,37820,46890,1,1,0,1,1,0,1,1,1,1,1,1,0,1,0,1,0,1,0,1,1),(4103797,'OPEL','Astra 1.8','Astra 1.8i 16V Comfort',199904,'manual','gasoline','Limousine','red',0,76500,10500,116,5,5,1796,4,28100,28100,1,1,0,0,1,0,0,0,1,1,1,1,0,0,0,1,0,1,0,1,0),(4104155,'OPEL','Astra 2.0','Astra 2.0i Turbo Sport',200409,'manual','gasoline','Limousine','silver',0,11500,31690,200,5,5,1998,4,32950,37420,1,1,0,1,1,0,0,0,1,1,0,1,0,0,1,1,1,1,1,1,1),(4104181,'OPEL','Vectra 2.2','Vectra 2.2 Design Edition',200503,'automatic','gasoline','Limousine','silver',0,13500,31850,155,5,5,2198,4,36050,39370,1,1,0,1,1,0,0,0,1,1,1,1,0,0,0,1,1,1,0,1,1),(4105146,'VW','Golf 1.4','Golf 1.4 Comfortline',200307,'manual','gasoline','Limousine','grey',0,38400,15900,75,5,5,1390,4,26540,29570,1,1,1,1,1,0,0,0,1,1,1,1,0,0,0,1,0,1,0,1,1),(4105256,'VW','Golf 1.8','Golf 1.8 T GTI',200003,'manual','gasoline','Limousine','red',0,123770,16500,150,5,5,1781,4,38410,39890,1,1,1,0,1,0,0,0,1,1,0,1,1,0,1,0,0,1,0,1,0),(4106389,'SMART','Pure','pure +',200203,'automatic','gasoline','Limousine','yellow',0,34000,8900,54,2,3,599,3,14380,18012,1,1,0,1,1,0,0,0,1,0,1,0,0,0,0,1,0,1,0,1,0),(4106888,'OPEL','Zafira 2.2','Zafira 2.2i 16V Elegance',200307,'manual','gasoline','Sedan','silver',0,58700,20800,147,7,5,2198,4,34300,34820,1,1,0,1,1,0,0,0,1,1,1,1,0,0,0,1,1,1,0,1,1),(4106982,'OPEL','Astra 1.8','Astra 1.8i 16V Edition',200305,'manual','gasoline','Coupe','blue',0,11000,21400,125,5,2,1796,4,32100,32650,1,1,0,1,1,0,0,0,0,1,1,1,0,0,0,1,0,1,0,1,1),(4109572,'VW','Passat 1.8','Passat 1.8 T Trend',200203,'manual','gasoline','Limousine','silver',1,66200,20500,150,5,4,1781,4,41890,41890,1,1,0,0,1,0,0,0,1,0,1,1,0,0,0,1,0,1,0,1,0),(4109637,'VW','Polo 1.4','Polo 1.4 16V High',200312,'manual','gasoline','Limousine','silver',0,42000,20900,101,5,5,1390,4,23300,26520,1,1,1,0,1,0,1,0,1,0,1,1,1,1,0,1,0,1,0,1,1),(4112188,'HYUNDAI','Accent 1.6','Accent 1.6 GLS',200510,'manual','gasoline','Limousine','light blue',0,1200,17900,105,5,5,1599,4,19690,21640,1,1,1,1,1,0,0,0,1,1,1,1,0,0,0,0,0,1,0,1,0),(4112395,'BMW','330','330i',200311,'automatic','gasoline','Limousine','grey',1,47000,35900,231,5,4,2979,6,56800,56800,1,1,1,1,1,0,1,0,1,1,1,1,0,1,0,1,0,1,0,1,1),(4112469,'BMW','118','118i',200512,'manual','gasoline','Limousine','silver',1,0,40900,129,5,5,1995,4,34200,34200,1,1,1,1,1,0,0,0,1,0,1,1,0,0,0,1,0,1,0,1,1),(4113216,'PEUGEOT','406 2.0','406 Break ColorEd.2.0 16V',199809,'manual','gasoline','Sedan','green',0,121000,9600,132,5,5,1998,4,38150,38150,1,1,0,0,1,0,1,0,1,1,1,1,0,1,0,0,0,1,0,1,1),(4114917,'MITSUBISHI','Space Wagon 2.4','Space W 2.4 GLX Elegance',200308,'automatic','gasoline','Sedan','silver',0,90600,20800,147,7,5,2351,4,41990,45630,1,1,0,0,1,0,0,1,1,0,1,1,0,0,0,0,1,1,0,1,1),(4115703,'OPEL','Sintra 2.2','Sintra 2.2i 16V GLS',199707,'manual','gasoline','Sedan','blue',0,125300,10500,141,5,5,2198,4,39950,39950,1,1,0,0,1,0,0,0,1,0,1,1,0,0,0,0,0,1,0,1,0),(4115792,'OPEL','Astra 2.0','Astra 2.0i 16V Sport STec',199612,'manual','gasoline','Sedan','white',0,64000,10900,136,5,5,1998,4,29075,30050,1,1,0,1,1,0,0,0,1,1,1,1,0,0,0,0,0,1,0,1,0),(4126586,'ALFA ROMEO','147 2.0','147 2.0 16V Distinctive',200503,'manual','gasoline','Limousine','black',0,10500,29500,150,5,5,1970,4,32300,33820,1,1,0,1,1,0,0,0,1,1,1,1,0,0,0,1,1,1,0,1,0),(4126595,'ALFA ROMEO','166 3.2 V6','166 3.2 V6 TI',200312,'manual','gasoline','Limousine','black',0,17000,38500,239,5,4,3179,6,66600,68140,1,1,1,1,1,1,1,1,1,1,1,1,0,1,1,1,1,1,1,1,0),(4126762,'VOLVO','V70 2.4','V70 2.4T AWD',200103,'automatic','gasoline','Sedan','beige',0,150000,24500,200,5,5,2435,5,56500,76180,1,1,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,1,1),(4127023,'TOYOTA','Corolla 1.6','Corolla 1.6 Linea Sol',200206,'manual','gasoline','Sedan','white',0,71000,16600,110,5,5,1598,4,30200,30200,1,1,0,1,1,0,0,0,1,1,1,1,0,0,0,0,0,1,0,1,0),(4127589,'OPEL','Frontera 3.2','Frontera 3.2i V6 Limited',200012,'automatic','gasoline','Sedan','silver',0,66000,18600,205,5,5,3165,6,48600,53500,1,1,0,1,1,0,1,0,1,1,1,1,0,1,0,0,1,1,0,1,1),(4127662,'OPEL','Astra 1.8','Astra 1.8i 16V Comfort',200203,'manual','gasoline','Sedan','blue',1,38100,18900,125,5,5,1796,4,28150,30830,1,1,0,1,1,0,0,0,1,1,1,1,0,0,0,1,1,1,0,1,1),(4128547,'RENAULT','Modus 1.2','Modus 1.2 16V Alizé',200510,'manual','gasoline','Sedan','black',0,50,18900,75,5,5,1149,4,19750,20250,1,1,0,0,1,0,0,0,1,0,1,1,0,0,0,0,0,1,0,1,1),(4128715,'AUDI','A4 1.8','A4 1.8 T quattro Ambiente',199901,'manual','gasoline','Limousine','red',0,161000,14900,180,5,4,1781,4,46080,55645,1,1,1,1,1,0,0,1,1,1,0,1,0,1,1,0,1,1,0,1,0),(4128887,'AUDI','A6 4.2','A6 Avant 4.2 q.Ambition',200005,'automatic','gasoline','Sedan','black',0,107000,32900,299,5,5,4172,8,92650,101555,1,1,1,1,1,1,1,1,1,1,1,1,0,1,0,1,0,1,1,1,0),(4129095,'AUDI','A6 3.2','A6 Avant 3.2 V6 FSI quatt',200505,'automatic','gasoline','Sedan','silver',0,11100,75900,256,5,5,3123,6,71500,98140,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,1,1,1,1,1,1),(4130630,'VW','Lupo 75','Lupo 75 Trendline ABS',200008,'manual','gasoline','Limousine','black',0,96000,9250,75,4,3,1390,4,20170,22110,1,1,0,0,1,0,0,0,1,0,1,1,0,0,0,0,0,1,0,1,0),(4131593,'HYUNDAI','Santamo','Santamo 2.0 16V GLX 4x4',200007,'manual','gasoline','Sedan','blue',0,105500,10900,139,7,5,1997,4,25990,25990,1,1,0,0,1,0,0,0,1,0,1,1,0,0,0,0,0,1,0,1,0),(4131835,'BMW','330','330i',200306,'automatic','gasoline','Limousine','black',0,42000,39900,231,5,4,2979,6,56800,56800,1,1,1,1,1,0,1,0,1,1,1,1,0,1,0,1,0,1,0,1,0),(4131984,'BMW','530','530i',200301,'manual','gasoline','Limousine','silver',1,42500,51700,231,5,4,2979,6,62900,70470,1,1,0,0,1,0,1,0,1,1,1,1,0,1,0,1,0,1,0,1,1),(4132127,'BMW','M3','M3 Cabrio',199704,'manual','gasoline','Cabrio','yellow',0,113400,27800,321,4,2,3201,6,94500,103580,1,1,1,0,1,1,1,0,1,1,1,1,0,1,1,0,1,1,0,1,0),(4134142,'OPEL','Astra 1.8','Astra 1.8i 16V Perfection',199706,'manual','gasoline','Cabrio','blue',0,95000,8500,116,4,2,1799,4,35150,35580,1,1,1,1,1,0,0,0,1,1,1,1,0,0,0,0,0,1,0,1,0);


CREATE INDEX index_car_car5_sMarke_asc ON car_car5 (sMarke ASC);
CREATE INDEX index_car_car5_sMarke_desc ON car_car5 (sMarke DESC);
CREATE INDEX index_car_car5_sModell_asc ON car_car5 (sModell ASC);
CREATE INDEX index_car_car5_sModell_desc ON car_car5 (sModell DESC);
CREATE INDEX index_car_car5_sTyp_asc ON car_car5 (sTyp ASC);
CREATE INDEX index_car_car5_sTyp_desc ON car_car5 (sTyp DESC);
CREATE INDEX index_car_car5_iInverkehrsetzung_asc ON car_car5 (iInverkehrsetzung ASC);
CREATE INDEX index_car_car5_iInverkehrsetzung_desc ON car_car5 (iInverkehrsetzung DESC);
CREATE INDEX index_car_car5_iGetriebeart_asc ON car_car5 (iGetriebeart ASC);
CREATE INDEX index_car_car5_iGetriebeart_desc ON car_car5 (iGetriebeart DESC);
CREATE INDEX index_car_car5_iTreibstoffart_asc ON car_car5 (iTreibstoffart ASC);
CREATE INDEX index_car_car5_iTreibstoffart_desc ON car_car5 (iTreibstoffart DESC);
CREATE INDEX index_car_car5_iAufbau_asc ON car_car5 (iAufbau ASC);
CREATE INDEX index_car_car5_iAufbau_desc ON car_car5 (iAufbau DESC);
CREATE INDEX index_car_car5_iAussenfarbe_asc ON car_car5 (iAussenfarbe ASC);
CREATE INDEX index_car_car5_iAussenfarbe_desc ON car_car5 (iAussenfarbe DESC);
CREATE INDEX index_car_car5_iAussenfarbeMetallic_asc ON car_car5 (iAussenfarbeMetallic ASC);
CREATE INDEX index_car_car5_iAussenfarbeMetallic_desc ON car_car5 (iAussenfarbeMetallic DESC);
CREATE INDEX index_car_car5_iKilometer_asc ON car_car5 (iKilometer ASC);
CREATE INDEX index_car_car5_iKilometer_desc ON car_car5 (iKilometer DESC);
CREATE INDEX index_car_car5_iPreisVerkauf_asc ON car_car5 (iPreisVerkauf ASC);
CREATE INDEX index_car_car5_iPreisVerkauf_desc ON car_car5 (iPreisVerkauf DESC);
CREATE INDEX index_car_car5_iLeistungPS_asc ON car_car5 (iLeistungPS ASC);
CREATE INDEX index_car_car5_iLeistungPS_desc ON car_car5 (iLeistungPS DESC);
CREATE INDEX index_car_car5_iSitzplaetze_asc ON car_car5 (iSitzplaetze ASC);
CREATE INDEX index_car_car5_iSitzplaetze_desc ON car_car5 (iSitzplaetze DESC);
CREATE INDEX index_car_car5_iTueren_asc ON car_car5 (iTueren ASC);
CREATE INDEX index_car_car5_iTueren_desc ON car_car5 (iTueren DESC);
CREATE INDEX index_car_car5_iHubraum_asc ON car_car5 (iHubraum ASC);
CREATE INDEX index_car_car5_iHubraum_desc ON car_car5 (iHubraum DESC);
CREATE INDEX index_car_car5_iZylinder_asc ON car_car5 (iZylinder ASC);
CREATE INDEX index_car_car5_iZylinder_desc ON car_car5 (iZylinder DESC);
CREATE INDEX index_car_car5_iEurotax_Neupreis_asc ON car_car5 (iEurotax_Neupreis ASC);
CREATE INDEX index_car_car5_iEurotax_Neupreis_desc ON car_car5 (iEurotax_Neupreis DESC);
CREATE INDEX index_car_car5_iPreisTotal_asc ON car_car5 (iPreisTotal ASC);
CREATE INDEX index_car_car5_iPreisTotal_desc ON car_car5 (iPreisTotal DESC);
CREATE INDEX index_car_car5_iRawOptionHatAirbag_asc ON car_car5 (iRawOptionHatAirbag ASC);
CREATE INDEX index_car_car5_iRawOptionHatAirbag_desc ON car_car5 (iRawOptionHatAirbag DESC);
CREATE INDEX index_car_car5_iRawOptionHatABS_asc ON car_car5 (iRawOptionHatABS ASC);
CREATE INDEX index_car_car5_iRawOptionHatABS_desc ON car_car5 (iRawOptionHatABS DESC);
CREATE INDEX index_car_car5_iRawOptionHatAlarm_asc ON car_car5 (iRawOptionHatAlarm ASC);
CREATE INDEX index_car_car5_iRawOptionHatAlarm_desc ON car_car5 (iRawOptionHatAlarm DESC);
CREATE INDEX index_car_car5_iRawOptionHatCD_asc ON car_car5 (iRawOptionHatCD ASC);
CREATE INDEX index_car_car5_iRawOptionHatCD_desc ON car_car5 (iRawOptionHatCD DESC);
CREATE INDEX index_car_car5_iRawOptionHatElektrischeFenster_asc ON car_car5 (iRawOptionHatElektrischeFenster ASC);
CREATE INDEX index_car_car5_iRawOptionHatElektrischeFenster_desc ON car_car5 (iRawOptionHatElektrischeFenster DESC);
CREATE INDEX index_car_car5_iRawOptionHatElektrischeSitze_asc ON car_car5 (iRawOptionHatElektrischeSitze ASC);
CREATE INDEX index_car_car5_iRawOptionHatElektrischeSitze_desc ON car_car5 (iRawOptionHatElektrischeSitze DESC);
CREATE INDEX index_car_car5_iRawOptionHatLeder_asc ON car_car5 (iRawOptionHatLeder ASC);
CREATE INDEX index_car_car5_iRawOptionHatLeder_desc ON car_car5 (iRawOptionHatLeder DESC);
CREATE INDEX index_car_car5_iRawOptionHatNavigationssystem_asc ON car_car5 (iRawOptionHatNavigationssystem ASC);
CREATE INDEX index_car_car5_iRawOptionHatNavigationssystem_desc ON car_car5 (iRawOptionHatNavigationssystem DESC);
CREATE INDEX index_car_car5_iRawOptionHatKlimaanlage_asc ON car_car5 (iRawOptionHatKlimaanlage ASC);
CREATE INDEX index_car_car5_iRawOptionHatKlimaanlage_desc ON car_car5 (iRawOptionHatKlimaanlage DESC);
CREATE INDEX index_car_car5_iRawOptionHatNebellampen_asc ON car_car5 (iRawOptionHatNebellampen ASC);
CREATE INDEX index_car_car5_iRawOptionHatNebellampen_desc ON car_car5 (iRawOptionHatNebellampen DESC);
CREATE INDEX index_car_car5_iRawOptionHatRadioKassette_asc ON car_car5 (iRawOptionHatRadioKassette ASC);
CREATE INDEX index_car_car5_iRawOptionHatRadioKassette_desc ON car_car5 (iRawOptionHatRadioKassette DESC);
CREATE INDEX index_car_car5_iRawOptionHatServolenkung_asc ON car_car5 (iRawOptionHatServolenkung ASC);
CREATE INDEX index_car_car5_iRawOptionHatServolenkung_desc ON car_car5 (iRawOptionHatServolenkung DESC);
CREATE INDEX index_car_car5_iRawOptionHatSonnendach_asc ON car_car5 (iRawOptionHatSonnendach ASC);
CREATE INDEX index_car_car5_iRawOptionHatSonnendach_desc ON car_car5 (iRawOptionHatSonnendach DESC);
CREATE INDEX index_car_car5_iRawOptionHatSitzheizung_asc ON car_car5 (iRawOptionHatSitzheizung ASC);
CREATE INDEX index_car_car5_iRawOptionHatSitzheizung_desc ON car_car5 (iRawOptionHatSitzheizung DESC);
CREATE INDEX index_car_car5_iRawOptionHatSportfahrwerk_asc ON car_car5 (iRawOptionHatSportfahrwerk ASC);
CREATE INDEX index_car_car5_iRawOptionHatSportfahrwerk_desc ON car_car5 (iRawOptionHatSportfahrwerk DESC);
CREATE INDEX index_car_car5_iRawOptionHatTraktionskontrolle_asc ON car_car5 (iRawOptionHatTraktionskontrolle ASC);
CREATE INDEX index_car_car5_iRawOptionHatTraktionskontrolle_desc ON car_car5 (iRawOptionHatTraktionskontrolle DESC);
CREATE INDEX index_car_car5_iRawOptionHatTempomat_asc ON car_car5 (iRawOptionHatTempomat ASC);
CREATE INDEX index_car_car5_iRawOptionHatTempomat_desc ON car_car5 (iRawOptionHatTempomat DESC);
CREATE INDEX index_car_car5_iRawOptionHatWegfahrsperre_asc ON car_car5 (iRawOptionHatWegfahrsperre ASC);
CREATE INDEX index_car_car5_iRawOptionHatWegfahrsperre_desc ON car_car5 (iRawOptionHatWegfahrsperre DESC);
CREATE INDEX index_car_car5_iRawOptionHatXenonlicher_asc ON car_car5 (iRawOptionHatXenonlicher ASC);
CREATE INDEX index_car_car5_iRawOptionHatXenonlicher_desc ON car_car5 (iRawOptionHatXenonlicher DESC);
CREATE INDEX index_car_car5_iRawOptionHatZentralverriegelung_asc ON car_car5 (iRawOptionHatZentralverriegelung ASC);
CREATE INDEX index_car_car5_iRawOptionHatZentralverriegelung_desc ON car_car5 (iRawOptionHatZentralverriegelung DESC);
CREATE INDEX index_car_car5_iRawOptionHatMetallicfarbe_asc ON car_car5 (iRawOptionHatMetallicfarbe ASC);
CREATE INDEX index_car_car5_iRawOptionHatMetallicfarbe_desc ON car_car5 (iRawOptionHatMetallicfarbe DESC);