DROP TABLE IF EXISTS `trims`;
CREATE TABLE `trims` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `body_type_id` bigint(20) unsigned NOT NULL,
  `trim_key` varchar(128) NOT NULL,
  `status` varchar(32) DEFAULT NULL,
  `trim_name` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_trim` (`body_type_id`,`trim_key`),
  CONSTRAINT `fk_trims_body` FOREIGN KEY (`body_type_id`) REFERENCES `body_types` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=598 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `trims` (`id`,`body_type_id`,`trim_key`,`status`,`trim_name`,`description`) VALUES
('1','1','Anniversario','Current','Anniversario',''),
('2','2','595_Grand_Prix_Edition','Current','595 Grand Prix Edition',''),
('3','2','595','Current','595',''),
('4','2','595_PREMIUM_Grand_Prix_Edition','Current','595 PREMIUM Grand Prix Edition',''),
('5','2','595_PREMIUM','Current','595 PREMIUM',''),
('6','2','695_TURISMO','Current','695 TURISMO',''),
('7','2','695_COMPETIZIONE','Current','695 COMPETIZIONE',''),
('8','3','EH0','Current','500e','500e'),
('9','3','EC0','Current','500e Cabrio','500e Cabrio'),
('10','3','EHT','Current','500e Turismo','500e Turismo'),
('11','3','ECT','Current','500e Turismo Cabrio ','500e Turismo Cabrio '),
('12','4','EH0','Current','500e','500e'),
('13','4','EC0','Current','500e Cabrio','500e Cabrio'),
('14','4','EHT','Current','500e Turismo','500e Turismo'),
('15','4','ECT','Current','500e Turismo Cabrio ','500e Turismo Cabrio '),
('16','5','EH0','Past','500e','500e'),
('17','5','EC0','Past','500e Cabrio','500e Cabrio'),
('18','5','EHT','Current','500e Turismo','500e Turismo'),
('19','5','ECT','Current','500e Turismo Cabrio ','500e Turismo Cabrio '),
('20','7','Turismo','Current','Turismo',''),
('21','7','Scorpionissima','Current','Competizione',''),
('22','6','Turismo','Current','Turismo',''),
('23','6','Scorpionissima','Current','Scorpionissima',''),
('24','8','CULT','Current','CULT',''),
('25','8','LOUNGE','Current','LOUNGE',''),
('26','8','COLLEZIONE_1957','Current','Limitierte Version COLLEZIONE 1957',''),
('27','9','POP','Current','POP','POP'),
('28','9','ICON','Current','ICON','ICON'),
('29','9','CROSS','Current','CROSS','CROSS'),
('30','10','POP','Current','POP',''),
('31','10','ICON','Current','ICON',''),
('32','10','RED','Current','RED',''),
('33','10','LA_PRIMA','Current','LA PRIMA',''),
('34','11','POP','Current','POP',''),
('35','11','ICON','Current','ICON',''),
('36','11','LA_PRIMA','Current','LA PRIMA',''),
('37','12','POP','Current','POP',''),
('38','12','ICON','Current','ICON',''),
('39','12','LA_PRIMA','Current','LA PRIMA',''),
('40','14','POP','Current','POP','POP'),
('41','14','ICON_500','Current','ICON','ICON'),
('42','14','TORINO','Current','TORINO','TORINO'),
('43','14','DOLCEVITA_500','Current','DOLCEVITA',''),
('44','14','LA_PRIMA_500','Current','LA PRIMA',''),
('45','13','CULT','Current','CULT',''),
('46','13','RED_SWISS_EDITION','Current','RED SWISS EDITION',''),
('47','13','LA_PRIMA','Current','LA PRIMA',''),
('48','13','ARMANI','Current','ARMANI','ARMANI'),
('49','15','ARMANI','Current','ARMANI',''),
('50','16','CULT','Current','CULT',''),
('51','16','RED_SWISS_EDITION','Current','RED SWISS EDITION',''),
('52','16','LA_PRIMA','Current','LA PRIMA',''),
('53','16','ARMANI','Current','ARMANI','ARMANI'),
('54','17','CULT','Current','CULT',''),
('55','17','RED_SWISS_EDITION','Current','RED SWISS EDITION',''),
('56','17','LA_PRIMA','Current','LA PRIMA',''),
('57','17','ARMANI','Current','ARMANI',''),
('58','18','SPORT_LOOK','Current','SPORT LOOK',''),
('59','19','Topolino','Current','Topolino','Topolino'),
('60','20','CULT','Current','URBAN LOOK / CULT',''),
('61','20','SWISS_EDITION_CROSS','Current','CROSS LOOK / SWISS EDITION CROSS',''),
('62','21','CULT','Current','URBAN LOOK / CULT',''),
('63','21','SWISS_EDITION_CROSS','Current','CROSS LOOK / SWISS EDITION CROSS',''),
('64','22','E_DOBLO','Current','E-DOBLÒ',''),
('65','24','QuboL_POP','Current','POP','POP'),
('66','24','QuboL_ICON','Current','ICON','ICON'),
('67','24','QuboL_LA_PRIMA','Current','LA PRIMA','LA PRIMA'),
('68','23','E_DOBLO','Current','E-DOBLÒ',''),
('69','25','E_DOBLO','Current','E-DOBLÒ',''),
('70','27','QuboL_POP','Current','POP','POP'),
('71','27','QuboL_ICON','Current','ICON','ICON'),
('72','27','QuboL_LA_PRIMA','Current','LA PRIMA','LA PRIMA'),
('73','26','E_DOBLO','Current','E-DOBLÒ',''),
('74','28','600_CULT','Current','600 CULT',''),
('75','28','600_SWISS_EDITION','Current','600 SWISS EDITION','600 SWISS EDITION'),
('76','28','RED','Current','RED',''),
('77','28','LA_PRIMA','Current','LA PRIMA',''),
('78','29','600_POP','Current','POP',''),
('79','29','600_SWISS_EDITION','Current','ICON SWISS EDITION',''),
('80','29','LA_PRIMA','Current','LA PRIMA',''),
('81','29','600_SPORT','Current','SPORT',''),
('82','30','POP','Current','POP','POP'),
('83','30','ICON','Current','ICON','ICON'),
('84','30','CROSS','Current','CROSS','CROSS'),
('85','31','POP','Current','POP','POP'),
('86','31','ICON','Current','ICON','ICON'),
('87','31','CROSS','Current','CROSS','CROSS'),
('88','32','POP','Current','POP','POP'),
('89','32','LA_PRIMA','Current','LA PRIMA','LA PRIMA'),
('90','34','eDucato_VAN_L4H2_3.5_T_Verglast','Current','L4H2 | 3.5 t | verglast','eDucato VAN L4H2 3.5 t - verglast'),
('91','34','eDucato_VAN_L3H2_4.25_T_TV','Current','L3H2 | 4.25 t | t-verglast',' eDucato VAN L3H2 4.25 t - teilverglast'),
('92','34','eDucato_VAN_L3H2_4.25_T_Verglast','Current','L3H2 | 4.25 t | verglast','eDucato VAN L3H2 4.25 t - verglast'),
('93','34','eDucato_VAN_L4H2_4.25_T_Verglast','Current','L4H2 | 4.25-t | verglast','eDucato VAN L4H2 4.25 t - verglast'),
('94','33','eDucato_VAN_L3H2_3.5_T','Draft','L3H2 | 3.5 t','eDucato VAN L3H2 - 3.5 t'),
('95','33','eDucato_VAN_L3H3_3.5_T','Draft','L3H3 | 3.5 t','eDucato VAN L3H3 3.5 t'),
('96','33','eDucato_VAN_L3H2_4.25_T','Draft','L3H2 | 4.25 t','eDucato VAN L3H2 4.25 t'),
('97','33','eDucato_VAN_L3H3_4.25_T','Draft','L3H3 | 4.25 t','eDucato VAN L3H3 4.25 t'),
('98','33','eDucato_VAN_L4H2_3.5_T','Draft','L4H2 | 3.5 t','eDucato VAN L4H2 3.5 t'),
('99','33','eDucato_VAN_L4H3_3.5_T','Draft','L4H3 | 3.5 t','eDucato VAN L4H3 3.5 t'),
('100','33','eDucato_VAN_L4H2_4.25_T','Draft','L4H2 | 4.25 t','eDucato VAN L4H2 4.25 t'),
('101','33','eDucato_VAN_L4H3_4.25_T','Draft','L4H3 | 4.25 t','eDucato VAN L4H3 4.25 t'),
('102','33','eDucato_VAN_L3H2_3.5_T_TV','Draft','L3H2 | 3.5 t | t-verglast','eDucato VAN L3H2 3.5 t - teilverglast'),
('103','33','eDucato_VAN_L3H2_3.5_T_Verglast','Draft','L3H2 | 3.5 t | verglast','eDucato VAN L3H2 3.5 t - verglast'),
('104','33','eDucato_VAN_L4H2_3.5_T_Verglast','Draft','L4H2 | 3.5 t | verglast','eDucato VAN L4H2 3.5 t - verglast'),
('105','33','eDucato_VAN_L3H2_4.25_T_TV','Draft','L3H2 | 4.25 t | t-verglast',' eDucato VAN L3H2 4.25 t - teilverglast'),
('106','33','eDucato_VAN_L3H2_4.25_T_Verglast','Draft','L3H2 | 4.25 t | verglast','eDucato VAN L3H2 4.25 t - verglast'),
('107','33','eDucato_VAN_L4H2_4.25_T_Verglast','Draft','L4H2 | 4.25-t | verglast','eDucato VAN L4H2 4.25 t - verglast'),
('108','33','VAN','Current','VAN','VAN'),
('109','35','290_Ducato_VAN_L2H1_3_T','Draft','290 Ducato VAN L2H1 3T','290 Ducato VAN L2H1 3T'),
('110','35','290_Ducato_VAN_L2H2_3_T','Draft','290 Ducato VAN L2H2 3 T','290 Ducato VAN L2H2 3 T'),
('111','35','290_Ducato_VAN_L2H1_3.3_T','Draft','290 Ducato VAN L2H1 3.3 T','290 Ducato VAN L2H1 3.3 T'),
('112','35','290_Ducato_VAN_L2H2_3.3_T','Draft','290 Ducato VAN L2H2 3.3 T','290 Ducato VAN L2H2 3.3 T'),
('113','35','290_Ducato_VAN_L3H1_3.3_T','Draft','290 Ducato VAN L3H1 3.3 T','290 Ducato VAN L3H1 3.3 T'),
('114','35','290_Ducato_VAN_L3H2_3.3_T','Draft','290 Ducato VAN L3H2 3.3 T','290 Ducato VAN L3H2 3.3 T'),
('115','35','290_Ducato_VAN_L2H1_3.5_T','Draft','290 Ducato VAN L2H1 3.5 T','290 Ducato VAN L2H1 3.5 T'),
('116','35','290_Ducato_VAN_L2H2_3.5_T','Draft','290 Ducato VAN L2H2 3.5 T','290 Ducato VAN L2H2 3.5 T'),
('117','35','290_Ducato_VAN_L3H1_3.5_T','Draft','290 Ducato VAN L3H1 3.5 T','290 Ducato VAN L3H1 3.5 T'),
('118','35','290_Ducato_VAN_L3H2_3.5_T','Draft','290 Ducato VAN L3H2 3.5 T','290 Ducato VAN L3H2 3.5 T'),
('119','35','290_Ducato_VAN_L3H3_3.5_T','Draft','290 Ducato VAN L3H3 3.5 T','290 Ducato VAN L3H3 3.5 T'),
('120','35','290_Ducato_VAN_L2H2_3.5_T_TV','Draft','290 Ducato VAN L2H2 3.5 T - Teilverglast','290 Ducato VAN L2H2 3.5 T - Teilverglast'),
('121','35','295_Ducato_VAN_L3H2_3.5_T_TV','Draft','295 Ducato VAN L3H2 3.5 T - Teilverglast','295 Ducato VAN L3H2 3.5 T - Teilverglast'),
('122','35','295_Ducato_VAN_L2H2_3.5_T','Draft',' 295 Ducato VAN L2H2 3.5 T',' 295 Ducato VAN L2H2 3.5 T'),
('123','35','295_Ducato_VAN_L3H2_3.5_T','Draft',' 295 Ducato VAN L3H2 3.5 T',' 295 Ducato VAN L3H2 3.5 T'),
('124','35','295_Ducato_VAN_L3H3_3.5_T','Draft','295 Ducato VAN L3H3 3.5 T','295 Ducato VAN L3H3 3.5 T'),
('125','35','295_Ducato_VAN_L4H2_3.5_T','Draft','295 Ducato VAN L4H2 3.5 T','295 Ducato VAN L4H2 3.5 T'),
('126','35','295_Ducato_VAN_L4H3_3.5_T','Draft','295 Ducato VAN L4H3 3.5 T','295 Ducato VAN L4H3 3.5 T'),
('127','36','Pica','Current','Pica®',''),
('128','36','Origo','Current','Origo®',''),
('129','36','Amplia','Current','Amplia®',''),
('130','36','Vertex','Current','Vertex®',''),
('131','37','Pica','Current','Pica®',''),
('132','37','Origo','Current','Origo®',''),
('133','37','Amplia','Current','Amplia®',''),
('134','37','Vertex','Current','Vertex®',''),
('135','37','Vertex_Cross','Current','Vertex® Cross',''),
('136','38','Pica','Current','Pica®',''),
('137','38','Origo','Current','Origo®',''),
('138','38','Amplia','Current','Amplia®',''),
('139','38','Vertex','Current','Vertex®',''),
('140','38','Vertex_Cross','Current','Vertex® Cross',''),
('141','40','G029','Current','Amplia®','Amplia®'),
('142','40','G079','Current','Vertex®','Vertex®'),
('143','39','Amplia','Current','Amplia®',''),
('144','39','Vertex','Current','Vertex®',''),
('145','41','H214','Current','Launch Edition','Launch Edition'),
('146','43','Launch_Edition','Current','Launch Edition',''),
('147','45','N','Current','N','N'),
('148','44','Amplia','Current','Amplia®',''),
('149','44','Vertex','Current','Vertex®',''),
('150','44','NLine','Current','N Line',''),
('151','47','N','Current','N','N'),
('152','46','Amplia','Current','Amplia®',''),
('153','46','Vertex','Current','Vertex®',''),
('154','46','NLine','Current','N Line',''),
('155','48','Low','Current','Pica®','Pica®'),
('156','48','Mid','Current','Origo®','Origo®'),
('157','48','Mid_Plus','Current','Amplia®','Amplia®'),
('158','48','Top','Current','Vertex®','Vertex®'),
('159','48','NLine','Current','N Line','N Line'),
('160','49','D0XC','Current','Origo®','Origo®'),
('161','49','Amplia_G4','Current','Amplia®','Amplia®'),
('162','49','Vertex_G4','Current','Vertex®','Vertex®'),
('163','49','N_Line_G4','Current','N Line','N Line'),
('164','50','Amplia_G4','Current','Amplia®','Amplia®'),
('165','50','Vertex_G4','Current','Vertex®','Vertex®'),
('166','50','N_Line_G4','Current','N Line','N Line'),
('167','51','D0XC','Current','Origo®','Origo®'),
('168','51','Amplia_G4','Current','Amplia®','Amplia®'),
('169','51','Vertex_G4','Current','Vertex®','Vertex®'),
('170','51','N_Line_G4','Current','N Line','N Line'),
('171','52','D0XC','Current','Origo®','Origo®'),
('172','52','Amplia_G4','Current','Amplia®','Amplia®'),
('173','52','Vertex_G4','Current','Vertex®','Vertex®'),
('174','52','N_Line_G4','Current','N Line','N Line'),
('175','53','D0XC','Current','Origo®','Origo®'),
('176','53','Amplia_G4','Current','Amplia®','Amplia®'),
('177','53','Vertex_G4','Current','Vertex®','Vertex®'),
('178','53','N_Line_G4','Current','N Line','N Line'),
('179','54','D0XC','Current','Origo®','Origo®'),
('180','54','Amplia_G4','Current','Amplia®','Amplia®'),
('181','54','Vertex_G4','Current','Vertex®','Vertex®'),
('182','54','N_Line_G4','Current','N Line','N Line'),
('183','55','D0XC','Current','Origo®','Origo®'),
('184','55','Amplia_G4','Current','Amplia®','Amplia®'),
('185','55','Vertex_G4','Current','Vertex®','Vertex®'),
('186','55','N_Line_G4','Current','N Line','N Line'),
('187','56','N','Current','N',''),
('188','58','Origo','Current','Origo®',''),
('189','58','Amplia','Current','Amplia®',''),
('190','58','Vertex','Current','Vertex®',''),
('191','58','N_Line','Current','N Line',''),
('192','57','Origo','Current','Origo®',''),
('193','57','Amplia','Current','Amplia®',''),
('194','57','Vertex','Current','Vertex®',''),
('195','59','N','Current','N',''),
('196','60','Origo','Current','Origo®',''),
('197','60','Amplia','Current','Amplia®',''),
('198','60','Vertex','Current','Vertex®',''),
('199','60','N_Line','Current','N Line',''),
('200','61','N','Current','N',''),
('201','62','Origo','Current','Origo®',''),
('202','62','Amplia','Current','Amplia®',''),
('203','62','Vertex','Current','Vertex®',''),
('204','62','N_Line','Current','N Line',''),
('205','63','D005','Current','Pica®','Pica®'),
('206','63','G14R','Current','Origo®','Origo®'),
('207','63','G1FH','Current','Amplia®','Amplia®'),
('208','63','H786','Current','Vertex®','Vertex®'),
('209','63','M291','Current','N Line','N Line'),
('210','64','Origo','Current','Origo®',''),
('211','64','Amplia','Current','Amplia®',''),
('212','64','Vertex','Current','Vertex®',''),
('213','64','Calligraphy','Current','Calligraphy',''),
('214','65','Origo','Current','Origo®',''),
('215','65','Amplia','Current','Amplia®',''),
('216','65','Vertex','Current','Vertex®',''),
('217','65','Calligraphy','Current','Vertex® Calligraphy',''),
('218','65','Vertex_Swiss_Edition','Current','Vertex® Swiss Edition',''),
('219','65','Calligraphy_Swiss_Edition','Current','Vertex® Calligraphy Swiss Edition',''),
('220','66','Origo','Current','Origo®',''),
('221','66','Amplia','Current','Amplia®',''),
('222','66','Vertex','Current','Vertex®',''),
('223','66','Calligraphy','Current','Vertex® Calligraphy',''),
('224','66','Vertex_Swiss_Edition','Current','Vertex® Swiss Edition',''),
('225','66','Calligraphy_Swiss_Edition','Current','Vertex® Calligraphy Swiss Edition',''),
('226','69','GOVN---G0ZC','Current','Origo','Origo'),
('227','69','H988---H806','Current','Amplia','Amplia'),
('228','69','H989---H729','Current','Vertex','Vertex'),
('229','69','C339---C209','Current','N Line',''),
('230','68','G08J','Current','Origo','Origo'),
('231','68','H984','Current','Amplia','Amplia'),
('232','68','H892','Current','Vertex','Vertex'),
('233','68','C126','Current','N Line','N Line'),
('234','71','G08J','Current','Origo','Origo'),
('235','71','H984','Current','Amplia','Amplia'),
('236','71','H892','Current','Vertex','Vertex'),
('237','71','C126','Current','N Line','N Line'),
('238','70','Ausstattung_1','Draft','Ausstattung_1',''),
('239','67','GOVN---G0ZC','Current','Origo®','Origo®'),
('240','67','H988---H806','Current','Amplia®','Amplia®'),
('241','67','H989---H729','Current','Vertex®','Vertex®'),
('242','67','C339---C209','Current','N Line','N Line'),
('243','73','GOVN---G0ZC','Current','Origo®','Origo®'),
('244','73','H988---H806','Current','Amplia®','Amplia®'),
('245','73','H989---H729','Current','Vertex®','Vertex®'),
('246','73','C339---C209','Current','N Line',''),
('247','73','Swiss_Edition','Current','Vertex® Swiss Edition',''),
('248','72','G08J','Current','Origo®','Origo®'),
('249','72','H984','Current','Amplia®','Amplia®'),
('250','72','H892','Current','Vertex®','Vertex®'),
('251','72','C126','Current','N Line','N Line'),
('252','75','GOVN---G0ZC','Current','Origo®','Origo®'),
('253','75','H988---H806','Current','Amplia®','Amplia®'),
('254','75','H989---H729','Current','Vertex®','Vertex®'),
('255','75','C339---C209','Current','N Line',''),
('256','75','Swiss_Edition','Current','Vertex® Swiss Edition',''),
('257','74','G08J','Current','Origo®','Origo®'),
('258','74','H984','Current','Amplia®','Amplia®'),
('259','74','H892','Current','Vertex®','Vertex®'),
('260','74','C126','Current','N Line','N Line'),
('261','76','Amplia','Current','Amplia®','Amplia®'),
('262','76','Vertex','Current','Vertex®','Vertex®'),
('263','76','Vertex_Calligraphay','Current','Vertex® Calligraphy','Vertex Calligraphy'),
('264','77','Amplia','Current','Amplia®','Amplia®'),
('265','77','Vertex','Current','Vertex®','Vertex®'),
('266','77','Vertex_Calligraphay','Current','Vertex® Calligraphy','Vertex Calligraphy'),
('267','77','BlackInk','Current','Vertex® Calligraphy Black Ink','Vertex® Calligraphy Black Ink'),
('268','79','G029','Current','Amplia®','Amplia®'),
('269','79','G079','Current','Vertex®','Vertex®'),
('270','78','Amplia','Current','Amplia®',''),
('271','78','Vertex','Current','Vertex®',''),
('272','81','G029','Current','Amplia®','Amplia®'),
('273','81','G079','Current','Vertex®','Vertex®'),
('274','80','Amplia','Current','Amplia®',''),
('275','80','Vertex','Current','Vertex®',''),
('276','82','D0BU','Current','Pica®','Pica®'),
('277','82','G2Q0','Current','Origo®','Origo®'),
('278','82','G2Q3','Current','Amplia®','Amplia®'),
('279','82','H0WR','Current','Vertex®','Vertex®'),
('280','82','M291','Current','N Line','N Line'),
('281','83','D0BU','Current','Pica®','Pica®'),
('282','83','G2Q0','Current','Origo®','Origo®'),
('283','83','G2Q3','Current','Amplia®','Amplia®'),
('284','83','H0WR','Current','Vertex®','Vertex®'),
('285','83','M291','Archived','N Line','N Line'),
('286','84','D0BU','Current','Pica®','Pica®'),
('287','84','G2Q0','Current','Origo®','Origo®'),
('288','84','GO_Edition','Current','Amplia® GO!',''),
('289','84','G2Q3','Current','Amplia®','Amplia®'),
('290','84','H0WR','Current','Vertex®','Vertex®'),
('291','85','C005','Current','Pica®','Pica®'),
('292','85','F0UU','Current','Origo®','Origo®'),
('293','85','F0UV','Current','Amplia®','Amplia®'),
('294','85','M822','Current','Vertex®','Vertex®'),
('295','86','C005','Current','Pica®','Pica®'),
('296','86','F0UU','Current','Origo®','Origo®'),
('297','86','F0UV','Current','Amplia®','Amplia®'),
('298','86','M822','Current','Vertex®','Vertex®'),
('299','87','C005','Current','Pica®','Pica®'),
('300','87','F0UU','Current','Origo®','Origo®'),
('301','87','F0UV','Current','Amplia®','Amplia®'),
('302','87','M822','Current','Vertex®','Vertex®'),
('303','90','G1UM','Current','Origo®','Origo®'),
('304','90','K2FC','Current','Amplia®','Amplia'),
('305','90','B940','Current','N Line','N Line'),
('306','90','H1ZP','Current','Vertex®','Vertex'),
('307','90','C05X','Current','N Line LUX','N Line LUX'),
('308','90','20th_Anniversary','Current','20th Anniversary',''),
('309','90','swiss_edition','Current','Vertex Swiss Edition','Vertex Swiss Edition'),
('310','88','G1UM','Current','Origo','Origo'),
('311','88','K2FC','Current','Amplia','Amplia'),
('312','88','B940','Current','N Line','N Line'),
('313','88','H1ZP','Current','Vertex','Vertex'),
('314','88','C05X','Current','N Line LUX','N Line LUX'),
('315','89','G1UM','Current','Origo','Origo'),
('316','89','K2FC','Current','Amplia','Amplia'),
('317','89','B940','Current','N Line','N Line'),
('318','89','H1ZP','Current','Vertex','Vertex'),
('319','89','C05X','Current','N Line LUX','N Line LUX'),
('320','89','20th_Anniversary','Current','20th Anniversary',''),
('321','89','swiss_edition','Draft','SWISS ANNIVERSARY EDITION','SWISS ANNIVERSARY EDITION'),
('322','93','G1UM','Current','Origo®','Origo®'),
('323','93','K2FC','Current','Amplia®','Amplia'),
('324','93','H1ZP','Current','Vertex®','Vertex'),
('325','93','C05X','Current','N Line','N Line'),
('326','93','swiss_edition','Current','Vertex® Swiss Edition','Vertex® Swiss Edition'),
('327','91','G1UM','Current','Origo','Origo'),
('328','91','K2FC','Current','Amplia','Amplia'),
('329','91','B940','Current','N Line','N Line'),
('330','91','H1ZP','Current','Vertex','Vertex'),
('331','91','C05X','Current','N Line LUX','N Line LUX'),
('332','92','G1UM','Current','Origo','Origo'),
('333','92','K2FC','Current','Amplia','Amplia'),
('334','92','B940','Current','N Line','N Line'),
('335','92','H1ZP','Current','Vertex','Vertex'),
('336','92','C05X','Current','N Line LUX','N Line LUX'),
('337','92','20th_Anniversary','Current','20th Anniversary',''),
('338','92','swiss_edition','Draft','SWISS ANNIVERSARY EDITION','SWISS ANNIVERSARY EDITION'),
('339','94','G1UM','Current','Origo®','Origo®'),
('340','94','origo_black_edition','Current','Origo® Black Line','Origo® Black Line'),
('341','94','K2FC','Current','Amplia®','Amplia'),
('342','94','H1ZP','Current','Vertex®','Vertex'),
('343','94','C05X','Current','N Line','N Line'),
('344','94','swiss_edition','Current','Vertex® Swiss Edition','Vertex® Swiss Edition'),
('345','95','SWISS_ALTITUDE','Current','SWISS ALTITUDE',''),
('346','95','SUMMIT','Current','SUMMIT',''),
('347','95','OVERLAND_BLACK_KITE','Current','OVERLAND BLACK KITE',''),
('348','95','TRAILHAWK','Current','TRAILHAWK',''),
('349','95','NORTH_STAR','Current','NORTH STAR',''),
('350','96','ALTITUDE','Current','ALTITUDE',''),
('351','96','FIRST_EDITION','Current','FIRST EDITION',''),
('352','96','SUMMIT','Current','SUMMIT',''),
('353','99','LBK','Current','Longitude Black Kite','Longitude Black Kite'),
('354','99','LON','Current','Longitude','Longitude'),
('355','99','ALT','Current','Altitude','Altitude'),
('356','99','SUM','Current','Summit','Summit'),
('357','97','LON','Current','Longitude','Longitude'),
('358','97','ALT','Current','Altitude','Altitude'),
('359','97','SUM','Current','Summit','Summit'),
('360','97','ULA','Current','Upland','Upland'),
('361','97','OLA','Current','Overland','Overland'),
('362','97','TNS','Current','The North Face','The North Face'),
('363','98','LBK','Current','Longitude Black Kite','Longitude Black Kite'),
('364','98','LON','Current','Longitude','Longitude'),
('365','98','ALT','Current','Altitude','Altitude'),
('366','98','SUM','Current','Summit','Summit'),
('367','98','ULA','Current','Upland','Upland'),
('368','98','TNS','Current','The North Face','The North Face'),
('369','100','LBK','Current','Longitude Black Kite','Longitude Black Kite'),
('370','100','LON','Current','Longitude','Longitude'),
('371','100','ALT','Current','Altitude','Altitude'),
('372','100','SUM','Current','Summit','Summit'),
('373','100','ULA','Current','Upland','Upland'),
('374','100','TNS','Current','The North Face','The North Face'),
('375','101','LON','Current','Longitude','Longitude'),
('376','101','ALT','Current','Altitude','Altitude'),
('377','101','ABE','Current','Black Edition','Black Edition'),
('378','101','SUM','Current','Summit','Summit'),
('379','101','ULA','Current','Upland','Upland'),
('380','101','OLA','Current','Overland','Overland'),
('381','101','TNS','Current','The North Face','The North Face'),
('382','102','LON','Current','Longitude','Longitude'),
('383','102','ALT','Current','Altitude','Altitude'),
('384','102','85th','Current','85th Anniversary',''),
('385','102','SUM','Current','Summit','Summit'),
('386','102','ULA','Current','Upland','Upland'),
('387','102','OLA','Current','Overland','Overland'),
('388','103','BLACKLINE','Current','BLACKLINE',''),
('389','103','TITANIUM','Current','TITANIUM',''),
('390','104','STEEL','Current','STEEL','STEEL'),
('391','104','BLACKLINE','Current','BLACKLINE',''),
('392','104','TITANIUM','Current','TITANIUM',''),
('393','105','STEEL','Current','STEEL','STEEL'),
('394','105','BLACKLINE','Current','BLACKLINE',''),
('395','105','TITANIUM','Current','TITANIUM',''),
('396','106','PLATINUM','Current','PLATINUM',''),
('397','106','TITANIUM','Current','TITANIUM',''),
('398','107','PLATINUM','Current','PLATINUM',''),
('399','107','TITANIUM','Current','TITANIUM',''),
('400','107','BLACKEDITION','Current','BLACK EDITION','BLACK EDITION'),
('401','108','PLATINUM','Current','PLATINUM',''),
('402','108','TITANIUM','Current','TITANIUM',''),
('403','108','BLACKEDITION','Current','BLACK EDITION','BLACK EDITION'),
('404','109','FIRST_EDITION','Past','FIRST EDITION',''),
('405','109','PLA','Current','Platinum','Platinum'),
('406','109','TITA','Current','Titanium','Titanium'),
('407','110','FIRST_EDITION','Past','FIRST EDITION',''),
('408','110','PLA','Current','Platinum','Platinum'),
('409','110','TITA','Current','Titanium','Titanium'),
('410','111','PLA','Current','Platinum','Platinum'),
('411','111','TITA','Current','Titanium','Titanium'),
('412','112','BRONZE','Current','BRONZE',''),
('413','112','PLATINUM','Current','PLATINUM',''),
('414','112','TITANIUM','Current','BLACKLINE',''),
('415','113','BRONZE','Current','BRONZE',''),
('416','113','PLATINUM','Current','PLATINUM',''),
('417','113','TITANIUM','Current','BLACKLINE',''),
('418','114','PLATINUM','Current','PLATINUM',''),
('419','114','TITANIUM','Current','TITANIUM',''),
('420','114','BLACKLINE','Current','BLACKLINE',''),
('421','115','PLATINUM','Current','PLATINUM',''),
('422','115','TITANIUM','Current','TITANIUM',''),
('423','115','BLACKLINE','Past','BLACKLINE',''),
('424','116','BRONZE','Current','BRONZE',''),
('425','116','PLATINUM','Current','PLATINUM',''),
('426','116','TITANIUM','Current','TITANIUM',''),
('427','117','BRONZE','Current','BRONZE',''),
('428','117','PLATINUM','Current','PLATINUM',''),
('429','117','TITANIUM','Current','TITANIUM',''),
('430','118','BRONZE','Current','BRONZE',''),
('431','118','PLATINUM','Current','PLATINUM',''),
('432','118','TITANIUM','Current','TITANIUM',''),
('433','118','BlackEdition','Current','BLACK EDITION','BLACK EDITION'),
('434','119','BRONZE','Current','BRONZE',''),
('435','119','PLATINUM','Current','PLATINUM',''),
('436','119','TITANIUM','Current','TITANIUM',''),
('437','120','Steel','Current','STEEL',''),
('438','120','BRONZE','Current','BRONZE',''),
('439','120','PLATINUM','Current','PLATINUM',''),
('440','120','TITANIUM','Current','TITANIUM',''),
('441','121','Steel','Current','STEEL',''),
('442','121','BRONZE','Current','BRONZE',''),
('443','121','PLATINUM','Current','PLATINUM',''),
('444','121','TITANIUM','Current','TITANIUM',''),
('445','122','PLA','Current','Platinum','Platinum'),
('446','122','TIT','Current','Titanium','Titanium'),
('447','122','BLA','Current','Blackline','Blackline'),
('448','123','PLATINUM','Current','PLATINUM',''),
('449','123','TITANIUM','Current','TITANIUM',''),
('450','123','BLACKLINE','Current','BLACKLINE',''),
('451','124','PLATINUM','Current','PLATINUM',''),
('452','124','TITANIUM','Current','TITANIUM',''),
('453','124','BLACKLINE','Current','BLACKLINE',''),
('454','125','VAN_Comfort','Current','VAN Comfort','VAN Comfort'),
('455','125','VAN_Luxury','Current','VAN Luxury','VAN Luxury'),
('456','125','CC_Luxury','Current','CC Luxury','CC Luxury'),
('457','126','VAN_Luxury','Current','VAN Luxury','VAN Luxury'),
('458','126','CC_Luxury','Current','CC Luxury','CC Luxury'),
('459','127','VAN_DCiV','Current','VAN / DCiV',''),
('460','127','CC','Current','CC',''),
('461','128','VAN','Current','VAN',''),
('462','129','VAN','Current','VAN',''),
('463','130','VAN_FWD','Current','VAN FWD',''),
('464','130','VAN_AWD','Current','VAN AWD',''),
('465','132','LUXURY','Current','Luxury',''),
('466','133','LUXURY','Current','Luxury',''),
('467','133','PREMIUM','Current','Premium',''),
('468','134','VAN_FWD','Current','VAN_FWD',''),
('469','135','77_2WD_BLACK_ROOF','Current','2WD',''),
('470','135','77_2WD_RED_ROOF','Current','4WD',''),
('471','136','77_2WD_BLACK_ROOF','Current','2WD',''),
('472','136','77_2WD_RED_ROOF','Current','4WD',''),
('473','137','COMFORT_AT','Current','Comfort ',''),
('474','137','LUXURY_AT','Current','Luxury ',''),
('475','138','COMFORT_AT','Current','Comfort ',''),
('476','138','LUXURY_AT','Current','Luxury ',''),
('477','139','STANDARD','Current','Standard',''),
('478','139','LONG_RANGE','Current','Long Range',''),
('479','139','PERFORMANCE','Current','Performance',''),
('480','140','LONG_RANGE','Current','Long Range',''),
('481','140','PERFORMANCE','Current','Performance 20\"',''),
('482','140','LAUNCH_EDITION','Current','Performance 21\"',''),
('483','141','STANDARD','Current','Standard',''),
('484','141','COMFORT','Current','Comfort',''),
('485','141','LUXURY','Current','Luxury',''),
('486','142','STANDARD','Current','Standard',''),
('487','142','COMFORT','Current','Comfort',''),
('488','142','LUXURY','Current','Luxury',''),
('489','143','STANDARD','Current','Standard',''),
('490','143','COMFORT','Current','Comfort',''),
('491','143','LUXURY','Current','Luxury',''),
('492','144','Comfort','Current','Comfort',''),
('493','144','Premium','Current','Premium',''),
('494','145','LUXURY','Current','64 kWh Premium',''),
('495','145','TROPHY_LOG_RANGE','Current','77 kWh Premium',''),
('496','145','XPOWER_4WD','Current','64 kWh XPOWER 4WD',''),
('497','146','COMFORT','Current','Comfort',''),
('498','146','LUXURY','Current','Luxury',''),
('499','147','Luxury','Current','Luxury ',''),
('500','147','Luxury4WD','Draft','Luxury 4WD',''),
('501','148','Comfort','Current','Comfort',''),
('502','148','Premium','Current','Premium',''),
('503','149','STANDARD','Current','Standard',''),
('504','149','COMFORT','Current','Comfort',''),
('505','149','LUXURY','Current','Luxury',''),
('506','150','STANDARD','Current','Standard',''),
('507','150','COMFORT','Current','Comfort',''),
('508','150','LUXURY','Current','Luxury',''),
('509','151','STANDARD','Current','Standard',''),
('510','151','COMFORT','Current','Comfort',''),
('511','151','LUXURY','Current','Luxury',''),
('512','152','T-A---','Current','Acenta',''),
('513','152','UC_B-C','Current','N-Connecta',''),
('514','152','V-HC_C','Current','TEKNA',''),
('515','152','WCHCEE','Current','N-DESIGN',''),
('516','152','WCHCCG','Current','N-SPORT',''),
('517','153','ACENTA','Current','ACENTA',''),
('518','153','N-CONNECTA','Current','N-CONNECTA',''),
('519','153','TEKNA','Current','TEKNA',''),
('520','153','N-DESIGN','Current','N-DESIGN',''),
('521','153','N-SPORT','Current','N-SPORT',''),
('522','154','ACENTA','Current','ACENTA',''),
('523','154','N-CONNECTA','Current','N-CONNECTA',''),
('524','154','TEKNA','Current','TEKNA',''),
('525','154','N-DESIGN','Current','N-DESIGN',''),
('526','154','N-SPORT','Current','N-SPORT',''),
('527','155','ACENTA','Current','ACENTA',''),
('528','155','N-CONNECTA','Current','N-CONNECTA',''),
('529','155','TEKNA','Current','TEKNA',''),
('530','155','N-DESIGN','Current','N-DESIGN',''),
('531','155','N-SPORT','Current','N-SPORT',''),
('532','156','ACENTA','Current','ACENTA',''),
('533','156','N-CONNECTA','Current','N-CONNECTA',''),
('534','156','TEKNA','Current','TEKNA',''),
('535','156','N-DESIGN','Current','N-DESIGN',''),
('536','156','N-SPORT','Current','N-SPORT',''),
('537','157','ENGAGE','Current','ENGAGE',''),
('538','157','ADVANCE','Current','ADVANCE',''),
('539','157','EVOLVE','Current','EVOLVE',''),
('540','157','EVOLVE_400','Current','EVOLVE400',''),
('541','157','NISMO','Current','NISMO',''),
('542','162','ACENTA','Current','ACENTA',''),
('543','162','N-CONNECTA','Current','N-CONNECTA',''),
('544','162','TEKNA','Current','TEKNA',''),
('545','162','TEKNA_PLUS','Current','TEKNA+',''),
('546','162','N-DESIGN','Current','N-DESIGN',''),
('547','163','ACENTA','Current','ACENTA',''),
('548','163','N-CONNECTA','Current','N-CONNECTA',''),
('549','163','TEKNA','Current','TEKNA',''),
('550','163','TEKNA_PLUS','Current','TEKNA+',''),
('551','163','N-DESIGN','Current','N-DESIGN',''),
('552','164','ACENTA','Current','ACENTA',''),
('553','164','N-CONNECTA','Current','N-CONNECTA',''),
('554','164','TEKNA','Current','TEKNA',''),
('555','164','TEKNA_PLUS','Current','TEKNA+',''),
('556','164','N-DESIGN','Current','N-DESIGN',''),
('557','165','ACENTA','Current','ACENTA',''),
('558','165','N-CONNECTA','Current','N-CONNECTA',''),
('559','165','TEKNA','Current','TEKNA',''),
('560','165','TEKNA_PLUS','Current','TEKNA+',''),
('561','165','N-DESIGN','Current','N-DESIGN',''),
('562','166','ENGAGE','Current','ENGAGE',''),
('563','166','ADVANCE','Current','ADVANCE',''),
('564','166','EVOLVE','Current','EVOLVE',''),
('565','168','ENGAGE','Current','ENGAGE',''),
('566','168','ENGAGE_PLUS','Current','ENGAGE+','ENGAGE+'),
('567','168','ADVANCE','Current','ADVANCE',''),
('568','168','EVOLVE','Current','EVOLVE',''),
('569','172','N_CONNECTA','Current','N-CONNECTA',''),
('570','172','N_TREK','Current','N-TREK',''),
('571','172','TEKNA','Current','TEKNA',''),
('572','172','TEKNA_PLUS','Current','TEKNA+',''),
('573','173','N_CONNECTA','Current','N-CONNECTA',''),
('574','173','N_TREK','Current','N-TREK',''),
('575','173','TEKNA','Current','TEKNA',''),
('576','173','TEKNA_PLUS','Past','TEKNA+',''),
('577','176','Acenta','Current','Acenta',''),
('578','176','N-Connecta','Current','N-Connecta',''),
('579','175','Acenta','Current','Acenta',''),
('580','175','N-Connecta','Current','N-Connecta',''),
('581','175','Tekna','Current','Tekna',''),
('582','178','Acenta','Current','Acenta',''),
('583','178','N-Connecta','Current','N-Connecta',''),
('584','177','Acenta','Current','Acenta',''),
('585','180','Acenta','Current','Acenta',''),
('586','180','N-Connecta','Current','N-Connecta',''),
('587','179','Acenta','Current','Acenta',''),
('588','182','Acenta','Current','Acenta',''),
('589','182','N-Connecta','Current','N-Connecta',''),
('590','181','Acenta','Current','Acenta',''),
('591','181','N-Connecta','Current','N-Connecta',''),
('592','181','Tekna','Current','Tekna',''),
('593','184','Acenta','Current','Acenta',''),
('594','184','N-Connecta','Current','N-Connecta',''),
('595','183','Acenta','Current','Acenta',''),
('596','183','N-Connecta','Current','N-Connecta',''),
('597','183','Tekna','Current','Tekna','');

DROP TABLE IF EXISTS `variants`;
CREATE TABLE `variants` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `body_type_id` bigint(20) unsigned NOT NULL,
  `trim_id` bigint(20) unsigned NOT NULL,
  `engine_id` bigint(20) unsigned NOT NULL,
  `status` varchar(32) DEFAULT NULL,
  `name` varchar(512) DEFAULT NULL,
  `price` decimal(12,2) DEFAULT NULL,
  `variant_disclaimer_json` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`variant_disclaimer_json`)),
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_variant` (`body_type_id`,`trim_id`,`engine_id`),
  KEY `idx_variants_trim` (`trim_id`),
  KEY `idx_variants_engine` (`engine_id`),
  CONSTRAINT `fk_variants_body` FOREIGN KEY (`body_type_id`) REFERENCES `body_types` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_variants_engine` FOREIGN KEY (`engine_id`) REFERENCES `engines` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_variants_trim` FOREIGN KEY (`trim_id`) REFERENCES `trims` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=1081 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `variants` (`id`,`body_type_id`,`trim_id`,`engine_id`,`status`,`name`,`price`,`variant_disclaimer_json`) VALUES
('1','1','1','1','Current','Anniversario X 1.4_ICE_180_Manual','36990.00','{}'),
('2','2','2','2','Current','595_Grand_Prix_Edition X 1.4_ICE_165_Manual_Limousine','25190.00','{}'),
('3','2','2','3','Current','595_Grand_Prix_Edition X 1.4_ICE_165_Manual_Cabrio','28190.00','{}'),
('4','2','4','2','Current','595_PREMIUM_Grand_Prix_Edition X 1.4_ICE_165_Manual_Limousine','28190.00','{}'),
('5','2','4','3','Current','595_PREMIUM_Grand_Prix_Edition X 1.4_ICE_165_Manual_Cabrio','31190.00','{}'),
('6','2','6','4','Current','695_TURISMO X 1.4_ICE_180_Manual_Limousine','43790.00','{}'),
('7','2','6','5','Current','695_TURISMO X 1.4_ICE_180_MTA_Limousine','45790.00','{}'),
('8','2','6','6','Current','695_TURISMO X 1.4_ICE_180_Manual_Cabrio','46790.00','{}'),
('9','2','6','7','Current','695_TURISMO X 1.4_ICE_180_MTA_Cabrio','48790.00','{}'),
('10','2','7','4','Current','695_COMPETIZIONE X 1.4_ICE_180_Manual_Limousine','44790.00','{}'),
('11','2','7','5','Current','695_COMPETIZIONE X 1.4_ICE_180_MTA_Limousine','46790.00','{}'),
('12','2','7','6','Current','695_COMPETIZIONE X 1.4_ICE_180_Manual_Cabrio','47790.00','{}'),
('13','2','7','7','Current','695_COMPETIZIONE X 1.4_ICE_180_MTA_Cabrio','49790.00','{}'),
('14','2','3','2','Current','595 X 1.4_ICE_165_Manual_Limousine','35190.00','{}'),
('15','2','3','3','Current','595 X 1.4_ICE_165_Manual_Cabrio','38190.00','{}'),
('16','2','5','2','Current','595_PREMIUM X 1.4_ICE_165_Manual_Limousine','37790.00','{}'),
('17','2','5','3','Current','595_PREMIUM X 1.4_ICE_165_Manual_Cabrio','40790.00','{}'),
('18','3','8','8','Current','500e','40490.00','{}'),
('19','3','9','8','Current','500e Cabrio','43490.00','{}'),
('20','3','10','8','Current','500e Turismo','44490.00','{}'),
('21','3','11','8','Current','500e Turismo Cabrio','47490.00','{}'),
('22','4','12','9','Current','500e','40490.00','{}'),
('23','4','13','9','Current','500e Cabrio','43490.00','{}'),
('24','4','14','9','Current','500e Turismo','44490.00','{}'),
('25','4','15','9','Current','500e Turismo Cabrio','47490.00','{}'),
('26','5','16','10','Past','500e','40490.00','{}'),
('27','5','17','10','Past','500e Cabrio','43490.00','{}'),
('28','5','18','10','Current','500e Turismo','39490.00','{}'),
('29','5','19','10','Current','500e Turismo Cabrio','42490.00','{}'),
('30','7','20','11','Current','Turismo X BEV_240','43400.00','{\"de-CH\": \"\", \"fr-CH\": \"\", \"it-CH\": \"\"}'),
('31','7','21','12','Current','Competizione X BEV_280','47400.00','{\"it-CH\": \"\", \"fr-CH\": \"\", \"de-CH\": \"\"}'),
('32','6','22','13','Current','Turismo X BEV_240','43400.00','{}'),
('33','6','23','14','Current','Scorpionissima X BEV_280','47400.00','{}'),
('34','8','24','15','Current','CULT X 1.0_MHEV_70_Manual_Berlina','24290.00','{}'),
('35','8','24','16','Current','CULT X 1.0_MHEV_70_Manual_Cabrio','27290.00','{}'),
('36','8','25','15','Current','LOUNGE X 1.0_MHEV_70_Manual_Berlina','27290.00','{}'),
('37','8','25','16','Current','LOUNGE X 1.0_MHEV_70_Manual_Cabrio','29890.00','{}'),
('38','8','26','16','Current','COLLEZIONE_1957 X 1.0_MHEV_70_Manual_Cabrio','31290.00','{}'),
('39','10','30','18','Current','POP X 1.2_MHEV_110_Automatic','18990.00','{}'),
('40','10','31','18','Current','ICON X 1.2_MHEV_110_Automatic','20990.00','{}'),
('41','10','32','19','Current','RED X BEV_113','24990.00','{}'),
('42','10','33','18','Current','LA_PRIMA X 1.2_MHEV_110_Automatic','23990.00','{}'),
('43','10','33','19','Current','LA_PRIMA X BEV_113','28490.00','{}'),
('44','11','34','20','Current','POP X 1.2_ICE_100_Automatic','1.00','{}'),
('45','11','34','21','Current','POP X 1.2_MHEV_110_Automatic','18990.00','{}'),
('46','11','35','20','Current','ICON X 1.2_ICE_100_Automatic','1.00','{}'),
('47','11','35','21','Current','ICON X 1.2_MHEV_110_Automatic','20990.00','{}'),
('48','11','36','20','Current','LA_PRIMA X 1.2_ICE_100_Automatic','1.00','{}'),
('49','11','36','21','Current','LA_PRIMA X 1.2_MHEV_110_Automatic','23990.00','{}'),
('50','11','36','22','Current','LA_PRIMA X BEV_113','28490.00','{}'),
('51','11','34','22','Current','POP X BEV_113','1.00','{}'),
('52','11','35','22','Current','ICON X BEV_113','1.00','{}'),
('53','12','37','23','Current','POP X 1.2_ICE_100_Automatic','15990.00','{}'),
('54','12','37','24','Draft','POP X 1.2_MHEV_110_Automatic','0.00','{}'),
('55','12','38','23','Current','ICON X 1.2_ICE_100_Automatic','18990.00','{}'),
('56','12','38','24','Current','ICON X 1.2_MHEV_110_Automatic','20990.00','{}'),
('57','12','39','23','Current','LA_PRIMA X 1.2_ICE_100_Automatic','21990.00','{}'),
('58','12','39','24','Current','LA_PRIMA X 1.2_MHEV_110_Automatic','23990.00','{}'),
('59','12','38','25','Current','ICON X BEV_113','99999.00','{}'),
('60','12','39','25','Current','LA_PRIMA X BEV_113','99999.00','{}'),
('61','14','40','26','Current','POP X MHEV_65_Berlina','19990.00','{}'),
('62','14','42','26','Current','TORINO X MHEV_65_Berlina','21990.00','{}'),
('63','14','44','26','Current','LA_PRIMA_500 X MHEV_65_Berlina','23490.00','{}'),
('64','14','44','27','Current','LA_PRIMA_500 X MHEV_65_Cabrio','25990.00','{}'),
('65','14','40','29','Current','POP X BEV_95_Berlina','24990.00','{}'),
('66','14','41','30','Current','ICON_500 X BEV_118_Berlina','30490.00','{}'),
('67','14','44','30','Current','LA_PRIMA_500 X BEV_118_Berlina','32490.00','{}'),
('68','14','41','31','Current','ICON_500 X BEV_118_Cabrio','32490.00','{}'),
('69','14','44','31','Current','LA_PRIMA_500 X BEV_118_Cabrio','34990.00','{}'),
('70','14','41','32','Current','ICON_500 X BEV_118_3_p_1','31490.00','{}'),
('71','14','44','32','Current','LA_PRIMA_500 X BEV_118_3_p_1','33490.00','{}'),
('72','14','43','27','Current','DOLCEVITA_500 X MHEV_65_Cabrio','23990.00','{}'),
('73','14','44','28','Current','LA_PRIMA_500 X MHEV_65_3_p_1','24490.00','{}'),
('74','13','45','33','Current','CULT X BEV_95_Berlina','24990.00','{}'),
('75','13','46','34','Current','RED_SWISS_EDITION X BEV_118_Berlina','30990.00','{}'),
('76','13','46','35','Current','RED_SWISS_EDITION X BEV_118_Cabrio','33490.00','{}'),
('77','13','46','36','Current','RED_SWISS_EDITION X BEV_118_3_p_1','32990.00','{}'),
('78','13','47','34','Current','LA_PRIMA X BEV_118_Berlina','32400.00','{}'),
('79','13','47','35','Current','LA_PRIMA X BEV_118_Cabrio','35400.00','{}'),
('80','13','47','36','Current','LA_PRIMA X BEV_118_3_p_1','34900.00','{}'),
('81','13','48','34','Current','ARMANI X BEV_118_Berlina','38490.00','{}'),
('82','15','49','37','Current','ARMANI X BEV_118_Berlina','38490.00','{\"de-CH\": \"test Disclaimer Versionsseite\"}'),
('83','16','50','38','Current','CULT X BEV_95_Berlina','24990.00','{}'),
('84','16','51','39','Current','RED_SWISS_EDITION X BEV_118_Berlina','30990.00','{}'),
('85','16','51','40','Current','RED_SWISS_EDITION X BEV_118_Cabrio','33490.00','{}'),
('86','16','51','41','Current','RED_SWISS_EDITION X BEV_118_3_p_1','32990.00','{}'),
('87','16','52','39','Current','LA_PRIMA X BEV_118_Berlina','32400.00','{}'),
('88','16','52','40','Current','LA_PRIMA X BEV_118_Cabrio','35400.00','{}'),
('89','16','52','41','Current','LA_PRIMA X BEV_118_3_p_1','34900.00','{}'),
('90','16','53','39','Current','ARMANI X BEV_118_Berlina','38490.00','{}'),
('91','17','54','42','Current','CULT X BEV_95_Berlina','24990.00','{}'),
('92','17','55','43','Current','RED_SWISS_EDITION X BEV_118_Berlina','30990.00','{}'),
('93','17','55','44','Current','RED_SWISS_EDITION X BEV_118_Cabrio','33490.00','{}'),
('94','17','55','45','Current','RED_SWISS_EDITION X BEV_118_3_p_1','32990.00','{}'),
('95','17','56','43','Current','LA_PRIMA X BEV_118_Berlina','32400.00','{}'),
('96','17','56','44','Current','LA_PRIMA X BEV_118_Cabrio','35400.00','{}'),
('97','17','56','45','Current','LA_PRIMA X BEV_118_3_p_1','34900.00','{}'),
('98','17','57','43','Current','ARMANI X BEV_118_Berlina','38490.00','{}'),
('99','18','58','46','Current','SPORT_LOOK X 1.5_MHEV_130_Automatic_4x4','39190.00','{}'),
('100','18','58','47','Current','SPORT_LOOK X 5_MHEV_130_Automatic_4x4_Dolce','42190.00','{}'),
('101','19','59','48','Current','Topolino X BEV_7kWh_8.2PS','9990.00','{\"de-CH\": \"Der Fiat Topolino ist ein leichtes vierrädriges Fahrzeug der Kategorie L6e-BP und darf in der Schweiz mit einem Führerausweis der Kategorie B oder F ab 18 Jahren gefahren werden.\", \"it-CH\": \"La Fiat Topolino è un quadriciclo leggero della categoria L6e-BP e può essere guidata in Svizzera con una patente di categoria B o F a partire dai 18 anni.\", \"fr-CH\": \"La Fiat Topolino est un quadricycle léger de la catégorie L6e-BP et peut être conduite en Suisse avec un permis de conduire de catégorie B ou F à partir de 18 ans.\"}'),
('102','20','60','49','Current','CULT X 1.5_MHEV_130_Automatic','32490.00','{}'),
('103','20','61','49','Current','SWISS_EDITION_CROSS X 1.5_MHEV_130_Automatic','38990.00','{}'),
('104','21','62','50','Current','CULT X 1.5_MHEV_130_Automatic','33990.00','{}'),
('105','21','63','50','Current','SWISS_EDITION_CROSS X 1.5_MHEV_130_Automatic','40490.00','{}'),
('106','22','64','51','Current','E_DOBLO X BEV_136','40990.00','{}'),
('107','24','65','52','Current','QuboL_POP X Benzin_110PS_MT','25990.00','{}'),
('108','24','66','53','Current','QuboL_ICON X Diesel_130PS_AT','30490.00','{}'),
('109','24','66','54','Current','QuboL_ICON X BEV_136PS','34990.00','{}'),
('110','24','67','52','Draft','QuboL_LA_PRIMA X Benzin_110PS_MT','0.00','{}'),
('111','24','67','53','Current','QuboL_LA_PRIMA X Diesel_130PS_AT','32990.00','{}'),
('112','24','67','54','Current','QuboL_LA_PRIMA X BEV_136PS','37490.00','{}'),
('113','24','65','55','Current','QuboL_POP X Benzin_110PS_MT_7-Sitzer','27790.00','{}'),
('114','24','66','56','Current','QuboL_ICON X Diesel_130PS_AT_7-Sitzer','32290.00','{}'),
('115','24','67','56','Current','QuboL_LA_PRIMA X Diesel_130PS_AT_7-Sitzer','34290.00','{}'),
('116','23','68','57','Current','E_DOBLO X BEV_136','40990.00','{}'),
('117','25','69','58','Current','E_DOBLO X BEV_136','40990.00','{}'),
('118','27','70','59','Current','QuboL_POP X Benzin_110PS_MT','0.00','{}'),
('119','27','70','60','Current','QuboL_POP X Diesel_130PS_AT','0.00','{}'),
('120','27','70','61','Current','QuboL_POP X BEV_136PS','0.00','{}'),
('121','27','71','59','Current','QuboL_ICON X Benzin_110PS_MT','0.00','{}'),
('122','27','71','60','Current','QuboL_ICON X Diesel_130PS_AT','0.00','{}'),
('123','27','71','61','Current','QuboL_ICON X BEV_136PS','0.00','{}'),
('124','27','72','59','Current','QuboL_LA_PRIMA X Benzin_110PS_MT','0.00','{}'),
('125','27','72','60','Current','QuboL_LA_PRIMA X Diesel_130PS_AT','0.00','{}'),
('126','27','72','61','Current','QuboL_LA_PRIMA X BEV_136PS','0.00','{}'),
('127','26','73','62','Current','E_DOBLO X BEV_136','40990.00','{}'),
('128','28','74','64','Past','600_CULT X 1.2_MHEV_110_Automatic','28490.00','{}'),
('129','28','75','64','Past','600_SWISS_EDITION X 1.2_MHEV_110_Automatic','25990.00','{}'),
('130','28','76','63','Current','RED X BEV_156','33990.00','{}'),
('131','28','77','64','Past','LA_PRIMA X 1.2_MHEV_110_Automatic','34990.00','{}'),
('132','28','77','65','Past','LA_PRIMA X 1.2_MHEV_145_Automatic','36790.00','{}'),
('133','28','77','63','Current','LA_PRIMA X BEV_156','38990.00','{}'),
('134','29','78','67','Current','600_POP X 1.2_MHEV_110_Automatic','24990.00','{\"fr-CH\": \"\", \"de-CH\": \"\", \"it-CH\": \"\"}'),
('135','29','79','67','Current','600_SWISS_EDITION X 1.2_MHEV_110_Automatic','25990.00','{\"de-CH\": \"Bei Swiss Edition handelt es sich um eine Nettopreisversion.\", \"fr-CH\": \"Swiss Edition sont des versions à prix net.\", \"it-CH\": \"Swiss Edition sono versioni a prezzo netto.\"}'),
('136','29','80','68','Current','LA_PRIMA X 1.2_MHEV_145_Automatic','30990.00','{}'),
('137','29','81','68','Current','600_SPORT X 1.2_MHEV_145_Automatic','30990.00','{}'),
('138','29','79','66','Current','600_SWISS_EDITION X BEV_156','31990.00','{\"fr-CH\": \"Swiss Edition sont des versions à prix net. \", \"it-CH\": \"Swiss Edition sono versioni a prezzo netto.\", \"de-CH\": \"Bei Swiss Edition handelt es sich um eine Nettopreisversion.\"}'),
('139','29','80','66','Current','LA_PRIMA X BEV_156','35990.00','{}'),
('140','29','81','66','Current','600_SPORT X BEV_156','35990.00','{}'),
('141','30','82','69','Current','POP X 3901A','14990.00','{}'),
('142','30','83','69','Current','ICON X 3901A','15990.00','{}'),
('143','30','84','69','Current','CROSS X 3901A','16990.00','{}'),
('144','31','85','70','Current','POP X 3901A','14990.00','{}'),
('145','31','86','70','Current','ICON X 3901A','15990.00','{}'),
('146','31','87','70','Current','CROSS X 3901A','16990.00','{}'),
('147','32','88','71','Current','POP X L2_Diesel','41990.00','{}'),
('148','32','88','72','Current','POP X L3_Diesel','42990.00','{}'),
('149','32','88','73','Current','POP X L2_Elektro','53990.00','{}'),
('150','32','88','74','Current','POP X L3_Elektro','54990.00','{}'),
('151','32','89','71','Current','LA_PRIMA X L2_Diesel','48990.00','{}'),
('152','32','89','72','Current','LA_PRIMA X L3_Diesel','49990.00','{}'),
('153','32','89','73','Current','LA_PRIMA X L2_Elektro','58990.00','{}'),
('154','32','89','74','Current','LA_PRIMA X L3_Elektro','59990.00','{}'),
('155','34','90','75','Current','eDucato_VAN_L4H2_3.5_T_Verglast X 210_kW_270_PS','68190.00','{}'),
('156','34','91','75','Current','eDucato_VAN_L3H2_4.25_T_TV X 210_kW_270_PS','66390.00','{}'),
('157','34','92','75','Current','eDucato_VAN_L3H2_4.25_T_Verglast X 210_kW_270_PS','66790.00','{}'),
('158','34','93','75','Current','eDucato_VAN_L4H2_4.25_T_Verglast X 210_kW_270_PS','69190.00','{}'),
('159','33','94','76','Draft','eDucato_VAN_L3H2_3.5_T X 210_kW_270_PS','56990.00','{\"it-CH\": \"Easy Pro\", \"fr-CH\": \"Easy Pro\", \"de-CH\": \"Easy Pro\"}'),
('160','33','95','76','Draft','eDucato_VAN_L3H3_3.5_T X 210_kW_270_PS','66990.00','{}'),
('161','33','98','76','Draft','eDucato_VAN_L4H2_3.5_T X 210_kW_270_PS','67390.00','{}'),
('162','33','99','76','Draft','eDucato_VAN_L4H3_3.5_T X 210_kW_270_PS','69390.00','{}'),
('163','33','102','76','Draft','eDucato_VAN_L3H2_3.5_T_TV X 210_kW_270_PS','65390.00','{}'),
('164','33','103','76','Draft','eDucato_VAN_L3H2_3.5_T_Verglast X 210_kW_270_PS','65790.00','{}'),
('165','33','104','76','Draft','eDucato_VAN_L4H2_3.5_T_Verglast X 210_kW_270_PS','68190.00','{}'),
('166','33','96','76','Draft','eDucato_VAN_L3H2_4.25_T X 210_kW_270_PS','65990.00','{}'),
('167','33','97','76','Draft','eDucato_VAN_L3H3_4.25_T X 210_kW_270_PS','67990.00','{}'),
('168','33','100','76','Draft','eDucato_VAN_L4H2_4.25_T X 210_kW_270_PS','68390.00','{}'),
('169','33','101','76','Draft','eDucato_VAN_L4H3_4.25_T X 210_kW_270_PS','70390.00','{}'),
('170','33','105','76','Draft','eDucato_VAN_L3H2_4.25_T_TV X 210_kW_270_PS','66390.00','{}'),
('171','33','106','76','Draft','eDucato_VAN_L3H2_4.25_T_Verglast X 210_kW_270_PS','66790.00','{}'),
('172','33','107','76','Draft','eDucato_VAN_L4H2_4.25_T_Verglast X 210_kW_270_PS','69190.00','{}'),
('173','33','108','77','Current','VAN X eDucato_VAN_L3H2_3.5_T','56990.00','{}'),
('174','33','108','78','Current','VAN X eDucato_VAN_L3H3_3.5_T','67390.00','{}'),
('175','33','108','79','Current','VAN X eDucato_VAN_L3H2_4.25_T','65990.00','{}'),
('176','33','108','80','Current','VAN X eDucato_VAN_L3H3_4.25_T','67990.00','{}'),
('177','33','108','81','Current','VAN X eDucato_VAN_L4H2_3.5_T','67390.00','{}'),
('178','33','108','82','Current','VAN X eDucato_VAN_L4H3_3.5_T','69390.00','{}'),
('179','33','108','83','Current','VAN X eDucato_VAN_L4H2_4.25_T','68390.00','{}'),
('180','33','108','84','Current','VAN X eDucato_VAN_L4H3_4.25_T','70390.00','{}'),
('181','33','108','85','Current','VAN X eDucato_VAN_L3H2_3.5_T_TV','65390.00','{}'),
('182','33','108','88','Current','VAN X eDucato_VAN_L3H2_4.25_T_TV','66390.00','{}'),
('183','33','108','86','Current','VAN X eDucato_VAN_L3H2_3.5_T_Verglast','65790.00','{}'),
('184','33','108','87','Current','VAN X eDucato_VAN_L4H2_3.5_T_Verglast','68190.00','{}'),
('185','33','108','89','Current','VAN X eDucato_VAN_L3H2_4.25_T_Verglast','66790.00','{}'),
('186','33','108','90','Current','VAN X eDucato_VAN_L4H2_4.25_T_Verglast','69190.00','{}'),
('187','36','127','96','Current','Pica X 6XS5ZDZ7Z_42kWh','23990.00','{}'),
('188','36','128','96','Current','Origo X 6XS5ZDZ7Z_42kWh','26500.00','{}'),
('189','36','128','97','Current','Origo X 6XS5ZDZ7Z_49kWh','28000.00','{}'),
('190','36','129','96','Current','Amplia X 6XS5ZDZ7Z_42kWh','29000.00','{}'),
('191','36','129','97','Current','Amplia X 6XS5ZDZ7Z_49kWh','30500.00','{}'),
('192','36','130','97','Current','Vertex X 6XS5ZDZ7Z_49kWh','33500.00','{}'),
('193','37','131','98','Current','Pica X 6XS5ZDZ7Z_42kWh','24490.00','{}'),
('194','37','132','98','Current','Origo X 6XS5ZDZ7Z_42kWh','27000.00','{}'),
('195','37','132','99','Current','Origo X 6XS5ZDZ7Z_49kWh','28500.00','{}'),
('196','37','133','98','Current','Amplia X 6XS5ZDZ7Z_42kWh','29500.00','{}'),
('197','37','133','99','Current','Amplia X 6XS5ZDZ7Z_49kWh','31000.00','{}'),
('198','37','134','99','Current','Vertex X 6XS5ZDZ7Z_49kWh','34000.00','{}'),
('199','37','135','99','Current','Vertex_Cross X 6XS5ZDZ7Z_49kWh','35000.00','{}'),
('200','38','136','100','Current','Pica X 6XS5ZDZ7Z_42kWh','24490.00','{}'),
('201','38','137','100','Current','Origo X 6XS5ZDZ7Z_42kWh','27000.00','{}'),
('202','38','137','101','Current','Origo X 6XS5ZDZ7Z_49kWh','28500.00','{}'),
('203','38','138','101','Current','Amplia X 6XS5ZDZ7Z_49kWh','31000.00','{}'),
('204','38','139','101','Current','Vertex X 6XS5ZDZ7Z_49kWh','34000.00','{}'),
('205','38','140','101','Current','Vertex_Cross X 6XS5ZDZ7Z_49kWh','35000.00','{}'),
('206','40','141','102','Current','G029 X 7D5G1FEV1','62000.00','{}'),
('207','40','142','102','Current','G079 X 7D5G1FEV1','67000.00','{}'),
('208','39','143','103','Current','Amplia X 9D5G1FEV1','55000.00','{}'),
('209','39','144','103','Current','Vertex X 9D5G1FEV1','61000.00','{}'),
('210','41','145','104','Current','H214 X 77.4kWh_2WD','67900.00','{}'),
('211','41','145','105','Current','H214 X 77.4kWh_4WD','71900.00','{}'),
('212','43','146','106','Current','Launch_Edition X ALS4ZHZ7Z','67900.00','{}'),
('213','43','146','107','Current','Launch_Edition X ALS4YCZ7Z','71900.00','{}'),
('214','45','147','108','Current','N X ALS4YCZ7Z_84','75500.00','{}'),
('215','44','148','109','Current','Amplia X ALS4ZHZ7Z_63','50100.00','{}'),
('216','44','148','110','Current','Amplia X ALS4ZHZ7Z_84','55100.00','{}'),
('217','44','149','110','Current','Vertex X ALS4ZHZ7Z_84','60100.00','{}'),
('218','44','149','111','Current','Vertex X ALS4YCZ7Z_84','63600.00','{}'),
('219','44','150','111','Current','NLine X ALS4YCZ7Z_84','65600.00','{}'),
('220','47','151','112','Current','N X ALS4YCZ7Z_84','75500.00','{}'),
('221','46','152','113','Current','Amplia X ALS4ZHZ7Z_63','50100.00','{}'),
('222','46','152','114','Current','Amplia X ALS4ZHZ7Z_84','55100.00','{}'),
('223','46','153','114','Current','Vertex X ALS4ZHZ7Z_84','60100.00','{}'),
('224','46','153','115','Current','Vertex X ALS4YCZ7Z_84','63600.00','{}'),
('225','46','154','115','Current','NLine X ALS4YCZ7Z_84','65600.00','{}'),
('226','48','155','116','Current','Low X 42kWh','29900.00','{}'),
('227','48','155','117','Current','Low X 61kWh','33500.00','{}'),
('228','48','156','117','Current','Mid X 61kWh','35000.00','{}'),
('229','49','160','118','Current','D0XC X G4S6K5G17','28500.00','{}'),
('230','49','160','119','Current','D0XC X G4S6K5G1U','30300.00','{}'),
('231','49','160','120','Current','D0XC X G4S6K8G1U','32800.00','{}'),
('232','49','161','119','Current','Amplia_G4 X G4S6K5G1U','33300.00','{}'),
('233','49','161','120','Current','Amplia_G4 X G4S6K8G1U','35800.00','{}'),
('234','49','162','120','Current','Vertex_G4 X G4S6K8G1U','40300.00','{}'),
('235','49','163','120','Current','N_Line_G4 X G4S6K8G1U','41700.00','{}'),
('236','50','164','122','Current','Amplia_G4 X G4T1K8G1U','36800.00','{}'),
('237','50','165','122','Current','Vertex_G4 X G4T1K8G1U','41300.00','{}'),
('238','50','166','122','Current','N_Line_G4 X G4T1K8G1U','42700.00','{}'),
('239','51','167','123','Current','D0XC X G4W5K5G17','29700.00','{}'),
('240','51','167','124','Current','D0XC X G4W5K5G1U','31500.00','{}'),
('241','51','167','125','Current','D0XC X G4W5K8G1U','34000.00','{}'),
('242','51','168','124','Current','Amplia_G4 X G4W5K5G1U','34500.00','{}'),
('243','51','168','125','Current','Amplia_G4 X G4W5K8G1U','37000.00','{}'),
('244','51','169','125','Current','Vertex_G4 X G4W5K8G1U','41500.00','{}'),
('245','51','170','125','Current','N_Line_G4 X G4W5K8G1U','42900.00','{}'),
('246','52','171','127','Current','D0XC X G4S6K8G1U','31300.00','{}'),
('247','52','172','127','Current','Amplia_G4 X G4S6K8G1U','36800.00','{}'),
('248','52','173','127','Current','Vertex_G4 X G4S6K8G1U','41300.00','{}'),
('249','52','174','127','Current','N_Line_G4 X G4S6K8G1U','42700.00','{}'),
('250','53','175','128','Current','D0XC X G4W5K8G1U','32500.00','{}'),
('251','53','176','128','Current','Amplia_G4 X G4W5K8G1U','38000.00','{}'),
('252','53','177','128','Current','Vertex_G4 X G4W5K8G1U','42500.00','{}'),
('253','53','178','128','Current','N_Line_G4 X G4W5K8G1U','43900.00','{}'),
('254','54','179','130','Current','D0XC X G4S6K8G1U','31700.00','{}'),
('255','54','180','130','Current','Amplia_G4 X G4S6K8G1U','37200.00','{}'),
('256','54','181','130','Current','Vertex_G4 X G4S6K8G1U','41700.00','{}'),
('257','54','182','130','Current','N_Line_G4 X G4S6K8G1U','43100.00','{}'),
('258','55','183','131','Current','D0XC X G4W5K8G1U','32900.00','{}'),
('259','55','184','131','Current','Amplia_G4 X G4W5K8G1U','38400.00','{}'),
('260','55','185','131','Current','Vertex_G4 X G4W5K8G1U','42900.00','{}'),
('261','55','186','131','Current','N_Line_G4 X G4W5K8G1U','44300.00','{}'),
('262','56','187','132','Current','N X 9IW5YDZ7Z','79900.00','{}'),
('263','58','188','133','Current','Origo X GIW5ZHZ7Z_63kWh','45000.00','{}'),
('264','58','188','134','Current','Origo X GIW5ZHZ7Z_84kWh','50000.00','{}'),
('265','58','188','135','Current','Origo X GIW5ZHZ7Z','53500.00','{}'),
('266','58','189','134','Current','Amplia X GIW5ZHZ7Z_84kWh','55000.00','{}'),
('267','58','189','135','Current','Amplia X GIW5ZHZ7Z','58500.00','{}'),
('268','58','190','134','Current','Vertex X GIW5ZHZ7Z_84kWh','60000.00','{}'),
('269','58','190','135','Current','Vertex X GIW5ZHZ7Z','63500.00','{}'),
('270','58','191','135','Current','N_Line X GIW5ZHZ7Z','65500.00','{}'),
('271','57','192','136','Current','Origo X GIW5ZHZ7Z_58kWh','49900.00','{}'),
('272','57','192','137','Current','Origo X GIW5YCZ7Z_58kWh','53900.00','{}'),
('273','57','192','138','Current','Origo X GIW5ZHZ7Z_77.4kWh','54900.00','{}'),
('274','57','192','139','Current','Origo X GIW5YCZ7Z_77.4kWh','58900.00','{}'),
('275','57','193','138','Current','Amplia X GIW5ZHZ7Z_77.4kWh','60400.00','{}'),
('276','57','193','139','Current','Amplia X GIW5YCZ7Z_77.4kWh','64400.00','{}'),
('277','57','194','138','Current','Vertex X GIW5ZHZ7Z_77.4kWh','66900.00','{}'),
('278','57','194','139','Current','Vertex X GIW5YCZ7Z_77.4kWh','70900.00','{}'),
('279','59','195','140','Current','N X 9IW5YDZ7Z','75900.00','{}'),
('280','60','196','141','Current','Origo X GIW5ZHZ7Z_63kWh','45500.00','{}'),
('281','60','196','142','Current','Origo X GIW5ZHZ7Z_84kWh','50500.00','{}'),
('282','60','196','143','Current','Origo X GIW5ZHZ7Z','54000.00','{}'),
('283','60','197','142','Current','Amplia X GIW5ZHZ7Z_84kWh','55500.00','{}'),
('284','60','197','143','Current','Amplia X GIW5ZHZ7Z','59000.00','{}'),
('285','60','198','142','Current','Vertex X GIW5ZHZ7Z_84kWh','60500.00','{}'),
('286','60','198','143','Current','Vertex X GIW5ZHZ7Z','64000.00','{}'),
('287','60','199','143','Current','N_Line X GIW5ZHZ7Z','66000.00','{}'),
('288','61','200','144','Current','N X 9IW5YDZ7Z','76500.00','{}'),
('289','62','201','145','Current','Origo X GIW5ZHZ7Z_63kWh','46100.00','{}'),
('290','62','201','146','Current','Origo X GIW5ZHZ7Z_84kWh','51100.00','{}'),
('291','62','201','147','Current','Origo X GIW5ZHZ7Z','54600.00','{}'),
('292','62','202','146','Current','Amplia X GIW5ZHZ7Z_84kWh','56100.00','{}'),
('293','62','202','147','Current','Amplia X GIW5ZHZ7Z','59600.00','{}'),
('294','62','203','146','Current','Vertex X GIW5ZHZ7Z_84kWh','61100.00','{}'),
('295','62','203','147','Current','Vertex X GIW5ZHZ7Z','64600.00','{}'),
('296','62','204','147','Current','N_Line X GIW5ZHZ7Z','66600.00','{}'),
('297','63','205','148','Current','D005 X GQS6K5615','15200.00','{}'),
('298','63','206','148','Current','G14R X GQS6K5615','18900.00','{}'),
('299','63','206','149','Current','G14R X GQS6K561L','19900.00','{}'),
('300','63','207','150','Current','G1FH X GQS6K7615','21900.00','{}'),
('301','63','207','151','Current','G1FH X GQS6K761L','22900.00','{}'),
('302','63','208','151','Current','H786 X GQS6K761L','24900.00','{}'),
('303','63','209','152','Current','M291 X GQS6K5G15','25300.00','{}'),
('304','64','210','153','Current','Origo X HKW6D5G1GEV1','54900.00','{}'),
('305','64','211','153','Current','Amplia X HKW6D5G1GEV1','61400.00','{}'),
('306','64','212','153','Current','Vertex X HKW6D5G1GEV1','66900.00','{}'),
('307','64','212','154','Current','Vertex X HKW6D5G1GEV2','71900.00','{}'),
('308','64','213','153','Current','Calligraphy X HKW6D5G1GEV1','71400.00','{}'),
('309','64','213','154','Current','Calligraphy X HKW6D5G1GEV2','74900.00','{}'),
('310','65','214','155','Current','Origo X HKW6D5G1GEV1','56200.00','{}'),
('311','65','215','155','Current','Amplia X HKW6D5G1GEV1','62700.00','{}'),
('312','65','216','155','Current','Vertex X HKW6D5G1GEV1','68200.00','{}'),
('313','65','216','156','Current','Vertex X HKW6D5G1GEV2','72700.00','{}'),
('314','65','217','155','Current','Calligraphy X HKW6D5G1GEV1','72700.00','{}'),
('315','65','217','156','Current','Calligraphy X HKW6D5G1GEV2','75700.00','{}'),
('316','65','218','155','Current','Vertex_Swiss_Edition X HKW6D5G1GEV1','69950.00','{}'),
('317','65','218','156','Current','Vertex_Swiss_Edition X HKW6D5G1GEV2','72700.00','{}'),
('318','65','219','155','Current','Calligraphy_Swiss_Edition X HKW6D5G1GEV1','72700.00','{}'),
('319','65','219','156','Current','Calligraphy_Swiss_Edition X HKW6D5G1GEV2','75700.00','{}'),
('320','66','220','157','Current','Origo X HKW6D5G1GEV1','56700.00','{}'),
('321','66','221','157','Current','Amplia X HKW6D5G1GEV1','63200.00','{}'),
('322','66','222','157','Current','Vertex X HKW6D5G1GEV1','68700.00','{}'),
('323','66','222','158','Current','Vertex X HKW6D5G1GEV2','73200.00','{}'),
('324','66','223','157','Current','Calligraphy X HKW6D5G1GEV1','73200.00','{}'),
('325','66','223','158','Current','Calligraphy X HKW6D5G1GEV2','76200.00','{}'),
('326','66','224','157','Current','Vertex_Swiss_Edition X HKW6D5G1GEV1','70450.00','{}'),
('327','66','224','158','Current','Vertex_Swiss_Edition X HKW6D5G1GEV2','73200.00','{}'),
('328','66','225','157','Current','Calligraphy_Swiss_Edition X HKW6D5G1GEV1','73200.00','{}'),
('329','66','225','158','Current','Calligraphy_Swiss_Edition X HKW6D5G1GEV2','76200.00','{}'),
('330','69','227','160','Current','Amplia 1.6 GDi Hybrid','40900.00','{}'),
('331','69','226','160','Current','Origo 1.6 GDi Hybrid','37900.00','{}'),
('332','69','228','160','Current','Vertex 1.6 GDi Hybrid','45900.00','{}'),
('333','69','229','160','Current','N Line 1.6 GDi Hybrid','47500.00','{}'),
('334','69','226','159','Current','Origo 1.6 T-GDi','39900.00','{}'),
('335','69','227','159','Current','Amplia 1.6 T-GDi','40900.00','{}'),
('336','69','228','159','Current','Vertex 1.6 T-GDi','45900.00','{}'),
('337','69','229','159','Current','N Line 1.6 T-GDi','47500.00','{}'),
('338','68','230','161','Current','G08J X 48kwh','42900.00','{}'),
('339','68','230','162','Current','G08J X 65kwh','46900.00','{}'),
('340','68','231','161','Current','H984 X 48kwh','45900.00','{}'),
('341','68','231','162','Current','H984 X 65kwh','49900.00','{}'),
('342','68','232','162','Current','H892 X 65kwh','54400.00','{}'),
('343','68','233','162','Current','C126 X 65kwh','56000.00','{}'),
('344','71','234','163','Current','G08J X 48kwh','42900.00','{}'),
('345','71','234','164','Current','G08J X 65kwh','46900.00','{}'),
('346','71','235','163','Current','H984 X 48kwh','45900.00','{}'),
('347','71','235','164','Current','H984 X 65kwh','49900.00','{}'),
('348','71','236','164','Current','H892 X 65kwh','54400.00','{}'),
('349','71','237','164','Current','C126 X 65kwh','56000.00','{}'),
('350','67','239','165','Current','Origo 1.6 GDi Hybrid','37900.00','{\"de-CH\": \"\"}'),
('351','67','240','165','Current','Amplia 1.6 GDi Hybrid','40900.00','{}'),
('352','67','241','165','Current','Vertex 1.6 GDi Hybrid','45900.00','{}'),
('353','67','242','165','Current','N Line 1.6 GDi Hybrid','47500.00','{}'),
('354','67','239','166','Current','Origo 1.6 T-GDi','39900.00','{}'),
('355','67','240','166','Current','Amplia 1.6 T-GDi','42900.00','{}'),
('356','67','241','166','Current','Vertex 1.6 T-GDi','47900.00','{}'),
('357','67','242','166','Current','N Line 1.6 T-GDi','49500.00','{}'),
('358','73','243','167','Current','Origo 1.6 GDi Hybrid','35350.00','{}'),
('359','73','244','167','Current','Amplia 1.6 GDi Hybrid','38350.00','{}'),
('360','73','245','167','Current','Vertex 1.6 GDi Hybrid','43350.00','{}'),
('361','73','246','167','Current','N Line 1.6 GDi Hybrid','44950.00','{}'),
('362','73','243','168','Current','Origo 1.6 T-GDi','40350.00','{}'),
('363','73','244','168','Current','Amplia 1.6 T-GDi','43350.00','{}'),
('364','73','245','168','Current','Vertex 1.6 T-GDi','48350.00','{}'),
('365','73','246','168','Current','N Line 1.6 T-GDi','49950.00','{}'),
('366','73','247','167','Current','Swiss_Edition X 1YW5K9A1TEV1','43350.00','{}'),
('367','73','247','168','Current','Swiss_Edition X 1EW5D5G1X','48350.00','{}'),
('368','72','248','169','Current','G08J X 48kwh','39400.00','{}'),
('369','72','248','170','Current','G08J X 65kwh','43400.00','{}'),
('370','72','249','170','Current','H984 X 65kwh','46400.00','{}'),
('371','72','250','170','Current','H892 X 65kwh','50900.00','{}'),
('372','72','251','170','Current','C126 X 65kwh','52500.00','{}'),
('373','75','252','171','Current','Origo 1.6 GDi Hybrid','35850.00','{}'),
('374','75','253','171','Current','Amplia 1.6 GDi Hybrid','38850.00','{}'),
('375','75','254','171','Current','Vertex 1.6 GDi Hybrid','43850.00','{}'),
('376','75','255','171','Current','N Line 1.6 GDi Hybrid','45450.00','{}'),
('377','75','252','172','Current','Origo 1.6 T-GDi','40850.00','{}'),
('378','75','253','172','Current','Amplia 1.6 T-GDi','43850.00','{}'),
('379','75','254','172','Current','Vertex 1.6 T-GDi','48850.00','{}'),
('380','75','255','172','Current','N Line 1.6 T-GDi','50450.00','{}'),
('381','75','256','171','Current','Swiss_Edition X 1YW5K9A1TEV1','43850.00','{}'),
('382','75','256','172','Current','Swiss_Edition X 1EW5D5G1X','48850.00','{}'),
('383','74','257','173','Current','G08J X 48kwh','39900.00','{}'),
('384','74','257','174','Current','G08J X 65kwh','43900.00','{}'),
('385','74','258','174','Current','H984 X 65kwh','47900.00','{}'),
('386','74','259','174','Current','H892 X 65kwh','51400.00','{}'),
('387','74','260','174','Current','C126 X 65kwh','53000.00','{}'),
('388','76','261','175','Current','Amplia X ZHZ7Z','76900.00','{}'),
('389','76','261','176','Current','Amplia X YCZ7Z','80400.00','{}'),
('390','76','262','176','Current','Vertex X YCZ7Z','84400.00','{}'),
('391','76','263','177','Current','Vertex_Calligraphay X YBZ7Z','89900.00','{}'),
('392','77','264','178','Current','Amplia X ZHZ7Z','77500.00','{}'),
('393','77','264','179','Current','Amplia X YCZ7Z','81000.00','{}'),
('394','77','265','179','Current','Vertex X YCZ7Z','85000.00','{}'),
('395','77','266','180','Current','Vertex_Calligraphay X YBZ7Z','90500.00','{}'),
('396','77','267','180','Current','BlackInk X YBZ7Z','91450.00','{}'),
('397','79','268','181','Current','G029 X 7D5G1FEV1','62000.00','{}'),
('398','79','269','181','Current','G079 X 7D5G1FEV1','67000.00','{}'),
('399','78','270','182','Current','Amplia X 9D5G1FEV1','55000.00','{}'),
('400','78','271','182','Current','Vertex X 9D5G1FEV1','61000.00','{}'),
('401','81','272','183','Current','G029 X 7D5G1FEV1','62000.00','{}'),
('402','81','273','183','Current','G079 X 7D5G1FEV1','67000.00','{}'),
('403','80','274','184','Current','Amplia X 9D5G1FEV1','55000.00','{}'),
('404','80','275','184','Current','Vertex X 9D5G1FEV1','61000.00','{}'),
('405','82','276','185','Current','D0BU X SWS6K5G17','18900.00','{}'),
('406','82','277','185','Current','G2Q0 X SWS6K5G17','23500.00','{}'),
('407','82','277','186','Current','G2Q0 X SWS6K5G1U','25200.00','{}'),
('408','82','278','186','Current','G2Q3 X SWS6K5G1U','28700.00','{}'),
('409','82','279','186','Current','H0WR X SWS6K5G1U','31200.00','{}'),
('410','82','280','186','Current','M291 X SWS6K5G1U','32200.00','{}'),
('411','83','281','187','Current','D0BU X SWS6K5G17','19200.00','{}'),
('412','83','282','187','Current','G2Q0 X SWS6K5G17','23800.00','{}'),
('413','83','282','188','Current','G2Q0 X SWS6K5G1U','25500.00','{}'),
('414','83','283','188','Current','G2Q3 X SWS6K5G1U','29000.00','{}'),
('415','83','284','188','Current','H0WR X SWS6K5G1U','31500.00','{}'),
('416','83','285','188','Current','M291 X SWS6K5G1U','32500.00','{}'),
('417','84','286','189','Current','D0BU X SWS6K5G17','19600.00','{}'),
('418','84','287','189','Current','G2Q0 X SWS6K5G17','24200.00','{}'),
('419','84','287','190','Current','G2Q0 X SWS6K5G1U','25900.00','{}'),
('420','84','289','190','Current','G2Q3 X SWS6K5G1U','29400.00','{}'),
('421','84','290','190','Current','H0WR X SWS6K5G1U','31900.00','{}'),
('422','84','288','190','Current','GO_Edition X SWS6K5G1U','21990.00','{\"fr-CH\": \"Dans la limite des stocks disponibles / Non inclus dans les promotions\", \"de-CH\": \"Nur solange der Vorrat reicht / Ausgeschlossen von Verkaufsaktionen\", \"it-CH\": \"Fino ad esaurimento scorte / Escluso dalle promozioni\"}'),
('423','85','291','191','Current','C005 X SWW5K5G17','21500.00','{}'),
('424','85','292','192','Current','F0UU X SWW5K5G1U','26700.00','{}'),
('425','85','293','192','Current','F0UV X SWW5K5G1U','29400.00','{}'),
('426','85','294','192','Current','M822 X SWW5K5G1U','32000.00','{}'),
('427','86','295','193','Current','C005 X SWW5K5G17','21800.00','{}'),
('428','86','296','194','Current','F0UU X SWW5K5G1U','27000.00','{}'),
('429','86','297','194','Current','F0UV X SWW5K5G1U','29700.00','{}'),
('430','86','298','194','Current','M822 X SWW5K5G1U','32300.00','{}'),
('431','87','299','195','Current','C005 X SWW5K5G17','22200.00','{}'),
('432','87','300','196','Current','F0UU X SWW5K5G1U','27400.00','{}'),
('433','87','301','196','Current','F0UV X SWW5K5G1U','30100.00','{}'),
('434','87','302','196','Current','M822 X SWW5K5G1U','32700.00','{}'),
('435','90','303','197','Current','G1UM X GTW5D5G17','35800.00','{}'),
('436','90','303','198','Current','G1UM X GTW5D5G1U','38200.00','{}'),
('437','90','303','199','Current','G1UM X GTW5D5G1X','40900.00','{}'),
('438','90','304','197','Current','K2FC X GTW5D5G17','40000.00','{}'),
('439','90','304','198','Current','K2FC X GTW5D5G1U','43200.00','{}'),
('440','90','304','199','Current','K2FC X GTW5D5G1X','45900.00','{}'),
('441','90','305','199','Current','B940 X GTW5D5G1X','47900.00','{}'),
('442','90','306','199','Current','H1ZP X GTW5D5G1X','51600.00','{}'),
('443','90','307','199','Current','C05X X GTW5D5G1X','52900.00','{}'),
('444','90','303','200','Current','G1UM X JFW5D5G1FEV1','41200.00','{}'),
('445','90','303','201','Current','G1UM X JFW5D5G1GEV1','43900.00','{}'),
('446','90','304','200','Current','K2FC X JFW5D5G1FEV1','46200.00','{}'),
('447','90','304','201','Current','K2FC X JFW5D5G1GEV1','48900.00','{}'),
('448','90','305','201','Current','B940 X JFW5D5G1GEV1','50900.00','{}'),
('449','90','306','201','Current','H1ZP X JFW5D5G1GEV1','55400.00','{}'),
('450','90','307','201','Current','C05X X JFW5D5G1GEV1','56700.00','{}'),
('451','90','308','201','Current','20th_Anniversary X JFW5D5G1GEV1','57900.00','{}'),
('452','90','303','202','Current','G1UM X JFW5D5G1FEV2','46200.00','{}'),
('453','90','303','203','Current','G1UM X JFW5D5G1GEV2','48900.00','{}'),
('454','90','304','202','Current','K2FC X JFW5D5G1FEV2','51200.00','{}'),
('455','90','304','203','Current','K2FC X JFW5D5G1GEV2','53900.00','{}'),
('456','90','305','203','Current','B940 X JFW5D5G1GEV2','55900.00','{}'),
('457','90','306','203','Current','H1ZP X JFW5D5G1GEV2','60400.00','{}'),
('458','90','307','203','Current','C05X X JFW5D5G1GEV2','61700.00','{}'),
('459','90','308','203','Current','20th_Anniversary X JFW5D5G1GEV2','62900.00','{}'),
('460','90','309','201','Current','swiss_edition X JFW5D5G1GEV1','56900.00','{}'),
('461','90','309','203','Current','swiss_edition X JFW5D5G1GEV2','61900.00','{}'),
('462','88','310','204','Current','G1UM X GTW5D5G17','35800.00','{}'),
('463','88','310','205','Current','G1UM X GTW5D5G1U','38200.00','{}'),
('464','88','310','206','Current','G1UM X GTW5D5G1X','40900.00','{}'),
('465','88','311','204','Current','K2FC X GTW5D5G17','40000.00','{}'),
('466','88','311','205','Current','K2FC X GTW5D5G1U','43200.00','{}'),
('467','88','311','206','Current','K2FC X GTW5D5G1X','45900.00','{}'),
('468','88','312','206','Current','B940 X GTW5D5G1X','47900.00','{}'),
('469','88','313','206','Current','H1ZP X GTW5D5G1X','51600.00','{}'),
('470','88','314','206','Current','C05X X GTW5D5G1X','52900.00','{}'),
('471','89','315','207','Current','G1UM X JFW5D5G1FEV1','41200.00','{}'),
('472','89','315','208','Current','G1UM X JFW5D5G1GEV1','43900.00','{}'),
('473','89','315','209','Current','G1UM X JFW5D5G1FEV2','46200.00','{}'),
('474','89','315','210','Current','G1UM X JFW5D5G1GEV2','48900.00','{}'),
('475','89','316','207','Current','K2FC X JFW5D5G1FEV1','46200.00','{}'),
('476','89','316','208','Current','K2FC X JFW5D5G1GEV1','48900.00','{}'),
('477','89','316','209','Current','K2FC X JFW5D5G1FEV2','51200.00','{}'),
('478','89','316','210','Current','K2FC X JFW5D5G1GEV2','53900.00','{}'),
('479','89','317','208','Current','B940 X JFW5D5G1GEV1','50900.00','{}'),
('480','89','317','210','Current','B940 X JFW5D5G1GEV2','55900.00','{}'),
('481','89','318','208','Current','H1ZP X JFW5D5G1GEV1','55400.00','{}'),
('482','89','318','210','Current','H1ZP X JFW5D5G1GEV2','60400.00','{}'),
('483','89','319','208','Current','C05X X JFW5D5G1GEV1','56700.00','{}'),
('484','89','319','210','Current','C05X X JFW5D5G1GEV2','61700.00','{}'),
('485','89','320','208','Current','20th_Anniversary X JFW5D5G1GEV1','57900.00','{}'),
('486','89','320','210','Current','20th_Anniversary X JFW5D5G1GEV2','62900.00','{}'),
('487','93','322','211','Current','G1UM X GTW5D5G1X','41400.00','{}'),
('488','93','323','211','Current','K2FC X GTW5D5G1X','46400.00','{}'),
('489','93','324','211','Current','H1ZP X GTW5D5G1X','52100.00','{}'),
('490','93','325','211','Current','C05X X GTW5D5G1X','53400.00','{}'),
('491','93','322','212','Current','G1UM X JFW5D5G1FEV1','42200.00','{}'),
('492','93','322','213','Current','G1UM X JFW5D5G1GEV1','44900.00','{}'),
('493','93','323','212','Current','K2FC X JFW5D5G1FEV1','47200.00','{}'),
('494','93','323','213','Current','K2FC X JFW5D5G1GEV1','49900.00','{}'),
('495','93','324','213','Current','H1ZP X JFW5D5G1GEV1','56400.00','{}'),
('496','93','325','213','Current','C05X X JFW5D5G1GEV1','57700.00','{}'),
('497','93','322','214','Current','G1UM X JFW5D5G1FEV2','46700.00','{}'),
('498','93','322','215','Current','G1UM X JFW5D5G1GEV2','49400.00','{}'),
('499','93','323','214','Current','K2FC X JFW5D5G1FEV2','51700.00','{}'),
('500','93','323','215','Current','K2FC X JFW5D5G1GEV2','54400.00','{}'),
('501','93','324','215','Current','H1ZP X JFW5D5G1GEV2','60900.00','{}'),
('502','93','325','215','Current','C05X X JFW5D5G1GEV2','62200.00','{}'),
('503','93','326','213','Current','swiss_edition X JFW5D5G1GEV1','57900.00','{}'),
('504','93','326','215','Current','swiss_edition X JFW5D5G1GEV2','62400.00','{}'),
('505','91','327','218','Current','G1UM X GTW5D5G1X','40900.00','{}'),
('506','91','327','217','Current','G1UM X GTW5D5G1U','38200.00','{}'),
('507','91','327','216','Current','G1UM X GTW5D5G17','35800.00','{}'),
('508','91','328','216','Current','K2FC X GTW5D5G17','40000.00','{}'),
('509','91','328','217','Current','K2FC X GTW5D5G1U','43200.00','{}'),
('510','91','328','218','Current','K2FC X GTW5D5G1X','45900.00','{}'),
('511','91','329','218','Current','B940 X GTW5D5G1X','47900.00','{}'),
('512','91','330','218','Current','H1ZP X GTW5D5G1X','51600.00','{}'),
('513','91','331','218','Current','C05X X GTW5D5G1X','52900.00','{}'),
('514','92','332','219','Current','G1UM X JFW5D5G1FEV1','41200.00','{}'),
('515','92','332','220','Current','G1UM X JFW5D5G1GEV1','43900.00','{}'),
('516','92','332','221','Current','G1UM X JFW5D5G1FEV2','46200.00','{}'),
('517','92','332','222','Current','G1UM X JFW5D5G1GEV2','48900.00','{}'),
('518','92','333','219','Current','K2FC X JFW5D5G1FEV1','46200.00','{}'),
('519','92','333','220','Current','K2FC X JFW5D5G1GEV1','48900.00','{}'),
('520','92','333','221','Current','K2FC X JFW5D5G1FEV2','51200.00','{}'),
('521','92','333','222','Current','K2FC X JFW5D5G1GEV2','53900.00','{}'),
('522','92','334','220','Current','B940 X JFW5D5G1GEV1','50900.00','{}'),
('523','92','334','222','Current','B940 X JFW5D5G1GEV2','55900.00','{}'),
('524','92','335','220','Current','H1ZP X JFW5D5G1GEV1','55400.00','{}'),
('525','92','335','222','Current','H1ZP X JFW5D5G1GEV2','60400.00','{}'),
('526','92','336','220','Current','C05X X JFW5D5G1GEV1','56700.00','{}'),
('527','92','336','222','Current','C05X X JFW5D5G1GEV2','61700.00','{}'),
('528','92','337','220','Current','20th_Anniversary X JFW5D5G1GEV1','57900.00','{}'),
('529','92','337','222','Current','20th_Anniversary X JFW5D5G1GEV2','62900.00','{}'),
('530','94','339','223','Current','ICE Origo','38100.00','{\"fr-CH\": \"Disponible uniquement en stock\", \"de-CH\": \"Nur ab Lager verfügbar\", \"it-CH\": \"Disponibile solo a magazzino\"}'),
('531','94','341','223','Current','ICE Amplia','43100.00','{\"fr-CH\": \"Disponible uniquement en stock\", \"de-CH\": \"Nur ab Lager verfügbar\", \"it-CH\": \"Disponibile solo a magazzino\"}'),
('532','94','342','223','Current','ICE Vertex','48800.00','{\"it-CH\": \"Disponibile solo a magazzino\", \"fr-CH\": \"Disponible uniquement en stock\", \"de-CH\": \"Nur ab Lager verfügbar\"}'),
('533','94','343','223','Current','ICE N Line','50100.00','{\"de-CH\": \"Nur ab Lager verfügbar\", \"it-CH\": \"Disponibile solo a magazzino\", \"fr-CH\": \"Disponible uniquement en stock\"}'),
('534','94','339','224','Current','Hybrid Origo 2WD','38700.00','{}'),
('535','94','339','225','Current','Hybrid Origo 4WD','41400.00','{}'),
('536','94','340','225','Current','Hybrid Origo Black Edition HEV','44400.00','{}'),
('537','94','341','224','Current','Hybrid Amplia 2WD','43700.00','{}'),
('538','94','341','225','Current','Hybrid Amplia 4WD','46400.00','{}'),
('539','94','342','225','Current','Hybrid Vertex 4WD','52900.00','{}'),
('540','94','343','225','Current','Hybrid N Line 4WD','54200.00','{}'),
('541','94','339','226','Current','Plug-in Origo 2WD','42700.00','{}'),
('542','94','339','227','Current','Plug-in Origo 4WD','45400.00','{}'),
('543','94','341','226','Current','Plug-in Amplia 2WD','47700.00','{}'),
('544','94','341','227','Current','Plug-in Amplia 4WD','50400.00','{}'),
('545','94','342','227','Current','Plug-in Vertex 4WD','56900.00','{}'),
('546','94','343','227','Current','Plug-in N Line 4WD','58200.00','{}'),
('547','94','344','225','Current','Hybrid Swiss Edition','54400.00','{}'),
('548','94','344','227','Current','Plug-in Swiss Edition','58400.00','{}'),
('549','95','345','228','Current','SWISS_ALTITUDE X 1.5_MHEV_130_Automatic','42990.00','{}'),
('550','95','345','229','Current','SWISS_ALTITUDE X 1.3_PHEV_190_Automatic_4x4','50490.00','{}'),
('551','95','346','228','Current','SUMMIT X 1.5_MHEV_130_Automatic','48490.00','{}'),
('552','95','347','230','Current','OVERLAND_BLACK_KITE X 1.3_PHEV_240_Automatic_4x4','47990.00','{}'),
('553','95','349','228','Current','NORTH_STAR X 1.5_MHEV_130_Automatic','47990.00','{}'),
('554','95','349','230','Current','NORTH_STAR X 1.3_PHEV_240_Automatic_4x4','57490.00','{}'),
('555','95','348','231','Current','TRAILHAWK X 1.3_PHEV_240_Automatic_4x4_TRAIL','58490.00','{}'),
('556','95','345','230','Current','SWISS_ALTITUDE X 1.3_PHEV_240_Automatic_4x4','52490.00','{}'),
('557','95','346','230','Current','SUMMIT X 1.3_PHEV_240_Automatic_4x4','57990.00','{}'),
('558','96','351','232','Current','FIRST_EDITION X 1.5_MHEV_145_Automatic','39990.00','{\"fr-CH\": \"La Jeep Compass First Edition n\'est disponible qu\'en stock. Veuillez contacter votre concessionnaire officiel Jeep pour en vérifier la disponibilité.\", \"de-CH\": \"Der Jeep Compass First Edition ist nur als Lagerfahrzeug verfügbar. Bitte wenden Sie sich an Ihren offiziellen Jeep Händler, um die Verfügbarkeit zu überprüfen.\", \"it-CH\": \"La Jeep Compass First Edition è disponibile solo in stock. Si prega di rivolgersi al proprio concessionario Jeep ufficiale per verificare la disponibilità.\"}'),
('559','96','351','234','Current','FIRST_EDITION X BEV_213','45990.00','{\"de-CH\": \"Der Jeep Compass First Edition ist nur als Lagerfahrzeug verfügbar. Bitte wenden Sie sich an Ihren offiziellen Jeep Händler, um die Verfügbarkeit zu überprüfen.\", \"fr-CH\": \"La Jeep Compass First Edition n\'est disponible qu\'en stock. Veuillez contacter votre concessionnaire officiel Jeep pour en vérifier la disponibilité.\", \"it-CH\": \"La Jeep Compass First Edition è disponibile solo in stock. Si prega di rivolgersi al proprio concessionario Jeep ufficiale per verificare la disponibilità.\"}'),
('560','96','350','232','Current','ALTITUDE X 1.5_MHEV_145_Automatic','38990.00','{}'),
('561','96','350','233','Current','ALTITUDE X PHEV_225','43990.00','{}'),
('562','96','350','234','Current','ALTITUDE X BEV_213','45990.00','{}'),
('563','96','352','232','Current','SUMMIT X 1.5_MHEV_145_Automatic','41990.00','{}'),
('564','96','352','233','Current','SUMMIT X PHEV_225','46990.00','{}'),
('565','96','352','234','Current','SUMMIT X BEV_213','48990.00','{}'),
('566','99','353','235','Current','LBK X M2E','32990.00','{}'),
('567','99','354','235','Current','LON X M2E','36190.00','{}'),
('568','99','355','235','Current','ALT X M2E','37290.00','{}'),
('569','99','356','235','Current','SUM X M2E','39790.00','{}'),
('570','97','357','236','Current','LON X M25','28990.00','{}'),
('571','97','357','237','Current','LON X M2K','31990.00','{}'),
('572','97','358','236','Current','ALT X M25','30490.00','{}'),
('573','97','358','237','Current','ALT X M2K','33490.00','{}'),
('574','97','359','236','Current','SUM X M25','33490.00','{}'),
('575','97','359','237','Current','SUM X M2K','36490.00','{}'),
('576','97','360','238','Current','ULA X U4L','35790.00','{}'),
('577','97','357','239','Current','LON X BEV_156','36190.00','{}'),
('578','97','358','239','Current','ALT X BEV_156','37290.00','{}'),
('579','97','359','239','Current','SUM X BEV_156','39790.00','{}'),
('580','97','361','238','Current','OLA X U4L','38990.00','{}'),
('581','97','362','238','Current','TNS X U4L','41690.00','{}'),
('582','98','363','240','Current','LBK X M25','24790.00','{}'),
('583','98','363','241','Current','LBK X M2K','27790.00','{}'),
('584','98','364','240','Current','LON X M25','28990.00','{}'),
('585','98','364','241','Current','LON X M2K','31990.00','{}'),
('586','98','365','240','Current','ALT X M25','30490.00','{}'),
('587','98','365','241','Current','ALT X M2K','33490.00','{}'),
('588','98','366','240','Current','SUM X M25','33490.00','{}'),
('589','98','366','241','Current','SUM X M2K','36490.00','{}'),
('590','98','367','242','Current','ULA X U4L','35790.00','{}'),
('591','98','368','242','Current','TNS X U4L','41690.00','{}'),
('592','100','369','243','Current','LBK X M25','24790.00','{}'),
('593','100','369','244','Current','LBK X M2K','27790.00','{}'),
('594','100','370','243','Current','LON X M25','28990.00','{}'),
('595','100','370','244','Current','LON X M2K','31990.00','{}'),
('596','100','371','243','Current','ALT X M25','30490.00','{}'),
('597','100','371','244','Current','ALT X M2K','33490.00','{}'),
('598','100','372','243','Current','SUM X M25','33490.00','{}'),
('599','100','372','244','Current','SUM X M2K','36490.00','{}'),
('600','100','373','246','Current','ULA X U4L','35790.00','{}'),
('601','100','374','246','Current','TNS X U4L','41690.00','{}'),
('602','100','369','245','Current','LBK X M2E','32990.00','{}'),
('603','100','370','245','Current','LON X M2E','36190.00','{}'),
('604','100','371','245','Current','ALT X M2E','37290.00','{}'),
('605','100','372','245','Current','SUM X M2E','39790.00','{}'),
('606','101','375','247','Current','LON X M2K','29990.00','{}'),
('607','101','376','247','Current','ALT X M2K','33490.00','{}'),
('608','101','377','247','Current','ABE X M2K','28990.00','{\"fr-CH\": \"Avenger Black Edition est une version à prix net.\", \"de-CH\": \"Bei Avenger Black Edition handelt es sich um eine Nettopreisversion.\", \"it-CH\": \"Avenger Black Edition è una versione a prezzo netto.\"}'),
('609','101','378','247','Current','SUM X M2K','36490.00','{}'),
('610','101','379','248','Current','ULA X U4L','35790.00','{}'),
('611','101','375','249','Current','LON X BEV_156','34990.00','{}'),
('612','101','376','249','Current','ALT X BEV_156','37290.00','{}'),
('613','101','378','249','Current','SUM X BEV_156','39790.00','{}'),
('614','101','380','248','Current','OLA X U4L','38990.00','{}'),
('615','101','381','248','Current','TNS X U4L','41690.00','{}'),
('616','102','382','250','Current','LON X ICE_100','25990.00','{}'),
('617','102','383','251','Current','ALT X M2K','33490.00','{}'),
('618','102','384','251','Current','85th X M2K','34985.00','{}'),
('619','102','385','251','Current','SUM X M2K','35990.00','{}'),
('620','102','384','252','Current','85th X U4L','38485.00','{}'),
('621','102','386','252','Current','ULA X U4L','35490.00','{}'),
('622','102','387','252','Current','OLA X U4L','38490.00','{}'),
('623','102','383','253','Current','ALT X BEV_156','33990.00','{}'),
('624','102','384','253','Current','85th X BEV_156','35985.00','{}'),
('625','102','385','253','Current','SUM X BEV_156','36490.00','{}'),
('626','103','388','254','Current','BLACKLINE X H5SNC2E','38290.00','{}'),
('627','103','388','255','Current','BLACKLINE X SH5SNCAE','41290.00','{}'),
('628','103','389','254','Current','TITANIUM X H5SNC2E','42590.00','{}'),
('629','103','389','255','Current','TITANIUM X SH5SNCAE','45590.00','{}'),
('630','104','391','256','Current','BLACKLINE X H5SNC2E','38790.00','{}'),
('631','104','391','257','Current','BLACKLINE X SH5SNCAE','41790.00','{}'),
('632','104','392','256','Current','TITANIUM X H5SNC2E','43090.00','{}'),
('633','104','392','257','Current','TITANIUM X SH5SNCAE','46090.00','{}'),
('634','104','390','256','Current','STEEL X H5SNC2E','30990.00','{}'),
('635','104','390','257','Current','STEEL X SH5SNCAE','33990.00','{}'),
('636','105','394','258','Current','BLACKLINE X H5SNC2E','38790.00','{}'),
('637','105','394','259','Current','BLACKLINE X SH5SNCAE','41790.00','{}'),
('638','105','395','258','Current','TITANIUM X H5SNC2E','43090.00','{}'),
('639','105','395','259','Current','TITANIUM X SH5SNCAE','46090.00','{}'),
('640','105','393','258','Current','STEEL X H5SNC2E','30990.00','{}'),
('641','105','393','259','Current','STEEL X SH5SNCAE','33990.00','{}'),
('642','106','396','260','Current','PLATINUM X SMWSNL2E','33990.00','{}'),
('643','106','396','261','Past','PLATINUM X MWSNC2E','40990.00','{}'),
('644','106','397','261','Past','TITANIUM X MWSNC2E','45990.00','{}'),
('645','106','397','263','Current','TITANIUM X SMWSNCAE','44990.00','{}'),
('646','106','396','263','Current','PLATINUM X SMWSNCAE','39990.00','{}'),
('647','106','396','262','Current','PLATINUM X MWS8H2E','37990.00','{}'),
('648','106','397','262','Current','TITANIUM X MWS8H2E','42990.00','{}'),
('649','107','398','264','Current','PLATINUM X SMWSNL2E','34490.00','{}'),
('650','107','398','265','Past','PLATINUM X MWSNC2E','40990.00','{}'),
('651','107','399','265','Past','TITANIUM X MWSNC2E','45990.00','{}'),
('652','107','399','267','Current','TITANIUM X SMWSNCAE','45490.00','{}'),
('653','107','398','267','Current','PLATINUM X SMWSNCAE','40490.00','{}'),
('654','107','398','266','Current','PLATINUM X MWS8H2E','38490.00','{}'),
('655','107','399','266','Current','TITANIUM X MWS8H2E','43490.00','{}'),
('656','107','400','266','Current','BLACKEDITION X MWS8H2E','43490.00','{}'),
('657','107','400','267','Current','BLACKEDITION X SMWSNCAE','45490.00','{}'),
('658','108','401','270','Current','PLATINUM X MWS8H2E','38790.00','{}'),
('659','108','402','270','Current','TITANIUM X MWS8H2E','43790.00','{}'),
('660','108','403','270','Current','BLACKEDITION X MWS8H2E','43790.00','{}'),
('661','108','401','272','Current','PLATINUM X SMWSNFAE','40790.00','{}'),
('662','108','402','272','Current','TITANIUM X SMWSNFAE','45790.00','{}'),
('663','108','403','272','Current','BLACKEDITION X SMWSNFAE','45790.00','{}'),
('664','109','404','273','Past','FIRST_EDITION X MCSNC2E','43990.00','{}'),
('665','109','404','275','Past','FIRST_EDITION X MCSNCAE','46990.00','{}'),
('666','109','405','274','Current','PLA X MCS8H2E','41990.00','{}'),
('667','109','405','275','Current','PLA X MCSNCAE','43990.00','{}'),
('668','109','406','274','Current','TITA X MCS8H2E','44990.00','{}'),
('669','109','406','275','Current','TITA X MCSNCAE','46990.00','{}'),
('670','110','408','277','Current','PLA X MCS8H2E','42490.00','{}'),
('671','110','408','278','Current','PLA X MCSNCAE','44490.00','{}'),
('672','110','409','277','Current','TITA X MCS8H2E','45490.00','{}'),
('673','110','409','278','Current','TITA X MCSNCAE','47490.00','{}'),
('674','111','410','280','Current','PLA X MCS8H2E','42490.00','{}'),
('675','111','410','281','Past','PLA X MCSNCAE','44490.00','{}'),
('676','111','411','280','Current','TITA X MCS8H2E','45490.00','{}'),
('677','111','411','281','Past','TITA X MCSNCAE','47490.00','{}'),
('678','111','410','282','Current','PLA X MCSNFAE','44490.00','{}'),
('679','111','411','282','Current','TITA X MCSNFAE','47490.00','{}'),
('680','112','412','283','Current','BRONZE X F5S9S2E','39990.00','{}'),
('681','112','413','283','Current','PLATINUM X F5S9S2E','42490.00','{}'),
('682','112','414','283','Current','TITANIUM X F5S9S2E','44990.00','{}'),
('683','113','415','284','Current','BRONZE X F5S9S2E','39990.00','{}'),
('684','113','416','284','Current','PLATINUM X F5S9S2E','42490.00','{}'),
('685','113','417','284','Current','TITANIUM X F5S9S2E','45490.00','{}'),
('686','114','418','285','Current','PLATINUM X SUPDSLPE','37990.00','{}'),
('687','114','418','286','Current','PLATINUM X SUPDSCPE','40990.00','{}'),
('688','114','418','287','Current','PLATINUM X UHDSLPE','39990.00','{}'),
('689','114','418','288','Current','PLATINUM X UHDSCPE','42990.00','{}'),
('690','114','419','286','Current','TITANIUM X SUPDSCPE','44390.00','{}'),
('691','114','419','288','Current','TITANIUM X UHDSCPE','45990.00','{}'),
('692','114','420','286','Current','BLACKLINE X SUPDSCPE','48390.00','{}'),
('693','114','420','288','Current','BLACKLINE X UHDSCPE','49990.00','{}'),
('694','115','421','289','Current','PLATINUM X SUPDSCPE','39490.00','{}'),
('695','115','421','290','Current','PLATINUM X UHDSCPE','40990.00','{}'),
('696','115','422','289','Current','TITANIUM X SUPDSCPE','43490.00','{}'),
('697','115','422','290','Current','TITANIUM X UHDSCPE','44990.00','{}'),
('698','116','424','291','Current','BRONZE X F5S9S2E','41990.00','{}'),
('699','116','425','291','Current','PLATINUM X F5S9S2E','45990.00','{}'),
('700','116','426','291','Current','TITANIUM X F5S9S2E','49990.00','{}'),
('701','117','427','292','Past','BRONZE X F5S9S2E','41990.00','{}'),
('702','117','428','292','Past','PLATINUM X F5S9S2E','45990.00','{}'),
('703','117','429','292','Past','TITANIUM X F5S9S2E','49990.00','{}'),
('704','117','427','293','Current','BRONZE X F5S9S2E_','35490.00','{}'),
('705','117','428','293','Current','PLATINUM X F5S9S2E_','39990.00','{}'),
('706','117','429','293','Current','TITANIUM X F5S9S2E_','42990.00','{}'),
('707','118','430','294','Past','BRONZE X F5S9S2E','41990.00','{}'),
('708','118','431','294','Past','PLATINUM X F5S9S2E','45990.00','{}'),
('709','118','432','294','Past','TITANIUM X F5S9S2E','49990.00','{}'),
('710','118','430','295','Current','BRONZE X F5S9S2E_','35490.00','{}'),
('711','118','431','295','Current','PLATINUM X F5S9S2E_','39990.00','{}'),
('712','118','432','295','Current','TITANIUM X F5S9S2E_','42990.00','{}'),
('713','118','433','295','Current','BlackEdition X F5S9S2E_','43690.00','{}'),
('714','119','434','296','Current','BRONZE X L2E','28490.00','{}'),
('715','119','434','297','Current','BRONZE X C2E','31490.00','{}'),
('716','119','434','298','Current','BRONZE X LAE','31490.00','{}'),
('717','119','434','299','Current','BRONZE X CAE','34490.00','{}'),
('718','119','435','296','Current','PLATINUM X L2E','30490.00','{}'),
('719','119','435','297','Current','PLATINUM X C2E','33490.00','{}'),
('720','119','435','298','Current','PLATINUM X LAE','33490.00','{}'),
('721','119','435','299','Current','PLATINUM X CAE','36490.00','{}'),
('722','119','436','297','Current','TITANIUM X C2E','35490.00','{}'),
('723','119','436','299','Current','TITANIUM X CAE','38490.00','{}'),
('724','120','438','302','Current','BRONZE X C2E','31490.00','{}'),
('725','120','438','303','Current','BRONZE X CAE','34490.00','{}'),
('726','120','439','303','Current','PLATINUM X CAE','36490.00','{}'),
('727','120','440','303','Current','TITANIUM X CAE','38490.00','{}'),
('728','120','437','300','Current','Steel X L2E','19990.00','{}'),
('729','120','437','302','Current','Steel X C2E','22990.00','{}'),
('730','120','437','303','Current','Steel X CAE','25990.00','{}'),
('731','120','437','301','Current','Steel X LAE','22990.00','{}'),
('732','121','442','306','Current','BRONZE X C2E','31490.00','{}'),
('733','121','442','307','Current','BRONZE X CAE','34490.00','{}'),
('734','121','443','307','Current','PLATINUM X CAE','36490.00','{}'),
('735','121','444','307','Current','TITANIUM X CAE','38490.00','{}'),
('736','121','441','304','Current','Steel X L2E','19990.00','{}'),
('737','121','441','306','Current','Steel X C2E','22990.00','{}'),
('738','121','441','307','Current','Steel X CAE','25990.00','{}'),
('739','121','441','305','Current','Steel X LAE','22990.00','{}'),
('740','122','445','308','Current','PLA X 5 seater','49990.00','{}'),
('741','122','445','309','Current','PLA X 7 seater','50990.00','{}'),
('742','122','446','308','Current','TIT X 5 seater','54990.00','{}'),
('743','122','446','309','Current','TIT X S5G7DSFPE','55990.00','{}'),
('744','122','447','308','Current','BLA X 5 seater','61340.00','{}'),
('745','123','448','310','Current','PLATINUM X G5DSFPE','49990.00','{}'),
('746','123','449','310','Current','TITANIUM X G5DSFPE','54990.00','{}'),
('747','123','450','310','Current','BLACKLINE X G5DSFPE','61340.00','{}'),
('748','123','448','311','Current','PLATINUM X G7DSFPE','50990.00','{}'),
('749','123','449','311','Current','TITANIUM X G7DSFPE','55990.00','{}'),
('750','123','450','311','Current','BLACKLINE X G7DSFPE','62340.00','{}'),
('751','124','451','312','Current','PLATINUM X G5DSFPE','50490.00','{}'),
('752','124','452','312','Current','TITANIUM X G5DSFPE','55490.00','{}'),
('753','124','453','312','Current','BLACKLINE X G5DSFPE','61840.00','{}'),
('754','124','451','313','Current','PLATINUM X G7DSFPE','51490.00','{}'),
('755','124','452','313','Current','TITANIUM X G7DSFPE','56490.00','{}'),
('756','124','453','313','Current','BLACKLINE X G7DSFPE','62840.00','{}'),
('757','125','454','314','Current','VAN_Comfort X L3H2FWDMY24','38900.00','{}'),
('758','125','455','314','Current','VAN_Luxury X L3H2FWDMY24','39900.00','{}'),
('759','125','456','315','Current','CC_Luxury X CCL3LUX','38400.00','{}'),
('760','125','456','316','Current','CC_Luxury X CCL4LUX','38900.00','{}'),
('761','126','457','317','Current','VAN_Luxury X L3H2FWDMY24','39900.00','{}'),
('762','126','458','318','Current','CC_Luxury X CCL3LUX','37400.00','{}'),
('763','126','458','319','Current','CC_Luxury X CCL4LUX','37900.00','{}'),
('764','127','459','320','Current','VAN_DCiV X 63VE22','56000.00','{}'),
('765','127','459','321','Current','VAN_DCiV X 88kWh_L2H2','59000.00','{}'),
('766','127','459','322','Current','VAN_DCiV X 77kWh_L3H2','57000.00','{}'),
('767','127','459','323','Current','VAN_DCiV X 88kWh_L3H2','60000.00','{}'),
('768','127','459','324','Current','VAN_DCiV X 77kWh_L3H3','58000.00','{}'),
('769','127','459','325','Current','VAN_DCiV X 88kWh_L3H3','61000.00','{}'),
('770','127','459','326','Current','VAN_DCiV X 77kWh_Doppelkabine_L3H2','60000.00','{}'),
('771','127','460','329','Current','CC X 88kWh_CC_eD9_L4','59500.00','{}'),
('772','127','460','328','Current','CC X 88kWh_CC_eD9','58500.00','{}'),
('773','127','459','327','Current','VAN_DCiV X 77kWh_Doppelkabine_L3H3','61000.00','{}'),
('774','128','461','330','Current','VAN X L2FWDMY24','29900.00','{}'),
('775','129','462','331','Current','VAN X L1FWDMY26','29500.00','{}'),
('776','129','462','332','Current','VAN X L2FWDMY26','30500.00','{}'),
('777','130','463','333','Current','-','44400.00','{}'),
('778','130','463','334','Current','VAN_FWD X L188kWhFWDMY24','47400.00','{}'),
('779','130','464','337','Current','VAN_AWD X L188kWhAWDMY24','51400.00','{}'),
('780','130','464','338','Current','VAN_AWD X L288kWhAWDMY24','52400.00','{}'),
('781','130','463','335','Current','VAN_FWD X L277kWhFWDMY24','45400.00','{}'),
('782','130','463','336','Current','VAN_FWD X L288kWhFWDMY24','48400.00','{}'),
('783','132','465','339','Current','LUXURY X AWDMY24','39900.00','{}'),
('784','133','466','340','Current','LUXURY X K1PELU','69900.00','{}'),
('785','133','467','340','Current','PREMIUM X K1PELU','72900.00','{}'),
('786','134','468','341','Current','VAN_FWD X L1H1_64kWh','39500.00','{}'),
('787','135','469','342','Current','77_2WD_BLACK_ROOF X CYBER77DB','63990.00','{}'),
('788','135','469','343','Archived','77_2WD_BLACK_ROOF X CYBER77FB','67990.00','{}'),
('789','135','470','342','Archived','77_2WD_RED_ROOF X CYBER77DB','67990.00','{}'),
('790','135','470','343','Current','77_2WD_RED_ROOF X CYBER77FB','67990.00','{}'),
('791','136','471','344','Current','77_2WD_BLACK_ROOF X CYBER77DB','63990.00','{}'),
('792','136','471','345','Archived','77_2WD_BLACK_ROOF X CYBER77FB','67990.00','{}'),
('793','136','472','344','Archived','77_2WD_RED_ROOF X CYBER77DB','67990.00','{}'),
('794','136','472','345','Current','77_2WD_RED_ROOF X CYBER77FB','67990.00','{}'),
('795','137','473','348','Current','COMFORT_AT X HSHEV','29990.00','{\"de-CH\": \"\", \"fr-CH\": \"\", \"it-CH\": \"\"}'),
('796','137','474','348','Current','LUXURY_AT X HSHEV','32990.00','{}'),
('797','137','473','346','Current','COMFORT_AT X MFRPSD7H44','25490.00','{\"de-CH\": \"\", \"fr-CH\": \"\", \"it-CH\": \"\"}'),
('798','137','474','346','Current','LUXURY_AT X MFRPSD7H44','28490.00','{}'),
('799','137','473','347','Current','COMFORT_AT X MFRPSD7H4F','27990.00','{\"it-CH\": \"Veicoli a magazzino disponibili\", \"fr-CH\": \"Véhicules de stockage disponibles\", \"de-CH\": \"Lagerfahrzeuge verfügbar\"}'),
('800','137','474','347','Current','LUXURY_AT X MFRPSD7H4F','30990.00','{\"de-CH\": \"Lagerfahrzeuge verfügbar\", \"it-CH\": \"Veicoli a magazzino disponibili\", \"fr-CH\": \"Véhicules de stockage disponibles\"}'),
('801','137','473','349','Current','COMFORT_AT X HSPHEV','34990.00','{}'),
('802','137','474','349','Current','LUXURY_AT X HSPHEV','37490.00','{}'),
('803','138','475','352','Current','COMFORT_AT X HSHEV','29990.00','{\"fr-CH\": \"\", \"de-CH\": \"\", \"it-CH\": \"\"}'),
('804','138','476','352','Current','LUXURY_AT X HSHEV','32990.00','{}'),
('805','138','475','350','Current','COMFORT_AT X MFRPSD7H44','25490.00','{\"fr-CH\": \"\", \"de-CH\": \"\", \"it-CH\": \"\"}'),
('806','138','476','350','Current','LUXURY_AT X MFRPSD7H44','28490.00','{}'),
('807','138','475','351','Current','COMFORT_AT X MFRPSD7H4F','27990.00','{\"de-CH\": \"Lagerfahrzeuge verfügbar\", \"it-CH\": \"Veicoli a magazzino disponibili\", \"fr-CH\": \"Véhicules de stockage disponibles\"}'),
('808','138','476','351','Current','LUXURY_AT X MFRPSD7H4F','30990.00','{\"it-CH\": \"Veicoli a magazzino disponibili\", \"fr-CH\": \"Véhicules de stockage disponibles\", \"de-CH\": \"Lagerfahrzeuge verfügbar\"}'),
('809','138','475','353','Current','COMFORT_AT X HSPHEV','34990.00','{}'),
('810','138','476','353','Current','LUXURY_AT X HSPHEV','37490.00','{}'),
('811','139','477','354','Current','STANDARD X LGSWFT79MC','41990.00','{}'),
('812','139','478','355','Current','LONG_RANGE X LGSWFCC9YC','48990.00','{}'),
('813','139','479','356','Current','PERFORMANCE X LGSWFDC92C','53990.00','{\"fr-CH\": \"\", \"de-CH\": \"\", \"it-CH\": \"\"}'),
('814','140','480','357','Current','LONG_RANGE X LKS7SC79YC','49990.00','{}'),
('815','140','481','358','Current','PERFORMANCE X LKS7SD792C','55990.00','{}'),
('816','140','482','359','Archived','LAUNCH_EDITION X LKS7SDA92C','61990.00','{}'),
('817','140','482','358','Current','LAUNCH_EDITION X LKS7SD792C','61990.00','{\"fr-CH\": \"\", \"de-CH\": \"\", \"it-CH\": \"\"}'),
('818','141','483','361','Current','STANDARD X MG3HEV','19490.00','{}'),
('819','141','484','361','Current','COMFORT X MG3HEV','20990.00','{}'),
('820','141','485','361','Current','LUXURY X MG3HEV','22990.00','{}'),
('821','141','483','360','Current','STANDARD X MG3ICEMT','16490.00','{}'),
('822','141','484','360','Current','COMFORT X MG3ICEMT','17990.00','{}'),
('823','142','486','363','Current','STANDARD X MG3HEV','19490.00','{}'),
('824','142','487','363','Current','COMFORT X MG3HEV','20990.00','{}'),
('825','142','488','363','Current','LUXURY X MG3HEV','22990.00','{}'),
('826','142','486','362','Current','STANDARD X MG3ICEMT','16490.00','{}'),
('827','142','487','362','Current','COMFORT X MG3ICEMT','17990.00','{}'),
('828','143','489','365','Current','STANDARD X MG3HEV','19490.00','{}'),
('829','143','490','365','Current','COMFORT X MG3HEV','20990.00','{}'),
('830','143','491','365','Current','LUXURY X MG3HEV','22990.00','{}'),
('831','143','489','364','Current','STANDARD X MG3ICEMT','16490.00','{}'),
('832','143','490','364','Current','COMFORT X MG3ICEMT','17990.00','{}'),
('833','144','492','366','Current','Comfort X MG4U43','21990.00','{}'),
('834','144','492','367','Current','Comfort X MG4U54C','24490.00','{}'),
('835','144','493','368','Current','Premium X MG4U54','27490.00','{}'),
('836','145','494','369','Current','64 kWh Premium','33490.00','{\"fr-CH\": \"\", \"de-CH\": \"\", \"it-CH\": \"\"}'),
('837','145','495','370','Current','77 kWh Premium','36490.00','{\"it-CH\": \"\", \"de-CH\": \"\", \"fr-CH\": \"\"}'),
('838','145','496','371','Current','64 kWh XPOWER','38490.00','{\"it-CH\": \"\", \"de-CH\": \"\", \"fr-CH\": \"\"}'),
('839','146','497','372','Current','COMFORT X MJR81C00FC','29990.00','{}'),
('840','146','498','373','Current','LUXURY X MJR81D00QC','36490.00','{}'),
('841','147','499','374','Current','Luxury X MGS62WD','45990.00','{}'),
('842','147','499','375','Current','Luxury X MGS64WD','48990.00','{}'),
('843','148','501','376','Current','Comfort X MGS9PHEV','38990.00','{}'),
('844','148','502','376','Current','Premium X MGS9PHEV','40990.00','{}'),
('845','149','503','378','Current','STANDARD X ZSHEV','21990.00','{}'),
('846','149','504','378','Current','COMFORT X ZSHEV','23990.00','{}'),
('847','149','505','378','Current','LUXURY X ZSHEV','25990.00','{}'),
('848','149','503','377','Current','STANDARD X ZSICE15MT','18990.00','{}'),
('849','149','504','377','Current','COMFORT X ZSICE15MT','21990.00','{}'),
('850','150','506','380','Current','STANDARD X ZSHEV','21990.00','{}'),
('851','150','507','380','Current','COMFORT X ZSHEV','23990.00','{}'),
('852','150','508','380','Current','LUXURY X ZSHEV','26990.00','{}'),
('853','150','506','379','Current','STANDARD X ZSICE15MT','18990.00','{}'),
('854','150','507','379','Current','COMFORT X ZSICE15MT','21990.00','{}'),
('855','151','509','382','Current','STANDARD X ZSHEV','21990.00','{}'),
('856','151','510','382','Current','COMFORT X ZSHEV','23990.00','{}'),
('857','151','511','382','Current','LUXURY X ZSHEV','26990.00','{}'),
('858','151','509','381','Current','STANDARD X ZSICE15MT','18990.00','{}'),
('859','151','510','381','Current','COMFORT X ZSICE15MT','21990.00','{}'),
('860','152','512','383','Current','T-A--- X SIFRNAL.YF16UGA','27490.00','{}'),
('861','152','512','384','Current','T-A--- X SIFRNAL.LF16UGA','29390.00','{}'),
('862','152','513','384','Current','UC_B-C X SIFRNAL.LF16UGA','32790.00','{}'),
('863','152','513','385','Current','UC_B-C X SIFDTAL.XF16HGA','35790.00','{}'),
('864','152','514','384','Current','V-HC_C X SIFRNAL.LF16UGA','36490.00','{}'),
('865','152','514','385','Current','V-HC_C X SIFDTAL.XF16HGA','39490.00','{}'),
('866','152','515','384','Current','WCHCEE X SIFRNAL.LF16UGA','38790.00','{}'),
('867','152','515','385','Current','WCHCEE X SIFDTAL.XF16HGA','41790.00','{}'),
('868','152','516','384','Current','WCHCCG X SIFRNAL.LF16UGA','38790.00','{}'),
('869','152','516','385','Current','WCHCCG X SIFDTAL.XF16HGA','41790.00','{}'),
('870','153','517','386','Current','ACENTA X FRNAL.YF16UGA','27490.00','{}'),
('871','153','517','387','Current','ACENTA X FRNAL.LF16UGA','29390.00','{}'),
('872','153','518','387','Current','N-CONNECTA X FRNAL.LF16UGA','32790.00','{}'),
('873','153','519','387','Current','TEKNA X FRNAL.LF16UGA','36490.00','{}'),
('874','153','519','388','Current','TEKNA X FDTAL.XF16HGA','39490.00','{}'),
('875','153','520','387','Current','N-DESIGN X FRNAL.LF16UGA','38790.00','{}'),
('876','153','520','388','Current','N-DESIGN X FDTAL.XF16HGA','41790.00','{}'),
('877','153','521','387','Current','N-SPORT X FRNAL.LF16UGA','38790.00','{}'),
('878','153','521','388','Current','N-SPORT X FDTAL.XF16HGA','41790.00','{}'),
('879','153','518','388','Current','N-CONNECTA X FDTAL.XF16HGA','35790.00','{}'),
('880','154','522','389','Current','ACENTA X FRNAL.YF16UGA','27490.00','{}'),
('881','154','522','390','Current','ACENTA X FRNAL.LF16UGA','29390.00','{}'),
('882','154','523','390','Current','N-CONNECTA X FRNAL.LF16UGA','33190.00','{}'),
('883','154','524','390','Current','TEKNA X FRNAL.LF16UGA','36490.00','{}'),
('884','154','524','391','Current','TEKNA X FDTAL.XF16HGA','39490.00','{}'),
('885','154','525','390','Current','N-DESIGN X FRNAL.LF16UGA','38790.00','{}'),
('886','154','525','391','Current','N-DESIGN X FDTAL.XF16HGA','41790.00','{}'),
('887','154','526','390','Current','N-SPORT X FRNAL.LF16UGA','38790.00','{\"it-CH\": \"\", \"de-CH\": \"\", \"fr-CH\": \"\"}'),
('888','154','526','391','Current','N-SPORT X FDTAL.XF16HGA','41790.00','{\"it-CH\": \"\", \"fr-CH\": \"\", \"de-CH\": \"\"}'),
('889','154','523','391','Current','N-CONNECTA X FDTAL.XF16HGA','36190.00','{}'),
('890','155','527','392','Current','ACENTA X FRNAL.YF16UGA','27490.00','{}'),
('891','155','527','393','Current','ACENTA X FRNAL.LF16UGA','29390.00','{}'),
('892','155','528','393','Current','N-CONNECTA X FRNAL.LF16UGA','32790.00','{}'),
('893','155','529','393','Current','TEKNA X FRNAL.LF16UGA','36490.00','{}'),
('894','155','529','394','Current','TEKNA X FDTAL.XF16HGA','39490.00','{}'),
('895','155','530','393','Current','N-DESIGN X FRNAL.LF16UGA','38790.00','{}'),
('896','155','530','394','Current','N-DESIGN X FDTAL.XF16HGA','41790.00','{}'),
('897','155','531','393','Current','N-SPORT X FRNAL.LF16UGA','38790.00','{}'),
('898','155','531','394','Current','N-SPORT X FDTAL.XF16HGA','41790.00','{}'),
('899','155','528','394','Current','N-CONNECTA X FDTAL.XF16HGA','35790.00','{}'),
('900','156','532','395','Current','ACENTA X FRNAL.YF16UGA','27490.00','{}'),
('901','156','532','396','Current','ACENTA X FRNAL.LF16UGA','29390.00','{}'),
('902','156','533','396','Current','N-CONNECTA X FRNAL.LF16UGA','33190.00','{}'),
('903','156','534','396','Current','TEKNA X FRNAL.LF16UGA','36490.00','{}'),
('904','156','534','397','Current','TEKNA X FDTAL.XF16HGA','39490.00','{}'),
('905','156','535','396','Current','N-DESIGN X FRNAL.LF16UGA','38790.00','{}'),
('906','156','535','397','Current','N-DESIGN X FDTAL.XF16HGA','41790.00','{}'),
('907','156','536','396','Current','N-SPORT X FRNAL.LF16UGA','38790.00','{\"fr-CH\": \"\", \"it-CH\": \"\", \"de-CH\": \"\"}'),
('908','156','536','397','Current','N-SPORT X FDTAL.XF16HGA','41790.00','{\"it-CH\": \"\", \"de-CH\": \"\", \"fr-CH\": \"\"}'),
('909','156','533','397','Current','N-CONNECTA X FDTAL.XF16HGA','36190.00','{}'),
('910','157','537','398','Current','ENGAGE X TSGAL.9FE03GA','45990.00','{}'),
('911','157','537','399','Current','ENGAGE X TSGAL.9FE0BGA','52490.00','{}'),
('912','157','538','399','Current','ADVANCE X TSGAL.9FE0BGA','55990.00','{}'),
('913','157','538','400','Current','ADVANCE X TSGNL.9FE0BGC','59490.00','{}'),
('914','157','539','399','Current','EVOLVE X TSGAL.9FE0BGA','61490.00','{}'),
('915','157','539','400','Current','EVOLVE X TSGNL.9FE0BGC','64990.00','{}'),
('916','157','540','401','Current','EVOLVE_400 X TSGNL.9FE0BGA_evolve','67990.00','{}'),
('917','157','541','402','Current','NISMO X TSGNL.9FE0BGA_nismo','67990.00','{}'),
('918','162','542','403','Current','ACENTA X TDZAL.WJ12UGA','38390.00','{}'),
('919','162','542','405','Current','ACENTA X TDNAL.9J12HGA','41590.00','{}'),
('920','162','543','404','Current','N-CONNECTA X TDZNL.WJ12UGA','42790.00','{}'),
('921','162','543','405','Current','N-CONNECTA X TDNAL.9J12HGA','43990.00','{}'),
('922','162','544','404','Current','TEKNA X TDZNL.WJ12UGA','46790.00','{}'),
('923','162','544','405','Current','TEKNA X TDNAL.9J12HGA','47990.00','{}'),
('924','162','545','404','Current','TEKNA_PLUS X TDZNL.WJ12UGA','50490.00','{}'),
('925','162','545','405','Current','TEKNA_PLUS X TDNAL.9J12HGA','51690.00','{}'),
('926','162','546','404','Current','N-DESIGN X TDZNL.WJ12UGA','50490.00','{}'),
('927','162','546','405','Current','N-DESIGN X TDNAL.9J12HGA','51690.00','{}'),
('928','163','547','406','Current','ACENTA X TDZAL.WJ12UGA','38390.00','{}'),
('929','163','547','408','Current','ACENTA X TDNAL.9J12HGA','41590.00','{}'),
('930','163','548','407','Current','N-CONNECTA X TDZNL.WJ12UGA','42790.00','{}'),
('931','163','548','408','Current','N-CONNECTA X TDNAL.9J12HGA','43990.00','{}'),
('932','163','549','408','Current','TEKNA X TDNAL.9J12HGA','47990.00','{}'),
('933','163','550','408','Current','TEKNA_PLUS X TDNAL.9J12HGA','51690.00','{}'),
('934','163','550','407','Current','TEKNA_PLUS X TDZNL.WJ12UGA','50490.00','{}'),
('935','163','549','407','Current','TEKNA X TDZNL.WJ12UGA','46790.00','{}'),
('936','163','551','408','Current','N-DESIGN X TDNAL.9J12HGA','51690.00','{}'),
('937','163','551','407','Current','N-DESIGN X TDZNL.WJ12UGA','50490.00','{}'),
('938','164','552','409','Current','ACENTA X TDZAL.WJ12UGA','38390.00','{}'),
('939','164','552','411','Current','ACENTA X TDNAL.9J12HGA','41590.00','{}'),
('940','164','553','410','Current','N-CONNECTA X TDZNL.WJ12UGA','42790.00','{}'),
('941','164','553','411','Current','N-CONNECTA X TDNAL.9J12HGA','43990.00','{}'),
('942','164','554','411','Current','TEKNA X TDNAL.9J12HGA','47990.00','{}'),
('943','164','555','411','Current','TEKNA_PLUS X TDNAL.9J12HGA','51690.00','{}'),
('944','164','555','410','Current','TEKNA_PLUS X TDZNL.WJ12UGA','50490.00','{}'),
('945','164','554','410','Current','TEKNA X TDZNL.WJ12UGA','46790.00','{}'),
('946','164','556','411','Current','N-DESIGN X TDNAL.9J12HGA','51690.00','{}'),
('947','164','556','410','Current','N-DESIGN X TDZNL.WJ12UGA','50490.00','{}'),
('948','165','557','412','Current','ACENTA X TDZAL.WJ12UGA','38390.00','{}'),
('949','165','557','414','Current','ACENTA X TDNAL.9J12HGA','41590.00','{}'),
('950','165','558','413','Current','N-CONNECTA X TDZNL.WJ12UGA','42790.00','{}'),
('951','165','558','414','Current','N-CONNECTA X TDNAL.9J12HGA','43990.00','{}'),
('952','165','559','413','Current','TEKNA X TDZNL.WJ12UGA','46790.00','{}'),
('953','165','559','414','Current','TEKNA X TDNAL.9J12HGA','47990.00','{}'),
('954','165','560','413','Current','TEKNA_PLUS X TDZNL.WJ12UGA','50490.00','{}'),
('955','165','560','414','Current','TEKNA_PLUS X TDNAL.9J12HGA','51690.00','{}'),
('956','165','561','413','Current','N-DESIGN X TDZNL.WJ12UGA','50490.00','{}'),
('957','165','561','414','Current','N-DESIGN X TDNAL.9J12HGA','51690.00','{}'),
('958','166','562','415','Current','ENGAGE X SIFB1AL.9K15BEA','28200.00','{}'),
('959','166','563','415','Current','ADVANCE X SIFB1AL.9K15BEA','31700.00','{}'),
('960','166','563','416','Current','ADVANCE X SIFB2AL.9K15BEA','34700.00','{}'),
('961','166','564','416','Current','EVOLVE X SIFB2AL.9K15BEA','36200.00','{}'),
('962','168','567','418','Current','ADVANCE X SITSJAL.9ZE2BGA','48990.00','{}'),
('963','168','568','418','Current','EVOLVE X SITSJAL.9ZE2BGA','50990.00','{}'),
('964','168','565','417','Current','ENGAGE X SITSJAL.9ZE23GA','38990.00','{}'),
('965','168','567','417','Current','ADVANCE X SITSJAL.9ZE23GA','43490.00','{}'),
('966','168','566','417','Current','ENGAGE_PLUS X SITSJAL.9ZE23GA','40490.00','{}'),
('967','168','566','418','Current','ENGAGE_PLUS X SITSJAL.9ZE2BGA','45990.00','{}'),
('968','172','569','419','Current','N_CONNECTA X TDNAL.WT33TGA','43990.00','{}'),
('969','172','569','420','Current','N_CONNECTA X TDNAL.9T33TGA','48990.00','{}'),
('970','172','569','421','Current','N_CONNECTA X TDNNL.9T33TGA','51990.00','{}'),
('971','172','569','422','Current','N_CONNECTA X JDNNL.9T33TGA','53190.00','{}'),
('972','172','571','421','Current','TEKNA X TDNNL.9T33TGA','55990.00','{}'),
('973','172','571','422','Current','TEKNA X JDNNL.9T33TGA','57190.00','{}'),
('974','172','572','421','Current','TEKNA_PLUS X TDNNL.9T33TGA','59990.00','{}'),
('975','172','572','422','Current','TEKNA_PLUS X JDNNL.9T33TGA','61190.00','{}'),
('976','172','570','421','Current','N_TREK X TDNNL.9T33TGA','53590.00','{}'),
('977','172','570','422','Current','N_TREK X JDNNL.9T33TGA','54790.00','{}'),
('978','173','573','423','Current','N_CONNECTA X TDNAL.WT33TGA','43990.00','{}'),
('979','173','573','424','Current','N_CONNECTA X TDNAL.9T33TGA','48990.00','{}'),
('980','173','573','425','Current','N_CONNECTA X TDNNL.9T33TGA','51990.00','{}'),
('981','173','573','426','Current','N_CONNECTA X JDNNL.9T33TGA','53190.00','{}'),
('982','173','575','425','Current','TEKNA X TDNNL.9T33TGA','55990.00','{}'),
('983','173','575','426','Current','TEKNA X JDNNL.9T33TGA','57190.00','{}'),
('984','173','576','425','Past','TEKNA_PLUS X TDNNL.9T33TGA','59990.00','{}'),
('985','173','576','426','Past','TEKNA_PLUS X JDNNL.9T33TGA','61190.00','{}'),
('986','173','574','425','Current','N_TREK X TDNNL.9T33TGA','53590.00','{}'),
('987','173','574','426','Current','N_TREK X JDNNL.9T33TGA','54790.00','{}'),
('988','176','577','429','Current','Acenta X L1MT','39790.00','{}'),
('989','176','577','430','Current','Acenta X L1DCT','43090.00','{}'),
('990','176','578','429','Current','N-Connecta X L1MT','42790.00','{}'),
('991','176','578','430','Current','N-Connecta X L1DCT','46090.00','{}'),
('992','176','578','432','Current','N-Connecta X L2MT','43790.00','{}'),
('993','176','578','433','Current','N-Connecta X L2DCT','47090.00','{}'),
('994','176','577','427','Current','Acenta X L1110MT','37790.00','{}'),
('995','176','577','428','Current','Acenta X L1130MT','39290.00','{}'),
('996','176','577','431','Current','Acenta X L2130MT','40290.00','{}'),
('997','176','577','432','Current','Acenta X L2MT','40790.00','{}'),
('998','176','577','433','Current','Acenta X L2DCT','44090.00','{}'),
('999','175','579','434','Current','Acenta X L1MT','46500.00','{}'),
('1000','175','579','435','Current','Acenta X L1DCT','50300.00','{}'),
('1001','175','580','434','Current','N-Connecta X L1MT','49000.00','{}'),
('1002','175','580','435','Current','N-Connecta X L1DCT','52800.00','{}'),
('1003','175','580','436','Current','N-Connecta X L2MT','50000.00','{}'),
('1004','175','580','437','Current','N-Connecta X L2DCT','53800.00','{}'),
('1005','175','581','434','Current','Tekna X L1MT','51700.00','{}'),
('1006','175','581','435','Current','Tekna X L1DCT','55500.00','{}'),
('1007','175','581','436','Current','Tekna X L2MT','52700.00','{}'),
('1008','175','581','437','Current','Tekna X L2DCT','56500.00','{}'),
('1009','178','582','440','Current','Acenta X L2DCT','51790.00','{}'),
('1010','178','582','443','Current','Acenta X L1EV','56500.00','{}'),
('1011','178','582','444','Current','Acenta X L2EV','66500.00','{}'),
('1012','178','583','444','Current','N-Connecta X L2EV','67700.00','{\"de-CH\": \"\", \"fr-CH\": \"\", \"it-CH\": \"\"}'),
('1013','178','582','438','Current','Acenta X L2MT','47390.00','{}'),
('1014','178','582','439','Current','Acenta X L2150MT','48190.00','{}'),
('1015','178','582','441','Current','Acenta X L2170MT','48990.00','{}'),
('1016','178','582','442','Current','Acenta X L2170AT','52590.00','{}'),
('1017','178','583','439','Current','N-Connecta X L2150MT','49390.00','{}'),
('1018','178','583','440','Current','N-Connecta X L2DCT','52990.00','{}'),
('1019','178','583','441','Current','N-Connecta X L2170MT','50190.00','{}'),
('1020','178','583','442','Current','N-Connecta X L2170AT','53790.00','{}'),
('1021','177','584','445','Current','Acenta X L1MT','31990.00','{}'),
('1022','177','584','446','Current','Acenta X L1DCT','34490.00','{}'),
('1023','180','585','451','Current','Acenta X L2DCT','51790.00','{}'),
('1024','180','585','454','Current','Acenta X L1EV','56500.00','{}'),
('1025','180','585','455','Current','Acenta X L2EV','66500.00','{}'),
('1026','180','586','455','Current','N-Connecta X L2EV','67700.00','{\"fr-CH\": \"\", \"de-CH\": \"\", \"it-CH\": \"\"}'),
('1027','180','585','449','Current','Acenta X L2MT','47390.00','{}'),
('1028','180','585','450','Current','Acenta X L2150MT','48190.00','{}'),
('1029','180','585','452','Current','Acenta X L2170MT','48990.00','{}'),
('1030','180','585','453','Current','Acenta X L2170AT','52590.00','{}'),
('1031','180','586','450','Current','N-Connecta X L2150MT','49390.00','{}'),
('1032','180','586','451','Current','N-Connecta X L2DCT','52990.00','{}'),
('1033','180','586','452','Current','N-Connecta X L2170MT','50190.00','{}'),
('1034','180','586','453','Current','N-Connecta X L2170AT','53790.00','{}'),
('1035','179','587','456','Current','Acenta X L1MT','31990.00','{}'),
('1036','179','587','457','Current','Acenta X L1DCT','34490.00','{}'),
('1037','182','588','460','Current','Acenta X L1MT','29490.00','{}'),
('1038','182','588','461','Current','Acenta X L1DCT','31890.00','{}'),
('1039','182','589','460','Current','N-Connecta X L1MT','31490.00','{\"fr-CH\": \"uniquement en stock\", \"de-CH\": \"nur ab Lager\", \"it-CH\": \"solo dal stock\"}'),
('1040','182','589','461','Current','N-Connecta X L1DCT','33890.00','{\"fr-CH\": \"uniquement en stock\", \"de-CH\": \"nur ab Lager\", \"it-CH\": \"solo dal stock\"}'),
('1041','182','589','462','Current','N-Connecta X L2MT','33490.00','{\"it-CH\": \"solo dal stock\", \"de-CH\": \"nur ab Lager\", \"fr-CH\": \"uniquement en stock\"}'),
('1042','182','589','463','Current','N-Connecta X L2DCT','35890.00','{\"fr-CH\": \"uniquement en stock\", \"it-CH\": \"solo dal stock\", \"de-CH\": \"nur ab Lager\"}'),
('1043','182','588','462','Current','Acenta X L2MT','31490.00','{}'),
('1044','182','588','463','Current','Acenta X L2DCT','33890.00','{}'),
('1045','182','588','464','Current','Acenta X L1EV','43990.00','{}'),
('1046','182','588','465','Current','Acenta X L2EV','45990.00','{}'),
('1047','182','589','464','Current','N-Connecta X L1EV','45990.00','{\"de-CH\": \"nur ab Lager\", \"fr-CH\": \"uniquement en stock\", \"it-CH\": \"solo dal stock\"}'),
('1048','182','589','465','Current','N-Connecta X L2EV','47990.00','{\"it-CH\": \"solo dal stock\", \"fr-CH\": \"uniquement en stock\", \"de-CH\": \"nur ab Lager\"}'),
('1049','181','590','466','Current','Acenta X L1MT','31990.00','{}'),
('1050','181','590','467','Current','Acenta X L1DCT','34490.00','{}'),
('1051','181','591','466','Current','N-Connecta X L1MT','34490.00','{}'),
('1052','181','591','467','Current','N-Connecta X L1DCT','36990.00','{}'),
('1053','181','591','468','Current','N-Connecta X L2MT','37990.00','{}'),
('1054','181','591','469','Current','N-Connecta X L2DCT','40490.00','{}'),
('1055','181','592','466','Current','Tekna X L1MT','35990.00','{}'),
('1056','181','592','467','Current','Tekna X L1DCT','38490.00','{}'),
('1057','181','592','468','Current','Tekna X L2MT','39490.00','{}'),
('1058','181','592','469','Current','Tekna X L2DCT','41990.00','{}'),
('1059','184','593','470','Current','Acenta X L1MT','29890.00','{}'),
('1060','184','593','471','Current','Acenta X L1DCT','32290.00','{}'),
('1061','184','594','470','Current','N-Connecta X L1MT','32290.00','{\"fr-CH\": \"\", \"de-CH\": \"\", \"it-CH\": \"\"}'),
('1062','184','594','471','Current','N-Connecta X L1DCT','34690.00','{\"de-CH\": \"\", \"it-CH\": \"\", \"fr-CH\": \"\"}'),
('1063','184','594','472','Current','N-Connecta X L2MT','34290.00','{\"it-CH\": \"\", \"fr-CH\": \"\", \"de-CH\": \"\"}'),
('1064','184','594','473','Current','N-Connecta X L2DCT','36690.00','{\"it-CH\": \"\", \"de-CH\": \"\", \"fr-CH\": \"\"}'),
('1065','184','593','472','Current','Acenta X L2MT','31890.00','{}'),
('1066','184','593','473','Current','Acenta X L2DCT','34290.00','{}'),
('1067','184','593','474','Current','Acenta X L1EV','43990.00','{}'),
('1068','184','593','475','Current','Acenta X L2EV','45990.00','{}'),
('1069','184','594','474','Current','N-Connecta X L1EV','46390.00','{\"fr-CH\": \"\", \"it-CH\": \"\", \"de-CH\": \"\"}'),
('1070','184','594','475','Current','N-Connecta X L2EV','48390.00','{\"it-CH\": \"\", \"de-CH\": \"\", \"fr-CH\": \"\"}'),
('1071','183','595','476','Current','Acenta X L1MT','31990.00','{}'),
('1072','183','595','477','Current','Acenta X L1DCT','34490.00','{}'),
('1073','183','596','476','Current','N-Connecta X L1MT','34490.00','{}'),
('1074','183','596','477','Current','N-Connecta X L1DCT','36990.00','{}'),
('1075','183','596','478','Current','N-Connecta X L2MT','37990.00','{}'),
('1076','183','596','479','Current','N-Connecta X L2DCT','40490.00','{}'),
('1077','183','597','476','Current','Tekna X L1MT','35990.00','{}'),
('1078','183','597','477','Current','Tekna X L1DCT','38490.00','{}'),
('1079','183','597','478','Current','Tekna X L2MT','39490.00','{}'),
('1080','183','597','479','Current','Tekna X L2DCT','41990.00','{}');


SET FOREIGN_KEY_CHECKS=1;
